{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["Analisis","Datos","Cobija","Riberalta","San Ingacio Velasco","Las Misiones","Valles","Camiri","German Busch","Bermejo","Chiquitos","Huacaraje","Bella Vista","El Sena"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":11,"defined_names":1291,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Analisis","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,5],[18,2,18,5]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Pando",{"$f":"+'Las Misiones'!C3","v":"Santa Cruz"},{"$f":"+'German Busch'!C4","v":"Santa Cruz"},{"$f":"+Huacaraje!C4","v":"Beni"}]
[null,"Provincia","Nicolas Suarez",{"$f":"+'Las Misiones'!C4","v":"Guarayos"},{"$f":"+'German Busch'!C5","v":"German Bush"},{"$f":"+Huacaraje!C5","v":"Itenez"}]
[null,"Sistema Eléctrico","Cobija",{"$f":"+'Las Misiones'!C5","v":"Las Misiones"},{"$f":"+'German Busch'!C6","v":"German Busch"},{"$f":"+Huacaraje!C6","v":"Huacaraje"}]
[null,"Empresa","ENDE",{"$f":"+'Las Misiones'!C6","v":"CRE Ltda."},{"$f":"+'German Busch'!C7","v":"CRE Ltda."},{"$f":"+Huacaraje!C7","v":"ENDE DELBENI S.A.M."}]
[null,"Combustible","Diesel",{"$f":"+'Las Misiones'!C7","v":"Gas/Diesel"},{"$f":"+'German Busch'!C8","v":"Gas"},{"$f":"+Huacaraje!C8","v":"Diesel"}]
[null,"Consumo especifico (pc/kWh) (*)",null,{"$f":"+'Las Misiones'!C8","v":13.231302586681062},{"$f":"+'German Busch'!C9","v":13.475068851751542}]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"+Cobija!C9","v":0.26606625750993845},{"$f":"+'Las Misiones'!C9","v":0.27718065536918751},null,{"$f":"+Huacaraje!C9","v":0.36575954954518364}]
[null,"Energía Alternativa",{"$f":"+Cobija!C10","v":"Solar"}]
[null,"Potencia Instalada MW",{"$f":"+Cobija!C11","v":5.0999999999999996}]
[null,"Potencia a Temp. Media (MW)",{"$f":"+Cobija!C12","v":5.0999999999999996}]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"+Cobija!C13","v":4.974914610377823E-2},{"$f":"+'Las Misiones'!C10","v":6.2553416093206415E-2},{"$f":"+'German Busch'!C10","v":5.5E-2},{"$f":"+Huacaraje!C10","v":1.5149920384314175E-3}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"+Cobija!C14","v":0.83270384196113723},{"$f":"+'Las Misiones'!C11","v":0.84237616434307439},{"$f":"+'German Busch'!C11","v":0.91838243797367758},{"$f":"+Huacaraje!C11","v":0.86183970738265214}]
[null,"Factor  Ʃ(Generacion Total - Bruta)/Ʃ(Generación Diesel)",null,{"$f":"+'Las Misiones'!C12","v":0.16051175725136119}]
[]
[]
[null,null,2018]
[null,null,{"$f":"+C6","v":"Cobija"},{"$f":"+D6","v":"Las Misiones"},{"$f":"+E6","v":"German Busch"},{"$f":"+F6","v":"Huacaraje"}]
[null,"Generación Total",{"$f":"+Cobija!H17","v":63151.7791},{"$f":"+'Las Misiones'!H15","v":58424.895768660623},{"$f":"+'German Busch'!H14","v":57411.820999999996},{"$f":"+Huacaraje!H14","v":680.3341416666666},"MWh"]
[null,"Generación Energía Renovable",{"$f":"+Cobija!H18","v":5319.8761000000022},{"$f":"+'Las Misiones'!H16","v":0},{"$f":"+'German Busch'!H15","v":0},{"$f":"+Huacaraje!H15","v":0},"MWh"]
[null,"Generación Fósil",{"$f":"+Cobija!H19","v":57831.902999999998},{"$f":"+'Las Misiones'!H17","v":58424.895768660623},{"$f":"+'German Busch'!H16","v":57411.820999999996},{"$f":"+Huacaraje!H16","v":680.3341416666666},"MWh"]
[null,"Generación Fósil Gas",null,{"$f":"+'Las Misiones'!H18","v":45374.324201240481},null,null,"MWh"]
[null,"Generación Fósil Diesel",null,{"$f":"+'Las Misiones'!H19","v":13050.571567420144},null,null,"MWh"]
[null,"Combustible Fósil gas natural",null,{"$f":"+'Las Misiones'!H20","v":640147.59325666993},{"$f":"+'German Busch'!H17","v":787872.44400000002},null,"MPC"]
[null,"Combustible Fósil Diesel",{"$f":"+Cobija!H20","v":15908.519},{"$f":"+'Las Misiones'!H21","v":3617.36598},null,{"$f":"+Huacaraje!H17","v":212.65},"Miles de Litros"]
[null,"Energía Vendida",{"$f":"+Cobija!H21","v":55108.400999999998},{"$f":"+'Las Misiones'!H22","v":52336.572},{"$f":"+'German Busch'!H18","v":52818.988000000005},{"$f":"+Huacaraje!H18","v":596.26700000000005},"MWh"]
[null,"Cantidad de Usuarios",{"$f":"+Cobija!H22","v":17092},{"$f":"+'Las Misiones'!H23","v":28263},{"$f":"+'German Busch'!H19","v":10771},{"$f":"+Huacaraje!H19","v":505}]
[null,"Consumo  por usuario (***)",{"$f":"+Cobija!H23","v":268.68515972384745},{"$f":"+'Las Misiones'!H24","v":154.31415631744684},{"$f":"+'German Busch'!H20","v":408.65122396558667},{"$f":"+Huacaraje!H20","v":98.393894389438955},"kWh/usuario-mes"]
[null,"Demanda Máxima",{"$f":"+Cobija!H24","v":12.36},{"$f":"+'Las Misiones'!H25","v":11.7398552093505},{"$f":"+'German Busch'!H21","v":10.25271},{"$f":"+Huacaraje!H21","v":0.159},"MW"]
[null,"Potencia Instalada",{"$f":"+Cobija!H25","v":22.560000000000002},{"$f":"+'Las Misiones'!H26","v":21.349999999999994},{"$f":"+'German Busch'!H22","v":23.199999999999996},{"$f":"+Huacaraje!H22","v":0.46400000000000002},"MW"]
[null,"Pot. Efectiva a Temp. Media",{"$f":"+Cobija!H26","v":19.500000000000004},{"$f":"+'Las Misiones'!H27","v":19.05},{"$f":"+'German Busch'!H23","v":19.099999999999998},{"$f":"+Huacaraje!H23","v":0.39800000000000002},"MW"]
[null,"Factor de Planta (****)",{"$f":"+Cobija!H27","v":0.3385546364594309},{"$f":"+'Las Misiones'!H28","v":0.3501054409128862},{"$f":"+'German Busch'!H24","v":0.34313407564130155},{"$f":"+Huacaraje!H24","v":0.19513496181439921}]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Datos","index":1,"n_rows":121,"n_cols":8,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Potencia  Instalada (MW)"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija","MW",20.61,25,25,24.16,22.560000000000002]
[null,"Riberalta","MW",10.079999999999998,10.08,15.75,16.05,16.120000000000005]
[null,"San Ignacio de Velasco","MW",8.2040000000000006,8.2040000000000006,8.2040000000000006,8.2040000000000006,7.84]
[null,"Las Misiones","MW",17.149999999999999,17.149999999999999,21.349999999999994,21.349999999999994,21.349999999999994]
[null,"Valles Cruceños","MW",7.64,7.64,9.64,11.637999999999998,11.637999999999998]
[null,"Camiri","MW",7.2499999999999991,7.9,9.06,10.866,12.673999999999999]
[null,"German Busch","MW",20.999999999999996,20.999999999999996,20.999999999999996,20.999999999999996,23.199999999999996]
[null,"Bermejo","MW",10.199000000000002,9.23,12.22,15.419,14.443999999999999]
[null,"Chiquitos","MW",5.84,5.84,5.84,5.84,7.54]
[null,"Huacaraje","MW",null,null,0.56999999999999995,0.69499999999999995,0.46400000000000002]
[null,"Bella Vista","MW",null,null,null,0.76600000000000001,1.4260000000000002]
[null,"El Sena","MW",null,1.42,2.2160000000000002,2.2160000000000002,2.2160000000000002]
[]
[]
[null,null,null,"Potencia Efectiva a temperatura media (MW)"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija","MW",15.96,19.260000000000002,19.66,19.2,19.500000000000004]
[null,"Riberalta","MW",9.2700000000000014,9.27,15.26,15.709999999999992,15.779999999999992]
[null,"San Ignacio de Velasco","MW",7.1010000000000009,7.1010000000000009,7.1010000000000009,7.1010000000000009,6.7919999999999998]
[null,"Las Misiones","MW",14.999999999999998,15,19.05,19.05,19.05]
[null,"Valles Cruceños","MW",6.48,6.48,8.1300000000000008,8.5,9.56]
[null,"Camiri","MW",6.5,7.1,8.25,10,11.75]
[null,"German Busch","MW",17.399999999999999,17.399999999999999,17.399999999999999,17.399999999999999,19.099999999999998]
[null,"Bermejo","MW",8.15,7.35,9.6,12.399999999999999,11.55]
[null,"Chiquitos","MW",4.84,4.84,4.84,4.84,7.2]
[null,"Huacaraje","MW",null,null,0.13,0.64800000000000002,0.39800000000000002]
[null,"Bella Vista","MW",null,null,null,0.66800000000000015,1.111]
[null,"El Sena","MW",null,1.1000000000000001,1.2999999999999998,1.2999999999999998,1.2999999999999998]
[]
[]
[null,null,null,"Generacion Bruta (MWh)"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija"]
[null,"Cobija Planta Solar","MWh",0,4794.3755010909099,5627.8183999999992,5776.1255999999994,5319.8761000000022]
[null,"Cobija Combustioble Fosil","MWh",52004.804699999993,56054.181291999994,55734.794489999993,56969.075999999994,57831.902999999998]
[null,"Riberalta","MWh",39754.100399999988,44000,47860,49359.07,54122.220000000008]
[null,"San Ignacio de Velasco","MWh",20118.833000000006,22009.939000000002,23362.835999999999,24446.846999999998,25906.172000000006]
[null,"Las Misiones","MWh",45834.749141093853,51150.008000000002,55241.41,59494.525999999991,58424.895768660623]
[null,"Valles Cruceños","MWh",24962.853000000003,27356.740999999998,30774.994530201344,33037.838000000003,34243.890999999996]
[null,"Camiri","MWh",26931.019,29769.716000000004,31023.121999999992,32518.518999999997,33217.416593452006]
[null,"German Busch","MWh",57328.465000000004,60886.547999999995,60284.14,55369.352999999996,57411.820999999996]
[null,"Bermejo","MWh",17625.435000000001,24367.993999999999,25069.998,27032.792000000005,28138.757000000001]
[null,"Chiquitos","MWh",16495.100058046999,18492.52734375,19606.297000000006,21045.854060999998,22087.9751005]
[null,"Huacaraje","MWh",null,null,190,679.30499999999995,680.3341416666666]
[null,"Bella Vista","MWh",null,null,200,833.62900000000002,901.40105729503864]
[null,"El Sena"]
[null,"El Sena Planta Solar","MWh",{"$nulls":4},95.87]
[null,"El Sena Combustioble Fosil","MWh",646.00490000000002,1248.1833999999999,1677.7593999999997,1881.0661,2213.192]
[]
[]
[null,null,null,"Energia Vendida (MWh)"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija","MWh",42283.498689999993,48572.567869999999,51457.801999999996,52482.941159999995,55108.400999999998]
[null,"Riberalta","MWh",35106.71,39792.533000000003,42339.169999999991,43252.69,47213.729999999996]
[null,"San Ignacio de Velasco","MWh",17541.050999999999,19341.800999999999,20551.661,21797.431,22765.301999999996]
[null,"Las Misiones","MWh",37833.118999999999,41946.923999999992,46627.072999999997,48820.517,52336.572]
[null,"Valles Cruceños","MWh",21245.180999999997,23113.885000000002,25842.941999999999,27838.267,28619.399999999998]
[null,"Camiri","MWh",23118.461000000003,25565.341000000004,26937.044999999998,27085.858999999997,26869.606]
[null,"German Busch","MWh",49864.024999999994,55849.830000000009,55786.36,50334.797000000006,52818.988000000005]
[null,"Bermejo","MWh",19097.196999999996,19975.205000000002,20153.143000000004,21583.880999999998,22919.561000000002]
[null,"Chiquitos","MWh",13815.352999999999,15456.422000000002,16493.128000000001,17568.087,18401.253000000001]
[null,"Huacaraje","MWh",null,null,null,575.524,596.26700000000005]
[null,"Bella Vista","MWh",null,null,null,697.50399999999991,714.51700000000005]
[null,"El Sena","MWh",327.1148,869.54600000000005,1342.3541000000002,1672.1505999999999,2105.6350000000002]
[]
[]
[null,null,null,"Cantidad usuarios"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija",null,13895,14516,15424,15589,17092]
[null,"Riberalta",null,17883,19044,19779,20120,21407]
[null,"San Ignacio de Velasco",null,8812,9304,10720,11519,12184]
[null,"Las Misiones",null,18188,20295,22711,25616,28263]
[null,"Valles Cruceños",null,18160,20322,21825,22984,23104]
[null,"Camiri",null,11277,11944,13230,14167,14957]
[null,"German Busch",null,8646,9004,9991,10406,10771]
[null,"Bermejo",null,10731,11261,11717,12254,12941]
[null,"Chiquitos",null,6760,7040,7747,8138,8470]
[null,"Huacaraje",null,null,null,406,490,505]
[null,"Bella Vista",{"$nulls":4},86.367508667657248,84.819207027540358]
[null,"El Sena",null,238,447,647,883,976]
[]
[]
[null,null,null,"Consumo Combustible Fosil"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija","Litros",13406.099,14382.120999999999,14611.594999999999,14853.701024046875,15908.519]
[null,"Riberalta","Litros",11267.231,15214.2,14037.7,14174.208000000001,15701.602999999999]
[null,"San Ignacio de Velasco","Litros",5569.6610000000001,6107.5820000000003,6427.6,6754.0240000000003,7250.9849999999997]
[null,"Las Misiones"]
[null,"Las Misiones Gas Natural","mpc",571963.42796784278,612920.54899999988,663158.38600000006,620081.93500000006,640147.59325666993]
[null,"Las Misiones Diesel","Litros",116.316,412.529,579.41200000000003,3507.2780006708795,3617.36598]
[null,"Valles Cruceños"]
[null,"Valles Gas Natural","mpc",284155.40100000001,313266.45,353773.35000000003,355513.28460000001,360015.70659999992]
[null,"Valles Diesel","Litros",0,0,30.18,1.38,5.15]
[null,"Camiri"]
[null,"Camiri Gas Natural","mpc",294214.14029697224,320543.55092341761,324808.4192879374,317579.27174145909,339259.18577000004]
[null,"Camiri Diesel","Litros",0,26.829000000000001,13.922000000000001,0,0]
[null,"German Busch","mpc",744218.66700000002,784928.69000000018,795439.49199999997,748755.08600000001,787872.44400000002]
[null,"Bermejo","mpc",0,282967.19999999995,292904.17000000004,368663.22899999999,401645.36199999996]
[null,"Chiquitos","mpc",178080.859,202608.06300730753,217565.0922305714,229197.23259043324,238334.33656033641]
[null,"Huacaraje","Litros",null,null,null,284.65100000000001,212.65]
[null,"Bella Vista","Litros",null,null,null,337.15899999999999,263.79599999999999]
[null,"El Sena","Litros",207.08499999899999,380.24799999999999,518.60700099999997,584.76199999999994,697.83399999999995]
[]
[]
[null,null,null,"Demanda Maxima"]
[null,"Sistema",null,2014,2015,2016,2017,2018]
[null,"Cobija","MW",null,null,11.57,11.45,12.36]
[null,"Riberalta","MW",null,null,8.9220000000000006,9.1549999999999994,9.8239999999999998]
[null,"San Ignacio de Velasco","MW",null,null,4.5794499999999996,4.6655860000000002,5.0506779999999996]
[null,"Las Misiones","MW",null,null,10.15507,11.0601664072266,11.7398552093505]
[null,"Valles Cruceños","MW",null,null,6.2857200000000004,6.4432310000000008,6.3408040000000003]
[null,"Camiri","MW",null,null,6.0750000000000002,6.03993,6.3780000000000001]
[null,"German Busch","MW",null,null,10.94204,9.6973780000000005,10.25271]
[null,"Bermejo","MW",null,null,5.91,5.96,6.1]
[null,"Chiquitos","MW",null,null,4.0962399999999999,4.5239889999999994,4.3802180000000002]
[null,"Huacaraje","MW",null,null,null,0.16900000000000001,0.159]
[null,"Bella Vista","MW",null,null,null,0.19500000000000001,0.20200000000000001]
[null,"El Sena","MW",null,null,0.43099999999999999,0.44500000000000001,0.67300000000000004]

{"sheet":"Cobija","index":2,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Pando"]
[null,"Provincia","Nicolas Suarez"]
[null,"Sistema Eléctrico","Cobija"]
[null,"Empresa","ENDE"]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"SUM(F20:H20)/SUM(F19:H19)","v":0.26606625750993845}]
[null,"Energía Alternativa","Solar"]
[null,"Potencia Instalada MW",5.0999999999999996]
[null,"Potencia a Temp. Media (MW)",5.0999999999999996]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"((H17/D17)^(1/4))-1","v":4.974914610377823E-2}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(D21:H21)/SUM(D17:H17)","v":0.83270384196113723}]
[]
[null,null,"Unidades",2014,{"$f":"+D16+1","v":2015},{"$f":"+E16+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D18+D19","v":52004.804699999993},{"$f":"+E18+E19","v":60848.556793090902},61362.612889999989,62745.201599999993,63151.7791,{"$f":"H17*(1+$C$13)","v":66293.526185159426},{"$f":"I17*(1+$C$13)","v":69591.572505079574},73053.693813226448,76688.052700161323,80503.217838355893,84508.184184420548,88712.394186376288]
[null,"Generación Energía Renovable","MWh",{"$f":"+Datos!D37","v":0},{"$f":"+Datos!E37","v":4794.3755010909099},{"$f":"+Datos!F37","v":5627.8183999999992},{"$f":"+Datos!G37","v":5776.1255999999994},{"$f":"+Datos!H37","v":5319.8761000000022},{"$f":"AVERAGE(F18:H18)","v":5574.6067000000003},{"$f":"AVERAGE(G18:I18)","v":5556.869466666667},5483.7840888888895,5538.4200851851856,5526.3578802469137,5516.1873514403296,5526.9884389574763]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D38","v":52004.804699999993},{"$f":"+Datos!E38","v":56054.181291999994},{"$f":"+Datos!F38","v":55734.794489999993},{"$f":"+Datos!G38","v":56969.075999999994},{"$f":"+Datos!H38","v":57831.902999999998},{"$f":"+I17-I18","v":60718.919485159422},{"$f":"+J17-J18","v":64034.703038412903},67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D88","v":13406.099},{"$f":"+Datos!E88","v":14382.120999999999},{"$f":"+Datos!F88","v":14611.594999999999},{"$f":"+Datos!G88","v":14853.701024046875},{"$f":"+Datos!H88","v":15908.519},{"$f":"I19*$C$9","v":16155.255667463647},{"$f":"J19*$C$9","v":17037.473788190804},17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D56","v":42283.498689999993},{"$f":"+Datos!E56","v":48572.567869999999},{"$f":"+Datos!F56","v":51457.801999999996},{"$f":"+Datos!G56","v":52482.941159999995},{"$f":"+Datos!H56","v":55108.400999999998},{"$f":"+I17*$C$14","v":55202.873951533504},{"$f":"+J17*$C$14","v":57949.1697930968},60832.091507726225,63858.436115942495,67035.338784233303,70370.289647526399,73871.151468566386]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D72","v":13895},{"$f":"+Datos!E72","v":14516},{"$f":"+Datos!F72","v":15424},{"$f":"+Datos!G72","v":15589},{"$f":"+Datos!H72","v":17092}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D21*1000/D22)/12","v":253.58941279836867},{"$f":"(E21*1000/E22)/12","v":278.84499787590704},{"$f":"(F21*1000/F22)/12","v":278.01803466459194},{"$f":"(G21*1000/G22)/12","v":280.55541920585023},{"$f":"(H21*1000/H22)/12","v":268.68515972384745}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D110","v":0},{"$f":"+Datos!E110","v":0},{"$f":"+Datos!F110","v":11.57},{"$f":"+Datos!G110","v":11.45},{"$f":"+Datos!H110","v":12.36}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D4","v":20.61},{"$f":"+Datos!E4","v":25},{"$f":"+Datos!F4","v":25},{"$f":"+Datos!G4","v":24.16},{"$f":"+Datos!H4","v":22.560000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D20","v":15.96},{"$f":"+Datos!E20","v":19.260000000000002},{"$f":"+Datos!F20","v":19.66},{"$f":"+Datos!G20","v":19.2},{"$f":"+Datos!H20","v":19.500000000000004}]
[null,"Factor de Planta (****)",null,{"$f":"D19/(D26*8760)","v":0.37196876823909081},{"$f":"E19/(E26*8760)","v":0.33223671562421464},{"$f":"F19/(F26*8760)","v":0.32362255657826888},{"$f":"G19/(G26*8760)","v":0.33871454052511413},{"$f":"H19/(H26*8760)","v":0.3385546364594309}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Riberalta","index":3,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[null,"Departamento","Beni"]
[null,"Provincia","Vaca Diez"]
[null,"Sistema Eléctrico","Riberalta"]
[null,"Empresa","CER Ltda."]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[]
[null,null,"Unidades",2014,{"$f":"+D12+1","v":2015},{"$f":"+E12+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D39","v":39754.100399999988},{"$f":"+Datos!E39","v":44000},{"$f":"+Datos!F39","v":47860},{"$f":"+Datos!G39","v":49359.07},{"$f":"+Datos!H39","v":54122.220000000008}]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D89","v":11267.231},{"$f":"+Datos!E89","v":15214.2},{"$f":"+Datos!F89","v":14037.7},{"$f":"+Datos!G89","v":14174.208000000001},{"$f":"+Datos!H89","v":15701.602999999999}]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D57","v":35106.71},{"$f":"+Datos!E57","v":39792.533000000003},{"$f":"+Datos!F57","v":42339.169999999991},{"$f":"+Datos!G57","v":43252.69},{"$f":"+Datos!H57","v":47213.729999999996}]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D73","v":17883},{"$f":"+Datos!E73","v":19044},{"$f":"+Datos!F73","v":19779},{"$f":"+Datos!G73","v":20120},{"$f":"+Datos!H73","v":21407}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D111","v":0},{"$f":"+Datos!E111","v":0},{"$f":"+Datos!F111","v":8.9220000000000006},{"$f":"+Datos!G111","v":9.1549999999999994},{"$f":"+Datos!H111","v":9.8239999999999998}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D5","v":10.079999999999998},{"$f":"+Datos!E5","v":10.08},{"$f":"+Datos!F5","v":15.75},{"$f":"+Datos!G5","v":16.05},{"$f":"+Datos!H5","v":16.120000000000005}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D21","v":9.2700000000000014},{"$f":"+Datos!E21","v":9.27},{"$f":"+Datos!F21","v":15.26},{"$f":"+Datos!G21","v":15.709999999999992},{"$f":"+Datos!H21","v":15.779999999999992}]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"San Ingacio Velasco","index":4,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Jose Miguel de Velasco"]
[null,"Sistema Eléctrico","San Ignacio de Velasco"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[]
[null,null,"Unidades",2014,{"$f":"+D12+1","v":2015},{"$f":"+E12+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fosil","Miles de litros"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Las Misiones","index":5,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Guarayos"]
[null,"Sistema Eléctrico","Las Misiones"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas/Diesel"]
[null,"Consumo especifico (pc/kWh) (*)",{"$f":"SUM(F20:H20)/SUM(F18:H18)","v":13.231302586681062}]
[null,"Consumo especifico (lts/kWh) (*)",0.27718065536918751]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"((H15/D15)^(1/4))-1","v":6.2553416093206415E-2}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(D22:H22)/SUM(D15:H15)","v":0.84237616434307439}]
[null,"Factor  Ʃ(Generacion Total - Bruta)/Ʃ(Generación Diesel)",{"$f":"SUM(F19:H19)/SUM(F15:H15)","v":0.16051175725136119}]
[]
[null,null,"Unidades",2014,{"$f":"+D14+1","v":2015},{"$f":"+E14+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D16+D17","v":45834.749141093853},{"$f":"+E16+E17","v":51150.008000000002},55241.41,59494.525999999991,58424.895768660623,{"$f":"H15*(1+$C$10)","v":62079.572583879868},{"$f":"I15*(1+$C$10)","v":65962.861918607712},70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D41","v":45834.749141093853},{"$f":"+Datos!E41","v":51150.008000000002},{"$f":"+Datos!F41","v":55241.41},{"$f":"+Datos!G41","v":59494.525999999991},{"$f":"+Datos!H41","v":58424.895768660623},{"$f":"+I15-I16","v":62079.572583879868},{"$f":"+J15-J16","v":65962.861918607712},70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Fósil Gas","MWh",{"$f":"+D17-D19","v":45415.109466582391},{"$f":"+E17-E19","v":49661.704281796665},53151.033241101519,46841.12493202358,45374.324201240481,{"$f":"+I17-I19","v":52115.071299027884},{"$f":"+J17-J19","v":55375.047038723096},58838.94539731722,62519.52243124105,66430.332131831019,70585.776338883355,75001.157776471533]
[null,"Generación Fósil Diesel","MWh",{"$f":"D21/$C$9","v":419.63967451146357},{"$f":"E21/$C$9","v":1488.3037182033388},2090.3767588984847,12653.401067976414,13050.571567420144,{"$f":"+I15*$C$12","v":9964.5012848519818},{"$f":"+J15*$C$12","v":10587.814879884618},11250.118869583883,11953.852236330997,12701.606529186914,13496.135407459331,14340.36478125239]
[null,"Combustible Fósil gas natural","MPC",{"$f":"+Datos!D92","v":571963.42796784278},{"$f":"+Datos!E92","v":612920.54899999988},{"$f":"+Datos!F92","v":663158.38600000006},{"$f":"+Datos!G92","v":620081.93500000006},{"$f":"+Datos!H92","v":640147.59325666993},{"$f":"+I18*$C$8","v":689550.27768389566},{"$f":"+J18*$C$8","v":732684.00312104239},778515.89043310913,827214.7188625444,878959.82536997786,933941.76505555829,992363.01289190224]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+Datos!D93","v":116.316},{"$f":"+Datos!E93","v":412.529},{"$f":"+Datos!F93","v":579.41200000000003},{"$f":"+Datos!G93","v":3507.2780006708795},{"$f":"+Datos!H93","v":3617.36598},{"$f":"+I19*$C$9","v":2761.9669965623834},{"$f":"+J19*$C$9","v":2934.7374673340537},3118.3153212525235,3313.3765970526533,3520.6396220015799,3740.8676571908741,3974.8717083007527]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D59","v":37833.118999999999},{"$f":"+Datos!E59","v":41946.923999999992},{"$f":"+Datos!F59","v":46627.072999999997},{"$f":"+Datos!G59","v":48820.517},{"$f":"+Datos!H59","v":52336.572},{"$f":"I15*$C$11","v":52294.352237266205},{"$f":"J15*$C$11","v":55565.542612088611},59041.357119547385,62734.595698154022,66658.858966299726,70828.598307517037,75259.169088745737]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D75","v":18188},{"$f":"+Datos!E75","v":20295},{"$f":"+Datos!F75","v":22711},{"$f":"+Datos!G75","v":25616},{"$f":"+Datos!H75","v":28263}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D22*1000/D23)/12","v":173.3428588446595},{"$f":"(E22*1000/E23)/12","v":172.2383345651638},{"$f":"(F22*1000/F23)/12","v":171.08843365182804},{"$f":"(G22*1000/G23)/12","v":158.82169021965439},{"$f":"(H22*1000/H23)/12","v":154.31415631744684}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D113","v":0},{"$f":"+Datos!E113","v":0},{"$f":"+Datos!F113","v":10.15507},{"$f":"+Datos!G113","v":11.0601664072266},{"$f":"+Datos!H113","v":11.7398552093505}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D7","v":17.149999999999999},{"$f":"+Datos!E7","v":17.149999999999999},{"$f":"+Datos!F7","v":21.349999999999994},{"$f":"+Datos!G7","v":21.349999999999994},{"$f":"+Datos!H7","v":21.349999999999994}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D23","v":14.999999999999998},{"$f":"+Datos!E23","v":15},{"$f":"+Datos!F23","v":19.05},{"$f":"+Datos!G23","v":19.05},{"$f":"+Datos!H23","v":19.05}]
[null,"Factor de Planta (****)",null,{"$f":"D17/(D27*8760)","v":0.34881848661410852},{"$f":"E17/(E27*8760)","v":0.38926946727549466},{"$f":"F17/(F27*8760)","v":0.33102871558863362},{"$f":"G17/(G27*8760)","v":0.35651509485971783},{"$f":"H17/(H27*8760)","v":0.3501054409128862}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Valles","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Vallegrande"]
[null,"Sistema Eléctrico","Valles Cruceños"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas"]
[null,"Consumo especifico (pc/kWh) (*)"]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[null,"Factor  Ʃ(Generacion Total - Bruta)/Ʃ(Generación Diesel)"]
[]
[null,null,"Unidades",2014,{"$f":"+D15+1","v":2015},{"$f":"+E15+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Generación Fósil Gas","MWh"]
[null,"Generación Fósil Diesel","MWh"]
[null,"Combustible Fósil gas natural","MPC"]
[null,"Combustible Fósil Diesel","Miles de Litros"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Camiri","index":7,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Cordillera"]
[null,"Sistema Eléctrico","Camiri"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas"]
[null,"Consumo especifico (pc/kWh) (*)"]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[null,"Factor  Ʃ(Generacion Total - Bruta)/Ʃ(Generación Diesel)"]
[]
[null,null,"Unidades",2014,{"$f":"+D15+1","v":2015},{"$f":"+E15+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fosil gas natural","MPC"]
[null,"Combustible Fosil Diesel","Miles de Litros"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"German Busch","index":8,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","German Bush"]
[null,"Sistema Eléctrico","German Busch"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas"]
[null,"Consumo especifico (pc/kWh) (*)",{"$f":"SUM(F17:H17)/SUM(F16:H16)","v":13.475068851751542}]
[null,"% Crecimiento Acumulativo Anual  (**)",5.5E-2]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(F18:H18)/SUM(F14:H14)","v":0.91838243797367758}]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D15+D16","v":57328.465000000004},{"$f":"+E15+E16","v":60886.547999999995},60284.14,55369.352999999996,57411.820999999996,{"$f":"(H14*(1+$C$10))","v":60569.471154999992},{"$f":"(I14*(1+$C$10))","v":63900.792068524985},67415.335632293849,71123.17909207,75034.953942133841,79161.876408951197,83515.779611443504]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D44","v":57328.465000000004},{"$f":"+Datos!E44","v":60886.547999999995},{"$f":"+Datos!F44","v":60284.14},{"$f":"+Datos!G44","v":55369.352999999996},{"$f":"+Datos!H44","v":57411.820999999996},{"$f":"+I14-I15","v":60569.471154999992},{"$f":"+J14-J15","v":63900.792068524985},67415.335632293849,71123.17909207,75034.953942133841,79161.876408951197,83515.779611443504]
[null,"Combustible Fósil gas natural","MPC",{"$f":"+Datos!D100","v":744218.66700000002},{"$f":"+Datos!E100","v":784928.69000000018},{"$f":"+Datos!F100","v":795439.49199999997},{"$f":"+Datos!G100","v":748755.08600000001},{"$f":"+Datos!H100","v":787872.44400000002},{"$f":"+I16*$C$11","v":55625.938586105236},{"$f":"+J16*$C$11","v":58685.365208341012},61913.060294799761,65318.278611013739,68910.783934619481,72700.877051023548,76699.425288829836]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D62","v":49864.024999999994},{"$f":"+Datos!E62","v":55849.830000000009},{"$f":"+Datos!F62","v":55786.36},{"$f":"+Datos!G62","v":50334.797000000006},{"$f":"+Datos!H62","v":52818.988000000005},{"$f":"I16*$C$11","v":55625.938586105236},{"$f":"J16*$C$11","v":58685.365208341012},61913.060294799761,65318.278611013739,68910.783934619481,72700.877051023548,76699.425288829836]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D78","v":8646},{"$f":"+Datos!E78","v":9004},{"$f":"+Datos!F78","v":9991},{"$f":"+Datos!G78","v":10406},{"$f":"+Datos!H78","v":10771}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D18*1000/D19)/12","v":480.60784370421766},{"$f":"(E18*1000/E19)/12","v":516.89832296757004},{"$f":"(F18*1000/F19)/12","v":465.30510793047074},{"$f":"(G18*1000/G19)/12","v":403.09114132872065},{"$f":"(H18*1000/H19)/12","v":408.65122396558667}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D116","v":0},{"$f":"+Datos!E116","v":0},{"$f":"+Datos!F116","v":10.94204},{"$f":"+Datos!G116","v":9.6973780000000005},{"$f":"+Datos!H116","v":10.25271}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D10","v":20.999999999999996},{"$f":"+Datos!E10","v":20.999999999999996},{"$f":"+Datos!F10","v":20.999999999999996},{"$f":"+Datos!G10","v":20.999999999999996},{"$f":"+Datos!H10","v":23.199999999999996}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D26","v":17.399999999999999},{"$f":"+Datos!E26","v":17.399999999999999},{"$f":"+Datos!F26","v":17.399999999999999},{"$f":"+Datos!G26","v":17.399999999999999},{"$f":"+Datos!H26","v":19.099999999999998}]
[null,"Factor de Planta (****)",null,{"$f":"D14/(D23*8760)","v":0.37611179997900596},0.39945512517713744,0.39550293916968454,0.36325875846323413,{"$f":"H14/(H23*8760)","v":0.34313407564130155}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Bermejo","index":9,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Tarija"]
[null,"Provincia","Aniceto Arce"]
[null,"Sistema Eléctrico","Bermejo"]
[null,"Empresa","SETAR"]
[null,"Combustible","Gas"]
[null,"Consumo especifico (pc/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fósil","MPC"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Chiquitos","index":10,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Chiquitos"]
[null,"Sistema Eléctrico","Roboré y Santiago de Chiquitos"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas"]
[null,"Consumo especifico (pc/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fósil","MPC"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Huacaraje","index":11,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Beni"]
[null,"Provincia","Itenez"]
[null,"Sistema Eléctrico","Huacaraje"]
[null,"Empresa","ENDE DELBENI S.A.M."]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"SUM(G17:H17)/SUM(G16:H16)","v":0.36575954954518364}]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"H14/G14-1","v":1.5149920384314175E-3},"Se debe tomar una decisión"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(G18:H18)/SUM(G14:H14)","v":0.86183970738265214}]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D15+D16","v":0},{"$f":"+E15+E16","v":0},190,679.30499999999995,680.3341416666666,{"$f":"+H14*(1+$C$10)","v":681.36484247476471},{"$f":"+I14*(1+$C$10)","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D47","v":0},{"$f":"+Datos!E47","v":0},{"$f":"+Datos!F47","v":190},{"$f":"+Datos!G47","v":679.30499999999995},{"$f":"+Datos!H47","v":680.3341416666666},{"$f":"+I14-I15","v":681.36484247476471},{"$f":"+J14-J15","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D103","v":0},{"$f":"+Datos!E103","v":0},{"$f":"+Datos!F103","v":0},{"$f":"+Datos!G103","v":284.65100000000001},{"$f":"+Datos!H103","v":212.65},{"$f":"+I16*$C$9","v":249.21569785949495},{"$f":"+J16*$C$9","v":249.59325765760423},249.97138945580164,250.35009412066285,250.7293725200762,251.10922552324502,251.48965400068943]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D65","v":0},{"$f":"+Datos!E65","v":0},{"$f":"+Datos!F65","v":0},{"$f":"+Datos!G65","v":575.524},{"$f":"+Datos!H65","v":596.26700000000005},{"$f":"I16*$C$11","v":587.22727645927807},{"$f":"J16*$C$11","v":588.11692110786373},589.00791356100888,589.90025586062688,590.79395005172444,591.68899818240629,592.58540230388007]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D81","v":0},{"$f":"+Datos!E81","v":0},{"$f":"+Datos!F81","v":406},{"$f":"+Datos!G81","v":490},{"$f":"+Datos!H81","v":505}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",null,null,{"$f":"(F18*1000/F19)/12","v":0},{"$f":"(G18*1000/G19)/12","v":97.878231292517},{"$f":"(H18*1000/H19)/12","v":98.393894389438955}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D119","v":0},{"$f":"+Datos!E119","v":0},{"$f":"+Datos!F119","v":0},{"$f":"+Datos!G119","v":0.16900000000000001},{"$f":"+Datos!H119","v":0.159}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D13","v":0},{"$f":"+Datos!E13","v":0},{"$f":"+Datos!F13","v":0.56999999999999995},{"$f":"+Datos!G13","v":0.69499999999999995},{"$f":"+Datos!H13","v":0.46400000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D29","v":0},{"$f":"+Datos!E29","v":0},{"$f":"+Datos!F29","v":0.13},{"$f":"+Datos!G29","v":0.64800000000000002},{"$f":"+Datos!H29","v":0.39800000000000002}]
[null,"Factor de Planta (****)",null,null,null,{"$f":"F16/(F23*8760)","v":0.16684229012996138},{"$f":"G16/(G23*8760)","v":0.11967011246406221},{"$f":"H16/(H23*8760)","v":0.19513496181439921}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"Bella Vista","index":12,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Beni"]
[null,"Provincia","Itenez"]
[null,"Sistema Eléctrico","Bella Vista"]
[null,"Empresa","ENDE DELBENI S.A.M."]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)"]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fósil","Miles de Litros"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]

{"sheet":"El Sena","index":13,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,18,2,22],[7,18,7,19]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[{"$nulls":18},"IPPC - DATA"]
[null,"Departamento","Pando",{"$nulls":15},"EFCO2,GAS",5.4300000000000001E-2,"tCO2/GJ","kgCO2/MJ","Source for Gas EF - IPCC 2006 (Lower value)"]
[null,"Provincia","Madre de Dios",null,null,"Generacion Solar Octubre (kWh)",18719.23,{"$nulls":11},"EFCO2,DIESEL",7.2599999999999998E-2,"tCO2/GJ","kgCO2/MJ","Source for Diesel EF - IPCC 2006 (Lower value)"]
[null,"Sistema Eléctrico","El Sena",null,null,"Generacion Solar Noviembre (kWh)",15162.550000000003,{"$nulls":13},"Value","Units"]
[null,"Empresa","ENDE",null,null,null,{"$f":"AVERAGE(G5:G6)","v":16940.89},{"$f":"+G7/(C11*1000*8760)","v":4.8347288812785388E-3},{"$nulls":12},1.05506E-3,"MJ/Btu"]
[null,"Combustible","Diesel",{"$nulls":15},"Conversion factors",null,1.05506E-6,"GJ/Btu"]
[null,"Energía Alternativa","Solar"]
[null,"Potencia Instalada MW",0.4]
[null,"Potencia a Temp. Media (MW)",{"$f":"+C10","v":0.4}]
[null,"Consumo especifico (lts/kWh) (*)"]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$nulls":16},"Emission Factors"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$nulls":17},"CO2 Emissions Factor Natural Gas",{"$f":"T4*1000000","v":54300},"gCO2/GJ"]
[{"$nulls":19},"CO2 Emissions Factor Natural Gas (g/BTU)",{"$f":"U14*U8","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,null,"Unidades",2014,{"$f":"+D16+1","v":2015},{"$f":"+E16+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh"]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh"]
[null,"Combustible Fósil","Miles de Litros"]
[null,"Energía Vendida","MWh"]
[null,"Cantidad de Usuarios"]
[null,"Consumo  por usuario (***)","kWh/usuario-mes"]
[null,"Demanda Máxima","MW"]
[null,"Potencia Instalada","MW"]
[null,"Pot. Efectiva a Temp. Media","MW"]
[null,"Factor de Planta (****)"]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]