Line - cross serve

This spreadsheet can be used in pre-game preparations and the postseason summary to analyze teams and particular players.

How to use it?

Here you can see the explanation of how to read the zones in this report:

Each table contains information about the serve of a team or a player divided by the starting and ending zone of the serve. There are numbers of total serve attempts, the percentage of the serves played in a particular direction, the percentage of aces, the percentage of errors, the opponent's positive reception, and the percentage of points won after that kind of serve. It shows the total serve data and the numbers regarding the red zone. The red zone is the situation when the team is above 20 pts and within two points difference of another team. 

In the example above, we can see that most balls were served by this team from zone 1 to zone 6. Also, the red zone was the most explored direction. Many serves played in line, from zone 1 to zone 5, and most aces were served this way. The team made the most mistakes while playing the cross court serve, from zone 1 to zone 1. The opponents' reception was best after the serve from zone 5 to zone 6 and the worst when the team served from zone 6 to zone 5. The serve from zone 5 to zone 6 was also where the serving team achieved the highest percentage of winning points.

Important formulas in this spreadsheet:

=VSCOUNT(VSOR("*S61","*S69"))

This formula counts the number of serves from zone 6 to zones 1 and 9.

=VSPER(VSOR("*S61#","*S69#"))

This formula gives the percentage of aces when the serve was played from zone 6 to zones 1 and 9.

=VSPER(VSOR("*S61=","*S69="))

This formula gives the percentage of errors when the serve was played from zone 6 to zones 1 and 9.

=VSPER(VSAND(VSOR("aR+","aR#"),VSOR("*S61;P-1","*S69;P-1")))

This formula gives the percentage of opponents' positive reception when the serve was played from zone 6 to zones 1 and 9.

=ROUND(VSCOUNT(VSOR("*S61;WR-0","*S69;WR-0")) / VSCOUNT(VSOR("*S61","*S69")),2)

This formula gives the percentage of aces when the serve was played from zone 6 to zones 1 and 9.

=VSCOUNT(VSOR("*S66;PR20:*;PA-2:2","*S68;PR20:*;PA-2:2"))

were

=VSPER(VSOR("*S66#;PR20:*;PA-2:2","*S68#;PR20:*;PA-2:2"))

This formula gives the percentage of aces when the serve was played from zone 6 to zones 6 and 8, the score was above 20, and the point advantage or loss was no bigger than two points.

=VSPER(VSOR("*S66=;PR20:*;PA-2:2","*S68=;PR20:*;PA-2:2"))

This formula gives the percentage of errors when the serve was played from zone 6 to zones 6 and 8, the score was above 20, and the point advantage or loss was no bigger than two points.

=VSPER(VSAND(VSOR("aR+;PR20:*;PA-2:2","aR#;PR20:*;PA-2:2"),VSOR("*S66;P-1","*S68;P-1")))

This formula gives the percentage of opponents' positive reception when the serve was played from zone 6 to zones 6 and 8, the score was above 20, and the point advantage or loss was no bigger than two points.

=ROUND(VSCOUNT(VSOR("*S66;WR-0;PR20:*;PA-2:2","*S68;WR-0;PR20:*;PA-2:2")) / VSCOUNT(VSOR("*S66;PR20:*;PA-2:2","*S68;PR20:*;PA-2:2")),2)

This formula shows the percentage of points won when the serve was played from zone 6 to zones 6 and 8, the score was above 20, and the point advantage or loss was no bigger than two points.