Macca’s Bye Planner Rd12 2019

Written by Schwarzwalder on June 4 2019

(Written & Created By Macca)

THE BYES ARE HERE! THE BYES ARE HERE!! – Is it too late? Should you panic? Are you well placed / planned?


We’ll get back to those questions shortly, and to aid your deliberations and team structure / planning, the latest version of the BYE PLANNER with updated prices, averages, BE’s, total scores etc is now provided, as of the end of round 11!



Two versions of the planner are supplied again, and …. And again … SET YOUR OWN AVERAGE OR PLAYER VALUE!! That’s right – in column O, in cells 13, 26, 31 & 41 you can now set your own average value or player value (choose from the drop-down list) to determine your own gun qualifier for the bye period!! – Have a play – you know you want to! Defaults are currently in there as per the following:

Qualifiers currently set to:

Def = $450,000 or 90+

Mid = $525,000 or 105+

Ruc = $500,000 or 100+

Fwd = $450,000 or 90+


Make sure you nominate any players in your squad that you do not believe will play in any rounds, including the byes, to get a more accurate total of available numbers (think Bines!). – SEE COLUMN I ON THE “PLANNER TAB”


For ROUND 12 only (this week) – (cash calculator on PLANNER TAB)  

You should begin by loading your current team at the end of round 11, before any trades, in Column B of PLANNER TAB

in cell J46 enter your CURRENT team value (should be same as value showing in cell J44)

in cell J47 enter your available cash in the bank

Go Back and make your planned trades of players in COLUMN B

Check cell J49 to determine if you have sufficient cash to make those trades – POP UP MESSAGES WILL APPEAR AND THE CELL IN J49 WILL CHANGE COLOUR IF GOOD OR BAD


OK, for most of you, you’ve seen / used the previous versions, so no need to go into it further … just utilise the sheets and enclosed tabs with all the data to make your best decisions. Instead, here are some thoughts on the Byes and what to look out for:


On the Planner

I cannot stress enough to make sure you nominate any players in your squad that may not play / aren’t playing – column I is your friend!! (Bines, Constable, maybe Young and Hore – if they aren’t playing, exclude them!)

Columns R to U and Rows 50-54 – the warning box of too many players on the field in any line. This is important to check on! In the example team, in round 12 the numbers are less than they appear as there are 7 in defence and 3 rucks

Thus instead of 21 players, this team only has 19!! And maybe questions over Hore and any of the Blues rookies playing!! Be careful!!

Make use of DPPs! – in this team, if Constable somehow does play, then you need to swap Setterfield with say Worpel to make use of your numbers – always check this too!!


Further Thoughts:

Don’t make any trades until you see the teams this round (as normal – DUH!!)

Use these planners to plan out your moves for each of the next three weeks – save different versions with each of your planned trades (after this week though, prices won’t be current – unless I can get time to update each week)

Think carefully about any trades you make – no point trading a player in for this week, if it makes your next week(s) numbers worse (factor in the trades of any players coming in after this bye)

If you can, numbers on field permitting, any trades this week should try to free up cash – there are a plethora of very relevant Guns available next week after their byes (Fyfe, Ryan, Macrae, Dunkley, Boak, Rocky?, Sicily, Zerrett etc – so you would ideally like to be bringing in two of these guns after this week – cash is king!!)

Don’t panic if the numbers look bad on any 1 week – make the other two weeks as strong as possible to cover a lower scoring bye week, if that is where you are today –

don’t panic trade in bad choices just to get 18 on the field if that player won’t play more games / generate cash later.

DPP players are great! Hold someone like Setterfield as long as you can (even if he loses a little cash), as he allows you to move players around and has the last Bye!


In summary:

check your possible players (Columns Q to U & rows 12, 25,30 & 40) and “Guns” (rows 13, 26, 31 & 41) for each of the bye rounds

Check total possible numbers in rows 42 and 43 and watch for the cells colour change depending on numbers!

Check also the warning box in rows 50-54, Columns R-U – this lets you know to be careful with your bye numbers in total – you can’t say you have 18 in a round if 10 are in the Mids – only 8 can play!

Use the info on the various tabs to research your players and rookies  


So, get to it! Leave a comment on the thread about your thoughts on the Byes and your plans – generate the discussion!!


HINTuse the planner to make all your team changes BEFORE playing on the actual SC site!! Saves inadvertent locking in your changes when not ready once the round has commenced and the last-minute players not listed!! Trades are gold remember!


The bye planner will continue to work each week showing how many players you have available over each of the bye rounds, though averages and player values etc will only be updated when I get a chance to upload current data.

SCT 2019 AFL Bye Planner – Rnd11 – $dollars equals Gun

SCT 2019 AFL Bye Planner – Rnd11 – Avg equals Gun


Good luck all – hope this resource has helped all year!!




Leave a comment / Scroll to bottom

7 thoughts on “Macca’s Bye Planner Rd12 2019”

  1. Absolutely brilliant that you keep updating this bye planner for us coaches. It really helps us get through the byes.

    Hope it isn’t asking too much but you add an injury planner 😉 It will be great so we can deal with the likes of, Whitfield out till rd15, Hurn likely to miss this week. Crouch and Williams expected to return but you know.
    That would be really help for many of us coaches 😉

    Thanks for all this Macca


    1. Just use column I against his name Nato – select “no”from the drop for if he will play and it will bring them up as “omitted” and exclude them from your count – when they are back, change back to “yes” …


      1. Forgot about that, thanks for the help. Wish you could fix these injuries like the way you make this planner . Then us coaches wouldnt have to deal with these injuries at crazy times


  2. I want to know how you made the bye planner through excel, it is very useful. This looks insanely hard to make !!!


    1. haha thanks Stizz – nah, not too hard … and I have deliberately tried to use more ‘simpler’ excel techniques / options, so that it is easy to use for everyone … there are a lot more complex ways and use of things like macros and pivot tables etc … but trying to keep it a little more easier for most … if I can get creative over the off season, I may try to experiment for something more next year …


  3. Oh scheisser! Just saw Whitfield out now too!!

    Definitely choose him as “no” to play in column I now if you are holding him and not trading him out …

    Bye Planning can be a real biotch!!



Leave a Reply

Your email address will not be published. Required fields are marked *