vlookup like function
Posted: Fri Jan 30, 2015 7:41 am
hi everyone!
I'm trying to do a simulation with the following structure and ran into a problem on how to do a vlookup like task.
I am trying to compute c = s(t, i) * p(t, i, j),
where c is consumption, t is temperature, i and j are time-of-year and time-of-day variables.
The s() and p() functions' values are given in a matrix: for each t (row) and i and j (colums) the value is given.
I have 1000x618 simulations for t, so I'm looking for a fast way to compute c for each t, i and j variations.
In Excel I would use vlookup functions on the matrices but cannot find a suitable function in EViews.
The data looks like the example file uploaded.
Can somebody help me, please? I would appreciate this very much!
Thanks in advance.
Best,
cselefendi
I'm trying to do a simulation with the following structure and ran into a problem on how to do a vlookup like task.
I am trying to compute c = s(t, i) * p(t, i, j),
where c is consumption, t is temperature, i and j are time-of-year and time-of-day variables.
The s() and p() functions' values are given in a matrix: for each t (row) and i and j (colums) the value is given.
I have 1000x618 simulations for t, so I'm looking for a fast way to compute c for each t, i and j variations.
In Excel I would use vlookup functions on the matrices but cannot find a suitable function in EViews.
The data looks like the example file uploaded.
Can somebody help me, please? I would appreciate this very much!
Thanks in advance.
Best,
cselefendi