Procedure

This project will present a series of problems that can be solved programmatically. For each problem, we will provide opportunities to identify key information that must be manipulated and then analyze that data to design an algorithm to solve the problem. Finally, you will implement each solution in Excel using cells to store your data. You will be encouraged to show and label intermediate steps in your solution in order to demonstrate your thought process. It is expected that you will complete this assignment by storing data in cells and using relative references $($A$3),$ absolute references $($D$$3$ or $B$$7),$ simple equations $),$ and built$-$in Excel functions $(=$SUM$($A$3$:A$7))$ to solve these problems but not macros or Visual Basic for Applications $($VBA$).$

You may assume that all programs are given the kind of data that they expect. Each problem will express the kind of data that the user will enter and you may assume that the user will listen. For instance, if the program says that "The user will enter a positive number which represents the price of an item," then you can expect that the user will enter a positive number and do not need to account for any other type of data.

Remember: think about your problem, be explicit in your algorithm design, and be specific and precise in your implemented solution. Test your code. Think about edge conditions$/$places in your solution where the program's behavior changes. If the computer doesn't do what you expect, this is your fault; this is also okay. Examine your code to make sure that your code does what your algorithm says. If you're confident that it does, examine the logic of your algorithm and see if you missed some situations or didn't fully express the solution.

Problem $1$: Age Calculator

A simple question that is asked of you throughout your life is "How old are you?" This can be solved many ways. When we're young, we just memorize it$."$I$\text{'}$m five years old!" As you age, you'll notice that the answer will more and more start with the words, "Let's see... what year is it$?"$ Because of this, we are going to be asking for a calculator that will take a date and will determine some birthday$-$related facts for someone born on that day. Your program should display their current age, the number of days until their next birthday, and their unbirthday$/$half birthday$/$the day that is half a year away from their birthday.

Implementation. Please go to the first tab, labeled Prob $1-$ Age Calculator, in the associated Excel Spreadsheet and implement your solution. You may assume that the input will be in cell B$3,$ under the label "Date of Birth." The solutions to this problem belong in B$6,$ B$9,$ and B$12$ in the formatted boxes provided.

It is STRONGLY recommended that you show and label intermediate calculations in the spreadsheet. You may store these calculations anywhere in the sheet but, remember, a solution that is not understandable isn't usable so make sure that your calculations and labels are logical$,$ understandable, and organized.

Procedure

This project will present a series of problems that can be solved programmatically. For each problem, we will provide opportunities to identify key information that must be manipulated and then analyze that data to design an algorithm to solve the problem. Finally, you will implement each solution in Excel using cells to store your data. You will be encouraged to show and label intermediate steps in your solution in order to demonstrate your thought process. It is expected that you will complete this assignment by storing data in cells and using relative references $($A$3),$ absolute references $($D$$3$ or $B$$7),$ simple equations $(=G{7}^{**}2),$ and built$-$in Excel functions $(=$SUM$($A$3$:A$7))$ to solve these problems but not macros or Visual Basic for Applications $($VBA$).$

You may assume that all programs are given the kind of data that they expect. Each problem will express the kind of data that the user will enter and you may assume that the user will listen. For instance, if the program says that "The user will enter a positive number which represents the price of an item," then you can expect that the user will enter a positive number and do not need to account for any other type of data.

Remember: think about your problem, be explicit in your algorithm design, and be specific and precise in your implemented solution. Test your code. Think about edge conditions$/$places in your solution where the program's behavior changes. If the computer doesn't do what you expect, this is your fault; this is also okay. Examine your code to make sure that your code does what your algorithm says. If you're confident that it does, examine the logic of your algorithm and see if you missed some situations or didn't fully express the solution.

Problem $1$: Age Calculator

A simple question that is asked of you throughout your life is "How old are you?" This can be solved many ways. When we're young, we just memorize it$."$I$\text{'}$m five years old!" As