Passing

The passing spreadsheet can be used as a game preparation sheet, a sheet used during the game on the bench, and a summary sheet after a game 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,

• passing player.

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

The second one is the team pass grade. You can find the number of passing and attacking attempts, kills, hitting efficiency, earned side-out percentage, and %FBSO, broken by the reception grade. 

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

The last section is passing a 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 those actions 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 cell D6, with the effect marked in cell D4, in rotation from cell C7, while the player from cell C3 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 cell D6, in rotation from cell C7, while the player from cell C3 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 cell D6, in rotation from cell C7, while the player from cell C3 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 cell D6, with the effect marked in cell D4, in rotation from cell C7, while the player from cell C3 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 the player from cell A55 after the reception of the player from cell A5, in the zone from cell D6, with the effect marked in cell D4, in rotation from cell C7, while the player from cell C3 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 the player from cell A56 after the reception of the player from cell A5, in the zone from cell D6, with the effect marked in cell D4, in rotation from cell C7, while the player from cell C3 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 the player from cell A59 after receptions of the player from cell A5, in the zone from cell D6, with the effect marked in cell D4, in rotation from the cell C7, while the player from cell C3 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 C7, while the player from cell C3 served the ball, from the zone in cell D5.