Free Excel templates

A free electrical estimating template in Excel

A commercial electrical bid from takeoff to price: fifteen items with labor units and material, building wire priced from its copper content, difficulty and supervision factors on the hours, consumables, other direct costs and markup, then a change order priced lump sum and time and material.

The takeoff gives 3,404 raw labor hours and $210,964 of material. Difficulty and supervision factors take the hours to 3,824, or $211,085 of labor at $55.20 an hour. Total cost is $474,378, and at a 21% markup the bid is $574,000.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.

Electrical_Estimating_Template.xlsx (20 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Electrical Contractor Business Owner, which explains the method behind it, chapter by chapter.

Get the book on Google Play →

Or the DRM-free PDF, $19.99 →

Want every model at once?

The Financial Model Library: all 182 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

4 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Wire
Summary
Change order
Checks

What the worked case returns

MeasureValue
Raw labor hours from takeoff3,404
Estimate hours after factors3,824
Composite labor rate per hour$55.20
Labor$211,085
Material with consumables$217,293
Other direct costs$46,000
Total cost$474,378
Markup on cost21%
Bid$574,000
Copper in the estimate (lb)3,680

Building wire is priced from its copper content at the bid's copper price plus a non-copper cost per thousand feet, so a move in copper reprices the wire lines at once. Labor units are hours per unit of each item; factors for difficulty and supervision apply to the total hours, not to each line.

How to use it on your own case

  1. Enter each item's quantity, labor unit and material price on Takeoff.
  2. Enter the copper price and the copper content of each wire size on Wire.
  3. Enter the difficulty and supervision factors, the composite rate, other direct costs and the markup on Summary.
  4. Read the bid, then price a change order lump sum and time and material.

Questions people ask about it

How do electrical contractors estimate a job?

They take off quantities from the drawings, multiply each by a labor unit in hours and a material price, apply factors for difficulty and supervision, add consumables and other direct costs, and mark up the total cost.

What is a labor unit in electrical estimating?

The hours needed to install one unit of an item, such as 0.055 hours per foot of conduit or 1.1 hours per light fixture, under normal conditions.

Why price wire from copper?

Copper is most of the cost of building wire and moves with the metal market. Pricing from copper content keeps the estimate current and shows the exposure if copper rises before purchase.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Electrical Contractor Business Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Electrical Contractor Business Owner. See the book.