Old Ocker’s ULTIMATE SuperCoach Spreadsheet v2.1

Published by Jock on

One of the true gentleman of Supercoach has done it again.

If you’re like many of us.. there’s something about a good Excel stats spreadsheet that really stirs the loin.

And Ocker’s is clearly the best you’ll ever come across. Here is the second version for the season. Ocker’s gone and juiced here right up!

A few quick notes before we hear from the great man Ocker;
  • You’ll need Microsoft Excel 2007 or newer
  • You might need to click on ‘enable editing’ up the top before you crank into it
Over to Ocker!


Hello Community,

Some of you may have noticed that not all players names have consistency, Example Nat Fyfe and Nathan Fyfe.
I have spent many hours going through each and every player to make sure of uniformity in naming. The best advice I can give you is search by Sirname first. If you find any problems please hit me up on Twitter.

I have updated all of the ESS top up players and their list has now been finalized.

I have also put in the bye rounds for each player.

I made the decision to Update the Spreadsheet to try and make things easier for you in your research, after all that is why I do this for you. This Version 2.1 will be the last for this year. 2017


  • Bonus 1: 2016 AFL Draw.
  • Bonus 2: Club listed rookie sheet with hyperlinks direct to the players profile, this should save a lot of time going to Club sites and searching for them.

I wish everybody a great SuperCoach season and truly hope that my Spreadsheet helps you to do that. It would be nice to know that whoever wins this year used my Ultimate SC Stats Sheet. Hope it is one of you.


Please Enjoy.



Extend the courtesy to our good mate and follow Old Ocker on twitter here @OldOckerOO 


Rick Grimes · 25/02/2016 at 20:00

There goes my POD…

    Rick Grimes · 25/02/2016 at 20:07

    Great sheet BTW. Hugely useful and much appreciated.

      TJM · 25/02/2016 at 20:59

      Who is it?

        OldOcker · 27/02/2016 at 00:24

        TJM, It is Old Ocker mate. I am a point of difference.

        Cheers hope you enjoy.

      OldOcker · 27/02/2016 at 00:23

      There are about 800 players Rick and POD will remain that way. This sheet is supposed to help you find those and there are many so I would not see that as a problem mate.

      Just trying to help those that do not have the time to do what I can do and help level the playing field for those that know how to use it. You only have to start worrying when I start to make videos on how to do that.
      I am happy that you find it hugely useful and glad you appreciate.


JSS · 25/02/2016 at 20:07

Hi jock how is my team looking I have 10000 left
Birchall, yeo, rich, smith, m.brown r.bonner: k.collins, m.hibbered
Danger, Pendles, Ablett, Rockliff, wines, Libba, crouch, parish: macpherson, d.gore, j.long
Nic nat, lobbe: wyatt
Zorko, wingard, Barlow, Greene, kerridge, kommer: m.cox, petracca

    Ethan017 · 25/02/2016 at 20:17

    Looks pretty solid maybe downgrading Smith to Aish could generate some cash to uprgrade Rich/Birchall/Yeo and Macpherson's a rookie so won't play too much and maybe Keays in for Long
    Good luck this year buddy

Tom · 25/02/2016 at 20:07

1. wingard, gray

2. wingard, parker

3. franklin, danger

whats the best option?

    @randomcliche · 25/02/2016 at 21:22

    3, 1, 2 for me.

    Average Joe · 26/02/2016 at 08:12


    Glenn Rush · 28/02/2016 at 11:03

    Wingard, Parker bra

Ren · 25/02/2016 at 20:13

Beautiful Ock!

Do you reckon its too expensive to be going in with Danger, Fyfe, GAJ and pendles?

Should I be opting for a cheaper option?

    Average Joe · 26/02/2016 at 08:13

    If you have any areas that need upgrading bad then don't go with all four of them. Otherwise go for it

    OldOcker · 27/02/2016 at 00:31

    Ren, Not at all in my opinion they are all players that you would most likely be looking at having at the end of the season.
    Why not start with them, It will save trading up later. (Mid-priced madness is crazy this year with bargains that are very risky) Stick to the guns and rookies theory is my advice. Trades and how you use them will be as usual vital this year.


Ethan017 · 25/02/2016 at 20:14

Rate my team if you could
KK, Bartel, Yeo, Aish, Dea, Francis (bonner, Broad)
Ablett (C), Pendles, Rockliff, Parker, Wines, Libba, Crouch, O'meara (Freeman, Petracca, D.Cunningham)
Mumford, Lobbe (Grimley)
D.Martin, Barlow, Greene, Conca, Simpkin, Kerridge (Komner, Brown (Essendon)

7k in the bank
Cheers fellows

    Tom · 25/02/2016 at 20:18

    O'meara unlikely to line up round 1.

    Apart from that its pretty sold. Similar to many other teams ive seen

    tophawk · 25/02/2016 at 20:39

    Hi Ethan. I think your side needs a little work. A few tips from me for what its worth.

    1- Your backline is very risky: No assurity that most of these guys will perform consistently. Perhaps consider 2 of the following stalwarts. Shaw, Docherty, Simpson, Rampe, Rance, Houli etc)

    2- I really like your midfield. Perhaps replace O'Meara (will not play rd 1) for another rookie (Gresham, Mac Pherson). This will free up cash to grab a Heath Shaw for your backline.

    3- What the ruck?? Pi-ss off Minson and go for a more reliable option. (Martin or Jacobs) Mummy far to injury prone. Lobbe OK. Goldy I will grab later at a lower price just as you are planning. (I assume)

    4- Your forward line is pretty good. If you can afford it upgrade Greene to a Zorko, D.Smith, Dahlhaus or Wingard.

    Just my take of course mate. Hope it helps!


      Dean · 26/02/2016 at 20:53

      Tophawk where did you get Minson from in Ethan's team? lol

      Glenn · 28/02/2016 at 11:06

      Anyone with O'meara at this stage of NAB Cup should be on the net looking up injury updates! O'meara wont be ready for a bit still, do your research gents! He has had a bad knee for months now!?

Deccas · 25/02/2016 at 20:15

Great job lads! Always love the sheet1

    OldOcker · 27/02/2016 at 00:32

    Deccas. Not a problem mate I hope it helps you out this year.

Eric_the_Red · 25/02/2016 at 20:34

Stringer vs Billings at F4 community? Haunting my dreams.

    tophawk · 25/02/2016 at 20:44

    From what I am seeing in the NAB cup tonight, I think Stringer would be my preference. Early days, but Stringer looks very good.

      magpie4ver · 25/02/2016 at 21:20

      Yes I agree…..he's been on my radar but Stevens has looked good too?

Titan · 25/02/2016 at 20:48

Great work with the spreadsheet

Been playing around with my side a little
This is what i have atm
Laird kk doc z williams rookies x4
Danger pendles ablett rocky parker libba rookies x5
Goldy nic nat wyatt
Martin barlow billings simpkin rookies x4
Depending on how b smith goes i may swap him and laird and up parker to jpk
Thoughts would be great

Liam · 25/02/2016 at 20:53

Need some help for my team.
Still undecided if I should go set and forget in defence, or wait to see the premos and pick them up later.
So, should i go
Shaw, Smith, Gresham, 123k rookie and Wingard
Birchall, Aish, Crouch, Parker and Simpkin.
Leaning towards option 1 because it has more reliable options and would give me guaranteed keepers.

    @randomcliche · 26/02/2016 at 07:55

    Depends on your preference for Guns n Rookies vs Midprice Madness. Answer that question and you'll have your answer.

Mac · 25/02/2016 at 20:57


Shaw, Simpson, KK, Aish, Brown, Tucker, Broad, Collins
Fyfe, Pendles, Ablett, Rockliff, Parker, Libba, Hopper, Gresham, Cuningham, Keays, Mathieson
Goldstein, Nic Nat, Wyatt
Martin, Zorko, Barlow, Kerridge, Hunt, Petracca, Grimley, Adams

1k left in the bank

    Glenn · 28/02/2016 at 11:08

    Petracca , Aish and Tucker and Hopper could send this team down the gurgler!!

bloke · 25/02/2016 at 21:21

Just about to download.. and I already know it's awesome. Thanks Ocker, love your work. Cheers,

    OldOcker · 27/02/2016 at 00:34

    Onya bloke, Glad you enjoy. This years is better and next year? Surprise will be better again.


@Rickym1112 · 25/02/2016 at 21:27

McVeigh, Laird, Suckling, Weitering, M.Hibberd, M.Brown (ess). –(Tucker, Bonner.)

Ablett, Fyfe, Dangefield, Rockcliff, Parker, Libba, Crouch, mills –(Polkinghorn, Keays, Macpherson)

Martin, Lobbe–(Grimley)

Deledio, Barlow, Franklin, wells, Simpkin, Kerridge –(petracca, Milera)

McVeigh if fit.
Will be hoping to trade Franklin and mills when there bye comes around. Loaded up in the mid too generate good early points.

The Ranger · 25/02/2016 at 21:39

You're a bloody legend Ocker!
Top work mate.

    OldOcker · 27/02/2016 at 00:35

    Cheers mate appreciate your thoughts.

Gold Rush · 25/02/2016 at 22:47

Thanks Ocker, appreciate your efforts – If I don't win this year I hope you do.

    OldOcker · 27/02/2016 at 00:37

    Good Onya mate, The season is right in front of you don't look back.


Andrew · 26/02/2016 at 00:38

I have 2 spots left in my mids:
Danger or Pendles
Shiel or Treloar

    Glenn · 28/02/2016 at 11:09

    Treloar all day mate! Even Dangers before him! Pendles will pop you he's 110 as a max! Treloar will be the new 130 plus man!

Doug · 26/02/2016 at 01:55

Thanks Ocker, don't know what I'd without this magnificent spreadsheet….Champion!

    OldOcker · 27/02/2016 at 00:38

    You are welcome Doug,
    Thanks for the appreciation.


Sean · 26/02/2016 at 05:42

what are your thought on Blicavs in the ruck. Will be playing up more this year, i thnk.

BarronVonCrow · 26/02/2016 at 05:58

You're too bloody good to us Ocker. Great stuff, thanks again!

Average Joe · 26/02/2016 at 08:39

Choose 2 out of Gray, Wines, Parker and JPK

Jarry · 26/02/2016 at 11:09

Wines or Parker???

    Hamish · 26/02/2016 at 11:14

    yeah it's a tough one, personally I think Parker because of his ferocious attack on the ball and his tacking pressure. Tackling gains big point so defiantly Parker

    OldOcker · 27/02/2016 at 00:40

    I am more inclined to go with Parker at this stage due to reports of Wines having a minor groin problem.


Jarry · 26/02/2016 at 11:15

Yeah cheers Hamo always good to get some thoughts from the community

FisherDan · 26/02/2016 at 22:11

It also works in Open Office's Calc program for anyone who doesn't have excel. Takes a while to load initially but seems ok. Plus its free 🙂

    OldOcker · 27/02/2016 at 00:44

    Yes it is free mate and will remain that way, Last year I had a request for a MAC version and got it working for them in .ods format.
    I am always trying to help so if you have any problems let me know.


bailey · 27/02/2016 at 10:28

anyway to see sub affected games??

Rakesh · 28/02/2016 at 19:02

Hi Guys. We are new to Footy and would like help to fill the spots in 718979. Last year I played and was probably around 20000.

Comments are closed.