• Corpus ID: 1544985

Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics

@article{Birch2014MultidisciplinaryEM,
  title={Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics},
  author={David Birch and Helen Liang and Paul H. J. Kelly and Glen Mullineux and Tony Field and Joan Ko and Alvise Simondetti},
  journal={ArXiv},
  year={2014},
  volume={abs/1401.4582}
}
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… 

Figures from this paper

Constraint-based thinking towards enhancing complex interdisciplinary designing
There are as many perspectives in designing as there have been instances in which it has occured. In each instance, constraints will have invariably arisen in various forms, to the extent that
The Future of Spreadsheets in the Big Data Era
TLDR
The views of the participants on the reasons for the success of the spreadsheet, the trends driving change and the likely directions of change for the spreadsheet are records and key directions for further research in the evolution and use of spreadsheets are set.
Abstracting spreadsheet data flow through hypergraph redrawing
TLDR
A method of raising the level of abstraction of spreadsheets by "redrawing the boundary" of the cell is proposed and illustrated via common sub-expression identification and the application of sub-tree isomorphisms for the detection of vector (array) operations.

References

SHOWING 1-10 OF 19 REFERENCES
Supporting professional spreadsheet users by generating leveled dataflow diagrams
TLDR
This paper first study the problems and information needs of professional spreadsheet users by means of a survey conducted at a large financial company, and presents an approach that extracts this information from spreadsheets and presents it in a compact and easy to understand way, with leveled dataflow diagrams.
Extraction and analysis methodology for supporting complex sustainable design
TLDR
The paper discusses the use of a methodology that seeks to support the decision making process and design optimization for complex sustainable designs based upon automatically studying the relations between design parameters so that their interdependencies can be obtained and sensitivities established.
506: The Integrated Resource Management (IRM) model - a guidance tool for sustainable urban design
Traditionally the master-plan of an urban design development is centred around the land use schedule proposed by an urban design team. Technical teams (for transport, energy, waste, water, etc.) then
Detecting and visualizing inter-worksheet smells in spreadsheets
TLDR
The results of the evaluation indicate that smells can indeed reveal weaknesses in a spreadsheet's design, and that data flow diagrams are an appropriate way to show those weaknesses.
An end-user oriented graph-based visualization for spreadsheets
TLDR
This paper presents a spreadsheet visualization approach that is mainly based on the Markov Clustering (MCL) algorithm in an attempt to help spreadsheet users understand and debug their spreadsheets.
Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging
TLDR
This paper presents an integrated testing and debugging methodology for spreadsheets that is tightly integrated into the spreadsheet environment and provides an interface to the methodology that does not require an understanding of testing and debug theory, and that takes advantage of the immediate visual feedback that is characteristic of the spreadsheet paradigm.
Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance
TLDR
This paper proposes to use (complexity) measures as indicators for proper visualization, and proposes different visualization and representation methods that may ease spreadsheet comprehension but should not be applied with all kind of spreadsheet programs.
Agile Principles, Patterns, and Practices in C# (Robert C. Martin)
TLDR
This book presents a series of case studies illustrating the fundamentals of Agile development and Agile design, and moves quickly from UML models to real C# code.
Heuristics for the automatic identification of irregularities in spreadsheets
TLDR
It is found that most end users are willing to verify their spreadsheets, but only view have the time and skills to do really systematic testing of spreadsheets.
An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas
TLDR
The development of an automated (electronic) means for detecting such hard coding is described together with a discussion of some results obtained through analysis of a number of student and practitioner spreadsheet models.
...
...