AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Wind rose diagram excel3/2/2024 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.
0 Comments
Read More
Leave a Reply. |