Coin Slot Magazine - #V8N8 - 1983 - April [International Arcade Museum]
21
Units on Floor
45
member, Visicalc and Multiplan have
22
23 Overhead per Unit.....
a maximum of 63 columns and 255
rows? Well, 1 -2-3 has a maximum of
$71.11
24
25 Expenses per month
$191.11
26
27
28 Profit per Unit
$258.89
29
255 columns and 2000 rows! A
much larger sheet! Your individual
needs will dictate which of these
programs will work best for you, but
you should at least be aware that
this type of program is available.
Every business has numerous ap
plications for this type of program.
Think about what yours might be.
Anyplace on this projection where
on 20 different machines we propose
a calculation is performed is actually
to put into our arcade. These pro
aformula and is re-evaluated when
ever any of the figures are changed.
So, to do an analysis of a new
jections would be stored as separate
machine that rents of $11 7.50 and
expected sales per day are 75, we
merely replace those figures and
would go to the other sheets and
to compile a composite profit pro
impact that this type of pro
the projection is already done for
jection.
gram is having, let me tell
the new machine. This sheet, com
sheets on the disk Then a consolida
tion sheet could be prepared, which
extract the necessary information
This is a very useful function for
plete with the formulas, is saved on
multiple businesses or multiple pro
disk and can be called up at any
jects. Information can be shared
time. It can also be saved for each
between
machine and recalled selectively.
As rent, payroll, or utilities change,
everything we have talked about
sheets.
Multiplan
has
here. 1-2-3 has everything Multiplan
The Wall Street Journal says that
this "may well be the decade of the
microcomputer." Don't restrict your
self to the age of the calculator.
As a further example of the
you what happened yesterday in
the store. A well-dressed gentleman
came in about mid-afternoon. After
the usual opening amenities, I soon
found out that he is a financial
planner for oil & gas companies
here in Denver. Specifically, he ex
amines investment options for his
clients. Simply put, he gathers
necessary information about available
these can be changed also and the
has except the multiple-sheet con
projection
You can
solidation, but it has a lot more. It
also look at the profit on a machine
should since it sells for $495.00,
that is played 20 times a day versus
30 versus 40, etc The original Visicalc
compared to Multiplan's $250.00.
1-2-3 has graphic display analysis
program could be used to do these
That is, data compiled using the
projections.
spreadsheet can be displayed graph
his findings. I asked if he was aware
of the spreadsheet programs Yes,
specify how many characters per
ically. This can be a line graph, a
bar chart, or a pie chart. Graphics
are very useful tools in presentations
A picture is worth a thousand words,
column and vary this amount from
as they say.
re-evaluated.
Let's look at the advantages of
the two newer programs. There are
better formatting options. We can
column to column. Each cell can be
1-2-3 is the only program that
controlled as to whether the value
allows you to instantly switch back
investment options, compares these
options, and writes reports revealing
he had heard of them, but had never
seen one in operation. I showed
him a simple profit and loss projection
covering a 12-month period in which
he could choose any growth per
centage for sales and watch the net
profit change. The whole projection
took less than ten minutes to set
up. And with each new change I
"magically" fit into the model, his
is to be displayed as a dollar and
and forth between the spreadsheet
cents format, an integer (or whole
and the graphic display. Ifs fascinating
number) format, or any number of
to change a value, switch to the
decimals. It may be advantageous
graphics and see how it affected
to allow a title to use two or three
the line, switch back, change a value,
eyes grew larger and his gasps
cells for display and this is easily
switch back, etc.
The "3" in the 1-2-3 refers to its
database management function.
This capability enables it to sort
information or search through data
grew louder. When I finished, his
done with the newer programs. In
dividual cells can be protected against
accidental erasure. The cells that
have formulas should be protected
first comment was, "Do you know
how long that would take me by
hand?" He estimated at least an
hour do each re-calculation, which I
when the formulas are finished. Then
only the variable amounts cain be
changed. This makes it easy for a
for specified criteria. For instance,
say we set up the sheet with column
headings as follows: Name, Age,
was producing in a matter of seconds
once the initial sheet was set up. He
mentioned spending hours calcu
novice to use a model created by a
Address, City, State, Zip. Appropriate
lating
more-experienced user.
information would be filled in below
results only to find that he had
made an error, at which time he
.com
m
the
headings for maybe 500 entries.
One advantage of Multiplan : over
u
m
use At this time, the entire sheet could
fro programs
any of the other spreadsheet
m
d
-
e
e
d information
d
be sorted by zip code and sub-
is its ability to exchange
nloa to w another,
arca or to sorted by name. Or, all of the zips
.
w
from one o sheet
D
/ww from many between 80000 and 89999 could
consolidate information
/
:
p
t
ht one. Maybe we'd better be copied to another section of the
sheets into
look at an example of this. Assume
that we have performed projections
APRIL 1983
© The International Arcade Museum
sheet.
One final word about 1-2-3. Re
figures and typing
up the
would have to re-do the whole sheet
After a brief consultation about
the necessary hardware-software
configuration, he chose an IBM
Personal Computer running the 1-
2-3 program, a letter-quality printer,
and a pen plotter.
13
http://www.arcade-museum.com/