Ultimate Fantasy Football Strategy – 2009 Ultimate Draft Tool

2009 Ultimate Draft Tool

Buy the Ultimate Draft Tool for only $10!

Download the Ultimate Draft Tool
Works with any version of Microsoft Excel from 97 to 2007. Does not work with Macs.

Download the unprotected version : If you are unable to edit cells for any version you can download this version. Be very careful however because you could experience problems if you change any cells that are not in green.

Once you buy the Ultimate Draft Tool, we will send you an e-mail with your password to access the file within 24 hours (generally much faster). The player rankings and average draft position rankings will be updated about once a week. All you have to do is download the program before your draft to get the most up do date version.

August 24, 2009: Added Trades and fixed a bug in the algorithm that suggests picks.


The Ultimate Draft Tool is a very unique program which tells you who we believe you should pick in your fantasy draft. It adjusts itself based on your league settings, position settings, drafting tendencies, the players that other teams have picked and evidently the players you have selected. It is basically a tool which puts our player rankings and strategy articles all together.


-Buy the Ultimate Draft Tool

Download the Ultimate Draft Tool.

-Open the file you downloaded and enter the password which we sent you by e-mail.

-Enable macros in Excel.
For Excel 97-2003: On the Tools menu, point to Macro, and then click Security. Set the security level to Low or Medium.
For Excel 2007: On the Developer tab, in the Code group, click Macro Security. In the Macro Settings category, under Macro Settings, click the option that you want. If the Developer tab is not displayed, click the Microsoft Office Button, click Excel Options, and then in the Popular category, under Top options for working with Excel, click Show Developer tab in the Ribbon.

Adjust the League Settings, Ultimate FF Strategy Rankings Percentage, Draft Tendencies and Position Settings.

-Click “Generate Draft”

-Change Team Names (if you wish) and click “Update Team Names”. If you click “Generate Draft” after you have updated the team names, they will reset to the default names.

-Select a player from the dropdown menu

-Click “Draft Player”

Note: You may also use the search box to help you find a player name. If you enter “johnson” and click “Find”, you will see Chris Johnson’s name appear. If you click one more time you will see Andre Johnson and then Calvin Johnson and so on. This is very useful later in drafts instead of scrolling through the list to find all the players.

-When it is your turn to draft you will see a list of five suggested players.
Adjustable Settings

Number of Teams: 8 to 16

Draft Type: Serpentine or Third Round Reversed (3RR)

Number of Rounds: Up to 25 for a 12-Team League

Scoring System: 4 or 6 pts per TD pass and 0 or 1 Point per Reception. The rest of the scoring system is based on the WCOFF but slight variations such as 3 pts per TD pass should not reduce the effectiveness of this tool.

Ultimate FF Strategy Rankings Percentage: From 0% to 100%. The higher the number the more you trust us and the more you will reach for players that we like. We generally recommend between 40% and 60% to have the best success. This setting can be adjusted during the draft but not when it is your turn to pick.

Draft Tendencies: If you have been in the same league for a few years you know whether QBs, RBs, WRs and TEs generally get drafted earlier or later than in the average draft. This will impact the draft strategy in this tool. This setting can be adjusted during the draft but not when it is your turn to pick.

Position Settings: The number of players that your league starts and the number that you’re allowed to draft at each of these positions: QB, RB, WR, TE, PK, Def and Flex.

How will the Ultimate Draft Tool help you?

The Ultimate Draft Tool will suggest five players from best to worst for each one of your draft picks. It will suggest players based on a number of factors which include:

-Our 2009 Player Projections

-Our Average Draft Position Analysis which looks at historical data and determines when there is good value at each position.

-Our Strategies for Drafting Depth which tells you when and where you should draft depth

-Your league’s scoring system.

-The risk factor of the players you have selected so far based on our rankings and average draft position. For example if you draft two high risk starting running backs in the second and third rounds, you will be much more likely to select another running back in the fourth round or / and to select more depth at the running back position.

-The players that should be available when your next pick comes up. For example, if you are selecting at the end of the second round and the beginning of the third round, you are very likely to select a running back with one of those picks because there will be a lot less talent left at the running back position at the end of the fourth round.

Will the Ultimate Draft Tool make me win my league?

Obviously there’s no sure thing in fantasy football but if you enjoy our articles and believe in our strategies then this is definitely the tool for you. We are using this tool for our expert drafts and our rapid draft leagues because we strongly believe that it works. It keeps track of a number of statistics and factors that are generally very hard or impossible to keep track of when you have little time to make your selection.


This tool unfortunately has a few limitations for now. These features may or may not be added this year depending on the demand for them. This tool does not include individual defensive players, does not allow you to use your own player projections does not work for leagues with very different scoring systems and does not work in keeper leagues where your keepers replace a draft pick.

Draft Example

Click here to see the results of a draft we conducted using the Ultimate Draft Tool. This draft was done on Rapid Draft and it was done entirely using the Ultimate Draft Tool.

Note: The algorithm for the final few rounds of the draft has been adjusted slightly since we did this draft.

If you have any questions about this tool or suggestions to improve it, please e-mail me at phil@ultimateffstrategy.com