Project Progress Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

Contents

Field Description
Current Hours This column displays the labor hours spent in the current period.
Current Amount This column displays the labor or expense amount spent in the current period.
JTD Hours This column displays the job-to-date labor hours spent.
JTD Amount This column displays the job-to-date labor, overhead, or expense amount spent.
Budget Hours

This column displays the budgeted hours.

If you use Planning, your selection in Budget Source on the Budget tab determines whether budget information comes from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.

Budget Amount

This column displays the budgeted amount.

If you use Planning, your selection in Budget Source on the Budget tab determines whether budget information comes from the project budget worksheet, the associated plan's budget, or the associated plan's baseline.

% Exp

This column displays the percentage of the budget spent to date, calculated as follows:

JTD Amount / Budget Amount

% Rpt This column displays the overall percent complete. The percentage is based on cost or billing amounts, depending on your selection in Report At. This percentage is calculated based on your selection of budget source on the Budget tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
Balance Hours

This column displays the budgeted labor hours that have not been spent, calculated as follows:

Budget Hours - JTD Hours

Balance Amount

This column displays the budgeted amount that has not been spent. This amount includes both labor and expenses. This amount is calculated as follows:

Budget Amount - JTD Amount

ETC Hours This column displays the estimate to complete hours. The estimate to complete hours are the estimated additional labor hours required to complete the work.
ETC Amount This column displays the estimate to complete amount. The estimate to complete amount is the estimated additional monetary amount that is required to complete the work. This amount includes both labor and expenses.
EAC Hours This column displays the estimate at completion hours. The estimate at completion hours are the estimated total number of hours that will have been worked at the completion of the project.
EAC Amount This column displays the estimate at completion amount. This amount is the estimated total monetary amount that will have been spent at the completion of the project. It includes both labor and expenses.
Budgeted Rate This column displays the rate applied to budgeted labor hours (Budget Hours) to calculate the budgeted amount for labor.
Effective Rate

This column displays the current effective hourly rate, calculated as follows:

Job-to-date labor amount at cost rates or at billing rates / Job-to-date labor hours

% Labor Rpt This column displays the percent complete for labor. The percentage is based on cost or billing amounts, depending on your selection in Report At. This percentage is calculated based on your selection of budget source on the Budget tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
% Expense Rpt This column displays the percent complete for expenses. The percentage is based on cost or billing amounts, depending on your selection in Report At. This percentage is calculated based on your selection of budget source on the Budget tab and, if you select one of the planning budget sources, the percent complete formula specified for each of the project plans.
Project Currency Code This column displays the three-character code for the project currency.
Billing Currency Code This column displays the three-character code for the billing currency.
Functional Currency Code This column displays the three-character code for the functional currency.