Spreadsheet: 673387d1587358407-formula-for-concurrent-activity-revisedexample
Sheet: Example (2)

Row | Activity | Platform | Feature | User | Machine | COUNT
1 | OUT | Platform A | Feature G | User A | Machine A | 1
2 | OUT | Platform A | Feature E | User A | Machine A | 1
3 | IN | Platform A | Feature E | User A | Machine A | 1
4 | IN | Platform A | Feature G | User A | Machine A | 0
5 | OUT | Platform A | Feature G | User A | Machine A | 1
6 | OUT | Platform A | Feature E | User A | Machine A | 1
7 | out | Platform A | Feature G | User A | Machine A | 1
8 | out | Platform A | Feature G | User A | Machine A | 1
9 | out | Platform A | Feature E | User A | Machine A | 1
10 | in | Platform A | Feature E | User A | Machine A | 1
11 | in | Platform A | Feature G | User A | Machine A | 1
12 | OUT | Platform A | Feature I | User A | Machine A | 1
13 | in | Platform A | Feature G | User A | Machine A | 1
14 | out | Platform A | Feature I | User A | Machine A | 1
15 | out | Platform A | Feature I | User A | Machine A | 1
16 | IN | Platform A | Feature E | User A | Machine A | 1
17 | IN | Platform A | Feature G | User A | Machine A | 1
18 | in | Platform A | Feature I | User A | Machine A | 1
19 | out | Platform A | Feature I | User A | Machine A | 1
20 | in | Platform A | Feature I | User A | Machine A | 1
21 | in | Platform A | Feature I | User A | Machine A | 1
22 | IN | Platform A | Feature I | User A | Machine A | 0
23 | OUT | Platform A | Feature I | User A | Machine A | 1
24 | OUT | Platform A | Feature B | User A | Machine A | 1
25 | OUT | Platform A | Feature D | User A | Machine A | 1
26 | OUT | Platform A | Feature C | User A | Machine A | 1
27 | OUT | Platform A | Feature G | User A | Machine A | 1
28 | OUT | Platform A | Feature F | User A | Machine A | 1
29 | IN | Platform A | Feature I | User A | Machine A | 1
30 | IN | Platform A | Feature F | User A | Machine A | 1
31 | OUT | Platform A | Feature H | User A | Machine A | 1
32 | IN | Platform A | Feature B | User A | Machine A | 1
33 | IN | Platform A | Feature D | User A | Machine A | 1
34 | IN | Platform A | Feature C | User A | Machine A | 1
35 | IN | Platform A | Feature G | User A | Machine A | 1
36 | IN | Platform A | Feature H | User A | Machine A | 0
37 | OUT | Platform A | Feature G | User A | Machine A | 1
38 | OUT | Platform A | Feature E | User A | Machine A | 1
39 | IN | Platform A | Feature E | User A | Machine A | 1
40 | IN | Platform A | Feature G | User A | Machine A | 0
41 | OUT | Platform A | Feature I | User A | Machine A | 1
42 | OUT | Platform A | Feature I | User A | Machine A | 1
43 | OUT | Platform A | Feature D | User A | Machine A | 1
44 | OUT | Platform A | Feature D | User A | Machine A | 1
45 | OUT | Platform A | Feature I | User A | Machine A | 1
46 | OUT | Platform A | Feature I | User A | Machine A | 1
47 | IN | Platform A | Feature I | User A | Machine A | 1
48 | IN | Platform A | Feature D | User A | Machine A | 0
49 | OUT | Platform A | Feature G | User A | Machine A | 1
50 | out | Platform A | Feature G | User A | Machine A | 1
51 | out | Platform A | Feature G | User A | Machine A | 1
52 | OUT | Platform A | Feature E | User A | Machine A | 1
53 | IN | Platform A | Feature E | User A | Machine A | 1
54 | in | Platform A | Feature G | User A | Machine A | 1
55 | in | Platform A | Feature G | User A | Machine A | 1
56 | IN | Platform A | Feature G | User A | Machine A | 0
57 | OUT | Platform A | Feature G | User A | Machine A | 1
58 | OUT | Platform A | Feature E | User A | Machine A | 1
59 | IN | Platform A | Feature E | User A | Machine A | 1
60 | IN | Platform A | Feature G | User A | Machine A | 0
61 | OUT | Platform A | Feature I | User A | Machine A | 1
62 | OUT | Platform A | Feature H | User A | Machine A | 1
63 | IN | Platform A | Feature H | User A | Machine A | 1
64 | OUT | Platform A | Feature A | User A | Machine A | 1
65 | IN | Platform A | Feature I | User A | Machine A | 1
66 | OUT | Platform A | Feature G | User A | Machine A | 1
67 | OUT | Platform A | Feature E | User A | Machine A | 1
68 | IN | Platform A | Feature E | User A | Machine A | 1
69 | IN | Platform A | Feature G | User A | Machine A | 1
70 | OUT | Platform A | Feature G | User A | Machine A | 1
71 | OUT | Platform A | Feature E | User A | Machine A | 1
72 | IN | Platform A | Feature E | User A | Machine A | 1
73 | IN | Platform A | Feature G | User A | Machine A | 1
74 | IN | Platform A | Feature A | User A | Machine A | 0
75 | OUT | Platform A | Feature I | User A | Machine A | 1
76 | OUT | Platform A | Feature H | User A | Machine A | 1
77 | OUT | Platform A | Feature G | User A | Machine A | 1
78 | OUT | Platform A | Feature E | User A | Machine A | 1
79 | out | Platform A | Feature G | User A | Machine A | 1
80 | out | Platform A | Feature E | User A | Machine A | 1
81 | IN | Platform A | Feature H | User A | Machine A | 1
82 | in | Platform A | Feature E | User A | Machine A | 1
83 | IN | Platform A | Feature E | User A | Machine A | 1
84 | in | Platform A | Feature G | User A | Machine A | 1
85 | IN | Platform A | Feature G | User A | Machine A | 1
86 | IN | Platform A | Feature I | User A | Machine A | 0
87 | OUT | Platform A | Feature I | User A | Machine B | 1
88 | OUT | Platform A | Feature I | User A | Machine B | 1
89 | OUT | Platform A | Feature G | User A | Machine B | 1
90 | OUT | Platform A | Feature G | User A | Machine B | 1
91 | OUT | Platform A | Feature E | User A | Machine B | 1
92 | OUT | Platform A | Feature E | User A | Machine B | 1
93 | IN | Platform A | Feature G | User A | Machine B | 1
94 | IN | Platform A | Feature E | User A | Machine B | 1
95 | OUT | Platform A | Feature I | User A | Machine A | 2
96 | OUT | Platform A | Feature I | User A | Machine A | 2
97 | OUT | Platform A | Feature D | User A | Machine A | 2
98 | OUT | Platform A | Feature D | User A | Machine A | 2
99 | OUT | Platform A | Feature I | User A | Machine A | 2
100 | OUT | Platform A | Feature I | User A | Machine A | 2
101 | IN | Platform A | Feature I | User A | Machine A | 2
102 | IN | Platform A | Feature D | User A | Machine A | 1
103 | out | Platform A | Feature I | User A | Machine B | 1
104 | in | Platform A | Feature I | User A | Machine B | 1
105 | OUT | Platform A | Feature G | User A | Machine A | 2
106 | OUT | Platform A | Feature E | User A | Machine A | 2
107 | out | Platform A | Feature G | User A | Machine A | 2
108 | out | Platform A | Feature E | User A | Machine A | 2
109 | in | Platform A | Feature E | User A | Machine A | 2
110 | in | Platform A | Feature G | User A | Machine A | 2
111 | out | Platform A | Feature G | User A | Machine A | 2
112 | out | Platform A | Feature E | User A | Machine A | 2
113 | in | Platform A | Feature E | User A | Machine A | 2
114 | in | Platform A | Feature G | User A | Machine A | 2
115 | out | Platform A | Feature G | User A | Machine A | 2
116 | out | Platform A | Feature E | User A | Machine A | 2
117 | in | Platform A | Feature E | User A | Machine A | 2
118 | in | Platform A | Feature G | User A | Machine A | 2
119 | out | Platform A | Feature G | User A | Machine A | 2
120 | out | Platform A | Feature E | User A | Machine A | 2
121 | out | Platform A | Feature G | User A | Machine A | 2
122 | out | Platform A | Feature E | User A | Machine A | 2
123 | in | Platform A | Feature E | User A | Machine A | 2
124 | in | Platform A | Feature G | User A | Machine A | 2
125 | IN | Platform A | Feature I | User A | Machine B | 1