I’ve got a weather file from the Meteorological Organization in an excel file format which is attached, here. I’m trying to convert it into .EPW file, any thoughts about a tool or descript to do it?
Thanks in advance and any help is highly appreciated.
ARDAL1.xls (1.21 MB)
I had a look at your .xls file, the weather data must be hourly data to generate an .EPW file. Thus 8760 values instead 365. I know it is not easy to find them.
However, I’m working on a new component that let you modify an existent .EPW file as you want, also just few hours or days or months of it.
This is a preview of it.
This new potential component creates a copy of Epw file automatically starting from an existing EPW file. In this case I modified dry bulb temperature from June to September, I added 5 °C to the original values.
or you can create your own values, for example here I plugged random values.
Or you can copy and paste your values from .xls column of a weather data into a panel component.
All your modified files are stored into a folder that you want.
I think should be useful a component like this. Anyway, I’ll try to finish it as soon as possible.
As Antonello mentioned unless you have the data for every hour of the year you won’t be able to create an epw weather file.
Looks like some of the stuff that you’re recently working on are very similar to what I have implemented in the new Ladybug library: https://github.com/ladybug-analysis-tools/ladybug-core/blob/master/…
One the one hand, the new development will be behind the current plugins and it’s great that you’re adding these features that are really needed. One the other hand I’m worried that we are duplicating work. It might be a good idea to get you involved in the new development as soon as possible to avoid this issue however then it will take much longer for your development to be ready to use by everyone in Grasshopper… I’m just thinking loud here. Thanks for the great work.
I’m sorry, I didn’t know your script about Epw files.
I thought and made this component yesterday night. I had this idea because of a problem that I had years ago about Epw files, writing manually some values of ENVI-Met inside it.
Anyway, I’m agree with you about the problem of too many components. if you want I can send you this component like it appears now, thus you can see if there are some good ideas to complete your code. My Python is still too young And if you need too much time to complete your code you could write a temporary component.
It works very well, I was thinking to add some others functions to read automatically the type of variable, and warnings, too. And it can edit all variables of Epw file.
The principle was to create a waterfall of these components, one for each variable edited. As you can see from this image.
In this way you can track the editing.
Let’s talk about other ideas about this issue by email, ok? Thanks!
Yalda, Mostapha and Antonello,
I just wanted to make you aware of a related project that I have been working on that also should be better coordinated with Mostapha’s efforts and I think will help with Yalda’s issue here.
The impetus for this related project is that there are thousands of weather file stations in the world that are producing publicly-available hourly data but have either not been running long enough to generate EPW files, have a few hours where there are gaps in the data, or are not keeping detailed radiation records that are required to produce EPW files. A full map of these weather stations (and links to order/download their data) can be found on the National Climatic Data Center (NCDC) website here:
I have been working on a component that can take the hourly data downloaded from the map database above and produce an actual-year EPW file for any station on the map if you have a base EPW file for a nearby location. The main reason why I need the base EPW file is that many of these stations are not recording detailed radiation data with a pyranometer but they are often keeping detailed records of sky conditions like cloud cover and visibility (especially if they are airport weather stations). By finding the correlation between these sky conditions and radiation in the initial base EPW file, I have been hoping that I can a pretty decent estimate of radiation for the weather station that is only recording sky conditions. So far, the results look really promising but I really should quantify the percent error of this method before distributing it widely. I followed this method to create an actual-year weather file for Paris in the deadly 2003 European heat wave as you see here:
Given the opportunity to test this for another case, Yalda, I have produced an actual-year EPW file of 2015 for what I think is your site (assuming that the ARDAL you are referring to is the Ardal in Iran and not the one in Norway or India).
For some reason, the peak temperatures in the NCDC records of Ardal are coming much earlier in the day than the nearby Esfahan. I am positive that this is something reflected in the NCDC and the WMO’s records.
You can find the EPW file attached along with the GH file that I used to generate it and the 2015 text file that I downloaded from the map database (Shahr Kord). The the base EPW file that I used is from the US DoE database (Esfahan).
I am planning to release this component for connecting to the NCDC database with Dragonfly (the new insect that I have been working on to extend the capabilities of LB+HB). If any of you test out this workflow or have any feedback, please send it to me or post here.
Thank you for your reply.
The new component which you are working on it seems amazing! I was wondering when it will be finished. Actually, I need the epw weather file as the basic data to do analysing on my project.
Thanks for your time spending with my question and also sharing the NCDC website.
The component which you have been working on would be great! Just let us know when is it released?
Regarding my case location, you got it right, Ardal County at Chaharmahal Bakhtyari Province is in Iran. The only base EPW file you can find is from Esfahan where has the common border with Chahrmahal.
Also, I’ve received the Total Solar Radiation(TSR) file as well, which is attached, here. Could this file helpful?
May you please let me know how I can access to the EPW file that you have produced for my site?
TSR- Ardal.xls (149 KB)
Somehow, I must have forgotten to attach the EPW file 3 months ago. You can find it attached this time. The components are released as a beta and you can download them from the Dragonfly github:
You can also find them in the example file attached.
NCDC_AMY_Creator4.gh (393 KB)
IRN_Esfahan.408000_ITMYAMY.epw (1.91 MB)
Thanks for the EPW file. The components also are amazing!