Download HPPalmtop - HP Computer Museum

Transcript
..
,
.
,
Getting Lotus 1·2·3 and
HP CALC to Work As a Team!
LOTUS
Ed demonstrates how the 95LX's CALCCELL
function integrates Lotus 1-2-3 and HP CALC
By Ed Keefe
Integrating Lotus 1·2·3
and HP CALC
Let me describe a feature of the solve
program that will make your life in
the math lane much simpler. This
technique ties together Lotus 1-2-3
and HP CALC's SOLVE function.
Once you have seen this technique,
you will be able to design interchangeable solution programs in SOLVE
with one or two lines of code.
To show you how this technique
works, I'll use INSURE.WKl ii , a
simple 1-2-3 worksheet that compares
the value of whole life vs. term insurance.
If you don't get The HP Palmtop
Paper ON DISK and want to follow
along on your 95LX, start 1-2-3 with
a blank worksheet. Set column A to a
width of 5 ([MENUI Worksheet Column
Set-width 5IENTERI) and set the width
APPLICATION
BUILDER
of column D to 12.
Now key in the following worksheet labels and functions. (If you
want to save a lot of keystroking, just
key in the formulas in cells Dll and
D13. The labels in column A are just
reminders, anyway.)
Cell Contents
A1:' Whole Life vs. Term Insurance
A2: 'Ann'l Prem for Term
A3: 'Ann'l Prem for Life
A4: 'Whole Life Cash Val
AS: ' Period (years)
A6: 'Whole Life Cash Val
A7: ' at end of Per.
A8: 'Avg Ann'llnt Rate
A9: ' over Period
A10: 'Future Value of Oiff
A11: ' in Premiums
A12: 'Savings (+) Loss (.)
A13: ' with Term Ins
011: @FV((03-02)/12,(09/12)/100,05*12)
013: +011-07
When finished, your worksheet
should look like this.
Ail PR [W5J'
Whole Li/'e vs. rerllll!Clal
FOR THE HP 95LX
With QAPaim you can create
custom data collection and
viewing applications for your
palmtop on your PC without
programming. Uses an easy
screen painting approach.
Transfers data to dBase and
LotUs 123 formats. Demo available.
QA SYSTEMS, INC.
220 East 42nd Street
New York, N.Y. 10017
1800945-1717 / 212599-1717
Fax 212-599-2614
$5,000.00
6
$8,258.18
Worksheet looks like this
Key in the numbers as shown below.
If necessary, set the number of deci-
mal places to 2 in cells D2, D3, D7,
Dll, and D13 (press I MENU I Range
Format Currency 2 while in the cell.
(This makes the numbers in those
cells appear with currency formats .)
At Ceil:
02:
03:
05:
07:
09:
Key in
310
453
25
5000
6
The last two lines will not appear on
the HP 95LX. Press I < OownArrow > I to
scroll the screen to see the "bottom
line."
011: $8,258.18
013: $3,258.18
In other words, if you invested the
money you saved with term insurance at a 6% annual rate, you would
earn $5,000 more over 25 years.
8acksolving Using HP CALC
with Lotus 1·2·3
Now, suppose you wanted to run the
program in reverse to find what annual premium for term insurance
would give a saving/loss figure of
$0.00 exactly. 1-2-3 can't solve such a
"backsolving" and uses the HP CALC
program.
Keep 1-2-3 running and press
I HP CALCI. Then press I MENU I Solve to
activate the SOLVER. Press ~ to
Ii Find it on The HP Palmtop Paper ON DISK, Nov/Dec 92.
ABOUT THE AUTHOR
[Ed Keefe is an author, programmer, computer science instructor, and longtime contributor to support publications for HP computers. He is the president
of the FastAid Company, 314 S.w. Logan, Ankeny, IA 50021. Ed's CompuServe ID# is [75300,3667J.J
52 THE HP PALMTOP PAPER NOVEMBER / DECEMBER 1992