{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Principal","CurvaRemanso F2","CurvaRemansoS1"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":3,"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":"Principal","index":0,"n_rows":94,"n_cols":27,"rows_kept":94,"cut":false,"hidden":false,"merged":[[7,0,7,9],[0,1,0,8],[0,11,0,18],[3,18,3,19],[3,8,3,9],[5,7,5,9]]}
[null,"Estudio de una obra de toma",null,null,null,null,null,null,null,null,null,{"$f":"B1","v":"Estudio de una obra de toma"},null,null,null,null,null,null,null,null,"Para utilizar este libro correctamente es necesario tener habilitadas las macros de Visual Basic"]
[]
["Tema:","Canales: Curvas de Köch",null,null,null,null,null,null,null,null,"Tema:",{"$f":"B3","v":"Canales: Curvas de Köch"},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,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)"]
[]
[{"$f":"\"Un canal rectangular indefinido, de b=\" & G17 & \" m de ancho con pendiente I0=\" & G18 & \" conecta con un depósito con un vertedero a la cota \" & G20 & \" m cuyo nivel de agua se sitúa a la cota \" & G21 & \" m. Suponiendo un número de Manning n=\" & G19 & \". Calcular:\"","v":"Un canal rectangular indefinido, de b=6 m de ancho con pendiente I0=0,0003 conecta con un depósito con un vertedero a la cota 199 m cuyo nivel de agua se sitúa a la cota 200 m. Suponiendo un número de Manning n=0,015. Calcular:"}]
["1.- Energía espécifica"]
["2.- Calado crítico correspondiente a esa curva de energía específica"]
["3.- Curva de los calados uniformes asociados a los distintos caudales de salida"]
["4.- Cuadal de salida y calado uniforme asociado en el canal"]
["5.- Integrar la curva de remanso, en caso de existir"]
[]
["Datos del problema"]
[]
["Ancho del canal ",null,null,null,null,"b",6,"m"]
["Pendiente del canal",null,null,null,null,"I0",2.9999999999999997E-4,"-"]
["Nº de Manning",null,null,null,null,"n",1.4999999999999999E-2]
["Cota del labio del vertedero",null,null,null,null,"zv",199,"m"]
["Cota de la lámina de agua en el depósito",null,null,null,null,"z0",200,"m"]
["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"]
[]
["Energía específica constante en toda la curva",null,null,null,null,"Hº",{"$f":"G21-G20","v":1},"m"]
["Calado crítico en el canal",null,null,null,null,"yc",{"$f":"2/3*G29","v":0.66666666666666663},"m"]
["Caudal máximo de salida",null,null,null,null,"Qyc",{"$f":"SQRT((G29-G30)*2*G23)*G17*G30","v":10.229369482035539},"m3/s"]
["Solución de la ecuación no lineal del corte",null,null,null,null,"ycorte",{"$f":"miykoch(G29,G17,G19,G18)","v":{"$error":"#NAME?"}},"m"]
["Caudal correspondiente al punto de corte",null,null,null,null,"Qcorte",{"$f":"SQRT((G29-G32)*2*G23)*G17*G32","v":{"$error":"#NAME?"}},"m3/s"]
["Tipo de régimen en el canal",null,null,null,null,"Régimen",{"$f":"IF(G32<G30,\"Rápido\",\"Lento\")","v":{"$error":"#NAME?"}},"-"]
["Calado de salida por el vertedero",null,null,null,null,"ysal",{"$f":"MAX(G30,G32)","v":{"$error":"#NAME?"}},"m"]
["Caudal de salida por el vertedero",null,null,null,null,"Qsal",{"$f":"IF(G32<G30,G31,G33)","v":{"$error":"#NAME?"}},"m3/s"]
["Pendiente del canal para el caudal de salida",null,null,null,null,"Pendiente",{"$f":"IF(G34=\"Rápido\",\"Fuerte\",\"Suave\")","v":{"$error":"#NAME?"}},"-"]
["Calado unitario en el canal",null,null,null,null,"q",{"$f":"G36/G17","v":{"$error":"#NAME?"}},"m3/(s·m)"]
["Calado crítico en el canal",null,null,null,null,"yc",{"$f":"(G38^2/G23)^(1/3)","v":{"$error":"#NAME?"}},"m"]
["Calado uniforme en el canal",null,null,null,null,"yu",{"$f":"miyuniforme(G36,G17,G19,G18)","v":{"$error":"#NAME?"}},"m"]
["Velocidad para calado uniforme",null,null,null,null,"v",{"$f":"G36/G17/G40","v":{"$error":"#NAME?"}},"m"]
["Número de froude al cuadrado ",null,null,null,null,"F2",{"$f":"G41^2/G23/G40","v":{"$error":"#NAME?"}},"-"]
["Número de Froude",null,null,null,null,"F",{"$f":"SQRT(G42)","v":{"$error":"#NAME?"}},"-"]
["Curva de remanso para alcanzar el uniforme",null,null,null,null,"tipo",{"$f":"IF(G32<G30,\"F2\",\"No hay\")","v":{"$error":"#NAME?"}}]
["Incremento de calado en la curva de Köch",null,null,null,null,"Dy",{"$f":"G29/40","v":2.5000000000000001E-2},"m"]
[]
["Datos para el gráfico"]
[]
["Curva de Koch",null,null,"Cuva remanso F2",null,{"$f":"IF(G44=\"F2\",G44,\"\")","v":{"$error":"#NAME?"}},"Solución del corte"]
["y","Q (Köch)","Q (unifor.)","x","y","Cota y","x","yu1=","yu1="]
[{"$f":"0","v":0},{"$f":"SQRT(($G$29-A51)*2*$G$23)*$G$17*A51","v":0},{"$f":"SQRT($G$18)/$G$19*($G$17*A51)^(5/3)/($G$17+2*A51)^(2/3)","v":0},{"$f":"'CurvaRemanso F2'!K12","v":0},{"$f":"'CurvaRemanso F2'!A12","v":{"$error":"#NAME?"}},{"$f":"E51-D51*$G$18+$G$20","v":{"$error":"#NAME?"}},0,{"$f":"G32","v":{"$error":"#NAME?"}},{"$f":"G32+G20","v":{"$error":"#NAME?"}}]
[{"$f":"A51+$G$45","v":2.5000000000000001E-2},{"$f":"SQRT(($G$29-A52)*2*$G$23)*$G$17*A52","v":0.65605925799427611},{"$f":"SQRT($G$18)/$G$19*($G$17*A52)^(5/3)/($G$17+2*A52)^(2/3)","v":1.4727121968915761E-2},{"$f":"'CurvaRemanso F2'!K13","v":0},{"$f":"'CurvaRemanso F2'!A13","v":{"$error":"#NAME?"}},{"$f":"E52-D52*$G$18+$G$20","v":{"$error":"#NAME?"}},{"$f":"G33","v":{"$error":"#NAME?"}},{"$f":"G32","v":{"$error":"#NAME?"}},{"$f":"I51","v":{"$error":"#NAME?"}}]
[0.05,1.295187245150291,4.6499851880002982E-2,{"$f":"'CurvaRemanso F2'!K14","v":0},{"$f":"'CurvaRemanso F2'!A14","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"G33","v":{"$error":"#NAME?"}},0,{"$f":"G20","v":199}]
[7.5000000000000011E-2,1.9170475346219251,9.0902008831843226E-2,{"$f":"'CurvaRemanso F2'!K15","v":0},{"$f":"'CurvaRemanso F2'!A15","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},"Régimen crítico"]
[0.1,2.5212853864646103,0.14603613351219585,{"$f":"'CurvaRemanso F2'!K16","v":0},{"$f":"'CurvaRemanso F2'!A16","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},"x","yc1=","yc1="]
[0.125,3.1075261463099553,0.21069365756459893,{"$f":"'CurvaRemanso F2'!K17","v":0},{"$f":"'CurvaRemanso F2'!A17","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},0,{"$f":"G30","v":0.66666666666666663},{"$f":"H56+$G$20","v":199.66666666666666}]
[0.15,3.6753734504128968,0.2839966285666804,{"$f":"'CurvaRemanso F2'!K18","v":0},{"$f":"'CurvaRemanso F2'!A18","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"G31","v":10.229369482035539},{"$f":"G30","v":0.66666666666666663},{"$f":"H57+$G$20","v":199.66666666666666}]
[0.17499999999999999,4.2244072069344831,0.36526022577584172,{"$f":"'CurvaRemanso F2'!K19","v":0},{"$f":"'CurvaRemanso F2'!A19","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"G31","v":10.229369482035539},0,199]
[0.19999999999999998,4.7541813175351235,0.45392572482687055,{"$f":"'CurvaRemanso F2'!K20","v":0},{"$f":"'CurvaRemanso F2'!A20","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.22499999999999998,5.2642210962306661,0.54952295579241661,{"$f":"'CurvaRemanso F2'!K21","v":0},{"$f":"'CurvaRemanso F2'!A21","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Contorno"]
[0.24999999999999997,5.7540203336449887,0.65164724318563472,{"$f":"'CurvaRemanso F2'!K22","v":0},{"$f":"'CurvaRemanso F2'!A22","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"x","y"]
[0.27499999999999997,6.223037943802046,0.75994426517670433,{"$f":"'CurvaRemanso F2'!K23","v":0},{"$f":"'CurvaRemanso F2'!A23","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"-H65/5","v":-4},{"$f":"G20-G21+G20","v":198}]
[0.3,6.670694116806736,0.87409959654775582,{"$f":"'CurvaRemanso F2'!K24","v":0},{"$f":"'CurvaRemanso F2'!A24","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,0,{"$f":"I62","v":198}]
[0.32500000000000001,7.0963658833236618,0.99383119310948642,{"$f":"'CurvaRemanso F2'!K25","v":0},{"$f":"'CurvaRemanso F2'!A25","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,0,{"$f":"G20","v":199}]
[0.35000000000000003,7.499381974536302,1.1188838133772152,{"$f":"'CurvaRemanso F2'!K26","v":0},{"$f":"'CurvaRemanso F2'!A26","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"MAX(D91,20)","v":20},{"$f":"-H65*G18+G20","v":198.994}]
[0.37500000000000006,7.8790168327019092,1.2490247664834073,{"$f":"'CurvaRemanso F2'!K27","v":0},{"$f":"'CurvaRemanso F2'!A27","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.40000000000000008,8.2344835903655813,1.3840405976965324,{"$f":"'CurvaRemanso F2'!K28","v":0},{"$f":"'CurvaRemanso F2'!A28","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Agua depósito"]
[0.4250000000000001,8.5649257877695604,1.5237344550566003,{"$f":"'CurvaRemanso F2'!K29","v":0},{"$f":"'CurvaRemanso F2'!A29","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"x","y"]
[0.45000000000000012,8.869407533764587,1.6679239624576054,{"$f":"'CurvaRemanso F2'!K30","v":0},{"$f":"'CurvaRemanso F2'!A30","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"H62","v":-4},{"$f":"G21","v":200}]
[0.47500000000000014,9.1469017295475545,1.816439476978009,{"$f":"'CurvaRemanso F2'!K31","v":0},{"$f":"'CurvaRemanso F2'!A31","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"0.8*$H$62","v":-3.2},{"$f":"I69","v":200}]
[0.50000000000000011,9.3962758580194965,1.9691226429427755,{"$f":"'CurvaRemanso F2'!K32","v":0},{"$f":"'CurvaRemanso F2'!A32","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"0.7*$H$62","v":-2.8},{"$f":"I70-0.05*$K$75","v":{"$error":"#NAME?"}}]
[0.52500000000000013,9.6162746814969893,2.1258251787372466,{"$f":"'CurvaRemanso F2'!K33","v":0},{"$f":"'CurvaRemanso F2'!A33","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"0.5*$H$62","v":-2},{"$f":"I71-0.1*$K$75","v":{"$error":"#NAME?"}}]
[0.55000000000000016,9.8054989674161916,2.2864078487406476,{"$f":"'CurvaRemanso F2'!K34","v":0},{"$f":"'CurvaRemanso F2'!A34","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"0.4*$H$62","v":-1.6},{"$f":"I72-0.1*$K$75","v":{"$error":"#NAME?"}}]
[0.57500000000000018,9.9623790456898398,2.4507395843371551,{"$f":"'CurvaRemanso F2'!K35","v":0},{"$f":"'CurvaRemanso F2'!A35","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"0.2*$H$62","v":-0.8},{"$f":"(I70+I75)/2","v":{"$error":"#NAME?"}}]
[0.6000000000000002,10.085141545858443,2.6186967263321335,{"$f":"'CurvaRemanso F2'!K36","v":0},{"$f":"'CurvaRemanso F2'!A36","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,0,{"$f":"MAX(G39:G40)+G20","v":{"$error":"#NAME?"}},null,{"$f":"I69-I75","v":{"$error":"#NAME?"}}]
[0.62500000000000022,10.171766992514133,2.7901623672457316,{"$f":"'CurvaRemanso F2'!K37","v":0},{"$f":"'CurvaRemanso F2'!A37","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Régimen crítico"]
[0.65000000000000024,10.219934931299711,2.965025776535156,{"$f":"'CurvaRemanso F2'!K38","v":0},{"$f":"'CurvaRemanso F2'!A38","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"x",{"$f":"\"yc=\"& TEXT(G39,\"0.000\")","v":{"$error":"#NAME?"}}]
[0.67500000000000027,10.226951708598218,3.1431818952558519,{"$f":"'CurvaRemanso F2'!K39","v":0},{"$f":"'CurvaRemanso F2'!A39","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,0,{"$f":"G39+$G$20","v":{"$error":"#NAME?"}}]
[0.70000000000000029,10.189653576054488,3.3245308893173857,{"$f":"'CurvaRemanso F2'!K40","v":0},{"$f":"'CurvaRemanso F2'!A40","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"H65","v":20},{"$f":"I65+G39","v":{"$error":"#NAME?"}}]
[0.72500000000000031,10.104273786373762,3.5089777525361869,{"$f":"'CurvaRemanso F2'!K41","v":0},{"$f":"'CurvaRemanso F2'!A41","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"Régimen uniforme"]
[0.75000000000000033,9.9662555656575442,3.6964319522870106,{"$f":"'CurvaRemanso F2'!K42","v":0},{"$f":"'CurvaRemanso F2'!A42","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,"x",{"$f":"\"yu=\"& TEXT(G40,\"0.000\")","v":{"$error":"#NAME?"}}]
[0.77500000000000036,9.769980872550363,3.886807111817514,{"$f":"'CurvaRemanso F2'!K43","v":0},{"$f":"'CurvaRemanso F2'!A43","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,0,{"$f":"G40+$G$20","v":{"$error":"#NAME?"}}]
[0.80000000000000038,9.5083626350702417,4.080020724295836,{"$f":"'CurvaRemanso F2'!K44","v":0},{"$f":"'CurvaRemanso F2'!A44","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},null,{"$f":"H65","v":20},{"$f":"I65+G40","v":{"$error":"#NAME?"}}]
[0.8250000000000004,9.1722044106092575,4.2759938944684199,{"$f":"'CurvaRemanso F2'!K45","v":0},{"$f":"'CurvaRemanso F2'!A45","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.85000000000000042,8.7491388147634197,4.4746511044587143,{"$f":"'CurvaRemanso F2'!K46","v":0},{"$f":"'CurvaRemanso F2'!A46","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.87500000000000044,8.2217413757670474,4.6759200007699855,{"$f":"'CurvaRemanso F2'!K47","v":0},{"$f":"'CurvaRemanso F2'!A47","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.90000000000000047,7.5638561593938176,4.8797311999925181,{"$f":"'CurvaRemanso F2'!K48","v":0},{"$f":"'CurvaRemanso F2'!A48","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.92500000000000049,6.7324496841788397,5.0860181110764531,{"$f":"'CurvaRemanso F2'!K49","v":0},{"$f":"'CurvaRemanso F2'!A49","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.95000000000000051,5.6455903145729325,5.2947167723314932,{"$f":"'CurvaRemanso F2'!K50","v":0},{"$f":"'CurvaRemanso F2'!A50","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[0.97500000000000053,4.0970887530049511,5.5057657015651147,{"$f":"'CurvaRemanso F2'!K51","v":0},{"$f":"'CurvaRemanso F2'!A51","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[1.0000000000000004,{"$error":"#NUM!"},5.7191057579816267,{"$f":"IF('CurvaRemanso F2'!K52<>0,'CurvaRemanso F2'!K52,20)","v":20},{"$f":"'CurvaRemanso F2'!A52","v":{"$error":"#NAME?"}},{"$error":"#NAME?"}]
[]
[]
[1.9535,{"$f":"SQRT(($G$29-A94)*2*$G$23)*$G$17*A94","v":{"$error":"#NUM!"}},{"$f":"CurvaRemansoS1!K52","v":0}]

{"sheet":"CurvaRemanso F2","index":1,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":{"$error":"#NAME?"}}]
[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!G17","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":{"$error":"#NAME?"}},null,{"$f":"O12","v":0},{"$f":"M5","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!G36","v":{"$error":"#NAME?"}},"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":{"$error":"#NAME?"}},null,{"$f":"O52","v":0},{"$f":"M5","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!G19","v":1.4999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":{"$error":"#NAME?"}},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!G18","v":2.9999999999999997E-4},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":{"$error":"#NAME?"}},"m",null,null,null,"Suave",{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M5","v":{"$error":"#NAME?"}}]
["Calado Y al comienzo de la curva",null,null,null,"yini",{"$f":"IF(Principal!G44=\"F2\",Principal!G39,Principal!G40)","v":{"$error":"#NAME?"}},"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":{"$error":"#NAME?"}},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!G40","v":{"$error":"#NAME?"}},"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":{"$error":"#NAME?"}},"-",null,null,null,"Fuerte",{"$f":"M5","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["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":{"$error":"#NAME?"}},"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":{"$error":"#NAME?"}},{"$f":"$F$3+2*A12","v":{"$error":"#NAME?"}},{"$f":"$F$3*A12","v":{"$error":"#NAME?"}},{"$f":"C12/B12","v":{"$error":"#NAME?"}},{"$f":"$F$4/C12","v":{"$error":"#NAME?"}},{"$f":"A12+E12^2/2/$M$4","v":{"$error":"#NAME?"}},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":{"$error":"#NAME?"}},"H1-H2","(I1+I2)/2","(H1-H2)/(Im-I0)",null,{"$f":"E12^2/$M$4/A12","v":{"$error":"#NAME?"}},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":{"$error":"#NAME?"}},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":{"$error":"#NAME?"}},{"$f":"$F$9+K12","v":0}]
[{"$f":"A12+$M$9","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"C13/B13","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"A13+E13^2/2/$M$4","v":{"$error":"#NAME?"}},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":{"$error":"#NAME?"}},{"$f":"F12-F13","v":{"$error":"#NAME?"}},{"$f":"(G12+G13)/2","v":{"$error":"#NAME?"}},{"$f":"IFERROR(H13/(I13-$F$6),0)","v":0},{"$f":"J13+K12","v":0},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"$F$9+K13","v":0}]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"C14/B14","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"$F$5^2*E14^2/D14^(4/3)","v":{"$error":"#NAME?"}},{"$f":"F13-F14","v":{"$error":"#NAME?"}},{"$f":"(G13+G14)/2","v":{"$error":"#NAME?"}},{"$f":"IFERROR(H14/(I14-$F$6),0)","v":0},{"$f":"J14+K13","v":0},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"$F$9+K14","v":0}]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"$F$5^2*E15^2/D15^(4/3)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$f":"(G14+G15)/2","v":{"$error":"#NAME?"}},0,{"$f":"J15+K14","v":0},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"$F$5^2*E20^2/D20^(4/3)","v":{"$error":"#NAME?"}},{"$f":"F19-F20","v":{"$error":"#NAME?"}},{"$f":"(G19+G20)/2","v":{"$error":"#NAME?"}},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"A24+E24^2/2/$M$4","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$f":"A24/2*(SQRT(1+8*L24)-1)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"A25+E25^2/2/$M$4","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]
[{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0,0,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},0]

{"sheet":"CurvaRemansoS1","index":2,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Curva \" & M8","v":{"$error":"#NAME?"}}]
[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!G17","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":{"$error":"#NAME?"}},null,{"$f":"O12","v":0},{"$f":"M5","v":{"$error":"#NUM!"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["Caudal circulante por el canal",null,null,null,"Q",{"$f":"Principal!B94","v":{"$error":"#NUM!"}},"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":{"$error":"#NAME?"}},null,{"$f":"O52","v":0},{"$f":"M5","v":{"$error":"#NUM!"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["Número de Manning",null,null,null,"n",{"$f":"Principal!G19","v":1.4999999999999999E-2},null,null,"Calado crítico",null,null,"yc",{"$f":"(($F$4/$F$3)^2/$M$4)^(1/3)","v":{"$error":"#NUM!"}},"m",null,null,null,"Fuerte","F1","F2","F3"]
["Pendiente geométrica canal",null,null,null,"I0",{"$f":"Principal!G18","v":2.9999999999999997E-4},"-",null,"Calado uniforme",null,null,"yu",{"$f":"miyuniforme(F4,F3,F5,F6)","v":{"$error":"#NAME?"}},"m",null,null,null,"Suave",{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M5","v":{"$error":"#NUM!"}}]
["Calado Y al comienzo de la curva",null,null,null,"yini",2.5,"m",null,"Pendiente",null,null,"Pend",{"$f":"IF(M6>M5, R3, IF(M6=M5, R4, R5))","v":{"$error":"#NAME?"}},"-",null,null,null,"signo",1,-1,-1]
["Calado Y al final de la curva",null,null,null,"yfin",{"$f":"Principal!A94","v":1.9535},"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":{"$error":"#NAME?"}},"-",null,null,null,"Fuerte",{"$f":"M5","v":{"$error":"#NUM!"}},{"$f":"M6","v":{"$error":"#NAME?"}},{"$f":"M6","v":{"$error":"#NAME?"}}]
["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":-1.3662499999999999E-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","H0","I","DH0","Im","Dx","x","F2","Yc","N","Xdib"]
[{"$f":"F7","v":2.5},{"$f":"$F$3+2*A12","v":11},{"$f":"$F$3*A12","v":15},{"$f":"C12/B12","v":1.3636363636363635},{"$f":"$F$4/C12","v":{"$error":"#NUM!"}},{"$f":"A12+E12^2/2/$M$4","v":{"$error":"#NUM!"}},{"$f":"$F$5^2*E12^2/D12^(4/3)","v":{"$error":"#NUM!"}},"H1-H2","(I1+I2)/2","(H1-H2)/(Im-I0)",null,{"$f":"E12^2/$M$4/A12","v":{"$error":"#NUM!"}},{"$f":"A12/2*(SQRT(1+8*L12)-1)","v":{"$error":"#NUM!"}},{"$f":"$M$3*$F$4*E12+$F$3*$M$3*$M$4*A12^2/2","v":{"$error":"#NUM!"}},{"$f":"$F$9+K12","v":0}]
[{"$f":"A12+$M$9","v":2.4863374999999999},10.972674999999999,14.918025,{"$f":"C13/B13","v":1.35956136493608},{"$error":"#NUM!"},{"$f":"A13+E13^2/2/$M$4","v":{"$error":"#NUM!"}},{"$f":"$F$5^2*E13^2/D13^(4/3)","v":{"$error":"#NUM!"}},{"$f":"F12-F13","v":{"$error":"#NUM!"}},{"$f":"(G12+G13)/2","v":{"$error":"#NUM!"}},{"$f":"IFERROR(H13/(I13-$F$6),0)","v":0},{"$f":"J13+K12","v":0},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"$F$9+K13","v":0}]
[2.4726749999999997,10.945349999999999,14.836049999999998,{"$f":"C14/B14","v":1.3554660198166344},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"$F$5^2*E14^2/D14^(4/3)","v":{"$error":"#NUM!"}},{"$f":"F13-F14","v":{"$error":"#NUM!"}},{"$f":"(G13+G14)/2","v":{"$error":"#NUM!"}},{"$f":"IFERROR(H14/(I14-$F$6),0)","v":0},{"$f":"J14+K13","v":0},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"$F$9+K14","v":0}]
[2.4590124999999996,10.918025,14.754074999999997,1.3513501755125124,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"$F$5^2*E15^2/D15^(4/3)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"(G14+G15)/2","v":{"$error":"#NUM!"}},0,{"$f":"J15+K14","v":0},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.4453499999999995,10.890699999999999,14.672099999999997,1.3472136777250312,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.4316874999999993,10.863374999999998,14.590124999999997,1.3430563706030585,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.4180249999999992,10.836049999999998,14.508149999999995,1.3388780967234368,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.4043624999999991,10.808724999999999,14.426174999999994,1.3346786970711157,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3906999999999989,10.781399999999998,14.344199999999994,1.3304580110189768,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$f":"$F$5^2*E20^2/D20^(4/3)","v":{"$error":"#NUM!"}},{"$f":"F19-F20","v":{"$error":"#NUM!"}},{"$f":"(G19+G20)/2","v":{"$error":"#NUM!"}},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3770374999999988,10.754074999999997,14.262224999999994,1.326215876307353,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3633749999999987,10.726749999999997,14.180249999999992,1.3219521290232359,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3497124999999985,10.699424999999998,14.09827499999999,1.3176666035791635,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3360499999999984,10.672099999999997,14.01629999999999,1.3133591326917846,{"$error":"#NUM!"},{"$f":"A24+E24^2/2/$M$4","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$f":"A24/2*(SQRT(1+8*L24)-1)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},0]
[2.3223874999999983,10.644774999999996,13.934324999999991,1.3090295473600895,{"$error":"#NUM!"},{"$f":"A25+E25^2/2/$M$4","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.3087249999999981,10.617449999999996,13.852349999999989,1.3046776768433093,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.295062499999998,10.590124999999997,13.770374999999987,1.3003033486384714,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2813999999999979,10.562799999999996,13.688399999999987,1.2959063884576052,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2677374999999977,10.535474999999995,13.606424999999987,1.291486620204594,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2540749999999976,10.508149999999995,13.524449999999986,1.2870438659516652,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2404124999999975,10.480824999999996,13.442474999999984,1.2825779459155162,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2267499999999973,10.453499999999995,13.360499999999984,1.2780886784330598,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.2130874999999972,10.426174999999994,13.278524999999984,1.2735758799367929,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1994249999999971,10.398849999999994,13.196549999999982,1.2690393649297749,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1857624999999969,10.371524999999995,13.114574999999981,1.2644789459602119,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1720999999999968,10.344199999999994,13.032599999999981,1.259894433595637,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1584374999999967,10.316874999999992,12.950624999999981,1.2552856363966793,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1447749999999965,10.289549999999993,12.868649999999979,1.2506523608904168,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1311124999999964,10.262224999999994,12.786674999999978,1.2459944115433041,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1174499999999963,10.234899999999993,12.704699999999978,1.2413115907336649,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.1037874999999961,10.207574999999991,12.622724999999978,1.2366036987237408,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.090124999999996,10.180249999999992,12.540749999999976,1.2318705336312945,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0764624999999959,10.152924999999993,12.458774999999974,1.2271118914007524,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0627999999999957,10.125599999999991,12.376799999999974,1.2223275657738786,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0491374999999956,10.09827499999999,12.294824999999975,1.2175173482599737,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0354749999999955,10.070949999999991,12.212849999999973,1.2126810281055893,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0218124999999953,10.043624999999992,12.130874999999971,1.2078183922637475,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[2.0081499999999952,10.01629999999999,12.048899999999971,1.2029292253626571,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[1.9944874999999953,9.9889749999999911,11.966924999999971,1.1980133096739136,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[1.9808249999999954,9.9616499999999917,11.884949999999971,1.1930704250801807,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[1.9671624999999955,9.9343249999999905,11.802974999999973,1.1881003490423341,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]
[1.9534999999999956,9.9069999999999911,11.720999999999973,1.1831028565660628,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},0]