<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Franklin Gothic Medium";
panose-1:2 11 6 3 2 1 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma",sans-serif;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Stop asking me hard questions! It’s a Friday!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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?).
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">
</span><img width="609" height="151" style="width:6.3437in;height:1.5729in" id="Picture_x0020_3" src="cid:image007.png@01D29433.6607DD00"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">These inputs can become very important if you are trying to set up user defaults for, say, the 2<sup>nd</sup> or 3<sup>rd</sup> plug load entries. Study the doe2 defaults
expressions in that area for further reference material. That’s how the 3<sup>rd</sup> inputs know to be “n/a” before you entered at least the 1<sup>st</sup> and 2<sup>nd</sup> entries for a given field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">~Nick<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#3A7A46"><img width="726" height="9" style="width:7.5625in;height:.0937in" id="_x0000_i1034" src="cid:image001.png@01D29433.07EAFF90"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#3A7A46"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="724" style="width:543.0pt;border-collapse:collapse">
<tbody>
<tr>
<td width="230" valign="top" style="width:172.3pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Senior Energy Engineer</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Regional Energy Engineering Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Energy and Sustainability Services</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Schneider Electric</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="291" valign="top" style="width:218.3pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">D </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">913.564.6361
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">M </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">785.410.3317
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">F </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">913.564.6380</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">E </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:nicholas.caton@schneider-electric.com"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">nicholas.caton@schneider-electric.com</span></a><o:p></o:p></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">15200 Santa Fe Trail Drive<br>
Suite 204<br>
Lenexa, KS 66219<br>
United States</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:4.0pt">
<td width="724" colspan="3" valign="top" style="width:543.0pt;padding:0in 0in 0in 0in;height:4.0pt">
<p class="MsoNormal" style="mso-line-height-alt:4.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="_x0000_i1033" src="cid:image002.png@01D29433.07EAFF90"><!--[if gte mso 9]><xml>
<o:OLEObject Type="Embed" ProgID="PBrush" ShapeID="_x0000_i1033" DrawAspect="Content" ObjectID="_1550068075">
</o:OLEObject>
</xml><![endif]--><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Bishop, Bill [mailto:bbishop@pathfinder-ea.com]
<br>
<b>Sent:</b> Friday, March 03, 2017 3:14 PM<br>
<b>To:</b> Nicholas Caton <Nicholas.Caton@schneider-electric.com>; Chris Jones <Christopher.Jones@RWDI.com>; Michael Campbell <mcamp1206@gmail.com><br>
<b>Cc:</b> equest-users@onebuilding.org<br>
<b>Subject:</b> RE: [Equest-users] User-Defined Default Expressions<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Nick,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Where did you find that little gem of BDL?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">~Bill<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Nicholas Caton [<a href="mailto:Nicholas.Caton@schneider-electric.com">mailto:Nicholas.Caton@schneider-electric.com</a>]
<br>
<b>Sent:</b> Friday, March 03, 2017 4:04 PM<br>
<b>To:</b> Bishop, Bill <<a href="mailto:bbishop@pathfinder-ea.com">bbishop@pathfinder-ea.com</a>>; Chris Jones <<a href="mailto:Christopher.Jones@RWDI.com">Christopher.Jones@RWDI.com</a>>; Michael Campbell <<a href="mailto:mcamp1206@gmail.com">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org">equest-users@onebuilding.org</a><br>
<b>Subject:</b> RE: [Equest-users] User-Defined Default Expressions<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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 2<sup>nd</sup> set of 4 characters (or the 3<sup>rd</sup> set, or the 4<sup>th</sup> set…).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">To do this, append the optional argument “,#” wherever you’d normally specify “C-ACTIVITY-DESC.”
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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: <o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Retail_–_Best Buy<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Retail_–_Home Depot<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">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
<span style="background:yellow;mso-highlight:yellow">highlighted</span> the new addition:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> AREA/PERSON =
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D">{if(#SV(#L("ZONE-TYPE"))==2) then no_def else<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> if(#RV(#L("PEOPLE-SCHEDULE"))!=0) then unused else<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> switch (#L("C-ACTIVITY-DESC"))<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> case "Reta":
<span style="background:yellow;mso-highlight:yellow">switch (#L("C-ACTIVITY-DESC",2))<o:p></o:p></span></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D;background:yellow;mso-highlight:yellow"> case “_Bes” : 67<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D;background:yellow;mso-highlight:yellow"> case “_Hom” : 67*2<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D;background:yellow;mso-highlight:yellow"> default : 500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D;background:yellow;mso-highlight:yellow"> endswitch</span><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> case "Lobb": 150<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> case "Clas": 100<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> default: 500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> endswitch<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D"> endif<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1F497D">endif}<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">~Nick<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#3A7A46"><img border="0" width="726" height="9" style="width:7.5625in;height:.0937in" id="_x0000_i1025" src="cid:image001.png@01D29433.07EAFF90"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#3A7A46"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="724" style="width:543.0pt;border-collapse:collapse">
<tbody>
<tr>
<td width="230" valign="top" style="width:172.3pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Senior Energy Engineer</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Regional Energy Engineering Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Energy and Sustainability Services</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469"> Schneider Electric</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="291" valign="top" style="width:218.3pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">D </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">913.564.6361
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">M </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">785.410.3317
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">F </span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">913.564.6380</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#57B069">E </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:nicholas.caton@schneider-electric.com"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">nicholas.caton@schneider-electric.com</span></a><o:p></o:p></span></p>
</td>
<td width="203" valign="top" style="width:152.4pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">15200 Santa Fe Trail Drive<br>
Suite 204<br>
Lenexa, KS 66219<br>
United States</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:4.0pt">
<td width="724" colspan="3" valign="top" style="width:543.0pt;padding:0in 0in 0in 0in;height:4.0pt">
<p class="MsoNormal" style="mso-line-height-alt:4.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#3A7A46"><img border="0" width="722" height="49" style="width:7.5208in;height:.5104in" id="_x0000_i1026" src="cid:image002.png@01D29433.07EAFF90"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Equest-users [<a href="mailto:equest-users-bounces@lists.onebuilding.org">mailto:equest-users-bounces@lists.onebuilding.org</a>]
<b>On Behalf Of </b>Bishop, Bill via Equest-users<br>
<b>Sent:</b> Friday, March 03, 2017 12:24 PM<br>
<b>To:</b> Chris Jones <<a href="mailto:Christopher.Jones@RWDI.com">Christopher.Jones@RWDI.com</a>>; Michael Campbell <<a href="mailto:mcamp1206@gmail.com">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org">equest-users@onebuilding.org</a><br>
<b>Subject:</b> Re: [Equest-users] User-Defined Default Expressions<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Mike,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">~Bill<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"> AREA/PERSON =
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">{if(#SV(#L("ZONE-TYPE"))==2) then no_def else<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">if(#RV(#L("PEOPLE-SCHEDULE"))!=0) then unused else<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">switch (#L("C-ACTIVITY-DESC"))<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">case "Reta": 67<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">case "Lobb": 150<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">case "Clas": 100<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">default: 500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">endswitch<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">endif<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">endif}<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Medium",sans-serif;color:black">William Bishop, PE, BEMP, BEAP, CEM, LEED AP
</span></b><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Medium",sans-serif;color:#006600">|</span></b><b><span style="font-size:10.0pt;font-family:"Franklin Gothic Medium",sans-serif;color:black"> Pathfinder Engineers & Architects LLP<o:p></o:p></span></b></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="526" style="width:394.8pt;border-collapse:collapse">
<tbody>
<tr style="height:13.45pt">
<td width="345" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:13.45pt">
<p class="MsoNormal" style="line-height:105%"><b><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">Senior Energy Engineer<o:p></o:p></span></b></p>
</td>
<td width="182" rowspan="6" style="width:136.35pt;padding:0in 5.4pt 0in 5.4pt;height:13.45pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"><img border="0" width="56" height="38" style="width:.5833in;height:.3958in" id="Picture_x0020_4" src="cid:image003.jpg@01D29433.07EAFF90">
<img border="0" width="46" height="39" style="width:.4791in;height:.4062in" id="Picture_x0020_2" src="cid:image004.jpg@01D29433.07EAFF90"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:4.55pt">
<td width="345" valign="top" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:4.55pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:5.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"><o:p> </o:p></span></p>
</td>
</tr>
<tr style="height:9.8pt">
<td width="345" nowrap="" valign="bottom" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:9.8pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D">134 South Fitzhugh Street</span><span style="font-size:9.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D">
</span><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D">Rochester, NY 14608<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:12.4pt">
<td width="345" valign="top" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:12.4pt">
<p class="MsoNormal" style="line-height:105%"><b><i><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#002060">T: (585) 698-1956</span></i></b><b><i><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#002060">
</span></i></b><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D"> </span><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:#1F497D">F: (585) 325-6005</span><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:9.8pt">
<td width="345" valign="top" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:9.8pt">
<p class="MsoNormal" style="line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:wbishop@pathfinder-ea.com"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif">bbishop@pathfinder-ea.com</span></a></span><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:black">
</span><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D"><a href="http://www.pathfinder-ea.com/"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif">www.pathfinder-ea.com</span></a><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:24.6pt">
<td width="345" valign="top" style="width:258.45pt;padding:0in 5.4pt 0in 5.4pt;height:24.6pt">
<p class="MsoNormal" style="margin-top:3.0pt;line-height:105%"><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D"><img border="0" width="34" height="32" style="width:.3541in;height:.3333in" id="Picture_x0020_5" src="cid:image005.png@01D29433.07EAFF90" alt="http://png-5.findicons.com/files/icons/977/rrze/720/globe.png"></span><span style="font-size:7.5pt;line-height:105%;font-family:"Calibri",sans-serif;color:#00B0F0">Carbon
Fee and Dividend - simple, effective, and market-based.</span><span style="font-size:11.0pt;line-height:105%;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Equest-users [<a href="mailto:equest-users-bounces@lists.onebuilding.org">mailto:equest-users-bounces@lists.onebuilding.org</a>]
<b>On Behalf Of </b>Chris Jones via Equest-users<br>
<b>Sent:</b> Friday, March 03, 2017 12:52 PM<br>
<b>To:</b> Michael Campbell <<a href="mailto:mcamp1206@gmail.com">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org">equest-users@onebuilding.org</a><br>
<b>Subject:</b> Re: [Equest-users] User-Defined Default Expressions<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">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. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Other than that, I suggest reviewing the BDLDFT.TXT file in the eQUEST 3-65 Data folder. It is full of example default expressions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></b></p>
<table class="MsoNormalTable" border="0" cellspacing="20" cellpadding="0" width="600" style="width:6.25in">
<tbody>
<tr>
<td width="70" valign="top" style="width:52.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.rwdi.com/assets/logos/RWDI-logo.gif"><span style="color:#1F497D;text-decoration:none"><img border="0" width="70" height="70" style="width:.7291in;height:.7291in" id="Picture_x0020_1" src="cid:image006.jpg@01D29433.07EAFF90" alt="Title: RWDI - Description: RWDI logo"></span></a><span style="color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="484" valign="top" style="width:363.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#005EB8">Christopher Jones, </span></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#005EB8">P.Eng.
</span></b><span style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#999999">|
</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#999999">Senior Energy Analyst</span><span style="font-family:"Arial",sans-serif;color:#1F497D"><br>
</span><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#999999">RWDI</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#999999"><br>
901 King Street West, Suite 400, Toronto, ON M5V 3H5 Canada<br>
Tel: (519) 823-1311 ext 2052<br>
<a href="http://www.rwdi.com/"><span style="color:#999999">rwdi.com</span></a></span><span style="color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif"> Equest-users [<a href="mailto:equest-users-bounces@lists.onebuilding.org">mailto:equest-users-bounces@lists.onebuilding.org</a>]
<b>On Behalf Of </b>Michael Campbell via Equest-users<br>
<b>Sent:</b> Friday, March 03, 2017 12:32 PM<br>
<b>To:</b> equest-users<br>
<b>Subject:</b> [Equest-users] User-Defined Default Expressions<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Hi eQUEST Users,<o:p></o:p></p>
</div>
<p class="MsoNormal">I'm trying to create default user expressions in an effort to auto-populate certain fields in my models.<o:p></o:p></p>
</div>
<p class="MsoNormal">I want to reference the activity description (C-ACTIVITY-DESC) have it automatically fill in fields such as Area/Person.<o:p></o:p></p>
</div>
<p class="MsoNormal">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.<o:p></o:p></p>
</div>
<p class="MsoNormal">I've tried using the "Switch" function and if-then statements but haven't been able to get it to work.<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Any assistance is appreciated.<o:p></o:p></p>
</div>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
</div>
<p class="MsoNormal">Mike Campbell<o:p></o:p></p>
</div>
<div>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:7.0pt">
<hr size="3" width="100%" align="center">
</span></div>
<p class="MsoNormal"><b><span style="font-size:7.0pt">RWDI - A Platinum Member of Canada's 50 Best Managed Companies</span></b><span style="font-size:7.0pt">
<br>
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
<a href="mailto:solutions@rwdi.com">solutions@rwdi.com</a> or call +1.519.823.1311.
<o:p></o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:7.0pt">
<hr size="3" width="100%" align="center">
</span></div>
</div>
<p class="MsoNormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________<o:p></o:p></p>
<p class="MsoNormal"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________<o:p></o:p></p>
</div>
</body>
</html>