Share This Post

Fantasy Football FF247 / Fantasy Football Tips

Fixture Tracker – Fantasy Premier League 2014-15

Fixture Tracker – Fantasy Premier League 2014-15

Fixture Tracker - Fantasy Premier League 2014-15We’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.

fig1 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,fig2 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!

fig3I 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

Thanks for reading Fixture Tracker – Fantasy Premier League 2014-15. This article was written by Calvin Clyne


Share This Post



1,328 Comments

  1. 7
    Potty Procky says:

    Tight Pants Clyne
    Well I have looked at this Article and followed your Link and to be honest,i don’t understand a thing.
    But I promise you a pair of white Marks and Sparks Y-Fronts I will conquer this and learn from your hard work.
    Amazing Buddy
    Potty

  2. 8
    FF247 says:

    @Murage 86

    If you are going to spend 7.0 on a defender, it might as well be Baines and not Coleman. Leighton has pens and set pieces in his locker. So I would drop Coleman for him if you wish to have one. Rosenoir could be a problem as his starting spot is in jeopardy. So I would consider a change to a different player at that price. Perhaps you should wait until predicted line ups are out next Friday before making a decision. Siggy and Ramsey yes, the rest of your midfield would be a no from me. Herrera is a bit too deep so you should wait it out a bit before bringing him in. Schurrle is a rotation risk, if he gets consistent minutes, definitely yes but until then I would wait. Holtby is a rotation risk also. I feel he deserves to start, but that is not the same as him actually doing it. Your frontline is good. Keep your eye on Dzeko this weekend, see if you are comfortable with having him.

  3. 9
    Mito21 @FantasyFooty247 says:

    I see what this has become. Take a cheap shot at Mito on the articles game. First Taco Chins now you. All is fair in love and FPL. I will exact my revenge when you least expect it, literally will take the Taco out of Chin’s hand and shove it up your….. mouth, What you think I was going to say?! :hippo:

    All kidding aside this is fantastic work. It is highly appreciated.

  4. 10
    NIN says:

    Late night RMT..

    Begovic-Fabianski
    Wisdom-Mariappa-Jones-Caulker-Filipe Luis
    Mutch-Ramsey-Mata-Sigurdsson-Cesc
    Rooney-Bojan-Costa

    Nice work on the article Calvin. I’ll certainly be having a looksie to see what’s what. Don’t really understand it as yet, ha. Thanks buddy.

    • 10.1
      Mito21 @FantasyFooty247 says:

      What do you want us to rate? You know it looks good, go to bed. #except4Wisdom

    • 10.2

      Nin,
      Mito’s right. Nice team. I like Mutch.

    • 10.3
      NIN says:

      Cheers Mito/chins. I fell asleep so i’m only seeing your replies now. Not having Terry is eating away at me a bit but cant happily pull 0.5m from anywhere so Luis might have to do (it’ll hurt if Terry manages a goal or two early on).

      Chins, i like Mutch too but do you reckon he’s worth 5.5m? Seeing as i already have Caulker? QPR’s first few (h) games are great though..

  5. 11
    cr88 says:

    Hello guys,

    What do you think of my preliminary team selection:

    Howard

    Shaw F.Luis Debuchy

    Noble Hazard Mata Shelvey

    Rooney Remy Sturridge

    Bench: Myhill, Dummett, G.Cameron, Albrighton

    Has 0.5 left, and considering switching Shelvey with Sigurdson. What do you think about these two?

    Thanks smile

    • 11.1
      Mito21 @FantasyFooty247 says:

      @CR88, I can see lower production from your midfield than most teams. You have 4 big players in the front 8, the other 4 will probably be very up and down. Shelvey, Noble and Albrighton are basically fifth mids. One of them ok, three of them probably not ok. Dummy and Cameron are probably not going to start, although possible. But those can be changed before the deadline if need be. Once we have a better idea on who will start GW1.

  6. 12

    That’s my doubles partner ladies and gentlemen!! Mr Calvin Clyne!!!
    Take a bow mate. Great work. Loads of lovely colours. A really useful tool. A beautiful little dig at Mito. Perfect.

    :hippo:

    (That’s how you do the hippo mito. Just saying.)

Leave a Reply

Go to Latest CommentsView Now