Just wanted to say, in using Lena's spreadsheet, the calculators on the right need to be coded to include ALL the values in the middle set of columns - for example, if Sim 2 in the first set of columns was actually the first one you listed in the second set of columns(let's say they hit the level you were aiming for first, so you listed them first or something), their score would appear as 0 in the third set of columns because the coding isn't looking for Sim 2's name in ALL the data, only from row 4 down.
It's really only an issue if you listed them in a different order in the second set of columns than in the first set, but that might happen depending on how people track I guess. So instead of coding of
For J3: "=SUMIF(G3:G31;B3;F3:F31)"
For J4: "=SUMIF(G4:G32;B4;F4:F32)"
etc
It should be:
For J3: "=SUMIF(G3:G31;B3;F3:F31)"
For J4: "=SUMIF(G3:G31;B4;F3:F31)"
Does that make sense? I feel like I babbled. Sorry! I only found this incidentally while I was plotting and planning some stuff out.