Search found 9 matches

by tbs14
Thu Apr 29, 2010 11:41 pm
Forum: Vensim
Topic: Optimization error
Replies: 4
Views: 6375

That works Tony. Thanks:)
by tbs14
Thu Apr 29, 2010 5:08 am
Forum: Vensim
Topic: Optimization error
Replies: 4
Views: 6375

Optimization error

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
by tbs14
Mon Apr 26, 2010 4:32 am
Forum: Vensim
Topic: taking data from excel - one by one
Replies: 8
Views: 9894

TQVM:) I will give it a try.
by tbs14
Thu Apr 22, 2010 9:42 pm
Forum: Vensim
Topic: taking data from excel - one by one
Replies: 8
Views: 9894

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...
by tbs14
Wed Apr 21, 2010 11:22 pm
Forum: Vensim
Topic: interpolation of excel data
Replies: 4
Views: 5788

Thanks for the feedback. I will try them out:)
by tbs14
Wed Apr 21, 2010 11:18 pm
Forum: Vensim
Topic: taking data from excel - one by one
Replies: 8
Views: 9894

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
by tbs14
Wed Apr 21, 2010 2:32 am
Forum: Vensim
Topic: interpolation of excel data
Replies: 4
Views: 5788

interpolation of excel data

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...
by tbs14
Wed Apr 21, 2010 1:21 am
Forum: Vensim
Topic: taking data from excel - one by one
Replies: 8
Views: 9894

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.
by tbs14
Tue Apr 20, 2010 3:49 am
Forum: Vensim
Topic: taking data from excel - one by one
Replies: 8
Views: 9894

taking data from excel - one by one

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...