Go to Post Just proves those guys have loco-motives - Wayne C. [more]
Home
Go Back   Chief Delphi > Other > Chit-Chat > Games/Trivia > Fantasy FIRST
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
Reply
Thread Tools Rating: Thread Rating: 8 votes, 5.00 average. Display Modes
  #241   Spotlight this post!  
Unread 02-03-2015, 17:45
orangemoore orangemoore is offline
Registered User
AKA: Roger Moore
FRC #3135 (Robotic Colonels)
Team Role: College Student
 
Join Date: Dec 2012
Rookie Year: 2013
Location: Chicago
Posts: 2,310
orangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

So now that week one is over how does scoring get done?
__________________
Stronghold


Student 2013-2016
3135 -- Robotic Colonels
3507 -- Robotheosis (FTC)
Reply With Quote
  #242   Spotlight this post!  
Unread 02-03-2015, 20:19
PVCpirate's Avatar
PVCpirate PVCpirate is offline
FRC Data Nerd
AKA: Anthony Jennings
FRC #1058 (PVC Pirates)
Team Role: Alumni
 
Join Date: May 2010
Rookie Year: 2009
Location: Londonderry NH
Posts: 669
PVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud ofPVCpirate has much to be proud of
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Well right now I don't think complete match data is available for all the events, so right now we wait. Once that happens, some of us have to go through and score all the teams, although there might be some stuff to automate some of the process. Then the scores for each FF player get totaled up and the event score is added to the standings.

Also, I vote for either using the district points and not giving our usual ranking points or using our usual ranking points and not having anything in place of win/loss points.
__________________
My accomplishments with 1058:
2010 - Granite State Regoinal Winners, Galileo quarterfinalists, IRI quarterfinalists
2012 - GSR Chairman's Award winners
An incredible four years I will never forget
Reply With Quote
  #243   Spotlight this post!  
Unread 02-03-2015, 22:38
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,817
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by PVCpirate View Post
Once that happens, some of us have to go through and score all the teams, although there might be some stuff to automate some of the process. Then the scores for each FF player get totaled up and the event score is added to the standings.

Also, I vote for either using the district points and not giving our usual ranking points or using our usual ranking points and not having anything in place of win/loss points.
Using our usual ranking points and not having anything else isn't gonna work past #15 or #16--everybody gets zero beyond that unless they're picked or pick up hardware. That would be... rather bad for a lot of folks in single-tier events.


Everybody OK with using FIRST's system for the year, with no separate FF ranking points? Unless I suddenly hear a lot of negativity on this, I think that's about the way to go. Awards points and elims finishes won't change, BTW.
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #244   Spotlight this post!  
Unread 02-03-2015, 22:52
Navid Shafa Navid Shafa is offline
FIRST Hiatus/Retired?
no team
Team Role: Alumni
 
Join Date: Oct 2007
Rookie Year: 2007
Location: Seattle, WA
Posts: 1,525
Navid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond reputeNavid Shafa has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by EricH View Post
Everybody OK with using FIRST's system for the year, with no separate FF ranking points? Unless I suddenly hear a lot of negativity on this, I think that's about the way to go. Awards points and elims finishes won't change, BTW.
It would certainly make things a lot easier. If everyone is OK with it, my bet is that I can ask Alex at HQ to spit out all district point equivalent data (not just districts) for teams at all events for us. He was doing some of this last year with the original District Ranking System which is now FIRST's main Database source. He's likely a little preoccupied right now though considering...

*Edit: Alex said these values will be available for non-district teams that compete in districts, but not exposed for non-district events
__________________
2015 & 2016 Fantasy FIRST Champions [Rotten Fruit Alliance]
Elgin Clock Award Winners: '13, '15, '16

Team 1983 | Alumnus, Former Mentor| Team_ 360 | Former Coach | Team 5803 | Former Mentor

"Once a Skunk, Always a Skunk"

Founding Member

Last edited by Navid Shafa : 03-03-2015 at 02:05. Reason: New Information
Reply With Quote
  #245   Spotlight this post!  
Unread 02-03-2015, 23:01
Maldridge422's Avatar
Maldridge422 Maldridge422 is offline
I was on a different team in 2013.
AKA: Matt Aldridge
FRC #0619 (Cavalier Robotics)
Team Role: College Student
 
Join Date: Sep 2012
Rookie Year: 2011
Location: CVille
Posts: 216
Maldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant future
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by EricH View Post
Everybody OK with using FIRST's system for the year, with no separate FF ranking points? Unless I suddenly hear a lot of negativity on this, I think that's about the way to go. Awards points and elims finishes won't change, BTW.
Sounds good to me.
Reply With Quote
  #246   Spotlight this post!  
Unread 03-03-2015, 20:14
Maldridge422's Avatar
Maldridge422 Maldridge422 is offline
I was on a different team in 2013.
AKA: Matt Aldridge
FRC #0619 (Cavalier Robotics)
Team Role: College Student
 
Join Date: Sep 2012
Rookie Year: 2011
Location: CVille
Posts: 216
Maldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant futureMaldridge422 has a brilliant future
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

I've been working on some of the scoring, using FIRST's district ranking points system. It looks like the Northern Lights data is complete. Can someone confirm these scores look right?

Scores for Northern Lights Regional:
Code:
Falcon			122
Koko's X-Cats		118
Team SuperPowerMatic	110
Rotten Peach Alliance	108
The Yellow Alliance	92
Swamp Life		70
Daedalite InVAders	66
SHARP Cheddar		54
Brolliance Beta		53
Orange Juice		49
The Breakfast Company	49
Frog Farce		44
PureMichigan		43
LTown Throwdown		38
Spoiler for points breakdown:
PureMichigan:
2169 won the Industrial Design Award sponsored by General Motors (15 points)
2169 was rank 30 (12 points)
2169 were quarterfinalists (4 points)
4226 was rank 59 (4 points)
2518 was rank 48 (8 points)
Total points: 43

Orange Juice:
5148 was rank 17 (15 points)
4624 was rank 6 (19 points)
4624 were quarterfinalists (4 points)
3381 was rank 35 (11 points)
Total points: 49

SHARP Cheddar:
27 won the Entrepreneurship Award sponsored by Kleiner Perkins Caufield and Byers (2 points)
27 was rank 9 (17 points)
27 were quarterfinalists (4 points)
5232 was rank 12 (16 points)
5232 were semifinalists (10 points)
877 was rank 57 (5 points)
Total points: 54

The Breakfast Company:
3883 was rank 14 (16 points)
3883 were quarterfinalists (4 points)
4623 was rank 4 (20 points)
4623 were quarterfinalists (4 points)
4671 was rank 56 (5 points)
Total points: 49

Swamp Life:
3055 won the Excellence in Engineering Award sponsored by Delphi (15 points)
3055 was rank 13 (16 points)
3055 were semifinalists (10 points)
5720 was rank 44 (9 points)
3750 won the Judges' Award (5 points)
3750 was rank 18 (15 points)
Total points: 70

LTown Throwdown:
2502 was rank 36 (11 points)
2502 were semifinalists (10 points)
3054 was rank 52 (7 points)
2847 won the Gracious Professionalism Award sponsored by Johnson & Johnson (2 points)
2847 was rank 49 (8 points)
Total points: 38

Frog Farce:
4656 won the FIRST Dean's List Finalist Award (4 points)
4656 was rank 43 (9 points)
4656 were quarterfinalists (4 points)
2705 was rank 20 (14 points)
3723 was rank 26 (13 points)
Total points: 44

Koko's X-Cats:
2512 won the Team Spirit Award sponsored by Chrysler (2 points)
2512 won the FIRST Dean's List Finalist Award (4 points)
2512 won the Woodie Flowers Finalist Award (8 points)
2512 won the Regional Finalists (20 points)
2512 won the Regional Chairman's Award (42 points)
2512 was rank 7 (18 points)
2479 was rank 47 (8 points)
2574 was rank 31 (12 points)
2574 were quarterfinalists (4 points)
Total points: 118

Rotten Peach Alliance:
3130 won the Innovation in Control Award sponsored by Rockwell Automation (15 points)
3130 won the Regional Winners (30 points)
3130 was rank 1 (22 points)
3130 got the high score (5 points)
876 was rank 11 (17 points)
876 were semifinalists (10 points)
2491 was rank 46 (9 points)
Total points: 108

Falcon:
525 won the Imagery Award in honor of Jack Kamen (2 points)
525 won the Regional Winners (30 points)
525 was rank 2 (21 points)
525 got the high score (5 points)
5638 won the Highest Rookie Seed (5 points)
5638 won the Rookie Inspiration Award (15 points)
5638 was rank 8 (18 points)
5638 were quarterfinalists (4 points)
2846 was rank 29 (12 points)
2846 were semifinalists (10 points)
Total points: 122

The Yellow Alliance:
5172 won the Quality Award sponsored by Motorola (15 points)
5172 won the Regional Finalists (20 points)
5172 was rank 3 (20 points)
5290 was rank 15 (16 points)
2501 was rank 10 (17 points)
2501 were quarterfinalists (4 points)
Total points: 92

Team SuperPowerMatic:
4215 won the Regional Winners (30 points)
4215 was rank 21 (14 points)
4215 got the high score (5 points)
5464 won the Rookie All Star Award (20 points)
5464 was rank 51 (7 points)
4786 won the Industrial Safety Award sponsored by Underwriters Laboratories (2 points)
4786 won the Regional Finalists (20 points)
4786 was rank 33 (12 points)
Total points: 110

Brolliance Beta:
2175 was rank 27 (13 points)
2175 were quarterfinalists (4 points)
4207 won the Creativity Award sponsored by Xerox (15 points)
4207 was rank 58 (4 points)
4207 were quarterfinalists (4 points)
4238 was rank 25 (13 points)
Total points: 53

Daedalite InVAders:
4531 was rank 60 (3 points)
2500 won the Regional Engineering Inspiration Award (36 points)
2500 was rank 22 (14 points)
2500 were quarterfinalists (4 points)
3926 was rank 45 (9 points)
Total points: 66
Reply With Quote
  #247   Spotlight this post!  
Unread 07-03-2015, 20:35
orangemoore orangemoore is offline
Registered User
AKA: Roger Moore
FRC #3135 (Robotic Colonels)
Team Role: College Student
 
Join Date: Dec 2012
Rookie Year: 2013
Location: Chicago
Posts: 2,310
orangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

I just realized that one of my picks (4101) in the PNW District draft doesn't exist as a PNW team. I assume I need to change that right?
__________________
Stronghold


Student 2013-2016
3135 -- Robotic Colonels
3507 -- Robotheosis (FTC)
Reply With Quote
  #248   Spotlight this post!  
Unread 07-03-2015, 20:47
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,817
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by orangemoore View Post
I just realized that one of my picks (4101) in the PNW District draft doesn't exist as a PNW team. I assume I need to change that right?
Yup. Just don't pick a team that's played more than once.


With the data back online, is any scoring happening?
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk

Reply With Quote
  #249   Spotlight this post!  
Unread 07-03-2015, 20:55
orangemoore orangemoore is offline
Registered User
AKA: Roger Moore
FRC #3135 (Robotic Colonels)
Team Role: College Student
 
Join Date: Dec 2012
Rookie Year: 2013
Location: Chicago
Posts: 2,310
orangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by EricH View Post
With the data back online, is any scoring happening?
I can do some scoring I just need to have an updated sheet/document laying out what everything(Awards/Ranking/Playoffs) is worth.
__________________
Stronghold


Student 2013-2016
3135 -- Robotic Colonels
3507 -- Robotheosis (FTC)
Reply With Quote
  #250   Spotlight this post!  
Unread 07-03-2015, 21:10
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,817
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by orangemoore View Post
I can do some scoring I just need to have an updated sheet/document laying out what everything(Awards/Ranking/Playoffs) is worth.
Relevant items (from the SLFF rules document, W-L-T and ranking removed, and from FIRST's published method):

Ranking is using the District Ranking system (which is a formula based on number of teams at event, ranking of team in question, and a normalization factor). I'm going to have a hard time reproducing it here, but I'll try--see spoiler.

Winner, 30 points
Finalist, 20 points
Semifinalist, 10 points
Quarterfinalist, 4 points

Woodie Flowers Finalist Award, 8 points
Regional Chairman’s Award, 42 points
Engineering Inspiration, 36 points
Rookie All-Star, 20 points
Rookie Inspiration, 15 points

Highest Rookie Seed, 5 points
High score, 5 points
Judges Award, 5 points
Robot-based award (Delphi, Xerox, GM, Rockwell, Motorola), 15 points
Dean’s List, 4 points
Any award not previously mentioned, 2 points

Spoiler for district ranking:
QP(R,N,a)=(Inverse Error((N-2R+2)/aN)(10/Inverse Error(1/a))+12), round up to the nearest point.

R is the Rank, N is the Number of teams at the event, a is 1.07 (normalization).
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk


Last edited by EricH : 07-03-2015 at 21:30.
Reply With Quote
  #251   Spotlight this post!  
Unread 07-03-2015, 21:20
orangemoore orangemoore is offline
Registered User
AKA: Roger Moore
FRC #3135 (Robotic Colonels)
Team Role: College Student
 
Join Date: Dec 2012
Rookie Year: 2013
Location: Chicago
Posts: 2,310
orangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by EricH View Post
Spoiler for district ranking:
QP(R,N,a)=abs(InvERF((N-2R+2)/aN)(10/InvERF(1/a))+12)

R is the Rank, N is the Number of teams at the event, a is 1.07 (normalization). Now if I can just figure out the what the InvERF stands for, we're all set.

Have you seen this document?
__________________
Stronghold


Student 2013-2016
3135 -- Robotic Colonels
3507 -- Robotheosis (FTC)
Reply With Quote
  #252   Spotlight this post!  
Unread 07-03-2015, 21:29
EricH's Avatar
EricH EricH is offline
New year, new team
FRC #1197 (Torbots)
Team Role: Engineer
 
Join Date: Jan 2005
Rookie Year: 2003
Location: SoCal
Posts: 19,817
EricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond reputeEricH has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by orangemoore View Post
Have you seen this document?
Oh, THAT's where it was! I thought I'd seen something explaining the system. Will adjust the spoiler. And if an event you're scoring has the number of teams in the tables... well, now, seems like it'd be a bit of a pain to use the equation a bunch of times, no?
__________________
Past teams:
2003-2007: FRC0330 BeachBots
2008: FRC1135 Shmoebotics
2012: FRC4046 Schroedinger's Dragons

"Rockets are tricky..."--Elon Musk


Last edited by EricH : 07-03-2015 at 21:31.
Reply With Quote
  #253   Spotlight this post!  
Unread 07-03-2015, 23:22
BrennanB's Avatar
BrennanB BrennanB is online now
TBC is good at getting almost first
AKA: Brennan Bibic
FRC #4476 (W.A.F.F.L.E.S.)
Team Role: Mentor
 
Join Date: Jan 2012
Rookie Year: 2006
Location: Kingston
Posts: 1,299
BrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond reputeBrennanB has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

If someone shoots me the scores I can shoot up a current FF ranking doc.
__________________

Brennan Bibic - @b_bibic - Eh-Nalysis
10 years of inspiration compilation - W.A.F.F.L.E.S. #4476 YouTube Channel - 64 events and counting!

FRC 2013-2017 (W.A.F.F.L.E.S. Community Robotics #4476) - FLL 2006-2017 (W.A.F.F.L.E.S. #105) - VRC 2010-2013, 2015-2016 (W.A.F.F.L.E.S. #4476)
FRC 2009-2012 (K-Botics #2809)

Fantasy First 2014-2017 (The Breakfast Company) #TBCWin
2014 Dean's List Finalist

"Work until your idols become your rivals."
Reply With Quote
  #254   Spotlight this post!  
Unread 07-03-2015, 23:27
orangemoore orangemoore is offline
Registered User
AKA: Roger Moore
FRC #3135 (Robotic Colonels)
Team Role: College Student
 
Join Date: Dec 2012
Rookie Year: 2013
Location: Chicago
Posts: 2,310
orangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond reputeorangemoore has a reputation beyond repute
Re: [FF]: 2015 Season Long Fantasy FIRST: Traditional League

Quote:
Originally Posted by EricH View Post
Oh, THAT's where it was! I thought I'd seen something explaining the system. Will adjust the spoiler. And if an event you're scoring has the number of teams in the tables... well, now, seems like it'd be a bit of a pain to use the equation a bunch of times, no?
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.
__________________
Stronghold


Student 2013-2016
3135 -- Robotic Colonels
3507 -- Robotheosis (FTC)
Reply With Quote
  #255   Spotlight this post!  
Unread 09-03-2015, 16:03
AGPapa's Avatar
AGPapa AGPapa is online now
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
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 14:29.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi