Multi Family Dwelling Load Calculation Worksheet Excel

Building a Practical Multi Family Dwelling Load Calculation Worksheet in Excel

Most people grab a blank spreadsheet and start typing numbers without a plan. That usually ends in messy formulas that break when you adjust one value and realize three other cells didn't recalculate properly. The first thing I'd do is map out exactly what NEC 220.82 and 220.84 require before opening the workbook. Write down your inputs on paper first. You'll save hours of rework.

Here is the structure that actually works in practice. Typical inputs I include: Number of dwelling units (must be 3 or more for the optional multi-family method under 220.84). Square footage per unit. Number of small appliance branch circuits (usually 2 per unit). Number of laundry branch circuits (usually 1 per unit). Rated kW of electric range or wall oven per unit. Rated kW of electric dryer per unit. Rated kW of HVAC system per unit. Rated kW of water heater if electric. Voltage and phase of the service. Whether any cooking/dryer loads are gas instead of electric.

Once the inputs are isolated, build the calculation sheet below or on a separate tab. The flow follows the code sequence: general lighting and general use receptacle load, small appliance and laundry loads, fixed appliance loads, HVAC and motor loads, then demand factors applied in the proper order. Feeders and services are calculated last.

The Optional Method (NEC 220.84)

This is the path most electricians and engineers take for multi-family dwellings with three or more units. It is significantly faster than the standard method and produces the same results for typical residential construction. The formula is essentially straightforward once you stop fighting it: you sum the first 3 units at 100 percent, the next 3 at 60 percent, and everything beyond that at 40 percent. But the individual unit loads need to be assembled correctly first, which is where spreadsheets go wrong.

A proper unit load assembly under 220.84 includes: General lighting at 3 VA per square foot. Small appliance circuits at 1,500 VA each. Laundry circuit at 1,500 VA if present. Fixed appliances including the range, dryer, water heater, and any other permanently connected equipment. HVAC at the nameplate rating, including the larger of the heat or cooling load, plus any permanently installed motors that do not have a continuous duty rating factored in yet. The total of these items for one unit, multiplied by the number of units, then reduced by the demand factors from Table 220.84. One detail that trips people up constantly. When you have a mix of gas and electric ranges, the demand factor applies to the total number of units, but only the electric ranges count toward the range load. Gas ranges simply disappear from the calculation. I spent an entire afternoon on a project rechecking my numbers because I had accidentally included gas ranges in the unit count for the demand table. The service size dropped by nearly 40 kVA once I corrected it. Always verify the fuel source for every major appliance before you lock in the spreadsheet.

Practical Pitfalls Nobody Talks About

The biggest problem I see with Multi Family Dwelling Load Calculation Worksheet Excel implementations is the handling of noncontinuous versus continuous loads. HVAC systems with electric heat running full capacity are treated differently than lighting and receptacles. Lighting and general use loads are assumed to be noncontinuous. Heat pumps in heating mode drawing full current can easily push your conductor sizing and overcurrent protection decisions if the spreadsheet does not flag them. Make sure your worksheet clearly labels which loads are continuous so you can apply the 125 percent multiplier where required.

Another issue is demand factor stacking. Some worksheets apply the 220.84 demand factor to the entire total including HVAC, then apply additional diversification on top. That double reduction is incorrect. The 220.84 table already accounts for the diversity of the building. You apply it once to the summed load of all the components, not repeatedly. I have seen this error produce undersized services that pass inspection by accident but are genuinely risky under simultaneous full load conditions. Unit voltage mismatches are also common. If your building has both 120/240 volt single phase and three phase distribution, the per-phase balancing in your spreadsheet needs to reflect that. A three-phase service feeding multiple feeders requires you to divide the total calculated load by the square root of three and the system voltage to get line current. Getting this wrong throws off every downstream component size, from the main breaker to the conduit fill calculations.

What the Worksheet Cannot Do For You

Excel will not replace a licensed professional reviewing the calculation for a formal plan submission. The software follows whatever logic you build into it. If you build it wrong, the output will look clean and authoritative while being completely incorrect. This is the most dangerous kind of error because it looks right.

The optional method also assumes typical residential occupancy patterns. If a building has unusually high simultaneous load potential, such as a hotel with commercial kitchen equipment in each unit or a luxury condominium with individual heat pumps rated above 10 kW per unit, the standard demand factors may not provide adequate safety margins. In those cases, the standard method under 220.82 with per-unit detail and stricter demand allowances is the safer choice. The spreadsheet should still be usable, but you will need to switch calculation branches, and a single worksheet trying to handle both paths simultaneously tends to become unmaintainable. For most standard apartment and condo buildings, a well-built worksheet following 220.84 will cut the calculation time from roughly two hours of manual work to under fifteen minutes. The remaining time is spent verifying inputs, checking for gas versus electric equipment mismatches, and confirming the local Authority Having Jurisdiction accepts the optional method for your specific project. Some jurisdictions have amendments that override or modify the standard NEC tables, and no spreadsheet accounts for those unless you specifically build them in. If you are building this from scratch, start with the input cells clearly separated at the top, use named ranges for every major value, and lock the formula logic behind a verification row that checks the unit demand against a known benchmark before you trust the final service size. I keep a simple copy-paste calculation block for each unit type because even within one building, a penthouse unit and a ground floor unit sometimes have different square footage and appliance configurations. The demand factors still apply to the aggregate, but the per-unit assembly needs to accommodate that variation.