Serve directions by rotation

This spreadsheet can be very useful during the game to see how your opponents serve against your team or for the preparation before the game if you play again against the opponent you played with before.

How does it work?

You can choose the form of visualization in orange cells. On each court, you can find the directions of the team’s serve in a particular rotation. Above each court are numbers summarizing serve efficiency, total number of serves, aces, errors, and the number of serves that caused the opponent’s overpass. 

In the example above, in rotation one the team served from zone 9 to zone 1 without winning any points while also not making many mistakes. In rotation 6, the serve mostly came from zone 1 to zones 6 and 1. The serve efficiency was the highest in rotation 6, as well as the percentage of aces and the number of serve errors. 

Important Formulas in this spreadsheet:

=ROUND(VSEFF(VSCELL("*S;(1)",$B6)),3)

This formula shows the efficiency of the serve in rotation from cell B6. The result is rounded to three decimal places.

=VSCOUNT(VSCELL("*S;(1)",$B6))

This formula counts the number of serves in rotation from cell B6.

=VSCOUNT(VSCELL("*S#;(1)",$B6))

This formula counts the number of aces in rotation from cell B6.

=VSPER(VSCELL("*S#;(1)",$B6))

This formula gives the percentage of aces in rotation from cell B6.

=VSCOUNT(VSCELL("*S=;(1)",$B6))

This formula counts the number of serve errors in rotation from cell B6.

=VSPER(VSCELL("*S=;(1)",$B6))

This formula gives the percentage of serve errors in rotation from cell B6.

=VSCOUNT(VSCELL("*S/;(1)",$B6))

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

=VSCOURT(VSCELL("*S;(1)",$B$6),1.5,"arrows","heatmap","print")

This formula gives the court the directions of serves in rotation from cell B6.