View Single Post
  #2   Spotlight this post!  
Unread 09-01-2005, 15:35
Adam Richards's Avatar
Adam Richards Adam Richards is offline
I'm baaaaaaack.
FRC #1902 (Exploding Bacon)
Team Role: College Student
 
Join Date: Jan 2005
Rookie Year: 2005
Location: Orlando, FL
Posts: 1,062
Adam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond reputeAdam Richards has a reputation beyond repute
Send a message via AIM to 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:

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.
Reply With Quote