So I wanted to keep with the playoff situation and made a spreadsheet for myself. I am sure I am not the only who'd like to keep up the with standings daily so I might as well share with everyone else. Playoff standings are Chinny's responsibility, but I am sure he doesn't mind.
I made the spreadsheet using openoffice so it doesn't work correctly in excel.
Some instructions to use the spreadsheet.
1.Allow macros
2.Open the spreadsheet and select yes when it asks to update links(this step might freeze program up to a minute so just wait)
3.Click the Replace and Sort buttons and you should have your standings.
Current standings after 1st round of playoffs. Tier winners will pick before 5th overall anyway so it doesn't actually matter how they finish so 5th overall would go to The Comish currently and so on.
EDIT: found an error so had to update the standings and the spreadsheet
Code:
Team GP G A +/- PIM PPP SOG G GP W GAA SVS
Tier 1 Das Chicleteur 72 20 27 5 101 19 188 2 1 1,73 43
Tier 3 LU Timbersports 60 12 18 3 47 10 104 5 4 1,59 164
The Comish 62 12 13 3 26 9 128 7 4 2,06 166
jl67SixtyS ilverSevens 71 12 14 -8 45 3 138 7 4 1,7 205
The Guru 73 7 19 -3 65 9 109 5 4 1,81 151
Backmarkers 69 10 29 -5 40 20 145 3 1 2,35 81
iamlilc 67 6 16 -7 88 7 124 7 3 2,14 191
Nordique 61 10 11 7 54 6 120 6 4 3,89 142
Bleedblue 69 10 21 0 61 14 116 0 0 100 0
Tier 2 Maroons 69 10 20 -20 57 12 160 0 0 100 0
Great Wall of Chinny 40 6 8 -12 27 2 99 3 1 1,31 97
UW Ain't Rad 46 6 8 -3 59 4 109 0 0 100 0
Code:
Team G A +/- PIM PPP SOG W GAA SVS Total
Tier 1 Das Chicleteur 12 11 11 12 11 12 5 9 4 87
Tier 3 LU Timbersports 10 7 9,5 5 8 2 10 11 9 71,5
The Comish 10 4 9,5 1 6,5 8 10 7 10 66
jl67SixtyS ilverSevens 10 5 3 4 2 9 10 10 12 65
The Guru 4 8 6,5 10 6,5 3,5 10 8 8 64,5
Backmarkers 6,5 12 5 3 12 10 5 5 5 63,5
iamlilc 2 6 4 11 5 7 7 6 11 59
Nordique 6,5 3 12 6 4 6 10 4 7 58,5
Bleedblue 6,5 10 8 9 10 5 2 2 2 54,5
Tier 2 Maroons 6,5 9 1 7 9 11 2 2 2 49,5
Great Wall of Chinny 2 1,5 2 2 1 1 5 12 6 32,5
UW Ain't Rad 2 1,5 6,5 8 3 3,5 2 2 2 30,5
I assumed we have min GP 1 requirement for goalies so your team is ranked (tied) last if you goalie hasn't played a game. I also included G,A, PIM and PPP for goalies. All should be up-to-date, but keep me posted if you find errors.
