Learn more

Export Data (Units) window

Import Data (Units) window

Edit Database Units window

You use the Edit Database Units window to define valid units for items in an open standard database.

You also use this window to select valid units when you are working with items in a database.

  1. Display the Database Items window:

    • On the ribbon, select the Data tab, and then from the Phase/Item group, click Items.

    • In classic view, select Database > Items.

  2. Display the phase and item for which you are adding or editing units.

  3. Open the Edit Database Units window:

    1. Click the [Edit] button.

    2. Click Edit Units.

  4. To add a new unit value:

    1. Click [Add]. to create a new row in the grid.
    2. In the Name column for the new row, type up to eight alphanumeric characters to identify the unit.
    3. If you are defining a unit of time, in the Type column, select the time (such as week, crew hour, and so on) from the list.
    4. In the Description column, type a description to help you to remember how this value is used when you need to select a unit, later.

    To edit an existing unit, simply type a new name, type, or description for the unit.

    To delete an existing unit, click the row indicator An image showing a row indicator on the spreadsheet to select the unit you want to delete, and then click [Remove].

  5. When you have finished adding and editing units for the selected database item, click [OK] to close the Edit Database Units window.

After adding database unit values

You can export the list of values to Microsoft Excel, where you can use that program to easily edit the list. You can then import the values back into the database.