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) Tool 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 often suffers from inconsistent pay item numbering, incorrect units of measurement, and missing divisions. This browser-based tool structures quantities into standard divisions (Series 1000 through Series 9000), aggregates divisional subtotals, applies contingencies and VAT, and exports audit-ready pricing schedules.
2. Practical Step-by-Step Instructions
- Import Item 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 Pink Book).
- Map Pay Item Codes: The auto-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 items in division)
- Total Tender Base Cost (C_base):C_base = ∑ S_div (Series 1000 to Series 9000)
- Grand Total with Contingencies & Tax:C_grand = [ C_base × (1 + r_phys + r_price) ] × (1 + r_vat)Where r_phys = physical contingency, r_price = price adjustment, and r_vat = VAT rate.
4. Standard Specification Series (ERA Standard Technical Specifications 2013)
The BoQ hierarchy corresponds to the 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 & Culverts | Pipe culverts (m), box culvert concrete (m³), stone pitching (m²) |
| Series 4000 | Sub-Base & Base Courses | Natural gravel sub-base (m³), crushed stone base GB1 (m³) |
| Series 5000 | Asphalt Pavements & Surfacing | Prime coat (liters), asphalt concrete surfacing AC (m³ or tonnes) |
| Series 6000 | Structures & Bridges | Reinforced concrete (m³), high-yield rebar (kg), elastomeric bearings (No) |
| Series 7000 | Ancillary Works & Markings | Thermoplastic markings (m²), traffic signs (No), guardrails (m) |
5. Output Interpretation & Commercial Auditing
Before finalizing tender documents, check:
- Unit Consistency: Verify that no volumetric items (e.g., concrete) are mistakenly tagged with linear or area units.
- Provisional Sums: Confirm that dayworks, utility relocations, and laboratory allowances are entered under appropriate provisional headings.
- Formula Integrity: Ensure the exported Excel schedule contains live formula links (
=SUM()and=Q*R) rather than hardcoded static text.
6. Related Technical Guides & Workflow Integration
Read our specialized guide on Streamlining BoQ Estimation for tips on integrating CAD takeoffs into contract documentation.