ddkm, you have ignored the friction term in your Bernoulli set-up. The classic Bernoulli equation is for a frictionless system and you have to modify it. Check your Fluids Textbook. The terms of the Bernoulli equation must cover :
1. Pressure change - zero in your case as you have atmospheric both sides
2. Velocity head - to be calculated
3. Static head - 9.7 m in your case
4. Friction head - to be calculated
5. Internal energy change - negligible
6. Shaft work - not applicable to your system
7. PxV work - not applicable to liquids
Ignoring the zeroes and the N/A's you have
Static head + velocity head + friction head = 0
The math to solve this is ugly (for an old man like me) so that is why I said that once you have understood it, you just wack it with the software.
As the tank fills up, the level should never get above the top of the overflow pipe. That is why I said earlier that the actual nozzle on the side of the tank should be one size larger than the rest of the overflow piping.
Itdepends has highlighted a very important aspect here and the outlet nozzle probably needs to be designed with more attention than just to say "one size bigger".
I agree completely with
Itdepends that there are two separate calculations - one for the outlet nozzle and one to drive the liquid to the collection pot. This is probably what has caused the confusion over whether we should use the 300 mm or the 9700 mm as the driving force. When you separate it into the two components then it makes sense. 300 mm is the maximum driving for to get the water through the outlet nozzle, and 9700 mm is the maximum driving force to get the water to the collection pot. The Bernoulli analysis above applies to the second part of the problem.
However, I disagree that you can use all of the 300 mm as driving force to get the liquid through the exit nozzle. If the level in the tank gets above the top of the outlet nozzle then you will start to get air locks and surging.
In my previous posts I have deliberately ignored the aspect of making the vertical section of pipe self-venting because we have enough confusion as it is. But once you have sorted out what the situation is in terms of pressures, flows and velocities you will realize that the vertical leg is not running full if you select a standard size pipe. The section of pipe above the liquid level in the vertical leg must be wide enough to allow any entrained gas to escape back up the pipe, or it will reduce the density in the vertical leg and lower the driving force and therefore also lower the flow. If the exit nozzle runs flooded it will not be possible for this air to escape easily - hence my argument that the liquid level should be below the top of the nozzle. If the air cannot get out it would lead to oscillating flowrates as the vertical leg gradually filled up and then syphoned out.
By my calculations an 8" outlet and vertical leg down to the liquid level would be about the smallest you could use, but a 10" would be safer. The lower part of the vertical leg and the horizontal section could be 3". It is the requirement for self-venting that makes the pipe so big. If you don't require steady flow and you could put up with the surging you could make the whole line 3", but it would be hard to predict how much of the 300 mm ullage you would use during the air lock phase of the surge cycle.
Katmar Software
Engineering & Risk Analysis Software