Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

Thread: Comish Dynasty Playoff Standings 2012

  1. #1
    temek's Avatar
    temek is online now
    Join Date
    Aug 2009
    Posts
    231
    Rep Power
    14

    Dobber Sports Prodigy

    Default 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
    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.
    Attached Files Attached Files
    Last edited by temek; April 27, 2012 at 4:58 PM.

  2. #2
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    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
    Attached Files Attached Files

  3. #3
    temek's Avatar
    temek is online now
    Join Date
    Aug 2009
    Posts
    231
    Rep Power
    14

    Dobber Sports Prodigy

    Default

    Quote Originally Posted by Chinny View Post
    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
    I found an error in mine, but everything matches apart from G,A, PIM and PPP for goalies. It doesn't seem like your spreadsheet counts them at all. It doesn't make a much of a difference, but you might want to check that. I think Brodeur has 2 A, 1 PPP and Clemmensen 1 A, 1 PPP and that's the only difference.
    Last edited by temek; April 27, 2012 at 3:48 PM.

  4. #4
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    Quote Originally Posted by temek View Post
    I found an error in mine, but everything matches apart from G,A, PIM and PPP for goalies. It doesn't seem like your spreadsheet counts them at all. It doesn't make a much of a difference, but you might want to check that. I think Brodeur has 2 A, 1 PPP and Clemmensen 1 A, 1 PPP and that's the only difference.
    Our league doesn't count that for goalies, at least Fantrax didn't and my sheet is meant to copy the regular season

  5. #5
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    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
    Attached Files Attached Files

  6. #6
    temek's Avatar
    temek is online now
    Join Date
    Aug 2009
    Posts
    231
    Rep Power
    14

    Dobber Sports Prodigy

    Default

    Quote Originally Posted by Chinny View Post
    Our league doesn't count that for goalies, at least Fantrax didn't and my sheet is meant to copy the regular season
    I thought they did count, but I don't think you can actually see that in Fantrax (I couldn't find a team log or something like that). I assumed the following setting in Fantrax, Players will always accumulate stats in all scoring category groups: Yes, did specifically that as in counting G,A,PIM and PPP for goalies. I am not 100% sure though so maybe Comish can clarify about that. As it's likely impossible to see whether they counted, it's probably better to not count them.

  7. #7
    iamlilc's Avatar
    iamlilc is offline
    Join Date
    Aug 2009
    Posts
    974
    Location
    Ottawa
    Rep Power
    15

    Dobber Sports Initiate

    Default

    I somewhat recall that the goalie scoring stats didn't count.

    Either way, thank you both for doing the playoff stats!
    24 GM – 3 Tier Salary Cap Roto Dynasty League + Roto Playoffs (Keep 32 of 35)
    G, A, +/-, PIM, SOG, STP, HITS, BS, W, GAA, SV | 4C, 4LW, 4RW, 6D, 1G

    C - Crosby, Turris, K.Hayes, Nugent-Hopkins, Gourde, Blandisi, Lazar, Aston-Reese
    LW - Ovechkin, JT.Miller, N.Ritchie, Barbashev, Vrana, Kempe, McCann, Kossila
    RW - Eberle, Shaw, Vrbata, Andrighetto, Armia, M.Sorensen, Tippett, T.Mitchell
    D - Klingberg, J.Schultz, Klefbom, Forbort, Matheson, Chabot, P.Martin, M.Reilly
    G - J.Gibson, Stalock, McElhinney

  8. #8
    ccsitdown's Avatar
    ccsitdown is offline
    Join Date
    Apr 2008
    Posts
    1,252
    Location
    Brooklyn
    Rep Power
    14

    Dobber Sports Ace

    Default

    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.
    20-Team Keeper League
    PTS: G=1, A=1, W=2, SO=3
    Starting roster: 6F, 3D, 1G, *Keep 12

    F: Tarasenko, Kucherov, Scheifele, Eichel, Pavelski, J.T. Miller, Goldobin (farm)
    D: Doughty, Josi, Ekman-Larsson, Sanheim (farm)
    G: Crawford, Hellebuyck

    16-Team Keeper League
    PTS: G=1, A=1, W=2, SO=3
    Starting roster: 6F, 4D, 1G, *Keep 12 + 4 on farm
    F: Kane, Kessel, Pastrnak, Parise, Couture, Radulov, Zuccarello, Fabbri, Keller
    D: Weber, Karlsson, Pietrangelo, Parayko
    G: Rask,
    Farm: Bjorkstrand, Fiala

  9. #9
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    Quote Originally Posted by ccsitdown View Post
    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.
    I remember seeing goalie stats there as well, but at the same time they arent still there which leads me to believe they dont keep them there.
    But again i am not sure how it is supposed to go

  10. #10
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    update prior to game 6
    Attached Files Attached Files

  11. #11
    NordiqueFan's Avatar
    NordiqueFan is offline
    Join Date
    May 2008
    Posts
    1,186
    Rep Power
    12

    Dobber Sports Padawan

    Default

    what are the final result
    30GMs Dynasty
    G A +- PIM PPP SOG W Saves GAA
    4LW- Maroons, Hoffman, Eriksson,, Namesnikov
    4C- J.Carter, Wennberg, Backlund, Anisimov
    4RW-Kucherov, Labanc, Yakupov, Burakovsky
    6D- Barrie, Savard, Dumoulin, Methot, Ouellet, Theodore
    1G-Dubnyk, Smith,

    bench- Crouse, Beauvillier, Juulsen, , Stolarz, Puljujarvi, Bracco, C.White, Debrincat, Bears, Girard, kerffot, saarela, cirelli

    *******

  12. #12
    Chinny's Avatar
    Chinny is offline
    Join Date
    Mar 2008
    Posts
    1,836
    Rep Power
    0

    Dobber Sports Stud

    Default

    Final results
    Attached Files Attached Files

  13. #13
    Location
    Ottawa
    Rep Power
    50

    Dobber Sports Samurai

    Default

    Thanks Chinny for the stats. Congrats to Das Chicleteur! for winning the playoffs!


    The pen is mightier than the sword...unless someone is trying to stab you with a sword. Then, it's the sword...definitely the sword.

  14. #14
    Location
    Saint-Hyacinthe,
    Rep Power
    27

    Dobber Sports Giant

    Default

    Quote Originally Posted by The Comish View Post
    Thanks Chinny for the stats. Congrats to Das Chicleteur! for winning the playoffs!
    Thanks Russ! Is it time to announce the rules change you told me about the other day where the winner of the playoff gets the 1st overall pick?
    24GMs Dynasty (G A +- PIM STP SOG HITS BLK W SV GAA / 4C, 4LW, 4RW, 6D, 1G)
    Cap hit: $1073 out of $1100

    C- Dvorak $5, Galchenyuk (LW) $52, Guentzel $5, EStaal $81, Hischier $5, Shipachyov (LW) $5, RWhite (RW) $19, Hawryluk $5
    LW- Elhers $39, Konecny (LW) $5, Kreider $92, Sobotka $5, Ennis (RW) $5, Bjork $5, Jones $5, Kovalchuk (RW) $5
    RW- Clutterbuck $35, Duchene (C) $38, Pastrnak $67, Radulov $5
    D- Borowiecki $61, Boychuk $75, Faulk $66, Karlsson $165, Parayko $53, Russell $40, Kulikov $5, Morin $5, Makar $5, Fabbro $5
    G- Vasilevskiy $56, Budaj $44, Forsberg $5, Shesterkin $5

  15. #15
    bctopdawg's Avatar
    bctopdawg is offline
    Join Date
    Aug 2007
    Posts
    249
    Location
    Georgetown, ON
    Rep Power
    0

    Dobber Sports Prodigy

    Default

    Thanks for the final standings, and I reluctantly congratulate Chic AGAIN.

    I hope next year, with a healthy SID I can give you atleast half a run

    Enjoy the summer all !

    Bleedblue
    Comish Dynasty

    24 Team / 3 Tier Roto League
    CAP = $1200
    G.A.+/-.PIM.STP.SOG.BS.HITS
    W.GAA.SV%.SV

    Tier 1
    C - Scheifele, Stamkos, Eichel, Komarov, D.Strome
    LW - Gaudreau, Palat, Schenn, Trocheck, Domi, Vatrano
    RW - Forsberg, T.Wilson, Clutterbuck, Shaw, Nichoshkin
    D - PK, OEL, Trouba, Jones, Martinez, Myers, Despres, Beauchemin, Pouiliot,
    G - Allen, Elliott, Gibson

    Cap = $1116

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •