Harmonic Alchemy: Reference Spreadsheet

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.


Guy Pople is a music, education and multimedia specialist based in the UK`s North-West. He plays guitars, studies theory and runs St Annes Music in Lytham St. Annes, a one-stop shop for musicians on the Fylde coast of Lancashire. St Annes Music offers professional instruments, recording, tuition and accessories.

His live band Nomad is currently building up their original music. You can catch him
on Virtual Strangers.

Guy Pople

Send comments or questions to: