Thread Content
Recently, I saw the diameter calculation tables prepared by our company using EXCEL, and I noticed that the formula for the friction coefficient used in those tables was taken from a certain paper; the friction coefficient calculated using this formula has a rather large error. The formula for the friction coefficient in the paper is as follows: Moreover, this EXCEL sheet does not include the friction coefficients for fittings and valves. If it’s just about calculating the pipe diameter, that’s definitely possible. However, it is not very convenient for calculating the pressure drop of specific pipelines, such as that of control valves. For convenience in my work, I wrote a small software program in C# for calculating pipe pressure drop. The formula for the friction coefficient was taken from that used in pump head calculations by a large engineering company in China (it is actually derived from a research paper as well, but the formula there is more precise); the calculation results were verified by referring to relevant charts, and they matched fairly well. The software screenshot is as follows: It can be shared with everyone for use if needed. Equivalent length of pipe fittings in the software: elbow 35D, gate valve 117D, globe valve 388D, check valve 100D, tee 50D, reducer 20D, filter 35D; K for the container inlet is set to 0.78, and K for the container outlet is set to 1.