Calculating time phased data in Cost

Produce time-based reports and improve productivity using time-phased data.

The Time Phased Data utility uses schedule data assigned against control accounts to distribute budgets over the duration of a project.

Once the data has been distributed, it can be used to produce time-based reports (such as S-Curves and Histograms) and will be used when calculating productivity and some forecasts. 

Dates can be entered manually or imported from a planning tool. Integration options are available in the administration module. See also Importing Time Phased Data.

Spread Time Phased Data

  1. Ensure dates have been entered, or Schedule Activities have been created and linked to Control Accounts.
  2. In the Cost Worksheet, click the Spread Time Phased Data button under Utilities.
  3. Select the relevant Control Accounts and budget types.
  4. Click Spread TPD

Tip!

Hiding the Unassigned Column in Time Phased Data Reports

The Unassigned column can affect your curve results, but you can stop this from happening by hiding the column. Note that when hidden, the unassigned values are still considered when calculating To Date amounts. To see your data, it has to be set up so that the unassigned amount is about half way or at the top of the monthly average. If the unassigned amount is nearer the value of Period 1, it is harder to see the difference.

Filtering Time Phased Data reports

You can filter the results of a Time Phased Data report. Once you’ve set up one or more filters, you can save and apply them by Control Account and Control Element