FogWind Excel template for wind roses used in "Análisis de la variabilidad espacial de la captación pasiva de agua de niebla…" (Estrela et al., 2010)

This Zenodo record provides an Excel template used to compute and automatically plot wind roses (including the calms fraction) that was applied in the preparation of the chapter:

Estrela, M.J., Valiente, J.A., Corell, D., Azorín, C. (2010). Análisis de la variabilidad espacial de la captación pasiva de agua de niebla en relación a la estacionalidad y a los patrones de viento en una región mediterránea (Comunidad Valenciana). Publicaciones de la Asociación Española de Climatología (AEC), Serie A, nº 7.

The file (plantilla_fogwind.xls) includes a worksheet named windrose where wind observations must be pasted into:

• Column A: wind speed (VEL, km/h)
• Column B: wind direction (DIR, degrees)

Key features:

• Automatic filtering of blank entries prior to tabulation.
• Wind-speed classes based on the Beaufort scale.
• Predefined direction bins (0-360°) and speed intervals.
• Maximum capacity of 8,760 records (one year of hourly data).
• Automatic computation of the calms category (very low wind speeds) and its percentage.
• Automatic generation of the wind-rose chart (directional frequency by speed class), consistent with the plots used in the related publication.