Help with Excel Lookups
Posted: Wed Nov 26, 2008 4:13 pm
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