MEP BOQ Excel Sheets – Free Download & Complete Bill

2

MEP BOQ Excel Sheets; BOQ is technique which is used to by contractors to make accurate bills for MEP projects. they obtains information about materials, labours, equipment using multiple techniques one of the most common technique is using excel sheets, spreadsheets and quantifying. they Use their BOQ to make estimations on the costs and manage budgets on the sites like constructions, buildings etc. this is very useful all over the world and still its very popular in MEP projects like Mechanical, Electrical, Plumbing.

What’s Included in the BOQ Workbook

1. Mechanical BOQ Sheet

   • Ductwork quantities (linear feet, fittings, insulation)
   • HVAC equipment schedules (units, capacities, accessories)
   • Pipework take‑offs (diameter, length, valves, supports)

2. Electrical BOQ Sheet

   • Cable tray and conduit lengths
   • Cable and wire counts by gauge
   • Lighting fixtures, switches, outlets, and panel boards
   • Earthing and lightning protection materials

3. Plumbing BOQ Sheet

   • Cold, hot water, and sanitary piping take‑offs
   • Fixture counts with fixture unit values
   • Valves, traps, pumps, and accessories
   • Drainage pipe lengths and fittings

4. Summary & Costing Sheet

   • Consolidates quantities from all trades
   • Input unit rates to calculate total costs
   • Automatically updates grand totals and subtotals
   • Includes contingency and overhead markup fields

Key Features

• Pre‑Formatted Materials Lists: Standard categories for MEP components—just enter your project data.
• Dynamic Take‑Off Calculations: Change lengths or counts and watch totals update instantly.
• Built‑In Rate Tables: Customize labor and material unit rates per region or project.
• Error‑Proof Formulas: Locked cells protect critical calculations while allowing user inputs.
• Printable Reports: Generate BOQ printouts and summary sheets for tender submissions.

How to Use the Excel CATALOG

1. Download & Open: Unzip and enable editing in Microsoft Excel.
2. Enter Project Details: Fill in project name, location, and revision date on the Cover sheet.
3. Quantify MEP Items: Navigate to the Mechanical, Electrical, and Plumbing tabs—enter lengths, counts, and sizes.
4. Adjust Rates: On the Summary tab, input unit costs for materials and labour.
5. Review & Export: Verify totals and print or save the BOQ report as PDF for clients and contractors.

Benefits of Using These BOQ Sheets

• Consistency Across Trades: Uniform format for all MEP disciplines ensures clarity.
• Time Savings: Eliminates manual take‑off on paper, reducing drafting and calculation errors.
• Cost Transparency: Breakdowns by item and trade help stakeholders understand budget allocations.
• Flexibility: Easily adapt the sheets to new project specifications and local standards.