[Comedian2004]

I started the work on this program, slowing getting something to work. Some complex stuff I have to do in it!

I struggled with the players, so I switched to the team stuff first, and that went easier. No screenshot yet, as it is too ugly, but using it, I see that the Tigers in 1963 went 72-90.

Runs scored:

1 12-12
2 12-18
3 8-12
4 6-9
5+ 31-34

I am going to go ahead and break that down further, from 6-9 then a 10+.

Also do the same for runs allowed.

I also had it check for games when they had an error.

With no errors, they were 37-39, when they had +1 errors, they were 35-51.

I still have to tweak the numbers, as something is wrong, as the Win totals under runs is 69, so I am missing 3 games. Obviously, if they scored zero runs, they did not win the game.

The error numbers are correct.

Now it gets more complicated, as I have to access another CSV file and do some figuring out. Some of the things I want to add are: (Please suggest some for me)

When leading after 8 innings
When leading after 7 innings
When leading after 6 innings (Might as well include innings 1-8)
When scoring 1st
When someone on the team hits a HR.

Some other things that may be a little easier, would be some streak things: (These are for the team)

Games in a row with an extra base hit
Games in a row with a HR
Consecective shutout innings and being shutout

For the Hitters:

W/L when player hit HR
W/L when player started
W/L when player hit HR player got 2 or more hits
W/L when player hit HR player batted 1st
W/L when player hit HR player batted 2nd (and rest of places in lineup)
W/L when player hit HR player was DH
W/L when player hit HR player scored a run
W/L when player hit HR player knocked in a run

Maybe also some streak records:

Hits in a row
Getting on base in a row
Walks in a row
K's in a row
Most ABs in a row w/o a HR
Most ABs in a row w/o a hit
Most ABs in a row w/o a walk

Pitchers:

Team record when he started the game
Team record when he lasted 5, 7, 8, 9 innings
Team record when he allowed a HR
Team record when he allowed XX runs
Team record when he allowed XX walks
Team record when he allowed XX K's

Streaks:

K's in a row
W's in a row
Hits in a row
Batter on base in a row
Consective shutout innings

Basically, when you are listening to a game on the radio/TV and they throw out one of those oddball stats, write it down and post it in here. That is what I am looking for.

I think I may have to start from scratch again and redesign it, maybe creating a database that contains all this data and then using SQL to access it. That way you can define the parameters that you want.

So, I may work on importing all of the CSV files that are needed into a SQL database. I have not done this before, as there has been a stumbling block in creating the database. I do have some new books, so, I will give it a try.