CoolProp Installation
Installation Instructions a) the CoolProp.dll and CoolProp_x64.dll files and place them in a folder called C:\CoolProp* b) the CoolProp.xlam file and place it in a convenient location c) Install the CoolProp Add-in from the Excel Options menu, Manage Add-ins 1) Open Excel 2) Go to the menu File→Options→Add-Ins 3) At the bottom of the , select Manage: Excel Add-ins, then click the Go… button. 4) Click the browse button on the Add-in Manager . 5) Browse to the file CoolProp.xlam that you copied above in step (b). 6) Make sure the CoolProp Add-in is selected (box checked) and close the add-in manager. d) Open the file TextExcel.xlsx (this file) and try to re-evaluate one of the formula cells on the Sample Calcs tab. The
*Alternate CoolProp Location If you need to place the CoolProp DLL files in a location other than on the C: drive, follow these instructions: a) the CoolProp.dll and CollProp_64.dll files and place them in CoolProp directory in a reachable location b) Open CoolProp.xlam c) You will get an Excel error - File not found: C:\CoolProp\CoolProp.dll d) Clicking Ok on the error dialog only brings up another. Try pressing and holding the <Enter> key until the errors g e) Go to File | Options on the main menu and select Customize Ribbon from the Excel Options menu 1) In the right hand pane under Main Tabs, make sure that the box in front of Developer is checked 2) Press OK f) Under the Developer menu, select Visual Basic to bring up the visual basic editor 1) Select Edit | Replace… from the main menu 2) Enter the following on the Find What: C:\CoolProp\CoolProp.dll Replace With: (new location) 3) Press the Replace All button 4) Repeat for C:\CoolProp\CoolProp_64.dll g) Press the Save button (disk image) or File | Save h) Press File | Close and Return to Excel i) Press
-
-<Shift>-F9 to recalculate the entire workshee on the Sample Calcs tab. All formulas should now
d C:\CoolProp*
n the Sample Calcs tab. The CoolProp formulas should all be working.
w these instructions: tory in a reachable location
Enter> key until the errors go away Options menu oper is checked
tab. All formulas should now be working.
CoolProp Example Calculations Function Usage Critical temperature of R410A: Critical density of propane: Density of Nitrogen at STP: Density of Air at STP: Boiling point of water at 1 atm: Boiling point of water at 1 atm: Example of an error: CoolProp DLL version installed: CoolProp Git Revision:
Units K kg/m³ kg/m³ kg/m³ °C °C
COOLPROP #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Phase Determination Water phase @ RT Water phase @ 400 K and 1 atm Water phase @ 400 K and 30 MPa Water phase @ 1030 K and 10 MPa Water phase @ 1030 K and 30 MPa
#NAME? #NAME? #NAME? #NAME? #NAME?
Mixtures
Dewpoint of dry air at 1 atm: Density of dry Air at STP:
mole Components fraction Nitrogen 0.7809 Oxygen 0.2095 Argon 0.0093 CO2 0.00039 K kg/m³
Humid Air Properties Dewpoint of dry Air at 1 atm: Dewpoint of air at 1 atm, 50% humidity: Density of Dry Air at STP: Density of 50% Humid Air at STP: Enthalpy of 50% Humid Air at STP: * Air Temperature (T) = 20°C
Incompressible Fluid Properties
Units K K kg/m³ kg/m³ J/kg #NAME? K
Units
#NAME? #NAME? COOLPROP #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
COOLPROP
Viscosity of 20% Aqueous Ethylene Glycol: Specifi Heat of Dowtherm Q @ 500 K, 1 atm Density of Seawater @ RT, 3.5% Salinity
Pa-s J/kg-K kg/m°
#NAME? #NAME? #NAME?
op
ons Expected value 344.494 220.4781 1.2503861303 1.2930656163 99.9742958477 99.9742958477 [current version]
liquid gas supercritical_liquid supercritical_gas supercritical
78.9334036422 1.2931619537 Expected value 149.3954439364 282.424425815 1.2930956155 1.2916247681 4723.4366339629 270.3856639732
Expected value
Function Call =Props1SI("R410A","Tcrit") =Props1SI("Propane","rhocrit") =PropsSI("Dmass","T",298.15,"P",101325,"HEOS::Nitrogen") =PropsSI("Dmass","T",298.15,"P",101325,"HEOS::Air") =PropsSI("T","P",101325,"Q",0,"HEOS::Water")-273.15 =PropsSI("T","P",101325,"Q",0,"REFPROP::Water")-273.15 =Props1SI("A","B") =get_global_param_string("version") =get_global_param_string("gitrevision")
=PhaseSI("T",293.15,"P",101325,"Water") =PhaseSI("T",400,"P",101325,"Water") =PhaseSI("T",400,"P",30e6,"Water") =PhaseSI("T",1030,"P",10e6,"Water") =PhaseSI("T",1030,"P",30e6,"Water")
=PropsSI("T","P",101325,"Q",0,"HEOS::"&MixtureString(A17:A20,B17:B20)) =PropsSI("D","T",273.15,"P",101325,"HEOS::"&MixtureString(A17:A20,B17:B20)) Function Call =HAPropsSI("D","T",293.15,"P",101325,"R",0) =HAPropsSI("D","T",293.15,"P",101325,"R",0.5) =1/HAPropsSI("Vda","T",273.15,"P",101325,"R",0) =1/HAPropsSI("Vha","T",273.15,"P",101325,"R",0.5) =HAPropsSI("H","T",273.15,"P",101325,"R",0.5) =HAPropsSI("T","H",C31,"P",101325,"R",1)
Function Call
0.0013814222 2288.1643758646 1024.8598443641
=PropsSI("V","T",300,"P",101.325,"INCOMP::MEG[0.2]") =PropsSI("C","T",500,"P",101325,"INCOMP::DowQ") =PropsSI("V","T",300,"P",101.325,"INCOMP::MEG[0.2]")
Saturation Table for water Temperature Temperature °C 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 300 310 320 330 340 350 360 370 #NAME?
K 273.16 283.15 293.15 303.15 313.15 323.15 333.15 343.15 353.15 363.15 373.15 383.15 393.15 403.15 413.15 423.15 433.15 443.15 453.15 463.15 473.15 483.15 493.15 503.15 513.15 523.15 533.15 543.15 553.15 563.15 573.15 583.15 593.15 603.15 613.15 623.15 633.15 643.15 #NAME?
Pressure kPa #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Sat. Liq. Density kg/m³ #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Sat. Vap. Density kg/m³ #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Sat. Liq. Enthalpy kJ/kg #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Sat. Vap. Enthalpy kJ/kg #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Water Saturation Curve
Pressure [kPa]
10.0
1.0 200
250
300
350
400
450
500
550
600
650
700
Temperature [K]
Pressure-Density Plot for Water
Pressure [kPa]
10.0
Sat. Liquid 1.0
0
5
10
15
20
25
30
35
40
45
40
45
Density [kg/m³]
Pressure-Enthalpy Plot for Water
Pressure [kPa]
10.0
Sat. Liquid 1.0
0
5
10
15
20
25
Enthalpy [kJ/kg]
30
35
P
Sat. Liquid 1.0
0
5
10
15
20
25
Enthalpy [kJ/kg]
30
35
40
45
Property Calculator Fluid Type
PureFluids
Fluid
Water
Output Name
Hmass
Input Name 1 Input Value 1
T
Input Name 2 Input Value 1
Q
Result
400
1 #NAME?
get_global_param_string("FluidsList") ==> Copy C2 and paste result as value here ==> Select C3 and convert text to columns. Copy C3:n3 and paste here Transposed ==> This makes a list we can use in a dropdown. The same procedure can be used to extract the PredefinedMixtures list and the ParameterList.
#NAME? 1-Butene Acetone PureFluids 1-Butene Acetone Air Ammonia Argon Benzene CarbonDioxide CarbonMonoxide CarbonylSulfide cis-2-Butene CycloHexane Cyclopentane CycloPropane D4 D5 D6 Deuterium Dichloroethane DiethylEther DimethylCarbonate DimethylEther Ethane Ethanol EthylBenzene Ethylene EthyleneOxide Fluorine HeavyWater Helium HFE143m Hydrogen HydrogenChloride HydrogenSulfide IsoButane IsoButene Isohexane Isopentane Krypton m-Xylene MD2M
Air
MD3M MD4M MDM Methane Methanol MethylLinoleate MethylLinolenate MethylOleate MethylPalmitate MethylStearate MM n-Butane n-Decane n-Dodecane n-Heptane n-Hexane n-Nonane n-Octane n-Pentane n-Propane n-Undecane Neon Neopentane Nitrogen NitrousOxide Novec649 o-Xylene OrthoDeuterium OrthoHydrogen Oxygen p-Xylene ParaDeuterium ParaHydrogen Propylene Propyne R11 R113 R114 R115 R116 R12 R123 R1233zd(E) R1234yf R1234ze(E)
R1234ze(Z) R124 R125 R13 R134a R13I1 R14 R141b R142b R143a R152A R161 R21 R218 R22 R227EA R23 R236EA R236FA R245ca R245fa R32 R365MFC R40 R404A R407C R41 R410A R507A RC318 SES36 SulfurDioxide SulfurHexafluoride Toluene trans-2-Butene Water Xenon
Ammonia PredefinedMixtures Air.mix Amarillo.mix Ekofisk.mix GulfCoast.mix GulfCoastGas(NIST1).mix HighCO2.mix HighN2.mix NaturalGasSample.mix R401A.mix R401B.mix R401C.mix R402A.mix R402B.mix R403A.mix R403B.mix R404A.mix R405A.mix R406A.mix R407A.mix R407B.mix R407C.mix R407D.mix R407E.mix R407F.mix R408A.mix R409A.mix R409B.mix R410A.mix R410B.mix R411A.mix R411B.mix R412A.mix R413A.mix R414A.mix R414B.mix R415A.mix R415B.mix R416A.mix R417A.mix R417B.mix
Argon
Benzene
CarbonDioxide
CarbonMonoxide
ParameterList FluidType A PureFluids ACENTRIC PredefinedMixtures ALPHA0 ALPHAR BVIRIAL Bvirial C CONDUCTIVITY 0MASS 0MOLAR MASS MOLAR CVIRIAL CVMASS CVMOLAR 0mass 0molar mass molar Cvirial Cvmass Cvmolar D DALPHA0_DDELTA_CONSTTAU DALPHA0_DTAU_CONSTDELTA DALPHAR_DDELTA_CONSTTAU DALPHAR_DTAU_CONSTDELTA DBVIRIAL_DT DCVIRIAL_DT DELTA DIPOLE_MOMENT DMASS DMOLAR Delta Dmass Dmolar FH FRACTION_MAX FRACTION_MIN FUNDAMENTAL_DERIVATIVE_OF_GAS_DYNAMICS
CarbonylSu
R417C.mix R418A.mix R419A.mix R419B.mix R420A.mix R421A.mix R421B.mix R422A.mix R422B.mix R422C.mix R422D.mix R422E.mix R423A.mix R424A.mix R425A.mix R426A.mix R427A.mix R428A.mix R429A.mix R430A.mix R431A.mix R432A.mix R433A.mix R433B.mix R433C.mix R434A.mix R435A.mix R436A.mix R436B.mix R437A.mix R438A.mix R439A.mix R440A.mix R441A.mix R442A.mix R443A.mix R444A.mix R444B.mix R445A.mix R446A.mix R447A.mix R448A.mix R449A.mix R449B.mix R450A.mix
G GAS_CONSTANT GMASS GMOLAR GWP100 GWP20 GWP500 Gmass Gmolar H HH HMASS HMOLAR Hmass Hmolar I ISOBARIC_EXPANSION_COEFFICIENT ISOTHERMAL_COMPRESSIBILITY L M MOLARMASS MOLAR_MASS MOLEMASS O ODP P PCRIT PH PHASE PIP PMAX PMIN PRANDTL PTRIPLE P_CRITICAL P_MAX P_MIN P_REDUCING P_TRIPLE P_max P_min Pcrit Phase Prandtl Q
R451A.mix R451B.mix R452A.mix R453A.mix R454A.mix R454B.mix R500.mix R501.mix R502.mix R503.mix R504.mix R507A.mix R508A.mix R508B.mix R509A.mix R510A.mix R511A.mix R512A.mix R513A.mix TypicalNaturalGas.mix
RHOCRIT RHOMASS_CRITICAL RHOMASS_REDUCING RHOMOLAR_CRITICAL RHOMOLAR_REDUCING S SMASS SMOLAR SMOLAR_RESIDUAL SPEED_OF_SOUND SURFACE_TENSION Smass Smolar Smolar_residual T TAU TCRIT TMAX TMIN TTRIPLE T_CRITICAL T_FREEZE T_MAX T_MIN T_REDUCING T_TRIPLE T_critical T_freeze T_max T_min T_reducing T_triple Tau Tcrit Tmax Tmin Ttriple U UMASS UMOLAR Umass Umolar V VISCOSITY Z
acentric alpha0 alphar conductivity dBvirial_dT dCvirial_dT dalpha0_ddelta_consttau dalpha0_dtau_constdelta dalphar_ddelta_consttau dalphar_dtau_constdelta dipole_moment fraction_max fraction_min fundamental_derivative_of_gas_dynamics gas_constant isobaric_expansion_coefficient isothermal_compressibility molar_mass molarmass molemass p_critical p_reducing p_triple pcrit pmax pmin ptriple rhocrit rhomass_critical rhomass_reducing rhomolar_critical rhomolar_reducing speed_of_sound surface_tension viscosity
cis-2-Bute CycloHexa Cyclopent CycloProp D4
D5
D6
DeuteriumDichloroetDiethylEth
DimethylC DimethylEtEthane
Ethanol
EthylBenzeEthylene EthyleneOxFluorine HeavyWateHelium
HFE143m Hydrogen HydrogenCHydrogenSu IsoButane IsoButene Isohexane IsopentaneKrypton
m-Xylene
MD2M
MD3M
MD4M
MDM
Methane Methanol MethylLinoMethylLinoMethylOleMethylPalm
MethylSteaMM
n-Butane n-Decane n-Dodecann-Heptanen-Hexane n-Nonane n-Octane n-Pentane
n-Propanen-UndecanNeon
NeopentanNitrogen NitrousOxiNovec649 o-Xylene OrthoDeutOrthoHydr
Oxygen
p-Xylene ParaDeuteParaHydroPropylene Propyne R11
R113
R114
R115
R116
R12
R123
R1233zd(E)R1234yf R1234ze(E)R1234ze(Z)R124
R125
R13
R134a
R13I1
R14
R141b
R142b
R143a
R152A
R161
R21
R218
R22
R227EA
R23
R236EA
R236FA
R245ca
R245fa
R32
R365MFC R40
R404A
R407C
R41
R410A
R507A
RC318
SES36
SulfurDiox SulfurHexaToluene
trans-2-BuWater
Xenon