4 ms·
“While Excel 5 was being designed, Lotus had shipped a “new paradigm” spreadsheet called Improv. According to the press releases, Improv was a whole new generat
by teddyh 9y ago
“While Excel 5 was being designed, Lotus had shipped a “new paradigm” spreadsheet called Improv. According to the press releases, Improv was a whole new generation of spreadsheet, which was going to blow away everything that existed before it. […] Of course, Improv is now a footnote in history. […] Why? Because in Improv, it was almost impossible to just make lists. The Improv designers thought that people were using spreadsheets to create complicated multi-dimensional financial models. Turns out, if they asked people, they would discover that making lists was so much more common than multi-dimensional financial models, and in Improv, making lists was a downright chore, if not impossible.”
— Joel Spolsky
https://www.joelonsoftware.com/2000/05/09/the-process-of-designing-a-product/ https://www.joelonsoftware.com/2000/05/09/the-process-of-des...
Archive.org link: https://web.archive.org/web/20170606181942/https://www.joelonsoftware.com/2000/05/09/the-process-of-designing-a-product/ https://web.archive.org/web/20170606181942/https://www.joelo...
- phowat 9y agoMaybe improv was just ahead of it’s time. It wouldn’t be the first time we see a product fail only to have a similar one years later become a success. I bet there are more people using excel for complex stuff now, they might as well find a niche.
- Aloha 9y agoI think Improv was only solving one of the use-cases that you'd use a spreadsheet for - and thats why it was never widely adopted.
- cm2187 9y agoYes. Kind of like saying that you could replace a general programming language with FoxPro because all you ever need to do is database related code. As a programmer, even if you only deal with database, you kind of like to have full flexibility to do anything you want and not be cornered in a specific use case and fight against the product if you want to do things slightly differently. Users think the same way, even if it means more opportunities to shoot oneself in the foot.
- jacobolus 9y agoDisclosure: Spolsky worked on Excel for several years as a product manager, and is biased. The other reason that Microsoft Office tools succeeded is that Microsoft was very good at all of the extra-technical stuff – business deals, marketing, software bundling, legal fights, etc., some of it quite underhanded/anticompetitive. Lotus made Improv for NeXTSTEP originally, so there was a niche platform problem for the first 2 years, and after it had been ported to Windows Improv was competing against Lotus’s own previous spreadsheet program 1-2-3, creating consumer confusion and confusion within other parts of the Lotus organization. But the main reason is probably just inertia. Once people have learned one tool that seems to work well enough for their needs, getting them to adopt something else (especially if it isn’t conceptually identical) is twice as hard.
- Aloha 9y agoHe probably is biased - but it seems they were building "spreadsheet for advanced users" when most people who use a spreadsheet are not or will ever be advanced users.
- adrianratnapala 9y agoYet there is an enormous amount of important money-work being done by Excel users who are far more advanced than me, building what are essentially computer programs / databases. So even if that market has fewer users then Excel itself, there an still be money to be made from people who could use a tool that is better behaved than a consumer spreadsheet but easier to use (for domain specialists) than a general programming environment.
- eropple 9y agoThis is the argument that (IMO, rightly) people make against the continued use of C for systems programming. But C aficionados insist they understand its behaviors well enough to not get bitten...
- adrianratnapala 9y ago
- feelin_googley 9y agoDemo of Improv on NeXT: http://www.youtube.com/watch?v=TbsfvdZXE7s http://www.youtube.com/watch?v=TbsfvdZXE7s
- nitemice 9y agoSeems a lot like PivotTables crossed with a normal spreadsheet. That's actually pretty cool!
- gadders 9y agoPivot Tables were invented by Lotus: https://en.wikipedia.org/wiki/Pito_Salas https://en.wikipedia.org/wiki/Pito_Salas
- cm2187 9y agoThanks. It’s interesting but even that solves a very specific use of Excel. It will become painful if you need to cross reference different periods, etc. I sort of built a similar calculation engine for work that works in a similar way, but it is a solution taylored to a very specific problem. Finance depart who would be the primary user for that would still need Excel on the side.
- kamaal 9y agoThis is spot on. The biggest reason why lists matter so much is because. Most data structure use cases in everyday life are lists, or lists of lists(Tables). Of course you have graphs and trees. But for all practical purposes, most problems there are, are either lists or tables. Excel will benefit, if they add optional tree and graph interfaces. Like you get an option to build a graph of how your business things are connected and help you figure the shortest steps to a solution etc. And yes if you want to build a Microsoft Excel killer. Please build a thick client desktop application which is as feature rich as a Excel and give it away for free. Charge for the cloud usage. Anything less isn't going to cut it. Excel is just way ahead of anything that is out there. The only competing product I've seen is Libreoffice Calc. But even that has a long way to go.
- nnq 9y agoAlso, you live in a 3D world, hence any non-cognitively overloading "work surface" has to be -1 dim, so 2D, hence List or ListOfLists (spreadsheet). Anything else will require brainpower you could be using for something else instead! (like solving the actual problem, not masturbating with the tools...) Other alternatives are Trees, which are also "lists of lists" but without the size constraints (Graphs "look 2D" but easily grow multi-dimensional information-wise). But trees have a big problem: they easily grow bigger than the screen, so you expand/collapse them, so you always end up with hidden information that you can overlook - hence they are really bad for sloppy people (I know it from first hand experience... if I'm not careful I can really forget that whole sections or Wrkflowy trees or Org-mode documents I work with even exits!) Now combining list & lists-of-lists & trees & formatted text could work, if they manage to not informationally overload the user. But I'm 99% sure that any tool more complex than matrixes and trees as information shape will not take on wide scale, until we manage to couple it with some superhuman-Clippy AI-assistant that almost reads your mind. We're stupid monkeys and it's only so much our brains can handle...
- alexandersingh 9y agoSlightly off-topic, but speaking of lists... http://www.spiegel.de/international/zeitgeist/spiegel-interview-with-umberto-eco-we-like-lists-because-we-don-t-want-to-die-a-659577-2.html http://www.spiegel.de/international/zeitgeist/spiegel-interv...