[Equest-users] User-Defined Default Expressions - equipment schedules and loads
Bishop, Bill via Equest-users
equest-users at lists.onebuilding.org
Tue Mar 7 16:32:40 PST 2017
Michael,
Each of the 2nd, 3rd, 4th and 5th values for equipment schedules has a different DOE-2 default value based on the entry for the previous schedule. For example, default for the second schedule is, “if(#RV(#L("EQUIP-SCHEDULE",0))!=0) then unused else no_def endif”.
You can change the defaults for each of these manually in the eQUEST user interface in their respective input fields or you can combine them all into a single expression in an input file. Expanding on your example below, copy the following into a text file and do a “File -> Import File…” of the text file. Note that each value is separated by a comma, and you can use “&D” (without the quotation marks, and without brackets) for any interim value if you want to use the DOE-2 default.
Regards,
~Bill
SET-DEFAULT FOR SPACE
EQUIP-SCHEDULE = (
{$ Expression for EQUIP-SCHEDULE[0]
if(#SV(#L("ZONE-TYPE"))!=1) then no_def /* Conditioned zones only */
else switch (#L("C-ACTIVITY-DESC") + #L("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
endif},
{$ Expression for EQUIP-SCHEDULE[1]
if(#SV(#L("ZONE-TYPE"))!=1) then no_def /* Conditioned zones only */
else switch (#L("C-ACTIVITY-DESC") + #L("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
endif},
{$ Expression for EQUIP-SCHEDULE[2]
if(#SV(#L("ZONE-TYPE"))!=1) then no_def /* Conditioned zones only */
else switch (#L("C-ACTIVITY-DESC") + #L("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
endif} )
..
William Bishop, PE, BEMP, BEAP, CEM, LEED AP | Pathfinder Engineers & Architects LLP
Senior Energy Engineer
[cid:image004.jpg at 01D29779.94B65520] [cid:image005.jpg at 01D29779.94B65520]
134 South Fitzhugh Street Rochester, NY 14608
T: (585) 698-1956 F: (585) 325-6005
bbishop at pathfinder-ea.com<mailto:wbishop at pathfinder-ea.com> www.pathfinder-ea.com<http://www.pathfinder-ea.com/>
[http://png-5.findicons.com/files/icons/977/rrze/720/globe.png]Carbon Fee and Dividend - simple, effective, and market-based.
From: mccampbell04 at gmail.com [mailto:mccampbell04 at gmail.com] On Behalf Of Michael Campbell
Sent: Tuesday, March 07, 2017 2:35 PM
To: Nicholas Caton <Nicholas.Caton at schneider-electric.com>
Cc: Bishop, Bill <bbishop at pathfinder-ea.com>; Chris Jones <Christopher.Jones at rwdi.com>; equest-users at onebuilding.org; David Reddy <IMCEAEX-V at eurprd04.prod.outlook.com>
Subject: Re: [Equest-users] User-Defined Default Expressions
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<mailto: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:
[cid:image014.png at 01D29777.8193DFA0]
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
[cid:image015.png at 01D29777.8193DFA0]
Nick Caton, P.E., BEMP
Senior Energy Engineer
Regional Energy Engineering Manager
Energy and Sustainability Services
Schneider Electric
D 913.564.6361<tel:(913)%20564-6361>
M 785.410.3317<tel:(785)%20410-3317>
F 913.564.6380<tel:(913)%20564-6380>
E nicholas.caton at schneider-electric.com<mailto:nicholas.caton at schneider-electric.com>
15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219
United States
[cid:image016.png at 01D29777.8193DFA0]
From: Bishop, Bill [mailto:bbishop at pathfinder-ea.com<mailto:bbishop at pathfinder-ea.com>]
Sent: Friday, March 03, 2017 3:14 PM
To: Nicholas Caton <Nicholas.Caton at schneider-electric.com<mailto:Nicholas.Caton at schneider-electric.com>>; Chris Jones <Christopher.Jones at RWDI.com<mailto:Christopher.Jones at RWDI.com>>; Michael Campbell <mcamp1206 at gmail.com<mailto:mcamp1206 at gmail.com>>
Cc: equest-users at onebuilding.org<mailto: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]
Sent: Friday, March 03, 2017 4:04 PM
To: Bishop, Bill <bbishop at pathfinder-ea.com<mailto:bbishop at pathfinder-ea.com>>; Chris Jones <Christopher.Jones at RWDI.com<mailto:Christopher.Jones at RWDI.com>>; Michael Campbell <mcamp1206 at gmail.com<mailto:mcamp1206 at gmail.com>>
Cc: equest-users at onebuilding.org<mailto: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
[cid:image015.png at 01D29777.8193DFA0]
Nick Caton, P.E., BEMP
Senior Energy Engineer
Regional Energy Engineering Manager
Energy and Sustainability Services
Schneider Electric
D 913.564.6361<tel:(913)%20564-6361>
M 785.410.3317<tel:(785)%20410-3317>
F 913.564.6380<tel:(913)%20564-6380>
E nicholas.caton at schneider-electric.com<mailto:nicholas.caton at schneider-electric.com>
15200 Santa Fe Trail Drive
Suite 204
Lenexa, KS 66219
United States
[cid:image016.png at 01D29777.8193DFA0]
From: Equest-users [mailto: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<mailto:Christopher.Jones at RWDI.com>>; Michael Campbell <mcamp1206 at gmail.com<mailto:mcamp1206 at gmail.com>>
Cc: equest-users at onebuilding.org<mailto: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
[cid:image017.jpg at 01D29777.8193DFA0] [cid:image018.jpg at 01D29777.8193DFA0]
134 South Fitzhugh Street Rochester, NY 14608
T: (585) 698-1956<tel:(585)%20698-1956> F: (585) 325-6005<tel:(585)%20325-6005>
bbishop at pathfinder-ea.com<mailto:wbishop at pathfinder-ea.com> www.pathfinder-ea.com<http://www.pathfinder-ea.com/>
[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] On Behalf Of Chris Jones via Equest-users
Sent: Friday, March 03, 2017 12:52 PM
To: Michael Campbell <mcamp1206 at gmail.com<mailto:mcamp1206 at gmail.com>>
Cc: equest-users at onebuilding.org<mailto: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.
[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<tel:(519)%20823-1311>
rwdi.com<http://www.rwdi.com/>
From: Equest-users [mailto: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<mailto:solutions at rwdi.com> or call +1.519.823.1311<tel:(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/20170308/72add1ab/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image014.png
Type: image/png
Size: 9020 bytes
Desc: image014.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image015.png
Type: image/png
Size: 255 bytes
Desc: image015.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image016.png
Type: image/png
Size: 8477 bytes
Desc: image016.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image017.jpg
Type: image/jpeg
Size: 1240 bytes
Desc: image017.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image018.jpg
Type: image/jpeg
Size: 1309 bytes
Desc: image018.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image019.png
Type: image/png
Size: 2844 bytes
Desc: image019.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image020.jpg
Type: image/jpeg
Size: 2227 bytes
Desc: image020.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 1517 bytes
Desc: image004.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 1647 bytes
Desc: image005.jpg
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 3864 bytes
Desc: image006.png
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20170308/72add1ab/attachment-0004.png>
More information about the Equest-users
mailing list