What happens when you combine assemblies

When you put the spreadsheet into a Combine Assembly sequence, Sage Estimating (SQL) consolidates each matching assembly under a single Combined Assembly overline with all assembly items listed below the overline.

An overline is any level of the spreadsheet based on the spreadsheet sequence. For example, if the spreadsheet is in Phase/Item order, the primary overline is group phase and the secondary overline is phase.

To combine matching items into one line:

On the ribbon, from the Spreadsheet Actions group on the Home tab, click Combine Items.

Notes:  

  • Items that make up individual assemblies are not combined
  • An asterisk appears at the beginning of rows that contain combined items.
All assemblies Combined assemblies

 

Takeoff Quantity

Total Amount

 

Takeoff Quantity

Total Amount

Foundation – Footing NoRbar

20 cy

908

Foundation – Footing NoRbar

35 cy

2043

Foundation – Footing NoRbar

15 cy

1135

Paving – Asphalt with Base

550 sy

4530

Paving – Asphalt with Base

750 sy

6116

Paving – Asphalt with Base

200 sy

1586