Lucille Rose May 1, 2021 Spreadsheet
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.
It does have one severe limitation. Goal seek is not a formula. It does not permanently reside in the spreadsheet or the selected cells. Therefore you have to re-run Goal Seek each and every time you change the spreadsheet. Often this is acceptable because you have created a model specifically to calculate that one parameter. Having said that, there will be occasions where this is inadequate. What are the plans for your meeting or convention this year? Does it start with a budget or did you even do one last year? If you did one, did you do it the easy way with a Budget Spreadsheet for Meetings? Let us discuss your needs and see what forms and budgets can be facilitated the easy way. If approached correctly, you can cut your ”Hassle Factor” by more than half with the right event template.
Most planners are good at multi-tasking and have no problems designing a simple spreadsheet to handle a basic budget or designing a form to handle registration. So, you spend your time designing and stressing out. You end up with a variety of forms that each handle a specific need like registration, exhibits, food expenses and budget. The forms are not connected and do not work together. Hence, you end up having to do additional work merging the information from the various forms into your budget. Why do this when there is a Budget Spreadsheet for Meetings on the market that will tie your history, individual forms and budget together? It is so easy that all you have to do is enter the information. The spreadsheet does the rest.
Templates are spreadsheets that are pre-formatted with text, colors, and/or formulas. They can be used to save you time and effort. Sometimes you are using a workbook as a template and don‘t even realize it. By this I mean you have a spreadsheet that you use daily, weekly or monthly. You may have to modify a few cells but the remainder of the spreadsheet is exactly the way you want it. It may be tedious to modify the cells but it is easier than recreating it from scratch. Guess what, you have the basis of a template!
Lester loved his numeric universe, but this was not how he had envisioned his life unfolding; flying hither and thither from his hometown of Hershey to wherever his firm wished to send him. Just because he was 38, single, and still living with his folks didn‘t mean his employer should take advantage of him which, in fact, his company did on a regular basis. After all, Lester had other important interests, too. The ”Four Bs” he called them: Botany, bowling, bugs and Buddy Holly. Myriad plants crowded his tiny room in his parent‘s house, forcibly sucking carbon dioxide out of anyone who entered. Bowling trophies – ranging in size from tiny silver cups to massive bronze edifices shaped like the Empire State Building – claimed space not dominated by flower pots, planter boxes, and hanging baskets.
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.