Ventana software support forum

Hi

I would like to transform an exogenous data getting the data from Excel with a get xls data into a normal endogenous variable but keeping the old data as a reference mode for that data.
Is it possible to do it?
Regards.
JJ

Hi JJ,

There are several approaches to this - the cleanest is to import the data and not use GET XLS DATA. Alternatively you can simulate the model that uses GET XLS DATA with a save list only including the data of interest and call that simulation "History." Another common approach is the just create the variable "net cash flow data" using GET XLS DATA and then compare that to "net cash flow" on a custom graph.

Hi Bob

Thank you for your answer.
You say that the cleanest way is to import the data into the
the reference mode.
But how?
The only way I saw was to populate the lookup table by hand.
Is there another way?
Best regards.
JJ

Hi JJ,

If you are actually using the reference mode feature of Vensim (I thought you just meant to get the date) then you need to go to model>Setting - click on the reference mode tab and use the import .dat file option.

To get a .dat file from Excel you can reorganize by hand, or export the run from a model using GET XLS DATA.

In addition - the reference mode editor itself has in import button - just select in Excel the Time and value pairs (ie select the time row/column then control+click to select the values row/column).

[Edited on 2007-2-17 by bob@vensim.com]

Hi Bob

Thanks a lot.
I know now how to do it.
Best regards.
JJ