Ten Types of Spreadsheet or eWorkBook Applications

TYPE 1: Reference Library These eWorkBooks are databases or tables of data which are largely constant, and used as lookup values for calculations. They include such things as materials libraries, properties of chemical elements and such things. {MS Access or other DBMS potentially the better tool for this}

TYPE 2: Data Collection These are eWorkBooks that are used to collect variable data, and create data tables and simple lists. Examples would include book lists and price lists. {MS Access or other DBMS potentially the better tool for this.}

TYPE 3: Tabulated Calculations Tables of independent parameters and calculated dependent variables, with or without charts or graphs illustrating such relationships. {MS Access or other DBMS potentially the better tool for this.}

TYPE 4: Text Book Formula Sheets These are the type of eWorkBooks typically uploaded to ExcelCalcs and complying with their recommended template making use of XLC. Such worksheets typically restricted to a single A4 page, have a sketch to illustrate the parameters of the mathematical model, show the algebraic formula, show the numbers substituted in the formula and then show the numerical result. These are primarily for the purpose of studying and understanding the formula.

TYPE 5: Calculated Reports These are full technical reports, at least as far as the calculations go. Simply combining a series of Type-4 spreadsheets would not be appropriate for such reports. Such approach would generate a large amount of paper if so printed, or waste of hard-disk space if printed to pdf files, and most importantly a waste of time to read. Such calculated reports should be kept compact and concise, details of calculations are hidden behind the scenes, the reports display input parameters, and calculated results, but not necessarily the process of transformation from input to result. The user of such reports is expected to make independent checks on the results using other tools.

TYPE 6: Calculators and Dashboards These can be simple or complex, either way no printed report is generated. These obtain input parameters and calculate results, how such transformation takes place is not shown. The purpose of such tools is rapid decision making. Such tools are likely used by persons checking Type-5 workbooks.

TYPE 7: Applications These eWorkBooks can make little to extensive use of visual basic for applications (vba) and custom dialogue forms. The main features are that the workbook has the simple interface of Type-6 calculators, but can produce the reports of Type-5, or otherwise more detailed trace similar to Type-4, as well as produce tabulated reports based on variations in magnitude of input parameters similar to Type-3. Also likely to include data collection (Type-2), and rely on information extracted from libraries (Type-1).

TYPE 8: Function Libraries Libraries of additional functions., which extend or otherwise simplify the calculation capabilities of the primary workbook application (eg, MS Excel).

TYPE 9: Utility Library/Add-In Extends the features of the primary application (eg.MS Excel), but not the calculation capability. (eg. XLC).

TYPE:10: Other. Those types of spreadsheets not mentioned elsewhere.