<BODY contentEditable=true onload=parent.init()><P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">Yashika<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">Someone has to write a program that reads the Excel file and write the data into a text file that is exactly like the NCDC 80-column format.<SPAN style="mso-spacerun: yes"> </SPAN>The column arrangements in the NCDC file and Excel file (converted from the .bin file) are different.<SPAN style="mso-spacerun: yes"> </SPAN><B style="mso-bidi-font-weight: normal">The Dew Point temps column in NCDC is missing in the text file that was converted from .bin file using MKAFT </B>and therefore also in the Excel file.<SPAN style="mso-spacerun: yes"> </SPAN>The converted .bin file also includes several columns of calculated data.<SPAN style="mso-spacerun: yes"> </SPAN><o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">The “<A href="https://mail.iit.edu/attach/7_-_Customizing_eQUEST_Weather_Data.34092949.pdf?sid=&mbox=INBOX&charset=escaped_unicode&uid=24382&number=4&filename=7_-_Customizing_eQUEST_Weather_Data.34092949.pdf" target=attachment><FONT color=#0000ff>7_-_Customizing_eQUEST_Weather_Data.34092949.pdf</FONT></A>” ” in <A href="http://bepan.info/weather"><FONT color=#0000ff>http://bepan.info/weather</FONT></A> has to be fixed by the person who wrote the procedure (Jeff Hirsch?). <o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin"><SPAN style="mso-spacerun: yes"> </SPAN>Go to <A href="http://bepan.info/weather"><FONT color=#0000ff>http://bepan.info/weather</FONT></A><SPAN style="mso-spacerun: yes"> </SPAN><SPAN style="mso-spacerun: yes"> </SPAN>The procedure described in <A href="http://bepan.info/yahoo_site_admin/assets/docs/Jeddah08.87105445.zip"><STRONG><I><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #333300; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-ansi-language: EN" lang=EN></SPAN></I></STRONG></A></SPAN><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-ansi-language: EN" lang=EN></SPAN><SPAN>
<A href="http://bepan.info/yahoo_site_admin/assets/docs/NCDC-Weathertpe_to_Weatherbin_to_Weatherxls_to_Weatherbin.111140134.zip"><I><SPAN style="COLOR: black; mso-bidi-font-weight: bold; mso-ansi-language: EN" lang=EN>CONVERT EDITED EXCEL FILE "Weather.xls" BACK TO "Weather.bin<STRONG>"</STRONG></SPAN></I></A> is tedious and a waste of time.<SPAN style="mso-spacerun: yes"> </SPAN>I am going to leave it on the website because it shows the various file formats.<SPAN style="mso-spacerun: yes"> </SPAN>In the Excel file the DP temp has to be calculated for revised DB, WB, AP based on elevation.<SPAN style="mso-spacerun: yes"> </SPAN>This can be done with template <STRONG>“</STRONG></SPAN><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin"><A href="http://bepan.info/yahoo_site_admin/assets/docs/Template_Beijing-Weather-Analysis-Long.3104551.zip">
<FONT color=#0000ff>12 - Template Beijing-Weather-Analysis-Long EXCEL</FONT></A>” in <A href="http://bepan.info/weather"><FONT color=#0000ff>http://bepan.info/weather</FONT></A><o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN>In the example, the converted JEDDAH08.bin file resulted in 145 KB instead of 146 KB. <SPAN style="mso-spacerun: yes"> </SPAN>When you try to use the JEDDAH08.bin file with the DOE2 program it results in “End of File” message.<SPAN style="mso-spacerun: yes"> </SPAN>Something is missing and I am not going to waste my time looking for it.<SPAN style="mso-spacerun: yes"> </SPAN>It was a one-time effort for a project and NOT intended to be used as a routine procedure for all projects.<o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN>There are many subscribers to this blog who can write a program that reads the Excel file columns and write to a text file using the 80-column NCDC format.<SPAN style="mso-spacerun: yes"> </SPAN><o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN>Is NCDC 80-column weather data being used to create DOE2 <SPAN style="mso-spacerun: yes"> </SPAN>.bin files these days?<SPAN style="mso-spacerun: yes"> </SPAN>DOE2 users now convert EnergyPlus EPW files to .bin files.<o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><STRONG><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; FONT-WEIGHT: normal; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-ansi-language: EN; mso-bidi-font-style: italic" lang=EN>This method should work<o:p></o:p></SPAN></STRONG></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">From</SPAN></B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">: Claudia De Paula <<A href="javascript:main.compose('new','t=claudia_dp@GroupVE.co.il')" target=1><FONT color=#0000ff>claudia_dp@GroupVE.co.il</FONT></A>> <o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">Date</SPAN></B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">: Thursday, February 10, 2011 2:30 am <o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">Subject</SPAN></B><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">: RE: [Equest-users] editing weather data <o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin">> I have just done something like this. <BR>> I took an EPW file and renamed it to csv, then I could open it in <BR>> excel. (Renaming a BIN file did not work). <BR>> I changed whatever I needed to change in the csv file and saved it. <BR>> Then I renamed it to EPW again and used the weather processor to <BR>> convert it to BIN. <BR>> It worked. <BR>> <o:p></o:p></SPAN></P>
<P style="MARGIN: auto 0in" class=MsoNoSpacing><STRONG><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-ansi-language: EN; mso-bidi-font-style: italic" lang=EN>Varkie</SPAN></STRONG><STRONG><SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; FONT-WEIGHT: normal; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-theme-font: minor-latin; mso-bidi-font-weight: bold; mso-ansi-language: EN; mso-bidi-font-style: italic" lang=EN><o:p></o:p></SPAN></STRONG></P></BODY>