{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["areas","barras","criterios","obras","proyectos","cortocircuito","zonas","zonaBarra","calificacionProyectos","ejecutar","ASIGNACION","RESUMEN","RESUMEN %","EXPANSION","BENEFICIO","INTERCAMBIO","PORCENTAJE BARRAS","PORCENTAJE AREAS","PORCENTAJE ZONAS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"areas","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["nombre","periodo","limiteimportacion","limiteexportacion","demanda","generacion","factorimportacion","factorexportacion"]
["Cauca-Nariño-Putumayo",2023,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2024,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2025,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2026,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2027,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2028,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2029,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2030,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2031,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2032,9999999,999999,200,300,1,1]
["Cauca-Nariño-Putumayo",2033,9999999,999999,200,300,1,1]

{"sheet":"barras","index":1,"n_rows":463,"n_cols":7,"rows_kept":463,"cut":false,"hidden":false,"merged":[[375,6,377,8]]}
["nombre","periodo","capacidad","cortocircuito","factorcapacidad","factorcorto"]
["Catambuco 115",2023,96.704426520019695,24.935369658724799,1,1]
["Cordoba 34.5",2023,19.0625,14.096713247253099,1,1]
["El Zaque 115",2023,70.001064240932465,20.061180395953741,1,1]
["Florida (Cauca) 115",2023,23.4375,20.026205348433582,1,1]
["Guapi 115",2023,108.5240640677512,19.15132485759441,1,1]
["Imues 34.5",2023,17.1875,15.192283709201179,1,1]
["Jamondino 115",2023,65.625,13.440575476686719,1,1]
["Jamondino 220",2023,131.25,10.20033179037296,1,1]
["Jamundi 115",2023,136.6540789604187,22.656960742122219,1,1]
["Jardinera 115",2023,62.5,21.1780646650938,1,1]
["Junin 115",2023,56.144134908390697,30.1640254665468,1,1]
["Mocoa 115",2023,64.154918199083838,22.21385661833768,1,1]
["Mondomo34.5",2023,16.953125,13.78305126480266,1,1]
["Olaya 115",2023,82.435872045073211,19.37829720536698,1,1]
["Paez (Cabaña) 115",2023,72.843456268310547,15.565345756381401,1,1]
["Paez 220",2023,184.375,22.837474481769611,1,1]
["Panamericana 115",2023,63.264222490943212,22.051862603031829,1,1]
["Panamericana 138",2023,999.52774047851563,24.05126416086976,1,1]
["Panamericana 34.5",2023,47.814788818359382,20.476716784677901,1,1]
["Pasto 115",2023,86.640873666224422,23.44284308969878,1,1]
["Pescador 34.5",2023,20.710866451263421,14.67166450047802,1,1]
["Popayan 115",2023,53.021240234375,21.914485636861571,1,1]
["Propal(CEO) 115",2023,0,0,1,1]
["Pto Caicedo 115",2023,51.430941978469491,9.9850363910824633,1,1]
["Renacer 220",2023,168.75,34.954457087429162,1,1]
["Rio Mayo 115",2023,60.921518528175511,20.23765031837209,1,1]
["S Bernardino 115",2023,209.375,8.5827227436057907,1,1]
["S Bernardino 220",2023,700,9.7111661565653602,1,1]
["San Martin 115",2023,76.248806408763869,19.22260860432883,1,1]
["Santander 115",2023,186.8194580078125,14.37381387444055,1,1]
["Santander 34.5",2023,42.1875,7.2013007032110394,1,1]
["Tesalia 220",2023,450,25.56982534924364,1,1]
["Tumaco 115",2023,62.5,24.234541988092982,1,1]
["Yarumo 115",2023,47.043874672453967,26.159786344243411,1,1]
["Catambuco 115",2024,95.193419855644379,24.90190032252444,1,1]
["Cordoba 34.5",2024,19.814453125,14.09290583339064,1,1]
["El Zaque 115",2024,14.21896617393941,20.01840685113671,1,1]
["Florida (Cauca) 115",2024,23.0712890625,19.901036617800891,1,1]
["Guapi 115",2024,111.2584390677512,19.147572257826891,1,1]
["Imues 34.5",2024,17.473334401950471,15.19077928725866,1,1]
["Jamondino 115",2024,71.875,13.386998338946769,1,1]
["Jamondino 220",2024,143.75,10.15135136147047,1,1]
["Jamundi 115",2024,155.7947039604187,22.521398010307831,1,1]
["Jardinera 115",2024,68.75,21.167798229583109,1,1]
["Junin 115",2024,57.316009908390697,30.160898552480251,1,1]
["Mocoa 115",2024,64.154918199083838,22.20479424757821,1,1]
["Mondomo34.5",2024,15.628662109375,13.775828679618879,1,1]
["Olaya 115",2024,73.486328125,19.376580704795039,1,1]
["Paez (Cabaña) 115",2024,72.843456268310547,15.46128183811574,1,1]
["Paez 220",2024,194.53792572021479,22.627690028526839,1,1]
["Panamericana 115",2024,68.75,22.041783909831359,1,1]
["Panamericana 138",2024,39.55078125,24.046774487768399,1,1]
["Panamericana 34.5",2024,47.814788818359382,20.467581682533229,1,1]
["Pasto 115",2024,83.933346364154914,23.410501565922761,1,1]
["Pescador 34.5",2024,20.710866451263421,14.66744673868064,1,1]
["Popayan 115",2024,60.833740234375,21.5641229491379,1,1]
["Propal(CEO) 115",2024,0,0,1,1]
["Pto Caicedo 115",2024,51.430941978469491,9.9811550199186279,1,1]
["Renacer 220",2024,181.25,34.928228352205153,1,1]
["Rio Mayo 115",2024,59.969619801172769,20.204043675575509,1,1]
["S Bernardino 115",2024,218.75,7.5982794598004393,1,1]
["S Bernardino 220",2024,700,9.4906248799033399,1,1]
["San Martin 115",2024,66.717705607668393,19.17994792589873,1,1]
["Santander 115",2024,193.0694580078125,14.12981231019687,1,1]
["Santander 34.5",2024,41.09375,7.1365751306612513,1,1]
["Tesalia 220",2024,500,25.468824782394009,1,1]
["Tumaco 115",2024,64.682488614466607,24.23293558190375,1,1]
["Yarumo 115",2024,47.043874672453967,26.156660339976629,1,1]
["Catambuco 115",2025,96.685234576073356,24.856014926564619,1,1]
["Cordoba 34.5",2025,19.84375,14.080391976379859,1,1]
["El Zaque 115",2025,14.21896617393941,19.987227490799881,1,1]
["Florida (Cauca) 115",2025,23.556461744010448,19.860089323216432,1,1]
["Guapi 115",2025,110.82383579014279,19.140653355733679,1,1]
["Imues 34.5",2025,17.597341830485689,15.18549551225677,1,1]
["Jamondino 115",2025,84.375,13.304833628967961,1,1]
["Jamondino 220",2025,168.75,10.07116540417835,1,1]
["Jamundi 115",2025,147.2746810875833,22.373892040845099,1,1]
["Jardinera 115",2025,81.25,21.142145540050048,1,1]
["Junin 115",2025,56.868228580981388,30.152006905926999,1,1]
["Mocoa 115",2025,64.545543199083852,22.180738302451921,1,1]
["Mondomo34.5",2025,15.140266418457029,13.758147346459561,1,1]
["Olaya 115",2025,73.486328125,19.371560643998851,1,1]
["Paez (Cabaña) 115",2025,72.843456268310547,15.349164374123729,1,1]
["Paez 220",2025,203.91292572021479,22.394461788754739,1,1]
["Panamericana 115",2025,81.25,22.015113129533731,1,1]
["Panamericana 138",2025,999.52774047851563,24.0338236832314,1,1]
["Panamericana 34.5",2025,47.780619263648987,20.430400261574281,1,1]
["Pasto 115",2025,83.277617095684946,23.35543072386486,1,1]
["Pescador 34.5",2025,20.710866451263421,14.656858701998511,1,1]
["Popayan 115",2025,63.177490234375,21.491056201732579,1,1]
["Propal(CEO) 115",2025,0,0,1,1]
["Pto Caicedo 115",2025,51.430941978469491,9.9707040460974845,1,1]
["Renacer 220",2025,218.75,34.876623660747661,1,1]
["Rio Mayo 115",2025,60.750869801172769,20.172997790895671,1,1]
["S Bernardino 115",2025,221.875,7.4723506812151097,1,1]
["S Bernardino 220",2025,812.5,9.2858469528949499,1,1]
["San Martin 115",2025,63.590313157308927,19.14097330744719,1,1]
["Santander 115",2025,205.5694580078125,13.970570194491851,1,1]
["Santander 34.5",2025,41.09375,7.0480561026962487,1,1]
["Tesalia 220",2025,575,25.263571214422981,1,1]
["Tumaco 115",2025,65.854363614466592,24.22788542987033,1,1]
["Yarumo 115",2025,48.609747378237323,26.14815765853535,1,1]
["Catambuco 115",2026,96.685234576073356,24.814445100738649,1,1]
["Cordoba 34.5",2026,20.0634765625,14.06791858018854,1,1]
["El Zaque 115",2026,14.21896617393941,19.96497483861879,1,1]
["Florida (Cauca) 115",2026,23.107147216796879,19.83651888789019,1,1]
["Guapi 115",2026,110.39093018158751,19.13641603485851,1,1]
["Imues 34.5",2026,17.322383364384351,15.180209162776491,1,1]
["Jamondino 115",2026,79.1015625,13.227400671906199,1,1]
["Jamondino 220",2026,158.203125,9.9937966276777601,1,1]
["Jamundi 115",2026,156.6496810875833,22.350891925460029,1,1]
["Jardinera 115",2026,76.171875,21.116957251048781,1,1]
["Junin 115",2026,57.258853580981388,30.14322268358665,1,1]
["Mocoa 115",2026,64.545543199083852,22.15254376774223,1,1]
["Mondomo34.5",2026,14.667133092880251,13.75284435262023,1,1]
["Olaya 115",2026,82.892055162084645,19.36846555835535,1,1]
["Paez (Cabaña) 115",2026,72.843456268310547,15.304289985948239,1,1]
["Paez 220",2026,203.91292572021479,22.24458040788976,1,1]
["Panamericana 115",2026,76.171875,21.98909099844073,1,1]
["Panamericana 138",2026,999.52774047851563,24.021019206130578,1,1]
["Panamericana 34.5",2026,47.780619263648987,20.394171997348369,1,1]
["Pasto 115",2026,83.277617095684946,23.30354413555493,1,1]
["Pescador 34.5",2026,20.710866451263421,14.653684531479181,1,1]
["Popayan 115",2026,63.177490234375,21.449571568419358,1,1]
["Propal(CEO) 115",2026,0,0,1,1]
["Pto Caicedo 115",2026,51.821566978469491,9.9584570143664468,1,1]
["Renacer 220",2026,205.078125,34.818952637940747,1,1]
["Rio Mayo 115",2026,59.801637460529449,20.148317619020482,1,1]
["S Bernardino 115",2026,221.875,7.4078336281113906,1,1]
["S Bernardino 220",2026,812.5,9.1781742725607494,1,1]
["San Martin 115",2026,63.590313157308927,19.109109787358801,1,1]
["Santander 115",2026,208.6944580078125,13.93427016516306,1,1]
["Santander 34.5",2026,39.609375,7.0232930158554581,1,1]
["Tesalia 220",2026,553.125,25.030425462523279,1,1]
["Tumaco 115",2026,65.082632790859549,24.222864222520592,1,1]
["Yarumo 115",2026,47.072579765932687,26.13818119544889,1,1]
["Catambuco 115",2027,96.000014231772155,24.81535093787155,1,1]
["Cordoba 34.5",2027,19.71923828125,14.06818312500774,1,1]
["El Zaque 115",2027,14.21896617393941,19.965751141517881,1,1]
["Florida (Cauca) 115",2027,22.74609804153442,19.837546779996732,1,1]
["Guapi 115",2027,109.95971561056569,19.136614719396491,1,1]
["Imues 34.5",2027,17.634883364384351,15.180321447766341,1,1]
["Jamondino 115",2027,74.15771484375,13.234134367117649,1,1]
["Jamondino 220",2027,148.3154296875,10.02989972105965,1,1]
["Jamundi 115",2027,144.41142475261589,22.354193460357799,1,1]
["Jardinera 115",2027,71.4111328125,21.11752413609813,1,1]
["Junin 115",2027,57.258853580981402,30.143408299261729,1,1]
["Mocoa 115",2027,64.545543199083852,22.153043372454711,1,1]
["Mondomo34.5",2027,19.354633092880249,13.75346679242368,1,1]
["Olaya 115",2027,82.391929626464844,19.368610912712171,1,1]
["Paez (Cabaña) 115",2027,73.624706268310547,15.307259321952071,1,1]
["Paez 220",2027,197.5406467914581,22.24794377983925,1,1]
["Panamericana 115",2027,73.79150390625,21.989655436019881,1,1]
["Panamericana 138",2027,999.52774047851563,24.021292328134301,1,1]
["Panamericana 34.5",2027,47.780619263648987,20.394940936048599,1,1]
["Pasto 115",2027,85.621367095684946,23.306510119910101,1,1]
["Pescador 34.5",2027,20.710866451263421,14.654057114143971,1,1]
["Popayan 115",2027,62.190341949462891,21.451394405509419,1,1]
["Propal(CEO) 115",2027,0,0,1,1]
["Pto Caicedo 115",2027,51.416710986450198,9.9586312680449431,1,1]
["Renacer 220",2027,192.2607421875,34.819724867400431,1,1]
["Rio Mayo 115",2027,59.801637460529449,20.149015233704709,1,1]
["S Bernardino 115",2027,219.140625,7.4107672152716102,1,1]
["S Bernardino 220",2027,818.359375,9.1809780723299994,1,1]
["San Martin 115",2027,66.715313157308913,19.10994588955683,1,1]
["Santander 115",2027,201.22222900390619,13.937677403930939,1,1]
["Santander 34.5",2027,38.077392578125,7.0260357091799381,1,1]
["Tesalia 220",2027,514.84375,25.033031662863809,1,1]
["Tumaco 115",2027,65.082632790859549,24.222970602554891,1,1]
["Yarumo 115",2027,48.609747378237323,26.13832336180737,1,1]
["Catambuco 115",2028,96.000014231772155,24.8156060921578,1,1]
["Cordoba 34.5",2028,19.71923828125,14.068257301684721,1,1]
["El Zaque 115",2028,81.406466173939407,19.965967967704859,1,1]
["Florida (Cauca) 115",2028,22.74609804153442,19.83783533609078,1,1]
["Guapi 115",2028,109.53018547146191,19.13667022065821,1,1]
["Imues 34.5",2028,17.35933831181584,15.18035292356466,1,1]
["Jamondino 115",2028,69.522857666015625,13.234580445093769,1,1]
["Jamondino 220",2028,139.04571533203119,10.03029688259436,1,1]
["Jamundi 115",2028,156.91142475261589,22.355141467954201,1,1]
["Jardinera 115",2028,66.94793701171875,21.117660557168691,1,1]
["Junin 115",2028,57.258853580981402,30.14346037922742,1,1]
["Mocoa 115",2028,64.936168199083852,22.153156457399579,1,1]
["Mondomo34.5",2028,19.354633092880249,13.753640496671339,1,1]
["Olaya 115",2028,82.24572581351552,19.36865150394976,1,1]
["Paez (Cabaña) 115",2028,73.624706268310547,15.30809275154123,1,1]
["Paez 220",2028,206.9156467914581,22.248913788857571,1,1]
["Panamericana 115",2028,69.179534912109375,21.989640818546128,1,1]
["Panamericana 138",2028,999.52774047851563,24.021346477922901,1,1]
["Panamericana 34.5",2028,47.780619263648987,20.394411023717179,1,1]
["Pasto 115",2028,84.9524501652499,23.306823082744369,1,1]
["Pescador 34.5",2028,20.710866451263421,14.65416129933989,1,1]
["Popayan 115",2028,63.752841949462891,21.451898606546319,1,1]
["Propal(CEO) 115",2028,0,0,1,1]
["Pto Caicedo 115",2028,51.807335986450198,9.9586805624469612,1,1]
["Renacer 220",2028,180.24444580078119,34.819945043223811,1,1]
["Rio Mayo 115",2028,59.801637460529449,20.149211162558132,1,1]
["S Bernardino 115",2028,222.265625,7.4115733735814509,1,1]
["S Bernardino 220",2028,809.1796875,9.1817855131036801,1,1]
["San Martin 115",2028,64.630459621143018,19.110181032574999,1,1]
["Santander 115",2028,210.59722900390619,13.938652112027251,1,1]
["Santander 34.5",2028,34.970340728759773,7.026806314656314,1,1]
["Tesalia 220",2028,486.1328125,25.033760788633089,1,1]
["Tumaco 115",2028,65.082632790859549,24.223000436806799,1,1]
["Yarumo 115",2028,47.083136927170742,26.138363571232311,1,1]
["Catambuco 115",2029,80.735331604955732,24.814874877921749,1,1]
["Cordoba 34.5",2029,19.765625,14.06804023074791,1,1]
["El Zaque 115",2029,14.627724390629741,19.965388742269301,1,1]
["Florida (Cauca) 115",2029,22.74609804153442,19.837090650474131,1,1]
["Guapi 115",2029,109.53018547146191,19.136526719449769,1,1]
["Imues 34.5",2029,17.67183831181584,15.180260764367381,1,1]
["Jamondino 115",2029,69.522857666015625,13.23327655322837,1,1]
["Jamondino 220",2029,139.04571533203119,10.0291214869847,1,1]
["Jamundi 115",2029,149.55620171733699,22.352944298807611,1,1]
["Jardinera 115",2029,66.94793701171875,21.117238101429841,1,1]
["Junin 115",2029,57.258853580981402,30.143308175578621,1,1]
["Mocoa 115",2029,66.948612939587903,22.152793062004239,1,1]
["Mondomo34.5",2029,19.354633092880249,13.753219709762311,1,1]
["Olaya 115",2029,81.924453447056479,19.36854650464867,1,1]
["Paez (Cabaña) 115",2029,73.624706268310547,15.30610976903079,1,1]
["Paez 220",2029,206.9156467914581,22.246704279642731,1,1]
["Panamericana 115",2029,64.855813980102539,21.989360009042461,1,1]
["Panamericana 138",2029,999.52774047851563,24.021146278964739,1,1]
["Panamericana 34.5",2029,48.093119263648987,20.394526867581661,1,1]
["Pasto 115",2029,81.591515742911724,23.305915324730389,1,1]
["Pescador 34.5",2029,20.710866451263421,14.65390899742202,1,1]
["Popayan 115",2029,63.752841949462891,21.450598322712992,1,1]
["Propal(CEO) 115",2029,0,0,1,1]
["Pto Caicedo 115",2029,53.090004622936249,9.9585221400113753,1,1]
["Renacer 220",2029,180.24444580078119,34.819251115979263,1,1]
["Rio Mayo 115",2029,60.192262460529449,20.148673102823341,1,1]
["S Bernardino 115",2029,222.265625,7.4095181599948798,1,1]
["S Bernardino 220",2029,804.58984375,9.1797070174395206,1,1]
["San Martin 115",2029,64.630459621143018,19.109528902210261,1,1]
["Santander 115",2029,210.59722900390619,13.936353720675511,1,1]
["Santander 34.5",2029,78.751572293767822,7.0249511240262752,1,1]
["Tesalia 220",2029,486.1328125,25.03143119500896,1,1]
["Tumaco 115",2029,66.254507790859549,24.222913164904071,1,1]
["Yarumo 115",2029,47.083136927170742,26.138234283673,1,1]
["Catambuco 115",2030,80.735331604955732,24.81535093787155,1,1]
["Cordoba 34.5",2030,20.078125,14.06818312500774,1,1]
["El Zaque 115",2030,14.627724390629741,19.965751141517881,1,1]
["Florida (Cauca) 115",2030,23.13672304153442,19.837546779996732,1,1]
["Guapi 115",2030,109.102333184464,19.136614719396491,1,1]
["Imues 34.5",2030,17.39571583819372,15.180321447766341,1,1]
["Jamondino 115",2030,69.522857666015625,13.234134367117649,1,1]
["Jamondino 220",2030,139.04571533203119,10.02989972105968,1,1]
["Jamundi 115",2030,107.21282958984381,22.354193460357799,1,1]
["Jardinera 115",2030,66.94793701171875,21.11752413609813,1,1]
["Junin 115",2030,57.258853580981402,30.143408299261729,1,1]
["Mocoa 115",2030,65.446861149133952,22.153043372454711,1,1]
["Mondomo34.5",2030,19.354633092880249,13.75346679242368,1,1]
["Olaya 115",2030,82.315078447056464,19.368610912712171,1,1]
["Paez (Cabaña) 115",2030,73.624706268310547,15.30725932195206,1,1]
["Paez 220",2030,176.45263671875,22.24794377983925,1,1]
["Panamericana 115",2030,64.855813980102539,21.989655436019881,1,1]
["Panamericana 138",2030,999.52774047851563,24.021292328134301,1,1]
["Panamericana 34.5",2030,48.093119263648987,20.394940936048599,1,1]
["Pasto 115",2030,81.591515742911724,23.30651011991009,1,1]
["Pescador 34.5",2030,20.710866451263421,14.654057114143971,1,1]
["Popayan 115",2030,65.315341949462891,21.451394405509419,1,1]
["Propal(CEO) 115",2030,0,0,1,1]
["Pto Caicedo 115",2030,52.159383651465419,9.9586312680449431,1,1]
["Renacer 220",2030,180.24444580078119,34.819724867400431,1,1]
["Rio Mayo 115",2030,60.192262460529449,20.149015233704709,1,1]
["S Bernardino 115",2030,225.390625,7.4107672152715907,1,1]
["S Bernardino 220",2030,804.58984375,9.1809780723299994,1,1]
["San Martin 115",2030,64.630459621143018,19.10994588955683,1,1]
["Santander 115",2030,61.138916015625,13.937677403930939,1,1]
["Santander 34.5",2030,34.473345279693604,7.0260357091799381,1,1]
["Tesalia 220",2030,486.1328125,25.033031662863831,1,1]
["Tumaco 115",2030,65.219281106627363,24.222970602554891,1,1]
["Yarumo 115",2030,47.083136927170742,26.13832336180737,1,1]
["Catambuco 115",2031,96.000014231772155,24.81535093787155,1,1]
["Cordoba 34.5",2031,19.859619140625,14.06818312500774,1,1]
["El Zaque 115",2031,81.815224390629737,19.965752469259741,1,1]
["Florida (Cauca) 115",2031,23.13672304153442,19.837546779996732,1,1]
["Guapi 115",2031,108.67615219546219,19.136614719396491,1,1]
["Imues 34.5",2031,17.39571583819372,15.180321447766341,1,1]
["Jamondino 115",2031,65.177679061889648,13.23934546754543,1,1]
["Jamondino 220",2031,130.3553581237793,10.06492796204321,1,1]
["Jamundi 115",2031,149.9920438243368,22.354193460357799,1,1]
["Jardinera 115",2031,66.94793701171875,21.117560267067741,1,1]
["Junin 115",2031,57.649478580981388,30.143408299261729,1,1]
["Mocoa 115",2031,65.446861149133952,22.153144157426951,1,1]
["Mondomo34.5",2031,19.354633092880249,13.753466799162069,1,1]
["Olaya 115",2031,82.705703447056464,19.368610912712171,1,1]
["Paez (Cabaña) 115",2031,73.624706268310547,15.30726329303711,1,1]
["Paez 220",2031,206.7587616853416,22.24794377983925,1,1]
["Panamericana 115",2031,64.855813980102539,21.98967129465278,1,1]
["Panamericana 138",2031,999.52774047851563,24.02129444709707,1,1]
["Panamericana 34.5",2031,48.093119263648987,20.394941831305079,1,1]
["Pasto 115",2031,87.2962001652499,23.308385969019909,1,1]
["Pescador 34.5",2031,20.710866451263421,14.654057114143971,1,1]
["Popayan 115",2031,64.805065840482712,21.451421632227511,1,1]
["Propal(CEO) 115",2031,0,0,1,1]
["Pto Caicedo 115",2031,52.159383651465419,9.9586312680449431,1,1]
["Renacer 220",2031,168.97916793823239,34.819724867400431,1,1]
["Rio Mayo 115",2031,60.192262460529449,20.149015233704709,1,1]
["S Bernardino 115",2031,225.390625,7.4108439791634897,1,1]
["S Bernardino 220",2031,804.58984375,9.1809780723299994,1,1]
["San Martin 115",2031,65.411709621143018,19.10994588955683,1,1]
["Santander 115",2031,210.29167175292969,13.937677403930939,1,1]
["Santander 34.5",2031,52.285845279693604,7.0260357091799381,1,1]
["Tesalia 220",2031,443.06640625,25.033113427125809,1,1]
["Tumaco 115",2031,64.544007182121277,24.222970602554891,1,1]
["Yarumo 115",2031,48.773292504937537,26.13832336180737,1,1]
["Catambuco 115",2032,96.000014231772155,24.81535093787155,1,1]
["Cordoba 34.5",2032,19.859619140625,14.06818312500774,1,1]
["El Zaque 115",2032,15.340354573243079,19.965752469259741,1,1]
["Florida (Cauca) 115",2032,22.775211744010448,19.837546779996732,1,1]
["Guapi 115",2032,108.2516359759487,19.136614719396491,1,1]
["Imues 34.5",2032,17.39571583819372,15.180321447766341,1,1]
["Jamondino 115",2032,65.177679061889648,13.23934546754543,1,1]
["Jamondino 220",2032,114.0609383583069,10.06492796204321,1,1]
["Jamundi 115",2032,149.9920438243368,22.354193460357799,1,1]
["Jardinera 115",2032,62.763690948486328,21.117560267067741,1,1]
["Junin 115",2032,57.649478580981402,30.143408299261729,1,1]
["Mocoa 115",2032,65.446861149133952,22.153144157426951,1,1]
["Mondomo34.5",2032,19.354633092880249,13.753466799162069,1,1]
["Olaya 115",2032,81.736495984786274,19.368610912712171,1,1]
["Paez (Cabaña) 115",2032,73.624706268310547,15.30726329303711,1,1]
["Paez 220",2032,205.14345885967489,22.24794377983925,1,1]
["Panamericana 115",2032,64.855813980102539,21.98967129465278,1,1]
["Panamericana 138",2032,999.52774047851563,24.02129444709707,1,1]
["Panamericana 34.5",2032,48.093119263648987,20.394941831305079,1,1]
["Pasto 115",2032,87.2962001652499,23.308385969019909,1,1]
["Pescador 34.5",2032,21.023366451263421,14.654057114143971,1,1]
["Popayan 115",2032,64.805065840482712,21.451421632227511,1,1]
["Propal(CEO) 115",2032,0,0,1,1]
["Pto Caicedo 115",2032,52.159383651465419,9.9586312680449431,1,1]
["Renacer 220",2032,147.8567719459534,34.819724867400431,1,1]
["Rio Mayo 115",2032,60.192262460529449,20.149015233704709,1,1]
["S Bernardino 115",2032,223.8037109375,7.4108439791634897,1,1]
["S Bernardino 220",2032,802.294921875,9.1809780723299994,1,1]
["San Martin 115",2032,66.192959621143018,19.10994588955683,1,1]
["Santander 115",2032,210.29167175292969,13.937677403930939,1,1]
["Santander 34.5",2032,51.517979949712753,7.0260357091799381,1,1]
["Tesalia 220",2032,443.06640625,25.033113427125809,1,1]
["Tumaco 115",2032,64.544007182121277,24.222970602554891,1,1]
["Yarumo 115",2032,47.070128369222573,26.13832336180737,1,1]
["Catambuco 115",2033,96.000014231772155,24.8156060921578,1,1]
["Cordoba 34.5",2033,19.859619140625,14.068257301684721,1,1]
["El Zaque 115",2033,15.340354573243079,19.965967968827499,1,1]
["Florida (Cauca) 115",2033,22.775211744010448,19.83783533609078,1,1]
["Guapi 115",2033,107.8287780229176,19.13667022065821,1,1]
["Imues 34.5",2033,17.39571583819372,15.18035292356466,1,1]
["Jamondino 115",2033,65.177679061889648,13.234594497107871,1,1]
["Jamondino 220",2033,114.0609383583069,10.03030396133342,1,1]
["Jamundi 115",2033,149.9920438243368,22.355141467954201,1,1]
["Jardinera 115",2033,65.888690948486328,21.117698052913319,1,1]
["Junin 115",2033,57.649478580981402,30.14346037922742,1,1]
["Mocoa 115",2033,65.446861149133952,22.15315647710008,1,1]
["Mondomo34.5",2033,19.354633092880249,13.753640496672171,1,1]
["Olaya 115",2033,81.417212797345698,19.36865150394976,1,1]
["Paez (Cabaña) 115",2033,73.624706268310547,15.308092752166219,1,1]
["Paez 220",2033,205.14345885967489,22.248913788857571,1,1]
["Panamericana 115",2033,64.855813980102539,21.990148040124168,1,1]
["Panamericana 138",2033,999.52774047851563,24.021411947421509,1,1]
["Panamericana 34.5",2033,48.093119263648987,20.396654378682541,1,1]
["Pasto 115",2033,88.0774501652499,23.306827577416691,1,1]
["Pescador 34.5",2033,20.767524838447571,14.65416129933989,1,1]
["Popayan 115",2033,64.805065840482712,21.451898615468021,1,1]
["Propal(CEO) 115",2033,0,0,1,1]
["Pto Caicedo 115",2033,52.159383651465419,9.9586805624469612,1,1]
["Renacer 220",2033,147.8567719459534,34.819945043223811,1,1]
["Rio Mayo 115",2033,60.192262460529449,20.149211162558132,1,1]
["S Bernardino 115",2033,223.8037109375,7.4115733903636301,1,1]
["S Bernardino 220",2033,802.294921875,9.1817855131036801,1,1]
["San Martin 115",2033,66.192959621143018,19.110181032574999,1,1]
["Santander 115",2033,210.29167175292969,13.938652112027251,1,1]
["Santander 34.5",2033,44.821489974856377,7.026806314656314,1,1]
["Tesalia 220",2033,371.533203125,25.033760801268379,1,1]
["Tumaco 115",2033,64.544007182121277,24.223000436806799,1,1]
["Yarumo 115",2033,47.070128369222573,26.138363571232311,1,1]
["Cabaña34.5",2023,0,3.0875082830064802,1,1,"Para estas subestaciones no se calculó capacidad por barra"]
["CasaFria 34.5",2023,0,14.45894986910605,1,1]
["Corinto 34.5",2023,0,11.829886320716851,1,1]
["Japio 34.5",2023,0,13.99986352842045,1,1]
["PTejada 34.5",2023,0,12.09520881000655,1,1]
["Pupiales 34.5",2023,0,13.479772639811751,1,1]
["Sapuyes 34.5",2023,0,15.023817744147751,1,1]
["Tangua 34.5",2023,0,15.3564191390603,1,1]
["Cabaña34.5",2024,0,3.0003632471374502,1,1]
["CasaFria 34.5",2024,0,14.455940179398601,1,1]
["Corinto 34.5",2024,0,11.810230434575541,1,1]
["Japio 34.5",2024,0,13.991902145882181,1,1]
["PTejada 34.5",2024,0,12.076344061505861,1,1]
["Pupiales 34.5",2024,0,13.474519664295769,1,1]
["Sapuyes 34.5",2024,0,15.021979988948621,1,1]
["Tangua 34.5",2024,0,15.35523268466561,1,1]
["Cabaña34.5",2025,0,2.875817391615771,1,1]
["CasaFria 34.5",2025,0,14.445825478681179,1,1]
["Corinto 34.5",2025,0,11.77438147814234,1,1]
["Japio 34.5",2025,0,13.97435834075171,1,1]
["PTejada 34.5",2025,0,12.04144179203883,1,1]
["Pupiales 34.5",2025,0,13.457899361384101,1,1]
["Sapuyes 34.5",2025,0,15.01558941254271,1,1]
["Tangua 34.5",2025,0,15.351025616139751,1,1]
["Cabaña34.5",2026,0,2.8311535581830811,1,1]
["CasaFria 34.5",2026,0,14.43573068728856,1,1]
["Corinto 34.5",2026,0,11.76336159164962,1,1]
["Japio 34.5",2026,0,13.969116247213501,1,1]
["PTejada 34.5",2026,0,12.03085598490815,1,1]
["Pupiales 34.5",2026,0,13.44136939667003,1,1]
["Sapuyes 34.5",2026,0,15.00919923142277,1,1]
["Tangua 34.5",2026,0,15.34681428912968,1,1]
["Cabaña34.5",2027,0,2.8351907062233508,1,1]
["CasaFria 34.5",2027,0,14.43594489534415,1,1]
["Corinto 34.5",2027,0,11.764622021356271,1,1]
["Japio 34.5",2027,0,13.9697341396438,1,1]
["PTejada 34.5",2027,0,12.032075318320381,1,1]
["Pupiales 34.5",2027,0,13.441719656857661,1,1]
["Sapuyes 34.5",2027,0,15.009334932814509,1,1]
["Tangua 34.5",2027,0,15.3469037585955,1,1]
["Cabaña34.5",2028,0,2.8363154851558399,1,1]
["CasaFria 34.5",2028,0,14.436004952461911,1,1]
["Corinto 34.5",2028,0,11.7649731725047,1,1]
["Japio 34.5",2028,0,13.96990673077628,1,1]
["PTejada 34.5",2028,0,12.032415326031771,1,1]
["Pupiales 34.5",2028,0,13.44181788362572,1,1]
["Sapuyes 34.5",2028,0,15.009372974124981,1,1]
["Tangua 34.5",2028,0,15.34692883785357,1,1]
["Cabaña34.5",2029,0,2.8336153953995411,1,1]
["CasaFria 34.5",2029,0,14.435829168935321,1,1]
["Corinto 34.5",2029,0,11.76412747613503,1,1]
["Japio 34.5",2029,0,13.96948946545573,1,1]
["PTejada 34.5",2029,0,12.03159590337429,1,1]
["Pupiales 34.5",2029,0,13.44153052696983,1,1]
["Sapuyes 34.5",2029,0,15.00926159983374,1,1]
["Tangua 34.5",2029,0,15.346855402155031,1,1]
["Cabaña34.5",2030,0,2.835190706223321,1,1]
["CasaFria 34.5",2030,0,14.43594489534415,1,1]
["Corinto 34.5",2030,0,11.764622021356271,1,1]
["Japio 34.5",2030,0,13.9697341396438,1,1]
["PTejada 34.5",2030,0,12.032075318320381,1,1]
["Pupiales 34.5",2030,0,13.441719656857661,1,1]
["Sapuyes 34.5",2030,0,15.009334932814509,1,1]
["Tangua 34.5",2030,0,15.3469037585955,1,1]
["Cabaña34.5",2031,0,2.83519374368406,1,1]
["CasaFria 34.5",2031,0,14.43594489534415,1,1]
["Corinto 34.5",2031,0,11.764622021356271,1,1]
["Japio 34.5",2031,0,13.9697341396438,1,1]
["PTejada 34.5",2031,0,12.032075318320381,1,1]
["Pupiales 34.5",2031,0,13.441719656857661,1,1]
["Sapuyes 34.5",2031,0,15.009334932814509,1,1]
["Tangua 34.5",2031,0,15.3469037585955,1,1]
["Cabaña34.5",2032,0,2.83519374368406,1,1]
["CasaFria 34.5",2032,0,14.43594489534415,1,1]
["Corinto 34.5",2032,0,11.764622021356271,1,1]
["Japio 34.5",2032,0,13.9697341396438,1,1]
["PTejada 34.5",2032,0,12.032075318320381,1,1]
["Pupiales 34.5",2032,0,13.441719656857661,1,1]
["Sapuyes 34.5",2032,0,15.009334932814509,1,1]
["Tangua 34.5",2032,0,15.3469037585955,1,1]
["Cabaña34.5",2033,0,2.836315485654771,1,1]
["CasaFria 34.5",2033,0,14.436004952461911,1,1]
["Corinto 34.5",2033,0,11.7649731725047,1,1]
["Japio 34.5",2033,0,13.96990673077628,1,1]
["PTejada 34.5",2033,0,12.032415326031771,1,1]
["Pupiales 34.5",2033,0,13.44181788362572,1,1]
["Sapuyes 34.5",2033,0,15.009372974124981,1,1]
["Tangua 34.5",2033,0,15.3469288378536,1,1]

{"sheet":"criterios","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["nombre","ponderacion"]
["BT_Confi",1]
["BT_Flex",1]
["EC_RE",1]
["EC_RP",0.5]
["EC_Per",1]
["EC_Mar",1]
["B_Ambiental",0.3]

{"sheet":"obras","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["nombre","barra","zona","area","capacidadbarra","cortocircuito","capacidadzona","capacidadarea","costo","periodoini","excluyente","dependiente","obligatorio"]

{"sheet":"proyectos","index":4,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["nombre","capacidad","tipo","barra","area","obra","excluyente","fpo","periodoIni","fpomax","fila","obligatorio","activo","ordenLlegada"]
["SC_1797_A1",9.4,"Solar FV","Cordoba 34.5","Cauca-Nariño-Putumayo",null,null,"2024-06-30",2024,"2024-06-30",2,0,1,3]
["SC_1790_A1",6.2,"Solar FV","Cordoba 34.5","Cauca-Nariño-Putumayo",null,null,"2024-12-31",2024,"2024-12-31",2,0,1,5]
["SC_830_A1",7.5,"Hidraulica","Mondomo34.5","Cauca-Nariño-Putumayo",null,null,"2026-12-31",2026,"2026-12-31",2,0,1,1]
["SC_1797_A2",9.4,"Solar FV","Imues 34.5","Cauca-Nariño-Putumayo",null,"SC_1797_A1","2024-06-30",2024,"2024-06-30",2,0,1,4]
["SC_1790_A2",6.2,"Solar FV","Imues 34.5","Cauca-Nariño-Putumayo",null,"SC_1790_A1","2024-12-31",2024,"2024-12-31",2,0,1,6]
["SC_830_A2",7.5,"Hidraulica","Pescador 34.5","Cauca-Nariño-Putumayo",null,"SC_830_A1","2026-12-31",2026,"2026-12-31",2,0,1,2]

{"sheet":"cortocircuito","index":5,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["nombre","barra","aportecortocircuito"]
["SC_830_A1","Santander 115",0.1]
["SC_830_A1","Pescador 34.5",0.27]
["SC_830_A1","Mondomo34.5",0.89]
["SC_830_A2","Santander 115",7.0000000000000007E-2]
["SC_830_A2","Pescador 34.5",1.21]
["SC_830_A2","Mondomo34.5",0.38]
["SC_1797_A1","CasaFria 34.5",0.11776099999999978]
["SC_1797_A1","Catambuco 115",4.5232999999999635E-2]
["SC_1797_A1","Cordoba 34.5",2.8942000000000245E-2]
["SC_1797_A1","Imues 34.5",0.13993100000000025]
["SC_1797_A1","Jamondino 115",8.9529999999999887E-2]
["SC_1797_A1","Jardinera 115",8.7087000000000359E-2]
["SC_1797_A1","Junin 115",1.6019999999999923E-3]
["SC_1797_A1","Panamericana 115",5.8923000000000059E-2]
["SC_1797_A1","Panamericana 34.5",8.1759000000000803E-2]
["SC_1797_A1","Pupiales 34.5",1.6073000000000004E-2]
["SC_1797_A1","Sapuyes 34.5",7.4890000000000789E-3]
["SC_1797_A1","Tangua 34.5",2.065963]
["SC_1797_A2","CasaFria 34.5",1.4272999999999314E-2]
["SC_1797_A2","Catambuco 115",5.0142999999999383E-2]
["SC_1797_A2","Cordoba 34.5",8.2412000000000152E-2]
["SC_1797_A2","Imues 34.5",0.13125700000000018]
["SC_1797_A2","Jamondino 115",7.6180000000000803E-2]
["SC_1797_A2","Jardinera 115",3.5546000000000078E-2]
["SC_1797_A2","Junin 115",3.975599999999968E-2]
["SC_1797_A2","Panamericana 115",4.710700000000001E-2]
["SC_1797_A2","Panamericana 34.5",2.5783000000000555E-2]
["SC_1797_A2","Pupiales 34.5",4.1336999999999957E-2]
["SC_1797_A2","Sapuyes 34.5",0.25688300000000019]
["SC_1797_A2","Tangua 34.5",1.707084]
["SC_1790_A1","Jamondino 115",8.9529999999999887E-2]
["SC_1790_A1","Catambuco 115",4.5232999999999635E-2]
["SC_1790_A1","Panamericana 115",5.8923000000000059E-2]
["SC_1790_A1","Jardinera 115",8.7087000000000359E-2]
["SC_1790_A1","Panamericana 34.5",8.1759000000000803E-2]
["SC_1790_A1","Junin 115",1.6019999999999923E-3]
["SC_1790_A1","Sapuyes 34.5",7.4890000000000789E-3]
["SC_1790_A1","Imues 34.5",0.13993100000000025]
["SC_1790_A1","Cordoba 34.5",2.8942000000000245E-2]
["SC_1790_A1","Pupiales 34.5",1.6073000000000004E-2]
["SC_1790_A1","Tangua 34.5",2.065963]
["SC_1790_A1","CasaFria 34.5",0.11776099999999978]
["SC_1790_A2","Jamondino 115",7.6180000000000803E-2]
["SC_1790_A2","Catambuco 115",5.0142999999999383E-2]
["SC_1790_A2","Panamericana 115",4.710700000000001E-2]
["SC_1790_A2","Jardinera 115",3.5546000000000078E-2]
["SC_1790_A2","Panamericana 34.5",2.5783000000000555E-2]
["SC_1790_A2","Junin 115",3.975599999999968E-2]
["SC_1790_A2","Sapuyes 34.5",0.25688300000000019]
["SC_1790_A2","Imues 34.5",0.13125700000000018]
["SC_1790_A2","Cordoba 34.5",8.2412000000000152E-2]
["SC_1790_A2","Pupiales 34.5",4.1336999999999957E-2]
["SC_1790_A2","Tangua 34.5",1.707084]
["SC_1790_A2","CasaFria 34.5",1.4272999999999314E-2]

{"sheet":"zonas","index":6,"n_rows":111,"n_cols":4,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["nombre","periodo","capacidad","factor"]
["Zona7",2023,450,1]
["Zona7",2024,500,1]
["Zona7",2025,575,1]
["Zona7",2026,553.125,1]
["Zona7",2027,514.84375,1]
["Zona7",2028,486.1328125,1]
["Zona7",2029,486.1328125,1]
["Zona7",2030,486.1328125,1]
["Zona7",2031,443.06640625,1]
["Zona7",2032,443.06640625,1]
["Zona7",2033,371.533203125,1]
["Zona3",2023,186.8194580078125,1]
["Zona3",2024,193.0694580078125,1]
["Zona3",2025,205.5694580078125,1]
["Zona3",2026,208.6944580078125,1]
["Zona3",2027,201.22222900390619,1]
["Zona3",2028,210.59722900390619,1]
["Zona3",2029,210.59722900390619,1]
["Zona3",2030,73.624706268310547,1]
["Zona3",2031,210.29167175292969,1]
["Zona3",2032,210.29167175292969,1]
["Zona3",2033,210.29167175292969,1]
["Zona10",2023,136.6540789604187,1]
["Zona10",2024,155.7947039604187,1]
["Zona10",2025,147.2746810875833,1]
["Zona10",2026,156.6496810875833,1]
["Zona10",2027,144.41142475261589,1]
["Zona10",2028,156.91142475261589,1]
["Zona10",2029,149.55620171733699,1]
["Zona10",2030,107.21282958984381,1]
["Zona10",2031,149.9920438243368,1]
["Zona10",2032,149.9920438243368,1]
["Zona10",2033,149.9920438243368,1]
["Zona1",2023,209.375,1]
["Zona1",2024,218.75,1]
["Zona1",2025,221.875,1]
["Zona1",2026,221.875,1]
["Zona1",2027,219.140625,1]
["Zona1",2028,222.265625,1]
["Zona1",2029,222.265625,1]
["Zona1",2030,225.390625,1]
["Zona1",2031,225.390625,1]
["Zona1",2032,223.8037109375,1]
["Zona1",2033,223.8037109375,1]
["Zona2",2023,96.704426520019695,1]
["Zona2",2024,95.193419855644379,1]
["Zona2",2025,96.685234576073356,1]
["Zona2",2026,96.685234576073356,1]
["Zona2",2027,96.000014231772155,1]
["Zona2",2028,96.000014231772155,1]
["Zona2",2029,81.591515742911724,1]
["Zona2",2030,81.591515742911724,1]
["Zona2",2031,96.000014231772155,1]
["Zona2",2032,96.000014231772155,1]
["Zona2",2033,96.000014231772155,1]
["Zona6",2023,184.375,1]
["Zona6",2024,194.53792572021479,1]
["Zona6",2025,203.91292572021479,1]
["Zona6",2026,203.91292572021479,1]
["Zona6",2027,197.5406467914581,1]
["Zona6",2028,206.9156467914581,1]
["Zona6",2029,206.9156467914581,1]
["Zona6",2030,176.45263671875,1]
["Zona6",2031,206.7587616853416,1]
["Zona6",2032,205.14345885967489,1]
["Zona6",2033,205.14345885967489,1]
["Zona8",2023,700,1]
["Zona8",2024,700,1]
["Zona8",2025,812.5,1]
["Zona8",2026,812.5,1]
["Zona8",2027,818.359375,1]
["Zona8",2028,809.1796875,1]
["Zona8",2029,804.58984375,1]
["Zona8",2030,804.58984375,1]
["Zona8",2031,804.58984375,1]
["Zona8",2032,802.294921875,1]
["Zona8",2033,802.294921875,1]
["Zona5",2023,168.75,1]
["Zona5",2024,181.25,1]
["Zona5",2025,218.75,1]
["Zona5",2026,205.078125,1]
["Zona5",2027,192.2607421875,1]
["Zona5",2028,180.24444580078119,1]
["Zona5",2029,180.24444580078119,1]
["Zona5",2030,180.24444580078119,1]
["Zona5",2031,168.97916793823239,1]
["Zona5",2032,147.8567719459534,1]
["Zona5",2033,147.8567719459534,1]
["Zona4",2023,63.264222490943212,1]
["Zona4",2024,68.75,1]
["Zona4",2025,81.25,1]
["Zona4",2026,76.171875,1]
["Zona4",2027,73.79150390625,1]
["Zona4",2028,69.179534912109375,1]
["Zona4",2029,66.94793701171875,1]
["Zona4",2030,66.94793701171875,1]
["Zona4",2031,66.94793701171875,1]
["Zona4",2032,64.855813980102539,1]
["Zona4",2033,65.888690948486328,1]
["Zona9",2023,20.710866451263421,1]
["Zona9",2024,20.710866451263421,1]
["Zona9",2025,20.710866451263421,1]
["Zona9",2026,20.710866451263421,1]
["Zona9",2027,20.710866451263421,1]
["Zona9",2028,20.710866451263421,1]
["Zona9",2029,20.710866451263421,1]
["Zona9",2030,20.710866451263421,1]
["Zona9",2031,20.710866451263421,1]
["Zona9",2032,21.023366451263421,1]
["Zona9",2033,20.767524838447571,1]

{"sheet":"zonaBarra","index":7,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["nombre","barra"]
["Zona1","Popayan 115"]
["Zona1","Florida (Cauca) 115"]
["Zona1","Guapi 115"]
["Zona1","Olaya 115"]
["Zona1","S Bernardino 115"]
["Zona2","El Zaque 115"]
["Zona2","Pasto 115"]
["Zona2","San Martin 115"]
["Zona2","Rio Mayo 115"]
["Zona2","Catambuco 115"]
["Zona2","Jamondino 115"]
["Zona3","Santander 115"]
["Zona3","Paez (Cabaña) 115"]
["Zona4","Panamericana 115"]
["Zona4","Junin 115"]
["Zona4","Jardinera 115"]
["Zona4","Cordoba 34.5"]
["Zona4","Imues 34.5"]
["Zona4","Panamericana 34.5"]
["Zona4","Tumaco 115"]
["Zona5","Jamondino 220"]
["Zona5","Renacer 220"]
["Zona5","Pto Caicedo 115"]
["Zona5","Yarumo 115"]
["Zona6","Paez 220"]
["Zona7","Tesalia 220"]
["Zona8","S Bernardino 220"]
["Zona9","Mondomo34.5"]
["Zona9","Pescador 34.5"]
["Zona10","Jamundi 115"]

{"sheet":"calificacionProyectos","index":8,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["nombre","BT_Confi","BT_Flex","EC_RE","EC_RP","EC_Per","EC_Mar","B_Ambiental"]
["SC_1797_A1",1046093.7014400265,532402.71185945196,1279199.2769390531,2233314.8329703775,30466.641786060238,2233314.8329703775,532402.71185945196]
["SC_1790_A1",1046093.7014400265,532402.71185945196,1279199.2769390531,2233314.8329703775,531129.59482687956,2233314.8329703775,532402.71185945196]
["SC_830_A1",2492450.5814773492,1723530.620306287,1911187.8929146468,1510184.4921459206,419133.87463419,1510184.4921459206,532402.71185945196]
["SC_1797_A2",1046093.7014400265,532402.71185945196,1279199.2769390531,2233314.8329703775,0,2233314.8329703775,532402.71185945196]
["SC_1790_A2",1046093.7014400265,532402.71185945196,1279199.2769390531,2233314.8329703775,531020.83608540357,2233314.8329703775,532402.71185945196]
["SC_830_A2",2492450.5814773492,1723530.620306287,1911187.8929146468,1510184.4921459206,508440.09768366814,1510184.4921459206,532402.71185945196]

{"sheet":"ejecutar","index":9,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OPTIMIZADOR",null,"cbc"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PERIODO INICIAL",null,2023]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PERIODO FINAL",null,2033]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ESCALAR",null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOLERANCIA ",null,9.9999999999999995E-7]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TIEMPO MAXIMO",null,1000]
[]
[null,null,null,null,null,null,null,null,null,null,null,"OBRAS EN FILA 2",null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BOLSA",null,3]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SUBAREA",null,"Cauca-Nariño-Putumayo"]

{"sheet":"ASIGNACION","index":10,"n_rows":8,"n_cols":28,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","aprobado","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion","calificacion"]
["nombre","barra","tipo","capacidad","periodoIni","Fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["SC_830_A2","Pescador 34.5","Hidraulica",7.5,2026,2,0,0,0,1,1,1,1,1,1,1,1,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666,9060606.7441586666]
["SC_830_A1","Mondomo34.5","Hidraulica",7.5,2026,2,0,0,0,0,0,0,0,0,0,0,0,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188,8971300.521109188]
["SC_1790_A1","Cordoba 34.5","Solar FV",6.2,2024,2,0,1,1,1,1,1,1,1,1,1,1,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134,6898518.3480788134]
["SC_1790_A2","Imues 34.5","Solar FV",6.2,2024,2,0,0,0,0,0,0,0,0,0,0,0,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368,6898409.5893373368]
["SC_1797_A1","Cordoba 34.5","Solar FV",9.4,2024,2,0,1,1,1,1,1,1,1,1,1,1,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938,6397855.3950379938]
["SC_1797_A2","Imues 34.5","Solar FV",9.4,2024,2,0,0,0,0,0,0,0,0,0,0,0,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335,6367388.7532519335]

{"sheet":"RESUMEN","index":11,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,"capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada"]
["tipo","Fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Hidraulica",2,0,0,0,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5]
["Solar FV",2,0,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001]

{"sheet":"RESUMEN %","index":12,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[null,null,"capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada","capacidad aprobada"]
["tipo","Fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Hidraulica",2,0,0,0,7.5,7.5,7.5,7.5,7.5,7.5,7.5,7.5]
["Solar FV",2,0,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001,15.600000000000001]

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

{"sheet":"BENEFICIO","index":14,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[2,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786,1572.7429493639786]

{"sheet":"INTERCAMBIO","index":15,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["area","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Cauca-Nariño-Putumayo",2,-100,-115.6,-115.6,-123.1,-123.1,-123.1,-123.1,-123.1,-123.1,-123.1,-123.1]

{"sheet":"PORCENTAJE BARRAS","index":16,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["barra","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Catambuco 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Cordoba 34.5",2,0,0.78730409068506657,0.78614173228346462,0.77753224628863482,0.79110560851801415,0.79110560851801415,0.78924901185770757,0.77696498054474716,0.78551355338373596,0.78551355338373596,0.78551355338373596]
["El Zaque 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Florida (Cauca) 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Guapi 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Imues 34.5",2,0,0,0,0,0,0,0,0,0,0,0]
["Jamondino 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Jamondino 220",2,0,0,0,0,0,0,0,0,0,0,0]
["Jamundi 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Jardinera 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Junin 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Mocoa 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Mondomo34.5",2,0,0,0,0,0,0,0,0,0,0,0]
["Olaya 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Paez (Cabaña) 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Paez 220",2,0,0,0,0,0,0,0,0,0,0,0]
["Panamericana 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Panamericana 138",2,0,0,0,0,0,0,0,0,0,0,0]
["Panamericana 34.5",2,0,0,0,0,0,0,0,0,0,0,0]
["Pasto 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Pescador 34.5",2,0,0,0,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.35674591019409641,0.3611407742782623]
["Popayan 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Pto Caicedo 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Renacer 220",2,0,0,0,0,0,0,0,0,0,0,0]
["Rio Mayo 115",2,0,0,0,0,0,0,0,0,0,0,0]
["S Bernardino 115",2,0,0,0,0,0,0,0,0,0,0,0]
["S Bernardino 220",2,0,0,0,0,0,0,0,0,0,0,0]
["San Martin 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Santander 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Santander 34.5",2,0,0,0,0,0,0,0,0,0,0,0]
["Tesalia 220",2,0,0,0,0,0,0,0,0,0,0,0]
["Tumaco 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Yarumo 115",2,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"PORCENTAJE AREAS","index":17,"n_rows":2,"n_cols":13,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["area","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Cauca-Nariño-Putumayo",2,-1.000001000001E-4,-1.156001156001156E-4,-1.156001156001156E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4,-1.231001231001231E-4]

{"sheet":"PORCENTAJE ZONAS","index":18,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["zona","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Zona1",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona10",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona2",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona3",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona4",2,0,0.22690909090909092,0.192,0.20480000000000001,0.21140645161290325,0.22550021505376347,0.23301688888888891,0.23301688888888891,0.23301688888888891,0.24053356272401435,0.23676293724209105]
["Zona5",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona6",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona7",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona8",2,0,0,0,0,0,0,0,0,0,0,0]
["Zona9",2,0,0,0,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.36212874133725481,0.35674591019409641,0.3611407742782623]