Jump to content



Submitter

File Information

  • Submitted: Jun 07 2011 12:09 PM
  • Last Updated: Dec 21 2011 08:17 PM
  • File Size: 28KB
  • Views: 34003
  • Downloads: 9,711

Previous Versions

  • 07 Oct 2011 Download Orifice Flow Calculator for Gases, Steam, and Vapors 1.1
  • 07 Jun 2011 Download Orifice Flow Calculator for Gases, Steam, and Vapors

Download Orifice Flow Calculator for Gases, Steam, and Vapors 1.11

* * * * - 5 Votes



Screenshots
Based on Bernoulli's equation, this worksheet will calculate the flow through an orifice valid for gases, vapors, and steam.

Corner tap types are assumed.

Based on the method shown here:

http://www.flowmeter...ifice_calc.html

What's New in Version 1.11 (See full changelog)

  • 1.1 Fixed cell D12 bug
  • 1.11 Equation (19000*D25/D22)^0.08 changed to (19000*D25/D22)^0.8. Little affect on most results.


Disclaimer: All software provided "As-Is" with no warranty, expressed or implied, available. See our Terms of Use for more information.




As instrument engineer I have to calculate the other way around, given flow, given pressure drop, given linesize.

To calculate the orifice diameter.

The ISO 5167 gives formulas for the uncertanty, you may add them.


Excell allows you to built an unit selector. Most locations use bar. many places have flow in m3/hr instead of kg/hr

Density calculator for gas.

Enjoy your Sunday!
Dear Toon

Thank you very much for you suggestion.

I will try to incorporate these changes in this spreadsheet.

By the way, You can use this spreadsheet to calculate orifice diameter using solver.

regards
Dear acer_asd,

There is a bug in your sheet.
Cell D12 must be calculated value (or it has to be highlighted).
Expansion coef. calculation (cell D23) refers to cell D12.

Regards, szerencseh
Photo
Chris Haslego
Oct 06 2011 02:36 PM

Dear acer_asd, There is a bug in your sheet.Cell D12 must be calculated value (or it has to be highlighted).Expansion coef. calculation (cell D23) refers to cell D12. Regards, szerencseh


I've sent a note to the author to have a look.
Photo
Chris Haslego
Oct 07 2011 07:21 AM

Dear acer_asd, There is a bug in your sheet.Cell D12 must be calculated value (or it has to be highlighted).Expansion coef. calculation (cell D23) refers to cell D12. Regards, szerencseh


I've sent a note to the author to have a look.



Corrected version 1.1 of the spreadsheet has been uploaded.
Photo
johnnygeneric
Dec 16 2011 04:46 PM
For the Discharge Coefficient, what equation is this based on? From what I can tell this is not the latest ISO 5167 equation. I keep stumbling onto a different equation on the internet - similar form, but constants are slightly different and exponents slightly different. Results simillar?

Also, there is a mistake in your equation: This section (19000*D25/D22)^0.08 should be (19000*D25/D22)^0.8 Or maybe the referenced equation is wrong. Correct me if I'm wrong.

Thanks

[note]Sent a note to the author to comment on this. Thanks for your feedback.[/note]
Dear johnnygeneric

Thanks your feedback.

Yes, you are right, there is a mistake in this equation. i have submitted corrected file in download section.

Actually this mistake create minor error in calculation that's why it escaped my attention.

Also, this is not ISO 5167 but this is older version i.e. 2003. I dont think there will be much of a difference in this calculation and latest ISO calculation. If you have latest ISO please check it and tell me how much error is there in this equation.

Once again i thank you for your feedback.

[note]Corrected file updated in Downloads on 12/21/2011[/note]
Photo
johnnygeneric
Jun 20 2012 09:22 AM
For orifice plates used for just taking up pressure drop in a line, what "L" should we use? Corner taps, flange taps or what? Thanks.

Johnnygeneric

Which one can we use for Falnge Taps?

 

Thanks!


Random Files





user(s) are online (in the past 15 minutes)

members, guests, anonymous users