<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    This is an interesting topic, and seems to be getting more
    discussion lately (see also [Bldg-sim] "historic weather files for
    model calibration" topic from late last year).<br>
    <br>
    There are a number of issues, besides formatting data to one of the
    DOE-2 or other weather utility formats, that should be considered. 
    I think the biggest are:<br>
    <br>
    a) Cleaning the source weather data (i.e. removing extraneous points
    and filling gaps).  Depending on the location, even NCDC weather
    data suffers from data quality issues.<br>
    b) Generating solar radiation data for the site.  If measured global
    horiz is available, estimating diffuse and subsequently DN component
    is relatively straight-forward using various correlations that have
    been developed from measured data.<br>
    <br>
    The DOE-2 and some other weather utility tools are capable of
    generating solar, but I would review the algorithms used to make
    sure they are appropriate for your site.  As many pointed out, Excel
    would be an ideal interface for creating weather files.  I tried to
    use Excel at first, and after encountering the issues described
    above, I decided to use a programming language (MATLAB) that I could
    implement all the required operations (i.e. INPUT: Raw, unprocessed
    NCDC data; OUTPUT: TMY2 format w/ solar for use with PKATPE
    utility).   <br>
    <br>
    - David <br>
    <br>
    On 3/29/2011 11:31 AM, Varkie C Thomas wrote:
    <blockquote cite="mid:fb05f35e2cac2.4d91df19@iit.edu" type="cite">
      <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 moz-do-not-send="true"
          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
          moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://bepan.info/yahoo_site_admin/assets/docs/Jeddah08.87105445.zip"
          type="4"><strong><font size="4" color="#000000"
              face="Trebuchet MS"><em>CONVERT EDITED EXCEL FILE
                "Weather.xls" BACK TO "Weather.bin"</em></font></strong></a> to
        the website <a moz-do-not-send="true"
          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 moz-do-not-send="true"
          href="http://bepan.info/engg-calcs">http://bepan.info/engg-calcs</a> you
        will find Excel psychrometric programs.  </p>
      <p>Varkie</p>
      <p> </p>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <meta http-equiv="Content-Type" content="text/html;
        charset=ISO-8859-1">
      <meta name="GENERATOR" content="MSHTML 8.00.6001.19019">
      <div dir="ltr" align="left">
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2">Hi
                  Rohini,<span class="780441117-29032011"> all,</span></font></font></font></span></div>
        <div dir="ltr" align="left"><span class="827461017-29032011"></span> </div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2">I
                  actually haven't had too much success with the .epw
                  method.<span class="780441117-29032011"> Using the
                    guide that Ashu had linked me seems quite foolproof
                    now that I have obtained the add-in (psych.xla) that
                    Paul referred me to. However, the excel template
                    that Jeff Hirsch (from DOE2) made is still missing.
                    I think if it could be found, my problem would be
                    resolved.</span></font></font></font></span></div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2"><span
                    class="780441117-29032011"></span></font></font></font></span> </div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2"><span
                    class="780441117-29032011">I will try the .epw
                    method again, but with the type of data I have
                    available, I believe the .txt to .bin method would
                    be more suitable to my needs. Again, this is
                    contingent on the fact that
                    "custom_eQuest_Weather_data.xls" can be made
                    available.
                  </span></font></font></font></span></div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2"><span
                    class="780441117-29032011"></span></font></font></font></span> </div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2"><span
                    class="780441117-29032011">Thank you all for your
                    feedback and I look forward to hearing back again
                    soon.</span></font></font></font></span></div>
        <div dir="ltr" align="left"><span class="827461017-29032011"><font
              face="Arial"><font color="#0000ff"><font size="2"><span
                    class="780441117-29032011"></span></font></font></font></span> </div>
      </div>
      <div dir="ltr" class="OutlookMessageHeader" lang="en-us"
        align="left">
        <hr tabindex="-1">
        <font size="2" face="Tahoma"><b>From:</b> R B
          [<a class="moz-txt-link-freetext" href="mailto:slv3sat@gmail.com">mailto:slv3sat@gmail.com</a>] <br>
          <b>Sent:</b> Tuesday, March 29, 2011 11:31 AM<br>
          <b>To:</b> Jonathan Chew; eQUEST Users List<br>
          <b>Subject:</b> Re: [Equest-users] Editing eQuest Weather
          Files<br>
        </font><br>
      </div>
      <div>Another way might be to make a epw file if the directions for
        making that are clearer/easier and then convert it to bin.
      </div>
      <div>-Rohini<br>
        <br>
      </div>
      <div class="gmail_quote">On Tue, Mar 29, 2011 at 9:17 AM, Jonathan
        Chew <span dir="ltr">
          <<a moz-do-not-send="true" href="mailto:jchew@twfp.com">jchew@twfp.com</a>></span>
        wrote:<br>
        <blockquote style="border-left: 1px solid rgb(204, 204, 204);
          margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"
          class="gmail_quote">
          <div>
            <div dir="ltr" align="left"><span><font size="2"
                  color="#0000ff" face="Arial">Hi Paul,</font></span></div>
            <div dir="ltr" align="left"><span></span> </div>
            <div dir="ltr" align="left"><span><font size="2"
                  color="#0000ff" face="Arial">Thanks for the quick
                  reply, as well as the link. That will be extremely
                  helpful. I am under the assumption then, that
                  psych.xla is needed to run the other excel file in
                  question, "Custom_eQuest_Weather_data.xls". Obtaining
                  this excel file would help me move forward.
                </font></span></div>
            <div dir="ltr" align="left"><span></span> </div>
            <div dir="ltr" align="left"><span><font size="2"
                  color="#0000ff" face="Arial">Thanks again for the
                  feedback everyone.</font></span></div>
            <div dir="ltr" align="left"><span></span> </div>
            <div dir="ltr" align="left">
              <hr>
            </div>
            <div dir="ltr" align="left"><font size="2" face="Tahoma"><b>From:</b>
                Paul Diglio [mailto:<a moz-do-not-send="true"
                  href="mailto:paul.diglio@sbcglobal.net"
                  target="_blank">paul.diglio@sbcglobal.net</a>]
                <br>
                <b>Sent:</b> Tuesday, March 29, 2011 10:06 AM
                <div class="im"><br>
                  <b>To:</b> Jonathan Chew; Ashu Gupta; <a
                    moz-do-not-send="true"
                    href="mailto:equest-users@lists.onebuilding.org"
                    target="_blank">
                    equest-users@lists.onebuilding.org</a><br>
                </div>
                <div>
                  <div class="h5"><b>Subject:</b> Re: [Equest-users]
                    Editing eQuest Weather Files<br>
                  </div>
                </div>
              </font><br>
            </div>
            <div>
              <div class="h5">
                <div style="font-family: times new roman,new
                  york,times,serif; font-size: 10pt;">
                  Jonathan:<br>
                  <br>
                  I have pysch.xla on my machine because I purchased the
                  Get Psyched! Excel add-in.<br>
                  <br>
                  You can download this program for a free trial from
                  KW-Engineering.  It costs $50 to purchase.  I find it
                  very useful in my investment grade audits.<br>
                  <br>
                  Paul Diglio<br>
                  <div><br>
                  </div>
                  <div style="font-family: times new roman,new
                    york,times,serif; font-size: 10pt;">
                    <br>
                    <div style="font-family: times new roman,new
                      york,times,serif; font-size: 12pt;">
                      <font size="2" face="Tahoma">
                        <hr size="1">
                        <b><span style="font-weight: bold;">From:</span></b>
                        Jonathan Chew <<a moz-do-not-send="true"
                          href="mailto:jchew@twfp.com" target="_blank">jchew@twfp.com</a>><br>
                        <b><span style="font-weight: bold;">To:</span></b>
                        Ashu Gupta <<a moz-do-not-send="true"
                          href="mailto:agupta@enernoc.com"
                          target="_blank">agupta@enernoc.com</a>>; "<a
                          moz-do-not-send="true"
                          href="mailto:equest-users@lists.onebuilding.org"
                          target="_blank">equest-users@lists.onebuilding.org</a>"
                        <<a moz-do-not-send="true"
                          href="mailto:equest-users@lists.onebuilding.org"
                          target="_blank">equest-users@lists.onebuilding.org</a>><br>
                        <b><span style="font-weight: bold;">Sent:</span></b>
                        Tue, March 29, 2011 9:53:30 AM<br>
                        <b><span style="font-weight: bold;">Subject:</span></b>
                        Re: [Equest-users] Editing eQuest Weather Files<br>
                      </font><br>
                      <div dir="ltr" align="left"><font size="2"
                          color="#0000ff" face="Arial"><span>Hi Ashu,
                            all,</span></font></div>
                      <div dir="ltr" align="left"><font size="2"
                          color="#0000ff" face="Arial"><span></span></font> </div>
                      <div dir="ltr" align="left"><font size="2"
                          color="#0000ff" face="Arial"><span>Actually,
                            thus far I have been referring to that
                            document. In it, he references a certain
                            excel file called
                            "Custom_eQuest_Weather_data.xls" and
                            "pysch.xla" (see attached). Would you know
                            where I could obtain this? Apparently it
                            performs some psychometric calculations
                            relevant to reconfiguring the file.
                          </span></font></div>
                      <div dir="ltr" align="left"><font size="2"
                          color="#0000ff" face="Arial"><span></span></font> </div>
                      <div dir="ltr" align="left"><font size="2"
                          color="#0000ff" face="Arial"><span>Thanks
                            again Ashu, all</span></font></div>
                      <div dir="ltr" align="left">
                        <hr>
                      </div>
                      <div dir="ltr" align="left"><font size="2"
                          face="Tahoma"><b>From:</b> Ashu Gupta [mailto:<a
                            moz-do-not-send="true"
                            href="mailto:agupta@enernoc.com"
                            target="_blank">agupta@enernoc.com</a>]
                          <br>
                          <b>Sent:</b> Monday, March 28, 2011 4:38 PM<br>
                          <b>To:</b> Jonathan Chew; <a
                            moz-do-not-send="true"
                            href="mailto:equest-users@lists.onebuilding.org"
                            target="_blank">
                            equest-users@lists.onebuilding.org</a><br>
                          <b>Subject:</b> RE: [Equest-users] Editing
                          eQuest Weather Files<br>
                        </font><br>
                      </div>
                      <div>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Jonathan,</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">I think attached
                            document will help to use PKAFT.bat.  </span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Thanks!</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Ashu</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <div>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">Ashu
                                Gupta – Project Engineer, Energy
                                Services</span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">EnerNOC,
                                Inc. | 2300 Clayton Rd., S480 | Concord,
                                CA 94520</span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">m: <a
                                  moz-do-not-send="true"
                                  href="tel:925.775.8254"
                                  target="_blank">
                                  925.775.8254</a> | O: <a
                                  moz-do-not-send="true"
                                  href="tel:925.826.1618"
                                  target="_blank">925.826.1618</a></span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;"><a
                                  moz-do-not-send="true"
                                  href="mailto:agupta@enernoc.com"
                                  target="_blank">agupta@enernoc.com</a>
                                |
                                <a moz-do-not-send="true"
                                  href="http://www.enernoc.com/"
                                  target="_blank">www.enernoc.com</a></span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 11pt;">EnerNOC
                                - get more from energy</span></b></p>
                          <p class="MsoNormal"><span style="font-family:
                              Webdings; color: green; font-size:
                              13.5pt;">ü</span><span style="color:
                              green; font-size: 10pt;"> Please consider
                              the environment before printing this
                              e-mail.</span><span style="color: rgb(0,
                              62, 116); font-size: 10pt;"></span></p>
                          <p class="MsoNormal"><span style="color:
                              rgb(14, 39, 120); font-size: 11pt;"></span> </p>
                        </div>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <div>
                          <div style="border-width: 1pt medium medium;
                            border-style: solid none none; border-color:
                            rgb(181, 196, 223) -moz-use-text-color
                            -moz-use-text-color; padding: 3pt 0in 0in;">
                            <p class="MsoNormal"><b><span
                                  style="font-size: 10pt;">From:</span></b><span
                                style="font-size: 10pt;"> Jonathan Chew
                                [mailto:<a moz-do-not-send="true"
                                  href="mailto:jchew@twfp.com"
                                  target="_blank">jchew@twfp.com</a>]
                                <br>
                                <b>Sent:</b> Monday, March 28, 2011 1:27
                                PM<br>
                                <b>To:</b> Ashu Gupta; <a
                                  moz-do-not-send="true"
                                  href="mailto:equest-users@lists.onebuilding.org"
                                  target="_blank">
                                  equest-users@lists.onebuilding.org</a><br>
                                <b>Subject:</b> RE: [Equest-users]
                                Editing eQuest Weather Files</span></p>
                          </div>
                        </div>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Hi Ashu, all, </span>
                        </p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Thanks again for the quick
                            reply. Yes, I am aware that there are
                            databases available. However, my issue is
                            that the client (a university) has asked to
                            provide an energy model based on local data.
                            In fact, the weather station they
                            recommended is actually the
                            on-campus station.
                          </span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Therefore, we do have to
                            provide a custom .bin weather file. As
                            previously discussed, the issue right now is
                            to format my edited weather data to work in
                            eQuest. Again, it would be the 'User
                            Selected' tab in the schematic design wizard
                            (shown in attached screenshot) that would
                            provide the weather file representing my
                            custom weather data for Waterloo, Ontario,
                            Canada.</span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Thanks again Ashu, all</span></p>
                        <p class="MsoNormal"> </p>
                        <div style="text-align: center;"
                          class="MsoNormal" align="center">
                          <hr size="2" align="center" width="100%">
                        </div>
                        <p style="margin-bottom: 12pt;"
                          class="MsoNormal"><b><span style="font-size:
                              10pt;">From:</span></b><span
                            style="font-size: 10pt;"> Ashu Gupta
                            [mailto:<a moz-do-not-send="true"
                              href="mailto:agupta@enernoc.com"
                              target="_blank">agupta@enernoc.com</a>]
                            <br>
                            <b>Sent:</b> Monday, March 28, 2011 4:11 PM<br>
                            <b>To:</b> Jonathan Chew<br>
                            <b>Subject:</b> RE: [Equest-users] Editing
                            eQuest Weather Files</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Jonathan,</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">You have to
                            download the weather files (epw file) from
                            below link in and to convert it into .bin
                            format that eQuest require. I am checking
                            the Waterloo weather file but I could not
                            found here. So, you can take the weather
                            file of nearest city which is nearly same
                            weather from the below link.</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"><span><a
                                moz-do-not-send="true"
href="http://apps1.eere.energy.gov/buildings/energyplus/cfm/weather_data3.cfm/region=4_north_and_central_america_wmo_region_4/country=3_canada/cname=CANADA"
                                target="_blank">http://apps1.eere.energy.gov/buildings/energyplus/cfm/weather_data3.cfm/region=4_north_and_central_america_wmo_region_4/country=3_canada/cname=CANADA</a></span></span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Thanks!</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;">Ashu</span></p>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <div>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">Ashu
                                Gupta – Project Engineer, Energy
                                Services</span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">EnerNOC,
                                Inc. | 2300 Clayton Rd., S480 | Concord,
                                CA 94520</span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;">m: <a
                                  moz-do-not-send="true"
                                  href="tel:925.775.8254"
                                  target="_blank">
                                  925.775.8254</a> | O: <a
                                  moz-do-not-send="true"
                                  href="tel:925.826.1618"
                                  target="_blank">925.826.1618</a></span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 10pt;"><span><a
                                    moz-do-not-send="true"
                                    href="mailto:agupta@enernoc.com"
                                    target="_blank">agupta@enernoc.com</a>
                                  |
                                  <a moz-do-not-send="true"
                                    href="http://www.enernoc.com/"
                                    target="_blank">www.enernoc.com</a></span></span></b></p>
                          <p class="MsoNormal"><b><span style="color:
                                rgb(20, 69, 114); font-size: 11pt;">EnerNOC
                                - get more from energy</span></b></p>
                          <p class="MsoNormal"><span style="font-family:
                              Webdings; color: green; font-size:
                              13.5pt;">ü</span><span style="color:
                              green; font-size: 10pt;"> Please consider
                              the environment before printing this
                              e-mail.</span><span style="color: rgb(0,
                              62, 116); font-size: 10pt;"></span></p>
                          <p class="MsoNormal"><span style="color:
                              rgb(14, 39, 120); font-size: 11pt;"></span> </p>
                        </div>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <div>
                          <div style="border-width: 1pt medium medium;
                            border-style: solid none none; border-color:
                            rgb(181, 196, 223) -moz-use-text-color
                            -moz-use-text-color; padding: 3pt 0in 0in;">
                            <p class="MsoNormal"><b><span
                                  style="font-size: 10pt;">From:</span></b><span
                                style="font-size: 10pt;"> Jonathan Chew
                                [mailto:<a moz-do-not-send="true"
                                  href="mailto:jchew@twfp.com"
                                  target="_blank">jchew@twfp.com</a>]
                                <br>
                                <b>Sent:</b> Monday, March 28, 2011
                                11:55 AM<br>
                                <b>To:</b> Jonathan Chew; Ashu Gupta; <a
                                  moz-do-not-send="true"
                                  href="mailto:equest-users@lists.onebuilding.org"
                                  target="_blank">
                                  equest-users@lists.onebuilding.org</a><br>
                                <b>Subject:</b> RE: [Equest-users]
                                Editing eQuest Weather Files</span></p>
                          </div>
                        </div>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Here is previously
                            mentioned image attachment.
                          </span></p>
                        <p class="MsoNormal"> </p>
                        <div style="text-align: center;"
                          class="MsoNormal" align="center">
                          <hr size="2" align="center" width="100%">
                        </div>
                        <p style="margin-bottom: 12pt;"
                          class="MsoNormal"><b><span style="font-size:
                              10pt;">From:</span></b><span
                            style="font-size: 10pt;"> Jonathan Chew
                            <br>
                            <b>Sent:</b> Monday, March 28, 2011 2:54 PM<br>
                            <b>To:</b> 'Ashu Gupta'; <a
                              moz-do-not-send="true"
                              href="mailto:equest-users@lists.onebuilding.org"
                              target="_blank">
                              equest-users@lists.onebuilding.org</a><br>
                            <b>Subject:</b> RE: [Equest-users] Editing
                            eQuest Weather Files</span></p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Hi Ashu,</span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Thanks for the quick
                            reply. I think my problem might have been
                            lost in translation. To help clarify, I have
                            included a screenshot. Basically, the root
                            of what I need to do is have the 'User
                            Selected' weather file be a weather file for
                            a specific city (that happens to not be in
                            the
                            <a moz-do-not-send="true"
                              href="http://doe.com/download/weather"
                              target="_blank">doe.com/download/weather</a>
                            site. The city is Waterloo, Ontario,
                            Canada).
                          </span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">What I have done up to
                            this point is the exchange data in a
                            pre-existing weather file (i.e. Seattle,
                            Washington)</span> <span style="color: blue;
                            font-size: 10pt;">with data of my own
                            (Waterloo, Ontario, Canada) using excel. The
                            problem now is to get this new weather data
                            to work inside of eQuest.
                          </span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">I understand that I need
                            to use the PKAFT.bat program taken from
                            <a moz-do-not-send="true"
                              href="http://doe2.com/index_Wth.html"
                              rel="nofollow" target="_blank"><span
                                style="font-family: 'serif'; font-size:
                                12pt;">http://doe2.com/index_Wth.html</span></a> (bottom
                            of the page). I'm not entirely sure how to
                            prepare my data to be converted using PKAFT,
                            and also, I do not know how to use PKAFT.bat
                            properly. </span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: blue;
                            font-size: 10pt;">Thanks again Ashu, all.</span></p>
                        <div style="text-align: center;"
                          class="MsoNormal" align="center">
                          <hr size="2" align="center" width="100%">
                        </div>
                        <p style="margin-bottom: 12pt;"
                          class="MsoNormal"><b><span style="font-size:
                              10pt;">From:</span></b><span
                            style="font-size: 10pt;"> Ashu Gupta
                            [mailto:<a moz-do-not-send="true"
                              href="mailto:agupta@enernoc.com"
                              target="_blank">agupta@enernoc.com</a>]
                            <br>
                            <b>Sent:</b> Monday, March 28, 2011 1:46 PM<br>
                            <b>To:</b> Jonathan Chew; <a
                              moz-do-not-send="true"
                              href="mailto:equest-users@lists.onebuilding.org"
                              target="_blank">
                              equest-users@lists.onebuilding.org</a><br>
                            <b>Subject:</b> RE: [Equest-users] Editing
                            eQuest Weather Files</span></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;">Hi
                              Jonathan,</span></i></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;"></span></i> </p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;">If you
                              are in detail mode then you have to just
                              replace your .bin weather file by old one
                              in your computer C drive and relink the
                              location of weather file in Project Data
                              tab (attached) then your weather data will
                              automatically replaced.</span></i></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;"></span></i> </p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;">I hope
                              it helps you.</span></i></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;"></span></i> </p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;">Thanks!</span></i></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;">Ashu</span></i></p>
                        <p class="MsoNormal"><i><span style="color:
                              rgb(31, 73, 125); font-size: 11pt;"></span></i> </p>
                        <div>
                          <p class="MsoNormal"><b><i><span style="color:
                                  rgb(20, 69, 114); font-size: 10pt;">Ashu
                                  Gupta – Project Engineer, Energy
                                  Services</span></i></b></p>
                          <p class="MsoNormal"><b><i><span style="color:
                                  rgb(20, 69, 114); font-size: 10pt;">EnerNOC,
                                  Inc. | 2300 Clayton Rd., S480 |
                                  Concord, CA 94520</span></i></b></p>
                          <p class="MsoNormal"><b><i><span style="color:
                                  rgb(20, 69, 114); font-size: 10pt;">m:
                                  <a moz-do-not-send="true"
                                    href="tel:925.775.8254"
                                    target="_blank">925.775.8254</a> |
                                  O: <a moz-do-not-send="true"
                                    href="tel:925.826.1618"
                                    target="_blank">
                                    925.826.1618</a></span></i></b></p>
                          <p class="MsoNormal"><b><i><span style="color:
                                  rgb(20, 69, 114); font-size: 10pt;"><span><a
                                      moz-do-not-send="true"
                                      href="mailto:agupta@enernoc.com"
                                      target="_blank">agupta@enernoc.com</a>
                                    |
                                    <a moz-do-not-send="true"
                                      href="http://www.enernoc.com/"
                                      target="_blank">www.enernoc.com</a></span></span></i></b></p>
                          <p class="MsoNormal"><b><i><span style="color:
                                  rgb(20, 69, 114); font-size: 11pt;">EnerNOC
                                  - get more from energy</span></i></b></p>
                          <p class="MsoNormal"><i><span
                                style="font-family: Webdings; color:
                                green; font-size: 13.5pt;">ü</span></i><i><span
                                style="color: green; font-size: 10pt;">
                                Please consider the environment before
                                printing this e-mail.</span></i><i><span
                                style="color: rgb(0, 62, 116);
                                font-size: 10pt;"></span></i></p>
                          <p class="MsoNormal"><i><span style="color:
                                rgb(14, 39, 120); font-size: 11pt;"></span></i> </p>
                        </div>
                        <p class="MsoNormal"><span style="color: rgb(31,
                            73, 125); font-size: 11pt;"></span> </p>
                        <div>
                          <div style="border-width: 1pt medium medium;
                            border-style: solid none none; border-color:
                            rgb(181, 196, 223) -moz-use-text-color
                            -moz-use-text-color; padding: 3pt 0in 0in;">
                            <p class="MsoNormal"><b><span
                                  style="font-size: 10pt;">From:</span></b><span
                                style="font-size: 10pt;">
                                <a moz-do-not-send="true"
                                  href="mailto:equest-users-bounces@lists.onebuilding.org"
                                  target="_blank">equest-users-bounces@lists.onebuilding.org</a>
                                [mailto:<a moz-do-not-send="true"
                                  href="mailto:equest-users-bounces@lists.onebuilding.org"
                                  target="_blank">equest-users-bounces@lists.onebuilding.org</a>]
                                <b>On Behalf Of </b>Jonathan Chew<br>
                                <b>Sent:</b> Monday, March 28, 2011
                                10:35 AM<br>
                                <b>To:</b> <a moz-do-not-send="true"
                                  href="mailto:equest-users@lists.onebuilding.org"
                                  target="_blank">equest-users@lists.onebuilding.org</a><br>
                                <b>Subject:</b> [Equest-users] Editing
                                eQuest Weather Files</span></p>
                          </div>
                        </div>
                        <p class="MsoNormal"> </p>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">Hi,</span></p>
                        </div>
                        <div>
                          <p class="MsoNormal"> </p>
                        </div>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">I'm working on a
                              calibrated energy model using eQuest. The
                              client has specified that they would like
                              weather data for this model to be taken
                              recently from a local weather station.
                            </span></p>
                        </div>
                        <div>
                          <p class="MsoNormal"> </p>
                        </div>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">I have hit somewhat of a
                              wall so far. I have managed to open an
                              existing .bin weather file in excel, and
                              replaced the existing data with that of my
                              own. However, I cannot get PKAFT.bat (from
                              DOE utilities) to work. I'm wondering if
                              anyone can point out the lines of text in
                              the PKAFT console that that I should
                              change, and how I should change them.</span></p>
                        </div>
                        <div>
                          <p class="MsoNormal"> </p>
                        </div>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">I suspect the cause is
                              this: after I edit the data in excel and
                              import the data back into notepad, the
                              spaces in the original document are not
                              preserved. Could anyone show me a better
                              why to do this?</span></p>
                        </div>
                        <div>
                          <p class="MsoNormal"> </p>
                        </div>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">Any feedback is much
                              appreciated.</span></p>
                        </div>
                        <div>
                          <p class="MsoNormal"> </p>
                        </div>
                        <div>
                          <p class="MsoNormal"><span style="color: blue;
                              font-size: 10pt;">Thanks.</span></p>
                        </div>
                        <p> </p>
                        <p class="MsoNormal"><b><i><span
                                style="font-size: 10pt;">Jonathan</span></i></b> <b><i><span
                                style="font-size: 10pt;">Chew</span></i></b></p>
                        <p class="MsoNormal"><span style="font-size:
                            10pt;">Mechanical Engineering Services</span></p>
                        <p class="MsoNormal"><span style="font-family:
                            'Courier New'; font-size: 9pt;"><img
                              moz-do-not-send="true" border="0"
                              height="50" width="160"></span><strong><span
                              style="color: white; font-size: 10pt;">The
                              Walter Fedy Partnership</span></strong></p>
                        <p class="MsoNormal"><span style="font-size:
                            10pt;">Phone: <a moz-do-not-send="true"
                              href="tel:519-576-2150" target="_blank">519-576-2150</a> x236<br>
                            Fax:     <a moz-do-not-send="true"
                              href="tel:519-576-5499" target="_blank">519-576-5499</a><br>
                            Web:    </span><span style="font-family:
                            'Courier New'; font-size: 9pt;"><a
                              moz-do-not-send="true"
                              href="http://www.twfp.com/" rel="nofollow"
                              target="_blank"><span style="font-size:
                                10pt;">www.twfp.com</span></a></span></p>
                        <p class="MsoNormal"> </p>
                        <p class="MsoNormal"><span style="color: gray;
                            font-size: 7.5pt;">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;"></span></p>
                        <p class="MsoNormal"><br>
                          <span style="color: gray; font-size: 10pt;">This
                            email and any information disclosed in
                            connection herewith, whether written or
                            oral, is the property of EnerNOC, Inc. and
                            is intended only for the person or entity to
                            which it is addressed. This email may
                            contain information that is privileged,
                            confidential or otherwise protected from
                            disclosure. Distributing or copying any
                            information contained in this email to
                            anyone other than the intended recipient is
                            strictly prohibited.</span>   ­­  
                        </p>
                        <p class="MsoNormal"><br>
                          <span style="color: gray; font-size: 10pt;">This
                            email and any information disclosed in
                            connection herewith, whether written or
                            oral, is the property of EnerNOC, Inc. and
                            is intended only for the person or entity to
                            which it is addressed. This email may
                            contain information that is privileged,
                            confidential or otherwise protected from
                            disclosure. Distributing or copying any
                            information contained in this email to
                            anyone other than the intended recipient is
                            strictly prohibited.</span>   ­­  
                        </p>
                      </div>
                      <br>
                      <span style="color: gray; font-size: 10pt;">This
                        email and any information disclosed in
                        connection herewith, whether written or oral, is
                        the property of EnerNOC, Inc. and is intended
                        only for the person or entity to which it is
                        addressed. This email may contain information
                        that is privileged, confidential or otherwise
                        protected from disclosure. Distributing or
                        copying any information contained in this email
                        to anyone other than the intended recipient is
                        strictly prohibited.</span>   ­­  
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <br>
          _______________________________________________<br>
          Equest-users mailing list<br>
          <a moz-do-not-send="true"
href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org"
            target="_blank">http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org</a><br>
          To unsubscribe from this mailing list send  a blank message to
          <a moz-do-not-send="true"
            href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG">
            EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG</a><br>
          <br>
        </blockquote>
      </div>
      <br>
      <br clear="all">
      <br>
      -- <br>
--------------------------------------------------------------------------------<br>
      Rohini Brahme, Ph.D. LEED AP<br>
      Building energy analysis, tool development, and training<br>
      Dallas/Fort Worth, TX<br>
      <br>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Equest-users mailing list
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org</a>
To unsubscribe from this mailing list send  a blank message to <a class="moz-txt-link-abbreviated" href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG">EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG</a>
</pre>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Equest-users mailing list
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org</a>
To unsubscribe from this mailing list send  a blank message to <a class="moz-txt-link-abbreviated" href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG">EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG</a>
</pre>
    </blockquote>
  </body>
</html>