Ockers StatsHe’s done it again Community … Old Ocker has delivered a SIGNIFICANT BEAST of a Supercoach stats Excel spreadsheet!

The offline research tool of the season… (along with The Higginator!)

 

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,

Ladies and gentlemen, I have prepared a spreadsheet of a complete list of players and their scores per round, Prices, Clubs, and Positions covering the last 5 years as well as adding this year’s players, Prices, Change of clubs and Positions etc. (4079 data entries!)

The idea of this is to help those of you who do not keep your own stats and some that do but do not have it in this easy to use format and make it very easy to research a player so that you can see a player’s progression over this period of time and help you form an opinion and make your decision on selections a bit easier.

It is also to help everyone decide for yourselves if a player is over or under priced and hopefully it will help you identify the next breakout player or two as well. You can also compare the guns or anyone you like by putting a tick next to their name and it will give you a comparison of players on the one page which I believe makes it so much easier to do your research.

You can sort any column you like in any order and even look for player in a certain position and price range by (Number Filters, Greater than or Equal to etc) EVERY column gives you options.

The formulas behind the sheet should give bang on figures.. for instance – where a player can play a game and score zero or even have a minus score it will still give you an accurate average for that third of the season.

Example: Jack Riewoldt in 2011 scored a big fat zero in round 2 and DID play that game. So his score for that game must be included in his average. (The formula used takes that into consideration as it does for minus scores)

I truly wish everybody a successful Super-coach season. If you have any questions I am only too happy to respond. I believe this spreadsheet should make it easier to find those elusive players and save trades if you can identify the right players in the first place. I must also mention that I am self taught in Excel so don’t pick on me Ha Ha.

Looking forward to helping anyone I can again this year and a big thank you to everyone who appreciated my Options and Opinions last year.

Cheers,
Old Ocker.

DOWNLOAD OCKER’S INCREDIBLE STATS SPREADSHEET HERE

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

 


82 Comments

'Don't Blush Babby' · 02/02/2016 at 15:32

Excellent work Mr.Higgo

    peanuts · 02/02/2016 at 15:44

    it's not Higgo, its Old Ocker … bloody legend!!! oh yeah, Higgo is nice also.

      OldOcker · 02/02/2016 at 15:58

      Thanks mate and you are welcome.

      Cheers and enjoyl

    OldOcker · 02/02/2016 at 17:23

    I won't blush Babby and I am sure Higgo loves you as much as I do being a community member.

    Don't Blush just enjoy the SC season and I hope the spreadsheet helps you to do that.

    Cheers Ocker.

      'Don't Blush Babby' · 02/02/2016 at 20:37

      Thanks mate , apologies if I offended anyone , I was just overwhelmed because I was in the process of trying to do something similar. Congrats you've saved me a shit load of hours – May The SC Gods be with you !!

        OldOcker · 02/02/2016 at 21:06

        Not a problem mate you did not offend anyone.

        You cannot offend me and I am very happy that it saved you a lot of work and time,
        I appreciate that and it is one of the reasons I am so willing to share with the community.
        I have the time and do it for myself so why not share.
        Community spirit is the name of the game.

        Cheers. and Enjoy mate.

West · 02/02/2016 at 15:34

bloody hell thats a lot of numbers

    OldOcker · 02/02/2016 at 15:59

    And a lot of work just for you.
    The Community,

    Cheers mate.

LEKD0G · 02/02/2016 at 15:41

Love it Mate!

    OldOcker · 02/02/2016 at 16:00

    I had a feeling you would,

    Ages update on computer clock daily.

    Cheers mate.

Grahame Lebroy · 02/02/2016 at 15:54

This will save alot of time, your a legend Ock

    OldOcker · 02/02/2016 at 16:02

    Thank you for your comment and that is the idea to help everyone and try and level the playing field.

    Cheers.

FAST HANDS · 02/02/2016 at 15:54

Nice work old. Is 2015 meant to b populated? When u filter on 2015 everyone had a zero against their name in my copy?

    OldOcker · 02/02/2016 at 16:06

    Please try and download from the bold lettering at bottom of description, Teething problem with first downloads should be corrected now.
    I do not understand why you would have a problem with 2015.
    Have you tried sorting in the table?

      FAST HANDS · 02/02/2016 at 16:16

      Rookie mistake got excited when I saw this and clicked on the spreadsheet at the top of the page which must be linked to last year as it opened as jockstats. Once I read you click on the writing download all good. Opened as old ockers. Fantastic work on this mammoth effort. Being a numbers man gonna jump right in. Thanks again.

      OldOcker · 02/02/2016 at 16:17

      You may have also clicked on the wrong sort button if you are not familiar with excel. Go to names and select all and you can sort in alphabetical order or reverse and go to z to a . or Vicki verca. THE same with any column. it will remember the last 2 columns you sorted. You will see a difference in the header column as to what you last changed.

      Hope this helped.
      Cheers.

        FAST HANDS · 02/02/2016 at 16:24

        No problems with Excel know how to use it just unbridled enthusiasm.

          OldOcker · 02/02/2016 at 16:48

          No problems here either I truly hope you enjoy and it helps you to improve your SC score.
          Cheers.

wombat · 02/02/2016 at 16:10

All available on Footywire Stats but lovely regurgitation Oldocker!

    OldOcker · 02/02/2016 at 16:25

    Can't please everyone wombat and I do not know footywire and I am sure the stats are available on a lot of sites.

    This is a composition of my own and it is an offline tool. (NOT ONLINE)

    I put a lot of work into this and I am sorry if it does not please you but we are all entitled to our own opinion and I appreciate yours.

    Does footywire allow you to sort online?

      Ray Spence · 02/02/2016 at 16:38

      Define: old ocker
      Gentlemen, scholar and alruist

        OldOcker · 02/02/2016 at 16:45

        I think you meant to say altruist which you have obviously spelt wrong.

        Take your pick I am all of them.

        Cheers.

      wombatsfc · 02/02/2016 at 17:49

      Please note that that wombat is not this wombat

        OldOcker · 02/02/2016 at 18:14

        I am not worried about wombats mate,
        All they do is eat roots and leaves. Message for Higgo in there I think Ha Ha

        Cheers mate not a worry in the world.

          I N Pieman · 02/02/2016 at 18:35

          Now we’ve got 2 wombats. Hells bells. Ones hard enough to put up with! Any decent Carlton Intel wombats? Apart from battling with club wada for the spoon

            OldOcker · 02/02/2016 at 19:01

            Good to see you so to speak NUTS,
            If you wish to talk Carlton I would suggest you talk to LEK.

            But they do have some positives this year believe it or not. Keep putting those pies out mate and you are off the bottom.

            There is only 1 real Wombat (they all eat roots and leaves anyway)

            Club Wada could be a problem for you so just keep putting out Pies, Which I am sure you can do.

            Cheers Itchy looking forward to our differential opinions during the season.

        wombatsfc · 02/02/2016 at 18:35

        This Wombat thinks the old blokes dataa is brilliant and unique because genuine wombats are too damn lazy and talented to need to visit more than one SC website.

          OldOcker · 02/02/2016 at 19:02

          Cheers mate.

The Ranger · 02/02/2016 at 17:09

My proverbial hat is doffed in your direction OldOcker, love ya work!

    OldOcker · 02/02/2016 at 17:17

    Thanks Mate.
    I really appreciate positive feedback.

    Cheers and enjoy.

Patch · 02/02/2016 at 17:49

Ocker – I bloody love you and the work you put in for us mate. The appreciation levels for this are off the charts. I can't fathom how long this took you to put together.

    OldOcker · 02/02/2016 at 18:22

    No problem mate I appreciate your comments.

    I just contacted Matthew Richardson who has 84 thousand follower's and he put out a tweet for me. Love the boy.
    I will get it to anyone that plays supercoach this year. More legends to come with follower's

    Thank you Richo mate.

    Thanks Patch for your appreciation. I love it.
    Cheers.

Pitch 72 · 02/02/2016 at 17:55

Feel free to join these leagues community, no sheep stations here!, 218655, 855272, 301322.

    OldOcker · 02/02/2016 at 18:23

    BUGGER I wanted to play for sheep stations.

I N Pieman · 02/02/2016 at 18:39

Your a treasure Ocker. Absolutely magnificent!

    OldOcker · 02/02/2016 at 19:05

    Cheers Mate,
    The Community Spirit.

    Enjoy and I hope it helps you to beat me this year. Ha Ha.

Average Joe · 02/02/2016 at 19:18

Just thinking about this the other day! Amazing work mate, this will help me and others a whole heap

    OldOcker · 02/02/2016 at 20:10

    That is the idea mate,
    Helping others to help themselves.

    Cheers Mate

FootyFanatic · 02/02/2016 at 19:21

What's everyones thoughts on Zac Williams (GWS) as a defender? he averaged 88 not including vest affected scores in 2015, and is priced at $375,500.

BarronVonCrow · 02/02/2016 at 19:26

Love it, Ock. Great stuff! Will be using this bad boy for sure.

    OldOcker · 02/02/2016 at 20:12

    No worries mate,
    We may have to talk PM on Twitter,.

    Cheers.

Tom · 02/02/2016 at 20:07

What do we think of Robbie Gray? Had a few injury affected scores so think he can add a few points to his average this year.

    'Don't Blush Babby' · 02/02/2016 at 22:06

    Yeah but at 595k i'm looking elsewhere, JPK 595k also, Priddis 611k, Beams 612k , if he was MID / FWD for sure

Bc · 02/02/2016 at 20:21

Thoughts jock, is any one thinking Aaron black? I think he will be key to north if they want to go forward. Cheap and has averaged 70odd before could be a rookie POD

    OldOcker · 02/02/2016 at 20:27

    I very much doubt that anyone would be thinking of him at $226-600 Way too expensive and risky looking at his last 5 years.

    I would suggest you look elsewhere and I am sure that Jock would say the same.

    Cheers.

Dools · 02/02/2016 at 20:40

Ocker, me old China, hope y ought are well mate, amazing tool you have created better then last year and an obvious love of the game and this community on display. Like last year mate if you need anything even a visit I m in melbourne again let me know and we can share a brew or a beverage , Fridge is keen to catchup ,

Thanks once again for the work.

Regards

Dools and The Fridge

OldOcker · 02/02/2016 at 20:59

Nice to hear from you Dools,
I am very good at the moment loving the start of my Supercoach season.
We always try and be bigger and better mate and would love to talk 1's and 0's with you mate and have a beer but I live about 4 hours from Melbourne.

My bloody fridge has been raided by some bugger that did not sleep last night but is going to bed right now.

Cheers Mate, Sure we will catch up in the season.

ANZAC day is the only time I normally go to Melbourne but I am not sure I will go this year.
I go to meet mates but they are deceased so it would be too traumatic for me I think I will just go to the local RSL Parade. for a few quiet ones.

Cheers Dools.

    medadsson · 03/02/2016 at 02:22

    Hi OldOcker, read your reply to Dools. Thanks for sharing the good stuff with us OldOcker. AND … Sincere thanks to you and your mates, living and deceased. Not many people can lay claim (not that you or they would) to having helped define a nation. I hope you enjoy their memory and your quiet ones on Anzac day.

      OldOcker · 04/02/2016 at 02:29

      Thanks for your thoughts mate,
      Good luck for this season.
      Cheers.

Mick P · 02/02/2016 at 21:29

Thanks Mate

You are a legend

    OldOcker · 02/02/2016 at 21:38

    No worries mate

GREG · 02/02/2016 at 21:36

will this give me computer any viruses

    OldOcker · 02/02/2016 at 21:40

    Certainly not it was scanned and tested for malware before I sent it to Jock.

    Cheers.

Dean · 02/02/2016 at 21:57

Ocker well fark me sideways mate, that's one AWESOME spreadsheet you put together.

Thank you kindly old sir, I love how it shows the BYE rounds. Absolutely PRICELESS mate thanks a ton.

Hope you go far.

Big balls · 02/02/2016 at 22:38

Need forward pods around 500k , options ??

Cheers big balls

    Big balls · 02/02/2016 at 22:48

    Forgot to say , love the spreadsheet , thanks

    Swans2012 · 02/02/2016 at 23:50

    Robinson, reckon he might carry on where he finished last year,and a hall but that’s dependant on role in nab, if cutting loose in mid/hf then could be a good option. Tore it last half season but We know about gc’s injury troubles then….

      Pete · 03/02/2016 at 18:30

      The NAB challenge is a total load of garbage it gives you very little to go on regarding AFL players that have played such as Robinson, all it does is clouds your initial gut feeling, as the players that are in the top 22 of each club are seldom out of second gear in order not to risk injury.
      The NAB challenge gives us a little advantage regarding the rookies, the kids that we have never seen before, thats the only slight advantage we get from NAB.

      When it was the NAB cup that was slightly different as there was a large purse that went to the NAB cup Club winner.
      However now since this NAB challenge the players are only having a jog as there is basically next to nothing to gain for the clubs.

        OldOcker · 03/02/2016 at 20:03

        I don't think anyone would argue with that Pete, Very well said.
        Cheers.

    JoeWoolcock · 03/02/2016 at 14:13

    either riewoldt would be a gutsy pick, bb

Swans2012 · 02/02/2016 at 23:52

Love it ocker, everything I need in one place, easily accessible offline.

    OldOcker · 03/02/2016 at 20:04

    Swans2012, Thanks for the comment mate,
    Hope it helps your selections for the season.

    Cheers.

wombatsfc · 03/02/2016 at 00:10

Love the spreadsheet mate but what do all those numbers mean?
This looks more like work than a game can't you just post the cheats?

throttlefinger · 03/02/2016 at 00:52

Simply amazing. You are a godsend Double O. Easily one of my favorite pre-season tools.

Appreciate taking the time to update and share with the community, my friend.

    OldOcker · 03/02/2016 at 19:18

    Cheers my friend,
    I will be working this year on creating something bigger and better for next year mate.

    Thanks for your support.

    Cheers.

Danners · 03/02/2016 at 08:50

Great stuff Ocker! Being looking forward to this for a while. A very handy tool

    OldOcker · 03/02/2016 at 20:06

    Danners, Thanks for the comment mate.
    May the Supercoach Gods shine brightly upon you this year.

    Cheers.

General Soreness · 03/02/2016 at 10:44

OO your an absolute star!

    OldOcker · 03/02/2016 at 19:29

    Thanks General, Glad you like the addition of the Birthdates this year.

    I try not to over complicate things with too many stats because it can get confusing for some but I am looking at more improvement for next year.

    Cheers.

Derek · 03/02/2016 at 12:25

is there going to be the continuation of the JockReynolds Leagues this year.

I might have been a chance of qualifying after last years effort.

JoeWoolcock · 03/02/2016 at 13:58

You're too generous Mr. Ocker, I bow to your humble genius!

    OldOcker · 03/02/2016 at 19:30

    You are very welcome Joe,
    Thank you for your kind words.

    Cheers

Wattsieesq · 04/02/2016 at 16:27

Great work Ocker. As always, your spreadsheets are magnificent. Cheers

    OldOcker · 04/02/2016 at 22:06

    Cheers mate glad you enjoy.

Steve · 04/02/2016 at 23:59

no essendon top up players?

    OldOcker · 05/02/2016 at 01:26

    The cut off deadline for Essendon top up players is March 15th.
    The decision had to be made whether to release this now or wait until then.
    The idea of this sheet is to help you pre-season and March 15th does not give you any time for study.
    The SuperCoach site is only adding them as they are confirmed.

    The sheet is not Write protected so you can add your own in as they are confirmed if you like, I will release the small list of players separately soon after the deadline.
    Hope this helps.

    Cheers.

Steve · 05/02/2016 at 20:29

no essendon top up players?

    Steve · 05/02/2016 at 20:30

    all good mate. it's awesome as it is.
    love your work! makes the supercoach fanatics jobs easier

    Steve · 05/02/2016 at 20:30

    ignore this msg
    thanks for you work mate!
    makes our picking much easier

James · 11/02/2016 at 22:29

Legendary

OldOcker · 20/02/2016 at 21:25

You are welcome James.
Hope it helps you out this season.
Cheers.

Musti · 07/06/2016 at 14:04

Can I get access to the old Rounds.xls files, as I want to see the prices of all player since round 1

Comments are closed.