Beach Analysis

This spreadsheet contains the data that allows you to analyze the game of beach volleyball. 

How does it work?

In the first sheet, you can find the table with the essential data of the beach volleyball game. 

There is the percentage of kills for each player, the number of kills, and all attack attempts. Here, we can see, for example, that player #1 (Łosiak) attacked more balls and had a higher percentage of the kills. Then, we can see how efficient the players were while serving. Here, player #2 (Bryl) served more aces. We can also see the number of staff blocks of the player who plays by the net. There is also the percentage of positive reception for each player and the number of reception errors. There is also the number of mistakes each player made in each element; for example, player #2 made more service errors but fewer mistakes in the attack. 

Below this table are courts that visualize the directions of the serve and attack of each of these players. On the left, you can find the “Options” table. 

First, you need to choose visualization options and the element you want to analyze (Serve or Attack). The following options depend on the element choice. If you choose “Serve” in effects, you can choose “Ace”, “Error”, “Negative”, “Overpass,” or “Positive” serve. Then, you can choose the serving zone, serve type (“jump”, “float”), and whether you want to see the starting point on the court or not. When you choose “Attack”, you will see the different choices of effect (“Kill”, “In the play”,”Blocked”, “Error”) and starting zones. You can still choose the attack type (“hard”,”cut-shot”) and starting point option. 

On the right are two tables. The first table shows the team’s defensive player, with numbers regarding digging and blocking particular players. The second one shows the attack broken by attack type by a specific player.

The second sheet is designed to analyze the attack. On the left, you can find data showing the team’s performance in side-out, while on the right, you can see similar data regarding the transition phase of the game. The data in the side-out table are broken by the passing effect. You can also separately see numbers while the team or player attacked in the first ball side-out and during the side-out phase transition. 

Under the table, there are courts that visualize the side-out attack. They can be filtered by attack effect, part of the rally (FBSO and Side-out transition), passing effect, attack type, and attack starting zone. Obviously, you can also choose the visualization form of the court and determine whether you want to see a starting point or not.

The transition table analyzes the attack numbers in transition. They are broken by the side-out transition and break-point phase. It also shows separate numbers of attacks after dig and after freeball. Just as in the case of the side-out phase, under the table, there are courts that visualize the transition attack. They have similar filters, but instead of the reception effect, you can choose whether you want to see a transition after dig or after freeball, and in the phase of the game, you can choose side-out or break-point rallies.

The last sheet gives you the point breakdown for the particular game. In the orange cell, you can determine how many games you want to see (up to 5 games). 

You can see how many points each player scored in a particular element. There is also the part that shows the number of errors, and the last one analyzes the defense performance. On the right, you have courts that work just like the courts in the first sheet, but here, you can also choose which game you want to visualize.