Changing the calculation methods for assembly items
Changing an existing standard database assembly
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:
-
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.
- Click [ ].
-
Complete the fields at the top of the window.
- Click [Insert], and then use the shortcut menu options to select items. You can insert items, item tables, and select-at-takeoff items.
-
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.
For more information, see Changing the calculation methods for assembly items.
-
To customize a variable for use in this assembly only, set up an assembly-specific variable.
For more information, see Setting up an assembly-specific variable.
-
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.
For more information, see Changing rows in an assembly.
-
- Click [Test], and then verify that the appropriate variables display for the assembly.
- When you finish setting up the assembly, click [OK] to save it.
- 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.