*** VD 10 Commentary Thread ***

[Long John]

Here's a temp sheet that I'm using to track VD 10. Feel free to use among yourselves. It's a VD9 sheet conversion. The POS tab has not been updated yet, but I'll be tackling that shortly.

https://dl.dropboxusercontent.com/u/68883317/VD10-Scoring-Sheet%20Temp.xlsx

Decades sheet is wrong too. Fixing those formulas as well.

[johnnya24]

Here's the V10 test sheet.

If someone could look at the verification formula on the Rounds page. I can't seem to make it work, and changes aren't having expected outcomes. So maybe there is something else going on that I'm not getting.

This is not the finished sheet. It still needs the career numbers updated (then any contemporary players will need to manually updated as they are selected). Maybe we get that tonight. Won't take long to finalize once I get the data.

.VD 10 (TEST) DOCUMENT

Done

- All the modification for Decades made
- BY data updated and sorted for years up to 2014. All eligible 2010's years are included for batting and pitching.
- Snapshot page updated (don't think we need a matrix thingy ... that was only useful for Decades and Letters)

To Do

- Updated Career data
- Fix verification formula on Rounds page

[heyelander]

Cripes, now we have to do your job for you?

[heyelander]

It's depressing going right before Johnny and after seeing he's made a pick, thinking well, let me go see who I should have taken

[johnnya24]

It's depressing going right before Johnny and after seeing he's made a pick, thinking well, let me go see who I should have taken

I almost picked Dimaggio last time, then you picked him right away. Was looking at him and Greenberg ... hoped one might make it back.

[Long John]

Here's the V10 test sheet.

- Fix verification formula on Rounds page

The reference to the Standings sheet is wrong. It should reference column AC. This is the formula I have from the VD2 sheet.

=COUNTA(C2:AC2)-stand!AC2+IF(MAX(dec!C3:P3)>1,5,0)+IF(MAX(dec!C21: P21)>1,7,0)

[Long John]

Since I've already done the work, here's each formula:

=COUNTA(C2:AC2)-stand!AC2+IF(MAX(dec!C3:Q3)>1,5,0)+IF(MAX(dec!C21: Q21)>1,7,0)
=COUNTA(C5:AC5)-stand!AC3+IF(MAX(dec!C4:Q4)>1,5,0)+IF(MAX(dec!C22: Q22)>1,7,0)
=COUNTA(C8:AC8)-stand!AC4+IF(MAX(dec!C5:Q5)>1,5,0)+IF(MAX(dec!C23: Q23)>1,7,0)
=COUNTA(C11:AC11)-stand!AC5+IF(MAX(dec!C6:Q6)>1,5,0)+IF(MAX(dec!C24: Q24)>1,7,0)
=COUNTA(C14:AC14)-stand!AC6+IF(MAX(dec!C7:Q7)>1,5,0)+IF(MAX(dec!C25: Q25)>1,7,0)
=COUNTA(C17:AC17)-stand!AC7+IF(MAX(dec!C8:Q8)>1,5,0)+IF(MAX(dec!C26: Q26)>1,7,0)
=COUNTA(C20:AC20)-stand!AC8+IF(MAX(dec!C9:Q9)>1,5,0)+IF(MAX(dec!C27: Q27)>1,7,0)
=COUNTA(C23:AC23)-stand!AC9+IF(MAX(dec!C10:Q10)>1,5,0)+IF(MAX(dec!C2 8:Q28)>1,7,0)
=COUNTA(C26:AC26)-stand!AC10+IF(MAX(dec!C11:Q11)>1,5,0)+IF(MAX(dec!C 29:Q29)>1,7,0)
=COUNTA(C29:AC29)-stand!AC11+IF(MAX(dec!C12:Q12)>1,5,0)+IF(MAX(dec!C 30:Q30)>1,7,0)
=COUNTA(C32:AC32)-stand!AC12+IF(MAX(dec!C13:Q13)>1,5,0)+IF(MAX(dec!C 31:Q31)>1,7,0)
=COUNTA(C35:AC35)-stand!AC13+IF(MAX(dec!C14:Q14)>1,5,0)+IF(MAX(dec!C 32:Q32)>1,7,0)

[johnnya24]

Great thx ... somehow, no matter how many times I looked at that, I didn't register that it was calling the Standings sheet

[Long John]

I was a huge Vlad Guerrero fan when he was playing. His BY and Career numbers don't normally justify me being able to take him any VD so far.

[The Feral Slasher]

Great thx ... somehow, no matter how many times I looked at that, I didn't register that it was calling the Standings sheet

Uuugggh. Cant seem to download and open in excel. Any idea why ? anyone ?

[johnnya24]

Uuugggh. Cant seem to download and open in excel. Any idea why ? anyone ?

This is the direct link Dropbox is giving me

https://www.dropbox.com/s/12bnb20kvlxxcf7/VD10%20%28TEST%29.xlsx?dl=0

Are you trying to open it from my PC rather than downloading it to your PC?

[The Feral Slasher]

This is the direct link Dropbox is giving me

https://www.dropbox.com/s/12bnb20kvl...T%29.xlsx?dl=0

just figured it out. Needed to download instead of "save as"

[johnnya24]

just figured it out. Needed to download instead of "save as"

It's not the finished article ... still needs the career stats updated from VD9.

LJ fixed the Rounds formula.

Now, hoping that mjl can use some wizardry to update the Career stats without losing the Position and Decade sections.

[johnnya24]

Now, hoping that mjl can use some wizardry to update the Career stats without losing the Position and Decade sections.

I think I've figured something out ...

[johnnya24]

Note to self - don't sort a 22K row sheet with about 30K cell calls to other sheets.