{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Summary","Examples","Mixture Example"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":32,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Summary","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,"Sample Workbook to demonstrate the use of REFPROP in a Spreadsheet."]
[]
[]
[]
[]
[]
[]
[null,null,"Dr. Eric W. Lemmon",null,"Dr. Mark O. McLinden"]
[null,null,"Physical and Chemical Properties Division",null,"Physical and Chemical Properties Division"]
[null,null,"Theory and Modeling of Fluids Group",null,"Experimental Properties of Fluids Group"]
[null,null,"325 Broadway",null,"325 Broadway"]
[null,null,"Boulder, CO 80305, U.S.A.",null,"Boulder, CO 80305, U.S.A."]
[null,"Phone: ","+1-303-497-7939","Phone: ","+1-303-497-3580"]
[null,"Fax: ","+1-303-497-5224","Fax: ","+1-303-497-5224"]
[null,"Web: ","http://www.boulder.nist.gov/div838/theory.html","Web: ","http://FluidProperties.NIST.Gov"]
[]
[]
[null,null,"Dr. Marcia L. Huber"]
[null,null,"Physical and Chemical Properties Division"]
[null,null,"Theory and Modeling of Fluids Group"]
[null,null,"325 Broadway"]
[null,null,"Boulder, CO 80305, U.S.A."]
[null,"Phone: ","+1-303-497-5252"]
[null,"Fax: ","+1-303-497-5224"]
[null,"Web: ","http://www.boulder.nist.gov/div838/theory.html"]

{"sheet":"Examples","index":1,"n_rows":109,"n_cols":17,"rows_kept":109,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["***Do not save your work as REFPROP.XLS, but rename it.  This will avoid losing the file if you ever uninstall or reinstall the program.***"]
["The REFPROP.xls file can be saved as a template file (REFPROP.xlt).  When a new Excel file is created (under File/New) using this template file, a suffix number is appended so that the saved material will not overwrite the original file."]
["Text of user-specified values in the input cells is blue."]
["Macros must be enabled to calculate properties."]
["See the help file in the REFPROP graphical interface for additional information on calculating properties."]
["Most properties shown here use the default units of \"Molar SI\"; other available sets:  \"SI\", \"SI with C\", \"Molar SI\", \"E\", \"cgs\", \"mks\", \"M\" (these all need quotes).  The \"SI with C\" set can also be labeled as just \"C\"."]
["(See the \"REFPROP with Instructions and Help.XLS\" file for definitions of these sets)"]
["All unit systems use a mass basis for properties and a mole basis for compositions, except \"Molar SI\", which uses a mole basis for properties."]
["To use mass basis for compositions, add the word \"mass\" to the end of the composition string; see the example at the bottom of this sheet."]
["To permanently change the default units to English, search for \"DefaultUnits = 0\" in the Visual Basic code (press Alt-F11) and change the value to 3."]
["To use predefined mixtures, the extension \".MIX\" must be included in the fluid name, see the example below."]
["For information on making these functions available to any Excel worksheet, see the help file or visit http://www.fontstuff.com/vba/vbatut08.htm for information on how to use these functions in a vba file."]
["A screen shot of REFPROP can be inserted into a worksheet by clicking the \"Print Screen\" key (top row) to copy what is displayed on the monitor when REFPROP.exe is running.  This can then be pasted into a worksheet."]
["NOTE:  The units used here have changed slightly from those used in REFPROP 7.0.  \"SI\" now refers to SI units on a mass basis, while \"Molar SI\" will return the same results as those given in version 7.0."]
[]
["An environment variable can be set to specify the locations of the fluid files.  This new variable should be called RPPrefix and be given the value of \"C:\\Program Files\\REFPROP\" (or the directory where REFPROP is located)."]
["(Environment variables can be set under Start/Settings/Control Panel/System/Advanced/Environment Variables, under the \"User variables\" option.)"]
["The environment variable for the path (located under the \"System variables\") can also be modified by adding \";c:\\program files\\REFPROP\" (or whatever location is used) to the end so that the file REFPROP.DLL can be found from any location."]
["Alternatively, the comments at the beginning of the Visual Basic code (press Alt-F11) tell how to change the working directories in order for REFPROP to locate the fluid files and the DLL."]
[]
[]
["Example:",null,null,"Units:","Molar SI"]
["Pure Fluid Calculations",null,null,"Critical Temp. (K):",{"$error":"#VALUE!"},null,"Triple Point Temp. (K):",{"$error":"#VALUE!"},null,"Critical Temp. (C):",{"$error":"#VALUE!"}]
[null,null,null,"Crit. Press. (MPa):",{"$error":"#VALUE!"},null,"Trp Pressure (MPa):",{"$error":"#VALUE!"},null,"Triple Point Temp. (C):",{"$error":"#VALUE!"}]
["Fluid:  ","nitrogen",null,"Crit. Dens. (mol/L):",{"$error":"#VALUE!"},null,"Trp Density (mol/L):",{"$error":"#VALUE!"}]
["T","P","r","h","s","Quality"]
["K","MPa","mol/L","J/mol","J/mol-K","—"]
[200,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[100,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},100,{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},1,{"$error":"#VALUE!"},-4000,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,"If the phase is known for given inputs of T and P, the following examples show how to obtain much faster calculations:"]
[100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"(Melting point given temperature)",null,null,null,"These examples also show how to force the calculation to search only in the liquid or only in the vapor state (for example, for metastable states.)"]
[{"$error":"#VALUE!"},200,{"$error":"#VALUE!"},"(Melting point given pressure)",null,null,null,{"$error":"#VALUE!"},"(Input state is known to be in the liquid)"]
[60,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"(Sublimation point given temperature)",null,null,null,{"$error":"#VALUE!"},"(Input state is known to be in the vapor)"]
[{"$error":"#VALUE!"},0.01,{"$error":"#VALUE!"},"(Sublimation point given pressure)"]
[]
["Two-Phase Calculations"]
["Compute properties from given temperature and density.",null,null,null,null,null,null,null,null,null,"Liquid","Vapor ","Liquid","Vapor"]
["T","P","r","u","h","s","Quality","rSL","rSV","Surf. Tens.","Viscosity","Viscosity","Th. Cnd.","Th. Cnd.","Z","Z"]
["K","MPa","mol/L","J/mol","J/mol","J/mol-K","—","mol/L","mol/L","mN/m","mPa-s","mPa-s","mW/(m-K)","mW/(m-K)","-","-"]
[100,{"$error":"#VALUE!"},15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[" ",null,null,null,null,null,"Latent heat"]
["Calculate properties given only the saturation pressure.",null,null,null,null,null,"J/mol"]
[{"$error":"#VALUE!"},0.3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Calculate properties given only the saturation temperature."]
["(note that some of the following calculations use \"TD&\" to define the input properties, see the \"Mixture Example\" sheet for more information."]
[100,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Example:"]
["Unit Conversions"]
["Unit system:  ","cgs"]
["T","P","r","v","u","h","s","Cv","Cp","w","h","l","Z","Prandtl"]
["K","MPa","g/cm3","cm3/g","J/g","J/g","J/g-K","J/g-K","J/g-K","cm/s","mPa-s","mW/(m-K)","-","Number"]
[100,1,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Other Properties"]
["Unit system:  ","E","Isothermal","Volume","Isentropic","Isothermal","Adiabatic","Adiabatic Bulk","Isothermal Bulk"]
["T","P","Compressibility","Expansivity","Expansion","Expansion","Compressibility","Modulus","Modulus"]
["F","psia","1/psia","1/R","Coefficient","Coefficient","1/psia","psia","psia"]
[-200,1000,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
["Example:"]
["Mixture Calculations (maximum number of components in a mixture is 20)"]
["System:  ","0,6 nitrogen + 0,05 argon + 0,35 oxygen"]
[]
["nitrogen;0,6;argon;0,05;oxygen;0,35"]
[]
["Components","Mole Fractions"]
["nitrogen",0.6]
["argon",0.05]
["oxygen",0.35]
["Total",1]
[]
[]
["Mixture properties:"]
["r (100 K, 0.1 MPa)",{"$error":"#VALUE!"},"kg/m3"]
["r (100 K, 1 MPa)",{"$error":"#VALUE!"},"kg/m3"]
[]
[]
["Example:",null,null,"Mole Fraction 1","Mole Fraction 2","Mass Fraction 1","Mass Fraction 2"]
["Predefined Mixture:",null,"r410a.mix",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"In addition to the predefined mixtures in REFPROP, any mixture with a \".mix\" extension that you save in the mixtures directory while running the REFPROP graphical interface will be available to the Excel file here."]
["Mixture properties:"]
["r (300 K, 10 MPa)",{"$error":"#VALUE!"},"kg/m3"]
[null,null,null,null,"Properties of the liquid and vapor at the equilibrium compositions (not the R410A composition):"]
["Two phase state point at 300 K, 200 kg/m3:",null,null,null,"Liquid Phase","Liquid Phase","Vapor Phase","Vapor Phase","Liquid","Vapor","Liquid","Vapor ","Liquid","Vapor","Liquid phase","Liquid phase"]
["T","P","r","Quality","Mole Frac.","Mole Frac.","Mole Frac.","Mole Frac.","Density","Density","Viscosity","Viscosity","Th. Cnd.","Th. Cnd.","mass fract.","mass fract."]
["K","MPa","kg/m3","(molar basis)","R32","R125","R32","R125","kg/m3","kg/m3","mPa-s","mPa-s","mW/(m-K)","mW/(m-K)","R32","R125"]
[300,{"$error":"#VALUE!"},200,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Liquid phase composition string:",null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"(These two cells are just for checking mass to mole conversions)"]
[null,"Vapor phase composition string:",null,null,{"$error":"#VALUE!"}]
[]
[null,null,null,null,"Properties of the liquid and vapor at the equilibrium compositions (not the R410A composition for the liquid):"]
["Dew point at 300 K with equilibrium liquid properties",null,null,null,"Liquid Phase","Liquid Phase",null,null,"Liquid","Vapor","Liquid","Vapor ","Liquid","Vapor"]
["T","P","r","Equilibrium","Mole Frac.","Mole Frac.",null,null,"Enthalpy","Enthalpy","Viscosity","Viscosity","Th. Cnd.","Th. Cnd."]
["K","MPa","kg/m3","Liquid Density","R32","R125",null,null,"kJ/kg","kJ/kg","mPa-s","mPa-s","mW/(m-K)","mW/(m-K)"]
[300,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Liquid phase composition string:",null,null,{"$error":"#VALUE!"}]
[]
[]
["Alternative method for specifying a mixture setup",null,null,null,"To specify mass composition, add the word \"mass\" at the end of the input"]
["R32/R125 (0.5/0.5)",null,null,null,"R32/R125 (0.5/0.5) mass"]
["T","P","r",null,"T","P","r"]
["K","MPa","kg/m3",null,"K","MPa","kg/m3"]
[300,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,300,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Mixture Example","index":2,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Phase calculation example for a 50/50 mixture of ammonia and water"]
["ammonia;0.5;water;0.5"]
["Pressure (MPa)",0.3]
["Liquid phase temperature (K)",{"$error":"#VALUE!"}]
[]
["Get the liquid and vapor densities for all other thermodynamic property calculations"]
["Liquid phase density (kg/m^3)",{"$error":"#VALUE!"}]
["Vapor phase density (kg/m^3)",{"$error":"#VALUE!"}]
[]
["Get the vapor phase composition"]
["Ammonia mole fraction",{"$error":"#VALUE!"}]
["Water mole fraction",{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"}]
[]
["Calculate all other properties using the temperature and density as inputs"]
["(with the appropriate mole fractions for ammonia and water for either the liquid or vapor.)"]
["Use the ampersand in the special code \"TD&\" to indicate that phase equilibrium checks should not be performed,"]
["and that the properties should be calculated directly from the equation of state (EOS) irregardless of phase."]
["The special code only works for temperature and density since these are the independent properties in the EOS."]
["If the ampersand is not used, the program attempts to find the phase boundary for each input, thus slowing down the process,"]
["and occasionally causing errors because of nonconvergence."]
["The ampersand should NOT be used for two-phase states, it will return properties for metastable states."]
["Liquid enthalpy (kJ/kg)",{"$error":"#VALUE!"}]
["Vapor enthalpy (kJ/kg)",{"$error":"#VALUE!"}]
[]
["Liquid speed of sound (m/s)",{"$error":"#VALUE!"}]
["Vapor speed of sound (m/s)",{"$error":"#VALUE!"}]