Practice spreadsheets - Serving and Passing

The series of practice sheets are dedicated to use during your practices. These spreadsheets don't group players by home and away team, so they cannot be used during the game. They are designed to help you analyze your team, their performance during practice, and the quality of particular elements. It helps to prepare your team better for the upcoming games. The spreadsheet that gathers data from all aspects is the "Stats sheet for practice." You can also find the spreadsheets dedicated to particular elements in this series.

Practice Spreadsheet - Serving

This spreadsheet enables you to analyze the service of your team during practice. In the first sheet, on the left, there is a table that gives data regarding the service of particular players. The players are sorted by their positions. In blue cells, you have the player numbers that are put in there automatically. If you need to change them, you can do it manually.

This example shows player #9 (Olszewski J.) had the most serve attempts. He had six aces but also made four mistakes, so his percentage of aces was relatively high, but so was the rate of his errors. The best quality of service was achieved by player #11 (Bogucki I.), who served eight aces on 40% of his attempts and made only one mistake (5%). 

On the right, you have two tables. The first can be used when you are playing the training game during your practice session. There, you can find the players grouped by first and second teams (you can change the players manually in the blue cells in column J). There, you can see the serve effects and series over time, which helps to know how the particular player performed in this element and look at the flow of the game (e.g. if there were many serve errors in the series, which lowered the efficiency of practice).

The table below shows the serve of all players without sorting them into teams. It can be used for analyzing the game and during other serve exercises. There, you can see the quality of the players' performance chronologically.

In the second sheet  ("Players"), you can find the service performance of particular players in time.

You can see if they got better or worse in time if they made many mistakes and their service efficiency. This may help you make better decisions about the starting lineup or rotation before the game. The rotation planner may also help you here.

In this spreadsheet, you can also find more complex data regarding the service of particular players. There is the number of attempts, percentage of errors, overpasses, and aces, and the quality of reception after this player passes during the practice.

The graph shows this data visually. It helps to see the quality of the serve of particular players, and you can easily see if they made many mistakes or if the other players struggled with passing after their serve.

Practice Spreadsheet - Passing

This spreadsheet allows you to analyze your players' passing performance during the practice sessions. On the left side, you have the table that presents the passing data of particular players in your team. There is a number of attempts, percentage of perfect (4 grade), positive (3 and 4 grade) receptions, overpasses, and errors. You can also find the efficiency of passing particular players there.

Here, we can see that the best passing quality was player #9 (Olszewski J.), who achieved 84% positive passing and 0.737 efficiency in this element. The highest percentage of errors (40%) had player #1 (Klimik J.); however, his positive reception was at the same level. The lowest positive reception rate had player #5 (Ciok M.), who also had the negative efficiency of passing (-0.04).

On the right, there is a graph that visually shows the passing data of particular players. It helps to analyze who had the highest passing rate, who struggled the most, or whose passing efficiency was the best.

Below, you can find the "courts" that present the passing data of particular players depending on the reception zone. There, you can see the number of passing attempts in this zone, the number of errors (red number), the percentage of perfect passing (on the left), and of positive passing (on the right).

This example shows that this player passed the most balls in zone 6; his rate of perfect reception (4 grade) was just 14%, but the percentage of positive reception in this zone was 86%. He struggled in zone 1, where he made two errors while he had only three attempts.