Ventana software support forum

That works Tony. Thanks:)

Hi I try to run an optimization on a variable called the effective spot market price and selected the variable from the available variables in the model. However I received this error: ERROR: Name effective spot market price not found in actual data files. Any idea how I can overcome this? Thanks

TQVM:) I will give it a try.

Actually I want the variable in Vensim that takes the data from Excel to be updated as the model runs. For example, first it takes the data from cell E1 and perform some task then take data from cell E2 and repeat the process till all the Excel data has been taken. My specific problem is I have a li...

Thanks for the feedback. I will try them out:)

I see. Will I be able to get the data one by one from Excel if I were to use Vensim DSS and use VB to get the values? Then I can feed the constant one by one to Vensim DSS to run my model. Will that work or would it be rather tricky to do that?

Thanks

I have a variable 'scheduled production' for an annual production schedule that is made up using Excel data using the Get Xls data command. Then I have another function that is defined as IF THEN ELSE(price>production cost,production ahead,scheduled production). However at the time steps where the E...

TQ for the suggestion. But I am still not sure how the data can be obtained from Excel.The command 'Get Excel constants' needs me to specify the cell and I am not sure how to update the cell number for me to get the second value.

I have been thinking on how to do a particular task using Vensim Pro for some days. I have a schedule of power plants to be constructed in an excel file. But before I want to construct a plant, I want to evaluate the market price ( a variable that I have already determined). If the price is higher t...