btw Ken, doubt this helps you all that much since I suspect you must be way beyond this point, but I just happened across the work I did for VD10 converting Lahman to our format. http://tinyurl.com/neutralmilkhotelsucks
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
***VD 13 Spreadsheet***
Collapse
X
-
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.
-
Originally posted by johnnya24 View PostI'll get all those changes down at some point today. Thx fellas ... Good work
I'm checking in BB-Ref as I go. There are H/AB changes for some of the players Ken listed, as well."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
-
The last hitter slot (#15) is calculating AVG instead of OBP in the OBP column on the team pages. This doesn't affect anything in terms of standings/rankings, but it does display the wrong value in that cell."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 Kevin Seitzer View PostThe last hitter slot (#15) is calculating AVG instead of OBP in the OBP column on the team pages. This doesn't affect anything in terms of standings/rankings, but it does display the wrong value in that cell.
Comment
-
Originally posted by johnnya24 View PostIOW KS has his next 15 picks mapped out."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
-
There's a mistake in the spreadsheet where a bunch of Feral's entries in column E and F of his page reference column "sac" instead of "AC", which breaks a bunch of other stuff.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
-
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)"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
-
Ken's corrections of the day (through pick 108)
Bob Feller had 22 Sv not 21
Charlie Gehringer had 1775 R not 1774
Eddie Cicotte had 209 W not 208
Eddie Cicotte had 24 Sv not 25
Eddie Cicotte had a 1.154 WHIP not 1.155
Gaylord Perry had 10 Sv not 11
Pud Galvin had 1807 SO not 1806
Pud Galvin had 365 W not 364
Pud Galvin had a 2.85 ERA not 2.86
Ty Cobb had a 0.466 OBP in 1911 not 0.467
Whitey Ford had 11 Sv not 10
Comment
-
Originally posted by Ken View PostKen's corrections of the day (through pick 108)
Bob Feller had 22 Sv not 21
Charlie Gehringer had 1775 R not 1774
Eddie Cicotte had 209 W not 208
Eddie Cicotte had 24 Sv not 25
Eddie Cicotte had a 1.154 WHIP not 1.155
Gaylord Perry had 10 Sv not 11
Pud Galvin had 1807 SO not 1806
Pud Galvin had 365 W not 364
Pud Galvin had a 2.85 ERA not 2.86
Ty Cobb had a 0.466 OBP in 1911 not 0.467
Whitey Ford had 11 Sv not 10
Someone take Ken's laptop away please
Comment
-
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."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