Pressure-enthalpy Charts in Excel?

[MechEng92]

Does anyone know of a template, method, or download to put a pressure-enthalpy chart for refrigerants into excel? I'd like to calculate refrigerant density in a liquid expansion line which requires finding the percentage of liquid and vapour in the mixture from the chart at a given condition. I've only been able to use third party software or plot the chart on paper before, it would be handy to have it live in my workbook.

 

[dbill74]

If your existing chart is in an electronic format, e.g. PDF or word, you can try doing a copy/paste. Depending on the exact format you may get away with copying the entire chart and when you paste into excel will put everything into individual cells. Doesn't always work, but worth a shot.

 

[MintJulep]

https://catalog.data.gov/dataset/ni...-transport-properties-database-refprop-srd-23

 

[MechEng92]

dbill74 - If you mean copy and pasting the chart data then I don't have any of that, so far I have pasted a screenshot of the chart into excel and measured points from the image to use to plot a chart in excel. This is a lengthy and not the most accurate process.

MintJulep - The link sounds promising but it seems as though I need to request and pay for any of the data.

 

[MintJulep]

The refrigerant manufacturers typically publish the equations of state in the technical documents for their products if you want to take the time to do it on your own.

Google will find you other possible sources for refrigerant equations of state in excel.

Some of them may be free for use and free of malware.