This spreadsheet is extremely useful for pre-game analysis when you want to get all the essential information about the setter. The first sheet is for the total side-out rallies. Then, there is the sheet for each rotation, the setter in the first row and the setter in the second row. At the top of each sheet, in the grey cell, you have the filter allowing you to filter this spreadsheet by the setter.
How to use it?
The spreadsheet shows the distribution after side-out. It is broken by the quality of the pass and by the setter call. You can choose the setter and rotation you want to analyze in the orange cells at the top of the sheet.
In rows are the directions of the set (Front, Back, Center, Pipe). In columns, there are numbers that:
T - number of sets to a particular direction
% - the percentage of all sets that were set to this direction
%# - the %kills from the sets to a particular zone
EFF - efficiency of the attack after sets to a particular zone.
In this example, you can see that while the reception was positive and the setter call was K1, most balls were set to zone 4, and there was also the highest attack efficiency and the %kills, and the least was set to the opposite. While the setter call was K7, most balls were set to the opposite and the least to zone 4. Most balls were set to the middle blocker if the setter call was K2 or KD after a positive pass.
The red zone is when the team is above 20 points and within two points difference from another team. It is broken by set directions and setter calls. Here, we can see that when the call was K1, most balls were set to zone 4, and when the call was KD, most balls were set to middle blockers.
Then, you have the distribution broken by the reception zone. For example, here we can see that if the ball was passed in zone one, the call was mostly K1, and most balls were set to zone 4. When the reception was in zone 6 or 5, and the setter call was KD, most balls were set to the middle blocker.
The “Setter” table shows us the distribution while the opponent’s setter was in the first row. The “Opposite” table is the setter breakdown while the opponent’s setter is in the back row. In this case, if the setter was in the first row, the setter call was KD in most rallies, and most balls were set to the middle blocker. On the other hand, while the opposite was in the first row, the setter call was mostly K1, and most often, the ball was set to zone 4.
The first sheet is for the total side-out rallies. Then, there is the sheet for each rotation, the setter in the first row and the setter in the second row.
Using the “Show on video” function, you can easily see these actions on video and analyze those actions even more thoroughly.
Important Formulas in this spreadsheet:
=VSCOUNT(VSAND(VSCELL("(1)EF;(2)",$D$2,$E$2),"aS-;B-1"))
This formula counts the sets to zone 4, by the setter whose number is in cell D2 while the team was in rotation, defined in cell E2, while the team was in side-out, and the pass was positive.
=VSCOUNT(VSAND(VSCELL("(1)EK1C;(2)",$D$2,$E$2),"aS-;B-1"))
This formula counts the sets to zone 4, while the team was in side-out, the pass was positive, and the setter call was K1.
=VSPER(VSAND("*A#",VSCELL("(1)EKDC;(2);B-0",$D$2,$E$2),"aS-;B-1"))
This formula gives the %kills while the set was to the middle blocker, while the team was in side-out, the pass was positive, and the setter call was KD.
=VSEFF(VSAND("*A",VSCELL("(1)EK7B;(2);B-0",$D$2,$E$2),"aS-;B-1"))
This formula gives the efficiency of attack while the set was to zone 2, while the team was in side-out, the pass was positive, and the setter call was K7.
=VSCOUNT(VSAND(VSCELL("(1)EKDC;(2);PR20:*;PA-2:2",$D$2,$E$2),"aS-;B-1"))
This formula counts the sets to the middle blocker while the team was in side-out, the pass was positive, the team was above 20, and the point difference was within 2 points.
=VSCOUNT(VSAND(VSCELL("(1)EK1B;(2)",$D$2,$E$2),VSOR("aS-6;B-1","aS-8;B-1","aS-3;B-1")))
This formula counts the sets to the zone while the team was in side-out, the pass was positive, and the pass was in zone 6, 8, or 3.
=VSCOUNT(VSAND(VSCELL("(1)EK1F;(2);aZ432",$D$2,$E$2),"aS-;B-1"))
This formula counts the sets to the zone 4 while the team was in side-out and the pass was positive, the setter call was K1, and the setter was in the front row.
Attachments (1)
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