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 full-size slide

  2. Pain:
    Spreadsheet

    View full-size slide

  3. Commercial
    Real Estate

    View full-size slide

  4. Share the
    spreadsheet…

    View full-size slide

  5. Pain:
    Legacy App

    View full-size slide

  6. Training = Long
    Mistakes = Lots

    View full-size slide

  7. Back up…
    Understand
    the problem.

    View full-size slide

  8. Collaboration
    w/Client

    View full-size slide

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

    View full-size slide

  10. User
    Experience
    Design

    View full-size slide

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

    View full-size slide

  12. Test Driven
    Development

    View full-size slide

  13. Red Green
    Refactor

    View full-size slide

  14. Calculator
    Example

    View full-size slide

  15. Why Refactor?

    View full-size slide

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

    View full-size slide

  17. TDD leads to
    well-tested code.

    View full-size slide

  18. TDD leads to
    more adaptable
    code.

    View full-size slide

  19. Redundancy
    Redundancy
    Redundancy

    View full-size slide

  20. Infrastructure

    View full-size slide

  21. Bonus:
    Delight the
    Client

    View full-size slide

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

    View full-size slide

  23. Thanks!
    RayHightower.com

    View full-size slide