and welcome to the Desk of Lady Aida. Hey everybody, and welcome to the Desk of Lady Aida. It's me, Lady Aida, and welcome to my desk. With me is Mr. Lady Aida on camera control. Word to your mother. Ooh, it's right, it's Mother's Day. So for those who are thinking about it, maybe call your mom. If you don't want to call your mom, believe me. I understand, you don't have to, but if you want to, I don't know.  But once you're done with that, come on by and we can hang out at my desk and look at electronics. Yeah, we've got a lot of stuff going on this week. You can see some progress that we have. We're posting across all the social media channels, pretty much 24 seven, but Sunday is when we kind of collect things together to figure out what, when, and if we're gonna release something. So what's on your desk this week? Yeah, let's look at my own desk. I set up a couple things. I was actually working on some electronics this week. So first up, I think I showed these, this is a Zippy navigation. Yeah, that little video is gonna come out probably tomorrow. But that's okay, I can do a live demo tonight. You can do a live demo. Might wanna move the camera physically a little bit. Sorry, I forget. There you go. Okay, now it's zoomed in. Okay, so this is a click scroll wheel. It's reminiscent of the iPod. It's not the same one as in the iPod. It's made by Zippy. It used to be made by, I think, E-Switch or something, but Zippy makes, which they make a lot of mechanical stuff. They make a version, and it's got a rotary click wheel in the middle, and it's got four buttons, you know, Northwest, Southeast, and then one in the center. Got hooked up here to a Feather M4, and it's just reading the rotary encoder, and as you can see, it's spinning a Neopixel to match. You can maybe hear a little bit of the clicking. And then there's, if I press the up or left or down or right buttons, and then the center turns the whole thing on. So there's a little demo showing this breakout because the board is like it, the sensor itself is like a totally ridiculous pinout, and so this is just a little adapter that makes it breadboard friendly. So not a big deal, but you know, I wanted to, I wanted to start playing with this a little bit more and, you know, to test the footprint, I was like, I might as well make a breakout. So I did that. So that's one thing. I also put together this prototype, which I was distracted by Trinkies. And, you know, it's also like TFT's got really expensive, and they're still really expensive, but I wanted to finish it off. This is a 1.69 inch IPS TFT display, and you can tell it's a rounded rectangle. So it actually has the pixel cut off, like it's missing pixels. It doesn't have like a, it's not like a different mapping.  Do you think that's because the actual iconography is all rounded corners now, or is there, why is there? It's just for smart watches. This is so you can fit it into an enclosure. And so instead of having to work around that with a physical design. Or you'd have to make it bigger. You'd have to make it a little bigger and then make it look like rounded corners. Now the screen itself does rounded corners, so. And so you don't have to worry about the, it just means your case can be a little smaller. Gotcha. Yeah. So this is a few folks who remember, we were experimenting with, we really like quick and STEMIQT, which is plugging in, I squirt seeing here is like the rotary encoders that we used to put in the shop. I squirt see stuff connecting with four pin wires. Grove does this, STEMIQT does this, but for SPI and displays, it was something that we were starting to get all annoyed by.  And so it's like, it's not like just I squirt see where you're like four pins and done. You actually need like a lot of pins. And we saw that DF robotics, who came up with a standard that they called, I think it's just like generic display interface. I don't like you really have a name for it. And I was like, well, that's a good idea.  It's not really not my favorite hobby. So on this display, we have a little flip top for this flex cables. Flex cable has 18 pins. And I always like the bottom contact type because it's, I feel like it's easier to insert. And then if you plug this in, it'll show. I don't think we got to show that we actually have a logo that you designed. And you can see it's being inverted, but that's the iSpy logo. So SPI flex for display connectivity, putting on a, you know, a 20-cent connector on the back just means like, look at how easy it is to connect a TFT display a lot. Like there's such a pain to wire, but really the pinouts are very standardized. So this actually got done this weekend. So this is ready to order. And I got the pinout right this time. So good for me. That's SD card being tested. Um, what else? Some keyboard stuff showed up. So my break apart ortho key PCB. So you can actually see, you know, this has the routed cutouts. I haven't tried breaking this apart yet. I'm a little nervous to do it. I have a couple of these PCBs in a lot, but you know, in between, there's a little bit of a couple of very small holes and the two traces that connect each one to each other. So I'm hoping that, you know, you'll be able to easily break this apart and make custom ortho linear keypads.  So check out the previous videos for this. It's got rows and columns and it's diode matrixed in between. Okay. For that connector on iSpy. Yeah. Are you going to do a great search about it or like what about it? I kind of covered FPCs already. So I don't think I'm going to do a special one just for that. What is that connector called? It's just a sort of generic 18 pan FPC connector. If you look, one of our first great searchers was about FPC connectors and just instead of 40 pan or whatever, I picked pick 18. Okay. I also got the PCBs for the MacroPad RP2040 designs. This is going to have like an OLED glitter encoder and three by four keys. So we just got these on Friday. So I haven't had a chance to put them together yet, but I think I will do that soon. On our blog and on the social media, as we posted up our take on the Arduino Pro Micro size boards, but we're doing RP2040 for the Keeb community. So we're just calling it like... This is Keeb. But this is all in one. This is like a Macro. So there's a lot of keyboard stuff going on. So that'll be something to check out. Why? Because mechanical stuff isn't stopped. That's why people are like, why are you suddenly doing all this mechanical stuff? Because I can get them. There's no parts shortage. Some more keyboards. There's no shortage of chips, but as long as I can get any chip, in this case, the RP2040, I can make a MacroPad because every other component is a common jelly bean and I have enough stock. Speaking of the Keeb, so if you want to go to the computer and we can show off the keyboard design that I did yesterday night. So after a while, like I just couldn't watch SNL anymore. Like I didn't... It wasn't that funny. So I came upstairs and let Phil suffer through it. And I designed a circuit board instead. So, you know, everyone's loss is your gain. So the segment that you missed, and you can watch it online is the Pete Davidson character Chad. He was stranded on Mars. There was an issue of oxygen. Yeah. Elon kind of plays himself with that. See, I think Elon can play himself. I just don't... Yeah. He just doesn't need to play anybody else. So I think that was one of the funny ones. I'll check it out. Yeah, you can do it online. It's on YouTube. And I did think the... You know, anytime people dress up in any type of Mario characters, doesn't even need to be funny, but it looks funny. It does look funny. And that sometimes physical humor is all you need. Yeah. Okay, so doing keyboard stuff, and people really like using Adafruit boards and keyboards, and we've designed itsy-bitsies and I noticed that itsy-bitsy, the pinout never cut on with keyboards, even though I thought it was like kind of cool because it had more GPIO and it had a NeoPixel driver pin and a V High available. But it turns out people really like the Pro Micro pinout. And so I thought, okay, well, since so many people are using Circuit Python with the RP2040 make keyboards, I should make a Circuit Python happy RP2040 board. It's basically like the... It's eBitzy, but it's got the pinout of a Pro Micro. And thankfully it's actually... I always find it kind of amazing when the pins just sort of like magically fall into place. Like this is a very... This really was a very... It was like a lot of flow. Like I felt like really like it was happening because pins like zero through nine on the Pro Micro are down here. And those match up zero through nine here. Like they're like one in a row. And even the alternative function. So the TX and RX pins are like... TX, RX, SDA and STL and it's exactly the same as the Pro Micro. So it's like, even if you're using the UR or iSquert C peripherals, it's like a drop in replacement, which I thought is sweet. One thing I did change, and this is the big thing I changed with the design is that Pro Micro doesn't have a pin at the top, which I'm not sure exactly why, but there's actually like one pin gap missing. And I added it back and I made it connect to D plus and D minus because I noticed a lot of people, it's like they want to make a keyboard, but they may not necessarily want the USB-C there. They may want it to be connected to like another keyboard or, you know, I don't know. Like they want it to go through an enclosure and then there's like a panel mount. And also the old crow is always asking, like, can you put the D plus D minus pins? And I know in Pedro also I see them. They make projects, sometimes they end up extending the USB out for some reason. And so I thought, you know, as if we have these two slots, let's add the two data pins. And then I also put a jumper here that lets you short out. There's a fuse and a protection diode. And those are good, but like if you want higher current, I wanted to give people an option.  And then it's got the eight megabytes of flash memory over here, the RP2040 chip. It's got a NeoPixel here. There's a power LED, but it's interesting, the ProMicro doesn't have a D13 LED that I can notice. So for the boot button over here, I put that diode in that lets you use the boot button as a user button. So that's kind of nice. And then Sparkfun made a ProMicro of the RP2040 and they put a STEMI QT quick connect on the end. And I was like, that's a really good idea. So I grabbed that idea from them. So this is a little bit, and then it cast a little pads like the Elite-C, which is a really common keyboard microcontroller. So I kind of like, I picked a little bit of everything and I was like, okay, well, I don't really know what I'm doing, but I think this could be a good design for people. And it fits all on a double-sided board. So it should be pretty inexpensive. And there's a good ground plane and there's like lots of GPIO.  So I think this is good to go. Yeah, and we do have a person in the chat that I agree with, I've seen this a lot over the years, is the cheap clones of the ProMicros, the USB ports is ripped right off. Yeah, I've always preferred, I never liked having service mount only USB, you know, USB, micro, USB, but these USB C's, you see that there's these two holes.  It is so strong. I have Mr. Lady at a test that for me. Yup. He does that. Okay, what else? Okay, so that's this keyboard. It's called the KB2040 for lack of a better name. So that's that. And it should just come out, it's exactly like the itsy-bitsy or the cutie pie. It's like the exact same design. Just like with a lot more ground pins. And then like there's, you know, a raw pin over here. Okay, great. So that's, that's that. And then, okay. And then lastly, let's go back to the overhead for the last thing. Before we... We're gonna show the... Oh yeah. So, right. So, and also last week, we talked about this pin-up generator. And we actually got some pin-up generating this week. So, you know, we, Phil B worked on this a lot. Kattney worked on this. So the colors that are picked there, these are actually not just any colors. These are picked from a specific palette of colors that are readable, no matter what kind of color blindness you may have. Like if you have Trionic or Bio... I don't know that there's three or four different kinds, but these are like really safe colors. So they're very beautiful colors, but they're also really accessible, which is great. So we started with the RP2040. And then I've also got here, I'm working on the ESP32S2. So again, for every chip, there's always a little detail, something I have to kind of noodle around with to make it work. So with the ESP32, unlike the RP2040, one of the things about it is not every pin has every function. So you see like these pins have, this is called the power domain. So it's like, whether you can use an RTC mode or not like in low power mode. So the nice thing about the RP2040 is every pin has a PWM output. Every pin has an I squared C, and every pin has a U or every pin has SPI mux. Like they just completely cross-barred the whole thing. But with the ESP32, it's like there's some pins that are special high-speed SPI. There's some pins that are touch. There's some pins that are debug or have crystal output. So there's gonna be these gaps in between. So we're still working on that. But you can see like here, these are DAC pins, but they don't have the high-speed SPI or something. So, but it looks good so far. Like I'm liking the look. So we're gonna do some ESP32 S2, and these are the pins that are like floating. So like these debug pins are actually like right here. You can kind of barely see them. And then this neopixel pin is actually for the neopixel over here. So we're gonna have to like point to them out and be like this is a pin for internal connections, not an external connection. But so far the automatic generator is working really well. So the nice thing is like this is all fully automatically generated from the fritzing file and the circuit Python pin alias name file, which is how I determine like what we call the pin. You know, it's like what is the neopixel pin called? I know it's pin 45, but what's like the human friendly name? It's neopixel. So there's a lot of pins that have friendly names like MISO and S-Clock and VDIV and A2. So all of all the friendly names were parsing out. Yeah, so that's what we're gonna be more. We're gonna keep working on that. It's like happening. And you know, there's folks that are colorblind in the chats and they're like, thanks for doing this. Yeah. We'll always do the best job we can for absolutely everyone. One thing, and I wanna thank the community is people assume the best in us. Sometimes we don't get to everything right away or we'll be updating something, but we always go out of our way to help people. We don't go out of our way to exclude anyone. So thanks for cutting a slack. Cause like once in a while, like we'll have a graphic or a chart or something where like, oh, let's make sure it's good for everyone possible. But you know, sometimes we just need to update stuff if we didn't get to it or if we missed it. Yes. So do you want to go over to, is it great search time? No, not, not quite yet. All right. Cause I see Digikey and I'm just like, I know, but I was actually gonna look something and I realized it's not there. So let's just go to the other head real fast. We're really almost done. We're ready. That's fine. We'll scrap it off. It's your show, do whatever you want. Well, I wanna kinda make sure that we get to everything. So with the CESA boards, which I'm loving and we just got the Wodering Coder out, this is like a three year old project and I finally finished it. So the Wodering Coder, you know, we use the Wodering Coder and it gives you the values where I squared C and there's a Neopixel. Wonderful. You know, we just put them in the shop. We're gonna be making more. The chip that's used on this is the Samdio 9, which, you know, until a few months ago was like extremely plentiful, like water, raining from the skies. You could get Samdio 9s. You had these very inexpensive Cortex M0 chips. I really loved them because they were very fast. They had a lot of RAM, a lot of flash and were very inexpensive. I was getting them for a great price. I got a great price from Microchip for them. But then you can't really get them anymore. So I have some stock, right? I have, you know, I don't, I'm not like the car companies. I buy stuff and I broker it ahead of time and like we have some coming and we have stock, but I have a huge pile of all these seesaw type boards, not just the Wodering Coder, but I wanna make one with like this encoder and I wanna make one with like a joystick and I wanna make one. Like I have all these like little Y squared C to button thing, you know, again, mechanical stuff. And the chip itself is, I'm a little hesitant to design, if I'm gonna be designing the PCB, I might not pick a chip that I know I'm gonna be able to get a lot of. And, you know, I looked at, we tried about this, I looked at the MS51, which is the cheapest microcontroller on Digikey. Like you search for like, microcontroller with like eight to 16K of flash, nothing is cheaper than this. It's 30 cents. It's like dirt cheap. And it has some nice benefits. This is also a chip that Pameron uses in there, like I squared C. They have a seesaw like thing, which I don't know what they call it inside, but it's not open source, I think, but it's like, it's an MS51 if you look and then they write code on it to do I squared C stuff. One of the things that's nice about this chip, other than the fact that it's 30 cents, just like amazing. And I'm sure you can get even cheaper if you go direct or you have a broker, is that it can do three or five volt logic and it's five volts safe. So, you know, one of the things that I have to do on all these boards is because people are using these with an UNO or they're using with a mega, they're powering with five volt and they're using five volt logic. So I have to have a logic shifter and regulator and it would be kind of nice if I could skip those. Again, I have plenty of regulators and shifter chips, but like it is an extra 30 cents ish, 20, 30 cents. And it's another thing that I won't be able to get. So I got this dev kit and I was like, yay, I'm going to get this. And then of course, like all the MS51s disappeared from the face of the earth and the lead time is two years, which is... What's a seesaw for the folks who don't know what seesaw is? Oh, seesaw is the firmware that is on this little chip that reads the rotary encoder. It's a microcontroller, it reads the rotary encoder and then it has an I-squared C interface as a peripheral. So you can read what the value is. So it's a like I-squared C to anything converter. So it's a firmware so that, you know, because like an I-squared C and non-digital converter is like, it's like a dollar. It's like, it's cheaper to get a microcontroller programming with your custom firmware. And for stuff like this where it's, you know, you don't need heavy duty specifications, it's good enough. The problem is that the same DO9, like I said, it's evaporated. So I looked around and I was like, I spent like an evening and I was like, what's a chip that I'll be able to get that's inexpensive and five volts? Friendly and so far, I think the thing I found was the AT Tiny 817 and 816 in that series. So it looks like there's gonna be a lot coming into stock at DigiQ soon. Like I kind of did the thing where I, you know, I checked the lead time, it's three to five volts. It's got I-squared C peripheral. It's one of the new AT timies. So one thing that I thought was really neat. So the programming chip, I thought like, oh, does it use like the SPI? It actually doesn't, this is SPI, but it's not, it doesn't use this for programming the chip. The chip is actually programmed with an asynchronous serial protocol, which I thought was really smart because you don't need special hardware to do asynchronous serial. You just need one resistor and a serial port, which means that I could, even without a boot loader, you could plug in, you know, I'll look maybe I can write a boot loader, but you can plug in to these pins and maybe short a jumper or two and then use the same wires connected to, you are on my controller to program in the chip, like raw, like program the chip completely, even if there's no boot loader on it. So I thought it would be kind of neat in case people wanted to upgrade the firmware on these little boards or like, you know, somebody finds a bug once in a while, I can fix it and send them new firmware. So I'll do a great search about how I found the 817, 816, but yeah, I think this is going to be what I want to use. And I think I'm just going to have to redesign the boards before I get them into production because I do have a stash of Samdeo 9s, but I don't know, they're going to last a whole year, especially if I come up with like 10 new products. All right, speaking of stuff out of stock, it's time for the great search. Where are you? The great search brought to you by DigiKey and Eat A Fruit DigiKey, thank you so much. More so than ever. The great search is now becoming the most popular segment across all of our shows because before, back in the time of Plenty, it's like, oh, why do you need a search for anything? You can just find chips everywhere. They grow on trees, not anymore. So we tweet at us and use like Pound, the great search, or At Us, At Eat A Fruit, whatever ways, let us know what you're looking for. And we're also out there helping people. And we saw- We see things, we help things. We saw this one. You want to start with the tweet? Yes, so we saw Tobias tweeted, and there's lots of Jerry who had like a headache-y gif about like how she's working on design and can't find a part. And Tobias says, welcome to the club. Anyone, TPS 27081A for 15 bucks a piece, usually 30 cents a piece. So they're talking about how brokers are, you know, have seen this. Like some brokers are what I would call ethical. It's like they'll charge a little bit more because it's rare, but they're not going to charge a ridiculous amount. Or like we're seeing 10, 20, 10 prices. I like not putting people in, you know, you can resist anything from, but temptation. And so I think right now there's a lot of temptation for a lot of folks who do broker in your parts to charge whatever. No, I have to actually redesign a couple more.  But it's like, okay, I'm not paying $15 for example. I've seen it, I've seen it. I've had people quote me like five, six, seven, eight dollars for parts that I'm like, that's a 70 cent part. Like, I can understand like, hey, 50% more, you know, ooh, like I wanna make a couple bucks, but I'm not gonna pay it. Like if they find someone great, but I'm not gonna pay it. Okay, so what is that? And I'm saying you shouldn't pay it either. Instead you should tag us on social media and we'll find you an alternative. We'll find the alternative and that's one thing. Just because it's not the same part number that you're used to doesn't mean- Correct. It's not something that you- Sometimes the part number is similar, but sometimes it's not, I don't see here. So this part is an I2C power switch, normally 35 week lead time out of stock completely. And yeah, it used to be about 30 cents a piece. So look at the data sheet and so we can see what we're dealing with here. Cause I've never used this part. So this is a 1.2 to 8 volt, 3 amp P-FET high side low switch with level shift and adjustable slew rate control. So basically you can use this, there's a V in coming in and then there's a GPIO logic high and low.  So it's basically like it's like a P-FET but it's like it's got a little bit extra in it just to make it special. Also it's 1.2 to 8 volts and it's 3 amps. Now look, I may not be able to get you the exact same part but maybe it's within the specifications you need. So let's use and I wanna highlight there's a couple things. So there's new up here right below, not in stock. You can sign up for start notification where they email you, which we did on Adafruit so I hope they were inspired by and also find similar parts and they tell you how to use the similar parts tool which I will tell you as well. So let's look. So what do we want? So we want an active part. I don't want to say general purpose because I actually don't know. We do want it with one output because we want it to be pin compatible. We want to be one to one high side. I think I want the interface to be on and off but I'm not sure. Voltage I'm not gonna select because there might be a wider range or a range that's close enough so I'm not gonna be too specific. Same with the current. I'm not to be too specific. I do want surface mount and I do want it to be in SOT 236 or T SOT 236. So let's be similar. Okay, so another thing is down here. These are now all your specifications that you picked are also available down here that you can turn on or off specific ones or you can delete the whole thing so you can see more clearly what you searched for. So we're gonna be very picky. We only want ones in stock. Okay, there's only 13 similar-ish parts. The output type. So let's look at this chip again to see what is the output type and it says it's a PFAT. Okay, so let's go back here. XP channel. Okay, there's eight. Current output looks like there's a couple options. Voltage load, I mean, I think other than the 5.5 so the 5.5, I mean, it might be good enough but I'm going to assume that they want up to eight volts that usually the high limit is what they want. So I'm gonna turn those on. Let's look at more filters. Okay, so we have actually quite a few options, right? So this is really good stuff and a lot of them are in stock. So let's look at, they're all on off. So it looks like we have a couple options, a couple of different current options. So since we have a couple of different current options, I'm gonna start getting picky and I'm gonna say the other one was a three amp. I'm gonna assume that this person needs something that's about three amps. So I'm gonna pick only 2.8 and 3.3 amps. Okay, so here's the two that came up. One is almost the same, 1.8 to eight volts. Another one is 1.5 to 12 volts. They both have an RDS on of about 40 milliohms. Checking this data sheet. Yeah, you know, 40 milliohms or so, that sounds about right. And this one has slew eight control, although I'll say sometimes features aren't complete. It depends on the person who entered it in if they like were, you know, they filled in everything. So I always take the features as a grain of salt. Always check the data sheet. And the pinout, the package is the same, which means I can have a check if the pinout is the same. So these are both pretty cheap. So let's look at the V-shaped part first. So the V-shaped part, so here's what I always like to see. So the application circuit, see this? It's basically the same as this. It's very similar. There's the R1, there's the VN on off, R2. VN R1 on off. What's slew? Slew is how fast you want the current to go in. It's a current limiting thing. If something is slewed, it means it's gonna slowly ramp up. If you have high slew, it spikes up. There's times when you want it to react very fast. You want a lot of current and sometimes you want to reduce your inverse current because it could damage your components. Use slew in a sentence like that. What? You slew in a sentence. Like I want more slew because or like oh, too much slew. Last week we talked about op-amps and we actually wanted a high slew op-amp because we want it to react to volume changes very quickly. High slew. High slew. Okay, so for this one, you see the same pinout, two and three are V out, two and three are V out and one is the bottom of this. Looks like, yeah, another MOSFET. So yeah, this one and then there's a return. This shows the internal resistors but this looks actually almost identical. I mean, I will tell them, you know, you go and of course check that all the specifications match everything but this is very, very promising and there's 12,000 in stock and then for this one and notice that the part numbers are totally, sometimes it's like, oh, an NE555 or TI555 or an LM555, they all have the same part number. They have different prefixes. These have completely different part numbers and prefixes and that's not unusual. Don't, it's nice when they are but it doesn't necessarily mean it's bad if they're not. It just depends on. Yeah, everybody, we're all gonna have to adapt at least for a while. You gotta be flexible. Yeah, just because it's not the same part number doesn't mean you can't use it. In fact, that's gonna stop a lot of other people from either getting the parts they need or maybe even some changes to their design. You gotta be, you gotta stretch. Yeah, gotta do some flexing. This one also RDS on, you know, you see the specifications and then you can see down here again, the same thing. There's an input, two pins on the output. Pin six is, you know, you can connect to a capacitor out here. One is, this one has five. Yeah, one is from the bottom of this FET. Five is to the on-off gate and VIN is on pin four. So this is actually one of the times when like there's actually two looks like good options. Both have about 10,000 pieces of our stock in Digki right now. And they're like 30 cents, 20 cents, even cheaper. So, you know, if you can't get that TI part. Or if you're getting quoted like- Seven bucks. 10 bucks apart. Don't do it. Don't. Look, sometimes I agree. Sometimes there aren't any alternatives, but I'll say something. I've actually, other than very, very specific chips that are like, okay, yes, it's a one-off. Only this company makes this particular microcontroller in this package, and you need that exact microcontroller. No, you might not be able to get that. But analog and linear components and power components, there's probably something out there. There's probably something out there. You're not out of luck. There's gold at the end of the rainbow. So that's the great search. So check it out. Send us your great crises, your build material crises, and we'll help fix them. Where? All right, and then just a little slide now. Yes. Telescope mount terminology refer to slew rate, which is how much angular motion per second it can move. That's the same thing. This is actually, it's the same rotational motion per second, but the rotation is the, it's numerically in the imaginary plane, or the voltage plane. Like it's rotating, but it's not physical. That's in a voltage. Or current mode. Okay. Okay, great. That's our show for tonight. This is Descalade data. Thanks, everybody. All shows during the week. We have JP's product pick on Tuesday. 3D Hangouts on Wednesday. Show and tell. No one paid, we're gonna be hosting show and tell. We're gonna be doing Ask an Engineer. And then Thursday, we've got JP's workshop and Friday, deep dive with Scott. So full week ahead, tons of things and we'll be broadcasting. Ask an engineer from the Adafruit factory. Soon. Once again, very soon. The only reason we're not is because our shift overlaps with the team. Now we're all vaccinated and we're past our two weeks, but we're still setting a good example. So when we do video broadcasts, we do, we will take our masks off. So we wanna make sure that everyone's out. So it's just Lady Aida and I. And we have ventilation and all this stuff. We just wanna continue set a good example. And then for the teams that are still around, if they're fully vaccinated and they're after their two weeks or one month, we'll start to work with them. And then over time, it'll be as normal or whatever normal is that we define together going forward. So we'll see everybody soon as the show is during the week. Thanks for spending your Sunday with us. Thanks everybody. See you everybody. Bye. Next week.


Hello everyone. Welcome back to another video. In this tutorial, we're going to be revisiting our most asked question or most asked question about function, which is the VLOOKUP function in Excel. But before we do that, can we just ask you a really big favour? Ask you to smash the like button on this video and also subscribe to the channel and hit that bell notification so you're notified of all of our future videos as they come out. If you could give the video a like, it's greatly appreciated because it not only helps us out to identify what content you want to see more of, it also helps out the channel in terms of the YouTube algorithm. So obviously in our time, we're going to reach more people and help more people to get the solutions that they need in Excel. So if you've done that just now, thank you very much. It is greatly appreciated. So the VLOOKUP function is probably one of the most common ones that are getting used day-to-day by many users, whether they're beginners or advanced users. And it's one of those ones that it just brings so much value and makes things so much easier when you're especially working with data and you need to merge particular data sets together. For our example, we're going to look at quickly here. You can see we've got some source data in this range here, ID, first name, surname. And we just created our sort of basic skeleton table over the left-hand side here. So we've got three of those IDs and for those IDs we want to pull through the first name and the surname. So we're going to jump straight in with using the function. In order to do so, you just need to hit your equal symbol and then do the VLOOKUP or type VLOOKUP and then hit open brackets and you will get the prompts to everything we need to provide into our VLOOKUP function. So the first thing we need to do is select our lookup value. For us, it's going to be the ID because it's a unique identifier in both the set we have on the left here and our data set in which we want to source data from. So once we've selected that, the next thing we're asked to do is provide the table array. So the table array is just selecting all of the data that you wish to look or search for your lookup value in and return another piece of data that corresponds with that value. For us, all we need to do is just select this table here of ID through to surname from the first to the last row. And all I'm going to do is just use the dollar symbol in front of the column and the number for each start and end cell reference. That will just lock that range so as we drag our formula down later on, it will always make sure that this table array remains the same. And we hit column, having it comma sorry, we move on to the column index number. So as you'll see above our range here or our table array to keep it consistent, I've put the numbers one to three. So what those numbers relate to is the columns within our table array. So ID is classes number one, first name is classes number two and surname is class is the column index number three for our range or table array. So for us, we want to pull back the first name. So all we need to do here is enter the number two to indicate to our function that having found our ID, so ID 02, it'll come down here in the first column. And then move across to identify the name Hannah being the second or second column index number that we wish to return our value. So once we've done that, we hit comma again. And lastly, we just need to enter a true or false value here to indicate to our function how we want to search for ID. So we can either have an exact match or an approximate match. So we always advise using the exact, especially when you're getting started, because it will ensure that it finds an exact match of your ID in your search range here, rather than something that could be less than or greater than or be slightly a match to our desired value. So all we're going to do here is enter the word false and close our brackets. Okay, and then having done that, you can see that our first name of Hannah is now populated correctly into our first name column. If we now pull that formula down, you can see that our range remains the same and locked to G5 to I11, but each of those first names have been updated as we pull it down. The real quick way to then try and to get the surname is all we need to do here is simply copy the formula we've put in already. Move across the surname and then populate that into the desired column of column C and hit enter. So at the moment you can see we've got Hannah in both the first and the surname. All we need to do to jump across the full surname is change the column index number, which is this time going to be three for the surname. So all we need to do is just change the two to a three, hit enter, copy that formula down, and you can see we've now successfully pulled through the first name and the surname. So that's great and obviously it's when we've got data in the same sheet. But what if you want to pull data through to our table and let's say let's put in here phone as in phone number. Let's say we want to pull through phone number but it's not within the same sheet, it's in a different sheet within Excel. All we need to do is we can see in VLOOKUP2 sheet that we've got a slightly different data set here and we've got the ID, name, surname, but this time we've also got a phone number and excuse the number that's presented there, it's just a random number generation just so we've got something to pull through. So all we need to do this time is the same equals VLOOKUP, open brackets, select our lookup value, what's going to be exactly the same because it's obviously still the ID, hit comma, and then this time our table arrays in a different sheet. So all you really need to do having got to this stage of the VLOOKUP function is navigate to your second sheet, highlight the same your table array, but for what I'm going to do you can literally just highlight each of those columns because there's no data beneath or above our data range that's going to conflict with our search results. Do comma and this time of phone in this table here is going to be the fourth column. So all we need to do is enter number four and lastly enter the word false so that we get an exact match. And once we do that, we can pull this information down and we can see it successfully pulled through a number for us. So to do a quick check, let's look for ID four, it should be Claire Smith and it's 98764. Let's find Claire Smith 98764. So it's pulled it through exactly as we require. So there you go. That's a really quick look at how to use the VLOOKUP function in a couple of examples. We hope that did answer any questions that you do have, but obviously if it didn't answer your questions and there's anything we're missing or we may be skipping over, drop us a comment below this video or reach out to us by one of the links in the description for this video. So those are Facebook and Instagram. And there are also great platforms as well to be identified of when new videos are coming out onto the channel. So once again, if you haven't already, please do give the video a like and subscribe to the channel. So obviously you receive all those future videos. And obviously again, as you mentioned earlier, giving the video a like will be greatly appreciated by us. So thank you very much for watching and we shall see you in the next video.


The ELEG exoskeleton is a novel semi-passive lower limb exoskeleton designed to provide assistance for workers performing long-term static squatting tasks. It uses motorized tuning of the assistive squatting height to maximize its effectiveness. Additionally, it incorporates inertial sensors and an electromagnetic switch to measure the tilt angle of the thigh and adjust the squatting height respectively. Experimental results showed that the exoskeleton reduced muscular activity and had no significant impact on the normal gait of users during walking. Overall, the ELEG exoskeleton has the potential to be effective in reducing muscular strain on long-term continuous squatting activities. This article was authored by Yaotu, Ibeen Zhu, GUN Song, and others.


Kia ora koutou. We're going to get started because we've got a lot to fit in this morning. I'm delighted to welcome Tim Sherritt, the Associate Professor of Digital Heritage at the University of Canterbury, a historian. Oh, sorry. University of Canberra. Close. You can see what I did there. Come to New Zealand. MDF is from University of Canterbury. He's a historian, a hacker. He also researches the possibilities and politics of digital cultural collections. He's also a seasoned presenter here at MDF and spoke as a keynote in 2012. It's so great to have you back, Tim. Come on up and tell us about data and stories. Thank you. Thanks, Fi. Of course, again, I said yesterday, I'm glad to be back. I always love coming to MDF. It is my favourite conference around the world. In 2012, it was actually a keynote. I did with Chris McDowell where the MDF organisers challenged us to make things and present them on stage. I did. I made a hacky demo of how narrative text could be enriched using linked open data. It was riffing off some stuff that Chris had done and John Voss, the keynote the previous year, had done around linked open data. That was 2012. I've made several attempts at taking this further in the years since. Most of which I've given up on. The latest version is shaping up okay. I still think it's important. I thought it was a good time to bring it back to where it started here at MDF and talk about where it's at. I suppose this is also my little reminder that not all data has to be big. Not every digital project has to finish in a sprint. It's a story of small, simple technologies and slow-burning passions. Let's just start by stating the obvious. Linked open data is about making connections. There's the connections between things, so relationships between people or between a person and a place, the subject of a photograph, all expressed in a nice, structured, standard form. That's the linked part of linked open data. There's also the connections between the people and organisations that create linked open data and those who use, enrich or explore that data. That's sort of like the open part of linked open data, the share ability. I think it's fair to say that more effort has been put into the connections between things than the connections between projects, users and audiences. Interestingly, both these types of connections are dependent upon context for their full richness and meaning. The fact that two people know each other or that a person was in a particular place at a particular time gains meaning within the context of a specific story or argument or narrative. Likewise, what we share and how we actually share it depends on the sorts of audiences and the collaborators that we want to connect with. It's the specific contextual character of these connections that really interests me. How can we explore linked open data within the context of a particular narrative, a particular story? How can we use linked open data to connect to different audiences to expand the reach of our research and our collections? Rather than large-scale production of linked open data data sets, I'm interested in this small-scale creation and consumption and capturing pockets of interests and expertise in sharing what we know. I'm a historian. My argument is that historians make linked open data all the time. They just don't know it. Think of a normal historical research process. You're gathering information about people and places and events and sources and you're going to great lengths to try and understand and define and document the relationships between all those sorts of things. But then we get to that process which, for some reason, we call writing up. In that process of writing up, that data gets squeezed out. All the richness of those relationships that you've documented. Sort of get chucked out as you gradually build your story. You may glimpse their ghostly remnants in a footnote, but that's about it. In a way, that's a good thing because that's part of the skill of being a historian is being able to take all that mess of data, all those relationships, all those things and create a compelling narrative from that to be able to put that in a form of a story which communicates something significant to your audience. But why can't we have both? Why can't we have the story and the data? And that's really what this is all about. James Minahan was the Melbourne-born son of a Chinese father and white Australian mother. When he was five, James' father took him to China. When he returned to Australia 26 years later, he was arrested and declared a prohibited immigrant under the White Australia policy. But was James really an immigrant under the law? He'd been born in Australia. The case ended up in the High Court of Australia and continues to have resonances today when, of course, we're still having these questions and debates about who belongs. Kate Bagnell, my partner in many things, recently published an account of the James Minahan case in the journal History Australia. But the story is so rich in detail and in order to actually have it accepted in a conventional academic journal, Kate had to cut back on the narrative parts and boost the theory parts in order to get it in. So we're working on another version of this story, a lot of book version, which puts back all of Kate's narrative and adds in much more in terms of people, places, relationships and resources. So let's have a little look. As the theme of this talk is basically why haven't I done more over the years, this is all sort of unfinished, it's very rough demo, but hopefully it gives you a bit of a sense of what we're trying to aim at. You'll see at the bottom of all these pages a little note saying it's going to be published completely in September 2018. We're keeping up there with our total missing of all of our deadlines in this project. Anyway, it doesn't look very exciting. It's basically just text and that's deliberate. You know, I want to focus on the text to be central to the experience. And as you scroll down the page, little things wobble and do stuff.  So you're getting a sense there's a relationship here happening between the text and what else is going on and hopefully it's encouraging you to start to explore.  And so we've got people and places and eventually if playing around you'll probably notice that some of the things, the colours represent different things so we've got people and we've got a place here different sorts of resources. When you click on a footnote we get a nice footnote, you click on the link and we actually get the resource that's referred to in the footnote. All of these of course link through to more details about those things. So we click on there, we get lots more information about James Minahan. We start to see the sort of detail in terms of relationships within this story and of course you can navigate any of those relationships to see more about that sort of person. We see the resources, the documents that have been used in the story and where they refer to parts of James's case. And you've also got, going back the other way, we came from the narrative through to the data but of course we've got here, you can see where that particular person has mentioned within the narrative text and you can jump back the other way to see where the context of that is. So the aim is to start building up that sort of relationship between the conventional narrative text and the data underneath. That sort of enables you to move fairly easily between the two and to explore the relationships that are there. If you just want to read the text you can just read the text if you want to dive in and follow the relationships you can. Of course there are various ways that you can then start to navigate that so you can just have a list of the various types of things so the various resources that are used in this and again which, so this is a particular document produced by the High Court of Australia in the National Archives and it gives you information about its context in the archive so you can follow to see what file that was in and things like that and look for other things from the National Archives of Australia that are used within this resource. So it's also an interface to the different types of institutions which have contributed material to the resource. So they have fairly conventional sorts of lists but you could also view it other ways so we could just throw everything onto a big wall. So these are all the different types of things which are currently in there the people and the places and the events and everything, still lots to put in. So you can just sort of navigate it that way as well and of course you can just fairly easily throw the places onto a map and see what we've got going on here. Milben, that would be exciting.  But you understand that you've got that sort of network of entities of people and places which are sitting underneath there and you've got the narrative text sitting on top. Now what's also going on is all that information is being provided out to the world in a nice structured format as linked open data. So as an interface it's just something that people can use but of course for something that is we also want to provide something that computers can understand, can read. And on the bottom of every page the data is all in there so you can click on there it's sort of a little API pretend API in terms of delivering the structured data within that page it's also embedded within the page itself but available as a separate file but you could just put .json on the end of every page every URL and get the .json structured data out of that thing as well. Okay, so that's the little demo. And I won't do it now but if you take one of those pages and feed it to there's a thing called the structured data linter which extracts structured data from a web page so if you feed one of those URLs to the structured data linter you get back a long list of the things and their relationships and their properties just to prove that all that data is actually sitting in just that normal old page. Now obviously yes our September deadline has gone but we're still aiming to get that version in of James Minahan also working on some other things so I'm involved with a project on aviation heritage at the moment and one of our outputs from that will be a logbook relating to the history of civil aviation in Australia and that'll be pretty cool cos it's relationships between places airfields and aeroplanes aeroplanes that have really good identifiers cool so we can start to sort of look at where airplanes were and who owned them and did all that sort of stuff which will be fun. Now since 2012 you know one of the reasons why I haven't done more this is my excuse that's why I'm late with my homework is that I sort of assumed that it was such an obvious thing to do that somebody with more money and better programming skills would actually do something much more exciting and interesting so why should I invest too much time and certainly there have been some interesting developments since 2012 and you've got new platforms for publishing which embed all sorts of new possibilities things like scalar and manifold in particular a Mecca S I mean assume you've all heard of a Mecca but a Mecca S the S for semantic ads is a new version which came out this year and adds a whole lot of great abilities within a Mecca to not just upload items but to define relationships between them using standardised vocabulary so basically to produce linked open data you can get the output out as Jason LD which is a structured way of sharing linked open data the one down the bottom there is really interesting Doc Keely which is basically an editor for creating texts with linked open data so it sort of does some of the things that I want to do but not quite but it's still something to certainly keep an eye on if you're interested in this space really it's not that I want more it's really just that I want less I just want simple and that's been one of the motivating things throughout this and I set myself some basic ground rules back in 2012 around using simple tools and that's still really important to me the fact that you can create linked open data without a triple store and what you're seeing here in this demo is just static HTML pages with a bit of JavaScript bells and whistles on top there's nothing fancy about it so it's really just a case of it's using these particular tools you just basically start with some data and that could come from anything really it could come out of a mech or S it could come out of a triple store as I can get it out in Jason LD and then do a bit of manipulation and load it up at the moment the stuff for James Minahan is sitting in a series of Google Sheets as Kate's sort of continuing to update it and I just sort of run a script to pull that out and get it ready and plug it in Jason LD as I said is a way of sharing linked open data using Jason which is a way of sharing data in text formats which developers are all very used to so it's a very convenient way and it's probably been the most significant thing which has changed since 2012 has been the sort of development and uptake of Jason LD as a way of sharing and embedding linked open data so the data for this if you want to you can just create it in a text editor as a YAML file which is another way of representing data in a text file so basically you could do all this just with a text editor and of course then you have your text itself and you can use a tool like pan doc to take your Word document just run it out get it in a markdown format which is a text format and then you just define your relationships between your narrative text here and your data file by there's some little tags in that text there which sort of look like that then you feed your text and your data to a static site generator called Jekyll so that just takes all that stuff and spits out a whole lot of HTML pages so I've created a plugin which takes that data file creates an HTML page for everything in that data file and defines all the relationships between the different bits and pieces and then there's a Jekyll theme that I've created which does the sort of JavaScript doodads or the things that wobble and do stuff on the page but there's no reason why you have to have that theme in the end at the moment they're all sort of lumped together but in the end that should be separate the plugin that creates the relationships and the documents should be separate from the way you actually represent that you don't have to have wobbling balls that sounded much ruder than I expected as I said the result is just plain old HTML that you can upload to any web server and the data is embedded within those pages as JSON-LD so no databases, no platforms and this is really important to me in terms of preservation and sustainability you can zip up the whole thing plonk it in your repository and then you know sometime later somebody can unzip it open it up and it will work I'll save you from the story of Lodbook 2 you might be wondering about what happened to Lodbook 2 it's gone missing in action basically because I tried to sort of adopt the new coolness in terms of building it in Angular and ended up in a totally space that I didn't want in terms of the ability to sustain and preserve it OK but wrapping up there's a question here and that's the why bother question I mean you have to put a bit more work in here to make sure you've got your data in a form that you can plug it in and do all that sort of stuff and why would a historian bother with that when they can submit their article to a journal and get their brownie points and that's all good so what's in it for historians why should they care about linked open data and perhaps the answer to that is linked open data the linked open data should support them to do new and interesting things, not the other way around so for historians the point of something like Lodbook is not to create linked open data because why would they want to do that but to expose their research in interesting ways ways that bring the richness and complexity of the work that they do to the foreground that offers new opportunities for engagement and new audiences just build in, just add a bonus and of course it's the preservability that I mentioned before that your data and your text stay together but there's a bigger picture as well and that's instead of dumbing down our publications in order to fit into a PDF we can open them up to new connections I mean our James Minahan Lodbook of course is going to be linked out to resources in a range of different cultural heritage institutions so to the National Archives there's all sorts of stuff we can move from PDFs to portals what I want is historical narratives to be contextually and critically rich gateways to our cultural heritage collections every publication should be a finding aid I want publications that are not just the final output of a research process but starting points for many journeys of online discovery and there's some cool other cool developments things like web mentions and link data notifications that makes it conceivable that cultural heritage institutions could be alerted when their collection items are used in these sorts of contexts and they could then retrieve the linked open data the nice open structured data, grab the web page parse the data out and ingest it into their own systems collections would then become embedded within a structured web of scholarship and storytelling okay, it's not going to happen quickly but that's alright stay tuned for the next instalment in about 6 years time thanks very much and I should say that I did share these slides via the NDF Twitter stream if you want to grab the links in it we've got a little bit of time for questions if there are any questions Kia ora Michael it's on, okay, thank you can you talk a little bit about the pipeline of data you showed a little bit of the markup and I'm thinking in terms of authoring environments and writing this so two aspects one's just an ease of use of how easy is it to write something like this if you were doing documentation but there's also the aspect of how are you getting the data into this that last jump yep, so I sort of wanted to leave it as open as possible in terms of possibilities for getting the data in so in terms of what it expects to see in terms of the and it can either Jekyll will pick up automatically either Jason or Yamal so that's the sort of format it's expecting that my plugin expects things to have at least a schema.org name and type and so that's the sort of very base level requirements so conceivably as I said at the moment our data for James Minahan is just sitting in Google Sheets because that was what was easiest for Kate and her research assistant to be plugging stuff into and it's easy enough to get the CSV and process just do a little manipulation of that to get it in Yamal so I mean there's a custom script involved there but I could set up a sort of shared Google Sheet with a standard script which would enable people to go down that route if that's what they were interested in similarly I've got some templates which use AirTable so you could which is a cloud based database thing so you could actually use that as an API I can pull that out fairly easily and make it available so I'm trying not to say that this is the method that you should use for creating the data but leave it as open as possible and this may be again because I'm just lazy and but again but I did want it to be simple and as much as possible around people's research practices rather than saying well this is the technology, this is the way you have to do things in terms of the text, the south and area text itself well you know you can just write it in Microsoft Word and then use Pandoc to get a markdown output and add in the tags so that's pretty straightforward too Hi Siobhan Hello, we finally met Yes, well we'll get to talk later I'll come stalk you later Have you seen the work that JSTOR Labs is doing? They recently JSTOR Labs they're reimagining a monograph and when they did that project my brain was exploded basically by it and it just seems very similar to the type of work you're doing here and I was wondering if you could comment further if you know that work No I don't but see I always said somebody else would do it They haven't actually done it, they've just explored the possibility and it was about yeah the same very similar themes streaking from both these projects that you're talking about, yeah Yeah, no I haven't seen that one in particular but yeah I mean certainly there's a few of these sort of reimagining exercises going on around the world at the moment so I think there's one is it University of College London or one of those UK institutions too that's a really publishing platform and I mentioned Scala which enables you to have that sort of non-linear narrative and rich media and that sort of thing embedded within your publication They also did an original project right at the start about a Zambezi expedition which pulled in a whole load of research from images and specimens it just blew my mind I just wish more people were doing this Yeah and there's Manifold as a new one which similarly enables you to sort of have those very media objects with your text as well so I think there's lots in that space and maybe I'm stupid for doing my own thing but I do sort of think I mean what I'm trying to do is like I said it's sort of simpler really and I still do want to have the sort of narrative text at the foreground but have those other layers as well and I think there's some value in scaling these things back to simple processes I'd love to be able to do it and I don't know how I mean I look at something like Manifold and it looks really cool and then there's like the installation instructions are about that long and you've got to set up your server and you've got to have all this sort of stuff and they'll send somebody out for a day to help you and I think I don't really want to do all that and then it comes back to those preservation issues as well which I also think are important in terms of designing new platforms and how do we sustain publishing platforms over time which means that the thing's actually going to be readable Thank you Thanks Tim, I was just wondering if you're the Jekyll pipeline you could add in extra checks like the linter and to check that the links resolve the general links that kind of stuff so you could kind of make the pipeline more robust Absolutely, yeah Yep, no reason why you couldn't I mean you know there's good Jekyll's built on Ruby, there's good libraries you know linked up in other libraries for Ruby which enable you to do that I mean I do need to you know it does a little bit of checking just in terms of the sort of structure of the data obviously in order to make it work but there's no reason why you couldn't do more like that and the other thing I see you know as you're doing it you're going to be linking out to other identifiers for the different things as well whether they're being wiki data or anywhere else and the other part of the theme which I haven't put in would be pulling stuff back at the load time using JavaScript in order to display material from those sources as well to integrate it further and to make that stuff available but I see that as sort of a presentation part of it rather than just defining the relationships in the data and presentation possibilities Kia ora Tim, thank you so much I have to admit it's great to see a lot of my team here because and they will tell you that I've been a bit cynical about linked open data and how much focus there is on getting the tech perfect and right but what you've done for me today is actually show how it's useful and the point about historical narratives being to be contextual rich gateways to our collections and actually seeing an example of that has been a bit of an aha moment for me so thank you take note team and thank you very much thank you very much


Greetings. My name is Jacquela Maidana, and I'm running for Amherstown Council in District 4, formally Precinct 5 and 9.  In 1974, I moved to the Valley. My children attended the Amherst public schools, and I went to the University of Massachusetts, receiving a bachelor in fine arts and my master's and certificate of advanced graduate study in counseling psychology at the School of Education. I then went on to teach at the University for over 20 years. I became a town meeting member in the 80s, and then again in 2014. As a town meeting member, I felt that I had a voice in town government. By talking to people all over, I felt that I could make an informed decision when voting. As a new counselor, I will continue to be that voice. One of my concerns is the new, oversized dormitory-like buildings in the center of town. I'm not against progress or growth, but I want it to be humane and organic. The town appreciates the fact that it is about developing affordable housing for low and moderate income families and seniors. The new council will need to be careful and carefully prioritize what we want in our future. One of the capital projects also concerns me is the state of our neighborhood schools, school buildings. The need to remodel Fort River and Wildwood seems inevitable. The open concept schools did not work. I know because my children went to one of them. With today's technology, there are companies who have successfully remodeled this type of building. It will lower the costs instead of destroying the existing buildings. This is doable. The firehouse in the center of town is also a major concern. It also needs to be remodeled, not destroyed. Remodeling is a much lower cost than a new building, and it will have a lower impact on the environment. Putting in a substation in South Amherst would balance out the town's coverage and keep the main station right where it belongs. The DBW has been in need of remodeling for several years. This is also doable. It doesn't have to be an enormous cost. The library, this is also one of the issues that we've just simply finished paying off the last renovations, and I feel that it's important to utilize the space in a better way. So, although I'm a renter, I've been a homeowner, I know how difficult it can be to balance a budget. I believe in getting involved to think globally and to act locally, and that means I will work hard on your behalf. This new form of government will have enormous power and will bring with it new challenges for the town. I want to be part of the solution, and that's why I'm running for a seat in the new council because I want to have a voice in the future of Amherst. Vote for me, Jackwell and Maidana, on September 4th in District 4. So, that means you're still going to be voting in the same location that you've always voted in, but this is now called District 4. So, I appreciate this, and I appreciate having the opportunity to speak with you today. Thank you.


Kim, nine years ago, we sat in these very seats and recorded a video all about our lives as YouTubers. Fact? Nine years. Fact. And it's like, I don't, I don't, there's a whole game about the lavish lifestyle of a YouTuber. Meanwhile, this is the same shirt I wore in the last video like three or four years ago, yeah. This is my lavish lifestyle. I can't afford to get a new shirt. That's not true actually.  He only likes five shirts. He buys new clothes every month and then wears the same five shirts. I don't need to be called out right now. They made a sequel, Kimberly. The first one must have been such a banger that they, I did like it. You played it after we finished the video. I don't need to be called out a second time in this video. We're going to try and create yet another successful YouTuber. Okay. Did you know that Bob Wolf and I had a podcast? Yeah. We've been doing a podcast. You can watch that on Nintendo. In fact, you're in one of the bonus episodes on the Patreon. It's a great time. Is the podcast good, Kim? Yeah. Yeah. This used to be me, except not an anatic. Oh, wait. Oh, it's meta. They're playing the first game. Congratulations.  I didn't actually finish that game. No, you didn't. A social experiment to find the most promising future. Really? That's what it was.  I know. I'm kind of freaked out. We're giving you a golden ticket to come live in New Tube City. I was, I like the name. If you accept the invitation. What about just taking back the titles?  If I don't accept, do you accept the challenge? Nah.  I want to make that room. It's a baby Groku. And a weird switch, like a fakie switch. I like that. And a piranha plant. There's a lot of Nintendo little, there's like a Minecraft thing. Little creeper with legs.   We should probably microwave one of those factor meals. It would only take a couple of minutes and they're delicious. They really are though. We should go do that right now. Let's do that. Welcome to everyone's favorite game. Who can prepare a home cooked meal quickest? Fitness starts with food and factor makes it possible to hit your daily goals with nutritious purposeful eating. Factor offers keto calorie smart chef's choice vegan and vegetarian options, which includes seafood, meat, and even plant based options. Factor supports wholesome eating made simple. They have over 27 meal options and over 33 add on option. The best part is it's super easy. No mess. No hassle. Takes a couple minutes and you're done. How's that going over there by the way? Anyone?  This way it's chef prepared meals that you can make way quicker than ordering something to be delivered to you. Also the meals are so delicious but also healthy that you never have to opt into eating anything unhealthy because you know the fast food places near you have no other option. I feel like you can tell just by looking at the meals how good they taste.  That's such a good deal. Oh, I'm done. How are you already done? You lost. Guarantee your mind's gonna taste better anyway. Can I at least try some? Nope. Really?  So full.  Okay, of course it's my dream. Where do you want to live in the high tech neighborhood known for its video game stores, PC component stores, and it's Jim. This is obviously the video game one right here. Dress up like a real YouTuber. All right, so I'll wear the same shirt I've been wearing the last five years. They don't have the YouTuber shirt, which is a white shirt with blue sleeves. That's pretty cool. Yes, that's too cool. I wouldn't wear that. That's what I would wear. Yeah, that's you. I need to slap a beard on this guy ASAP. All right. Now they better have the YouTuber haircut. It's right there. Oh, that's there. There we go. Bottoms. Where's the basic jeans? Wait, what are you trying to say? All right, here we go. This looks like Pokemon. Yeah, it does actually. It looks exactly like Pokemon. The fact that this game honestly looks maybe even better than Pokemon says something about how bad Pokemon looks. It actually looks pretty good. It does look nice. Oh, pigeons. I highly doubt you can like run around this area. Absolutely not. And to draw a name? Well, it's got to be Tugmas. Never Siami. You notice that? We'll make it Siami. It's a cat's name, by the way. If it's your first time here and if you didn't know that, you have to subscribe. Loading personality? Well, it's already not Siami. He has the personality. His personality is mad. His personality is mad and hungry. First step, learn how to record videos. Hate to tell you. Suspend disbelief. Pretend you don't know how. Figure that one out. But before you do, you need to create your new tube channel. Now do I recreate the magic that is beat em ups? No, you got to do a parody because all this stuff is parody. Call yourself Plank.  I know. And so my channel name is sort of beat em ups would be Yeah, smack em down.  Finally enough, beat em ups is like, I don't read it as an aggressive like, you know, beating someone up but smack em down really sounds aggressive. Would you like to test me out now? Well, that depends. What are you going to do? Oh, it's a camera. That thing records me. All right, record video.  You shyly say hello. This is cute. Enter full of energy. Look, that's literally you. Oh, that is me. Dude, hold on. That's my character that I've made. That's this guy. Nice. Now we'll post your video to new tube first. We'll touch it up a bit by editing on your computer. Oh, yeah. You get to edit your videos. Oh, you have to connect them connected. They're connected here connected there. Yeah, yeah, yeah, yeah. It's like a little puzzle. I love that. Oh, I get to choose the thumbnail. They all look terrible, but I will say that emojis in thumbnails generically work really well. So I'm going to go with the emoji one. What is a good clickbait title for that? Hit randomize and see what they suggest. Laughing about hashtag home vlog. What? Reacting to home in a vlog. Another vlog with home. What are these titles? These are terrible. They seem to love hashtag home for some reason. The suggestions weren't bad because we are in a new house. My new apartment vlog. Cop's called. That's what works though. Or choose a clickbait phrase. The vlog you would never have expected. That's you. That's literally a title I would do with like the capital like words of like never expected. That's what I do on my channel. Every single video and it gets high visibility apparently and does not make people mad. This is also me when I upload this. Please, please don't fail. Please don't bomb. Oh, no. Why is he so sad? Did I fail? Okay. First up my guy. It's been two seconds. Give it a chance. I look so like nervous. The dread of trying to be successful is already setting in. I've uploaded one video so far and I wasn't happy with it. A poltergeist appears and you have a laughing fit. You flatter yourself. You think it's a good piece of information. Laughing probably. Has to be laughing, right? Why am I having such a hard time? So upset. You're stressed out so much. The realism. Okay, I'm going to ask for subscribe. You should always ask for subscribers. Guys, subscribe. So now I have to edit the video. You think I should cut out the part where I'm angry? I mean, I don't know if that's going to do well with your subscribers. Yeah, I don't know either but I seem to get more points for like editing it well and that's linking them all up.  Oh, now we've got some effects. Oh, yeah, comment.  What was this video? I was playing a game. What were you commenting on? Well, there was a ghost. There was a ghost. I can't believe this happened. Well, I recently uploaded a video called the hardest game I've ever played. So this is on brand for me. Uploading. Let's see. Let's see. Two likes. Oh, he's pleased. Two likes is two likes.  Fifty five subs from the second. Why are they angry though? Well, because it's me. And I do click me like what do you want ring? You can stay awake till 4 a.m. But you won't be able to get all your energy back for the next day. Well, yeah, that's pretty much the life that I have. Yeah, that's accurate. That tracks. So you got 27 subscribers from your first video and you get 29 from your second. Oh, that's not bad. I got three likes on the first video too. So I really don't know why he was so angry. I don't know. Today's trends. You got to pay attention to this. Okay. So the games are armored, nucleus, deity of war, honey, play studios one and still gaming corner in your room. Oh, yeah. Add furniture. Oh, yeah. Oh boy. Oh, little beanbag. Oh, no. Oh, now we have to go to the game store. Oh, that's sick. Oh, so you can run around the little area they made. Oh, there's a scooter. You could rent them, I think. Oh, you need a license. Oh, but that, but that is pretty cool. Oh, look, she's good. Oh, there's Tomb Raider. Oh my God. A PlayStation five and I've seen Xbox at a switch. Look at the names. Oh, so armored nucleus is PUBG. So PUBG is the game that's trending right now. The honey play studios one is trending. I can't afford it. Can I help you or something? I'm here on the behalf of Xavier saying. No, just looking would be kind of creepy when I've walked up to her behind the counter. You need something? Nope. Just looking. Just looking.  I got a free PlayStation five. I got to just run home like this. I got the game. I'm ready to raid some tombs. I want the Mantendo switch. But I like that they called it Mantendo switch. How funny would it be if it was non-Tendo, you know, like, like the podcast, non-Tendo podcast. Who hosts the non-Tendo podcast? Pretty sure it's like you and. It's me. It's me, right? Me and Bob. Russian home to install my new PlayStation relatable. Does this feel like how you started minus the minus getting the free stuff instant representation and living in a cool city? Yeah, exactly. So not at all, basically. Well, no, I did have a robot drone that would film all my videos. Oh, where'd he go? Died. Record video will play Tomb Raider.  I hope I can unlock like more cards. I think so. Your phone rings. You make a technical comment. You ship. Oh, the lingo. You explain the law. I explain the law. Why are you mad? I don't know. I'm always the wrong choice. I think it accidentally realized my true personality. You answer a hater from a previous video. You shouldn't already be doing that. You have 50 followers. How do you already have haters and you ship them? I'm sorry. You hate me, but I love you. I love you. Come on. One dislike. I did get a dislike. But he's fine with it. He's fine with it. He's happy for my subs. My subs. I got two more angry subs. You're new in town and you need to meet people having good friendships or help your YouTube career. There are celebrities in the neighbors. Celebrities. There are neighbors. Meet 10. Okay. Talk to the lady with the cat. Maybe she'll give you a pet. I can pet. Best game ever. Best game ever. We did it. Can't talk to that lady. Perhaps this child. They don't want to talk to me. Okay. Oh, doggo. Yeah, doggo. Yeah, I bet the doggo's butt. Oh, look. It's a My Hero Academia pop. And Spiner Man. That says hashtag fountain on it. Why is she pushing me out of the way? She's trying to talk to me. She really wants to talk. Are you lost? That's all she said. Oh, that's dumb. You want to talk to me? Oh, Gigi. Hello. You've certain got guts. I'm Gigi Macaron. You never heard of me? Yes, nothing good. What a pretty dress.  Her grandmother is definitely not alive. No. I guess the dress. Because otherwise, that's rude. At least you've got good taste. Oh. Ooh. Ooh. Ooh. Hmm. Toodaloo Grandma. I don't want to build a relationship that way. No. What is this? Oh, eSports. That's definitely open. Oh, okay. It looks like his name is Charles or Chad Robin. I would not have guessed Robin. No, me either. So it's true. There's someone new in town. I'm Robin. I'm Plank. Oh, no, don't leave me. Hey, come back. Cassidy with a K. Are you new in town? I'm Plank. Hey, who are you? You look familiar. Are you a YouTuber? Okay. Yeah, go with that. Nope. Oh, well, that's helpful. You know, if you look a stranger in the eye, you get sucked the life out of them. Get out of here, vampire. I like her. I feel like I just went into an eSports bar, chugged three energy drinks, and then passed out. Relatable, honestly. Ring. Don't miss Playcon. I assume that's like Twitchcon. There's some huge promotional poster in the city. Do you know you can post content almost instantly for your followers? I'm talking about InstaLife app. Literally Instagram. Oh, that's how you like. She's like super famous. Oh, 32,000 likes.  We need to start simping. Publish a photo with hashtag Playcon. So you got to go to the poster presumably and do it. Okay. I'm going to do a new apartment photo. Okay. 103 likes. Not bad. For just installing the app. Starting out. I should have a famous eGamer as a TV.  All right. Let's do one more video game. We got to do the other game. Okay. Let's do the other video game.  Yeah, I guess ask for subs. Always ask for subs. I try to troll someone and it goes wrong. There you go. That's not bad. Let's see, baby. Oh, you got seven likes. Only one dislike this time. Only one dislike. He's satisfied with that. Well, that's because in the last one, I addressed my hater and I flipped him around on my side. We're best friends now. My energy is low. So maybe we should go to a restaurant. I am enjoying this too much. Oh, there's ramen. There's a game after my own hat. Hat? Hat. Oh, there's a latest Susie. How nice. A new face. What's your name? I'm Plank. Takeout Walk Dragon Breath Rice. We love California, Ron. Yeah, we do like that. 50 though. Good Lord. Yeah, new two prices.  Oh, don't forget to take a picture.  Oh, it's record video actually. Do a little vlog. I got some energy after eating. Oh, maybe I don't. Oh, no, you don't have enough time. Hold on, hold on, hold on. I gotta eat more. Now, I also wouldn't recommend if you're trying to do a gaming channel, filming a vlog outside of a spicy ramen store might be a little bit against your branding. But I mean, who knows? Give it a shot.  So I think at level one, you don't have many options for things. I really think as you level up your video making, you get options to more things, which I think is a good way to represent like just getting better at making videos the more you make. Yeah. Well, there's that lady again. What you want, Gigi? I don't like people cast shadows in my area without permission. I don't like that she loves me every time we talk. Where's the big... Oh, that's it. That big one. Is it? Oh, yeah, yeah, yeah, yeah. Here we go. Oh, you can look at the camera. Oh, that was creepy. I don't like that. It was like... Oh. That's very interesting. That's you. And you can even move the camera and stuff. Yeah, you can move the camera. That's cool. Man, this is actually pretty well fleshed out for what it is. Yeah. And what it is is fun. So that's good. Oh, my God. 800 likes, not bad. I'm blowing up. All right, let's go home. I need to edit that vlog. You need to. I got work to do. I can't be out gallivanting all night. Edit the vlog. Hit the hay. Wake up bright and early and shoot some more gameplay videos. Bam, bam, bam, bam. Easiest video I've ever edited. Posty, posty. I got food poisoning. No, you did not get the food poisoning. This is so wrong. New to. It's not a real business, Kim. I'm not costing anyone their livelihood. This is so messed up. Let's see how it does. I hope it takes. Let's see how it does. Two dislikes. I mean, it's about on par with my other content. He seems happy with it. Now he's exhausted. That food poisoning hit hard. Ring. I didn't mention it before, but the ticket to the festival cost a thousand. I'm sorry. I've been eating food. I should stop immediately. Installing the commissions app to your phone. You can open it now. All right. Let's see. Deliver a package. Okay. Blair's asking for photos. You take her photos. I'll do. I'll do that one, I think. I mean, out of the two options, I think that's definitely the better one. But before we head out, let's record a video. A poltergeist appears in Tomb Raider and you explain you ship. Yeah. To finish, ask for subs. I didn't do as well on that one.  Is that a good title? I think that'll do well on my channel. Yeah. Okay. On your channel? Sure. Six dislikes.  Why did it get so bad? There were no cats. It also wasn't a Nintendo Switch video. Hi, I'm here to take your picture. While you're at work, Blair, unprofessional. I mean, am I not here to take your picture? Talk to her at the video game store. Yeah, what do you want? Oh, wait. What? Oops. What do you do? I bought Armored Nuculus again. Now I have two copies of Armored Nuculus. Do a giveaway. Yeah, sell it for $14. That's GameStop. I literally just got GameStop. I guess we're done because it's not letting me take her photo. Yeah, why? Hold on. Commissions. Can I do the package delivery at least? Oh, he's got a box over his head. He does. What are you doing with your life? What does it mean? What about the package that you want me to deliver? The package, Adam. The package. Give me your package, Adam. I request your package. Pick up the package and slay it or surf and take it to Adam.  There's the package. Give it to me. Signed to wonder when it would arrive. Thanks. That's rude. I'm sure the money you get for doing jobs will increase as you go. But 60 is like the cost of what? A sushi roll cost.  So I feel like the value of things in this town is kind of skewed. Oh, my lady. I've come to take a photo of you from the bushes. You want photos, right? Oh, well, excuse me, princess.  So you have to do one hashtag armored nucleus so she notices you and asks you to take the photo. Read the description. I'll do that another time because I don't, I, I, I don't want to bog down my Insta life with more photos. Well, actually, once again, this game series has proved to be more enjoyable than you would think because from the outside in, it looks like a weird mobile cash grab. But honestly, they do put a lot of thought into it. Wait, wait, I got to end it like that. You have to ask for a subscribe. I got to ask for, hey, please, for the love of God, subscribe. I need you. I'd appreciate you like the video. Comment down below. Check out Kim's Etsy. She has a YouTube channel too that she never uploads to, but it's their brand new podcast. You can go subscribe to Nontendo podcast. It has a Patreon with free bonus episodes weekly. I don't know what else to do here. Play more game. Yeah, let's keep playing.