Attack directions - game

This spreadsheet is prepared for use during the game. It shows the attack directions of the players. 

How to use it?

It shows the starting six players on the upper part of the spreadsheet and the bench players below. From the left, you have outside hitters, opposites, and then middle blockers. You can choose the visualization form of the courts in the orange cells at the top right of the spreadsheet.

Here you can see that when the ball was fast (X5), the direction of attack from zone 4 was mostly cross, and the efficiency was pretty high. When the ball was high (V5), the direction was line and cross, but the kills were only from the cross attack. Also, the efficiency of this attack was very low (-0.067).

Important Formulas in this spreadsheet:

=IF($A$19="","",VSCOUNT(VSCELL("(1)X5",$A$19)))

This formula counts the number of attacks of the player from cell A19, while the combination was X5. If there is no player in cell A19, the cell containing this formula will remain empty. 

=IF($A$19="","",VSPER(VSCELL("(1)V5#",$A$19)))

This formula returns the percentage of kills of the player from cell A19, while the combination was V5. If there is no player in cell A19, the cell containing this formula will remain empty. 

=IF($A$19="","",ROUND(VSEFF(VSCELL("(1)V5",$A$19)),3))

This formula gives the efficiency of attacks of the player from cell A19, while the combination was V5. The result is rounded to three decimal places.  If there is no player in cell A19, the cell containing this formula will remain empty. 

=IF($A$19="","",VSCOURT(VSCELL("(1)X5",$A$19),"heatmap","print","start","end",1.4)) 

This formula gives the court the directions of the attacks of the player from cell A19, while the combination was X5. The visualization form is a “heatmap”, the start and end points are shown, and the court size is 1.4.