Alphabetical Order Database?

metsgeek · 10-08-2005, 07:50 PM

I want to create a modified Ankit database that takes all the players and reorders their debut alphabetically.

There are approxiamtely 9750 players in Ankit's regular database. Ideally I'd like to have the first 600 or so debut in 1901, then have 80-90 debut per year after that.

I'm not much of an expert with Excel, so I was wondering if it was an easy process....or if I need MS Access, would there be any database expert out there who could crunch the numbers quickly.

I'd also like to make a Reverse Alphabetical database as well.

Any ideas?

arod23 · 10-09-2005, 01:28 PM

Changing the debut year in the master file is the easy part. The hard part is that the batting, pitching, fielding, fieldingof all need to be changed to match the new debut year and subsequent years.

SandMan · 10-09-2005, 07:39 PM

Quote:

Originally Posted by arod23

Changing the debut year in the master file is the easy part. The hard part is that the batting, pitching, fielding, fieldingof all need to be changed to match the new debut year and subsequent years.

Easily done in Access...... and Excel. What I did to do my random debut database in 2004 was to bring in the Master CSV and add a column and using the randbetween function added a new debut year. I then imported all the tables including this new master csv into Access. I added a column in Access that had the difference from the debut year and the new debut year. Then just ran a query that subtracted this value from all the batting, pitching and fielding records, keyed by the lahmanID. Very quick and easy. You also need to do this to the birth year in the master csv file also. Then you just export the tables back to csv format, but before you do this you delete the debut column, keeping the new random debut column and you also delete the difference column..... works like a charm....

10-08-2005, 07:50 PM	#1
metsgeek Hall Of Famer Join Date: Dec 2002 Location: Norwood, MA Posts: 5,450	Alphabetical Order Database? I want to create a modified Ankit database that takes all the players and reorders their debut alphabetically. There are approxiamtely 9750 players in Ankit's regular database. Ideally I'd like to have the first 600 or so debut in 1901, then have 80-90 debut per year after that. I'm not much of an expert with Excel, so I was wondering if it was an easy process....or if I need MS Access, would there be any database expert out there who could crunch the numbers quickly. I'd also like to make a Reverse Alphabetical database as well. Any ideas?

10-09-2005, 01:28 PM	#2
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	Changing the debut year in the master file is the easy part. The hard part is that the batting, pitching, fielding, fieldingof all need to be changed to match the new debut year and subsequent years.