### File Information

• Submitted: Jun 07 2011 12:09 PM
• Last Updated: Dec 21 2011 08:17 PM
• File Size: 28KB
• Views: 42097
• Downloads: 10,621

### Previous Versions

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

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

5 Votes

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!
acer_asd
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
tomcseh
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
Chris Haslego

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.
Chris Haslego

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.
johnnygeneric
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]
acer_asd
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]
johnnygeneric
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

• #### Gross Plant Heat Rate...

By aerryawan gerry
Feb 12 2013 09:21 AM FREE
• #### MS Excel to Hysys Gas...

By Ajay S. Satpute
Nov 01 2013 03:06 PM FREE
• #### Steam Ejector Calculat...

By ankur2061
Feb 12 2013 10:38 AM FREE
• #### Hydraulic Study of Gla...

By Ajay S. Satpute
Nov 14 2012 03:01 PM FREE
• #### Pipe Size Optimization...

By Chris Haslego
Dec 09 2010 03:24 PM FREE

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

members, guests, anonymous users