You'll basically want to convert the angles to cardinal directions (see here for tips on how to do it), then do a COUNTIF (eg COUNTIF(ColumnOfCardinalDirection, 'NE') to get the number of hours where the wind blows from the North East), either using a formula or a pivot table. Open that in Excel, you'll get many variables including hourly Wind Speed (m/s) and Wind Direction (degrees).ĭefine what kind of wind rose you want to achieve: do you want to plot the only wind direction, or do you want to also take wind speed into account? I have a preference for the second one of course.Īssuming you just want to take the wind direction into account, you need to 'bin' the number of occurrences of a given direction, excluding cases where wind speed is zero.
Convert it to CSV using the WeatherConverter from EnergyPlus.
