2013 Supercoach Team Analysis Tool – THE HIGGINATOR!

Filed in Talking Strategy by on January 7, 2013 • views: 27507

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

 

Comments (97)

Trackback URL | Comments RSS Feed

  1. Choppers says:

    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

    • @PeterHiggo says:

      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.

  2. Paul S says:

    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.
    Thoughts?
    Thanks you old excel wizard – top job yet again!

    • @PeterHiggo says:

      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.

    • @MRB37 says:

      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

      • HawkEye says:

        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!

  3. @MRB37 says:

    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.

  4. Brett says:

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

  5. Kevin says:

    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.

  6. JohnnoB says:

    Outstanding!
    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.

  7. Dan says:

    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 :)

    • @PeterHiggo says:

      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.
      Cheers.

      • Dan says:

        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!!! :)

  8. Higgo,

    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.

    Jock.

  9. Joey says:

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

  10. Higgo you legend :D 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

      • Dan says:

        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…

  11. Ross says:

    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

  12. @PeterHiggo says:

    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.

    • Choppers says:

      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?

  13. Ash says:

    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)?

  14. Choppers says:

    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

  15. lowedown says:

    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

    Cheers

  16. Mathew says:

    Three cheers for higgo

  17. Supercoach Jesus says:

    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

  18. Dools says:

    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

  19. hamish says:

    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

  20. Dools says:

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

    • hamish says:

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

      • Dools says:

        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)

  21. hamish says:

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

    • Dools says:

      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?

  22. hamish says:

    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?

  23. Dools says:

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

  24. Dools says:

    Sorry Micro soft Ecel

    • Dools says:

      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

  25. Jonesracing82 says:

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

  26. Jonesracing82 says:

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

  27. abc says:

    doesnt work on Excel 2000, just alot of errors

  28. Hounddogs says:

    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

    John

  29. kane says:

    anything for mac?

  30. Alwarmo says:

    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.

  31. Barney's19 says:

    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.

  32. RossWasLyon says:

    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

  33. Nick says:

    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.

  34. Same Old FC says:

    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

  35. Andrew says:

    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
    Laffa

  36. Popey99 says:

    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%

  37. George says:

    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 4.0.3.3.

  38. start here says:

    What’s Taking place i am new to this, I stumbled upon this I’ve discovered It positively useful and it has aided me out loads.
    I hope to contribute & help other customers like its aided me.

    Great job.

    Feel free to visit my homepage … start here

  39. Hey there just wanted to give you a quick heads up.

    The text in your content seem to be running off the screen in Opera.
    I’m not sure if this is a formatting issue or something to do
    with web browser compatibility but I figured I’d post
    to let you know. The design and style look great though!

    Hope you get the problem solved soon. Cheers

  40. 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.

  41. 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)

  42. 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

  43. The following are a couple of the top sellers in the daypack
    category of backpacks. Older children ages 7 to 12 at this
    summer camp will work with a vocal coach,
    choreographer and director to improve their singing, dancing
    and acting skills. (858-509-7977), Gnarly Neal’s Island Surf
    Camp (858-344-5336), the Pacific Surf School (858-488-2685), La Jolla Surf Camp
    (858-454-8273), the Australian Surf Academy (858-454-8273), SDSA Surf Camp (800-447-7873) and Camp Pacific’s Surf and Bodyboard
    Camp (760-434-7564). Are you aware that you are obligated to pay seven
    different types of taxes. Talk to their leader, Cooper, and you can follow them to Nelson.
    What legal procedures are used if troublesome or illegal
    problems arise. Hiking or camping is more enjoyable when you have
    complete outdoor camping gear. The coach’s and I each ordered what we wanted, a cheese burger with some fries, a
    steak and so on. There are several sports camps in New York focusing
    much more on enjoyable, expertise advancement, basic safety, and sportsmanship.

    You won’t be expected to get in a ring and fight Muay Thai when
    you are in Thailand’ in fact, even sparring is voluntary at most gyms.

    Here is my blog post; delray beach boys camps

  44. Shock hair loss is generally caused by physician error when doing the treatment, so picking a physician who understands exactly what they are doing is
    essential. Used in determining menstrual irregularities, menopause, pituitary problems, suspected gonadal failure and infertility tests.

    Because of this, you need to clean your hairs and make them tidy at all the times.

    My web page – igrow tallahassee

  45. 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

    surgery.

    Here is my homepage: prescription glasses greenpoint new york

  46. 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&…)

  47. 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

  48. It enables you to eat normal, like normal people, without putting on the weight.

    If taken in a correct manner, these drops do not
    have any side effects. Individuals feel lethargic while
    you’re on the HCG protocol.

    My site hcg weight loss gastonia nc

  49. Some folks have no concerns in trying Garcinia Cambogia since according to scientific research it is
    risk-free and efficient. In addition to being a great meal ingredient, a handful of walnuts
    as a snack can really help avoid between meal hunger pangs.
    Notice how Mindfulness gives you a way to create a vision of the whole you to add
    to the idea of losing weight. Are you still overweight, the possibility
    of greater health. Should they need to know the protection issues of garcinia cambogia extract, they have got to refer numerous sites.

    Benefits of Garcinia Cambogia and How it Works Garcinia Cambogia has been making its name in the weight loss industry for some
    time now. Appetite Suppression: Hydroxycitric Acid (HCA) is found in abundance in Garcinia Cambogia.
    Retake the hip measurement and photographs as well so you are consistent.
    Seeking for natural fat burners, fucoxanthin, a seaweed extract, one of the key
    nutrients in the popular weight loss formula Primal Lean, is a good example.
    Garcinia cambogia extract is a natural dietary supplement that may
    help in an individual’s weight loss.

    Stop by my weblog … garcinia cambogia for men and women

  50. 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

  51. diet plans says:

    You could certainly see your skills within the article you write.
    The arena hopes for more passionate writers like you
    who are not afraid to say how they believe. At all times go after your heart.

    my webpage … diet plans

  52. 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
    someone!

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

  53. I really like your blog.. very nice colors & theme.
    Did you create this website yourself or did
    you hire someone to do it for you? Plz respond as I’m looking to construct my
    own blog and would like to find out where u got this from.

    many thanks

    Feel free to surf to my site … where to find garcinia cambogia

  54. The main component in the product is HCA (hydroxycitric acid).

    And, you will just end up getting frustrated, which just worsens the situation. You can find vitamin supplements which come with the bacterium of intenstine’s microflora.
    The popular health expert told his audience that the fruit is a “dual action fat-burner” that can double
    or triple a user’s weight loss. Nor will you learn anything useful about how to eat a
    healthy diet. Presently, it is promoted through capsules or
    liquid extracts. “The Holy Grail Of Weight Loss”, Found in Javita Coffee.

    To interrupt this resistance cycle, it may be time for you to
    take a different approach. Proactol contains both
    soluble and non-soluble fiber. During the last 15 years, countless weight loss
    supplements, exercise gimmicks and fad diets
    have come and gone.

    my site; garcinia cambogia reviews for men

  55. 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

  56. website says:

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

  57. 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

  58. 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.

  59. 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.

  60. 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.

  61. Neil says:

    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)

  62. Buy Vydox says:

    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

  63. Smile your friends on this International Friendship Day 2014. Friendship is a beautiful relationship. So celebrate friendship day 2014 this week with us share Friendship Day 2014 quotes, wishes, and messages and send to your friends.

  64. Chiquita says:

    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.

  65. Hello, i think that i noticed you visited my site so
    i came to return the favor?.I am attempting to to find issues to improve my
    web site!I assume its adequate to use some of your ideas!!

    my blog secret money system reviews

  66. vitamin d3 says:

    Right now it looks like Movable Type is the preferred blogging platform out there right
    now. (from what I’ve read) Is that what you’re using on your blog?

    For a wonderful review please visit this website ::
    vitamin d3

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

  68. Remarkable issues here. I’m very satisfied to
    peer your post. Thanks so much and I’m taking a look ahead to contact you.
    Will you please drop me a mail?

    For a better review please have a look at this page; dieting to lose weight

  69. We stumbled over here coming from a different web page and thought I might as well check things out.
    I like what I see so now i’m following you. Look forward to looking at your web page yet again.

    For an incredible review please click the link to this web-site: extreme makeover weight loss

  70. An impressiv share! I’ve just forwarded this ojto
    a co-worker who was dong a littloe research oon this.

    And he in fact ordered me lunch because I discovered
    itt forr him… lol. So let me reword this…. Thajks for the meal!!
    But yeah, thanx forr spending some time to discuss this topic hedre on your web site.

  71. It’s remarkable for me to have a site, which is useful for my experience.

    thanks admin

  72. It's good to hear they have increased the number of degrees of freedon so you can now have more information about the other traders which are operating in the same time. Good news !

  73. Awesome information, thanks admin for sharing such a great post with us, its really great one. I have found here a good blog having iPhone, iPad and IOS apps and games, you can download iPhone apps and games totally free.

  74. Rock says:

    The post you have shared is really useful. Thank you very much for this, I visit again your site for more updates and I hope you will come with more updates in the next time.