[Equest-users] User-Defined Default Expressions
Michael Campbell via Equest-users
equest-users at lists.onebuilding.org
Tue Mar 7 11:35:13 PST 2017
Ok - I am now trying to set up default expressions to auto-populate 2nd,
3rd, 4th, and 5th values for plug loads.
I have the following which is working for inputting the plug load schedule
in EQUIP-SCHEDULE 1, but how can I specify the equipment schedule for
Equipment Load #2/3/4/5?
I've tried using the BDLDFT document as reference but was unable to get
anything to work.
EQUIP-SCHEDULE = (
{switch(Local("C-ACTIVITY-DESC",0)+Local("C-ACTIVITY-DESC",1))
case "Apartmen" : #SI("ESMFHR Unit Eqp Sched", "SPACE", "EQUIP-SCHEDULE")
default : #SI("ESMFHR Non-Res Eqp Sched", "SPACE", "EQUIP-SCHEDULE")
endswitch
} )
Thank you,
On Fri, Mar 3, 2017 at 6:41 PM, Nicholas Caton <
Nicholas.Caton at schneider-electric.com> wrote:
> Stop asking me hard questions! It’s a Friday!
>
>
>
> If I had to guess I would likely credit David Reddy & the rest of crew at
> 360 Analytics… but honestly I can’t recall (could have been you, Bill?).
>
>
>
> More constructively and to your point however, this optional argument
> however is what the doe2 reference manual is generally referring to when it
> lists “i" or “i1, i2” in its syntax / explanations of the BDL functions.
> Example:
>
>
>
>
>
> These inputs can become very important if you are trying to set up user
> defaults for, say, the 2nd or 3rd plug load entries. Study the doe2
> defaults expressions in that area for further reference material. That’s
> how the 3rd inputs know to be “n/a” before you entered at least the 1st
> and 2nd entries for a given field.
>
>
>
> ~Nick
>
>
>
> *Nick Caton, P.E., BEMP*
>
> Senior Energy Engineer
> Regional Energy Engineering Manager
>
> Energy and Sustainability Services
> Schneider Electric
>
> D 913.564.6361 <(913)%20564-6361>
> M 785.410.3317 <(785)%20410-3317>
> F 913.564.6380 <(913)%20564-6380>
> E nicholas.caton at schneider-electric.com
>
> 15200 Santa Fe Trail Drive
> Suite 204
> Lenexa, KS 66219
> United States
>
>
>
>
>
> *From:* Bishop, Bill [mailto:bbishop at pathfinder-ea.com]
> *Sent:* Friday, March 03, 2017 3:14 PM
> *To:* Nicholas Caton <Nicholas.Caton at schneider-electric.com>; Chris Jones
> <Christopher.Jones at RWDI.com>; Michael Campbell <mcamp1206 at gmail.com>
>
> *Cc:* equest-users at onebuilding.org
> *Subject:* RE: [Equest-users] User-Defined Default Expressions
>
>
>
> Nick,
>
> Where did you find that little gem of BDL?
>
> ~Bill
>
>
>
> *From:* Nicholas Caton [mailto:Nicholas.Caton at schneider-electric.com
> <Nicholas.Caton at schneider-electric.com>]
> *Sent:* Friday, March 03, 2017 4:04 PM
> *To:* Bishop, Bill <bbishop at pathfinder-ea.com>; Chris Jones <
> Christopher.Jones at RWDI.com>; Michael Campbell <mcamp1206 at gmail.com>
> *Cc:* equest-users at onebuilding.org
> *Subject:* RE: [Equest-users] User-Defined Default Expressions
>
>
>
> Appending to this, while ("C-ACTIVITY-DESC") returns the first 4
> characters by default, if you ever need to further distinguish inputs
> within spaces sharing the same/similar activity descriptors, you can also
> reference the 2nd set of 4 characters (or the 3rd set, or the 4th set…).
>
>
>
> To do this, append the optional argument “,#” wherever you’d normally
> specify “C-ACTIVITY-DESC.”
>
>
>
> To build on the running example, say you had 2 tenants to distinguish in a
> building with “Retail” space, but they had two different occupancy
> densities. You could handle that by first adding to their descriptors,
> such as follows:
>
> Retail_–_Best Buy
>
> Retail_–_Home Depot
>
>
>
> The first 4 characters for each case are the same: “RETA” (list position
> 0). The second set of 4 is “IL_–“ (list position 1). The third set is
> finally distinguishable: “_BES” and “_HOM” (list position 2).
>
>
>
> From here you could either insert an if/then statement for the “Reta”
> case, or just nest another switch statement. Added some formatting for
> clarity, but highlighted the new addition:
>
>
>
> AREA/PERSON =
>
> {if(#SV(#L("ZONE-TYPE"))==2) then no_def else
>
> if(#RV(#L("PEOPLE-SCHEDULE"))!=0) then unused else
>
> switch (#L("C-ACTIVITY-DESC"))
>
> case "Reta": switch (#L("C-ACTIVITY-DESC",2))
>
> case “_Bes” : 67
>
> case “_Hom” : 67*2
>
> default : 500
>
> endswitch
>
> case "Lobb": 150
>
> case "Clas": 100
>
> default: 500
>
> endswitch
>
> endif
>
> endif}
>
>
>
> ~Nick
>
>
>
> *Nick Caton, P.E., BEMP*
>
> Senior Energy Engineer
> Regional Energy Engineering Manager
>
> Energy and Sustainability Services
> Schneider Electric
>
> D 913.564.6361 <(913)%20564-6361>
> M 785.410.3317 <(785)%20410-3317>
> F 913.564.6380 <(913)%20564-6380>
> E nicholas.caton at schneider-electric.com
>
> 15200 Santa Fe Trail Drive
> Suite 204
> Lenexa, KS 66219
> United States
>
>
>
>
>
> *From:* Equest-users [mailto:equest-users-bounces at lists.onebuilding.org
> <equest-users-bounces at lists.onebuilding.org>] *On Behalf Of *Bishop, Bill
> via Equest-users
> *Sent:* Friday, March 03, 2017 12:24 PM
> *To:* Chris Jones <Christopher.Jones at RWDI.com>; Michael Campbell <
> mcamp1206 at gmail.com>
> *Cc:* equest-users at onebuilding.org
> *Subject:* Re: [Equest-users] User-Defined Default Expressions
>
>
>
> Mike,
>
> You can start with the expression below. Paste only the text between the
> brackets if you are pasting within the interface. If pasting into the input
> file, this would go after “SET-DEFAULT FOR SPACE”. Like Chris said, the
> case statement names should be four characters or less. However, they are
> not case sensitive, so upper/lower case doesn’t matter.
>
> ~Bill
>
>
>
> AREA/PERSON =
>
> {if(#SV(#L("ZONE-TYPE"))==2) then no_def else
>
> if(#RV(#L("PEOPLE-SCHEDULE"))!=0) then unused else
>
> switch (#L("C-ACTIVITY-DESC"))
>
> case "Reta": 67
>
> case "Lobb": 150
>
> case "Clas": 100
>
> default: 500
>
> endswitch
>
> endif
>
> endif}
>
>
>
> *William Bishop, PE, BEMP, BEAP, CEM, LEED AP **|** Pathfinder Engineers
> & Architects LLP*
>
> *Senior Energy Engineer*
>
>
>
>
>
> 134 South Fitzhugh Street Rochester, NY 14608
>
> *T: (585) 698-1956 <(585)%20698-1956>* F: (585)
> 325-6005
>
> bbishop at pathfinder-ea.com <wbishop at pathfinder-ea.com>
> www.pathfinder-ea.com
>
> [image: http://png-5.findicons.com/files/icons/977/rrze/720/globe.png]Carbon
> Fee and Dividend - simple, effective, and market-based.
>
>
>
> *From:* Equest-users [mailto:equest-users-bounces at lists.onebuilding.org
> <equest-users-bounces at lists.onebuilding.org>] *On Behalf Of *Chris Jones
> via Equest-users
> *Sent:* Friday, March 03, 2017 12:52 PM
> *To:* Michael Campbell <mcamp1206 at gmail.com>
> *Cc:* equest-users at onebuilding.org
> *Subject:* Re: [Equest-users] User-Defined Default Expressions
>
>
>
> Note, only the first 4 characters of the C-ACTIVITY-DESC field are
> recognized in user defined expressions. Therefore, if your UDF uses
> “RETAIL” as the test, it may fail because only “RETA” is used.
>
>
>
> Other than that, I suggest reviewing the BDLDFT.TXT file in the eQUEST
> 3-65 Data folder. It is full of example default expressions.
>
>
>
>
>
> [image: Title: RWDI - Description: RWDI logo]
> <http://www.rwdi.com/assets/logos/RWDI-logo.gif>
>
> *Christopher Jones, **P.Eng. *| Senior Energy Analyst
> *RWDI*
> 901 King Street West, Suite 400, Toronto, ON M5V 3H5 Canada
> Tel: (519) 823-1311 ext 2052 <(519)%20823-1311>
> rwdi.com <http://www.rwdi.com/>
>
>
>
>
>
> *From:* Equest-users [mailto:equest-users-bounces at lists.onebuilding.org
> <equest-users-bounces at lists.onebuilding.org>] *On Behalf Of *Michael
> Campbell via Equest-users
> *Sent:* Friday, March 03, 2017 12:32 PM
> *To:* equest-users
> *Subject:* [Equest-users] User-Defined Default Expressions
>
>
>
> Hi eQUEST Users,
>
> I'm trying to create default user expressions in an effort to
> auto-populate certain fields in my models.
>
> I want to reference the activity description (C-ACTIVITY-DESC) have it
> automatically fill in fields such as Area/Person.
>
> So for this example, I'm trying to make all spaces that have Activity
> Description of "RETAIL" to be populated with a Area/Person value of 67.
>
> I've tried using the "Switch" function and if-then statements but haven't
> been able to get it to work.
>
> Any assistance is appreciated.
>
> Thank you,
>
> Mike Campbell
> ------------------------------
>
> *RWDI - A Platinum Member of Canada's 50 Best Managed Companies*
> This communication is intended for the sole use of the party to whom it
> was addressed and may contain information that is privileged and/or
> confidential. Any other distribution, copying or disclosure is strictly
> prohibited. If you received this email in error, please notify us
> immediately by replying to this email and delete the message without
> retaining any hard or electronic copies of same. Outgoing emails are
> scanned for viruses, but no warranty is made to their absence in this email
> or attachments. If you require any information supplied by RWDI in a
> different format to facilitate accessibility, contact the sender of the
> email, email solutions at rwdi.com or call +1.519.823.1311 <(519)%20823-1311>.
>
> ------------------------------
>
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> ______________________________________________________________________
>
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> ______________________________________________________________________
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0005.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 9020 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0020.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 2227 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0015.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 1240 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0016.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 1309 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0017.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 2844 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0021.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 255 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0022.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 8477 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170307/1d21aeaa/attachment-0023.png>
More information about the Equest-users
mailing list