Project Variance Visualforce Page
Using the Project Variance Visualforce page, you can compare initial planned hours against actual hours spent to determine if your project is over or under the original allowance.
For information on the fields displayed, see Project Variance Visualforce Page.
Variation At Completion
The Variation at Completion (VAC) field highlights the difference between the original number of planned project hours and the current estimate for the total hours. VAC may be a negative number when the Planned Hours field is not populated with a value, or when the current estimate for Total Hours exceeds Planned Hours.
Cut Off Date
Project variance values are calculated using a cut off date. The cut off date is determined based on whether the project has a work calendar.
| Scenario | Example Cut Off Date |
|---|---|
| Work calendar on project | The last day in the week for the work calendar is used to determine the cut off date. For instance, if today is Tuesday 5th April and the last day in the week for the project's work calendar is a Sunday, Sunday 3rd April is used as the cut off date. When today is Sunday 10th April and the last day in the week for the project work calendar is a Sunday, Sunday 10th April is used as the cut off date. |
| Work calendar not on project | The last Sunday before today's date is used as the cut off date. Today is used as the cut off date when today is Sunday. |
The time spent on a project is calculated from approved and submitted timecard hours when their week ending date is up to and inclusive of the cut off date. Timecards with a week ending date after the cut off date are excluded from the calculation even when time has been submitted and approved up to and including the cut off date.
Viewing Project Variance Values
Project variance values are calculated dynamically each time you view the project detail page.
- Click the Projects tab.
- Select the project you want to view.
- Review the values on the project's detail page. For a description of the fields, see Project Variance Visualforce Page.