<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns:o =
"urn:schemas-microsoft-com:office:office"><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff size=2>I've
got one too...you don't need anything!</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff size=2>Open
the EnergyPlus weather files in excel, they are already CSV. There should
be a description of the header in the documentation.</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2>Alternatively, you can import your own TMY2 in excel by opening it or
importing it, and then use text functions to extract the data you want out of
the one column with all of the data according to the NREL TMY user's
manual. Google should find that for you if you need
it.</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2>Lastly, each of the EnergyPlus files has a stat summary which may cover
much of the information you need without doing anything in excel at all.
If you need these in excel, "text to columns" will be your best
friend.</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff size=2>Good
luck!</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=735555822-20092004><FONT face=Arial color=#0000ff
size=2>David</FONT></SPAN></DIV>
<DIV><SPAN class=735555822-20092004>
<DIV dir=ltr align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial
size=2>--------------------------------------------------------------</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>David S. Eldridge, Jr.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Project Engineer</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>LEED v2.0 Accredited
Professional</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Grumman/Butkus Associates</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>820 Davis St., Suite 300</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Evanston, IL 60201</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>847.328.3555 ext. 224</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="mailto:dse@grummanbutkus.com">dse@grummanbutkus.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial
size=2>-------------------------------------------------------------</FONT></DIV></SPAN></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Ketterer, Al
[mailto:Al.Ketterer@benham.com] <BR><B>Sent:</B> Monday, September 20, 2004
4:42 PM<BR><B>To:</B> BLDG-SIM@GARD.COM<BR><B>Cc:</B> Meyer,
Duane<BR><B>Subject:</B> [BLDG-SIM] TMY/TMY2 Converstion Utility
Program<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=934133821-20092004>Does anyone know
where we could obtain a conversion utility program to convert weather
information from a TMY or TMY2 file into an excel spreadsheet? Preference
would be for freeware or shareware application.
Thanks.</SPAN></FONT></DIV></BLOCKQUOTE><PRE>
===========================
You received this e-mail because you are subscribed
to the BLDG-SIM@GARD.COM mailing list. To unsubscribe
from this mailing list send a blank message to
BLDG-SIM-UNSUBSCRIBE@GARD.COM
</PRE></BODY></HTML>