pooladdict please send me the spreadsheet.
30GM G A PIM +/- SOG PPP
shallif @ hotmail dot com
karma coming your way.
Just as a public service announcement: I\'ve been tinkering with a spreadsheet that ranks players based on their value in roto leagues, based on various league parameters, projections and reasonable assumptions. It\'s a pretty good way to evaluate a players\' across-the-board contributions, and I think it would be a very good tool in auto-drafts. I obviously intend to find out.
If anybody is interested in seeing the results for their league parameters, just let me know and I\'ll fire you off a top-whatever list.
So far it\'s for skaters only. Let me know how many owners are in the league, what positions there are, and what stat categories you count. I\'ve spent some time building it up so it includes even bizarro-stats (:P ) like hits, ATOI, etc.
pooladdict please send me the spreadsheet.
30GM G A PIM +/- SOG PPP
shallif @ hotmail dot com
karma coming your way.
30 GM Commish Dynasty
G A +/- PIM PPP SOG W GAA SV
Start: 3C, 3LW, 3RW, 4D, 1Utl, 1G
C:Savard,Filpulla,Arnott,Ott,Boyd,Weight,Rupp
LW:Heatley,Morrow,Sullivan,Tambellini,Bissonnette, Pierro-Zabotel
RW: Hemsky,Backes,Orr,Tikhonov,Artyukhin,Ortmeyer
D:EJ,Ehrhoff,Hjalmarsson,Babchuk,Commodore
G: M.A.Fleury,Deslauriers,Koskinen,Monnino
Hey C-nuck, what positions are there and how big are the rosters? This has a huge effect on the rankings. I don\'t want to send the whole spreadsheet (it\'s approaching 10 megs now), but I\'ll happily fire you a summary.
I\'m assuming this is for an un-named dynasty league with 3C, 3LW, 3RW, 4D, 1 util, and say an average of 5 bench?
Its the comish 3GM draft
3lw,3c,3rw,4d,1utl,1G,1bn
30 GM Commish Dynasty
G A +/- PIM PPP SOG W GAA SV
Start: 3C, 3LW, 3RW, 4D, 1Utl, 1G
C:Savard,Filpulla,Arnott,Ott,Boyd,Weight,Rupp
LW:Heatley,Morrow,Sullivan,Tambellini,Bissonnette, Pierro-Zabotel
RW: Hemsky,Backes,Orr,Tikhonov,Artyukhin,Ortmeyer
D:EJ,Ehrhoff,Hjalmarsson,Babchuk,Commodore
G: M.A.Fleury,Deslauriers,Koskinen,Monnino
Yeah, pieced that together. It\'s in your inbox.
Anybody else?
thx pooladdict
surprised to see heatley ranked 17th.
any explanations?
30 GM Commish Dynasty
G A +/- PIM PPP SOG W GAA SV
Start: 3C, 3LW, 3RW, 4D, 1Utl, 1G
C:Savard,Filpulla,Arnott,Ott,Boyd,Weight,Rupp
LW:Heatley,Morrow,Sullivan,Tambellini,Bissonnette, Pierro-Zabotel
RW: Hemsky,Backes,Orr,Tikhonov,Artyukhin,Ortmeyer
D:EJ,Ehrhoff,Hjalmarsson,Babchuk,Commodore
G: M.A.Fleury,Deslauriers,Koskinen,Monnino
Yeah, actually a pretty interesting one... your super deep league broke my spreadsheet because the average C became a \"-\".
Now I gotta figure out how to deal with negative points there... get back to you soon.
Ack, one more bug I found. Hold on!
OK, fixed. It turns out using shooting percentage can be a bad way to predict SOG if a player missed part of the season. Anyway, it\'s much more reasonable now. Heater sits at #6.
Did you send a file with the fixes?
30 GM Commish Dynasty
G A +/- PIM PPP SOG W GAA SV
Start: 3C, 3LW, 3RW, 4D, 1Utl, 1G
C:Savard,Filpulla,Arnott,Ott,Boyd,Weight,Rupp
LW:Heatley,Morrow,Sullivan,Tambellini,Bissonnette, Pierro-Zabotel
RW: Hemsky,Backes,Orr,Tikhonov,Artyukhin,Ortmeyer
D:EJ,Ehrhoff,Hjalmarsson,Babchuk,Commodore
G: M.A.Fleury,Deslauriers,Koskinen,Monnino
Yeah, it should be in your inbox.
Hey there,
Do you have a copy of this sheet that can be changed depending on the league. I have a few drafts coming up in the next couple weeks, but of course they have differing #\'s of GM and scoring categories.
The spreadsheet really is too big to fire off by email now, but it\'s not a big deal to send you the output sheets even if you want me to do it several times for your different leagues.
Give me the deets and a place to send \'em and I\'ll do it...
Thx again pooladdict
30 GM Commish Dynasty
G A +/- PIM PPP SOG W GAA SV
Start: 3C, 3LW, 3RW, 4D, 1Utl, 1G
C:Savard,Filpulla,Arnott,Ott,Boyd,Weight,Rupp
LW:Heatley,Morrow,Sullivan,Tambellini,Bissonnette, Pierro-Zabotel
RW: Hemsky,Backes,Orr,Tikhonov,Artyukhin,Ortmeyer
D:EJ,Ehrhoff,Hjalmarsson,Babchuk,Commodore
G: M.A.Fleury,Deslauriers,Koskinen,Monnino
Well I\'ll just give you the one for now, because it\'s the most convoluted and hard on my brain (and weak spreadsheet skills!).
It\'s a 16 team H2H league.
Positions are:
3C, 3LW, 3RW, 3F, 4D, 3UTIL, 2G, 9BN, 5IR
Categories are:
G, A, P, +/-, PIM, PPG, PPA, PPP, SHG, SHP, GWG, SOG, FW, GS, W, L, GA, GAA, SA, SV, SV%, SHO
It\'s messy...
Oh and email address is [email protected]
Thanks pooladdict, I\'d be interested to see how your ratings compare with my own spreadsheet.
My league is actually strickingly similar to yours:
10GMs, G, A, PTS, PPP, SHP, +/-, PIM, Shots, W, SO, S%
4C, 4LW, 4RW, 6D, 2G, 2BN
lissett at shaw dot ca
10 team, roto G, A, PTS, PIM, PPP, SHP, +/-, Shots, W, Save %, SO
2011/12 Roster:
C: Getzlaf, M. Richards, Weiss, Dubinsky
LW: Burrows, Benn, Malone, Kunitz
RW: Malkin, C. Stewart, Semin, J. Williams
D: Letang, Phaneuf, Pronger, Corvo, Del Zotto, Y. Weber
G: Kiprusoff, Backstrom, Brodeur
Bench: Smyth
Farm: L. Adam, B. Connelly, Tatar, Beach, Pulkinnen, Jeffrey, Toffoli; Subban, Pietrangelo, B. Smith, Gardiner; Rask, Dekanich, Lack.