AnkitDB 5 & Career Average DB 5 have both been re-released.

Ankit · 05-01-2003, 04:27 PM

While I was fixing the problem with the Career Average DB, the solution improved upon something that could be carried over to the AnkitDB as well. The problem with the Career Average DB was that OOTP was limiting the batting talent to Average as the highest because only one season's worth of stats for each player were in the Career Avg. DB. I tried to add a second year but that too didn't work. Then, I went back to modifying some queries I used to create the Career Average Fielding file to make the same kind of files for batting, pitching and fieldingOF. It worked!!

Now, I also had the Career Average FieldingOF file, meaning that now if you import an OF in a certain year, he won't be rated to play seemingly random OF positions. Now, he will be rated according to his career average. This change is why I re-released AnkitDB 5.

You can download AnkitDB 5 here: http://www.spleen1015.com/ankitdb/AnkitDB5.zip

Download the Career Average DB 5 here: http://www.spleen1015.com/ankitdb/CarAvgDB5.zip

Instructions for using the Career Average DB are in the zip file. Use the AnkitDB 5 just like you would use the Lahman DB.

Have fun!!!

Qrusher14242 · 05-01-2003, 04:42 PM

Awesome! thx Ankit

sporr · 05-01-2003, 05:15 PM

Great news! Thank you once again.

targy · 05-01-2003, 07:28 PM

You are the best

Tycobbler · 05-01-2003, 08:27 PM

excellent work big guy
thanks

targy · 05-01-2003, 10:51 PM

One question, in the original Lahman it has folders like Award etc...Do I have to download the original and then copy yours over that or just use yours

Ankit · 05-02-2003, 12:47 AM

Quote:

Originally posted by targy
One question, in the original Lahman it has folders like Award etc...Do I have to download the original and then copy yours over that or just use yours

Just use mine...

Mark42661 · 05-02-2003, 12:47 AM

When using the career average database for rookie drafts, are the ratings you see basically what you are going to get for a player's entire career, since they are based on a career average, or will players still develop and change?

Also when you first create a historical league using your AnkitDB5, what do you suggest we imput for adjust hitters and pitchers and make bad hitters and pitchers? Whole career or remaining career and make generic L/R splits?

Thanks

hamonrye · 05-02-2003, 04:11 AM

so the previous ankit db assigned random OF positions and the new one assigns the correct OF positions. does the career average db also have correct OF positions? i'm just curious...

also, has anyone tried the new career average database yet? i'm wondering how it's working...

Dargone · 05-02-2003, 04:30 AM

Awesome

Ankit · 05-02-2003, 08:59 AM

Quote:

Originally posted by Mark42661
When using the career average database for rookie drafts, are the ratings you see basically what you are going to get for a player's entire career, since they are based on a career average, or will players still develop and change?

Also when you first create a historical league using your AnkitDB5, what do you suggest we imput for adjust hitters and pitchers and make bad hitters and pitchers? Whole career or remaining career and make generic L/R splits?

Thanks

The ratings will change over a player's career and talents will change as well because of how player development works in OOTP 5. The career average DB helps in that, it begins a player's career with the ratings and talents a player deserves based on his real life output and thus gives him a better chance or replicating that.

For Adjust hitters & pitchers, use adjust if: less than zero atAB, zero IP.

Do the same for make bad hitters and pitchers: lesss than zero AB, zero IP.

Set talent levels based on whole career or remaining career is a personal preference, I personally use whole career.

Make generic lefty/righty splits? Yes.

Ankit · 05-02-2003, 09:09 AM

Quote:

Originally posted by hamonrye
so the previous ankit db assigned random OF positions and the new one assigns the correct OF positions. does the career average db also have correct OF positions? i'm just curious...

also, has anyone tried the new career average database yet? i'm wondering how it's working...

The previous AnkitDB didn't assign random OF positions, they would appear random. Here's an example:

Lets say you create a historical league in 1954, Hank Aaron will be a Left fielder because in the FieldingOF file, he played 105 games that year in left and 11 in right.

Now you create a historical league in 1955, Aaron will be a right fielder, he played 105 in right as per the FieldingOF file.

Create a historical league in 1962 and Aaron is now a CF because he played 83 games there and only 71 as a RF. The new career avg fielding file, has Aaron rated for all three positions because he played on average 14 games in left per season, 13 in center and 95 in right. Thus his primary position will be Right field.

There are plenty of examples and I think the new DBs help give players more accurate OF positions. Do you agree?

hamonrye · 05-02-2003, 04:58 PM

i haven't tried it yet, but i'm anxious to....thanks ankit for your hard work...i'll be trying it out tonight

rferry · 05-03-2003, 01:05 AM

will you be updating your era-neutral normalized database for version 5?

Ankit · 05-03-2003, 09:49 AM

Quote:

Originally posted by rferry
will you be updating your era-neutral normalized database for version 5?

I don't know how many people used that DB but I have a feeling it wasn't that many. As such I am not inclined to make one right now. If more people ask for it, then yes. You are the first one to ask for it... When I do make it, I want to make it better than the previous one. I have not got any suggestions from its' users on how and what to improve nor do I have any ideas. So, I am just going to wait a while before I even think about it.

Qrusher14242 · 05-03-2003, 04:01 PM

the new database seems to be working fine...have players with Good and Brilliant Talent and Hitting now, thx Ankit

dcundy · 05-05-2003, 12:50 PM

Still having issue with minimal time players making a big impact using the career average db. What was the criteria used for excluding players with little playing time in real life? Is there a way to modify existing db to teak the players? If I wanted to remove some players (batters) do I have to remove them from the batters, master and fielding files or just the master file?

Ankit · 05-06-2003, 03:30 PM

Quote:

Originally posted by dcundy
Still having issue with minimal time players making a big impact using the career average db. What was the criteria used for excluding players with little playing time in real life? Is there a way to modify existing db to teak the players? If I wanted to remove some players (batters) do I have to remove them from the batters, master and fielding files or just the master file?

First, I deleted all batters who debuted prior to 1996 and had less than 100 career at-bats. I also deleted all pitchers who debuted prior to 1996 and had less than 20 career IP.

Yes, there is a way to tweak to the players but it is extremely time consuming and tedious. If you want to remove them, delete their info from Master.csv. If after you do this, some players import with no names or something like that, the you will have to delete those players from these files as well: Pitching.csv, Batting.csv, Fielding.csv and FieldingOF.csv.

Lastly, about minimal time players making a big impact using the career avg db, when you create the league do this:

Under Advanced Import Options, make sure Adust Hitters and Adjust Pitchers options have 100 AB and 80 IP, respectively. Also make sure that Make Bad Hitters and Make Bat Pitchers options have 25 AB and 20 IP, respectively.

This is going against what I have in my Read me file but I will fix that in the readme so it matches what I have said above.

dcundy · 05-06-2003, 10:47 PM

When you set those advanced options does it apply to every draft year in a career league?

Ankit · 05-07-2003, 12:21 AM

Quote:

Originally posted by dcundy
When you set those advanced options does it apply to every draft year in a career league?

From what I have seen, yes, it does.

05-01-2003, 04:27 PM	#1
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	AnkitDB 5 & Career Average DB 5 have both been re-released. While I was fixing the problem with the Career Average DB, the solution improved upon something that could be carried over to the AnkitDB as well. The problem with the Career Average DB was that OOTP was limiting the batting talent to Average as the highest because only one season's worth of stats for each player were in the Career Avg. DB. I tried to add a second year but that too didn't work. Then, I went back to modifying some queries I used to create the Career Average Fielding file to make the same kind of files for batting, pitching and fieldingOF. It worked!! Now, I also had the Career Average FieldingOF file, meaning that now if you import an OF in a certain year, he won't be rated to play seemingly random OF positions. Now, he will be rated according to his career average. This change is why I re-released AnkitDB 5. You can download AnkitDB 5 here: http://www.spleen1015.com/ankitdb/AnkitDB5.zip Download the Career Average DB 5 here: http://www.spleen1015.com/ankitdb/CarAvgDB5.zip Instructions for using the Career Average DB are in the zip file. Use the AnkitDB 5 just like you would use the Lahman DB. Have fun!!! __________________

05-01-2003, 07:28 PM	#4
targy All Star Starter Join Date: Jan 2002 Location: Clearwater, FL Posts: 1,152	You are the best __________________ www.emerge180.com

05-01-2003, 08:27 PM	#5
Tycobbler All Star Starter Join Date: Apr 2003 Location: 20 minutes from Comerica Park Posts: 1,957	good job excellent work big guy thanks

05-01-2003, 10:51 PM	#6
targy All Star Starter Join Date: Jan 2002 Location: Clearwater, FL Posts: 1,152	One question, in the original Lahman it has folders like Award etc...Do I have to download the original and then copy yours over that or just use yours __________________ www.emerge180.com

05-02-2003, 12:47 AM	#8
Mark42661 All Star Starter Join Date: Aug 2002 Location: Home of the Kansas City Chiefs! Posts: 1,080	When using the career average database for rookie drafts, are the ratings you see basically what you are going to get for a player's entire career, since they are based on a career average, or will players still develop and change? Also when you first create a historical league using your AnkitDB5, what do you suggest we imput for adjust hitters and pitchers and make bad hitters and pitchers? Whole career or remaining career and make generic L/R splits? Thanks __________________ A Man of the World Site dedicated to Sailor Tom Sharkey

05-01-2003, 04:42 PM	#2
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	Awesome! thx Ankit

05-01-2003, 05:15 PM	#3
sporr Global Moderator Join Date: Dec 2001 Location: Muscatine, IA Posts: 8,277	Great news! Thank you once again.

05-02-2003, 04:11 AM	#9
hamonrye Major Leagues Join Date: Sep 2002 Posts: 335	so the previous ankit db assigned random OF positions and the new one assigns the correct OF positions. does the career average db also have correct OF positions? i'm just curious... also, has anyone tried the new career average database yet? i'm wondering how it's working...

05-02-2003, 04:30 AM	#10
Dargone Hall Of Famer Join Date: Feb 2002 Location: Interwebs Posts: 2,862	Awesome __________________ 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-02-2003, 04:58 PM	#13
hamonrye Major Leagues Join Date: Sep 2002 Posts: 335	i haven't tried it yet, but i'm anxious to....thanks ankit for your hard work...i'll be trying it out tonight

05-03-2003, 01:05 AM	#14
rferry All Star Reserve Join Date: May 2002 Location: DC Posts: 549	will you be updating your era-neutral normalized database for version 5? __________________ please excuse my grammar, i read baseball weekly in my high school english classes.

05-03-2003, 04:01 PM	#16
Qrusher14242 All Star Starter Join Date: Feb 2002 Location: CA Posts: 1,253	the new database seems to be working fine...have players with Good and Brilliant Talent and Hitting now, thx Ankit

05-05-2003, 12:50 PM	#17
dcundy Minors (Single A) Join Date: Nov 2002 Posts: 71	Still having issue with minimal time players making a big impact using the career average db. What was the criteria used for excluding players with little playing time in real life? Is there a way to modify existing db to teak the players? If I wanted to remove some players (batters) do I have to remove them from the batters, master and fielding files or just the master file?

05-06-2003, 10:47 PM	#19
dcundy Minors (Single A) Join Date: Nov 2002 Posts: 71	When you set those advanced options does it apply to every draft year in a career league?