Using formulas to calculate item takeoff quantities (spreadsheet or takeoff grid)

1. Click in the first item's Quantity cell.

   You can select the Quantity cells of other items using the standard Microsoft Windows selection methods.

2. Right-click the Quantity column, and then select one of these options from the shortcut menu:

   • <formula name>

     Use this command to calculate takeoff quantities in the spreadsheet or takeoff grid using the formula named by the command. A window opens so you can enter the variables used by that formula. Existing quantities are either added to or replaced by the calculated results.

     The shortcut menu includes <formula name> if the selected items all have the same formula. Otherwise, Enter Dimensions or Select Formula is available.

   • Select Formula

     A formula has not been assigned to the items.

     Choose this option to display a list of available formulas. Select the formula you want to use from the list. The Formula window opens.

   • Enter Dimensions

     The items have different formulas assigned to them and some items may not have a formula assigned to them.

     Choose this option to open the Enter Dimensions window.

3. Enter a value for each variable in the window.

   For more information, click on the title bar of the window, and then click a field or button.

4. Click a button to continue.

   To...	Click...
   Add the new quantity to the existing takeoff quantities	[Add to Qty]
   Replace the existing takeoff quantities with the new quantity	[Replace Qty]
   Cancel the quantity calculation and close the Formula window	[Cancel]

Sage Estimating (SQL) uses the formula assigned to each item to calculate the takeoff quantities and displays them in the Quantity column.

Any items that do not have a formula assigned to them will have a blank quantity.