|
GET 123 LOOKUPS('file','tab','x row or col','cell') GET LOOKUPS from lotus 123 |
Scroll Prev Top Next More |
Returns Lookup x,y pairs from Lotus 123 for a Lookup variable or a vector of Lookup variables.
Restrictions: Must appear directly following the left parenthesis ( that indicates the beginning of a Lookup definition.
When a model is checked, GET 123 LOOKUPS queries 123 for the values. If 123 is not running Vensim will attempt to start it. If 123 does not have the specified file open Vensim will try to get 123 to open it. If Vensim cannot get values from 123 it reports an error. The values are also queried each time a simulation is made and a warning is given if the values are not obtainable. If Vensim has trouble getting values with this function you should try opening the named file in 123 first.
All of the arguments to GET 123 LOOKUPS are literals and must be enclosed in single quotes '. 'file' names a file with complete extension to be used. This can be a 123 file or any other type of file 123 is capable of opening. If no directory is specified (best practice) Vensim will append directory information for the current model. 'tab' names the tab that contains the Data. This function will not work with older versions of Excel that do not support tabs. 'x row or col' is either the number of the row containing x values (x running across) or the letter of the column containing x values (x running down). Note that the spreadsheet file must contain values for x. 'cell' names the cell that the first y value is on. Vensim will read successive values across or down depending on the 'x row or col' argument. Vensim will also read additional subscript elements in the other direction.
Note that you can substitute named Excel ranges for 'x row or col' and 'cell'. To do this just create the named ranges in Excel and use those names in place of the Letter/Number designators.
See also: GET 123 DATA, GET XLS LOOKUPS
Units: GET 123 LOOKUPS is not part of units checking. Specify units for the left hand side variable.
Example:
See GET XLS LOOKUPS
NOTE GET 123 LOOKUPS is not available on the Macintosh.
Availability: Not PLE.
