<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Every so often I receive questions about making your own custom .epw weather file from onsite weather station data. I haven't done this in a while, so others may have better methods. However, since I was typing this up anyway, I thought I'd post it.</p>
<div style="color: rgb(0, 0, 0);">
<div>
<div id="divtagdefaultwrapper" style="font-size:12pt; color:#000000; background-color:#FFFFFF; font-family:Calibri,Arial,Helvetica,sans-serif">
<p></p>
<p><br>
</p>
<p><b>Tips for making your own weather file for simulation from a weather station:</b><br>
</p>
<p>There are multiple ways to make your own weather file from a weather station, for example, you can use the EnergyPlus Weather Tool. If you're doing it by hand, here are some tips based on my experience.</p>
<p><br>
</p>
<p><br>
</p>
<p>1. Start with an .epw which is as close as possible to your custom file, then revise it with your custom data.</p>
<p><br>
</p>
<p>2. Info on what each of the columns in the weather file means can be found in the EnergyPlus user guide.</p>
<p><br>
</p>
<p>3. You must convert the timesteps. If your weather station logs every 5 mins and you're using hourly data in your simulation, you must convert the data. You'll need to decide how to deal with wind direction, which isn't so easy to average. You could use
the dominant wind direction over the hour, or consider each wind direction and speed as a vector and then mathematically combine them, etc.</p>
<p><br>
</p>
<p>4. Make sure you're not missing any data entries. If you have any blanks in the file it won't run. Out-of-range data will also cause errors. </p>
<p><br>
</p>
<p>5. If there is data that you need in the file but don't have via your weather station, you have multiple options. Here are some shortcut solutions. (Yes, I acknowledge that these shortcuts cause inaccuracies. I recommend doing a sensitivity analysis
with high and low values to see if the data really has a big impact on your simulation. If not, use the shortcut.) A. <span style="font-size:12pt">You could keep the data from the original .epw file. B. You could select some realistic value and use it
for every time step. I do not recommend this approach for solar radiation. See below.</span></p>
<p><span style="font-size:12pt"><br>
</span></p>
<p><span style="font-size:12pt">6. Unless you have a fancy weather station, y</span><span style="font-size:12pt">ou will probably need to convert from global horizontal radiance to indirect and </span><span style="font-size:12pt">direct normal </span><span style="font-size:12pt">radiance
(and possibly other variables). Multiple people have suggested equations for this based on empirical findings. Each empirical formula has its own inaccuracies. I'd recommend picking one that was created based on research in a climate similar to yours. I've
used one from Duffy and Beckman's <i>Solar Engineering of Thermal Processes</i> 1991. </span></p>
<p><br>
</p>
<p>7. Make small changes to the file and run it often, to facility easy debugging. If you have a problem, also try running portions of the year to pinpoint the problem.</p>
<p><br>
</p>
<p>8. In case you don't know how to convert between an Excel file and .epw formats, I wrote the directions below a while back.</p>
<p><br>
</p>
<p><br>
</p>
<p>Best of luck,</p>
<p>Holly</p>
<p><br>
</p>
<pre style="white-space:pre-wrap">I'm sure there are a lot of ways to convert between .epw and excel. This is one
way that works:
1. Open your EPW as a CSV in Excel.
2. Make the desired edits, such as plugging in your weather station data.
(Even if you're not using EnergyPlus, the Auxiliary EnergyPlus Programs manual
will explain the components of the EPW file.)
3. Save the file as a CSV. I usually save only the header first, deleting the
body. Then only the body, deleting the header. Otherwise, you end up with a
lot of extra commas in the header. This method is quicker than deleting the
commas.
4. Then I open the files in Textpad or Notepad and combine the header and body
and make sure everything looks OK. Then save it. CSV or TXT format is fine.
5. Then I manually change the file name from .txt or .csv to .epw.
6. Then the EPW file works in EnergyPlus. I'm assuming it would work in other
programs as well. As long as all the values are OK I haven't had any problems
with conversions.
As an alternative, you can use the EnergyPlus Weather Tool to compile custom
data into an EPW format.
Hope this helps.
Holly</pre>
<div id="Signature">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px"><font color="#888888">
<div> </div>
<div><font color="#ff6600" face="Arial" size="1">Holly W. Samuelson, DDes, LEED, AIA</font></div>
<div><font color="#999999" face="Arial" size="1">Assistant Professor Harvard Graduate School of Design</font></div>
</font></div>
</div>
</div>
</div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Holmes, Seth <sholmes@hartford.edu><br>
<b>Sent:</b> Tuesday, July 21, 2015 11:33 AM<br>
<b>To:</b> Samuelson, Holly Wasilowski<br>
<b>Subject:</b> Weather file creation</font>
<div> </div>
</div>
<div>
<div>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Holly,</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Hope all is well with the new family. We have the pic of the twins on our fridge; well done!</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
So our department just acquired a Onset weather station (among many other tools). Of course, now I am looking to generate (or have students generate) EPW files for our use with onsite projects. I remember you running into numerous pitfalls when you were building
the GSD epw file. Any advice or resources you can recommend?</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Thanks in advance. Curious to see how our elections will turn out. </p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
-S</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Seth H. Holmes, AIA, LEED AP bd+c</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
Assistant Professor of Architecture and Sustainable Design</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">University of Hartford, Department of Architecture</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">200 Bloomfield Avenue</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">West Hartford, CT 06117</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">e: <a href="mailto:sholmes@hartford.edu" style="color:blue; text-decoration:underline">
sholmes@hartford.edu</a></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">p: 860-768-4764</span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
<span style="font-size:9.0pt">w: <a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__uhaweb.hartford.edu_architect_&d=BQMFAg&c=WO-RGvefibhHBZq3fL85hQ&r=dOsILCJrs8pyomNNLoIoX3gD8X0UrhsUOE2F0mgz5WA&m=M2B8AOr0s3vFRxFs4_kq5SNoZpc1xfBkBsXzb2kXF7Q&s=GntOrYlyNsYbIgOOGbEBUMQzNYzEpDENZmCCBGRGy4g&e=" style="color:blue; text-decoration:underline">
http://uhaweb.hartford.edu/architect/</a></span></p>
<p style="margin:0in 0in 0.0001pt; font-size:11pt; font-family:Calibri,sans-serif">
</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>