Suzanne Eléonore May 12, 2021 Spreadsheet
”Happy crapola!” he exclaimed, rising from the rollered chair and scooping accordion folds of printouts into his tattered briefcase. He snatched his worn black suit coat from a hanger on the back of the office door, switched off the fluorescent overheads, and walked to the executive offices in the adjoining building. When his audit week ended, Lester typically teamed with Lance Lott for a tour of the local watering holes. Lance was a marketing guy he‘d met when he first worked the Bourgeois account. Lance also was single, and resembled Keanu Reeves on a bad hair day. Lester considered him a ”chick magnet,” and although he himself never got lucky on their semi-annual expeditions, the other always disappeared with a babe on his arm. Lester decided, tonight would be HIS night.
Unfortunately an internal rate of return is time dependent so the amount you can withdraw depends on when you take it. Suffice to say, the only way to calculate the amount you can take e.g. halfway through the life of the fund, is by trial and error. If you are evaluating a number of investment opportunities, that can be a very time consuming process. Therefore Microsoft have built the Goal Seek function to aid your spreadsheet development. Since Excel 2007, it has been available from the Data ribbon. In earlier versions of Excel, it was present from the Tools menu. It gets straight to the point. It asks you which value you would like to fix (in this case the investor‘s return), what you would like to fix it to, and asks what you would like to change. All fields can accept cell references. It will then calculate the input through trial and error.
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.
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.
When Microsoft Excel is used to manipulate, store and analyse data it can become extremely difficult to manage, let alone efficiently work to produce any meaningful insights. This is because with data sets large and small, the data must be meaningful, logical, structured, internally consistent and clean. This holds true regardless of whether the data has been imported into excel from another system or manually entered. In this computing age, most people know that for any data set to be useable it must first be relatively structured and clean. A spreadsheet and its table layout naturally encourages data to be somewhat structured, however ensuring data is clean is also difficult.
About four months after my husband asked for a divorce I made an appointment to meet a divorce attorney recommended by my therapist. She was 60 years old, short, smart and focused. I thought she was great. She charged $350.00 per hour. It was good that she was focused. I was at the time furious at my husband for his recent behaviors and I told her that I wanted to file for divorce immediately. Could she explain the process to me?