Results 1 to 12 of 12

Thread: Prospect Guide Spreadsheet

  1. #1
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Prospect Guide Spreadsheet

    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 bigmamadog317@gmail.com. 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


  2. #2
    austeane's Avatar
    austeane is online now
    Join Date
    Sep 2010
    Posts
    1,491
    Rep Power
    40

    Administrator

    Default Re: Prospect Guide Spreadsheet

    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:

     

    H2H Each Cat - Yahoo - 14 teams - Real Cap Hit - 85m cap
    Start: 2C 2LW 2RW 4D 2U 2G 7B daily (21)
    Cats: G A +- PIM SOG PPG PPA SHP GWG FW HIT W
    GAA SV SV% SO
    Edler's Mind Tricks:
    C:, Lehtera, Plekanec, Kuznetsov, Komarov
    LW: Benn, Kreider, Roussel
    RW: Malkin, Yakupov, Nyquist
    D: Subban, Letang, Karlsson, Jones, Dillon, Deslauriers
    G: Bobrovsky, Lehner, Elliott
    JV: Sekac, Petan, Poirier, Vrana, Fleury, Sanheim, Galiev, 5th, 9th, 15th, 18th, 24th overall amateur picks

  3. #3
    Location
    Portland, OR
    Rep Power
    50

    Dobber Sports Wizard

    Default Re: Prospect Guide Spreadsheet

    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: Giroux, Tavares, P. Kane, Okposo, Nash, Hornqvist, Gaudreau, Kucherov, Thornton, Zibanejad, Hartnell, Neal, M. Martin, Raffl

    D: Green, Ekman-Larsson, Gudas, Borowiecki, Ristolainen, Manson

    G: Andersen, Markstrom, Darling

    Farm: Laine, Hurley, Gusev, Hartikainen, Stransky, Ferland, Labanc, Chase, Khaira, Tarasov, Petrov, Kosov, Kujawinski, Parayko, Slavin, Thrower, Kichton, Marchenko, Kasdorf, Williams

  4. #4
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Re: Prospect Guide Spreadsheet

    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


  5. #5
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Re: Prospect Guide Spreadsheet

    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


  6. #6
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Re: Prospect Guide Spreadsheet

    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


  7. #7
    finminer's Avatar
    finminer is online now
    Join Date
    Sep 2008
    Posts
    284
    Location
    San Antonio, TX
    Rep Power
    10

    Dobber Sports Blue-Chipper

    Default Re: Prospect Guide Spreadsheet

    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.
    12-team salary cap keeper; $220 cap; salaries determined by auction draft;
    3 C, 2 LW, 2 RW, 2 F, 4 D, 2 G, 5 Bench, 1 IR, 8 farm;
    Draftees & prospects may be contracted for 5 years; prospects have entry level contracts.
    Top 4 get paid; annual parity draft for non-finishers;
    Rotisserie: Fwd Only G, Fwd Only A, PPG+SHG, PPA+SHA, PIM, GWG+ShooG, D-Pts, G Net Pts, GAA, Save %

    Roster:
    C - Bergeron $2 18-19, Kopitar $25 16-17, Horvat $5 18-19, Trocheck $6 16-17
    LW - Landeskog $7 16-17
    RW - KHayes $5 19-20, Larkin $5 20-21
    D - Gostisbehere $6 16-17, Dumba $5 18-19
    G - Mrazek $5 19-20, Gibson $5 19-20
    Prospects: Kapanen, Gillies, BRitchie, Rantanen

  8. #8
    letnry's Avatar
    letnry is offline
    Join Date
    May 2008
    Posts
    5,096
    Rep Power
    33

    Dobber Sports Superstar

    Default Re: Prospect Guide Spreadsheet

    Sent you an email, I can help out.

  9. #9
    Location
    Portland, OR
    Rep Power
    50

    Dobber Sports Wizard

    Default Re: Prospect Guide Spreadsheet

    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: Giroux, Tavares, P. Kane, Okposo, Nash, Hornqvist, Gaudreau, Kucherov, Thornton, Zibanejad, Hartnell, Neal, M. Martin, Raffl

    D: Green, Ekman-Larsson, Gudas, Borowiecki, Ristolainen, Manson

    G: Andersen, Markstrom, Darling

    Farm: Laine, Hurley, Gusev, Hartikainen, Stransky, Ferland, Labanc, Chase, Khaira, Tarasov, Petrov, Kosov, Kujawinski, Parayko, Slavin, Thrower, Kichton, Marchenko, Kasdorf, Williams

  10. #10
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Re: Prospect Guide Spreadsheet

    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


  11. #11
    Location
    SusquehannaValley
    Rep Power
    16

    Dobber Sports Veteran

    Default Re: Prospect Guide Spreadsheet

    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


  12. #12
    Feadur's Avatar
    Feadur is offline
    Join Date
    Jul 2013
    Posts
    130
    Rep Power
    5

    Dobber Sports Prodigy

    Default Re: Prospect Guide Spreadsheet

    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


Posting Permissions

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