Earned value 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 cost (AC)
Description |
The total cost of work done by each assigned resource on a task by the report date of a specified progress period, or by today's date, plus any fixed costs.
Also known as 'actual total cost' and 'spent cost'. |
Parameters |
|
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 by today's date. |
Parameters |
|
Editable? | No |
Budget at completion (BAC)
Description |
The planned cost of a task, according to a baseline. When you add this field to the spreadsheet, the Table Definition dialog configures the field to display information from the current baseline by default; compare this to the Forecast at completion field, which is configured to display information from the live data by default.
Also known as 'baseline (total) cost', 'budgeted cost' and 'planned cost'. |
Parameters |
|
Editable? | No |
Cost performance index (CPI)
Description |
The ratio between the earned value and the actual cost of a task to the report date of a specified progress period, or to today's date, according to a specified baseline.
EV / AC |
Parameters |
|
Editable? | No |
Cost variance (CV)
Description |
The difference between the budgeted cost of the work of a task and the cost of actual work performed, to the report date of a specified progress period, or to today's date, according to a specified baseline. This field provides you with a measure of slippage and of changes in resource assignments and costs.
EV - AC |
Parameters |
|
Editable? | No |
Cost variance percent (CV%)
Description |
The cost variance as a percentage of the earned value, to the report date of a specified progress period, or to today's date, according to a specified baseline.
(CV / EV) * 100 |
Parameters |
|
Editable? | No |
Earned value (EV)
Description |
Given a task's actual percentage complete in the live data and its total planned costs according to a specified baseline, the amount of money that the task has cost by today's date or by the report date of a specified progress period. From a contractor's point of view, this is the 'earned value' of a task, as it represents its chargeable income.
Also known as 'achieved cost'.
APC * BAC |
Parameters |
|
Editable? | No |
Estimate at completion (EAC)
Description |
An estimate of the total task cost, based on current progress, to the report date of a specified progress period, or to today's date, according to a specified baseline.
(AC / EV) * BAC |
Parameters |
|
Editable? | No |
Estimated actual cost
Description |
An estimate of the total cost of a task (assuming that it finishes on budget), to the report date of a specified progress period, or to today's date, according to a specified baseline.
AC + (BAC - EV) |
Parameters |
|
Editable? | No |
Forecast at completion (FAC)
Description | The planned cost of a task, according to the live data. When you add this field to the spreadsheet, the Table Definition dialog configures the field to display information from the live data by default; compare this to the Budget at completion field, which is configured to display information from the current baseline by default. |
Parameters |
|
Editable? | No |
Planned percent complete (PPC)
Description |
Given the report date of a progress period or today's date, the percentage complete that a task is planned to be, according to a specified baseline. You can use this field to see what the progress for a task would be if the project was completely on track.
Assuming that this field uses today's date rather than the report date of a progress period, the formula is as follows:
((Today's date - Start date in baseline) / (Finish date in baseline - Start date in baseline)) * 100 |
Parameters |
|
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 |
|
Editable? | No |
Planned value (PV)
Description |
Given a task's planned percentage complete and planned cost according to a specified baseline, the amount that the task should have earned/cost by today's date or by the report date of a specified progress period.
Also known as 'baseline elapsed cost' and 'schedule earned value'.
PPC * BAC |
Parameters |
|
Editable? | No |
Schedule performance index (SPI)
Description |
A measure of a project's schedule efficiency: the ratio of earned value to planned value. In other words, the amount that a task has earned/cost, divided by the amount that it should have earned/cost, to the report date of a specified progress period, or to today's date, according to a specified baseline. A schedule performance index greater than 1 indicates a favourable position; a schedule performance index lower than one indicates an unfavourable one.
EV / PV |
Parameters |
|
Editable? | No |
Schedule variance (SV)
Description |
The difference between the cost of work that a specified baseline said would be done and the cost of work that has been done in the live data, to the report date of the specified progress period or to today's date. If negative, the task is ahead of schedule; if positive, it has slipped.
EV - PV |
Parameters |
|
Editable? | No |
Schedule variance percent (SV%)
Description |
SV as a percentage of PV.
(SV / PV) * 100 |
Parameters |
|
Editable? | No |
Total cost variance
Description |
The difference between the estimated cost of work in a specified baseline and the actual cost of work in the live data.
FAC - BAC |
Parameters |
|
Editable? | No |
Total cost variance percent
Description |
The ratio (percentage) between the estimated cost of work in a specified baseline and the actual cost of work in the live data.
(FAC / BAC) * 100 |
Parameters |
|
Editable? | No |