Attack directions

This spreadsheet can be very useful for the preparation before the game, during the game to see how the opponents pass, and after the game to analyze your players’ performances.

How to use it?

There are three sheets: The first one contains the attack directions for outside hitters, in the second one, you can find the courts with the attack directions for opposites, and the third one is for middle blockers. You can choose how to visualize the courts with the orange cells at the spreadsheet’s top right. 

Here we can see, for example, that if the ball was set fast to zone 4, it was mostly attacked to the line, but when it was set high, the direction of attack was either line or cross. We can also see that this player was way more effective when he hit the fast ball. 

Important Formulas in this spreadsheet:

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

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

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

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

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

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

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

This formula gives the court on the directions of the player's attacks from cell A6, while the combination was X5. The visualization forms are “heatmap” and “arrows”, the start and end points are shown, and the court size is 1.4. If there is no player in cell A6, the cell containing this formula will remain empty.