Go to Post This is the hint that never ends, yes it goes on and on my friend. Some people start guessing not knowing what it was, and they'll continue to guess forever just because... - JaneYoung [more]
Home
Go Back   Chief Delphi > ChiefDelphi.com Website > Extra Discussion
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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


All times are GMT -5. The time now is 05:43.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi