<BODY onload=parent.init() contentEditable=true><P></P><FONT face=Calibri>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 115%; FONT-SIZE: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin">Jonathan,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 115%; FONT-SIZE: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin">Thanks for the information.<SPAN style="mso-spacerun: yes"> </SPAN>I am going to try again to convert the �jeddah08.bin� file to �jeddah08.ft�, make revisions, and convert it back to �jeddah08.bin� using UltraEdit.<SPAN style="mso-spacerun: yes"> </SPAN>Send me the �</SPAN><SPAN style="LINE-HEIGHT: 115%; COLOR: blue; FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin">edit to the current guide on your website</SPAN><SPAN style="LINE-HEIGHT: 115%; COLOR: black; FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-themecolor: text1">
� and I will put it in. Or, I could give you administrative privileges (you must have a Yahoo account) and you can add it.<SPAN style="mso-spacerun: yes"> </SPAN><o:p></o:p></SPAN></P>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 115%; FONT-SIZE: 12pt; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin">It would be more convenient if someone were to write a program that converts the Excel file back to �weather.bin�.<SPAN style="mso-spacerun: yes"> </SPAN>It is easier to make changes in Excel.<SPAN style="mso-spacerun: yes"> </SPAN>In the case of Jeddah weather, the AP, DB, WB, WS, etc., was changed for 8760 hours (for a higher elevation near Jeddah) with Excel programming.<SPAN style="mso-spacerun: yes"> There are other uses such checking the DOE2 model with actual energy performance data.</SPAN></SPAN></P>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 115%; COLOR: black; FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-themecolor: text1">Thanks for your interest in the website.<o:p></o:p></SPAN></P>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal><SPAN style="LINE-HEIGHT: 115%; COLOR: black; FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-themecolor: text1">Varkie</SPAN><SPAN style="LINE-HEIGHT: 115%; FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-themecolor: text1"><o:p></o:p></SPAN></P>
<P style="MARGIN: 0in 0in 10pt" class=MsoNormal></FONT></P>
<P><B>----- Original Message -----</B></P>
<P></P><B>From</B>: Jonathan Chew <jchew@twfp.com>
<P></P><B>Date</B>: Thursday, March 31, 2011 9:15 am
<P></P><B>Subject</B>: RE: [Equest-users] Editing eQuest Weather Files
<P></P>
<P></P>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011>Hi Varkie, all</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011>I have found a work around to the PKAFT issue. Varkie, as previously mentioned, I have been referring to Jeff Hirsch's eQuest weather guide, and more importantly, the elusive excel sheet that supposedly prepared the data in a much more user friendly method than all previously discussed methods. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011>Anyways, after turning a 'template' .bin file to a .ft file, I suggest it is opened with a word processing program called 'UltraEdit', instead of either notepad or Excel. In this program, you can edit columns effectively, while preserving the format of the original .bin file, unlike Excel. I have confirmed that the edited .ft file can be converted back to a (.bin) file using PKAFT, and used in eQuest without a 'End of Weather file' error. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011>As I am currently working through this myself, I can provide an edit to the current guide on your website Varkie, if you like. We can discuss further if you are interested.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011>Thank you again for all the help everyone. I'm glad this can finally move forward. </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN class=233065913-31032011></SPAN></FONT></DIV>
<DIV dir=ltr align=left></DIV>
<P></P>
<P class=8a5c92da-e305-4160-ad9c-cf07cef08a83></P>
<P class=8a5c92da-e305-4160-ad9c-cf07cef08a83><B><I><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA"></SPAN></I></B></P><SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA">
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: x-small; FONT-WEIGHT: bold">Jonathan</SPAN> <SPAN style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: x-small; FONT-WEIGHT: bold">Chew</SPAN><SPAN style="FONT-STYLE: italic; FONT-FAMILY: Arial; FONT-SIZE: x-small"></SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: Arial; FONT-SIZE: x-small">Mechanical Engineering Services</SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal></SPAN><SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA"><IMG id=IMG1 border=0 src="https://mail.iit.edu/attach.msc?sid=&mbox=INBOX&uid=23927&number=4" width=160 height=50><FONT color=#ffffff size=2 face=Arial><STRONG>The Walter Fedy Partnership<BR></STRONG></FONT></SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA">Phone: 519-576-2150 x236<BR>Fax: 519-576-5499<BR>Web: </SPAN><SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA"><A href="http://www.twfp.com/" target=1><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt">www.twfp.com</SPAN></A><o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA"></SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: gray; FONT-SIZE: 7.5pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US" lang=EN-US>The information contained in this e-mail is intended only for the individual or entity to whom it is addressed. Its contents (including any attachments) may contain confidential and/or privileged information. If you are not an intended recipient you must not use, disclose, disseminate, copy or print its contents. If you receive this e-mail in error, please notify the sender by reply e-mail and permanently delete the message. Information, opinions or conclusions contained in this message that do not relate to the official business of "The Walter Fedy Partnership" will be understood as neither given nor endorsed by it.</SPAN>
<SPAN style="FONT-FAMILY: 'Courier New'; COLOR: gray; FONT-SIZE: 9pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US" lang=EN-US><o:p></o:p></SPAN></P>
<P style="LINE-HEIGHT: normal; MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt; mso-fareast-font-family: 'Times New Roman'; mso-fareast-language: EN-CA"></SPAN></P>
<P class=8a5c92da-e305-4160-ad9c-cf07cef08a83></P>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT size=2 face=Tahoma><B>From:</B> Varkie C Thomas [mailto:thomasv@iit.edu] <BR><B>Sent:</B> Tuesday, March 29, 2011 2:31 PM<BR><B>To:</B> Jonathan Chew<BR><B>Cc:</B> R B; eQUEST Users List<BR><B>Subject:</B> Re: [Equest-users] Editing eQuest Weather Files<BR></FONT><BR></DIV>
<DIV></DIV>
<P>Someone (like Joe Huang, Jeff Hirsch) should write a program to read the Excel file and write it into a text file using the NCDC 80-column format and then convert it back to "weather.bin". It would be very useful. </P>
<P>You can order NCDC weather file (they will send you any 10 consecutive years) for about $200 and use PKAFT to convert to "weather.bin". The webpage <A href="http://bepan.info/weather" target=1><FONT color=#0000ff>http://bepan.info/weather</FONT></A> shows how to convert NCDC packed 80-column TEXT DATA to "weather.bin" and back to TEXT TABLE which can then read into EXCEL See <A href="http://bepan.info/yahoo_site_admin/assets/docs/9_-_Weather___NCDCtpe_to_DOE2bin_to_Tables-Charts.34093358.pdf" type=4 target=1><FONT color=#0000ff>9 - Weather _NCDC.tpe to DOE2.bin to Tables-Charts</FONT></A></P>
<P><STRONG><FONT color=maroon>The excel file can be saved as text file but I don't think PKAFT can convert it back to "weather.bin".</FONT></STRONG> The NCDC format has been changed. Example: the DP column in NCDC is now missing and other calculated results have been added and all the columns have been rearranged.</P>
<P>I have just added a zipped file <A href="http://bepan.info/yahoo_site_admin/assets/docs/Jeddah08.87105445.zip" type=4 target=1><STRONG><FONT color=#000000 size=4 face="Trebuchet MS"><EM>CONVERT EDITED EXCEL FILE "Weather.xls" BACK TO "Weather.bin"</EM></FONT></STRONG></A> to the website <A href="http://bepan.info/weather" target=1><FONT color=#0000ff>http://bepan.info/weather</FONT></A> showing my crazy attempt at converting the Excel file back to "weather.bin". It is 9 MB. Double click on it. It produced a "weather.bin" that was 145 KB instead of 146 KB and I get a "end of file" message. I decided not to figure out what was missing and gave up. It would be quicker and easier to write a program that does the conversion. </P>
<P>Under <A href="http://bepan.info/engg-calcs" target=1><FONT color=#0000ff>http://bepan.info/engg-calcs</FONT></A> you will find Excel psychrometric programs. </P>
<P>Varkie</P>
<P></P></BODY>