# Saturated steam equations

I found the following paper and am attempting to put Saturated Pressure and Saturated Temperature into excel. I got Saturated Pressure to work, but can't get saturated Temperature to work.

Saturated Steam Equations Paper

Saturated Pressure (working)
=(B18+273.15)/647.096 [cacluates Tr from C]
=EXP(9.56756 + 5.39806*LN(B19) - 6.16183*(LN(B19))^2 + 1.49572*(LN(B19))^4 + 0.433*B19^5 )

Saturated Temperature (not working)
=B15/22064 [calculates Pr from kPa]
=EXP((0.00937817 + 0.000498951*B16 + 0.0000111049*B16^2 + 0.000000334995*B16^3 + 0.0000000344102*B16^4)^(-0.4))

I thought maybe it was outputting in K, but that did not solve it.

Either I didn't correctly translate the equation, or the equation is wrong. Thoughts? Thanks!

• How do you know it is not working? – user190081 Sep 13 '18 at 22:00
• I compared it to the TLV online calculator. tlv.com/global/US/calculator/steam-table-pressure.html – ericnutsch Sep 13 '18 at 22:22
• If someone prefers python: there is IAPWS module. from iapws import IAPWS97; IAPWS97(P=1, x=1).T gives 453K for 1MPa – Xpector Jun 12 at 13:25