Thermo Utilities v3.0, MS EXCEL Add-ins
Contents
1. is outside the acceptable range specified in IFC formulation for Industrial use 0C lt T lt 800C 1003 Dryness fraction should be within the following limits 0 0 lt Q lt 1 0 1004 Pressure of the wet steam may not be more than 221 0 bar pressure at critical point is 221 2 bar i e P lt 221 0 bar 1005 Temperature of the wet steam may not be more than 374 0 C temperature at critical point is 374 15 C i e T lt 374 0 C e 1012 It is impossible to find a point with the specified pressure P and specific entropy s e 1013 It is impossible to find a point with the specified pressure P and specific volume v e 1014 It is impossible to find a point with the specified pressure P and specific enthalpy h e 1015 Inputs are not enough to determine the state of the steam or water Pressure and temperature are too close to wet steam data e 1016 Pressure and temperature are too close to critical point e 1017 Specific volume is too small Error handling reporting for Air and flue gas functions All functions return large negative numbers in case of error No function returns a negative number less than 20E 9 no matter what units are used The returned values and reasons are e 21E 9 Moisture content mc is not acceptable 0 lt mc lt 0 30 e 22E 9 Volumetric compositions should be within the interval zero and one and the sum must be one e 23E 9 Temperature should be within2. TF fugacity pressure ratio Function Description LKPTH P T gt H residual enthalpy LKPTS P T gt S residual entropy LKPTZ P T gt Z compressibility factor LKTP T gt P reduced saturation pressure LKTQF T Q gt F fugacity pressure ratio LKTQH T Q gt H residual enthalpy LKTQS T Q gt S residual entropy LKTQZ T Q gt Z compressibility factor Simple rules to remind function names All functions for steam water properties start with STM then comes abbreviations for inputs needed and at last the output Some examples are STMPTH needs P pressure and T temperature and calculates H specific enthalpy STMPHT needs P pressure and H specific enthalpy and calculates T temperature The same rule applies to functions for dry air moist air and flue gases Functions for dry and moist air start with Air and functions for flue gases start with Flue All functions for dry moist air need mc moisture content Therefore it has been omitted from the function s name The same is with the flue gas functions all of them need the volumetric or mole fraction of the gases Functions for screen hygrometer start with Screen and functions for sling hygrometer start with Sling These functions calculate SH specific humidity RH relative humidity PS percentage saturation and VWR volumetric water ratio Abbreviations e Cp Specific heat capacity at constant pressure e Cv S
3. Thermo Utilities v3 0 MS EXCEL Add ins Functions for properties of steam water When you activate STMXL XLA you have access to all steam water functions By pressing fx button in MS Excel a dialog over all function comes up Select User Defined and you will have a list over all user defined functions When you pick a function a brief description of the function appears at the bottom of the dialog box If you press Next Excel will continue with a dialog box that asks for the necessary inputs for the function In case you press Enter button you should fill all the parameters with numbers cell reference variable name and so on These are the normal Excel functions behavior and is not specific for this program If you need more help please see the on line help of MS Excel or the user manual The function names are compatible with the DLL version of steam properties Those users who upgrade to this version from DLL version of steam properties will find several new functions There are some simple rules that will help you to remind function names Here you have a complete list of functions for properties of steam and water A print of this page will be helpful if you are new to this package Function Description Comment STMCp P T gt Cp Heat capacity STMCpSS P gt Cp for saturated steam STMCpSW_ P gt Cp for saturated water STMDv V T gt Dv Dynamic viscosity STMPHO P H gt Q Dryness fr
4. action STMPHS P H gt S Specific entropy STMPHT P H gt T Temperature ISTMPHV P H gt V Specific volume sTMPOH P Q gt H Specific enthalpy sTMPQs P Q gt S STMPQV P Q gt V STMPSH _ P S gt H STMPSQ P S gt Q STMPST _ P S gt T STMPSV _ P S gt V STMPT P gt T Saturation temperature Should work in demo version STMPTH STMPTS sTMPTV sSTMPVH sTMPVO STMPVS STMPVT STMTc V T gt Tc Thermal conductivity Ed STMTP T gt P Saturation pressure Should work in demo version STMTQH _ T Q gt H STMTQS T Q gt S STMTQV _ T Q gt V Functions for properties of air flue gases Functions for properties of air flue gases are based on equations accepted by ASHRAE and are compatible with formulations accepted by CIBSE Chartered Institute of Building Services Engineers When you activate AIRXL XLA you have access to all air flue gases functions By pressing button fx in MS Excel a dialog over all function comes up Select User Defined and you will have a list over all user defined functions When you pick a function a brief description of the function appears at the bottom of the dialog box If you press Next Excel will continue with a dialog box that asks for the necessary inputs for the function In case you press Enter button you should fill all the parameters with numbers cell reference variab
5. ference variable name and so on These are the normal Excel functions behavior and is not specific for this program If you need more help please see the on line help of MS Excel or the user manual The function names are compatible with the DLL version of steam properties Those users who upgrade to this version from DLL version of steam properties will find several new functions There are some simple rules that will help you to remind function names Here you have a complete list of functions A print of this page will be helpful if you are new to this package Function Description Comment Fluidindex Fluid index in DB Should work in demo version DBT IN ormal freezing point Ishould work in demo version DpBTb IN orma boiling point DBTe Critical temperature DBPc Critical pressure DBVc Critical specific volume DBZc Critical compressibility factor DBAF Pitzer s acentric factor DBDM Dipole moment DBDELHF Standard enthalpy of formation Should work in demo version DBDELGF Standard Gibbs energy of formation should work in demo version ILKPFT EPT reduced temperature LKPHT lemor reduced temperature LKPOF PQF fugacity pressure ratio LKPOH lP QH residual enthalpy ILKPOS POS residual entropy LKPOZ Poz compressibility factor ILKPST EST reduced temperature ILKPZT PZT reduced temperature LKPT IPT reduced saturation temperature Should work in demo version LKPTF E
6. le name and so on These are the normal Excel functions behavior and is not specific for this program If you need more help please see the on line help of MS Excel or the user manual The function names are compatible with the DLL version of Air and Exhaust Gas properties Those users who upgrade to this version from DLL version of Air and Exhaust Gas will find several new functions There are some simple rules that will help you to remind function names Here you have a complete list of functions for properties of Air and Exhaust Gas A print of this page will be helpful if you are new to this package Function Description Comment AirCpT mc Cp gt T Temperature AirDpt mc P gt Dpt Dew point temperature AirDv mc P T gt Dv Dynamic viscosity AirGc mc gt Gc Gas constant Shoutd work in demo version AirktT mc H gt T AirMM mc gt Mm Molecular mass Shoutd work in demo version AirST mc S gt T Airto mc P T gt Tc Thermal conductivity lAnTCp mc T gt Cp Heat capacity at constant P AirTCv mc T gt Cv Heat capacity at constant V AirTGamma_ mc T gt Gamma Cp Cv AirTH mc T gt H Specific enthalpy AirTS mc T gt S Specific entropy FlueCpT Cp gt T Temperature FlueDpt P gt Dpt Dew point temperature IFlueDv P 7 gt Dv Dynamic viscosity fFlueGC gt Gc Gas constant Shoutd work in dem
7. o version FlueHT H gt T Function Comment FlueMM gt Mm Molecular mass Shoutd work in demo version lrluesT ks gt T IFlueTe P T gt Tc Thermal conductivity lFlueTCp lr gt Cp Heat capacity at constant P FlueTCv T gt Cv Heat capacity at constant V FiueTGamma Vi tC Cp Cv FlueTH T gt H Specific enthalpy FlueTS T gt S Specific entropy GasDensity P T Gc gt Ro Density IShould work in demo version Gass P Gc Satm gt S at pressure P Should work in demo version GasSAtm P Gc S gt Satm S at atmospheric pressure Should work in demo version ScreenPS DBT WBT gt PS Percentage saturation ScreenRH DBT WBT gt RH Relative humidity ScreenSH DBT WBT gt SH Specific humidity ScreenVWR_ DBT WBT gt VWR Volumetric water ratio SlingPS DBT WBT gt PS Percentage saturation SlingRH DBT WBT gt RH Relative humidity SlingSH DBT WBT gt SH Specific humidity SlingVWR DBT WBT gt VWR Volumetric water ratio Fluid properties utility for use with Lee Kesler method The current version of Lee Kesler method support 467 different chemical compounds You can use the utility software fluidpro exe to view edit or add new entries to our database When you edit or add new entries you should use the units mentioned in ellipses below This limitation apply only to database en
8. pecific heat capacity at constant volume e Dv Dynamic viscosity e Gamma Ratio of Cp Cv e GC Gas constant e H Specific enthalpy e mc Moisture content e MM Molecular mass e P Pressure e PS Percentage saturation e Q Steam quality dryness fraction 1 wetness fraction e RH Relative humidity e S Specific entropy e SH Specific humidity moisture content e T Temperature e Tc Thermal conductivity e V Specific volume e VWR Volumetric water ratio Molecular Weight Calculator Molecular weight of any compound can be computed by using its chemical formula e This function supports all atoms in the periodic system e It should work even if you do not have any registration key e Fractional multipliers are allowed e Fractional numbers less than 1 should begin with 0 Macro development and error handling You can view our function prototypes and VBA interface by selecting Tool Macro Visual Basic Editor in Excel By developing your own macros you can speed up your calculations and also make your own dialog boxes for input output Error handling reporting for Steam water functions All functions return large negative numbers in case of error No function returns a negative number less than 1000 no matter what units are used The returned values and reasons are e 1001 The pressure is outside the acceptable range specified in IFC formulation for Industrial use 0 01 bar lt P lt 1000 bar 1002 The temperature
9. point with the specified reduced pressure Pr and reduced specified entropy sr e 2013 It is impossible to find a point with the specified reduced pressure Pr and compressibility factor Z Z V P R T V Specific volume R Gas Constant 8 3144 J mol K 10 732 psia ft2 Ib mol R e 2014 It is impossible to find a point with the specified reduced pressure Pr and reduced specific enthalpy h e 2015 Inputs are not enough to determine the state of the fluid Pressure and temperature are too close to wet vapor data e 2016 It is impossible to find a point with the specified reduced pressure Pr and reduced fugacity pressure ratio f e 2020 Acentric factor is out of acceptable range 0 5 lt Af lt 2 0 In case of questions or comments contact Support taftan com For more information please visit http taftan com
10. the following limits 40 C lt T lt 1500 C e 24E 9 It is impossible to find a temperature with the specified specific enthalpy e 25E 9 It is impossible to find a temperature with the specified specific entropy e 26E 9 It is impossible to find a temperature with the specified specific heat capacity e 27E 9 The wet bulb temperature is limited to 40C lt T lt 70C e 28E 9 The following condition should be satisfied DryBulbT gt WetBulbT e 29E 9 This combination of dry and wet bulb temperatures are not possible e 30E 9 Pressure is outside the acceptable range 1 bar lt P lt 20 bar e 31E 9 Gas constant is too small Error handling reporting for Lee Kesler functions All functions return large negative numbers in case of error No function returns a negative number less than 2000 No matter what units are used The returned values and reasons are e 2001 The pressure is outside the acceptable range 0 01 lt Pr lt 10 Pr Reduced pressure P Pcr Per Critical pressure P Pressure e 2002 The temperature is outside the acceptable range 0 3 lt Tr lt 4 0 Tr Reduced temperature T Tcr Tcr Critical temperature T Temperature e 2003 Dryness fraction should be within the following limits 0 0 lt Q lt 1 0 e 2004 Pressure of wet vapor may not be more than Pcr i e Pr lt 1 0 e 2005 Temperature of wet vapor may not be more than Tcr i e Tr lt 1 0 e 2012 It is impossible to find a
11. try our software will use the default unit for input output as you selected by setunit exe as described before The database supports the following e Normal freezing point Tfp K e Norma boiling point Tb K at 1 atmosphere e Critical temperature Tc K e Critical pressure Pc bar e Critical specific volume Vc cm3 mol e Critical compressibility factor Zc no dimension e Pitzer s acentric factor Omega no dimension e Dipole moment DipM debyes e Standard enthalpy of formation DELHF J mol e Standard Gibbs energy of formation DELGF J mol A word of caution in case you add remove entries in the middle of database the fluid index will be changed Here is a screenshot of fluidpro exe Insert About Search by i Functions for Lee Kesler method These functions compute the thermodynamic properties of chemicals by using reduced pressure and temperature When you activate LKXL XLA you have access to these functions By pressing fx button in MS Excel a dialog over all function comes up Select User Defined and you will have a list over all user defined functions When you pick a function a brief description of the function appears at the bottom of the dialog box If you press Next Excel will continue with a dialog box that asks for the necessary inputs for the function In case you press Enter button you should fill all the parameters with numbers cell re
Download Pdf Manuals
Related Search