We are back on CFM. It's been, it's been what boys? Three years? Three years we are back on CFM boys. We are back all the way. Madden season is kind of dead.  Trying to keep some interest going. We're going to rock some CFM, but one of the problems with this CFM boys, we got thrown into a season that we didn't draft. We didn't pick this team. This team sucked. Whoever this owner was kind of quit. You know, I'm, I'm kind of, this is a, this is a rebuild change around a team that I didn't draft. You know, they, they fired the GM. They fired the coach. They're bringing a professional to save the team. We got some pieces to work with boys. Are you guys ready to be introduced to the Minnesota Vikings of 2024? Are you guys ready to see what we got, what we're cooking with? We got some gas. All right, boys. We got some gas. It is the Vikings, Super L, not a lot of swag involved with the Vikings, but that's why we're here. I'll show you guys this team as we are in free agents right now. I'm trying to pick up some free agents. I'm trying to pick up some free agents, but let me show you guys this roster real quick. You see it, Minnesota Vikings draft central. We were three and 14 next year. We have a high pick. I think we have the fifth pick. So the draft is in about an hour. So we got times to tweak the team, figure it out. I need your guys help. Honestly, I'm really worried about how the game plays. It's kind of like regs, but abilities are kind of a little more frequent, worried about how the game plays, but we'll figure it out. That's what we got a season to do, right? This league is pretty good. We got some big bully guys in here, problems in this league. We got my is in my division. The winner last year was like cerebral victory or something. He went undefeated the whole year and won.  So we got to go ahead and really dial it in. The biggest piece we have is Kyler Murray. We have Kyler Murray absolute stud. You know, we don't really like Kyler Murray that much in real life, but we're going to make them tough. And the thing I think they gave everybody have quarterbacks. Every quarterback has abilities. Like every quarterback has like five abilities. So Kyler Murray literally has everything except quarterback playmaker. I couldn't get that. And you can change the abilities once you get them. Once you, once you like get an ability, unlock it, level up enough, you can change it to whatever you want. So Kyler Murray has every ability you could pick. So he's going to be a stud. I thought about maybe even trading him, finding ourselves a new big strap, getting a bunch of defensive pieces for Kyler Murray. But because everybody has quarterbacks, I'm not sure that that's an option. You know, I don't know. Maybe I'll put some whispers out there and see, but this guy is just too good not to not to keep, you know, running back. We got Joe mixing, but we have Joe mixing. He's in the free agents. So he's in the free agents. I didn't wasn't able to stop, but he's mine. We got Joe mixing. We got Joe mixing. He is our running back. He's actually a stud. I was thinking about trading him too, but nobody really bid him off or so. We're back wide receivers where we're actually pretty strong here, boys. We're actually pretty strong. We got Tim Patrick, six foot four, decent speed. We got Quezz Watkins, 97 speed and rags is crazy good. We got Mackenzie Short, but fast. And we got Will Fuller, the fifth. So our wide receivers are definitely good enough. Without a doubt, they're strong. It's a strong group of men here at wide receiver tight end. My Steelers fans, we got Fire Moooooth. I don't know if we'll play him or we'll rock for wide receivers. We'll see.  And that's one thing I'm worried about because of like edge threats and under pressures. And like, I think that's just going to be ridiculous. Can you guys just bear?  So we'll see. Yeah, it's going to be nasty. It's going to be absolutely nasty. But here we go. Our defensive line is awful. We have Franklin Myers. I have no idea. We have I am by Dejo. We have Dre Greenlaw, who this guy decided will play defensive end with absolutely no pass rushing abilities. I mean, this is miserable to pick Dre Dre Greenlaw and put him at the end. Right? I mean, what are we doing here? This is a off ball linebacker. You put him at the end, just ruined him. We got Derek Brown, who actually has an ability. He has like, I actually was able to get like double or nothing on him. So he's a decent detackle. So we can fight a little bit with that, right? Boys like, I got this a weak as defensive front.  None of these guys can play. We have Miles Jack. If you guys remember, we got this guy, Jevin White, who has 89 speed. I have no idea.  We got Miles Jack. If you guys remember, he was on the big strap squad. He was one of the more linebackers. The best thing about Miles Jack is that he gets two abilities, but he doesn't get lurker. So he won't jump. So is he usable? We'll find out. We'll find out, man. We'll find out. I put pick artists on him and like secure tackler. 86 speed is probably too slow and like, I don't know. Corners were kind of stacked. I'll be honest, boys. We are kind of stacked the corner. We have Snead Gaming. This is our best player. And we got Jamele Dean, who's 95 speed. He's in free agent. I wasn't able to resign him, but he's on my team. So we have two 95 speed corners. That's actually really tough in CFM, boys. If you guys know, and rags, that's super tough. We got William Jackson, too, with 92 speed. We got this dude, Crop. We got good secondary, like fast enough players to play in the secondary for sure. McKinney is safety. Probably won't play. We got these young guys, Stevens and my man, Greg Jr. Greg Jr. might be a staple of the team. Greg Jr. might be a staple of the team right here. Greg Jr. I don't know. We'll see how it goes, boys. We'll see how it goes. But all in all, what would you guys give this team out of 10? We can work with it. That's how I feel. I feel like we can win. We can definitely make playoffs. We can definitely make the playoffs, boys. If we run into a good player with past rushes, we might be SOL. All right?  Our defensive line is in shambles. Our linebackers are, yeah, my trenches are weak. I got the pretty stuff. You know, the trenches are weak. Now, this is where I'll tell you guys, is we have the draft coming up here. That will be marked down tonight and in this video, the draft because I have decent DBs and decent wide receivers. Listen, boys, what are we going to do in the draft? What are we going to do with the fifth overall pick? Are we going to grab a line? That's kind of wild in CFM. Are we going to grab a D? I would love a D line. And that's a beast. I don't really know how the draft pool works. Let's take a look at it. Let's take a look at quarterback. I don't need a quarterback.  Halfback. We're not getting wide receiver. I see nobody that tall that makes me really that excited. All right. We got the fifth pick, 38th. It looks like my standard picks right here. No seventh round pick, six, 38, 70. Those are my numbers, boys. Those are my numbers. Six, 38, 70. I tried to get some free agents. Let me show you guys sign for it. I'll show you who I'm plotting on. All right. These are my boys. I want this wide receiver named Dan Chizzie. Dan Chizzie is six, three, 95 speed. Dan Chizzie, that's my man. I want to get Dan Chizzie. I don't even want to show people about Dan Chizzie because, you know, the other crabs in here, they're going to go try to get them. So I might not get Dan Chizzie. Then I was going to grab my man Mo Rigg. He might still be tough. You know, he might still be tough. But these are my guys right here. Jamel Dean and Mixon. They'll be on my team for sure. Two studs. Now that's all I really want.  I want to pick my players in the draft. So let's go back to the draft. I would grab a corner if like we could get a corner to be honest. They let you, the things you can buy is one superstar development for a player. And you can make a player five years younger too. Like if you had Tom Brady, you could make them five years younger.  So somebody that's under like 75, you can buy superstar development. So I don't know who I'd use it on. Miles Burke, six foot threes. This is going to be a top pick in the draft. 4.37, six foot three corner right here. I feel like he's going to go top three in the draft right here. If he's there at six, we're grabbing Miles. All right.   All right. They never get abilities. All right. All right, Steven Cosby, the Cosby man. Elite speed four, five, 40 Cosby. Do we hit him with the pill? Cosby? Oh, Cosby? Is this our number one guy here?  I can't lie, boys, the draft is looking weak as s***. So I got Kyler Murray, Omaha, hot rod master, threat detector, fearless, gunslinger, pass lead elite.  A little crazy. All right. We got Mixon. Mixon, is he cracked? We got Mixon with tank and evasive. Bro, he's definitely, bro, you know, he's getting f***ed, guys. Energizer evasive. Let's get it. Seen enough. Fant, Noah Fant. I got Fant. I got James. He's giving some more money since they're giving $40 million to that white guy. Somebody just said they got Quentin Nelson for me. For Miles Jack and my first. Is Quentin Nelson good? That's tough. I don't know who this is. What do you guys think? Am I trading my first round pick for a guard? I feel like that's super boring. I feel like Twitch and YouTube will absolutely kill me. They will laugh at me.  Secure protector and threat detector. So I can check. Dude, this is, I mean, I feel like this is a smart move. He has the 14th pick. What do you guys think about a swap? A swap and Nelson? How about I trade Jack for his 14th overall pick? I do want Nelson, but it takes away the whole draft pretty much, right? If I trade for Nelson, I don't have a first round pick and all that. I'm going to get players like my whole draft is going to be Quentin Nelson. I will never, do you guys understand? I will never have a pick in the top 10 again. Do we understand that? Okay, here's his final offer. Quentin Nelson and his first for my whole draft, first, second, and third. So I'll get Quentin Nelson and the 14th pick in the draft and I'll be done. I'll have picked 14 and I have Quentin Nelson. Chad is telling me yes. And then I can trade Miles Jack for 31. So I have 14 and 31. What do we think boys? I feel like that's good comms. I feel like that's good comms from the boys. Jack got to go with that guy. Damn, Jack is in the deal. Hold up. See now this guy clearly in the chat. So I can't get 31, but I'll have 14 and Quentin Nelson. I feel like that's a dub, boys. First of all, let me tell you this right now. I learned this from CSFM. Yo, second, third, fourth, fifth round. No, them suck. Okay. We can't even pick seven good players for the first round. I don't give this about two, three, four. I don't care to be honest. I really don't. Y'all are nasty right now, bro. I feel like it's a good deal. I think the smart move is going to be trading for Quentin Nelson. If I want to win a championship, Quentin Nelson solidifies my offense. Okay. I also feel like it's kind of boring, but if I can wind up with two secure protectors with Kyler Murray and our boys, I feel like we would go nuts. Well, essentially we have our other guy to play left tackle. We'll put Quentin Nelson at right tackle and we'll be able to like get the edge threats down. Edge threats only work on the edge. There's only two edge threats. You don't need five secure protectors. I don't know what game you guys have been playing for four or five years now. I don't know. I get pick 14. So I drop back eight spots in the draft. I don't have my second round pick or my third round pick go to, but I get Quentin Nelson and I get and I lose a linebacker. Okay. Send. All right. This is what he sent. Okay. Done. Done deal. 94 overall Quentin Nelson except I'm doing it. I sent it. I sent it. We are on the clock, boys, or we are on the next pickup. We're on deck. We're on deck right now. Five cam.  Let's figure it out, bro. We got two minutes. It's got CFM. It's not life or death here, dude. You're picking just pick one. Like the day I take the whole clock, Greg Nicholas quarterback. All right. Do I hit pick player here or pick player? Right? It's going to bring me back to my draft board, right? I'm like panicking right now. We get a little more dots and thank God. I didn't say about him for like the last five minutes. Thank God we got him. Thank God, dude. A plus finesse move, block shed, everything. Thank God, dude. I didn't say I didn't want him to get I know he I probably would have picked this guy. I probably would have picked this guy at six. I wouldn't pick them at six if I kept six. By the way, chat, do we agree that we wanted this guy was our number one outside of Cosby? Cosby was our man. Oh, he's normal. Well, I can just pay to get him superstar since I traded for a superstar tackle, right, boys? Okay. Hey, excuse me. Can I pay for my superstar? Yeah.  How about that? Let's go. Strength, speed, acceleration is there. Is it not there? This is who we would have picked if we stayed at six. The way the draft broke down, this is who we would have got at six. We traded for Quinn Nelson and got our guy at six at 14. That's what we do, boys. They bring me in to save Minnesota. They bring me in to save this franchise. We get it done on the first night. We have put pieces in place the first night. Yeah, I'm about to play right now, man.  Opening day keys. What do we got? Speak to the media. It's opening day this week. Your fresh start for every team around the league. Will you be focusing on the same? What's the key to victory? Offense or defense? Dominating offense. Okay. All right. I'm over this. All right. Oh, he's ready. Let's go.  Let's see what the boys got. Let's see what the boys got.  Okay.  Okay. Nice. Why do I have Mackenzie right there, bro? That's like a nasty spot there on Mackenzie. Move! Move! Fire move, man. I need something out of you, kid. Fire move, bro. Someone you, kid. Someone you. Move! There's literally no way I use fire move. Do I? Do I use him? I mean, he's 83 speed. I feel like I should put somebody better there. Against all these guys with seven inside shades and one step ahead, it's like, what am I supposed to do here? This is going to be a shitty game because this guy just, from that, yeah, single back bunch, we're going to get just like, run, run, run, run, run, run. Who the f*** is doing? What a playmaker from hell, wasn't it? Wasn't an absolute playmaker from hell? They give him the guy 30 yards down the field to playmaker. What am I playing right now, dude? Where is my pass rush, dog?  Good job. Round of applause for this guy. Good tackle, kid. God! That was my fault. That was user error. That was user error. I was asked for that. Look at LeMond Dodson getting in there. Let's go, man. This is a f***ing nightmare. Oh, for the learn-how theory of thumb works. Good play, bro.  Well, why am I in this league, dude? Holy s***. There's just no way on a Sunday night you kick this field. Okay. Okay. Like, the whole team came through. The whole team just, everybody just run through my backfield right there. Does anybody know? Does anybody have comms? How this dude got Elam in the game?  Yo, get me off of this s***. Oh, my God. I mean, what type of press was this? Dog.   My man got pressed that f***ing sleep like that. This is, this is disgusting.  This is, this is absolutely disgusting. This is the worst team ever assembled. I thought this team was good. I really thought this team was good on paper. Mooth. I can't lie. Mooth going kind of nuts a little bit. Hold up, though. Mooth is going nuts a little bit. Like a little bit of nuts. Like a little bit of nuts. I really don't think, I really don't think he's good.  I really have no idea. Like, okay, that was a deep, that was a deep blue out there. Okay. Okay, the boys. The boys. He don't like this. What is going on, dog? I've never seen just run by with Claypool. All right, man. All right. All right. Obviously, this is like a different mode I'm playing right now. Obviously, there's some crazy s*** going on where when you shade up, they just don't, they just run by him every time, no matter what. Apparently, I'm playing easy mode or something. I didn't press. I didn't buy s***. All right. So, no more. This s*** absolutely got awful. Claypool is 91 speed. Just roasting me. Good hit, dude. You're talented.  Jesus Christ in heaven.  Watch out for me, man. I love playing CFM. Awesome. Watch out for my cover four. Holy s***. Yeah, my three-man rush. We're playing here, dude. Dog, I can't even click. This is s***. Something is like dog. I swear to God, something's so busted right now. All right, come on, man. For some reason, I'm like hot routing. I'm hot routing DB, hot routing dumbass hot routes that I normally don't. Like, it's like I might have a conductor on and I'm accidentally doing s***. Oh my God, I'm going to lose my s***, man. The mother is, he started blocking the blip. I swear to God, I'm going to like, oh my God, man. Good tackles, boys. No, this is the worst I've ever played. He's 10 yards off of him. He's 10 yards to f*** off of him game. Like, what are we doing?  How does he have fun playing this football game? How does he have any type of joy playing this s***? Like, we're not even trying to go to ball. Like, we're not even trying to run a f*** play. Like, not another inside zone, maybe. I mean, who knows? I could break one. Like, I wouldn't even want to go to have a beer with this guy. I wouldn't, I don't even want to like, associate with this f***ing human being. I cannot believe how easily my defense is just getting ran the f*** by. God f***, dude. Oh my God, man. I'm going to lose my f***ing mind. I am going to lose my f***ing mind, Randy. Mike Martz himself just gets me with the baby. Oh, we're going to put two streaks now. There's just no f***ing way, dude. There's just, he dropped it. There is no f***ing way that he just, I mean, you cannot stop streaks. I don't know what to do about him. Like, how fast is this f***ing guy? I need to know. We were backed off 10 yards with the deep blue on the inside and this dude still just walked right by like, this is f***ing insane. He got 298 speeders. They're 5'9", all right. All right, I've seen enough. There's just no f***ing way, bro. It's just no f***ing way! Bro, what am I? I can't. Yo, take me out this f***ing league. There is just no f***ing way. He's 10 yards off in a like, dog, what? No, I can't, I can't play Madden like this. I literally can't play this game. I can't. Y'all got it. I cannot play this. There is no f***ing way that is real. I got 10 yards off of deep blue. What am I supposed to do? Like, what other, but what am I supposed to do right there other than a deep blue 10 yards off? Do I have an option? Do I have an option other than deep, like, dog? Nah, not for me, G. Not for me. I guess we just got to press and play two men under, I guess. I really don't know to stop it. Like, I tried backed off man. I tried backed off deep third. I've tried like, what are my other options here, boys? Now, back to defense. What's crazy though, if I did have knockout, bro, none of these f***ing be caught. Why is my dude, like, not manned up on? Touchdown. This is the most age f***ing f***ing ever. Yo, the deep zone don't work. Yo, the deep zone doesn't work. It doesn't work. I tried that on that fourth down. It has to be two men under. The problem was he just quick snapped. I tried to play to run a little bit and he just quick snapped the f***ing two streak play. Like, this is the most nasty s*** in the world. Good blocking, bro. That was great. Man, I got to get out of bounds there.  Move! Dude, move kind of going crazy though. Move is kind of low key, like, carrying the boys. I shouldn't even move these guys in a box like this. I really shouldn't. No huddle. Come on. You see the body? You see the body? Quezz! That's why we got mixing, baby. Come on! Come on! Ball! Oh! Gun tray, why flex? I'll tell you what. You got it, partner. You can die. You can win. I got nothing else to say to you. You want to run, run. Yup. F***ing bombs, bro. Just just bombs that play to s***. There we go. Who's that? Who's 91? Lamont? Dotson. 98. Dotson. I'm not f***ing with the safeties, bro. You burned me deep with those guys. You got it. Go get them Dotson. Go get them Dotson. You don't got nothing. Pick. Click me on the go- Dude! How did you click me on the- Like, why would they not click me on the guy that was manned up right there? Oh, this is good. This is his bread and butter right here. Oh, he don't like this. He don't like this. Oh, okay. I'm learning CFM now. I'm learning. I'm learning. Dotson, this is your time, Dotson. And I'll be honest, the long sleeves on my user are cracked. Can we go with him? Are we gonna go with this guy out here? I always miss that hit stick.  Why is the man not running with him and make me panic? Why am I panicking? Why do you not run with him?  No, but it's just so- I had to- I had to like guard outside so much right there. God, dude. This guy is gonna be happy going all the time. Let's go, Stevens. Dotson! Dotson! There's no way you're gonna be big man now.   Ah, yeah. All right, little man. That's what we like to see, little man. Yeah, the little man showing up. Oh, look at that little man playing football. Oh, he's so cute. Oh, I'm cute. My little actor. My field goal. He's so cute. Oh, a cute little man. Good job, buddy. Pat him on the back. You think he played Madden like that? Imagine this guy playing Call of Duty or something. I don't like nothing right now. I don't like being in a little field. Oh, I've never seen somebody dive like that, dude. We're walking this off here. All right, thanks. Good game. We got a- bro, I'm so afraid. I'm kicking deep. I'm kicking deep here. I swear to God. Shade up, shade up, shade up, shade up, shade up, shade up. GGs. GGs, GGs, GGs. Do I need some defense? I couldn't stop anything. Bro, I didn't- it took me- it took me how many times to realize I just cannot cover streaks. 547 yards passing. I do a pick. Those seven touchdowns. Marquis Brown had almost 300 yards on me. Just shucking the ball up. It's just- and then Claypool burnt me one time. Dog, third and 10. We are shaded up right here. I don't know why he even played like inside- outside like that. You see that? Like, it was weird. It was a weird first half. I had to learn a little bit.  Like, for real, you don't win football games by kicking field goals. You really don't win football games by kicking field goals, boys. Do we see that? I kicked no field goals. All touchdowns. He kicked one, two, three, four, five field goals. He kicked five field goals. What's crazy is if he turned one of those field goals into a touchdown, it would have been more than two field goals. See? Muth went crazy a little bit. Mixin' won us the game low-key on that two-point conversion with the run. Mixin' caught the ball. Like, I do the ball to Mixin' a lot. What do we put on Muth? Possession? I like possession. Short route running. That's what I think. What do we think, boys? We like Vert? All right, say no more. Whoa! Chat knows. Chat knows. He's a star. Like, when do I get- when do I get abilities on this guy? McKinney could use speed. That's what he really need. He got none of it. 50 points. 50 to 43. 559 yards. I did have a turnover on a pick on just a bad play by me. I overthought one play and fat-fingered it. Player stats. Here we go. Here we go. Here we go. What do my boys have out there? Kyler Murray, 547. Tutty?


Hello, welcome to SSUnitech. So, see this site and this is continuation of SSIS tutorial. So, today we gonna discuss about fuzzy grouping transformation. So, before going forward, if you haven't watched part 13 and 30 of this video series. So, I would strongly recommend to watch that video where you can understand about the conditional split and fuzzy lookup. So, let's start with fuzzy grouping. So, what is fuzzy grouping? So, it is also used to replace wrongly typed words with the correct words, like we have done in fuzzy lookup transformation. For example, if 90% records are correct data and 10% records typed incorrect, then it would be treated same as 90% records. Next is, it uses grouping technique to replace the wrongly typed words in data to correct data. Next is, it allows us to use only DT underscore WSTR or DT underscore STR data types columns in fuzzy matching. And in exact matching can be used any data types except DT underscore WSTR or DT underscore STR. So, this is our scenario. Let's assume we have a flat file which we have used in our last video when we were discussed about fuzzy lookup transformation. So, that flat file contains the information of employees that has three columns. First is first name, last name and designation, which is titles. So, in our SQL server, we have a table that contains the information of titles. So, we want to load only correct titles and we don't want to load incorrect titles, which is wrongly typed. So, as we can see, we have to use a flat file source, then we need to use fuzzy grouping transformation, then we will use conditional split and then OLA DB destination to load the data. So, let's have a look of flat file source. So, go to one folder. Then we can open this file. As we can see, it has last name, first name titles. In titles, we can see customer service representative. In our second row, we can see customer service rep dot. So, this is our incorrect title. While we are going to group between titles, then our second title will be treated as our first title. Let's have a look of our destination. So, this is our destination table and we can see it has only two columns. So, first is ID and second is occupation description. So, in ID, we can see it has identity column. So, go to an SSDT to implement the package. So, here we need to use one more package. So, right click on this SSIS package, then new SSIS package. Then I want to rename this package with fuzzy grouping. So, this is fuzzy grouping. Then we have to use dataflow task. So, we can drag and drop this dataflow task. After that, we need to double click on this. So, inside dataflow panel, we have to use our source, which is our flat file source. So, we can drag and drop flat file source. Then we need to double click on this flat file source. Then it would ask for flat file connection manager. So, click on new. Then we can browse and this is our file. So, we can select this file and then click on open. Go to on columns. So, we are getting last name, first name and titles. Now, move to advanced tab. So, in this advanced tab, we have titles. So, I gonna change the size of this title with 255. Then click on OK. Now, go to on columns. So, we want all the column. Then click on OK. So, we have done our source. Now, we need to configure our fuzzy grouping transformation. So, go to on other transformations. Then we need to drag and drop. Then we need to connect with source. Once we connect with source, then double click on this fuzzy grouping transformation. So, here we need to select OLEDB connection manager. So, I gonna click on new. As we have already made the connection. So, I gonna use that one. Click on OK. Go to on columns. So, here we wanna do grouping on this titles. So, we can select this checkbox. Then here we can see we have many options. First is input column names which is titles. Second is output alias name. I wanna use as titles. Then this is our group output alias and this is very important. So, this column will be loaded in our database. Next is match type. In match type as we can see we have exact match and fuzzy match. So, I wanna use fuzzy match. So, here we have comparison flags. So, it has many more options. So, what it mean? So, our first option is ignore flag. If we select this option, then fuzzy grouping will ignore our case. So, here as we can see we have capital letters and in our small letters. So, it would be treated as same values. Next is ignore kana types. If we select this option, then it will ignore the difference between Hiragana and Katakana. So, these are the language specific. And our next is ignore non-spacing characters. If we select this option, then fuzzy grouping will ignore the difference between diachritics and characters. Our next option is ignore character width. If we select this option, then it will ignore the differences between single byte character and double byte character. And our next is ignore symbols. So, if we select this option, then it will ignore the difference between letters and symbols. So, these are the comparison flags. So, here we can see we have numerals. So, what is numerals? So, basically we have to specify the significance of starting and ending numerals while comparing data. So, it has four options. First is neither. Second is leading, then trailing and leading and trailing. So, first is neither. So, numerals of the starting and ending position will be ignored while grouping. Next is leading. So, numerals at the starting position will be ignored while grouping. Third is trailing. So, numerals at the ending position will be ignored while grouping. And our last is leading and trailing. So, numerals at the starting and ending position will be ignored while the grouping. So, go to SSDT and I am going to use neither and move to our advanced tab. So, in our advanced tab, as we can see, we have input key column, which is our system defined formula. Second is output key column name, which is underscore key underscore out. Then similarity score column name, which is underscore score. Then we have similarity threshold value. And this is very important. So, here we need to take care. Here we have a slider. So, we can adjust the value between 0 to 1. So, I want to use 0.8 at this time. And then we have token delimiters. So, I want to use space and dot. So, in our additional delimiters, we can specify dot. Now, click on OK. So, now we need to use conditional split because here we can see in advanced tab, if the value of underscore key underscore in is equals to underscore key underscore out, that would be our perfect titles. So, we want to load only that data in our database. So, we can use conditional split. That is available inside this common. So, we can drag and drop conditional split. And then we need to connect with fuzzy grouping. So, here double click on this conditional split. And then I want to specify underscore key underscore in should be equals to underscore key underscore out. When this value will be matched, then that would be our matched output. So, we can put an output name with matched and you can specify any output name as you wish. So, click on OK. Now, I want to load data in our destination. So, we have to use OLEDB destination. So, we can drag and drop OLEDB destination, then connect with conditional split. So, here we want to load data for matched output. So, click on OK. Now, we need to double click on this OLEDB destination. Here we need to specify the table. So, our table is fuzzy grouping occupation. Then go to on mapping. So, in mapping as we can see, we have many columns in our available input. And in our destination, we want to load only titles clean column. So, we can map with destination. So, there is no need to specify any value for ID because ID is identity column. So, values will be loaded at the runtime. Now, click on OK. Now, we can save this package and then click on start. So, as we can see, we are getting 21 rows, then fuzzy grouping will perform grouping on this 21 rows and provide the output. By using conditional split, we have divided input data. And in our matched output, we are getting 9 rows. So, we can stop this package, go to on SSMS, then we can execute our selected statement. So, here we are getting the duplicate data. As we can see store manager, store manager, assistant manager, assistant manager, and then customer service representative, customer service representative. So, we are not getting data as we were expected. So, go to on SSDT. So, we had specified wrong threshold value. So, I am going to change this value by 50 this time. Then click on OK. Now, go to on SSMS. I am going to truncate this table. So, truncate table. We can execute. Now, we can check. We don't have any data right now. So, I am going to run this package. Click on start. So, as we can see, we are getting 21 rows from source and in our destination, we had loaded only 6 rows. So, go to on SSMS, then we need to execute our selected statement. So, as we can see, we are getting the data as we were expected. So, we are getting distinct titles. So, this is our actual value for threshold. So, thank you so much for watching this video. If you like this video, please subscribe our channel to get many more videos and don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.


Guys here he is as fan the priest chat. I've re-rolled but man. I look listen. I'm level one I'm so far behind. I mean I really I really got to speed this up like if I'm trying to level fast So what I'm going to do Is I'm going to do a technique Tag all of these okay at level one you move faster than them Okay, so I'm just going to kite them in a circle and wait until somebody else and comes kills them because you see I move approximately 10% faster. That's the plan See that boom just like that And then look I just keep going a circle somebody else is going to come kill them And then my XP is just going to tick like crazy. I Promise I promise I promise that's surely going to happen and if look listen I could even get a little bit of distance and Any second now somebody's going to come kill them all and then I'll just get all the XP Okay, it's called mob tagging any second now somebody whose higher level is going to probably kill them man We tell you two thousand years ago a man was sent to Azeroth To die from blizzard sins That man took on the burden of the people of Azeroth All the evil all the wrong all the bad in the world Was upon his shoulders and he was the sacrificial lamb His soul of iron was tainted but three days later. He rose again clear of the tainted soul He rose again. Yes, that's right. I'm going to continue the paladin This is basically what I decided because I wanted to re-roll priest, but the reality of it is I Kind of want to play priest because I was like I want to mind control people this and that but like And it'd be kind of funny for some things, but I think this is the last time I'm playing vanilla Whatever one I actually I'm gonna like kind of try hard it to try and get to level 60 without dying I don't think I'm gonna do it for real. It's gonna be really hard to get to 60 without dying once, but That's what I do. I play paladin. That's that's my class I know it like the back of my hand and I think that's what a lot of people want to see too I did the bit and I threw because I wanted to do that, but then I Pretty much got cold feet like 30 minutes right after I get it So that's why we're gonna go ahead and keep going with the paladin today because of I mean season of mastery is still going on I still want to do a little bit of this and just kind of like Clarifying get to a point of like okay. We're hard committing sticking to this. No, that's just what I think I think this is just better.  Is it really you his eye I bear The mark upon my chest of the red paladin the death was a mere Boy to distract our enemies. Wait. Why is your name strap on?  I Do not pretend to fully grasp their motivations There is no reward for a life of such hardship. Perhaps that is what makes them so fascinating so admiral Are you one of soul of iron? I am ah Yes, male for the king of veterans gloves. Thank you spritz. Thank you. Thank you very much spritz gloves fit for a king Hmm. So yeah, I mean that's basically what happened is I Wanted to re-roll in a funny way do a bit But then I kind of got cold feet afterwards and I think really at the end of the day Like that's just what I want to do is I want to play a paladin. I like playing paladin. That's kind of my class It just is what it is, you know a weapon fit for a king My king it is I crafter of the great acts of pepega as you grow in strength and power I believe you deserve equipment that is fit for the strength as our one true king I present to you the sword of pepega may it serve you well PS I've included extra ret coin so you may train the ability to wield the sword like a true king. Ah, yes Thank you pepega. Thank you very much. Very good most excellent Mighty pepega may the light shine upon your path Okay, so we're gonna pick up engineering Engineering and first aid Frick hey, by the way, if you guys want to join the guild, this is like a viewer kind of community thing if anybody wants to join the guild Right now it's open invites anybody can invite anybody into Elysium. We're playing on obsidian edge So anybody can play why don't you want to hit 60 fast because that's just not what I'm doing I can't I literally don't have the time I host Like four different shows Well three different shows on twitch Every single week, I guess it's different right like I don't play the game like that anymore. Yo, that's legit lots of great people in it Yeah, I mean at the end of the day like it's like our community, right? So it's just fun and then and then people can use the discord join the discord and and there's a so in the discord There's a welcome channel in The discord you can just click this right here and it gives you access once you click this to the guild channels So it doesn't like dirty up the discord But you can go in here and you can talk to people you guys can there's different lobbies if you guys want to make groups and stuff But yeah, I just joined the discord and you can click that and then you can go do that so Okay, so what I'm doing is I'm going around. I'm kind of running some errands Get my heavy linen bandage training so now I can make heavy linen bandages So I need linen cloth to do that Where is the where's the miner? Oh, there he is? Deep mountain mining killed Show back to ten. Yeah, I got the little ten like two hours. I We ran around we boosted it a little bit so We just we just ripped right through it. Oh, yeah, I don't have the Okay mining trainer I got the mining supplies


So again, as I mentioned before, we can take water levels to work out what's happening with how water wants to move through the landscape. We can also take chemistry samples and send that off to a lab to figure out the dissolved salt load. We can also do analysis on the isotopes in the water molecule, so oxygen 18 and hydrogen 2 predominantly, to try to track how water is actually moving through the environment. And we can also use radiogenic isotopes. So those are isotopes that decay over time for us to then try to put a time frame upon which processes are occurring. So throughout these processes, you actually need to continually monitor. So when we plug all this information into our models and it projects a certain scenario or projects a certain way that the system is going to adapt to having groundwater extracted out of these coal seams, we still need to keep collecting information through monitoring to actually see is what is actually happening in the environment, what we thought was happening through these models. And if it is all hunky-dory, if it isn't, then we need to step back, have a look at the data, reassess how does this new data fit in with the data that I had previously? And what does that now mean for how the models need to be developed to project potential behavior in the groundwater systems, in, you know, adapt what we're doing and then implement that new framework, monitoring, review, adapt, implement. And this is a cyclic process that keeps happening all the time, not only in coal seam gas, but pretty much any activity that requires any type of environmental disturbance. And it really does require not only the proponents who want to extract the coal seam gas for use, but the communities, the researchers and the regulators to all come together to build up this data set, to continually review this data set and to continually implement changes and annotations as we find out more about how not only the system operated prior to coal seam gas extraction, but how it is behaving in response to that disturbance.


Have you ever faced a situation where someone deleted WhatsApp messages, images or videos before you could see them? Well, I've got a secret tip for you to recover such lost messages. It's called Watchshed app recovery app. Simply download Watchshed app recovery from the link in the comments or the play store. Grant the necessary permissions and the magic begins. Now whenever someone deletes messages or media on WhatsApp, open the Watchshed app recovery and uncover the truth. You'll not only see the messages with timestamps, but also those deleted images, videos and audio files. It's incredible, right? Don't wait any longer. Download Watchshed app recovery today and never let anyone hide what's been said from you again.


In this presentation, we will enter some typical type of expenses, including things such as the phone expense and the utilities expense. We're going to do this in a two-step process, first entering the expense as we normally would for a for-profit type of organization, and then at a later time, we will allocate and break them out in accordance with the classes that we have set up. Let's get into it with Intuit's QuickBooks Online. Here we are in our not-for-profit company, not-for-profit organization dashboard. We're going to go on to Excel to think of our objective. We're now on Tab 8, so we are on Tab 8. We're going to enter some of the normal kind of business transactions, normal type of expenses you might consider in either a for-profit or not-for-profit type of organization. So we've got the telephone expense, and so if we're going to be paying something like the telephone bill, we're going to have a typical kind of setup for this. We're going to be writing checks. Therefore, cash is going to be decreasing, credit to cash, debit to the telephone, and so if we had obviously this one, the effect on the accounts then would be a debit to the telephone expense and a credit to the cash. Now note the difficult thing about these transactions is that we also are going to have to record these and break them out by category. So note down below where we have our statement of activities on the expense side of things. We're going to be breaking them out with restrictions and without restrictions and so on, and this breakout, which we will do by classes, and then we'll further be breaking out the items that are without restrictions into what they are used for, breaking them out by function. So note when we enter this into QuickBooks, we will typically see the items as their nature, their nature being like the rent expense, the salaries expense, that's what they actually are in essence, that's their nature, and then by function what they're used for, programs and other admin type functions, including the program of education, community service, and then the admin function and the fundraising. So what we need to do is then enter this information like we normally would, assign them to the proper account, use the classes to then assign them out as what we'll start off with unclassified, then we'll use the classes, then we'll go back in there and assign the classes to these items so that we can then break out the more detail for the classes. So we'll use the class feature within QuickBooks to do this. We're going to do this in essence in a two step process. And I think this is how you would want to do it in practice because it's just going to be a little bit faster if you have to do this two step process. One, I'm just going to enter it in there and I'm not going to assign a class. And I'll just enter everything in there so that when you do the data input, you can assign someone just to, hey, just do the data input. Don't worry about the classes. It will then populate into unclassified and then go in there at the end of a period of month or week and then assign the classes going from the income statement by class back to the information to assign the classes. We're going to do the first of those steps now, which will be similar to just a for-profit organization just entering the expenses. So telephone expense, we're writing a check, telephone expense. Postage, same thing, cash is going down. We're going to put the other side to postage expense, just what you would expect them to go to in account format by nature. Then we'll think about by function later by program and so on and so forth. And then cash and the utilities, supplies, cash goes down. And then we bought supplies on account, which means this time accounts payables going to be going up instead of cash going down. And that's going to be it. All right, so let's do it. Let's start with the telephone first. I'm going to highlight them green as we go. So the last green one, that's the one that we're going to be working on. We'll start off with the telephone, with the telephone. Then let's go on back over to QuickBooks. Going to hit the plus button. Now if we're paying this by check, obviously we would write a check. If it's some kind of electronic transfer that we're just entering into the system, we could simply go to the expense here. Also note, if you're entering into the system, you might use like a bank register. You could use the register as well to quickly enter them into the system as well. I'm going to use the expense form. So let's open up the expense form. We're going to say that Verizon is our telephone company. So I'm going to type in the vendor was going to be Verizon, Verizon. It's going to be coming out of our checking account. So make sure that you got this drop down going, whoop. I didn't add it. V-E-R-I-Z-O-N, Verizon. Is that how you spell Verizon? No, that's not how you spell Verizon. It's supposed to be V-E-R-I-Z-O-N, I think. So there it is. And then I'm going to say save. And then I'm going to select the drop down. And this is going to go to the checking account. So we'll pick up the old checking account here. I'm just going to tab through and the date then let's make this 0-1-3-0-2-0. So it's towards the end of the month here. It's going to be an electronic transfer, we're going to say. So I'm just going to use cash, the payment type or possibly how we should leave that blank. Since it's cash. And then I'm going to go down and we're going to be entering then the telephone. Let's see if they have one for us. Do they have anything like a telephone expense? I don't think they give us a telephone expense, which is a little unusual to me. They do have the utilities. This is where we'd have to think, do we want to group it in utilities or break out the telephone? Typically, I think most companies break out the telephone out from the utilities. So that's what I'll do. But that's the method that you want to think about with these expenses. First, the expense categories that they gave us. Can we find one that's appropriate there? If we can, then we probably should use it. If the name is slightly different, then we can adjust the name in the chart of accounts. It's probably the best method. And then if they don't give us the account we want, then and only then, after we've kind of considered the options should be add an account. Otherwise things get messy real fast if we add, if we just keep on adding accounts. And also, obviously, if you're doing the second month of operations, you should always be checking the prior month to see what happened there, to first consider consistency. So you want to be consistent as much as possible. If you make a change, then make sure that you are doing it for a reason and then implement that change from that point on forward. All right. So then I'm going to say other, I'm just going to say other business expense here, because this is really the key point that we need on the name. And I'm just going to call it telephone, telephone. There we have it. And then I'm going to say save. And that looks good. And the amount, let's pick up the amount is for 6,200. So we'll pick up the amount 6,200. And then we don't, I'm not going to put a billable, not customer. And I'm not going to have it as a class because I'm going to leave it to go into unclassified. And then we're going to go back in and classify it at a later time. So what's going to happen here? Expense means the cash account is going to go down. This is actually going down from the checking account. So the checking account is decreasing, of course, other side then going into the income statement profit and loss. It's going to go into the account of the telephone expense. And it's not going to be classified, therefore going into a default category of unclassified, which we will then go into at a later point, later presentation at the end of the month, one by one and reclassify that entire column at one time. All right, let's say save and new. We're going to do this a few times. So I'm going to say save and new. I'm going to say yet. Thank you for letting me know about that. QuickBooks, but that's okay. And then we're going to go into the next one. So I'm going to go into the next one, which is going to say, okay, now we're paying for printing and postage, printing and postage. I'm going to make this green to indicate that's the one we are on, to lessen the likelihood that I'll pick the wrong number or something like that. But I could still do it. But I really think the colors are helpful. They make it, they reduce the, reduce it. So I'm going to go back over here and then we're going to say, this is going to go to, let's say staples, staples. That's a supply store staples. I think that's spelled right. It's going to be a vendor. I'm just going to set it up quick setup here. It's going to come out of the checking account. Once again, we're going to keep it at the date at the end of the month. I'm not going to put a payment type this time because we're going to say it's an electronic transfer. And then I'm going to say it needs to be going to printing and postage. I'd like to go to printing and postage. And let's see if we have an account over here that's like something that like office supplies, it can go there. So I could put it in the office supplies if it's postage. You know, I might want to put it in there. It might be too small for me to break out. Maybe I don't want to break out the postage. But I kind of like to track my postage in separate account. And this is kind of the how I would mold things over if you were thinking this out. You know, do I want to, you know, do I want to put it in there? Is it worth it for me to put it into another account? I think it is here. So I'm going to have, I'm going to have another account for this one. I'm going to say that's mad another one. And this one's going to be an expense and I'll have the other detail, which I'll just say is like other for here because I don't think that account, it doesn't do much of anything. So I'm just going to then say this is going to be printing and postage, printing and postage. Then I'm going to say save and close. And the amount, the amount is going to be for 12,900. One, two, nine, zero, zero. And then I'm not going to have any class. And what's this going to do again? Of course, it's going to be decrease in the check and account. The other side going into an expense account that being printing and postage is not going to be assigned to a class. Therefore, when we run the profit and loss by class, it's going to be an unclassified account, which we will then classify according to our percentages all at the same time at a later time, later presentation. All right, let's do it again. Save and new. And thank you QuickBooks for reminding me about that, but we have thought about that. And now we're going to go then to the utilities. Utilities. All right, that's the next one. I'm going to say this is our electric company. We pay Edison. It's our electric company. So I'm going to call this Edison, Edison, and add that vendor. Now, obviously, if it was the second month of operations, sometimes the accounts would populate for us and it would be easier for us to enter this information. And it'll make it easier for us also to be consistent through the fact that when we have the same vendor, that information will populate on the second month. So just keep that in mind. It'll help you with the consistency. So we have the checking account, January 30th, and we're just going to scroll on down here. Now, this one is the one, like the electric, that's what I put into utilities here. So I'm going to put that into utilities. I'm basically, utilities for me most of the time would be the gas and the electric. Gas and the electric on the utilities. So I'm going to go utilities. That's the one we want. And then the amount, the amount here, let's check out what is the amount. 9,100. So 9100, missing a zero, 9100. All right, what's this going to do? It's going to be decreasing the checking account. The other side is going to go to an expense account on the income statement or profit and loss. That being the utilities expense, it's not going to go into any class. And therefore in the profit and loss by class, it's going to be in an unclassified area that will then classify all at the same time at a later point in accordance with our percentage breakout. All right, let's do it again. Save and new, save and new. Thank you QuickBooks for the reminder, but it's okay. And we're going to go back on over here and do this again. So now we're on the supplies expense. So now we have supplies expense. I'm going to make that green. So I'm going to go back over. We're going to say supplies. And I'm going to say this came from office depot. So I'm going to say office depot. And it's going to be from the checking account and same date. Now I wanted to use office depot because this is going to highlight kind of a problem that you just, you need to be aware of. Last time we used office depot, we put it to the account of property, plant and equipment. And so that's what it's trying to help us out. And that's great because it helps us out with consistency and say, Hey, last time you put it to here with the 13,000, do you want to do that again? That helps with consistency. However, this is an exception when we do not want to do that because last time we put it to equipment because we purchased a large amount from office depot. And this time we purchased a smaller amount which we just want to put into office supplies. So note that especially in the second month of operation, this would have happened with most of our transactions and most of the time it would have been very helpful. But you can't completely rely on it.  So I'm going to hit the drop down and say, Okay, that's not where we wanted to go. I want an expense account. So we're going to look for an expense account. See this, I think we saw that office supplies before. Here we go. Yeah, office supplies and software. It's going to office supplies and software. And we'll pick up the amount is not 13,000. It's 500. So 500 for that. What's this going to do? Decrease the check and account. The other side going into the expense account for the office supplies. It's not going to be classified into class. It's going to be an unclassified. We will class it all later in a later presentation. Let's say save a new and say, Okay, thank you. Quick books for the reminder. And then go back on over here and say that one is done. Now this one's a little bit different because this one's going into accounts payable. So it's going to be supplies again. But the other side, it's a bill. So this is the bill because it's not coming out of the checking account. So I'm going to go back on over and I'm going to close up the check here. We don't need or the expense. We don't need an expense. We need a bill type of form. So I'm going to hit the plus button. Now we're going to go to a bill form. Now whenever you see a bill type of form, it means accounts payable is going to go up. That's what a bill means. So we're going to take it. It's going to go like we can imagine. We're going to say this is going to office depot. We get to imagine office depot billing us, sending us an invoice or bill. And we are now going to take that and put it into our system, not pay it yet. We're just putting it into our system, increasing the accounts payable. So we'll put that in. We're going to say terms. I could say, all right, terms. I'll say net 15. We're going to say the bill date is 130. And there we have that. And then we're going to pick up the category. And so now I'm going to categorize the supplies. Now you might say, hey, look, you're using office depot. Again, why didn't it add the category of supplies? And sometimes it doesn't when you jump over from like an expense item to a bill type of item. So if we had entered a bill in the past for office depot, then it would most likely populate here. Last time we did the expense form. So I'm going to hit the dropdown. We want to populate the category to be office supplies or that supplies item we had again. So let's see, office supplies, that's the one. And we're going to pick up the amount. So we're going to go back on over to here. We're going to say 4500, 4500, no class account again. So this is going to be the same thing. What's going to happen? Well, it's going to be increasing because it's a bill. The accounts payable, a liability account. Then the other side is still going to go to an expense, increasing the expense, decreasing the net income. And it's not going to be going to a class. And therefore it's going to be an unclassified when we run the report by class. And we will then classify them at a later point. So let's say save and close. And I think that's it. So I'm going to say save and close. Thank you for reminding me of that QuickBooks. I'm assuming that's the same message. I hope it is. So I'm not messing anything up. QuickBooks is like, hey, I'm trying to tell you this. Okay. So we're going to go back on over here and say, let's go to the reports. Let's check off our reports or check out our reports. We're going to go into the balance sheet. Let's open up the old balance sheet here and scroll up top. Make sure we're in January or January is included. I'll go all the way to the out to the end of the year, January through December, run the report. Then I'm going to go back up top. I'm going to duplicate the tab by right clicking on that tab and duplicating it. Then I'm going to go back to the tab to the left. Let's do the same thing for the income statement. We're going to go down to the reports on the left-hand side. Open up the income statement, the PNL, the profit and loss right here. And see what that looks like. Let's scroll back up top. Make sure our dates are sound. January. Let's make it through December 12, 31, 2, 0. Run that report. All right. Now let's go back to the balance sheet. Let's close up the old hamburger and then hold down control, scroll up a little bit, get back up to that 125, 125%. And then in the checking account, it's negative because again, we still haven't deposited this undeposited funds, which I should really do, but in any case, we're going to keep it here. We're in the negative number, but we're not going out of business here. It's just we haven't recorded that last thing. It's okay. The not-for-profit is still flowing forward, even though it's a not-profit with no-profit things. Okay. So we have the items here. There's Staples, Verizon, Office Depot, Edison, and so on and so forth. Here are our items. Everything has been included, I believe looks correct, except for of course the one that went to the bill, as opposed to the expense forms. If we go into any of these forms, we'll actually go into that expense form. If you needed to make any changes at that point in time, it is possible to edit the form once you go back into it.  And then the other one that we entered with a bill is going to affect the accounts payable. Here's the accounts payable form. Let's open up the old accounts payable form. There's the bill. So anytime you see a bill type of format, it will be increased in the accounts payable. Bill means increase to accounts payable. The bill and the expense and check forms look very similar, but that's the major differences. Bills and checks or checks and expenses will be decreasing the cash account. Bills will be increasing the liability account. All right, let's go back on over to the balance sheet. Now let's go to the income statement and close up the hamburger on this side, going down to the expense items. So here are the expenses. Now note here, they're listed out by nature. We call it nature versus function. In other words, what they're used for versus kind of what they are. So these are basically, this was a software type expense.  When we think of the not-for-profit organization, we want to think about it in both ways. Note that we're going to have in our format here, we have this statement of activities broken out between restricted and not restricted. So we'll think about that by class. We'll use our classes to think about that in QuickBooks. And then we have them broken out by what they're used for here. So notice when you're giving this to the board of directors, you've got to think, well, what would be easiest for them to see? I need both. I need for them to see it by form and by function for reporting purposes to get everything in there for regulatory reporting purposes oftentimes, which means I need something like this, having it by nature here and then by form.  This gets a little bit overwhelming. So you really want to start off with something different and then give more detail because this will bog things down. So we need to, in essence, break out by nature and by form in some way with our reporting. So let's go back on over. You can see here they're by nature, which is usually what most people consider to be thought of in, but it can be useful with decision-making to then think about, well, how are we allocating that out to the function? What is it what we actually do, the programs and the administrative functions? Because when you're looking at a not-for-profit organization, just realize that one of the things people are really concerned with is if you're taking this money, how much of it is going to the programs versus management in general, which is really going to the workers, because that shows how efficient the program is. So you really want to think of, well, how much of this funding is actually going to what I'm trying to donate for or what we want to actually do, the purpose of the program and not to the administrative or you want an efficient amount going to the administrative. So if I go back on over here, we have that. Now, if I go into any of these items, that will, of course, take us back to the checks or expenses that we have written. So let's go back up top. Now, what if we want to break this out by class? If I select the drop, I drop down and break this out to by classes, and that will help us to see the function. So we saw it by nature. Now, this will help us out to see it to by function. However, note that we didn't assign classes yet, you'll recall. That's why I kept on giving us those messages every time we entered it. It's an unspecified. So we have them all in unspecified over here. That made the data input a little bit easier because I didn't have to break out all these percentages to go in by class. But we're going to need to basically allocate these to what they're used for in accordance with some kind of allocation base that we'd have to determine within the not-for-profit organization. Our determination was this is going to be our percentage breakout. 40% education, 20% community service, the admin or management in general 20, and then the fundraising 20. So we're going to have to go back in here, then, and allocate this out by class, which it's a little time consuming to do, but again, I think it's easier to do. It's not too bad. We're going to click on each of these, drill back in on them, and then break them out by class. So we'll do that in a future presentation, but I think it's a little bit easier to do the data input when you're just paying the bills, just pay the bills. And don't worry about the class. And then you can run this report and easily see these items that have not been specified, have not been put into the proper classification, and then simply go back in and reclassify them as we will do in a future presentation. So that will obviously be a good time, and we'll do that later. So that's going to be it for now. Let's get out of here.