Cadence Yuna June 9, 2021 Spreadsheet
I don‘t think so. My husband and I weren‘t a great married couple but we were excellent business partners. We almost never, actually maybe NEVER, fought about money. We agreed on how to raise our kids and were always honest about our finances. He made a lot of money and I had some money of my own from my grandmother and would inherit when my parents died. I knew that we would be able to sort through these things better on our own. Most significantly, he LOVED to make spreadsheets and certainly would not be willing to pay someone else make one for him. I did some research on the internet to see what our options would be. I knew we couldn‘t do it ourselves but that we would need some assistance because our finances were complicated. I learned about divorce mediators, professionals who work with couples at an hourly fee to help them navigate the process. It sounded like it would work for us so we agreed to find one. And we did. Well, I did.
Whilst Excel cannot clean or structure all of your data for you it does come with some useful functionality for manipulating and analysing clean and structured data sets. This in-built functionality includes pivot tables, sorting and filtering. Filtering alone is a powerful tool and can help to quickly isolate data based on specified criteria. But what happens if your data is clean but not very structured (a common problem). For instance what if you, a client or your team is using colours, fonts or some kind of formatting to classify data in an Excel spreadsheet. In short, you wont be able to filter the data, because Excel‘s in-built filtering logic requires rules based on numbers, dates and text only. It will not perform filtering based on formats. In addition Excel filtering only applies down rows. It will not perform filtering across columns.
Microsoft plans to have this program up soon and now Google is beta testing a similar situation, which would allow you to do essentially the same thing. Why is this good? Well, consider the Digital divide in the world and if everyone just had a terminal rather than a big hard drive with lots of expensive stuff on the computer then they can store all their information at one location. By doing this, the computers would actually be terminals and it would be very inexpensive to make them, meaning that everyone in the world could afford to have one and everyone in the world could be online and interconnected in a giant collective of humanity. There would be no one who would be without the Internet and this would bring the world closer together in a common cause.
This will show your Angel Investor that you indeed are a rational thinker and concerned about the money as well as the truth. If the Angel Investor cannot trust you your chances of being funded are nil. An angel investor is betting on the jockey not only the horse. As an entrepreneur you must be honest with yourself as well as your financial partner. They want to make sure you believe in what you are doing and that you also have risked your own capital, time and energies into the new business. Angel investors want you to succeed and often they also like to give their input and if you end up taking their money for your startup, the need to realize that their input needs to be taken seriously.
Microsoft Excel is a phenomenally powerful calculator. You can create spreadsheets with 10,000 lines of data and calculate subtotals instantly. Indeed, if you change your data, any totals will get automatically updated. Arguably that‘s not too impressive. If we have quarterly revenues of $1m, and we secure another $20k, we can update our subtotal without summing revenues from scratch. So it‘s more impressive that Excel can do the same thing with statistical functions. If you‘ve ever plotted a chart on Excel, you may be aware that you can add a best fit line. These best fit lines are calculated using a method known as regression. Basically, you have to calculate the distance of every single point from the line, and minimise the sum. The maths is a little more sophisticated but the key point is that, every time you change the data, you need to perform the analysis all over again.
Here‘s a very simple budget set up. Keep a simple income spreadsheet. List all the sources by name in column A. List how much each brings in in column B. And then, any notes you have for the income (like if it is temporary) in column C. You don‘t need to get very detailed with the income, because it only needs to be accounted for so that we can budget for it‘s use. And, the incomes use is in our expenses spreadsheet. This spreadsheet will be much more complex than the income one. You‘ll need a field for income that you carry over from the income sheet. You‘ll also need a field for a total expenses budgeted for. A third field will give us the budget surplus. We get that by subtracting the budgeted amounts from the income amount. A final field will subtract the actual amount spent from the income, and will serve to tell us where we stand in our budget. If you like, you can add another field that subtracts the actual amount spent from the amount budgeted.
Tag Cloudandroid app for excel spreadsheets