how to save the sensitivity graphs as table?

Use this forum to post Vensim related questions.
Post Reply
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

how to save the sensitivity graphs as table?

Post by yongyang »

hi, this question may be too simple for most people here.

for the target variable, the sensitivity grant could display mean value, 50%, 75%, and any other user defined confidence bounds. but I would like to save these information as a table, for example, I have interest to save the two lines (together they make up the 95% confidence bound) over time as a table. Could you help me on this?

thanks,

Yong
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: how to save the sensitivity graphs as table?

Post by Administrator »

You cannot save the values in the tables. All you can do is export the sensitivity run and re-calculate them in something like Excel.
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
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: how to save the sensitivity graphs as table?

Post by tomfid »

Not so. In DSS you can use the % keyword with SENS2FILE in a command script. This will get integrated into the normal export process at some point. https://www.vensim.com/documentation/in ... s2file.htm
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

thanks a lot to both of you.

So without DSS, all I can get is a visualization? we could roughly estimate the values of any confidence bounds but no way to the specific values? that is really a pity: visualization is important, but it seems to me, most people would like to obtain the information quantitatively, will be much easier to share and report to others. Why the VENSIM does not allow this? thanks!
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: how to save the sensitivity graphs as table?

Post by tomfid »

Remember that PLE is a learning tool, not a production tool.

That said, we're upgrading most of the tools, and this is the kind of thing that will get implemented in the new system.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: how to save the sensitivity graphs as table?

Post by Administrator »

yongyang wrote:thanks a lot to both of you.

So without DSS, all I can get is a visualization? we could roughly estimate the values of any confidence bounds but no way to the specific values? that is really a pity: visualization is important, but it seems to me, most people would like to obtain the information quantitatively, will be much easier to share and report to others. Why the VENSIM does not allow this? thanks!
I think it's because analysing sensitivity runs is not as straightforward as looking at a single graph (from a single run). It's always been assumed that to do any proper analysis, you'd need the results in a spreadsheet.

I've added a new ticket to our system to implement this, so it should be done soon.
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
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

thanks a lot. good to know. What i am using is PRO not PLE.
tomfid wrote:Remember that PLE is a learning tool, not a production tool.

That said, we're upgrading most of the tools, and this is the kind of thing that will get implemented in the new system.
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

great! thanks a lot!
Administrator wrote:
yongyang wrote:thanks a lot to both of you.

So without DSS, all I can get is a visualization? we could roughly estimate the values of any confidence bounds but no way to the specific values? that is really a pity: visualization is important, but it seems to me, most people would like to obtain the information quantitatively, will be much easier to share and report to others. Why the VENSIM does not allow this? thanks!
I think it's because analysing sensitivity runs is not as straightforward as looking at a single graph (from a single run). It's always been assumed that to do any proper analysis, you'd need the results in a spreadsheet.

I've added a new ticket to our system to implement this, so it should be done soon.
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

Administrator wrote:
yongyang wrote:thanks a lot to both of you.

So without DSS, all I can get is a visualization? we could roughly estimate the values of any confidence bounds but no way to the specific values? that is really a pity: visualization is important, but it seems to me, most people would like to obtain the information quantitatively, will be much easier to share and report to others. Why the VENSIM does not allow this? thanks!
I think it's because analysing sensitivity runs is not as straightforward as looking at a single graph (from a single run). It's always been assumed that to do any proper analysis, you'd need the results in a spreadsheet.

I've added a new ticket to our system to implement this, so it should be done soon.
Hi, could you give me any ideas how soon this function could be added? of course, just a rough estimation, I asked this because if the timeline is within several weeks, I will wait. if within several months, I will try to figure out other ways for solve this problem. thanks a lot!
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: how to save the sensitivity graphs as table?

Post by Administrator »

yongyang wrote:Hi, could you give me any ideas how soon this function could be added? of course, just a rough estimation, I asked this because if the timeline is within several weeks, I will wait. if within several months, I will try to figure out other ways for solve this problem. thanks a lot!
I cannot give you an estimate. The quickest thing for now would be to export the results file to Excel and do the analysis there.
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
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

Administrator wrote:
yongyang wrote:Hi, could you give me any ideas how soon this function could be added? of course, just a rough estimation, I asked this because if the timeline is within several weeks, I will wait. if within several months, I will try to figure out other ways for solve this problem. thanks a lot!
I cannot give you an estimate. The quickest thing for now would be to export the results file to Excel and do the analysis there.
Could you tell me how to export the results file to Excel? if it could be done, then problem solved. thanks a lot!
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: how to save the sensitivity graphs as table?

Post by Administrator »

Open the Vensim help and search for exporting datasets. It's the first link in the results.
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
yongyang
Junior Member
Posts: 7
Joined: Tue May 30, 2017 8:15 pm
Vensim version: PRO

Re: how to save the sensitivity graphs as table?

Post by yongyang »

Administrator wrote:Open the Vensim help and search for exporting datasets. It's the first link in the results.
i see, so you mean i still have to export all simulation data and then compute the 95% confidence interval manually?
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: how to save the sensitivity graphs as table?

Post by Administrator »

yongyang wrote:i see, so you mean i still have to export all simulation data and then compute the 95% confidence interval manually?
Yes. When you export a sensitivity run, all the simulations are exported.
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
JudeChen
Member
Posts: 20
Joined: Thu Jul 04, 2019 7:42 am
Vensim version: DSS

Re: how to save the sensitivity graphs as table?

Post by JudeChen »

Hi I would like to check that the confidence bounds used within the Sensitivity graph refers to the number of graphs that fall within the bound right? It does not refer to the confidence intervals used in statistical analysis right? Or am I missing some statistical knowledge that I should know here? I did a 1000 simulation runs and the range of possible data was huge, which is fine, but when I calculated confidence intervals at each time point it was tiny. Sorry if I sound silly here for doing something wrong here.
JudeChen
Member
Posts: 20
Joined: Thu Jul 04, 2019 7:42 am
Vensim version: DSS

Re: how to save the sensitivity graphs as table?

Post by JudeChen »

Oh nvm, just realized Vensim represents the graphs based on percentiles, which makes sense! Thanks!

Curious question, is it possible for me to buy a CD of the software and install it in a non-internet connected computer?
Post Reply