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

Outgrowing Spreadsheets, Moving to Rails

Ray Hightower
December 05, 2016
Business
0
300

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

See All by Ray Hightower
Syndication Case Study
rayhightower
0
7
Raspberry Pi is a Gateway Drug for GPUs
rayhightower
1
240
Exploring Parallelism with Raspberry Pi and Nvidia Jetson Nano
rayhightower
1
630
Why Should You Speak at ChicagoRuby?
rayhightower
0
40
ActionCable vs. Socket.io at ConFoo
rayhightower
0
2.2k
The Business of Parallelism
rayhightower
0
250
Creative Career Day
rayhightower
6
63
Kenya, IoT, and M-Pesa
rayhightower
1
70
Web Design, Development, Business, + IoT
rayhightower
0
220

Other Decks in Business

See All in Business
株式会社エビリー_会社紹介資料_エンジニア
eviryr_recruit
0
1.4k
20230527_ChatGPT部_第８回_オープニングトークとこの1週間のサマリ
doradora09
0
110
【株式会社センタード】採用候補者様向け会社紹介資料
centered
0
570
FastLabel / Product&Development向け / 採用資料
eisukeueta
0
4.1k
welcome to want.jp_採用資料
wantjp
0
18k
Supership Corporate Profile（会社紹介資料）/ Supership Corporate Profile
supership
1
52k
about
socialmatch
0
1.5k
コミューン株式会社説明資料
commmune
3
120k
[Leverages]会社紹介資料_エンジニア職向け.pdf
leverages
0
240
MUFGトランジション白書 / MUFG Transition White Paper
mufg_cn
0
9.1k
MNTSQ CompanyDeck
mntsq
0
22k
HAKKO MAYO GEN
inetoagave
0
1.3k

Featured

See All Featured
A Tale of Four Properties
chriscoyier
149
21k
Designing Experiences People Love
moore
131
22k
Large-scale JavaScript Application Architecture
addyosmani
500
110k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
101
6.3k
Practical Orchestrator
shlominoach
179
9.1k
Designing the Hi-DPI Web
ddemaree
273
33k
Fashionably flexible responsive web design (full day workshop)
malarkey
395
64k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
23
1.8k
The Language of Interfaces
destraynor
149
21k
Happy Clients
brianwarren
90
6k
Design by the Numbers
sachag
272
18k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
16
5.8k

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