Macca’s Bye Planner Rd13 2019

Written by Schwarzwalder on June 11 2019

(Written & Created By Macca)

HANDS UP IF YOU DIDN’T USE THIS RESOURCE AND PLAN FOR THE FIRST BYE??

 

Bit of a nightmare first bye round for some, and it just goes to show that no matter how well you plan, you just can’t help bad luck (or coaches known as Furl!!)

 

This is the last planner for the year, and I must start out by saying a HUGE thankyou to a member of our community, by the name of Angus, who pointed out that I had stuffed up the GUN QUALIFIER NUMBER COUNT.

It wasn’t picking up and adjusting the number of GUNS available, if one of your guns was out (eg Hurn) and giving the wrong number of guns. In my haste I had left out the calculation for the “omitted” category on the guns line.

 

All fixed now, thanks to Angus!! – How good is our community eh??

 

Two versions of the planner are supplied again, 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!

 

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 13 only (this week) – (cash calculator on PLANNER TAB)  

You should begin by loading your current team at the end of round 12, 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

 

UTILISE the various tabs with all the current player data to make your best decisions. Search on the specific position tabs, or by club or by BE etc – make use of this resource, particularly if you don’t buy SC Gold! Also, plan your moves on this file before locking them in on the actual SC site!

 

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!

 

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 two weeks – save different versions with each of your planned trades (after this week though, prices won’t be current)

Don’t panic if the numbers look bad on any 1 week – there is still half the season to go!

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!

 

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

 

REMEMBERuse 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!

 

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

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

SCT 2019 AFL Bye Planner – Rnd13 – Avg equals Gun

 

Macca

8
0


Leave a comment / Scroll to bottom

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

  1. Thank you very much for such a valuable and essential resource to navigate the minefields called bye rounds. Much appreciated. Top stuff Macca.

    7

    0
  2. This is a great tool…unfortunately it cant help with Hurn, whit and yeo all missing r12 🙁 Did trade whit to williams however.
    I’ve mentioned this in a few posts…nearly over it !!! I’m looking for big wins in rds 13/14 now.

    2

    0

Leave a Reply

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