Page 14 of 15 FirstFirst ... 412131415 LastLast
Results 131 to 140 of 145

Thread: ***VD 13 Spreadsheet***

  1. #131
    Big Leaguer
    Join Date
    Feb 2016
    Posts
    2,875
    Quote Originally Posted by The Feral Slasher View Post
    No need its fine
    Good point - I feel like we should vote on this issue.

  2. #132
    Hall of Famer johnnya24's Avatar
    Join Date
    Mar 2011
    Location
    Belfast, NI
    Posts
    28,054
    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

  3. #133
    Big Leaguer
    Join Date
    Jan 2011
    Location
    San Francisco
    Posts
    3,661
    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.

  4. #134
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,631
    Quote Originally Posted by mjl View Post
    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")
    Formula should be =IF(ISNA(MATCH(C2,pick!$M$2:$M$352,0)),0,"KO")
    "There was nothing for him to do under the truck, but it's tough to blame him now that he is dead." -V.Erps 3/26/2005

  5. #135
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,631
    Quote Originally Posted by Ken View Post
    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

    Code:
    quinnja99
    uhlege99
    yeagejo99
    youngcy99
    youngir99
    zachato99
    We wanted to have every eligible QUIZY hitter in the spreadsheet (more relevant when we combine letters with decades). I forget why we distinguished them with a 99. I'm sure there's a reason for it, but obviously we're not doing that for John Ward or Dave Foutz, so if there was a good reason for it, I don't think it still matters? It's one of those Chesterton's Fence things...I wish I remember why we used the 99s.
    "There was nothing for him to do under the truck, but it's tough to blame him now that he is dead." -V.Erps 3/26/2005

  6. #136
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,631
    What's the deal with Jim O'Rourke?

    I'm using the new stats from Ken, and I changed his ID from o'rouch01 to o'rouji01, but I gather I need to update some stats, too?

    And did we lose some of his best year options from the hit_seas worksheet, too?
    "There was nothing for him to do under the truck, but it's tough to blame him now that he is dead." -V.Erps 3/26/2005

  7. #137
    Hall of Famer johnnya24's Avatar
    Join Date
    Mar 2011
    Location
    Belfast, NI
    Posts
    28,054
    Quote Originally Posted by Kevin Seitzer View Post
    What's the deal with Jim O'Rourke?

    I'm using the new stats from Ken, and I changed his ID from o'rouch01 to o'rouji01, but I gather I need to update some stats, too?

    And did we lose some of his best year options from the hit_seas worksheet, too?
    Discussion above on O'Rourke. You'll need to add his career stats manually and change his by codes.

    We lost some career and by hitting lines. Pitching was fine

  8. #138
    Big Leaguer
    Join Date
    Feb 2016
    Posts
    2,875
    Quote Originally Posted by johnnya24 View Post
    Discussion above on O'Rourke. You'll need to add his career stats manually and change his by codes.

    We lost some career and by hitting lines. Pitching was fine
    What was lost? I only removed the 99 years but we can add those back if they are needed

  9. #139
    Hall of Famer johnnya24's Avatar
    Join Date
    Mar 2011
    Location
    Belfast, NI
    Posts
    28,054
    Quote Originally Posted by Ken View Post
    What was lost? I only removed the 99 years but we can add those back if they are needed
    There were maybe 5 it 6 lines missing from the career batting sheet, and something similar on the BY.

    My guess is that some of the non descript quizy didn't make it across.

    Maybe ken knows?

  10. #140
    Hall of Famer johnnya24's Avatar
    Join Date
    Mar 2011
    Location
    Belfast, NI
    Posts
    28,054
    Thought I was answering KS ... Soz

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •