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. Typing over a calculated amount in the spreadsheet or Detail window creates a lump amount that Sage Estimating tries to preserve. If an amount changes, Sage Estimating recalculates the conversion/productivity and order quantity for that category. You can change the amount for items, but not at other levels.
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 normal, change its unit price. Sage Estimating 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.