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