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
Young,silva,hazard and terry
Or
Mata,eriksen,fabregas and jose enrique
@Farhandowski
I think you can have the argument about the merits of having Baines. So I will leave him alone despite his fixtures. Doubling up with Howard is a whole different deal. Everton play CFC, Arsenal, Liverpool and Man U in four of the first seven games. You will probably want to avoid these fixtures, so I would suggest you either change Timmy for DDG or get a back up keeper you can rotate with Howard since Myhill is not a starter.
Ince and Dummett are rotation risks. Ince could very well become a permanent starter, but time will tell and with the uncertainty that comes with week 1 of FPL regarding all teams, I would say go with a safer bet for now until you are sure that he definitely has the starting role. Dummett could play, but who knows. If he is playing he is not the worst to have because he is on some set pieces, but there is a big question mark whether he will get the minutes. Bruce & Wisdom are even bigger rotation risks than the aforementioned. Wisdom is expected to go week 1, but no guarantees after that. Bruce has tough competition in his spot and his playing time depends on formation many times. If they play 3 in the back he tends to be included. When they play 4 he tends to lose his spot.
The rest looks good to me.
Fabregas+5.5 forward
or
de Jong/Tadic+ Reviere/Pelle
Fabregas and bojan
Hi FDMS All Starz, my concern is no t much forward have great points in past few seasons with price below 7 except Lambert given Bojan preseason form is good
You would expect him to have a good start to the season, if other cheap players hit form you can always just swap.
Yes, looking at first 13 weeks, perhaps the only away to City, Spurs and Liverpool consider tough. Actually I still got Siggy, Eriksen, Mata and Silva on board, just might want downgrade a 8-9 midfielder to boost forward or in defense especially the only premium defender I have is Jones. Thoughts on that?
Oh Lordy – is it that time of year already?
Off on my hols tomorrow so not here for the start of the season and no guarantee of getting online – how does this look for a season starter? Have left myself £4.5 million in the bank so can bring in pretty much whoever I want later – most likely a Liverpool player after the 3rd gameweek.
Any thoughts?
Cheers
Robbo
Robbo,
I would get Bojan instead of Weimann. Bojan has hit the ground running at Stoke and rotates perfectly with Siggy as your 5th mid.
I wouldn’t leave the money in the bank, spend it and maximise point potential. I would try and get a Chelsea mid or striker in there if you can, probably at the expense of Snoddy.
Good luck and have a great holiday – hopefully see you when you’re back, especially if Red Robbo means what I hope it does! Captain Marvel?
Cheers,
Cookie
What do you guys think about Bojan, Im not too convinced with him.. But who knows? maybe his breakthrough is at Stoke!
His pre season form is good
My problem is his position, I think he’s being played in a wider role for Stoke rather than in a central position (Similar to Sterling) so far so he might be looking good whilst Stoke can dominate the opposition but I’m concerned that Stoke won’t be able dominate that much week in week out in the EPL. His form so far can’t be denied though.
Afternoon all…….. I can’t make up my mind between Herrera and Sanchez or Mata and Ramsey……. Heeelp!! Keep swapping them back and forth
Mata and Ramsey for sure.
Cheers
I would go with mata and Ramsey