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
Is there any logic in this team? oh and how would you try and fit Eriksen in this team
No logic whatsoever Slow, delete all + start again.
Not my team man, a mates team, he asked me for help to put Eriksen in
the classic “asking for a mate” yeah course.
just joking slow :big-lol:
having said that its not that bad a midfield….forwards and backs however…
The only problem I have with this team is Mirallas, I heard that he will miss the start of the season, so I dont know how to replace him but still have Everton attacking coverage… Barkley maybe?
quite an expensive defence, could you not downgrade one of your 5’s (clyne—>yoshida? ward–>mariappa or davies?!) raise that 0.5 to get eriksen.
Ok, this is my team, experimenting in forcing a 343, so bojan—>dzeko. how do i recover the 3 mil. the obvious move seems to be silva–>snodgrass. all done. any geniuses got any genius moves?
Hi Haz something has to give Hazard to Sterling , Shaw to Debuchy & Luis to Davies or Clyne You could chance Costa if you what to keep your namesake
Alright, so I’m undecided on my midfield as you can see. I’m a huge Yaya fan and can’t see my team without him but not having him frees up cash for others. What would YOU do? How would you recover the 4.5mil?
blackillusion – I’d drop Yaya and improve your defence. Did you watch the game yesterday? He was terrible. Really bad World Cup too and with all his shite talk in the media, maybe his head isn’t where it should be. At the moment, 11m is looking like a hugely inflated price, for me. I’d bring in Cesc/Hazard and improve your defence with the change.
Can’t bring hazard or fab in till I sell someone else as well.
blackillusion – What do you mean? Both are cheaper than Yaya!
But I’m already over by 4.5mil
Even if I do get Fab, I would still need to lose 2.5mil from somewhere else. See my dilema?
Oh yeah, silly me. Right, i’d just go without him. Those strikers + Yaya is a killer for the rest of the squad, plus he’s been out of sorts since the end of last season. If you were to pull 4.5m and still keep the forwards then i reckon you’d be left with a really weak squad. It’d mean relying on 4 super expensive big hitters every week when most would have strong 11’s out.
Definitely downgrade Yaya and one of the forwards.
Yeah I agree. Would you recommend selling costa or sturridge?
I’d probs sell Studge and yaya, bring in Dzeko (for example) and a 9 mil mid, and use the extra cash to upgrade defense.
Look better?
Hmm, looks good, wouldn’t say better, cause you have lost 4.5 mil of upgrades, but it still looks good. Perhaps Ward to Davies (spurs), and maybe one of the 9 mil mids down to sterling, then upgrade O’Shea.
blackillusion – Well, you’re not 4.5m over budget now so yeah, much better. Having said that, it’s still not what i’d call a strong squad. Double Sunderland defence? Bruce? Hutton? Isgrove?
I was playing with the same idea. Think I’d prefer Coutinho to Sterling. What do you say?
And I think I’m ok with the defenders, will have 0.5 extra to maybe get Ferdinand for Hutton.
From what I’ve seen in pre-season Sterling is a much better pick, even if he is 0.5 more.
Yeah, upgrading Hutton could be a good move also, but watch Ferdinand, as he’s a little past his best, and may be rested more often than you’d like.
[…] Calvin Clyne provided us with an interactive fixture tracker of epic proportions that was a massive hit on both here and social media alike. Take the time to save your own copy and use it as you wish as we expect from the reaction it got he may be copyrighting it as we speak! Fixture Tracker – Fantasy Premier League 2014-15 […]