

Mike MacGregor
Admin-
Content Count
5,892 -
Joined
-
Last visited
-
Days Won
1
Mike MacGregor last won the day on August 9 2015
Mike MacGregor had the most liked content!
Community Reputation
20 ExcellentAbout Mike MacGregor
-
Rank
FF Geek
- Birthday 10/11/1972
Contact Methods
-
Website URL
https://www.draftbuddy.com
Profile Information
-
Gender
Male
-
Location
Barrie, Ontario, Canada
-
Interests
playing soccer, fantasy football, comic books, sports pools
-
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.
-
Is there a way to use Draft Buddy to upload League on an MFL site
Mike MacGregor replied to LunaTick's topic in Draft Buddy
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.
-
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in FFToday Board
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 -
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in Draft Buddy
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 -
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in FFToday Board
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! -
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in Draft Buddy
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! -
Updating ADP after Keepers are entered
Mike MacGregor replied to PatMcGroin88's topic in Draft Buddy
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. -
Setting Keepers that cost a specific draft pick
Mike MacGregor replied to lostsoulny's topic in Draft Buddy
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. -
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in FFToday Board
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 -
Draft Buddy 2018 - Post-Cut Down Day Updated Projections + Depth Charts
Mike MacGregor replied to Mike FF Today's topic in Draft Buddy
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.
-
Another Draft Buddy custom scoring question
Mike MacGregor replied to bob_pendleton's topic in Draft Buddy
Awesome Bob, thanks! -
Another Draft Buddy custom scoring question
Mike MacGregor replied to bob_pendleton's topic in Draft Buddy
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? -
Another Draft Buddy custom scoring question
Mike MacGregor replied to bob_pendleton's topic in Draft Buddy
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.