1 Reply Latest reply on Aug 1, 2014 2:22 PM by Marcos Vainer Loeff

    Pi Calc Help for a Novice

    monty_315

      Hello,

       

      I have created some efficiency data within EXCEL, which obviously, is very easy to use with multiple cells. I want to transition the formula in a Pi Calc, but as you are aware, the calc has to be an entire string. The result of the below expression is erratic because a small bottom end changing by the smallest amount multiplies and escalates. In EXCEL, I included a digital OR state for an inlet gas valve, so, for the ('Power_Tag'), i set to 0 when valve was closed. Can anyone advise on where I'd include this digital state into the below formula please?

       

      max(0,('Power_Tag')/max(0,((('Gas_Flow_Tag'/1000)*'Gas_CV'*(1000/3600))))*100)

        • Re: Pi Calc Help for a Novice
          Marcos Vainer Loeff

          Hi Carl,

           

          To be honest, I understood the general idea but I would need a numeric example to understand better your issue. Are you trying to write an expression for PI Performance Equation? If so, this is how you would add a condition for when the PI Tag ba:active.1 is on the active state: 

           
          if 'ba:active.1'="Active" then 1 else 2
          

          Is this what you are looking for?