Side out formulas

Sideout% by rotation (in cell A3 you have rotation number):

• =VSCOUNT(VSOR(VSCELL("*R;WR-0;*Z(1)",$B3),VSCELL("aS=;*Z(1)",$A3)))/ VSCOUNT(VSOR(VSCELL("*R;*Z(1)",$A3),VSCELL("aS=;*Z(1)",$A3)))

First ball side out %kills for particular player (in cell A3 you have the attacking player number):

• =VSPER(VSCELL("(1)A","*R;B-0",$A$2))

First ball side out efficiency by rotation (in cell A3, you have the rotation number): 

• =VSEFF(VSAND(VSCELL("*A;*Z(1)",$A$3),"*R;B-0"))

Sideout percentage in transition by rotation (in cell A3, you have the rotation number): 

• =VSEFF(VSAND(VSCELL("*A;*Z(1)",$A$3),"aS;R-0","*R;B-0;NOT"))

FBSO% by rotation for a team while a specific player passed the ball (in cell A2, you have the attacking player number, and in cell A3, you have the rotation number):

• =VSEFF(VSAND("*A",VSCELL("*(1)R;*Z(2);B-0",$A2,$A$3)))

Won points after reception:

• =VSCOUNT(VSOR(VSAND("*R;WR-0","*R;B-0")))