Optimization: data import format
Posted: Tue Jun 22, 2021 9:05 pm
Hello Vensim folks,
just started looking at the optimization functionality in Vensim and seem to have fallen at the first hurdle.
I set up a very simple test model A->B with first order rate (first attachment), then made a synthetic data set in excel for B (B(t)= Ao(1 - e^(-kt))
The data was copied into a notepad window with the first line describing the data.
B reaction curve
1 9.516258196
2 18.12692469
3 25.91817793
4 32.9679954
5 39.34693403
6 45.11883639
7 50.34146962
8 55.06710359
9 59.34303403
10 63.21205588
.
.
.
etc
file saved as B_reactionCurve.dat (I would like to attach it here as well but this webpage uploader will not accept it).
I then loaded it into Vensim using either Model > from .dat format OR Model> Import dataset; either works.
the import appears to work as i do get a window saying "writing 24 values for B reaction curve" etc etc see attached "screenAfterDataImport.png"
although I dont see any errors, there is no data displayed in the graph or the table.
Pretty sure something basic is wrong, not mentioned in the manual. Perhaps there is a command/button/setting to load the data into memory? The electric.mdl example in the manual is a bit frustrating as there are parts that dont seem to correspond to this version of Vensim.
for example:
Click OK in the message box and close the Output window.
Ø Double click on percent of US dwellings with electric power.
Ø Click on the Graph tool. Two datasets, run1 and electric, display lines for percent of US dwellings with electric power.
double click on what?? button? image? menu item?
A much simpler example with a stepwise procedure would help a lot. Perhaps this particular problem might form the basis of an Optimization tutorial?
Thanks for any help, or direct me to an alternative example?
Thomas
just started looking at the optimization functionality in Vensim and seem to have fallen at the first hurdle.
I set up a very simple test model A->B with first order rate (first attachment), then made a synthetic data set in excel for B (B(t)= Ao(1 - e^(-kt))
The data was copied into a notepad window with the first line describing the data.
B reaction curve
1 9.516258196
2 18.12692469
3 25.91817793
4 32.9679954
5 39.34693403
6 45.11883639
7 50.34146962
8 55.06710359
9 59.34303403
10 63.21205588
.
.
.
etc
file saved as B_reactionCurve.dat (I would like to attach it here as well but this webpage uploader will not accept it).
I then loaded it into Vensim using either Model > from .dat format OR Model> Import dataset; either works.
the import appears to work as i do get a window saying "writing 24 values for B reaction curve" etc etc see attached "screenAfterDataImport.png"
although I dont see any errors, there is no data displayed in the graph or the table.
Pretty sure something basic is wrong, not mentioned in the manual. Perhaps there is a command/button/setting to load the data into memory? The electric.mdl example in the manual is a bit frustrating as there are parts that dont seem to correspond to this version of Vensim.
for example:
Click OK in the message box and close the Output window.
Ø Double click on percent of US dwellings with electric power.
Ø Click on the Graph tool. Two datasets, run1 and electric, display lines for percent of US dwellings with electric power.
double click on what?? button? image? menu item?
A much simpler example with a stepwise procedure would help a lot. Perhaps this particular problem might form the basis of an Optimization tutorial?
Thanks for any help, or direct me to an alternative example?
Thomas