In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.
So many fields!
The PPR report contains hundreds of fields, and keeping track of them can be difficult. This section helps you get a handle on what each field means.
The first thing to understand is that many of the fields have similar names. The reason is because we using a naming schema. By understanding the schema, you can quickly narrow down the fields you are actually interested in. There are six fields in the schema. Simply substitute in the metric you are looking for (revenue, hours, etc).
- Actual X
- Actual X to date
- Projected X
- Projected X to date
- Projected X to complete
- X at completion
So what do each of these actually mean? They differ based on the date ranges that they cover. You'll see three distinct ranges.
- From start to end of project (actual, projected, actual/projected mix)
- From start to use actuals through date (actual, projected)
- From use actuals through date to end (projected)
The graphic below helps visualize them. See below the image for some real world examples of using them. ("UATD" stands for "Use Actuals Through Date")
So why do we have all the fields and why would you choose one over another? I think the best example is when you want to look at the difference between what work was expected and what work was actually done. This is what our variance report shows. For example, you might use -
- Projected X vs. Actual X. Show the variance between the work planned and the work that was actually done
- Actual X to date vs. Projected X to date. Very similar to the last example, but you only care about the variance up to a specific date.
- Projected X vs. X at completion. Show the difference between my initial plan and what I am likely to deliver.
Data Fields
Field | Field Category | Description | |
|---|---|---|---|
% Achieved Milestones | Billing Fields | Percentage of billing milestones that have been achieved | |
% Achieved Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have been achieved | |
% Calendar Days Elapsed | Task Planning Fields | Percentage of time (based on calendar days) that has elapsed since the start of the project | |
% Complete Based on Contract Revenue | Percent Complete Fields | Actual Contract Revenue to Date / Contract Revenue at Completion | |
% Complete Based on Hours | Percent Complete Fields | Actual Hours to Date / Hours at Completion | |
% Complete Based on Resource Direct Costs | Percent Complete Fields | Actual Resource Direct Cost to Date / Resource Direct Cost at Completion | |
% Complete Based on Task Hours | Percent Complete Fields | Actual Task Hours to Date / Task Hours at Completion | |
% Cost Written Down | Billing Fields | Percentage of actual disbursed costs that have been written down | |
% Elapsed | Task Planning Fields | Percentage of time (based on working days) that has elapsed since the start of the project | |
% Foregone Milestones | Billing Fields | Percentage of billing milestones that have been foregone | |
% Foregone Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have been foregone | |
% Incomplete Delivery Milestones to Date | Task Planning Fields | Percentage of delivery milestones that should have been completed to date that have not yet been completed | |
% Incomplete Tasks to Date | Task Planning Fields | Percentage of tasks that should have been completed to date that have not yet been completed | |
% Late Delivery Milestones at Completion | Task Planning Fields | Percentage of delivery milestones that actually were completed late or which are planned to be completed late | |
% Late Delivery Milestones to Date | Task Planning Fields | Percentage of delivery milestones that should have been completed already, but which have not yet been completed or which were completed late | |
% Late Issues | Issue Fields | ||
% Late Tasks at Completion | Task Planning Fields | Percentage of tasks that actually were completed late or which are planned to be completed late | |
% Late Tasks to Date | Task Planning Fields | Percentage of tasks that should have been completed already, but which have not yet been completed or which were completed late | |
% of Budgeted Billing Adjusted Revenue Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Billing Adjusted Revenue Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Chargeable Hours Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Chargeable Hours Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Client Amount Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Client Amount Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Contract Revenue Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Contract Revenue Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Disbursed Amount Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Disbursed Amount Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Expense Amount Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Expense Amount Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Hours Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Hours Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Resource Direct Cost Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Resource Direct Cost Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Budgeted Task Hours Consumed | Performance to Budget Fields | Percentage of budget consumed, using the actuals to date method | |
% of Budgeted Task Hours Remaining | Performance to Budget Fields | Percentage of budget remaining, using the actual to date method | |
% of Time Contract Value Recognized | Revenue Recognition Fields | Portion of an engagement's contract value that has already been recognized | |
% of Time Contract Value to be Recognized | Revenue Recognition Fields | Portion of an engagement's contract value that remains to be recognized | |
% Open High Priority Issues | Issue Fields | ||
% Open Issues | Issue Fields | ||
% Overbudget Tasks at Completion | Task Planning Fields | Percentage of tasks that are already or will be over budget based on actual hours plus remaining hours | |
% Overbudget Tasks to Date | Task Planning Fields | Percentage of tasks that are already or will be over budget based on actual hours plus remaining hours that should have been completed to date | |
% Time Written Down | Billing Fields | Percentage of actual time that has been written down | |
% Total Written Down | Billing Fields | Percentage of actual time and disbursed costs that have been written down | |
% Unachieved Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have not been achieved to date | |
% Unbilled Billing Adjusted Revenue | Billing Fields | Percentage of actual time that has not yet been billed | |
% Unbilled Client Amount | Billing Fields | Percentage of actual costs that have not yet been billed | |
| % Unbilled Hours | Billing Fields | Unbilled Hours / Hours at Completion | |
% Variance to Budgeted Billing Adjusted Revenue at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Chargeable Hours at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Client Amount at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Contract Revenue at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Disbursed Amount at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Expense Amount at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Hours at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Resource Direct Cost at Completion | Performance to Budget Fields | Percentage variance to budget expected, using the estimate at completion method | |
% Variance to Budgeted Task Hours at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method | |
Achieved Milestones | Billing Fields | Number of billing milestones that have been achieved | |
Achieved Milestones to Date | Billing Fields | Number of billing milestones that have been achieved to date | |
Actual Billing Adjusted % of Contract | Rate Realization Fields | ||
Actual Billing Adjusted % of Contract to Date | Rate Realization Fields | ||
Actual Billing Adjusted Rate | Rate Realization Fields | ||
Actual Billing Adjusted Rate to Date | Rate Realization Fields | ||
Actual Billing Adjusted Revenue | Performance to Budget Fields | Actual time worked, measured in billing adjusted revenue | |
Actual Billing Adjusted Revenue to Complete | Project Performance to Budget Fields | ||
Actual Billing Adjusted Revenue to Date | Performance to Budget Fields | Actual time worked to date, measured in billing adjusted revenue | |
Actual Chargeable Hours | Performance to Budget Fields | Actual time worked, measured in chargeable hours | |
Actual Chargeable Hours to Complete | Project Performance to Budget Fields | ||
Actual Chargeable Hours to Date | Performance to Budget Fields | Actual time worked to date, measured in chargeable hours | |
Actual Client Amount | Performance to Budget Fields | Actual costs expended, measured using client amount | |
Actual Client Amount to Complete | Project Performance to Budget Fields | ||
Actual Client Amount to Date | Performance to Budget Fields | Actual costs expended to date, measured using client amount | |
Actual Contract % of Standard | Rate Realization Fields | ||
Actual Contract % of Standard to Date | Rate Realization Fields | ||
Actual Contract Rate | Rate Realization Fields | ||
Actual Contract Rate to Date | Rate Realization Fields | ||
Actual Contract Revenue | Performance to Budget Fields | Actual time worked, measured in contract revenue | |
Actual Contract Revenue to Complete | Project Performance to Budget Fields | ||
Actual Contract Revenue to Date | Performance to Budget Fields | Actual time worked to date, measured in contract revenue | |
Actual Cost (ACWP) | Earned Value Fields | Actual cost (also known as Actual Cost of Work Performed); approved hours spent on task through actuals cutoff date | |
Actual Cost End Date | Activity Fields | Date of the last reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses. | |
Actual Cost Start Date | Activity Fields | Date of the first reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses. | |
| Actual Deferred Revenue | Revenue Fields | Will be null unless you bring in a row field that is at the contract line item level or higher | |
| Actual Deferred Revenue to Date | Revenue Fields | Will be null unless you bring in a row field that is at the contract line item level or higher | |
Actual Disbursed Amount | Performance to Budget Fields | Actual costs expended, measured using disbursed amount | |
Actual Disbursed Amount to Complete | Project Performance to Budget Fields | ||
Actual Disbursed Amount to Date | Performance to Budget Fields | Actual costs expended to date, measured using disbursed amount | |
Actual Expense Amount | Performance to Budget Fields | Actual costs expended, measured using expense amount | |
Actual Expense Amount to Complete | Project Performance to Budget Fields | ||
Actual Expense Amount to Date | Performance to Budget Fields | Actual costs expended to date, measured using expense amount | |
Actual Hours | Performance to Budget Fields | Actual time worked for the entire duration of a project. Useful for comparing actual against projected hours (similar to schedule variance report) | |
Actual Hours End Date | Activity Fields | Date of the last reported hours for the project. Includes unapproved (submitted) hours if the report is configured to include unapproved hours. Null if no reported hours. | |
Actual Hours Start Date | Activity Fields | Date of the first reported hours for the project. Includes unapproved (submitted) hours if the report is configured to include unapproved hours. Null if no reported hours. | |
Actual Hours to Complete | Project Performance to Budget Fields | ||
Actual Hours to Date | Performance to Budget Fields | Actual time through the Use Actuals Through Date | |
Actual ODC Revenue Amount | Revenue Fields | ||
Actual ODC Revenue Amount to Date | Revenue Fields | ||
Actual Project Margin | Profit Fields | Project profit of actual time and costs as a percentage of revenue | |
Actual Project Margin to Date | Profit Fields | Project profit of actual time and costs to date as a percentage of revenue | |
Actual Project Profit | Profit Fields | Project profit of actual time and costs; (ActualSystemRevenue) + (ActualOdcRevenueAmount) - (ActualResourceDirectCost) - (ActualExpenseAmount) | | |
Actual Project Profit to Date | Profit Fields | Project profit of actual time and costs to date; (ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate) - (ActualResourceDirectCostToDate) - (ActualExpenseAmountToDate) | |
Actual Resource Direct Cost | Performance to Budget Fields | Actual time worked, measured using resource direct cost | |
Actual Resource Direct Cost to Complete | Project Performance to Budget Fields | ||
Actual Resource Direct Cost to Date | Performance to Budget Fields | Actual time worked to date, measured using resource direct cost | |
Actual Resource Direct Rate | Rate Realization Fields | ||
Actual Resource Direct Rate to Date | Rate Realization Fields | ||
Actual Resource Margin | Profit Fields | Project profit of actual time as a percentage of revenue; | |
Actual Resource Margin to Date | Profit Fields | Project profit of actual time to date as a percentage of revenue | |
Actual Resource Profit | Profit Fields | Project profit of actual time; (ActualSystemRevenue)- (ActualResourceDirectCost) | |
Actual Resource Profit to Date | Profit Fields | Project profit of actual time to date; (ActualSystemRevenueToDate) - (ActualResourceDirectCostToDate) | |
Actual Standard Rate | Rate Realization Fields | ||
Actual Standard Rate to Date | Rate Realization Fields | ||
Actual Standard Revenue | Revenue Fields | ||
Actual Standard Revenue to Date | Revenue Fields | ||
Actual System % of Billing Adjusted | Rate Realization Fields | ||
Actual System % of Billing Adjusted to Date | Rate Realization Fields | ||
Actual System % of Contract | Rate Realization Fields | ||
Actual System % of Contract to Date | Rate Realization Fields | ||
Actual System % of Standard | Rate Realization Fields | ||
Actual System % of Standard to Date | Rate Realization Fields | ||
Actual System Rate | Rate Realization Fields | ||
Actual System Rate after ODC | Rate Realization Fields | ||
Actual System Rate after ODC to Date | Rate Realization Fields | ||
Actual System Rate to Date | Rate Realization Fields | ||
Actual System Revenue | Revenue Fields | ||
Actual System Revenue after ODC | Rate Realization Fields | (ActualSystemRevenue) + (ActualOdcRevenueAmount)- (ActualExpenseAmount) | |
Actual System Revenue after ODC % of Contract | Rate Realization Fields | ||
Actual System Revenue after ODC % of Contract to Date | Rate Realization Fields | ||
Actual System Revenue after ODC % of Standard | Rate Realization Fields | ||
Actual System Revenue after ODC % of Standard to Date | Rate Realization Fields | ||
Actual System Revenue after ODC % of System | Rate Realization Fields | ||
Actual System Revenue after ODC % of System to Date | Rate Realization Fields | ||
Actual System Revenue after ODC to Date | Rate Realization Fields | (ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate)- (ActualExpenseAmountToDate) | |
Actual System Revenue Recognized to Date | Revenue Recognition Fields | ||
Actual System Revenue to be Recognized to Date | Revenue Recognition Fields | Actual System Revenue to Date - Actual System Revenue Recognized to Date | |
Actual System Revenue to Date | Revenue Fields | ||
Actual Task Hours | Performance to Budget Fields | Actual time worked, measured in hours | |
Actual Task Hours to Date | Performance to Budget Fields | Actual time worked to date, measured in hours | |
Actual Total Revenue | Revenue Fields | (ActualSystemRevenue) + (ActualOdcRevenueAmount) | |
Actual Total Revenue to Date | Revenue Fields | (ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate) | |
Billed Billing Adjusted Revenue | Billing Fields | Actual time that has been billed, measured in billing adjusted revenue | |
Billed Client Amount | Billing Fields | Actual costs that have been billed, measured in client amount | |
| Billing Days | Hours Fields | Number of billable days. Useful when you use daily billing. | |
| Billed Hours | Billing Fields | Actual time that has been billed (T&M and NTE only) | |
Billed Milestone Amount | Billing Fields | Milestones that have been billed | |
Billing Adjusted % of Contract at Completion | Rate Realization Fields | ||
Billing Adjusted Rate at Completion | Rate Realization Fields | ||
Billing Adjusted Revenue at Completion | Performance to Budget Fields | Actual plus projected time, measured in billing adjusted revenue | |
Billing Adjusted Revenue Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in billing adjusted revenue; (BudgetedBillingAdjustedRevenueAtCompletion) - (ActualBillingAdjustedRevenueToDate), never less than zero | | |
Billing Adjusted Revenue Variance to Date | Variance Fields | Variance between actual time compared to projected time to date | |
Budgeted Billing Adjusted Revenue at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Billing Adjusted Revenue Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in billing adjusted revenue; (BudgetedBillingAdjustedRevenueAtCompletion) - (ActualBillingAdjustedRevenueToDate) | |
Budgeted Chargeable Hours at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Chargeable Hours Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in chargeable hours; (BudgetedChargeableHoursAtCompletion) - (ActualChargeableHoursToDate) | |
Budgeted Client Amount at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Client Amount Remaining | Performance to Budget Fields | Costs that have been budgeted, but not yet expended to date, measured in client amount; (BudgetedClientAmountAtCompletion) - (ActualClientAmountToDate) | |
Budgeted Contract Revenue at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Contract Revenue Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in contract revenue; (BudgetedContractRevenueAtCompletion) - (ActualContractRevenueToDate) | |
Budgeted Disbursed Amount at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Disbursed Amount Remaining | Performance to Budget Fields | Costs that have been budgeted, but not yet expended to date, measured in disbursed amount; (BudgetedDisbursedAmountAtCompletion) - (ActualDisbursedAmountToDate) | |
Budgeted Expense Amount at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Expense Amount Remaining | Performance to Budget Fields | Costs that have been budgeted, but not yet expended to date, measured in expense amount; (BudgetedExpenseAmountAtCompletion) - (ActualExpenseAmountToDate) | |
Budgeted Hours at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Hours Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in hours; (BudgetedHoursAtCompletion) - (ActualHoursToDate) | |
Budgeted Resource Direct Cost at Completion | Performance to Budget Fields | This is the same as your budget. | |
Budgeted Resource Direct Cost Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in resource direct cost; (BudgetedResourceDirectCostAtCompletion) - (ActualResourceDirectCostToDate) | |
Budgeted Task Hours at Completion | Performance to Budget Fields | Same as Planned Hours. For the active task baseline, how many hours were budgeted from day one? | |
Budgeted Task Hours Remaining | Performance to Budget Fields | Work that has been budgeted, but not yet delivered to date, measured in task hours | |
Chargeable Hours at Completion | Performance to Budget Fields | Actual plus projected time, measured using chargeable hours | |
Chargeable Hours Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in chargeable hours; (BudgetedChargeableHoursAtCompletion) - (ActualChargeableHoursToDate), never less than zero | | |
Chargeable Hours Variance to Date | Variance Fields | Variance between actual time compared to projected time to date | |
Client Amount at Completion | Performance to Budget Fields | Actual plus projected costs, measured using client amount | |
Client Amount Backlog | Backlog Fields | Costs that have been committed or budgeted, but not yet expended to date, measured in client amount; (BudgetedClientAmountAtCompletion)- (ActualClientAmountToDate), never less than zero | |
Client Amount Variance to Date | Variance Fields | Variance between actual costs compared to planned costs to date; | |
Contract % of Standard at Completion | Rate Realization Fields | ||
Contract Rate at Completion | Rate Realization Fields | ||
Contract Revenue at Completion | Performance to Budget Fields | Actual plus projected time, measured in contract revenue | |
Contract Revenue Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in contract revenue; (BudgetedContractRevenueAtCompletion) - (ActualContractRevenueToDate), never less than zero | |
Contract Revenue Variance to Date | Variance Fields | Variance between actual time compared to projected time to date; | |
Cost Performance Index | Earned Value Fields | Ratio of how much the accomplished work should have cost versus how much it actually cost; Earned value / Actual cost (greater than 1 is under budget, less than 1 is over budget) | |
Cost Variance | Earned Value Fields | Comparison of the actual cost of the work completed as compared to how much that work should have cost as measured in hours; Earned value - Actual cost (negative is over budget, positive is under budget) | |
Cost Written Down | Billing Fields | Actual costs that have been written down; (ActualDisbursedAmount) - (ActualClientAmount) | |
Delivery Milestones at Completion | Task Planning Fields | Number of delivery milestones | |
Delivery Milestones to Date | Task Planning Fields | Number of delivery milestones that should have been completed already | |
Disbursed Amount at Completion | Performance to Budget Fields | Actual plus projected costs, measured using disbursed amount | |
Disbursed Amount Backlog | Backlog Fields | Costs that have been committed or budgeted, but not yet expended to date, measured in disbursed amount; (BudgetedDisbursedAmountAtCompletion) - (ActualDisbursedAmountToDate), never less than zero | |
Disbursed Amount Variance to Date | Variance Fields | Variance between actual costs compared to planned costs to date | |
Earned Value (BCWP) | Earned Value Fields | Number of hours the project has "earned" based on percent of work completed (also known as Budgeted Cost of Work Performed); % complete X Budgeted hours | |
Expense Amount at Completion | Performance to Budget Fields | Actual plus projected costs, measured using expense amount | |
Expense Amount Backlog | Backlog Fields | Costs that have been committed or budgeted, but not yet expended to date, measured in expense amount; (BudgetedExpenseAmountAtCompletion) - (ActualExpenseAmountToDate), never less than zero | |
Expense Amount Variance to Date | Variance Fields | Variance between actual costs compared to planned costs to date | |
Foregone Milestones | Billing Fields | Billing milestones that have been manually marked as foregone | |
Foregone Milestones to Date | Billing Fields | Billing milestones to date that have been manually marked as foregone | |
Hours at Completion | Performance to Budget Fields | Actual plus projected time, measured in hours | |
Hours Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in hours; (BudgetedHoursAtCompletion) - (ActualHoursToDate), never less than zero | |
Hours Variance to Date | Variance Fields | Variance between actual time compared to projected time to date | |
Incomplete Delivery Milestones to Date | Task Planning Fields | Number of delivery milestones that should have been completed to date that have not yet been completed | |
Incomplete Tasks to Date | Task Planning Fields | Number of tasks that should have been completed to date that have not yet been completed | |
Late Delivery Milestones at Completion | Task Planning Fields | Number of delivery milestones that actually were completed late or which are planned to be completed late | |
Late Delivery Milestones to Date | Task Planning Fields | Number of delivery milestones that should have been completed already, but which have not yet been completed or which were completed late | |
Late Issues | Issue Fields | Issues with due dates in the past that are still open | |
Late Milestones | Billing Fields | ||
Late Tasks at Completion | Task Planning Fields | Number of tasks that actually were completed late or which are planned to be completed late | |
Late Tasks to Date | Task Planning Fields | Number of tasks that should have been completed already, but which have not yet been completed | |
ODC Revenue Amount at Completion | Revenue Fields | ||
Open High Priority Issues | Issue Fields | ||
Open Issues | Issue Fields | ||
Overbudget Tasks at Completion | Task Planning Fields | Number of tasks that are already or will be over budget based on actual hours plus remaining hours | |
Overbudget Tasks to Date | Task Planning Fields | Number of tasks that are already or will be over budget based on actual hours plus remaining hours that should have been completed to date | |
Planned Value (BCWS) | Earned Value Fields | Number of hours of work that should have been completed to date based on elapsed time (also known as Budgeted Cost of Work Scheduled); % elapsed X Budgeted hours | |
Project Margin at Completion | Profit Fields | Project profit of actual plus projected time and costs as a percentage of revenue | |
Project Profit at Completion | Profit Fields | Project profit of actual plus projected time and costs; (SystemRevenueAtCompletion) + (OdcRevenueAmountAtCompletion) - (ResourceDirectCostAtCompletion) - (ExpenseAmountAtCompletion) | |
Projected Billing Adjusted % of Contract | Rate Realization Fields | ||
Projected Billing Adjusted % of Contract to Complete | Rate Realization Fields | ||
Projected Billing Adjusted Rate | Rate Realization Fields | ||
Projected Billing Adjusted Rate to Complete | Rate Realization Fields | ||
Projected Billing Adjusted Revenue | Variance Fields | Projected time as planned (useful for variance analysis), measured in billing adjusted revenue | |
Projected Billing Adjusted Revenue to Complete | Performance to Budget Fields | Projected time, measured in billing adjusted revenue | |
Projected Billing Adjusted Revenue to Date | Variance Fields | Projected time as planned to date (useful for variance analysis), measured in billing adjusted revenue | |
Projected Chargeable Hours | Variance Fields | Projected time as planned (useful for variance analysis), measured using chargeable hours | |
Projected Chargeable Hours to Complete | Performance to Budget Fields | Projected time, measured using chargeable hours | |
Projected Chargeable Hours to Date | Variance Fields | Projected time as planned to date (useful for variance analysis), measured using chargeable hours | |
Projected Client Amount | Variance Fields | Projected costs as planned (useful for variance analysis), measured using client amount | |
Projected Client Amount to Complete | Performance to Budget Fields | Projected costs, measured using client amount | |
Projected Client Amount to Date | Variance Fields | Projected costs as planned to date (useful for variance analysis), measured using client amount | |
Projected Contract % of Standard | Rate Realization Fields | ||
Projected Contract % of Standard to Complete | Rate Realization Fields | ||
Projected Contract Rate | Rate Realization Fields | ||
Projected Contract Rate to Complete | Rate Realization Fields | ||
Projected Contract Revenue | Variance Fields | Projected time as planned (useful for variance analysis), measured in contract revenue | |
Projected Contract Revenue to Complete | Performance to Budget Fields | Projected time, measured in contract revenue | |
Projected Contract Revenue to Date | Variance Fields | Projected time as planned to date (useful for variance analysis), measured in contract revenue | |
Projected Cost End Date | Activity Fields | Date of the last projected expenses for the project. Null if no reported expenses. | |
Projected Cost Start Date | Activity Fields | Date of the first projected expenses for the project. Null if no reported expenses. | |
Projected Disbursed Amount | Variance Fields | Projected costs as planned (useful for variance analysis), measured using disbursed amount | |
Projected Disbursed Amount to Complete | Performance to Budget Fields | Projected costs, measured using disbursed amount | |
Projected Disbursed Amount to Date | Variance Fields | Projected costs as planned to date (useful for variance analysis), measured using disbursed amount | |
Projected Expense Amount | Variance Fields | Projected costs as planned (useful for variance analysis), measured using expense amount | |
Projected Expense Amount to Complete | Performance to Budget Fields | Projected costs, measured using expense amount | |
Projected Expense Amount to Date | Variance Fields | Projected costs as planned to date (useful for variance analysis), measured using expense amount | |
Projected Hours | Variance Fields | Projected time as planned (useful for variance analysis), measured in hours | |
Projected Hours End Date | Activity Fields | Date of the last projected hours for the project. Includes requested hours if the report is configured to include requested hours. Null if no scheduled hours. | |
Projected Hours Start Date | Activity Fields | Date of the first projected hours for the project. Includes requested hours if the report is configured to include requested hours. Null if no scheduled hours. | |
Projected Hours to Complete | Performance to Budget Fields | Projected time, measured in hours | |
Projected Hours to Date | Variance Fields | Projected time as planned to date (useful for variance analysis), measured in hours | |
Projected ODC Revenue Amount | Revenue Fields | ||
Projected ODC Revenue Amount to Complete | Revenue Fields | ||
Projected Project Margin | Variance Fields | Project profit of projected time and costs as planned as a percentage of revenue (useful for variance analysis) | |
Projected Project Margin to Complete | Profit Fields | Project profit of projected time and costs as a percentage of revenue | |
Projected Project Profit | Variance Fields | Project profit of projected time and costs as planned (useful for variance analysis); (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedResourceDirectCost) - (ProjectedExpenseAmount) | |
Projected Project Profit to Complete | Profit Fields | Project profit of projected time and costs; (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedResourceDirectCost) - (ProjectedExpenseAmount) | |
Projected Resource Direct Cost | Variance Fields | Projected time as planned (useful for variance analysis), measured using resource direct cost | |
Projected Resource Direct Cost to Complete | Performance to Budget Fields | Projected time, measured using resource direct cost | |
Projected Resource Direct Cost to Date | Variance Fields | Projected time as planned to date (useful for variance analysis), measured using resource direct cost | |
Projected Resource Direct Rate | Rate Realization Fields | ||
Projected Resource Direct Rate to Complete | Rate Realization Fields | ||
Projected Resource Margin | Variance Fields | Project profit of projected time as planned as a percentage of revenue (useful for variance analysis) | |
Projected Resource Margin to Complete | Profit Fields | Project profit of projected time as a percentage of revenue; | |
Projected Resource Profit | Variance Fields | Project profit of projected time as planned (useful for variance analysis); (ProjectedSystemRevenue)- (ProjectedResourceDirectCost) | |
Projected Resource Profit to Complete | Profit Fields | Project profit of projected time; (ProjectedSystemRevenue)- (ProjectedResourceDirectCost) | |
Projected Standard Rate | Rate Realization Fields | ||
Projected Standard Rate to Complete | Rate Realization Fields | ||
Projected Standard Revenue | Revenue Fields | ||
Projected Standard Revenue to Complete | Revenue Fields | ||
Projected System % of Billing Adjusted | Rate Realization Fields | ||
Projected System % of Billing Adjusted to Complete | Rate Realization Fields | ||
Projected System % of Contract | Rate Realization Fields | ||
Projected System % of Contract to Complete | Rate Realization Fields | ||
Projected System % of Standard | Rate Realization Fields | ||
Projected System % of Standard to Complete | Rate Realization Fields | ||
Projected System Rate | Rate Realization Fields | ||
Projected System Rate after ODC | Rate Realization Fields | ||
Projected System Rate after ODC to Complete | Rate Realization Fields | ||
Projected System Rate to Complete | Rate Realization Fields | ||
Projected System Revenue | Revenue Fields | ||
Projected System Revenue after ODC | Rate Realization Fields | (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedExpenseAmount) | |
Projected System Revenue after ODC % of Contract | Rate Realization Fields | ||
Projected System Revenue after ODC % of Contract to Complete | Rate Realization Fields | ||
Projected System Revenue after ODC % of Standard | Rate Realization Fields | ||
Projected System Revenue after ODC % of Standard to Complete | Rate Realization Fields | ||
Projected System Revenue after ODC % of System | Rate Realization Fields | ||
Projected System Revenue after ODC % of System to Complete | Rate Realization Fields | ||
Projected System Revenue after ODC to Complete | Rate Realization Fields | (ProjectedSystemRevenueToComplete) + (ProjectedOdcRevenueAmountToComplete) - (ProjectedExpenseAmountToComplete) | |
Projected System Revenue to Complete | Revenue Fields | ||
Projected Task Hours to Complete | Performance to Budget Fields | Task hours to complete, inclusive of hours remaining updates by resources | |
Projected Total Revenue | Revenue Fields | (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) | |
Projected Total Revenue to Complete | Revenue Fields | (ProjectedSystemRevenueToComplete) + (ProjectedOdcRevenueAmountToComplete) | |
Rate Loss due to Contract Terms at Completion | Rate Realization Fields | ||
Rate Loss due to Discounting at Completion | Rate Realization Fields | ||
Rate Loss due to Write Downs at Completion | Rate Realization Fields | ||
Remaining Task to Projected Hours Ratio | Task Planning Fields | Ratio that expresses how accurate scheduled hours are as compared to task hours ( less than 1 indicates overstaffing, greater than 1 indicates understaffing); (ProjectedTaskHoursToComplete) / (ProjectedHoursToComplete) | |
Resource Direct Cost at Completion | Performance to Budget Fields | Actual plus projected costs, measured using resource direct cost | |
Resource Direct Cost Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in resource direct cost; (BudgetedResourceDirectCostAtCompletion)- (ActualResourceDirectCostToDate), never less than zero | |
Resource Direct Cost Variance to Date | Variance Fields | Variance between actual time compared to projected time to date | |
Resource Direct Rate at Completion | Rate Realization Fields | ||
Resource Margin at Completion | Profit Fields | Project profit of actual plus projected time to date as a percentage of revenue | |
Resource Profit at Completion | Profit Fields | Project profit of actual plus projected time; (SystemRevenueAtCompletion) - (ResourceDirectCostAtCompletion) | |
Schedule Performance Index | Earned Value Fields | Ratio of how much work actually was accomplished versus how much should have been completed; Earned value / Planned value (greater than 1 is ahead of schedule, less than 1 is behind schedule) | |
Schedule Variance | Earned Value Fields | Comparison of the amount of work that should have been completed to date versus how much work actually was completed to date; Earned value - Planned value (positive is ahead of schedule, negative is behind schedule) | |
Standard Rate at Completion | Rate Realization Fields | ||
Standard Revenue at Completion | Revenue Fields | ||
System % of Billing Adjusted at Completion | Rate Realization Fields | ||
System % of Contract at Completion | Rate Realization Fields | ||
System % of Standard at Completion | Rate Realization Fields | ||
System Rate after ODC at Completion | Rate Realization Fields | ||
System Rate at Completion | Rate Realization Fields | ||
System Revenue after ODC % of Contract at Completion | Rate Realization Fields | ||
System Revenue after ODC % of Standard at Completion | Rate Realization Fields | ||
System Revenue after ODC % of System at Completion | Rate Realization Fields | ||
System Revenue after ODC at Completion | Rate Realization Fields | (SystemRevenueAtCompletion) - (ExpenseAmountAtCompletion) | |
System Revenue at Completion | Revenue Fields | ||
System Revenue Recognized | Revenue Recognition Fields | ||
System Revenue to be Recognized | Revenue Recognition Fields | System Revenue at Completion - System Revenue Recognized | |
Task Days | Task Planning Fields | Task Days to Date + Task Days to Complete | |
Task Days to Complete | Task Planning Fields | ||
Task Days to Date | Task Planning Fields | ||
Task Hours at Completion | Performance to Budget Fields | Actual plus projected time, measured in task hours | |
Task Hours Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in task hours; (BudgetedTaskHoursAtCompletion) - (ActualTaskHoursToDate), never less than zero | |
Task Hours Variance | Variance Fields | Variance between actual hours compared to budgeted task hours | |
Task Plan End Date | Activity Fields | Latest task end date for the project. | |
Task Plan Start Date | Activity Fields | Earliest task start date for the project. | |
Tasks at Completion | Task Planning Fields | Total number of tasks in the current task plan, not including parent or roll-up tasks | |
Tasks to Date | Task Planning Fields | Total number of tasks in the current task plan, not including parent or roll-up tasks, that should have been completed to date | |
Time Written Down | Billing Fields | Actual time that has been written down; (ActualContractRevenue) - (ActualBillingAdjustedRevenue) | |
Total Issues | Issue Fields | ||
Total Milestones to Date | Billing Fields | Billing milestones that should have been achieved to date | |
Total Revenue at Completion | Revenue Fields | (SystemRevenueAtCompletion) + (OdcRevenueAmountAtCompletion) | |
Total Revenue Recognized | Revenue Recognition Fields | ||
Total Written Down | Billing Fields | Actual time and disbursed costs that have been written down; (TimeWrittenDown) + (CostWrittenDown) | |
Unachieved Milestones to Date | Billing Fields | Billing milestones that should have been achieved to date that have not been achieved | |
Unbilled Billing Adjusted Revenue | Billing Fields | Actual time that has not yet been billed, measured in billing adjusted revenue | |
Unbilled Client Amount | Billing Fields | Actual costs that have not yet been billed, measured in client amount | |
| Unbilled Hours | Billing Fields | Actual time that has not yet been billed | |
Unbilled Milestone Amount | Billing Fields | Milestones that have not yet been billed | |
Variance to Budgeted Billing Adjusted Revenue at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (BillingAdjustedRevenueAtCompletion) - (BudgetedBillingAdjustedRevenueAtCompletion) | |
Variance to Budgeted Chargeable Hours at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (ChargeableHoursAtCompletion)- (BudgetedChargeableHoursAtCompletion) | |
Variance to Budgeted Client Amount at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (ClientAmountAtCompletion) - (BudgetedClientAmountAtCompletion) | |
Variance to Budgeted Contract Revenue at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (ContractRevenueAtCompletion) - (BudgetedContractRevenueAtCompletion) | |
Variance to Budgeted Disbursed Amount at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (DisbursedAmountAtCompletion) - (BudgetedDisbursedAmountAtCompletion) | |
Variance to Budgeted Expense Amount at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (ExpenseAmountAtCompletion) - (BudgetedExpenseAmountAtCompletion) | |
Variance to Budgeted Hours at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (HoursAtCompletion) - (BudgetedHoursAtCompletion) | |
Variance to Budgeted Resource Direct Cost at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; (ResourceDirectCostAtCompletion) - (BudgetedResourceDirectCostAtCompletion) | |
Variance to Budgeted Task Hours at Completion | Performance to Budget Fields | Variance to budget expected, using the estimate at completion method; |