(Draft) Excel table formula to calculate NPSHR (Net Positive Suction Head Required)

Here is the Excel table formula to calculate NPSHR (Net Positive Suction Head Required) in metric units:

=(((Pb - Pv) / (rho * g)) + h)

This formula is designed to calculate NPSHR in metric units, and the result will be in meters (m). In the formula, the variables have the following units:

Pb: Pressure of the liquid at the pump suction measured by a gauge (in units of Pa or kPa).

Pv: Vapor pressure of the liquid at the pump suction (in units of Pa or kPa).

rho: Density of the liquid at the pump suction (in units of kg/m^3).

g: Acceleration due to gravity (approximately 9.81 m/s^2).

h: Elevation difference between the pump suction gauge and the liquid surface (in units of meters, m).

To calculate NPSHR using the above formula in an Excel table, follow these steps:

1) Enter the formula into the desired cell in the Excel table.

2) Input the values for each variable, either through cell references or directly as numerical values. Make sure to use metric units for the variables Pb, Pv, rho, g, and h.

3) Once the formula is calculated, the NPSHR value will be displayed in meters (m).

You can use the provided formula in an Excel table to calculate NPSHR values in metric units accurately. Ensure that you use the appropriate unit for each variable and provide correct input values to obtain accurate results.