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.

Updating More Than One Set of Projections in Draft Buddy

Today marked another fantasy baseball projections update, including both sets of projections we have available for Draft Buddy and the Last Player Picked Price Guide. Those are the Steamer-Fangraphs projections, from Steamer Projections Blog plus playing time adjustments from Fangraphs, and the Zeile consensus projections from FantasyPros.

The update also included our depth charts and average draft position (ADP) data from each of FantasyPros, Mock Draft Central and National Fantasy Baseball Championship. Make sure to support each of the above mentioned websites, or drop them a thank you, for helping power Draft Buddy and LPP for your fantasy baseball drafts this season.

One of our Draft Buddy users sent me an email asking how to update both sets of projections in the software. I realize the Draft Buddy instructions need an overhaul since I combined the old Cheatsheet Compiler and Draft Buddy into one file, but that is a job that is going to have to wait until next year. For now, I’ll respond to emails and write the occasional blog post to answer key questions like this one.

caption

Fantasy Baseball Draft Buddy, action tab

When it comes to updating projections in Draft Buddy, everything happens on the aptly named action tab. Buddy only updates one set of projections at a time, based on the “Source:” drop-down, and if you read the information boxes that pop-up, you’ll know the new projections you are grabbing overwrite the projections in the Site A (or first) section on each of the hitters data and pitchers data tabs.

So, the process to update both steps is essentially update one, move it to Site B, and update the second. Here is the detail:

  1. Select one of the two available projections with the drop-down on the action tab. Click the Update Projections button.

  2. After the projections update you can click No to not Compile Cheatsheets.
  3. Now click the Move Site A to Site B button (or Site C, if you prefer).
  4. Use the drop-down to select the other set of projections. Hit Update Projections again.
  5. This time you want to hit Compile Cheatsheets so your cheatsheets are updated for the latest projections.

If you only plan to use one set of projections to generate your cheatsheets, then there is no need to update both sets. If you do the update, and then later change the allocation key or mix or projections in Site A, B, and possibly C, then you need to hit Compile Cheatsheets again to see the impact of the change.

That is it for now. Good luck in your fantasy baseball drafts!

How To Transfer Last Player Picked Dollar Values To Draft Buddy

I’m not sure why I didn’t think of posting this earlier, but once I resurrected the Last Player Picked Price Guide, then people were naturally going to wonder how to get the LPP dollar values into Draft Buddy. Makes perfect sense.

It would help if I had some video screencast software, and time to do a video (they take longer than you think!), but for now I’ll type the steps. There is more than one way to do this. Here is one way I believe is efficient:

  1. Go to Last Player Picked, input your settings and process your player values. On the results page click the League Info tab for the link to download a comma-separated value (CSV) file of the results. Download that file.

  2. Open Draft Buddy. Open the CSV file from LPP. The CSV should open automatically in Excel.
     
  3. In the CSV file, right-click on the tab name and select the Move or Copy option. We want to move (or copy) the LPP results as a new tab in Draft Buddy. It shouldn’t matter where you put the results in Draft Buddy. I selected the end to get it out of the way.
     
  4. Now we want to create what is called a named range of the LPP results. The player names should be in column E, and the dollar values in column K. Highlight all cells from E2 over to column K, and down to the last player in the list. Then select Insert > Name > Define and type in a name, something like “lpp_lookup”. Click Add. Click OK.
     
  5. Now we are going to create VLOOKUP formulas to pull the dollar values from the lpp_lookup named range and put them on the cheatsheets in Draft Buddy. Where we put those formulas depend if you have an auction league, or draft pick style league.
     

    Auction leagues:

    1. Go to the overall tab, scroll to the far right of the cheatsheet and highlight any cell in the last column plus two cells to the right and select Format > Column > Unhide. Numerous columns should appear.
       
    2. Scroll further to the right to find the long list of players including some yellow highlighted boxes that include dollar values from Draft Buddy. In the first yellow highlighted cell (AN8), input this formula:
       
      =IF(ISNA(VLOOKUP(AF8,lpp_lookup,7,0)),AuctionMinBid,
      ROUND(VLOOKUP(AF8,lpp_lookup,7,0),1))

      Make the formula all together as one line with no line break.

    3. The dollar value for that first player in the list should match the dollar value from LPP. Copy that cell, and paste it all the way down the entire list. Since this is an auction league, the dollar values on the cheatsheets use formulas that reference from this list, so at this point all three cheatsheets should all update for LPP values.
       
    4. You can optionally copy the entire list of dollar values and Edit > Paste Special > As Values to remove the formulas and keep the new values. You can also optionally hide the once hidden columns again to clean up the tab.
       

    Draft pick style leagues:

    1. We put a very similar formula directly on the cheatsheets in the dollar column. Start on hitters, first basemen, and select cell G8. Input this formula:
       
      =IF(ISNA(VLOOKUP(E8,lpp_lookup,7,0)),AuctionMinBid,
      ROUND(VLOOKUP(E8,lpp_lookup,7,0),1))

      Make the formula all together as one line with no line break.

    2. Copy the formula, and . . . this is important . . . highlight the rest of the dollar value cells for 1B and choose Edit > Paste Special > Formulas. This prevents the formatting getting messed up.
       
    3. Now do the same for each other position, plus pitchers and the overall tab. Copy the first cell where you input the formula, highlight the ranges for other positions, and use Edit > Paste Special > Formulas. As you do each one you should see the dollar values update.
       
    4. Once you have the formula on all parts of the cheatsheets where it is supposed to be, optionally highlight each cheat sheet, one at a time, copy and then in the exact same spot use Edit > Paste Special > As Values (to remove the formulas).
       
  6. Okay, now in both cases there is a good chance the cheatsheets are out of order, so we need to select sections of the cheatsheet and re-order them. I wouldn’t include the Rank and Tier columns, because you will just have to put those numbers back, but highlight everything for say, 1B, from the player names to ADP, select Data > Sort and sort by Dollar.
     
  7. Repeat the last step for each position on hitters, pitchers and each of the three main sections on the overall cheatsheet.
     
  8. Since starting pitchers and overall rankings span across columns, they may still be slightly out of order from, say, the bottom of first main section (players ranked 1-82) and the top of the section main section (players ranked 83-164). To fix this, I would simply re-number the Rank and Tier numbers as appropriate, and click the re-rank buttons.

I think that should do it. Now your Last Player Picked values are in Draft Buddy, so you are ready to track your draft. Remember, if you hit Compile Cheatsheets again, then you will need to repeat these steps to replace the newly calculated values from the compile function.

If there are any questions, then post them below. Cheers.