34 ms·
Separation of data, formulas, and graphs (a la MVC). It shouldn't be a mystery to me whether a number is data I've entered, or a result of a computation. It s
by ken 18y ago
Separation of data, formulas, and graphs (a la MVC). It shouldn't be a mystery to me whether a number is data I've entered, or a result of a computation.
It should also have a real solver, so I don't have to work out formulas on paper first. If I can type in some equations (legibly) and it's possible to derive the data I want from the data and formulas I've given, then just do it.
(I understand Lotus Improv got this right. In fact, from what I've read about it, Lotus Improv got many things right. A modern clone of Improv would be cool.)
Also, it should know units. If my search engine can do unit conversions on the fly, my spreadsheet ought to be able to.
Better graphing. I'm not sure exactly what I want, but every time I try to make a graph in a spreadsheet, I end up with something that doesn't look at all like I wanted.
N.B., I've basically given up on spreadsheets. For lists, I use an outliner. For simple math, I use a HLL like Ruby or Lisp or Octave. I suspect if there was an OmniOutliner for Windows, Excel would die overnight.