|
|
 It's not easy dealing with the reality that others aren't as passionate as we are and that the process may be slower than we want it to be - but it gives me plenty of time to think and prepare. - JaneYoung [more] |
 |
|
||||||||||||||
|
|||||||||||||||
Excel Spreadsheet Scoring Sim for FIRST Lunacy
Please be sure to enable macros (set the security level to low) in order to use all functions of the spreadsheet. Fairly straight-forward, I think.
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.
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.
Updates are FULL versions, you don't need to download all three... unless you really want to!
Attached Files
-
2009 Lunacy Spreadsheet v1.0
2009lunacy_scoring1.0.xls
download file
uploaded: 01-03-2009 05:57 PM
filetype: xls
filesize: 55.5kb
downloads: 213
-
UPDATE - v.1.1
2009lunacy_scoring1.1.xls
download file
uploaded: 01-03-2009 09:43 PM
filetype: xls
filesize: 56kb
downloads: 150
-
UPDATE - v1.2
2009lunacy_scoring1.2.xls
download file
uploaded: 01-03-2009 10:22 PM
filetype: xls
filesize: 63kb
downloads: 370
Discussion
view entire thread
01-03-2009 07:38 PM
tb222
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!!
01-03-2009 09:16 PM
rtfgnow
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.
01-03-2009 09:38 PM
tb222
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.
01-03-2009 09:49 PM
tb222
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.
01-03-2009 10:24 PM
tb222
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.
01-08-2009 02:15 PM
Killraine
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.
01-12-2009 12:04 AM
tb222
Re: paper: 2009 Lunacy Scoring Spreadsheet
|
Originally Posted by Killraine
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. |
view entire thread
Tags
loading ...