Page 1 of 5

StratRat: 70's, 80's and 90's Stats - 5/30/11 - New URL

PostPosted: Mon Oct 15, 2007 10:16 pm
by YountFan
I have been slaving for the 70's and 80's for you guys.

Teams: 10,000+
AB's guys with over 500,000
IP's guys with ove 245,000


It ain't no DiamondDope, but hey the mystery card game is the step child of TSN anyways.

Enjoy it and provide some feedback. Be aware that I have no web programming skills so don't expect amazing things.

YountFan

[b:c6687e497d]5/30/11 Update: I have moved most of the stuff here. I still need to bring over the Pitcher by Ballpark stats. That could happen this week. I am also working on collecting stats for the 90's so stay tuned. [/b:c6687e497d]

[url=http://apex.oracle.com/pls/apex/f?p=45738:1]YountFan's StratRat StatPack[/url]

A Wonderful Tool...

PostPosted: Tue Oct 16, 2007 10:20 am
by ddeakin
YountFan, simply amazing. Thanks for sharing this.

A Question and an Issue.

This includes only completed seasons, correct? By that I mean if the player got cut and finished the season as a free agent, his stats for that season are not included in this database?

Secondly, in the 80's Hitter side of the fence, the links to the individual hitters cause the following error:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/StratRat/hitter_cards80.asp, line 68

All in all, looks like a great tool!

PostPosted: Tue Oct 16, 2007 4:39 pm
by YountFan
Not sure how it happened, but it is fixed now. And I am collecting more data

[quote:2ab46ee685]This includes only completed seasons, correct? By that I mean if the player got cut and finished the season as a free agent, his stats for that season are not included in this database? [/quote:2ab46ee685]
This is sadly true, but it is what we live with

PostPosted: Tue Oct 16, 2007 5:01 pm
by jsam9801
Pretty amazing to see which RP have pitched the most innings...Steamer, Reardon and Worrell in the top 12.

Quick Question: OBP seems low for the players. Highest catcher OBP is .328...that seems off.

Thanks YF for your efforts.

J

PostPosted: Tue Oct 16, 2007 5:28 pm
by YountFan
I thought the OBP looked off too, but it the one I checked were correct. How many time has your C been on base more than .328? Look at Carew, Hernandez etc. Near .400

PostPosted: Tue Oct 16, 2007 5:34 pm
by jsam9801
the suprise was tettleton...I either ride out a .340 - .380 OBP or cut him as soon as I know I have a bad card.

Carter too. I think of BC's decade league. Carter .308 in '82, .354 in '83 and .390 in '84 for my last 3 seasons.

PostPosted: Tue Oct 16, 2007 6:44 pm
by YountFan
I found my error. Expect an update by morning.

PostPosted: Tue Oct 16, 2007 8:35 pm
by jsam9801
My real question is how are you able to collect the data? Thanks again for all of your hard work.

j

PostPosted: Wed Oct 17, 2007 5:03 pm
by YountFan
J, I wrote a java program to read the team sim and spilt pages and extract the data into a tab delimited file.

I then import this in to Access and produce summary data for the web pages.

I think I may need to pay for a provider because the free one I am using has issues with performance and stuff.

YF

PostPosted: Thu Oct 18, 2007 10:06 am
by jsam9801
[quote:bd5527b460="YountFan"] I think I may need to pay for a provider because the free one I am using has issues with performance and stuff. YF[/quote:bd5527b460]

We are all benefitting from your hard work. We will all chip in. :D

Let me know the cost, and I will contribute.

J