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

Outgrowing Spreadsheets, Moving to Rails

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.

Ray Hightower

December 05, 2016
Tweet

More Decks by Ray Hightower

Other Decks in Business

Transcript

  1. Outgrowing
    Spreadsheets +
    Moving to Rails
    @RayHightower
    ConFoo - Dec 5-7, 2016
    Vancouver, BC
    Canada

    View Slide

  2. Pain:
    Spreadsheet

    View Slide

  3. Commercial
    Real Estate

    View Slide

  4. View Slide

  5. View Slide

  6. View Slide

  7. View Slide

  8. View Slide

  9. Share the
    spreadsheet…

    View Slide

  10. View Slide

  11. View Slide

  12. View Slide

  13. View Slide

  14. Pain:
    Legacy App

    View Slide

  15. View Slide

  16. View Slide

  17. Training = Long
    Mistakes = Lots

    View Slide

  18. Enter

    View Slide

  19. View Slide

  20. Back up…
    Understand
    the problem.

    View Slide

  21. Collaboration
    w/Client

    View Slide

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

    View Slide

  23. User
    Experience
    Design

    View Slide

  24. View Slide

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

    View Slide

  26. Wireframes

    View Slide

  27. View Slide

  28. View Slide

  29. View Slide

  30. View Slide

  31. View Slide

  32. Test Driven
    Development

    View Slide

  33. Red Green
    Refactor

    View Slide

  34. Calculator
    Example

    View Slide

  35. View Slide

  36. View Slide

  37. View Slide

  38. Why Refactor?

    View Slide

  39. View Slide

  40. TDD encourages
    flexible code.
    Well-tested code.

    View Slide

  41. TDD leads to
    well-tested code.

    View Slide

  42. TDD leads to
    more adaptable
    code.

    View Slide

  43. Dev Ops

    View Slide

  44. Redundancy
    Redundancy
    Redundancy

    View Slide

  45. Infrastructure

    View Slide

  46. Bonus:
    Delight the
    Client

    View Slide

  47. View Slide

  48. View Slide

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

    View Slide

  50. Thanks!
    RayHightower.com

    View Slide