{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Esquema","ELL","N1","NRR","Costes","Rot. Not","Q nocturnos","Grafico Q noct","Vol mensual","ELL (Método 2)","Sensibilidad N1","Sensibilidad Presion","Sensibilidad CI","Sensibilidad CA"],"not_rendered":{"charts":15,"images":0,"macros":1,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Grafico Q noct","index":7,"reason":"not_a_worksheet"}],"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":"Esquema","index":0,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,14,3,15],[6,14,6,15],[9,14,9,15],[10,14,10,15],[21,14,21,15],[4,14,4,15],[5,14,5,15],[11,14,11,15],[12,14,12,15],[13,14,13,15],[7,14,8,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[17,14,17,15]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ficha",null,"Contenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELL",null,"Cálculo del Nivel Económico de Fugas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1",null,"Coeficiente N1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NRR",null,"Calculo del Indice Natural de Aumento de Fugas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CV - CI",null,"Coste Marginal del agua"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes de Inspeccion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROT. NOT",null,"Valores de referencia para el calculo de las fugas para roturas notificadas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caudales nocturnos",null,"Calculo del NRR con el método de los minimos caudales nocturnos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grafico Q noct",null,"Gráfico de los caudales nocturnos y regresión lineal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volumen mensual",null,"Cálculo del NRR utilizando los volumenes inyectados y facturados mensuales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELL (método 2)",null,"Cálculo del Nivel Económico de Fugas - Método 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensibilidad N1",null,"Analisis de sensibilidad del coeficiente N1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensibilidad Presion",null,"Analisis de sensibilidad de la presion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensibilidad CI",null,"Analisis de los costes de inspeccion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sensibilidad CA",null,"Analisis de los costes ambientales (Coste Marginal del Agua)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tipo de celdas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Datos a Ingresar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Celdas formuladas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Resultados"]

{"sheet":"ELL","index":1,"n_rows":26,"n_cols":191,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,48,4,63],[2,1,2,2],[2,4,2,10],[2,12,2,18],[2,20,2,26],[4,31,4,46],[2,31,2,82],[4,67,4,82],[2,30,25,30],[2,84,2,102],[3,84,3,89],[3,91,3,96],[4,98,5,98],[4,100,4,102],[4,84,4,85],[4,86,4,87],[4,88,4,89],[4,91,4,92],[4,93,4,94],[4,95,4,96],[4,170,4,190],[4,109,4,122],[4,124,4,137],[4,141,4,154],[2,104,2,154],[4,104,4,107],[4,165,4,168],[2,156,2,168],[4,156,4,159],[4,161,5,161],[4,163,5,163],[2,170,2,190]]}
[null,null,null,null,null,"Basico 1","Basico 2","Intermedio","Avanzado",null,null,null,null,null,null,"Basico","Intermedio","Avanzado","Otros",null,"Referencia","Calculado"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176]
[null,"INFORMACION",null,null,"FUGAS POR ROTURAS NO NOTIFICADAS",null,null,null,null,null,null,null,"FUGAS POR ROTURAS NOTIFICADAS",null,null,null,null,null,null,null,"FUGAS DE FONDO",null,null,null,null,null,null,null,"NIVEL ECONÓMICO DE FUGAS",null,"No editar","N1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes de inspeccion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugas por Rot. Not.",null,null,null,null,null,null,"Fugas de fondo"]
[null,null,null,null,"Basico 1",null,null,null,null,null,null,null,null,null,null,"Intermedio","Referencia","Referencia",null,null,null,null,null,"Intermedio",null,null,null,null,null,null,null,"Fugas por roturas notificadas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugas de fondo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugas rot not",null,"ELL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basico",null,"Intermedio",null,"Avanzado",null,null,"Basico",null,"Intermedio",null,"Avanzado",null,null,"Fugas por Rot Not",null,"ELL",null,null,null,"Originales",null,null,null,null,"Fugas por Roturas Notificadas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugas de fondo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ELL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fugas por Roturas no Notificadas",null,null,null,null,"Fugas por Roturas Notificadas",null,"Fugas de fondo",null,"ELL",null,null,null,null,"Costes Ambientales"]
[null,"Codigo","Sector Analizado / Direccion",null,"NRR (m3/año/año)","Longitud de tuberia (km)","Costes de intervencion (USD)","Coste del agua (USD/m3)","Frecuencia Optima de Inspeccion (Años)","Porcentaje Anualmente Inspeccionado","Caudal fugado (m3/año)",null,"Roturas por año en tuberias","Roturas por año en acometidas","Presion promedio (mca)","N1","Caudal tuberias (m3/año)","Caudal acometidas (m3/año)","Caudal fugado (m3/año)",null,"Longitud de tuberias (km)","Numero de acometidas","Presion promedio (mca)","N1","Caudal tuberias (m3/año)","Caudal acometidas (m3/año)","Caudal fugado (m3/año)",null,"ELL (m3)",null,null,0.5,0.6,0.7,0.79999999999999993,0.89999999999999991,0.99999999999999989,1.0999999999999999,1.2,1.3,1.4000000000000001,1.5000000000000002,1.6000000000000003,1.7000000000000004,1.8000000000000005,1.9000000000000006,2.0000000000000004,null,0.5,0.6,0.7,0.79999999999999993,0.89999999999999991,0.99999999999999989,1.0999999999999999,1.2,1.3,1.4000000000000001,1.5000000000000002,1.6000000000000003,1.7000000000000004,1.8000000000000005,1.9000000000000006,2.0000000000000004,null,null,null,{"$f":"+AW6","v":0.5},{"$f":"+AX6","v":0.6},0.7,0.79999999999999993,0.89999999999999991,0.99999999999999989,1.0999999999999999,1.2,1.3,1.4000000000000001,1.5000000000000002,1.6000000000000003,1.7000000000000004,{"$f":"+BJ6","v":1.8000000000000005},{"$f":"+BK6","v":1.9000000000000006},2.0000000000000004,null,"N1","Perdidas","N1","Perdidas","N1","Perdidas",null,"N1","Perdidas","N1","Perdidas","N1","Perdidas",null,null,null,"Basico","Intermedio","Avanzado",null,"Presion Promedio","Fugas por roturas notificadas","Fugas de fondo","ELL",null,15,20,25,30,35,40,45,50,55,60,65,70,75,80,null,15,20,25,30,35,40,45,50,55,60,65,70,75,80,null,"Fugas por Rot. no Notificadas",null,15,20,25,30,35,40,45,50,55,60,65,70,75,80,null,{"$f":"+Costes!$I$9","v":"Grupo geofono"},{"$f":"+Costes!$J$9","v":"Soundstick"},{"$f":"+Costes!$K$9","v":0},{"$f":"+Costes!$L$9","v":0},null,null,null,null,null,{"$f":"+Costes!$I$9","v":"Grupo geofono"},{"$f":"+Costes!$J$9","v":"Soundstick"},{"$f":"+Costes!$K$9","v":0},{"$f":"+Costes!$L$9","v":0},null,0,0.25,0.5,0.75,1,1.25,1.5,1.75,2,2.25,2.5,2.75,3,3.25,3.5,3.75,4,4.25,4.5,4.75,5]
[null,"CTC-029","Brasil - Av. Quito - Calle 22 SO - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C7,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C7,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C7,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C7,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":8592.3226328177552},11.778969999999999,{"$f":"Costes!$C$3*ELL!F7","v":547.07190585599994},{"$f":"+Costes!$C$2","v":0.06},{"$f":"IFERROR(SQRT((2*G7)/(H7*E7)),\"0\")","v":1.456821328268139},{"$f":"IFERROR(100/I7,\"0\")","v":68.642597454884495},{"$f":"IFERROR(J7*G7/H7/100,\"0\")","v":6258.7394354249782},null,3,12,19.899999999999999,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C7,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C7,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C7,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C7,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":0.9936372366441939},{"$f":"IFERROR(((O7/50)^P7)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M7),\"0\")","v":1037.6811284273028},{"$f":"IFERROR(((O7/50)^P7)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N7),\"0\")","v":1474.8523445702867},{"$f":"IFERROR(Q7+R7,\"0\")","v":2512.5334729975893},null,11.778969999999999,842,19.899999999999999,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C7,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C7,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C7,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C7,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":0.9936372366441939},{"$f":"IFERROR(+((W7/50)^X7)*(20*U7*(24*365/1000)),\"0\")","v":826.17174660715568},{"$f":"IFERROR(+((W7/50)^X7)*(1.25*V7*(24*365/1000)),\"0\")","v":3691.0942268467934},{"$f":"IFERROR(IF(Y7+Z7=0,\"0\",Y7+Z7),\"0\")","v":4517.2659734539493},null,{"$f":"IFERROR(+K7+S7+AA7,\"0\")","v":13288.538881876517},null,null,3959.3552566042872,3610.8776915679755,3293.0709316156681,3003.2355252506727,2738.909609730913,2497.848,2278.0031180791616,2077.5076009342374,1894.6584390889079,1727.9025112575023,1575.8233921285059,1437.1293212440537,1310.6422307830355,1195.287739049767,1090.0860246729023,994.14350399999921,null,7118.4965174359422,6491.971193905606,5920.5886916245781,5399.4956860405491,4924.2660117250334,4490.863066511999,4095.6055245879174,3735.1360673001386,3406.3928660829852,3106.5835752774592,2833.1616139395042,2583.8045351744304,2356.3942992665807,2148.999283044137,1959.8578726665619,1787.3635004717744,null,6258.7394354249782,null,{"$f":"IFERROR((AW7+AF7+$BN7),\"-\")","v":17336.591209465209},{"$f":"IFERROR((AX7+AG7+$BN7),\"-\")","v":16361.588320898558},15472.399058665225,14661.4706467162,13921.915056880924,13247.450501936977,12632.348078092058,12071.383103659355,11559.790740596873,11093.225521959939,10667.724441492988,10279.673291843463,9925.7759654745932,9603.0264575188812,9308.6833327644417,9040.2464398967513,null,1,2497.848,0.9936372366441939,2512.5334729975893,0.90056353439572434,2737.4879750556456,null,1,4490.863066511999,0.9936372366441939,4517.2659734539493,0.90056353439572434,4921.7100649031163,null,{"$f":"+BN7","v":6258.7394354249782},null,{"$f":"IFERROR(CH7+CO7+$CU7,\"-\")","v":13247.450501936977},{"$f":"IFERROR(CJ7+CQ7+$CU7,\"-\")","v":13288.538881876517},{"$f":"IFERROR(CL7+CS7+$CU7,\"-\")","v":13917.93747538374},null,19.899999999999999,2512.5334729975893,4517.2659734539493,13288.538881876517,null,1897.2787535799157,2525.0787341649007,3151.8701837578737,3777.8591005517997,4403.1814179999928,5027.9336431060037,5652.1878666655484,6276,6899.4146767993088,7522.4683545800772,8145.1913735554244,8767.6093773698485,9389.7443253009951,10011.615232995067,null,3411.103910778384,4539.8210088428214,5666.7248762449217,6792.1858756634992,7916.4484008827221,9039.6859611545133,10162.028168005243,11283.575543999999,12404.408335730934,13524.592089906575,14644.181354979246,15763.222235474108,16881.754211819483,17999.811472109781,null,6258.7394354249782,null,{"$f":"+IFERROR(DF7+DU7+$EJ7,0)","v":11567.122099783279},{"$f":"+IFERROR(DG7+DV7+$EJ7,0)","v":13323.639178432699},15077.334495427775,16828.784411640278,18578.369254307694,20326.359039685496,22072.955470095771,23818.314979424977,25562.562447955221,27305.799879911629,29048.112163959646,30789.571048268932,32530.237972545456,34270.166140529829,null,6258.7394354249782,6832.5346552730716,0,0,null,2512.5334729975893,null,4517.2659734539493,null,{"$f":"IF(FA7=0,0,FA7+$FF7+$FH7)","v":13288.538881876517},{"$f":"IF(FB7=0,0,FB7+$FF7+$FH7)","v":13862.334101724609},0,0,null,13288.538881876517,9783.2776920778779,9078.452819154405,8733.2125630988776,8518.8504166096773,8369.2505016175019,8257.2392353640244,8169.3227448716871,8097.9411862625602,8038.4866390348761,7987.9693245656672,7944.3534106677398,7906.1982647061686,7872.4519193610358,7842.3258780410815,7815.215924772443,7790.6502081547724,7768.2541506616089,7747.7260967928614,7728.8200204221666,7711.3329937791295]
[null,"CTC-030","Calle 22 SO - Av. Quito - Venezuela - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C8,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C8,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C8,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C8,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":9214.8068140551459},13.110799999999999,{"$f":"Costes!$C$3*ELL!F8","v":608.92848384000001},{"$f":"+Costes!$C$2","v":0.06},{"$f":"IFERROR(SQRT((2*G8)/(H8*E8)),\"0\")","v":1.484155480096446},{"$f":"IFERROR(100/I8,\"0\")","v":67.3783854461809},{"$f":"IFERROR(J8*G8/H8/100,\"0\")","v":6838.1030155550097},null,3,16,19.899999999999999,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C8,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C8,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C8,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C8,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":0.81005347511995662},{"$f":"IFERROR(((O8/50)^P8)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M8),\"0\")","v":1228.9066356888452},{"$f":"IFERROR(((O8/50)^P8)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N8),\"0\")","v":2328.8539330646636},{"$f":"IFERROR(Q8+R8,\"0\")","v":3557.7605687535088},null,13.110799999999999,903,19.899999999999999,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C8,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C8,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C8,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C8,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":0.81005347511995662},{"$f":"IFERROR(+((W8/50)^X8)*(20*U8*(24*365/1000)),\"0\")","v":1089.0484126859444},{"$f":"IFERROR(+((W8/50)^X8)*(1.25*V8*(24*365/1000)),\"0\")","v":4687.9801225678821},{"$f":"IFERROR(IF(Y8+Z8=0,\"0\",Y8+Z8),\"0\")","v":5777.0285352538267},null,{"$f":"IFERROR(+K8+S8+AA8,\"0\")","v":16172.892119562344},null,null,4734.0665783235454,4317.403791830161,3937.4130450675548,3590.866695583341,3274.8211777279748,2986.5919999999996,2723.730942967818,2484.0052640870799,2265.3787327793443,2065.9943346839223,1884.1584981727706,1718.3267091484036,1567.0903919368861,1429.1649448421686,1303.3788287357329,1188.6636159999989,null,7687.093378616104,7010.5237330106411,6393.501495353682,5830.7856770545968,5317.5965683987524,4849.5751396799997,4422.74601559031,4033.4837083709317,3678.4818229093535,3354.7249722100878,3059.4631646892085,2790.1884457382339,2544.6135951507645,2320.6526994677279,2116.4034342227014,1930.1309055926388,null,6838.1030155550097,null,{"$f":"IFERROR((AW8+AF8+$BN8),\"-\")","v":19259.26297249466},{"$f":"IFERROR((AX8+AG8+$BN8),\"-\")","v":18166.030540395812},{"$f":"IFERROR((AY8+AH8+$BN8),\"-\")","v":17169.017555976247},{"$f":"IFERROR((AZ8+AI8+$BN8),\"-\")","v":16259.755388192949},{"$f":"IFERROR((BA8+AJ8+$BN8),\"-\")","v":15430.520761681739},{"$f":"IFERROR((BB8+AK8+$BN8),\"-\")","v":14674.270155235008},{"$f":"IFERROR((BC8+AL8+$BN8),\"-\")","v":13984.579974113138},{"$f":"IFERROR((BD8+AM8+$BN8),\"-\")","v":13355.59198801302},{"$f":"IFERROR((BE8+AN8+$BN8),\"-\")","v":12781.963571243708},{"$f":"IFERROR((BF8+AO8+$BN8),\"-\")","v":12258.822322449021},{"$f":"IFERROR((BG8+AP8+$BN8),\"-\")","v":11781.724678416987},{"$f":"IFERROR((BH8+AQ8+$BN8),\"-\")","v":11346.618170441649},{"$f":"IFERROR((BI8+AR8+$BN8),\"-\")","v":10949.807002642661},{"$f":"IFERROR((BJ8+AS8+$BN8),\"-\")","v":10587.920659864907},{"$f":"IFERROR((BK8+AT8+$BN8),\"-\")","v":10257.885278513444},{"$f":"IFERROR((BL8+AU8+$BN8),\"-\")","v":9956.8975371476481},null,1,2986.5919999999996,0.81005347511995662,3557.7605687535088,0.79672962643700085,3601.7023137080009,null,1,4849.5751396799997,0.81005347511995662,5777.0285352538267,0.79672962643700085,5848.3803616584582,null,{"$f":"+BN8","v":6838.1030155550097},null,14674.270155235008,16172.892119562344,16288.185690921469,null,19.899999999999999,3557.7605687535088,5777.0285352538267,16172.892119562344,null,2829.6523444074974,3572.2359638075359,4279.9868164562913,4961.162756574744,5621.00477705497,6263.1171127312973,6890.1204026259065,7504,8106.3082435028773,8698.2897195372861,9280.9628414548679,9855.1751806432821,10421.642271821291,10980.975603296141,null,4594.7393093451765,5800.53342510522,6949.7667117720057,8055.8481266243198,9127.2879010016459,10169.938527527725,11188.055353384911,12184.862160000001,13162.879607349983,14124.128632770109,15070.262917805103,16002.658733847482,16922.477953487698,17830.71350059786,null,6838.1030155550097,null,{"$f":"+IFERROR(DF8+DU8+$EJ8,0)","v":14262.494669307684},{"$f":"+IFERROR(DG8+DV8+$EJ8,0)","v":16210.872404467766},{"$f":"+IFERROR(DH8+DW8+$EJ8,0)","v":18067.856543783306},{"$f":"+IFERROR(DI8+DX8+$EJ8,0)","v":19855.113898754073},{"$f":"+IFERROR(DJ8+DY8+$EJ8,0)","v":21586.395693611626},{"$f":"+IFERROR(DK8+DZ8+$EJ8,0)","v":23271.158655814033},{"$f":"+IFERROR(DL8+EA8+$EJ8,0)","v":24916.278771565827},{"$f":"+IFERROR(DM8+EB8+$EJ8,0)","v":26526.965175555011},{"$f":"+IFERROR(DN8+EC8+$EJ8,0)","v":28107.290866407871},{"$f":"+IFERROR(DO8+ED8+$EJ8,0)","v":29660.521367862406},{"$f":"+IFERROR(DP8+EE8+$EJ8,0)","v":31189.328774814981},{"$f":"+IFERROR(DQ8+EF8+$EJ8,0)","v":32695.936930045777},{"$f":"+IFERROR(DR8+EG8+$EJ8,0)","v":34182.223240863997},{"$f":"+IFERROR(DS8+EH8+$EJ8,0)","v":35649.792119449012},null,6838.1030155550097,7465.0137319439973,0,0,null,3557.7605687535088,null,5777.0285352538267,null,{"$f":"IF(FA8=0,0,FA8+$FF8+$FH8)","v":16172.892119562344},{"$f":"IF(FB8=0,0,FB8+$FF8+$FH8)","v":16799.802835951334},{"$f":"IF(FC8=0,0,FC8+$FF8+$FH8)","v":0},{"$f":"IF(FD8=0,0,FD8+$FF8+$FH8)","v":0},null,16172.892119562344,12343.153342357211,11573.083723913522,11195.885014751415,10961.679635944312,10798.23144635447,10675.851439094746,10579.796630461886,10501.807371408009,10436.849192068421,10381.65555380088,10334.002170011889,10292.31505052869,10255.444848749337,10222.530077952088,10192.910590655883,10166.070856774046,10141.601624613058,10119.173314805363,10098.517126897776,10079.411348353293]
[null,"CTC-031","Venezuela - Av. Quito - Vacas Galindo - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C9,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C9,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C9,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C9,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":12541.525553127101},12.784879999999999,{"$f":"Costes!$C$3*ELL!F9","v":593.79119462400001},{"$f":"+Costes!$C$2","v":0.06},1.2562644364614348,79.601075297230892,7877.7362656829519,null,1,14,19.899999999999999,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C9,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C9,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C9,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C9,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":1.0583089740152092},{"$f":"IFERROR(((O9/50)^P9)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M9),\"0\")","v":325.88652777344277},{"$f":"IFERROR(((O9/50)^P9)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N9),\"0\")","v":1621.13460228039},1947.0211300538328,null,12.784879999999999,1229,19.899999999999999,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C9,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C9,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C9,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C9,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":1.0583089740152092},844.8574195489158,5075.9655576822852,5920.8229772312006,null,15745.580372967985,null,null,3256.5633898329079,2969.9411478447882,2708.5455941682731,2470.1564342485617,2252.7487899029593,2054.4759999999997,1873.653934914696,1708.7466915268535,1558.3535472557269,1421.1970623185509,1296.1122291534971,1182.0365768422253,1078.001146478972,983.12226083092685,896.59401838137705,817.68144799999936,null,9903.095065434396,9031.4868789829925,8236.592167023091,7511.6590916761143,6850.5300693980871,6247.589468447999,5697.7159096962969,5196.2387656164065,4738.8984879616319,4321.8104271505799,3941.4318360428879,3594.5317778352296,3278.1636824751886,2989.6403184870915,2726.5109676204361,2486.5406084423021,null,7877.7362656829519,null,21037.394720950258,19879.16429251073,18822.874026874313,17859.551791607628,16981.015124983998,16179.801734130951,15449.106110293946,14782.721722826212,14174.98830090031,13620.743755152082,13115.280330879337,12654.304620360406,12233.901094637113,11850.49884500097,11500.841251684764,11181.958322125254,null,1,2054.4759999999997,1.0583089740152092,1947.0211300538328,1.191581852938784,1722.0506848878376,null,1,6247.589468447999,1.0583089740152092,5920.8229772312006,1.191581852938784,5236.6957428750302,null,7877.7362656829519,null,16179.801734130951,15745.580372967986,14836.48269344582,null,19.899999999999999,1947.0211300538328,5920.8229772312006,15745.580372967985,null,1443.6128253191721,1957.3771669397552,2478.7644237509489,3006.3080351222156,3539.0269175819371,4076.2166985006725,4617.3461889159616,5162,5709.8440976040893,6260.6038430298559,6814.0493172154829,7369.9851319124236,7928.243130353485,8488.677018294411,null,4389.9759763465345,5952.3153222298033,7537.8356858829229,9142.0773078586244,10762.056747724919,12395.63203301702,14041.187836728135,15697.460975999998,17363.43566470053,19038.276736179152,20721.285014631823,22411.866331246703,24109.509327191769,25813.769126800573,null,7877.7362656829519,null,13711.325067348658,15787.42875485251,17894.336375316823,20026.121608663794,22178.819930989808,24349.584997200647,26536.270291327048,28737.197241682952,30951.016027987571,33176.616844891956,35413.070597530255,37659.587728842082,39915.488723228205,42180.182410777932,null,7877.7362656829519,8599.9595598639007,0,0,null,1947.0211300538328,null,5920.8229772312006,null,15745.580372967985,16467.803667148932,0,0,null,15745.580372967985,11333.585996069516,10446.438588884383,10011.892349411861,9742.0794784957925,9553.7813894258907,9412.7952973486845,9302.1367641649922,9212.2903823563356,9137.4562647696075,9073.8712434813751,9018.9728617513665,8970.9478272911365,8928.4720522085518,8890.5530733636442,8856.4303775350672,8825.5100558491758,8797.3206358960779,8771.4824306002301,8747.6857723427856,8725.6752404479612]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C10,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C10,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C10,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C10,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F10","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C10,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C10,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C10,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C10,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O10/50)^P10)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M10),\"0\")","v":"0"},{"$f":"IFERROR(((O10/50)^P10)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N10),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C10,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C10,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C10,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C10,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C11,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C11,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C11,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C11,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F11","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C11,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C11,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C11,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C11,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O11/50)^P11)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M11),\"0\")","v":"0"},{"$f":"IFERROR(((O11/50)^P11)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N11),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C11,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C11,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C11,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C11,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C12,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C12,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C12,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C12,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F12","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C12,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C12,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C12,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C12,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O12/50)^P12)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M12),\"0\")","v":"0"},{"$f":"IFERROR(((O12/50)^P12)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N12),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C12,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C12,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C12,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C12,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C13,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C13,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C13,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C13,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F13","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C13,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C13,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C13,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C13,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O13/50)^P13)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M13),\"0\")","v":"0"},{"$f":"IFERROR(((O13/50)^P13)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N13),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C13,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C13,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C13,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C13,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C14,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C14,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C14,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C14,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F14","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C14,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C14,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C14,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C14,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O14/50)^P14)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M14),\"0\")","v":"0"},{"$f":"IFERROR(((O14/50)^P14)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N14),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C14,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C14,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C14,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C14,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C15,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C15,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C15,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C15,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F15","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C15,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C15,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C15,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C15,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O15/50)^P15)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M15),\"0\")","v":"0"},{"$f":"IFERROR(((O15/50)^P15)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N15),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C15,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C15,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C15,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C15,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C16,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C16,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C16,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C16,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F16","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C16,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C16,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C16,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C16,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O16/50)^P16)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M16),\"0\")","v":"0"},{"$f":"IFERROR(((O16/50)^P16)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N16),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C16,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C16,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C16,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C16,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C17,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C17,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C17,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C17,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F17","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C17,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C17,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C17,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C17,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O17/50)^P17)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M17),\"0\")","v":"0"},{"$f":"IFERROR(((O17/50)^P17)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N17),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C17,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C17,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C17,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C17,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C18,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C18,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C18,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C18,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F18","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C18,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C18,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C18,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C18,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O18/50)^P18)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M18),\"0\")","v":"0"},{"$f":"IFERROR(((O18/50)^P18)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N18),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C18,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C18,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C18,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C18,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C19,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C19,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C19,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C19,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F19","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C19,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C19,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C19,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C19,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O19/50)^P19)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M19),\"0\")","v":"0"},{"$f":"IFERROR(((O19/50)^P19)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N19),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C19,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C19,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C19,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C19,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C20,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C20,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C20,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C20,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F20","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C20,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C20,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C20,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C20,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O20/50)^P20)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M20),\"0\")","v":"0"},{"$f":"IFERROR(((O20/50)^P20)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N20),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C20,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C20,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C20,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C20,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C21,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C21,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C21,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C21,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F21","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C21,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C21,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C21,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C21,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O21/50)^P21)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M21),\"0\")","v":"0"},{"$f":"IFERROR(((O21/50)^P21)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N21),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C21,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C21,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C21,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C21,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C22,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C22,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C22,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C22,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F22","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C22,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C22,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C22,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C22,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O22/50)^P22)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M22),\"0\")","v":"0"},{"$f":"IFERROR(((O22/50)^P22)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N22),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C22,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C22,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C22,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C22,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C23,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C23,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C23,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C23,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F23","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C23,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C23,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C23,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C23,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O23/50)^P23)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M23),\"0\")","v":"0"},{"$f":"IFERROR(((O23/50)^P23)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N23),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C23,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C23,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C23,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C23,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,{"$f":"IFERROR(CL23+CS23+$CU23,\"-\")","v":0},null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C24,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C24,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C24,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C24,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F24","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C24,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C24,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C24,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C24,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O24/50)^P24)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M24),\"0\")","v":"0"},{"$f":"IFERROR(((O24/50)^P24)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N24),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C24,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C24,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C24,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C24,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C25,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C25,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C25,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C25,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F25","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C25,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C25,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C25,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C25,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O25/50)^P25)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M25),\"0\")","v":"0"},{"$f":"IFERROR(((O25/50)^P25)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N25),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C25,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C25,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C25,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C25,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C26,NRR!$C$9:$Y$28,3,FALSE),IF(ELL!$E$5=ELL!$G$1,VLOOKUP(C26,NRR!$C$9:$Y$28,7,FALSE),IF(ELL!$E$5=ELL!$H$1,VLOOKUP(C26,NRR!$C$9:$Y$28,19,FALSE),IF(ELL!$E$5=ELL!$I$1,VLOOKUP(C26,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},null,{"$f":"Costes!$C$3*ELL!F26","v":0},{"$f":"+Costes!$C$2","v":0.06},"0","0",0,null,null,null,null,{"$f":"IFERROR((IF($P$5=$P$1,VLOOKUP(C26,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$P$5=ELL!$Q$1,VLOOKUP(ELL!C26,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$P$5=ELL!$R$1,VLOOKUP(ELL!C26,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$P$5=ELL!$S$1,VLOOKUP(ELL!C26,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},{"$f":"IFERROR(((O26/50)^P26)*((IF($Q$5=$U$1,864,'Rot. Not'!$E$5))*M26),\"0\")","v":"0"},{"$f":"IFERROR(((O26/50)^P26)*((IF($R$5=$U$1,307,'Rot. Not'!$E$10))*N26),\"0\")","v":"0"},0,null,null,null,null,{"$f":"IFERROR((IF($X$5=$P$1,VLOOKUP(C26,'N1'!$C$7:$Q$26,5,FALSE),IF(ELL!$X$5=ELL!$Q$1,VLOOKUP(ELL!C26,'N1'!$C$7:$Q$26,9,FALSE),IF(ELL!$X$5=ELL!$R$1,VLOOKUP(ELL!C26,'N1'!$C$7:$Q$26,15,FALSE),IF(ELL!$X$5=ELL!$S$1,VLOOKUP(ELL!C26,'N1'!$C$7:$S$26,17,FALSE),\"Elegir Metodo\"))))),\"0\")","v":"0"},"0","0","0",null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,null,0,0,0,null,null,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"N1","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,4,4,5],[2,4,2,6],[2,8,2,10],[2,12,2,16]]}
[null,null,null,null,"Lineal","Aproximacion","Seguridad","Ninguno",null,null,null,null,1.2,1.5,0.5,0.7]
[]
[null,null,null,null,"BASICO",null,null,null,"INTERMEDIO",null,null,null,"AVANZADO",null,null,null,null,null,"OTRO METODO"]
[]
[null,null,null,null,null,null,"Lineal"]
[null,"Codigo","Sector Analizado / Direccion",null,"% aprox de red rigida","% aprox de red elastica","N1",null,"Km de red elastica","Km de red rigida","N1",null,"Km red elastica con diametros menores a 100 mm","Km red elastica con diametros mayores a 100 mm","Km red rigida con diametros menores a 200 mm","Km red rigida con diametros mayores a 200 mm","N1",null,"N1"]
[null,"CTC-029","Brasil - Av. Quito - Calle 22 SO - Tungurahua",null,null,null,{"$f":"IFERROR((IF(B7=0,\"-\",(IF($G$5=$E$1,1,IF($G$5=$F$1,(1.5*E7+0.5*F7),IF($G$5=$G$1,1.5,\"-\")))))),\"-\")","v":1},null,6.0091299999999999,6.16404,{"$f":"IFERROR(((I7*1.5+J7*0.5)/(I7+J7)),\"-\")","v":0.9936372366441939},null,4.6997799999999996,1.30935,4.7793799999999997,1.38466,{"$f":"IFERROR(((M7*1.2+N7*1.5+O7*0.5+P7*0.7)/(SUM(M7:P7))),\"-\")","v":0.90056353439572434}]
[null,"CTC-030","Calle 22 SO - Av. Quito - Venezuela - Tungurahua",null,null,null,1,null,4.0644600000000004,9.0444399999999998,{"$f":"IFERROR(((I8*1.5+J8*0.5)/(I8+J8)),\"-\")","v":0.81005347511995662},null,3.1701299999999999,0.89433000000000007,5.1625500000000004,3.8818899999999998,{"$f":"IFERROR(((M8*1.2+N8*1.5+O8*0.5+P8*0.7)/(SUM(M8:P8))),\"-\")","v":0.79672962643700085}]
[null,"CTC-031","Venezuela - Av. Quito - Vacas Galindo - Tungurahua",null,null,null,1,null,11.84759,9.3728999999999996,1.0583089740152092,null,10.23737,1.61022,0.61023000000000005,0.32706000000000002,1.191581852938784]
[null,null,null,null,null,null,{"$f":"IFERROR((IF(B10=0,\"-\",(IF($G$5=$E$1,1,IF($G$5=$F$1,(1.5*E10+0.5*F10),IF($G$5=$G$1,1.5,\"-\")))))),\"-\")","v":"-"},null,null,null,{"$f":"IFERROR(((I10*1.5+J10*0.5)/(I10+J10)),\"-\")","v":"-"},null,null,null,null,null,{"$f":"IFERROR(((M10*1.2+N10*1.5+O10*0.5+P10*0.7)/(SUM(M10:P10))),\"-\")","v":"-"}]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]
[null,null,null,null,null,null,"-",null,null,null,"-",null,null,null,null,null,"-"]

{"sheet":"NRR","index":3,"n_rows":28,"n_cols":25,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,22,2,23],[6,22,6,23],[7,6,7,7],[2,6,2,8],[2,10,2,20],[5,11,5,13],[5,14,5,16],[4,11,4,16]]}
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,36]
[]
[null,null,null,null,"BASICO 1",null,"BASICO 2",null,null,null,"MEDIO",null,null,null,null,null,null,null,null,null,null,null,"Avanzado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Caudal por tipo de fuga (m3/h)"]
[null,null,null,null,null,null,null,null,"Periodo entre años:",null,null,"Tuberias",null,null,"Acometidas"]
[null,null,null,null,null,null,"Año 1 ","Año 2",2,null,null,0.15,1,5,0.15,1,5,null,null,null,null,null,"Pestaña Adicionales"]
[null,"Codigo","Sector Analizado / Direccion",null,"Valor de NRR asumido (m3/año/año)",null,"Volumen de perdidas reales (m3/año)",null,"NRR (m3/año/año)",null,"Fugas encontradas durante 1 CAF","# de fugas tipo A","# de fugas tipo B","# de fugas tipo C","# de fugas tipo D","# de fugas tipo E","# de fugas tipo F","Flujo agregado de todos los caudales encontrados (m3/h)","Años","NRR (m3/h/año)","NRR (m3/año/año)",null,"NRR (m3/dia/dia)","NRR (m3/año/año)"]
[null,"CTC-029","Brasil - Av. Quito - Calle 22 SO - Tungurahua",null,8592.3226328177552,null,null,null,{"$f":"IFERROR(((H9-G9)/$I$7),\"-\")","v":0},null,{"$f":"L9+M9+N9","v":0},null,null,null,null,null,null,{"$f":"IFERROR(((L9*$L$7)+(M9*$M$7)+(N9*$N$7)+(O9*$O$7)+(P9*$P$7)+(Q9*$Q$7)),\"-\")","v":0},null,{"$f":"IFERROR((R9/S9),\"-\")","v":"-"},{"$f":"IFERROR((T9)*(24*365),\"-\")","v":"-"},null,null,{"$f":"IFERROR(W9*(365*365),\"-\")","v":0}]
[null,"CTC-030","Calle 22 SO - Av. Quito - Venezuela - Tungurahua",null,9214.8068140551459,null,null,null,{"$f":"IFERROR(((H10-G10)/$I$7),\"-\")","v":0},null,{"$f":"L10+M10+N10","v":0},null,null,null,null,null,null,{"$f":"(L10*$L$7)+(M10*$M$7)+(N10*$N$7)+(O10*$O$7)+(P10*$P$7)+(Q10*$Q$7)","v":0},null,{"$f":"IFERROR((R10/S10),\"-\")","v":"-"},{"$f":"IFERROR((T10)*(24*365),\"-\")","v":"-"},null,null,{"$f":"IFERROR(W10*(365*365),\"-\")","v":0}]
[null,"CTC-031","Venezuela - Av. Quito - Vacas Galindo - Tungurahua",null,12541.525553127101,null,null,null,0,null,{"$f":"L11+M11+N11","v":0},null,null,null,null,null,null,0,null,{"$f":"IFERROR((R11/S11),\"-\")","v":"-"},"-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,"-","-",null,null,0]

{"sheet":"Costes","index":4,"n_rows":45,"n_cols":37,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[6,0,6,1],[17,0,17,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[39,0,39,1],[41,0,41,3],[31,0,31,3],[18,0,18,1],[7,13,7,15],[6,8,7,11],[37,0,37,1],[25,0,25,1],[26,0,26,1],[24,0,24,1],[21,0,21,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
["Coste Marginal del agua (USD/m3)",null,{"$f":"+C43","v":0.06}]
["Coste de inspeccion (USD/km)",null,{"$f":"+C27","v":46.444800000000001}]
[]
[]
[]
["Dias laborables anual",null,250,null,null,null,null,null,"Grupo de trabajo "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NO EDITAR"]
["Equipo",null,"Coste (USD)","Coste de manteniento (% del coste del equipo","Vida util (años)","Costo total (USD)","Coste amortizado por dia laborable (USD)",null,"Grupo geofono","Soundstick",null,null,null,null,"Coste diario de Inspeccion USD/dia","Coste de inspeccion USD/km"]
["Geofono",null,6800,0.05,5,{"$f":"C10*(1+D10)","v":7140},{"$f":"F10/(E10*$C$7)","v":5.7119999999999997},null,1,null,null,null,null,{"$f":"+I9","v":"Grupo geofono"},116.11199999999999,46.444800000000001]
["Sound Stick",null,360,0.05,5,{"$f":"C11*(1+D11)","v":378},0.3024,null,null,1,null,null,null,{"$f":"+J9","v":"Soundstick"},110.70240000000001,55.351200000000006]
["Caudalimetro Ultrasonido portatil",null,12000,0.05,5,12600,10.08,null,null,null,null,null,null,{"$f":"+K9","v":0},0,0]
["Data Logger",null,1550,0.05,5,1627.5,1.302,null,null,null,null,null,null,{"$f":"+L9","v":0},0,0]
["Detector de tuberia metalicas",null,8000,0.05,5,8400,6.72]
["Detector de tuberia no metalicas",null,8000,0.05,5,8400,6.72]
["Generador electrico portatil",null,2000,0.05,5,2100,1.68]
["Bomba centrifuga portatil",null,2500,0.05,5,2625,2.1]
["Recurso humano por equipo de trabajo",null,{"$f":"800*12","v":9600},null,null,9600,{"$f":"F18/($C$7)","v":38.4},null,2,2]
["Camioneta (Amortizacion y mantenimiento anual)",null,40000,0.05,5,42000,{"$f":"F19/(E19*$C$7)","v":33.6},null,1,1]
[null,null,null,null,null,null,null,"Coste (USD/dia)",{"$f":"(I10*$G$10)+($G$11*I11)+($G$12*I12)+(I13*$G$13)+($G$14*I14)+($G$15*I15)+($G$16*I16)+($G$17*I17)+($G$18*I18)+($G$19*I19)","v":116.11199999999999},{"$f":"(J10*$G$10)+($G$11*J11)+($G$12*J12)+(J13*$G$13)+($G$14*J14)+($G$15*J15)+($G$16*J16)+($G$17*J17)+($G$18*J18)+($G$19*J19)","v":110.70240000000001},0,0]
[null,null,null,null,null,null,null,"Red inspeccionada (Km/dia)",2.5,2]
["Grupos de trabajo a utilizar",null,"Cant","Coste (USD/dia)","Longitud de red inspeccionada diaria (km/dia)"]
["Elegir:","Grupo geofono",1,{"$f":"IFERROR((C23*HLOOKUP(B23,I9:L21,12,FALSE)),0)","v":116.11199999999999},{"$f":"IFERROR((HLOOKUP(B23,I9:L21,13,FALSE)),0)","v":2.5}]
[]
["Resultados",null,"Coste","Unidades"]
["Coste diario de inspeccion ",null,{"$f":"+D23","v":116.11199999999999},"USD/dia"]
["Coste de inspeccion por km",null,{"$f":"IFERROR((D23/E23),0)","v":46.444800000000001},"USD/km"]
[]
[]
[]
[]
[]
["Desglose de costes",null,"Coste","Unidades"]
["Costes de produccion",null,0.06,"USD/m3"]
["Costes de distribucion",null,0,"USD/m3"]
["Costes de capital",null,0,"USD/m3"]
["Costes ambientales",null,0,"USD/m3"]
["Total",null,{"$f":"+SUM(C34:C37)","v":0.06},"USD/m3"]
[]
["Ingreso manual",null,0.06,"USD/m3"]
[]
["Coste marginal del agua"]
["Elegir:","Manual",{"$f":"+IF(B43=A44,C38,IF(B43=A45,C40,0))","v":0.06},"USD/m3"]
["Desglose"]
["Manual"]

{"sheet":"Rot. Not","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,4,1],[6,1,9,1],[1,6,1,7]]}
[]
[null,"Tuberias","m3/hora/rot.","dia","m3/rot",null,"Valores a 50 mca"]
[null,null,36,1,{"$f":"C3*24*D3","v":864}]
[null,null,12,3,{"$f":"C4*24*D4","v":864}]
[null,null,1,2,{"$f":"C5*24*D5","v":48}]
[]
[null,"Acometidas","m3/hora/rot.","dia","m3/rot"]
[null,null,1.6,8,{"$f":"C8*24*D8","v":307.20000000000005}]
[null,null,0.8,16,307.20000000000005]
[null,null,1,2,48]

{"sheet":"Q nocturnos","index":6,"n_rows":371,"n_cols":62,"rows_kept":371,"cut":false,"hidden":false,"merged":[[4,13,4,36],[4,38,4,61]]}
[]
[null,"Poblacion",1000]
[null,"Uso",0.01]
[null,"% activo",0.06]
[null,null,null,null,null,null,null,null,null,"NDF Calculado",null,"Vol fugado ajustado (m3/dia)",null,"CAUDALES (m3/h)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESIONES"]
["Día","Caudal minimo ","Caudal consumido estimado","Hora minimo consumo ","Presion Maxima","Presion Promedio","NDF Calculado","NDF Asumido","NNF","Vol fugado calculado (m3/dia)","Vol fugado ajustado (m3/dia)","Vol fugado escogido (m3/dia)",null,"00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00",null,"00:00:00","01:00:00","02:00:00","03:00:00","04:00:00","05:00:00","06:00:00","07:00:00","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","23:00:00"]
[1,{"$f":"MIN(N7:AK7)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B7,N7:AK7,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM7:BJ7,MATCH(B7,N7:AK7,0)),\"-\")","v":"-"},{"$f":"IFERROR(AVERAGE(AM7:BJ7),\"-\")","v":"-"},{"$f":"IFERROR(24*(F7/E7),\"-\")","v":"-"},null,{"$f":"IFERROR(B7-C7,\"-\")","v":-0.6},{"$f":"IFERROR(IF($J$5=$G$6,G7*I7,IF($J$5=$H$6,H7*I7,\"Seleccionar NDF\")),\"-\")","v":"-"},null,{"$f":"+IF($L$5=$J$6,J7,IF($L$5=$K$6,K7,\"-\"))","v":0}]
[2,{"$f":"MIN(N8:AK8)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM8:BJ8),\"-\")","v":"-"},{"$f":"IFERROR(24*(F8/E8),\"-\")","v":"-"},null,{"$f":"IFERROR(B8-C8,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J8,IF($L$5=$K$6,K8,\"-\"))","v":0}]
[3,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[4,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[5,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[6,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[7,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[8,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[9,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[10,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[11,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[12,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[13,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[14,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[15,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[16,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[17,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[18,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[19,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[20,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[21,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[22,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[23,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[24,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[25,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[26,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[27,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[28,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[29,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[30,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[31,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[32,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[33,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[34,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[35,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[36,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[37,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[38,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[39,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[40,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[41,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[42,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[43,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[44,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[45,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[46,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[47,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[48,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[49,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[50,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[51,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[52,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[53,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[54,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[55,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[56,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[57,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[58,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[59,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[60,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[61,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[62,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[63,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[64,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[65,0,0.6,{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B71,N71:AK71,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM71:BJ71,MATCH(B71,N71:AK71,0)),\"-\")","v":"-"},"-","-",null,-0.6,{"$f":"IFERROR(IF($J$5=$G$6,G71*I71,IF($J$5=$H$6,H71*I71,\"Seleccionar NDF\")),\"-\")","v":"-"},null,0]
[66,{"$f":"MIN(N72:AK72)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM72:BJ72),\"-\")","v":"-"},{"$f":"IFERROR(24*(F72/E72),\"-\")","v":"-"},null,{"$f":"IFERROR(B72-C72,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J72,IF($L$5=$K$6,K72,\"-\"))","v":0}]
[67,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[68,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[69,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[70,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[71,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[72,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[73,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[74,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[75,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[76,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[77,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[78,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[79,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[80,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[81,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[82,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[83,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[84,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[85,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[86,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[87,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[88,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[89,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[90,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[91,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[92,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[93,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[94,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[95,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[96,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[97,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[98,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[99,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[100,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[101,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[102,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[103,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[104,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[105,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[106,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[107,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[108,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[109,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[110,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[111,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[112,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[113,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[114,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[115,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[116,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[117,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[118,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[119,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[120,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[121,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[122,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[123,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[124,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[125,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[126,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[127,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[128,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[129,0,0.6,{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B135,N135:AK135,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM135:BJ135,MATCH(B135,N135:AK135,0)),\"-\")","v":"-"},"-","-",null,-0.6,{"$f":"IFERROR(IF($J$5=$G$6,G135*I135,IF($J$5=$H$6,H135*I135,\"Seleccionar NDF\")),\"-\")","v":"-"},null,0]
[130,{"$f":"MIN(N136:AK136)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM136:BJ136),\"-\")","v":"-"},{"$f":"IFERROR(24*(F136/E136),\"-\")","v":"-"},null,{"$f":"IFERROR(B136-C136,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J136,IF($L$5=$K$6,K136,\"-\"))","v":0}]
[131,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[132,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[133,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[134,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[135,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[136,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[137,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[138,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[139,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[140,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[141,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[142,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[143,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[144,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[145,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[146,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[147,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[148,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[149,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[150,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[151,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[152,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[153,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[154,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[155,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[156,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[157,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[158,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[159,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[160,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[161,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[162,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[163,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[164,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[165,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[166,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[167,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[168,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[169,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[170,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[171,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[172,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[173,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[174,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[175,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[176,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[177,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[178,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[179,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[180,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[181,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[182,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[183,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[184,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[185,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[186,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[187,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[188,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[189,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[190,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[191,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[192,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[193,0,0.6,{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B199,N199:AK199,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM199:BJ199,MATCH(B199,N199:AK199,0)),\"-\")","v":"-"},"-","-",null,-0.6,{"$f":"IFERROR(IF($J$5=$G$6,G199*I199,IF($J$5=$H$6,H199*I199,\"Seleccionar NDF\")),\"-\")","v":"-"},null,0]
[194,{"$f":"MIN(N200:AK200)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM200:BJ200),\"-\")","v":"-"},{"$f":"IFERROR(24*(F200/E200),\"-\")","v":"-"},null,{"$f":"IFERROR(B200-C200,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J200,IF($L$5=$K$6,K200,\"-\"))","v":0}]
[195,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[196,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[197,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[198,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[199,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[200,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[201,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[202,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[203,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[204,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[205,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[206,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[207,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[208,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[209,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[210,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[211,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[212,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[213,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[214,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[215,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[216,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[217,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[218,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[219,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[220,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[221,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[222,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[223,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[224,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[225,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[226,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[227,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[228,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[229,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[230,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[231,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[232,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[233,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[234,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[235,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[236,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[237,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[238,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[239,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[240,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[241,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[242,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[243,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[244,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[245,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[246,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[247,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[248,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[249,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[250,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[251,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[252,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[253,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[254,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[255,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[256,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[257,0,0.6,{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B263,N263:AK263,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM263:BJ263,MATCH(B263,N263:AK263,0)),\"-\")","v":"-"},"-","-",null,-0.6,{"$f":"IFERROR(IF($J$5=$G$6,G263*I263,IF($J$5=$H$6,H263*I263,\"Seleccionar NDF\")),\"-\")","v":"-"},null,0]
[258,{"$f":"MIN(N264:AK264)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM264:BJ264),\"-\")","v":"-"},{"$f":"IFERROR(24*(F264/E264),\"-\")","v":"-"},null,{"$f":"IFERROR(B264-C264,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J264,IF($L$5=$K$6,K264,\"-\"))","v":0}]
[259,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[260,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[261,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[262,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[263,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[264,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[265,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[266,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[267,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[268,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[269,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[270,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[271,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[272,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[273,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[274,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[275,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[276,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[277,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[278,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[279,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[280,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[281,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[282,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[283,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[284,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[285,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[286,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[287,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[288,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[289,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[290,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[291,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[292,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[293,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[294,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[295,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[296,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[297,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[298,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[299,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[300,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[301,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[302,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[303,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[304,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[305,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[306,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[307,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[308,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[309,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[310,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[311,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[312,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[313,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[314,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[315,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[316,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[317,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[318,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[319,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[320,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[321,0,0.6,{"$f":"IFERROR(INDEX($N$6:$AK$6,MATCH(B327,N327:AK327,0)),\"-\")","v":"-"},{"$f":"IFERROR(INDEX(AM327:BJ327,MATCH(B327,N327:AK327,0)),\"-\")","v":"-"},"-","-",null,-0.6,{"$f":"IFERROR(IF($J$5=$G$6,G327*I327,IF($J$5=$H$6,H327*I327,\"Seleccionar NDF\")),\"-\")","v":"-"},null,0]
[322,{"$f":"MIN(N328:AK328)","v":0},{"$f":"$C$2*$C$4*$C$3","v":0.6},"-","-",{"$f":"IFERROR(AVERAGE(AM328:BJ328),\"-\")","v":"-"},{"$f":"IFERROR(24*(F328/E328),\"-\")","v":"-"},null,{"$f":"IFERROR(B328-C328,\"-\")","v":-0.6},"-",null,{"$f":"+IF($L$5=$J$6,J328,IF($L$5=$K$6,K328,\"-\"))","v":0}]
[323,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[324,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[325,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[326,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[327,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[328,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[329,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[330,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[331,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[332,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[333,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[334,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[335,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[336,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[337,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[338,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[339,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[340,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[341,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[342,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[343,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[344,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[345,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[346,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[347,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[348,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[349,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[350,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[351,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[352,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[353,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[354,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[355,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[356,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[357,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[358,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[359,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[360,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[361,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[362,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[363,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[364,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]
[365,0,0.6,"-","-","-","-",null,-0.6,"-",null,0]

{"sheet":"Vol mensual","index":8,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Mes","Volumen inyectado mensual","Volumen facturado mensual","Vol fugado (m3/mes)"]
[1,null,null,{"$f":"IFERROR(B6-C6,\"-\")","v":0}]
[2,null,null,{"$f":"IFERROR(B7-C7,\"-\")","v":0}]
[3,null,null,0]
[4,null,null,0]
[5,null,null,0]
[6,null,null,0]
[7,null,null,0]
[8,null,null,0]
[9,null,null,0]
[10,null,null,0]
[11,null,null,0]
[12,null,null,0]
[]
[]
[null,null,"m3/mes/mes"]
[null,{"$f":"+B20/(30*30)","v":0},"m3/dia/dia"]

{"sheet":"ELL (Método 2)","index":9,"n_rows":26,"n_cols":24,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,4,2,10],[2,12,2,16],[3,16,4,16]]}
[null,null,null,null,null,"Basico 1","Basico 2","Intermedio","Avanzado"]
[]
[null,"INFORMACION",null,null,"EARL",null,null,null,null,null,null,null,"UARL",null,null,null,null,null,"ELL"]
[]
[null,null,null,null,"Basico 1"]
[null,"Codigo","Sector Analizado / Direccion",null,"NRR (m3/año/año)","Longitud de tuberia (km)","Costes de intervencion (USD)","Coste del agua (USD/m3)","Frecuencia Optima de Inspeccion (Años)","Porcentaje Anualmente Inspeccionado","Perdidas Reales Anuales Economicas (EARL) (m3)",null,"Longitud de tuberias (km)","Longitud de acometidas (km)","Numero de acometidas","Presion promedio (mca)","Perdidas Reales Anuales Inevitables (\"UARL\") (m3)",null,"ELL (m3)",null,null,"Metodo 1","Metodo 2","Diferencia"]
[null,"CTC-029","Brasil - Av. Quito - Calle 22 SO - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C7,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C7,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C7,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C7,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":8592.3226328177552},11.778969999999999,{"$f":"Costes!$C$3*'ELL (Método 2)'!F7","v":547.07190585599994},{"$f":"+Costes!$C$2","v":0.06},{"$f":"IFERROR(SQRT((2*G7)/(H7*E7)),\"-\")","v":1.456821328268139},{"$f":"IFERROR(100/I7,\"-\")","v":68.642597454884495},{"$f":"IFERROR(J7*G7/H7/100,\"-\")","v":6258.7394354249782},null,11.778969999999999,0.6603,842,{"$f":"20.9-1","v":19.899999999999999},{"$f":"IFERROR((18*M7+0.8*O7+25*N7)*P7*(365/1000),\"-\")","v":6552.6137009600006},null,{"$f":"IFERROR(K7+Q7,\"-\")","v":12811.35313638498},null,null,{"$f":"+ELL!AC7","v":13288.538881876517},{"$f":"+S7","v":12811.35313638498},{"$f":"+ABS(V7-W7)","v":477.18574549153709}]
[null,"CTC-030","Calle 22 SO - Av. Quito - Venezuela - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C8,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C8,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C8,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C8,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":9214.8068140551459},13.110799999999999,{"$f":"Costes!$C$3*'ELL (Método 2)'!F8","v":608.92848384000001},{"$f":"+Costes!$C$2","v":0.06},{"$f":"IFERROR(SQRT((2*G8)/(H8*E8)),\"-\")","v":1.484155480096446},{"$f":"IFERROR(100/I8,\"-\")","v":67.3783854461809},{"$f":"IFERROR(J8*G8/H8/100,\"-\")","v":6838.1030155550097},null,13.110799999999999,0.43447000000000002,903,{"$f":"20.9-1","v":19.899999999999999},{"$f":"IFERROR((18*M8+0.8*O8+25*N8)*P8*(365/1000),\"-\")","v":7040.192045525001},null,13878.295061080011,null,null,{"$f":"+ELL!AC8","v":16172.892119562344},{"$f":"+S8","v":13878.295061080011},{"$f":"+ABS(V8-W8)","v":2294.5970584823335}]
[null,"CTC-031","Venezuela - Av. Quito - Vacas Galindo - Tungurahua",null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C9,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C9,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C9,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C9,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":12541.525553127101},12.784879999999999,{"$f":"Costes!$C$3*'ELL (Método 2)'!F9","v":593.79119462400001},{"$f":"+Costes!$C$2","v":0.06},1.2562644364614348,79.601075297230892,7877.7362656829519,null,12.784879999999999,0.14069000000000001,1229,19.899999999999999,8838.554311214999,null,16716.290576897951,null,null,{"$f":"+ELL!AC9","v":15745.580372967985},{"$f":"+S9","v":16716.290576897951},970.71020392996616]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C10,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C10,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C10,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C10,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F10","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,{"$f":"IFERROR((18*M10+0.8*O10+25*N10)*P10,\"-\")","v":0},null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C11,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C11,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C11,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C11,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F11","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C12,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C12,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C12,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C12,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F12","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C13,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C13,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C13,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C13,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F13","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C14,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C14,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C14,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C14,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F14","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C15,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C15,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C15,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C15,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F15","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C16,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C16,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C16,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C16,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F16","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C17,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C17,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C17,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C17,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F17","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C18,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C18,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C18,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C18,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F18","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C19,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C19,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C19,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C19,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F19","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C20,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C20,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C20,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C20,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F20","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C21,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C21,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C21,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C21,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F21","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C22,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C22,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C22,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C22,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F22","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C23,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C23,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C23,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C23,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F23","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C24,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C24,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C24,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C24,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F24","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C25,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C25,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C25,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C25,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F25","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]
[null,null,null,null,{"$f":"IFERROR((IF($E$5=$F$1,VLOOKUP(C26,NRR!$C$9:$Y$28,3,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$G$1,VLOOKUP(C26,NRR!$C$9:$Y$28,7,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$H$1,VLOOKUP(C26,NRR!$C$9:$Y$28,19,FALSE),IF('ELL (Método 2)'!$E$5='ELL (Método 2)'!$I$1,VLOOKUP(C26,NRR!$C$9:$Y$28,22,FALSE),\"Elegir Metodo\"))))),\"-\")","v":"-"},null,{"$f":"Costes!$C$3*'ELL (Método 2)'!F26","v":0},{"$f":"+Costes!$C$2","v":0.06},"-","-","-",null,null,null,null,null,0,null,"-"]

{"sheet":"Sensibilidad N1","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sensibilidad Presion","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sensibilidad CI","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sensibilidad CA","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}