Description

A complete electrical BOQ template in Excel for electrical installation works. It runs from MV switchgear and transformers to cabling, terminations, cable racks, generators, UPS, lighting, earthing and commissioning. Use it as a QS to issue a tender, or as a contractor to price one.

Built from real project experience, working alongside quantity surveyors who used this structure to tender, measure and certify electrical works.

What’s included in the electrical BOQ

• 384 line items across 12 bills and 39 sections
• Bill 1 Preliminaries & General: fixed and time-related P&G, site staff, vehicles, plant and travel
• MV equipment, LV switchboards, MCCs, DBs, VSDs, generators and UPS
• MV, LV, SWA, single-core, earth, control and instrument cables by size
• Terminations, glands and lugs; cable ladder, tray, conduit and supports
• Rigging, craneage and positioning of heavy equipment
• Lighting and small power, earthing and lightning protection, testing and commissioning
• Provisional sums and daywork rates

Built for real tenders

• Supply rate, install rate and S&I rate on every line, with supply, install and total amounts.
• Supply By and Install By columns. Free-issue and “by others” items drop out of the totals automatically.
• A scope of work under every bill and a reference documents line under every section, plus a drawing register sheet.
• Cost by area or building on the Summary.
• Pricing checks flag lines with a quantity but no rate before you issue or submit.
• Contingency, tax and tender sum carry to a signed tenderer’s declaration on the cover.

Why line-by-line pricing matters

Lump-sum quotes are hard to measure at claim time and leave no record when a project runs late. Pricing supply and installation separately on every line means progress can be measured, claims can be checked against agreed rates, and both sides have the facts if an extension of time is needed.

Works with the rest of the set

The rows match the Electrical Daily Progress Tracker and the Electrical Payment Certificate. Your priced BOQ pastes straight into the monthly claim.

File details

• Microsoft Excel (.xlsx) for Excel 2016 or later, Microsoft 365 and LibreOffice 7 or later. No macros.
• Choose your country: currency labels and tax (GST, VAT or sales tax) update across the file. 17 countries built in, including Australia, South Africa, the UK, the USA and the eurozone.
• Yellow cells are inputs. Formulas on the summary sheets are protected without a password, so they can’t be overwritten by accident.
• Instructions sheet in the file, plus a Read Me PDF with a one-minute quick start.
• Instant download after purchase. Re-download any time from My Account.
• Licensed for use on your own projects. Not for resale or redistribution.

This template is a tool to save you time. It is not legal, quantity surveying or engineering advice. Always check quantities, rates and scope against your contract documents.