 Guitar and Excel, interval and modes complement and parallel worksheet part number 11. Yeah, have you ever wondered why some soap is just for your hands? I mean the bottle actually says specifically hand soap, like you're restricted to just one body part. I mean it makes you feel like breaking the rules, washing other parts of your body with the hand soap. At least if you're a rebel like me, and honestly that would fine. No problem at all, however unfortunately the slippery slope then got to me. Because I started thinking, you know if washing my entire body with soap specifically designed for your hands was good, why not try toothpaste? Let me tell you, the extreme minty fresh experience of toothpaste is not designed for every body part, you know? But whatever, you live, you learn, let's just play some guitar. No, I don't know what that had to do with guitar, Phil. I was just thinking out loud, I'm going to get to the guitar thing now. Get off my back, man. Anyways, let's do some guitar and 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 prior presentation. So if you want to build this from a blank worksheet, you may want to begin back there. If you do have access to this workbook though, there's a bunch of tabs on down below including the first two representing the finished work, the final product. We have the numbered tabs which will correspond to the related video presentation so you can work through the practice problem piece by piece. The blue tab is where we're going to continue working now, it's going to be starting on the point that we stopped off at last time. So last time, we put together our two worksheets, the complement modes and the parallel modes. And then I'm going to be adding to the worksheet with the complement mode on the right hand side. And if you want to put this on a standalone worksheet, you can do that but I'm trying to limit the number of tabs that we would have or need as a reference tool. So I'm going to put this on the right hand side and we're going to be pulling from some of this information that we put together in prior presentations. So what we have here is we've started designing out the circle. And notice a lot of times when people, when we look at the scales, we tend to just look at the seven notes out of the twelve notes, which is great because that's the major measuring tool or the primary measuring tool that we typically use. But we lose some depth in thinking of it that way because we're losing the twelve notes in the musical alphabet because the seven notes that we have are given by the whole, whole half, you know, the formula that we used to get seven out of the twelve. So this worksheet, if we work through the worksheet, I think it'll give us a good understanding of this whole of the formulas here. In this case, we're looking at the major scale, which has the whole, whole half, whole, whole half. It'll give us a better idea of the intervals, what they mean, and it'll give us a reference tool to look at all of the major scales, which of course there are twelve, twelve of them because you can apply that same formula to each of the starting points of the twelve notes. So we actually did this two times. We have the green one, which we started up top, which is the C, and then we labeled it as the one, and we said that it was the interval of zero or the first position, which is going to be the perfect first, and then we skipped one whole step to the two, and that's going to be the major second, and then we did another whole step, so we skipped and went to the three, and that's going to be the major third, which is an E, and then we had a half step, so we went to the four, which is the F, and that's the perfect fourth, five notes away, and then we skipped one again because it's a whole step to go over here, and so now we're on the G, which is the perfect fifth, seven notes away, and then we skipped one again and so on and so forth. Then we did the same thing for the red ones. So here's the red one here, which I'm going to say C sharp or D flat, and then I'm going to call it the one on the outer circle of the red and apply the same whole, whole half. So we applied the same whole, whole half formula here, and we note that what's happening is this red circle is going to shift to the right or clockwise, just a tick, right? So you can see these should match, and you can see kind of that pattern. So now we're just going to continue around the circle starting with a D this time. So I'm going to unhide so I can get some more space between BG and CZ and right-click and unhide. I'm going to go to the right and let's see if we can just fill this out a little bit further. So I'm going to say let's format paint this to here, and let's just do some format painting to here, and then I'm going to format paint this here and here. And I missed one, and I got the wrong one, and then missed one. What are you doing for goodness graciousness's sake? Let's go from here to here, and then here to here, and then here. I'm going to format paint there, and I'm going to format paint this to these two, and then format paint this to these two, and then format paint this to here, and format paint here. And then we're going to format paint these two, format paint these two, and then format paint this, format paint that, and then let's format paint these two. And we're going to have to do that basically every time. So maybe we'll just do it one circle at a time. So now let's hide as much as we can. So I'm going to go from here, CX on back, because I want to see these circles. And let's go to this one, right-click, and then hide. And now I'm on the key of D. So I'm going to change my entire worksheet to be in the key of D now. So I'm going to say, all right, this is going to be the key of D, which is a six. So now we're in the key of D. Our worksheets are in the key of D. And so let's put this together then using that. So let's start this from here. This is going to be the first. It's staggered from the last one. It's going to be the perfect first, which I could get there, or I can see it on this circle. And now I'm going to pick up that perfect first right there. And then we're going to go a whole step. So we're going to skip this one and go to this one. I already put a two there, but let me do it again. There's the two. Hold on a sec. There's the two. And then this one's going to be now, it's an E. So there's the E. There's the two. And the interval is the major second. So then we're going to go to another whole step. So we went whole, whole. And so now we're on the F-sharp. And this is going to be the three. And we're going to say that this is going to be equal to here's the three. It's a G, F-sharp. And I can see the interval is a major second. And then we're going to say, OK, so now we went whole, whole half. So now we're going a half right here. And I can see it's still staggered. One tick to the left. So I can pick up that numbering on this side. We're looking at the G now. The G is here. And this circle, the interval is the perfect fourth. The fourth is the place in the scale, the seven-note scale. The five represents the total notes away in all the 12-note scale. And then we're going to say, OK, so then we did that one. And now we went, what did I do? I said here, whole, whole, half. And now we're on the holes again. So I'm going to go here and say this is whole for the five. There's the five. This is going to be equal to the perfect fifth. Seven notes away, whole. And then another whole. So we're going to go up here to the hole. And this is in the wrong spot right there. This should be up here. So I'm going to say this is going to be up here for the whole. And this is going to be equal to the six. And here we're going to say this is equal to the six, which is a B, which is a major six, hold on a sec. It's nine notes away. That's correct. But I think I got these two backwards, because I want to say this one is going to be the six. And then this one's going to equal the B, which is a major six, nine notes away. And then I'm going to go here and say then we had another whole step. Whole step is going to be equal to this one. So that's going to be the seven. And it's going to be equal to the seven, which is the C sharp, and it is a major seven or 11 notes away. And then we're going to go the seven has a half step back home. So now we're back home again. All right. So let's do another one. I'm going to unhide from here to here. Right click and unhide and put another circle around our thing here. I'm going to have to bring it down a bit. So I'm going to take this whole thing and bring it down a little bit. I can do that every time. I want to copy it and paste it now, so I remove the formulas, taking the whole thing, copy and paste it one, two, three. And so then I'm on this one, the blue. So let's make a blue on the outside. Blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, format, paint the blue, and format, paint the blue, format, paint the blue, format, paint the blue. OK, now let's hide it again. I'm going to hide from here to our circles. Right click and hide. The blue is going to be a D sharp. So let's go over here and say I want to change my key to a 7 now, D sharp. And so then I can do the same thing on the blue. So the blue is going to be equal to the 1. So there's the 1. And then it's going to be the perfect first. So it's going to be there's the D sharp up here, perfect first. We're going to say whole step. I put this in the wrong spot. It should be right there. Whole step, skipping that, going to here. We're going to say this is the second. It's staggered from the orange now. And that's going to be an F. There's the F. The interval is a major second. So now we're going to go whole step. So whole step here, this is going to be the 3. This is a G. So here's our G over here. So we can see the G. If I look at my G here and I go to this one, there it is. Now I have these staggered in my workshop. I'm going to pull these to the right and actually stagger them like this. Now let's just keep it the way it is. Let's see what that ends up looking like. So we're going to say that. And then I'm going to say that's the 3. And then we've got then a half step to the 4. So I'm going to go, OK, here's the 4, which is right there staggered. And we're going to say that's a G sharp. So there's the G sharp. Here's the interval, perfect 4. And then we're going to say now we're going to go the whole step to the 5 here. I'm sorry, whole step to the 5, which is up here. And so we're going to say that this is going to be equal to the 5. And then the 5 is an A sharp. So there's the A sharp. It's the perfect fifth, seven notes away. And then a whole step to the 6. So there's going to be the 6. This is equal to that 6. And it's going to be equal to the 6 over here, which is a C, which is a major 7, 11 notes away. And then a whole step to the 7. I missed some formatting of the blue here, formatting of the blue here, and then formatting of the blue over here. So now we're on the 7, which is the diminished with a dot. And this is going to be then, there's the 7. It's going to be the major 7, 11 notes away. All right, let's do it again. I'm going to unhide here, unhide. Hopefully I haven't messed anything up, because I'm going to finalize it now by copying. And in paste, I'm going to copy the whole thing and then paste it just 1, 2, 3. So there we have it. And then I'm going to pull it down one and do the next layer. So the next one is the purple. So I'll make the purple format paint out to here, format paint to there, format paint these two, format paint these two. And then this one, I'm going to format paint it there. And then I'll format paint it here. And then I'll format paint it here. And then I'll format paint it there. And then we'll format paint it here. And then we'll format paint that here. And format paint that there. And then format paint this here. And format paint that there. And format paint that there. Format paint this one. And there's the next circle. OK, let's hide this from CV on back to here. Right click and hide. And then I'm going to say that now we're on the purple, which is an E or 8. So I'm going to change my key to be in 8. So there we have it. So now I'm going to say, all right, the key is in 8. So I'm going to go, OK, so this one now is the first. So it's staggered from the blue. And then this is going to be the E, which is now position 1 or the perfect first, 0 notes away. Then we have this is going to be the 2. And I put these two backwards here. Did I not? I've got these two backwards. So let me fix that. I'm going to take these two, pull this to the right, grab this one, and put it right there. These two are backwards. I'm going to take these two, pull this to the right, grab this one, and put it right there. OK, so this is going to be then the 2 is going to be over here, whole step to the 2. And the 2 is going to be a major second. And then so now we've got a whole step, another whole step. So we're going to go whole step over here. And so again, I think I have this one backwards. Let's put this here, this here, and this here. So we want a whole step. This is going to be 3. And then the 3 up here ties into that major third. And then we've got a half step. So a half step here, which is going to be now, yeah, the 4. And then this is going to be the 4, which is here. So we'll pull in, that's the perfect fourth. And then we've got the whole step. It's going from the 4 to the 5, whole step is the 5. And this is going to be equal to the 5, which is a perfect fifth, 7 notes away. And then going from the 5 to the 6 is a whole step. So we're going to be over here. Here's the 6. And this is going to be the 6 is here. So that's going to be a major 6. And then we're going to go from the 6 to the 7, whole step. Here's the 7. And then this is going to be the 7, which once again is a major 7, 11 notes away. And then a half step back home. All right, let's copy the whole thing and then paste it down. So we could do the formatting copy. And I'm going to paste it 1, 2, 3. Then let's unhide from here to here, right click, unhide, go into the right. I'm going to pull this full thing down. I'm going to pull that down. And so now we're on the yellow. So let's format paint the yellow across. Format paint, format paint. We're going to format paint, format paint here, format paint there, format paint here, format paint. Format paint, format paint there, format paint there, format paint these two, format paint this one, format paint this one, format paint these two, format paint these two, format paint here, and format paint there, OK? So then I'm going to hide from CU over to BH, right click, hide. And I'm going to change to an F now. So I'm going to go over here and say my key is now in an F, which is a 9. So there we have our 9. Now note, you don't really need this circle to populate this, right, because we can see it's all staggered. So I could just say this is going to be the one now. And this is going to be the perfect first zero notes away. Then we go a whole step. And I can see it's staggered to the 2. So here's the 2. And that's going to be a major second. And then we go a whole step. So we can see a whole step is going to be here. I'm going to say this is to the 3. And this is going to be a, well, maybe I should have put, I've got these two. This should be the 3 down here. And this is going to be a major third. And then we're going from the 3 to the 4, which is a half step. So I'm going to say half step is here. I've got these two backwards again. When I go around the circle, I get them backwards. Sorry about that. My fault. I have a problem. OK. So then we're going to go here and say that we did 3 to the 4. It's going to be here. So we went to the 4 right there. So 3 to the 4. I think I don't know exactly what I was doing there. I think I got, but there it is. And then 4 to the 5 is a whole step. So we're going to go that over here and tab. And that's going to be the perfect fifth, seven notes away, and 5 to the 6 is a whole step. So we'll be down here. And there's the 6. And that's going to be a major 6, nine notes away. And then a whole step to the 7, which is going to be here. And that's going to be a major 7 away. So let's try to continue the rest of this without having to adjust the key. So I'm going to unhide these. Right-click, Unhide. And we'll see if we can just do the rest of these internally. That'll be a little faster, maybe. So let's take this whole thing, pull it down a few cells now. All right, so let's make this green. Let's copy this green around. Green, green, format paint to the green. Format paint the green. Format paint the green. Format paint the green. Format paint the green. And again. And so there we have fancy green. Green. Oh, no. Now I've format painted two of them. Let's try to avoid that. That's exactly what I was trying to avoid. And then it happened for crying out loud. OK, green, green, green. And then let's just keep going. If I go to the red, here's the red. Here's the red. Here's the red. Red, and red, and then red, red, red, and continue in here. This one's in the wrong spot. What is wrong with you? I don't know. I don't make me get the list out. Don't make me get the list out of the things that are wrong. I've been working on it for decades. OK, here we go. And then we'll put this one down here. And then now we've got the blue. We'll format paint the blue around on the blue. Ultra vase. Another time. Another time of good times. We're going around another time of good times. OK, so then this is going to be blue, blue, blue, oh, oh, k-passo, oh, and then blue, and then blue, and blue. And then we're on the purple. Purple, here, here, and then here, here, here, oh, no, no, undo. Purple is here. And then here, and here. And then we'll put some purple out here. And here, and here, and here, and here, and there, and there. And brown, brown. We're going to say the brown is out here. So put some brown around, brown around. So we've got the brown, brown, brown, and then brown, brown, and then brown, brown, brown, brown, brown, and brown brown finally brown and one more time on the light orange format painting the light orange light orange and so paint this around it's light orange it doesn't have too many calories in my orange juice because it's light orange and so we'll just copy this one around around around and then around around and here and here and here and there okay alright so now we can just go around the horn on this thing so we left off on the green so if I make the green the one then it's just gonna see it's just gonna say okay this is the one let's do this fast we're gonna say that's the one that's gonna be the perfect first zero notes away whole step skipping this skipping this one going to this one this is going to be the two this is going to be the major second two notes away but that's in the wrong spot major second two notes away and then we're gonna go from the two to the three which is a whole step so there's the three staggered and the three is going to be I don't know why I don't have the three here alright something funny happened here this should be the three should be major third and the four on the yellow should be the perfect fifth so the three here uh... so the three here should be the major third there we have it so three of the four is a half step so now we're gonna say this is the four and it's going to be a perfect fourth and then we're gonna say four uh... to the five is a whole step so we skip this one whole step over here there's the five and that's going to be the perfect fifth the five to the six is a whole step here's the six it's going to be the major nine major six nine notes away and then six to seven is going to be a whole step skipping that one whole step for here and that's going to be the major seven eleven notes and now we went back to the one half step back to the one let's do it again if we make this one the one that's going to be the one at a g it's going to be the perfect first we go to the whole step so we say a whole step going to the a is going to be i've got it backwards again the a is the two and it's going to be the major second so going from the two to the three is a whole step so we'll be up here with the three whole step and it's going to be the major third four steps away three to the four is a half step so we'll put that here half step and it's going to be a perfect fourth four to the five is a whole steps we'll skip this one and go whole step here boom and that's going to be a perfect fifth and then five to the six is a whole step so we're gonna go down here to the six and said did it that's going to be the six which is a major six or nine notes away six to the seven is a whole step so there's the seven it's a major seven and seven back to the eight or one is a half step and then if we make this one now the one we're gonna say and i got these two backwards again this see if i can get everything going the right way and so now we're gonna make this one the one so this is the g sharp it's going to be the one which means it's a perfect first and then we go whole step to the two so there's that's the one whole step to the two which i'll put here and that's going to be the major second two notes away going from the two to the three is a whole step so we skip one whole step to the three there's the three that's going to be the major third and then three to the four as a whole is a half step so we go half step to the four major third four notes away four to the five is a whole step so we're gonna say okay here's the five right there it's going to be a perfect fifth seven notes away five to the six is a whole step and i'm missing the blue ring here so i'm just gonna well i'm gonna pull these down and add the blue that i have forgotten the forgotten blue without the blue stripe there's chaos you need the blue stripe in there to keep order for crying out loud what are you trying to get anarchy okay there's the blue there's the blue stripe okay so then i left off on the five five to six is a whole step so this is going to be six and that's going to be the major six nine notes away six to seven is a whole step there's the seven there's the major seven seven eight is a half step so we're back home here let's do it a couple more times here this is going to be the one now which is now that a it's the one uh... put in the wrong spot though it's the one it's gonna be a perfect first and then we're skipping whole step to the two so here's the two appear uh... no wait a second that i'd skipped the i didn't do it with them on the wrong one here what is happening there's the blue i'm on the purple so there's the blue and there's the purple i'm missing a purple here that's what's driving me crazy i'm missing a purple that's how it got messed up let's put a purple in there okay so now we're gonna say this one on the a is now the one which we're going to call perfect first and then we go a whole step to here which is now the two and that's going to be the major second and then we're gonna go uh... student three is a whole step some out here that's going to be the three uh... this is going to be the three and i'm gonna call that a major third four notes away three of the four is a half step so we're gonna say there's the four it's a major third four to five is a whole step so there's the five dude that's going to be a perfect fifth five to six is a whole step and that's going to be a major six nine notes away six to seven is a whole step and that's going to be then the major seven eleven notes away and then half step back home student two more times and so now we're on the brown which is a a sharp b flat so we're gonna say make this the one perfect first and then we go from their whole step to here the c this is going to be this s two which is a major second and then we go whole step from the two to the three skipping that one to the three and this is going to be a major third four notes away three to the four is a half step so there's the four it's a major four and then four to the five uh... is a whole step so we're gonna go over to the five whole step away and this is going to be the perfect fifth seven notes away five to the six is a whole step so there's the six that's going to be a major six nine notes away six to seven uh... six to seven is a whole step so s and so that's right so six to seven is here boom boom and then seven to eight or back to one is the octave with a half step let's do it one more time so now we're gonna say that the b is the one if we start on a b we're gonna make it the one that means it's a perfect first zero notes away and then we're gonna go whole step to the two so the two is over here say that's the two and it's going to be a major second whole step from the two to the three there's going to be the three it's going to be the major fourth our major third four notes away going from the four to the five hold on a second i went uh... from whole step to the two and then a whole step to the three and then there's a half step to the four so here's the four and that's going to be a major third four notes away from four to five is a whole step so here's five that's gonna be a perfect fifth seven notes away from five to six is a whole step five to six that's going to be a major six nine notes away six to seven is a half step so here's uh... six to seven i'm sorry the whole six to seven is a whole step right so what am i doing here i'm getting a little tired at the end i'm getting close to the end it's it's getting okay so there's that one and then half step back home so hopefully i got that correct and then so let's copy the whole thing and i'm just gonna paste it one two three although i don't think i need to but i'm just gonna do that one more time to make sure it's not referencing anything else so so i'm gonna copy and paste it one two three so it's kind of a standalone static worksheet let's put some borders around the whole thing put some borders around it boom and so what so if i missed any if i missed anything up all will i'll keep on possibly look at it later keep on take a look at it but you get the idea of if you go through that i think that actually helps a lot to kind of get the to get the pattern down right click i'm gonna insert and i'm gonna put a header on it shift cells down i'm gonna put a header on it that's going to be called this i'll just call it that major i only in scale with twelve notes there's the intervals i'm gonna format this across right click format uh... format cells alignment and i'm gonna center it across and then i'm gonna make it home tab font group black and white make it a little bit larger on the font size so i'm gonna say the font sizes make it go up a bit and so there we have it and so that'll give us basically all of the majors now again we could do the same thing all of the other related modes and so we might take a look at that because i think it's just a good exercise to uh... to just go through and you'll see the different intervals and just really drill home this idea of the whole whole half or the other intervals if we start on a different location for the different modes