Macca’s Bye Planner – Rd11

Written by Schwarzwalder on June 1 2017

OK SC coaches, you asked and we now deliver!! Please find enclosed TWO VERSIONS of the bye planner with current player data as of round 10.

The versions allow you to choose the calculator for “GUNS” based on either:

·         a dollar ($) value qualifier (for example, $450,000 for a DEF) or;

·         the current average qualifier (for example, 90+ for a DEF)

You choose which file you want!! (Files Planner Tab should also print on A4 if you like)

PLANNER TAB

  • The key tab
  • Choose now whether each of your players are likely to play or are just an emergency loophole (for example, Strandica) in COLUMN G – this will update the real numbers you have available each week
  • Shows 2017 starting data and data as of round 10 with updated prices, average, 3 round average and BE’s.
  • 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)

 

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

  • You should begin by loading your current team at the end of round 9, before any trades, in Column B of PLANNER TAB
  • in cell H46 enter your CURRENT team value (should be same as value showing in cell H44)
  • in cell H47 enter your available cash in the bank
  • Go Back and make your planned trades of players in COLUMN B
  • Check cell H49 to determine if you have sufficient cash to make those trades – POP UP MESSAGES WILL APPEAR AND THE CELL IN F49 WILL CHANGE COLOUR IF GOOD OR BAD

Happy Bye Planning all and good luck over the coming rounds!!

Macca

SCT 2017 AFL Bye Planner – Rnd 11 – Guns = $$

SCT 2017 AFL Bye Planner – Rnd 11 – Guns=Avg

6
0


Leave a comment / Scroll to bottom

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

Leave a Reply

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