Software for weather databases management and construction of reference years

The purpose of this paper is to illustrate a procedure that permits, starting from a sufficiently long database of time series, the construction of a Reference Year (RY) of hourly weather data according to the rules of ISO 15927-4 standard. In order to facilitate the management of the weather database and to allow the users to easily generate the file, an algorithm has been implemented in Microsoft Visual Basic for Application (VBA). By this way, the application of the ISO 15927-4 is possible even using a popular software tool such as Microsoft Excel or Access without any other expensive specialized software. Such tool allows to fulfil all the procedures mentioned in ISO 15927- 4 giving as …