<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.6058" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>Hi Leo,Ben,</DIV>
<DIV> </DIV>
<DIV>I have created this macro to construct the .tmy2 file from your own data in excel. Long time since I used it, but if I remember right I used the tmy to excel converter to create the template, then after filling the columns with your data, run the macro and bobs your uncle.</DIV>
<DIV>Hope you can figure this out. </DIV>
<DIV>Cheers</DIV>
<DIV>John</DIV>
<DIV> </DIV>
<DIV>
<DIV><U><FONT face=Arial> </FONT></U></DIV>
<DIV><FONT face=Arial>John Macbeth</FONT></DIV>
<DIV><FONT face=Arial>PhD Student</FONT></DIV>
<DIV><FONT face=Arial>Greenspace Research</FONT></DIV>
<DIV><FONT face=Arial>UHI Millenium Institute</FONT></DIV>
<DIV><FONT face=Arial>Lews Castle College</FONT></DIV>
<DIV><FONT face=Arial>Stornoway</FONT></DIV>
<DIV><FONT face=Arial>Isle of Lewis</FONT></DIV>
<DIV><FONT face=Arial>HS2 0XR</FONT></DIV>
<DIV><FONT face=Arial>Scotland</FONT></DIV>
<DIV><FONT face=Arial>UK</FONT></DIV>
<DIV><A href="mailto:John.Macbeth@lews.uhi.ac.uk"><FONT face=Arial></FONT></A> </DIV>
<DIV><FONT face=Arial>01851 770324</FONT></DIV><BR><BR>>>> Ben Elliston <bje@air.net.au> 4/7/2011 1:34 pm >>><BR>Hi Leo,<BR><BR>> Does anyone know, which is the easiest way to create a *.tm2 or<BR>> *.tmy file out of a *.dat??<BR><BR>That depends on what's in a .dat file :-). What is it?<BR><BR>There is documentation for the TMY2 file format here:<BR> <A href="http://rredc.nrel.gov/solar/pubs/tmy2/tmy2_index.html">http://rredc.nrel.gov/solar/pubs/tmy2/tmy2_index.html</A><BR><BR>Cheers, Ben<BR>_______________________________________________<BR>TRNSYS-users mailing list<BR>TRNSYS-users@cae.wisc.edu<BR><A href="https://mailman.cae.wisc.edu/listinfo/trnsys">https://mailman.cae.wisc.edu/listinfo/trnsys</A>-users<BR></DIV></BODY></HTML>