Working with standard databases > Building and modifying a standard database > Crews > Changing an existing rate table

Learn more

Changing an existing rate table

Open the Database Rate Table window in one of the following ways:
- On the ribbon, from the Crews group on the Data tab, click Rate Tables.
- In classic view, select Database menu > Crews > Rate Tables.
- From a crew or rate table, right-click a cell in the Resource column, and then select Edit Rate Table from the shortcut menu.
Select the rate table you want to change.
The source option indicates where the rate table showing in the window is stored. If you opened the window from the spreadsheet, you can choose to change a rate table in either the estimate or the standard database.
You can click $image\list.gif$ to choose from a list of existing rate tables in either the estimate or standard database, or scroll through the rate tables using [<<] and [>>].
Make changes as needed.
- To rename the rate table, click [Rename], and then enter the new name in the Rate table field.
- To change a resource rate, click the cell, and then enter the new rate.
- To add, delete, or modify resources in the rate table, move the cursor to the resource name or description cell and right-click to display your options. How?
- To change the heading for a benefit/other cost column, right-click the column heading, right-click, and then select Change Benefit Column from the shortcut menu. Enter the new heading in the Changing Benefit Column window, and then click [OK].
- To change how the rate for a benefit/other cost column is calculated, right-click the column heading, and then select the desired option from the shortcut menu: Amount per Unit or Percent of Base Rate.
For more information, click $image\windhlp.gif$ on the title bar of the window and then click a field or button.
When you finish changing the rate table, click [OK] to save it.
Change other rate tables in the same manner. When you finish, click [Close].

Tips:

Changes to a rate table affect only future take off items. To apply changes to existing items, select Crews from the Reprice Estimate group on the Takeoff tab. (In classic view, click Pricing menu > Reprice Crews).
To sort the resources in the rate grid by description, right-click the Description column heading and select Sort by Description from the shortcut menu.
To sort the resources in the rate grid by name (ID), right-click the Resource column heading and select Sort by Resource ID from the shortcut menu.