Strange behaviour with the :NA: value
Posted: Wed Nov 12, 2008 4:56 pm
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
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