done with spreadsheets, which have lots of features with make them ideal:
- Formulas- preform calculations on the data and automatically update the page when data's changed
- functions which are built in complex formulas
- varibles- which hold key data about the model
- page is layed out in a logical way (in rows and columns)
- it's easy to replicate formulas and functions by dragging them across or copying and pasteing them.
- able to preform 'what if' tasks, which is used to predict certain things in the model, the user justs adjusts the data and then sees what effect it has on the rest of the model eg- if a spreadsheet was modelling a new product's revenue then the user could change the price, sales figures and budget to see how these changes would effect the total profit of the product.
Comments
No comments have yet been made