[Joe Johnson]

Originally Posted by Joe Ross

Besides entering the teams in the "TEAM NAME DATA" worksheet, you must also enter the team number in the "Team Summary" worksheet. That's relatively easy to fix by changing A2 on the "Team Summary" worksheet to ='TEAM NAME DATA'!A2 and dragging down.

You are right, I just got sloppy at the end and missed this. This was page was the relative easy part and I was tired...

Originally Posted by Joe Ross

You seem to be making the same mistake calculating RP as I initially did. The winner should get the lower of the unpenalized score of the winner or loser (per team update 15). Lets say Blue scores 19 and Red 25, and each has a 10 point penalty. The net score is Blue 9, Red 15. The losers RP is the losers net score, 9, which you get correct. However the winners RP is the lower of the teams raw score, which is 19. You currently have it at 15.

I have to admit that I have NOT read the rules on this one. BUT, folks I know and trust have told me this is what FIRST intended by the rules whatever they SAY and that this is how they want the ranking implemented.

I will see what I can find out...

Joe J.