I'm in! This could be useful. Depending on how this goes, there could be some fantasy guide improvements to be made...
Every year when the prospect guide comes out I like to take the information it has on the prospect profiles and convert them into an excel document to make it easier to sort players and create custom rankings of my own. This year I was hoping to get some help in creating this spreadsheet. I'm looking to recruit one person for each team to help me fill in this spreadsheet. In return everyone who helps will get a copy of the completed spreadsheet which will include a draft tool to help make your drafting process easier. I've already gotten permission from Dobber to create this spreadsheet. If you are interested than you can contact me via PM or email at [email protected]. You will need a copy of the guide in order to help with this spreadsheet.
When you email me send me your dobber hockey username so that way I can mark you down on the list below. I'm also looking for details on your league such as the most teams in one league, the most games played for farm eligibility in one league, and the deepest farm in one league. This stuff will be useful for when I'm creating the spreadsheet and when adding prospect profiles (I've found that the prospect guide doesn't always include all of the players eligible to be drafted in my league).
In addition to the contents of the prospect guide I'm also looking to include info such as NHL games played; age; height; weight; draft position; and links to their profile pages on NHL.com or Yahoo sports, capgeek, and Dobber Prospects.
Teams:
Anaheim - Artamus - X
Boston - letangerang58 - X
Buffalo - ccsitdown - X
Calgary - letangerang58 - X
Carolina - gopack26 - X
Chicago - letnry - X
Colorado - letnry - X
Columbus - lucifer316 - X
Dallas - letnry - X
Detroit - Artamus
Edmonton - mxmizuno88 - X
Florida - Jouko-Pouko - X
Los Angeles - mxmizuno88 - X
Minnesota - mxmizuno88 - X
Montreal - letangerang58 - X
Nashville - mxmizuno88 - X
New Jersey - mxmizuno88 - X
New York Islanders - lucifer316 - X
New York Rangers - CaptainCally - X
Ottawa - letangerang58 - X
Philadelphia - mxmizuno88
Phoenix - E_johnson - X
Pittsburgh - Letangerang58 - X
San Jose - Excelsior - X
St. Louis - letnry - X
Tampa Bay - letnry - X
Toronto - jer_33
Vancouver - Austeane
Washington - letnry - X
Winnipeg - mxmizuno88
Last edited by letangerang58; July 23, 2014 at 2:44 AM.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
I'm in! This could be useful. Depending on how this goes, there could be some fantasy guide improvements to be made...
Data Science Intern, Pebble
COO, Quidditch Post
Associate Editor, Dobber Sports Network
Hockey Operations Intern, UBC Thunderbirds
Top 100 Roto
Dobber Prospects
Ask me your fantasy questions on Twitter: @austeane
My main league:
I might be able to help, I'm usually home during the day. I'm not exactly sure what we're doing with the spread sheet but sure I'm in mark me down for Chicago. I'll PM you with other info.
20 Team Dynasty (points per) - G (25, 50 for defense) A (25) PIM (3) PPP (15) SHP (25) OTG (15) GWG (25) HTr (50) SOW (75) HIT (1) BLK (2) W (50) SHO (100) OTL (10) GA (-15) SV (2) Use actual NHL salary
Start 12 F, 6 D, 1G weekly
F: Kucherov, Marchand, Barkov, Gaudreau, Laine, Aho, Dubois, Dadonov, Huberdeau, Trocheck, Bertuzzi, Beauvillier, Khaira, Grigorenko
D: Ekman-Larsson, Yandle, Edler, Pulock, Borowiecki, Weegar, Mike Reilly
G: Andersen, Hart
Farm: Boldy, Beckman, Wise, Mascherin, Kovalenko, Manukyan, Walker, Morozov, Shafigullin, Palmu, Tychonic, Zhuravlyov, Kesselring, Zamula, Lankinen, Sogaard, Ingram, Rybar
I do prefer to be contacted via email if possible because it'll make contacting you with messages that I need to get out to everyone later much easier.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
This is an example of what I'm looking to get from your end. Its very simple data entry. All you need to do is fill in the cells with the data and I'll do the rest. You don't need any excel skill what-so-ever to do this other than the ability to open up an excel file and type. Some of the more complicated things (and by complicated I mean only slightly more challenging than typing) I will offer guidance for if need be.
At the end of the day I plan on making a spreadsheet where you can add custom rankings with a draft tool which will allow you to keep track of who is available throughout your draft. You will be able to sort by games played, position, NHL team, and player availability in your league.
If you do want to help then make sure to contact me with the team you are interested in and wait for my go ahead before starting. I don't want anyone to waste their time duplicating what someone else did.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
I'm bumping this to see if anyone else is interested.
If you have sent me your spreadsheet but there isn't an X next to your name on the list above than please send it to me again because I lost it in my email. Also, if you have previously committed to doing a spreadsheet but you don't have to time to do it then please let me know so that I can remove your name from the list and open the team up for someone else to do.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
Did you finish this? I'd be interested in helping out if you need it. I do something similar for fantasy baseball and add prospects from the various prospect web sites to build a sizable database that I can scan quickly.
20-team NHL cap keeper; auction salaries w/contracts; 4C, 4LW, 4RW, 6D, 2G, 3B, 18 farm
H2H Cat Wins: G, A, Pts, 2G+A, DPts, PIM, SOG, Hits, Blks, FO%, STG, GWG, G Wins, GAA, Save %, ShO
C: Stamkos, Toews, DRyan, Compher, Fisher, Haula
LW: Lucic, Tkachuk, Eriksson Ek, Connor
RW: Radulov, Tarasenko, JWilliams, Point, Callahan
D: Braun, Del Zotto, McNabb, CMiller, Petry, Subban, Butcher
G: Andersen, Rinne
Farm: Anderson-Dolan, Beaudin, O?Regan, Suzuki, Kayumov, Bastian, Pu, Meloche, Pionk, Poolman, Montembault, Hill
Sent you an email, I can help out.
Work has gotten very weird, working lots of overtime and doing doubles and crap so ya I'm gonna drop out of this. Sorry man!
20 Team Dynasty (points per) - G (25, 50 for defense) A (25) PIM (3) PPP (15) SHP (25) OTG (15) GWG (25) HTr (50) SOW (75) HIT (1) BLK (2) W (50) SHO (100) OTL (10) GA (-15) SV (2) Use actual NHL salary
Start 12 F, 6 D, 1G weekly
F: Kucherov, Marchand, Barkov, Gaudreau, Laine, Aho, Dubois, Dadonov, Huberdeau, Trocheck, Bertuzzi, Beauvillier, Khaira, Grigorenko
D: Ekman-Larsson, Yandle, Edler, Pulock, Borowiecki, Weegar, Mike Reilly
G: Andersen, Hart
Farm: Boldy, Beckman, Wise, Mascherin, Kovalenko, Manukyan, Walker, Morozov, Shafigullin, Palmu, Tychonic, Zhuravlyov, Kesselring, Zamula, Lankinen, Sogaard, Ingram, Rybar
We're one third of the way done! I'll be gone for the weekend getting drunk in a creek and I won't have cell phone reception so I won't be able to get back to anyone until Sunday night.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
Half way done with the data entry! Anymore volunteers would be welcome and anyone who has already helped and is willing to do more are also welcome to volunteer for more work. Data entry only takes about an hour or two per team. I'll work on getting this finished up in the next two weeks.
Fantrax - Salary cap dynasty - cap hit - H2H each category
Start: 2C, 2LW, 2RW, 4D, 2UTIL, 2G, 6 Bench, 4IR
Cats: G, A, +/-, PIM, STG, STA, SOG, FOW, GWG, Hits, BLK, W, GAA, Saves, SV%, SO
C: Getzlaf, Turris, Eakin, ____
LW: Kunitz, MacArthur, Pacioretty, ____
RW: Little (C), Tarasenko, Eriksson (LW)
D: Pietrangelo, JJ, Streit, Brodie, Benn, ____
G: Lundqvist, Bishop, Holtby
Farm: Grigorenko, H Lindholm, Faksa, Collberg, Grimaldi, Lee, K Hayes, G Carey, Schmaltz
G: Grubauer, Gudlevskis
already sent an email in, but got no response. i would love to help!
DobberHockey Injury Report Columnist
Points only keeper league. 9F 6D 1G + 5 Bench & 9 Farm. $109M cap.
Drop 5 at the end of the year from Main team only.
10 Teams.
F: Crosby Kane McDavid Hall Draisaitl MacKinnon Duchene Backstrom Hornqvist Sprong Perron
D: Letang Green Klingberg Rielly Faulk Bowey Phaneuf Campbell Schultz
G: Holtby
Farm: RNH E.Lindholm Vrbata Fabbri Morrissey Pouliot Murray Vasilevskiy Fleury