Lotus 1-2-3 Vs Excel Vs Google Docs and spreadsheets?
Upon their release in the early 1980s, Microsoft Excel and Lotus 1-2-3 offered similar products measured by both quality and efficiency. Each of them was associated with different systems that in turn determined their place in the market for the next two decades. It looks like we may be embarking on another turn of events with the availability of free web-hosted applications such as Google Docs & Spreadsheets and Zoho Office.
Lotus wasn’t the only spreadsheet program in the early 1980s, but it was the most efficient. Upon its launch in 1983, Lotus was an innovator in the use of consumer television advertising. Things looked great for Lotus for a number of years due to its speed and similarity to the VisiCalc model, including the A1 letter and number cells and forward slash menu structure. It was virtually bug free and beat the slower screen input/output functions of DOS. In addition to being a spreadsheet, it also featured comprehensive charts/graphs and database operations. Hence its name 1-2-3, which refers to its three main abilities.
The data was ordered in each rectangle defined within the order of the data in one or two columns in the rectangular area. Text within a certain range could also be justified in paragraphs allowing it to act like a primitive word processor. It contained user-friendly features such as keyboard-driven popup menus and one-key commands. Lotus’ most notable user-friendly feature was a context-sensitive help menu accessed with the F1 key.
Version 2.0 introduced macros and plugins. This resulted in third party vendors being able to sell macro and plugin packages ranging from full word processors to dedicated financial spreadsheets. Version 2.0 contained macros with syntax and commands, as well as a string of variable expressions that were similar in complexity to an advanced BASIC interpreter. In subsequent releases, Lotus 1-2-3 also supported multiple worksheets. Lotus also created a version of 1-2-3 for the HP 200LX, a laptop released by Hewlett-Packard.
Excel was first offered for the Mac in 1985 and then for Windows in 1987. Compared to Lotus, the introduction of Excel offered all the number-crunching capabilities plus drop-down menus and WYSIWYG formatting. These two features made Excel much easier to use. By 1988, Excel outsold 1-2-3 and began to cement its place as the leading developer of PC software. Microsoft proved to be an ambitious competitor by maintaining a valuable product and releasing new versions roughly every two years. Excel has also kept up with its Mac releases. The current version for Windows is Excel 12 or Microsoft Office Excel 2007. The current version for Mac OS X is Microsoft Excel 2008.
Looking back, it seems that in 1982, when Microsoft offered its spreadsheet program titled Multiplan, it was popular with CP/M systems, but MS-DOS systems favored Lotus 1-2-3. MS-DOS clearly prevailed as the most prevalent system, thus Lotus 1-2-3 as the most prevalent spreadsheet program. In the late 1980s, Microsoft created Excel, a new spreadsheet for its Windows graphical interface. Lotus focused on IBM OS/2. Windows usage skyrocketed with Windows 3.0, but Lotus had already lost its lead. Excel becomes the industry leader in spreadsheet software [http://www.thesoftwarespot.com]. IBM continues to sell 1-2-3 as part of the Lotus SmartSuite office suite.
The trends are changing again with the availability of free web-hosted applications such as Google Docs & Spreadsheets and Zoho Office. However, this will surely present a challenge for Excel to maintain its prestigious position; It won’t be a clear comparison as online apps are a different product. They don’t mimic Excel and 1-2-3 but rather extend them. They use the power of web collaboration, instant feedback, mashups, live data, and context searches. However, it will be interesting to see Microsoft’s future maneuvers!