Random Debut Yeard DB

[Hyper_Chem]

I remember there was one for 6.5, i believe it was from Arod, and what i'm wondering is if there is one out for ootp2006, or if the old one would work. If anybody know where i could find this i'd appreciate it.

I'd really like the idea of clemente and cobb having the opportunity to play in the same year.

Anyways, let me know if this is out already or if its in to work by anybody.

Thanks

[Stu]

The old one will import but for some reason I can only get half the players to be eligible for the initial draft. The rest appear as FA's.

[stl jason]

just thinking out loud here, so this might not work at all.... but I was trying to come up with a do-it-yourself random option using the current arod/garlon DB...

since the game pulls the players from the master.csv file, I'm thinking you could just randomize that file to have the players shuffled to different years. Here's my thoughts on how (you'll probably want to save a back-up file of the original, in case you want to go back to it):

highlight column E (birth year), cut it and paste it in the last column (AA), next to the debut year (why you need to do this later). Highlight column Z (debut year) and insert a blank column between it and column Y (throws). Now highlight column AA (debut year), and sort if (ascending or descending), expanding the selection to include birth year. Once you finish the sort, delete the empty column you added between "throws" and "debut year", and cut the birth year column and repaste it back to its original spot. Then save the file and exit. The reason for the blank insert is, the sort will only affect the debut year/birth year columns, so none of the other stats will change spots.

You'll probably need to start with an inaugural draft, since the players will all be randomized and teams most likely won't be stocked with the right amount of players... and you'll have to have a rookie draft, instead of assigning them to original teams.

What could be fun with this is, you have a bunch of different criteria to sort, so you can make different randomized rosters and have new players showing up in different years with each new sim. (sort the first names or last names or birth city, etc. along with the debut year/birth year).

The only thing that you'll want to ensure is that you have the debut year and birth year connected when you sort them. You don't want to just sort the debut year and have a player born in 1867 have his debut year in 1997

I just did a quick sort of only the debut year/birth year to see what I would get. In a descending sort of the debut year, Albert Pujols would make his debut in 1922. I might have to make a trial run on a season to see what happens.


--got some errors on the start-up, so I'll tinker with it to see if I can get it to work...

[SandMan]

1. Copy the Master CSV to Excel.
2. Create a column with new Random year using the function Randbetween(FY, LY) with first year about 5 years before your league starting and last year the year you want your last season to run without having fictional players.....
3. Create a column subtracting the random debut year from the actual debut year.
4. Paste the Random Year over the actual debut year using Paste Special - Value.
5. Create a column subtracting the number created in step 3 with the birth year. Paste using the Paste Special - Value over the birth year.

Batting/Pitching and Fielding CSV

1. Copy all these to a Excel workbook.
2. Create a Master CSV that has the Lahmn ID and the value created in step 3 above.
3. Create a column in the batting file that does a lookup on the lahman ID, returning the value created in the master csv step 3.
4. Create a column that subtracts this value from the year of the record. Paste this column into the year column using paste special value.
5. Do this for all files that has the year value in it.
6. Delete the extra columns you created in all imported csvs and export the new tables to csv files. Just make sure to save a copy of the original lahmans csv files in case you have made any errors or in case if you want to create another random debut database in the future.....


I used to have this in an access program using queries and it worked good. The above way is a little more work but you can create a Random Debut table in about 25-30 minutes. On Simcentral I have a random debut database in the OOTP5 section that I create a few years ago using my access application. It does not have any players from 2004-present but it does have the historical players. IF you started in 1901 you would have enough players for 24 teams with an average of 4-5 rounds each year after the initial draft.

The above steps require a intermediate understanding using MS EXCEL and the functions to create the tables, also it requires the Analysis Pack that comes with Excel 2002 and above for some of the functions...(randbetween being one - otherwise you will need to use the random function)

I hope this helps. I was going to write a little VB app that does this automatically but I found that the interest in a random debut database was actually very small and would not be worth the time to create it, although it would be a simple program......

[trapper700]

Originally Posted by SandMan

1. Copy the Master CSV to Excel.
2. Create a column with new Random year using the function Randbetween(FY, LY) with first year about 5 years before your league starting and last year the year you want your last season to run without having fictional players.....
3. Create a column subtracting the random debut year from the actual debut year.
4. Paste the Random Year over the actual debut year using Paste Special - Value.
5. Create a column subtracting the number created in step 3 with the birth year. Paste using the Paste Special - Value over the birth year.

Batting/Pitching and Fielding CSV

1. Copy all these to a Excel workbook.
2. Create a Master CSV that has the Lahmn ID and the value created in step 3 above.
3. Create a column in the batting file that does a lookup on the lahman ID, returning the value created in the master csv step 3.
4. Create a column that subtracts this value from the year of the record. Paste this column into the year column using paste special value.
5. Do this for all files that has the year value in it.
6. Delete the extra columns you created in all imported csvs and export the new tables to csv files. Just make sure to save a copy of the original lahmans csv files in case you have made any errors or in case if you want to create another random debut database in the future.....


I used to have this in an access program using queries and it worked good. The above way is a little more work but you can create a Random Debut table in about 25-30 minutes. On Simcentral I have a random debut database in the OOTP5 section that I create a few years ago using my access application. It does not have any players from 2004-present but it does have the historical players. IF you started in 1901 you would have enough players for 24 teams with an average of 4-5 rounds each year after the initial draft.

The above steps require a intermediate understanding using MS EXCEL and the functions to create the tables, also it requires the Analysis Pack that comes with Excel 2002 and above for some of the functions...(randbetween being one - otherwise you will need to use the random function)

I hope this helps. I was going to write a little VB app that does this automatically but I found that the interest in a random debut database was actually very small and would not be worth the time to create it, although it would be a simple program......

Any chance you can post some pics with your walkthrough? I've barely used Excel and I'm not really any good with it. If not, thanks anyway for your tutorial, as I was wondering how to randomize the years players can be drafted.

[tim86432]

When I try to import the csv file I am getting errors that the file is too big for excel and it cuts off somewhere in the W's. Is there a way to get around this?

[trapper700]

yeah, so if anyone gets this working, mind sharing it with the rest of us? thanks.

[Nukester]

Something like this would probably be fairly easy to write up using FoxPro, but my biggest question is how do you handle the number of players being imported for a given year ? For instance, how do you know your not getting 5 rookies for 1910 and 34 for 1915 ?

[gbmoore121]

Originally Posted by Nukester

Something like this would probably be fairly easy to write up using FoxPro, but my biggest question is how do you handle the number of players being imported for a given year ? For instance, how do you know your not getting 5 rookies for 1910 and 34 for 1915 ?

I was thinking the same thing. I would like to do a random debut with the AROD/ GARLON using 16 teams. I would think there is a way to ensure some frequency.

[SandMan]

Originally Posted by tim86432

When I try to import the csv file I am getting errors that the file is too big for excel and it cuts off somewhere in the W's. Is there a way to get around this?

Excel Only handles 64K records. You need to open in wordpad take the first half of the data, cut it and paste into another document and process the new lists seperately. I think that there is an Excel version of Lahmans on the baseball1 site that has the tables broken down in parts.

Or you can do this in MS ACCESS. The master CSV should open, the other tables may be too large...