Oh I also said that the other day and I was like, ah, I should say that maybe that's why how it got because I'd never I haven't said that a long. It's also like not even funny, but it somehow is funny Yeah, it doesn't really make sense. It's funny if you like really love airplane Roger Roger vector Victor. I threw an extra vector there Roger, huh Airplane 2 was unnecessary, but still kind of funny. There was one great visual joke in airplane 2 other than that I completely agree with you, but when they were doing the sort of like You know kind of like zoom up isn't oh, where does audio go? Oh, what happened Rob? It's a Rob. I think we just lost your audio. Oh, no. Oh wait now there it goes. I think you have a loose cable Oh, yeah, I hear you Me now. Yes. Yeah That was weird. I just muted myself because I had to cough It was like either really good timing or somehow I'm now controlling yours as well Correlation I'm muting again because nothing changed over here. That was weird Okay. All right. Let me try to meet me again and see if I know I am talking can anybody find Weird merely correlation. Yeah, it's it really did sound like a cable was loose cuz It came back in that sort of Well, if we're April 1, you would have to suspect that I'm messing with you, but Didn't suspect that does your cat frequent the top of your desk.  Yeah, we we go back. We've had Ashby for almost nine years. Wow That's a lot of Ashby. Yeah, she's a great member of our family Well, I remember when when Ashby first became part of your family. It was a little touch and go, you know She had to chill out a little bit Okay, so you went without again Rob. So I think it's gotta be a Mike thing Cable right there say something Rob. Hello. Hello. Oh, yeah, so don't touch your microphone. Wow That's this blue icicle thing. It's so fancy. I I Won't touch it again. Anyway. Yeah, Ashby has settled right in I I'm a rescue myself So we are very loyal to our rescues around here.  I'm ready Hey, there's a lane You want to do the pre-roll sure do okay? Here we go. All right, three two Daily tech news show is powered by you to find out more head to daily tech news show comm slash supports This is the Daily Tech News for Monday April 2nd 2018 from DTNs headquarters in Los Angeles on Tom Merritt and from studio feline. I'm Sarah Lane We have with us returning guest Rob Reed author of after on and host of the after on podcast as well Rob Good to have you back great to be here. I am a very happy that we have had a couple of years with April 1st On the weekend because it really is disruptive to the news flow But you know next year we'll be back at it I actually really love April Fool's Day, but for for a few years it became a bit much Well, yeah You just get used to you know everything you read being like what kind of a weird thing Are they trying to do them like is this real or not? It's just it's exhausting if you actually have to work that day Austin yesterday because Google Maps started inserting pictures of Waldo everywhere and I as it happened I was in the middle of a bit of a map crisis when it happened and just having that damn face pop in and wave Every time we were trying to do our navigation was was really pretty tiring. Yeah a lot of times people need navigation for very serious reasons Our producer Roger Chang is here as well Roger. How are you? I'm doing fine I'm glad to hear it. No, are you telling the truth? I can't tell Let's start with a few tech things you should know Sources tell Bloomberg's Ian King and Mark Gurman that Apple plans to use its own chips and Macs starting as early as 2020 Project Kalamata, which is a really good name for a project as it's apparently called aims to make all Apple devices work seamlessly together Is that because Kalamata olives have the seed inside and this will have the seed of Apple's processor nevermind Yeah We'll get back to that in the potion Cloudflare launched a consumer DNS service at one dot one dot One dot one and one dot zero dot zero dot one and yes Cloudflare is aware that many of you use that as a garbage address and they're willing to take that no problem Cloudflare also promises it will be the internet's fastest DNS and the company will wipe all logs within 24 hours to ensure privacy All right, let's talk a little bit more about Mark Zuckerberg's campaign of apology this time Who's he talking to sir? Well in an interview with Vox CEO Mark Zuckerberg defended his company claiming it makes decisions quote based on what's going to matter to our community He also argued that he is among companies who work hard to change people less and make their product available to more than just the rich Zuckerberg also used the word glib to describe Apple CEO Tim Cook's comment that Apple doesn't sell user data to advertisers I'm not really sure why glib was the word that he used but I guess it was the tone Well, that's what he said after that which is and not at all aligned with the truth Which seemed to be a slightly pro polite way of saying lying also kind of glib to say that Yeah, it is kind of glib. It is kind of glib. I I I really liked this article It gave me the impression and and this could be an impression Right, you may not trust a word that comes out of the man's mouth and that's fine But if you take him as his word it gave me the impression that that Mark Zuckerberg Acknowledges the problems with Facebook that he wants Facebook to emphasize the quality of our interactions with people over everything else Over advertising over time spent viewing. He's like what will make Facebook successful will be the quality of people's Interactions, we're doing a lot to an emphasize that people get meaningful interactions And we're doing research for that and we want to make Facebook a really good place What disappoints me is that he never acknowledges that one of the reasons I think I think and maybe he just does screeds of me Maybe he's not gonna acknowledge it one of the reasons I think Facebook's in the position it is is because it closes itself off At one point one example is in this article He talks about maybe someday having a third-party review panel so people can appeal things that have been blocked That if somebody complains about something and the Facebook staff blocks it you could appeal outside of Facebook and say hey Is this really? Should this really be blocked and to me? I'm like, yeah, that's what an open Platform looks like you you have that happen naturally in an open platform You're just trying to reinvent what you've walled yourself off from I Think it'd be really neat if the appeal route was to like a North Korean court Like so unexpected and kind of cool in a weird way. No, I don't think that would be cool in any way Unexpected I will go for Yeah, definitely very interesting It also the the whole sort of like hey, you know, we don't want to charge people a lot of money Facebook is for you know Not just the rich Okay But one could argue that you know people giving away their data in exchange for not being charged for things Is more expensive in the long run as well. So the you know, if you're going to Compare Apple and Facebook for example, it's like well, okay Yeah, Facebook is not selling a bunch of hardware and Apple sells a lot of expensive hardware But Apple also provides services that aren't always at a cost Apple not selling user data, which is something that obviously Facebook has been accused of and and is well aware of those problems That to some people is worth more even if it's not, you know dollars coming out of your wallet in the long run It's potentially detrimental. So I don't I think it's it's oversimplifying things to say We want the whole world to be on Facebook and we don't want to charge you because there is some cost depending who you are Yeah, there there is and and and It's a it's a good campaign speech I mean, I I don't think Mark Zuckerberg wants to run for president I think he sees Facebook as a government. He basically says so In this interview and he feels that he is acting as if he were a governmental leader and needs to act like one Which is why he goes out pseudo campaigning and meeting people and talking to them Whether that changes down the road and he decides to run for actual public office I don't know but I think he has an inflated sense of what Facebook should be CBRS is a spectrum that will be freed from exclusive military use in the US this year Google is leading a project to make private use of the spectrum without interference Now this would make wireless data cheaper to operate because carriers wouldn't have to own the spectrum Verizon AT&T T-Mobile, Comcast and Charter are all testing CBRS and recommending manufacturers include support in future hardware This would increase coverage possibilities as well because even though if you live in an area with a lot of Military activity it might not work as well in a lot of places. You don't have much military activity at all And so it's just open spectrum Yes, and it's specifically the Navy So I think landlocked states could be facing a bandwidth bonanza here because the Navy doesn't usually haul into I don't know South Dakota That's that's one of those things that I want to agree with you on but I'm always hesitant to say it because as soon as I do Somebody writes in is like well actually the Navy Test its planes in some landlocked area But but I think largely the point is well taken which is you know in in the middle of the country You don't get a lot of Navy planes flying around and if that's who makes the use of CBRS for the most part then Yeah What is I think unarguable is there's a lot of unused spectrum in this space and Google's trying to make a system that will make good use of it and it's a hundred and fifty megahertz, right? I mean, it's a huge it's a big slice of spectrum Yeah, and what they're trying to do is is make it smart so that if Military use is happening that gets prioritized And then second would be Somebody like Verizon who's like oh, I'm gonna use this network And then there would be an open platform It seems like down below it and then squatters get no benefit And so one of the things that the article noted was that if somebody has technically bought the spectrum But they're not using it They're just kind of sitting there then lower priority people can actually use that spectrum as well So it goes Navy official owner and if official owners not using it right down to the next party, which is great Excuse me the Wall Street Journal reports that as Amazon looks for its new second headquarters and is courting cities for that It's asking cities that are in the running to provide SAT and ACT scores You know like like high school students when Amazon first announced its expanded headquarters search It listed education as a very important factor in choosing the city Company also said that it's request for proposals that it would invest five billion dollars over ten years to creating at second headquarters In whatever city is ultimately chosen the project also potentially means up to fifty thousand new employees or new jobs anyway I Think it's an interesting insight into what Amazon's after right they they want not just college educated It looks like they're looking because they're looking at SAT and ACT scores. They're like, what's the funnel into college? You know what do you have a well-developed high school? System that will that will feed these people in I mean they they are very forward to the not forward long-term thinkers at the same time it also puts a lot of emphasis on Certain tests that not everybody believes is the best indicator of like the new smart workforce that might work for Amazon You know, it doesn't I guess if you had a bunch of you know, great SAT scores You might say oh, yeah good schools, but it doesn't necessarily mean that that's going to help Amazon at some new headquarters although when you're looking at fifty thousand potential new positions, I Guess if you're Amazon and you're gonna invest a lot of money into some new place You want or you know workforce that is demonstrated that you know that education base is strong They should make the mayors take the SATs for each of these cities. I think and also fill out maybe an essay test I wonder if they just have a huge amount of intern positions that they're looking to fill as soon as they ramp up No, they don't have fifty thousand intern positions. Oh, no, not fifty thousand I think they're mostly looking like are we gonna have an educated workforce local to this and and and I think I Think they also want it sounds like they want an urban situation They want to put their headquarters in a downtown Which is interesting as well The economic times says its sources say Google presented a mid-range version of the pixel smartphone in Trade meetings held in Malaysia the UK and US last month The device would launch around July or August with the focus on price sensitive markets like India Google is also expected to bring the Google home pixel book and the forthcoming pixel three to India soon Hindi was added to Google Assistant last month So that kind of paves the way for a lot of this pixel three is expected to arrive in October And yeah, Hindi and English you got those on there You can reach a large part not 100% but you can reach a large part of the Indian market And the Indian market scene is an important one to move into by a lot of people. So I you know Would you look at the pixel as a competitor to Samsung or the iPhone? One of the issues is it's available in eight countries Samsung's available in hundred plus countries So you if you really want to be in this game for real, you've got to get into more countries Worldwide and it seems like that's the direction Google is moving Yeah, and India is such a vital market as well in a weird way I don't follow what goes on in the Android platform very closely And so this is probably an ignorant thing to say but I was kind of surprised at The fact that it's taken them this long to try to push their sort of defining Flagship II this is Android done right phone Into a middle price point of the cheapest pixel right now is 649 bucks. That ain't cheap. Yeah Well, they were the middle ground with Nexus phones for the longest time They were and then they dumped that to do the pixel is a very Google thing to do like We'll just throw out everything we did with one project move to a new project and then start to replicate the old project inside the new project Yeah, yeah ESPN announced its standalone sports streaming service called ESPN plus will launch April 12th for $5 a month The service will include live sports not carried on ESPN's main cable networks as well as access to ESPN originals Sports will come with MLB NHL MLS college sports boxing PGA golf tennis and others So I was a surprise to me to see MLB and NHL Listed here. I didn't realize they would they would those are expensive rights Especially the MLB to get and I didn't realize they would put any such games on this service this service Feels like it's a things that are left over because we bought rights to a lot of stuff and couldn't use it on our main channels I don't think it'll be a lot of MLB games to be honest Those will mostly put be put on ESPN and ESPN too, but I don't know Rob. You were at Disney World recently Yes I do feel I have very personal insights into this because I did spend much of the past weekend at Disney World And of course Disney is the owner of ESPN I'm just gonna say it was the talk of the Magic Kingdom this new service I was five years old too, so that was kind of interesting. Oh, wow, that's crazy They they have an ESPN sports zone usually outside of those places. Yeah. Yeah Well, the interesting thing is ESPN has lost almost 13 million Subscribers over the last six years now a lot of that was just people Cutting the cable and as by dint of that losing ESPN and who knows how many of these people were actually watching ESPN to begin With but this is you know They've got to start bobbing and weaving a little bit as cable cutting becomes more and more of a thing and 13 million subscribers is a lot, you know, however you cut them and however you minimize them Yeah, and this is a smart move I mean it feels like the kind of product that you have to really be a sports fanatic You know a fan of the CFL or college softball To really justify five dollars a month to pay for this which isn't that much but it's building the groundwork, right? This I Imagine that this service will continue to grow and it's an add-on to the ESPN app You don't get a separate app It's gonna be one of those things where you're logged in with your PlayStation view account or your Comcast account And then you see something and you're like, oh, I want to watch that and it's like hey great You want to watch this sign up for ESPN plus five dollars a month barely miss it and you'll get access to all this extra stuff Hey folks if you want to get all the tech headlines each day in about five minutes Be sure to subscribe to Daily Tech headlines at Daily Tech headlines Dot-com still available on the Amazon Echo the Google home and the anchor app as well as as a regular podcast Alright Friday Tesla posted that the Model X car that was involved in a fatal crash in, California Had autopilot active during the crash and that the driver's hands were not on the steering wheel in the six seconds prior to The crash that warnings to put hands on the steering wheel had been delivered a few times prior to the crash The United States National Transportation Safety Board criticized Tesla for releasing the information the investigation is still ongoing I don't like it if people give information partway through So it's it's interesting that Tesla made that because it's not necessarily flattering to Tesla But I think they were trying to show hey, this is not you know, this is not what a lot of people think it is We don't want this to leak out. We want to control the information and tell you yeah autopilot was on No, the guy didn't have his hands on the wheel and he's supposed to with autopilot now one of the reasons we bring this up though is Rob you had the chance to talk with Rodney Brooks on the latest episode of after on Turns out he's an interesting person to talk to about self-driving cars. Why is that? Yeah? Well Rodney is goes back almost to the dawn of two industries robotics and artificial intelligence and Those are the two things that clearly come together when it comes to self-driving So just a quick background about the show So my podcast is called after on the after on podcast and it's long unhurried interviews with thinkers founders and scientists like Rodney and we actually recorded this episode before the two tragedies in self-driving the one in Phoenix and obviously this very very recent one in Mountain View and Rodney Just his to hit his background again when he entered the field of robotics There were literally three mobile robots in the entire world was back in the 70s when he came out to Stanford to study robotics And then he headed MIT's AI lab and he actually studied AI before it was really it was barely even named And he studied it by under the person who named AI So he's been at that intersection all along and he is a little bit of a skeptic when it comes to self-driving He believes it will happen. We'll save lots of lives long-term and it'll be very powerful but he believes that a lot of people in the industry are really Extremely optimistic when they talk about the timeframe of rolling out different services and he's gotten a little bit of pushback from people from that and You know probably less so this week with these you know two terrible accidents coming right on each other's heels Just you know, obviously by coincidence But in our interview we spent about 10 minutes talking about self-driving and he made a lot of really kind of intriguing and to me points I'd never heard before Supporting his sense of skepticism about how quickly it's going to come out. Do we have a range of people in our audience? Some people think that you know the these sorts of setbacks You can you can argue that the Tesla crash may not be an example of a self-driving car This may be just an example of someone, you know, not paying attention while driving which can happen if you have auto assist or not on Certainly the Uber one is is without controversy a setback But we have we have people who say oh, that's just a setback We'll figure it out and we'll move past it and we're gonna get these things soon We have people who ride in and say it's all overhyped It's never gonna happen and you know, and you're irresponsible We're even talking about it. I think the important thing with Rodney Brooks in your interview is he's not a skeptic on everything He is actually oh more optimistic than some people about certain topics. Why is he thinking that this, you know What does he think about auto autonomous cars? Well, I think he focuses on a lot of things that he believes that a lot of the pundits and even some of the people in the Companies are just ignoring to me. Here's one of the really intriguing ones How often when you get picked up by a Lyft or an Uber does that driver? technically violate the law in double parking in crossing over double yellow line, whatever it is I would say when I'm getting picked up and it tends to be in dense urban cores like New York City in San Francisco Where I spend most of the time. It's a pretty high percentage. It may even be a majority that the driver Technically violates the law. They pull into a bus lane. They do whatever it is and both the driver and the passenger No, that's fine. Probably a passing police officer would know that's fine. These are just the things that we do Well, how do you tell a self-driving service? It's fine to violate the law 40 or 50 times a day You kind of can't do that, right? And you've got to figure out how you work around that What happens if a car has to go up a one-way street because a garbage truck or Construction has blocked the street and you your only way out is to cross a double yellow line or go wrong Way on a one-way street or wait six hours There's a lot of these cases which actually are confronted by Uber and Lyft drivers Probably dozens and dozens of times per day that get a little bit trickier when you start doing things Programmatically and then he talks about the social cues that go on between people between drivers and pedestrians And then he came up with I think he just came up with it in the course of the interview He said what about teasing cars and he came up with this idea of like hey, I'm a teenager I'm a little bit bored. I know a self-driving car is never going to run me over for liability reasons And it's really really capable. Why don't I get out and pretend I'm jumping in the middle of the road so car teasing and you know a whole bunch of nuances You know that I hadn't thought of now when we talk about self-driving we often talk about the so-called trolley problem Which is what happens if the car is going down the road and you have to choose between running over a nun and Running over to escaped convicts We talk about that a great deal We don't talk about some of these subtleties and I think that he makes the point It's a strong one that these subtleties particularly when they tangle with legality Are really going to slow down the rollout But long-term he certainly believes we're gonna get there just not as quickly as some of us would hope myself included I like it to be switched on tomorrow. I've never driven a Tesla in autopilot mode but I have a friend who goes back and forth from San Francisco to LA because he's from the Bay Area and he lives down here and He a lot of that part of that road is just sort of going straight not a ton of traffic Whatever, you know, just make sure you don't hit, you know other trucks But it's it's more or less kind of monotonous and you know, he's mentioned like yeah I have a movie on sometimes. Oh, you know, and I'm like wow I mean it seems like it's The drivers is as we get more of this autonomous technology That's even you know, either an Uber or a Tesla or whatever, you know And there's just going to be more of it as you try to figure it out It's like you are encouraged to pay less attention Because that's the point right the car is smart enough that you can pay less attention But then you have stories like this where it's like well, the driver was warned put your hands back on the wheel Well, I don't know what those warnings sound like I've never heard it myself But this is like this funny gray area. We're in now where it's like it won't be great The you know the cars will just drive us and then we have these incidents where it's like hmm Doesn't sound like you were paying enough attention. Well autopilot mode is supposed to make us pay less attention, right? That's the whole point of it. It's just not working that well yet Well Tesla did make the interesting and I think important point and they they're probably going to get a fair amount of Flak for this and they did it carefully where they said that you know We want to point out and we have you know, you know, incredible empathy and sympathy for you know, the victim family friends But there are roughly four times as many miles driven by a Tesla in you know, assist mode They're four times in miles driven perfect fatality the normal human drivers And so let's not lose sight of that and let's not throw the baby out with the bath water It's terrible that this accident happened But we would argue that for this accident three others were prevented that would have lost it resulted in a loss of life and I'm sure that they struggled mightily with should we say that in this press release so soon after the accident But what they said they explicitly put their thinking in the press release They said we don't want the lives that can in future be saved by self-driving to be put in jeopardy because people Overreact to an incident like this and lose sight of the fact that you know arguably by the math We've saved multiple lives for each one that is tragically lost in the circumstance So it's going to be I'm increasingly in agreement with Rodney's points in my interview But it's not going to be as smooth and as fast as we thought because there are these strange agonizing and also, you know legally complex issues They're going to come up again and again and again as we start rolling this stuff out Yeah, and I think that's what's the most interesting about that perspective and it's not just Rodney's I've heard this from other people which is it's yes The technology is there and yes, we can solve all these problems. None of these are our killers even even weather even winter driving none of these are our killers, but We will have to solve them slower than people are expecting because they're not as easily solved as the Optimists would like to imply so and and I think the legality thing is a good one I can think of a million ways we could try to solve that Certainly machine learning is capable of learning when to fudge things, but then it's the liability part Well, okay, if we've taught machine learning when to fudge things when do we punish it for fudging things wrong? We have laws for a reason right or maybe we adapt the laws Maybe we have to change the laws to be more sensible Because we've we were like and we've let it slide because we all figured out how to work it out But now that we have automated systems We need to come up with a more workable system of laws that doesn't require fudging But all of that stuff takes time anytime you're talking about anything involving laws It's going to take a lot of time and that that is a bigger Impedance to the development of autonomous cars I think than the technology itself and it's interesting to hear that coming from Rodney because he's certainly no Luddite I mean, this is the person who invented the Roomba. He invented the Pac-Bot, which you know 6500 of them deployed in Afghanistan and Iraq Diffusing all those IEDs. He is you know, he is no cringing future-fearing Luddite by any stretch of the imagination. So He did this great blog post on January 1st We made dated predictions of lots of things about a third or maybe a quarter Then we're pertaining to self-driving cars And I think it's great that he has the courage to go out and put dates on his predictions and hold himself to account and Be put in a position where he will be either be clearly right or clearly wrong Um, and it is interesting getting these cautionary notes from somebody who is very much a futurist And whose vision has had a lot to do with the fact that we've gotten to this point already Yeah, Rodney Brooks thinks we'll have a labor shortage That the the robots won't take our jobs So go listen to after on to find out a little more about that perspective And thanks to everybody who participates in our subreddit You can submit stories and vote on them at dailytechnewshow.reddit.com and facebook.com slash dailytechnewshow Shall we go across the pond? Let's let's check in across the great wide Atlantic Ocean Otherwise the pond to find out what's been happening in the uk on text message Hey, thanks guys this week We have taken a british look on the latest in the facebook data scandal Specifically discussing the fact that Mark Zuckerberg has said he is not going to appear before a uk Committee of lawmakers to give evidence and this has been seen as a very very bad PR move in britain to say the least We've also got some discussion around how europe is going to potentially dump 300,000 ukowned.eu domains once we leave the european union all that and more at techpodcast.uk Yes That's there's so many things falling out of brexit where the eu is like well if we don't fix this We're just gonna take out here because only people live in the eu can have died eu So unless you want to figure that out i'm certain some of them will be figured out but I wonder uh, so check out tech's message if you'd like to know more Thanks, Nate linkson and thanks to rob reed rob. We were talking about uh after on what is on the next episode So people can look forward to what's coming up. Yeah, actually the next episode goes up tomorrow So depending on when people see this episode of dts. It may already be up So rodney brooks's episode 23 we talked about that the next episode Is going to be a really long interview with george church Who is widely considered to be the leading? But uh bio engineer and probably the top person worldwide in genomics today Uh, he is a co-inventor of crisper his work on the human genome project actually predated The official start of that project and he is one of the most widely cited people and the co-founder Of 22 startups all this while running a very busy and very high profile academic lab at harvard He and I talk all about what's happening in synthetic biology We go through a series of definitions that I think will help people Frame synthetic biology better in their minds and really contextualize this amazing thing that george helped invent called crisper and we talk about a lot of other really cool things and I think that um Life is about to get much more interesting very quickly Due to senbio a lot quicker than I thought going into the interview So that will be up starting tomorrow as we sit here But perhaps today when you dear listener are listening if you are in fact listening on tuesday instead of monday time travel man, just problem with everything Thank you patrons, uh, it is uh the second of the month Which means uh, some of you are are still actually having your pledges processed And we thank every single one of you who keeps this show running. We got seven more patrons than last month So huge thanks to you for that. I want to keep it going to get at least one more Next month, so don't cancel Unless unless you have to we understand uh financial difficulties happen But we've got all kinds of good things coming this month including a round table with amber mac and gen cutter at the end of the month So check out all the new perks are posted up at patreon.com Slash d t n s patrons non patrons and everybody in between We love to get your feedback questions comments ideas all of it our email address is feedback at daily tech news show dot com We're live monday through friday at 4 30 p.m. Eastern 20 30 utc And you can find out more at daily tech news show dot com slash live back tomorrow with our guest lamar wilson talk to you then This show is part of the frog pants network Get more at frog pants dot com And I know a lot of you guys appreciate the show notes The expanded show notes that are more than just the google doc Big thanks to ethan cayne who's back doing that. He just he just finished today's right now Like the show wasn't even over. He was done with the show notes. Amazing. He lives in the future. He does. Oh my gosh more time travel Time travels the new uh, has the new uh, vampires So I got a I got a question about patreon because i'm brand new to it myself Is the second of the month when people roll off if they've turned off their credit card or whatever it is Like does it all happen on one day? It's the first it's just sort of every month It starts on the first and and for for one as large as us It usually takes a few days for everything to get processed usually it's all done by the fifth Okay, because that that that's interesting because um, I was I went into yesterday the first uh with 204 patrons and I was feeling pretty good about it just started about a month ago Oh, right. Yeah, and then it rolled back. I started back in february So I mean I am experiencing You know, whatever drives this and then I looked I'm like, oh my god I'm down to 202. I see why you're asking this I went backward, but now up to 207. So never Look Never look at your patreon numbers between the first and the fifth. It would drive you crazy Well, they dipped and then they went back up again, but because they're all about 170 since they're in So I'm okay with that, you know They're an estimate Of what they think you'll have at the end of the month And on the first of the month when it's going through and like oh that credit card didn't process Well, hold on we need to reprocess it Uh that number fluctuates wildly Got it because it's it's dealing with all of this change and then by the fifth They've they've reprocessed credit cards that work And they they found which ones are like that. This one just isn't working and then it sort of levels out Well, good. Well, I did see the dip and I I feel the fact that I'm clawing my way past the dip Back to an all-time high. Oh, yeah good about that But it was a little sad yesterday when I saw myself going backward and I was afraid I was going to see that every day But it never really rained that always expected on the first. Yeah Because that's just the way the system works when it's going through and like oh that didn't work that didn't work That didn't work. It's so it artificially drops. Thank you for the the project. Yeah Now I remember the first time that happened. I was like, oh my god, we're losing everybody They hate my show they hate my show Well, you know, it's I mean they do hate my show, but that wasn't people drop off for reasons that are not credit card oriented However, it is interesting because I figured that everybody would just be on their own 30 day cycle That's how it used to be when we were running Rhapsody is like, you know You'd have some people that build on the 17th and some on the 21st And someone went backward yesterday. I was like, oh my god. This is what happens when you've got more than You know a couple hundred patrons. This is going to happen every day. Maybe I've peaked You know, I was like I was talking to Morgan. It's like honey. I think I've peaked No, no, that's all every single day and for the first time I've gotten to the point Where I had what is non euphemistically and without any kind of irony called in business negative gross Uh also notice shrinkage, but okay, so I'll have to do this once week That's great news and like I said I've already clawed myself my way out of that whole And I'll remember this in fact I'm going to put a reminder in my calendar to not freak out Yeah on a first just don't look between the first and the fifth. I'll put a reminder. Don't look at patreon Five days or just you know, don't take those numbers seriously until the fifth. That's what they shake out funny story They wanted to move to a billing system like you're talking about where you just get charged the moment you pledge and you're on You're on 30 day cycle And that caused the whole fiasco in december that they then backed off of what was that? I don't remember that so in december patreon Said we're going to change it to this 30 rolling 30 month thing problem is because of that when we Bill it's going to cost more because right now we can put all of your things through as one transaction And there's certain processing fees that are per transaction So if we're doing it everybody at a different date, you're going to have more transactions So creators to make sure that you don't have to pay that We're going to have that processing fee paid by the supporter Because the supporter will barely notice it because it's a small percentage. Well, yeah, but it's not a round number anymore They'll notice it in a heart. Also, I play five blocks. What am I getting charged 521? That would the supporters definitely noticed it because a lot of them say well, wait a minute I'm supporting 20 different people And now I'm going to have you just raised. Yeah, you only raised me, you know Five cents, but it was across You know five cents per dollar across 30 different supporters. Some of them. I'm supporting at five dollars You just you know, I and so people started canceling their pledges because they couldn't support as many people and they backed off That's why I Fiasco, huh? That's a good name for it. Yeah, I don't remember asking. I get it. Yeah It's an apt description though. Yes, indeed. All right Show tie it all Autonomous road rage and uh car teasing Car teasing I think is I think it's a phrase that roddy just came up with when we were talking and it just tickles me But I'm obviously biased so I shouldn't have a vote in this. Oh, no, it's great. I love it. What do you think, sarah? Uh Sure car teasing It's the new cow tipping, isn't it? Or maybe car teasing colon the new cow tipping question mark We'll can hmm The only my only reservation is that it kind, you know, it's like We were discussing an incident where somebody died. Oh true You know just how about slowing down self-driving? Very apt. Okay. We'll do that descriptive Yeah, it is tricky when you've got fatalities involved the whimsical names become less funny Again, great. Can you guys hear me? Yes, we You're back.  Luckily this didn't happen during the help problem. I can't I'm not so I still can't hear you Am I audible? Don't touch anything you were just touching. Oh wait. Now I can't hear you Okay, I was holding it. I'm holding the plug into the mic This blue icicle thing is not all that it's cracked up to be. Okay, I'm gonna let go of it now Let's see if I go mute. You can still hear me, right? Yes. Okay, good Now are you using a xlr cable between the icicle and the mic? Yeah, I'm using um, yeah, there's an xlr The icicle is kind of an xlr adapter that goes to uh usb. I believe right? Yeah Yeah, so the the icicle itself is you plug a mic into an xlr And what I've been touching at the bottom of it is just sort of the usb cable that Connects the icicle to my mac so maybe I just should replace that cable and quit blaming blue icicle and the good people there Do you but I think what roger was asking is is there a cable between your mic and the icicle? No I'm wondering if maybe you want because it sounds like you're having a strain cable strain issue where it's pulling on Pulling on it. It was pretty loose over here. It's it's a couple feet of slack Um, but you know, we got through the episode and I'll look at it More significantly, I'll have morgan look at it because she's much smarter about all things technical than I am Well, tell morgan uh that uh my experience with the icicle is it is a little delicate. Yeah so sometimes that Plasticy connection thing starts to to get a little wonky and using a cable between the mic and the icicle We'll obviate that because the mic itself can strain it more than Right. Well, check out. Um when it goes up tomorrow check out the george church episode I think all of you guys will be I was blown away by some of the things that he has in a five-year time frame And I came out of that interview. This is a couple weeks ago kind of walking on air Feeling like there's some really amazing stuff that's around the corner and george is a very Understated he's not a there's not a drop of p.t. Barnum's blood in him. Right. He's a pretty humble understated guy And um and I ran it by uh another uh genomicist Basically, you know, he and I did some sort of color commentary on it and our our extra for patrons thing And this guy's like, yeah, no it's george's is the guy and his predictions have had a habit of being conservative Over the past 25 years that he's been a prominent person on the scene. So Uh the organ shortage may end Zeno transplantation pig organs into Humans, which there's all kinds of cool stuff coming. Anyway, I'm just I'm plathering now, obviously I Okay, so one of the the uh after on episodes when when I was doing them with you for the book That I was so excited about was involving, you know, the programmable dna and all of that So I'm pretty excited to hear more along these lines. It's Yeah, and Andy was one of the people Andy Hessel that that episode. I think it was my Fourth episode He was one of the people uh who introduced me to george and then a later guest also did And in the world of genomics, I mean getting george. It's really strange. It's like There's no other field that I know of Where if you ask like hey, who's the top person in the field normally you'll hear well, there isn't one There's these five or six people, right or five or six names will come up in genomics in synthetic biology It is literally just unanimity. It's always while there's george church And then it's almost like the first one michael jackson with michael jackson Um like michael jordan with basketball in the 80s right is just this Unanimity that you don't get anywhere else. So it was pretty pretty darn exciting. We sat down for over two hours Uh like end of day's weather in boston on a friday afternoon So I was expecting him to say dude. I got five minutes and hop but we really really spent a great deal of time and we structured the conversation in a way To really be very uh explanatory about you know How is genetic sequencing different from editing different from synthesis different from assembly and now that we've got all these baseline terms together Let's go into this sort of the wild blue yonder of the near future And things that are going to be potentially very very transformative. I think all human society in the next five to 10 years So anyway, that was that was fun from the guy who brought you crisper. I mean not the only guy right but still Yeah, he basically is the guy who brought us crisper. I mean there are a lot of there There are a lot of names on the patents as there should be but he did the first work You know he did the first work and probably the most influential work Um, well, I just got a response from this dog fostering organization that I was Yeah, I'm you know, I'm not ready to get a dog. Um, but I like the idea of being part of you know Helping that you know that the system work better. Um, and they just got back to me and said oh got your application Sounds really good. Let's talk Cool It is but it's marlies mutts. Um, marlies mutts is um, I uh, they're in particular I I know some folks who work with incarcerated people and um, One of the programs not the only one but one of the programs with them is That uh, certain dogs are placed with uh, you know a good match Uh, and somebody who's in jail, um helps, uh, you know train them and you know Get them to you know, be more comfortable with the people and you know, it's a temporary situation But um, they've got a really great instagram page and I'm just like Looking at it crying one day like I really want to volunteer these people. They seem like such angels. So maybe I will That's very cool. Yeah, it's hard for me for us to foster dogs because we want to always keep Yeah, exactly It takes it takes a special kind of person and and they exist Yeah to do it on the rotating basis Well, I mean and I'm not totally sure it's like It would depend on the dog, of course, but it's like, you know, I I already have animals You know, I I'm not necessarily the idea isn't just to like get a bunch of dog crates in here and like go nuts But to be able to be part of you know, placing them and and you know, just hanging out with them and I worked at the spca in san francisco years ago and um Eventually I got busy and I couldn't do it anymore on the days that I wanted to but it was very rewarding You know just makes you feel good. Yeah, that's very cool.  No google probably auto muted him when it noticed that his mic wasn't Working properly that happens So you'll need to unmute and hang out there and then No There you are. You're back. Yeah, see it has that telltale crackle Whenever you connect again that really sounds cable based The other solution is to buy a sure There's a sure adapter It's a little more expensive, but it's a little it's a little more durable Could you send me a link because I'm going to do that I think it's time now and certainly the thing I asked I thought I was asking you but I was just asking ashby the dog because I was on mute Does this thing do they literally send dogs into the prisons to be trained? Yes, really So is it minimum security? Like I can't imagine all prisons. I was just at san quentin actually last week literally Doing a visit with last mile, which is one of these groups that works with incarcerated folks And I couldn't imagine dogs at san quintin. So is it is it lower security prisons or? Well, I'm going to have to get back to you on that. But yes, I uh, I'm under the impression that I mean, these are prisons where it's like they've got these whole kind of like it's like it almost looks like I don't know Well, and they just you know, they've got like little things, you know for the dogs to jump over and you know The whole thing is is training. That's cool. It's training. Yeah. So it's like Yeah, not everybody who's you know in prison for whatever reason is is going to be a good match for the sort of thing And I don't know that much about it. But I looked at um I looked at enough for the photos where I was like, wow, you know, if this is something that was it's something I could do in la that was you know, not super time prohibitive or whatever. I I'd I'd like to know more so Can you guys see ashby again? We got hi ashby Oh, buddy Oh What a sweetheart Oh So before we shut down the stream, I want to remind folks that I have a follow-up to pilot x funding on ink shares right now Yeah, it's called Trigor t-r-i-g-o-r And we're just shy of 40 funded. You could be the person who pushes it past the 40 percent mark How does ink share work? I don't even know of this. Is it like a Kickstarter for books? Ink shares is what I did for pilot x and it's exactly that uh, if we get 750 pre-orders it gets published So ink shares works like a normal publisher everywhere except the slush read Uh, the what what the editors and slush readers would normally do is done by the crowd And then once it gets to 750 pre-orders, then it goes to a professional editor and gets a marketing plan and the whole ball of wax So very cool. Yeah So you can go to ink shares dot com search for t-r-i-g-o-r just search for my name And take a look there's a couple sample chapters up there as well And I know a bunch of you guys read pilot x so if you liked that and you would like more ink shares dot com Rob, thanks again for joining us man. That was a really good conversation Thank you as always for having me. I'm always delighted to be on this show And it's very kind of you to put me in my work in front of your substantially vastly larger audience It's very very cool. I really appreciate it. It's easy when you have smart people coming on talking about interesting things Yeah, I get good guests. I've been very blessed in that regard. No, I met you coming on our show Oh, you do the same thing on your show I just come in with a transitive property of smartness of the guests who have hopefully rubbed off Everyone will hug right now and then I'll stop the stream All right, thanks Roger. All right. See you guys tomorrow. See y'all


This paper examined a new hydrological landscape classification method based on dominant runoff mechanisms. It identified three landscape classes, wetlands, hillslopes and plateaus, corresponding to three dominant hydrological regimes, saturation excess overland flow, storage excess subsurface flow, and deep percolation. The study found that topography, geology and land use were key factors in determining these landscapes. Additionally, two indicators hand, height above nearest drainage and slope proved to be effective in classifying the landscape. The study also assessed the sensitivity of the classification to sample size and resolution. Overall, the results showed that the hand-based classification was an efficient method for reading the landscape and developing conceptual models. This article was authored by Askarari, M. Frakowitz, F. Finisha, and others.


As an agent, should you have your own logo? If you have your own company, you have your own LLC, if you're wanting to get paid as a self-employed individual and you're wanting to save some money on taxing and stuff, start to brand yourself. Even our secure agent mentor logo, it's evolved over the last few years. It's nothing what it used to be. Even now, this logo is almost outdated because now we just use an M. There's no reason for words, there's no reason for circles. All logos, you'll notice most logos start out super complex, a lot of moving parts, and then they get simpler in time. Look at Starbucks' logo. Look at McDonald's. I mean, there's an arch. Look at the swish for the Nike.  They're going to lose it for get it, who cares?  Just think outside the box. There's so many new things that you can do to stand out. For this 8% nation insurance conference, we're not going to just give everybody a pencil. We're going to do something that's going to be unique that you're going to remember that you may use later and may think about the event because of that. When you're thinking about logo, branding, marketing, think outside the box a little bit. Think about having a logo, think about growing your business, think about taking yourself seriously. It all comes down to taking yourself seriously. Are you a business? Do you want to blow up? Do you believe in yourself and is all these things going to help your business as you grow? Because I'm telling you what, whether you think you need a logo or not, if you want to be a solopreneur forever and you want to make a little bit of money and you want to just be by yourself and be selfish and not help tons of people, then don't worry about any of this and turn the video off now. But if you want to build a brand and grow and leave a legacy and think bigger and help way more people, then these things we've talked about may be important to you.


This is the VOA Special English Technology Report. Benjamin Stassen took his own life in 2010. His parents thought their 21-year-old son was happy. Since his suicide, they have attempted to learn why he killed himself. Alice and Jay Stassen thought Benjamin's Facebook account might hold clues to his suicide. But the account does not belong to them, nor did it belong to their son. Facebook owns everything in his account. That is what the company says in its user agreement. Jay Stassen says he found it difficult even to communicate with Facebook. If you search on the home page of Facebook for an email address, a mailing address, a phone number, or a contact person to help, he says, you will find little information. A court ordered the company to let the Stassen's see their son's account. But Facebook has yet to obey the order. 34-year-old Mack Tonys died in his sleep in 2009. He left behind a lot of online friends, many of whom liked his futuristic blog, Post Human Blues. Work on the blog stopped when he died. A short time later, the comments area was filled with unwanted advertising. That angered his friend, Dia Sobin. He said the advertising, or spam, dishonored his friend. Lawyer John Boucher stays informed about digital rights and the law. But he admits that he and his wife have signed many user agreements without reading them. He says he would not know how to get information from his wife's accounts if she dies. Mr. Boucher says he thinks that laws will be written over time to deal with these situations. But it will take a long time to be accepted by the states. Some businesses now are offering people a way to control what happens to their online information after they die. One way to do this is to place your online accounts and passwords in a digital storage area. You give the owners of the area orders about which information to destroy and which to give others when you die. Mark Platner was one of Mac Tony's friends. He recently used a program called Sitesucker to download Mac's blog. He then uploaded a copy of the blog to a new website under his control. Mark Platner says we should all plan our own digital legacy. He says don't be passive. Get to work on your online afterlife now. And that's the VOA Special English Technology Report. You can leave comments about this story at voaspecialenglish.com. I'm Carolyn Presuti.


Hello everyone, welcome back to another video. In this week's video I've picked five new formulas available to us in the Office 365. I just wanted to do a dedicated video towards to go through each one just to hopefully go a bit more in-depth and show you what each of these formulas does. Each one is really simple to understand and get the grasp of. You might have actually seen me use a couple of these in previous videos But I thought it just really beneficial to do a dedicated video to go through each one independently Because we'll probably be using them a lot more in the future. So to go through each one We've got round array sequence sort by and unique So we'll go through the first two round away and round away and then also sequence In this sheet then we'll jump over to the other tab I have there just because I need a bit of extra data to do so. If you do enjoy the video Please do give it a thumbs up. Also, if you're new to the channel or your previous viewer Please do subscribe. Hit that bell notification button as well And that way you'll be notified of our new videos as they come out. So without further delay, let's jump straight in So random array is really great for generating random numbers So people often ask me about this in regards the content I use for this tutorial Is there a quick way or easy way to generate random numbers in? Excel as a standard or not as a standard but in Excel we have a formula called random number of them beginning with random So we've got round round array and round between so previously I would have used this formula what gives you a give you a random number and Simple way to use it is say we want a random number between one and ten Do this hit enter and you can see that a random number has been produced for me If I hit f9, which just as refresh on the sheet You can see that every time the sheet is refreshed another or the calculation is Recalculated and a new random number is produced This is great And obviously what you can do is you can drag this down and then you can obviously and drag this out and you can Gradually build out a range of numbers that again when you hit f9 are going to continue to randomly generate The benefit of round array so the new dynamic formula We have is it kind of takes a lot of this work out for you allows you just to pre-determine What and how much information you need? So with round array all we need to do is equal to equal brands and hit in array And you can see we've got a number of values that we can enter in here So the first one that we've got is rows So if we just enter in say we want ten rows close brackets and hit enter You can see how our formula spills so it covers the range of ten rows as we required and it gives us a random Load of random numbers that we have in there. You'll notice at first. There are decimal decimal numbers But we'll get on to in a second. What's that the last? Edition we need to add into this where it allows us to do if we want an integer So a whole number instead if you go back into the formula and Let's just remove the bracket off the end there to get back into here And let's say we go into columns. I'll just do a comma there and let's say we want three columns and Then open or close our bracket, sorry You can see now how that range has been spilled over to now three columns in addition to the ten rows And once again if you hit F9 each of those are going to be randomly generated each time the page refresh Let's get back in and it's worth mentioning here if you weren't aware Because the formula has spilled it looks like if you click anywhere here that you will see the same formula But in fact, you just need to go back to that first cell there just to make any edits that you're quite So this is where we can now get a bit more Put in the determination that we require So let's say we want to have a minimum value will be number one and let's say the maximum is 10 like we looked at earlier Go to 10 and then do another common and this is where we can now determine So if we enter false, we'll get decimal and as you probably aware because we didn't put Previously false is the default value, but let's say we want to use an integer So we just click true or you could have typed in there alternatively Close your brackets and hit enter and you can see you've now got those random numbers generated for you So just to go and start over again Let's just remove that and the real benefit obviously using round array is say we wanted quite a lot of random data All we need to do is go around between Open brackets Well, I'll put the wrong one on there now. I've gone back to the first one. Let's go round array and Let's say we want a hundred rows By a hundred rows and we wanted random numbers between one and ten and we wanted them to be Integers for the brackets so you can see that is a lot quicker way I've obviously putting those random information in there rather than doing that round between What we've previously had available in Excel So we can close that and there. It's gone. So that's the benefit of using around the way It just gives us the benefit of quickly getting a load of random information Depending on a couple of key pieces of criteria that we acquire So that's round array done. Let's just mark that as yellow. So for sequence So sequence is really good for creating an array of sequential numbers So going from one to ten or whatever you require If you do equals and then enter in here sequence And brackets so you can see rows is a mandatory field So we do have to put in a number of rows and we'll gradually go through this So let's say again, we want ten rows You can see that it's given us ten rows of information and it goes sequentially up from one through to ten So that's just the default value. Obviously if we put in here only five It's going to give us the same but only you'll see up to five rows worth of sequential data If we now want to change this, I'm just gonna put it back to ten just because it gives a bit more information and I say we now want to go over five columns close brackets You can see how again, we still got sequential data over ten rows But what it's actually now done is it's spread it over a number of five columns to be exact So that we have sequentially from one to five across the columns So obviously this is what we're referring to here one to five and then obviously ten rows worth means that obviously It's going to go from an overall total of one to fifty So this is really beneficial if you again want sequential data if you're potentially building a chart or some kind of I don't know Examples escape my mind But again, it's really beneficial if you're trying to show growth over time So that's probably a better definition of why you want to use this So to go back in and probably Re-clarify why you probably use sequence we can now say And then columns we can now enter what our start number is. So let's say our start number is a hundred and We want to step so what is our step so step is the sort of the addition We want to apply to our starting number. So if we were to go step is let's go ten and close brackets You can see that our starting number is a hundred and then each sequential number is going to add ten to that So it's now going to go from a hundred all the way up to five hundred and ninety and again This could be a good Then or use the data if you're trying to do like maybe a graph or something to show sequential growth over time You might not want to do it over columns But you get the idea that if we again, maybe didn't want over a number of columns We only wanted over the single column That we can obviously just do that and we can show see the starting number of a hundred growing by ten each time over ten rows So that is how to use sequence So for the next ones I'm going to jump across to our other tap here I've been named the central Excel because we've got some information in here to show us And let's just copy them across just so we can remember what we are looking at Let's put them over top here. We're always doing that one there So format is a bit different. Cool. So we're looking at sort now So the real benefit of using sort or basically a neighbor gives us the ability to dynamically sort the data We're working with and I emphasize the word dynamic because as the data changes So will the information that is spilled using this formula to use sort What we do is do equals and then the word sort and open our brackets And then the first thing when you do is select our array So you can either select your range by obviously doing selecting the range as I've done here Or because the information I have here and you might recognize this from a previous video I've done Because it is a table if I hover in the top left hand corner get this black diagonal arrow I can just select the table as a whole. So that's another little tip there Once I've selected the array either by selecting the table or actually manually selecting a range I can just do common and so sort index is going to be okay What is the column within that range that we want to sort by? So we're going to sort by salary. So for us, that's going to be column number three Moving along that's sort order. So you can even go obviously ascending so small to largest or descending largest or smallest in our example For us, we're going to go ascending orders. So we start with the smallest salary So we need to do the number one there or of course, you could just click this here if you wish And lastly, we've got our true or false. So true being sought by column So what that will do it'll put on what the value or the column was sorting by being salary It'll put that in the first column, but we just want the same in the same order So department name and yearly salary. So we can just go into false here But actually you don't even need to put this information in because it is an optional field So if you want to do that's what you you do with that else All you need to do at this point is do a close bracket and you can see how the information is sorted for us And there we go We can see that we've got our department name and yearly salary So the same orders are table on the left, but this time our salary is sorted in you ascending order as Mentioned before because this is dynamic if we get and change anyone. So let's say Bruce here. Let's put his salary to 15 You can see how automatically that's pulled through to our sorted information Just to do one more. Let's go into Naomi and let's put that down to maybe 1500 Again, you can see how that's sorted as well. And if we suddenly changed our mind and we wanted to do this and into Let's say descending order rather than ascending What we need to do is click our ascending or descending there or minus one hit enter And it's going to automatically sort for us as well The next one we're going to look at is sort by Well, it's exactly the same as sort. It's just that sort by allows us to add multiple Sort sorting criteria. So basically sorting by multiple columns would be an easier way of putting it So let's say we want to work the same way we're doing. So we'll go equals sort by And this time we want to select our array. So nothing different now Okay, so by array one. So what is the first piece of information? We want to sort by well I'm going to do it by department. So again the same way I selected the range of information You can either do this manually by selecting here or because my information is within the table All I need to do is hover at the top here and you see it selects that particular column within the table if I just go Column here not column comma. Sorry. I didn't have the choice of deciding whether I wanted to be ascending or descending Because we are working with text here. This will be alphabetical in ascending. What sounds logical So I'll go for that. Let's go ascending order there Let's do comma and then next one is name. So I also want to sort by name So let's go to the name column Do a comma and this time again. I want to do it in alphabetical order So I just want to do the number one again close brackets and hit enter and you can see now how our table has been sorted by first department and then name in alphabetical order and then also by yearly salary I only did the two criteria there, but we can indeed do more if we so wish We want to go one step further and say, okay, we also now want to do the yearly salary and We want that also in ascending order. Well, actually, let's go into descending so minus one So we can now see all our information is sorted for us and once again If we had to change any of this information so Bruce down here So you'll see him on this line at the moment if we changed his salary to 100,000 You can see how it's automatically populated for us And I guess another example here. So let's say Beverly Atkins Where is she so she is in finance. Do do do do Beverly Atkins in here. So let's say for whatever reason Z just because it's the last letter we take that you can see how a Zevely now named Obviously moves into a different order because she's now her name is now last in the ascending order for the cap department of finance So that's how we can filter or not filter. Sorry. That's how we can do sort by with Multiple criteria across our columns The last one we have to look at is using unique. So unique is a real powerful Former for using many times personally, I'm sure you do as well when you're working with data You might have duplicates in there either rightly or wrongly and you just want to understand Okay, what are all of the unique values? So I don't want if someone appears 10 5 6 how many different times I only want a list that shows me each value appearing only once and this is where unique comes in perfectly handy for us in Previous or in Excel you obviously have the removed duplicates button and there might be some complex formulas You can often use to get unique numbers, but there's nothing as easy as there is now So if we go into unique open our brackets And for us, I'm just going to go and select the department option here So let's go to department That column and if I was just to do close brackets now and hit enter You can see it gives me a unique list of all the values that appear in that list And as you can see on this list straight away We've got sales in here just like five times at least or six times that you can just see Obviously what it's done is removed all those duplicates and just giving us a list of unique values If you wanted to go by further what we have the ability of doing here is to say what do we want to do? So we've got true here if you want to return unique columns or false if you want to return unique rows Well for us, we just want to do unique rows because that's what we're working with here It is an optional field so you could even do a comma and leave this blank and then another comma to move on But we'll just populate this so we want return unique rows and The last option we have here is we can do return items that appear only once So if we had to do this option for true and close brackets You can see at the moment we get an error because there's nothing that only appears once if I was to change sales to sales room Because that only appears once unless let's just do here. Let's just do sales law You can see how those two values are being pulled through simply because they are only appearing once in the list as our formula says But if you want to have an actual unique list of all values just appear in once then we just need to do the false option here and hit enter and you can see we get that now and You can see what sales room and sales floor in here as well But let's just put you back to sales as they should be What also demonstrates how great and dynamic this formula is and we got our dynamic list there as well So hopefully enjoyed that tutorial. We went through obviously five new formulas that Hopefully you weren't aware of and you've learned something new or if you were aware of them Maybe you've seen them in our previous videos or a couple of them at least at least It's gonna be a bit more insight into how each of them works and the benefits of using them They're not available at the moment in Everyday Excel you need to have the office 365 subscription to be able to use these functions as it stands But I believe it's really personally beneficial to try and get access to these and start familiarizing yourself because as soon as they do become available these can be really powerful formulas and They're gonna save you a lot of time and hassle with doing some Sometimes quite complex things, but now we can obviously achieve them using relatively simple formulas So if you haven't already, please do give the video a like It's not only appreciated by myself But it also helps that all important YouTube algorithm and make sure more people do find this video and others on our channel If you are new to the channel or you have seen our videos before please do subscribe Also, make sure you hit that bell notification button so you're notified of all of our future videos So that's everything in this video. Thank you very much for watching and I shall see you in the next one 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


Okay. Okay, we'll get started. Steven Ellis talking about resource allocation using C Groups. Hi, a few of you will probably remember me from previous Linux cons. I recently started as the Red Hat solution architect in New Zealand. At the moment we're currently based out of Ingram Micro's office there. Red Hat's got quite a good presence at the moment in the New Zealand market. I'm here to talk to you about C Groups. Anyone in the room had a play with C Groups yet? Anyone know what C Groups are? Okay, alright. So what are C Groups? Why are they so useful and important in your infrastructure and your operational day to day use of Linux systems? So what's it all about? Well at the end of the day is your hardware starting to get faster and faster. We're starting to put more and more workloads on their equipment and in the traditional Unix space there's been a series of methods to manage those resources effectively in order to meet various SLAs and prevent resource contention. That's been slightly lacking in the Linux space so now C Groups has come along to fill that gap and it basically provides an internal feature to control that resource management and then the user space tools and libraries in order for you to set the rules around how those resources are going to be allocated either on a per process basis per user basis and there's a whole variety of resources that it can manage at present and this is an ongoing project so expect additional resources to be pulled into the project going forward. So here's a kind of typical use case in this example. We're talking about a virtualised environment so we do the resource management at the hypervisor and we say that virtual machine A is only allowed a maximum of 40% of network but 50% of the CPU and so forth and break things out but this could easily be applied at an application level so that you've got a say a mix of database service running on the same server and you want to control the resources allocated on a per database instance and there's a lot more to this. For any of you ever had the instance where you can't actually SSH into a box because it's that busy. Brilliant use case all of a sudden we can now prevent that by saying that no matter what's going on the SSH process has a higher resource allocation or has a higher priority over other system resources so the control group is just the framework for allocating and managing those resources within that we have a series of controllers first of which the memory controller so we can say that this resource is only allowed a certain amount of memory from the operating system then we've got a scheduler to attribute a portion of the CPU resources which is going to like a waiting system so you say this one's got 500 shares this has got a thousand shares and it will wait the load accordingly. Come on go forward the IO controller so here we want to control the amount of disk IO so that say your PostgreSQL server doesn't get swamped when you want to run a backup. We want to manage the network which I have to say I haven't played with myself it's actually interesting learning curve in order to do the network controller there's not that many great examples out there at the moment so let's jump forward so here we go let's break things out a little bit more so you've got your memory controller CPU set is a bit like task set so say these processors are allowed allocated are allowed to utilize particular CPUs on a multi-core system CPU account gives you a breakdown accounting level of the number of cycles used by a systems allocated to a particular group and then the device controller actually allows you to disallow access to particular devices so say that you want to spin up some aside from using tools like SE Linux to do control around what resources a process or family of processes of access to you can actually also do some smarts using C groups there's some other controllers in there things like the network controller this freezer and this keeps moving around and it has a AV system will turn off in 15 minutes I'm being told touch the screen cancel warning right and it has a hierarchical model which means that you allocate a when you start process up you can allocate it to a C group like it's a demon sequel and then every or demons HTTP that every child from it is basically picks up all the same resource pool and it's the family of resources the tree of resources that has the restriction applied so if you say that the resource pool that was running your Apache server has a upper threshold of a certain amount of RAM yeah then you know that the Apache instance and its children will not exceed that amount of RAM so let's look at some of those subsystems in detail with memory you can limit the memory and also pull statistics back from the C groups hierarchy about the amount of memory currently being used CPU usage what was CPU accounting here we can pull back the number of cycles being used so you may be charging a department or a client for the number of cycles that they're utilizing and bill accordingly CPU shares so here's a waiting model so we'll be in order to do this would say wait sequel with a thousand shares and HTTPD with 500 shares and therefore it gets when there's resource contention it will wait in the way of the sequel server but it won't deny HTTPD CPU resources we go jump so if you want to start using C groups it's on modern most modern Linux distributions have it now you can just go your install I've get install they'll usually come with an example CG config which is what you need in order to set up the virtual file system that C groups uses to manage its configuration on say Ubuntu that would be under slash dev slash C groups but under well six and for Doric tends to be slash C group then just simply start the demon and away you go so it was you can then basically do an LS and look into slash C group slash CPU set see what the default default rules are they also installs a bunch of command line tools so that you can use CG exec to start a process and allocated to a particular C group move CG classify effectively takes an existing PID and moves it into a given C group you can create C group rules either that directly onto the file system or you can use the CG create CG delete command line tools to manage those but you can actually just script this into the CG config script so that when you start up the the background demon it already has a series of rules defined so here we've defined a basic rule for Apache where that its memory allocation will never exceed a gigabyte in the case of Enterprise 6 and Fedora 14 the HTTP demon has a Sysconfig file as soon as you add that line in and start the service it's immediately C groups managed now I haven't looked on this on things like Debian Ubuntu so you'll have to go and dig that one up having a chance to have a play but in the case of RedHouse distributions it's very easy to manage if you're doing this with say virtual machines you may decide that you want to limit your virtual machines to never exceed three and a half gig one and a half one way of doing that is on a most Linux environments you're going to manage those via liver so you restrict liver then everything liver creates live within that three and a half gigabyte pool and you can say well I only want liver to access CPUs one through three and they'll be locked into their word of warning if you only have two CPUs CPU zero and it's CPU one don't say one through three because it won't start up actually checks to see how many CPUs you've got and again liver has a Sysconfig entries on a rel six or Fedora 14 system so you just create the appropriate entry need to see Sysconfig liver and you live that's fully managed then by C groups come on jump forward CG Red is another demon that allows you to then also attribute rules to users or groups of users so here you may decide that users on your system are assigned the staff group but then you can also go further and say that if that user starts up the FTP demon then they also pick up an additional C groups classification and it may be that the FTP you want to disallow access to a whole group of devices just as additional security policy or give it a different set of permissions or a different level of resource allocation and you can manage all that by that demon if you want to go and have a play these slides will be available afterwards the rel six has some great documentation as part of Red Hat's normal documentation which is just available by their website Fedora's got an overview on the Fedora project wiki Zonka's been doing a series on C groups on server watch he's done two articles today I think it's going to be an ongoing series of articles so that's one to watch for I highly recommend having a look at that and if you're using it on Debbie no Ubuntu have a look at the bottom link so any questions I suppose the obvious one is this it works you put your deliberate logic bombs in there and they just get constrained to their little X percent so you put the deliberate logic bombs you know the the one the 15 character or bomb or those sort of fork bomb type attacks those sort of ones they get constrained yet they should get restraint constrained I'll be interesting one to try out in terms of testing that it's behaving on your system one that tried out is actually using some of the lipvert stuff and making sure that given virtual machine actually doesn't get over a bit as an allocated amount of CPU use so you know cat there view random or pipe it through G zip in a virtual machine over there do something else over there and monitor the CPU allocation and it's in kernel it's been in kernel for a long time but it was called something else and it's been renamed C groups I'll tell you in a moment I've got up here process containers yeah okay I've just got a question how does it compare to the hard separation that you get from say VMware ESX or or KVM something like that is it strong enough that you can use it maybe with containers or something like that namespaces to give you something like that or is it how close is that I wouldn't rely on it's as it's only part of the solution if you look compare it with like a container based model or using virtualization it's the way of controlling resources it is in a way of controlling you seeing other resources so it's only a piece of the puzzle so say you're running multiple databases for different clients but on the same server you need to meet various SLAs it's one way of doing that but if they need access to the server where you they'll see that you're running other database servers on that box doesn't provide any security per se except say at the case of the device C groups that you want to black block off access to selected devices on the system and what we don't


Suika Game, the watermelon-merging puzzle game, is coming to iOS, having already enjoyed several months as the Nintendo Switch smash hit of the moment, but not all is as it seems. This innocuous game actually has a murky history of copyright infringement, fraud, and downright theft. The game, published by Aladdin X, seemingly came out of nowhere to become the top downloaded game on Japan's Nintendo eShop in 2023, even beating the Legend of Zelda, Tears of the Kingdom. As is often the case though, while Suika Game, or Watermelon Game as it is also known, appears to be an overnight sensation, it actually released all the way back in 2021. The game's sudden meteoric rise is not unlike the journey that took among us to the top of the charts in 2020. After lying mostly unobserved on the eShop for two years, the game was picked up by several prominent Twitch streamers. Suika Game quickly became incredibly popular among content creators, leading to a sudden influx of new players. What's notable about the game is that it wasn't developed by a game studio at all. Aladdin X is, instead, the manufacturer of multimedia electronics, and their version of Suika Game started life as a built-in game for their ceiling smart projector, Popin Aladdin. When Suika Game proved to be a big hit among Popin Aladdin users, the company began exploring other options for publishing the title on app stores. Speaking with Nippon TV, a spokesperson for Aladdin X said of their decision, there were other options, such as a smartphone app, but we decided to offer it on the Nintendo eStore because it had a better chance of standing out, rather than being buried amongst a lot of other apps. Aladdin X is very proud of the success they've seen with Suika Game, and the company is apparently eager to protect their copyright from those who would infringe it. When a version of the game appeared on the iOS app store, using Suika Game's art assets and the text description from the Nintendo eShop, Aladdin X was quick to denounce this as an unlicensed copy. In a text on... X. Formerly Twitter. Aladdin X said, We have not developed Suika Game for smartphones, and applications that closely resemble Suika Game posted on the app store are not affiliated with our company in any way. We have also reported this matter to Apple, the company that operates the app store. Please be careful when downloading applications similar to Suika Game developed by our company. Yet while Aladdin X can be protective of the art assets that they created for Suika Game, the company cannot prevent developers from creating copycat games, because Suika Game is itself a copycat game. It could be argued that the reason Aladdin X worried that Suika Game would be buried on a mobile app store is because there were already plenty of identical games on all mobile platforms even in 2021. The original game, whose name translates appropriately as Synthetic Watermelon, was created by a Chinese developer, Wei Umbrella Games, in 2021. Here is where the story gets even more interesting, as the original version of the game is no longer available, following a scandal involving fraudulent advertisements and the theft of unsuspecting players' money. Synthetic Watermelon could well be called the Chinese equivalent of Tetris. It's a simple game which involves falling puzzle pieces. It's fun to play and endlessly addictive, and its transition to markets outside of its home country has been highly controversial. Wei Umbrella Games, a subsidiary of Beijing Mido Technology Company Limited, released their own version of Synthetic Watermelon on 22 January 2021, long before Aladdin X released their version on the pop-in Aladdin. Synthetic Watermelon was played by over 40 million people before it was shut down. It was significant enough that an academic paper was published on the popular science China website, analysing its skinner box mechanics and fundamentally addictive gameplay. The mobile game was available to play for free online, but with one key feature that is missing from the Aladdin X version of the game. In the top right-hand corner of the screen, Synthetic Watermelon featured a present icon which appeared to be integrated as part of the game. Unsuspecting players who tapped this icon were told they had won a 100-USN voucher worth approximately 10 pounds or 15 US dollars. All players needed to do to receive their prize was to provide their personal details and pay 19.9 yuan, approximately 2 pounds or 3 dollars. It's estimated that 1.6 million people were tricked by this alleged scam, losing over 30 million yuan in total. None of these victims received their promised money, and as pressure mounted online around accusations of fraud, the original version of Synthetic Watermelon was removed from the internet. Copycat Watermelon Game clones began popping up across the Chinese-language internet and on various mobile app stores. This was the environment that led Aladdin X to similarly copy Synthetic Watermelon, making their own Watermelon Game, leading to millions of Nintendo eShop download sales. The moral of the story? In the words of a quote often attributed to Pablo Picasso, that was almost certainly not actually said by him, Good Artists Borrow, Great Artist Steel.