<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
color:black;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang="EN-US" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black">Answer: I’m not sure that you can unpack a bin file, but you can go to NREL (or EnergyPlus?) webpages to get the original TMY, TMY2, or TMY3 data which are all editable in a spreadsheet. The EPW format is already comma separated variable, so edit away! The “native” TMY format is also editable in comma separated variable, although you’ll need to get the dictionary from NREL’s page as well to interpret the values.</span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black">Use these instructions to recompile into the eQuest *.bin format.</span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><p class="MsoNormal" style="text-indent:.5in"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"><a href="http://doe2.com/index_Wth.html">http://doe2.com/index_Wth.html</a></span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black">Question: Now that I answered one, I have a question for the group: using the EnergyPlus real-time weather utility – it seems to be not working lately? Has this site moved, or is it currently inactive?</span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black">David</span></font></p>
<p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><div><p class="MsoNormal"><u><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></u></p>
<p class="MsoNormal"><font size="1" color="black" face="Calibri"><span style="font-size:8.0pt;color:black"> </span></font></p><p class="MsoNormal"><font size="2" color="#1f497d" face="Calibri"><span style="font-size:11.0pt;color:#1F497D">David S. Eldridge, Jr., P.E., LEED AP BD+C, BEMP, HBDP</span></font></p>
<p class="MsoNormal"><b><font size="2" color="#244061" face="Calibri"><span style="font-size:11.0pt;color:#244061;font-weight:bold">Grumman/Butkus Associates</span></font></b><font size="1" color="gray"><span style="font-size:9.0pt;color:gray"></span></font></p>
<p class="MsoNormal"><u><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></u></p>
</div><p class="MsoNormal"><font size="2" color="black" face="Calibri"><span style="font-size:11.0pt;color:black"> </span></font></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt"><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:bldg-sim-bounces@lists.onebuilding.org">bldg-sim-bounces@lists.onebuilding.org</a> [mailto:<a href="mailto:bldg-sim-bounces@lists.onebuilding.org">bldg-sim-bounces@lists.onebuilding.org</a>] <b><span style="font-weight:bold">On Behalf Of </span></b>James Hansen<br>
<b><span style="font-weight:bold">Sent:</span></b> Friday, December 10, 2010 4:59 PM<br><b><span style="font-weight:bold">To:</span></b> <a href="mailto:bldg-sim@lists.onebuilding.org">bldg-sim@lists.onebuilding.org</a><br>
<b><span style="font-weight:bold">Subject:</span></b> [Bldg-sim] custom weather file</span></font></p></div></div><p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p><p class="MsoNormal">
<font size="2" face="Calibri"><span style="font-size:11.0pt">I feel like I’ve seen this question asked before, but couldn’t find it in the archives.</span></font></p><p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p>
<p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt">Does anyone know if there is a tool that can extract a TMY file (or EPW file) to excel, then allow adjustments to the excel spreadsheet, and can then recompile back to TMY or EPW or BIN?</span></font></p>
<p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p><p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt">I basically need to make a custom weather file based on a weather station.</span></font></p>
<p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p><p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt">Thanks, and sorry if this question has already been asked!</span></font></p>
<p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p><p class="MsoNormal"><b><font size="2" color="teal" face="Arial"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:teal;font-weight:bold">GHT Limited<br>
</span></font></b><b><font face="Arial"><span style="font-family:"Arial","sans-serif";font-weight:bold"><font color="black"><span style="color:black">James Hansen</span></font></span></font><font color="black"><span style="color:black">, PE, LEED AP</span></font></b></p>
<p class="MsoNormal"><b><font size="2" color="black" face="Arial"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;font-weight:bold">Senior Associate</span></font><font color="black"><span style="color:black"></span></font></b></p>
<p class="MsoNormal"><font size="1" face="Arial"><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><font color="black"><span style="color:black">1010 N. Glebe Rd, Suite 200</span></font></span></font></p>
<p class="MsoNormal"><font size="1" face="Arial"><span style="font-size:7.5pt;font-family:"Arial","sans-serif""><font color="black"><span style="color:black">Arlington</span></font><font color="black"><span style="color:black">, </span></font><font color="black"><span style="color:black">VA</span></font><font color="black"><span style="color:black"> </span></font><font color="black"><span style="color:black">22201-4749</span></font></span></font><font color="black"><span style="color:black"></span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Arial"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:black">703-338-5754 (Cell)</span></font><font color="black"><span style="color:black"></span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Arial"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:black">703-243-1200 (Office)</span></font><font color="black"><span style="color:black"></span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Arial"><span style="font-size:7.5pt;font-family:"Arial","sans-serif";color:black">703-276-1376 (Fax)</span></font><font color="black"><span style="color:black"></span></font></p>
<p class="MsoNormal"><font size="2" color="teal" face="Arial"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:teal"><a href="http://www.ghtltd.com/"><font size="2"><span style="font-size:10.0pt">www.ghtltd.com</span></font></a></span></font></p>
<p class="MsoNormal"><b><font size="2" color="#31849b" face="Calibri"><span style="font-size:11.0pt;color:#31849B;font-weight:bold"> </span></font></b></p><p class="MsoNormal"><font size="2" face="Calibri"><span style="font-size:11.0pt"> </span></font></p>
</div></div></body></html>