Just a few things here. First off, the Smash Records needed to be cleaned up, so I've given them quite the overhaul. I transferred everything over to an Excel spreadsheet (now that my laptop is revived) instead of Microsoft Works Spreadsheet Editor so it should look a little
cleaner.
Next, I've set up formulas and a few macros, so now I only have to input data in six fields, and the formulas take care of everything including Rank, Games Behind, Win Percentages, etc. as well as moving everything into rank order. What I'm saying is that the computations are correct. I know some may not look it, but they're correct.
And for those who are curious, this is the current formula that I'm using to determine rank:
= (
Division Win Percentage +
Overall Win Percentage)/2 +
Round Win Percentage/100 +
Kill Differential/100,000
So you'll note that primarily, rank is determined by equal parts Division Win Percentage and Overall Win Percentage. Round Win Percentage acts as an initial tie breaker (the large denominator associated with it assures that it doesn't interfere with the first term), and Kill Differential acts as a secondary tie breaker (same principle). This outputs a composite score that Excel ranks from largest to smallest to determine division rank. I thought you guys might be curious given that your division rank will determine whether or not you participate in the post-season bowls.
But, do keep in mind that this formula may change given that it hasn't been thoroughly discussed among the three co-hosts. If you guys have some input on the matter, please, do state it.
And, without further ado (up to date through the Yukine v. Foo match):