Passing

The passing spreadsheet can be used as a preparation sheet, as a sheet used during the game on the bench, and as a summary sheet after a match or season. 

How to use it?

This spreadsheet consists of four sections, and all of them can be filtered by:

• serving player;

• passing effect;

• serving zone;

• passing zone;

• rotation.

The first section illustrates the individual breakdown of all the players passing the ball. The columns consist of the number of passing attempts, perfect, neutral, and negative reception percentages, passing errors and overpasses, passing average, hitting efficiency, side-out percentage, and %FBSO. This can help you find the worst passing player on the opponent team, or analyze the performance of your own players. 

Here, you can see that the most balls were passed by player #2, but player #9 had the best percentage of positive receptions. Player #93 had the highest percentage of negative receptions, but also the lowest percentage of errors and overpasses. The team also achieved the highest %SO after player #93 passes.

The second section is the team pass grade. You can find the number of passing and attacking attempts, kills, hitting efficiency, earned side-out percentage, and %FBSO, separated by the reception grades 4, 3, 2, and 1 in their respective columns. As you can predict in this case, the team achieved their highest attack efficiency after the perfect pass, and the lowest efficiency after the negative pass.

The third section is FBSO, which allows us to analyze the first action after reception.

The most balls here were attacked by player #93. The player #25 had the highest efficiency, %kills, and no errors or blocked attempts. This part can also be filtered by the passing player.

The last section is a passing heat map. The heatmap shows the ending zone of the passing by the analyzed player. The starting zone and passing rate are marked by a particular symbol. The heat map refers to the player whose number you can choose in cell D8.

Using the “Show on video” function, you can easily see these actions on video and analyze them even more thoroughly.

Important Formulas in this spreadsheet:

=VSCOUNT(VSAND(VSCELL("(1)R(2)0(3);(4)",$A5,$D$6,$D$4,$D$7),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)))

This formula counts the number of receptions of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=VSPER(VSAND(VSOR(VSCELL("(1)R(2)0#;(3)",$A6,$D$6,$D$7),VSCELL("(1)R(2)0+;(3)",$A6,$D$6,$D$7)),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)))

This formula gives the percentage of positive receptions of the player from cell A5, in the zone from the cell D6, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=VSPER(VSAND(VSCELL("(1)R(2)0-;(3)",$A8,$D$6,$D$7),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)))

This formula gives the percentage of negative receptions of the player from cell A5, in the zone from the cell D6, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=ROUND(VSEFF(VSAND("*A",VSCELL("(1)R(2)0(3);(4);B-0",$A11,$D$6,$D$4,$D$7),VSCELL("(1)S(2)0;B-1",$D$3,$D$5))),3)

This formula gives the efficiency of attack after the reception of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=VSCOUNT(VSAND(VSCELL("(1)A;(2)",$A55,$D$7),VSCELL("(1)R(2)0(3);B-0",$D$8,$D$6,$D$4),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)))

This formula counts the attacks of player from cell A55, after the of reception of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=VSPER(VSAND(VSCELL("(1)A#;(2)",$A56,$D$7),VSCELL("(1)R(2)0(3);B-0",$D$8,$D$6,$D$4),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)))

This formula gives the percentage of kills of player from cell A56, after the reception of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=ROUND(VSEFF(VSAND(VSCELL("(1)A;(2)",$A59,$D$7),VSCELL("(1)R(2)0(3);B-0",$D$8,$D$6,$D$4),VSCELL("(1)S(2)0;B-1",$D$3,$D$5))),3)

This formula shows the efficiency of attack of player from cell A59, after receptions of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.

=VSCOURT(VSAND(VSCELL("(1)R(2)0(3);(4)",$D$8,$D$6,$D$4,$D$7),VSCELL("(1)S(2)0;B-1",$D$3,$D$5)),"heatmap","end","arrows","print",1.8)

This formula shows the court with heatmap and arrows of receptions of the player from cell A5, in the zone from the cell D6, with the effect marked in cell D4, in rotation from the cell D7, while the player from cell D3 served the ball, from the zone in cell D5.