A revised Excel Schedule of Prices or BOQ shouldn’t send your tender back to zero. See what changed, review uncertain lines, and carry only the rates that still match.
Item 5.1 · row 42375 mm · 94 m · Rate needs review
CHANGED
PS-18Temporary bypass pumping
Not in original—
Item 8.1 · row 632 days · No previous rate
ADDED
DW-06Flush and CCTV inspection
Item 6.4 · row 5265 m · $8.70 / m
Not in revised schedule—
REMOVED
4 changes found in this fictional scheduleNothing uploaded
A moved row can still match. A changed diameter needs your review.
For priced civil tendersRates carried only on an unambiguous matchWorkbook layout and formulas preservedFiles stay on your device
Try the example
One revision. Four things to notice.
This fictional drainage schedule shows a moved item, a changed pipe diameter, a new pay item and a removed line. Filter the changes, then choose how you’d resolve the changed rate.
RC
Riverside access upgradeOriginal tender vs revised Schedule of Prices
FICTIONAL SAMPLE · NO SIGNUP
LineOriginal · priced tenderRevised · Schedule of PricesComparison result
SW-04Moved
Catchpit lead-in300 mm uPVC connection · StormwaterItem 4.2 · row 2812 m · $82.40 / m
Catchpit lead-in300 mm uPVC connection · StormwaterItem 4.2 · row 3512 m · $82.40 / m
Same pricing basis. Rate carried.Section, description, unit and quantity match.
SW-09Changed
Stormwater pipeSN16 uPVC · diameter changedItem 5.1 · row 41300 mm · 94 m · $142.50 / m
Stormwater pipeSN16 uPVC · 375 mm diameterItem 5.1 · row 42375 mm · 94 m · Rate needs review
Diameter changed. No rate carried.The original rate is held for your decision.
PS-18Added
Temporary bypass pumpingNew pay item · StormwaterNot in original—
Temporary bypass pumpingNew pay item · StormwaterItem 8.1 · row 632 days · No previous rate
New item. No rate invented.No previous rate to carry.
DW-06Removed
Flush and CCTV inspectionExisting line · Drainage worksItem 6.4 · row 5265 m · $8.70 / m
Flush and CCTV inspectionExisting line · Drainage worksNot in revised schedule—
Removed from the new schedule.Visible for review; not copied forward.
YOUR REVIEW · SW-09
300 mm changed to 375 mm. What should happen to the old rate?RateCarry leaves the line for you to resolve.
This is an interactive sample using fictional data. It does not accept workbook uploads or create an export.
The matching rule
Only carry a rate when the whole line still means the same thing.
Items can move within a schedule and still match. A different diameter, unit or quantity changes the pricing basis, so the line stays visible for you to review.
RateCarry checks five fieldsAll five must match clearly
01ItemSame pay item reference✓
02SectionSame work section✓
03DescriptionSame scope and specification✓
04UnitSame measurement basis✓
05QuantitySame tender quantity✓
If anything is unclear, no rate is carried automatically. You review the original and revised line side by side. RateCarry never fills in a price of its own.
A practical guide
How to compare a revised BOQ in Excel
When a client issues a new Schedule of Prices after tender pricing, start with the priced original and the exact revised workbook.
01
Keep the priced tender as your reference
Use the workbook that contains your submitted rates, quantities and item descriptions.
02
Find every added, removed, moved and changed line
Check the revision itself, not just the row number. Items may move without changing their scope.
03
Carry rates only on a clear, like-for-like match
Confirm the item, section, description, unit and quantity. A changed pipe diameter needs an estimator’s decision.
04
Review uncertain rows before you export
Resolve each changed line, then download the revised schedule with accepted rates in place.
Straightforward pricing
One export for the work you’ve already priced.
Preview a comparison free. The first revised workbook export is NZ$49. Unsupported workbook formats are identified before payment.
For one accepted-rate export to your revised .xlsx schedule.
Compare two Excel workbooks
Review changes before rates carry
Download the revised schedule
Good to know
Before you compare
Do my tender files leave my device?
RateCarry processes supported workbooks locally in your browser. Your priced rates stay on your device.
When will a rate carry forward?
Only when item, section, description, unit and quantity match unambiguously. Changed or uncertain rows are held for your review; RateCarry never invents a rate.
What happens to the revised workbook?
Your accepted rates go into the correct cells of the revised workbook. Its layout and formulas are preserved.
Which files can I compare?
RateCarry is designed for .xlsx Schedule of Prices and Bill of Quantities workbooks. Unsupported workbooks are identified before payment.