Adjusting a spreadsheet group (level)
Entering lump amounts in the spreadsheet
How Adjust Column affects bid amounts
For each category, this spreadsheet column shows the extension of the order quantity by the unit price, that is, in its simplest form:
Order quantity x Price
Depending on the type of cost category, the amount may be affected by a productivity factor or a price factor.
-
Order quantities for labor and equipment, may be calculated using a productivity factor, for example:
Takeoff quantity x Productivity x Productivity factor
-
Prices for other categories, such as material, may be calculated using a price factor, for example:
Takeoff quantity (with waste) x Price x Price factor
You can change the amount. If you type over a calculated amount in the spreadsheet or Detail window, you replace the calculation with a lump amount. Sage Estimating (SQL) then recalculates the productivity factor (for labor and equipment) or the order quantity for that item.
In the Sub Amount column, click 
to open a grid containing
the bids entered for an item. After you specify a bid for the estimate,
the sub name, sub number, and sub amount are the same in the spreadsheet
and Bid Grid. Any change you make to one cell updates the corresponding
cell in the other grid.
Tips:
- To enter the same amount for several items, choose Fill Down on the shortcut menu.
- An asterisk (*) in the Sub Amount column means that the item is included with other items in a subcontractor bid.
- Lump amounts have a different font and background color for easy identification. Use the Options command to change the font and background color.
- To restore a lump amount to a calculated amount, change its unit price. Sage Estimating (SQL) recalculates the amount.
- Collapse the spreadsheet to see values for the upper two levels. The Options command controls whether information displays when the levels are expanded.
- These amounts also appear in the Extension tab of the Detail window.