Modelling

1. Financial Modelling

1.1. A model is a program wrote in order to simulate real life experiences.

1.2. In this case, financial modelling, uses mathematical formulas and complex calculations to predict what is likely to happen in a future.

2. Spreadsheet Modelling

2.1. In order to create a model we need a set of input values, work with them and provide one or more output values.

2.2. Spreadsheets are usually used because they can deal with lots of data and work with them. This is usually used in business decisions because it allows tests and get the results immediately.

3. Features

3.1. Supports the idea of variables - (VAT rate)

3.2. Formulas - (=B2*B3)

3.3. Functions - (=SUM(B2,B3))

3.4. Goal Seek

3.5. Graphs - (to represent data visually)

4. Characteristics

4.1. - Sort Data - Absolute and relative reference - Protect cells form changes - User interface - Macro language - Automatic calculations - Conditional formatting - Import and Export - Filtering data - Lookup tables - Pivot tables - Replication - Graphing

5. Object Modelling

6. Physical Models

6.1. Simulations e.g new navy ship

7. Mathematical Models

7.1. Simulation e.g speed, acceleration...

8. - Disease modelling (tries to predict how epidemics spread) - Weather modelling (for tomorrow (short term model) and also long term modelling) - Earthquake modelling (likelyhood of one happening and the likely damage caused) - Bridge building (how it will behave in wind and heavy use) - Roller coaster design (excite the customer yes! but don't harm them!) - Car design (predict its performance and how materials such as steel will behave) - Car crash testing (predict the damage in a crash and help protect people)racing - Game Simulation (most games are a kind of object model, but it is just for fun)