Abstract:This paper demonstrates a methodology to help practitioners maximise the utility of complex multidisciplinary engineering models implemented as spreadsheets, an area presenting unique challenges. As motivation we investigate the expanding use of Integrated Resource Management(IRM) models which assess the sustainability of urban masterplan designs. IRM models reflect the inherent complexity of multidisciplinary sustainability analysis by integrating models from many disciplines. This complexity makes their use time-consuming and reduces their adoption. We present a methodology and toolkit for analysing multidisciplinary engineering models implemented as spreadsheets to alleviate such problems and increase their adoption. For a given output a relevant slice of the model is extracted, visualised and analysed by computing model and interdisciplinary metrics. A sensitivity analysis of the extracted model supports engineers in their optimisation efforts. These methods expose, manage and reduce model complexity and risk whilst giving practitioners insight into multidisciplinary model composition. We report application of the methodology to several generations of an industrial IRM model and detail the insight generated, particularly considering model evolution.

Risk Management for Complex Calculations: EuSpRIG Best Practices in Hybrid Applications

A Computational Framework for the Near Elimination of Spreadsheet Risk

Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel

Investigating the use of Software Agents to Reduce The Risk of Undetected Errors in Strategic Spreadsheet Applications

Automating Spreadsheet Discovery & Risk Assessment

Comparison of Spreadsheets with other Development Tools (limitations, solutions, workarounds and alternatives)

From Good Practices to Effective Policies for Preventing Errors in Spreadsheets

Reducing Spreadsheet Risk with FormulaDataSleuth

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

Governance of Spreadsheets through Spreadsheet Change Reviews

Transforming Critical Spreadsheets into Web Applications at Zurich Financial

Qtier-Rapor: Managing Spreadsheet Systems & Improving Corporate Performance, Compliance and Governance

Protecting Spreadsheets Against Fraud

Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics

Will Dynamic Arrays finally change the way Models are built?

Excel: Automated Ledger or Analytics IDE?

Establishing A Minimum Generic Skill Set For Risk Management Teaching In A Spreadsheet Training Course

A risk analysis framework for real-time control systems

Stochastic Formal Methods for Hybrid Systems

Simulation-based Probabilistic Risk Assessment

A Pilot Study Exploring Spreadsheet Risk in Scientific Research