Analysis by rotation formulas

Here in the cell B3 we have the number of analyzed rotation, and in cell B2 we have number by analyzed player:

Overall +/- by rotation

• =VSCOUNT(VSCELL("S;WR-0;*Z(1)",$B3))-VSCOUNT(VSCELL("S;LR-0;*Z(1)",$B3))

Sideout% by rotation

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

Perfect (#) and Good(+) pass percentage by rotation

• =VSPER(VSOR(VSCELL("*R#;*Z(1)",$B3),VSCELL("*R+;*Z(1)",$B3)))

Passing average by rotation

• =(VSCOUNT(VSCELL("*R#;*Z(1)",$B$3))*4+VSCOUNT(VSCELL("*R+;*Z(1)",$B$3))*3+VSCOUNT(VSCELL("*R!;*Z(1)",$B$3))*2+VSCOUNT(VSCELL("*R-;*Z(1)",$B$3))*1+VSCOUNT(VSCELL("*R/;*Z(1)",$B$3))*0.5)/VSCOUNT(VSCELL("*R;*Z(1)",$B$3))

Firstball sideout efficiency by rotation

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

Sideout percentage in transition by rotation

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

Points scored in system % by rotation

• =VSPER(VSAND(VSCELL("*A#;*Z(1)",$B3),VSOR("*R#;B-0","*R+;B-0")))

Points scored Out of system%  by rotation

• =VSPER(VSAND(VSCELL("*A#;*Z(1)",$B3),VSOR("*R!;B-0","*R-;B-0")))

Total attacks by rotation for a specific player

• =VSCOUNT(VSCELL("*(1)A;*Z(2)",$B$2,$B$3))

Attack efficiency by rotation for a specific player

• =VSEFF(VSCELL("*(1)A;*Z(2)",$B$2,$B$3))

Total passes by rotation for a specific player

• =VSCOUNT(VSCELL("*(1)R;*Z(2)",$B$2,$B$3))

# and + pass percentage by rotation for a specific player

• =VSPER(VSOR(VSCELL("*(1)R#;*Z(2)",$B$2,$B$3),VSCELL("*(1)R+;*Z(2)",$B$2,$B$3)))

Passing average by rotation for a specific player

• =(VSCOUNT(VSCELL("*(1)R#;*Z(2)",$B2,$B$3))*4+VSCOUNT(VSCELL("*(1)R+;*Z(2)",$B2,$B$3))*3+VSCOUNT(VSCELL("*(1)R!;*Z(2)",$B2,$B$3))*2+VSCOUNT(VSCELL("*(1)R-;*Z(2)",$B2,$B$3))*1+VSCOUNT(VSCELL("*(1)R/;*Z(2)",$B2,$B$3))*0.5)/VSCOUNT(VSCELL("*(1)R;*Z(2)",$B2,$B$3))

FBSO% by rotation for a specific player

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

Attack% by rotation for a specific player

• =VSEFF(VSCELL("*(1)A;*Z(2)",$B$2,$B$3))

Kill% by rotation for a specific player

• =VSPER(VSCELL("*(1)A#;*Z(2)",$B$2,$B$3))