Consider water flowing through an ANSI Schedule 40 commercial steel pipe. Look up pipe dimensions and properties to determine the following: a) Calculate the volume flowrate (in GPM) and velocity (in ft/s) at which the flow through the tube becomes turbulent. b) Use Excel to plot the friction factor in the tube for flowrates from 0 to 100 GPM. On a second y-axis plot the pressure drop per unit length of tube. c) Calculate the percent difference between the Haaland and Colebrook equations at 100 GPM. Use Excel to iterate a solution to the Colebrook equation and include a screenshot of the iterative solution. d) Work in base SI units and convert answers to English/British systems as required. Include your .csv file with your homework solution for full credit. Problem 2 If air under standard conditions blows around the exterior of the pipe from problem 1, calculate the drag assuming the exterior of the pipe is smooth. Assume a wind velocity of 30 m/s.