Ventana software support forum

Hi,

Is there a tip for filling a large number of input/output data in a lookup graph? In my case, a goal is to specify hundreds of data points (kept in Excel) to make a lookup graph. This, if done manually, is time-consuming and vulnerable to mis-specification.

Hope you can help.

Monte

There is a function called

GET XLS LOOKUPS('file','tab','x row or col','cell')

You can read the data directly from Excel.

Tony.

In addition to the get_xls_lookup function already mentioned, if you arrange the data pairs in Excel and copy them to the clipboard, you can "import" from the clipboard using the "import vals" button in the bottom-left of the equation editor (when looking at a lookup table equation in "as graph" mode).

If this is actually Time Series Data don't use a lookup - make it a data variable.

Thank you so much for your helps.