Nix Bye Planner for R9

Greetings Coaches,

Here is updated Bye Planner for R9.  If you are reading this I presume you know how important bye planning is.  Not much change this week as it is a short week.  New features are:

• Player’s scoring history is included to the right of tables,
• Positions for players are updated to include recent changes by AFLFantasy.

Team Tables

Below is an updated table ranking various teams based on how many points per game they have scored or conceded on average up to round 8.

 

Essendon, Hawthorn and Port have scored most points and hundreds.  Brisbane, St.Kilda and West Coast have conceded the most points and hundreds.

The next table uses this information to see who has the best draw during the bye period.  The percentage indicates whether they are playing a team likely to concede more or less points than the average team.  The column on far right forecasts the number of extra hundreds (or less hundreds).

 

Western Bulldogs are playing a string of teams likely to concede the most points. However most of these come from playing Brisbane in R12, so no point rushing to trade in doggies before their bye this week.

Collingwood players should be your trade targets after their Bye.  North Melbourne players should be looked at to fill Bye holes for R9 as they are playing the generous Brisbane.

Search Tab

I have a new ‘Search‘ tab with a searchable table so it is easier to find players to trade in.

For example if you want to find the best forward line players who do not have a bye this week (R9) you can easily produce a list like this example from last week (you should be able to right click on this image and open in a new tab to see it better).

In the new tab there is a link at the top right of the table that explains how you manipulate the table.  But briefly –

• Filter the position column so it only shows records that “contain” “For”  – i.e. for forward line players.
• Filter the Round 9 column so it only shows records that “equal” “P” – i.e. player might play in R9.
• Then sort the the table however you want – e.g. select average column and sort so players with highest average are at the top.

The columns are right are Prices and BEs for Real DreamTeam.  I don’t play RDT and I haven’t checked the numbers. But I had them so I thought I would put them in as well for RDTers.  If they are wrong let me know and I will remove them.

 

Here is link to latest Bye Planner file

Bye Planner for R9

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

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

If you find any issues please make comments below or tweet to me @NixTrader.

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

 

How to use it:

• Download 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. There are lots of lookup formulas in this file so other software 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.