View Single Post
  #4   Spotlight this post!  
Unread 09-01-2005, 20:42
Steve Howland Steve Howland is offline
Many years, many teams
FRC #2473 (Goldstrikers)
Team Role: Engineer
 
Join Date: Mar 2004
Rookie Year: 2003
Location: Mountain View, CA
Posts: 763
Steve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond reputeSteve Howland has a reputation beyond repute
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
Reply With Quote