Everything HP200LX: Knowledge, Products, Service

9 years, 100's of pages of HP Palmtop Paper, jammed with tips, reviews and how-to's

Most useful, up-to-date Web sites devoted to the HP 200LX

Direct link into 1000's of pieces of Palmtop software

Tips from Our Techs

2008 Catalog
(PDF, 2.6 MB)

Contact Us/About Us

Weekly Palmtop Paper Newsletter
(Palmtop tips, latest happenings, and HP Palmtop Paper Store information)



Privacy Policy

Transferring Solver Equations to 1-2-3

Transferring Solver Equations to 1-2-3

1-2-3's named range feature makes transferring equations from Solver to a 1-2-3 spreadsheet pretty simple. Equations may be imported into 1-2-3, one-at-time, from the Solver catalog using the 95LX's clipboard. An entire equation file may be imported into 1-2-3 by pressing (MENU) File Import Text filename.eqn and pressing (ENTER). Be sure to state the (EQN) extension of the Solver equation file. If you don't, 1-2-3 will assume the extension is .PRN and tell you that the file does not exist. Now that your equations are in 1-2-3, examine them to determine if each equation occupies a single cell. There is a good chance an equation will be split on two lines. If this happens, make a copy of the .EQN file and use MEMO or another text editor to edit the copy and remove the characters causing the equations to break and occupy more than one line. Then import the edited copy, not the original .EQN file. If you are using the clipboard, be sure to put the edited equation on the clipboard.

* 30.416666 = (approx.) 365/ 12, the number of days in a year divided by the number of months, or the approximate length (in days) of a month.

** 0.03287671 = (approx.) 12/365, the reciprocal of the number of days in an average month. This fraction is common in time series analysis.

After importing equations into 1-2-3, named ranges identifying the equations variables must be created. An efficient way to do this is to list the variable names in a column and use the (MENU) Range Name Labels Right command to assign each variables name to the cell on its right.

Now go to the cell containing the equation. Assuming you have the result on the left side of the equation, remove the equal sign and everything to its left, including the label prefix character.

If you have assigned a named range to each of the equations variable, you should now have a working 1-2-3 formula. If you're getting an error and cannot get out of edit, perhaps you have not assigned a named range to every variable in the equation. If this is so, add a label identifier at the beginning of the equation to turn it back into a label. Finish naming ranges and re-edit the formula.

If you are still having difficulty, make sure the equation is valid in Lotus. For example, HP CALC allows extra spaces between operators (3 * 4), but 1-2-3 does not. If an equation starts with a variable (e.g. FEET), put a plus sign in front of the variable (+FEET).

iPhone Life magazine

Notice about Palmtop.net
The Palmtop Network with its S.U.P.E.R. (Simply Unbeatable Palmtop Essentials Repository) software is now available under the domain name of hp200lx.net.  

We Buy
We buy used palmtops, working or broken: HP 200LX, HP 100LX and 1000CX.

Copyright 2010 Thaddeus Computing Inc