Originally posted by heyelander
View Post
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
***VD 13 Spreadsheet***
Collapse
X
-
---------------------------------------------
Champagne for breakfast and a Sherman in my hand !
---------------------------------------------
The Party told you to reject the evidence of your eyes and ears. It was their final, most essential command.
George Orwell, 1984
-
Additional playerID oddities:
On the season sheets (not the career sheets) these were wrong:
martijd01->martijd02
mccutan01->mccutan01
sanchga01->sanchga02
devench01->devench02
And Sam Gray had Dolly Gray's playerID listed (as discussed in the commentary thread).
Comment
-
Spreadsheet with updated player data from BR --
Comment
-
Originally posted by Ken View PostSpreadsheet with updated player data from BR --
https://docs.google.com/spreadsheets...DfJYZLh-fi8_HA
Comment
-
Originally posted by Ken View PostSpreadsheet with updated player data from BR --
https://docs.google.com/spreadsheets...DfJYZLh-fi8_HA
I'm going to do it for now ... because the alternative is Ken Work. But is that the way we want to go?
Comment
-
Originally posted by johnnya24 View PostWait ... we're using the apostrophes in the player codes now?
I'm going to do it for now ... because the alternative is Ken Work. But is that the way we want to go?
Additional playerID oddities:
On the season sheets (not the career sheets) these were wrong:
martijd01->martijd02
mccutan01->mccutan01
sanchga01->sanchga02
devench01->devench02
incorrect last first correct
drewjd01 Drew J.D. drewj.01
mondead01 Mondesi Adalberto mondera02
obrieda01 O'Brien Darby o'brida01
obrieja01 O'Brien Jack o'brija01
obriepe03 O'Brien Pete o'bripe03
oconnja01 O'Connor Jack o'conja01
odoulle01 O'Doul Lefty o'doule01
ofarrbo01 O'Farrell Bob o'farbo01
oneilpa01 O'Neill Paul o'neipa01
oneilst01 O'Neill Steve o'neist01
oneilti01 O'Neill Tip o'neiti01
orourji01 O'Rourke Jim o'rouch01
orourjo01 O'Rourke John o'roujo01
phamto01 Pham Tommy phamth01
pierzaj01 Pierzynski Anthony pierza.01
surhobj01 Surhoff B.J. surhob.01
youkike01 Youkilis Kevin youklke01
burneaj01 Burnett A.J. burnea.01
delacto01 de la Cruz Tommy dela_to01
dickera01 Dickey R.A. dicker.01
garcifr02 Garcia Freddy garcifr03
graydo02 Gray Dolly graydo01
harriwi02 Harris Will harriwi10
johnsji01 Johnson Jim johnsji04
odayha01 O'Day Hank o'dayha01
odellbi01 O'Dell Billy o'delbi01
ortizra01 Ortiz Ramon ortizra02
richajr01 Richard J.R. richaj.01
ryanbj01 Ryan B.J. ryanb.01
sabatcc01 Sabathia CC sabatc.01
santajo01 Santana Johan santajo02
vazqufe01 Vazquez Felipe riverfe01
And Sam Gray had Dolly Gray's playerID listed (as discussed in the commentary thread).
Round 2 for Controller
h2
o'rouji01
1875
Round 15 for DMT
h9
o'doule01
1929
Round 18 for DMT
h9
o'neiti01
1929
The 3 changes on the ROUNDS sheet are all you should have to change right?
Jim O'rourke is o'rouji01
Check out the latest Stats, Height, Weight, Position, Rookie Status & More of Jim O'Rourke. Get info about his position, age, height, weight, draft status, bats, throws, school and more on Baseball-reference.com
o'rouch01 is the wrong guy, that's a guy who had 2 PA in his career in 1959.
Comment
-
Originally posted by Ken View Post
The 3 changes on the ROUNDS sheet are all you should have to change right?
Jim O'rourke is o'rouji01
Check out the latest Stats, Height, Weight, Position, Rookie Status & More of Jim O'Rourke. Get info about his position, age, height, weight, draft status, bats, throws, school and more on Baseball-reference.com
o'rouch01 is the wrong guy, that's a guy who had 2 PA in his career in 1959.
Jim O'Rouke's career stats are missing. i'll fix it manually
Comment
-
Originally posted by johnnya24 View PostGot those changes. The "o'rouch01" guy has Jim O'Rourke Best Years it seems.
Jim O'Rouke's career stats are missing. i'll fix it manually---------------------------------------------
Champagne for breakfast and a Sherman in my hand !
---------------------------------------------
The Party told you to reject the evidence of your eyes and ears. It was their final, most essential command.
George Orwell, 1984
Comment
-
-
Code:x Team CH CP BYH BYP Multi Place .01 Controller_ 40.8 49.3 38.4 49.8 178.311 2 .02 DMT_____ 41.2 49.3 46.8 46.4 183.757 1 .03 JohnnyA__ 54.6 31.3 56.7 31.3 173.824 4 .04 Frae______ 35.6 42.2 44.8 44.5 167.077 8 .05 El Bene___ 42.1 40.3 29.5 46.9 158.889 11 .06 Ken______ 38.5 40.0 44.0 46.7 169.146 5 .07 TS Garp__ 34.5 45.8 37.7 45.2 163.098 10 .08 Heyelander 41.6 39.8 38.7 38.0 158.073 13 .09 Revo_____ 42.7 45.7 31.7 38.7 158.749 12 .10 Feral Slash 37.8 52.5 35.3 50.9 176.450 3 .11 KS_______ 38.0 40.4 42.9 44.1 165.446 9 .12 Hacko____ 49.0 37.7 48.3 32.4 167.239 7 .13 mjl_______ 50.8 32.8 52.3 32.1 168.031 6
Comment
-
Is it something weird about the way LibreOffice imported the spreadsheet that it looks like all of the players are KO'ed? The formula looks like =IF(ISNA(MATCH(C2,pick!#ref!,0)),0,"KO")In the best of times, our days are numbered, anyway. And it would be a crime against Nature for any generation to take the world crisis so solemnly that it put off enjoying those things for which we were presumably designed in the first place, and which the gravest statesmen and the hoarsest politicians hope to make available to all men in the end: I mean the opportunity to do good work, to fall in love, to enjoy friends, to sit under trees, to read, to hit a ball and bounce the baby.
Comment
-
Originally posted by mjl View PostIs it something weird about the way LibreOffice imported the spreadsheet that it looks like all of the players are KO'ed? The formula looks like =IF(ISNA(MATCH(C2,pick!#ref!,0)),0,"KO")"Jesus said to them, 'Truly I tell you, the tax collectors and the prostitutes are going into the kingdom of God ahead of you.'"
Comment
-
Originally posted by Ken View PostIn the spreadsheet there are several rows of "99" stats. I believe these were an early attempt at getting hitting stats for some pitchers? Regardless they aren't real ID's so I'm ignoring the
Code:quinnja99 uhlege99 yeagejo99 youngcy99 youngir99 zachato99
"Jesus said to them, 'Truly I tell you, the tax collectors and the prostitutes are going into the kingdom of God ahead of you.'"
Comment
Comment