View Single Post
  #5   Spotlight this post!  
Unread 10-03-2015, 14:21
MasterMentor's Avatar
MasterMentor MasterMentor is offline
TheGreatGonzo
AKA: George Gonzo
no team
Team Role: Alumni
 
Join Date: Jan 2015
Rookie Year: 2004
Location: Kansas
Posts: 31
MasterMentor will become famous soon enough
Re: Math: How to solve ranking equation

Quote:
Originally Posted by ArtemusMaximus View Post
I was curious about the function, did a little digging found someone already made one for Excel VBA. I hope this helps.
http://www.mrexcel.com/forum/excel-q...ml#post1146833
You just have to be careful about this, the input into InvERF with the District Qual Points Formula will be negative on one side of the [-1, 1] range, and this function can only handle positive input values. Also at the midpoint it's possible to get a divide-by-zero error with this function too. Both issues are easily worked around with a little formula/programming magic, but it's important to know this isn't a perfect drop-in solution.

-MM
Reply With Quote