BumbleBee: A refactoring environment for spreadsheet formulas

Felienne Hermans, Danny Dig

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

19 Citations (Scopus)

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.

Original languageEnglish
Title of host publicationFSE 2014
Subtitle of host publicationProceedings of the 22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering
Place of PublicationNew York,NY
PublisherAssociation for Computing Machinery (ACM)
Pages747-750
Number of pages4
ISBN (Electronic)978-1-4503-3056-5
DOIs
Publication statusPublished - 16 Nov 2014
Event22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014 - Hong Kong, China
Duration: 16 Nov 201421 Nov 2014

Conference

Conference22nd ACM SIGSOFT International Symposium on the Foundations of Software Engineering, FSE 2014
Country/TerritoryChina
CityHong Kong
Period16/11/1421/11/14

Keywords

  • End-user programming
  • Spreadsheets
  • Transformation

Fingerprint

Dive into the research topics of 'BumbleBee: A refactoring environment for spreadsheet formulas'. Together they form a unique fingerprint.

Cite this