Chapter 4 SPREADHEET MODELLING WITH EXCEL STEP 1 PLANNING THE MODEL c& Developing the Conceptual Paper Worksheet ( CPW) STEP 2: TRANSLATING THE CPW INTO A SPREADSHEET MODEL CR Cell reFerencing cR Saving a spreadsheet model c& Entering the OUTPUTS cR Entering the TOT REV Column (R Absolute and relative addressing
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
oR Copying a formula cR Entering the TOT COST Column CR 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
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
STEP 4 CREATING A GRAPH cRFollow 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
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
SOLVING SIMULTANEOUS EQUATIONS 10-20 TR 0 A=01-15x=TCb=500 1-10 q 0 3xl 3x1 x=Ab
SOLVING SIMULTANEOUS EQUATIONS x A b b q TC TR A x x x 1 3x3 3 1 3 1 0 500 0 1 1 0 0 1 15 1 0 20 − = = = − − − =
Enter the data as shown below,(Fig 13) Solving the equations as a two stage process o& Stage 1: find the inverse of the a matrix c& Stage 2: multiply this inverse by the b matrix Solving the equations as a one stage process
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