It is suitable for pre-game analysis when you want to get all the essential information about the setter. It is also a valuable spreadsheet you can use during the game/ on the bench. At the top of the sheet, you have the filters allowing you to filter this spreadsheet by the setter, reception quality, setting zone, and opponent’s rotation.
How does it work?
The spreadsheet shows the distribution after side-out after positive reception. It is broken by the rotation and reception zone. At the top of the sheet, you have the filters allowing you to filter this spreadsheet by setter, score, and point difference.
Each court is divided into the zones to which the ball was sent. The black numbers show the amount of balls set to this zone.
Black - shows the percentage of balls set to this zone.
Red - shows the %kills from this zone
Pink - shows the attack’s efficiency from this zone.
In this example, in rotation 4, when the reception was on the left side of the court (zone 5, zone 7, or zone 4), and it was positive, most balls were set to zone 4. The second option was the middle blockers, who attacked from the slide. The opposite never attacked from the back row in this situation.
Using the “Show on video” function, you can easily see these actions on video and analyze them even more thoroughly.
Important Formulas in this spreadsheet:
=VSCOUNT(VSAND(VSCELL("(1)E(6)B;PR(2):(3);PA(4):(5);(7)",$A$3,$B$3,$C$3,$D$3,$E$3,$A6,B6),"aS-;B-1"))
This formula counts the balls set to the zone 4, after positive reception, while the score is within range in cells B3 and C3, while the point difference is within range from cells D3 and E3, while the setter from cell A3 set the ball.
=VSPER(VSAND("*A#",VSCELL("(1)E(6)C;PR(2):(3);PA(4):(5);B-0;(7)",$A$3,$B$3,$C$3,$D$3,$E$3,$A12,I12),"aS-;B-1",VSOR("*X1;B-0","*X7;B-0","*X2;B-0")))
This formula gives the %killes from balls set to zone 3 after positive reception, while the attack combination was X1, X7, or X2, while the score is within range in cells B3 and C3, while the point difference is within range from cells D3 and E3, while the setter from cell A3 set the ball.
=VSEFF(VSAND("*A",VSCELL("(1)E(6);PR(2):(3);PA(4):(5);(7);B-0",$A$3,$B$3,$C$3,$D$3,$E$3,$A30,AD30),"aS-;B-1",VSOR("*XS;B-0","*CF;B-0","*CD;B-0","*XD;B-0")))
This formula shows the attack efficiency from balls set to the middle blocker after positive reception when the attack combination was XS, CF, CD, or XD, while the score is within range in cells B3 and C3, while the point difference is within the range from cells D3 and E3, while the setter from cell A3 set the ball.
=VSCOUNT(VSAND(VSCELL("(1)E(6);PR(2):(3);PA(4):(5);(7);(8)",$A$3,$B$3,$C$3,$D$3,$E$3,$A36,AR36,$F$3),"aS!;B-1"))
This formula counts the balls after neutral reception, while the score is within range in cells B3 and C3, while the point difference is within range from cells D3 and E3, and the setter from cell A3 sets the ball.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article