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
    266
    Rep Power
    21

    Dobber Sports Blue-Chipper

    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 3: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
    266
    Rep Power
    21

    Dobber Sports Blue-Chipper

    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 2: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
    266
    Rep Power
    21

    Dobber Sports Blue-Chipper

    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
    990
    Location
    Ottawa
    Rep Power
    21

    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, W.Nylander, Kempe, B.Howden, Wallmark, Z.Sanford, Newhook
    LW - Ovechkin, Vrana, S.Bennett, Lehkonen, Aston-Reese, T.Benson, S.Poulin
    RW - JT.Miller, Coleman, Gourde, Dzingel, Tippett, Volkov
    D - Klingberg, Chabot, Slavin, Matheson, Chychrun, Sanheim, D.Toews, E.Bouchard, Cholowski
    G - J.Gibson, DeSmith, Sparks, Luukkonen, Starrett

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

    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 + 2 on farm

    F: Kucherov, Scheifele, Eichel, Tarasenko, Rakell, Schwartz, Dadonov
    D: Doughty, Josi, Ekman-Larsson, Keith
    G: Hellebuyck
    Farm: Tolvanen, Kaprizov

    16-Team Keeper League
    PTS: G=1, A=1, W=2, SO=3
    Starting roster: 6F, 4D, 1G, *Keep 12 + 4 on farm
    F: P Kane, Kessel, Pastrnak, Keller, Marchessault, B Schenn, Fiala, Kase,
    D: Weber, Karlsson, Pietrangelo, Parayko
    G: Rask
    Farm: Kravtsov, A Boqvist, Necas, I Samsonov

  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,341
    Rep Power
    19

    Dobber Sports Ace

    Default

    what are the final result
    Member of Comish Dynasty 24 team (since the beginning) (Nordique)
    Member of King Of Hockey League (Columbus)
    Member of Great Dynasty (Colorado)
    Member of United Hockey League (Los Angeles)
    Member of Global Hockey league (since the beginning) (Washington)
    Member of Vnhl (Quebec)

    *******

  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 Ninja

    Default

    Thanks Chinny for the stats. Congrats to Das Chicleteur! for winning the playoffs!
    "For I am a sinner in the hands of an angry God. Bloody Mary, full of vodka, blessed are you among cocktails. Pray for me now and at the hour of my death, which I hope is soon. Amen." - Sterling Archer

    "Don't spray that urine on my sons window. If you want a dollar for doing nothing, walk to Canada." - Malory Archer

    “Anyone who thinks the pen is mightier than the sword has not been stabbed with both.” - Lemony Snicket

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

    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?

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

    Dobber Sports Blue-Chipper

    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
  •