Spreadsheet: 95365d1294950306-countif-to-determine-transitions-scratch
Sheet: notekeysB101

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 21 | 22 | 23 | 24 | 31 | 32 | 33 | 34 | 41 | 42 | 43 | 44
B101C101.asc | 43 | 3 | 4 | 1 | 1 | 1 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 4 | 3 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 1 | 1 | 3 | 1 | 4 | 3 | 2 | 4 | 1 | 1 | 2 | 3 |  |  |  |  |  |  |  | 4 | 2 | 1 | 1 | 0 | 4 | 3 | 4 | 1 | 4 | 4 | 2 | 3 | 1 | 3 | 5
B101C102.asc | 45 | 2 | 2 | 3 | 3 | 2 | 3 | 1 | 2 | 4 | 3 | 2 | 1 | 1 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 1 | 4 | 3 | 3 | 3 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 3 | 3 | 4 | 3 | 3 |  |  |  |  |  | 1 | 1 | 0 | 2 | 2 | 14 | 5 | 2 | 1 | 5 | 5 | 1 | 0 | 2 | 3 | 0
B101C103.asc | 47 | 2 | 3 | 2 | 1 | 3 | 1 | 4 | 1 | 3 | 3 | 2 | 1 | 3 | 3 | 1 | 2 | 1 | 2 | 2 | 2 | 1 | 3 | 4 | 3 | 1 | 2 | 2 | 2 | 3 | 2 | 2 | 4 | 2 | 2 | 2 | 3 | 4 | 4 | 4 | 3 | 2 | 3 | 3 | 1 | 4 | 4 | 2 |  |  |  | 0 | 3 | 4 | 2 | 4 | 7 | 4 | 1 | 4 | 4 | 3 | 2 | 1 | 2 | 2 | 3
B101C104.asc | 42 | 1 | 1 | 2 | 2 | 2 | 4 | 2 | 3 | 3 | 1 | 4 | 3 | 2 | 4 | 3 | 2 | 3 | 3 | 3 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 1 | 2 | 3 |  |  |  |  |  |  |  |  | 2 | 3 | 0 | 1 | 0 | 7 | 8 | 2 | 3 | 6 | 6 | 0 | 0 | 1 | 2 | 0
B101C105.asc | 46 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 2 | 3 | 4 | 2 | 3 | 2 | 1 | 2 | 2 | 4 | 1 | 3 | 2 | 1 | 3 | 1 | 3 | 1 | 1 | 3 | 2 | 1 | 3 | 4 | 1 | 4 | 1 | 2 | 1 | 2 | 1 | 3 | 3 | 1 | 4 | 3 | 1 | 1 | 2 |  |  |  |  | 2 | 4 | 6 | 2 | 5 | 6 | 2 | 2 | 4 | 3 | 1 | 2 | 3 | 2 | 1 | 0
B101C106.asc | 40 | 2 | 3 | 2 | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 4 | 3 | 3 | 4 | 3 | 3 | 2 | 3 | 4 | 3 | 3 | 2 | 3 | 3 | 1 | 4 | 2 | 3 | 1 | 3 | 3 | 3 | 2 | 4 | 2 | 1 | 2 | 4 | 2 | 1 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 1 | 2 | 4 | 5 | 3 | 2 | 4 | 6 | 3 | 0 | 4 | 3 | 0
B101C107.asc | 45 | 2 | 4 | 3 | 1 | 2 | 3 | 4 | 2 | 1 | 4 | 3 | 4 | 3 | 3 | 2 | 2 | 2 | 2 | 4 | 4 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 2 | 2 | 3 | 1 | 3 | 2 | 4 | 1 | 4 | 2 | 1 | 1 | 4 | 1 | 2 | 2 |  |  |  |  |  | 4 | 5 | 1 | 3 | 4 | 6 | 2 | 3 | 2 | 2 | 1 | 2 | 3 | 2 | 3 | 1
B101C108.asc | 43 | 3 | 2 | 2 | 1 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 4 | 3 | 1 | 4 | 4 | 3 | 2 | 1 | 4 | 4 | 3 | 3 | 3 | 1 | 3 | 3 | 4 | 4 | 1 | 1 | 1 | 3 | 3 | 4 | 2 | 3 | 4 | 2 |  |  |  |  |  |  |  | 2 | 0 | 3 | 2 | 2 | 3 | 2 | 1 | 2 | 4 | 9 | 3 | 1 | 2 | 3 | 3
B101C109.asc | 44 | 1 | 4 | 4 | 3 | 1 | 1 | 1 | 3 | 4 | 1 | 4 | 2 | 1 | 4 | 2 | 1 | 2 | 3 | 2 | 2 | 3 | 4 | 3 | 3 | 3 | 4 | 2 | 1 | 1 | 3 | 3 | 2 | 3 | 3 | 4 | 4 | 1 | 3 | 4 | 3 | 1 | 4 | 1 | 1 |  |  |  |  |  |  | 4 | 1 | 3 | 4 | 3 | 1 | 3 | 0 | 2 | 2 | 4 | 5 | 3 | 3 | 3 | 2
B101C110.asc | 43 | 2 | 2 | 1 | 2 | 1 | 3 | 4 | 3 | 2 | 1 | 1 | 2 | 2 | 2 | 3 | 1 | 3 | 3 | 1 | 4 | 4 | 1 | 1 | 2 | 4 | 2 | 2 | 2 | 2 | 1 | 3 | 2 | 2 | 4 | 4 | 2 | 2 | 2 | 3 | 1 | 4 | 2 | 1 |  |  |  |  |  |  |  | 2 | 3 | 3 | 2 | 5 | 9 | 2 | 2 | 3 | 2 | 1 | 1 | 1 | 3 | 1 | 2
B101C111.asc | 50 | 1 | 4 | 1 | 1 | 4 | 1 | 1 | 4 | 3 | 1 | 4 | 2 | 4 | 1 | 3 | 4 | 4 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 1 | 1 | 1 | 2 | 1 | 3 | 2 | 4 | 2 | 1 | 2 | 2 | 4 | 4 | 3 | 4 | 2 | 4 | 3 | 3 | 1 | 1 | 5 | 2 | 2 | 4 | 2 | 1 | 1 | 4 | 2 | 2 | 8 | 3 | 4 | 3 | 4 | 2
B101C112.asc | 43 | 3 | 3 | 1 | 4 | 3 | 1 | 2 | 1 | 3 | 3 | 2 | 3 | 3 | 4 | 4 | 3 | 2 | 3 | 3 | 4 | 3 | 2 | 4 | 4 | 4 | 2 | 2 | 1 | 4 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 4 | 2 | 2 | 4 | 1 | 2 | 4 |  |  |  |  |  |  |  | 1 | 4 | 1 | 2 | 4 | 3 | 2 | 4 | 2 | 3 | 4 | 2 | 1 | 3 | 3 | 3
B101C113.asc | 42 | 1 | 4 | 3 | 1 | 1 | 3 | 3 | 2 | 2 | 3 | 1 | 1 | 4 | 4 | 1 | 1 | 2 | 2 | 1 | 1 | 4 | 4 | 3 | 3 | 1 | 4 | 3 | 3 | 4 | 2 | 2 | 4 | 2 | 4 | 4 | 3 | 3 | 1 | 1 | 4 | 1 | 4 |  |  |  |  |  |  |  |  | 5 | 1 | 1 | 6 | 1 | 3 | 1 | 2 | 4 | 1 | 4 | 1 | 2 | 2 | 4 | 3
B101C114.asc | 40 | 3 | 4 | 4 | 4 | 3 | 2 | 3 | 3 | 2 | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 4 | 2 | 1 | 4 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 1 | 1 | 1 | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 11 | 1 | 3 | 1 | 2 | 0 | 1 | 1 | 2 | 2 | 4 | 3 | 1 | 1 | 3 | 3
B101C115.asc | 43 | 3 | 1 | 4 | 4 | 4 | 3 | 1 | 3 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 4 | 2 | 2 | 4 | 1 | 1 | 3 | 2 | 3 | 4 | 4 | 2 | 1 | 3 | 3 | 1 | 1 | 4 | 1 | 1 | 2 | 2 | 1 | 2 | 4 | 1 | 4 | 3 |  |  |  |  |  |  |  | 3 | 2 | 3 | 3 | 2 | 2 | 1 | 2 | 3 | 1 | 4 | 4 | 3 | 2 | 4 | 3
B101C201.asc | 41 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 1 | 4 | 3 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 1 | 1 | 3 | 1 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 1 | 4 | 4 | 2 | 3 | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 | 2 | 0 | 1 | 5 | 0 | 3 | 2 | 11 | 2 | 2 | 1 | 2 | 5
B101C202.asc | 45 | 3 | 4 | 3 | 3 | 3 | 3 | 1 | 2 | 2 | 3 | 3 | 3 | 1 | 3 | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 2 | 3 | 3 | 3 | 1 | 2 | 2 | 4 | 2 | 4 | 1 | 4 | 1 | 1 | 2 | 4 | 2 | 2 | 3 | 4 | 3 | 1 | 4 | 4 |  |  |  |  |  | 1 | 3 | 1 | 2 | 0 | 4 | 5 | 3 | 4 | 3 | 9 | 2 | 2 | 2 | 2 | 1
B101C203.asc | 41 | 1 | 4 | 1 | 3 | 4 | 3 | 3 | 4 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 1 | 2 | 4 | 2 | 2 | 1 | 3 | 4 | 4 | 2 | 4 | 3 | 3 | 2 | 4 | 4 | 3 | 4 | 2 | 4 | 2 | 2 | 4 | 3 |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 1 | 2 | 4 | 2 | 5 | 0 | 4 | 3 | 4 | 1 | 4 | 5 | 2
B101C204.asc | 48 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 2 | 3 | 2 | 2 | 4 | 2 | 3 | 4 | 1 | 4 | 1 | 1 | 1 | 3 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 1 | 3 | 3 | 1 | 3 | 4 | 3 | 2 | 3 | 4 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 2 | 3 |  |  | 2 | 0 | 4 | 1 | 0 | 2 | 7 | 1 | 2 | 7 | 11 | 4 | 3 | 1 | 2 | 0
B101C205.asc | 45 | 3 | 3 | 4 | 2 | 1 | 1 | 3 | 3 | 2 | 2 | 2 | 1 | 1 | 2 | 4 | 2 | 2 | 3 | 4 | 1 | 4 | 3 | 1 | 2 | 1 | 4 | 3 | 2 | 4 | 4 | 2 | 3 | 2 | 4 | 1 | 3 | 1 | 2 | 4 | 2 | 2 | 1 | 2 | 2 | 3 |  |  |  |  |  | 2 | 4 | 2 | 2 | 4 | 5 | 3 | 4 | 2 | 3 | 2 | 2 | 2 | 4 | 2 | 1
B101C206.asc | 43 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 4 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 4 | 4 | 4 | 3 | 3 | 1 | 3 | 4 | 1 | 2 | 4 | 4 | 4 | 1 |  |  |  |  |  |  |  | 0 | 1 | 1 | 0 | 0 | 14 | 4 | 3 | 1 | 3 | 4 | 2 | 2 | 2 | 1 | 4
B101C207.asc | 49 | 3 | 2 | 1 | 2 | 2 | 4 | 2 | 1 | 3 | 3 | 2 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 3 | 2 | 1 | 4 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 1 | 4 | 3 | 3 | 3 |  | 0 | 1 | 1 | 2 | 4 | 11 | 4 | 1 | 0 | 7 | 14 | 0 | 0 | 1 | 2 | 0
B101C208.asc | 43 | 4 | 3 | 4 | 4 | 3 | 3 | 1 | 4 | 1 | 3 | 4 | 3 | 4 | 2 | 4 | 1 | 2 | 3 | 4 | 4 | 2 | 2 | 2 | 2 | 4 | 2 | 2 | 2 | 4 | 1 | 3 | 3 | 2 | 1 | 2 | 2 | 2 | 2 | 1 | 3 | 3 | 4 | 2 |  |  |  |  |  |  |  | 0 | 2 | 3 | 1 | 2 | 8 | 1 | 3 | 1 | 1 | 3 | 5 | 3 | 4 | 3 | 2