Attack (play by play)

This sheet contains a play-by-play analysis of the team’s attack. It is suitable for when you want to get all the essential information about the setter and hitters, and it isa valuable spreadsheet that you can use on the bench. 

How does it work?

In the orange cell, you can select the game you want to analyze, which is useful during pre-game analysis. You can see the game’s name/label on the top of the sheet. Above each table, you have the number of the set and the score. See the example table below: SET 1 (21:25).

For each set, there is a table that shows the players and their attack attempts chronologically. It allows you to see how many balls the player attacked in a row and what the results were. It also shows us if the setter repeats sets to a player and what the distribution looks like in particular moments of the set. This shows the efficiency of the hitters over time and is useful for preparing tactics and choosing block options and defense strategies. 

This example shows that the most balls in a row were attacked by player #11 (Drews A.). Most of her series were successful; once, she scored three points in a row. Another player with few attack series was player #23 (Robinson K.), but they were unsuccessful as she never scored more than one point.

On the right side of the table, you can see the players’ attack attempts in a particular set, their percentage of kills, and the number of their attack errors.

Here, we can see that the most balls were attacked by player #11, and she scored from half of her attempts. Many balls were also attacked by player #23, but she scored on only 8% of them. 

The table on the right will show how many times the player attacked the ball in the row. You can see who is/was getting the most balls to attack during the set.

Here, we can see that player #11 had the most series and the longest series of attacks. he attacked the ball even four times in a row, while the next player, #23 Robinson, had just one series of three attacks in a row in this game. The other players never attacked more than two balls in a row. It tells us a lot about the setter and their team tactics and allows us to prepare better tactics for the game against this team. 

Important formulas in this spreadsheet:

=IF(L6=$B11,VSMAP(VSPLAYS(VSCELL("*A;S1;(1)",$C$5),VSRANGE(L5&":"&L5)),"effect"),"")

This formula gives the effect of the attack in the first set, in the game specified in cell C5 within particular range, if in the cells L6 and B11 we have the same values.

=IF(VSCOUNT(VSCELL("(1)A;S1;(2)",$A$9,$C$5))=0,"",VSCOUNT(VSCELL("(1)A;S1;(2)",$A$9,$C$5)))

This formula counts the number of the attacks of the player from cell A9, in the first set, in the game specified in cell C5  and shows it if it was different than 0.

=IF(VSCOUNT(VSCELL("(1)A;S1;(2)",$A$9,$C$5))=0,"",VSPER(VSCELL("(1)R#;S1;(2)",$A$9,$C$5)))

This formula gives the percentage of kills of the player from cell A9, in the first set, in the game specified in cell C5  and shows the number of this receptions was different than 0.