Serve directions

This spreadsheet can be very useful for the preparation before the game, during the game to see how the opponents pass, and after the game to analyze your players’ performances.

How does it work?

On each court, we can find the directions of the serve of particular players. Above each court are numbers summarizing serve efficiency, the total number of serves, aces, errors, and serves that caused the opponent’s overpass. 

This example shows that player #9 served the ball from zone 1 to zones 6 and 1. He also had the highest percentage of errors and, on the other hand, the highest percentage of aces. Player #11 served mostly diagonally, from zone 5 to zone 5. He had the highest serve efficiency  (meaning he did not make many errors), and his serves were hard to pass by the opponent’s teams. Player #19 served mostly from zone 6 to zone 1, with the lowest percentage of errors.

Important Formulas in this spreadsheet:

=ROUND(VSEFF(VSCELL("(1)S",$A3)),3)

This formula shows the efficiency of a player's serve from cell A3. The result is rounded to three decimal places.

=VSCOUNT(VSCELL("(1)S",$A3))

This formula counts the number of serves of a player from cell A3.

=VSCOUNT(VSCELL("(1)S#",$A3))

This formula counts the number of aces of a player from cell A3.

=VSPER(VSCELL("(1)S#",$A3))

This formula gives the percentage of aces of a player from cell A3.

=VSCOUNT(VSCELL("(1)S=",$A3))

This formula counts a player's number of serve errors from cell A3.

=VSPER(VSCELL("(1)S=",$A3))

This formula gives a player's percentage of serve errors from cell A3.

=VSCOUNT(VSCELL("(1)S/",$A3))

This formula counts the number of serves that caused the opponent’s overpass of a player from cell A3.