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
Saint James Infirmary Lead Sheet
Chords, melody and lyrics for the song The Saint James Infirmary Blues! This lead sheet was transcribed by James Louis Steed.
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.

All of these exercises are designed to be printed in a landscape orientation.
Merge Multiple PDF
A very helpful online tool for combining multiple PDF files into a single file.
Public Domain Music Search
http://www.pdinfo.com/public-domain-music-list.php
A handy site that allows for searching for public domain music.
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
Video Game Music MIDI Repository
Web site that is a great starting point for creating sheet music and performing music from video games.
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!

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