Spreadsheet Pane Column Definitions
The Spreadsheet pane of the Project view displays a set of standard columns.
Use the Insert Column dialog box and the Edit Column dialog box to change fields in the Spreadsheet pane.
| Column | Description | Formula |
|---|---|---|
| % Complete | This column displays the manually entered percent complete used to calculate earned value for work packages with a progress technique of Percent Complete. | N/A |
| % Spent | This column displays the percentage of the forecast spent. |
(Actuals / BAC) * 100 |
| Actual Finish | This column displays the actual finish date of the control account or work package. | N/A |
| Actual Rate | This column displays the actual rate. |
Actuals / Actuals Hours |
| Actual Start | This column displays the actual start date of the control account or work package. | N/A |
| Actuals | This column displays the total actual currency value of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Apportioned CaWP Uid | This column displays the UID for the work package stored in the Apportioned to field. | N/A |
| Apportioned to | This column displays the work package to which the budget for the referenced work package is apportioned. | N/A |
| Assignment % Complete | This column displays the percentage of work that has been completed for the Earned Value class to which the resource is assigned. | N/A |
| BAC | This column displays the budget at completion or the resource total. | N/A |
| Baseline Finish | This column displays the baseline finish date that defines the last date of the control account or work package. | N/A |
| Baseline Start | This column displays the baseline start date that defines the initial status date for the control account or work package. | N/A |
| Budget | This column displays the total currency budget value of the control account or work package. The Update Totals utility populates the value in the column. | N/A |
| Budget Rate | This column displays the budget rate. |
Budget / Budget Hours |
| Ca[1-3]Id | This column displays the control account field names. | N/A |
| Calculated % Complete | This column displays the percentage of the work that has been completed, which is calculated using the formula Earned/BAC * 100. The value in the column is populated when you run the Calculate Progress process or when you manually edit or create the Earned Value class of a resource assignment and run the Update Totals process. |
(Earned / BAC) * 100 |
| CAM | This column displays the Control Account Manager (CAM) code attached to the control account. | N/A |
| CAWPUid | This is used internally by Cobra. | N/A |
| CI Batch | This is used internally by Cobra. | N/A |
| Class | This column displays the class associated with the resource. | N/A |
| Class Description | This column displays a brief description of the class associated with the resource. | N/A |
| Control Account Codes [1-9] | This column displays the control account codes. | N/A |
| CPI | This column displays the Cost Performance Index, which is an index of the contract performance. |
Earned / Actuals |
| CPI Performance | This column displays the CPI Performance. |
Actuals/ Earned |
| Current Period Actuals | This column displays the current period actual currency value of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Current Period Budget | This column displays the current period budget value of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Current Period Hours Actuals | This column displays the current period actuals value in hours of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Current Period Hours Budget | This column displays the current period budget value in hours of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Current Period Hours Progress | This column displays the current period earned value in hours of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Current Period Progress | This column displays the current period earned value of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| CV | This column displays the Cost Variance in dollars. |
Earned - Actuals |
| CV % | This column displays the Cost Variance percentage. |
((Earned - Actuals) / Earned) * 100 |
| Description | This column displays a brief description of the control account or work package. | N/A |
| EAC | This column displays the total Estimate At Complete currency value based on the cost set EAC. The Update Totals utility populates the value in the table. | N/A |
| Early Finish | This column displays the early finish date for the control account or work package. | N/A |
| Early Start | This column displays the early start date for the control account or work package. | N/A |
| Forecast Finish | This column displays the forecast finish date of the control account or work package. | N/A |
| Forecast Start | This column displays the initial status date for the control account or work package. | N/A |
| Hours % Complete | This column displays the percentage of the work that has been completed. |
(Earned Hours / BAC Hours) * 100 |
| Hours % Spent | This column displays the percentage of the budget spent. |
(Actuals Hours / BAC Hours) * 100 |
| Hours Actuals | This column displays the total actual values in hours. | N/A |
| Hours BAC | This column displays the budget at completion in hours. | N/A |
| Hours Budget | This column displays the budget values in hours. | N/A |
| Hours CPI | This column displays the Cost Performance Index in hours. |
Earned Hours / Actuals Hours |
| Hours CPI Performance | This column displays the CPI Performance in hours. |
Actuals Hours/Earned Hours |
| Hours CV | This column displays the Cost Variance in hours. |
Earned Hours - Actuals Hours |
| Hours CV % | This column displays the Cost Variance percentage. |
((Earned Hours - Actuals Hours) / Earned Hours) * 100 |
| Hours EAC | This column displays the total Estimate At Complete currency value in hours. | N/A |
| Hours iEAC | This column displays the independent Estimate At Complete in hours. |
Actuals Hours + ((1 / CPI Hours) * (BAC Hours - Earned Hours)) |
| Hours iEAC2 | This column displays the independent Estimate At Complete in hours. |
Actuals Hours + ((1 / (CPI Hours * SPI Hours)) * (BAC Hours - Earned Hours)) |
| Hours Progress | This column displays the total earned currency value in hours. | N/A |
| Hours SPI | This column displays the Schedule Performance Index (SPI) in hours. |
Earned Hours / Budget Hours |
| Hours SV | This column displays the Schedule Variance (SV) in hours. |
Earned Hours - Budget Hours |
| Hours SV % | This column displays the Schedule Variance (SV) percentage. |
((Earned Hours - Budget Hours) / Budget Hours) * 100 |
| Hours TCPIBAC | This column displays the To Complete Performance Index for the budget at complete in hours. |
(BAC Hours - Earned Hours) / (BAC Hours - Actuals Hours) |
| Hours TCPIEAC | This column displays the To Complete Performance Index for the projected estimate at complete in hours. |
(BAC Hours - Earned Hours) / (EAC Hours - Actuals Hours) |
| Hours VAC | This column displays the Variance At Complete (VAC) in hours. |
BAC Hours - EAC Hours |
| Hours VAC % | This column displays the Variance At Complete (VAC) percentage. |
((BAC Hours - EAC Hours) / BAC Hours) * 100 |
| Hours Variance | This column displays the Variance in hours. |
Budget Hours - Actuals Hours |
| iEAC | This column displays the independent Estimate At Complete. |
Actuals + ((1 / CPI) * (BAC - Earned)) |
| iEAC2 | This column displays the independent Estimate at Complete. |
Actuals + ((1 / (CPI * SPI)) * (BAC - Earned)) |
| Last Update | This column displays the date when the control account or work package details were last updated. | N/A |
| Late Finish | This column displays the late finish date for the control account or work package. | N/A |
| Late Start | This column displays the late start date for the control account or work package. | N/A |
| Non Labor EAC | This column displays the EAC value for resources that do not have an hours result. This field is used in the scale EAC currency option when both hours and currency are selected. | N/A |
| OP Batch | This is used internally Cobra. | N/A |
| Pending Finish | This column displays the pending finish date of the control account or work package. | N/A |
| Pending Start | This column displays the pending start date of the control account or work package. | N/A |
| Performance Factor | This column displays the performance factor value, usually based on performance to date, which is divided into the budgeted cost of work remaining to arrive at an Estimate To Complete (ETC). | N/A |
| Progress | This column displays the total earned currency value of the control account or work package. The Update Totals utility populates the value in the table. | N/A |
| Progress Technique | This column displays the progress technique assigned to the work package. | N/A |
| Project | This column displays the name of the project. | N/A |
| Resource | This column displays resource assignment for the selected cost set or class type. | N/A |
| Resource Assignment Codes [1-9] | This column displays resource assignment codes. | N/A |
| Resource Description | This column displays a brief description of the resource. | N/A |
| Sequence | This column is used internally by Cobra. | |
| SPI | This column displays the Schedule Performance Index. |
Earned / Budget |
| Spread Curve |
This column displays the spread curve name for the budget or forecast resource assignments. If there is no assigned spread curve, or if the resource assignment is manually spread or adjusted, this column displays Manual. For other types of resource assignments, this column is blank. |
N/A |
| Start Percent | This column displays the opening percent complete for work packages that use the user-defined progress technique. | N/A |
| Status | This column displays the status of the selected control account or work package. | N/A |
| SV | This column displays the Schedule Variance in dollars |
Earned - Budget |
| SV % | This column displays the Schedule Variance percentage. |
((Earned - Budget) / Budget) * 100 |
| TCPIBAC | This column displays the To Complete performance index for the budget at complete. |
(BAC - Earned) / (BAC - Actuals) |
| TCPIEAC | This column displays the To Complete Performance Index for the projected estimate at complete. |
(BAC - Earned) / (EAC - Actuals) |
| Total | This column displays the current total for each of the results over the life of the project. | N/A |
| Uid | This column displays the unique ID for the row. | N/A |
| Units | This column displays how the result is measured. For example, a unit of measurement might be dollars, or it might be tons. | N/A |
| Units Complete | This column displays the number of units completed. | N/A |
| Units To Do | This column displays the number of units that remain to be completed, which is available only if you selected the Units Complete progress technique. | N/A |
| User | This column displays the individual who is currently accessing the project. | N/A |
| User Character Fields [1-10] | This column displays the character fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display
User Character Fields [6-10]. Refer to
Additional User Fields for instructions on how to configure Cobra to use these additional fields.
|
N/A |
| User Date Fields [1-10] | This column displays the date fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display
User Date Fields [6-10]. Refer to
Additional User Fields for instructions on how to configure Cobra to use these additional fields.
|
N/A |
| User Numeric Fields [1-10] | This column displays the numeric fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display
User Numeric Fields [6-10]. Refer to
Additional User Fields for instructions on how to configure Cobra to use these additional fields.
|
N/A |
| VAC | This column displays the Variance At Complete in dollars. |
BAC - EAC |
| VAC % | This column displays the Variance At Complete percentage. |
((BAC - EAC) / BAC) * 100 |
| Variance | This column displays the Variance. |
Budget - Actuals |
| Work Package | This column displays the work package ID. | N/A |
| Work Package Codes [1-9] | This column displays the work package codes assigned to the project. | N/A |
| Work Package Manager | This column displays the work package manager assigned to the project. | N/A |