A two Pass tube, baffled spacing single pass shell and tube HE is used to cool down hot methanol. cooling water flows thru tubes at 25C and a flow rate of 30 kg/sec. Methanol enters the shell at 90 C and should leave at 40C with 152kg/ sec. Perform a detailed deign of the exchanger to determine the surface area of this HE for a valid desigh where shell diameter between the range of (0.15, 0.25m) and the pressure drop across the exchanges both sides less than 0.75atm.
Counter Current, Triangular Pitch and Do= 23.2mm BWG= 16
Please HELP ME FIND AN EXCEL FILE THAT COULD DO ME THIS CALCULATION
As I am stuck in the hand calculation until finding the Friction Factor.