How do I solve the colbrooke equation by iteration in Excel?
I want to program excel to check whether fluid flow is laminar, transitional,
or turbulent and use corresponding equations to solve for friction.
Laminar (re<2300) - friction = Re/64
Transitional (2300<re<4000) - friction use Churcill equation
Turbulent (re4000) - friction use colebrooke iterative equation
I have the flow type listed in one column and I would like the corresponding
friction factor to be listed in the adjacent column.
--Steve
|