[theCoder]

Rev D is now available. I added a sheet to prepare for an upcoming match. The sheet shows all teams for a match with detailed information on each. It also predicts the winner of the match.

I tried to make the input values more general. As recommended by others, making it able to handle a large range of values such as the # balls scored. It impacts the validity configuration (not too much of a problem) and the score determination logic. The score code now just multiplies the value (0, 1, or 2) times the weight. I couldn't come up with a clean way to do make the scoring logic generic enough to handle a large range. Feel free to change this yourself. You would need to change the validity of the cells B6-G11 on sheet Match Input. The score calculation code is in macro "compute_score". After hearing about the first weeks regionals, I now more than ever, want to score this regional with high/medium/low rankings. It sounds like it is going to be very hard to count the # balls scored by each robot or HP.