Page 1 of 1

Strange behaviour with the :NA: value

Posted: Wed Nov 12, 2008 4:56 pm
by LAUJJL
Hi

I join two models, that make the same calculations with the same values, the same equations but give different results!
The first model example.mdl works correctly but the second model that calculates one of the value with the get xls data from an Excel file joined named example.xls does not work properly. The models are simplistic. I suspect that Vensim does not deal with a value calculated by an ordinary equation the same way than a value calculated by a get XLS data and calculates the value of :NA: because it does not find one in the Excel file corresponding to the associated time.
Joined the Winzipped file for the three files.
Does Anybody have an idea?
Regards.
JJ

Posted: Wed Nov 12, 2008 5:52 pm
by Administrator
Change the equation for ES3 so that it is

ES3 :RAW:
:= GET XLS DATA ('example.xls','feuil1','1','B2')

Vensim will interpolate by default, inserting :RAW: will make the value :NA: appear when data is missing.

Hope this helps.

Tony.

:na: strage value

Posted: Thu Nov 13, 2008 9:08 am
by LAUJJL
Hi Tony

Thanks for the answer. It works now perfectly.
In fact in my models, when one listed the values of the get xls data, Vensim showed --, but in fact it was keeping the preceeding value imported.
Best regards.
JJ