Statistically best track

  • Thread starter OJBrit
  • 31 comments
  • 1,917 views
I just started entering the data for the sheet and noticed that there was no formula for the avg variation field. If you follow @OJBrit's template and use column K for the variation and column L for the points the following formula should work all the way up to a variation of -15:

=if(K2<-14, 4, if(K2<-9, 3, if(K2<-4, 2, if(K2<0, 1,if(K2>0, -1, 0)))))
 
Last edited:
Dragon Trail-Gardens is my best and most active track. There, I had scored 24 wins, 52 top 5s and 23 poles, the most by any course I entered.
 
Last edited:
Back