Skip to content
Template Updated November 13, 2026 5 min read

Electrical estimate template (Excel and PDF)

Free electrical estimate template in Excel and PDF with a device takeoff table, labor rate, overhead and markup, totals by formula, and exclusions.

Clipboard with a blank estimate sheet, pen, tape measure and spools of building wire on a workbench

This is a free electrical estimate template for electricians and small contractors. The Excel file has a project block, a device takeoff table, a labor rate, overhead and markup percentages, a totals block that works by formula, and a space for exclusions and clarifications. The PDF is the same form for printing and filling in by hand.

Five rows in the table are labeled "Example". They show how the formulas behave. Their prices and hours are placeholders. They are not labor units from any book, and you should replace them with your own numbers.

What is in the Excel file

1. Project info. Project name, address, client or general contractor, who prepared the estimate, the date, and the bid due date.

2. Device takeoff table. One row per item:

Column What you enter or what it does
Item Description, for example "Duplex receptacle, 20 A"
Qty The count from your takeoff
Unit each, feet, and so on
Material $ each Your supplier price per unit
Labor hours each Your own hours per unit
Material $ extended Formula: qty × material price
Labor hours extended Formula: qty × hours each
Labor $ extended Formula: extended hours × your labor rate

There are 24 rows. Add more by inserting a row inside the table and copying the formulas down.

3. Rates and totals. You enter the labor rate (dollars per hour), overhead percent and markup percent. The sheet then calculates the material subtotal, total labor hours, labor cost, direct cost, overhead, cost with overhead, markup, and the total bid.

4. Exclusions and clarifications. Ten lines, with a few starter lines you can edit or delete.

Yellow cells are for you to fill in. Everything else is a formula.

How the math works

Every number comes from the same chain:

  1. Extended material = quantity × material price each.
  2. Extended hours = quantity × hours each.
  3. Labor cost = total hours × labor rate.
  4. Direct cost = material subtotal + labor cost.
  5. Overhead = direct cost × overhead percent.
  6. Markup = (direct cost + overhead) × markup percent.
  7. Total bid = direct cost + overhead + markup.

Markup is applied to cost with overhead, not to direct cost alone. If you prefer to add markup to direct cost only, change the markup formula in the totals block. Know which method you use, because the same percentages give different totals.

Worked example

Example, with made-up rates. Not real prices or labor units. Take 20 receptacles, 12 switches and 14 recessed lights, a labor rate of $60 per hour, overhead of 12% and markup of 15%.

Line cost = qty × (material each + minutes ÷ 60 × labor rate).

Item Qty Material each Minutes each Labor each Line
Receptacle 20 $4.50 18 18 ÷ 60 × $60 = $18.00 20 × $22.50 = $450.00
Switch 12 $5.00 15 15 ÷ 60 × $60 = $15.00 12 × $20.00 = $240.00
Recessed light 14 $38.00 30 30 ÷ 60 × $60 = $30.00 14 × $68.00 = $952.00
  1. Direct cost (subtotal): $450.00 + $240.00 + $952.00 = $1,642.00
  2. Overhead, 12%: $1,642.00 × 0.12 = $197.04
  3. Cost with overhead: $1,642.00 + $197.04 = $1,839.04
  4. Total with 15% markup: $1,839.04 × 1.15 = $2,114.90 (rounded)

Price per opening. Divide the total by the number of devices: 46 devices, so $2,114.90 ÷ 46 = about $45.98 per opening. It is a rule-of-thumb sanity check, not a pricing method. It hides large differences between items (here a light costs more than three times a switch), and it shifts with wire runs, ceiling height, wall type and how much equipment is on the job. Compare it only with your own past jobs of a similar type.

Where the numbers come from

The template does not include prices or labor units. That is on purpose.

  • Quantities come from your takeoff: you count the devices on the drawings. If you want a faster count, see electrical takeoff software and the sample takeoffs to judge how an AI count looks on real drawings.
  • Material prices come from your supplier quotes. They change often, so date every quote.
  • Labor hours come from your own history: jobs you have finished and timed. Many contractors also buy a published labor-unit book. If you do, enter the figures yourself from your own copy. We do not copy anyone's published units into this file.
  • Labor rate should be loaded: wages, taxes, insurance and benefits, not just the pay rate.
  • Overhead and markup are business decisions. Use your own numbers.

Filling it in, step by step

  1. Fill in the project block.
  2. Finish your takeoff. Count devices by type and sheet, and separate new work from existing and relocated devices. Our guide on how to read electrical blueprints covers the symbols and the traps.
  3. Delete the Example rows and type your own items. Keep one line per device type.
  4. Enter prices and hours.
  5. Enter the labor rate, overhead and markup.
  6. Write the exclusions: permits, patching, items by others, working hours, and anything the drawings leave open.
  7. Check the total against a rough check, such as price per opening or per square foot from your past jobs. A bid far from that range needs a second look.

Use RFIs to protect the number

Every open question on the drawings changes the price. If a drawing leaves something unclear, write down how you priced it and ask. Our construction RFI template has a "priced as" line for exactly this. Put the same assumption in your clarifications so the estimate and the RFI say the same thing. For a wider view of the bidding process, see how to bid electrical jobs.

Before you finalize, cross-check device counts against the circuit loads with the electrical panel schedule template. Long feeders may need a voltage drop calculator pass, and conduit sizing may need the conduit fill calculator.

What the template does not do

  • It does not calculate wire and conduit lengths. Our takeoff software estimates lengths from the drawings (estimates, not field measurements); in this template you enter feet yourself.
  • It does not include tax, bonds, or payment terms.
  • It does not add a contingency line. Add a row if you carry one.
  • It is not a legal proposal. Your contract terms go in a separate document.

FAQ

References

Sources

This page uses no outside documents. The formulas are plain arithmetic, the layout is our own, and the worked example uses made-up numbers. The template has not been reviewed by a working estimator. Overhead is added before markup, which is one common method; change the formula if you do it differently.

Free to try on a sample

Upload your drawings

Send a PDF drawing set. The takeoff counts every electrical device by sheet, lists the open questions it found in the drawings, and emails you when it is ready. Export the result as CSV or JSON.

Early access: 1 free project up to 5 plan sheets. Paid plans start at $19.90 a month; cancel anytime.

  • Upload a PDF drawing set
  • Devices counted by sheet
  • Open questions listed for you
  • Export to CSV or JSON