Most UAE infrastructure suppliers still price a bill of quantities the same way they did ten years ago. A tender arrives, an estimator opens the BOQ in Excel, and the next two or three days go into reading each line, finding the matching product, looking up a rate in an old quote or an email from a supplier, and typing it in. The process works, in the sense that quotes go out. What it hides is how much time and margin leak out of the spreadsheet along the way.
That leak matters more in 2026 than it did a few years ago. Volume is high when it arrives: MEED data showed contracts worth $29.744 billion awarded across 114 contracts in the first quarter, as Aletihad reported on 28 April 2026. Costs are also moving faster than most rate sheets are updated. Cement was up 16 percent since January, concrete up 10 percent and steel reinforcement up 8 percent, according to a Currie & Brown market report reported by EnterpriseAM on 6 October 2026. A BOQ priced from last quarter's rates can lose its margin before the contractor even opens the envelope.
This article looks inside the spreadsheet itself. It walks through how BOQ pricing is usually done at a UAE trading or supply firm, the specific places where time and margin are lost, what controls you can add today without buying anything, and how AI matching against a maintained price library changes the work.
How a BOQ Usually Gets Priced in Excel
The details vary by firm, but the pattern at most suppliers with 50 to 200 employees looks very similar. Understanding it step by step is the easiest way to see where the problems come from.
- The BOQ arrives from a contractor or consultant, often as a PDF or a locked Excel file, sometimes with several hundred lines across multiple sections.
- The estimator copies or retypes the lines into the firm's own pricing template, or works directly in the client's file.
- For each line, the estimator reads the description and specification reference and decides which product in the firm's range is the closest match.
- The estimator finds a cost for that product. This might come from a supplier price list, a recent purchase order, an email from a manufacturer, or a quote the firm sent for a similar job.
- Margin is applied, often by hand per line or through a column formula that someone set up years ago.
- Totals are checked, the sheet is sent for approval, and someone adjusts a few rates after a conversation with the sales manager.
- The priced BOQ is pasted back into the client's format and submitted.
None of these steps is unreasonable. The problem is that every one of them relies on a person remembering the right source, copying the right number and not breaking a formula. Across several hundred lines and several tenders a week, small error rates add up.
Where Estimators Lose Time
Retyping and reformatting
Locked PDFs and client templates with merged cells force estimators to retype descriptions and quantities before any pricing can start. On a large BOQ this alone can take most of a day, and it adds its own errors: a quantity of 1,250 typed as 125, or a unit of linear metres read as each.
Searching for the last rate
The single biggest time sink is usually rate hunting. The estimator knows the firm quoted a similar valve or cable last year, but the rate sits in a file named after a project, in a folder on someone's laptop, or in an email thread with a supplier. Each search takes minutes, and on lines that are not standard products, those minutes repeat for every tender.
Matching descriptions to products
Consultants describe items by specification, not by your part numbers. Matching a line such as a ductile iron gate valve to a particular standard and pressure rating against your catalogue takes product knowledge, and that knowledge often lives in one or two senior people. When they are busy, matching slows down or is done by someone who is less sure.
Reconciling the final file
After approvals, the rates have to be copied back into the client's template. Totals are checked again because something always moves. We covered the wider version of this problem, where whole days are lost across the tender process, in our piece on why tender responses slip in UAE construction supply. Inside the BOQ itself, the reconciliation step is where many late changes get lost.
Where Margin Leaks Out of the Spreadsheet
Time is visible because estimators complain about it. Margin loss is quieter, because it only shows up later, when the job is delivered and the numbers do not match the quote.
Spreadsheet errors are normal, not rare
Spreadsheet error is one of the most studied problems in business computing. Raymond Panko's review of spreadsheet error research for EuSpRIG found that audits from 1997 onward discovered errors in 91 percent of 54 spreadsheets examined, and that laboratory studies showed cell error rates of roughly 1 to 9 percent. In one experiment developers estimated a 10 percent chance that their own sheet contained an error, while 86 percent of them had in fact made one. People checking a spreadsheet alone caught only about half of the errors. A BOQ is exactly the kind of large, repetitive, hand built sheet where those rates apply.
Outdated rates
Copying a rate from an old quote feels safe because it was a real price once. In a year where imported building material costs rose by 20 to 25 percent, according to Moody's, as reported by Arab News on 1 July 2026, an old rate can be badly wrong. Moody's noted that contractors, not developers, absorbed most of those increases. For a supplier, that pressure comes straight back as tighter negotiations on every quote. We looked at this in more detail in our article on keeping UAE supplier quotes accurate during the Hormuz disruption.
Missed and misread items
Missed items rarely look like mistakes. A line hidden in a later section, a note that a price must include installation or testing, or a provisional quantity that becomes firm, can all slip past a tired estimator. If the line is priced at zero or left out, the firm may still be bound to supply it at the total quoted. Unit mismatches cause the same kind of loss, for example pricing per piece when the BOQ asks per metre.
Short validity windows
Suppliers are protecting themselves by quoting shorter validity periods. The same EnterpriseAM report noted that some steel prices are locked for only around 30 days and that fluctuation clauses are becoming common on longer programmes. If your BOQ rates came from a supplier quote that has already expired, your margin depends on prices not moving before the order is placed.
Broken formulas and hidden overrides
Every estimating team has a template with formulas that only one person fully understands. A margin column that was overwritten by hand on twenty lines, a total that excludes a newly inserted row, or a currency conversion fixed at an old rate can all survive approval because reviewers look at the total, not the logic underneath it.
Why the Pressure Is Higher in the UAE Right Now
The UAE pipeline remains large. WKS Connector's June 2026 overview of UAE construction tenders notes that the Abu Dhabi Projects and Infrastructure Centre oversees more than 600 ongoing projects worth over AED 200 billion, and that ADNOC plans to award around AED 200 billion in projects between 2026 and 2028. The same overview points out that bids are evaluated on price, technical capability and local value criteria, so price accuracy sits alongside ICV and technical credentials as a deciding factor.
Awards also arrive unevenly. EnterpriseAM, citing Kamco Invest data, put second quarter awards at $20.5 billion, down 56.6 percent from the first quarter. For an estimating team, that means quiet weeks followed by bursts where several large BOQs land at once. Bursts are exactly when shortcuts get taken, old rates get copied without checking and lines get skipped. Our guide to tender management software for UAE infrastructure suppliers covers how to choose tools for that capacity problem. This article stays with the BOQ, because that is where the margin is actually set.
Controls You Can Add to Your Excel Process Today
Before any software decision, there are practical steps that reduce errors in the spreadsheet you already use. They also make any later automation far easier, because the data will be cleaner.
- Build one price library. Keep a single sheet or database of products, units, current cost, supplier, and the date each cost was confirmed. Estimators price from that source only, not from old quotes.
- Add a rate age column. Next to every priced line, show the date the cost was confirmed. Conditional formatting that turns a cell red after 30 days makes stale rates visible during review.
- Lock the template logic. Protect the formula columns for margin, totals and currency, and add a check cell that compares the sum of lines with the grand total.
- Flag zero and blank lines. A simple count of lines with no rate, or with a rate of zero, should appear at the top of the sheet and be cleared before approval.
- Check units explicitly. Add a column for the unit in the BOQ and the unit in your price library, and flag any line where they differ.
- Review the logic, not just the total. A second reviewer should sample lines, check where rates came from and confirm that overrides are intentional.
These controls are simple, and many teams already know they should use them. The reason they slip is time. When three BOQs are due on the same day, the rate age check and the second review are the first things to go. That is where automation earns its place.
How AI Matching Against a Price Library Changes the Work
Modern tender and quotation tools apply the same controls automatically, on every line, every time. ZentraBid, BearingNorthAI's tender and quotation agent, is built for this step in the process. The approach is simple to describe:
- It reads the BOQ from the format it arrives in, including PDFs and locked spreadsheets, and extracts each line with its description, quantity, unit and specification reference.
- It matches each line to candidate products in your own catalogue, with a confidence indication, so estimators focus on the uncertain lines rather than checking every one.
- It prices matched lines from your central price library, using the cost and margin rules you have set, and shows the date each cost was confirmed.
- It produces an exception list: lines with no match, lines with a unit mismatch, rates older than your threshold and items that look unusual for the tender.
- It returns the priced draft in the client's format, ready for the estimator to review and adjust.
The estimator still owns the final price. What changes is where their time goes. Instead of retyping and rate hunting, they review a short list of exceptions and apply commercial judgment where it matters: on the risky lines, the competitive lines and the terms. Before pricing, it is also worth checking the commercial clauses that sit around the BOQ, which we covered in our guide to checking tender documents for the compliance clauses UAE suppliers miss.
Measuring the Difference
If you want to know how much your current process is costing, measure it on your next few tenders before changing anything. Track these numbers for each BOQ:
- Hours from BOQ received to priced draft ready for review.
- Number of lines in the BOQ and number of lines that needed a manual rate search.
- Number of lines with rates older than 30 days at the time of submission.
- Number of corrections made during approval, and the value of those corrections.
- For won jobs, the difference between quoted cost and actual purchase cost by line.
The last number is the most revealing. If actual costs on won jobs regularly come in above the quoted costs, the gap is margin that left through the spreadsheet. Even a small percentage across a year of awarded orders is often larger than the cost of fixing the process.
Conclusion
Excel is not the problem in itself. It is flexible, familiar and good enough for many tasks. The problem is that BOQ pricing asks a person to do hundreds of small lookups and copy operations under deadline pressure, with no system checking whether each rate is current, each unit matches and each line has been priced. Research on spreadsheet errors suggests that most large sheets contain at least one mistake, and UAE material costs in 2026 have made old rates riskier than usual.
Start with one clean price library and a rate age column. Then measure how long your next three BOQs take and how many stale rates they contain. If the numbers show what they show at most suppliers, the case for matching BOQ lines automatically against your own price library becomes clear. If you would like to see how ZentraBid handles one of your recent BOQs, bring a real one to the conversation.
Research Sources Used
- Aletihad, Projects worth $30 billion awarded in UAE in first quarter of 2026 (MEED data), 28 April 2026
- EnterpriseAM UAE, UAE contractors back away from fixed price contracts as materials costs climb (Currie & Brown and Kamco Invest data), 6 October 2026
- Arab News, UAE developers keep projects on track despite 25% jump in material costs: Moody's, 1 July 2026
- Raymond R. Panko, Spreadsheet Errors: What We Know. What We Think We Can Do, EuSpRIG Proceedings, July 2000
- WKS Connector, UAE Construction Tenders in 2026: Where the Opportunities Are and How to Get Matched, 23 June 2026