Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Browse Open Actuarial Jobs

Life  Health  Casualty  Pension  Entry Level  All Jobs  Salaries


Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-30-2019, 05:27 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 86,092
Blog Entries: 6
Default Guinness Will Record Anything: Most Spreadsheet Packages

This is... something else.

https://www.fastcompany.com/90297443...g-spreadsheets

Quote:
This guy holds the Guinness World Record for collecting spreadsheets
Ariel Fischmanís office shelves are a veritable museum devoted to the era of VisiCalc, Lotus 1-2-3, Multiplan, and other products that once duked it out for number-crunching supremacy.
Spoiler:
In a world in which a 1976 Apple-1 computer can fetch $375,000 at auction, itís not exactly news that people appreciate the value of our technological heritage. But Ariel Fischman, a financial advisor in Mexico City, isnít just another collector of vintage PCs. Fischman collects spreadsheet softwareóboxes full of disks, manuals, and other accoutrements that were standard fare in every office until we started downloading most of our apps. Itís a surprisingly rich hobby, given that the 1980s and early 1990s saw booming competition among software giants, startups, and even unexpected contenders such as Boeing (yes, the aircraft company).


There may be other spreadsheet collectors out there, but only Fischman has been recognized by Guinness World Records as having the largest such collection on the planet, an honor he received in May of last year. I spoke with him about his trove, how he assembled it, and why a seemingly mundane piece of business software sparked his imagination.

Fast Company: Why donít we start with the most obvious question. Why spreadsheets?

Ariel Fischman: Iím a corporate financial advisor, and Iíve been a user of spreadsheets for close to 30 years. One day I was just thinking: Many people use these, and they save so much time from using them, especially as compared to what was available before. So I decided to research a little bit about the history of spreadsheets. And if you go online, there isnít anything too formal on how they came to be. I decided to focus a bit of an intellectual interest in understanding the history of where they came from and how they got to be such a popular tool.

In all honesty, it wasnít supposed to be a collection at the beginning. Iím not the kind of person that would have, like, a Star Wars collection. I just wanted to find the oldest spreadsheets that I could get my hands on. I found one, and then another, and then quickly discovered that even within Microsoft there was something before Excel called Multiplan. I donít even know when exactly I decided it would be a collection. I just continued to buy stuff, and Iíve bought as many as I can get.

ADVERTISING

inRead invented by Teads

Microsoftís pre-Excel spreadsheet, Multiplan, came in a seemingly endless array of variants for different computing platforms. [Photo: courtesy of Ariel Fischman]
FC: Once one sets out to collect spreadsheets, where does one get them?

AF: Iíve bought a lot through eBay. Iíve also invested quite a bit of time in reaching out to the people who did reviews of the software for magazines, mostly in the í80s and early í90s, and the people who were on beta tester lists. Theyíve been able to send me the rarest items. I have a bunch of demos. Disks with stamps labeled ďconfidential.Ē A lot of pre-releases, undocumented, that never went out to the public.

FC: How many spreadsheets do you have?

AF: Unique items? Close to 800. The official Guinness record count is slightly higher than 500. Theyíre very strict. They donít count a disk without a box, for example. And thereís disks that were distributed without a box, because many people programmed software out of their garage and sold it by mail. They were never displayed on shelves.

The records team also didnít count any demos. And I must have three digits of demos. They decided those donít count because they had limited functionality. The way I see it, if itís a grid, if it captures numbers and text, if it performs arithmetic calculations, itís a spreadsheet.

The process to attain a Guinness World Record is very complicated. It took me over two years of gathering documentation and letters and recommendations from people in the computing history world.


VisiCalc, the PC spreadsheet that started it all. [Photo: courtesy of Ariel Fischman]
FC: Is there such a thing as a valuable spreadsheet?
AF: There are some that have cost me a lot of money. One person that I bought a few items from owns a lot of software from the first half of the í80s. She has things I havenít been able to find anywhere else, and sheís conscious of the imbalance between supply and demand. Not that the demand is so high, but even one person is demand, and that would be me. Iíve paid close to four figures for some items.

FC: All it takes is one fanatic.

AF: Yes, exactly.

FC: How do you even gauge whatís out there to collect? Are there things you know existed that youíve been unable to find?

AF: I started looking for only stand-alone spreadsheets: Excel, but not the entire Microsoft Office package. And then I opened the spectrum to suites that are not stand-alone spreadsheets. Microsoft Works is an example. Itís a suite, and the spreadsheet itself was not sold on its own. That also applies to the 2016 and 2019 versions of Excel. There is no physical media for Excel stand-alone, only for Office.

Thereís one item that I havenít been able to find that I know existed: Excel 2001 for the Mac. I have the Office version and Iíve seen pictures of the Excel stand-alone version. Iíve spoken with people at Microsoft; they searched and said ďSorry, we donít have it.Ē

FC: Of the spreadsheets you do have, do you know which ones are rarest? I know youíve got a lot of betas, which by definition are fairly rare.

AF: Yeah, I think those are the rarest. For example, I have two versions of Excel beta from 1985 with their respective documentation. But I bought the disks and documentation from different people. It was just a happy coincidence that I was able to match them.

The other family of rare products is Microsoftís Multiplan. I exchanged some emails with one of the people who headed the development of Excel and worked on Multiplan as well back in the í80s. He mentioned an unsubstantiated claim that Multiplan was the program that was ported to the most architectures. I think I have close to 40 versions of Multiplan for different operating systems, including some very strange computer architectures.


In 1985, long before Excel ate the spreadsheet industry, it was a humble piece of beta software. [Photo: courtesy of Ariel Fischman]
FC: I always thought that Multiplan was a flop. But when I looked at Wikipedia, it said it sold a million copies, which doesnít sound bad for the early 1980s. Do you have a sense as to why it went away and Excel came around?
AF: The explanation that Iíve put together on my ownóitís really a hypothesisóis that Multiplan was sold in so many different versions that it must have been difficult to control quality and releases. Itís not that they didnít sell enough, itís just that it was hard to manage.

Excel wasnít really a strong replacement to Multiplan, in my view, until version three. There were spreadsheet wars in the 1980s, where the front runners were Lotus 1-2-3, Excel, Superplan, and Borlandís Quattro. The differentiating factor that led Excel to win that war would be that the fact that Windows 3.0 came out in 1990, and Excel was native. It simply made more sense to have the two products that matched, and Windows 3.0 was a winner in the operating system war.

In the early days you just went to the neighborhood store and bought whatever the clerk recommended. With the interconnectivity of computers, it became more relevant to have something that was compatible with what everyone else had. If everyone had Windows, Excel was the more obvious choice.

FC: Lotus basically bet on IBMís OS/2 operating system, which turned out not to be a great idea. They spent years trying to play catch-up on Windows, and by then it was probably too late.

AF: Correct. Plus, the obvious point is that Excel and Windows were made by the same company.

FC: Do you actually run any of these old spreadsheets? Do you have old computers around, or is it more about the physical products?

AF: Itís more about the physical product. Iím sure that because of the humidity of the places where they were stored and simply the passing of time, many of them probably wouldnít work. Iíve played with a few, in cases where you can emulate the original operating system, but itís really a limited number. So I have to base my opinions on the documentation that each product has.

In most cases, I have the boxes, books, and booklets. Theyíre interesting to read. In the end, out of the literally hundreds of different products, the bloodline is the same.

FC: Do you have a favorite out of all of them?

AF: I used Lotus 1-2-3 back in the day. But Excel is the tool that, for me, really made a difference. Itís the top-of-mind spreadsheet. Itís what most people use as their default. There are online spreadsheets today, like Google Sheets, and even Office 365 now comes with an online tool. But Excel is the standard. If you know how to use it well, you can move from one job or one business to another, and itís to a certain extent universal.


Once upon a time, Lotus 1-2-3 came in a classy case designed to look spiffy on your office shelves. [Photo: courtesy of Ariel Fischman]
FC: Products like 1-2-3 used to come in really nice cloth boxes, and the documentation was great, and over time, the manuals got bigger and bigger. They were these impressive physical products, and thatís almost totally gone away. Do you have interesting examples of packaging from the old days?
AF: I have a ton of those Lotus cloth boxes. There were some that had really interesting art. But we live in a different time right now. If you buy Office today, itís either a download or an empty box with a card with a key number in it. Youíre not even buying media. Youíre buying a license.

FC: You also paid hundreds and hundreds of dollars back in the day, compared to today when youíre either paying a little bit of money, or in some cases no money if youíre using an online spreadsheet.

AF: They were expensive items. Before 1979, people didnít have a reason to own a computer. And when VisiCalc came out, they understood why theyíd want to use one. People started buying $2,000 computers just to use VisiCalc. If you pay attention to advertisements for personal computers in 1980, 1981, the way they would advertise their computers was, ďOurs is the best to run VisiCalc.Ē It was that interesting.

FC: I was trying to remember if any of the old spreadsheets are still out there other than Excel. I realized I wasnít sure if Quattro Pro was around. I looked at the Corel site, and it is, as part of the WordPerfect suite. Do any of the other 1980s and 1990s contenders still exist?

AF: I donít think so, not the old ones. Thereís definitely competition, but when compatibility is so critical, itís basically down to Excel, Numbers, Google Sheets, and thereís a few out there that are more specialized.

FC: Was it better for spreadsheet users back when there was lots of competition?

AF: In all the economics books, we read that monopolies are detrimental to development and research because essentially the monopoly company can sit in a comfort zone without any need for innovation. I try to be as unbiased as I can with this comment, but the reality is that Excel innovates all the time. I donít think that we have lost the innovation edge from going from a market with dozens of competitors to one with one, two, or three companies. Again, to my point on compatibility: If you want to create a file and share it with someone else, you couldnít unless they were using the same software. I donít think weíve lost anything. With some products, itís better not to have too many choices.


Ariel Fischman owns more spreadsheet software than you, or anyone else. [Photo: courtesy of Ariel Fischman]
FC: What else have you learned from this collection?
AF: Not to take any credit at all away from [VisiCalc creators] Dan Bricklin and Bob Frankston, but I think there are other people in history who should also be recognized for their contributions. There was an article in the Journal of Accounting in 1961 by an academic named Richard Mattessich. Heís in his mid-90s now; Iíve exchanged emails with him. He conceptualized the spreadsheet way before computing power was able to execute it. He wrote in his paper that we were going to be able to use computers to perform business forecasts and budgeting. Essentially, he describes what a spreadsheet was going to be almost 20 years later.

Also, in 1969 Rene Pardo and Remy Landau created LANPAR, which I understand was sold mostly to telcos. Rene told me some time ago that the original software was on paper tape since they were paranoid that it could would be stolen by the service provider. They had several thousand lines of code running in 32K of memory, and they would compile the code and store it on a GE 200/400 or Honeywell 6000 computer. I believe they deserve significant recognition as well.

People in the earlier days were already thinking about this, and the uses it could have. Thatís definitely one thing Iíve learnedónot through collecting, but from my research.

I have no interest in selling my collection. Right now, I enjoy seeing it in my office. But eventually, Iíll just give it away, if some institution wants it. I think itís the right thing to do. Physical spreadsheets are finite; theyíre getting close to their end.


So, it's mainly interesting for software history, but jeez, Guinness. Come on.
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
  #2  
Old 01-30-2019, 05:28 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 86,092
Blog Entries: 6
Default

But now I'm inspired to write a piece for the Modeling Platform: Does this Spreadsheet Spark Joy?
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 11:29 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.20428 seconds with 11 queries