First of all. This is one of the most interesting articles I have read. Many Thanks to all the contributors and to the creators. I am working on taking this to the next level.
Rob Z I will need your help on this if you have some time!
I have taken the FBG VBD spreadsheet and built a ZVBD spreadsheet on top of it. So the way it works, is that the FBG VBD spreadsheet is used to predict scoring and overall fantasy points. Once run, the ZVBD spreadsheet is opened. The starting positions and flex values are automatically pulled from the ZVBD spreadsheet and prepopulated along with the VBD fantasy point values.
As the user, you are required to enter the following items:
* Draft Position
* If Flex available, identify which positions can be flexed (For Survivor drafts, you can flex QB, PK, D)
* Round Number
* Estimated Projections for League by Round (I only have 16 rounds to date)
During the draft, you must do the following items:
* Mark on the draft sheet which player is taken (Easy, just put a character in the field)
* Update baseline projections (This is more difficult, I am in the process of working this out to be automatic based on the estimated projections given at the beginning.... Statistical analysis here is a good thing)
* Identify which position you have drafted
* Click the [Value] Button
A little time consuming, but takes about 30 seconds to do. When the button is clicked, the spreadsheet performs all the baseline calculations based on the round and gives you the best value position. It DOES account for all of the items Rob has mentioned in his article.
Currently, I am in the process of validating calculations and tweaking it. Hopefully, it'll pan out. I did one mock Survivor draft and here was the results:
1.11: Ahman Green
2.02: M. Harrison
3.11: S. Mack
4.02: J. Garcia
5.11: A. Thomas
6.02: C. Conway
7.11: M. Alstott
8.02: Eagles-D
9.11: J. Thrash
10.02: D. Jolley
11.11: J. Fiedler
12.02: Kevin Johnson
13.11: J. Kitna
14.02: R. Longwell
15.11: J. Chandler
16.02: Jets - D
Scoring:
Passing:
1pt / 25 yards
4pt / TD
2pt / 2 pnt conv
-2pt / Int
Rushing:
1pt / 10 yards
6pt / TD
2pt / 2 pnt conv
-2pt / Fumble Receiving:
1pt / 10 yards
6pt / TD
2pt / 2 pnt conv
-2pt / Fumble Kicking:
1pt / XP
3pt / FG Defenses:
1pt / Sack
2pt / INT
2pt / Fumble Recovery
4pt / Safety
6pt/ TD
I was very surprised by some of the value at the positions... Mainly at taking S. Mack in the 3rd round. In this first example I did not update the baseline "guesstimated" positions for the draft. I am making tweaks based on this draft and I will test again on my next draft. In addition, I will post the results after the draft for review. I should be drafting again on Thursday night to try this out.
Sorry for the long post, but I think it's been some interesting discovers into the world of ZVBD.