 Guitar and Excel spreadsheet creation mapping the path to fretboard enlightenment part number 12 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 using a blank worksheet, you may want to begin back there However, if you do have access to the workbook, we got a whole bunch of tabs down below Including the example tab which is the finished product the end result in essence the answer key the starting point tabs Corresponding to the video presentations as we work through this long practice problem The blank tab representing where we started with a blank worksheet and where we will continue at this time With a quick recap to start out with so we started our project by listing out the musical alphabet In a column format a and then the sharps and flats being the lowercase a b c b c C sharp d d sharp or e flat e f F sharp or g flat g and then g sharp or a flat and then we repeat that process We then numbered our notes useful both for Excel formatting and for memorization Purposes so that we can start thinking about the intervals we combined the two together We created our fretboard on the left-hand side from that information with both just numbers as well as numbers and The letters then we constructed our Scales and we tried to make them so that we can adjust to the different scales with our key here in Which if I put a four is the C where we started and if I change it to a six it changes to D And everything related to it should then change we created our worksheet from that which gives us the Major scale information including the relative positions one two three four five six seven notes in the scale and then the Roman numerals capital or not capital or uppercase or no will show us whether or not it's going to be constructing a major or minor scale We also have the intervals up top and whatnot which we'll play with we've put the same information in terms of a circle We have the same thing with the numbers and the letters down below then we created the related the related Modes including the minor or Aeolian mode Related to the C major or whatever we put in that green cell that we started with then the Dorian then the Phrygian and Then the Lydian Mix a Lydian and finally the Locan so now death This is all great because now we can think about how these things relate to the major scale and we can use this same Fretboard to practice all of those different modes because all the same notes Are in that fretboard, but it's also useful that sometimes we want to switch when we're playing between Not between the relative scale if I'm in the C major I might want to go to like a C minor or a C Dorian which has different notes in the scale But I can use that as the pivot point. So what we want to do now is start copying this stuff down I would like to have below this one a a See the the related modes below it and that way I can scroll down to the ones below it and I can use a different Fretboard I can make the same fretboard down below so I can easily scroll up and down between the two fretboards when I'm going from a C major Save to a like a C minor All right, so that's what we're gonna do now So I should be able to do some nice copying and pasting when I copy and paste below I'm not going to use the major because I want to use one of these over here that we had good practice with and we got all the formatting down So that we can copy it over Easily, so I'm just going to go over here to like the Dorian I'm going to copy everything related to the Dorian the way we did before but instead of taking the entire Column because I'm not going to the right. Everything should be formatted uniformly So I'm just going to take the actual cells I'm going to put my cursor around the top cell make a square around this whole thing down to Here so I have everything I need For that what's related to this grouping I'm going to say copy and then I'm going to paste that underneath this time the major So here's the major one Here's where the actual information related to the major Scale is this stuff over here is all the notes, right? So I want to be in column ae I'm going to go down below in ae and control v or right click and paste So there we have it now it looks kind of like a mess because now it's it's trying to pull this note in And it can't do it because the relative cell is on the right But that's okay Because now what I'm going to do is just say that this first note is going to be equal to the same note As the major up top that number four So that one is going to be the same and then what I'd like to do this time instead of copying that down What what I need to do is I'm going to first look at the formula So I want to look at the relative formula So, uh, you'll recall that the formula up here For the major was whole whole half A whole whole whole half I'm just going to look for the formula that's going to be related to in this case. We're looking at the minor So I'm going to call this Minor and and I'm going to do this by saying equals I'm going to scroll up and find the related minor So I'm going to say this is the major the related minor is over here and I can copy that same name So there's the related minor the name is then pulling in And then so now this is the c minor not the related minor to the c major which would be a minor A minor is related same notes as c major The c minor is going to be different notes, but pivoting around that central one note of the c So now what I want to do is find the minor the minor formula So I'm going to say this equals I'm going to go find a minor that we fixed up top So here's the minor formula And I want to pick up that number two and just copy that formula down So I'm going to say enter and then I'm just going to copy the minor formula down that we created before And that should populate then This information hold on a second now this information. I'm going to say let's pull that from actually our major Our major stuff. So I'm going to say now we kind of reversed The format so if I look at my major this one we created with this if then function So I'm going to use this formula and I'm going to put that down here So so what we're just doing is is taking this plus this but it goes if it goes over 13 Then I'm going to have to subtract the 12 to get us back to where we need to be when it goes around The horn or over the top past 12. I can copy that down And that should give us Our uh our formula So then we have our notes over here So I think that's populating properly. Everything else should populate properly And so now we have this one. This should populate properly all of these I think are going to populate Properly and then down here We have now the minor which is mapped out With uh the a c minor as opposed to the relative again a minor and then it's mapped out over here Which which looks good. So now I can move from here. I can say, okay. I'm going to move from a c Major and then move down and then start playing with the c minor down below So now I also might want to put my my I'll just copy the fretboard down here too. So I'm going to put the fretboard down here I'm going to put it so it corresponds to This area so I'm going to say this equals I'll do both of them again I'll say this equals the one without the one up top here I'm going to copy that across I think it goes to right there And then I'm going to just I'll just copy the whole thing down. I could just copy this whole thing down And then boom down I go too far and then I delete this last bit And then I can copy the formatting So now I'm just going to go up top and copy the formatting of this whole thing And go to the home tab clipboard format painter And I'll bring that down here and just format paint it And so there is that then I also want to do another one that has the letters involved in it I want to line up to to this area to right there in that row So I'm going to say okay. Let's do it this equals This one this time And I'll copy it to the right all the way to the right And then down I'll copy it too far and then I'll fix it right so there it goes down to there and then I'll delete that last one And then I'll just format paint this one So we're going to just format paint it I'm going to take this whole thing This has the the The conditional stuff, but I think that won't mess anything up home tab clipboard format paint it And then I'm going to paste that right there and you've got the conditional formatting, but we can clear those Uh, if if we wanted to clear the conditional formatting So now I can see these two side by side. I can say if I hid these cells From here to here right click and hide I can say okay. I'm in I'm in this the c major And then I I could if I'm working here now notice I might not want this with the numbers So I could hide this Right click and hide And then I could I might not need this one, right? I could hide this and Say I don't need that bit right click and hide So now I could be working. Okay. Here. I am using The c major and if I wanted to then go over here and and transition To the related minor I could go here and I can hide These if I wanted to to have them side by side or I can say I'm going to go from The major down to the minor so and the minor is going to have a different fretboard related to it Which will allow us to easily transition So I can say I'm going to start working on going from the the major up top in the c major to the Not the relative minor which would be a minor but rather down here to The the c minor and so then I can say how could I map out the c minor? So if I started to kind of play around with this I could say okay If I'm playing around and I'm just kind of playing on the guitar I could say okay. I'm playing in c major and then maybe I transition and see if I can transition to Orientating myself around the minor or orientating myself around The dorian or something like that Any other mode that I want which has all the same notes And then maybe I can go back to orientating around the c Use that as my pivot point to then try to transfer to the c Minor instead of the a minor and then try to play around with the and that has a whole different set of notes here, so then I can try to map that out and see if I can Kind of play around from going that way. So that's how that that's how I'm thinking the worksheet could be useful So let's unhide here and we'll continue this process. I'm going to unhide This and then we'll unhide this And then We'll continue that so I'm going to continue that down So that we just did the minor And just like we did with when we went to the right the reason I started with the minor underneath Instead of the dorian because that would be the the next one is because the minor is most common So notice if I if I went through the modes you would think I would say this is the major and then you'd go to dorian But we jumped over to the minor because the minor in western music is usually the most useful So you go you go the major and then the minor and then I'll go around I'll just go around the loop for the rest of them, which will be uh next the dorian