View Single Post
Old 01-01-2015, 12:47 AM   #1
Bigrod
OOTP Stats Master
 
Join Date: Mar 2009
Location: Maine
Posts: 3,075
Historical 3.0 Plus: Post your suggestions

Posting here as not all visit the mods forum.
Last yr. I released Historical Importer 2.0 for ootp that automated the creation of text files that ootp can use to auto import historical players.
I'm currently working on 3.0 Plus, which will contain more features and I'd like suggestions as to what you would like to see. Unfortunately, I don't have excel so one will need Apache Open Office (it's free) as this is just a simple spreadsheet utility.
The features in 3.0 Plus so far are:
1. Updated to include all players with a lahman ID up to & including 2013 MLB debuts. 18,171 players in all. Fully sortable by name, country, state, city. Formulas will auto adjust so that data and links will/should be correct.
2. Auto creates the correct text format (lahmanID,Year) in its own column for use with ootp's historical import from text file feature. Just copy your finished results from that column to any text program and save. No limit on the number of players that can be imported at once.
3. You can create multiple text files on one sheet. No need to add separate sheets.
4. Auto creation of the players bbref MLB page link. Just click the link to goto the player's bbref page.
5. Auto search any player on bbref's site. Simply input the players name and click the auto generated link. Uses full name or just last name.
6. Auto generated player page links can be used internally to automate importing any players bbref stats (hitting, fielding and Pitching) to a separate sheet in Open Office. Once imported, format them to ootp's specs and save as .txt files for import to ootp.
7. Add your own vlookup tables to the vlookup sheet. Great for creating your own importable rosters. No data is locked that can't be unlocked as nothing is password protected.


Post your suggestions for additional features and I'll see if I can incorporate them.
Have a happy and fruitful new year. Your help is greatly appreciated.
Bigrod is offline   Reply With Quote