Here is my version of the scoring spreadsheet. I tried to test it pretty thoroughly, but easy to miss some stuff, so let me know if you find any bugs. It doesn't have any support for the Loot or Winning Bonuses yet as they don't apply in the Qualifier Round.
The one quirky area is in the support global list. Because support can keep hunting after the cap is reached to try to get missing scoring categories for the variety/sweep/bonus mob, but those ped don't count toward the support ped total there is a separate location to enter those additional globals at the bottom of the support global list. You'll see once you get in the spreadsheet...
There are just 3 additional spots, as that is the most you should need to enter to fulfill any missing scoring categories/bonus mob.
Regardless of what the total support score shows at the top of the support global list, their score gets capped at 100 when it is recorded up in the summary at the top. The only way it goes above that is if main or support teams score an ATH.
All bonuses, HOFs, Susans, ATH scoring and doubling should happen automatically as long as you indicate with "H", "S" or "A" next to the ped amount when you enter the global.
The bonus mob points always automatically shows up in the Main Team section regardless of where it gets recorded. It just made it easier for handling doubling, etc.
The thing kept spreading out, so it may be best viewed at 75%. I liked the way Jamira did the freeze panes to keep the upper portion of the scoring chart always in view, but it does make getting screenshots at the end of the event more difficult. The easiest way to do it is to unfreeze the panes. First you will have to "unprotect" the document under the "review" tab. Password is "wofusa". Then under the "View" tab, select "Unfreeze Panes". Then you can scroll down and grab a couple of screenshots that cover the entire document and cut and paste them together. Someone know a better way to do this?
Holler if you have any questions or suggestions to improve it. I'm definitely not an Excel guru, so I'm sure there might be better ways to do some of this stuff.
Thanks to Jamira for the initial layout.
Judges Spreadsheet for WOF Qualifier 2
-Mack