Data import from excel

cchab · Post by **cchab** » Wed Jan 24, 2007 4:31 pm

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]

cchab · Post by **cchab** » Wed Jan 24, 2007 4:44 pm

The vensim file was attached in my last message... sorry

Post by **Administrator** » Thu Jan 25, 2007 9:43 am

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.