monty_315

Pi Calc Help for a Novice

Discussion created by monty_315 on Jul 31, 2014
Latest reply on Aug 1, 2014 by Marcos Vainer Loeff

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)

Outcomes