Learn more

About entering prices in the estimate

Changing the order of the spreadsheet columns

Changing the size of the spreadsheet columns

Changing the spreadsheet column headings

Eliminating excess column width on the spreadsheet (Best Fit Column)

Making spreadsheet columns non-scrolling

Turning spreadsheet columns on or off

Spreadsheet window

Spreadsheet columns

Note: Columns marked with an asterisk (*) are available only if you have a license to use Crews.

Addon Amount

Amount (all categories)

Assembly

Base Amount (all categories)

Base Productivity (Labor, Equip)

Bid Grid

BOM Desc

Conv Factor (Material, Other)

Cost/Unit (all categories

*Count (Labor, Equip)

*Crew

Date, Time

Description

*Equip Hours

Grand Total

Grand Total Unit Price

Group

Item

JC Cat (all categories)

JC Phase (all categories)

*Labor Man Hrs

Location

Material Class

Notes

Percent of Total

Phase

Price (all categories)

Price Code

Price Factor (all categories)

Price Source UPC

Productivity (Labor, Sub, Equip)

Productivity Adjustment Factor (Labor, Equip)

Quantity (all categories)

*Rate Table (Labor, Equip)

Seq

Sub Name

Sub Number

Subcategory (all categories)

Takeoff Quantity

Tax (all categories)

Total Amount

Total Cost/Unit

Update Database

Vendor Number

Vendor Name

Waste

Waste (all categories)

<WBS>

Tips:  

  • To adjust the width of a column, drag the right border of the column header in either direction.
  • To fit a column to the width of its contents, double-click the right border.
  • To restore a hidden column, select the columns on either side and use the Show Hidden Columns command on the shortcut menu.
  • The shortcut menu for column headers offers several useful commands.