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.)

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 > Assemblies > Smart 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.

   • To change an item calculation method, click the right mouse button from any Calculation cell to open a shortcut menu listing your editing options. How?

   • To customize a variable for use in this assembly only, set up an assembly-specific variable. How?

   • To make other changes in the item grid, click the right mouse button from any item row to open a shortcut menu listing your editing options. How?

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.