[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [TRNSYS-users] Count if statement in TRNSYS

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@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@tess-inc.com

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