<div dir="ltr">This information is extremely helpful.<div><br></div><div>Thank you everyone for the help on this!</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Mar 6, 2017 at 6:06 PM, Nicholas Caton <span dir="ltr"><<a href="mailto:Nicholas.Caton@schneider-electric.com" target="_blank">Nicholas.Caton@schneider-electric.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="EN-US" link="blue" vlink="purple">
<div class="m_-4697762119373232483WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">I got you buddy!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Building on what Aaron just taught me/us for stringing together 8+ descriptor characters as well:<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">switch(#L("C-ACTIVITY-DESC",0) + #L("C-ACTIVITY-DESC",1))<u></u><u></u></span></p>
</span><p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">  case "office": #SI("Office Ltg Sch","SPACE","LIGHTING-<wbr>SCHEDUL")<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">  case "kitchen": #SI("Kitchen Ltg Sch","SPACE","LIGHTING-<wbr>SCHEDUL")<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">  case "restroom": #SI("Restroom Ltg Sch","SPACE","LIGHTING-<wbr>SCHEDUL")<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">  default: no_def<u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in"><span style="font-size:11.0pt;font-family:Consolas">endswitch<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Coolest thread ever?  Maybe!<u></u><u></u></span></p><span class="">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">~Nick<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<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="m_-4697762119373232483Picture_x0020_1" src="cid:image001.png@01D29699.2E8CAE60"><u></u><u></u></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"><u></u><u></u></span></p>
<table class="m_-4697762119373232483MsoNormalTable" 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<u></u><u></u></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"><u></u><u></u></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"><a href="tel:(913)%20564-6361" value="+19135646361" target="_blank">913.564.6361</a>
</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"><a href="tel:(785)%20410-3317" value="+17854103317" target="_blank">785.410.3317</a>
</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"><a href="tel:(913)%20564-6380" value="+19135646380" target="_blank">913.564.6380</a></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" target="_blank"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">nicholas.caton@schneider-<wbr>electric.com</span></a><u></u><u></u></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"><u></u><u></u></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"><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="m_-4697762119373232483_x0000_i1033" src="cid:image002.png@01D29699.2E8CAE60"><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
</span><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 [mailto:<a href="mailto:equest-users-bounces@lists.onebuilding.org" target="_blank">equest-users-bounces@<wbr>lists.onebuilding.org</a>]
<b>On Behalf Of </b>Michael Campbell via Equest-users<br>
<b>Sent:</b> Monday, March 06, 2017 2:53 PM<br>
<b>To:</b> Aaron Powers <<a href="mailto:caaronpowers@gmail.com" target="_blank">caaronpowers@gmail.com</a>><br>
<b>Cc:</b> equest-users <<a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.<wbr>onebuilding.org</a>></span></p><div><div class="h5"><br>
<b>Subject:</b> Re: [Equest-users] User-Defined Default Expressions<u></u><u></u></div></div><p></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Has anyone had any luck creating default user expressions for schedules?<u></u><u></u></p>
</div>
<p class="MsoNormal">I was able to get it to work for other fields but when trying to use the Switch function for schedules I am getting errors.<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">Any advice?<u></u><u></u></p>
</div>
<p class="MsoNormal">Thank you,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Sun, Mar 5, 2017 at 10:25 PM, Aaron Powers via Equest-users <<a href="mailto:equest-users@lists.onebuilding.org" target="_blank">equest-users@lists.<wbr>onebuilding.org</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<div>
<div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">To expand on Nick's trick below, I wanted to share why only the 1st 4 characters are returned by default and why
 his code works (this is mostly a guess from reverse-engineering the source code, but it's consistent with the way the actual program works).</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Old versions of Fortran had no built-in character or string data types, so programmers had to use tricks to deal
 with them.  This would have been true of the dialect of Fortran used in the original DOE2.1A, and so a form of the original technique used to deal with string literals persists in the code today.  As a warning, this next part may give the mechanical engineers
 out there a headache...  A single character is traditionally encoded in ASCII using a single byte.  A byte is 8 bits, and the largest 8 bit number is 11111111 = 255, so you can encode 256 unique characters using a single byte.  As an example, the btye 01100001
 = 97 represents the character 'a' in ASCII.  The smallest built-in data type in early Fortran was the integer (or float) which is encoded using 4 bytes.  The trick used in DOE2 is to encode string literals as an array of 8 integers (or float), and since each
 integer contains 4 bytes (i.e. 4 characters), the entire string array represents a total of 8x4 = 32 characters.  This is why there's a 32 character limit on string fields.  So accessing the first element of this array by #L("C-ACTIVITY-DESC") or #L("C-ACTIVITY-DESC",0)
 returns the first 4 characters, #L("C-ACTIVITY-<wbr>DESC",1) returns the second 4 characters, and so on.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Now a little further into the weeds (this is more speculation into how it could be done rather than how it's actually
 done under the DOE2 hood).  Consider the string 'abcd'.  This can be encoded into a single integer by making the four bytes of the integer be the same as the 4 character's ASCII representation in sequence together.  So the first byte is 97(01100001), the second
 98(01100010), the third 99(01100011), and the fourth 100(01100100).  Also, in Fortran, integers are encoded in little-endian style which just means that we need to order the bytes in reverse order when constructing the integer.  The entire integer in binary
 form is then <wbr>011001000110001101100010011000<wbr>01.   The value of this integer in decimal is 1684234849.  So, in DOE2-Land, the number 1684234849 is equivalent to 'abcd'.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">However, it appears that you can't access the integer representation of these four character 'words' in keyword expressions. 
 For example:</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">if ("abcd" == 1684234849) then ... produces an error.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Also, you can't do arithmetic with the integer representation.  Interestingly though, the '+' operator functions
 as a concatenate operator when dealing with string literals.  This can be used to compare the first 4, 8, 12, ... characters of a string.  For example, try the following code for the lighting power density of a space.  This expression considers the first 8
 characters when checking the C-ACTIVITY-DESC field.  This could be expanded to check all 32 characters, although the code would get a little bloated.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">switch(#L("C-ACTIVITY-DESC",0) + #L("C-ACTIVITY-DESC",1))</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">  case "office": 1.1</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">  case "kitchen": 1.5</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">  case "restroom": 0.7</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">  default: 1.0</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">endswitch</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">In this code, the result when C-ACTIVITY-DESC = "office" is 1.1, but the result when C-ACTIVITY-DESC = "office1"
 is 1.0.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Aaron</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
<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 [mailto:<a href="mailto:Nicholas.Caton@schneider-electric.com" target="_blank">Nicholas.Caton@<wbr>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" target="_blank">bbishop@pathfinder-ea.com</a>>; Chris Jones <<a href="mailto:Christopher.Jones@RWDI.com" target="_blank">Christopher.Jones@RWDI.com</a>>; Michael Campbell <<a href="mailto:mcamp1206@gmail.com" target="_blank">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org" target="_blank">equest-users@onebuilding.<wbr>org</a><br>
<b>Subject:</b> RE: [Equest-users] User-Defined Default Expressions</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt"> <u></u><u></u></span></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^nd set of 4 characters (or the 3^rd set, or the 4^th set…).</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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.” </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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:</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Retail_–_Best Buy</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:.5in">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Retail_–_Home Depot</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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).</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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">highlighted</span>the new addition:</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">   AREA/PERSON      =</span><span style="font-size:9.5pt"><u></u><u></u></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</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">  if(#RV(#L("PEOPLE-SCHEDULE"))!<wbr>=0) then unused else</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">  switch (#L("C-ACTIVITY-DESC"))</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">    case "Reta": <span style="background:yellow">switch (#L("C-ACTIVITY-DESC",2))</span></span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d;background:yellow">                   case “_Bes” : 67</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d;background:yellow">                   case “_Hom” : 67*2</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d;background:yellow">                   default : 500</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d;background:yellow">                 endswitch</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">    case "Lobb": 150</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">    case "Clas": 100</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">    default: 500</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">  endswitch</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">  endif</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Consolas;color:#1f497d">endif}</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">~Nick</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365_x005f_x0000_i1025" src="cid:image001.png@01D29699.2E8CAE60"></span><span style="font-size:9.5pt"><u></u><u></u></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:9.5pt"><u></u><u></u></span></p>
<table class="m_-4697762119373232483MsoNormalTable" 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</span><u></u><u></u></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><u></u><u></u></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"><a href="tel:(913)%20564-6361" target="_blank">913.564.6361</a> </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"><a href="tel:(785)%20410-3317" target="_blank">785.410.3317</a> </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"><a href="tel:(913)%20564-6380" target="_blank">913.564.6380</a></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" target="_blank"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#626469">nicholas.caton@schneider-<wbr>electric.com</span></a></span><u></u><u></u></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><u></u><u></u></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"><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="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365_x005f_x0000_i1026" src="cid:image002.png@01D29699.2E8CAE60"></span><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> </span><span style="font-size:9.5pt"><u></u><u></u></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" target="_blank">mailto:equest-users-bounces@<wbr>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" target="_blank">Christopher.Jones@RWDI.com</a>>; Michael Campbell <<a href="mailto:mcamp1206@gmail.com" target="_blank">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org" target="_blank">equest-users@onebuilding.<wbr>org</a><br>
<b>Subject:</b> Re: [Equest-users] User-Defined Default Expressions</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt"> <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Mike,</span><span style="font-size:9.5pt"><u></u><u></u></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.</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">~Bill</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">   AREA/PERSON      =</span><span style="font-size:9.5pt"><u></u><u></u></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</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">if(#RV(#L("PEOPLE-SCHEDULE"))!<wbr>=0) then unused else</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">switch (#L("C-ACTIVITY-DESC"))</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">case "Reta": 67</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">case "Lobb": 150</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">case "Clas": 100</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">default: 500</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">endswitch</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">endif</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">endif}</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></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</span></b><span style="font-size:9.5pt"><u></u><u></u></span></p>
<table class="m_-4697762119373232483MsoNormalTable" 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:10.1pt">
<b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Senior Energy Engineer</span></b><u></u><u></u></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:10.1pt">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black"><img border="0" width="56" height="38" style="width:.5833in;height:.3958in" id="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365Picture_x0020_4" src="cid:image003.jpg@01D29699.2E8CAE60">  <img border="0" width="46" height="39" style="width:.4791in;height:.4062in" id="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365Picture_x0020_2" src="cid:image004.jpg@01D29699.2E8CAE60"></span><u></u><u></u></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:10.1pt">
<span style="font-size:5.0pt;font-family:"Arial",sans-serif;color:black"> </span><u></u><u></u></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:10.1pt">
<span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d">134 South Fitzhugh Street</span><span style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:#1f497d">                 </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d">Rochest<wbr>er,
 NY 14608</span><u></u><u></u></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:10.1pt">
<b><i><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#002060">T: <a href="tel:(585)%20698-1956" target="_blank">(585) 698-1956</a></span></i></b><b><i><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#002060">              </span></i></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">        <wbr>  </span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1f497d">F: <a href="tel:(585)%20325-6005" target="_blank">(585)
 325-6005</a></span><u></u><u></u></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">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="mailto:wbishop@pathfinder-ea.com" target="_blank"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">bbishop@pathfinder-ea.com</span></a></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">     <wbr>        </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://www.pathfinder-ea.com/" target="_blank"><span style="font-size:9.0pt;font-family:"Arial",sans-serif">www.pathfinder-ea.com</span></a></span><u></u><u></u></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">
<span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><img border="0" width="34" height="32" style="width:.3541in;height:.3333in" id="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365Picture_x0020_5" src="cid:image005.png@01D29699.2E8CAE60" alt="http://png-5.findicons.com/files/icons/977/rrze/720/globe.png"></span><span style="font-size:7.5pt;font-family:"Calibri",sans-serif;color:#00b0f0">Carbon
 Fee and Dividend - simple, effective, and market-based.</span><u></u><u></u></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></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" target="_blank">mailto:equest-users-bounces@<wbr>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" target="_blank">mcamp1206@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:equest-users@onebuilding.org" target="_blank">equest-users@onebuilding.<wbr>org</a><br>
<b>Subject:</b> Re: [Equest-users] User-Defined Default Expressions</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt"> <u></u><u></u></span></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.</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></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.</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1f497d"> </span></b><span style="font-size:9.5pt"><u></u><u></u></span></p>
<table class="m_-4697762119373232483MsoNormalTable" 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"><span style="font-size:9.5pt"><a href="http://www.rwdi.com/assets/logos/RWDI-logo.gif" target="_blank"><span style="color:#1f497d;text-decoration:none"><img border="0" width="70" height="70" style="width:.7291in;height:.7291in" id="m_-4697762119373232483m_-7039709998937579219gmail-m_5566097437395105365Picture_x0020_1" src="cid:image006.jpg@01D29699.2E8CAE60" alt="Title: RWDI - Description: RWDI logo"></span></a><u></u><u></u></span></p>
</td>
<td width="484" valign="top" style="width:363.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><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-size:9.5pt;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: <a href="tel:(519)%20823-1311" target="_blank">(519) 823-1311 ext 2052</a><br>
<a href="http://www.rwdi.com/" target="_blank"><span style="color:#999999">rwdi.com</span></a></span><span style="font-size:9.5pt"><u></u><u></u></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span><span style="font-size:9.5pt"><u></u><u></u></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" target="_blank">mailto:equest-users-bounces@<wbr>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</span><span style="font-size:9.5pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9.5pt"> <u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.5pt">Hi eQUEST Users,<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">I'm trying to create default user expressions in an effort to auto-populate certain fields in my models.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">I want to reference the activity description (C-ACTIVITY-DESC) have it automatically fill in fields such as Area/Person.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">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.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">I've tried using the "Switch" function and if-then statements but haven't been able to get it to work.<u></u><u></u></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:9.5pt">Any assistance is appreciated.<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">Thank you,<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt">Mike Campbell<u></u><u></u></span></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" target="_blank">solutions@rwdi.com</a> or call <a href="tel:(519)%20823-1311" target="_blank">+1.519.823.1311</a>.</span><span style="font-size:9.5pt"><u></u><u></u></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"><span style="font-size:9.5pt"><br>
______________________________<wbr>______________________________<wbr>__________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________<wbr>______________________________<wbr>__________<u></u><u></u></span></p>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
______________________________<wbr>_________________<br>
Equest-users mailing list<br>
<a href="http://lists.onebuilding.org/listinfo.cgi/equest-users-onebuilding.org" target="_blank">http://lists.onebuilding.org/<wbr>listinfo.cgi/equest-users-<wbr>onebuilding.org</a><br>
To unsubscribe from this mailing list send  a blank message to <a href="mailto:EQUEST-USERS-UNSUBSCRIBE@ONEBUILDING.ORG" target="_blank">
EQUEST-USERS-UNSUBSCRIBE@<wbr>ONEBUILDING.ORG</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal"><br>
______________________________<wbr>______________________________<wbr>__________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________<wbr>______________________________<wbr>__________<u></u><u></u></p>
</div></div></div>
</div>

</blockquote></div><br></div>