Tag Archives: cheatsheet compiler

S h a r e :

Draft Buddy Update and Optional Projection Pal Available

Use Projection Pal to add alternate sets of projections to your copy of Draft Buddy. Download a copy of Pal pre-loaded with projections from draftbuddy.com.

Use Projection Pal to add alternate sets of projections to your copy of Draft Buddy. Download a copy of Pal pre-loaded with projections from draftbuddy.com.

Today there is a full projections, depth chart and ADP update available for the fantasy football version of Draft Buddy, our custom cheatsheet and draft tracking software.

If you want to mark these on your calendar, the remaining regularly scheduled updates are July 9, 16, 23, 30, August 6, 13, 20, September 3 and 8. Generally, once a week on Thursdays so Draft Buddy is up to date for you prior to the weekend’s prime drafting times.

The above noted updates are projections from FF Today, included in Draft Buddy by default. Today I also uploaded a copy of Projection Pal to our member download page including the official DraftBuddy.com projections (updated today), so you can add them to your copy of Draft Buddy as a second set of projections. To add them and make them the primary projections for your cheatsheets, follow these steps:

  • Download Projection Pal, the one that includes the Draft Buddy projections, and open it in Excel.
  • Open your copy of Draft Buddy in Excel.
  • On the setup tab in Pal, check that the filename matches the filename for your copy of Draft Buddy. It should unless you changed it. Everyone should be using version 1.2!
  • In Pal, go to the QB Raw tab, press the Copy to Compiler button, and wait for Pal to copy over the projections to Buddy. Repeat for each of the RB Raw, WR Raw and TE Raw tabs.
  • In Buddy, go to the options tab and change the default allocation key to 100% Site B.
  • Go to the action tab and click Compile Cheatsheets.

Use the Average Projections / Allocations Keys box to change the percentage of each set of projections reflected in the cheatsheets, if desired.

Use the Average Projections / Allocations Keys box to change the percentage of each set of projections reflected in the cheatsheets, if desired.

Now the cheatsheets reflect the new set of projections. You can use the Average Projections / Allocations Keys box to change the percentage of each set of projections reflected in the cheatsheets, if desired. Just remember each time you change anything on rules, scoring, options, or projections (anything that would cause the cheatsheets to change), then you need to click Compile Cheatsheets again to see the impact of that change.

Since we don’t have projections for kickers, defense or IDP, then you may wish to simply stick with projections from FF Today for each of those. You can change the default allocation key in Draft Buddy by position. To do that, go to each of the position tabs (QB, RB, etc.) and find the two “+” signs near the top of each tab. Click the first plus sign to open up some hidden columns. You’ll notice at the top the allocation key for the tab, which you can change by inputting a different number (from the options tab box), or you can change the key by player in the yellow highlighted column.

Fire away in the comments if you have any questions. Thanks!

S h a r e :

Download 2013 Fantasy Football Draft Buddy For Free

While I’ve been keeping busy maintaining our fantasy baseball stats database, and also turning my attention to the upcoming fantasy football season, I haven’t had much time to properly update instructions, videos, screenshots for our bread and butter product, Draft Buddy.

Draft Buddy, in case you weren’t aware, is the all-in-one custom player ranking cheatsheet creator and draft (or auction) tracking tool. It is in Microsoft Excel. There is a fantasy baseball version which is available for free and a fantasy football version that helps pay the bills.

Draft Buddy works for redraft, keeper or dynasty leagues. You can customize a ton of possible scoring systems. For baseball you can choose roto or fantasy points scoring. It includes stats for all players for the past three years, plus last half of the prior year. It includes projections for the current year, depth charts and average draft position data, and these are updated regularly from initial release in the early spring training or preseason through to Opening Day or opening kickoff.

These are some tricked out spreadsheets. They are older than my kids, which is saying something now that Megan . . . well, anything I say about my eldest daughter she would surely be embarrassed about, so yes, she’s “that old”.

Draft Buddy has gone through a lot of changes over the years, including a name change. You’ll still see some references to Cheatsheet Compiler, the first half of the old combined CC & DB name. The videos give some insight into how Draft Buddy works, but if they aren’t keeping up with the changes, then I need to make new videos. Given the lack of time, as mentioned, I wanted to come up with another way for people to try out the Fantasy Football Draft Buddy.

How about a free trial?

Perfect. And I’m not going to create a separate stripped down version of Draft Buddy, but rather I will make the 2013 Fantasy Football Draft Buddy available to download. To get it, you just need to login or register (for free) and subscribe to the football version. Heck, and get the baseball version too if you missed out this year and want to check it out.

It has last year’s projections in it of course, and player stats from 2010-2012 NFL seasons. If you have any questions then feel free to post a comment here or shoot me an email. I am travelling a fair bit over the next couple weeks, but I will respond to every comment or email as soon as possible.

I hope you like it, and decide to give it a try for the now fast approaching, 2014 NFL season. Cheers.

S h a r e :

Position Eligibility for Miguel Cabrera

Here is a question received from Ken using the fantasy baseball Cheatsheet Compiler & Draft Buddy:

Mike,

Thanks for the great tools. One quick question. My league’s positional eligibility is based solely on games played previous year. As such, Miguel Cabrera should not qualify at 1B.

Is there a set-up that I am missing that is causing him to appear on the 1B cheatsheet? I have the position eligibility set to 20 games. If not, is there a means to manually remove him from the first base list, while keeping him on the 3B list?

Thanks,
Ken

And my answer in response to that question:

Hi Ken. Thanks! The reason he pops out at 1B is because he is on the depth charts (in my database) at 1B. Surely once he plays a minimum number of games at 1B then you can start him there this season, no?

Anyway, you can make an adjustment to prevent him from showing at 1B. Go to the hitters tab and under Position for him, change from 1B to 3B. Hit Compile Cheatsheets and it should remove him from 1B, since he doesn’t have position eligibility there based on number of games played last year. Each time you update, you’ll have to make that change.

Maybe I can create some kind of option to only choose positions based on games played prior year, not both games played and projected position this year.

Cheers,

Mike