sensitivity errors when using constants from excel files

Use this forum to post Vensim related questions.
Post Reply
Chaboud Christian
Junior Member
Posts: 7
Joined: Tue Sep 22, 2020 1:06 pm
Vensim version: DSS

sensitivity errors when using constants from excel files

Post by Chaboud Christian »

I'm using Vensim DSS 8.2.1.

When perdorming a sensitivity analysis for a parameter obtained from an Excel file I get the following error :
*******************************************
ERROR: A not found or wrong type must be constant.
A=RANDOM_NORMAL(0.5,1.5,1,0.01).
^.
Line 2 of file TestSensib.vsc.
ERROR: No sensitivity inputs marked in sensitivity file.
**************************************************
When the parameter value is red in the vensim model, sensitivity analysis is running well ...

In old vensim versions, it was easy to perform sensitivity analysis on parameters obtained from Excel files ...

The attached files give an example of the problem : if 'A' variable used in sensitivity analysys : error, if 'A1' variable used : no problem


Thanks for your help
Attachments
TestSensib.vsc
(50 Bytes) Downloaded 84 times
Test.xlsx
(8.21 KiB) Downloaded 84 times
TestSensib.mdl
(1.39 KiB) Downloaded 86 times
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: sensitivity errors when using constants from excel files

Post by Administrator »

Click Simulation->Simulation control, navigate to the "Constant changes" tab and tick "Overwrite Get....XLS equations". Now it should work ok.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Post Reply