Spreadsheet: 134837d1325670895-not-include-some-values-in-arrays-based-on-a-further-test-joels-sample-sheet1-
Sheet: Sheet1

Task | Variable | Component | REFDES | R/I | I | T |  |  |  |  |  |  | R/I | I | T
1 | 1 |  |  | a |  |  | 1.1 | 1 | 0 |  |  | 1 | DONE | INCOMPLETE
 | 2 |  |  |  |  |  | 1.2 | 0 | 0 |  |  | 2 | INCOMPLETE | INCOMPLETE
 | 3 |  |  |  |  |  | 1.3 | 0 | 0 |  |  | 3 | INCOMPLETE | INCOMPLETE
 | 4 |  |  |  |  |  | 1.4 | 0 | 0 |  |  | 4 | INCOMPLETE | INCOMPLETE
2 | 1 |  |  |  |  |  | 2.1 | 0 | 0 | 0 | INCOMPLETE | 5 | DONE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  | a |  |  |  | 1 | 0 | 0
 | 2 |  |  |  |  | a | 2.2 | 0 | 0 | 1 | DONE | 6 | INCOMPLETE | INCOMPLETE | DONE
 | 3 |  |  |  |  |  | 2.3 | 0 | 0 | 0 | INCOMPLETE | 7 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
3 | 1 |  |  |  |  |  | 3.1 | 0 | 0 | 0 | INCOMPLETE | 8 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 3.2 | 0 | 0 | 0 | INCOMPLETE | 9 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | 3 |  |  |  |  |  | 3.3 | 0 | 0 | 0 | INCOMPLETE | 10 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 4 |  |  |  |  |  | 3.4 | 0 | 0 | 0 | INCOMPLETE | 11 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
4 | 1 |  |  |  |  |  | 4.1 | 0 | 0 | 0 | INCOMPLETE | 12 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | 2 |  |  |  |  |  | 4.2 | 0 | 0 | 0 |  | 13 | INCOMPLETE | INCOMPLETE | INCOMPLETE
5 | 1 |  |  |  |  |  | 5.1 | 0 | 0 | 0 | INCOMPLETE | 14 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 5.2 | 0 | 0 | 0 | INCOMPLETE | 15 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 3 |  |  |  |  |  | 5.3 | 0 | 0 | 0 | INCOMPLETE | 16 | INCOMPLETE | INCOMPLETE | INCOMPLETE
6 | 1 |  |  |  |  |  | 6.1 | 0 | 0 | 0 | INCOMPLETE | 17 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 6.2 | 0 | 0 | 0 | INCOMPLETE | 18 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | 3 |  |  |  |  |  | 6.3 | 0 | 0 | 0 | INCOMPLETE | 19 | INCOMPLETE | INCOMPLETE | INCOMPLETE
7 | 1 |  |  |  |  |  | 7.1 | 0 | 0 | 0 | INCOMPLETE | 20 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 7.2 | 0 | 0 | 0 | INCOMPLETE | 21 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
8 | 1 |  |  |  |  |  | 8.1 | 0 | 0 | 0 | INCOMPLETE | 22 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 8.2 | 0 | 0 | 0 | INCOMPLETE | 23 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
9 | 1 |  |  |  |  |  | 9.1 | 0 | 0 | 0 | INCOMPLETE | 24 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
10 | 1 |  |  |  |  |  | 10.1 | 0 | 0 | 0 | INCOMPLETE | 25 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
11 | 1 |  |  |  |  |  | 11.1 | 0 | 0 | 0 | INCOMPLETE | 26 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
12 | 1 |  |  |  |  |  | 12.1 | 0 | 0 | 0 | INCOMPLETE | 27 | INCOMPLETE | INCOMPLETE | INCOMPLETE
13 | 1 |  |  |  |  |  | 13.1 | 0 | 0 | 0 | INCOMPLETE | 28 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | 2 |  |  |  |  |  | 13.2 | 0 | 0 | 0 | INCOMPLETE | 29 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 3 |  |  |  |  |  | 13.3 | 0 | 0 | 0 | INCOMPLETE | 30 | INCOMPLETE | INCOMPLETE | INCOMPLETE
14 | 1 |  |  |  |  |  | 14.1 | 0 | 0 | 0 | INCOMPLETE | 31 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
15 | 1 |  |  |  |  |  | 15.1 | 0 | 0 | 0 | INCOMPLETE | 32 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 15.2 | 0 | 0 | 0 | INCOMPLETE | 33 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
16 | 1 |  |  |  |  |  | 16.1 | 0 | 0 | 0 | INCOMPLETE | 34 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 16.2 | 0 | 0 | 0 | INCOMPLETE | 35 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | & |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 3 |  |  |  |  |  | 16.3 | 0 | 0 | 0 | INCOMPLETE | 36 | INCOMPLETE | INCOMPLETE | INCOMPLETE
17 | 1 |  |  |  |  |  | 17.1 | 0 | 0 | 0 | INCOMPLETE | 37 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 17.2 | 0 | 0 | 0 | INCOMPLETE | 38 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 | 3 |  |  |  |  |  | 17.3 | 0 | 0 | 0 | INCOMPLETE | 39 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 4 |  |  |  |  |  | 17.4 | 0 | 0 | 0 | INCOMPLETE | 40 | INCOMPLETE | INCOMPLETE | INCOMPLETE
18 | 1 |  |  |  |  |  | 18.1 | 0 | 0 | 0 | INCOMPLETE | 41 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 | 2 |  |  |  |  |  | 18.2 | 0 | 0 | 0 | INCOMPLETE | 42 | INCOMPLETE | INCOMPLETE | INCOMPLETE
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  | Total Tasks | 42 |  |  |  |  | 43 | #N/A | #N/A | #N/A