Chapter 4 SPREADHEET MODELLING WITH EXCEL

1. Chapter 4 SPREADHEET MODELLING WITH EXCEL • STEP 1 PLANNING THE MODEL • Developing the Conceptual Paper Worksheet (CPW) • STEP 2: TRANSLATING THE CPW INTO A SPREADSHEET MODEL • Cell referencing • Saving a spreadsheet model: • Entering the OUTPUTS • Entering the TOT REV Column • Absolute and relative addressing

2. Copying a formula • Entering the TOT COST Column • Entering the TOT COST Column • STEP 3 TIDYING UP THE SPREADSHEET MODEL • Adjusting the column widths • Formatting the contents of the cells • Interrogating the model

3. STEP 4 CREATING A GRAPH • Follow Step 1 to step 4--- THE CHART WIZARD ICON • Making minor Changes to the graph • Scaling of x-axis and y-axis • Modifying The Model • Creating a Copy of the Original Model • Creating a copy of the original Chart • Modifying the Original Chart

4. SOLVING SIMULTANEOUS EQUATIONS

5. Enter the data as shown below, (Fig 13). • Solving the equations as a two stage process • Stage 1: find the inverse of the A matrix • Stage 2: multiply this inverse by the b matrix • Solving the equations as a one stage process