Serving

The serving spreadsheet can be used as a preparation sheet, during the game on the bench, and as a summary sheet after a match or season. 

How does it work?

Filters:

• passing player

• passing effect

• serving zone

• passing zone

This spreadsheet is divided by the starting six players and the bench players. The starting six players are filled automatically, but the bench players must be added manually. In the columns, you can find information about serve attempts, percentage of points won after player serve (%PS), and percentages of aces and serve errors. In the second part of the table, there is data from the opponents’ team, such as their passing average after the particular players’ serve and the percentage of their 1st grade, 2nd grade, and PP (3rd and 4th grade) receptions. There is also the hitting efficiency of the opponents’ team from passing the starting six players serves, side-out efficiency, and first ball side-out efficiency.

In this example, you can see that the most balls were served by the player (12 Szalpuk A.), whose %PS was second highest in the team (49%), and the least services were performed by the player (11 Nowakowski P.), whose %PS was the lowest (27%). The player (20 Weber L.) won the highest percentage of points after his serve and had the highest percentage of aces and service errors. The opponents had the most difficulties receiving #20’s serves, as they achieved only 19% of positive passing, and the opponents had their best reception from player #11’s serves (58% of positive reception). The opponents also had the lowest side-out efficiency and first-ball side-out efficiency after player #20 served and the highest side-out efficiency when player #11 served the ball.

Important Formulas in this spreadsheet:

=VSCOUNT(VSAND(VSCELL("(1)S(2)0",$A6,$D$3),VSCELL("(1)R(2)0(3);R-0",$D$1,$D$4,$D$2)))

This formula counts the number of serves played by the player from cell A6, from the zone in cell D3, and was passed by the player from cell D1, in zone D4, with effect from cell D2.

=ROUND(VSCOUNT(VSAND(VSCELL("(1)S(2)0;WR-0",$A6,$D$3),VSCELL("(1)R(2)0(3);R-0",$D$1,$D$4,$D$2)))/(VSCOUNT(VSAND(VSCELL("(1)S(2)0",$A6,$D$3),VSCELL("(1)R(2)0(3);R-0",$D$1,$D$4,$D$2)))),2)

This formula counts the percentage of points won after the serve played by the player from cell A6, from the zone in cell D3, and was passed by the player from cell D1, in zone D4, with effect from cell D2. The result is rounded to two decimal places.

=VSPER(VSAND(VSCELL("(1)S(2)0#",$A6,$D$3),VSOR(VSCELL("(1)R(2)0(3);R-0",$D$1,$D$4,$D$2))))

This formula gives the percentage of aces served by the player from cell A6, from the zone in cell D3, and was passed by the player from cell D1, in zone D4, with effect from cell D2. 

=VSPER(VSCELL("(1)S(2)0=",$A6,$D$3))

This formula gives the percentage of serve errors served by the player from cell A6, from the zone in cell D3. 

= ROUND((( (VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),

VSOR(VSCELL("(1)R(2)0#",$D$1,$D$4),VSCELL("(1)R(2)0+",$D$1,$D$4)))) * 3) + (VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0!",$D$1,$D$4))) * 2) + (VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0-",$D$1,$D$4))) * 1) + (VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0/",$D$1,$D$4))) * 0.5) ) /   VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0",$D$1,$D$4)))) , 2)

This formula counts the passing average of the opponents' team when the player from cell A6, from the zone in cell D3, was passed by the player from cell D1, in zone D4.  The result is rounded to two decimal places.

=VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0-",$D$3,$D$4))) /VSCOUNT(VSAND(VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSCELL("(1)R(2)0",$D$3,$D$4))) 

This formula counts the percentage of negative receptions of the opponents' team when the player from cell A6, from zone cell D3, was passed by the player from cell D1, in zone D4.  

=ROUND(VSEFF(VSAND("aA",VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSOR(VSCELL("(1)R(2)0(3);B-0",$D$1,$D$4,$D$2)))),3)

This formula gives the efficiency of attack of the opponent team while the ball was served by the player from cell A6, from the zone in cell D3, and was passed by the player from cell D1, in zone D4, with effect from cell D2. The result is rounded to three decimal places.

=VSPER(VSAND("aA#",VSCELL("(1)S(2)0;B-1",$A6,$D$3),VSOR(VSCELL("(1)R(2)0(3);B-0",$D$1,$D$4,$D$2))))

This formula gives the percentage of kills of attack of the opponent team while the ball was served by the player from cell A6, from the zone in cell D3, and was passed by the player from cell D1, in zone D4, with effect from cell D2.