Producing estimates > Completing an estimate > Checking for incomplete entries
Checking for incomplete entries in the estimate
The Scan feature finds incomplete entries on the spreadsheet. An incomplete entry is any
of the following:
- A quantity, amount, or
price cell which is blank or contains a zero
- A blank Sub Name cell on
items which have subcontractor amounts
- A conversion factor or
order quantity cell if the order unit exists for the category, the takeoff
unit and order unit are different, and the conversion factor for the category
is zero
To check for incomplete entries:
- Position the cursor
anywhere on the spreadsheet.
-
On the ribbon, from the Tools group on the Home tab, click
.
In classic view, click Pricing > Scan, or click
on the toolbar.
Sage Estimating stops at the first cell that is empty or
contains a zero.
- Fill in the missing quantity, amount, price, conversion
factor, or subcontractor name. If you need to do more research before
supplying a value, leave the cell blank for now.
- Repeat steps 2 and 3 until
no more incomplete entries are found. (When Sage Estimating reaches the bottom
of the spreadsheet, it resumes scanning from the beginning of the spreadsheet.)
Tips:
- If you do not want Scan to stop at blank Sub
Name cells on items that have subcontractor amounts, clear the
Include subcontractor name during scan check box in the Estimating Management Console (Preferences tab > Spreadsheet options).
- To have the scan skip cells
that are intentionally blank, enter a hyphen (-) or an asterisk (*).