Progress fields

For each field listed below, the following information is given:

  • Description - the information displayed by the field when added to the spreadsheet or to a text annotation.
  • Parameters - any additional, optional parameters that you can use to modify the information that the field displays or the way in which the information is displayed.
  • Editable? - whether the field is editable when displayed in a spreadsheet column. If a field is editable in the spreadsheet, you can change the data displayed in the column to edit the properties of the corresponding bar, task or allocation.

Actual duration

Description The duration of a bar, task or allocation that has been completed by the report date of a specified progress period or today's date. You can use this field to enter actuals against tasks where resource bars are not displayed in a project. If the actual duration is edited to be greater than the planned duration, the planned duration is increased.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Dates - specify a date range if required.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the progress that was completed within that progress period or a cumulative amount, ie all progress that has been completed up to the end of the progress period.
  • Rolled up values - select this check box to display rolled-up values for parent tasks in terms of working days, or clear the check box to display rolled-up values for parent tasks in terms of elapsed days.
  • Override time unit - the time unit in which to display the information.
Editable? Yes

Actual duration vs planned

Description The difference between the duration of a bar, task or allocation that has been completed by the report date of a specified progress period or today's date and the planned actual duration according to the specified baseline.
Parameters
  • Data - the baseline against which you want to compare the live data.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Override time unit - the time unit in which to display the information.
Editable? No

Actual percent complete (APC)

Description The percentage of a task that is complete by the report date of a specified progress period or today's date. Note that this field ignores any progress that has been recorded after the specified report date (in contrast to the Percent Complete field, which includes all progress regardless of report date).
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Dates - specify a date range if required.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Use period date - if you specify a progress period, whether to calculate the value up to the report date of the selected progress period, or up to the last task section to be completed in the selected progress period. The latter setting gives more accurate results if you have not straightened your progress lines by rescheduling.
  • Measure of progress - whether you want progress to be calculated according to duration percentage complete, overall percentage complete or cost percentage complete.
  • Cost centre - the cost centre about which you want to display information.
Editable? No

Actual task work

Description

The amount of work (as specified in the Effort & Modelling section of the Task tab of the Bar and Task Properties dialog) that has been completed against a task by the report date of a specified progress period or today's date.

 

This information is used when you model consumable resources using the Quantity From Task modelling method, when you model permanent resources using the Work From Task modelling method and when you model tasks in terms of task work without using resources.

 

For more information, refer to Quantity From Task modelled consumable resources, Work From Task modelled permanent resources and Modelling tasks in terms of task work without using resources.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Work details - whether to display just the amount of work (for example 25.00), just the name of the unit in which the work is measured (for example Litre) or both the amount of work and the work unit (for example 25.00 Litre).
  • Work unit - whether you want to display task work that has been measured using any work unit, or only task work that has been measured using a specific work unit.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the progress that was completed within that progress period or a cumulative amount, ie all progress that has been completed up to the end of the progress period.
Editable? Yes

Cost percent complete

Description The percentage of a bar, task or allocation's cost that has been completed by the report date of a specified progress period or today's date.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the cost that was completed within that progress period or a cumulative amount, ie all cost that has been completed up to the end of the progress period.
Editable? No

Distributed average % complete

Description

The position at which the progress line is drawn against a summary or expanded task, given as a percentage of the overall duration of the summary or expanded task; only makes sense when applied to summary or expanded tasks.

 

Progress on expanded tasks, summary tasks and hammocks

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? No

Duration percent complete

Description The percentage of a bar, task or allocation's duration that has been completed by the report date of a specified progress period or today's date.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the duration that was completed within that progress period or a cumulative amount, ie all duration that has been completed up to the end of the progress period.
Editable? No

Duration remaining

Description The duration of a bar, task or allocation's duration that remains to be completed.
Parameters
  • Data - the baseline against which you want to compare the live data.
  • Dates - specify a date range if required.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Rolled up values - select this check box to display rolled-up values for parent tasks in terms of working days, or clear the check box to display rolled-up values for parent tasks in terms of elapsed days.
  • Override time unit - the time unit in which to display the information.
Editable? Yes

Effort percent complete

Description The percentage of a bar, task or allocation's effort that has been completed by the report date of a specified progress period or today's date.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the effort that was completed within that progress period or a cumulative amount, ie all effort that has been completed up to the end of the progress period.
Editable? No

Original duration

Description

The duration of a task before any progress has been applied - the duration between the Original start and the Original finish fields. If the duration of a task is changed before any progress has been applied, this field is updated automatically to reflect the new duration; once progress is applied to a task, this field no longer changes, even if the duration of the task does, unless the Original start or Original finish fields are edited.

 

If progress has been applied to a task and the progress is subsequently removed, this field is used to set the resulting duration of the task.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Rolled up values - select this check box to calculate this field for parent tasks by summing the original durations of the child tasks, or clear the check box to calculate this field for parent tasks as the difference between the start and finish dates of the parent task.

    Selecting this check box calculates this field in the most accurate way; clearing the check box calculates this field in the same way as it is calculated in Primavera software, resulting in matching values between Powerproject and Primavera software.
  • Override time unit - the time unit in which to display the information.
Editable? No

Original duration percent complete

Description

The percentage of a task's original duration that has been completed.

 

(Original duration - Duration remaining) / Original duration.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Rolled up values - select this check box to calculate this field for parent tasks using the summed original durations and the summed remaining durations of the child tasks, or clear the check box to calculate this field for parent tasks using the remaining duration of the parent task - ie the difference between the progress date and the finish date of the parent task.

    Selecting this check box calculates this field in the most accurate way; clearing the check box calculates this field in the same way as it is calculated in Primavera software, resulting in matching values between Powerproject and Primavera software.
Editable? No

Original finish

Description

This field is kept in step with the finish date of tasks until a task is started, at which point it is fixed at the finish date of the task immediately before progress was entered. Once a task is in progress or completed, you can edit this field in the spreadsheet if required.

 

This field is calculated for summary tasks, expanded tasks and hammocks, displaying the latest original finish date of the tasks within the summary group, chart or hammock. This field is not editable for summary tasks, expanded tasks and hammocks.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? Yes (once a task is in progress or completed, but not for summary tasks, expanded tasks or hammocks).

Original start

Description

This field is kept in step with the start date of tasks until a task is started, at which point it is fixed at the start date of the task immediately before progress was entered. Once a task is in progress or completed, you can edit this field in the spreadsheet if required.

 

This field is calculated for summary tasks, expanded tasks and hammocks, displaying the earliest original start date of the tasks within the summary group, chart or hammock. This field is not editable for summary tasks, expanded tasks and hammocks.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? Yes (once a task is in progress or completed, but not for summary tasks, expanded tasks or hammocks).

Overall percent complete

Description

The overall percentage complete progress of a task that has been completed by the report date of a specified progress period or today's date.

 

If you configure a spreadsheet column to display the overall percentage complete value of tasks for a specific progress period, the actual cost of a task is updated automatically each time you use this column to update the task’s overall percentage complete value.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Show distributed average for charts/summaries - whether you want to display a progress value for expanded and summary tasks that takes into account how the progress is distributed within the subchart or summary group (a distributed average figure, which matches precisely the shading on expanded and summary tasks), or a simpler value that indicates the percentage of progress that has been completed without taking into account how the progress is distributed throughout the subchart or summary group.
  • Progress period - the progress period about which you want to display information.
  • Cumulative - if you specify a progress period, whether to display the progress that was completed within that progress period or a cumulative amount, ie all progress that has been completed up to the end of the progress period.
Editable? Yes

Overall percent weighting

Description

A factor by which the overall percentage complete progress on a task is rolled up onto its parent task. The overall percentage complete progress for each task is multiplied by the task's weighting when the progress is rolled up to the parent task.

 

The overall percent weighting is initially set to be the task's original duration in hours. For example, a task with an original duration of 7h will have a weighting of 7; a task with an original duration of 75h will have a weighting of 75; and so on. Milestones are the exception: they are assigned a weighting of 1. This calculated value appears in the Calculated weight field, in the 'Progress' fields on the Task tab of the Bar and Task Properties dialog.

 

If you want to override the weighting with your own value, enter it in this field - reduce the weighting to indicate that the task should contribute less towards the overall percent complete of its parent task, or increase it to indicate that the task should contribute more. This value then appears in the Calculated weight field, and does not change, even if the duration of the task changes.

 

If you have manually edited the weighting of a task and subsequently want to revert to its weighting being calculated automatically, enter '1.00' in this field. The weighting will then be calculated automatically once more, according to its original duration in hours, and this value will appear in the Calculated weight field. If you enter '1.00' in this field, the weighting is set instantly to be the task's original duration - so the field will never display '1.00', except for milestones.

 

Calculating progress on parent tasks according to overall percentage complete

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? Yes

Percent complete

Description The percentage of a bar, task or allocation's duration that has been completed. You can specify whether this field relates to overall percentage complete or duration percentage complete, using the Duration percent complete and Overall percent complete radio buttons on the Progress tab of the Options dialog.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Show distributed average for charts/summaries - whether you want to display a progress value for expanded and summary tasks that takes into account how the progress is distributed within the subchart or summary group (a distributed average figure, which matches precisely the shading on expanded and summary tasks), or a simpler value that indicates the percentage of progress that has been completed without taking into account how the progress is distributed throughout the subchart or summary group.
Editable? Yes

Planned actual duration

Description In the live data or in a specified baseline, the bar, task or allocation duration that is planned to be complete by the report date of a specific progress period or today's date.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Override time unit - the time unit in which to display the information.
Editable? No

Planned actual task work

Description

The amount of work (as specified in the Effort & Modelling section of the Task tab of the Bar and Task Properties dialog) that has been completed against a task by the report date of a specified progress period or today's date in the specified baseline. If no baseline is specified, this field displays the number of task work units that have been completed in the live data.

 

This information is used when you model consumable resources using the Quantity From Task modelling method, when you model permanent resources using the Work From Task modelling method and when you model tasks in terms of task work without using resources.

 

For more information, refer to Quantity From Task modelled consumable resources, Work From Task modelled permanent resources and Modelling tasks in terms of task work without using resources.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Work details - whether to display just the amount of work (for example 25.00), just the name of the unit in which the work is measured (for example Litre) or both the amount of work and the work unit (for example 25.00 Litre).
  • Work unit - whether you want to display task work that has been measured using any work unit, or only task work that has been measured using a specific work unit.
Editable? Yes

Planned duration remaining

Description In the live data or in a specified baseline, the bar, task or allocation duration that is planned to remain to be completed by the report date of a specific progress period or today's date.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Override time unit - the time unit in which to display the information.
Editable? No

Planned percent complete (PPC)

Description The percentage complete that a task is planned to be by the report date of a specified progress period, or by today's date, either in the live data or a specified baseline.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Dates - specify a date range if required.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Show distributed average for charts/summaries - whether you want to display a progress value for expanded and summary tasks that takes into account how the progress is distributed within the subchart or summary group (a distributed average figure, which matches precisely the shading on expanded and summary tasks), or a simpler value that indicates the percentage of progress that has been completed without taking into account how the progress is distributed throughout the subchart or summary group.
  • Progress period - the progress period about which you want to display information.
  • Use period date - if you specify a progress period, whether to calculate the value up to the report date of the selected progress period, or up to the last task section to be completed in the selected progress period. The latter setting gives more accurate results if you have not straightened your progress lines by rescheduling.
  • Measure of progress - whether you want progress to be calculated according to duration percentage complete, overall percentage complete or cost percentage complete.
  • Cost centre - the cost centre about which you want to display information.
Editable? No

Planned percent complete variance

Description The difference between the percentage complete in the specified baseline and the percentage complete in the live data, by the report date of a specified progress period, or by today's date.
Parameters
  • Data - the baseline against which you want to compare the live data.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Use period date - if you specify a progress period, whether to calculate the value up to the report date of the selected progress period, or up to the last task section to be completed in the selected progress period. The latter setting gives more accurate results if you have not straightened your progress lines by rescheduling.
  • Measure of progress - whether you want progress to be calculated according to duration percentage complete, overall percentage complete or cost percentage complete.
  • Cost centre - the cost centre about which you want to display information.
Editable? No

Planned task work remaining

Description

The amount of work (as specified in the Effort & Modelling section of the Task tab of the Bar and Task Properties dialog) that has yet to be completed against a task by the report date of a specified progress period or today's date in the specified baseline. If no baseline is specified, this field displays the number of task work units that have yet to be completed in the live data.

 

This information is used when you model consumable resources using the Quantity From Task modelling method, when you model permanent resources using the Work From Task modelling method and when you model tasks in terms of task work without using resources.

 

For more information, refer to Quantity From Task modelled consumable resources, Work From Task modelled permanent resources and Modelling tasks in terms of task work without using resources.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Work details - whether to display just the amount of work (for example 25.00), just the name of the unit in which the work is measured (for example Litre) or both the amount of work and the work unit (for example 25.00 Litre).
  • Work unit - whether you want to display task work that has been measured using any work unit, or only task work that has been measured using a specific work unit.
Editable? Yes

Process state

Description Whether a bar, task or allocation is not started, in progress, or complete. 'Not Started' is displayed if a task has no progress. 'In Progress' is displayed if a task has progress, but is less than 100% complete. 'Complete' is displayed if a task is 100% complete.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? No

Progress at period

Description The progress of a task, in percentage terms, at the report date of a specified progress period, or at today's date. If a task has been marked as 100% complete, this field displays 100% for all progress periods later than the one in which the task was completed.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
Editable? No

Slip

Description

For tasks, slip is the difference between the report date of a specified progress period and the start or resume date of a task. A positive value indicates that work is ahead of schedule; a negative value indicates that work is behind schedule. For summary and expanded tasks, slip is calculated as being the difference between the report date and the task's effective progress date. The effective progress date for a summary or expanded task is calculated from the task's percentage complete and duration. The percentage complete for a summary or expanded task is calculated as the total actual duration of the child tasks, divided by the total duration of the child tasks.

 

If a summary or expanded task contains a gap between the last completed work and the work that remains to be completed and if the report date is located at some point within this gap, the Slip field for summary and expanded tasks shows zero.

 

Monitoring task slippage.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Progress period - the progress period about which you want to display information.
  • Override time unit - the time unit in which to display the information.
Editable? No

Task work remaining

Description

The amount of work (as specified in the Effort & Modelling section of the Task tab of the Bar and Task Properties dialog) remaining to be completed on a task.

 

This information is used when you model consumable resources using the Quantity From Task modelling method, when you model permanent resources using the Work From Task modelling method and when you model tasks in terms of task work without using resources.

 

For more information, refer to Quantity From Task modelled consumable resources, Work From Task modelled permanent resources and Modelling tasks in terms of task work without using resources.

Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
  • Work details - whether to display just the amount of work (for example 25.00), just the name of the unit in which the work is measured (for example Litre) or both the amount of work and the work unit (for example 25.00 Litre).
  • Work unit - whether you want to display task work that has been measured using any work unit, or only task work that has been measured using a specific work unit.
Editable? Yes

User percent complete

Description A percent complete that is independent of the actual duration, cost or effort that has been completed on a task or allocation.
Parameters
  • Data - whether you want to display information relating to the live data or to a specific baseline.
  • Specific task - specify specific task(s) on a multi-task bar to which you want the field to refer if required.
Editable? Yes