OOTP Developments Forums - View Single Post - Anderson Utilities

Comedian2004 · 09-12-2006, 02:49 PM

I am using the Lehrman database to pull up the historical data. That is why the grids with the stats are formatted in different order. I am hiding some of the columns that are not used. It would be too difficult to align those two grids up. That is why I have the grid with the differences. I will pretty that up when I get the numbers all in there.

I have not got as far as no historical records, but:

The program checks to see if your league is a historical and if NOT, it will tell you and not let you run it. I may change that to just advise you.

I will modify the list of players so that they are only shown if they are in the historical database. So, it will really be impossible to show stats for non-real plays in the program.

Now this is a season to season display. So, you are comparing the 1927 Babe Ruth with the 1927 Babe Ruth. It currently only compares your current season. So, if you are in 1949, it just shows 1949 stats. I will change that to allow you to pick what season you want to load.

When the program first loads and you hit the start button, it first loads in all the players in the league from your CSV file. It then loads in all the player's stats for the given year. It loads this entire file into memory, but just the stats for this year and for your MLB. No splits, no minors, no post season stats are loaded. Then it loads in the entire lahman database for players in the given year.

Then you can start clicking on players.

Now, if you wanted to switch years, you would basically have to click START again and clear our everything and reload it for the year. The problem is, if it is a LONG league, 50+ years, it takes a minute to load in the stats. There is no workaround for this, as it is the bad design of the dump.

I still have to load the pitcher's stats also, and do all the screens for the pitchers. It will autodetect if it is a hitter or pitcher and display the correct stats.

Once the individual compare is complete, then I will add a league compare. It will basically go through every player and do the compare. It will then display the top 50 over performers and top 50 under performers and maybe the top 50 most accurate.

09-12-2006, 02:49 PM	#6 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,396	I am using the Lehrman database to pull up the historical data. That is why the grids with the stats are formatted in different order. I am hiding some of the columns that are not used. It would be too difficult to align those two grids up. That is why I have the grid with the differences. I will pretty that up when I get the numbers all in there. I have not got as far as no historical records, but: The program checks to see if your league is a historical and if NOT, it will tell you and not let you run it. I may change that to just advise you. I will modify the list of players so that they are only shown if they are in the historical database. So, it will really be impossible to show stats for non-real plays in the program. Now this is a season to season display. So, you are comparing the 1927 Babe Ruth with the 1927 Babe Ruth. It currently only compares your current season. So, if you are in 1949, it just shows 1949 stats. I will change that to allow you to pick what season you want to load. When the program first loads and you hit the start button, it first loads in all the players in the league from your CSV file. It then loads in all the player's stats for the given year. It loads this entire file into memory, but just the stats for this year and for your MLB. No splits, no minors, no post season stats are loaded. Then it loads in the entire lahman database for players in the given year. Then you can start clicking on players. Now, if you wanted to switch years, you would basically have to click START again and clear our everything and reload it for the year. The problem is, if it is a LONG league, 50+ years, it takes a minute to load in the stats. There is no workaround for this, as it is the bad design of the dump. I still have to load the pitcher's stats also, and do all the screens for the pitchers. It will autodetect if it is a hitter or pitcher and display the correct stats. Once the individual compare is complete, then I will add a league compare. It will basically go through every player and do the compare. It will then display the top 50 over performers and top 50 under performers and maybe the top 50 most accurate. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!