Jump to content

Mike MacGregor

Admin
  • Content Count

    5,964
  • 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 Excellent

About 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

Recent Profile Visitors

68,367 profile views
  1. Mike MacGregor

    Projection pal QB Clean formula error

    Hi big D. The FantasyPros projections have a small problem. They include the player's team in the same table cell as the player's name, so you need to do some data cleaning to get that out of there before the data will properly transfer to the Clean tab. Do you see that? Where it used to have "Josh Allen" on the Raw tab it is now "Josh Allen BUF". You can kind of see on the QB Raw tab how I cleaned the data in some of those columns to the right of the projections. First, copy the names and paste them to the right of the data (you can use the same columns I used before). Then highlight all of those names and split the data by space using Data > Text To Columns > Delimited > Space. Now combine the first + last names using a simple formula like "=N11&" "&O11" and copy, paste special it back to the original names on the left side. Clean tab look better now?
  2. Mike MacGregor

    Draft Buddy: Version 2.0, Projections Updated: 8/14

    Welcome back everyone. 25 years! That's crazy.
  3. Mike MacGregor

    Draft Buddy: Version 2.0, Projections Updated: 8/14

    Welcome back everyone. 25 years! That's crazy.
  4. Thought I could post an image. 79-998-8 with 3, 100-yard receiving games
  5. Hi SJ. We did just update in the last hour, do you think maybe you got one from last Thursday just before we published the one this morning? Or I wonder if it is a timezone difference thing? Hmm... A good way to tell is this... check the projections from FF Today for Rashee Rice, since that is one of the players that FFT Mike changed in this update. You should see a "U" under the change column, and these projections on the WR tab: https://ibb.co/q9K9DnX
  6. Mike MacGregor

    Deleted Players

    If you deleted them off those tabs, then yes, they will come back. I would do this: Zero out the projections for the players. Don't change their projections, because an update will replace your change, but instead do this: Go to the position tab and unhide the columns hidden by the first "+" sign near the top of the tab. Then change the allocation key for the players you want to zero out. Use one that is 0% for all sites (like #13) and you'll see right away the projected fantasy points go to zero. Once you've done all players, hit Compile Cheatsheets. Image: https://ibb.co/mcxYHp7
  7. Mike MacGregor

    Projection Pal assistance

    In terms of others, try to look for ones with a CSV download. That tends to be easier than the web query, because you can open the CSV in Excel and then copy/paste them into the position-Raw tabs. FantasySharks used to have a CSV download. I haven't checked that in a bit. 4for4.com has that, but it is subscriber only.
  8. Mike MacGregor

    Projection Pal assistance

    Hi Cretins. I have just the video for you. The issue with FantasyPros projections is they jam the player name and team together in one field. So when you update those projections, the names no longer match. Check out this video:
  9. Mike MacGregor

    Draft Buddy: 2024 Version 2.0

    Giddy up
  10. Mike MacGregor

    Auction League Drafting

    Howie! I checked your league. I love the rule about resetting all keepers if a team wins back-to-back championships and had a keeper finish Top 2 at their position. I picture guys with bad keepers cheering for a potential back-to-back winner, and guys with good keepers cheering against. lol Okay, I started getting Draft Buddy set up for your league to test it out. Problem: your auction is not set yet. We might not be able to test very well anyway with no results. However, I found another league from another customer that uses the auction sync with MFL. Here are the pages that Draft Buddy imports for them, including keepers: https://www.draftbuddy.com/football/3rdparty/mfl/keepers.php?MFL=42618&o=1 https://www.draftbuddy.com/football/3rdparty/mfl/auction_results.php?MFL=42618&o=1 (auction results - players, and it does include the winning bidder teams) https://www.draftbuddy.com/football/3rdparty/mfl/auction_results.php?MFL=42618&o=1&v=2 (auction results - winning bids) So based on this I feel good it will work for your auction. Make sure your rules are set up properly, Compile Cheatsheets. Set the owners (you can also pull that with the sync by using the link on the sync tab) but make sure to put them in the right nomination order. Check your auction report tab that it is correct order and long enough. Then the sync should work once the keepers are input and auction is set up. Let me know if you have any questions or run into any issues.
  11. Mike MacGregor

    Auction League Drafting

    Hi Howie. Sorry we missed this earlier. I'm supposed to get email updates when people post on the forum! Did you already have your auction? What is the league site? I haven't used the auction sync in some time and so few people do, it is hard to test. I'd like to check out your league, but yes, I believe everything you are asking does pull in the team and winning bid value.
  12. Mike MacGregor

    FIX: Run-time Error 1004 When Trying to Update Projections

    Pleased to say we made some progress with this. New video:
  13. Mike MacGregor

    Draft Buddy Help Videos

    Started created some new Draft Buddy how to videos posted to YouTube. These are more about the information than the video production quality! Listed here, I will put each one in its own post. Feel free to ask questions. 1. Quick start, rules and scoring setup 2. MyFantasyLeague.com integration, franchise names and draft results 3. Update projections (plus adp, depth) and compile cheatsheets
×