***VD 13 Spreadsheet***

[Ken]

Al Kaline had 1582 RBI not 1583
Goose Goslin had 1482 R not 1483
Goose Goslin had 1612 RBI not 1609
Goose Goslin had 176 SB not 175
Jack Chesbro had a 1.152 WHIP not 1.150

[johnnya24]

Johnny I recommend that you update your spreadsheet stats for Bond for 1875. I suspect you'll be pleasantly surprised with the changes (SO/WHIP/ERA).

Tommy Bond had 70 SO in 1875 not 8
Tommy Bond had a 0.878 WHIP in 1875 not 0.884
Tommy Bond had a 1.41 ERA in 1875 not 1.56

Thx bro. Gonna need those extra SO's!

[Ken]

Doc White had a 1.121 WHIP not 1.122 (another Johnny improvement)
Harry Heilmann had 1543 RBI not 1539
Tom Daly had a 0.433 OBP in 1894 not 0.436 (we need to knock Daly down some since DMT is currently in 1st)

[Ken]

Through pick 183

Bill Dickey had 36 SB not 37
Dizzy Dean had 31 Sv not 30
Frank Baker had 991 RBI not 987
George Sisler had 1178 RBI not 1175
Harry Heilmann had 1543 RBI not 1539
Ken Williams had 916 RBI not 913
Max Carey had 68 RBI in 1912 not 66
Max Carey had 802 RBI not 800
Mort Cooper had 15 Sv not 14
Tom Brown had 1524 R not 1521
Tom Brown had 658 SB not 657
Tom Brown had 742 RBI not 736
Tom Brown had a 0.336 OBP not 0.337

[Ken]

Additional changes through pick 238

Benny Kauff had 455 RBI not 454
Billy Pierce had 3 Sv in 1955 not 1
Billy Pierce had 33 Sv not 32
Ed McKean had 324 SB not 323
Ed McKean had 67 HR not 66
Ed McKean had a 0.365 OBP not 0.364
Fred Clarke had 1622 R not 1619
Fred Clarke had 509 SB not 506
George Brett had 1596 RBI not 1595
Hardy Richardson had 1127 R not 1120
Hardy Richardson had 207 SB not 205
Hardy Richardson had 73 HR not 70
Hardy Richardson had 828 RBI not 822
Harry Stovey had 1495 R not 1492
Harry Stovey had 912 RBI not 908
Jake Beckley had 1581 RBI not 1575
Jake Beckley had 1603 R not 1600
Jake Beckley had 87 HR not 86
Jimmy Sheckard had 810 RBI not 813
Joe Jackson had 792 RBI not 785
Joe Wood had 10 Sv not 11
Joe Wood had 1434.1 IP not 1436
Joe Wood had a 1.087 WHIP not 1.085
Roger Connor had 1323 RBI not 1322
Roy Face had 191 Sv not 193
Sam Thompson had 1308 RBI not 1305
Vida Blue had a 1.234 WHIP not 1.233

[mjl]

Unfortunate bug I just ran into - on the "pick" sheet, cell C100 points to $ROUNDS.J17 and J18, not 23 and 24; this made Johnny Bench look like he wasn't drafted on the "hit_car" and "hit_seas" sheets.

[Kevin Seitzer]

Unfortunate bug I just ran into - on the "pick" sheet, cell C100 points to $ROUNDS.J17 and J18, not 23 and 24; this made Johnny Bench look like he wasn't drafted on the "hit_car" and "hit_seas" sheets.

I don't have that problem in my sheet.

My guess is that what happened is you moved some cells on the 'rounds' worksheet? On the 'rounds' worksheet, I always recommend that people copy-and-paste rather than cutting/moving. I'm not sure if that's what happened, but it's the only way that comes to mind.

[johnnya24]

I don't have that problem with bench either. But I'll check when I get home.

I'm going to have a fun evening one of these days inputting all these "ken changes".

I think "ken work" is going to be my new go to phrase for undesirable tasks. I got a whole basket of Ken Work that needs ironing. I got a lotta Ken Work to do before I file my taxes etc etc

[Ken]

I don't have that problem with bench either. But I'll check when I get home.

I'm going to have a fun evening one of these days inputting all these "ken changes".

I think "ken work" is going to be my new go to phrase for undesirable tasks. I got a whole basket of Ken Work that needs ironing. I got a lotta Ken Work to do before I file my taxes etc etc

Haha, if I had edit rights to a spreadsheet I could do it via query in a lot less time than your taxes. Maybe I already do and just dont know it?

[Bene Futuis]

The OBP cell for each team's page for their hitter #15 is calculating batting average instead of OBP. The rest of the hitters are fine. The error is on both career and BY for hitter 15.

[johnnya24]

The OBP cell for each team's page for their hitter #15 is calculating batting average instead of OBP. The rest of the hitters are fine. The error is on both career and BY for hitter 15.

Thx. Fixed. Didn't effect the standings BTW ... that was already being calculated independently.

[Ken]

I don't have that problem with bench either. But I'll check when I get home.

I'm going to have a fun evening one of these days inputting all these "ken changes".

I think "ken work" is going to be my new go to phrase for undesirable tasks. I got a whole basket of Ken Work that needs ironing. I got a lotta Ken Work to do before I file my taxes etc etc

I filed my taxes last night. Biggest refund I've ever gotten, it was a nice surprise.

[Ken]

Full disclosure on my Mickey Cochrane pick...

Mickey Cochrane had 830 RBI not 832

[heyelander]

I filed my taxes last night. Biggest refund I've ever gotten, it was a nice surprise.

Filed mine this week.. can make it another 3 months before I move onto the streets

[Ken]

In 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

quinnja99
uhlege99
yeagejo99
youngcy99
youngir99
zachato99

Here are the playerID corrections for real playerIDs that do not match bbref (and therefore I'm calling them "incorrect" - in some cases they are just a difference between lahman and bbref, but we are standardizing on bbref)

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

Picks that need to be updated on the "Rounds" spreadsheet (note this is JUST a change to fix playerIDs not a change of stats):

Round 2 for Controller

h2
o'rouji01
1875

Round 15 for DMT
h9
o'doule01
1929

Round 18 for DMT
h9
o'neiti01
1929