Everybody for us tier ripping 2021 top scrum f1 racing sapphire five bucks number 24 Random pack style. So there's 20 spots to the break. Everyone's gonna get two packs Everyone's name isn't the randomizer twice or every spots in twice Thanks everybody for joining. We've also got numbers one through 40 and the other randomizers So I'll randomize both of those at same amount of time is put inside by side to know who's getting what's how it's gonna work I'll go left the right first box When the packs are facing up, I'll just take them out set them down like that top pack is number one Bottom back number eight. They're gonna be facing up So, yeah So yeah one through eight tonight through 16 and so on Good luck everybody on the random do the random first year and eight a three and five Want to ran up a three and a five? names first one two three four five six seven eight Scott f down to Alexander s and eight times in the pack numbers one two three four five six seven eight 28 down to 33 Scott f 28 9 Danny G 27 20 Scott f 38 Alexander s to Braden K 39 Taylor D 36 Scott f 31 Taylor D 25 Danny G 18 8 10 Scott f 12 and 7 Taylor D 4 Braden K 22 Taylor D 35 Danny G 23 Scott f 34 Taylor D 24 and 3 Danny G 6 and 29 William L 14 Danny G 17 Brian G 21 Braden K 30 Scott f 13 Braden K 5 Taylor D 32 William L 16 Taylor D 37 max H 26 Braden K 15 max H 40 Brian G 1 Danny G 19 Braden K 11 Alexander s 33 these results posted and we're gonna get ripping here Also, get your link in chat. Thanks guys for filling up group breaks tonight Here we Go, there's your link just sort these Packs one through eight again, like I said facing up back number one There's a first stop and I start with a short truce formula one freshest Yuki Sonoda 86 of 199 Nice Yuki good start packed one Mateo Nanini and Max for stopping to Lewis Hamilton Got the upper share James Allison and make Schumacher rookie Pack three David Beckman with a gold Sapphire Future Stars Ralph Boshung 36 of 50 You go pack three Kimmy Reichenan and a George Russell number four here Jean-Lucas Petzikoff Aqua Nikita Mazpin rookie numbered 70 of 99 Pretty solid color in this first box here here ghastly and a basur number five Roy Nassani a Yuki Sonoda formula one freshest rookie. It's one there. Is that the short prints? Yep, that is nice Yuki short print rookie you go pack number five Rotary Botas and but no toe number six Lewis Hamilton Richard for sure Sebastian Vettel Ben Pascal number seven other color here Roman Grosjean a Chartreuse Oscar Piazzari Future Stars nice 184 of 199 Carlos Sainz and Lewis Hamilton and number eight Antonio Giovanazzi Max Verstappen Robert Schwarzman and Lewis Hamilton, so that'll be do this. That's the bottom There we go. That's not supposed to be All right, here we go pack number nine Yeah, it was a nice piazzari Good young driver Liam Lawson Um Fernando Alonso Pierre ghastly and Charles Leclerc number 10 Bochum Aqua Nikita Mazpin rookie that's back-to-back boxes with the same car 32 and 99 this time though Fernando Alonso and Sebastian Vettel pack number 11. We got Pierre ghastly with an orange behind it Wow, very nice Sergio Perez orange big card there That card number 46 13 of 25 on the Perez Big stuff dust on that card Vettel Alonso, right so number 12 My Yugi Sonoda Nikita Mazpin Jos Capito and Sergio Perez 13 max for stopping with a Nice CPL anstroll nice card there four of 100 up here. Okay, or watch a and Sergio Perez Good stuff my good break so far number 14 Lewis Hamilton car number one David Brevio Sato and signs pack 15 But Tee-Fee another CPL total wolf this time 83 of 100 Lewis Hamilton Nikita Mazpin and number 16 Sergio Perez Daniel Ricardo Lewis Hamilton and Liam Lawson number 17 Got for sure. There's a chart shoes Kimi Reichenan. That's the short print right gotta be Yeah, 150 one-on-one 99 the short the short print variation Kimi Reichenan, very nice I have a skull and alabona number 18 Couple of rakes tonight man Roman Grosjean and orange Lewis Hamilton You're on fire with F1 tonight 11 of 25 Holy cow, dude, holy cow just on fire with F1 Big Lewis there insane man Sergio Perez and Yuri Vips number 19 now Geo Vinazi Verstappen George Russell and Zendali Number 20 Max Verstappen and Aqua Antonio Geo Vinazi 59 of 99 Daniel Ricardo and Pierre Gasly 21 pets cuffs Kimi Reichenan Fernando Alonso and Capito 22 22 The Oprah share chartreuse bent Viscale 76 of 199 Yeah, Sergio Perez Joaquin 23 Mercedes team Lance Stroll Sergio Perez and Marino Sato and 24 Joey Egenton Sharpe truce Pierre Gasly Grand Prix winner Italy 62 of 199 Carlos Sainz and Lewis Hamilton. Yeah, Lewis was off-center. It's still a huge car though number 25 Tee-Fee Okon Sonoda rookie in a monshow 26 Kimi Reichenan Fernando Alonso Sebastian Vettel and Franz Toast 27 Leclerc Stroll Russell and Schwarzman 28 as the bone Okon Soft now or Latifi and Nisani 29 Max Verstappen Green mick Schumacher rookie Very nice 20 of 75 on the mick Lando Norris and Lewis Hamilton number 30 here pack number 30 Gold after the Christian Horner is Charles Leclerre Holy cow huge hits 25 of 50 huge hits in these breaks This is insane dude pack number 30 This one's going to Brayden K congrats Brayden. Yeah, it's I We've ripped a good amount of this. This is a break 24 of this stuff. I haven't seen That amount of like gold portraits for these guys. That's a huge card. Congrats pack 30 Brayden K Number 31 We've just been on fire all night tonight, I guess Tee-Fee Petticoff Zendeli and Russell. Hope it carries over for personal and 32 32 Nisani Hamilton Beckman and ghastly Last one. All right, this is 33 here. Daniel Ricardo Carlos Sainz, George Russell The arms and deli 34 Yuki Sonoda rookie Aqua Theo Porsche Nice Theo 1999 Daniel Ricardo and Pierre ghastly number 35 Drugovic nice and that's the bone Okon sepia 56 of 100 Very nice card there Charles Leclerc and Fernando Alonso 36 Fernando Alonso Samaya Vettel Vettel 37 the Lewis Hamilton another gold dude. Come on Come on Gold Max Verstappen short print.   Thanks again, everybody. Personals coming up shortly


About 20, 25 years ago, my former pastor and mentor tried to implore me to go to seminary. He thought that, Cory, you have an understanding of the scriptures, but you should let someone pour more into you and to kind of delve into you, kind of stretch you, kind of test you, push you to defend the scriptures. I had a love for the scriptures, but at the same time, I felt like one, I didn't have enough time. Two, why bother? I've got the scriptures in the Holy Spirit. The problem is, when you read the scriptures, sometimes your own imagination, your own preconceived notions, what you think or feel, can creep into the text. You may unintentionally ice-ajeeb the text. What does ice-ajeeb mean? If you don't know what that means, then you might want to take part in what I'm going to offer. If you do know what that means, you're going to want to take part in what I'm about to offer. As many of you know, I'm in seminary at this moment, and one of the benefits of it is to have someone to kind of push you, one to help you to articulate what you're saying, also to help you to see, are you possibly missing something? And so what I want to do is offer those of you guys who really value the Word of God an opportunity to have the same sort of testing and pushing the same experience that you might get at a seminary, without having to obviously pay and obviously take the time, but just to kind of give an idea, a little bit of insight at the kind of training and teaching that you might get at seminary.  It is free. Remember, joining our Patreon is free. There are different paid tiers and so forth, but everyone gets the same thing. Why? Because again, whatever someone wants to give, it goes towards those in prison to receive Bibles and study materials, Christian youth groups to be supported, as well as sending Bibles overseas. So if you want to pay fine, if you don't want to, fine, you're still going to get access to the exact same thing that everyone else is going to give. Unlike what you might see on the channel, what we'll have here on Patreon is we'll have different assignments. You'll get some of the same seminary assignments, obviously not what I get them. You get them after the fact or something similar, something different, and you'll get exposed to what different seminary professors are asking what they're requiring of their students. We'll cover different issues in systematic theology, different Bible study methods and so forth, how to exegete and also how to communicate the passages. We'll cover the different languages, specifically Greek, some beginning lessons in Greek, how to read Greek, how to understand what it's saying, and then how to in turn apply that to the text. And then after that, how to apply that in explaining to other people because the goal is to not just get information, but to communicate the information. That's why our model is to love it, learn it, live it. Love the scripture so much that you want to learn it and then learn it so much that you want to live it out by giving it to other folks. That necessarily means you must understand the text in order to communicate the text. So if you're interested, please go to our Patreon page, click the link listed below, and there you can just sign up and you'll start seeing some of the lessons as early as this week. And then you'll start taking some of the lessons. They'll be homework, do it at your own pace. There's no, there's no hurry, but you will be challenged. You will be pushed and you're going to see yourself grow. And even for those that might think that's a waste of time, there's no need. Well, I would even offer the same challenge to you. Try it and see if this might be something that you get a benefit out of it. I did. I thought at one point in time, I don't necessarily need it. I found out, you know what? Seminary is the byproduct of people who have labored in the scriptures, just pouring out to others who might want to see the riches of the scriptures that they've discovered, even through the languages, through the culture, through the history, through the text, things that you might not have seen and seen it from someone as a standpoint, but also forcing you to make your case, not with your opinions, but with the scriptures. So I look forward to seeing you guys over on Patreon page as we delve further into the scriptures. Amen.


Hello everyone and welcome to Blackstar Potential, my name is Lee Fuge and I'm here today with MusicTeacher.com and in this video we're going to talk about starting out with legato playing. All of the tones you're hearing in this video are coming from the Blackstar HT20 Mark II which is on the drive channel and the amp is mic'd with an Aston Origin Condenser microphone.  The term legato essentially means to join up smoothly. So what we're going to focus on in this video is looking at ways to get you started with some smooth legato playing. So with all of these exercises you can aim to push them very fast if you're into guitar players like Joe Satriani for instance who is a very fast legato player. You will want to stop building up speed on these gradually. But in the early stages don't worry about the speed, just focus on the clarity of the notes. That's the most important factor when it comes to doing the legato. So all of the exercises we're going to do are going to focus just on hammer-ons and pull-offs. You can integrate some slides into your legato playing as well but for the time being we'll just stick with hammer-ons and pull-offs. First exercise we're going to look at is an ascending hammer-on riff that plays across two different strings. We're going to be using the first, the third and the fourth fingers for this. So this lick uses the fifth, the seventh and the eighth frets on the B and E strings. What we're actually doing is a double hammer-on here. So I'm picking the fifth of the B, then I'm hammering on to the seventh and with the same motion I'm hammering on to the eighth. So you'll notice I only picked the string once. The second note comes from the force created by the hammer-on from my third to my fourth finger. And then repeating the same pattern on the high E string. So timing-wise what I'm playing there is actually a series of triplets. So that's three notes on every beat. That means we're hitting the fifth fret notes on the beat. So it's one, two, three, four. So your picking hand should only be picking four single times in an entire bar. One, two, three, four. What I like to do is down-pick the B string and up-pick the E. So as you start to build this together try and get each of those fifth fret notes to fall on the first beat and then gradually increase your speed over time. Don't worry about the speed right now, focus on the note clarity. The second exercise is the same thing but backwards this time using a series of double pull-offs. So essentially repeating the same thing but upside down now. So I'm actually starting with all three fingers in place on the high E string and picking. So you're going to hear the eighth fret note first and pulling off to the seventh and off to the five. And then I'm just repeating the same thing on the B string.  And then pulling them together. This one can also be worked out with triplets and also your picking hand is still only picking four times except this time we're starting with the E and then going to the B. Fourth legato exercise makes for a great fast rock lick. So here is in full. So this lick actually looks a lot more difficult than it is but what we're actually doing here is we're playing sixteenth notes. So we're doing four notes across a beat but the first six notes all happen off the back of one pick stroke. So I'm actually starting by playing the seventh on the E hammering onto the eight and pull off again. Then I'm actually pulling off to the fifth of the E so this is all one motion now. So one pick stroke is going to get me all these notes. From there I'm actually hammering back to the seven and pulling off to the five again. So six notes off one pick stroke. Now that is going to take a while to build up because you do need some additional strength in the fret in hand to keep those notes ringing clear. So you may find in the early stages you do have to really hammer those notes on to get the extra clarity and volume you need but your fingers will build up in strength with a bit of repetition. So once you've done that initial six note phrase you're picking the eighth fret on the B and then the fifth on the E. So it's an eight note phrase across two beats so that's sixteenth notes but you're only picking three notes. You're picking the first note then the eighth fret on the B and the fifth on the E. The fourth leg art exercise we're going to look at is another one that builds into a great rock lick. This is sort of a pentatonic-ish looking idea so you may feel quite familiar with some of the movements in this but we are adding some additional notes. So this one has a lot more pick notes and it does sound a bit faster but we're still playing sixteenth notes but I'm picking two notes close together so I'm going one E and then the anda are handled by legato notes and then two E and the anda are handled by legato notes. So it starts with this descending phrase where I pick the fifth fret of the high E and then the eighth fret of the B. Once I've picked that eight I'm pulling off to the seven and off to the five. So that's my first beat, one E and a. Then I'm coming back up with an ascending run so I'm actually starting by going down one more note to the eighth of the G. Then I'm playing the fifth of the B and hammering on to the seven and eight. One. Two. The fifth and final exercise is a quick triplet style lick so this again is a great speed building exercise if you're working up to playing some shred guitar or some fast rock licks. This is a great one to start building in. So we're once again leaning very heavily on those double pull-offs. So the first thing I'm doing is a pull-off from the eight to the seven to the five on the high E string. So this is triplets now so that's one. Then I've got a picked ascending run here. This is also a triplet but I'm playing the eight on the B, the five on the E and the seven on the E. It's very important you pick those notes because it creates this accent. Then we're doing a pull-off again from the eight to the seven to the five and then the same on the B string. So each one of those groupings there is a triplet so it's one. Two. Three. Four. Picking wise, for this I like to go up for the first triplet. Then I alternate pick the next triplet. So I'm hitting the seventh fret of the E string there on a downbeat so it's up. Down, up, down. Then I do the next triplet as an up and the final one as a down. So there you go, there are five legato exercises to get you started. Like I said, don't worry too much about the speed, focus on the note clarity. Legato is a great technique if you want to stop building up some fast rock, fast metal and shred guitar licks. It's a very essential skill to have in your toolbox. But it does take practice, it does take work, and it does take some strength building so really take your time with this. Practice these groupings with the metronome as well to help build your speed and clarity of the notes. Make sure each note is ringing as clear as you can possibly make it. Thank you all for watching, I hope you've enjoyed this lesson. Please let us know down below in the comments how you've gotten on with these legato ideas. And if there are any topics you'd like to see us talk about in future Blackstar videos, please let us know down below. Don't forget to check out Blackstar Amplification on YouTube for more free video lessons just like this. And if you're looking for a guitar teacher in your area, please head to musicteacher.com and check out the network of great music teachers all around the country waiting to help you guys out. Thanks so much for watching and I'll see you soon.


Hi guys, this is Jason Zach here from the Nathaniel School of Music. In this lesson, I'm going to introduce you to a two-handed arpeggio pattern. Usually arpeggios are done with like one hand, right hand, left hand. I've done quite a few, right? And this two-handed arpeggio pattern can be used for anything which is like a modern, ballad or country feel or it could even be used for like a modern gospel, like a praise and worship kind of feel. You use this a lot to bring out stuff which is very inspiring and uplifting. The music could be very motivational and stuff like that, as you may have figured by the introduction video, right? It's for some nice ambient stuff or ballad stuff and it also allows the singer or the vocal line to go all over the place, right? And what I like about this approach which we have developed for this lesson would be it uses the same arpeggio pattern. It's just one pattern throughout the video which I'm going to teach you first and then we'll do the exploration from that one pattern. And when we explore it, the good thing about this video is there are not going to be any chords as such. I'm not going to give you a chord progression, but yet it's going to sound as though there are some serious chords going on. For example, you know, something like... So there's a technique we have for you which will allow you to actually create this harmonic content using a very popular rhythm. You can call it even maybe call it like a modern pop rhythm. You'll find this in almost all the ballads these days in the past decade or so. And I'll first walk you through the rhythm, then I'll be walking you through the actual scale which I'm using, the pattern which I'm using. I will break it finger by finger, thumb by thumb and everything else. And then we'll look at how we can explore this and use it as a great songwriting tool. That's the final goal of this exercise, to show you how you can build a song without even a chord really. Just a pattern, a scale and the piano. That's pretty much it. So I'm excited to share this with you. Let's get cracking before we do. Do consider subscribing to our YouTube channel, hitting the bell icon for notifications, leaving us a comment for something you'd like to learn in the future, like the video without fail. And also do consider heading over to our Patreon page where all these notes are laid out for you very neatly as a downloadable PDF for a very nominal subscription. You'd also be supporting our channel greatly. Let's get cracking. So you have this pattern. Let me first play you the pattern. So the first thing you'd like to note with this pattern is it's following a 3-3-2 feel or a counting feel. It's almost like you can go 1-2-3, 1-2-3, 1-2-1. Some people confuse this with a triplet. It's not a triplet. It's actually what we call as the thresio rhythm. Thre meaning three of something. So thresio. So we count it as 1-2-3, 1-2-3, 1-2-3, 1-2-3, 1-2-3, 1-2-3, 1-2-3, 1-2-3, 1-2-3. You've heard so many songs like this, right? 3-1-2. That's why I chose this. So generally whenever people play arpeggios these days from the material I hear, especially the modern pop hits which are doing the rounds on Spotify, if any piano is doing mellow, ballad, arpeggiated stuff, it's generally on this rhythm, which is takita, takita, taka, takita, takita, taka, 1-2-3, 1-2-3, 1-2-3. Even though it is 3-meeting, 3-meeting, 2, the beat is not triplets. You're not saying 1 and a 2 and a 3 and a... You're not doing that because then the 3 and will go for a toss.  So a lot of musicians will simplify it by just saying it out as 1-2-3, 1-2-3, 1-2, but whilst doing this, you need to keep the pulse in mind. You could either observe the pulse as quarter notes, 1 and 2 and 3 and 4 and 1 and 2 and 3 and 4. Or you could observe the pulse as slow half notes or minims, as we call it. That'll be 1 and 2 and 3 and 1 and tak, doom, doom, which is more common. Okay? So that was an overview of this particular time feel which I'm playing around with. Now let me teach you the pattern. So I've chosen E-flat major scale as my scale for the lesson. Some of you may be wondering, why have you not chosen C major? Well, I don't like it. So I'm going to do E-flat. It's a nice scale. Lot of our favourite artists use it, Simon and Garfunkel, not our Jones to name a few. So E-flat is the scale. Forget C major. Let's start. E-flat. It has 3 flats. E-flat, F-G, E-flat, B-flat, C-D, E-flat. So this entire pattern, the most important notes for this exercise will be obviously the root. E-flat. So I would first say, get into this hand hold, pinky on E-flat, thumb on E-flat and probably your ring finger or your middle finger on E-flat at the top end. Primarily because the black notes, generally we don't use our pinky, otherwise our hand will have to angle weirdly. So ring will be a great finger for the top. So get this basic shape first. E-flat, E-flat, E-flat, E-flat, E-flat. Okay. And then in the middle, we're going to start off with our thumb playing G. Okay, that's your shape. So perhaps you could start by whacking all the four together. We're just going to use four notes for this exercise for the most part. Okay. Okay. If you'd like, you can ignore this pinky E-flat for now and go that, but I think it's nicer to go all in. E-flat, E-flat, G-E-flat. That's your base. Now you build a pattern. As you can see, it's an arpeggio created with both hands. Okay. The two hands are working together for the same goal to make an arpeggio. What am I doing? Playing it slowly. So the first hit is actually struck by the root and the octave of my left pinky and thumb. And then you do thumb ring, thumb high. I'm just calling it as the high root, high E-flat. Let's get that first. Together, break it there. Together, break it there. That's your first three beats. Okay. Now we break up the left hand. Remember what we did earlier at the right hand area? G-E-flat that continues. So together, two, three, single. While this is going alone, this can be holding. Okay. That's important. That'll sound great. Then you end, you cap it off with your two thumbs. So I'm going to call it as root, thumb high, thumb, thumb high, thumb, thumb. You see, there's a lot going on with your thumbs inside the two hands, right? Because the left hand thumb will be inside. Right hand will also be inside when you're visualizing. This is outside. This is outside. So together again. Thumb, thumb. Thumb, thumb. So it ends with the two thumbs. And if you're very new to the instrument, maybe you're finding tricky to hold both these together. So even this would work great. May not give you that much depth, but it still sounds great to me. All following the thresio. So if you actually break it down, if you just consider what the left hand is doing. That's the thresio rhythm. And you're filling up the missing beats in your right. Thresio on the left. That's your right hand. So put it together again, guys. Play it with some serious dynamics if you can. Volume, that means. Soft. Get louder. Actually controlling my volume with just my breath. Just breathing in and out. There's a nice lesson on that which we'll put in the description for you guys to check out. So anyway, that's your base pattern which I think is already nice come to think of it. Very pop-ish and very usable for a variety of songs. So now we're going to look at a good number of variations to spice this exercise further. They're very quick variations, very easy, very simple approaches. Let's get cracking one by one. So the first thing I'd like to do is take this middle note, the G and take it to town. That means you just explore the scale rather than thinking, oh, which chord should I play? Not needed. You already have a nice foundation built with the E flat.  So you go in the first cycle you do G, next cycle you can weave it around to A flat. Quite like that. So maybe let's do both together. E flat, A flat, G, A flat, G. Why not we try a couple of other things. F. A flat. Try to stick in the key. We don't want to do that A which is a tritone. I kind of like it but stick within the key of E flat then we are going more pop, folk, modern music. A flat, B flat, C flat, E flat. I just love that, really love that dissonance. It creates a very beautiful effect if you move it around, you know. As a great ear training challenge, isolate the moving note or the floating note and sing it. Use Swara as if you want. Speed it up. The flat 7 if you like that. Flat 6. If you want a minor vibe, why not. So that's the beauty of this environment. It's a bit scale independent as well because you are literally just playing the root, the tonic or the sa of the scale and maybe the fifth as well which we'll come to shortly. There's a lot of room for harmonic exploration as well as even changing scales. You can start a layer of the song or a section with the major vibe. So the isolation of that note, that middle note is very crucial for the music to actually compose itself or make it into a song. Otherwise you probably may just be stuck on the G. You may not know where you're going. Another nice thing would be to just compose a very short, easy to understand simple melody which you can do while doing the piano job. So something like it should work really well for a verse of a song and then you can actually release it in the chorus to create some nice harmonic movement. So that was the we started with the foundational finger movement over the thresio pattern. So we just floated around the thumb that was you could say our first variation and now the next variation which I'd like you to consider is to float your right hand movement you are initially floating the thumb note by playing all the other notes of the E flat major scale. Why not play it in thirds? So you could do things like first of all a recap on the thirds this would be E flat's third F's third G's third A flat's third B flat's third C with E flat so there I would suggest to go over a chart on Patreon you'll have this written down neatly. So you just basically look at diatonic thirds from the E flat major scale and instead of just doing single G you can do you can play the B flat along with the root either together with the G or but I prefer G its third along with the root. So obviously this is the E major E flat major chord but it doesn't have to just be E flat major you can do A flat with its third which is C with the same E flat with its third D and the same E flat Now in this region you have F with A flat G with B flat A flat with C B flat with D but now you're probably wondering I'm stuck because my wall is created with the E flat. Well it doesn't have to be a wall it can be what happened there I moved my top most note from E flat to B flat nothing wrong with that that's the fifth of the scale another very pivotal note so you go third pairs within the vicinity of this much E flat to E flat high love that when you want to access some higher notes pivot your B flat and use thirds as long as you use these third pairs you're good to go so a lot more harmonic flavour or harmonic colour than maybe just floating around one note so instead of floating one note we are floating thirds as opposed to the earlier variation where we did E flat B flat single still nice but a lot colourful with the thirds can inspire a melody as well so that was thirds guys so I have one more right hand variation for you before we just cap it off with some left hand improvisation so the next right hand variation would be using what I call a spread thirds where instead of playing E flat with the G up top that means it'll be closer right E flat to G you take the high G put it below the root and you get a spread effect you get E flat with it's third played below it get a more denser or a more bigger, wider deeper third so now if we take the same pattern of course this is exactly what we did in the very beginning of the lesson this is what I taught you in the beginning now what if we take the next third pair in the spread version which could be which could be A flat F normally A flat would have been on top there but I am bringing it down there and I am closing the harmony it's like the harmony is not you know random there is no chord the up top there and then a bass note really down I am kind of making the two hands and the arpeggio has literally as I told you at the beginning of the lesson is just one arpeggio with two hands so you go what are my pairs spread thirds another one B flat G C A flat D B flat E flat C F D flat D G flat so you could literally build your scale with the pattern and I have a nice trick what I do with these thirds will be the very last hit don't do hit one of them hit both because you don't have an extra beat you don't have 1 2 3 1 2 you are not doing endless triplets so at the end of it all one triplet or rather 1 2 3 1 2 3 1 2 at the last 1 2 you want to hit them together let's see how it goes don't think that oh this is all very happy folk music all the time that's only because of the scale what if I do that's your minor there we go the emotion changes so it's not the pattern which is causing the emotion it's the scales minor or major so major would be more like a folk song you know minor well maybe for like a movie theme tension if you want depending on what you are doing but then don't go non-diatonic initially think of the scale stick within the scale then see how it goes last thing I'd like to add well I have to add this because right now the right hand was going all over the place but the left hand was droning it was just droning with E flat so you are probably wondering if the right hand was able to explore so much why can't the left hand do the same exploration well that's exactly what's going to happen now so let me demonstrate that's E flat C B flat so you maintain the same pattern let's just show you this with C you see it's still the same thresio B flat E flat thresio C B flat E flat with the right hand that's my pattern you are doing spread third movements there you are doing base movements there but you are keeping the pattern still which is 3 3 2 right that didn't change so far so a good way to practice base movement would be maybe keep it simple in the right hand move the left slowly move the right hand thumb this one and then do your other stuff in the right hand which I taught you spread in the right hand right so what I wanted to touch on lastly would be how you can use the exact same rhythm the same arpeggio build sections of a song you do not want to just stop with it as an exercise or something which helps you build one small bit of a piece of music why not use it for the whole song so a great approach would be use combos of them like you could go spread thirds with a static root for your verse maybe a simple chilled out melody like the next part could be with a changing bass C spread voicing in the right right also different dynamics you play something super soft or explode it in the chorus dynamics will help you build sections and of course a great way to build sections would always be use your voice your voice is completely free so think maybe in one assortment or with one variation you want to sing this kind of a melody with the next variation you want to do a different melody with maybe some kinds of change some kinds of well variations I have given you quite a few variations so far three in the right hand one just floating the thumb the other with thirds closed thirds with the same root on the top or else the fifth on the top then we have looked at spread third in the right and then to cap it off we just float around our left hand and at the end of the day it is still the same thresio same old same thing over and over again so the whole purpose of this lesson is to give you that modern day pop ballad rhythm which is essentially like a thresio rhythm going on for us and to use it hopefully also as a song writing tool use it as a nice combo tool usually we look at arpeggios with one hand and the left hand doesn't do much or the right hand doesn't do much here both hands are working together for the same outcome to create an arpeggio but harmonically very interesting and very dense and the other hopefully interesting part of this lesson was we didn't have a chord progression so this is one of the few lessons at least on this channel where we are building harmony we are building progressions without chords well they are chords but we are not imagining it that way we are just stacking up the root the fifth bringing in a couple of notes of course playing the modern pop pattern which is iconic in nature you could build a song with this I hope so I hope you have fun with the exercise I hope you get creative we have an instagram channel for my account which is jasonzak or our school instagram which is Nathaniel school so what you could do is you could reach out and get me to hear what you are up to and what you are doing by recording something over this exercise and I would request you to tag me I will go through it, I will check it out and I will probably reshare it as well which will be quite cool so record yourself playing it and you can actually get me to hear this otherwise I don't know how I am going to listen to you people through a youtube forum only we will have to figure out another way so instagram becomes a great tool for now record it, put it up there and also do consider heading over our patreon page and getting all these notes neatly assorted for you to practice in a very organized way like the video, share the video leave us a comment with something you would like to learn as always this is jason here from Nathaniel, see you in the next one cheers


Hello everyone and welcome back to another tutorial. In this video, we're going to be looking at searchable drop-down list So the video is going to be in two sections as such Mostly we're going to be firstly looking at how to create the searchable drop-down list And at the end there we're going to be looking at how you can create multiple drop-down lists So you'll see as we move for this video And we do the first search down drop-down list that searchable drop-down list You'll see obviously the limitation that it could have in its default form And we'll just show you how you can use that if you want to be having multiple drop-down lists within your report So the basic formula or not formula set up we have for today is we've got a report sheet where we're going to be sharing Obviously the multiple drop-down lists and then we've got master data. What sits behind that? So master data is just a customer and company column and we format this into a table what you can see by obviously click into it or the table options here and You scroll down and you can see also you've got a corner formatting there to show you that it is actually a table And we can see the details for the table is this is called doesn't quite fill the page, but it's cool Oh, there you go. It's called a customer table. So that's what we'll be referencing for that It's also worth noting. I'll just put the website on here of generate data.com This is where I've generated this random data that I'm going to be using for this tutorial And it's also a great resource for you if there's other data you want to generate It's all completely just random So there's obviously no actual data being used and it's just a really good resource for getting that Generating random data for when you're trying Tutorials such as this or when you're just doing your own work because obviously appreciate these formulas need data for you To actually be able to try them in the first place So the first thing we'll start by doing is building out obviously the validation prep In column F here So this is where we'll gradually build a formula to show you how the dynamic list is can be formed and we'll be using data Validation to provide the drop-down list in the report sheet So we'll further delay will jump straight into it Although one delay is if you're new to the channel Please do subscribe to the channel and hit that Bell notification button so you're notified of our future videos And also if you do enjoy the content in this video Please do hit that like button something only not only appreciated by me But it's also very beneficial for the channel as well, and if it is your first time checking that channel Thank you very much for stopping by So here we go. Let's jump straight in. So the first part we're going to do is a search So we're going to take the value what we've got in our report sheet And we're then going to use that to search our customer list to pick out all the values that match our In criteria that were invented So what does it start off with is I'll just put in here some initial initial initial initials So two characters that could be the part of our search So we want to look for a customer and so far we're putting be so we want to pull back all the customers that have be within their name So back in the master data in our validation prep we can start entering our formula So we're going to do equal search and We'll open brackets and the first thing we need to do is obviously search for that value So I was going to go back into that into that customer sheet. So for us, it's report B a Once I go back into the master data, let's get rid of that I don't need to select our customer table So that is just column a and as you know if you hover at the top of that column of a table You'll get this downward arrow select that and then obviously will select the column within the table Close brackets Don't need to enter anything else here hit enter and you can see because we're using the new dynamic arrays in office 365 So you need to have office 365 for this to be working for you You can see it's done a spilled range and what that basically means is it's gone through each of those Values in our list so you can see each one of these values at the moment corresponds with that name in that row And we've got some options here So we've got the value error if obviously those initials or that be was not found within the name But where it is found so Bell he see row 27 It's the first it's returned number one and what that means is that search term is appeared in the first character of That name for Sasha Bell one just below what is very well placed to give the example You can see it's given number seven because the bee doesn't happen until character number seven and so on and so For for all of our options available there So we want to now just sort of finally tune this so we're going to turn try and rather than have numbers and the error We want to have this into a simple true or false in order to do that We can just use our yes is number function So I'm just going to revert to our function atop it and type in is number Open our brackets and then we just need to enter another closed bracket at the end there Enter and you can see it spilled and updated that for all of those values So what we now have in each corresponding row is a true or false value to tell us if our search value The bee will have done so far is present in that row or in that customer name being more specific So that's great But we want to now build on this one more step because it's great as it is to have the true or false All we really want is the list of names that our search is applicable to So we only want the list of names that have the initials B and E in them in order to do that We can use our new filter function So you might have seen this already on our channel in previous videos But if you haven't we'll quickly go on to it now and you'll get a brief idea of how that works So again another little amendment to our formula top in and I should have said at the beginning I was going to be building this out gradually but we kind of built it from the inside out So you can hopefully get a better understanding of how the function is working So what we need to do now is use our filter. So we'll type in filter open brackets So what is our rate? So we want to get this is our array the customer name So it's had to select that table one more time and this is the rate This is the array or the range of names that we want to filter and The next part for include so this is going to well This is where you'd have to put some logic in to determine what names you want But by default what's going to do here for us is it's going to pull through only the names that meet the true in our second Piece of criteria for that is number So that's where I can perfectly well for us as it is so we don't need to do anything there All we need to do is jump to the end and where it says if empty if I was to add that comma there And this is simply if there's no value there or we can't get a matching value What do we want to return? We want to return not found So this is predominantly only come up is if we entered a string or initials into our report and There was no names that had those values within them And we get this message pop up that said not found so we know there's there's no values in there for us or matching our criteria Once you hit enter you can now see you've got a list of names there what match off such criteria So we've kind of achieved what we've initially set up to do if I was to go into our report game And let's say let's select some different names. So let's even just say s Just a letter s go back to master data Quirky's a few that you but you can see how it's updated Maybe I'll just do another one just to try and get a better idea CL Yeah, there you go. So you can see again. It's updated So it's now only shown as the names will have the characters of CL in them as a as a joint together So from this information we've got already we could actually now go and do our drop-down list And all to do that. We're just going to use data validation So we can go into our data tab and go into data validation We want to show a list because we want the list of obviously the names and then our source is going to be If I just select that go to master data, it's going to be this first one here. So f2 for us as you see So what we're going to need to use here is the new dynamic Syntax for spilled ranges and what that is simply is the hashtag So what this means is our data validation will first reference master data f2 So obviously this one here what says Cameron in it at the moment But by using the hashtag it will just spill to whatever that range is so we can see the number of Names here at the moment. So it's going to just incorporate all of those names into our list for us once you do, okay You can see that we've now got a drop-down list that gives us all of these options in here Well, every single name One change that we do need to make I think when I quickly jump in and start showing the search aspect So if we were to put CL You'll see that we'll get an error message So this is not ideal because we want to type in a search string and to return all of the matching names in our list So therefore we need to make one little change to our data validation to allow us to do that Let's just go cancel We return back into data validation and You can see what we're into here so far, but we just need to go into this error alert tab And we're going to just untick this show error alert after invalid data is entered So basically the reason we're getting an error is because CL was not a value in our list But because we want to use it search criteria, we just need to untick this just so it's going to allow us to do that in the first place So if we do okay By default our list is going to show us every single name that we have in our list There's quite a few of them But if we were to enter initials CL and then do our drop-down list We'll only see the names that are applicable to that search and likewise the first ones we use I think would be E You'll now see only those that match them work be E So that is how you create a dynamic searchable drop-down list in Well, I'll say the word dynamic. Let's just make this a bit shorter That is how you can create a searchable drop-down list in Excel in using Office 365 The only problem with that is you're limited in the sense that it's only going to be available for just that one drop-down list But what we want is we want to have a drop-down list for each one of these cells here So what is the solution to allow us to do that? Well firstly when we go into our master data, we need to do a quick change here because in essence what we need is We need this spilled range of obviously the search names for each row of our customer names So let's just make that a bit easier. So in our customer range, we've got one two three four five six seven Thirty so we have 13 potential drop-downs here. So we need to have 13 of these validation preps so that there is one validation prep for each customer row and I hope that makes sense, but if it doesn't then hopefully it will as we move through this example here now In order to do that we We obviously need to have like say we need to have one each But we can't just copy and paste a validation beneath each one of these Else we'll have a problem of spilled ranges. We'll be spinning into one another So what we need to do is rather than have this in a column format Going down horizontally We know going vertically. Sorry. We need to change it into a horizontal spilled list So it goes across here. So then we're able to create each one of these for each row In order to do so we can just update our formula here to include transpose So for those who don't know transpose will take Some information like this we're having the column format and it will transform it into a row format And you'll see as soon as I enter it in here. So all we need to do is just go transpose here Open our brackets and just enter closed bracket at the end there And you can see now rather than this spinning down Vertically get it right this time. It's ours going to spill horizontally for us And having just done that I can notice that our data is not in alphabetical order So let's just make that one change as well. So just inside of transpose. I want to do sort Open brackets and then just enter another closed bracket for us at the end here And you can see we're now got a more presentable format here that we can see them in alphabetical order What just makes that a lot better just when working with data anyway, really Now that we're done that we're able to actually copy this down for each of our rows So we had 13 customer rows in total. So all I'm going to do is drag this down two three four five Something like that So what we've got we've got reference b8 it was so we want down to b20 I'm going to try to look it up then a few two many four three two one There we go b20 so you can now see we've got a Validation list for each of our rows and our data For that first one we've got the initials be you can see our list has already been formatted for us So we've got these five names here But because all of our other drop-down lists are currently empty That's why we're able to now see the full extent of our customer list in this transposed list So having done this we've built all the back-end data that we need So we can jump into our report sheet one more time and show you how we can now do this drop-down list to reference those cells We need to make one quick change. So if we're going to data validation once again Into our settings So at the moment, obviously it's fixed on this range of f2 with this build hashtag there We just need to remove these dollar signs. So obviously it's not fixed and we can copy that down and let's go Okay And then now all we need to do is control c on that current drop-down Go down as the far as we need to go in our customer range We're going to pay special Validation select okay And now when we go into these lists, we should be able to see what we have so perfectly at first We've got the lists that contain all of our names If we were to go and type in here cl And then do our drop-down You can see how it's now filtered to those and let's go to one random ones go around 13 and let's go uh d a You can see that how this is now updated for all those applicable to initials of d a And some of them at first might know why I might get in da because you might expect to see david or damien But obviously you can see the da is at the end or throughout this text here as well If I was just to change just to put maybe david And Ah another good example here no david's on this and that's why we then see this value of not found So a great demonstration an act or anything actually showed how to do that And so we now got names available to us so we can go through and select these either Just like this if we want or we can start typing and we'll pick out those only applicable to those as well So one last thing because we have got the company uh column on here as well How can we pull through the applicable comp company for all these names? So let's just actually put some names in here just so it actually does look right Um get rid of david and we'll put in here abram So we want to pull in this the corresponding company for this individual Very simply we're going to use another new new function. Uh, if you weren't aware of it, it's called v Not v. Lookup. Uh, it replaces you can say v. Lookup. Uh, but this is called x. Lookup So it's sort of more and better improved. Do I say, uh, but obviously I leave you to decide that But anyway, we'll be using x. Lookup. All we need to do is enter x. Lookup Open our brackets. So the first thing you do is enter our lookup array, which obviously is our custom name here We want to look up the customer name in our column our customer column So it was just going to be that one there We want to return a value from column b, which is the company column And at the end here, if not found we're just going to show it return a blank because in theory we could be still Populating at it in our data. So we don't want to start trying to pull through things Pull through errors or whatever if um, we're still busy trying to type the information in the first place If you haven't used x. Lookup before There you go. There's a summary on the page basically how to use it and the criteria you need As you will see it's a lot simpler than the v. Lookup function But we have done another video that looks the x. Lookup in depth So if you want to check that out by all means check out our page on youtube You'll find that tutorial and that'd be hopefully give you the insight you need to learn about x. Lookup Once you've done that enter You can see it's now called that company through for us and we'll just copy this down All those rows Like so and you can see it's only populated there So if we now go and do select a code customer from here and let's use our new search criteria s So I think of ones I haven't used um s a Here we go Sasha bell you can see it's now going to pull for that company for us as well So a little bonus on there as well in addition to looking at the searchable drop-down list So I hope you enjoyed that video And it would give you the insight of one how to use a searchable drop-down list in xl And also how to extend that so that you can have multiple searchable drop-down lists within the same report If you did enjoy that video, please do give the video a like as I said the beginning of video I greatly appreciate it because it shows me the content that you'd like to potentially see more of And it also does help that all important youtube algorithm If it's the first time to channel or if you repeat viewer, please do subscribe to the channel And do make sure you hit that bell notification button so you're notified of our future videos Thank you very much for watching and I'll see you in the next video. Oh and one last thing before I go Links to this document that you have been working on throughout this tutorial that can be downloaded by the link in the description for this video So I think that's everything. Uh, thank you very much once again. And yeah, we'll see you in the next video Before you go, don't forget to check out the other videos on our channel You'll see everything from other functions and formulas through to tips and tricks We've also created some playlists so you can see these categorized together So make sure you check those out and get all those useful information And obviously as always, don't forget to subscribe and hit that bell notification button