Create a Dynamic List From a Header Name in Excel

I use this formula constantly to limit selections in cells in Excel. This formula allows you to not only have the list auto-populate as you add elements to it, but it also allows you to move your list to a different area within your sheet and maintain the list without having to change your formula. Continue reading Create a Dynamic List From a Header Name in Excel

The Raven Full Poem Text

Once upon a midnight dreary, while I pondered, weak and weary,
Over many a quaint and curious volume of forgotten lore—
While I nodded, nearly napping, suddenly there came a tapping,
As of some one gently rapping, rapping at my chamber door.
“‘Tis some visiter,” I muttered, “tapping at my chamber door—
Only this and nothing more.” Continue reading The Raven Full Poem Text

From Beyond Full Story Text

Horrible beyond conception was the change which had taken place in my best friend, Crawford Tillinghast. I had not seen him since that day, two months and a half before, when he had told me toward what goal his physical and metaphysical researches were leading; when he had answered my awed and almost frightened remonstrances by driving me from his laboratory and his house in a burst of fanatical rage. I had known that he now remained mostly shut in the attic laboratory with that accursed electrical machine, eating little and excluding even the servants, but I had not thought that a brief period of ten weeks could so alter and disfigure any human creature. Continue reading From Beyond Full Story Text

Dominant Chord Diagrams With Notations

These diagrams are designed to connect the notes on the guitar with musical notation for dominant chords.  One of the theories I learned from the chord chemist, Ted Greene, is that there are 4 possible inversions of 4 note chords on a particular set of 4 strings.  I have applied this theory to these diagrams.  Use these to train your fingers to create dominant chords as well as train yourself to recognize notes on the guitar, their relationship to musical notation as well as recognition of intervals on the notation staff.

Click here to edit/download PDF.

All of these exercises are designed to be printed in a landscape orientation.

Introduction to a Musician’s Literacy

Consider this an introductory post to James’ musical literacy project.  In recent weeks, I have dedicated a large amount of my time towards becoming a literate musician.  That is to say, I’m determined to be able to write and site-read musical notation.  I am already, what I would consider to be, a competent musician and guitarist but one of the things that has always bothered me and has limited my growth as a musician is that I cannot write or site-read musical notation.  I have a rudimentary knowledge of the bass and treble staffs and can, with some thought and calculation, determine notes on the staffs.  However, my ability to hear and perform what is written on paper is weak at best. Continue reading Introduction to a Musician’s Literacy

Ten Pages of Blank Guitar Fret Board Diagrams

Blank guitar fret board diagrams are extremely useful tools when learning how the guitar fits into the musical spectrum.  It’s a puzzle that is solved by study but needs to be solved instantaneously while playing.  Use these to help you to find patters and locations on the fret board.  There are 10 pages in this PDF file.  If you need more, download more!  Print, study, repeat.  I spent many an hour on some blank diagrams I got from someone else.  Those are used up so I decided to make my own.  Enjoy!

Click here to download/view the PDF.

All of these exercises are designed to be printed in a landscape orientation.