Excel Orifice Plate Calculations3/16/2021
This Excel spreadsheet sizes a liquid orifice meter using the equations in ISO 5167.Orifice meters determine liquid flowrate by measuring the pressure difference across a constriction in a pipe.
The spreadsheet is free - all I ask is that you credit this website with its authorship (and perhaps provide a link). These positions the values of L 1 and L 2, and are given below. The solution to the equations is iterative; you need Re to calculate C, but you need Q to calculate Re, but you need C to calculate Q. This process is automated in the Excel spreadsheet with a button linked to a VBA macro. The VBA macro simply initiates Goal Seek with the requireed settings. Excel Orifice Plate Calculations Download Excel SpreadsheetDownload Excel spreadsheet to size an orifice meter with ISO 5167. Applying this equation to a streamline traveling down the axis of the horizontal tube gives. It is recommended that location 1 be positioned one pipe diameter upstream of the orifice, and location 2 be positioned one-half pipe diameter downstream of the orifice. ![]() For real flows (such as water or air), viscosity and turbulence are present and act to convert kinetic flow energy into heat. To account for this effect, a discharge coefficient C d is introduced into the above equation to marginally reduce the flowrate Q. As a result, the volumetric flowrate Q for real flows is given by the equation.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |