Values taken from printed schedules and specifications
Derived (Measured/Computed)
Quantities computed from scaled drawings and geometry
Estimated (Indicative)
Estimated quantities requiring verification
Provisional
Provisional sums and allowances
HOW TO USE THIS WORKBOOK
1. Start with this Summary sheet to review the total contract value and trade breakdown.
2. ALL dollar values on this sheet are live formulas linked to the "Bill of Quantities" sheet.
3. Open "Bill of Quantities" and edit any Rate or Quantity -- all totals on this Summary and the Trade Summary sheet will update automatically via Excel formulas.
4. Use "Program Dashboard" for the visual program overview: milestones, phase timing, critical path and procurement releases.
5. Use "Schedule Inputs" to set a project start date, edit trade lead times, and apply builder overrides.
6. Review "Indicative Program" for the dependency-aware baseline schedule and override durations where required.
7. Check "Procurement Schedule" for long-lead release dates and on-site requirements.
8. "Program Gantt" shows the printable colour-coded program with procurement, milestones, and critical path highlighting.
9. Check "Provisional Sums" for items that are allowance-based and will be subject to final measurement.
10. The "RFI Register" lists all items requiring further information or verification. Use the Status dropdown to track responses (OPEN / IN PROGRESS / CLOSED / N/A).
11. "Trade Exclusions" and "Scope Assumptions" document what is and is not included in this estimate.
12. All data sheets have filters enabled -- use the dropdown arrows in the header row to filter by trade, status, or any column.
13. Charts above are native Excel charts linked to the "Chart Data" table. When you edit rates or quantities in BOQ, the charts update automatically.
Generated by EstiFlow | 28 April 2026 | Confidential