ABCDEFGHIJK
1
The 7 diatonic modes
2
M →-3-2-10123
We assign an integer M to each mode, with higher meaning "brighter"
3
↓ RLOCPHRAEODORMIXIONLYD
You can File/"Make a copy" and change this to another value like 19 →
12
4
Here, the row number (R) is a scale degree (minus 1); the colored value is how many semitones above the root that scale degree is in that mode.
5
00000000←=round(($K$3 * $A5 + H$2)/7)
6
11122222[In English: (12R + M) / 7, rounded]
7
23333444
8
35555556
9
46777777
10
58889999
11
610101010101111
12
712121212121212
13
14
Here, the row number (R) is a number of semitones above the root; a check mark appears if that note is part of that mode.
15
0←=mod($A15 * 7 -H$2 + 3, $K$3) < 7
16
1[In English: is (7R - M + 3) less than 7 (mod 12)?]
17
2
18
3
19
4
20
5
21
6
22
7
23
8
24
9
25
10
26
11
27
12
28
13
29
14
30
15
31
16
32
17
33
18
34
19
35
20
36
21
37
22
38
23
39
24
40
25
41
26
42
27
43
28
44
29
45
30
46
31