There are few filters that are based on playes around analyzed play.
First is the B filter - B-0 means "in same ball possession".
The formula that counts all attacks after reception (first ball) looks like this:
- =VSCOUNT(VSAND("*A", "*R;B-0"))
The formula that counts all first transition attacks:
- =VSCOUNT(VSAND("*A", "aR;B-1"))
Second is the P filter - P-1 means "one play before”.
The formula that counts all attack errors after the positive setting looks like this:
- =VSCOUNT(VSAND("*A=", "*E+;P-1"))
The formula that counts all kill attacks after perfect reception looks like this:
- =VSCOUNT(VSAND("*A#", "aR;P-2"))
Third is R filter - R-1 means "one rally before”.
The formula that counts all attacks, when in the rally before there were attack errors, looks like this:
- =VSCOUNT(VSAND("*A", "*A=;R-1"))
The formula that counts all serve errors after ace serves looks like this:
- =VSCOUNT(VSAND("*S=", "*S#;R-1"))
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article