Search only in titles

---

Adding Columns to a WBS Sheet

You can add WBS custom attributes to a WBS sheet, as columns. The WBS Sheet window toolbar Menu Options icon (  ) enables you to add columns to the WBS Sheet.

Note: By default, all the predefined columns that are in hidden block in the WBS Attribute Form will display when you open the WBS sheet.

The following explains how to add a column by way of creating a new column or copying an existing column.

To add a new column:

1. From the toolbar, click Add Column  to open the New Column window.
2. Enter or select values in the following required fields:
   • Name
   • Type
   • Datasource
   • Data Format
   • Display Mode
   • Total
   • Column Position

   The following fields are optional and enable you to customize you newly added column:

   • Data Format
   • Display Mode
   • Total
3. Click Save, or Save & Add New to continue.

The following explains the required fields:

Name

The name of the column that you want to add. The value in this field is pre-populated according to the selected Datasource; however, you can override the pre-populated value.

Type

This field has the following options:

• Business Process Data Source: When you select this option, all the data elements, based on SYS BP Decimal Amount and SYS BP Currency Amount which are added on the WBS Attributes Form, are displayed in the Datasource drop-down list. Select this option if want to pull the roll up information for the new WBS (Type-cost BP). The Datasource drop-down list will be displayed followed by the Formula creator option which enables you to create the query for the column. When you select the Formula Picker, the Formula creator window displays the list of new Cost-type BPs with different statuses where you can select BPs to see the roll-up amount.
• Direct Cell Entry: When you select this option, all the data elements, based on SYS Numeric and Date logical data sources, are displayed. You can define manual entry column by using the logical sources. You can copy the data in the Direct Cell Entry field and paste it into other manual entry column.
• From EVA Sheet: When you select this option, all the data elements, based on SYS Numeric logical data sources as data sources, are displayed. Select this option if you need to populate data into WBS sheet from an EVA sheet. When you select the logical data source, you can select the sheet name and available DEs, per selected sheet, are displayed as columns to add.
• From Activity Sheet: Select this option if you need to populate data in to the WBS Sheet column from an Activity Sheet. When you select this option:
  • All the data elements are displayed in the Datasource field (based on SYS Numeric logical data sources and SYS Date logical sources).
  • The logical data source, you can select the sheet name and available DEs, per selected sheet, are displayed as columns to add.
  • When you select the SYS Date logical data source, all of the date columns (like Planned Start, Planned Finish, and so on) from the Activity Sheet will be available to pick.
• WBS Custom Attributes: When you select this option, all of the custom attributes that are added in WBS Attributes Form are displayed.
• Formula: When you select this option, all of the data elements are displayed in the Datasource field (based on SYS Numeric, SYS Date logical data sources, and SYS Integer Amount). If you select Formula as the type, the Datasource field displays the following:
  • A list of all of the SYS Numeric and SYS Date logical source data elements that allow formula-type entry. The logical source data elements that already have been used to create a column will not be listed.
  • A formula creator window (Formula Creation Window) that you can use to create the formula for the column. The formula window shows the list of all numeric columns that can be created as formula.

Datasource

The drop-down list displays a list of all SYS Numeric and SYS Date logical source data elements which allow the formula-type entry. The sources that have been used to create a column will not display in the list. The Datasource drop-down list will be displayed followed by the Formula creator option which enables you to create the formula for the column. The Formula window shows all of the list numeric columns (all Numeric Columns) that can be created as formula.

Data Format

The data format options are:

• Currency
• Decimal

The Data Format option is available only when SYS Numeric logical source Datasource is selected, and by default the Currency must be selected. There are no data format for Date- and String-type data elements.

If you select the SYS BP Currency Amount data element, the default option will be Currency.

If you select the SYS BP Decimal Amount data element, the default option will be Decimal.

When you select Decimal, and proceed to choose a number, the system displays the choice of decimal places (values are zero to eight).

Summary Rows

Within the formula columns, in the WBS Sheet, you can select the type of summary rows that you want to display. The options under the Summary Rows block enable you to display the roll-up value from children (Sum of All Rows), or to display the formula value (Use Formula Definition). Your options are:

• Blank
• Sum of All Rows
• Use Formula Definition

Display Mode

The display mode options are:

• Show
• Hide

Total

The total options are:

Blank

• Sum of All Rows
• Use Formula Definition: This option is available for a formula column.

Column Position After

To position the newly added column.

• If you choose a column in the Cost sheet and then select to add a column, the Column Position After drop-down will be pre-populated according to the name of the selected column in the WBS sheet.
• If you select no column and then select to add a column, the Column Position After drop-down will be pre-populated according to the name of the last column in the WBS sheet.

To add a new column by way of copying an existing column:

1. From the toolbar, click Menu Options (  ).
2. Click Columns.
3. Click Copy Column Data to open the Copy Column Data window.
4. Select values in the following fields:
   • Copy from Column (required)
   • Percentage
   • Past to Column (required)
5. Click Save to continue.

The following explains the fields:

Copy from Column (required)

Displays all the existing manual-entry or formula-based numeric columns for you to select.

Percentage

To enter the percentage value. The value must be greater than zero and less than or equal to 100.

Paste to Column (required)

Displays all the existing manual-entry numeric columns for you to select.

If you right-click the Direct Cell Entry of a numeric column, you can hide, lock, copy (the column data), paste (the column data) into, delete, or see the properties of that column. The Copy Column Data option is available only for:

• Direct Cell Entry columns
• Custom elements that have been added as columns

The Copy from Column field will be pre-populated with the name of the selected column; however, you can change the source to any other source.

If you right-click the column header, you can see some or all of the following options:

• Insert
• Hide this Column
• Lock after this Column
• Delete
• Properties

Entering WBS Code into a System WBS Sheet

Additional ways to enter the WBS code into a System WBS Sheet are by using import CSV or REST services.

Note: The REST service data corresponds to the columns in the CSV template.

You can import bulk WBS codes by way of CSV. When you use a CSV template to import data:

The value for the ETC Technique required field, in the CSV template, is the remaining cost for the activity, by default, if you do not enter any other values.

The values, or codes, for the allowed ETC Technique are:

1 = Remaining cost for the activity

2 = 1*(BAC-EV)

3 = 1/(CPI)*(BAC-EV)

4 = (1/CPI*SPI)*(BAC-EV)

5 = Performance Factor * (BAC-EV)

For a WBS, you can enter "Yes" as the value for the Apply ETC Technique to Child WBS field to use the same ETC Technique value to the child WBS.

The default value for the WBS Status is Active.

After you finish preparing the CSV template, you can save the file and proceed to import the CSV file into the System WBS Sheet. To import:

1. Open the System WBS Sheet.
2. Click Menu Options, click Import, and click WBS Details.
3. Navigate to the location of the CSV file, select it, click Open, and confirm the import. You can see that the values are added in the columns (WBS Codes, WBS Name, and so forth).

Editing the Default Values of the Columns

In the System WBS Sheet log, you can edit the default values of the columns (Planned Units, Actual Units, and so forth).

1. Click the column header to select it.
2. Right-click and click Properties.
3. Proceed to update the fields in the Column Properties pop-up window. You can change the default columns structure in the Column Properties window.

Roll-up Value

In the System WBS Sheet log, you can add columns and conduct a roll-up value for the added column, either by using all manual activity sheets or a single activity sheet.

When you add a new column, you can select the (right-click in the Sheet Name field of the New Column window) All Manual Activity Sheets option to get the data (roll-up) from all the activity sheets, and not just one. You can only do the roll-up from activity sheets with an Active status.

---

Last Published Wednesday, July 2, 2025