Build a spreadsheet that will allow you to solve all four types of fluid flow problems

The spreadsheet will have three tabs, one for SI and two identical ones for engineering units include an if statement to allow calculation of the friction factor for laminar or turbulent flow use eqn. 6.49 for turbulent friction factor

In the spreadsheet solve these problems

1) Water flows from a reservoir whose surface is at 5 ft elevation through 2000 ft of new galvanized 1/2 inch schedule 40 pipe to a second reservoir whose surface is at 3 ft elevation - there are 6 elbows, two tees (line flow), a globe valve, a sharp entrance and a submerged exit

a)find the flow rate

b)find the flow rate if the surface of the first tank is at 13 ft elevation and the pipe length is 100 ft

2) Air flows from a plenum at 1000 Pa gauge through a new sheet metal tube the tube length is 100 m and it includes 4 sheet metal elbows with K = 1.0 each and a gate valve with K=0.24 find the diameter for a flow rate of 0.5 m3/s

since the air is at near atmospheric pressure, you can use 1 atm values for the properties