[Equest-users] Editing eQuest Weather Files

[R B]

Another way might be to make a epw file if the directions for making that
are clearer/easier and then convert it to bin.
-Rohini

On Tue, Mar 29, 2011 at 9:17 AM, Jonathan Chew <jchew at twfp.com> wrote:

>  Hi Paul,
>
> 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.
>
> Thanks again for the feedback everyone.
>
>  ------------------------------
>  *From:* Paul Diglio [mailto:paul.diglio at sbcglobal.net]
> *Sent:* Tuesday, March 29, 2011 10:06 AM
>
> *To:* Jonathan Chew; Ashu Gupta; equest-users at lists.onebuilding.org
>  *Subject:* Re: [Equest-users] Editing eQuest Weather Files
>
>   Jonathan:
>
> I have pysch.xla on my machine because I purchased the Get Psyched! Excel
> add-in.
>
> 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.
>
> Paul Diglio
>
>
>  ------------------------------
> *From:* Jonathan Chew <jchew at twfp.com>
> *To:* Ashu Gupta <agupta at enernoc.com>; "equest-users at lists.onebuilding.org"
> <equest-users at lists.onebuilding.org>
> *Sent:* Tue, March 29, 2011 9:53:30 AM
> *Subject:* Re: [Equest-users] Editing eQuest Weather Files
>
> Hi Ashu, all,
>
> 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.
>
> Thanks again Ashu, all
>  ------------------------------
>  *From:* Ashu Gupta [mailto:agupta at enernoc.com]
> *Sent:* Monday, March 28, 2011 4:38 PM
> *To:* Jonathan Chew; equest-users at lists.onebuilding.org
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
>  Jonathan,
>
>
>
> I think attached document will help to use PKAFT.bat.
>
>
>
> Thanks!
>
> Ashu
>
>
>
> *Ashu Gupta – Project Engineer, Energy Services*
>
> *EnerNOC, Inc. | 2300 Clayton Rd., S480 | Concord, CA 94520*
>
> *m: 925.775.8254 | O: 925.826.1618*
>
> *agupta at enernoc.com | www.enernoc.com*
>
> *EnerNOC - get more from energy*
>
> ü Please consider the environment before printing this e-mail.
>
>
>
>
>
> *From:* Jonathan Chew [mailto:jchew at twfp.com]
> *Sent:* Monday, March 28, 2011 1:27 PM
> *To:* Ashu Gupta; equest-users at lists.onebuilding.org
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
>
>
> Hi Ashu, all,
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> Thanks again Ashu, all
>
>
>  ------------------------------
>
> *From:* Ashu Gupta [mailto:agupta at enernoc.com]
> *Sent:* Monday, March 28, 2011 4:11 PM
> *To:* Jonathan Chew
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
> Jonathan,
>
>
>
> 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.
>
>
>
>
> 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
>
>
>
> Thanks!
>
> Ashu
>
>
>
> *Ashu Gupta – Project Engineer, Energy Services*
>
> *EnerNOC, Inc. | 2300 Clayton Rd., S480 | Concord, CA 94520*
>
> *m: 925.775.8254 | O: 925.826.1618*
>
> *agupta at enernoc.com | www.enernoc.com*
>
> *EnerNOC - get more from energy*
>
> ü Please consider the environment before printing this e-mail.
>
>
>
>
>
> *From:* Jonathan Chew [mailto:jchew at twfp.com]
> *Sent:* Monday, March 28, 2011 11:55 AM
> *To:* Jonathan Chew; Ashu Gupta; equest-users at lists.onebuilding.org
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
>
>
> Here is previously mentioned image attachment.
>
>
>  ------------------------------
>
> *From:* Jonathan Chew
> *Sent:* Monday, March 28, 2011 2:54 PM
> *To:* 'Ashu Gupta'; equest-users at lists.onebuilding.org
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
> Hi Ashu,
>
>
>
> 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
> doe.com/download/weather site. The city is Waterloo, Ontario, Canada).
>
>
>
> What I have done up to this point is the exchange data in a pre-existing
> weather file (i.e. Seattle, Washington) 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.
>
>
>
> I understand that I need to use the PKAFT.bat program taken from
> http://doe2.com/index_Wth.html (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.
>
>
>
> Thanks again Ashu, all.
>  ------------------------------
>
> *From:* Ashu Gupta [mailto:agupta at enernoc.com]
> *Sent:* Monday, March 28, 2011 1:46 PM
> *To:* Jonathan Chew; equest-users at lists.onebuilding.org
> *Subject:* RE: [Equest-users] Editing eQuest Weather Files
>
> *Hi Jonathan,*
>
> **
>
> *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.*
>
> **
>
> *I hope it helps you.*
>
> **
>
> *Thanks!*
>
> *Ashu*
>
> **
>
> *Ashu Gupta – Project Engineer, Energy Services*
>
> *EnerNOC, Inc. | 2300 Clayton Rd., S480 | Concord, CA 94520*
>
> *m: 925.775.8254 | O: 925.826.1618*
>
> *agupta at enernoc.com | www.enernoc.com*
>
> *EnerNOC - get more from energy*
>
> *ü** Please consider the environment before printing this e-mail.***
>
> **
>
>
>
> *From:* equest-users-bounces at lists.onebuilding.org [mailto:
> equest-users-bounces at lists.onebuilding.org] *On Behalf Of *Jonathan Chew
> *Sent:* Monday, March 28, 2011 10:35 AM
> *To:* equest-users at lists.onebuilding.org
> *Subject:* [Equest-users] Editing eQuest Weather Files
>
>
>
> Hi,
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> 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?
>
>
>
> Any feedback is much appreciated.
>
>
>
> Thanks.
>
>
>
> *Jonathan* *Chew*
>
> Mechanical Engineering Services
>
> *The Walter Fedy Partnership*
>
> Phone: 519-576-2150 x236
> Fax:     519-576-5499
> Web:    www.twfp.com
>
>
>
> 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.
>
>
> 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.   ­­
>
>
>
> 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.   ­­
>
>
> 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.   ­­
>
>
> _______________________________________________
> Equest-users mailing list
> http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org
> To unsubscribe from this mailing list send  a blank message to
> EQUEST-USERS-UNSUBSCRIBE at ONEBUILDING.ORG
>
>


-- 
--------------------------------------------------------------------------------
Rohini Brahme, Ph.D. LEED AP
Building energy analysis, tool development, and training
Dallas/Fort Worth, TX
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110329/67a496b8/attachment-0002.htm>