| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I solve the colbrooke equation by iteration in Excel?
I would use a UDF. Use the mode either 1 or 2 to return the value or the type
Function Fluid_Flow(mode As Integer, re As Single) Select Case mode Case 1 Select Case re Case Is < 2300 Fluid_Flow = "Laminar" Case Is = 4000 Fluid_Flow = "Transitional" Case Else Fluid_Flow = "Turbulent" End Select Case 2 Select Case re Case Is < 2300 Fluid_Flow = "add formula" Case Is = 4000 Fluid_Flow = "add formula" Case Else Fluid_Flow = "add formula" End Select End Select End Function "Steve M." wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I solve the colbrooke equation by iteration in Excel?
Have you checked this site?
http://www.cheresources.com/colebrook1.shtml "Steve M." wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I solve the colbrooke equation by iteration in Excel?
Does your code use the visual basic editor in excel? How would I write a simple do loop to perform the iteration for the colbrooke equation? Thank, --Steve M. "Joel" wrote: I would use a UDF. Use the mode either 1 or 2 to return the value or the type Function Fluid_Flow(mode As Integer, re As Single) Select Case mode Case 1 Select Case re Case Is < 2300 Fluid_Flow = "Laminar" Case Is = 4000 Fluid_Flow = "Transitional" Case Else Fluid_Flow = "Turbulent" End Select Case 2 Select Case re Case Is < 2300 Fluid_Flow = "add formula" Case Is = 4000 Fluid_Flow = "add formula" Case Else Fluid_Flow = "add formula" End Select End Select End Function "Steve M." wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I solve the colbrooke equation by iteration in Excel?
No, but I will. Articles appear helpful. "JLGWhiz" wrote: Have you checked this site? http://www.cheresources.com/colebrook1.shtml "Steve M." wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I solve the colbrooke equation by iteration in Excel?
What caught my eye was the Excel spreadsheet download that they have in zip
file format. I didn't check it but it could answer all of your questions. "Steve M." wrote: No, but I will. Articles appear helpful. "JLGWhiz" wrote: Have you checked this site? http://www.cheresources.com/colebrook1.shtml "Steve M." wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you help me to solve the below equation in excel ? | Excel Worksheet Functions | |||
| how can I solve two equation with excel? | Excel Discussion (Misc queries) | |||
| How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
| Using iteration to solve a two-parameter equation | Excel Discussion (Misc queries) | |||
| How do I define and solve a maths equation using excel? | New Users to Excel | |||
Linear Mode
