HOME BATTERY PLANNER · YOUR METER DATA · YOUR RATE · RUNS IN YOUR BROWSER

What would a home battery have saved you last year?

Installers quote battery savings from a typical house and a hopeful controller. This runs a battery hour by hour through a year of your own smart-meter data (with your solar exports in it) on your own rate plan, in the two modes batteries are usually set to, self-powered and time-based, and next to the perfect-foresight ceiling, the most any schedule could have saved. It sizes the battery and compares rate plans with and without one.

Arithmetic on what you enter. Not financial, tax, legal or engineering advice, and not a quote. The example meter data is a synthetic placeholder and the example rate plans use invented prices: type your own plan from your utility's tariff sheet. Your installer, your utility's tariff and your interconnection agreement decide what a real battery may do.

1. Your meter data

In your utility account look for Green Button or Download my data (Texas: Smart Meter Texas). Choose electric usage, hourly or 15-minute readings, the last 12 months. With solar, the file must include what you sent to the grid: negative readings, a received column, or a received series in the XML.

2. Your rate plan (or several, to compare)

One line per price. import: 0.32 prices every hour; a later line with months, a day type or hours overrides it for those hours, so write the general price first: import jun-sep weekdays 16-21: 0.55. Hours end before the second number. export: is the credit per kWh sent to the grid, by period like imports, or export: import - 0.03, or an hourly table (export table weekdays: then 12 lines of 24 credits, January first). fixed: is dollars a month; holidays: weekend prices US federal holidays as weekends. Separate plans with a line of ---.

3. The battery

Leave the cost blank for savings only. Subtract any incentive you are sure you qualify for from the cost; this page assumes none.

How it works

Your file is turned into net kWh for every hour (use minus solar). A battery behind the meter changes only what flows through it, so each mode replays the year: self-powered stores solar the house is not using and covers the house whenever it would draw from the grid; time-based stores spare solar but discharges only in each day's highest-priced hours (and, if allowed, fills from the grid in the cheapest ones). The ceiling is a dynamic programme that knows the whole year in advance; checked against an exact linear programme (HiGHS) it came within 0.21% of the optimal saving in every one of 32 test cases. Losses are the square root of the round trip each way; the reserve is never spent; every mode starts the data at the reserve. Each hour is billed at its import price or credited at its export credit.

Measured on forty simulated California homes with solar (NREL ResStock, real 2018 weather): with a low export credit, self-powered reached a median 97% of the ceiling and the peak-only rule 25%; with exports credited near retail, self-powered lost a median $12 a year. The write-up has the numbers.

Not decided here: whether your tariff, incentive or interconnection agreement allows grid charging or battery export; monthly or annual netting rules (credits are counted hour by hour in full; some plans pay year-end surplus at a lower rate); demand charges; battery wear and warranty limits; outages; taxes; tariff changes over the battery's life; financing.

Questions

Is a home battery worth it with solar?

It depends mostly on how your utility credits exports. Where exports earn far less than imports cost (California's net billing tariff, often called NEM 3, is the best-known case), storing midday solar for the evening is worth close to the full price gap on every kWh. Where exports earn about what imports cost (one-for-one or retail-minus net metering), storing solar earns little or nothing, and a battery only pays through time-of-use price differences. This tool bills your own year of meter data both ways.

Self-powered or time-based mode?

On forty simulated California homes with solar and a low export credit, the self-powered setting reached a median 97% of the perfect-foresight ceiling, and a battery that waits for the peak window reached 25%, because it stays full and wastes the next day's solar. Where exports are credited near the retail price the order reverses. Run your own data: the tool shows both.

What size battery do I need?

Savings flatten once a battery can hold the evening's use. In the forty-home check, going from 13.5 to 20 kWh added a median $7 a year per extra kWh under the low-export example plan. The size table shows the same curve for your own data.

Where do I get my data?

Most US utilities with smart meters have a Green Button Download My Data button in the online account; Texas households use Smart Meter Texas. Download 12 months of hourly or 15-minute electric usage. With solar, make sure the file includes energy sent to the grid (negative values or a received column).

Related free tools: the solar payback calculator for the panels themselves, the Texas electricity plan checker for retail plans billed on your own usage, and the demand charge interval analyzer for a business meter with a peak-shaving battery.