Question-and-Answer Resource for the Building Energy Modeling Community
Get s tarted with the Help page
Ask Your Question

How to convert CSV/Excel weather file to ddy?

asked 2017-06-05 12:52:05 -0500

Yael gravatar image

updated 2017-10-26 13:02:28 -0500

Hi, I have an Excel format of weather file for a certain day and I would like to convert it to DDY and upload it in OpenStudio. How can this be achieved? Thanks in advance, Yael

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2017-06-05 16:31:57 -0500

updated 2017-06-06 11:22:45 -0500

It sounds like you may be confusing design condtions (.ddy file) with weather (.epw file). See the answer to this question on design conditions vs. weather, and this question for which design day conditions to use for your model.

What you probably want is the ASHRAE 2013 design day information for your site. You can download that here or here.

If you want to adjust the .ddy files, you can could calculate the 0.4%, 1%, 99%, and 99.6% percentiles in your weather file and then adjust the SizingPeriod:DesignDay objects accordingly or make your own.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer


Question Tools

1 follower


Asked: 2017-06-05 12:52:05 -0500

Seen: 332 times

Last updated: Oct 26 '17