Reception by rotation

Here you can find a few formulas that will help you to analyze reception by rotation:

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

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

2. 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))

3. Total passes by rotation for a specific player

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

4. # and + pass percentage (positive reception) 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)))

5. 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))

In these functions, in cell number B3, you have the number of analyzed player, and in cell number B3 is the number of analyzed rotation.