Spreadsheet Pane of the Project View
The Spreadsheet pane displays properties about the control accounts, work packages, and resource assignments associated with the project.
You can see project properties such as costs, dates, and codes at both the control account and work package levels, and limit the display of items in this pane using filters. You can drill down into specific control accounts to see the individual work packages assigned to these accounts. You can also see work packages from multiple control accounts at the same time.
Color Band
The Spreadsheet pane uses colors to highlight the status of work packages or control accounts that exceed predefined threshold settings.
Keep Data in Sync
The Spreadsheet pane displays values stored in the CAWP table. Cobra updates these values when you perform manual data entry or run a process by summing up the time-phased data.
These values are calculated and associated with the parent record (CAWP table), so they can, on occasion, become out of sync in a multi-user mode or when connection errors occur. If the values in the Spreadsheet pane seem incorrect, run the Update Totals utility to populate the values with detailed(time-phased ) data. You can run the Update Totals utility on a regular basis to ensure that the summary values are always correct.
You can also display data based on formulas against the CAWP data by inserting calculated fields as columns in the Spreadsheet pane. Basically, you can insert any column from the CAWP table into the Spreadsheet pane and compare its content against the individual control accounts or work packages. Right-click the Spreadsheet pane to display a shortcut menu where you can select a task to perform, such as adding control accounts and work packages and updating the forecast.
When you open a project for the first time, Cobra displays the following columns by default. Most of these columns are fields from within the CAWP table.
Column | Description |
|---|---|
Control Account Field 1 | This column displays the first control account key value. Cobra creates the control account key by combining the work breakdown structure (WBS) and the organizational breakdown structure (OBS). Cobra uses this field as the primary sort key. The column header depends on the prompt that you assigned to the Control Account Field 1 using either the Fields tab of the Project Properties dialog box or the Fields page of the New Project Wizard. For example, if you specified WBS as the prompt, the column header will be WBS. |
Control Account Field 2 | This column displays the second control account key value. Cobra creates the control account key by combining the WBS and OBS. Cobra uses this field as the secondary sort key. This column displays the second control account key value. Cobra creates the control account key by combining the WBS and OBS. Cobra uses this field as the secondary sort key. The column header depends on the prompt that you assigned to the Control Account Field 2 using either the Fields tab of the Project Properties dialog box or the Fields page of the New Project Wizard. For example, if you specified OBS as the prompt, the column header will be OBS. |
Control Account Field 3 | This column displays the third control account key value, for example, the Resource Breakdown Structure (RBS). |
Work Package | This column displays the work package key. The column header depends on the prompt that you assigned to the Work Package field using either the Fields tab of the Project Properties dialog box or the Fields page of the New Project Wizard. For example, if you specified WP as the prompt, the column header will be WP. |
Resource | This column displays the resources assigned to the selected work package. |
Description | This column displays a brief description of the control account or work package. |
Baseline Start | This column displays the baseline start date that defines the initial status date for the project. |
Baseline Finish | This column displays the baseline finish date that defines the last date of the project. |
Status | This column displays the status of the selected control account or work package.
|
Class | This column displays the class associated with the resource. |
Cobra displays the Errors dialog box if validation errors are encountered in this pane during a save operation.
Copy and Paste
You can quickly update values by copying multiple cells from an Excel spreadsheet and paste the values in columns for a single row in the Project view panes.
Cobra pastes the values in the editable cells only and ignores the values in the read-only cells if the destination cells in the Project view pane include read-only cells. Cobra displays an error message if all destination cells are read-only.
Cobra does not allow you to paste values if some of the data types of the copied values from the Excel spreadsheet do not match the data types of their destination cells.
Cobra does not allow you to paste values if the copied values from the Excel spreadsheet exceed the available destination columns in the Project view pane.
Total Row
The Total row is located at the top of the Spreadsheet and Time-phase panes of the Project view. This row displays the project-level values for the following fields in the Spreadsheet pane when they are added as columns in the pane.
Select the Show Project Totals option in the Data group on the Edit tab to display the Total row values in the Spreadsheet pane.
To display the Total row values in the Time-phase pane, select both the Show Project Totals option and the Show Summary Time-phase option.
Actuals | Actual Finish | Hours Actuals | Actual Rate | BAC |
BAC Hours | Baseline Finish | Baseline Start | Budget | Hours Budget |
Budget Rate | CPI | Hours CPI | CPI Performance | Hours CPI Performance |
CV | Hours CV | CV % | Hours CV % | Description |
EAC | Hours EAC | Earned | Hours Earned | Forecast Finish |
IEAC | Hours IEAC | IEAC 2 | Hours IEAC 2 | Last Update |
% Complete | Hours % Complete | % Spent | Hours % Spent | Project |
Sequence | SPI | Hours SPI | SV | Hours SV |
SV % | Hours SV % | TCPI BAC | Hours TCPI BAC | TCPI EAC |
Hours TCPI EAC | User ID | VAC | Hours VAC | Variance |
Hours Variance | VAC % | Hours VAC % |
The Total row displays project-level data based on the filter applied to the Project view.
The Total row is read-only. It remains on top of the panes even if you sort a column in the Spreadsheet pane.
Columns that are not defined at the project level are displayed as blank in the Total row of the Spreadsheet pane.
The Total row displays values only for Baseline Start, Baseline Finish, Actual Finish, and Forecast Finish dates as these are the dates that you see and define on the General tab of the Project Properties dialog box. If you add Actual Start as a column, for example, it will display as blank.
The Baseline Finish, Actual Finish, and Forecast Finish dates display the latest Baseline, Actual, and Forecast Finish dates of the control accounts displayed in the Spreadsheet pane. On the other hand, the Baseline Start date displays the earliest Baseline Start date of the control accounts displayed in the Spreadsheet pane.
When you edit any of these dates, the updated dates will display in the Total row/column only after you save the changes.
Related Topics:
Right-click the Spreadsheet pane to display the available commands and options that you can use.
Spreadsheet Pane Column Definitions
The Spreadsheet pane of the Project view displays a set of standard columns.
The filtering feature of Cobra allows you to limit the display of items in the Spreadsheet pane based on your selections.
You can find records in the Spreadsheet pane without expanding all of the records.
The save and share feature of Cobra allows you to save the selections for columns and their order, filters, sorts, Show Project Totals option, Show Summary Time-phase option, Show Assignments option, and resource results to a named view.
Spreadsheet Pane of the Project View Dialog Boxes
Use the dialog boxes in this section to manage the Spreadsheet pane of the Project view.
Follow the procedures in this section to utilize the dialog boxes in the Spreadsheet pane of the Project view.
Learn more about...
General Tab of the Project Properties Dialog Box
Time-phase Pane of the Project View