Receive email notifications by changing your settings.
Click on your picture in the top right corner, go to Preferences and select your notification preferences.
Thank you for contributing to our forum!
Please keep in mind:
1. To only comment on the topic where the discussion is about. Do you have a new question or topic? Please start a new discussion.
2. Be kind to other users!

Heat Stress KNMI data - Excel calculator tool

edited February 8 in Ideas/suggestions

The Heat Stress Overlay, available in the Tygron Platform, can allow for detailed and temporal results. Although easily added, the proper configuration of it is essential. Finding, parsing, and entering the proper KNMI weather readings can be a task taking up a bit of time, but it's possible to automate the process somewhat. We've recently developed a small tool to assist with this.

https://previewsupport.tygron.com/wiki/File:Heat_stress_knmi_data_calculator.xlsx

This excel file has a "calculator" tab which assists with finding and converting the desired values.

KNMI data can still be downloaded and opened in excel as usual: https://support.tygron.com/wiki/KNMI_Weather_data

The tab with that data can then be copied into the calculator excel. The calculator tab has an input field for the name of the added tab, and an input field for the desired date. A table is then produced with all the Heat Stress Overly input values for all hours of the specified day, as well as the correctly calculated averages. These values can then be copied over into the Heat Stress Overlay's configuration wizard.

Tagged:
Sign In or Register to comment.