2015 Recycle Rush Score Calculator

[Chris G]

James,
Quick fix for your spreadsheet, as it calculates litter incorrectly for the opposite Alliance color.

Cells Q11-Q20

Change formula from:

=IF(EXACT(N11,$Z$5),IF(EXACT(UPPER(P11), $X$5),1,0))

to

=IF(EXACT(N11,$Z$5),IF(EXACT(UPPER(P11), $X$5),1,0),0)

...added a ",0" to the end of the formula so as make the output zero if alliance is not "Red". Likewise, do the same for cells R11-R20

from

=IF(EXACT(N11,$Z$5),IF(EXACT(UPPER(P11), $X$5),1,0))

to

=IF(EXACT(N11,$Z$5),IF(EXACT(UPPER(P11), $X$5),1,0),0)

This fixes the problem is alliance is not "Blue"

That's all I've found so far. Thanks for the calculator!

Chris

P.S. A form reset button to clear all inputs would be nice...I can do it but not right now......