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 Codes

The Spreadsheet pane uses colors to highlight the status of work packages or control accounts that exceed predefined threshold settings.

Attention: For more information about how Cobra uses colors to identify projects, master projects, control accounts, and work packages that exceed threshold settings, see the Threshold Colors help topic.

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. Planned means that it has not been started (the Start column for the Actuals field is empty). In-Progress means that it has been started (the Start column for the Actuals field contains a date). Completed means that it is finished (the Finish column for the Actuals field contains a date).
Class	This column displays the class associated with the resource.

Note: There is always a blank row at the bottom of the Spreadsheet pane. When you add data and save your changes, a new blank row is added. Using this blank row, you can manually add a new control account or work package.

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.