1 / 10

Engineering Spreadsheet Design for Effective Planning Process

This lecture emphasizes the importance of planning in engineering and how efficient spreadsheet design can aid in the process. It covers the phases of spreadsheet modeling - designing, building, and testing - with an example problem of an Influence Diagram Excel Model.

thane-gay
Download Presentation

Engineering Spreadsheet Design for Effective Planning Process

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Lecture 3: Spreadsheet Engineering

  2. Spreadsheet Engineering • Builders use blueprints or plans. • Without plans structures will fail to be effective. • Advanced planning in any sort of design can speed up implementation. • Spreadsheets are no different from other arenas of design. • Engineering and advanced planning aids effectiveness.

  3. Spreadsheet Design • An efficient process minimizes time spent. • An effective process yields results that meet users’ requirements. • Good design helps analysts spend the majority of their effort improving decisions, rather than building and fixing models.

  4. The Phases of Spreadsheet Modeling • Designing • Building • Testing

  5. Example

  6. Problem

  7. Influence Diagram

  8. Excel Model Excel Model

More Related