Fixture Tracker – Fantasy Premier League 2014-15
We’ve all seen a few different ways of viewing upcoming fixtures, and the one that has become increasingly popular over the last couple of years is the colour-coded one. With this, you can instantly see each team’s approaching fixtures with an accompanying colour that corresponds to the difficulty of each match. This is very useful for both identifying teams that are potentially about to have a great run due to a kind set of fixtures, and also identifying weaker teams that can rotate well, i.e. when one team has a bad fixture the other will have a decent one, so you swap between the two players. For more info on rotation, check out Mito’s somewhat exceptional article on it 😉 Rotation Analysis Home and Away and Favourable fixtures
Many of these colour-coded tickers only show a few weeks in advance, which is very helpful for short-term plans, but not if you’re planning transfers for the long-term. It is understandable that these tickers are short-term, as teams’ form tends to fluctuate as the season progresses, so if you made a season-long ticker now, it may well not be a good reflection of how difficult a match is come Christmas or Easter. Who knows, maybe Villa will get off to a blinder and win 10 out of 15 (hahaha!), in which case a game against them would no longer be considered easy. Also, sometimes we may even disagree with the colour a certain match has been assigned by the fantasy football gurus that make the tickers! The ticker I have made is designed with both of these points in mind, and can be updated throughout the season as and when you see fit.
Customisable Tracker
Some of you may already have seen my earlier prototype after I posted it on the boards last week (much to init’s dismay :p ) – I have since added all 38 GWs to the tracker, modified the colours used and added a new custom search for individual teams, so even if you had the original please do use this updated version instead.
And it works like this: I have split up all 20 teams into four groups of similar ability, and then given every possible combination (of which there are 32) a difficulty rating of between A and E (5 difficulties as opposed to 3 for greater accuracy). Both of these factors are the variables that you can change, and doing so will automatically update the colours in your fixtures tab. Simply click on the ‘Variables’ tab as shown in fig.1, change any of the values in the cyan-coloured columns shown in fig. 2,
and you will be able to view your very own customised 38 GW fixture tracker as shown in the main image above. This is all explained in more detail in the ‘How It Works’ tab. Finally, I have made a ‘Compare Fixtures’ tab as well – this allows you to select only the teams you wish in order to see just how well they compare and/or rotate, without having the distraction of all 20 teams’ colours present. If you wish to use this tool then select the ‘Compare Fixtures’ tab and then click on the ‘Add Team’ drop-down menu as shown in fig. 3 and choose the team you want. You can do this with as many or as few teams as you wish. Though it seems rather simple, I found this last feature very tricky and would not have been able to make it work as well as it does without the help of Dreamers, so a huge thanks to him!
I have made the link read-only, so as to preserve the template in its original format for everyone in case the formulas stop working. Just save your own version of the file, and you will be able to customise it entirely as you see fit. Please bear in mind that this was made with Google Sheets and is intended to be used in that format so it can be saved in favourites for easy access; if you download it with Excel then the margins and borders will probably be off so will need adjusting. I am always open to suggestions for ways to improve it, so feel free to send me a message or post a comment below to that effect if you have any ideas. And finally, I have double- and triple-checked the fixtures, but there are a lot of them and after a point they all tend to blur together, so if you spot any mistakes please let me know as soon as possible!
Click the link below for the file. Hope it helps a few of you, happy customising.
Fixture Tracker – Fantasy Premier League 2014-15
this is some mind blowing stuff CC. nothing i say can depict how awesome this is.
i LITERALLY bow down to you sir.
we are all forever indebted.
it is because of all you guys and your efforts that this site and community is so brilliant.
keep it up guys. the site is really leaping ahead.
Can’t disagree with any of that jasprit! Fantastic work Calvin, I think you’ve done the community a great service here and provided a brilliant tool that I’m sure will be used over and over by a great many. Thanks mate!
+10000000000…… Well said Jasprit. Couldn’t agree more.
What a great tool Calvin, I literally can’t wait to get into work in the morning , download it and try it out ! I can tell you for sure I ain’t getting much done tomorrow !
Definitely a very helpful tool…the generosity of people on this forum always amazes me…everyone wants to win but it doesn’t stop anyone from helping each other out! Can’t wait to play around with this little tool!
Thank you for the hard work Calvin. Great job. Now please learn me math… 😛
Anyway, I’ve done 2 RMT”s and both times while placing it another article is being published. Are the FF247 mods secretly conspiring against me? Just saying. Darn it, bad luck.
there, there.
Sorry Raz! Wasn’t meant to be :p And yes we just sit here waiting for you to RMT then scramble like hell to publish!
Lol
I’ll live to fight another day…….. KEEP THEM ARTICLES COMING!!!!!!!!!!!!!!!!!!!!!
Oyasumi nasai
You’re in charge of scheduling now Raz, you do a RMT – we publish a new one 😉
CC,
This is OUTSTANDING. What a gem of an idea which has been turned in to an invaluable tool. And it is interactive as well!
This will be used throughout the season and seasons beyond.
This is the sort of stuff I suspect that ‘other sites’ will charge you a yearly membership for so for it to be here, for free, with all these great people, great ideas and top banter.. Just makes me happy that I found this place and / or it’s riots all that time ago..
Keep up the good work guys, it’s massively appreciated. All of you. (But esp Calvin as he done all the work on this one ;))
Demsie you owe us £12.50 :hippo:
Ha ha. . Damn it ! Me and my bloody big gob !!
To be fair I’ve already shelled out a fiver which I’ll prob never see again so we can call it £7.50 😉
Yeah that was for the league.. New shoes for Mrs Init !
Calvin, this is top drawer stuff mate. I wouldn’t even know where to begin with something like this so your hard work is seriously appreciated.
It it top draw or top shelf?
Anyway, it is awesome!
I normally use .ods for stuff like this but the fixtures wouldn’t format properly for me, worked fine with .xlsx though, did we really need a blown up version of that avatar
Quality tool though, thanks.
I do feel a bit sheepish about that haha, but in all honesty it took almost as long making that stupid avatar as it did making the spreadsheet so had to get it some coverage 😉
Wow what a tool! And the fixture tracker isn’t bad either 😉 Joking aside I’ve genuinely seen other sites charge for this type of thing so it’s really amazing to get this for free. Top work CC
Griff
Fernando do you rate him or not?
Potty
Hello Potty, how are you? From what I’ve seen as a solid CDM Fernando is a good player and is just what we need in our squad instead of Javi Garcia. As a Fantasy Football player though I don’t think he’ll be a high scorer.
Hi Griff
Feeling strong at present.
Fernando’s price of 5.0m is so tempting and he just may turn it on.
Also due to me not currently working he’s all I can afford.
Potty
Good to hear. Didn’t actually realise that he was only 5.0m which has now got me thinking. If he plays he will surely get involved in some goals, especially from set pieces. He’s probably no worse than any other similarly priced mids.
Potty I didn’t realise it was all based on income! May explain the odd tax dodgers success last season then? #Cookie
I wonder if Cookie is on a tight spending spree also?
Potty