IB81
"Mortgage/Rent
[B91
"Rates
[Bl01
"Gas
IB11]
"Electricity
IB12]
"Water
rates
[B131
"Te
I ephone
[B141
"Insurance
[B15]
"Clothing
[B16]
"Hi
re-purchase
IB171
"Car
tax
[B18]
"Pet
ro
l
IB19]
"TV
licence
[B20]
"Savi
ngs
[B22]
"Quarterly
tots
[0221
sum(col)
lrows 810
20J
[F22]
sum(col)
Irows 8
to
201
[H22]
sum(colJ
[rows 8
to
20]
[J22]
sum(colJ
[rows 8
to
201
[025]
"Yearly
[F25]
"Mont
h l y
[B27]
"Payment
s
[027]
sum(d22:j22J
[F271
year.pay/12
[028]
rept("=",len(str(year.paY,0,2J)+1)
[F28] d28
Note that the underlining
at
the
two
final
figures assumes a monetary
format.
The
length
of
the underlining
is
for
a number
In
decimal
format.
with
two
deCimal
places, plus one
(for
the currency symbol).
You
also should use a
few
more commands,
to
Justify
text
nght
In
the range B22:B27
(quarterly
tots
and payments) and
to
Justify
numbers left over the cells containing the
yearly and monthly payments.
You
must also modify the numeric display
format.
Since many
of
the cells are
still
empty,
Simply changing the format
will
have no
effect.
You
must change the default format
of
the cells
to
make the effect permanent.
The
following command
will
change the display default
to
monetary
Units
over the whole
of
the budget application.
Units,DefauLts,Monetary,Minus
sign
The
display
of
Figure
5.5
uses
deCimal
format.
with
two
deCimal
places, except for the
yearly and monthly payments, which
are
in
monetary format
The
appropnate commands
are:
Units,DefauLts,DecimaL,Decimal
pLaces
2
Units,Cells,Monetary,Minus
sign,Range
d27:f27
ThiS
last
command can use the Cells oplion since the cells concerned already
exist.
You
can enter values
in
this table by moving the cursor
to
the appropriate cell and typing
In
the number. The easiest
way
of
moving the cursor
is
to
press
F5
(Go
to
cell)
and
then use a cell label, such
as:
apr.gas
The
chart displays twelve
values,
labelled
by
month. The values
are
read from twelve
cells above the chart. The vertical scale
is
adjusted automatically
to
make sure that
all
values
will
fit
the display.
It
IS
only suited
to
displaying positive
values.
First
you
should
set
the column
Widths
to
five
In
column
A,
one
in
column B and three
in
columns C
to
N,
uSing
the Width option
of
the Grid command.
[C2]
row=O [columns C
to
N]
'2'84
Exampes
AN
AUTO·SCALING
BAR
CHART
To Next Page
Loading...
Need help?
General
