Page 2 of 9 FirstFirst 1234 ... LastLast
Results 11 to 20 of 88

Thread: ***VD 13 Spreadsheet***

  1. #11
    I'm seeing some dups in hit_seas, appears to be specific to 1959
    cepedor01_1959
    boyerke01_1959
    allisbo01_1959
    ...

    It may be specific to mine, I use open office calc
    people called me an idiot for burning popcorn in the microwave, but i know the real truth. - nullnor

  2. #12
    Hall of Famer johnnya24's Avatar
    Join Date
    Mar 2011
    Location
    Belfast, NI
    Posts
    27,632
    Quote Originally Posted by Controller Jacobs View Post
    I use open office calc
    I feel your pain 🤪

    You can get a fully functioning and "legit" grey market MS Office key for about 20 bucks.

  3. #13
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,159
    Quote Originally Posted by Ken View Post
    I was thinking he needed some database indexes and a better execution plan.
    It's the truth. We'll get there. In the mean time, I still have to use the data. It's only a few tens of millions of rows, so it's not too bad.
    "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

  4. #14
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,159
    Quote Originally Posted by Controller Jacobs View Post
    I'm seeing some dups in hit_seas, appears to be specific to 1959
    cepedor01_1959
    boyerke01_1959
    allisbo01_1959
    ...

    It may be specific to mine, I use open office calc
    I confirm. There are 20 duplicate years, all from 1959. I will fix in the next release.
    "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. #15
    There may be two relevant pitching bys missing

    These were both taken in vd10:
    papeljo01_2014
    streehu01_2014

    If they are indeed missing, the Street one looks more important. The Papelbon one must have been a very specific need.
    people called me an idiot for burning popcorn in the microwave, but i know the real truth. - nullnor

  6. #16
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,159
    Updated with a new spreadsheet (link in the first post of this thread, and also in the history thread).

    New fixes in Version 1.1:
    17. Removed 20 duplicate hitter seasons from 1959.
    18. Remove the 14th drafter slot from various worksheets
    19. Update the standings rankings to reflect 13 teams instead of 14
    20. Update team sheets to reflect OBP instead of AVG
    "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. #17
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,159
    Quote Originally Posted by Controller Jacobs View Post
    There may be two relevant pitching bys missing

    These were both taken in vd10:
    papeljo01_2014
    streehu01_2014

    If they are indeed missing, the Street one looks more important. The Papelbon one must have been a very specific need.
    I'll plan to catch this when I update pitcher stats.

    Do you have the ability to check the BB-Ref IDs for the players I added from 2013 onwards?
    "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

  8. #18
    Quote Originally Posted by Kevin Seitzer View Post
    I'll plan to catch this when I update pitcher stats.

    Do you have the ability to check the BB-Ref IDs for the players I added from 2013 onwards?
    I have a nice bbref player id lookup for 2018 on the crashed machine. If it comes back up, I'll be able to check from that. I also have 2013-2017 - that's easier to rebuild since it's in that database that I downloaded.
    people called me an idiot for burning popcorn in the microwave, but i know the real truth. - nullnor

  9. #19
    Big Leaguer Kevin Seitzer's Avatar
    Join Date
    Jan 2011
    Location
    Houston, TX
    Posts
    3,159
    One quirk I noticed/remembered is that Lahman and BB-Ref differ on the playerID for Kevin Youkilis. I believe we were using Lahman's ID (youkike01) instead of BB-Ref (youklke01). I personally don't care which as long as we standardize on one.
    "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

  10. #20
    Big Leaguer
    Join Date
    Feb 2016
    Posts
    2,469
    Quote Originally Posted by Kevin Seitzer View Post
    One quirk I noticed/remembered is that Lahman and BB-Ref differ on the playerID for Kevin Youkilis. I believe we were using Lahman's ID (youkike01) instead of BB-Ref (youklke01). I personally don't care which as long as we standardize on one.
    I vote BB-ref since it's easier to get to that data

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
  •