Joined
·
1,513 Posts
Tried to simulate driving a long distance trip in Excel (see attached) for the Ipace 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: 276