|
|
|
 Andy Baker is so awsome, that his presence alone at the competition caused the scoring system to crash....multiple times...at all 8 regionals. - Andy Grady [more] |
 |
|
|||||||
|
||||||||
UPDATED AGAIN!!!!!
Easy to use spreadsheet.
I have included:
1. Stacked and Contained Tetras for each goal
2. 10 pt. bonus for each row (yes, I figured out how to calculate ownership into rows and equal a bonus...)
3. 10 pt. bonus for all 3 bots in end zone (TOUCHDOWN!)
4. Penalty Deduct...
UPDATED AGAIN!!!!!
Easy to use spreadsheet.
I have included:
1. Stacked and Contained Tetras for each goal
2. 10 pt. bonus for each row (yes, I figured out how to calculate ownership into rows and equal a bonus...)
3. 10 pt. bonus for all 3 bots in end zone (TOUCHDOWN!)
4. Penalty Deduction
5. Assigning ownership without having that color tetra on a goal results in an ERROR warning!(added v1.2)
*NEW in v1.3!* 6. Stacked tetras take precedence over contained tetras when assigning ownership!=)
7. Simple, common sense directions!
(May be useful to print out and use for 'hard copy' scoring.)
Attached Files
-
Triple Play Scoring Spreadsheet v1.3
1106065160tripplayscore.xls
download file
uploaded: 18-01-2005 11:19
filetype: xls
filesize: 20kb
downloads: 137
Discussion
view entire thread
09-01-2005 15:35
Adam Richards
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
The "blue end zone" field doesn't work properly. It isn't sending any data to field I10. I10 isn't calculating the score for having all 3 robots behind the end zone in I2. Instead, the "red end zone" (H2) field controls both scores, adding 10 to both.
This is the corrected field for I10:
=((C2+E2+G2+G6+E6+C6+C10+E10+G10)*3)+(SUM(C3,E3,G3,C7,E7,G7,C11,E11,G11))+(IF(I2=3,10,0))+(IF(AND(B4=CHAR(66),D4=CHAR(66),F4=CHAR(66)),10,0))+(IF(AND(B8=CHAR(66),D8=CHAR(66),F8=CHAR(66)),10,0))+(IF(AND(B12=CHAR(66),D12=CHAR(66),F12=CHAR(66)),10,0))+(IF(AND(B4=CHAR(66),B8=CHAR(66),B12=CHAR(66)),10,0))+(IF(AND(D4=CHAR(66),D8=CHAR(66),D12=CHAR(66)),10,0))+(IF(AND(F4=CHAR(66),F8=CHAR(66),F12=CHAR(66)),10,0))+(IF(AND(B4=CHAR(66),D8=CHAR(66),F12=CHAR(66)),10,0))+(IF(AND(F4=CHAR(66),D8=CHAR(66),B12=CHAR(66)),10,0))-(I6)
09-01-2005 18:35
cbudrecki
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
|
Originally Posted by nartak
The "blue end zone" field doesn't work properly. It isn't sending any data to field I10. I10 isn't calculating the score for having all 3 robots behind the end zone in I2. Instead, the "red end zone" (H2) field controls both scores, adding 10 to both.
|
ENJOY!!!
09-01-2005 20:42
Steve Howland
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
Perhaps I'm being a bit picky...but I like the new feature about only having ownership if you have a tetra of your color. Could you also add that if, for example, blue has a stacked tetra and red only has contained tetras, that the goal cannot go to red? (and vice versa with red on top and blue below) Not really sure where in the code to put it but something like IF(B2=0,IF(C2>0,IF(B4="R","ERROR",0),0),0) with all the ANDs and ORs added in for each case. If not its okay - its still a really cool spreadsheet
12-01-2005 12:04
cbudrecki
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
|
Originally Posted by Steve Howland
Perhaps I'm being a bit picky...but I like the new feature about only having ownership if you have a tetra of your color. Could you also add that if, for example, blue has a stacked tetra and red only has contained tetras, that the goal cannot go to red? (and vice versa with red on top and blue below) Not really sure where in the code to put it but something like IF(B2=0,IF(C2>0,IF(B4="R","ERROR",0),0),0) with all the ANDs and ORs added in for each case. If not its okay - its still a really cool spreadsheet
|
18-01-2005 11:27
cbudrecki
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
|
Originally Posted by Steve Howland
Could you also add that if, for example, blue has a stacked tetra and red only has contained tetras, that the goal cannot go to red?
|
ps- I am also proud to state that this spreadsheet was the FIRST scoring program posted in the white papers for this year! I know, it doesn't mean much, but I'm proud to have the bragging rights!
15-08-2005 10:49
cbudrecki
Re: White Paper Discuss: Triple Play Scoring Spreadsheet
I was experimenting with Excel and now created v2.0 which was just submitted to the white papers!!! (it may take a day or 2, but it'll be there) Let's just say I wanted to get a jump on making an outstanding spreadsheet for next year!!! If you downloaded any of the 1.x versions, I highly suggest you update them with this. I kept it printer friendly so it can easily be used as a scoring sheet for mini's. (I'd love to get a pm or e-mail saying somebody used the hard-copy at a mini!!!) Trust me, you can definately look forward to a spreadshet from me next year...
view entire thread
Tags
loading ...