It was set up by gerbernomics.
That was a fun thread, I'll link it here.
Last year we did a spreadsheet that everyone could give their predictions on players point totals based on 82 games played. Does anyone know who started that, and if we can get that spreadsheet started again. I would take a stab at creating that sheet, but it would be so much easier if we could just re-use the same setup.
I know it was really nice to use in my league setup, plus it cut down on threads about "please reank these four guys".
Thanks
theslymonkey
EDIT: Thanks to Penguin7 and gerbernomics I have created a new Google Spreadsheet.
https://docs.google.com/spreadsheet/...neDN1RWc#gid=0
Pick a column, Label the top with something, put in your predictions.
Google saves all changes automatically so just try not to touch any of the stuff on the left of the Black column.
There are now two sheets, Forwards and Defense on the bottom of the spreadsheet, under the "left/right" scroll bar.
Last edited by theslymonkey; August 29, 2012 at 1:31 PM.
14 Team, Keep14 Farm5, 82GP Cap/Position
Skaters: Points only, Goalies 2ptWin/3ptSO
Start: 4C,4LW,4RW,6D,2G
C- Crosby, Zibanejad, Couturier, Zacha, Frost
LW- Marchand, Huberdeau, McTavish, Rackell, Kuzmenko
RW- Konecny, Necas, Caufield, Jarvis, Lafreniere
D- Hughes, Carlson, Werenski, Chychrun, Andersson, Dobson, Weegar
G- Andersen, Merzlikins, Daccord, Jones
Farm- Johnston, Foerster, Tarasov, Hutson, Reinbacher
Picks-1,2,3,4,5,6,7,8,9,11
It was set up by gerbernomics.
That was a fun thread, I'll link it here.
14 Team, Keep14 Farm5, 82GP Cap/Position
Skaters: Points only, Goalies 2ptWin/3ptSO
Start: 4C,4LW,4RW,6D,2G
C- Crosby, Zibanejad, Couturier, Zacha, Frost
LW- Marchand, Huberdeau, McTavish, Rackell, Kuzmenko
RW- Konecny, Necas, Caufield, Jarvis, Lafreniere
D- Hughes, Carlson, Werenski, Chychrun, Andersson, Dobson, Weegar
G- Andersen, Merzlikins, Daccord, Jones
Farm- Johnston, Foerster, Tarasov, Hutson, Reinbacher
Picks-1,2,3,4,5,6,7,8,9,11
It told me i need permission ([email protected])
24 Team Dynasty, H2H , NHL Salaries & Cap 94M$.
3C , 3R , 3L, 4D, 1SKT, 2G , 4B , 5Farm
G,A,SPT,HT,BLK,SHOTS,FOW... W,SV,SV%,GAA
C: E.Kuznetsov. B.Neilson, B.Hayton
LW: J.Huberdeau, J.Kyrou, D.Heinen
RW: J.Virtanen, V.Hinostraza, E.Tolvanen
D: C.Makar, T.Chabot, M.Dumba, M.Matheson,
SKT:C.Sissons
G: B.Bishop, A.Raanta
B: A.Anisimov, C.Fischer, T.Pitlick, A.Martinez, N.Zaitsev
Farm: V.Kravtsov, J.Gauthier, R.Lavoie, I.Konovalov, M.Berdin
2021 picks: 2/1'st , 3/2nd's
Whoa, this is awesome. I'd do it myself of course but I have enough trouble turning a computer on let alone messing with a spread sheet!! Will you give us the link in this thread? You are a Sly Monkey!! Why re invent the wheel, and I think guys will love this again this year. Gerbernomics, thanks where every you are!
14 Team Roto; Keep 25; 12 F, 6 D, 2 G; 10 Farm; 5 Bench; 5 IR;
Salary Cap - 102.5 Mil
Scoring Cats: G, A, Pts, PIM, Hits, BS, SOG, F Points, D Points; Win+Ties+SO, GAA, SV%
Keepers
F: Aho, Larkin, DeBrincat, Vrana, Bennett, Scheifele, Kakko,Tolvanen, McBain,
D: Heiskanen, Fox, Toews, Lundqvist
G: Swayman, Andersen, Copley
Drops
F: Gaudreau, Terravainen, Puljujarvi, Kravstov, Zary
D: Brannstrom, Cernak, Alexeyev
G: Korpisalo, Merzlikins
FARM: Rossi, Berggren, Holtz, Savoie, Clarke, Tarasov, Wolf
Sorry everyone, I forgot to change it from Private to Public. It should work now.
14 Team, Keep14 Farm5, 82GP Cap/Position
Skaters: Points only, Goalies 2ptWin/3ptSO
Start: 4C,4LW,4RW,6D,2G
C- Crosby, Zibanejad, Couturier, Zacha, Frost
LW- Marchand, Huberdeau, McTavish, Rackell, Kuzmenko
RW- Konecny, Necas, Caufield, Jarvis, Lafreniere
D- Hughes, Carlson, Werenski, Chychrun, Andersson, Dobson, Weegar
G- Andersen, Merzlikins, Daccord, Jones
Farm- Johnston, Foerster, Tarasov, Hutson, Reinbacher
Picks-1,2,3,4,5,6,7,8,9,11
that old spreadsheet became a monster! i'll be putting mine in this week. if you guys want, i can include dobber, hockey news, mckeens (when it comes out), forecaster, etc...
15-Team keep 6f, 3d, 1g pts-only, wins=2, SO=3, OTL=1
F: Robertson, Thompson, DeBrincat, McCann, Tomasino, Chytil, Brink, Carlsson, Berggren, Guenther
D: Morrissey, Montour, Jiricek, Perbix, LaCombe, Perunovich
G: Talbot, Kuemper, Merzlikins, Kochetkov, Copley
I think the spreadsheet is an awesome idea.
That said, and maybe it's not my business, but I'm not sure it'd be right to include the info from the different guides. These guys, Dobber included, put a lot of work into their predictions and rightly charge a price for it. Taking their work and making it avalaible to everyone for free kinda defeats that. Anyway, that's just my two cents.
Yeah... I kind of agree.
I paid for Dobber's guide.
That said, perhaps you can make a separate spreadsheet with all of the magazine predictions. Then maybe you can combine them & average that. And then you could put a column in the public shared spreadsheet that says "Magazines". You don't need to reference which ones you are using, don't even tell us. But it would be good to see how we stack up.
Actually, I've found that one of the very, very best predictions come from going to betting sites. They actually have their a$$ on the line for their numbers. Last year I tracked bodog's numbers (I called it *Vegas* in your, gerbernomics, spreadsheet). Those numbers were the best of any predictions from last year.
Awesome Sly....thanks, rep to you.
this sheet will be a monster!
is column F the AVG of what we are imputting?? i.e it would be nice to see the avg of all of the numbers once the sheet is done.
...thnx again
Hockey Pools? Too many to mention. Points only, salary cap and dynasty.
I get where you guys are coming from ........ perhaps gerbernomics could just list them as magazine A, B, C etc .... then we dont know which is which and one would have to buy them to find out, but it also doesnt just wash out all the numbers with an average of 5 sources ...... just a thought
Last edited by wendelclark17; August 29, 2012 at 10:12 AM.
what i will do in this case is simply put mag avgs, from 5 or 6 different guides, to insulate the fact that a lot of work goes into those numbers and they are pay guides.
15-Team keep 6f, 3d, 1g pts-only, wins=2, SO=3, OTL=1
F: Robertson, Thompson, DeBrincat, McCann, Tomasino, Chytil, Brink, Carlsson, Berggren, Guenther
D: Morrissey, Montour, Jiricek, Perbix, LaCombe, Perunovich
G: Talbot, Kuemper, Merzlikins, Kochetkov, Copley
P7 in da P column!
yeah F is the average
6 teams dynasty pool,points only,no pos. for F, Keep All, 12F, 6D, 2G count.....backup=6F, 4D, 2G, 4 roster moves( 2 at 30th game and 2 at NHL deadline)
F- , P. Kane,Eichel, DeBrincat, Kopitar, Wheeler, Kuznetsov, Point, Huberdeau, Verhaghe, Bergeron,Keller, Batherson, Schmaltz, W.Nylander, Buchnevich,Rantanen
D- Makar, Gostisbehere, Carlson, Burns, Barrie, M. Rielly, Hronek, DeAngelo, KA Miller
G- Vasilevskyi, Sorokin, Campbell, Markstrom
Farm: Lundell, Guenther, Holtz, Glass, E. Svechnikov, Denisenko, Newhook, Heponiemi, Lauko,Neighbours, Bokk N. Foote, Borgstrom, Dahlen, Bokk, S. Poulin, Zelleweger, Liljegren, Heinola, Perunovich, S. Knight.