Hacker News new | past | comments | ask | show | jobs | submit login

A couple of problems with Excel [edit: actually just spreadsheets in general], which I think fundamentally restrain it:

1. Difficult change control. It is very difficult to diff spreadsheets. So changes to a model are very hard to verify for correctness.

2. Massive code duplication by design (eg. the fill function). So it is easy to introduce an error by failing to update all relevant cells.




1. The review functionality goes to a very granular monitoring of changes in a spreadsheet. It is indispensable, especially when many people have access to the file. It can be circumvented, of course, but we are talking about unintentional errors. 2. In Excel you get very evident visual indicators when a formula is dissimilar to the formulas around it. Duplication is necessary at the most ad-hoc level. When you use Tables, things are more safe.

The major issues with Excel are not of functionality but of user training on the functionality available.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: