Integrating Vensim Excel
Posted: Thu May 20, 2021 12:43 pm
We are developing a Vensim model to evaluate, among other issues, energy use and emissions for multimodal transportation options (e.g. combinations of water, road and rail transport). The model is running fine but we also would like to run Vensim scenario's for combinations of different classes of transportation units. Could you recommend a way to extract attribute values for specific classes from Excel and load them in our Vensim model.
E.g.: Vessel Class X: Average Speed, Pay Load, Power, Speed, Energy Type, CO2-emision, NOx Emission, etc.
To run a scenario I envisage that Vessel Class X is selected by some kind of menu in Vensim (?) and related data are automatically loaded from the Excel file into our Vensim model (transforming Excel data into Vensim constants)
Looking forward to your reply!
Thanks for your attention,
Joaquim de Witte
E.g.: Vessel Class X: Average Speed, Pay Load, Power, Speed, Energy Type, CO2-emision, NOx Emission, etc.
To run a scenario I envisage that Vessel Class X is selected by some kind of menu in Vensim (?) and related data are automatically loaded from the Excel file into our Vensim model (transforming Excel data into Vensim constants)
Looking forward to your reply!
Thanks for your attention,
Joaquim de Witte