D · Bills of Quantities — commercial analysis

EMR ZFD AZR MW 0177 BOQ (OCT 2024) PTA456 — 9 sheets

EMR ZFD AZR MW 0177 BOQ (OCT 2024) PTA456 — 9 sheets.xlsx

Bill total2,175,914,452.65 AED
As submitted · quantity × rate2,175,914,379.52
Size7,621 lines · 550 blocks · 9 sheets
Source fileEMR ZFD AZR MW 0177 BOQ (OCT 2024) PTA456 — 9 sheets.xlsx
Fingerprint · SHA-2566bc9fb73ef81a1bb
File size6.96 MB
Received9/9/2026, 9:45:51 PM
Report generated9/9/2026, 11:24:32 PM
Grammar versionv1.12

2 of 7 headings are settled · 5 still open · 1 not assessable from this submission alone.

1

Received in hard copy manuscript

10openOpen in the workspace

4 things about how this file is put together need answering before it can be quoted line by line.

Received in hard copy manuscriptNot assessable here: this submission reached the review as a file.
ExcelEMR ZFD AZR MW 0177 BOQ (OCT 2024) PTA456 — 9 sheets.xlsx — cell values read directly, never off the printed page.
PDF
Sheets submittedGR1 · 2 - Main · 3 - Ext · Bill 4 · 3M · 4.1-M · 4.2-M · 4.3-M · 4.4-M
9 sheets · GR1 · 2 - Main · 3 - Ext · Bill 4 · 3M · +4 more
Lines transcribed
7,621
Collection blocks
550
7 lines carry no item reference, though every other line on their page doesEither the reference was missed in the source, or the row is not an item.
7
0 lines
7 lines carry no item reference, though every other line on their page does
UnitRateYour decision
Total0 lines0.00
1 line restarts its lettering without a new headingUsually a heading the page prints that was not picked up.
1
0 lines
1 line restarts its lettering without a new heading
UnitRateYour decision
Total0 lines0.00
1 line repeats an item letter already used under the same headingKept exactly as printed — confirm which line the bidder meant.
1
0 lines
1 line repeats an item letter already used under the same heading
UnitRateYour decision
Total0 lines0.00
1 line has no heading above it while its neighbours doA governing heading may have been missed when the page was read.
1
0 lines
1 line has no heading above it while its neighbours do
UnitRateYour decision
Total0 lines0.00
2

Arithmetical Errors

5openOpen in the workspace

The bid's own arithmetic does not close — a difference of 73.13.

1 line does not multiply out — quantity × rate is not the amount shownThe page total uses the printed amount, so the quantity is usually what is wrong.
1
0 lines
1 line does not multiply out — quantity × rate is not the amount shown
UnitRateYour decision
Total0 lines0.00
1 line does not add up to the collection total its own page printsBoth figures are shown — neither is corrected to the other.
1
Total as the bill prints it
2,175,914,452.65
Total the bidder's own quantity × rate producesComputed from the figures the SOURCE prints — a reviewer's own changes are never folded in here.
2,175,914,379.52
What the bid's internal arithmetic contradictions are worthThe printed amounts total MORE than quantity × rate.
73.13
3

Deviations from Tender Bill

3openOpen in the workspace

3 sections do not total what the summary declares.

GENERAL REQUIREMENTS FOR THE WHOLE OF THE WORK — declared 313,190,338.58, lines total 0.001 Sum row 6 · 1/GR/1 - 1/GR/15 — off by -313,190,338.58. Both figures are kept; neither is corrected to the other.
313,190,338.58
PROVISIONAL SUMS — declared 5,720,000.00, lines total 0.004 Sum row 6 · 4/PS/1 — off by -5,720,000.00. Both figures are kept; neither is corrected to the other.
5,720,000.00
SECTION R - ELECTRICAL INSTALLATIONS — declared 249,590,682.12, lines total 249,611,555.25 Summary row 41 · Page 2/R/1 - 2/R/177 — off by 20,873.13. Both figures are kept; neither is corrected to the other.
20,873.13
0 lines
SECTION R - ELECTRICAL INSTALLATIONS — declared 249,590,682.12, lines total 249,611,555.25
UnitRateYour decision
Total0 lines0.00
a

General Requirements

2settledOpen in the workspace

2 blocks of scope sit outside the measured lines, worth 318,910,338.58.

BILL NO. 1 -GENERAL REQUIREMENTSDeclared as one figure on Summary row 11 — a whole bill priced as a lump, not measured line by line.
313,190,338.58
BILL NO. 4 -PROVISIONAL SUMSDeclared as one figure on Summary row 71 — a whole bill priced as a lump, not measured line by line.
5,720,000.00
b

Excluded, unpriced items

2openOpen in the workspace

Scope this bid does not price — put each to the bidder before comparing.

363 lines carry no rate, so nothing reaches the totalsSay why the bidder left them unpriced, or ask them to price them.
363
0 lines
363 lines carry no rate, so nothing reaches the totals
UnitRateYour decision
Total0 lines0.00
160 lines print words where a figure belongsAccept the wording as a class, or put it to the bidder.
160
0 lines
160 lines print words where a figure belongs
UnitRateYour decision
Total0 lines0.00
4

Key High / Low Analysis

0not assessableOpen in the workspace

Not yet assessed — a rate can only be called high or low against a benchmark, and none is set for this submission.

Nothing to report in this section.

5

BOQ line items should be priced individually.

2settledOpen in the workspace

6,946 of 7,621 lines carry a unit rate, worth 2,169,047,863.06 — 99.7% of the printed total.

Lines priced at a unit rateQuantity × rate — the lines a rate comparison can be run on.
6,946
0 lines
Lines priced at a unit rate
UnitRateYour decision
Total0 lines0.00

the quantity the bidder’s own arithmetic implies (amount ÷ rate), shown where the cell prints 0 and a zero cannot have produced the amount. The cell itself is unchanged.

Lines priced as a wholeAn amount with no rate behind it — there is no unit rate here to compare.
152
0 lines
Lines priced as a whole
UnitRateYour decision
Total0 lines0.00
6

Any Other Observations

3openOpen in the workspace

3 further observations on this submission.

1 line carries the finding section collectionNo plain-language description has been written for this finding yet.
1
1 line carries the finding bill rollupNo plain-language description has been written for this finding yet.
1
1 line carries the finding summary tieNo plain-language description has been written for this finding yet.
1