M B A 8590 Chapter 4: Clemson - Decision Modeling - Book Notes - Ch 4 -2.02.17 - Jose Pena
Document Summary
Decision modeling 859 book notes ch. Modeling in spreadsheets is more an art than a science. Although no completely systematic procedure is available for modeling in spreadsheets there is a general process that should be followed. Sketch out blocks on a piece of paper for the various data cells, changing cells, and output cells (label them all) Should a block of numbers be in a row or a column or two-dimensional. Is there a way to arrange the blocks in consistent rows or columns so they can utilize the a single set of headings. Try to arrange the spreadsheet so that it starts with the data at the top and progresses logically toward the objective cell at the bottom. If it is a complicated model, you may want to start by building a small, readily manageable version of the model.