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, get 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. It makes sense to 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 Field tab on the Project Properties dialog box or the Fields page in 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 Field tab on the Project Properties dialog box or the Fields page in 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 Field tab on the Project Properties dialog box or the Fields page in 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 assign 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. |
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 only pastes the values in the editable cells 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:
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 % |
Columns that are not defined at the project level are displayed as blank in the Total row of the Spreadsheet pane.
The Total row will only display values 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 column, for example, it will only 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 only display in the Total row after you save the changes.
- Related Topics:
- Spreadsheet Pane Column Definitions
The Spreadsheet pane of the Project view displays a set of standard columns. - Filters
The filtering feature of Cobra allows you to limit the display of items in the Spreadsheet pane based on your selections. - Using the Find Function
You can find records in the Spreadsheet pane without expanding all of the records. - Save and Share View
The save and share feature of Cobra allows you to save the selections for columns and order of columns, filters, sorts, Show Summary option, Show Assignments option, and resource results to a named view. - Update EAC Dialog Box
Use this dialog box to manually update the forecast values for a control account or work package. - Add Control Account Dialog Box
Use this dialog box to add a control account to a project. - Add Work Package Dialog Box
Use this dialog box to add a work package to a control account. - Rename Control Account Dialog Box
Use this dialog box to rename a control account. - Rename Work Package Dialog Box
Use this dialog box to rename a work package. - Move Control Account Dialog Box
Use this dialog box to create a new control account by moving it from one location to another. - Move Work Package Dialog Box
Use this dialog box to create a new work package by moving an existing one from one location to another. - Copy Control Account Dialog Box
Use this dialog box to create a new control account by copying an existing one. - Copy Work Package Dialog Box
Use this dialog box to create a new work package by copying an existing one. - Shortcut Menu
Right-click the Spreadsheet pane to display the available commands and options that you can use in Spreadsheet pane. - Procedures
Use the procedures to add, rename, move, copy, and save control account and work package.