How to measure Block&Defense vs Side out attack performance

[FrancescoOleni]

In the last two seasons, I'm tracking the performance of teams (my team during the match, all the teams during the week) at block and defense system vs side out attack in this way.

1. How many SO attacks did the opponent hit?
2. How many of them didn't cross the net or go out? The total of "not error attacks" is the amount of attempts that I can transform in positive situation.
3. Out of the total of "not error attacks", how many times did I get a positive situation?
4. I define as a "positive situation":

• Block #
• Block !
• (Optional block touch and) defense followed by a counterattack

5. I define as a "negative situation":

• Defense =
• Block =
• Defense / (free ball to the opponent)
• Block / (net touch fault)

The cose for this part is:

OPP. 1st (no error)
=<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>

B#
=<a$$r/>
=<a$$r/>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

B!
=<a$$r!>
=<a$$r!>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

CA
=<a$$r{"(AorB)andCandD"[~~~~~+,5][~~~~~-,5][~~~B~/,8][~~~D~/,8]}>
=(<a$$r{"(AorB)andCandD"[~~~~~+,5][~~~~~-,5][~~~B~/,8][~~~D~/,8]}>)/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

D=
=<a$$r#{AND[~~~B,8]}>
=<a$$r#{AND[~~~B,8]}>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

B=
=<a$$r#{AND[~~~B,2]}>
=<a$$r#{AND[~~~B,2]}>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

D/
=<a$$r{AND[~~~D~/,2]}>
=<a$$r{AND[~~~D~/,2]}>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

B/
=<a$$r{AND[~~~B~/,2]}>
=<a$$r{AND[~~~B~/,2]}>/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

Pos.
=(<a$$r/>+<a$$r!>+(<a$$r{"(AorB)andCandD"[~~~~~+,5][~~~~~-,5][~~~B~/,8][~~~D~/,8]}>))/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

Neg.
=(<a$$r#{AND[~~~B,8]}>+<a$$r#{AND[~~~B,2]}>+<a$$r{AND[~~~D~/,2]}>+<a$$r{AND[~~~B~/,2]}>)/(<a$$r#>+<a$$r+>+<a$$r!>+<a$$r->+<a$$r/>)

At my level of this season (Korean V-League), I know that 50% of positive situations are a good goal to win the set, so I put in my worksheet the same box, but set by set (I can do also by quality of serve).

The last step has been to consider what happens with different middle blockers playing. We have 5 MB in the roster, so I'm using anything helpful to better understand the best skills of each of them.

Here is the code for this part (MB #6). It's better to type it by hand, because the DV4 wizard may have some problems.
It's working with up to 3 different setters in your roster. In my team, setters are #02, #3 and #05. You can replace them in formulas with your setters and/or with not-in-the-roster setters (#99) of you have less than 3.

n
=(<a$$r{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>)

Pos,%
=((<a$$r/{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r/{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r/{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][3-6,3-X-6-X-X-X]}>))/((<a$$r{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>))

Pos.
=(<a$$r/{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r/{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r/{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r/{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r!{AND[~~~~~=,6];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r!{AND[~~~~~=,6];;2,1,6;[][3-6,3-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][2-6,2-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][2-6,2-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][5-6,5-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][5-6,5-X-6-X-X-X]}>)+(<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;5,4,3;[][3-6,3-X-X-X-X-6]}>+<a$$r{AND[~~~~~=,6][~~~~~#,6][~~~~~/,6][~~~~~!,6][~~~D~/,8][~~~B~/,8];;2,1,6;[][3-6,3-X-6-X-X-X]}>)

I hope it could be interesting :)

[tyler-widdison]

Very nice Francesco!