Attack directions by rotation

This spreadsheet can be used on the bench during the game or during game preparation against a particular opponent.

How does it work?

This spreadsheet can be filtered by:

• attacking player

• attack zone

• setter

• setting zone

• point range/score

• point difference  

• FBSO

There are six courts, one for each rotation. Above each court is basic information about the attack in this rotation, such as efficiency, total number of attempts, kills, errors, and blocked attacks. 

Under each court, you can find the table with the setter distribution in this particular rotation and attack efficiency for all these situations. The left means balls set to zone 4, the right means set to zone 2, BR means set to the back row (zone 1), C is for the set after which the ball was hit by the middle blocker, and P means set to zone 6.

On these screenshots, we can see that the analyzed team in rotation 6 attacked mostly from zone 4, and they were very efficient because they won all these rallies. The attack from the right side of the court was far less efficient. They almost did not play with a middle blocker in this rotation.

Important Formulas in this spreadsheet:

=ROUND(VSEFF(VSAND(VSCELL("(1)A(2)0;*Z1;PR(3):(4);PA(5):(6)",$C$2,$D$2,$G$2,$H$2,$I$2,$J$2),VSCELL("(1)E(2);B-0",$E$2,$F$2))),3)

This formula gives the efficiency of the attack of the player in cell C2, from zone which number is in cell D2, in the rotation 1, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2, while the ball was set by the setter from cell E2 in the zone which number is in cell F2. The result is rounded to three decimal places.

=VSCOUNT(VSAND(VSCELL("(1)A(2)0;*Z6;PR(3):(4);PA(5):(6)",$C$2,$D$2,$G$2,$H$2,$I$2,$J$2),VSCELL("(1)E(2);B-0",$E$2,$F$2)))

This formula counts the number of the attacks of the player in cell C2, from zone which number is in cell D2, in the rotation 6, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2, while the ball was set by the setter from cell E2 in the zone which number is in cell F2. 

=VSCOUNT(VSAND(VSCELL("(1)A(2)0#;*Z5;PR(3):(4);PA(5):(6)",$C$2,$D$2,$G$2,$H$2,$I$2,$J$2),VSCELL("(1)E(2);B-0",$E$2,$F$2)))

This formula counts the number of the kills of the player in cell C2, from zone which number is in cell D2, in the rotation 5, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2, while the ball was set by the setter from cell E2 in the zone which number is in cell F2. 

=VSPER(VSAND(VSCELL("(1)A(2)0=;*Z4;PR(3):(4);PA(5):(6)",$C$2,$D$2,$G$2,$H$2,$I$2,$J$2),VSCELL("(1)E(2);B-0",$E$2,$F$2)))

This formula shows the percentage of the attack errors of the player in cell C2, from zone which number is in cell D2, in the rotation 4, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2, while the ball was set by the setter from cell E2 in the zone which number is in cell F2. 

=VSCOURT(VSAND(VSCELL("(1)A(2)0;*Z3;PR(3):(4);PA(5):(6)",$C$2,$D$2,$G$2,$H$2,$I$2,$J$2),VSCELL("(1)E(2);B-0",$E$2,$F$2)),"arrows","heatmap","print",1.5)

This formula gives the court the attack directions of the player in cell C2, from a zone whose number is in cell D2, in rotation 3, while the score is within range in cells G2 and H2, while the point difference is within the range from cells I2 and J2, while the ball was set by the setter from cell E2 in the zone which number is in cell F2. The visualization forms are “arrows” and “heatmap,” and the court size is 1.5.

=VSCOUNT(VSAND(VSCELL("(1)EF(2);*Z6;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A;B-0"))/VSCOUNT(VSAND(VSCELL("(1)E(2);*Z6;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A;B-0"))

This formula gives the percentage of balls set to zone 4, by the setter from cell E2, from zone F2, in rotation 6, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2.

=VSCOUNT(VSAND(VSCELL("(1)EB(2);*Z5;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A20;B-0","*R;B-0"))/VSCOUNT(VSAND(VSCELL("(1)E(2);*Z5;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A;B-0","*R;B-0"))

This formula gives the percentage of balls set to zone 2 in the first ball after reception, by the setter from cell E2, from the zone from F2, in rotation 5, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2.

=VSCOUNT(VSAND(VSCELL("(1)EC(2);*Z5;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A;B-0","*R;B-0;NOT"))/VSCOUNT(VSAND(VSCELL("(1)E(2);*Z5;PR(3):(4);PA(5):(6)",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A;B-0","*R;B-0;NOT"))

This formula gives the percentage of balls set to the middle blocker in the transition, by the setter from cell E2, from the zone from F2, in rotation 5, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2.

=ROUND(VSEFF(VSAND(VSCELL("(1)EB(2);*Z1;PR(3):(4);PA(5):(6);B-0",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A20")),3)

This formula gives the efficiency of attack of balls set to zone 2, by the setter from cell E2, from the zone from F2, in rotation 1, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2. The result is rounded to three decimal places.

=ROUND(VSEFF(VSAND("*A;*Z5",VSCELL("(1)EF(2);*Z5;PR(3):(4);PA(5):(6);B-0",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*R;B-0")),3)

This formula gives the efficiency of attack of balls set to zone 4, by the setter from cell E2, from the zone from F2, in rotation 5, while the score is within range in cells G2 and H2, while the point difference is within range from cells I2 and J2. The result is rounded to three decimal places.

=ROUND(VSEFF(VSAND(VSCELL("(1)EP(2);*Z1;PR(3):(4);PA(5):(6);B-0",$E$2,$F$2,$G$2,$H$2,$I$2,$J$2),"*A","*R;B-0;NOT")),3)

This formula gives the efficiency of attack of balls set to the pipe (zone 8), by the setter from cell E2, from the zone from F2 in transition, in rotation 1, while the score is within range in cells G2 and H2, while the point difference is within the range from cells I2 and J2. The result is rounded to three decimal places.