Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This file contains a monthly snapshot of the project status and is updated as part of the monthly project update process. The first row of this file is an automatically updated line, contain the raw status information form the project files as well as the TID ID actuals files.  It is very important that you do not later the column order of this file!

At the request of the Division Director the PM must look at the incoming actuals, update their project files in order to reconcile the monthly and total actuals with the reported cost and copy the raw tile to the appropriate month row for the project status. The PM will then provide a short note explaining the project status as well as a mitigation strategy for high risk projects.

To copy/update the monthly status, select all columns except for the "Status Month" in the "Current Raw Data" row, right clock click and select "Copy". Select the same range of boxes on the appropriate month line, right click and choose "Paste Special", make sure the "Values" field is selected and click "Ok". This will copy the current values into the appropriate month, preserving the snapshot for that month.

...