Report this item to Etsy

Off Grid Solar Calculator Excel, Panel and Battery Sizing Spreadsheet, Inverter Sizing

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

Seller's description

Plan an off-grid or hybrid solar system from your own daily loads: PV array, battery bank, charge controller and inverter, with a string voltage check and a simple payback view.

WHAT IT DOES
- Daily load table for up to 40 AC or DC appliances: energy per day, peak load and motor start surge are added up for you
- PV array size from peak sun hours and your losses (temperature, dust, wiring, MPPT, battery)
- Modules per string and strings in parallel, checked against your charge controller or hybrid inverter: cold-weather Voc against max input voltage, hot and cold Vmp inside the MPPT window, current per tracker
- Battery bank from days of autonomy and depth of discharge (LiFePO4 or lead-acid): units in series and parallel
- Next standard charge controller and inverter size, with a surge check
- Cost by component and a 25-year cumulative cash view (energy price rise, O&M, battery replacement)
- Every check line turns green (OK) or red (FAIL) and says why

WHAT'S INSIDE (1 Excel file + a printable PDF of the example)
Start Here, Loads, System Design, Cost & Payback, Lists (standard sizes you can edit). Ships with a worked example: an off-grid cabin on a 48 V LiFePO4 bank.

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice. Metric units, any currency. No macros.

GOOD TO KNOW
- Digital download. Nothing is shipped.
- This is a monthly-average energy balance, not an hour-by-hour simulation. For a bankable design use PVsyst, SAM or similar.
- Estimation aid: check against your local rules (for example IEC 62548 or NEC 690) and the equipment datasheets, and have a qualified installer or engineer review the design.

HOW THIS WAS MADE
The workbook was designed and built with the help of AI tools. Scripts recalculated the file in LibreOffice and compared it with a separate Python calculation of the same method, across 8 test systems including edge cases.

For your own use and your company's projects. Please do not resell or share the file.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

NowPrice:$4.27

Original Price: $5.69

Loading

25% off

•

Sale ends on November 16

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

May include: A digital spreadsheet interface titled Off-Grid Solar + Battery Sizing Calculator by tobulab. It displays a Daily Load Table and System Design window with technical data, including PV array size, voltage, and current specifications.

Plan an off-grid or hybrid solar system from your own daily loads: PV array, battery bank, charge controller and inverter, with a string voltage check and a simple payback view.

WHAT IT DOES
- Daily load table for up to 40 AC or DC appliances: energy per day, peak load and motor start surge are added up for you
- PV array size from peak sun hours and your losses (temperature, dust, wiring, MPPT, battery)
- Modules per string and strings in parallel, checked against your charge controller or hybrid inverter: cold-weather Voc against max input voltage, hot and cold Vmp inside the MPPT window, current per tracker
- Battery bank from days of autonomy and depth of discharge (LiFePO4 or lead-acid): units in series and parallel
- Next standard charge controller and inverter size, with a surge check
- Cost by component and a 25-year cumulative cash view (energy price rise, O&M, battery replacement)
- Every check line turns green (OK) or red (FAIL) and says why

WHAT'S INSIDE (1 Excel file + a printable PDF of the example)
Start Here, Loads, System Design, Cost & Payback, Lists (standard sizes you can edit). Ships with a worked example: an off-grid cabin on a 48 V LiFePO4 bank.

WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice. Metric units, any currency. No macros.

GOOD TO KNOW
- Digital download. Nothing is shipped.
- This is a monthly-average energy balance, not an hour-by-hour simulation. For a bankable design use PVsyst, SAM or similar.
- Estimation aid: check against your local rules (for example IEC 62548 or NEC 690) and the equipment datasheets, and have a qualified installer or engineer review the design.

HOW THIS WAS MADE
The workbook was designed and built with the help of AI tools. Scripts recalculated the file in LibreOffice and compared it with a separate Python calculation of the same method, across 8 test systems including edge cases.

For your own use and your company's projects. Please do not resell or share the file.

  • Designed by
  • Item type
    Digital download
  • Digital file type(s)
    1 ZIP
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 25, 2026