Eric
October 24th, 2009, 09:56 AM
Hi all,
A while ago, I started a home-made spreadsheet to try to help me with fretboard visualization, along with polishing some of my Excel skills. The file is here:
http://www.box.net/shared/uyc6tbi8gf
I've been working on it in Open Office 3.0, so please excuse me if there are some formatting burps. My question is this:
The punchline in here at the current time is the fretboard based on key, like the 'G major fretboard.' The only way I could find to automate this by punching in a new letter was to use the INDIRECT function, which, if I'm remembering correctly, takes a string and converts it to a cell designation. This, coupled with a concatenation operator (&), lets me point the spreadsheet to the correct chromatic scale above.
This is a big pain in the butt and not very maintainable. Is there an easier way?
Please forgive me if this is super-stupid and childish in your opinion; I am interested in automating this stuff and learning some simple programming, but I'm still getting my feet wet. If there are any overhauls you can suggest that would make the ENTIRE thing easier, I'm all ears/eyes.
A while ago, I started a home-made spreadsheet to try to help me with fretboard visualization, along with polishing some of my Excel skills. The file is here:
http://www.box.net/shared/uyc6tbi8gf
I've been working on it in Open Office 3.0, so please excuse me if there are some formatting burps. My question is this:
The punchline in here at the current time is the fretboard based on key, like the 'G major fretboard.' The only way I could find to automate this by punching in a new letter was to use the INDIRECT function, which, if I'm remembering correctly, takes a string and converts it to a cell designation. This, coupled with a concatenation operator (&), lets me point the spreadsheet to the correct chromatic scale above.
This is a big pain in the butt and not very maintainable. Is there an easier way?
Please forgive me if this is super-stupid and childish in your opinion; I am interested in automating this stuff and learning some simple programming, but I'm still getting my feet wet. If there are any overhauls you can suggest that would make the ENTIRE thing easier, I'm all ears/eyes.