Outils de calcul Excel gratuits pour les ingénieurs procédés

Accès et téléchargement gratuits

My Engineering Tools a développé des outils de calcul Excel gratuits qui peuvent être téléchargés. Parmi ces outils, vous trouverez un outil de calcul du débit et de la perte de charge d’une plaque d’orifice (diaphragme). Ces outils couvrent les calculs clés que les ingénieurs doivent effectuer tout au long de leur travail et de leur carrière. De nouveaux outils sont ajoutés régulièrement.

Suivez‑nous sur Twitter
Question, remarque ? Contactez‑nous à contact@myengineeringtools.com

Outils de calcul Excel pour l’ingénierie

Clause de non‑responsabilité : tous ces outils ont uniquement pour but d’illustrer le contenu du site, ILS NE PEUVENT PAS ÊTRE UTILISÉS pour la CONCEPTION DÉTAILLÉE, il faut toujours se référer à un fournisseur réputé pour la conception détaillée

Accédez directement à la section qui vous intéresse

Psychrométrie de l’air - Compresseurs - Données et propriétés physiques - Systèmes de tuyauterie et dynamique des fluides - Pompes - Échangeurs de chaleur - Thermodynamique - Systèmes sous vide

Psychrométrie de l’air

Calculateur d’air humide	Article technique	Calculateur Excel
Ce calculateur permet de calculer différentes propriétés de l’air humide, généralement déterminées à l’aide d’un diagramme psychrométrique ou de Mollier, utiles pour divers types de tâches (sécheresse…)

Calculs en génie chimique

Calculateur BOD	Article technique	Calculateur Excel
Lors de l’analyse des eaux usées, il est crucial de pouvoir calculer la demande biochimique en oxygène afin de savoir si les effluents sont sûrs à rejeter. Ce calculateur permet de déterminer le BOD5 à partir de résultats expérimentaux.

Calculateur de solides totaux dans l’eau	Article technique	Calculateur Excel
Calculez les différents types de solides totaux dans l’eau grâce à cet article technique et à son calculateur Excel.

Gas Saturation Concentration in Water	Technical article	Excel calculator
Calculate the saturation concentration of gas in water

Tank purging minimum volume of gas Calculator	Technical article	Excel calculator
Explore various techniques for reducing oxygen concentration in tanks for product protection and safety. Learn about dilution, displacement, pressure-cycle, and evacuation-replacement purging methods. Calculate the minimum inert gas volume required with our free Excel calculator.

Compressors

Compressor power calculation tool	Technical article	Excel calculator
Understand how to calculate the required power for a compressor to achieve a given compression task. Use the calculator to practice the calculation formula explained in the technical article

Gas expander available energy calculation	Technical article	Excel calculator
Discover how to harness the power of gas expanders to optimize energy use in process industries. Learn to calculate available energy, outlet temperature, and more. Access our free Excel calculator for quick estimates

Polytropic compressor power calculation	Technical article	Excel calculator
Understand how to calculate the required power for a compressor using the polytropic coefficient of the compressor. Use the calculator to practice the calculation formula explained in the technical article

Data, physical properties

Antoine law : Saturation pressure of pure components	Technical article	Excel calculator
The Antoine equation, also known as Antoine’s Law, is a class of semi-empirical correlations that describe the relationship between vapor pressure and temperature for pure substances

Water Properties Excel calculation tool	Technical article	Excel calculator
Calculate the properties of water thanks to this Excel calculator that allows you to get density, viscosity, thermal conductivity and vapor pressure of water

Horizontal tank volume calculator	Technical article	Excel calculator
Young Engineers would be surprised how often it is required to calculate the volume of a tank because the factory do not have it tabulated. This calculators allows to determine the volume of horizontal cylindrical tanks with different kinds of ends.

Spherical tank volume calculator	Technical article	Excel calculator
Young Engineers would be surprised how often it is required to calculate the volume of a tank because the factory do not have it tabulated. This calculators allows to determine the volume of spherical tanks.

Vertical Cylindrical tank volume calculator	Technical article	Excel calculator
Young Engineers would be surprised how often it is required to calculate the volume of a tank because the factory do not have it tabulated. This calculators allows to determine the volume of vertical cylindrical tanks with different end standard shapes.

Boiling temperature of water	Technical article	Excel calculator
Calculate the boiling point of water depending on the pressure

Steam cost calculator	Technical article	Excel calculator
Estimate the cost of industrial steam generated in boilers, from the cost of fuel and characteristics of the steam (pressure)

Piping systems and fluid dynamics

Churchill friction factor calculation tool	Technical article	Excel calculator
The Churchill correlation, also known as the Churchill equation, is an explicit equation used to calculate the friction factor, which is used to estimate the pressure drop due to the flow of a fluid in a pipe

CV valve calculation tool - Liquid, gas and steam	Technical article	Excel calculator
Determine the control valve flow coefficient (Cv) for Liquid, Gas, or Steam services with our Excel calculation tool. Choose the relevant sheet, input valve and flow data, and instantly compute the required Cv for your desired flow at the necessary pressure drop. The tool also enables you to calculate flow using a known Cv and pressure drop.

Orifice flow and pressure drop calculation tool	Technical article	Excel calculator
How to size and calculate orifice plates for precise fluid flow control and measurement. You can access our Excel calculation tool to practice the concepts presented in the page

Pipe partially full	Technical article	Excel calculator
This webpage explains how to determine if a pipe is partially full, which is crucial for accurate calculations in scenarios like return pipes and condensate systems. An Excel calculator is proposed at the end of the article.

Pressure drop Excel calculation tool for incompressible flow	Technical article	Excel calculator
You can learn how to calculate the pressure drop of a fluid in a pipe, depending on the pipe characteristics (length, material, singularities). This particular tool is designed for incompressible flow (typically liquid).

Pressure drop Excel calculation tool for compressible flow, non choked	Technical article	Excel calculator
You can learn how to calculate the pressure drop of a fluid in a pipe, depending on the pipe characteristics (length, material, singularities). This particular tool is designed for compressible flow (gas) and for a pressure drop in the pipe <10% of the inlet pressure (non choked).

Pressure Safety Valve Sizing tool - Pressure Gas flow	Technical article	Excel calculator
This guide provides insights into pressure relief valve design and sizing, focusing on API 520 standards. It explains critical vs. subcritical flows and offers formulas for safety valve sizing, especially for steam applications. Engineers can select standard valve orifice sizes based on standardized designations.

Pressure Safety Valve Sizing tool - Pressure Liquid flow	Technical article	Excel calculator
This guide explains pressure relief valve design and sizing for liquid flow, emphasizing safety. It provides formulas and coefficients for calculating valve requirements based on API520 standards.

Pressure Safety Valve Sizing tool - Low pressure	Technical article	Excel calculator
This guide explains pressure relief valve design and sizing for low-pressure safety venting. It outlines theoretical formulas and coefficients for calculating valve flow. Note that this information is for low-pressure gas applications only.

Speed of sound calculation tool	Technical article	Excel calculator
This article offers insights into gas sonic velocity and critical pressure ratios, along with a downloadable Excel calculator for sonic velocity estimation. Sonic velocity represents the maximum attainable gas speed within a system, impacting aspects like pressure safety valves and flow constraints. Formula in both metric and imperial units are given.

Tank agitator power calculation	Technical article	Excel calculator
This page is explaining step by step how to calculate the power required for the motor of a turbine agitator of a tank holding liquid. An Excel calculator is given to illustrate the calculation methodology.

Check valve minimum velocity calculation	Technical article	Excel calculator
Understand why a minimum velocity is required to avoid damage to a check valve and excessive noise. Check our calculator to determine the minimum velocity for different kind of standard check valves.

Fluid velocity in pipe	Technical article	Excel calculator
Calculating the velocity of a fluid in a pipe is very important as many Engineering design are based on the velocity of a liquid or gas in pipes (it allows to calculate Reynolds for instance). The calculator allows you to calculate a liquid or gas velocity in a pipe.

Hydraulic diameter calculation	Technical article	Excel calculator
Whenever flow is not happening in a circular pipe it is required to calculate an equivalent diameter to be able to determine some values such as Reynolds number...

Terminal velocity calculator	Technical article	Excel calculator
Calculating the terminal velocity of a particle in a fluid has many industrial applications, for example to manage the handling of a suspension (make sure it will not demix), in designing fluidized beds...

Mixing tank blending time calculator	Technical article	Excel calculator
How long does it take to mix properly 2 easily miscible liquids together ? This calculator attempts to give an order of magnitude of the time needed.

Water hammer pressure rise calculator	Technical article	Excel calculator
If a water hammer phenomena is happening, for example when a valve is suddenly closing, the pressure in the pipe is increasing significantly. This calculator allows to estimate what will be the pressure when water is happening.

Steam trap : steam loss calculator	Technical article	Excel calculator
Knowing the diameter of the orifice of the steam trap, it is possible to calculate the steam leakage that will happen in case the steam trap remains stuck open.

Gas flowrate in long pipeline calculator	Technical article	Excel calculator
Calculate the flowrate of compressible fluids in long pipelines with significant pressure drop. Apply the isothermal, Weymouth or Panhandle equations

Pumps

Pump temperature rise calculation tool	Technical article	Excel calculator
Understand temperature rise in centrifugal pumps and its impact. Learn how to calculate temperature increase at no flow, low flow, and normal operation. Avoid pump damage with our calculation tools in both US and SI units. Ensure optimal pump performance and prevent thermal issues.

Conversion pressure / head	Technical article	Excel calculator
Very often the pressure at the discharge of a pump is given as head (in m or ft) but it can be necessary to convert that to an actual pressure. This calculator allows you to do just that.

Pump head rise calculation	Technical article	Excel calculator
When a pump is bringing a fluid from conditions A at its suction to conditions B at its discharge, there is typically a change in head ; this calculator allows to determine that.

Hydrostatic pressure calculator	Technical article	Excel calculator
Calculate the pressure generated by a column of liquid thanks to this calculator.

Pump power calculator	Technical article	Excel calculator
Determine the power required for a pump to perform a given duty, based on the conditions of the fluid at inlet, discharge, required capacity, pump efficiency...

Pump minimal flow calculator	Technical article	Excel calculator
Determine the minimal flow that needs to go through a centrifugal pump in order to prevent breakdowns and higher maintenance of he pumps

Pump noise estimate calculator	Technical article	Excel calculator
Learn how to calculate and reduce pump noise levels with our step-by-step guide. Discover the causes of pump noise, explore noise reduction strategies, and access our free Excel and online calculators to estimate pump noise levels accurately.

Pump full torque calculator	Technical article	Excel calculator
Learn how to calculate centrifugal pump full load torque with our step-by-step guide. Understand the relationship between torque, power, and speed, and access our free Excel and online calculators to simplify your engineering tasks.

Heat exchange

Condenser sizing Excel calculation tool	Technical article	Excel calculator
Learn about condensers and their crucial role in diverse industries. Explore their design process step-by-step, from gathering fluid properties to calculating heat flux. Access a free Excel tool for shell-tube condenser sizing, ensuring efficient heat exchange.

Heat conduction through a pipe calculation tool	Technical article	Excel calculator
This webpage provides a comprehensive overview of heat conduction through pipes, covering both simple and composite pipes. It delves into the underlying principles, introduces relevant formulas, and presents practical examples to illustrate the concepts. Additionally, a free Excel calculator is offered to facilitate heat conduction calculations.

Heat conduction through a wall calculation tool	Technical article	Excel calculator
This webpage provides a comprehensive overview of heat conduction through pipes, covering both simple and composite pipes. It delves into the underlying principles, introduces relevant formulas, and presents practical examples to illustrate the concepts. Additionally, a free Excel calculator is offered to facilitate heat conduction calculations.

Process furnace Shortcut method for efficiency estimation	Technical article	Excel calculator
Optimize energy consumption in process furnaces with our efficiency calculator. Track and improve furnace efficiency crucial for cost savings and environmental impact. Understand the heat losses, calculate efficiency, and ensure optimal combustion economics. Access our free Excel tool for quick, simplified calculations.

Air cooled heat exchanger sizing	Technical article	Excel calculator
This page is giving a calculation method to design step by step air heat exchangers.

Heat loss through an insulated pipe	Technical article	Excel calculator
When designing or troubleshooting a system, it may be required to calculate the heat loss (and then the temperature change) of a fluid through an insulated pipe.

Heat loss through a non-insulated pipe	Technical article	Excel calculator
When designing or troubleshooting a system, it may be required to calculate the heat loss (and then the temperature change) of a fluid through an uninsulated pipe.

Plate heat exchanger sizing	Technical article	Excel calculator
Get an idea of the required size of a plate heat exchanger to fit a defined application thanks to this calculator.

Duration to heat up or cool down a tank	Technical article	Excel calculator
Estimate the time it needs for a tank to be heated up, or in contrary, to be cooled down in between 2 temperatures.

Viscosity estimation from agitator power	Technical article	Excel calculator
This calculator helps to estimate the viscosity of a fluid in a tank knowing the type of agitator and the power necessary to agitate.

Thermodynamics

Mixture flash equilibrium calculation	Technical article	Excel calculator
When performing a liquid / vapor calculation, the characteristics of the infeed are available (flow rate and composition) while the characteristics of the vapor phase and liquid phase must be calculated (flow rate and composition). This calculator allows you to determine the vapor and liquid composition.

Ideal Gas Law calculation tool	Technical article	Excel calculator
Calculate all sorts of gas properties bases on the ideal gas law : pressure, molar volume, molar quantity, volume, volumetric flow, convert volumetric flowrate to different conditions.

Steam turbine - steam flow requirement	Technical article	Excel calculator
Steam turbine are often used to produce power, in process industry or power plant. This simple calculation tool allows to define what is the steam flow required per kWh produced.

Vacuum systems

Air leakage rate calculation (vacuum applications)	Technical article	Excel calculator
Explanations on how to calculate the air leakage rate inside a vessel under vacuum. An Excel calculator can be found here to calculate the rate of leakage.

From our sister website www.powderprocess.net, special tools related to bulk handling can be downloaded also for free :

Pneumatic conveying - Dilute Phase - Air only method

Pneumatic conveying - Dilute Phase - Rhodes method

Pneumatic conveying - Dilute Phase - Zenz Othmer method

Cyclone design calculation tool