The Edit/Translate Hourly Weather Data dialog can be accessed from the Tools menu and can be used to process hourly weather data. You may wish to do this for various reasons:
Note: The Rocky Mountain Institute now provides a free .epw hourly weather data editing and translation tool called Elements. Users may find this to be a more convenient way to edit epw files than the processor built into DesignBuilder. It provides a spreadsheet environment and allows individual values to be edited or ranges of data can be pasted in from an external spreadsheet program. For more information see the Big Ladder downloads page
Use this dialog to convert weather data to and from a range of file formats.
To edit/convert a file or files:
Converted files are stored in the Weather data folder. You can access these files by clicking on the Edit/Review tab.
On Input data tab you can select the name(s) of the source file (s) to be converted by checking in the checkboxes.
Use the Select all and Select none buttons for widespread changes.
Click on the Convert button to start the conversion.
On the Options tab you can select various options to be used during the conversion.
Supported formats are:
Required extensions are shown in brackets.
You can automatically correct any values that are outside the typical range for the EnergyPlus converter by checking the Fix out of range data checkbox.
You can apply the standard convention used by DesignBuilder to rename the output file. If you select this option the output file will be named using the Country_Location_Source convention.
You can make some changes in the weather data as follows.
You can fix the year to 2002. This is a recommended step for cases where you would like to view daily, hourly or sub-hourly EnergyPlus results within DesignBuilder or within the Results Viewer. The reasons for this are explained on the Add new hourly weather data page.
You can set the number of heating and/or cooling degree days or add a fixed delta to the dry-bulb outdoor air temperature values in the weather data. If you select the degree day option DesignBuilder adds or subtracts the same temperature difference to/from all dry-bulb outdoor air temperature values in the weather data so as to give the requested heating and cooling degree day values based on the supplied base temperature. The algorithm used is as follows:
For Each Hour in the weather file:
If Tdb < TDDBaseHeat Then
Tdb = Tdb - HeatAdj
Else If Tdb > TDDBaseCool Then
Tdb = Tdb - CoolAdj
where:
Tdb is the Outdoor air dry bulb temperature
TDDBaseHeat is Heating base degree day temperature
TDDBaseCool is Cooling base degree day temperature
HeatAdj is the delta T required to be subtracted to give the correct overall number of heating degree days
CoolAdj is the delta T required to be subtracted to give the correct overall number of cooling degree days
HeatAdj = 24 * (HeatDD - OldHeatDD) / HeatDDCount
CoolAdj = 24 * (CoolDD - OldCoolDD) / CoolDDCount
HeatDDCount is the number of hours in the year where Tdb < TDDBaseHeat
HeatDD is the user defined required heating degree days
OldHeatDD is the number of heating degree days in the source data
CoolDDCount is the number of hours in the year where Tdb > TDDBaseCool
CoolDD is the user defined required cooling degree days
OldCoolDD is the number of cooling degree days in the source data
You can view all files in the current hourly weather data folder on this tab. You can open any of the files for viewing/editing by clicking on the Open selected file link on the info panel or by double-clicking on it.
If you have hourly weather data in a format that is not supported by the DesignBuilder weather data translator there are 2 ways this can be used to generate an equivalent weather file in epw format.
The rest of this section provides details on the second of these methods.
To translate weather data from any format follow these instructions. Note that as a starting point you will need to have the main data required by EnergyPlus stored in a csv format file or spreadsheet. The data required is:
Direct normal radiation
If any of the above parameters are missing and you are unsure about how to derive them, you may wish to consider using the EnergyPlus custom weather translator instead which has built-functions to derive some missing parameters based on other equivalent data. e.g. Direct normal radiation can be derived based on known solar position and global and diffuse horizontal radiation.
If you do have all the required data in columns of a csv file then you are ready. The process is as follows:
Note 1: If your regional settings aren't like UK/US, you could run into a couple of problems, such as the spreadsheet program changing the DataPeriods line from 1/1, 12/31 to 01-Jan -- you'd need to hand edit that before step 7
Note 2: Be aware that specific year data is not usually deemed appropriate for Energy Analysis. See this document for more information on selecting weather data:
Drury B. Crawley. 1998. "Which Weather Data Should You Use for Energy Simulations of Commercial Buildings?" in ASHRAE Transactions, pp. 498-515, Vol. 104, Pt. 2. Atlanta: ASHRAE.