Warning: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in ..../includes/class_bbcode.php on line 2968 Excel Fretboard Spreadsheet
Not sure if this really belongs here, but it seemed to fit this topic area as well as any....
I use MS Excel extensively where I work, so got playing around to see if I could make a little guitar fretboard tool with it. The ZIP file attached below contains the resulting spreadsheet. Could be useful for a couple of things:
You can select the open note for each string and the rest of the notes will fill in for that string, down to the 22nd fret. Seemed to me to be a handy way to see what the note sequences were for alternate/open tunings, etc. There's also a "reference" fretboard shown for the standard E-A-D-G-B-E tuning scheme.
Additionally, below the editable fretboard, you can select notes (from a particular chord, for example) and they will be highlighted in green on the fretboard. You can even select notes (up to 7) and then change the tuning pattern, and their new positions will be displayed.
Feel free to play around w/ it and comment or ask questions. The spreadsheet is "protected", so only the pale yellow colored cell entries can be changed. These are edited using a dropdown selection list (just click the little down arrow at the right side of the selected cell), so you don't have to type in anything manually. Obviously, you have to have MS Excel or other compatible spreadsheet program on your PC to be able to open/edit this file.
Excel Fretboard Spreadsheet
Reply With Quote