Macca’s Bye Planner – Rd7

Written by Schwarzwalder on May 2 2017

(Written & Organised by Macca)

Hi SCT Community! Please find enclosed the updated bye planner after the first six (6) rounds. Those using the previous planner will note that there is now a row for each position totaling possible “GUNS” in each of the bye weeks. 

There is a small price / budget calculator shown in Cells G46 to G49 of the PLANNER TAB that will let you know if you can afford any player changes for trades going into week seven only. The bye planner though will continue to work each week showing how many players you have available over each of the bye rounds.
 
The workbook has four (4) tabs as follows:
 
PLANNER TAB
·         The key tab
·         Shows 2017 starting data and data as of round 6 with updated prices, average, 3 round average and BE’s.
·         Bye rounds are shown in columns N to R
·         The rows shaded black under each of the positions (D, M, R, F) will indicate how many players ARE available, in each position, each bye week. *AND now how many GUNS available*
·         Total players available for your team are shown in Rows 42 & 43, columns N to R and the cells will change colour depending how many players you have available each week (colour legend shown below them!)
·         Pictorial view of teams on the byes in Columns S to X
·         Simply choose the players you want in each position in each of the cells in Column B (choose from the drop down menu in each cell by alpha order on surname)  
 
BYES-DRAW & SEASON DRAW TABS
·         Separate tabs are included to show the byes draw and the full season draw if this helps your planning …
 
PLAYER DATA TAB
·         This is a key tab with the data of all players and filters are included on each column to allow you to search on each position or club or games played (eg 2 played on the bubble) and so on, 
·         BE’s as of round 6 are included for that all important trade decision and negative BE’s are shown in red
  • ​​             ​​​​​​​Total points scored and games played now also included, thanks to Nath!
​DON’T DELETE OR ALTER ANY OF THE DATA ON ANY OF THE TABS AS IT IS USED TO MAKE THE WHOLE FILE WORK!!
 
For ROUND 7 only (this week) – (cash calculator on PLANNER TAB)  
  • You should begin by loading your current team at the end of round 6, before any trades, in Column B of PLANNER TAB
  • in cell G46 enter your CURRENT team value (should be same as value showing in cell G44)
  • in cell G47 enter your available cash in the bank
  • Go Back and make your planned trades of players in COLUMN B
  • Check cell G49 to determine if you have sufficient cash to make those trades – POP UP MESSAGES WILL APPEAR AND THE CELL IN G49 WILL CHANGE COLOUR IF GOOD OR BAD

Hope that is worthwhile gents! The last step will only work for this round obviously, as the player values would have to be updated each week. However, for right now, with some key trades about to happen, that may impact on byes, this gives everyone an up to date look! 
 
Cheers 
Macca

 

SCT 2017 AFL Bye Planner – Rnd7

 

** Thanks for all your help, Macca!  Legend! – Schwarzwalder **

 

11
0


Leave a comment / Scroll to bottom

4 thoughts on “Macca’s Bye Planner – Rd7”

  1. Much appreciated for this.

    Going to be my 1st year seriously having a crack at top spot.

    How many do we aim for for each bye round?

    2

    0
  2. I’m not sure what a “good number of guns” playing each round would be, but you would want as good an 18 playing each bye round as possible.

    I think if you have 13 guns each bye round you should be going well?
    3 in def
    5 -6 in mids
    1 ruck
    3 fwd

    What’s everyone else think???

    0

    2

Leave a Reply

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