Using a spreadsheet program you have written, rework Example 3-8 for the following cases...

Using a spreadsheet program you have written, rework Example 3-8 for the following cases:

Example 3-8

Design a baffle wall for one of a pair of flocculation basins using the following design parameters:

Q ⁼ 10,000 m³/d

Diameter of orifices ⁼ 100 mm

Orifice coefficient of discharge ⁼ 0.60

a. Given velocities of 0.55, 0.45, and 0.35 m/s, find the corresponding diameters in cm and headlosses for 60 orifices.

b. Given headlosses of 3, 6 and 9 mm, find the corresponding diameters and velocities for 60 orifices.