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

Where can I find the max and min monthly dry bulb temperatures?

asked 2016-06-15 14:39:44 -0600

buildingnerd's avatar

updated 2020-01-20 12:13:02 -0600

The HVAC Loads Profile in the results tab gives the monthly Average Outdoor Dry Bulb Temperature. Where can I find the monthly maximum and minimum outdoor dry bulb temperatures? Thanks!

edit retag flag offensive close merge delete


Are you looking for a solution other than opening the weather file in excel or something and performing a statistical analysis there?

Adam Hilton's avatar Adam Hilton  ( 2016-06-15 17:26:28 -0600 )edit

I think excel would work fine but how do I open the EPW in excel?

buildingnerd's avatar buildingnerd  ( 2016-06-17 23:38:17 -0600 )edit

3 Answers

Sort by ยป oldest newest most voted

answered 2016-06-20 11:00:46 -0600

A great resource for looking at and even editing EPW files is Elements. If you open your EPW file in Elements, you can click on the Dry Bulb Temperature column and then the Normalize by Month button above it. You can then change the Scaling Method to Scale by Minimum/Maximum and it while show you the Current Min and Current Max temperature for each month.

edit flag offensive delete link more

answered 2016-06-20 08:14:21 -0600

Chris Jones's avatar

updated 2016-06-20 08:15:06 -0600

Open the EPW file in your favorite text editor - one that doesn't wrap lines after a certain column. I use Ultraedit. The top part of the file is header information. Copy the rows below that header information - starting at row 9 right to the bottom of the file. Copy that data into an Excel sheet, use Text to Columns with the delimiter set to comma. The 6th column is drybulb. Use an excel array formula to get the min and max for each month. On a second sheet, enter 1,2,3,4,.. for each month in a column. Then enter the min and max formulas beside the month number. In the example I just created: {=MIN(IF(Sheet1!$C$3:$C$8762=Sheet2!$B4,Sheet1!$H$3:$H$8762))}. For array formulas, type the formula then use Ctrl-Shift-Enter to specify an array formula. Note, in my example, the weather data starts in Row 3, Column B - adjust the formulas depending on where you paste the data from the EPW file.

I don't know why some of the items get bolded in my answer.

edit flag offensive delete link more


I think excel would work fine but how do I open the EPW in excel?

Like this :)

Adam Hilton's avatar Adam Hilton  ( 2016-06-20 08:25:12 -0600 )edit

answered 2016-06-20 08:31:06 -0600

You can open EPW weather files in the DView application. Then simply go to the Statistics tab to view min/max for all the weather variables in the file. DView has a number of other visualization capabilities as well.

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: 2016-06-15 14:39:44 -0600

Seen: 561 times

Last updated: Jun 20 '16