Is there a better way to write this grade calculation formula?

bigtime

New member
Joined
Apr 28, 2018
Messages
2
Hello,

The formula I'm using below does give the result I am expecting, but it seems like there should be a much better more efficient way of doing it (math was never my strong suit!!).

I'm assigning a percent score based on the number of steps.

Here's my formula:

$stepGrade = $AVGSteps/(($maxavgsteps-$minavgsteps)/$maxPoints) - $maxPoints

86% = 9300/((10000-5000)/100) - 100

PercentAverage Steps/Day
10010000
909500
809000
708500
608000
507500
407000
306500
206000
105500
05000



Thanks for any feedback!

Tim
 
Top