Basic functions

1. VSCOUNT  -  will return the number of plays fitting the search

• = VSCOUNT("*A") - counts all the attacks of the analyzed team
• = VSCOUNT("*4S#") - counts all the aces of player number four

2. VSPER  - will return percentage of plays with this effect, in all plays fitting search 

• =VSPER("*A#") - counts the percentage of kill attacks of the team
• =VSPER("*8S=") - counts all the missed serves of player number eight

3.  VSEFF – that will return the efficiency of plays fitting search

•  = VSEFF("*A") - shows the efficiency of the attack of the team
• = VSEFF("*2S") - shows the efficiency of the serve of player number two

4. VSCELL - you can use this function to automatize these functions

• =VSCOUNT(VSCELL("*(1)A",B2)) - this function counts all attacks of the player whose number you put in the cell B2
• =VSPER(VSCELL("*(1)A#",B2)) - this function counts the percentage of kills of the player whose number is in the cell B2
• =VSEFF(VSCELL("*(1)A",B2)) - this function shows the efficiency of the attack of the player whose number is in the cell B2