Using formulas to calculate item takeoff quantities (Item takeoff)

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

    For more information, click An image showing 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

    An image showing the Add Pass button

    Undo the last dimension

    An image showing 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 An image showing 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. How?