Standard

BumbleBee : A refactoring environment for spreadsheet formulas. / Hermans, Felienne; Dig, Danny.

FSE 2014 : Proceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering. New York,NY : Association for Computing Machinery (ACM), 2014. p. 747-750.

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

Harvard

Hermans, F & Dig, D 2014, BumbleBee: A refactoring environment for spreadsheet formulas. in FSE 2014 : Proceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering. Association for Computing Machinery (ACM), New York,NY, pp. 747-750, 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014, Hong Kong, China, 16/11/14. https://doi.org/10.1145/2635868.2661673

APA

Hermans, F., & Dig, D. (2014). BumbleBee: A refactoring environment for spreadsheet formulas. In FSE 2014 : Proceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering (pp. 747-750). Association for Computing Machinery (ACM). https://doi.org/10.1145/2635868.2661673

Vancouver

Hermans F, Dig D. BumbleBee: A refactoring environment for spreadsheet formulas. In FSE 2014 : Proceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering. New York,NY: Association for Computing Machinery (ACM). 2014. p. 747-750 https://doi.org/10.1145/2635868.2661673

Author

Hermans, Felienne ; Dig, Danny. / BumbleBee : A refactoring environment for spreadsheet formulas. FSE 2014 : Proceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering. New York,NY : Association for Computing Machinery (ACM), 2014. pp. 747-750

BibTeX

@inproceedings{d4165324bae6425db68218319ba248ef,
title = "BumbleBee: A refactoring environment for spreadsheet formulas",
abstract = "Spreadsheets are widely used in industry. It is estimated that end-user programmers outnumber regular programmers by a factor of 5. However, spreadsheets are error-prone: several reports exist of companies that have lost big sums of money due to spreadsheet errors. In previous work, spreadsheet smells have proven to be the cause of some of these errors. To that end, we have developed a tool that can apply refactorings to spreadsheet formulas, implementing our previous work on spreadsheet refactoring, which showed that spreadsheet formula smells are very common and that refactorings for them are widely applicable and that refactoring them with a tool is both quicker and less error-prone. Our new tool Bumblebee is able to execute refactorings originating from both these papers, by means of an extensible syntax, and can furthermore apply refactorings on entire groups of formulas, thus improving upon the existing tool RefBook. Finally, BumbleBee can also execute transformations other than refactorings.",
keywords = "End-user programming, Spreadsheets, Transformation",
author = "Felienne Hermans and Danny Dig",
year = "2014",
month = nov,
day = "16",
doi = "10.1145/2635868.2661673",
language = "English",
pages = "747--750",
booktitle = "FSE 2014",
publisher = "Association for Computing Machinery (ACM)",
address = "United States",
note = "22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014 ; Conference date: 16-11-2014 Through 21-11-2014",

}

RIS

TY - GEN

T1 - BumbleBee

T2 - 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014

AU - Hermans, Felienne

AU - Dig, Danny

PY - 2014/11/16

Y1 - 2014/11/16

N2 - Spreadsheets are widely used in industry. It is estimated that end-user programmers outnumber regular programmers by a factor of 5. However, spreadsheets are error-prone: several reports exist of companies that have lost big sums of money due to spreadsheet errors. In previous work, spreadsheet smells have proven to be the cause of some of these errors. To that end, we have developed a tool that can apply refactorings to spreadsheet formulas, implementing our previous work on spreadsheet refactoring, which showed that spreadsheet formula smells are very common and that refactorings for them are widely applicable and that refactoring them with a tool is both quicker and less error-prone. Our new tool Bumblebee is able to execute refactorings originating from both these papers, by means of an extensible syntax, and can furthermore apply refactorings on entire groups of formulas, thus improving upon the existing tool RefBook. Finally, BumbleBee can also execute transformations other than refactorings.

AB - Spreadsheets are widely used in industry. It is estimated that end-user programmers outnumber regular programmers by a factor of 5. However, spreadsheets are error-prone: several reports exist of companies that have lost big sums of money due to spreadsheet errors. In previous work, spreadsheet smells have proven to be the cause of some of these errors. To that end, we have developed a tool that can apply refactorings to spreadsheet formulas, implementing our previous work on spreadsheet refactoring, which showed that spreadsheet formula smells are very common and that refactorings for them are widely applicable and that refactoring them with a tool is both quicker and less error-prone. Our new tool Bumblebee is able to execute refactorings originating from both these papers, by means of an extensible syntax, and can furthermore apply refactorings on entire groups of formulas, thus improving upon the existing tool RefBook. Finally, BumbleBee can also execute transformations other than refactorings.

KW - End-user programming

KW - Spreadsheets

KW - Transformation

UR - http://www.scopus.com/inward/record.url?scp=84986893427&partnerID=8YFLogxK

U2 - 10.1145/2635868.2661673

DO - 10.1145/2635868.2661673

M3 - Conference contribution

AN - SCOPUS:84986893427

SP - 747

EP - 750

BT - FSE 2014

PB - Association for Computing Machinery (ACM)

CY - New York,NY

Y2 - 16 November 2014 through 21 November 2014

ER -

ID: 45796128