Hello friends. Welcome back. My name is Suseel Singh and this is continuation of SQL Server intro questions and answers. So today I am going to discuss one more question. And this question is related to city and row number. Here we can understand the logic behind row number and city. So let's start. So here we have an input table and this table is related to phone number. You can see it contains 5 columns. First is ID then the phone type then primary then sequence and then the phone number. So here we have output table and in this output table we have 4 columns. First is ID. Second is business phone number. So business phone number is related to when type input table is B and then the home phone number when type is H and then cell phone number when type is C. So this is our output table and this is our input table. So we can see we have to pivot this input table to get the output table. But the condition is we want those phone numbers which primary is 1. So here we can see we have primary column and then the sequence columns. All logic behind the primary and sequence. And then we want to pivot. So there is 3 logics. First when primary value is 1 then we want that row as it is and we are not going to see another row related to the same type and ID. And then if the primary value is not equal to 1 then we will see the sequence number and pick the maximum sequence number for that row and we want display in our output. So simply we can see for the ID 1 we have only a single column. So this is for business phone number. So 1 and the number is 1. So ID is 1 and the business phone number value is 1 and rest is not available. Then move to the ID 2. In ID 2 we have business we sorry we have cell phone number and we have home phone number. Cell phone number we have a single row. So we will display that record as it is and the number would be 2. So here we can see business phone number is not available for the ID 2 and we have the home phone number and home phone number first is a cell phone number. So cell phone number value is 2 and here value is 2. So this is our output and move to the home phone number. We have 2 rows for the home phone number. First we will check the primary. So primary value is 1 we can find out from here. So we will display 3 in our home phone number. So in our output we can see and then move to the ID 3. In ID 3 we have all 3 columns. Business phone number, home phone number and cell phone number. So business phone number we have a single row. So 5 will be displayed as it is and then move to the home phone number and in home phone number we can see we have primary value is 1. Then this row number is 6 will display in our output and then move to the cell phone number. In cell phone number we can see we have 2 rows. First is where primary value is 0 and second we have primary value is 0. So primary value is 0 for these 2 rows. So we have to move the sequence and pick the max sequence number that is 2. We will display in our output 9. So we can see here. So this is our input and this is off. Let's move to SQL Server Management Studio to write the carry. So this is our SQL Server and I have already created this table which is phone master and we can execute this table. And this is our input data. So this input data and I have displayed in slide. So these 2 data are same. So now we write a query by which we want to display this output. Okay. So you know there is several steps to perform this task. So first is our row number. So try to understand one by one. So it's very easy to understand in row number. I am going to use partition by on the behalf of ID and primary type. So I am not going to discuss what is a row number if you want then go to my SQL Server tutorials and you can see from there. Now you can see I am going to use partition by on the behalf of ID and type. And then I am going to use order by in his primary column in decreasing order and then sequence number in decreasing order. And his primary value might be null. So we are going to use is null and if value is null then it will be replaced by zero. Then it will be sought in decreasing order. If one is available then it will come first then values come for zero and other. And second if the value is same for two rows then it will move to the sequence number and sort in sequencing order. So according to our requirement we can see if the value of primary is not null sorry not one then pick the max sequence number. So by using this condition we can pick we can execute this query and now we can see we want only those rows which row number value is one. So we can filter from here where row number is equals to one. So this is our intermediate input table. So this is our first step. Now moved to our second step. So in our second step I am going to use the pivot. Basically in our input table we can see we have to use these rows as a columns. So we have to use the pivot. So here we can see we have used case statement. So if you haven't watched my previous session please go and watch then you can very easily understand what is case statement and how it works. So here you can see this is our selected statement and we have used one more CTE. And inside this second CTE I am going to use this first CTE. So in this first CTE as we have displayed the row number one we are going to pick the values of row number one only. So then if the value of phone type is B then it will return the phone number for the business. Second if the value is H then it will return phone number for the home. Second is C then it will return the phone number for cell phone number. If I am going to execute this query then you can see it will return the result all these four columns which we want in our output. But the values are not perfect as we can see here we want IDs only once but here IDs are going to repeat more than once. So we have to use one more logic by which we can simplify it and provide output as we want. So I have already typed the query so copy from here and I am going to paste it here and now we can execute. Column name should be business phone number. So it is a business phone number now execute and now we can see the our output. So it seems very good as we want. So this output and this output is very good. So logic behind it I am going to use the group by on the behalf of ID and then I am going to put the maximum business number and then maximum home number and then the maximum cell number because you know there is two rows one value is null another value is something then it will pick the max value. Max value should be where we have some value null value is not going to reflect over there. So if this problem has been reduced by using max and we don't want to display null then we have to use is null and we replace the null value by Na. So this is our output as we want. So I hope you have understand this logic and it's very important. If you like this video please subscribe our channel for many more videos. If you need this script it will be all over on my Facebook page. You can go there and copy. Thank you.


Hello! In this presentation we will discuss the discussion question of why don't we record interest at the inception of a loan? Another way this essay question could be asked is just simply what is interest? What is interest expense? In order to answer this question we need to consider you know how does interest expense happen? How does it accumulate? How is interest used within the recording? And then of course how do we record that interest expense and what is going to be the effect on the financial statements? Why this question is a bit of a problem is because the idea of interest one can be a bit abstract and when we first see interest within the recording of a problem especially within a comprehensive problem or even when with a short answer question we often see something like a loan we're going to take the loan out it's going to be a ten thousand dollar loan we're going to make so many payments and the interest rate is going to be five percent or something like that and when we record the payment then it's very easy for us to start getting confused on the recording of the loan and think that we have to do something with that five percent interest at the point in time that we are recording the loan instead of just doing what the actual transaction is when we first record the loan which would just be a debit to the cash if we got cash for the loan if we took if we got a ten thousand loan for cash and then a credit to the loan payable increasing the cash we got increasing the liability and increasing the payable meaning we are increasing the amount we owe the question then is well what do we do with this five percent interest that a problem inevitably gave us within the problem it's just kind of confusing things I know it's important I know we're going to have a five percent interest somewhere why isn't it something I need to deal with at the point in time that I do the question and if I don't need to deal with it why did the question give us that information there'll be a couple answers to that one is that of course in real life if we had a loan agreement and in real life with many different things it's it's often the case that we have more information than we need in book problems especially with multiple choice questions the reverse is often the case meaning a book problem often tests our knowledge by limiting the amount of information they give us in order to achieve a certain goal or objective and that can really test conceptual concepts well but in practice it's often the opposite it's often that we've got this giant loan agreement with all this stuff on it and we need to pick and choose those things that are relevant to what we need to deal with and in that sense this type of question is good if they're gonna because it's kind of related to real life if if the question is going to give us the full loan terms at the inception of the loan in order to record a journal entry we don't really need some of the information given we don't really even need to know at that point in time what the interest rate is the fact that interest rate is five percent versus six percent versus ten percent at the inception of the loan the journal entry we record when we start the loan process doesn't make a difference now then just to think about what interest is or why that's the case we got to think about what interest is now i would consider i would think of interest kind of as similar to something like rent it's going to be a rent it's going to be very clear people have a good idea of what rent is if we have an office building and we live in it first or you know we work in it basically live in it we're working in an old time for a certain period of time then we're going to have to pay rent on the office building as we consume it as we use it so if a month has passed we pay whatever is due for that month that has passed in accordance to an agreement that we have agreed upon for the rents amount over a period of time the concept of interest is really the same thing except that we were borrowing something that i guess is kind of more intangible more abstract in nature we're borrowing money so rather than having the use of something very tangible very visible very obvious that we're using such as a building we're going to be using something that i guess is less obvious is that's going to be the use of the money if we got ten thousand dollars and we're using that in order to help us run our business just like us consuming the use of a space we're consuming the use of that purchasing power so we have we're getting that purchasing power and that's worth something we're getting the purchasing power today in order to help generate revenue and we're paying the rent in order to allow us that purchasing power that rent is just the interest so just like if we were going to pay so much a month for for the rent on a building we're going to pay so much on the rent for the money now of course the rent on money can be a bit more difficult for us to calculate we might not just say we're just going to pay the the interest at you know a hundred dollars or a thousand dollars a month we're going to base it somehow on the principal and those terms of rents could be confusing meaning we might pay some of the principal and interest back for if we most of us think of like a mortgage or a car payment in which case we pay some of the interest and some of the principal at a monthly time period and in that type of setup it can actually be a little bit confusing what interest is versus what principal is because we're paying off a little bit of each as we go the purest sense or the most easy comparison to say a rental property would be that i'm going to borrow the ten thousand dollars we're going to pay back the ten thousand dollars at the end of say five years and within that time period we're going to pay the rent monthly or pay the interest monthly meaning we're going to pay five percent monthly and not to pay any of the principal back we're going to return the entire principal just like we would return the office building at the end of the time period at the end of five years in that case it would be a very straightforward comparison and we can say okay we're just paying for the use of that ten thousand dollars so the complexity of different loan agreements which which could have a good purpose and they're not complex just to confuse people but you know there's a good reasons why we might want to pay off some of the principal at the same time but the idea of paying off the principal and that the vast ways that we can structure a loan agreement and the way the interest is going to be paid back and how the principal is going to be paid back really can kind of muddy the waters it kind of confuse us in terms of what you know what actually interest is so when considering what interest is it's going to be basically the rent on the money when we record the interest then we're just going to record the interest over time why then doesn't it happen at at the point in time that we take out the loan why at the inception of the loan don't we have to deal with interest well it's going to be the same thing as the inception of a lease agreement when we when we go and say we're gonna we're gonna pay you you know a thousand dollars a month for the next five years in order to use the office building we don't typically write the check for that month in the first day unless we prepay for the office building or we're putting down a deposit because why because we haven't used it yet we're gonna we can't record the expense under the matching principle the matching principle or the expense recognition principle saying that we don't recognize an expense until it has been incurred in order to help us generate revenue uh so in in this case in the case of just making agreement if we just signed a lease with a with somebody we haven't yet incurred an expense because we haven't consumed anything we haven't used the office bill then used the space in order to achieve the goal of revenue generation when we first take out a loan the same case if we got ten thousand dollars today then i haven't i don't have any interest even though i know the interest rate the interest rate is five percent haven't used it though so even though i'm gonna pay five percent just like i know i'm going to pay a thousand dollars on the property i haven't yet consumed that five percent because time has not passed so it's going to take time to pass in order for that interest to accumulate over time and as it does as we consume the use of that ten thousand dollars that purchasing power over time in order to help us generate revenue in accordance with the matching principle that's when the interest will take place so when we take out the loan the you know the transaction doesn't matter what the interest rate if whether it's you know five percent ten percent a hundred percent hopefully not you know twenty percent it's going to be we're going to record the loan is just a debit to cash and a credit to the loan balance that we got the loan payable then over time we're going to have to record that interest as it is incurred in accordance with whatever policy we have it might be that we just pay the interest only on the loan it might be that we pay some of the interest and some of the principal but the interest portion of it the interest portion of any payment just represents the use the consumption of that money at the agreed upon price that agreed upon price being reflected in terms of a rate some type of interest rate that we will have to calculate so if asked the question why don't record why don't we record interest at the inception of the loan or just a simple question as what is interest I would then break it down in in that format in terms of defining you know what is interest how do we use interest and why is it used we have interest basically to record the expense related to the consumption of the value of money in a similar way as to the when we consume or rent the value of a property we don't record it at the inception of the loan because we have not yet consumed the value of the money that we have received just as we have not consumed the value of a rental property at the signing of the lease we record the interest expense reflecting the consumption of the use or purchasing value of that money as it has been used or purchased as time passes where we are consuming that that purchasing power in the future recording interest expense in the point in time that it has been incurred in order to help us generate revenue in accordance with the matching or expense recognition principle


Welcome to ToffeeTV. It is the start of the 11 show. Crystal Palace versus Everton. Everton looking to get another positive result. Get us up that table. Get us in the top half of that table. Just in time for the busy Christmas period. This is the time to start picking up points, getting some confidence. So let's hope we can do that at Selhash Park. Let's get into it in goal. Jordan Pickford of course, our number one. England's number one. Hopefully isn't too busy. And if he is, then let's hope he has a good game. At right back, I'm going with Seamus Coleman. Thought he showed real hard the other night against Arsenal. Listen, it's so obvious we need to replace him. It's so obvious we need to give him a break. It's so obvious, but he keeps playing. He keeps doing his best. Sometimes it's maybe not good enough, but he keeps trying. That's all you can ask of a player. We're flogging him to bits, but he's had nearly a week off for this game. So let's hope he does the business. At left back, let's have a little think about this one. Obviously, Dean went off the side last week. Ben Goff, he come into the side. Difficult one, but I'm going to go with Luca Dean just because obviously, Jerry Meane is missing. And that creates a problem at centre back. Mason Allgate did okay the other night at centre back when he came on, but I'm going to go for Michael Keane. And I'm going to go for Ben Goffrey going back into it. I thought Ben Goffrey did really well the other night at left back. Strong, fast going to the tackle. I just think we need him at centre back. I think, you know, they play for three, three at times. And the other, you know, the Ben Tech, it can be a bit of a handful. I think we need pace at centre back for this game. So I'm going to go back to that back for, because I just don't fancy Mason Allgate in there. Hopefully, Luca Dean comes out with something to prove. Show that, you know, show that, well, you know, I don't think we missed anything last week, but he needs to get some kind of form because he's been poor for a while. And maybe he doesn't recognise that or maybe he's blaming the manager for that, but he's been, he's poor last season, just in his general play. So we need to see more from him. Into midfield, I'm going to go with the three of Allen, Delf and Decore. I think when we brought Andre Gomez in against Arsenal, it made such a difference to Decore. It meant he could start going forward, it meant he could join in the tacks, break the lines, whether it be with the ball or just be that extra player. And I want to see more of that. But I'm going to start with Delf because I think Gomez is someone who does really well when he comes off the bench. I think we have to start strong in this game again.  And then maybe the last half an hour, bring Andre Gomez on, and then let him start being a little bit better on the ball than maybe what Delf will last an hour. We are away from home, so we have to just be a little bit more careful. We have to play three in midfield. We've been saying it for a while, and I think the other night proved that. And I think we have to continue that. I think Delf can start the game and Andre Gomez can finish the game and I think that'll give us a nice blend in the midfield and get Decore going. Another game under his belt, obviously getting fitter and stronger. Don't put too much pressure on him. I think when it's two against three, for me, it takes a lot away from Alan and it takes a lot away from Decore at the moment. Alan's maybe been carrying a bit of a knock as well, so we need three in there for this game. In front of them, it's that understanding going back to his old club. Obviously he wanted to do well. Played for an hour the other night. It was okay, but it was a bit of a strange position for him. He didn't work that, but didn't get that much creative out of him, so hopefully a bit more in this game. On the other side, obviously the Marey Grey, fantastic deal the other night. Obviously the winning goal, but obviously he created the goal for Rich Arleson as well. So a bit more of that coming off the left hand side would be fantastic.  And hopefully, you know, get more goals. Got three the other night, of course, only one of them counter, you know, he's on it again. And he's, you know, the Rich Arleson that we all love, the Rich Arleson that goes out and fights for absolutely everything. And hopefully he gives those Crystal Palace defenders a ton of time. Yeah, because that's what we've got to start doing. Fighting for every point, instead of being so passive in the games and let the games just pass us by and trying to be, you know, let's start fighting for everything like we did in the second half the other night. So that's my start at 11 for the game. As I said, I think someone, someone like, you know, someone, I can't say go much, but it was really important. Subs coming off the bench will be really important. And, you know, the more players we're getting back, that's huge. Obviously Dom's not ready yet and we've had a blow with Mina, but that's a team good enough to be Crystal Palace. I think and get us into that top half of the table if we can as well. So let me know your thoughts in the comments on my start 11. Do you agree? Do you disagree? Maybe people will keep hogging and Dean will stay out. Let me know your thoughts in the comments. Make sure you check out the match preview as well with me and Baz on this one. We've done a video on Dean as well. That's over on our page and we've done a video about brands. That's over on our page as well. Make sure you go and check those out. The links are all in the description and on the screen. Thank you for watching. See you later.


This study compared the effects of pelvic floor muscle training, PFMT, and functional magnetic stimulation, FMS, on urinary incontinence symptoms and quality of life in women with stress urinary incontinence, SUI. Both treatments showed improvements in symptoms and quality of life, however no significant differences were seen between the two treatments. This article was authored by Vilma Dodoniine, Andrew Kirklight, Laura Zlibonite, and others.


Hello, good morning. My name is Markus Richter and speaking in the microphone. Some of the people know my voice already. I moderate the KS radio every now and then, every month. The monthly broadcast of KS Computer Club is approximately two hours long. We have two to four hackers as a guest and they say, this is just too short. We need more time. This just doesn't work. The logical consequence, we're trying 30 people in one hour and please be welcome. 13 people. Why do we do this? Jürgen Hackt is a project that was initiated with the Openish Foundation in Germany to allow teenagers to give an access to hackathons. This is something that comes every year in the southwest and north and center in Berlin. The east one, the north one was in Hamburg and in Berlin there was already in regional events, 15, 20 people in Berlin. And what happens there is, in principle, it's just a normal hackathon. There is a lot of people come together, they should do something, they learn something. Sometimes they have an idea that they want to implement. And the highlight of this year was the event in Berlin where, for the first time, even more people were in, as in this room, it was the broadcast of the end presentation. There was really a lot of people in the audience. Today we want to show you, to introduce you to the people, the young people, the teenagers. How do you say really, young hackers, youth hackers? It's going to be today like a very quick presentation and discussion. If you are interested in one particular project, you can do it on the website of jugentact.de and tomorrow in the center center at noon, 12.30, there is a real presentation. Together we have three big themes, refugees welcome, society and surveillance. And in each of these topics, a few young hackers are invited and they're going to talk about their projects. We have 20 minute blocks. If you have questions, just ask them. Just give me a sign. Stand in front of a microphone. I'm going to see. I'm going to have a look. Who wants to ask the question? We're going to answer them. Noon, enough introduction. Let's start with the first block. Refugee is welcome. Noa is going to... Finn. And please say something in the microphone, Noa. Yeah, this is the project Fack Borders. Yeah, and this is the project Fack Borders. Yeah, we're going to talk about this. Then we have three people, David, Anna and Carl, from the project Germany says welcome. Please speak in the microphone. Say hello. Hello. Very nice. Okay, a warm applause. Please don't pair with your applause because it's just a small presentation. There is a lot of work beneath that, behind that. It's really, really nice for people to get this positive feedback and get applause. Where shall we start? Let's start with Moin Refugees, High Refugees. It's a project from Hamburg, from Jugendhack North. One question I have now. Jugendhack, Youthhack, Hacker. How do you want to be called? Everything would be fine. I would call it Hacker. Okay, that's a big question. We must clear this. Please now a big applause for Hacker. They want to be called just Hacker. Thank you. Now applause for Hacker. Yeah, not undecided. Everybody makes what they want. So Moin Refugees, what is this project? Does it have to do with trains? I was told it has to do with trains. Well, I just start. So we are doing Jugendhack North in Hamburg. And we're presenting now the topic Refugees. And we culminated with the Hamburger project. And it's about an app for an iPhone. And it should make the communication between helpers and refugees. And it should be make the conversation and communication between these two parties easier. And you can sign in as a refugee or as an helper. And now you can sign in as a refugee. Tell the date when you arrive. And then they are saved. And then they send it to the helpers so that the helpers have all the dates. And this should make the conversation easier. Is it about the first contact when they arrive at the city or forever? It's about the first contact. And it's also about the people who are interested in. So there's a section about news and you can look in there. But it's mainly for the first contact between helpers and refugees. And there's also a procession where you can donate money. So how is this technically? Well, so it's, we're four people and we're sitting together. And then we thought about, hey, how should we do this? And then we had the idea. There are controls at the borders. And we thought about, hey, let's track these controls at the borders, at Twitter. And a lot of left political people helped us and get their data. So a lot of borders got destroyed by left political people. So then we built maps. So when we had this data, we built map and we based it on the street map. And now we put a map over it and with a warm body camera. And then you can take a look at where all these borders get controlled and have the exact position. So it's not about where does safe or where does not safe, but it shows the tendency where you might be able to cross the border. Exactly. We analyzed just who we get from the people who came here. There's just a difficulty, a lot of difficulties. So we need to check our dates and that's very difficult. You've talked on the conjunctiv. Are you ready for a project or are you still working on it? So we're still working on this technique. At the moment, we're working to get as many daughters as we need. And yes, we need help. There are a few ideas on GitHub, how we want to do it. And on Jungtakt.de, just look at Jungtakt.de slash project. Yeah, it should be somewhere we will see. We are perfectly organized. And then you can take a look at the source code and find a contact. This is one of the beautiful places about Jungtakt. It's not about making the perfect product, but it's about the way there. And you can also you can also fail as a project. This might sound stupid, but it's also about the process and how you go about the way. And that is also important to learn that some things might fail and that you can start over again. And now we are going to the second project, which is Germany says welcome. Yeah, Germany says welcome is a website for refugees at Jungtakt West. And we started with the idea of how to help the refugees. We need money and now we can do it. So we started Germany says welcome in Berlin and we started at the Congress in Berlin. Yeah, we thought what is the biggest challenge with refugees coming in? We talked with a lot of refugees. The most of them told us they had too much information to deal with or they don't get enough information. So where to give an asylum application? What kind of data do you need to put in the form? How do you deal with the public transportation? Then we had an idea to make an FAQ frequently asked questions. And here we also have a lot of information. So the project is growing and sometimes it's necessary to fall on your face to get to do it better. So we thought of a concept not to just separate in categories, but also in levels. If a refugee arrives and wants to put a nasolam application, he doesn't really need information on how to find an apartment. He doesn't need to know how to give this formula if he needs an apartment. So we have, for instance, sending the formula, the formula is pending and waiting and third thing, integration in the society. So we have a phrase book as well. There is a project, phrase book. We integrated this in our app. It offers words that are frequently used like if you want to ask if there is pork meat in the food, very easy things of the daily life. Where is the next train? Where is the next subway? And also we have a map to show the next foreign office. Where do I find a hotspot? In the keynote, we were asked to give refugees more internet access. And we want to participate in this. So first question, do the audience, do you have questions? Can we have some light? All right, there are no questions. Are there questions on the internet? No, there are also no questions on the internet. I have a question. I should have explained this in advance. If you have a question, please go to the microphones with the numbers. So I can say the number. Okay, there's a question at one number, number two. Hello. I didn't think I could just ask questions in between. What about the challenge that the refugees don't speak German? There is this phrase book. You called it with the English word, phrase book. But the refugees speak very many different languages. How do you deal with this? I'm asking every one of you. In which language do you publish your solutions? In Germany, we use the phrase book, where we have 26 languages. Our phrase book will be translated into 23 or 26 languages. It's not ours, but we use it from another. Applause for the project, Facebook, that we are just binding in our app. It's not our project. And the rest of the app will be translated with the county, North Rhine West Failure, with whom we work together. And they want to implement the app as well. And we also collected all the languages, German, English, Arabic. It's difficult. There are many dialects and languages. When refugees come to Germany, we want to offer for as many people as possible, to offer the translations. But we are still in the process of assessing how many languages. How do you do it with more refugees? The app is right now in English because that's the most common language. Many things work about pictures so that they don't need any language. But we would be happy if people would consider helping us and translating in languages that we don't speak. If somebody feels interested and wants to help us, it would be really great to come to us and signal your readiness to help.   Of course, everything is self-explaining. But the instructions, maybe the language is not the biggest problem, I think. Of course. Yeah, there could be some explanations, some text accompanying a map in various languages. It's a work in progress.  Microphone number four. Hello. My question is, everything works with the app. How far do the refugees have mobile phones? How do you know that this app is being used? How popular is it among refugees? Is there an audience of refugees who can use the apps? So what about the information? How do the refugees get the information before they arrive at the city? Yeah, true. This is a problem. You can hack North. We had two refugees who were there and did something. We talked with them and they got the information for other information. So we have the information that refugees do have mobile phones. Our project is only for iOS. We're trying to port it on Android to reach as many people as possible. But it's an issue. This is the next step. But apart from this, there is the possibility to register more people so you can share a mobile phone. As soon as the app is in the app store, right now we're still testing it. But as soon as the app is in the app store, we're going to try to reach as many people as possible so that the refugees know that there is the app and that they can use it.  I think it's more complicated because the information needs to arrive as the refugees before they even arrive here. The mobile solution itself is used on E-flat. It's a JavaScript-based solution for OpenStreetMap. And as far as I know, it's portable on various operating systems. And of course, there is going to be a website. There is going to be a web solution. So we have a large possibility of implementations. We need to finish with the questions for this section because we only have 20 minutes. We develop at the moment only for Android and for web browsers so we can reach many people. But our projects are quite similar. Maybe we could just work together and make an iOS version together. And maybe to the first question, we have something like a survey. 80% of the refugees who come here have a mobile phone, smartphone. So to make sure that the app reaches the target, then we've been thinking about many things. But we are the app is going to be distributed on refugees who put location. When refugees set an application, they are being given the app from the authorities. So we have reached the end of the first section of refugees welcome. Many thanks to the project Fagborders, Germany's Ask Welcome and Moin, the refugees. Please leave the table and we are going to the next section, which is society. Everything on the stage is very short, very compact. If you want to talk to the people, they are still here. There is a youth tech assembly next to the center center on the first floor. And you can also go to youthtech.de. There is a section about the projects on the website as well where you can look them up. So please sit down, close the microphones and here's your applause. We have Marco from Easybay and Rene from Gute Laune Fenster, Happy Mood Window. And Lilo. And Marble from Anti-Cheat. And Hans-Peter from another project. We said it was my favorite project. Anti-Cheat is something to try to prevent cheating in gaming. We started because we had a group of people and one of them used to program cheats and I found it very interesting and he said he wanted to use to go on the other side of the of the force and we thought, hope, can you find out if cheats are being used? What we found is that most cheats in the game are used through the mouse, the computer mouse. So we found before the computer does anything then we made a mouse sniffer that just grabs the data before they're processed by the computer and then they're going to be verified on the server. And so we're going to recognize that some people are using a cheat on their computer or not. I haven't asked a question. So somehow you have to have the cheater install the program on their computer? It's not what something is going to install on their computer at home. The idea was also talked about. It's something that happens of events, e-sport events where you really have big prizes to win and if the organizers say we want to guarantee that there is no cheating and so you can attach it to the hardware and use it there. Sounds very interesting. Easybay. There should be something like ebay or let's say internet auction platform. What is it about? First, I was by Jugendhekt East in Dresden and there I was in the theme future city. How can you improve your city in the future?   So we thought about this project ebay ads. We could place it in a big hall where people bring things and other people pick up things like a free shop and we implemented this over a website where people could just register for their objects and other people could just pick them up. And with QR codes we implemented lagging and we use a Raspberry Pi. So I could just put things in this hall and I never have to see them again. Exactly. Is this theoretically or have you tried it? Right now it's only theoretical because the resources are not there. We need still need a storage. So if everyone has a hall in Dresden please call us. They're searching for one. Selenio you have done something with trees and Wi-Fi. So why? Well we had the problem that everybody knows that. If you're somewhere and you want to check your mails or not at home if you want to do some homework, anything that kind of things. But you've already used your flat rate. You don't have any data volume. So we thought there are just two little hot spots, free hot spots that you can use in the city. And because nobody wants to give electricity for all the routers for free we thought maybe we could just mount them on trees and then put a bike next to it and then with a dynamo to create electricity just to operate the router. And to make sure the tree doesn't fall down, which would be quite a problem, then we thought there would be a pump that would water the tree at the same time with a sensor that would measure the state of the tree. And if the tree has enough water and if somebody is using the bike fast enough the router would get some electricity. I see it in the news. Climate change stopped by young hackers. Have you tried it? We have made a little model but of course we cannot just not take a villain router and a bike and make it in real. But we have a proof of concept. We made a model. Do you want to try it? Yes. But we need, we are missing resource. It's in Berlin. So, Berlin, if you have a tree, a bicycle and everything else that it's needed here, people who are searching for it. You tried some of the basic problems and want to solve them. I was also in the discussion area of Zukunftstadt, city of the future. So we thought about what is important for the city of the future. We decided information is going to be important. So it's about public transport and how you get information. You can get them from the Deutsche Bahn. And we were looking for a platform to make the information nice to look at. So we thought about the Guttlaune Fenster which should also present this kind of information. And we want to avoid a negative mood so you don't get late to work and we want to enforce a good mood by cat pictures. So where should this sort of window be? Inside the city, at the wall, where is it? We think it should be at home for example in your bathroom. So you have, don't have a mirror but there is a mirror with a display behind it. So you can look through the mirror at the content behind the mirror. There is a project called Magic Mirror which is already done by someone else. So the information is going to be presented through this window. So to build it, you need 30 magic mirrors. I'm sorry, can you please repeat the question? So we only need one. Let's, depends where you want to have it. No, we haven't done it and other team has done it and we are working on the software for it. One moment for question. We have one last project and that's the event card. So for big events like Jugendhekt or this Congress, there are people coming from many regions to one point in place and at a certain size the ways people are using are doubling. So two people who are coming to the Congress might be in the same train sitting right next to each other but don't know about each other and then you said next to the other person for hours and aboard and we thought it would be nice to know in advance with whom you are going to the Congress together. So we've programmed a map where you can enter the route you are taking to the event so you can look at the routes others are taking and contact them and build groups to go to events together. So one more question and then you can ask question. Does it exist in real? We have a library. You can download it on github or you can look at it at github. So every person organizing an event can implement it on their home page. It's not one central server but the organizers have to implement it themselves on their own home page and also... So why we don't have it for this Congress? This is not our fault. So these are the six, five projects. Are there any questions so far? Oh, people are going. The internet has questions. What happened to anti-cheat? Did it get tested? Is it already being used? We tried it on the hackathon. People said there was no negative affection from the using of the mouse but we've never tried it on big events but we haven't met so far. But the software is there and everything you need is an Alenino and a Raspberry Pi and you just have to put it together and but after this we've never tried it and we stopped the project. Why haven't you tried it? Was there no interest? Or was it more like you meet once at the JungTact event and afterwards you have other things to do? So we didn't have the time and you need to travel to see each other. The interest is there but we have other priorities. There are other priorities? Yes, sorry. So you work together on a project for a weekend and what happens then? What do you take with you? What do you join the JungTact event again? You work on a project for two days and put a lot of energy into it but then the project doesn't happen because there is a lack of time after the event so what do you take out of it? We have an improved concept and at the next event we can continue with the hacking and with the project. So you learn a lot. But about the event map, what is your current status? So we have a few problems. It's not easy to afford a card to find the right city and we have a few ideas how to do it but there was no time left. So we are still working actually and we're talking to each other and think about how to do it but this will cost time. How do you organize it? Do you do it online or do you meet up for many hackatots? Yeah, yeah, well we're meeting each other. But about 3-5 do you still follow up on this project? Well, we know each other before. At the moment we have finished with the model. We just need the resources now. So yeah, if we had the resources, we need the resources. Do you do other things instead or does it just lie around and you wait to get the material? Yeah, of course we're doing things in our free time but not to this project. What do you do in your free time? Do you chill out or do you work on other projects? So the background of the question is the Jungtech event that you want to work on other projects in this area or do you don't? So not in this project but there is another project where we're still working on. Which one is it? Scan is easy. Can you please tell us about it? So there's an app which scans in barcode and then it makes a short version of the text. Can you use this app? Is this app live? Can you download it? Yes, there is a website but we don't have a lot of projects. Is it going to be a community project? So we're still working on the translation and we have to get all projects into the database. But it's very easy to enter. I'm very looking forward to see this. What about Easybay or other project? Are you waiting for a storage area or do you work on other projects? I try to rephrase it. Are you still working on Easybay? At the moment not. Do you work on other projects which are about hacking or programming? Yes but this group is so split into different parts that we have problems to meet up. Do you fall apart completely? Or are you still in contact with other people and if you have a question you contact them? Yes but online. Really? You contact them online? Oh my god. What about the Gute Laune Fenster? Yes this is uh well we're working on a front end for a modern futuristic house. So we're thinking about functions to imply them and yeah we're definitely working on it. All right. Last question. Last opportunity for questions. Internet? No. Stop. Stop. What's up? Oh there's a question up there. I didn't see the microphones up there. Number five. Sorry I just want to tell that there's a living place at the Havie Hamburg where they have some sort of mirrors which they where they have some sort of mirrors. So I can get you the contact. Where do you sit? Row 23. René you go to the row 23 and contacts. Thank you very much on this participant. Thanks. Thank you on the young people from Jugendakt. Okay. That was Jugendakt. Let's start with Jan Roland. You worked on a privacy patch project. You all know about the laptop. Where is my camera sticker? So some people do it for the smartphone. Just to clear us all. So yes we have seen that a lot of people put stickers on the camera on their laptop. So why do people don't do it on their mobile phone? It's a bit more complicated because it's not practical. You use the camera in the front more often. So we are working on a thing to put around your mobile phone which is before your camera as well. And there are LEDs inside which are shown on the camera so that the camera can't see. So Nina from AutoPGP. How to PGP? It's one of the biggest problems of people. There are some tools to increase but people don't use it. I mean nobody uses it. The people in this room do use it but normal people don't. How do you want to explain this? I have a project from Jugendakt South at the topic to find them to get a crypto messenger. And to spread it around. We haven't worked on the crypto because we would destroy it. So we try to explain the idea behind crypto. There are a lot of tutorials inside the internet. And we have a new concept. So we just ask questions like what sort of So what operating system are you using? What sort of things you are using in general? So how do you use crypto? I just want to know that I'm only here for using it or do you want to have background information and then we build text blocks and get your individual explanation. There is that. Yes the website is online. Jugendakt.de slash project in German with K. You can find the project online. There are a few parts missing. There are a lot of it's available in English and German. And if someone want to help us feel free to join. So that's what I wanted to ask. You don't want to do this yourself. You are accepting people to help you. Of course if someone want to help. So feel free to help. Now we have people who want to do encryption to work on encryption themselves. Lukas for instance. Yes we have looked at Rikoshi which has a protocol for to anonymize. So that you can use a crypto between two people that they get anonymous and no one will know something about them. And there is a reference application which implies GUI and the protocol. So we had a few problems. One there is a So our first problem was that GUI and the project was about the front end. So because these parts haven't been apart we couldn't build the front end. And if we hear people who are programmed already you might notice. So we had the idea to build a library. So we started in Haskell. And next to it we want to have a modular so that we can try new things in the protocol. Okay well yeah just write encryption library just like just like that. Max tries to measure big people amount of events. How do you do this? With magic. So we want to rebuild creepy dough but people told us no no this wouldn't work. We don't want to spy on people but we want to locate them. So we tried it with Wi-Fi. First thing was it was about the technique behind it. So what was what is possible? So we built up an infrastructure and a back end and then we tried it technically. Of course it wasn't finished. It isn't finished. But after two Jungtag days it's working now. And now we have results we can work on. That's quite interesting. Now last project for today is the Neuland Eufony from Jeremy and Jacob. What do you do there? Neuland Eufony is the most tense on surveillance. The project is implemented with proxy in Python. So when you go to a website in a way that you are not able to access a home page it is supposed to build an awareness about for people in the so-called first world to have a feeling how censored internet looks like. This is our project. All right now that's the point where I'm going to ask the audience if anybody has a question. Just stand in front of the microphone or write it from the internet. Internet has a question. A question about the privacy patch. Which power source do you use your smartphone for the LED? We have used OTG so the mobile phone has to support it. And from this part we get the energy. It's when I think about it you have something hanging on your nd like a periphery isn't it too thick? Is it practical? This was a prototype which was quite big and we wanted to build a smaller Are you working on it currently? Currently we are not working on it. All right I'd like to ask the Querschläger project. Does anybody from you know? Does anybody from you knew before arriving about Ricochet? Just a couple. Who knows Haskell programming language? Not that many people. Lukas, how did you think about implementing an encryption library yourself? Because if anybody would do this here on the congress everyone around them would say I'm programming an encryption library. Everybody would say don't do this. This is just too dangerous. We have programmed a protocol. Now we have implemented a protocol which uses cryptography which is already there which already can be used. So it can use everything which is around from projects already there from crypto which is already there. So Ricochet is also not something where we would say you can already use it. It's already good but it's rather alpha and it has to be proved in practice and it has to be seen whether it is the right approach. But it sounds like we're not touching the encryption core itself so we can't break anything. Yeah of course we can break something. Our protocol can be hacked and hidden services might also encounter problems. Has anybody else have a look at it? Did you have somebody just double check your code apart from yourself? Yeah in singular cases but not in a big style and our code is not ready yet so we don't have the complete protocol implemented. So if anybody wants to do some code review in Haskell just feel free. New question? Hello I have a question on Max. I didn't understand the project at all. Surveillance. What are you doing exactly? You look at the MAC address. What are you doing exactly in your project? No mobile files always want Wi-Fi and the mobile phone always wants to have Wi-Fi because mobile data is very slow so it is always looking is there a Wi-Fi network and we want to catch those Wi-Fi requests and we get the packages and give them an identifier, a hash value. So these three packages might come from the same source and then we can say depending on the strength of the signal we're just coming from. So if here and there and there is something with an antenna so we can see how many people are in which part of the audience room and at a conference you can see where a lot of people are standing where there might be a queue because people don't get through a door as I'm saying. Bingo. So we solve all the problems of humanism. Very nice. Newland Euphony project. Do you have about this proxy server? Did you try it on somebody who didn't know what was happening? No we haven't tried it yet with people who didn't know what is happening. It's very obvious. The changes are highlighted and there are cat pictures on the website so you should notice. Everyone is very welcome to try. It's on GitHub. It's running. You can use it. It's very slow. If you have any ideas how to make it faster we are looking for improvements. Thank you very much. One last question about PGP how to project. Do you try on people who had no idea and did they really manage to go through the process? No we haven't tried it yet. But a project came from the idea when I tried to explain it to my mother how to use PGP and my mother did use it and it did work because I did it for her but she wanted to know how to understand and she encountered the project as a problem that she could communicate with me but not with anyone else and then my mom asked me to explain it to her friends and this was a lot of work for me so I had the idea to make an easy to understand guide just how to project how to explain it to your mother or how to explain it to different kinds of people. So please try this PGP how to protocol just try to use it and assess it. So thank you very much to all the participants from Jugendhaft. This is your applause. Thanks and all participants. You can go now. There is somebody else coming but it's not over. It's not over. I have one more intervention. You can talk to the project from the Open Knowledge Foundation Germany and Daniel Fader is asked to come on stage and tell us a few words. Thank you. So applause also goes to my wonderful colleagues which are standing over there. I can give you a quick look at what is coming up. We have then different events at different places and we are always thinking about how to develop the program and the future together with the youth, with the people participating and also with the mentors. Next year we want to have also for regional events and one main event in Berlin. It's not a lot actually so there are a lot more people who want to join but can't and we have also heard in this project presentations how to it's a problem that sometimes you start a project or very often you start a project and how do you develop it? How can it become better? And we are looking for ideas on how to get more events for young people and how to have how you can open for example hack spaces for youth as well and what kind of events you can offer to young people to be more attractive for them. We will have again five events. We want to have more international projects and not only a German language approach but also work with other partners to have similar youth hacking events with about code and ethics with international partners. We want to have an entry level program. At the moment we are looking for young people who are already into code who already have some experience so young people coming to us have some experience at some level. We don't test it but now we want we are also already thinking about how we can approach a more entry level program to also talk about children how they can learn programming how very young people can get a concept about programming with all the ethical questions coming with it. And if you have any ideas and want to help develop these ideas with us we are very open for you to approach us. And we also want to talk be attractive for girls. Currently we have 20 percent of girls attending which is not bad for this kind of events but it's not nearly representing the society so we want to have 50 percent of girls attending our events. And next year we want to talk to more actors which are involved in the area of girls and tech and implement their experience and we have already implemented the scientific ideas which are around but we are still we still want to focus on this. I have to finish now thank you very much for the program for this great space and it's great to be on this main stage and be in contact with so many people and I have to talk to who has a conference area where we can implement TRIFA maybe so it's great to get in contact with all of these people and with you and at two o'clock tomorrow there will be a meet up at the you can take the assembly. Now very shortly there is there is real things you can do if a teenager has a project there needs they need people to organize it with them and this congress is full of hackers and these teenagers from Jugendhack really need people to give them a hand especially in Berlin but if you know people or elsewhere if you know people if you know people who can program who can give assistance please just give them a hand and support them as far as you can thank you very much


Hello, this is Laptop Media, and today, we will show you how to open the Dell XPS 139305 and what's inside of it. To open this laptop, you need to undo all 8 Torx head screws. Then, pry the bottom panel starting from the front corners. After that, lift the panel from the chassis. Please remember, it would be of great help to us if you just hit the like button and subscribe to our channel. That would motivate us to make even more and better videos for you. Inside, you will find a 52 watt hours battery pack. It got us through more than 13 hours of either web browsing or video playback. Before you continue, unplug the battery connector. To remove the unit from the device, you need to undo a total of 5 Phillips head screws. Unfortunately, the memory here is soldered to the motherboard. On the bright side, you can pick between 8 or 16 GB either of which works in quad channel mode. Storage-wise, there is 1 m.2 PCIe slot, hidden beneath a metal shroud. As for the cooling, Dell relies on the same solution with two heat pipes and two fans, which we saw a couple of years ago. If you'd like to see more disassembly videos of the latest notebooks we would highly appreciate if you hit the like button and subscribe to the channel.


Dynamic reconstruction of metal sulfides during electrocatalytic oxygen evolution reaction is a key aspect of study. Herein, modeling on a series of cobalt nickel bimetallic sulfides, the authors reveal a dynamic phase evaluation pathway and the SO substitution process occurring on the catalytic surface at the pre-catalytic stage. This article was authored by Yang Hu, Yao Jing, Jing Jing, and others.


Welcome to Restaurants Hawai'i on Think Tech Hawai'i. I am your host, Cheryl Matsuoka, the Executive Director of Hawai'i Restaurant Association. And today I have two special guests. I'd like to introduce the ladies. Ladies, I'm gonna introduce you. And if you could tell us a little bit about yourself. The first lady is Sherry Ewan. Sherry, you wanna introduce yourself? Hey, yes. Good afternoon. I'm Sherry Ewan. I'm newly on board with Waihata. I am the Broadline Sales Manager. So that means that we service and handle all these street accounts or our broadline accounts. But of course, as many of you know, we handle all types of customers. And I'm excited to be on the show today to share a bit about what we've been going through and also what we've accomplished as far as a company that's been in business about 108 years. So that's about it. I'm excited to be here today. Thank you so much. And I'd like to also introduce Christina. Hi, Christina. Hi. Hello. My name is Christina Lee and the Director of the Hata Cares Program at Waihata. And I'm also really excited to be here and to share more about our company and all the great things that we're doing. So thank you. Thank you, ladies. Hawaii Restaurant Association's Hall of Fame is quickly approaching Monday, February 28th. And we are grateful for Waihata, who is our this year's Hall of Fame Presenting Sponsor. So this year, HRA and Waihata will be paying tribute to our pandemic champions and industry advocates. And these honorees have demonstrated exemplary dedication during the pandemic in various capacities. So I did my homework, ladies. And I found out that in 2009, 13 years ago, Waihata received the honor of being inducted into the HRA's Hall of Fame. So it's just so fitting that this year in 2022 that Waihata is the Presenting Sponsor paying tribute to our pandemic champions and to our industry associates. So maybe Sherry, you could help me. Why is the Hall of Fame important? So the Hall of Fame, as you know, recognizes industry leaders. So why was it important and meaningful to Waihata when they received their induction into the Hall of Fame? What did it mean to Waihata? So what it meant to Waihata, first of all, just knowing that we're coming out of this pandemic and trying to get back to some kind of normalcy, it's exciting to reenter our industry and our operations and whatnot with a big bang. So for us to sponsor this year is super exciting for us. In 2009, it was such an honor to be an inductee and to have shared that accomplishment along with a lot of successful restaurateurs here in Hawaii. We feel that we play such a vital role in feeding Hawaii as part of Hawaii's food chain and we service our Department of Education, so our KKoka'ina or our children in Hawaii and also all branches of military and we're a locally owned and operated business. So that is such a highlight and such a great accomplishment for us and we're proud to mention that. We really love to get into our communities and help families in Hawaii, starting with our Ohana or our staff here at Waihata and taking it outside into our general public. So we know that we're part of Hawaii's food chain and it's gratifying to be recognized for our efforts in all of our hard work. You just touched on something. I was gonna ask Christina. Christina, share with me a little bit about what is Hata Cares? Well, thank you so much for asking that. Hata Cares is about doing good every day. During the pandemic, our Hata Cares team was first on the scene to help prepare meals and take them out to first responders to participate in food distribution, to all of those in need and to donate food to various nonprofit companies to help support Hawaii's food chain and food industry. And now along with all of that good work, the Hata Cares team is also looking at ways to develop ways to improve from within. So our Hata Cares program is our dedication and focus to enhancing Hawaii's food industry starting with our employees, our Ohana. And we feel that great service starts with happy employees. So we've made it one of our key focuses to focus on culture and process improvement and enhance our employee experience. So this in turn is that ripple effect of creating happier employees which makes greater productivity and provides excellent levels of service and the community as a whole wins. So we're extremely proud to say that we're kind of in the business, our Hata Cares team is in the business of spreading joy and happiness while making things more efficient. I love that. Oh my goodness. And no wonder that, you know, why Hata has been in business since 1903, 108 years ladies, that's incredible. And that they can still support the industry or food service industry by being this year's Hall of Fame presenter.  So what is epitome? What does it mean? And I looked it up in the English dictionary and it says that a person, a thing or a business that is emphasizing and being the best possible example of it. And that's exactly why Hata. So at the Hall of Fame, it is all about the awards and I'll go through the list of all of the inductees that are this year. But it's also about the food and it's our 14th annual Hall of Fame. So we have 14 chefs of Aloha. So I was going to ask Sherry, if you could please or Christina, it doesn't matter, please share with the viewers a little bit about chef Chris and his dishes because as I mentioned earlier, I can't pronounce it, but it sounds so yummy. I can take this one. So I have a little script to read though, because it's a long description of one dish. So that evening, we will be preparing and serving creation of Chef Chris Blanc. It's a shichimi-crusted kuwa aina, ranch, flat iron steak with pickled honshi-meji mushrooms, Mari's garden greens in a sesame vinaigrette with crispy shallots and a yuzu ponzu brown butter. Ooh, that's a long description, but it sounds really good. So the inspiration behind Chef Chris's dish, of course, being locally sourced and using sustainable products. We are sourcing our beef for that evening from kuwa aina ranch on the west side of the Garden Isle of Kaua'i. And under the ownership of Jehe Fuller, and of course our beautiful greens from Mari's gardens found locally right here in Mililani under the owner Fred Lau. And we're a big supporter of Hawaii Agricultural Foundation, HAF, which is a nonprofit organization. And they were created to kind of promote and support Hawaii's farmers and agriculture. And their mission is to support and sustain all our products that we grow here in Hawaii, which I know a lot of local farmers and local chefs have really got behind this to promote from within and promote from our islands and sourcing products from our islands. And needless to say that the flavors incorporated into this dish is probably Chef Chris Blanc's favorite flavors. And of course, all our products you can find here at our local chef's zone. I love chef's zone. You have to know when my husband goes there, it's the boiled peanuts. There's like four bags of boiled peanuts. And it's just me and my husband. Four bags of boiled peanuts automatically every time we go to chef's zone. And so thank you for that. And that's the reason why, why Hata supports the community. And that's the reason why they have been inducted into the Hall of Fame because of all the support, the community support here in the Hawaiian islands that why Hata does. And our nominations for the inductees are submitted by our food industry peers. So ladies, I'm hoping next year that you all will also nominate people from our industry. The nominator must submit a detailed statement on why they are nominating that person or business into the Hawaii Restaurant Association Hall of Fame. And then the selection committee, they have to go through the rigorous process of reading all of the ballots and then selecting. So this year we have 10 and I'd like to read off the name. So it is Denise Hayashi Yamaguchi, my dear friend. Victor Lim, who is amazing. I call him the Energizer Bunny. Greg Maples, who is my knight and shining armor on a white horse. Mark and Amanda Lagucci, who's done so much for our community. Ryan Tanaka, who is just brilliant. Gwen Yamamoto-Lau, who has a heart so big. Sherri Manor McNamara, who is my dear, dear friend and representative Sylvia Luke, who if it wasn't for her we wouldn't have had the Hawaii Restaurant card. So those are the this year's 10 inductees and we're excited and it's an honor to induct them into our Hall of Fame. There's so many other achievements that they've done. I just kind of touched on a few and there are so many other people that are still out there because we are still coming out the end of our endemic. There's still so many people out there that are still helping our food service industry. So to our members and our viewers who are watching, please next year, nominate the person or the business who has really helped our industry because that's what we really need. So this year, our Hall of Fame is on Monday, the 28th. And if anybody's interested in getting tickets, all they have to do is go to our website HawaiiRestaurant.org and tickets are still available. So ladies, I don't want to close yet. There was still lots to talk about but I just wanted to ask you if there's anything Sherri that you wanted to discuss that I haven't touched on? I think what I did forget is just a little background on our chef, we have to thank him because he's gonna, he's gonna be showcased that evening along with his dish. So he was originally born and raised actually in Phoenix, Arizona. And he's cooked professionally over 23 plus years all over nationwide in different states. He's, I'm sure he's planned many of menus and designed a lot of kitchens. He's worked for a lot of James Beard award-winning chefs and celebrity chefs. And he actually was with the BLT concept. So he helped to open a few of their stores including Trump Tower as an executive chef, sous chef, I'm sorry. And then he moved to Hawaii and married a local girl. But he moved to Hawaii to open up the beach house in Haleiva and also worked a few years at Michelle's at the Colony Surf in Waikiki, which is a nostalgic spot for many of the residents and what we know. And so we're super proud of him. And I am sure that we will all enjoy his dish that evening. So we're excited for him. And the secret is he married a local girl. So that means he married a local girl. But he's not going anywhere, lady. The local girl's going to be, right? Christina, is there anything else because we can still chat about the Hall of Fame or we can chat about Waihata. Is there anything that I missed? Oh, you know, I just want to share that, you know, as we all know, the pandemic has created such a challenging landscape for the food service industry. And so we're just really grateful to be able to give back after we've kind of weathered that storm. And so, you know, being part of this sponsorship and being part of such an amazing event is really exciting for us because we feel that, you know, as a locally owned business, it's important for us to give back to that industry that has allowed us to be part of the community. So for so many years, we're so grateful. And we know that a lot of the restaurants and our dear friends have suffered through that pandemic. So it's our hope that this event provides a little bit of light and hope and excitement for what's on the horizon as we all get through this together. That's very nice. And one of the other topics that I wanted you to share was a little bit about Waihata's philosophy because I know it comes from the top. I know it comes from Russell. And so he's done so much for the community and he's done so much, you know, to keep this business going for all these years. It's like, it's so impressive. Do you want to share a little bit about some of Russell's philosophy and the core values of Waihata? Yeah, I wish, I don't know if you guys can see our core values behind us, but they're partners first, continuous improvement, Ohana empowerment, Ohana pride, candid communication, live aloha and give aloha. And, you know, some of the ways that we show that or bring that to life, during 2020 and 2021, Waihata donated about half a million pounds of food to various charities. We also partnered with HRA and the Hawaii Food Bank as well as the City and County of Honolulu and the Great Aloha Run to distribute over 3,000 turkeys to unemployed food service industry workers. We also worked with chefs to put together curated chef boxes so that the community could have access to these deluxe meals during the shutdown when they couldn't go out to eat. And we prepared meals again for first responders to thank them for all of their dedication and hard work to the community. And we also started Ohana meals within our own company. We know that we have a lot of frontline workers that could not stay at home and needed to come to work to continue with that food chain, keep that food chain going so we want to make sure that we took care of them as well. So it's really important for us to take care of our Ohana, our employees, as well as our community. So that's a huge part of our philosophy. That's so awesome, you're right. We were there doing the food box distribution on a Sunday out there at your location. And to see all these cars come through and people so grateful, so grateful for free food boxes. It was awesome. So ladies, I'm going to read the rest of the chefs that are gonna be providing food at the Night of Hall of Fame, but I'm gonna read it and then we have the list here because I don't wanna miss anybody. And later on, oh my goodness, I missed someone. So yes, you're right. Number one is Waihata with Chef Chris. We also have pounders who is Chef Graham Elliott. We have Chai himself who will be presenting his dish. We also have the Sheraton Chef Matt, Matt Benet, Chef Bon Chow Bao Tran, Dukes and Hula Grill, Chef Drew Crocker, Cahill Avenue Food Hall, Chef Mario Lopez, Kapahale, Chef and Owner Kea Kali, 53 by the Sea, Chef Kavika and Short Fire. And we also have some desserts. El Gelato will be making their gelato. We have Hawaiian pie and we also have the Sheraton making some yummy lavender panna cotta. So I don't know if I said outback in there because I now see outback is staring at me. So we do have, like I said, it's our 14th year, we have 14 chefs and it's gonna be a great event. Part of the fun of the event that night is that we will be having some auction items. We'll be having, of course, the whole diner round. We have a lot of beverages that will be there. So we're looking forward to another night to just celebrate ladies just to get together. It's been so long, right? That we've gotten together and it's been so long that we've gathered. So we're looking forward to a great event. Let's see, what did I miss, ladies? I'm gonna go back now to Sherry. I see here, I think I've asked all of the topics that we were talking about. Did I miss anything else? Oh, the locations. I wanted you to cover the locations where Waihata covers on all the neighbor islands. Okay, great. We are actually on the island of Kaua'i and also the big island. The original Waihata brand started out of little Hilo, Hawaii. So we're super excited how our company has grown. We have also some presents through a third party on the island of Maui as well. But we're looking forward to expansion in the upcoming years as our Ohana here at Waihata is growing. Russell really believes also in work opportunity and job opportunities for our locals, supporting even our college students for future, future leaders in Hawaii. So supporting our schools and our culinary program at KCC. So he's a strong advocate of growing Hawaii's people and giving back to the people and where I'm very honored to be a part of a company that really and truly believes in that because my employment or career is much more than that. There's a purpose behind it. And that's what I'm excited about. So we provide tools for KCC culinary students as well. So, yeah. And statewide, statewide DOE, statewide military, chain restaurants as well. So, yeah, a lot of work for us. I was up at the Culinary Institute of the Pacific. Beautiful, and Russell's support up there is just amazing. I also was gonna ask Sherry to mention about charity days. As you know, the Hawaii Restaurant Association has our Hawaii Restaurant Association's Educational Foundation. It's a markable. So we call it the HRA Educational Foundation.  Do you wanna cover a little bit about that, ladies? One of you? Maybe quickly. Being a supporter of it, you know, in addition to that also, I forgot to mention, this is a super exciting time for us as well. But we also were a part of judging along with Loon Farms, I believe it was, to the high school culinary championship and program. So again, really being supportive behind Hawaii's education.  So it's quite an exciting accomplishment when we can establish and get behind these programs or be advocates for these programs where the kids can stay home and learn and develop in their career path. So super exciting time for us. And to support that, it's again, such a greater purpose than just food service. Exactly, and what you're supporting also with our HRA Educational Foundation is on our board is Chris Lee, and he's been a huge supporter. We have 10 local high schools that have culinary programs, and these culinary programs are for juniors and seniors. And ladies, you know, that's our future chefs. That's our future general managers in our restaurants. So we really, really appreciate all of the support. The Educational Foundation has, like I said, 10, and one on Maui and one in Kohala. And we're looking to grow because we need those future restaurant employees in our restaurants and in our hotels and anything in our food service industry. So ladies, he's giving me the five minute warning. Is there anything that I missed that we have not discussed? Cheryl, I just wanted to say huge congratulations to all of the inductees and to you as well. So, you know, thank you to you and your team at the Hawaii Restaurant Association. You guys have been a leader and a voice for the restaurants of Hawaii, especially during this challenging time. So really a big shout out to you and all of the inductees that have, you know, brought the industry through these tough times. And we have a great executive committee and a great board. You got to know it takes a village, right? Well, this it takes like an army to get through a pandemic. So again, everyone, Cheryl Matsuoka, the executive director for Hawaii Restaurant Association, our annual 14th annual Hall of Fame is Monday, the 28th at the Sheraton. For ticket information, go to our website, which is hawaiirestaurant.org and we're paying tribute this year to our pandemic champions and our industry advocates. And again, Hawaii Restaurant Association is the voice of Hawaii's restaurants and food service industry. Thank you and we'll see everyone on Monday night.


Hello everyone. My name is Miriam from the Wikimedia Research Team and together with Caroline Marek today I will be telling you about our project called the Knowledge Gap Index and how you can make your own. Before I delve into this project I'd like to start with a principle that most of us know very well as this is one of the foundation or principle of our movement strategy. Knowledge equity is that principle that is encouraging us to include into Wikimedia projects those knowledge and communities that have been left out by structures of power and privilege and include and break down the social political and technical barriers preventing people from accessing free knowledge. And so while knowledge equity is our end goal, there exist inequalities in Wikimedia projects that prevent us from advancing knowledge equity. Those inequalities are what we call knowledge gaps and our goal with the Knowledge Gap Index is to be able to identify measure and visualize those inequalities and making sure that everyone can see the extent to which knowledge gaps are present in Wikimedia projects. Knowledge Gap Index is a multi-year research project. Our journey started a few years ago where we started research on identifying systematic definition of knowledge gaps. We are continuing this journey by measuring this gap and mapping gaps into metrics that everyone can look at to see the extent of knowledge gaps. And finally, we are looking at ways to visualize gap and surface this measurement into a very easy to understand format. Let me take you through this research journey. We started in 2020 by releasing the taxonomy of knowledge gaps that is a structured list of all possible inequalities that we can find in Wikimedia projects. This is the result of a few years of research looking at many references, sources, surveys in community initiatives in looking for evidence of inequalities in Wikimedia projects. And so the result is this structured list of knowledge gaps across content readers and contributors. And just to zoom in into the taxonomy, the inequalities that we can find in Wikimedia projects can be very different. The gender gap is one of the selling most famous inequalities, but we have more potential inequalities, geographic inequalities, multimedia, age, structured data, and so on. And so once we had a systematic definition of what inequalities we can find in Wikimedia, the next step was to quantify those knowledge gaps. And so the idea here is that this is still an ongoing process is to map each of the gaps in our taxonomy into metric, into a few numbers that can tell us the extent or the presence of these knowledge gaps in Wikimedia projects. And by doing this process by generating data around knowledge gaps, we can produce data that can give us some interesting insights about the state of a knowledge gap. Let me give you some examples from the gender gap. One of the measurements, one of the way in which we can measure the gender gap is by computing the number of articles that, or the number of biographies for each gender. So what we see here is that the vast majority of articles are about men, but thanks to the way in which we can, we map the biography data to genders, we can actually see the distribution across all the different gender diverse categories. Another way in which we can measure the gender gap is not only to look at the quantity of articles, but also by looking at the quality of articles from different genders. And so what you see in this plot is the evolution of the average quality of articles about men, women and gender minorities over time. And what we see is that the average article about the average quality of articles about women, especially in the past few years, is getting higher quality than articles about men. And what we also see here is that the average article, average quality of articles for gender minority is increasing at a very fast pace, and it is now much, much higher than articles about men or women. And this is really speaking about the efforts, the organized efforts around increasing quality and quantity of articles about gender minorities. Another way in which we can look at the gender gap is by looking at the visibility of articles. And here what we see is over time the average number of page views that an article about a man or a woman or a gender minority person gets over time. What we see here that an average article about a gender minority get way more page views than other genders. And finally, why most of this data that we saw until now was aggregated across all Wikipedia's, thanks to the way in which we compute this data, we can actually compare the same measurements across different language editions of Wikipedia. For example, what you see here is the average quality of articles for different genders for Chinese, English, Malay and Tamil Wikipedia's. And these are the languages that are mostly spoken in Singapore, so that is why we chose them. What you see is that these numbers vary from wiki to wiki, so this can also be an interesting perspective that you want to explore in this data. And this and much more data you can find in a recent data set release that we put out a few months ago. So these knowledge gaps metrics data set are now available for you to look.  So they contain metrics for five knowledge gaps, gender as we just saw, but also geography, sexual orientation, time and multimedia. And for each of these gaps, you will find data about the overall article quality quantity by different genders, for example, the quality of articles, page views and revisions. This data is available at the link below and we will also make sure that the link is included into a meta page that will be attached to the comments page for this video. And so the knowledge gaps data is available now to the public and its format is like a gigantic table. And so for us and for some of us, this might be the ideal format through which we want to explore this data because we just plug it into our way of visualizing data, analyzing, manipulate data through code and other tools. However, in order to make this data more Explorable and browsable by a non-data savvy people, we are working on tools and systems to visualize knowledge gaps in easy ways. One of such tools is being actually deployed as I speak. And again, I will be make sure that all the documentation is included in the meta page attached to this video. And the first way in which we want to make this data more available is through an API. It's an API that allows us to easily query this data, just a portion of the data that we need for our analysis, rather than downloaded a gigantic table. And so this API has a road to URL that is the same for everyone. And then you can specify three different parameters. The first one is the type of gap. So the type of gap that you want to get the data for, for example, gender, geography or sexual orientation. Second parameter is the specific category that you're interested into. For example, in case of the gender gap, this can be female male non-binary, et cetera. And the third parameter is the period, the slice of time of history that you actually need for your analysis. And so instead of maybe getting the data since the beginning of time, you want to specify a specific month or a specific year. And this parameter allows you to specify the beginning and the end of the period that you're interested into. Another way that we have provided you to explore this data is by putting together notebooks that can, it's pre-populated code that allows you to visualize different aspects of knowledge gaps in a relatively intuitive form. And so Caroline has worked on these beautiful notebooks and she's prepared a video for us where she explores with us these notebooks so that you can make them your own. So I'm going to play this now. This notebook provides you with our code for reading, wrangling and visualizing public knowledge gaps data to help you and your colleagues answer questions that you might have about gender gaps in Wikipedia content. So after providing you with some basic setup code as well as code for loading and processing our public gender gaps data, we provide you with code to help answer some questions. To start with, how can I see the current number of articles for males, females and gender minorities across all Wikipedias? Here we provide you with the code to see those numbers and percentages in both table format and pie chart format. But these are the current numbers and percentages. What if I want to see that data across time in this code below? We show you how to wrangle and plot cumulative articles created over time for these three gender categories across all Wikipedia. But what if instead of all Wikipedias, you're interested in one Wikipedia edition? Scroll down and you will find the code to generate a plot that shows the same data as above, except for a Malay Wikipedia, one of the languages spoken in Singapore. Here in the code, we've indicated where you can replace MSWiki, which is Malay Wikipedia, with another Wikipedia edition of your choice. And then you'll be able to generate the plot for that Wikipedia. But what if you're interested in multiple Wikipedia editions? Well, scroll down and we've provided you with the code for generating a plot that compares four different Wikipedia editions. Here we compare Chinese, English, Malay and Tamil Wikipedias, four languages spoken in Singapore. But we've indicated up here in the code where you can replace ENWiki, MSWiki, TAWiki and or ZHWiki with the Wikipedia editions of your choice. I hope you enjoy exploring the rest of this notebook as well as additional notebooks that we'll be providing in the future and the rest of your time at Wikimania. So again, the link to this notebook will be provided and included into my page attached to this video. And I want to thank Caroline for putting together these notebooks again. And this is everything we had for you today. I hope you enjoyed our journey towards knowledge gaps and the knowledge gap index and that you have some tools to make this data and this work your own. We are very much looking forward to hearing your feedback about any of that. And again, the link for feedback will be included into the Macapage attached to this video. Thank you all for listening and enjoy Wikimania.