Kikisoblu makes the finest Duwamish Fry Bread in the greater Seattle area. Her family has passed down the recipe for generations and it is truly delicious. Recently she has expanded to a unique catering business which supports film production crews working in Vancouver. Kikisoblu has partnered with her friend, Daanis, to facilitate the cross-border business. Daanis, a Canadian citizen and resident, makes the four hour round trip drive to pick up the film production crew orders. As the business grows, Kikisoblu and Daanis want to monitor the activity year-over-year activity to determine whether or not Daanis may be considered a U.S. Resident under the Substantial Presence Test. As such, they have asked you to prepare an automated spreadsheet model to indicate when Daanis may meet the test requirements.\ \ Required:\ Determine the Number of Days based on the expected Trip Made for each year using the COUNTIF formula\ Calculate the Days by applying the Substantial Presence Test as a formula referenced to the Number of Days. Hint: use the ROUND function for whole days\ Determine Test Met leveraging an IF formula\ Calculate the Days Left using an IF formula. Hint: Days Left may not be negative.