[TRNSYS-users] Count if statement in TRNSYS

[David BRADLEY]

Sajid,

   I'd start by defining an equation like:


aboveFive = GT(inputVal,5.)


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.

kind regards,

  David



On 07/18/2020 15:16, MEHMOOD Sajid via TRNSYS-users wrote:
> Hi everyone,
>
> I have a question, and if someone can answer it. i will be thankful.
>
> 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.
>
>
>
> Thanks
> The University of Edinburgh is a charitable body, registered in 
> Scotland, with registration number SC005336.
>
> _______________________________________________
> TRNSYS-users mailing list
> TRNSYS-users at lists.onebuilding.org
> http://lists.onebuilding.org/listinfo.cgi/trnsys-users-onebuilding.org

-- 
***************************
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
d.bradley at tess-inc.com

http://www.tess-inc.com
http://www.trnsys.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20200720/0e3322d0/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 25894 bytes
Desc: not available
URL: <http://lists.onebuilding.org/pipermail/trnsys-users-onebuilding.org/attachments/20200720/0e3322d0/attachment-0001.png>