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
Hi, any thoughts on my team
Foster
Debuchy, Jones, Skrtel
Henderson, Ramsey, Eriksen, Mata
Lambert, Diego Costa, Rooney
Bench
Krul, Wisdom, Shelvey, Upson
hey Dazza
Skrtel position could be under threat as its really 2 from 3 and Liverpool have some tough games to start and still cant defend for shit. Beginning to think it might be more lack of protection from mid. Lambert wont play up front. Remy is an option there if he gets pre season game time. If not look elsewhere.
Dazza
Marry me
A team without Luis
WoooHooo
Potty
Dazza,
I’m not convinced on three Liverpool players given their tough two away games in the first three. Also, in Henderson and Lambert I think you’ve picked the wrong two – Lambert will suffer from rotation and Henderson may be restricted in his attacking (and potential points) when Liverpool have to defend. To me, Sterling is a much more attractive midfield pick.
What do we think?
FDMS
Seems a good squad to me. Only a ? on Duff and perhaps Young.
No to Young for me. If he plays he is out of position the wrong way for me – he might have found his spot though as a position
Fab & Davis or Eriksen and Snoddy/Mutch? – not loving that Tadic now supposed to be on corners etc
Evening gentlemen!
Is anyone else here playing either the Ultimate game or is everyone playing ‘normal’ Premier league?!?!?!
Evening Peaky, I’m on UFPL as well but remind me next Friday as I keep forgetting!
I’m just playing the normal game but I’m going to try my hand at some NFL fantasy as well for the first time which looks like it could be a whole new different sort of headache.
I’ve not noticed many Ultimate teams on here to be honest though Dave.
Evening Peaky, I’m on UFPL as well but remind me next Friday as well as I keep forgetting!
Are you so forgetful you needed to make that comment twice, or did you forget that you wrote the first comment before you wrote the second?
It didn’t register and crashed! Sorry!
Tekno
He forgets which.
:finger:
Ok cool I wont be on my own then!! I will be doing the normal one but my main mini league has decided to go ultimate!
Peaks
You’ll find me on UFPL as well mate.
Excellent i’m not sure how many weeks i’ll concerntrate on both formats?!?!
Peaks
Could be difficult but the thought of money riding on it should be enough to keep us going
Yes,that always helps take the pain away
Posh Cockney
My Ultimate League code goes Social on Monday.
Potty
You claiming benefits for that too?
Has Floydeth been on at all? He said he wanted a RMT but I can’t see it anywhere.
Hi Cookie
I was on late tonight. Watched PSG then the last embers of the Blackburn match. Big league is nearly upon us!
Your thoughts on Snodgrass in place of Siggy for a week or two?
GP, personally prefer Siggy. Snoddy had never done anything for me and though it’s close between the two, Snoddy’s Europa involvement may just seem him get the odd rest.
Siggy has always done well for me mate.
Cookie
Fair enough and thanks pal.
I would have to go with Siggy against Man Utd or Davis at Liverpool currently.
Play Siggy vs Utd
Cookie
That’s how it has been sitting in my draft for almost a week now.
You loyal fool
Potty
I’m loyal to you Potty. No one has been taken to the cellar since I released you.