Examples of the WaterSteamPro Custom Units functions
used in Microsoft Excel
Set dimensions in needed form: Used formula:
Pressure (to MPa): 1 =wcuSETCU(1;1000000;0)
Temperature (to C): 1 =wcuSETCU(2;1;273,15)
Volume (m3/kg): 1 =wcuSETCU(4;1;0)
Internal energy ,enthalpy (MJ/kg): 1 =wcuSETCU(6;1000000;0)
Entropy (kJ/kg*K): 1 =wcuSETCU(5;1000;0)
Pressure: 21 MPa The properties in blue are calculated automatically from the input values in red.
Temperature: 300 °C
Pressure: 21 000 000 Pa
Temperature: 573 K
Used formula:
Volume: 0,001357905 m3/kg =wcuVPT(C12;C13)
Density: 736,4286269 kg/m3
Internal Energy: 1,304947004 kJ/kg =wcuUPT($C$12;$C$13)
Entropy: 3,205131374 kJ/kg*K =wcuSPT($C$12;$C$13)
Enthalpy: 1,333463006 MJ/kg =wcuHPT($C$12;$C$13)
Heat capacity (p): 5,288982099 kJ/kg*K =wcuCPPT($C$12;$C$13)
Heat capacity (v): 3,030153644 kJ/kg*K =wcuCVPT($C$12;$C$13)
Saturation temperature: 369,827343 C =wcuTSP($C$12)
Saturation pressure: 8,58770833 MPa =wcuPST($C$13)
Note: All used functions are defined in Visual Basic for Application's Editor. For call it please press Alt-F11 keys.
The another way to use the WaterSteamPro functions is to use the WaterSteamPro Custom Units Excel add-in. Choose menu Tools/Add-ins.
In appeared dialog check the "WaterSteamPro Custom Units" and press OK. After that all functions will be viewed in "Insert function" wizard