|
|
|
![]() |
|
|||||||
|
||||||||
|
|
Thread Tools | Rate Thread | Display Modes |
|
#2
|
|||||
|
|||||
|
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: Code:
=((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) Last edited by Adam Richards : 09-01-2005 at 15:38. |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| White Paper Discuss: Continuous Improvement Process for FIRST Teams | Chris Fultz | Team Organization | 2 | 05-01-2005 20:52 |
| White Paper Discuss: Comparison Paper for Teacher Involvement | CD47-Bot | Extra Discussion | 1 | 13-11-2004 00:09 |
| White Paper Discuss: Championship 20004 results for all divisions | CD47-Bot | Extra Discussion | 1 | 23-04-2004 02:05 |
| White Paper Discuss: Team 234 Cyber Blue Chairman's Submittal 2004 | CD47-Bot | Extra Discussion | 1 | 19-04-2004 10:56 |
| White Paper Discuss: Pocket PC 2002 Scoring Program | CD47-Bot | Extra Discussion | 3 | 16-01-2003 09:45 |