Skip to content

Free battery worksheet

Battery runtime worksheet

A free worksheet for listing daily loads, choosing a reserve target, estimating usable amp-hours, and checking how many 100Ah batteries the plan really implies.

What you get

Turn a calculator result into a usable next step.

The file stays lightweight on purpose: enough structure to capture the parts, assumptions, and checks that matter without forcing every rig into the same plan.

Daily load worksheet

A simple table for listing watts, hours, duty cycle, and daily watt-hours before sizing the bank.

  • Appliance-by-appliance load rows
  • Daily watt-hour total
  • Reserve-day target

Usable capacity math

The worksheet separates nominal capacity from usable capacity so AGM and lithium comparisons are clearer.

  • Depth-of-discharge assumptions
  • 100Ah battery count
  • Reserve margin checks

Charging reality check

Runtime only matters if the system can recover, so the worksheet prompts charger, solar, and generator checks.

  • Solar recovery target
  • DC-DC or shore charger limits
  • Monitor, fuse, and cable questions

How to use it

Use the file after the math, not before it.

The worksheet works best after you have a real calculator result. It slows the decision down just enough to catch fit, safety, recovery, and daily-use assumptions before you buy or build.

1

List the daily loads

Start with watts, hours, and duty cycle for the appliances that actually run when you are off-grid.

2

Choose the reserve target

Decide whether the bank needs to cover one night, a cloudy day, or multiple days before recharge.

3

Check recovery before buying batteries

If charging cannot refill the bank, adding capacity only delays the same problem.

Use this when

You know the appliances you run but not how long the battery bank will last.

You are comparing AGM and lithium usable capacity.

You need to explain why one more battery may not solve a charging bottleneck.

LimitsWhat this resource does not replaceThe resource helps you plan. It does not replace current specs, manuals, code requirements, or installer judgment.
  • Brand-specific battery recommendations without current spec checks.
  • A replacement for battery manuals, BMS limits, or installer review.
  • A one-click answer when loads, reserve days, and recharge windows are still unknown.

Optional follow-up

What the follow-up emails keep from slipping.

The download is useful by itself. The matching follow-up path keeps the next few decisions tied to the same planning problem instead of scattering them across tabs, notes, and shopping carts.

Email 1

Your RV battery runtime worksheet

Deliver the worksheet and show how to turn daily loads into usable amp-hour targets.

Email 2

Why usable capacity changes the answer

Explain lithium vs AGM sizing without making the battery count look simpler than it is.

Email 3

Runtime is only half the system

Connect battery size to recharge windows, charger limits, monitor/shunt choices, and protection.