Free load calc · Excel

Free Electrical Load Calculation Worksheet

NEC Article 220 service load calcs for dwellings (standard and optional method), multifamily, and commercial buildings. You enter the demand factors from your adopted code; the sheet does the math, converts to amps, and checks the service size you pick.

  • Dwelling standard method — lighting, appliances, dryer, cooking, heat/A/C, motor, EVSE
  • Optional method (220.82 / 220.83) + 220.84 multifamily block
  • Commercial tab with 125% continuous loads and receptacle demand
  • Your code values as inputs — every pre-fill cites its NEC section
  • Amps at 240 V and 208 V single-phase, 208 V and 480 V three-phase
  • Service size check against the rating you select
  • Live formulas, print-ready, sign-off block

Load Calculation Worksheet

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Dwelling – Standard

Article 220 Part III, line by line: general lighting and demand, 220.53 appliances, dryer, Table 220.55 cooking, noncoincident heat/A/C, 25% largest motor, EVSE. Total VA, amps, service check.

02

Dwelling – Optional

220.82 general loads at nameplate with first-block / remainder factors and the largest heat/A/C option; switch to 220.83 for existing homes; 220.84 multifamily block.

03

Commercial

Unit load vs. actual lighting, continuous loads at 125%, receptacle demand, signs, kitchen equipment, HVAC, largest motor, growth allowance, and amps at 208 V / 480 V.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

How do you calculate the electrical load for a house?

Under the NEC standard method (Article 220, Part III) you add the general lighting load (3 VA per square foot), two or more 1,500 VA small-appliance circuits and a 1,500 VA laundry circuit, apply the lighting demand factors, then add fastened-in-place appliances (75% when there are four or more), the dryer, the cooking demand from Table 220.55, the larger of heating or air conditioning, 25% of the largest motor, and loads like an EV charger. Divide the total VA by 240 V for a single-phase service.

What is the difference between the standard and optional method?

The standard method applies a separate demand factor to each type of load. The optional method in 220.82 lists every general load at nameplate, takes the first 10 kVA at 100% and the rest at 40%, then adds the largest heating or A/C option. The optional method usually gives a smaller number for all-electric homes and can only be used where the dwelling meets 220.82(A). Existing dwellings use 220.83.

Why does the worksheet make me enter the demand factors?

Demand factors and table values change between NEC editions and local amendments, and the 2023 NEC renumbered much of Article 220. The worksheet pre-fills only a few common values with their section numbers (3 VA/ft², 1,500 VA circuits, first 3,000 VA at 100%, the 220.53 75% factor, the 5,000 VA dryer minimum and the 25% largest-motor adder). You enter the rest from the code your AHJ adopted, so the calc matches your edition.

How do I convert VA to amps for a three-phase service?

Divide the total VA by the line-to-line voltage times the square root of 3 (1.732). A 96,000 VA load at 208Y/120 V is 96,000 ÷ (208 × 1.732) ≈ 267 A; at 480Y/277 V it is about 116 A. The worksheet shows amps at 240 V and 208 V single-phase and at 208 V and 480 V three-phase, assuming the load is balanced across phases.

Does the calculated load tell me what size service to install?

It tells you the minimum. The service you pick is your call — most contractors round up to the next standard rating and leave room for EV charging, heat pumps, and solar or battery storage. The worksheet checks the rating you select against the calculated amps and shows what percent loaded it is.

A load calc that matches your code book

Every electrical permit starts with a load calculation, and every plan reviewer checks it against the NEC edition their jurisdiction adopted. This free Excel worksheet follows NEC Article 220 line by line and cites both the 2023 and 2020 section numbers, so the calc reads the way the inspector expects.

Demand factors are inputs, not buried constants: you enter the values from your adopted code, and only a handful of common ones are pre-filled with their section references. The result is total VA, amps at 240 V, 208 V and 480 V, and a check against the service size you pick. Carry the loads to your panel schedule template when you lay out the panels.

Built by a licensed electrical contractor. When you are ready to run the whole job — crews, daily reports, change orders and job cost — Field PM does that from the field up.

How to do an NEC service load calculation, start to finish

A load calculation answers one question: how big does the service (or feeder) have to be for this building? The inspector will ask for it with the permit application, the utility will ask for it before they set a transformer, and the owner will ask why you're quoting a 400 A service when the neighbor has 200 A. The free worksheet above does the math for you. This guide explains what goes on each line, which NEC sections apply, and the mistakes that get load calcs kicked back at plan review.

One thing up front: use the NEC edition your AHJ adopted. The 2023 NEC reorganized Article 220 — the dwelling 3 VA per square foot moved from Table 220.12 to 220.41, the non-dwelling unit load table became Table 220.42(A), the lighting demand factors moved to Table 220.45, and non-dwelling receptacle demand moved from 220.44 to 220.47. The method didn't really change, but the section numbers did, and plan reviewers notice. Every line in the worksheet shows both the 2023 and 2020 numbers.

Standard method for a dwelling (Article 220, Part III)

The standard method applies a separate rule to each kind of load, then adds them up. Here's the order the worksheet follows.

1. General lighting, small-appliance and laundry circuits

Measure the floor area from the outside dimensions. Leave out open porches and unfinished spaces that can't be adapted for future use. Note that the 2023 NEC no longer excludes garages in 220.5(C) — if you're on 2023, the garage counts. Multiply by 3 VA per square foot (220.41 in 2023, Table 220.12 in 2020). Add 1,500 VA for each small-appliance branch circuit — at least two — and 1,500 VA for the laundry circuit (220.52). Bathroom circuits are not added.

Then apply the lighting demand factors: for a dwelling, the first 3,000 VA at 100% and the next block at a reduced percentage, with a further step for very large loads. The worksheet pre-fills the first two steps with their table reference and leaves the top step for you to enter — look it up in our NEC general lighting load guide or your code book.

2. Fastened-in-place appliances (220.53)

List every appliance that's fastened in place: water heater, dishwasher, disposer, built-in microwave, trash compactor, well pump. Don't include the range, dryer, space heating, or air conditioning — they have their own rules. When there are four or more, 220.53 lets you take 75% of the total. The worksheet counts the appliances and applies the factor automatically at the threshold you set.

3. Dryer (220.54)

Use 5,000 VA or the nameplate rating, whichever is larger. The worksheet handles the "larger of" automatically. For five or more dryers (multifamily), enter the demand percentage from Table 220.54.

4. Cooking appliances (220.55)

This is the line people get wrong most. Table 220.55 depends on how many appliances there are, their kW rating, which column you're allowed to use, and the notes under the table (note 4 covers a cooktop and up to two wall ovens in the same room). The worksheet deliberately makes you enter the demand VA instead of the nameplate — see how to read Table 220.55 for worked examples.

5. Heating or air conditioning, not both (220.60)

Heating and cooling don't run at the same time, so 220.60 lets you count only the larger of the two. Enter fixed electric heat at 100% (220.51). If you have a heat pump with strip heat, the compressor and strips can run together in heat mode — put both on the heating line. The sheet takes the larger number.

6. Largest motor

Add 25% of the largest motor in the calc (220.50 and 430.24). On most houses that's the A/C compressor. Use the nameplate — or the full-load current from the NEC motor tables for general-purpose motors (see our motor full-load current chart) — times voltage.

7. EV chargers and everything else

The 2023 NEC added 220.57: EVSE load is 7,200 W or the nameplate rating, whichever is larger. A 48 A wall charger on a 60 A circuit is 11,520 VA — that alone can push a 150 A house to 200 A. Add hot tubs, well pumps, shop equipment and anything else that isn't already counted.

Optional method (220.82, 220.83 and 220.84)

For a single dwelling served by 120/240 V or 208Y/120 V with service conductors of 100 A or more, 220.82 offers a simpler calc that usually comes out smaller for all-electric homes:

  1. List all "general loads" at nameplate — lighting at 3 VA/ft², the small-appliance and laundry circuits, and every range, oven, cooktop, dryer, water heater and fastened-in-place appliance, plus motors not otherwise counted.
  2. Take the first 10 kVA at 100% and the rest at 40%.
  3. Add the largest of the heating/air-conditioning options in 220.82(C), each with its own percentage.

Existing dwellings use 220.83 — the same idea with a different first block depending on whether heat or A/C is being added. The worksheet's Optional tab covers both: change the first-block VA and remainder percentage to switch.

For three or more dwelling units, 220.84 applies a single demand factor (from Table 220.84, based on the number of units) to the combined connected load, then you add the house loads calculated by the standard method. See our 220.84 multifamily guide for when a building qualifies. And for single-family services, the 310.12 rule lets you size service conductors at 83% of the service rating — see dwelling service conductor sizing.

Commercial service load calculation

Non-dwelling calcs follow the same structure but with different rules. The worksheet's Commercial tab walks through it:

  • General lighting — building area times the unit load for the occupancy from Table 220.42(A) (2023) or 220.12 (2020). If the actual connected lighting on the fixture schedule is higher, it governs. Most commercial occupancies take no lighting demand reduction.
  • Continuous loads at 125% — anything that runs three hours or more (lighting in a store or office, parking-lot lights, water heaters under 422.13, EV chargers) gets 125% for feeder and service conductor sizing (215.2 and 230.42). Mark them "Y" and the sheet applies it.
  • Receptacles — 180 VA per yoke (220.14(I)), then the first 10 kVA at 100% and the remainder at 50% (220.47 in 2023, 220.44 in 2020).
  • Signs, show windows and multioutlet assemblies — 220.14(F), (G) and (H).
  • Kitchen equipment — 220.56 demand factors for three or more units.
  • HVAC — larger of heating or cooling (220.60), plus 25% of the largest motor.
  • Growth allowance — not an NEC requirement, but most engineers carry 20–25% spare. It's a separate line so it's visible.

For existing buildings, 220.87 lets you use the maximum demand from a year of utility data (or a 30-day recording) instead of calculating — often the only way to prove an existing service can take a new load.

Converting VA to amps

SystemFormula100,000 VA equals
120/240 V single-phaseVA ÷ 240417 A
120/208 V single-phase (network)VA ÷ 208481 A
208Y/120 V three-phaseVA ÷ (208 × 1.732)278 A
480Y/277 V three-phaseVA ÷ (480 × 1.732)120 A

Three-phase amps assume the load is balanced. Apartments fed from a 208Y/120 V system get 120/208 V single-phase, three-wire services — divide by 208, not 240, and watch the neutral.

Mistakes that get load calcs rejected

  1. Wrong code edition. Citing 220.12 on a 2023 job (or 220.41 on a 2020 job) is the easiest plan-review comment there is.
  2. Range at nameplate in the standard method. Use the Table 220.55 demand, not 12 kW.
  3. Counting heat and A/C together. They're noncoincident — larger one only.
  4. Forgetting the 25% largest motor.
  5. Missing the EV charger. The owner is going to buy one. Ask.
  6. Skipping 125% on continuous commercial loads.
  7. Treating the calc as the service size. The calc is the minimum; pick the rating with room to grow.

Where the load calc goes next

Once the service is sized, the same loads land on your panel schedules — use the free panel schedule template to lay out circuits and check phase balance, and the voltage drop calculator for long feeders. For conductors, see the wire ampacity chart and standard breaker sizes.

Run the whole electrical job, not just the calc

Field PM was built by a licensed electrical contractor for contractors who run work in the field: daily reports, time and crew costs, change orders, RFIs, QC hold points and job cost in one place, on the phone your foreman already carries. Start a free 30-day trial — no credit card required.

This worksheet is a calculation aid, not engineering advice. The electrical designer of record and the authority having jurisdiction have the final say. Verify every factor against the NEC edition adopted by your AHJ and any local amendments.

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice