Hi,

I'm hoping someone can give some advice on how to quickly transfer recruits' FSS into Excel.  I'm looking for the formulas needed, so I would just be able to copy the recruit's info into a spreadsheet, and the pre-entered data would do all the hard work for me.  If anyone has any advice, regarding this way or any other way to use Excel for Whatif, please let me know.  Thank you,

 

Kyle

My spreadsheet is pretty ancient.  I haven't figured out a way to do any automated incorporation of potentials into Excel.  I just use macros to manually color code values according to FSS.

However, you can import individual player ratings into Excel.   Go to the recruit's page.  Copy the URL into your clipboard.  Load an empty Excel sheet and go to "Data-> From Web".  You'll get some extraneous rows, but the ratings will be there for you to manipulate into your master summary.

I do the same process with my game planning spreadsheet so I can compare starting lineups.  It works pretty slick.

I took an Excel class last year. The professor didn't know of a way to tell the program "increase all the green numbers by 20, the black ones by 10, etc.".  Or, if he did, he felt it was too complicated for me.   So, I copy the data into Excel and manually change the numbers.

Some systems won't transfer the numbers in color, only black-and-white.  Google Chrome, however, will copy in color

when you computer saavy people get this all figured out, let me know. :)     

I use google chrome and use the compare recruits feature. This transfers the color potentials at least, I then have to manually increase them by each potential to figure out a best guess of what the player could be. 

Just search recruits and use the ratings display rather than general. This will give you a page of 50 players ratings with the color coding (for ones you have purchased FSS). In Excel you can just write a simple function (under Developer->Visual Basic) to return the text color index of a particular cell. From there you just write a simple set of if statements, if red#, add low amount, if blue#, add high amount, etc. I'd rather not post the actual function here for all the world to see, but you can just google search "excel text color function". The first result goes into way more depth than you really need, but it should give you a good idea how it works.

Alblack56, if that professor truly didn't know how to do that I would seriously question his credentials unless it was an incredibly basic class.

Thanks a lot everyone.  Ploww, what you wrote sounds very intriguing.  Going to try and mess around with it and see if it will work out, I'm a bit of an Excel rookie.

Posted by kylesleem on 4/30/2012 3:07:00 PM (view original):
Thanks a lot everyone.  Ploww, what you wrote sounds very intriguing.  Going to try and mess around with it and see it if will work out, I'm a bit of an Excel rookie.

You'll be shocked at how much great info on Excel is out there on the internet.  Who needs classes when you have Google? :)

I created a pretty elaborate spreadsheet that pulls in all of the recruits for the entire world.  I use a IE/Firefox Add-On called iMacros to automatically execute all of the searches and save a text file of the data.  Then in Excel, I have some macros that pull in this information from these files.  From there, you are able to weight the categories as you see fit to rank the recruits.

The FSS data is color coded in the spreadsheet, but I do not do the +20, +10, etc, because I am ranking them against players for which I do not have FSS.

It takes me a little while to generate the spreadsheet, but it works in the background of the computer, and you only have to generate it at the beginning of recruiting.

Shoot me a sitemail if you want me to send it to you.

Ditto on the sitemail for me. I don't want to actually share my spreadsheet since it has a lot of my own ranking formulas that I've come up with, but I'd be more than happy to help anyone that has questions. Using Excel really helped me with recruiting, and I'm all for helping other people improve their game and increase the level of competition.