***VD 13 Spreadsheet***

[Ken]

Stat corrections for newly picked players (through pick 120)

Norm Cash had 1045 R not 1046
Norm Cash had 1104 RBI not 1103
Sam Crawford had 1523 RBI not 1525

[TS Garp]

I'm still getting an error message starting with when I entered Thome for mjl. Usually it corrects itself after the next player but it's not this time.

[Kevin Seitzer]

I'm still getting an error message starting with when I entered Thome for mjl. Usually it corrects itself after the next player but it's not this time.

Both of those issues are addressed in previous posts in this thread. I can point you to them later if you can't find them.

[johnnya24]

I updated it, and it works fine on mine

Cell A39

Change "AC13" to "AC14"

[TS Garp]

I updated it, and it works fine on mine

Cell A39

Change "AC13" to "AC14"

Thanks. Now explain it again like you're explaining it to a kindergartner or 85 year-old.

[Kevin Seitzer]

In some later versions of the spreadsheet, Jim Thome's playerid has been changed to abreubo01 in the hit_car worksheet from 'thomeji01'. I'm not sure when or why this happened.

Garp, this is the other fix you need to make.

[Kevin Seitzer]

Found the mjl "red number" issue on the ROUNDS worksheet. (Reason it's been hard to find is that the only time it shows up is when mjl and hacko have picked different numbers of players.)

Formula in cell A39 is referencing Hacko's number of players on the standings sheet instead of mjl's (formula referencing cell stand!AC13 instead should be stand!AC14)

=COUNTA(C38:AC38)-stand!AC14+IF(MAX(dec!C15:Q15)>1,5,0)+IF(MAX(dec!C 33:Q33)>1,7,0)

And this is the one Johnny is explaining to you. (The formula in that cell has a typo.)

This is the lesser problem for you. The Thome problem will cause you more issues if you don't fix it, than this one will.

[The Feral Slasher]

Thanks. Now explain it again like you're explaining it to a kindergartner or 85 year-old.

or Feral Slasher

[Kevin Seitzer]

or Feral Slasher

What part of my explanation are you not following?

[The Feral Slasher]

What part of my explanation are you not following?

Sorry. I was just joking. No problem for me

[TS Garp]

Garp, this is the other fix you need to make.

I'm about to get on a conference call -- can you email a correct one to my work email?

[The Feral Slasher]

Sorry. I was just joking. No problem for me

Other than u stealing pete rose

[TS Garp]

I can pick shortly thereafter.

[Ken]

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

[Ken]

Eddie Cicotte had 3226 IP not 3223