Loading

Everything HP200LX: Knowledge, Products, Service 

Transferring Solver Equations to 123
123's named range feature makes transferring equations from Solver to a 123 spreadsheet pretty simple. Equations may be imported into 123, oneattime, from the Solver catalog using the 95LX's clipboard. An entire equation file may be imported into 123 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, 123 will assume the extension is .PRN and tell you that the file does not exist. Now that your equations are in 123, 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 123, 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 123 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 reedit 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 123 does not. If an equation starts with a variable (e.g. FEET), put a plus sign in front of the variable (+FEET).


Copyright © 2010 Thaddeus Computing Inc