10 replies to this topic

[ankur2061]

Dear forum members,

This forum is a boon for all chemical engineers and with icons like Art Montemayor and Chris Haselgo at the helm of affairs. I feel I should be returning to this forum little of what I know and hence I am uploading two spreadsheets.

One spreadsheet is about combustion calculations and other is about compressibility factor z using the Redlich-Kwong equation of state.

Would appreciate comments, if any.

Cheers to all fellow chemical engineers.

ankur2061.

Attached Files

•  COMBUSTION_CALCULATIONS.xls   26KB   2876 downloads
•  compressibility_factor_z_calc.xls   28.5KB   3530 downloads

[gvdlans]

Thanks Ankur!

One comment I have is the following: on the combustion spreadsheet you write:
"H2 = weight fraction of Hydrogen in Solid/Liquid fuel" and similar O2 for oxygen. My suggestion is to write "H" and "O" i.s.o. "H2" and "O2" since we are dealing with chemically bonded hydrogen and oxygen atoms, not with hydrogen or oxygen gas.

[jebi]

Hi Ankur

The excel sheets you have uploaded are not accessible anymore. Could you please update the links?

Thanks
Jeb

[Art Montemayor]

Jeb:

I tried downloading Ankur's Workbooks and they both are accessible.

You either must be doing something wrong, or you are blocked out where you are located - which I can't imagine.

Try again by clicking on the hyperlink to both files and following the normal instruction box to save or open.

Good luck.

[luuquocdai]

Attached files are Z calculation tools which base on some equations:SRK, RKB, RK, PR.

Attached Files

•  Z - Soave Redlich Kwong.xls   21KB   770 downloads
•  Z - Redlich Kwong Barxuk.xls   24KB   595 downloads
•  Z - Redlich Kwong.xls   21.5KB   637 downloads
•  Z - Peng Robinson.xls   22KB   718 downloads

[jebi]

Art Montemayor,
Thanks for your comment. Unfortunately, I still have problem downloading those files, while I was able to download new files uploaded by luuquocdai.

luuquocdai,
Thanks a lot for sharing those files. They are very useful.

Actually, I am trying to calculate z and then Vm for a pure gas (methane for the moment) for large amount of data (p and T). I prefer not to use software or charts. Apparently for the two- and three-parameter EOS I will need to use 'solver' or 'goal seek' in excel to do the calculations for every p and T. So I am using the following virial equation which is more straightforward and is not implicit. And since the gas is pure I think there shouldn't be any problem with the accuracy.

I will appreciate any commnents on this.

Thanks
Jeb

Attached Files

•  Pitzer correlation.xls   61.5KB   588 downloads

[luuquocdai]

Thanks jebi for your contribution.

[kybele39]

Dear Ankur,

For the same reason, I would like to share my two cents with all forum members in your post. Your posted spreadsheets are related all what we do behind the computers in the field of heat transfer and combustion is the very first basic step indeed.

I would like to post in here basic calculation of the heating values of fuel gases in Btu/lb and Btu/scf. Plus the molecular weight of a specific fuel gas. These values are always discussed between engineers between the companies at least I came across.

Thank you very much for sharing.

Kybele

I also attached the combustion constants from Perry's Chemical Engineer's Handbook

Attached Files

•  combustion calculations101.xls   36KB   890 downloads
•  Combustion Constants.pdf   48.92KB   712 downloads

[ankur2061]

All,

It is wonderful to share and I am happy that everyone is trying to contribute something or the other. When I saw the different z-factor calculation spreadsheets using different EOS (RK, PR, SRK) it reminded me that I have a spreadsheet which gives z-factor using all the EOS in a single worksheet. This should prove helpful in having a comparison of all EOS in one sheet. All thanks to Mr. Dennis Kirk.

Regards,
Ankur

Attached Files

•  EOSCalcs.xls   77.5KB   956 downloads

[ankur2061]

All,

A new EOS property calculator has been launched at:

http://www.chemsof.com/spreadsheet.htm

Happy downloading.

Regards,
Ankur.

[Padmakar Katre]

Dear Ankur,
Thanks it's a very useful link.