*** VD 14 Commentary Thread ***

[The Feral Slasher]

Bene has been around since the last pick, but apparently also at church.

Maybe he is torturing himself with indecision

[cavebird]

Bene has been around since the last pick, but apparently also at church.

[The Feral Slasher]

Not following you exactly.

How do the Lahman sheets make it easier?

And as far as static or dynamic what do you mean

Static is what this draft is....

[Ken]

We 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.

Not following you exactly.

How do the Lahman sheets make it easier?

And as far as static or dynamic what do you mean

[johnnya24]

I 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 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.

[Ken]

AND ... 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.

I 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).

[heyelander]

via Imgflip Meme Generator

[johnnya24]

explains a lot? No, I meant the combined pages. I always just added the career stuff to the BY pages

Yeha I always wonder who sees discussions and update posts. I should really start spamming updates combined with PM's so everyone is aware of stuff.

[The Feral Slasher]

Funny, I don't think I ever looked at them, but created them on my own every time.

Yeah, me too. Took quite a while back in VD1 with my poor excel skills

[heyelander]

You never looked at the Snapshot?

explains a lot? No, I meant the combined pages. I always just added the career stuff to the BY pages

[johnnya24]

Funny, I don't think I ever looked at them, but created them on my own every time.

You never looked at the Snapshot?

[heyelander]

The 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.

Funny, I don't think I ever looked at them, but created them on my own every time.

[heyelander]

Downloaded 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?

just D/L it. Merck gave me a nasty warning when I went to dropbox, but I said I didn't care. Will be looking for work again soon.

[cavebird]

Let's walk before we crawl through the fiery pit of hell that will be the decade-letter-franchise draft.

I would think then that letters and franchises would work better than decades and franchises because a lot of decades would become force picks for the shorter-time franchises available then. For example, it might exclude Braves and Cubs from the 1870's because you almost need those franchises from the teens through 60's when there where only 14-15 franchises total. To me, decades a little bit overlaps with franchises.

[johnnya24]

I thought it was going to be franchises, decades, and letters just to be evil.

Let's walk before we crawl through the fiery pit of hell that will be the decade-letter-franchise draft.