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
West Ham have agreed a deal to sign Morgan Amalfitano from Marseille on a free transfer, according to Sky sources.
Im happy with the core of my team, I dont forsee to many changes from here on end by I do welcome any opinions and suggestions
Slow Poison – Having just one United player is a red flag, for me. I’d also ditch Sterling, Barkley, Toilet and Austin. Rooney and Sigurdsson instead of Sterling&Dzeko would be a good start.
Alright Slow,
Looks good, mate. A few choices I’ve been looking at but haven’t seen a lot around here. Clyne could be spot on, especially if Southampton manage to keep their pressing game going with energetic youth, they could be good clean sheet potential and Clyne will play higher up. I’ve also looked at Austin, but I’m still unsure if he’s a better option for £0.5m greater than Bojan.
My only issue is Barkley, I think he’s overhyped and he has a lot left to do on his game. For Everton I feel Mirallas is a better option, although £0.5m more in price, but then since you have Hoilett, you can swap Austin for Bojan and that’s that sorted.
Well done buddy, looks great.
Thanks mate, Il have a look at those options
Agree with every point!
But especially with his last? 😛
What about Fraizer Campbell tho, Im not too convinced with Bojan.. But who knows? maybe his breakthrough is at Stoke!
I don’t think Mirallas or Lukaku will be starting for Everton in GW 1 this season, neither have been involved in any of the preseason games so far, they might get some game time today against Paderrborn, but I wouldn’t expect them to be rushed back into the starting line up with Everton being involved in the Europa league this season.
Hi everyone,
This is my current team. Any Saints/WBA fans know about Targett and Wisdom starting? I could change Cahill to Luis to free up some extra cash in my defence I’m just not sure that Luis is nailed on… Any suggestions on the team would be appreciated.
@ItsMero
IF you are going to play Bego, I suggest you get a second keeper who plays. Stoke City is still living off the defensive fame they received two seasons ago. Last season they allowed 52 goals, that is more than Liverpool who many made fun of for being terrible in the back. Now that doesn’t mean that Bego is not worth having. Because when we look at the numbers closer we see that at home Stoke was very good. They only allowed 17 goals which made them 4th best in EPL. Their problem was on their travels where they were fourth worst allowing 35 goals. Only the three teams that went down were worse. So a rotating keeper for his away games looks necessary. You will find a list of options in this article https://fantasyfootball247.co.uk/rotation-analysis-home-away-rotation-favourable-fixtures/ but off the top of the head I say go for the Swansea keeper as he rotates perfectly with Bego.
Manquillo won’t start right away and Liverpool’s fixtures are not great in the opening weeks, so I would stay away from them for a bit if not forever. 😉 Moore could do well over the long haul but don’t expect much from him at the beginning as 4 of his first 5 are against Che, Eve, Ars and ManU. Cameron is not a sure starter, in fact popular opinion is that he won’t. There is no way I would double up on Liverpool in the midfield. Maybe Sterling, but with their opening games definitely not Coutinho. Wilshere has the 3 of the worst plagues of fantasy football. Injuries, rotation and sits deep. Don’t disagree with any of your strikers but make sure you find a place in the midfield or even at striker for I least one Manchester United player, their fixture list is super tasty.
No United attacking force will kill you.
Very good points Mito, and well made too.
Owwww ffs, I need to stop looking at my team. Wasting time, lol.
Have a nice day peepzzzzzzzzzzzzzzzzzzz. 😉
See ya again………………………………………………
soon…………………………….
Hey guys…
Could do with some constructive critique on this team please…
Chambers maybe the suprise bargain of the season…?
Especially with Mr. Wengers being very complementary of the young
Lad, & his versatility along the back, plus Vermalean gone & Merts not 100% / WC fatigued ….he’s got to be worth 4.5m …. If he does well bonus…if not easily swapped out..!
Hi Bigpopz, loving the front 7, very strong. Probably worth the gamble with Chambers as you say. I’m guessing you’re not far off settled with that team now?
Initt,,,
Yea pretty much done …. Unless there’s some must have new arrivals over the next week..?
Still tinkering with defence…
Happy with goalies / Mids / Fwds…
I’m really tempted to squeeze in Lovren for either Davies or Caulker…..but need an extra 0.5m…
What’s your thoughts on Lovren / Liverpool defence this season..?