guys i do need help for calculating range like no effect of terrain and anything. i need macro anything on my excel document to simultaneously calculate distance vs battery percentage .that is whenever it goes from 80% to 5% it will charge again means reset its counter and so on . my total range is 560 km on one charge that is if battery 10% it has completed 450 km.consider 505 km on one charge and reset counter .the distance is in km and accordingly percentage moves .for the first time the counter is 100%-10% only and other times its 80%-5%.hope u guys get it its same as km/litre.but this time percentage of car battery.please guys help me with it.
-
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.
range calculation in terms of distance
- Thread starter SJ excel
- Start date
