<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Sajid,</p>
<p> I'd start by defining an equation like:</p>
<p><br>
</p>
<p>aboveFive = GT(inputVal,5.)</p>
<p><br>
</p>
<p>the variable aboveFive will have a value of 1 if inputVal is
strictly greater than 5. You can then integrate aboveFive in which
case you will get the cumulative amount of time that inputVal has
been greater than 5.</p>
<p>kind regards,</p>
<p> David</p>
<p><br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 07/18/2020 15:16, MEHMOOD Sajid via
TRNSYS-users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:DBAPR05MB696528D55062BB7352AD9066D37D0@DBAPR05MB6965.eurprd05.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
Hi everyone, </div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
I have a question, and if someone can answer it. i will be
thankful.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
I have hourly data of whole year as shown in figure getting from
integrator. i want to calculate, the number of times, the value
is above 5 (for example). i know, we can do this by using
countif statement in excel sheet. But how i can implement this
in TRNSYS, as i need to pass this number (the number of times or
hours the value is above 5) to another equation.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<img size="25894" contenttype="image/png" unselectable="on"
tabindex="-1" style="max-width: 100%; user-select: none;"
data-outlook-trace="F:1|T:1"
src="cid:part1.8D6D232A.75315C5F@tess-inc.com" class=""><br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;
font-size: 12pt; color: rgb(0, 0, 0);">
Thanks</div>
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
TRNSYS-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:TRNSYS-users@lists.onebuilding.org">TRNSYS-users@lists.onebuilding.org</a>
<a class="moz-txt-link-freetext" href="http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org">http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
***************************
David BRADLEY
Principal
Thermal Energy Systems Specialists, LLC
3 North Pinckney Street - suite 202
Madison, WI 53703 USA
P:+1.608.274.2577
F:+1.608.278.1475
<a class="moz-txt-link-abbreviated" href="mailto:d.bradley@tess-inc.com">d.bradley@tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.tess-inc.com">http://www.tess-inc.com</a>
<a class="moz-txt-link-freetext" href="http://www.trnsys.com">http://www.trnsys.com</a></pre>
</body>
</html>