Thread: Excel Scoring Spreadsheet
View Single Post
  #9   Spotlight this post!  
Unread 09-01-2005, 12:04
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: Excel Scoring Spreadsheet
Very good spreadsheet - nice work!

Found one small error - in totaling Blue's total score the cell referred to for number of robots behind the end zone is red's cell.
Code:
(IF(H2=3,10,0))
should read
Code:
(IF(I2=3,10,0))
But still very nice - far more code then I understand in excel!
Attached Files
File Type: xls TripPlayScore.xls (19.0 KB, 62 views)