|DO NOT request access to edit this template! Save your own copy to be able to customise it. For a full explanation on how to get the most out of this tracker please watch the following video:|
|There is one main update from last season's effort:|
- you can now give each team a rating for both defence and attack
Navigate via the tabs at the bottom of the page. Select the Customise tab and follow the steps. You can choose the level of customisation you want: between 3, 5 and 7 colours of match difficulty, and between 3 and 10 different skill levels for each team. You assign each team a skill level for both defence and attack, e.g. West Brom - 2 in defence and 4 in attack, 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 Defence and Attack tabs 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.