EE And EA Worksheets: A Practical Guide

What These Are

EE and EA worksheets stand for electrical engineering and electrical analysis. They are calculation documents used to determine load requirements, conductor sizing, overcurrent protection, and voltage drop for electrical systems. The kind of worksheet most people actually use is a spreadsheet, usually built in Excel or Google Sheets, that takes input values and returns results based on NEC or IEC formulas. I built my first proper EE worksheet around 2008. I still use a refined version of it today. The basic structure has not changed much. What has changed is how often I see people misusing these tools because the underlying assumptions are wrong.

EE And EA Worksheets

This is the kind of search term people type when they need a practical template rather than a textbook chapter. They want something they can open and fill in. The problem is that most freely available templates are either too simple to be useful or contain errors that create real safety issues. Start with the load list. This is the part everyone rushes through and then regrets later. Write down every connected load, the voltage, the phase, the duty cycle, and the power factor if you know it. The power factor detail is critical and gets ignored constantly. Here is a concrete example. I was working on a small commercial retrofit last year. The contractor's original EE worksheet listed a 5 HP compressor at 230 volts, single phase. They calculated current using the standard formula I = P / V and got roughly 21.7 amps. Then they applied a 125% demand factor and sized the breaker at 30 amps. It looked fine on paper. The compressor tripped the breaker within two weeks of operation. The issue was power factor. The nameplate showed 0.72 PF, not 1.0. The correct current is 5,000 watts divided by 230 volts divided by 0.72, which gives about 30.2 amps. With the 125% factor applied, the breaker needs to be at least 38 amps. The mistake cost us a weekend and a replaced breaker.

The formula itself is straightforward: For single phase: I = P / (V × PF) For three phase: I = P / (3 × V × PF)

Where I is current in amps, P is power in watts, V is voltage, and PF is power factor. If the load is given in horsepower, convert first. One horsepower equals 746 watts. Do not skip that conversion step. It sounds obvious until you see someone calculate current directly from 5 HP without converting.

Common Mistakes

The most frequent error is adding maximum load ratings instead of applying diversity factors. A restaurant kitchen with ten pieces of equipment does not draw ten times the rating simultaneously. NEC demand factors exist for this reason. Residential dwelling units use Table 220.82. Commercial kitchens use Table 220.56. Apply the correct table and do not guess. Another common error is using the wrong conductor ampacity table. THHN wire in a conduit has a different ampacity than THWN wire in the same conduit. The 75-degree column applies to most modern terminations rated 75 degrees. The 60-degree column applies to older devices. Using the wrong table can understate ampacity by 10 to 15 percent. That matters when you are near the limit. A third error is ignoring ambient temperature correction. Conductor ampacity drops as temperature rises. The correction factor from NEC Table 310.15 applies when ambient exceeds 30 degrees Celsius. In a ceiling space on a hot roof, ambient can reach 45 degrees or higher. The correction factor for 45 degrees on the 75-degree column is roughly 0.87. Multiply your conductor ampacity by 0.87 before comparing it to the calculated load.

When This Method Fails

EE and EA worksheets based on standard NEC or IEC formulas do not handle non-linear loads well. Variable frequency drives, LED lighting banks, and computer loads create harmonics. The neutral current in a three-phase system with heavy non-linear loads can exceed the phase current. Standard worksheet formulas do not account for this. If your project has significant harmonic content, you need a dedicated harmonic analysis, usually done with specialized software like ETAP or SKM, not a basic spreadsheet. These worksheets also fail when dealing with non-standard voltages or custom equipment. If you are working with 208Y/120 volt systems in North America or 400 volt three-phase systems in Europe, the basic math still works, but the conductor sizing tables and breaker sizes differ. Using a US-centric template on a European project will give wrong answers. Always verify the code basis and the regional standards before relying on any worksheet. There is also the issue of future load expansion. A worksheet gives you the answer for the load you specify. It does not tell you whether your design leaves enough capacity for the next renovation. I learned this the hard way on a data center project where the client added three more racks six months after commissioning. The main feeder was already at 90 percent capacity with the original load. The fix was replacing the main breaker and upgrading the feeder, which required shutting down half the facility. Building in at least 20 percent spare capacity for future growth is a standard practice that most small projects skip.

A Working Template Structure

Build your worksheet with the following sections. Keep it simple and traceable. Input section: Project name, date, designer, code basis, voltage, phase, frequency, ambient temperature, and any special conditions. Load schedule: Each row should contain the load description, connected load in watts or VA, voltage, phase, demand factor, calculated load, and the resulting current. Add a column for power factor if it varies between loads.

Summary: Total connected load, total calculated load, total current, and the selected overcurrent device and conductor size. Include the voltage drop calculation for the longest feeder or branch circuit. Notes: Any assumptions, exceptions, or items that need a professional review. This section is often skipped, but it is the most important one when a mistake happens.

Where To Find Reliable Templates

Several sources offer downloadable EE and EA worksheets. The National Electrical Contractors Association publishes templates that align with the NEC. The International Electrotechnical Commission does not provide ready-made worksheets, but many engineering firms share internal templates online. Search for "NEC load calculation spreadsheet" or "IEC cable sizing calculator" to find working versions. Verify the formulas against the latest code edition before using any template on an actual project. I have seen templates posted on engineering forums that use outdated ampacity values from the 2014 NEC instead of the 2023 edition. The difference is small but measurable. For a quick starting point, I recommend building your own from scratch using a blank spreadsheet. It takes about an hour, and you will catch errors that templates hide. The structure I described above is easy to set up and gives you full control over every formula.

The Bottom Line

EE and EA worksheets are useful tools, but they are only as good as the inputs and assumptions behind them. A correctly built worksheet reduces manual calculation time from about 45 minutes per load schedule to roughly 10 minutes. That time saving is real. But no worksheet replaces a thorough review by a qualified engineer or electrician, especially for anything beyond a simple residential branch circuit. Double check your units, verify your power factors, apply the correct demand factors, and account for ambient temperature and harmonic content when relevant. The cost of a mistake on paper is a few hours of rework. The cost of a mistake in the field is far higher.