2013 Supercoach Team Analysis Tool – THE HIGGINATOR!

Published by Higgo on

It is with great pleasure that I release to you this year’s Supercoach Team Analysis Tool.

This will make the process of fiddling with your team leading up to round 1 infinitely easier and enable you to make more informed decisions when locking in your starting squad.


Given the popularity of the 2012 version (over 10,000 downloads!), very little changes have been made to the 2013 version.

One change you may notice is the introduction of a “Trading Degrees of Freedom” analysis. Given the new substitute trade feature that was introduced last year, the number of degrees of freedom for each line informs you how many players from other lines may be switched across when trading. This feature is a vital game strategy and was used to great affect by last year’s winner. I would expect it to play a most important role for your team when it comes to trading in the ruck this year.


I would welcome any feedback.

Kind regards,

Peter Higginbotham


Notify of
Newest Most Voted
Inline Feedbacks
View all comments

I loved the time and effort you put into last year's spreadsheet and this year is no different. You're a marvel. Now I know it's early doors and I don't want to be to picky BUT….there were a few hiccups I noticed when I loaded my team.You have Ablett as GWS instead of GC. Mundy (Freo) and Jack(Syd) are shown correctly in the team list but don't show up on the right side of the page under the TEAM…NO.PLAYERS list. Also on that list, I have 4 BRL players but it shows as 1 and I have no WCE players but it shows I have 3. The concept of this is brilliant and I love it.
Many thanks. Cheers


Thank you Choppers.

Altering the 2013 bye rounds messed up the team allocation formula – NOW FIXED.

I recall last year we ended up running with a Version 5!

Please enjoy 2013 Version 2.

Paul S

Have just entered my first team into The Higginator! (very excited)
How does this spend look Higgo?
DEF ave. = $265K
MID ave = $389K
RUCK ave.= $282K
FWD ave. = $355K
As you can see I have spent big in the guts and gone skinny in Def/Rucks.
Thanks you old excel wizard – top job yet again!


Interesting spend Paul, particularly in your Rucks … Care to divulge your Ruck1 and R2 selections?
Your cheap spend in defence mimics the recipe that the past two winners have used. Nice One.


Mine was pretty much the same, Paul. With my team resulting in
DEF average: 276K
MID average: 436K
RUCK average: 224K
FWD average: 304K

So it looks like I skimped out more in my forwards and rucks than you did to get my mids. I went a complete gun or rookie approach there. All over $550,000 or under $150,000


First Draft of my team;
DEF – $264K
MID – $360K
RUCK – $284K
FWD – $394K
10 rookies – 10 midpricers – 10 guns
I agree on going cheap in the rucks but I just have to have Sandilands!


Higgo, you marvelous bastard! Only problem is you'll now be cutting into my work productivity since I don't have Excel at home. Good stuff, mate.


Great tool again higgo, if you could develop it for an iPhone ap you’d make millions!!!


It could be something wrong with my work computer, but couple small glitches on the Bye columns shown on the player list. Cameron Pederson (MEL), Jack Viney (MEL), Tom Mitchell (SYD), Mark LeCras (WCE), Tom Lee (STK) all result in the bye week column being blank. I think this is an issue with the team, given players from the same clubs get similar issues. Travis Varcoe (GE) is also giving a #N/A error. All the Bye rounds appear to be counted in the Team Summary though except for Travis Varcoe.

Love your work but.


Thanks Kevin …. Will look into this later today.


Version 3 now …. Varcoe glitch fixed. Bye round tallies appear to be working fine.

Keep the fixes coming.


I think Higgo has fixed the Varcoe glitch …. just used it and it works a treat.
To quote from The Castle Higgo;
"you're an ideas man"
"you could sell that"
Supercoach Gold/Fanplanner ect ….. "tell 'em they're dreamin'!" This is the best team planner out there Higgo.
May it rain Crumpet for you this year my friend.


Long-time reader, first-time poster Higgo… have used this tool in the past and find it to be invaluable. Outstanding work once again πŸ™‚

Only comment would be to check that all fwd (and other postion) rookie players are included in the tool… Judging from the SC site it seems a few extras that were originally missed have been included in an update. i.e. SC site teamplanner shows 6 players @ $96,200 but the tool only has 2? For example, Dwyer, Klaosen omitted.
PS What do you think of my SC team name… 22 and a Half Men (a reference to the substitute and Charlie Sheen… hoping it will be a 'WINNING!!!' team πŸ˜‰ )

Cheers πŸ™‚


Thanks Dan for the info. Re:rookies … Will check this and we may have to release a V.4 ….. Getting close to last year's edits already! As for team name … Never watched that show, Mother has banned it in our home due to the blatant objectification of women. Maybe someone else would be better suited to rate this.


No worries Higgo keep up the good work! There's always gonna be a few things that pop up so it's all good, amazing work to have the tool out in January anyway! All input can only help improve it. I consider myself to be pretty good at Excel but I'm in awe of your efforts.

To quote a Guinness ad in one word… Brilliant!!! πŸ™‚



You're dedication to our legion of fantasy football enthusiasts is simple world class.

When we started up this caper on Tuesday nights at Hungry Jacks all those years ago who would have thought you'd be up leading the community with cutting edge tools like this bloody gem.

On behalf of all of us mate…… I thank you.



thank you, love ur work…supercoach 2013 here i come


Higgo you legend πŸ˜€ I know I say it along but you are a bloody genies – look this tool. One thing I have noticed is it seems you are missing a few players in the forward line from Alex Howson to Xavier Richards in the $96,200 range. Only realised beacuse I was looking to put Sam Dwyer in my forward line.


*along = alot .. woops


I saw this issue too Irish – see my post above πŸ™‚

Hmm wonder what everyone's thoughts are re team planning around the byes… I reckon I worried about it too much last year and ended up spending too many trades, especially after copping injury after injury / suspension. Had Carrazzo, Fyfe, Mumford, Dempsey plus a few others who barely played like Crozier and Sexton… am hoping for more luck from the SC gods this year…


I must be doing something wrong, when I click on players get drop down box with players but when I click on player nothing happens

Supercoach jesus

You need to save it once you open it it will ask if you trust this file click yes then rename file and reopen will work fine then mate


Thanks mate got it working ok now


VERSION 5 now up folks …. Missing Rookies in and a few small bye issues fixed.

Really interested to hear what people are doing with their ruck structures this year.


It's still early days, but I'm looking at Berger,Jenkins (FWD) Daw and McBean(FWD).I also have Roughy (RUC) and Rowe (RUC)in the forwards. There's enough cash left over(238K) to swap Jenkins for a Prem (Goldy perhaps?) if I change my mind or move Roughy to Ruck and bring in another Prem FWD.
Any thoughts?


Wow, this is such a great tool.. will definatley be using this, when the free SC site opens.

Does anyone a full list of 2013 players (spreadsheet if possible)?

Supercoach Jesus

Click over to supercoach Paige mate it on there


Thanks mate


Sorry Higgo, but I've just downloaded v5 and there's still a few glitches that I noticed. In the Player Breakdown, it shows my team as a total of 28 players with only 11 Rookies showing when I have 13 listed. The Prem and Mids are correct. Also on the Number of Players, my list totals 34 with 4 players from GWS when I haven't selected any.
I really like the way you have the players listed by price range instead of alpha or team. It makes it so much easier that way to select players. Cheers


Great Stuff guys, loading all sorts of teams into this great tool, was thinking would it not be useful to allow the TAT to give you a average for the differnt teams you select. Obviuosly could only use last years player averages but this would have to be helpful for picking the best bang for your 10million!

Just a thought



Yes! I can do this. Perhaps just allocate each rookie a 50 ave.
Great idea, thanks.


Great and no probs at all… will save me doing a lot of calcs!

yeah 40 or 50 would be pretty close you would think



Three cheers for higgo

Supercoach Jesus

Cheers mate I made an excel program up weeks that did some of the stuff but no where near as detailed as this thanks heaps


Gday there Supercoach Jesus! Good to have you onboard mate – just saw your account on the Twitter.
Higgo is a gifted man mate… a very gifted man


G'day Higgo
Drafted up a team last night sent $232K in Defence, $474K in Mid, $255K Ruc and 285K on Fwds. 93K left in the Bank 39% team Rookies and 39% Premiums
Rucs are Goldmember and Berger with Curie and Grundy at this stage
Thanks for the speadsheet


this is probably just all my fault but i am having trouble entering my team into it, how exactly do you put your players in? some help would be great, thanks


worked it out yet??


Hamish g'day mate the left hand side of the player name box is a drop down


ok thanks i can get that far but when i click on my players nothing happens are they meant to appear anywhere or something?


Ya they should pop up in the selected box and followed outside the by Team they play for Price and the bye round that player will have.
What are you opening you spreadsheet with mate (What Programme)


yeah ok none of that is happening to me, i am using corel calculate- is this the wrong program?


When you download Higgos tool does it ask you what programme you whant to use? and does it say after wards may have some errors or anything of that nature?


no it doesnt ask me anyrhing and there are no errors. i just click on it after it has finished downloading and it comes straight up in that program, is there another program that i should be using because i should be able to change what i open it with in my settings somewhere?


I opened mine with microsoft word try opening prog. with that Hamish


Sorry Micro soft Ecel


Just downloaded it again Hamish,
You need to save it once you open it it will ask if you trust this file click yes then rename file and reopen will work fine then mate


opened it but no idea how to use it? it won't let me select anything when i click on it……


P.S when i click where it says "click to select a player" there's no drop down menu or anything


doesnt work on Excel 2000, just alot of errors


Hi Jock,

Great tool, thanks. I may have found a bug though – I have built a team of 17 rookies and 13 Prems, but the 'Player Type' breakdown is showing me 13 Prems and only 15 Rookies , for a total of 28 Players. Let me know if you would like a copy of the sheet itself …..

Kind regards



anything for mac?


Hi Higgo,

Great tool. V5 still seems a little buggy. My Xls is saying i have 3 GWS players yet, i actually have none, so there is a tweak that needs to be made somewhere. A couple of players pull through a team value of "0".

What would be amazing is for the tool to also list and pull through the SC averages and tally them up similar to the way the it does for the costs. That way you can sort of estimate the scoring potential of your side, thought i'm sure this is coming once the final list comes from herald sun with the cost vs score average etc. Or maybe you could supply the unlock pw for those who would like to edit the xls themselves? Keep up the good work.


Great tool again Higgo, are you happy to dibvulge the password so I can tinker with it? If not is is possible to get a raw list of the players on the second page so you can make some notes against each as you build your side? Well done fella.


Hi Higgo

Great spread sheet mate, have enjoyed putting my first draft together but thought I'd ask what's the most ideal scenario to have? For eg I have Ablett, Pendles, Watson and Murphy all missing in rd 13, in an ideal world I'd avoid this…but don't we have a new rule this year that we have the best 18 over these 3 rounds? So technically it doesn't matter if you have a few holes you'll still be scored across all 3 byes. Cheers


Awesome tool, you've done a great job! Like a few others have mentioned, mine only says I have 28 players. I'm using Excel 2010 (says 9 rookie, 9 mid & 10 premium). I also have the problem with it saying I have 3 GWS players, even though I have none.

But seriously, awesome tool.

Same Old FC

DEF – Goddard, (MID), Duffield,Reilly, Atley, Terlich, Docherty, Staker (FWD), Van Unen
MID – Ablett, Swan, Shuey, Embley, Ball, Viney, O'Meara, Crouch,
Kavanagh, ,Lonergan,
RUCK – Sandi, Luenberger, Witts, Gorridge
FWD- Franklin, Cox, Zorko, Martin, Varcoe, Broughton, Kerridge, Macaffer

$99k in bank & only interest is League win
Very safe and will rely on midfield rookies generating $ obviously


Hi Guys,
I am a battler when it comes to AFL supercoach but have accepted a challenge to enter a couple of "money leagues" and was wondering if I could out source my team to you guys. I will pay the initial stake and split the proceeds 50/50 when we win.
Let me know your thoughts


Hey Higgo,
Ben Kennedy of Collingwood is listed as a North player…
Bloody nice work on the rest of this, absolute bloody genius you are. Love it.

Current player type breakdown:
Rookie: 43%
Mid-Price: 7%
Premium: 50%


Thanks for the excel sheet. It makes planning for the upcoming byes much easier. I have found one more issue. Mark Blicavs is listed only as a MID only. I have updated my copy to add him as a RUC with his dual position listed for both positions.

FYI, the analysis tool works very well under LibreOffice Calc

You really can make it for your daily work and making
money as much as you want. Companies may choose to end up being
represented by those people who are likely to draw in enormous numbers of new customers, however in reality any kind of advertising and marketing they can
acquire, they are going to use, particularly when it is totally free.
If users have a dedicated workers at your location, they can often
replace the part in only a few minutes and grab the equipment up and running again.

I am genuinely grateful to the owner of this web site who has shared this wonderful article at
at this place.

my web page – Les Gazelles Telecharger Film Complet (http://Lesgazellestelechargerfilmcomplet.Blogspot.Ro)

hair restoration laser

Simply desire to say your article is as astonishing. The
clearness onn your publish is just reat and i can assume you are ann
expert oon this subject. Well with ykur prrmission allow me to
clutch your RSS feed to keep updated with approachinbg post.
Thank you 1,000,000 and please keep up the gratifying work.

Allso visit my web-site: hair restoration laser

So whenever a person goes for a treatment he or she should be diagnosed properly before doing

treatment. This is a very important visit since the cornea and resulting

vision are rapidly improving at this stage.

Only if this doesn’t work will the eye doctor suggest alternative treatment such as laser eye


Here is my homepage: prescription glasses greenpoint new york

Unquestionably believe that which you stated. Your favorite reason appeared

to be on the web the simplest thing to be aware

of. I say to you, I definitely get irked while people think about

worries that they plainly don’t know about. You managed to

hit the nail upon the top and also defined out the whole

thing without having side effect , people can take

a signal. Will likely be back to get more. Thanks

Feel free to visit my website: puregarciniacambogiapluss.net (http://www.hothome.eu/index.php?m=member_profile&…)

is garcinia cambogia

My relatives all the time say that I am wasting my time
here at net, except I know I am getting familiarity all the time by reading such fastidious content.

My webpage … is garcinia cambogia

extreme weight loss pills

I have been browsing online more than 3 hours nowadays, but I by no means

found any fascinating article like yours. It’s pretty value sufficient for me.

In my opinion, if all site owners and bloggers made just right content as you did, the web

will probably be much more helpful than ever before.

Here is my web site :: extreme weight loss pills

Today, I went to the beachfront with my children. I found a sea
shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear
and screamed. There was a hermit crab inside and it pinched her ear.
She never wants to go back! LoL I know this is totally off topic but I had to tell

Feel free to visit my blog; best facial toner for oily skin

Howdy! This post could not be written any better! Looking through this post reminds me of my previous roommate!

He constantly kept preaching about this.

I will forward this article to him. Fairly certain he’s going to have a very good read.

I appreciate you for sharing!

My homepage :: elizabeth grant skin care reviews


I visited many web pages but the audio quality for audio
songs existing at this web site is genuinely fabulous.

start an online business

When someone writes an paragraph he/she keeps the thought of a user in his/her brain that how a user can be aware of it.
So that’s why this paragraph is great. Thanks!

My web page; start an online business

Tinnitus Remedy Review

Teachers can arrange for the student to sit

in the library or another quiet place when noise levels are causing the hyperacusis

student problems. Most people who have found they

are living with the ringing in the ears which characterizes the sounds

of tinnitus will have been told by their medical practitioner

that there is no known tinnitus cure. With fewer distractions,

people suffering from ADHD are therefore able to focus more easily on the task at hand.

inventor help

I really like what you guys tend to be up too. This sort of clever work
and reporting! Keep up the excellent works guys I’ve you guys to my
personal blogroll.

The plant was ultimately finished with a design intended to.

Celebrity computer backgrounds: This is one of the best options for adults.

Apple concentrates on creating projects that are simple,

attractive, and intuitive to the end user.


Taurus It’s a fantastic time to relax and do more quiet issues close to
home. You could learn a lot by paying interest
to debates heading on around you. They should consider
absolutely nothing at face worth.

Feel free to visit my site :: AskNow Psychics
Reviews (Neil)

Buy Vydox

Hello Dear, are you in fact visiting this web page on a regular basis,
if so after that you will definitely take nice knowledge.

Stop by my page: Buy Vydox


It packed in all senses of the phone it could be synched having a smart interface to the S4 launch
with a variety of entertaining games and much more powerful have taken their profits.
This stripped-down puzzle game with timing and physics-based elements,
graduated from tanks Nike Dunk Heels. Smartphones e
g This smartphone kaufen offer comes in bright sunlight.

I am truly happy to read this weblog posts which consists of tons of valuable
facts, thanks for providing such information.