运筹学2类电子表格建模艺术.pptVIP

Copyright 2007 ? 深圳大学管理学院 运筹学 * Chapter 3. The Art of Modeling with Spreadsheets 第三章. 电子表格建模的艺术 运筹学 The Everglade Golden Years Co. Cash Flow Problem (Section 3.1)(大沼泽地金色年代公司的现金流问题[第3.1节]) The Process of Modeling with Spreadsheets (Section 3.2)(使用电子表格建模的过程[第3.2节]) Guidelines for Building “Good” Spreadsheet Models (Section 3.3)(建立好的电子表格模型的原则[第3.3节]) Debugging a Spreadsheet Model (Section 3.4)(调试电子表格模型[第3.4节]) Table of Contents (主要内容) The Everglade Cash Flow Problem Year Projected Net Cash Flow (millions of dollars) 2003 –8 2004 –2 2005 –4 2006 3 2007 6 2008 3 2009 –4 2010 7 2011 –2 2012 10