Mike MacGregor

Bob, thanks for the work on this. I will take a look at that .xls version more closely. I did run into a problem this year with my new Windows computer (which I was way overdue for). The new Windows computer ran old Excel, but the copy of Draft Buddy had problems for people who used that version... this is way back near the start of June So I scrapped it and created a new file from the old Windows computer, which was still kicking around. All appeared to be good with that one, and I didn't hear of any real issues with it until you presented me with this one. There was little reason for some of the conditional formatting to be missing, since I still started with last year's version, but the conditional formatting can be very finicky and just "disappear" at times. Sorry for the trouble you had with this.

There is no direct way (good idea), but I've added rosters successfully to the one local league I commish two different ways: 1. Start a live draft and as commissioner go in and make all the picks. Sorting players by ADP, this really didn't take me too long. Probably 10 minutes. The thing I like about this option is it keeps the draft history. 2. Haven't done this one in a few years since I like option 1, but there used to be a spot in the commish setup to import rosters by picking a team and inputting player names into a large text box. You could do that by copying the names from the rosters tab, one team at a time, and pasting them in the box and submitting. Might be one or two not recognizable (team D, rookies perhaps), which you then adjust and try again or select and add later.

Check that calculation is set to Automatic, Bob. Old Excel... lets see... I think it is Tools > Options > Calculation, select Automatic. Did that update it? Or try F10 (on Windows) to force calculation. If they are greying out on one tab they really should on the others.

Final* Update! Projection changes: Dropped: RB Jerick McKinnon, WR Martavis Bryant, WR Brehsad Perriman, WR Braxton Miller, K Dan Bailey, K Eddie Pineiro Added: TE Antonio Gates, QB Chad Kelly, Nathan Peterman, K Matt Baher UP: Lamar Miller, Stefon Diggs, Jordy Nelson, Bruce Ellington, Jordan Cook DOWN: AJ McCarron, D.J. Moore, Adam Shaheen, Ed Dickson * of course if anything else major happens between now and Thursday, we will do another unscheduled update

Final* Update! Projection changes: Dropped: RB Jerick McKinnon, WR Martavis Bryant, WR Brehsad Perriman, WR Braxton Miller, K Dan Bailey, K Eddie Pineiro Added: TE Antonio Gates, QB Chad Kelly, Nathan Peterman, K Matt Baher UP: Lamar Miller, Stefon Diggs, Jordy Nelson, Bruce Ellington, Jordan Cook DOWN: AJ McCarron, D.J. Moore, Adam Shaheen, Ed Dickson * of course if anything else major happens between now and Thursday, we will do another unscheduled update

Not good Jerick McKinnon news: http://fftoday.com/news/index.php?Item=12620 Update is ready. McKinnon way down, Breida up and Morris up, but don't go too crazy drafting Breida and Morris. Draft Buddy action tab > Update Projections. Good luck to those drafting tonight!

Not good Jerick McKinnon news: http://fftoday.com/news/index.php?Item=12620 Update is ready. McKinnon way down, Breida up and Morris up, but don't go too crazy drafting Breida and Morris. Draft Buddy action tab > Update Projections. Good luck to those drafting tonight!

Hi Pat. So I am clear, do you want to change a player's ranking on the cheatsheet, or his ADP? The ADP comes from the adp tab. Oh I get what you are saying due to it being a keeper league. Sorry, there isn't really a way to adjust for that. Interesting idea though. I think in a case like this you just need to not think too much about the number value of the ADP (i.e. DJ s/b 1.03 as opposed to 1.04, since Zeke is not available), but rather consider the order of the players based on ADP. Who is available and what is the order of those players from lowest to highest based on ADP. That will still give you a good sense of when a player should get drafted, 1, 5, 10, 15, 20, 30 picks from now.

Hi lostsoulny. There is a way (check keepers cost a draft pick on the rules tab, hit Compile to update, and an extra column shows up on the keepers tab), but ... it essentially copies each player to the draft report tab, so I am in favor of just putting the kept players right on the draft report tab. Make sure to change your reset options for keepers and draft picks to "no" before hitting Compile Cheatsheets again.

8/30 update is ready! Update highlights... Alshon Jeffery down, TE Dallas Goedert up Sammy Watkins down, Chris Hogan up Slight bumps for Bilal Powell, James White and Peyton Barber Slight bump down for Carson Wentz Now I have to go schedule some more online drafts ... and then later kick myself because of so much in-season management time from being in too many leagues

8/30 update is ready! Update highlights... Alshon Jeffery down, TE Dallas Goedert up Sammy Watkins down, Chris Hogan up Slight bumps for Bilal Powell, James White and Peyton Barber Slight bump down for Carson Wentz Now I have to go schedule some more online drafts ... and then later kick myself because of so much in-season management time from being in too many leagues

Hi TAM. Sorry to hear you are having trouble. I don't usually knee jerk to this but would you mind trying to download a fresh copy and before you even change any settings try to Compile Cheatsheets. This seems familiar to someone else who downloaded and the macros got removed on them. I'm hoping the same issue here and a re-download fixes it. Also if you download again you shouldn't need to update projections, as it will already have the latest update.

Awesome Bob, thanks!

Since Fantasy Sharks provides their projections in Excel, this should be pretty straight forward - using Projection Pal. Download Pal and try these steps: 1. Download the Excel file with Fantasy Sharks projections. It is a csv file. 2. Open that file in Excel. Copy all of the projections and then you are going to paste them into the Pal file on the QB Raw tab, between the grey highlighted cells. 3. Then change the headings... the only ones that really matter are "LastName, FirstName" for the player name, and "Custom 1" under sacked projections. 4. At the top make sure to check that you want to transfer custom fields. And then click Copy to Draft Buddy. ... did those projections copy into the QB tab in Draft Buddy under the Custom 1 field? Assuming yes, carry on: 5. Go to the custom scoring tab and for QB scoring box beside Custom 1 and under the heading FF Pts, put in the points deducted for a sack, -1. Do not change anything under the heading Ranking. 6. Now hit Compile Cheatsheets and you should see the projected fantasy points now reflect the sacks against. All good? Any questions?

Hi Bob. Sure, that would be a good category to use the custom scoring feature for. My first question however is do you have projections for sacks allowed? We would need to get those projections into Draft Buddy. Let me know what you've got and what format it is in, and then we will go from there.