Hi there,
I have a problem with a GET XLS DATA expression. I set up a model and tried to simulate it. Unfortunately the model could not find my data I put in an excel file (which is stored at the same place). There are four variables which all have the same problem. They alle have 5 subscripts. The data is in form of a time series (starts at time=0, ends at time=44).
example of one
HHVQw[HHtyp11]:= GET XLS DATA('BE.xls','hhvq','1','C3')
(THE TYPE IS DATA AND equation)
I would be very glad if you could help me with that.
Thank you in advance,
Fionnuala
no data found
No data found
Hi
Can you post the model and the excel file? It will be easier to see what is wrong.
Regards.
JJ
Can you post the model and the excel file? It will be easier to see what is wrong.
Regards.
JJ
-
- Super Administrator
- Posts: 4590
- Joined: Wed Mar 05, 2003 3:10 am
No data found
Hi
Joined the model corrected as Tony mentionned.
There is still a problem, because the HHVqm is getting years data that are outside the range of years declared in the setting. You should change the data in the first row and have them in the range of 0 to 44.
Another problem. Another problem is the lack of units checking which is not professionnal!
Best regards.
JJ
Joined the model corrected as Tony mentionned.
There is still a problem, because the HHVqm is getting years data that are outside the range of years declared in the setting. You should change the data in the first row and have them in the range of 0 to 44.
Another problem. Another problem is the lack of units checking which is not professionnal!
Best regards.
JJ
- Attachments
-
- Modell_08_11_24_2.mdl
- (47.92 KiB) Downloaded 246 times
-
- Senior Member
- Posts: 107
- Joined: Wed Nov 26, 2008 6:12 am
Greetings!
I would like to drive my model with data from Excel, which is not time dependant; essentially I would like to create a cross sectional lookup of GDP index vs per capita Energy use (in say 2008). However, the data I have is presented vertically in Excel (not horizontally).
1) Would I be violoting any vensim fundamentals if I do not have time dependant lookups?
2) How mayI modify the GET XLS LOOKUPS function to read down instead of across
3) What are GET XLS DATA and CONSTANT - how are they different from LOOKUPS (I didn't really understand this from the manual)
Thank you very much!
Karan
I would like to drive my model with data from Excel, which is not time dependant; essentially I would like to create a cross sectional lookup of GDP index vs per capita Energy use (in say 2008). However, the data I have is presented vertically in Excel (not horizontally).
1) Would I be violoting any vensim fundamentals if I do not have time dependant lookups?
2) How mayI modify the GET XLS LOOKUPS function to read down instead of across
3) What are GET XLS DATA and CONSTANT - how are they different from LOOKUPS (I didn't really understand this from the manual)
Thank you very much!
Karan
-
- Senior Member
- Posts: 1107
- Joined: Wed Mar 12, 2003 2:46 pm
For this you would use a GET XLS LOOKUPS with GDP/capita in one row and energy use in another in the excel sheet. The function would be used as
energy use = energy use as a function of GDP(GDP)
where
energy use as a function of GDP is defined using GET XLS LOOKUP.
[Edited on 2008-11-27 by bob@vensim.com]
energy use = energy use as a function of GDP(GDP)
where
energy use as a function of GDP is defined using GET XLS LOOKUP.
[Edited on 2008-11-27 by bob@vensim.com]