Jump to content



Photo

Draft Buddy Problem?


  • Please log in to reply
5 replies to this topic

#1 bob_pendleton

bob_pendleton

    FF Rookie

  • Members
  • 8 posts

Posted 06 September 2018 - 01:12 PM

Hi Mike,

 

   I used the "pre-2007" version of Draft Buddy during my draft last night and I ran into a problem.  Fortunately the issue is easy to re-create:  A large number of players, when drafted via the pull-down menus on the "draft report" tab (primarily what I use) or via the "Draft Player" button on the "summary" tab did not have their names automatically grayed-out on the "offense" and "off-notes" tabs once drafted. NOTE:  I had no issues with the grayed-out function working on the "overall" tab.  Here's a subset of names that didn't work.  I can provide a full list from my draft if you need it:

 

Aaron Rodgers
David Johnson
Le'Veon Bell
Julio Jones
Stefon Diggs
Russell Wilson
Ben Roethlisberger

 

  Is there something I can do to fix this? Thank you.



#2 Mike MacGregor

Mike MacGregor

    FF Geek

  • Admin
  • 6,613 posts

Posted 06 September 2018 - 01:30 PM

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.



#3 bob_pendleton

bob_pendleton

    FF Rookie

  • Members
  • 8 posts

Posted 06 September 2018 - 01:36 PM

Calculation is definitely set to Automatic.  Even so, I tried pressing F10 during the draft to see if that would help.  Sadly it did not.  Note that the grey-out functionality worked for some players on the "offense" and "off-notes" tabs and 100% of the grey-out functionality worked on the "overall" tab. 

 

I just downloaded a fresh copy of "draft_buddy_football_2018_1.0.xls" and even without any of my league settings, the problem is easy to recreate.



#4 bob_pendleton

bob_pendleton

    FF Rookie

  • Members
  • 8 posts

Posted 06 September 2018 - 03:12 PM

I think it has something to do with an error in the Conditional Formatting on this year's Draft Buddy (pre-2007, that is).  When I look at past years, it looks like each cell on the "offense" and "off-notes" tabs have a 3-part Conditional Formatting setting -- one of those conditions handles the case where the player's name is right above the red-dashed Tier line.  That third condition seems to be missing from this year's spreadsheet.



#5 bob_pendleton

bob_pendleton

    FF Rookie

  • Members
  • 8 posts

Posted 07 September 2018 - 09:12 AM

Quick update:  I'm fairly certain I've confirmed it's a problem with the conditional formatting in the "offense" and "off-notes" worksheets of this year's pre-2007 version of Draft Buddy (aka, draft_buddy_football_2018_1.0.xls).  When I perform a format-only copy of the corresponding worksheets from last year's draft buddy to this year's, the problem goes away.  I'm just not sure if that might break something else?  But at least I've narrowed the problem down.



#6 Mike MacGregor

Mike MacGregor

    FF Geek

  • Admin
  • 6,613 posts

Posted 09 September 2018 - 05:56 AM

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.