{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Alumno","CRemanso_Rect_Red"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":10,"comments":2,"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":"Alumno","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Curva de remanso para canal rectangular"]
[]
["Ancho del canal rectángular",null,null,null,"b",0.5,"m",null,"Calado Y al comienzo de la curva",null,null,"yini",4,"m"]
["Caudal circulante por el canal",null,null,null,"Q",20,"m3/s",null,"Calado Y al final de la curva",null,null,"yfin",3.7,"m"]
["Número de Manning",null,null,null,"n",1.4999999999999999E-2]
["Pendiente geométrica canal",null,null,null,"I0",0.2,"-"]
["Densidad del agua",null,null,null,"ro",1000,"kg/m3"]
["Gravedad de la tierra",null,null,null,"g",9.81,"m/s",null,"Incremento del intervalo en Y",null,null,"Incy",null,"m"]
[]
["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"]
["y","p","S","Rh","v","H","I","DH","Im","Dx","x","F2","ycong","N"]
[null,null,null,null,null,null,null,"H2-H1","(I1+I2)/2","DH/(I0-Im)"]

{"sheet":"CRemanso_Rect_Red","index":1,"n_rows":25,"n_cols":27,"rows_kept":25,"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",0.5,"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":33.972880616442787},null,{"$f":"O12","v":200},{"$f":"M5","v":5.4636599090863642},{"$f":"M6","v":33.972880616442787},{"$f":"M6/2*(SQRT(1+8*F4^2/M4/M6^3/F3)-1)","v":0.14073136399841715}]
["Caudal circulante por el canal",null,null,null,"Q",20,"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":191.61143501322778},{"$f":"M5","v":5.4636599090863642},{"$f":"M6","v":33.972880616442787},{"$f":"AA3","v":0.14073136399841715}]
["Número de Manning",null,null,null,"n",1.4999999999999999E-2,null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":5.4636599090863642},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",2E-3,"-",null,"Calado uniforme",null,null,"yu",{"$f":"[1]!yuniforme(F4,F3,F5,F6)","v":33.972880616442787},"m",null,null,null,"Suave",{"$f":"M6","v":33.972880616442787},{"$f":"M6","v":33.972880616442787},{"$f":"M5","v":5.4636599090863642}]
["Calado Y al comienzo de la curva",null,null,null,"yini",5.47,"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",7,"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":5.4636599090863642},{"$f":"M6","v":33.972880616442787},{"$f":"M6","v":33.972880616442787}]
["Coordenada x para inicio de la curva",null,null,null,"xini",200,"m",null,"Incremento del intervalo en Y",null,null,"Incy",{"$f":"(F8-F7)/5","v":0.30600000000000005},"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":5.47},{"$f":"$F$3+2*A12","v":11.44},{"$f":"$F$3*A12","v":2.7349999999999999},{"$f":"C12/B12","v":0.23907342657342656},{"$f":"$F$4/C12","v":7.3126142595978063},{"$f":"A12+E12^2/2/$M$4","v":8.1955008822463391},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":8.1087287562932903E-2},"H2-H1","(I1+I2)/2","DH/(I0-Im)",null,{"$f":"E12^2/$M$4/A12","v":0.99652683080304905},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":5.4573247191227656},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":219633.29244195612},{"$f":"$F$9+K12","v":200},null,null,"Para utilizar este libro correctamente es necesario tener habilitadas las macros de Visual Basic"]
[{"$f":"A12+$M$9","v":5.7759999999999998},12.052,2.8879999999999999,{"$f":"C13/B13","v":0.23962827746432128},6.9252077562326875,8.2203681175833516,{"$f":"$F$5^2*E13^2/D13^(4/3)","v":7.2498782014468188E-2},{"$f":"F13-F12","v":2.4867235337012517E-2},{"$f":"(G12+G13)/2","v":7.6793034788700545E-2},{"$f":"H13/($F$6-I13)","v":-0.33248063014511303},{"$f":"J13","v":-0.33248063014511303},0.8463878523488062,5.1627903331688971,220324.89176465373,{"$f":"$F$9+K13","v":199.66751936985489}]
[6.0819999999999999,12.664,3.0409999999999999,{"$f":"C14/B14","v":0.24012950094756791},6.5767839526471557,8.2865915983586724,{"$f":"$F$5^2*E14^2/D14^(4/3)","v":6.5205212025851514E-2},{"$f":"F14-F13","v":6.6223480775320809E-2},{"$f":"(G13+G14)/2","v":6.8851997020159844E-2},{"$f":"H14/($F$6-I14)","v":-0.99059839237637881},{"$f":"J14+K13","v":-1.3230790225214919},0.72495613231130274,4.8887531742715531,222255.42966294312,{"$f":"$F$9+K14","v":198.67692097747852},null,null,"Excel 2010:"]
[6.3879999999999999,13.276,3.194,0.24058451340765291,6.261740763932373,8.3864402341841178,{"$f":"$F$5^2*E15^2/D15^(4/3)","v":5.8958866895011973E-2},9.9848635825445342E-2,{"$f":"(G14+G15)/2","v":6.208203946043174E-2},{"$f":"H15/($F$6-I15)","v":-1.6618716129169135},{"$f":"J15+K14","v":-2.9849506354384054},0.62568573393366222,4.6332460587279707,225312.86443864746,197.01504936456161,null,null,null,"Archivo",null,"Opciones",null,"Centro de Confianza"]
[6.694,13.888,3.347,0.24099942396313365,5.975500448162534,8.513908542609105,5.3568532035908445E-2,0.12746830842498724,5.6263699465460212E-2,-2.3490530443123037,-5.3340036797507091,0.54374321559877659,4.3945941599196088,229405.64125325068,194.66599632024929,null,null,null,"Botón de configuración del centro de confianza"]
[{"$f":"A16+$M$9","v":7},14.5,3.5,0.2413793103448276,5.7142857142857144,8.6642742724000907,4.8884708660450117E-2,0.15036572979098572,5.1226620348179278E-2,-3.0545613070215012,-8.3885649867722094,0.47550693497145469,4.1713544845224408,234458.21428571429,191.61143501322778,null,null,null,"Deshabilitar todas las macros con notificación",null,null,null,null,"(Habilitarlas al abrir este libro)"]
[]
[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"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel 2013:"]
[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"]
[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,"Configuración de macros"]
[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)"]