{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CapacidadRectangular","Principal","CurvaRemansoIzq","CurvaRemansoDer","CRemRectRedIzq","CRemRectRedDer"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":33,"comments":6,"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":"CapacidadRectangular","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
[null,"Capacidad en canales"]
[]
["Tema:","Canales",null,null,null,null,null,"Alumno:"]
[]
["Dibujar la curva de capacidad de cualquier canal rectangular independientemente de su anchura"]
[]
["Solución"]
[]
["Dibujo de la curva de capacidad del canal"]
["Incb",0.05]
["b = y/b","k(y) / b8/3",null,"Caudal de régimen uniforme",null,null,"Q",{"$f":"Principal!G21","v":12},"m3/s"]
[{"$f":"B10","v":0.05},{"$f":"A12 * (A12/ (1+2*A12) )^(2/3)","v":6.3682712060349729E-3},null,"Ancho del canal",null,null,"b",{"$f":"Principal!F17","v":6},"m"]
[{"$f":"A12+$B$10","v":0.1},{"$f":"A13 * (A13/ (1+2*A13) )^(2/3)","v":1.9078570709222198E-2},null,"Pendiente del canal",null,null,"Io",2.4600000000000002E-4," -",null,"Interpolación lineal"]
[0.15000000000000002,3.5551385467782928E-2,null,"Número de Manning",null,null,"n",1.0999999999999999E-2,null,null,"Posición","Ordenada","Abscisa"]
[0.2,5.4655176650639709E-2,null,"Abscisa del gráfico",null,null,"k(y) / b8/3",{"$f":"H11*H14/SQRT(H13) / H12^(8/3)","v":7.0800508461076814E-2}," -",null,{"$f":"MATCH(H$15,$B$12:$B$41,1)","v":4},{"$f":"INDEX(A$12:A$41,$K15)","v":0.2},{"$f":"INDEX(B$12:B$41,$K15)","v":5.4655176650639709E-2}]
[0.25,7.5713358034672495E-2,null,"Ordenada del gráfico",null,null,"y/b",{"$f":"(H15-M15) / (M16-M15) * (L16-L15) + L15","v":0.2383350573252237}," -",null,{"$f":"K15+1","v":5},{"$f":"INDEX(A$12:A$41,$K16)","v":0.25},{"$f":"INDEX(B$12:B$41,$K16)","v":7.5713358034672495E-2}]
[0.3,9.8277802282833629E-2,null,"Calado correspondiente",null,null,"y",{"$f":"H16*H12","v":1.4300103439513423},"m"]
[0.35,0.12203398490986396,null,null,null,null,null,null,null,null,null,"Líneas del gráfico"]
[0.39999999999999997,0.14675232217309453,null,null,null,null,null,null,null,null,null,"x","y"]
[0.44999999999999996,0.17226026949694306,null,null,null,null,null,null,null,null,null,0,{"$f":"H16","v":0.2383350573252237}]
[0.49999999999999994,0.19842513149602489,null,null,null,null,null,null,null,null,null,{"$f":"H15","v":7.0800508461076814E-2},{"$f":"H16","v":0.2383350573252237}]
[0.54999999999999993,0.22514291565164116,null,null,null,null,null,null,null,null,null,{"$f":"H15","v":7.0800508461076814E-2},0]
[0.6,0.25233081868269497]
[0.65,0.27992200296872038]
[0.70000000000000007,0.3078618717944045]
[0.75000000000000011,0.33610535599178742]
[0.80000000000000016,0.36461490072706104]
[0.8500000000000002,0.3933589476487982]
[0.90000000000000024,0.42231077420347518]
[0.95000000000000029,0.45144759479567681]
[1.0000000000000002,0.48074985676913629]
[1.0500000000000003,0.51020068327530388]
[1.1000000000000003,0.53978542822460385]
[1.1500000000000004,0.56949131769994998]
[1.2000000000000004,0.59930715873709772]
[1.2500000000000004,0.62922310107722279]
[1.3000000000000005,0.65923044092708782]
[1.3500000000000005,0.68932145829421865]
[1.4000000000000006,0.7194892813539]
[1.4500000000000006,0.7497277727287226]
[1.5000000000000007,0.78003143364446437]

{"sheet":"Principal","index":1,"n_rows":93,"n_cols":27,"rows_kept":93,"cut":false,"hidden":false,"merged":[[7,0,7,8],[0,1,0,8],[0,11,0,18],[3,18,3,19],[3,8,3,9],[5,7,5,9]]}
[null,"Intersección de 2 pendientes indefinidas en canal rectangular",null,null,null,null,null,null,null,null,null,"Intersección de 2 pendientes indefinidas en canal rectangular",null,null,null,null,null,null,null,null,"Para utilizar este libro correctamente es necesario tener habilitadas las macros de Visual Basic"]
[]
["Tema:","Canales",null,null,null,null,null,null,null,null,"Tema:","Canales",null,null,null,null,null,null,null,null,"Excel 2010:"]
["Autor:","Jaime García Palacios",null,null,null,null,null,"Alumno:",null,null,"Autor:","Jaime García Palacios",null,null,null,null,null,"Alumno:",{"$f":"IF(I4=0,\"\",I4)","v":""},null,null,"Archivo",null,"Opciones",null,"Centro de Confianza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Botón de configuración del centro de confianza"]
["Enunciado",null,null,null,null,null,null,"(Asegurarse de habilitar las macros)",null,null,"Mínima distancia a representar de cada tramo",null,null,null,null,"Lmin",60,"m",null,null,null,"Deshabilitar todas las macros con notificación",null,null,null,null,"(Habilitarlas al abrir este libro)"]
[]
[{"$f":"\"Por un canal rectangular indefinido en ambos sentidos, de \" & F17 & \" m de ancho con pendientes \" & F18 & \" y \" & G18  & \" respectivamente, circulan \" & G21 & \" m3/s. Suponiendo un número de Manning de \" & F19 & \". Calcular:\"","v":"Por un canal rectangular indefinido en ambos sentidos, de 6 m de ancho con pendientes 0.001 y 0.002 respectivamente, circulan 12 m3/s. Suponiendo un número de Manning de 0.011. Calcular:"}]
["1.- Calado crítico, calado uniforme, velocidades de circulación y número de froude.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para utilizar este libro correctamente es necesario tener habilitadas las macros de Visual Basic"]
["2.- Clasificar las pendientes."]
["3.- Determinar el calado conjugado del uniforme en ambas pendientes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel 2013:"]
["4.- Dibujar la forma de la curva de remanso indicando el tipo de curva que se forma.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Archivo",null,"Opciones",null,"Centro de Confianza"]
["5.- Integrar la curva de remanso.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Botón de configuración del centro de confianza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Configuración de macros"]
["Datos del problema",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deshabilitar todas las macros con notificación",null,null,null,null,"(Habilitarlas al abrir este libro)"]
[null,null,null,null,null,"Tramo 1","Tramo 2"]
["Ancho del canal ",null,null,null,"b",6,{"$f":"F17","v":6},"m"]
["Pendiente del canal",null,null,null,"Io",1E-3,2E-3,"-"]
["Nº de Manning",null,null,null,"n",1.0999999999999999E-2,{"$f":"F19","v":1.0999999999999999E-2}]
[null,null,null,null,null,null,5]
["Caudal circulante por el canal",null,null,null,null,"Q",12,"m3/s"]
["Densidad del agua",null,null,null,null,"ro",1000,"kg/m3"]
["Gravedad de la tierra",null,null,null,null,"g",9.81,"m/s2"]
[]
["Resultados"]
[]
["Peso específico del agua",null,null,null,null,"gama",{"$f":"G22*G23","v":9810},"N/m3"]
[]
[null,null,null,null,null,"Tramo 1","Tramo 2"]
["Calado unitario en el canal",null,null,null,"q",{"$f":"$G$21/F17","v":2},{"$f":"$G$21/G17","v":2},"m2/s"]
["Calado crítico en el canal",null,null,null,"yc",{"$f":"(F30^2/$G$23)^(1/3)","v":0.74153273541536779},{"$f":"(G30^2/$G$23)^(1/3)","v":0.74153273541536779},"m"]
["Calado uniforme en el canal",null,null,null,"yu",{"$f":"miyuniforme($G$21,F17,F19,F18)","v":0.89269987749321777},{"$f":"miyuniforme($G$21,G17,G19,G18)","v":0.71139530299656961},"m"]
["Velocidad para calado uniforme",null,null,null,"v",{"$f":"$G$21/F17/F32","v":2.2403946168517255},{"$f":"$G$21/G17/G32","v":2.8113764479123136},"m/s"]
["Número de froude al cuadrado ",null,null,null,"F2",{"$f":"F33^2/$G$23/F32","v":0.57315826376462964},{"$f":"G33^2/$G$23/G32","v":1.1325516149460619},"-",null,null,null,null,null,null,null,"Calados límite"]
["Número de Froude",null,null,null,"F",{"$f":"SQRT(F34)","v":0.75707216549324385},{"$f":"SQRT(G34)","v":1.0642140832304663},"-",null,null,"Caso","Pedientes",null,"Tipo curva remanso",null,"Tramo 1",null,"Tramo 2"]
["Tipo de pendiente en el canal",null,null,null,"Pend",{"$f":"IF(F35<1,\"Suave\", \"Fuerte\")","v":"Suave"},{"$f":"IF(G35<1,\"Suave\", \"Fuerte\")","v":"Fuerte"},null,null,null,"actual","Tramo 1","Tramo 2","Tramo 1","Tramo 2","yini","yfin","yini","yfin"]
["Calado conjugado del uniforme",null,null,null,"yuc",{"$f":"F32/2*(SQRT(1+8*F34)-1)","v":0.60851635250899305},{"$f":"G32/2*(SQRT(1+8*G34)-1)","v":0.77250963658885552},"m",null,null,{"$f":"IF(AND(L37=$F$36, M37=$G$36),1,0)","v":0},"Suave","Suave","S2 ó S1","-",{"$f":"G32","v":0.71139530299656961},{"$f":"F32","v":0.89269987749321777},{"$f":"G32","v":0.71139530299656961},{"$f":"G32","v":0.71139530299656961}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L38=$F$36, M38=$G$36),1,0)","v":1},"Suave","Fuerte","S2","F2",{"$f":"F31","v":0.74153273541536779},{"$f":"F32","v":0.89269987749321777},{"$f":"G31","v":0.74153273541536779},{"$f":"G32","v":0.71139530299656961}]
["Datos para las curvas de remanso",null,null,null,null,"Izquierda","Derecha",null,null,null,0,"Fuerte","Suave","F1 ó -","- ó S3",{"$f":"G32","v":0.71139530299656961},{"$f":"MIN(G32,F37)","v":0.60851635250899305},{"$f":"F32","v":0.89269987749321777},{"$f":"MAX(F32, G37)","v":0.89269987749321777}]
["Ancho del canal rectángular",null,null,null,"b",{"$f":"F17","v":6},{"$f":"G17","v":6},"m",null,null,0,"Fuerte","Fuerte","-","F2 ó F3",{"$f":"F32","v":0.89269987749321777},{"$f":"F32","v":0.89269987749321777},{"$f":"F32","v":0.89269987749321777},{"$f":"G32","v":0.71139530299656961}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"$G$21","v":12},{"$f":"$G$21","v":12},"m3/s",null,null,"Cuando no hay curva en uno de los lados se pone yini e yfin iguales al uniforme en la sección"]
["Número de Manning",null,null,null,"n",{"$f":"F19","v":1.0999999999999999E-2},{"$f":"G19","v":1.0999999999999999E-2}]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"F18","v":1E-3},{"$f":"G18","v":2E-3},"-",null,null,"Factor de multiplicación"]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"INDEX($P$37:$P$40,MATCH(1,$K$37:$K$40,0))","v":0.74153273541536779},{"$f":"INDEX($R$37:$R$40,MATCH(1,$K$37:$K$40,0))","v":0.74153273541536779},"m",null,null,"tramo recto a la derecha"]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"INDEX($Q$37:$Q$40,MATCH(1,$K$37:$K$40,0))","v":0.89269987749321777},{"$f":"INDEX($S$37:$S$40,MATCH(1,$K$37:$K$40,0))","v":0.71139530299656961},"m",null,null,"DL",1.1000000000000001]
["Tipo de curva de remanso",null,null,null,null,{"$f":"IF(F44=F45,\"No hay\", CurvaRemansoIzq!M8)","v":"S2"},{"$f":"IF(G44=G45,\"No hay\",CurvaRemansoDer!M8)","v":"F2"}]
[]
["Datos para el gráfico"]
[]
["Curvas de remanso",null,null,null,null,null,"Régimen uniforme"]
["Tramo 1",null,null,"Tramo 2",null,null,"Tramo 1",null,"Tramo 2"]
["x","y1","yc1","x","y2","yc2","x","yu1=","x","yu2="]
[{"$f":"CurvaRemansoIzq!O12","v":0},{"$f":"CurvaRemansoIzq!A12","v":0.74153273541536779},{"$f":"CurvaRemansoIzq!M12","v":0.74153273541536791},{"$f":"CurvaRemansoDer!O12","v":0},{"$f":"CurvaRemansoDer!A12","v":0.74153273541536779},{"$f":"CurvaRemansoDer!M12","v":0.74153273541536791},{"$f":"MIN(-$Q$6,$A$93)","v":-582.25734997531936},{"$f":"F32","v":0.89269987749321777},{"$f":"MAX(0,$D$93)","v":71.325005126857917},{"$f":"G32","v":0.71139530299656961}]
[{"$f":"CurvaRemansoIzq!O13","v":-3.8418070268050122E-2},{"$f":"CurvaRemansoIzq!A13","v":0.745311913967314},{"$f":"CurvaRemansoIzq!M13","v":0.73776635366423848},{"$f":"CurvaRemansoDer!O13","v":4.8578885246506843E-3},{"$f":"CurvaRemansoDer!A13","v":0.74077929960489786},{"$f":"CurvaRemansoDer!M13","v":0.74228668192513014},{"$f":"MIN(0,$A$93)","v":-582.25734997531936},{"$f":"F32","v":0.89269987749321777},{"$f":"$L$45*MAX($Q$6,$D$93)","v":78.457505639543712},{"$f":"G32","v":0.71139530299656961}]
[{"$f":"CurvaRemansoIzq!O14","v":-0.15691906844566134},{"$f":"CurvaRemansoIzq!A14","v":0.7490910925192602},{"$f":"CurvaRemansoIzq!M14","v":0.73402539320823368},{"$f":"CurvaRemansoDer!O14","v":1.980611773092229E-2},{"$f":"CurvaRemansoDer!A14","v":0.74002586379442792},{"$f":"CurvaRemansoDer!M14","v":0.74304165121978516}]
[{"$f":"CurvaRemansoIzq!O15","v":-0.35993562406437002},{"$f":"CurvaRemansoIzq!A15","v":0.75287027107120641},{"$f":"CurvaRemansoIzq!M15","v":0.73030959882934032},{"$f":"CurvaRemansoDer!O15","v":4.5382016519515275E-2},{"$f":"CurvaRemansoDer!A15","v":0.73927242798395798},{"$f":"CurvaRemansoDer!M15","v":0.74379764538409465},"Régimen uniforme continuación"]
[{"$f":"CurvaRemansoIzq!O16","v":-0.65226288322538739},{"$f":"CurvaRemansoIzq!A16","v":0.75664944962315261},{"$f":"CurvaRemansoIzq!M16","v":0.72661871955115565},{"$f":"CurvaRemansoDer!O16","v":8.2167073185301351E-2},{"$f":"CurvaRemansoDer!A16","v":0.73851899217348804},{"$f":"CurvaRemansoDer!M16","v":0.74455466650991087},"Tramo 1",null,"Tramo 2"]
[{"$f":"CurvaRemansoIzq!O17","v":-1.039099376784745},{"$f":"CurvaRemansoIzq!A17","v":0.76042862817509882},{"$f":"CurvaRemansoIzq!M17","v":0.72295250854031923},{"$f":"CurvaRemansoDer!O17","v":0.13079191117145267},{"$f":"CurvaRemansoDer!A17","v":0.7377655563630181},{"$f":"CurvaRemansoDer!M17","v":0.74531271669621302},"x","yu1=","x","yu2="]
[{"$f":"CurvaRemansoIzq!O18","v":-1.5260938107170472},{"$f":"CurvaRemansoIzq!A18","v":0.76420780672704502},{"$f":"CurvaRemansoIzq!M18","v":0.71931072301066301},{"$f":"CurvaRemansoDer!O18","v":0.19194198596353551},{"$f":"CurvaRemansoDer!A18","v":0.73701212055254817},{"$f":"CurvaRemansoDer!M18","v":0.74607179804913959},{"$f":"G54","v":-582.25734997531936},{"$f":"H53","v":0.89269987749321777},0,{"$f":"J53","v":0.71139530299656961}]
[{"$f":"CurvaRemansoIzq!O19","v":-2.1193988392876451},{"$f":"CurvaRemansoIzq!A19","v":0.76798698527899123},{"$f":"CurvaRemansoIzq!M19","v":0.71569312413000319},{"$f":"CurvaRemansoDer!O19","v":0.26636413228274886},{"$f":"CurvaRemansoDer!A19","v":0.73625868474207823},{"$f":"CurvaRemansoDer!M19","v":0.74683191268202265},0,{"$f":"H53","v":0.89269987749321777},{"$f":"I53","v":71.325005126857917},{"$f":"J54","v":0.71139530299656961}]
[{"$f":"CurvaRemansoIzq!O20","v":-2.8257331100831236},{"$f":"CurvaRemansoIzq!A20","v":0.77176616383093744},{"$f":"CurvaRemansoIzq!M20","v":0.71209947692948161},{"$f":"CurvaRemansoDer!O20","v":0.35487411854902678},{"$f":"CurvaRemansoDer!A20","v":0.73550524893160829},{"$f":"CurvaRemansoDer!M20","v":0.74759306271542358}]
[{"$f":"CurvaRemansoIzq!O21","v":-3.6524531563963372},{"$f":"CurvaRemansoIzq!A21","v":0.77554534238288364},{"$f":"CurvaRemansoIzq!M21","v":0.70852955021538311},{"$f":"CurvaRemansoDer!O21","v":0.4583654004840596},{"$f":"CurvaRemansoDer!A21","v":0.73475181312113835},{"$f":"CurvaRemansoDer!M21","v":0.74835525027716532},"Régimen crítico"]
[{"$f":"CurvaRemansoIzq!O22","v":-4.6076370740140495},{"$f":"CurvaRemansoIzq!A22","v":0.77932452093482985},{"$f":"CurvaRemansoIzq!M22","v":0.70498311648334533},{"$f":"CurvaRemansoDer!O22","v":0.57781930977625062},{"$f":"CurvaRemansoDer!A22","v":0.73399837731066842},{"$f":"CurvaRemansoDer!M22","v":0.74911847750236882},"Tramo 1",null,"Tramo 2"]
[{"$f":"CurvaRemansoIzq!O23","v":-5.7001823790675292},{"$f":"CurvaRemansoIzq!A23","v":0.78310369948677605},{"$f":"CurvaRemansoIzq!M23","v":0.70145995183488963},{"$f":"CurvaRemansoDer!O23","v":0.71431696964048186},{"$f":"CurvaRemansoDer!A23","v":0.73324494150019848},{"$f":"CurvaRemansoDer!M23","v":0.74988274653348785},"x","yc1=","x","yc2="]
[{"$f":"CurvaRemansoIzq!O24","v":-6.939921032219095},{"$f":"CurvaRemansoIzq!A24","v":0.78688287803872226},{"$f":"CurvaRemansoIzq!M24","v":0.6979598358962027},{"$f":"CurvaRemansoDer!O24","v":0.86905330089394983},{"$f":"CurvaRemansoDer!A24","v":0.73249150568972854},{"$f":"CurvaRemansoDer!M24","v":0.75064805952034364},{"$f":"MIN(-$Q$6,$A$93)","v":-582.25734997531936},{"$f":"F31","v":0.74153273541536779},0,{"$f":"G31","v":0.74153273541536779}]
[{"$f":"CurvaRemansoIzq!O25","v":-8.3377553742674593},{"$f":"CurvaRemansoIzq!A25","v":0.79066205659066846},{"$f":"CurvaRemansoIzq!M25","v":0.69448255173909312},{"$f":"CurvaRemansoDer!O25","v":1.0433535746259448},{"$f":"CurvaRemansoDer!A25","v":0.7317380698792586},{"$f":"CurvaRemansoDer!M25","v":0.75141441862016056},0,{"$f":"F31","v":0.74153273541536779},{"$f":"$L$45*MAX($Q$6,$D$93)","v":78.457505639543712},{"$f":"G31","v":0.74153273541536779}]
[{"$f":"CurvaRemansoIzq!O26","v":-9.9058197074631966},{"$f":"CurvaRemansoIzq!A26","v":0.79444123514261467},{"$f":"CurvaRemansoIzq!M26","v":0.69102788580406416},{"$f":"CurvaRemansoDer!O26","v":1.2386930880813307},{"$f":"CurvaRemansoDer!A26","v":0.73098463406878866},{"$f":"CurvaRemansoDer!M26","v":0.75218182599760097}]
[{"$f":"CurvaRemansoIzq!O27","v":-11.657673556304728},{"$f":"CurvaRemansoIzq!A27","v":0.79822041369456087},{"$f":"CurvaRemansoIzq!M27","v":0.68759562782542927},{"$f":"CurvaRemansoDer!O27","v":1.4567206986471783},{"$f":"CurvaRemansoDer!A27","v":0.73023119825831873},{"$f":"CurvaRemansoDer!M27","v":0.75295028382480289},"Régimen conjugado del uniforme"]
[{"$f":"CurvaRemansoIzq!O28","v":-13.608534365380287},{"$f":"CurvaRemansoIzq!A28","v":0.80199959224650708},{"$f":"CurvaRemansoIzq!M28","v":0.68418557075841746},{"$f":"CurvaRemansoDer!O28","v":1.6992871607963318},{"$f":"CurvaRemansoDer!A28","v":0.72947776244784879},{"$f":"CurvaRemansoDer!M28","v":0.75371979428141367},"Tramo 1",null,"Tramo 2"]
[{"$f":"CurvaRemansoIzq!O29","v":-15.775559702361903},{"$f":"CurvaRemansoIzq!A29","v":0.80577877079845328},{"$f":"CurvaRemansoIzq!M29","v":0.68079751070819905},{"$f":"CurvaRemansoDer!O29","v":1.9684794923064053},{"$f":"CurvaRemansoDer!A29","v":0.72872432663737885},{"$f":"CurvaRemansoDer!M29","v":0.75449035955462718},"x","yu1c=","x","yu2c="]
[{"$f":"CurvaRemansoIzq!O30","v":-18.178192166265692},{"$f":"CurvaRemansoIzq!A30","v":0.80955794935039949},{"$f":"CurvaRemansoIzq!M30","v":0.67743124686078149},{"$f":"CurvaRemansoDer!O30","v":2.2666629776143914},{"$f":"CurvaRemansoDer!A30","v":0.72797089082690891},{"$f":"CurvaRemansoDer!M30","v":0.75526198183922089},{"$f":"MIN(-$Q$6,$A$93)","v":-582.25734997531936},{"$f":"F37","v":0.60851635250899305},0,{"$f":"G37","v":0.77250963658885552}]
[{"$f":"CurvaRemansoIzq!O31","v":-20.838584498353868},{"$f":"CurvaRemansoIzq!A31","v":0.81333712790234569},{"$f":"CurvaRemansoIzq!M31","v":0.67408658141571309},{"$f":"CurvaRemansoDer!O31","v":2.5965329396231054},{"$f":"CurvaRemansoDer!A31","v":0.72721745501643897},{"$f":"CurvaRemansoDer!M31","v":0.75603466333759073},0,{"$f":"F37","v":0.60851635250899305},{"$f":"$L$45*MAX($Q$6,$D$93)","v":78.457505639543712},{"$f":"G37","v":0.77250963658885552}]
[{"$f":"CurvaRemansoIzq!O32","v":-23.782128367148879},{"$f":"CurvaRemansoIzq!A32","v":0.8171163064542919},{"$f":"CurvaRemansoIzq!M32","v":0.67076331952054402},{"$f":"CurvaRemansoDer!O32","v":2.9611791391420645},{"$f":"CurvaRemansoDer!A32","v":0.72646401920596904},{"$f":"CurvaRemansoDer!M32","v":0.7568084062597904}]
[{"$f":"CurvaRemansoIzq!O33","v":-27.038118723745985},{"$f":"CurvaRemansoIzq!A33","v":0.8208954850062381},{"$f":"CurvaRemansoIzq!M33","v":0.66746126920699389},{"$f":"CurvaRemansoDer!O33","v":3.3641666874338387},{"$f":"CurvaRemansoDer!A33","v":0.7257105833954991},{"$f":"CurvaRemansoDer!M33","v":0.75758321282356544},"Solera"]
[{"$f":"CurvaRemansoIzq!O34","v":-30.640597691006946},{"$f":"CurvaRemansoIzq!A34","v":0.82467466355818431},{"$f":"CurvaRemansoIzq!M34","v":0.66418024132876874},{"$f":"CurvaRemansoDer!O34","v":3.8096388277053692},{"$f":"CurvaRemansoDer!A34","v":0.72495714758502916},{"$f":"CurvaRemansoDer!M34","v":0.75835908525439322},"Tramo 1",null,"Tramo 2"]
[{"$f":"CurvaRemansoIzq!O35","v":-34.629439533486611},{"$f":"CurvaRemansoIzq!A35","v":0.82845384211013051},{"$f":"CurvaRemansoIzq!M35","v":0.66092004950098704},{"$f":"CurvaRemansoDer!O35","v":4.3024490836197611},{"$f":"CurvaRemansoDer!A35","v":0.72420371177455922},{"$f":"CurvaRemansoDer!M35","v":0.75913602578551787},"x","ys1","x","ys2"]
[{"$f":"CurvaRemansoIzq!O36","v":-39.051764362268891},{"$f":"CurvaRemansoIzq!A36","v":0.83223302066207672},{"$f":"CurvaRemansoIzq!M36","v":0.65768051004116013},{"$f":"CurvaRemansoDer!O36","v":4.8483334541840115},{"$f":"CurvaRemansoDer!A36","v":0.72345027596408928},{"$f":"CurvaRemansoDer!M36","v":0.7599140366579904},{"$f":"MIN(-$Q$6,$A$93)","v":-582.25734997531936},1E-3,0,1E-3]
[{"$f":"CurvaRemansoIzq!O37","v":-43.963807809134089},{"$f":"CurvaRemansoIzq!A37","v":0.83601219921402292},{"$f":"CurvaRemansoIzq!M37","v":0.65446144191168776},{"$f":"CurvaRemansoDer!O37","v":5.4541381573018706},{"$f":"CurvaRemansoDer!A37","v":0.72269684015361935},{"$f":"CurvaRemansoDer!M37","v":0.76069312012070478},0,1E-3,{"$f":"$L$45*MAX($Q$6,$D$93)","v":78.457505639543712},1E-3]
[{"$f":"CurvaRemansoIzq!O38","v":-49.433435318753361},{"$f":"CurvaRemansoIzq!A38","v":0.83979137776596913},{"$f":"CurvaRemansoIzq!M38","v":0.65126266666382071},{"$f":"CurvaRemansoDer!O38","v":6.1281259085868367},{"$f":"CurvaRemansoDer!A38","v":0.72194340434314941},{"$f":"CurvaRemansoDer!M38","v":0.76147327843043622}]
[{"$f":"CurvaRemansoIzq!O39","v":-55.543587509716374},{"$f":"CurvaRemansoIzq!A39","v":0.84357055631791533},{"$f":"CurvaRemansoIzq!M39","v":0.64808400838304858},{"$f":"CurvaRemansoDer!O39","v":6.8803956413693692},{"$f":"CurvaRemansoDer!A39","v":0.72118996853267947},{"$f":"CurvaRemansoDer!M39","v":0.76225451385188114},"Curvas de remanso (punto medio)"]
[{"$f":"CurvaRemansoIzq!O40","v":-62.397103439817641},{"$f":"CurvaRemansoIzq!A40","v":0.84734973486986154},{"$f":"CurvaRemansoIzq!M40","v":0.64492529363587292},{"$f":"CurvaRemansoDer!O40","v":7.7234701220814905},{"$f":"CurvaRemansoDer!A40","v":0.72043653272220953},{"$f":"CurvaRemansoDer!M40","v":0.76303682865769351},"Tramo 1",null,"Tramo 2"]
[{"$f":"CurvaRemansoIzq!O41","v":-70.123640546367781},{"$f":"CurvaRemansoIzq!A41","v":0.85112891342180774},{"$f":"CurvaRemansoIzq!M41","v":0.64178635141792573},{"$f":"CurvaRemansoDer!O41","v":8.6731390627805194},{"$f":"CurvaRemansoDer!A41","v":0.71968309691173959},{"$f":"CurvaRemansoDer!M41","v":0.76382022512852499},"x",{"$f":"IF(F46=\"No hay\",\"\",F46)","v":"S2"},"x",{"$f":"IF(G46=\"No hay\",\"\",G46)","v":"F2"}]
[{"$f":"CurvaRemansoIzq!O42","v":-78.889889113752076},{"$f":"CurvaRemansoIzq!A42","v":0.85490809197375395},{"$f":"CurvaRemansoIzq!M42","v":0.63866701310339358},{"$f":"CurvaRemansoDer!O42","v":9.7497037368004893},{"$f":"CurvaRemansoDer!A42","v":0.71892966110126966},{"$f":"CurvaRemansoDer!M42","v":0.76460470555306337},{"$f":"(A53+A93)/2","v":-291.12867498765968},{"$f":"(B53+B93)/2","v":0.8171163064542919},{"$f":"(D53+D93)/2","v":35.662502563428959},{"$f":"(E53+E93)/2","v":0.72646401920596904}]
[{"$f":"CurvaRemansoIzq!O43","v":-88.915161546552582},{"$f":"CurvaRemansoIzq!A43","v":0.85868727052570015},{"$f":"CurvaRemansoIzq!M43","v":0.63556711239571062},{"$f":"CurvaRemansoDer!O43","v":10.979876693134527},{"$f":"CurvaRemansoDer!A43","v":0.71817622529079972},{"$f":"CurvaRemansoDer!M43","v":0.76539027222807221}]
[{"$f":"CurvaRemansoIzq!O44","v":-100.49614945925705},{"$f":"CurvaRemansoIzq!A44","v":0.86246644907764636},{"$f":"CurvaRemansoIzq!M44","v":0.63248648527948592},{"$f":"CurvaRemansoDer!O44","v":12.399799021986363},{"$f":"CurvaRemansoDer!A44","v":0.71742278948032978},{"$f":"CurvaRemansoDer!M44","v":0.76617692745842969},"Resalto"]
[{"$f":"CurvaRemansoIzq!O45","v":-114.04818071197261},{"$f":"CurvaRemansoIzq!A45","v":0.86624562762959256},{"$f":"CurvaRemansoIzq!M45","v":0.62942496997362818},{"$f":"CurvaRemansoDer!O45","v":14.060069277883809},{"$f":"CurvaRemansoDer!A45","v":0.71666935366985984},{"$f":"CurvaRemansoDer!M45","v":0.76696467355716935},"Tramo 1"]
[{"$f":"CurvaRemansoIzq!O46","v":-130.1782020228641},{"$f":"CurvaRemansoIzq!A46","v":0.87002480618153877},{"$f":"CurvaRemansoIzq!M46","v":0.62638240688563751},{"$f":"CurvaRemansoDer!O46","v":16.034641131772879},{"$f":"CurvaRemansoDer!A46","v":0.71591591785938991},{"$f":"CurvaRemansoDer!M46","v":0.76775351284551874},"x","yres"]
[{"$f":"CurvaRemansoIzq!O47","v":-149.82408321216079},{"$f":"CurvaRemansoIzq!A47","v":0.87380398473348497},{"$f":"CurvaRemansoIzq!M47","v":0.62335863856702389},{"$f":"CurvaRemansoDer!O47","v":18.437810604829032},{"$f":"CurvaRemansoDer!A47","v":0.71516248204891997},{"$f":"CurvaRemansoDer!M47","v":0.76854344765294014},{"$f":"IF(K39=1, IF(G46 = \"S3\", D93, A93), \"\")","v":""},{"$f":"IF(K39=1, IF(G46 = \"S3\", G32, F32), \"\")","v":""}]
[{"$f":"CurvaRemansoIzq!O48","v":-174.54862925004861},{"$f":"CurvaRemansoIzq!A48","v":0.87758316328543118},{"$f":"CurvaRemansoIzq!M48","v":0.62035350966983316},{"$f":"CurvaRemansoDer!O48","v":21.460080308362134},{"$f":"CurvaRemansoDer!A48","v":0.71440904623845003},{"$f":"CurvaRemansoDer!M48","v":0.76933448031717122},{"$f":"G88","v":""},{"$f":"IF(K39=1, IF(G46 = \"S3\", G37, F37), \"\")","v":""}]
[{"$f":"CurvaRemansoIzq!O49","v":-207.25334897049845},{"$f":"CurvaRemansoIzq!A49","v":0.88136234183737738},{"$f":"CurvaRemansoIzq!M49","v":0.6173668669042377},{"$f":"CurvaRemansoDer!O49","v":25.455266345987514},{"$f":"CurvaRemansoDer!A49","v":0.71365561042798009},{"$f":"CurvaRemansoDer!M49","v":0.77012661318426534}]
[{"$f":"CurvaRemansoIzq!O50","v":-254.31852178471169},{"$f":"CurvaRemansoIzq!A50","v":0.88514152038932359},{"$f":"CurvaRemansoIzq!M50","v":0.61439855899716966},{"$f":"CurvaRemansoDer!O50","v":31.201857266814354},{"$f":"CurvaRemansoDer!A50","v":0.71290217461751015},{"$f":"CurvaRemansoDer!M50","v":0.77091984860863239}]
[{"$f":"CurvaRemansoIzq!O51","v":-334.86650350719401},{"$f":"CurvaRemansoIzq!A51","v":0.88892069894126979},{"$f":"CurvaRemansoIzq!M51","v":0.61144843665196547},{"$f":"CurvaRemansoDer!O51","v":41.035888346006722},{"$f":"CurvaRemansoDer!A51","v":0.71214873880704022},{"$f":"CurvaRemansoDer!M51","v":0.77171418895308019}]
[{"$f":"CurvaRemansoIzq!O52","v":-582.25734997531936},{"$f":"CurvaRemansoIzq!A52","v":0.892699877493216},{"$f":"CurvaRemansoIzq!M52","v":0.60851635250899438},{"$f":"CurvaRemansoDer!O52","v":71.325005126857917},{"$f":"CurvaRemansoDer!A52","v":0.71139530299657028},{"$f":"CurvaRemansoDer!M52","v":0.77250963658885519}]

{"sheet":"CurvaRemansoIzq","index":2,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":"Curva S2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pendienes","Curvas",null,null,"Limites",null,"x","yc","yu"]
["Ancho del canal rectángular",null,null,null,"b",{"$f":"Principal!F40","v":6},"m",null,"Densidad del agua",null,null,"ro",{"$f":"Principal!G22","v":1000},"kg/m3",null,null,null,"Suave","S1","S2","S3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S6:U6),LOOKUP(M8,S5:U5,S8:U8))","v":0.89269987749321777},null,{"$f":"O12","v":0},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!F41","v":12},"m3/s",null,"Gravedad de la tierra",null,null,"g",{"$f":"Principal!G23","v":9.81},"m/s",null,null,null,"Crítica","F1","F2","F3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S7:U7),LOOKUP(M8,S5:U5,S9:U9))","v":-1},null,{"$f":"O52","v":-582.25734997531936},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!F42","v":1.0999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":0.74153273541536779},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!F43","v":1E-3},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":0.89269987749321777},"m",null,null,null,"Suave",{"$f":"M6","v":0.89269987749321777},{"$f":"M6","v":0.89269987749321777},{"$f":"M5","v":0.74153273541536779}]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"Principal!F44","v":0.74153273541536779},"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":"Suave"},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!F45","v":0.89269987749321777},"m",null,"Tipo de curva de remanso",null,null,"Curva",{"$f":"IF(M7=R3,IF(F7>M6,S3,IF(F7<M5,U3,T3)),IF(M7=R5,IF(F7>M5,S5,IF(F7<M6,U5,T5)),\"No hay\"))","v":"S2"},"-",null,null,null,"Fuerte",{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777},{"$f":"M6","v":0.89269987749321777}]
["Coordenada x para inicio de la curva",null,null,null,"xini",0,"m",null,"Incremento del intervalo en Y",null,null,"Incy",{"$f":"(F8-F7)/40","v":3.7791785519462493E-3},"m",null,null,null,"signo",1,1,-1]
["Calado","Perímetro mojado","Superficie mojada","Radio hidráulico","velocidad","Energía específica","Pendiente de pérdidas","Incremento energía específica","Pendiente de pérdidas media","Incremento en x","X acumulada","Número de Froude al cuadrado","Calado conjugado","Impulsión","x para dibujo"]
["y","p","S","Rh","v","H","I","DH","Im","Dx","x","F2","Yc","N","Xdib"]
[{"$f":"F7","v":0.74153273541536779},{"$f":"$F$3+2*A12","v":7.483065470830736},{"$f":"$F$3*A12","v":4.4491964124922063},{"$f":"C12/B12","v":0.59456868710227606},{"$f":"$F$4/C12","v":2.6971162626821927},{"$f":"A12+E12^2/2/$M$4","v":1.1122991031230518},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":1.7605512060529637E-3},"H1-H2","(I1+I2)/2","(H1-H2)/(Im-I0)",null,{"$f":"E12^2/$M$4/A12","v":1.0000000000000002},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":0.74153273541536791},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":48548.092728279466},{"$f":"$F$9+K12","v":0}]
[{"$f":"A12+$M$9","v":0.745311913967314},7.4906238279346278,4.4718714838038842,{"$f":"C13/B13","v":0.59699586930624216},2.6834402651018281,{"$f":"A13+E13^2/2/$M$4","v":1.1123277985937039},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":1.7333015799866351E-3},{"$f":"F12-F13","v":-2.8695470652095878E-5},{"$f":"(G12+G13)/2","v":1.7469263930197994E-3},{"$f":"IFERROR(H13/(I13-$F$6),0)","v":-3.8418070268050122E-2},{"$f":"J13+K12","v":-3.8418070268050122E-2},0.98486520273842149,0.73776635366423848,48549.34944028264,{"$f":"$F$9+K13","v":-3.8418070268050122E-2}]
[0.7490910925192602,7.4981821850385204,4.4945465551155612,{"$f":"C14/B14","v":0.59941815818822641},2.6699022588478813,1.1124131145274672,{"$f":"$F$5^2*E14^2/D14^(4/3)","v":1.7066176624722464E-3},{"$f":"F13-F14","v":-8.5315933763263629E-5},{"$f":"(G13+G14)/2","v":1.7199596212294408E-3},{"$f":"IFERROR(H14/(I14-$F$6),0)","v":-0.11850099817761123},{"$f":"J14+K13","v":-0.15691906844566134},0.97003428724889107,0.73402539320823368,48553.102697937269,{"$f":"$F$9+K14","v":-0.15691906844566134}]
[0.75287027107120641,7.505740542142413,4.5172216264272382,0.60183556853110431,2.6565001658975591,1.1125539169128862,{"$f":"$F$5^2*E15^2/D15^(4/3)","v":1.6804848325919545E-3},-1.4080238541902546E-4,{"$f":"(G14+G15)/2","v":1.6935512475321005E-3},-0.20301655561870868,{"$f":"J15+K14","v":-0.35993562406437002},0.95549966484906146,0.73030959882934032,48559.327564969848,-0.35993562406437002]
[0.75664944962315261,7.5132988992463048,4.5398966977389161,0.60424811505826492,2.6432319497438277,1.112749099987401,1.6548889199277668E-3,-1.9518307451482642E-4,1.6676868762598605E-3,-0.29232725916101743,-0.65226288322538739,0.94125397313538806,0.72661871955115565,48567.999603295961,-0.65226288322538739]
[0.76042862817509882,7.5208572563501974,4.5625717690505931,0.60665581243390954,2.630095614363789,1.1129975853970986,1.6298161884823101E-3,-2.4848540969757416E-4,1.6423525542050383E-3,-0.38683649355935751,-1.039099376784745,0.92729006815039616,0.72295250854031923,48579.094860640835,-1.039099376784745]
[0.76420780672704502,7.52841561345409,4.5852468403622701,0.60905867526335022,2.6170892032176627,1.1132983213854784,1.6052533212508099E-3,-3.0073598837976334E-4,1.61753475486656E-3,-0.48699443393230213,-1.5260938107170472,0.91360101685828299,0.71931072301066301,48592.589858527113,-1.5260938107170472]
[0.76798698527899123,7.5359739705579827,4.6079219116739472,0.61145671809330371,2.6042107982773279,1.1136502820100942,1.5811874054148442E-3,-3.5196062461584354E-4,1.5932203633328272E-3,-0.59330502857059797,-2.1193988392876451,0.90018008991527809,0.71569312413000319,48608.461580617324,-2.1193988392876451]
[0.77176616383093744,7.5435323276618753,4.6305969829856242,0.61384995541218579,2.5914585190834032,1.1140524663859805,{"$f":"$F$5^2*E20^2/D20^(4/3)","v":1.5576059181298474E-3},{"$f":"F19-F20","v":-4.021843758863497E-4},{"$f":"(G19+G20)/2","v":1.5693966617723459E-3},-0.70633427079547861,-2.8257331100831236,0.8870207547218254,0.71209947692948161,48626.68746139892,-2.8257331100831236]
[0.77554534238288364,7.5510906847657671,4.6532720542973021,0.61623840165040278,2.5788305218298997,1.1145038979548241,1.534496712879778E-3,-4.5143156884352997E-4,1.5460513155048127E-3,-0.82672004631321361,-3.6524531563963372,0.87411666874429628,0.70852955021538311,48647.245375200007,-3.6524531563963372]
[0.77932452093482985,7.5586490418696597,4.6759471256089791,0.61862207118064139,2.5663249984755039,1.1150036237788816,1.5118480063736569E-3,-4.9972582405755084E-4,1.5231723596267174E-3,-0.95518391761771271,-4.6076370740140495,0.8614616730945196,0.70498311648334533,48670.113625524842,-4.6076370740140495]
[0.78310369948677605,7.5662073989735523,4.6986221969206561,0.62100097831815726,2.5539401758805931,1.1155507138586922,1.4896483659599285E-3,-5.4709007981057489E-4,1.5007481861667926E-3,-1.0925453050534795,-5.7001823790675292,0.8490497863559896,0.70145995183488963,48695.270934697939,-5.7001823790675292]
[0.78688287803872226,7.5737657560774441,4.721297268232334,0.62337513732106209,2.541674314969121,{"$f":"A24+E24^2/2/$M$4","v":1.116144260473674},1.4678866975357857E-3,-5.9354661498178807E-4,1.4787675317478571E-3,-1.2397386531515662,-6.939921032219095,0.83687519864614157,{"$f":"A24/2*(SQRT(1+8*L24)-1)","v":0.6979598358962027},48722.696433806748,-6.939921032219095]
[0.79066205659066846,7.5813241131813367,4.743972339544011,0.62574456239060683,2.5295257099145387,{"$f":"A25+E25^2/2/$M$4","v":1.1167833775447282},1.4465522339297098E-3,-6.3911707105424043E-4,1.4572194657327478E-3,-1.397834342048365,-8.3377553742674593,0.8249322659045849,0.69448255173909312,48752.369652932684,-8.3377553742674593]
[0.79444123514261467,7.5888824702852293,4.766647410855688,0.62810926767146691,2.51749268734895,1.1174672000180192,1.4256345237365123E-3,-6.8382247329101808E-4,1.436093378833111E-3,-1.5680643331957371,-9.9058197074631966,0.81321550439766976,0.69102788580406416,48784.270511660987,-9.9058197074631966]
[0.79822041369456087,7.596440827389122,4.789322482167365,0.63046926725202224,2.5055736055947326,1.1181948832691271,1.4051234205852011E-3,-7.2768325110783572E-4,1.4153789721608567E-3,-1.7518538488415305,-11.657673556304728,0.80171958543020794,0.68759562782542927,48818.379309860204,-11.657673556304728]
[0.80199959224650708,7.6039991844930146,4.811997553479042,0.63282457516463753,2.493766853917887,1.1189656025268087,1.3850090728209168E-3,-7.7071925768157357E-4,1.395066246703059E-3,-1.9508608090755581,-13.608534365380287,0.79043933025561197,0.68418557075841746,48854.676718722323,-13.608534365380287]
[0.80577877079845328,7.6115575415969063,4.8346726247907199,0.63517520538594052,2.4820708518023902,1.1197785523156318,1.3652819135830669E-3,-8.129497888231807E-4,1.3751454932019918E-3,-2.1670253369816161,-15.775559702361903,0.77936970517610782,0.68079751070819905,48893.143772055075,-15.775559702361903]
[0.80955794935039949,7.619115898700799,4.8573476961023969,0.63752117183709789,2.4704840482448818,1.1206329459167816,1.3459326512626855E-3,-8.5439360114980545E-4,1.3556072824228763E-3,-2.4026324639037879,-18.178192166265692,0.76850581682507868,0.67743124686078149,48933.761857818143,-18.178192166265692]
[0.81333712790234569,7.6266742558046916,4.8800227674140739,0.63986248838409077,2.4590049210690066,1.1215280148463616,1.326952260322788E-3,-8.9506892957991191E-4,1.3364424557927366E-3,-2.6603923320881768,-20.838584498353868,0.75784290762395679,0.67408658141571309,48976.512709895251,-20.838584498353868]
[0.8171163064542919,7.6342326129085833,4.9026978387257518,0.64219916883798778,2.4476319762587879,1.1224630083505458,1.3083319724663098E-3,-9.3499350418424498E-4,1.3176421163945489E-3,-2.9435438687950093,-23.782128367148879,0.74737635140643066,0.67076331952054402,49021.378400094691,-23.782128367148879]
[0.8208954850062381,7.641790970012476,4.9253729100374288,0.6445312269552157,2.4363637473104163,1.1234371929169646,1.2900632681369108E-3,-9.7418456641884532E-4,1.2991976203016102E-3,-3.2559903565971062,-27.038118723745985,0.73710164920307109,0.66746126920699389,49068.341330370735,-27.038118723745985]
[0.82467466355818431,7.6493493271163686,4.9480479813491058,0.64685867643783079,2.4251987946018563,1.1244498518017263,1.2721378683386189E-3,-1.0126588847616524E-3,1.2811005682377649E-3,-3.6024789672609612,-30.640597691006946,0.72701442517978287,0.66418024132876874,49117.384225258967,-30.640597691006946]
[0.82845384211013051,7.6569076842202612,4.9707230526607828,0.6491815309337865,2.4141357047797118,1.1255002845715085,1.254547726760948E-3,-1.050432769782228E-3,1.2633427975497834E-3,-3.9888418424796681,-34.629439533486611,0.71711042272380476,0.66092004950098704,49168.490124518641,-34.629439533486611]
[0.83223302066207672,7.6644660413241539,4.9933981239724599,0.65149980403719998,2.4031730901627952,1.1265878066601704,1.2372850221967424E-3,-1.0875220886619186E-3,1.2459163744788452E-3,-4.4223248287822825,-39.051764362268891,0.70738550067124695,0.65768051004116013,49221.642375975498,-39.051764362268891]
[0.83601219921402292,7.6720243984280456,5.0160731952841378,0.65381350928861781,2.3923095881618717,1.1277117489393655,1.2203421512405716E-3,-1.1239422791951004E-3,1.228813586718657E-3,-4.912043446865197,-43.963807809134089,0.697835629670438,0.65446144191168776,49276.824628558708,-43.963807809134089]
[0.83979137776596913,7.6795827555319383,5.0387482665958148,0.65612266017527898,2.3815438607150772,1.1288714573026497,1.2037117212560901E-3,-1.159708363284162E-3,1.2120269362483308E-3,-5.4696275096192748,-49.433435318753361,0.68845688867560817,0.65126266666382071,49334.020825525928,-49.433435318753361]
[0.84357055631791533,7.6871411126358309,5.0614233379074918,0.6584272701313777,2.3708745937385025,1.1300662922625997,1.1873865436012603E-3,-1.1948349599499863E-3,1.1955491324286752E-3,-6.1101521909630145,-55.543587509716374,0.67924546156566712,0.64808400838304858,49393.215197870231,-55.543587509716374]
[0.84734973486986154,7.6946994697397226,5.0840984092191697,0.6607273525383236,2.360300496591488,1.1312956285604847,1.1713596271008934E-3,-1.2293362978850197E-3,1.179373085351077E-3,-6.853515930101266,-62.397103439817641,0.6701976338830915,0.64492529363587292,49454.392257903703,-62.397103439817641]
[0.85112891342180774,7.7022578268436153,5.1067734805308467,0.66302292072500024,2.3498203015561612,1.1325588547880405,1.1556241717564028E-3,-1.2632262275558137E-3,1.1634918994286481E-3,-7.7265371065501443,-70.123640546367781,0.66130978968813381,0.64178635141792573,49517.536793011874,-70.123640546367781]
[0.85490809197375395,7.7098161839475079,5.1294485518425237,0.66531398796802332,2.3394327633307754,1.1338553730209235,1.1401735626831249E-3,-1.2965182328830149E-3,1.1478988672197639E-3,-8.7662485673842916,-78.889889113752076,0.65257840852378646,0.63866701310339358,49582.633859573783,-78.889889113752076]
[0.85868727052570015,7.7173745410514005,5.1521236231542007,0.66760056749199648,2.3291366585364339,1.1351845984634301,1.1250013642660199E-3,-1.3292254425065764E-3,1.1325874634745725E-3,-10.025272432800511,-88.915161546552582,0.64400006248713715,0.63556711239571062,49649.66877704268,-88.915161546552582]
[0.86246644907764636,7.7249328981552932,5.1747986944658777,0.66988267246976541,2.318930785236776,1.1365459591040914,1.1101013145249413E-3,-1.3613606406612799E-3,1.1175513393954805E-3,-11.580987912704465,-100.49614945925705,0.63557141340293477,0.63248648527948592,49718.627122182217,-100.49614945925705]
[0.86624562762959256,7.7324912552591849,5.1974737657775556,0.67216031602267123,2.3088139624702402,1.1379388953817604,1.095467319681078E-3,-1.3929362776690102E-3,1.1027843171030095E-3,-13.552031252715549,-114.04818071197261,0.62728921009537042,0.62942496997362818,49789.494723453674,-114.04818071197261]
[0.87002480618153877,7.7400496123630775,5.2201488370892326,0.67443351122080131,2.2987850297945198,1.1393628598618339,1.0810934489165467E-3,-1.4239644800735363E-3,1.0882803842988125E-3,-16.130021310891504,-130.1782020228641,0.61915028575425535,0.62638240688563751,49862.257655549358,-130.1782020228641]
[0.87380398473348497,7.7476079694669702,5.2428239084009096,0.67670227108324021,2.2888428468428317,1.1408173169222513,1.066973929319433E-3,-1.4544570604173579E-3,1.0740336891179899E-3,-19.645881189296698,-149.82408321216079,0.61115155539192689,0.62335863856702389,49936.902234067886,-149.82408321216079]
[0.87758316328543118,7.7551663265708619,5.2654989797125875,0.67896660857831759,2.2789862928916587,1.1423017424489412,1.0531031410069703E-3,-1.4844255266899253E-3,1.0600385351632016E-3,-24.724546037887823,-174.54862925004861,0.60329001338739463,0.62035350966983316,50013.415010327044,-174.54862925004861]
[0.88136234183737738,7.7627246836747545,5.2881740510242645,0.68122653662385513,2.2692142664396084,1.1438156235403871,1.0394756124198199E-3,-1.5138810914459011E-3,1.046289376713395E-3,-32.704719720449845,-207.25334897049845,0.59556273111436309,0.6173668669042377,50091.78276631012,-207.25334897049845]
[0.88514152038932359,7.7702830407786472,5.3108491223359415,0.68348206808741296,2.2595256847970631,1.1453584582210075,1.0260860157807422E-3,-1.5428346806203308E-3,1.0327808141002812E-3,-47.065172814213234,-254.31852178471169,0.58796685464993015,0.61439855899716966,50171.9925097417,-254.31852178471169]
[0.88892069894126979,7.7778413978825398,5.3335241936476185,0.68573321578653323,2.2499194836862926,1.1469297551630431,1.0129291627112358E-3,-1.571296942035616E-3,1.019507589245989E-3,-80.547981722482334,-334.86650350719401,0.58049960256087985,0.61144843665196547,50254.031469289024,-334.86650350719401]
[0.892699877493216,7.7853997549864324,5.3561992649592955,0.68797999248898301,2.2403946168517304,1.1485290334166722,1.0000000000000065E-3,-1.599278253629155E-3,1.0064645813556211E-3,-247.3908464681254,-582.25734997531936,0.57315826376463319,0.60851635250899438,50337.887089885306,-582.25734997531936]

{"sheet":"CurvaRemansoDer","index":3,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":"Curva F2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pendienes","Curvas",null,null,"Limites",null,"x","yc","yu"]
["Ancho del canal rectángular",null,null,null,"b",{"$f":"Principal!G40","v":6},"m",null,"Densidad del agua",null,null,"ro",{"$f":"Principal!G22","v":1000},"kg/m3",null,null,null,"Suave","S1","S2","S3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S6:U6),LOOKUP(M8,S5:U5,S8:U8))","v":0.71139530299656961},null,{"$f":"O12","v":0},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!G41","v":12},"m3/s",null,"Gravedad de la tierra",null,null,"g",{"$f":"Principal!G23","v":9.81},"m/s",null,null,null,"Crítica","F1","F2","F3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S7:U7),LOOKUP(M8,S5:U5,S9:U9))","v":1},null,{"$f":"O52","v":71.325005126857917},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!G42","v":1.0999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":0.74153273541536779},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!G43","v":2E-3},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":0.71139530299656961},"m",null,null,null,"Suave",{"$f":"M6","v":0.71139530299656961},{"$f":"M6","v":0.71139530299656961},{"$f":"M5","v":0.74153273541536779}]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"Principal!G44","v":0.74153273541536779},"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":"Fuerte"},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!G45","v":0.71139530299656961},"m",null,"Tipo de curva de remanso",null,null,"Curva",{"$f":"IF(M7=R3,IF(F7>M6,S3,IF(F7<M5,U3,T3)),IF(M7=R5,IF(F7>M5,S5,IF(F7<M6,U5,T5)),\"No hay\"))","v":"F2"},"-",null,null,null,"Fuerte",{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961},{"$f":"M6","v":0.71139530299656961}]
["Coordenada x para inicio de la curva",null,null,null,"xini",0,"m",null,"Incremento del intervalo en Y",null,null,"Incy",{"$f":"(F8-F7)/40","v":-7.534358104699546E-4},"m",null,null,null,"signo",1,1,-1]
["Calado","Perímetro mojado","Superficie mojada","Radio hidráulico","velocidad","Energía específica","Pendiente de pérdidas","Incremento energía específica","Pendiente de pérdidas media","Incremento en x","X acumulada","Número de Froude al cuadrado","Calado conjugado","Impulsión","x para dibujo"]
["y","p","S","Rh","v","H0","I","DH0","Im","Dx","x","F2","Yc","N","Xdib"]
[{"$f":"F7","v":0.74153273541536779},{"$f":"$F$3+2*A12","v":7.483065470830736},{"$f":"$F$3*A12","v":4.4491964124922063},{"$f":"C12/B12","v":0.59456868710227606},{"$f":"$F$4/C12","v":2.6971162626821927},{"$f":"A12+E12^2/2/$M$4","v":1.1122991031230518},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":1.7605512060529637E-3},"H1-H2","(I1+I2)/2","(H1-H2)/(Im-I0)",null,{"$f":"E12^2/$M$4/A12","v":1.0000000000000002},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":0.74153273541536791},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":48548.092728279466},{"$f":"$F$9+K12","v":0}]
[{"$f":"A12+$M$9","v":0.74077929960489786},7.4815585992097962,4.4446757976293867,{"$f":"C13/B13","v":0.59408420567591813},2.699859460255869,{"$f":"A13+E13^2/2/$M$4","v":1.1123002529755968},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":1.7660527746179084E-3},{"$f":"F12-F13","v":-1.1498525449571417E-6},{"$f":"(G12+G13)/2","v":1.7633019903354362E-3},{"$f":"IFERROR(H13/(I13-$F$6),0)","v":4.8578885246506843E-3},{"$f":"J13+K12","v":4.8578885246506843E-3},1.0030543606411608,0.74228668192513014,48548.142881451939,{"$f":"$F$9+K13","v":4.8578885246506843E-3}]
[0.74002586379442792,7.4800517275888563,4.4401551827665671,{"$f":"C14/B14","v":0.59359952905002444},2.7026082436431991,1.1123037087795542,{"$f":"$F$5^2*E14^2/D14^(4/3)","v":1.7715775480437463E-3},{"$f":"F13-F14","v":-3.4558039574417165E-6},{"$f":"(G13+G14)/2","v":1.7688151613308274E-3},{"$f":"IFERROR(H14/(I14-$F$6),0)","v":1.4948229206271606E-2},{"$f":"J14+K13","v":1.980611773092229E-2},1.006121172782527,0.74304165121978516,48548.293477180792,{"$f":"$F$9+K14","v":1.980611773092229E-2}]
[0.73927242798395798,7.4785448559679164,4.4356345679037474,0.59311465710660127,2.7053626299226727,1.1123094799402331,{"$f":"$F$5^2*E15^2/D15^(4/3)","v":1.777125648930403E-3},-5.7711606789023762E-6,{"$f":"(G14+G15)/2","v":1.7743515984870745E-3},2.5575898788592989E-2,{"$f":"J15+K14","v":4.5382016519515275E-2},1.0092004999390294,0.74379764538409465,48548.544720407903,4.5382016519515275E-2]
[0.73851899217348804,7.4770379843469765,4.4311139530409278,0.59262958972755964,2.7081226362424724,1.1123175759109436,1.7826972006547213E-3,-8.0959707104977241E-6,1.7799114247925621E-3,3.6785056665786076E-2,8.2167073185301351E-2,1.0122924060147807,0.74455466650991087,48548.896816911467,8.2167073185301351E-2]
[0.7377655563630181,7.4755311127260367,4.4265933381781082,0.59214432679471529,2.7108882798208307,1.1123280061932905,1.788292327376202E-3,-1.0430282346929332E-5,1.7854947640154617E-3,4.8624837986151311E-2,0.13079191117145267,1.015396955305863,0.74531271669621302,48549.349973310265,0.13079191117145267]
[0.73701212055254817,7.4740242411050968,4.4220727233152886,0.59165886818978908,2.7136595779463879,1.1123407803374701,1.7939111540427857E-3,-1.2774144179550362E-5,1.791101740709494E-3,6.1150074792082849E-2,0.19194198596353551,1.0185142125031346,0.74607179804913959,48549.904397067992,0.19194198596353551]
[0.73625868474207823,7.4725173694841569,4.4175521084524689,0.59117321379440591,2.7164365479785522,1.1123559079425691,1.7995538063966944E-3,-1.5127605099030106E-5,1.7967324802197399E-3,7.4422146319213331E-2,0.26636413228274886,1.0216442426950605,0.74683191268202265,48550.560296497541,0.26636413228274886]
[0.73550524893160829,7.471010497863217,4.4130314935896493,0.59068736349009543,2.7192192073478627,1.1123733986568651,{"$f":"$F$5^2*E20^2/D20^(4/3)","v":1.8052204109803105E-3},{"$f":"F19-F20","v":-1.7490714296020116E-5},{"$f":"(G19+G20)/2","v":1.8023871086885026E-3},8.8509986266277929E-2,0.35487411854902678,1.0247871113705682,0.74759306271542358,48551.317880765375,0.35487411854902678]
[0.73475181312113835,7.4695036262422772,4.4085108787268297,0.59020131715829194,2.7220075735563523,1.1123932621781281,1.8109110951421089E-3,-1.9863521262930561E-5,1.8080657530612097E-3,0.10349128193503283,0.4583654004840596,1.0279428844219216,0.74835525027716532,48552.177359895897,0.4583654004840596]
[0.73399837731066842,7.4679967546213373,4.40399026386401,0.58971507468033346,2.7248016641779174,1.1124155082539278,1.8166259870426482E-3,-2.2246075799703391E-5,1.8137685410923787E-3,0.11945390929219098,0.57781930977625062,1.0311116281476256,0.74911847750236882,48553.138944775863,0.57781930977625062]
[0.73324494150019848,7.4664898830003974,4.3994696490011904,0.58922863593746277,2.7276014968586848,1.1124401466819385,1.8223652156605988E-3,-2.4638428010703706E-5,1.8194956013516234E-3,0.13649765986423118,0.71431696964048186,1.03429340925535,0.74988274653348785,48554.202847158791,0.71431696964048186]
[0.73249150568972854,7.4649830113794575,4.3949490341383708,0.5887420008108265,2.7304070893173846,{"$f":"A24+E24^2/2/$M$4","v":1.1124671873102501},1.8281289107988314E-3,-2.7040628311603143E-5,1.8252470632297152E-3,0.154736331253468,0.86905330089394983,1.0374882948648774,{"$f":"A24/2*(SQRT(1+8*L24)-1)","v":0.75064805952034364},48555.369279669452,0.86905330089394983]
[0.7317380698792586,7.4634761397585176,4.3904284192755512,0.58825516918147536,2.7332184593457232,{"$f":"A25+E25^2/2/$M$4","v":1.112496640037679},1.8339172030905544E-3,-2.9452727428935788E-5,1.8310230569446929E-3,0.17430027373199508,1.0433535746259448,1.0406963525110782,0.75141441862016056,48556.638455808301,1.0433535746259448]
[0.73098463406878866,7.4619692681375778,4.3859078044127315,0.58776814093036378,2.7360356248087587,1.112528514814082,1.8397302240055035E-3,-3.187477640298475E-5,1.8368237135480288E-3,0.195339513455386,1.2386930880813307,1.043917650146907,0.75218182599760097,48558.010589956059,1.2386930880813307]
[0.73023119825831873,7.4604623965166379,4.3813871895499119,0.58728091593835041,2.7388586036452822,1.1125628216406727,1.8455681058561857E-3,-3.4306826590668749E-5,1.8426491649308446E-3,0.21802761056584768,1.4567206986471783,1.0471522561464277,0.75295028382480289,48559.48589737821,1.4567206986471783]
[0.72947776244784879,7.458955524895698,4.3768665746870923,0.5867934940861973,2.741687413868195,1.1125995705703398,1.8514309818041721E-3,-3.6748929667096419E-5,1.8484995438301788E-3,0.24256646214915339,1.6992871607963318,1.0504002393078589,0.75371979428141367,48561.064594229567,1.6992871607963318]
[0.72872432663737885,7.4574486532747581,4.3723459598242727,0.58630587525457012,2.7445220735648941,1.1126387717079673,1.8573189858664505E-3,-3.9201137627564719E-5,1.8543749838353112E-3,0.26919233151007338,1.9684794923064053,1.0536616688566469,0.75449035955462718,48562.746897558893,1.9684794923064053]
[0.72797089082690891,7.4559417816538183,4.367825344961453,0.58581805932403841,2.7473626008976564,1.1126804352107589,1.8632322529218244E-3,-4.1663502791555729E-5,1.8602756193941373E-3,0.29818348530798611,2.2666629776143914,1.0569366144485661,0.75526198183922089,48564.533025313525,2.2666629776143914]
[0.72721745501643897,7.4544349100328784,4.3633047300986334,0.58533004617507467,2.7502090141040267,1.1127245712885614,1.8691709187173761E-3,-4.4136077802514606E-5,1.8662015858196004E-3,0.32986996200871382,2.5965329396231054,1.0602251461728402,0.75603466333759073,48566.423196343982,2.5965329396231054]
[0.72646401920596904,7.4529280384119385,4.3587841152358138,0.58484183568805514,2.7530613314972103,1.112771190204195,1.8751351198749782E-3,-4.6618915633622748E-5,1.8721530192961772E-3,0.36464619951895938,2.9611791391420645,1.0635273345552962,0.7568084062597904,48568.417630408738,2.9611791391420645]
[0.7257105833954991,7.4514211667909986,4.3542635003729941,0.58435342774325894,2.7559195714664622,1.1128203022737808,1.8811249938978627E-3,-4.9112069585799389E-5,1.8781300568864205E-3,0.40298754829177397,3.3641666874338387,1.0668432505615368,0.75758321282356544,48570.516548178843,3.3641666874338387]
[0.72495714758502916,7.4499142951700588,4.3497428855101745,0.58386482222086866,2.7587837524774845,1.1128719178670756,1.887140679177246E-3,-5.1615593294807027E-5,1.8841328365375542E-3,0.44547214027153065,3.8096388277053692,1.0701729656001453,0.75835908525439322,48572.720171242734,3.8096388277053692]
[0.72420371177455922,7.4484074235491189,4.3452222706473549,0.58337601900096969,2.7616538930728232,1.1129260474078049,1.8931823149990114E-3,-5.4129540729253023E-5,1.8901614970881287E-3,0.49281025591439215,4.3024490836197611,1.0735165515259133,0.75913602578551787,48575.028722110954,4.3024490836197611]
[0.72345027596408928,7.446900551928179,4.3407016557845353,0.58288701796355058,2.7645300118722691,1.1129827013740021,1.8992500415504505E-3,-5.6653966197250938E-5,1.896216178274731E-3,0.54588437056425088,4.8483334541840115,1.0768740806430999,0.7599140366579904,48577.442424221008,4.8483334541840115]
[0.72269684015361935,7.4453936803072391,4.3361810409217156,0.58239781898850251,2.7674121275732606,1.1130418902983472,1.9053439999270616E-3,-5.9188924345088267E-5,1.902297020738756E-3,0.60580470311785906,5.4541381573018706,1.0802456257087123,0.76069312012070478,48579.961501942133,5.4541381573018706]
[0.72194340434314941,7.4438868086862993,4.331660426058896,0.58190842195561943,2.7703002589512864,1.1131036247685095,1.9114643321394014E-3,-6.1734470162333466E-5,1.9084041660332315E-3,0.67398775128496613,6.1281259085868367,1.0836312599358171,0.76147327843043622,48582.586180580212,6.1281259085868367]
[0.72118996853267947,7.4423799370653594,4.3271398111960764,0.58141882674459799,2.7731944248602978,1.1131679154274927,1.9176111811200071E-3,-6.4290658983168214E-5,1.9145377566297042E-3,0.75226973278253262,6.8803956413693692,1.087031056996882,0.76225451385188114,48585.316686382648,6.8803956413693692]
[0.72043653272220953,7.4408730654444195,4.3226191963332568,0.58092903323503753,2.7760946442331136,1.113234772973982,1.9237846907303631E-3,-6.6857546489274E-5,1.9206979359251851E-3,0.84307448071212143,7.7234701220814905,1.0904450910271375,0.76303682865769351,48588.153246543283,7.7234701220814905]
[0.71968309691173959,7.4393661938234796,4.3180985814704371,0.58043904130643964,2.7790009360818377,1.1133042081626943,1.9299850057679451E-3,-6.9435188712274609E-5,1.9268848482491541E-3,0.94966894069902874,8.6731390627805194,1.0938734366279761,0.76382022512852499,48591.096089207356,8.6731390627805194]
[0.71892966110126966,7.4378593222025398,4.3135779666076175,0.57994885083820824,2.7819133194982713,1.11337623180473,1.9362122719733111E-3,-7.2023642035734525E-5,1.9330986388706281E-3,1.0765646740199692,9.7497037368004893,1.0973161688703725,0.76460470555306337,48594.145443476475,9.7497037368004893]
[0.71817622529079972,7.4363524505815999,4.3090573517447979,0.57945846170964976,2.7848318136543324,1.1134508547679292,1.9424666360372586E-3,-7.4622963199155734E-5,1.9393394540052847E-3,1.2301729563340369,10.979876693134527,1.1007733632983383,0.76539027222807221,48597.30153941366,10.979876693134527]
[0.71742278948032978,7.43484557896066,4.3045367368819782,0.57896787379997239,2.7877564378024764,1.1135280879772285,1.9487482456080473E-3,-7.7233209299309991E-5,1.9456074408226529E-3,1.4199223288518354,12.399799021986363,1.1042450959324008,0.76617692745842969,48600.564608048371,12.399799021986363]
[0.71666935366985984,7.4333387073397201,4.3000161220191586,0.57847708698828681,2.7906872112761194,1.113607942415022,1.9550572492986781E-3,-7.9854437793569488E-5,1.9519027474533628E-3,1.660270255897446,14.060069277883809,1.1077314432731153,0.76696467355716935,48603.93488138161,14.060069277883809]
[0.71591591785938991,7.4318318357187803,4.295495507156339,0.57798610115360527,2.7936241534900637,1.1136904291215242,1.9613937966942406E-3,-8.2486706502127305E-5,1.9582255229964596E-3,1.9745718538890722,16.034641131772879,1.1112324823046036,0.76775351284551874,48607.412592391011,16.034641131772879]
[0.71516248204891997,7.4303249640978404,4.2909748922935194,0.57749491617484217,2.7965672839409272,1.1137755591951348,1.9677580383593222E-3,-8.5130073610661938E-5,1.9645759175267816E-3,2.4031694730561517,18.437810604829032,1.1147482904981252,0.76854344765294014,48610.997975035963,18.437810604829032]
[0.71440904623845003,7.4288180924769005,4.2864542774306997,0.57700353193081344,2.799516622207574,1.113863343792808,1.974150125845479E-3,-8.7784597673223885E-5,1.9709540821024009E-3,3.0222697035331008,21.460080308362134,1.1182789458156754,0.76933448031717122,48614.691264262859,21.460080308362134]
[0.71365561042798009,7.4273112208559606,4.2819336625678801,0.57651194830023678,2.8024721879515497,1.1139537941304238,1.9805702116987775E-3,-9.0450337615788357E-5,1.9773601687721283E-3,3.99518603762538,25.455266345987514,1.1218245267136189,0.77012661318426534,48618.492696010246,25.455266345987514]
[0.71290217461751015,7.4258043492350208,4.2774130477050605,0.57602016516173149,2.8054340009175176,1.114046921483161,1.9870184494674E-3,-9.3127352737143454E-5,1.9837943305830888E-3,5.7465909208268391,31.201857266814354,1.1253851121463474,0.77091984860863239,48622.402507214065,31.201857266814354]
[0.71214873880704022,7.4242974776140809,4.2728924328422409,0.5755281823938182,2.808402080933698,1.1141427371858743,1.9934949937093116E-3,-9.5815702713331063E-5,1.9902567215883561E-3,9.8340310791923695,41.035888346006722,1.1289607815699751,0.77171418895308019,48626.420935812974,41.035888346006722]
[0.71139530299657028,7.422790605993141,4.2683718179794212,0.57503599987491893,2.8113764479123113,1.1142412526334737,1.9999999999999992E-3,-9.8515447599423211E-5,1.9967474968546556E-3,30.289116780851199,71.325005126857917,1.1325516149460593,0.77250963658885519,48630.548220753612,71.325005126857917]

{"sheet":"CRemRectRedIzq","index":4,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":"Curva S2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pend.","Curvas",null,null,"Limites",null,"x","yc","yu","yucong"]
["Ancho del canal rectángular",null,null,null,"b",{"$f":"Principal!F40","v":6},"m",null,"Densidad del agua",null,null,"ro",1000,"kg/m3",null,null,null,"Suave","S1","S2","S3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S6:U6),LOOKUP(M8,S5:U5,S8:U8))","v":0.89269987749321777},null,{"$f":"O12","v":0},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777},{"$f":"M6/2*(SQRT(1+8*F4^2/M4/M6^3/F3^2)-1)","v":0.60851635250899305}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!F41","v":12},"m3/s",null,"Gravedad de la tierra",null,null,"g",9.81,"m/s",null,null,null,"Crítica","F1","F2","F3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S7:U7),LOOKUP(M8,S5:U5,S9:U9))","v":-1},null,{"$f":"O17","v":-312.58737082850803},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777},{"$f":"AA3","v":0.60851635250899305}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!F42","v":1.0999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":0.74153273541536779},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!F43","v":1E-3},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":0.89269987749321777},"m",null,null,null,"Suave",{"$f":"M6","v":0.89269987749321777},{"$f":"M6","v":0.89269987749321777},{"$f":"M5","v":0.74153273541536779}]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"Principal!F44","v":0.74153273541536779},"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":"Suave"},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!F45","v":0.89269987749321777},"m",null,"Tipo de curva de remanso",null,null,"Curva",{"$f":"IF(M7=R3,IF(F7>M6,S3,IF(F7<M5,U3,T3)),IF(M7=R5,IF(F7>M5,S5,IF(F7<M6,U5,T5)),\"No hay\"))","v":"S2"},"-",null,null,null,"Fuerte",{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.89269987749321777},{"$f":"M6","v":0.89269987749321777}]
["Coordenada x para inicio de la curva",null,null,null,"xini",0,"m",null,"Incremento del intervalo en Y",null,null,"Incy",{"$f":"(F8-F7)/5","v":3.0233428415569995E-2},"m",null,null,null,"signo",1,1,-1]
["Calado","Perímetro mojado","Superficie mojada","Radio hidráulico","velocidad","Energía específica","Pendiente de pérdidas","Incremento energía específica","Pendiente de pérdidas media","Incremento en x","X acumulada","Número de Froude al cuadrado","Calado conjugado","Impulsión","x para dibujo"]
["y","p","S","Rh","v","H","I","DH","Im","Dx","x","F2","ycong","N","Xdib"]
[{"$f":"F7","v":0.74153273541536779},{"$f":"$F$3+2*A12","v":7.483065470830736},{"$f":"$F$3*A12","v":4.4491964124922063},{"$f":"C12/B12","v":0.59456868710227606},{"$f":"$F$4/C12","v":2.6971162626821927},{"$f":"A12+E12^2/2/$M$4","v":1.1122991031230518},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":1.7605512060529637E-3},"H1-H2","(I1+I2)/2","DH/(Im-I0)",0,{"$f":"E12^2/$M$4/A12","v":1.0000000000000002},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":0.74153273541536791},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":48548.092728279466},{"$f":"$F$9+K12","v":0},null,"y",{"$f":"TRANSPOSE(A12:A17)","v":0.74153273541536779},0.77176616383093777,0.80199959224650774,0.83223302066207772,0.86246644907764769,0.89269987749321766]
[{"$f":"A12+$M$9","v":0.77176616383093777},{"$f":"$F$3+2*A13","v":7.5435323276618753},{"$f":"$F$3*A13","v":4.6305969829856268},{"$f":"C13/B13","v":0.61384995541218612},{"$f":"$F$4/C13","v":2.5914585190834014},{"$f":"A13+E13^2/2/$M$4","v":1.1140524663859803},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":1.5576059181298444E-3},{"$f":"F12-F13","v":-1.7533632629285201E-3},{"$f":"(G12+G13)/2","v":1.659078562091404E-3},{"$f":"H13/(I13-$F$6)","v":-2.6603251323555499},{"$f":"J13","v":-2.6603251323555499},0.88702075472182396,0.71209947692948106,48626.687461398906,{"$f":"$F$9+K13","v":-2.6603251323555499},null,"x",{"$f":"TRANSPOSE(O12:O17)","v":0},-2.6603251323555499,-13.084806363813069,-37.581918563297506,-94.913778750415091,-312.58737082850803]
[0.80199959224650774,7.6039991844930155,4.8119975534790465,0.63282457516463797,2.4937668539178848,1.1189656025268087,1.3850090728209129E-3,{"$f":"F13-F14","v":-4.9131361408283336E-3},{"$f":"(G13+G14)/2","v":1.4713074954753786E-3},{"$f":"H14/(I14-$F$6)","v":-10.424481231457518},{"$f":"J14+K13","v":-13.084806363813069},0.79043933025561008,0.68418557075841679,48854.67671872233,{"$f":"$F$9+K14","v":-13.084806363813069}]
[0.83223302066207772,7.6644660413241557,4.9933981239724661,0.65149980403720065,2.4031730901627921,1.1265878066601707,1.2372850221967378E-3,-7.6222041333620094E-3,1.3111470475088254E-3,-24.497112199484437,{"$f":"J15+K14","v":-37.581918563297506},0.70738550067124439,0.65768051004115935,49221.642375975513,-37.581918563297506]
[0.86246644907764769,7.7249328981552949,5.1747986944658866,0.6698826724697664,2.318930785236772,1.1365459591040916,1.110101314524935E-3,-9.9581524439209534E-3,1.1736931683608365E-3,-57.331860187117584,-94.913778750415091,0.63557141340293155,0.63248648527948459,49718.627122182239,-94.913778750415091]
[{"$f":"A16+$M$9","v":0.89269987749321766},7.7853997549864351,5.3561992649593062,0.68797999248898412,2.2403946168517259,1.1485290334166729,1.0000000000000002E-3,-1.1983074312581277E-2,1.0550506572624676E-3,-217.67359207809292,-312.58737082850803,0.57315826376462997,0.60851635250899316,50337.887089885335,-312.58737082850803]

{"sheet":"CRemRectRedDer","index":5,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":"Curva F2"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pend.","Curvas",null,null,"Limites",null,"x","yc","yu","yucong"]
["Ancho del canal rectángular",null,null,null,"b",{"$f":"Principal!G40","v":6},"m",null,"Densidad del agua",null,null,"ro",1000,"kg/m3",null,null,null,"Suave","S1","S2","S3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S6:U6),LOOKUP(M8,S5:U5,S8:U8))","v":0.71139530299656961},null,{"$f":"O12","v":0},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961},{"$f":"M6/2*(SQRT(1+8*F4^2/M4/M6^3/F3^2)-1)","v":0.77250963658885563}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!G41","v":12},"m3/s",null,"Gravedad de la tierra",null,null,"g",9.81,"m/s",null,null,null,"Crítica","F1","F2","F3",{"$f":"IFERROR(LOOKUP(M8,S3:U3,S7:U7),LOOKUP(M8,S5:U5,S9:U9))","v":1},null,{"$f":"O17","v":0},{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961},{"$f":"AA3","v":0.77250963658885563}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!G42","v":1.0999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":0.74153273541536779},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!G43","v":2E-3},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":0.71139530299656961},"m",null,null,null,"Suave",{"$f":"M6","v":0.71139530299656961},{"$f":"M6","v":0.71139530299656961},{"$f":"M5","v":0.74153273541536779}]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"Principal!G44","v":0.74153273541536779},"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":"Fuerte"},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!G45","v":0.71139530299656961},"m",null,"Tipo de curva de remanso",null,null,"Curva",{"$f":"IF(M7=R3,IF(F7>M6,S3,IF(F7<M5,U3,T3)),IF(M7=R5,IF(F7>M5,S5,IF(F7<M6,U5,T5)),\"No hay\"))","v":"F2"},"-",null,null,null,"Fuerte",{"$f":"M5","v":0.74153273541536779},{"$f":"M6","v":0.71139530299656961},{"$f":"M6","v":0.71139530299656961}]
["Coordenada x para inicio de la curva",null,null,null,"xini",0,"m",null,"Incremento del intervalo en Y",null,null,"Incy",{"$f":"(F8-F7)/5","v":-6.0274864837596368E-3},"m",null,null,null,"signo",1,1,-1]
["Calado","Perímetro mojado","Superficie mojada","Radio hidráulico","velocidad","Energía específica","Pendiente de pérdidas","Incremento energía específica","Pendiente de pérdidas media","Incremento en x","X acumulada","Número de Froude al cuadrado","Calado conjugado","Impulsión","x para dibujo"]
["y","p","S","Rh","v","H","I","DH","Im","Dx","x","F2","ycong","N","Xdib"]
[{"$f":"F7","v":0.74153273541536779},{"$f":"$F$3+2*A12","v":7.483065470830736},{"$f":"$F$3*A12","v":4.4491964124922063},{"$f":"C12/B12","v":0.59456868710227606},{"$f":"$F$4/C12","v":2.6971162626821927},{"$f":"A12+E12^2/2/$M$4","v":1.1122991031230518},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":1.7605512060529637E-3},"H1-H2","(I1+I2)/2","DH/(Im-I0)",0,{"$f":"E12^2/$M$4/A12","v":1.0000000000000002},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":0.74153273541536791},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":48548.092728279466},{"$f":"$F$9+K12","v":0},null,"y",{"$f":"TRANSPOSE(A12:A17)","v":0.74153273541536779},0.73550524893160818,0.72947776244784857,0.72345027596408895,0.71742278948032934,0.71139530299656972]
[{"$f":"A12+$M$9","v":0.73550524893160818},{"$f":"$F$3+2*A13","v":7.4710104978632161},{"$f":"$F$3*A13","v":4.4130314935896493},{"$f":"C13/B13","v":0.59068736349009554},{"$f":"$F$4/C13","v":2.7192192073478627},{"$f":"A13+E13^2/2/$M$4","v":1.1123733986568649},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":1.8052204109803099E-3},{"$f":"F12-F13","v":-7.4295533813106829E-5},{"$f":"(G12+G13)/2","v":1.7828858085166368E-3},{"$f":"H13/(I13-$F$6)","v":0.34219565890882747},0,{"$f":"E13^2/$M$4/A13","v":1.0247871113705684},{"$f":"A13/2*(SQRT(1+8*L13)-1)","v":0.7475930627154237},{"$f":"$M$3*$F$4*E13+$F$3*$M$3*$M$4*A13^2/2","v":48551.317880765368},{"$f":"$F$9+K13","v":0},null,"x",{"$f":"TRANSPOSE(O12:O17)","v":0},0,0,0,0,0]
[0.72947776244784857,7.4589555248956971,4.3768665746870914,0.58679349408619719,2.7416874138681959,1.1125995705703398,1.851430981804174E-3,{"$f":"F13-F14","v":-2.2617191347484855E-4},{"$f":"(G13+G14)/2","v":1.8283256963922421E-3},{"$f":"H14/(I14-$F$6)","v":1.3174476827446866},0,1.0504002393078598,0.75371979428141378,48561.064594229567,0]
[0.72345027596408895,7.4469005519281781,4.3407016557845335,0.58288701796355047,2.7645300118722704,1.1129827013740021,1.8992500415504529E-3,-3.8313080366236818E-4,1.8753405116773134E-3,3.0734187089763849,0,1.0768740806431014,0.75991403665799062,48577.442424221008,0]
[0.71742278948032934,7.4348455789606582,4.3045367368819765,0.57896787379997228,2.7877564378024777,1.1135280879772285,1.9487482456080495E-3,-5.4538660322633881E-4,1.9239991435792512E-3,7.1760586513265077,0,1.1042450959324026,0.76617692745843002,48600.564608048371,0]
[{"$f":"A16+$M$9","v":0.71139530299656972},7.4227906059931392,4.2683718179794186,0.57503599987491871,2.8113764479123131,1.1142412526334735,2.0000000000000031E-3,-7.1316465624504666E-4,1.9743741228040262E-3,27.829863180531159,0,1.1325516149460615,0.77250963658885552,48630.548220753612,0]