Setting up a new standard database assembly

Note: This feature is available only with a Sage Estimating (SQL) SQL product license. (It is not available with Sage Estimating Essential.)

Before you start

Before you start building assemblies, you should understand how Sage Estimating (SQL) calculates the quantities for an assembly when you take it off.

For more information, see How Estimating calculates takeoff quantities for assemblies.

To set up a new standard database assembly:

  1. Open the Assembly window in one of the following ways:

    • On the ribbon, from the Elements group on the Data tab, click Assemblies.
    • In classic view, select Database menu > AssembliesSmart Assemblies.
  2. Click [Add].
  3. Complete the fields at the top of the window.

  4. Click [Insert], and then use the shortcut menu options to select items. You can insert items, item tables, and select-at-takeoff items.
  5. Review the item grid and make changes as needed.

    The calculation method (Calculation) specified for each item, table, or select-at-takeoff item determines how Sage Estimating (SQL) calculates the item quantity. The calculation method is filled in with the formula you assigned to the standard database item. Check the calculation method for each item to make sure it is appropriate for the use of the item in this assembly.

  6. Click [Test], and then verify that the appropriate variables display for the assembly.
  7. When you finish setting up the assembly, click [OK] to save it.
  8. Set up additional assemblies in the same manner. When you finish, click [Close].

Tip: After you set up your assemblies, you can print the Assemblies reports from the Database Reports group on the Reports tab (in classic view, select Database menu > Reports) to check them.