Electrical estimating spreadsheet: what to include and how to check it
An electrical estimating spreadsheet works best as a short chain: quantities in, your own labor units and prices applied, a summary out. Keep every rate in one place, never type numbers inside formulas, and have a second person check the sheet. Spreadsheet research shows errors are common, so the checking matters as much as the layout.
What should an electrical estimating spreadsheet include?
Most shops need five parts, whether they sit on separate tabs or in one workbook.
- Takeoff. One row per item: sheet number, area, description, quantity and unit. Keep the sheet reference so anyone can find the count on the plans.
- Assemblies. What goes into one device, fixture or run: box, device, plate, wire, connectors, supports. Assemblies stop you from pricing a receptacle and forgetting the box.
- Price list. Material cost per unit, with the date and the supplier quote it came from. Prices go stale, so the date matters.
- Labor units. Hours per unit, set by you. For how to set and adjust them, see Electrical labor units explained.
- Summary. Material, labor, burden, overhead, profit and any contingency, on one page. The markup and overhead guide shows how those lines should stack.
Here is a small illustrative layout for the takeoff tab. The rows are made up.
| Sheet | Area | Item | Qty | Unit | Assembly | Checked by |
|---|---|---|---|---|---|---|
| E-101 | Office | 20A duplex receptacle | 32 | ea | REC-01 | Second reader |
| E-102 | Office | 2x4 LED troffer | 18 | ea | LTG-A | Second reader |
How common are errors in spreadsheets?
Common enough that you should plan for them. A 2009 study in the Journal of Organizational and End User Computing, by researchers at Dartmouth, audited 50 operational business spreadsheets. They found errors in 0.9% to 1.8% of formula cells, depending on how an error is defined. Using the stricter definition, only 7 of the 50 workbooks had no wrong results. The other 43 had 281 instances of wrong results.
A rate near 1% sounds small. But even a low rate can mean wrong cells in a sheet with hundreds of formulas. The same paper notes that the older “about 5% of formulas” figure came from only 43 spreadsheets in five studies, and that the rate differs widely from one workbook to the next. Those were business spreadsheets, not estimating sheets, so treat the numbers as a warning, not a forecast for your shop.
Which spreadsheet mistakes cost estimators money?
The Dartmouth audit sorted the errors it found by type. Hard-coding was the most common, at 37.7% of the 483 error instances found under the broader definition. That means a number typed inside a formula instead of a reference to a cell. Reference errors came next at 32.9%, then logic errors at 21.9%. The authors note that most hard-coding errors did not give a wrong answer at the time, but they are traps when an input changes.
In an estimate, those categories look like this:
- Hard-coding. For example, a formula that multiplies by a typed burden rate or a typed tax rate. Next year the rate changes and one tab still uses the old one.
- Reference errors. For example, a total that stops one row short, so a line added at the bottom of the takeoff is left out of the sum.
- Logic errors. For example, markup applied to the wrong base, or overhead counted twice.
- Overwritten formulas. For example, someone types a price over a formula to “fix it fast” and forgets.
How do you check an estimating spreadsheet before a bid?
Use the tools Excel already has, then add a human.
- Show the formulas. The Journal of Accountancy’s guide to debugging Excel spreadsheets describes turning on formula view with Ctrl+~ and zooming out to spot formulas that look different from those around them. It also describes spotting a cell where a typed value replaced a formula.
- Trace precedents and dependents. The same guide explains that Trace Precedents shows the inputs to a formula, and Trace Dependents shows what a cell change will affect before you change it.
- Run Error Checking, but do not trust it fully. The authors warn that the suggested fix may not always be correct. They also say no software tool can catch all logic errors, so formulas still need a manual review.
- Limit what can be typed. Microsoft says data validation restricts the type of data or the values users enter in a cell, such as a dropdown list. A unit column limited to “ea, ft, lf” prevents typos from breaking a lookup.
- Sanity-check the totals. Compare dollars per square foot, labor hours per device and material share of the total against your last few similar jobs. The bid review checklist lists more checks.
- Have a second person read it. Someone who did not build the sheet should test it with a simple job where you know the answer.
When is a spreadsheet enough, and when is it not?
A spreadsheet is a fair fit when you bid a few small jobs a month, one person builds and owns the sheet, and your assemblies are stable. It costs little and you control every cell.
It gets harder when several estimators edit copies, when plan revisions arrive often, or when counting from the drawings takes most of your week. A spreadsheet starts after the counting. It does not read plans or count symbols, so the slowest step stays manual. For a comparison of tools that do take on that step, see Electrical estimating software in 2026.
A spreadsheet hygiene checklist
- Put all rates (burden, markup, tax, waste) on one inputs tab and refer to them by cell.
- Date every price and note its source.
- Lock formula cells you do not want changed, and leave input cells open.
- Keep a version number or date in the file name, and save a copy when the bid goes out.
- Never reuse an old bid file without clearing it and re-checking every input.
- Record who checked the sheet and when.
Where Amptake fits
Amptake is being built to count symbols from your legend and fixture schedule and show each count on the drawing for review, then hand the quantities to your assemblies and your own labor units. The pricing choices and the final check stay with you. Join the waitlist for early access.
This guide is general information, not accounting, legal or business advice. Check your own sheets and bid practices with a qualified adviser.