|EDIT: If you have come across this tracker separately from the accompanying article then check out the video explaining how to use it: |
This is a customisable and interactive fixture tracker for the 15/16 FPL season. I'll try and keep the waffling to a minimum as who has time for it, but please do read this section to get the most out of the different features available.
There are two main updates from last season's effort:
- you can now choose between 3, 5 and 7 colours to represent the difficulty of each match (5 last season)
- you can put teams into as many as 10 different categories of skill level (4 last season)
Navigate via the tabs at the bottom of the page. Select the Customise tab and follow the four steps. You assign each team a skill level, e.g. Arsenal - 1, Aston Villa - 4, etc., and then decide on the relative difficulties of each possible match, e.g. 1 vs 1 home, 1 vs 1 away, 1 vs 2 home, etc. After you have done this the Fixtures tab will automatically have updated with colours specific to your selections. There are a lot of formulas at work in the background when you change the values, so it can sometimes take a few seconds to update. I urge you to KEEP UPDATING the skill levels of each team as their forms change over the course of the season so that the tracker stays relevant.
When it comes to inputting your data, only change things in cyan-coloured cells. Also keep in mind that there will be some default figures already in place, but these should only be used as examples. Replace these with your own valuations to make it personal. The default version will be using all 7 colours but only 5 skill levels. Either of these can be changed as you wish by selecting from the two drop-down menus (click on the arrow to activate these).
Be sure to hide each GW after it has passed. To do this hover over the letter above the GW's column and click on the arrow that appears, then select Hide Column.
The Compare Fixtures tab is a useful feature that allows you to compare any number of teams side by side without the other teams cluttering things up, making it particularly helpful when looking for strong rotation options. Select your teams by clicking on the arrows in the Add Team cells. When you are finished just highlight the Add Team option from the drop-down menu to return it to normal, ready for next time.
This version is more complicated than last time, so if anything doesn't work, there's a faulty fixture, or you just need a hand setting it up, ask away on Twitter and I'll get back to you: @SharpyBoy86
Bear in mind this was designed for Google Sheets as it is free and online so is easily accessed by everyone, and I recommend you use it with that. It will very possibly work in Excel and other spreadsheet programs too, but even if it does the formatting will probably be all over the place. The original copy is locked so it stays in tact, so to be able to customise your own version you should go to File and then Make a Copy. You will be able to edit this version, and I recommend bookmarking it for easy access as it is a great tool if used correctly. Finally it's unfortunately not particularly mobile-friendly - it can be viewed in Google Drive, but to my knowledge drop-down menus don't work in the mobile version so customising will be difficult and the Compare Fixtures tab won't work, so use a computer to get the most out of it.