| Author |
Topic: Excel scale charts help sought |
John McGann
From:
Boston, Massachusetts, USA * R.I.P.
|
Posted 20 Oct 2003 4:43 pm |
|
I just got Joe Wright's excellent Excel scale charts. I have no chops at Excel and am wondering if there is a way (that wouldn't take a programming degree) to convert the number functions in the charts to actual pitches. This would help me to see the notes on the neck with various pedals activated, etc. which I find really useful, as number functions only apply to specific situations, whereas "notes is notes".
BTW Joe did a great job with these and they are well worth checking out! |
|
|
 |
Jim Smith
From:
Midlothian, TX, USA
|
Posted 20 Oct 2003 5:06 pm
|
|
| Ask Joe himself! He should be able to do it for you, or send you a modified spreadsheet. |
|
|
|
John McGann
From:
Boston, Massachusetts, USA * R.I.P.
|
Posted 20 Oct 2003 5:30 pm
|
|
from Joe:
" I used the intervals to be neutral. It
would involve rewriting the spreadsheet to change keys. It has only one
line to read each scale type from.
I would print them out a major scale list with each note value listed under
the interval"
I don't think Joe has the time or inclination to do that; fair enough; different people use learning methods. I am trying to really get each note of the neck in my mind, and these Excel charts could be very helpful in that regard if I could enter the key and have it spit back the notes... |
|
|
|
Graham
From:
Marmora, Ontario, Canada
|
|
|
|
Bob Hoffnar
From:
Austin, Tx
|
Posted 21 Oct 2003 12:07 am
|
|
You could learn everything in C before you move on to other keys. The #'s would represent the notes. A=1, B=2 and so on. By using the numbers your get the added benefit of knowing the function of the note. For instance in the Key of C the E note is represented by the number 3. Now you have a way of visualizing where your major thirds are.
If I'm trying to learn all the pitches up and down the neck I spend some time reading sheet music and saying the notes in a scale as I play it.
Bob[This message was edited by Bob Hoffnar on 21 October 2003 at 01:10 AM.] |
|
|
|
John McGann
From:
Boston, Massachusetts, USA * R.I.P.
|
Posted 22 Oct 2003 1:04 pm
|
|
Totally agreed, Bob, the function numbers make everything transposable- but I find thinking of the pitches really helpful when playing stuff that modulates a lot...it's just a more complete way of looking at things, and I can use all the information I can get on these 20 strings (and those pedals and levers do something too, right?)  |
|
|
|
