Adding A Column to a Project

The Procedure

  1. Decide which of the four basic worksheet types need to have this new column
    The 4 basic worksheet types that need to be considered in a typical Project are:
    1. Estimate Section
    2. Quantity workup sheet
    3. Rate workup sheet
    4. Cost workup sheet
  2. Carry out the following for each of these worksheet types needing this new column (these steps will be explained in detail later)
    1. Create a NEW worksheet
    2. Add the column
    3. Save this as the Default Worksheet
    4. Apply this new column to all existing worksheets

Create a New Worksheet

Carrying this out in actual fact opens up a worksheet identical to the Default worksheet for the project, and therefore by adding the column to this enables us to Save this modified worksheet as the Default, so that subsequently when we create a new worksheet, it will have the added column in it.

Add the Column

Refer to the 'How Do I Topic' Columns->Adding for full details.

Save this as the Default Worksheet
  1. Enter some trial data to make sure it is working as expected.
  2. Remove all unnecessary data from the worksheet (otherwise this will be saved as well)
  3. Click the option 'Defaults->Save as Default'
Apply this New Column to all Existing Worksheets

Refer to the 'How Do I topic' 'Applying Worksheet Modifications to Other Existing Worksheets'  for full details