Page 1 of 1

Data import from excel

Posted: Wed Jan 24, 2007 4:31 pm
by cchab
Hi

I have a problem importing data from excel.

The data are only available at distinct time points

I did try to use the :hold backward: and :look forward" data
functions , but obtained the same results with and without
these functions...

I would to hold bakward data values ...

I send to you a short vensim program (test.mdl and the excel file (test.xls)

can you tell me what is wrong ?

Thanks

[Edited on 1-24-2007 by cchab]

vensim file

Posted: Wed Jan 24, 2007 4:44 pm
by cchab
The vensim file was attached in my last message... sorry

Posted: Thu Jan 25, 2007 9:43 am
by Administrator
It is all working exactly as you expect. The problem is that when graphing, Vensim only plots the points it has joined with straight lines, which are the data points from Excel.

If you look at the attached model, you will see I have introduced three aux variables, these show how the data points are actually used in Vensim.

Hope it clears things up.

Tony.