MattyB’s Essential Supercoach Team Picker v2.0

Published by Patch on

This is something, folks. Every stat. Every score. Every time on ground percentage. Heck, if a player’s breathed during the JLT series, MattyB’s recorded it as a statistic.

He’s released his version 2.0 of the his team picker and this is ESSENTIAL reading, viewing, utilising and anything and everything else.

Instructions are in the document and remember to use the tabs down the bottom to flick around to where you need to go.

Click through to download MattyB’s team picker HERE.

EDIT: “From MattyB It’s a version of the Team Picker without the autofill macros. Seems like a few people are having problems with that aspect, so this might make it easier for them.”

Download that version HERE.

You can download the file without a dropbox account, too.

Categories: Supercoach

Notify of
Newest Most Voted
Inline Feedbacks
View all comments

Uhmm, not sure if it is intended, but the Download requires me to open a Drop box account…


At the bottom of the registration popup it lets you click through without creating an account, then Download from the top right.


Yep, as Jel says, you should be able to download it without signing up to Dropbox. I just figured this was a better way to distribute it, as knowing me I'm likely to have made a mistake and I can fix it quickly this way. πŸ™‚


Love a good spreadsheet, and this is a cracker. Well done MattyB.


Its a great spreadsheet, but I just get errors when I try to enter players names from the drop down list in the starting team tab. Any thoughts appreciated.


Let's see if I can fix this for you. What do the errors say, Rob?


Doesn't seem to find the player when I enter the name. Just shows #NAME? in the index/match columns for role, price, club etc. Maybe no-one else having the same problem (I also tried your no macro with similar results). Might try and fix it myself, I have a little excel knowledge. Still an awesome spreadsheet though. πŸ™‚


Very weird. There is Data Validation on those cells which is linked to the same list that is used as the Lookup list. That shouldn't be able to happen.

Which player was it?


Matty, yes it did seem strange coz it looks fine, however I've done a fix. Seems my version was putting the text _xlfn.IFNA before each index statement, and some inverted commas at the end. When I got rid of these bits, it now works. Thanks for replying. All the best.


Ok, IFNA is an Excel 2013 formula. I was only thinking about Index and Match.

I'm going to fix all these up right now.

Thanks Rob. πŸ™‚

Great fact hunt

Mattyb this is s&$t hot. You are a gun. Thanks heaps for your effort it is a great help. May the supercoach gods be with you.


Is this supported on Mac? I'm running up to date Excel and having issues, saying it contains content that this version of Excel doesnt support, and only able to open read only. I do that and when i click to add players it sends me into Microsoft visual basic saying Compile Error: Method or data member not found.


Mac version issues? I'll be completely honest and say I've never dealt with compatibility issues between PC and Mac versions of Excel.

This was built on Excel 2013. What version is your Mac running, Grizz? I'll see if I can find a way to test it at my end on a Mac.


Looks like i'm running version16.22 mate. I'm a noob with Excel so no idea if it's a compatibility issue, was just my first thought haha.

Thanks legend!


Just thinking about it, I'll make a version without the Visual Basic macros, just the data and formulas. That should make things run a bit smoother.

Should still work the same, but you'll need to scroll through a list rather than type and have it auto fill half the name. I'll post a link here.


Got no issues scrolling mate! That would be awesome, you're a bloody champ!


Try this one then, Grizz. πŸ™‚


Thank you mate! Will download this arvo after work and let you know how I go!


Hey Matty B, great spreadsheet, all the stats at a glance , time for me to procrastinate.


Cheers MattyB, been waiting for this one!


Love the spread sheet, you legend!
just a quick question, would you happen to know how to update it so when looking at JLT stats you only see each players name once per row and totals and averages are summed together.
thanks mate.


Hey Sam, do you mean more like what I did with the Rookie Watch tab? I'll have a look at it tonight and add a new tab with all the players summarised. In reality, probably should have done that in the first place, and just let users filter by Rookie to get the same result as the Rookie Watch tab.


Great Job
However I can't seem to get the rookies to sort from highest to lowest average
Any tips!!


Long time reader, not an often poster.

This is awesome and I wanted to say thank you. Terrific stuff.


Awesome post admin thanks for sharing.