Lookup or time series for data input
Posted: Tue Apr 17, 2018 2:52 pm
Hi,
I am having some issues trying to integrate data in Ventity. I have weather data in hourly values for a single year, i.e. 24*365 = 8760 data points, that I need to use in my model, repeatedly over several years, such that the value on, for instance, January 3rd, 4pm, will always be the same data point.
My initial idea was to do this via a lookup function specified via an excel sheet, using Modulo(Model.Time,8760) as input and the hourly values as output. This works to a certain extent, but since Ventity external data input files require the entire lookup function to be contained in a single cell, only about a fifth of the sequence fits (Excel has a character limit per cell of 32767).
The second idea was to input the data as Time Series data and use a Data Entity to access the values, however, there is no way to "repeat" the values once the first year is over, as far as I have been able to figure out.
Is there a functionality or workaround in Ventity that could solve my problem? I know that in Vensim it is possible to specify Lookup functions in Excel in a different format, where each row would be a new data point. This made it easy to access this type of longer data sets.
I am having some issues trying to integrate data in Ventity. I have weather data in hourly values for a single year, i.e. 24*365 = 8760 data points, that I need to use in my model, repeatedly over several years, such that the value on, for instance, January 3rd, 4pm, will always be the same data point.
My initial idea was to do this via a lookup function specified via an excel sheet, using Modulo(Model.Time,8760) as input and the hourly values as output. This works to a certain extent, but since Ventity external data input files require the entire lookup function to be contained in a single cell, only about a fifth of the sequence fits (Excel has a character limit per cell of 32767).
The second idea was to input the data as Time Series data and use a Data Entity to access the values, however, there is no way to "repeat" the values once the first year is over, as far as I have been able to figure out.
Is there a functionality or workaround in Ventity that could solve my problem? I know that in Vensim it is possible to specify Lookup functions in Excel in a different format, where each row would be a new data point. This made it easy to access this type of longer data sets.