View Single Post
Old 12-13-2014, 09:07 PM   #8
Ike348
All Star Starter
 
Ike348's Avatar
 
Join Date: May 2013
Location: Philadelphia
Posts: 1,245
I downloaded your thing in Excel, and it looks great! I can't believe I missed it when you released it.

Here's what I did:

- Copied the names of the players born in the state (Alaska) from BB-ref in the appropriate column.
- Created a VLOOKUP to automatically load the players' debut years in the next column over.
- Since I want these players to be based on the best years of their career, similar to the way Strat-o-Matic creates its Hall of Fame cards, I selected, "Base Potential Ratings on... Peak Seasons of Career". I based Fielding and Pitcher Stamina on "Entire Career" as well.
- After importing the players as free agents, I exported the rosters and imported them into Excel. Then I copied all of the potential ratings, and pasted them over the current ratings. After I re-imported and re-scouted, all of the players were there with their best possible ratings.

Thanks to your tool, importing players was so much easier than literally going on every players' BB-ref page to look up their best season.
__________________
Uniforms on my Photobucket

Quote:
Originally Posted by Ike348 View Post
Even in a parallel universe, the Astros don't make the playoffs.
Ike348 is offline   Reply With Quote