Setter Distribution

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 on the bench. 

How to use it?

The spreadsheet shows the distribution after side-out. It is broken by the rotation, setter calls, and quality of the pass. 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 3, when the reception was positive, most balls were attacked by middle blockers from the slide. The second option was the pipe, where hitters had 90% of kills and attack efficiency. A few balls were set to zone 4. However, none of the attacks was performed by the opposite from zone 1.

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)F;PR(2):(3);PA(4):(5);(7)",$A$3,$B$3,$C$3,$D$3,$E$3,$A6,I6),"aS-;B-1"))

This formula counts the balls set to zone 4, 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 sets 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,$A6,W6),"aS-;B-1",VSOR("*X1;B-0","*X7;B-0","*X2;B-0")))

This formula gives the percentage of kills from the balls set to zone 3, while the setter call was marked in cell A6, in the rotation from cell W6, 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. The attack combination was X1, X7 or X2.

=VSEFF(VSAND("*A",VSCELL("(1)E(6)B;PR(2):(3);PA(4):(5);B-0;(7)",$A$3,$B$3,$C$3,$D$3,$E$3,$A6,AD6),"aS-;B-1"))

This formula returns the efficiency of the attack from the balls set to zone 2 or 9 in the rotation marked in cell AD6, 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.