 Guitar and Excel spreadsheet creation mapping the path to fretboard enlightenment part number 14 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 we started in a prior presentation So if you're using a blank worksheet, you may want to begin back there If you do have access to this workbook, there's multiple tabs on down below including the example tab Which is the finished product the end work the answer key if you will we have many starting point tabs Which will tie into the video presentations as we go through this long practice problem the blank tab Representing the blank worksheet that we started with and are continuing on at this time quick recap of what we have Done thus far we started our project by listing out the musical alphabet in a column a a sharp the sharps and flats being represented by the lower cases here b c C sharp d d sharp e f f sharp g g sharp a then it repeats We numbered each of them which I'm going to call absolute numbers not relative numbers because they're never going to change This is another name for the notes a can be called one or absolute number one And then we combine them together so we can see the number and the letter We've then created our fretboard with just the numbers which looks nice and clean if you were able to see The notes as numbers that can look quite nice However, most people are going to want to see the letters So we have this fretboard showing the letters and the numbers Then we built our musical scales here. We then started with the The major scale and we did that first with C But we can change this keynote to whatever we want We built it with the formula for the major scale whole step whole step half step whole step whole step whole step half step or two note difference two note difference one note two two two one and then we saw that in terms of our running balanced formula and Created the notes in the scale We then showed that over here so we can see the notes in the scale We can see the number. These are relative numbers now to the position in the scale one through seven And then we have also the numbering in the Greek alphabet with the upper case showing that it's going to build a A major chord the lower case a minor chord We built it in terms of a circle as well. We then went through to the right and looked at the relative the relative modes including the minor or Aeolian the Dorian the Phrygian the Lydian the Mixolydian and the Locrian all of those are using the same notes So we can we can use the same fretboard and hide the cells such as this and We can use that same fretboard and hide this over here and see that fretboard side by side With any of those so I can hide from if I want to see the next one over and kind of switch over here I can right-click and hide and see now the Dorian next to it and use the same notes Basically because they're all using the same notes I'm just going to be focused now around the D as opposed to the starting point was a C Because these are all relative modes to the C So then I'm going to unhide these right-click and unhide We also said you might want to then think about the modes and pivot around The root note so I might want to look at all the modes With that start with a C. So here's the C major and then here is the C minor it's not going to be all the same notes, but it's pivoting around that C and We can have all of the a whole nother fretboard over here So that we can have the two fretboards up on top of each other So we did that for all of the all of the modes That's stint that start with a C So here's a friggin that starts with a C the Lydian that starts with a C and then the mix of Lydian And then the Locian so now we're just going to do that repeating the process for the rest of them So what I'm going to do is I'm going to I'm going to say now We're starting at this minor and I want to go I want to look at all of the relative Modes to the right that are going to have this the same minor in this case That are going to be related to the C here the C minor not the C major this time Let's start by copying this format and then copying it to the right So I'm going to do this with just the keyboard this time I'm holding down shift and going to the right back to the left a bit still holding down shift and down picking up all that Information and then I'm going to say control C on the keyboard and I'm going to paste it To each one of these items to the right and then I'm going to go back in and fill in the information So I'm going to say control V I'm going to do this all the way until we get back to the major So I'm going to say control V or all the way across here For everything that we have up top so it lines up to each one of them up top so I'm going to say control V and control V and Control V and So there we have it okay now Let's go back to the first one and let's add the names I'm just going to add the names to start with now over here We're starting with the minor instead of starting with with the major So I'm just going to it's going to be the same pattern going to the right So I'm just going to copy the names from up top so the one after the the minor It happens to be populated properly right now, but let's just do it again This is going to be equal to if I go up top We had the minor and then after the minor is the Dorian Enter and then the next one we're going to work on is Going to be after the Dorian it looks like it's populated properly, but let's just double-check it Dorian and then we had after the Dorian the Phrygian Enter and then this one is after the Phrygian Scrolling up we're going to say there's the Phrygian after the Phrygian is the Lydian and then next one equals after the Lydian We have the Mixo Lydian Enter and then after the Mixo Lydian. We've got the Locian Locian that's the crazy one like the character Loki It's weird and then the last one I'm going to go back This is where the major is we go all the way around the horn all the way around the loop and back to the start of the loop so the last one is going to be The the major so I'm going to go all the way back to the left To pick it up Okay Now oftentimes it might be easiest for us first to populate the information for the major Because that's usually what we think of as home base Even though it's on the far right when we're looking at it now So we might want to say okay first I'm going to look here maybe I'll even make this red so I can kind of recognize it when I when I'm trying to Maneuver around this worksheet So in order to do that then what I'd like to do is copy the formula over here And then I need to pick up that first note So maybe this first note is the first thing to look at so if I go back to the right and say okay How what is that first note because if I was to look over here? I know in the minor We're looking at a C minor. So the question is well, what is the relative major? Then to the C minor well if I scroll up top I can say well last time if I looked at the minor this way Here's the minor That we had up top that was relative to the C major. So now this is the minor here's the minor There's the C so that relative position should be the same down here. So if I look at what I'm Doing down here We're gonna say Here's here's the minor that we're on which is a C relative position should be that D Right there D sharp. So I'm gonna pick that up I'm gonna try to tie everything together to this D sharp so I'm gonna go all the way back to the right and Say let's pick that number up with a formula so everything ties together. So this first note That's the key. I want to pick that all the way back up from The first one in our list, which is the minor and I'm gonna pick up that Seven right there, which is a D sharp. All right, we have that and then I Could just I could just copy this formula here and paste that into the formula and it should pick up the relative Formula but just the formula only so there's our formula pattern for the minor that I should be able to copy down and Then it should populate the pattern properly and then I'm also gonna copy this and paste paste it here for The formula as well Maybe I can just paste Well, let's do the formula. Yeah, there we have it and then I can copy this down and I believe that will give us the proper Items here too. So there's our major So now let's go all the way to the left and we'll double check this later We'll kind of play with it. So if so if there's any kinks in it We'll try to work those out as we work with the worksheet, but let's go back to the left now and say, okay Let's say, okay, okay Okay, so then we're gonna we've got the minor and then after the minor is The Dorian so to change the Dorian I need that starting note again to change But now it's it's easier for me to see because I can see it related to the major So I'm gonna tie this to the major which is all the way to the right now and go to the major on the right and say there's The major the Dorian is one to the right. So it's gonna be that nine. So I'm gonna pick up this nine and Enter and then once I have that I'm gonna pick up this formula Which is on the Dorian and copy that and paste just the formula over here and Then double-click copying that down and it should have everything. This is populating. I think properly I think I can copy this and paste it here. Oh, hold on not that way paste it Formula and I think that was already populating properly. So I think that is right. Let's try the the next one Which is the Phrygian? So I need to change the root note here. This is gonna be equal to I'm gonna go to the right to the majors and The Phrygian is The one absolute that was the Dorian now we're on the Phrygian, which is that 11? Let's pick it up over here. We can pick it up either way. I think but let's pick it up over here. There's the 11 So we have that and then our formula is populating. I think the formula is populating Well, maybe it's not so let's let's copy this and Paste it here paste it just the formulas copy it down paste it here copy this Paste it here just the formulas and copy it down. All right. I think that works. Let's try the next one Which is gonna be the Lydian So the Lydian I need to change the root note. So I'm gonna say equals. I'm gonna go back to the majors and We did so last time we did this one. So we should be on this one the 12 so I think that's right 12 and Then the formula is gonna be here. I'll copy this Formula and paste it here just the formula I'll copy it again and paste it here just to make sure that's well not like that controls the paste it formula Okay, and then I'm gonna go to the next one mix Lydian so the last one I had was We started at the 12 so let's just keep that in mind to make sure I pick up the right note equals and We'll go to the right and Say, okay. We had the 12 last time. So now we're on the two So there's the two right there. Let's do right there. Okay, and then I'm gonna copy this here paste it to the formulas just like that and Then copy it again and paste it down here just to make sure that's Proper and then we started at the two this time now. We're on the Locan. So we'll put our cursor here equals scroll into the right and Last time we were on the two. We're not picking up the six because that's the minor We already did that we'll skip that and go to this one We're not picking up this four, which is the six of the relative position We'll pick up that six, which is a D, which is the seven relative position All right, so there's that and then then we're gonna say, okay, let's copy this control C paste it formulas copy that down and then copy this and Paste it like that. Oh not like that Control Z paste it like that and copy it down. And so there we have it. So there we have it Easy, let's try it again. So on the next one We're gonna say we had the minor if I go down this way. I Had the minor and then after the minor we've got the Dorian. So let's do the same thing I'm gonna copy all of this and Paced it across so I'm gonna copy all of this and then I'm gonna paste it across Control V and then paste it here control V and Then paste it here control V and then paste it here control V and then paste it here Control V and then paste it here control V. And that's the end of it and then I'll go back and name them so I'm going to go back to the start where we started with the Dorian so after the Dorian I think everything is right until we go around the horn so I think the Phrygian is actually correct and then the Lydian is correct and then the Mixolydian is correct I believe I hope Locian is correct and then we go around the horn so that's when this is going to be zero and this should be the major so this equals up to the top back to the left this is going to be the major so major do this one boom let's make it red to try to say tell ourselves that's home base for this one and then we go to the right and then the one after the major would normally be the minor and I think it well because we put it out of order so it's going to be the minor so let's pick that one up so we have the major and then the minors next in our ordering and I think that's it all right let's go back to the left then and start to populate this thing so we'll say okay so now we started on the Dorian so now I got to think okay well what is what is the relative like it might be we know that the Dorian here is gonna be the C I might want to look at the relative major and think about that first so the question then is what's the relative major of wait I already did the yeah it was the C Dorian what's the relative major of the C Dorian well I can go up top and look at my Dorian up here I could say here's my Dorian related to the C major so there's so so so where's my C relative to this the C is way over here it's the seven so now the same relative positions should be over here so I'm going to say all right that means that if I go down to this one I'm on the minor and then here's the Dorian then if this was a C Dorian then this should be the major so I'm going to build the major first which is going to be a an A sharp or B flat a two note so I'm going to say all right two note let's go to the majors and build that one Primero first we're going to say this one here the first note's going to be a two so I'm going to say this equals back to the to the Dorian so we can kind of build this together build everything tying it together and we want to pick up then this two so we want that two and enter that's the starting note that I'm going to pick up my formula and I can do that by just copying this and paste it right there but the formulas only copy it down whole whole half whole whole half that looks good copy it again and paste the formulas there well not like that paste the formula and then copy that down so now we've got the major so now I can work on on all of the related modes using the major as my home base so I'm going to say all right then we have the Dorian so after the Dorian we've got the Phrygian so what's going to be the first note okay I can say what's the relative position for the Phrygian to the major the Phrygian actually maybe it would be easier to go in order so what I'll do is I'll kind of try to go and order this one let's go to the right and I say here's the major I know that the minor is the six right so I can say let's do the minor first so I'm going to say here's the major the minor is going to be the six of it so this is going to be equal to on the minor side it's going to be equal to the six of the major so that will be the 11 which is a g so we have that and then I can copy the minor pattern copying this paste it formulas paste that down copy this paste it on the formulas and copy it that down and then I know that the Dorian if I look at that compared to my major is going to be here so that would be the the c related to this and then I'm and then the next one's going to be a d okay so let's do that so now I'm going to go back on over here and say okay this is going to be the Dorian and then the Phrygian so it's the one after the Dorian so this is going to be equal to moving to the major and so here we had the major so the one after the Dorian is Phrygian so it's going to be here relative to the major which is that six boom and then I think this formula is actually populating properly so I think we're good on everything here so let's just hope we are and continue so the one after the Phrygian which was that six is the Lydian so this first note I think that's all we need to change on the Lydian so I'm going to say that according to this one would be the one after that six would be that seven right there or we can pick it up right here okay and I think everything else changes properly let's do it to this one this is the Mixolydian so this is the one after what did I just put in there a seven so the Mixolydian changing this note compared to the major scale so here's the major and we just did the seven so this is going to be the nine boom and everything else populates and then the next one is the Locian which is the weird one so this is going to be equal to going to the right this would be the one we're skipping this one because that's the minor which we already did and so we're going to this this one so that's going to be this here and okay that makes sense I think everything else is populating properly all right let's see if we can continue on again and try this again hopefully we've have everything we'll work out the Kings later but you get kind of the thought process here and let's see so now we had Dorian so now after Dorian we've got Phrygian so I'll do the same thing I'll just copy this whole thing and say Phrygian just copy that I'm going to paste it here and then go to the right paste it here go to the right paste it here go to the right paste it here go to the right paste it here go to the right paste it here and that's the last one. Alright, so if I look at my Phrygian then then I'm going to try to list these out again. So I'm starting at the Phrygian. So we'll start at the Phrygian here. And then after Phrygian, we've got Lydian. I think that's populating properly. And then we've got Mixolydian. And then we've got Locian. I think that's right. And then it starts over, which is where we run into the problem. So now I'm going to say this is going to be equal to after Locian, it starts over at the major. So this will be our major now. So I'm going to say this equals to the top row that we worked on, which is the major. I'll make it red to indicate that's our home base. And then this is after the major is the minor. So this equals and I should be able to just copy. Now that I think about it the relative position from the major to the minor here, and just paste it, boom. And then after that is the Dorian, I should be able to paste it here, Dorian, and then that's it. So now I want to think about what's going to be the relative major here of the starting point. So I can change that note first and use this as my home base. So I'm going to go to the first one and say, All right, how am I going to do that? This one, I'm on Phrygian. So what's the relative major if I think about that as the one note in the key of Phrygian? Well, I can do it up top. I can say, Well, when I was in the key of C, if I looked at Phrygian over here, Dorian, Phrygian, and I know the one that the major was a C. Now the major is right here. So now I'm going to say, Okay, the same relative position should hold. So I'm going to go, Okay, that means that if I'm looking at what I've got here on the Phrygian, then there's the Lydian. I'm on Phrygian. Then it should be here it is I got lost there. Here it is. It should be this one. So if I'm on Phrygian, there's the C. So it should be a G sharp or an A flat. So it's a 12 note 12. So I'm going to go down. I'm going to go to my home base C and say there's C. And this first note is going to be the 12. So I'm going to say, let's bring this up from the 12 tying everything together over here. There's my 12. Maybe I should pick it up from up top like this. There's the 12. I'm going to copy the formula now. So the formula I should be able to copy by copying this control C and pasting it here control formula only copy it down copy that again paste it here formula only copying it down to the right of that is the minor, which is the six of the major. So this note right here should be the six of the major, which is which is going to be like that nine or I can pick it up over here, which is that nine right there. And then I can pick up the minor pattern, copying this and paste it down formulas here, copy it down copy it from here, paste it down formulas here. And then after the minor, we get to the Dorian. So the Dorian is going to be equal to going back to the home base of the major. It's going to be equal to here's the major. The Dorian is the one right to the to the right. So it's going to be that number two. So this number two right there. And so that's our starting point. I'm going to copy then this and paste just the formula and copy that down. So there we have that. And then I'll copy this and paste just the formula here and copy that down. Alright, and then there's nothing to the right of that. So I'm going to go all the way to the left again, and start from this side. And so we had the Phrygian. That's the starting point, right? And then after Phrygian, we had Lydian. So I think everything is populating properly on the Lydian as long as we change this starting note. So the Lydian. Where's the Lydian? Where's the Lydian? I just did the Dorian. So this one is actually after the Dorian. So if I go back on over here, we're going to say going back to my major. Here's we just did the Dorian. So this is the Lydian, which I believe is that four, I hope, which is the four. And then everything else, I think populates properly. And then after the Lydian, which was the four, the next position, Mixolydian, I just need to change this one note, tying it into the major. So we had the Phrygian was here. So now we have this five. So this should be this one. And so that's the five for the Mixolydian. And then I'm going to go to the right. And then we got the Locian. So I need to change that one. That's the one at the end. That's the last one. So meaning we're not going to put the six in there. We're going to go to the Locian, which is the 11. I think I messed up here. So there's the 11. Okay, something happened though. So this is the major. This is the minor. And then we had the Dorian. Right. And then we had we had the Dorian. And then the next one was a four, which was the Phrygian is the four. Okay, I messed up. And then this one should be the one after the four is the Lydian. So this is going to be after the four. Let's go back on over the one after the four. This should be the five. Let's do it this way. And this one should be after the five for the Mixolydian, the one after the five. And that's going to be the seven. And then you get the minor and then the 11. Alright, hopefully I fix that. Alright, so we'll play with it later. But that's the general process will continue on with it, hopefully wrapping it up next time, just for the for the rest of these. But the idea now is, of course, now you can, you can, I can move multiple different ways, right? I can say, Okay, here's my, here's my major tied to the major hide these cells. And I can see this compared to this, I can move to the right and see any of these next to my fretboard. And I can move down now and see see the minor with it with the same C and then see all the ones to the right, which are relative to that note, which will all have the same fretboard or the same notes in the fretboard. So that's the idea. So let's unhide this one again, right click and unhide and we'll continue playing with this our modes next time.