Skip to content
SpreadsheetWeb
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In

Energy storage planning demo

Battery Sizing Calculator

Estimate a practical battery bank and solar charging requirement from appliance loads, autonomy, chemistry, voltage, efficiency, and temperature assumptions.

Build a load scenario ↓

Live workbook model

Size storage from the loads that matter

Start with the published example, edit the appliance audit or system assumptions, and the server-pinned workbook recalculates the bank.

Published exampleLiFePO4 · 12 V 100 Ah modules · 48 V system

01

Battery system

Choose the battery technology, module, system voltage, and storage assumptions.

The workbook uses chemistry to derive depth of discharge, round-trip efficiency, and indicative cycle life.
Select a published module size or choose Custom to enter voltage and amp-hour capacity.
The target DC bus voltage used to determine how many battery modules are required in series.
Used only when the Custom battery module is selected.V
Used only when the Custom battery module is selected.Ah
How long the bank should support the entered loads without adequate charging input.days
Leave blank to use the workbook default for the selected chemistry.fraction
The fraction of battery energy delivered as usable AC energy.fraction
Leave blank to use the selected chemistry default.fraction
The coldest temperature the batteries are expected to experience.°C
02

Charging assumptions

Connect the storage estimate to a preliminary solar charging requirement.

Use a conservative worst-month value for year-round solar operation.h/day
The fraction of generated charging energy delivered to the battery bank.fraction
Accounts for wiring, temperature, soiling, mismatch, and similar array losses.fraction
03

Appliance load audit

Enter one appliance type per row. Unused rows stay at zero.

AppliancePower WHours/dayQuantityEnergy Wh/day
—
—
—
—
—
—
—
—
—
—
Total—

Workbook results

Battery bank recommendation

Validated model outputs update after each complete input change.

Workbook model —
Required nominal energy—kWh
Total batteries—modules
Achieved autonomy—days
Recommended PV array—W
View all workbook results
ResultValueUnit
Connecting to the live workbook…

Connecting to the live workbook…

Powered bySpreadsheetWeb
i

Demonstration only

This calculator demonstrates the SpreadsheetWeb platform and provides illustrative preliminary estimates. It does not replace project-specific electrical design, manufacturer guidance, applicable codes, or review by a qualified professional. Independently verify loads, operating conditions, equipment ratings, protection, wiring, charging, and all results before making engineering, purchasing, installation, safety, or financial decisions.

A focused planning model

What the workbook combines

  • Load auditPower, operating hours, and quantity for each appliance group.
  • Storage assumptionsChemistry, voltage, autonomy, efficiency, and temperature.
  • Charging contextPeak sun hours, path efficiency, and PV derating.

Build from your spreadsheet

Convert My Excel Model to a Web App

Explore more examples in the gallery or talk with the SpreadsheetWeb team about your application.

Sign-up for a free accountView more demos

Product

FeaturesGalleryCustomersDevelopers & APITemplates

Solutions

IndustriesMarketingHuman ResourcesFinanceSales

Use Cases

Online CalculatorsSales QuotingTimesheet AppsScored QuestionnairesSearch ApplicationsReporting Applications

Support

User GuideTraining VideosCase StudiesTips

Resources

BlogExcel ApplicationsExcel Tips & TricksExcel FormulasExcel MacrosExcel Templates

About

About UsContact UsServices

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use -

FacebookXLinkedIn