ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
12(improv)
LookupTable
2
G5.harmHelperMOD( value( mid( long_pi, row() + random_offset, 4) ), H7 - G7 + 1) * step + G7
3
to be pasted into row ?
EXPLANATIONS of each step of the formula on this side
4
5
=iferror(
Basically, this is saying
as long as currTonic isn't "-"
6
TEXT( mid( index( currTonic, row(), 1 ), 1, 2 ), "00" )
Take the root of the currTonic (00 format) and append
7
& "-" & -
8
MOD( VALUE( MID( index( currTonic, row(), 1 ), 7, 2 ) ) + 12 -
and also the difference between the 3rd degree of the currTonic and the first degree
9
VALUE( MID( index( currTonic, row(), 1 ), 1, 2 ) ), 12 ) - 3
minus 3, giving us 1 for major and 0 for minor
10
,
11
"-"
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
)
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100