 |
|
|
#1
04-27-2012, 09:06 AM
|
||||
|
||||
Comish Dynasty Playoff Standings 2012
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 Last edited by temek; 04-27-2012 at 03:58 PM. 
|
|
#2
04-27-2012, 01:51 PM
|
||||
|
||||
|
Thanks temek,
Sorry i have just been super busy, here is the excel version and a pdf stats i will try to update this frequently as well hopefully everything matches! the excel sheet will auto update for you on open, if you have any issues with it let me know and i can help you out or fix it
__________________
The Comish's Dynasty Pool - YR1 Dual Champ! G,A,+/-,PPP,PIM,SOG,W,GAA,SVS 3C- Toews $74, , Lecavalier $119, Madden $29 3L- McDonald (C) $65, Avery $60, MacArthur $22 3R- Semin $108, C.Stewart $5, Kopecky $12 4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50 1U- Ja.Williams $51 1G- Emery $5 BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5 IR- Burish $17, Lupul $66, Hemsky, Bieksa Cap hit $927
|
|
#3
04-27-2012, 02:33 PM
|
||||
|
||||
|
Quote:
Last edited by temek; 04-27-2012 at 02:48 PM.
|
|
#4
04-28-2012, 05:10 PM
|
||||
|
||||
|
Quote:
__________________
The Comish's Dynasty Pool - YR1 Dual Champ! G,A,+/-,PPP,PIM,SOG,W,GAA,SVS 3C- Toews $74, , Lecavalier $119, Madden $29 3L- McDonald (C) $65, Avery $60, MacArthur $22 3R- Semin $108, C.Stewart $5, Kopecky $12 4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50 1U- Ja.Williams $51 1G- Emery $5 BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5 IR- Burish $17, Lupul $66, Hemsky, Bieksa Cap hit $927
|
|
#5
04-28-2012, 05:18 PM
|
||||
|
||||
|
Updated the stats and fixed an issue in my excel sheet, the goalie stats seemed to be loaded in as text instead of a number on occasion
__________________
The Comish's Dynasty Pool - YR1 Dual Champ! G,A,+/-,PPP,PIM,SOG,W,GAA,SVS 3C- Toews $74, , Lecavalier $119, Madden $29 3L- McDonald (C) $65, Avery $60, MacArthur $22 3R- Semin $108, C.Stewart $5, Kopecky $12 4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50 1U- Ja.Williams $51 1G- Emery $5 BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5 IR- Burish $17, Lupul $66, Hemsky, Bieksa Cap hit $927
|
|
#6
04-28-2012, 07:00 PM
|
||||
|
||||
|
Quote:
|
|
#7
05-04-2012, 07:19 AM
|
||||
|
||||
|
I somewhat recall that the goalie scoring stats didn't count.
Either way, thank you both for doing the playoff stats!
__________________
24 GM Salary Cap Roto Dynasty League + Roto Playoffs G,A,+/-,PPP,PIM,SOG,W,GAA,SV | 4C,4LW,4RW,6D,1G Kovalchuk - Bergeron - Hossa Moulson - Turris - Simmonds Saad - Perreault - Z.Kassian Stalberg - Bjugstad - J.Ward Streit - Carlson Leddy - Carle Nikitin - Franson Crawford Bench: Flynn, Gomez, T.Johnson, Jenner, Winnik, Pulkkinen, Frolik, Ma.Stone, Galiev, Noesen, Kuba, McQuaid, Oleksy, Donovan, E.Gelinas, Lehner
|
|
#8
05-20-2012, 04:15 PM
|
||||
|
||||
|
Fantrax counted the goalie stats - when Cam Ward scored, his name appeared at the bottom of my skaters list, grayed out, and it tabulated his goal.
__________________
24-Team Keeper League PTS: G=1, A=1, W=2, SO=5 Starting roster: 6F, 3D, 1G, *Keep 12 F: Spezza, Kovalchuk, Krejci, Franzen, Pacioretty, Steen, Berglund, Erat, PMB D: Keith, Weber, Visnovsky, Leddy G: Lundqvist, Harding 16-Team Keeper League PTS: G=1, A=1, W=2, SO=3 Starting roster: 6F, 4D, 1G, *Keep 12 + 4 on farm F: Benn, Krejci, Kessel, Skinner, Ryan, Parise, Clowe, C. Smith, Boedker, Leblanc D: Edler, E Johnson, Campbell, Kronwall, Petry, McDonagh, Hamonic G: Price, Rask Farm: Schwartz, Zibanejad, Bjugstad, Dumba
|
|
#9
05-25-2012, 10:09 PM
|
||||
|
||||
|
Quote:
But again i am not sure how it is supposed to go
__________________
The Comish's Dynasty Pool - YR1 Dual Champ! G,A,+/-,PPP,PIM,SOG,W,GAA,SVS 3C- Toews $74, , Lecavalier $119, Madden $29 3L- McDonald (C) $65, Avery $60, MacArthur $22 3R- Semin $108, C.Stewart $5, Kopecky $12 4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50 1U- Ja.Williams $51 1G- Emery $5 BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5 IR- Burish $17, Lupul $66, Hemsky, Bieksa Cap hit $927
|
|
#10
05-25-2012, 10:13 PM
|
||||
|
||||
|
update prior to game 6
__________________
The Comish's Dynasty Pool - YR1 Dual Champ! G,A,+/-,PPP,PIM,SOG,W,GAA,SVS 3C- Toews $74, , Lecavalier $119, Madden $29 3L- McDonald (C) $65, Avery $60, MacArthur $22 3R- Semin $108, C.Stewart $5, Kopecky $12 4D- Phaneuf $107, Wisniewski $35, Goligoski $5, Robidas $50 1U- Ja.Williams $51 1G- Emery $5 BN- B.Stuart(D) $20, C.Bourque(LW) $5, Pickard(G) $5, Abdelkader(LW) $5, Conklin(G) $45, Y.Weber(D) $5, Leighton(G) $5 IR- Burish $17, Lupul $66, Hemsky, Bieksa Cap hit $927
|
 |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT -4. The time now is 02:43 AM.
