Learn more

Combining assemblies on the spreadsheet

Combining items on the spreadsheet

Rules for combining items

What happens when you combine items

What happens when you combine assemblies

When you put the spreadsheet into a Combine Assembly sort sequence, Sage Estimating consolidates each matching assembly under a single Combined Assembly overline with all assembly items listed below the overline. Note that the items that make up individual assemblies are not combined. To combine matching items into one line, select Home tab > Spreadsheet group > Combine (in classic view select View menu > Combine or click on the toolbar). An asterisk displays 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