View Single Post
  #255   Spotlight this post!  
Unread 09-03-2015, 16:03
AGPapa's Avatar
AGPapa AGPapa is offline
Registered User
AKA: Antonio Papa
FRC #5895
Team Role: Mentor
 
Join Date: Mar 2012
Rookie Year: 2011
Location: Robbinsville, NJ
Posts: 323
AGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond reputeAGPapa has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by orangemoore View Post
I recreated the formula in in excel (I think). With events that have 24 - 70 teams. It looks correct but I am not totally sure.

Here is the just Numbers version on Google Docs.
That's not quite right. For example, in the "37" column you have the 4th rank team getting 20 points, when in reality they got 19 points.

I've added the script I've been using (which, as far as I can tell, has been consistent with the official rankings) to your spreadsheet. You can find it under Tools->Script Editor. I'm put my values on another page in your spreadsheet.

If you want to use the script just type "=points(N, R)" where N is the number of teams and R is the rank.
__________________
Team 2590 Student [2011-2014]
Team 5684 Mentor [2015]
Team 5895 Mentor [2016-]

Last edited by AGPapa : 09-03-2015 at 16:26.
Reply With Quote