Respond to This

USING EXCEL TO EMBED STUFF IN YOUR BRAIN

I just wondered if anyone had tried to develop matrices in excel or other spreadsheets to illustrate the patterns, overlaps and superimpositions of, say, the blues scales over other scales ( and where the scales differ), as a learning process (and for the sheer fun of it). I suspect there is no limit to what you can do. I am also transposing this stuff on to an excel "fretboard". To develop a Fretboard you are disciplined to actually type all the notes on there - of course you CAN cut and paste - but you know what I mean.

I am finding that the process of doing this is increasing my understanding and ability to visualise what's going on very rapidly.

As an example, if you have a lateral "row" itemising all the notes in the chromatic scale starting with C, and vertical "columns" that intersect those notes on the basis WWHWWWH, the point at which these notes intersect is your C major Scale - or am I way off here? It seems to work for me, anyhow. BTW, you give the relevant column a color.

In saying all this, I'd like to make a few things clear:

1. I am not trying to re-invent the wheel - I know the stuff is in guitar basics.
2. My major purpose is to learn via the process of doing it - It makes me/you identify the notes in various scales, and makes you know what notes are in a scale and why. In other words, to develop a matrix or a formula for the notes to fall into place in the matrix, and by extension, on the fretboard, you have to know what notes are in a scale and what the intervals are - and where the notes are on the fretboard too!
3. I am not trying to rid music of spontaneity by making it "computerised'- its just that so many people use excel and word each day at work that its seems a useful way to go about learning the stuff - for some.
4. I am not an excel guru. Indeed I see being pretty average an advantage - because the more the laborious the process the more I take in, in terms of why things happen. In other words, if all I did was go click click, it wouldn't stick.
5. "Conditional formatting" is the key to making this work in terms of illustrating what is going on in the matrix and transferring that stuff to a fretboard.

What I have done so far is very much "work in progress" and there are several errors, but if anyone wants to take a peek, pls let me know.

I'd also welcome the opportunity of hearing what others may have done in this regard.

Cheers

Ron Wiber


Responses  [ Pages: 1 · 2 ]
Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/16/2001 10:14 PM

Inactive Member wrote:

Sometimes at work, when I have some time left on my lunch, I will take a sheet of paper and make it into a grid. It is meant to represent the fretboard, 6 blocks wide and 24 blocks long. I number the frets on the side...3, 5, 7, 9, 12, 15, 17, 19, and 24. Then I proceed to write the notes in. I try not to do it in any order, so I have to think about where I am on the fretboard and what note belongs there. It helps me a lot to remember and visualise, not so much the notes themselves, but how they relate to each other within the fretboard.

When I have all the notes in there, I shade in different block as I try to pick out different scales or modes. Sometimes I just shade in a major scale and think of different chord or scale formulas and try to contruct them on my paper fretboard.

Anyway, that's what I do, and I definately think it helps me to understand the fretboad better. I think that's a great idea to use Excel though. Maybe I'll try it. :-)

-mike

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/17/2001 4:43 AM

Sangram Rakshit (1274) wrote:

Whatta idea! The possibilities are astounding! Could you consider sending it to me?

thanks in advance...

Sangram

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/17/2001 6:17 AM

Antonio Rosa (6847) wrote:

Hi Ron,
I've seen some Pedro Lima work with Excel, on intervals and chords. May be you want contact him.
Antonio



Respond to this

Does anyone know how to post an excel file?

7/17/2001 11:30 PM

Ron Wiber (3568) wrote:

Thanks Antonio. I'll follow that up (Pedro Lima).

Meanwhile I'll try to learn how to post the file somewhere.

If anyone knows how to post an excel file, - Your assistance would be appreciated.

Ron Wiber




Respond to this

Re: Does anyone know how to post an excel file?

7/18/2001 7:10 AM

Antonio Rosa (6847) wrote:

I believe you can send it as an attachment in most email systems, but they have limits for size
so it's better if you zip it.
Other alternative is upload it to some sites that
offer disk space, and then share it with others (I've used some in the past, you have to specify the email address).Then people can go there and download the file.
Currently I don't now about sites offering space, normally they do it in a temporary way, after that they want to charge for the service (i used i-drive and x-drive).
Antonio



Respond to this

Re: Does anyone know how to post an excel file?

7/18/2001 8:18 AM

Ron Wiber (3568) wrote:

Thanks Antonio. Posting it my MSN Communities site has not worked for those who have tried to access it. I'll email to those who are interested and who have an external email address on their Homepages - in the next day or so.

RW

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/17/2001 7:24 AM

Chester Horton (10480) wrote:

Hi Ron
I'm always interested in learning toools, I'd like to see what it looks like
Chet

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/17/2001 7:42 AM

William Petersen (3362) wrote:

Ron,

I'm an Excel Moron, but I'd love to see what it looks like.

Bill

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/17/2001 1:48 PM

Robert Silvia (1575) wrote:

Great Minds think alike.

I've been doing that for a while... especially when I was at work.

Another thing I do is create a picture in Adobe Photo shop, which takes more time but the results are a little bit more eye pleasing.

Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/18/2001 3:09 AM

Steve Scott (617) wrote:

Ron,
I've never used excel but I've used matrices. I don't know if you were using this but this one will show you all the chords in the any major key, if you know your chord formulas.

1...2...3...4...5...6...7......key of C Major
7...b2..b3..3...b5..b6..b7.....C#
b7..1.. 2...b3..4...5...6 .....D
6...7...b2..2...3...b5..b6.....D#
b6..b7..1...b2..b3..4...5 .....E
5...6...7...1...2...3...b5 ....F
b5..b6..b7..7...b2..b3..4
4...5...6...b7..1...2...3
3...b5..b6..6...7...b2..b3
b3..4...5...b6..b7..1...2
2...3...b5..5...6...7...b2
b2..b3..4...b5..b6..b7..1
1...2...3...4...5...6...7

For example, its easy to see that the key of C Major contains: Dm(1, b3, 5),Dm7 (1,b3,5,b7),
Em7b9(1,b2,b3,5,b7), Fb5(1,3,b5) ect...You can turn it around and see (for example) that the only note in the key of C that does not belong to the key of F Major is the 7th(note B). Can't format a matrix with this editor but I hope somebody finds this useful.

Steve





Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/18/2001 8:23 AM

Ron Wiber (3568) wrote:

Thanks Steve

I'll send you a copy of my crude work in progress effort to your external email address in the next day or so. With your knowledge of music and software savvy, I am sure you will have some ideas about how to optimise what is only the germ of an idea at this stage - That is - If it is not just a load of rubbish.

RW



Respond to this

Re: USING EXCEL TO EMBED STUFF IN YOUR BRAIN

7/18/2001 7:28 PM

Steve Scott (617) wrote:

Thanks RW,
What you are doing is interesting and I'd like to hear more about it.

Steve
www.chordware.com

More Responses  [ Pages: 1 · 2 ]