VSPLAYER, VSPLAYERNAME, VSTEAMNAME functions

Function VSPLAYER returns the player's number and the team's prefix.

• = VSPLAYER("*1i") - get the first player of the team

It is possible to add the role of the player like this:

•  = VSPLAYER("*1i","libero") - get the first team libero

Other roles are here:  setter, opposite, middle, and outside. 

We can get the player name using the VSPLAYERNAME function:

• =VSPLAYERNAME(A2),

Where in cell A2 is the player's number.

To get the team name, we put:

• =VSTEAMNAME("*")

Calculating function results in the spreadsheet can by prevented using #! the symbol. This can be used to optimize spreadsheet calculation time heavily.

• VSPLAYER and VSTEAMNAME automatically return this code when the player or team isn’t found.