In the Monitoring People sheet of the Project Monitoring.xlsx file, we created five tables of daily costs, one for each type of people, and we created a chart for all of these. In each table, the...

In the Monitoring People sheet of the Project Monitoring.xlsx file, we created five tables of daily costs, one for each type of people, and we created a chart for all of these. In each table, the start times were the earliest start times. As an alternative, do the following. Delete the bottom four tables. For the top table, give the user three choices for the start times: (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. Also, let the user choose one type of people to monitor: engineering, systems, purchasing, installers, or training.


You can decide on the user interface for making these choices. Based on these choices, the appropriate start times should appear in column B of the table, the body of the table should show daily usages of the type of people selected, and the chart should show these daily usages graphically. (Hint: In the formulas in the body of the table, you’ll need to refer to one of the columns in the range G6:K20. One useful way to do so is with Excel’s OFFSET function. For example, you could offset everything with respect to cell F5 or any other convenient “anchor” cell. Look up the OFFSET function in online help.)