Published on July 14, 2014
Testing and Refactoring Spreadsheets Felienne Hermans Delft University of Technology
Felienne Hermans Delft University of Technology Testing and Refactoring Spreadsheets
95% of all U.S. firms use spreadsheets for financial reporting
90% of all analysts in industry perform calculations in spreadsheets
Importance can grow over time
And, spreadsheet exist ‘under the radar’
Only 33% of spreadsheets has a manual
Complex spreadsheets without documentation can lead to serious errors
The European Spreadsheet Risk Interest Group (Eusprig.org) collects horror stories
No documentation, errors, long life It looks like…?
No documentation, errors, long life It looks like software!
For software, tools have been created to help programmers write good code
We bring quality tools to spreadsheets
BumbleBee: A tool for spreadsheet improvement
But, not all transformations have to be behavior preserving
You can download BumbleBee from my website (felienne.com)
The transformations are entirely programmable, with a small language
Expector: A tool for spreadsheet testing
These test formulas can be exploited
Our tool Expector can find test formulas
Expector helps users to understand robustness of their spreadsheets
More info? Over drinks, send me an email (firstname.lastname@example.org) or visit felienne.com
Home; Documents; Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014
Program Eusprig 2014 announced. March 31, 2014 Felienne Hermans 18 Comments. ... Testing and refactoring spreadsheets ...
April 29, 2014 Felienne Hermans 1 Comment. ... Felienne Hermans: 9:30: ... Testing and refactoring spreadsheets ...
... Testing and Refactoring Spreadsheets http://www.slideshare.net/eusprig/felienne-hermans-at-eusprig-2014 ... net/Proceedings/vol3/html ...
... Refactoring and Unit Testing This handout ... Refactoring Example In this ... Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014.
Share Slides Felienne Hermans Symposium EWI. ... (Eusprig) collects horror stories. 20. ... Testing and Refactoring Spreadsheets ...
Detecting and refactoring code smells in ... Proceedings of EuSpRIG ’12 ... Gathering domain knowledge from spreadsheets – Felienne Hermans ...
March 26, 2014 felienne Press. ... Who is testing the spreadsheets?, ... Infotron: Felienne Hermans Embraces Errors, ...