 Guitar and Excel spreadsheet creation mapping the path to fretboard enlightenment part number 15 Get ready and don't fret remember the boards fretted so you don't have to be 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 using a blank worksheet you may want to begin back there if you do have access to this workbook There's a whole bunch of tabs down below Including the example tab the end result the finished product the answer key if you will a bunch of starting point tabs Which will tie into the beginning points of the video presentations as we work through the long practice problem and then the blank tab Representing the blank worksheet. We started with and will be continuing on at this time Let's give a quick recap of what we have done thus far We started by listing the musical alphabet a and then the sharps and flats being represented by the lowercase a b in Between could be an a sharp b flat bc c sharp d d sharp e F F sharp g g sharp starts over from a we've repeated the process a couple times We numbered them with what I'm going to be calling absolute numbers because they're not going to be changed relative to the scale and Then we combined them together so we can see the absolute number so we can represent note a by saying either a or it's the one note Then we created our fretboard both with the absolute numbers and with a fretboard Having the numbers and the letters related to it. We used our musical alphabet to create a scale Which can be adjustable by simply adjusting this first key note So we're starting with the key of C because that's what most people Recognize easiest to start off with so you got the formula whole whole half whole whole half Repeating the formula again Allows us to create our tool on the right hand side And if we see it down here, we can see the letters which gives us the relative positions to the scale major scale in this case of The key of C one to seven notes We have the Roman numerals which give us an added piece of information because if it's a capital or uppercase that means it's going to be Constructing a major a major chord versus a minor chord We also have some of the distances up top that we'll talk about when we start to analyze our Information we also see it in the terms of a circle very nice to be able to see this way because then you can see the infinite Progression and imagine it kind of going on forever in a circle type of format. We then did the modes Let's look at it down here the minor We did the minor or Aeolian and then the related Dorian and then the related Phrygian and then the related Lydian and then the mix of Lydian and then the Locan So that is useful because that all ties out to the same Kind of fretboard over here because they're all using the same notes We then said that we might want to have on the same worksheet all of the Modes related to the pivot point of C as the key we're working in so we went down And so let's do the minor C minor down below instead of a minor the relative minor D Dorian I mean C Dorian and then C Phrygian and then C Lydian and so on this allows us to do something like this we can basically have we can hide all of these cells for example and Then we could see this side by side we can hide this and see these side by side here So I can see my major and this one over here. I might want to hide Everything underneath so I can see the next one and then I can hide these So now I can say okay if I was playing maybe I want to go from the major To the relative minor over here, which both uses the same Set of notes on the fretboard or I might want to go from the major down To the minor using the C as the pivot point And so and then we can have a different fretboard, which will have different notes on it be given the fact that we're now looking at A different key not just a different mode. It's gonna have actually different notes in it. Okay, that's the idea So I'm gonna unhide this unhide and then we'll unhide this Unhide and then I'm just going to continue down I'm gonna hold control and scroll down zooming out a bit I think this project is easier to do if zoomed out a bit and prior presentations What we've done is take the information that we listed on down below and then put the relative modes to the right We did that with the Dorian. We did that with the Phrygian. We did that with the Lydian or we didn't do it with the Lydian That's where we're at now. So I'm gonna do the same thing I'll do it faster this time because we did the same kind of process last Presentation will try to wrap it up this time. So I'm gonna copy this to get the formatting I'm just gonna paste it all the way across to start out with and then we'll make the changes that need to Be made. I'm just pasting Each section so we can get all the related modes should have the same number of related modes as the one above it and The formatting should be the same in terms of the width of the cells So that looks good. Then I'm gonna go back and just list out the modes We have the Lydian now the next one is Mixolydian which is pop populating properly and then the next one is Gonna be the Lydian which is the last one then it's gonna go around the horn again around the circle That's why it's not populated here. That's gonna be the major scale So I'm gonna pick this one up by saying equal scrolling up to the top and then I'm gonna go all the way to the left To pick up the relative major scale on the left So we'll pick that up. There's the major scale boom Okay, now let's this is gonna be the home base. So I'm gonna make this red I'll make the whole thing red this time so we can really see that that's the home base now I want to get that first key note correct. So how are we gonna do that? Well, we're gonna pull it from the home from our starting position here, which was in the Lydian so we're in Lydian on the C Lydian So if I if I go up top and say well, where is The major in relation to the Lydian to see that it's easy to go up top and Find our Lydian up here when we did it this way I'm gonna say here's the fridge in there's the Lydian and this is when our C Was the major so in this case It looks like it's position five, right so position five is Is out what we're looking for so I'm gonna say okay that means that if I go down to my major So let's go down to the major the one we just put together down here the last one and Find the major Where's the major there it is? So I'm gonna say this first note then is gonna be equal to and And we're gonna go to the first part here the Lydian and It was position five so we're gonna start with that 11 so starting with the 11, which is a G and Then I can just copy down the formula which should be relative to this cell We copied over here so I'm just gonna copy this and paste it down Pacing it the formulas only and that should give us copying it down the whole whole half whole whole half Formula I'm gonna copy that here as well Pacing it formulas only which will give us our Roman numerals So then I'm gonna copy the major and let's go to the right first Because that's the order we're used to and the next one when I paste it should be The minor because that's the next one we worked on so the minor and that looks good Now I'm gonna use the major as my home base So the minor starting note is gonna be the sixth So that's gonna be the eight in this case So I will enter that and then the formulas let's pick up the formulas are gonna be I'm just gonna copy this and paste it right here pasting it formulas hold on a second I'm gonna copy this and paste it formulas and And Hold on. I messed that up because I copy this I'm gonna paste it over here Formula and there's the minor then I'm gonna copy it and paste it here just the formulas and there it is So now we paste that down copying this one more time. I'm gonna paste it over here The formulas only and copy that down All right Then the next one after the minor now now we're gonna go relative to the major will be the Dorian Which will be the one right to the right first one to the right? So I'm gonna go okay Let's paste this I would imagine this would be the Dorian so right click paste just the formulas and The starting note needs to be equal to I'm gonna go back to the major scale And this is gonna be the first one to the right. So it's the two note of The major so I'm gonna say all right enter and then I'm gonna copy this relative cell reference and paste it right here paste the formulas only copy that down Copy that cell reference and paste it right here Just the formulas and copy that down Let's copy the Dorian and then go to the next one which should be the Phrygian. I believe so we're gonna right-click and paste the Phrygian and Then I'm going to say the first note should be the the three note of the major scale So I'm gonna go back on over to the major scale here So three relative position right meaning I'm talking about this number three and then it's the three note Which is the absolute number three of a B for the note name. So I'm gonna say all right. That's enter and Then let's copy this Paste just the formulas here Copy that down. I'm gonna copy this Paste just the formulas here and copy that down and then copy the Phrygian and go to the right Well, the next one is gonna be all the way to the left now. So let's go to the left and That's where our starting point was which should be The Lydian So now we have the Lydian and it's starting on The four does that make sense because if I go back on over to our major scale We did the Dorian, which was which was the two note of the major scale Phrygian and then The Lydian so that makes sense. So now we're gonna go after that So now we're on the six. So I'm gonna go back to the left and Say, okay, so now we did the Lydian Which was the four and now we're on The mix of Lydian so the first note for the mix of Lydian is Gonna be equal to if I go to the right it might be easier I could be doing this by just pulling the next note from the one Prior to it, you know, but I'm gonna go I'm gonna keep on doing it from the major Because I think that's the easiest way for me to see it I'm gonna say this is gonna be then the six a mix of Lydian is the Five the app the relative position five note of the major scale Which in this case is the absolute note of a six or a D, right? So I'm gonna say all right, there's that and let's say copy this And I'll paste it in the formulas only here and Paste that down boom Okay, and then I'm gonna copy Actually, I think that's all we need to do on here We just need to change that first note everything else is populating properly, okay? So then mix of Lydian then we've got the Lydian so that was six and now we're on the Lydian That's the last one So I'm gonna say this equals if I go to my major scale the last one We're not going to the eight because that's the minor. So Lydian is the relative Seven position of the major scale rates, which is a 10 in this case f sharp So I'm gonna say okay there it is. I think everything else is populating all right Let's do it again, and let's copy this whole thing again And I'm gonna say let's cut. Let's just copy this whole thing down Hold on a second We'll copy the format of this actually let's let's do it for let's copy the one down here I'm gonna copy the format for this one and that'll help us with the pattern and So I'll say copy this and then I'll paste it here and we'll paste it all the way across again pasting it and then pasting it and then pasting it and then Paste and paste Okay, let's go back to the start and we're gonna say all right. Let's check it out then so now we got the mix of Lydian as our starting point and so the next the next one is gonna be the Locan that goes down to the to the end We loop back around this should be our major So I'm gonna say this is gonna be equal all the way to the top I'm gonna pick up the major so I'm gonna go to the top and I'll pick it up from the first one here, which is The major so let's pick that up enter Let's make it I'm gonna make it red to show that that's my home base So we're gonna say this is red to stand out as the home base note And then I want to say well, what's gonna be that first note that I need to be looking at well I'm looking at now the The mix of Lydian so let's go to the mix of Lydian and See where the major is in relation to a mix of Lydian up top up top when we were working in the major Scale of the key of C so if I go to the mix of Lydian The four in the key of C. So there's there's the C was in the four note Position so one two three four. So I'm gonna do the same thing down here I'm gonna look for my major down below So we had our major down here and I'm looking where did my major go and We're here and then the first note is Gonna be equal to Relative to our starting point of mix of Lydian It's gonna be equal to the four, which is a nine. Hopefully I'd hopefully I remembered that correctly and So we're gonna say enter. Okay, so hopefully I got that if I have that right I could just copy the relative reference here pasting it Just the formulas copying that down and then I can copy this here paste just the formulas here and Copy that down and then I can copy the major to the right So now we're gonna go and that should populate the minor. That's the next one over and Then the minor the relative position from the minor to the major now is gonna be the sixth position Which is I'm looking at that is the six which is the note of a D Which happens to be a six note so I'm gonna say all right There's that and then I'm gonna copy this and paste the formula here and copy that down And then I'll copy this and paste it into our Our numbering system and then I'll copy the minor the next one should be the Dorian So I'm gonna paste it over here just the formulas and then the starting note This should be the one right to the right or note number two of the major scale So if we look at the major scale note number two, I'm looking at this note is Is here so we're gonna is the Dorian which is 11 or G So I'm gonna say there's the 11 and then I'll copy this here and paste just the formulas Copy it down Copy this bit and paste it right here pasting just the formulas and copy it down and then we'll copy the Dorian and We will go over and paste it should give us the Phrygian and The starting point should be the third note of the major scale So if I go back on over here to the major scale for the Phrygian The fridge the major scale the Phrygian is the third note meaning this three of the major scale So I'm gonna say of the relative major so there it is It's a it's a one and that happens to be an a so I'm going to copy this paste the relative formula here Copy that down and then I'll copy this paste the relative formula here and copy that down So next we have the Lydian, which will be the four note of the relative major. So let's paste that Here paste it formulas and in the four note. It should be equal to the relative major I'm looking for the four note now So now the relative major is here We did the three note last time now. We're on the four note this four note Which happens to be a two which is an a sharp and enter so there we have that and then let's copy this and paste it Formulas only copy it down copy it again paste it here Formulas only copy it down and then the Lydian goes to the mix of Lydian. So the mix of Lydian Starts over. That's where we started so we ended off last time at The two so now we're at the four which should be the C So that makes sense because that was our starting point So if I go back on over to the starting point the mix of Lydian should be correct starting on The C which is a four note a C and then we're gonna say all right the next one Is going to be the Lydian which which is the weird one Which is at the end is the last note So I'm going to say this equals if I go back on over the starting point It equals the last note because we skipped over this one the six note because that's what the relative minor is so this one's the eight and enter and then we can copy the relative formulas here and paste that Formulas only there copy it down. This is already done. I think that's already good. All right, so hopefully we've got that correct Let's do it one more time and wrap this up and again if we have any kind of errors with it We'll test it out when we start practicing with it and hopefully pick them up at that time but you can kind of see the process and Adjust it if you if you see any issues with it, so I'm not gonna Okay, okay, let's continue. I've said that already last one last one wrapping it up wrapping it up like Like Santa Claus on Christmas Eve. Here we go We're just gonna paste it all the way across like we did before the process is low Mismo. It's the same Process we've seen it time and time again. We've got it ingrained in the mind I can do this with one eye closed and the eyelids tied together behind my back I don't know what anyway, so this is the low key in So now we start over because we're starting with the last one now So now we're just gonna start at the beginning which is gonna be equal to I'm gonna scroll all the way to the top and Pick up the major. So I'm gonna go all the way to the top and go to the major Right there and enter. So there we have it and then I'm going to say, okay What's my starting point so we can do this again if I go up to the top and I go to the low key in Where we were we're in related to the C major and say where's the C major related to the low key in We could see it's the it's the number two So, okay, so that means if I go to my low key and then And I go over here and say let's go down down down down down down and there's Our Location and I'm gonna say the starting point is relative. This this is our major Relative to the low key in it's the two of Of the low key in so I'm gonna say okay. That makes sense because the low it's the last one When we when we when we see it in terms of the major to the okay So we're gonna say that so that's an just a note number two which is of absolute position five Which is a C sharp? Okay, and then I can copy this here and paste it there if that's correct Hopefully, I think it is we're kind of and everything else should populate properly This everything starts to mix together after you do this like for a while. So there we have it So there's the major. I'm gonna make this Red to indicate that that's home base. So it stands out. It's standing out Everybody else is behind it. It's standing out for us So then we're gonna go to the right and we're gonna say let's copy this major The next one should be the minor in the progressions We have been doing if we copy if we paste the formula only and the first note of the minor relative to the major is The six note so relative to the major the minor Is gonna be note number six. I'm in the wrong spot. It should be there It is note number six, which is a two a sharp So I'm gonna say all right there it is and then I'll copy this Copy paste the formula Copy it down copy Copy paste the formula copy it down Copy the minor next one Dorian, which is the second note of the major scale right click paste Formulates it starts on the second note of the major scale So the first note is going to be the second note of the major scale So there's the second note represented with a little double eyes and then there's the seven which is a D sharp So boom and let's copy this then Paste it formulas only copy it down and Then we'll copy this paste it right here formulas only copy it down Copy the Dorian next should be the Phrygian am I right am I right the Phrygian right click and paste it there It is and then the first note of the Phrygian is the three note of the relative major scale So if I go back to the relative major There's the three note, which is absolute note number nine, which is an F Boom, so we'll pick that up and then I'll copy this and I'll paste it here formulas only copy that down copy this Paste it here formulas only copy it down copy the Phrygian go into the Lydian next time and Paste in the Lydian formula only which should be the four note of The relative major scale so the first note should be the four note of the relative major sale See how what good practice this is right here. This is just great practice. There's the four note We're picking up the ten which is an F sharp boom and then I'm gonna take this Lydian and Paste it here formulas only copy it down Copy this and paste it Here formulas only copy it down and then after Lydian is the mix of Lydian, which will be the five note So we're gonna say let's paste the mix of Lydian and This is gonna be the five note of the relative major scale. So back to the relative major scale and There it is home base the five note is this one Which is a 12 or G sharp the last note in the musical alphabet as it it happens and copy that and Paste the formulas here copy it down Copy this paste the formulas here and copy it down Okay, and I think that's it So hopefully again, we'll kind of test it out while we work through the the worksheet But you can see just the beauty of this now because now we can We can see this side by side to whatever we want to work on Over here like the major scale right-click and hide and Then I could hide the stuff above if I don't want to work with just numbers only I can hide that Well, it's not what I want to do I want to hide and then I can hide if I want if I want just the numbers only I can hide This stuff below from like let's just hide all of this and then hide Boom and so now we can see, you know these two side by side With the major and the minor and if I move down to the minor then I can see the relative Dorian Which will have the same notes right if I did everything correctly So now I can I can kind of move if I'm playing in a song or just just mess it around trying to say How can I move from a major scale to a minor scale? Well, it's gonna have all the same chords Well, what if I move from a major C to a minor C and pivot around the C? And then I go from that minor C to the relative modes Then all the relative modes again will have the same kind of notes Here so you can kind of see kind of try to map out the fretboard that way So I'm gonna unhide so we'll play with our now that we have our fancy worksheet We'll we'll play with it. I'm hoping to play with it and in future presentations