Standard

Improving the Performance of a Large Scale Spreadsheet : A Case Study. / Swidan, A.A.S.; Hermans, Felienne; Koesoemowidjojo, Ruben.

2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016. ed. / A. Jiu. Vol. 1 Piscataway, NJ : IEEE, 2016. p. 673-677.

Research output: Chapter in Book/Conference proceedings/Edited volumeConference contributionScientificpeer-review

Harvard

Swidan, AAS, Hermans, F & Koesoemowidjojo, R 2016, Improving the Performance of a Large Scale Spreadsheet: A Case Study. in A Jiu (ed.), 2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016. vol. 1, IEEE, Piscataway, NJ, pp. 673-677, SANER 2016, Osaka, Japan, 14/03/16. https://doi.org/10.1109/saner.2016.100

APA

Swidan, A. A. S., Hermans, F., & Koesoemowidjojo, R. (2016). Improving the Performance of a Large Scale Spreadsheet: A Case Study. In A. Jiu (Ed.), 2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016 (Vol. 1, pp. 673-677). Piscataway, NJ: IEEE. https://doi.org/10.1109/saner.2016.100

Vancouver

Swidan AAS, Hermans F, Koesoemowidjojo R. Improving the Performance of a Large Scale Spreadsheet: A Case Study. In Jiu A, editor, 2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016. Vol. 1. Piscataway, NJ: IEEE. 2016. p. 673-677 https://doi.org/10.1109/saner.2016.100

Author

Swidan, A.A.S. ; Hermans, Felienne ; Koesoemowidjojo, Ruben. / Improving the Performance of a Large Scale Spreadsheet : A Case Study. 2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016. editor / A. Jiu. Vol. 1 Piscataway, NJ : IEEE, 2016. pp. 673-677

BibTeX

@inproceedings{0a4e6ed82e184ec1bcc7815be4659ee8,
title = "Improving the Performance of a Large Scale Spreadsheet: A Case Study",
abstract = "Spreadsheets are used extensively for calculations in several domains, especially in finance and insurance. Spreadsheets offer a clear benefit to their users: they are an easy to learn application in which to express their business needs, however, there are downsides too. Like software, spreadsheets can have a long life span in which they are used by several people. This leads to maintainability issues, including errors, but also often to issues with performance. In this paper we present a case study in which a model for shortfall calculations, originally implemented in a spreadsheet, was adapted to run on an HPC cluster. We present the design, analysis and implementation of the solution which clearly improved the performance of the spreadsheet, with a factor of 50 in some cases. We subsequently reflect on challenges related to reverse engineering, testing and scalability. Finally, we identify opportunities that would provide automatic support to refactoring, dependency recognition and performance profiling in future spreadsheet optimization projects.",
keywords = "simulation models, spreadsheet optimization, large-scale, high-performance",
author = "A.A.S. Swidan and Felienne Hermans and Ruben Koesoemowidjojo",
year = "2016",
month = "5",
day = "23",
doi = "10.1109/saner.2016.100",
language = "English",
volume = "1",
pages = "673--677",
editor = "A. Jiu",
booktitle = "2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016",
publisher = "IEEE",
address = "United States",

}

RIS

TY - GEN

T1 - Improving the Performance of a Large Scale Spreadsheet

T2 - A Case Study

AU - Swidan, A.A.S.

AU - Hermans, Felienne

AU - Koesoemowidjojo, Ruben

PY - 2016/5/23

Y1 - 2016/5/23

N2 - Spreadsheets are used extensively for calculations in several domains, especially in finance and insurance. Spreadsheets offer a clear benefit to their users: they are an easy to learn application in which to express their business needs, however, there are downsides too. Like software, spreadsheets can have a long life span in which they are used by several people. This leads to maintainability issues, including errors, but also often to issues with performance. In this paper we present a case study in which a model for shortfall calculations, originally implemented in a spreadsheet, was adapted to run on an HPC cluster. We present the design, analysis and implementation of the solution which clearly improved the performance of the spreadsheet, with a factor of 50 in some cases. We subsequently reflect on challenges related to reverse engineering, testing and scalability. Finally, we identify opportunities that would provide automatic support to refactoring, dependency recognition and performance profiling in future spreadsheet optimization projects.

AB - Spreadsheets are used extensively for calculations in several domains, especially in finance and insurance. Spreadsheets offer a clear benefit to their users: they are an easy to learn application in which to express their business needs, however, there are downsides too. Like software, spreadsheets can have a long life span in which they are used by several people. This leads to maintainability issues, including errors, but also often to issues with performance. In this paper we present a case study in which a model for shortfall calculations, originally implemented in a spreadsheet, was adapted to run on an HPC cluster. We present the design, analysis and implementation of the solution which clearly improved the performance of the spreadsheet, with a factor of 50 in some cases. We subsequently reflect on challenges related to reverse engineering, testing and scalability. Finally, we identify opportunities that would provide automatic support to refactoring, dependency recognition and performance profiling in future spreadsheet optimization projects.

KW - simulation models

KW - spreadsheet optimization

KW - large-scale

KW - high-performance

U2 - 10.1109/saner.2016.100

DO - 10.1109/saner.2016.100

M3 - Conference contribution

VL - 1

SP - 673

EP - 677

BT - 2016 IEEE 23rd International Conference on Software Analysis, Evolution, and Reengineering, SANER 2016

A2 - Jiu, A.

PB - IEEE

CY - Piscataway, NJ

ER -

ID: 13969270