Practice Spreadsheets - Setting, Attack, Rotation

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 - Setting

This spreadsheet helps to analyze the setter’s performance during practice. The first sheet contains the hitters groped by the positions and their attack data after the set of the particular setter. The setter is assigned automatically in the blue cell above the table (D2). You can change it manually if necessary. The attack data regards all actions, FBSO sorted by the passing quality and transition with the distinction of attack after freeball and after the dig.

In this example, we can see that most balls received the opposite, and the highest efficiency was achieved by player #9 (Olszewski J.). We can also see that player #5 (Ciok M.) was far more effective in transition than in FBSO. This may help to give some advice to our setter about his distribution for the following game.

In the second sheet, you will find the distribution of the particular setter during the practice session. It can be filtered by the setter, score, and point difference.

Practice Spreadsheet - Attack

This spreadsheet can be used to analyze our team’s attack performance better. In the first sheet, some tables contain data regarding attacks on particular players. There are numbers and percentages that give information about kills, errors, block attacks, and attack efficiency.

These data are also presented on the graphs on the right side of the table.

It helps to compare the players and make decisions before the upcoming game. Here, we can see that player #9 was the most efficient player on the team and did not make any mistakes. The lowest percentage of kills had player #19. 

There are also tables and graphs that present data regarding the attack after the reception, which allows us to analyze better the first action in side out of our team and find ways to improve it.

The second sheet contains attack combinations of particular players played during this practice session. It can be filtered by the setter, setting zone, rotation, and game phase.

Practice Spreadsheet - Rotation

This spreadsheet helps you analyze team performance in particular rotations. The first table shows the number of attack attempts, percentage of kills, and efficiency in particular situations. 

The table below shows the rallies in side out. You can find the data regarding won and lost points, the number of serve errors, and the percentage of won actions in this rotation. There is the part that shows data for the whole team, which is also broken by team A and team B (if you are playing a practice game).

On the right, you can see the graphs that present these data and compare teams A and B (for example, when your starting six play against the bench players). You have the number of attempts and won or lost rallies. The “Break Point” table and graphs below show the same set of data in this phase of the game.

The last table shows the team's won points in particular rotations. We can see how many points they won and what part of it the points won with attack, block, serve and how many opponent errors there were. We can also see this breakdown on the graph on the right side.