Electronic business tool - spreadsheet software - includes an article on personal information management systems - Buyers Guide

Black Enterprise, Sept, 1992 by Denise E. Womack

Fully loaded Microsoft Excel 4.0 and Microsoft Excel 4.0 for Windows have the added appeal of the Lotus 1-2-3 Release 2.0 compatibility. A menu bar (toolbar) runs along the top of the program, which makes it easier to perform routine tasks. Both Microsoft Excel 4.0 and Microsoft Excel 4.0 for Windows retail for $495.

In an industry long dominated by an out-with-the-old-in-with-the-new mentality, innovative PC-based spreadsheet programs that boast increased user functionality are standing strong in the market. Traditional spreadsheets relied on common business tools such as pencils, calculators or adding machines, ledgers and, most importantly, time.

Today's electronic (or computerized) spreadsheet calculates and recalculates for you, but is not limited to accounting features. Programs such as Lotus/Symphony 2.0+, from Cambridge, Mass.-based Lotus Development Corp., and Excel, from Redmond, Wa.-based Microsoft Corp., have taught users that financial analysis, statistical functioning, sales forecasting and invoicing can be performed hassle-free.

Unfortunately, one lesson not so quickly learned by software industry leaders is that more is not always better. The major consideration when choosing spreadsheet software is to make sure that the program's capabilities match your organization's requirements, says Herbert Mack, systems support manager at American Telephone & Telegraph Co. in Morristown, N.J. "The most important of these," he explains, "are end-user needs, training benefits and maintenance."

In terms of development, it is also critical to know if one can take a particular application and substitute it with another application. "Flexibility is key," adds Mack.

And the newest lines are providing just that. Microsoft Excel Release 3.0 has developed easier ways to do common tasks. Microsoft Excel 4.0 and Microsoft Excel for Windows 4.0 keep pace by offering such features as Object-Linking Embedding (OLE) and CrossTabs func tionality.

OLE makes it simpler to integrate and share information across applications. The assimilation of CrossTabs from a database to a spreadsheet environment is a valuable analysis tool that tracks database information to industry trends.

Another revolutionary feature is the Macro Interpreter, which enables users of the MS-DOS-based Lotus 1-2-3 Release 2.0 software program to run compatible macros unmodified in Windows-based Microsoft Excel 4.0.

A major drawback for organizations with data exchange is the lack of interactiveness between Lotus 1-2-3 Release 3.1 and any Microsoft Excel software version.

Key Players

Lotus, considered the leader in spreadsheet technology, has stepped up to the challenge. Lotus 1-2-3 for DOS 3.1+ offers consumers the Lotus Magellan viewer. Users are able to find, view and work on information that is stored on their PC's hard drive before actually loading a file.

The introduction of the Backsolver and Solver features have dramatically exploited the basic "what-if" scenario into a "how-to" capability. For instance, users can get a detailed report of multiple, mathematically correct solutions to a production plan on maximizing profits.

Other PC-based spreadsheet programs include Quattro Pro from Borland International Inc., Scotts Valley, Calif. A DOS-based spreadsheet, Ouattro Pro offers a WYSIWYG (what-you-see-is-what-you-get) display and can create attractive charts with icons and illustrations without the need for a presentation graphics program.

Borland makes the transition to Window's capabilities with its newest release, Quattro Pro for Windows. Quattro Pro outshines Excel, according to recent reviews, in the area of multiple spreadsheets. For instance, Quattro Pro lets you group related spreadsheets into notebooks. You can attach tabs or labels to each file (or spreadsheet), making it much easier to flip through or rearrange spreadsheets. This software feature also facilitates how the user can manipulate and consolidate data.

Like Microsoft Excel 4.0, Quattro Pro for Windows has a menu bar along the top that lets you perform routine tasks by using simple push-button operations. The user simply points to an object on the menu and clicks the correct button on a mouse to make a selection. Quattro Pro for Windows 1.0 retails for $495.

Choice ideas

With a plethora of system features, it may be difficult to decide which spreadsheet program is best for you or your organization. You might consider the following tips:

Fully loaded Microsoft Excel 4.0 and Microsoft Excel 4.0 for Windows have the added appeal of Lotus 1-2-3 Release 2.0 compatibility. However, both of the software packages require tremendous amounts of memory to run them effectively.

For instance, Excel 4.0 for Windows requires a minimum of 2 MB of memory. Microsoft Excel 4.0 for the Macintosh requires a minimum of 1 MB of memory and supports Apple System 7.0. But in order to take full advantage of the Windows environment, your hard disk space should really be about 10 MB or no less than 6 MB.