Spreadsheet or writing an application?
- by Lenny222
When would you keep simple to medium-complex personal calculations in a spread sheet (Excel etc) and when would you write a small program or script for it?
For example when you want to calculate what size of mortgage you can afford to buy a house.
I could create a spreadsheet and have a nice tabular representation. On the other hand, if i would write a small script in a nice language (in my case Haskell), i'd have the security of a nice type system, preventing typos etc.
What are the pro/cons in your opinion?