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
Help with Excel Lookups
Questions about lookups
Hi
It would be better to ask one question at a time and join a simplistic model with the excel file to illustrate it.
Regards.
JJ
It would be better to ask one question at a time and join a simplistic model with the excel file to illustrate it.
Regards.
JJ