Passing (line-cross serve)

In this spreadsheet, you will find the reception breakdown by line-cross serve, allowing you to analyze whether the passing player was more effective while receiving the line or the cross serve. You can also see in which zone the passing player had the best reception and where he/she struggled.

How does it work?

The table below shows the passing and attack efficiency after the serve from the particular zones. It gives the passing attempts, passing average, %good receptions, percentage of errors, %FBSO, %SO, and attack efficiency.

In this example, you can see that the player (93 Kovacevic U.) passed the ball most times when the serve was from zone 1 to zone 5. He achieved the best numbers when the ball was served from zone 5 to 1, but he also passed the least balls there. He made the most errors when the serve was from zone 6 to zone 6 and 5.

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

Important Formulas in this spreadsheet:

=VSCOUNT(VSAND(VSCELL("(1)R",$A$3),VSOR("aS11;P-1", "aS19;P-1","aS91;P-1", "aS99;P-1")))

This formula counts the number of receptions of the player from cell A3, while the serve was played from zone 1 or 9 to zone 1 or 9.

=VSPER(VSAND(VSOR(VSCELL("(1)R#",$A$3),VSCELL("(1)R+",$A$3)),VSOR("aS16;P-1", "aS18;P-1","aS96;P-1", "aS98;P-1")))

This formula counts the percentage of positive receptions of the player from cell A3, while the serve was played from zone 1 or 9 to zone 6 or 8.

=VSPER(VSAND("*A#",VSCELL("(1)R;B-0",$A$3),VSOR("aS66;B-1", "aS68;B-1","aS68;B-1", "aS88;B-1")))

This formula counts the percentage of kills after receptions of the player from cell A3, while the serve was played from zone 6 or 8 to zone 6 or 8.

=ROUND(VSCOUNT(VSAND(VSCELL("(1)R;WR-0",$A$3),VSOR("aS51;P-1", "aS59;P-1","aS71;P-1", "aS79;P-1"))) /VSCOUNT(VSAND(VSCELL("(1)R",$A$3),VSOR("aS51;P-1", "aS59;P-1","aS71;P-1", "aS79;P-1"))),2)

This formula gives the percentage of points won in side-out. Firstly, it counts the number of rallies won after receptions of the player from cell C2, of the serve from zone 5 or 7 to zone 1 or 9. Then it divides it by the number of all receptions of the player from cell C2,  of the serve from zone 5 or 7 to zone 1 or 9

=ROUND(VSEFF(VSAND("*A",VSCELL("(1)R;B-0",$A$3),VSOR("aS55;B-1", "aS57;B-1","aS75;B-1", "aS77;B-1"))),3)

This formula gives the efficiency of the attack after receptions of the player from cell A3, while the serve was played from zone 5 or 7 to zone 5 or 7. The result is rounded to three decimal places.