Project Planning Performance Columns & Groups Tab

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

For each plan, Vantagepoint provides a summary section. The contents of those sections depend on the following:

• Which column the data corresponds to: Planned, Baseline, or EAC.
• Whether you select Billing or Cost under When Cost and Billing are Planned, Use on the Options tab.

Grouping and Sorting

Use the grouping and sorting fields to specify the order in which data displays on the report. The sequence in which the selected criteria are listed on the grid determines which sort is applied first. For details, see Grouping and Sorting.

Columns

Field	Description
Resource	For labor, this column displays the employee number or the generic resource identifier. For consultants and expenses, this column displays the account name.
Vendor Name	This column displays the name of the vendor associated with expenses.
Planned	This column displays the planned hours or amount.
JTD	This column displays the actual job-to-date (JTD) hours or amount.
ETC	This column displays the estimate-to-complete (ETC) hours or amount. This is the estimate of the remaining labor hours or amount needed to complete the work, as of the current date.
EAC	This column displays the estimate-at-completion (EAC) hours or amount. This is the current estimate of the total amount or the number of hours that will have been spent or worked at the completion of the plan. Vantagepoint calculates the EAC hours or amount as follows: JTD + ETC.
Baseline	This column displays the hours or amount in the baseline version of the plan.
Plan - EAC	This column displays the variance between the planned hours or amount and the EAC hours or amount.
Plan - JTD	This column displays the variance between the planned hours or amount and the JTD hours or amount.
Baseline - JTD	This column displays the variance between the hours or amount in the baseline version of the plan and the JTD hours or amount.
EAC Multiplier	This column displays the EAC multiplier for cost. Vantagepoint calculates this multiplier for cost as follows: (Direct labor fee / EAC labor cost The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines. Note:This column will be blank for a plan if the budget type for the plan is Billing or if it is Cost and Billing and you select Billing in For Plans Budgeted at Cost and Billing, Use on the Options tab.
Budget Multiplier	This column displays the estimate at budget multiplier for cost or billing. Vantagepoint calculates this multiplier for cost as follows: Compensation fee / EAC cost Vantagepoint calculates this multiplier for billing as follows: Compensation fee / EAC billing The compensation fee is calculated from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Planned Multiplier	This column displays the planned multiplier for cost or billing. The planned multiplier helps you evaluate how much revenue a plan will return per unit of labor cost or billing. Vantagepoint calculates this multiplier for cost as follows: (Compensation fee + Consultant fee + Reimbursable allowance) - (Direct expenses + Reimbursable expenses) / Planned labor cost Vantagepoint calculates this multiplier for billing as follows: (Compensation fee + Consultant fee + Reimbursable allowance) - (Direct expenses + Reimbursable expenses) / Planned labor billing The fee and reimbursable allowance values come from the fee entries on the Project Review form of the Projects hub. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines.
Target Multiplier	This column displays the organization's target multiplier for cost or billing. The report displays this multiplier only in the total line for each plan. It is not displayed for detail lines. Note: In the current version of Vantagepoint, you cannot specify target multipliers for billing, so this column will be blank for a plan if the budget type for the plan is Billing or if it is Cost and Billing and you select Billing in For Plans Budgeted at Cost and Billing, Use on the Options tab.
+ Manage Columns	Click this link to open the Select Columns dialog box to add or remove columns in the Columns grid.
+ New Calculation	Click this link to open the Calculated Fields dialog box to add a calculated field of your own design to the report.

Other

Use this section to apply formatting options to the groupings displayed on the report.

Field	Description
Indent First Column	To indent the first report column, enter the size of the indent in inches or millimeters. (You select the unit of measure on the Layout tab.)
Indent for Each Group	To indent each group, enter the size of the indent in inches or millimeters. (You select the unit of measure on the Layout tab.)
Show Totals on Header	Select this check box to display totals in the header row for each group rather than at the end of the group. This check box is enabled only if you are grouping by at least one field.
Hide Single Line Totals	Select this check box to not display group totals if the group contains only one detail line. This check box is enabled only if you are grouping by at least one field and when the Show Totals on Header check box is cleared.
Hide Document Map	Select this check box if you do not need to display the document map information on your report or your Excel file export of the report. This controls whether the outline is exported to Excel when you download to Excel.