Random Debut Year Files

bd3 · 12-21-2003, 11:09 AM

Following metsgeek's dynasty for a Random Chaos league and scprideandms modified ankit database I had created my own process for creating a random debut years database. Unforunately the file size when zipped runs around 14MB...not very conducive for downloading. This is due to the all the formula links I used in Excel. Anways, if anyone just want the ankit files with random debut years already done I have created a modified set of ankit files with random debut years (1895-1995) already assigned and have posted it here if anyone wants.

I can create custom sets with different debut year ranges if anyone wants just drop me a note.

SandMan · 12-22-2003, 10:48 AM

I have downloaded this and can verify that it is was very easy to use...... thanks...

bd3 · 12-22-2003, 09:33 PM

Sandman - great to hear. Was wondering if anyone was able to make it work, and if it was as easy as I thought.

Flounder602 · 12-22-2003, 10:47 PM

I also downloaded the files but couldn't get it to work :-( But I did DL the database files already done and have just begun a new season with them. Thanks for doing the two sets of files.

SandMan · 12-23-2003, 12:12 AM

I did fnd a problem if the files were loaded on a computer without the analysis pack loaded with excel that it would not work. There is a simple fix though.

In the column where the function is loaded as =randombetween($m$1, $m$2) you will need to make the following changes:

1. Define cell M1 as "start_year" and cell m2 as "end_year". (menu Insert-name-Define)

2. Modify the first cell in j1 to =INT(RAND()*(End_Year-Start_Year)+Start_Year).

3. copy this to the other cells in column "J".

I enjoyed using this because I was going to write a VB program to do this exact same thing but have not have time to do so. A program would make it available to those without access and excel but this could be automated in excel also using a script.

bd3 · 12-23-2003, 04:27 PM

Good point sandman! Appreciate the catch, you do need the analysis took pack installed in excel. Also, your formulas will work fine. I had tried to do this all in access, but my programming skills are not that good. If I can do something in excel I stick with what I know best.

Flounder - Glad you are enjoying it.

SandMan · 12-27-2003, 12:53 AM

Found an issue with the program....it appears that the new debut years file works fine except that when you have multiple records in the batting, pitching, fielding files for the same year it will number them as single records. Example if a player had three fielding positions in a year the random update wil give them (1901, 1902, 1903, example) instead of the same year.... This causes problems assigning players the wrong position when importing into the game...

I ended up putting the tables into an access table the creating a new field called modified years and this value is added to the season, birth year and debut year in all the tables. This was simply the debut year - the random year and add this to the year in the tables.

This could probably be done in the new debut year program by creating a random debut year and then taking the debut year -the random year to get the modify year, then just add this number to the season in all the excel tables to get the new year.

bd3 · 12-27-2003, 05:42 PM

Good catch sandman!!! This explains some positional anomalies I have come across in my solo dynasty. I will put a fix in tonight and upload the corrected files then.

metsgeek · 01-16-2004, 01:41 AM

This needs a BUMP

SandMan · 01-16-2004, 11:12 AM

I use bd3's excel random year worksheet to get new random years but I use ankits files, import them into access and create my own random sets. Any start year after 1901 can be created. For those that have access, all you need to do is to update the birth year and debut year in ankits from the bd3 file. Then create a field I call modyr that is the old birth year - the new birth year (the number can be pos or neg) then take this number and update all the batting, pitching, fielding tables. Example if H.AARON new debut year is 1906 his new birth year is 1886. His modyr would be 1932 (or whatever his birthyear is) - 1886 = 46. Then update all batting and fielding year field. Season - modyr. This modifies all records. I have it down where I can produce a new random set in about 20 minutes. I also tinker with the team files. I wanted to start in 1901 with 20 teams and just modified the team files by - 66 years (giving me the teams that were active in 1967).

After you update the tables just export the tables as csv files and they are ready to be used in the game. If you don't have access but have excel it can be done also but I would not recommend it because of the limitations of excel row sizes.

SandMan · 01-16-2004, 11:15 AM

Another thing. when in access look for players that do not have valid birth dates and just either enter a valid month or year or delete these rows from the modified master file you created. Most of these records are pre -1890 players and I personally deleted them, but some owners would probably want to include these.

metsgeek · 01-28-2004, 12:19 AM

It would be really cool (hint, hint) if everyone who generated a random database uploaded it to one of the various sites that host them.

SandMan · 01-28-2004, 04:19 PM

I have a 3.3 meg file zipped ready. I used the upload center at Baseball Sim Central. If anyone else has a site that I can put this on let me know what I need to do to upload. I have a set ready that starts with 1901/28 players per team/with rookies through 1995.

I don't know what kind of interest this would bring, but it only takes me about 30-60 minutes to create a new set.

JoeRockEHF · 01-29-2004, 08:23 AM

SandMan, you're file is up on my site now.

SandMan · 01-29-2004, 10:45 AM

Thanks... I hope to get some feedback on this file. If I get enough interest I can make different sets. I did have one where the league started with 1901 but the teams were from 1967, giving me 20 teams with a more modern feel.

For those using the set, if you need any assistance please feel free to contact me using the email address in the readme file. Overall I am pleased with the set and was inspired by reading the Random Chaos League dynasty thread....

Also for those that don't mind working with Access and Excel I can send you a detailed "HOW TO" document to create your own Random Debut Sets - all you need is Excel, Access, Ankits DB, and BD3's New Debut Year Spreadsheet and about 1-2 hours the first time you create a set....after that 20-30 minutes to create a different set..

metsgeek · 05-27-2004, 09:32 PM

Figured I'd bump this to regenerate interest with anyone who may have not seen it.

waylander · 06-25-2004, 09:28 PM

Can't seem to find this db anywhere. (modified random debut). Does anyone have a good link to this?

-g

SandMan · 06-27-2004, 11:22 AM

Quote:

Originally Posted by waylander

Can't seem to find this db anywhere. (modified random debut). Does anyone have a good link to this?

-g

at WWW.BASEBALLSIMCENTRAL.COM in the OOTP5 area.

Melo · 05-16-2005, 01:39 PM

Are there any issues with this file in OOTP6?

SandMan · 05-16-2005, 07:41 PM

Quote:

Originally Posted by Melo

Are there any issues with this file in OOTP6?

No - it is just a lahman format database, should have no problems with V6.x.x

12-21-2003, 11:09 AM	#1
bd3 Minors (Single A) Join Date: Feb 2003 Posts: 51	Random Debut Year Files Following metsgeek's dynasty for a Random Chaos league and scprideandms modified ankit database I had created my own process for creating a random debut years database. Unforunately the file size when zipped runs around 14MB...not very conducive for downloading. This is due to the all the formula links I used in Excel. Anways, if anyone just want the ankit files with random debut years already done I have created a modified set of ankit files with random debut years (1895-1995) already assigned and have posted it here if anyone wants. I can create custom sets with different debut year ranges if anyone wants just drop me a note.

01-16-2004, 01:41 AM	#9
metsgeek Hall Of Famer Join Date: Dec 2002 Location: Norwood, MA Posts: 5,450	This needs a BUMP __________________ Commissioner - PBRL - Just finished 2009 109 seasons and still running strong!!!

01-28-2004, 12:19 AM	#12
metsgeek Hall Of Famer Join Date: Dec 2002 Location: Norwood, MA Posts: 5,450	It would be really cool (hint, hint) if everyone who generated a random database uploaded it to one of the various sites that host them. __________________ Commissioner - PBRL - Just finished 2009 109 seasons and still running strong!!!

01-29-2004, 08:23 AM	#14
JoeRockEHF All Star Reserve Join Date: Sep 2002 Location: Niles, MI Posts: 933	SandMan, you're file is up on my site now. __________________ PSN: JoeRockEHF

05-27-2004, 09:32 PM	#16
metsgeek Hall Of Famer Join Date: Dec 2002 Location: Norwood, MA Posts: 5,450	Figured I'd bump this to regenerate interest with anyone who may have not seen it. __________________ Commissioner - PBRL - Just finished 2009 109 seasons and still running strong!!!

12-22-2003, 10:48 AM	#2
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	I have downloaded this and can verify that it is was very easy to use...... thanks...

12-22-2003, 09:33 PM	#3
bd3 Minors (Single A) Join Date: Feb 2003 Posts: 51	Sandman - great to hear. Was wondering if anyone was able to make it work, and if it was as easy as I thought.

12-22-2003, 10:47 PM	#4
Flounder602 Bat Boy Join Date: Apr 2003 Location: Long Island, New York Posts: 18	I also downloaded the files but couldn't get it to work :-( But I did DL the database files already done and have just begun a new season with them. Thanks for doing the two sets of files.

12-23-2003, 12:12 AM	#5
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	I did fnd a problem if the files were loaded on a computer without the analysis pack loaded with excel that it would not work. There is a simple fix though. In the column where the function is loaded as =randombetween($m$1, $m$2) you will need to make the following changes: 1. Define cell M1 as "start_year" and cell m2 as "end_year". (menu Insert-name-Define) 2. Modify the first cell in j1 to =INT(RAND()*(End_Year-Start_Year)+Start_Year). 3. copy this to the other cells in column "J". I enjoyed using this because I was going to write a VB program to do this exact same thing but have not have time to do so. A program would make it available to those without access and excel but this could be automated in excel also using a script.

12-23-2003, 04:27 PM	#6
bd3 Minors (Single A) Join Date: Feb 2003 Posts: 51	Good point sandman! Appreciate the catch, you do need the analysis took pack installed in excel. Also, your formulas will work fine. I had tried to do this all in access, but my programming skills are not that good. If I can do something in excel I stick with what I know best. Flounder - Glad you are enjoying it.

12-27-2003, 12:53 AM	#7
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Found an issue with the program....it appears that the new debut years file works fine except that when you have multiple records in the batting, pitching, fielding files for the same year it will number them as single records. Example if a player had three fielding positions in a year the random update wil give them (1901, 1902, 1903, example) instead of the same year.... This causes problems assigning players the wrong position when importing into the game... I ended up putting the tables into an access table the creating a new field called modified years and this value is added to the season, birth year and debut year in all the tables. This was simply the debut year - the random year and add this to the year in the tables. This could probably be done in the new debut year program by creating a random debut year and then taking the debut year -the random year to get the modify year, then just add this number to the season in all the excel tables to get the new year.

12-27-2003, 05:42 PM	#8
bd3 Minors (Single A) Join Date: Feb 2003 Posts: 51	Good catch sandman!!! This explains some positional anomalies I have come across in my solo dynasty. I will put a fix in tonight and upload the corrected files then.

01-16-2004, 11:12 AM	#10
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	I use bd3's excel random year worksheet to get new random years but I use ankits files, import them into access and create my own random sets. Any start year after 1901 can be created. For those that have access, all you need to do is to update the birth year and debut year in ankits from the bd3 file. Then create a field I call modyr that is the old birth year - the new birth year (the number can be pos or neg) then take this number and update all the batting, pitching, fielding tables. Example if H.AARON new debut year is 1906 his new birth year is 1886. His modyr would be 1932 (or whatever his birthyear is) - 1886 = 46. Then update all batting and fielding year field. Season - modyr. This modifies all records. I have it down where I can produce a new random set in about 20 minutes. I also tinker with the team files. I wanted to start in 1901 with 20 teams and just modified the team files by - 66 years (giving me the teams that were active in 1967). After you update the tables just export the tables as csv files and they are ready to be used in the game. If you don't have access but have excel it can be done also but I would not recommend it because of the limitations of excel row sizes.

01-16-2004, 11:15 AM	#11
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Another thing. when in access look for players that do not have valid birth dates and just either enter a valid month or year or delete these rows from the modified master file you created. Most of these records are pre -1890 players and I personally deleted them, but some owners would probably want to include these.

01-28-2004, 04:19 PM	#13
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	I have a 3.3 meg file zipped ready. I used the upload center at Baseball Sim Central. If anyone else has a site that I can put this on let me know what I need to do to upload. I have a set ready that starts with 1901/28 players per team/with rookies through 1995. I don't know what kind of interest this would bring, but it only takes me about 30-60 minutes to create a new set.

01-29-2004, 10:45 AM	#15
SandMan Hall Of Famer Join Date: Aug 2003 Posts: 2,946	Thanks... I hope to get some feedback on this file. If I get enough interest I can make different sets. I did have one where the league started with 1901 but the teams were from 1967, giving me 20 teams with a more modern feel. For those using the set, if you need any assistance please feel free to contact me using the email address in the readme file. Overall I am pleased with the set and was inspired by reading the Random Chaos League dynasty thread.... Also for those that don't mind working with Access and Excel I can send you a detailed "HOW TO" document to create your own Random Debut Sets - all you need is Excel, Access, Ankits DB, and BD3's New Debut Year Spreadsheet and about 1-2 hours the first time you create a set....after that 20-30 minutes to create a different set..

06-25-2004, 09:28 PM	#17
waylander Minors (Double A) Join Date: May 2004 Posts: 123	Can't seem to find this db anywhere. (modified random debut). Does anyone have a good link to this? -g

05-16-2005, 01:39 PM	#19
Melo All Star Starter Join Date: Nov 2003 Location: Where the baned reside Posts: 1,428	Are there any issues with this file in OOTP6?