{"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":7,"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"]
["Arauca",2023,9999999,999999,200,300,1,1]
["Arauca",2024,9999999,999999,200,300,1,1]
["Arauca",2025,9999999,999999,200,300,1,1]
["Arauca",2026,9999999,999999,200,300,1,1]
["Arauca",2027,9999999,999999,200,300,1,1]
["Arauca",2028,9999999,999999,200,300,1,1]
["Arauca",2029,9999999,999999,200,300,1,1]
["Arauca",2030,9999999,999999,200,300,1,1]
["Arauca",2031,9999999,999999,200,300,1,1]
["Arauca",2032,9999999,999999,200,300,1,1]
["Arauca",2033,9999999,999999,200,300,1,1]

{"sheet":"barras","index":1,"n_rows":111,"n_cols":6,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["nombre","periodo","capacidad","cortocircuito","factorcapacidad","factorcorto"]
["Banadia 220",2023,400.390625,10.32191974,1,1]
["Samore 220",2023,483.740234375,28.912548480000002,1,1]
["Toledo 220",2023,522.63946533203125,27.921754369999999,1,1]
["Playitas 115(1)",2023,0,12.5,1,1]
["La Paz 115",2023,0,0,1,1]
["La Paz 220",2023,0,0,1,1]
["Barra Banad 34.5",2023,39.2572021484375,8.1110607849999994,1,1]
["C Limon 220",2023,342.6514928939373,10.89050784,1,1]
["Banadia 115",2023,21.62093177359225,9.589999164,1,1]
["Banadia 115",2024,21.283104714629872,9.2859980849999992,1,1]
["Banadia 220",2024,400.78125,10.10145268,1,1]
["Samore 220",2024,489.35546875,28.650946040000001,1,1]
["Toledo 220",2024,529.19921875,27.556120870000001,1,1]
["Playitas 115(1)",2024,49.546484584923171,12.5,1,1]
["La Paz 115",2024,0,0,1,1]
["La Paz 220",2024,0,0,1,1]
["Barra Banad 34.5",2024,33.3197021484375,7.582408751,1,1]
["C Limon 220",2024,349.18327331542969,10.707176779999999,1,1]
["Banadia 115",2025,32.703229847538751,9.1437477690000009,1,1]
["Banadia 115",2026,47.845604714629872,8.5597615390000001,1,1]
["Banadia 220",2025,408.18673614885307,10.08732474,1,1]
["Samore 220",2025,487.2955322265625,28.641175749999999,1,1]
["Toledo 220",2025,523.7635612487793,27.54950535,1,1]
["Playitas 115(1)",2025,44.902545213699348,10.9850785,1,1]
["La Paz 115",2025,0,0,1,1]
["La Paz 220",2025,0,0,1,1]
["Barra Banad 34.5",2025,27.90985107421875,7.3116789000000004,1,1]
["C Limon 220",2025,518.14472422954702,10.695775599999999,1,1]
["Banadia 115",2027,46.754369139671333,8.5617031039999993,1,1]
["Banadia 115",2028,46.754369139671333,8.5625358079999998,1,1]
["Banadia 220",2026,649.20236114885313,8.9287823129999992,1,1]
["Samore 220",2026,648.63835342634695,27.8388536,1,1]
["Toledo 220",2026,433.75678062438959,26.890659299999999,1,1]
["Playitas 115(1)",2026,98.027545213699341,9.4569769350000001,1,1]
["La Paz 115",2026,192.1875,8.7201734940000009,1,1]
["La Paz 220",2026,519.921875,9.64266544,1,1]
["Barra Banad 34.5",2026,30.40985107421875,6.8582939469999999,1,1]
["C Limon 220",2026,519.87909922954668,9.6442432779999994,1,1]
["Banadia 115",2029,46.754369139671333,8.5625358079999998,1,1]
["Banadia 115",2030,46.754369139671333,8.5617031039999993,1,1]
["Banadia 220",2027,631.19359676895556,8.9307630299999996,1,1]
["Samore 220",2027,644.75337915406021,27.84115396,1,1]
["Toledo 220",2027,433.75678062438971,26.89383656,1,1]
["Playitas 115(1)",2027,94.964184425771236,9.4584015130000001,1,1]
["La Paz 115",2027,192.1875,8.7220564409999994,1,1]
["La Paz 220",2027,504.46319580078119,9.6442177699999991,1,1]
["Barra Banad 34.5",2027,31.03485107421875,6.8609989770000004,1,1]
["C Limon 220",2027,504.42593409448801,9.6457947399999995,1,1]
["Banadia 115",2031,46.754369139671333,8.5617031039999993,1,1]
["Banadia 115",2032,46.754369139671333,8.5617031039999993,1,1]
["Banadia 220",2028,629.83894678788749,8.9316187990000007,1,1]
["Samore 220",2028,644.75337915406021,27.842168130000001,1,1]
["Toledo 220",2028,433.75678062438971,26.895260180000001,1,1]
["Playitas 115(1)",2028,94.964184425771236,9.4590113480000007,1,1]
["La Paz 115",2028,192.1875,8.7228638870000008,1,1]
["La Paz 220",2028,504.05513644218439,9.6448863130000007,1,1]
["Barra Banad 34.5",2028,31.03485107421875,6.8621579199999996,1,1]
["C Limon 220",2028,504.01802028943138,9.6464629039999998,1,1]
["Banadia 115",2033,46.455163643740264,8.5617031039999993,1,1]
["Tame 115",2023,22.33865390786373,29.375407639999999,1,1]
["Banadia 220",2029,630.22957178788749,8.9316187990000007,1,1]
["Samore 220",2029,644.75337915406021,27.842168130000001,1,1]
["Toledo 220",2029,433.75678062438971,26.895260180000001,1,1]
["Playitas 115(1)",2029,91.996553662465885,9.4590113480000007,1,1]
["La Paz 115",2029,192.1875,8.7228638870000008,1,1]
["La Paz 220",2029,503.64867106545722,9.6448863130000007,1,1]
["Barra Banad 34.5",2029,31.03485107421875,6.8621579199999996,1,1]
["C Limon 220",2029,503.61169989767569,9.6464629039999998,1,1]
["Tame 115",2024,21.640570973242991,29.178300660000001,1,1]
["Tame 115",2025,23.863490779733802,28.879327459999999,1,1]
["Banadia 220",2030,630.62019678788749,8.9307630299999996,1,1]
["Samore 220",2030,644.75337915406021,27.84115396,1,1]
["Toledo 220",2030,433.75678062438971,26.89383656,1,1]
["Playitas 115(1)",2030,91.996553662465885,9.4584015130000001,1,1]
["La Paz 115",2030,192.1875,8.7220564409999994,1,1]
["La Paz 220",2030,504.03929606545722,9.6442177699999991,1,1]
["Barra Banad 34.5",2030,31.34735107421875,6.8609989770000004,1,1]
["C Limon 220",2030,503.20696669495038,9.6457947399999995,1,1]
["Tame 115",2026,56.688690185546882,28.217617629999999,1,1]
["Tame 115",2027,51.374125480651863,28.21909831,1,1]
["Banadia 220",2031,629.26890657233344,8.9307630299999996,1,1]
["Samore 220",2031,637.34478279948235,27.84115396,1,1]
["Toledo 220",2031,434.38178062438902,26.89383656,1,1]
["Playitas 115(1)",2031,91.996553662465885,9.4584015130000001,1,1]
["La Paz 115",2031,192.1875,8.7220564409999994,1,1]
["La Paz 220",2031,503.63289256520147,9.6442177699999991,1,1]
["Barra Banad 34.5",2031,31.65985107421875,6.8609989770000004,1,1]
["C Limon 220",2031,502.80381448129822,9.6457947399999995,1,1]
["Tame 115",2028,49.768684059381492,28.219732130000001,1,1]
["Tame 115",2029,49.768684059381492,28.219732130000001,1,1]
["Banadia 220",2032,628.82111573918428,8.9307630299999996,1,1]
["Samore 220",2032,637.34478279948235,27.84115396,1,1]
["Toledo 220",2032,437.19089031219482,26.89383656,1,1]
["Playitas 115(1)",2032,89.121661360513826,9.4584015130000001,1,1]
["La Paz 115",2032,184.68017578125,8.7220564409999994,1,1]
["La Paz 220",2032,503.22807657861858,9.6442177699999991,1,1]
["Barra Banad 34.5",2032,31.65985107421875,6.8609989770000004,1,1]
["C Limon 220",2032,502.40223708098063,9.6457947399999995,1,1]
["Tame 115",2030,48.991048370953663,28.21909831,1,1]
["Tame 115",2031,48.991048370953663,28.21909831,1,1]
["Banadia 220",2033,628.3741994975062,8.9307630299999996,1,1]
["Samore 220",2033,615.09370941203088,27.84115396,1,1]
["Toledo 220",2033,439.06589031219403,26.89383656,1,1]
["Playitas 115(1)",2033,89.121661360513826,9.4584015130000001,1,1]
["La Paz 115",2033,185.46142578125,8.7220564409999994,1,1]
["La Paz 220",2033,502.82484190448338,9.6442177699999991,1,1]
["Barra Banad 34.5",2033,32.28485107421875,6.8609989770000004,1,1]
["C Limon 220",2033,502.79286208098063,9.6457947399999995,1,1]
["Tame 115",2032,47.460078109361348,28.21909831,1,1]
["Tame 115",2033,47.460078109361362,28.21909831,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":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["nombre","capacidad","tipo","barra","area","obra","excluyente","fpo","periodoIni","fpomax","fila","obligatorio","activo","ordenLlegada"]
["SC_1323_A1",30,"Termica - Ciclo Abierto","Barra Banad 34.5","Arauca",null,"SC_1323_A2","2023-08-31",{"$f":"YEAR(H2)","v":2023},"2023-08-31",2,0,1,1]
["SC_1323_A2",30,"Termica - Ciclo Abierto","Banadia 115","Arauca",null,"SC_1323_A3","2023-08-31",{"$f":"YEAR(H3)","v":2023},"2023-08-31",2,0,1,2]
["SC_1323_A3",30,"Termica - Ciclo Abierto","Banadia 220","Arauca",null,"SC_1323_A1","2023-08-31",2023,"2023-08-31",2,0,1,3]

{"sheet":"cortocircuito","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["nombre","barra","aportecortocircuito"]
["SC_1323_A1","Barra Banad 34.5",1.92]
["SC_1323_A1","Banadia 115",0.45]
["SC_1323_A1","Banadia 220",0.16]
["SC_1323_A2","Barra Banad 34.5",0.56999999999999995]
["SC_1323_A2","Banadia 115",0.51]
["SC_1323_A2","Banadia 220",0.25]

{"sheet":"zonas","index":6,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["nombre","periodo","capacidad","factor"]
["Zona2",2023,522.63946533203125,1]
["Zona2",2024,529.19921875,1]
["Zona2",2025,523.7635612487793,1]
["Zona2",2026,433.75678062438959,1]
["Zona2",2027,433.75678062438971,1]
["Zona2",2028,433.75678062438971,1]
["Zona2",2029,433.75678062438971,1]
["Zona2",2030,433.75678062438971,1]
["Zona2",2031,434.38178062438902,1]
["Zona2",2032,437.19089031219482,1]
["Zona2",2033,439.06589031219403,1]
["Zona1",2023,400.390625,1]
["Zona1",2024,400.78125,1]
["Zona1",2025,519.14472422954702,1]
["Zona1",2026,649.20236114885313,1]
["Zona1",2027,631.19359676895556,1]
["Zona1",2028,629.83894678788749,1]
["Zona1",2029,630.22957178788749,1]
["Zona1",2030,630.62019678788749,1]
["Zona1",2031,629.26890657233344,1]
["Zona1",2032,628.82111573918428,1]
["Zona1",2033,628.3741994975062,1]
["Zona3",2023,483.740234375,1]
["Zona3",2024,489.35546875,1]
["Zona3",2025,487.2955322265625,1]
["Zona3",2026,648.63835342634695,1]
["Zona3",2027,644.75337915406021,1]
["Zona3",2028,644.75337915406021,1]
["Zona3",2029,644.75337915406021,1]
["Zona3",2030,644.75337915406021,1]
["Zona3",2031,637.34478279948235,1]
["Zona3",2032,637.34478279948235,1]
["Zona3",2033,615.09370941203088,1]

{"sheet":"zonaBarra","index":7,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["nombre","barra"]
["Zona1","Banadia 220"]
["Zona1","Tame 34.5"]
["Zona1","Barra Banad 34.5"]
["Zona1","Playitas 115(1)"]
["Zona1","La Paz 220"]
["Zona1","La Paz 115"]
["Zona1","C Limon 220"]
["Zona1","Banadia 115"]
["Zona1","Tame 115"]
["Zona2","Toledo 220"]
["Zona3","Samore 220"]

{"sheet":"calificacionProyectos","index":8,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["nombre","BT_Confi","BT_Flex","EC_RE","EC_RP","EC_Per","EC_Mar","B_Ambiental"]
["SC_1323_A1",28031949.229069807,19189148.297214948,0,13339267.683275502,17920395.191768471,13339267.683275502,17642891.425462402]
["SC_1323_A2",28031949.229069807,19189148.297214948,0,13339267.683275502,18383607.710774753,13339267.683275502,17642891.425462402]
["SC_1323_A3",28031949.229069807,19189148.297214948,0,13339267.683275502,18453574.924580615,13339267.683275502,17642891.425462402]

{"sheet":"ejecutar","index":9,"n_rows":20,"n_cols":14,"rows_kept":20,"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]

{"sheet":"ASIGNACION","index":10,"n_rows":5,"n_cols":28,"rows_kept":5,"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_1323_A3","Banadia 220","Termica - Ciclo Abierto",30,2023,2,1,1,1,1,1,1,1,1,1,1,1,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349,90976441.403417349]
["SC_1323_A2","Banadia 115","Termica - Ciclo Abierto",30,2023,2,0,0,0,0,0,0,0,0,0,0,0,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495,90906474.189611495]
["SC_1323_A1","Barra Banad 34.5","Termica - Ciclo Abierto",30,2023,2,0,0,0,0,0,0,0,0,0,0,0,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212,90443261.670605212]

{"sheet":"RESUMEN","index":11,"n_rows":3,"n_cols":13,"rows_kept":3,"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]
["Termica - Ciclo Abierto",2,30,30,30,30,30,30,30,30,30,30,30]

{"sheet":"RESUMEN %","index":12,"n_rows":3,"n_cols":13,"rows_kept":3,"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]
["Termica - Ciclo Abierto",2,30,30,30,30,30,30,30,30,30,30,30]

{"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,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727,30022.225663127727]

{"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]
["Arauca",2,-130,-130,-130,-130,-130,-130,-130,-130,-130,-130,-130]

{"sheet":"PORCENTAJE BARRAS","index":16,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["barra","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Banadia 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Banadia 220",2,7.492682926829268E-2,7.4853801169590645E-2,7.3495773731020814E-2,4.6210552818863541E-2,4.7528999269904365E-2,4.7631224066083638E-2,4.7601701575020534E-2,4.7572215658184293E-2,4.767437209540807E-2,4.770832157049109E-2,4.7742252982363356E-2]
["Barra Banad 34.5",2,0,0,0,0,0,0,0,0,0,0,0]
["C Limon 220",2,0,0,0,0,0,0,0,0,0,0,0]
["La Paz 115",2,null,null,null,0,0,0,0,0,0,0,0]
["La Paz 220",2,null,null,null,0,0,0,0,0,0,0,0]
["Playitas 115(1)",2,null,0,0,0,0,0,0,0,0,0,0]
["Samore 220",2,0,0,0,0,0,0,0,0,0,0,0]
["Tame 115",2,0,0,0,0,0,0,0,0,0,0,0]
["Toledo 220",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]
["Arauca",2,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4,-1.3000013000013001E-4]

{"sheet":"PORCENTAJE ZONAS","index":18,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["zona","fila",2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
["Zona1",2,7.492682926829268E-2,7.4853801169590645E-2,5.7787354084205399E-2,4.6210552818863541E-2,4.7528999269904365E-2,4.7631224066083638E-2,4.7601701575020534E-2,4.7572215658184293E-2,4.767437209540807E-2,4.770832157049109E-2,4.7742252982363356E-2]
["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]