I m a g i n e I T   T o o l b a r

How to write models
(and carry out calculations based on data)

What is involved

To write a spreadsheet based model (or to peform calculations based on numerical data), you normally have:

  • a table containing columns of values (which can be both numerical values and calculated quantities)

  • cells containing quantities that have just one value - these can be numerical values and calculated quantities, and they are often constants or parameters of some sort

magineIT enables you to set up one or two tables and up to five blocks of single-valued quantities, (which we will refer to as parameters).

Looking at an example of a spreadsheet model

Here is a simple example of a model that you can download (right-click and save to your hard disc): Savings.xls