no data found

[Fio]

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

[LAUJJL]

Hi

Can you post the model and the excel file? It will be easier to see what is wrong.
Regards.
JJ

[Fio]

here is the model and the excel file.
thank you

[Edited on 11-24-2008 by Fio]

[Fio]

and the excel file

[Edited on 11-24-2008 by Fio]

[Administrator]

You have the equations set up to read time from row 1, when time is actually on row 2.

eg, you have
BEVölkerungw[HHTYP11] := GET XLS DATA('BE.xls','bev2','1','B3')
you should have
BEVölkerungw[HHTYP11] := GET XLS DATA('BE.xls','bev2','2','B3')


Tony.

[Fio]

thanks a million - that helped:)

[LAUJJL]

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

[karankhosla]

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

[bob@vensim.com]

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]