Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Outgrowing Spreadsheets, Moving to Rails

2769d4f1f9abeb4dd2438ff636a9e4dc?s=47 Ray Hightower
December 05, 2016

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.

2769d4f1f9abeb4dd2438ff636a9e4dc?s=128

Ray Hightower

December 05, 2016
Tweet

Transcript

  1. Outgrowing Spreadsheets + Moving to Rails @RayHightower ConFoo - Dec

    5-7, 2016 Vancouver, BC Canada
  2. Pain: Spreadsheet

  3. Commercial Real Estate

  4. None
  5. None
  6. None
  7. None
  8. None
  9. Share the spreadsheet…

  10. None
  11. None
  12. None
  13. None
  14. Pain: Legacy App

  15. None
  16. None
  17. Training = Long Mistakes = Lots

  18. Enter

  19. None
  20. Back up… Understand the problem.

  21. Collaboration w/Client

  22. Face-to-face or video. Email = last.

  23. User Experience Design

  24. None
  25. To the User: The UX is the whole app.

  26. Wireframes

  27. None
  28. None
  29. None
  30. None
  31. None
  32. Test Driven Development

  33. Red Green Refactor

  34. Calculator Example

  35. None
  36. None
  37. None
  38. Why Refactor?

  39. None
  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

  47. None
  48. None
  49. Recap •Pain Sources •Pain Resolution •UX First •TDD •Dev Ops

  50. Thanks! RayHightower.com