Spreadsheet: 723332d1615640587-how-to-calculate-of-slots-which-fit-into-open-capacity-example_task-capacity
Sheet: Sheet1

Additional tasks: | 6 |  | section to demonstrate where additional tasks fit |  |  |  |  |  | 1 | section to demonstrate where additional tasks fit |  |  |  |  |  | 2 | section to demonstrate where additional tasks fit
Time | Day 1 |  |  |  |  |  |  |  | Day 2 |  |  |  |  |  |  | Day 3
00:00:00 | -1 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3 | (1 continue)
00:30:00 | -2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3
01:00:00 | 3 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  | 7
01:30:00 | 0 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
02:00:00 | 5 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
02:30:00 | 8 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
03:00:00 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
03:30:00 | 0 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
04:00:00 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
04:30:00 | 0 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
05:00:00 | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
05:30:00 | 10 |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  | 10
06:00:00 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
06:30:00 | -1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
07:00:00 | 3 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
07:30:00 | -1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
08:00:00 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
08:30:00 | -1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
09:00:00 | 0 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
09:30:00 | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
10:00:00 | -3 |  |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
10:30:00 | -1 |  |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
11:00:00 | -7 |  |  |  |  |  |  |  | -4 |  |  |  |  |  |  | -4
11:30:00 | 3 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 | 2
12:00:00 | 0 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8
12:30:00 | -1 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 6
13:00:00 | 1 |  | 1 |  |  |  |  |  | 4 |  |  |  |  |  |  | 4
13:30:00 | 2 |  |  | 1 |  |  |  |  | 0 |  |  |  |  |  |  | 2
14:00:00 | 9 |  |  |  | 1 |  |  |  | 5 |  |  |  |  |  |  | 5
14:30:00 | 3 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 2
15:00:00 | 6 |  |  |  |  | 1 |  |  | 2 |  |  |  |  |  |  | 2
15:30:00 | 4 |  |  |  |  |  |  |  | -1 |  |  |  |  |  |  | -1
16:00:00 | 6 |  |  |  |  |  | 1 |  | -2 |  |  |  |  |  |  | -2
16:30:00 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
17:00:00 | 3 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  | 3
17:30:00 | 2 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
18:00:00 | 11 |  |  |  |  |  |  | 1 | 8 |  |  |  |  |  |  | 8
18:30:00 | 3 |  |  |  |  |  |  |  | -2 |  |  |  |  |  |  | -2
19:00:00 | 3 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
19:30:00 | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
20:00:00 | 4 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
20:30:00 | 1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
21:00:00 | 2 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  | 2
21:30:00 | -1 |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
22:00:00 | 2 |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1
22:30:00 | 2 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
23:00:00 | 1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1
23:30:00 | -1 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1