Stephan
Member
Useful Tool in Excel SpreadSheet to Calc EV Charging Cost & Average Ranges:
TAB1: (2030) YEAR TEMPLATE to LOG CHARGES
TAB2: (YR SUMMARY) YEARS SUMMARY
TAB3: (EV MODELS) EVs COMPARE
TAB4: (EV CALCS) EV CHARGE COST + EV CHARGE TIME + EV MILE KW & COMPARE HOUSE "existing" Elec Tariff to "EV" Elec Tariff for Potential Cost Savings.
Comprehensive Comparison within EXCEL Worksheet, see attached PHOTO below, download XLS file SIZE is 1MB, this will open & work on newer versions of Excel such as XLSX. TAB2 utilises 3D RANGE RANGE via INDIRECT MIN or AVERAGE or MAX.
Best to Download, as Browser resized: File > Create Copy > Download Copy. Then Open that.
Also on a personal note, I drive a Gen1 3008 2HDI which is fabulous, but an e-3008 is still a really new expensive car, beyond my means (At The Moment! In a few years..!), but I'm sure the Clientele, who can buy 1, will appreciate this Method to compare specs and monitor log their Charges, obviously pre App this was how to, unless you relied on your Speedo Clocks MPG AV & Range, or perhaps many will prefer not make other considersations of running costs, other then it's cheaper, well, with an EV Tariff yes, and to Drive, if you like Automatics!
TAB4: EV CALC
To estimate Charge Costs from Your Prospective or Owned Car + Elec Tariff, you will need to know a few basic details, to get your specific details right, intially it is based on 50 KW EV, easily adjusted, Blue Boxes are COMBO-BOXES with pre defined relevant specifications:
CAR BATTERY KW (If no idea, compare same Model & Year... On AutoTrader, or Google it)
KW of CHARGER (You're currently using... ie Portable 3KW, Home Wall Charger 7KW, etc)
RANGE FROM NEW (Eg 220 miles)
RANGE CURRENT NOW FROM FULL CHARGE (Eg 150 miles)
ANNUAL MILES
DIESEL/PETROL (ICE compare) your PREVIOUS ppm, full tank miles, etc.
ELEC/GAS ANNUAL KWH CONSUMPTION (no idea look at Smart Meter wifi display, or ASK Supplier)
ELEC/GAS TARIFF PRICE £ KWH & DAY RATE (see photo below)
also 1 assuption on EV Tariff, you're not doing any heavy consumotion except EV Charging!
This XL Sheet will give you a more FORMED CONSENSUS OPINION, if it is advantageous to you, ie from Diesel to EV, and to go with EV tariff, instead of just on a whim Total Guess (yer... alright then etc.!)
CELLS in BLUE require NUMBER, generally either:
COMBO DROP DOWN BOX, will present options on Cursor (MousePad) Hovering over, left click to Activate,
or Enter Number Manually
TAB1: RANGE & CHARGE YEAR LOG
TAB2: YEARS SUMMARY of RANGE & CHARGES
TAB3: EV MODEL COMPARE
TAB4: EV CALCS: CHARGE, COST & TIME
Any suggestions, let me know! Something I've not considered? I know it is all to easy to accept information.
Especially Big Businesses & People of alledged importance tend to purposely exclude all really Pertinent information, & National + WorldWide Organisations, instead delay you with burecratic nonsence waffle to waste time & effort as a means to pacify you & deter you from asking realistic questions & making real world espectations, so after wading through all that made up ridiculous equivalents stuff, here is the clear answer (Not... NO you can't do this etc!) EV XLS FILE.
Cheers Stephan
TAB1: (2030) YEAR TEMPLATE to LOG CHARGES
TAB2: (YR SUMMARY) YEARS SUMMARY
TAB3: (EV MODELS) EVs COMPARE
TAB4: (EV CALCS) EV CHARGE COST + EV CHARGE TIME + EV MILE KW & COMPARE HOUSE "existing" Elec Tariff to "EV" Elec Tariff for Potential Cost Savings.
Comprehensive Comparison within EXCEL Worksheet, see attached PHOTO below, download XLS file SIZE is 1MB, this will open & work on newer versions of Excel such as XLSX. TAB2 utilises 3D RANGE RANGE via INDIRECT MIN or AVERAGE or MAX.
Best to Download, as Browser resized: File > Create Copy > Download Copy. Then Open that.
Also on a personal note, I drive a Gen1 3008 2HDI which is fabulous, but an e-3008 is still a really new expensive car, beyond my means (At The Moment! In a few years..!), but I'm sure the Clientele, who can buy 1, will appreciate this Method to compare specs and monitor log their Charges, obviously pre App this was how to, unless you relied on your Speedo Clocks MPG AV & Range, or perhaps many will prefer not make other considersations of running costs, other then it's cheaper, well, with an EV Tariff yes, and to Drive, if you like Automatics!
TAB4: EV CALC
To estimate Charge Costs from Your Prospective or Owned Car + Elec Tariff, you will need to know a few basic details, to get your specific details right, intially it is based on 50 KW EV, easily adjusted, Blue Boxes are COMBO-BOXES with pre defined relevant specifications:
CAR BATTERY KW (If no idea, compare same Model & Year... On AutoTrader, or Google it)
KW of CHARGER (You're currently using... ie Portable 3KW, Home Wall Charger 7KW, etc)
RANGE FROM NEW (Eg 220 miles)
RANGE CURRENT NOW FROM FULL CHARGE (Eg 150 miles)
ANNUAL MILES
DIESEL/PETROL (ICE compare) your PREVIOUS ppm, full tank miles, etc.
ELEC/GAS ANNUAL KWH CONSUMPTION (no idea look at Smart Meter wifi display, or ASK Supplier)
ELEC/GAS TARIFF PRICE £ KWH & DAY RATE (see photo below)
also 1 assuption on EV Tariff, you're not doing any heavy consumotion except EV Charging!
This XL Sheet will give you a more FORMED CONSENSUS OPINION, if it is advantageous to you, ie from Diesel to EV, and to go with EV tariff, instead of just on a whim Total Guess (yer... alright then etc.!)
CELLS in BLUE require NUMBER, generally either:
COMBO DROP DOWN BOX, will present options on Cursor (MousePad) Hovering over, left click to Activate,
or Enter Number Manually
TAB1: RANGE & CHARGE YEAR LOG
TAB2: YEARS SUMMARY of RANGE & CHARGES
TAB3: EV MODEL COMPARE
TAB4: EV CALCS: CHARGE, COST & TIME
Any suggestions, let me know! Something I've not considered? I know it is all to easy to accept information.
Especially Big Businesses & People of alledged importance tend to purposely exclude all really Pertinent information, & National + WorldWide Organisations, instead delay you with burecratic nonsence waffle to waste time & effort as a means to pacify you & deter you from asking realistic questions & making real world espectations, so after wading through all that made up ridiculous equivalents stuff, here is the clear answer (Not... NO you can't do this etc!) EV XLS FILE.
Cheers Stephan
