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
Strange behaviour with the :NA: value
Strange behaviour with the :NA: value
- Attachments
-
- example.ZIP
- (2.85 KiB) Downloaded 68 times
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
:na: strage value
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
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