Solving Problems with a Spreadsheet

I've covered the basic concept of a spreadsheet application, discussed the end users and developers of such applications, and even attempted to figure out why people use spreadsheets at all. Now it's time to take a look at the types of tasks that are appropriate for spreadsheet applications.

You might already have a pretty good idea of the types of tasks for which you can use a spreadsheet. Traditionally, spreadsheet software has been used for numerical applications that are largely interactive in nature. Corporate budgets are an excellent example of this. After the model has been set up (that is, after formulas have been developed), working with a budget is simply a matter of plugging in amounts and observing the bottom-line totals. Often, budgeters simply need to allocate fixed resources among various activities and present the results in a reasonably attractive (or at least legible) format. A spreadsheet, of course, is ideal for this.

Budget-type problems, however, probably account for only a small percentage of your spreadsheet-development time. If you're like me, you've learned that uses for spreadsheet software (particularly in recent years) can often extend well beyond the types of tasks for which spreadsheets were originally designed.

Here are just a few examples of nontraditional ways that a spreadsheet such as Excel can be used:

♦ As a presentation device: For example, with minimal effort you can create an attractive, interactive on-screen slideshow with only Excel.

♦ As a data-entry tool: For repetitive data-entry tasks, a spreadsheet is often the most efficient route to take. The data can then be exported to a variety of formats for use in other programs.

♦ As a forms generator: For creating attractive printed forms, many find it easier to use Excel's formatting capabilities than to learn a desktop publishing package such as PageMaker.

♦ As a text processor: The text functions found in all spreadsheets enable you to manipulate text in ways that are impossible using a word processor.

♦ As a platform for simple games: Clearly, Excel was not designed with this in mind. However, I've downloaded (and written) some interesting strategy games by using the tools found in Excel and other spreadsheets.

You can probably think of many more examples for this list.

Ironically, the versatility of spreadsheets is a double-edged sword. On one hand, it's tempting to try to use a spreadsheet for every problem that crops up. On the other hand, you'll often be spinning your wheels by trying to use a spreadsheet for a problem that's better suited for a different solution.