... My new umpires table has data 1871-2002, regular season only. I'm next planning on looking for a source of All-Star/PostSeason umps so I can imput that. ...
896
Paul Wendt
pgw02472
Nov 1, 2002 5:21 pm
... I hope you will check again, Mike, but we need another pair of eyes here. The only reported count that I see is in the a second paragraph of the ...
897
Paul Wendt
pgw02472
Nov 1, 2002 5:21 pm
... After everyone without a LahmanID has an umpire_ID, there may be a good way to create the POSTUMPIRES table from the historical record using the shorter...
898
Rob Wood
robertowood
Nov 2, 2002 12:10 am
For what it is worth, TB7 says that the 1936 HOF election in question was "held by a special veterans' committee of 78 designed to choose among "old-timers"."...
899
rxqhccinsdas
Nov 2, 2002 12:59 am
http://portrelll.4mg.com/index.html...
900
shjhiltikhmt
Nov 4, 2002 1:15 am
http://jhueiase.4t.com/index.html...
901
rpger_007
Nov 5, 2002 11:31 am
Does anyone know where I can find relief and starting pitching splits for the 1991-98 Milwaukee Brewers?...
902
kjokbaseball
Nov 5, 2002 5:06 pm
... Yes, Baseball Direct has them. Go to: http://www.baseballdirect.com/scoreboard/ then select STATS at the top, and then Select the Brewers under TEAM ...
903
mgyglypwaibd
Nov 6, 2002 1:59 am
free pictures here http://freepiccs.itgo.com/index.html...
904
ken_matinale
Nov 6, 2002 2:47 pm
Hi, I tried to make a table of unique team abbreviations from the Lahman Access Batting table through the 2001 season. I found 99 items listed below with...
905
tom tom
tangotiger
Nov 6, 2002 2:59 pm
I think they've all been addressed with bdb4.6 If I remember, the problem was with Sean L and Sean F joining forces, and there was some mixup along the way....
906
Mike Crain
ucraimx
Nov 7, 2002 4:27 pm
Looks like that is my error. Total votes is an Excel calulcated field. I had votes needed (Which is 75% of the total). If anyone has the total votes data nad...
907
Paul Wendt
pgw02472
Nov 7, 2002 8:05 pm
... I know Bill Deane well by email. I can ask him whether he has direct evidence of the 78 (denominator) or 59 (votes needed). Using the 75% rule, the...
908
Crain, Mike (LNG-DAY)
ucraimx
Nov 12, 2002 2:30 pm
I need to convert the IPOuts collumn to display an Innings piatched. Is there any Excel function that if the value ends in .3, it will correct to .1, and .7 to...
909
tom tom
tangotiger
Nov 12, 2002 2:53 pm
Do the following In cell A1, put =5 (that will be your IPouts) In cell A2, put =INT(A1/3)+MOD(A1,3)/10 ... __________________________________________________ ...
910
F. X. Flinn
FXFlinn
Nov 12, 2002 3:18 pm
=Int(cell)+(((cell)-int(cell))*3)/10 ... From: Crain, Mike (LNG-DAY) [mailto:ucraimx@...] Sent: Tuesday, November 12, 2002 9:30 AM To: 'BBALL - Databank'...
911
Crain, Mike (LNG-DAY)
ucraimx
Nov 12, 2002 4:13 pm
I was looking at Wally Andrews. My OLD copy of BaseballEncyclopedia (Circa 1976) list him as playing in 1885 with Providence in 1 game. Neither the ...
912
Sean Lahman
anson2995
Nov 12, 2002 4:24 pm
This reminds me, if I haven't said it before... I think the best solution (from a design view) is to have a separate column for fractional innings pitched. So...
913
micke.hovmoller@...
mhovm1
Nov 12, 2002 4:34 pm
... I think the best solution is to have a column for "Outs Recorded" (I don't know if there is a proper term for it), i.e. IP*3. That makes summaries over...
914
tom tom
tangotiger
Nov 12, 2002 4:41 pm
Just to be clear, the 4.6 version has "IPouts". A pitcher with 1 2/3 IP will have a value of "5". Having 2 columns will still pose problems, especially when...
... There is an another way to do this. Use the "dollarfr"; function: =round(dollarfr(IP,3),1) Ex: =round(dollarfr(20.7,3),1) = 20.2 I use the "dollarfe";...
917
ken_matinale
Nov 13, 2002 4:14 pm
Hi, The stats at mlb.com seem to have an integer as the ID for a player. For instance, A-Rod appears to have playerID=121347. You can see it in the URL after...
918
tom tom
tangotiger
Nov 13, 2002 6:55 pm
Having discussed this at length in the past, the consensus is that we cannot rely on any one entity to supply the IDs, and therefore, it is best that each ...
919
timmermant
Nov 13, 2002 7:56 pm
Hello all, I've seen a couple of references to version 4.6 lately. I'm just checking to make sure I haven't missed its release. I'm assuming that 4.6 is the...
920
Sean Lahman
anson2995
Nov 13, 2002 8:01 pm
Well, the primary reason is that they've only got numbers for active players. And while a sequential number is preferable from the rules of database design, it...
921
tom tom
tangotiger
Nov 13, 2002 8:07 pm
The version on baseball-databank.org is called, I think, bdb46. Tom ... __________________________________________________ Do you Yahoo!? U2 on LAUNCH -...
... Quick status update. I have the stats, and I'm now patching in the new players and the new IDs. Optimistically, I'll get that done tomorrow night. ...
924
Holmes, Dan
hof_boone
Nov 14, 2002 2:04 pm
The use of alphanumeric player Ids, while not preferable for B design, works well for ad hoc queries. For example, I have created a switchboard in Access that...
