<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: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=us-ascii">
<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:"Yu Gothic";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",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.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
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:windowtext;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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;}
/* List Definitions */
@list l0
{mso-list-id:12851717;
mso-list-type:hybrid;
mso-list-template-ids:251557884 67698703 1600926658 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
mso-ascii-font-family:Calibri;
mso-fareast-font-family:"Yu Gothic";
mso-hansi-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:693964282;
mso-list-template-ids:-917238068;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></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="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><a name="_MailEndCompose"><span style="color:#1F497D">In addition to the character length of an expression, there is also a line length; i.e. # of characters per line of text. However, I forget what the exact maximum character length.<o:p></o:p></span></a></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#1F497D"><table border="0" cellspacing="0" cellpadding="0" width="100%"><tr><!--MAKE-SURE-TO-SET-THE-TD-WIDTH--><td width="80" style="padding-right: 13px;" valign="top"><a href="http://www.archnexus.com"><img src="http://www.stationerycentral.com/SignatureImages10/ArchNexus-logo-80x99.png" nosend="1" border="0" width="80" height="99" alt='ARCH | NEXUS'></a></td><td width="1" valign="top" style="border-left: 1px #009AD9 solid;"> </td><td style="padding-left: 9px;"><table border="0" cellspacing="0" cellpadding="0" width="100%"><tr><td align="left" colspan="2"><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 11pt; font-weight: normal">DAVID W. GRIFFIN II</span></td></tr><tr><td style="padding-top: 6px;" align="left" colspan="2"><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 7.5pt;">BEMP</span><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 7.5pt;"><br>ENERGY ANALYST</span></td></tr><tr><td align="left" style="padding-top: 6px; padding-bottom: 6px;" colspan="2"><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 7.5pt;"> 2505 E Parleys Way<br>Salt Lake City, UT 84109 </span></td></tr><tr><td align="left" width="100%" style="padding-left: 3px; white-space: nowrap;"><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 7.5pt;"><b>Office</b> 801.924.5028 </span></td></tr><span style="color: #52616E; font-family: 'Verdana', sans-serif; font-size: 7.5pt;"></span><tr><td align="left" style="padding-top: 6px; padding-bottom: 0px; white-space: nowrap;" colspan="2"><span style="color: #52616E; font-size: 7.5pt; font-weight: normal; font-family: 'Verdana', sans-serif;"><a style="text-decoration: none; color: #52616E" href="http://www.archnexus.com"><font color="#52616E">archnexus.com</font></a></span></td></tr><tr><td align="left" style="padding-top: 6px; padding-bottom: 0px; white-space: nowrap;" colspan="2"><a href="https://twitter.com/arch_nexus"><img src="http://www.stationerycentral.com/SignatureImages10/ArchNexus-tw-sharp-L-29x22.png" nosend="1" border="0" width="29" height="22" alt="Twitter"></a><a href="https://www.facebook.com/pages/Architectural-Nexus/179588705397563?ref=ts&fref=ts"><img src="http://www.stationerycentral.com/SignatureImages10/ArchNexus-fb-sharp-L-29x22.png" nosend="1" border="0" width="29" height="22" alt="Facebook"></a><a href="https://www.youtube.com/channel/UCYRPWKF-yp-AUiI8ia2XfKw?feature=mhee"><img src="http://www.stationerycentral.com/SignatureImages10/ArchNexus-yt-sharp-L-29x22.png" nosend="1" border="0" width="29" height="22" alt="Youtube"></a><a href="https://www.linkedin.com/company/architectural-nexus"><img src="http://www.stationerycentral.com/SignatureImages10/ArchNexus-li-sharp-L-29x22.png" nosend="1" border="0" width="29" height="22" alt="LinkedIn"></a></td></tr></table></td></tr></table><style> a {color: #009AD9;} </style></span><span style="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>From:</b> Nicholas Caton [mailto:Nicholas.Caton@schneider-electric.com]
<br>
<b>Sent:</b> Wednesday, November 15, 2017 10:34 AM<br>
<b>To:</b> Bishop, Bill; equest-users@onebuilding.org<br>
<b>Cc:</b> Jeff Hirsch<br>
<b>Subject:</b> Re: [Equest-users] Parsing Error: Expression too long to be parsed.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">For everyone’s benefit, I was further informed by JJH that every linefeed and carriage return counts as a character, thus the “every line counts as 2 characters” from the reference manual.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">There is however normally one of each for every line, except for the last line which only has a line feed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">So technically, the check for expression length is:<o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in">C + L*2 – 1 <= 4096<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">where <o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in">C = # of characters (including whitespaces), and<o:p></o:p></p>
<p class="MsoNormal" style="text-indent:.5in">L = number of lines in your text editor<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Nailed <u>that</u> one to the wall!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m going to retract my 2<sup>nd</sup> query regarding #L vs. #LR as a non-issue, as I think this truly was an expression length problem that I accidentally hid from myself in troubleshooting the expression with a separate model.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks everyone,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">~Nick<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img width="726" height="9" id="_x0000_i1025" src="cid:image001.png@01D35E26.0CC6F510"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="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="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="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="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="color:#3A7A46"><img border="0" width="722" height="49" id="_x0000_i1026" src="cid:image002.png@01D35E26.0CC6F510"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Bishop, Bill [<a href="mailto:bbishop@pathfinder-ea.com">mailto:bbishop@pathfinder-ea.com</a>]
<br>
<b>Sent:</b> Tuesday, November 14, 2017 1:22 PM<br>
<b>To:</b> Nicholas Caton <<a href="mailto:Nicholas.Caton@schneider-electric.com">Nicholas.Caton@schneider-electric.com</a>>;
<a href="mailto:equest-users@onebuilding.org">equest-users@onebuilding.org</a><br>
<b>Subject:</b> RE: Parsing Error: Expression too long to be parsed.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi Nick,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">From the DOE-2 help file for Keyword Expressions, “The length of an expression cannot exceed 4096 characters (new line counts as two characters.)”.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">It is not too hard to exceed this limit for long expressions. I’m wondering if your original expression exceeded it and your revised did not, so that it has nothing to do with the #L vs. #LR issue you mention.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">~Bill<o:p></o:p></span></p>
<p class="MsoNormal"><span style="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" id="Picture_x0020_4" src="cid:image003.jpg@01D35E26.0CC6F510">
<img border="0" width="46" height="39" id="Picture_x0020_2" src="cid:image004.jpg@01D35E26.0CC6F510"><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%;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><span style="color:#002060">
</span></i></b><span style="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="color:#1F497D"><a href="mailto:wbishop@pathfinder-ea.com"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:blue">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="color:#1F497D"><a href="http://www.pathfinder-ea.com/"><span style="font-size:9.0pt;line-height:105%;font-family:"Arial",sans-serif;color:blue">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="color:#1F497D"><img border="0" width="34" height="32" id="Picture_x0020_5" src="cid:image005.png@01D35E26.0CC6F510" alt="http://png-5.findicons.com/files/icons/977/rrze/720/globe.png"></span><span style="font-size:7.5pt;line-height:105%;color:#00B0F0">Carbon
Fee and Dividend - simple, effective, and market-based.</span><span style="color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="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>From:</b> Equest-users [<a href="mailto:equest-users-bounces@lists.onebuilding.org">mailto:equest-users-bounces@lists.onebuilding.org</a>]
<b>On Behalf Of </b>Nicholas Caton via Equest-users<br>
<b>Sent:</b> Tuesday, November 14, 2017 1:00 PM<br>
<b>To:</b> <a href="mailto:equest-users@onebuilding.org">equest-users@onebuilding.org</a><br>
<b>Subject:</b> [Equest-users] Parsing Error: Expression too long to be parsed.<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Friends,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have encountered an expression evaluation error that would seem pretty self-explanatory on the surface:<o:p></o:p></p>
<p class="MsoNormal"><img border="0" width="602" height="381" id="Picture_x0020_3" src="cid:image006.png@01D35E26.0CC6F510"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">After a couple passes to do the logical thing and reduce the line count and character count in the expression (trimming whitespace, removing annotations), I realized a mistake where I used #L instead of #LR for a reference to C-ACTIVITY-DESC.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Trimmed Example – the highlighted characters should read <span style="background:yellow;mso-highlight:yellow">
#LR</span>:<o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:Consolas"> switch(#SV(#PS()))<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 1 : 38800.32*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/10260.77 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 2 : 27584.18*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/7294.65 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 3 : 33622.74*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/8891.55 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 4 : 12621.09*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/3337.66 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 5 : 8551.12*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/2901.15 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 7 : 18717.66*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/6350.37 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 8 : 8066.63*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/2899.83 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> case 10 : 24826.83*<span style="background:lime;mso-highlight:lime">#L</span>("SPACE","AREA")/8924.85 $Exh*Area/Total Unit Area<o:p></o:p></span></p>
<p class="MsoNormal" style="text-indent:.5in"><span style="font-family:Consolas">default : no_def<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:Consolas"> endswitch<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Fixing that function, unintuitively, caused the above “expression too long” error to go away!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This however raises a couple questions – I’d be sincerely interested to see any replies or thoughts around either prompt:<o:p></o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l0 level1 lfo3">I didn’t think there was a limit for expression length (or at least a practical limit). The existence of this error suggests otherwise. To avoid crossing that line and to better interpret these errors
in the future: Does anyone know what the actual character/line/other limits are for expression length?
<o:p></o:p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoNormal" style="mso-list:l0 level2 lfo3">For reference, after trimming this was a relatively hefty expression clocking in at 2737 characters and 73 lines, according to my text editor… so if there is a limit it would be above those figures since
it’s now working again. <o:p></o:p></li></ol>
</li><li class="MsoNormal" style="mso-list:l0 level1 lfo3">To further help interpret/troubleshoot similar situations in the future… Why would using #L (which I would think should resolve in an error along the lines “you’re using the wrong function here, dummy”)
trigger an <u>expression length</u> error? Is there a hierarchy of error messages that maps out “throw error X before checking for root cause Y,” that we could construct and keep as a reference for interpreting what different expression evaluation errors
could mean when they come up?<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks everyone!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">~Nick<o:p></o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#3A7A46"><img border="0" width="726" height="9" id="Picture_x0020_1" src="cid:image001.png@01D35E26.0CC6F510"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif;color:#3A7A46">Nick Caton, P.E., BEMP</span></b><span style="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="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="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="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="color:#3A7A46"><img border="0" width="722" height="49" id="_x0000_i1032" src="cid:image002.png@01D35E26.0CC6F510"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><br>
______________________________________________________________________<br>
This email has been scanned by the Symantec Email Security.cloud service.<br>
______________________________________________________________________<o:p></o:p></span></p>
</div>
</body>
</html>