 Guitar and Excel spreadsheet creation mapping the path to fretboard enlightenment part number 13 Get ready and don't fret because it's just a board with strings on it and Excel will show us how it works 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 So if using a blank worksheet, you might want to begin back there However, if you do have access to this workbook, we got a lot of tabs down below including the example tab Which is the final product the end result in essence the answer key the starting point tabs are going to refer to The video presentations tying into them and the blank tab Representing the blank worksheet. We started on and what we're going to be continuing with this time What did we do quick recap of what has been done thus far? We started by thinking about our musical alphabet a and then the sharps and flats are going to be in the lower case a b So a sharp and then b c c sharp d d sharp e f F sharp g g sharp and then back to a again We numbered them which is useful both for our Excel worksheet as well as our memorization We then created our major scale from it using this green note as the key Which should be shifting everything adjusting everything if we just adjust this one note here with our musical formula We created the notes and then used it to construct this worksheet Which is giving us the notes relative positions one two three four five six seven of the notes in the scale of this case The C scale and it tells us whether we're going to be constructing a major or minor chord from it gives us some intervals We also made a circular format which could be useful Conceptually, then we did the same thing for the minor. Let's do it down here the minor the other modes the Dorian the Phrygian the Lydian the Mixo Lydian and The Locian now these are all related to the same major and they all relate Kind of to the same fretboard so we can hide Any of these we want to put it next to the same fretboard Which is going to have the same notes that we're working on which is focused in on different areas now below it We're going to start to say I'm going to put the related modes below That will have the same note. So we have where if we're in C Major I want to see the related Minor which we did last time C minor. I mean I want to use the same starting point the same root Instead of using the related minor which would be an A minor So that's what we did last time and now we're going to go to all the rest of them down below That are all going to start with a C. So we'll go to the Dorian this time now note There's one thing we didn't do last time I need to change these Letters here and instead of having a fancy formula I'm just going to say that these letters are going to be equal to The ones that we fixed in the minor mode before actually not this one Let's do it up top here. This one right here where we have the numbers. So I'm going to say this equals I'm going to look to the minor we did up top and I'm just going to be picking up this minor and I should have the same Pattern here. So I'll just pick up that pattern and copy it down. So we don't need to do that fancy Formula again. I can just pick up the relative pattern to the relative minor. Hopefully I remember to do that every time I think everything else is good. We'll test it out, you know as we start practicing with it but now I'm just going to copy this whole thing again and We'll just copy this whole thing again And I'm going to say control C and put it down below and then control V So there we have it. I'm going to name it now. It's going to be a Dorian. So I'm going to say equals I'm going to look for the Dorian that we did up top So the Dorian there's the minor Here's the Dorian. So we have the same names boom and So that looks good. And then I just need to change my root note is going to be for again So that looks good. And now I just need to copy the formula over I just want to copy the same Dorian formula scrolling up and then I'm going to go to the right where we constructed a Dorian and So that's over here. I'm just going to copy this formula So I'll just equals that and I'm just going to copy that formula down and That should populate the proper Dorian information here Which is which should be good and then I'm going to fix my Numbers here by saying this equals I'm going to go back up and look for the Dorian again looking for the Dorian Right there, and I'll just copy these numbers. So I have the proper Upper and lower case. So we'll copy those down boom and So there we have that so I think that is good I'm not going to spend a lot of time checking it right now I'm going to try to copy through and if we notice any any things that we need to tweak. I'll go back and Fix them. So I'm going to go in and say let's just keep doing this and see if I can get through At least a few of these modes. So I'm going to copy this whole thing again We'll copy this whole thing Control C and we'll put it down here control V And so the C looks good now. I'm on Frigian now, so I'm going to say this equals I'm going to scroll all the way to the top and look for the frigian that we had up top So here's the minor Here's the Dorian. Here's the Frigian. So I'll copy that name and then I want to copy the pattern So this is going to be equal to and I'll scroll up top and We'll say the Frigian once again the Frigian But boom boom right there and I want to copy this pattern which starts with that one Enter and then I should be able to just copy that down double-click on it Be a faster way to do it there. We have it now. I could change these I think I can change these by actually copying this formula might be faster and then pasting it Just the formula just the formula not the formatting and so there we have it and I should be able to copy that down And I think that should work. All right, let's go to the Lydian now. So I'm going to do the same thing I'm going to copy this whole thing and We'll just go down to I can't see how far I need to go right there Control C and then we'll paste that down here control V that looks good I'm going to take my formula and well, let's do it this way first Let's go over here and say I want to take the name equals up top and Then I'm going to go all the way to the right till I get to Lydian So I'm going to say there's Dorian There's Frigian and there's Lydian. So enter that and now I should be able to copy the relative Reference so I think I could just copy this and Paste it right here in the formula and it will take the relative formula up there in the Lydian So I'm going to then say right-click and paste just the formula not the formatting and Then copy that down and so that should give us that I'm going to do the same thing here right-click Or I can copy this control C and right-click and paste just the format. I think that should work copying it down and so there we have our Lydian Okay, let's try it again. So let's say copy this whole thing and We'll go down to here and say control C I'm going to put this down below control V and now we're on the mix of Lydian So I'm going to do the same thing this equals all the way to the top on the name All the way to the top and then to the right looking for mix of Lydian And this helps us to kind of memorize the order Dorian Frigian Lydian Mix of Lydian. Okay, boom There's that and then I'm going to copy that and Paste the formula here just the formula only Copy that down. I'm going to copy that and paste the formula only here and Then copy that down and I think that should populate it So so we'll say, okay Now hold on something went funny with that one. Let's copy that again. I did the form I did the format. Oh, I'm going to copy and paste the formula and So there we have it. So that looks good Okay, let's do one more. I'm going to copy this again ultra vase and This will be the last one we're going to copy that and put that down below here control V or paste Change. Let's change the name first equals. I'm going to go all the way to the top page up this time I'm using page up to get to the top and then I'm going to go to the right It's all the way the last one. So there's the minor the Dorian Frigian Lydian Mix a Lydian and then Locrian. So we'll pick up the Locrian That's the one we want and then I'm going to copy that Formula just the formula only here right-click and paste just the formula Copying that down and copy it again and paste that over here just the formula and Copy that down. That's the weird one that has the the diminished up top and so that looks good So that looks good. So now I'm going to do the same on the right But now let's copy our fretboards down again. So now I've got my relative I'm going to control shift down so I can see a little bit more to the side and let's copy our fretboards So here we have the minor the next one starts right there. So I'm going to make another fretboard here Which is equal to This one up top and I'll copy that down To the 8 and I'll copy it to the right There and then I'm just going to format paint it. I'll just take this whole thing and say format paint and put it right there and then this one is Going to line up to this one. So I wanted to line up right there This is going to be equal to this fretboard and So if I got something wrong on the fretboard it should copy everything should copy through so I can Just fix Whatever is wrong on any one individual fretboard and all the rest of them should be fixed as well I'll format paint this one format paint it there and So that lines up and then the next one happens Right here. So I'm just going to line it up right there and Maybe I can just copy this pattern now So I could probably copy just this pattern of the two fretboards and The relative cell references should populate down here. So I can just paste that right here Control V. I think that works and then the next one is going to be right here and So I'll just say control V There's our fretboards and then the next one is right here Control V and then the next one is that it or that there's one more is right here and Look at that. So now if I was if I was Playing with this I can say, okay, let me I can go to the I can work in my C Major I can put this side-by-side over here with my fretboard by hiding these and I can be working with the C major next to my fretboard. I can also hide. Maybe I don't want this top bit I can hide that. I don't want the number ones I just want the ones with the letters in it and then from here. Maybe I want to hide like All of this. Where's the next one? start Oh So so there's that maybe I don't want like this stuff So I could go down to here and hide this one Hide and then maybe I want to hide From I could probably go up a little higher. I Can hide well, let's go from like here To here and hide That because maybe I don't need that one in the middle and then maybe I go from like here To here and hide and then I go from like here to Here and hide and then I can go from maybe here To here and hide and Then I can go from here To here and you might have these hidden like all the time because maybe you don't want the number only ones Is what I'm doing so I can go from here to here right-click and hide So I think I hit the wrong one any case. I won't get into it now. Let's undo that last I don't know what I did there any case so well I can then say okay. I've got my major I can go to the right now and look at the minor the related minor I can look at the Dorian and so on and I can hide columns to look at these side-by-side With this fretboard because they're using the same notes and then I can also say well What what if I want to try to transition by going and using the root as my pivot then I can go to the related minor Which has a different fretboard because I can map out the notes on the separate fretboard Which will be different then up here and then if I want to transition to the Dorian the C Dorian Then again, I have a different fretboard so now I can try to say what if I look at this fresh board and then transition here How can I transition to the the Dorian to the Phrygian and see the Lydian in C and so on and Then this one I messed up, but the mix of Lydian and then you know the Locrian How can we transition between those and we have all the different fretboards all right? So I'm going to unhide everything unhide and let's unhide this way unhide and Then now I'm going to do the same thing in future presentations just for like if you had The major here and you went to the minor and then you wanted to go from the minor Which is now on an a and go below it so I'll do the same thing and just add the related Ones below it for all the rest of them, which is should be the same kind of Process shouldn't be something new and excel so but it's kind of useful just to go through the steps and we'll and that'll be our worksheet