Testing and Refactoring Spreadsheets - Felienne Hermans at Eusprig 2014

  • Published on
    21-Nov-2014

  • View
    206

  • Download
    0

DESCRIPTION

 

Transcript

1. Testing and Refactoring Spreadsheets Felienne Hermans Delft University of Technology 2. Felienne Hermans Delft University of Technology Testing and Refactoring Spreadsheets 3. 95% of all U.S. firms use spreadsheets for financial reporting 4. 90% of all analysts in industry perform calculations in spreadsheets 5. Importance can grow over time 6. And, spreadsheet exist under the radar 7. Only 33% of spreadsheets has a manual 8. Complex spreadsheets without documentation can lead to serious errors 9. The European Spreadsheet Risk Interest Group (Eusprig.org) collects horror stories 10. Why? 11. No documentation, errors, long life It looks like? 12. No documentation, errors, long life It looks like software! 13. For software, tools have been created to help programmers write good code 14. We bring quality tools to spreadsheets 15. BumbleBee: A tool for spreadsheet improvement 16. But, not all transformations have to be behavior preserving 17. You can download BumbleBee from my website (felienne.com) 18. The transformations are entirely programmable, with a small language 19. Expector: A tool for spreadsheet testing 20. These test formulas can be exploited 21. Our tool Expector can find test formulas 22. Expector helps users to understand robustness of their spreadsheets 23. More info? Over drinks, send me an email (f.f.j.hermans@tudelft.nl) or visit felienne.com

Recommended

View more >