Cover of the Off-Grid Solar Sizing Workbook guide

Digital download · Excel, Google Sheets, LibreOffice + PDF

Off-Grid Solar Sizing Workbook

Turn an appliance list and your local sun data into a clear specification for panels, batteries, inverter, charge controller and cable, before you spend money on equipment.

  • Spreadsheet with live formulas, in blank and worked-example editions
  • 14-page guide with the method, a worked example and a kit-listing checklist
  • Three printable worksheets for working around the house with a pencil

$19 USD · checkout opening soon

One email when checkout opens. We will not share your address. See our privacy policy.

Not ready to buy? Download the free load audit worksheet (PDF).

Who it is for

People planning a stand-alone (off-grid) solar system for a cabin, homestead, workshop, tiny house or RV, who want to understand the numbers before comparing kits or talking to an installer. It suits a first system and a careful upgrade alike. You do not need to be an electrician, but you do need to be comfortable typing numbers into a spreadsheet.

It is a planning tool, not a design service. The finished design, protection and installation must follow your equipment manuals and local electrical code, and should be checked by a qualified, licensed electrician where the law or the risk requires it.

What the workbook calculates

1. Load audit

Up to 40 appliances: daily energy, essential-only energy, inverter standby, simultaneous AC load and the peak while a motor starts. Measured readings override estimates.

2. Monthly sun hours

Twelve months of peak sun hours from PVWatts, PVGIS or Global Solar Atlas. Pick the months the system must cover; see the energy balance for every month.

3. Solar array

Array watts from the design month, losses and reserve, rounded to whole panels, with the energy actually delivered in the worst month.

4. Battery bank

Required watt-hours and amp-hours, then a series and parallel layout for the batteries you are considering, and the days of storage it really gives.

5. Inverter

Continuous and surge targets with pass/check against a chosen model, plus the DC current it can draw from the battery.

6. Charge controller

Charge current at full array output, cold-morning string voltage against the controller's limit, and PV current checks.

7. Cable voltage drop

Smallest AWG meeting your drop allowance for each DC run, with a metric mm² minimum. Ampacity and protection are flagged as separate checks.

8. Summary

A one-page specification and every check in one place, ready to compare against kits and quotes.

Look inside

The worked example uses illustrative loads and sun hours; it does not describe a real home or location.

How it differs from our free calculator

The free solar sizing calculator gives a quick first estimate from a single daily energy figure. The workbook builds that figure from an itemised audit, checks every month instead of one, lays out real batteries, checks inverter surge and DC current, catches cold-weather controller overvoltage and sizes cable for voltage drop. It also saves your project so you can revisit it when loads or prices change.

Details

You getZIP file: workbook (.xlsx, blank), workbook (.xlsx, worked example), guide (PDF, 14 pages, US Letter), README
Works withMicrosoft Excel 2010 or later, LibreOffice Calc, Google Sheets (upload to Drive and open with Sheets). Apple Numbers has not been checked.
UnitsWatts, watt-hours, volts, amps; cable lengths in feet or metres; wire sizes in AWG with a metric mm² minimum
Version1.0, November 2026. Corrections are added to the store listing for existing buyers.
DeliveryInstant download after checkout
LicencePersonal or single-household use, including one property or one client project. Please do not resell or share the files.
RefundsIf the files do not open or do not match this description, contact us within 30 days for a refund.

Limits, stated plainly

Questions

Do I need Excel?

No. The workbook uses standard functions that work in Google Sheets and the free LibreOffice Calc.

Is this suitable outside the United States?

The sizing method works anywhere; sun-hour sources cover most of the world. References to the National Electrical Code apply to the US. Elsewhere, follow your own wiring rules.

Will it tell me which brand to buy?

No. It produces a specification and a checklist so you can judge any kit or quote yourself. We do not sell equipment.

Can I see the method before buying?

Yes. Our free guides cover the power audit and sizing method, and the free worksheet includes the load-audit pages from the guide.

Plan the system before you buy the parts

$19 USD · checkout opening soon

One email when checkout opens. We will not share your address. See our privacy policy.