Home point advantage

The "home point advantage filter" allows analyzing the plays that occurred when there was a particular point difference between two teams. It is used by typing PA after the semicolon, then putting the lower number, and then, after the colon, the higher number of advantage. It is analyzed from the home team's point of view, so the loss is expressed by negative numbers and the advantage - by positive numbers. Below you can find a few examples of how you can use this filter:

1. The formula that counts all attacks when the home team leads by 2 points or more looks like this:

=VSCOUNT("*A;PA2:*")

2. The formula that counts all serve errors when the home team leads has an advantage between 3 and 5 points looks like this:

=VSCOUNT("*S=;PA3:5")

3. The formula that counts all kill attacks when the home team loses by no more than 2 points looks like this:

=VSCOUNT("*A/;PA*:-2")

4. The formula that counts all attacks when the score difference was not greater than 1 is like this:

=VSCOUNT("*A;PA-1:1")

5. The formula that counts all attacks of player number four when the score difference is not greater than two looks like this:

=VSCOUNT("*4A;PA-2:2")