FAQ and Contact

Frequently Asked Questions

Q: The “Player Rankings” button won’t work on Excel 2013. What can I do?

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.

Q: My Draftomatic stats don’t seem to be updating. What can I do?

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

Q:  Does the Fantasy Football Draftomatic use NFL projections for this coming season?

A:  Yes.  The Fantasy Football Draftomatic uses statistical projections for this coming 2014 NFL season.  These projections are updated regularly.

Q:  Can we use the Fantasy Football Draftomatic with multiple leagues and varying fantasy point schemes?

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.

Q:  Does the Fantasy Football Draftomatic work for Points Per Reception (PPR) leagues?

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!

Q:  How do I handle flex positions in the Fantasy Football Draftomatic?

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!

Fantasy Football, Microsoft Excel, spreadsheet, Flex Position

Q: Do the Excel for Fantasy Football books and the Fantasy Football Draftomatic use the same method for ranking players?

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.

Q:  What is the difference between the Free NFL Stats and the projections in the Fantasy Football Draftomatic?

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.

Q: Will the Fantasy Football Draftomatic work for DEF, K or IDP’s?

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.

Q: How do I unlock the Fantasy Football Draftomatic, so I can modify it?

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.

Q:  Why can’t I manually sort the Fantasy Football Draftomatic tables?

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!

Q: Can I apply performance bonus points with the Fantasy Football 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.

Nested IF Statements Video

As you can see, this is pretty complicated stuff.

Q:  How do I apply Schedule Impact for RB’s and QB’s to the cheat-sheet in Excel for Fantasy Football?

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.

Contact

Send John an email:

4 responses to “FAQ and Contact

  1. My league gives bonuses for big performances by core positions:
    QB:300yds=15pts, 350yds=20, 400yds=25;
    RB/WR/TE: 100yds=15pts, 150yds=20pts, 200yds=25.

    How do I customize bonuses to the Value Based Draftomatic?

    • Hi, Reggie.

      The Value Based 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. For your purposes, use NFL stats, instead of dollars as used in the video.

      http://youtu.be/QMlaTBRUJPs

      As you can see, this is pretty complicated stuff.

      I do hope this helps, or at least points you in the right direction.

  2. Last year the Draftomatic gave separate sheets for each position, this year only the master sheet. Did I do something different or did you remove that?

    • Hi, Jamie.

      Thank you for your purchase!

      This year, I have the stat worksheets hidden.

      Press Ctrl + Shift + A, to Unhide the worksheets. Please be careful though. Changes to those sheets can corrupt the Draftomatic.

      Good luck and have a great season!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s