Open the Cheatsheet Compiler & Draft Buddy and click to the "1.Note that, in general, cells highlighted yellow throughout the CC/DB are intended to be changed by the user. Follow the first tabs in order, numbered 1 to 5 and as described below, to complete the steps to create your custom cheatsheets. This section outlines the steps to create custom cheatsheets for your fantasy football league. Once these cheatsheets are prepared, then you will be ready to use the features to track your draft. Generally, your first steps will be to create custom cheatsheets for your league. The reason for this is because each were separate files in prior years, but starting in 2011, both are combined into a single file called, Cheatsheet Compiler & Draft Buddy. This first part is sometimes referred to as the Cheatsheet Compiler and the second part is sometimes referred to as Draft Buddy. The second main function of the program is the draft tracker, keeping track of your fantasy draft or auction as it occurs by marking players drafted off the cheatsheets and updating various schedules with the draft results. The first creates custom player rankings (cheatsheets) based on your fantasy football league rules, league scoring, current year player projections and prior year player statistics. There are two main functions of the Cheatsheet Compiler & Draft Buddy. You should now be prompted to enable macros.Close the Compiler & Draft Buddy, then re-open it.In Excel, choose Tools > Macro > Security.If you are not prompted to enable macros, then it likely means your Excel macro security setting is set at high, which automatically disables macros. Macros must be enabled for the CC/DB to work properly. When you open the Compiler & Draft Buddy, you should be prompted by Excel to enable macros. The Cheatsheet Compiler & Draft Buddy each require that macros be enabled to work properly.Įxcel 2002: Versions prior to Excel 2007 look like this
From Excel, select Office Button > Open or File > Open (older Excel) and browse to the folder where you saved the CC/DB.
The CC/DB is not compatible with Mac Office 2008. Each of the download files are unzipped and work equally on Windows and Mac computers. Download one of the available files depending on your version of Microsoft Excel.