Solar Load Calculation Worksheet

Why Your Solar Load Numbers Look Right But Your System Still Underperforms

I built my first solar load calculation the hard way. 2016, off-grid cabin in northern Vermont. My math said I could run the well pump, fridge, and some lights. The pump tripped three days later. Turns out I hadn't accounted for the compressor startup current spike, which hit 80 amps for about two seconds. The breaker never saw it because it's a thermal-magnetic type, and the inverter sagged so hard the control board reset. That afternoon, I spent six hours reworking the entire load schedule with inrush current included. Never again. That experience is what separates people who do solar load calculations on a spreadsheet from people who actually build systems that work. The gap isn't the math. It's what you choose to ignore until something burns down.

What a Solar Load Calculation Worksheet Actually Is

A Solar Load Calculation Worksheet is a structured spreadsheet or template that breaks down every electrical load in a space—typical or residential, small business, or off-grid installation—into hourly or daily energy consumption figures, then maps those against available solar generation capacity to size batteries, panels, and inverters correctly. It's not fancy. It's usually just rows and columns. But when it's done properly, it prevents the single most common mistake I see: oversizing the array and undersizing the battery, or vice versa, because the load profile was wrong from the start. The core of it has three sections. First, a complete inventory of every device that draws power in your scenario. Second, a load profile that shows when those devices run and for how long. Third, a generation model that accounts for panel output relative to your location, tilt, shading, and seasonal variation. Most people skip section two entirely and wonder why their calculations are wrong.

Building the Worksheet From Scratch

Start with a clean spreadsheet. I use Google Sheets because it syncs across devices and lets me pull real-time irradiance data from NREL's database without leaving the sheet. OpenOffice works fine too. The tool doesn't matter, but consistency does. Create a column for each device category. Not each individual device—categories. You'll have roughly 15 to 30 rows for a typical home. Group things logically: lighting, refrigeration, HVAC, water heating, electronics, miscellaneous. If you have a workshop with welding equipment, that's its own category. Don't lump it in with general electronics. For each category, record four values: average wattage, hours of operation per day, duty cycle if it's a cycling load, and startup inrush current if applicable. The startup inrush row is where most people quit. They see a number like 1200 watts for a fridge and move on. That's the running draw. The startup can be 3 to 7 times that for a compressor motor. Factor it into your inverter sizing, not your daily energy total. Those are two different calculations.

I should say this plainly: a typical residential solar load calculation takes between 45 minutes and 2 hours if you have good data. It takes 3 to 5 hours if you're guessing. The difference is whether you go out to the panel and read the nameplate on each breaker, or you eyeball it and hope. There's a shortcut people use. They look up "average home uses 30 kilowatt-hours per day" and stop. That number exists for a reason—it's a national median. It will be wrong for your specific site. If your home has a heat pump water heater and an EV charger, you're already at 45 kWh before you count the rest. Use the median as a sanity check, not as your starting point.

Common Worksheet Setup Mistakes

I've reviewed probably 200 solar load calculation worksheets over the years, either through consulting work or because people sent them to me after their systems failed to meet expectations. The errors repeat in predictable patterns. The biggest one is phantom load omission. Devices that draw power even when they're "off." A cable box. A router. A smart speaker. An aquarium heater. These typically add 50 to 150 watts of continuous draw that nobody accounts for. In a net-zero setup, that 100-watt ghost load alone can eat 2.4 kWh per day. That's a quarter of a solar panel's worth of energy going nowhere. The second mistake is conflating wattage with watt-hours. Your worksheet needs both. Wattage is instantaneous. Watt-hours is energy over time. If someone writes "my TV is 150 watts" and leaves it at that, you can't calculate daily consumption without knowing how many hours it runs. Force yourself to fill in both columns before moving to the next row.

The third mistake is using the wrong peak sun hours value. Peak sun hours aren't the same as daylight hours. They're a measure of solar irradiance averaged over the day, expressed in equivalent hours of 1000 W/m² irradiance. In Phoenix, you might see 6.2 peak sun hours in June. In Seattle, maybe 4.1 in the same month. Using daylight hours—say, 15 hours in summer—will overestimate your generation by a factor of three or four. I see this error in at least one out of five worksheets. Here's a counter-intuitive point that trips people up: adding more panels doesn't always solve a deficit if your battery bank is undersized. I had a client in New Mexico who added 4 kW of panels to an existing 2 kW system. His battery was 6 kWh. He was still blackout-prone in winter because his loads exceeded his storage capacity before noon. More panels just meant he was clipping generation at midday and still running dark at night. The fix wasn't more panels. It was 12 kWh of battery and a load shed strategy for December.

Using an Existing Solar Load Calculation Worksheet Template

If you want to skip the setup work, there are downloadable Solar Load Calculation Worksheet templates available from several sources. The National Renewable Energy Laboratory has a basic one on their website. BlueBook by Energy Systems Integration Group offers a more detailed version. There are also community-maintained versions on Reddit and various solar forums that incorporate real-world corrections for inverter efficiency, wiring losses, and temperature derating. When you download a template, don't trust it blindly. Check the default assumptions. Some templates assume 85% inverter efficiency. Others assume 92%. The difference matters when you're sizing a system to within 10% of your actual load. A 7% efficiency loss on a 5 kW inverter is 350 watts of heat you didn't account for. Over a 6-hour charging window, that's 2.1 kWh gone. Here's what I always do with any template: I open it and scan every cell that has a hardcoded value. Anything that isn't tied to your specific location or your specific load profile is suspect. Replace the defaults with your numbers. Keep the structure. The formulas inside are usually correct—they're basic multiplication and division—but the assumptions baked into the template are rarely right for your situation.

I also add a column for "derating factors." Most templates include one overall derating factor, usually 0.77 or 0.80, which rolls together temperature, soiling, wiring, and inverter losses. I prefer to split these out. Temperature derating for your specific panel model at your site's maximum ambient temperature. Soiling loss based on how often you clean the panels. Wiring loss based on your conduit length and gauge. When you separate them, you can see exactly which factor is dragging your system performance down. When you lump them together, you get a number that looks clean and tells you nothing.

How to Read the Results and Catch Red Flags

Once your worksheet is populated, the output should show you daily energy consumption in kWh, peak demand in kW, required array size in kW, and required battery capacity in kWh. Compare these numbers against realistic component availability. If your calculation says you need 18.7 kWh of battery, check whether that maps to standard battery modules. A 20 kWh system built from four 5 kWh units is different from a 18.7 kWh system built from random odd-sized modules you found on eBay. Here's the part nobody likes to hear: solar load calculations assume everything works as specified on day one. They don't account for panel degradation, which is roughly 0.5% per year for modern monocrystalline modules. They don't account for battery capacity fade, which can be 20% over five years for lithium iron phosphate at deep cycle duty. They don't account for inverter efficiency dropping as components age. If you're designing a system for a 20-year lifespan, you need to factor degradation into your sizing or plan to replace components before the warranty expires. I once sized a system for a remote research station in Alaska. The calculation was tight—literally 2% generation surplus in the worst month. I flagged it. The engineer on site said the station budget didn't allow for a bigger array. I told them they'd need a generator backup or they'd be running dark for two weeks every March. They chose the smaller array. They called me six months later during a snow event. The panels were buried. The batteries were at 12%. The generator hadn't been serviced in four years. The whole station went dark for 72 hours before someone dragged a shovel to the array. The calculation was correct. The assumption that the array would stay clear of snow was the failure.

When the Worksheet Isn't Enough

Solar load calculation worksheets are a starting point, not an ending point. They work well for static loads with predictable patterns. They break down when your load profile is dynamic or unpredictable. A residential home with a heat pump and a heat pump water heater is borderline. The heat pump cycles based on outdoor temperature, which varies daily. A worksheet gives you an average, but averages don't capture cold snaps. During a polar vortex event in 2022, a client in Iowa saw her heat pump run continuously for 18 hours. Her calculated daily load was 12 kWh. She consumed 31 kWh that day. Her system wasn't designed for that. The worksheet told her the truth about normal conditions. It couldn't tell her about extreme conditions because extreme conditions aren't in the data. Commercial installations have a similar problem. A retail store's load varies dramatically between weekdays and weekends, between summer and winter, between occupied and unoccupied hours. A worksheet based on average weekday consumption will completely mislead you if 60% of your energy goes to a commercial kitchen that only runs Thursday through Sunday.

In these cases, you need something beyond a spreadsheet. You need actual load monitoring data. A clamp meter on the main service panel recording 15-minute intervals for two weeks minimum. That data replaces every estimate in your worksheet with reality. It costs about $200 for a used clamp meter and two weekends of data collection. It saves you from ordering the wrong system size. Another scenario where worksheets fail is grid-tied systems with net metering. If your utility offers true net metering at retail rates, your battery sizing becomes much less critical because you're using the grid as your storage. The worksheet still tells you your production-to-consumption ratio, but the consequences of a mismatch are cheaper. You export surplus and import deficits. The worksheet is still useful for understanding your annual balance, but it shouldn't drive battery decisions in that context. I see too many people size a massive battery bank for a grid-tied system when a modest array and a net metering agreement would handle everything at lower cost.

A Practical Walkthrough

Let me walk through a real example from a project I did last year. Single-family home, 1800 square feet, Ohio. Grid-tied with battery backup planned. The homeowner wanted to reduce their bill and have backup power during outages. I started by going through their electric bill for the past 12 months. Average monthly consumption: 920 kWh. Daily average: 30.7 kWh. That was their baseline. Then I walked through the house and built the load inventory. Lighting: LED throughout. 40 bulbs at an average of 8 watts each, running about 4 hours per day. 1,280 watt-hours. Refrigerator: 150 watts running, 30% duty cycle. 1,080 watt-hours. HVAC: mini-split heat pump, 2,000 watts cooling, 1,200 watts heating, running 8 hours in summer and 6 hours in winter on average. I calculated seasonally, not as an annual average, because Ohio has very different heating and cooling loads.

Water heater: tankless electric, 12 kW, used 45 minutes per day on average. 9,000 watt-hours. This was the surprise. The homeowner hadn't realized how much energy the water heater consumed. It was 29% of their total daily load. Electronics and miscellaneous: TV, router, modem, computers, phone chargers, garage door opener, exterior lights. Combined: about 3,500 watt-hours per day. Total daily load: approximately 18 kWh. Not the 30.7 kWh from the bill. The difference was old habits—the bill included a space that wasn't on the main panel anymore, and the homeowner had replaced several appliances over the years without updating their mental model of consumption.

For the solar array, I used peak sun hours for central Ohio: 4.2 hours annual average, 2.8 hours in December. Required array size for 18 kWh: about 4.3 kW. I sized it at 5 kW to account for degradation and soiling over the expected 25-year lifespan. For the battery, they wanted three days of autonomy. Three days at 18 kWh is 54 kWh. At 90% depth of discharge and 85% round-trip efficiency, that's about 71 kWh of usable capacity, which maps to roughly 80 kWh of installed lithium iron phosphate. That's a significant investment. We discussed it. The homeowner ended up choosing two days of autonomy, which reduced the battery to about 55 kWh installed. That's still substantial, but it changed the economics of the project noticeably. The worksheet didn't solve the decision about battery size. It provided the data. The decision was about what they valued—full backup versus cost savings. The worksheet made the trade-off visible.

Final Thoughts on What Works and What Doesn't

A Solar Load Calculation Worksheet is the single most important document in a solar design project. It's also the most frequently done poorly. The difference between a good one and a bad one isn't sophistication. It's completeness. Every load documented. Every assumption stated. Every edge case flagged. If you're building this for the first time, expect it to take longer than you think. Budget two hours for a simple residential project. Budget half a day for a complex one with unusual loads or off-grid requirements. Don't rush through the load inventory. That section determines everything that follows. If you need a starting point, download a template and modify it. Don't try to build from zero unless you have a specific reason. The structure of an existing worksheet encodes lessons from hundreds of prior installations. Rebuilding that from scratch is unnecessary work.

And when your system doesn't perform as expected—and it probably won't, not on the first try—go back to the worksheet. Compare the actual measurements against your calculated values. The gap between them tells you what you missed. That gap is where the real learning happens.