OOTP Developments Forums - View Single Post - How do I get Lahman's dbase into excel to edit?

statfreak · 04-18-2002, 05:21 PM

<blockquote>quote:<hr />Originally posted by Markmeister:
Actually, there is a way to edit the pitching and batting files in Excel. Just open the files up in Word, cut up into smaller pieces (i.e. batting1, batting2, etc.), edit how you want in Excel, and re-piece back together.

Hey, I didn't say it was easy. <img border="0" title="" alt="[Wink]" src="wink.gif" /> I actually used this method to edit the files in the database program that is part of Microsoft Works. Limited to only 32,000 records so I cut the files up so I could resort and add back in the 1871-1875 stats. Forgot about deleting the TOT lines so I need to fix that though.

By the way, I think I have partially figured out how to adjust Iatric's Modified DB to work w/ Lahman 4.5. For the batting DB - need to add a Total Bases column after Hits (column #8) and add a formula for total bases to that column. The pitching file is easier - just move the games pitched column two columns to the left (needs to be immediately after the league abreviation and not after the losses column). I haven't looked at the fielding file yet.<hr /></blockquote>I have taken the batting and pitching files from the Lahman 4.5 database and replaced a player's rookie year stats with their career averages. You can download the modified batting and pitching files from my website. Please note these files may only be used for importing rookies into an historic league.

<a href="http://www.statfrk.com/OOTP.html" target="_blank">http://www.statfrk.com/OOTP.html</a>

04-18-2002, 05:21 PM	#14
statfreak Hall Of Famer Join Date: Dec 2001 Location: Milwaukee, WI Posts: 2,434	</font><blockquote><font size="1" face="Verdana, Arial">quote:</font><hr /><font size="2" face="Verdana, Arial">Originally posted by Markmeister: <strong>Actually, there is a way to edit the pitching and batting files in Excel. Just open the files up in Word, cut up into smaller pieces (i.e. batting1, batting2, etc.), edit how you want in Excel, and re-piece back together. Hey, I didn't say it was easy. <img border="0" title="" alt="[Wink]" src="wink.gif" /> I actually used this method to edit the files in the database program that is part of Microsoft Works. Limited to only 32,000 records so I cut the files up so I could resort and add back in the 1871-1875 stats. Forgot about deleting the TOT lines so I need to fix that though. By the way, I think I have partially figured out how to adjust Iatric's Modified DB to work w/ Lahman 4.5. For the batting DB - need to add a Total Bases column after Hits (column #8) and add a formula for total bases to that column. The pitching file is easier - just move the games pitched column two columns to the left (needs to be immediately after the league abreviation and not after the losses column). I haven't looked at the fielding file yet.</strong></font><hr /></blockquote><font size="2" face="Verdana, Arial">I have taken the batting and pitching files from the Lahman 4.5 database and replaced a player's rookie year stats with their career averages. You can download the modified batting and pitching files from my website. Please note these files may only be used for importing rookies into an historic league. <a href="http://www.statfrk.com/OOTP.html" target="_blank">http://www.statfrk.com/OOTP.html</a> __________________ Roll out the barrel!