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.