Harmonic Alchemy: Modes, Chord Scales and Substitutions Reference Spreadsheet by Guy Pople
Here I have collected the information presented in my "Harmonic Alchemy" articles into a reference spreadsheet.
GUIDANCE:
1) Generate modes in all positions
2) Use the CAGED system to generate 5 shapes of each chord + matching 1/2/3 octave arpeggios.
3) Now try the following chord progression Dm7 - G7 - G#7 #5 #9 - Am7 - Am9 - B dim7 - E7 - Am add9 which demonstrates how substitutions can be applied.
- It takes a regular Dm - G - Am - Bmb5 - E - Am and introduces a range of substitutions, both diatonic and non-diatonic.
4) Attempt to complete the fields which have been left blank.
KEY = C / Am	I major - Ionian	ii min - Dorian	ii min - Phrygian	IV major -Lydian	V major - Mixolydian	vi minor - Aeolian	vii dim - Locrian
	TONIC	SUPERTONIC	MEDIANT	SUB-DOMINANT	DOMINANT	SUB-MEDIANT	LEADING TONE
							(or SUB-TONIC)
INTERVALS - ascending in 3rds
R	C	D	E	F	G	A	B
3	E	F	G	A	B	C	D
5	G	A	B	C	D	E	F
7	B	C	D	E	F	G	A
2/9	D	E	F	G	A	B	C
4/11	F	B	A	B	C	D	E
6/13	A	G	C	D	E	F	G
CHORDS - stacked 3rds + common extensions
R 3 5	I maj	ii min	iii min	IV maj	V maj	vi min	vii dim
R 3 5 7	I maj7	ii min7	iii min7	IV maj7	V dom7	vi min7	vii min7b5
R 3 5 9	I maj add9	ii min add9	iii min add b9	IV maj add9	V maj add9	vi min add9	vii min b5add b9
R 3 5 7 9	I maj9	ii min9	iii min7 b9	IV maj9	V dom9	vi min9	vii min7 b5 b9
R 3 5 11	I maj add11	ii min add 11	iii min add11	IV maj add11	V maj add11	vi min add11	vii min b5 add 11
R 3 5 7 11	I maj11	ii min11	iii min 11	V maj7 #11	V dom11	vi min11	vii min 11 b5
R 3 5 13 (or 6)	I maj add13	ii min add 13	ii min add b13	IV maj add13	V maj add 13	vi min add b13	vii m b5 b13
R 3 5 7 13	I maj13	ii min13	ii min b13	IV maj13	V dom13	vi min b13	vii m7 b5 b13
INVERSIONS - common examples
3 5 R	I 3/6	ii	iii	IV	V	vi	vi dim
5 R 3	I 4/6	ii	iii	IV	V	vi	vi dim
3 5 7 R	I 3/5/6	ii	iii	IV	V	vi	vi dim
Introduce intervals 9, 11 and 13
SUSPENSIONS - common examples
R 2 5	I sus2	ii sus2	iii sus b2	IV sus 2	V sus2	vi sus2	vii sus b2
R 4 5	I sus4	ii sus4	iii sus4	IV sus #4	V sus4	vi sus4	vii sus4
Introduce suspended Roots and 5ths
KEY = A HARMONIC MINOR (Aeolian maj7)	i minor - Aeolian #7	ii dim - Locrian #6	III major - Ionian #5	iv minor - Dorian #4	V major - Phrygian #3	VI major - Lydian #2	# vi dim - Mixolydian #1
INTERVALS - ascending in 3rds
R	A	B	C	D	E	F	G#
3	C	D	E	F	G#	A	B
5	E	F	G#	A	B	C	D
7	G#	A	B	C	D	E	F
9 or 2	B	C	D	E	F	G#	A
2/9	D	E	F	G#	A	B	C
4/11	F	G#	A	B	C	D	E
6/13
	i min	ii dim	III aug	iv min	V maj	VI maj	vii dim
Significant deviations in red
					V dom7 b9	vi dim7
11 or 4	D	E	F	G#	A	B	C
13 or 6	F	G#	A	B	C	D	E
SUBSTITUTIONS - common examples	i min (R b3 5)	ii dim (R b3 b5)	III aug (R 3 #5)	iv min (R b3 b5)	V maj (R 3 5)	VI maj (R 3 5)	#vii dim (R b3 b5)
	I min [maj7] (R b3 5 7)	ii dim7 (R b3 b5 bb7)	III maj7 +5 (R 3 #5 7)	iv dim7 (R b3 b5 bb7)	V dom7 (R 3 5 b7)	vi min (R b3 b5)	#vii dim7 (R b3 b5 bb7)
	i	ii	III	iv	V	vi dim7 (R b3 b5 bb7)	#vii
	i	ii	III	iv	V	VI	#vii
	i	ii	III	iv	V	VI	#vii
	i	ii	III	iv	V	VI	#vii
	i	ii	III	iv	V	VI	#vii
	i	ii	III	iv	V	VI	#vii
Introduce Suspended and Inverted chords featuring the G#
KEY = A MELODIC MINOR (Aeolian maj 6, 7)	i minor - Aeolian #6,#7	ii minor - locrian #5,#6	III aug - Ionian #4,#5	IV major - Dorian #3,#4	V major - Phrygian #2,#3	vi dim - Lydian #1,#2	vii dim - Mixolydian #7,#1
INTERVALS - ascending in 3rds
R	A	B	C	D	E	F#	G#
3	C	D	E	F#	G#	A	B
5	E	F#	G#	A	B	C	D
7	G#	A	B	C	D	E	F#
9 or 2	B	C	D	E	F#	G#	A
11 or 4	D	E	F#	G#	A	B	C
13 or 6	F#	G#	A	B	C	D	E
SUBSTITUTIONS - common examples	i min (R b3 5)	ii min (R b3 5)	III aug (R 3 #5)	IV maj	V maj (R 3 5)	#vi dim (R b3 bb5)	#vii dim (R b3 b5)
	i min6 (R b3 5 6)	ii min7 (R b3 5 b7)	III maj7 b5 (R 3 b5 7)	IV dom7 b5	V dom9 (R 3 5 b7)	#vi min7 b5 (R b3 b5 b7)	#vii m7 b5 (R b3 b5 b7)
	i	ii min6 (R b3 5 6)	III	IV	V aug (R 3 #5)	#vi	#VII dom7 #5 #9 (R 3 #5 b7 #9)
	i	ii	III	IV	V	#vi	#vii
	i	ii	III	IV	V	#vi	#vii
	i	ii	III	IV	V	#vi	#vii
	i	ii	III	IV	V	#vi	#vii
	i	ii	III	IV	V	#vi	#vii
Introduce Suspended and Inverted chords featuring the F# and G#						NOTE
						Dom 7 with sharp or flat 5ths or 9ths are
						collectively known as Altered Dominants.
						e.g. chords IV and VII in A Melodic Minor