Ping: database gurus

Eckstein 4 Prez · 03-23-2005, 02:55 PM

So, I'm here at work looking over the Win Shares spreadsheet that I got from BigCity (he's got it at bigcitybaseball, for those who are interested). I'm also looking over my Catobase mdb files, and noticing that most of the information I need is right there, waiting to be input into the Excel spreadsheet.

Now, in my heart of hearts, what I'd REALLY like is to have a utility that automatically can move the data from one file to the other. However, that can wait: my real issue is, where is the underlying data for the park factors in Catobase? I see the computed Park Factors in the TeamStats table, but is there somewhere where Cato put the runs/hits/home runs by park before doing this? I notice that most of the tables still have a lot of the interim data used for the calculations, but I can't find those particular fields anywhere.

Failing this, can anyone show me how to set up a new table with the Cato info that calculates this information?

If any of these questions are unclear, please let me know and I'll try to explain better. Thanks.

03-23-2005, 02:55 PM	#1
Eckstein 4 Prez Hall Of Famer Join Date: Dec 2002 Location: The OC Posts: 6,358	Ping: database gurus So, I'm here at work looking over the Win Shares spreadsheet that I got from BigCity (he's got it at bigcitybaseball, for those who are interested). I'm also looking over my Catobase mdb files, and noticing that most of the information I need is right there, waiting to be input into the Excel spreadsheet. Now, in my heart of hearts, what I'd REALLY like is to have a utility that automatically can move the data from one file to the other. However, that can wait: my real issue is, where is the underlying data for the park factors in Catobase? I see the computed Park Factors in the TeamStats table, but is there somewhere where Cato put the runs/hits/home runs by park before doing this? I notice that most of the tables still have a lot of the interim data used for the calculations, but I can't find those particular fields anywhere. Failing this, can anyone show me how to set up a new table with the Cato info that calculates this information? If any of these questions are unclear, please let me know and I'll try to explain better. Thanks. __________________ Looking for an insomnia cure? Check out my dynasty thread, The Dawn of American Professional Base Ball, 1871.