New AnkitDB and CarAvgDB are now available!!! - Page 2

Ankit · 05-16-2004, 06:36 PM

Quote:

Originally posted by BaseballMan
Ankit,

You wouldnt have a copy of your database with all the all the 1 year career players still in the database? Or maybe a list of all the players you deleted?

I don't have this list... but you can compare the original lahman db's master.csv to mine and see who got deleted and work from there...

Ankit · 05-16-2004, 06:38 PM

Quote:

Originally posted by dangarion
Soooooo where is this unique league file?

:-) Created one, played a few season, didn't like some things. Created a whole new Normalized DB, still not completely happy but at least this time it is more fun... I will post the file in a day or two.

Ankit · 05-19-2004, 01:59 AM

This unique league file is an experiment created for fun. The idea formed in the OOTP IRC chat room one day when JBmagic, TotalEnd98, Antonym and I were chatting. JBmagic wondered if there was a way to import all players in MLB history in one year and then have a best of the best league. With the help of the other mentioned previously and Darrylr, the whole idea became a reality and here it is.

Even though there are 12,000 players that have appeared in the MLB since 1876, I deleted ones that didn't have significant playing time to make the league file more manageable. Still, you have access to over 5000 of the best players to play in the MLB from 1876 to 2001. The players were imported using my Normalized Career Averages DB at their rookie age. The league is set up like today's MLB, with 30 teams and a 162 game schedule with simple Financials ON. You will begin with a fantasy draft of 50 rounds to set up your team.

Because all players come in at their rookie age, you should not hold any Amateur Drafts for at least 15 seasons. Also, do not import rookies when the game prompts you for it when you proceed to the next season. You do not need to change league totals or anything else. Just unzip the league in to you OOTP 6 folder and play.

You can download it from here: http://www.baseballmaelstrom.com/ank...Players.lg.zip

Once again, thanks to the JBmagic, TotalEnd98, Darrylr and Antonym for their help. Have fun with this, guys.

P.S.: Dead Ball Era pitchers are rated too highly, but the league is still extremely fun... In my private sim, I had a combined no-hitter in the Game 7 of the World Series by a team that had the fewest wins of any, playing in the post season. That same season saw Ty Cobb take away some else's Triple Crown with the final AB of the season. Info on this will be posted in the Dynasty forum on the OOTP boards.

Again, download it from here: http://www.baseballmaelstrom.com/ank...Players.lg.zip

jbmagic · 05-19-2004, 04:16 AM

thanks Ankit...for putting this great league file together for the best players of all time in one league..

who will the number one pick be in the fantasy draft...download it and find out...

dougaiton · 05-19-2004, 09:32 AM

Excellent stuff Ankit!

arod23 · 05-19-2004, 04:30 PM

Thanks Ankit, can't wait to try it out.

By the way, how did you "normalize" the stats? Is it based on how players did relative to their year/era averages and adjusted to modern baseball figures?

The stats and top players in my test sims using the normDBs all seem intuitively correct, so I was just curious on what approach you took.

Ankit · 05-19-2004, 04:33 PM

yeah, thats pretty much how. A relative comparision of how they did to their year against the modern figures.

arod23 · 05-19-2004, 04:38 PM

For your career averages, did you normalize each player's career average to a 162 game season or just divide by the number of years played?

Dargone · 05-19-2004, 07:15 PM

Very nice

octones · 05-20-2004, 02:52 PM

Ankit, do you have a list of the duplicated players in your regular databases?

For example I know Ruth is in twice as George Ruth and Babe Ruth. What other players are in the db's twice? I thought you had a list in the readme before but I didn't see it in the new one.

Ankit · 05-20-2004, 07:13 PM

Its probably not in the readme files of the Normalized DBs, it is in the AnkitDB.

Malleus Dei · 06-04-2004, 11:49 PM

bump

Cardinal Rule · 06-07-2004, 05:56 PM

Ankit or anyone - I have a question. I started up a league using the AnkitDB for 1998. I noticed an interesting trend - many closers and relievers are converted to starters and wind up as a number 2 or 3 starter. IRL John Wetteland didn't start a game after 1990 and was mostly a full-time closer from 1992 until his career ended in 2000. However in my sim the Rangers converted him to a starter and he's 3rd in the AL in strikeouts. IRL Mike Magnante started 19 of his 484 games, however in my sim Houston converted him to their number 2 starter and he's leading the NL in wins. Ugueth Urbina and Mariano Rivera were also converted into starters. I haven't dug into this deeply to find out what might cause this, but my first suspicion is endurance? Any thoughts or similar results from anyone?

Ankit · 06-07-2004, 07:10 PM

Can you post their endurance ratings in the game? My hunch is that it is the endurance rating. I have done some test and have not been satisfied with how it assigns them. It assigns the highest endurance rating when you have pitched some games as a reliever and some as a starter. The best thing would be to simply calculate the IP/G and use that to get an Endurance rating.

Here's my research in to it:

<pre><font size=2>
Player G GS IP Rating
Barry Zito 28 28 178.7 72
Barry Zito 28 28 178.7 75
Barry Zito 28 21 178.7 93
Barry Zito 28 21 178.7 93
Barry Zito 28 14 178.7 97
Barry Zito 28 14 178.7 91
Barry Zito 28 7 178.7 89
Barry Zito 28 7 178.7 85
Barry Zito 28 0 178.7 43
Barry Zito 28 0 178.7 44

Player G GS IP Rating
Bill Zuber 22 22 86.0 59
Bill Zuber 22 22 86.0 53
Bill Zuber 22 21 86.0 57
Bill Zuber 22 21 86.0 50
Bill Zuber 22 14 86.0 76
Bill Zuber 22 14 86.0 71
Bill Zuber 22 7 86.0 84
Bill Zuber 22 7 86.0 89
Bill Zuber 22 0 86.0 41
Bill Zuber 22 0 86.0 45

Player G GS IP Rating
Irv Young 27 27 164.7 78
Irv Young 27 27 164.7 79
Irv Young 27 23 164.7 85
Irv Young 27 23 164.7 86
Irv Young 27 18 164.7 95
Irv Young 27 18 164.7 93
Irv Young 27 9 164.7 85
Irv Young 27 9 164.7 83
Irv Young 27 0 164.7 40
Irv Young 27 0 164.7 40</font></pre>

Cardinal Rule · 06-08-2004, 12:05 AM

Here's the notable converts with endurance rating:

Urbina - 58 (MON Closer Kline has 12)
Rivera - 57 (NYY Closer Stanton has 26)
Magnante - 52 (HOU Closer Wagner has 21)
Brantley - 53 (SD Closer Hoffman has 27)
Quantrill - 58 (TB Closer Hernandez has 26)
Wetteland - 59 (TEX Closer DPatterson has 20)
Plesac - 50 (TOR Closer Myers has 10)

I know not all these guys would be tagged as closers, but they all are noted as short-inning specialists so it looks like endurance is the culprit here, especially since each of these teams has a closer with an endurance rating in the teens or twenties.

So is this something that can be adjusted in the database, or is it inherent in the way the game imports the players?

Thanks for your help...

Ankit · 06-08-2004, 12:09 AM

probably something that can be adjusted in the DB. Off the bat, I would say, each of those guys probably have 1 or 2 games started for their career averages, set it to 0 and you should be fine.

Cardinal Rule · 06-08-2004, 02:12 PM

Just for clarification sake - you do recommend importing your database using the 'Whole Career' setting, rather than the 'Remaining Career' setting, correct?

Thanks again...

jbmagic · 06-08-2004, 03:44 PM

check his readme...he has the recommend setting in there

Carlton · 07-06-2004, 05:33 PM

Ankit...questions

How about pitchers...batting and position playing?
for example Snake Wiltse was a good batter albeit for a short time and he played some games at 1B...other pitchers played 20 or 30 games in the OF...Doc Crandall comes to mind...will they import with those ratings?

and vice versa...guys like Homer Hilderbrand, George Sisler and Jack Dunleavy pitched then played the field...will they have ANY pitching ratings?

Then Catcher's Passed Ball ratings...many in the deadball thru 30's had 15 or more per 162 games...can that be imported?

and of course Hits batsmen and wild pitches...or does that default to 4-4 or 0-0?

Ankit · 07-07-2004, 10:00 AM

If the player was a pitcher, primarily, then he won't have ratings for other positions, and vice-versa. The Catcher's Passed Ball rating is 4 because my DB uses Lahman 5.0 and that didn't have a column for PB. I am trying to make a new DB with Lahman 5.1 that will include PB but Markus is not willing to help me nor is responding to my multiple e-mails and so am stuck.

Off-topic thought: I find it strange that Steve AND Markus managed to respond to comments in the thread titled "OOTP 6 vs. PureSim 2004," but can't come up with answers or replies to other meaningful questions and queries by paying customers. One of the reasons why I am considering giving full support to PureSim and making it better and ditiching the OOTP series... Sorry, had to get it off my chest. Have kept it in me too long.

05-19-2004, 01:59 AM	#23
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	This unique league file is an experiment created for fun. The idea formed in the OOTP IRC chat room one day when JBmagic, TotalEnd98, Antonym and I were chatting. JBmagic wondered if there was a way to import all players in MLB history in one year and then have a best of the best league. With the help of the other mentioned previously and Darrylr, the whole idea became a reality and here it is. Even though there are 12,000 players that have appeared in the MLB since 1876, I deleted ones that didn't have significant playing time to make the league file more manageable. Still, you have access to over 5000 of the best players to play in the MLB from 1876 to 2001. The players were imported using my Normalized Career Averages DB at their rookie age. The league is set up like today's MLB, with 30 teams and a 162 game schedule with simple Financials ON. You will begin with a fantasy draft of 50 rounds to set up your team. Because all players come in at their rookie age, you should not hold any Amateur Drafts for at least 15 seasons. Also, do not import rookies when the game prompts you for it when you proceed to the next season. You do not need to change league totals or anything else. Just unzip the league in to you OOTP 6 folder and play. You can download it from here: http://www.baseballmaelstrom.com/ank...Players.lg.zip Once again, thanks to the JBmagic, TotalEnd98, Darrylr and Antonym for their help. Have fun with this, guys. P.S.: Dead Ball Era pitchers are rated too highly, but the league is still extremely fun... In my private sim, I had a combined no-hitter in the Game 7 of the World Series by a team that had the fewest wins of any, playing in the post season. That same season saw Ty Cobb take away some else's Triple Crown with the final AB of the season. Info on this will be posted in the Dynasty forum on the OOTP boards. Again, download it from here: http://www.baseballmaelstrom.com/ank...Players.lg.zip __________________ Last edited by Ankit; 05-19-2004 at 10:47 AM.

05-19-2004, 04:16 AM	#24
jbmagic Hall Of Famer Join Date: Sep 2003 Location: Los Angeles Posts: 3,417	thanks Ankit...for putting this great league file together for the best players of all time in one league.. who will the number one pick be in the fantasy draft...download it and find out... Last edited by jbmagic; 05-19-2004 at 01:17 PM.

05-19-2004, 09:32 AM	#25
dougaiton Hall Of Famer Join Date: Mar 2003 Location: Location: Posts: 3,414	Excellent stuff Ankit! __________________ tThis shower of clowns My park-adjusted, historically split Born in '69 league file! (also at Joe's wonderful site +BBSC)

05-19-2004, 04:33 PM	#27
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	yeah, thats pretty much how. A relative comparision of how they did to their year against the modern figures. __________________

05-19-2004, 07:15 PM	#29
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	Very nice __________________ I was never one to patiently pick up broken fragments and glue them together again and tell myself that the mended whole was as good as new. What is broken is broken -- and I'd rather remember it as it was at its best than mend it and see the broken places as long as I lived.-Margaret Mitchell

05-19-2004, 04:30 PM	#26
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	Thanks Ankit, can't wait to try it out. By the way, how did you "normalize" the stats? Is it based on how players did relative to their year/era averages and adjusted to modern baseball figures? The stats and top players in my test sims using the normDBs all seem intuitively correct, so I was just curious on what approach you took.

05-19-2004, 04:38 PM	#28
arod23 Major Leagues Join Date: Apr 2004 Location: Philadelphia, PA Posts: 378	For your career averages, did you normalize each player's career average to a 162 game season or just divide by the number of years played?

05-20-2004, 02:52 PM	#30
octones Minors (Triple A) Join Date: Nov 2002 Location: Dayton, OH Posts: 226	Ankit, do you have a list of the duplicated players in your regular databases? For example I know Ruth is in twice as George Ruth and Babe Ruth. What other players are in the db's twice? I thought you had a list in the readme before but I didn't see it in the new one. __________________

05-20-2004, 07:13 PM	#31
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	Its probably not in the readme files of the Normalized DBs, it is in the AnkitDB. __________________

06-07-2004, 05:56 PM	#33
Cardinal Rule All Star Starter Join Date: Mar 2002 Location: Omaha Posts: 1,199	Ankit or anyone - I have a question. I started up a league using the AnkitDB for 1998. I noticed an interesting trend - many closers and relievers are converted to starters and wind up as a number 2 or 3 starter. IRL John Wetteland didn't start a game after 1990 and was mostly a full-time closer from 1992 until his career ended in 2000. However in my sim the Rangers converted him to a starter and he's 3rd in the AL in strikeouts. IRL Mike Magnante started 19 of his 484 games, however in my sim Houston converted him to their number 2 starter and he's leading the NL in wins. Ugueth Urbina and Mariano Rivera were also converted into starters. I haven't dug into this deeply to find out what might cause this, but my first suspicion is endurance? Any thoughts or similar results from anyone? __________________ "Go Crazy Folks!" Jack Buck

06-07-2004, 07:10 PM	#34
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	Can you post their endurance ratings in the game? My hunch is that it is the endurance rating. I have done some test and have not been satisfied with how it assigns them. It assigns the highest endurance rating when you have pitched some games as a reliever and some as a starter. The best thing would be to simply calculate the IP/G and use that to get an Endurance rating. Here's my research in to it: <pre><font size=2> Player G GS IP Rating Barry Zito 28 28 178.7 72 Barry Zito 28 28 178.7 75 Barry Zito 28 21 178.7 93 Barry Zito 28 21 178.7 93 Barry Zito 28 14 178.7 97 Barry Zito 28 14 178.7 91 Barry Zito 28 7 178.7 89 Barry Zito 28 7 178.7 85 Barry Zito 28 0 178.7 43 Barry Zito 28 0 178.7 44 Player G GS IP Rating Bill Zuber 22 22 86.0 59 Bill Zuber 22 22 86.0 53 Bill Zuber 22 21 86.0 57 Bill Zuber 22 21 86.0 50 Bill Zuber 22 14 86.0 76 Bill Zuber 22 14 86.0 71 Bill Zuber 22 7 86.0 84 Bill Zuber 22 7 86.0 89 Bill Zuber 22 0 86.0 41 Bill Zuber 22 0 86.0 45 Player G GS IP Rating Irv Young 27 27 164.7 78 Irv Young 27 27 164.7 79 Irv Young 27 23 164.7 85 Irv Young 27 23 164.7 86 Irv Young 27 18 164.7 95 Irv Young 27 18 164.7 93 Irv Young 27 9 164.7 85 Irv Young 27 9 164.7 83 Irv Young 27 0 164.7 40 Irv Young 27 0 164.7 40</font></pre> __________________ Last edited by Ankit; 06-07-2004 at 07:16 PM.

06-08-2004, 12:05 AM	#35
Cardinal Rule All Star Starter Join Date: Mar 2002 Location: Omaha Posts: 1,199	Here's the notable converts with endurance rating: Urbina - 58 (MON Closer Kline has 12) Rivera - 57 (NYY Closer Stanton has 26) Magnante - 52 (HOU Closer Wagner has 21) Brantley - 53 (SD Closer Hoffman has 27) Quantrill - 58 (TB Closer Hernandez has 26) Wetteland - 59 (TEX Closer DPatterson has 20) Plesac - 50 (TOR Closer Myers has 10) I know not all these guys would be tagged as closers, but they all are noted as short-inning specialists so it looks like endurance is the culprit here, especially since each of these teams has a closer with an endurance rating in the teens or twenties. So is this something that can be adjusted in the database, or is it inherent in the way the game imports the players? Thanks for your help... __________________ "Go Crazy Folks!" Jack Buck

06-08-2004, 12:09 AM	#36
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	probably something that can be adjusted in the DB. Off the bat, I would say, each of those guys probably have 1 or 2 games started for their career averages, set it to 0 and you should be fine. __________________

06-08-2004, 02:12 PM	#37
Cardinal Rule All Star Starter Join Date: Mar 2002 Location: Omaha Posts: 1,199	Just for clarification sake - you do recommend importing your database using the 'Whole Career' setting, rather than the 'Remaining Career' setting, correct? Thanks again... __________________ "Go Crazy Folks!" Jack Buck

06-08-2004, 03:44 PM	#38
jbmagic Hall Of Famer Join Date: Sep 2003 Location: Los Angeles Posts: 3,417	check his readme...he has the recommend setting in there

07-06-2004, 05:33 PM	#39
Carlton Hall Of Famer Join Date: Mar 2002 Posts: 3,765	Ankit...questions How about pitchers...batting and position playing? for example Snake Wiltse was a good batter albeit for a short time and he played some games at 1B...other pitchers played 20 or 30 games in the OF...Doc Crandall comes to mind...will they import with those ratings? and vice versa...guys like Homer Hilderbrand, George Sisler and Jack Dunleavy pitched then played the field...will they have ANY pitching ratings? Then Catcher's Passed Ball ratings...many in the deadball thru 30's had 15 or more per 162 games...can that be imported? and of course Hits batsmen and wild pitches...or does that default to 4-4 or 0-0? __________________ "I am at that stage of my life where I keep myself out of arguments. I am 100% self sufficient spiritually, emotionally & financially. Even if you say 1+1=5, you are ABSOLUTELY CORRECT. Enjoy!"

07-07-2004, 10:00 AM	#40
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	If the player was a pitcher, primarily, then he won't have ratings for other positions, and vice-versa. The Catcher's Passed Ball rating is 4 because my DB uses Lahman 5.0 and that didn't have a column for PB. I am trying to make a new DB with Lahman 5.1 that will include PB but Markus is not willing to help me nor is responding to my multiple e-mails and so am stuck. Off-topic thought: I find it strange that Steve AND Markus managed to respond to comments in the thread titled "OOTP 6 vs. PureSim 2004," but can't come up with answers or replies to other meaningful questions and queries by paying customers. One of the reasons why I am considering giving full support to PureSim and making it better and ditiching the OOTP series... Sorry, had to get it off my chest. Have kept it in me too long. __________________