Each project will have a sub-folder in the TID-ID folder in smart sheets. In this folder will be 4 files:

  • Project Name Project
  • Project Name Tracking
  • Project Name Actuals
  • Project Name Dashboard
  • Project Name Report
  • Project Name Risk Registry
  • Project Name PM Scoring

The Project and Tracking file will be used to plan and track the progress of the project. The Risk Registry and PM Scoring files are part of the Conduct Of Project Management process. The use of these files can be found here in the COPM document. All four of these files need to be created and maintained as part of your role as project manager.

The Actuals file is used for generating the Report file which compares each resource's earned value to the actual charges generated by the resource.

The Dashboard file is an overview of the project.

The sequence of events which need to be executed when setting up a project are:

  1. Have Stephen or Ryan create you a new project. Email them the project name and information about which program this project is part of, the name of the PM, TL, and PE.
  2. Edit the Project file adding a line for each M&S item as well as each labor task. See the information below about the use of each column.
    1. It is up to you to ensure the equations in the parent and task lines are correct. You can either copy the example lines or use the Project Update Script to ensure the fields are correct.
  3. Run the Project Update Script which will ensure the internal formatting and equations are correct in the Project file.

Descriptions of File Structures




  • No labels