White Paper Discuss: Triple Play Scoring Spreadsheet

[Steve Howland]

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

[cbudrecki]

Originally Posted by Steve Howland

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

you just wanna see how long i can make the code in that scoring box. unfortunately, I don't have my usual access to Excel, but maybe once school starts up for me (next week) I'll see what I can do.