Combining assemblies on the spreadsheet

You can combine matching assemblies on the spreadsheet. Some estimators like to combine assemblies because it makes it easier for them to review the spreadsheet during the revision process. When you combine assemblies, you do not lose any of your estimate detail or accuracy.

To combine matching assemblies:

Put the spreadsheet in Combined Assembly sequence. How?

Tips:  

  • No editing is permitted on a combined assembly overline.
  • To combine matching items into one line:

    • On the ribbon, select Home tab > Spreadsheet group > Combine.
    • In classic view, select View menu > Combine or click An image of the Combine icon, from Classic view on the toolbar.

    An asterisk (*) appears at the beginning of rows that contain combined items.

  • Combined Assembly is an available sort level for spreadsheet sequences.