Maintaining WBS Data

Editing WBS Elements

To change information for an existing WBS element, complete the following steps:

  1. To show the field to be changed, use the Horizontal Scroll Bar. If the field you need is not displayed, use Column Hide on the Format menu to change the displayed fields.

  2. To select the WBS, do one of the following:

  3. Click on the desired row in the WBS Sheet

  4. Click on the leg in the WBS Tree and click Edit » Go To WBS

  1. To edit a cell, double-click the desired cell. If your cursor is already placed in the cell you want to edit, press F2 to access Edit mode.

  2. Change the data in one or more editable fields in the current row. After modifying and leaving a cell, the row is shown in blue to indicate that it is in Edit mode.

  3. To advance to the next field, use Tab, Shift+Tab, or the left- or right-arrow keys.

Filling Down Cells

A quick way to propagate your data is to use Fill Down, which automatically fills the selected cells with the data in the first cell of the selected cells. The cell(s) to be filled must be in rows below the cell(s) to be copied. Copied dates must be within the Start and Complete dates of the parent.

To auto-fill WBS element cells, complete the following steps:

  1. To select the data to be copied, select the cell that contains the desired data.

  2. To select the cells to be filled with this data, drag the mouse down the column, or click the desired rows while holding the Shift key.

  3. Click Edit » Fill Down, or press Ctrl+D.

  4. Click Yes when asked to save the changes. The cells below the first cell will all now contain the same data as the first cell of the selected cells.

Copying / Pasting Cell Data

Copying element cells using the clipboard is another fast way to enter data into new WBS elements.

To copy WBS cell data, complete the following steps:

  1. To select the cells to be copied, click on the cell(s) in the WBS Sheet. To choose multiple elements, use Shift and Ctrl while clicking the mouse button.

  2. To copy the data to the clipboard, click image\winm0059_wmf.gif Copy , Click Edit » Copy Cell(s), or press Ctrl+C.

  3. Highlight the cell(s) into which you would like to paste the copied cell(s).

  4. To paste, click image\winm0060_wmf.gif Paste, Click Edit » Paste, or press Ctrl+V. MPM pastes the new cell information over any existing information in the selected cells.

Be sure that the target cell(s) contain the same type of information as the cell(s) you copied. If you copied more than one cell, you may have copied hidden fields. Copying hidden fields causes a problem if you attempt to paste the copied cells into cells that do not contain corresponding hidden fields. To solve this problem, copy and paste visible cells one at a time, or display hidden fields before copying and pasting.

Deleting the Contents of One or More Cells

To delete the data from one or more cells, complete the following steps:

  1. Choose the cell(s) from the WBS Sheet.

  2. Click Edit » Delete Cell(s), or press the Delete key. If the deletion is across more than one row and any errors are encountered during the delete, a message is displayed for each row that encounters an error. For example, you would receive this message if you deleted one or more <Required> field.

Deleting Entire WBS Legs

When deleting WBS legs, all data (BCWS, BCWP, ACWP, BOEs, etc.) associated with that WBS element is also deleted.

Once a WBS element is deleted, the only way to restore that element and its children is from a backup of the data. Be sure to back up your data first!

To delete a WBS element and all of the WBS element's children, complete the following steps:

  1. To select the WBS leg to be deleted, click on the WBS in the WBS Tree, or click on the row number of the WBS leg in the WBS Sheet. To choose multiple elements, use Shift and Ctrl while clicking the mouse button.

  2. To delete the selected legs, click Edit » Delete WBS(s) or press Del.

  3. MPM asks you to verify the deletion. Click Yes.