Making Lookup Graph

Monte · Post by **Monte** » Tue Nov 14, 2006 2:09 pm

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

Post by **Administrator** » Tue Nov 14, 2006 4:03 pm

There is a function called

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

You can read the data directly from Excel.

Tony.

Lee Jones · Post by **Lee Jones** » Tue Nov 14, 2006 5:04 pm

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).

bob@vensim.com · Post by **bob@vensim.com** » Tue Nov 14, 2006 10:17 pm

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

Monte · Post by **Monte** » Wed Nov 15, 2006 3:56 pm

Thank you so much for your helps.