 Guitar and Excel interval and modes complement and parallel worksheet part number 10 Get ready because it's time for our guitar skills to Excel Here we are in Excel if you don't have access to this workbook That's okay because we basically built this from a blank worksheet, but started in a prior presentation So if you want to build this from a blank worksheet, you could begin back there But if you do have access to this workbook, there's a bunch of tabs down below including the first two Representing the final worksheet the end of product the numbered sheets tying into the related video Presentation so you can go through the practice problem in a step-by-step fashion The blue tab is where we're going to continue on here We're going to start where we left off in the prior presentation So last time we put together this colorful Diagram which is just taking the major scale putting it in a circle similar to what we had over here and Then we're going to have the related modes in different color schemes around it So if I started on the a we were going to be following the red around and that gives us the position in that scale as well As the relative position in terms of intervals So this is a great tool Because but but it has some limitations at the same time and that we're looking at everything from a Seven-note scale when there's actually 12 notes in the musical alphabet What makes it a little bit difficult to look at these intervals these intervals We have to just we end up just kind of memorizing What these intervals are and not really seeing what they mean in terms of absolute distances when we look at 12 notes So what we'd like to do now is do a similar worksheet and this time will not do all the modes We'll just do one mode at a time But we'll look at all of the notes within a particular mode starting with the major Scale and we'll look at all 12 notes so that we can get a real idea of what these intervals are actually What they actually mean right so I'm going to start this over here somewhere So I'm going to make a bunch of skinnier cells again, so I'm going to put my cursor in Cm I'm going to I'm going to go all the way to the right That's why I have a lot of room and then I'm going to make this a lot thinner So I'll make them about the same width that we had before because that we tested that Let's make it around that width and then I'm just going to start somewhere in the middle And we'll have to adjust this as we build this it's going to be a very large Thing here, so we'll have to say okay. We'll just start it somewhere. Let's start it down here like around here And so I'm just going to start with the C So I'll say this is equal to and I could just pull the same C in From my wheel over here if I want to start that as basically the key Starting point I picked the wrong cell. Let's do that again. It's the cell in the middle pick the one in the middle So there it is so there is our C So now I'm just going to go around the circle here and I need to pick up all 12 notes this time instead of just Instead of just the the seven notes Let's actually see if I can hide some cells over here to do that So I'm going to be pulling not primarily from this worksheet But I'm going to be primarily pulling to start out from From actually the full list starting from this Worksheeter possibly this area. So let's hide everything from this side Let's actually see the intervals to let's hide it from here on Over to like around here right click and hide So now I can see these things somewhat side by side Okay, and then I'm going to then go around my circle. Let's see. I'm going to try to Distance this out properly from the start. So we're going to say down one two and Let's go three over so down two cells one two three over and this is going to be Equal to the next one is going to be a C sharp or D flat and then I'm going to go once again Let's see. I'm trying to one one two three over so down two One two three over and this one's going to be I'm just going to pull my D So I'm just going through the musical alphabet But starting instead of that a all 12 notes this time instead of that a we're starting at the C and Then we're going to go okay, and then let's go down One two three and then this is going to be the D sharp or E flat and Then we're going to go down one two three one two. Let's go down One two three one two and then this is going to be then the E So I'll pick up my E over here We're going to go to the E and then this is going to be down Let's say one two three one two. Okay. I have a pattern here one two three one two and That's going to be equal to the F So we'll pick up the F Okay, and then I'm going to go one two three over one two three and this is going to be equal to the F sharp or G flat and then we're going to go one two and then up one and This is going to be equal to The G so I'm going to say this is equal to the G and Then I'm going to go over one two and then one two three This is going to be equal to The G sharp or a flat and then I'm going to go over one and then one two three up This is going to be equal to the a Right is that yeah, and then we're going to go from the a up one Two three and then this is going to be equal to The a sharp or B flat and then we're going to go up one two one two three And this is going to be equal to the B and that's going to be our circle that takes us back around To the C. Let me just check. Does that look about right? It looks a little wonky, but Let's see if I can fix that a little bit more. Let's actually pull this one down here So it's kind of like even with that one and then this one is down One two one two three so down one two one two three Down one two one two three. Let's pull this one down To like right there and that looks a little bit nicer. Doesn't it? All right, let's keep it at that. Okay, so then I'm going to put I'm going to try to put the intervals here So this is going to be the one so I can say okay. This is going to be The one so if I go back on over here, I can pick the one here. I could pick that from The scale so and I'm just listing it one one two three actually let's put it Well, we'll put it from here. This is going to be the one and Enter and actually these ones. Maybe I should take that from the related circle. So let's unhide over here I'm going to unhide right click and unhide and then I'm going to go to my major Circle over here. I'm looking at these circles. So I'm going to hide from here on over To let's hide all the way over to here for now and then hide and So now I'm going to say okay the one is to see let's pick it up from this one Which will give us an eye right there. So it's a major chord construction and it's an eye and then I'm going to go Okay, so then we skip the next one and we go on over to the D and that's because of our Formula so if I go back on over here just to look at the formula We've got the The four skips two to go to the six skips two to go to the eight So we can see that here because now we're saying all right. We're skipping this one That's the point of this one. We can see the skip We're not going to put anything here and we're going to say the two is going to be this D So there's going to be the two. Let's actually move this whole thing up for now And then I'll move it down later. I'll just move this up to here so I could see it a little better Hold on a second Let's just pull this whole thing up for now. I'm going to put it right There so we can work on it more easily All right, so there's the two and notice because we're working on the key of C All of the nap all of the non-sharps and flats will be what we're looking for Here so if that's going to be the two we're looking for now the three and I'm going to say the three How do I want to shape it? I can put the three? I think we put it up here in the diagonal in my I'm looking at my chart Just to give me an idea of how I'm going to format this the three is going to be an E That's going to be the three So again, we skipped one right here. I put it out as a diagonal this time and then we're going to say Before is going to be the F. So the F. I'll put that underneath this time There's the four we're going to skip the G and we're going to go I'm sorry the the F sharp or G flat and we're going to go to the G Which is going to be equal to the five and then we're going to go to the skipping the G sharp going to the a and the a is going to be equal to Then the six and then we skip the a sharper B flat and then this one is going to be The B Which is going to be the seven I'm going to put that down here because that's similar to how I did it on my Worksheet, so I'm going to say this is going to be the seven So I think that works and then I'm going to move this a down this gets easier once we get the original circle down here I'm going to move that a down a bit I'm going to move this G sharp down one. So it's from the a it's one two three and then one Okay, so let's color code this thing now. So I'm going to make this one's going to be green That's going to be my inner circle. I'm going to make this one green and White and then let's make that so everything around the circle is going to be The green so over here. I'm going to say one step up I'm going to make the full circle even though there's nothing there. So this is the one And I can make that green green Center white and then over here. There's nothing here, but it would be the same formatting. Let's format paint this To there and then I'm going to format paint this Again to the two and then I'm going to format paint this here. We skipped This note and then we're going to format paint it to The threes I'm going to say format paint to the three which is the e and I'm going to pull this one down I want to put this one down so it's diagonal this way and then I'm going to format paint that one to Here on the f and then I'm going to format paint that one here to the f f sharp or G flat format paint that one over here to the g and then I'll format paint that one to the G Sharp which would be I'm going to say here and then I'm going to format paint that one to the a format paint that one This way on the a sharp and format paint this one This one I actually want going up this way. So that's why it looks kind of wonky I want it going up here. Well, hold on a sec Unformat paint I want to format paint This one and then pull this one up to the top. So it goes like that All right. I think I think that makes sense So there's the the c so now you can actually see that if I start on the c and I go to the two It's a whole step because i'm skipping a note right or two It's two notes away to get to the d and then when I go here to the three Uh, it's a whole step because i'm skipping two notes now Let's actually map that out so we can so we can see that So i'm actually going to put that in here. Let's i'm going to i'm going to copy this And i'll put that inside here so we can see it So I put major ionian showing all 12 notes and the formula is whole whole half whole whole half Or you can call it two steps two steps one step two two one Let's make this i'm going to make this uh black So i'm going to say let's make this black. Let's make it white. I'll center it across those cells And i'm going to go to the format center And go to the alignment and i'll center it across There so there we have it Okay, so then and it might be just easiest to put brackets around this whole thing as we build it. So i'll just everything's got Home tab font group borders so we could see it a little bit more defined Okay, so then so there is that now we'd also like to know the interval information So and let's center this one to center that So if this is uh the one if I follow this basically around And I look at if that is the one the one is Zero steps away. It's on itself, which we call a perfect first. So the one representing where it is in the scale In the first position the zero representing how many steps away. It is zero steps away So i'm going to say let's format paint this again To here and then on this one we're going to we're going to say That there's nothing uh here. I'm just trying to think of where I want to actually place that Just to follow the circle around i'm going to format paint this one to here So there's nothing there and then and then we have the d here I'm going to format paint that one to here and now we have the d So the d is we're saying two Uh the second position. So here's the two and that's going to be a Major second right so major second. So we'll say okay. There's that one And then we have this one doesn't have anything Within it. So let me just make sure I got this right. This is one One two notes away one two three notes away And I'll format paint the green underneath it here. So there's that one and then the e Is three away and let's put that Right here and I'm going to put that one here. So the three If it was there that's going to be a major Third so it's a major third the third representing It's the three here of the scale the four representing how many absolute notes It's away from the starting point, which is c which is one two Uh three four and then we've got the f I'll put that On uh so the f I'll put it on this side So I'm going to say i'm just trying once we get the position down. This will be a lot easier So there's going to be the f so there's the four so the four is going to be A perfect four which means the four represents the note in the seven note scale the five the five Represents how many notes away it is using 12 notes, which you can see now is one two three four five notes away Right and then we can go to here and say okay. This one is here. Let's put it on this side So we'll put it over here This is going to be the g. So there's the g. That's the perfect fifth So the fifth is the fifth note in the scale if I look at the seven note scale But the seven represents total out of 12 notes distance from the c in all 12 notes, right? So and then we're going to say that that the next one I'm just trying to format where I want to format it. So I think I'm going to Format paint it this way And then the a Is going to be here. So I will format paint that a To here and then I'm going to say the a Is the six which is a minor A major six away. So six is the relative position here The nine represents the two that out of the 12 notes. Here's one two three four five six seven eight nine what will happen there one This is one two three four five six seven eight nine Okay, and then we go up to this one And I'll just format paint this above it. We skip that one And then we go over here to the b And where do I want this? I'm going to format paint this one This way and this is the seven. So there's the seven relative position is that Major seven which is 11 notes away. So again the seven. It's the seventh position Relative to the seven note scale the 11 shows the relative position for the 12 notes that are involved here Okay, so we'll continue that going around And started on well, what if I did that same formula whole whole half whole whole half But I started here From the C sharp right we could do that same thing and color it going around for now Let's just look at the color scheme. So I'm going to go let's make this one Red I'll see if I can find these red these colors because we're gonna we're going to run low on colors here So I'll make this one red And then white and then center. So that's going to be those and then this one will do the orange drop down this will be orange And then white and then we'll center that one And then the e and then the d is going to be the blue So we'll make this one drop down blue white Center and then the e I'm going to put these two Is going to be purple. Let's make that purple. These are arbitrary colors I'm just trying to find some colors that will work here and then this is going to be the yellow So I'm going to go boom Yellow this time. I don't want to make it white text because that'll be too light So I'll just center it there And then this one is going to be we'll make this a lighter green. I chose a funny green here I think it's that green. So I think it's actually Like this green, but then I like well, hold on a second undo I want to choose these two And then I did like this green. I think maybe I did This green And then lightened it. I think I did this green And then I lightened it by going boom color wheel And I went to the custom and then I made it a lot lighter So I was on the lighter side And then so now I'm doing the light ones And so I'll keep the text dark against the lighter background And then I'm going to say this one I think I did a similar thing with the red So I went to like the red, but then I went boom color wheel And custom make it a light red A light red And then center And then this one I'm going to make the hold on Hold on This one is going to be the dark blue I had a dark blue over here that I could have used And white and then center And then this one I'm going to make it A light purple So here's the normal purple And then I'll lighten it with the color wheel To a light purple Light purple And then we'll center it And keep it black because it's black on the lighter color And then this will be the brown So where did I have a brown? I could use that brown I think I was on this brown that is in my example Let's center it make it white And then this one I have a lighter orange color. Where did I get that from? I think I started With this color And then made it lighter. I can just use that color. I haven't used that one yet, but I think I made it lighter By going Up to the lighter colors The lighter register region Keeping it black on the lighter color So so there it is. So then what we're going to do is we'll follow this Now we're not going to be able to make this worksheet basically dynamic Meaning it's not going to change everything when we change our key on the left hand side So when I change this cell, I'm not going to allow it to change everything Because we're going to have to shift things. We're going to have to shift the cells around So what I want to do is after each circle that I have I'm going to copy the whole thing and then paste it so I no longer have formulas in here, but just plain text So hopefully I've done it correctly and then I can I can make this permanent by selecting the whole thing Control c and copy and then I'm going to paste it right down on top again But paste it just one two three So now we've got the same thing with just text so that If I change my key over here to like a to like a g On 11, it's not going to change our worksheet on the right hand side. We're going to make it static All right, so then I'm going to go back on over. Let's make it back to a four And so then we're going to go around around the circle the next one will do We could do the c sharp. So the easy way we could do that is then I can change my key from four to five And my relative circle over here will change And then I can apply my same whole whole half so on from this point So let's see. Let's just do a few of them. We're going to run long on time But let's just see how that might work. I could say then that let's first make all of these the same red Let's copy the format in here Format paint that there Format paint that there and then I'm going to format paint this to these two format paint it here And then we're going to take just one of these and format paint it here format paint this one format paint these And this one I should have another green over here format paint the green And then format paint the red And then format paint the red and then take one red and format paint here And then format paint here and then format paint these two format paint to these two And then format paint to this one format paint to this one format paint to these two Right and then we're going to start on this one. So now this is the one I'm going to represent that over here by saying this is going to be equal to the one And uh, and then I'll I'll I'll change I'll unhardcode these You know, I'm going to use formulas right now and then we'll do that same thing to unhardcode it and then This is going to be the p If that's the one that's going to be now the zero position Or the relative or relative position one right the c-sharp is the one note And then we apply our thing we do a whole step So we're going to skip a note in other words And now this is going to be the two now note. You can see the two Here, but it's also going to follow the pattern. It's the two that's right there, right? It's just going to be following the pattern Around so you're always going to be a shift up on the circle And so I'm going to say this is going to be then the two Which is going to be the uh The m Two major second second note major second So we went a whole step from one to two whole step So we're going to skip this note going over here I can see that because I can see that I'm going to be one Step away from the last green one. So I could pick up that three there or I can pick up that three here This is going to be the f if I pick up my f here. There's the f here's the related distance Which is the uh major second, which is uh the major second two note away Hold on a sec. That's not right. This is going to be the three So this is the three on f and that's going to be the major third or four notes away So now we went from here Uh, we went whole step. We went whole step whole whole now. We have a half step I can see it's a half step because it's one distance Change from the green ones here So now I'm going to say this is going to be a four which I can pick up there Or I can pick up the four up top And I can say okay if this is There it is there. So it's a perfect fourth Which is five notes away five notes away from here, right? So this is the one Uh, two three four. Hold on. This is the one and then I'm going to one two three four five And then that four on this side represents again where it is relative to the scale, right? It's it's relative to the scale. It's the four But it's five notes away when you're saying relative to the whole 12 notes in the scale. Okay So then we did the half now. We got three whole steps. So we're going to skip one go to a whole step again So we're here and I could pick up this five. It's nice and staggered or I can pick it up over here And now I'm going to say okay. There it is. Here's the relative position. That's the perfect fifth So it's the perfect fifth fifth note in the seven note scale But it's seven notes away in comparison to the seven note scale. We have another whole step. So we're going to go a whole step from five To six So I'm going to go up here and say we could pick up that seven this way Or I can pick up the seven over Over uh here Wait, I'm on the six, right? I'm on the six So there's the six and I could pick up uh the six here or there And then I'm going to say here's the six and that's going to be a major six Which is nine notes away and so now we've got then Then the half step Hold on a second No, it's another whole step, right? It's another whole step. So now we're going to go to a whole step up to here And that's going to be the c so the c is going to be The c is going to be now our seven and that's the one with the diminished with the dot And I'm going to say okay if that's if that's the seven now the related position is going to be A major seventh or 11 notes away So hopefully I've got that uh correct and we could just continue to do this for all 12 Notes, right? So now I can do that from the d I can do that from the d sharp or e flat and so on and so forth And we'll see how this thing kind of staggers its way Uh as we go around the circle and then you can look at all the major scales basically from here Not just the seven notes, but seeing what it means to see the whole whole half Thing or the 2 2 1 2 2 2 1 because you can actually see the notes that are skipped Within it and that's kind of that to me. That's a nice visual tool Because again a lot of times we just talk about it as if there's only seven Notes, you know that we're measuring things in and we're just like wait a second There's only seven out of there's actually 12 notes. It's kind of nice to see All of them to see what's actually going on in relation to all 12 notes So hopefully I've got that right because I'm going to solidify it now I'm going to take this and copy it And then paste on top paste it one two three and then next time We'll just continue on we'll go to the d and we'll make a d Circle and continue with it