<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 10:15:06 Thursday, 31 March 2011 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.8a5c92da-e305-4160-ad9c-cf07cef08a83 {
MARGIN: 0cm 0cm 0pt
}
LI.8a5c92da-e305-4160-ad9c-cf07cef08a83 {
MARGIN: 0cm 0cm 0pt
}
DIV.8a5c92da-e305-4160-ad9c-cf07cef08a83 {
MARGIN: 0cm 0cm 0pt
}
TABLE.8a5c92da-e305-4160-ad9c-cf07cef08a83Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="GENERATOR" content="MSHTML 8.00.6001.19019">
</head>
<body contentEditable="true" onload="parent.init()">
<p class="8a5c92da-e305-4160-ad9c-cf07cef08a83"></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">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">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">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">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-family:Arial; font-size:x-small; font-weight: bold; font-style: italic; ">Jonathan</span> <span style="font-family:Arial; font-size:x-small; font-weight: bold; font-style: italic; ">Chew</span><span style="font-family:Arial; font-size:x-small; font-style: italic; "></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="cid:image4490b2.JPG@2767f118.42a54d79" 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="_blank"><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">http://bepan.info/weather</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">
9 - Weather _NCDC.tpe to DOE2.bin to Tables-Charts</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"><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">http://bepan.info/weather</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">http://bepan.info/engg-calcs</a> you will find Excel psychrometric programs.
</p>
<p>Varkie</p>
<p> </p>
<p></p>
</body>
</html>