Old Ocker’s ULTIMATE SuperCoach Spreadsheet
He’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!
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.
Extend the courtesy to our good mate and follow Old Ocker on twitter here @OldOckerOO