excel data

Use this forum to post Vensim related questions.
Post Reply
LBD
Member
Posts: 25
Joined: Wed Jan 25, 2006 7:56 pm

excel data

Post by LBD »

Hello,

Question 1

I just wanted to verify something about the excel data that we input in the vensim model. If the excel column from which the model reads data, has about 400 rows worth of data, which values does the model show in the graph? does it take an average? for that particular month?

Question 2

there are 2-3 variables that input into another variable A, but we have excel data for variable A, how do we feed the data and also show relationships with the other 2 variables? isn't it that if we feed data, but not include the input variables inthe equation, we will get an error?


I would really appreciate any feedback

thanks.
Administrator
Super Administrator
Posts: 4838
Joined: Wed Mar 05, 2003 3:10 am

Post by Administrator »

>> I just wanted to verify something about the excel data that we
>> input in the vensim model. If the excel column from which the
>> model reads data, has about 400 rows worth of data, which
>> values does the model show in the graph? does it take an
>> average? for that particular month?
It depends on what you are reading (column/row of data). Can you post an example of what you are trying to read?

>>there are 2-3 variables that input into another variable A, but
>>we have excel data for variable A, how do we feed the data
>>and also show relationships with the other 2 variables? isn't it
>>that if we feed data, but not include the input variables inthe
>>equation, we will get an error?
You can import the data to a VDF file and then display graphs/tables with the imported value and the calculated value.

Tony.
Post Reply