Bid Leveling Worksheet
Compare original offers, scope adjustments and complete bid totals.
Fictional worked example.
Scope for North Workshop
Blank amounts stay unknown. A zero adjustment means you explicitly entered 0.
Entries save on this device.
- Selected original bid
- $12,000.00
- Selected adjustment
- +$1,000.00
- Selected comparable total
- $13,000.00
- Selected review
- Complete
A comparison total ranks price only. Read the scope and next action beside each bid.
Bid comparison
3 bids · US dollars · fictional worked example
| Bidder & original | Adjustment | Comparable total | Scope & follow-up |
|---|---|---|---|
| North Workshop Original $12,000.00 | +$1,000.00 Add quoted disposal cost | $13,000.00 $500.00 above lowest complete | Complete · addenda 1 and 2 Base scope; disposal excluded. Next: Confirm disposal inclusion |
| Greenline Works Original $12,500.00 | $0.00 No adjustment | $12,500.00 Lowest complete | Complete · addenda 1 and 2 Disposal included. Next: Check proposed start date |
| Cedar Contracting Original $11,800.00 | Unknown Disposal amount not confirmed | Unresolved | Needs clarification · addenda 2 not confirmed Disposal excluded; confirm final addendum. Next: Request revised scope |
No bids match these filters. Reset filters to restore the worksheet.
On this page4
Compare the same work before ranking price
The opening worksheet uses three fictional bidders for a storage-room refit. It deliberately includes an unresolved scope. Enter a project name, select a bidder and preserve the original offered price. Add or remove bidders for any of the site’s trades or another work package.
Use Scope to record addenda, inclusions and exclusions. Enter the total adjustment needed to place that offer on the same scope basis; a deduction is negative. Record the reason for a nonzero adjustment. Mark scope complete only after resolving it. When no addendum applies, enter “None”.
Understand complete, unknown and unranked bids
A comparable total is the original offer plus its adjustment. Blank amounts stay unknown. A bid is ranked only when it is received, named, numerically valid, marked complete, has an addenda entry, and gives a reason for a nonzero adjustment. Negative comparable totals are invalid. Requested and declined offers stay in the record and are excluded from the lowest complete price.
The worksheet shows ties. It does not award a contract or combine price, licensing and experience into an invented score. Qualifications, scope notes and the next action stay beside the amount for you to assess.
In the fictional example, North Workshop’s $12,000 bid becomes $13,000 after a $1,000 disposal adjustment. Greenline Works remains $12,500 and is the lowest complete comparable offer. Cedar Contracting’s $11,800 original offer stays unranked because disposal and the final addendum remain unresolved.
Keep a reusable bid record
The Compare tab searches names and scope notes, filters review status and sorts by name, comparable total or action due date. The headline result always uses the whole worksheet, so a search cannot silently change the lowest complete bid.
Entries save on this device. Download a CSV for every bidder, including original values, unresolved fields, scope, next actions and dates. Save the editable JSON backup to move the worksheet to another browser; loading a backup asks before replacing the current worksheet. Print includes every bid and its scope notes.
Use the bid tabulation template for an offline spreadsheet, the bid proposal template to prepare your own offer, and the job-pricing calculator to check the effect of your costs on margin.
Method and corrections
This is the site’s original bid-tabulation method: preserve quoted amounts, apply user-supplied scope adjustments, retain the reason and compare only resolved offers. Supplier records supplied by you are the source for your worksheet. The worked amounts are invented arithmetic examples. The GAO cost guide describes documenting scope, assumptions and cost differences.
Method checked October 28, 2026; review due April 28, 2027. Report a worksheet correction with a fictionalized example and the behavior you expected.