How to Install CoolProp in Microsoft Excel
How to Install CoolProp in Microsoft Excel
This video shows how to install CoolProp plugin in Microsoft Excel. CoolProp is an open-source thermophysical property database.
Install CoolProp in MATLAB ► • How to Setup CoolProp in MATLAB
Download CoolProp ►https://sourceforge.net/projects/cool…
Toluene ORC with Coolprop in Microsoft excel ► • Performance Model of the Toluene Orga…
Install CoolProp in PyCharm IDE for Python ► • How to install Free CoolProp Fluid Pr…
How to create Excel drop-down lists ► • How to Create Drop Down List in Excel…
Affiliate products
Speechelo Text to Speech Software ► https://bit.ly/3mVGCCY
Like, Subscribe \u0026 Share ►https://bit.ly/2HJpCRF\r
\r
\r
Translated titles:\r
كيفية تثبيت CoolProp مكتبة خصائص السوائل في Microsoft Excel\r
\r
Cara Memasang CoolProp Perpustakaan Properti Cairan di Microsoft Excel\r
\r
Come installare CoolProp Fluid Property Library in Microsoft Excel\r
\r
Microsoft Excel에서 CoolProp 유체 속성 라이브러리를 설치하는 방법\r
\r
Cara Memasang CoolProp Perpustakaan Properti Cecair di Microsoft Excel\r
\r
Jak zainstalować bibliotekę właściwości płynów CoolProp w Microsoft Excel\r
\r
Cómo instalar la biblioteca de propiedades de fluidos CoolProp en Microsoft Excel\r
\r
So installieren Sie die CoolProp Fluid Property Library in Microsoft Excel\r
\r
Comment installer la CoolProp bibliothèque de propriétés des fluides dans Microsoft Excel\r
\r
Como instalar CoolProp Biblioteca de propriedades de fluidos em Microsoft Excel
#howtoinstallcoolprop#coolpropinexcel#fluidproperties#thermodynamic#doxatech
Content
5.68 -> Hello everyone. In this video, I'm going to
show you how to set up CoolProp plugin
14.48 -> in Microsoft excel. In my opinion among
the free fluid property libraries
22.08 -> available in the public domain, CoolProp
is the closest alternative to
28.48 -> REFProp. The margin of error in CoolProp is
within an acceptable range. So why CoolProp. CoolProp
38.96 -> is a free and an open-source thermophysical
properties database for several fluids that can be
47.92 -> installed in several applications and programming
languages such as MatLab, Python, FORTRAN, LabVIEW
59.36 -> and many more depending on what you are using.
so if you are interested in using Coolprop
66.64 -> in MatLab, you can follow the link below this
video on how to set up Coolprop in MatLab.
77.44 -> With CoolProp plugin installed in your
Microsoft excel, you can now access hundreds of
85.36 -> fluid properties library. Let's jump into this
straight away. To begin, I will open my browser
96.08 -> and go to type in CoolProp
and select CoolProp download
104.08 -> and once you have CoolProp download window opened,
I will go to the file pivot
112.16 -> and I have my CoolProp folder here. so you see
within the CoolProp folder, you have the last modified
122.24 -> CoolProp is in August which is the
latest version. so I will click on this folder
130.96 -> and again you have a list of all the versions
of CoolProp. My interest will be the recent
140 -> version. so in case, you're watching the video,
just go to the most recent version of CoolProp.
150.32 -> In my case, this is 6.4.1. Depending on
when you're watching this video it could change
158.56 -> but this is the latest version at the time
of making this video. so I will click on the folder. Quickly,
167.2 -> there are two ways to install CoolProp into
your computer and to your Microsoft excel. The
177.6 -> first method is an automated process which is easy.
All you need to do is go to the installer here
189.6 -> and you click on Windows folder. you
click on windows folder, and then you click on the
198.8 -> CoolProp executable file and
once you click on it, it begins to
207.76 -> download. It prompts you and it begins to
download. Once the download is complete, you
212.64 -> go to wherever you've saved this file.
I will go to my download folder here and this
220.08 -> is the CoolProp that has finished downloading.
I can double-click on it now and install it. Select next
233.6 -> and finish. You see with this method,
automatically there will be a test excel file
244.48 -> that would appear on your desktop.
And this is the sample
252.16 -> EES file. so with this, I
can now open this excel file.
260.64 -> so immediately this is opened, um I can now
check if the add-in was properly installed
268.24 -> in Microsoft excel. To do that, I will go to my file
pivot and click on options. In the options, I will
278.56 -> click on add-ins to check if it's there. So you
can see the CoolProp add-in has been included
287.12 -> and that's why I like the automated method. It
does this automatically for you without having to
292.56 -> add any manual input. so the next thing to do
is to copy this location you have here.
300.32 -> Make sure you copy it and then
you take whatever you've copied here
304.72 -> to Trust Center. You click on Trust Center and
then you go to Trust Center Settings, and then you
315.2 -> you come to add a new location.
so in your case, once you
319.28 -> open this environment, you wouldn't
find um the CoolProp Path location added in your environment.
327.6 -> so you need to add that location in there.
To add a new location, you click on add new location
333.28 -> and then you paste whatever you've copied
into this place and that's the way
340.48 -> to save the path location there. so I'm gonna
cancel it because I already have that in here.
345.44 -> I will click on close, I click on okay and
maybe I can now open a new excel file. I
353.12 -> can now show you how to check the fluid properties.
I can type in here let's say the temperature,
361.04 -> I can type in here say pressure, and then i
could type in my Cp and type in my enthalpy.
374.08 -> Then I could give a particular
temperature value of interest, say 288.15,
380.56 -> and then maybe I could say the pressure of
101325 and then for the Cp, I would type equals,
387.92 -> and then I can type Props, so
you go down this list you see this Phase add-in is
395.76 -> part of the add-in package. so I'm interested
in um in this one PropSI. so I will select
404.08 -> this and um once I have that, I can now enter,
remember you need to put your double quotation
417.12 -> sign for the Cp. so C is representing the Cp.
You put a comma, take this off and then you
426.24 -> enter T for the temperature value you are interested
in and then you select the value. Next, you put
439.36 -> the pressure,
444.96 -> and then you select the value, enter a comma and
then you enter your fluid type. let's say nitrogen
458.24 -> and then I close it and you see, that's
the fluid property. I could do the same for enthalpy.
466.16 -> type equals, @
471.36 -> Propsi, so that's the one I'm
interested in.
479.68 -> I do the same thing rather than C,
now do for H which is for enthalpy
488.08 -> let's say, sorry I need to end the quotation. Sorry,
495.52 -> cancel, I need to end the quotation sign, the
double quotation sign. yeah, so that's it,
507.92 -> and then I will do the same for P, the pressure.
Select the pressure, so I missed something here.
517.52 -> I will put a comma sign and then I will select a value
for the pressure, this is the value for my pressure
525.84 -> and then again I will select the
fluid I'm interested in,
534.56 -> and that's it. so you see, you have the cp value,
you have the enthalpy value. I could do this
540.8 -> for any fluid. I could do this for let's say helium. let's come here I want to
547.36 -> do this for helium. I could select the fluid
property. if the fluid I'm interested in is helium
557.52 -> and that's it. It gives me the value
for helium so with this you can
561.6 -> select any fluid that you are interested in.
For the second method, I will just show you quickly.
567.84 -> um I'm not a fan of the second method because
it's a bit complicated to use this method,
572.24 -> but I'm going to show you quickly. I will
close this, um don't save, I'll close this.
578.88 -> For the second method, you go back to your
browser, where you have your CoolProp, come to file,
586.56 -> and then you come to CoolProp folder and when you
are in the folder, you come to the most recent
594.48 -> folder and then you go to Microsoft excel.
600.48 -> Then this is um what you need to download, all these
um files that we have here. so this one is if you
607.84 -> have an excel version before 2007, then you can use this
one. if your excel version is after 2007 then you need to
616.16 -> download this one. Again you can download the excel test file. Once you download this
624.56 -> and yeah, it's going to prompt you
and then it will start downloading
632.56 -> and then once it has downloaded, it
doesn't end there, you also need to
636.88 -> go back, um download this one and once you
download this one, you go back again to your folder
649.84 -> and you come to this environment, and
go to shared library download, open the shared
660.24 -> library and then you will see windows folder, you open
windows folder and then you need to select the dl
666.08 -> file so this is the dl. You could select 64 or 32 bits depending on your computer. I use 64 bit so I will have to download it.
675.76 -> And then, you download the CoolProp
dll. Once you download this,
684 -> it's a bit of a complicated process. I don't like
this manual process, I would rather recommend the first one,
689.2 -> which is automated. Once this is completed, the
next thing you need to do is to go to your excel
698.96 -> environment and quickly, once
your excel is opened, you go to file,
706.56 -> then you come to the option, and then you go to
add-ins. In my case, I used the first
713.28 -> the method, that's why I already have the add-in here.
If you don't have your add-in, you need to go to
722.24 -> here you have your manage excel add-in. You go
to and click on the Go option. And then here, you won't have the CoolProp.
729.2 -> it's here because mine is already installed. To install yours, you go to browse and wherever you have
733.52 -> your CoolProp xlam excel file located on your system.
In my case, this is here. You click on
741.12 -> it and it opens. Once this is installed on
your excel add-in, the next thing you need to do is to
748.24 -> make sure that you have the dl path location set-up. wherever you have the dll that you've downloaded, you
754.96 -> have it saved here. You go back to your Trust
Center option here,
761.84 -> go to Trust Center Settings and locate wherever you
have the dll path. Go to Trust Center location, yeah and then
769.12 -> find wherever you have the dl file located and
make sure that the excel can access that path.
779.04 -> With that, you can be able to run any
fluid property in excel. You see why I'm not a fan of the
785.52 -> second method. I recommend the first method
I showed you. And that's how you can
791.84 -> install CoolProp plugin in your Microsoft excel. I hope
you find this video useful and you now know
802.08 -> how to set up CoolProp in your Microsoft excel
environment. If you did find this video useful,
810.16 -> please click the like button and subscribe and
as well hit the notification button so you can be
818.56 -> notified when I do my next video. Thank you for
watching and see you in my next video. Bye for now.
Source: https://www.youtube.com/watch?v=I4nugwRtcZU