search for in

Harmonic Alchemy: Reference Spreadsheet

Rating: 0 user(s) have rated this lesson Posted by: guypople, on Apr 25,2010, in category Music Theory Views: this lesson has been read 679 times
Add lesson into my personal favorites list! Print this lesson!

Here I have collected the information presented in my "Harmonic Alchemy" articles into a reference spreadsheet.
 

  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
 

 

More guitar lessons from guypople
TitleRatingVotesCategoryDate
Practice Methodology 1 - What to do when you are not feeling creative Average rating: 5.0 1Correct PracticeOct 20,2010
THE MODAL DISTILLERY - Transmuting Theory into Practice (Not rated) 0Music TheoryAug 14,2010
Guitar Theory For The Self-Taught (part 4) Average rating: 5.0 1Music TheoryJul 7,2010
Guitar Theory For The Self-Taught (part 3) Average rating: 5.0 1Music TheoryJul 7,2010
Guitar Theory For The Self-Taught (part 2) (Not rated) 0Music TheoryJul 7,2010
Click here to view all guitar lessons of guypople
How would you rate this lesson?

User Feedback

Post your comment (please login or register first)
Comment:
 
Enter the code shown:
Insert Cancel