Well, hey, well good morning. Good morning, Hal. Good morning. Good to see you And I know that we this this holiday weekend a lot of people have Well, they a lot of people took off on Friday and we'll are still disappeared. They're still gone I don't know where they went. Most of us are Most people I guess states are starting to reopen and people are getting out and about Did you do anything exciting over the weekend? No, not as far as going anywhere or doing anything. We did using the traditional steak barbecue last evening One of the nice things that's been happening here with the with the shutdown and everything is that of the number of the local musical groups have started doing live streaming on Facebook or Twitch or one of the various streaming services and It's it's turned in to out to be kind of a regular thing There's a bunch called the porch rockers here in town and they put on a live concert from a driveway last night It was quite an audience People pulled up all very nicely distant apart that sitting in their cars There was even a fire truck that pulled up and it sat down for a while. So that was it was pretty neat You know, it's it's not really as much fun as being there, but it's it's not half bad It's not half bad Yeah, there's a I know that there's been some innovation that's been happening around the music side of things to make up for The the lag time between some connections. It'll be interesting to see And hey Sean it'll be interesting to see is they You know create some technology that does a better job of syncing up that conversation Which can then be applied almost like an R&D effort and can be applied to meetings in general Sean we're just talking about bands Musicians that are playing, you know online little mini concerts and things for people in streaming that which is You know, I've got the benefit of having really nice quality high quality speakers my setup. So You know, that's I'm sure people or have been throughout this been upgrading their home studio setups I Suspect you're right Sean what's the latest with you? Along those lines I am back to Kickstarter effort. I don't know if you happen to see it Posted out on my Facebook page, but it's a all-in-one sort of podcast mixing system Which was relatively inexpensive inexpensive and I thought it'd be interesting way to Or at least something interesting to play with for a short period of time You know be interesting to and I didn't I saw the link I didn't explore further into that since I have a lot of other equipment and microphones and So I've got my You know that the audio the zoom device not zoom the video player that most people know but It's an actual Digital recording and I've got I can do up to eight channels So I can do a I've got a double mic on the front of it so I can have up to eight people Yeah Yeah, so I just posted the link. I know you've got much better equipment heck I remember from SharePoint fast Seattle when you popped open your magic case full of condenser Whoa, yeah, the one like a rogue anesthetist, you know walking in someplace I'm the I'm the traveling carnival guy. You know look at my wares You're just the carnival guy. It's it's I've got salves.  I've got a great question. I've I did end up commenting on this So I won't share my answer. I'll share some of the other answers But a guy so Phil out on the Microsoft Teams community on Facebook Starts it out says what am I missing? I have a team so Microsoft Teams question with about 16 channels I need to assign a guest from another work domain to see just see one channel in that team From collaboration on a project. I did a test and the guests can see all 16 channels Of course you add them to a team they can they have access to that so how can I assign permissions to just that one and Let me tell you that the he had a range of incorrect responses One it's just not possible You know like that you just don't understand The the way that teams is set up and that's working as designed Somebody else telling him lecturing him that he has too many channels and that's just the wrong use of teams Folks you can have a hundred channels. There's no wrong way to use teams in that respect And somebody else coming to do teams is horizontal not vertical You can remove them from teams but add them to the and this is correct to a SharePoint online Library that's another way of accomplishing that But if so I'll let you guys answer So he had 16 channels. He wants to add a person to just one of those channels. How do you do that? my thinking well, if one of those if the channel in question were implemented as a private channel and Ding ding ding ding. Yeah, that's my thinking. That's that is the scenario that they deployed private channels and so it's a if you need to restrict access Then that is the only way to go and do that it essentially Breaks the hierarchy the permissions hierarchy You would have to go and use treat it like that channel as a completely separate team Meaning that if you want everybody in the team to have access to it plus that one person you add Everybody in plus that one person and you can do that from your active directory say you're like all employees Whatever it was for the creation of that team plus that that one person and then they would have access to only that channel Yeah, that's my thinking yeah You know, there's a lot of people that had a problem with Private channels a lot of SharePoint people that spent years cleaning up permissions Continue to clean up permissions. They still bear the mental and emotional scars. That's right and But you know, I think I said all along and I was one of those people. I wasn't a fan of that I think there are other scenarios like just giving access to You know to the to a SharePoint list that is locked down However, you want to have the rest of the benefits of the chat and integrations with other applications As well as access to content. There's there's not it's not just about content Within those teams so I understand why they did it And so I don't use them very often. I've got a couple and they meet those those scenarios So make sense Anything I thought that was a good question to kick things off with Let's see quite a few questions of rolled into the communities What's here's a great broad question. What's the difference between a to-do list and planner? Practically or in terms of implementation or what it's targeting. Yes, I mean, I just think of tasks literally as a collection of tasks that I can check off and it's much like taking that piece of no paper writing things down scratching things through whereas planners a bit more involved with that and Has the ability to Do swim lanes and organize tasks and things more extensively? That's my thinking or at least that's the the containers. I put them in Once for a group and the other is for an individual that's kind of a little over the simplistic way of looking at it Yeah, that was gonna be my my basic things. Yeah, you're right I mean some of the it's probably confusing that they're they're also trying to make them Completely integrated so that can I go in if I have a planner plan a board and I have ten tasks and all ten of those tasks are assigned to me then they're Basically the same thing because in to-do I would see all of those ten tasks as soon as they're assigned to me But I guess to Tal's point five of those could be assigned to Sean and then they would not show up on my to-do list Or would they get done? And then they wouldn't get done That's that's kind of the age old project managers Problems like most project managers career PMs have a bit of that OCD ADHD going on I spent the first, you know a half of my career in project management related roles And so it's like it's not getting done while going and do it myself. I want it done right, you know Yeah Anyway, I thought that was a Good question, but yeah, I think that the it's gonna be the lines are getting blurred between the solutions The new list capability that's gonna be another one of these where people will start to ask that question Which tool do I use when do I use the planner tasks? Do I use planner? Do I use or do I use teams tasks that new app or the list app? Or planner or to-do Yes, yeah the answer is yes Yes Well, that's but what that's exciting about that if you think about that as a task That's assigned to you as a single object that's captured by the graph and it's picked up and that task is used in planner and in teams Uh, and eventually we'll see more of that kind of deeper integration with project and project online as well Uh, it's still a little bit of degree of separation. There's that DMZ between Microsoft project and project online with planner and tasks But uh, but I think they're going to see some deeper integration over the next couple years Um, but you've got that individual artifact that is uh, you know can be tracked and measured and then utilized by those different User experiences and that's what we're talking about where they've developed a new app Which is a new user experiencing? Leveraging that same data that lives in multiple places So what is the right? The the answer that where where do you go? Which tool do you use? and I guess the answer is you use the one that makes sense for you to use Yeah The one that fits the situation at hand. Yeah Definitely You guys find into any questions this past week? No, thanks. I found it out in the drug that I reported Uh, only one how? Well Yeah, for the last couple of days. Yeah, search search is broken Except that it's not broken in on anything but an outlook.com account Interesting. Yeah, it uh If you've got an office 365 account a pop account and iMap account search works fine office Outlook.com live.com Hotmail msn mail it comes back and says there was an issue. We think you're offline And uh, so collected a bunch of logs had a nice little chat with a couple of the engineers and Hopefully there'll be a fix for that coming out presently What was the announcement that that just was made this last week around search and and teams? Do you guys see that? I didn't know I don't think so While christian's looking for that along those same line of bugs one that's been bugging me quite literally for Seemingly the end the beginning of time is um I told you my wife and I keep a family calendar and share point online Uh, and we both synchronize that to our outlook clients on the desktop Well one thing that keeps happening And we have to keep going back and doing this again is once we connect the calendar to outlook It'll work for a while and then we start Getting permissions errors Um, and it stops synchronizing you can't send received tasks and so that linkage gets broken You have to basically drop the calendar for outlook go back into Office 365 or SharePoint online and open it up and outlook again Now I you know, I understand the permission situation. I know tokens and whatnot I actually in the interest of it may be being a A particular account issue. I added all of the accounts That I have email for into that SharePoint site and granted them the same rights on the calendar And I still run into this problem It still comes back with a An authentication issue it can't sign in and there's no amount of finagling I can do from the outlook side To repair this I have to go back in the SharePoint and it has to reestablish The link and outlook and then it runs fine for a while from indeterminate period of time and then it'll break again Uh, you ready one of the insider channels or one of the solar ones Uh, pardon me Is your outlook version an insider any and so one of the insider channels or in one of the general release channels um It I believe I've got both situations. I've I've tried this with the click to run install Both on insider not insider I've also launched. I believe what I've got installed right now is the client from the MSI that I download the heavy client And includes the all office professional and The installation doesn't seem to make a difference So I'll actually Well, though the one thing that I wanted to point out I don't know how many people are aware of this but if you've got The one of the insider versions of for that matter not only of this office outlook, but office there is a Contact support feature that actually goes back to the product group And uh, you can pop that thing up and it'll take screenshots. You can it'll send logs It does all kinds of stuff. This is what I just got to reporting this the the search bug that that I came up with Thanks for reminding me that That's not just for Mvps developers people that are Trying to write code or anything like that That's for anybody that's happens to be on that channel that If you've got it inside a channel build you've got that feature and Use it to report stuff. They they're happy to see that That's a good point. I'm glad happy about the bugs, but they're happy to see the people that think you're paying attention Yeah, well they stay in business. In fact this error message I just sent I put in the chat window Interestingly enough, this isn't the particular list. I'm talking about this is my And it's not reporting a permissions error Now for the people list because we synchronize people contacts. It's saying the server may not be reachable from your Oh, share point online isn't reachable I can go to that list right now. It's yeah, it's something something with a way outlook connects. I don't know if it's like old Com plumbing or something that just does not deal with Tokens properly. I don't know what but It's not at all resilient And I'm I'm sure there we're not I don't think we're alone in this problem. I'm sure somebody else has seen it before Now well There's always user voice to go chase And a lot of them show up over there for things like that and fortunately For all of us microsoft is starting to pay attention to user voice again Yeah, well there is the q&a site now. Yeah You can always go plop it out there I'm sure microsoft loves to see anytime. I make a post I've Indelibly scarred myself on bill bears memory After headers disappeared from share point online. I became that relentless hound. He couldn't kick away Bill I like quite a few of those Yeah, I know bill. I love you. You're a great guy. Thank you for tolerating me Thank you for uh, eventually coming and chris mcnulty too because chris was the other guy I started with on this and then I went to bill I called them out by name in various posts and channels and i'm like i'm sure they love that sort of attention I think my my three that I've flogged bill's number one Cashman number two mcnulty number three Nobody yeah, yeah Cashman's such a good natured guy about everything But you know, I've often described bill's gonna love this. I've described him to people They're like, what's he like? I'm like he is that troll in the furnace room That nobody really pays attention to he's always grumpy and he's responsible for feeding the fires And that's that's that's bill He always has that kind of underlying attitude It's a lovable guy, but he is funny You have to find a clip now. I just made me think of the classic film uh, Thumbtannic Oh, no Oh He said we we must make the ship go faster. It must be faster faster faster faster And then so they you know the the the engineers they call it down to the furnace rooms and they're like We get to work more Faster throwing the wood into the fire, you know I'll find that Hey A little bit of new of news of new news that came out, um about something that I think has caused it again the response of the witch tool when response Okay during the headlights Microsoft lists Wow, we have gotten a whole bunch of commentary and thoughts in various channels on that Sean Wooder lists I'm not going there. I'm not touching that one not with a 10 foot pole No, what so what's the comment commentary? What have you heard? uh It has produced a great deal of confusion Especially amongst people who have been longtime share point practitioners Like what do we use with this? What do we do with this list thing? What is it replaced? What's the intended use? So the use cases are certainly there and everybody else is like What does the kind of product and app roadmap collectively look like for everything going forward with this Is it going to deprecate or cause a sunset to some things? What should we be warning people we might need to get away from? I think there's uh There was a distinct Sense of worry In the community amongst our friends And I've yet to see a lot of really good guidance from Microsoft. So I think that's a good topic for conversation Yeah, if you think of the well, we just we talked about the Private channels and the concern when they started talking about private channels a couple of the year and a half Two year almost two years ago It was a while back before we we actually saw it go live um And it was the people who had all of that rich history of administration was with share point that That saw you know, we already had the wild west of groups creation and uh And trying to and that's you know an ongoing concern for some organizations and Locking down the provisioning process. And so I my first thought with the announcement of of list And microsoft doing the look at the beautiful shiny things that we're showing you and then all of the people think Wait a second What actually what just happened to my job? What do I have to go clean up? What's happening on the back end? What have you done to me? Right and so You know like like a lot of things I mean I had this we had this this conversation last week about project cortex and I've said oh look I'm not going to talk about the functionality of what it can and can't do until I can actually get my My hands on it like everybody else. I'm reading you know about it lists is not available yet So we we can't get our hands on it. We can't play with it So we we can't really have an opinion on it until we see that And run through some scenarios and then start really digging into What is happening on the back end what the management experience is like for this thing? But I think those those are good questions to ask What is this displace? essentially though it's they've packaged SharePoint lists and they've made it more accessible through other as a standalone offering it through teams And they've created a bunch of templates fad 40 anybody no So they've created a bunch of templates and I Look, this is one of those questions. I think you know I remember specifically Having a conversation with somebody. I think it was at SharePoint Saturday twin cities Where we said, you know, I wish I could just have this list and do other things with it and Wishes have come true. We get this this side up. I think it completely makes sense from a user experience But like you I'm just concerned about what's actually happening on the back end or what will happen what that'll look like Yeah, and it's a fair point to say be careful what you wish for But yeah, I think we'll see some more of that guidance, you know, microsoft to their credit. I don't want to Drub them too much. They have we heard that this was coming That is the mvp crew and they did a little bit of qa on it But you know some basic questions like, you know SharePoint app versus the lists app is there one I should be using over the other or are there particular You know scenarios that are best handled or envisioned through one and not the other I mean those sorts of things just basic sort of guidance. We could really use some help on Well, that was that Microsoft historically has done that, you know, the hey, let's put two overlapping 60 overlap Products out there with slightly different Go-to-market plans around them and let's see which one sticks which people gravitate toward and it may be that Hey, we're using the SharePoint app for our legacy Experiences and views into that data or sometimes where it's built out. It was SharePoint first And and now I'm you know, I just want to visualize that bring that over to an environment and where most people Most end users, they're really not going in thinking from a SharePoint standpoint. They're in this Graphical interface. They just want to be able to go and track some project information and pull a bunch of people into it And they don't need to know that just like most things in teams. It's SharePoint under the covers But they just want a more packaged more produced Solution for building out that list Yeah, this is actually now that you mentioned this is This is one of those scenarios where Microsoft is almost conducting an extended A B test Seeing what bakes out where users gravitate Kind of to winnow things down perhaps in the future. I don't know. I don't think that's their Stated purpose and I don't think that anybody was suggesting it, but it kind of works out that way Can I add my custom list my list app to my yammer community? Yeah I'll ask those guys. I'll ask uh, holstie Story there, you'll become a favorite customer number one. I'm sure Uh, let's see. What else what other questions what else has been out there? Um I like your t-shirt Oh, yeah, I've worn you've seen this before though Um, I don't think I pay too much attention to it. But uh, yeah, I like the the little I have sore on there in the middle of the signal I yeah, there's a there's a couple different versions of plays on this. This is the of course I remember what the original artwork was but uh, it was used famously by joy division as an album cover And uh, then you've got the little the Lord of the Rings version of it Yeah, I have my I bought those t-shirts Um, I it was one of those where I bought three shirts or four shirts I've got the um Uh, the giving tree beard as well You've seen that one. So it's the giving tree cover instead of handing the boy the little boy and and apple He's pouring them out. It's it's tree beard and he's pouring out entrot Water Yeah And it's a little hobbit. So he's got bigger feet. Oh boy um No, I I bought like my mordor fun run because you don't just walk to mordor all the way to mordor Nobody just walks into mordor. Yeah, it's a fun run. Yeah Um, but a couple of those were my first wash and they shrank like two sizes Oh, man, you had to give them to my skinny boys Where I'm his leg wraps Uh Yeah, that's the way I can put on that t-shirt and look completely ripped in an unflattering way Yeah, I've got some of those that just by virtue of time have come to be that size and those don't get worn anymore Yeah, oh and I like your shirt too classic The future is here Uh Nice yeah, my daughter's like what's that? Five and a quarter fox no more. It's a coaster, honey. Yeah I'm trying to remember the name of it. Uh, uh, you know, anyway, I don't give old storage devices, but Yeah, I we had it ran to that situation again We were looking for a couple movies this weekend and we couldn't find them on any streaming service And like we could pay for them on prime And and I said I said, you know, we own the dvds But we don't for the tv that's upstairs. There's no dgd player It's just you know, a tv hang smart tv hanging on the wall connected to wi-fi And they have to come downstairs where it's uncomfortable for a large group because there's only two comfy chairs for the xbox because xbox one and Down here in my my office, but that's the only place where you can watch movies off of dvd Nice there it is It's classics fargo and full money Yeah, I was gonna get raising arizona and she's like, had you gotten that yet? I'm like, no She's like, well don't because I found this dvd that's got three movies on it. I'm like, that's okay Hey, I did Brazil are you getting the split screen thing? I'm not I just ripped it and I haven't watched it yet. Are you saying that it's uh, it's doubled on the screen So like is there a setting dude? I did I do something like nope everything else plays Normal and there so it's uh, yeah, it's not watchable Okay, thanks for saying that I'll go back and take a look at that. I'm not sure what happened there Sorry, Hal. We're talking plex Sean's question That's happened occasionally with Do and until somebody points it out I if I haven't watched it. I really don't notice I think once One movie there was no sound. I'm like what happened here. I No clue Hey, here's a great question. This was posted over the microsoft teams Space on the the group on facebook says anyone with the solution my son has a new mac book air for school The camera works fine, but his microphone doesn't work and other apps his microphone works fine. Any suggestions? Hmm. Well, if the micro Yeah, uh replace the user. Yeah buy a pc or replace the user. Yeah That's good. Have cac air I just love that question is the general it mac related in a microsoft teams Yeah, that That is going wide with it. I guess Because first of all, you're gonna get in all likelihood.  Oh, here's the question So back another team's question is teams appropriate for interacting with customers outside your organization Inviting them as guests to the team. We have created teams for every customer with different projects as channels One problem seems to be that every customer has to create an office 365 account Which not everyone is willing to do I like to find the best way to communicate in one place with customers as an alternative to outlook That's a perfectly valid use of it and me you're not going to get around the Outlook account creation. That's a feature not a problem Well, there's one other problem that I identify here. It could be a problem But if you have a single team with each channel as a customer, it means that they can all see each other Unless they're private channels in which case you just sign yourself up for a lot of permissions nightmare management. So, yeah There's no, I think ideal easy solution to that. But yes teams can be the solution Just going to have to jump through certain hoops Yeah Uh-oh time to walk the dog Uh, they've been walked. Yeah, there's uh That by another son that stayed the weekend over here and has to go back to works this afternoon And so they're just excited to have More familiar faces around I'll bet Yeah, the uh, but I think that you're you're right. It's um It's one of those issues that uh people have complained about well, how hard, you know, some of the Office 365 Microsoft 365 products are to use and how easy some of these third party solutions are We've talked about week after week like Why we were using zoom for so long and You know that this morning was another reason why I was thinking Should we just go back and use zoom because it works the way we needed to work? But No, we're gonna stick through and I've got an answer Probably we're we're gonna move to the team's live tonight So, uh No live stream, but at least people can Join in anonymously and watch and ask questions and we can share out that link So i'll make that that shift when we're done here. Um, but the uh Um, you know what was I saying? Um The yeah, the the people complain about you that you know that how complex it is because Microsoft solutions are designed for the enterprise And so you you predominantly know who you're collaborating with they're more secure It's meant to retain information capture In teams the conversation as well as the content and do it all in a secure way so that you Are only sharing with people that you know that are confirmed And so you go to a lot of these other easier to collaborate solutions web based solutions, right? And they're less secure So it depends on what you need to go and do if you your enterprise your organization or company Need something that's secure that meets all of those Uh compliance regulatory Security requirements that your IT team has then teams is going to be able to meet that There are sometimes some little minor hoops to jump through to get people in there collaborating But it's it's going to be the best for you long term.  Yeah, there are two organizations I work with right now where their IT Excuse me their IT departments have specifically made zoom verboten. Nobody's allowed to use it and categorically It's not allowed for use within the organizations For the very same reasons you described. I mean obviously the feature set of zoom is intended to Be easier to access lower cost of energy and investment getting into it, but you pay for that with security potentially holes in the platform All sorts of things like that. So it's hard to have one and It's hard to have one set of benefits and the other set of benefits at the same time you got to kind of Determine where you really want to be in all of that And where your organization is or what the what your organization will require of you You know the new york times test if you know suddenly all this stuff ends up on the front page tomorrow Are you or is someone else in your organization going to get fired or worse as a result? something to think about Well, that's the you know, I I think it was uh john white who MVP who Kind of coined the phrase that you know no longer. Do you need to be the the IT department of no? You know the answer and you know know to everything one of the ideas of teams Was surfacing all of those third-party applications and other integrations It allows you if you instead of in an IT organization If you're able to go to your end users and say look we've provided these solutions We've provided SharePoint. We've provided teams We've provided these custom applications that we've built kind of all the things that you've done and yet they've still gone and paid for unsecure Non-compliant third-party services and tools and installed themselves or used a personal credit card and signed up for it And suddenly they're you know, they are sharing at a manager's meeting. Hey, I went you know IT wasn't responsive. They couldn't give us what we needed. So we went and we built this out Here's this company data that's out in this third party system And then there's the questions of well, how secure is it? You've got our intellectual property that's out on this other place You've invited people in that have not been vetted properly and don't have the clearance to access can all those issues And I don't want to sound like i'm overthinking that I think there there are that is more common than not Yeah scenarios where there are requirements. You're just you know Ambivalent to those requirements. You just want to get your work done But teams allows you to go in and for IT to say look add that third party service as a tab within this team um If you're gonna you're I get it You're you have these use cases. We weren't able to meet your needs Or is it just an education issues? Like did you know? That you're out there using Trello Like we have planner that's built in and it does almost everything And here you might have integrations. You might have other things, but we can give you 80 percent of what you're doing and it's free and it's secure and won't hassle you anymore Or help us understand. What are the scenarios? Can we go and customize? Can we do some things? So it it opens up that possibility to have those conversations with end users about how they're breaking the rules And instead of just shutting them down, it should be a conversation to understand Why why is it? Is it an education? Is it that we don't have the functionality? Is it that we've just You know if the functionality is there, but we it just haven't had the time to help you go and Build exactly what you need to configure what you need within the out-of-the-box experience. So What's compelling you to do that? Yeah, I same sort of situation I had back when I was doing dr work. It was those business critical access databases running on PCs under somebody's desks that were completely off it's radar Not backed up or anything. They're like, well, we can't do without this app. Okay. Well, it's not backed up It's completely unknown to it and if you can't do without it, what are you going to do when this pc crashes? You know those sorts of questions, uh, maybe they hadn't thought that far ahead but yeah What what is the solution not giving you that you need and how can we address that gap is the more productive conversation to have rather than circumventing it and Going enrolling your own it's an interesting you know thing when you culturally If your organization if people feel like they're shut down before and so they never asked those questions They never come to it and have that conversation like this is what we're thinking. This is what we need and let's have a conversation I mean, I I think we've all all three of us have sat in meetings where The dialogue just gets shut down. Well, that's not approved and you need to go through this if we have a process for that and Um, it's funny. I do that voice, but that's exactly what Yeah, uh, but it Instead of starting out and having that that open dialogue about what they're trying to accomplish and I've I've run enough, uh, you know change management teams and governance bodies at different companies and off You know project based and organization based And I've just found that what works better is where you just have that conversation and sometimes you as the it person have to recognize that you know, they have a need that we're not able to go and meet and um You then assess the risk of third-party solution I look at is like if you're going to go and use that third-party tool better that i'm aware that you're doing it and can Monitor that and if you're hit by a bus That I have access to get to that data that just shut it down to move it over whatever but um, but it's better that it be this this open dialogue then Yeah, shut it down because that's when people It's like people are like water running downhill and there's a place of rock. They just roll right around the rock.  Oh, sorry. Yeah, maybe they take a better job That's that the the more happy scenario, but I've literally been called in. I was doing some forensic work Uh for an organization that no joke their developer just died They died and they had all of The secrets in their head. They were not documented anywhere And so for the this organization had to forensically try and tease them out of I mean I had to reflect into compiled code to go looking for Because there for instance, there was a solution that was pulling data What somebody thought was from SharePoint. They're like we can't figure out which list this is where it's coming from I went in founded Found an embedded sequel connection with embedded credentials pointing to some other server that was on no one's radar And I'm like actually your data is coming from here And so they were able to finally get to that data, but that was not documented anywhere So, you know, this idea of somebody getting hit by a bus, you know, people literally do just drop dead on the job without documenting things data point one Can pull that up But yes, the happier scenario is they take a happier job or win the lottery and Are living off on a beach and they can laugh at you and your inability to get things done because they're gone But you know, that is the happier scenario I was just on here responding to um I provided a A semi-answer here. I need to add to it more, but it's kind of chuckling somebody was just asking um Three days ago How do I stream a team's public live event to youtube and facebook? Oh boy, uh, so, you know what I love about this. Let me just say that so I've And then there's some links here and I've watched all of these videos multiple times And uh, and just I'll just say how finicky And so how do you do this? It requires teams obs and then the the stream key to that other platform and you can use restream connect to restream and Uh, you basically toggle on multiple channels. So you could um capture You're like this teams event And live stream it to multiple locations like youtube and twitter via periscope and facebook live All at the same time The problem well, there's multiple problems um So what one problem if this is something that people are thinking about doing and and let me just preface this by saying that I don't have it figured out yet because of how finicky things are um, I've upgraded to the latest version of obs and uh, because you have to have a the virtual camera Um installed to be able to use because your camera Can only be used one for one thing one application So if you're trying to use obs And teams the camera's being trying to be used in two places. Can't do that. You have to set up a virtual camera So i've done all that i've gotten it to work And then with the upgrade For some reason even though I have my stream key everything is there It's like it's failing to connect to the server and you get totally helpful Feedback when you go search on like why is it not connecting to the server and people saying that It was largely a bandwidth issues like it's not a bandwidth issue for me It's like well, you need to refresh the stream key did that you need to restart obs Did that you need to restart windows? Did that you need to clear cache you need to do the blah all this stuff did all that Not connecting to server you need to make sure it's your firewall connections are clear that it recognized obs Oh, it's in the list. It's I've done that still not connecting the server. So when I say how finicky it is um If you can't tell a little bit of frustration I probably spent I was telling how I probably shut her Sean, you know like I probably spent another six seven hours this weekend Trying to get this stuff set up and figured out And part of the problem was the older version of obs wasn't recognizing like different things obs open broadcast systems like it's an open source solution It's constantly being tweaked Like I don't know what the thing what the deal is every other technology works And yet and I've streamed for years And and for some reason it's not able to connect with uh with the server so Maybe they're trying to You know, I I just think I need to take that that taper guidance and I need to simplify my requirements Why I think that this evening we're just going to for apac edition of this We're just going to do a teams live And share publicly Anybody can come join and watch the stream and ask questions Uh, but only the panelists will be able to be on screen and yeah That's the it's not ideal. It's not what I want. I want to live stream But if I can't and I don't have time to waste today to uh Try and make this work. So I'm going to spend zero time And we're just going to do teams live this evening. So anyways That was my whiny response long run out response to that innocently asked questions Yeah, they didn't realize what they were tapping into. Yeah, that's that just gonna get a go and unload on that person But in your defense, I know you've poured countless hours into this trying to get things to work and whatnot So you've definitely put in your time It's just there are certain factors in play and it's just not a Trivial to implement solution. No and everybody said the same thing too with obs. They said look you can you can use to run like a television station And have all your fades and cross fades and have multiple people and streamed in different locations Like it's wonderful what it can do and I've seen it working And but everybody said the same thing. It's a pain in the butt to set up Once it's set up It's a dream Yeah, your obs for me is ripping videos you can do it with handbrake, which is a totally free solution has hundreds of knobs and dials and settings to get all of those correct is A monumental effort or you can get a paid for solution like dvd fab which I use which I just Picked the output that I want and it does it. I don't have to spend those countless hours. My time is worth more than that So well, that's what you know, honestly, I was looking for I went and spent a little bit of time to find somebody um Just out through like fiber type things, you know to uh It's like who are experts that I could just pull in on video and walk me through And hey, you need to do this because you have to think about Each of those different scenes and sources You have to think about the video input and output different settings different screens You have to think about the audio components of each of those I've got these fancy monitors my extra wide and my standard large monitor over here both that have audio and You know input and output And so sometimes you forget you have to turn off the mics and speakers for my monitors You know, why am I getting that that echo because that's why how before we started recording here this morning I kept asking that because I was hearing it here Because it was it for some reason not using my primary mic was actually using the little tiny pin dot microphone hole in one of my two monitors Yeah Love that you got to become a technical producer Yep Oh, let's see another how about a one drive question Where's Hans when you need him? Yeah, exactly. And did we uh, did we freeze? Did we lose how? Either that or he's really good at That answers the question. There you go. We lost your video how in the process of losing how yeah So he might come back without his video because I know he's got a A lesser Network connection there. Yeah, I know he's a bandwidth constraint There he is again All right So how I was just about to ask a one drive question It's a backup question Sean Okay, that's a bit more of your background. So, uh rich asks says it's a newbie question So we'll be kind here I I like the idea of using one drive for off-site backup But I really do not need to backup every folder in my hard drive Is there a way to specify which folders to copy to one drive or conversely to specify which folders not to copy? well First we probably ought to ask I'm going to ask the rhetorical question at this point by backup you Really mean backup because if you're backing this up to one drive I would I would be kind of concerned about that but saying let's say that you've already recognized the limitations of that scenario um First of all, do you have enough storage? Are you talking about one drive for business where you've got the terabyte of storage and is that going to be enough to hold your data Or do you need something else if you're on consumer one drive? You're going to be limited to most people are like five or 25 gig right off the bat there um Assuming you've got your storage totally dealt with and you're okay with that um How are you getting this stuff out to one drive? Are you using the file sync client on your pc? And if so, you know, how is that? What's that situation look like? um And I noticed that one drive actually has a Backup function manage backup Yeah, something commented here. So daren hemming actually mentioned he says look you can make one drive the master not the backup So you actually the default storage location for depending on what you're doing yeah And uh, and so that that's that's one way But you know the other thing I was thinking is the the the files on demand And as a being able to go in and say well for these files Whether I want these pure cloud if I want them synced between the desktop or I want them local only only so you have the ability To go in through the the one drive sync client Uh and determine that Yeah, well, I mean so if if you're looking at a backup scenario from a pc to a cloud the files on demand is going to be less of an An option or a function there because if you're moving it through the sync client It has to start out on your local system. Anyway, right Um, so that's that's fine for files that are out in the cloud And then you do not want to have them with a footprint on your system So if you're talking if you're talking cold backup of old things that have been archived And I'm thinking, you know, like amazon glacier storage and things like that this You know files on demand would definitely be an option once you've actually got the stuff out there But moving from your local system, it's There are a lot of other questions. I would want to ask kind of the the 10 or 20 questions um And you know, maybe if if he hears this or sees this and can come out at some point and give us answers to That sort of stuff or at least elaborate on it because You know the requirements and the scenario Unfortunately like share point It all depends and there are different scenarios and different strengths and weaknesses for Different approaches to it that will make sense given your situation or not make sense You know, and I was thinking this just the scenario of uh, you know an individual user It's not the traditional backup. So I'm not looking at, you know, in a system or a The way that we look at it from a share point stand standpoint for example But as an end user with desktop folders and I want those folders to be You know back maybe my maybe I'm you know my my images My pictures folder and I want that You know just kept in sync and that's something that you know the You know files on demand would do really well specifically for that you could say well, hey look I've got all the stuff that's local But the specifically I want synced between so that they're both locations or cloud only But I think to your point it depends on that there's a lot of room for interpretation around What you mean by backup Yeah, what you're trying to back up. What's in those two or three folders? Yeah, so one drive for business If you use the backup functionality manage backups, it looks like it Has the option of going against your desktop Your documents folder by documents and pictures um, you would want to Obviously if you're using that backup functionality locate the things you care about Um in those locations Which this is the whole you know for people who have been using PCs forever This idea of my pictures my documents and whatnot many of us actively fight against that You know, I have a sim a simple You know, I've got a single drive for my system And then all of my data goes on a data drive. I've got other drives for other purposes That doesn't necessarily align with my my documents my pictures um So, you know, if you adhere to the Microsoft's newer way of doing things and putting files in the places that the system expects to find them It looks like this would be more valuable to you than somebody who comes from an old school I want just I want to locate files In wherever location I want to put them in we're on a different drive And deal with it that way All right, uh, you know, we're just about out of time one quick question though, um Is there a way to have outlook give a warning when attaching attachments with pii? Personally identifiable information dlp rules um, and those typically come from the exchange server um administered by your admin so if you've got a dlp program as part of Your office subscription or you're in office 365 These rules can be set up to either actively Block the transmission They can be set up to just warn somebody and give them the option There are different ways to configure the digit when I say dlp I mean digital loss prevention if you're not familiar with that get familiar with those rules um And those can be implemented pushed to the outlook system Of issue or all users some users whatever And they will take effect and thus, you know, there are different patterns that can be searched for one of those is pii personally identifiable information things like Social security numbers and drivers licenses and whatnot There's another one for accounts like bank accounts or credit card accounts There are a whole bunch of predefined rules that can be implied put in place You can implement some of those any of those or create your own Provided your Good at creating patterns things like regular expressions. You can have those built out And your documents will be searched by the rules prior to being sent and if and if it trips any of these rules and there's a You know, the rule is defined to to warn you or to block it that action will take effect So yeah, dlp is the system that's designed to do that And that's what you would do In that situation to make sure you block those documents from going out Awesome Well gents, I know we're slightly over here on the time but Really appreciate your your help and I look for the modified calendar invite for the Teams live for this evening Will do All right. See you guys later. Take it easy Bye


Hi everyone, I'm Joe for jaspyscasebreaks.com. We're coming at you with a two-box break of 2021 upper deck SP game used golf random box break number nine. There would be a randomizer But Danny actually got both boxes. So big thanks to him appreciate it so Don't have to do a randomizer saves me a little a little time right there Here's two boxes right over here, and I just post if you're watching live I just posted the fight the last two boxes. I don't think we have any more golf And I don't think we have any more SP gaming's golf after that Thanks everyone For knocking all of these out So hopefully we can find some big names in here Maybe some big names that are that are leading the us open who's leading the us open right now We've got it on the background here We've got a an r henley a russell henley is uh tied with Richard bland Us hoisin wolf bubble watson Is in the top five right now john romkepka shifely so on and so forth Pretty fun golf action happening. All right, let's see what kind of action we have here and use to use this Blank card right there to hide some of the hits We got rookies calling more kawa That's pretty nice. He's pretty good Where is he he's uh tired for he's even Tied for 14 Just day two nice rookie card And we got justin soup a couple relics and then an autograph. We've got danie willett tour gear A couple pieces of his shirt and we've got a maverick mcneely Back nine fabrics. Let's see the autograph is going to be Is going to be nice tony finnell 247 out of 299 First tee rookies jersey and autograph Fina was pretty solid But how's he doing it? How's he doing here? At the u.s. Open Tony finnell is six over Well, not not a good u.s. Open for him and the second and final box For danie. Good luck, danie. So mickelson Birdie's there too over for him. All right. We got da points and a rookie card adam long rookie card We've got a triple relic here We got danielle kane lexie tomson and stacey lewis I think lexie tomson a few pieces of their shirts Was up in the u.s. Open a lot. I think I've been reading some articles about how like She was up by a lot on the final day and then just choked She'll she'll get them next time. All right Here we got oh wow Front nine dual swatch combos A couple pieces of tiger shirt A couple people the pieces of jack nicholas's shirt That's pretty cool 11 out of 25 That's a good pairing right there That has been certified blah blah to had to be having worn by the Featured players. I'm not sure if it's match worn, but Very cool. Uh, and the Final one is more first tier rookies It's maverick mcneely 172 out of 4.99 First tee rookies jersey and autograph A little bit of dust on there Danny, thank you very much for uh for getting into A lot of these recent golf boxes. Hopefully we've been sending you some really nice stuff. The fina was nice And now it's got something that's stuck in there too. Let's give tony fino That's a cleaner toddler. There we go. Nice and the morikawa rookie card too Danny, thank you very much. Enjoy the golf this weekend And uh, and thanks for watching jaspy's casewrakes.com. See you next time


I've given these these exact talks on inequality and on morality of capitalism several times. People in the audience, there were a lot of small or big L libertarians in the audience, who knows what the connections are, but it's there. He talks about morality. He talks about the fact that the economic case is unequivocal, but the real attack on capitalism is a moral attack, and then we need a moral defense of capitalism.


Hello everyone and welcome back to another tutorial. In this video, we're going to be showing you how to properly use the index plus match function combination. The main reason or benefit for using index match is it gives us more flexibility than using VLOOKUP on its own. So the problem you have with VLOOKUP is you always need to make sure that your lookup value is in the far left hand column of your data set so that you can return only values that appear to the right of it. In our example, as you'll see, we want to return values that appear to the left and the right of our search or lookup value. So in our example, we've got some simple data on the left hand side here. We've got the region, the city and the revenue and profit for each of those cities and on the right hand side you can see we've got our city and this is going to be our lookup value. So at the moment we're set to Cambridge and we want to return the revenue and or the region and the revenue for that given city. So to get started, we'll quickly look at index to show you how that works. So index how it works is all we do well the easiest way is to sometimes just jump into it. So if you go index, open brackets and you can see there's quite a lot of arguments we can provide for this function, but only for starters only focus on that top row and we'll just jump through what each bit means. So the first part is the array and when we work with index, index is allowing us to actually do the return aspect of our desired function. So we are able to enter an array or an arrange of which contains a number of values and we can then provide a number for the row and a number for the column which will locate where our desired value is and it index will then return that value to us. So when we want to come to entering it in here, all we need to do if we want to return a single value is select the column it's the whole column and then we can go comma and let's enter the row number and we'll go for the number of two. So at the moment you can see we've got our array which is this column B and we want to return the row number two. So basically position number two from that range that we've provided. You can see that column number is surrounded with the boxed brackets and that means it's an optional function or an optional entry. So we don't need to provide that detail, but we'll come on to that in a second. So having populated as we've done, we can close brackets and enter and you can see we get the value of Great Britain return to us. And the reason we get that is because Great Britain is in the second row of our array that you can see highlighted here on the left-hand side. If I was to change to number two to the number of five then what will happen is our index will now return to us the value that appears in row number five of our array and you can see that is now North America. If we were to go back into our function as we mentioned and you can see we now got the column number. Let's put a column number having put the comma in there of the number two. So we're saying we want to look up in our array. We want to return the value that's in row number five and the value which is obviously in column number two. So this is kind of like giving our function the coordinates as you would for a map. So you've got the longitude and the latitude. So we want row number five and column number two. And when we hit enter on this, you can see by initially we'll get an error. And the reason for that is because at the moment in our array, we've only provided a single column of data. And when we want to then go into a second column, so we're trying to jump across here to city, it won't do it because we're moving out of our provided array. To get around that, all we need to do is just ensure that our array is extended out like so. So it now covers all the rows that we need and the two columns that we need. And when we hit enter, you can see that our value of New York is returned. And just to visualize that, what's happening is in our array, it's coming down to the fifth position. So we've got one, two, three, four, five, which is North America. And the region is the first column within our array and city is the second. So it's going to go to the second column and that's how we then get the value of New York returned. So that's how the index function is working for us. So the key facts to remember there is if you want just one column or you're only looking in one column, all you need to do is just select the array of a single column and the row number to return from it. If you want to return a value that could sit in multiple columns, then all you need to do is ensure that the column number that you provide is the same as the array that you've provided or that the array extends the number of columns from which you wish to return. So that's the first part and that's how we return a value. So as you can see, we need to input integers or numbers into this index function to better tell us to where to return information from. And in order to populate those numbers, because we don't want to be putting five and two in here, we want it to be done dynamically, but this is where we're going to use the match function. So just to clear that formula, let's look at how the match function works. So the first thing we'll do is to equals match. This is how we get into the match formula. And this works by the VLOOKUP aspect of what we're looking to do is it allows us to provide a value we wish to search for, an array in which to look for it and match will then return to us the position of that array the value sits. So we want to look for Cambridge. So we can select Cambridge from just above here. We'll go comma and then we're going to our lookup array section. So for us, it's going to be city. So we just need to select all of the values in the city for our lookup array and then do comma. And this time, we're going to be putting a zero in match type because that will make sure we get an exact match on our lookup value. So this is exactly the same as you would use in the VLOOKUP function. Obviously, with VLOOKUP, you'd commonly use the word false to get an exact match. But it's just doing exactly the same thing. Once we've done that, we can close our brackets, hit enter, and you can see we get the number three. So what that's telling us is our lookup value of Cambridge is in the third row or third position of our provided array. And we can see that is the case when we look at it over here. So match is now giving us that number we need to combine with index to return our desired value. So let's just clear this down and put in the two functions together, how they should work. So the first part we want to do is we want to do index and our index function starts by saying, right, we want to return a value from this column, so from the region. We now move on to the row number. So we now need to use match to say, what row from this range do we wish to return? So for us, we're going to do match, open brackets, we'll enter the lookup value of Cambridge and the lookup array for Cambridge is city. And the key point to remember at this point here is we need to ensure that our index array and our match array are the same in that they start and end in the same rows. Else if they're distorted, then the problem you're going to have is the values aren't going to coordinate with the right value. So we just need to make sure that these two ranges are corresponding in their start and end positions. So we've entered our match array or lookup array to a comma enter our zero to get the exact match. We'll do a close brackets to close or finish the match formula and one more to finish the index. Now when we enter, we can see we get the value of Great Britain return to us, which is obviously correct for example here. And if we now go and change this to say New York, we can see how our region is now populated or updated to show the correct region of North America. So this is how we're able to do use index match to return a value from the left of our lookup value, which again is something that we cannot do using the V lookup. So we now want to return the revenue. So this is going to be very much the same especially for the match part, but we're just going to be indexing data from a different row. So we'll enter this formula combination once again. So we'll enter index and this time our array is going to be the revenue column because we want to return revenue rather than region. Do comma. The row number is going to be exactly the same. It's going to be our match same match function. So we want to take the city and find out what row the city that we're looking for sits in. So we've set entered our lookup array there. Our match type is zero to get an exact match close to end the match and one more close to end index. And you can see we're now got the revenue of 98 or 9,805. And we can see for New York, if we go over here, we can see that's correct. So we've got the North America region, New York, and the revenue is 9,805. So that is how we can use again index match to get a different value this time from the right side of our lookup value. So to take this one step further before we finish and we're going to make it a bit more advanced is how can we also now have the ability to flick between revenue and profit? So as you see, we've got the revenue at the moment. But what if we wanted to bring profit in and have the ability to flick between the two as we so desire? The first thing we want to do is just quickly do a bit of data validation on revenue so that we can have that the drop down to have the select between the two. So we just needed to select a list, select our input values of revenue and profit and then go back. And now you can see we've now got our drop down available for us of revenue and profit. And at the moment, that's nothing's going to update our data here because our index is currently fixed on that revenue column. So we need to make a slight update to this front or this formula here, specifically the the index part. As you remember at the start, when we are working with or introducing you to index, we entered a second column and initially we got that error message. And we had to extend our index array to cover more than one column. And that's simply what we need to do here is we just need to make sure that this array of index of D6 to D7 is extended over the column E so that we can now source information that's stored in a separate column. So we make that change there. And then the next addition we do is we just get rid of one of these brackets in here. So we can now go into the column number by entering hitting comma. And to get the column number, all we now need to do is we need to do another match function to identify to us which column we should be extracting from. So revenue being the first and the profit being the second. So we just do equals match, open our brackets. And this time we're going to be looking at our drop down here. So we can see what value is because obviously if it's revenue, it's going to give us it's going to say it's position number one or column number one. And if it's profit, it will say it's number two. And it's that number that allow us to then jump between the revenue and the profit column. So having selected that, we then need to select our lookup array, which is those two values there. All the column headers, so we say. Another zero just to make sure we get an exact match. Let's close brackets on the match and close brackets on the index and hit enter. And at the moment, it looks like nothing's changed. But now with our drop down, we can select profit. And you see our former is going to update and say, okay, well actually we should be extracting from the second column for profit. And we're getting the value of three, nine, two, two. And just to visualize that, we can see New York here in row 10. We know it's in North America. The revenue is 9805. So let's go to revenue. Yet 9805. And then for profit, we're getting three, nine, two, two, which we can match here and confirm that the formula is correct. So this is a more advanced and even more dynamic way of using multiple match formulas with index to give a real dynamic lookup for us. So we hope you enjoyed that video. If you did, please do give the video a great big thumbs up. It's not only appreciated by us because we can then see the more content that you'd like to see more of, but it also really does help the channel in terms of the YouTube algorithm. So please do smash that like button if you haven't done already. And as always, if you haven't subscribed to the channel, please hit that subscribe button. Make sure you hit that bell notification button as well so you're notified of all of our future videos that come out onto the channel. So thank you very much for watching and we shall see you in the next video. Before we go, don't forget to check out the other videos on our channel. You'll see everything from other functions and formulas through to tips and tricks. We've also created some playlists so you can see these categorized together. So make sure you check those out and get all those useful information. And obviously as always, don't forget to subscribe and hit that bell notification button.


Thanks, Eric. And hello, everyone. It's a real pleasure to be here. And as a scientist with a relatively intact short-term memory, the last 30 years has been really amazing to watch what's happened in the world of genomics. And from my perspective as a paleontologist interested in the evolution of all life on this planet, it's been pretty cool to think about what the potential for this is moving forward. As a museum director, I think also of collections that will be generated, and I think of the public that will be served. And museums are interesting places where the public actually interfaces with science in a pleasant brushing sort of way. I mean, most people go to museums once or twice a year, yet the impact, it can be felt in a lifelong way. Lots of scientists, when you talk to them, say, well, how did you get interested in science? And they'll say, well, you know, I went to museum X and saw object B, and then I knew right then I was going to do something in the world of science. So what we do is we catalyze curiosity. We inspire people. It might be a mistake to call it an educational experience. It's more of a life-changing experience. But we do that well at museums. We've done it well for the last 100 years. And one of the things that's interesting for museums is how do museums respond to the rapidly changing world of science in the 21st century? We have a plan with incredible challenges. And how do we as museums get on board with that? And one of the cool things that the leadership at the National Museum of Natural History did before I got there was realize that in Washington, D.C., there are amazing scientific organizations like NIH and many others that are doing incredible groundbreaking research that are not that far away from the mall, as Eric said. So that launched this idea of doing an exhibit on the human genome at the National Museum of Natural History. It opened in June 14th on the mall. It's called Genome, Unlocking Life's Code. And what's interesting about it is that probably most of the people that walk into the building won't know what the word genome means when they walk into the building. Ideally, they will when they walk out of the building. And it's an interesting challenge for us because as you know, the rate of change in science is so fast that it's leaving a lot of people behind. The rate of scientific literacy is not keeping pace with the rate of scientific advancement. So it's places like this where we will introduce people to concepts and inspire them. But we want to trigger their curiosity. This is not going to be a lecture on a wall. It's not a classroom. It's an experience. If you go to a museum and watch what people are doing, it's usually families with children. They're on a social outing. They're going there because they know that it's really interesting. And they think it might be good for them. That's the general premise. I really want to thank Eric Green who really did come up with the idea for this and drove the partnership. And I think it's an inspired thing because partnerships between organizations that create knowledge and organizations that distribute knowledge are really important as we think about the next part of the century where we've got a lot of very interesting complex challenges that probably have scientific, engineering, technical solutions. If we can figure out the politics and the social activities that stitch this stuff all together. We also were very lucky to receive funding from Life Technologies Corporation. It's CEO Greg Lucere who gave us on the order of $4.6 million to fund this exhibit. And that's one of the tricky things about partnerships is there's lots of good ideas. We have great venues but you need to bring the resources to the table to present the actual exhibit to the public. So that's kind of the framework of how this exhibit came to be. I want to take a few moments and explain to you a little bit about what's going on genomically at the Smithsonian Institution because we're a large institution and as I learned applying for the job last year far more complicated than most people realize as are most things in Washington, DC. The Smithsonian Institution founded in 1846 based on a bequest by a British fellow who never actually came to the States. He just wanted to increase and diffuse knowledge. Presently consists of 19 museums, nine research institutes, and a national zoo. Many of these buildings are on the mall but not all the museums on the mall are the Smithsonian which is always confusing to people as well. But when you look at, you think Smithsonian, most people think the big museum mall experience in Washington, DC. And it is a big museum mall experience. More than 30,000, sorry, 30 million people a year visit the mall museums in Washington, DC. And most of those people are visiting once in their life or maybe for the first time in their life. So that number 30 million repeats and is unique every year which is pretty amazing to think about the number of people that actually have a museum experience on the mall in Washington, DC. It's the great eighth grade American experience. And we see it in spades in Washington, DC, and the mall in March during spring break. And if you think about that, this is the place where eighth graders come. And if we can trigger that moment of curiosity when they come, when they're in eighth grade, then we turn them over to you guys. That's the game plan. Now, the Smithsonian is far broader than the mall. It exists all over the world. We have research stations everywhere and we've created a number of interesting coalitions and organizations where we're working together. Here's just one example. The Smithsonian Institution Forest Earth Observatory. This started with our group in Panama. We have a number of major units that are far flung, but one is the Smithsonian Tropical Research Institute in Panama where after the formation of the Panama Canal, we decided it would be good to do some science on the tropics in Panama. And in Panama, we established a 50-hectare plot in a diverse tropical rainforest and mapped every single tree on the plot to watch those trees grow. And you say, well, why do you have to watch trees grow? Well, in the tropics where the seasons aren't well expressed, trees don't make annual growth rings. There's no seasonality that makes the rings. So it's very difficult. The tropics actually know how old a tree is when you cut it down. You cut a tree down in Bethesda. You can count the rings. See, that tree is 67 years old. You cut a tree down in Panama and it looks like butter. There's no growth rings. So the biodiversity of the planet, highly concentrated in the tropics, yeah, we don't know very much about forest dynamics in the tropics. So the Smithsonian set up this plot to watch trees grow. This has now grown to 47 plots in 21 countries and 74 partners. On those plots are 4.5 million trees. And something like 60% of the generic tree diversity of the planet. So on our plots now, we have a pretty good watched sample of the diversity of trees on the planet. We've recently started a similar program with the marine world with the thing called Tenenbaum Marine Observatories where we're putting out plots in the world's oceans to take repeated observations of the health of the oceans. Now in both cases, we started out doing these things using the basic taxonomic science of descriptive morphology that traditionally characterizes museum science. We rapidly have come to realize that genetics and genomics are the way forward to really understand the biodiversity of the planet. Which brings us to the National Museum of Natural History, which is the world's largest natural history museum, but only 10% of the Smithsonian Institution. This is the museum where I am, it's on the mall. It is by far the most visited natural history museum in the world. We get 7.5 million visitors per year. The next closest has 5 million visitors per year. Now what does 7.4 million visitors a year mean? It means that on the last week of March that just passed, we had 380,000 people in the building. Now that's a number that most museums in this country cannot equal on an annualized basis. We do it in a week in March. So we have a lot of people flowing through that space, they're going to see this exhibit and have their first experience of the word genome and maybe get their curiosity catalyzed and think about what the potential is for them in their future. What most people don't realize about museums is that they're not just places that have exhibits about stuff. They're also places that do things. They do scientific research and create new knowledge. They're also places that house the treasured artifacts, objects and scientific data of our culture. Without museums we wouldn't have dinosaurs. Without museums we probably won't have the long term preservation of the biologic tissues that form the basis for much biologic research. So at this museum we have on staff somewhere around 200 scientists, but a scientific community that's far larger because many scientists from around the world come to Washington D.C. to study the collections that we house. We have by far and away the world's largest natural history collections. 127 million objects, hard to conceive. I don't like numbers, I really look at it in terms of volume, but they're vast collections. Those things, the science and the collections are behind the scenes. Most people who come to the museum don't realize that we have science and we have many things. So one of the great potentials for this museum is to shine light on the back of the house. From my perspective the back of the house isn't just what we do at the Natural History Museum or what we do at the Smithsonian, it's what we do with science writ large in the world. And the NIH is a great example of that just up the red line from D.C. Here's an example of where our collections come from, the collections that we house at the National Museum. You can see they come from everywhere collections. We have seven major kinds of collections. And the interesting thing about them all is that, well, at first blush and it all seemed to you to be relevant to genetic and genomic study, I would submit that they all are. For instance, they're anthropological collections, vast collections of ethnology. These collections are, in many cases, made of biologic materials, those materials trace the cultural pathways of the people that built those materials and analyzed the materials and learned about what happened there. We have a parallel project called Recovering Voices which is actually trying to use our material culture to save languages. There's 6,000 languages spoken in the world today. By the end of this century, mostly those will be extinct. And we're working on ways to save and preserve those languages through the use of the material culture. We have vast collections of plants preserved primarily as dry herbarium sheets. And the plant diversity of the plant is staggering. There's somewhere in the vicinity of 400,000 species of plants, we have over 100,000 type specimens of this museum, the original descriptors of these plants. If you want to think about looking at the biodiversity of plants, the genetics of plants, where would you go? You go and look at the actual genetic information that are stored on shelves here in the museum. And of course, with museum collection data that are classified or pickled or stored. We understand that, but realize that it's still there in part. And the study of antique and ancient DNA is a burgeoning and interesting field where we can actually access data from museum collections. We have vast collections of insects. We have vast collections of fossils. And again, you think what are fossils for genetic research, but just think about it, there is a lot of research that has improved. We're all interested to see how far back in time we can take the understanding of DNA and the genetic relationships of organisms. And of course, the genetics of living organisms helps us understand the real history of life, which is manifestly expressed in the fossil record. Minerals, how do minerals have anything to do at all with life on this earth? And it turns out in the last 30 years, there has been a lot of change in civilization and life. And much of what happens in the deep bowels of the planet, the exobiology of this planet is close related to the mineralogy of this planet. Of course, our invertebrate collections, again, dry and pickled collections are vertebrate collections, which are vast. If you think about it, this building on the mall and associated facilities in Maryland called the Encyclopedia of Life. It was a big coalition, the secretary at his house, the museum. The goal here was based on a dream by E.O. Wilson, which was to have a website that had its page for every species on the planet. And when I interviewed for the job, I thought, that's an absurdly ambitious project that will never happen. They said, well, we've already got to 1.1 out of 1.9 million pages already on the website. So they're well on their way. It's just the big idea. You can get to the big idea. And finally, today at the museum have opened our laboratories of analytical biology. It's a 12,000 square foot new genetic next gen sequencing lab in the museum. We have satellite facilities in the National Zoo and in Panama and in Maryland to attack the problem of the genomics of the biodiversity of life. We have a large cryorepository at the facility in Suitland, Maryland, where we are preserving in perpetuity with museum archival skills, the tissues that underpin the study of the biodiversity of life. If you think about this, if you just have a tissue, you can look at the genomics of that tissue. But unless you know the organism from which that tissue came, the downstream use of that knowledge becomes challenging. And with humans, it's not a problem.  It's no big deal. But when you're talking about 1.9 million species of the planet's diversity, it becomes a real challenge to connect the phenotype with the genotype. And that's what underpins our global genome initiative. So all this to say that we're delighted with the partnership with NIH. Great thanks to Eric Green and Vince Bonham, Francis Cullen, for their support of it. I think it's an innovative new partnership between a major scientific agency and a major public museum. And we're delighted to be part of it. Thanks very much. Thank you, Kirk. And I should point out a couple things about the exhibition. First of all, this would not, Kirk mentioned the fact that life technologies was generous to jumpstart the fundraising for this. This exhibition would never have been possible had it not been from our great partnership with the foundation for NIH, who's been instrumental in raising funds and to be able to do this. And it had involved many, many donations from other major donors. The other thing for those who are interested in coming and visiting the exhibition when it opens in mid-June, it's really easy to remember for especially human geneticists in the audience. It's Hall 23, which is the same number of the pairs of human chromosomes. That's easy to remember. If you're not a human geneticist, just go to the Hope Diamond, which is visited by over 4 million people annually, and take a left. And then you'll come right into our exhibition. So we look forward to seeing you there. It will be resident at the National Museum of Natural History for about 14 months and then starting after that, it will tour North America for about four to five years. So with that as a feel-good story, we're going to now turn our attention to the scientific part of this today's event, and we're going to have now a series of disfabulous talk by just terrific genomic scientists. And this will be started off by Sarah Tishkoff, who's going to talk about African integrative genomics implications for human origins and disease.


I'm Marsha Joyner and we are navigating the journey. Navigating the journey is dedicated to exploring the options and choices for the end of life care. And to assist people to talk about their wishes, it's time to transform our culture so we shift from not talking about dying to talking about it. It's time to share the way we want to live our lives at the end of our lives. And it's time to communicate about what kind of care we want and don't want for ourselves. We believe that the place for this to begin is not in the Intensive Care Unit. But together we can explore the various paths to life's ending. Together we can make the difficult conversations easier. Together we can make sure that our own wishes and those of our loved ones are expressed and respected. So if you're ready to join us, we ask, navigate the journey. As you know, we have invited members of various religions and traditions to talk about the end of life customs in their culture. So much of what we think comes from our family narrative, our stories, our history. So much is lost when we do not pass our family stories. Here today when everyone has a smartphone and people talk in 140 characters, today's guest is one of my favorite writers of history. Tom is recipient of the Hawaii Award for Literature, three times recipient for the Hawaii Publishers Award for Best Nonfiction. And he has been recognized for excellence in research, writing, reporting, and filmmaking and continues to make contributions in his field of interest, which is Hawaii and Pacific History issues. Our guest, my dear friend Tom Kauffman, Aloha Tom. I am so glad that you're here. This is a real pleasure. And for our audience, you can see that when Tom becomes real worldwide, my library becomes worth a million dollars because I have everything, I think, I think, I think. This one, well, let's talk about first the first battle. Tell me about that because this is such a part of our history here in Hawaii. In fact, everything here is a part of our history in Hawaii. Tell me about this one. Well, that one-hour PBS documentary film was about the network of people, the relatively small network of people who got together before World War II out of concern for what a war between Japan and the United States would mean to our community. And they gradually formulated the two goals, basically, maximum involvement of Hawaii's people in a war effort as American citizens and minimizing or altogether warding off mass internment. And so the film is about them and about how that played out during the war, the power of having a, the power of relationships, I think, the power of interracial relationships, and the power of having a preconceived plan for what you might do in crisis. And for everybody, is this on YouTube? I don't know that it is. But you can download it from Amazon. And if you do, there's a prize, my own special prize, if you can find me in the film. No, we're not telling who it is, but if you can find me, trust me, there's a prize. This one, this one is the most beautiful film that I have seen. And as you can tell, it's on this old, what is this called? VHS. VHS. The VHS format. VHS. And PBS runs it, or used to run it, every year on Earth Day. And I think you should update it and air it again, because this was done before we were talking about global warming and climate change. And tell us the title, because I love that story. Okay. The title came from a Hawaiian chant, which I can't recite the words of the chant anymore, but it was, may the heavens live, may the waters live. May the heavens continue to live. May the earth continue to live. May the rain continue to dampen the earth. And may the verdant forest grow and continue to grow and flourish. Thank you. It's such a beautiful piece, and it should be done over and over again. We need to be reminded. So much of this, what I remember about it, we can't even find any more, houses everywhere. The, it's trying, it attempted to revive the link with the forest, and particularly revive the link with the native forest, the native Hawaiian forest, which is very different from the introduced forest. And to, in the process I went, you know, island by island by island, many times, I think we had something like 20 inter-island film expeditions, but on the tops of the mountains of each island is a native forest that is entirely different from what we think of as the forest we see when we drive over the poly. And it is, some of them are 10,000 years old, for example. They function much more efficiently in terms of catching and saving water and helping the water seep down into the aquifer, because they have a complex overstory and an understory and all the ferns and lichens that are down there, which help us, in essence, save water. Much in contrast to a lot of the giant overstory type trees we see now as we're driving around, such as Albezia, for example. Oh dear. Yeah. Well, let's keep going here. Ah, Arirang. I have played this, well I used to, but we don't have the machine anymore, over and over and over till I knew the words. Arirang. Arirang. Arirang. Arirang. Arirang. So this is about the Koreans and their immigration into Hawaii. Into Hawaii. Yeah. And then more broadly into the United States, yeah. So there's two hours, and it was occasioned by the collection of Korean American scholars around the Korean study center at UH, and they began working on this back when in the late 1990s, and they invited me in, and I was sort of the privileged, I was very privileged to do it, but I, it was kind of an inside thing in the sense that we all knew one another, we all had a very high degree of trust, and could ambitiously develop the immense amount of work that went into this. Oh, it shows. Yeah, I mean it was, and here was the thing, Hawaii is the place where Korean America began, and Hawaii has a unique history of involvement with the future of Korean America and also with preserving the nation of Korea during the long period when it was colonized by Imperial Japan. So Hawaii has this very important history, and that was our initial focus. As we worked, we said we cannot ignore the second wave migration in essence, the post-1965 migration to the continental United States, also to Hawaii, but to over two million people in the United States, and all of the achievements and also pain and suffering and what was it? This one, this is, well I think you have to start here before we get to here, so tell us about this one. You want me to go a little faster, I can tell. That's deep history, okay just let's read the subtitle, on Hawaiian, of Hawaii, okay, of Hawaii, from settlement to kingdom. So it begins with the first settlers and takes it all the way up to Kamehameha's kingdom. This one, and somewhere in here, there it is, nation within. Now let's talk about nation within. The next week, July 4, we are going to do a reenactment of the day that the provisional government declares itself the Republic of Hawaii and what it does to the Hawaiian people. Tom has helped immensely with the research, and if it wasn't for Tom I couldn't have written the script, so this book, the amount of research that you have in the book as well as the film, talk about nation within. It was inspired by my research and work with John Dominus Holt, the Hawaiian writer, scholar, and he had basically rediscovered the queen and the overthrow, and he said what we don't know about is what happened between the overthrow of the monarchy and the United States takeover of Hawaii over five years later, and that was sort of a black hole of Hawaii's history. And I believed, I knew enough about it to know that it was enormously important and virtually unknown history, and so it was basically dig and dig and dig. What amazed me about it is the fact that the provisional government in all of their Skull Duggery kept incredible research and papers, they kept everything. All of their dirty work. All their dirty laundry is very carefully organized in the archives of Hawaii. And the fact that they used the state of Mississippi Constitution of 1891 to create their own Constitution. The most notorious document for creating Jim Crow black-white racial segregation was the template for the organization of the so-called Republic of Hawaii. Yeah, where you could, the only people with good votes. And it's all in the archives. They wrote it all. A 22-page memorandum from Lauren Thurston, describing how that adaptation should be made. And where they said that you have to be Anglo-Saxon or of the Teutonic descendants in order to vote. That's it. And then the whole thing is written in English so the Hawaiians can't read it.  Yeah. But we do invite you to come out on the 4th of July at 9.30 a.m. at the palace where we get to relive that. Now, let's come up today to catch a wave. I want you to see my dog-eared.  Everything that we know about the Democratic Party is there, warts and all. And this is what a nice clean cover looks like. But if you don't have, if you haven't read it, you should. Because this brings you up to date from the 50s up to the 70s, I guess, that part of- Instead of the early statehood and the collision of John A. Burns and Tom Gil primarily, but it's Democratic Party and early statehood history and woven around the clash between these two large figures. What I noticed is that you talk about the 1970 election and the issues, that election, are the same as they are today. Have we not progressed? I mean, they talk about the traffic, the lack of housing, people going without. The whole, all of these issues, the only thing different is that we have a rail. But if you read this and didn't know that you were talking about 1970 election, you would think it's the election coming up because these same issues will be there. How much time do we have? We have time. We have time. We have time. And how, let's do this, oh boy, the islands on the edge of America. What a title. It's actually the island edge of America. Oh, the island edge. But it was a self-defeating title. It's complicated. It's a political history. I attempted to make it a political history of most of the 20th century of Hawaii. Well, let's take a break. And when we come back, let's talk about the rest of them. Okay. Okay. You're watching Think Tech Hawaii, which dreams live on ThinkTechHawaii.com, uploads to YouTube, and broadcasts on cable OC16 and Ollello 54. Great content for Hawaii from Think Tech. Sounds like scuba divers are the poor man's astronaut. At DiveHeart, we believe that to be true. We say forget the moon. DiveHeart can help children, adults, and veterans of all abilities escape gravity right here on Earth. Search DiveHeart.org and imagine the possibilities in your life. So caught up in the confusion, nothing is making sense. I never quite did it. Hi, we're back with my guest, Tom Kaufman. And going through all of this wonderful history of Hawaii. Tom is an award-winner of all of this. Obviously, when you read and you look at all that we have talked about, and Tom's research is incredible. It is like you think you live, talk, and breathe research, do you? I remember one book, I don't remember which one, that you were in D.C. in the archives for months, it seemed. Yeah, it was a long time. It was Nation Within. Nation Within, yeah. Right. And these, how Hawaii changed America, talk about what happened and when. Okay, well, it's a book parallel to the first film we talked about, First Battle. First Battle, yeah. Except that it's a much deeper and more complicated and elongated history. But it covers the subtitle. Finally, I was pretty happy with the subtitle, The Movement for Racial Equality, 1939 to 1942. And then the final version of that book is going to be 1939 to, maybe 1970 even. But with a real emphasis on the crisis of the war and the way that people did work together, at least a good many people did work together to cope with the crisis and prophetically shape a post-war Hawaii based on the principles of maximum participation, inclusion, and equality. Now, a lot of our young people can't imagine a time when Hawaii was discriminatory, when it was racially, everybody was, even the Koreans and the, of course, with the Japanese and the Okinawans and the Chinese and all of these different groups. It's hard to imagine, given today when everybody's married to each other, it's hard to imagine that there was such a time. And it wasn't very long ago, I mean in historic terms it wasn't very long ago, it was maybe 60, 50, 60, 70 years ago, depending on how you count time. The war was 70, you know, 75 years ago or so. So it was maybe three generations.  And all of that has changed. I wouldn't say all of that has changed, but I say that is substantially changed into a multi-ethnic society, which is the critical point. Yeah, I remember reading, of course, when we first came here in 1946, we couldn't stay at the Royal Hawaiian Hotel. You know, that was only for white and then they all service people, military, at the Royal Hawaiian Hotel. And Fort Shafter was, the 25th infantry was all black. The military was totally segregated and in the book that you gave me, First Strange Place, and that book, they talk about all of the differences and the issues that the Americans had coming to Hawaii, where all of this was new, all of this was different, the people, the language, the look, everything, and how the military insisted on keeping the racial divide. But they had been a part of the overthrow. So the Navy was knee-deep in the overthrow, in the bringing annexation, the whole thing. They were there. The military history, the more I work on it, gets more and more complicated. I think the United States Army played a crucial role in, certainly in the World War II, because there was martial law and because they were instrumental in forming the Japanese-American fighting units, which famously were a transformative. The Navy persisted in being an all-white, racially segregated institution throughout the entire war. So the beginnings of change occurred during the war, and then after the war, it was 1948, there was Truman. Truman issued an executive order integrating the military. Now, even for the July 4 issue of 1894, the Navy played a critical role in making that happen. So they have been a part of this all along. If you think about blue-water navies, if you think about the United States Navy, the Navy is the basis for projection of force into distant places. And so it is inherently a colonial instrument. And that's the way its history played out in Hawaii. Well, we see, what was his name, Mahon? Yeah, Alfred Mahon. Alfred Mahon. And Teddy Roosevelt, together, they had decided that to control the American Empire, they had to control the oceans. Yes. And they did a pretty good job of controlling the oceans. And I think that was one of the key researchers for the nation within. And I really worked hard on their correspondence and the way that through their conversation with one another, they developed a plan, basically, to build the Panama Canal, to build a canal through the Isthmus of the Americas, where it was originally described, because they didn't quite know where they were going to put it. And to be able to then rapidly move the American fleet from one ocean to the other, or distribute it, so that if push came to shove, America could fight a two ocean war. Well, you know, there's, quote, Spanish-American war. They needed Hawaii as a refueling station between the Philippines and Guam, and the mainland. And Hawaii became necessary. That became the catalyst for what was called annexation, was the Spanish-American war. And the reduction of Hawaii to a cooling station between the American West Coast and the distant Pacific. For anybody that doesn't understand, there's this one little caveat. Teddy Roosevelt, the great Teddy Roosevelt, got a peace prize, right? But he's the one that set up the war with Columbia in order to take Panama out of Columbia, create its own country, then he could take the canal through the Panama Canal, through that land. But he gets the peace prize, right? Oh well. Tom, let me tell you, Tom is a jewel, as you can tell. And I absolutely love him. And next week on July 4th, we are doing a reenactment at the palace at 9.30 a.m. on the steps of the palace. And my producer, Scott Foster, Tom Kaufman, and our own Jay Fidel will be part of the cast. So please join us. We look forward to seeing you. Aloha. Thank you, Tom. Aloha. Thank you, Marcia. I'm excited.