DISCLAIMERThese worksheets are distributed at no charge on an as-isbasis. The author does not assume any liability for their use.WORKSHEET PROTECTION AND COPYRIGHTI have protected the worksheets to prevent accidental changes to the formulas and calculation method. It is still possible to see theformulas that are used so that those who are interested can verify the calculation method, or use my calculation methods and formulas in their own worksheets or other programmingenvironments.If you want to make changes to the worksheets, the password iseliminator, but you do so at your own risk. Note that some of my newer worksheets, though protected to prevent accidental changes, do not requirea password. For those newer sheets, simply select from the Excel Review menu, Unprotect sheet.I have not claimed copyright to these worksheets because I want them to be used by anyone whowants to use them. If you design your own worksheets or other program using my formulas and calculation methods, leave my name off, as I don’t want credit for any possible incorrect calculations.
These Excel® Workbooks are intended as full function control valve sizingapplications.They include control valve sizing calculations in accordance with the current ISA/IEC standards and noisecalculations in accordance with the current IEC standards. These workbooks include typical valve sizing and noise calculation parameters and typical tables of valve capacity (Cv) for a number ofthe most popular control valve styles. As such, many users will find them suitable for preliminary control valve selection.
Control Valve Sizing
When you select a valve manufacturer it would be wise to ask them toverify your selections based their proprietary parameters.Additional features rarely found in valve selection applications is the ability to calculate and graph theinstall flow characteristic and installed gain of a particular valve style and size in the system into which it is to be installed.There are three workbooks. Gas flow in mass flow units, Gas flow in volumetric flow units and Liquid flow. Thefirst tab on each is a “READ ME” tab which contains an instruction manual. Reading the manual will significantly improve your experience with the workbook.I have retained my original stand-alone worksheets for valve sizing and IEC noise that are below for those whoprefer to use them. The download is a zip file which contains a short instruction manual, and Excel ® worksheets for:Liquid (Volumetric flow units) Includes a tab that can convert mass flow to volumetric flowGas (Volumetric flow units where the molecular weight or specific gravity is known)Gas (Mass flow units where the density is known. This includes steam.)A unique feature of these worksheets is that in addition to performing traditional Cv calculations, they can also graph the installed flow characteristic and installedgain of a valve when it is installed in a particular system.These worksheets are based on ANSI/ISA-75.01.01 (IEC 60534-2-1 Mod) -2012 'Flow Equations for Sizing Control Valves.' Each has space for four simultaneous calculations.
For example, you cancalculate required control valve capacity (Cv or Kv) for Minimum, Normal, Maximum and one additional flow condition. Engineering units are by default set to US units, but can beeasily changed to SI units. Your experience with these worksheets will be much better if you read the included 'Instructions.' 4-27-18: Minor revision to liquid sizing worksheet. No obvious difference, no change to calculated results. See Revision History. I have recently become a member of the ISA S75.07 committee that is working on standards involving control valve noise.
Emerson Automation Solutions Final Control Us Lp
So far my main effort has been to make Excel ® worksheetsthat calculate Aerodynamic and Hydrodynamic noise in accordance with the current IEC Standards. These calculations involve many equations and, in the words of Dr. Hans Baumann are a 'programmers nightmare.' I have to agree with him!Here are two zip files, one forAerodynamic noise and one for Hydrodynamic noise. Each contains a worksheet for flow in mass flow units and a worksheet for volumetric flow units. Alsoincluded for each is a short instruction file.On 1/15/18 I replaced theHydrodynamic noise file with Rev. The only change is that I added the option of either entering a known value of x Fz or letting the worksheet calculate an approximate value using Equation 3 of the Standard.On 3/9/18 I added an Excel sheet thatcalculates typical values for some parameters required by the IEC noise calculations.On 8/7/18 Ireplaced the Aerodynamic noise sheets with Rev.
There was a minor error in the FLP calculation for Conditions 2, 3 and 4. This only resulted in a calculation error of about 1dB(A).On 10/7/18I replaced the Typicalx Fz, Fd and F L parameters worksheet with Rev 3. There was a change to theF L calculation for the Globe 4 port cage valves.On 10/9/18 I replaced the Typical x Fz, F d and F L parameters worksheet with Rev 4. There was a change to thex Fz calculation for the Globe 4 port cage valves. Revised May 6, 2017. Minor revisions to some tabulated data. Added a README (Information and Instructions) tab.Revised May 28 2017. Minor corrections to some tabulated values.
Added tabulated values for Tr = 2.5 for increased accuracy.This worksheet approximates the compressibility factor of gasses for control valve sizing purposes. It uses tabulated data from the Nelson Obert charts with two dimensional interpolationbetween the tabulated reduced pressure points and reduced temperature points.It is valid for reduced temperatures (Tr) between 1.0 and 15 and reduced pressures (Pr) between 0.0 and 20. The worksheet shows the reduced pressure and temperature being used in thecalculation, and informs the user whether each is within the limits of the worksheet.There is space on the worksheet for four calculations to make it easily compatible with the four calculations performed by the above control valve sizing worksheets.
This worksheet approximates the behavior of P1 and P2 (pressure upstream and pressure downstream of a controlvalve) at different flow rates. This worksheet calculates the pressure drop in liquid piping systems.There are ten columns of identical individual calculations. You can use just one, or you can use more than one for different flow rates in the same system, for unrelated calculations or forchained calculations for the same system where you want to break the system down into several small systems in series.There is a description of how the worksheet works and instructions for its use on the second tab.On 5/21/15 Iadded a third tab with typical isolation valve Cv values.
Fisher Control Valve Sizing Software Firstvue Download Skype Free
This is the home page for your valve software selections. Feel free to download the latest version ofour valve sizing programs.Valve sizing programs are used to help engineers, technical sales representatives, and other customers correctlysize a valve for a specific application and generate a report about the product they have sized.
Once the valve issized, you are able to configure the selections for that valve. This information is then reported as output from the programthat can be used to communicate with the factory what your valve requirements are and help guide you in the direction ofthe particular valve you need for your application.Choices:PRV 2SIZE Pressure Relief Valve Software is an integrated valve sizing, selection and configuration platform for Anderson Greenwood, Crosby and Varec brand overpressure protection valves and for Yarway brand Automatic Recirculation Control Valve (ARC) valves.