Kamori, and this is Beyond the Lines on Think Tech Hawaii. I was the head coach of the Punahou Boys Varsity Tennis Team for 22 years, and we were fortunate to win 22 consecutive state championships. This show is based on my books Beyond the Lines and Beyond the Game, and it's about leadership, character, and creating a superior culture of excellence. My special guest today is a Super Bowl champion head coach and was inducted into the NFL Hall of Fame this year. He is the legendary Coach Dick Vermeel, and today we are going Beyond the Super Bowl. Hey Coach V, welcome back to Beyond the Lines. Well, nice to be with you again. It was fun last time and it'll be more fun this time. Coach V, you were the head coach of the Philadelphia Eagles for seven years, head coach of the St. Louis Rams for three years, and head coach of the Kansas City Chiefs for five. I couldn't keep the job. What is it about coaching that you love so much? I love the relationship building. I love the challenge. I love the game. I love the sense of striving to accomplish, striving to be something better than you were last weekend when you got beat, or as good as you were last week when you won. All those things, but the main thing is the kind of people you get to be with in around seven days a week, especially as intense as it is during the season. Coach V, I was so fortunate to meet you and your wife, Carol, a few years ago in Hawaii. Your wife, Carol, has been with you every step of the way. What are some things you admire most about her? Why do you guys make such a great team together? I think number one, her great attributes. She's tolerant of me, my high moods, my low moods, my temper, my passion. She's just a tolerant person, understanding. I think it helped for her to be deeply involved in my job as well. She lived and died on Sunday as well and came to practice once a week and those kinds of things. I think, but really she's just tolerant of a guy she'd been married to 67 years. Patient, she also has great things to, great ability to condense what is really important today and tomorrow and not confuse too many things with it. Well, she, I feel so great to know both of you and Coach V, you were inducted into the NFL Hall of Fame this year. Tell me about that experience. Well, you know, I'm a byproduct of everybody I've been surrounded by. The NFL, the owners I've worked for, Leonard Toast, you know, Georgia Frontier and the people at the Rams, you know, along with Stan Brunke there and then Lamar Hunt, and then the coaching staffs I was involved with, players. I was very fortunate, very fortunate and many times because of the overall quality of the organization, you are a participant in building you as when you end up in the Hall of Fame, you're a byproduct of the attributes of all those people and what the contributions they made to your team because there's so many isolated situations that happen sometimes in regard to football and one play. If that person didn't make that play, I wouldn't be putting on the gold jacket. You know, if John Shire, as I said when I accepted my speech of John Shire, isn't the most valuable player in the upset of Ohio State, the Rose Bowl as a quarterback player, the Philadelphia Eagles wouldn't have called. You know, then they see that in the Rams. Kurt Warner doesn't come out of the blue, become the most valuable player in the league his first year, and Mike Jones doesn't make the tackle the last play of the game, you know, and you take the trend green, coming to the Rams and playing like he did, Tony Gonzalez, those kind of players, Will Shields, these great players and all of a sudden you as a leader, as the head coach, reap the rewards of their contributions. Then it was my job, especially after I left the Eagles, it was in broadcasting for two to make sure I put it all together and molded into the kind of organization that hopefully my leadership could influence and build. So coach V, right there, you said you put it all together. What did you focus on? What were your priorities? How did you build these winning teams? Well, with a lot of help. And also the control of decisions that make a difference in winning and losing. No one over ever told me I couldn't. No one ever told me in three different teams, you can't do that. They were always receptive to new ways, new challenges and new ideas and new processes. And so you get the accumulation of a lot of people making good decisions ends up a great result more often than not. You know, and you can think of a lot of NFL examples that reflect that, you know, starting with Belichick and Andy Reed and those kind of people as of today, you know, the Bill Parcells, the Don Schulitz, the Tom Landrys, people that were able to put all these different attributes into one package that function properly in a positive way. Yeah, no, that's for sure. And coach V, you have both of my books. And I feel so honored and grateful that you like the books. And you know, I talk about that superior culture of excellence. And that's really what you are all about. I mean, you're all about that superior culture of excellence. You're about those superior discipline details. What are some things that that you liked about the books? Well, I think anytime, you know, when you're out of coaching, you're no longer in the challenge of building your own organization. And I like to reflect back and think about what I could have done better. If I knew today what I knew that, you know, if I knew then what I know today. And what you know today is what you learn from reading and different concepts like that. And, you know, I can take one rusty comment and manufacture that into a way that it really adds to my profile as a leader and sort of sound bites with people I talk to in the coaching world and the team you're coaching, you know, you never know when you turn a page in a book, you aren't going to read something that stimulates you. And I first, I enjoy finding things that relate to help me being what I ended up being, you know, and then it says, you know, I did a lot of things right because here it is on paper. I believe these same things, you know, but books like you write isn't about any one thing, it's an accumulation of thoughts you gain that are stimulated by what is said. And then you add to that yourself and your own thinking. And I enjoy that, you know, like different statements people make, you make the book makes, and then you build on that statement and build on that thinking. You know, I'm still reading. I'm reading a book right now about MacArthur, Patton and Marshall. Very, I wish I'd have read it when I was coaching. There's a lot of things in there that parallel being a head coach in the National Football League. So, you know, you just, you never know, I'm at 86 years old, I still have a quest for improving the way I think, you know, and that keeps your mind active, I think it helps. It stimulates, it really is. Yeah, Coach V, the greatest coaches, the greatest leaders, they're always learning, which makes them even greater.  I don't think so. That's when you become stagnant. That's when the people that weren't as good as you a long time ago, I'll end up being better than you are today. Everyone catches up.  They change. Hey, the American culture has changed. I'm sure it has in Hawaii, you know, and the young people think different than the people in the last generation. And then those people thought different than that last generation. So, you got to keep making sure you're on the positive side of the next generation.  But I'll tell you what, I'm still going to read what Rusty says and what other people say. You're too kind, Coach V, and who are some current NFL coaches that you admire? Well, you have to start with Bill and Shack and Andy Reed. You have to start with those two guys. Andy Reed, to be able to do what he's done, takes a lot of years. Because he's coached his own offensive scheme, for example, many, many years now. And every year, I'm sure that things he used to like, he doesn't like anymore, but because he likes it's better. He keeps building a better package. They lose the speed burner wide receiver last year, right? Goes to Miami. Ah, means the home run, right? They're a better offense today than they were last year when he was there. And so that experience, there's no substitute for that wealth of experience and knowledge in the right frame of mind. If you always think you're right when you're wrong, you never get any better. But Andy, I think that, and Bill and Shack, who's been able to coach through the different generation gaps?  That's his philosophy. And he made sure they do. Is he like exact personality of Andy Reed? No, but he is what he is. And no one does it better. And there, you know, there's some young coaches. I'm impressed with Shanahan. Of course, his dad was a great coach. His dad's a Hall of Fame football coach. His dad said, my Shanahan will be in the Hall of Fame. I just, I just feel that strongly. You know, Mike Holmgren, well as well. And there are other people that aren't in the Hall of Fame like, you know, Martin Shottenheim and Dan Reeves, they ought to be at the Hall of Fame. They're not. So I feel fortunate to be there. But I don't know, I've got off a little attractive. Yeah. Anyway, go ahead. No, Coach B, you know, it's hard to achieve success. It's hard to win one championship or one Super Bowl, let alone to sustain success, winning multiple Super Bowls or just having success throughout a long period of time. So it's not easy being a successful head coach. There's assistant coaches that are just great assistant coaches, but sometimes they become a head coach and then they fail. Why is that? Well, first off, normally they're not in an organization that can take advantage of their ability. You get hired in the NFL because the team was losing. Okay, now they hire someone to come in and turn over, take it over and get going and out. It doesn't work. Okay, it doesn't work. And many, first off, the personnel wasn't good enough. That's why they were losing. Okay. And secondly, if they keep losing and say, they just don't know what they don't know. And sometimes they don't start at the ground level deep enough to evaluate why they are in the hole that they're in. You know, but you know, there've been a lot of teams that found that out the hard way, but they eventually did. They eventually found out. I could think of the old New Orleans Saints. They couldn't beat any of that coach after coach. And they hired Jim Moore. What happened? Eventually they started winning, didn't they? And those kind of guys are out there, but there aren't a lot of them. And there aren't a lot of coaches that are given the opportunity to really take total control of what makes a difference in winning and losing. Yeah. Coach V, you've told me before that you love all of the players that you coached. And I want to ask you about that 1999 season when you were coaching the St. Louis Rams, and you guys won the Super Bowl. Why was Kurt Warner? I mean, Kurt Warner's story is incredible, but why was he able to rise to the occasion when Trent Green got hurt? And how did the whole team just gel together to become the greatest show on turf? Well, you know, when success becomes obvious and everyone sees it, they think it just happened then. No, that football team was built in 97 and winning four or five games and 98 and winning four or five games and roster changes being made. Rusty, there were only nine players in that Super Bowl that were on the roster when we took it over. Okay, three years. So there was a lot of room given for other people to come in and take jobs and find a way to do it better with the new people, you know, and none of them are bad people. They just couldn't meet what we were looking for. System coaches, you know, when we brought Mike Marx in in 99, the contribution that he made was tremendous, Al Saunders, tremendous contributions, you know. So, you know, it's a complete evolution. In the NFL right now, they expect too much too soon. See, it's a different league now, you know, you buy players and all these kinds of things. The practice sessions are now controlled by the players union, how much time they can spend on the field, how many days you have to warm pads, how many double days you can have, what you can do in the off season. So it limits the ability of great coaches and leaders to build. So the personnel department and the finance department, the salary cap, now you got to do more buying and hope you bought the right product, you know. You can't make mistakes if you do. You're in trouble. You're in trouble. You can't be successful, no matter how good a coach you were. Players win games. But you as a leader, you as a head coach, you as a coaching staff have to provide them with the tools to take advantage of their skills and what they can do. And then when you've done that, then the great ones take it beyond.  Coach V, I want to ask you about identity because every successful team, every winning team has an identity. What would you describe your team's identity as? What kind of qualities were you striving for in building your identity? Yeah, to me, I think they identified these guys really hardworking kids that really cared about each other. They were deeply involved in the whole team concept, not a cliche, not anything. They really cared about each other. And you use the term love. In some cases, they loved each other. You know, you don't love everybody on the team, but there are guys that fit in a category that goes beyond respect. And what's the next term you used that goes beyond respect? I don't know. I'd call it love. Now, it's not the same kind of love you have for your own family or a lot of kind of stuff, but it's not far off it. It's not far off it. And when that can infect a football team, because the deeper the compassion for each other and the passion for each other, the deeper the commitment not to let the other guy down. You don't want to let that guy down. You care about it. They want to lift me up their shoulders. They want to help the next guy go to Pro Bowl or become an all American goal. I would say 90% of the true selfishness of people is erased in that kind of environment. Yeah. No, I totally agree with you there. And Coach V, when there's a new coach of a team and there's some new coaches where they'll turn a losing season around within that first year coaching.  It's just a new coach with maybe their coaching staff. Is it just because they have a system or they have a better culture or they're able to connect with the players or to really highlight the strengths of the players? What do you think causes that? Well, first off, if a team was losing last year and they fire the coach and a new coach comes in and turns it all around, number one reason probably is they had some serious injuries last year. They had, they lost key guys, you know, and also all of a sudden, they're not as good because the players are guys that play the game. It wasn't that they weren't well prepared or weren't talented. They just lost the best players and it only takes a few and boy, all of a sudden, you're not what you were going to be. And we've all experienced that. I think that's the number one thing. I think there are very few teams that are poorly coached. Now, some teams are coached better than others. Normally, the teams that are coached better than others, those coaches have a say in personnel, have a say in a lot of different things that enable them to more quickly put the team together. Well, I went to St. Louis Rams. I had a 51% vote on personnel and I could hire anybody I wanted to hire. No restrictions, no number restrictions. And I hired the oldest staff in football. People thought we were all old men, but we had, we had some knowledge. We had some experience. There's no substitute for many years of exposure to how to do things. And gradually, like Andy Reed, gradually, you keep improving your scheme to the point that Andy's offense is always number one or right up there, you know, because he's been there and doing it. And so there's more often, I'll just summarize, more often than not, that team that was losing just last year, and you come in the next year and start winning right off the bat, mainly got players back. You had full control of the draft in trades, all that kind of stuff.  A higher percentage of the teams that you play because of the competition level, you have an easier schedule. I've done today, listen to radio, NFL's serious radio. Some people have the last four or five games, toughen anybody else. And some people have an easier than everybody else. Well, the guys that are playing the easier never is going to win more games. Okay. Because in the NFL, if you study hard, NFL team, playoff caliber teams playing each other, usually at the end of the season, if you break even at 50-50, you got a good chance to be in the playoffs. Our cells used to beat that. He used to win 70%. He was so good. Yeah. Now, coach, when I was coaching, I would focus a lot on fundamentals because I knew that if our players had strong fundamentals, it would show up when it was a pressured situation. Players that have weak fundamentals, when the pressure is on, I mean, it's very evident. How much would you focus on fundamentals in practice? Tremendous amount. Earlier, I said, Rusty, the union has taken away the ability of coaches to spend more time with individual players to make them better. Try them out, work them out. If he doesn't look at a good, bring somebody else in attitude. Now they have 25-minute coaching staff so that you can break down the two hours you have to practice into smaller groups and maybe still do a halfway decent job. But it's tough. You have to be able to develop players. I don't care what sport it is. If you have more time to work on the fundamentals, that player may never be an all-pro, but he'll be better. But an all-pro might be all-famous. An average player might become an all-pro if you give them time to improve their fundamental weakness. But it's more difficult for a coach today than it ever was. I completely agree. I mean, that's what I see. You know this, that discipline is a choice. Self-discipline is a choice. And I always say that discipline leads to habits which lead to success. What are your thoughts? Oh, I agree with you. Yeah, no question. Self-discipline might be the greatest personal attribute you can acquire if you have it, really. When you say, I think to my players, you say you're going to do something, you do it. I don't care what it is. When you say or have said, you're going to do it, you do it. That's the first sign of training yourself. I'm going to work out today, then you don't. I'm going to work out tomorrow, then you don't. Your discipline breaks down. And when you're really a self-discipline guy, what you say, what you think you do, you do. Sometimes it's pain. He has to do it. Sometimes it's tough. Sometimes it's hard. But because you said you were going to do it and you set the standard of doing on a consistent basis, then you developed the habit to do it. It is just who you are. And my wife laughs at me all the time. I say, I got to get my workout. I'm going to need you. What are you doing there? Hey, this is what I am. This is what I've been doing all my life. If I don't work out, I feel guilty. It bothers me. I wake up in the middle of the night thinking about it. What did I give into? Why didn't I do that? Why did I find an excuse? And I used to tell my players, you tell me something you're going to do, then you do it. If you say you're going to call me at five o'clock tomorrow, you call me at five o'clock tomorrow. Because if you don't, I'm calling you. You can teach. You can help people to a certain point improve their own levels of self-discipline. But the initial thing starts with a mental. You've got to recognize how important it is. Yeah, I'm totally with you there. Words and actions matter. And Coach V, you had such an effective coaching style. How would you describe your coaching style? Vermeel's way. You've got to be yourself. People, every once in a while, someone says, Coach, what's really important? I'm just becoming a head coach for this. I'm just a coach that got this deal. What's the most important? The number one, be you. You can't be anybody else but you. And it doesn't take long for players to recognize you aren't being you. So make sure that, and don't be afraid to let them know who you are, what you really are inside and out. Most of my players have been in my house. I've gone hunting with them. I've gone all the different things with them. They know me. And they either buy into what I am or they ask to be traded. And I think I'm an emotional guy. Yeah, I tear up. I choke up. And that used to embarrass me. And I know the initial some players great, but they know I'm sincere. They know that I care. And they know this is me. It's nuts. The tears or the emotion are not a tool you're used to motivate. They're just part of who you are, you know. And I think that's the big thing. And then you can't be what you are not. You can't sell what you are not. Your team will not be what you are not. That's why being an example is so important. You want your team to have a great worth of ethic. They better see it in you and they better see it in the coaches around you on a year-round basis. You know, that's just and very important to me. I completely agree with you, Coach V. And Coach V. No, yeah. Really, it's not complicated. You know your success in coaching wasn't complicated to you. This is just what you do. Yeah, I totally agree.  And yeah, you have to be the model, the example for your team.  And Coach V, when I look at you, I look at greatness. I see you as greatness and you've been around greatness. You've seen it. How would you define greatness? Well, it goes all the way back to saying, I think saying a person being the best he could possibly be and then just a little bit better than that. There are those guys. Kurt Warner is a great example of that. Come out of the arena league and a year later, he's the most valuable player in the national football league. Being the best he could be and even better than he thought he could be and a little bit beyond that. Nobody's ever done what he did his first years as a starter. They're raving all about these guys. Oh boy, their first year started. Yeah, they were first round picks. Okay. Here's a guy out of the street, off the street, 30 years old, 27 years old, whatever it was. But there are people. The military world has spent a lot of money trying to determine what developed in somebody to become a Medal of Honor winner. They can't define it. It doesn't come in a package and it can be, I've sat next to Medal of Honor winners and didn't know he was the Medal of Honor winner. He didn't look like one, but he was one. So you got to be careful of putting people in packages. Somebody that takes his God-given ability becomes the best he can be with that. Then he's a little better than that. He just finds it. They call him overachievers. All famed players are overachievers. Okay. Really? Yeah. If they hadn't been what they were and then taken it to the next level, like saying go from the Pro Bowl to Canton, they went to the next level. And there was some active use within them. Self-discipline, pride. Recognize that hard work was not a form of punishment. It was a solution. And they recognized that they were surrounded by people they cared about. Very few people, athletes, coaches, anybody can consistently give their best to a leader that they care about the least. Very seldom. Very seldom. They may do it, but they do it only because they have to, and that's how they get paid. But there's always going to be a little left in them that they haven't given yet. Coach V, I have to say that you are a man of great character. You're an exceptional leader, a tremendous role model. I am so honored to be friends with you, to know you. I mean, it's so, I enjoy all of our conversations and I really want to thank you. I appreciate it. I don't take those words for granted or I appreciate it. And please give Dr. Miyawaki my love. I love that guy. I just don't get to see him like I was for a while when I was coach in the Chiefs and he was a personal, personal friend of Lamar Hunt. Of course, now he's rooting for his bangles are playing real well. One of the great men I've met in my life. Thank you. I will. I'll convey that message to Dr. Miyawaki. Thank you, Coach V. Thank you. Thank you for watching Beyond the Lines on Think Tech Hawaii. For more information, please visit RustyKamori.com and my books are available on Amazon and Barnes & Noble. I hope that Coach V and I will inspire you to create your own superior culture of excellence and to find your greatness and help others find theirs. Aloha.


Up to half of Alzheimer's cases may be attributable to just these seven risk factors, and that's not including diet, just because there's so many dietary factors they couldn't fit them into their model. But they acknowledge that diet might be another important modifiable risk factor for Alzheimer's disease. In particular, there's growing evidence that dietary patterns, such as the Mediterranean diet, are associated with lower Alzheimer's risk, as well as slower cognitive decline. But which constituents of the Mediterranean diet are responsible? The traditional Mediterranean diet is a diet high in intake of vegetables, beans, fruit, and nuts, and low in meats and dairy. When they tried to tease out the protective components, fish consumption showed no benefit, and neither did moderate alcohol consumption. The two critical pieces appeared to be vegetable consumption and the ratio between unsaturated fats and saturated fats, essentially plant fats to animal fats.  But this is grouping all fats together. Harvard researchers examined the relationship between major fat types to cognitive change over four years, among 6,000 healthy older women, and found that higher saturated fat intake was associated with a poorer trajectory of cognition and memory.   What if one already has Alzheimer's, though? Previously, this group of Columbia University researchers reported that eating a Mediterranean-style diet was related to lower risk for Alzheimer's disease. But whether Mediterranean diet or any diet, for that matter, associated with subsequent course of the disease and outcomes had yet to be investigated until now. They found that adherence to the Mediterranean diet may affect not only risk for Alzheimer's disease, but also subsequent disease course. Higher adherence to the Mediterranean diet was associated with lower mortality, and the more they adhered to the healthier diet, the longer they lived. Within five years, only 20% of those with high adherence died, with twice as many deaths in the intermediate adherence group, and the low diet adherence group, within five years, more than half were dead.  And by the end of the study, the only people still alive were those with high adherence to the healthier diet.


From DailyDoseOfWeirdNews.com, I'm Darren Marlar and this is your Daily Dose of Weird News! This episode is brought to you by the audiobook One Bad Night by Jason R. Davis, narrated by Darren Marlar. Here's a free sample on the audiobooks page at MarlarHouse.com. What comes to mind when you think of back-to-school prep? Stocking up on notebooks and pencils, a trip to the mall for the latest sneakers? How about watching hours of content on YouTube? Well, for Generation Z, the video platform has become an integral part of the yearly late summer ritual, providing product suggestions, style inspiration and do-it-yourself ideas. The most popular content of middle school students is hairstyles, makeup and pranks. High school students look most at advice sites, life hacks and skits. And college students are surfing mostly for advice and tech products. Do they make a Cliff's Notes version of YouTube? A woman in Germany called police to report what she thought was a bare-chested man with two big white dots on his forehead staring into her window. Well, the man turned out to be an emu which had escaped from a local zoo. I can only assume that men look a lot different in Germany. Long drives and short fuses do not mix. A recent study shows that the average couple can last only 22 minutes into a road trip before they get into their first argument. That means most couples start bickering not long after they leave the driveway. The most common cause of car crankiness is clashes over directions, with 44% of the respondents to this recent survey admitting they thought over which way to go. Seems much of the stress of driving is caused by our own partner when we're behind the wheel, which is exactly why every Sunday before heading to church I lock my wife in the trunk. Hundreds of pastors from Richmond, Virginia have signed a new statement of unity, rejecting the ideology of white supremacy and affirming that every human being is created in the image of God. According to CBN, the Metro Richmond pastors and ministry leaders who signed the statement repented for any role the church has played in the sins of racism and resolved to preach, teach and advocate against it. But then somebody mentioned that Jesus wasn't white and a fistfight broke out. Your puppy may have a better understanding of language than you think. Researchers in Budapest used fMRI to monitor 13 dogs while they listened to human speech, and the scientists discovered that the animals processed both the meaning of words and the tone in which the words were spoken, using similar areas of the brain that humans do. So your chewed-up slippers may not be because he's a bad dog but because his feelings were hurt when you said bad dog. The nation's largest atheist organization, Freedom from Religion, is demanding that Senator Marco Rubio, a Republican from Florida, stop tweeting Bible verses from his Twitter account, telling him that doing so is a violation of the United States Constitution. No, it's not. It's kind of interesting a group who's always screaming for freedom of speech when they want to say something don't believe in free speech for people that say stuff they don't agree with.  A new study reports that older women are doing more and more binge drinking. Usually after seeing the selection of older men available to them. In England, a farmer thanked firefighters who rescued a litter of piglets and two sows from a barn fire in February by giving them sausages made out of the animals. Well, good thing they didn't have to save his kids from the fire. The study says every droid in the workforce is going to cost six humans their jobs. Plus, they don't pick it for 15 bucks an hour. In fact, they don't get paid at all, and they're perfectly happy about it. On September 9th, in Austin, Texas, they're going to have a clown-only showing of the new movie It, based on the Stephen King novel. Because just being a Stephen King movie isn't disturbing enough. A guy in New Zealand was robbed of everything in his pockets by two men with a garden rake. So, once you anti-Second Amendment folks get the guns banned, you'll next have to work on banning garden utensils. Sears says it's going to close another 28 Kmart stores. If you see a blue light special, it might be a sale on buying the actual store. If you're already an official weirdo, please share this video on Facebook, Twitter, Reddit and other social media to help get the word out. To become an official weirdo, click that subscribe button and click that little bell next to the subscribe button to be a part of the notification squad. While you're at it, click that like button to let the world know that you're a weirdo.


Morning Gary. Morning. How are you? Yeah, good. Thank you Would it be safe to say you slept okay last night or were you in your study at 2 a.m. Analyzing the game? No, yeah, I don't sleep great after games. So I'd a quick look at leads last night Obviously, yeah condensed prep for for leads. So Yeah, made a little head start on that one and a lot to do today to make sure the boys are ready for Sunday How'd you reflect now that the dust is ever so slightly settled on what was a huge Result for you in your quest for Premier League survival and a and a really good solid away performance Yeah, I think that the most important thing was was the result of course So we spoke a lot about that The fact that the performance also had some real good elements in it is is a positive of course, but Yeah, just a how big the game was the opposition we faced and almost Being able to take a free shot at us and they didn't really have yet It was a it was a tough game for the boys I thought because we were in a in a position that we'd been on a decent run and we'd managed to move as it Move ourselves away slightly whereas Southampton were almost Yeah, last sort of throw at that point and they were gonna throw everything at us and there would be a desperation So I felt it was it was gonna be tricky to see them off initially first part of the game I thought would be tricky for us And I thought the lads managed it really really well and then managed to control the flow of it And yeah, look like a good side for for large parts now that you've had the chance to sort of Reflect and come out of the the heat of battle two decisions the the VAR non-intervention for the handball the clear handball and Perhaps Dom's goal in the first half that wasn't even looked at with offside Have you had the chance to review those decisions? And are you maybe as baffled now that you've had the chance to look at them as you was last night in the press conference? Yeah, no, I haven't seen I've reviewed the Dom situation I thought yeah, I was shown the handball quite a lot after the game and yeah, I was very surprised Not that I think that should be handball just that we've just seemed so similar to so many we've had go against us that Yeah, I just struggling to understand it a little bit. I will seek some clarity on that as well This this week or next week whenever the the guys are available to catch up try and figure out The differences and and and also why the check seems so short on it So, yeah, there's a few things that I need clearing up on that but Yeah, bigger picture a couple of VAR calls obviously we get a factual one and offside that goes our way which is Nice because we've had a few that haven't so yeah, I think Let's reflect mainly on the performance and what a huge victory and Yeah, an incredible run that the team have been on. I think that's 15 points from the last eight games At this stage of the season with the fixtures that we've had in there is a yeah, it's an incredible return that the The group of players have worked hard to achieve Like you say great form at the moment three wins in four seven points clear of the bottom three How do you instill into your team that the season is not over and you know every place in the Premier League Is worth upwards of three million pounds. So there's still a lot to play for between now and the end of the campaign Yeah, at this moment, it's not about each place. It's still about avoiding the bottom three for me So, um, I still believe 36 points could be relegated. I think Um, maybe the world felt when we left The Tottenham Hotspur Stadium that we were fine and then you get a performance against West Ham Um, where we let ourselves down.  You've won three of your your last four sort of very different forms Of of late and and they've had a couple of big heavy defeats where they've conceded five and six goals But they've shown that they can still be dangerous How do you impose yourself in the way that you do against Southampton? But take your chances because clearly they can they can concede goals Yeah, I think I haven't seen loads of Leeds Obviously been yeah Southampton and Westam prep mainly this week But then um, yeah, I'll have more of a detailed look at them and See how and why and but for us, I think just making sure that we we start the game well Um, because we have conceded some early goals recently And we were out of our last home game before it started So making sure that we're we're ready Which will as I say the boys are going to be extremely tired this morning going for a recovery session as we speak So they'll be tired. There needs to be a lot of work done In a short space of time to make sure that we we turn up right from the start of Leeds We don't have yeah, we don't have time to to ease ourselves into this one They play it in an intense way And they'll have seen the start against West Ham. I'm sure And they'll be keen to come and impose himself in front of our crowd and try and make it an awkward afternoon for us So, um, yeah real focus from me on trying to get the boys ready to Start off all guns blazing at two o'clock on Sunday And then just find me from me. I know it's not been a lot of time since the game But but any knocks or worries from from last night or anyone back in the the squad you can welcome for the weekend Yeah, so taff obviously we need to see how he is this morning.  Um, yeah, matty vinnier ideally wouldn't have done 90 but then Taff having to come off made that tricky. So matty maybe did longer than he he was meant to. Um, have to see how he is marcos Suffered some cramp as well. Obviously hasn't played as much recently So there'll be a few that we need to check. Um Yeah, we'll have a look whether we need to freshen it up a little bit because some of the Yeah, some of the distance is covered and the intensity of the game last night was very very high. So, um Yeah, we need to have a look and make sure we get things right and give ourselves the best chance of Being fresh enough to to um, yeah to cause leads some problems. Thank you Gary just the result last night Effects your choices in terms of that rotation the fact you got the three points in and maybe a little bit more Comfortable in the table. Does it affect some of the rotation decisions you might make? No, I don't think so I think I don't feel any more comfortable at all. So, um, Yeah, I still feel that At this moment in time we could be relegated. So let's um, let's approach the game exactly in that way. Um, Try and get the best team out there for For energy also for quality. Um, so yeah, there'll be no No rotation that wouldn't have took place in any other scenario. It'll be Yeah, business as usual from team selection wise that's interesting to hear you say you don't feel any more comfortable after last night's result I mean people seem generally more comfortable around the club But is that is that just your forward-facing bit as the manager? You have to be saying the right things or do you genuinely not feel more comfortable after winning last night? No, I felt everyone In the world felt more comfortable after Tottenham. Um, and you see what can happen So, um, you lose a game for Neil to Westam not in a forest beat Brighton and all of a sudden it's full Lose at Southampton and and we're we're right back in it. So, um, things can change very quickly. So We've been on a good run. So other teams definitely can as well. So, um, Obviously, yeah, as I say, I still think 36 points can be relegated. So yeah, a real clear focus from me last night's done Um, we obviously enjoyed the the fact that we managed to execute a game plan Against a team that could have been dangerous on the evening Fantastic that the fans got to enjoy another away victory. Um, But yeah, nothing nothing done yet. So yeah, we need we need three points on Sunday Just looking at your numbers now You've had as many away wins as Liverpool this season in the Premier League Which given how hard the first half of the season was away from home for the team It's quite an eye-catching statistic Does that just emphasise the kind of progress you've made in the last couple of months away from home? Yeah, I think we are making progress. I think even at home fullum and fullum and Liverpool recently Good victories. I think we're we're trying to improve everything. I don't see us purely as a as a counter attacking team I know the away wins would would suggest that but Leicester We were dominant with the ball really Tottenham dominant with the ball for long spells last night felt we had control. So Yeah, trying to improve all aspects, but yeah, three three away wins on the trot For ourselves is is is a big achievement the lads the lads deserve real credit because winning away games in the Premier League is tough Winning one is tough. So to go free on the trot at this stage. That's a critical stage is um, yeah an impressive effort from the lads And did you recognise this team now from the one that played at Leeds earlier in the season in there? See saw for three game that was spring in both ways. I saw lots of promise in performance at Leeds The way our goals arrived from Directly from the game plan that we'd come up with the way the boys were able to carry it out Um, and then just a real concern at that point, especially that that sort of spell in the season where we once the game Wasn't tactical anymore and it became a bit more chaotic that we suffered Um, but lads have obviously made us to show real improvement in that not not perfect I mean it can be tricky that part of a game Um, but I think back to Wolves away um Managing to see it out. Um some other ones where we've Once the game becomes chaotic even Southampton last night. I know they have their their offside goal But apart from that our goal wasn't under real threat even though they had bodies everywhere and Yeah at that at that moment in a game you're relying on a group of players being able to see something out. Um But yeah, I think we've improved in that. Um, but still lots lots of room lots of room for improvement I didn't think don't think last night was the complete performance by any means but um Yeah, an impressive one for the for the amount of pressure and how much was riding on the game Another player that's caught the iron recent weeks has been Joe Rothwell. He ran himself into the ground last night I think he was still barely barely moving by the end of the game But um, can you just sum up the improvements that he's made himself and what he's brought to the team in the last few weeks particularly? Yeah, he's an interesting one Joe. So he um, he came from blackburn and was very Very attack minded never had too many defensive responsibilities at at blackburn And we worked hard for Joe on sort of changing just his habits really around how he sees the game and how he sees day to day training and um Yeah, it took a while With him to to get him to where he is at this moment, but yeah full credit to him I mean there's nothing we haven't done anything spectacular with him We've just tried to point him in the right direction and he's grabbed his His moment and his opportunity and he works his socks off every single day Um, and he's shown a huge improvement in just yeah, he was he was always a fantastic footballer But now he stays connected to the game much more. He um Yeah, he doesn't switch off anywhere near as much as he used to he's and you saw last night against a very talented Southampton midfielder in in lavia that he he can hold his own against some of the That yeah, some of the top midfielders in a Premier League Just fine. I know you speak a lot about not being bothered about proving anybody wrong or anything like that outside Or any noise Do you think your players take pleasure and motivation from from proving people wrong and I guess Stunning stuff down people's throats. I hope so. I would have yeah, I would have Um, so yeah, I hope they're enjoying it


Morning traders, pleasure to be here with another tip wheel chart here.  Intraday hourly time frame Kiwi Dollar, we have for that initial decline. We had a secondary low here which was met with positive divergence. We've now seen the first leg of a recovery. What I'm looking for is a second leg to the upside here. So I ran long through the 73 level using a stop just below the overnight low, 72 75 and I'm targeting at a minimum an equal objective up into the daily range resistance at 73.90 and we'll see how we trade there. My trail will stop up if we get an impulsive move and take out the cryo highs or watch for reversal patterns in that area. As always traders, plan the trade. Trade the plan and most importantly manage your risk. Until next time, thanks very much.


Hello, welcome everyone, welcome again for our second module. So as you have seen in our last module, so we have discussed about the different type of fuels and then different type of fuel choice and conversion device. So when we look into the biological pathway, when we look into the biological pathway, we have this biomethanation. Biomethanation is nothing but the biogas generation and which we have seen, it is mostly on the cellulosic based feedstock. So if we have good cellulose in the waste, then this technology is a most suitable one for that. And then when we look into the bioethanol generation, then we need something which is more on the sugar-based side. So biologically these two are the prominent technologies that convert our waste to energy. When we look into the chemical process, so chemical process we saw that biodiesel which requires mostly the fat, fatty oil and fatty acids. So they are very much specific to a particular type of compounds or chemical species in the feedstock or organic species which they are selectively converting to the desired energy carriers, whether it is methane or ethanol or the biodiesel. So but when we look into this thermochemical pathway which is focus of our study because this is a process which is giving us the hydrogen. So when we look into the thermochemical pathway, we have this pyrolysis combustion and gasification. These three are the prominent technologies which are classified into thermochemical conversion. So here we have the flexibility that any biomass with low moisture content can be converted. So we have seen that mostly the three compositions are lignin, cellulose and the hemicellulose. So these three are major component plus we have something like salts, something we have protein and then we have fats, etc. So these are mostly the less component in the biomass waste and especially if we are looking into the something organic waste which is coming from the plant based species. So agro residue or even the cellulose makes the major component for the animal excreta. So these are three makes the bulk of your thing. And thermochemical conversion, it does not have any distinction or preference for this thing. It needs to have a low moisture content. So we will see what exactly this thermochemical conversion process is and combustion is something which all of us know. So we will start with that. So thermochemical conversion combustion of biomass. So combustion of biomass is one of the oldest process or the technology that human civilization has invented controlled fire. So fire was one of the major or one of the I would say the most important finding of the human civilization for the light and heat and keeping the animal away from them. So this was one of the most significant invention or the discovery by the human civilization. So what exactly combustion is technically speaking, we all know what combustion is something burning, yes. So technically which involves the complete oxidation or combustion which involves the complete oxidation or the stoichiometry combustion which we call complete oxidation of biomass fuel to CO2 and H2O with remaining coming as a ash. So that we classify or technically as combustion. So our predominant fuel that we have been using for centuries, it is oil seeds, agro-recedue, the green stalk and husk. So agro-recedue is not something new that we are trying to use it to get rid of the problem of paddy straw burning, agro-recedue burning in the fields that is one of the burning issues of the today generation. But it is something which has been in use for decades, sorry not decades for centuries. So these agro-recedues have been used as a fuel for cooking as well as as a fodder for the animal stock for the cows and buffaloes. So plus there have been tradition of collecting the tea branches and the broken trunk and broken tree branches collection of firewood, collection of firewood from the nearby jungle or from the villages which have been the key cooking fuel for centuries or for thousands of years probably. So then another is the dried animal dunes. So animal dun, dried cakes which is quite common still now in our villages and specifically this is one of the very good process to get rid of the animal waste especially in the rural areas. So this is basically the combustion process technically speaking. Now when we talk about the paralysis and the gasification. So these two seems to be a new term, how it is different from this combustion. So this paralysis, gasification and combustion. So these are not something which are very much different but here we will see the combustion involves this paralysis and gasification. So these are quite interlinked. So I would like to explain it with an example of this burning matchstick. So this burning matchstick all of us have seen, have used, have burned and we know whatever you are seeing here it is very much familiar to every one of us. So when we look into this particular thing, this flame, this flame that you are seeing this yellow luminous flame, this is something which we classify or identify as a combustion process as a oxidation process. And then we have this red charcoal burning. These red charcoal burning and then this is a luminous flame. Both of them are oxidation, both of them are combustion. Technically in both the part the combustion is going on. So then the question comes what is the difference between these two? What is the difference between these two? And if I ask you a question, you have biomass is a solid fuel, biomass is a solid fuel. And then we are seeing these two flames or these two oxidation zone or combustion zone. I would say combustion zone we are seeing this one and this two. So one and two which one is a solid combustion, solid combustion, which one? So that is a question. So just take a pause of 10 seconds, think that this red charcoal burning is a solid combustion yes or no and this flame, luminous flame, yellow luminous flame, is it a solid combustion or a gaseous combustion? So just give it a thought. So once you look into that just by common sense that how do we see? We do not need to go into the detail of technical definition of solid combustion and gaseous combustion. Common sense says that some gases if it is burning it will be not restricted to one place. If we blow it with air you will see a moving flame. So it will move. So this particular flame will move. It is not something solid that is fixed at one place. It is something fluid which is flowing. So it is either liquid or it is a gas. So our one, this particular thing or this is your solid combustion. If you blow it, this charcoal is not going anywhere and this charcoal, the carbon in this charcoal is getting oxidized which is in the solid form. So this is classified as solid combustion. Now what this is a gaseous flame, gaseous flame. Now the question comes from where does this gas comes, where does this gas comes? Now that is the process called pyrolysis. So in pyrolysis what happens? In pyrolysis what we do is whenever we have a biomass, biomass it is nothing but a composed of various organic compounds. So when you supply heat, when you supply heat what happens? It undergoes pyrolysis. So pyrolysis means pyro means heat and lysis means breaking down. So pyrolysis means breaking down the molecules or the organic compounds under heat, pyro means heat. So you are supplying the heat or the energy basically if you want to break a bond you need to give some energy to it and that energy is actually supplied in the form of heat. So you are supplying the heat and it is getting broken down. And then you can recall that how does your overall combustion process of this thing. So let me just rub it first. So now you can identify this as some chemical which you rub on the matchstick side and then it will catch fire, it will catch fire and what it does? It supplies heat to the wood, heat to the wooden stick and then this is what happening here. So this flame, this flame is not only supplying heat in the surrounding but also it is supplying heat in the bottom side to the this wooden piece of the matchstick. So and you can see that, you can see that here your sum of the portion, sum of the portion is has gone blackish, sum of the portion has gone blackish that means it has, it is undergoing the thermal breakdown, organic compounds which are essentially the high hydrocarbon oxygenated hydrocarbon. So they are undergoing series of thermal crackdown, it is undergoing a thermal crackdown and releasing the lighter compounds into the atmosphere. So lighter compounds when it undergoes it comes out here and this is nothing but your fuel, your higher hydrocarbon, higher hydrocarbon is actually coming as fuel and this is called volatile. So what does this pyrolysis process produce, it produces volatile and volatiles is nothing but higher hydrocarbon. So short form for that HHC, higher hydrocarbon and oxygenated higher hydrocarbon and plus it also has carbon monoxide, hydrogen, H2O, CO2. So there is lot of, more than typically if you do a pyrolysis of a biomass you will see that there are more than 200 species, the more than 200 species different chemical compounds that comes out of the biomass during the process of pyrolysis. So this is what is happening but is it the only thing that you get from this pyrolysis no. What you are seeing here is you are also seeing the leftover, this again you are again seeing this as a leftover charcoal, charcoal. So this is what is coming as a another product of the carbon in the form of charcoal, so typical language we call it charcoal and this will have ash also in it, ash those inorganic compounds sodium, potassium all those things will not undergo means will not get oxidized nitrogen and all compounds. So they will remain in the solid form in different oxidizer, whether it is oxidized or different other form but it will remain in the solid phase and will be embedded in your charcoal. And finally if the charcoal will get burned, so when this charcoal gets burned what you get is if your charcoal gets burned finally you will get ash and then all the combination of all this process is called the combustion. So here what is happening is you are doing a pyrolysis here, pyrolysis here then you are generating fuel that is volatile and then you are getting oxygen from the surrounding air and this is reacting with oxygen to give you CO2 plus H2O plus heat plus light. So here we are seeing light also as energy and heat also coming out. So heat and light but this CO2 and H2O is released when you are having this oxidation of this volatile and plus here what you are seeing is carbon is getting reacted with oxygen to give you CO2 plus heat plus light if you want to get this light from this small red hot burning charcoal. So this is what is we identify as combustion is nothing but combination of your pyrolysis and we will see that where does this gasification comes into picture. So in gasification it is something where pyrolysis combustion is both are actually happening. So we will take this gasification a little later in the next module what we will do is we will continue with the pyrolysis process. So pyrolysis so I hope you understood that whenever we are breaking down the biomass by supplying heat pyrolysis happens and in the pyrolysis this biomass is getting converted into something called as vapour. Because it is at high temperature everything you will see it is coming out as a vapour but if you bring down at the room temperature then you will see that you will get some as condensate which is technically called as bio oil which is higher hydrocarbon compound which remains at liquid at the room temperature. So this is what happens in this case and combustible gases which are essentially the lighter compounds like you will get hydrogen, CO, then methane, then your C2 plus compound, C3 plus compound so they will remain in the gaseous phase under the ambient condition. So they are combustible gases and then condensate bio oil and then solid residue of the pyrolysis we have seen in the previous slide we get the charcoal. So this charcoal is also part of that. So now when we look into the organic chemistry, organic chemistry of this so typically this is one of the example of your glucose. So this is simple glucose where your glucose molecule when you supply heat breaks down into liquid bio oil. So this is C6 compound which will remain in the liquid state once you bring down into room temperature and then methane, hydrogen, carbon monoxide they are combustible gases and plus you are getting biochar, carbon as a residue and then also you are getting as the water of pyrolysis. So this is water, this is will also come in the solution with the bio oil. You have to separate it so that is one of the challenge and one of the process that you have to separate this water of pyrolysis if you want to use the liquid bio oil and what is the use for liquid bio oil that we will see in the next slide. So here we have seen that our hydrogen, hydrogen is coming out as one of the product in the combustible gas and here in this particular course we are interested in this hydrogen. But also we will see that this liquid oil, this liquid oil will also give us hydrogen and that is how it gives us so let us see. So before that, before going into the chemistry of getting hydrogen from the bio oil or the liquid condensate, so different pyrolysis pathway depending on what is the temperature and what type of product do we get. So these three are the major broad classification of the pyrolysis. So first is the fast pyrolysis where we do it at moderate temperature and short residence time. And then slow pyrolysis where we do it at low temperature and very long residence time. And then gas production where we look for high temperature and long residence time. So these three and here we are seeing that when it is short residence time moderate temperature then what we are getting, we are getting high amount of liquid. When we are doing slow pyrolysis, we are getting high amount of solid char and when we are doing looking for gas production, high temperature and long residence time we are getting this high amount of gas. So to understand this we have to understand the very basic chemistry of how this pyrolysis is happening and what is the role of temperature and the residence time. So if we look into the any higher hydrocarbon, we will not take very long, just take the example of your C3 compound, C3 compound you have. So this is nothing but your C3 etchette, C3 etchette. Now your temperature, your temperature signifies kinetic energy of the molecules, it signifies the kinetic energy. So temperature is nothing but measure of the root means care, the average out velocity or kinetic energy of the gas molecules and when we say high temperature means we are giving the high energy, high kinetic energy and high kinetic energy and this could be the gas molecules, molecules in the reacting system. And what does it do? Just take this could be M, this M could be oxygen, M could be nitrogen, M could be argon or M could be even this propane or the C3 etchette molecule also which has reached to a high velocity or the high kinetic energy it possess. And why this is required high temperature for initiating any set of reaction? Because you need to break down any of these bonds, any of these bonds needs to be broken down, broken down. So typically what happens is this carbon hydrogen bonds are more stronger, are stronger than your carbon carbon bonds. So this carbon carbon bonds here are weaker. So at low temperature when this M hits here or hits here it will get broken down. So just imagine that this will get broken down. So what you will get when you increase the temperature, when you are increasing the temperature means we are doing the pyrolysis. We are doing the pyrolysis, increasing the temperature and then some of the molecules will come and hit this at high velocity and will break the bond. So you will get C2 compound and plus CH3 here. So these are still radical, if we write down it like this. So we are getting these two radical compounds. Now this is happening, now reaction also needs time. Reaction is not instantaneously. All these M molecules when this happens, this also M which had kinetic energy greater than the bond energy that time or was at high temperature it will come down with kinetic energy less than the bond energy because it has transferred it energy to the for breaking down the bond. So here the M has slowed down or the kinetic energy has of the system has reduced. So it is not that instantaneously when you do or increase the temperature then everything will get broken down at the instant. Also because in one set you are getting this C2 and C3 then again some M will come and will come and hit here with high kinetic energy and you will get hydrogen will come out and plus you will get C double bond H, H, H, H which is a stable compound, stable compound potential output of your pyrolysis. This is just example, we are biomass is not having this propane as such but we are getting this C2H4 which is a stable compound because at the end of any reaction you will get the species which are stable compounds. They are not radicals or ions or something which they will be stable compounds. Now this H is very is radical and very very reactive it will go and hit something else which will be say C4 compound, there will be some C8 compound, there will be carbohydrates, cellulose, hemicellulose, in the variety of things having different different bond energy, having different different chemical structure, everywhere you will see that they are getting broken down. So it all these things initiate a chain reaction, chain reaction. So whenever we say chain reaction it also involves time, it involves time and with increase in time if you give more and more time you will get smaller out smaller chain compound, smaller chain hydrocarbon or species or the chemical species will be of shorter chain. So if you give it the time this C2 compound will also yield this and this can also get converted to CO, H2 and something else. So if you give C5, C6, C8 you will see that ultimately everything will come down to C3, C2 and all those things but you need to give time. So that is what is happening here and we see in this particular slide if you give short residence time and moderate temperature. So moderate temperature what happens is at the moderate temperature your overall kinetic energy of the reaction system is low. You do not have enough energy to break some of the tough or stronger bonds. Not all the bonds in the this thing will have the same energy level. Similarly this paralysis happens it starts at around more than 175 degree centigrade and it continues up to 900 degree centigrade. Some of the tough thermally very stable compound, thermally stable very strong bonds and they are lignins. Lignins the cellulose and hemicellulose start disintegrating or start breaking down at the lower temperature starts with the hemicellulose, hemicellulose bond energy of some of the bond energy is low it is you will see that 175, 180 degrees they will start breaking down but lignin will not start breaking down below 450 degrees or so. So every different compound have a different number of bonds and every bond will have its own bond energy. So if you have moderate temperature then many of the compounds you will not be able to target. Then another thing is short residence time whatever you have disintegrated it will mostly be still be the large hydrocarbon compound which will be in the liquid state at the ambient temperature. So you will get very less amount of gaseous product in it. But then the same thing if we go for long residence time and increase the temperature also little bit then you will see that whatever this liquid compound was it will also start getting converted to smaller hydrocarbon that will be in the state of the gaseous state and also you will see that some of the charge which still has lot of organic molecules still unconverted. This charcoal and this charcoal does not mean that it is only carbon still they will have some hydrogen and oxygen in it. And this particular thing you will see that it will sorry it is getting reduced and you will get converted to this liquid and then liquid will get converted to gas. So charcoal output is also coming down and then when we look into a low temperature. Low temperature but very long residence time. Low temperature many of the organic molecule will not be able to specially the lignin and some of the solulose which also get disintegrate or crack down at the high temperature which charcoal yield will be still very very high. And because you are giving the long residence time your liquid thing will come down and your gaseous output will increase and this liquid thing will reduce. So this is the effect of the long residence time and your charcoal still is high because you have given very low temperature. So depending on what type of output you want you go for different pathway. And here what we are looking for we are looking for more of the combustible gases because this hydrogen is in the combustible gases the more the gas you have you will have more amount of hydrogen in it. So for high amount of hydrogen production we go for the high temperature long residence time of the paralysis process. So this is about basic of the paralysis we will go further after paralysis also can we do something with this liquid whatever this liquid is what we discussed in the previous slide that how we get the liquid bio oil also to the hydrogen. So we are just looking into whatever hydrogen is there in the biomass and typically it is around 5 to 7 weight, weight percentage by weight or 50 to 70 gram of elemental hydrogen in 1 kg of dry biomass dry biomass. So this is something present there and something we can get it from the combustible gas you get it in the gaseous state hydrogen but still there will be something which will be in the embedded in CH4 which will be in the liquid bio oil and that how we get it. So that we will take up in the next module and we will discuss on this which is actually the more industrial way or the effective way of harvesting the hydrogen or at least we want to go up to 50 to 70 gram whatever is the hydrogen there we want to extract that and can we extract more than this also can we get more this we will try to understand in the next module. In this module we will stop here. Thank you. Thank you again for your patience and give it to you.


I have an untested theory that the single most common container for data sets in the entire world is spreadsheets. And of those, I think the majority are probably going to be Microsoft Excel spreadsheets. So for instance, if somebody sends you a spreadsheet or if you download a spreadsheet from online, it might be an Excel format. And even though it's really easy to import Excel directly into Google Drive or into Google Sheets, I do want to show you you also can just resort to plain old copy and paste. So I've got a spreadsheet here that's import. And it's the same data I've been using for some other examples. I'm going to select the entire set by doing shift and then commander control with space. I get the rectangle. I'm going to hit copy. And then just go back to Excel sheets and hit paste. I'm going to do control or command V in this case. And there's my data. I'm ready to go. On the other hand, it may be that you also are going to be using data from web pages on tables. I do this occasionally. And so for instance, if we go to this next tab, I have a link here to a page in Wikipedia on Nobel laureates that has a table in it. So let's open this page and it talks about who's won the Nobel Prize, which is a wonderful thing to do. And here we have a table with a list of everybody who's ever won a Nobel Prize from 1901 down through 2017. There we go. Now, what I'm going to do is I'm going to copy this. I find it works the best if I started the bottom right, and I just click and I drag up. And I'm going to go up to 1901. Just have to not go past it. Almost there. And I'm going to copy the headings to. So now I let go, I've got that all selected. I do command or control C to copy it. Then I'm going to go back to my spreadsheet. I'm going to come to this cell right here. And all I do is I hit command or control V to paste it in. Now this is going to do something slightly weird. And that is, these are all links. So I've got a million links on this table. And truthfully, that may cause problems as I'm trying to deal with the data. So I'm actually going to ask Google Sheets to not paste it as links, but to paste it as plain text.  And I say, give me the values only. And now you see it just turns into unformatted text. And that's a great way to go. I can then if I want to, I can delete this first row, I can then lock that first row, I can put it in bold, I can highlight the columns and then just double click right here to resize them. And now I've got a data set that I can work with. This is great. I do want to show you one tiny more little trick about copying and pasting in Excel. I'm going to go to this sheet called paste transpose. And I'm just going to type in a little bit of data here. Now, I showed you in another video how Google Sheets is able to fill in a pattern. If you do 123, it just keeps continuing or if you do q 01 or q 02. It can also do this with things like days of the week. So I've got Sunday, Monday here. And I'm just going to highlight those two. And I'll drag it down a little bit. And look, we had now have the whole week. Now, what I want to show you is if you want to switch it from being arranged vertically in a column to being the column headers, what you want to do is a special kind of paste called a transpose or transposition. So I'm going to copy this by hitting controller command C. Then I'll just come over here. And I'm going to do a control click.  And we've got a few options here. The one I want to show is this one right here, paste transpose. And it flips it around from the roast to the columns. And if you're trying to set up your data for analysis, this can save you a lot of stress about trying to rearrange things manually. And so that's just one final tip on getting data by copy and paste into Google Sheets.


Roger Ebert actually gave this movie thumbs down, right?   A bore? This movie's anything but bore and tons happening, tons of subject matter. A bore? I don't think so.  And you know what, Siskel and Ebert? You're dead. So who cares? I'm not gonna say it again.