Nan Candice May 12, 2021 Spreadsheet
”Rippeto‘s Rendezvous” was only a block away, and attracted patrons from all levels of the social spectrum: Primarily fringe types, college students, and the occasional Young Urban Professional. It was near the University, and close to Civic Arena and Three Rivers Stadium. On clear nights, you could look out Rippeto‘s windows and see the Monongahela River afire in the distance. Two things are striking about Rippeto‘s when one weasels through the wall of humanity standing outside, and plasters oneself against an identical living wall inside: The smoke and the smell.
In a well-designed spreadsheet, any output can be calculated from the raw data. However, that‘s not always enough. Sometimes the output is fixed and the raw data is variable. Let‘s say you run an investment company and want to offer your clients a fixed return. An Excel expert could create a very complex model to calculate the likely return on investments over a fixed period. You could then calculate the internal rate of return being offered to clients. The problem is that you‘re not interested in the return offered to clients; that is, after all, fixed. Instead you‘re concerned with how much money you expect to draw from the investment fund, whilst still offering your investors a satisfactory return. If you have $1 and owe investors a quarter, you can calculate your profits using a simple formula.
”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.
Here‘s where the expense sheet gets complex. All of your categories of spending go in column A. Get as detailed as you like, or keep it really simple and just put the basic categories. Generally, the more detail the better. it‘s also helpful to have categories for your categories. A Utilities category for your power, gas, water, etc, categories. Again, detail is good, but be wary of going into too much detail. Column B is where you‘ll put the amount that you‘re budgeting for that category. Column C, how much you‘ve spent on that category to date. If you like (or are a statistics junkie) you can add columns for % of budgeted amount, and % of total budget as well. For our simple budget, we‘ll just leave that out for now.
Spreadsheets such as Microsoft Excel are well suited to tasks involving the manipulation of small amounts of related data. Working out a budget, producing visual reports, organizing lists and calculations that involve many variables are all tasks well suited to a spreadsheet. There are some data related tasks however that spreadsheets such as Microsoft Excel are not suited for. Tasks involving the processing and combination of large sets of data for example are generally not well suited to spreadsheets. There is another technology with a long history and theoretical background that specializes in these sorts of tasks. That technology is relational databases. The most common way people insert data into and extract data from relational databases is via the language of Structured Query Language.
These common complaints with Microsoft Excel filtering are heard time and time again by engineers, accountants, management consultants, bankers and finance professionals who work with data in Excel spreadsheets on a daily basis. Many spreadsheet users including financial modellers (who seem to be leading the charge) are turning towards Excel Add-ins and software tools that plug into Microsoft Excel to help them improve the in-built filtering logic of Microsoft Excel and thus analyse certain data sets quickly and easily.
Tag Cloudmadcow spreadsheet