The included sections describe the manual and automated steps performed to be able to display the included graph. The workbook consists of four interdependent spreadsheets, ordered with the most used first:
Read Me--containing instructions for tool usage Project Status and Forecast--main page, summarizing all detailed data from the other spreadsheets Status Reporting--used to track the percent complete for each activity in the schedule and calculate the project aggregated percent complete. Project Plan--populated when the project planning is complete, equivalent of a project baseline. Task_Export_Table--working spreadsheet for importing data from other tools such as MS Project.
Good stuff George! This brings back memories of many hours spent with schedulers to work out a solution. We got to something similar, as I recall. That was lost, so now I will keep yours handy in case the need arises again.