View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve M. Steve M. is offline
external usenet poster
 
Posts: 1
Default 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