SteamTab® V4.0 User`s Guide
Contents
1. Remarks e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 The specified entropy unit must be in kJ kg C if units is 0 and must be in Btu b F if units is 1 STTU Calculates superheated vapor or subcooled liquid property at the specified temperature and internal energy Syntax STTU temperature internal_energy property_code units Remarks e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 The specified internal energy unit must be in kJ kg if units is 0 and must be in Btu Ib if units is 1 37 CuemicaLocic 38 STPV Calculates superheated vapor or subcooled liquid property at the specified pressure and volume Syntax STPV pressure volume property code units Remarks The specified pressure unit must in bar if units is 0 and must be in psia if units is 1 specified volume unit must be in m kg if units is 0 and must be in ft Ib if units is 1 STPH Calculates superheated vapor or subcooled liquid steam property at the specified pressure and enthalpy Syntax STPH pressure enthalpy property_code units Remarks The specified pressure unit must in bar if units is 0 and must be in psia if units is 1 The specified enthalpy unit must be in kJ kg if units is 0 and must be in Btu Ib if units is 1 STPS Calculates superheated vapor or subcooled liquid property at th2. We encourage you to submit your tips and tricks to us for inclusion in future releases and upgrades See page 5 fot information on how to contact us Tips and tricks to help you become more productive in no particular order You may notice a slight delay the first time you use SteamTab This is normal because the spreadsheet application loads the full Steam Tab package only when you first use it This helps conserve memoty You do not have to remember the calling sequence of Steam Tab functions Use the SteamTab dialog boxes to generate the correct function with the right arguments Click on the cell where you want the results before opening any of the SteamTab dialog boxes SteamTab will automatically fill in the Output cell reference for you SteamTab V4 0 CuemicaLocic Uninstalling SteamTab To uninstall SteamTab from Window s Start menu select Programs ChemicaLogic SteamTab and then select Uninstall ChemicaLogic SteamTab This will completely uninstall SteamTab from your computer You can also uninstall SteamTab from the Control Panel Add or Remove Programs or Programs and Features in Windows 7 and selecting ChemicaLogic SteamTab version 2 0 to uninstall Control Panel All Contre Panel Items Programs and Features Panel Home Uninstall or change a program View installed updates To uninstall program select from the list and then chick Uninstall Change
3. MVC Vieual Studio 9010 Micrnenft Crenoratice 2017 0 Corporation Product version 40 Support lini http www chemicalo Sce 200 MB Help lini httgi www chemicalo Update information http www chemicalo SteamTab V4 0 19 CuemicaLocic 20 Joule James Prescott Joule jj joul James Prescott 1818 1889 British physicist who established the mechanical theory of heat and discovered the first law of thermodynamics SteamTab V4 0 CuemicaLocic Introduction SteamTab V4 0 Chapter Tutorial sty mie To thwart stump a problem in thermodynamics that stymied half the class The American Heritage Dictionary of the English Language Third Edition 1996 The SteamTab package you purchased contains several examples and templates that you can use in your work The examples included in the SteamTab package illustrate the following concepts Steam Quality Constant temperature process Constant pressure process Constant volume process Constant entropy process Constant internal energy process Irreversible adiabatic expansion Irreversible adiabatic compression Moisture content in air and dew point calculations Relative humidity Charting of steam properties The following sections give you step by step instructions on how to solve two steam telated problems using the power of SteamTab 1 Calculating the enthalpy of vaporization and 2 Constant property proc
4. VALUE error In Lotus versions ERR error Examples 1 STTSAT 21 2 pl returns 14 696 which is the vapor pressure in psia of water at a temperature of 212 F 2 STTSAT 2 2 8 1 STTSAT 212 0 8 1 returns 970 19 which is the enthalpy of vaporization in Btu Ib of water at a temperature of 212 F 3 STTSAT 300 0 11 returns 5 75 which is the specific heat capacity of liquid at constant pressure in kJ kg C at a temperature of 300 C Functions for Superheated or Subcooled Steam Properties The functions in this category calculate the superheated vapor or subcooled liquid property at any two specified independent variables These functions have a wide range of applicability Generally the properties returned by these functions are acceptable within the following ranges Pressure D bat Temperature T 190 lt T 5000 0 lt P lt 100 000 The supetheated subcooled functions require two independent variables as input Use the following table as a guide to select the appropriate function 34 SteamTab V4 0 CuemicaLocic SteamTab V4 0 Specified Independent Variable First Variable Second Variable Use Function Temperature T Pressure P STTP Temperature T Volume STTV Temperature T Enthalpy H STTH Temperature T Entropy 5 STTS Temperature T Internal Energy U STTU Pressure P Volume STPV Pressute P Enthalpy H STPH Pr
5. Figure 7 Constant Property Dialog Box Constant Steam Properties Steam Property Critical compressibility Output to Cel 1 SteamTab V4 0 15 CuemicaLocic 16 Using Excel s Function Wizard If you know the SteamTab function that you want to use you can use Excel s function wizard to generate the function call SteamTab installs all of the functions in a category called ChemicaLogic SteamTab as shown below Figure 8 ChemicaLogic SteamTab functions in Excel s Function Wizard Insert Function 10 Search for a function Type a brief description of what you want to do and then click Go Or select a category ChemicaLogic SteamTab Select a Function STTH A STTP STTPP STTPT STTS STTU Y STTSAT temperature quality property code units Calculates saturated steam properties at specified temperature and quality Selecting the STTP function to shows the function wizard Figure 9 Excel s Function Wizard for SteamTab Function Function Arguments 5 Temperature 8 Pressure 4 0 004 Property_code 6 6 Units 0 0 9 406073686 Calculates superheated subcooled steam properties at specfied temperature and pressure Temperature temperature Formula result 9 4061 Help on this Function If you need help on the function arguments or need to lookup the property codes click on the Help o
6. New Print 4 Save amp Send New from Personal Templates Choma atog we jJ 4 8 Lins Remta RemTab Resto Compressor xpanderit Pressure 1 Options Reports SteamTab Tempis o He be Apo Ur Dis to eat a RWG di inc writs the ka b 2 riw fa condone Sharm Cos Cem 27 CuemicaLocic Click here to display or erase the sample data shown Click on the drop down list box to select the units you want to work on The units column will then change automatically Click on the drop X Microsoft Excel SteamTab Compressori Insert Format File Edit View Tools Figure 14 SteamTab Compressor Template Example Data Window Help 1515 la ec ol 8 moe amp down list box to select the model formulation you want to wotk on Enter the problem specification in the shaded area the un shaded cells are protected After you have entered each of the 5 values the answer will automatically appear 28 Ariel Jm s rz w amp se m m sll 144 W 100 A B D E F G B Sample Data Print About 2 Single Stage Steam Compressor Adiabatic Process nits Inlet Outlet Outlet ideal 6 Flowrate m 100 00 100 00 Pressu
7. 0V OT m kg C f Ib F 17 DvbP 0V OP m kg bar f Ib psi 18 MU Viscosity dynamic 4 uPa s Ib ft hr 19 T Thermal conductivity K W m Btu hr ft F 20 ST Surface tension N m N m 21 PR Prandtl number Pr dimensionless dimensionless 22 DC Static dielectric constant dimensionless dimensionless 23 JT Isothermal Joule Thomson coefficient kJ kg Btu Ib psia 24 JT Joule Thomson coefficient C bar F psia 25 Q Quality vapor mass fraction dimensionless dimensionless 26 GAMMA Isentropic exponent y V P oP 0V dimensionless dimensionless 27 HV Latent heat of vaporization kJ kg Btu Ib Note By definition the thermodynamic Reference State of steam is the liquid at the triple point 0 01 C at which the internal energy and entropy ate set to zero SteamTab V4 0 31 CuemicaLocic Functions for Saturated Steam Properties 32 The functions for saturated steam properties calculate vapor liquid or two phase properties at either specified pressure or specified temperature The applicable range of these functions is from the triple point up to the critical point Depending on your choice of independent variable the two functions you can choose are Independent Variable Use Function Pressure STPSAT Temperature STTSAT These functions are described in detail below STPSAT Calculates the saturated vapor or liquid property at the specified pressure Syntax STPSAT pre
8. 88 1 9 7264 8 9 4061 8 9 2185 8 9 2265 30 9 1841 40 9 0556 50 8 92 12 9 7396 10 9 4193 10 9 2318 10 9 2872 40 9 2430 50 9 1128 60 8 97 13 98043 20 9 4841 20 9 2967 20 9 3461 50 9 3002 60 9 1685 70 9 035 14 9 8669 30 9 5468 30 9 3594 30 9 4033 60 9 3558 70 9 2226 80 9 089 15 9 9275 40 9 6075 40 9 4202 40 9 4589 70 9 4099 80 9 2753 90 9 142 16 9 9864 50 9 6663 50 9 4791 50 9 5130 80 9 4626 90 9 3266 100 9 193 17 10 0435 60 9 7234 60 9 5362 60 9 5656 90 9 5139 100 9 3767 110 9243 18 10 0990 70 9 7790 70 9 5918 70 9 6169 100 9 5640 110 9 4256 120 9292 19 10 1530 80 9 8330 80 9 6458 80 9 6670 110 9 6129 120 9 4734 130 9 340 20 10 2056 90 9 8856 90 9 6984 90 9 7159 120 9 6606 130 9 5201 140 9 387 21 10 2569 100 9 9369 100 9 7497 100 9 7636 130 9 7073 140 9 5659 150 9 433 22 9 9870 110 9 7998 110 98104 140 97531 150 9 6106 160 9 477 23 10 0358 120 9 8487 120 9 8561 150 9 7978 160 9 6545 170 9 521 24 9 8964 130 9 9008 160 9 8417 170 9 6975 180 9 564 25 9 9432 140 9 9447 170 9 8847 180 9 7397 190 9 606 26 9 9889 150 9 9877 180 9 9268 190 97811 200 9 648 27 AN NAAR 1n noon aca nn 99717 211 M M Temperature Enthalpy lt Constant Quality Constant Pressure lt Constant Enthalpy 14 on Ready 21 CuemicaLocic If you are using the Worksheet functions directly in you spreadsheet then you do not have to set the options The options dialog is only used by the SteamTab dialog boxes See Table
9. ChemicaLogic Corporation SteamTab is a registered trademark of ChemicaLogic Corporation ChemicaLogic is a trademark of ChemicaLogic Corporation All other trademarks and copyrights are hereby acknowledged CuemicaLocic Table of Contents INTRODUCTION TO STEAMTAB c csssssssssssessessssssssssesoessssssessscsscesnsesesesesseesees 3 OVERVIEW AND FEATURES cccccececececececececececececececececececececececececececececececececececececececs 3 WHAT S NEW IN 0 8 5 TECHNICAL SUPPORT AND CONTACT INFORMATION ccccccececececececececececececececeeecesece 5 GETTING 4 VE UD 7 MINIMUM SYSTEM REQUIREMENTS 7 INSTALLATION eere cete e se etu vex Bes bake e BOS 7 USINGSSTEAM TAB eid eut os eet e eacus crue eed Ge veut ea etes Ge aeu eae cx Deve 8 Wheres SteamTab enc ena ded eise n 8 Setting Steam Property 10 Using the Saturated Steam Properties Dialog 11 Using the Superheated Subcooled Steam Properties Dialog 13 Using the Constant Steam Properties Dialog 15 Using Excel s Function 16 Using SteamTab Excel s Visual Basic for Applications VBA 17 FIPS AND TRICKS ie ER ee Pee ue AS e 18 UNINSTALLING STEAMTAB ccccccecececececececece
10. SteamTab pop up menu by clicking on it 4 The following figures show what you should see SteamTab V4 0 CuemicaLocic SteamTab Menu SteamTab V4 0 Figure 2 Access to SteamTab in Excel 2003 Tools Dat Type a question for help 8x Spelling E 311 010 OB Research E Error Checking 4 Speech 1 J K L M N CU Shared Workspace 3 0 Share Workbook 30 10 50 60 70 H kJkg kJ Track Changes kg kJ kg bar H kJ kg H kJ kg H kJkg 0 00082 0 006117 250 0 Mace 5 0 006117 1000 367 0 006117 1250 458 0 006117 1500 549 0 006117 1750 641 0 0061 191 806 0 1 ER ee 2 0 1 1148 627 0 1 1387 832 0 1 1627 038 0 1 1866 243 251423 02 Protection 02 1194428 02 1430 179 0 2 1665 931 0 2 1901682 317 624 04 Online Collaboration 2 04 1244995 0 4 1476 838 04 1708 680 0 4 1940523 359 907 06 91 0 6 1277 086 0 6 1506 381 0 6 1735 676 0 6 1964 971 391 710 08 E b1 08 1301 098 08 1528 444 08 1755791 08 19831387 417 504 1 Scenarios 7 1 1320481 1 1546 226 1 171 9707 1 1997 715 504 704 T Forks 627 2 1385315 2 1605 467 1825 6207 2 2045 7737 604 65
11. at a pressure of 14 7 psia 3 STPSAT 100 0 11 returns 6 124 which is the specific heat capacity at constant pressure in kJ kg C at a pressure of 100 bar STTSAT Calculates the saturated vapor liquid or two phase property at the specified tempetature Syntax STTSAT temperature quality property code units Arguments temperature quality property code Units Remarks is the temperature at which the saturated steam property is required See the Remarks section for acceptable temperature units is 1 for vapor phase properties 0 for liquid phase properties and between 0 and 1 for two phase is an integer property code that specifies the type of property required See Table 2 Property Codes for Thermodynamic and Transport Properties of Steam page 31 for a listing of valid property codes and their meaning is an integer argument optional in Excel For Metric SI units specify a value of 0 or leave empty in Excel For English units specify a value of 1 e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 33 CuemicaLocic The specified temperature must be greater than or equal to the Triple Point Temperature 0 01 C and less than or equal to the Critical Temperature 373 976 C If any of the arguments are invalid or if the arguments are outside the acceptable bounds the function returns the following error codes In Excel versions
12. creates a call with all the correct arguments to the approptiate SteamTab function based on the input parameters you supply Use the following steps to calculate a saturated steam property see Figure 5 for an illustration of the saturated steam properties dialog box 1 Select Options Click on the Options button to bring up the options dialog box from where you can select the units as described in the previous section If you previously selected the units you can skip this step 11 CuemicaLocic Depending on your choice of units and independent variable the value text will show you the units in which the value is required Ti p Click on a cell where you want the results before opening the saturated dialog box SteamTab will automatically fill in the Output cell reference You can determine the triple point and the critical point of steam by using the Constant steam properties dialog box See page 15 If you activate the saturated dialog box on a cell that already contains a saturated SteamTab function then SteamTab will automatically initialize the dialog box with the correct values 12 2 Select independent variable Choose either Temperature or Pressure as the independent variable the vatiable you wish to specify by clicking on the appropriate radio button 3 Provide a value for the independent variable Type in a number for the independent variable in the Value edit box Alternatively you can type in
13. the LAPW S Formulation 1995 for the Thermodynamic Properties of Ordinary Water Substance for General and Scientific Use The International Association for the Properties of Water and Steam Frederica Denmark Sept 1996 The scientific formulation is valid in the entire stable fluid region of water from the melting pressure curve starting at 251 165 K to 1273 K at pressures up to 1 000 MPa The formulation can also be extrapolated to pressures up to about 100 GPa and temperatures up to 5000 K SteamTab imposes the following temperature and pressure restrictions Pressure D bat 0 P lt 100 000 Temperature T 190 lt T 5000 Note SteamTab does not include properties for ice SteamTab is designed as a low cost personal productivity enhancement tool for steam property users in the scientific engineering plant operation and educational communities SteamTab contains the following features Easy access to a comprehensive set of thermodynamic and transport steam properties from the spreadsheet s Tools menu Direct live links to variable steam conditions by cell reference Choice of Mettic SI or English units Direct calculation of steam outlet conditions for isentropic isenthalpic constant internal energy or constant volume process SteamTab functions for saturated vapor liquid superheated subcooled and constant steam properties Generation of your own steam property diagrams using the spreads
14. version number of the spreadsheet application and the operating system on which it is installed ready You can contact us via any of the following paths SteamTab V4 0 5 CuemicaLocic By Telephone By Fax By Email By Web By Mail 781 425 6738 9 AM to 5 PM EST 781 425 6741 clc support a chemicalogic com http www chemicalogic com ChemicaLogic Corporation 99 South Bedford Street Suite 207 Burlington Massachusetts 01803 USA Car not Nicolas L onard Sadi Car not Nicolas L onard Sadi 1796 1832 French physicist and engineer who founded the science of thermodynamics SteamTab V4 0 CuemicaLocic Chapter Getting Started The reality is that zero defects in products plus zero pollution plus zero risk on the job is equivalent to maximum growth of government plus zero economic growth plus runaway inflation Dixie Lee Ray 1924 94 U S Democratic politician government official Scientists and Engineers for Secure Energy speech 1980 Quoted in Esther Stineman American Political Women 1980 Minimum System Requirements You should not encounter any hardware or software problems in using SteamTab on any hardware that has one of the following spreadsheet applications pre installed Microsoft Excel 2003 or later running on Windows XP or later 32 bit and 64 bit operating systems are both supported Installation SteamTab contains an automatic installation program that will
15. 1 on page 31 for a listing of steam properties and their Metric SI and English units 10 The SteamTab pop up menu contains the following menu items 1 Saturated Selecting this menu item brings up the saturated steam properties dialog box which helps you obtain saturated vapor or liquid steam properties or two phase steam properties 2 Superheated Subcooled The menu item displays the dialog box for obtaining supercritical or subcooled steam properties This dialog box is also used for constant property processes such as isenthalpic isentropic constant volume etc SteamTab uses a highly efficient iterative search algorithm to quickly calculate all constant process properties 3 Constant Properties Selecting this menu item brings up the constant properties dialog box which you can use to select the required constant steam property 4 Options This menu item allows you to select the units and other configuration options You can also change the units and model formulation from any of the Steam Tab dialog boxes 5 Help Provides you with easy access to online help 6 About SteamTab Gives you information regarding the version of SteamTab installed on your machine The following sections describe how to use the vatious capabilities of SteamTab Setting Steam Property Options The options dialog box helps you in setting up the units to base your property calculations All of the SteamTab dialog boxes use the same options t
16. 5 4 817 9 ig 4 4 1458 014 4 1671 354 4 1884 6947 4 2098 033 670 377 6 8789 Sour 07 6 1504683 6 1713 260 6 1921 837 6 2130 413 720 864 8 925 61 Macro per 8 1539 840 8 1744 584 8 1949 327 8 2154071 762 515 10 963 9 VOTES 10 1568 3527 10 1769 8127 10 1971 2717 10 2172 7317 908 498 20 1097 4 um B6 20 1664 416 20 1853 395 20 2042 375 20 2231 354 1087 492 40 1258 8 2 AutoCorrect Options 90 40 1772 823 40 1944156 40 2115 489 40 2286 822 1213 923 60 1370 9 Customs 60 1842 189 60 1999256 60 2156 323 60 2313 389 1317 311 80 14614 80 1893 860 80 2037 997 80 2182 134 80 2326 272 1408 064 100 15398 QPtion 02 100 1935 035 100 2066 778 100 2198 521 100 2330264 1 1450 442 110 1576 0 CO2Tab 110 1952 803 110 2078 394 110 2203 984 110 2329 574 1 1491 459 120 16108 Data Analysis bs 120 1969 054 120 2088 453 120 2207 851 120 2327 250 1 1531 508 130 1644 n 2097 094 130 2210 211 130 2323 328 1 1570 960 140 1677 6 SteamTab 140 2211 098 140 2317787 1 1610 200 150 1710 25 150 1810 300 Superheated Subcooled 150 2210498 150 2310 548 1 j 1649 688 160 1742797 160 1835 907 RE S 160 2208 347 160 2301457 1 1690 026 170 170 1861 521 170 2204 540 170 2290257 1 1732 085 180 1809 860 180 1887 634 180 2198 732 180 2276 506 1 1777 154 190 1846 039 190 1914 925 190 2190 465 1
17. 90 2259 351 1 1827 214 18857277 200 1944240 5 200 2178 293 200 2236 807 2 1932662 210 1977 765 4 AboutSteamTab 210 21581797 210 2203283 2 20275147 220 2043 689 220 2059863 220 2076 038 220 20922137 220 2108 387 220 2124 562 2 2084 256 220 64 2084256 220 64 2084 256 220 64 2084 256 220 64 2084 256 220 64 2084 256 220 64 2084 256 220 thalpy Chart Constant Quality Constant Temperature Constant Entropy C lt m pes BOA 2 TS Tad a B Hl Figure 3 Access to Steam Tab in Excel 2007 or Excel 2010 5 6 5 ts diagram iapws95 ds Compatibility Mode Microsoft Excel o g Insert Page Layout Formulas Data Review View Developer Add Ins a o cg 54 MoistAirTab SteamTab Menu Commands B12 d f 5 12 854 6 0 EUN DENS F H j K L M N td 1 Constant Pressure 2 3 P 0 002 bar P 0 004 bar P 0 006 bar P 0 008 bar P 0 01 bar 0 015 bar P 0 14 P bar 0 002 0 004 0 006 0 008 0 01 0 015 0 5 Ts bar N A 3 761 6 970 13 019 17 6 S kJ kg K T C S kJ kg K T C S kJ kg K T C S kJ kg K T C S kJ kg K T C S kJ kg K T C S kJ kg 7 9 6726 o 9 3521 0 9 1643 o 9 0567 3761 8 9749 6 970 8 8270 13 020 0 2 8 9 5862 2 9 3658 2 9 1781 2 9 0651 5 8 9952 10 8 8725 20 87 9 9 6997 4 9 3793 4 9 1917 4 9 0986 10 9 0604 20 8 9356 30 8 80 10 97131 6 9 3927 B 9 2051 B 9 1637 20 9 1233 30 8 9965 40
18. CHEMICALOGIC SteamTab V4 0 User s Guide THERMODYNAMIC AND TRANSPORT PROPERTIES OF WATER AND STEAM Pressure Enthalpy Diagram for Water and Steam Based on the IAPWS 95 Formulation for General and Scientific Use 10000 1000 100 Pressure bar E o 0 1 0 01 0 500 1000 1500 2000 2500 3000 3500 4000 4500 5000 Drawn with SteamTab Duo V3 0 Enthalpy kJ kg Copyright 1998 ChemicaLogic Corporation e ChemicaLogic Corporation 99 South Bedford Street Burlington MA 01803 USA Tel 781 425 6738 Fax 781 425 6741 www chemicalogic com Software License Agreement OTICE THIS IS A CONTRACT BY INSTALLING AND USING THE SOFTWARE INDCATED BELOW YOU ARE IMPLICITLY CCEPTING ALL THE TERMS AND CONDITIONS OF THIS AGREEMENT gt Z SteamTab Thermodynamic and Transport Properties of Water and Steam This ChemicaLogic Corporation ChemicaLogic License Agreement accompanies the software product identified above and related documentation SOFTWARE The term SOFTWARE shall also include any upgrades modified versions or updates of the SOFTWARE licensed to you by ChemicaLogic You must read this Agreement carefully before indicating acceptance at the end of the text of this Agreement If you do not agree with the terms and conditions of this Agreement decline where instructed during installation and you will not be able to use the SOFTWARE ChemicaLogic grants to you a nonexclusive license to use the SOFTWA
19. NCTIONS center en teet 30 TABLE 2 PROPERTY CODES FOR THERMODYNAMIC AND TRANSPORT PROPERTIES 31 List of Figures FIGURE 1 CHEMICALOGIC STEAMTAB ON WINDOW S START MENU 8 FIGURE 2 ACCESS TO STEAMTAB IN EXCEL 2008 9 FIGURE 3 ACCESS TO STEAMTAB IN EXCEL 2007 OR EXCEL 2010 9 FIGURE 4 STEAM PROPERTY OPTIONS DIALOG 11 FIGURE 5 SATURATED STEAM PROPERTIES DIALOG eee 13 FIGURE 6 SUPERHEATED SUBCOOLED DIALOG BOX 14 FIGURE 7 CONSTANT PROPERTY DIALOG 22 2 2 2 2 202004 800000011 000060000000400 15 FIGURE 8 CHEMICALOGIC STEAMTAB FUNCTIONS IN EXCEL S FUNCTION WIZARD iter OT NO e I OE T De ARD 16 FIGURE 9 EXCEL S FUNCTION WIZARD FOR STEAMTAB 16 FIGURE 10 EXCEL VBA REFERENCE TO STEAMTAB eee 17 FIGURE 11 TUTORIAL EXAMPLE 1 23 FIGURE 12 TUTORIAL EXAMPLE 2 essent 25 FIGURE 13 STEAMTAB TEMPLATES FOR EXCEL 2007 2010 27 FIGURE 14 STEAMTAB COMPRESSOR TEMPLATE EXAMPLE 28 SteamTab V4 0 CuemicaLocic Chapter Introduction to SteamTab Whatever creativity is it is in part a solution to a problem Brian Aldiss b 1925 Bury My Heart at W Smith s Ap ritif 1990 Overview and Features Designers of steam processing systems and equipment use a v
20. RE provided that you agree to the following USE You an entity or a person may use the SOFTWARE either on a stand alone computer or on a network if you meet the following conditions STAND ALONE COMPUTER USE You must acquire one copy of the SOFTWARE for each computer on which the SOFTWARE will be installed The primary user of the computer may also use the SOFTWARE on a home and or laptop computer provided the SOFTWARE is used on only one computer at a time SHARED NETWORK USE You may use the SOFTWARE on a network provided you have purchased SOFTWARE equal to the maximum number of copies in use at any time The SOFTWARE is in use on a computer when it is resident in memory or when executable and other files are installed on the hard drive or other storage device Software which is stored on a server and not resident in memory on that machine is not considered in use UPGRADES If the SOFTWARE is an upgrade you are authorized to use the SOFTWARE only if you are an authorized user of a qualifying product as determined by ChemicaLogic The upgrade SOFTWARE replaces the qualifying product RESTRICTIONS You may not alter reverse engineer decompile or disassemble the SOFTWARE You may not loan rent lease or license the SOFTWARE or any copy However you may transfer the SOFTWARE on a permanent basis provided you transfer the SOFTWARE including the most recent update and all prior versions this SOFTWARE Agreement and all documentation a
21. SteamTab functions also return quality as a calculated property If the quality cannot be determined then a value of 1 is returned If the phase is superheated vapor then a quality of 2 is returned and if the phase is subcooled liquid a quality of 3 is returned SteamTab V4 0 CuemicaLocic The argument code is an integer or string argument the string is case insensitive that specifies the type of steam property requested Valid values of code and the units in which they are returned are shown in the table below Table 2 Property Codes for Thermodynamic and Transport Properties of Steam Code Steam Property Metric SI Units English Units 0 T Temperature T C F 1 P Pressure P bar psia 2 Volume V mg ft lb 3 D Density 2 kg m lb ft 4 2 Compressibility factor Z dimensionless dimensionless 5 A Helmoltz free energy A kJ kg Btu lb 6 S Entropy 5 kJ kg C Btu Ib F 7 U Internal energy kJ kg Btu lb 8 H Enthalpy H kJ kg Btu lb 9 G Gibbs free energy G kJ kg Btu Ib 10 Heat capacity at constant volume C kJ kg C Btu Ib F 11 Heat capacity at constant pressure C kJ kg C Btu Ib F 12 Ww Speed of sound v m s ft s 13 ALPHA Coefficient of thermal expansion p ov r 1 1 F 14 APPA Isothermal compressibility l bar l psia 15 DPDT OP OT bar C psia F 16
22. atiety of conventional methods to look up steam properties for engineering calculation including printed steam tables in different units stand alone steam property software proprietary design software general purpose process simulators and long hand calculations from fundamental equations Lookup from printed steam tables remains the most frequently used method for daily use of steam properties The interpolation of property values between fixed state points is a tedious boring and prone to error exercise that has plagued many generations of engineers SteamTab designed as an add in package to popular spreadsheet applications allows users the convenient access without leaving the spreadsheet computation environment to a variety of steam property values SteamTab contains a comprehensive set of thermodynamic and transport properties applicable over a wide range of conditions with selected derivative and dimensionless properties SteamTab uses fundamental equations to calculate all steam properties with no interpolation or curve fits to raw steam data SteamTab uses formulations that are approved the International Association of the Properties of Water and Steam LAPWS in 1995 for general and scientific use This formulation is thermodynamically rigorous accurate and applicable over wider range of conditions The formulations used in SteamTab are given in the following reference SteamTab V4 0 3 CuemicaLocic Reference Release on
23. cecececececececececececececececececececececececececevecs 19 TUTORIAL ppE 21 INTRODUCTION ies ee rn BEE 21 EXAMPLE 1 ENTHALPY OF 22 EXAMPLE 2 CONSTANT PROPERTY 556 lt 25 TEMPLATES AND EXAMPLES 3 doo toes 26 SteamTab for Excel 2007 2010 essen 26 FUNCTION REFERENC Eissssssssscsccsesscsssessacsesesvensccnssessevesicsseceasesdesoassvtacsosessecoosense 29 OVERVIEW 29 FUNCTIONS FOR SATURATED STEAM 6 00 32 DIUI Rt TEMERE M 32 Y M SAT eo etre Uma Ec A t na 33 FUNCTIONS FOR SUPERHEATED OR SUBCOOLED STEAM PROPERTIES 34 General Description esie iei Reb EES s bee er be ee Eees 35 VEU ER 36 MAE 36 T 37 37 37 38 38 ST PS 38 39 FUNCTIONS FOR CONSTANT STEAM PROPERTIES eene nnne 39 Examples 40 SteamTab V4 0 i CuemicaLocic List of Tables TABLE 1 OVERVIEW OF STEAMTAB FU
24. ct the steam property you want Use the mouse or the cursor keys to scroll through the list of available steam properties until you come to the one you desite 5 Provide an output cell reference Notice that SteamTab has already filled this in with the currently selected cell reference If this is not where you want the results to go select or type in a different cell reference 6 Click OK SteamTab will calculate the requested steam property and place it in the specified output cell as a formula If you want a different superheated or subcooled steam property simply repeat the above steps Alternatively you could copy the cell containing the supetheated subcooled steam property function and paste it in the location you want You can then use the superheated subcooled dialog box to change the output steam property Figure 6 Superheated Subcooled Dialog Box Superheated Subcooled Steam Properties Pressure bar Steam Property Temperature C Output to Cell 14 SteamTab V4 0 CuemicaLocic Tip Click on a cell where you want the results before opening this dialog box SteamTab will automatically fill in the Output cell reference If you activate the constant property dialog box on a cell that already contains a constant property SteamTab function then SteamTab will automatically initialize the dialog box with the correct values Click here to drop down the list box and to select the desired out
25. e specified pressure and entropy Syntax STPS pressure entropy property code units Remarks The specified pressure unit must in bar if units is 0 and must be in psia if units is 1 The specified entropy unit must be in kJ kg C if units is 0 and must be in Btu lb F if units is 1 SteamTab V4 0 CuemicaLocic STPU Calculates superheated vapor or subcooled liquid property at the specified pressure and internal energy Syntax STPU pressure internal_energy property_code units Remarks The specified pressure unit must in bar if units is 0 and must be in psia if units is 1 The specified internal energy unit must be in kJ kg if units is and must be in Btu Ib if units is 1 Functions for Constant Steam Properties SteamTab V4 0 The functions in this category return constant steam properties such as the molecular weight critical properties and triple point properties The constant steam property functions are Function STMW STTC STPC STVC STRC STZC STTPT STTPP Calculates Metric SI Units Molecular weight kg kmol Critical temperature C Critical pressure bar Critical specific volume m ke Critical specific density kg m Critical compressibility factor dimensionless Triple point temperature Triple point pressure bar English Units Ib Ibmol psia lb ft dimensionless sF psia All of the functions in this category take a
26. en below 1 Layout the problem definition It is good practice to first lay out the problem definition Follow these steps a In cell A1 type Specified Temperature In cell B1 type C for the units In cell C1 type 225 In cell A2 type Vapor Enthalpy po pom In cell B2 type kJ kg the units in which SteamTab is to return the enthalpy In cell type Liquid Enthalpy h In cell A4 type Enthalpy of Vaporization Copy the contents of cell B2 to cell B3 and B4 i Expand the width of column A so that you can see all of its contents 2 Set the steam property options Since we will be using the SteamTab dialogs to obtain properties we will first the steam property options to use the metric SI units 23 CuemicaLocic Excel users should first check on the cell check box next to the value edit box before typing in C1 You may notice a slight delay the first time you use SteamTab This is normal because the spreadsheet application loads the full SteamTab package only when you first use it This helps conserve memory 3 a b From the SteamTab pop up menu select Options Click on the Metric SI radio buttons Click OK Use SteamTab to get the vapor enthalpy In this step you will use SteamTab to get the vapor enthalpy at a temperature of 225 C a b Click on cell C2 to make it the active cell From the Tools menu pop up the SteamTab menu and select Saturated In the saturated steam pr
27. ess 21 CuemicaLocic Example 1 Enthalpy of Vaporization Problem Statement Solution 22 This rather simple example will illustrate how to use SteamTab to obtain the enthalpy of vaporization of steam Note that the enthalpy of vaporization is not one of the properties that is automatically calculated by SteamTab Note SteamTab V4 0 now includes this property However it is nearly effortless given the ease of use of SteamTab in a spreadsheet computing environment Calculate the enthalpy of vaporization of water at temperatures of 225 C and 231 3 The enthalpy of vaporization of water is defined as the difference between the enthalpies of the vapor and the liquid Therefore all that we need to do is use SteamTab to get the saturated vapor and liquid enthalpies at the specified temperature and take the difference of the two values to get the enthalpy of vaporization If you have access to printed steam tables looking up the enthalpy of vaporization at a particular temperature is very easy especially if you do not have to interpolate between the tabulated temperatures For example you could easily look up the enthalpy of vaporization at 225 C since most printed steam tables are tabulated at increments of 5 C and some even at 1 C increments However you would have to interpolate to get the enthalpy of vaporization at a temperature of 231 3 C This process becomes tedious if you have several such points to comp
28. essute P Entropy S STPS Pressure P Internal Energy U 5 All of these functions have a similar syntax and arguments as described below General Description General Syntax STXX first variable second variable property code units Replace STXX with the appropriate function name General Arguments first variable is the first independent variable second variable is the second independent variable property code is an integer property code that specifies the type of property required See Table 2 Property Codes for Thermodynamic and Transport Properties of Steam page 31 for a listing of valid property codes and their meaning Units is an integer argument optional in Excel For Metric SI units specify a value of 0 or leave empty in Excel For English units specify a value of 1 General Hemarks e If any of the arguments are invalid or if the arguments are outside the acceptable bounds the function returns the following error codes 35 CuemicaLocic 36 In Excel versions VALUE error In Lotus versions ERR error e Some of these functions solve for the pressure iteratively Therefore it is possible that the function may fail to converge in which case the function returns the above error codes The individual functions are documented below STTP Calculates superheated vapor or subcooled liquid property at the specified temperature and pressure Syntax STTP temperature pressure p
29. fice14 LIBRARY SteamTal Language English United States Once a reference to SteamTab is established you can use the SteamTab functions in VBA just as you would any other function as shown below SteamTab V4 0 17 CuemicaLocic 7 Microsoft Visual Basic for Applications ts_diagram_iapws95 xls Module Code File Edit View Insert Format Debug Run Tools Add Ins Window Help Ty sane 9 aa NOS 8 Project VBAProject X General HXCalcEff Option Explicit 9 44 atpvbaen xls ATPVBAEN XLAV 3 2 88 MoistAirTab MoistAirTab xla Function HXCalcEff temperature As Double pressure As Double As Double 2 88 Solver SOLVER XLAM HXCalCEff temperature pressure H 3 SteamTab SteamTab xla End Function STTP Bwat temperature As Double ByVal pressure As Double ByVal property code As String ByVal units 12 88 VBAProject FUNCRES XLAM 19 4 VBAProject ts diagram iapw 22 85 Microsoft Excel Objects Chart1 Temperature Enthe Sheet2 Constant Quality Sheet3 Constant Pressure sheet4 Constant Enthalpy Sheet5 Constant Density ThisWorkbook Modules t 05 28 References n4 Col48 Tips and Tricks 18 Below is a list of tips that users like you have contributed to help the SteamTab user community gain the best possible benefit of using SteamTab in a spreadsheet computing environment
30. hat you specify from the option dialog box You can access the SteamTab options from either the SteamTab pop up menu or from any of the other SteamTab dialog boxes Use the following steps to set the SteamTab options see Figure 4 for an illustration of the SteamTab options dialog box 1 Select units Select the Metric radio button if you want properties in Metric SI units or select the English radio button for properties English units SteamTab V4 0 CuemicaLocic Use this group to select the units See the Chapter Function Reference on page 29 for a description of SteamTab functions SteamTab V4 0 2 Select comment option Check the comments box if you want SteamTab to place a comment regarding the property calculated and the units in the output cell 3 Click OK Click on the OK button to accept the changes After you have clicked OK all of the SteamTab dialog boxes will use the specified units options Note If you typically work with only one set of options you need to only specify them once SteamTab will remember the options even in subsequent sessions Figure 4 Steam Property Options Dialog Steam Property Options T Add note text to output cell Using the Saturated Steam Properties Dialog Box The saturated steam properties dialog box helps you in calculating saturated vapor or liquid steam properties at either specified temperature or specified pressure This dialog box automatically
31. he Commonwealth of Massachusetts U S A excluding the application of its conflicts of law rules This Agreement will not be governed by the United Nations Convention on Contracts for the International Sale of Goods the application of which is expressly excluded If any part of this Agreement is found void and unenforceable it will not affect the validity of the balance of the Agreement which shall remain valid and enforceable according to its terms You agree that the SOFTWARE will not be shipped transferred or exported into any country or used in any manner prohibited by the United States Export Administration Act or any other export laws restrictions or regulations This Agreement shall automatically terminate upon failure by you to comply with its terms This Agreement may only be modified in writing signed by an authorized officer of ChemicaLogic Corporation U S GOVERNMENT RESTRICTED RIGHTS The SOFTWARE and or user documentation are provided with RESTRICTED AND LIMITED RIGHTS Use duplication or disclosure by the Government is subject to restrictions as set forth in subparagraph c 1 ii of The Rights in Technical Data and Computer SOFTWARE clause at DFARS 252 227 7013 subparagraphs c 1 and 2 of the Commercial Computer SOFTWARE Restricted Rights at 48 CFR 52 227 19 as applicable Manufacturer contractor is ChemicaLogic Corporation 99 South Bedford Street Suite 207 Burlington MA 01803 USA SteamTab is Copyright 1995 2010 by
32. heet s charting capability Export of steam property values to other applications limited only by the spreadsheet s file transfer capability SteamTab V4 0 CuemicaLocic Examples for Expander Compressor Pressure Letdown Relative Humidity etc What s New in Version 4 0 SteamTab Version 4 0 offers a number of enhancements SteamTab V4 0 supports Excel versions 2003 2007 and 2010 running on Windows 7 Windows Vista and Windows XP e Supports both 32 bit and 64 bit Excel 2010 e Includes automatic installation and uninstalling on the supported platforms Fully compatible with all previous versions of SteamTab e The ability to use a numeric property code as well as mnemonic string the string version is case insensitive For example to calculate the enthalpy of steam you can use either 8 or H e Added two new properties the isentropic exponent and latent heat of vaporization Technical Support and Contact Information ChemicaLogic offers free technical support with the purchase of SteamTab If you have any problems during installation or use of SteamTab please contact us at one of the addresses listed below Before requesting support it would save both your time and our time if you could first do the following Make sure you have read any relevant portions of the manual Isolate the problem to a small test case Have the version number of your copy of SteamTab ready Have the
33. ified pressure and enthalpy P H at specified pressure and entropy 5 at specified pressure and internal energy P U Constant properties functions STMW STTC STPC STVC STRC STZC STTPT STTPP Molecular weight Critical temperature Critical pressure Critical specific volume Critical specific density Critical compressibility factor Triple point temperature Triple point pressure Calling Sequence STPSAT pressure quality code units STTSAT temperature quality code units STTP temperature pressure code units STTV temperature volume code units STTH STTS temperature enthalpy code units temperature entropy code units STTU temperature internal energy code units STPV pressure volume code units STPH pressure enthalpy code units STPS pressure entropy code units STPU pressure internal energy code units STMW units STTC units units units STRC units STZC units STTPT units STTPP units In Microsoft Excel units is an optional argument You need not specify units in which case all requested properties are returned in Metric SI units that is the default value is 0 For steam properties in English units set units to 1 The argument quality is used to specify the saturated steam quality vapor fraction or to specify the two phase steam quality Use a value of 1 for saturated vapor 0 for saturated liquid and between 0 and 1 for two phase The
34. install the add in within Excel as well as certain example files document files and the online help file To install SteamTab simply click on the file SETUP STEAMTAB EXE and follow the instructions on the screen Note Before installing SteamTab on your machine please make sure that Excel is not running SteamTab V4 0 7 CuemicaLocic Once installation is complete you can access SteamTab from Excel If you need to access the User s Guide and other documents at are installed go to Window s Start menu click on Programs and you should see a folder called ChemicaLogic SteamTab as shown below Figure 1 ChemicaLogic SteamTab on Window s Start Menu Using SteamTab A pop up menu which is also known as a drop down menu is a special menu item that displays a sublist of menu items when it is selected The following sections describe how to access and use the various features of SteamTab Where is SteamTab As an add in package to your spreadsheet application SteamTab quietly becomes a part of your spreadsheet You only see it when you need to use it Just to make sure that SteamTab is available 1 Start your spreadsheet application if you have not already started it 2 Excel 2003 Users Click on the Tools menu You should see a SteamTab pop up menu somewhere near the bottom of the Tools menu Excel 2007 or 2010 Users Click on the Add ins ribbon and you will see the SteamTab menu 3 Expand the
35. n integer argument units optional in Excel which is 0 or Metric units For constant properties in English units set this argument to 1 39 CuemicaLocic 40 Note Excel Only If you want to use the default argument you need not specify any value In this case Excel users must use the empty parenthesis for example STTC Examples 1 STMW returns 18 0152 which is the molecular weight of steam in kg kmol 2 STPC 1 returns 3198 8 which is the critical pressure of steam in psia 3 5 0 returns 0 01 which is the triple point temperature of steam in C en tro py en tro py noun plural en tro pies 1 Symbol S For a closed thermodynamic system a quantitative measure of the amount of thermal energy not available to do work A measure of the disorder or randomness in a closed system A measure of the number of bits necessary to transmit a message as a function of the probability that the message will consist of a specific set of symbols A hypothetical tendency for all matter and energy in the universe to evolve toward a state of inert uniformity Inevitable and steady deterioration of a system or society SteamTab V4 0
36. n this function located on the lower left corner of the function wizard SteamTab V4 0 CuemicaLocic Using SteamTab in Excel s Visual Basic for Applications VBA You can also use the SteamTab functions in you own mactos or functions in Excel s VBA But before you use the SteamTab functions you need to establish a reference to the add in from the VBA editor To establish a reference to the SteamTab add in start the VBA editor in Excel 2003 from the Tools Macro Start Visual Basic Editor or press the Alt F11 keys or in Excel 2007 2010 from the Developer tab select Visual Basic if you do not see the Developer tab please refer to this document on how to show the Developer tab http msdn microsoft com en us library bb608625 aspx The Visual Basic editor comes up and from the Tools menu Select References and place a check mark next to SteamTab and select OK Figure 10 Excel VBA Reference to SteamTab References VBAProject Available References v Visual Basic For Applications Cancel v Microsoft Excel 14 0 Object Library OLE Automation Microsoft Office 14 0 Object Library Browse atpvbaen xls Microsoft Forms 2 0 Object Library MoistAirTab Ref Edit Control Priority Solver Help SteamTab l VBAProject Accessibility Cpl dmin 1 0 Type Library Acrobat Arcrohat Access Tyne 4 SteamTab Location C Program Files Microsoft Office Of
37. nd media and you do not retain any copies COPYRIGHT The SOFTWARE is owned by ChemicaLogic Corporation and its structure organization and code are the valuable trade secrets of ChemicaLogic The SOFTWARE is also protected by United States Copyright Law and International Treaty provisions You agree not to modify adapt translate reverse engineer decompile disassemble or otherwise attempt to discover the source code of the SOFTWARE You may use trademarks only to identify printed output produced by the SOFTWARE in accordance with accepted trademark practice including identification of trademark owner s name Such use of any trademark does not give you any rights of ownership in that trademark Except as stated above this Agreement does not grant you any intellectual property rights in the SOFTWARE TRANSFER You may not rent lease or sub license the SOFTWARE You may however transfer all your rights to use the SOFTWARE to another petson or entity provided that you transfer this Agreement with the SOFTWARE LIMITED WARRANTY For ninety 90 days from your date of purchase ChemicaLogic warrants that the magnetic media and the user documentation if any are free from defects in material and workmanship ChemicaLogic will at its option either refund the amount you paid or provide you with corrected items at no charge provided that the defective item s is are returned to ChemicaLogic within ninety 90 days from the date of purchase Except as
38. ocic Click here to drop down the list box and to select the desired output steam property See the Chapter Function Reference on page 29 fora description of SteamTab functions SteamTab V4 0 Figure 5 Saturated Steam Properties Dialog r Saturated Steam Properties Independent Variable Temperature Value C F 25 D Pressure Phase Steam Property Pressure bar Output to Cel F 33 Using the Superheated Subcooled Steam Properties Dialog Box The supetheated subcooled dialog box helps you in calculating supercritical or subcooled steam properties You also use this dialog box to model constant property processes such as isenthalpic isentropic constant volume etc Using this dialog box automatically creates a call to the appropriate SteamTab function based on the input parameters you supply The following steps show you how to use this dialog box see Figure 6 for an illustration of the superheated subcooled dialog box 1 Select Options Click on the Options button to bring up the options dialog box from where you can select the units as described in the previous section If you previously selected the units you can skip this step Select independent variables Unlike saturated properties calculating superheated or subcooled properties requires two independent variables SteamTab gives you 9 combinations of independent variables that you can choose from Temperature and any one
39. of Pressure Volume Enthalpy Entropy or Internal energy or Pressure and any one of Volume Enthalpy Entropy or Internal energy a Select the first independent variable Use the drop down list to select either Temperature or Pressure as the first independent variable 13 CuemicaLocic Depending on your choice of units and independent variables the drop down list box will show you the units in which the values are required Ti Click on a cell where you want the results before opening this dialog box SteamTab will automatically fill in the Output cell reference If you activate the superheated subcooled dialog box on a cell that already contains a SteamTab function then SteamTab will automatically initialize the dialog box with the correct values First Independent Variable Second Independent Variable Click here to drop down the list box and to select the desired output steam property b Select the second independent variable Use the drop down list box to select the second independent variable The choices available will depend on what you chose as the first independent variable 3 Provide values for the independent variables Type a number in each of the edit boxes next to the independent variable selections Alternatively you can type in or select a cell reference that contains a value for the specified independent variables 4 Select steam property required Using the drop down combo box sele
40. operties dialog box select Temperature as the independent variable Type C1 in the value edit box Select Vapor as the phase Use the drop down list box and locate Enthalpy as the required steam property Note that the Output Cell is already filled in with C2 Click OK The cell C2 should now contain the value 2802 148 Notice that cell C2 actually contains a formula which looks like the following For Excel users STTSAT C2 1 8 0 For Lotus 1 2 3 users STTSAT C2 1 8 0 Use SteamTab to get the liquid enthalpy Use the following steps to get the enthalpy of liquid at 225 C Copy the contents of cell C2 to cell C3 Make sure that cell C3 is the active cell From the Tools menu pop up the SteamTab menu and select Saturated Notice how SteamTab fills in all of the right values in the dialog box Select Liquid as the phase and click OK The cell C3 should contain the value 966 796 which is the specific enthalpy of liquid at 225 C Calculate the enthalpy of vaporization In cell C4 type the formula C2 C3 and press Enter You now have the answer 1835 352 kJ kg Extend the result to 231 3 Copy the cells C1 through C4 to cells D1 through D4 Then change the value in D1 to 231 3 The numbers is D2 D3 and D4 change automatically to their proper values If you have been working along Figure 11 on page 23 shows what your spreadsheet should look like 24 SteamTab V4 0 CuemicaLocic Example 2 Constant Property Process P
41. or Repair Tum Windows features on or et Organize Unina Iratall a program from the network Publier Installed On A Adobe Acrobat 9 Pro lt English Francais Deutsch Adobe Systems 08 26 2010 BB Asede Flash Player 10 Activex Adobe Systems Incorporated 08 26 2010 1018236 MFL Pro Suite MFC 88600N Brother Industries Ltd 01 22 2010 1000 Wi ChemicaLogic MoistAirTab version 20 ChemicaLogic Corporation 09 09 2010 20 Lx Shemisahogis 0 Corporrbon d Compatibility Pack for the 2007 Office system Microsoft Corporation 68 11 2010 12054251000 Gi Dotfuscator Software Services Community Edition Prekmptive Schutions 04 29 2010 52 2000 Google Earth Google 08 31 2010 5211547 Googie Toolbar tor Internet Explorer Googie lnc 94 29 C HTML Help Workshop 68 12 2000 Setup version 5310 Jordan Russell 08 17 2010 5340 B Intel R Graphics Media Accelerator Oriver Intel Corporation 04 28 2010 81510199 SEEK Enghsh Runtime Vantage 04 02 3010 009 000 0002 Df Kaspersky Anti Vins 2010 Kaspersky Lab 01 22 2010 007 2 Microsoft Framework 4 Client Profile Microsoft Corporation 04 29 2010 4230119 Microsoft NET Fromework 4 Extended Microsoft Corporation 04 29 2010 403089 I Mscresoft Framework 4 Multi Targeting Pack Microsoft Corporation 04 29 2010 4030319 WH Microson ASP NET MVC 2 Microsoft Corporation 04 29 2010 20502170 Micronit 452
42. or select a cell reference that contains a value for the specified independent variable 4 Select phase Select either Vapor or Liquid for saturated properties For two phase properties select Quality and specify the steam quality as a value between 0 and 1 5 Select steam property required Using the drop down combo box select the steam property you want Use the mouse or the cursor keys to scroll through the list of available steam properties until you come to the one you desire 6 Provide an output cell reference Notice that Steam Tab has already filled this in with the currently selected cell reference If this is not where you want the results to go select or type in a different cell reference 7 Click OK SteamTab will calculate the requested steam property and place it in the specified output cell as a formula Note The specified independent variable must be greater or equal to the triple point and less than or equal to the critical point of steam If the specified independent variable is outside these bounds the SteamTab function returns the VALUE error in Excel versions or the ERR error in Lotus versions If you want a different saturated steam property simply repeat the above steps Alternatively you could copy the cell containing the saturated steam property function and paste it in the location you want You can then use the saturated dialog box to change the output steam property SteamTab V4 0 CuemicaL
43. put steam property Using the Constant Steam Properties Dialog Box The constant steam properties dialog box gives you access to fundamental steam properties such as molecular weight critical properties and triple point properties The following steps illustrate how to use this dialog box see the figure below for an illustration of this dialog box 1 Select Options Click on the Options button to bring up the options dialog box from where you can select the units as described in the previous section If you previously selected the units you can skip this step 2 Select constant steam property required Using the drop down combo box select the constant steam property you want Use the mouse or the cursor keys to scroll through the list of available steam properties until you come to the one you desire 1 Provide an output cell reference Notice that SteamTab has already filled this in with the currently selected cell reference If this is not where you want the results to go select or type in a different cell reference 2 Click OK SteamTab will calculate the requested steam property and place it in the specified output cell as a formula If you want a different constant steam property simply repeat the above steps Alternatively you could copy the cell containing the constant steam property function and paste it in the location you want You can then use the constant properties dialog box to change the output steam property
44. re P psia 120 00 1 700 00 1 700 00 8 Steam Quality 96 100 096 ss SS 9 Compression Efficiency 75 00 10 Isentropic Efficiency 11 Temperature oF 34127 1 178 29 1 011 03 12 Enthalpy Btu lb 1 190 38 1 590 54 1 490 50 H13 Entrepy Btu Ib F 1 5870 1 6523 1 5879 14 Density Ib ft3 0 27 1 83 2 10 ma 16 Specific A Btu lb 400 17 Total Ah Btu hr 40 016 66 18 Power hp 15 72 20 SS Superheated or subcooled t Compressor TCI Ready Sum 100 00 Nernst Walther Hermann Nernst n rnst Walther Hermann 1864 1941 German physicist and chemist He won a 1920 Nobel Prize for his work in thermochemistry particularly his proposal of the third law of thermodynamics 1906 SteamTab V4 0 CuemicaLocic Overview SteamTab V4 0 Chapter Function Reference spelling is Wobbly It s good spelling but it W obbles and the letters get in the wrong places A A Milne 1882 1958 Winnie the Pooh ch 6 1926 The SteamTab add in package is based on a set of 19 core functions that together calculate over 30 thermodynamic and transport properties of steam You can use these functions directly in your spreadsheet or you can use SteamTab s easy to use dialog boxes to automatically generate the appropriate function call with the correct arguments SteamTab functions are divided into three categories 1 Functions for saturated vapor liquid or two phase properties 2 f
45. roblem Statement A steam line is connected to an evacuated well insulated tank via a valve The line pressure is 120 psia and temperature is 800 F If the valve is opened and the steam is allowed to expand into the tank what is the final temperature in the tank Assume that the steam line is connected to an inexhaustible source of steam at the other end Solution Based on the laws of thermodynamics since no heat is added or removed from the system the only work done by the steam in expanding into the tank is to change the internal energy of the steam in the tank In other words the final internal energy in the tank must equal the initial enthalpy of steam in the line Also the final pressure in the tank must be equal to the pressure of steam in the line where U is internal energy and H is the enthalpy The solution to this problem is shown in Figure 12 Solution Strategy The temperature and pressure in the line are specified to be 800 F and 120 psia Since the line temperature is greater than the critical temperature of steam 705 16 F the steam is not saturated Therefore we use the superheated subcooled SteamTab functions to compute the thermodynamic properties of the steam in the line The final conditions in the tank are thus determined the final pressure in the tank is 120 psia and the internal energy is equal to the enthalpy of steam in the line Given these two variables the rest of the thermodynamic properties of steam can ea
46. roperty_code units Remarks e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 The specified pressure unit must be in bar if units is 0 and must be in psia if units is 1 Examples 1 STTP 500 200 12 1 returns 1810 1 which is the speed of sound in ft s at a temperature of 500 F and a pressure of 200 psia 2 5000 1200 21 1 retutn 0 779 which is the Prandlt number at a temperature of 5000 F and a pressure of 1200 psia STTV Calculates superheated vapor or subcooled liquid property at the specified temperature and volume Syntax STTV temperature volume property code units Remarks e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 e The specified volume unit must be in m if units is 0 and must be in ft lb if units is 1 SteamTab V4 0 CuemicaLocic SteamTab V4 0 STTH Calculates superheated vapor or subcooled liquid property at the specified temperature and enthalpy Syntax STTH temperature enthalpy property_code units Remarks e The specified temperature unit must be in C if units is 0 and must be in F if units is 1 The specified enthalpy unit must be in kJ kg if units is 0 and must be in Btu Ib if units is 1 STTS Calculates superheated vapor or subcooled liquid property at the specified temperature and entropy Syntax STTS temperature entropy property code units
47. sily be computed SteamTab contains 9 combinations of independent variables you can specify and one of them is pressure P and internal energy U Figure 12 Tutorial Example 2 111 2 iiia 3 Pressure P 120 00 120 00 P2 P Temperature T F 80020 1137 52 Answer 5 enthalpy H Bum 1428 97 160445 internar Eneroy U Btul 129141 342897 Uz Using a strategy similar to the one in tutorial example 1 we first design and layout the problem definition The known and computed variable names are SteamTab V4 0 25 CuemicaLocic Step by step Instructions documented in Column A Column B contains the units in which the properties are computed Column C contains the line conditions and column D the tank conditions Cells C3 and C4 contain the specified line pressure and temperature respectively Cell D3 simply refers to the value in cell C3 since the final pressure is the same as the line pressure Using SteamTab s superheated subcooled dialog box and using temperature and pressure as the independent variables we compute the enthalpy and internal energy shown in cells C5 and C6 We then refer the contents of cell D6 to the value in cell C5 since the final internal energy is the same as the initial enthalpy Again using Steam Tab s superheated subcooled dialog box with pressure and internal energy as the independent variables we obtain the final
48. specifically provided herein ChemicaLogic makes no warranty representation promise or guarantee either express or implied statutory or otherwise with respect to the SOFTWARE including but not limited to implied warranties of merchantability fitness for a particular purpose and noninfringement ChemicaLogic is not responsible for and does not make any representation warranty or condition concerning product media software or documentation not manufactured or supplied by ChemicaLogic such as third parties programs that are designed to use or include the SOFTWARE LIMITATION OF LIABILITY Because software is inherently complex and may not be completely free of errors you ate advised to verify your work and to make backup copies In no event will ChemicaLogic be liable for any damages whatsoever including without limitation damages for loss of business profits business interruption loss of business information or other pecuniary loss arising out of the use of or inability to use the software user documentation or related technical support even if ChemicaLogic has been advised of the possibility of such damages In no case shall ChemicaLogic liability exceed the amount paid by you for the SOFTWARE Because some states do not allow the exclusion or limitation of liability for consequential or incidental damages the above limitation may not apply to you GOVERNING LAW AND GENERAL PROVISIONS This Agreement will be governed by the laws of t
49. ssure quality property code units Arguments pressure is the pressure at which the saturated steam property is required See the Remarks section for acceptable pressure units quality is 1 for vapor phase propetties O for liquid phase properties and between 0 and 1 for two phase property_code is an integer property code that specifies the type of property required See Table 2 Property Codes for Thermodynamic and Transport Properties of Steam page 31 for a listing of valid property codes units is an integer argument optional in Excel For Metric SI units specify a value of 0 or leave empty in Excel For English units specify a value of 1 Remarks e The specified pressure unit must be in bar if units is 0 and must be in psia if units is 1 SteamTab V4 0 CuemicaLocic SteamTab V4 0 The pressure must be greater than or equal to the Triple Point Pressure 0 0061173 bar and less than or equal to the Critical Pressure 220 55 bar e If any of the arguments are invalid or if the arguments are outside the acceptable bounds the function returns the following error codes In Excel versions VALUE error In Lotus versions ERR error Examples 1 STPSAT 1 of water in 2 STPSAT 1 4 7 1 0 1 returns 212 02 which is the boiling point F at a pressure of 14 7 psia 4 7 1 8 1 STPSAT 14 7 0 8 1 returns 970 18 which is the enthalpy of vaporization in Btu Ib of water
50. thermodynamic properties including the final temperature of 1137 92 The step by step instructions are left as an exercise for the user You should follow the general solution strategy described above and re create this example on yout own You can use the example included in your SteamTab package as a guide Templates and Examples 26 The SteamTab package you purchased contains several examples and templates that you can use in your work Based on your version of SteamTab for a particular spreadsheet application these templates and examples are installed and used differently This is described below SteamTab for Excel 2007 2010 If you used the automatic installation program the templates and examples are installed in My Templates directory within a sub directory called ChemicaLogic You can access these templates from within Excel by performing these steps 1 Start Excel From the File menu select New Select My Templates to see the templates and examples Shown in Figure 13 below 4 Select any one of the shown templates to create a working copy of the template An example of how to use the Compressor template is illustrated below SteamTab V4 0 CuemicaLocic SteamTab V4 0 Figure 13 SteamTab Templates for Excel 2007 2010 View Developer Add ins swe ll s Open Available Templates Home Info Recent Blot Recent Sample workbook templates templates
51. unctions These two functions calculate saturated vapor liquid and two phase properties from the triple point up to the critical point You can choose either temperature or pressure as the independent variable Functions for superheated vapor or subcooled liquid properties 9 functions The functions in this category provide you with a rich set of tools for conducting several constant property processes Depending on the choice of independent variables you can model isentropic isenthalpic constant volume or constant internal energy processes Functions for constant steam properties 8 functions The 8 functions in this category give you access to fundamental steam properties that are not functions of temperature or pressure such as molecular weight critical properties and triple point properties 29 CuemicaLocic 30 Function Note All SteamTab functions begin with the prefix ST Table 1 Overview of SteamTab Functions Calculates Saturated vapor liquid or two phase functions STPSAT STTSAT at specified pressure at specified temperature Supetheated or subcooled functions STTP STTV STTH STTS STTU STPV STPH STPS STPU at specified temperature and pressure at specified temperature and volume 1 1 at specified temperature and enthalpy at specified temperature and entropy I S at specified temperature and internal energy I U at specified pressure and volume at spec
52. ute or if you need to interpolate several different properties Using the power of SteamTab and the ease of use of spreadsheets this process becomes nearly effortless The solution to this problem is show in Figure 11 below SteamTab V4 0 CuemicaLocic Step by step Instructions See Table 1 on page 19 for a listing of steam properties and their Metric SI and English units SteamTab V4 0 Figure 11 Tutorial Example 1 A B D E 1 Specified Temperature 225 231 3 2 Vapor Enthalpy kJ kg 2802 148 2803 015 3 Liquid Enthalpy kJ kg 966 796 996 3022 4 Enthalpy of Vaporization kJ kg 1835 352 1806 713 5 6 The first step in solving a problem in a spreadsheet is to layout the problem definition As shown in the figure above the known and computed variable names are documented in Column A Column B contains the units in which the properties are computed Column C contains the specified and computed properties at the first temperature and column D contains the same at the other temperature Using SteamTab obtain the saturated vapor and liquid enthalpies at 225 C shown in cells C2 and C3 In cell C4 take the difference between C2 and C3 to get the enthalpy of vaporization at 225 C Then simply copy cells C1 through C4 and paste it in cells D1 through D4 Change the temperature in cell D1 to 231 3 and instantly you have the solution to the second part of the problem The step by step instructions for this example are giv
Download Pdf Manuals
Related Search