SuperCoach Team Selector 2014!

[Purple 77]

Hey all! I know I'm a bit late last year, but laziness and now Uni slowed my production of an excel spreadsheet that helps you select your SuperCoach team. Also, the SuperCoach site made it particularly harder for me to copy and paste what I wanted, so pretty much all of the data you see I manually put in. Mistakes? Maybe. But I did try a little harder to make sure I eliminated those mistakes, such as having the wrong average, games played, total points, AFL team, Bye Round associated with the wrong player.

I will gladly guarantee it's 95-97% accurate, if not, higher.

How this spreadsheet differs from a few that I have seen, is its main feature to look at where you're spending your money at what positions.

To pick a player, simply put a "1" in the SELECT column only. Try not to write anywhere else, as there are "invisible" IF functions that a wrong "1" placement will erase.

Hopefully, as you start to use it, you will get the gist of it and how it works.

Credit should go to ossie85 , for creating the original spreadsheet that I have expanded on, and for also allowing me to use his website for the Elxam League to make any downloads possible  :)

If you have any questions or see any mistakes, please post them in this thread so other people can see, and if it's a really big  mistake, so I can fix it.

So without further ado, I present

The 2014 SuperCoach Selector

Enjoy!

[ossie85]

Been wanting this for a while :) Far better than the website IMO.

Cheers Purple, might actually move this to rate my supercoach now I think about it....

[Ringo]

Thanks Purps and well done.

[Ringo]

Just noticed Nahas missing from Forward line Purps.

[Purple 77]

Just noticed Nahas missing from Forward line Purps.

Huh. That's strange. My apologies for missing that one. If a few more mistakes arise, I will update the spreadsheet, because I remember last year I did a lot of fixes and reposting it is a little bit of a hassle.

But if people are feeling like a DIY;

Highlight the entire Nathan Bock row by clicking row 179. Click 'insert row'

enter:

NAHAS, Robin   NTH   R8      236   6   39.3   $212,200

And copy and paste the information you see in Fasolo's row, the two columns that have $0 and 163 in them, down onto Nahas's row.

Hope that makes sense, apologies for the error

[ossie85]

But if people are feeling like a DUI;

Uni life suits you bro (DUI = Driving Under Influence) :P Think you meant DIY!

[Purple 77]

But if people are feeling like a DUI;

Uni life suits you bro (DUI = Driving Under Influence) :P Think you meant DIY!

Lol, maybe I am DUI after that  :P

I did mean DIY, and I said that in my head as I was typing it lol

[SydneyRox]

Awesome work Purp!! Love it! :)

[mancityfc]

can't seem to get passed the backs ? how do i find the other positions?? thanks

[maygs]

Tabs along the bottom (left)

[BigBob]

Missy AWOL? ::)

[ossie85]

Yeah, this is the old thread :) Mods can we unsticky?