EV Fleet · Excel template
Free EV Range Observation Log
A record comparing rated range against what a vehicle actually delivered on real routes — by season and load — so route planning is built on observed range, not the window sticker.
Built and reviewed by the FleetOpsClub research team. Preview it free below. Enter your name and email to unlock the full template and the editable spreadsheet — a CSV that opens in Excel, Google Sheets, or Numbers.
- Editable CSV — yours to keep
- Print or save as PDF
- No spam · unsubscribe anytime
What you get
- A trip record pairing starting and ending state of charge against miles actually driven
- A derived real-world efficiency figure per trip, in miles per kWh or kWh per mile
- Ambient temperature and load-condition fields, since both move real range significantly
- A rated-vs-observed comparison so the gap is visible rather than assumed
- A per-vehicle trend so route assignments can be based on that vehicle's actual cold-weather range, not the spec sheet
How to use it
- 1
Record starting and ending state of charge alongside the odometer reading for each trip worth tracking — a handful of observations per vehicle per season is enough to see a pattern.
- 2
Note the ambient temperature and whether the vehicle was loaded, since both change real-world range more than most drivers expect.
- 3
Calculate the observed efficiency and compare it against the rated figure; a consistent 15-20% gap in cold weather is common and worth planning around rather than treating as a fault.
- 4
Track a few observations per vehicle across a full season before drawing conclusions — one cold snap reading is not the same as a seasonal pattern.
- 5
Feed the seasonal pattern into route assignment: a vehicle with a known cold-weather range gets shorter or interior routes on the coldest days rather than the longest one.
Preview the template
Here's a real sample of the layout — the actual columns and structure you'll work in. The complete template, plus the editable spreadsheet, unlocks the moment you enter your email.
Preview
EV Range Observation Log
Real-world range varies with driving style, cargo weight, HVAC use, and terrain as well as temperature. Treat the figures here as operational planning data, not a warranty or performance claim against the manufacturer.
| Date | Unit | Start SOC | End SOC | Miles Driven | Temp | Load | Observed mi/kWh |
|---|---|---|---|---|---|---|---|
| 2026-01-08 | EV-101 | 95% | 20% | 142 | 18°F | Loaded | 2.1 |
| 2026-04-08 | EV-101 | 95% | 18% | 178 | 58°F | Loaded | 2.6 |
Free unlock
Unlock the full template
Enter your name and email to reveal the complete template and download the editable spreadsheet. You can print it, save it as a PDF, or adapt the columns to your own vehicles. It's a fair trade: the preview costs nothing, and the full file costs you about 20 seconds.
- Editable CSV
- Every row & section
- Branded PDF
Frequently asked questions
Quick answers to the questions buyers usually ask once the category, software, or rollout details start getting more specific.
It varies by vehicle and conditions, but a meaningful reduction in cold weather is normal for EVs generally — battery chemistry is less efficient when cold, and cabin heating draws directly from the battery rather than from waste engine heat the way it does in a combustion vehicle. The point of this log isn't to find the industry-average figure; it's to find your specific vehicles' figures, which is what route planning actually needs.
The rated figure is measured under standardised test conditions that rarely match a real route — your load, your terrain, your climate, your driving pattern. Treating the rated number as a planning figure is how a route that looks comfortably within range on paper runs a vehicle down to single digits on a cold, loaded, headwind day. Observed data from your own operation is what removes that gap.
Enough to cover the range of conditions you actually operate in — a handful of trips per vehicle across a cold spell, a hot spell, and typical conditions gives a usable picture faster than you'd expect. One reading tells you nothing; four or five spread across a season starts to show a real seasonal curve you can plan against.
For routes near a vehicle's range limit, yes — a route that's comfortable in October can be genuinely tight in January once the seasonal efficiency drop is accounted for. This is exactly the decision the log is built to support: knowing a specific vehicle's cold-weather range lets you reassign it to shorter routes on the days it needs to, rather than finding out from a stranded driver.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.