New here, and building a free EV charging cost spreadsheet. What should it cover?

BenGC_EV

New Member
Hi everyone,

I'm Ben, from the Gold Coast in Australia. I worked in the car trade for 14 years and I drive a BYD now.

I've been making a few spreadsheets to make life easier for myself and other EV owners. They're mostly cost calculators, because I never found one that answered the questions I actually had. The one I'm proudest of works out what a single charge costs, say from 20% to 85%. It allows for the power lost while charging and shows the range added, the cost per 100 miles and what the same distance would cost in a gas car. I've done US, UK and Australian versions so the units are right for each.

I'd like to make it more useful, so I'm after opinions from people with different cars and different power plans.

What do you wish a charging cost calculator did that the ones you've tried don't? Time-of-use rates, home solar, cold weather, public fast charging, a log of every charge?

I have a free one-tab version I'm happy to share if the mods are OK with a link. I sell a bigger version too, so I wanted to ask before posting one.

Cheers,
Ben
 
Some things I'd want in a charging cost calculator: (1) Charging losses as an input. Wall-to-battery efficiency is often somewhere around 85-90% on AC, and worse at low amperage or in the cold, so let people override the default. (2) Multi-band time-of-use rates, ideally with separate weekday and weekend schedules. (3) Public DC pricing models. Per kWh, per minute, session fees and idle/congestion fees give very different totals, and per-minute pricing hurts most above ~80% when the car slows down. (4) Subscription break-even, i.e. monthly fee vs. the discount per kWh. (5) Home solar: use the export rate as the opportunity cost of self-consumed energy. (6) A winter range factor, plus the extra energy for preheating. Cost per 100 miles (or per 100 km) next to the gas comparison is a nice touch.
 
Thanks Bohdan, that's a really useful list. There's plenty in there I hadn't thought through properly.

Charging losses and a cold weather setting are already in it, so it's good to know I'm on the right track there. The per minute public charging point is a good one. I hadn't really thought about how much that stings above 80% once the car slows right down. Session and idle fees too.

The subscription break-even and using the solar export rate as the real cost of power you use yourself are both smart ideas. I'll have a think about how to fit them in without making it too fiddly to fill out.

Out of interest, what are you driving, and do you mostly charge at home or out and about?
 
One thing I’d add is a simple charge log that records start/end SOC, kWh added, charger type, tariff band, session/idle fees and ambient temperature, then calculates effective $/kWh and cost per 100 km. That lets people compare their estimate with reality and spot when AC losses or cold weather are worse than expected. A CSV export is handy for tax or rebate records. I’d also include separate fields for taxes/GST and any minimum session charge, since those often decide whether public charging is actually cheaper.
 
Thanks Ben. I drive a VW e-Golf and charge mostly at home, so a home charging cost calculator is exactly what I'd use. I'm planning to upgrade it soon, so I'm curious how much a newer car's efficiency changes the cost per 100 km. How does the BYD compare on that for you?
 
Thanks sophiabrown, a proper charge log is a great idea. Checking the estimate against what actually happened is the bit I care about most, especially in winter or on a slow AC charger. Good shout on GST and minimum session charges too. A couple of dollars minimum on a short top up can wreck the numbers and most people never notice.

Bohdan, the e-Golf has a good name for being efficient, so a newer car won't always beat it by much. Cost per 100 km mostly comes down to how many kWh the car uses per 100 km, times your home rate, plus whatever gets lost while charging. A bigger, heavier car can end up costing more even if it's newer.

I haven't got clean numbers for my BYD handy, so I'll pull them from my last few charges and post them here rather than guess. What are you looking at upgrading to?
 
Back
Top