Spreadsheet: 95339d1294938961-countif-to-determine-transitions-example
Sheet: notekeysB101

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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