Vintage Draft 2 Spreadsheet

[DMT]

Update:

I've added a sheet in the workbook to keep track of the Knockouts (see "KO" tab). I've also created a formula so that a player will be listed as "KO'd" in the hit_car and pit_car sheets. The KO sheet shows the player, eligible positions and eligible decades. This will allow you to see if a player selected for KO still has eligibility in a restricted decade.

Cool, but how did we input a KO into the spreadsheet? I tried pasting the player ID into the KO sheet but that didn't work.

ETA: Ok, never mind, it works after you enter the pick number on the KO sheet.

[Long John]

Re-post in case you aren't reading the Commentary thread. And if you aren't, why are you VDing?

SS is updated through 11.13.

I've also made a couple of updates.
-The hit_seas and pit_seas sheets now show players that have been KO'd, but will not show them as KO'd for years that are not eligible.
-The dash sheet shows the number of KOs each drafter has made so far. (I put it at the bottom.)

If you are updating this version on your own, copy and paste the drafter in the "KO'd by" column. This will allow the count in the dash sheet to continue to be accurate. I'm sure there's a lookup formula of some kind to automatically generate the pick and drafter, but I'm not that savvy enough in Excel to figure that out.

[johnnya24]

Is the "POS" sheet on the SS working 100%?

My line says I have 0 catchers when I actually have both slots filled.

[Controller Jacobs]

Is the "POS" sheet on the SS working 100%?

My line says I have 0 catchers when I actually have both slots filled.

Note: this may not apply to you, as I'm working with an earlier version, but...

In my version I have to manually set how the hitters apply within each person's list. You get a red flag for any incomplete list. It's pretty easy to fill them out.

[johnnya24]

Note: this may not apply to you, as I'm working with an earlier version, but...

In my version I have to manually set how the hitters apply within each person's list. You get a red flag for any incomplete list. It's pretty easy to fill them out.

I normally keep the teams filled in on my own SS, but I've been too busy this time. I really don't know how a lot of the Zsheet normally works. The individual table with my team positions is correct, but to collated league table is incorrect. I'll probably get around to manually inputting the teams at some point.

[SeaDogStat]

Yes, you always have to input the positions for each team on that tab

[Long John]

I update the "pos" tab once a round. It's updated through my 13.07 pick.

[Riff Raff]

Hi guys,

I just got a chance to check in now, after 11pm. Pretty tired and no energy to update my sheets properly.

I'll endeavour to get the picks up in the morning, but, if you don't see a pick by 10am EST just skip me. Hate to do it ... I don't want to hold up the draft.

Long John - if by chance you update the spreadsheet again to include all the picks since the last update this will save me a few minutes. No worries if not. I love that you are sharing the updated sheet so much. It takes time to update my sheet and I really appreciate getting to DL a new version @ the turn each round. Thank you.

[mjl]

LJ: if you want the #H and #P columns on the career standings pages to be correct, you can just replace whatever's there with =$dec.R3 etc.

[Long John]

They appear to be correct to me already. Did I miss something?

[mjl]

hm. maybe it's a problem with OpenOffice? For me the #H column is always equal to the number of drafted players and the #P column is 0.