Organizational factors affecting the success of end-user computing
Journal of Management Information Systems
International Journal of Human-Computer Studies
What we know about spreadsheet errors
Journal of End User Computing - End User Development
Refactoring: improving the design of existing code
Refactoring: improving the design of existing code
Using a structured design approach to reduce risks in end user spreadsheet development
Information and Management
The spreadsheet interface: A basis for end user programming
INTERACT '90 Proceedings of the IFIP TC13 Third Interational Conference on Human-Computer Interaction
Detecting Design Flaws via Metrics in Object-Oriented Systems
TOOLS '01 Proceedings of the 39th International Conference and Exhibition on Technology of Object-Oriented Languages and Systems (TOOLS39)
Object-Oriented Metrics in Practice
Object-Oriented Metrics in Practice
WEUSE I Proceedings of the first workshop on End-user software engineering
Inferring templates from spreadsheets
Proceedings of the 28th international conference on Software engineering
Errors in Operational Spreadsheets: A Review of the State of the Art
HICSS '09 Proceedings of the 42nd Hawaii International Conference on System Sciences
The evolution and impact of code smells: A case study of two open source systems
ESEM '09 Proceedings of the 2009 3rd International Symposium on Empirical Software Engineering and Measurement
Discovery-based edit assistance for spreadsheets
VLHCC '09 Proceedings of the 2009 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Deriving metric thresholds from benchmark data
ICSM '10 Proceedings of the 2010 IEEE International Conference on Software Maintenance
The state of the art in end-user software engineering
ACM Computing Surveys (CSUR)
Supporting professional spreadsheet users by generating leveled dataflow diagrams
Proceedings of the 33rd International Conference on Software Engineering
Towards a catalog of spreadsheet smells
ICCSA'12 Proceedings of the 12th international conference on Computational Science and Its Applications - Volume Part IV
Data clone detection and visualization in spreadsheets
Proceedings of the 2013 International Conference on Software Engineering
Improving spreadsheet test practices
CASCON '13 Proceedings of the 2013 Conference of the Center for Advanced Studies on Collaborative Research
Comparing or configuring products: are we getting the right ones?
Proceedings of the Eighth International Workshop on Variability Modelling of Software-Intensive Systems
Hi-index | 0.00 |
Spreadsheets are often used in business, for simple tasks, as well as for mission critical tasks such as finance or forecasting. Similar to software, some spreadsheets are of better quality than others, for instance with respect to usability, maintainability or reliability. In contrast with software however, spreadsheets are rarely checked, tested or certified. In this paper, we aim at developing an approach for detecting smells that indicate weak points in a spreadsheet's design. To that end we first study code smells and transform these code smells to their spreadsheet counterparts. We then present an approach to detect the smells, and communicate located smells to spreadsheet users with data flow diagrams. We analyzed occurrences of these smells in the Euses corpus. Furthermore we conducted ten case studies in an industrial setting. 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.