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
UR - http://www.scopus.com/inward/citedby.url?scp=84986893427&partnerID=8YFLogxK
U2 - 10.1145/2635868.2661673
DO - 10.1145/2635868.2661673
M3 - Conference contribution
AN - SCOPUS:84986893427
T3 - Proceedings of the ACM SIGSOFT Symposium on the Foundations of Software Engineering
SP - 747
EP - 750
BT - 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014 - Proceedings
PB - Association for Computing Machinery
Y2 - 16 November 2014 through 21 November 2014
ER -