{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Presentacion ","Criterios de diseño ","relaciones hidraulicas ","Diseño Cribado","Diseño Desarenador "],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Presentacion ","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,7,33,12],[34,7,34,12],[28,6,28,12],[25,6,26,12],[32,7,32,12],[23,6,23,12],[21,5,21,8],[24,6,24,12],[11,6,19,12],[22,6,22,12],[30,7,30,12],[29,7,29,12],[31,7,31,12],[3,0,7,5],[3,6,3,12],[5,6,5,12],[7,8,7,12],[7,6,7,7]]}
[]
[]
[]
[null,null,null,null,null,null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO"]
[]
[null,null,null,null,null,null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE"]
[]
[null,null,null,null,null,null,"Trabajo de grado: ",null,"Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar (cribado y Desarenador) de aguas residuales"]
[]
["Autores "]
[null,null,null,null,null,"Introducción "]
[null,"Belquis Sepúlveda Mancipe ",null,null,null,null,"El objetivo del aplicativo es analizar el operaciones unitarias de los sistemas de tratamiento preliminar de aguas residuales, analizando operaciones básicas de tipo físico para la separación de solidos de gran tamaño y arenas. \n\nLos procesos analizados en el presente aplicativo corresponden a sistemas de cribado, el cual se emplea para la separación de materiales gruesos mediante el paso del fluido mediante cribas o rejillas,  y Desarenadores, los cuales se emplean principalmente para la remoción de materiales como arenas, gravas y otros. "]
[null,"Ingeniera Sanitaria "]
[null,"Especialista en Ingeniera Ambiental "]
[]
[null,"Javier Sierra Mesa "]
[null,"Ingeniero Civil "]
[]
["Apoyo técnico: "]
[null,"Fernando Gama Doza"]
[null,"Ingeniero de Sistemas "]
[null,"Especialista en bases de datos",null,null,null,"Configuración Inicial de Excel "]
[]
["Tutor:",null,null,null,null,null,"1. Activación de la opción Programador en Excel: Ir a Archivo -Opciones de Excel - Personalizar Cinta de Opciones -Comandos mas Usados. Incluir \"Programador\""]
[null,"Jairo Alberto Romero Rojas ",null,null,null,null,"2. Activar Macros: Una vez se activa el programador buscar en la Pestaña \"Programador\"-seguridad de macros -Configuración de macros -Habilitar todas las macros "]
[null,"Ingeniero civil ",null,null,null,null,"3. Habilitar la Opción solver ir a Archivo -Opciones de Excel -Complementos-seleccionar complementos de Excel- seleccionar Solver -Seleccionar Aceptar"]
[null,"Master of engineering "]
[null,null,null,null,null,"Bibliografía "]
[null,null,null,null,null,null,"Para la elaboración del aplicativo se emplean diferentes fuentes entre las cuales e encuentran: "]
[null,null,null,null,null,null,1,"Qasim, S (1999). Wastewater treatment plants - Planning, desing and operation. Second Edition"]
[null,null,null,null,null,null,2,"Metcalf & Eddy Inc. Wastewater Engineering: Teatment and Reuse, McGraw Hill, 2003"]
[null,null,null,null,null,null,3,"Tchobanoglous, Crites, Aguas Residuales Para Núcleos Pequeños, 2000."]
[null,null,null,null,null,null,4,"Romero Jairo, Tratamiento de Aguas Residuales, Teoría y Principios de Diseño,  3a Ed. 2004"]
[null,null,null,null,null,null,5,"WEF, ASCE. Desing of municipal Wasteater Treatment Plans, 5a  Ed.2009"]
[null,null,null,null,null,null,6,"WEF, Natural Systems for Wastewater Treatment MOPFD -16, 3a Ed. 2010"]

{"sheet":"Criterios de diseño ","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[10,16,10,17],[11,16,11,17],[12,16,12,17],[14,11,14,16],[7,9,7,17],[7,1,7,5],[1,1,5,1],[1,2,1,17],[3,2,3,17],[5,2,5,3],[5,4,5,17],[20,6,20,8],[20,3,20,5],[8,1,8,5],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[9,2,9,5],[17,1,17,17],[19,1,19,8],[20,15,20,17],[19,10,19,17],[20,12,20,14],[9,16,9,17],[27,12,27,14],[27,15,27,17],[28,3,28,5],[27,3,27,5],[28,6,28,8],[27,6,27,8],[28,12,28,14],[28,15,28,17]]}
[]
[null,null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO"]
[]
[null,null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE"]
[]
[null,null,"Trabajo de grado: ",null,"Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar (cribado y Desarenador) de aguas residuales"]
[]
[null,"COEFICIENTE DE RUGOSIDAD PARA DIFERENTES MATERIALES",null,null,null,null,null,null,null,"CRITERIOS TEORICOS DE DISEÑO DEL DESARENADOR "]
[]
[null,null,"Manning´s n (adimensional)",null,null,null,null,null,null,null,null,"Profun","Long","Ancho ","R L:A","R A:P"]
[null,"Hierro Colado",null,1.2E-2,"a",1.4999999999999999E-2,null,null,null,null,"Desarenedor de Flujo Horizontal ","2 - 5",null,null,"2,5:1 -5:1"]
[null,"Hormigon o Revestido en Hormigon ",null,1.2E-2,"a",1.7000000000000001E-2,null,null,null,null,"Desarenador Aireado ","2 - 5","8 -20","2,5 - 7","3:1 - 5:1"]
[null,"Hierro Galvanizado ",null,1.4999999999999999E-2,"a",1.7000000000000001E-2,null,null,null,null,"Desarenador Tipo Vórtice","2,5 - 5"]
[null,"Plástico",null,1.0999999999999999E-2,"a",1.4999999999999999E-2]
[null,"Acero ",null,1.4999999999999999E-2,"a",1.7000000000000001E-2,null,null,null,null,"R L:A R elacion Largo: Ancho ","Velocidad Minima del agua 0,2-0,4 m/s"]
[null,"Arcilla Vitrificada ",null,1.2999999999999999E-2,"a",1.4999999999999999E-2,null,null,null,null,"R:A:P Relación Ancho: Profundidad","Tiempo de Retencion Hidraulica 20seg -3 min"]
[]
[null,"CRITERIOS TEORICOS DE DISEÑO DEL CRIBADO."]
[]
[null,"Criterios de diseño de las rejas manuales y mecanicas gruesas",null,null,null,null,null,null,null,null,"Criterios de diseño de las rejas manuales y mecanicas finas "]
[null,"Factor de diseño","Unidad ","Manual",null,null,"Mecanico",null,null,null,"Factor de diseño","Unidad ","Manual",null,null,"Mecanico"]
[null,"Velocidad a través de la reja ","m/s",0.6,"a",1.2,0.6,"a",1.2,null,"Velocidad a través de la reja ","m/s",0.6,"a",1.2,0.6,"a",1.2]
[null,"Tamaño de las barras",null,null,1.4999999999999999E-2,null,null,null,null,null,"Tamaño de las barras"]
[null,"Ancho de barras","mm",4,"a",8,8,"a",10,null,"Ancho ","mm",4,"a",8,8,"a",10]
[null,"Profundidad ","mm",25,"a",50,50,"a",75,null,"Profundidad ","mm",25,"a",50,50,"a",75]
[null,"Separación entre barras ","mm",40,"a",100,40,"a",100,null,"Separación entre barras ","mm",10,"a",20,10,"a",20]
[null,"Inclinación ","Grados",45,"a",60,60,"a",90,null,"Inclinación ","Grados",45,"a",60,75,"a",85]
[null,"Perdida de carga permisible, reja obstruida","mm",150,null,null,150,null,null,null,"Perdida de carga permisible, reja obstruida","mm",150,null,null,150]
[null,"Máxima perdida de carga, reja obtruida ","mm",800,null,null,800,null,null,null,"Máxima perdida de carga, reja obtruida ","mm",800,null,null,800]
[null,"Angulo de inclinacion de la reja ","º ",75,null,null,75,null,null,null,"Angulo de inclinacion de la reja ","º ",75,null,null,75]

{"sheet":"relaciones hidraulicas ","index":2,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"n ",{"$f":"'Diseño Cribado'!E23","v":1.4999999999999999E-2},"q",{"$f":"'Diseño Cribado'!E15","v":0.1},"q/Q",{"$f":"F2/F3","v":0.64749218490881377}]
[null,null,"R",{"$f":"'Diseño Cribado'!E29","v":0.1275},"Q",{"$f":"(0.312/D2)*(D5^(8/3))*(D4^(1/2))","v":0.15444201849954836},"v/V",{"$f":"LOOKUP(M9,K8:K107,J8:J107)","v":1.0587590048440849},null,"v",{"$f":"H3*F4","v":0.79963963519462855}]
[null,null,"S",{"$f":"'Diseño Cribado'!E22","v":2E-3},"V",{"$f":"(1/D2)*(D3^(2/3))*(D4^(1/2))","v":0.75526123653832367},"y/D",{"$f":"LOOKUP(M9,K8:K107,I8:I107)","v":0.57821723263153357},null,"y",{"$f":"H4*D5","v":0.29489078864208212},null,{"$f":"LOOKUP(H2,K8:K107,J8:J107)","v":1.0587590048440849},"se aproxima al menor"]
[null,null,"D",{"$f":"'Diseño Cribado'!E25","v":0.51},null,null,null,null,null,null,null,null,{"$f":"MATCH(M4,J8:J107,0)+1","v":56},"la fila en la que esta el numero por ensima"]
[null,null,"theta","y/D","v","V_full","q","Q_full","y/D","v/V_full","q/Q_full",null,{"$f":"INDEX(K8:K107,M5)","v":0.66101511781230715},"este es el numero por ensima"]
[null,0,0,0,0,null,null,null,0,null,null,null,{"$f":"INDEX(K8:K107,M5-1)","v":0.63438889579080526},"el numero por abajo"]
[null,0.01,3.141592654E-2,2.4671981719864844E-4,3.1114882008657892E-3,0.41135777681927327,6.755982589622973E-10,1.357742197241114E-2,2.4671981719864844E-4,7.5639464626745014E-3,4.9758949845934666E-8,null,{"$f":"(M6+M7)/2","v":0.64770200680155621},"el promedio"]
[null,0.02,6.283185308E-2,9.8663578612179226E-4,7.8373642106336246E-3,0.41135777681927327,1.3605772180362692E-8,1.357742197241114E-2,9.8663578612179226E-4,1.9052427478663925E-2,1.0020880405727361E-6,null,{"$f":"IF(H2>=M8,M6,M7)","v":0.63438889579080526},"y el numero mas aproximado"]
[null,0.03,9.424777962E-2,2.2190176990390387E-3,1.3448461468755153E-2,0.41135777681927327,7.8717426604346136E-8,1.357742197241114E-2,2.2190176990390387E-3,3.2692858204218724E-2,5.7976710721886136E-6]
[null,0.04,0.12566370616,3.9426493437893506E-3,1.9717755732706684E-2,0.41135777681927327,2.731944186246136E-7,1.357742197241114E-2,3.9426493437893506E-3,4.7933348641587784E-2,2.0121229139061552E-5]
[null,0.05,0.15707963270000003,6.1558297040353871E-3,2.6518953161990388E-2,0.41135777681927327,7.1635627686719438E-7,1.357742197241114E-2,6.1558297040353871E-3,6.4466881766626419E-2,5.2760846523206401E-5]
[null,0.06,0.18849555924,8.8563746379616282E-3,3.3767781734619723E-2,0.41135777681927327,1.5728079873776351E-6,1.357742197241114E-2,8.8563746379616282E-3,8.2088594497279496E-2,1.1583995773082161E-4]
[null,7.0000000000000007E-2,0.21991148578000003,1.2041619033758222E-2,4.1402032489898037E-2,0.41135777681927327,3.0543606799922094E-6,1.357742197241114E-2,1.2041619033758222E-2,0.10064725847662213,2.2495880927900499E-4]
[null,0.08,0.25132741232,1.5708419439765031E-2,4.9372661946659235E-2,0.41135777681927327,5.420938373652961E-6,1.357742197241114E-2,1.5708419439765031E-2,0.12002365028424081,3.9926124301565668E-4]
[null,0.09,0.28274333885999997,1.9853157166678459E-2,5.7639165690357555E-2,0.41135777681927327,8.980589592415116E-6,1.357742197241114E-2,1.9853157166678459E-2,0.1401193047474118,6.6143555165799287E-4]
[null,0.1,0.31415926540000005,2.4471741858761276E-2,6.6166916221836444E-2,0.41135777681927327,1.4088681835135389E-5,1.357742197241114E-2,2.4471741858761276E-2,0.16085004332106342,1.0376551501281401E-3]
[null,0.11,0.34557519194000003,2.9559615530529659E-2,7.4925516418358262E-2,0.41135777681927327,2.1146338175155858E-5,1.357742197241114E-2,2.9559615530529659E-2,0.18214197139459012,1.5574634284862398E-3]
[null,0.12,0.37699111848,3.5111757064934745E-2,8.388772466153116E-2,0.41135777681927327,3.0598166885637898E-5,1.357742197241114E-2,3.5111757064934745E-2,0.20392886530594645,2.2536065350117519E-3]
[null,0.13,0.40840704502000003,4.1122687168598737E-2,9.3028723272729E-2,0.41135777681927327,4.2929331908648123E-5,1.357742197241114E-2,4.1122687168598737E-2,0.22615039392728054,3.1618176113167185E-3]
[null,0.14000000000000001,0.43982297156000005,4.7586473779216265E-2,0.1023256039397908,0.41135777681927327,5.866201178233005E-5,1.357742197241114E-2,4.7586473779216265E-2,0.24875086775069463,4.3205559863668712E-3]
[null,0.15,0.47123889809999997,5.4496737919783322E-2,0.11175699610661147,0.41135777681927327,7.8351296016978273E-5,1.357742197241114E-2,5.4496737919783322E-2,0.27167833551305631,5.7707049376667704E-3]
[null,0.16,0.50265482464,6.1846659993877673E-2,0.12130279284425417,0.41135777681927327,1.0258057012338765E-4,1.357742197241114E-2,6.1846659993877673E-2,0.29488391779584022,7.5552317908236096E-3]
[null,0.17,0.53407075118000003,6.9628986515777203E-2,0.13094394513962024,0.41135777681927327,1.3195644308865905E-4,1.357742197241114E-2,6.9628986515777203E-2,0.31832130694626298,9.7188143195954327E-3]
[null,0.18,0.56548667771999994,7.7836037268774416E-2,0.14066230539907396,0.41135777681927327,1.6710327376951955E-4,1.357742197241114E-2,7.7836037268774416E-2,0.34194638663868704,1.2307437605538644E-2]
[null,0.19,0.59690260426000008,8.6459712884623285E-2,0.15044050711079476,0.41135777681927327,2.0865735523010269E-4,1.357742197241114E-2,8.6459712884623285E-2,0.3657169393369451,1.5367965704688808E-2]
[null,0.2,0.62831853080000011,9.5491502836637654E-2,0.16026187156442306,0.41135777681927327,2.5726081834860528E-4,1.357742197241114E-2,9.5491502836637654E-2,0.38959241953223805,1.8947692637921287E-2]
[null,0.21,0.65973445734000002,0.10492249383855379,0.17011033514271245,0.41135777681927327,3.1355531795324373E-4,1.357742197241114E-2,0.10492249383855379,0.41353377699104266,2.3093877364228459E-2]
[null,0.22,0.69115038388000005,0.1147433786408677,0.1799703924732019,0.41135777681927327,3.781755662479291E-4,1.357742197241114E-2,0.1147433786408677,0.43750331855831293,2.7853267506627474E-2]
[null,0.23,0.72256631042000008,0.12494446521596686,0.18982705195615537,0.41135777681927327,4.5174277929778948E-4,1.357742197241114E-2,0.12494446521596686,0.46146460004706402,3.3271616674779313E-2]
[null,0.24,0.75398223696,0.13551568632299094,0.19966580105229853,0.41135777681927327,5.3485810282555626E-4,1.357742197241114E-2,0.13551568632299094,0.48538234185376805,3.9393200263818103E-2]
[null,0.25,0.78539816350000002,0.14644660944298377,0.20947257933698946,0.41135777681927327,6.2809608349608068E-4,1.357742197241114E-2,0.14644660944298377,0.50922236345374738,4.6260334603457902E-2]
[null,0.26,0.81681409004000005,0.15772644707452932,0.21923375778223841,0.41135777681927327,7.319982512229889E-4,1.357742197241114E-2,0.15772644707452932,0.53295153303630627,5.391290428406692E-2]
[null,0.27,0.84823001658000008,0.16934406737971369,0.22893612306465802,0.41135777681927327,8.4706687681316921E-4,1.357742197241114E-2,0.16934406737971369,0.55653772935776846,6.2387902396668547E-2]
[null,0.28000000000000003,0.87964594312000011,0.18128800516990495,0.23856686594995971,0.41135777681927327,9.7375896747445507E-4,1.357742197241114E-2,0.18128800516990495,0.57994981350449137,7.1718988291967364E-2]
[null,0.28999999999999998,0.91106186965999991,0.19354647322051011,0.24811357299629275,0.41135777681927327,1.1124805603601002E-3,1.357742197241114E-2,0.19354647322051011,0.60315760872390034,8.193606729028699E-2]
[null,0.3,0.94247779619999994,0.20610737390354306,0.25756422096587167,0.41135777681927327,1.2635813714282813E-3,1.357742197241114E-2,0.20610737390354306,0.6261318868393011,9.306489656105818E-2]
[null,0.31,0.97389372273999997,0.21895831112652214,0.26690717344843123,0.41135777681927327,1.4273498534798665E-3,1.357742197241114E-2,0.21895831112652214,0.64884436004158674,0.10512672113897563]
[null,0.32,1.00530964928,0.23208660256591751,0.27613117928940006,0.41135777681927327,1.6040087133334308E-3,1.357742197241114E-2,0.23208660256591751,0.67126767706816948,0.1181379437563863]
[null,0.33,1.03672557582,0.24547929218307291,0.28522537248626723,0.41135777681927327,1.793710933738284E-3,1.357742197241114E-2,0.24547929218307291,0.69337542295104992,0.13210983185048264]
[null,0.34,1.0681415023600001,0.25912316301025173,0.29417927327285998,0.41135777681927327,1.996536340854697E-3,1.357742197241114E-2,0.25912316301025173,0.71514212165266844,0.1470482647524391]
[null,0.35,1.0995574288999999,0.27300475019418846,0.30298279015642804,0.41135777681927327,2.2124887529903496E-3,1.357742197241114E-2,0.27300475019418846,0.73654324101800339,0.16295352368704835]
[null,0.36,1.1309733554399999,0.28711035428427356,0.31162622270899215,0.41135777681927327,2.4414937408219171E-3,1.357742197241114E-2,0.28711035428427356,0.75755519956026651,0.17982012680926832]
[null,0.37,1.1623892819799999,0.30142605475225648,0.32010026494423,0.41135777681927327,2.6833970236026542E-3,1.357742197241114E-2,0.30142605475225648,0.77815537467002471,0.19763671108220882]
[null,0.38,1.1938052085200002,0.31593772373012718,0.32839600913564504,0.41135777681927327,2.9379635199154406E-3,1.357742197241114E-2,0.31593772373012718,0.79832211189706814,0.21638596236349453]
[null,0.39,1.2252211350600002,0.33063103995261578,0.33650494995200103,0.41135777681927327,3.2048770654327643E-3,1.357742197241114E-2,0.33063103995261578,0.81803473500354362,0.23604459461781224]
[null,0.4,1.2566370616000002,0.34549150289055236,0.34441898880284022,0.41135777681927327,3.4837408039489269E-3,1.357742197241114E-2,0.34549150289055236,0.83727355652779578,0.25658337871709147]
[null,0.41,1.28805298814,0.36050444706113877,0.35213043830099955,0.41135777681927327,3.7740782517143657E-3,1.357742197241114E-2,0.36050444706113877,0.85601988863262757,0.27796722083052028]
[null,0.42,1.31946891468,0.37565505650100972,0.35963202676092126,0.41135777681927327,4.0753350288871681E-3,1.357742197241114E-2,0.37565505650100972,0.87425605404057471,0.30015528994886587]
[null,0.43,1.3508848412200001,0.39092837938779923,0.36691690266162019,0.41135777681927327,4.3868812457815145E-3,1.357742197241114E-2,0.39092837938779923,0.89196539688326393,0.32310119363569223]
[null,0.44,1.3823007677600001,0.40630934279578473,0.37397863901176004,0.41135777681927327,4.7080145255955731E-3,1.357742197241114E-2,0.40630934279578473,0.90913229331279799,0.34675320065636162]
[null,0.45,1.4137166943000001,0.42178276757104483,0.38081123756164997,0.41135777681927327,5.0379636394987555E-3,1.357742197241114E-2,0.42178276757104483,0.92574216174100998,0.37105450870833406]
[null,0.46,1.4451326208400002,0.43733338331145155,0.38740913281332345,0.41135777681927327,5.3758927244053709E-3,1.357742197241114E-2,0.43733338331145155,0.94178147258786005,0.39594355506730233]
[null,0.47,1.47654854738,0.45294584343671357,0.39376719578536035,0.41135777681927327,5.7209060485105172E-3,1.357742197241114E-2,0.45294584343671357,0.95723775743361916,0.42135436757693795]
[null,0.48,1.50796447392,0.46860474033359867,0.39988073749390962,0.41135777681927327,6.0720532847638375E-3,1.357742197241114E-2,0.46860474033359867,0.97209961748114471,0.44721695304911663]
[null,0.49,1.53938040046,0.48429462056138695,0.40574551211555726,0.41135777681927327,6.4283352479528556E-3,1.357742197241114E-2,0.48429462056138695,0.98635673124472933,0.47345771980977053]
[null,0.5,1.570796327,0.50000000010255174,0.41135771980137587,0.41135777681927327,6.7887100470018519E-3,1.357742197241114E-2,0.50000000010255174,0.99999986139098218,0.49999993082606403]
[null,0.51,1.6022122535400001,0.51570537964361529,0.41671400911473078,0.41135777681927327,7.152099600501156E-3,1.357742197241114E-2,0.51570537964361529,1.0130208606650719,0.52676418358610189]
[null,0.52,1.6336281800800001,0.53139525987110003,0.42181147906829886,0.41135777681927327,7.517396460398334E-3,1.357742197241114E-2,0.53139525987110003,1.0254126768426657,0.55366891267528018]
[null,0.53,1.6650441066200001,0.54705415676747959,0.42664768073829701,0.41135777681927327,7.8834708862336369E-3,1.357742197241114E-2,0.54705415676747959,1.0371693566540769,0.58063091080564344]
[null,0.54,1.6964600331600002,0.56266661689203468,0.43122061843617715,0.41135777681927327,8.2491781103094537E-3,1.357742197241114E-2,0.56266661689203468,1.0482860486326249,0.60756586390785405]
[null,0.55000000000000004,1.7278759597000002,0.57821723263153357,0.43552875042004896,0.41135777681927327,8.6133657327637208E-3,1.357742197241114E-2,0.57821723263153357,1.0587590048440849,0.63438889579080526]
[null,0.56000000000000005,1.7592918862400002,0.59369065740568583,0.43957098912986875,0.41135777681927327,8.9748811846807573E-3,1.357742197241114E-2,0.59369065740568583,1.0685855814584264,0.66101511781230715]
[null,0.56999999999999995,1.7907078127799998,0.60907162081236454,0.44334670093200096,0.41135777681927327,9.3325791971248951E-3,1.357742197241114E-2,0.60907162081236454,1.0777642381288486,0.68736017898599444]
[null,0.57999999999999996,1.8221237393199998,0.62434494369764992,0.44685570536013769,0.41135777681927327,9.6853292143215062E-3,1.357742197241114E-2,0.62434494369764992,1.0862945361464751,0.71334081197459764]
[null,0.59,1.8535396658599999,0.63949555313582063,0.45009827384076612,0.41135777681927327,1.0032022690129918E-2,1.357742197241114E-2,0.63949555313582063,1.0941771353419998,0.73887537048746421]
[null,0.6,1.8849555923999999,0.65450849730451255,0.45307512789240956,0.41135777681927327,1.0371580208441141E-2,1.357742197241114E-2,0.65450849730451255,1.1014137897080878,0.76388435370984564]
[null,0.61,1.9163715189399999,0.66936896024036208,0.45578743678874428,0.41135777681927327,1.0702958370171631E-2,1.357742197241114E-2,0.66936896024036208,1.1080073417184739,0.78829091354158976]
[null,0.62,1.9477874454799999,0.68406227646057316,0.45823681467642058,0.41135777681927327,1.1025156392090269E-2,1.357742197241114E-2,0.68406227646057316,1.1139617153214616,0.81202134061186371]
[null,0.63,1.9792033720200002,0.69857394543597817,0.46042531713899626,0.41135777681927327,1.1337222365779985E-2,1.357742197241114E-2,0.69857394543597817,1.1192819075869336,0.83500552526222105]
[null,0.64,2.01061929856,0.71288964590130943,0.4623554371988135,0.41135777681927327,1.1638259128565146E-2,1.357742197241114E-2,0.71288964590130943,1.1239739789870209,0.85717738995029347]
[null,0.65,2.0420352251000002,0.72699524998856002,0.46403010074894946,0.41135777681927327,1.1927429702193734E-2,1.357742197241114E-2,0.72699524998856002,1.1280450422912931,0.87847528981789513]
[null,0.66,2.07345115164,0.74087683716948172,0.46545266140750113,0.41135777681927327,1.2203962259406505E-2,1.357742197241114E-2,0.74087683716948172,1.1315032500576596,0.89884237848720783]
[null,0.67,2.1048670781800003,0.75452070799346838,0.46662689478647768,0.41135777681927327,1.2467154583210001E-2,1.357742197241114E-2,0.75452070799346838,1.1343577807001968,0.91822693649374931]
[null,0.68,2.1362830047200001,0.76791339760725696,0.46755699216742425,0.41135777681927327,1.2716377988645869E-2,1.357742197241114E-2,0.76791339760725696,1.1366188231147545,0.93658266013129121]
[null,0.69,2.1676989312599999,0.78104168904311488,0.46824755357562403,0.41135777681927327,1.295108068206623E-2,1.357742197241114E-2,0.78104168904311488,1.1382975598425233,0.95386890886814779]
[null,0.7,2.1991148577999997,0.79389262626238888,0.4687035802443017,0.41135777681927327,1.3170790538328189E-2,1.357742197241114E-2,0.79389262626238888,1.1394061487507088,0.97005090989223042]
[null,0.71,2.23053078434,0.80645352694155337,0.46893046645968783,0.41135777681927327,1.3375117281856523E-2,1.357742197241114E-2,0.80645352694155337,1.1399577032080972,0.98509991874998848]
[null,0.72,2.2619467108799998,0.81871199498812985,0.46893399077711334,0.41135777681927327,1.3563754063134448E-2,1.357742197241114E-2,0.81871199498812985,1.1399662707316112,0.99899333545761004]
[null,0.73,2.29336263742,0.83065593277413674,0.46872030659747849,0.41135777681927327,1.3736478427812403E-2,1.357742197241114E-2,0.83065593277413674,1.1394468100779507,1.0117147758775165]
[null,0.74,2.3247785639599998,0.84227355307498453,0.46829593209249404,0.41135777681927327,1.3893152681215734E-2,1.357742197241114E-2,0.84227355307498453,1.1384151667521192,1.0232540985649667]
[null,0.75,2.3561944905000001,0.85355339070204628,0.46766773946604562,0.41135777681927327,1.4033723656529138E-2,1.357742197241114E-2,0.85355339070204628,1.1368880469020808,1.0336073876944525]
[null,0.76,2.3876104170400003,0.86448431381741209,0.46684294353787698,0.41135777681927327,1.4158221900282014E-2,1.357742197241114E-2,0.86448431381741209,1.134882989565992,1.0427768930693204]
[null,0.77,2.4190263435800001,0.87505553491967047,0.46582908963457498,0.41135777681927327,1.4266760293901927E-2,1.357742197241114E-2,0.87505553491967047,1.1324183372355039,1.0507709285968645]
[null,0.78,2.4504422701200004,0.88525662148987028,0.46463404077155873,0.41135777681927327,1.4359532134990829E-2,1.357742197241114E-2,0.88525662148987028,1.1295132046955125,1.0576037309710864]
[null,0.79,2.4818581966600002,0.89507750628715566,0.46326596410848797,0.41135777681927327,1.4436808706562212E-2,1.357742197241114E-2,0.89507750628715566,1.12618744609761,1.063295280642917]
[null,0.8,2.5132741232000004,0.90450849728391924,0.46173331665923756,0.41135777681927327,1.4498936366711186E-2,1.357742197241114E-2,0.90450849728391924,1.1224616202214073,1.0678710874695161]
[null,0.81,2.5446900497400002,0.91354028723066194,0.46004483023636783,0.41135777681927327,1.4546333195030662E-2,1.357742197241114E-2,0.91354028723066194,1.1183569538749352,1.0713619437171737]
[null,0.82,2.57610597628,0.92216396284112545,0.45820949560894297,0.41135777681927327,1.457948523549858E-2,1.357742197241114E-2,0.92216396284112545,1.1138953033827135,1.0738036473436268]
[null,0.83,2.6075219028199998,0.93037101358862884,0.45623654585163881,0.41135777681927327,1.4598942378507972E-2,1.357742197241114E-2,0.93037101358862884,1.1090991141078699,1.0752366987026349]
[null,0.84,2.6389378293600001,0.93815334010493157,0.45413543886243868,0.41135777681927327,1.4605313927165854E-2,1.357742197241114E-2,0.93815334010493157,1.1039913779531132,1.0757059739944266]
[null,0.85,2.6703537558999999,0.94550326217333169,0.45191583902591653,0.41135777681927327,1.4599263894923662E-2,1.357742197241114E-2,0.94550326217333169,1.0985955887846557,1.0752603789282582]
[null,0.86,2.7017696824400002,0.9524135263081126,0.44958759799924103,0.41135777681927327,1.4581506083002262E-2,1.357742197241114E-2,0.9524135263081126,1.0929356957234913,1.0739524861664744]
[null,0.87,2.73318560898,0.9588773129128576,0.44716073459873484,0.41135777681927327,1.4552798986926083E-2,1.357742197241114E-2,0.9588773129128576,1.0870360542501456,1.0718381601821667]
[null,0.88,2.7646015355200002,0.96488824301056897,0.44464541376616956,0.41135777681927327,1.451394058177467E-2,1.357742197241114E-2,0.96488824301056897,1.0809213750722912,1.0689761731841658]
[null,0.89,2.79601746206,0.97044038453894665,0.44205192459614434,0.41135777681927327,1.446576303549588E-2,1.357742197241114E-2,0.97044038453894665,1.0746166707098777,1.0654278157436528]
[null,0.9,2.8274333886000003,0.97552825820461919,0.43939065740898103,0.41135777681927327,1.4409127398805831E-2,1.357742197241114E-2,0.97552825820461919,1.0681471997599399,1.0612565056963457]
[null,0.91,2.8588493151400001,0.98014684289054355,0.4366720798577351,0.41135777681927327,1.4344918318838074E-2,1.357742197241114E-2,0.98014684289054355,1.0615384088133661,1.056527398793855]
[null,0.92,2.8902652416800003,0.98429158061124222,0.43390671206331777,0.41135777681927327,1.427403882181448E-2,1.357742197241114E-2,0.98429158061124222,1.0548158720090302,1.051307004438607]
[null,0.93,2.9216811682200001,0.98795838101098377,0.43110510077846664,0.41135777681927327,1.4197405207615166E-2,1.357742197241114E-2,0.98795838101098377,1.0480052282270798,1.0456628096603178]
[null,0.94,2.9530970947599999,0.99114362540047085,0.42827779258955589,0.41135777681927327,1.4115942096254342E-2,1.357742197241114E-2,0.99114362540047085,1.0411321159432372,1.0396629142805944]
[null,0.95,2.9845130212999997,0.99384417032804984,0.42543530617509634,0.41135777681927327,1.403057766295677E-2,1.357742197241114E-2,0.99384417032804984,1.0342221057899386,1.0333756799682905]
[null,0.96,3.01592894784,0.99605735068191692,0.42258810365134458,0.41135777681927327,1.3942239094817382E-2,1.357742197241114E-2,0.99605735068191692,1.0273006308982588,1.0268693956148329]
[null,0.97,3.0473448743799998,0.9977809823202628,0.41974656104877628,0.41135777681927327,1.3851848297960134E-2,1.357742197241114E-2,0.9977809823202628,1.0203929151269906,1.0202119611592406]
[null,0.98,3.07876080092,0.99901336422675668,0.41692093797830981,0.41135777681927327,1.376031787974406E-2,1.357742197241114E-2,0.99901336422675668,1.0135238993220266,1.0134705916708311]
[null,0.99,3.1101767274599998,0.99975328018924381,0.41412134656303834,0.41135777681927327,1.3668547425951092E-2,1.357742197241114E-2,0.99975328018924381,1.0067181657902124,1.0067115431578333]
[null,1,3.1415926540000001,1,0.41135771972975965,0.41135777681927327,1.3577420088094226E-2,1.357742197241114E-2,1,0.99999986121688511,0.999999861216885]

{"sheet":"Diseño Cribado","index":3,"n_rows":89,"n_cols":23,"rows_kept":89,"cut":false,"hidden":false,"merged":[[65,0,65,6],[66,0,79,6],[81,0,81,6],[59,0,63,0],[59,1,59,5],[61,1,61,5],[63,2,63,6],[10,7,10,12],[22,7,22,9],[27,7,27,9],[28,7,28,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[20,7,20,9],[21,7,21,9],[26,7,26,9],[42,0,42,1],[7,0,7,1],[1,0,5,0],[24,7,24,11],[8,7,8,14],[3,1,3,5],[1,1,1,5],[1,7,5,7],[1,8,1,14],[3,8,3,14],[5,9,5,14],[8,0,8,1],[10,0,10,4],[18,0,18,2],[39,0,39,1],[31,7,31,10],[52,0,52,1],[46,0,46,1],[36,0,36,1],[36,2,36,3],[46,2,46,3],[47,0,47,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[37,0,37,1],[38,0,38,1],[44,0,44,3],[40,0,40,1],[43,0,43,1],[41,0,41,1],[32,7,32,10],[34,7,34,10],[33,7,33,10],[29,7,29,10],[30,7,30,10],[5,2,5,6],[12,0,12,2],[34,0,34,2],[30,0,30,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[23,2,24,2],[21,0,21,1],[22,0,22,1],[23,0,24,1],[28,0,28,1],[32,0,32,4],[29,0,29,1],[26,0,26,2],[19,5,19,6]]}
[]
[null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO",null,null,null,null,null,null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO"]
[]
[null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE",null,null,null,null,null,null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE"]
[]
[null,"Trabajo de grado: ","Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar (cribado) de aguas residuales",null,null,null,null,null,"Trabajo de grado: ","Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar (cribado y Desarenador) de aguas residuales"]
[]
["Datos Ingresados por el Usuario "]
["Datos salida aplicativo ",null,null,null,null,null,null,"Resultados De Diseño del Sistema de Pretratamiento (Cribado Grueso y Fino)"]
[]
["1. Datos de entrada para el diseño de las unidades",null,null,null,null,null,null,"3. Dimensionamiento Sistema de Cribado Grueso y Fino "]
[]
["Caudales de diseño del ST ",null,null,null,null,null,null,"Area de Flujo Libre ",null,null,"A","m2",{"$f":"a(E15,F41)","v":0.08},{"$f":"a(E15,F51)","v":0.08}]
[null,null,null,null,null,null,null,"Longitud Libre entre barras (Total)",null,null,"ET","m",{"$f":"Et(M13,E31)","v":0.27},{"$f":"Etf(N13,M46)","v":0.2}]
["Caudal Máximo ",null,"Qmax","m3/s",0.1,null,null,"Separación entre barras",null,null,"Sp","m",{"$f":"F39","v":0.1},{"$f":"F49","v":0.01}]
["Caudal Medio  ",null,"Qmed","m3/s",{"$f":"E15/2","v":0.05},null,null,"Numero de separaciones ",null,null,"#Sp","Und",{"$f":"NSp(M14,M15)","v":3},{"$f":"NSp(N14,N15)","v":20}]
["Caudal Minimo",null,"Qmin","m3/s",{"$f":"E16/2","v":2.5000000000000001E-2},null,null,"longitud Libre entre barras (Total-Ajustado)",null,null,"ER","m",{"$f":"Er(M15,M16)","v":0.3},{"$f":"Er(N15,N16)","v":0.2}]
[null,null,null,null,null,null,null,"Numero total de barras",null,null,"#B","Und",{"$f":"M16-1","v":2},{"$f":"N16-1","v":19}]
["Caracteristicas del ducto de entrada PTAR",null,null,null,null,null,null,"Ancho de barras",null,null,"Ab","m",{"$f":"F40","v":8.9999999999999993E-3},{"$f":"F50","v":0.01}]
[null,null,null,null,null,"Cotas del Canal ",null,"Ancho de la rejilla",null,null,"Ac","m",{"$f":"Ac(M17,M18,M19)","v":0.318},{"$f":"M20","v":0.318}]
["Cota Batea tuberia de entrada",null,"Z0","m",0.12,"Z1",0,"Coeficiente de Eficiencia",null,null,"CE","%",{"$f":"Ce(M17,M20)","v":94.34},{"$f":"Ce(N17,N20)","v":62.89}]
["Pendiente ducto entrada PTAR",null,"S","m/m",2E-3,"Z2",0,"Longitud de la rejilla ",null,null,"L","m",{"$f":"l(M28,F38)","v":0.97},{"$f":"l(M28,F48)","v":0.97}]
["Rugosidad ",null,"n",null,1.4999999999999999E-2,"Z3",0,"longitud que ocupa la rejilla en el canal",null,null,"Lc","m",{"$f":"lc(M22,M28)","v":0.25933},{"$f":"lc(N22,M28)","v":0.25933}]
["Diametro de la tuberia de entrada",null,"D","in",20]
[null,null,null,"m",{"$f":"d(E24)","v":0.51},null,null,"3.1 Dimensionamiento Canal del Sistema de Cribado"]
[]
["Condiciones hidraulicas Iniciales (Entrada ST)",null,null,null,null,null,null,"Ancho del Canal",null,null,"AC","m",{"$f":"N20","v":0.318}]
[null,null,null,null,null,null,null,"Profundida total del canal (incluye borde libre)",null,null,"Pc","m",{"$f":"M50+0.4","v":0.93469271471419035}]
["Radio Hidraulico ",null,"RH","m",{"$f":"RH(E25)","v":0.1275},null,null,"Longitud Total del Canal ",null,null,"Lc","m",{"$f":"M30+M31+M32+M33+M34+M35","v":2.2186599999999999}]
["Velocidad del Fluido en el conducto de entrada al ST",null,"V0","m/s",{"$f":"'relaciones hidraulicas '!K3","v":0.79963963519462855},null,null,"Longitud de aquietamiento ",null,null,null,"m",0.3]
["Altura Lamina de Agua en el coducto de entrada al ST",null,"H0","m",{"$f":"'relaciones hidraulicas '!K4","v":0.29489078864208212},null,null,"longitud de la placa de mantenimiento rejilla gruesa",null,null,null,"m",0.4]
[null,null,null,null,null,null,null,"Longitud de la rejilla gruesa en el canal ",null,null,null,"m",{"$f":"M23","v":0.25933}]
["2. Selección de Criterios de Diseño para el Diseño de los ST",null,null,null,null,null,null,"Separacion entre la rejilla gruesa y placa de mantenimiento rejilla Fina",null,null,null,"m",0.7]
[null,null,null,null,null,null,null,"Longitud de la rejilla Final en el canal (incluye longitud de la placa de mantenimiento) ",null,null,null,"m",{"$f":"N23","v":0.25933}]
["Criterios de Diseño de la rejilla gruesa",null,null,null,null,null,null,"Longitud Rejilla fina hasta la seccion del desarenador",null,null,null,"m",0.3]
[]
["Tipo de rejilla ",null,null,null,"Valor Recomendado","Confirmado por el diseñador ","Validación de datos ","5. Calculo Condiciones Hidraulicas en el Canal de Cribado"]
["Angulo de inclinación (con la horizontal)",null,"β","º",75,75,"OK"]
["Separación entre Barras",null,"Sb","m",7.0000000000000007E-2,0.1,"OK","5.1  Condiciones Hidraulicas Aguas Arriba de la Rejilla Gruesa",null,null,null,null,null,null,null,"Polinomio d2"]
["Ancho de Barras",null,"Ab","m",8.9999999999999993E-3,8.9999999999999993E-3,"OK","Altura de la lamina de agua, aguas arriba de la rejilla gruesa",null,null,"d2","m",0.4202437176365435,null,null,1,"d32",{"$f":"T42-S42+W42","v":-0.44022288155696943},"d22",{"$f":"V42-U42","v":3.5281317703588621E-3},null,{"$f":"(P40*M40^3)+(R40*M40^2)+T40","v":-2.84122605444595E-7}]
["Velocidad flujo maximo ",null,"Vmax","m/s",1.2,1.2,"OK","Velocidad aguas arriba de la rejilla gruesa ",null,null,"V2","m/s",{"$f":"Vddos(E15,M40,M20)","v":0.748},null,null,"A",null,"B",null,"C",null,"EQ"]
["Velocidad flujo medio ",null,"Vmed","m/s",0.89999999999999991,0.6,"OK","Velocidad a traves de las aberturas de la rejilla gruesa ",null,null,"VR","m/s",{"$f":"vr(E15,M40,M14)","v":0.88100000000000001},null,null,"2*g",{"$f":"2*9.81","v":19.62},null,{"$f":"ROUND((E21+E31+((E30^2)/Q42)),2)","v":0.45},{"$f":"Q43*((E30^2)/Q42)","v":9.777118443030558E-3},{"$f":"Q43*((E15/M20)^2)/Q42","v":1.5120564730109409E-3},{"$f":"((E15/M20)^2)/Q42","v":5.0401882433698027E-3},{"$f":"G21","v":0}]
["Velocidad flujo mínimo",null,"Vmin","m/s",0.6,0.6,"OK","Perdidad de carga  a traves de la rejilla gruesa",null,null,"hL","m",{"$f":"hL(M42,M41)","v":1.0999999999999999E-2},null,null,"Ke",0.3,null,1,"2hL1","2hL2","1/d2","Z2"]
[]
["Criterios de Diseño de la rejilla Fina",null,null,null,null,null,null,"5.2  Condiciones Hidraulicas Aguas Abajo de la Rejilla Gruesa",null,null,null,null,null,null,null,"Polinomio d3"]
[null,null,null,null,null,null,null,"Altura de la lamina de agua, aguas abajo de la rejilla gruesa",null,null,"d3","m",0.40739155114059306,null,null,1,"d33",{"$f":"M43-S48+U48","v":-0.4377607410820073},"d23",{"$f":"T48","v":5.0401882433698027E-3},null,{"$f":"(P46*M46^3)+(R46*M46^2)+T46","v":-1.2170524755529544E-7}]
["Tipo de rejilla ",null,null,null,"Valor Recomendado","Confirmado por el diseñador ","Validación de datos ","Velocidad aguas abajo de la rejilla gruesa ",null,null,"V3","m/s",{"$f":"Vdtres(E15,M46,M20)","v":0.77200000000000002},null,null,"A",null,"B",null,"C",null,"EQ"]
["Angulo de inclinación",null,"β","º",80,75,"OK",null,null,null,null,null,null,null,null,"2*g",{"$f":"2*9.81","v":19.62},null,{"$f":"E26+M40+((M41^2)/Q48)","v":0.44876074108200731},{"$f":"((E15/M20)^2)/Q48","v":5.0401882433698027E-3},{"$f":"G22","v":0}]
["Separación entre Barras",null,"Sb","m",1.4999999999999999E-2,0.01,"OK","5.3  Condiciones Hidraulicas Aguas Arriba de la Rejilla Gruesa al 50% de obstruccion ",null,null,null,null,null,null,null,"Ke",0.3,null,1,2,"Z3"]
["Ancho de Barras",null,"Ab","m",8.9999999999999993E-3,0.01,"OK","Altura de la lamina de agua, aguas arriba de la rejilla gruesa (50%) ",null,null,"d2`","m",0.53469271471419033,null,null,"Polinomio d250%"]
["Velocidad flujo maximo ",null,"Vmax","m/s",1.2,1.2,"OK","Velocidad aguas arriba de la rejilla gruesa (50%) ",null,null,"V2`","m/s",{"$f":"Vddos(E25,M50,M30)","v":3.1789999999999998},null,null,1,"d32",{"$f":"-1*U53-W42","v":-0.43776790180318226},"d22",{"$f":"T53-S53","v":-2.7710811756630198E-2},null,{"$f":"(P51*M50^3)+(R51*M50^2)+(T51)","v":-3.6644778047406623E-7}]
["Velocidad flujo medio ",null,"Vmed","m/s",0.89999999999999991,1,"OK","Velocidad a traves de las aberturas de la rejilla gruesa (50%) ",null,null,"VR`","m/s",{"$f":"vr(E15,M50,M14)","v":0.69299999999999995},null,null,"A",null,"B",null,"C",null,"EQ"]
["Velocidad flujo mínimo",null,"Vmin","m/s",0.6,0.9,"OK","Perdidad de carga  a traves de la rejilla gruesa (50%) ",null,null,"hL50%","m",{"$f":"hLOBS(M52,M51)","v":-0.70099999999999996},null,null,"2*g",{"$f":"2*9.81","v":19.62},null,{"$f":"ROUND((((((E15/(M14*0.5))^2)-(E15/M20)^2))/(Q53*0.7)),6)","v":3.2751000000000002E-2},{"$f":"((E15/M20)^2)/Q53","v":5.0401882433698027E-3},{"$f":"U48+M46+((M47^2)/Q53)","v":0.43776790180318226},{"$f":"G21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ke",null,null,"Hl50","1/d2","P2","Z2"]
[null,null,null,null,null,null,null,"5.4  Condiciones Hidraulicas Aguas Arriba de la Rejilla Gruesa",null,null,null,null,null,null,null,"Polinomio d4"]
[null,null,null,null,null,null,null,"Altura de la lamina de agua, aguas abajo de la rejilla Fina ",null,null,"d4","m",0.40741404491762601,null,null,1,"d34",{"$f":"-1*S58-V58-W58","v":-0.46814425246577146},"d24",{"$f":"U58+T58","v":1.0080376486739605E-2},null,{"$f":"(P56*M56^3)+(R56*M56^2)+(T56)","v":-1.3207488228084152E-10}]
[null,null,null,null,null,null,null,"Velocidad aguas abajo de la rejilla Fina",null,null,"V4","m/s",{"$f":"Vddos(E15,M56,M20)","v":0.77200000000000002},null,null,"A",null,"B",null,"C",null,"EQ"]
[null,null,null,null,null,null,null,"Perdidad de carga  a traves de la rejilla Fina",null,null,"hL","m",{"$f":"hL(M57,M56)","v":2.1999999999999999E-2},null,null,"2*g",{"$f":"2*9.81","v":19.62},null,{"$f":"V58+M46+((M47^2)/Q58)","v":0.43776790180318226},{"$f":"((E15/N20)^2)/Q58","v":5.0401882433698027E-3},{"$f":"((E15/N20)^2)/Q58","v":5.0401882433698027E-3},{"$f":"G23","v":0},{"$f":"(M47^2)/Q58","v":3.0376350662589195E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ke",null,null,1,"Hl","1/d4","z4","hL1"]
[null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO"]
[]
[null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE"]
[]
[null,"Trabajo de grado: ","Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar (cribado) de aguas residuales"]
[]
["Esquema del Sistema de Pretratamiento (Cribado Grueso y Fino y Desarenador)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Perfil Hidraulico Sistema de Pretratamiento (Cribado Grueso y Fino )"]
[]
[]
[]
[]
[]
[]
[{"$f":"E31","v":0.29489078864208212},{"$f":"M40","v":0.4202437176365435},{"$f":"M46","v":0.40739155114059306},{"$f":"M56","v":0.40741404491762601}]

{"sheet":"Diseño Desarenador ","index":4,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[49,0,49,1],[50,0,50,1],[51,0,51,1],[59,0,59,1],[66,0,66,1],[58,0,58,1],[46,0,46,2],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,25,1],[33,0,33,1],[36,1,36,2],[35,0,35,2],[38,0,38,1],[39,0,39,1],[37,0,37,1],[41,0,41,2],[43,0,43,1],[44,0,44,1],[0,0,4,0],[0,1,0,5],[2,1,2,5],[4,2,4,6],[6,2,6,4],[7,2,7,4],[12,0,12,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[53,0,53,1],[8,0,8,4],[10,0,10,2],[13,0,13,1],[14,0,14,1],[15,0,15,1],[17,0,17,2],[26,0,26,1],[31,0,31,1],[32,0,32,1],[48,0,48,1],[73,3,73,4],[75,0,75,1],[71,0,71,1],[63,0,64,1],[68,0,69,1]]}
[null,"ESCUELA  COLOMBIANA DE INGENIERIA JULIO GARAVITO"]
[]
[null,"ESPECIALIZACIÓN EN RECURSOS HIDRÁULICOS Y MEDIO AMBIENTE"]
[]
[null,"Trabajo de grado: ","Guía y herramienta computacional para el diseño hidráulico de un sistema de tratamiento preliminar ( Desarenador) de aguas residuales"]
[]
[null,null,"Datos Ingresados por el Usuario "]
[null,null,"Datos salida aplicativo "]
["1. Datos de entrada para el diseño de las unidades"]
[]
["Caudales de diseño del ST "]
[]
["Caudal de emergencia",null,"Qemer","m3/s",{"$f":"E14+E14*0.3","v":6.5000000000000002E-2}]
["Caudal Máximo ",null,"Qmax","m3/s",0.05]
["Caudal Medio  ",null,"Qmed","m3/s",{"$f":"E14/2","v":2.5000000000000001E-2}]
["Caudal Minimo",null,"Qmin","m3/s",{"$f":"E15/2","v":1.2500000000000001E-2}]
[]
["Varibales y constantes para el diseño del desarenador "]
[]
["Numeros de desarenadores ",null,"#","Unidad",2]
["Numero de desarenadores para Caudal de emargencia ",null,"#","Unidad",{"$f":"E20-1","v":1}]
["Tiempo de Retencion ",null,"Tr","Seg",60]
["Velocidad Horizontal ",null,"Vh","m/s",0.3]
["Velocidad de Sedimentacion",null,"Vs","m/min",1.1499999999999999]
[null,null,"Vs","m/s",{"$f":"ROUND((E24/60),3)","v":1.9E-2}]
[null,null,"Vs","m3/m2-dia",1730]
["Gravedad",null,"2*g","m/s2",{"$f":"2*9.81","v":19.62}]
[]
["Caracteristicas hidraulicas de entrada al Desarenador para una sección de control de vertedero rectangular "]
[]
["Se mantiene la lamina de agua de la salidad del sistema de cribado?"]
["Altura de la seccion ",null,"H","m",0.47099999999999997]
["Ancho del canal ",null,"T ","m",0.34]
["Profundidad del canal",null,"Pc","m"]
[]
["Canales rectangulares la Profundidad critica "]
[]
["Cabeza de velocidad",null,"Vc2/2g",null,{"$f":"ROUND((1/3.1)*(E32+((E23^2)/E27)),3)","v":0.153}]
["Profundidad Critica ",null,"dcQMH ","m",{"$f":"dcqmh(E38)","v":0.31}]
["Velicidad Critica",null,"VcQMH ","m/s",{"$f":"vcqmh(E38,E27)","v":1.7330000000000001}]
[]
["Dimensiones de la seccion de control"]
[]
["Area de la seccion de control",null,"Aqmh","m2",{"$f":"aqmh(E14,E40)","v":2.8899999999999999E-2}]
["Ancho de la seccion de control",null,"w","m ",{"$f":"w(E44,E39)","v":9.2999999999999999E-2}]
[]
["Diseño del canal para los caudales de Diseño"]
[null,null,null,null,"Qmed","Q min","Qmer"]
["Area en la seccion de control",null,"a","m2",{"$f":"aqmd(E15,E45)","v":0.02},{"$f":"aqmin(E16,E45)","v":1.0999999999999999E-2},{"$f":"aqmin(E13,E45)","v":3.4000000000000002E-2}]
["Calculando la profundidad critica en la seccion de control",null,"dcQMD","m",{"$f":"dcQMD(E49,E45)","v":0.22},{"$f":"dcqmin(F49,$E$45)","v":0.11799999999999999},{"$f":"dcqmin(G49,$E$45)","v":0.36599999999999999}]
["Calculando la altura de la seccion de control",null,"H","m",{"$f":"HQMD(E50,E23,E27)","v":0.34},{"$f":"hqmin(F50,$E$23,$E$27)","v":0.17799999999999999},{"$f":"hqmin(G50,$E$23,$E$27)","v":0.56299999999999994}]
["Ancho de la lamina de agua en el desarenador",null,"T","m",{"$f":"Tqmd(E15,E23,E51)","v":0.37},{"$f":"tqmin(E16,F51,$E$23)","v":0.35},{"$f":"tqmin(E13,G51,$E$23)","v":0.57999999999999996}]
[]
["Longitud del Desarenador "]
[]
["Longitud del Desarenador ",null,"L","m",{"$f":"ld(E57,E60)","v":10.704000000000001}]
["longitud teorica",null,"Lt","m",{"$f":"Lt(E32,E23,E25)","v":7}]
["longitud minima adicional ",null,"Lmin","m",{"$f":"lmin(G51)","v":1.1299999999999999}]
["longitud maxima adicional ",null,"Lmax","m",{"$f":"lmax(E57)","v":3.5}]
["Se dopta una longitud adicional ",null,"Ladop","m",{"$f":"Ladop(E58,E59)","v":3.7040000000000002}]
[]
["Tiempo de retención hidraulico en el desarenador para caudal máximo"]
[]
["Tiempo de retencion hidraulico ",null,"seg","TH",{"$f":"THseg(E56,E23)","v":35.680000000000007}]
[null,null,"min","TH",{"$f":"THmin(E64)","v":0.59466666666666679}]
[]
["Tiempo de sedimentacion para caudal maximo"]
[]
["Tiempo de sedimentación ",null,"min","Ts",{"$f":"TSmin(E32,E24)","v":0.41}]
[null,null,"seg","Ts",{"$f":"TSseg(E69)","v":24.6}]
[]
["Volumen de arena retenida"]
[]
["Volumen Tratado ",1000000,"m3","Volumen  de arena retenido ",null,30,"m3"]
[]
["Cantidad de arena retenida al transitar el caudal maximo ",null,"m3","Varena",{"$f":"Varena(E14,F74,B74)","v":0.13}]