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

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

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

buildingnerd gravatar image

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

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

Comments

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

Adam Hilton gravatar image Adam Hilton  ( 2016-06-15 17:26:28 -0500 )edit

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

buildingnerd gravatar image buildingnerd  ( 2016-06-17 23:38:17 -0500 )edit

3 Answers

Sort by ยป oldest newest most voted
3

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

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
2

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

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
2

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

Chris Jones gravatar image

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

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

Comments

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

Like this :)

Adam Hilton gravatar image Adam Hilton  ( 2016-06-20 08:25:12 -0500 )edit

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

Stats

Asked: 2016-06-15 14:39:44 -0500

Seen: 444 times

Last updated: Jun 20 '16