add_filter('comment_flood_filter', '__return_false');

Old Ocker’s ULTIMATE SuperCoach Spreadsheet

Published by Jock on

 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 

 


Subscribe
Notify of
guest
77 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
'Don't Blush Babby'

Excellent work Mr.Higgo

peanuts

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

OldOcker

Thanks mate and you are welcome.

Cheers and enjoyl

OldOcker

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'

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

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

bloody hell thats a lot of numbers

OldOcker

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

Cheers mate.

LEKD0G

Love it Mate!

OldOcker

I had a feeling you would,

Ages update on computer clock daily.

Cheers mate.

Grahame Lebroy

This will save alot of time, your a legend Ock

OldOcker

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

Cheers.

FAST HANDS

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

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

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

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

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

OldOcker

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

wombat

All available on Footywire Stats but lovely regurgitation Oldocker!

OldOcker

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

Define: old ocker
Gentlemen, scholar and alruist

OldOcker

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

Take your pick I am all of them.

Cheers.

The Ranger

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

OldOcker

Thanks Mate.
I really appreciate positive feedback.

Cheers and enjoy.

Patch

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

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

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

OldOcker

BUGGER I wanted to play for sheep stations.

I N Pieman

Your a treasure Ocker. Absolutely magnificent!

OldOcker

Cheers Mate,
The Community Spirit.

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

Average Joe

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

OldOcker

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

Cheers Mate

FootyFanatic

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

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

OldOcker

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

Cheers.

Tom

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.

Bc

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

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

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

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

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

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

Mick P

Thanks Mate

You are a legend

OldOcker

No worries mate

GREG

will this give me computer any viruses

OldOcker

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

Cheers.

Dean

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

Need forward pods around 500k , options ??

Cheers big balls

Swans2012

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

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

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

JoeWoolcock

either riewoldt would be a gutsy pick, bb

Swans2012

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

OldOcker

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

Cheers.

wombatsfc

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

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

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

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

OldOcker

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

Cheers.

General Soreness

OO your an absolute star!

OldOcker

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

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

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

OldOcker

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

Cheers

Wattsieesq

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

OldOcker

Cheers mate glad you enjoy.

Steve

no essendon top up players?

OldOcker

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

no essendon top up players?

Steve

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

Steve

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

James

Legendary

OldOcker

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

Musti

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