Download
1 / 10
100 likes | 236 Vues
This lecture delves into the principles of Spreadsheet Engineering, emphasizing the importance of using blueprints and advanced planning for effective designs. Just like in traditional engineering, spreadsheets require structured planning to ensure successful outcomes. An efficient spreadsheet design minimizes time and enhances the process, allowing analysts to focus on improving decision-making rather than correcting models. The lecture outlines the critical phases of spreadsheet modeling: Designing, Building, and Testing, and highlights the use of influence diagrams and Excel models for real-world applications.
E N D
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.
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.
The Phases of Spreadsheet Modeling • Designing • Building • Testing
Excel Model Excel Model
