|
|
|
 Chief Delphi down for a few hours ON A WEEKEND??? This is MADNESS! - [more] |
 |
|
|||||||
|
||||||||
 |
| Thread Tools | Rate Thread | Display Modes |
|
|
|
| Chief Delphi down for a few hours ON A WEEKEND??? This is MADNESS! - [more] |
|
|
|||||||
|
||||||||
|
| Thread Tools | Rate Thread | Display Modes |
|
#1
|
|||||
|
|||||
|
paper: 2009 Lunacy Scoring Spreadsheet
Thread created automatically to discuss a document in CD-Media.
2009 Lunacy Scoring Spreadsheet by tb222 Last edited by cbudrecki : 03-01-2009 at 19:38. 
|
|
#2
03-01-2009, 19:38
|
|||||
|
|||||
|
Re: paper: 2009 Lunacy Scoring Spreadsheet
The first draft of my spreadsheet is up. The game is fairly straigh forward as far as scoring this year. I have limited the number of balls, so if you exceed the total number of provided game pieces, you will get ERROR in the score boxes.
PLEASE BE SURE TO SET MACRO SECURITY TO LOW TO USE THE RESET BUTTON!!!! If you find any bugs, or would like to see more features added, just post them here! ENJOY!!
|
|
#3
03-01-2009, 21:16
|
||||
|
||||
|
Re: paper: 2009 Lunacy Scoring Spreadsheet
I see two problems that need to be fixed. First, and most easily fixed is that the fact that in A1 and A5 you should say "Trailers attached to". Second is that you can score 8 empty cells and 8 super cells in your calculations, the total should add up to 8.
|
|
#4
03-01-2009, 21:38
|
|||||
|
|||||
|
Re: paper: 2009 Lunacy Scoring Spreadsheet
I was just thinking about that issue with the empty & super cells. I should have that corrected and post a new version.
The trailer colors do represent the bot they are connected to (no flags/lights this year), but they are scored for the opposing alliance, which is why I set up the spreadsheet how I did.
|
|
#5
03-01-2009, 21:49
|
|||||
|
|||||
UPDATE POSTED
v1.1 results in an ERROR if the number of EMPTY CELLS & SUPER CELLS combined, is greater than 8. Also added "Trailer" to A1 & A5.
|
|
#6
03-01-2009, 22:24
|
|||||
|
|||||
|
UPDATE - v1.2
v1.2 adds IDEAL score buttons for red & blue. Max score would be 360, but decided not to add those buttons, due to a 0 RP, and the loss of cells your next time up.
|
|
#7
08-01-2009, 14:15
|
|||
|
|||
|
Re: paper: 2009 Lunacy Scoring Spreadsheet
Not that it is super important, but I believe the ideal score should be something along the lines of 182-178. This would be achieved with all super cells scored evenly and the winning team scoring 61 moon rocks to the losing teams 59.
Nice work on this though, it will be a nice tool.
|
|
#8
12-01-2009, 00:04
|
|||||
|
|||||
|
Re: paper: 2009 Lunacy Scoring Spreadsheet
Quote:
|
|
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| FRC 2009 - Lunacy | Michelle Celio | General Forum | 47 | 05-01-2009 14:57 |
| paper: OVERDRIVE Excel Scoring Spreadsheet | cbudrecki | Extra Discussion | 7 | 08-01-2008 00:50 |
| paper: Rack & Roll Scoring Spreadsheet v1.0 | cbudrecki | Extra Discussion | 50 | 14-01-2007 22:14 |
| White Paper Discuss: Triple Play Scoring Spreadsheet | cbudrecki | Extra Discussion | 6 | 15-08-2005 10:49 |
| White Paper Discuss: 2005 Scoring and Ranking spreadsheet | Joe Ross | Extra Discussion | 2 | 17-03-2005 13:06 |
- Arizona North
Linear Mode
