Pressure high at work. Must learn to go with the flow. Finding the balance.

Jan 14, 2008 22:16


I've heard of people doing entire PhD dissertations using Excel. I'm not surprised--it's a very useful, general-purpose tool. Today I used it to investigate the imbalance in the filling of two two-million gallon tanks that would result from asymmetrical piping (in which the water has to flow 330 feet further to get to the second tank). I did this by modeling the two paths the water could take, setting the flow in one path to a constant total minus the flow in the other path and using Excel's Solve function to balance the flows so that the pressure at the input to the two paths was equal. You can't just use algebra because the relationship between flow and pressure is nonlinear. (This method of modeling water flow isn't original with me, by the way. I learned it from psteger.)

The result was that the imbalance was in fact significant--the level in the second tank would be 9 feet (out of 40) lower than the level in the first tank when the first tank filled.

work

Previous post Next post
Up