Frequently Asked Questions
A: It seems that Excel 2013 won’t run some macros on protected sheets. Unprotect both the workbook and worksheet on the “Step 2 – Player Rankings” worksheet. Review tab > Changes group > Unprotect Sheet button. (Be sure to make a backup copy for yourself, beforehand.) Then, click the “Rank Players” button on the “Step 1 – Input Sheet” worksheet.
A: The stats are updated three times per week, in August. Try clicking the Rank Players button. That will sort the VBD player rankings again.
Also, your Draftomatic is programmed to update the hidden stat worksheets automatically, when you open the Draftomatic. If that’s not happening, try clicking the Refresh All button under the Data tab. (Your PC may have disabled the Refresh feature, while not recognizing the Draftomatic as a safe program. Silly PC.)
A: Yes. The Fantasy Football Draftomatic uses statistical projections for this coming 2014 NFL season. These projections are updated regularly.
A: Yes. The Fantasy Football Draftomatic is extremely flexible. You can create as many different player rankings as you want. Simply, change the inputs on the Input Sheet and click the Rank Players button again.
A: Yes. Simply, enter the number of points per reception in the Receptions field on the Input Sheet. For non-PPR leagues, just leave the value at zero. Super easy!
A: It’s even easier than before! Customize up to five different flex positions, by clicking the check boxes. Enter the number of those flex positions. And you’re done!
A: No. The Fantasy Football Draftomatic is a different type of Excel spreadsheet from the books’. It uses projections and Value Based Drafting, instead of past statistics. The Fantasy Football Draftomatic is designed for those who are short on time or not interested in learning more Excel skills.
A: The Free NFL Stats are actual statistics from past performances of players. The Fantasy Football Draftomatic projections are forecasted performance statistics, by multiple sports analysts of well-known sports websites.
A: No. The current version of the Fantasy Football Draftomatic works only for core positions: QB, RB, WR, TE. These positions have the most predictable stats, and typically score the bulk of fantasy points.
Yet, you can still use the Draftomatic for your all-important early and mid draft picks. DEF, K, and IDP’s are usually drafted late and dropped anyway.
A: In Excel, under the Review tab, click Unprotect Sheet. There is no password. Please keep a backup copy of the original Fantasy Football Draftomatic for yourself, just in case you accidentally save changes that you don’t want.
A: Actually, you can. The Rank Players button uses a macro that automatically sorts the player rankings for you. Next to the Security Warning, click Enable Content. (For Excel 2007, click Options. Then click Enable this Content.) This enables the spreadsheet’s macro. (Don’t worry. I’m not in the business of spreading macro viruses to my customers. That’s just bad business.)
If you want to manually sort the tables instead, then click the Unprotect Sheet button under the Review tab. There is no password. You are then free to sort the table manually, but also at risk of screwing up the spreadsheet. Please make a backup copy of the Draftomatic!
A: No. The Fantasy Football Draftomatic does not have a bonus point feature.
However, the bonus point feature can be built into the spreadsheet described in my books.
In addition to the steps in the books, use a nested IF statement for each bonus point tier. Below is a video link that explains how to create nested IF statements. Use NFL stats, instead of dollars as used in the video.
As you can see, this is pretty complicated stuff.
A: Although Schedule Impact (SI) is not meant to be directly integrated with the Excel cheat sheet, it works well as a tie-breaker for non-stud players. If you have a tie between players in the Blend column, then use SI to break the tie. Non-stud players on teams within the top three SI ratings might be worth moving to the top of their tier. As always, use your qualitative judgment in addition to MS Excel’s output.
Send John an email: