HFBoards

Go Back   HFBoards > General Hockey Discussion > Prospects
Mobile Hockey's Future Become a Sponsor Site Rules Support Forum vBookie Page 2
Prospects Discuss hockey prospects from all over the world and the NHL Draft.

2013 Player list/mock draft creator spreadsheet...

Reply
 
Thread Tools
Old
05-26-2013, 11:31 AM
  #1
Beerfish
Registered User
 
Beerfish's Avatar
 
Join Date: Apr 2007
Posts: 12,982
vCash: 500
2013 Player list/mock draft creator spreadsheet...

I have once again this year done up a mock draft/player list spreadsheet. Some of you may be familiar with it from other years. For those that aren't here are some of it's features.

List of over 400 draft eligible players.
Full draft order list.
Ability to easily create mock drafts.
Draft pick value chart.

Obviously the full draft order is not set due to the playoffs still going on so there will be a final version at the end of the playoffs.

Google doc link below:

https://docs.google.com/file/d/0B-P5...it?usp=sharing

Beerfish is offline   Reply With Quote
Old
05-26-2013, 01:43 PM
  #2
Henderson19
Registered User
 
Join Date: Jul 2007
Posts: 642
vCash: 500
Thanks for sharing this...looks like a lot of work went into creating the tool.

Just curious, can you share a little more information about the mocks and rankings you used to arrive at your "average ranking?"

Again, thanks for sharing it!

Henderson19 is offline   Reply With Quote
Old
05-26-2013, 01:46 PM
  #3
CerebralGenesis
Registered User
 
CerebralGenesis's Avatar
 
Join Date: Jul 2009
Posts: 24,006
vCash: 500
very nice!

will be playing with this

CerebralGenesis is offline   Reply With Quote
Old
05-26-2013, 01:56 PM
  #4
Jabba11
Hockey Lobby
 
Jabba11's Avatar
 
Join Date: Nov 2009
Posts: 3,873
vCash: 500
Nice Job! It's really nice!

Jabba11 is offline   Reply With Quote
Old
05-27-2013, 09:21 AM
  #5
Beerfish
Registered User
 
Beerfish's Avatar
 
Join Date: Apr 2007
Posts: 12,982
vCash: 500
Quote:
Originally Posted by Henderson19 View Post
Thanks for sharing this...looks like a lot of work went into creating the tool.

Just curious, can you share a little more information about the mocks and rankings you used to arrive at your "average ranking?"

Again, thanks for sharing it!
Good question, You will notice that columns J to R are hidden on spreadsheet. You will see what web resources I used to get the 'Average Ranking'.

Also you will see column R is called 'Adjusted Central Scouting Ranking.' This is just a very basic and unscientific loose ranking I added. The reason being that after the 1st 40 players or so who are ranked in he web rankings all the other players would have the same rank and one would have to use the Central Scouting list which is not that helpful because it keeps N/A and Eurpoean players separate.

Beerfish is offline   Reply With Quote
Old
05-27-2013, 11:34 AM
  #6
hototogisu
Global Moderator
Poked the bear!!!!!
 
hototogisu's Avatar
 
Join Date: Jun 2006
Location: Montreal, QC
Country: Canada
Posts: 36,181
vCash: 500
Awards:
Great work! I was trying to remember who was responsible for these and if we'd see one again this year.

hototogisu is offline   Reply With Quote
Old
05-27-2013, 06:32 PM
  #7
Henderson19
Registered User
 
Join Date: Jul 2007
Posts: 642
vCash: 500
Quote:
Originally Posted by Beerfish View Post
Good question, You will notice that columns J to R are hidden on spreadsheet. You will see what web resources I used to get the 'Average Ranking'.

Also you will see column R is called 'Adjusted Central Scouting Ranking.' This is just a very basic and unscientific loose ranking I added. The reason being that after the 1st 40 players or so who are ranked in he web rankings all the other players would have the same rank and one would have to use the Central Scouting list which is not that helpful because it keeps N/A and Eurpoean players separate.
Ah, the old 'hidden columns' trick...

Again, thanks for sharing an awesome tool!

Henderson19 is offline   Reply With Quote
Old
06-05-2013, 06:34 PM
  #8
jer33
Registered User
 
jer33's Avatar
 
Join Date: Aug 2008
Posts: 104
vCash: 500
Year after year, awesome.

Thanks so much, an invaluable tool.

Jer33

jer33 is offline   Reply With Quote
Old
06-06-2013, 12:13 PM
  #9
Captain Clutch
Registered User
 
Join Date: May 2012
Posts: 211
vCash: 500
Very nice of you to do this, excellent work!

Captain Clutch is offline   Reply With Quote
Old
06-06-2013, 01:40 PM
  #10
Circulartheory
@danccchan
 
Circulartheory's Avatar
 
Join Date: Apr 2006
Location: Hong Kong
Country: Hong Kong
Posts: 5,289
vCash: 500
Beerfish, just wanted to say thank you.

I haven't downloaded your 2012 or 2011 spreadsheets but did download your 2010 file from awhile back and since then, I had kept adding names on my own and modified to my preferences.

But thank you so much for the original file and writing out that formula for average rankings.

Circulartheory is offline   Reply With Quote
Old
06-11-2013, 06:50 PM
  #11
chrisralph007
HFB Partner
 
chrisralph007's Avatar
 
Join Date: Jan 2004
Location: Calgary, Canada
Posts: 2,295
vCash: 500
Beauty creation!

Look froward to this every yr.

___
*2013 NHL Draft Prospect Index
**2013 NHL Draft Guide: The Next Ones

chrisralph007 is offline   Reply With Quote
Old
06-13-2013, 11:47 PM
  #12
CNS
A World Alone
 
CNS's Avatar
 
Join Date: May 2008
Posts: 10,561
vCash: 500
Was wondering if I just missed this or what. One of the things I look forward to a lot as the draft nears. Thanks for the hard work yet again!

CNS is offline   Reply With Quote
Old
06-14-2013, 09:40 AM
  #13
Beerfish
Registered User
 
Beerfish's Avatar
 
Join Date: Apr 2007
Posts: 12,982
vCash: 500
There will be an updated final version just after the playoffs when all the draft positions are finally set.

Beerfish is offline   Reply With Quote
Old
06-25-2013, 02:52 PM
  #14
Dutchy
Registered User
 
Dutchy's Avatar
 
Join Date: Aug 2003
Location: Montréal, Québec, Ca
Country: Netherlands
Posts: 3,511
vCash: 500
Send a message via ICQ to Dutchy
Quote:
Originally Posted by Beerfish View Post
There will be an updated final version just after the playoffs when all the draft positions are finally set.
Can't wait for it, thanks!

Dutchy is offline   Reply With Quote
Old
06-25-2013, 08:56 PM
  #15
Beerfish
Registered User
 
Beerfish's Avatar
 
Join Date: Apr 2007
Posts: 12,982
vCash: 500
Here is the final version of the 2013 NHL draft player evaluator/mock draft creator.


https://docs.google.com/file/d/0B-P5...it?usp=sharing

Beerfish is offline   Reply With Quote
Old
06-26-2013, 07:25 PM
  #16
PantherStriker
Registered User
 
Join Date: Jul 2010
Country: Canada
Posts: 226
vCash: 50
Bumping for justice. One of, if not the, best spreadsheet I've seen in this prospects forum. Thank you

PantherStriker is offline   Reply With Quote
Old
06-27-2013, 07:43 PM
  #17
MCDAVIDISH
Registered User
 
MCDAVIDISH's Avatar
 
Join Date: Jul 2011
Location: Edmonton
Country: Canada
Posts: 2,137
vCash: 50
Definitely using this. BUMP

MCDAVIDISH is offline   Reply With Quote
Reply

Forum Jump


Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -5. The time now is 03:52 AM.

monitoring_string = "e4251c93e2ba248d29da988d93bf5144"
Contact Us - HFBoards - Archive - Privacy Statement - Terms of Use - Advertise - Top - AdChoices

vBulletin Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
HFBoards.com is a property of CraveOnline Media, LLC, an Evolve Media, LLC company. ©2015 All Rights Reserved.