Control Valve Sizing Worksheets in Excel

Free Download

Features:

  1. Perform traditional Cv calculations.
  2. Graph the installed flow characteristic and installed gain of a valve when it is installed in a particular system.
  3. Space for four simultaneous calculations.
  4. Calculate required control valve capacity (Cv or Kv) for Minimum, Normal, Maximum and one additional flow condition.
  5. Engineering units are by default set to US units, but can be easily changed to SI units. 
  6. Comprehensive instructions.
  7. 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. Control Valve Sizing (Liquid and Gas) Excel Worksheets.
  2. IEC Control Valve Aerodynamic Noise (Mass and Volumetric) Excel Worksheet.
  3. IEC Control Valve Hydrodynamic Noise (Mass and Volumetric) Excel Worksheet.
  4. Typical xFz, Fd and FL Parameters for IEC Control Valve Calculations Excel Worksheet.
  5. Liquid Vapor Pressure for Control Valve Sizing Excel Worksheet.
  6. Gas Compressibility Factor Based on the Nelson-Obert Generalized Compressibility Charts Excel Worksheet.
  7. Control Valve P1 and P2 vs. Flow Excel Worksheet.
  8. 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.

Control Valve Sizing Excel Worksheets:

  • 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.