Macca’s UPDATED Bye Planner

Those players include:

• Hayes
• Dixon
• Joyce
• Cox
• Lienert
• Lynch
• Strnadica

SCT 2022 AFL Bye Planner – AVERAGE = Gun

SCT 2022 AFL Bye Planner – DOLLAR$ = Gun

Here at the SCT Community we aim to provide you with as much information and data as possible to aid your SC tilt, for overall or league glory.  Bye planning is important in doing well in this challenging game. Good team management will allow you to make up ground, or fall away, if you manage your numbers badly! Consider those players you start with, and those you want to bring in, carefully. Consider when you bring your guns in. It’s a delicate balance of points now and less points on some bye rounds … so choose & plan carefully! You must also factor in injuries, trades left to end of year and DPP coverage … oh & that pesky little thing COVID … easy huh?

That said, please find enclosed the SCT Bye Planner for the start of the season, with player information current from the Official SC site as of 4/3/2022.

Two versions of the planner are supplied. Choose your “Gun Qualifier” based on Price (eg to be counted as a Gun defender, your value is over $450K) or on Average (defender = 90+) and so on … it’s up to you which one you choose!!

‘Qualifiers’ currently set to:

Def = $450,000 or 90+

Mid = $525,000 or 110+

Ruc = $525,000 or 110+

Fwd = $450,000 or 90+

AND … YOU GET TO SET YOUR OWN ‘QUALIFIER’ AMOUNT!! (see, we aim to please!)

In Column O and cells 13, 26, 31 and 51 – you can set your own amounts and simply choose which dollar or average, from the drop-down list, you would like your premos to ‘qualify’ at … easy as that!

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 Ben King!). – SEE COLUMN I ON THE “PLANNER TAB”

The price / budget calculator shown in Cells J46 to J49 of the PLANNER TAB will let you know if you can afford your starting line-up.

HINT – use the planner to make all your team changes BEFORE playing on the actual SC site!! Saves inadvertent locking in your changes when not ready in round 1 and the last-minute players not listed!! Trades are gold remember! Save versions of this file and plan a few for different scenarios!!

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.

PLANNER TAB

• The key tab
• Choose whether each of your players are likely to play or are just an emergency loophole (think Ben KIng!) in COLUMN I – this will update the real numbers you have available each week
• Shows 2022 starting data and final 2021 data for players.
• Simply choose the players you want in each position in each of the cells in Column B (choose from the drop-down list in each cell, listed in alpha order, on surname)
• Make sure you 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!

 PLAYER DATA TAB

• This is a key tab with the data of all players. Filters are included on each column to allow you to search on each column – you can search by position or club to start with – BUT, there’s more for you this year – read on!!

• Averages for the last six (6) years are included along with the total key stats (total, games and average) for players in 2018 to 2021!! – is your player improving?
• ​​​​​​​​​Rookies are shaded in yellow.
• Club Change – players that have changed clubs in the off season also have their club shaded blue. (also see the separate tab for full list). Will this improve or hinder their scoring?

​DON’T DELETE OR ALTER ANY OF THE DATA ON ANY OF THE TABS AS IT IS USED TO MAKE THE WHOLE FILE WORK!!

SEASON DRAW TAB

• The full draw is included on this tab and just for your added bonus, I have also included a grid to help you determine the best club to run a non-playing player to take advantage of the C / VC loop to the byes!
• Anyone for a Hawk – by far the team playing most games last in first 10 rounds!?? There’s a little bit more to it, but I’m not going to do all your work for you!

 

ADDITIONAL TABS

• For your ease, note that tabs are included listing all players in each position (D, M, R and F) and all rookies listed on their own tab – filters included on each tab.
• A separate tab is also included for those players changing clubs with their new and old clubs
• Even better! – a new tab also included indicating the position changes of players – when combined with club changes, does this make your player a better or worse option??
• But wait! There’s usually more – also a tab normally available indicating players that are making a return – from injury or other lay-off – I haven’t had time to do these this year – but many have been talked about!
• Hopefully, when you combine all of these colour coded players, it may help you find that gem or breakout player you are looking for – well, at least based on stats eh?
• Spare a thought also, as we play this great game, for those players no longer listed – retired or not currently making a side, after being listed in 2020. They are usually included on their own tab as well … but again I haven’t had the time – it is interesting to note the number of players that were rookies last year that haven’t made it … it’s a tough life to make it in footy!
• There are 25 club changes, 192 rookies listed, and positional changes totalled 209!

So, get to it! Leave a comment on the thread as well for any thoughts or ideas and discussions – we love those!

• Choose your players in Column B of the PLANNER TAB
• Check cell J49 to determine if you have sufficient cash for your choices – POP UP MESSAGES WILL APPEAR AND THE CELL WILL CHANGE COLOUR IF GOOD OR BAD
• Check all the tabs for any data that you think will help your SC year!

Happy Bye Planning all and good luck for the year!!

Macca

 

---

Leave a comment / Scroll to bottom