2014 Bye Planner

byeplanner

The Bye Planner spreadsheet is available.  Consider this a Beta test version.

It will be updated later this week after all Round 6 scores are in.  So come back to this article for an updated version.  I will also add to the article with more information.

If you find any issues please make comments below or tweet to me @NixTrader.  I haven’t done much testing so there will probably be some bugs.

Many thanks to Matt @neilsatis for giving me his typed up AFL Fixture that this spreadsheet uses.

The Bye Planner is is an MS Excel 2007 spreadsheet.  It will run on recent versions of MS Excel installed on a Windows PC.

Here is link to file

Bye Planner R6

 

The Bye Planner is for AFL Fantasy, but it will work for Real Dream Team as they use the same scoring (I think).  Supercoaches might find it slightly useful to keep track of byes but all the scoring will be wrong.

How to use it:

  • Downloaded the file and save it to your hard drive.  Then open the file in MS Excel 2007 or later.
  • Make changes in the Green cells to put in your own players.
  • In the Bye rounds section – use the green drop down box to adjust for players who are not available.
  • Make notes in the bottom section about your strategy for the bye rounds – who you will trade in or out and what impact that will have on your scores.
  • You can copy all the green section blocks to the updated file, so you will not have to start again in an updated version.

 

Technical Notes:

  • This is not an app.  There will never be an app for any platform.
  • This file will not run on iPad or any other tablets.
  • Many apps or pieces of software that claim to open Excel files do not support all the Excel formulas including lookup formulas – so they probably will not fully support this file.
  • Even MS online excel on OneDrive (cloud) may not support all the formulas.
  • There will not be a Supercoach version.

 

@NixTrader

 

18 Comments

  • *wonders if this is your side*

    looks pretty handy, but typed in Daisy (instead of Dale) and wondered why it didn’t work

    • When you download … no it won’t have my side in it – my full side is too embarrassing. A few players will be mine but then I swap a few others just to check it’s working.

      Also you shouldn’t have to type in anything. Put your mouse to the right of the names and you should get a little down arrow – click on this and it will bring up a drop down menu list with all the players in that position. Scroll down and click the player you want – that way no spelling mistakes.

      • the scrolling through takes forever, plus if you accidentally click/drag mouse outside area you gotta start that scrolling again. I’d prefer typing tbh, mine just doesn’t seem to accept and input other than scroll and click.

        Also whats with all the three letter entries in the names?

        • Grab the slider and drag it till you get close, then scroll to finalise your choice. The slider is fast.

          The names shortened to 3 letters are not eligible for that position – for example Ablett will show up as abl in the Defender section. This makes it easier to just pick the eligible defenders as they are the only full names on the list. I had a version that blanked out the ineligible names completely but that made it too hard to keep track of the alphabet while you were sliding through list.

  • Great work Nix. Very Helpfull

  • Excellent work Nix
    Very handy to see I am in trouble first week
    Anyway you can make changes on your team in second sheet each week on expected trades?

    • Glad you like it.

      You just type in what you want to do in the green section at the bottom of the 3 bye rounds.

      But in the update I might add a watchlist section underneath that so coaches can keep track of players they are hoping to trade in during the bye period.

  • Cheers Nix, it has been very helpful

  • Is it really that hard for fantasy or RDT to show some sort of overlay of
    bye rounds.
    Bye planning is an essential part of the game and it’s a pain in arse
    doing it in either form of the game.

  • This is really helpful thanks. I know this isnt a supercoach site but do you know of a bye planner for supercoach. Cheers.

    • Sorry, I don’t know of a bye planner for supercoach. I don’t even know how supercoach handles the bye scoring. Suggest you try tooserious.

  • …and why the fk should I have to pay for an integral part of a game which is in essence a marketing tool to increase the interest (read revenue)for all games in a given round…..double dip anyone.
    …seems like everyone’s a self promoting marketing “tool” these days.
    hashtag#fuckoff

    • Well I’m providing a free tool for bye planning. Nobody is paying me for it. And the DTTalk website is hosting it for free.

      If you want to grumble perhaps you should do it in a thread where someone is asking you to pay for something, or take your issue to AFLFantasy and RDT.

  • this will be very helpful, cheers nix!

  • Thanks Nix, paid for assist coach and have tracked byes since it was available. However this is so much easier, currently 20, 21, 19. Am a real big fan of yours, especially appreciated Nix traders last year. I do my own excel spreadsheets and know the time needed to upkeep them,thanks for doing this for free mate.