Electrical estimating has a habit of turning into a long, error-prone list — every light point, socket, DB, and metre of conduit counted by hand across multiple rooms or floors. An electrical takeoff spreadsheet is what keeps that list organized and priceable, and it’s the base document behind every electrical BOQ and wiring quotation you’ll ever send a client.
What Is an Electrical Takeoff Spreadsheet?
An electrical takeoff is a structured count of every electrical item in a project — light points, fan points, 5A and 15A sockets, switches, distribution boards, MCBs, wiring length, and conduit — organized by room or floor so it can be priced accurately. It’s the electrical equivalent of a quantity takeoff in civil work: get the count wrong here, and every downstream number (material order, labour cost, final quotation) is wrong too.
What an Electrical Takeoff Sheet Should Include
| Column | Purpose |
|---|---|
| Room / Area | Groups points by location so nothing gets double-counted or missed |
| Point Type | Light, fan, 5A socket, 15A socket, AC point, exhaust, etc. |
| Quantity | Count of that point type in the room |
| Wire Gauge | 1.5mm² for lighting, 2.5-4mm² for power circuits |
| Conduit Length | Metres of PVC conduit run per point/circuit |
| Rate | Material + labour rate per point |
| Amount | Quantity × Rate, rolled up into the BOQ |
Electrical BOQ for Residential vs Commercial Buildings
The takeoff structure is the same, but scale and complexity differ:
Residential (2-3BHK): 80-150 points total, single-phase supply, one or two distribution boards, straightforward room-wise layout. An electrical BOQ for a residential building is usually a single sheet, room by room.
Commercial: An electrical BOQ for a commercial building adds three-phase distribution, panel boards per floor, higher-capacity cabling, fire alarm and emergency lighting circuits, and often a separate takeoff for each floor or zone before rolling up into one master BOQ. Load calculations and cable sizing become load-bearing parts of the estimate, not just a point count.
💡 Where electrical quotations lose accuracy
Most electrical quotations for house wiring in Excel price per point with a flat average rate — which overcharges simple rooms and undercharges complex ones (kitchens, utility areas). Our Civil Work Estimate & BOQ Template includes an electrical BOQ sheet that prices each point type separately and rolls straight into your project’s overall cost estimate.
How to Build an Electrical Quotation for House Wiring in Excel
- List every room from the floor plan, including balconies, utility areas, and external points.
- Count points per room by type — lights, fans, 5A sockets, 15A sockets — using the drawing or a site walk-through.
- Assign wire gauge and conduit length per circuit, based on distance from the DB.
- Apply material + labour rate per point, split separately so you can update either independently as prices change.
- Sum by room, then by floor, to get a room-wise and whole-house total — this is what makes the quotation easy for a client to review and trust.
- Add DB, MCB, and earthing as separate lump-sum lines, since these don’t scale per point the way wiring and sockets do.
House Wiring Cost Calculator: The Quick Version
For a fast budget check before building the full takeoff, a simple house wiring cost calculator works off a per-sq-ft or per-point average:
| Quality Level | Rate per Sq Ft | 1000 Sq Ft House |
|---|---|---|
| Budget/Basic | ₹75–110 | ₹75,000–1.1 Lakh |
| Mid-range/Good | ₹110–180 | ₹1.1–1.8 Lakh |
| Premium/Luxury | ₹180–300+ | ₹1.8–3 Lakh+ |
This is a useful budgeting thumb rule, but it won’t hold up as an actual client quotation — for that you need the room-wise takeoff, because point density and quality level vary a lot room to room.
Build It Yourself, or Start From a Ready Template
A one-off electrical takeoff in Excel is manageable to build. What’s harder to get right on the first try is a reusable sheet — one that scales from a 2BHK to a commercial floor plate without redesigning the structure each time, and links cleanly into your overall project BOQ.
Our Professional Civil Work Estimate & BOQ Template includes an electrical BOQ sheet alongside the civil BOQ, Rate Analysis, and Bar Bending Schedule — so your electrical estimate feeds into the same abstract of cost as the rest of the project, instead of living in a separate file.
Special Launch Offer
Get Electrical + Civil BOQ Together for ₹249 ₹999
Electrical BOQ, Civil BOQ, Rate Analysis, BBS & Abstract of Cost — one linked Excel file
Frequently Asked Questions
What is an electrical takeoff spreadsheet?
A structured, room-wise count of every electrical point, wiring run, and fitting in a project, used to price an electrical BOQ or quotation accurately.
How is an electrical BOQ for a commercial building different from residential?
Commercial BOQs add three-phase distribution, per-floor panel boards, load calculations, and often fire/emergency circuits — usually broken into floor-wise or zone-wise takeoffs before rolling up into one master BOQ.
Can I make an electrical quotation for house wiring in Excel myself?
Yes — list rooms, count points by type, apply material + labour rates per point, and sum by room and floor. The main risk is using one flat average rate instead of pricing point types separately.
Is a house wiring cost calculator accurate enough for a quotation?
A per-sq-ft calculator is good for early budgeting but not accurate enough for a final quotation — actual point count and room-wise detail matter more as project size grows.
Related: Best BOQ Format for Electrical Work in Excel · Electrical Wiring Cost per Square Foot in India · BOQ Template in Excel: Free Format Guide