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
2-0 at HT.
cazorla and ramsey on target for arsenal.
city look disinterested, arsenal looking really good.
toure was nowhere to be seen while Sanchez has been trying by making some good runs, but his final passes have been really bad. still looks very uneasy. i reckon,it will be a while before Sanchez gets used to this brand of football.
OOOO TO BE A GOONER
RMT
need a team to rate buddy :big-lol:
hahaha I thought I uploaded a pic….
What do you guys think? RMT:
Krul (Myhill)
Terry, Gibbs, Manquillo, (Wisdom, Hutton)
Ramsey, Coutinho, Barkley, Shea, (Lampard)
Sturridge, Costa, Rooney
Is it a fantasy necessity to have Yaya Toure in the squad? Decided to take him out and go with 3 top strikers as well as reinforcing my defence. Was really impressed by Manquillo and Coutinho’s performance today, both relative bargains IMO if they get the game time. Still not completely decided, could potentially use Lovern/Azpilicueta instead of Terry/Manquilo. Anyone else intrigued by the idea of including Lampard as a cheap substitute?
Cheers
I’m on the fence about Yaya. I have him in my team right now but debating to sell and use the extra cash. Your mid looks a bit weak tbh. Barkley is not a great fantasy peospect. Get Mata in, starting fixtures for United coupled with his form would get you points.
Unless Rambo scores a double-hatty today or something I’m definitely sticking with Sanchez. Once Ozil returns and we play our best XI then I expect Ramsey to play a deeper role and be less involved.
If I’m wrong, it’ll be easy to downgrade Alexis to Aaron, much easier than chasing down 2.0m to squeeze in Sanchez if he scores a debut brace!
Rambo looks just as good as last year he’s box to box and his runs in behind are always threatening, I think he’ll have a great year once again.
Being a stubborn ass last year i didn’t get Ramsey and it cost me. Really tempted to downgrade Costa and get him in.
Stay cool Muts we are in it for the long haul if he scores two more then we can start thinking about it
Afternoon all, 2 probs to help with here please :-
1- 10 million on 2 playing keepers, who ?
2- Eriksen + Henderson or Silva + Davis ?
Hi Elle I would say Kurl & Pan good or Ars & Cry GK not sure prices Erik & Hen
Silvers, the keeper problem is a toughie for me, i want 2 playing keepers, Krul will concede heavily, Panty + Mannone chance of rotation, thinking Sir Chesney + ? At the moment.
Szcezsny might not play as well though.
Foster and Krul for me.
Howdy Elle. 1 – DDG and Krul. 2 – Silva and Davis.
Calvin, i think United will concede trying to play the LVG way, defenders are not good enough.
I expect us to get in another CB soon, and even if not I think it’s a mistake not to have United defence given our opening fixtures.
10 mil on keepers?? id just get two 4.5’s. if 10 mil- i’d probably go szczesny+ krul
SILVA AND DAVIS FOR ME
Haz, i think having a decent keeper will reward you with good points, Howard was top dog last season + there was only 3 defenders with more points than him.
sorry about the caps. and calvins sounds better. forgot about DDG
Silva on for Nasri at halftime. Not surprised at all with Arsenal being in the lead with the CBs playing for City :/
What’s the opposite of Sooty?
Pleas give your answers…….NOW
Potty
CLEAN
Paddy Mastermind this ain’t!
Potty
Seriously guys, Potty’s offering free prizes here just answer with SWEEP to be in with a chance to win. I’ve already done it once, just having a bit of fun
NOT SOOTY.
Nellie
Sooty?
By the time mine and Gee Pees doubles team have finished with AudtiBum!
You and Spiderman will be hiding up a Chimney
Potty
Oooooohhhh ! Get the pink handbags out. :big-lol:
And me, i’m in, if Potty will let me now. :worthy:
Unooted
?ytooS
Sweep