Spreadsheet: 165253d1341125112-combining-negative-data-automate-counting-negative-staffing-sectors-bigjess-oeldere-
Sheet: Sheet1

COLUMNS: |  |  |  |  |  |  |  | NET
time | T2 | T3 | T4 | T5 | T6 | T7 | T8 | NET | T10 | T11 | negative | group | T14 |  | negative | (Meerdere items)
12:00AM |  | 11 |  | 873.33 |  | 8.02 | 8.27 | 2.23 | 10.5 | 96.15 |  | 3
12:30AM |  | 9 |  | 865.8 |  | 6.78 | 6.99 | 3.51 | 10.5 | 99 |  | 3 |  |  |  | Waarden
1:00AM |  | 4 |  | 853.1 |  | 3.65 | 3.76 | 5.24 | 9 | 99.98 |  | 1 |  |  | Rowlabels | Sum negative | [NAME] negative
1:30AM |  | 3 |  | 820.44 |  | 2.91 | 3 | 7.5 | 10.5 | 100 |  | 1 |  |  | 1 | 15 | 8
2:00AM |  | 2 |  | 771.55 |  | 2.15 | 2.22 | 6.28 | 8.5 | 100 |  | 1 |  |  | 2 | 0 | 0
[NAME] |  | 2 |  | 702.06 |  | 2.03 | 2.09 | 5.41 | 7.5 | 100 |  | 1 |  |  | 3 | 6 | 6
3:00AM |  | 1 |  | 629.85 |  | 1.29 | 1.33 | -7.2 | 6.5 | 100 | 8 | 1 |  |  | 4 | 5 | 5
3:30AM |  | 2 |  | 561.54 |  | 1.77 | 1.82 | -6.1 | 10 | 100 | 7 | 1 |  |  | 5 | 19 | 7
4:00AM |  | 2 |  | 500.39 |  | 1.65 | 1.7 | 4 | 7 | 100 |  | 1 |  |  | 6 | 14 | 7
4:30AM |  | 1 |  | 454.4 |  | 1.09 | 1.12 | -4.1 | 8.5 | 100 |  | 2 |  |  | Endtotaal | 59 | 8
5:00AM |  | 3 |  | 434.9 |  | 1.92 | 1.98 | 4.52 | 6.5 | 100 |  | 2
5:30AM |  | 2 |  | 446.15 |  | 1.54 | 1.59 | 7.41 | 9 | 100 |  | 2
6:00AM |  | 4 |  | 486.15 |  | 2.47 | 2.55 | 4.45 | 7 | 99.99 |  | 2
6:30AM |  | 5 |  | 538.59 |  | 3.07 | 3.16 | 5.34 | 8.5 | 99.99 |  | 2
7:00AM |  | 5 |  | 596.46 |  | 3.3 | 3.4 | 3.6 | 7 | 99.82 |  | 2
7:30AM |  | 3 |  | 636.65 |  | 2.45 | 2.53 | 4.97 | 7.5 | 99.99 |  | 2
[NAME] |  | 10 |  | 669.85 |  | 6 | 6.19 | 2.31 | 8.5 | 97.32 |  | 2
8:30AM |  | 12 |  | 708.05 |  | 7.24 | 7.46 | 3.54 | 11 | 98.92 |  | 3
[NAME] |  | 15 |  | 758.48 |  | 9.17 | 9.45 | 0.88 | 10.33 | 88.64 |  | 3
9:30AM |  | 19 |  | 801.94 |  | 11.7 | 12.06 | 1.94 | 14 | 93.68 |  | 3
10:00AM |  | 23 |  | 829.24 |  | 14.16 | 14.6 | -2.27 | 12.33 | 43.16 |  | 3
10:30AM |  | 29 |  | 845.39 |  | 17.59 | 18.13 | -1.13 | 17 | 67.37 |  | 3
11:00AM |  | 31 |  | 861.72 |  | 18.96 | 19.55 | -5.72 | 13.83 | 0 | 6 | 3
11:30AM |  | 34 |  | 883.67 |  | 21.03 | 21.68 | -4.18 | 17.5 | 8.65 |  | 3
12:00PM |  | 33 |  | 905.63 |  | 20.94 | 21.59 | -6.59 | 15 | 0 | 7 | 6
12:30PM |  | 32 |  | 921.96 |  | 20.71 | 21.35 | -3.85 | 17.5 | 17.38 |  | 6
1:00PM |  | 33 |  | 925.13 |  | 21.34 | 22 | -5 | 17 | 0 | 5 | 4
1:30PM |  | 34 |  | 921.05 |  | 21.83 | 22.51 | -1.51 | 21 | 64.31 |  | 4
2:00PM |  | 32 |  | 918.06 |  | 20.63 | 21.27 | -1.27 | 20 | 66.84 |  | 4
2:30PM |  | 30 |  | 924.95 |  | 19.62 | 20.23 | 1.77 | 22 | 90.95 |  | 4
3:00PM |  | 31 |  | 932.84 |  | 20.35 | 20.98 | 0.52 | 21.5 | 83.99 |  | 4
3:30PM |  | 30 |  | 938.83 |  | 19.89 | 20.51 | 1.99 | 22.5 | 91.85 |  | 4
4:00PM |  | 32 |  | 935.2 |  | 20.97 | 21.62 | 0.88 | 22.5 | 86.21 |  | 4
4:30PM |  | 31 |  | 933.66 |  | 20.37 | 21 | 2 | 23 | 91.76 |  | 5
5:00PM |  | 33 |  | 932.39 |  | 21.49 | 22.15 | -1.15 | 21 | 68.5 |  | 5
5:30PM |  | 34 |  | 936.65 |  | 22.16 | 22.85 | -4.35 | 18.5 | 7.8 |  | 5
6:00PM |  | 30 |  | 942.82 |  | 19.96 | 20.58 | -3.08 | 17.5 | 34.96 |  | 5
6:30PM |  | 31 |  | 954.07 |  | 20.77 | 21.41 | -0.41 | 21 | 76.39 |  | 5
7:00PM |  | 33 |  | 970.04 |  | 22.27 | 22.96 | -6.96 | 16 | 0 | 7 | 5
7:30PM |  | 32 |  | 981.56 |  | 21.91 | 22.59 | -5.59 | 17 | 0 | 6 | 5
8:00PM |  | 25 |  | 983.55 |  | 17.67 | 18.22 | -5.59 | 14.5 | 13.43 | 6 | 5
8:30PM |  | 23 |  | 974.3 |  | 16.3 | 16.8 | -1.8 | 15 | 56 |  | 6
9:00PM |  | 24 |  | 967.5 |  | 16.81 | 17.33 | -2.83 | 14.5 | 35.27 |  | 6
9:30PM |  | 21 |  | 969.95 |  | 15.02 | 15.48 | -0.48 | 15 | 74.88 |  | 6
10:00PM |  | 24 |  | 980.83 |  | 17.02 | 17.55 | -6.05 | 11.5 | 0 | 7 | 6
10:30PM |  | 14 |  | 987.55 |  | 10.82 | 11.15 | 0.35 | 11.5 | 83.64 |  | 6
11:00PM |  | 15 |  | 986.91 |  | 11.46 | 11.81 | 2.19 | 14 | 94.64 |  | 6
11:30PM |  | 10 |  | 981.83 |  | 8.17 | 8.42 | 4.58 | 13 | 99.48 |  | 6
12:00AM