I was trying to calculate the fT values for small pipe or copper tubing and I noticed an apparent discrepancy between the Crane fT values and the friction factor for straight clean commercial schedule 40 steel pipe (See attached Excel) at fully turbulent flow. Is this just a calculation difference or does anybody have a different explanation?
Additionally, since the values don't seem to match, I am not sure if I can use the calculated fully turbulent friction factor for smaller pipe sizes such as 1/4", 3/8", or for tubing. How do I approach this using Crane's method?