Hello, and welcome to the audio guide that will help you work through your spreadsheet assignment. I think it's called Excel Training A. In any event, it's the first assignment. This audio tutorial will help you become familiar with the spreadsheet and how they work and will walk you through a little bit, a little portion of each part of the first Excel assignment.  This particular spreadsheet software that I'm using is Microsoft Excel 2007. There's a number of different kinds of spreadsheet software that you can use. Microsoft Excel is the most popular. But if you don't have Excel on your computer, I believe there's instructions to help you download OpenOffice, which is a free version of a spreadsheet. It looks slightly different. This portion of the worksheet will look very similar than the numbers over here and the letters over here. But this top portion will look different, but it has the same functionality. It's just that the menu buttons will look slightly different. This is a spreadsheet, and the spreadsheet consists of cells. You can use your mouse to click between cells. You can also use your arrow keys to click between cells. Particular cells are identified by their row and their column. The row is always a number, and the column is always a letter. The following tutorial is going to work you through the rest of the assignment that you need to do. In order to locate that, and you'll be able to download this assignment and follow along either now or later, the sheets for the assignment are listed down here. You can click them and you can bring up the different assignment pages. I started on a blank sheet just to start with basic familiarity. If you ever are curious about adding additional sheets, you can usually push a button right here that's Insert Worksheet. Click that, a new worksheet will appear. You can drag the order around there as well. Let's begin by looking at the very first exercise, which is called formulas. You click on that formula worksheet and that brings that to the front. This is the basic instructions for how to enter formulas into Excel. I have put here the symbols, the operators, and what they do. I guess before we get there, if you've never used Excel before, I should point out that when you click in a particular cell, you can see what's in that cell right where it is, but also this formula bar up here is a very helpful place to look and see what exactly is in your cell. In order to enter data into a cell, you just click on that cell and start typing. Push Enter to enter the data. If you want to delete the data, just highlight the cell and push Delete. You can type numbers into the cell, etc. I assume that you have some at least very basic familiarity with how a spreadsheet functions. In this exercise, I'm simply asking that you follow the instructions over here for the particular numbers here on the left. For example, I would like you to write a formula in this cell that adds the numbers in column A and B. And how does that work? Well, in Excel, whenever you want to enter a formula, you need to use the equals sign as the first key that you enter. The equals sign tells Excel that what you're about to do is enter a formula that Excel should calculate. So what we'll do is we'll click on the cell that we'd like. We'll type the equals button. And then we will tell Excel which numbers we would like to add. In this case, we'd like to add 47 and 21. So we type equals, then we click on the cell 47. And notice what that does. That tells Excel to look at cell A13, the one that we highlighted. And then we want to add them. So to do addition, we use the plus symbol. So we push plus, and then we click on this cell, and that is cell B13, as you can see right there. So what this formula is doing is it's telling Excel to add whatever's in A13 plus whatever's in B13. In this case, it's 47 and 21. That's the end of the formula. We push enter. What appears? Well, what appears is the solution to the addition problem, 68. And a simple hand math would show you that that is in fact true. Now back to what I was saying earlier, if you click on that cell and you look up at the top, you can see the formula that you entered. Now that's very helpful because all you see down here is the number. But up here, you can see the entire formula. One of the reasons Excel is really powerful is because you can leave this formula here and you can change some of the numbers in these columns and the formula will still work. For example, if we change 47 to 40, just type a new number in there, the formula automatically recalculates and adjusts the new information and the answer is 61. So let's put it back to 47. Now for the rest of the assignment, you should complete and submit to your instructor. You will finish by entering the proper formulas in these cells. One of the ones I want to help you with, and by the way, all the operators are up here. So you add addition, subtraction, multiplication, division, raise the power. If you can't find that on your keyboard, that's shift. And the number six most often. But one thing I want to help you with is how Excel recognizes order of operations. If you've done basic math, you should have an understanding of order of operations and the use of parentheses. But let's just do an example to make sure you're getting it. And let's fill in number six. Number six says, raise a plus b to the b power. Well, the first thing we need to do, remember, is to type equals to tell Excel we're entering a formula. And then we need to use a parenthesis. Because first we need to add a plus b, and then we need to raise that entire amount to the b power. In other words, we want to raise four plus two, which is six, to the fourth power. So we type, we click on this cell to add, and we push the plus sign. And then we click on that cell. And then what we do is we close the parenthesis. And then we want to use the power operator, which is shift six. And then we want to click again on this cell, b18. So we have the correct answer, which is raising the a plus b cells to the b cell power. And then we push Enter to finish it, 1,296. Now, if we had what would be an incorrect way, the incorrect way to do this. Let's just delete that so I can show you the incorrect way. It would not be correct to simply type equals two plus four, excuse me, four, which is the b18 cell. And then if you raise that to the four power, that's not correct. 258 is not correct. Why? If we click on it, we can look up here, what that's doing is that's because Excel follows order of operations, it's taking this amount, which is four to the fourth power. It's b18 to the b18 power, whatever's in that cell. And then it's adding a18. So if you need to review basic order of operations, that's something you should review. That's not something that's something we consider a prerequisite for this course. OK, so for the rest of your assignment, you should fill in the rest of these cells. And once you're through with that, you can check them on a regular calculator. That's fine, just to make sure you've done it all properly. Move on to the next sheet by clicking the next sheet. This sheet is designed to introduce you to the concepts of copying and pasting formulas in Excel. And formulas, Excel is very powerful because you usually only need to do something once, and then you can copy it along and get the results. And I'll show you by an example. The instructions say, first, to write a formula in cell b17 that adds the sales from store A. So what it wants is it wants the total sales right there in the total column for store A. And there's two ways that we can do that, the long way and the short way. The long way would be to type the equals sign and then click on each cell inserting a plus in between, like so, and then type in enter, 222. That's the long way, but there's a short way because Excel has a bunch of built-in functions that do special things. The one that you're going to use most often is sum. It's basically telling Excel to add a column of numbers. And so we'll delete this, and we'll show you that function. You type equals, then open parenthesis. I'm sorry. First you type equals, then you type sum, and that's a special code word that tells Excel that you're about to give it a range of reference cells to add. And you need to then use an open parenthesis. Now, this parenthesis has nothing to do with order of operations. It's simply how Excel is expecting to get the information that it needs in order to follow the instructions that you're giving it. And in this case, we type the open parenthesis, and then we highlight the entire range of cells that we like to add. And then we close the parenthesis, and then we push Enter. And it does it for us. It's much faster, especially if you have a very large column of numbers. For example, you could have 1,000 numbers that you're trying to add, and you wouldn't want to individually type equals plus that number, plus that number, plus that number. The sum function is what you want. Again, if you forgot what it is, click on the cell, look up here. It says equals sum, and then open parenthesis. And then what I did is I just used my mouse to highlight the row, the column that I wanted. And then I pushed Enter. Now, here's the copy and paste beauty of Excel. Rather than type again in each of these cells equals sum, open parenthesis, and highlighting the range, Excel can copy and paste formulas, and it does it right. Notice first that we are adding the information in column B. That's this column right here. It's because all this data is in column B. Watch what happens if we simply click on that cell, find where your Excel does a copy and paste. Control C is good for copy. Control V is good for paste as a shortcut. But we can also go up here to copy, or we can right click and find copy there. I'll right click here for you. We're gonna copy it. Then we're gonna click it there, and we're gonna paste it. And watch what happens. It adds the next column of numbers properly. And how does it do that? It's because when you told Excel to copy and paste it and you moved the formula over one space, Excel moved everything over one space. Whatever it had up here, it simply moved it over one space. And that's why now it says C instead of B. This column says B, this column says C. To continue, we can simply copy this again and paste it in there, and we should get the correct answer. Likewise, if we go over here, we can also sum horizontally equals sum open parenthesis and then simply highlight the horizontal row. Type enter. Again, that's correct sum. Again, you can copy and paste this formula. Simply copy. And this time, rather than doing one at a time, I'm just gonna copy the highlights whole area. I'm gonna right click, I'm gonna push paste, and there it is, all the formula moving all the way down. Finally in the last row, it doesn't really matter whether we've copied down or copied to the right, it's going to give us the same answer. We'll just copy this way, paste. And this total should be the total both ways. One thing, one other thing I wanted to point out, pay attention now. When I click on this cell right here, we look up and we see that it's adding this row, and this row is identified by row 12, columns B through D. That's why it says B12 through D12. When we move down, watch what changes. Last time when I showed you, it was the column letter that was changing because we were copying and pasting from left to right. But when we copy and paste from top to bottom, the row number changes. Notice this changes to B13 to D13, B14 to D14. Why did it do that? It's because when you copy and pasted and you moved the formula down one cell, Excel knew to move all the arguments in the formula that the portion and the parentheses down one cell also. So if you copy and paste down, Excel changes it properly so that it moves down. If you move it to the right or left, Excel changes it properly so that it goes to the right or to the left. So you can work on that in your assignment now as well. Moving on to the next. The next tab is teaching you about how to use something called the data table. But I think I'm gonna put that in the second AVI file just so the files don't get too big. So that's coming up in another file.


And welcome back to theCUBE. Here, live from the Lakehouse, we're doing wall-to-wall coverage from Databricks' data and AI summit. And I'm so excited to be joined by Jamel Brown from First Orion. Welcome to theCUBE. I know it's your first time, and really excited, because I met you first yesterday at the press briefing, and you just absolutely had such great answers and great information. I think that people who are coming to this summit could really benefit from. And so, why don't we first, what's First Orion about? All right, well, thank you for the kind words, Rob. Yeah, so my name's Jamel Brown, CTO at First Orion. First Orion, we're all about bringing bringing transparency to the phone call. So we are responsible for scam and fraud, spam protection in the phone call, as well as brand identification for business to let the caller know who they are. We want people to be able to trust their phone and answer the phones again. Yeah, and it was funny, because we were all saying that it's so many times, I just push, you know, send to voicemail, and I love the fact that what you're doing, and I think what was super interesting is that the use case and the amount of data you have to actually go through to identify that the caller is legit, is amazing. And can you take us through kind of like, what does that look like from it? Because it was like so many per second, and how fast it has to happen. Absolutely, so we received, we analyzed about 100 billion phone calls annually. For each phone call, right, the number of packets, think about the, if you think about like an email, right? When you see an email, you only see kind of the UI, but behind the scenes there's all this information in this packet. It's the same thing with the phone call, but a little different. With the phone calls, for every one phone call that we receive, there's at minimum three packets that we receive that we then have to tie together. So we're talking about, you know, hundreds of, a factor of three at least for each phone call. So over 300 billion records that we then have to basically tie together, join, and then we analyze that data. So we source data from a number of different places in addition to the data that we see, and we tie all that together, and we basically fingerprint each phone call. By generating this fingerprint, we're able to determine statistically whether we think this call is a scam or not, or a different type of call. We can tell other, like the category of the call, whether we think it's a telemarketing call, or a marketing call, or a banking call, right? So we have a whole host of data that we apply to each individual phone call, and ultimately we have to respond to that phone call within 100 milliseconds. Wow, yeah, and I think that was the amazing part is that you have to do this at such a rapid pace. And I know that the Databricks folks were saying that you really push them on their technology. You're really using it, you're always leaning into all of their technology. And we were talking, you said you'd use Dolly, now you're looking at some of the Mosaic ML stuff that's coming down. Talked about how that journey is gone. Yeah, so Databricks has been a phenomenal partner. You know, like I mentioned in the press briefing, I've been familiar with Databricks since 2015. Actually, 2015 was my first Spark conference as well. But, you know, we've had a long history together. And at first to run, you know, we hit a point where we weren't really able to scale very well. So then we switched over to Databricks, and it's been, you know, a blessing ever since. We've been able to accomplish a lot of things with a small set of people, because we are a small company. We don't have infinite resources to go boil the ocean. And so, you know, for example, you mentioned our Dolly use case. With Dolly, we've been experimenting, we built out an internal kind of knowledge base for allowing our engineers to onboard more efficiently. So instead of going out and searching through confluence, we're now able to, the engineers come on and they can start asking questions of the things that they need, whether it's a product, or it's actually setting up their machines. This has presented a phenomenal degree of efficiency. You know, we've seen, we did some measurements, and we've seen over seven and a half times productivity gains to a point where, you know, we tried to extrapolate, it's kind of hard to ask or answer the question, how much time does someone actually spend looking up information during their job, right? But we got to a point, you know, with a very rudimentary, very conservative estimate of around, we were able to generate around $900 in savings per employee. And so that's been a God's sense to help us. And then also, we also found, you know, they talk a lot about these LLMs, these AIs hallucinating or presenting wrong information. And while that's obviously true, there is a component of that. We've also seen situations where an engineer goes out and he has a question about how a product works. He goes, he looks it up, and even he can be wrong, right? He can derive some incorrect assumptions based on the documentation that he's reading. And so, you know, humans are just as likely to be wrong as an LLM is, but, you know, so there's always going to need to be that level of vetting concerns. But, you know, otherwise, it's really helped in our rolling out of this internal project. Yeah, no, I think that hits on what Ollie was talking about, you know, hey, you have to be able to trust it. You have to be able to. And that's been a big theme. And I think when we look at it, it's not only the ethical use of it. It's, this is how do you work together? How does machine and person work together to become, you know, one plus one equals three? And I think that's been a big key to what we've been seeing in all of the different events we go to. It's not about replacing people. It's about making them more efficient or go fast. Exactly, augmenting, yep. Yeah, and have you started to use any of the other stuff out there, like co-pilot or from Git or how deep into AI, like going that direction, have you guys gotten it? So our team, we're not using co-pilot. We're like a Bitbucket shop. So we're not using co-pilot at the moment. We, most of our AI usage is in either, we use AI in some of our scam prevention. We use some AI in our vetting applications. So we have to vet businesses. This project that I just referred to, we call it Maestro Internally. That's kind of our first internal tool that we've developed to help with the employee side of efficiency gains. Yeah, and I think that's huge. And having been, you know, I was at AWS and I remember getting there and trying to figure out how do I set up my environments? How do I get really going? How do I know what to do? And this is all during COVID as well. So I think it's, you know, going through and making people more efficient, like you said, I mean, quantifiable to $900 per employee. That's huge. And that was just one use case, right? Yeah. Like, so yeah, we're really excited about what we're seeing early on and, you know, Databricks, especially with all the announcements this morning, it's going to get even easier for us to deliver on these things and make people's lives easier and us ultimately delivering better products. Was there anything that stood out to you, any of the announcements today that stood out to you? Yeah, everything.  Hey, what happened to this process? We see that a lot where a job may fail and it's really, you know, it kind of takes someone who really has experience with Spark to be able to dig in and understand at times. Now being able to ask these questions or just automatically let us know and then be able to ask further qualifying questions about the issue that happens is going to allow us to make our products much more stable. Yeah, I thought it was really neat how you could figure out where it was, the data was coming from, how the failures happen. I thought the woman who did the demo did a really great job with it. I thought that was fantastic. And in fact, I thought all the demos that were done today on the stage were really deep enough that somebody who's technical could get a little bit out of it, but not too deep that somebody who wasn't overly technical couldn't follow along. Oh yeah, they've really mastered that heart for her. Seriously. And it always leads to a lot of extra questions. Like, so I've got my lead architect here and immediately, you know, since the keynote was over, we're sitting in the back of the room kind of strategizing on who we're gonna go seek out and start pinging about, you know, what they're presenting and try to get some more information out of them. Start to push on getting into the previews that they announced. Exactly, exactly, exactly. Oh, I think that looked like key, I was just based on our short conversations yesterday. I started kind of keeping that in the back of my mind when I was watching what they were announcing, how they were announcing it. They didn't really get into the Lakehouse apps that much, but I think what was neat was, I like how they talk about keeping the data private. And I think to me that would seem like a huge thing for you guys. So huge. Conversely, the apps has been, I mean, right on time, because we've been discussing, right, we develop an app on the Lakehouse marketplace. How do you keep someone from just taking it, reading the source code, or, you know, for example, notebooks, the data you share, reading the source, and just recreating it themselves. You would be essentially open sourcing your proprietary information that would make the business, right, and so them announcing that further details around it, perfect, Chef's Kiss. Yeah, yeah, Chef's Kiss, I love that. I look at it and go, it's, to me, it just makes so much sense because your IP is your data. I mean, that's what you do and how you do it, how you, you know, make sure that it's not a scam and, you know, get people to trust the phone calls. I mean, that seems like a very similar message to what Databricks is bringing from a data perspective is how do you trust the AI and have transparency. And conversely as well, right? Like, it's an arms race, like I discussed yesterday. And so the bad guys are out there using these same technologies. If we were to then give them, right, where they, the app wasn't secure enough or they were able to see, hey, what actual data elements are they using? What can we obfuscate? What can we mask to get by, right? We're giving them the blueprint on how to scam people. We don't want to do that. So, you know, again, our goal is to protect people, protect customers, especially the elderly because they're much more inclined to fall for these scams, these phone scams. And, you know, ultimately, right, bring trust and transparency back to the phone call. Yeah, and I think that's so key is the trust and transparency. And we were even talking and chatting about how they're even using the AI voice enablement. They're getting, like you were talking about yesterday, they get, they went from having the first six digits of the number right to having my child's phone number or something like that, and a voice of that. And a voice somehow, right? And it's crazy. And I think that's one of the things that I'm really excited about what you're doing, what, how you're doing it with. And again, I asked the question in the press briefing, how much, you know, how did you get started and you kind of went through that and then what percentage was on Databricks and you were, I believe, said 100%. 100%, yep. Which is awesome. And I think that's, they should be very excited about that. That's for sure. So you're a good portion of that two exabytes a day processing that Olly was talking about. For sure, yeah. You know, Arsalaam mentioned yesterday, hey, who's this first Iran company in my internal reports that are using every, the top of every single category of all these skews, right? Yeah, we've always tried to push because we have to, right? We have to try to keep up and keep protecting people, so. I love it, I love it. Well, I want to thank you for coming on board. I really appreciate it. I mean, you're fantastic in such a wealth of knowledge and I know the people who are out watching, we actually have a lot of app developers and data developers that watch the show pretty religiously and I think getting your view on what's going on with Databricks has been fantastic. So I really want to appreciate it. Absolutely, thank you for having me. Yes, thank you. And thank you for watching and we're theCUBE, we're actually taking the signal out of the noise and presenting it to you to give you what's going on here live from the Databricks Lakehouse and the Data and AI Summit. We'll be back shortly with our next guest.


Hey guys, it's Nate, aka the Foot Accountant. Welcome back to the channel. We are back with another video and today we're going to be talking about one of the easiest investments ever that you can make in this game right now because prices in this part of the market are just way too cheap with a week ahead of a lot of content. I think I want to take a look at this area with you guys today for a potential investment. Also, the content just keeps dropping. There are so many new players and we're getting more today. The Super League Tots released yesterday. Today we're going to get the Belgium Pro League. We're going to get more SBC content. Another icon moments upgrade SBC is expected to be dropped today as well. Maybe another showdown SBC. And who knows what else because the content seriously just keeps flowing on this game and it's great. I want to talk about that and talk about everything from the market in the past two days from Friday to yesterday on Saturday and heading into today on Sunday. I want to talk about it all in the video today. So if you're enjoying the uploads on the channel, make sure to thumbs up and of course subscribe. If you're new, let's talk about this investment I'm talking about. I want to start the video off by speaking on this investment because we have talked a lot about SBC Fodder in the past couple of weeks and I think we still needed to talk about it especially right now with how incredibly low these prices are. 84s are 2k and some even under 2000 coins. 85s are 4k, 86s are 7,000 coins. Fodder is in the bin. It is so incredibly low with the lining round packs, the saved up packs that people have been opening. And I think today is a great opportunity with the content that we could get on Sunday. I think you might see the beginning of a rise on some of these cards. Again, it's the same fluctuation in the same kind of trend that we've seen the past three or four weeks, right? Fodder gets low on the weekends with the lining rounds and the saved up packs and then starts to go up during the week as we get SBCs. Now today on Sunday, I think it's going to be the start of that rise for some cards. Now, if you're going to buy some fodder, where do you want to focus? Like what kind of fodder cards do you want to buy? Well, here's the thing. Last week, as you guys remember, 86s did pretty well because of the guaranteed rating on that Loudly Guitars guaranteed, 86s went from like 7k on the weekend, like 8.4. They were actually even a little bit lower than that on the weekend all the way up to like 10,000 coins, 11,000 coins on Thursday of last week. Even Friday morning, this Busquets card was like 11,000, 12,000 coins. They're now 6 to 7k.  And I think the place where you want to focus on this week for fodder is I want to base it around the guaranteed Todd's pack because that is the SBC that we know is going to be one that will 100% come out later on this week. And it's one that everybody is going to want to do. It's going to be, the Loudly Guitars one is gone now, but the League One Todd's guaranteed to try to pack your guys like the Messi, the Mbappe, the Neymar. It's going to drop this week 100% on Wednesday, that's when we expect it. And we know everybody's going to go ahead and do it again because you have the opportunity to pack guys like Neymar, like Benyeter, like Mbappe, like all of these top tier cards. Of course, you're probably going to pack Gandhuzi, Fofana, Lafonte, one of those guys, but just because you have the opportunity to pack one of the big boys, that's going to be the SBC that we can count on that we know everybody's going to do. And with the price of this team and the prices of the players that are in this team being about this team in total, if we scroll up here, 18 million coins is the whole entire squad of League One Todd's. That is the most expensive by far for any of the Todd's League so far. Last week, we had an 87 rated team for LaLiga. I would not be surprised if this isn't going if this is going to be an 88 rated guaranteeing Todd's squad on Wednesday for League One Todd. So that's why I think if you're going to buy some fodder this week, I would try to stick to like the 87 to the 88, the 86 to the 87 range, I think might do the best just because I feel like that part of the market of fodder has the highest potential to go up with the content also coming out today on Sunday. But even specifically looking forward to Wednesday, I like 86s at like 6 to 7,000 coins. I love 87s at 10k. You know, even for some of the higher rated squads that could be a part of an icon moments 93 plus coming out again today, that's the other SBC that could make higher tier fodder rise. I mean, Lewandowski on Thursday was like 44, 45,000 coins. Thursday night Friday morning he was 47k and now he is 34,000 coins. I know a part of that rise was because of the Fabinho and the Rodrigo SBCs and they required some higher rated teams, some higher rated squads. But again, if the guaranteed League One Todd's later on this week is going to be at that 87 to 88 rating, I think these 92s might see like Lewandowski or De Bruyne the higher tier like the 90s and up could see a bump in price up as well. That's why I just think fodder across the board is a really good investment right now. And I'm trying to figure out like we always try to figure out what the best bang for your buck is going to be, what the best return your investment is going to be if you're buying fodder. I think that the 86s to 87s are probably going to be your best bet this week, but maybe dabble in that higher tier, maybe dabble in the lower tier a little bit too, right? Again, 84s at 2k, that's atrociously cheap. That's ridiculous for how cheap these cards are right now. And even starting today on Sunday, like I mentioned, the icon moments 93 plus upgrade is going away today. Last week we had it for the first time. If they follow the same trend, we're probably going to get the same SBC again today in the game. Now, what does it require? Because also when they re-release these packs, they usually re-release them with the same requirements. This is a four part SBC with 288s and 289 rated squads. It was about 660,000 hopefully when they re-release it today, it's cheaper. And there's just the absolute slightest chance that they could release the icon moments player pick. But I think we would have some leaks ahead of time if that was going to happen. And as of right now, we have nothing. But regardless, I think that's why I think that this fodder is going to be a good buy. If you have not bought it already, the prices that I'm seeing right now are just really, really cheap. And I think that today, especially after content and even in the early hours of today, as people realize how low fodder is, you're going to start to see it rise. So anything between 86 and 92, I think I like the most this week because of, I think that middle tier is going to do the best because a lot of people have untradable Todd's cards in their teams as well. So if you need to go do like an 88 rated squad for a guaranteed Todd's or if you're working on an icon moments pack, you know, you're probably going to end up buying a couple of those 86 to 87 rated cards to finish out that squad. So that's why I like the SBC fodder investment a lot. And even again, starting with today's content, this could be an SBC, these, these showdown SBC leaks right here. I think this SBC could come out today as well. So if we're getting the 93 plus moments and a showdown Kuti or Merrill versus Emerson today, I think that that middle tier of the market could start rising as early as today, like I mentioned. So definitely take a look at those cards. They're really low as I'm looking at them right now. It's because of the lightning rounds. It's just because of the lack of demand for the fodder and also a ton of supply, right on the weekends, that combination gets these prices low. I think they'll rise up. Now, when do you want to sell these cards? We'll talk about this too, right? If you're buying 86 is if you're buying 87s, I think you would want to wait to sell these until Wednesday, Thursday, maybe even Friday morning, depending on the content that we get later on this week, we're probably going to see some more league on TOTS SBCs, maybe another like a TOTS moments or a U23. We're going to have some more content around those TOTS cards in that league this week. So I feel like that that's going to be your sell time. So you're kind of buying now and then selling later on in this next week. I think that's a good plan. So this is an SBC that is I think either coming today or tomorrow and I would be leaning towards today because if you remember for the UCL final, which by the way, GGs to Real Madrid, Rodrigo owners for the showdown cards are looking forward to their 94 rated Rodrigo and their 94 rated Gareth Bale. If you got the road to the final, those upgrades are going to happen hopefully pretty soon because both those are going to get a nice boost. But usually they were they were releasing the showdown SBCs like three full days before the game was played. This game is on Wednesday. It's between Argentina and Italy, the winner of the Euros and the winner of Copa America. So that's why they've chosen Romero and Emerson. It's great timing for this Emerson card because we're in the middle of league one TOTS, right? And those Italian links with the league on links as well with Syria TOTS coming next week. That's going to be a card I think most people would be interested in doing. I'm 100% doing Couture and Merrill of course is a Spurs fan. That card looks fantastic. So this game is coming on Wednesday, Wednesday, Wednesday, Wednesday. But this SBC is probably going to be out either today or tomorrow on Monday. So keep an eye out for that right there. And again, I think this is probably going to be somewhere in the range. You know, how much should they price variety at like 200k? Yeah, I feel like a showdown between these two cards where Merrill might be a little bit more expensive because of Premier League TOTS tax. But I think that somewhere between two to 250,000 coins would be a sweet spot for these cards, maybe a little bit less hopefully. But if they give them really good stats, then maybe we'll be willing to pay a little bit more. But that could be the rise, start of the rise on fodder today. So that's kind of my investment advice for you right now. If you want to try to make some coins this week, fodder is probably going to be the easiest way to do it. Honestly, I know that it's not the most glamorous way, but fodder is probably the easiest ways to make coins in FIFA like right now on a consistent weekly basis. So as long as you pick the right rating of cards, maybe go through and just club stock like a lot of everything. If you have a couple hundred thousand coins, you can buy a couple 87s, go buy a DiBala, a Sancho, a Yaris, a Shesney, a Marjush, buy one, put it in the club, do the same thing with the 86s. Even the 84s, 85s, and then stack a couple of the above 88 ratings as well, like a Ramos, a Mane. It's crazy to think that Gold Kante has fodder. Just do a little bit of a club stock too. Even if you don't want to invest, it'll probably pay some dividends later on this week with these cards going up in price. I'm going to do that myself. So other content that we could see today on Sunday, I believe with the Belgian Pro League dropping today, we're going to see this leaked SBC for Holt, a center-back card. Stats are predicted. Maybe this is going to be, I forget the guy's name who was a center-back. A couple of weeks ago during Eredivisitats that they dropped. He was a French center-back. I can't remember his name. It's as bad. But maybe we're going to get those sorts of vibes today. A really cheap Tats card from a secondary league. If he has more than 83 paces, then he might be pretty meta. But this card alongside of the Pro League Tats should be dropping today, Undav, Vanneken, Ito, Decchettelere. There's going to be some nice cards in here, man. And it just continues. The absolute insane content that we have had recently. Yesterday, we had the release of the Super League Tats, including this Balotelli card, which is absolutely unbelievable. Five-star skill boost, four-star weak foot. I mean, look at the upgrade this card got, right? And of course, after the insane goal that he scored last week, everybody's talking about Balotelli. Medium-low work rates. Again, the five-star skills. There's just so many cool cards to use right now. Viscale looks pretty good. Hampshire looks pretty good. The left-back looks pretty solid. I mean, there's just so many cool cards that are so cheap inside of the team this season. That's why Tats is just undefeated as one of the best promos every single year, because the amount of cards we get with the boost and the skill move week foot upgrades this year as well, it's just fantastic. So I absolutely love the content that is coming out. And I'm excited for today's content on Sunday as well. And also, we are one day closer to upgrade packs. Monday, tomorrow is a big day for upgrade packs. We'll talk about that a bit more in tomorrow's video, of course, as we expect that. So let's also talk about the market. You're like, Nate, this market this weekend has been pretty crazy. It has. These League One Tats cards, they started off really expensive. If you guys remember talking on Wednesday and Thursday of this last week, I was like, guys, there's going to be two ways this is going to play out. And it played out the second way. EA did not make them really cheap. They started off with crazy high price ranges. Neymar was like seven million coins. Marquinhos was like over a mill. Paqueta was like two mill and it took them hours and hours of lightning rounds to drop down low in price and then rebound. Well, they did rebound and they did get very, very low on Friday night into Saturday. I bought two Ben yetters at two million coins flat sold one at 2.3 sold the other one like 22 something. I bought five Marquinhos at 700 K flat and I sold two here for like 820, 830. The other ones I sold for like 740 or 750. These Militaos I bought for like 300 and 90 to 400 K last week during La Liga team this season. So I sold all those. I actually sold them a bit early. He actually ended up going to like 480 K. I bought a couple of Chaminis as well. I think just one of them at like 680 sold for 780. There were just tons of fluctuations and flips with these brand new Tats cards from Friday night into Saturday. Now that was the good side of things. If you made some of those cards GGs of course if you bought any of these cards early on you probably did lose a bit but that was exactly how EA wanted it to go down. Now what's going to happen with these cards as we head throughout the day today? I still think that you know a lot of these are still up from their low points on Friday night. You know Paqueta was one too flat. Ben yetter was two mill flat and he's still 2.13 right now. I think these cards are all going to drop off a bit more today. The lower tier ones though like Fofana and Genduzzi so many people are going out and using these cards. Actually if I'm being honest if you guys have opened any packs what it really seems to be like is right now with this team you're packing tons of Lafonts, tons of Terriers, a tons of Salibas and then a couple Kloss and maybe a couple Payets thrown in there but like everybody else is like super unpackable. Like I don't even know how in the world I was able to pack Ben yetter. It's probably going to be that way this week with upgrade packs as well. We just hope that the weight is good so that even if we're packing blues consistently even if it's a lot of the lower tier cards we at least feel like we're having a chance to pack in the higher tier ones because last week it just felt like we couldn't pack anybody. So that's our hope for this next coming week with upgrade packs in total. But I think that all these card prices are going to drop off a bit more today. Could we see a few more fluctuations? Yes like Genduzi is one of the most hyped cards and he's 100,000 coins. Fofana is 200k even though he has bad links. He's still an insane card for 200,000 coins that a lot of people want to go out and try. You know I'm not going to try to buy a card like a Ben yetter today trying to see if he can do the same fluctuation as he did you know from early Saturday hours right here at 2 mil going up to 2.3 you know and then coming back to oh he went back to 2.3 wow so I sold him too early here at 2.2 when I sold my second one. I'm not expecting some crazy fluctuations like that today on Sunday but I do think you'll see a few cards move around a bit. Actually I would expect maybe some more fluctuations with the hyped cards that are inside of the Super League maybe a Balotelli maybe a Hamshake since these cards are still probably pretty rare. I haven't checked them on the market too much but the cards that are of value in here are probably going to be pretty rare since they were released yesterday not on Friday so I would watch Balotelli and Hamshake for maybe some fluctuations today on the market as well but I also want to take a look at your out-of-packs cards let me actually look at a specific card for example here Renato Sanchez and if you guys were in the live stream on Friday we saw some crazy movements guys like Renato. Renato was like 420,000 coins the content drop he actually went up since these League 1 Tots cards were super duper expensive in that first hour a lot of your League 1 out-of-packs specials bounced like Renato like Awar, Jelson Martins went from like 430,000 coins up to like 470 for like an hour and then after that they dropped off because especially for a guy like Renato Sanchez there's so many midfielders in this team he went down down down and he got Panic sold a ton so he actually bounced up right here and then all night he got Panic sold he went from 450k all the way to 290 and then went back up all the way to 360 350 where he is right now based off of rarity kind of the same thing happened with like Awar as well and I don't think we're getting the League 1 Cup as an objective this week at least unless that comes out today on Sunday I feel I thought I remembered them dropping those on Saturdays in the weeks past Awar was like 500k he bounced up to like 580 then back down to 500 and of course he does fluctuate a lot around in price but these League 1 Tots cards were so expensive early on that's why those out-of-packs specials exploded if you're still holding an Awar a Jelson Martins I mean could these guys bounce back a little bit more this week yes but I feel like that's only gonna happen if the content is bad for some reason and it's not very hyped this week or if they drop the Tots cup and I want to see if any of these Jelsons yeah man you see anytime you see this like we look at this all the time you see zero games played for the current club that tells me that's an investor selling the card I still have like four Jelsons on my transfer list yes I know this guy's gonna be incredibly incredibly hyped this week and a lot of people are gonna want to use them in their teams but I don't see his price rising up that much even though he's super rare just with like everybody's teams now and FIFA are totally divided like a lot of what we do for like the League investing like even people that are wanting to buy Serie A cards for this next upcoming week I'd be a bit careful with that too because people right now are just running so many of the older Tots cards from like week one and week two that they have and it takes a lot to try to train change your team every week to whatever League is hype it maybe doesn't take as much effort with League on because there's a lot of French and a lot of League on links and people's untradable squads already but I just think that the investing in that specific League for a rise in the like you know we invested in League one special cards beforehand it's just gonna get harder and harder because of how many people are already running untradable cards in their team that link together and they don't want to really change it up so I'm probably not going to invest in any Serie A special cards that you know maybe a few this Zlatan I'd be very careful with although like I feel like Zlatan will be a absolute perfect card for EA sports to pick to do an end of an era item or a flashback Zlatan especially considering that he is potentially done with football um and done in Milan as well so you know that could be an SBC that comes out or you know a Di Bala foot birthday I know it's really early to talk about that stuff but this is the time of the of the weekend when people are looking to invest that stuff as well if I'm being completely honest I'm not going to invest in any of this stuff I kind of last week kind of put a sour taste in my mouth after investing in some of those cards you know Di Bala's 490k yes this card would be absolutely cracked and a lot of people would want to link him up with other Serie A Tots cards but I don't think I'm going to mess around with this stuff uh this week if you want to there's probably opportunities out there where you could make some coins but for me I'm going to stay away and um probably just take some of the losses on these um league one special cards that I still have you know I haven't now worn it like 590 and he's like what 510 I have Jelsons at 450 he like kind of hasn't moved and I did buy a couple Hakimi's for 415,000 coins because I know we have Kloss and I know that Kloss is just fine and he's dirt sheep and he links really good to all the guys that are in the team right now but this Hakimi is is the the guy right this is the right back if you're playing a league one team this is the guy you want to use so I'm hoping that he rises maybe back up a little bit during the week as people maybe craft a variety and I know that there's still investors in here that are selling as you can see here zero games played current clubs so I bought a couple of those at like 415 because if he goes anywhere near 400k again I still feel like this card should be like 450 because this is the best right back right now if you're running any sort of league one squad like this is the best guy so that's why I bought a couple of him hoping that he rises a little bit throughout the rest of this week but today should be a pretty good day of content I'm going to go do a club stock on some SBC fodder right now like we talked about at the beginning of the video and I'm just going to hope hope for some good content this week and watch these tots cards man because it just there's just so many incredible cards right now to keep an eye out for and to watch and there's just so much content that it's it's incredible I didn't even look at the SBC the batch Hawaii I didn't even look at the objective Maxim who's got five star skills but make sure also I'm watching this money because of course he's not getting upgraded so his car price is down a lot I keep an eye on your road to the finals your bail is going to get upgraded soon in this money was panicked so big time so he's rare I might watch and keep an eye on to him just a quick check on the tokens tracker I want to just check this at the end of the video the tots swaps tokens the only ones we have had so far have been released through objectives except for the free one we have the azor key Dante the first two objective and tots max and have all given us tokens so only five tokens have been released as of right now they're all still available and they're all still available for like the next five days until June 3rd they are all out in the game so actually that's more than five days it's like a freaking week right when's Jude third next Tuesday plenty of time sorry I can't that's the wrong month next Friday wow all these are out until Friday w so plenty of time to go claims claim some tokens maybe today they'll drop the first like SBC for a tots swap to token but make sure you keep an eye on those and if you're grinding for any of those good luck also if you're grinding week and week good luck I have no idea in the poll last night I put up on the YouTube channel you guys said that you wanted Harry Kane to be removed from the team and you wanted Ben yetter to be inserted in so I've removed Harry Kane and with that daily Ali and I put in Ben yetter in Vieira so I might be running a might be running an R9 Ben yetter strike force of course if you missed it in the Twitter poster on the stream on Friday we did pack Ben yetter out of a saved 75 times 15 so the red list luck continues and I gotta find a way to get this guy in the squad the way that I like it I just need another left mid if I'm being honest like Neymar I know it's a lot to ask for me a sports but Neymar would be so perfect for the team and you know maybe I get noodle men's maybe I run a different formation we'll see but this is the squad of a rocket at the moment I'm probably gonna play a weekend league with this exact squad right here and try it out still want to use son of the team I'll probably sub him off pretty fast to bring somebody else in but absolute balling team man I can't I can't wait to use Ben yetter it's gonna be so much fun and I'll start my weekend league games today on Sunday because I have not played any of them as of yet so good luck with your guys's weekend league as well and hopefully today on Sunday we do get a solid batch of content and I think that fodder is going to start to rise up this week because the content should be pretty good especially with that guaranteed league one pack being the most hype sbc that we'll see later on this week so if you enjoyed today's video put a thumbs up on a comment below if you have any questions and subscribe if you're new it's been Nathan put account and I'll catch you guys later peace out


Thank you very much Mr. Speaker. Mr. Speaker, I felt a compunction to add my voice not only to approve and to support this historic resolution but in the main Mr. Speaker to deal with an issue of misinformation with seemingly have pervaded our society to such an extent that it goes down the annals of belief. Mr. Speaker, I'm happy to hear the member from Swazil confess in this August chamber. We say confession is good for the soul and when he can stand on his feet here and speak about a contribution to his constituency being made through the ministry of housing sanctioned by the honorable prime minister he must understand that today St. Lucia enjoys a prime minister that is unlike the one that occupied that chair before. Unlike, you know, and you should ask yourself why is it your leader never found it necessary to at least take a page from the book of the member of Fokastry's East and give the opposition one bag of cement. And you know it has been coined Mr. Speaker in such an embracing tone and my colleague from then renorth would say that is the hardship that was deliberately created by the leader of the opposition was then prime minister for five years and you know Mr. Speaker, he had the audacity, the goal, the gumption to go on social media and say as though he's still prime minister he will be repairing an HRDC in his constituency with a CDP allocation can you believe this Mr. Speaker and even stated the amount of 100,000 I will let me quote him I will use 100,000 out of my CDP allocation you know Mr. Speaker, it irks me you did not find it necessary to at least take 100,000 over five years to share between six opposition members but today in one financial year you can tout that you will allocate 100,000 out of your CDP allocation you know Mr. Speaker, governance comes with continuity and that is what persons don't understand if you look at the shape of the table around which we see it, it is circular, it is round and it speaks to the old phenomenon what goes around comes around you know today and imagine Mr. Speaker, he had the audacity to expound on it and to say they don't want to give it to me because they want to undermine me in my constituency and oh how my heart ached when I heard these words I could never forget during the election I went to Kasri south I saw a certain character, a certain character either big or small daddy or mummy I am not sure which one erected lights in a constituency of which he was not the rep I went to Denver remember Kasri central, there is a resolution before you yes I am speaking the resolution Mr. Speaker I don't see the connection Mr. Speaker, Mr. Speaker I am basically attempting to show how we are stressing so far that the Minister of Finance can now make resources available to the opposition a feat which was never existed during the reign that has nothing to do with the resolution before us members very well Mr. Speaker but Mr. Speaker, the leader of the opposition wrote on his Facebook page an open letter to the Prime Minister and in that letter Mr. Speaker he indicated quite lucidly that the Prime Minister did not understand the importance of construction you remember that he indicated that the Prime Minister does not understand the importance of construction a man who took the package of material that you need for construction remove that on steel remove that on lumber remove that on plywood remove that on cement remove that on blocks you as leader of the opposition you are intimating that he does not know the importance of construction so what was that move for Mr. Speaker what was that move for why the removal of that on those building materials if one does not know that construction activity will bolster economic activity and thereby bring economic growth about Mr. Speaker you know and he claims that on one hand Mr. Speaker that and I was glad to have heard the member for Swizzel say why don't they support what is good and that's the hypocrisy I don't like that is the hypocrisy I don't like because I am sure if his dear leader if the leader of the opposition had graced us with his presence in this other chamber today I have my doubts as to whether those words would be emanating from the mouth of the member from Swizzel I don't like the hypocrisy it was on their paid radio program Mr. Speaker that they claimed they were not supporting this move because people don't eat plywood it was on their paid radio program that they said people will have to eat plywood soup they said it plywood soup people don't eat little short one Mr. Speaker first time you are hearing that it is that kind of hypocrisy so they come here and and we flash in mirrors as our leader would always say the honorable prime minister pretend they support for the world to see and then go in their holes Mr. Speaker and then best the government for a move they know would redound to the benefit of the average poor citizen of this country hypocrisy hypocrisy that's what it is and they come here why you think you learn something good you know why you think you learn something good Mr. Speaker you know those are the kind of things you hear that is the kind of garbage Mr. Speaker that people spew on the out of political loyalty Mr. Speaker but we must learn as a people we must learn as a people never to take benefits conferred upon the citizen of this country whether by one party or the other and play political football with it we must learn not to do that and if there is anything you all have done that would benefit solutions I will applaud you all but you all did absolutely nothing you see like this is zero written if and that this has of a zero you know Mr. Speaker there are three approaches the government could have taken with respect to building materials government may have sought not to interfere with the prices government may have sought to increase the prices to generate more revenue or government may have sought to bring relief government chose the option that would be beneficial to everybody and you heard them spinning the news asking which person will build a house can you imagine can you imagine Mr. Speaker the bandy one which person will build a house the bandy one you know which person will build a house and somebody calls and you get a response like yeah the rich will take advantage of the opportunity to build houses to rent I mean what kind of world thinking is this Mr. Speaker how do we empower our people when we keep our thinking in that kind of cocoon Mr. Speaker how can we grow our people you bring relief you are giving them an opportunity to build a house cheaper and they are saying no I don't support it because the rich people will be like who will build the houses to the rich people you see even in your short sightedness you don't realize that there is a labor component to construction you don't even realize that your myopia gives you jaundice eyes bright yellow you know let's argue for argument's sake that rich people capitalize on the benevolence of the government Mr. Speaker can the benevolence of the government alone construct a house you need laborers you need carpenters you need messengers you need tradesmen you need electricians promise but you know they go and they spin the news on spin news you know and the bandy one yeah yeah you know people will eat plywood soup you know that kind of plywood soup you know Mr. Speaker honestly I was speaking to some of my colleagues and even within the tenets of democracy sometimes a little autocracy needs to because you see you have so much nonsense Mr. Speaker that sometimes you tell yourself look I want to devoid myself of my hearing ability because some of you infuriate me to such an extent I can do without hearing anything at all I mean a sense of reasoning a sense of reasoning that will not even find embrace by the market you know and somebody is actually typing that typing it sending it on a computer and one with a little more intelligence a little more intelligence would read it and laugh because solutions will eat plywood soup Mr. Speaker you know and all the former administration has become accustomed to Mr. Speaker making life more difficult for the malware of this country Mr. Speaker and the track record is testament of that fact they stop knife they stop step they stop the distress fund and guess what Mr. Speaker as if to further financially imprison our poor people they remove the subsidy rice flour and sugar you know so as if malware is in this country Mr. Speaker what the enemies of the last administration the enemies and every decision they took every decision they took Mr. Speaker will financially draconian decisions that basically militated against a comfortable life by those persons in the lower echelons of our financial strata Mr. Speaker you know and telling me the government brings relief and rather than breast the relief we have everything negative to say Mr. Speaker Mr. Speaker this government introduced the national housing assistance program which has been rolled out pretty soon Mr. Speaker and the prime minister called me and said to me Mr. Minister let us give a little more to the people by awaiting the implementation of the VAT so they can get a little more for the money Mr. Speaker so when you would have been able to help 20 families or since 20 households Mr. Speaker you can stretch it to 12.5% more you can now do 25 that is the thinking of the government Mr. Speaker that is the thinking of the government that is the thinking of the government we can now help more people with the same resources you know and then you all in your myopia led by a man whose mental faculty is empty will follow whatever he says living him and you know with hypocrisy at your side now will say he is good because what he is absent from the house today say it when he is there Mr. Speaker I need you to say it when he is there Mr. Speaker you know I want you to say it when he is there so Mr. Speaker this government led by Philip Joseph Pierre who emanated from Castrisse out east Masha Castrisse is sorry Castrisse is they always say Mr. Speaker I am sure you know what the well done phenomenon wise people come from the east and this is a man who has shown compassion and I am not saying this because I am in his cabinet I am saying it because it is the truth look at the kind of programs he has rolled out look at his brain children the MSME helping small businesses the youth economy the housing assistance program increasing to the poor people all sorts of things basically to help the underprivileged and then I remember him saying in cabinet one time gentlemen we can no longer proceed with this distress for not in place because it was meant for who for the poor it was meant for the poor and it is aptly referred to as a distress fund and it is in times like this Mr. Speaker when the inclemency of our weather sales us there are people who don't know if my small domicile can withstand the pressures of the inclemency of the weather and so they look outside and they say lord please stop the rain but we have a compassionate government Mr. Speaker and I am glad to report that the distress fund that was taken out by the now leader of the opposition has been replaced by Philip Joseph Pierre to ensure Mali ways of access to funds if and when the situation around them so Mr. Speaker you know I want to end by saying this I want to end by saying this when I listen to some of those people Mr. Speaker I listen to some of them I listen to them chastise and castigate the government they castigate the government because the government conferred a benefit a benefit on the poorer people of this country Mr. Speaker you ask yourself Mr. Speaker whether those people are suffering with either the discoloration of their brains or their eyes Mr. Speaker because I suspect John Disney does not confine itself to eyes alone it is in the brain as well because you cannot be thinking rationally you cannot be thinking objectively you cannot be thinking in the interest of the poor people when you are telling me that you don't support a benefit to the poor people of this country you know what Mr. Speaker only one place in the world that a benefit to the poor people would not be appreciated only in St. Lucia I thank you Mr. Speaker


We're now going to be entering a sales receipts which are going to be the sales items that we make on like a cash based system and then we will make the deposit. So what do we expect to happen? Sales receipts, we expect to be increasing, not cash because we're going to put it into that undeposited funds like account or funds to be deposited account or payments to deposit. I think they're going to call it and then the other side is going to go into the revenue account and then when we deposit it we're going to take it out of the clearing account and put it into the checking account. Let's go to the tab to the left to do this. Quick look at the flow chart. Just remember that if you're on the customer cycle we expect money to be going into our checking account at the end of the cycle in some way shape or form. The easiest method or cycle we could have is if we were in like gig work getting paid by like YouTube or something and we just wait till it clears the bank possibly recording with bank fees using just a deposit form and that would be the easiest thing to do although it's not really a full service accounting system but it would be nice to do if we're in that type of industry. But a step away from that is what we're going to do now the sales receipt form meaning it's still on a cash based system. We're not tracking accounts receivable but we're doing a full service cash based system because we have to typically because we're going to get receipts from a customer at like a cash register for example and then we want to be able to check the sales receipts for the day versus the cash that we have or the credit cards versus the grouping of the credit cards and then we're going to physically make the deposit into the bank and we want our deposit in our books to match what we physically deposit into the banks. That's why it's a bit more of a challenge and you can't just rely on the bank feeds and then the step away from that would be the accrual method in which case we have to track the accounts receivable and enter an invoice track the accounts receivable receive the payment and then deposit. Remember that these two forms the receive payment and the sales receipt represent us receiving money and both of them we can either put directly into the checking account however we might want to use that undeposited funds like account payments to deposit as a clearing account to help us to then group the deposits in our system in the same format as will be put into the bank either by us with physical checks or the cash that we physically put into the bank in a group or with the credit cards where the credit card company might group the deposits in a way to group multiple deposits together or multiple sales in one deposit that goes into our checking account. Okay so let's go back on over I'm going to say new on the left we're going to go into the sales receipt sales receipt we're matching we imagine whenever we're at the sales receipt we're at like a check register in our shop and like our guitar shop and then Garcia we're going to say Garcia we're going to have a new customer Garcia guitars guitars is going to be the new customer very creative name that I came up with with that one I feel like or our team came up with a really creative name on that one Garcia guitars because it has two G's so that's why it's cool anyways we'll save that one obviously we might want their email address and whatnot but it's not as important because if we're making the sale in the shop we might not even get their name because we're at the cash register if it was a food truck or something we probably wouldn't get their name we would just have a generic customer called customers because no one wants to give us their name so that we can give them a peanut butter and jelly sandwich although no one orders peanut butter you know whatever sandwich we're making whatever you get what I'm saying so then the date is going to be let's make the date let's go with 0223 for the date and then this populates automatically and then the location is necessary for the sales tax calculation no tax payment method I'm just going to keep going with cash to imagine us grouping it remember that if we got an actual check we would imagine that the check is something that would hit our bank account in the same amount as we would enter for the actual sale because it would so in that case we could use a deposit directly into the checking account but if you're doing if you're working at a sales register you're thinking I might get paid by cash check or credit card and so you probably want to keep your deposit system the same all the time meaning I'm going to put everything into undeposited funds or payments to deposit the clearing accounts and not try to pick and choose when I want to put it into the checking account or not right because if I got cash then for sure I or almost certainly I don't want to put it directly into the checking account because when I make the deposit physically into the bank I'm going to group multiple sales together at one time and that'll mess up my bank reconciliation same with the credit card here if I get a credit card then the credit card company might group multiple sales together and deposit them into my checking account in some grouped format I want to match that on my end so I'm just going to say cash for the example problem and we're not going to put it indirectly into the checking account here we're going to put it into the clearing account just remember also that if you did put it into the cash account then you also have the added kind of little bit of a complication in that in your transaction detail you'll have sales receipts that will increase your checking account as opposed to just deposits and possibly transfers not a big deal if you want to do that but you've got to kind of remember that it's another little sorting issue that that could I like to have all the increases be basically deposits in my checking account that it's easy to know what the increases are they're all deposit transactions but whatever so now we're going to go down here and we're going to add the stuff the stuff that was purchased so we're going to say it's an EPSP is one of the things that were purchased so we've got that one and so I'm going to say we've got how many of those two of those I'm going to say gets us to the 1200 it is a taxable item and then the next one the next line is going to be an ELP an ELP which we set up in a prior presentation this is an Epiphone Les Paul and we're going to say that let's say we sell two of those two so that comes out to the sales of 2200 and then the tax is being applied based on the location let me I had to click down here for it to reformat and calculate based on location but I'm going to change it to our generic problem of just the five percent you could do that if you want to do the generic problem by changing the math here and just override it to five percent or I set up this another item of just five percent so I can make it generic and not related to just California so you can just see the concept and follow along no matter where you are so then we've got the three the 2003 10 and so that looks good so what's this going to do it's a sales receipt so it's going to increase some kind of cash account this it's going to go for us into the clearing account like undeposited funds payments to deposit that's for the full amount 2003 10 the other side is going to go into revenue 2200 the difference the sales tax is not going to be revenue because we're just the tax collector they forced us to collect taxes for that one they said you want for we want protection money and you've got to give us five percent we're like okay so then we got to increase the payable account of of a liability of 110 and then also we're going to have the inventory go down not by the amounts on here but by the cost which is no one because we have a perpetual inventory system that was set up by the items that we put in place and the cost to goods sold is going to go up by that same amount the expense account related to us consuming the inventory the net impact income impact is going to be income minus the cost of goods sold and the the sub ledger for inventory is also going to go down by unit not just by the cost okay that's a lot of action let's save it and close it and check it out


Hey, I'm Roy Woods and I'm about to test my knowledge of video slang in the game of slang Dogs bollocks is that even how I pronounced it bollocks dogs balls? Damn, this is crazy. I actually do not know what dogs bollocks are Boogie, dang, I really don't know what it means, but I'm thinking I'm thinking it's not good Ragi, wow, this is insane.  Ragi This is rad. This is rad. Like this is cool Yard, oh, that's like home. Yard is home. We say that all the time it's on. Going to Yard found Yeah, I know that one Yeah, Yard Reen Oh, damn, it's kind of like a man from the block Yareen, wild one. I have no clue what this could mean This is insane. What could Reen mean? Reen, I'm not a man. I need to get I uh, I don't know Swill Everything's okay. I that's the only thing I could think that I need like everything's all right We cool, you know, we swell, we all right, you know How do I say this? A up? A up? I don't know which one it could be how you pronounce it. A up I'm gonna possibly know what this means All right, voice gives up again.  I don't know like This is a slang This is really a slang This is a slang. How do you even Can I get it in a sentence, please? Gabi, like you're gullible Mmm Trash maybe Ah, yeah, yeah. Oh, we did it. Yes