Okay, right, it's been far too long since we sat down and had this chat and there's a reason for that is name one being, I've been extremely busy. The golfing season is well and truly kicked off but also lots of things have been happening and I'm pleased to say that they're all very positive things and the majority is all down to obviously the support of the channel from you people who watch every day of insane this for quite some time. Anything that positive that happens to me or the channel or if you wanna word it is basically down to the support I get from the people who watch. So I'll start up with a thank you and probably finish with one as well. But this is what we're gonna have a look at. First of all, I wanna talk about the Taggers Target Board. I'm gonna scan across now. As you can see, the names have increased. They just keep on coming in and doing my very best to keep on top of it. If you have a look at its board, if your name is not on there and it should be, then stick it back down in the comments below. I apologize if I've missed you but there's a great video to catch up on anything that I've missed because the problem I'm having there's info coming on via Twitter, from Instagram, on different videos. So I am struggling. I think I'm pretty much there. I might have missed out the other one or two people but in the main it's been absolutely brilliant. But what you'll also notice is the amount of white, tip X that is on the board and some red numbers which basically means people have been cut. It's acting as a huge inspiration and I clearly take full responsibility for all handicap reductions over the last three or four weeks. I can't say and be said for anybody that's actually gone up in the handicaps. So I'm only taking credit for positivity but I'm gonna read some names out very, very quickly. Otherwise we could be here for a while. The movers in the last couple of weeks since we last did this video. Bill Diaz, Brian Treadwell, Dave Richard, Dave Strings. Dave Strings, I can't amend your handicaps because I've lost the details of what it should be amended to. So can you stick it down in the comments below. Alan Jordan, Beaty at Home, John Stuart, Unreal down to 2.4 John Stuart, Keith Pudney, Grumpy golfer, Lee Boyd, Wayne, Martin Short, Tony Penny, Brooks Crabb, Crabb, hmmm. Brooks Crabb, Usanos. Oh my God, that bit right. Colin Bennett, Trotter 1966, Kay Sheil, Gary Callaghan, Paul Bear, Eddie Latiac, Friday Bass, these names obviously come from some names that come from Twitter and what have you. Don V, Garth Oliver, Carl Brady, Steve Holiday, Kutter Gain, Chris Berry again, Unreal knock here, the other week, Gross of 66 to come down to 4.8 and lower my handicap again, has also had a reduction. So well done to everybody who has managed and achieved a reduction. Keep on going, you're doing far better than I am because I am not budging if anything I've crept up slightly the wrong way but we don't talk about negativity on this channel. Anyway, next thing moving on very, very quickly. If you've watched the last two videos you'll have noticed I am wearing a certain brand of clothing and it is Bunker Mentality. And I will be wearing their clothing for the next, certainly for the next three months we've had a little bit of a chat, we've agreed that's what I'll do for all the videos and then we'll see where it leads from there. Give you a background on it very, very quickly. Over the last probably six months or so, a couple of companies that were really interested in the potential of wearing their clothing on videos, which was brilliant, but there were certain things I never ever wanted a brand that had an interesting golf clubs I never wanted any conflict whatsoever because I love this idea of remaining completely independent on the club reviews. So again, Bunker Mentality ticked that box they just make clothing, head to toe clothing apart from shoes, so it's literally trousers, belts, caps, t-shirts for off the course. What do you call these things? Mid layers, jumpers, whatever you wanna call them. Polo shirts, it is a real good, solid range of product. I'm gonna stand here like a salesman, but I do wanna show my appreciation for their support. Once again, this is down to you lot following the channel. But the thing I will say, honestly, is that I would never wear anybody's clothing or promote any kind of product that I didn't fully believe in personally. So the first thing for me is I had to like the product, I had to believe in it and I had to be confident in it. And like I said, honestly, be prepared to wear it. I would not go out looking and absolutely in my opinion anyway, in anyone's clothing unless it looked right. And I'm more than happy, I love it. The only thing I would say is I would literally go out and buy this and wear this clothing. It is really nice golf gear, real attention to detail. Fabrics are really good for golf. And honestly, I can't speak out enough what I've seen so far. I've spread a few across the garments, across the back of what they've sent in so far. And you'll see, like I said, I'll be wearing this on the videos moving forward for the foreseeable future. So yeah, really pleased with that. We'll still be doing mixed in with the average golfers stuff. So you'll still see the caps and the hoodies and all the rest of it. We'll still be doing all that in the videos as well, mixed in with this bunker mentality. Right, stop for breath because I'm rather excitable at the minute. Man vs Golf videos, I'm loving doing them. I hope you enjoy watching them. Got a little bit excited about a bunker shot a few weeks ago which was a great way to finish a video. Not always gonna end on such a high. The recent one was equally as enjoyable for me to film but not quite such an epic ending. More than planned through the summer but some real big ones planned in the upcoming weeks. And that is because realistically two major things on the horizon. In a week or so time, 10 days time, I will be doing Man vs Golf hold challenge at the Belfry. Now, the Belfry, the three holes that I will choose are then gonna be the sixth, the 10th and the 18. 10th and the 18 are very obvious because of their iconic status in world golf and mainly for historic reasons in the Ryder Cup. There's been some real drama on 10 and 18. Most people will know the Belfry for those two holes. I've played there a few times over the years. It's changed hands a few times over recent years and as I understand, there's a lot of money in it at the moment. The course is supposed to be in very, very good condition. But like I said, it's an iconic Man vs Golf hold challenge and I cannot wait to play that. And hopefully we'll get a good video out from there and you never know, might chip in from a bunker. Although I doubt it very much. Next is I've been working with a company, a tour operator in Ireland called Lynchpin Tours. Big thank you to Lowell Courtney if he's watching this video and if you're interested in planning any trips to Ireland, he's the perfect company to deal with bespoke trips, knows everybody and anyone over in Ireland and he's helped me out big time in organizing what he's gonna be.  I spoke to him when he'd gone back a couple of weeks ago at the idea of where I would like to have gone and basically the gist of it is this. Upcoming in Ireland is the Irish Open and that's in July. That's what a course called Bali Liffing. There's two courses there, the old course and Glashidi Lynx. Glashidi Lynx has got the Irish Open in July and I will be going to play Glashidi Lynx. I've played it before, played it a few years ago, four years ago. Looking forward to going back. It'll be at a time when I would imagine grandstands are all people playing off mats maybe so it'll be in pristine condition and I can't wait to experience that. And the other course that is really well known and I cannot wait to get to is Royal Port Rush. And I can't wait to play there. It's got the Open next year so it's the Open venue for 2019. Four years ago on my last trip to Northern Ireland, I had to stay in a hotel which overlapped Royal Port Rush and unfortunately I couldn't get on that course and I had to stay for four days looking at that golf course just wanting the opportunity to get on and I promised one day I would go back and I'm back in. Well, it's week commencing the 11th of June. I'm in Ireland for a week but apart from those two courses, I'll also be at County Sligo, which is Ross's point. I'm at Ardglass, which is over in Belfast and I am at, what's your, I'm at the again, can't believe I didn't even got that one, Castle Rock, which is just, it's not reopened as such but they've just done some major works of Castle Rock and again, not of course I've played before but it's honestly, those courses are five courses that I would literally give a right arm to play and I'm gonna play them. I'm not gonna give me right arm them and I just, I can't believe the trip's been pulled together in a matter of weeks. Came out of nowhere, like I said, massive thank you to Lyle Courtney and yeah, Ireland is a place, I'm my surname is Sullivan for those of you who don't know so I have Irish descent from many, many years ago. My family originated from there so I love Ireland for a number of different reasons. I love it for Guinness as well because I do like a drop of Guinness. I love it for everything that goes on in a place but I love Link's Golf. Link's Golf in Ireland with Guinness, it just doesn't get any better than that. I cannot wait to go and I cannot wait. I'll be doing, hopefully fingers crossed, I don't know about timings to film certain things because like I said, it's, I've got access to these courses. They know I'm going to film, whether or not I can get in man versus golf all challenges, I really hope I can because they again will be unreal. I can't wait to do the Bali Liffon in particular and the Port Rush ones because I wanna give you a real feel for what we're gonna be watching or a lot of us will be watching in a month's time at Bali Liffon and certainly in a year's time at Royal Port Rush and the history and all the rest of it behind it. I can't wait. Like I said, I'm gonna end it there. It's more of an update video. It's more about me telling you that things are going particularly well at the moment. I don't like to, I'm not gloating. I hope it doesn't come across that way. I just really am excited about what's going on but I'm always grateful and I'm always real. I always realized that like I said, these opportunities come because you people are watching and supporting the channel. So, honestly, I really do appreciate it. Thank you. So, what we need to keep on doing, we've got Taggers Target Board. Keep on giving me all the information from that. Let's see if we can keep that growing. Keep on commenting on videos. Keep on liking videos. Stay subscribed to videos. And that's all I can ask and offer my genuine appreciation. Right, keep an eye out for some videos. I'm looking down here. I'm just about to put out a video with a tailor-made Haito wedge. I've got a tailor-made two-iron, the UDI, driving iron video coming out. And if you haven't caught up on M-Man vs. Golf Force, then please go to watch. Other than that, I will see you very, very soon on Teoplo TV and that's me done.


This paper reviews recent advances in energy storage technology, focusing on the use of two-dimensional, 2D, materials such as graphene and transition metal di-calcogenites, TMDCs. These materials offer unique advantages over traditional three-dimensional, 3D, materials due to their high surface area and exceptional electrical conductivity. Hybridization of 2D materials with other low-dimensional materials can further enhance the performance of energy storage devices by taking advantage of the synergy between different materials. Additionally, strategies for creating face-to-face, face-to-line, and face-to-face heterojunctions are discussed, along with a design approach for combining 2D materials with other quantum materials to create efficient and long-lasting energy storage systems. This article was authored by Monica Sharma, Pulacol M. Ajyan, and FreedomDeb. We are article.tv. Links in the description below.


Hi there, welcome back to my YouTube channel. This is Daniel Rossell here and I'm in good good form today because I have just finished setting up My home networking dream setup that I've been trying to really get right for the last couple of weeks now I have had a backup slash failover internet system running for a couple of weeks The problem is that it wasn't really what I intended to do the cellular router. I bought from TP link I only discovered after purchasing doesn't support bridging mode so you can't just take a Cellular the cellular connectivity coming from it and put that into something like a load balancing router now I did a bit of digging through the TP link forums and played around with it and eventually figured out a way to do that That does work and that works in such a way that we can get the connection into the load balancer So the purpose of this uh video and these blog posts I wrote today is just to explain to anybody else Who's looking to do this how I got everything working finally? um And yeah, I mean I basically got cellular internet because my isp connectivity Was kind of rocky it would go down a lot like almost every day And I figured anyway, it's something I really always wanted to have this kind of idea of backup or failover internet Um something if you're working from home, you're running a business from home Two people running a business from home having some kind of backup internet connectivity If cellular is cheap now where I'm based in the world I can get a data only 4g plan for like nine dollars per month So cellular is pretty cheap So I feel like if it's that kind of a cost and you can justify it because you work from home I think something like this is really worth doing Um, so without more ado or further ado, let me just I just put together this presentation And this is a bit old school, but it's the quickest way I can think of of like narrating What I've done and how I got the components working So, um, my objective basically was reducing down downtime because my isp was unreliable And I wanted to get a cellular connectivity in place to have automatic failover now something I Sort of question I put into my blog is well Why couldn't you just use a hotspot or use a my fi and the answer is basically that This is many advantages the way I've networked this Um, it provides that backup connectivity for every single device in the house Including the wired devices including the wireless devices. This also happens automatically So you don't need to jump on to a cellular network and jump back to a Your primary network this will the load balancer will will handle absolutely all of this automatically So I think that's a lot better. Secondly stuff like using a hotspot I used to do it before I built out the system and it's just awkward. You need to use your phone What if your phone's out of battery? Everybody's jumping on and off the hotspot? So this is a much more robust solution if you need something of this nature So that was the objective the problem So the problem that I ran into was that after I bought the TP link cellular router As I said, I discovered it doesn't do bridging now. Um, there are LTE 4g cellular even 5g routers on the market that will do bridging So one option would have been to just buy one of those I don't want to do that because what can I say I'm building this out on a budget and I just spent 120 bucks on hardware So I figured with a bit of time and effort I could figure out a way to get it to work and I did now there's actually one more advantage to Keeping your cellular network and your main network separate and I'll get to that at the end of this presentation But that's something called bonding so Bonding load balancing and failover are three different concepts bonding is this is this kind of cool idea actually of Let's take all the internet connections we can get let's aggregate the connection speeds and let's give us one really Fast internet that's also got failover built into it. The problem with bonding is that it's not easy You need to have hardware on the isp side and you need to have the hardware on your side There's a project called open mptc, but you also need a vps. So If you have if you're going to do it like this and keep your cellular router running and keep your Load balancer running. Well, there's actually something clever You could do which is running a wi-fi network off that 3g router or even running ethernet off it Putting that as well as a load balancing router Into your computer if you have a network interface card With two ethernet ports you could do this very easily or just use wi-fi and ethernet And you could use a program like speedify to bond your cellular connection With your failover connection while the same cellular cellular connection is also Providing automatic failover. So that's one reason I can just think of and I wanted to Highlight for why you might want to do it in this manner. Um, also just kind of philosophically Part of me says it's better to just have one piece of hardware that does everything It'll do your 4g modem. It'll do your Dual wan it'll do it'll do your everything else you might need Part of me also says well for troubleshooting it might be easier to build it piece by piece So the solution as I said is you could just buy an LTE Cellular router that does bridging or you could play around with the TP link one, which is what I did So here's what I did basically. I firstly disabled the wi-fi And in contradiction to what I just said Um, I did that because if you don't want to do bonding on the network as well Well, there's no point having the wi-fi Using the wi-fi coming off that cellular network, right because If you put an access point at the other side of the load balancer You're going to be you can put out a wi-fi network that has the Automatic failover slash backup built into it. So therefore there's no advantage to having a wi-fi Network upstream of load balancing. So disabled the wi-fi network now here's Here was the breakthrough thanks to kevin and the TP link forums And that was basically I just needed to assign an IP address now to people who are really internet working This might seem like well, obviously to me. I'm just learning this. So it was like Oh, wow, this finally works. So all I had to do was basically check The IP range from the load balancer and assign an IP address To the cellular router that was within that range And then do static routing now. They did say that you're supposed to disable the DHCP Um, I didn't actually do that and it still works the problem I get whenever I take down a DHCP server is that I find it very hard to get into the device So when I took that down I couldn't get into the cellular and why would you want to get into it just to check everything's working Maybe change a few settings. So at the risk of maybe making the network less stable I decided to keep the DHCP server up and But it is it is running So I'm just showing the screenshots of sort of what I did to make this work This is as you can see, this is the load balancer its web interface and it shows The the DHCP server page shows where the IP addresses start and where they end And I just picked a random number that wasn't in use by something That had a reserved address. So I said 103 Or I can't remember if it was 103 or 105 or 107, but whatever it was I just picked a number at random In that range and I Gave that address to the cellular router. So then when I went into the cellular router, I put in that IP address Now if you turn off the DHCP server, you'll still have the option to configure manually the IP address And again, just make sure this is done in coordination And now what you can actually do is give the load balancer an address reservation From the cellular router. I'm not sure if that's the correct way to do it That's what I ended up doing. So give the load balancer the reservation from the cellular router And not vice versa because that address reservation system in the load balancer is for reserving Is for binding MAC addresses to LAN local local IP addresses So as I just mentioned static IP assignment and that's basically it. So I have now my ISP router And I have my cellular router both products are from TP-Link They're both going into the load balancer the load balancer is then going into I mean, this is just one more layer of complication But if you're already building out this setup, uh, what's one more piece of gear, right? So the final thing I have is a router from TP-Link that's running as an access point only And its only job is to put out a Wi-Fi network from the load balancer that has the benefit of this backup built into it So all in all besides my ISP router. I have the Cellular router the load balancer and the AP so three more pieces of hardware that weren't on my network before and as I said If you are prepared to spend More money like five or six hundred dollars or a thousand dollars You could definitely find yourself a more advanced load balancer that would be able to give out a Wi-Fi network and that would cut your Hardware down a bit, but again There are things you can do if you separate out the hardware So you might want to put the access point 10 meters over that way Well, if you have it just at the end of the load balancer just run along ethernet cable If the Wi-Fi is in the load balancer either you need to get the load balancer to a place that you want to put a Wi-Fi from Or you've just you or you have Wi-Fi in it for no reason because you're using the AP anyway So that's what i'm saying about sort of separating components seems like a lot of work But maybe there are there are there are definitely some advantages I can think of so the fail over now is really really quick if I pull out the ethernet from the ISP network in the load balancer I fail over to cellular Pretty much instantaneously. I called it here under two seconds By contrast in my first setup when I had ISP Running into the cellular router and the cellular router was running in three four g backup mode This is the tp link tlm or 100 and when it was responsible for failover That failover took about 20 to 30 seconds and the reason i'm guessing is that well the 3g connection probably isn't live Until it's required. So it has to firstly detect failover Firstly detect failure on one one on the ISP Then it has to bring up that cellular line Then it needs to switch over Then it needs to switch back whereas if you're using the load balancer for this My theory or my guess work is that well everything's always online And all the load balancer has to do is say well, that's not working Let's pull from this and that process can happen very very quickly. So um, I also created a Load balancing rule here and you can see what the rule is. It's pretty simple Um to find this in the tp link r470t Just go into load balancing under transmission and click into link backup on my rules Just well if one one is down one one being the ISP internet go over to one two Which is the cellular router and it automatically brings it back and I've tested this and it works beautifully So here's the setup I've been describing in diagram format I have my ISP router running as a bridge or it should be running as a bridge I should say sometimes you can change that why keep the ISP router at all Well, sometimes you need to keep it for to get support from the ISP So sometimes I think it's useful in my case The modem is hard to find in a load balancer vdsl2. So that's another reason you just want to say well At least I know this piece of hardware. We're bringing the ISP's internet So let's just keep that in place and add stuff afterwards Or you can be a bit more aggressive and say let's try to get that modem and let's find the load balancer That has that modem and the wi-fi and then I've only got one box to worry about Um, but this is the way I've done it ISP and cellular router. They're both going into the load balancer From the load balancer. We're networking the whole house So there's an ethernet switch bringing ethernet to everything that's wired from the nas to the computer I'm recording this on to another networking switch everything And there is an access point a router running an access point Bringing wireless all over the house as well wireless printers wireless phone devices, whatever My my my heart will always lie with ethernet connectivity So that's the diagram and this is the diagram with the actual Examples of the TP-Link gear plotted on it Cellular router is something like the MTL MR100 or you could use the MR6400 something a bit fancier Bringing that in to the load balancer That box the r470t there's also the r480t Now I have to point out that my home internet's pretty slow It's VDSL if you have something like fiber optic internet You're naturally going to want to get a better load balancer that has ports with enough throughput. So like Gigabit ports right so Choose your load balancer based on What your connectivity is and what your speeds are and then pick something that won't create a bottleneck because if you've got A 300 megabit per second connection Wired into a load balancer that can only take in or give out 100 Then for no reason you've just lost two thirds of your network speed So that's a concern there and then um running out a As I said the wi-fi so that's just kind of showing you the gear And tidy it up as you as you can now here here's my final sort of idea That I mentioned I don't know if this if this would actually work I haven't tried it out yet But what you what I suspect you could do is run off some ethernet from that cellular router It's already going into the load balancer, but run out another LAN port So again up for up for something a bit better than the TL MR 100 Go for something with a few LAN ports take another ethernet um from Well, I've done it from the From the archer demonstrating doing this by wi-fi, but let's say you had a few Ethernet ports on your computer and you could Plug in two incoming ethernet So in that case take it off the load balancer Then run speedify on your computer and then what I think would work would be you'd be able to actually bond the connectivity from cellular and the load balancer and Everybody else so you'd have bonding and failover everybody else on the network would just have bonding unless they wanted to do the same thing With speedify that's just kind of taking it to the next level But the truth is I've come to the conclusion that for my networking needs. I don't really need very fast internet I just need internet that doesn't go down like every single day So high availability is what I think my use case is best described as and for that I'm happy enough just to have the load balancer automatically swapping over in the event of failover and keeping the internet up Throughout uh throughout the place and this is just kind of what it looks like This is the start of the network with the isp writer the load balancer and the cellular going into it And just a couple more suggestions. Well, if you're going to all this trouble Put your networking gear on a ups so that in tiny power outages Doesn't bring the whole stack crashing down and the final thing I recommend is uh, if you if you are going for a cellular 4g that has External antennas, so if you have a load balancer that only takes a plug-in device unless that plug-in gadget has Check the specs, but if you have external antenna support You may want to put your antenna on the roof Or put it outside and therefore bring in better quality 4g and that'll just mean that in the event you do fail over to cellular Your cellular is going to be As good as possible now just a quick a couple of examples of well Here is as I said something you could do to make this a bit easier You could get yourself something like one of the dreitech lte routers Some of these guys have a vds l2 modem in them Um, but most of the the newer ones have gigabit ports So you could run really fast internet Into one one you could run Uh cellular off a usb modem that's compatible with the dreitech Um, you could keep your isps router or your fiber optic to ethernet adapter and just put those in And that'll also give you out your wi-fi network. So Something like this would simplify the setup a bit Um, but um, it's going to cost you these are expensive gadgets for Uh business networking really so uh, and I'm just just showing that thing in the spec that has a five It has two dual band wi-fi connectivity So I hope this video has been useful and not too too much info I mean I've been playing around with this networking setup for a couple of weeks now trying out different things and I was just frustrated because I knew I could figure out some way to get these two appliances Into the load balancer and I think that's just the better way to do this because You've got one sort of specialist piece of hardware Whose job it is to balance connections and to do stuff like load balancing I'm not even doing load balancing, but you could also set that up Um, that it's a it's a piece of gear that's designed to take in multiple one connections Do stuff like failover do stuff like load balancing put out connections to the local area network And I think it's better than relying on a functionality In let's say the cellular Rider that would have oh it can do failover back and forth between a cellular line and an isp line But it's not really what it's intended for and the uh difference in time of failover between two Seconds and 30 seconds is very noticeable So, um, hope that video was interesting If you'd like to get more videos from me on all subjects related to technology home networking Linux and a whole bunch of other stuff Please feel free to subscribe to this youtube channel. Thank you very much for watching


Hello everyone and welcome back to another tutorial in this video We're going to be looking at the new Excel filter function that we have available to us The real benefit of using this and I've wanted as I'm going to say it surpasses the V lookup But it doesn't but to give an example with women using the V lookup function obviously our purpose of using that is we have a particular Value that or variable that we want to search for in a table and return another piece of information So an example of that could be As you see an example got in the table if we wanted to see okay What was the expenses for London? We could obviously have our value of London and we might want to V lookup this range Just these four cells in this poor example to return obviously what the expense number was But V lookup as we know only will only return one Value or one piece of information But what if as per our example we're going to be looking at we want to return every example that matches our criteria So that being again sticking with London. We can see that we wouldn't want to just return In the scenario of wanting to return multiple All those that match sorry In our example of London we can see that we've got a match for the finance one for human resources and one for sales So you can see there's actually three pieces of information that we want to return and that is where the filter function Enables us to do just that so what we're going to do is just drop down dive straight in really We've got the since the syntax at the top here so we can see what this filter function looks like Very simply we need to do is enter the word filter and then we've got three parts to enter Firstly we'll look at the first two just the most important the array and the include and also it gives us a bit of error Handling could say by giving an option what to do if empty, but I'll get to that in a second So all we need to do first thing with staff by putting a drop down in the city You could just type in our values or our cities as required But we want to obviously be very you know accurate and make sure that there's going to be no mistake with the encrypt Spelling or a wrong city entered so all we're going to do here is go into Do a quick drop down so let's just go and do data data validation And we'll do a quick list Our source is going to be these first five values here because that is the total of our cities do okay You can see we're now got a drop down in there. Well, it's perfect So now to enter our formula, so we're going to go down drop down one below Where we've obviously got the city added there with our drop down and all we need to type into here is equals filter Open our brackets and then we dive straight in so the first part is our array So we just want to select the entirety of our table So that's as we selected here So we've got the department the city and the expenses columns all included The next part is our include so what is what do we basically want to filter? So for that all we need to do is select the city column because we want to filter the city column for only the city We're interested in and we're then going to do the equal symbol and we're then going to select the The reference here of g8 for us. What is where we've got our drop down for city and having done that It's going to do brackets and here enter and you can see initially It's given us a calc error because obviously we haven't provided the city But soon as we select a city so go for London you can see that the formula actually expands out for us So you can see rather than just being in this one cell. It's actually Done exactly that it's expanded and put it in as many spaces as required So to give another example if we were to try and change Cambridge over here Let's say that's London as well. You can see that it's picked up as an additional one as well So we'll add it in there, but I'm just going to change this back to Cambridge And you can see it's got back to our three The formatting will not carry across so all we just need to do is make sure that We do copy that across for as many rows as we require So I'm just going to literally just do that whole column just depending on how much data we pull across But there you go. That is the the formula basically in this entirety If I do just remove this piece of data validation. So let's go to data and let's go validation And just go clear all Okay, so if I was to put in here a city that doesn't exist in our list So I think I'll get an example. I thought it was Bristol. So go to Bristol and enter You can see we get that calc error and we'll get exactly the same if this is left blank So how do we deal with that? Well the benefit we have is the third and final piece of our syntax We can see is this optional one of if empty So what that means is if you've done the filter as required, but there's actually no matching variables What do we want to return and simply for us or we're going to do that third part is in quotes put Not found so you could put anything you want in there You could maybe even reference another value through a formula do anything that meets your particular criteria But for us we're going to put in there the text of not found We're going to enter you can see that not found so basically there's a blank here So it's obviously not going to find that if I was to put a Bristol so incorrect city or one that's not in our list Again, it's going to get not found, but if I was to instead put a value we know exists So what kind of there you can see that we've we've now returned those values correctly as required So I think that comes off quite well how to use the filter function And as mentioned you don't need to be limited to just three examples We've got here. You can obviously do as many as you need The next example that I have I'm going to scroll down to is exactly the same table But allows me just to elaborate on just a couple of maybe a better way of working What I've done here is if I go into the data I've converted this into a table and you can see that where I forget the home tab here You can see although you can't see it as one and I'm going to jump ahead to get something I didn't want to do so if you're not familiar with what you can see the table design tab actually popped up there If I click away and go into our data You can see we now have a table design and you can see I've named this table expensive If you're not sure how to insert a table all you need to do is just select all of your data Simply go into the insert tab and obviously I can't at the moment But if I go to this above example Honour all that data insert tab go to table you'll get this pop up Just make sure you've got the my table has headers ticked as long as you obviously selected the headers hit ok And then it'll come create it as a table for you by default. It'll do it's default blue Formatting on the cells But we need to do is just go into the formatting options that you can find if you go into table options The table styles so I think by default it'll do maybe this blue one or something similar to it But I've just gone on to the no format just I just prefer the format for this example But that's how they get a table in there if you haven't done already So for this example rather than obviously referencing an actual range as we did up here and just to remind you obviously You can see we reference that whole range there All we now need to do is just go into Do another filter function and sorry the port the reason I put a table in there is to show you that in this filter function We can actually reference a table rather than just a given array So for us how we need to do that now is I'm just going to put in here another city. So let's go to Edinburgh And what I could do as well is just change this and put back our piece of data validation So we've got a drop-down because it's just again better ways of working. It's good way just think to always remember Okay, so you can see we've got those drops downs now available to us So in this time, I'm going to go into equals filter and over our function go into our variables So this time for the array rather than select this range When you've got a table in there all you need to do is if you hover over the top left hand corner Just yeah, literally the top left hand corner of the first cell that contains your head You can see you get this this dark Slightly obviously different angled arrow Once you get that if you just click you can see it will select the whole table for you And you can see it's done exactly just that and populated it into our function for us So we've just got the word expenses. What is the table reference? If I now do a comma to move into the include section So again for this because we want to do a filter on the city column We don't need to select that range All we need to do is hover over city and you can see that you get this other side down It's down with our own app the thicker one. So if I just select that you can see it's gonna say okay The expenses table in brackets city column and this time always then carry on doing to our equals Select our drop down. So when obviously the city column is equal to our drop down of Cambridge in this example And then because we know how it works We're gonna do comma comma and in a third and far apart We're gonna put them up found if we see there is a value that's entered that is not present in our table All terms for the effect drop down is left blank It's blank, hit enter and then you can see obviously we've got our values as you would expect Let's just copy the formatting of this down So let's go into this one here that matters Copy that down for the whole length Perfect. So yeah, so you see if I obviously clear the drop down. It's gonna give not found But let's go back into another one. Let's go bombing him so you can see it's pulled all those values through for us The real benefit of obviously using this table is it allows us to Stay dynamic So with this first example if we wanted to start adding more pieces of information at the bottom here So if I was to do another one for Cardiff, so let's think of another department IT Cardiff And let's say we've got revenue of 10,000 copy the formatting You can see that nothing's happened because in order for me to Or in order for this new piece of information to filter into this The format up here. We'd first need to go into the filter And then we need to drag down all of these ranges to make sure it's looking at that new piece of information And once you've done that it will filter through but obviously it allows for human error So obviously not update the formula and also it's just a bit clunky and it's just not giving us the dynamic approach We want there's just one thing we don't need to worry about or be thinking about when we're adding new data The benefit of obviously adding a table is as soon as new information is added So if I do IT and this example is Birmingham You can see that it's been added in there straight away and that's the benefit of using the table and why I'd always insist using a table if you can when you're doing such references Just to ensure that your data is made being kept up to date Another example is particularly useful again for if you're popping this formula in and then the worksheet is being shared with a Collie or someone else or another team and they're going to be the ones who are updating it again It just makes it robust so that as they're going to be utilizing the form It just means that they're not going to have to be worrying about things not fooling through or again as always They'll come back to you and say oh, it's not working. It's broken. Well, actually obviously they just haven't updated But by doing the table reference, so I will for that out it just eliminates any sort of potential visual problems So I hope you enjoyed that video and it's gone into enough depth for you to start now using that in your work If you do have any questions, just drop a comment below this video and I'll get back to you as soon as I can If you did enjoy the video, please do give it a like and not only does it show me the content that you're interested in seeing more It will also help that you do algorithm What's all important for making sure that other people can find our content and enjoy the videos as well Lastly, if you haven't already or if you're new to the channel, please do subscribe Make sure you get that bell notification button as well that way you should be notified all of our future videos as they come out So thank you very much for watching and I should 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


The Hollywood Radio Theater, adaptations of famous motion pictures, with Hollywood's greatest stars. Here is your host, Frank Brzeeg. Greetings again, ladies and gentlemen. Over a century ago, the eyes of the world turned to California and the fabulous wealth of the new gold strike. Men and women with adventure in their hearts braved incredible hardships to reach the new empire of the west and an epic chapter in the history of the nation was written in their blood and courage. All the color and romance of those fabulous times is captured in the Paramount screen hit, California. And we present it with Ray Milan in his original screen role and Elizabeth Scott as his co-star. It's curtain time and here's California starring Ray Milan as Jonathan and Elizabeth Scott as Lily with Raymond Burr as Captain Coffin. The year is 1848. At a fairly town along the western trail, a large wagon train is about to resume its long journey to California. Now, what do you want? They tell me the wagon train's getting ready to leave. Who's the boss? I am. Well, then you can help me. How about a lift to California? Not a chance. Why not, Mr. Corporal? It's a room for all of us. It's a room for one more. You can ride one of my way. I'm welcome. Turn on your car. It's the only thing she cheats at. Thank you, Mrs. Everett. Throw her out of this town. We don't want to like the herd near us. Well, I'm glad to see you two good ladies who are so set against wickedness. I think we can take her off your hands, all right? Well, I think I've got something to say about that, Mr. Fabian. Oh, I can pay my way if that's what you're thinking. Now, look, Fabian, this is your wagon train. It's my job to get you where you're going. For $1,000 cash, I've guaranteed you to lay this outfit down in California all in one piece. There'll be trouble enough. Who are you afraid of? Me or yourself? I don't care what kind of baggage we carry, and I don't want the boys fighting over it. You say there's trouble ahead of us, Mr. Trumbull. And we'll need all the help we can get from Providence. By doing one good deed now, we'll improve our chances with Providence considerably. Have one of the boys get the ladies' baggage, Mr. Trumbull. Oh, thank you. My name's Fabian, Miss, and this is Mr. Trumbull. I'm Lily Bishop. Just like that, Mr. Fabian. It's all settled, huh? She comes with us, Jonathan. Now, what time will we be leaving here? Get your people together. We're leaving right now. Everything's quiet, Johnny. Looks like a nice, calm night. Yeah. Tell Ed to take the cattle watch, Whitey. Warn you a section to go easy on water. I've just told the others. That's two days along Dry Hall. You told the others? And what about her? The girl in Fabian's wagon. What about her? Take a look at you. I'll take care of her right away. What do you think you're doing? That's water. Two days' rashes and you're washing your hair in it. I ought to make you drink it. How am I supposed to keep clean, Mr. Trumbull?  Where's Fabian? In his other wagon where he belongs. Good night, Mr. Trumbull. Yeah, I think we live through the night. What's in the box, Grandpa? Yes. I've got some grape cuttings in here. They sure don't look like much right now. Grape cuttings? Awful dry, aren't they? No, painfully dry. I heard you just now with Miss Bishop. Sort her up with her. Well, I'm rough on everybody. I've got to be, Grandpa. Maybe you think it's easy to haul you farmers over the trail. I'd just as soon right heard I'm buffalo. Then why did you hire out as a guy? Maybe I'd just like to keep moving. That could be the reason, couldn't it? You, uh, no Missouri at all? Yes, some. Been through it. I won't send a vineyard there. Rich, good earth. Why'd you leave it? Because I want it soon. The grapes need more than earth, Mr. Trumbull. Well, they don't look much like grapes to me.  From these dead sticks I've seen miracles rise every spring in my vineyard. Now see it again, please, God, in California. Yeah, you're a long way from it right now. That's you, Trumbull. I've been looking for you. What's the matter, Panic? You run out of water? Patience would be more like it. How much longer is it going to take? Well, we're all in the hurry to get where we're going. You, Mr. Panic, as well as the rest of us. Oh, perhaps your reasons are different. I paid my way tonight. There's room for more than farmers in California. Room for everybody. California's going to be the next state in the union, God willing. I wouldn't be too sure, Fabian. Times like these there may not even fear you. We don't need that kind of talk, Mr. Panic. Not in this train.  A little grease on your tongue, Panic. You'll keep out of this, Neil Skinner. What do you know about politics? Politics? Practically nothing. But we've got people with this outfit from Ohio and Kentucky, Wisconsin and Georgia. The north and south is right here. And we're getting along fine, understand? If you've got any more of that talking to you, you'd better say to yourself. And when we get to California, once we get there, you can tear each other to pieces for all I care. Me? I'll be having a long drink.  It's kinda late to be up, Pop, isn't it? Lily. Boy, I was just reading. Been down in the campfire. There are women on this train, Pop. And they don't like me any more than the women back in Pony Flats. Forget about them, Lily. Listen to this. A land of wheat and barley and vineyards. A land of oil and honey. Where thou shall eat thy bread and enjoy abundance of all things. Somebody else writing about California? This was thousands of years ago. The children of Israel and God leading them to the Promised Land. Oh, they're pretty words, Pop. Pretty names. I know lots of names, too. Natchez, Memphis, Savannah, New Orleans. Oh, they're pretty, too. But they're places that can break your heart. But I'll find a place somewhere where nobody can throw me out. I'm... I'm grateful to you, Pop, for taking me along to the Promised Land.  They don't hurt me, Pop. They can't. You're the best that I've seen since I left Missouri. Soldiers out here on the desert. Just a routine patrol, Mr. Fabian. We sure thought you were Indians when we first saw you dust. We've just been all through this country, Mr. Fabian. No sign of Indians. Now, uh, where's your guy? Well, he went on ahead, just got around a bit. He trombo-backed yet wordy. Ain't seen him, Mr. Fabian. Well, you can tell me. How's the waterhole at Salt Lake? Three days ago, our horses stood in it up to the knees. Blend your water, Captain. Uh-huh. Um, about your guy, uh, trombo, huh? That's not a common name. He wouldn't have a brother, would he? Not that he spoke to him. Well, I once knew a lieutenant by that name. Good soldier, too. Not the kind you'd expect to desert. Well, stick to the trail and good luck. Sound your call, Corporal. We're moving out. And 20 miles today, Grandpa. Not too bad for a country like this. And plenty of water to spare from a great cuttings. Those cuttings still got life in them, huh? Life. Someday you'll drink wine from these dead little snakes. Well, I'm not planning on it, Grandpa. Well, any problems? Not a thing, Jonathan. Then I think I'll go join the boys. There's a card game tonight. Seems like Lily's winning all their money. Lily? Yeah, and she's good at it, Grandpa. Too good. Why do you think they ran her out of town? Cheats you mean? Mark Cohns? There's been a rumor. I'll soon find out. Oh, Jonathan, wait. Yeah? Have you any family, Jonathan, any brothers? No. It's none of my business, I know. But were you ever in the Army? Now, look, you hired me to take you to California. If you had any questions like that, you should have asked them long ago. No questions, Jonathan. That's enough for me, little. Spence of company. Here's your heart for me, too. So you're all leaving so early, too. I'm still here, and I'm calling your bet. Still want to climb those golden stairs, huh? Well, Mr. Trumbull, what have you got? Jack High Street. What a pity. A full house. You know, you're awful cute, Miss Bishop. Where'd you learn poker at your mother's knee? No, my father's. He was a gambler, Mr. Trumbull. Played the Mississippi River Boats. And he always used to say, it's a cheat who's most afraid of being cheated.  It makes you look a lot more important than you really are. Oh, just one thing more. My father also told me to always leave a man burying money. We'll do it again, boys, whenever you're ready. Mind if I talk to you, Lily? It's not my wagon. I don't own it. I came to give you back your burying money. When I need any favors from you, I'll ask for them. Aren't you afraid people will see you? You'd better get in the wagon. It took you a long time to make up your mind, didn't it? Make up my mind? Why don't you admit it? Back there in Pawnee Flat, there was something else you were afraid of. You know, for a woman, you're pretty smart. Too smart. A woman gets tired knowing too much. Sometimes she likes to be surprised. Like this, maybe? That was what you wanted, wasn't it?  Well, that's exactly what you're not going to get.  You sat like judgment on me. They were throwing me out of town. You thought just what they wanted you to think. You didn't need any proof, oh no. You knew just by looking at me, you knew. And ever since then, all these weeks trying to shame me. You're not a hard man to figure, Mr. Trumbo. That was your way of making love to me. Then you come here and expect me to fall into your arms and be thankful for the favor you're doing me.  Pretty high and mighty, aren't you? Boss of a wagon trade. But let me tell you this.  So help me. Anything else to tell me? It'll have to wait, won't it? Aren't you being called? Trouble, Mr. Trumbo? Yeah, probably. Whatever it is, it's tame to what you're going to get from me. Now get out of here. Move. It's gold. They found gold in California. Who are these men? That's right, we've seen your campfires. We figured we'd better share the good news. They found the gold. They're always finding gold in California, but nobody ever saw it. What a state this time, Mr. Mountains are gold. Tons are gold. We're heading for California, if you like, you can string along with us. We ain't waiting for no wagon. We aim to get there while there's still standard rules. It's not use, Grandpa. This is the end of your wagon train. They're all going to look for gold. Gold.  Bring us nothing but murder and greed. We steal it out of the ground and we'll steal it from one another. Look at their faces, Jonathan.   Don't leave the train. I'd be a fool to stay, Mr. Fabian. Quickly you get there the richer you'll be. But your wagon, Abe, all your belongings. From here on in, I'm my own boss. You want my wagon? It's yours. See you in California, gentlemen. You'll need those tools, Slim. You'll need your plows. Stay with the train. What train? There ain't any train anymore. We're going by horse. Well, get me a plow too. Gold plating. He's right, Jonathan. There isn't any train anymore. So you're going too, huh? I am. Nobody's going to get to California ahead of me. Look, I suppose you've got plenty of reason to hate me, but, well, I don't want anything to happen to you. Breaking up the wagon train, it's liable to be dangerous. I'll take my chances.  Well, about last night, I... Well, speak up, Mr. Trumbo. I might begin to think you are not so sure of yourself after all. Look, I'm trying to apologize. I'm sorry I slapped you. Get ready to go, Lil. That's all you've got. You're going with him? With panic? You got anything to say about it? Not a thing, except I almost made a mistake. As long as we're leaving, Trumbo, I got a present for you. My bow whip. I won't be needing it anymore. It's on yours. See you in California, Mr. Trumbo. How are you feeling, Jonathan? Any better? I feel like what I am. The biggest fool in the territory. Easy now, Mr. Ingest. You stay put. You've been a broken bone on that shoulder.  It might have been a bullet instead of a whip. They've all gone, huh? Yeah, and the only ones left. We're staying here awhile. That shoulder will take time to mend. 700 miles between us and California, and this had to happen. Let me know how you to get there. Sun and the soil still be waiting. I wonder... I wonder if we'll ever see any of them again. Kenneth, Lily, yeah. Yeah, I wonder. Well, California will continue in a moment. What's the word for the Armed Forces Radio and Television Service? Today, the word is climb on the bandwagon. We've all heard that phrase, the first bandwagon was horse drawn and large enough to carry a full band. Usually associated with publicizing some sort of an event. The bandwagon is most generally thought of in connection with the circus or a political event. Often the political candidates would ride on the bandwagon. Their supporters would climb on the bandwagon to show their support. Often this public display of confidence was given in the hopes of gaining some favor from the candidate if he was successfully elected. Then there were the other folks who just climbed on the bandwagon to join the crowd. Today we still see those who will flock to join some popular fad, whether it be politics or a circus. They figuratively climb on the bandwagon. That's the word for the Armed Forces Radio and Television Service. Act 2 of California starring Ray Milan as Jonathan and Elizabeth Scott as Lily. Two months have gone by and the Gold Rush in California is at the height of its hysteria. Overnight scores of towns have sprung up. Among them, a place called Pharaoh City, a collection of half-built shacks and tents. The largest building in town is a saloon, the Golden Lily. Hello, Panic. Trouble. Reaching for a gun bet? I don't try anything. I won't, not just now. So you finally made it. Yeah. Where's Lily?  There's a lot of things I can't get off my mind, but I'm going to take them one at a time. Who's this stranger, Panic? Oh, his name's Trumbo. This here's Mr. Pike. Welcome to Pharaoh City, Mr. Trumbo. Thanks.  I ain't no scurvy landlubber. One of these days, Mr. Pike, somebody's going to cut your throat. Where you going, Mr. Trumbo? This rough talk upset you? I think I see a friend of mine. Hey, Whitey! Johnny! Charity! So you did get it, huh? How about you? Millionaire yet? Me. I'm lucky if I eat once a day. But I thought everybody in town was rich. Ask him what's going on. That's even gouging. Pike? That's right, Pike. Go on, ask him, Johnny. Him and his captain, Coffin. What's your lift, farmer? You know more, I won't. I come here, Johnny, expecting to find a free country. Instead, I find a shark named Captain Coffin, squeezing the life blood out of the place. But you got a claim, haven't you? But I need water to work my claim. I got to buy water from Coffin, pay him for every drop. I got to buy Coffin's food at Coffin's prices. I got to buy two drop from him. A hundred dollars for a shovel.  Two days ago, my claim started to pay out. Good truth. Right then, Coffin and his gang moved in. Sears their foreclosure for debt. They drive me off the place with pick-handles. I warned you, Hastie! All right, boys! Let's take care of them! What's the damage this time, Mr. Pike? A couple of chairs and a mirror, Miss Lily. I'm beginning to think you're too expensive to have around. It takes a long time to get furniture out here. You said you wanted to see that fella when he came, too. Well, he's all right now, I guess. Mike clouded him with a bottle. Where is he? I dumped him in your office, Miss Lily. Thanks! Well, Mr. Trumbull, I'm glad to see you're still alive. I came to this place looking for you.  I told you once before how I felt about you. You know, I'm just beginning to understand something. No woman can go around hating a man the way you say you hate me. Not unless there's something else on her mind. This much, I'll tell you. If you ever so much as set foot in here again, I'll have a better man than Pike throw you out. You talk like maybe you own this place. I do. Maybe I shouldn't ask how you got it. Well, then don't. Must take quite a man to stake you to a layout like this. Why, just the furnishings of room, Mr... Hey, what's this? It's a model of a ship. Yeah. Famous ship, too. A brig. Nice ship. From you, Skinnery. You seem to know a lot about ships. My father was first made on a whaler. Let me see that model. Congo Queen. Pharaoh Coffin, master. Coffin. You know, I keep hearing that name. Why do you mention it? Yes, Lily. Well, I understand a lot of things. Something amuse you, friend. Like said you had company, Lily. Don't worry. I can take care of him. You're a long way from Africa, Captain Coffin, and the slave trade. Why, slaves, Mr. Trumbo. I can get more for a shovel than I can for a black. Or by running helpless men off their claims with pick handles. These are fast-moving times. No room for helpless men. This is an odd place to find a man who remembers the Congo Queen. A fine ship, Mr. A fine name. She was a floating graveyard. I used to hear back east how people crossed to the other side when you walked down a street. They said you had the stink of death about you. Anything else, Mr. Trumbo? Yeah, they told me no court would try you because no one would hold it. A black was a man, just an animal to be beaten and chained. Most men love the chains they wear, Mr. Trumbo. They need a master the way an infant needs its mother. You know, Coffin, for all your ways, I've heard it said you're a frightened man. Afraid that one day a bolt would break. A chain would give and the blacks would come swarming up out of the hold. What do you dream about at night, Captain Coffin? Of California, friend. California. You never hear the drag of the chains below decks? The chanting of the slaves over there dead? I even heard rumors of nightmares you've had.  That's true, isn't it, Captain? In Faro City, the truth has a price on its head, and you don't speak it, Mr. Trumbo, unless you're armed, nor do you intrude into another man's dream. As for you, Lily, well, I had you wrong. You don't care for anybody but Lily Bishop. Who said that the wages of sin to death looks like they come pretty high in Faro City?   Next time, I won't spoil her aim, Mr. Trumbo. I'm obliged, Captain. Happy drain. Why did you do it? Why did you do it? Because I knew you would cry over him afterwards. I should not like to see you crying, Lily. Games open, gentlemen. Place your bets, please. Place your bets. Close that table, Mike. The matter, Miss Lil, ain't there money any good? I said close that table. You heard it, gentlemen. Sorry. I thought I told you to stay out of here, Trumbo. Now, this time, I didn't come to see you, Lil. This is business. I don't want any business from you. What's the matter? You scared? What have you got that I should be scared of? Well, wouldn't be my luck, would it? I got quite a pile of chips here. Mike, get up. I'll deal. Is any game still open? It's open, but only to Trumbo and me. And this time, Trumbo, there won't be any burying money. Well, thanks for the warning, Lil. I'll go ahead and deal. You win again, Mr. Trumbo. Not quitting, are you? I never quit. How much? How much you got? Four stacks of chips. All right. Four stacks. Looks like you're bidding into a queen, Lil. All right with you? Anything you say. And take three cards. Well? A four, a trade, a ten. Too bad, Lil. Pay him off, Mike. The game's closed.  Looks like I am. Just a minute. I'll cut you, Lil. Every chip I've won against this place. If you win, I'm broke. If I win, I get the saloon. Everything or nothing, high card wins. Lay off, Lil. He's too lucky tonight. Look, a while back, you said you weren't afraid of anything I've got. Well, I got this pile of chips, and it says you've lost your nerve. Shuffle the cards, Mr. Trumbo. Now, cut. Not too good, Lil. Four or diamonds? Got him licked, Lil. Most anything's better than a four. Sure. Well, go ahead. Cut a card. The deuce. The deuce of space. Well, it looks like I'm the new proprietor. Turn everything over to him, Mike. All right, boys. Let's have a drink on the house. Here's your piece of paper, Mr. Trumbo. A quick plain deed. You don't have to leave, Lil. You can work here, you know. Don't do me any favor. I'm not. I'll need a good dealer. Maybe you can get back a piece of the coffin's money. It wasn't coffin's money. No? Who's was it? It was mine. I bought this place from coffin with it. But it took me five years to save. But that's my business, not yours. Sure. That's the way you feel. That's exactly the way I feel. Good night, Mike. Good night, Mr. Lil. Hey, Mike, take a thousand dollars. See that she gets it. Burying money. She won't need burying money. Not where she's going. Why not? Coffin's place. Captain, we'll see you now. Straight ahead, ten years into the library. Mr. Trumbo. Frankly, I hardly expected you to accept my invitation. I appreciate it. Just curiosity, Captain. I've heard about this place of yours, but I'll never believe the word until now. People said it was a palace. Well, they were right. I bought it from a grandee of Spain, Mr. Trumbo. Thousands of acres in this Hacienda. It's more than a palace. It's also a citadel, as I'm sure you've observed. Oh, and guards, thick walls, iron gates. Are there slaves in California, too, Captain Toffin?  But you didn't send for me to listen to me talk. Oh, I hear you took over the Golden Lily last night. I like a man who takes what he wants and doesn't ask too many questions. I like to see such a man get ahead, but not too far ahead. I have a good piece of this country in my hands, Mr. Trumbo.  I'll buy the Golden Lily at a fair price, and you can leave California. Or you can stay here and go along with me. Do you know what that means? I'll do all right alone as a saloon keeper. I could possess all of California and the power that goes with it if I had a handful of men like you. Sorry, no deal. At least we understand each other. Good day, Mr. Trumbo. Mr. Pike, no deal, he said, huh? No deal. We'll dispose of Trumbo tonight. Now, find Miss Bishop. She's not occupied. I'll be waiting for her in the patio. Although she is occupied. Who should know by now that in certain matters I am a man of unbounded patience, Mr. Pike? I shall still wait for it. All my travels will end. I never found another island like it. Such tranquility, such a paradise. Yes, a man could well forget himself there. Why didn't you stay? Alone? No. But I could return there and be happy with you, Lily. Do you hear me? I'd like to take you there someday. Someday? Maybe I'd like to go. As my wife, Lily. Because it seems so strange. All my life I've wanted to be just that. A wife. Does that seem so strange to you? I have no illusions that you would love me. But I believe we could be happy together. I know what they say about me as slaver and all the rest of it. But everything I did, I did because I had to. Nobody ever helped me. My father was a drunken sail rigger. I took more beatings before I was 12 than any felon does in a lifetime. I ran away, lived under the wards like a rat. Then one day, one day I saw a captain step from his ship to the shore. Bright buttons gleaming in the sun, giving orders like a giant, like a king. In time I became the master of the ship.  But tomorrow, tomorrow I'll be master of a country. All of California, Lily. And when that happens, I... You're not even listening. There are other thoughts in your eyes. You're thinking of someone else? Yes. Who? I am.  I was trying to picture you like you said. I'm beginning to understand you. I love you, Lily. I love you. I think Mr... I was trying to picture you like you said. I'm beginning to understand you. I love you, Lily. I love you. I think Mr. Trumbo's ready to listen to you now, Captain. Come on in. The rest of you men get out of his office. Close the door, Mr. Pike. None of this is my wish, Mr. Trumbo. You made your own decision.  Only to tell you that this is your last night in Faro City. But before you leave, I want you to sign this. Quit claiming deed for the Golden Lily. There's a pen. Sign it. If you want to kill him, Captain, here, use a gun. Kill him? No. No, no gun. There are other ways. Put him on a horse. Tie him. Hand and foot. Then lose him in the desert. I'll see you tomorrow, then, at the Hacienda. I won't be there. I'm going south to meet Senator Creel. Creel? He's here? He's here. Six months more, Mr. Pike. And I'll own the entire territory of California. I'm moving on. Where are you going? I'm going to get a college education, an associate degree.  Well, I'm moving off. What do you mean? I'm going to get a bachelor's degree in computer science. Education counselor said that all my programming experience is worth college credit. And if I take some courses... College level education can help you advance in your job specialty. There are any number of courses and programs available to service members overseas. So if you like the kind of mobility a college degree can give you, stop by the education office. You could be on your way up. Every day we go looking for trouble. And do you know what we find? What do you think is the biggest health problem today? Cancer. That would have to be cancer. Cancer. These people are wrong. And that's the trouble. While cancer may be the most talked about problem, it isn't the biggest. For every person who dies from cancer, more than two die from heart-related problems, like high blood pressure. This not only affects almost one in four adults today, but it's often symptomless, which means nearly 17.5 million Americans are needlessly risking their lives to cardiovascular problems without realizing it. This is the kind of trouble we look for. We're the American Heart Association, committed to reducing death and disabilities due to heart disease, through research, prevention, improved treatments, and information which could save your life. Heart disease, huh? Who'd ever think of that? The American Heart Association. Oh, right. The American Heart Association. We're fighting for your life. Now your host, Frank Brzee, returns to the microphone. Back three of California, starring Ray Milan as Jonathan and Elizabeth Scott as Lily. Six weeks have gone by since Jonathan Trumbo's sudden departure from Faro City. But now, just as unexpectedly, he's returned. Not to the town, but to the shack of his old friend, Mr. Fabian. It wasn't lanky to sell out, Jonathan. Run off without telling anybody. Sell out? I was run out. Captain Coffin, you did a pretty good job, too, Grandpa. Almost perfect. Yeah, but where have you been? I'm not too sure, Whitey. Over most of that desert, I guess. It hadn't been for a couple of Indians that are cashed in long ago. What are you going to do, Johnny? Well, first off, I'm going to borrow your gun.  Men like Coffin are like weeds in the field. You have to dig them up by the roots and can't do that with a gun. Jonathan, lots of things have happened while you've been gone. They're planning a convention at Monterey to make California another state in the Union. And when that happens, they'll take care of men like Coffin. Sorry, Grandpa, I can't wait that long. Besides, if there is a convention, he'll be running it. Maybe Johnny's right, Mr. Fabian. Look what's going on right now. Tonight. What? I'm not sure, Jonathan. Some big shindig at Coffin's Hacienda send it creelers there, politicians from back east. Some of them rich Spaniards, too. I'm sure you'd like to know what they're cooking up. So would I, Wadi. There's only one way to find out. I'm going there. As much as we know, gentlemen, that in the hands of the delegates, we'll rest the decision as to whether or not California becomes a state. As I've told you, I intend to be a delegate myself. Even so, even so, the convention may go against us. That's why we're meeting here now. What is Senor Coffin proposing? Immediate preparation for the armed seizure of California. Isn't that rushing things a little? I think Senator Creel can answer that.  Surely you should know that a whole country is rushing toward an armed conflict. When that happens, a strong and independent California can affect decisively the outcome. Senor, I too would like California to be a great and independent country. And yet, if the people should be against it, I would be a fool to fight for them. Yes, yes. You ask a great deal from us, Senator Creel, but what can we expect from you? If we're going to take the territory by force, what do we do about weapons? Powder and shot, don't grow on trees. No, Mr. Willoughby, they do not. Come with me, gentlemen. We'll take a little walk. I'll show you ample evidence of Senator Creel's good faith. Senora, senora! Well, I suppose you could call me a guest. You don't remember me. Oh, yes, many weeks ago, to see the master. Please, senor, you do not tell him. You do not tell him. Tell him what? I am not to come here to the chapel. He keeps it always locked, senor. Why lock up a chapel? I do not know. But if he finds a... Senora, they're coming here. Listen. There's no time to get out. Get behind the older. Hurry. Follow me, gentlemen. Perhaps you will find these precincts overly pious. But I assure you they are practical. Here. Here in this anti-room. Behold. Guns and ammunition from the floor to the ceiling. And heaven's enough to equip her regiment. But how did you get it here? Our friend, Senator Creel, smuggled it in right under Colonel Stewart's nose. Stewart? He's back in California? He's in camp just outside of Ferro City. You don't suppose he's got wind of this? If I know Stewart, he's too busy with his own political career. Shall we return to the house, gentlemen? Those guns. Why does he have them here? I do not know, senor. It is a sin against God. Be careful, senor. You're only one against men. Just forget you ever saw me here. Miss Bishop, is she here tonight? Yes, senor. Soon the dancing will commence in the patio. She will be there, senor. Thank you. Lily, wait! Chamba! But do you know this isn't a safe place for you? Since one of you cared. I don't. Then why warn me? Because I'm not afraid anymore. Of you or anything. For the first time in my life, I've got something I've always wanted. What would that be? I'm... I'm going to marry Farrell Coffin. You don't love him? He knows it. You wouldn't understand, would you? That a woman can sometimes manage without love. Providing the price is all right. Two months ago I would have hated you for that. No, it doesn't matter.  Why didn't you ever show that side of me? Instead of always trying to hurt me? Why do you tell me that now? Because it's too late now to do anything about it.  Don't ask me why. Maybe I want to even up a lot of other women. And I'm going to hurt you again. Worse than ever. You can't hurt me. That's one thing I've promised myself. You can't hurt me ever again.  Well, I'm not going to. Not tonight. I've found out enough about him to make me want to find out a little more. But I'll come back, little. And when I do, nothing's gonna save him. Oh, no, no, you mustn't. Even if I loved you, you couldn't stop me now. Good night, little. Lily, what's the matter, darling? Does he look unhappy? Do I? I'm not unhappy. Lily, in all my life, I never want to cause you a moment's sadness. If only I could... What was that? I heard something. Oh, it's just the wind, Farrow, stirring the branches. No, no. Well, see for yourself. The leaves are brushing against the roof. Only the wind. For a moment it sounded... sounded like naked feet shuffling across the deck of a ship. It was you to make a deal, Colonel Stewart. It's hardly a practice of the army to make deals with deserters. Colonel Stewart, I didn't wake you up in the middle of the night just to have myself arrested. Sir, did you ever hear of a Captain Farrow Corphin? A man who's running for the Monterey Convention? That's not all he's running for. He's setting himself up to take over all of California with enough guns to start a small war. I know all about Captain Corphin and the guns that were smuggled in. But you won't need reinforcements, sir. You won't need the army at all, not if you'll agree to what I'm asking. I found it, Trumple. I don't make deals with deserters. But if you help me wipe out my court martial, I'll take Corphin off your hands. How? Kill him? Something like that. That way of settling disputes is over, Trumple.  Run somebody against him and break his back at the poles. Do you know anybody who's really respected around here? An honest man? Well, I know a farmer like that, Michael Fabian. But what if he doesn't break Corphin's back? I will make a deal, Trumple. I'll give you your freedom for 30 days till after the Monterey Convention. Then you report back here and you'll face a court martial. If you don't, you won't get just two years. You'll get 20. Yes, sir. Fair enough. Just one thing more. That woman, Fort Marcy. Just who was chasing who? Well, it's your guess, sir. He was hardly worth deserting for. Well, it was either that or shoot the husband. Anything else, sir? You have 30 days of freedom. Thank you, sir. The votes have just been counted. The Monterey Convention is Michael Fabian. Hello, Mr. Fabian. Well, now, you think you drive way out here to see me? So you won the election. In a way, I'm very happy for you. Only in a way? Come in, Lily. Come in. Sit down. You see, I didn't come to congratulate you. I'm here to ask you not to go to Monterey. But why not? Well, I'm afraid for you. Don't you see this whole thing as Trumple's idea? He's using you to pay off a grudge. You see? You know... No, I know Mr. Trumple, Mr. Fabian. And I know Captain Cawking. Surely he didn't send you here, Lily, not Cawking? No, but I heard them talking. Farrow, Pike, Senator Creel. Oh, please believe me. They'll do anything to stop you. A man can't stay out of danger hiding under a bed, Lily. And they can no more keep California from becoming a state than they can keep the sun from shining. I'll tell you once again, Mr. Fabian, don't go to Monterey. I've got to go, Lily, but thanks for the warning. I didn't really think you'd listen to me. Well, good night, Mr. Fabian. Pardon, Senor. Yeah? You are Senor Trumple. You are here in Monterey for the convention, yes? A lot of people are here for the convention. Senor, as you may observe, I am a little drunk. It is not a habit, I assure you. I am Don Luis Rivera Hernandez. In California, that is the name of honor. And with honor, a man should be more careful. Do you agree? I wouldn't now. Senor, your friend Fabian. He speaks tomorrow. Any objections? Do not let him. Take him away at once, Senor. Why? I do not like to see a man killed in cold blood. Look, sense, Jonathan, the convention is about to reopen. I can't stay here in the hotel room. There's only one place you're going, Grandpa, and that's home. If you don't listen to me, you're going to be killed. Then who's been telling you that nonsense? The man who was drunk. And you're worrying about the word of a drunk? But there's something else you better know. I got you into this, Grandpa, but I didn't give a bent nickel for what you were fighting for. All I wanted was to fix Corpin. That's why I persuaded you to run against him. I've known that for some time, but I'm glad you told me. And you're still going back to that convention hall? I am. You forget the folks who voted for me, Jonathan. They have faith in me, and I got to keep faith with them. You should understand that. Well, I think I do. Well, if it's that important to you, it ought to be that important to me. Let's go. Mr. Willoughby still has the floor. I ask you again, why are certain delegates in this hall so insistent on rushing California into statehood? Statehood will only make California a pawn in the Civil War already threatening to separate the rest of the country. If Williams' measure is fast, it is inevitable that those of us favoring an independent empire, a republic of California must either separate from it or contest the decision by force of arms. The chair recognizes Mr. Fabian. I just heard the words independent empire. So did you all. A slip of the tongue, Mr. Willoughby? No. No, I don't think so. Order! Order! Mr. Fabian will be heard. I say that's nothing but treason. We are men from every state in the Union. We're farmers and miners and everything else. What we want California to be is what she should be, another state, in what I believe is the greatest land on earth. That was a bad move, Coffin. We're lucky we got out of Monterey with our lives. I'm still curious to know just who shot Mr. Fabian.  Still say I don't know. To pike perhaps. Pinnock maybe? There are a dozen who might have done it. Under your orders.  Know as well as I do it, would come to fighting sooner or later. Let it be sooner. We're prepared and the others are not. I'll be leaving you at Sacramento. I suddenly feel the need of a long sea voyage. Good luck with your war, Captain Coffin. Get her at once. Get Miss Lily at once. I told you, Senor, she's not here. Then find her. Tell her there's a priest waiting in the chapel, waiting to marry us. The priest is gone, Senor. He said, he said you cannot use the Holy Church as you would your chattel. Lily, find Miss Lily. She went to the town this morning, Senor, before you returned. The news reached here first, Senor. What news? Answer me! Answer me! Senor Fabian has been murdered. Mr. Pike? No. I've come back, Farrow. Lily, Lily, you didn't leave me. You didn't leave me.  Just as sure as if you pulled a trigger yourself. Lily, what do you care about Fabian? Yes, yes, I killed him. I'll kill everyone who tries to stand in my way.  Lily, that gun. Oh, no, you wouldn't. That's the only reason I came back. Captain Colton, they're on their way here. Lily, don't touch her. Don't touch her. Struck her, Mr. Pike. You'll strike her. She had a gun.  Lily, Captain, Captain, listen to me. The whole town's at the gates. Trumbo's coming for you. We've got one chance, but we've got to get out of here. Get some water. Get some wine. Captain, please, I've got horses in the side pad. There might still be time to make a run for it. Call the men, pass out the rifles. No one can touch me here. They've gone. The men, the servants, everyone. It's you and me now. We're both dead. And let me run for it. You strip, Lily. You stuck her. She just lies there. You've killed her. Kill her. Can't you see that she's breathing? Come on. I'll take her with us.  Listen. Feet across the deck.  You betrayed me. Listen, I can hear them. You took the keys and unlocked the chains. The slaves, I can hear them. The slaves, they're coming up on deck. Trumbo's men, you hear? I told you, Captain. They're coming across the deck. Oh, you betrayed me, Pike. You betrayed me. Captain, you betrayed me, Pike. Lily. Tell them they can stop shooting. Where is he, Lil? You better tell us. We'll find him anyway. He's in the next room. He's out of his mind. I know now that he was always out of his mind. Trumbo, maybe it's better this way, Lil. Come on. We're going back to town. You can stay here, Lil. He'd want you to stay here, here at his place.  You know, it's as if I was seeing them for the first time, the way he always saw them. Babies saw a lot of things that most folks missed. Well, I'll say goodbye, Lily. Where are you off to, Trumbo? I got a date with the army, remember? How long does it mean? Year? Two, maybe. You... you'll come back, won't you? Where will you be by then? Right here. Waiting. I'll be back.


and his name is Joshua Williams he's from the Bahamas 7.03 meters his winning leap and Joshua coming into this event what were you thinking what did you achieve to do and are you happy with the performance I felt good going into the competition but my jump before all my other jumps I was in last place during the competition going into the second round but on my last attempt I was able to get a person a new person the best and also to win the competition yeah what point did you know that you had this in a bike after I saw after I saw the came in island guy he went up for and he didn't get the jump but then he was in second place at the time so when I saw that I got the winning jump then I was I was ecstatic another gold medal for the Bahamas how do you feel about delivering for your country I feels good last year I didn't place at all in the long jump I placed last year third and high jump but I have high jump tomorrow and I'm expecting to bring a next gold home for the Bahamas all right well congratulations to you Joshua thank you yeah back upstairs to our commentary team


Yep That's right a little lamp We've got see that the inverter Grid just went down about five or ten minutes ago blackout but I am Live because my modem up there We've got our modem plugged in to the inverter So We got that monkey over here went with the doggie I can't see you get light up by your baby There you go there monkey and there's poochie There's her little hamster.  What kind of noise is this? Up and banging booming, huh? Then all old ones a bright light and zap-zoop and Our transformer went out. So we're gonna be out for a while Well, you did you see it out there? Well, it was pretty dark. Well, you would have known if it was that one No, not that one. The one in the side of the street. Yeah, well it looked like it was coming back from back there Behind the house and something was on the roof too.  But we're hanging tough ain't we babe Yeah, oh we're strong That wind that wind is something else ain't it But guys we're gonna make it man. We're gonna make it come on everybody hunker down Hang tough, you know, don't let it get you down, man Getting a lot of comments from you guys appreciate it, man.  I imagine But we'll see man Anything else happens, man. I'm gonna kick you guys on And I'll let you know what's happening. So I'm doing this live So, you know, what's going on right this second As well as that way it doesn't take forever to upload and all that Hang on a second Anyway, so We are in citrus county So we are About an hour away from anywhere really, huh? Yeah, we're about an hour from uh, Tampa about an hour from Orlando We're kind of on the west side, but um, yeah, we're about an hour from Ocala So in verness Yeah, we're right. It's gonna be hitting us hard. So it ain't over yet. We're in uh, citrus county in verness area so But hey won't hang in there, man, and uh Like like I was telling you before I was really interrupted by someone's phone anyway Anyway, so but what I was saying was that and it takes a long to upload I want you to know what's going on right now You know, I know a lot of our followers are here with us. So they know what what's going on as well But for those of you that doesn't uh, we just kind of want you to know how bad it is and what's what's shaking So read that on the glass So but anyway, no I got them. I said I don't have them on I'm not wearing pink ones. I got my glasses.  It's too dark now There's no street lights nothing up there and second wall. She won't let me Because I've been out in it several times. I was out in it pumping out the boat It's got some water in it. That's pumping out the boat and uh tree land fell About five feet from me and now she won't let me out No, so anyway, listen guys, we're gonna go I'll get back with you here shortly I do have to go out and kind of shine light around and see what's Make sure nothing else is falling. I know there's some stuff on the roof But I think there's small limbs sliding across the roof. I think the roof is okay so far So I'm gonna check some of that out if anything Anything else turns up here shortly all I know it's getting late, but I'll I'll still I'm gonna go live every time I get on here It will be saved.  So no, we're not gonna be working tomorrow. See what? Anyway guys she bear I'm gone for now Stay tuned for part four because I'm sure I'll be back on again. So all right guys. Thanks for watching. Thanks for commenting guys. Appreciate it Back at you guys after a bit. Bye. Bye


hold up. Okay. Yeah, that's your cup. That's your party cup. Party in a cup. It's very Cheshire cat. Yeah, it was and I put some light for you painted it in the states for me, but you can probably. Yeah, all the leftovers are about to go on to there. We'll add some royal blue next to it. All right, two people have a filled cup. I'm going to move your, I'm going to move your things over to the side. Yeah, good idea. I can see them. See, they're going to come up and take you in here. Okay. I went live too soon. Hey, y'all. Let's get a lot of white. Yeah. I think it's going to be magic. We're using all the leftover colors. Yeah. Just launched. What's up? What's up? It's going to be a 10 person pour on there using all the leftover paint from the class. I'm going to try to go live tomorrow too. I'll probably hand my phone to Lady Giraffe.  Everyone said hello. That's a sink.  And then they're going to make magic or mystery on this. Could also be, could also be bad. Magical mystery. I was going to say, yeah. So once you're done, there's no rules on the technique that you have to do. You could be a free rein. You could do, I'm going to do what's called a ribbon pour. It's very simple. There's not really anything super special to it. But the one thing I asked is trying not to go too much over someone else's design. We'll integrate it all together, but this is a very much collaborative piece. So I'll start over here. So ribbon pour is literally just as it sounds and pouring in ribbon. That's awesome, Christy. Okay. Once you're done, you can kind of set your cup down to drain and then let the next person go. So please hold. We need one more camera at least. Because we don't have enough. Because we don't have enough. Please hold. Okay. Whoever wants to go can go. Don't be shy. All right. That looks like a watermelon. It makes me want a watermelon. Traveling tree ring, wedding eyes. More ribbons, infinity ribbon. That's what it looked like. Ooh, that blue just jumped out of there. I go too close to the edge. All right, see? So fill in the space. Nice. Yeah, that purple is really nice. Hello, Crystal in Australia. Like those colors together, right?  Hello, hello, everybody. May have to bring someone over here. Christy, how are you? It is like a dragon tail, huh? Ooh. That looks like that old candy ribbon. Goofy. Am I having fun in the sun? I got it. I got it. Add a zoom in on it. We'll swap out. It's supposed to be rain tomorrow. That's what you told me. Oh, I don't know the weathers. Like that aqua and that brownie. Like is it copper? Yeah. Can I say like a burnt elk over there? Nice. That was really pretty. I'm going to love this. And since it's in the center, I'm hoping it doesn't like leave. It could condense and it could get stretched out. Because we got to fill all of the this. Ooh, these are fun. Okay, then yeah, bring it over. All colors should be over here. There's a coral over here. Yep. Yep. Love those. Love all of that. I like this. I like that coral black. Yep. Yep. Yep. I came out unscathed. On greens. Ooh, this blue and yellow look fun together. Wagga, is that how you say that? I would love to say that I live in Wagga. In Australia. I would love to say I'm from Wagga, whatever. Just all nonchalant.  It reminds me of a latte. I was going to say, you drink a lot of coffee, so I'm going to all own that. I didn't argue. Am I suited? I mispronounced it. Woga. Okay. How is it? Listen. I have questions. Done, finished. Just even with the cups on it, it's done. It's a wrap. Do you want me to pop these?  Even that right there. Love that. Love that. Love it all. Snake skin. That's what we in the resin biz call that look. This is very punk rockery of you with this black and pink. Living for that. You know, I just don't go through other people's work. If you could avoid it. Crushed it. I'm going to get you on the tail. I just got to put my jacket down. Go ahead. Yeah, I'm standing onto this. It is a 36 inch canvas. Not much. You want the chair? Okay. If you could just try not to let any of it run off, that'd be great. That'd be super. We need ideas for it to do with pretty cups, right? Nah.  Where's my cup? I didn't put a cup on this one because I was filming. You're not even at the edge yet. You're at the edge. I'm just trying to help you. Okay, you're over the edge. Evaluate. That part's looking real nice. That part's looking real nice. Yeah, but those top areas are super fun. I wonder if this is going on Marcy's wall. It is unless someone buys it. It is available for purchase. Sorry. You could just come on this side. No. I don't want to make it difficult. It looks like you're putting a light on it because it's where the sheen is. Super psychedelic. Mind your edges. I'm going to be a part of the movie. I really like this edge on this side. Maybe my favorite part of the whole piece. Is that weird? No. I agree. This is my favorite part of the whole piece. Almost just died. Right here. All of this. Grateful dead looking. Very that. Edge. Oh, TeeGee. You're the best. Yeah, like all of this. And then this whole edge. Ripples. All of them. What? Crazy person. It actually looks better in person than it does on set. It happened. It happened. It always happens. It probably was on some scrape off or something like that. But that's okay. That's pretty darn cool, huh? There you guys. This is Marcie's classroom. This is all the artwork that the people have done today. Okay, it totally would. Tomorrow I'm teaching a resin class here. Everybody did super good job. Sharon. She used a lot of paint. Most of it was artist loft. In golden. Marcie has all of her recipes on her website and on her channel. For her paints. And she sells her own line of paints. Ta-da. These are all Marcie paints. They are already poor paints. You can find them on her website. Same Stephanie. They did. Students did an amazing job. So, you guys. Australian photo? Thank you. She just got the studio and it's super cute. It's in Pasadena. One day I will have this. But until then. We'll just use my studio in my house. But I gotta go and prep boards for tomorrow's class. Because tomorrow I'm teaching geodes and oceans. On these geode and ocean boards. I brought a pop-up shop. The wine I got while I was here. And so, yeah. It's gonna be an awesome day tomorrow. But I gotta go.  And I'll see you on the next live. Until then, be kind to one another. Because you never know what someone's going through. And I'll see you in the next video. Love you guys. Bye.