Joined
·
1,514 Posts
Tried to simulate driving a long distance trip in Excel (see attached) for the I-pace calculating total time, total kwh charged and cost at 4 different highway speeds. I build it for Metric and Imperial system.
The calculations are driving by various assumptions that can be adjusted and some general assumptions to simplify the simulation. Key logic (although flawed) to simplify the simulation is that fast chargers are available exactly where you need them and they are all working and charging at the same constant charging speed, also that you depart with a 100% SoC.
Changeable assumptions:
Any feedback, suggestions, corrections etc on the logic and/or calculations is welcome
The calculations are driving by various assumptions that can be adjusted and some general assumptions to simplify the simulation. Key logic (although flawed) to simplify the simulation is that fast chargers are available exactly where you need them and they are all working and charging at the same constant charging speed, also that you depart with a 100% SoC.
Changeable assumptions:
- Usable battery size of the car - set to 85kW
- Battery charging speed - set to 50kW
- Recharge to battery % - set to 80% SoC
- % extra charge for last leg - set to 10%
- Distance to travel - set to 1250km
- Avg cost per kwh charged - set to €0.25
- Ratio avg speed to highway speed
- Fuel efficiency for the 4 different speeds
Any feedback, suggestions, corrections etc on the logic and/or calculations is welcome
Attachments
-
24.6 KB Views: 314