An Electric Vehicle begins its journey from the initial point with the capacity of covering 550 kms in a single charge (100%-0%). As it starts,it functions at 100% cycles throughout till the battery reaches 10% and the cycles automatically shift to 80% to optimize the energy level(10%) and cycle continues for 80%-10%. It travels at a uniform speed of 40 km/h throughout the journey. please help me to calculate distance vs battery left according to km traveled vs time taken .please guys help something in excel either macros ,how to do this.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
excel for simulate this case.
- Thread starter SJ excel
- Start date
Similar threads
- Question
- Question
