Happy Hacktoberfest again my Hacktoberfest shirt on We've got it we've got a nice full panel again today, so that's very exciting I can you believe it's the third week of Hacktoberfest already? No No Okay, and does anyone feel like they've done three works of solid Hacktoberfest thing No Okay, well then I'm not feeling so bad because I'm not I haven't made nearly as much progress in my app as I thought I would In fact, well, I can I'll talk about that later, but um, so we have Sandy back She was out traveling last week and couldn't find Wi-Fi to save her life on the Thursdays I had no clue about an interstate going down to one lane Didn't think it was possible Finding inner finding internet connection on a one lane interstate in the middle of Appalachia was not easy Like how how is internet like with Appalachia with all the mountains that's got to be heard at the best of times Isn't it? Well, sometimes it's really great when you're on a mountain and the tower is there too Sometimes it's really great But it's more when you go down into the valleys and in the hollers that it gets a little tricky and Rural internet is a real issue So this it was challenging, but I'm glad to be back I am thrilled with all the changes and all the updates that I've seen I have been playing All Week with the changes. So I love it. Oh, that's excellent. Well, that's great So I'm looking we're looking forward to hearing Your reaction, you know as a end user and tester and all that because that's that's important Because some of us developers just you know, we've got our blinders on and this is what I'm doing This is how it's supposed to work. No one could possibly deviate from this path of using this app And it's good enough And below me we have Steve Harris who's joining us How are you Steve? Um I'm thinking in there That's good So Steve's published a brand new tree app That's joy that has joined the family. So we're very excited about that. So Um, and well, so we'll probably start off with you sharing that if you don't mind Um, but we also but alesha's here and he said he's written his first app And which is hard to believe since alesha's written so much on wiki tree But I guess the first one that he technically calls an app So we're looking forward to seeing that The tree app A tree a first a first official tree app. Yes. Okay. You've done lots of things. I think alesha should go first What's that? I think alesha should go first. Do you think I should go first? Okay, absolutely Jamie before before we turn it over to alesh. Do you want to say anything or? um I I just moved some of my old stuff into tree apps code and I'll show that off to you That's great. I can forward it. Okay, alesh Take it away. Okay, uh, so um I This week I decided to try to write an app also by myself Since all of you are all are already doing it so I decided to try to uh Not really write something new but to move the wiki tree maps wiki tree plus maps to uh to um the tree apps so Oh, this is exciting And this is really brand new Yes, yeah, it is not you probably most likely already saw this But now it's wrapped into an app So it actually took me half an hour or less Wow Because it's other it was already written um So here I can uh in three apps Now one of the application is maps. I named it maps plus, but I'm not really Satisfied with the name. I will probably go With the name it has until now. So like wiki tree plus maps something like that. We'll see um, and you can Enter any person and it will show the ancestors of that person. So where they were born and where where they moved during the lifetime. So We can now see my ancestors how from which part of Slovenia they were And how they moved during the life their lifetime Um, all you can also it's clip kable map.  So this is this profile more on here that Here and so you get some details of the Profile you can also extend it Show the profile on wiki tree Or you can also then navigate and show just this person's ancestors. So This was all already written in wiki tree maps plus Okay, he has none Yeah, they were all they all lived in the same place. So uh here in Slovenia, that's not that interesting because We didn't move around a lot. Yes, if we have a look for your profiles, for instance It's 11 007 11 007, yeah James Bond 11 James James Bond, right? Yeah 11 James Bond. That's right So we get 284 profiles for your ancestors and here are the locations Of them. So, okay, we Very often you will see someone located here south of Africa in the middle of just in the in near Africa That's on 00 coordinates. Um, since the location was not interpreted to actual place, so Probably here you should use a different you should Write the depth location as it should be most likely. Yeah, that's just That the place name, but it doesn't have the yeah, usually that is not enough because the world is big Um, also if you have someone for instance here, probably You have someone in Greece Um, this can also be a I mean, I don't know where this this is Uh, probably not in Greece. No, not in Greece No, that's part of Newval France. Yeah. Yeah So such locations should be corrected and then it will be displayed correctly also on the map the map displays the data from weekly database dumps. So it's uh, seven days. So up to seven days old. So The changes you may want to be visible immediately, but next week they will be in and here you can then You can see how your ancestors moved around Then you have a few possibilities here in layers. You can set some you can define how you want to Look at the data so you can display birth and death locations. Those are the dots that are separate In separate layer Or you can turn off also the arrows the lines between birth and death place Then you can choose to color by century. So now you have You see for each for all profiles. So blue one this blue lines were in 18th century and so on so you can Have kind of timestamps. So here in 20th century, you have you're moving around here a lot And you can also monitor by you can also look at the data by generation. So I think You can separately turn on and off each generation But first and second for living profile people is are usually empty because there is no Location info in the public dump. So with your grandparents, you start to get the data in So this is your third generation Fortune and you can look at fourth or fifth Nice So you can that's another way to look And the data and you can also cross mix this with Like something is Yeah So this they were all in 19th century Yeah Okay, so Here you can so after you have a person I mean, you can navigate through persons here through profiles here and then once you Nothing was found. Let's try that You can also here show ancestors and descendants or a new nuclear family from this person So you can just restart the Charting so now we will go from Murray and we'll look at descendants of Murray Augustine So You can see them all now, okay Okay, so now you can see the descendants of her so So I don't know I will most likely also make an outer navigation So you would once you enter the profile ID you would be able to select What you're you're trying to Look at are those ancestors descendants nuclear family, but that will be it Okay, so That's great. That's what you already had red red. Yes application Right. That's just on your apps Uh server. Yeah, it is on apps trt nik2 Uh dash dt. Let me put the url out To the chat Yeah, yeah, so Yeah, and when when said he said that's really new. It's not in the tree apps tab yet It's written so it's it has to go to the stage it has to be added to the You can test it here on my Site Now I was playing with this before we came on live and the one things that I really really like is if you have a Family with similar last names a lot of them and you know if you have smiths Jones things like that The the one beauty of this is the show on wiki tree Button as well because then you can figure out Which you know robert smith if you have four of them in a row You sometimes we don't know the dates off the top of our head, but if we so I I really appreciate the show on wiki tree because then I can just click on it It opens up a brand new tab so i'm not losing my map I'm losing my data and I can go oh that was the wrong smith robert smith Let me go back down because I know in my family we tend to name people the same over and over again So I really appreciate just that little Section that you have there as well as opening up on a new tab That's yeah That's very cool I like that and I mean you did have you you're saying that you know It's nothing new because it already existed on wiki tree plus But there's still a number of wiki tree users that are nervous about going over to wiki tree plus and trying that So I think this will make it a lot more accessible to um, yeah I hope I I hope it will not be too much for my servers Well, uh, at least you know who to blame There you go, um, that's great. Okay steve. Why don't you show us your new app And then jamie's gonna show her show us the app that she has repurposed for the tree apps And then I think we'll end with um sandi giving a recap of what it's been like testing all these new things All right, let me get my Screenshares ready to set up here. Okay, and maybe I should have went ahead and gone first because that's going to be a tough Act to follow. I know I was trying to help you out there, but you You were so gracious I mean alphabetically a lesh was first and you know a lesh, you know, but still mine's not going to be nearly that exciting Oh, but it is exciting Very graphical and people like to see pictures and stuff. So all right Are you sharing your screen yet? You may have to walk me through this Uh, go down to the present button. It's already here. I think I've already seen the screen. Oh, hello It there was stream yard. So there you go. All right. So and I'm gonna have to look up on another monitor here um So this is kind of family portraits is actually a request that was submitted into github to be able to pull the profile pictures of all the ancestors Um, so the one that's currently published is going to be a little behind of my development stage Greg actually Found an issue yesterday. So I've got a pr out for that and it should be updated within the tree apps At some point um But all this is doing is it's going to take your profile ID or any profile ID you submit and it's going to go through and find all of your ancestors and their siblings Out to 10 generations and load all of the profile pictures Now you'll notice that there are going to be some strange items and images that are in here So Obviously I've got you know, a lot of family portraits that are in here. Some of them will be duplicates It's because it said is a profile picture for multiple individuals But you can actually click on the image and it'll take you right over to that person's profile And again, it's just going to pull that profile image So in this case They have this set as their profile image. So that's what it's pulling in. Um Let's see if we update that so here's the one for queen elizabeth You can see all the profile photos that are pulling in Um, that's very cool Greg, do you mind if I pull yours? No, go right ahead. Uh now, is this the updated version or the this will be the updated version Yeah, because I was asking steve yesterday about this because all I saw were these records like the baptismal marriage records in the priest priest handwriting. I thought where are my pictures? I know I have pictures And you've got a lot of ancestors to page through Yes, all those one thing I had completely forgot to put in was pagination to pull all of those ancestors So the further back you go in time, obviously you're not going to have profile photos for a lot of these people So they're putting in, you know shields and emblems of some sort But now this is now pulling in all the data. So I'll scroll down here and we'll find greg in a minute In a while Yeah, or maybe we won't See let me refresh this maybe he's on the first image there Yeah Oh, you know what are you? I overwrote my database this morning when I was working on an issue with jamey. Oh, no Um, I think the updated code should be on the the test Thing on the app server so it's app.wikikreed.com Slatter Slash The wikikreed dynamic tree one. Yeah. Yeah slash app slash wikikreed dynamic tree. So that should be the Have all the pull requests that we worked on this morning Right, right. Yeah, jamey's been doing all these pull requests and they've been coming pretty fast and furious this last week Yep But it's been pretty easy to check like most everyone's code worked fine except I found a bug with uh steves this morning when I So but we we fixed it before No, no before this uh presentation so We've it's a steved uh, there we go the system Yep, so now we're starting to pull in some of those more recent profiles. Yes There we go, mr. Greg. Here I am There we go worse Again, like I said, it's nothing too terribly fancy. Um, it's just gonna run through all the ancestors and siblings and start pulling in those profile photos um, one of the things we did talk about is potentially trying to open up the api at some point with brian and being able to return not just Images or sources but being able to filter on all those different photos within the api So the one that i'm using right now again is only pulling the profile photos So, you know, hopefully that'll help expand this app and then anywhere we may have duplicate images um Don't see any off hand, but well, there's a bunch of shields at the top, right? Yeah, that's true um Here we go like these here the blazzle. Yeah, right So one of the things that I'll probably end up doing is combining those into one and then just providing a pop-up That shows you all of the profiles that have those and then you can just click within the Pop-up on one of the links and go to those profiles That way you're not having to see a bunch of duplicate images So like I said relatively easy kind of uh mooring from a technical standpoint But it's fun to play around with and see what all's out there. Yeah, it's nice to look at Yeah yeah Yeah, and if we if we can get to if we can get brian to uh To add that little piece so we could filter out the sources would be even nicer To do uh q but I don't know I know yeah, I mean it's not mission Anything but yeah So he's already put it on the to-do list. Yeah. Yeah, it's in there. Oh excellent. Yeah, that'll be great That'll be a great one. Well, that's a step in the right direction. So that's right Yeah That's great. So see Steven had a question. I don't know how to how to put it up on the screen. Oh What area this one here? Yeah What are we pulling flows from so this is the profile pictures for each of the Wiki tree, right? So I'll just select one of the kind of random ones here By going to that profile so it's their actual whatever image is set as their profile picture Right, there may be other images listed for that profile, but it's only going to pull in the profile picture at this time And you say you go out 10 generations plus the siblings of those direct to senate ancestors Do you go down as well or just up? Um do not currently go down. Um, so that's probably another one that I'll probably need to do because obviously you can pull these for Different people. Let's see. Let me get back over to So for queen elizabeth, you wouldn't have her kids or grandkids. Correct. Do they fall into the privacy? Some of them might and obviously, you know Privacy protected images aren't going to show or if they do it's only going to be whatever thumbnail is visible Um, so that's one of the things I'm doing is transforming the images to put them in a specific size range So we don't have these huge images that are loaded and pushes everything around So i'm kind of formatting everything into the same height All right, so yeah, that's that's a good one. So obviously with queen elizabeth, there's a lot going on there You could pay you know what? Sorry, i'm just thinking uh, just like my fan chart led me to thinking about the fandoku Made up that game you could use this as a basis for like a memory match game With wow who is married with home? Oh I just to name this person would be too complicated for me I mean, so who are we looking at here, greg? Yeah, I don't know. Yeah could be Beethoven. Who knows? Oh, it's german All right, so you did good on that one That would definitely be interesting I've had a lot of fun, you know after building this doing you know quite a bit of testing on it Especially after yesterday's update after talking to greg Going through all the pages now You know i've been playing it just pulling a bunch of random profiles and playing with them There's some really interesting photos that are out there. Yeah Really interesting so it's fun to play with from that perspective as well Yeah, there is there a get a random profile option in wiki tree. I think there is isn't there In the browser extension there is um There was also a stand alone app that I made like a million years ago where there's just like a big button that you can click on Oh, yeah But no, I find since you go up to find drop down and random I think that's part of the browser extension. Okay Because that that you could do random pictures, you know as well You know, just randomly pick profiles and then find the profile picks from those two right that that could be an I'm a bad host because i'm giving you more and more work more ideas So All right, that's what we're doing. Yeah, that's funny Or and then look at k of course k's k's he's adding to it. Yeah, and bio check at random That's right There you go Maybe we combined them. Mm-hmm. That's right That would be interesting I'm sure you already saw that paddy. It's Oh, okay, that's very cool Very cool Well, jimmy you are one of the first to do apps in general on wiki tree way before any of the rest of us did stuff Not tree apps specifically, but yeah Isle of apps and now you're starting to bring some of those over Yeah, yeah, I I haven't updated most of my apps for a long time So it'll be good to get in the shared code so other people can make them better And it was kind of painful looking at my old code just because i'm a better Why did I do it this way or what what was I doing? It was It was uh Yeah, I had to clean it up like the ancestor statistics app I definitely had to clean that up before I put it in the shared code because it was kind of embarrassing Yeah, so oh and before we move on to me, um Steve also uh combined the family calendar and family anniversaries app, right? Oh, right So just so people know what is it under now? Is it just family? I think it's just calendar now Or will be Can you show that? Not gonna be anything fancy. Um, okay I think I saw that written somewhere, but I didn't actually get a chance to check that out Well, that's what we were working on this morning Maybe sure Steve to introduce those errors Yeah, I tried loading it and it just kept refreshing the page until I hit the api limit. Oh, no It was only for For the test account that I was using that didn't have any family attached. So it was it was something All right, so someone I'll have to pop that screen share in there I have no idea what I'm doing. Let's go. There we go. All right. So yeah, it's just we've Oh there went Okay, I'm gonna hit it again There we go. Um, it's like Jamie was saying it was just combining the two different ones. So the This is kind of what we call the watch list anniversaries. It was modeled after special anniversaries, right? Right. So it's just providing the listing and you can jump to the different months at the top, right? We'll draw that data And then up at the top just change the display mode to modern calendar Like a second and now it will load that new nice in a modern calendar view, right? Because it's exact same data. It's just so how yeah you yeah exact same data just all combined into one view That's that's brilliant. Yeah. Yeah, so this will kind of open up some possibilities as well for other Now a question. Can you port that's to google the calendar? Yeah That's going to be a fun one. I have started working with trying to do like a ics Have you well someone had actually suggested that before for the um Special anniversaries page, which is what this is going to eventually replace Right, but it was just like You know, it's such a a minor thing that it's like on the to-do list for maybe eventually sometime But with with shared apps, you know, if someone really wants to do it they can just add to the code and Right and it's actually pretty tough to do right so In the two calendars or two views work a little bit differently from each other So same Basic data to completely different calls to the api, but on your watchlist what you're returning really is Um the day the month in the year, right? So every there's no separation between years So you're just running down and it's sort of right, right, right by the day in the month, right? So when you get on the modern calendar The year is completely stripped out because see i'm looking at october of 2023 But i'm looking at everybody who had an event on a specific day Right, right. So that's kind of the difference between those two apps and if we did implement kind of that ics function It would probably be directly from this modern calendar Right because then we're not appending your data to it. It's going to be a lot easier to understand but getting the The format corrects a little tricky. So it hasn't been implemented yet Right and currently it uses the watchlist and there. Is there any filtering options yet? There's not so the watchlist anniversaries use the watchlist There's no filtering options that have been added in yet. I know there was one that was suggested I haven't had a chance to get around to it yet However, the modern calendar is not focused only on the watchlist. It's actually Paginating through get people So ancestors again all the way out to 10 generations plus siblings Right, so one of the features i'll probably add to this one a little bit later is being able to turn on or off Whether the siblings You know is being used how many generations you're going out if you're only wanting to see three or four generations instead of the entire 10 Yeah, you know those are going to be pretty easy to add Yeah, yeah, I think that was not on Main server yet, right? No Yeah, I can probably update the main server one today Uh, it just depends on I I need to do a little bit More But it is on the test version of The dynamic tree which I put a link in the private chat because I can't put links into the public one. So if someone Could put that in there so people can play with it So I think a leash turned into a robot on them All right, let me see would you like me to post that link gamey? Yeah, if you can it always fails when I try posting it so Oh, actually, I just got the same air. I think the house we posted from the wiki tree account. Maybe okay Or from a host so okay, so I'm I'm trying to read that. So it's apps dot wiki tree dot com Yeah, yeah Now what's great about this is everybody's used to seeing it more in a modern view like this in a lot of this go Every day we might pop in to wiki tree And click on this person to check their profile see if they need sources see if they're sourced see if they need connected Categories things like that. So we use the anniversary List as an end user Excuse me we use the anniversary lists like this as an end user constantly So seeing it in a modern view is just perfection Yeah, that's nice Very sweet says j. Yeah indeed Good stuff Okay, are you ready? Sure, let me see Yeah, if you if you want to feel better, let me let me share my progress this week This is my progress this week So the app that i've been working on Um, I can't I couldn't quite figure out why it wasn't why it was messing up with some of the positioning So i've gone back to first principles and i'm i'm debugging Individual each of these stickies is a function that i'm trying to connect and figure it exactly what it's doing And why these aren't working together the way they're supposed to so I have nothing to show except for my my physical debugging But I as long as long as you don't print out the sources you're still modern But I do that there's someone in the chat Steve 80 is in the chat and he is getting He's getting his computer all set up and he's going to be my assistant He's going to go through all the settings In the app and make the settings work like they do in the fan chart at least for most of them I'm not sure how the coloring and the highlighting. I'm not sure but if highlighting will make sense in such a large large app, but He's all ready to get on board and help with that. So while he's working at that I'll try and get the the the lines going where they're supposed to in the boxes to be somewhat copacetic and Murray's actually started started. I'll work on the free space page for the help But I don't have anything I I mean I could show you that but it's just a shell right now and he's he's he's Got that up and a skeleton for that But that's all I have Not a lot to show so don't feel bad. Jamie. You've done more work than I have Yeah, so, uh I have I don't know if it's showing up there. It is Okay Yeah, so I I made an old app Like a long time ago. It was based on a reddit post that someone made that was like, oh try to figure out You know these certain or like how many answers are your Ancestors earliest birthday for each generation thing. So I just like quickly made an app and it turned into the ancestor statistics app um, and so I've I've moved that away from my own little app Without shared code into the the tree ops code and this is available on Uh, like if you go to your tree ops tab now under ancestor statistics And so I mean it's it's pretty simple right now Um, and nothing has changed from the old app. It's just It's in the share code, but But people have given me a lot of suggestions over the years. So I'm going to put those suggestions into Uh github as issues for other people to work on if they want or maybe I'll have time to work on them So yeah, so it's just a little simple Simple app in here But oh and the one thing that a lot of people wanted, uh But it can do now is before I just would grab Whatever you were logged in in or in ads and that was the only thing you could view So now you can do it for anything. So um I'm not sure I'm not sure who's to I don't know if you can tree ideas off the top of my head and I'm kind of worried a bit about privacy Just I mean, I don't think the screen will matter too much, but no just one won't show anything. Yeah, what's your idea, Greg? need 11 007 What happened hopefully it works. Yeah, there we go There we go. Yeah, and someone had asked what the generation length was and like I had forgotten too So I had to look at my code. Um, but it's basically like the age the average age Of your ancestors when they gave birth to your ancestors. So If that makes sense Right the age the age at which they became the parents of the of your aunt Yeah, not like their first child, but like your aunt like when they were Yeah, yeah, so that's what the generation length is And then my span is their their average age at death. So right Yes, because so if you if you mapped the Your birth year your parents birth year your grandparents birth year Those the difference between those birth years is that generation gap, right? Yeah, right the generate and so the average would be the average of those Yeah, and and one improvement that that maybe I'll get to um Is that right now the The oldest ancestor it just um looks at Um, well, so the average lifespan only takes the years of um for like Like just the year so so sometimes it's like If the oldest ancestor may not be exactly the oldest if you have two 99 year olds. Yeah. Yeah Like 99 and three months and the other was 99 and two months or something like it may choose the wrong one So that that's something that could be improved. Okay, so we have a volunteer there jamie David was saying earlier on that he was all set to go and then he lost Steam and inspiration. So and he was looking for some suggestions. Yeah. Yeah, I definitely need to yeah I was just trying to put this in there so I could like You know put the stuff in there because I think I Made the post for people to add suggestions like three years ago and I So so there'll be a lot of happy people That's great And yeah, and then so you also add maybe the oldest female and the oldest male ancestor to your list Yes, they're just yeah, you could just the oldest ancestor regardless of gender, right? Yeah, let me write that down. Yeah Because that's actually yeah, that's true the difference between the two would be interesting I know That those are my stats there, right? So look at the difference between the earliest at the 10th generation, you know the farthest back The difference between the earliest birth year and the latest birth year is over a century Because one is one is obviously I'm pretty sure I while knowing my my my tree one of them is is On the I don't know if it's the direct male male land But it's it's one of the male male dominated lines Because of course the men can have children a lot longer Later and some of those lines are very very spaced out And the other I think the youngest one is the pure maternal line Oh, which I suspect happens a lot of people but the difference there is wild Stats wise And Jamie if you're taking ideas the average lifespan may be interesting for males and females as well Yep, I am taking ideas Yeah, so overall average lifespan and then average male lifespan average female Yeah, there's probably a lot of other data that people would like to see you know That I haven't thought of so so yeah, we could add a bunch of stuff. Maybe like Have different settings so people can see just the stats that they want or Mm-hmm Now if you're just you're just using Direct ancestors so like family size is that that is that something that you can report on or When I when I move the code from my old code to to this I used to get people Just the ancestor thing but so like it could be expanded to to You know do family size and stuff right now though is just getting ancestors But because it is using get people for the call it could be expanded to like include You know siblings or or stuff like that So yeah, lots could be done with it Neat or do the descendants statistics. Yeah. Yeah, it could be the other way I should just rename it statistics or something. Yeah, that's right Family statistics family statistics. That's right. There we go Mm-hmm Very cool Yeah, and then the other thing I did Is it yesterday actually mostly while I was in the airport and on a plane Was uh, let me how do I stop screen share And then share screen again Now that's statistics again One second Oh wait a second. Are you waiting for us to no no no no I was trying to I had too many tabs open. So I was trying to find out which one I wanted to share So I added something to the cc7 views so because last week, uh, we all added, um This little drop down here. Mm-hmm. Uh, one of the things I've wanted to do since all the data is basically the same uh is Basically move, uh, the old missing links app Into cc7 because it it it gathers all the same data So I added a little missing family thing down here Nice So what what missing links used to do is it would show you all the profiles? Uh within a certain number of degrees that were either missing a mother a father Um, or if they didn't have um the no more children Checkbox checked or the no more spouses checkbox checked. Um, and that would basically be so you could Find out where there were possible missing family members for you to increase your, uh When I originally wrote it it was more to help connect people because I figured if you Like added new family members you would probably find a connection eventually It it can also help to grow your cc7 So so I added that into the cc7 views. So if you click missing family, well, so Because I didn't want to use my own, uh Because there's private people in it. Um, I chose someone else So so I don't know how many people are gonna disappear from this chart But I'm pretty sure that Abigail will disappear because so these gray boxes here I mean that the no more No more children and no more spouses boxes are checked and also she has parents So she probably will not show up on this report once I select missing family Hopefully Okay. Oh, okay. So yeah, so she disappeared. So everyone on this chart will will Could possibly be missing families. Is there a legend for all the images and colors on this page? Yes Somewhere in help in the help. Yeah. So all I did was add the drop down to to filter the thing the Stuff were already there. Um Yes So yeah, so it's great No more spouses children boxes checked Purple brick wall as both parents are missing pink is missing mother Blue is missing father. So so you can see this one has missing mother You don't know if any of them are missing full Um, so yeah, it was just I just kind of wanted to combine the two apps just because it basically Makes sense do the same thing now Um, I probably will change styling to be a bit more closely Or like a styling option to be a bit more closely. Um, what it looked like on the old app just for people that like that style But yeah, it was actually really easy. I think it was like 10 lines of code that I had to change to add this That the enm real had already done so Wow, and it's a lot faster than the missing missing links that because that one used to um, Make an api call for every single profile it looked at so it could take a long Um, so yeah, so that that's what I worked on. That's what you did. Wow That's great. Well, you guys we there 10 lines of code or your half hour of programming Oh, man It wasn't it was a little only half an hour See earlier dimension the uh optimization I also this week I prepared and automated the display of the api locks, so It's updated each day each day um So these are locks from connection finder for you will get them for yesterday and you can see uh for so here you have somewhere should uh, here is the application identification. So okay, these are Unidentified calls, but I ancestor explorers for instance Is using these calls. So with the end with um, I also grab out Parameters the levels of parameter some parameters On which server it was around how many times it was Used these days. So it was used 28 times and also 13 more times. It was cached. So It was requested twice within Consecutively with the same request. So part of the So here you can also check if you can get some optimization done or how your application is using the How often it's used for instance here we see a high number. So cc7 is making to made to 2600 calls to the api during the day And so on and you you get these stats for each day Here's the part and you can see if something can be optimized or and so on. Is that just to get people? Uh, yes, these are these are the these are actually These are logs from connection finders. So only for the requests that I receive And these are these are related to the api the others are for are not shown here since They have nothing to do with the programs. I'm I do this. I also prepared a lot I did the same thing for wiki 3 plus api calls. So here you get the daily statistics for For All the pages that are where the application identified itself as using app id parameter or With the Correct name in the search as we as I wrote it on the github how And the application should identify Um, so you cannot here you can see for instance out of bio For one name study called made 1500 calls to Category info box search. So the developer knows which call it that is so it will help them Nice There is another lock from the api server itself, but i'm still working with brian to get those Locks daily on a daily basis from automatically from the server. So Hopefully we should get that also available To see so that that log that you're working on with brian is that the one where um Retrieval from like for the fan chart the tree the tree. Yeah, all of them. Yeah, they're all the here only the The requests that come to connection finder are lock Are locked and counted, but uh, they're all the api calls will be analyzed, right? Okay Because I I don't think any of my apps would go through the connection finder. Would they? Hmm. I don't know I think I saw They do if you use ancestors of the or descendants it does come to go to a connection finder Even if it was a get people I think Or for the get ancestors I don't know Okay. Well, let me check Yeah, let's share again I think it's just get people for right now. I think get ancestors Oh, this is the wrong one Connection finder. I thought I saw I'd get the fractal there the fractal. So you have ancestor explorer bio check Harry ancestor cemetery stats ancestor line explorer Calendar cc7 fan chart Oh Okay, so you are making these calls to uh, the This call these calls come to the connection finder Finally, the rest api calls are processed on the server only on the api server Okay, interesting I didn't realize I was playing with the connection finder there Well, you want nine the generation of a person? I do. How else would you get? I guess There you go 21 times Okay, so k is Get people with zero Ancestory centers or nucleus wouldn't show there because there's no connections to be found. I guess that means Yeah, okay You can find here. Maybe also some Problems in your applications that you're Requesting something too much or so I did when I analyzed this locked and I found a few bucks on my end also um That I made the cause that I really didn't have to do So if you are getting the cash to results often then that that might be an indication that you are Making the same request twice Okay, that's good to think. Um, although it can be with different fields You're requesting different fields each times in that case. It's okay because connection finder doesn't Bother with that But on for me it it was the same result requested and usually the cashed one as you can see are 100 times faster So Yeah, good Wow, well, that's a lot of that's a lot of new stuff And so some of the stuff we saw just now folks for those who are watching live or who are watching the The replay on on youtube Um, some of those things are still in there on the testing app server, which we did have a link to earlier um Or going to also post the link to the locks so you can see Uh, so the development. Oh, that's great. See it. Yeah Um, but eventually they will all show up on the area So if you're wondering why they're not there currently they will get to the tree apps um but sandy Thanks for Where we really appreciate you sticking around so I want to turn turn it over to you to um To give us your like we missed you last week And so you've got two weeks I'll be there young. What do you think? What are you guys doing? and um Jamie with your ancestor view something came up while I was kind of in between traveling and getting home That was really kind of funny like a great nephew had the typical family tree Chart thing you need to do at school. He's he's in middle school But the math teacher Wanted to do a little bit of math with it and do an average lifespan So I was like, wait, wait, wait, this literally just came available So, um, keep it no math So he just said it I think it's really interesting from my perspective You you kind of you're known as a family historian get some really wild and weird requests and that was kind of Good great timing there. So I couldn't wait to see that We did have to dig a little bit for the oldest female or because I only had the oldest male But that was easy too because it was close relation to the oldest male. So that was really interesting The other thing That I really really really love is the cc7 view that jamie had up and I've been using it with biocheck So with the filter you can go to the filter and just pick Show me everybody in my cc7 with the biocheck and that lets me go through the issues Bing bing bing bing all the way through It's the visual I think seeing that chart that pink and blue chart and table is the visual that really really works And that kind of ties into steve's calendar as well because I know in our project we Really use the anniversary dates to go to each profile and see if they're cleaned up See if something's new is added which also brings me to steve's family portraits So when that came out, I think it was uh Yesterday, uh, everybody in my project was randomly picking on portraits So I was introduced to a seventh great-grandfather that I didn't even have a clue if he was Which was interesting to me because he was from germany And that was interesting because my dna has a lot of germany So that was another way that I could trace a line Back that I really hadn't traced before didn't know about to kind of look and see where's this going with my dna All because somebody put up a portrait that I thought was interesting It's like she was saying the random idea and some of these portraits are so interesting You never know what you're going to get out of them So just looking on but I do want to mention too with those family portraits There is a person in one of my projects that is compiling a pdf ebook And going through those portraits would let her see who she already has In her ebook and who she doesn't So I was really amazed at that I hadn't thought about that all because otherwise what we're doing is we're clicking you know parent parent parent parent But if you look at that ancestor view It kind of came up and she recognized some of her portraits and she didn't recognize some of them So she could see who she missed and who she still had so that was really great That was just a really different way of using an app that maybe people don't normally think about Or just click on a random one As well and look at it now. I don't think this has been released yet, but I I will not lie I have spent my majority of time on categories because there's new features on categories That popped up and it's the orphan And the missing parents and things like that. So what I have I don't think this one has Been released or talked about much Browser extension So when I did I'm kind of a freak like this I always start with the cemetery category where my grandmother is buried because I know everybody that's buried there I went there and I saw a couple things missing parents Oh my cc7 is going to go up because I just picked these missing parents orphaned Oh I might want to adopt one of those profiles or maybe somebody Orphaned it and I didn't realize That they orphaned it so I can pick that up as well. Those were the two things But that missing parent was really key for me because I could see where I didn't have the parent and I could easily link them if I had one or two profiles I can link them to the truth Implemately so the the whole category the the goodies that are on the category pages were huge Because then I went over to my one-place studies And started working on on those as well But I gotta say probably my favorite is right now today And then I've noticed that a lot of us are enjoying is the cc7 view with the bio check Yeah, yeah, actually uh, we all made some um Share my screen again. Okay. He made some uh Some changes to the The css just so it's a little bit easier to see Yeah See Yeah, so so I I don't know if you can see that it's like Isn't that great that is all comes up with the full bio check information. Yes Yeah, and you also like you can use the skate key to close it and yeah, no Yeah, so like this one there's quite a bit so that little yellowish orange is telling me I need to go in here bio check has found something I've always loved case bio check, but this is just everything Yeah, no, this is really I've been using it too and and for anyone that wasn't here last Week where you have to go to the settings And then click this bio check and enable it because it takes longer for The cc7 to load because it has to grab the bio information for everyone um So if you're not going to use it keep it off because then it will load faster otherwise, you know You can we could probably also add suggestions to the to this table of everything On top of the bio check no No, and I've got one question about this particular screen because it is especially with bio check It does add a little bit of time if you're going past the third generation or the third cc7 Is there a way maybe it and I don't even know if this is useful But is there a way maybe to be able to select? I only want to see 4th through 7th generation Yes, there is the reason why I mentioned that is my my first second and third generations I I'm pretty You know Neurotic about making sure the clean. Yeah, I had to go to my fifth generation to find One that showed up with a bio check Yeah, but you can load Yeah, you want to show them jamie? I don't can you do like a range of? Oh, well, you can at least do like one degree only Yeah, so you could just do the fourth generation or or fifth. Yeah, like right And that would be handy for me I think you do you could do one. I don't um or you can start with your grandparents and go by sections Yeah, and like if you do get like all of or like cc7 up to The seventh degree you can like filter Um, so if you just want to see like all the fourth degree people you can put a four in that column and it will filtered And you can one of the options in that filter there is bio check with a check mark or bio check with the next, right? Yes Yes, so it only shows the ones that have bio check issues. Yeah. Yeah, you can do that too And unfortunately I chose some with a huge You didn't choose I didn't choose Brigham young. I chose you didn't choose Brigham young. Did you That was who I did originally and did degree three and it was a ton of people I chose now now I'm thinking too if if we could get Steve's There's a cancel button now. Oh, yeah, there's a cancel button. There's a cancel button. Use the cancel button Yeah, I don't know who to do though that's like private enough where it's not going to show someone living So if we could get Steve's anniversary table with bio checks You could do my fourth or fifth generation that they're all dead I can assure you Clark double one 007 okay How to go there and then I think it's gonna do fourth degree only. Hopefully. Yeah, I think so I don't know because I switched. Okay. Yeah, maybe. Okay. Actually, I think there were some living people in there So, yeah, I don't think they're all dead. It's it's not ancestors. They're there's some people that Hopefully they're not living No, they're not look at the There are filters down here. Um, right. It's not just ancestors. Yeah, I didn't look at that I Worth the instructions. I need to play with this more. Okay. I don't think it Shows what those filter images are in the help yet But there is there are the yeah, the first two are the bio check ones. Yeah, sorry, good Yeah, there are Yeah But you if you're you're doing that you shouldn't be able to see anyone that's private. Uh I have a sys off account. So there's oh, so you can see All right, of course Let's do a say. Um, yeah, but uh real mentions that there are save and load file buttons to Right up at the top And I have not played with that yet But I believe it will save Like the so if you've done the big if you've done the if you waited the two minutes or whatever to load the whole thing You could save and then reload it and so then reload it getting it from the There's so many features here. This is yeah Yeah Oh bio check in the calendar. That's a nice one sandy. Yeah, you know if we could get that that would be fabulous too Who's them when we look at every day? We can say oh that person's clean bio check cleaned it or checked it But no Yeah, and a year you're all done you have nothing left to do We added those 12 children to those 12 children That's right. That's right. Yeah. Well, I mean that's one of k that was one of k's Missions for this month is to integrate bio check into more and more apps. So so steve. Are you still here? Yeah, you're still there I'm still here. You heard that That's good But speaking from the end user side, I just want to say thank you to everybody because we have been playing with these Twos we've been trying them out.  We're really enjoying. It's really fun getting to know these new features Yeah, that's good. Yeah now. We've been very Tree apps heavy this This broad live cast and we've mentioned a few things about the wiki tree browser extension But I promise next week We will talk more about what's happened on the wiki tree browser extension because Ian just keeps pumping things out And um, I've been bad because I haven't taken the time to check out all of those things And I don't want to embarrass myself or Ian by trying to do a demo that I don't know what i'm doing about So Don't know what i'm doing. So um, so next week we will Cover lots of the stuff that's happened with the uh, Ian for president He's he's running every every week, right? Complaints around for a long time We can make him president of the apps project. There we go. Yeah, excellent Uh-huh, great. Well, I can't believe it's a flora and be vice president. Yeah, born of this campaign manager at least President of b-land That's right b-land. Oh, that's great. Well, thank you everyone for coming. Um any last thoughts any words? nice No, um, thanks everyone who's who's been here live in the chat I tried to keep an eye on questions, but I may or may not have I may have missed some Anyways, Dave check David Weinberg check out jamie's github and grab any of those issues that she posts as a challenge or something to work on and Anyone else has any other ideas, you know, just add them to the g to g post and we'll see you here next week So thanks very much And uh, let me think here is I have to find us Um, I'm going to play us out with the wiki tree day intro Just uh because wiki tree day is coming up. So I thought we'd do something different for the outro. It's an intro outro Anyway, see you next week


We are working parents and we breastfed both babies exclusively My first six years my bio to take you to the Bonseville Mother's breast milk is naturally the best milk for baby. Love yourself and love your baby Breastfeeding saves me money and it's free Every moment I breastfeed strengthens the bond between me and my baby I breastfed twin boys and lost all my baby fats And we have breast milk power I am Pastor Alvin and I support breastfeeding For more information call the nutrition unit of the ministry of health and wellness at 468-5359


There has never been a greater potential for infectious disease to spread than right now. With urban migration, increased global travel and population growth, governments around the world are tasked with managing fast-spreading disease. Despite available therapies, the world is still battling under the burden of HIV, AIDS, TB and malaria. Now in the last two decades, we have seen a series of health innovations in the form of new and better drugs, novel surgical procedures and a greater understanding of the human body generally. Now while we can measure the impact that each of these innovations will have on a single person, how does this translate to the greater population? A vaccine may have an 80% efficacy over a period of three years, but how will this change the level of disease in the entire country or population of interest? The vaccine itself costs money, but can we expect cost savings in the future? What if we could build computer simulations or a video game, if you like, in order to measure this impact on the population? If we could do so, we could, at a fraction of the cost and in a fraction of the time, make these measurements rather than conducting field survey or a clinical trial. In order to build these models, we first need to have a good understanding of the biology of the disease. We then take the environmental and geographical context and couple it with demographic and health system data in order to get an idea of how the innovation can be implemented. We then write up a series of equations on how the disease will behave in your body, how the disease can spread throughout the population and how the innovation itself can be used to counter the disease. We then write up some computer code in order to build a model out of these equations. And this allows us to make a set of predictions. So for example, we can see in the top left-hand corner how, with the intervention being rolled out, disease incidence decreases over time. We can see from the cost perspective that we initially have a cost increase with the intervention, but cost savings are made in the future as disease decreases throughout the population. By building these models, what this allows us to do is to design a customized disease management strategy to suit different health systems around the world. Whether it is measuring the path to malaria elimination by 2030 or reaching the 1990-90 HIV AIDS targets by 2020, mathematical modeling can be of considerable use. So the greatest challenge in this kind of modeling is being able to communicate our results in a manner that is both understandable and can be used to support health policy and implementation. After all, it is mathematics. And that's quite a tough task to communicate efficiently. So in my lab at the University of Cape Town, what we do is we focus on developing these disease models for a set of diseases, but we package them in easy-to-use computer applications. And this allows policymakers and users of these models to engage directly with the models themselves. So here's an example of some of the applications that we have. We focus on implementation and user friendliness. So you can see by controlling a set of switches, we are able to design or combine several health interventions together to form a basic strategy. Now, this allows us to create outputs such as disease, incidents, prevalence, a total cost, say, for budgetary purposes, and even a cost breakdown of the different components of the health system. This can be really useful in helping a country design their national strategic plan or making funding applications. Now, we have created one such application in the Asia Pacific. The purpose of this application was to predict the path to malaria elimination by 2030. This application has already been influential in shaping policy in the region. And our task now is to attempt to recreate the successes in the Asia Pacific back home in Africa. Now, we're living in an age where data is readily available and where technology has developed to the point that we can process these complex models efficiently. The innovation that I am proposing is to take these mathematical models and package them into easy to use computer applications that allow decision makers and policy makers to engage with them directly and navigate the outputs of millions of simulations with ease. And in this way, mathematical modeling can become an invaluable tool in shaping health policy and saving lives. Thank you.


Personal finance practice problem using OneNote. Comprehensive problem, home financing, financial statements, and property insurance estimate. Prepare to get financially fit by practicing personal finance. You're not required to, but if you have access to OneNote, would like to follow along. We're in the icon on the left-hand side, practice problem tab in the 8210 comp probe tab. Also, take a look at the immersive reader tools. Most of our practice problems are in the text area too with the same name, same number, but with transcripts. Transcripts that can be translated into multiple languages, either listened to or read in them. Information on the left, calculations on the right. We're going to start off with our loan payment calculations, creating our amortization table, then breaking it out into a year-by-year calculation instead of a month-by-month breakout of the amortization table data, which is useful for putting things together such as the financial statements, which is the next thing we'll look at. That includes the balance sheet and the income statement. We'll do two formats of an income statement discussing why you might use different formats of an income statement, tools you might use to put them together. We'll look at the difference and reconcile those two income statements, and then we'll take a look at the estimated property insurance needed calculation on down below. Scroll in all the way back up to the top. Now note that we do do this in Excel too, so if you want to work through this in Excel worksheet, really good practice problems to train in Excel and get these concepts down. Information on the left, we've got the assets, the liabilities. These will be used to help us put together our personal financial statements. Note that you can use tools such as accounting software, like QuickBooks, or I think there's a wave accounting, like free accounting software that you can connect to your bank account, for example. But you still need to kind of understand the accounting concepts a bit in order to make those accounting software's work. For the balance sheet, you can also use other tools such as there's a personal capital kind of tool that just pulls in the ending balances, for example, instead of using the transactions to create the ending balance as accounting software does, which is good for balance sheets. Calculation is not so good for the income statement where you really need to do some kind of pulling that data into a time horizon. We'll talk more about that shortly when we get to the income statement and the balance sheet. Then we've got the income data. We're going to assume that we have W2 incomes for the personal income. Again, there's kind of a problem with that in that when it hits our bank, if we're using our bank as the source of when we're going to calculate the income, it's going to go into our bank net of withholdings, which could include things like the social security, Medicare, federal income tax, and possibly other withholdings such as benefits 401K and so on. We'll talk more about that later. We've got the expenses. Now, the expenses, of course, are what we are expending. We can't get that using software like a personal capital, which pulls the ending balances. We'd have to possibly actually look at the income statement or the bank statement details and pull our expenses, put them into categories and or use software accounting software to help us do that like a QuickBooks or like a wave accounting. A lot of different options. I'm not promoting any one of them. Just you have a lot of things you can use there. Then we've got the home purchase. So we've got the home information, home price, rate, years, down payments. We got the current value of the home and the estimated value of appliances, furniture, clothing, household items, jewelry. All right, given all that data that we've gathered together, first, we're just going to look at our loan payment calculation. And this will help us kind of understand some components of our balance sheet and income statement, financial statements as well. So I'm going to say the home price is the 306,200. We're going to say the down payment was 20%. So we've got the down payment then being at the 61,240, which is of course going to be the 306,200 times the 0.2. That's going to be the 62,61,240. That means that we've got the loan of the 306,200 price of the home minus the 61,240 we put down on it. That gives us the 244,960 the amount that we're going to finance, the loan that we're going to be getting. That means that when we have the home on the books, the difference between the value of the home, which currently at the point of purchase, we're going to say is the 306 minus the 61,240. I'm sorry, 306,2 minus the loan, 244,960 is the 61,240, which in essence is the equity in the home, the net value of the home, which we might reflect on the balance sheet assets, liabilities, assets minus liabilities being the net value. We'll talk more about that later. Okay, so that's going to give us the payment calculation. Now you could use that payment calculation in Excel. In order to do this payment calculation, you can use online calculators to help to calculate that payment calculation as well. We won't go through it here, but just note we do work this in Excel if you want to take a look at that. We could then build our amortization table, which does sound daunting, but it's I think useful to do in Excel. Remember, you do have online tools to help you with this as well, so we could use an online calculator. I'm not promoting this one, but here's one you could use and I could put the loan amount, not the home price, but the loan amount, 30 year, 5% every month, run it, and we get our payment calculation and we could create an amortization table, noting that that amortization is broken out basically by month. We however might want to do it in an Excel worksheet so we can kind of combine it into our other calculations and break it out by year. So I won't go through the loan calculations in depth here. We do build these in Excel, which makes it a lot easier to do. It's easier than you would think to build these amortization tables. So then, but noting on the amortization table that the breakout between the interest and the loan reduction changes each period even though the payment is the same. That gives a level of complexity when we start to think about our financial statements and how we're going to record these on, say our balance sheet and an income statement, how we're going to record each payment in basically our accounting system. It's also useful oftentimes to break this out on a year by year basis. So for example, the payments for the entire year is going to be something like that, 13, 15. This is rounded times 12. We'll be paying about 15, 7, 80. I think it's rounded to zero in any case. But the interest gets a little bit more tricky because if I was going to add the full year, which would be 12 months or the full year here of interest, you could see that they change each month. So that's part of the problem. So if we were to break this out in a table, we can use Excel formats or a pivot table to sum up the interest, which you could see changes each year. And it's kind of nicer oftentimes when we're doing budgeting, for example, to see that on a year by year breakout, which is something we can't see on the online tool as easily. The same with the decrease in the loan principle. You can see that that changes each time frame. So it's nice to see the decrease in the loan principle on a year by year breakout. And then it's also nice to see the loan balance at the end of each year, meaning that's going to be the smallest number at the end of each period. So here we have the end of year one. There's the 241.346, which will be left due principle balance owed after one year. Here it is after two years. So we can do that calculations in Excel. I won't go over them here. But if you want to work that in Excel, we've got that. And then once we have that, I'm going to scroll all the way down because I'm going past the 30 year amortization table here past the 30 year to the balance sheet. So then we're going to construct the balance sheet. Now remember the balance sheet stuff you might use like accounting to do that, an accounting system, meaning you actually enter the data into the accounting software like a QuickBooks, which creates the balance sheet, the endpoint from the ground up, meaning I'm not going to look at the financial statements, ending balance to record the checking account, but rather actually enter the data from the bank, the increases and decreases or whatever, debits and credits that will then create the ending balance and then reconcile my books to the bank. So that would be what accounting software does. Although you can use other software just pulls the information in from the ending balance, which is great for the balance sheet, but isn't as helpful for the income statement. So it kind of depends on your needs and how precise you want to be with your financial statement creation. You could use both. I like to use both. So I have an ending balance kind of calculation that's coming from the financial statements that might help with investment planning and stuff that can be updated a little bit more quickly and then also have the calculations on the QuickBooks or something like that so that you can create the actual income statement, the timing data. So remember that the balance sheet shows where we stand as of a point in time. So let's think about the balance sheet information here. So we're going to say, all right, the balance sheet, I can break the assets out into categories. We've got the current assets. Now it's often useful to do that. That might be more of a business term you might think, but same kind of concept. These are more liquid type of assets that we have that we might be able to use to pay off our current debts that are becoming due. Clearly the checking account. Now the checking account, if you were using something like QuickBooks, you would have to reconcile entering the actual transactions to get to the ending balance. If you use something like a personal capital, kind of software, then it'll just give you the ending balance based on the financial institution that you're linking to. So either way, you can link to the bank, but they do different links. One links the activity so you can calculate the ending balance. The other links just to the ending balance, which is great here, but not so good for the income statement or reconciling and giving a double check of your figures. Savings account, same thing. You can get them in a similar fashion with those two ways. Emergency fund, same kind of thing. You could typically get that from the financial institution both ways, connecting to the bank if you wanted to do it that way. Total current assets then are going to be the 58,000. Notice how we did this. We basically said current assets. We indented, put a colon, given the fact that that's a subcategory. Put the subcategory calculations in an inner column and then broke the outer calculation, the sum of it into the outer column. That's a common format. Practicing that format in Excel is a good practice, good tool to do. So then we do this in Excel if you want to work through that. We got other assets. I'm going to put the IRA down here in the other assets. It might also be, in your case, a 401k plan or something like that, which is often also, of course, in or with a financial institution, which you can get from basically personal capital kind of software, which pulls in the ending balance. And if you're using something like a QuickBooks, note that it's a little different than the checking account because something like an IRA, which is supported by stocks and bonds, possibly, is going to change in value due to the changing values of the stocks and bonds. And you have to determine how are you going to account for that on your side of things because you're not going to be doing it by just increases and decreases to the checking account and reconciling it. You'd have to actually look at the statements, for example, possibly periodically and see whether or not there's been an increase and decrease. And then you've got to figure out how you want to record basically the unrealized gains, the gains that you have not yet sold the stock for, but you've got kind of unrealized gains that would be involved. And that's one reason that you might use both software, like a QuickBooks, to calculate the periodic data as you're entering the data and then other software that pulls in the ending balance to give you kind of up-to-date ending balance on things like the stocks and bonds as it jumps around, right? Okay, in any case, that's going to be that one. I put it down here because we can't really use it to pay off the current liabilities as easily because it's under the umbrella of an IRA as opposed to other savings. If they were outside of the umbrella of an IRA, you might call them current because I can take them out or sell the stocks if they weren't under that umbrella easily. And then we've got the property plants and equipment, which you might call fixed assets or something like that on the personal side of things, same kind of idea. We've got the home here. Now, the home is something that you can't really just go to a financial institution to figure it out. What you can do is take at least the cost of the home and put that on the books possibly, which might be relevant to do given the fact that it's going to be a huge asset for most people. And again, you could change the value of the home periodically by using tools online to adjust the appraisal of the home. But again, if you haven't sold it, you're going to deal with this unrealized gain or loss that you're going to have to deal with on the other side of the calculation from a bookkeeping standpoint. And then we've got the car, same kind of concept. You may or may not put the car on your books because it's significant, but it's not as significant as the home. And again, the car will depreciate over time. So it's a question of, do you need it on there for the purposes of what you are doing kind of concept? Then we're going to have the second car, same thing. You might say there's a whole bunch of other assets like your TV and all this other stuff that you've got. And again, you might put that on there or try to estimate household goods to get an idea, but you're not going to probably want to depreciate all of your personal belongings on your balance sheet unless you're using it or using it for some purpose, like to get a loan and trying to look as good as possible to get a loan or something like that. But for your personal use, it might not be worth the time to put all of your personal belongings basically on the financial statement. You want to have a list of those. You want to have items of them possibly for homeowners insurance, if nothing else, right? So that you can value them in the event that you have a fire or something like that. But we're going to keep it here. We're going to sum those up. So now we've got the 3062, the 14, the 21. That's going to be the 341, 2. Notice again, all this stuff up top we can possibly get from financial software oftentimes like a personal capital pulling in the ending balance. And if you used like a QuickBooks then you'd have to enter the adjustments, the actual transactions here, and then the periodic adjustments here that are taking place with unrealized gains and losses determining what you're going to do there. And then these down here, we have to value periodically if we want to put them on a real-time value taking some kind of appraisal periodically of the home and the car. If it was a business, we'd have to depreciate it, right? But anyways, that's that. So then we're going to say the total assets then are going to be the 58,000, the 40,000. And so we're going to, let's just add them up. We're going to say that's the 58,000. I'm only adding up the outer column now, 40,000, 341, 2. That's going to give us the 439, 2 here. On the liability side of things, we're going to say that we have once again current liabilities. Those are things that are due within a year typically. So oftentimes we've got like a credit card balance that is going to be due. So we're going to put that there. That also we can get oftentimes from the financial institution. If you're using something like personal capital, it can pull in that ending balance. If you're using something like QuickBooks, it will give you the transactions as you buy things and pay them off in order to calculate the ending balance. The car loan also with a financial institution. So typically if you're using like a personal capital, it can pull in that ending balance. If you're using something like accounting software, then when you make the payments, you'll have to break it out between interest and principle. That gives you the total current liabilities. And then we've got the long-term liabilities, which I'm going to say is the home loan, which we're pulling in from the data on the left-hand side. And that's going to be the home loan, which also you can pull from a financial institution if you're using something like a personal capital. And when you pay off your loan payments, you can break out the interest and principle according to the amortization tables that we calculated up top in order to calculate it if you're using something like a QuickBooks. Total liabilities then, the 93, the 241, 346. And so then we've got the net assets. Now, remember if the net assets you can think of as kind of like equity for a corporation, we can say it's the 341, 200 minus the 241, I'm sorry, minus the 250, 646. One more time. Hold on a second. We've got the total assets are down here. That's not the total. That's 439, 200 minus the 253, 646. That gives us the 1-88554. Now, if you did this using accounting software, then you would let the system, all your transactions would be in balance, for example. And you would be using a calculation of assets, assets equal liabilities plus equity kind of calculation and all transactions will kind of be in balance. And that'll be kind of your double check. If you're just building your balance sheet, possibly using something like a personal capital, then it's just going to use this kind of subtraction method to get to the net assets, meaning if these are your assets minus your liabilities, these are the net assets that you have if you were to liquidate, right? If you're just going to give everything away or something like that, right? You'd sell all your assets. You'd get the cash. You pay off all the liabilities and that would be kind of like your net worth. Okay, and so then we could add that to the assets and that would give us our total assets and liabilities, which is kind of how we are typically seeing it from a business perspective or from a company perspective or from an accounting perspective, assets equal liabilities plus equities. So notice the term isn't quite right here. It should be liabilities and I'm sorry, it says total net assets and liabilities or it would be total liabilities and equity would be kind of like the bottom line. That's how we're kind of used to seeing it from just an accounting perspective and you can see it as the left side being what we own, right? And the life, the right side being who we owe it to, either a third party liabilities or ourselves. It's actually something that we own after the assets. We have claimed to it and a third party does not. So then on the income statement, so now this is going to be our timing statement. This is the one that we can't really construct with something like a personal capital by just looking at the ending balance and we have to use either something like a QuickBooks to construct it or we have to basically look, actually just look at our bank statements possibly and be pulling the information to construct the income statement. Now, the first part of the income statement, we'll do this a couple of different ways. The first part's kind of the most confusing oftentimes because if we're building this just from our bank statement, then if I look at my income side of things and if I have a W-2 job, then I'm going to see it hit at the net amount, the 48,000 in this case and the 65,000. But I actually earned in this case the 60,000 and the 79,000, the gross amount and the difference between those two were taken out directly by the employer partially because they're required to for with mandatory withholdings, taxes, Social Security, Medicare, federal income tax and partially because possibly we told them to for benefits such as 401k plan health and so on. But that kind of messes up our accounting because if we're on a cash basis system, then we don't see it hit our checking account that way. They pulled it out before it hit our checking account. So the proper way to do this is you'd like to say, okay, I'd like to put my income on the gross income which in this case would be the 60 and the 79,000 which you could get from the paycheck stub because they will give you the paycheck stub. So every paycheck stub you might pull it from there. You might be trying to construct it at the end of the year or something possibly from your W-2 which means box one might not be the best box because it might be reduced for things like the 401k. So box, I think it's five would be the one for the Medicare which is probably the closest one if you're trying to have the highest income level because that doesn't have as much of the deductions which have tax implications for it. Obviously the W-2 is for tax implications. The actual paycheck stub will show you the gross pay that you earned in theory because it gets kind of complicated in like reality like who's actually paying the taxes and so on when you start to put them. But in any case, you've got that amount there and that's one way that you can kind of construct this. So that means that when you put this into something like QuickBooks, you whenever you see the bank account go up by your income level what you really should be doing is putting the income in there at your gross income and then putting the other items related to taxes as expenses as well as the other items that are related to benefits like a 401k and the 401k which can get a little bit kind of confusing. We might go into that in future presentations but that's going to give us the total income of the 139,000. We've got the normal expenses then. So we're going to say property taxes is a normal expense like utilities. These you might be getting by just going through your income statement or you might use bank, I'm sorry, your bank statement or you might use bank feeds and something like QuickBooks assigning these as you pay them on a cash basis to two categories like property taxes as an expense, utilities, food, gas and maintenance, and interest on a car and credit card and so on, interest on the home loan. Now these two are getting kind of tricky. These two down here because if you're trying to do the bookkeeping on these then when you record them you're not going to just record the interest on something like the home loan. It's going to have the actual payment you pay on the home loan. So it's going to go down by the interest and principal. That's when you'd have to use our amortization table. I won't scroll up top but I'll go here. Your amortization table to break out the interest and principal depending on what kind of bookkeeping process you're using. We might dive into that in more detail in the future but that's where the kind of a tricky thing is with your bookkeeping. So the total normal expenses is going to be, we're adding up to 600 down through the 12166 to give us the 1491 and then we're going to say this is net income before taxes and withholdings, meaning if my gross income was 139,000 minus the 14091, that's going to give us the 124909 and then we've got the taxes and withholdings. So because I put this amount up top on the gross income the amount that's been taken out I'm going to assume to be all taxes. It may not be. It might be a 401k plan in your case or something like that. It is included in there as well but that's what I'm going to account for down here and I'm going to do that. You would do that basically by saying I'm just going to say all right my gross amount that I got paid according to my pay stubs I'm going to say is the 60,000 plus the 79,000 minus the net amount which is 48,000 the amount that actually hit the checking account minus 65,000. If we assume that difference to 26,000 is taxes then we've got the taxes and withholdings at the 26,000 and that's going to give us our net income which is going to then be the 124,909 minus 26,000 for the 98,909 on the bottom line. Okay so you could try to do this income statement on like a more of a cash basis. So if you try to do it on like a cash basis from things that hit your bank account you might say I'm not going to be able to enter it gross so you might be using like a QuickBooks and you're saying every time something hits my account on the bank account I'm just going to record it as income from my W2 income that means you're going to record up top net and that means this is already net of the withholdings that have been taken out. So you have to kind of realize that if you're entering your income statement in that fashion and if you need to adjust it if you need to look good for a bank or something like that you might want to put the gross amount of course up top if you're trying to get a loan you want the highest income line item typically up top but in any case or whatever they ask for but you hire better. So total income is going to be the 113 then because really this is kind of net of the taxes and withholdings and then the expenses would be cash flow basis property taxes here same utilities and then we got the food we've got the gas and maintenance credit card payment. Now notice here I'm not just looking at the interest I'm looking at the full payment here because I'm thinking about this on a cash flow basis at this point and that you know you it could be useful depending on what you're trying to calculate for to think of your your cash flow versus your your like a cruel basis kind of income statement and if you're using QuickBooks or something like that you can actually construct kind of more of an accrual basis income statement and a statement of cash flow but the statement of cash flow is often kind of confusing to people but in any case I'm going to put the full payment down here in a normal bookkeeping system what you would want to do is just record the interest on an accrual system and then the the principle being a decrease to the loan balance now there's multiple different ways you can kind of do that we might get into the bookkeeping later the same is going to be true for the for the car loan payment and the same is true for the home loan payment I have the full amount here on a cash flow basis even though part of it is principal that I'm going to be paying that should be paying down the loan which is a which is a liability on the on the balance sheet so those are the little bit more confusing so that means I'm going to get the 18195 here if I add all that up and that's going to give me my net cash flow of we said that the net income is the 11300-18185 that's going to give us the 94815 now if I try to take the difference between these two and reconcile them and say well what's the difference between those two we've got the 98909-94815 and I've got a difference then of the 4094 if we reconcile that that difference is due to the fact that the home loan a balanced reduction meaning we've got we've got these two numbers up here I deducted more for the home loan so if I take this this 15780-12166 we get that that 3614 and that we can look at the amortization table I won't go up and look at it right now but you can look at the amortization table to determine the breakout between interest and principle and that's that bookkeeping thing that we got we're going to have to basically deal with on an accrual kind of basis so that this one's on a cash flow we just record the whole thing as a cash flow expense and this one we did an accrual kind of calculation we got the credit card payments of the 310 because we had the full payment on this side which includes interest and principle same with the car loan and then we've got the interest on on the credit card that's the 75 where we just recorded the interest portion here and that's gives us the difference of the 4094 so just to give us an idea of a couple ways the income statements can be a little confusing it can be you know confusing to get your bookkeeping stuff down and there's no way to get around some accrual concepts when you're when you're talking about loans like a mortgage or something like that typically okay last thing let's take a look at the estimated property insurance needed so if our property insurance how much do we need would be a question we might ask so we've got the property insurance you might put a calculation something like this we might say with the current replacement cost of the home notice if I look at the home you're gonna you're gonna probably looking at the replacement cost of it we purchased the home for 306 200 but it might have gone up in value so we might want the home you know to be covered at the current price here which we might have to do by looking at appraisal tools online to be valuing the home so we've got that at the 125,000 we've got the personal property we said was the estimated value of appliances furniture clothing and so on which we estimated at 21,000 21,000 down here notice again that 21,000 we didn't put on the incomes on the balance sheet as an asset you could you can estimate it on the balance sheet and but it might change over time right you might buy new stuff and whatnot and it might be tedious to try to put that on the balance sheet because it those kind of things depreciate over time so you might have to revalue you might put just like a static number on the balance sheet to kind of represent what you feel the value is but it changes over time so it depends on how you want to do that you do want to have a list of these items and be able possibly to give an approximate value of them and have maybe images of pictures of them and whatnot in a list of them in the event of course from an insurance standpoint that there was a fire or something so that you can list those items and possibly get recouped for them so then we have the additional coverage for items with items on standard personal coverage like jewelry firearms and that kind of silverware photographic electronics so over and above computer equipment we're going to say 2000 here because we have 2000 for the for the jewelry so it might have a whole separate kind of calculation we would have to add for the additional coverage items such as jewelry possibly total personal property then if we add this up 21,000 plus the 2000 23,000 and then we might have type of coverage for personal property so we're going to have replacement value is what we would like to have and notice again we've got this kind of how are they going to recoup the property we would like to have it recouped it would be nice if we can have it recouped enough get enough payment in order to purchase a new property right we would like to replacement cost so that's what we're going to be covering here we'll put that personal liability so we got the additional personal liability coverage personal personal injury claims this is something that we might add to it if we so choose over and above what the standard policy is we could have specialized coverages flood or earthquake coverage excluded from the home so these are kinds of coverages like we talked about in our presentations that oftentimes might not be in the standard calculation so if you're subject to earthquake or something like that or flood then you might have to buy like special insurance which might be in conjunction with the current homeowners insurance or some or separate policy for those particular items because they kind of could throw off you could we talked about the actuarial calculations and why that might be the case the way the insurance kind of calculation works so that's going to give us our total property insurance needed at the 348,000 so again this was just kind of an overview we do work through this problem in Excel so if you want to just kind of practice putting these tables together working through the problems in Excel then it's a good thing to do