EV Fleet · Excel template
Free Depot Charging Schedule
An overnight charging plan that allocates limited depot capacity across the fleet by departure time and battery need, so every vehicle leaves with enough range and nothing overloads the site.
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 vehicle list with departure time, battery need, and current state of charge at plug-in
- A charger assignment and time slot per vehicle, sequenced against site capacity
- A total site-load column so the schedule can be checked against the depot's electrical capacity before it's committed
- A priority flag for vehicles that must charge first regardless of slot order
- A completed-vs-planned column to catch a charger that didn't deliver what was scheduled
How to use it
- 1
List every vehicle plugging in overnight with its departure time and the state of charge it needs to leave with — not just 'full', since not every route needs it.
- 2
Sequence charging so vehicles needing the least time or leaving earliest get priority slots, rather than charging on a first-plugged-in basis.
- 3
Sum the planned load across all simultaneous sessions against the depot's actual electrical capacity — this is the step that prevents a breaker trip at 3am.
- 4
Flag any vehicle that must charge regardless of slot order — a spare needed for an early-morning breakdown call, for instance — so it isn't deprioritised by the sequencing logic.
- 5
Check completed-vs-planned each morning; a vehicle that didn't reach its target charge by departure is either a scheduling problem or a charger fault, and the log tells you which to chase.
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
Depot Charging Schedule
Depot electrical capacity and any utility demand-charge structure are site-specific. Confirm your site's actual simultaneous-charging limit with your electrician or charging-network provider before scheduling to it.
| Vehicle | Departure | SOC at Plug-in | Target SOC | Charger | Slot | Priority |
|---|---|---|---|---|---|---|
| EV-101 | 05:30 | 35% | 90% | DC-01 | 22:00–01:30 | Standard |
| EV-104 | 06:00 | 48% | 80% | L2-03 | 22:00–05:00 | Standard |
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.
Because depot electrical capacity is finite, and charging every vehicle simultaneously at full rate can exceed what the site's connection supports — which either trips a breaker or triggers a utility demand charge that makes the whole operation more expensive. Sequencing by need and departure time gets every vehicle what it actually requires within the capacity you have.
This is a site-specific electrical question, not something a spreadsheet can tell you — confirm the simultaneous-charging limit with your electrician or the charging-network provider who installed the hardware, and build the schedule to stay under it with margin. Running the schedule at the theoretical maximum with no margin is what causes an unplanned trip the first time something charges slightly slower than expected.
Treat it as an exception and re-check the total load for that window before adding it — an ad hoc plug-in that isn't checked against the concurrent load is exactly the kind of event the schedule exists to prevent. If it happens often, it's worth building a standing reserve slot rather than repeatedly overriding the plan.
Not necessarily, and charging to 100% every night is generally harder on battery longevity than charging to the level the next day's route actually needs. Setting a target SOC per vehicle rather than defaulting everything to full both protects the battery and frees up depot capacity for vehicles that genuinely need a deeper charge.
Related guides & tools
Looking for more? Browse all fleet templates or run a fleet calculator.