This report includes the contents of the spreadsheet using the sort levels, ranges, fonts, and layout of your choice. The width of the report depends on the visible columns and their size. There are also options to allocate addons; combine items; round prices and quantities; include the cover page, estimate totals, and level totals; and print grid lines and shaded headings.
To create this report:
- On the ribbon, select the Reports tab, and then from the Estimate Reports group, click Spreadsheet.
-
In classic view, select Reports menu > Spreadsheet.
Tip: When the ability to export formulas is enabled (through the Estimating Management Console), exporting this report to Microsoft Excel also exports all formulas associated with the spreadsheet. For example, if your spreadsheet is set up to report the Labor Amount (Labor Quantity column * the Labor Price column), clicking on the Labor Amount column in the Excel spreadsheet reveals the resulting calculation formula as I4*K4 (where I4 is the Labor Quantity column and K4 is the Labor Price column).
Refer to the Estimating Management Console Help for more information about enabling and disabling the ability to export formulas for this report.