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
getting data for reference mode from an outside file
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
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.
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.
reference mode
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
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
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
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]
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]
getting outside data for reference mode
Hi Bob
Thanks a lot.
I know now how to do it.
Best regards.
JJ
Thanks a lot.
I know now how to do it.
Best regards.
JJ