Originally posted by cavebird
View Post
Announcement
Collapse
No announcement yet.
Announcement
Collapse
No announcement yet.
*** VD 14 Commentary Thread ***
Collapse
X
-
Bene has been around since the last pick, but apparently also at church.
Leave a comment:
-
Originally posted by Ken View PostNot following you exactly.
How do the Lahman sheets make it easier?
And as far as static or dynamic what do you mean
Leave a comment:
-
Originally posted by johnnya24 View PostWe would need to decide if we are going to make it dynamic of just create a static list of available "peak years". The later might be easier.
We will need a lot more player data on the sheet, though I have the 2019 Lahman sheets to make that a lot easier.
If we are to make it dynamic, we'd need to create a way for players to plug in year ranges.
The static option is definitely easier and certainly doable, especially with Lahman.
How do the Lahman sheets make it easier?
And as far as static or dynamic what do you mean
Leave a comment:
-
Originally posted by Ken View PostI can do it automatically if you need me to, that's like 10 minutes of work at most assuming I have all the data correct (and I can spot check the data against a known good source of your choosing, i.e. the spreadsheet).
We will need a lot more player data on the sheet, though I have the 2019 Lahman sheets to make that a lot easier.
If we are to make it dynamic, we'd need to create a way for players to plug in year ranges.
The static option is definitely easier and certainly doable, especially with Lahman.
Leave a comment:
-
Originally posted by johnnya24 View PostAND ... if I can sort out a way to do this, I might be able to add "Peak Year" data to the spreadsheet also. Though this is more of a long-shot.
I tried this several years ago. The idea was that, instead of using BY, we would use the average of 3 or 5 consecutive years of a players career, which would constitute peak years performance, rather than a 1-off BY. So for instance:
Pedro Martinez's best 5 year average :
1997-2001 - 17w 163k 2.18era 0.926whip
3 year average:
1998-2000 - 20w 283k 2.25era 0.922whip
It's unlikely that I can make this work in an automated way ... but maybe. An alternative way would be to throw a lot of man hours at it on baseball-reference.com, and manually compile the data using B-R.com's automatic compiler. This would be doable if I had some volunteers.
Leave a comment:
-
Originally posted by heyelander View Postexplains a lot? No, I meant the combined pages. I always just added the career stuff to the BY pages
Leave a comment:
-
Originally posted by heyelander View PostFunny, I don't think I ever looked at them, but created them on my own every time.
Leave a comment:
-
Originally posted by johnnya24 View PostYou never looked at the Snapshot?
Leave a comment:
-
Originally posted by johnnya24 View PostThe last 2 or 3 drafts at least.
The black tabs are my creation (Snapshot, hit_comb, pit_comb). The rest is original copyrighted Kevin Seitzer (apart from the flourishes on the Rounds sheet).
Glad someone is making use of them. I have to re-remember how to build those pages every time I compile the spreadsheet. If you do it right, you should be able to copy paste your formulas from one draft to the next.
Leave a comment:
-
Originally posted by Bene Futuis View PostDownloaded the most recent spreadsheet and my problems are solved! Had to re-input my formulas which is always kind of a chore but.....
Holy crap the hit_comb and pit_comb sheets are amazing!!!! I swear, if I'd have used these things all along I'd be undefeated. Well, maybe not that but having rankings like that is just fantastic. Thanks for the work on that, Johnny! How long has that been in the sheet?
Leave a comment:
-
Originally posted by johnnya24 View PostLet's walk before we crawl through the fiery pit of hell that will be the decade-letter-franchise draft.
Leave a comment:
Leave a comment: