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 Rodwell considered a defensive mid or box to box?
He’s more of a ‘center circle to hospital’ type! Haha. Jokes aside, box to box. How long he can stay fit for is the worry. I had him in my squad but ditched him because he’s so injury prone.
ya my team seems to be pretty much the same as everyone elses. Perhaps thats the way to go. Still not sure. Ah well
TD – Joey Barton is a good shout at 5m. He’s on set pieces, as in the lot! as far as i know.
thought about him NIN – but also have Caulker so wont have both.
TD – I’ve actually gone for Caulker and Mutch to start the season. Both are easily dropable/rotatable so i’m not too fussed there.
Tottenham: DeAndre Yedlin ‘on brink’ of switch from Seattle
Could put Davies at risk perhaps?
Nope. Yedlin is a RB.
Actually, i read on MLSFB recently that he was going to Roma and the transfer would be held until the MLS season is over. Might it be the same if a Spurs deal happens? Keep it in mind anyway.
he isnt good enough to play anyway is he? More a squad player
TD – I haven’t watched enough Seattle games to be able to judge him properly. He’s lightning quick and a decent player from what i’ve seen. Can he dislodge Walker? Maybe not.
Hippo,
Right back versus left back so probably not.
And he’ll stay with Seattle until next year most likely.
Oh okay, I only seen him once anyways, wouldnt be a massive MLS supporter! My bad guys!
Forster worth a look if say 5M? Prob 5.5 wont he….
Dreamers
I say 5.0 once he is listed. Could have a few fanciers but Krul at 4.5 is better value I think.
14.5m for a striker and midfielder, I want City cover, so Bojan and Silva or Jovetic and a 6.5 mid?
Id say Bojan and Silva
+1
Thanks guys, I was stressing haha
Probably Bojan & Silva for me. Jovetic don’t really know if he’s nailed on to start with dzeko around ?
Thanks mate, thats the choice so!
Luis of Chelsea!!!!
Be wary,apart from his cleansheet potential which will be limited as Chelsea attempt to bulldoze themselves to the PL Title in a blaze of attacking football.
The said Luis in 4 seasons at Athletico Madrid scored only 5 goals,but more alarmingly in that 4 year reign he ventured over the halfway line only 19 times.
Look elsewhere lads for better value.
Potty
Evening guys,
I’m going off Sigurdsson tonight – Snodgrass is winning the race to start the season for me. Doesn’t have to be for long (sure Siggy will be in my team from GW5) – but Hull have better fixtures over the first six.
Any thoughts?
Siggy for me TGP. Hull will be hit and miss I’d say.
Cheers sir.
I just think Snodgrass at QPR is more attractive than Siggy at Man Utd.
May still go with Siggy and bite the bullet on the first week (or play Davis at Liverpool)?
Ive both on the bench at the mo. Could always start Snoddy and then just sell him I guess
Gee Pee
Seeing the Light darling x
Potty
Potts
Maybe maybe . . .
Would you have Snoddy over Siggy to start the season (even just for the first week but probably for 5/6 weeks)?
I ain’t playing with Siggy due to Man Utd away.
Snoddy needed that move.
Why you ask?
As a Leeds Lad I will enlighten you.
Wherever he goes his 1st season for that Club is phenomenal.
End of.
Potty
Potty,
Thinking of bringing him in for Sigurdsson for the first five weeks.
I know all about the man – seen him in the flesh many times for his country pal. One of our better ones.
TGP – I wouldn’t go for Snoddy over Siggy mate. There’s more goals in Siggy, for me. Plus he’ll be a no10 behind Bony with Gomis and Montero to back him up.
NIN
Likewise, I think Snodgrass will be the main source for Hull’s strikers though. And has better fixtures to start with – Siggy has Old Trafford and Stamford Bridge in his first four.
Just thinking about it but it might be start with Snodgrass for at least week one.