FanFooty   FanFooty
Australian Rules
Fantasy Football
Blog Forum App
 
Welcome, Guest. Please login or register.
Name: Pwd: Login for:

    Advanced search
Home Help Login Register
+  FanFooty Forum
|-+  FanFooty
| |-+  Archives
| | |-+  Supercoach Archive
| | | |-+  2010-2017 Supercoach Archive
| | | | |-+  Excel SuperCoach Selector 2013!
« previous next »
Pages: [1] 2 Go Down Print
Author Topic: Excel SuperCoach Selector 2013!  (Read 9268 times)
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« on: February 14, 2013, 07:48:48 PM »

Hey FF SuperCoach community!

Some of you may remember last year, I made an excel system that can help pick your SuperCoach team. With it, you can keep track of your spending and have just a general fiddle in trying to make that winning formula. Like I said, its an excel system..... meaning you can take it to school/work and it actually looks like your working! Possibly the best part about it lol.

Now, the possible errors.....

SuperCoach has made it harder for me to copy and paste the information I want, so I had to manually put in most of the data, so an error here and there is likely. The errors to look for should be fairly minor, such as Sam Mayes being labelled a Geelong player or any wrong team associated with a player. No real problem there. Same goes with games played, averages and total points as they may also be wrong/associated with the wrong player, as I also had to type that in manually (nearly cost me my sanity). But all in all, I can confidently say that it is 95% accurate. Who knows? It may be 100%. So if you come across any errors, please post it here so everyone else can fix it :)

How to use....
There are 4 tabs; Backs, Centres, Rucks and Forwards.
In each tab, whenever you want to select a player, simply put a "1" in the SELECT column. Common mistakes are people making a selection outside of the select column into a cell that has an "invisible" IF function, so when they delete their wrongfully inputted selection and put it into the select column, the selection or something else won't register.

Also, you will notice that when you select a player in a position, every other cell in the corresponding position list also fills up with that player name. So don't panic if that happens, its just easier for me for that to happen lol. When you make more selections, the player names will fill up those spots that were copies of another player in that list (I know, the sentence doesn't make to much sense lol)


I think thats all..... oh wait! The spreadsheets...

A thank you should go to ossie85, as I am using his website to host these spreadsheets so they can be downloaded.

SC Selector (2003 Compatible)

SC Selector

If any questions, please ask me or if any errors found, also let us know  :)

Cheers guys!
« Last Edit: February 16, 2013, 06:56:47 PM by Purple 77 » Logged
ossie85
Bob Rose
Seasoned Coach
****
Offline Offline



I am Groot

« Reply #1 on: February 14, 2013, 08:00:37 PM »


I find these easier to sort your team out :)
Logged
My Chumps
Experienced Coach
***
Offline Offline



Please God show me the way

« Reply #2 on: February 14, 2013, 09:59:17 PM »

Awesome work Purps! I'll be sure to use it  8)
Logged
Ringo
Chat/forum mods
Coaching Legend
*****
Offline Offline


2014 RDT Elxam m0nty medalist

« Reply #3 on: February 14, 2013, 10:22:39 PM »

Just a slight adjustment is it also possible to add a column for bye rounds.

Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #4 on: February 15, 2013, 05:36:37 PM »

Just a slight adjustment is it also possible to add a column for bye rounds.

I can if you like! Will be done either tonight or on Sunday. Will let you guys know :)

Thanks MC :)
Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #5 on: February 16, 2013, 06:57:26 PM »

Ok, as per Ringo's request, the byes are now added in :)

Again, let me know if there is any problems etc.
Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #6 on: February 24, 2013, 11:58:22 AM »

Just out of interest, what is the download count os? Think we reached 360 last year?
Logged
ossie85
Bob Rose
Seasoned Coach
****
Offline Offline



I am Groot

« Reply #7 on: February 24, 2013, 03:08:28 PM »


A smidge over 200 :)
Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #8 on: February 24, 2013, 05:05:58 PM »

Oh nice! Was only expecting 50 at this stage lol
Logged
ossie85
Bob Rose
Seasoned Coach
****
Offline Offline



I am Groot

« Reply #9 on: March 16, 2013, 06:31:51 AM »


371 downloads Purple
Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #10 on: March 16, 2013, 10:58:36 AM »


371 downloads Purple

Oh awesome! I think we have surpassed last years download count now  :D
Logged
FisherSaints
Guest
« Reply #11 on: March 16, 2013, 03:09:29 PM »

Looks really good Purp
Logged
Purple 77
Seasoned Coach
****
Offline Offline



He's dead

« Reply #12 on: March 16, 2013, 04:23:54 PM »

Looks really good Purp

Thanks FS! Oh, and by the way, I just found a mistake today about the spreadsheet, that surprisingly no one has picked up on.

In the Ruck averages, I have the formula wrong, so apologies for that. But it can't be to big of a deal if 370+ downloads hasn't said anything about it.

To fix this, simply enter (for one row containing one player);

="The Total Score cell" / "The Games Played Cell

And copy and paste down the column
Logged
mabo
Property Steward
*
Offline Offline


Fantasy coach

« Reply #13 on: March 17, 2013, 09:28:47 AM »

Thank you for posting this Purps  :)
Logged
benjy251090
Hardened Coach
***
Offline Offline



Anatidaephobia - Occurs to hot chicks too

« Reply #14 on: July 15, 2013, 08:01:22 PM »

When is next years one coming out, looking forward to next year already :P
Logged
Pages: [1] 2 Go Up Print 
« previous next »
 


FanFooty Contact Us About Us Advertising Site Map Copyright © 2004-2011 Paul Montgomery.
SMF 2.0 RC5 | SMF © 2014, Simple Machines