Attack Combinations

In the "Attack combinations" spreadsheet, players'' efficiencies are filtered by attack combinations. This breakdown lets you analyze the amount and efficiency of players when they attack from various combinations. 

How to use it?

This sheet can be filtered by setter, setting zone, rotation, side-out, and transition. The attack combinations are presented by players' position; there is a separate table for outside hitters, opposites, and middle blockers. All the attack combinations in each position-specific table are presented by each player.

The first column shows the total number of attacks from this combination. The second column contains the errors and blocks for each player in this combination, and in the third column, you can find the number of kills in this combination. The last column shows the percentage of kills and attack efficiency.  

The spreadsheet also contains the tables presenting the individual setter distributions for each attack combination. The "Red Zone" table for each setter shows the distributions above the 20th point, while the point difference is no more significant than 2 points.

Important Formulas in this spreadsheet:

=VSCOUNT(VSAND(VSCELL("(1)X5;(2)",$B8,$H$2),VSCELL("(1)E(2);B-0",$F$2,$G$2)))

This formula counts the number of attacks of the player from cell B8, while the attack combination was X5, in the rotation, which number is in cell H2, while the ball was set by the player from cell F2, in the zone, which number is in cell G2. 

=VSCOUNT(VSAND(VSOR(VSCELL("(1)V5=;(2)",$B8,$H$2),VSCELL("(1)V5/;(2)",$B8,$H$2)), VSCELL("(1)E(2);B-0",$F$2,$G$2)))

This formula counts the number of attack errors and blocked attacks of the player from cell B8, while the attack combination was V5, in the rotation, which number is in cell H2, while the ball was set by the player from cell F2, in the zone which number is in cell G2. 

=VSPER(VSAND(VSCELL("(1)X1#;(2)",$B50,$H$2),VSCELL("(1)E(2);B-0",$F$2,$G$2))) 

This formula gives the percentage of the player's kills from cell B50, while the attack combination was X1, in the rotation, which number is in cell H2, while the ball was set by the player from cell F2, in the zone, which number is in cell G2. 

=ROUND(VSEFF(VSAND(VSCELL("(1)V6;(2)",$B28,$H$2),VSCELL("(1)E(2);B-0",$F$2,$G$2))),3)  

This formula gives the efficiency of attacks of the player from cell B28, while the attack combination was V6, in the rotation, which number is in cell H2, while the ball was set by the player from cell F2, in the zone, which number is in cell G2, and the result was rounded to three decimal places. 

=VSCOUNT(VSAND("*X5",VSCELL("(1)E(2);B-0;(3)",$AC15,$G$2;$H$2)))

This formula counts the number of attacks of the home team, while the attack combination was X5, while the ball was set by the player from cell F2, in the zone whose number is in cell G2, in the rotation whose number is in cell H2. 

=ROUND(VSEFF(VSAND("*X7;PR20:*;PA-2:2",VSCELL("(1)E(2);B-0;PR20:*;PA-2:2",$AC$15,$G$2))),3)

This formula gives the efficiency of attacks while the attack combination was X7, above the 20th point, while the point difference was not more significant than two, while the ball was set by the player from cell F2, in the zone which number is in cell G2, in the rotation which number is in the cell H2, and the result was rounded to three decimal places.