The google doc spreadsheet is coming along. There's a lot that can be done with the math. Here is a view-only link to the sheet...
https://spreadsheets.google.com/ccc?key=0Avus1s5lh50BdGVka2ZHZHhTR0oxOHFOYWdGajRveHc&hl=en
Because of the way that protecting the sheet from changes works, I have been rethinking how it would be used with judges. Here's how I think it would work...
- Create a "submission" form for players to fill out with all the relevant scores. This form populates a new row in a spreadsheet with all the "raw" scores for that PC.
- This sheet and the template belongs to the l4w.judges google account so that they can be managed by any judge.
- The first judge creates a new copy of the "checker" template which does all the math and creates a sheet for judges to compare to the character sheet in the wiki. This checker sheet would be created for each level review for a character.
- The first judge then copies the raw scores from the submission form into the checker sheet, which then does all the math automagically and calculates the final scores.
- The first judge shares the "checker" sheet so that player's can view (but not edit) the sheet the judge is using to double-check math. This link can be inserted into the judge's approval comments in the wiki too.
- The second judge reviews the link to the checker sheet and also compares to the wiki page.
I think this process provides the right amount of control for judges to be certain that no one has changed the math, either by accident or design. It also gives players an easy way to fill out the basic info for judges to plug into the checker. And everything is linked to the existing gmail account that the judges use for email notices about character submissions. They can share the finished sheets view-only and provide a URL that anyone at L4W can see what is going on, so the process is still transparent.
The disadvantage over the current method is that it is external to the ENworld site. This process also relies on the judges to perform a few extra steps that will take 5-10 minutes for each character review.