Outgrowing Spreadsheets, Moving to Rails

Excel spreadsheets are ok for quick analysis, but when the rows are too many and the formulas are too complex, recalc time slows to a crawl. Plus, sharing a spreadsheet is cumbersome due to security and version control headaches.

This presentation will take the audience through a conversion from an old, slow spreadsheet into a zippy Ruby on Rails app.

Transcript

1. Outgrowing Spreadsheets + Moving to Rails @RayHightower ConFoo - Dec 5-7, 2016 Vancouver, BC Canada
2. Pain: Spreadsheet
3. Commercial Real Estate
9. Share the spreadsheet…
14. Pain: Legacy App
17. Training = Long Mistakes = Lots
18. Enter
20. Back up… Understand the problem.
21. Collaboration w/Client
22. Face-to-face or video. Email = last.
23. User Experience Design
25. To the User: The UX is the whole app.
26. Wireframes
32. Test Driven Development
33. Red Green Refactor
34. Calculator Example
38. Why Refactor?
40. TDD encourages flexible code. Well-tested code.
41. TDD leads to well-tested code.
42. TDD leads to more adaptable code.
43. Dev Ops
44. Redundancy Redundancy Redundancy
45. Infrastructure
46. Bonus: Delight the Client
49. Recap •Pain Sources •Pain Resolution •UX First •TDD •Dev Ops
50. Thanks! RayHightower.com