Electrical estimate template for Excel and PDF
An electrical estimate template turns takeoff quantities into a price: quantity x unit cost for material, quantity x labor unit for hours, hours x your labor rate, then general conditions, overhead and profit. The free Excel file below does that math with working formulas, and the PDF is a one-page form for residential and small commercial estimates. You supply the prices and labor units; the template supplies none.
Download the free electrical estimate template
Free download, no signup. The Excel file is a full electrical estimating spreadsheet with formulas, frozen headers, print areas, data validation and an Instructions tab. Nothing is locked.
How the electrical estimate template builds a price
The Estimate tab extends each line, and the Summary tab stacks the costs and markups in this order:
Material total = sum of (qty x unit cost) + waste allowance + sales tax
Labor total = sum of (qty x labor unit) x difficulty factor x burdened labor rate
Direct cost = material + labor + equipment + subcontracts + permits + general conditions
Bid price = direct cost x (1 + overhead %) x (1 + profit %) + bond
Wire and conduit are usually priced per 100 or per 1,000 feet. Pick C or M in the Unit column and the template divides the extension for you, for both the material cost and the labor unit, so you can type prices the way your supplier quotes them. Settle the trade sizes before you price them: the conduit fill calculator gives the smallest raceway for each group of conductors.
How to fill in the Excel estimate
- Fill in the project block on the Estimate tab.
- Enter quantities from your takeoff. The electrical takeoff sheet gives device and fixture totals by type; measured conduit and wire go in the branch and feeder sections.
- Enter material unit costs from a current supplier quote. Old prices are the most common reason an estimate is wrong on copper-heavy work.
- Enter a labor unit for each line, in hours per unit (or per 100 or 1,000 feet for C and M).
- On the Summary tab, enter the sales tax rate for materials, a difficulty factor, your burdened labor rate and the other direct costs.
- Enter overhead and profit as markup percentages and, if the job needs one, a bond rate. Read the Checks block to see the resulting margin.
- Carry the rounded bid price to your proposal. The electrical bid template has the scope, exclusions and terms.
Where labor units come from
Labor units are the hours to install one unit of something: a receptacle, a fixture, 100 feet of 3/4 in. EMT. They decide most of an electrical bid, and they are the one input no template can give you honestly.
Your own job history
The most accurate units are measured from finished jobs: hours charged to a cost code divided by the quantity installed. If a job logged 1,240 hours to devices and installed 3,100 devices, that job ran 0.40 hours per device (example figures). Track a few jobs per item and the Labor units tab becomes your shop's standard.
Published labor unit manuals
The NECA Manual of Labor Units is a long-standing reference for electrical labor, sold in book, PDF and online subscription form1. It is copyrighted, so this template does not reproduce any of its values. If you own a copy, enter the units you use in the Labor units tab and adjust them to your crews.
Estimating software databases
Electrical estimating programs ship with item databases that carry labor units. If you use one, the template is mostly useful for small jobs and for checking totals. The electrical estimating software guide compares them.
Whatever the source, adjust for conditions with the difficulty factor instead of editing every line. Use 1.00 for normal conditions and go higher for work at height, occupied buildings, phased work or tight schedules.
Markup vs margin
Markup is a percent added to cost. Margin is the percent of the selling price that is profit. The same dollars give a smaller margin than markup, and mixing them up is a common way to bid below the profit you meant to carry. The template enters overhead and profit as markups and shows the resulting margin in its Checks block.
| Markup on cost | Price on $100,000 of cost | Margin of price |
|---|---|---|
| 10.0% | $110,000 | 9.1% |
| 15.0% | $115,000 | 13.0% |
| 20.0% | $120,000 | 16.7% |
| 25.0% | $125,000 | 20.0% |
| 30.0% | $130,000 | 23.1% |
To hit a target margin, divide cost by (1 minus the margin): $100,000 / 0.90 = $111,111 for a 10% margin, which is an 11.1% markup. The construction cost estimator lets you type profit either way and shows the other.
Electrical work estimate sample
A worked example through the Summary tab, with illustrative inputs only (they are not pricing guidance): material from the Estimate tab of $18,000, 7% sales tax, 220 base labor hours, a difficulty factor of 1.10, a $65 burdened rate, $600 for a lift, $450 in permits, $1,500 of general conditions, 12% overhead and 10% profit.
| Material with tax | $18,000 + $1,260 = $19,260 |
|---|---|
| Labor | 220 hrs x 1.10 = 242 hrs x $65 = $15,730 |
| Direct cost | $19,260 + $15,730 + $600 + $450 + $1,500 = $37,540 |
| Overhead (12%) | $4,504.80, cost plus overhead $42,044.80 |
| Profit (10%) | $4,204.48 |
| Bid price | $46,249.28, rounded up to $46,300 |
| Checks | Total markup over direct cost 23.2%. Profit margin 9.1% of the price. |
Residential electrical estimating spreadsheet and PDF form
For house wiring and small service work, the same Excel file works as a residential electrical estimating spreadsheet: delete the sections you do not need, use the branch wiring section for NM or MC cable, and put service upgrades under service and distribution. For an electrical house wiring estimate in Excel, enter cable per 100 or 1,000 feet and boxes and devices each.
The PDF is an electrical estimate for residential work you can fill in by hand at the kitchen table: customer and job address, up to 16 line items with material, labor hours and labor dollars, a summary box with tax, permits, overhead and profit, scope notes, what is not included, and signature lines for both parties. For a rough number before you do a full estimate, the electrical estimate calculator and the electrical cost per square foot guide help.
Common mistakes in electrical estimates
- Using a labor rate that is only the wage. A burdened rate adds payroll taxes, insurance and benefits.
- Adding profit percent to overhead percent and applying the sum once, then calling it margin.
- Leaving out general conditions: supervision, trucks, small tools, temporary facilities and cleanup cost money on every job.
- Pricing wire per foot with a supplier price per 1,000 feet. The C and M units in the template exist to prevent that.
- Taking device counts from a takeoff that never got checked against the fixture schedule.
On commercial work, the takeoff is where most of the hours go. AmpCount counts devices and fixtures on vector PDF sets from the legend and exports the quantities per sheet to Excel, so they can be pasted into the Estimate tab. It does not price material or apply labor units; that part stays in this template or your estimating software. For what changes when you move a commercial shop off spreadsheets, see the guide to estimating software for commercial electrical work.
Questions about the estimate template
Is the electrical estimate template free?
Yes. Both files download directly with no account or email, and you can change them however you like.
Does it include material prices or labor units?
No. Prices change by region and month, and published labor units are copyrighted. The template has the formulas; you enter your own numbers.
Can I use it in Google Sheets?
Yes. Open the .xlsx with Google Sheets; the formulas, dropdowns and frozen rows carry over.
Count the devices, check the numbers
AmpCount reads the legend on a vector PDF set, counts every electrical device and fixture on every sheet, keeps uncertain marks out of the count until you confirm them, and checks fixtures against the schedule. $149 a month or $1,490 a year for a team of up to 3, cancel anytime, full refund within 14 days.
Keep reading
Sources
Manual names are trademarks of their owners. This template does not include values from any published labor unit manual.