Attack by rotation

Here you can find a few formulas that will help you analyze the attack by rotation:

1. Total attacks by rotation for a specific player

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

2. Attack efficiency by rotation for a specific player

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

3. Attack% by rotation for a specific player

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

4. Kill% by rotation for a specific player

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

In cell B2, you have the number of a player you analyze, and in B3 is the number of a rotation.