|
|
|
 I think FIRST is probably close to the farthest you can get from 'gangsta', outscored only by the math team. - Tom Bottiglieri [more] |
 |
|
|||||||
|
||||||||
This spreadsheet takes raw match data (teams participating, scores, and penalties) and produces calculates the RP and QP for each team. The spreadsheet is initially populated with data from the Florida regional.
At the Finger Lakes regional, the ranking system wasn't working throughout Friday, a...
This spreadsheet takes raw match data (teams participating, scores, and penalties) and produces calculates the RP and QP for each team. The spreadsheet is initially populated with data from the Florida regional.
At the Finger Lakes regional, the ranking system wasn't working throughout Friday, and I spent a few hours throwing together a spreadsheet to calculate the ranks of the teams. Saturday morning the official system was working, and that spreadsheet was used to double check the official rankings.
Since then, I've completely overhauled the spreadsheet, using Advay Mengle's Ranking spreadsheet (http://www.chiefdelphi.com/forums/papers.php?s=&action=single&paperid=308) as a basis. It's now much easier to use. Thank you to Advay for the start, Kevin Sevcik for checking the spreadsheet, and Kenny from SOAP for providing data from the Florida regional to check the RP algorithm.
Instructions are on the first sheet (Info).
Attached Files
-
2005 Scoring and Ranking spreadsheet
2-2005ranking.xls
download file
uploaded: 16-03-2005 20:39
filetype: xls
filesize: 663.5kb
downloads: 227
Discussion
view entire thread
17-03-2005 11:45
Joe Ross
Re: White Paper Discuss: 2005 Scoring and Ranking spreadsheet
|
Originally Posted by Joe Ross
Thread created automatically to discuss a document in the White Papers.
2005 Scoring and Ranking spreadsheet by Joe Ross |
I'm doing the QP calculations with the winner getting the lower of the winners or losers unpenalized score, per update 15, and the highest match score being the teams highest penalized score per 8.3.6. I'm awaiting word on any changes to those based on the discusion in this thread: http://www.chiefdelphi.com/forums/sh...threadid=36282
17-03-2005 13:06
Joe Johnson
Re: White Paper Discuss: 2005 Scoring and Ranking spreadsheet
|
Originally Posted by Joe Ross
The spreadsheet has been updated this morning to handle DQs, and to manually find the highest match score (ie it's not taken into account in the ranking).
I'm doing the QP calculations with the winner getting the lower of the winners or losers unpenalized score, per update 15, and the highest match score being the teams highest penalized score per 8.3.6. I'm awaiting word on any changes to those based on the discusion in this thread: http://www.chiefdelphi.com/forums/sh...threadid=36282 |
Thanks.
Joe J.
view entire thread
Tags
loading ...