BoQ Tool
A Bill of Quantities (BoQ) translates engineering designs into a structured contract pricing schedule. This tool maps raw geometric quantities, structural counts, and pavement volumes into standardized hierarchical divisions (Series 1000 General to Series 6000 Structures) conforming to standard technical specifications.
Tender preparation often requires manually linking CAD takeoffs into thousands of Excel BoQ cells with inconsistent unit codes, unreferenced pay-item numbering, and broken sum formulas. This tool automates hierarchical BoQ generation with verified specification pay items.
- •ERA Standard Technical Specifications (2013 Edition)
- •FIDIC Conditions of Contract for Construction (Red Book)
- •Standard Method of Measurement for Civil Engineering Works (CESMM4)
- •Quantity Surveyors preparing tender documents
- •Highway Estimators pricing contract bids
- •Procurement Specialists structuring FIDIC tenders
Amount_item = Quantity · Unit_RateTotal computed per standard measurement unit (m³, m², ton, linear meter, or lump sum).Use these outputs for preliminary checks. They do not constitute official engineering approval. Verify the inputs, method and results against the project criteria before using them for design or construction.
Bill of Quantities (BoQ) Generator: Choose Standard Specifications
Select the standard technical specifications to compile, map, and structure your Bill of Quantities (BoQ).
Bill of Quantities (BoQ) Tool Documentation
Technical specifications, mathematical formulas, and civil guidelines
1. Functional Purpose & Methodology
Preparing a tender-ready Bill of Quantities (BoQ) requires transforming raw geometric takeoffs into standardized, hierarchically structured payment schedules mapped to client contract specifications. The Bill of Quantities (BoQ) Estimator automates this compilation, matching physical road items (such as crushed rock base, subgrade preparation, pipe culverts, and asphalt concrete) to official specification clauses (such as ERA Standard Technical Specifications 2013 or AACRA Urban Standards).
Manual BoQ compilation in spreadsheets frequently suffers from broken sum formulas, inconsistent pay-item numbering, and missing specification divisions. This browser-based tool structures quantities into standard divisions (Series 1000 through Series 8000), aggregates divisional subtotals, applies compounding contingencies and statutory Value Added Tax (VAT), and exports audit-ready pricing schedules.
2. Practical Step-by-Step Instructions
- Import Quantity Takeoffs: Upload an Excel (.xlsx) or CSV file containing raw takeoff descriptions, physical quantities, and provisional unit rates.
- Select Specification Division Standard: Choose the target contract framework (e.g., ERA 2013 Divisions, AACRA City Roads, or FIDIC Red Book standard).
- Map Pay Item Codes: The mapping engine matches common descriptions (e.g., "CBR>15 capping" or "Class C25/30 concrete") to their standard specification numbers (e.g., Item 21.03, Item 52.02).
- Configure Financial Parameters: Enter the project currency, physical contingency percentage (typically 5% to 10%), price escalation contingency (typically 5%), and Value Added Tax (VAT, typically 15%).
- Generate Grand Summary & Export: Inspect the live hierarchical tree and download the completed, fully formatted tender schedule in Excel with linked calculation formulas.
3. Mathematical Formulations & Financial Aggregation
Tender pricing models follow standard contract accounting structures:
- Item Total Amount (A_i):A_i = Q_i × R_iWhere Q_i = verified item quantity, and R_i = proposed unit rate.
- Division Subtotal (S_div):S_div = ∑ A_i (for all pay items within the division)
- Total Tender Base Cost (C_base):C_base = ∑ S_div (Series 1000 through Series 8000)
- Grand Total with Contingencies & Tax (C_grand):C_grand = [ C_base × (1 + r_phys + r_price) ] × (1 + r_vat)Where r_phys = physical contingency rate, r_price = price adjustment contingency, and r_vat = Value Added Tax rate.
4. Standard Specification Series (ERA Standard Specifications 2013)
The BoQ hierarchy corresponds to recognized highway divisions:
| Division Code | Series Title | Typical Pay Items & Standard Units |
|---|---|---|
| Series 1000 | General & Preliminaries | Engineer's facilities, survey, insurance, traffic safety (Lump Sum / Month) |
| Series 2000 | Site Clearance & Earthworks | Clearing & grubbing (ha), roadway excavation (m³), borrow fill (m³) |
| Series 3000 | Drainage & Cross Structures | Pipe/box culverts (m), stone pitching (m²), headwalls, gabion mattresses (m³) |
| Series 4000 | Subbase, Roadbed & Gravel | Natural gravel subbase GS (m³), subgrade capping layer (m³) |
| Series 5000 | Base Courses | Crushed stone base GB1 (m³), cement stabilized base CB1 (m³) |
| Series 6000 | Bituminous Surfacings | Prime coat MC-30 (L), asphalt concrete AC (m³), double surface dressing (m²) |
| Series 7000 | Bridges & Major Structures | Structural concrete C30 (m³), reinforcing steel (tonne), elastomeric bearings (No.) |
| Series 8000 | Ancillary Works | Thermoplastic markings (m²), traffic signs (No.), guardrail (m), kilometer posts (No.) |
5. Worked Numerical Example with Real Financial Aggregation
A preliminary cost estimate is prepared for an upgraded 10.0 km two-lane rural road using verified contractor unit rates. Financial provisions include 10.0% Physical Contingency and 15.0% statutory VAT:
6. Engineering Assumptions & Limitations
- Provisional Sums: Specialist items (e.g. utility relocations, environmental mitigation, geotechnical lab testing) are typically entered as fixed provisional lump sums and are not subject to physical item remeasurement.
- Unit Rate Currency & Inflation: Unit rates reflect static prices entered by the user. Multi-year construction contracts requiring FIDIC price adjustment formulas must apply indices separately based on local fuel, cement, and labor index curves.
- Method of Measurement: Pay-item volume definitions follow net theoretical dimensions shown on construction drawings. Construction tolerances, waste, and over-excavation are deemed included in contractor unit rates per ERA specification clauses.
- Independent Commercial Audit: This tool compiles quantities mathematically; final bidding documents must be audited and stamped by a licensed Quantity Surveyor or Professional Engineer.
7. Standards Referenced & Contract Frameworks
The schedule formatting and measurement rules align with recognized infrastructure procurement standards:
- ERA Standard Technical Specifications (2013): Series 1000 to Series 8000 pay-item definitions and measurement rules.
- FIDIC Conditions of Contract (Red & Pink Books): Measurement and evaluation clauses for civil engineering works.
- CESMM4 (Civil Engineering Standard Method of Measurement): Hierarchical item categorization conventions.
- AACRA Standard Specifications for Urban Infrastructure: Urban pay-item classifications for municipal roads.
8. Frequently Asked Questions (FAQs)
Physical contingencies account for unforeseen ground conditions and scope adjustments during construction. In standard FIDIC and public procurement guidelines, statutory VAT is levied on the entire contract sum including contingencies.
Yes. The tool allows creating custom divisions, such as Series 9000 for Street Lighting and Intelligent Transportation Systems (ITS) or Series 10000 for Toll Facilities.
The ExcelJS export engine generates dynamic spreadsheet formulas (e.g., =SUM(D4:D12)) rather than hardcoded values, preserving full auditability in your exported workbook.
The tool checks for arithmetic errors and zero-quantity items. Unbalanced bidding or front-loading analysis should be evaluated in accordance with the project tender evaluation guidelines.
Yes. CSV files generated by Civil 3D Quantity Takeoff (QTO) manager can be uploaded directly, with automatic mapping to pay-item codes.
9. Related Technical Guides & Workflow Integration
To compile verified earthwork excavation volumes before feeding them into this BoQ tool, use our Excel Quantity Takeoff & QC Tool. For complete BoQ compilation workflows, read our technical guide on Streamlining BoQ Estimation for Highway Infrastructure.
Developer of InfraDigital CAD
Read the tool-specific source, assumptions and limits before interpreting its output. These browser-based tools are provided as productivity aids for preliminary engineering and drafting checks. Project-specific independent verification and approval by a licensed Professional Engineer (PE / REng) is required before final design submission, drawing stamping, or construction implementation.
Author: Yonatan Abrham
InfraDigital CAD developer
Technical Integrity & Independent Verification: Use the tool for the stated calculation or workflow. Check the applicable edition, input assumptions and limits in the tool documentation.
The user remains solely responsible for verifying that all inputs, soil parameters, traffic projections, and geometry comply with project-specific statutory requirements and geotechnical investigations prior to final engineering approval or construction stakeout.