Control Valve Sizing Excel Worksheets per ISA and IEC Standards - Free Download

100% Free - Documentation Included

Features:

  1. New 2021 Worksheet that will calculate and graph control valve installed flow characteristic and installed gain, based on using the user’s preferred control valve sizing software. Constructing and using the Excel sheet is discussed in the article Calculating the Installed Flow and Gain of a Control Valve in Process Instrumentation Magazine. Worksheet and article by Jon F. Monsen.
  2. 2020 Worksheet offering an accurate and simple Control Valve Hydrodynamic Noise Calculation via a non IEC method. Worksheet by Jon F. Monsen and calculation method by Hans D. Baumann. Control valve noise prediction method discussed here in Valve World Magazine.
  3. 2019 Workbooks intended as full function control valve sizing applications.
  4. 2019 Workbooks include control valve sizing calculations in accordance with the current ISA/IEC standards and noise calculations in accordance with the current IEC standards.
  5. 2019 workbooks include typical valve sizing and noise calculation parameters and typical tables of valve capacity (Cv) for a number of the most popular control valve styles. As such, many users will find them suitable for preliminary control valve selection. 
  6. 2019 workbooks have the rare ability to calculate and graph the installed flow characteristic and installed gain of a particular valve style and size in the system into which it is to be installed.
  7. 2019 workbooks include built-in documentation.
  8. Perform traditional Cv calculations.
  9. Space for four simultaneous calculations.
  10. Calculate required control valve capacity (Cv or Kv) for Minimum, Normal, Maximum and one additional flow condition.
  11. Engineering units are by default set to US units, but can be easily changed to SI units. 
  12. Comprehensive instructions.
  13. Based on ANSI/ISA-75.01.01 (IEC 60534-2-1 Mod) -2012 "Flow Equations for Sizing Control Valves."

Control Valve Excel Worksheet Sets available for download:

  1. Calculate and Graph Control Valve Installed Flow and Gain - 2021 Worksheet.
  2. Control Valve Hydrodynamic Noise - non IEC - simplified - 2020 Worksheet.
  3. Control Valve Sizing with IEC Noise - Liquid - 2019 Workbook.
  4. Control Valve Sizing with IEC Noise - Gas (Volumetric) - 2019 Workbook.
  5. Control Valve Sizing with IEC Noise - Gas (Mass) - 2019 Workbook.
  6. Control Valve Sizing (Liquid and Gas) Excel Worksheets - Legacy Version. 
  7. IEC Control Valve Aerodynamic Noise (Mass and Volumetric) Excel Worksheet - Legacy Version.
  8. IEC Control Valve Hydrodynamic Noise (Mass and Volumetric) Excel Worksheet - Legacy Version.
  9. Typical xFz, Fd and FL Parameters for IEC Control Valve Calculations Excel Worksheet.
  10. Liquid Vapor Pressure for Control Valve Sizing Excel Worksheet.
  11. Gas Compressibility Factor Based on the Nelson-Obert Generalized Compressibility Charts Excel Worksheet.
  12. Control Valve P1 and P2 vs. Flow Excel Worksheet.
  13. Liquid Pressure Drop in Pipe and Fittings Excel Worksheet.

DISCLAIMER

These worksheets are distributed at no charge on an as-is basis. The author and INDUSTRYDOCS DO NOT assume any liability for their use. 

You must prove you are not a robot to access Excel Control Valve Worksheets.
Complete the test below successfully and click SUBMIT:



Note: Worksheets are protected with either the password: "eliminator" or no password.

New 2021 Worksheet that will calculate and graph control valve installed flow characteristic and installed gain, based on using the user’s preferred control valve sizing software.

  • Calculate and Graph Control Valve Installed Flow and Gain 2021 Worksheet:

2020 Worksheet for Hydrodynamic Noise Calculation using an accurate and simple non IEC method. Worksheet by Jon F. Monsen and calculation method by Hans D. Baumann.

  • Control Valve Hydrodynamic Noise non IEC 2020 Worksheet:

2019 Workbooks intended as full function control valve sizing applications

  • Liquid - Control Valve Sizing with IEC Noise 2019 Workbook:
  • Gas Volumetric Flow - Control Valve Sizing with IEC Noise 2019 Workbook:
  • Gas Mass Flow - Control Valve Sizing with IEC Noise 2019 Workbook:

Control Valve Sizing Excel Worksheets
(Legacy Versions - 2018 and Prior)

  • Liquid (Volumetric flow units) includes a tab that can convert mass flow to volumetric flow: 
  • Gas (Volumetric flow units where the molecular weight or specific gravity is known):
  • Gas (Mass flow units where the density is known. This includes steam):
  • 90 Deg to Relative Travel Table:
  • Instructions, PLEASE READ:

IEC Control Valve Aerodynamic Noise Worksheets:

  • IEC Aero Noise Mass: 
  • IEC Aero Noise Volumetric:
  • Instructions, PLEASE READ:

IEC Control Valve Hydrodynamic Noise Worksheets:

  • IEC Hydro Noise Mass: 
  • IEC Hydro Noise Volumetric:
  • Typical xFz, Fd and FL for IEC Control Valve Calculations:
  • Instructions, PLEASE READ:

Additional Worksheets:

  • Liquid Vapor Pressure:
  • Gas Compressibility Factor:
  • Control Valve P1 and P2 vs. Flow:
  • Liquid Pressure Drop in Pipe and Fittings:

Control Valve Resources

Why spend time designing all of your datasheets from scratch? 

Professionally designed datasheets in friendly Excel format that you may modify to suit your needs. Summarize the performance and technical characteristics of equipment and components in sufficient detail to be used by a design engineer for system integration. Specify typical values, ranges, tolerances, and nominal values.