I have detailed wind historical data on an Excel sheet, (Speed and Direction) categorized by hour, day, month, and year, and I have imported the file into Anylogic by the builtin tool, however, I searched and I knew that in order to use the data in the Excel file I have to include the data into a Data Set, but I can’t find any field in the “Properties” of the Data set that can link the Excel sheet to this Data set, anyone can help me do that?
what I want to do is for the Anylogic to check the table (row by row for each hour of the day) and create a dynamic variable, so when the wind speed is larger than a certain number (for example 10 m/s), then this wind speed will trigger another condition.
I have tried the Anylogic help, I asked Chat GPT 3.5, but its knowledge stops at the Anylogic version of January 2022, so it’s not that recent, and I tried finding a few papers but with no luck.