Hello everyone.
Is it possible to change the hourly dry bulb temp. of an exsited weather file? I have tried to paste it in CSV format but when I applied it in DB, it showed a format error. After that I tried to change it in Elements, however I couldn't paste a column from CSV to an exsited weather file.
Is there another way to change some data in a weather file? I would appreciate it if I can get some guide. Thanks.
I first opened a weather file I had, USA_ME_Caribou.Muni.AP.727120_TMY3 - Copy1, in Elements.
This is what the data looked like to start:
Then, I created my own timeseries data in excel:
For no particular reason, decided to set the variable to -10 deg C for the entire year. I then highlighted the entire column in elements by clicking on the header of the Dry Bulb Temperature [C] column.
Then, I went into excel, selected the -10 deg C (control+shift+down) column, and used control C + control V to paste into elements. Then, control S to save.
The new data looks like this:
Note that when changing the DBT I selected Relative Humidity, Atmospheric Pressure as my Variables to Hold Constant in the psychometric state. As a result, other variables like Dew Point Temp and Wet Bulb Temp changed in response to changing DBT. You will need to choose which variables you want to hold constant when changing the DBT based on your application.
Not sure if that will solve your formatting error, but editing data within Elements is typically a safer option because it will preserve the relationship between solar variables and psychometrics. If you decide to import to Excel as a csv and make edits manually there (see https://www.youtube.com/watch?v=JzpxQ...), be careful, because I don't think that Excel will automatically preserve the relationship between timeseries variables the way Elements does.
you can see https://bigladdersoftware.com/project... for instructions.
Hello sashadf1, thanks for ur elaborate instructions. I had done exactly what u describe before I asked this question. Though it failed at the step " and used control C + control V to paste into elements.". The Elements didn't react when I used Crtl+V or "paste" in "Edit". It would be great if u have further advice about that.
Make sure that the timeseries data is highlighted in excel before you paste into elements. When you press control C in excel, dashed lines moving clockwise should appear around the selected data. These dashed lines NEED to be around the data before you transfer to elements. Try 1. first selecting the entire column data in elements. 2. copying data in excel, then 3. pasting into elements.
Sometimes when switching between excel and elements I noticed that I would have to reselect data in excel, because I would lose the dashed lines.
Ok, I got the dash line but it still doesn't work, I guess I have to try another way to deal with it. Thank you anyway.
This is an excellent response. Thank you @sashadf1. @Frank Wang, does your Excel use a "." as the decimal separator? Unfortunately, Elements is unable to interpret a "," as the decimal separator but you can change the settings temporarily if this is your case. Otherwise, just click on one of the cells in the dry bulb column before pasting.
The standard way to do this is to use the weather converter that comes with EnergyPlus to create a "EnergyPlus CSV" file. Then, make your changes -- FYI, you should change dewpoint to missing (99.9) and relative humidity to some number (100?).
Then, use the weather converter again to change the EnergyPlus csv format to an EPW.
Linda
FIBPSA, FASHRAE http://climate.onebuilding.org - free repository of climate data for building simulation Climate.onebuilding is a FREE service not supported by any outside organization or government agency.
Thank you Linda, I have successfully changed my weather file using your way, the data catagories include Dry Bulb Temperature , Dew Point Temperature, Relative Humidity and Atmospheric Pressure.
Comments
@Frank Wang what weather file format are you trying to edit (TMY, EPW, BIN, ...) and what simulation tool are you planning on using with the custom weather file you will create?
Hello Aaron, the original format is EPW, and I want to use it in Design Builder and EnergyPlus.
@Frank Wang great, I have added more tags for this information. In the future, using multiple tags related to your question helps others know how to provide better answers.
Got it, thank you, Aaron.