A pump station includes a pump sump receives an idealized inlet flow that varies with time as follow: - Peak flow value = 70 l/s (takes place within 3 non-continuous hours a day) - Average flow value = 50 l/s (takes place most of the day); If the water is to be conveyed from the Pump Station at site A (water surface elevation= 10.00) to another tank B located at a water treatment plant at site B (water surface elevation= 20.05m) through a 6.0 km bituminous lined steel pipeline (roughness height for new lining layer conditions= 0.15mm). It is required to develop a dynamic excel sheet and to answer the following: a) Design the pipeline and get the minimum pipe diameter based on the peak discharge, available pipe diameters = 200, 250, 300, 350, 400, 450, 500, 600, 700 mm (velocity should not exceed 1.5 m/s) b) Determine the required pumping head (assume that the local losses is 10% of the friction losses). c) Draw the system curve and pump curve(s), and hence determine: i) The operating pumping discharges and pumping heads corresponding to the average and peak flow loads ii) Select the suitable No. of pumping units to satisfy the peak and average flow loads.