Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014

40 %
60 %
Information about Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014

Published on July 14, 2014

Author: eusprig

Source: slideshare.net

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

Why?

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 (f.f.j.hermans@tudelft.nl) or visit felienne.com

Add a comment

Related pages

Testing and Refactoring Spreadsheets - Felienne Hermans at ...

Home; Documents; Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014
Read more

March | 2014 - Spreadsheet Lab

Program Eusprig 2014 announced. March 31, 2014 Felienne Hermans 18 Comments. ... Testing and refactoring spreadsheets ...
Read more

Felienne Hermans - Spreadsheet Lab

April 29, 2014 Felienne Hermans 1 Comment. ... Felienne Hermans: 9:30: ... Testing and refactoring spreadsheets ...
Read more

Spreadsheets - 90+ million End User Programmers With No ...

... Testing and Refactoring Spreadsheets http://www.slideshare.net/eusprig/felienne-hermans-at-eusprig-2014 ... net/Proceedings/vol3/html ...
Read more

Refactoring And Unit Testing - Documents

... Refactoring and Unit Testing This handout ... Refactoring Example In this ... Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014.
Read more

Slides Felienne Hermans Symposium EWI - Technology

Share Slides Felienne Hermans Symposium EWI. ... (Eusprig) collects horror stories. 20. ... Testing and Refactoring Spreadsheets ...
Read more

Publications – Felienne's blog

Detecting and refactoring code smells in ... Proceedings of EuSpRIG ’12 ... Gathering domain knowledge from spreadsheets – Felienne Hermans ...
Read more

Press – Felienne's blog

March 26, 2014 felienne Press. ... Who is testing the spreadsheets?, ... Infotron: Felienne Hermans Embraces Errors, ...
Read more