QScope

Model revisions

What changed between one issue and the next

A revised bill arrives and the quantities have moved. Load the earlier and the later issue and QScope lists what changed, item by item, with the money each change moved.

  • Two issues of the same priced bill, Revision A earlier and Revision B later, as .xlsx files
  • Items matched by bill reference, with quantity, rate and description changes counted
  • Unchanged items are counted, not listed

30 days free, no card.

Model revisions
Revision A to revision B
Matched items42
Quantity changed14
Rate changed3
Description changed2
Difference+£38,400.00

The comparison lists every change and leaves the items that did not move out of the way.

Quantity changes

Every quantity change, item by item

The Quantity changes card lists each item with its reference, its description, the quantity and rate before and after, and the money it moved.

  • Nothing is cut from the list, however long it runs
  • Each line shows the scope, price and total movement
  • Reference and description come from the bill, so the item can be found again
Model revisions
Quantity changes
ItemQuantity, before → after
2.1 External render5 → 7 nr
3.4 Studwork partitions120 → 138 m
6.2 Small power42 → 48 nr
Movement on these items+£4,860.00

Ref, description and both issues of the figures sit on one line, so nobody has to hold two schedules side by side.

Only in one revision

Items that appeared, and items that went

The Only in one revision card lists what was removed and what was added, each with its own amount.

  • Removed and added counted separately
  • Each item carries its value from its own issue
  • Read from the bill itself, not from a model export
Model revisions
Only in one revision
Removed1 item · £3,150.00
Added3 items · £12,400.00
Net of added and removed+£9,250.00

An item that exists in one issue only is never folded into a total quietly: it has its own card.

Model revisions

The cost of the revision first

The totals of both revisions and the difference come first, in pounds and in per cent.

  • Revision A total and Revision B total sit side by side.
  • Difference shows the change in pounds, coloured by direction.
  • Difference % is measured against revision A and says n/a when revision A is zero.
Model revisions
The cost of the revision first
In the program
Revision A totalcalculated
Revision B totalcalculated
Differencecalculated
Difference %calculated
n/acalculated

On screen: “Revision A total”, “Revision B total”, “Difference”, “Difference %”.

Model revisions

Scope and price kept apart

Quantity movement and rate movement are split, never blended.

  • Scope is the change in quantity valued at the old rate.
  • Price is the change in rate valued on the new quantity.
  • The two add up to the change in the amount, checked on every line.
Model revisions
Scope and price kept apart
In the program
Scope is the change in quantity valued at the old rate
Price is the change in rate valued on the new quantity
The two add up to the change in the amount, checked on every line

Shown on the same screen as the rest of this page.

See it running before you sign up

Every other function on the Model revisions screen

6 functions the sections above do not cover, each as it works in the program.

Functions 1 to 3

01Rate changes with no change in quantity have their own list.
02Lines where only the description or the unit changed are listed, because the same figures with new words can still be a scope change.
03Both files are read in your browser and nothing is uploaded.

Functions 4 to 6

04The column layout is found by arithmetic, and a sheet that does not add up is refused with the reason.
05Each file shows its number of priced items and its total as soon as it is read.
06Rows found in one revision only, rows without a reference, ambiguous references and rows failing their own arithmetic are all counted on screen.

Who it is for

One change, four people it touches

You are applying

You price the change and defend it

You price the instruction, submit the variation and defend it when it comes back cut. Instructed work with no variation against it is money you have already spent.

Applying for payment
the same measurement

You are certifying

You value the change and answer for it

You value the variation from the other chair and account for what you cut. The register you keep is the one the final account will be argued from.

Certifying payment

You are doing both

You build the change, paid or not

You absorb the small changes as they come, and the ones nobody wrote down are the ones you end up building for free.

Doing both yourself

You are reporting

You fund the change, priced or blind

You check that scope changes are priced and approved before money moves, because an unpriced variation is risk the facility is carrying blind.

Recommending a drawdown

The client, the architect and the tenderer are not on this list. They are the people you let in on a link: they see the one document you sent them, answer it, and that answer is written into the record. No account, no licence, no charge, on every plan.

FAQs

The questions this page raises most often, answered without a sales pitch at the end.

No. It compares two issues of a priced bill of quantities as .xlsx files. A schedule without rates is refused, because the layout is read from quantity times rate.

No. The comparison reads the two files and changes nothing in the project.

It is refused with the reason, rather than read wrongly.

From the blog

The part nobody teaches you, written down

Three pieces from the same corner of a contract as this page, answered at length and without a sales pitch at the end.

All 174 pieces

Keep reading

The three parts this page leans on

Compare the last two issues you were sent

Load both files and see what moved, item by item, with scope and price separated before anyone argues about the total.

30 days free, no card.

Rather ask first? Write to help@qscope.co.uk and you will get a reply within one working day, Monday to Friday.