03-15-2015, 09:57 AM
|
#13
|
All Star Reserve
Join Date: Dec 2012
Posts: 576
|
Quote:
Originally Posted by Ike348
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.
|
Quote:
Originally Posted by Bigrod
Nope, it easy as pie. If you only want to import specific players, create a .txt file with the players lahmanid,year. When you got all the players you want entered in the .txt file, import them into ootp using the import from .txt file feature.
You can start a real historical season in any year of your choice and just set the options to auto import players in their debut yr. and ootp will handle the rest. 
|
Will try this when I get home from work this afternoon, thank you very much.
|
|
|