ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAG
1
12(improv)
LookupTable
2
G5.harmHelper2

See the comment in the main sheet for this column and paste it here.		MOD( 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
=if(
Basically, this is saying
6
AND( index( plannedMeasure, row(), 1 ) <> "-", index( currMeasure, row(), 1 ) <> "-" ),
as long as currMeasure isn't "-"
7
if(
8
AND(
9
MOD( index( currMeasure, row(), 1 ), 8 ) = 1,
10
MOD( index( plannedMeasure, row(), 1 ), 8 ) = 2
11
) ,
12
TEXT( index( harmGroot, row(), 1 ), "00" )
13
& "-" & index( harmGkind, row(), 1 )
14
,
15
index( G5.harmHelper2, row() - 1, 1 )
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