Entering quantities for spreadsheet groups

1. Display the spreadsheet in a sequence that contains the desired level.

For example, to enter quantities for locations, click the Location/Phase tab at the bottom of the spreadsheet.

2. To collapse the spreadsheet to the appropriate level:
   • On the ribbon, from the Spreadsheet Display group on the Home tab, click Collapse  .
3. Click in the Takeoff Quantity cell of the desired level and enter a quantity.

To enter phase quantities:

1. With the spreadsheet in Phase/Item order, click  once to collapse the spreadsheet to the phase level.
2. Click in the Takeoff Quantity cell of the desired phase, and then enter a quantity.

To enter group phase quantities:

1. With the spreadsheet in Phase/Item order, click  twice to collapse the spreadsheet to the group phase level.
2. Click in the Takeoff Quantity cell of the desired group phase, and then enter a quantity.

To enter location quantities:

1. With the spreadsheet in Location/Phase order, click  twice to collapse the spreadsheet to the location level.
2. Click in the Takeoff Quantity cell of the desired location, and then enter a quantity.

Tip: When you enter quantities for levels, Sage Estimating calculates the cost per unit for each level and prints it on your estimate reports.

Getting Started: Completing an estimate (SQL)