Replacement of manning’s tabled ratio by programmable fuctions
DOI:
https://doi.org/10.14295/holos.v22i2.12473Keywords:
Tabela das relações de Manning, Curve Expert, Funções Modeladas.Abstract
In this work, equations were modeled by the Curve Expert program to eliminate the laborious manual interpolation process of the Manning relations table and thus accelerate the process in urban infrastructure projects for micro stormwater drainage and sewage collection, both by gravity. Three functions were modeled: V/Vp(Q/Qp), for calculating the velocity "V", Y/D (Q/Qp) for calculation of the blade "Y" and R/D (Q/Qp) for calculating the hydraulic radius "R", three important parameters for infrastructure projects, after previously selecting the diameter of the commercial line pipe. Numerical checks were performed, using as a measurement parameter the manning relations table, the polynomial function of grade 10 was selected, which produced a correlation coefficient r²-->1, attesting great fidelity to the adjusted models, in addition, the verifications of the accuracy of the functions modeled with the MAPE (Mean Absolute Percentage Error) method were performed to show the efficiency it provides. The results were efficient for the measurement of velocity (V), water slide (Y) and hydraulic radius (R) in circular section pipes operating under atmospheric pressure, with excellent numerical assertiveness. And it was proven that the functions found are of real value to urban infrastructure designers.
References
ANDRADE, J.B. Fotogrametria. 2. ed. SBEE, 2003. 274 p.
AZEVEDO NETO, M. F. et al. Manual de Hidráulica. 8. ed. São Paulo: Blucher, 1998.
CHAPRA, STEVEN.et al. Métodos numéricos para ingenieros. 5. ed. México: Miembro de la Câmara Nacional de la Industria Editorial Mexicana, 2007
CHEIN, FLÁVIA. Introdução os modelos de regressão linear: um passo inicial para compressão de econometria com uma ferramenta de avaliação políticas públicas. Brasilia: Enap, 2019.
DAVIS, C. V,; SORENSEN, K. E. Handbook of Applied hydraulics. 3. ed. Chicago: McGraw-Hill Book Company, 1969.
FELIX, FRANCISCA E. F. O método dos mínimos quadrados aplicado ao ajuste de curva. Paraíba: Iniciação cientifica hipátia. 2019.
HYAM, DANIEL G. Home. Curve expert. Disponível em: https://www.curveexpert.net/. Acesso em: 14 mar. 2022.
MENEZES FILHO, F. C. M; COSTA, A. R. Sistema de cálculo para o dimensionamento de galerias de águas pluviais: uma abordagem alternativa. Goiás: Revista Eletrônica de Engenharia Civil, 2012.
MIKHAIL, E.; ACKERMAN, F. Observations and least squares. University Press of America, 1976.
MYTTENAERE, ARNAUD, et al. Mean absolute percentage error for regression models, Neurocomputing, 2017. https://doi.org/10.1016/j.neucom.2015.12.114 DOI: https://doi.org/10.1016/j.neucom.2015.12.114
NEVES, RENATO A. O método dos mínimos quadrados: estudo e aplicação para o ensino médio. Dissertação (Mestrado), 2015.
PORTO, RODRIGO M. Hidráulica básica. 4. ed. São Carlos: EESC-USP, 2006.
RÍSPOLI, ÍTALO A. G. et al. Estática básica. 3. ed. rev. Indaiatuba (SP): Gráfica e Editora Vitória, 2017.
STOCK, J. H.; WATSON, M. W. Introduction to econometrics. 3. ed. Addison: Wesley Series in Economics, v. 1. Addison-Wesley, 2010.