In the Monitoring Costs sheet of the Project Monitoring.xlsx file, we created two tables of daily costs, one where all activities start at their earliest start times and one where they start at their...

In the Monitoring Costs sheet of the Project Monitoring.xlsx file, we created two tables of daily costs, one where all activities start at their earliest start times and one where they start at their latest start times. Then we created a single chart for both of these. As an alternative, do the following. Delete the bottom table (the one that uses latest start times).

For the top table, give the user three choices: (1) the start times in column B can be the earliest start times, (2) the start times can be halfway between the earliest and latest start times, and (3) the start times can be the latest start times. Implement this so that the user can input a 1, 2, or 3 in some (currently unused) cell to make the choice. Based on this input, the appropriate start times should appear in the table (from the use of IF formulas), and the chart should show the associated daily costs graphically. (If you know how, you could also let the user make the choice from one of three radio buttons.)