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
RMT please.
thoughts anyone??
Not much to say on that one.
Yeah it looks good, difference of opinion on the Arsenal keeper but having him has its merits.
yeah, well i have utd and cfc def already, and ars had a lot of CS last season, 2nd behind chelsea i think.
Hi Hazard – DDG has prob better fixtures or is there a reason you dont want to go that route.
Shaw must be dodgy to start?
Is Cork nailed?
sup dreamers, only reason i dont have DDG is because of shaw!! i reckon LVG’s just threatening- surely cant put 31 mil on the bench? hopefully cork should be, no one even knows s’oton anymore!!
Hello blue hope you well mate! Everyone should get stuck into this league guys, worthy prizes up for grabs
#bastard, beat me to it.
thanks mito
been on this site for 2 years and feel like a nut for asking, but what are the banterbury leagues? havent seen anyone mention anything about them this year.
Bench is always on site giving info about them, theres 4 main leagues + 4 qualifying leagues to get into the main leagues + a couple of cup comps, all H2H, think every place has been taken, ask bench when hes on. Try the doubles, get youself a partner, set up a separate team to your singles + get in the league.
thanks elle, ill try and catch him.
I’m pretty sure all the leagues are full now Hazard, all the spots went very early this season
damn, missed my chance aha, always next year!!
Still got the doubles Haz, just get a partner.
Is a whole lot more than what I am going to describe, but basically is a bunch of h2h leagues. That compete in promotion and relegation like the English leagues do. Out of this, Bench gets teams that participate in other tournaments like the Cup, which is like the FA CUP as basically everyone faces everyone from all his leagues. Than he also has a Champions league version where only the top teams from his leagues face off.
sounds good, will try get involved
How does this look?
How does this look??
de gea myhill
shaw debuchy cahill dummett bruce
schurle barkley sidwell eriksen shelvey
rooney sturridge lukaku
help guys
if schurlle gets game time, your in with a great diferential there!!
maybe over spent on defence and a little average in midfield.
dummett and bruce arent going to get game time. go for wisdom/duff.. probably better. or haidara.
maybe get rid of shaw to a 4.5, and downgrade sidwell to a 4.5/5. he play defensively so less chance of points. use money to upgrade midfield. feel like you have 5 average mids, seems like there needs to be a big hitter (haz/ram/sanch/yaya/silva/mata)
are you sure on lukaku?
Nishant- to be honest needs a bit of work mate. A tad too much money in defence. Schurrle is not gonna be available in beginning of season due to World Cup. Try upgrade shelves to Siggy. Lukaku could be a decent shout but Everton do have tough fixtures to start off
Cheers guys. I will look into it. Thanks for that Schurrle’s absence thing. downgrade Lukaku to Lambert and Sturridge to Costa? Is that cool?
no – Lambert wont play
not lambert, dzeko or jovetic.
Get rid of lambert definitely! I only realised he was on the pitch v man utd in the week when they subbed him off!
Hey i made many changes. This seems good to me.
De Gea Myhill
Cahill Sagna Debuchy O Shea Wisdom
Yaya toure Ramsey Henderson Siggurdson Wanyama
Rooney Diego costa Wickam
cool?
BTW – Schurrle is playing tonight
Debuchy and Jordi Gomez
OR
Caulker and Siggy?
caulker and siggy.
+1