Capture single data points from a data variable
Posted: Fri Nov 03, 2017 2:35 pm
Hi,
I have a model with a data variable called profile, which is taken from an Excel using GET XLS DATA function. I want to get data point from this profile for each single year, which will be passed to another variable in the same model. In other words, for any single year, only 1 data point taken from the profile is needed.
I tried to GET DATA AT TIME but it returns constant values throughout the whole period. I also tried SAMPLE IF TRUE but, while it does capture the data point for each year, however the value of that data point is held constant for the remaining period (rather than drops to zero).
The graphs for the profile and results from GET DATA AT TIME and SAMPLE IF TRUE are attached, for reference.
Could someone point me in the right direction please? Many thanks.
WZ
I have a model with a data variable called profile, which is taken from an Excel using GET XLS DATA function. I want to get data point from this profile for each single year, which will be passed to another variable in the same model. In other words, for any single year, only 1 data point taken from the profile is needed.
I tried to GET DATA AT TIME but it returns constant values throughout the whole period. I also tried SAMPLE IF TRUE but, while it does capture the data point for each year, however the value of that data point is held constant for the remaining period (rather than drops to zero).
The graphs for the profile and results from GET DATA AT TIME and SAMPLE IF TRUE are attached, for reference.
Could someone point me in the right direction please? Many thanks.
WZ