FanFooty Forum

AFL fantasy competitions => AFL Fantasy => AF Strategy => Topic started by: PowerMan on December 23, 2010, 06:49:31 PM

Title: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 23, 2010, 06:49:31 PM
been working on this over the last few weeks.

any comments to make this better would be appreciated!

(http://img408.imageshack.us/img408/1748/afldrawv3.jpg) (http://img408.imageshack.us/i/afldrawv3.jpg/)

Title: Re: 2011 AFL Fixture spreadsheet!
Post by: elephants on December 23, 2010, 06:54:21 PM
thats brilliant mate well done and thanks :)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Fletch74 on December 23, 2010, 06:59:49 PM
Well done PM. Thats awesome stuff ;)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Junktimer on December 23, 2010, 07:01:09 PM
great stuff Powerman
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: pyronerd on December 23, 2010, 07:09:16 PM
Quote from: elephants on December 23, 2010, 06:54:21 PM
thats brilliant mate well done and thanks :)
+1 it will be very useful to check byes great job PM  :)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: j959 on December 23, 2010, 07:18:19 PM
cool, thanks for sharing PowerMan.

going to be hard keeping up overall ranking scores with those multi-bye rounds 4, 5, 6, 16 & 19 ...   ???
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Justin Bieber on December 23, 2010, 10:32:20 PM
Cheers for this Powerman. An easy way to see the whole list in a small area and pretty easy to read :D.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Hawka on December 23, 2010, 10:45:46 PM
great work  ;)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: nas on December 23, 2010, 10:55:25 PM
Solves the problem Ta
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 24, 2010, 11:17:07 AM
Is there anything that needs to be done to improve it a touch.

If anyone thinks of anything please let me know!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 24, 2010, 11:19:13 AM
Quote from: j959 on December 23, 2010, 07:18:19 PM
cool, thanks for sharing PowerMan.

going to be hard keeping up overall ranking scores with those multi-bye rounds 4, 5, 6, 16 & 19 ...   ???

Not really, if you pick your premiums from the clubs that are included in those multiple bye weeks you should be fine.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: j959 on December 24, 2010, 11:59:42 AM
Quote from: PowerMan on December 24, 2010, 11:19:13 AM
Quote from: j959 on December 23, 2010, 07:18:19 PM
cool, thanks for sharing PowerMan.

going to be hard keeping up overall ranking scores with those multi-bye rounds 4, 5, 6, 16 & 19 ...   ???

Not really, if you pick your premiums from the clubs that are included in those multiple bye weeks you should be fine.
for league games i'd be ok but I've seen somewhere that they will still count towards scoring for people's overall ranking.

here's a link to the topic where i was asking people for thoughts on it:

http://www.fanfooty.com.au/forum/index.php/topic,23237.0.html
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Junktimer on December 24, 2010, 01:03:59 PM
powerman i reckon you should have derby/showdown game for carlton v collingwood, carlton v essendon, collingwood v essendon.  always big games
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Hawka on December 24, 2010, 01:18:16 PM
and hawks essendon ;)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: pyronerd on December 24, 2010, 01:20:15 PM
Quote from: hawka26 on December 24, 2010, 01:18:16 PM
and hawks essendon ;)
he said showdown not punch-up  :P
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: nas on December 24, 2010, 01:22:45 PM
Quote from: Junktimer on December 24, 2010, 01:03:59 PM
powerman i reckon you should have derby/showdown game for carlton v collingwood, carlton v essendon, collingwood v essendon.  always big games

Or just make it the 2 rounds that the afl use :> Rivally rounds. Be all over the place other wise using others. IMO
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Junktimer on December 24, 2010, 01:40:08 PM
yeah but north melbourne verse bulldogs is hardly a rivalry, only the big ones i mean
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 24, 2010, 02:19:15 PM
Quote from: Junktimer on December 24, 2010, 01:03:59 PM
powerman i reckon you should have derby/showdown game for carlton v collingwood, carlton v essendon, collingwood v essendon.  always big games

Would it be a good Idea to bold the games that are played in Tassie?

Title: Re: 2011 AFL Fixture spreadsheet!
Post by: nas on December 24, 2010, 02:35:16 PM
imo > no
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 24, 2010, 02:38:23 PM
Quote from: Junktimer on December 24, 2010, 01:03:59 PM
powerman i reckon you should have derby/showdown game for carlton v collingwood, carlton v essendon, collingwood v essendon.  always big games

I thought If i done that it would look to messy and hard to read!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 24, 2010, 02:40:47 PM
I can email this to those who want this as well, just PM me your email address and it'll be done.

Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Cicjose on December 24, 2010, 08:22:46 PM
Can you mark out the rounds the DT finals are in Powerman plz?

Fremantle have a tough run home after their second bye
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on December 26, 2010, 11:24:05 AM
Quote from: Cicjose on December 24, 2010, 08:22:46 PM
Can you mark out the rounds the DT finals are in Powerman plz?

Fremantle have a tough run home after their second bye

people should know when DT Finals are!

Title: Re: 2011 AFL Fixture spreadsheet!
Post by: nas on December 26, 2010, 05:14:53 PM
Quote from: PowerMan on December 26, 2010, 11:24:05 AM
Quote from: Cicjose on December 24, 2010, 08:22:46 PM
Can you mark out the rounds the DT finals are in Powerman plz?

Fremantle have a tough run home after their second bye

people should know when DT Finals are!



Clap clap
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Barlow 21 on December 28, 2010, 11:19:07 AM
Great work Powerman! Really easy guide to the fixtures.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: bomberboy0618 on December 28, 2010, 07:56:21 PM
nice work powerman :)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on January 04, 2011, 12:08:19 PM
Have updated the spreadsheet with a newer version of it.

It now includes Home where it isn't normally regular venue, with the exception of Geelong games at Skilled Stadium, which I've also added!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Justin Bieber on January 06, 2011, 12:54:29 AM
Nice addition Powerman. Really like the Skilled Stadium games as that is normally Geelong's fortress and especially if people are looking at Pods :P.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on January 06, 2011, 02:01:42 PM
Quote from: Hellopplz on January 06, 2011, 12:54:29 AM
Nice addition Powerman. Really like the Skilled Stadium games as that is normally Geelong's fortress and especially if people are looking at Pods :P.

also Bartel seems to play well there as well. Trying to make it as simple as possible for people to make there teams.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: RiOtChEsS on January 06, 2011, 02:47:48 PM
awesome effort PM love the new DP too :)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on January 06, 2011, 04:13:40 PM
Maybe this could be stickied for easy finding for when the season starts?
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: bomberboy0618 on January 06, 2011, 04:57:11 PM
Quote from: PowerMan on January 06, 2011, 04:13:40 PM
Maybe this could be stickied for easy finding for when the season starts?
pm m0nty or prospector_1 if u want and they will do it.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: j959 on January 06, 2011, 06:17:45 PM
Quote from: bomberboy0618 on January 06, 2011, 04:57:11 PM
Quote from: PowerMan on January 06, 2011, 04:13:40 PM
Maybe this could be stickied for easy finding for when the season starts?
pm m0nty or prospector_1 if u want and they will do it.
+1 my vote
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: dylsta05 on January 06, 2011, 06:28:50 PM
will help alot, that mate!!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on January 19, 2011, 12:06:14 AM
bump, trying to keep this near top of the page.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: ShaynoB on January 19, 2011, 06:27:12 PM
Thats awesome. Thanks PowerMan. Will help everyone out. ;)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on February 17, 2011, 11:24:57 AM
bump
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Bazinga on February 17, 2011, 11:31:10 AM
You should request for this to become a 'sticky' PowerMan.

Its a great tool and i'm sure many people use it  ;)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Wes Mantooth on February 18, 2011, 01:49:49 AM
i am working on the ultimate spreadsheet...

MUAHAHAHAHA (mad scientist laugh)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Mish on February 25, 2011, 12:03:50 AM
awsome stuff man!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: chrisuzz on February 25, 2011, 09:56:09 PM
Thanks PowerMan good stuff :)

Just out of bad memory ::) is the rounds where there are 3 byes, no league games are played ?
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Zarts on February 28, 2011, 03:42:29 PM
yeah.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: boo-yaa on March 03, 2011, 02:28:27 PM
nice work mate.
whcih teams do you fellas think have an 'easy' draw?
and on the other hand who has a bad draw?
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on March 20, 2011, 11:55:02 AM
bump again!
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: TMurphBROWNLOW on April 19, 2011, 06:49:31 PM
i love referring to this page :)
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on April 26, 2011, 12:59:14 PM
Quote from: TMurphBROWNLOW on April 19, 2011, 06:49:31 PM
i love referring to this page :)

It'll become handier later in the year when our trades start to run out.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Master Q on April 26, 2011, 05:28:59 PM
Quote from: PowerMan on April 26, 2011, 12:59:14 PM
Quote from: TMurphBROWNLOW on April 19, 2011, 06:49:31 PM
i love referring to this page :)

It'll become handier later in the year when our trades start to run out.
Yeh that's true.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: Ziplock on May 02, 2011, 12:12:12 PM
bump
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: PowerMan on June 13, 2011, 12:57:37 PM
this is proving so handy with my trade decisions at this time of year, so glad I made it up now.  ;D

Will most def do it again next season.
Title: Re: 2011 AFL Fixture spreadsheet!
Post by: TMurphBROWNLOW on June 13, 2011, 04:58:49 PM
nice! :)