Home

Steam Calculator User Manual

1. C for Metric units system or F for English units system Acceptable values between 0 C and 800 C pressure Enthalpy in kJ kg for Metric units system or Btu Ib for English units system Acceptable values between 0 041587373 kJ kg and 4500 kJ kg e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations O for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the pressure iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 16 of 24 Steam Calculator SCTS Syntax SCTS temperature entropy outputCode umSystem Description Calculates the steam properties at the specified temperature and entropy Parameters e temperature Temperature in C for Metric units system or F for English units system Acceptable values between 0 C and 800 C e entropy Entropy in kJ kg C for Metric units system or Btu Ib F for English units system Acceptable values between 0 00015455 kJ kg C and 12 kJ kg C e outputCode specifies the property to be calculated See the Properties table e umSyst
2. installed and if an Internet connection is available during the setup process e NET Framework 4 0 Client Profile e Windows Installer 3 1 Installation The add in is delivered as a zip package containing the installation kit and the necessary prerequisites downloadable Steam Calculator is built using the NET Framework 4 0 technology which is included as web installer in the installation package and will be installed on the target machine during the setup process Steam Calculator is installed for current user only so the setup does not require elevated privileges However NET Framework 4 0 Client Profile requires administrator privileges If needed a computer administrator can download and install NET Framework 4 0 Client Profile prior Steam Calculator installation using the following address http go microsoft com fwlink Linkld 131000 Installation steps e Unzip the installation package in a local folder on the target machine Browse the folder and run setup exe e f prerequisites NET Framework 4 0 Client Profile Windows Installer 3 1 are not already installed on the target machine the setup will continue with the prerequisites download and installation Please accept the License Agreements and confirm the prerequisites installation e Once the prerequisites are installed the setup may prompt you to restart the machine Choose yes to restart the machine at this moment e After restart the setup will continue with the Steam Ca
3. of 24 ei Steam Calculator Esat Psat x tp e pn ees arm ens eeue e enu tv S Calculates the saturated steam properties atthe specified pressure and steam quality Excel function SCPX Input Output Pressure Value Pr feet psia Cell N 328 537743 l J Pressure psia 101 Enthalpy Btu b 743 991767 Values between 0 09 psia and 705 1 psia Entropy Btu b F 1 039524 Quality 05 Quality Vaue 0 Canay Ti 0 453653 Intemal Energy Btu b 702 765277 lsobaric Heat Capacity Btu b F 0 823952 Isochoric Heat Capacity Btu lb F 0 633072 Specific Volume ft3 b 2 204327 Values between 0 and 1 Speed Of Sound ft s Value Region Thermal Conductivity Btu h ft F 0 019119 Viscosity lb At h 0 070413 Surface Tension N m Value Unrlebals Cann Cannons Bb ART 11C RORAAY Cell 4 Region IAPWS 97 4 a a a a a a a a Ca a a English Units of Measure System Remarks e When switching the UM System all the inputs and outputs are reevaluated according to the new selection The selection is persisted as a user preference 5 Find formulas To find a Steam Calculator formula in the active workbook or worksheet select Find formulas from the menu or press the Find formulas button A new dialog window will be opened and you can select the formulas you are searching for f Find Steam Calculator formulas Find what O All functions SCTX ce Search wit
4. of the Software received from the Licensor or made in connection with this License and all documentation relating thereto and Licensee shall provide Licensor with a certificate if requested certifying that the same has been done and any rights of the Licensee to use the Software shall cease 2 License grant This is a license agreement and NOT an agreement for sale American Process Inc continues to own the copy of the SOFTWARE contained on the disk and all other copies that you are authorized by this LICENSE to make Your rights to the SOFTWARE are specified in this LICENSE and American Process Inc retains all rights not expressly granted to you in this LICENSE American Process Inc hereby grants to you and you accept a non exclusive non transferable license to use copy and modify the SOFTWARE only as authorized below provided that the Licensee has paid the appropriate License Fees the Licensor grants to the Licensee in the country where the Software was downloaded for the term of this License a limited personal non exclusive non sub licensable and non transferable license 3 Permitted uses This LICENSE grants you the following rights 3 1 The SOFTWARE is licensed per individual user developer You may make copies on more than one computer as long as the use of the SOFTWARE is by the same user developer 3 2 Solely with respect to electronic documents included with the SOFTWARE you may make a copy for each developer for which the Softwar
5. temperature iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 18 of 24 Steam Calculator SCPV Syntax SCPV pressure specific volume outputCode umSystem Description Calculates the steam properties at the specified pressure and specific volume Parameters pressure pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 100000 kPa specific volume Specific volume in m3 kg for Metric units system or ft3 lb for English units system Acceptable values between 0 00095669 m3 kg and 1000 m3 kg outputCode specifies the property to be calculated See the Properties table umSystem specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the temperature iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 19 of 24 Steam Calculator SCTU Syntax SCTU temperature internal energy outputCode umSystem Description Calculates t
6. ITHER EXPRESS OR IMPLIED WHETHER ARISING BY STATUTE OR OTHERWISE IN LAW OR FROM A COURSE OF DEALING OR USAGE OR TRADE INCLUDING BUT NOT LIMITED TO ANY IMPLIED WARRANTIES OF ACCURACY COMPLETENESS PERFORMANCE CURRENCY MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE SOFTWARE 8 Limitation of liabilities American Process Inc liability whether in contract or otherwise arising out of Licensee s use of or in connection with the SOFTWARE or otherwise under this Agreement shall not exceed the amount of the license fee paid by you to American Process Inc INNO EVENT SHALL AMERICAN PROCESS BE LIABLE FOR ANY SPECIAL INCIDENTAL INDIRECT OR CONSEQUENTIAL DAMAGES WHATSOEVER INCLUDING WITHOUT LIMITATION DAMAGES FOR LOSS OF BUSINESS PROFITS BUSINESS INTERRUPTION LOSS OF BUSINESS INFORMATION OR ANY OTHER PECUNIARY LOSS ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE EVEN IF AMERICAN PROCESS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES 2008 2011 American Process Inc All right reserved Page 23 of 24 Steam Calculator About American Process I nc American Process Inc has become the premier consulting firm for the application of thermal Pinch technology the ultimate methodology to identify energy savings We boast the world s largest experience list and have completed over 200 studies and identified potential annual savings of US 500 million for our clients Although best known in the pulp a
7. Steam Calculator Overview Introduction Steam systems are a part of almost every major industrial process today Chemical processes are significant energy consumers in view of their large heating demands The chemical industry uses steam for a wide variety of purposes the most important being process heating drying or concentrating steam cracking and distillation Steam Calculator is an engineering tool built as an MS Excel add in used to calculate thermodynamic and transport properties of steam It calculates 22 properties such as temperature pressure enthalpy entropy quality internal energy viscosity thermal conductivity surface tension etc The calculations are based on the IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam revised release August 2007 supplemented with additional backward equations and transport properties equations These equations can predict the water and steam properties on a very large scale of pressure and temperature solid phase compressible liquid Pressure supercritical fluid critical pressure Per critical point liquid phase Pp triple point superheated vapour gaseous phase critical temperature Tip Ter Temperature Phase diagram The phase diagram shows that at the interfaces between solid and liquid liquid and gas and solid and gas it is possible for more than one phase to exist in equilibrium The point at which all three phases com
8. apacity kJ kg C 1 930698 Isochoric Heat Capacity kJ ka C 1 454282 x 4 Specific Volume m3 kg 18 098975 x Values between 0 and 1 Speed Of Sound m s 437 769969 Region Thermal Conductivity W m C 0 0196 i Viscosity uPa s 10 353492 J Region IAPWS 97 4 Surface Tension N m 0 06935 Fx Unlebabs Cena Cannes N I Anl 4167207901 a Merc _ Fndferulos 1 Input panel Input panel is used to provide either a value or a cell reference for the input parameter The user is able to select a cell reference as an input by clicking on Cell radio button and pressing the Browse button A Browse for input dialog window is displayed Select the input range for Pressure kPa 048 Remarks Once all the input are filled up with values or cell references the outputs are automatically calculated in the Output panel e Ifthe input values are outside limits a warning is displayed next to the input 2 Output panel The Output panel is used to display the list of calculated values for the available function outputs To paste the corresponding formula in an Excel cell click on the corresponding Browse button and select a cell to insert the formula Select the output range for Temperature C E S Remarks e Some output values may not have meaning in some regions therefore Value is displayed e To complete the formulas insertions press OK button and all the formulas from all tabs are automatica
9. e has been licensed as described in section above provided that such copies shall be used only by such developer for internal purposes and are not to be republished or distributed to any other third party C You may use the evaluation versions of the SOFTWARE for the limited purposes of demonstrations trials and design time evaluations 4 Restricted uses You may not without the prior written permission of American Process Inc 4 1 Disassemble decompile or unlock decode or otherwise reverse translate or engineer or attempt in any manner to reconstruct or discover any source code or underlying algorithms of SOFTWARE provided in object code form only 4 2 Use copy modify or merge copies of the SOFTWARE and any accompanying documents except as permitted in this LICENSE 4 3 Transfer rent lease or sublicense the SOFTWARE 5 Copyright All title and copyrights in and to the SOFTWARE are owned by American Process Inc The SOFTWARE is protected by United States copyright laws and international treaty provisions All rights are reserved worldwide You must treat the SOFTWARE like any other copyrighted material except that you may in addition to the copies permitted in this LICENSE make one copy of the SOFTWARE solely for backup or archival purposes No part of the accompanying printed materials may be reproduced transmitted transcribed stored in any retrieval system or translated into any language by any means without the express prior
10. e together is the triple point and represents the temperature and pressure for which all three states of matter coexist For water this is 273 16 K at 611 2 Pa The other labeled point on the diagram is called the critical point also called critical state At this point the liquid and gaseous phases of a pure stable substance become identical for water this is at 647 096 K and 22064000 Pa IAPWS equations deal with the regions above triple point pressure and 0 C up to 100 MPa and 800 C and for high temperatures up to 50 MPa and 2000 C P kPa IAPWS Regions 100000 80000 60000 40000 20000 T 0 200 400 600 800 1000 1200 1400 1600 1800 2000 T C IAPWS Regions Page 1 of 24 Region 1 corresponds to the liquid phase region 2 to the vapor phase region 3 to the supercritical fluid phase region 4 represents the saturation line between liquid and vapor phase and region 5 the high temperature vapor region Most of the Steam Calculator functions use basic or backward equations to calculate the properties of water and steam However some functions use iterative algorithms which in some cases may fail to converge The properties can be calculated in two ways with Steam Calculator 1 Using the visual interface which is available from the Steam Calculator menu item added to the MS Excel Tools menu Excel 200 2003 or Steam Calculator ribbon from ChemGoodies tab Excel 2007 2010 Using the corresponding spreadsheet function
11. em specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the pressure iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 17 of 24 Steam Calculator SCPU Syntax SCPU pressure internal energy outputCode umSystem Description Calculates the steam properties at the specified pressure and internal energy Parameters e pressure pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 100000 kPa e internal energy Internal energy in kJ kg for Metric units system or Btu Ib for English units system Acceptable values between 0 042199 kJ kg and 4000 kJ kg e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations O for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the
12. eter owner 200 1510 00 Function Arguments Pressure ko gt 200 enthalpy Fio is outputCode E 0 umSystem fc Sf 0 29789483 Calculates the steam properties at the specified pressure and enthaply Returns Value error if the parameters values are invalid enthalpy is the Enthalpy in kJ kg For Metric units system or Btu lb for English units system Formula result 0 29789483 Help on this Function Cancel 6 Press OK to insert formula or Cancel to abort Remarks e The functions can be also inserted by typing the formula and its arguments directly into MS Excel cell or using the Steam Calculator user interface The function returns Value error if the parameters values are invalid e Some function solves for the temperature or pressure iteratively Therefore it is possible that these functions fail to converge in which case the function returns the VALUE error e For the calculated property s output code see the Properties table 2008 2011 American Process Inc All right reserved Page 10 of 24 Steam Calculator SCPX Syntax SCPX pressure quality outputCode umSystem Description Calculates the saturated steam properties at the specified pressure and steam quality Parameters pressure Pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 22064 kPa quality Steam quality Acceptable values between 0 and 1 out
13. feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 22 of 24 Steam Calculator License Agreement License agreement IMPORTANT NOTICE Please carefully read this License Agreement BY DOWNLOADING INSTALLING AND OR USING THE SOFTWARE OR CLICKING I ACCEPT WHEN PROMPTED IN CONJUNCTION THEREWITH YOU LICENSEE ACCEPT ALL OF THE TERMS AND CONDITIONS OF THIS LICENSE IF YOU ARE ACCEPTING THESE TERMS ON BEHALF OF ANOTHER PERSON OR LEGAL ENTITY YOU REPRESENT AND WARRANT THAT YOU HAVE FULL LEGAL AUTHORITY TO ACCEPT ON BEHALF OF AND BIND THAT PERSON OR LEGAL ENTITY TO THESE TERMS 1 Evaluation license Licensor grants Licensee the right to use a limited capabilities version of the Software upon the terms and conditions of this License for an unlimited period for the purpose of evaluating whether or not the Software meet the Licensee s requirements Upon the evaluation 1 1 The Licensee will where the Software has met Licensee s requirements and where Licensee wishes to enter into a full License become fully bound by this License and pay to Licensor the License Fee s 1 2 In the event that the Software does not meet the Licensee s requirements or where Licensee otherwise does not wish to enter into a full License Licensee shall destroy the Software and all copies in whole or in part in any form including partial copies or modifications
14. he steam properties at the specified temperature and internal energy Parameters e temperature Temperature in C for Metric units system or F for English units system Acceptable values between 0 C and 800 C internal energy Internal energy in kJ kg for Metric units system or Btu Ib for English units system Acceptable values between 0 042199 kJ kg and 4000 kJ kg e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations O for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the pressure iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 20 of 24 Steam Calculator SCTV Syntax SCTV temperature specific volume outputCode umSystem Description Calculates the steam properties at the specified temperature and specific volume Parameters e temperature Temperature in C for Metric units system or F for English units system Acceptable values between 0 C and 800 C e specific volume Specific volume in m3 kg for Metric units system or ft3 Ib for English units system Accep
15. hin a a Entire Workbook E scps O Active Worksheet Sheet 0 Value Formula N HS VALUE SCPx D2 E2 2 0 E HS VALUE SCPx D2 E2 3 0 HS HVALUE SCPx D3 E3 2 0 HS VALUE SCPX D3 E3 3 0 HS HVALUE SCPx D4 E4 2 0 ur mem ri OODATA NAM v Remarks Click on the item list with found formulas to navigate to the corresponding cell 2008 2011 American Process Inc All right reserved Page 9 of 24 Steam Calculator How to use Insert Functions from Excel Functions exposed by Steam Calculator add in are accessible using Insert Function feature of MS Excel The add in adds a new functions category named Steam Calculator which contains the list of available functions Insert Function Search for a function Type a brief description of what you want to do and then Go click Go Or select a category Steam Calculator Most Recently Used Select a function Logical SCPH pressure ent formation Calculates the steam SENERE Jd enthaply Returns Value error if the parameters values are invalid Help on this Function Cancel Usage Select the cell to insert formula in Select Insert Function menu in an opened MS Excel workbook Select the Steam Calculator Category Select the corresponding function and press OK each function displays a short description when it is selected The Functions Argument is displayed Enter a value or browse for a Cell reference for each param
16. ic units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 14 of 24 Steam Calculator SCPS Syntax SCPS pressure entropy outputCode umSystem Description Calculates the steam properties at the specified pressure and entropy Parameters e pressure Pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 100000 kPa e entropy Entropy in kJ kg C for Metric units system or Btu Ib F for English units system Acceptable values between 0 00015455 kJ kg C and 12 kJ kg C e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 15 of 24 Steam Calculator SCTH Syntax SCTH temperature enthalpy outputCode umSystem Description Calculates the steam properties at the specified temperature and enthalpy Parameters e temperature Temperature in
17. lculator components installation Click on Next in the Welcome screen select Agree in the License Agreement screen and press Next to get in the Installation Folder screen e Select an installation folder or keep the default entry and press Next Press Next in the Confirm Installation screen e Press Close on the Installation Complete screen Open Microsoft Excel and make sure that e A new ribbon named Steam Calculator is added under ChemGoodies tab MS Excel 2007 or MS Excel 2010 e Under Excel Tools menu there is a new entry named Steam Calculator containing the menu items MS Excel 2000 2002 2003 e In the Insert Function dialog there is a new category named Steam Calculator containing the Steam Calculator functions Uninstallation Use Programs and Features or Add Remove Programs feature to uninstall Steam Calculator 2008 2011 American Process Inc All right reserved Page 4 of 24 Steam Calculator Properties Current release of Steam Calculator operates with the following properties Properties Table Property Metric UM English UM outputCode Temperature C F 0 Pressure kPa psia 1 Enthalpy kJ kg Btu lb 2 Entropy kJ kg C Btu lb F 3 Quality n a n a 4 Density kg m lb ft 5 Internal Energy kJ kg Btu lb 6 Isobaric Heat Capacity kJ kg C Btu b F 7 lsochoric Heat Capaci
18. lly inserted in the corresponding cells e The functions can also be inserted using excel Insert Functions or by typing the formula directly into MS Excel cell Page 7 of 24 fe SCPX D 8 SE 8 0 0 p e r M Pressure Quality Temperature Enthalpy 101 0 5 99 884313171 1547 008 3 Region panel The Region panel displays the corresponding IAPWS regions number Pertti er een perm my ees Region Viscosity 1Pa s 48 869566 Region APw5 97 5 Surface Tension N m Value J Region Region as specified in IAPWS Industrial Formulation 1997 for the Thermodynamic Properties of Water and Steam The IAPWS IF97 divides the thermodynamic surface into five regions region 1 for the liquid state from low to high pressures region 2 for the vapor and ideal gas state region 3 for the thermodynamic state around the critical point region 4 for the saturation curve vapor liquid equilibrium region 5 for high temperatures above 1073 15 K 800 C and pressures up to 10 MPa 100 bar Remarks e Some backward functions arise difficulties and it is possible to show a region and still have Value as output this happens because the calculated temperature or pressure is out of the IAPWS limits 4 Units of Measure System The Units of Measure System used in the calculations is displayed in the bottom of the screen and can be switched by pressing the UM System button and selecting an item from the drop down list Page 8
19. mp paper sector we offer Pinch energy optimization to various industries We provide a full range of engineering services including project implementation Our references include co generation plants for which we also provided O amp M services read more American Process Inc is prominent in the cellulosic biorefinery field Our proprietary process co produces chemical feedstock for ethanol or chemicals and cellulose for pulp and paper We are a member of several consortiums comprised of major academic institutions and corporations in the forest products industry giving us access to leading technologies and testing facilities read more To support our mission for reducing energy and operating costs we have developed a suite of proprietary software products including closed loop optimization energy monitoring process simulation and benchmarking to further help our clients realize and maintain these reductions American Process Inc developed www ChemGoodies com to provide simple and effective tools to help chemical engineers on their work Our products are developed as Excel add ins that gives you access to functions and properties directly from your working spreadsheet Steam Calculator is only one of these tools visit www ChemGoodies com to download free evaluation versions or to buy our products American Process Inc founded in 1994 has offices in Atlanta USA Athens Greece and Cluj Napoca Romania 2008 2011 American Proces
20. putCode specifies the property to be calculated See the Properties table umSystem specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 11 of 24 Steam Calculator SCTX Syntax SCTX temperature quality outputCode umSystem Description Calculates the steam properties at the specified temperature and quality Parameters e temperature Temperature in C for Metric units system or F for English units system Acceptable values between 0 C and 373 946 C e quality Steam quality Acceptable values between 0 and 1 e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 12 of 24 Steam Calculator SCTP Syntax SCTP temperature pressure outputCode umSystem Description Calculates the steam properties at the specified temperatu
21. re and pressure Parameters e temperature Temperature in C for Metric units system or F for English units system Acceptable values between 0 C and 2000 C e pressure Pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 100000 kPa up to 800 C and between 0 611657 kPa and 50000 kPa up to 2000 C e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations O for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid 2008 2011 American Process Inc All right reserved Page 13 of 24 Steam Calculator SCPH Syntax SCPH pressure enthalpy outputCode umSystem Description Calculates the steam properties at the specified pressure and enthalpy Parameters pressure pressure in kPa for Metric units system or psia for English units system Acceptable values between 0 611657 kPa and 100000 kPa enthalpy Enthalpy in kJ kg for Metric units system or Btu Ib for English units system Acceptable values between 0 041587373 kJ kg and 4500 kJ kg outputCode specifies the property to be calculated See the Properties table umSystem specifies the Unit of Measure System used in calculations 0 for Metr
22. s Inc All right reserved Page 24 of 24
23. s exposed by the Steam Calculator add in Insert Function feature in MS Excel 2 2008 2011 American Process Inc All right reserved Page 2 of 24 Steam Calculator Steam Calculator versions There are two types of installation 1 Evaluation version Steam Calculator Evaluation version is a free edition with a restricted set of features There are only 3 functions enabled in the Insert Functions feature of Excel and 3 tabs enabled in the Steam Calculator Functions dialog user interface The functions available in the Evaluation version are O SCPH Calculates the steam properties at the specified pressure and enthalpy O SCPS Calculates the steam properties at the specified pressure and entropy O SCPX Calculates the saturated steam properties at the specified pressure and steam quality 2 Full version The full version exposes all the available functions to the user who has to pay a license fee 2008 2011 American Process Inc All right reserved Page 3 of 24 Steam Calculator Installation System Requirements e Operating System Windows 2000 SP4 Windows XP Windows 2003 Windows Vista Windows 7 32 bit or 64 bit editions e MS Excel 2000 MS Excel 2002 MS Excel 2003 MS Excel 2007 MS Excel 2010 32 bit or 64 bit editions e Internet connection to allow prerequisites download if not already installed Note The following prerequisites will be automatically downloaded and installed if they are not already
24. table values between 0 00095669 m3 kg and 1000 3 m kg e outputCode specifies the property to be calculated See the Properties table e umSystem specifies the Unit of Measure System used in calculations O for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function feature of MS Excel e The function returns Value error if the parameters values are invalid e This function solves for the pressure iteratively Therefore it is possible that the function may fail to converge in which case the function returns the VALUE error 2008 2011 American Process Inc All right reserved Page 21 of 24 Steam Calculator SCHS Syntax SCHS enthalpy entropy outputCode umSystem Description Calculates the steam properties at the specified enthalpy and entropy Parameters enthalpy Enthalpy in kJ kg for Metric units system or Btu Ib for English units system Acceptable values between 0 041587373 kJ kg and 4500 kJ kg entropy Entropy in kJ kg C for Metric units system or Btu Ib F for English units system Acceptable values between 0 00015455 kJ kg C and 12 kJ kg C outputCode specifies the property to be calculated See the Properties table umSystem specifies the Unit of Measure System used in calculations 0 for Metric units or 1 for English units Remarks e The function can be found in the Steam Calculator category when using Insert Function
25. ty kj kg C Btu Ib F 8 Specific volume m3 kg ft lb 9 Speed of sound m s ft s 0 Thermal Conductivity W m C Btu h ft F 1 Viscosity pPa s Ib ft h 2 Surface Tension N m N m 3 Helmholtz Free Energy kJ kg Btu Ib 4 Gibbs Free Energy kJ kg Btu Ib 5 Compressibility Factor n a n a 6 Isothermal Compressibility 1 kPa 1 psi 7 J oule Thompson Coefficient C kPa F psi 8 Isothermal J oule Thompson kJ kg kPa Btu lb psi 9 Thermal Expansion Coefficient uE 1 F 20 Prandtl Number n a n a 21 Static Dielectric constant n a n a 22 The corresponding units of measure for each property in both Units of Measure systems Metric UM System and English UM System the add in operates with are listed in the above table The UM system is specified as a parameter umSystem when the Excel functions are used O for Metric and 1 for English It can be changed also by pressing the UM System button when the add in interface is used SCTP 101 100 5 0 Metric English The outputCode column represents the code used as a parameter in the Excel spreadsheet functions which indicates which parameter is calculated 2008 2011 American Process Inc All right reserved Page 5 of 24 Steam Calculator How to use User I nterface The Steam Calculator add in User Interface is available by invoking the Steam Calculator menu entries automatically added under Tools MS Excel 2003 or earlier or in Steam Calculator ribbon is a
26. utomatically added under ChemGoodies MS Excel 2007 2010 Functions dialog A dialog window Spelling Research Alt Click Error Checking Speech Shared Workspace Share Workbook Track Changes Compare and Merge Workbooks Protection Online Collaboration Goal Seek Scenarios Options 11 Formula Auditing j Z 12 Macro 13 14 Add Ins 15 AutoCorrect Options 16 j i 17 Customize Steam Calculator Functions Find Formulas About Steam Calculator i ChemGoodies containing one tab for each Steam Calculator function is displayed calling up the Functions menu Page 6 of 24 lt Steam Calculator by American Process Inc q Steam Calculator a Tsat X Psat X tp P a e ps tm ers Pu erev aru ew ens Calculates the saturated steam properties atthe specified pressure and steam quality Excel function SCPX Input Output gt es Pressure Value 8 Erona l Reset L porna kPa Cell Temperature C 41 510053 a s Pressure kPa 8 E Enthalpy kJ kg 2576 236577 Values between 0 61 kPa and 22064 kPa Entropy kJ kg C 8 22738 Quality 1 amp d Quality Value 1 Density kg m3 0 055252 3 Intemal Energy kJ kg 2431 444781 ca i A Isobaric Heat C
27. written permission of American Process Inc 6 Termination This LICENSE and your right to use the SOFTWARE will terminate immediately without notice from American Process Inc if you fail to comply with the terms and conditions of this LICENSE Upon termination you agree to destroy the SOFTWARE including all accompanying documents and copies This is in addition to and not in lieu of any criminal civil or other remedies available to American Process Inc 7 Limited warranty A American Process Inc does not warranty that the SOFTWARE will be error free Except with respect to REDISTRIBUTABLES which are provided AS IS without warranty of any kind American Process Inc warrants that the SOFTWARE will perform substantially in accordance with the accompanying electronic documentation for a period of thirty 30 days from the date of receipt B American Process Inc entire liability in contract tort or otherwise and your exclusive remedy under the performance warranty set forth in Section 7 A shall be at American Process Inc option either a return of the purchase price paid or b repair or replacement of the defective SOFTWARE This limited warranty is void if failure of the SOFTWARE has resulted from accident abuse or misapplication Any replacement SOFTWARE will be warranted for the remainder of the original thirty 30 day period C EXCEPT AS EXPRESSLY SET FORTH IN THIS SECTION AMERICAN PROCESS INC DISCLAIMS ALL OTHER WARRANTIES E

Steam Calculator User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents