Spreadsheet for ranking draft prospects? Topic

I'm sure people have these, but I've been unable to find one. Does anyone have a spreadsheet that can import draft class data and rank prospects?

If so, can you please please email it to [email protected]

=)
5/19/2011 1:17 AM
You can use the "Get external data function" on Excel and import from the Web.  Experiment around with that and you can get the information you want.
5/19/2011 7:30 AM
As far as ranking prospects, you get to do that on your own...
5/19/2011 7:30 AM
Ive used "Get external data" vs copy and paste...for me it is much simpler to copy and paste. 
5/20/2011 2:13 PM
Yeah, copy/paste takes a matter of seconds.
5/20/2011 4:37 PM
cool, so once you import all the players. Is there some excel formula you use for ranking them? or just visually do it?
5/20/2011 8:33 PM
(AL2*1.1)+(AM2*0.9)+(IF(D2="S";12;0))
5/21/2011 7:18 PM
The formula I use is UUDDLRLRBAB
5/22/2011 12:08 AM
Contra?
5/24/2011 10:53 PM
Pick a few skills you find valuable and assign a weight to them.  Multiply the skills by those percentages, tweak as necessary.  Everyone values skills differently, but you should be able to eyeball when the best players start creeping their way to the top of your rankings.  Different positions will likely need different weights assigned to them as well...it starts easy but it's easy to add layers of complexity.
5/25/2011 11:59 PM
Spreadsheet for ranking draft prospects? Topic

Search Criteria

Terms of Use Customer Support Privacy Statement

© 1999-2026 WhatIfSports.com, Inc. All rights reserved. WhatIfSports is a trademark of WhatIfSports.com, Inc. SimLeague, SimMatchup and iSimNow are trademarks or registered trademarks of Electronic Arts, Inc. Used under license. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.