how to make vensim update get xls constants?
how to make vensim update get xls constants?
After changing values in an xls-file that I use as input and saving that xls file, vensim does not automatically read the new values. My work around is to close the model, reopen it and then vensim reads in the new values. My question is wether there is a key-combination (ideal), or at least a menue-command that I can click to make Vensim pick up the new values so I don't have to close the model every time. Please not that I am working on the mac version of Vensim so that it picks the values directly from the file not from the excel application.
Re: how to make vensim update get xls constants?
This is a Mac limitation. GET XLS uses GET DIRECT on the Mac, so the file has to be saved for changes to propagate. On Win GET XLS passes live values.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Re: how to make vensim update get xls constants?
saving the xls file does not help.
saving the vensim file does not help either.
Only closing and reopening the vensim file helps.
But that is subotimal (I have to move the window to second screen, resize it, show hidden elements etc.) before I can start working again.
It seems Vensim does not re-read the xls file each time it runs a simulation. How can I make Vensim re-read the xls-file?
saving the vensim file does not help either.
Only closing and reopening the vensim file helps.
But that is subotimal (I have to move the window to second screen, resize it, show hidden elements etc.) before I can start working again.
It seems Vensim does not re-read the xls file each time it runs a simulation. How can I make Vensim re-read the xls-file?
Re: how to make vensim update get xls constants?
That does sound wrong. I'll test.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: how to make vensim update get xls constants?
Can you post an example with step by step instructions so we can test?
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- Junior Member
- Posts: 11
- Joined: Fri Aug 26, 2016 9:49 pm
- Vensim version: DSS
Re: how to make vensim update get xls constants?
I am now running into a similar problem, using CSV files with GET DIRECT CONSTANTS. I ran the model with no problem when I had a single, unified CSV file. I would change the CSV file and Vensim would use the modified version. However, I have just split the data set into four different files, and Vensim no longer reads in data even after I save the files. I have to go to Settings -> XLS files -> Modify Selected (with no changes) -> Add Editing to force it to look again. (Or restart.)
Another change in my case is that I just updated to the new "Anniversary" edition of Windows 10. (Actually, not my choice -- MS did it for me, with no option to postpone.)
I attach my model, with data files.
Thanks,
Eric
Another change in my case is that I just updated to the new "Anniversary" edition of Windows 10. (Actually, not my choice -- MS did it for me, with no option to postpone.)
I attach my model, with data files.
Thanks,
Eric
- Attachments
-
- p2cs-multisector.zip
- (10.41 KiB) Downloaded 205 times
Re: how to make vensim update get xls constants?
This just crashes when I attempt to run it. Will investigate.
/*
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
Advice to posters (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Blog: http://blog.metasd.com
Model library: http://models.metasd.com
Bookmarks: http://delicious.com/tomfid/SystemDynamics
*/
-
- Junior Member
- Posts: 11
- Joined: Fri Aug 26, 2016 9:49 pm
- Vensim version: DSS
Re: how to make vensim update get xls constants?
Thanks very much. And interesting... it doesn't crash for me.
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: how to make vensim update get xls constants?
Can you give me a list of parameters that are not updating? My tests here are working fine.ekempbenedict wrote:I am now running into a similar problem, using CSV files with GET DIRECT CONSTANTS. I ran the model with no problem when I had a single, unified CSV file. I would change the CSV file and Vensim would use the modified version. However, I have just split the data set into four different files, and Vensim no longer reads in data even after I save the files. I have to go to Settings -> XLS files -> Modify Selected (with no changes) -> Add Editing to force it to look again. (Or restart.)
Another change in my case is that I just updated to the new "Anniversary" edition of Windows 10. (Actually, not my choice -- MS did it for me, with no option to postpone.)
I attach my model, with data files.
Thanks,
Eric
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- Junior Member
- Posts: 11
- Joined: Fri Aug 26, 2016 9:49 pm
- Vensim version: DSS
Re: how to make vensim update get xls constants?
Yes, I was changing "investment utilization sensitivity" in the CSV file and it was not updating in Vensim.
-
- Super Administrator
- Posts: 4589
- Joined: Wed Mar 05, 2003 3:10 am
Re: how to make vensim update get xls constants?
ok, I think I've found the bug. Just need to do some testing before creating a new build.
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
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391
Units are important!
http://www.bbc.co.uk/news/magazine-27509559
-
- Junior Member
- Posts: 11
- Joined: Fri Aug 26, 2016 9:49 pm
- Vensim version: DSS
Re: how to make vensim update get xls constants?
Thanks very much!
-
- Junior Member
- Posts: 11
- Joined: Fri Aug 26, 2016 9:49 pm
- Vensim version: DSS
Re: how to make vensim update get xls constants?
FYI, I discovered that part of the problem was the timestamp on the file. I have several versions of the CSV input files, and before a run I copy one version into the master using a Windows batch file. I realized that I have to "touch" the file to bring it up to date so Vensim knows that it's changed. This is my revised batch file:
use.bat
That works. If anyone is interested, it works like this:
Then it copies 'scalar_constants_my_scenario.csv' into 'scalar_constants.csv' for the run.
Eric
use.bat
Code: Select all
DEL scalar_constants.csv
COPY scalar_constants_%1.csv scalar_constants.csv
TOUCH scalar_constants.csv
Code: Select all
command line> use my_scenario
Eric