深圳大学管理学院：《运筹学》课程教学资源（PPT课件讲稿）规划论（线性规划）运筹学3类 SPREADHEET MODELLING WITH EXCEL简介

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