Free Excel calculation tools for Process Engineers
Access and download for free
My Engineering Tools has developed free Excel calculation tools that can be downloaded. Those calculation tools cover key calculations that Engineers have to do all along their work and career. New tools are added regularly.
Follow us on Twitter
Question, remark ? Contact us at contact@myengineeringtools.com
Engineering Excel Calculation tools
Disclaimer : all these tools are only aiming at illustrating the content of the website, THEY CANNOT BE USED for DETAIL DESIGN, always link with a reputable supplier for detail design
|
Access directly the
section of your interest
Air Psychrometrics - Compressors - Data and Physical Properties - Piping Systems and Fluid Dynamic - Pumps - Heat Exchange - Thermodynamic - Vacuum Systems |
Air Psychrometrics
| Humid air calculator |
 Technical
article |
 Excel calculator |
| This
calculator allows to calculate different properties of humid
air, usually determined thanks to a psychrometric or Mollier
diagram, and that are coming handy for different kind of tasks
(drying...) |
 |
|
Chemical Engineering Calculations
| BOD Calculator |
Technical
article |
Excel calculator |
| When
analyzing waste water it is crucial to be able to calculate
the biochemical demand in oxygen to know if those effluents
are safe to release. This calculator allows to determine the
BOD5 based on experimental results |
||
| Total Solids
in Water Calculator |
Technical
article |
Excel calculator |
| Calculate
the different kind of total Solids in water thanks to this
technical article and Excel calculator |
||
| 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. |  |
|
Top 5 Most
Popular
1. Compressor
Power Calculation
2. Pump Power Calculation
3. Pipe Pressure
Drop Calculation
4. Fluid Velocity in pipes
5. Churchill Correlation (friction
factor)
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