Losses in Pipes do it in excel or other if possible Dimensio

Losses in Pipes (do it in excel or other if possible)

Dimension & Constants: Square pipe width = 4 mm Smooth bend radius = 8 mm (to channel center) Distance between pressure taps: Straight section: 70 mm Smooth bend section: 70 mm Sharp bend section: 70 mm #RA = right angle bend Determine the loss coefficients for the three sections: Straight, Smooth, & RA Bend from the data. And its uncertainty for each. If possible, |Graph the data to find K_f for the smooth bend from the slope of the plot and from the pressure drops from the sharp bend for each single flow rate, find k_f values.

Solution

The answer of following question is as follows..

The loss coefficient for the straight smooth pipe is 87