Note: Please before giving a negative point please first consider that this is new for someone like us and I have tried multiple things but failed so I have come here for the solution.
I want to generate a driving behavior score based on the OBD-II data. We are considering the total count of Overspeed, Harsh Acceleration, Harsh Deceleration, and Harsh Turning. We are also taking the Distance traveled into consideration for the equation. We have provided 25% weightage to each right now.
And we have calculated the driving score by following this formula:
https://docs.google.com/spreadsheets/d/1Inj72owP1u0Yb9IpTgMqiwM2gKs6mzcU/edit?pli=1#gid=370599431
https://community.geotab.com/s/article/How-does-the-Safety-Scorecard-work?language=en_US
I do not know that the value I am getting is correct and Driving behavior scores are generally like this.
I have tried many formulas only this one got me something precise.
Please check the Excel sheet, the formula inside, and the driving score.
If it is incorrect, please provide me with a proper logic or formula to generate the driving behavior score based on the parameters I use.
If anyone has implemented the driving behavior score, please provide me the reference or provide logic on which I can generate it.