Passing by serve zone

This spreadsheet can be very useful for the preparation before a game, during a game to see how the opponents pass, and after a game to analyze your player’s performance. Here, depending on the serving and reception zones, you can analyze the players’ passing.

How does it work?

This spreadsheet can be filtered by the passing team, passing player, and the serve type. In the first table at the top next to “att”, you can find the player’s total passing numbers depending on his passing zone. 

Here, you can see that the player achieved his best passing numbers in zones 1 and 9 and the worst in zones 6 and 8. His most passing attempts were on the left side of the court, and the least attempts on the right side.

The total passing numbers are then broken down by the individual serving zones. 

In this example, when the serve was from zone 6, the player’s best passing numbers were in zones 5 and 7 (40%), and the most mistakes he made were in zones 6 and 8 (18%).

The graph below shows the quality of passing of each player on the analyzed team.

The radar shows the quality of passing depending on the pass type.

Important Formulas in this spreadsheet:

=VSPER(VSOR(VSCELL("(1)(2)RM+",$A$2,$B$2),VSCELL("(1)(2)RH+",$A$2,$B$2)))

This formula gives the percentage of good receptions of the float serve, of the player from the cell B2.

=VSPER(VSAND(VSCELL("(1)(2)R!;PA*:0",$A$2,$B$2),"*R;PA0:0;NOT"))

This formula gives the percentage of neutral receptions while the home team was losing, of the player from the cell B2.

=VSPER(VSAND(VSCELL("(1)(2)R-;PA0:*",$A$2,$B$2),"*R;PA0:0;NOT"))

This formula gives the percentage of negative receptions while the home team was leading, of the player from the cell B2.

=VSPER(VSCELL("(1)(2)R/;PR20:*",$A$2,$B$2))

This formula gives the percentage of overpasses of the player from the cell B2, while the score was above 20 points.

=VSPER(VSCELL("(1)(2)RQ=",$A$2,$B$2))

This formula gives the percentage of passing mistakes of the jump serve of the player from the cell B2.