{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ID_Carreteras","CostInv-Tipo","Longitud-PIB regional","variables soc-leg","Valores_GEO_Areas","Valores Filtro Var GEO","Valores Filtro Var NO GEO","Panel Pesos","resultados","fig2","Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":2,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ID_Carreteras","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["ID","PAIS","TRAMO","CARRETERA"]
[1,"Ecuador","Via al Emblase Compensador","Via al Emblase Compensador. Coca Codo Sinclair"]
[2,"Ecuador","Coca - La Belleza","Coca - La Belleza"]
[3,"Ecuador","Sucua - Bella Unión","Cuenca  -Macas"]
[4,"Ecuador","Cangaime - Taisha","Macuma - Taisha"]
[5,"Ecuador","Loreto - Murialdo","Sucumbios - Orellana"]
[6,"Ecuador","Sardina - Lumbaqui","Lumbaqui - Maderos - Sardina - Puccuna"]
[7,"Ecuador","Chuchumbletza - Ingreso Proyecto Mirador","Vía Acceso: Puerto Mirador"]
[8,"Ecuador","Sushufindi - Pto. Providencia","Sushufindi - Pto. Providencia"]
[9,"Ecuador","Sacha - Unión Milagreña","Sacha - Unión Milagreña"]
[10,"Ecuador","Macuma - Cangaime","Macuma - Taisha"]
[11,"Colombia","Variante San Francisco - Mocoa","Pasto - Mocoa"]
[12,"Colombia","Nuquí - El Afirmado","Nuquí - Las Ánimas"]
[13,"Colombia","El Dorado - La Uribe","Transversal de la Macarena"]
[14,"Colombia","Palo de Letras - Cacarica - Lomas Aisladas","Transversal de las Américas"]
[15,"Colombia","Tobiagrande/Villeta - El Korán","Ruta del Sol , Sector 1 "]
[16,"Colombia","Puerto Salgar - San Roque","Ruta del Sol, Sector 2"]
[17.100000000000001,"Colombia","San Roque - Ye de Ciénaga","Ruta del Sol, Sector 3"]
[17.2,"Colombia","Carmen de Bolivar - Valledupar","Ruta del Sol, Sector 3"]
[18,"Brasil","KM 555 a KM 767","BR-156"]
[19,"Brasil","Km 0 a Km 651","BR-163"]
[20,"Brasil","KM 152 a KM 984","BR-230"]
[21,"Brasil","Km 119 a 165","BR-432"]
[22,"Brasil","Km 203 a 318","BR-308"]
[23,"Brasil","Km 0 a 61,30","BR-422"]
[24,"Brasil","KM 250 a KM 655","BR-319"]
[25,"Bolivia","Isinuta - Monte Grande","Villa Tunari - San Ignacio de Moxos"]
[26,"Bolivia","Porvenir - El Chorro","Porvenir - El Chorro"]
[27,"Bolivia","Pumasani - Pelechuco","Pumasani - Pelechuco"]
[28,"Bolivia","Apolo - Ixiamas","Apolo - Ixiamas"]
[29,"Bolivia","Rio Yata - El Chorro","Rio Yata - El Chorro"]
[30,"Bolivia","Chiata - Lurasani","Chiata - Lurasani"]
[31,"PERÚ","SANTA MARÍA DE NIEVA-SARAMERIZA","REPOSO SARAMIRIZA"]
[32,"PERÚ","PUCALLPA-FRONTERA CON BRASIL","INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL"]
[33,"PERU","TRAMO 2","IIRSA SUR"]
[34,"PERÚ","SANTA TERESA-MACHU PICCHU","SANTA MARÍA-SANTA TERESA-MACHU PICCHU"]
[35,"PERÚ","PURUS-IÑAPARI","PURUS-IÑAPARI"]
[36,"PERÚ","IBERIA- ITAHUANIA-LD CUSCO","IBERIA- ITAHUANIA-LD CUSCO"]

{"sheet":"CostInv-Tipo","index":1,"n_rows":43,"n_cols":31,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["ID","Nombre carretera:","Región/Estado: ","País:","Nombre del tramo carretero que será evaluado:","Monto","Moneda","Monto","Moneda","Año estimación",1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,"Costos de inversión en $us al 2010","Calificacion","Distancia en Km:","Costo/km","Calificación (costo/km)","Categories","Frequencia","Tipo de inversión","Calificacion"]
[1,"Via al Emblase Compensador. Coca Codo Sinclair","Amazonia","Ecuador","Via al Emblase Compensador. ",45000000,"USD",{"$f":"F2","v":45000000},"$us",2009,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H2","v":45000000},{"$f":"V2*D43","v":45990000},{"$f":"IF(W2>1000000000,5,IF(W2>500000000,4,IF(W2>100000000,3,IF(W2>50000000,2,1))))","v":1},30,{"$f":"W2/Y2","v":1533000},{"$f":"IF(Z2<$AB$2,1,IF(Z2<$AB$3,2,IF(Z2<$AB$4,3,IF(Z2<$AB$5,4,5))))","v":3},500000,{"$f":"FREQUENCY(Z2:Z37,AB2:AB6)","v":8},"Carretera nueva",5]
[2,"Coca - La Belleza","Amazonia","Ecuador","Coca - La Belleza",11310000,"USD",11310000,"$us",2007,null,null,null,null,null,null,null,null,null,{"$f":"H3","v":11310000},{"$f":"T3*$D$43","v":11558820},11813114.040000001,12073002.548880002,{"$f":"IF(W3>1000000000,5,IF(W3>500000000,4,IF(W3>100000000,3,IF(W3>50000000,2,1))))","v":1},26,{"$f":"W3/Y3","v":464346.25188000005},{"$f":"IF(Z3<$AB$2,1,IF(Z3<$AB$3,2,IF(Z3<$AB$4,3,IF(Z3<$AB$5,4,5))))","v":1},1000000,13,"Mejoramiento de carretera",1]
[3,"Cuenca  -Macas","Amazonia","Ecuador","Sucua - Bella Unión",12940201,"USD",12940201,"$us",2001,null,null,null,{"$f":"H4","v":12940201},{"$f":"N4*$D$43","v":13224885.422},13515832.901284,13813181.225112248,14117071.212064719,14427646.778730143,14745055.007862207,15069446.218035175,15400974.034831949,15739795.463598251,1,45,349773.23252440558,1,2000000,9,"Mejoramiento de carretera",1]
[4,"Macuma - Taisha","Amazonia","Ecuador","Cangaime - Taisha",6584681,"USD",6584681,"$us",1998,{"$f":"H5","v":6584681},{"$f":"K5*$D$43","v":6729543.9819999998},{"$f":"L5*$D$43","v":6877593.949604},{"$f":"M5*$D$43","v":7028901.0164952883},7183536.8388581844,7341574.6493130643,7503089.2915979521,7668157.2560131075,7836856.7156453962,8009267.5633895947,8185471.4497841662,8365551.821679418,8549593.9617563654,1,25.33,337528.38380404131,1,5000000,3,"Carretera nueva",5]
[5,"Sucumbios - Orellana","Amazonia","Ecuador","Loreto - Murialdo",5000000,"USD",5000000,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H6","v":5000000},1,10,500000,2,"more",3,"Mejoramiento de carretera",1]
[6,"Lumbaqui - Maderos - Sardina - Puccuna","Amazonia","Ecuador","Sardina - Lumbaqui",23375651.77,"USD",23375651.77,"$us",2007,null,null,null,null,null,null,null,null,null,{"$f":"H7","v":23375651.77},{"$f":"T7*$D$43","v":23889916.108940002},{"$f":"U7*$D$43","v":24415494.263336681},{"$f":"V7*$D$43","v":24952635.137130089},1,73,341816.91968671355,1,null,null,"Carretera nueva",5]
[7,"Vía Acceso: Puerto Mirador","Amazonia","Ecuador","Chuchumbletza - Ingreso Proyecto Mirador","Entre 14.000.000 y 16.000.000","USD",15000000,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H8","v":15000000},1,14,1071428.5714285714,3,null,null,"Mejoramiento de carretera",1]
[8,{"$f":"[1]Entrada!M5","v":"Ecuador"},"Amazonia","Ecuador","Sushufindi - Pto. Providencia",30281057.52,"USD",{"$f":"F9","v":30281057.52},"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H9","v":30281057.52},1,46,658283.85913043481,2,null,null,"Mejoramiento de carretera",1]
[9,"Sacha - Unión Milagreña","Amazonia","Ecuador","Sacha - Unión Milagreña",62500000,"USD",{"$f":"F10","v":62500000},"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,62500000,2,12.5,5000000,5,null,null,"Mejoramiento de carretera",1]
[10,"Macuma - Taisha","Amazonia","Ecuador","Macuma - Cangaime",16374927.300000001,"USD",{"$f":"F11","v":16374927.300000001},"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,16374927.300000001,1,42.55,384839.65452408936,1,null,null,"Carretera nueva",5]
[11,"Pasto - Mocoa","Amazonía","Colombia","Variante San Francisco - Mocoa","450,000,000,000","Pesos",{"$f":"F12/$D$40","v":250000000},"$us",2009,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H12","v":250000000},{"$f":"V12*$D$43","v":255500000},3,45.6,5603070.1754385959,5,null,null,"Carretera nueva",5]
[12,"Nuquí - Las Ánimas","Chocó","Colombia","Nuquí - El Afirmado"," 100,228,065,354.60","Pesos",55682258.53033334,"$us",2008,null,null,null,null,null,null,null,null,null,null,{"$f":"H13","v":55682258.53033334},{"$f":"U13*$D$43","v":56907268.218000673},{"$f":"V13*$D$43","v":58159228.118796691},2,57,1020337.3354174858,3,null,null,"Carretera nueva",5]
[13,"Transversal de la Macarena (Baraya , Huila - San Juan de Arama, Meta)","Meta y Huila","Colombia","El Dorado - La Uribe",169930000000,"Pesos",94405555.555555552,"$us",2009,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H14","v":94405555.555555552},{"$f":"V14+$D$43","v":94405556.577555552},2,66.599999999999994,1417500.8495128462,3,null,null,"Carretera nueva",5]
[14,"Transversal de las Américas , Sector 1 Corredor Vial del Caribe","Caribe","Colombia","Palo de Letras - Cacarica - Lomas Aisladas","1,158,081,139,000","Pesos",643378410.55555558,"$us",2008,null,null,null,null,null,null,null,null,null,null,{"$f":"H15","v":643378410.55555558},{"$f":"U15*$D$43","v":657532735.58777785},671998455.77070904,4,62,10838684.770495307,5,null,null,"Carretera nueva",5]
[15,"Ruta del Sol , Sector 1 ","Caribe  - Andina","Colombia","Tobiagrande/Villeta - El Korán","962,075,973,782","Pesos",534486652.10111111,"$us",2008,null,null,null,null,null,null,null,null,null,null,534486652.10111111,546245358.4473356,558262756.33317697,4,77.900000000000006,7166402.5203231955,5,null,null,"Carretera nueva",5]
[16,"Ruta del Sol, Sector 2","Dto. Cundinamarca - Dto del Cesar - Valle del Río Magdalena","Colombia","Puerto Salgar - San Roque (Etapa 1: Tramo 1, 5 y 6)"," 2,094,286,000,000","Pesos",1163492222.2222223,"$us",2008,null,null,null,null,null,null,null,null,null,null,1163492222.2222223,1189089051.1111112,1215249010.2355556,5,528,2301607.9739309768,4,null,null,"Carretera nueva",5]
[17,"Ruta del Sol, Sector 3","Caribe","Colombia","San Roque - Ye de Ciénaga / Carmen de Bolivar - Valledupar"," 2,079,953,197,851","Pesos",1155529554.3616667,"$us",2008,null,null,null,null,null,null,null,null,null,null,1155529554.3616667,1180951204.5576234,1206932131.0578911,5,465,2595552.9700169703,4,null,null,"Carretera nueva",5]
[18,"BR-156","Amapa","Brasil","KM 555 a KM 767",432783094,"Real",{"$f":"F19/$D$41","v":272190625.1572327},"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H19","v":272190625.1572327},3,152,1790727.7970870573,3,null,null,"Mejoramiento de carretera",1]
[19,"BR-163","Para","Brasil","Km 0 a Km 651",1400000000,"Real",880503144.65408802,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H20","v":880503144.65408802},4,651,1352539.3927098126,3,null,null,"Mejoramiento de carretera",1]
[20,"BR-230","Para","Brasil","KM 152 a KM 984",1200000000,"Real",754716981.13207543,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,754716981.13207543,4,832,907111.75616835989,2,null,null,"Mejoramiento de carretera",1]
[21,"BR-432","Roraima","Brasil","Km 119 a 165",66274971.920000002,"Real",41682372.276729561,"$us",2009,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H22","v":41682372.276729561},{"$f":"V22*$D$43","v":42599384.46681761},1,46.24,921266.9651128375,2,null,null,"Carretera nueva",5]
[22,"BR-308","Para","Brasil","Km 203 a 318",146748641,"Real",92294742.767295599,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H23","v":92294742.767295599},2,163,566225.41575027979,2,null,null,"Mejoramiento de carretera",1]
[23,"BR-422","Para","Brasil","Km 0 a 61,30",93000000,"Real",58490566.03773585,"$us",2009,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H24","v":58490566.03773585},{"$f":"V24*D43","v":59777358.490566038},2,61.3,975160.82366339385,2,null,null,"Carretera nueva",5]
[24,"BR-319","Amazonas","Brasil","KM 250 a KM 655",487831257,"Real",306812111.32075471,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H25","v":306812111.32075471},3,405,757560.7686932215,2,null,null,"Carretera nueva",5]
[25,"Villa Tunari - San Ignacio de Moxos","El Beni y Cochabamba","Bolivia","Isinuta - Monte Grande",219753000,"$us",{"$f":"F26","v":219753000},"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H26","v":219753000},3,145,1515537.9310344828,3,null,null,"Carretera nueva",5]
[26,"Porvenir - El Chorro","Pando","Bolivia","Porvenir - El Chorro",201000000,"$us",201000000,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H27","v":201000000},3,337,596439.1691394659,2,null,null,"Mejoramiento de carretera",1]
[27,"Pumasani - Pelechuco","La Paz","Bolivia","Pumasani - Pelechuco",33864954,"$us",33864954,"$us",2008,null,null,null,null,null,null,null,null,null,null,{"$f":"H28","v":33864954},{"$f":"U28*$D$43","v":34609982.987999998},{"$f":"V28*$D$43","v":35371402.613735996},1,91,388696.73201907688,1,null,null,"Mejoramiento de carretera",1]
[28,"Apolo - Ixiamas","La Paz","Bolivia","Apolo - Ixiamas",99999999,"$us",99999999,"$us",1999,null,{"$f":"H29","v":99999999},{"$f":"L29*$D$43","v":102199998.978},104448398.955516,106746263.73253734,109094681.53465317,111494764.52841555,113947649.34804069,116454497.63369758,119016496.58163893,121634859.50643499,{"$f":"U29*$D$43","v":124310826.41557656},{"$f":"V29*$D$43","v":127045664.59671925},3,202,628938.93364712503,2,null,null,"Carretera nueva",5]
[29,"Rio Yata - El Chorro","El Beni ","Bolivia","Rio Yata - El Chorro",316800000,"$us",316800000,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H30","v":316800000},3,264,1200000,3,null,null,"Mejoramiento de carretera",1]
[30,"Chiata - Lurasani","La Paz","Bolivia","Chiata - Lurasani",250000,"$us",250000,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H31","v":250000},1,25,10000,1,null,null,"Carretera nueva",5]
[31,"MEJORAMIENTO Y CONSTRUCCIÓN DE LA CARRETERA REPOSO SARAMIRIZA, SECTOR: REPOSO DURAN DEL EJE VIAL N° 4 DE INTERCONEXIÓN VIAL PERÚ ECUADOR.","AMAZONAS-LORETO","PERÚ","SANTA MARÍA DE NIEVA-SARAMERIZA",38725272,"US$",38725272,"$us",2004,null,null,null,null,null,null,{"$f":"H32","v":38725272},{"$f":"Q32*$D$43","v":39577227.983999997},40447926.999647997,41337781.393640257,42247212.584300347,43176651.261154957,44126537.588900365,1,69.400000000000006,635829.0718861724,2,null,null,"Carretera nueva",5]
[32,"INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL","UCAYALI","PERÚ","PUCALLPA-FRONTERA CON BRASIL (HITO Nº67)",78441042.799999997,"US$",78441042.799999997,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H33","v":78441042.799999997},2,95.6,820513,2,null,null,"Carretera nueva",5]
[33,"IIRSA SUR","CUSCO","PERU","TRAMO 2 (NUEVO TRAZO)",70136400,"US$",70136400,"$us",2010,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H34","v":70136400},2,63.3,1108000,3,null,null,"Carretera nueva",5]
[34,"SANTA MARÍA-SANTA TERESA-MACHU PICCHU","CUSCO","PERÚ","SANTA TERESA-MACHU PICCHU",10392000,"US$",10392000,"$us",2004,null,null,null,null,null,null,{"$f":"F35","v":10392000},{"$f":"Q35*$D$43","v":10620624},10854277.728,11093071.838016,11337119.418452352,11586536.045658303,11841439.838662786,1,12,986786.65322189883,2,null,null,"Carretera nueva",5]
[35,"CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104","MADRE DE DIOS-UCAYALI","PERÚ","CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104",93690000,"US$",93690000,"$us",2004,null,null,null,null,null,null,{"$f":"F36","v":93690000},95751180,97857705.960000008,100010575.49112001,102210808.15192465,104459445.93126699,106757553.74175487,3,180,593097.52078752709,2,null,null,"Carretera nueva",5]
[36,"CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103","MADRE DE DIOS","PERÚ","CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103 Y CU-113",187380000,"US$",187380000,"$us",2004,null,null,null,null,null,null,187380000,191502360,195715411.92000002,200021150.98224002,204421616.30384931,208918891.86253399,213515107.48350975,3,360,593097.52078752709,2,null,null,"Carretera nueva",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(Z2:Z37)","v":10000}]
[null,"Tipos de cambio","Colombia",{"$f":"1800","v":1800},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(Z2:Z37)","v":10838684.770495307}]
[null,null,"Brasil",{"$f":"1.59","v":1.59},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(Z2:Z37)","v":1609213.9699950523}]
[null,null,"Perú",2.72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MEDIAN(Z2:Z37)","v":914189.36064059869}]
[null,"Inflación anual",null,1.022]

{"sheet":"Longitud-PIB regional","index":2,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,5,1,6],[1,13,1,14]]}
[]
["ID","Nombre carretera:"," Región/Estado: ","País:","Nombre del tramo carretero que será evaluado:","PIB regional",null,"Año estimación","Distancia en Km:","Calificacion","Categorias","Frequencia","PIB regional / distancia","Participacion porcentual en el PIB agregado de las carreteras de cada pais",null,"Calificacion","Categorias","Frequencia"]
[1,"Via al Emblase Compensador. Coca Codo Sinclair","Amazonia","Ecuador","Via al Emblase Compensador. ",7557700,"USD",2007,30,{"$f":"IF(I3<50,1,IF(I3<100,2,IF(I3<200,3,IF(I3<400,4,5))))","v":1},50,13,{"$f":"F3/I3","v":251923.33333333334},"Ecuador",{"$f":"M3/$N$4","v":1.639136644140486E-3},{"$f":"J3","v":1},0.25,{"$f":"FREQUENCY(O3:O38,Q3:Q7)","v":6}]
[2,"Coca - La Belleza","Amazonia","Ecuador","Coca - La Belleza",2508375,"USD",2007,26,{"$f":"IF(I4<50,1,IF(I4<100,2,IF(I4<200,3,IF(I4<400,4,5))))","v":1},100,9,96475.961538461532,{"$f":"SUM(M3:M12)","v":153692698.06388494},{"$f":"M4/$N$4","v":6.2771987709110081E-4},{"$f":"IF(O4>25%,1,IF(O4>15%,2,IF(O4>10%,3,IF(O4>5%,4,5))))","v":5},0.15,{"$f":"FREQUENCY(O4:O39,Q4:Q8)","v":4}]
[3,"Cuenca  -Macas","Amazonia","Ecuador","Sucua - Bella Unión",176526,"USD",2007,45,1,200,4,3922.8,null,2.5523658894773404E-5,5,0.1,{"$f":"FREQUENCY(O5:O40,Q5:Q9)","v":4}]
[4,"Macuma - Taisha","Amazonia","Ecuador","Cangaime - Taisha",2331160000,"USD",2007,25.33,1,400,5,92031583.103039876,null,0.59880257333230891,1,0.05,{"$f":"FREQUENCY(O6:O41,Q6:Q10)","v":13}]
[5,"Sucumbios - Orellana","Amazonia","Ecuador","Loreto - Murialdo",233116000,"USD",2007,10,1,"more",5,23311600,null,0.15167669182507384,2,"less",{"$f":"36-R6-R5-R4-R3","v":9}]
[6,"Lumbaqui - Maderos - Sardina - Puccuna","Amazonia","Ecuador","Sardina - Lumbaqui",2158830,"USD",2007,73,2,null,null,29573.013698630137,null,1.9241651731780789E-4,5]
[7,"Vía Acceso: Puerto Mirador","Amazonia","Ecuador","Chuchumbletza - Ingreso Proyecto Mirador",141427000,"USD",2007,14,1,null,null,10101928.571428571,null,6.5728097031841654E-2,4]
[8,{"$f":"[1]Entrada!M5","v":"Ecuador"},"Amazonia","Ecuador","Sushufindi - Pto. Providencia",233116000,"USD",2007,46,1,null,null,5067739.1304347822,null,3.2973193875016051E-2,5]
[9,"Sacha - Unión Milagreña","Amazonia","Ecuador","Sacha - Unión Milagreña",233116000,"USD",2007,12.5,1,null,null,18649280,null,0.12134135346005907,3]
[10,"Macuma - Taisha","Amazonia","Ecuador","Macuma - Cangaime",176526000,"USD",2007,42.55,1,null,null,4148672.1504112813,null,2.6993293778256246E-2,5]
[11,"Pasto - Mocoa","Amazonía","Colombia","Variante San Francisco - Mocoa",167246801956.93356,"pesos col",0,45.6,1,null,null,3667693025.3713498,"Colombia",{"$f":"M13/$N$14","v":5.3112702023669536E-2},4]
[12,"Nuquí - Las Ánimas","Chocó","Colombia","Nuquí - El Afirmado",127789083725.44397,"pesos col",0,57,2,null,null,2241913749.5691924,{"$f":"SUM(M13:M19)","v":69054913149.341415},{"$f":"M14/$N$14","v":3.246566605218551E-2},5]
[13,"Transversal de la Macarena (Baraya , Huila - San Juan de Arama, Meta)","Meta y Huila","Colombia","El Dorado - La Uribe",228067814842.24719,"pesos col",0,66.599999999999994,2,null,null,3424441664.2980061,null,4.9590123397768193E-2,5]
[14,"Transversal de las Américas , Sector 1 Corredor Vial del Caribe","Caribe","Colombia","Palo de Letras - Cacarica - Lomas Aisladas",2224523436247.2881,"pesos col",0,62,2,null,null,35879410262.053032,null,0.51957795073115975,1]
[15,"Ruta del Sol , Sector 1 ","Caribe  - Andina","Colombia","Tobiagrande/Villeta - El Korán",845056211423.10706,"pesos col",0,77.900000000000006,2,null,null,10847961635.726662,null,0.15709181491932872,2]
[16,"Ruta del Sol, Sector 2","Dto. Cundinamarca - Dto del Cesar - Valle del Río Magdalena","Colombia","Puerto Salgar - San Roque (Etapa 1: Tramo 1, 5 y 6)",892402994284.75427,"pesos col",0,528,5,null,null,1690157186.1453679,null,2.4475552992010201E-2,5]
[17,"Ruta del Sol, Sector 3","Caribe","Colombia","San Roque - Ye de Ciénaga / Carmen de Bolivar - Valledupar",5256051066172.6768,"pesos col",0,465,5,null,null,11303335626.177799,null,0.16368618988387795,2]
[18,"BR-156","Amapa","Brasil","KM 555 a KM 767",279190341,"Real",2007,152,3,null,null,1836778.5592105263,"Brasil",{"$f":"M20/$N$21","v":8.814232739330647E-3},5]
[19,"BR-163","Para","Brasil","Km 0 a Km 651",899970384,"Real",2007,651,5,null,null,1382442.9861751152,{"$f":"SUM(M20:M26)","v":208387798.8624579},{"$f":"M21/$N$21","v":6.6339919790005001E-3},5]
[20,"BR-230","Para","Brasil","KM 152 a KM 984",1636167441,"Real",2007,832,5,null,null,1966547.405048077,null,9.4369603968323321E-3,5]
[21,"BR-432","Roraima","Brasil","Km 119 a 165",3132330332,"Real",2007,46.24,1,null,null,67740707.871972322,null,0.32507041315160295,1]
[22,"BR-308","Para","Brasil","Km 203 a 318",444537578,"Real",2007,163,3,null,null,2727224.4049079753,null,1.3087255682891607E-2,5]
[23,"BR-422","Para","Brasil","Km 0 a 61,30",2887908771,"Real",2007,61.3,2,null,null,47111072.936378472,null,0.22607404653030175,2]
[24,"BR-319","Amazonas","Brasil","KM 250 a KM 655",34677325003,"Real",2007,405,5,null,null,85623024.698765427,null,0.41088309952004026,1]
[25,"Villa Tunari - San Ignacio de Moxos","El Beni y Cochabamba","Bolivia","Isinuta - Monte Grande",89842646.799999997,"$US",1996,145,3,null,null,619604.46068965516,"Bolivia",{"$f":"M27/$N$28","v":0.33352908427834588},1]
[26,"Porvenir - El Chorro","Pando","Bolivia","Porvenir - El Chorro",90783881.300000012,"$US",1996,337,4,null,null,269388.37181008904,{"$f":"SUM(M27:M32)","v":1857722.4293056428},{"$f":"M28/$N$28","v":0.14501002278945288},3]
[27,"Pumasani - Pelechuco","La Paz","Bolivia","Pumasani - Pelechuco",9592138.6000000015,"$US",1996,91,2,null,null,105408.1164835165,null,5.6740509142108313E-2,4]
[28,"Apolo - Ixiamas","La Paz","Bolivia","Apolo - Ixiamas",24756760.600000001,"$US",1996,202,4,null,null,122558.22079207921,null,6.5972299660443656E-2,4]
[29,"Rio Yata - El Chorro","El Beni ","Bolivia","Rio Yata - El Chorro",94268516.900000006,"$US",1996,264,4,null,null,357077.71553030307,null,0.19221263085237514,2]
[30,"Chiata - Lurasani","La Paz","Bolivia","Chiata - Lurasani",9592138.6000000015,"$US",1996,25,1,null,null,383685.54400000005,null,0.20653545327727427,2]
[31,"MEJORAMIENTO Y CONSTRUCCIÓN DE LA CARRETERA REPOSO SARAMIRIZA, SECTOR: REPOSO DURAN DEL EJE VIAL N° 4 DE INTERCONEXIÓN VIAL PERÚ ECUADOR.","AMAZONAS-LORETO","PERÚ","SANTA MARÍA DE NIEVA-SARAMERIZA",4464545,"NUEVOS SOLES",2009,69.400000000000006,2,null,null,64330.619596541779,"Peru",{"$f":"M33/$N$34","v":0.11450632670754361},3]
[32,"INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL","UCAYALI","PERÚ","PUCALLPA-FRONTERA CON BRASIL (HITO Nº67)",1850376,"NUEVOS SOLES",2009,95.6,2,null,null,19355.397489539751,{"$f":"SUM(M33:M38)","v":561808.42968481767},{"$f":"M34/$N$34","v":3.4451952777565832E-2},5]
[33,"IIRSA SUR","CUSCO","PERU","TRAMO 2 (NUEVO TRAZO)",4664246,"NUEVOS SOLES",2009,63.3,2,null,null,73684.770932069514,null,0.13115639965282774,3]
[34,"SANTA MARÍA-SANTA TERESA-MACHU PICCHU","CUSCO","PERÚ","SANTA TERESA-MACHU PICCHU",4664246,"NUEVOS SOLES",2009,12,1,null,null,388687.16666666669,null,0.69185000816866626,1]
[35,"CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104","MADRE DE DIOS-UCAYALI","PERÚ","CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104",2506849,"NUEVOS SOLES",2009,180,3,null,null,13926.93888888889,null,2.4789480102144597E-2,5]
[36,"CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103","MADRE DE DIOS","PERÚ","CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103 Y CU-113",656473,"NUEVOS SOLES",2009,360,4,null,null,1823.536111111111,null,3.2458325912520397E-3,5]
[]
[]
[null,"Tipos de cambio","Colombia",{"$f":"1800","v":1800}]
[null,null,"Brasil",{"$f":"1.59","v":1.59}]
[null,null,"Perú",2.72]
[]
[null,"Inflación anual",null,1.022]

{"sheet":"variables soc-leg","index":3,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
["ID","Nombre carretera:","Región/Estado: ","País:","Nombre del tramo carretero que será evaluado:","Pueblos en aislamiento ","Calificacion","Posibilidad de danos arqueologicos","Calificacion"," Grado de rechazo de la población local afectada","Calificacion","Vulneraria la construccion de la carretera algun tipo de norma","Calificacion","Existencia de presion externa","Calificacion"]
[1,"Via al Emblase Compensador. Coca Codo Sinclair","Amazonia","Ecuador","Via al Emblase Compensador. ","No Existen",1,"Si Existen",5,"medio",{"$f":"IF(J3=\"muy bajo\",1,IF(J3=\"bajo\",2,IF(J3=\"medio\",3,IF(J3=\"alto\",4,5))))","v":3},"No",{"$f":"IF(L3=\"No\",1,5)","v":1},"medio",{"$f":"IF(N3=\"muy bajo\",1,IF(N3=\"bajo\",2,IF(N3=\"medio\",3,IF(N3=\"alto\",4,5))))","v":3}]
[2,"Coca - La Belleza","Amazonia","Ecuador","Coca - La Belleza","No Existen",1,"No Existen",1,"bajo",{"$f":"IF(J4=\"muy bajo\",1,IF(J4=\"bajo\",2,IF(J4=\"medio\",3,IF(J4=\"alto\",4,5))))","v":2},"No",{"$f":"IF(L4=\"No\",1,5)","v":1},"bajo",{"$f":"IF(N4=\"muy bajo\",1,IF(N4=\"bajo\",2,IF(N4=\"medio\",3,IF(N4=\"alto\",4,5))))","v":2}]
[3,"Cuenca  -Macas","Amazonia","Ecuador","Sucua - Bella Unión","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"medio",3]
[4,"Macuma - Taisha","Amazonia","Ecuador","Cangaime - Taisha","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"bajo",2]
[5,"Sucumbios - Orellana","Amazonia","Ecuador","Loreto - Murialdo","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"bajo",2]
[6,"Lumbaqui - Maderos - Sardina - Puccuna","Amazonia","Ecuador","Sardina - Lumbaqui","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"medio",3]
[7,"Vía Acceso: Puerto Mirador","Amazonia","Ecuador","Chuchumbletza - Ingreso Proyecto Mirador","No Existen",1,"No Existen",1,"medio",3,"No",1,"bajo",2]
[8,{"$f":"[1]Entrada!M5","v":"Ecuador"},"Amazonia","Ecuador","Sushufindi - Pto. Providencia","No Existen",1,"No Existen",1,"bajo",2,"No",1,"medio",3]
[9,"Sacha - Unión Milagreña","Amazonia","Ecuador","Sacha - Unión Milagreña","No Existen",1,"No Existen",1,"bajo",2,"No",1,"medio",3]
[10,"Macuma - Taisha","Amazonia","Ecuador","Macuma - Cangaime","No Existen",1,"No Existen",1,"bajo",2,"No",1,"medio",3]
[11,"Pasto - Mocoa","Amazonía","Colombia","Variante San Francisco - Mocoa","No Existen",1,"Existen",5,"medio",3,"No",1,"alto",4]
[12,"Nuquí - Las Ánimas","Chocó","Colombia","Nuquí - El Afirmado","No Existen",1,"No Existen",1,"medio",3,"Si",5,"bajo",2]
[13,"Transversal de la Macarena (Baraya , Huila - San Juan de Arama, Meta)","Meta y Huila","Colombia","El Dorado - La Uribe","No Existen",1,"No Existen",1,"bajo",2,"No",1,"bajo",2]
[14,"Transversal de las Américas , Sector 1 Corredor Vial del Caribe","Caribe","Colombia","Palo de Letras - Cacarica - Lomas Aisladas","No Existen",1,"No Existen",1,"muy alto",5,"Si",5,"muy alto",5]
[15,"Ruta del Sol , Sector 1 ","Caribe  - Andina","Colombia","Tobiagrande/Villeta - El Korán","No Existen",1,"Existen",5,"bajo",2,"No",1,"bajo",2]
[16,"Ruta del Sol, Sector 2","Dto. Cundinamarca - Dto del Cesar - Valle del Río Magdalena","Colombia","Puerto Salgar - San Roque (Etapa 1: Tramo 1, 5 y 6)","No Existen",1,"No Existen",1,"bajo",2,"No",1,"bajo",2]
[17,"Ruta del Sol, Sector 3","Caribe","Colombia","San Roque - Ye de Ciénaga / Carmen de Bolivar - Valledupar","No Existen",1,"No Existen",1,"bajo",2,"No",1,"bajo",2]
[18,"BR-156","Amapa","Brasil","KM 555 a KM 767","No Existen",1,"No Existen",1,"medio",3,"No",1,"bajo",2]
[19,"BR-163","Para","Brasil","Km 0 a Km 651","No Existen",1,"No Existen",1,"bajo",2,"No",1,"muy alto",5]
[20,"BR-230","Para","Brasil","KM 152 a KM 984","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"muy bajo",1]
[21,"BR-432","Roraima","Brasil","Km 119 a 165","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"muy bajo",1]
[22,"BR-308","Para","Brasil","Km 203 a 318","No Existen",1,"No Existen",1,"muy bajo",1,"Si",5,"muy bajo",1]
[23,"BR-422","Para","Brasil","Km 0 a 61,30","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"medio",3]
[24,"BR-319","Amazonas","Brasil","KM 250 a KM 655","No Existen",1,"No Existen",1,"muy bajo",1,"No",1,"medio",3]
[25,"Villa Tunari - San Ignacio de Moxos","El Beni y Cochabamba","Bolivia","Isinuta - Monte Grande","No Existen",1,"No Existen",1,"muy alto",5,"Si",5,"alto",4]
[26,"Porvenir - El Chorro","Pando","Bolivia","Porvenir - El Chorro","Existen",5,"No Existen",1,"medio",3,"No",1,"bajo",2]
[27,"Pumasani - Pelechuco","La Paz","Bolivia","Pumasani - Pelechuco","No Existen",1,"No Existen",1,"bajo",2,"No",1,"bajo",2]
[28,"Apolo - Ixiamas","La Paz","Bolivia","Apolo - Ixiamas","Existen",5,"No Existen",1,"alto",4,"Si",5,"medio",3]
[29,"Rio Yata - El Chorro","El Beni ","Bolivia","Rio Yata - El Chorro","Existen",5,"No Existen",1,"medio",3,"No",1,"bajo",2]
[30,"Chiata - Lurasani","La Paz","Bolivia","Chiata - Lurasani","No Existen",1,"No Existen",1,"bajo",2,"Si",5,"medio",3]
[31,"MEJORAMIENTO Y CONSTRUCCIÓN DE LA CARRETERA REPOSO SARAMIRIZA, SECTOR: REPOSO DURAN DEL EJE VIAL N° 4 DE INTERCONEXIÓN VIAL PERÚ ECUADOR.","AMAZONAS-LORETO","PERÚ","SANTA MARÍA DE NIEVA-SARAMERIZA","Existen",5,"No Existen",1,"bajo",2,"No",1,"medio",3]
[32,"INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL","UCAYALI","PERÚ","PUCALLPA-FRONTERA CON BRASIL (HITO Nº67)","Existen",5,"No Existen",1,"muy alto",5,"Si",5,"alto",4]
[33,"IIRSA SUR","CUSCO","PERU","TRAMO 2 (NUEVO TRAZO)","Existen",5,"No Existen",1,"medio",3,"Si",5,"alto",4]
[34,"SANTA MARÍA-SANTA TERESA-MACHU PICCHU","CUSCO","PERÚ","SANTA TERESA-MACHU PICCHU","No Existen",1,"Existen",5,"bajo",2,"Si",5,"muy bajo",1]
[35,"CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104","MADRE DE DIOS-UCAYALI","PERÚ","CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104","Existen",5,"No Existen",1,"muy alto",5,"Si",5,"muy bajo",1]
[36,"CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103","MADRE DE DIOS","PERÚ","CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103 Y CU-113","Existen",5,"No Existen",1,"bajo",2,"Si",5,"muy bajo",1]
[]
[]
[null,"Tipos de cambio","Colombia",{"$f":"1800","v":1800}]
[null,null,"Brasil",{"$f":"1.59","v":1.59}]
[]
[null,"Inflación anual",null,1.022]

{"sheet":"Valores_GEO_Areas","index":4,"n_rows":81,"n_cols":41,"rows_kept":81,"cut":false,"hidden":true,"merged":[[2,36,2,40],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,2,8],[2,9,2,10],[2,11,2,15],[2,16,2,20],[2,21,2,25],[2,26,2,30],[2,31,2,35]]}
["Area según rango asignado por carretera (ha)"]
[]
["A.3. Nombre carretera:","A.2. Región/Estado: ","A.1. País:","Carretera","Cobertura de arboles (Rangos)",null,null,null,null,"Humedales (Rangos)",null,"Balance hidrico promedio (Rangos)",null,null,null,null,"Intervencion Humana (Rangos)",null,null,null,null,"Prox areas de conservacion/terr indígenas (Rangos)",null,null,null,null,"Ingreso bruto por agricultura (Rangos)",null,null,null,null,"Pendiente (Rangos)",null,null,null,null,"Densidad poblacional (Rangos)"]
[null,null,null,null,1,2,3,4,5,1,5,1,2,3,4,5,1,2,3,4,5,1,2,3,4,5,5,4,3,2,1,1,2,3,4,5,5,4,3,2,1]
["Via al Emblase Compensador. Coca Codo Sinclair","Amazonia","Ecuador",1,4692,13489,34816,134813,13393,194729,11840,0,0,0,181504,25065,100,5745,79575,77778,43371,0,0,0,0,206569,9284,95478,45643,56164,0,3636,68218,77647,57068,0,0,0,206569,0,0]
["Coca - La Belleza","Amazonia","Ecuador",2,700,2141,6860,75459,15823,100966,1687,0,0,0,95728,6925,0,14992,59211,28450,0,0,0,50016,52637,0,60827,41526,0,0,0,99622,3031,0,0,0,0,0,102653,0,0]
["Cuenca  -Macas","Amazonia","Ecuador",3,18561,44260,63206,127094,13621,280650,0,0,26600,0,254050,0,0,89444,172376,18830,0,0,0,8133,168274,104243,17600,127084,126289,8189,1488,7511,75258,113893,83888,100,0,0,198919,81731,0]
["Macuma - Taisha","Amazonia","Ecuador",4,0,393,1690,52203,19614,73900,0,0,0,0,73900,0,0,0,2994,51656,19250,0,68110,5790,0,0,53021,14720,6159,0,0,58222,15395,122,161,0,0,0,73900,0,0]
["Sucumbios - Orellana","Amazonia","Ecuador",5,2300,4926,10037,112288,19549,150116,4190,0,0,0,40810,113496,0,9639,109038,34119,1510,0,0,39149,87689,27468,79267,26790,39649,0,0,96757,54118,2974,457,0,0,0,142357,11949,0]
["Lumbaqui - Maderos - Sardina - Puccuna","Amazonia","Ecuador",6,8522,21892,24869,210745,23358,209000,93950,0,0,20047,109491,173412,800,97272,184200,15756,4922,0,0,33668,137392,131890,302195,755,0,0,0,193052,82222,26308,1368,0,0,0,256825,46125,0]
["Vía Acceso: Puerto Mirador","Amazonia","Ecuador",7,4210,14043,22440,100803,21074,124082,40185,0,0,20134,144133,0,0,35766,105376,23125,0,0,0,930,79325,83734,495,75752,86146,1874,0,5636,51433,64038,43160,0,0,0,92464,71545,0]
[{"$f":"[2]Entrada!M6","v":"Amazonia"},{"$f":"[2]Entrada!M5","v":"Ecuador"},"Ecuador",8,10926,25238,23651,128340,24111,208081,16267,0,0,0,175297,49051,11961,54496,70826,51718,35347,0,0,5499,100509,118340,224348,0,0,0,0,218265,6083,0,0,0,0,0,74862,149486,0]
["Sacha - Unión Milagreña","Amazonia","Ecuador",9,17085,39782,33515,65195,9886,163393,9727,0,0,0,172578,542,4679,112098,45180,4316,6847,0,0,59391,86996,26733,173120,0,0,0,0,168794,4326,0,0,0,0,0,31724,141396,0]
["Macuma - Taisha","Amazonia","Ecuador",10,1129,2945,16678,150279,37669,198692,15898,0,0,0,175509,39081,0,3271,105636,101807,3876,0,147471,67119,0,0,21262,102137,74042,13457,0,53773,114243,30231,16343,0,0,0,214375,215,0]
["Pasto - Mocoa","Amazonía","Colombia",11,17545,41757,49259,113167,13929,247568,1329,0,0,0,123450,125447,4200,94609,144031,6057,0,0,0,0,25115,223782,20796,172359,55742,0,0,13550,52647,79306,103394,0,0,0,23058,216339,9500]
["Nuquí - Las Ánimas","Chocó","Colombia",12,21116,38078,141408,207238,25659,505537,9700,0,0,0,0,470370,100,105651,319598,35219,10300,0,0,0,0,471271,188180,216552,58808,0,0,271777,209066,31187,3207,0,0,0,67965,403066,0]
["Transversal de la Macarena (Baraya , Huila - San Juan de Arama, Meta)","Meta y Huila","Colombia",13,49442,98608,55682,171664,20016,435132,0,0,12301,197588,225243,0,398,81733,230729,119584,2688,0,0,460,272473,162199,23616,132475,113354,160807,0,44001,130935,142802,117394,0,0,0,294623,140505,4]
["Transversal de las Américas , Sector 1 Corredor Vial del Caribe","Caribe","Colombia",14,60215,89518,83960,147134,54608,296288,191501,0,0,0,487789,0,3400,133241,149226,131327,21537,0,0,0,24676,418718,179266,179564,105008,23951,0,355801,105900,18471,7617,0,0,0,208888,229826,4241]
["Ruta del Sol , Sector 1 ","Caribe  - Andina","Colombia",15,37995,97616,61566,65533,1587,269397,4137,0,1764,182022,89748,0,7572,176398,89564,0,0,0,253065,20469,0,0,1004,13207,106782,144643,7898,11085,83093,115689,63667,0,0,0,0,250131,23403]
["Ruta del Sol, Sector 2","Dto. Cundinamarca - Dto del Cesar - Valle del Río Magdalena","Colombia",16,461217,916992,278741,304341,88343,2140215,75451,0,233219,1415785,559239,7423,78097,1538167,597105,2297,0,4404,1092870,874136,234482,9774,1164529,706401,219018,36289,9800,1596790,380403,154028,84445,0,0,0,167139,1874807,173720]
["Ruta del Sol, Sector 3 (Vertical)","Caribe","Colombia",17.100000000000001,133721,421878,163491,118794,7787,923509,16194,71981,242631,515118,76830,0,80366,637660,184275,4184,0,0,42429,304419,434067,125725,139845,479534,159747,79393,18708,661635,111825,104968,61275,0,0,0,19088,816012,71237]
["Ruta del Sol, Sector 3 (Horizontal)","Caribe","Colombia",17.2,285069,585873,197848,34301,2300,1177674,22480,581962,285545,332647,0,0,51413,822108,326633,0,0,0,55070,499456,526252,119376,63700,717249,274269,71646,13292,879059,211277,76510,33308,0,0,0,0,1200154,0]
["BR-156","Amapa","Brasil",18,52019,85049,88380,266242,108595,461966,322256,0,0,0,195444,474538,0,2200,50432,246814,373422,0,253732,237867,155545,24357,500008,132954,2596,0,0,783120,1102,0,0,0,0,670731,0,0,0]
["BR-163","Para","Brasil",19,131027,407619,377041,1113654,970151,3002691,52388,0,0,883512,2171567,0,0,20418,592870,1490888,950903,522906,1209054,632340,441689,249090,1358082,1155795,393626,120018,0,2027690,1015468,11921,0,0,0,1397987,1657092,0,0]
["BR-230","Para","Brasil",20,325366,734026,624188,1109232,203175,3023995,230111,0,0,2286598,967508,0,9300,275732,1168558,1272724,398159,0,630805,1177261,1010079,435961,300149,1019189,1372535,359731,0,2432488,820518,1100,0,0,410148,203408,2370199,270351,0]
["BR-432","Roraima","Brasil",21,6978,21022,27901,102867,190682,349650,0,0,0,349650,0,0,0,0,8392,31763,309495,0,153023,99138,81401,16088,329081,20569,0,0,0,276557,51011,18084,3998,0,0,44355,305295,0,0]
["BR-308","Para","Brasil",22,83225,243958,135941,147076,26123,482935,360039,0,0,57046,642688,0,2400,271671,419382,22330,0,320616,424878,0,0,0,182694,328621,40447,12136,0,839118,3856,0,0,0,0,0,0,743317,0]
["BR-422","Para","Brasil",23,38465,66102,41778,76920,6433,250979,132531,0,0,0,383510,0,1500,73531,173888,3499,0,0,5309,145794,169396,63011,9440,79485,119768,33833,0,327742,55468,300,0,0,0,0,192069,191441,0]
["BR-319","Amazonas","Brasil",24,26263,60072,65824,369423,2086537,2525449,200415,0,0,1631770,1094094,0,19133,76844,355540,930023,1344324,62162,1796648,596832,235666,34556,1194371,1198600,153699,11257,0,2709282,16582,0,0,0,0,1700212,904854,49414,71384]
["Villa Tunari - San Ignacio de Moxos","El Beni y Cochabamba","Bolivia",25,33353,150329,117836,577871,326297,1206413,13755,0,1480,344192,657983,216513,0,110877,279995,318256,511040,0,0,1153,206475,1012540,1139142,81026,0,0,0,1048250,110237,48308,13373,0,0,477281,689008,53879,0]
["Porvenir - El Chorro","Pando","Bolivia",26,21403,56247,45430,447590,597779,1180414,16215,0,643789,552840,0,0,0,6359,556521,507550,126199,0,2852,330288,362706,499383,1113590,74939,0,0,0,1140403,56226,0,0,0,0,919352,267475,8402,0]
["Pumasani - Pelechuco","La Paz","Bolivia",27,23586,5900,800,200,200,154460,1632,0,156084,8,0,0,0,5211,90863,45575,14443,0,0,0,28193,127090,74725,73567,7800,0,0,33376,97675,23803,1238,0,0,0,56959,98332,0]
["Apolo - Ixiamas","La Paz","Bolivia",28,47359,77072,39890,265217,166584,609050,464,0,0,609514,0,0,0,0,38527,207118,363869,0,0,0,35460,574054,368986,185623,54905,0,0,121204,221862,195811,70637,0,0,276200,333314,0,0]
["Rio Yata - El Chorro","El Beni ","Bolivia",29,74841,299684,118098,171179,300328,973033,9715,0,982748,0,0,0,0,0,240323,290934,451491,0,0,46397,321593,614758,496982,472837,12929,0,0,981748,1000,0,0,0,0,759929,222819,0,0]
["Chiata - Lurasani","La Paz","Bolivia",30,29952,22460,11958,24495,12172,191881,968,0,48857,143992,0,0,0,3187,10822,74240,104600,0,0,0,0,192749,37917,153025,1907,0,0,949,29079,57611,104510,700,0,0,192392,356,0]
["MEJORAMIENTO Y CONSTRUCCIÓN DE LA CARRETERA REPOSO SARAMIRIZA, SECTOR: REPOSO DURAN DEL EJE VIAL N° 4 DE INTERCONEXIÓN VIAL PERÚ ECUADOR.","AMAZONAS-LORETO","PERÚ",31,5244,10825,20730,183998,94601,282499,63860,0,0,181960,164399,0,0,0,6983,291520,47856,0,0,26334,100526,219499,260859,48035,0,0,0,223747,79321,32810,10481,0,0,0,346359,0,0]
["INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL","UCAYALI","PERÚ",32,22118,35645,24397,297606,292092,606825,112022,0,465961,252886,0,0,4300,48166,264813,294941,106627,0,0,9176,208108,496866,686047,8200,0,0,0,648573,64635,4839,800,0,0,0,714158,0,0]
["IIRSA SUR","CUSCO","PERU",33,1800,5670,13548,221420,34863,284780,4260,0,0,1762,0,287278,0,2097,70765,100465,115713,0,0,9151,153686,126203,114603,148229,18708,0,0,26941,161927,67303,32869,0,0,45245,65559,178236,0]
["SANTA MARÍA-SANTA TERESA-MACHU PICCHU","CUSCO","PERÚ",34,16182,23921,22019,47637,9430,155195,600,0,155795,0,0,0,0,41215,114580,0,0,0,0,0,19527,136268,2010,130160,23625,0,0,400,8119,23498,121160,2618,0,0,108425,47370,0]
["CARRETERA PURUS-IÑAPARI, RUTA MD-104 Y UC-104","MADRE DE DIOS-UCAYALI","PERÚ",35,4852,17997,25015,517898,595411,1162173,0,0,0,1162173,0,0,0,1760,56584,143150,960679,0,0,0,74674,1085220,1158106,4067,0,0,0,1137103,25070,0,0,0,0,880263,279588,0,0]
["CARRETERA IBERIA- ITAHUANIA-LD CUSCO (PUENTE CARBON CU-113 A PAUCARTAMBO). RUTA MD-103","MADRE DE DIOS","PERÚ",36,6100,17827,35698,660100,530584,1200633,74421,0,0,431534,843520,0,0,400,44036,483203,747415,0,34006,191780,172346,876922,1178638,82762,1391,0,0,986211,213719,46199,28925,0,0,882043,393011,0,0]
[]
[null,null,null,"Calculo para Promedios ponderados"]
[]
[null,null,null,1,{"$f":"(E5/SUM($E5:$I5))*E$4","v":2.3319731813143941E-2},0.13408348782075813,0.51911750818824776,2.6801389641307534,0.33282306923853028,{"$f":"(J5/SUM($J5:$K5))*J$4","v":0.94268259032090973},{"$f":"(K5/SUM($J5:$K5))*K$4","v":0.2865870483954514},{"$f":"(L5/SUM($L5:$P5))*L$4","v":0},{"$f":"(M5/SUM($L5:$P5))*M$4","v":0},0,3.5146415967545952,0.60669800405675589,{"$f":"(Q5/SUM($Q5:$U5))*Q$4","v":4.840997439112355E-4},{"$f":"(R5/SUM($Q5:$U5))*R$4","v":5.5623060575400958E-2},1.1556671136520968,1.5060923952771228,1.0497944996587096,{"$f":"(V5/SUM($V5:$Z5))*V$4","v":0},{"$f":"(W5/SUM($V5:$Z5))*W$4","v":0},0,0,5,{"$f":"(AA5/SUM($AA5:$AE5))*AA$4","v":0.2247191011235955},{"$f":"(AB5/SUM($AA5:$AE5))*AB$4","v":1.8488350139662777},0.66287293834021566,0.54377956034061259,0,{"$f":"(AF5/SUM($AF5:$AJ5))*AF$4","v":1.7601866688612522E-2},{"$f":"(AG5/SUM($AF5:$AJ5))*AG$4","v":0.66048632660273321},1.1276667844642709,1.1050641674210555,0,{"$f":"(AK5/SUM($AK5:$AO5))*AK$4","v":0},{"$f":"(AL5/SUM($AK5:$AO5))*AL$4","v":0},3,0,0]
[null,null,null,2,6.9318598179891663E-3,4.2403176772328015E-2,0.20379667864888149,2.9889783428893972,0.78344869928601846,{"$f":"(J6/SUM($J6:$K6))*J$4","v":0.98356599417454926},8.2170029127253949E-2,{"$f":"(L6/SUM($L6:$P6))*L$4","v":0},0,0,3.7301588847866114,0.33730139401673598,{"$f":"(Q6/SUM($Q6:$U6))*Q$4","v":0},0.29209083027286098,1.7304219068122704,1.1085891303712507,0,{"$f":"(V6/SUM($V6:$Z6))*V$4","v":0},0,1.4617010705970601,2.0510652392039201,0,{"$f":"(AA6/SUM($AA6:$AE6))*AA$4","v":2.9714322003263218},1.6228542397389427,0,0,0,{"$f":"(AF6/SUM($AF6:$AJ6))*AF$4","v":0.97047334223062165},5.9053315538756784E-2,0,0,0,{"$f":"(AK6/SUM($AK6:$AO6))*AK$4","v":0},0,3,0,0]
[null,null,null,3,6.9584092493870486E-2,0.33185625060920287,0.71086668016285404,1.9058715912754647,0.25532162164188621,1,0,0,0.18955995011580259,0,3.620880099768395,0,0,0.6374060217352574,1.8426082308925706,0.26837698200605736,0,0,0,8.6937466595403523E-2,2.3983466951719223,1.8571708533760911,0.31355781222162837,1.8112809549260644,1.3499625868519507,5.8357384642793518E-2,5.3019775521111704E-3,2.6762871904507393E-2,0.53631213254943877,1.2174559059326564,1.1956244432567256,1.7815784785319795E-3,0,0,2.1263388562266168,0.58244076251558885,0]
[null,null,null,4,0,1.0635994587280108E-2,6.8606224627875509E-2,2.8256021650879566,1.3270635994587279,1,0,0,0,0,4,0,0,0,0.12154262516914749,2.7959945872801084,1.3024357239512854,0,1.8433017591339649,0.23504736129905276,0,0,3.5873477672530445,0.79675236806495264,0.2500270635994587,0,0,0.7878484438430311,0.41664411366711773,4.9526387009472261E-3,8.7144790257104188E-3,0,0,0,3,0,0]
[null,null,null,5,1.5425888665325285E-2,6.6076458752515096E-2,0.20195171026156938,3.0124211938296446,0.65556673373574781,0.972846162819333,0.13576918590333492,0,0,0,1.0578979430482289,3.677627571189714,0,0.12493357354866305,2.1199046051352508,0.88445037782069391,4.8928751960390399E-2,0,0,0.76113048099231395,2.2731196453799591,0.89004964162119427,2.7201007508270081,0.73545358461559573,0.81634936104209843,0,0,0.62704625873264808,0.70143740360063767,5.7820175495444118E-2,1.1846590540873329E-2,0,0,0,2.7676888779438258,0.15487408137078273,0]
[null,null,null,6,2.9448556599144395E-2,0.15129964822071559,0.25781136613381433,2.9129950999702818,0.40357861126661276,0.68988281894702097,1.5505859052648951,0,0,0.19851790724542004,1.4456643010397756,2.862056444957914,2.6406997854431426E-3,0.64216537382406336,1.8240633767948506,0.20803432909721076,8.1234527149694674E-2,0,0,0.33340155141112393,1.8140551246080212,2.1767618418881005,4.9875391978874397,9.9686416900478629E-3,0,0,0,0.63724046872421192,0.54280904439676514,0.26051823733289325,1.8062386532431095E-2,0,0,0,2.5432414589866315,0.30450569400891236,0]
[null,null,null,7,2.5896536876422464E-2,0.17276250230669865,0.41409854216645137,2.4802362059420555,0.64815156547948571,0.75536778537381211,1.2231610731309392,0,0,0.36770623436234906,3.5097250208502011,0,0,0.43546177868957248,1.9244766142925847,0.56310762356407551,0,0,0,1.7013336260358926E-2,1.9348858764917158,2.5530370939514233,1.5066933711579321E-2,1.8446066464962529,1.5732800866881358,2.2816512141817895E-2,0,3.4309995312509514E-2,0.62621220330315885,1.1695227891177169,1.0509718933200216,0,0,0,1.6913218177051257,0.87245212152991602,0]
[null,null,null,8,5.1473151611657074E-2,0.23779597297730207,0.33426455485098883,2.4184749323961445,0.56794305258496414,0.92749211047123215,0.36253944764383905,0,0,0,3.1254479647690196,1.0931900440387257,5.3314493554656159E-2,0.48581667766149017,0.94709112628594849,0.92210316116034019,0.78777167614598742,0,0,7.3533082532494159E-2,1.7920195410701232,2.6374204361081892,5,0,0,0,0,0.97288587373188085,5.4228252536238343E-2,0,0,0,0,0,1.0010608518908124,1.3326260987394583,0]
[null,null,null,9,0.10325571275753492,0.480856747429939,0.60765850975746849,1.5760623220901349,0.29873748209569512,0.94381353974121995,0.28093230129390018,0,0,0,3.9874768946395562,1.5653881700554529E-2,2.7027495378927912E-2,1.295032347504621,0.78292513863216262,9.972273567467653E-2,0.19775300369685767,0,0,1.0291878465804067,2.0100739371534195,0.77209450092421439,5,0,0,0,0,0.97501155268022177,4.9976894639556374E-2,0,0,0,0,0,0.54974584103512014,1.6335027726432532,0]
[null,null,null,10,5.409678965021562E-3,2.8222328701485385E-2,0.23974125539051266,2.8802874940105414,0.90246765692381414,0.9259145346940677,0.3704273265296612,0,0,0,3.2715224381378443,0.91059695232769466,0,3.0486043152057413E-2,1.4768069341535019,1.8977025956475138,9.0311757304627427E-2,0,1.3744442891094646,0.93833356633580312,0,0,0.50408254227161953,1.9371829035837229,1.0532390065339643,0.12761619361018123,0,0.25058483619926369,1.0647560464140919,0.42263385991891511,0.30463674914954098,0,0,0,2.9969942681392423,2.0038212405051495E-3,0]
[null,null,null,11,7.445142728626776E-2,0.35438794519152839,0.62708512796140148,1.9208765281744229,0.29553546043614237,0.9946604418695284,2.6697790652358205E-2,0,0,0,1.9839532015251289,2.5200584980935892,1.6874450073725275E-2,0.76022611763098791,1.7360313704062325,9.7341470568146668E-2,0,0,0,0,0.40362077485867648,4.4954740314266548,0.41776317111094147,2.7699650859592522,0.67186828286399591,0,0,5.4440190118804167E-2,0.42304246334829265,0.9558893839620406,1.661635134212144,0,0,0,0.27792219271425528,1.7383817402379298,3.8168398976283359E-2]
[null,null,null,12,4.8710608328969618E-2,0.17567745254314313,0.97860433357401067,1.9122350916611111,0.29595223979755436,0.98117371229162498,9.4131438541874904E-2,0,0,0,0,5,2.1237374380930537E-4,0.44874996814393842,2.0362267132189915,0.29918363532879705,0.10937247806179226,0,0,0,0,5,2.0298140397808173,1.86868015705225,0.38060145834232212,0,0,0.52747958706381726,0.81153333320394305,0.18158827879208983,2.489728028072518E-2,0,0,0,0.43286959881621379,1.7114202674558574,0]
[null,null,null,13,0.12503919961963725,0.49876078621791953,0.42246062334982243,1.7365583239760047,0.25310309247063822,1,0,0,5.6539165126904017E-2,1.3622624858663579,2.0705716885910483,0,9.1466497522590842E-4,0.37566991165899083,1.5907517718761204,1.0992894110292968,3.088717906290505E-2,0,0,3.1714514216375717E-3,2.5047387919068238,1.8637907577470745,0.27444381432276899,1.2316038042821416,0.79037866180749894,0.74750146425815567,0,0.10112103913295276,0.60181737955379055,0.98454262154932304,1.0791575889615106,0,0,0,2.0312663743415791,0.64580403187998126,9.1926128163407882E-6]
[null,null,null,14,0.13828700035596586,0.41116584564860426,0.57845602673188878,1.3516047171219585,0.62705110980973044,0.60741017120107255,1.9629491439946369,0,0,0,4,0,7.749623345512398E-3,0.60739268481142206,1.0203929059036176,1.1973350412895374,0.24544652645926548,0,0,0,0.22261013906367699,4.7217373261704036,1.8375363118069492,1.4724727289873285,0.64582022144820816,9.8202296484750581E-2,0,0.72941579248404531,0.43420413334454039,0.11360034769131735,6.2461433119648045E-2,0,0,0,1.4147351311081262,1.0376945739409196,9.5743359934982106E-3]
[null,null,null,15,0.14375872597872846,0.73868413186680137,0.6988274554762256,0.99180845790909467,3.0023042259276496E-2,0.98487573756827307,7.5621312158634768E-2,0,1.2897848165127552E-2,1.9963368356401765,1.3124218561495098,0,2.7682116299984644E-2,1.2897701931021373,0.98229836144684024,0,0,0,1.8503367040294807,0.22449494395577879,0,0,1.8352380325663352E-2,0.19313138403269794,1.1711377744631379,1.0575869910139142,2.8873924265356409E-2,4.0525126675294482E-2,0.60755152924316536,1.268825813244423,0.93102868381992732,0,0,0,0,1.828884160652789,8.5557919673605473E-2]
[null,null,null,16,0.22502407746944089,0.89478609351718408,0.40798649905300166,0.59394213796219231,0.21550920798542569,0.96594658220146901,0.17026708899265502,0,0.21051819182133047,1.9169653729397842,1.0096088489871669,1.675117097974153E-2,3.5247641115583303E-2,1.3884466341045989,0.80847699969219189,4.1468344055466842E-3,0,1.9876642057060946E-3,0.98649345163034496,1.1835755028059283,0.42331651070152271,2.2056573508823084E-2,2.7259101785221884,1.3228254004963398,0.30760422221150663,3.3977875851401447E-2,4.5879355086077631E-3,0.72068172730005331,0.34337576150918053,0.20855309419379997,0.15245077552302558,0,0,0,0.22630531858141073,1.6923191491858429,7.8405319213274927E-2]
[null,null,null,17.100000000000001,{"$f":"(E21/SUM($E21:$I21))*E$4","v":0.15812414047543311},0.99773552599060389,0.57998086726398324,0.56189227252678642,4.6040363214536154E-2,0.9827668954978328,8.6165522510835868E-2,7.9400150017649135E-2,0.53527841510765972,1.7046351041298977,0.33899576420755384,0,8.8656734529528894E-2,1.4068848353806185,0.60985565122423424,1.8462522821668312E-2,0,0,9.3596135180446488E-2,1.007298376422836,1.9150577958175241,0.69335678990558547,0.7970855890208578,2.1865902440303366,0.5463135539603774,0.18100902047018616,2.1326292966358764E-2,0.70408948359215628,0.23800073001788863,0.33511013586207555,0.26082709111283031,0,0,0,6.3181796616490343E-2,1.8006812035699746,7.8598799342849288E-2]
[null,null,null,17.2,0.25788974218172572,1.060028532890172,0.53695389233312008,0.12412259553406894,1.0403558559821818E-2,{"$f":"(J22/SUM($J22:$K22))*J$4","v":0.98126907046928979},9.3654647653551137E-2,{"$f":"(L22/SUM($L22:$P22))*L$4","v":0.48490610371668968},0.47584726626749568,0.83151078944868728,0,0,{"$f":"(Q22/SUM($Q22:$U22))*Q$4","v":4.2838669037473527E-2},1.370004182796541,0.81647771869276775,0,0,{"$f":"(V22/SUM($V22:$Z22))*V$4","v":0},9.1771555983648764E-2,1.2484797784284349,1.7539482433087754,0.49733617519085055,{"$f":"(AA22/SUM($AA22:$AE22))*AA$4","v":0.27934773837966032},2.5163188195299591,0.72166177259953901,0.12567753886310296,1.1658053810180362E-2,{"$f":"(AF22/SUM($AF22:$AJ22))*AF$4","v":0.73245516825340751},0.3520831493291694,0.19125045619145545,0.11101242007275733,0,{"$f":"(AK22/SUM($AK22:$AO22))*AK$4","v":0},0,0,2,0]
[null,null,null,18,8.6657171177024248E-2,0.28336206968356697,0.44169019715635072,1.7741039672822077,0.90452868220928395,0.58907554238468185,2.0546222880765903,0,0,0,1.1668611992560993,3.5414235009298753,0,6.5391726163229634E-3,0.22485242276345435,1.4672357728410328,2.7748533144688108,0,0.75571592596288018,1.062695364563865,0.92655111459253225,0.18136235091235903,3.9336142413438271,0.83677020822647186,1.2253799023849909E-2,0,0,0.998594785660183,2.8104286796340832E-3,0,0,0,0,4,0,0,0]
[null,null,null,19,4.3683063665447351E-2,0.27179202344930409,0.3771048564223542,1.485123480909434,1.6171921778754537,0.98285216192445435,8.5739190377728369E-2,0,0,0.86758345692533645,2.8432220574328846,0,0,1.3366593793482918E-2,0.58218134457406823,1.9520123702202137,1.5562658117842452,0.17115956739580221,0.79150424588038482,0.62093975311276739,0.578301248511086,0.40766539915989081,2.2428944340931078,1.5270513400237355,0.39004783121240116,7.928466887595495E-2,0,0.66371115116826762,0.66477364415126416,1.1706080268300754E-2,0,0,0,1.8303775450651194,1.6272168412011603,0,0]
[null,null,null,20,0.10860060474227692,0.49000613153528372,0.62502407386947945,1.4809570268495824,0.33907857410596243,0.92928595442189033,0.35357022789054809,0,0,2.1080425775927401,1.1892765632096802,0,2.9765019572900774E-3,0.17649824466398015,1.1220048949054768,1.629361495522605,0.63716185097454825,0,0.38769788076971062,1.0853312707084526,1.2416055285230414,0.66986293624116733,0.49178890839047262,1.3359387391024524,1.3493248140977663,0.23576519102740723,0,0.74751344916238127,0.50429703273341431,1.0141034127345576E-3,0,0,0.63020073716098979,0.25003242057880104,2.1851153588727596,0.16615992226436385,0]
[null,null,null,21,1.9968521963084847E-2,0.12031478036915152,0.23952782944627271,1.177473172127629,2.7283159250250395,1,0,0,0,3,0,0,0,0,7.2003432003431997E-2,0.36336908336908336,4.4257829257829258,0,0.87529243529243528,0.85060489060489064,0.93122837122837121,0.23005863005863006,4.705863005863006,0.2353095953095953,0,0,0,0.7909538109538109,0.29178321178321176,0.15516087516087518,4.5737165737165734E-2,0,0,0.50742170742170745,2.6194337194337196,0,0]
[null,null,null,22,0.1307904947644514,0.76677410686082381,0.64090564068876965,0.92453675256119927,0.20526525050956826,0.57289430041733203,2.1355284979133402,0,0,0.24457579594531637,3.6738989387395784,0,3.3529715011393116E-3,0.75908760057168168,1.7577198676135086,0.12478642270073471,0,0.4300718718058093,1.1398562563883814,0,0,0,1.6199206239426278,2.3310669660115835,0.21518253301128928,4.3043245409630823E-2,0,0.99542571894269571,9.1485621146085178E-3,0,0,0,0,0,0,2,0]
[null,null,null,23,0.16745901139757421,0.57555572969725466,0.54564689287673374,1.3394979494814931,0.1400316937892363,0.65442622095903624,1.7278688952048185,0,0,0,4,0,5.9425239087545264E-3,0.58261296737950541,2.0666671948910142,5.5447709751285566E-2,0,0,2.7686370629188287E-2,1.1404709134051263,1.7667961721988996,0.82150400250319411,0.19461830896481203,1.31095222780238,1.4815071373790851,0.27900513759349516,0,0.85458527808922846,0.28926494745899717,2.3467445438189356E-3,0,0,0,0,1.502456259289197,0.99836249380720188,0]
[null,null,null,24,1.0069709242561401E-2,4.6065382752857521E-2,7.5714336654117392E-2,0.56657384114758569,4.0000801343803714,0.92647652267317815,0.36761738663410937,0,0,1.7958746291084222,1.6055004945221039,0,7.0190589112296142E-3,5.6381389533740493E-2,0.3912961174878864,1.3647386663457899,2.4658677028641192,2.2804512624254182E-2,1.3182227726695095,0.65685448723780793,0.34582209530629554,6.3385407342405928E-2,2.3346463757566185,1.8743302682211025,0.18026198558442053,8.8016585305210043E-3,0,0.99391679115319032,1.2166417693619345E-2,0,0,0,0,2.4949329827166724,0.99585379167852839,3.6255660590550375E-2,2.6187660132713883E-2]
[null,null,null,25,2.7663089726512543E-2,0.24936675054699151,0.29320071726801178,1.917152558792256,1.3531591143962856,0.9887269621888134,5.6365189055933282E-2,0,2.4258954504625591E-3,0.84625723670838782,2.1570242786239273,0.88722618524662178,0,0.18174054720333593,0.68841749660702456,1.0433186249762327,2.0941378564263284,0,0,2.8348555280912138E-3,0.67687400423548227,4.149182735492162,4.6679719514034135,0.26562243887726938,0,0,0,0.85910300876600598,0.18069151133286565,0.11877380819690403,4.383986467437271E-2,0,0,1.5646402790435416,1.6940486883773382,8.8314068226670428E-2,0]
[null,null,null,26,1.8317444749407118E-2,9.6276345822539106E-2,0.11664180464872664,1.5322534402442896,2.5580021036433771,0.98644943420224651,6.7752828988767611E-2,0,1.0760043421979577,1.3859934867030634,0,0,0,1.0628189689536188E-2,1.3952219108846602,1.6965993637125625,0.5273104696610228,0,4.7723072315012435E-3,0.82901602956420906,1.2138460495854768,2.0890682873323856,4.6847405490316181,0.25220756077470552,0,0,0,0.95301300570185077,9.3973988596298436E-2,0,0,0,0,3.0767392692111719,0.67135670235578293,1.4059230490558712E-2,0]
[null,null,null,27,0.76862412826696214,0.38454018119011929,7.8211562275956464E-2,2.6070520758652155E-2,3.2588150948315193E-2,0.98954462752735561,5.2276862363221689E-2,0,1.9998974963483074,1.5375547753888733E-4,0,0,0,6.6768316121261814E-2,1.7463354944519898,1.167900981472465,0.46264382543628113,0,0,0,0.72623532518047695,4.092205843524404,2.3936204289777825,1.8852215360172206,0.14991159060041515,0,0,0.21382261743074596,1.2515055223842348,0.45748020398226685,3.1724880198857087E-2,0,0,0,1.1003664088710872,1.2664223940859418,0]
[null,null,null,28,7.9445147134311431E-2,0.25857794209910051,0.20074749799537681,1.7796155820452861,1.3972307681984562,0.99923873774843563,3.8063112578218053E-3,0,0,3,0,0,0,0,0.18962812995271644,1.3592337501681668,2.9849109290352644,0,0,0,0.23270999517648489,4.7091125060293937,3.0268869952125792,1.2181705424321672,0.27023989604832704,0,0,0.1988535127987216,0.72799640369212193,0.96377277634311931,0.46356277296337739,0,0,1.8125916713972114,1.6405562464520913,0,0]
[null,null,null,29,7.7625423957350156E-2,0.62166720255567198,0.36747534046238578,0.71019053447149239,1.5575078049640609,0.99011445457024583,4.9427727148770591E-2,0,2,0,0,0,0,0,0.73362550725109599,1.1841652183469211,2.2970842983145219,0,0,0.14163447801470977,1.3089540757142217,3.1277499419993733,2.5285322381729598,1.9245503425089647,3.9467900214500563E-2,0,0,0.99898244514361767,2.0351097127646153E-3,0,0,0,0,3.0930777778230025,0.68019166663274822,0,0]
[null,null,null,30,0.29644585646842248,0.44458960578797868,0.35505804804180646,0.96974375723744766,0.60235359323812065,0.99498052880751264,2.5097355962436931E-2,0,0.50668657861850463,2.2399701320722429,0,0,0,3.3051765889374592E-2,0.16834933030505733,1.539857608802742,2.7119663570980408,0,0,0,0,5,0.98307484093772857,3.1739858645883565,2.9665696996095389E-2,0,0,4.9209485141224482E-3,0.30157273307095189,0.89620895104459963,2.167706340193623,1.8148914435646542E-2,0,0,2.9944590864756053,3.693942349596364E-3,0]
[null,null,null,31,1.6626611456001625E-2,6.8643428303286638E-2,0.19717943677512223,2.3335341378195169,1.4997083050621753,0.81562482857382079,0.92187585713089604,0,0,1.5760525928299827,1.8985965428933562,0,0,0,6.0483486786831006E-2,3.3666802364021144,0.69084389318597172,0,0,0.22809281699046363,1.1609457239453862,3.1686631500841611,4.2224679016102611,0.62202567871179115,0,0,0,0.6459973611195321,0.45802765338853618,0.28418490641213306,0.12104204019528871,0,0,0,3,0,0]
[null,null,null,32,{"$f":"(E37/SUM($E37:$I37))*E$4","v":3.2920646922415156E-2},0.10610873130929452,0.10893819825022549,1.7718386921045817,2.1737629082335852,0.84416433538708513,0.77917832306457424,0,1.296412171157423,1.0553817432638657,0,0,5.9818014125398037E-3,0.13400904504018241,1.1051572865992347,1.6411892934101415,0.74165295257544361,0,0,3.8546523839529515E-2,1.1656262689911083,3.478722957361899,4.9409432089731755,4.72454328214598E-2,0,0,0,0.9022406715198088,0.17982964386023731,2.0194839792055889E-2,4.4515731442156675E-3,0,0,0,3,0,0]
[null,null,null,33,6.4911413950905338E-3,4.0894190789070362E-2,0.14656997270114425,3.1939300615576576,0.62861295126955907,{"$f":"(J38/SUM($J38:$K38))*J$4","v":0.98526155549404926},7.3692222529753673E-2,{"$f":"(L38/SUM($L38:$P38))*L$4","v":0},0,1.8288126210905066E-2,0,4.9695197896484915,{"$f":"(Q38/SUM($Q38:$U38))*Q$4","v":0},1.4510102407971215E-2,0.73448311652366449,1.3903265983946858,2.0016779684472739,{"$f":"(V38/SUM($V38:$Z38))*V$4","v":0},0,9.4979933573207859E-2,2.1268474951563796,2.1831407417658455,{"$f":"(AA38/SUM($AA38:$AE38))*AA$4","v":2.0352880585351993},2.1059742842935285,0.1993464516587341,0,0,{"$f":"(AF38/SUM($AF38:$AJ38))*AF$4","v":9.3208552449487961E-2},1.1204469969554387,0.69855037365070582,0.45487129809022975,0,{"$f":"(AK38/SUM($AK38:$AO38))*AK$4","v":0},0.62614171048989764,0.68044907279269307,1.2332964295599225,0]
[null,null,null,34,0.13576756244284288,0.40139610198927755,0.55422060760640668,1.5987045784426415,0.39559019708194543,0.99614878526268491,1.9256073686575306E-2,0,2,0,0,0,0,0.52909271799480084,2.2063609230077987,0,0,0,0,0,0.50135113450367474,4.3733110818704066,6.4507846850027278E-2,3.3418274013928562,0.45492474084534162,0,0,2.5674764915433741E-3,0.10422670817420328,0.45247921948714653,3.1107545171539521,8.402066818575693E-2,0,0,2.0878397894669281,0.60810680702204822,0]
[null,null,null,35,4.1785332590406421E-3,3.0997964988851791E-2,6.4628612618447046E-2,1.7840511276097533,2.5638341573563972,1,0,0,0,3,0,0,0,3.0288089638978019E-3,0.14606431228397149,0.49269773088860264,4.1331152935062168,0,0,0,0.25752008373178931,4.6780998953352633,4.9825026050338463,1.3997915972923136E-2,0,0,0,0.97842834070314832,4.314331859370335E-2,0,0,0,0,3.0357795958273952,0.72316530312945371,0,0]
[null,null,null,36,4.8787939621325604E-3,2.8516150807520381E-2,8.5654026324692531E-2,2.1117979635434119,2.1218114882001169,0.94163306024686011,0.29183469876569934,0,0,1.0153311153880542,2.6462251794825944,0,0,6.2742440712314934E-4,0.10360972947028124,1.5158667789756355,2.9309150828121791,0,5.3340485971574536E-2,0.45122794799279087,0.54067043435023143,3.4387641621452896,4.66679759358437,0.26215581200689586,3.3045848442062064E-3,0,0,0.77346606496666026,0.33523129216488085,0.1086989256925589,9.0741254880185473E-2,0,0,2.7670765316606198,0.92469260125453512,0,0]

{"sheet":"Valores Filtro Var GEO","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Carretera","Cobertura de arboles (Rangos)","Humedales (Rangos)*","Balance hidrico promedio (Rangos)","Intervencion Humana (Rangos)","Proximidad a areas de conservacion / territorios indígenas(Rangos)","Ingreso maximo por agricultura (Rangos)","Pendiente (Rangos)","Densidad poblacional (Rangos)"]
[1,{"$f":"SUM(Valores_GEO_Areas!E45:I45)","v":3.6894827611914338},{"$f":"SUM(Valores_GEO_Areas!J45:K45)","v":1.2292696387163611},{"$f":"SUM(Valores_GEO_Areas!L45:P45)","v":4.1213396008113508},{"$f":"SUM(Valores_GEO_Areas!Q45:U45)","v":3.7676611689072415},{"$f":"SUM(Valores_GEO_Areas!V45:Z45)","v":5},{"$f":"SUM(Valores_GEO_Areas!AA45:AE45)","v":3.2802066137707016},{"$f":"SUM(Valores_GEO_Areas!AF45:AJ45)","v":2.9108191451766725},{"$f":"SUM(Valores_GEO_Areas!AK45:AO45)","v":3}]
[2,{"$f":"SUM(Valores_GEO_Areas!E46:I46)","v":4.0255587574146148},{"$f":"SUM(Valores_GEO_Areas!J46:K46)","v":1.0657360233018032},{"$f":"SUM(Valores_GEO_Areas!L46:P46)","v":4.0674602788033472},{"$f":"SUM(Valores_GEO_Areas!Q46:U46)","v":3.1311018674563824},{"$f":"SUM(Valores_GEO_Areas!V46:Z46)","v":3.5127663098009805},{"$f":"SUM(Valores_GEO_Areas!AA46:AE46)","v":4.5942864400652645},{"$f":"SUM(Valores_GEO_Areas!AF46:AJ46)","v":1.0295266577693785},{"$f":"SUM(Valores_GEO_Areas!AK46:AO46)","v":3}]
[3,{"$f":"SUM(Valores_GEO_Areas!E47:I47)","v":3.2735002361832781},{"$f":"SUM(Valores_GEO_Areas!J47:K47)","v":1},{"$f":"SUM(Valores_GEO_Areas!L47:P47)","v":3.8104400498841975},{"$f":"SUM(Valores_GEO_Areas!Q47:U47)","v":2.7483912346338855},{"$f":"SUM(Valores_GEO_Areas!V47:Z47)","v":4.3424550151434165},{"$f":"SUM(Valores_GEO_Areas!AA47:AE47)","v":3.5384607161945483},{"$f":"SUM(Valores_GEO_Areas!AF47:AJ47)","v":2.9779369321218603},{"$f":"SUM(Valores_GEO_Areas!AK47:AO47)","v":2.7087796187422057}]
[4,{"$f":"SUM(Valores_GEO_Areas!E48:I48)","v":4.2319079837618396},{"$f":"SUM(Valores_GEO_Areas!J48:K48)","v":1},{"$f":"SUM(Valores_GEO_Areas!L48:P48)","v":4},{"$f":"SUM(Valores_GEO_Areas!Q48:U48)","v":4.2199729364005414},{"$f":"SUM(Valores_GEO_Areas!V48:Z48)","v":2.0783491204330176},{"$f":"SUM(Valores_GEO_Areas!AA48:AE48)","v":4.6341271989174553},{"$f":"SUM(Valores_GEO_Areas!AF48:AJ48)","v":1.2181596752368065},{"$f":"SUM(Valores_GEO_Areas!AK48:AO48)","v":3}]
[5,{"$f":"SUM(Valores_GEO_Areas!E49:I49)","v":3.9514419852448022},{"$f":"SUM(Valores_GEO_Areas!J49:K49)","v":1.108615348722668},{"$f":"SUM(Valores_GEO_Areas!L49:P49)","v":4.7355255142379429},{"$f":"SUM(Valores_GEO_Areas!Q49:U49)","v":3.1782173084649985},{"$f":"SUM(Valores_GEO_Areas!V49:Z49)","v":3.9242997679934675},{"$f":"SUM(Valores_GEO_Areas!AA49:AE49)","v":4.2719036964847019},{"$f":"SUM(Valores_GEO_Areas!AF49:AJ49)","v":1.3981504283696033},{"$f":"SUM(Valores_GEO_Areas!AK49:AO49)","v":2.9225629593146083}]
[6,{"$f":"SUM(Valores_GEO_Areas!E50:I50)","v":3.755133282190569},{"$f":"SUM(Valores_GEO_Areas!J50:K50)","v":2.2404687242119161},{"$f":"SUM(Valores_GEO_Areas!L50:P50)","v":4.5062386532431091},{"$f":"SUM(Valores_GEO_Areas!Q50:U50)","v":2.7581383066512628},{"$f":"SUM(Valores_GEO_Areas!V50:Z50)","v":4.3242185179072461},{"$f":"SUM(Valores_GEO_Areas!AA50:AE50)","v":4.9975078395774872},{"$f":"SUM(Valores_GEO_Areas!AF50:AJ50)","v":1.4586301369863015},{"$f":"SUM(Valores_GEO_Areas!AK50:AO50)","v":2.8477471529955438}]
[7,{"$f":"SUM(Valores_GEO_Areas!E51:I51)","v":3.741145352771114},{"$f":"SUM(Valores_GEO_Areas!J51:K51)","v":1.9785288585047514},{"$f":"SUM(Valores_GEO_Areas!L51:P51)","v":3.8774312552125503},{"$f":"SUM(Valores_GEO_Areas!Q51:U51)","v":2.9230460165462326},{"$f":"SUM(Valores_GEO_Areas!V51:Z51)","v":4.504936306703498},{"$f":"SUM(Valores_GEO_Areas!AA51:AE51)","v":3.4557701790377862},{"$f":"SUM(Valores_GEO_Areas!AF51:AJ51)","v":2.8810168810534069},{"$f":"SUM(Valores_GEO_Areas!AK51:AO51)","v":2.5637739392350416}]
[8,{"$f":"SUM(Valores_GEO_Areas!E52:I52)","v":3.6099516644210565},{"$f":"SUM(Valores_GEO_Areas!J52:K52)","v":1.2900315581150712},{"$f":"SUM(Valores_GEO_Areas!L52:P52)","v":4.2186380088077451},{"$f":"SUM(Valores_GEO_Areas!Q52:U52)","v":3.1960971348084222},{"$f":"SUM(Valores_GEO_Areas!V52:Z52)","v":4.5029730597108069},{"$f":"SUM(Valores_GEO_Areas!AA52:AE52)","v":5},{"$f":"SUM(Valores_GEO_Areas!AF52:AJ52)","v":1.0271141262681192},{"$f":"SUM(Valores_GEO_Areas!AK52:AO52)","v":2.3336869506302707}]
[9,{"$f":"SUM(Valores_GEO_Areas!E53:I53)","v":3.0665707741307724},{"$f":"SUM(Valores_GEO_Areas!J53:K53)","v":1.2247458410351202},{"$f":"SUM(Valores_GEO_Areas!L53:P53)","v":4.0031307763401109},{"$f":"SUM(Valores_GEO_Areas!Q53:U53)","v":2.4024607208872459},{"$f":"SUM(Valores_GEO_Areas!V53:Z53)","v":3.8113562846580402},{"$f":"SUM(Valores_GEO_Areas!AA53:AE53)","v":5},{"$f":"SUM(Valores_GEO_Areas!AF53:AJ53)","v":1.0249884473197781},{"$f":"SUM(Valores_GEO_Areas!AK53:AO53)","v":2.1832486136783733}]
[10,{"$f":"SUM(Valores_GEO_Areas!E54:I54)","v":4.0561284139913756},{"$f":"SUM(Valores_GEO_Areas!J54:K54)","v":1.296341861223729},{"$f":"SUM(Valores_GEO_Areas!L54:P54)","v":4.1821193904655392},{"$f":"SUM(Valores_GEO_Areas!Q54:U54)","v":3.4953073302577002},{"$f":"SUM(Valores_GEO_Areas!V54:Z54)","v":2.3127778554452676},{"$f":"SUM(Valores_GEO_Areas!AA54:AE54)","v":3.6221206459994879},{"$f":"SUM(Valores_GEO_Areas!AF54:AJ54)","v":2.0426114916818117},{"$f":"SUM(Valores_GEO_Areas!AK54:AO54)","v":2.9989980893797474}]
[11,{"$f":"SUM(Valores_GEO_Areas!E55:I55)","v":3.272336489049763},{"$f":"SUM(Valores_GEO_Areas!J55:K55)","v":1.0213582325218866},{"$f":"SUM(Valores_GEO_Areas!L55:P55)","v":4.5040116996187178},{"$f":"SUM(Valores_GEO_Areas!Q55:U55)","v":2.6104734086790926},{"$f":"SUM(Valores_GEO_Areas!V55:Z55)","v":4.8990948062853317},{"$f":"SUM(Valores_GEO_Areas!AA55:AE55)","v":3.8595965399341896},{"$f":"SUM(Valores_GEO_Areas!AF55:AJ55)","v":3.0950071716412815},{"$f":"SUM(Valores_GEO_Areas!AK55:AO55)","v":2.0544723319284683}]
[12,{"$f":"SUM(Valores_GEO_Areas!E56:I56)","v":3.4111797259047889},{"$f":"SUM(Valores_GEO_Areas!J56:K56)","v":1.0753051508334999},{"$f":"SUM(Valores_GEO_Areas!L56:P56)","v":5},{"$f":"SUM(Valores_GEO_Areas!Q56:U56)","v":2.8937451684973285},{"$f":"SUM(Valores_GEO_Areas!V56:Z56)","v":5},{"$f":"SUM(Valores_GEO_Areas!AA56:AE56)","v":4.2790956551753894},{"$f":"SUM(Valores_GEO_Areas!AF56:AJ56)","v":1.5454984793405753},{"$f":"SUM(Valores_GEO_Areas!AK56:AO56)","v":2.1442898662720711}]
[13,{"$f":"SUM(Valores_GEO_Areas!E57:I57)","v":3.0359220256340218},{"$f":"SUM(Valores_GEO_Areas!J57:K57)","v":1},{"$f":"SUM(Valores_GEO_Areas!L57:P57)","v":3.4893733395843105},{"$f":"SUM(Valores_GEO_Areas!Q57:U57)","v":3.0975129386025388},{"$f":"SUM(Valores_GEO_Areas!V57:Z57)","v":4.3717010010755359},{"$f":"SUM(Valores_GEO_Areas!AA57:AE57)","v":3.0439277446705653},{"$f":"SUM(Valores_GEO_Areas!AF57:AJ57)","v":2.7666386291975771},{"$f":"SUM(Valores_GEO_Areas!AK57:AO57)","v":2.6770795988343767}]
[14,{"$f":"SUM(Valores_GEO_Areas!E58:I58)","v":3.1065646996681475},{"$f":"SUM(Valores_GEO_Areas!J58:K58)","v":2.5703593151957094},{"$f":"SUM(Valores_GEO_Areas!L58:P58)","v":4},{"$f":"SUM(Valores_GEO_Areas!Q58:U58)","v":3.0783167818093546},{"$f":"SUM(Valores_GEO_Areas!V58:Z58)","v":4.9443474652340811},{"$f":"SUM(Valores_GEO_Areas!AA58:AE58)","v":4.0540315587272362},{"$f":"SUM(Valores_GEO_Areas!AF58:AJ58)","v":1.3396817066395512},{"$f":"SUM(Valores_GEO_Areas!AK58:AO58)","v":2.4620040410425439}]
[15,{"$f":"SUM(Valores_GEO_Areas!E59:I59)","v":2.6031018134901269},{"$f":"SUM(Valores_GEO_Areas!J59:K59)","v":1.0604970497269077},{"$f":"SUM(Valores_GEO_Areas!L59:P59)","v":3.3216565399548141},{"$f":"SUM(Valores_GEO_Areas!Q59:U59)","v":2.2997506708489621},{"$f":"SUM(Valores_GEO_Areas!V59:Z59)","v":2.0748316479852593},{"$f":"SUM(Valores_GEO_Areas!AA59:AE59)","v":2.4690824541007701},{"$f":"SUM(Valores_GEO_Areas!AF59:AJ59)","v":2.8479311529828104},{"$f":"SUM(Valores_GEO_Areas!AK59:AO59)","v":1.9144420803263944}]
[16,{"$f":"SUM(Valores_GEO_Areas!E60:I60)","v":2.3372480159872446},{"$f":"SUM(Valores_GEO_Areas!J60:K60)","v":1.136213671194124},{"$f":"SUM(Valores_GEO_Areas!L60:P60)","v":3.1538435847280231},{"$f":"SUM(Valores_GEO_Areas!Q60:U60)","v":2.2363181093179207},{"$f":"SUM(Valores_GEO_Areas!V60:Z60)","v":2.6174297028523252},{"$f":"SUM(Valores_GEO_Areas!AA60:AE60)","v":4.3949056125900432},{"$f":"SUM(Valores_GEO_Areas!AF60:AJ60)","v":1.4250613585260592},{"$f":"SUM(Valores_GEO_Areas!AK60:AO60)","v":1.9970297869805287}]
[17,{"$f":"(B42+B43)/2","v":2.1665857454851256},{"$f":"(C42+C43)/2","v":1.0719280680657548},2.2252867964478167,2.1765901572414159,3.6504224251190509,3.6934943118152797,1.4624143172158703,1.971230899764657]
[18,{"$f":"SUM(Valores_GEO_Areas!E63:I63)","v":3.4903420875084334},{"$f":"SUM(Valores_GEO_Areas!J63:K63)","v":2.6436978304612722},{"$f":"SUM(Valores_GEO_Areas!L63:P63)","v":4.7082847001859749},{"$f":"SUM(Valores_GEO_Areas!Q63:U63)","v":4.4734806826896207},{"$f":"SUM(Valores_GEO_Areas!V63:Z63)","v":2.9263247560316366},{"$f":"SUM(Valores_GEO_Areas!AA63:AE63)","v":4.7826382485941492},{"$f":"SUM(Valores_GEO_Areas!AF63:AJ63)","v":1.0014052143398171},{"$f":"SUM(Valores_GEO_Areas!AK63:AO63)","v":4}]
[19,{"$f":"SUM(Valores_GEO_Areas!E64:I64)","v":3.7948956023219931},{"$f":"SUM(Valores_GEO_Areas!J64:K64)","v":1.0685913523021826},{"$f":"SUM(Valores_GEO_Areas!L64:P64)","v":3.710805514358221},{"$f":"SUM(Valores_GEO_Areas!Q64:U64)","v":4.1038261203720099},{"$f":"SUM(Valores_GEO_Areas!V64:Z64)","v":2.5695702140599312},{"$f":"SUM(Valores_GEO_Areas!AA64:AE64)","v":4.2392782742051995},{"$f":"SUM(Valores_GEO_Areas!AF64:AJ64)","v":1.3401908755878325},{"$f":"SUM(Valores_GEO_Areas!AK64:AO64)","v":3.4575943862662797}]
[20,{"$f":"SUM(Valores_GEO_Areas!E65:I65)","v":3.0436664111025848},{"$f":"SUM(Valores_GEO_Areas!J65:K65)","v":1.2828561823124385},{"$f":"SUM(Valores_GEO_Areas!L65:P65)","v":3.2973191408024203},{"$f":"SUM(Valores_GEO_Areas!Q65:U65)","v":3.5680029880239008},{"$f":"SUM(Valores_GEO_Areas!V65:Z65)","v":3.3844976162423723},{"$f":"SUM(Valores_GEO_Areas!AA65:AE65)","v":3.4128176526180987},{"$f":"SUM(Valores_GEO_Areas!AF65:AJ65)","v":1.2528245853085302},{"$f":"SUM(Valores_GEO_Areas!AK65:AO65)","v":3.2315084388769142}]
[21,{"$f":"SUM(Valores_GEO_Areas!E66:I66)","v":4.2856002289311776},{"$f":"SUM(Valores_GEO_Areas!J66:K66)","v":1},{"$f":"SUM(Valores_GEO_Areas!L66:P66)","v":3},{"$f":"SUM(Valores_GEO_Areas!Q66:U66)","v":4.8611554411554412},{"$f":"SUM(Valores_GEO_Areas!V66:Z66)","v":2.8871843271843272},{"$f":"SUM(Valores_GEO_Areas!AA66:AE66)","v":4.9411726011726014},{"$f":"SUM(Valores_GEO_Areas!AF66:AJ66)","v":1.2836350636350637},{"$f":"SUM(Valores_GEO_Areas!AK66:AO66)","v":3.1268554268554269}]
[22,{"$f":"SUM(Valores_GEO_Areas!E67:I67)","v":2.6682722453848124},{"$f":"SUM(Valores_GEO_Areas!J67:K67)","v":2.7084227983306723},{"$f":"SUM(Valores_GEO_Areas!L67:P67)","v":3.9184747346848949},{"$f":"SUM(Valores_GEO_Areas!Q67:U67)","v":2.6449468623870644},{"$f":"SUM(Valores_GEO_Areas!V67:Z67)","v":1.5699281281941908},{"$f":"SUM(Valores_GEO_Areas!AA67:AE67)","v":4.2092133683751314},{"$f":"SUM(Valores_GEO_Areas!AF67:AJ67)","v":1.0045742810573042},{"$f":"SUM(Valores_GEO_Areas!AK67:AO67)","v":2}]
[23,{"$f":"SUM(Valores_GEO_Areas!E68:I68)","v":2.7681912772422921},{"$f":"SUM(Valores_GEO_Areas!J68:K68)","v":2.3822951161638546},{"$f":"SUM(Valores_GEO_Areas!L68:P68)","v":4},{"$f":"SUM(Valores_GEO_Areas!Q68:U68)","v":2.7106703959305598},{"$f":"SUM(Valores_GEO_Areas!V68:Z68)","v":3.7564574587364081},{"$f":"SUM(Valores_GEO_Areas!AA68:AE68)","v":3.2660828117397722},{"$f":"SUM(Valores_GEO_Areas!AF68:AJ68)","v":1.1461969700920447},{"$f":"SUM(Valores_GEO_Areas!AK68:AO68)","v":2.5008187530963988}]
[24,{"$f":"SUM(Valores_GEO_Areas!E69:I69)","v":4.6985034041774938},{"$f":"SUM(Valores_GEO_Areas!J69:K69)","v":1.2940939093072874},{"$f":"SUM(Valores_GEO_Areas!L69:P69)","v":3.4013751236305261},{"$f":"SUM(Valores_GEO_Areas!Q69:U69)","v":4.2853029351427656},{"$f":"SUM(Valores_GEO_Areas!V69:Z69)","v":2.4070892751802728},{"$f":"SUM(Valores_GEO_Areas!AA69:AE69)","v":4.3980402880926626},{"$f":"SUM(Valores_GEO_Areas!AF69:AJ69)","v":1.0060832088468097},{"$f":"SUM(Valores_GEO_Areas!AK69:AO69)","v":3.5532300951184652}]
[25,{"$f":"SUM(Valores_GEO_Areas!E70:I70)","v":3.8405422307300574},{"$f":"SUM(Valores_GEO_Areas!J70:K70)","v":1.0450921512447466},{"$f":"SUM(Valores_GEO_Areas!L70:P70)","v":3.8929335960293994},{"$f":"SUM(Valores_GEO_Areas!Q70:U70)","v":4.0076145252129214},{"$f":"SUM(Valores_GEO_Areas!V70:Z70)","v":4.8288915952557359},{"$f":"SUM(Valores_GEO_Areas!AA70:AE70)","v":4.9335943902806827},{"$f":"SUM(Valores_GEO_Areas!AF70:AJ70)","v":1.2024081929701484},{"$f":"SUM(Valores_GEO_Areas!AK70:AO70)","v":3.3470030356475502}]
[26,{"$f":"SUM(Valores_GEO_Areas!E71:I71)","v":4.321491139108339},{"$f":"SUM(Valores_GEO_Areas!J71:K71)","v":1.0542022631910142},{"$f":"SUM(Valores_GEO_Areas!L71:P71)","v":2.4619978289010209},{"$f":"SUM(Valores_GEO_Areas!Q71:U71)","v":3.6297599339477817},{"$f":"SUM(Valores_GEO_Areas!V71:Z71)","v":4.1367026737135726},{"$f":"SUM(Valores_GEO_Areas!AA71:AE71)","v":4.9369481098063233},{"$f":"SUM(Valores_GEO_Areas!AF71:AJ71)","v":1.0469869942981491},{"$f":"SUM(Valores_GEO_Areas!AK71:AO71)","v":3.7621552020575137}]
[27,{"$f":"SUM(Valores_GEO_Areas!E72:I72)","v":1.2900345434400053},{"$f":"SUM(Valores_GEO_Areas!J72:K72)","v":1.0418214898905773},{"$f":"SUM(Valores_GEO_Areas!L72:P72)","v":2.0000512518258464},{"$f":"SUM(Valores_GEO_Areas!Q72:U72)","v":3.4436486174819976},{"$f":"SUM(Valores_GEO_Areas!V72:Z72)","v":4.8184411687048812},{"$f":"SUM(Valores_GEO_Areas!AA72:AE72)","v":4.4287535555954181},{"$f":"SUM(Valores_GEO_Areas!AF72:AJ72)","v":1.9545332239961049},{"$f":"SUM(Valores_GEO_Areas!AK72:AO72)","v":2.366788802957029}]
[28,{"$f":"SUM(Valores_GEO_Areas!E73:I73)","v":3.7156169374725314},{"$f":"SUM(Valores_GEO_Areas!J73:K73)","v":1.0030450490062575},{"$f":"SUM(Valores_GEO_Areas!L73:P73)","v":3},{"$f":"SUM(Valores_GEO_Areas!Q73:U73)","v":4.5337728091561473},{"$f":"SUM(Valores_GEO_Areas!V73:Z73)","v":4.9418225012058787},{"$f":"SUM(Valores_GEO_Areas!AA73:AE73)","v":4.5152974336930738},{"$f":"SUM(Valores_GEO_Areas!AF73:AJ73)","v":2.35418546579734},{"$f":"SUM(Valores_GEO_Areas!AK73:AO73)","v":3.4531479178493028}]
[29,{"$f":"SUM(Valores_GEO_Areas!E74:I74)","v":3.3344663064109614},{"$f":"SUM(Valores_GEO_Areas!J74:K74)","v":1.0395421817190165},{"$f":"SUM(Valores_GEO_Areas!L74:P74)","v":2},{"$f":"SUM(Valores_GEO_Areas!Q74:U74)","v":4.2148750239125388},{"$f":"SUM(Valores_GEO_Areas!V74:Z74)","v":4.5783384957283051},{"$f":"SUM(Valores_GEO_Areas!AA74:AE74)","v":4.4925504808964245},{"$f":"SUM(Valores_GEO_Areas!AF74:AJ74)","v":1.0010175548563822},{"$f":"SUM(Valores_GEO_Areas!AK74:AO74)","v":3.7732694444557509}]
[30,{"$f":"SUM(Valores_GEO_Areas!E75:I75)","v":2.6681908607737759},{"$f":"SUM(Valores_GEO_Areas!J75:K75)","v":1.0200778847699496},{"$f":"SUM(Valores_GEO_Areas!L75:P75)","v":2.7466567106907478},{"$f":"SUM(Valores_GEO_Areas!Q75:U75)","v":4.453225062095215},{"$f":"SUM(Valores_GEO_Areas!V75:Z75)","v":5},{"$f":"SUM(Valores_GEO_Areas!AA75:AE75)","v":4.1867264025221802},{"$f":"SUM(Valores_GEO_Areas!AF75:AJ75)","v":3.3885578872589432},{"$f":"SUM(Valores_GEO_Areas!AK75:AO75)","v":2.9981530288252016}]
[31,{"$f":"SUM(Valores_GEO_Areas!E76:I76)","v":4.1156919194161024},{"$f":"SUM(Valores_GEO_Areas!J76:K76)","v":1.7375006857047168},{"$f":"SUM(Valores_GEO_Areas!L76:P76)","v":3.4746491357233387},{"$f":"SUM(Valores_GEO_Areas!Q76:U76)","v":4.1180076163749169},{"$f":"SUM(Valores_GEO_Areas!V76:Z76)","v":4.5577016910200108},{"$f":"SUM(Valores_GEO_Areas!AA76:AE76)","v":4.8444935803220526},{"$f":"SUM(Valores_GEO_Areas!AF76:AJ76)","v":1.5092519611154902},{"$f":"SUM(Valores_GEO_Areas!AK76:AO76)","v":3}]
[32,{"$f":"SUM(Valores_GEO_Areas!E77:I77)","v":4.1935691768201018},{"$f":"SUM(Valores_GEO_Areas!J77:K77)","v":1.6233426584516595},{"$f":"SUM(Valores_GEO_Areas!L77:P77)","v":2.3517939144212887},{"$f":"SUM(Valores_GEO_Areas!Q77:U77)","v":3.6279903790375423},{"$f":"SUM(Valores_GEO_Areas!V77:Z77)","v":4.6828957501925368},{"$f":"SUM(Valores_GEO_Areas!AA77:AE77)","v":4.9881886417946353},{"$f":"SUM(Valores_GEO_Areas!AF77:AJ77)","v":1.1067167283163177},{"$f":"SUM(Valores_GEO_Areas!AK77:AO77)","v":3}]
[33,{"$f":"SUM(Valores_GEO_Areas!E78:I78)","v":4.0164983177125215},{"$f":"SUM(Valores_GEO_Areas!J78:K78)","v":1.058953778023803},{"$f":"SUM(Valores_GEO_Areas!L78:P78)","v":4.9878079158593964},{"$f":"SUM(Valores_GEO_Areas!Q78:U78)","v":4.140997785773596},{"$f":"SUM(Valores_GEO_Areas!V78:Z78)","v":4.4049681704954331},{"$f":"SUM(Valores_GEO_Areas!AA78:AE78)","v":4.3406087944874621},{"$f":"SUM(Valores_GEO_Areas!AF78:AJ78)","v":2.3670772211458622},{"$f":"SUM(Valores_GEO_Areas!AK78:AO78)","v":2.5398872128425132}]
[34,{"$f":"SUM(Valores_GEO_Areas!E79:I79)","v":3.0856790475631137},{"$f":"SUM(Valores_GEO_Areas!J79:K79)","v":1.0154048589492601},{"$f":"SUM(Valores_GEO_Areas!L79:P79)","v":2},{"$f":"SUM(Valores_GEO_Areas!Q79:U79)","v":2.7354536410025996},{"$f":"SUM(Valores_GEO_Areas!V79:Z79)","v":4.8746622163740811},{"$f":"SUM(Valores_GEO_Areas!AA79:AE79)","v":3.8612599890882251},{"$f":"SUM(Valores_GEO_Areas!AF79:AJ79)","v":3.7540485894926023},{"$f":"SUM(Valores_GEO_Areas!AK79:AO79)","v":2.6959465964889762}]
[35,{"$f":"SUM(Valores_GEO_Areas!E80:I80)","v":4.44769039583249},{"$f":"SUM(Valores_GEO_Areas!J80:K80)","v":1},{"$f":"SUM(Valores_GEO_Areas!L80:P80)","v":3},{"$f":"SUM(Valores_GEO_Areas!Q80:U80)","v":4.7749061456426887},{"$f":"SUM(Valores_GEO_Areas!V80:Z80)","v":4.9356199790670523},{"$f":"SUM(Valores_GEO_Areas!AA80:AE80)","v":4.9965005210067694},{"$f":"SUM(Valores_GEO_Areas!AF80:AJ80)","v":1.0215716592968516},{"$f":"SUM(Valores_GEO_Areas!AK80:AO80)","v":3.758944898956849}]
[36,{"$f":"SUM(Valores_GEO_Areas!E81:I81)","v":4.3526584228378749},{"$f":"SUM(Valores_GEO_Areas!J81:K81)","v":1.2334677590125596},{"$f":"SUM(Valores_GEO_Areas!L81:P81)","v":3.6615562948706488},{"$f":"SUM(Valores_GEO_Areas!Q81:U81)","v":4.5510190156652186},{"$f":"SUM(Valores_GEO_Areas!V81:Z81)","v":4.4840030304598866},{"$f":"SUM(Valores_GEO_Areas!AA81:AE81)","v":4.9322579904354713},{"$f":"SUM(Valores_GEO_Areas!AF81:AJ81)","v":1.3081375377042854},{"$f":"SUM(Valores_GEO_Areas!AK81:AO81)","v":3.6917691329151552}]
[]
["* Para esta variable talvez se puede ver si mas del 80% del area es humedal, ya que los valores aca eran solo 1 si no habia humedal o 5 si habia humedal."]
["Sin embargo, el promedio ponderado tambien nos da una idea de cuan importantes son los humedales en el area buffer de la carretera."]
[]
[17.100000000000001,{"$f":"SUM(Valores_GEO_Areas!E61:I61)","v":2.3437731694713428},{"$f":"SUM(Valores_GEO_Areas!J61:K61)","v":1.0689324180086688},{"$f":"SUM(Valores_GEO_Areas!L61:P61)","v":2.6583094334627604},{"$f":"SUM(Valores_GEO_Areas!Q61:U61)","v":2.1238597439560496},{"$f":"SUM(Valores_GEO_Areas!V61:Z61)","v":3.709309097326392},{"$f":"SUM(Valores_GEO_Areas!AA61:AE61)","v":3.7323247004481166},{"$f":"SUM(Valores_GEO_Areas!AF61:AJ61)","v":1.5380274405849508},{"$f":"SUM(Valores_GEO_Areas!AK61:AO61)","v":1.9424617995293141}]
[17.2,{"$f":"SUM(Valores_GEO_Areas!E62:I62)","v":1.9893983214989086},{"$f":"SUM(Valores_GEO_Areas!J62:K62)","v":1.0749237181228408},{"$f":"SUM(Valores_GEO_Areas!L62:P62)","v":1.7922641594328725},{"$f":"SUM(Valores_GEO_Areas!Q62:U62)","v":2.2293205705267822},{"$f":"SUM(Valores_GEO_Areas!V62:Z62)","v":3.5915357529117098},{"$f":"SUM(Valores_GEO_Areas!AA62:AE62)","v":3.6546639231824423},{"$f":"SUM(Valores_GEO_Areas!AF62:AJ62)","v":1.3868011938467897},{"$f":"SUM(Valores_GEO_Areas!AK62:AO62)","v":2}]

{"sheet":"Valores Filtro Var NO GEO","index":6,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Carretera","Costo Inversión (Rangos)","PIB Regional (Rangos)","Afectación a pueblos en aislamiento (Rangos)","Posibilidad de daños arqueológicos (Rangos)","Rechazo de la poblacion local (Rangos)","Vulneración de normas (Rangos)","Existencia de presión externa","Longitud rutas","Tipo de inversión"]
[1,{"$f":"'CostInv-Tipo'!AA2","v":3},{"$f":"'Longitud-PIB regional'!P3","v":1},{"$f":"'variables soc-leg'!G3","v":1},{"$f":"'variables soc-leg'!I3","v":5},{"$f":"'variables soc-leg'!K3","v":3},{"$f":"'variables soc-leg'!M3","v":1},{"$f":"'variables soc-leg'!O3","v":3},{"$f":"'Longitud-PIB regional'!J3","v":1},{"$f":"'CostInv-Tipo'!AE2","v":5}]
[2,{"$f":"'CostInv-Tipo'!AA3","v":1},{"$f":"'Longitud-PIB regional'!P4","v":5},{"$f":"'variables soc-leg'!G4","v":1},{"$f":"'variables soc-leg'!I4","v":1},{"$f":"'variables soc-leg'!K4","v":2},{"$f":"'variables soc-leg'!M4","v":1},{"$f":"'variables soc-leg'!O4","v":2},{"$f":"'Longitud-PIB regional'!J4","v":1},{"$f":"'CostInv-Tipo'!AE3","v":1}]
[3,{"$f":"'CostInv-Tipo'!AA4","v":1},{"$f":"'Longitud-PIB regional'!P5","v":5},{"$f":"'variables soc-leg'!G5","v":1},{"$f":"'variables soc-leg'!I5","v":1},{"$f":"'variables soc-leg'!K5","v":1},{"$f":"'variables soc-leg'!M5","v":1},{"$f":"'variables soc-leg'!O5","v":3},{"$f":"'Longitud-PIB regional'!J5","v":1},{"$f":"'CostInv-Tipo'!AE4","v":1}]
[4,{"$f":"'CostInv-Tipo'!AA5","v":1},{"$f":"'Longitud-PIB regional'!P6","v":1},{"$f":"'variables soc-leg'!G6","v":1},{"$f":"'variables soc-leg'!I6","v":1},{"$f":"'variables soc-leg'!K6","v":1},{"$f":"'variables soc-leg'!M6","v":1},{"$f":"'variables soc-leg'!O6","v":2},{"$f":"'Longitud-PIB regional'!J6","v":1},{"$f":"'CostInv-Tipo'!AE5","v":5}]
[5,{"$f":"'CostInv-Tipo'!AA6","v":2},{"$f":"'Longitud-PIB regional'!P7","v":2},{"$f":"'variables soc-leg'!G7","v":1},{"$f":"'variables soc-leg'!I7","v":1},{"$f":"'variables soc-leg'!K7","v":1},{"$f":"'variables soc-leg'!M7","v":1},{"$f":"'variables soc-leg'!O7","v":2},{"$f":"'Longitud-PIB regional'!J7","v":1},{"$f":"'CostInv-Tipo'!AE6","v":1}]
[6,{"$f":"'CostInv-Tipo'!AA7","v":1},{"$f":"'Longitud-PIB regional'!P8","v":5},{"$f":"'variables soc-leg'!G8","v":1},{"$f":"'variables soc-leg'!I8","v":1},{"$f":"'variables soc-leg'!K8","v":1},{"$f":"'variables soc-leg'!M8","v":1},{"$f":"'variables soc-leg'!O8","v":3},{"$f":"'Longitud-PIB regional'!J8","v":2},{"$f":"'CostInv-Tipo'!AE7","v":5}]
[7,{"$f":"'CostInv-Tipo'!AA8","v":3},{"$f":"'Longitud-PIB regional'!P9","v":4},{"$f":"'variables soc-leg'!G9","v":1},{"$f":"'variables soc-leg'!I9","v":1},{"$f":"'variables soc-leg'!K9","v":3},{"$f":"'variables soc-leg'!M9","v":1},{"$f":"'variables soc-leg'!O9","v":2},{"$f":"'Longitud-PIB regional'!J9","v":1},{"$f":"'CostInv-Tipo'!AE8","v":1}]
[8,{"$f":"'CostInv-Tipo'!AA9","v":2},{"$f":"'Longitud-PIB regional'!P10","v":5},{"$f":"'variables soc-leg'!G10","v":1},{"$f":"'variables soc-leg'!I10","v":1},{"$f":"'variables soc-leg'!K10","v":2},{"$f":"'variables soc-leg'!M10","v":1},{"$f":"'variables soc-leg'!O10","v":3},{"$f":"'Longitud-PIB regional'!J10","v":1},{"$f":"'CostInv-Tipo'!AE9","v":1}]
[9,{"$f":"'CostInv-Tipo'!AA10","v":5},{"$f":"'Longitud-PIB regional'!P11","v":3},{"$f":"'variables soc-leg'!G11","v":1},{"$f":"'variables soc-leg'!I11","v":1},{"$f":"'variables soc-leg'!K11","v":2},{"$f":"'variables soc-leg'!M11","v":1},{"$f":"'variables soc-leg'!O11","v":3},{"$f":"'Longitud-PIB regional'!J11","v":1},{"$f":"'CostInv-Tipo'!AE10","v":1}]
[10,{"$f":"'CostInv-Tipo'!AA11","v":1},{"$f":"'Longitud-PIB regional'!P12","v":5},{"$f":"'variables soc-leg'!G12","v":1},{"$f":"'variables soc-leg'!I12","v":1},{"$f":"'variables soc-leg'!K12","v":2},{"$f":"'variables soc-leg'!M12","v":1},{"$f":"'variables soc-leg'!O12","v":3},{"$f":"'Longitud-PIB regional'!J12","v":1},{"$f":"'CostInv-Tipo'!AE11","v":5}]
[11,{"$f":"'CostInv-Tipo'!AA12","v":5},{"$f":"'Longitud-PIB regional'!P13","v":4},{"$f":"'variables soc-leg'!G13","v":1},{"$f":"'variables soc-leg'!I13","v":5},{"$f":"'variables soc-leg'!K13","v":3},{"$f":"'variables soc-leg'!M13","v":1},{"$f":"'variables soc-leg'!O13","v":4},{"$f":"'Longitud-PIB regional'!J13","v":1},{"$f":"'CostInv-Tipo'!AE12","v":5}]
[12,{"$f":"'CostInv-Tipo'!AA13","v":3},{"$f":"'Longitud-PIB regional'!P14","v":5},{"$f":"'variables soc-leg'!G14","v":1},{"$f":"'variables soc-leg'!I14","v":1},{"$f":"'variables soc-leg'!K14","v":3},{"$f":"'variables soc-leg'!M14","v":5},{"$f":"'variables soc-leg'!O14","v":2},{"$f":"'Longitud-PIB regional'!J14","v":2},{"$f":"'CostInv-Tipo'!AE13","v":5}]
[13,{"$f":"'CostInv-Tipo'!AA14","v":3},{"$f":"'Longitud-PIB regional'!P15","v":5},{"$f":"'variables soc-leg'!G15","v":1},{"$f":"'variables soc-leg'!I15","v":1},{"$f":"'variables soc-leg'!K15","v":2},{"$f":"'variables soc-leg'!M15","v":1},{"$f":"'variables soc-leg'!O15","v":2},{"$f":"'Longitud-PIB regional'!J15","v":2},{"$f":"'CostInv-Tipo'!AE14","v":5}]
[14,{"$f":"'CostInv-Tipo'!AA15","v":5},{"$f":"'Longitud-PIB regional'!P16","v":1},{"$f":"'variables soc-leg'!G16","v":1},{"$f":"'variables soc-leg'!I16","v":1},{"$f":"'variables soc-leg'!K16","v":5},{"$f":"'variables soc-leg'!M16","v":5},{"$f":"'variables soc-leg'!O16","v":5},{"$f":"'Longitud-PIB regional'!J16","v":2},{"$f":"'CostInv-Tipo'!AE15","v":5}]
[15,{"$f":"'CostInv-Tipo'!AA16","v":5},{"$f":"'Longitud-PIB regional'!P17","v":2},{"$f":"'variables soc-leg'!G17","v":1},{"$f":"'variables soc-leg'!I17","v":5},{"$f":"'variables soc-leg'!K17","v":2},{"$f":"'variables soc-leg'!M17","v":1},{"$f":"'variables soc-leg'!O17","v":2},{"$f":"'Longitud-PIB regional'!J17","v":2},{"$f":"'CostInv-Tipo'!AE16","v":5}]
[16,{"$f":"'CostInv-Tipo'!AA17","v":4},{"$f":"'Longitud-PIB regional'!P18","v":5},{"$f":"'variables soc-leg'!G18","v":1},{"$f":"'variables soc-leg'!I18","v":1},{"$f":"'variables soc-leg'!K18","v":2},{"$f":"'variables soc-leg'!M18","v":1},{"$f":"'variables soc-leg'!O18","v":2},{"$f":"'Longitud-PIB regional'!J18","v":5},{"$f":"'CostInv-Tipo'!AE17","v":5}]
[17,{"$f":"'CostInv-Tipo'!AA18","v":4},{"$f":"'Longitud-PIB regional'!P19","v":2},{"$f":"'variables soc-leg'!G19","v":1},{"$f":"'variables soc-leg'!I19","v":1},{"$f":"'variables soc-leg'!K19","v":2},{"$f":"'variables soc-leg'!M19","v":1},{"$f":"'variables soc-leg'!O19","v":2},{"$f":"'Longitud-PIB regional'!J19","v":5},{"$f":"'CostInv-Tipo'!AE18","v":5}]
[18,{"$f":"'CostInv-Tipo'!AA19","v":3},{"$f":"'Longitud-PIB regional'!P20","v":5},{"$f":"'variables soc-leg'!G20","v":1},{"$f":"'variables soc-leg'!I20","v":1},{"$f":"'variables soc-leg'!K20","v":3},{"$f":"'variables soc-leg'!M20","v":1},{"$f":"'variables soc-leg'!O20","v":2},{"$f":"'Longitud-PIB regional'!J20","v":3},{"$f":"'CostInv-Tipo'!AE19","v":1}]
[19,{"$f":"'CostInv-Tipo'!AA20","v":3},{"$f":"'Longitud-PIB regional'!P21","v":5},{"$f":"'variables soc-leg'!G21","v":1},{"$f":"'variables soc-leg'!I21","v":1},{"$f":"'variables soc-leg'!K21","v":2},{"$f":"'variables soc-leg'!M21","v":1},{"$f":"'variables soc-leg'!O21","v":5},{"$f":"'Longitud-PIB regional'!J21","v":5},{"$f":"'CostInv-Tipo'!AE20","v":1}]
[20,{"$f":"'CostInv-Tipo'!AA21","v":2},{"$f":"'Longitud-PIB regional'!P22","v":5},{"$f":"'variables soc-leg'!G22","v":1},{"$f":"'variables soc-leg'!I22","v":1},{"$f":"'variables soc-leg'!K22","v":1},{"$f":"'variables soc-leg'!M22","v":1},{"$f":"'variables soc-leg'!O22","v":1},{"$f":"'Longitud-PIB regional'!J22","v":5},{"$f":"'CostInv-Tipo'!AE21","v":1}]
[21,{"$f":"'CostInv-Tipo'!AA22","v":2},{"$f":"'Longitud-PIB regional'!P23","v":1},{"$f":"'variables soc-leg'!G23","v":1},{"$f":"'variables soc-leg'!I23","v":1},{"$f":"'variables soc-leg'!K23","v":1},{"$f":"'variables soc-leg'!M23","v":1},{"$f":"'variables soc-leg'!O23","v":1},{"$f":"'Longitud-PIB regional'!J23","v":1},{"$f":"'CostInv-Tipo'!AE22","v":5}]
[22,{"$f":"'CostInv-Tipo'!AA23","v":2},{"$f":"'Longitud-PIB regional'!P24","v":5},{"$f":"'variables soc-leg'!G24","v":1},{"$f":"'variables soc-leg'!I24","v":1},{"$f":"'variables soc-leg'!K24","v":1},{"$f":"'variables soc-leg'!M24","v":5},{"$f":"'variables soc-leg'!O24","v":1},{"$f":"'Longitud-PIB regional'!J24","v":3},{"$f":"'CostInv-Tipo'!AE23","v":1}]
[23,{"$f":"'CostInv-Tipo'!AA24","v":2},{"$f":"'Longitud-PIB regional'!P25","v":2},{"$f":"'variables soc-leg'!G25","v":1},{"$f":"'variables soc-leg'!I25","v":1},{"$f":"'variables soc-leg'!K25","v":1},{"$f":"'variables soc-leg'!M25","v":1},{"$f":"'variables soc-leg'!O25","v":3},{"$f":"'Longitud-PIB regional'!J25","v":2},{"$f":"'CostInv-Tipo'!AE24","v":5}]
[24,{"$f":"'CostInv-Tipo'!AA25","v":2},{"$f":"'Longitud-PIB regional'!P26","v":1},{"$f":"'variables soc-leg'!G26","v":1},{"$f":"'variables soc-leg'!I26","v":1},{"$f":"'variables soc-leg'!K26","v":1},{"$f":"'variables soc-leg'!M26","v":1},{"$f":"'variables soc-leg'!O26","v":3},{"$f":"'Longitud-PIB regional'!J26","v":5},{"$f":"'CostInv-Tipo'!AE25","v":5}]
[25,{"$f":"'CostInv-Tipo'!AA26","v":3},{"$f":"'Longitud-PIB regional'!P27","v":1},{"$f":"'variables soc-leg'!G27","v":1},{"$f":"'variables soc-leg'!I27","v":1},{"$f":"'variables soc-leg'!K27","v":5},{"$f":"'variables soc-leg'!M27","v":5},{"$f":"'variables soc-leg'!O27","v":4},{"$f":"'Longitud-PIB regional'!J27","v":3},{"$f":"'CostInv-Tipo'!AE26","v":5}]
[26,{"$f":"'CostInv-Tipo'!AA27","v":2},{"$f":"'Longitud-PIB regional'!P28","v":3},{"$f":"'variables soc-leg'!G28","v":5},{"$f":"'variables soc-leg'!I28","v":1},{"$f":"'variables soc-leg'!K28","v":3},{"$f":"'variables soc-leg'!M28","v":1},{"$f":"'variables soc-leg'!O28","v":2},{"$f":"'Longitud-PIB regional'!J28","v":4},{"$f":"'CostInv-Tipo'!AE27","v":1}]
[27,{"$f":"'CostInv-Tipo'!AA28","v":1},{"$f":"'Longitud-PIB regional'!P29","v":4},{"$f":"'variables soc-leg'!G29","v":1},{"$f":"'variables soc-leg'!I29","v":1},{"$f":"'variables soc-leg'!K29","v":2},{"$f":"'variables soc-leg'!M29","v":1},{"$f":"'variables soc-leg'!O29","v":2},{"$f":"'Longitud-PIB regional'!J29","v":2},{"$f":"'CostInv-Tipo'!AE28","v":1}]
[28,{"$f":"'CostInv-Tipo'!AA29","v":2},{"$f":"'Longitud-PIB regional'!P30","v":4},{"$f":"'variables soc-leg'!G30","v":5},{"$f":"'variables soc-leg'!I30","v":1},{"$f":"'variables soc-leg'!K30","v":4},{"$f":"'variables soc-leg'!M30","v":5},{"$f":"'variables soc-leg'!O30","v":3},{"$f":"'Longitud-PIB regional'!J30","v":4},{"$f":"'CostInv-Tipo'!AE29","v":5}]
[29,{"$f":"'CostInv-Tipo'!AA30","v":3},{"$f":"'Longitud-PIB regional'!P31","v":2},{"$f":"'variables soc-leg'!G31","v":5},{"$f":"'variables soc-leg'!I31","v":1},{"$f":"'variables soc-leg'!K31","v":3},{"$f":"'variables soc-leg'!M31","v":1},{"$f":"'variables soc-leg'!O31","v":2},{"$f":"'Longitud-PIB regional'!J31","v":4},{"$f":"'CostInv-Tipo'!AE30","v":1}]
[30,{"$f":"'CostInv-Tipo'!AA31","v":1},{"$f":"'Longitud-PIB regional'!P32","v":2},{"$f":"'variables soc-leg'!G32","v":1},{"$f":"'variables soc-leg'!I32","v":1},{"$f":"'variables soc-leg'!K32","v":2},{"$f":"'variables soc-leg'!M32","v":5},{"$f":"'variables soc-leg'!O32","v":3},{"$f":"'Longitud-PIB regional'!J32","v":1},{"$f":"'CostInv-Tipo'!AE31","v":5}]
[31,{"$f":"'CostInv-Tipo'!AA32","v":2},{"$f":"'Longitud-PIB regional'!P33","v":3},{"$f":"'variables soc-leg'!G33","v":5},{"$f":"'variables soc-leg'!I33","v":1},{"$f":"'variables soc-leg'!K33","v":2},{"$f":"'variables soc-leg'!M33","v":1},{"$f":"'variables soc-leg'!O33","v":3},{"$f":"'Longitud-PIB regional'!J33","v":2},{"$f":"'CostInv-Tipo'!AE32","v":5}]
[32,{"$f":"'CostInv-Tipo'!AA33","v":2},{"$f":"'Longitud-PIB regional'!P34","v":5},{"$f":"'variables soc-leg'!G34","v":5},{"$f":"'variables soc-leg'!I34","v":1},{"$f":"'variables soc-leg'!K34","v":5},{"$f":"'variables soc-leg'!M34","v":5},{"$f":"'variables soc-leg'!O34","v":4},{"$f":"'Longitud-PIB regional'!J34","v":2},{"$f":"'CostInv-Tipo'!AE33","v":5}]
[33,{"$f":"'CostInv-Tipo'!AA34","v":3},{"$f":"'Longitud-PIB regional'!P35","v":3},{"$f":"'variables soc-leg'!G35","v":5},{"$f":"'variables soc-leg'!I35","v":1},{"$f":"'variables soc-leg'!K35","v":3},{"$f":"'variables soc-leg'!M35","v":5},{"$f":"'variables soc-leg'!O35","v":4},{"$f":"'Longitud-PIB regional'!J35","v":2},{"$f":"'CostInv-Tipo'!AE34","v":5}]
[34,{"$f":"'CostInv-Tipo'!AA35","v":2},{"$f":"'Longitud-PIB regional'!P36","v":1},{"$f":"'variables soc-leg'!G36","v":1},{"$f":"'variables soc-leg'!I36","v":5},{"$f":"'variables soc-leg'!K36","v":2},{"$f":"'variables soc-leg'!M36","v":5},{"$f":"'variables soc-leg'!O36","v":1},{"$f":"'Longitud-PIB regional'!J36","v":1},{"$f":"'CostInv-Tipo'!AE35","v":5}]
[35,{"$f":"'CostInv-Tipo'!AA36","v":2},{"$f":"'Longitud-PIB regional'!P37","v":5},{"$f":"'variables soc-leg'!G37","v":5},{"$f":"'variables soc-leg'!I37","v":1},{"$f":"'variables soc-leg'!K37","v":5},{"$f":"'variables soc-leg'!M37","v":5},{"$f":"'variables soc-leg'!O37","v":1},{"$f":"'Longitud-PIB regional'!J37","v":3},{"$f":"'CostInv-Tipo'!AE36","v":5}]
[36,{"$f":"'CostInv-Tipo'!AA37","v":2},{"$f":"'Longitud-PIB regional'!P38","v":5},{"$f":"'variables soc-leg'!G38","v":5},{"$f":"'variables soc-leg'!I38","v":1},{"$f":"'variables soc-leg'!K38","v":2},{"$f":"'variables soc-leg'!M38","v":5},{"$f":"'variables soc-leg'!O38","v":1},{"$f":"'Longitud-PIB regional'!J38","v":4},{"$f":"'CostInv-Tipo'!AE37","v":5}]

{"sheet":"Panel Pesos","index":7,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[[26,1,26,2],[2,6,2,7],[2,4,2,5],[0,1,0,7],[2,1,2,2],[10,1,10,2],[20,1,20,2]]}
[null,"Tabla de control - asignación de pesos"]
[]
[null,"ECONOMICOS",null,null,"Ponderación categorías",null,"Ponderación final"]
[null,null,null,null,0.4]
["V1","Costo de Inversión ",0.4,null,null,null,{"$f":"C5*$E$4","v":0.16000000000000003}]
["V2","Pendiente (Como aproximación del costo de mantenimiento)",0.1,null,null,null,{"$f":"C6*$E$4","v":4.0000000000000008E-2}]
["V3","PIB Regional (De todos los municipios atravesados por el tramo)",0.1,null,null,null,{"$f":"C7*$E$4","v":4.0000000000000008E-2}]
["V4","Densidad poblacional ",0.2,null,null,null,{"$f":"C8*$E$4","v":8.0000000000000016E-2}]
["V5","Ingreso bruto por agricultura ",0.2,null,null,null,{"$f":"C9*$E$4","v":8.0000000000000016E-2}]
[]
[null,"AMBIENTALES "]
[null,null,null,null,0.45]
["V6","Cobertura de arboles ",0.2,null,null,null,{"$f":"C13*$E$12","v":9.0000000000000011E-2}]
["V7","Existencia de humedales ",0.1,null,null,null,4.5000000000000005E-2]
["V8","Balance hidrico promedio ",0.1,null,null,null,4.5000000000000005E-2]
["V9","Grado de intervencion humana ",0.1,null,null,null,4.5000000000000005E-2]
["V10","Proximidad a areas de conservacion y tierras indígenas",0.2,null,null,null,9.0000000000000011E-2]
["V11","Longitud rutas",0.2,null,null,null,9.0000000000000011E-2]
["V12","Típo de inversión",0.1,null,null,null,4.5000000000000005E-2]
[]
[null,"DISPOSICION SOCIAL / CUMPLIMIENTO NORMATIVA"]
[null,null,null,null,0.1]
["V13","Grado de rechazo de la poblacion local ",0.4,null,null,null,{"$f":"$E$22*C23","v":4.0000000000000008E-2}]
["V14","Vulneración de normas legales",0.3,null,null,null,{"$f":"$E$22*C24","v":0.03}]
["V15","Existencia de presión externa",0.3,null,null,null,{"$f":"$E$22*C25","v":0.03}]
[]
[null,"CULTURAL"]
[null,null,null,null,0.05]
["V16","Afectación a pueblos en aislamiento voluntario",0.5,null,null,null,{"$f":"$E$28*C29","v":2.5000000000000001E-2}]
["V17","Posibilidad de daños arqueológicos ",0.5,null,null,null,{"$f":"$E$28*C30","v":2.5000000000000001E-2}]

{"sheet":"resultados","index":8,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,1,2,2],[28,1,28,2]]}
[]
[]
[null,"PESOS VARIABLES",null,null,"ID","PAIS","TRAMO","CARRETERA","ECONOMICOS","AMBIENTAL","SOCIAL","CULTURAL","TOTAL"]
[null,"ECONOMICOS",0.4,null,1,"Ecuador","Via al Emblase Compensador","Via al Emblase Compensador. Coca Codo Sinclair",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B8)+($C$6*'Valores Filtro Var GEO'!H8)+($C$7*'Valores Filtro Var NO GEO'!C8)+($C$8*'Valores Filtro Var GEO'!I8)+($C$9*'Valores Filtro Var GEO'!G8)","v":3.0920105117599066},{"$f":"($C$12*'Valores Filtro Var GEO'!B2)+($C$13*'Valores Filtro Var GEO'!C2)+($C$14*'Valores Filtro Var GEO'!D2)+($C$15*'Valores Filtro Var GEO'!E2)+($C$16*'Valores Filtro Var GEO'!F2)+($C$17*'Valores Filtro Var NO GEO'!I2)+($C$18*'Valores Filtro Var NO GEO'!J2)","v":3.3497235930817824},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F11)+($C$22*'Valores Filtro Var NO GEO'!G11)+($C$23*'Valores Filtro Var NO GEO'!H11)","v":2},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D2)+($C$27*'Valores Filtro Var NO GEO'!E2)","v":3},{"$f":"(I4*$C$4)+(J4*$C$11)+(K4*$C$20)+(L4*$C$25)","v":3.0941798215907648}]
[null,"Costo de Inversión ",0.4,null,2,"Ecuador","Coca - La Belleza","Coca - La Belleza",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B24)+($C$6*'Valores Filtro Var GEO'!H24)+($C$7*'Valores Filtro Var NO GEO'!C24)+($C$8*'Valores Filtro Var GEO'!I24)+($C$9*'Valores Filtro Var GEO'!G24)","v":2.268000009976439},{"$f":"($C$12*'Valores Filtro Var GEO'!B3)+($C$13*'Valores Filtro Var GEO'!C3)+($C$14*'Valores Filtro Var GEO'!D3)+($C$15*'Valores Filtro Var GEO'!E3)+($C$16*'Valores Filtro Var GEO'!F3)+($C$17*'Valores Filtro Var NO GEO'!I3)+($C$18*'Valores Filtro Var NO GEO'!J3)","v":2.6340948303992726},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F35)+($C$22*'Valores Filtro Var NO GEO'!G35)+($C$23*'Valores Filtro Var NO GEO'!H35)","v":2.5999999999999996},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D3)+($C$27*'Valores Filtro Var NO GEO'!E3)","v":1},2.4025426776702479]
[null,"Pendiente (Como aproximación del costo de mantenimiento)",0.1,null,3,"Ecuador","Sucua - Bella Unión","Cuenca  -Macas",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B28)+($C$6*'Valores Filtro Var GEO'!H28)+($C$7*'Valores Filtro Var NO GEO'!C28)+($C$8*'Valores Filtro Var GEO'!I28)+($C$9*'Valores Filtro Var GEO'!G28)","v":2.3545617941100998},{"$f":"($C$12*'Valores Filtro Var GEO'!B4)+($C$13*'Valores Filtro Var GEO'!C4)+($C$14*'Valores Filtro Var GEO'!D4)+($C$15*'Valores Filtro Var GEO'!E4)+($C$16*'Valores Filtro Var GEO'!F4)+($C$17*'Valores Filtro Var NO GEO'!I4)+($C$18*'Valores Filtro Var NO GEO'!J4)","v":2.5790741787171476},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F36)+($C$22*'Valores Filtro Var NO GEO'!G36)+($C$23*'Valores Filtro Var NO GEO'!H36)","v":3.8},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D4)+($C$27*'Valores Filtro Var NO GEO'!E4)","v":1},2.5324080980667558]
[null,"PIB Regional (De todos los municipios atravesados por el tramo)",0.1,null,4,"Ecuador","Cangaime - Taisha","Macuma - Taisha",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B27)+($C$6*'Valores Filtro Var GEO'!H27)+($C$7*'Valores Filtro Var NO GEO'!C27)+($C$8*'Valores Filtro Var GEO'!I27)+($C$9*'Valores Filtro Var GEO'!G27)","v":2.9445193618025822},{"$f":"($C$12*'Valores Filtro Var GEO'!B5)+($C$13*'Valores Filtro Var GEO'!C5)+($C$14*'Valores Filtro Var GEO'!D5)+($C$15*'Valores Filtro Var GEO'!E5)+($C$16*'Valores Filtro Var GEO'!F5)+($C$17*'Valores Filtro Var NO GEO'!I5)+($C$18*'Valores Filtro Var NO GEO'!J5)","v":2.8840487144790261},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F27)+($C$22*'Valores Filtro Var NO GEO'!G27)+($C$23*'Valores Filtro Var NO GEO'!H27)","v":2.1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D5)+($C$27*'Valores Filtro Var NO GEO'!E5)","v":1},2.7356296662365942]
[null,"Densidad poblacional ",0.2,null,5,"Ecuador","Loreto - Murialdo","Sucumbios - Orellana",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B21)+($C$6*'Valores Filtro Var GEO'!H21)+($C$7*'Valores Filtro Var NO GEO'!C21)+($C$8*'Valores Filtro Var GEO'!I21)+($C$9*'Valores Filtro Var GEO'!G21)","v":2.7541476768298558},{"$f":"($C$12*'Valores Filtro Var GEO'!B6)+($C$13*'Valores Filtro Var GEO'!C6)+($C$14*'Valores Filtro Var GEO'!D6)+($C$15*'Valores Filtro Var GEO'!E6)+($C$16*'Valores Filtro Var GEO'!F6)+($C$17*'Valores Filtro Var NO GEO'!I6)+($C$18*'Valores Filtro Var NO GEO'!J6)","v":2.7773841677902156},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F32)+($C$22*'Valores Filtro Var NO GEO'!G32)+($C$23*'Valores Filtro Var NO GEO'!H32)","v":2},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D6)+($C$27*'Valores Filtro Var NO GEO'!E6)","v":1},2.6014819462375396]
[null,"Ingreso bruto por agricultura ",0.2,null,6,"Ecuador","Sardina - Lumbaqui","Lumbaqui - Maderos - Sardina - Puccuna",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B18)+($C$6*'Valores Filtro Var GEO'!H18)+($C$7*'Valores Filtro Var NO GEO'!C18)+($C$8*'Valores Filtro Var GEO'!I18)+($C$9*'Valores Filtro Var GEO'!G18)","v":3.0791864740375745},{"$f":"($C$12*'Valores Filtro Var GEO'!B7)+($C$13*'Valores Filtro Var GEO'!C7)+($C$14*'Valores Filtro Var GEO'!D7)+($C$15*'Valores Filtro Var GEO'!E7)+($C$16*'Valores Filtro Var GEO'!F7)+($C$17*'Valores Filtro Var NO GEO'!I7)+($C$18*'Valores Filtro Var NO GEO'!J7)","v":3.4663549284301918},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F14)+($C$22*'Valores Filtro Var NO GEO'!G14)+($C$23*'Valores Filtro Var NO GEO'!H14)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D7)+($C$27*'Valores Filtro Var NO GEO'!E7)","v":1},3.0115343074086161]
[null,null,null,null,7,"Ecuador","Chuchumbletza - Ingreso Proyecto Mirador","Vía Acceso: Puerto Mirador",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B16)+($C$6*'Valores Filtro Var GEO'!H16)+($C$7*'Valores Filtro Var NO GEO'!C16)+($C$8*'Valores Filtro Var GEO'!I16)+($C$9*'Valores Filtro Var GEO'!G16)","v":3.3614980221837145},{"$f":"($C$12*'Valores Filtro Var GEO'!B8)+($C$13*'Valores Filtro Var GEO'!C8)+($C$14*'Valores Filtro Var GEO'!D8)+($C$15*'Valores Filtro Var GEO'!E8)+($C$16*'Valores Filtro Var GEO'!F8)+($C$17*'Valores Filtro Var NO GEO'!I8)+($C$18*'Valores Filtro Var NO GEO'!J8)","v":2.8271169449212761},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F22)+($C$22*'Valores Filtro Var NO GEO'!G22)+($C$23*'Valores Filtro Var NO GEO'!H22)","v":1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D8)+($C$27*'Valores Filtro Var NO GEO'!E8)","v":1},2.76680183408806]
[null,"AMBIENTAL ",0.45,null,8,"Ecuador","Sushufindi - Pto. Providencia","Sushufindi - Pto. Providencia",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B17)+($C$6*'Valores Filtro Var GEO'!H17)+($C$7*'Valores Filtro Var NO GEO'!C17)+($C$8*'Valores Filtro Var GEO'!I17)+($C$9*'Valores Filtro Var GEO'!G17)","v":3.5208932157667205},{"$f":"($C$12*'Valores Filtro Var GEO'!B9)+($C$13*'Valores Filtro Var GEO'!C9)+($C$14*'Valores Filtro Var GEO'!D9)+($C$15*'Valores Filtro Var GEO'!E9)+($C$16*'Valores Filtro Var GEO'!F9)+($C$17*'Valores Filtro Var NO GEO'!I9)+($C$18*'Valores Filtro Var NO GEO'!J9)","v":2.7930616149994969},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F19)+($C$22*'Valores Filtro Var NO GEO'!G19)+($C$23*'Valores Filtro Var NO GEO'!H19)","v":2.1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D9)+($C$27*'Valores Filtro Var NO GEO'!E9)","v":1},2.9252350130564615]
[null,"Cobertura de arboles ",0.2,null,9,"Ecuador","Sacha - Unión Milagreña","Sacha - Unión Milagreña",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B33)+($C$6*'Valores Filtro Var GEO'!H33)+($C$7*'Valores Filtro Var NO GEO'!C33)+($C$8*'Valores Filtro Var GEO'!I33)+($C$9*'Valores Filtro Var GEO'!G33)","v":3.0083094011905591},{"$f":"($C$12*'Valores Filtro Var GEO'!B10)+($C$13*'Valores Filtro Var GEO'!C10)+($C$14*'Valores Filtro Var GEO'!D10)+($C$15*'Valores Filtro Var GEO'!E10)+($C$16*'Valores Filtro Var GEO'!F10)+($C$17*'Valores Filtro Var NO GEO'!I10)+($C$18*'Valores Filtro Var NO GEO'!J10)","v":2.4386191455840107},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F33)+($C$22*'Valores Filtro Var NO GEO'!G33)+($C$23*'Valores Filtro Var NO GEO'!H33)","v":4.7},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D10)+($C$27*'Valores Filtro Var NO GEO'!E10)","v":1},2.8207023759890286]
[null,"Existencia de humedales ",0.1,null,10,"Ecuador","Macuma - Cangaime","Macuma - Taisha",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B32)+($C$6*'Valores Filtro Var GEO'!H32)+($C$7*'Valores Filtro Var NO GEO'!C32)+($C$8*'Valores Filtro Var GEO'!I32)+($C$9*'Valores Filtro Var GEO'!G32)","v":2.8198239121759596},{"$f":"($C$12*'Valores Filtro Var GEO'!B11)+($C$13*'Valores Filtro Var GEO'!C11)+($C$14*'Valores Filtro Var GEO'!D11)+($C$15*'Valores Filtro Var GEO'!E11)+($C$16*'Valores Filtro Var GEO'!F11)+($C$17*'Valores Filtro Var NO GEO'!I11)+($C$18*'Valores Filtro Var NO GEO'!J11)","v":2.8711581120820258},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F31)+($C$22*'Valores Filtro Var NO GEO'!G31)+($C$23*'Valores Filtro Var NO GEO'!H31)","v":3.1999999999999997},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D11)+($C$27*'Valores Filtro Var NO GEO'!E11)","v":1},2.7899507153072953]
[null,"Balance hidrico promedio ",0.1,null,11,"Colombia","Variante San Francisco - Mocoa","Pasto - Mocoa",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B22)+($C$6*'Valores Filtro Var GEO'!H22)+($C$7*'Valores Filtro Var NO GEO'!C22)+($C$8*'Valores Filtro Var GEO'!I22)+($C$9*'Valores Filtro Var GEO'!G22)","v":2.6419691119691122},{"$f":"($C$12*'Valores Filtro Var GEO'!B12)+($C$13*'Valores Filtro Var GEO'!C12)+($C$14*'Valores Filtro Var GEO'!D12)+($C$15*'Valores Filtro Var GEO'!E12)+($C$16*'Valores Filtro Var GEO'!F12)+($C$17*'Valores Filtro Var NO GEO'!I12)+($C$18*'Valores Filtro Var NO GEO'!J12)","v":3.1478705931489888},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F23)+($C$22*'Valores Filtro Var NO GEO'!G23)+($C$23*'Valores Filtro Var NO GEO'!H23)","v":2.1999999999999997},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D12)+($C$27*'Valores Filtro Var NO GEO'!E12)","v":3},2.8433294117046901]
[null,"Grado de intervencion humana ",0.1,null,12,"Colombia","Nuquí - El Afirmado","Nuquí - Las Ánimas",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B19)+($C$6*'Valores Filtro Var GEO'!H19)+($C$7*'Valores Filtro Var NO GEO'!C19)+($C$8*'Valores Filtro Var GEO'!I19)+($C$9*'Valores Filtro Var GEO'!G19)","v":3.5566681711528116},{"$f":"($C$12*'Valores Filtro Var GEO'!B13)+($C$13*'Valores Filtro Var GEO'!C13)+($C$14*'Valores Filtro Var GEO'!D13)+($C$15*'Valores Filtro Var GEO'!E13)+($C$16*'Valores Filtro Var GEO'!F13)+($C$17*'Valores Filtro Var NO GEO'!I13)+($C$18*'Valores Filtro Var NO GEO'!J13)","v":3.4791409771140405},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F5)+($C$22*'Valores Filtro Var NO GEO'!G5)+($C$23*'Valores Filtro Var NO GEO'!H5)","v":1.2999999999999998},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D13)+($C$27*'Valores Filtro Var NO GEO'!E13)","v":1},3.1682807081624427]
[null,"Proximidad a areas de conservacion y tierras indígenas",0.2,null,13,"Colombia","El Dorado - La Uribe","Transversal de la Macarena",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B25)+($C$6*'Valores Filtro Var GEO'!H25)+($C$7*'Valores Filtro Var NO GEO'!C25)+($C$8*'Valores Filtro Var GEO'!I25)+($C$9*'Valores Filtro Var GEO'!G25)","v":2.5908623975269069},{"$f":"($C$12*'Valores Filtro Var GEO'!B14)+($C$13*'Valores Filtro Var GEO'!C14)+($C$14*'Valores Filtro Var GEO'!D14)+($C$15*'Valores Filtro Var GEO'!E14)+($C$16*'Valores Filtro Var GEO'!F14)+($C$17*'Valores Filtro Var NO GEO'!I14)+($C$18*'Valores Filtro Var NO GEO'!J14)","v":3.1402132331605963},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F28)+($C$22*'Valores Filtro Var NO GEO'!G28)+($C$23*'Valores Filtro Var NO GEO'!H28)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D14)+($C$27*'Valores Filtro Var NO GEO'!E14)","v":1},2.6694409139330308]
[null,"Longitud rutas",0.2,null,14,"Colombia","Palo de Letras - Cacarica - Lomas Aisladas","Transversal de las Américas",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B12)+($C$6*'Valores Filtro Var GEO'!H12)+($C$7*'Valores Filtro Var NO GEO'!C12)+($C$8*'Valores Filtro Var GEO'!I12)+($C$9*'Valores Filtro Var GEO'!G12)","v":3.8923144915366596},{"$f":"($C$12*'Valores Filtro Var GEO'!B15)+($C$13*'Valores Filtro Var GEO'!C15)+($C$14*'Valores Filtro Var GEO'!D15)+($C$15*'Valores Filtro Var GEO'!E15)+($C$16*'Valores Filtro Var GEO'!F15)+($C$17*'Valores Filtro Var NO GEO'!I15)+($C$18*'Valores Filtro Var NO GEO'!J15)","v":3.4750500426809521},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F2)+($C$22*'Valores Filtro Var NO GEO'!G2)+($C$23*'Valores Filtro Var NO GEO'!H2)","v":2.4000000000000004},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D15)+($C$27*'Valores Filtro Var NO GEO'!E15)","v":1},3.4106983158210924]
[null,"Típo de inversión",0.1,null,15,"Colombia","Tobiagrande/Villeta - El Korán","Ruta del Sol , Sector 1 ",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B37)+($C$6*'Valores Filtro Var GEO'!H37)+($C$7*'Valores Filtro Var NO GEO'!C37)+($C$8*'Valores Filtro Var GEO'!I37)+($C$9*'Valores Filtro Var GEO'!G37)","v":3.1556191784405541},{"$f":"($C$12*'Valores Filtro Var GEO'!B16)+($C$13*'Valores Filtro Var GEO'!C16)+($C$14*'Valores Filtro Var GEO'!D16)+($C$15*'Valores Filtro Var GEO'!E16)+($C$16*'Valores Filtro Var GEO'!F16)+($C$17*'Valores Filtro Var NO GEO'!I16)+($C$18*'Valores Filtro Var NO GEO'!J16)","v":2.5037771183481459},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F29)+($C$22*'Valores Filtro Var NO GEO'!G29)+($C$23*'Valores Filtro Var NO GEO'!H29)","v":4},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D16)+($C$27*'Valores Filtro Var NO GEO'!E16)","v":3},2.9389473746328871]
[null,null,null,null,16,"Colombia","Puerto Salgar - San Roque","Ruta del Sol, Sector 2",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B36)+($C$6*'Valores Filtro Var GEO'!H36)+($C$7*'Valores Filtro Var NO GEO'!C36)+($C$8*'Valores Filtro Var GEO'!I36)+($C$9*'Valores Filtro Var GEO'!G36)","v":3.1532462499224092},{"$f":"($C$12*'Valores Filtro Var GEO'!B17)+($C$13*'Valores Filtro Var GEO'!C17)+($C$14*'Valores Filtro Var GEO'!D17)+($C$15*'Valores Filtro Var GEO'!E17)+($C$16*'Valores Filtro Var GEO'!F17)+($C$17*'Valores Filtro Var NO GEO'!I17)+($C$18*'Valores Filtro Var NO GEO'!J17)","v":3.1435730802919206},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F18)+($C$22*'Valores Filtro Var NO GEO'!G18)+($C$23*'Valores Filtro Var NO GEO'!H18)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D17)+($C$27*'Valores Filtro Var NO GEO'!E17)","v":1},2.8959063861003278]
[null,"SOCIALES",0.1,null,17,"Colombia","San Roque - Ye de Ciénaga - Carmen de Bolivar - Valledupar","Ruta del Sol, Sector 3",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B34)+($C$6*'Valores Filtro Var GEO'!H34)+($C$7*'Valores Filtro Var NO GEO'!C34)+($C$8*'Valores Filtro Var GEO'!I34)+($C$9*'Valores Filtro Var GEO'!G34)","v":3.1128069235805813},{"$f":"($C$12*'Valores Filtro Var GEO'!B18)+($C$13*'Valores Filtro Var GEO'!C18)+($C$14*'Valores Filtro Var GEO'!D18)+($C$15*'Valores Filtro Var GEO'!E18)+($C$16*'Valores Filtro Var GEO'!F18)+($C$17*'Valores Filtro Var NO GEO'!I18)+($C$18*'Valores Filtro Var NO GEO'!J18)","v":3.2107821362963342},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F17)+($C$22*'Valores Filtro Var NO GEO'!G17)+($C$23*'Valores Filtro Var NO GEO'!H17)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D18)+($C$27*'Valores Filtro Var NO GEO'!E18)","v":1},2.9099747307655828]
[null,"Grado de rechazo de la poblacion local ",0.4,null,18,"Brasil","KM 555 a KM 767","BR-156",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B15)+($C$6*'Valores Filtro Var GEO'!H15)+($C$7*'Valores Filtro Var NO GEO'!C15)+($C$8*'Valores Filtro Var GEO'!I15)+($C$9*'Valores Filtro Var GEO'!G15)","v":3.5371752906179115},{"$f":"($C$12*'Valores Filtro Var GEO'!B19)+($C$13*'Valores Filtro Var GEO'!C19)+($C$14*'Valores Filtro Var GEO'!D19)+($C$15*'Valores Filtro Var GEO'!E19)+($C$16*'Valores Filtro Var GEO'!F19)+($C$17*'Valores Filtro Var NO GEO'!I19)+($C$18*'Valores Filtro Var NO GEO'!J19)","v":3.165879690041701},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F12)+($C$22*'Valores Filtro Var NO GEO'!G12)+($C$23*'Valores Filtro Var NO GEO'!H12)","v":2.7},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D19)+($C$27*'Valores Filtro Var NO GEO'!E19)","v":1},3.1595159767659298]
[null,"Vulneración de normas legales",0.3,null,19,"Brasil","Km 0 a Km 651","BR-163",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B26)+($C$6*'Valores Filtro Var GEO'!H26)+($C$7*'Valores Filtro Var NO GEO'!C26)+($C$8*'Valores Filtro Var GEO'!I26)+($C$9*'Valores Filtro Var GEO'!G26)","v":3.0763603044826615},{"$f":"($C$12*'Valores Filtro Var GEO'!B20)+($C$13*'Valores Filtro Var GEO'!C20)+($C$14*'Valores Filtro Var GEO'!D20)+($C$15*'Valores Filtro Var GEO'!E20)+($C$16*'Valores Filtro Var GEO'!F20)+($C$17*'Valores Filtro Var NO GEO'!I20)+($C$18*'Valores Filtro Var NO GEO'!J20)","v":3.2612154619796265},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F16)+($C$22*'Valores Filtro Var NO GEO'!G16)+($C$23*'Valores Filtro Var NO GEO'!H16)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D20)+($C$27*'Valores Filtro Var NO GEO'!E20)","v":1},2.9180910796838964]
[null,"Existencia de presión externa",0.3,null,20,"Brasil","KM 152 a KM 984","BR-230",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B29)+($C$6*'Valores Filtro Var GEO'!H29)+($C$7*'Valores Filtro Var NO GEO'!C29)+($C$8*'Valores Filtro Var GEO'!I29)+($C$9*'Valores Filtro Var GEO'!G29)","v":3.0291076168882096},{"$f":"($C$12*'Valores Filtro Var GEO'!B21)+($C$13*'Valores Filtro Var GEO'!C21)+($C$14*'Valores Filtro Var GEO'!D21)+($C$15*'Valores Filtro Var GEO'!E21)+($C$16*'Valores Filtro Var GEO'!F21)+($C$17*'Valores Filtro Var NO GEO'!I21)+($C$18*'Valores Filtro Var NO GEO'!J21)","v":3.2004506365828678},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F21)+($C$22*'Valores Filtro Var NO GEO'!G21)+($C$23*'Valores Filtro Var NO GEO'!H21)","v":1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D21)+($C$27*'Valores Filtro Var NO GEO'!E21)","v":1},2.8018458332175746]
[null,null,null,null,21,"Brasil","Km 119 a 165","BR-432",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B14)+($C$6*'Valores Filtro Var GEO'!H14)+($C$7*'Valores Filtro Var NO GEO'!C14)+($C$8*'Valores Filtro Var GEO'!I14)+($C$9*'Valores Filtro Var GEO'!G14)","v":3.1208653316207462},{"$f":"($C$12*'Valores Filtro Var GEO'!B22)+($C$13*'Valores Filtro Var GEO'!C22)+($C$14*'Valores Filtro Var GEO'!D22)+($C$15*'Valores Filtro Var GEO'!E22)+($C$16*'Valores Filtro Var GEO'!F22)+($C$17*'Valores Filtro Var NO GEO'!I22)+($C$18*'Valores Filtro Var NO GEO'!J22)","v":3.0206724553386453},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F25)+($C$22*'Valores Filtro Var NO GEO'!G25)+($C$23*'Valores Filtro Var NO GEO'!H25)","v":1.5999999999999999},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D22)+($C$27*'Valores Filtro Var NO GEO'!E22)","v":1},2.8176487375506891]
[null,"CULTURAL",0.05,null,22,"Brasil","Km 203 a 318","BR-308",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B35)+($C$6*'Valores Filtro Var GEO'!H35)+($C$7*'Valores Filtro Var NO GEO'!C35)+($C$8*'Valores Filtro Var GEO'!I35)+($C$9*'Valores Filtro Var GEO'!G35)","v":2.5868461760647006},{"$f":"($C$12*'Valores Filtro Var GEO'!B23)+($C$13*'Valores Filtro Var GEO'!C23)+($C$14*'Valores Filtro Var GEO'!D23)+($C$15*'Valores Filtro Var GEO'!E23)+($C$16*'Valores Filtro Var GEO'!F23)+($C$17*'Valores Filtro Var NO GEO'!I23)+($C$18*'Valores Filtro Var NO GEO'!J23)","v":2.4748245142560643},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F34)+($C$22*'Valores Filtro Var NO GEO'!G34)+($C$23*'Valores Filtro Var NO GEO'!H34)","v":3.9000000000000004},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D23)+($C$27*'Valores Filtro Var NO GEO'!E23)","v":1},2.5884095018411091]
[null,"Afectación a pueblos en aislamiento voluntario",0.5,null,23,"Brasil","Km 0 a 61,30","BR-422",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B30)+($C$6*'Valores Filtro Var GEO'!H30)+($C$7*'Valores Filtro Var NO GEO'!C30)+($C$8*'Valores Filtro Var GEO'!I30)+($C$9*'Valores Filtro Var GEO'!G30)","v":3.1532657405560736},{"$f":"($C$12*'Valores Filtro Var GEO'!B24)+($C$13*'Valores Filtro Var GEO'!C24)+($C$14*'Valores Filtro Var GEO'!D24)+($C$15*'Valores Filtro Var GEO'!E24)+($C$16*'Valores Filtro Var GEO'!F24)+($C$17*'Valores Filtro Var NO GEO'!I24)+($C$18*'Valores Filtro Var NO GEO'!J24)","v":3.1142262984051814},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F20)+($C$22*'Valores Filtro Var NO GEO'!G20)+($C$23*'Valores Filtro Var NO GEO'!H20)","v":2.6},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D24)+($C$27*'Valores Filtro Var NO GEO'!E24)","v":1},2.9727081305047607]
[null,"Posibilidad de daños arqueológicos ",0.5,null,24,"Brasil","KM 250 a KM 655","BR-319",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B20)+($C$6*'Valores Filtro Var GEO'!H20)+($C$7*'Valores Filtro Var NO GEO'!C20)+($C$8*'Valores Filtro Var GEO'!I20)+($C$9*'Valores Filtro Var GEO'!G20)","v":3.3733936196530796},{"$f":"($C$12*'Valores Filtro Var GEO'!B25)+($C$13*'Valores Filtro Var GEO'!C25)+($C$14*'Valores Filtro Var GEO'!D25)+($C$15*'Valores Filtro Var GEO'!E25)+($C$16*'Valores Filtro Var GEO'!F25)+($C$17*'Valores Filtro Var NO GEO'!I25)+($C$18*'Valores Filtro Var NO GEO'!J25)","v":3.8191957326796113},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F3)+($C$22*'Valores Filtro Var NO GEO'!G3)+($C$23*'Valores Filtro Var NO GEO'!H3)","v":1.7000000000000002},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D25)+($C$27*'Valores Filtro Var NO GEO'!E25)","v":1},3.2879955275670572]
[null,null,null,null,25,"Bolivia","Isinuta - Monte Grande","Villa Tunari - San Ignacio de Moxos",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B7)+($C$6*'Valores Filtro Var GEO'!H7)+($C$7*'Valores Filtro Var NO GEO'!C7)+($C$8*'Valores Filtro Var GEO'!I7)+($C$9*'Valores Filtro Var GEO'!G7)","v":2.6149140122132364},{"$f":"($C$12*'Valores Filtro Var GEO'!B26)+($C$13*'Valores Filtro Var GEO'!C26)+($C$14*'Valores Filtro Var GEO'!D26)+($C$15*'Valores Filtro Var GEO'!E26)+($C$16*'Valores Filtro Var GEO'!F26)+($C$17*'Valores Filtro Var NO GEO'!I26)+($C$18*'Valores Filtro Var NO GEO'!J26)","v":3.7284507924458654},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F13)+($C$22*'Valores Filtro Var NO GEO'!G13)+($C$23*'Valores Filtro Var NO GEO'!H13)","v":3.3000000000000003},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D26)+($C$27*'Valores Filtro Var NO GEO'!E26)","v":1},3.103768461485934]
[null,"Devolver los valores originales",null,null,26,"Bolivia","Porvenir - El Chorro","Porvenir - El Chorro",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B13)+($C$6*'Valores Filtro Var GEO'!H13)+($C$7*'Valores Filtro Var NO GEO'!C13)+($C$8*'Valores Filtro Var GEO'!I13)+($C$9*'Valores Filtro Var GEO'!G13)","v":3.1392269522235496},{"$f":"($C$12*'Valores Filtro Var GEO'!B27)+($C$13*'Valores Filtro Var GEO'!C27)+($C$14*'Valores Filtro Var GEO'!D27)+($C$15*'Valores Filtro Var GEO'!E27)+($C$16*'Valores Filtro Var GEO'!F27)+($C$17*'Valores Filtro Var NO GEO'!I27)+($C$18*'Valores Filtro Var NO GEO'!J27)","v":3.3062347651683646},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F10)+($C$22*'Valores Filtro Var NO GEO'!G10)+($C$23*'Valores Filtro Var NO GEO'!H10)","v":2},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D27)+($C$27*'Valores Filtro Var NO GEO'!E27)","v":3},3.0934964252151844]
[null,null,null,null,27,"Bolivia","Pumasani - Pelechuco","Pumasani - Pelechuco",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B31)+($C$6*'Valores Filtro Var GEO'!H31)+($C$7*'Valores Filtro Var NO GEO'!C31)+($C$8*'Valores Filtro Var GEO'!I31)+($C$9*'Valores Filtro Var GEO'!G31)","v":2.375831674995371},{"$f":"($C$12*'Valores Filtro Var GEO'!B28)+($C$13*'Valores Filtro Var GEO'!C28)+($C$14*'Valores Filtro Var GEO'!D28)+($C$15*'Valores Filtro Var GEO'!E28)+($C$16*'Valores Filtro Var GEO'!F28)+($C$17*'Valores Filtro Var NO GEO'!I28)+($C$18*'Valores Filtro Var NO GEO'!J28)","v":2.3702472783488195},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F37)+($C$22*'Valores Filtro Var NO GEO'!G37)+($C$23*'Valores Filtro Var NO GEO'!H37)","v":2.5999999999999996},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D28)+($C$27*'Valores Filtro Var NO GEO'!E28)","v":1},2.3269439452551168]
[null,null,null,null,28,"Bolivia","Apolo - Ixiamas","Apolo - Ixiamas",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B4)+($C$6*'Valores Filtro Var GEO'!H4)+($C$7*'Valores Filtro Var NO GEO'!C4)+($C$8*'Valores Filtro Var GEO'!I4)+($C$9*'Valores Filtro Var GEO'!G4)","v":2.4472417601995371},{"$f":"($C$12*'Valores Filtro Var GEO'!B29)+($C$13*'Valores Filtro Var GEO'!C29)+($C$14*'Valores Filtro Var GEO'!D29)+($C$15*'Valores Filtro Var GEO'!E29)+($C$16*'Valores Filtro Var GEO'!F29)+($C$17*'Valores Filtro Var NO GEO'!I29)+($C$18*'Valores Filtro Var NO GEO'!J29)","v":3.885169673551923},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F8)+($C$22*'Valores Filtro Var NO GEO'!G8)+($C$23*'Valores Filtro Var NO GEO'!H8)","v":2.1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D29)+($C$27*'Valores Filtro Var NO GEO'!E29)","v":3},3.0872230571781802]
[null,null,null,null,29,"Bolivia","Rio Yata - El Chorro","Rio Yata - El Chorro",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B11)+($C$6*'Valores Filtro Var GEO'!H11)+($C$7*'Valores Filtro Var NO GEO'!C11)+($C$8*'Valores Filtro Var GEO'!I11)+($C$9*'Valores Filtro Var GEO'!G11)","v":2.4284848962440284},{"$f":"($C$12*'Valores Filtro Var GEO'!B30)+($C$13*'Valores Filtro Var GEO'!C30)+($C$14*'Valores Filtro Var GEO'!D30)+($C$15*'Valores Filtro Var GEO'!E30)+($C$16*'Valores Filtro Var GEO'!F30)+($C$17*'Valores Filtro Var NO GEO'!I30)+($C$18*'Valores Filtro Var NO GEO'!J30)","v":3.2080026809910094},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F26)+($C$22*'Valores Filtro Var NO GEO'!G26)+($C$23*'Valores Filtro Var NO GEO'!H26)","v":4.7},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D30)+($C$27*'Valores Filtro Var NO GEO'!E30)","v":3},3.0349951649435658]
[null,null,null,null,30,"Bolivia","Chiata - Lurasani","Chiata - Lurasani",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B10)+($C$6*'Valores Filtro Var GEO'!H10)+($C$7*'Valores Filtro Var NO GEO'!C10)+($C$8*'Valores Filtro Var GEO'!I10)+($C$9*'Valores Filtro Var GEO'!G10)","v":3.8391485674676531},{"$f":"($C$12*'Valores Filtro Var GEO'!B31)+($C$13*'Valores Filtro Var GEO'!C31)+($C$14*'Valores Filtro Var GEO'!D31)+($C$15*'Valores Filtro Var GEO'!E31)+($C$16*'Valores Filtro Var GEO'!F31)+($C$17*'Valores Filtro Var NO GEO'!I31)+($C$18*'Valores Filtro Var NO GEO'!J31)","v":3.0556341379103467},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F7)+($C$22*'Valores Filtro Var NO GEO'!G7)+($C$23*'Valores Filtro Var NO GEO'!H7)","v":1.5999999999999999},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D31)+($C$27*'Valores Filtro Var NO GEO'!E31)","v":1},3.1206947890467172]
[null,null,null,null,31,"Perú","SANTA MARÍA DE NIEVA-SARAMERIZA","Reposo Saramiriza",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B5)+($C$6*'Valores Filtro Var GEO'!H5)+($C$7*'Valores Filtro Var NO GEO'!C5)+($C$8*'Valores Filtro Var GEO'!I5)+($C$9*'Valores Filtro Var GEO'!G5)","v":2.1486414073071716},{"$f":"($C$12*'Valores Filtro Var GEO'!B32)+($C$13*'Valores Filtro Var GEO'!C32)+($C$14*'Valores Filtro Var GEO'!D32)+($C$15*'Valores Filtro Var GEO'!E32)+($C$16*'Valores Filtro Var GEO'!F32)+($C$17*'Valores Filtro Var NO GEO'!I32)+($C$18*'Valores Filtro Var NO GEO'!J32)","v":3.5676944658675196},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F24)+($C$22*'Valores Filtro Var NO GEO'!G24)+($C$23*'Valores Filtro Var NO GEO'!H24)","v":1.5999999999999999},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D32)+($C$27*'Valores Filtro Var NO GEO'!E32)","v":3},2.7749190725632524]
[null,null,null,null,32,"Perú","PUCALLPA-FRONTERA CON BRASIL","Interconección Pukallpa - Cruzeiro do Sul",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B6)+($C$6*'Valores Filtro Var GEO'!H6)+($C$7*'Valores Filtro Var NO GEO'!C6)+($C$8*'Valores Filtro Var GEO'!I6)+($C$9*'Valores Filtro Var GEO'!G6)","v":2.5787083739968226},{"$f":"($C$12*'Valores Filtro Var GEO'!B33)+($C$13*'Valores Filtro Var GEO'!C33)+($C$14*'Valores Filtro Var GEO'!D33)+($C$15*'Valores Filtro Var GEO'!E33)+($C$16*'Valores Filtro Var GEO'!F33)+($C$17*'Valores Filtro Var NO GEO'!I33)+($C$18*'Valores Filtro Var NO GEO'!J33)","v":3.4356056805935768},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F15)+($C$22*'Valores Filtro Var NO GEO'!G15)+($C$23*'Valores Filtro Var NO GEO'!H15)","v":5},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D33)+($C$27*'Valores Filtro Var NO GEO'!E33)","v":3},3.2275059058658386]
[null,null,null,null,33,"Perú","TRAMO 2","IIRSA Sur (Tramo 2)",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B9)+($C$6*'Valores Filtro Var GEO'!H9)+($C$7*'Valores Filtro Var NO GEO'!C9)+($C$8*'Valores Filtro Var GEO'!I9)+($C$9*'Valores Filtro Var GEO'!G9)","v":2.8694488027528662},{"$f":"($C$12*'Valores Filtro Var GEO'!B34)+($C$13*'Valores Filtro Var GEO'!C34)+($C$14*'Valores Filtro Var GEO'!D34)+($C$15*'Valores Filtro Var GEO'!E34)+($C$16*'Valores Filtro Var GEO'!F34)+($C$17*'Valores Filtro Var NO GEO'!I34)+($C$18*'Valores Filtro Var NO GEO'!J34)","v":3.6030692456072706},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F6)+($C$22*'Valores Filtro Var NO GEO'!G6)+($C$23*'Valores Filtro Var NO GEO'!H6)","v":1.2999999999999998},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D34)+($C$27*'Valores Filtro Var NO GEO'!E34)","v":3},3.0491606816244183]
[null,null,null,null,34,"Perú","SANTA TERESA-MACHU PICCHU","Santa María - Santa Teresa - Machu Pichu",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B23)+($C$6*'Valores Filtro Var GEO'!H23)+($C$7*'Valores Filtro Var NO GEO'!C23)+($C$8*'Valores Filtro Var GEO'!I23)+($C$9*'Valores Filtro Var GEO'!G23)","v":2.6423001017807568},{"$f":"($C$12*'Valores Filtro Var GEO'!B35)+($C$13*'Valores Filtro Var GEO'!C35)+($C$14*'Valores Filtro Var GEO'!D35)+($C$15*'Valores Filtro Var GEO'!E35)+($C$16*'Valores Filtro Var GEO'!F35)+($C$17*'Valores Filtro Var NO GEO'!I35)+($C$18*'Valores Filtro Var NO GEO'!J35)","v":2.8671541027826253},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F30)+($C$22*'Valores Filtro Var NO GEO'!G30)+($C$23*'Valores Filtro Var NO GEO'!H30)","v":2.1},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D35)+($C$27*'Valores Filtro Var NO GEO'!E35)","v":3},2.7071393869644838]
[null,null,null,null,35,"Perú","PURUS-IÑAPARI","Purus - Iñapari",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B2)+($C$6*'Valores Filtro Var GEO'!H2)+($C$7*'Valores Filtro Var NO GEO'!C2)+($C$8*'Valores Filtro Var GEO'!I2)+($C$9*'Valores Filtro Var GEO'!G2)","v":2.8471232372718078},{"$f":"($C$12*'Valores Filtro Var GEO'!B36)+($C$13*'Valores Filtro Var GEO'!C36)+($C$14*'Valores Filtro Var GEO'!D36)+($C$15*'Valores Filtro Var GEO'!E36)+($C$16*'Valores Filtro Var GEO'!F36)+($C$17*'Valores Filtro Var NO GEO'!I36)+($C$18*'Valores Filtro Var NO GEO'!J36)","v":3.8541526895441773},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F4)+($C$22*'Valores Filtro Var NO GEO'!G4)+($C$23*'Valores Filtro Var NO GEO'!H4)","v":1.5999999999999999},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D36)+($C$27*'Valores Filtro Var NO GEO'!E36)","v":3},3.1832180052036034]
[null,null,null,null,36,"Perú","IBERIA- ITAHUANIA-LD CUSCO","Iberia - Itahuania - LD Cuzco",{"$f":"($C$5*'Valores Filtro Var NO GEO'!B3)+($C$6*'Valores Filtro Var GEO'!H3)+($C$7*'Valores Filtro Var NO GEO'!C3)+($C$8*'Valores Filtro Var GEO'!I3)+($C$9*'Valores Filtro Var GEO'!G3)","v":2.5218099537899912},{"$f":"($C$12*'Valores Filtro Var GEO'!B37)+($C$13*'Valores Filtro Var GEO'!C37)+($C$14*'Valores Filtro Var GEO'!D37)+($C$15*'Valores Filtro Var GEO'!E37)+($C$16*'Valores Filtro Var GEO'!F37)+($C$17*'Valores Filtro Var NO GEO'!I37)+($C$18*'Valores Filtro Var NO GEO'!J37)","v":4.0119365976143948},{"$f":"($C$21*'Valores Filtro Var NO GEO'!F9)+($C$22*'Valores Filtro Var NO GEO'!G9)+($C$23*'Valores Filtro Var NO GEO'!H9)","v":2},{"$f":"($C$26*'Valores Filtro Var NO GEO'!D37)+($C$27*'Valores Filtro Var NO GEO'!E37)","v":3},3.1640954504424745]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0.1]

{"sheet":"fig2","index":9,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[5,11,6,15],[5,8,6,8],[5,9,6,9],[5,1,6,1],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,2,6,2]]}
[]
[]
[]
[]
[]
[null,"ID Proyecto/ Dimension ","Pais","Carretera","Ambiental","Económica","Calif Amb","Calif Eco","Categoria","Promedio",null,"Legenda"]
[]
[null,1,"Ecuador","Via al Emblase Compensador. Coca Codo Sinclair",3.3497235930817824,3.0920105117599066,{"$f":"IF(E8>3,\"X\",\"Y\")","v":"X"},{"$f":"IF(F8>3,\"X\",\"Y\")","v":"X"},{"$f":"IF(AND(G8=\"X\",H8=\"X\"),\"A\",IF(AND(G8=\"X\",H8=\"Y\"),\"B\",IF(AND(G8=\"Y\",H8=\"X\"),\"C\",\"D\")))","v":"A"},{"$f":"AVERAGE(E8:F8)","v":3.2208670524208447},null,"XX","A=alto costo ambiental + altos costos de oportunidad"]
[null,6,"Ecuador","Lumbaqui - Maderos - Sardina - Puccuna",3.4663549284301918,3.0791864740375745,"X","X","A",3.2727707012338829,null,"XY","B=alto costo ambiental + bajos costos de oportunidad"]
[null,12,"Colombia","Nuquí - Las Ánimas",3.4791409771140405,3.5566681711528116,"X","X","A",3.5179045741334258,null,"YX","C=bajo costo ambiental + altos costos de oportunidad"]
[null,14,"Colombia","Transversal de las Américas",3.4750500426809521,3.8923144915366596,"X","X","A",3.6836822671088059,null,"YY","D=bajo costo ambiental + bajos costos de oportunidad"]
[null,16,"Colombia","Ruta del Sol, Sector 2",3.1435730802919206,3.1532462499224092,"X","X","A",3.1484096651071649]
[null,17,"Colombia","Ruta del Sol, Sector 3",3.2107821362963342,3.1128069235805813,"X","X","A",3.161794529938458]
[null,18,"Brasil","BR-156",3.165879690041701,3.5371752906179115,"X","X","A",3.351527490329806]
[null,19,"Brasil","BR-163",3.2612154619796265,3.0763603044826615,"X","X","A",3.1687878832311442]
[null,20,"Brasil","BR-230",3.2004506365828678,3.0291076168882096,"X","X","A",3.1147791267355389]
[null,21,"Brasil","BR-432",3.0206724553386453,3.1208653316207462,"X","X","A",3.0707688934796957]
[null,23,"Brasil","BR-422",3.1142262984051814,3.1532657405560736,"X","X","A",3.1337460194806273]
[null,24,"Brasil","BR-319",3.8191957326796113,3.3733936196530796,"X","X","A",3.5962946761663455]
[null,26,"Bolivia","Porvenir - El Chorro",3.3062347651683646,3.1392269522235496,"X","X","A",3.2227308586959573]
[null,30,"Bolivia","Chiata - Lurasani",3.0556341379103467,3.8391485674676531,"X","X","A",3.4473913526889999]
[null,11,"Colombia","Pasto - Mocoa",3.1478705931489888,2.6419691119691122,"X","Y","B",2.8949198525590507]
[null,13,"Colombia","Transversal de la Macarena",3.1402132331605963,2.5908623975269069,"X","Y","B",2.8655378153437514]
[null,25,"Bolivia","Villa Tunari - San Ignacio de Moxos",3.7284507924458654,2.6149140122132399,"X",{"$f":"IF(F24>3,\"X\",\"Y\")","v":"Y"},{"$f":"IF(AND(G24=\"X\",H24=\"X\"),\"A\",IF(AND(G24=\"X\",H24=\"Y\"),\"B\",IF(AND(G24=\"Y\",H24=\"X\"),\"C\",\"D\")))","v":"B"},3.1716824023295525]
[null,28,"Bolivia","Apolo - Ixiamas",3.885169673551923,2.4472417601995371,"X","Y","B",3.16620571687573]
[null,29,"Bolivia","Rio Yata - El Chorro",3.2080026809910094,2.4284848962440284,"X","Y","B",2.8182437886175187]
[null,31,"Perú","REPOSO SARAMIRIZA",3.5676944658675196,2.1486414073071716,"X","Y","B",2.8581679365873454]
[null,32,"Perú","INTERCONEXIÓN VIAL PUCALLPA-CRUZEIRO DO SUL",3.4356056805935768,2.5787083739968226,"X","Y","B",3.0071570272951997]
[null,33,"Perú","IIRSA SUR",3.6030692456072706,2.8694488027528662,"X","Y","B",3.2362590241800682]
[null,35,"Perú","PURUS-IÑAPARI",3.8541526895441773,2.8471232372718078,"X","Y","B",3.3506379634079924]
[null,36,"Perú","IBERIA- ITAHUANIA-LD CUSCO",4.0119365976143948,2.5218099537899912,"X","Y",{"$f":"IF(AND(G31=\"X\",H31=\"X\"),\"A\",IF(AND(G31=\"X\",H31=\"Y\"),\"B\",IF(AND(G31=\"Y\",H31=\"X\"),\"C\",\"D\")))","v":"B"},3.266873275702193]
[null,7,"Ecuador","Vía Acceso: Puerto Mirador",2.8271169449212761,3.3614980221837145,"Y","X","C",3.0943074835524955]
[null,8,"Ecuador","Sushufindi - Pto. Providencia",2.7930616149994969,3.5208932157667205,"Y","X","C",3.1569774153831087]
[null,9,"Ecuador","Sacha - Unión Milagreña",2.4386191455840107,3.0083094011905591,"Y","X","C",2.7234642733872851]
[null,15,"Colombia","Ruta del Sol , Sector 1 ",2.5037771183481459,3.1556191784405541,"Y","X","C",2.8296981483943497]
[null,2,"Ecuador","Coca - La Belleza",2.6340948303992726,2.268000009976439,"Y","Y","D",2.451047420187856]
[null,3,"Ecuador","Cuenca  -Macas",2.5790741787171476,2.3545617941100998,"Y","Y","D",2.4668179864136235]
[null,4,"Ecuador","Macuma - Taisha",2.8840487144790261,2.9445193618025822,"Y","Y","D",2.9142840381408042]
[null,5,"Ecuador","Sucumbios - Orellana",2.7773841677902156,2.7541476768298558,"Y","Y","D",2.7657659223100355]
[null,10,"Ecuador","Macuma - Taisha",2.8711581120820258,2.8198239121759596,"Y","Y","D",2.8454910121289929]
[null,22,"Brasil","BR-308",2.4748245142560643,2.5868461760647006,"Y","Y","D",2.5308353451603827]
[null,27,"Bolivia","Pumasani - Pelechuco",2.3702472783488195,2.375831674995371,"Y","Y","D",2.373039476672095]
[null,34,"Perú","SANTA MARÍA-SANTA TERESA-MACHU PICCHU",2.8671541027826253,2.6423001017807568,"Y","Y","D",2.754727102281691]

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