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
Morning all. Woke up, read the BBC write up, can anyone fill me in on fantasy outcomes of the CS today; any must haves, have nots!? Cheers all.
Evening NZ, Citeh were crap, Ramseys a must have, Pool played well, although only a Dortmond ‘B’ team.
Oight Alex Arsenal looked spritely,city a bit rusty and dis-jointed!Just my view,Liverpool looked good, passed ball really well Coutinho,Sterling,Sturridge all exceptional!
Thanks boys, how was Sanchez? Did he play as a striker?
Played out on the right ,looked dangerous at times.Over riding thing I have about Arsenal is that they have so many stars im not sure they will have a stand out individual over the season,might be proven wrong.DeBuchy interests me,he had a few chances at goal and put himself about,just don’t fancy their first couple of fixtures though.Also as Chambers also had a solid game we will have to see who starts when Merts is back from his rest.
Cheer Peaky, I’m picking Chambers maybe a sneaky punt this year, I could well be wrong and Mert will jump straight back in! So what are the must have front two?
I think overwhelming view on here is Rooney,Costa,it is for me! And as u well know ive been saying Bojan as a 3rd striker for quite a while before everyone started copying me!! 😉
Are all the leagues with codes mentioned here free for everybody to join?
Hello Mr Bean, yup certainly are! Well Cookies has a £5 entry but ‘feel free’ to enter!
Sweet!
Howdy peeps…
Think I’m gunna settle on this..”….waddya think..?
Alright Popz, I like it loads! Mainly because its very similar to my team. Ive gone away from 3-5-2 to look at 4-3-3. Only concerns would be defence, but I guess your going with FL and Caulker starting most? Will Chambers continue to start?
@Bigpopz.
Very nice team. Crap bench..
If Chambers gets enough game time he will be a steal!
How do you put a picture of your team for a RMT?
horse- its addded to the comments, look below the box and there is a choose file button!!
Thanks Hazardeden.
I see the choose file button.
It brings up browse. So how do I connect my team?
(Sorry to be a bit thick)
Horse, evening mate, i’ve been trying all day to justify the 3 big hitters up top but it leaves the defence + midfield a bit lightweight + unbalanced and also as you rightly say a crap bench. Take a screenshot of your team, write something on a post, then click on choose files below the post, find your pic, choose it, then post your comment as usual.
Hi Elle,
It’s all right for you youngsters with your flashy IT skills. LOL
How do you take a screen shot?
There’s a button called PrtSc (Print Screen), it’s usually on the top line of buttons after all the F buttons. Just press it and you’ll take a screen shot, but you need a program to open and save the picture. I use Paint, just open it and press Ctrl + V then the screen shot should pop up.
Ha ! Cheers Horse, i don’t get called a youngster at all now, i had to ask our chieftain Init how to do it, so no flashy IT skills here mate.
Hey Horse are you gonna get a partner + get yourselves in the doubles ?
Thanks Tekno.
Getting there I think.
Can someone RMT.
I don’t know anout a doubles team Elle.
How does it all work?
Kaboul? really?
@Slow poison
Just changed Kaboul from Ben Davies and no doubt will change him to another 5m defender by the end of the week.
Yoshida is another one I am not 100% sure on but will adjust as more news comes out.
But apart from them, was is your opinion?
Yeah I’m not keen on Kaboul Horse, I’m sure I’ve read that he was in line for a possible move away to an Italian side as well, I’ve never liked Yoshida though, I’m expecting the Saints to pick up another CB before the transfer window shuts and I’d expect him to lose his place in the line up straight away.
How about adding Debuchy for Kaboul and changing Yoshida to a 4m defender? Hutton possibly looks like playing for Villa (I know Villa right) but at least you’d have a possible playing back up to go with one of the better defense’s in the league.
Thanks Andy.
Debuchy plus a 4m defender does seem an improvement.
looks good, reasonably balanced considering theres 32.5 mil up top!!
only questions on your bench:
-bruce- gametime a big issue
-vlaar- plays for villa!!!!!!!
-chambers- mert will be back, then your kinda screwed!!!
Heres a link for live streaming on Utube for Chelsea game on now!
https://www.youtube.com/watch?v=Ca087OiJbQw
Chelsea one down!
Terry, Cahill, and Ivanovic aren’t playing though Dave, Chelski have one last friendly on the 12th, the line up for that will be very interesting.
Do u think that will be THE one Andy???? I mean line-up??
I think it will be them three plus one of Azpi and Luis, I’m going to guess that Azpi starts the first game though but really you could toss a coin.
Too late mate ive adjusted my team accordingly Luis out Cahill in!
What are everyone’s thoughts on Holtby, 2 goals and 4 assists in preseason and has had the most game time of all midfielders. At 6m could could be a decent shout, no?
Hi Villan Holtby is a good solid player but will he start & is he your 4th or 5th choice MF player
HI Silver I’d be switching between him and siggy each week. Seems like he could be a decent differential but i guess it’s too early to tell at the moment.
Hi Villan – Id prefer to see him start the season and bring him in then. He is decent though
Yeah good call Dreamers, how’s your team looking, who are your differentials?
Hi Villan – Chris Baird seems my differential which is sad
Have Bojan at the moment and its not sitting well with me.
Hows your team looking?
Yeah i have Bojan too and am not convinced but time will tell! can’t see who’s a better option at the mo for the same price.
My team is just about sorted but i’ve said that so many times already : /