Basic Spreadsheet Types

Vertex42 The Excel Nexus

Professional Excel Templates

Get Instant Access

In this section, I classify spreadsheets into several basic types to provide a better perspective on how spreadsheet applications fit into the overall scheme of things. This is all quite arbitrary, of course, and is based solely on my own experience. Moreover, there is quite a bit of overlap between the categories, but they cover most of the spreadsheets that I've seen and developed.

My names for these categories are as follows:

■ Single-user applications

■ Spaghetti applications

■ Utility applications

■ Add-ins that contain worksheet functions

■ Single-block budgets

■ Data storage and access

■ Database front ends

■ Turnkey applications

I discuss each of these categories in the following sections.

Was this article helpful?

0 0

Post a comment