As a new volunteer assistant coach I’ve experienced the stress of trying to live by the code of “Fair playing time for each squad member”. Saying it and doing it, I’ve learned, are at 2 different levels of difficulty. Having tried various methods from “winging it” to writing each players name x 4 onto pieces of paper, creating formations with them, then adding up the amount of each players names to ensure some level of fairness, I have developed this spreadsheet intended to be used, either on a laptop before leaving the house, or on your phone pitchside. It is an absolute Godsend. It saves me time, brain power, and more importantly it helps keep pre-match stress to a minimum.
This spreadsheet works simply with the coach inputting numbers 1-7 next to players names for each quarter. Each number represents a position. This gives an extremely easy visual to work off. The “Game time” column, which you will input, helps to show how many quarters each player will play as a quick reference. Click "Learn More" to be redirected to our short Youtube clip.
Learn MoreThe result is a clearly visible summary of your selections in formation of 1-2-3-1. Click "Learn More" to be redirected to our short Youtube clip.
Learn MoreNo more scribbling on notebooks, worrying because the number of players won’t go into 7 as easily as you had hoped, or having to constantly adopt rolling subs. There is a guide of how to plan your subs depending on your attendance (up to 12 players) letting you know how much playing time each player has and how to break down the substitution, both WITH and WITHOUT a dedicated Goalkeeper . From there, it is easy to count playing time for the whole match, and includes a large comment box for notes.