Please enable JavaScript to view this site.

Vensim Help

Navigation: Reference Guide > Functions > Data Functions

GET 123 DATA('file','tab','time row or col','cell') GET DATA from lotus 123

Scroll Prev Top Next More

Returns time series data from Lotus 123 for a Data variable or a vector of Data variables.

Restrictions: Must appear directly following the data equals sign := and not be followed by anything.  

The GET 123 DATA function is invoked during simulation setup, before the active simulation begins.  If Lotus 123 is not running Vensim will attempt to start it.  If Lotus 123 does not have the specified file open Vensim will try to get Lotus 123 to open it.  If Vensim cannot get values from Lotus 123 it reports an error.  If Vensim has trouble getting values with this function you should try opening the named file in Lotus 123 first.

All of the arguments to GET 123 CONSTANTS 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 Lotus 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 123 that do not support tabs. 'time row or col'  is either the number of the row containing Time values (Time running across) or the letter of the column containing Time values (Time running down).  Note that the spreadsheet file must contain values for Time and  these values must be Time values and not those of an alternate Time Base. 'cell'  names the cell that the first Data value is on.  Vensim will read values for different times across or down depending on the 'time row or col' argument.  Vensim will also read additional subscript elements in the other direction.


Units: GET 123 DATA is not part of units checking.  Specify units for the left hand side variable.

NOTE GET 123 DATA is not available on the Macintosh.

Availability:  Not PLE.