Coin Slot Magazine - #V8N8 - 1983 - April [International Arcade Museum]
have been used to calculate the
It's as
sum The advantage of using Muitipian
is that any or all of the entries in the
column can now be changed and
the formula at row 8, column 2, will
re-evaluate automatically to reflect
1-2-3
the change. This is a very important
point! The numbers are all entered
by Rick Schlueter
in the column as the numbers them
selves, but the number "90" was
never entered. The computer calcu
lated it and put it on the sheet in
place of the formula that commanded
it Every time a number in the column
is changed, the total automatically
changes also.
When I began writing this
column, say column 2, starting at
series of articles, I wanted
to give a rudimentary
row 1. At the bottom of the column,
understanding of this new phenom
enon called microcomputers. We
have covered the basics of hardware
a formula is entered commanding
the computer to add the column
and record the answer there. This
the mysterious area of computer
languages. My aim has not been to
investigate or promote any specific
products but rather to convey enough
knowledge to my readers to allow
them to make a more intelligent
decision in the purchase of a
computer system. However, there
is a group of software that I feel
deserves some special attention. I n
a previous article, I mentioned a
program that really put micro
computers onto the desks of the
small businessman. It simulates a
greatly enhanced spreadsheet on
the computer. This month lefs look
at two of the newest entries of this
column numbers
1
12
10
2
15
3
13
4
31
5
15
6
6
3
4
5
6
7
8
9
904» actually a formula for
sum of column 2
row numbers
T
reason, we need to know what 6%
of that total (90) is. At row 9, we put a
would look something like this:
and software and even delved into
Seems simple enough, yet this is
the underlying principle that all of
these spreadsheet programs rely
upon. Now, let's say that, for some
his, of course, could have
been done on a paper spread
sheet and a calculator could
simple formula that says take 6% of
row 8, column 2 and put the answer
here. The answer appears as 5.4.
Now we have two formulas on the
sheet, one to total the column and
one to multiply that result by .06.
What do you think will happen if I
change the top number to 20? In
stantly, row 8, column 2 changes to
100 and row 9, column 2 changes
to 6. In summary, any time a number
is changed anywhere on the sheet,
all formulas are re-evaluated. Con
sider a profit/loss analysis on an
arcade machine. The sheet could
be set up something like this:
1 Zappo Arcade Machine P/L Analysis
type.
The programs are Muitipian by
Microsoft and 1-2-3 by Lotus.
Muitipian simulates a spreadsheet
4 Price per game
63 columns wide by 254 rows long.
6 Revenue per day
The width, in characters, for indivi
dual columns can be set by the
user. This is a large sheet, adequate
7 Days per month
3 Est games per day
10
on the screen and 20 rows. Since
12 Machine Rental
13 Machine Service
12
© The International Arcade Museum
30
$450.00
11
$100.00
$20.00
om
m.c
:
u
rom -muse 14
f
d
15 Shop Overhead:
e
e
16 Rent
load .arcad
n
w
17 Payroll
Do //www
:
18 Utilities
p
t
ht
19
the entire sheet the screen acts as
a window over the sheet and can be
moved over any part of the sheet.
Consider a simple example of spread
sheet simulation, adding a column
of five numbers. We will use the
numbers 10, 15, 13, 31, 15, and 6.
The numbers could be entered in a
$15.00
9 Revenue per month
for most spreadsheet jobs. Generally,
6 or 7 columns would be displayed
this is not large enough to display
60
$0.25
20 Total Overhead
$1200.00
$1500.00
$500.00
$3200.00
THE COIN SLOT
http://www.arcade-museum.com/