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.
You can choose 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.
You can also use the [] button in the Spreadsheet Report Options window to print items in the same order (ascending or descending) used in the spreadsheet.
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 you turn on the ability to export formulas (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 turning on and turning off the ability to export formulas for this report.