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>
   • Select Formula
   • Enter Dimensions

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

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

Published: July 07, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks