I'm all in favor, as was Johnny, of you giving it a try.
I think a lot of what you see here from VD 12 and VD 13 prep is the result of us not having updated the stats since 2016, or in some cases, since 2011, except for some ad-hoc updates that revo did for us last draft. The last time I personally remember updating from the Lahman database was 2009. At that point I had a fairly standard set of queries and procedures to update the spreadsheet once a new season was published in the database. Would that process have been well-served by even further automation? Yes. But at the time it was at the edge of my capabilities, and I didn't feel it was worth the effort. And once I quit drafting, I think some of that fell by the wayside. Presumably others took up the mantle. But it does serve as a warning to me about how useless all my queries/scripts to pull from the Lahman database into the spreadsheet became to the VD community once I left.
The particular pain we've had around this draft and the previous one was that we didn't have a single source of stats like we'd had previously with the Lahman database. I was interviewing when we started the previous draft and didn't have access to the updated databases that I have from work. Now we're trying to catch up on the technical debt from all the half-assed updates we've made to the stats in the spreadsheet to keep the drafts running over the past seven years or so. One big database of BB-Ref data would go a long way toward smoothing over that path.
I think a lot of what you see here from VD 12 and VD 13 prep is the result of us not having updated the stats since 2016, or in some cases, since 2011, except for some ad-hoc updates that revo did for us last draft. The last time I personally remember updating from the Lahman database was 2009. At that point I had a fairly standard set of queries and procedures to update the spreadsheet once a new season was published in the database. Would that process have been well-served by even further automation? Yes. But at the time it was at the edge of my capabilities, and I didn't feel it was worth the effort. And once I quit drafting, I think some of that fell by the wayside. Presumably others took up the mantle. But it does serve as a warning to me about how useless all my queries/scripts to pull from the Lahman database into the spreadsheet became to the VD community once I left.
The particular pain we've had around this draft and the previous one was that we didn't have a single source of stats like we'd had previously with the Lahman database. I was interviewing when we started the previous draft and didn't have access to the updated databases that I have from work. Now we're trying to catch up on the technical debt from all the half-assed updates we've made to the stats in the spreadsheet to keep the drafts running over the past seven years or so. One big database of BB-Ref data would go a long way toward smoothing over that path.
Comment