info:eu-repo/semantics/article
Determination of the darcy pipe flow friction factor as a routine in visual basic for ms excel.
Autor
MARIA TERESA ALARCON HERRERA
IGNACIO MARTIN
Institución
Resumen
An algorithm for the calculation of the Darcy friction factor, for the estimation of pressure losses in pipe flows, is presented. The algorithm includes the five correlations that generate the Moody chart. The codification of the algorithm in Visual Basic for Applications, for use in the MS Excel
spreadsheet, is presented. The Prandtl and Colebrook correlations, which are not explicit in the friction factor, are solved through a Newton numerical method; the derivatives of
the functions are obtained through a numerical central perturbation procedure. The algorithm also calculates the values of the friction factor for the critical flow zone, between the zones of laminar and turbulent flow, in order to avoid numeric discontinuities during optimization processes. The
results are shown as an Excel-generated Moody chart.
Ítems relacionados
Mostrando ítems relacionados por Título, autor o materia.
-
Compendio de innovaciones socioambientales en la frontera sur de México
Adriana Quiroga -
Caminar el cafetal: perspectivas socioambientales del café y su gente
Eduardo Bello Baltazar; Lorena Soto_Pinto; Graciela Huerta_Palacios; Jaime Gomez -
Material de empaque para biofiltración con base en poliuretano modificado con almidón, metodos para la manufactura del mismo y sistema de biofiltración
OLGA BRIGIDA GUTIERREZ ACOSTA; VLADIMIR ALONSO ESCOBAR BARRIOS; SONIA LORENA ARRIAGA GARCIA