GUIdebook: Graphical User Interface galleryHome > Ads > Magazine advertisements > Lisa > LisaCalc
Go backLisaLisaCalc

LisaCalc brochure from 1983.

Page 1
This image can be zoomedPage 1
Page 2
This image can be zoomedPage 2
Page 3
This image can be zoomedPage 3
Page 4
This image can be zoomedPage 4

(Advertisement scans courtesy of Rob Bedeaux.)


LisaCalc is a powerful electronic spreadsheet and financial modeling tool that helps you grasp the impact of even the most complex financial scenario. Its huge worksheet (255 rows by 255 columns) lets you test every variable that affects your decisions. And it’s easy, because LisaCalc eliminates the need to learn a modeling language.

Once you’ve created a spreadsheet. LisaCalc lets you transfer that information into other LisaCalc documents, into LisaGraph for graphing, or into LisaWrite for inclusion in a memo or report.

In less than 30 minutes you’ll be doing useful work with LisaCalc. Lisa’s revolutionary Graphics Mouse Technology™ replaces confusing computer commands with simple graphic images.

Graphics, together with the mouse, a simple selecting device, let you create, revise, and print documents intuitively. And because basic operations work the same way in all Lisa™ applications, you’ll learn other applications in even less time.

LisaCalc spreadsheets and models enable you to see the important numbers in your profession clearly. They help you to make better, faster decisions and communicate them more effectively.

Perform arithmetic analyses quickly and easily.
No special computer language or commands are required.
Use built-in functions and arithmetic operators, or create your own formulas.

Analyze business and technical scenarios by examining “What if?” possibilities.
Assumptions and formulas are easy to edit.
Spreadsheets recalculate automatically when new data is entered.
To view how changes affect different portions of the model, split the screen horizontally, vertically, or in both directions.

Graph data for further analysis or added impact.
Move data quickly and easily into LisaGraph for plotting.
Your LisaCalc model and LisaGraph plot can be viewed on the same screen simultaneously.

Insert LisaCalc results into LisaWrite documents.
Move your spreadsheet or model into a LisaWrite document as simply as you perform any basic editing.
Revise or reformat a LisaCalc spreadsheet while in LisaWrite.

Customize models with different formats or typestyles.
Modify your format with the mouse – no retyping required.
Vary the width of your columns with the mouse.
Show currency with or without cents, commas, or dollar signs.

Standardize data collection, and reports with formatted spreadsheets.
Data entry personnel can be prompted by the CIRCLE MISSING VALUES feature.
Protection feature ensures that a model cannot be overwritten accidentally.

Use special features to analyze financial and scheduling problems.
Numbers are calculated to 15 digits.
Built-in financial functions include net present value, annuity, and compound interest.
Maximum model size is 255 rows by 255 columns.
Dates, such as 1/4/82, and durations, such as 6 days or 3 years, can be built into your model.
Built-in calendar adds or subtracts any number of days, weeks, months, or years (including leap years) to or from dates.

This is the LisaCalc worksheet with data entered in ihe sheet’s cells. You use the mouse to point to a cell, then enter data into that cell by typing in the numbers, formulas, or text you want. The program instantly computes all the information entered on the worksheet to produce answers to extremely complex problems.

Menu Bar  All LisaCalc functions are selecied from the menu bar. To print a document, for example, just move the mouse and select PRINT from the menu bar. Once printing is under way, you may continue working with Lisa, either in the same document, or in another application.

Mouse/Pointer  The mouse is a palm-size device that controls Lisa’s pointer. It replaces all confusing special function keys and commands. The mouse is connected to Lisa by a thin cable. When you move the mouse, Lisa’s pointer matches the movement on the screen.

Cells  A cell is the intersection of a column and a row. You can use the mouse (or the keyboard) to select a cell, then you can enter text or numerical values.

Desktop Manager  The Desktop Manager uses graphic symbols such as these to coordinate all the system's operations. For example, to work on a document, simply use the mouse to select an existing document or create a new one. When you’re finished, use the mouse to put the document into a folder. The Desktop Manager also enables you to work with more than one document at a time.

Columns and Rows  The maximum number of columns and rows is 255. The width of each column may be set individually from 1 to 80 characters.

LisaGraph  More than one Lisa document may be on the screen at one time. To move information from LisaCalc to LisaGraph for example, simply use the mouse to select COPY from the EDIT menu. When you’re ready to transfer the information into another document, select PASTE and your data is transferred – you don’t even have to touch the keyboard.

Scrolling  To view another part of your worksheet, simply use the mouse to select the arrows or pages in the corners of the document. Similarly, to stretch or contract the document, use the mouse to move the box at the bottom right-hand corner.

Status Panel  These two lines provide information about the cell on which you are working. CELLS shows the coordinates (location) of the cell; VALUE shows the same data that appears in the cell; and FORMULA states the calculation (if any) that has been performed (such as, A1 + B1 + C1).

Putting LisaCalc Data Into Graphs and Reports
LisaCalc data can be transferred into LisaGraph or LisaWrite easily – use the mouse and the functions CUT and PASTE.
After transfer into LisaWrite, LisaCalc worksheets can be edited, reformatted, given titles, footnotes, bold text, and much more.

“What If?” Scenarios
Changing assumptions and formulas is radically simplified with LisaCalc – just point with the mouse, then type.
Enter new data and LisaCalc recalculates automatically, quickly illustrating the impact on any scenario.
To display important data from widely separated areas, worksheets can be “split” horizontally, vertically, or in both directions at once.
Any model can be protected against inadvertent changes.

Special Features for Scheduling and Finance
Calculations are made to 15 digits for unsurpassed accuracy.
Built-in functions include net present value, annuity factor, and compound interest factor.
Dollars and cents can be formatted as desired.
LisaCalc acknowledges dates (e.g., 1/4/82) and durations (e.g., 6 days or 3 years).
A built-in calendar accurately adds or subtracts days, weeks, months, or years.
LisaCalc automatically checks all dates to ensure their consistency.

Customizing LisaCalc Worksheets
Modifications require no typing – simply use the mouse.
Columns can have different widths.
Columns and rows may be added or deleted at any time.
The contents of columns, rows, cells, and ranges of cells can be centered, or justified left or right.
Currency can be shown with or without cents, commas, or dollar signs.
A variety of typestyles is available.
Page breaks are automatic; they can also be set manually.

LisaCalc and Standardized Analyses and Reports
LisaCalc creates standard templates for uniform data collection.
LisaCalc templates can be filled in without learning LisaCalc.
“Protection” features ensure that established templates cannot be changed accidentally.
CIRCLE MISSING VALUES feature helps any data entry person place data in the right location.
Arrow keys, numeric keypad, and mouse make data entry fast.

LisaCalc – An Overview
LisaCalc eliminates the need to learn a modeling language or special computer commands. The most complex models can be represented on LisaCalc’s spreadsheet.
Data analysis is simplified by built-in functions that include sum, average, net present value, if-then, and many more.
Common arithmetic operators such as +, -, ×, ÷ are available.
LisaCalc models can be as large as 255 columns by 255 rows.
Maximum size of a LisaCalc model visible on the screen is 13 columns (of eight characters) by 28 rows.


Basic learning time:
Less than 30 minutes.

Maximum worksheet size:
255 rows by 255 columns.
Maximum model size visible – 13 columns (8 characters wide) by 28 rows.

Precision and accuracy:
Standard IEEE numerics for calculations and formatting provide unsurpassed accuracy.
15 digits for high-precision calculations.

Editing is done the same way as in other Lisa applications.
Intracell editing.
Cut and paste, copy, move, replace, delete.
Insert new rows or columns.
Copy values or formulas into other models.

Left and right justification, and centering.
Fit as many as 132 columns on an 8½ × 11-inch (215 × 279 mm) page.
Variable column widths (1 to 80 characters).
Integer, decimal, and exponential numbers, with variable number of digits after decimal or exponent.
Various money formats (commas, dollar signs, cents).
Brackets for negative money values.
Fill pattern format.

+, -, ×, ÷.
=, <, >, ≥, ≤, <>, AND, OR, NOT.
Integer division, remainder.
Sum, average, minimum, maximum, count, exponent.
NPV, compound interest factor, annuity factor.
Absolute value, integer portion, round off.
Log, natural log. square root, sum of squares.
Lookup, NA, error.
Sin, asin, cos, acos, tan, atan.

Specify dates as mm/dd/yy.
Specify date parts as a number of days, months, or years.
Add, subtract, and compare dates or date parts.
Many functions work with dates or date parts.

Calculation features:
Automatic and manual recalculation.
Calculates until convergence is achieved.

Data exchange:
Move data and models between LisaCalc documents.
Move data and text into LisaGraph and LisaWrite.

Special features:
“Protection” guards ceils from being accidentally changed.
CIRCLE MISSING VALUES highlights cells that are referenced in a formula but do not contain valid data.
UNDO function cancels the effects of last operation.
REVERT TO PREVIOUS VERSION undoes all changes made to the document since it was last saved.
Up to 6 vertical or horizontal splits of the window.
More than one worksheet on the screen at once.

“What you see is exactly what you get” fidelity.
Automatic or manual page breaks.
Print formulas or values.
Apple’s high-resolution Dot Matrix Printer (160 × 144 dots per inch; 6.2 × 5,6 dots per mm).
Apple’s Daisy Wheel Printer.
Print one or multiple copies.
Print whole model or selected pages.
Print in horizontal or vertical formats.
A variety of typestyles are available, including a small, 15-pitch size.
Paper can be 8½ × 11 (215 × 279), 8½ × 14 (215 × 355), or 11 × 14 (279 × 355 mm) inches.

Brief orientation guide to get you started in 30 minutes.
Complete reference guide.
Extensive step-by-step tutorial.
Handy reference card.

[illustration captions]

LisaCalc data can easily be graphed in LisaGraph. Transferring the data between the two requires only three quick steps. Similar steps will incorporate a LisaCalc model into a LisaWrite document.

Splitting the screen opens windows into different portions of the model, allowing you to see the effects of changes immediately. More than one model can also be viewed on the screen simultaneously.

Customizing your LisaCalc model can be done at any time and requires no special commands. Use the mouse to “stretch” any column or format its contents.

Special program functions make it easy to learn and use LisaCalc. Move the mouse to select one of the menu titles at the top of the screen. Press the mouse button and the menu appears. Select a function and LisaCalc does the rest.

[fine print]

Apple Computer, Inc.
20525 Mariani Avenue
Cupertino, California 95014
(408) 996-1010
TLX 171-376

Apple Computer (U.K.) Ltd.
Eastman Way
Hernel Hempstead
Herts HP2 7MO
TLX 851-825834

Apple Computer International
5/7 rue de Chartres
92200 Neuilly-sur-Seine
TLX 842-630296

Apple Canada
875 Don Mills Road
Don Mills
Ontario, Canada M3C 1V9
(416) 444-2531
TLX 06-986561

® Apple and the Apple logo are registered trademarks of Apple Computer, Inc.
™ Lisa is a trademark of Apple Computer, Inc.
Product specifications may change without notice.
Printed in USA
© Apple Computer, Inc.

Lisa brochures: LisaCalc · LisaGraph · LisaList · LisaTerminal · LisaWrite
Page added on 22nd January 2005.

Copyright © 2002-2006 Marcin Wichary, unless stated otherwise.