add_filter('comment_flood_filter', '__return_false');

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!

CLICK HERE TO FIND OUT WHICH VENUES ARE HOSTING COACHKINGS!


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

JUST WHEN YOU THOUGHT THINGS COULD NOT GET ANY BETTER… THEY HAVE:

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

DOWNLOAD VERSION 2.1 HERE

Please Enjoy.

Ock.



 

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


Subscribe
Notify of
guest
50 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Rick Grimes

There goes my POD…

Rick Grimes

Great sheet BTW. Hugely useful and much appreciated.

TJM

Who is it?

OldOcker

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

Cheers hope you enjoy.

OldOcker

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.

Cheers.

JSS

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

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

1. wingard, gray

2. wingard, parker

3. franklin, danger

whats the best option?

@randomcliche

3, 1, 2 for me.

Average Joe

1

Glenn Rush

Wingard, Parker bra

Ren

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

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

OldOcker

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.

Cheers

Ethan017

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

7k in the bank
Cheers fellows

tophawk

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!

Cheers

Dean

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

Glenn

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

Great job lads! Always love the sheet1

OldOcker

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

Eric_the_Red

Stringer vs Billings at F4 community? Haunting my dreams.

tophawk

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

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

Titan

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

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
or
Birchall, Aish, Crouch, Parker and Simpkin.
Leaning towards option 1 because it has more reliable options and would give me guaranteed keepers.

@randomcliche

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

Mac

Thoughts?

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

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

bloke

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

OldOcker

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

Cheers

@Rickym1112

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

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

OldOcker

Cheers mate appreciate your thoughts.

Gold Rush

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

OldOcker

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

Cheers

Andrew

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

Glenn

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

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

OldOcker

You are welcome Doug,
Thanks for the appreciation.

Cheers

Sean

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

BarronVonCrow

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

Average Joe

Choose 2 out of Gray, Wines, Parker and JPK

Jarry

Wines or Parker???

Hamish

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

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

Cheers

Jarry

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

FisherDan

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

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.

Cheers

bailey

anyway to see sub affected games??

Rakesh

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.