Supercoach-Spreadsheet

HERE IT IS – SUPERCOACH PORN FOR THE MS EXCEL RESEARCH NUTS!

Settle into your research chair, download these tools to your laptop or desktop and go absolutely NUTS

OLD OCKERS JLT STATS

Ocker has delivered again – Supercoach scores and every stat you could want to poke a stick at from the JLT Series

DOWNLOAD OCKER’S JLT STATS HERE

TRIGGER’S JLT PROJECTOR

All the scores, key stats, including adjusted SC scores based on a projected 85% TOG

DOWNLOAD TRIGGER’S PROJECTOR HERE

THE HIGGINATOR

Needs no introduction. The #1 team planning and analysis tool in the nation.

Automated bye coverage analysis, structure analysis, THE WORKS

DOWNLOAD THE HIGGINATOR HERE

OLD OCKER’S ULTIMATE SUPERCOACH STATS SHEET

Historical detailed stats  and Supercoach analysis of every player over the past 3 seasons.

GRAB IT HERE HERE – AND DONATE TO THE GREAT MAN!


95 Comments

Leg · 18/03/2017 at 09:00

Thanks, when do we get ya rookie locks jock?

    Krups · 18/03/2017 at 09:35

    Should be enough info out now mate to get it right. Keep an eye on team sheets next week

Suttoo · 18/03/2017 at 09:01

DEF: Docherty, Laird, Adams, Ottens, Hampton, Vicker-Wlillis (Newman, Stewart)
MID: Danger, JPK, DePendles, Shuey, Fyfe, Titchell, Beams, SPP (Maynard, Wigg, Miles)
Ruck: Nank, Sandi (Strndica)
Forward: Dals, Macrae, JK, Picket, Black, Camroon (Smith, Eddy)
Thoughts
I want to get in The BONT but dont know hoow to fit him thoughts

    Krups · 18/03/2017 at 09:36

    Bont for Shuey?

      Dean.R · 18/03/2017 at 09:52

      Hey Krups, good line up. To answer your question, I would replace either Pendles or Shuey for Bont. Pendles may spend some time in the forward/ back half this year, as Buckley tried this at the beginning of last year, before realising it was a mistake and shifted him back in the midfield. this year however Bucks hasmore guns in his midfield, so he may experiment with this again. As for Shuey, he is not a midfield clearance beast like Bonts is, and with the added experience of Mitchell in there to contend with who is a bonafide clearance beast, Shuey's numbers will drop. I would pick Bonts over Pendles or Shuey. Infact, I would look at replacing both with Bonts, and/or Parker, or Hannebery, or even Sloane.

    bUCKET__ · 18/03/2017 at 09:50

    Could go Nank to Witts to free up a bit of cash – love how far you're pushing the GnR approach here, it's gunna be a bit rare from the looks of it this year!

    Dan · 18/03/2017 at 13:33

    Bont for either dahl or mccrae otherwise thats a lot of premos missing when dogs have their bye round.

Kev · 18/03/2017 at 09:39

Awesome, Jock! Cheers to Old Ocker, Trigger, and Higgo for taking on excel and putting it all together

oldmate65 · 18/03/2017 at 09:58

Can I get some thoughts and opinions on my current team?
DEF: Simpson, Adams, Laird, Hampton, EVW, Stewart (Long, Otten)

MID: Danger, Pendles, JPK, Bont, Fyfe, M.Crouch, O'Meara, SPP (Hibberd, Parfitt, LLoyd)

RUCK: Grundy, Sandilands (Strndica)

FWD: Riewoldt, Dahl, Roughy, Taranto, McCarthy, Eddy (Black, Pickett)

Thanks gentlemen.

    John · 18/03/2017 at 10:16

    Who is McCarthy?

      oldmate65 · 18/03/2017 at 10:23

      Cam McCarthy, Fremantle

    Rivo · 18/03/2017 at 12:33

    Love the Crouch selection at M5. You are exposed however in the ruck bench if Sandi goes down. You may want to consider Witts at R3 or Nank at F4.

    Dan · 18/03/2017 at 13:34

    Nice team. Different enough from the cookie cutter teams.

    SteveC · 22/03/2017 at 17:57

    like the Rooey pick – what is his selection %? I bet it is low. My feeling is JPK starts seasons slowly but comes home with a wet sail, I plan to get him after his bye

TRIGGER HAPPY · 18/03/2017 at 10:29

Well done Ock what a collection of stats, everything you ever wanted to know.
Apologies ol mate if I had of known you were putting together such a comprehensive analysis of the JLT series I wouldn't have put together my meagre offering but as I hadn't seen anything on the site thought i would quickly put together a quick and dirty.
Interesting fact.
If u do filter on who scored over 100, played over 80% TOG and had a DE of over 80% only 4 names come back as having achieved this in two games. Interestingly west coast had 3 Hurn, McGovern and Gaff. The only other player was Touey. Hurn and McGovern are surprising. Pod in defence anyone?

To quote the great man in the pod cast it was JLT so when viewing these stats "keep it in perspective" don't let the rose coloured glass cloud your judgement and ruin all your ground work before a ball has been bounced in the real deal.

    Kenny Powers · 18/03/2017 at 10:57

    big fan of the Governator

Jordan · 18/03/2017 at 10:40

How many rookies do we want to start on the field is 7 too much

    wombatsfc · 18/03/2017 at 11:02

    Not an issue Jordan, as long as you keep it to single digit numbers you'll be fine.

    Kev · 18/03/2017 at 11:03

    Depends on who they are. I'm more confident in the JS of Hampton than I am with Parfitt

Tom1 · 18/03/2017 at 10:44

Def: shaw laird Howe marchbank hampton vickers-Willis otten Stewart
Mid:Dangerfield jpk treloar selwood Fyfe beams Powell-pepper Barrett picket hibberd parfitt
Ruck: goldy sandi strndica
Fwd: Dahlhaus McRae Roughead Steele Taranto Houston eddy black

Thoughts on the team? 50/50 on getting Buttler for black and upgrading Steele to green, any glaring issues?

    Northernsoul74 · 18/03/2017 at 10:48

    Wait until teams drop but as it stands Butler more likely to play than Black.

oldmate65 · 18/03/2017 at 10:46

I'll throw this out there for some discussion, but what do we think of Jake Stringer?
Scores of 103 and 116 in JLT 2 and 3 from 77% and 81% game time respectively.
Priced at $410,100, good player when he plays well.

    Kev · 18/03/2017 at 10:59

    Classic example of a JLT trap. Those two scores in isolation are fantastic, yet his history shows that he has never averaged over 75.

    Northernsoul74 · 18/03/2017 at 11:10

    Now Crameri is back and personal issues are behind him he's certainly looking back to his old self and is getting a run through the midfield. My main concern is some games he just doesn't look interested so always likely to throw in a very poor score. I think he's worth considering if you think his head is back in the game.

      Dan · 18/03/2017 at 13:38

      The not looking interested couldve been associated with his 'personal issues' you speak of.

    Danners · 18/03/2017 at 19:28

    Boy oh Boy wow wee! He can burst out like tarzan and dominate or go completely missing like in the GF. Don't touch him

Marron · 18/03/2017 at 10:53

Looking for a couple of guns to fill a league – 413431

Demon · 18/03/2017 at 11:15

Def – Shaw, Simpson, Laird, Marchbank, Hampton, EVW (Hibberd, Stewart)

Mid – Danger, Treloar, Titch, Priddus, Fyfe, Beams, JOM, SPP (Barrett, Miles, Parfitt)

Rucks – Nank, Sandi (Cameron)

Fwd – Roo, Greene, Dahl, JJK, Pickett, Eddy (Houston, Begley)

$3,700k left. Thoughts please anyone.

    Dave · 18/03/2017 at 14:12

    Risky running Nank and Sandi, sand goes down and you don't have cover your going to need to double trade to go up to a premium.

      Kev · 18/03/2017 at 14:36

      The point of taking a risk really. Sandi probably won't last the season but he can give similar or above the output of the top priced rucks for 300k cheaper.

      Cameron gives short term cover.

Borko · 18/03/2017 at 12:04

Have about $1.475m for D3,F3 & R1 … want ideally 2 keepers and one value pick.

Adams-Gunston-Hickey
Adams-Rough-Goldy

Any other thoughts?

    borko · 18/03/2017 at 12:44

    Lloyd-Caddy-Grundy?

    Rivo · 18/03/2017 at 12:52

    Laird-Steele-Martin

    Dan · 18/03/2017 at 13:41

    Adams Roughie Goldy is 3 keepers. Roughead is ur value pick but should be looked at as a keeper. If ur not expecting him to be a keeper I go with ur other choice.

    Borko · 18/03/2017 at 15:14

    Thanks … I like Steele but he will need to go past a lot of players to be a top 8-10 fwd. Not sure roughead is a def keeper but does have R13 bye so that is handy. If they are both stepping stone options then I wonder if JOM
    is a better choice (swing TT fwd) … cheaper but prob more risk

    Derek · 18/03/2017 at 19:47

    Don't pick your team like that

    Get a piece of paper and Write down who your best (money no object) team is.

    It's your team, don't worry what other people say, especially if you have Cyril.

    Pick them carefully as if they deserve to be in your team.

    Don't make the mistake of asking "I've only got $550k, what premium should I get…..".

    Then pick at least 12 of them for your starting squad. You could go 13, but try 12 to start.

    I suggest you look for a bit of value, pick the guys who you think might drop in price, I didn't go for any of the expensive defenders, get them later.

    Once you have your best value 12, put them in your team and see if you are underweight on any line, at least 2 forwards, 2 defenders and 1 ruck is my suggestion, but nothing is wrong.

    Next step is pick 3 to 5 midpricers.

    Be very careful, this is usually a trap. I personally decided to only pick fallen premiums this year, you might be more of a young breakout guy.

    This is where you need to think about Sandi, Roughie, Beams, Swallow, Mills, Touhy, the Nank, Ryder.

    Think about your midpricers in isolation, rather than where they will be in your starting team. I see too many questions about Roughie should be a F4 not a F3…,, seriously.

    Pick your Mid pricers carefully.

    Read Patch's great article on Mid pricer players Suck before your decision.

    Slot them in your team

    The rest of the team are rookies and really can't be done until Thursday.

      Borko · 18/03/2017 at 20:16

      Thanks for your detailed response Derek. I always read your posts with interest.

      I have got to this point after following many of the steps you suggest. I plan to run the following structure:

      10-11 x keepers, eg danger
      2-3 x 'value' keepers, eg. beams
      2 x mids, eg. sandi
      4 x elevated cash cows, eg hampton
      10 x cash cows
      1 x loop hole

      If I end up with 12 genuine keepers, them it's 10 upgrades (20 trades + 2 correctives). Should have 6-8 trades left over for injuries and maybe even some icing on the cake at the end.

      Re. Nankervis, I plan to hold him all year … if he isn't a keeper, he will become my F7/R3. Had similar thoughts on Jake Lloyd for D7/M9 but he is a bit pricey for that strategy I think.

SNK · 18/03/2017 at 14:36

Def- Shaw, laird, Howe, Hampton, otten, vickers-willis, m,hibberd, Stewart

Mid- Dangerfield, j,Kennedy, treloar, priddas, fyfe, beams, swallow, spp, florrent, Barrett, parfitt

Ruck- ryder, sandi, strnadica

Fwd- dahlhaus, Franklin, macrae, nakervis, taranto, pickett McCarthy, eddy

Peoples thoughts

    Derek · 18/03/2017 at 20:02

    Instead of just posting your team, what do you want advice on? Otherwise I'll tell you to get rid of the Nank.

Phil · 18/03/2017 at 15:01

I don't have excel. So was wondering if someone is kind enough to tell me David Swallows average, time on ground and points per minute in the JLT?

Tiger Man · 18/03/2017 at 15:13

One spot left in a strong league. Anyone welcome 149246

    bigdog43 · 18/03/2017 at 15:24

    I joined mate, looking forward to the challenge

    Tiger Man · 18/03/2017 at 16:08

    Now full, thanks guys

Matt · 18/03/2017 at 15:21

Alright community I need some help with my selections. I am a player who thrives on playing risky, picking those who might rise to be popular who sit in the shadows at this point, or just players who will never have above 3/4% (Coniglio was with me all season last year and was my most happy pick 🙂

My team as stands:

DEF:
T.Adams, M. Hurley, H. Hartlett, T.Cutler, C.Marchbank, C. Hampton (BENCH: A. Otten, Z. Guthrie)

MID:
T.Rockliff, R. Sloane, R. Gray, N. Fyfe, D. Heppell, D. Beams, J. O'Meara, T.Taranto (BENCH: S.Powell-Pepper, M. Hibberd, B. Parfitt)

RUCK:
T.Hickey, T. Nankervis (BENCH: D. Cameron)

FWD:
N.Riewoldt, C. Wingard, P. Ryder, J. Roughead, C. McCarthy, B.Eddy (BENCH: M. Chol, D. Houston)

Yes as you can see I am a Port fan, and I'm backing a few of my fave bois to have a great bounce-back season. Not too many usual picks as well, and my Ruck could be extremely disastrous. Lemme know if you guys have any extra help!

    jimmy_raiders · 18/03/2017 at 15:40

    Tough year to load up on port players due to Round 9 bye

      jimmy_raiders · 18/03/2017 at 15:49

      Also Tom Cuter in 0.2% of teams! The ultimate POD

    Wilson · 18/03/2017 at 15:44

    Matt I really appreciate the testicular fortication, real balsy stuff, but mate you have gone to the enth degree and back, you are in for a horror run, round 9 is the killer too many port players, I actually love your rucks, hickey is a brilliant pick! Wingard is a good pick put I would go Steele free up cash, downgrade gray to wines and upgrade Rockliff to danger and consider trading Houston to a Pickett because of the bye. That's just my 2 bond worth.

    wombatsfc · 18/03/2017 at 15:58

    Bloody hell Matt M1,2,3 what the … I understand your desire to be different and not look like you're running with the pack but mate there is a far greater chance of your M1,2,3 selections ruining your chances of getting the cash than there is of them increasing your chances.
    Also, Hamish didn't suffer a form slump he suffered a role change i.e. his scores wont improve over last year coz he's not getting back in the middle.
    To really sink your boat how many will you have onfield in round 9? you need 22 and think you could get a few donuts

    Derek · 18/03/2017 at 19:59

    Hartlett to VickersW

    Tarento to Cyril (via swing)

Slatsy · 18/03/2017 at 15:24

How does everyone plan to loophole Danger this year?
Use Danger as VC and select a captain if he spuds it?
Or pick an early VC and have Danger as backup captain each round?

Sydney has the most games before Geelong (10) if you want JPK or Hanners as VC
Freo has the most games after Geelong (13) after if you want to VC Danger with Fyfe as backup.
Richmond has the most games that overlap times with Geelong (9)

    jimmy_raiders · 18/03/2017 at 15:39

    Some handy research there

    wombatsfc · 18/03/2017 at 15:51

    I'll probably wait until after teams are announced before I decide on my captain and then each week I'll make the decision based on the players form and the form of the upcoming opposition. Picking a player simply because he enables another player to be VC loopholed doesn't make sense to me

    TRIGGER HAPPY · 18/03/2017 at 17:18

    Danger into fyfe with strnanica loop happy days.

      neil Demons Delight · 18/03/2017 at 18:27

      how does that work Trig

Nedwardo · 18/03/2017 at 15:25

Long time fan first time poster
Running
Backs Shaw, Adams, Laird,Touhy, Hampton,Otten
(Vickers, Stewart)
Mids DangerWood, Treloar, Bont, Fyfe, Beams, JOM, Salt n Pepper, (Barrett, Miles, Parfitt)
Ruck Nank, Sandy,(Cameron)
Forwards Roo, Ryder, Rough, Steele, Toranto,(Picket, Eddy)
Would love some feedback
Not sure if I've gone to much Adelaide in the back and I'm not sold on the mid bench.

Doc · 18/03/2017 at 15:33

Lads, any interest in Scott Selwood as a stepping stone this year.
Haven't heard too much of his preseason but at $281k is well priced for his scoring history.
Will he get a game?

    Northernsoul74 · 18/03/2017 at 15:39

    He hasn't played any pre-season games so unlikely to be ready round 1.

    Nedwardo · 18/03/2017 at 15:46

    Won't be ready for round one but Chris Scott is desperate to have him relieve Dangerwood so he will have a lot of time in the action. (Geelong fan)

    Danners · 18/03/2017 at 19:25

    He does a bit of tagging and probably won't fit into Geelong's midfield too well

wombatsfc · 18/03/2017 at 15:48

Where do we get the stats for hitouts to advantage?

Matt · 18/03/2017 at 15:57

Thoughts Lads

DEF: Doch, Shaw, Laird, Tuohy, Hampton, EVH (Mackie, Watson)
MID: Danger, Sellwood, Treloar, Bont, Fyfe, M.Crouch, Beams, SPP (Grewar, Fox, Delcua Cardillo)
RUC: Nankervis, Witts (Strnadica)
FWD: Kennedy, Dahl, Steele, Taranto, Mccarthy, Eddy (Simpson, Pink)

Feedback really appreciated

    Brad · 19/03/2017 at 07:04

    Who are all your bench rookies!?

    SCB · 19/03/2017 at 09:12

    Your rookies need to play to make money to upgrade your team.

    SCDamien · 19/03/2017 at 11:53

    You need to have bench rookies who will play to earn you cash. I'd swap Docherty (because he will drop in price, so you should be able to pick him up later) or Tuohy (because he's never averaged over 85) to Marchbank and then fix your bench and then bank the remaining cash. Robbie Fox might be you're only bench player who might play round 1 providing any cover.

Stompers · 18/03/2017 at 17:05

Hi all,

What's every ones thought's on Gary Ablett this season, haven't seen much of him in any ones teams.

Will he be playing to much up front?

Cheers

    Northernsoul74 · 18/03/2017 at 17:56

    The round 9 bye is the big issue for me.

      Marcus · 18/03/2017 at 18:53

      do you need 22 players for round 9 or 18

        TRIGGER HAPPY · 18/03/2017 at 20:11

        22

    Danners · 18/03/2017 at 19:24

    More injury prone than ever and Round 9 bye

Dee · 18/03/2017 at 17:08

On ya Jock, great work mate…. Cheers!

Tyler · 18/03/2017 at 17:33

Thinking of starting both jpk and Hannebery its friendly on my byes! Last year started with danger and Selwood what's thoughts on this ?

    Northernsoul74 · 18/03/2017 at 17:55

    No issue, I've got Pendles and Treloar.

Suttoo · 18/03/2017 at 17:57

Do i go with PENDLES or THE BONT

Brandon · 18/03/2017 at 18:05

G'day all I've got a league I'm hoping to fill with some of the top 1% players from this forum!
I finished 982 last year so use that as a bit of a gauge.. If you finished top 1k or think you're gonna push close to it this year then join up!
280235
Cheers

    Jess_Coach · 18/03/2017 at 20:39

    Joined. Finished in top 20 overall last year.

      Brandon · 18/03/2017 at 21:59

      Sweet looks like its gonna be a strong league!

    Steve1 · 18/03/2017 at 20:46

    I joined, i was 828 last year

Justin · 18/03/2017 at 18:39

Currently have 120k sitting in the bank and I have no cover for sandi.. is it a good idea to go strndica to witts as r3?

    Derek · 18/03/2017 at 20:12

    kerp the cash

    If Sandi misses a week and you want to keep him, get Witts then. Might cost you a trade

      neil Demons Delight · 18/03/2017 at 20:42

      nank for roughy solves the problem

Doc · 18/03/2017 at 20:20

JJK or Buddy?

    SCDamien · 19/03/2017 at 21:30

    JJK by the skin of his teeth.

Formidableone · 18/03/2017 at 20:32

Jock. My magazine please or my money back. Either way, I don't care. THREE WEEKS since you took my money.

NickMacMan · 18/03/2017 at 21:03

Give me a hand boys!

Def- adams, laird, jones, marchbank, hampton, stewart (otten, VW)

Mids- danger, Treloar, fyfe, titch, lloyd, beams, JOM, SPP, (hibberd, parfitt, barret)

Ruck- nank, sandi (Strnadica)

Fwd- Dahl, Macrae, Caddy, rough, steele, pickett (black, eddy)

Rooks will change.

Not sure about touhy, j.hunt or johannisen for the back and ryder, hoskin elliot anf mccarthy for the forwards

Cheers

    Wilson · 18/03/2017 at 21:46

    Solid Team, wouldn't change the backs, Mayb move Llyod down there for VW or Otten, not shaw Otten will play, grab your self a WHE or Toranto, in the words of Croching this kid a bloody lock. Get rid of caddyshack for Ryder, cover a must for Nankilands

the nank · 18/03/2017 at 21:29

Is Dahlhouse worth pick 25 in a draft?

neil Demons Delight · 19/03/2017 at 09:26

there are two main issues left for us as we strive to get to a round 1 team. One of those is rucks.Believe me its driven plenty nuts but who do we choose Nankilands Gawndilands or Goldy gawn. Simple we strive to get to our two best prems and that's gawn/goldy. One issue has been the emergence of Spencergate and goldys injuries both of which have imo been overplayed however to have Goldy Gawn from the get go makes our forwards and defence thin particularly with the non appearance of quality rookies. So what do we do to get to Goldy Gawn so it doesn't affect our structures Byes and money earning cash cows.I think we must go with Gawndilands .Reason is simple Sandilands is a fallen prem Nank is not The other issue is rookies vs midpricers.In previous years this is where I have not had too great a problem .I read all the relevant material Jocks mag is the prime source with all the talent giving us their undoubted wisdom and attend as many tac and junior games as possible.I seen Cyrils cousin up Darwin 17 kgs overweight and he was brilliant now much much lighter Richmond have a potential star and this type of research is very relevant its what makes all the Jock Reynolds people gold. So 2017 we have crap rookies and potential doughnuts and midpricers raise their heads Which ones .My thoughts are FALLEN STARS. Up and coming Oliver types are rare and hard to pick whereas Swallow JOM types its only their future health that's is a concern. Cheers neil

    gator59 · 19/03/2017 at 09:38

    All very valid points Neil but i'm straying and going SandiWitts and Nan$Crevi$ at F5.. The rest of my structure i am happy with and we just have to sit back and see what rookies will be named and whether they look like having JS..

      neil Demons Delight · 19/03/2017 at 10:47

      Makes sense to have nank at F5 Good back up and good JS probably better than your high priced rookies TARANTO types who will be rested .Cant see that happening to nank

        gator59 · 19/03/2017 at 14:13

        Yep and i'm not having Taranto at all..

Wilson · 19/03/2017 at 11:58

I personally will be going with Goldielands I'm not at all concerned by don't bring me down Preuss, are we forgetting Currie in a hurry who played second Fidel to Goldy in the pre season tearing it up, only to be playing in the VFL now the poor bastard is up at the Suns being over shadowed by yet another Collingwood reject. I'm a bit of a risk taker usually I tend to think one year someone is going to break the mould of GNR and win it with Mid price Madness, I believe this year will be the year, a man or women will emerge from the shadows with balsy down right crazy selections in Steele, jones, Oliver , swallow , JOM the Nank the Nank for goodness sake billings Hell even Hickery smoked bacon.. This my friends will be the year that changes the game forever!!

    Swans2012 · 19/03/2017 at 18:49

    Hoping so, I'm running Steele, nank, rough sandi jom swallow and looking for a way to squeeze in higgins

greej14 · 19/03/2017 at 21:58

is Cam McCarthey and aaron black worth it??

    Wilson · 20/03/2017 at 15:19

    Not sure mate, C.Macarthey worries me 6goals for only 84pts obviously needs to kick a bag every week for enough points to justify selection , A.Black may not even play JS not as good as MaCarthey so for me it's a no to both, Would rather Go with a Taranto WHE or Turner around the same cash.

Sabsy · 21/03/2017 at 10:05

Thanks guys, love your work, and love the passion and generosity of this fine community.

Comments are closed.