Hi,

I have following analysis:

(493.47+1.8*Temperature)^-0.5*('Valve Position|A1'*(VPosition/100)^3+'Valve Position|B1'*(VPosition/100)^2+'Valve Position|C1'*(VPosition/100))

and similar equation in Excel:

(493.47+1.8*E1445)^-0.5*($R$5*(C1445/100)^3+$R$6*(C1445/100)^2+$R$7*(C1445/100))

the problem they give different result because of following:

(493.47+1.8*Temperature)^-0.5 from AF and (493.47+1.8*E1445)^-0.5 in Excel gives almost the same result - 0.04244

but in in AF Analysis it set to 0 whole result but in Excel it's more than 0, like 54.

It seems AF Analysis treats 0.04244 as 0 and we end up with 0 but Excel correctly use 0.04244 and calculate correctly.

thanks,

S

the fix is to put brackets around ((493.47+1.8*Temperature)^-0.5)