30 Years of Excel – the Story of Excellence!

Posted by
/ / 3 коментара

Legendary office product of Microsoft, which is used today by more than 1 billion people around the world, was created in 1985 for … Apple

 

excel 30 yearsАn autumn day in late 1984 four people gather in the small apartment of Red Lion Hotel in Bellevue, near Seattle. The purpose of the meeting is to lay the foundations of a secret project codenamed „Odyssey.“ For three days they plan, draw, program, write code and discuss hard to clarify the concept of creation and development of new software, which a couple of years later would change the business world, and will bring them millions of dollars.

In the group are young keen programmer with a hippie image, a graduate of MIT – Doug Klunder, his friend and talented mathematician, a graduate of Yale, but unlike him, rather looks like a playboy – Jabe Blumenthal, a neatly dressed clean-shaven young man with Hungarian accent and experience at Xerox named Charles Simonyi and the fourth guy is seemingly typical nerd with big magnifying glasses, his disheveled nondescript appearance and teenage look nothing indicate that he has already won over 50 million dollars, and his modest, founded few years ago software company based in nearby town Redmond, has recently signed a big contract with the giant IBM.

excel creators

Bill Gates, Doug Klunder, Jabe Blumenthal and Charles Simonyi in early 80s

Probably guessed that the mentioned company is Microsoft, and the name of the last of the group of four, started the project „Odyssey„, is Bill Gates. The product that will appear a few months later as a result of their and about 10 more people efforts, was primarily named „Mr Speadsheet“ (after “Master Plan” name was rejected), but shortly before official launch someone from the marketing department, whose identity unfortunately nobody does not remember suggested another name – „Excel“. Thus was born the Legend … 30 years later it continues to „live“ in about 1, 2 billion computers around the world, 1 in 6 people on the planet use Excel….

In the Beginning … Was Not Excel

Of course, Excel is not the beginning, but rather the “crown” of several years’ efforts of various scientists, programmers and companies dedicated to the idea of creating the tools to facilitate the work with numbers and data analysis for businesses and ordinary people with personal computers. These tools called „electronic table“, “electronic paper”, „visual calculators“, „spreadsheets“, get its final and perfect form with the advent of Excel.

Researchers agree that the man who developed the theoretical foundations, laid principles for the inventing of such product, is a professor of accounting at the University of Berkeley, California – Richard Mattessich. All in details is described in his book „Simulation of the Firm Through a Budget Computer Program“, published in 1964. He himself even programmed prototype spreadsheet using the language Fortran.

It may take longer than the 10 years to develop the technology to such an extent that the concept of spreadsheets to get a new boost. Late 70s are golden „pioneering“ years of computer „geeks.“ There are lots of new programming languages, processors, operating systems, also the first personal computers appeared, for use off which is not required PhD from Harvard. Apple, Microsoft and dozens of small IT companies founded by bearded long-haired hippies and hackers-programmers start looking for its place under the sun, trying to „change the world“ by means of computer.

VisiCalc

briklin frankston visicalc

Bricklin and Frankston in the early 80s

One of these young tech-idealists is Dan Bricklin who studied MBA at Harvard, but his real passion is programming. In 1978 he created the first spreadsheet software which called Visible Calculator. It performs basic calculations within 5 columns and 20 rows. A little later to Bricklin joins Bob Frankston – his friend and ally, also obsessed by the idea of spreadsheets and computer calculations. Frankston makes some improvements in the product and in 1979 they released it officially on the market under the name VisiCalc. Calculation and data processing field then has 254 rows and 63 columns.

For this to happen, however, merit another man whose name deserves to be mentioned – Peter Jennings, at the time known for its chess playing software (MicroChess). Appreciate the potential of the project, he takes it under his company Personal Software wing and invested considerable finances in development of VisiCalc. Their first client was Apple. Some researchers said that one of the big contributors to the Apple II sales boom was precisely VisiCalc. For a short time the product becomes so popular that two years later, Jennings decided to rename his company то VisiCorp.

Lotus 123

In 1982, 32-year-old Mitch Kapor, the person responsible for marketing and sales of VisiCorp, left the company, led by the idea that can create something even better than VisiCalc. He founded Lotus Development and a year later launched Lotus 123 – the „killer“ of VisiCalc – better spreadsheet product with new functionalities and improved architecture and UI. Lotus 123 was able to run under MS-DOS and IBM did not hesitate immediately to contract Kapor’ company, integrating the new product into their PC.

visicalc lotus 123

VisiCalc for Atari, 1980 and Lotus 123 for MS-DOS, 1985

SuperCalc

In 1980 appeared another, almost forgotten software product for a short time successfully compete with VisiCalc, and later with Lotus 123. His name is SuperCalc, developed by talented programmer Gary Balleisen, part of the company Sorcim. But the contracts of Apple with VisiCorp and IBM with Lotus, and especially the emergence and development of Excel, do not give a chance SuperCalc to survive. Despite its qualities, at the end of the 80s this spreadsheet software sink into oblivion as the same happens with VisiCalc and Lotus 123 in the early 90s.

Javelin

javelin spreadsheets

Javelin for DOS

Another spreadsheets product, which deserve our attention, appeared in 1984 and the following year received exceptional reviews from PC week and PC Magazine – called Most Significant Product of the Year. Javelin is defined as „business planning tool that provides many of the functions that traditional worksheets provide, but adds a new dimension by“ knowing „more about your data than other programs. Javelin provides a variety of views of your data, including traditional table, worksheet, and graph views, but also formula, diagram, notes, and error views. Javelin links variables by formulas, instead of simple references to cells of data, and deals with time series data and the calendar very effectively. „
The product was developed by a team of Javelin Software Company, among them Rob Firmin, Stan Kugel, John Levine, Christopher Herot and Charles Frankston (brother of Bob Frankston – one of the VisiCalc creators ). Run under MS-DOS.
Despite its undoubted qualities and functionalities, in some ways superior to its competitors on the spreadsheets market, Javelin failed and in 1988 ceased to exist as a product. Later on Lotus used Javelin as a basis for development to his new spreadsheets software Improv for NeXT, released in 1991.

Multiplan

Let’s back to Microsoft. Of course, the company of Bill Gates did not create its excellent spreadsheets from scratch. The foundation on which step the developers of Excel, is Microsoft product called Multiplan. It hit the market in 1982 to compete VisiCalc. In contrast of it, instead of A1 addressing, Multiplan uses R1C1 addressing (later Excel will integrate both methods of reference, today „default“ is A1). Spreadsheets competition became even stronger with the arrival of Lotus 123 and their warm relations with IBM.

multiplan mac 1984

Miltiplan for Macintosh, 1984

So Microsoft has to choose one of outlined two options – either to improve considerably Multiplan or to create a new „killer“ product. In January, 1984, something happened which clearly define the choice of Bill Gates to the second option. Apple launched the “Macintosh” computer – with revolutionary new GUI (graphical user interface), which will send very soon MS-DOS and all other existing OS in history. At the mentioned above meeting in the Red Lion Hotel all decided to abandon MS-DOS and to focus on developing software that works with the new GUI and OS of Apple.

excel 1.0

Excel 1.0 for Macintosh, 1985

At this time Microsoft had already created Multiplan version for new Macintosh. The results were encouraging and the next important step is … Excel. To the Project team joined some other people whose contributions to Excel should not be forgotten – Jon DeVaan (later chief of Office department at Microsoft), Mike Kos (today leading software engineer at Google), Jeffrey Harbers (who later would become a chief software architect of Microsoft Office) and Jeff Raikes (responsible for business management of the product, he had experience with Multiplan project management) Their aim is to create „a product that does everything that VisCalc and Lotus 123 do but better and faster.“

excel - recalc or dieBut not only. They worked hard to invent a real competitive advantage over spreadsheets software competitors. And this was “intelligent recalc” feature. Rather than recalculating all the cells when one cell was changed, it selectively recalculated cells affected by the change — making the program more efficient and improving its performance on the limited hardware of early personal computers. The team was so obsessed by this “recalc” feature, so they made t-shirts with the inscription “Excel – Recalc or Die!”

Microsoft announced the official release for September 30, 1985. Although initially everything goes according to plan, in the last minute some bugs were found. Final full audit of the software code started again, which lasted until the late hours of September 29. Sometime after midnight, the master disc was ready and sent out for duplication. September 30th in the morning several copies of the first version of Excel for Macintosh (Excel 1.0) were shipped to the nearest software store. So begins the real story of this legendary product…

Microsoft Excel Timeline

Today there are 13 versions of Excel for Windows and 13 versions for Mac. According to some researchers in 1986 it was created stable version of Excel for MS-DOS, but it is never launched officially.

Infographic excel timeline

Excel Infographic

For Windows:

  • Excel 2.0 (1987) – the first official versions of Excel for Windows
  • Excel 3.0 (1990)
  • Excel 4.0 (1992)
  • Excel 5.0 (1993)
  • Excel 95 (v7.0)
  • Excel 95 – part of Microsoft Office for Windows 95
  • Excel 97 (v8.0) – part of Office 97
  • Excel 2000 (v9.0) – part of Office 2000.
  • Excel 2002 (v10.0) – part of Office XP
  • Excel 2003 (v11.0) – part of the Office 2003
  • Excel 2007 (v12.0) – part of the Office 2007
  • Excel 2013 (v15.0) – part of Office 2013
  • Excel 2016 (v16.0) – part of Office 2016

For Apple:

  • Excel 1.0 (1985)
  • Excel 1.5 (1988)
  • Excel 2.2 (1989)
  • Excel 3.0 (1990
  • Excel 4.0 (1992)
  • Excel 5.0 (1993) – part of the Office 4.X-Motorola 68000
  • Excel 8.0 (1998) – part from Office 98
  • Excel 9.0 (2000) – part from Office 2001
  • Excel 10.0 (2001) – part of the Office v. X
  • Excel 11.0 (2004) – part from Office 2004
  • Excel 12.0 (2008) – part of Office 2008
  • Excel 14.0 (2011) – part from Office 2011
  • Excel 15.0 (2015) – part from Office 2016

The Creators of Spreadsheets – Where Are They Now?

  • Prof. Richard Mattessich today is 93 years old and still has been invited as a lecturer at the most prestigious universities. A living legend in the world of accounting, author of over 25 scholarly books, the latest of which was published in 2013.
  • Dan Bricklin today is 64 years old and continues to engage in software development, his company is called Software Garden.
  • Bob Frankston today is 66 years, a world-renowned computer scientist, in recent years actively opposing the influence of the largest telecommunications companies to the Internet development.
  • Mitchell (Mitch) Kapor today is 65 years old, he is among the most famous personalities in the IT industry, one of the founders of the Electronic Frontier Foundation and Open Source Applications Foundation, first chairman of the board of the Mozilla Foundation, an evangelist of open source software and strong supporter of ideas for free exchange of information and knowledge in the Internet.
  • Charles Simonyi – today 67 years; very popular person in the US. He left Microsoft in 2002 and founded his own company – Intentional Software, and a little later – a charitable foundation – Fund for Arts and Sciences (today donated over 75 million dollars). Simonyi is famous for its two flights into Space (as space tourist) on board of the Russian space ships „Soyuz TMA-9“ (2007) and “ Soyuz TMA-14″ (2009).
  • Jabe Blumenthal – today 61 years, after leaving Microsoft in 2013 is attributed entirely to the cause of which he devoted large part of his life – the fight against climate change and the creation of clean energy technologies. Board member of the Bullitt Foundation, Climate Solutions, Washington Environmental Council and Progress Alliance.
  • Jon DeVaan – now 55 years old, many years responsible for the development of Office products, left Microsoft in 2014 as head of the Windows Development department.
  • Doug Klunder – today 56 years; despite his excellent programming capabilities after leaving Microsoft in the late 90’s decided to devote himself to law. He supports as a lawyer American Civil Liberties Union, and in his spare time is engaged in farming.
  • Jeff Raikes – today 57 years, takes senior management positions at Microsoft until 2008, when he retired and became a CEO of Bill and Melinda Gates foundation. He has own foundation – Raikes Foundation.
  • Jeffery Harbеrs – the only one of Excel „pioneers“, which today is not alive. He died in a plane crash in 2006 at 54. In the end of the 90s he left Microsoft to deal with farming and venture capital companies.
  • Bill Gates – on 28 October will turn 60 years … hardly needs extra presentation.

 

Interesting Facts about Microsoft Excel

  • Excel 4.0 (1992) is the first version of Excel, that contains the item, so-called „Easter eggs“ – typical for earlier versions of most Microsoft products hidden animations or graphics surprises somewhere in the program, which have not been declared officially (in this version is an animated joke tease with the rival Lotus 123). Other better-known „easter egg“ are similar to Doom game „The Hall of Tortured Souls“, “Flight simulator” and others. The latest version of Excel with „easter egg“ is Excel 2000.
    excel flight simulator

    Excel Flight Simulator „Easter egg“

  • Version 5.0 of Excel (1993) for the first time includes Visual Basic for Applications (VBA), programming language based on Visual Basic, which adds features to automate tasks in Excel and provides so-called user-defined functions (UDF) for the use of worksheets. However VBA makes Excel the target of diferent macro viruses. This cause a lot of troubles for Microsoft and the company is forced to add an option for complete disabling of macros and respectively – their enabling if there is reliable security certificate.
  • Microsoft Excel 95 is the first major version after Excel 5.0, there is no version Excel 6.0.
  • Excel 2010 (v14.0) – part of Office 2010 is the first major version of Excel after v12.0 (Excel 2007), version 13 is „bypassed“ (because of the fatal number).
  • The concept of Pivot tables which today are an integral part of Excel has been developed by software engineer from Massachusetts – Pito Salas. It was originally applied to the product of Lotus called „Improv“ – for Steve Jobs platform – NeXT, in 1991. From Excel 95 „PivotTable“ is a part in all subsequent versions of Excel.
  • In Excel 2007 for the first is introduced so-called Ribbon menu.
  • In Excel you can undo last 100 actions.
  • Each Excel worksheet contains 1 048 576 rows and 16 384 columns.
  • In an Excel worksheet you can use up to 512 fonts.
  • Each function in Excel can have up to 255 arguments.
  • You can zoom in Excel from 10% to 400%.
  • You can not name the worksheet with the word „History“.
  • Maximum characters in the name of the Excel worksheet is 31.
  • You cannot use in the name of the Excel worksheet the following symbols:
    – Slash \ /
    – Star *
    – Big brackets [  ]
    – Colon :
    – Question mark ?
  • Bob Umlas is the longest-time holder of Microsoft MVP for Excel award – 20 years (since the MVP program was established in 1995).
  • Some interesting projects and games, created entirely with Microsoft Excel.
  • Video (Runaway Train of AC / DC), created using Microsoft Excel.
excel versions history

Excel world

 

Many of the facts and “heroes” from the story written above, you can see and hear in this interesting video, which use footage from a Microsoft documentary dedicated to the 25th anniversary of Excel:

Everything new about Microsoft Excel you will learn from the Microsoft Office site of Excel, Excel Blog or the Facebook Fan Page of Excel.

In our page Microsoft Resources you will find the links to some of the most authoritative websites devoted to Excel – the greatest software ever created by Microsoft.

And finally, do not forgetHappy 30-th Birthday, Excel!

 

Още публикации по темата: