03-01-2009 19:38

cbudrecki

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!!

03-01-2009 21:16

ATannahill

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.

03-01-2009 21:38

cbudrecki

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.

03-01-2009 21:49

cbudrecki

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.

03-01-2009 22:24

cbudrecki

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.

08-01-2009 14:15

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.

12-01-2009 00:04

cbudrecki

Re: paper: 2009 Lunacy Scoring Spreadsheet

Quote:

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.