FBSO (play by play)

This sheet contains a play-by-play analysis of the team’s attack after reception. It is suitable for when you want to get all the essential information about the setter and hitters, and it is a 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 for pre-game analysis. You can see the game’s name/label on the top of the sheet (i.e. above each table, you have the number of the set and the score). See the example table below: SET 4 (16: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 strategy. 

In this example, we can see that the team was losing the set, and the setter was trying to find the player who would be successful in the first rally after the reception. For most of the set she didn’t set the ball in a series to any player, but in the end, she set it to one player #22 (Plummer K.) FIVE times in a row. We could imagine in this situation that the setter was hoping that Plummer K. would help the team to change the result of this set, but it didn’t happen.

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 players #11 (Drewa A.) and #22 (Plummer K.) attacked the same number of balls in the first action after reception, but player #11 was a bit more successful. The team had 21 chances to attack after reception in this set, and they scored only 38% of these rallies, achieving 38% of kills.

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

Here we can see that the only player who had longer than two series of attacks after a reception in this game was player #22, who attacked the ball five times in a row. The other players had mostly one or two attempts. We can see that she had just six attempts and five of them were in the series.

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.