Using formulas to calculate item takeoff quantities (Item takeoff)

  1. In the variable pane, enter a value for each variable.

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

  2. Click a button to continue.

    Buttons used to take off item quantities
    To Click...
    Add the new quantity to the existing takeoff quantities

    the Add Pass button
    Undo the last dimension

    the Undo Pass button

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

    Any items that do not have a formula assigned to them will have a blank quantity after you generate them to the spreadsheet.

  3. (optional) To enter another pass:

    • Move the cursor to the variable pane.
    • Enter new values for variables as needed.
    • Click the Add Pass button.

    Sage Estimating (SQL) calculates the new takeoff quantities and adds them to the existing quantities. The number of the current pass displays at the bottom of the pane.

Tip: You can also access formulas from the takeoff grid or spreadsheet to calculate item takeoff quantities. For more information, see Using formulas to calculate item takeoff quantities.