Input each pipe section into the excel calculator. Easily insert whether or not the pipe section is on the hydraulically remote run and if it is in the suction or discharge. Then indicate the flow rate, pipe material, pipe size and pipe length. The calculator will then calculate the inner area, inner diameter, reynolds number and all other necessary calculations to determine the pressure loss and velocity in the pipe.

The second set of losses is due to equipment losses. These losses include chillers, cooling towers, coils, flow meters, etc. The calculator has a section where you can add in these losses. These losses should be provided to you by the manufacturer. The third set of losses is due to pipe expansions and reductions. These types of losses are calculated differently from pipe fittings.

The outputs of the calculator is a summary of the various pressure drops (piping ,equipment and pipe expansions/reductions). Also there will be losses due to elevation if the condenser water system is open. The calculator automatically accounts for this type of situation and separates the elevation head on the pump suction and discharge. This will tell you the total dynamic head and the net positive suction head available.

The pipe expansions and reductions section includes tapered, rounded and many more types of transitions.

The calculator comes with all the standard pipe types used in condenser water systems, like steel (schedule 40 and 80), copper (type K, L, M), polypropylene, PVC, etc. The calculator automatically determines the inner diameter and inner area of your selected pipe.

The calculator also includes the pipe properties like roughness and pipe types within each material. There is also the possibility of expanding the calculator to include more pipe materials and pipe types under the placeholders (user_1, user_2 and user_3)

This figure shows the available pipe sizes within each pipe material & type combination. This is just a snippet of the calculator, there are many more pipe types and materials, as shown in the figure on the right.

This figure shows the available pipe sizes within each pipe material & type combination. This is just a snippet of the calculator, there are many more pipe types and materials, as shown in the figure on the left.

All of the standard pipe fittings are available within the calculator. You can easily add a fitting to a pipe run by just inputting the number of each fitting under the corresponding column. This figure shows the available pipe fittings and the two joining methods that are common for condenser water piping.

The calculator automatically combines the various pipe fittings with the various pipe materials and finds the correct pressure drop through the pipe material and fitting combination.

The elevation will affect the net positive suction head available (NPSHA). The calculator will automatically determine the absolute pressure available for these calculations, once you input the elvation of your project.

Condenser water systems will be water, but the temperature of the water will affect the viscosity and vapor pressure which will affect the total dynamic head and NPSHA calculations. The calculator will automatically adjust the fluid properties, which will automatically adjust the TDH and NPSHA calculations.

The 1st sheet includes detailed instructions on how to operate the calculator, but it is relatively simple to operate the calculator and you may not need the instructions. More importantly, there is a link to the condenser water pump design guide that will give you more insight into how to design a condenser water pump and a condenser water system. In addition, you will also get the contact information of Justin, who will be able to answer any of your questions or be able to edit the calculator to suit your needs.

The 1st sheet of the calculator includes a list of the frequently asked questions. This picture shows a snippet of the common questions and answers.