Control Valve Sizing & Noise Analysis Toolkit (Excel, ISA/IEC)
We've expanded our image gallery! Discover more examples in the updated carousel.
Calculate Control Valve Sizing, Noise, Installed Flow, Installed Gain, and More with Excel.
Calculate control valve sizing, noise, installed flow, installed gain, and more with our powerful Excel software. Designed to help engineers avoid the consequences of improperly sized control valves, such as inefficient operation and potential safety hazards.
Based on ISA/IEC standards, our tool empowers you to analyze critical parameters like aerodynamic and hydrodynamic noise, installed flow characteristics, and installed gain. It is designed to assist engineers in ensuring optimal performance and mitigating risk.
Extensive Documentation and Articles are included.
Important Note: This software is intended for use by qualified engineers with a strong understanding of control valve sizing principles or under the direct supervision of a qualified instructor or experienced engineer. When used in real-world applications, users are solely responsible for validating results and ensuring compliance with all applicable safety regulations.
For a one-time purchase of $159, gain access to this comprehensive analysis toolkit.
April 2022 Worksheet that performs a valve sizing calculation for liquid flow without requiring an iterative solution. The ISA and IEC control valve sizing standards list formulas for liquid valve sizing that require an iterative solution whenever pipe reducers are involved upstream and downstream of the control valve. An iterative solution is required because the valve flow capacity, Cv, is one of the parameters that goes into the formulas, but it is Cv that one needs to solve for. Jon Monsen's method is so simple that it can be completely described in a three page magazine article Simplified Methods for Liquid Control Valve Sizing and it gives the EXACT same results as an iterative solution.
October 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. This is an enhanced version of the “Calculate and Graph Control Valve Installed Flow and Gain 2021 Worksheet" shown as list item 2 below. There are no errors in the item 2 version below, but enhancements were left out so it would fit into a magazine article. This one is a lot nicer and it also has a Read Me tab with instructions, and a tab with the article in Process Instrumentation magazine, and to an older article discussing installed gain.
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.
2019 Full Function/Feature Control Valve Sizing Application Workbooks
Includes control valve sizing calculations in accordance with ISA/IEC standards and noise calculations in accordance with IEC standards.
Includes 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.
Posesses 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.
Built-in documentation.
Perform traditional Cv calculations.
Space for four simultaneous calculations.
Calculate 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 be easily changed to SI units.
Comprehensive instructions.
Based on ANSI/ISA-75.01.01 (IEC 60534-2-1 Mod) -2012 "Flow Equations for Sizing Control Valves."
Control Valve Sizing Calculations: See Examples from Our Workbooks
Control Valve Excel Worksheet Sets included in the product:
Control Valve Aerodynamic Noise - October 2022 Worksheet
Control Valve Hydrodynamic Noise - July 2022 Worksheet
Valve Sizing Calculation for Liquid Flow Without Requiring an Iterative Solution - April 2022 Worksheet.
Enhanced Calculate and Graph Control Valve Installed Flow and Gain - October 2021 Worksheet.
Calculate and Graph Control Valve Installed Flow and Gain - 2021 Worksheet.
Control Valve Hydrodynamic Noise - non IEC - simplified - 2020 Worksheet.
Control Valve Sizing with IEC Noise - Liquid - 2019 Workbook.
Control Valve Sizing with IEC Noise - Gas (Volumetric) - 2019 Workbook.
Control Valve Sizing with IEC Noise - Gas (Mass) - 2019 Workbook.
Control Valve Sizing (Liquid and Gas) Excel Worksheets - Legacy Version.
IEC Control Valve Aerodynamic Noise (Mass and Volumetric) Excel Worksheet - Legacy Version.
IEC Control Valve Hydrodynamic Noise (Mass and Volumetric) Excel Worksheet - Legacy Version.
Typical xFz, Fd and FL Parameters for IEC Control Valve Calculations Excel Worksheet.
Liquid Vapor Pressure for Control Valve Sizing Excel Worksheet.
Gas Compressibility Factor Based on the Nelson-Obert Generalized Compressibility Charts Excel Worksheet.
Control Valve P1 and P2 vs. Flow Excel Worksheet.
Liquid Pressure Drop in Pipe and Fittings Excel Worksheet.
DISCLAIMER
These worksheets are distributed on an as-is basis. The author and INDUSTRYDOCS DO NOT assume any liability for their use.
Note: Worksheets are protected with either the password: "eliminator" or no password.
October 2022 Worksheet that predicts control valve aerodynamic noise.
Control Valve Aerodynamic Noise - October 2022 Worksheet: Aerodynamic_Noise_ABC_CVAT.xlsx
July 2022 Worksheet that predicts control valve hydrodynamic noise.
Control Valve Hydrodynamic Noise - July 2022 Worksheet: Hydro_ABC_Enanced_CVAT.xlsx
April 2022 Worksheet that performs a valve sizing calculation for liquid flow without requiring an iterative solution.
Valve Sizing Calculation for Liquid Flow Without Requiring an Iterative Solution - April 2022 Worksheet: Liquid_Valve_Sizing_Non-Iterative.xlsx
Enhanced October 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.
Enhanced Calculate and Graph Control Valve Installed Flow and Gain 2021 Worksheet: Graph_Installed_Flow_and_Gain_enhanced_101021.xlsx
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: Graph_Installed_Flow_and_Gain.xlsx
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: Hydrodynamic_Noise_Valve_World_Baumann_121819.xlsx
2019 Workbooks intended as full function control valve sizing applications
Liquid - Control Valve Sizing with IEC Noise 2019 Workbook: Valve_Sizing_W_IEC_Noise-Liquid.xlsx
Gas Volumetric Flow - Control Valve Sizing with IEC Noise 2019 Workbook: Valve_Sizing_W_IEC_Noise-Gas_Volumetric.xlsx
Gas Mass Flow - Control Valve Sizing with IEC Noise 2019 Workbook: Valve_Sizing_W_IEC_Noise-Gas_Mass.xlsx
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: CV_Sizing-Liquid_Rev_3.5b.xlsx
Gas (Volumetric flow units where the molecular weight or specific gravity is known): CV_Sizing-Gas_ Vol_Flow_Rev_3.5.xlsx
Gas (Mass flow units where the density is known. This includes steam): CV_Sizing-Gas_Mass_Flow_Rev_3.5.xlsx
90 Deg to Relative Travel Table: 90_Deg_to_Relative_Travel_Table_Rev_0.xlsx
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.