{"text_format":"2","workbook":"xlsx","n_sheets":16,"sheets":["Cobija","Riberalta","San Ingacio Velasco","Las Misiones","Valles","Camiri","German Busch","Bermejo","Chiquitos","Huacaraje","Rosario del Yata","El Sena","DESCRIPCION 6","CAP VI-1","Generacion Bruta","Hoja1"],"not_rendered":{"charts":18,"images":13,"macros":0,"external_links":13,"defined_names":1420,"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":"Cobija","index":0,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[3,5,3,9],[16,5,16,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS POREVISTOS"]
[null,null,1,"S1"]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Pando"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Nicolas Suarez"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Cobija"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"ENDE"}]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"}]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":28.199999999999996}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":22.560000000000002}]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":19.500000000000004}]
[null,"Consumo especifico (lts/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":0.26606625750993845}]
[8,"Energía Alternativa",null,"Solar"]
[11,"Potencia Instalada MVA",null,{"$f":"VLOOKUP($D$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A14,0)","v":5.0999999999999996}]
[16,"Potencia Instalada MW",null,{"$f":"VLOOKUP($D$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A15,0)","v":5.0999999999999996}]
[22,"Potencia a Temp. Media",null,0]
[null,"Categoría","Gran Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable","AM00045",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H23/D23)^(1/4)-1","v":4.974914610377823E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(D27:H27)/SUM(D25:H25)","v":0.89702050097660357}]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":52004.804699999993},{"$f":"+E24+E25","v":60848.556793090902},61362.612889999989,62745.201599999993,63151.7791,{"$f":"H23*(1+$C$19)","v":66293.526185159426},{"$f":"I23*(1+$C$19)","v":69591.572505079574},73053.693813226448,76688.052700161323,80503.217838355893,84508.184184420548,{"$f":"N23*(1+$C$19)","v":88712.394186376288}]
[null,"Generación Energía Renovable","MWh",0,4794.3755010909099,5627.8183999999992,5776.1255999999994,5319.8761000000022,{"$f":"AVERAGE(F24:H24)","v":5574.6067000000003},{"$f":"AVERAGE(G24:I24)","v":5556.869466666667},5483.7840888888895,5538.4200851851856,5526.3578802469137,5516.1873514403296,5526.9884389574763]
[null,"Generación","MWh",52004.804699999993,56054.181291999994,55734.794489999993,56969.075999999994,57831.902999999998,{"$f":"+I23-I24","v":60718.919485159422},{"$f":"+J23-J24","v":64034.703038412903},67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"Combustible Fósil","Miles de Litros",13406.099,14382.120999999999,14611.594999999999,14853.701024046875,15908.519,{"$f":"+I25*$C$12","v":16155.255667463647},{"$f":"+J25*$C$12","v":17037.473788190804},17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"Energía Vendida","MWh",42283.498689999993,48572.567869999999,51457.801999999996,52482.941159999995,55108.400999999998,{"$f":"I23*$C$20","v":59466.652070117292},{"$f":"J23*$C$20","v":62425.067232256108},65530.661022531793,68790.755452018886,72213.036795590655,75805.57371373201,79576.836275897193]
[null,"Cantidad de Usuarios",null,13895,14516,15424,15589,17092]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":253.58941279836867},{"$f":"(E27*1000/E28)/12","v":278.84499787590704},{"$f":"(F27*1000/F28)/12","v":278.01803466459194},{"$f":"(G27*1000/G28)/12","v":280.55541920585023},{"$f":"(H27*1000/H28)/12","v":268.68515972384745}]
[null,"Demanda Máxima","MW",null,null,11.57,11.45,12.36]
[null,"Potencia Instalada","MW",20.61,25,25,24.16,{"$f":"+C10","v":22.560000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",15.96,19.260000000000002,19.66,19.2,{"$f":"+C11","v":19.500000000000004}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.37196876823909081},{"$f":"E25/(E32*8760)","v":0.33223671562421464},{"$f":"F25/(F32*8760)","v":0.32362255657826888},{"$f":"G25/(G32*8760)","v":0.33871454052511413},{"$f":"H25/(H32*8760)","v":0.3385546364594309}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"COEF  i,j =",{"$f":"+G19","v":7.6597356000000005E-2},{"$f":"+H18","v":"gCO2/BTU"},"Diesel "]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",{"$f":"+D23","v":52004.804699999993},{"$f":"+E23","v":60848.556793090902},61362.612889999989,62745.201599999993,63151.7791,66293.526185159426,69591.572505079574,73053.693813226448,76688.052700161323,80503.217838355893,84508.184184420548,88712.394186376288]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":52004.804699999993},{"$f":"+E25","v":56054.181291999994},55734.794489999993,56969.075999999994,57831.902999999998,60718.919485159422,{"$f":"+J25","v":64034.703038412903},67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,{"$f":"+O25","v":83185.405747418816}]
[null,"F  i,j,bl =","MMBTU",{"$f":"+D26*33710/1000","v":451919.59729000001},{"$f":"+E26*33710/1000","v":484821.29890999995},{"$f":"+F26*33710/1000","v":492556.86744999996},{"$f":"+G26*33710/1000","v":500718.26152062014},{"$f":"+H26*33710/1000","v":536276.17549000005},{"$f":"I26*33710/1000","v":544593.66855019948},{"$f":"J26*33710/1000","v":574333.24139991205},606040.84085153695,638147.71030731639,672474.47034924652,708486.60855852009,746097.68536635744]
[null,"EF bl,ini =","tCO2/MWh",null,null,{"$f":"SUM(D45:F45)*$C$40/SUM(D44:F44)","v":0.66840407071704533},{"$f":"SUM(E45:G45)*$C$40/SUM(E44:G44)","v":0.67089111952391145},{"$f":"SUM(F45:H45)*$C$40/SUM(F44:H44)","v":0.68700885093123643},{"$f":"+H46","v":0.68700885093123643},0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643]
[null,"BE y =","tCO2/año",{"$f":"+F46*D44","v":34760.22315832493},{"$f":"+F46*E44","v":37466.842956284047},{"$f":"+F46*F44","v":37253.363517693942},{"$f":"+G46*G44","v":38220.047175882792},39731.029227196726,41714.435105285636,43992.407754143002,46421.126037244525,48880.42734699438,51509.766406252682,54268.20097698961,57149.11001678287]
[null,"EF bl =","tCO2/MWh",{"$f":"+D47/D43","v":0.66840407071704544},{"$f":"+E47/E43","v":0.61573922095944023},0.60710197566839541,0.60913099649492231,0.62913554920255166,{"$f":"+I47/I43","v":0.62923844160553788},0.63215136791070414,0.63543845101012442,0.63739299181463704,0.63984729790156003,0.64216503408192016,0.64420660203035485]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":20.61},25,25,24.16,22.560000000000002,{"$f":"+H51","v":22.560000000000002},{"$f":"($H$51/$H$52)*J52","v":24.979688123812821},{"$f":"+J51","v":24.979688123812821},{"$f":"($H$51/$H$52)*L52","v":27.755194426056875},{"$f":"+L51","v":27.755194426056875},{"$f":"($H$51/$H$52)*N52","v":30.81447014724786},{"$f":"+N51","v":30.81447014724786}]
[null,"Pot. Efectiva a Temp. Media","MW",15.96,19.260000000000002,19.66,19.2,19.500000000000004,{"$f":"I25/(I53*8760)","v":20.4734561468712},{"$f":"J44/(J53*8760)","v":21.591485745316938},22.783501342236356,23.990527096990654,25.281007425661326,26.634847866637116,28.048798810488172]
[null,"Factor de Planta",null,0.37196876823909081,0.33223671562421464,0.32362255657826888,0.33871454052511413,0.3385546364594309,{"$f":"+H53","v":0.3385546364594309},0.3385546364594309,0.3385546364594309,0.3385546364594309,0.3385546364594309,0.3385546364594309,0.3385546364594309]
[null,"Adiciones de capacidad","MW",{"$nulls":6},{"$f":"+J51-I51","v":2.4196881238128185},0,2.7755063022440538,0,3.0592757211909856,0]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente j (gas natural o diésel), el los últimos tres años previo a la implementación del proyecto"]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente j (planta)"]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado (tCO2e/MWh) al momento de la interconexión a la red"]
[null,"COEF  i,j =","gCO2/BTU","Coefiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año y"]

{"sheet":"Riberalta","index":1,"n_rows":104,"n_cols":15,"rows_kept":104,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[16,5,16,7],[72,1,75,4],[76,1,76,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,5]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Beni"},null,null,"Hibridación/Desplazamiento de energía fósil",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Vaca Diez"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Riberalta"},null,null,"Proyecto:","Planta Solar Riberalta"]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CER Ltda."},null,null,null,"Potencia Instalada MW",5000,"kWp"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"},null,null,null,"Potencia a Temp. Media",{"$f":"+H7*0.95","v":4750},"kWp"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":22.029999999999998},null,null,null,"Mes/Año de puesta en operación","2021-05-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":16.120000000000005},null,null,null,"Factor de Planta",0.13736980593607304]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":15.779999999999992},null,null,null,"Categoría","Pequeña Escala"]
[null,"Consumo especifico (lts/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":0.29016212958142484},null,null,null,"Metodología Aplicable","AMS I.A"]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AM00045",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H25/F25)^(1/2)-1","v":6.3411748380764132E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(D27:H27)/SUM(D25:H25)","v":0.88349172923638908}]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":39754.100399999988},44000,47860,49359.07,54122.220000000008,{"$f":"H23*(1+$C$19)","v":57554.20459644837},{"$f":"I23*(1+$C$19)","v":61203.817336573375},65084.858401462414,69212.003065813609,73600.857189151662,78268.016225838699,83231.127977013151]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",39754.100399999988,44000,{"$f":"(25.31+22.55)*1000","v":47860},49359.07,54122.220000000008,{"$f":"+I24+I23","v":57554.20459644837},{"$f":"+J24+J23","v":61203.817336573375},65084.858401462414,69212.003065813609,73600.857189151662,78268.016225838699,83231.127977013151]
[null,"Combustible Fósil","Miles de Litros",11267.231,15214.2,{"$f":"6544.7+7493","v":14037.7},14174.208000000001,15701.602999999999,{"$f":"+I25*$C$12","v":16700.05057207049},{"$f":"+J25*$C$12","v":17759.02997689266},18885.161117273823,20082.702202172582,21356.18146102257,22710.414266202872,24150.521341274245]
[null,"Energía Vendida","MWh",35106.71,39792.533000000003,42339.169999999991,43252.69,47213.729999999996,{"$f":"I23*$C$20","v":50848.663743741105},{"$f":"J23*$C$20","v":54073.066414557303},57501.934096213554,61148.232272529931,65025.748591324118,69149.144999267985,73534.013182706549]
[null,"Cantidad de Usuarios",null,17883,19044,19779,20120,21407]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":163.59442860071951},{"$f":"(E27*1000/E28)/12","v":174.12541570398375},{"$f":"(F27*1000/F28)/12","v":178.38435546117933},{"$f":"(G27*1000/G28)/12","v":179.14467362491715},{"$f":"(H27*1000/H28)/12","v":183.79396926239076}]
[null,"Demanda Máxima","MW",null,null,8.9220000000000006,9.1549999999999994,9.8239999999999998]
[null,"Potencia Instalada","MW",10.079999999999998,10.08,15.75,16.05,{"$f":"+C10","v":16.120000000000005}]
[null,"Pot. Efectiva a Temp. Media","MW",9.2700000000000014,9.27,15.26,15.709999999999992,{"$f":"+C11","v":15.779999999999992}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.48955116667405513},{"$f":"E25/(E32*8760)","v":0.54183722224685116},{"$f":"F25/(F32*8760)","v":0.35802557795771317},{"$f":"G25/(G32*8760)","v":0.35866308287482329},{"$f":"H25/(H32*8760)","v":0.39152950674514325}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"COEF  i,j =",{"$f":"+G19","v":7.6597356000000005E-2},{"$f":"+H19","v":"gCO2/BTU"},"Diesel"]
[]
[null,null,null,2014,{"$f":"+D42+1","v":2015},{"$f":"+E42+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",{"$f":"+D23","v":39754.100399999988},{"$f":"+E23","v":44000},47860,49359.07,54122.220000000008,57554.20459644837,61203.817336573375,65084.858401462414,69212.003065813609,73600.857189151662,78268.016225838699,83231.127977013151]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":39754.100399999988},44000,47860,49359.07,54122.220000000008,57554.20459644837,61203.817336573375,65084.858401462414,69212.003065813609,73600.857189151662,78268.016225838699,{"$f":"+O25","v":83231.127977013151}]
[null,"F  i,j,bl =","MMBTU",{"$f":"+D26*33710/1000","v":379818.35700999998},{"$f":"+E26*33710/1000","v":512870.68199999997},{"$f":"+F26*33710/1000","v":473210.86700000003},{"$f":"+G26*33710/1000","v":477812.55168000003},{"$f":"+H26*33710/1000","v":529301.03712999995},{"$f":"I26*33710/1000","v":562958.70478449622},{"$f":"J26*33710/1000","v":598656.90052105149},636618.78126330057,676987.89123523771,719916.8770510708,765568.06491369882,814114.07441435475]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"D45*$C$40/D44","v":0.73182594033067527},{"$f":"E45*$C$40/E44","v":0.89283041388901807},{"$f":"SUM(D45:F45)*$C$40/SUM(D44:F44)","v":0.79493246576956067},{"$f":"SUM(E45:G45)*$C$40/SUM(E44:G44)","v":0.79401753301509359},{"$f":"SUM(F45:H45)*$C$40/SUM(F44:H44)","v":0.74922672680525482},{"$f":"+H46","v":0.74922672680525482},0.74922672680525482,0.74922672680525482,0.74922672680525482,0.74922672680525482,0.74922672680525482,0.74922672680525482]
[null,"BE y =","tCO2/año",{"$f":"+F46*D44","v":31601.825055422669},{"$f":"+F46*E44","v":34977.028493860671},{"$f":"+F46*F44","v":38045.467811731171},39191.966993319314,40549.813738033903,43121.148323676964,45855.535731067575,48763.315424711174,51855.482512634793,55143.729321889106,58640.489610425699,62358.985582526831]
[]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":10.079999999999998},10.08,15.75,16.05,16.120000000000005,{"$f":"+H51","v":16.120000000000005},{"$f":"($H$51/$H$52)*J52","v":19.935098609861384},{"$f":"+J51","v":19.935098609861384},{"$f":"($H$51/$H$52)*L52","v":22.543497548780035},{"$f":"+L51","v":22.543497548780035},{"$f":"($H$51/$H$52)*N52","v":25.493191264198373},{"$f":"+N51","v":25.493191264198373}]
[null,"Pot. Efectiva a Temp. Media","MW",9.2700000000000014,9.27,15.26,15.709999999999992,15.779999999999992,{"$f":"I25/(I53*8760)","v":18.350964524483956},{"$f":"J44/(J53*8760)","v":19.514631269454863},20.752088157256928,22.068014349860338,23.467385723076777,24.955493681702855,26.537965167764749]
[null,"Factor de Planta",null,0.48955116667405513,0.54183722224685116,0.35802557795771317,0.35866308287482329,0.39152950674514325,{"$f":"+F53","v":0.35802557795771317},{"$f":"+I53","v":0.35802557795771317},0.35802557795771317,0.35802557795771317,0.35802557795771317,0.35802557795771317,0.35802557795771317]
[null,"Adiciones de capacidad","MW",{"$nulls":8},{"$f":"+L51-K51","v":2.6083989389186506},{"$f":"+M51-L51","v":0},{"$f":"+N51-M51","v":2.9496937154183378},{"$f":"+O51-N51","v":0}]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente j (gas natural o diésel), el los últimos tres años previo a la implementación del proyecto"]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente j (planta)"]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado "]
[null,"COEF  i,j =","gCO2/BTU","Coefiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año y"]
{"$rows_empty":9}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[null,"Opción 2: basada en la generación anual de electricidad por la actividad del proyecto"]
[null,"Calculo de línea base:"]
[{"$nulls":5},"Ecuación 1"]
[]
[{"$nulls":5},"Ecuación 2"]
[null,"Donde:"]
[null,"E BL,y  =","MWh","Línea de Base de Energía, y"]
[null,"EG i,y  =","MWh","Electricidad generada por las actividades del proyecto en el año  y"]
[null,"TDL  =","%","Promedio histórico de perdidas técnicas (Transmisión y distribución)"]
[null,"EF CO2,y =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado "]
[null,"BE CO2, y =","tCO2/año","Línea de Base de Emisiones"]
[]
[null,null,null,{"$f":"+D42","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG  i,y =","MWh",{"$nulls":7},{"$f":"L90/12*8","v":3810.6384166666662},{"$f":"+H8*H10*8760/1000","v":5715.9576249999991},{"$f":"+L90","v":5715.9576249999991},{"$f":"+M90","v":5715.9576249999991},{"$f":"+N90","v":5715.9576249999991}]
[null,"TDL  =","%",{"$nulls":7},{"$f":"1-$C$20","v":0.11650827076361092},{"$f":"1-$C$20","v":0.11650827076361092},0.11650827076361092,0.11650827076361092,0.11650827076361092]
[null,"E BL,y =","MWh",{"$nulls":7},{"$f":"+K90/(1-K91)","v":4313.1568644793542},{"$f":"+L90/(1-L91)","v":6469.7352967190309},{"$f":"+M90/(1-M91)","v":6469.7352967190309},{"$f":"+N90/(1-N91)","v":6469.7352967190309},{"$f":"+O90/(1-O91)","v":6469.7352967190309}]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":7},{"$f":"+H46","v":0.74922672680525482},{"$f":"+K93","v":0.74922672680525482},{"$f":"+L93","v":0.74922672680525482},{"$f":"+M93","v":0.74922672680525482},{"$f":"+N93","v":0.74922672680525482}]
[null,"BE CO2, y =","tCO2/año",{"$nulls":7},{"$f":"+K93*K90","v":2855.032147957525},{"$f":"+L93*L90","v":4282.5482219362875},{"$f":"+M93*M90","v":4282.5482219362875},4282.5482219362875,4282.5482219362875]
[]
[null,null,null,{"$f":"+D89","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Generación total","MWh",{"$f":"+D23","v":39754.100399999988},{"$f":"+E23","v":44000},47860,49359.07,54122.220000000008,57554.20459644837,61203.817336573375,65084.858401462414,69212.003065813609,73600.857189151662,78268.016225838699,83231.127977013151]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D47","v":31601.825055422669},34977.028493860671,38045.467811731171,39191.966993319314,40549.813738033903,43121.148323676964,45855.535731067575,48763.315424711174,51855.482512634793,55143.729321889106,58640.489610425699,62358.985582526831]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D25-D90","v":39754.100399999988},{"$f":"+E25-E90","v":44000},47860,49359.07,54122.220000000008,57554.20459644837,61203.817336573375,61274.219984795745,63496.045440813614,67884.899564151667,72552.058600838704,77515.170352013156]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+D26","v":11267.231},{"$f":"+E26","v":15214.2},14037.7,14174.208000000001,15701.602999999999,{"$f":"+I101*$C$12","v":16700.05057207049},{"$f":"+J101*$C$12","v":17759.02997689266},17779.458159229034,18424.147765105401,19697.627023955385,21051.85982913569,22491.966904207064]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D99-D94","v":31601.825055422669},34977.028493860671,38045.467811731171,39191.966993319314,40549.813738033903,43121.148323676964,45855.535731067575,{"$f":"+K99-K94","v":45908.283276753646},47572.934290698504,50861.181099952817,54357.941388489409,58076.437360590542]
[null,"Factor Emisiones con Proyecto","tCO2/año",{"$f":"+D103/D98","v":0.79493246576956067},{"$f":"+E103/E98","v":0.79493246576956067},0.79493246576956056,0.79401753301509359,0.74922672680525482,0.74922672680525482,0.74922672680525482,0.7053604233657228,0.68735092445542223,0.69104060798152578,0.69451027392392461,0.69777304203578916]

{"sheet":"San Ingacio Velasco","index":2,"n_rows":105,"n_cols":15,"rows_kept":105,"cut":false,"hidden":false,"merged":[[73,1,73,4],[1,1,1,3],[1,5,1,10],[3,5,4,9],[3,10,4,10],[17,5,17,7],[69,1,72,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,19]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"Electrificación mediante la extensión de una red (nacional, regional o mini-red)",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Jose Miguel de Velasco"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"San Ignacio de Velasco"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."},null,null,"Proyecto:","Conexión al SIN San Ignacio"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"},null,null,"Línea:","230 kV (Los Troncos - San Ignacio)"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":9.8000000000000007},null,null,null,"Mes/Año de puesta en operación","2023-11-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":7.84},null,null,null,"Categoría","Gran Escala"]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":6.7919999999999998},null,null,null,"Metodología Aplicable","AM00045"]
[null,"Consumo especifico (lt/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":0.27718065536918751}]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala"]
[null,"Metodología Aplicable Línea de Base","AM00045 (Ver pagina 11 de la metodología)",null,null,"Factores de Emisiones"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H25/D25)^(1/4)-1","v":6.5246497016822946E-2},null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F27:H27)/SUM(F25:H25)","v":0.8833159976235776},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":20118.833000000006},{"$f":"+E24+E25","v":22009.939000000002},23362.835999999999,24446.846999999998,25906.172000000006,{"$f":"H23*(1+$C$19)","v":27596.458974115307},{"$f":"I23*(1+$C$19)","v":29397.031252244797},31315.084564147837,33358.28413574407,35534.795322093225,37853.316239069594,40323.112524138902]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",20118.833000000006,22009.939000000002,23362.835999999999,24446.846999999998,25906.172000000006,{"$f":"+I23-I24","v":27596.458974115307},{"$f":"+J23-J24","v":29397.031252244797},31315.084564147837,33358.28413574407,35534.795322093225,37853.316239069594,40323.112524138902]
[null,"Combustible Fosil","Miles de litros",5569.6610000000001,6107.5820000000003,6427.6,6754.0240000000003,7250.9849999999997,{"$f":"+I25*$C$12","v":7649.2045843141768},{"$f":"+J25*$C$12","v":8148.2883884057001},8679.9356624320244,9246.271058737113,9849.5578557877379,10492.207003042418,11176.786755966314]
[null,"Energía Vendida","MWh",17541.050999999999,19341.800999999999,20551.661,21797.431,22765.301999999996,{"$f":"I25*$C$20","v":24376.393689598794},{"$f":"J25*$C$20","v":25966.867987748101},27661.115162446942,29465.906030375536,31388.453180284414,33436.439797074527,35618.050366547533]
[null,"Cantidad de Usuarios",null,8812,9304,10720,11519,12184]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":165.88223445301861},{"$f":"(E27*1000/E28)/12","v":173.23911758383488},{"$f":"(F27*1000/F28)/12","v":159.76104633084577},{"$f":"(G27*1000/G28)/12","v":157.69186416644962},{"$f":"(H27*1000/H28)/12","v":155.7048998686802}]
[null,"Demanda Máxima","MW",null,null,4.5794499999999996,4.6655860000000002,5.0506779999999996]
[null,"Potencia Instalada","MW",8.2040000000000006,8.2040000000000006,8.2040000000000006,8.2040000000000006,{"$f":"+C10","v":7.84}]
[null,"Pot. Efectiva a Temp. Media","MW",7.1010000000000009,7.1010000000000009,7.1010000000000009,7.1010000000000009,{"$f":"+C11","v":6.7919999999999998}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.32342915558230595},{"$f":"E25/(E32*8760)","v":0.35383046249193789},{"$f":"F25/(F32*8760)","v":0.37557955371904006},{"$f":"G25/(G32*8760)","v":0.39300604969780439},{"$f":"H25/(H32*8760)","v":0.43541306990227568}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G20","v":7.6597356000000005E-2},{"$f":"+H20","v":"gCO2/BTU"},"Diesel"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":20118.833000000006},{"$f":"+E25","v":22009.939000000002},23362.835999999999,24446.846999999998,25906.172000000006,27596.458974115307,29397.031252244797,31315.084564147837,33358.28413574407,35534.795322093225,37853.316239069594,40323.112524138902]
[null,"F  i,j,bl =","MMBTU",{"$f":"D26*1000*33710/1000000","v":187753.27231},{"$f":"E26*1000*33710/1000000","v":205886.58921999999},216674.39600000001,227678.14903999999,244430.70435000001,257854.68653723088,274678.80157315615,292600.63118058356,311691.79739002808,332028.59531860461,353692.29807255993,376769.48154362437]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"D44*$C$40/D43","v":0.71482298398192423},{"$f":"SUM(E44)*$C$40/SUM(E43)","v":0.71651122568354697},{"$f":"SUM(E44:F44)*$C$40/SUM(E43:F43)","v":0.71335848901917687},{"$f":"SUM(E44:G44)*$C$40/SUM(E43:G43)","v":0.71336104414952306},{"$f":"SUM(F44:H44)*$C$40/SUM(F43:H43)","v":0.7157073028639851},{"$f":"+H45","v":0.7157073028639851},0.7157073028639851,0.7157073028639851,0.7157073028639851,0.7157073028639851,0.7157073028639851,0.7157073028639851]
[null,"BE y =","tCO2/año",{"$f":"+D43*D45","v":14381.404239294014},{"$f":"+E43*E45","v":15770.368370110104},{"$f":"+F43*F45","v":16666.07738816283},17439.428302083634,18541.236489650495,19750.987220960684,21039.669949752402,22412.434712363862,23874.767566963852,25432.512517799096,27091.894869921987,28859.546107732433]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":8.2040000000000006},8.2040000000000006,8.2040000000000006,8.2040000000000006,7.84,{"$f":"+H49","v":7.84},{"$f":"+I49+2","v":9.84},{"$f":"+J49","v":9.84},{"$f":"+K49+2","v":11.84},11.84,{"$f":"+M49+2","v":13.84},13.84]
[null,"Pot. Efectiva a Temp. Media","MW",7.1010000000000009,7.1010000000000009,7.1010000000000009,7.1010000000000009,6.7919999999999998,{"$f":"+H50","v":6.7919999999999998},{"$f":"J49*($I$50/$I$49)","v":8.5246530612244893},{"$f":"K49*($I$50/$I$49)","v":8.5246530612244893},10.257306122448979,10.257306122448979,11.989959183673468,11.989959183673468]
[null,"Factor de Planta",null,0.32342915558230595,0.35383046249193789,0.37557955371904006,0.39300604969780439,0.43541306990227568,{"$f":"I25/(I50*8760)","v":0.46382224746874023},{"$f":"J25/(J50*8760)","v":0.39366123891662974},{"$f":"K25/(K50*8760)","v":0.41934625576724244},0.37124984452135545,0.39547259639441407,0.36039779248753767,0.38391248597994537]
[null,"Adiciones de capacidad","MW",{"$nulls":5},{"$f":"+I49-H49","v":0},2,0,{"$f":"+L49-K49","v":2},{"$f":"+M49-L49","v":0},{"$f":"+N49-M49","v":2},{"$f":"+O49-N49","v":0}]
[]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado (tCO2e/MWh) al momento de la interconexión a la red"]
[null,"COEF  i,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
{"$rows_empty":8}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[]
[null,"Emisiones del Proyecto"]
[null,"Utilizamos el factor de emisiones del Sistema Interconectado Nacional (SIN)",0.48]
[]
[]
[null,"Donde:"]
[null,"EG y =","Electricidad abastecida al sistema Aislado por la red (SIN) en el año y (MWh)"]
[null,"EF p =","Factor de Emisión de Red (SIN) método simple promedio"]
[null,"TL =",2.6814880952380937E-2,"Perdidas de energía en la red de transmisión del SIN "]
[null,"PE sf6,y =",0,"La red de transmisión nueva no tiene SF6"]
[]
[null,null,null,{"$f":"+D42","v":2014},{"$f":"+E42","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y(*) =","MWh",{"$nulls":9},{"$f":"+M25*0.7/12*2","v":4145.7261209108756},{"$f":"+N25*0.7","v":26497.321367348715},{"$f":"+O25*0.7","v":28226.178766897228}]
[null,{"$f":"+B82","v":"TL ="},"%",{"$nulls":9},{"$f":"+C82","v":2.6814880952380937E-2},{"$f":"+M87","v":2.6814880952380937E-2},{"$f":"+N87","v":2.6814880952380937E-2}]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":9},{"$f":"+C76","v":0.48},{"$f":"+M88","v":0.48},{"$f":"+N88","v":0.48}]
[null,"PE y =","tCO2/año",{"$nulls":9},{"$f":"M86*M88*(M87+1)","v":2043.3087711860528},{"$f":"N86*N88*(N87+1)","v":13059.765064978152},{"$f":"O86*O88*(O87+1)","v":13911.868987330656}]
[null,"(*) Asumimos que un 70% de la demanda de energía vendría de la red (SIN)"]
[]
[]
[null,null,null,{"$f":"+D85","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Emisiones Planta Sistema Aislado","tCO2/año",{"$f":"+D46","v":14381.404239294014},15770.368370110104,16666.07738816283,17439.428302083634,18541.236489650495,19750.987220960684,21039.669949752402,22412.434712363862,23874.767566963852,25432.512517799096,27091.894869921987,28859.546107732433]
[]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D25-D86","v":20118.833000000006},{"$f":"+E25-E86","v":22009.939000000002},23362.835999999999,24446.846999999998,25906.172000000006,27596.458974115307,29397.031252244797,31315.084564147837,33358.28413574407,31389.069201182348,11355.994871720879,12096.933757241673]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+D26","v":5569.6610000000001},{"$f":"+E26","v":6107.5820000000003},6427.6,6754.0240000000003,7250.9849999999997,{"$f":"+I98*$C$12","v":7649.2045843141768},{"$f":"+J98*$C$12","v":8148.2883884057001},8679.9356624320244,9246.271058737113,8700.4427726125032,3147.6621009127257,3353.036026789895]
[null,"Emisiones Planta Interconectada","tCO2/año",{"$f":"+(D25-D86)*D45","v":14381.404239294014},{"$f":"+(E25-E86)*E45","v":15770.368370110104},16666.07738816283,17439.428302083634,18541.236489650495,19750.987220960684,21039.669949752402,{"$f":"+(K25-K86)*K45","v":22412.434712363862},23874.767566963852,22465.386057389202,8127.5684609765967,8657.863832319732]
[null,"Emisiones del Proyecto","tCO2/año",{"$f":"D89","v":0},{"$f":"E89","v":0},0,0,0,0,0,0,0,2043.3087711860528,13059.765064978152,13911.868987330656]
[null,"Total Emisiones con Proyecto","tCO2/año",{"$f":"+D101+D100","v":14381.404239294014},15770.368370110104,16666.07738816283,17439.428302083634,18541.236489650495,19750.987220960684,21039.669949752402,22412.434712363862,23874.767566963852,24508.694828575255,21187.333525954749,22569.732819650388]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",{"$f":"+D102/D23","v":0.71482298398192423},{"$f":"+E102/E23","v":0.71651122568354697},0.71335848901917687,0.71336104414952306,0.7157073028639851,0.7157073028639851,0.7157073028639851,0.7157073028639851,0.7157073028639851,0.68970975086318687,0.5597219908591955,0.5597219908591955]
[]
[null,"Emisiones Reducidas","tCO2/año",{"$f":"+D95-D102","v":0},{"$f":"+E95-E102","v":0},0,0,0,0,0,0,0,923.81768922384072,5904.5613439672379,6289.8132880820449]

{"sheet":"Las Misiones","index":3,"n_rows":111,"n_cols":15,"rows_kept":111,"cut":false,"hidden":false,"merged":[[78,1,78,4],[1,1,1,3],[1,5,1,10],[3,5,4,9],[3,10,4,10],[17,5,17,7],[74,1,77,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,17]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"Electrificación mediante la extensión de una red (nacional, regional o mini-red)",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Guarayos"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Las Misiones"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."},null,null,"Proyecto:","Conexión al SIN Las Misiones"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas/Diesel"},null,null,"Línea:","230 kV (Los Troncos - Guarayos)"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":27.8},null,null,null,"Mes/Año de puesta en operación","2020-12-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":21.349999999999994},null,null,null,"Categoría","Gran Escala"]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":19.05},null,null,null,"Metodología Aplicable","AM00045"]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(F29:H29)/SUM(F27:H27)","v":13.231302586681062}]
[null,"Consumo especifico (lt/kWh)",0.27718065536918751]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AM00045 (Ver pagina 11 de la metodología)",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H26/D26)^(1/4)-1","v":6.2553416093206415E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F31:H31)/SUM(F26:H26)","v":0.85345028948253543}]
[]
[null,null,"Unidades",2014,{"$f":"+D23+1","v":2015},{"$f":"+E23+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D25+D26","v":45834.749141093853},{"$f":"+E25+E26","v":51150.008000000002},55241.41,59494.525999999991,58424.895768660623,62079.572583879868,65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",45834.749141093853,51150.008000000002,55241.41,59494.525999999991,58424.895768660623,{"$f":"H26*(1+$C$20)","v":62079.572583879868},65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Fósil Gas","MWh",{"$f":"+D26-D28","v":45415.109466582391},{"$f":"+E26-E28","v":49661.704281796665},53151.033241101519,46841.12493202358,45374.324201240481,{"$f":"+I26-I28","v":52115.071299027884},{"$f":"+J26-J28","v":55375.047038723096},58838.94539731722,62519.52243124105,66430.332131831019,70585.776338883355,75001.157776471533]
[null,"Generación Fósil Diesel","MWh",{"$f":"D30/$C$13","v":419.63967451146357},{"$f":"E30/$C$13","v":1488.3037182033388},2090.3767588984847,12653.401067976414,13050.571567420144,{"$f":"(SUM($F$28:$H$28)/SUM($F$26:$H$26))*I26","v":9964.5012848519818},{"$f":"(SUM($F$28:$H$28)/SUM($F$26:$H$26))*J26","v":10587.814879884618},11250.118869583883,11953.852236330997,12701.606529186914,13496.135407459331,14340.36478125239]
[null,"Combustible Fósil gas natural","MPC",571963.42796784278,612920.54899999988,663158.38600000006,620081.93500000006,640147.59325666993,{"$f":"+I27*$C$12","v":689550.27768389566},{"$f":"+J27*$C$12","v":732684.00312104239},778515.89043310913,827214.7188625444,878959.82536997786,933941.76505555829,992363.01289190224]
[null,"Combustible Fósil Diesel","Miles de Litros",116.316,412.529,579.41200000000003,3507.2780006708795,3617.36598,{"$f":"+I28*$C$13","v":2761.9669965623834},{"$f":"+J28*$C$13","v":2934.7374673340537},3118.3153212525235,3313.3765970526533,3520.6396220015799,3740.8676571908741,3974.8717083007527]
[null,"Energía Vendida","MWh",37833.118999999999,41946.923999999999,46627.072999999997,48820.517,52336.572,{"$f":"I26*$C$21","v":52981.829192664343},{"$f":"J26*$C$21","v":56296.023599532266},59817.532188146775,63559.323168780684,67535.175957560001,71759.731920161154,76248.548289699946]
[null,"Cantidad de Usuarios",null,18188,20295,22711,25616,28263]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D31*1000/D32)/12","v":173.3428588446595},{"$f":"(E31*1000/E32)/12","v":172.23833456516385},{"$f":"(F31*1000/F32)/12","v":171.08843365182804},{"$f":"(G31*1000/G32)/12","v":158.82169021965439},{"$f":"(H31*1000/H32)/12","v":154.31415631744684}]
[null,"Demanda Máxima","MW",null,null,10.15507,11.0601664072266,11.7398552093505]
[null,"Potencia Instalada","MW",17.149999999999999,17.149999999999999,21.349999999999994,21.349999999999994,{"$f":"+C10","v":21.349999999999994}]
[null,"Pot. Efectiva a Temp. Media","MW",14.999999999999998,15,19.05,19.05,{"$f":"+C11","v":19.05}]
[null,"Factor de Planta ",null,{"$f":"D26/(D36*8760)","v":0.34881848661410852},{"$f":"E26/(E36*8760)","v":0.38926946727549466},{"$f":"F26/(F36*8760)","v":0.33102871558863362},{"$f":"G26/(G36*8760)","v":0.35651509485971783},{"$f":"H26/(H36*8760)","v":0.3501054409128862}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":5.7289758000000003E-2},{"$f":"+H19","v":"gCO2/BTU"},"Gas natural"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G20","v":7.6597356000000005E-2},{"$f":"+H20","v":"gCO2/BTU"},"Diesel Oil"]
[null,null,null,{"$f":"+D23","v":2014},{"$f":"+E23","v":2015},{"$f":"+F23","v":2016},{"$f":"+G23","v":2017},{"$f":"+H23","v":2018},{"$f":"+H46+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D26","v":45834.749141093853},{"$f":"+E26","v":51150.008000000002},55241.41,59494.525999999991,58424.895768660623,{"$f":"+I26","v":62079.572583879868},65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"F  i,j,bl =","MMBTU (gas)",{"$f":"D29*1000*940/1000000","v":537645.62228977226},{"$f":"E29*1000*940/1000000","v":576145.31605999987},{"$f":"F29*1000*940/1000000","v":623368.88283999998},582877.01890000002,601738.73766126961,648177.26102286193,688722.96293377981,731804.93700712256,777581.83573079179,826222.2358477792,877905.25915222487,932821.23211838806]
[null,"F  i,j,bl =","MMBTU (Diesel)",{"$f":"+D30*33710/1000","v":3921.0123599999997},{"$f":"+E30*33710/1000","v":13906.35259},{"$f":"+F30*33710/1000","v":19531.978520000001},{"$f":"+G30*33710/1000","v":118230.34140261535},{"$f":"+H30*33710/1000","v":121941.4071858},{"$f":"+I30*33710/1000","v":93105.907454117943},98930.000023830944,105118.40947942257,111693.92508664494,118680.76165767325,126104.64872390438,133992.92528681838]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"(D48*$C$44+D49*$C$45)/D47","v":0.67856653201304129},{"$f":"(E48*$C$44+E49*$C$45)/E47","v":0.66612727743676314},0.67356626767337668,0.71349446345635403,0.74991757299280037,0.71304590095652676,0.71304590095652676,0.71304590095652676,0.71304590095652687,0.71304590095652676,0.71304590095652687,0.71304590095652676]
[null,"BE y =","tCO2/año",{"$f":"+D47*D50","v":31101.92677035978},{"$f":"+E47*E50","v":34072.415569908655},{"$f":"+F47*F50","v":37208.75035471475},42449.014906960096,43813.856037191304,44265.584764068721,47034.548306424607,49976.7199773924,53102.934537111898,56424.704496982144,59954.2625153181,63704.606445000107]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D35","v":17.149999999999999},17.149999999999999,21.349999999999994,21.349999999999994,21.349999999999994,{"$f":"+H54","v":21.349999999999994},{"$f":"+I54+2","v":23.349999999999994},{"$f":"+J54","v":23.349999999999994},{"$f":"+K54+2","v":25.349999999999994},25.349999999999994,{"$f":"+M54+2","v":27.349999999999994},27.349999999999994]
[null,"Pot. Efectiva a Temp. Media","MW",14.999999999999998,15,19.05,19.05,19.05,{"$f":"+H55","v":19.05},{"$f":"J54*($I$55/$I$54)","v":20.834543325526933},{"$f":"K54*($I$55/$I$54)","v":20.834543325526933},22.619086651053866,22.619086651053866,24.403629976580799,24.403629976580799]
[null,"Factor de Planta",null,0.34881848661410852,0.38926946727549466,0.33102871558863362,0.35651509485971783,{"$f":"+H37","v":0.3501054409128862},{"$f":"I26/(I55*8760)","v":0.37200573223480549},{"$f":"J26/(J55*8760)","v":0.36141934817972643},0.3840273630505483,0.37585632522166934,0.39936742232452394,0.39331819737788193,0.41792159423549052]
[null,"Adiciones de capacidad","MW",{"$nulls":5},{"$f":"+I54-H54","v":0},2,0,{"$f":"+L54-K54","v":2},{"$f":"+M54-L54","v":0},{"$f":"+N54-M54","v":2},{"$f":"+O54-N54","v":0}]
[]
[]
[null,"Donde:"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado (tCO2e/MWh) al momento de la interconexión a la red"]
[null,"COEF  i,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
{"$rows_empty":8}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[]
[null,"Emisiones del Proyecto"]
[null,"Utilizamos el factor de emisiones del Sistema Interconectado Nacional (SIN)",0.48]
[]
[]
[null,"Donde:"]
[null,"EG y =","Electricidad abastecida al sistema Aislado por la red (SIN) en el año y (MWh)"]
[null,"EF p =","Factor de Emisión de Red (SIN) método simple promedio"]
[null,"TL =",2.6814880952380937E-2,"Perdidas de energía en la red de transmisión del SIN "]
[null,"PE sf6,y =",0,"La red de transmisión nueva no tiene SF6"]
[]
[null,null,null,2014,{"$f":"+D90+1","v":2015},{"$f":"+E90+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y(*) =","MWh",{"$nulls":6},{"$f":"+J26*0.7/12*1","v":3847.8336119187829},{"$f":"+K26*0.7","v":49062.344986830765},{"$f":"+L26*0.7","v":52131.362267300428},{"$f":"+M26*0.7","v":55392.357062712552},{"$f":"+N26*0.7","v":58857.338222439874},{"$f":"+O26*0.7","v":62539.065790406741}]
[null,{"$f":"+B87","v":"TL ="},"%",{"$nulls":6},{"$f":"+C87","v":2.6814880952380937E-2},{"$f":"+C87","v":2.6814880952380937E-2},{"$f":"+K92","v":2.6814880952380937E-2},2.6814880952380937E-2,2.6814880952380937E-2,2.6814880952380937E-2]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":6},{"$f":"+C81","v":0.48},{"$f":"+C81","v":0.48},0.48,0.48,0.48,0.48]
[null,"PE y =","tCO2/año",{"$nulls":6},{"$f":"J91*J93*(J92+1)","v":1896.4861498305384},24181.414044910693,25694.044099384097,27301.294331050063,29009.083555223333,30823.700829335812]
[null,"(*) Asumimos que un 70% de la demanda de energía vendría de la red (SIN)"]
[]
[]
[null,null,null,{"$f":"+D90","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Emisiones Planta Sistema Aislado","tCO2/año",{"$f":"+D51","v":31101.92677035978},34072.415569908655,37208.75035471475,42449.014906960096,43813.856037191304,44265.584764068721,47034.548306424607,49976.7199773924,53102.934537111898,56424.704496982144,59954.2625153181,63704.606445000107]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil Gas","MWh",{"$f":"(D27/D26)*(D26-D91)","v":45415.109466582391},{"$f":"(E27/E26)*(E26-E91)","v":49661.704281796665},53151.033241101519,46841.12493202358,45374.324201240481,52115.071299027884,52144.835961464254,17651.68361919517,18755.856729372317,19929.099639549306,21175.732901665007,22500.347332941459]
[null,"Combustible Fósil Gas","MPC",{"$f":"D29","v":571963.42796784278},{"$f":"E29","v":612920.54899999988},663158.38600000006,620081.93500000006,640147.59325666993,{"$f":"+I102*$C$12","v":689550.27768389566},{"$f":"+J102*$C$12","v":689944.10293898161},233554.76712993279,248164.41565876335,263687.94761099335,280182.52951666748,297708.90386757068]
[null,"Generación Combustible Fosil Diesel","MWh",{"$f":"(D28/D26)*(D26-D91)","v":419.63967451146357},{"$f":"(E28/E26)*(E26-E91)","v":1488.3037182033388},2090.3767588984847,12653.401067976414,13050.571567420144,9964.5012848519818,9970.1923452246829,3375.0356608751654,3586.1556708992994,3810.4819587560746,4048.8406222377998,4302.1094343757177]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+D30","v":116.316},{"$f":"+E30","v":412.529},579.41200000000003,3507.2780006708795,3617.36598,{"$f":"+I104*$C$13","v":2761.9669965623834},{"$f":"+J104*$C$13","v":2763.5444484062341},935.49459637575728,994.01297911579616,1056.1918866004742,1122.2602971572624,1192.4615124902259]
[null,"Emisiones Planta Interconectada","tCO2/año",{"$f":"+(D26-D91)*D50","v":31101.92677035978},34072.415569908655,37208.75035471475,42449.014906960096,43813.856037191304,44265.584764068721,44290.866321883172,14993.015993217723,15930.880361133572,16927.411349094647,17986.278754595431,19111.381933500033]
[null,"Emisiones del Proyecto","tCO2/año",{"$f":"D94","v":0},0,0,0,0,0,1896.4861498305384,24181.414044910693,25694.044099384097,27301.294331050063,29009.083555223333,30823.700829335812]
[null,"Total Emisiones con Proyecto","tCO2/año",{"$f":"+D107+D106","v":31101.92677035978},34072.415569908655,37208.75035471475,42449.014906960096,43813.856037191304,44265.584764068721,46187.352471713712,39174.430038128412,41624.924460517665,44228.705680144711,46995.362309818767,49935.082762835846]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",{"$f":"+D108/D24","v":0.67856653201304129},{"$f":"+E108/E24","v":0.66612727743676314},0.67356626767337668,0.71349446345635403,0.74991757299280037,0.71304590095652676,0.70020237340072944,0.55892357028695794,0.55892357028695805,0.55892357028695805,0.55892357028695805,0.55892357028695794]
[]
[null,"Emisiones Reducidas","tCO2/año",{"$f":"+D100-D108","v":0},0,0,0,0,0,847.19583471089572,10802.289939263988,11478.010076594233,12195.998816837433,12958.900205499333,13769.523682164261]

{"sheet":"Valles","index":4,"n_rows":68,"n_cols":15,"rows_kept":68,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[17,5,17,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,20]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Vallegrande"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Valles Cruceños"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."}]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas"}]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":14.547500000000001}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":11.637999999999998}]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":9.56}]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(F29:H29)/SUM(F27:H27)","v":10.919685192417695}]
[null,"Consumo especifico (litros/kWh)",0.27718065536918751]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Pequeña Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AMS I.A",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H26/D26)^(1/4)-1","v":8.2236611195296572E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F31:H31)/SUM(F26:H26)","v":0.83931632668362122}]
[]
[null,null,"Unidades",2014,{"$f":"+D23+1","v":2015},{"$f":"+E23+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D25+D26","v":24962.853000000003},{"$f":"+E25+E26","v":27356.740999999998},30774.994530201344,33037.838000000003,34243.890999999996,{"$f":"H24*(1+$C$20)","v":37059.992549981114},{"$f":"I24*(1+$C$20)","v":40107.680748214501},43406.000495850501,46975.562882170612,50838.673982591885,55019.47424858273,59544.089360533057]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",24962.853000000003,27356.740999999998,30774.994530201344,33037.838000000003,34243.890999999996,{"$f":"+I24-I25","v":37059.992549981114},{"$f":"+J24-J25","v":40107.680748214501},43406.000495850501,46975.562882170612,50838.673982591885,55019.47424858273,59544.089360533057]
[null,"Generación Fósil Gas","MWh",{"$f":"+D26-D28","v":24962.853000000003},{"$f":"+E26-E28","v":27356.740999999998},30666.112472902641,33032.859297578791,34225.311059804888,37047.016023770731,40093.637076463485,43390.801920125945,46959.114427083477,50820.87286229898,55000.209224481456,59523.240046135099]
[null,"Generación Fósil Diesel","MWh",{"$f":"D30/$C$13","v":0},{"$f":"E30/$C$13","v":0},108.88205729870327,4.9787024212130717,18.579940195106754,{"$f":"(SUM($G$28:$H$28)/SUM($G$26:$H$26))*I26","v":12.976526210384403},{"$f":"(SUM($G$28:$H$28)/SUM($G$26:$H$26))*J26","v":14.043671751013362},15.198575724555818,16.448455087138388,17.801120292902688,19.265024101270829,20.849314397955055]
[null,"Combustible Fósil gas natural","MPC",284155.40100000001,313266.45,353773.35000000003,355513.28460000001,360015.70659999992,{"$f":"+I27*$C$12","v":404541.75229803036},{"$f":"+J27*$C$12","v":437809.89509402739},473813.89721432858,512778.74645847164,554947.93286018842,600584.97024844529,649975.0429365054]
[null,"Combustible Fósil Diesel","Miles de Litros",0,0,30.18,1.38,5.15,{"$f":"+I28*$C$13","v":3.596842039409788},{"$f":"+J28*$C$13","v":3.8926341397356286},4.2127511800106054,4.5591935608636645,4.9341261890925106,5.3398920060934412,5.7790266288234191]
[null,"Energía Vendida","MWh",21251.085999999999,23113.884999999998,25842.941999999999,27838.267,28619.399999999998,{"$f":"I26*$C$21","v":31105.056813972518},{"$f":"J26*$C$21","v":33663.031277390786},36431.364892204685,39427.3568821589,42669.729100535202,46178.743022384544,49976.326357803897]
[null,"Cantidad de Usuarios",null,18160,18933,20497,21942,23104]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D31*1000/D32)/12","v":97.517832232011756},{"$f":"(E31*1000/E32)/12","v":101.73543988450501},{"$f":"(F31*1000/F32)/12","v":105.06798555886228},{"$f":"(G31*1000/G32)/12","v":105.72671512776107},{"$f":"(H31*1000/H32)/12","v":103.22671398891966}]
[null,"Demanda Máxima","MW",null,null,6.2857200000000004,6.4432310000000008,6.3408040000000003]
[null,"Potencia Instalada","MW",7.64,7.64,9.64,11.637999999999998,{"$f":"+C10","v":11.637999999999998}]
[null,"Pot. Efectiva a Temp. Media","MW",6.48,6.48,8.1300000000000008,8.5,{"$f":"+C11","v":9.56}]
[null,"Factor de Planta ",null,{"$f":"D26/(D36*8760)","v":0.43975937552849653},{"$f":"E26/(E36*8760)","v":0.48193142581317994},{"$f":"F26/(F36*8760)","v":0.43211897041513397},{"$f":"G26/(G36*8760)","v":0.4436991404781091},{"$f":"H26/(H36*8760)","v":0.4089037633021913}]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":5.7289758000000003E-2},{"$f":"+H19","v":"gCO2/BTU"},"Gas natural"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G20","v":7.6597356000000005E-2},{"$f":"+H20","v":"gCO2/BTU"},"Diesel Oil"]
[null,null,null,{"$f":"+D23","v":2014},{"$f":"+E23","v":2015},{"$f":"+F23","v":2016},{"$f":"+G23","v":2017},{"$f":"+H23","v":2018},{"$f":"+H44+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D26","v":24962.853000000003},{"$f":"+E26","v":27356.740999999998},30774.994530201344,33037.838000000003,34243.890999999996,37059.992549981114,40107.680748214501,43406.000495850501,46975.562882170612,50838.673982591885,55019.47424858273,59544.089360533057]
[null,"F  i,j,bl =","Mpc (gas)",{"$f":"+D29","v":284155.40100000001},{"$f":"+E29","v":313266.45},353773.35000000003,355513.28460000001,360015.70659999992,404541.75229803036,437809.89509402739,473813.89721432858,512778.74645847164,554947.93286018842,600584.97024844529,649975.0429365054]
[null,"F  i,j,bl =","Miles de Litros (Diesel)",{"$f":"+D30","v":0},0,30.18,1.38,5.15,3.596842039409788,3.8926341397356286,4.2127511800106054,4.5591935608636645,4.9341261890925106,5.3398920060934412,5.7790266288234191]
[null,"NCV j =","Btu/pc (gas)",940,{"$f":"+D48","v":940},{"$f":"+E48","v":940},940,940,{"$f":"+H48","v":940},{"$f":"+I48","v":940},940,940,940,940,940]
[null,"NCV j =","Btu/litro (Diesel)",33710,{"$f":"+D49","v":33710},33710,33710,33710,{"$f":"+H49","v":33710},33710,33710,33710,33710,33710,33710]
[null,"EF co2,j =","gCO2/BTU (gas)",{"$f":"+C42","v":5.7289758000000003E-2},{"$f":"+D50","v":5.7289758000000003E-2},5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,{"$f":"+H50","v":5.7289758000000003E-2},5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2]
[null,"EF co2,j =","gCO2/BTU (Diesel)",{"$f":"+C43","v":7.6597356000000005E-2},{"$f":"+D51","v":7.6597356000000005E-2},7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,{"$f":"+H51","v":7.6597356000000005E-2},7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2]
[null,"BE y =","tCO2/año",{"$f":"((D46*D48*D50)+(D47*D49*D51))/1000","v":15302.442508221982},{"$f":"((E46*E48*E50)+(E47*E49*E51))/1000","v":16870.141563417958},19129.461915407886,19148.797131769628,19400.997743758635,21794.820539221677,23587.152721976909,25526.880229578212,27626.12435404694,29898.003201383606,32356.713666171523,35017.62014749401]
[null,"EF bl =","tCO2/MWh",{"$f":"D52/D45","v":0.61300855748427396},{"$f":"E52/E45","v":0.6166721965682227},{"$f":"SUM(D52:F52)/SUM(D45:F45)","v":0.61739334527665068},{"$f":"SUM(E52:G52)/SUM(E45:G45)","v":0.60489918374277241},{"$f":"SUM(F52:H52)/SUM(F45:H45)","v":0.58822337433262306},{"$f":"I52/I45","v":0.5880956535495252},{"$f":"J52/J45","v":0.58809565354952498},0.58809565354952509,0.58809565354952509,0.58809565354952498,0.58809565354952498,0.58809565354952509]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D35","v":7.64},7.64,9.64,11.637999999999998,11.637999999999998,{"$f":"+H56+1","v":12.637999999999998},13.637999999999998,14.637999999999998,15.637999999999998,16.637999999999998,17.637999999999998,18.637999999999998]
[null,"Pot. Efectiva a Temp. Media","MW",6.48,6.48,8.1300000000000008,8.5,9.56,{"$f":"I56*($H$57/$H$56)","v":10.381446984017872},11.202893968035745,12.024340952053619,{"$f":"L56*($H$57/$H$56)","v":12.84578793607149},{"$f":"M56*($H$57/$H$56)","v":13.667234920089363},14.488681904107237,15.310128888125108]
[null,"Factor de Planta",null,0.43975937552849653,0.48193142581317994,0.43211897041513397,0.4436991404781091,0.4089037633021913,{"$f":"I26/(I57*8760)","v":0.40751474850857611},0.40868925311451532,0.41208270020053833,0.41745256927929209,0.42462880239628908,0.43349436077706133,0.44397212620586213]
[null,"Adiciones de capacidad","MW",{"$nulls":5},{"$f":"+I56-H56","v":1},1,{"$f":"+K56-J56","v":1},{"$f":"+L56-K56","v":1},{"$f":"+M56-L56","v":1},{"$f":"+N56-M56","v":1},{"$f":"+O56-N56","v":1}]
[]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"FC  j,y =","Mpc/Miles de litros","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"NCV j =","Btu/pc - Btu/litro","Poder Calorífico Inferior del combustible \"j\""]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado"]
[null,"EF co2,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]

{"sheet":"Camiri","index":5,"n_rows":106,"n_cols":15,"rows_kept":106,"cut":false,"hidden":false,"merged":[[75,1,75,4],[1,1,1,3],[1,5,1,10],[3,5,4,9],[3,10,4,10],[16,5,16,7],[71,1,74,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,16]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"Electrificación mediante la extensión de una red (nacional, regional o mini-red)",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Cordillera"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Camiri"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."},null,null,"Proyecto:","Conexión al SIN Camiri"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas"},null,null,"Línea:","115 kV (Padilla - Monteagudo - Camiri)"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":15.83},null,null,null,"Mes/Año de puesta en operación","2021-04-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":12.673999999999999},null,null,null,"Categoría","Gran Escala"]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":11.75},null,null,null,"Metodología Aplicable","AM00045"]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(G26:H26)/SUM(G25:H25)","v":9.9920758954998004}]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AM00045 (Ver pagina 11 de la metodología)",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H25/D25)^(1/4)-1","v":5.3848706295990034E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F28:H28)/SUM(F25:H25)","v":0.8360200276017804}]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":26931.019},{"$f":"+E24+E25","v":29769.716000000004},31023.121999999992,32518.518999999997,33217.416593452006,{"$f":"H23*(1+$C$19)","v":35006.131503504352},{"$f":"I23*(1+$C$19)","v":36891.166397395362},38877.707981645202,40971.222260210081,43177.469574287861,45502.520451997734,47952.772311544642]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",26931.019,29769.716000000004,31023.121999999992,32518.518999999997,33217.416593452006,{"$f":"+I23-I24","v":35006.131503504352},{"$f":"+J23-J24","v":36891.166397395362},38877.707981645202,40971.222260210081,43177.469574287861,45502.520451997734,47952.772311544642]
[null,"Combustible Fosil gas natural","MPC",294214.14029697224,320543.55092341761,324808.4192879374,317579.27174145909,339259.18577000004,{"$f":"+I25*$C$12","v":349783.92279086204},{"$f":"+J25*$C$12","v":368619.33451628638},388469.00879567722,409387.56235541002,431432.55296191777,454664.63779289322,479147.74033657549]
[null,"Combustible Fosil Diesel","Miles de Litros",null,26.829000000000001,13.922000000000001]
[null,"Energía Vendida","MWh",23095.171000000002,25545.29,26937.044999999998,27085.858999999997,26869.606,{"$f":"I25*$C$20","v":29265.827025791263},{"$f":"J25*$C$20","v":30841.753949812344},32502.542499908981,34252.762364859511,36097.229305271168,38041.018404229726,40089.478031479441]
[null,"Cantidad de Usuarios",null,11277,11944,13230,14167,14957]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D28*1000/D29)/12","v":170.66574295764244},{"$f":"(E28*1000/E29)/12","v":178.22958528689438},{"$f":"(F28*1000/F29)/12","v":169.67148526077099},{"$f":"(G28*1000/G29)/12","v":159.32483353332861},{"$f":"(H28*1000/H29)/12","v":149.7047424840097}]
[null,"Demanda Máxima","MW",null,null,6.0750000000000002,6.03993,6.3780000000000001]
[null,"Potencia Instalada","MW",7.2499999999999991,7.9,9.06,10.866,{"$f":"+C10","v":12.673999999999999}]
[null,"Pot. Efectiva a Temp. Media","MW",6.5,7.1,8.25,10,{"$f":"+C11","v":11.75}]
[null,"Factor de Planta ",null,{"$f":"D25/(D33*8760)","v":0.47297188268352652},{"$f":"E25/(E33*8760)","v":0.47864357836516824},{"$f":"F25/(F33*8760)","v":0.42926694340666932},{"$f":"G25/(G33*8760)","v":0.37121597031963466},{"$f":"H25/(H33*8760)","v":0.32271851348928404}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G18","v":5.7289758000000003E-2},{"$f":"+H18","v":"gCO2/BTU"},"Gas natural"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":7.6597356000000005E-2},{"$f":"+H19","v":"gCO2/BTU"},"Diesel Oil"]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H43+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":26931.019},{"$f":"+E25","v":29769.716000000004},31023.121999999992,32518.518999999997,33217.416593452006,35006.131503504352,36891.166397395362,38877.707981645202,40971.222260210081,43177.469574287861,45502.520451997734,47952.772311544642]
[null,"F  i,j,bl =","MMBTU (gas)",{"$f":"D26*1000*940/1000000","v":276561.29187915387},{"$f":"E26*1000*940/1000000","v":301310.93786801258},{"$f":"F26*1000*940/1000000","v":305319.91413066111},298524.51543697156,318903.63462380006,328796.88742341025,346502.17444530921,365160.86826793657,384824.30861408543,405546.5997842027,427384.75952531962,450398.87591638096]
[null,"F  i,j,bl =","MMBTU (Diesel)",{"$f":"+D27*33710/1000","v":0},{"$f":"+E27*33710/1000","v":904.40558999999996},{"$f":"+F27*33710/1000","v":469.31061999999997},{"$f":"+G27*33710/1000","v":0},{"$f":"+H27*33710/1000","v":0}]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"(D45*$C$41+D46*$C$42)/D44","v":0.58832268782418118},{"$f":"(E45*$C$41+E46*$C$42)/E44","v":0.58217907722589957},{"$f":"(SUM(D45:F45)*$C$41+SUM(D46:F46)*$C$42)/SUM(D44:F44)","v":0.57798515653321392},{"$f":"(SUM(E45:G45)*$C$41+SUM(E46:G46)*$C$42)/SUM(E44:G44)","v":0.55685992201752621},{"$f":"(SUM(F45:H45)*$C$41+SUM(F46:H46)*$C$42)/SUM(F44:H44)","v":0.54671844229196276},{"$f":"+H47","v":0.54671844229196276},{"$f":"+I47","v":0.54671844229196276},0.54671844229196276,0.54671844229196276,0.54671844229196276,0.54671844229196276,0.54671844229196276]
[null,"BE y =","tCO2/año",{"$f":"+D44*D47","v":15844.129483924093},{"$f":"+E44*E47","v":17331.305790157101},{"$f":"+F44*F47","v":17930.904025318989},18108.259954465444,18160.574256935277,19138.497686263505,20169.081027117591,21255.159947606873,22399.722812899847,23605.918907763276,24877.067101874378,26216.664981748851]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D32","v":7.2499999999999991},7.9,9.06,10.866,12.673999999999999,{"$f":"+H51","v":12.673999999999999},{"$f":"+I51","v":12.673999999999999},12.673999999999999,12.673999999999999,12.673999999999999,12.673999999999999,12.673999999999999]
[null,"Pot. Efectiva a Temp. Media","MW",6.5,7.1,8.25,10,11.75,{"$f":"+H52","v":11.75},11.75,11.75,11.75,11.75,11.75,11.75]
[null,"Factor de Planta",null,0.47297188268352652,0.47864357836516824,0.42926694340666932,0.37121597031963466,0.32271851348928404,{"$f":"I25/(I52*8760)","v":0.34009648793844705},{"$f":"J25/(J52*8760)","v":0.35841024382974218},0.37771017178320415,0.39804937588856582,0.41948381982209132,0.44207248083161116,0.46587751201345229]
[null,"Adiciones de capacidad","MW",{"$nulls":8},{"$f":"+L51-K51","v":0},{"$f":"+M51-L51","v":0},{"$f":"+N51-M51","v":0},{"$f":"+O51-N51","v":0}]
[]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado (tCO2e/MWh) al momento de la interconexión a la red"]
[null,"COEF  i,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
{"$rows_empty":8}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[]
[null,"Emisiones del Proyecto"]
[null,"Utilizamos el factor de emisiones del Sistema Interconectado Nacional (SIN)",0.48]
[]
[]
[null,"Donde:"]
[null,"EG y =","Electricidad abastecida al sistema Aislado por la red (SIN) en el año y (mwH)"]
[null,"EF p =","Factor de Emisión de Red (SIN) método simple promedio"]
[null,"TL =",2.6814880952380937E-2,"Perdidas de energía en la red de transmisión del SIN "]
[null,"PE sf6,y =",0,"La red de transmisión nueva no tiene SF6"]
[]
[null,null,null,{"$f":"+D43","v":2014},{"$f":"+E43","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y(*) =","MWh",{"$nulls":7},{"$f":"+K25*0.7/12*9","v":20410.796690363732},{"$f":"+L25*0.7","v":28679.855582147055},{"$f":"+M25*0.7","v":30224.228702001499},{"$f":"+N25*0.7","v":31851.76431639841},{"$f":"+O25*0.7","v":33566.940618081251}]
[null,{"$f":"+B84","v":"TL ="},"%",{"$nulls":7},{"$f":"+C84","v":2.6814880952380937E-2},{"$f":"+K89","v":2.6814880952380937E-2},2.6814880952380937E-2,2.6814880952380937E-2,2.6814880952380937E-2]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":7},{"$f":"+C78","v":0.48},0.48,0.48,0.48,0.48]
[null,"PE y =","tCO2/año",{"$nulls":7},{"$f":"K88*K90*(K89+1)","v":10059.892691404362},{"$f":"L88*L90*(L89+1)","v":14135.473197750627},{"$f":"M88*M90*(M89+1)","v":14896.650142331138},{"$f":"N88*N90*(N89+1)","v":15698.815480639645},{"$f":"O88*O90*(O89+1)","v":16544.176384651553}]
[null,"(*) Asumimos que un 70% de la demanda de energía vendría de la red (SIN)"]
[]
[]
[null,null,null,{"$f":"+D87","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Emisiones Planta Sistema Aislado","tCO2/año",{"$f":"+D48","v":15844.129483924093},17331.305790157101,17930.904025318989,18108.259954465444,18160.574256935277,19138.497686263505,20169.081027117591,21255.159947606873,22399.722812899847,23605.918907763276,24877.067101874378,26216.664981748851]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D25-D88","v":26931.019},{"$f":"+E25-E88","v":29769.716000000004},31023.121999999992,32518.518999999997,33217.416593452006,35006.131503504352,36891.166397395362,18466.911291281471,12291.366678063026,12953.240872286362,13650.756135599324,14385.831693463391]
[null,"Combustible Fósil","MPC",{"$f":"+D26","v":294214.14029697224},{"$f":"+E26","v":320543.55092341761},324808.4192879374,317579.27174145909,339259.18577000004,349783.92279086204,368619.33451628638,{"$f":"+K99*$C$12","v":184522.77917794668},{"$f":"+L99*$C$12","v":122816.26870662303},129429.76588857536,136399.391337868,143744.32210097261]
[null,"Emisiones Planta Interconectada","tCO2/año",{"$f":"+(D25-D88)*D47","v":15844.129483924093},17331.305790157101,17930.904025318989,18108.259954465444,18160.574256935277,19138.497686263505,20169.081027117591,10096.200975113265,6719.9168438699544,7081.7756723289849,7463.1201305623154,7864.9994945246535]
[null,"Emisiones del Proyecto","tCO2/año",{"$f":"D91","v":0},0,0,0,0,0,0,10059.892691404362,14135.473197750627,14896.650142331138,15698.815480639645,16544.176384651553]
[null,"Total Emisiones con Proyecto","tCO2/año",{"$f":"+D102+D101","v":15844.129483924093},17331.305790157101,17930.904025318989,18108.259954465444,18160.574256935277,19138.497686263505,20169.081027117591,20156.093666517627,20855.39004162058,21978.425814660124,23161.93561120196,24409.175879176208]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",{"$f":"D103/D23","v":0.58832268782418118},{"$f":"E103/E23","v":0.58217907722589957},0.57798515653321392,0.55685992201752621,0.54671844229196276,0.54671844229196276,0.54671844229196276,0.51844861008868237,0.50902533268758876,0.50902533268758887,0.50902533268758876,0.50902533268758876]
[]
[null,"Emisiones Reducidas","tCO2/año",{"$f":"+D97-D103","v":0},0,0,0,0,0,0,1099.0662810892463,1544.332771279267,1627.4930931031522,1715.1314906724183,1807.4891025726429]

{"sheet":"German Busch","index":6,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[17,5,17,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,22]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"German Bush"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"German Busch"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."}]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas"}]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":28.984999999999999}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":23.199999999999996}]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":19.099999999999998}]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":13.475068851751542}]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala"]
[null,"Metodología Aplicable Línea de Base","AM00045 (Ver pagina 11 de la metodología)",null,null,"Factores de Emisiones"]
[null,"% Crecimiento Acumulativo Anual (*)",5.5E-2,null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F27:H27)/SUM(F25:H25)","v":0.91838243797367758},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"(*) Asumimos crecimiento de ventas en sistemas aislados del año 2018"]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":57328.465000000004},{"$f":"+E24+E25","v":60886.547999999995},60284.14,55369.352999999996,57411.820999999996,{"$f":"H23*(1+$C$19)","v":60569.471154999992},{"$f":"I23*(1+$C$19)","v":63900.792068524985},67415.335632293849,71123.17909207,75034.953942133841,79161.876408951197,83515.779611443504]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",57328.465000000004,60886.547999999995,60284.14,55369.352999999996,57411.820999999996,{"$f":"+I23-I24","v":60569.471154999992},{"$f":"+J23-J24","v":63900.792068524985},67415.335632293849,71123.17909207,75034.953942133841,79161.876408951197,83515.779611443504]
[null,"Combustible Fósil gas natural","MPC",744218.66700000002,784928.69000000018,795439.49199999997,748755.08600000001,787872.44400000002,{"$f":"+I25*$C$12","v":816177.79412780388},{"$f":"+J25*$C$12","v":861067.57280483306},908426.28930909873,958389.73522109899,1011101.1706582593,1066711.7350444635,1125380.880471909]
[null,"Energía Vendida","MWh",49864.024999999994,55849.83,55786.36,50334.797000000006,52818.988000000005,{"$f":"I25*$C$20","v":55625.938586105236},58685.365208341012,61913.060294799761,65318.278611013739,68910.783934619481,72700.877051023548,76699.425288829836]
[null,"Cantidad de Usuarios",null,8646,9004,9991,10406,10771]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":480.60784370421766},{"$f":"(E27*1000/E28)/12","v":516.89832296756992},{"$f":"(F27*1000/F28)/12","v":465.30510793047074},{"$f":"(G27*1000/G28)/12","v":403.09114132872065},{"$f":"(H27*1000/H28)/12","v":408.65122396558667}]
[null,"Demanda Máxima","MW",null,null,10.94204,9.6973780000000005,10.25271]
[null,"Potencia Instalada","MW",20.999999999999996,20.999999999999996,20.999999999999996,20.999999999999996,{"$f":"+C10","v":23.199999999999996}]
[null,"Pot. Efectiva a Temp. Media","MW",17.399999999999999,17.399999999999999,17.399999999999999,17.399999999999999,{"$f":"+C11","v":19.099999999999998}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.37611179997900596},{"$f":"E25/(E32*8760)","v":0.39945512517713744},{"$f":"F25/(F32*8760)","v":0.39550293916968454},{"$f":"G25/(G32*8760)","v":0.36325875846323413},{"$f":"H25/(H32*8760)","v":0.34313407564130155}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":5.7289758000000003E-2},{"$f":"+H19","v":"gCO2/BTU"},"Gas natural"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":57328.465000000004},60886.547999999995,60284.14,55369.352999999996,57411.820999999996,60569.471154999992,63900.792068524985,67415.335632293849,71123.17909207,75034.953942133841,79161.876408951197,83515.779611443504]
[null,"F  i,j,bl =","MMBTU (gas)",{"$f":"D26*1000*940/1000000","v":699565.54697999998},737832.96860000014,747713.12248000002,703829.78084000002,740600.09736000001,767207.12648013572,809403.51843654306,853920.71195055288,900886.35110783309,950435.1004187637,1002709.0309417957,1057858.0276435944]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"(D44*$C$40)/D43","v":0.69909321471666519},{"$f":"(E44*$C$40)/E43","v":0.69424648964358449},{"$f":"(SUM(D44:F44)*$C$40)/SUM(D43:F43)","v":0.70131714825246827},{"$f":"(SUM(E44:G44)*$C$40)/SUM(E43:G43)","v":0.71048365664158775},{"$f":"(SUM(F44:H44)*$C$40)/SUM(F43:H43)","v":0.72566442753717275},{"$f":"+H45","v":0.72566442753717275},{"$f":"+I45","v":0.72566442753717275},0.72566442753717275,0.72566442753717275,0.72566442753717275,0.72566442753717275,0.72566442753717275]
[null,"BE y =","tCO2/año",{"$f":"+D43*D45","v":40077.940891621831},42270.272215515608,42278.301149652551,39339.020385318865,41661.716219831629,43953.11061192237,46370.531695578095,48920.910938834881,51611.561040470791,54450.196897696675,57444.957727069988,60604.430402058832]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":20.999999999999996},20.999999999999996,20.999999999999996,20.999999999999996,23.199999999999996,{"$f":"+H49","v":23.199999999999996},{"$f":"+I49+4.2","v":27.399999999999995},27.399999999999995,27.399999999999995,{"$f":"+L49+1.5","v":28.899999999999995},28.899999999999995,28.899999999999995]
[null,"Pot. Efectiva a Temp. Media","MW",17.399999999999999,17.399999999999999,17.399999999999999,17.399999999999999,19.099999999999998,{"$f":"+H50","v":19.099999999999998},{"$f":"($H$50/$H$49)*J49","v":22.557758620689651},{"$f":"($H$50/$H$49)*K49","v":22.557758620689651},22.557758620689651,23.792672413793099,23.792672413793099,23.792672413793099]
[null,"Factor de Planta",null,0.37611179997900596,0.39945512517713744,0.39550293916968454,0.36325875846323413,0.34313407564130155,{"$f":"I25/(I50*8760)","v":0.36200644980157309},0.32337481260377016,0.34116042729697749,0.3599242507983112,0.36001142968258754,0.37981205831512982,0.40070172152246192]
[null,"Adiciones de capacidad","MW",{"$nulls":5},{"$f":"+I49-H49","v":0},4.1999999999999993,0,{"$f":"+L49-K49","v":0},{"$f":"+M49-L49","v":1.5},{"$f":"+N49-M49","v":0},{"$f":"+O49-N49","v":0}]
[]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\" "]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado "]
[null,"COEF  i,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]

{"sheet":"Bermejo","index":7,"n_rows":105,"n_cols":15,"rows_kept":105,"cut":false,"hidden":false,"merged":[[73,1,73,4],[1,1,1,3],[1,5,1,10],[3,5,4,9],[3,10,4,10],[17,5,17,7],[69,1,72,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,24]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Tarija"},null,null,"Electrificación mediante la extensión de una red (nacional, regional o mini-red)",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Aniceto Arce"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Bermejo"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"SETAR"},null,null,"Proyecto:","Conexión al SIN Bermejo"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas"},null,null,"Línea:","115 kV (Tarija - Bermejo)"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":18.055999999999997},null,null,null,"Mes/Año de puesta en operación","2021-10-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":14.443999999999999},null,null,null,"Categoría","Gran Escala"]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":11.55},null,null,null,"Metodología Aplicable","AM00045"]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":13.250152829182118}]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Gran Escala"]
[null,"Metodología Aplicable Línea de Base","AM00045 (Ver pagina 11 de la metodología)",null,null,"Factores de Emisiones"]
[null,"% Crecimiento Acumulativo Anual (*)",5.5E-2,null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F27:H27)/SUM(F25:H25)","v":0.8057744076145491},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"(*) Asumimos crecimiento de ventas en sistemas aislados del año 2018"]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":17625.435000000001},{"$f":"+E24+E25","v":24367.993999999999},25069.998,27032.792000000005,28138.757000000001,{"$f":"H23*(1+$C$19)","v":29686.388634999999},{"$f":"I23*(1+$C$19)","v":31319.140009924999},33041.692710470874,34858.985809546772,36776.230029071841,38798.922680670788,40932.863428107681]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",17625.435000000001,24367.993999999999,25069.998,27032.792000000005,28138.757000000001,{"$f":"+I23-I24","v":29686.388634999999},{"$f":"+J23-J24","v":31319.140009924999},33041.692710470874,34858.985809546772,36776.230029071841,38798.922680670788,40932.863428107681]
[null,"Combustible Fósil","MPC",null,282967.19999999995,292904.17000000004,368663.22899999999,401645.36199999996,{"$f":"+I25*$C$12","v":393349.1863602451},{"$f":"+J25*$C$12","v":414983.39161005861},437807.47814861184,461886.8894467855,487290.66836635862,514091.65512650833,542366.69615846628]
[null,"Energía Vendida","MWh",19097.196999999996,19975.205000000002,20153.143000000004,21583.880999999998,22919.561000000002,{"$f":"I25*$C$20","v":23920.532216582407},{"$f":"J25*$C$20","v":25236.161488494439},26624.150370361633,28088.478640731522,29633.344965971755,31263.178939100198,32982.653780750712]
[null,"Cantidad de Usuarios",null,10731,11261,11717,12254,12941]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":148.30240269623829},{"$f":"(E27*1000/E28)/12","v":147.819946422757},{"$f":"(F27*1000/F28)/12","v":143.33264345253338},{"$f":"(G27*1000/G28)/12","v":146.7811938958707},{"$f":"(H27*1000/H28)/12","v":147.59009478917136}]
[null,"Demanda Máxima","MW",null,null,5.91,5.96,6.1]
[null,"Potencia Instalada","MW",10.199000000000002,9.23,12.22,15.419,{"$f":"+C10","v":14.443999999999999}]
[null,"Pot. Efectiva a Temp. Media","MW",8.15,7.35,9.6,12.399999999999999,{"$f":"+C11","v":11.55}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.24687557777964536},{"$f":"E25/(E32*8760)","v":0.37846727549467274},{"$f":"F25/(F32*8760)","v":0.29811165810502283},{"$f":"G25/(G32*8760)","v":0.2488657386949478},{"$f":"H25/(H32*8760)","v":0.2781114175018285}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":5.7289758000000003E-2},{"$f":"+#REF!","v":{"$error":"#REF!"}},"Gas Natural"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D25","v":17625.435000000001},{"$f":"+E25","v":24367.993999999999},25069.998,27032.792000000005,28138.757000000001,29686.388634999999,31319.140009924999,33041.692710470874,34858.985809546772,36776.230029071841,38798.922680670788,40932.863428107681]
[null,"F  i,j,bl =","MMBTU",null,{"$f":"E26*1000*940/1000000","v":265989.16799999995},{"$f":"F26*1000*940/1000000","v":275329.91980000003},346543.43526,377546.64027999993,369748.23517863045,390084.38811345509,411539.02945969516,434173.67607997841,458053.22826437716,483246.15581891785,509824.69438895828]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"D44*$C$40/D43","v":0},{"$f":"SUM(E44)*$C$40/SUM(E43)","v":0.62534712809521142},{"$f":"SUM(E44:F44)*$C$40/SUM(E43:F43)","v":0.62729164932189707},{"$f":"SUM(E44:G44)*$C$40/SUM(E43:G43)","v":0.66516160058430718},{"$f":"SUM(F44:H44)*$C$40/SUM(F43:H43)","v":0.71355216610404737},{"$f":"+H45","v":0.71355216610404737},0.71355216610404737,0.71355216610404737,0.71355216610404737,0.71355216610404737,0.71355216610404737,0.71355216610404737]
[null,"BE y =","tCO2/año",null,{"$f":"+E43*E45","v":15238.455065341343},{"$f":"+F43*F45","v":15726.200393916661},17981.175194982658,20078.471008825425,21182.786914310822,22347.840194597917,23576.971405300803,24873.70483259235,26241.758598384924,27685.055321296095,29207.733363967378]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":10.199000000000002},9.23,12.22,15.419,14.443999999999999,{"$f":"+H49","v":14.443999999999999},{"$f":"+I49","v":14.443999999999999},14.443999999999999,14.443999999999999,14.443999999999999,14.443999999999999,14.443999999999999]
[null,"Pot. Efectiva a Temp. Media","MW",8.15,7.35,9.6,12.399999999999999,11.55,{"$f":"+H50","v":11.55},11.55,11.55,11.55,11.55,11.55,11.55]
[null,"Factor de Planta",null,0.24687557777964536,0.37846727549467274,0.29811165810502283,0.2488657386949478,0.2781114175018285,{"$f":"I25/(I50*8760)","v":0.29340754546442904},{"$f":"J25/(J50*8760)","v":0.3095449604649726},0.32656993329054612,0.34453127962152613,0.36348050000071003,0.38347192750074904,0.40456288351329023]
[null,"Adiciones de capacidad","MW",{"$nulls":8},{"$f":"+L49-K49","v":0},{"$f":"+M49-L49","v":0},{"$f":"+N49-M49","v":0},{"$f":"+O49-N49","v":0}]
[]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"F  i,j,bl =","MMBTU","Cantidad de Combustible i (masa o volumen) consumido por la fuente j (planta)"]
[null,"EF bl,ini =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado, al momento de la interconexión a la red"]
[null,"COEF  i,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible \"i\""]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
{"$rows_empty":8}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[]
[null,"Emisiones del Proyecto"]
[null,"Utilizamos el factor de emisiones del Sistema Interconectado Nacional (SIN)",0.48]
[]
[]
[null,"Donde:"]
[null,"EG y =","Electricidad abastecida al sistema Aislado por la red (SIN) en el año y (MWh)"]
[null,"EF p =","Factor de Emisión de Red (SIN) método simple promedio"]
[null,"TL =",2.6814880952380937E-2,"Perdidas de energía en la red de transmisión del SIN "]
[null,"PE sf6,y =",0,"La red de transmisión nueva no tiene SF6"]
[]
[null,null,null,{"$f":"+D42","v":2014},{"$f":"+E42","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y(*) =","MWh",{"$nulls":7},{"$f":"+K25*0.7/12*3","v":5782.2962243324027},{"$f":"+L25*0.7","v":24401.290066682737},{"$f":"+M25*0.7","v":25743.361020350287},{"$f":"+N25*0.7","v":27159.245876469551},{"$f":"+O25*0.7","v":28653.004399675374}]
[null,{"$f":"+B82","v":"TL ="},"%",{"$nulls":7},{"$f":"+C82","v":2.6814880952380937E-2},{"$f":"+K87","v":2.6814880952380937E-2},2.6814880952380937E-2,2.6814880952380937E-2,2.6814880952380937E-2]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":7},{"$f":"+C76","v":0.48},0.48,0.48,0.48,0.48]
[null,"PE y =","tCO2/año",{"$nulls":7},{"$f":"K86*K88*(K87+1)","v":2849.9269484252532},{"$f":"L86*L88*(L87+1)","v":12026.691722354568},{"$f":"M86*M88*(M87+1)","v":12688.159767084069},{"$f":"N86*N88*(N87+1)","v":13386.008554273691},{"$f":"O86*O88*(O87+1)","v":14122.239024758743}]
[null,"(*) Asumimos que un 70% de la energía vendría de la red (SIN)"]
[]
[]
[null,null,null,{"$f":"+D85","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Emisiones Planta Sistema Aislado","tCO2/año",{"$f":"+D46","v":0},15238.455065341343,15726.200393916661,17981.175194982658,20078.471008825425,21182.786914310822,22347.840194597917,23576.971405300803,24873.70483259235,26241.758598384924,27685.055321296095,29207.733363967378]
[]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D25-D86","v":17625.435000000001},{"$f":"+E25-E86","v":24367.993999999999},25069.998,27032.792000000005,28138.757000000001,29686.388634999999,31319.140009924999,27259.39648613847,10457.695742864034,11032.869008721555,11639.676804201237,12279.859028432307]
[null,"Combustible Fósil","MPC",{"$f":"+D26","v":0},{"$f":"+E26","v":282967.19999999995},292904.17000000004,368663.22899999999,401645.36199999996,393349.1863602451,414983.39161005861,{"$f":"+K98*$C$12","v":361191.16947260476},{"$f":"+L98*$C$12","v":138566.06683403568},146187.20050990762,154227.49653795251,162710.00884753992]
[null,"Emisiones Planta Interconectada","tCO2/año",{"$f":"+(D25-D86)*D45","v":0},{"$f":"+(E25-E86)*E45","v":15238.455065341343},15726.200393916661,17981.175194982658,20078.471008825425,21182.786914310822,22347.840194597917,{"$f":"+(K25-K86)*K45","v":19451.001409373162},7462.1114497777062,7872.5275795154794,8305.5165963888285,8762.3200091902163]
[null,"Emisiones del Proyecto","tCO2/año",{"$f":"D89","v":0},{"$f":"E89","v":0},0,0,0,0,0,2849.9269484252532,12026.691722354568,12688.159767084069,13386.008554273691,14122.239024758743]
[null,"Total Emisiones con Proyecto","tCO2/año",{"$f":"+D101+D100","v":0},15238.455065341343,15726.200393916661,17981.175194982658,20078.471008825425,21182.786914310822,22347.840194597917,22300.928357798417,19488.803172132273,20560.687346599549,21691.525150662521,22884.559033948957]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",{"$f":"+D102/D23","v":0},{"$f":"+E102/E23","v":0.62534712809521142},0.62729164932189707,0.66516160058430718,0.71355216610404726,0.71355216610404726,0.71355216610404737,0.67493298703583904,0.55907544983121416,0.55907544983121427,0.55907544983121427,0.55907544983121416]
[]
[null,"Emisiones Reducidas","tCO2/año",{"$f":"+D95-D102","v":0},{"$f":"+E95-E102","v":0},0,0,0,0,0,1276.0430475023859,5384.9016604600765,5681.0712517853754,5993.530170633574,6323.1743300184207]

{"sheet":"Chiquitos","index":8,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[16,5,16,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,18]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Santa Cruz"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Chiquitos"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Roboré y Santiago de Chiquitos"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"CRE Ltda."}]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Gas"}]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":9.879999999999999}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":7.54}]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":7.2}]
[null,"Consumo especifico (pc/kWh)",{"$f":"SUM(F26:H26)/SUM(F25:H25)","v":10.919593301706577}]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Pequeña Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AMS I.A",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"(H25/E25)^(1/3)-1","v":6.1010979753981731E-2},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(F27:H27)/SUM(F25:H25)","v":0.83618684261099208}]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":16495.100058046999},{"$f":"+E24+E25","v":18492.52734375},19606.297000000006,21045.854060999998,22087.9751005,{"$f":"H23*(1+$C$19)","v":23435.584102163059},{"$f":"I23*(1+$C$19)","v":24865.412049342864},26382.475200459736,27992.095860774909,29699.921054608163,31511.942336765718,33434.51681268277]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",16495.100058046999,18492.52734375,19606.297000000006,21045.854060999998,22087.9751005,{"$f":"+I23-I24","v":23435.584102163059},{"$f":"+J23-J24","v":24865.412049342864},26382.475200459736,27992.095860774909,29699.921054608163,31511.942336765718,33434.51681268277]
[null,"Combustible Fósil","MPC",178080.859,202608.06300730753,217565.0922305714,229197.23259043324,238334.33656033641,{"$f":"+I25*$C$12","v":255907.04718356088},{"$f":"+J25*$C$12","v":271520.18685817835},288085.89948138001,305662.30246204609,324311.05900911341,344097.59446431085,365091.32583356672]
[null,"Energía Vendida","MWh",13815.352999999999,15455.154000000002,16493.128000000001,17568.087,18401.253000000001,{"$f":"I25*$C$20","v":19596.52707513209},{"$f":"J25*$C$20","v":20792.130391761326},22060.678638135225,23406.622255885592,24834.683212448526,26349.871567119775,27957.503047821338]
[null,"Cantidad de Usuarios",null,6760,7040,7747,8138,8470]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D27*1000/D28)/12","v":170.3076060157791},{"$f":"(E27*1000/E28)/12","v":182.94453125000004},{"$f":"(F27*1000/F28)/12","v":177.41413880641969},{"$f":"(G27*1000/G28)/12","v":179.89767141803884},{"$f":"(H27*1000/H28)/12","v":181.04341794569066}]
[null,"Demanda Máxima","MW",null,null,4.0962399999999999,4.5239889999999994,4.3802180000000002]
[null,"Potencia Instalada","MW",5.84,5.84,5.84,5.84,{"$f":"+C10","v":7.54}]
[null,"Pot. Efectiva a Temp. Media","MW",4.84,4.84,4.84,4.84,{"$f":"+C11","v":7.2}]
[null,"Factor de Planta ",null,{"$f":"D25/(D32*8760)","v":0.38905005986185798},{"$f":"E25/(E32*8760)","v":0.43616097172888596},{"$f":"F25/(F32*8760)","v":0.46243011528736944},{"$f":"G25/(G32*8760)","v":0.49638321401279289},{"$f":"H25/(H32*8760)","v":0.35020254788971333}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G18","v":5.7289758000000003E-2},{"$f":"+H18","v":"gCO2/BTU"},"Gas Natural"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"GEN  j,bl =","MWh",{"$f":"+D23","v":16495.100058046999},{"$f":"+E23","v":18492.52734375},19606.297000000006,21045.854060999998,22087.9751005,23435.584102163059,24865.412049342864,26382.475200459736,27992.095860774909,29699.921054608163,31511.942336765718,33434.51681268277]
[null,"FC  j,y =","MPC",{"$f":"+D26","v":178080.859},202608.06300730753,217565.0922305714,229197.23259043324,238334.33656033641,255907.04718356088,271520.18685817835,288085.89948138001,305662.30246204609,324311.05900911341,344097.59446431085,365091.32583356672]
[null,"NCV j =","Btu/pc",940,940,940,940,940,940,940,940,940,940,940,940]
[null,"EF co2,j =","gCO2/BTU",{"$f":"+C40","v":5.7289758000000003E-2},{"$f":"+D46","v":5.7289758000000003E-2},{"$f":"+E46","v":5.7289758000000003E-2},5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2,5.7289758000000003E-2]
[null,"BE y =","tCO2/año",{"$f":"+D46*D45*D44/1000","v":9590.0767575495956},{"$f":"+E46*E45*E44/1000","v":10910.924884625158},{"$f":"+F46*F45*F44/1000","v":11716.396394148889},{"$f":"+G46*G45*G44/1000","v":12342.814750013096},{"$f":"+H46*H45*H44/1000","v":12834.869476754293},13781.201635422338,14622.00624938663,15514.109176630551,16460.640177507019,17464.91996211448,18530.471840327958,19661.034082609938]
[null,"EF bl =","tCO2/MWh",{"$f":"D47/D43","v":0.58138942618121048},{"$f":"E47/E43","v":0.59001804792857426},{"$f":"SUM(D47:F47)/SUM(D43:F43)","v":0.59012790139818516},{"$f":"SUM(E47:G47)/SUM(E43:G43)","v":0.5912642856804956},0.58804600625039938,{"$f":"I47/I43","v":0.58804600625039938},{"$f":"J47/J43","v":0.58804600625039938},0.58804600625039927,0.58804600625039927,0.58804600625039938,0.58804600625039938,0.58804600625039949]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":5.84},5.84,5.84,5.84,7.54,{"$f":"+H51","v":7.54},{"$f":"+I51","v":7.54},7.54,{"$f":"+K51","v":7.54},{"$f":"+L51+1","v":8.5399999999999991},{"$f":"+M51+1","v":9.5399999999999991},10.54]
[null,"Pot. Efectiva a Temp. Media","MW",4.84,4.84,4.84,4.84,7.2,{"$f":"+H52","v":7.2},7.2,7.2,{"$f":"$K$52/$K$51*L51","v":7.2},{"$f":"$K$52/$K$51*M51","v":8.1549071618037132},9.1098143236074272,10.064721485411141]
[null,"Factor de Planta",null,0.38905005986185798,0.43616097172888596,0.46243011528736944,0.49638321401279289,0.35020254788971333,{"$f":"I25/(I52*8760)","v":0.3715687484488055},{"$f":"J25/(J52*8760)","v":0.39423852183762786},0.41829140031170309,0.44381176846738501,0.41574991346966905,0.39487673004372742,0.37921820977168841]
[null,"Adiciones de capacidad","MW",{"$nulls":8},{"$f":"+L51-K51","v":0},{"$f":"+M51-L51","v":0.99999999999999911},{"$f":"+N51-M51","v":1},{"$f":"+O51-N51","v":1}]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"FC  j,y =","MPC","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"NCV j =","Btu/pc","Poder Calorífico Inferior del combustible \"j\""]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado"]
[null,"EF co2,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]

{"sheet":"Huacaraje","index":9,"n_rows":108,"n_cols":15,"rows_kept":108,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[16,5,16,7],[74,1,77,4],[78,1,78,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,12]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Beni"},null,null,"Hibridación/Desplazamiento de energía fósil",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Itenez"}]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Huacaraje"},null,null,"Proyecto:","Planta Solar Huacaraje"]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"ENDE DELBENI S.A.M."},null,null,null,"Potencia Instalada MW",250,"kWp"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"},null,null,null,"Potencia a Temp. Media",{"$f":"+H7*0.95","v":237.5},"kWp"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":0.58000000000000007},null,null,null,"Mes/Año de puesta en operación","2021-05-01"]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":0.46400000000000002},null,null,null,"Factor de Planta",0.13736980593607304]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":0.39800000000000002},null,null,null,"Categoría","Pequeña Escala"]
[null,"Consumo especifico (lts/kWh)",{"$f":"SUM(H26)/SUM(H25)","v":0.31256699756248457},null,null,null,"Metodología Aplicable","AMS I.A"]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA"]
[16,"Potencia Instalada MW"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Pequeña Escala",null,null,"Factores de Emisiones"]
[null,"Metodología Aplicable Línea de Base","AMS I.A",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual ",{"$f":"H25/G25-1","v":1.5149920384314175E-3},null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(G27:H27)/SUM(G25:H25)","v":0.86183970738265214}]
[]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D24+D25","v":0},{"$f":"+E24+E25","v":0},190,679.30499999999995,680.3341416666666,{"$f":"+H23*(1+$C$19)","v":681.36484247476471},{"$f":"+I23*(1+$C$19)","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",null,null,190,679.30499999999995,680.3341416666666,{"$f":"+I23-I24","v":681.36484247476471},{"$f":"+J23-J24","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Combustible Fósil","Miles de Litros",null,null,null,284.65100000000001,212.65,{"$f":"+I25*$C$12","v":212.97216305697248},{"$f":"+J25*$C$12","v":213.29481418841129},213.61795413374546,213.94158363352409,214.26570342941829,214.59031426422277,214.91541688185757]
[null,"Energía Vendida","MWh",null,null,153.167,575.524,596.26700000000005,{"$f":"I25*$C$20","v":587.22727645927807},{"$f":"J25*$C$20","v":588.11692110786373},589.00791356100888,589.90025586062688,590.79395005172444,591.68899818240629,592.58540230388007]
[null,"Cantidad de Usuarios",null,null,null,406,490,505]
[null,"Consumo  por usuario","kWh/usuario-mes",null,null,{"$f":"(F27*1000/F28)/12","v":31.438218390804597},{"$f":"(G27*1000/G28)/12","v":97.878231292517},{"$f":"(H27*1000/H28)/12","v":98.393894389438955}]
[null,"Demanda Máxima","MW",null,null,null,0.16900000000000001,0.159]
[null,"Potencia Instalada","MW",null,null,0.56999999999999995,0.69499999999999995,{"$f":"+C10","v":0.46400000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",null,null,0.13,0.64800000000000002,{"$f":"+C11","v":0.39800000000000002}]
[null,"Factor de Planta ",null,null,null,{"$f":"F25/(F32*8760)","v":0.16684229012996138},{"$f":"G25/(G32*8760)","v":0.11967011246406221},{"$f":"H25/(H32*8760)","v":0.19513496181439921}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":7.6597356000000005E-2},{"$f":"+H19","v":"gCO2/BTU"},"Diesel"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",null,null,{"$f":"+F23","v":190},679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"GEN  j,bl =","MWh",null,null,{"$f":"+F25","v":190},679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"FC  j,y =","Miles de Litros",null,null,null,284.65100000000001,212.65,212.97216305697248,213.29481418841129,213.61795413374546,213.94158363352409,214.26570342941829,214.59031426422277,214.91541688185757]
[null,"NCV j =","Btu/l",null,null,null,33710,{"$f":"+G46","v":33710},{"$f":"+H46","v":33710},33710,33710,33710,33710,33710,33710]
[null,"EF co2,j =","gCO2/BTU",null,null,null,{"$f":"+C40","v":7.6597356000000005E-2},{"$f":"+G47","v":7.6597356000000005E-2},7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2]
[null,"BE y =","tCO2/año",null,null,null,{"$f":"+G47*G46*G45/1000","v":734.99645635870479},{"$f":"+H47*H46*H45/1000","v":549.08289956711405},549.9147557883972,550.74787226523244,551.58225090689734,552.41789362556142,553.25480233629116,554.09297895705458,554.93242540872529]
[null,"EF bl =","tCO2/MWh",null,null,null,{"$f":"+G48/G43","v":1.0819829919678272},{"$f":"+H48/H43","v":0.80707826630893997},{"$f":"+I48/I43","v":0.80707826630894008},{"$f":"+J48/J43","v":0.80707826630893986},0.80707826630893997,0.80707826630893997,0.80707826630893997,0.80707826630893986,0.80707826630893997]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":0},0,0.56999999999999995,0.69499999999999995,0.46400000000000002,{"$f":"+H52","v":0.46400000000000002},{"$f":"($H$52/$H$53)*J53","v":0.54432945465107774},{"$f":"+J52","v":0.54432945465107774},{"$f":"($H$52/$H$53)*L53","v":0.54598001357667936},{"$f":"+L52","v":0.54598001357667936},{"$f":"($H$52/$H$53)*N53","v":0.54763557745790781},{"$f":"+N52","v":0.54763557745790781}]
[null,"Pot. Efectiva a Temp. Media","MW",0,0,0.13,0.64800000000000002,0.39800000000000002,{"$f":"I25/(I54*8760)","v":0.46619699748273369},0.46690328222226068,0.4676106369775449,0.46831906336965173,0.46902856302210244,0.46973913756087787,0.47045078861442224]
[null,"Factor de Planta",null,0,0,0.16684229012996138,0.11967011246406221,0.19513496181439921,{"$f":"+F54","v":0.16684229012996138},{"$f":"+I54","v":0.16684229012996138},0.16684229012996138,0.16684229012996138,0.16684229012996138,0.16684229012996138,0.16684229012996138]
[null,"Adiciones de capacidad","MW",{"$nulls":8},{"$f":"+L52-K52","v":1.6505589256016195E-3},{"$f":"+M52-L52","v":0},{"$f":"+N52-M52","v":1.6555638812284501E-3},{"$f":"+O52-N52","v":0}]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"FC  j,y =","Miles de litros","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"NCV j =","Btu/litro","Poder Calorífico Inferior del combustible \"j\""]
[null,"EF co2,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año \"y\""]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado"]
{"$rows_empty":9}
[null,"ACTIVIDADES DEL PROYECTO"]
[null,"Las emisiones de referencia se calculan considerando el consumo de combustible que se hubiera utilizado para generar la cantidad equivalente de energía en ausencia de la actividad del proyecto."]
[]
[]
[]
[null,"Opción 2: basada en la generación anual de electricidad por la actividad del proyecto"]
[null,"Calculo de línea :"]
[{"$nulls":5},"Ecuación 1"]
[]
[{"$nulls":5},"Ecuación 2"]
[null,"Donde:"]
[null,"E BL,y  =","MWh","Línea de Base de Energía, y"]
[null,"EG i,y  =","MWh","Electricidad generada por las actividades del proyecto en el año  y"]
[null,"TDL  =","%","Promedio histórico de perdidas técnicas (Transmisión y distribución)"]
[null,"EF CO2,y =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado "]
[null,"BE CO2, y =","tCO2/año","Línea de Base de Emisiones"]
[]
[null,null,null,{"$f":"+D42","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG  i,y =","MWh",{"$nulls":7},{"$f":"L92/12*8","v":190.53192083333332},{"$f":"+H8*H10*8760/1000","v":285.79788124999999},{"$f":"+L92","v":285.79788124999999},{"$f":"+M92","v":285.79788124999999},{"$f":"+N92","v":285.79788124999999}]
[null,"TDL  =","%",{"$nulls":7},{"$f":"1-$C$20","v":0.13816029261734786},{"$f":"1-$C$20","v":0.13816029261734786},0.13816029261734786,0.13816029261734786,0.13816029261734786]
[null,"E BL,y =","MWh",{"$nulls":7},{"$f":"+K92*(1-K93)","v":164.20797489805463},{"$f":"+L92*(1-L93)","v":246.31196234708196},{"$f":"+M92*(1-M93)","v":246.31196234708196},{"$f":"+N92*(1-N93)","v":246.31196234708196},{"$f":"+O92*(1-O93)","v":246.31196234708196}]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":7},{"$f":"(H48/H23)","v":0.80707826630893997},{"$f":"+K95","v":0.80707826630893997},{"$f":"+L95","v":0.80707826630893997},{"$f":"+M95","v":0.80707826630893997},{"$f":"+N95","v":0.80707826630893997}]
[null,"BE CO2, y =","tCO2/año",{"$nulls":7},{"$f":"+K95*K94","v":132.52868769482387},{"$f":"+L95*L94","v":198.79303154223581},198.79303154223581,198.79303154223581,198.79303154223581]
[]
[]
[]
[null,null,null,{"$f":"+D91","v":2014},{"$f":"+E91","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Generación total","MWh",{"$f":"+D23","v":0},{"$f":"+E23","v":0},190,679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D48","v":0},0,0,734.99645635870479,549.08289956711405,549.9147557883972,550.74787226523244,551.58225090689734,552.41789362556142,553.25480233629116,554.09297895705458,554.93242540872529]
[null,"Con Proyecto"]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D25-D92","v":0},{"$f":"+E25-E92","v":0},190,679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,492.89901013384781,398.66844213641417,399.70540316691898,400.74393518512926,401.78404057107872]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+D26","v":0},{"$f":"+E26","v":0},0,284.65100000000001,212.65,{"$f":"+I105*$C$12","v":212.97216305697248},{"$f":"+J105*$C$12","v":213.29481418841129},{"$f":"+K105*$C$12","v":154.06396369905747},124.61059798149209,124.93471777738628,125.25932861219077,125.58443122982557]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D103-D96","v":0},0,0,734.99645635870479,549.08289956711405,549.9147557883972,550.74787226523244,419.05356321207347,353.62486208332564,354.46177079405538,355.2999474148188,356.13939386648951]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",null,null,null,{"$f":"G107/G102","v":1.0819829919678272},0.80707826630893997,0.80707826630894008,0.80707826630893986,0.61316154160455572,0.51664318608658177,0.51708252732232551,0.51752120396644596,0.51795921702427106]

{"sheet":"Rosario del Yata","index":10,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[2,18,2,22],[7,18,7,19],[16,5,16,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS PREVISTOS"]
[null,null,8,{"$nulls":15},"IPPC - DATA"]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Beni"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X",{"$nulls":7},"EFCO2,GAS",5.4300000000000001E-2,"tCO2/GJ","kgCO2/MJ","Source for Gas EF - IPCC 2006 (Lower value)"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Vaca Diez"},{"$nulls":15},"EFCO2,DIESEL",7.2599999999999998E-2,"tCO2/GJ","kgCO2/MJ","Source for Diesel EF - IPCC 2006 (Lower value)"]
[4,"Sistema Eléctrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"Rosario del Yata"},{"$nulls":17},"Value","Units"]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"ENDE DELBENI S.A.M."},{"$nulls":17},1.05506E-3,"MJ/Btu"]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"},{"$nulls":15},"Conversion factors",null,1.05506E-6,"GJ/Btu"]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":1.2080000000000002}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":0.96640000000000004},{"$nulls":15},"Emission Factors"]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":0.77312000000000014},{"$nulls":16},"CO2 Emissions Factor Natural Gas",{"$f":"T4*1000000","v":54300},"gCO2/GJ"]
[null,"Consumo especifico (lts/kWh)",{"$f":"SUM(G26:H26)/SUM(G25:H25)","v":0.45269186812040735},{"$nulls":16},"CO2 Emissions Factor Natural Gas (g/BTU)",{"$f":"U11*U8","v":5.7289758000000003E-2},"gCO2/BTU"]
[8,"Energía Alternativa"]
[11,"Potencia Instalada MVA",{"$nulls":17},"CO2 Emissions Factor Natural Diesel",{"$f":"T5*1000000","v":72600},"gCO2/GJ"]
[16,"Potencia Instalada MW",{"$nulls":17},"CO2 Emissions Factor Diesel (g/BTU)",{"$f":"U14*U8","v":7.6597356000000005E-2},"gCO2/BTU"]
[22,"Potencia a Temp. Media"]
[null,"Categoría","Pequeña Escala",null,null,"Factores de Emisiones",{"$nulls":13},"Oxidation Factor Natural Gas",1,"Source for Gas OXID - IPCC 2006"]
[null,"Metodología Aplicable Línea de Base","AMS I.A",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU",{"$nulls":11},"Oxidation FactorDiesel",1,"Source for Gas OXID - IPCC 2006"]
[null,"% Crecimiento Acumulativo Anual (*)",5.5E-2,null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energía Vendida/Generación Bruta",{"$f":"SUM(H27)/SUM(H25)","v":0.7700524158518598}]
[null,"(*) Asumimos crecimiento de ventas en sistemas aislados del año 2018"]
[null,null,"Unidades",2014,{"$f":"+D22+1","v":2015},{"$f":"+E22+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",null,null,null,{"$f":"+G24+G25","v":58.606000000000009},171.51299999999998,{"$f":"H23*(1+$C$19)","v":180.94621499999997},{"$f":"I23*(1+$C$19)","v":190.89825682499995},201.39766095037493,212.47453230264554,224.16063157929102,236.489466316152,249.49638696354035]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación","MWh",null,null,null,58.606000000000009,171.51299999999998,{"$f":"+I23-I24","v":180.94621499999997},{"$f":"+J23-J24","v":190.89825682499995},201.39766095037493,212.47453230264554,224.16063157929102,236.489466316152,249.49638696354035]
[null,"Combustible Fósil","Miles de Litros",null,null,null,25.082999999999998,79.09,{"$f":"+I25*$C$12","v":81.912880097666857},{"$f":"+J25*$C$12","v":86.418088503038533},91.171083370705645,96.18549295609445,101.47569506867963,107.056858297457,112.94498550381712]
[null,"Energía Vendida","MWh",null,null,null,45.708000000000006,132.07400000000001,{"$f":"I25*$C$20","v":139.33807000000002},{"$f":"J25*$C$20","v":147.00166385},155.08675536174997,163.61652690664621,172.61543588651173,182.10928486026987,192.12529552758471]
[null,"Cantidad de Usuarios",{"$nulls":4},131,148]
[null,"Consumo  por usuario","kWh/usuario-mes",null,null,null,{"$f":"(G27*1000/G28)/12","v":29.076335877862601},{"$f":"(H27*1000/H28)/12","v":74.365990990990994}]
[null,"Demanda Máxima","MW",null,null,null,3.5999999999999997E-2,4.8000000000000001E-2]
[null,"Potencia Instalada","MW",null,null,null,0.2,{"$f":"+C10","v":0.96640000000000004}]
[null,"Pot. Efectiva a Temp. Media","MW",null,null,null,0.17499999999999999,{"$f":"+C11","v":0.77312000000000014}]
[null,"Factor de Planta ",{"$nulls":4},{"$f":"G25/(G32*8760)","v":3.8229615133724727E-2},{"$f":"H25/(H32*8760)","v":2.5324800275560184E-2}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emisión"]
[null,"EF CO2,j = COEF  i,j =",{"$f":"+G19","v":7.6597356000000005E-2},{"$f":"+H19","v":"gCO2/BTU"},"Diesel"]
[]
[null,null,null,{"$f":"+D22","v":2014},{"$f":"+E22","v":2015},{"$f":"+F22","v":2016},{"$f":"+G22","v":2017},{"$f":"+H22","v":2018},{"$f":"+H42+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",null,null,null,{"$f":"+G23","v":58.606000000000009},171.51299999999998,180.94621499999997,190.89825682499995,201.39766095037493,212.47453230264554,224.16063157929102,236.489466316152,249.49638696354035]
[null,"GEN  j,bl =","MWh",null,null,null,{"$f":"+G25","v":58.606000000000009},171.51299999999998,180.94621499999997,190.89825682499995,201.39766095037493,212.47453230264554,224.16063157929102,236.489466316152,249.49638696354035]
[null,"FC  j,y =","Miles de Litros",null,null,null,25.082999999999998,79.09,81.912880097666857,86.418088503038533,91.171083370705645,96.18549295609445,101.47569506867963,107.056858297457,112.94498550381712]
[null,"NCV j =","Btu/l",null,null,null,33710,{"$f":"+G46","v":33710},{"$f":"+H46","v":33710},33710,33710,33710,33710,33710,33710]
[null,"EF co2,j =","gCO2/BTU",null,null,null,{"$f":"+C40","v":7.6597356000000005E-2},{"$f":"+G47","v":7.6597356000000005E-2},{"$f":"+H47","v":7.6597356000000005E-2},7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,{"$f":"+N47","v":7.6597356000000005E-2}]
[null,"BE y =","tCO2/año",null,null,null,{"$f":"+G47*G46*G45/1000","v":64.766735809273072},{"$f":"+H47*H46*H45/1000","v":204.21804150840842},211.50699137512467,223.13987590075655,235.41256907529811,248.36026037443949,262.02007469503366,276.43117880326042,291.63489363743975]
[null,"EF bl =","tCO2/MWh",null,null,null,{"$f":"+G48/G43","v":1.1051212471295271},{"$f":"+H48/H43","v":1.1906854961921747},1.1688942560922024,1.1688942560922027,1.1688942560922024,1.1688942560922024,1.1688942560922024,1.1688942560922022,1.1688942560922024]
[]
[null,"Evolución Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D31","v":0},0,0,0.2,0.96640000000000004,{"$f":"+H52","v":0.96640000000000004},{"$f":"+I52","v":0.96640000000000004},0.96640000000000004,0.96640000000000004,0.96640000000000004,0.96640000000000004,0.96640000000000004]
[null,"Pot. Efectiva a Temp. Media","MW",0,0,0,0.17499999999999999,0.77312000000000014,{"$f":"+H53","v":0.77312000000000014},0.77312000000000014,0.77312000000000014,0.77312000000000014,0.77312000000000014,0.77312000000000014,0.77312000000000014]
[null,"Factor de Planta",null,0,0,0,3.8229615133724727E-2,2.5324800275560184E-2,{"$f":"I25/(I53*8760)","v":2.6717664290715992E-2},{"$f":"J25/(J53*8760)","v":2.8187135826705369E-2},2.9737428297174164E-2,3.137298685351874E-2,3.3098501130462268E-2,3.491891869263769E-2,3.6839459220732756E-2]
[null,"Adiciones de capacidad","MW",{"$nulls":5},{"$f":"+I52-H52","v":0},0,0,{"$f":"+L52-K52","v":0},{"$f":"+M52-L52","v":0},{"$f":"+N52-M52","v":0},{"$f":"+O52-N52","v":0}]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"FC  j,y =","Miles de litros","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"NCV j =","Btu/litro","Poder Calorífico Inferior del combustible \"j\""]
[null,"EF co2,j =","gCO2/BTU","Coeficiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año \"y\""]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado"]

{"sheet":"El Sena","index":11,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,10],[17,5,17,7]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO",null,null,null,"PROYECTOS POREVISTOS"]
[null,null,2,"S2"]
[2,"Departamento",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A4,0)","v":"Pando"},null,null,"NO TIENE PROYECTOS PREVISTOS, SOLO EXPANSION COMB. FOSIL",{"$nulls":4},"X"]
[3,"Provincia",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A5,0)","v":"Madre de Dios"},{"$nulls":10}," "]
[4,"Sistema Electrico",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A6,0)","v":"El Sena"}]
[5,"Empresa",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A7,0)","v":"ENDE"}]
[6,"Combustible",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A8,0)","v":"Diesel"}]
[10,"Potencia Instalada MVA",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A9,0)","v":2.7669999999999999}]
[15,"Potencia Instalada MW",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A10,0)","v":2.2160000000000002}]
[21,"Potencia a Temp. Media",{"$f":"VLOOKUP($C$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A11,0)","v":1.2999999999999998}]
[null,"Consumo especifico (lts/kWh)",{"$f":"SUM(F27:H27)/SUM(F26:H26)","v":0.31205778586083632}]
[8,"Energia Alternativa",null,"Solar(*)"]
[11,"Potencia Instalada MVA",null,{"$f":"VLOOKUP($D$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A14,0)","v":0.4}]
[16,"Potencia Instalada MW",null,{"$f":"VLOOKUP($D$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A15,0)","v":0.4}]
[22,"Potencia a Temp. Media",null,{"$f":"VLOOKUP($D$3,'[11]Potencia Inst y Efect'!$A$9:$W$40,A16,0)","v":0}]
[null,"(*) Ingresa en operación el 01/10/2018"]
[null,"Categoria","Pequeña Escala",null,null,"Factores de Emisiones"]
[null,"Metodologia Aplicable","AMS I.A",null,null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"% Crecimiento Acumulativo Anual (*)",5.5E-2,null,null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"Factor  Energia Vendida/Generacion Bruta",{"$f":"SUM(F28:H28)/SUM(F26:H26)","v":0.8870624006250849}]
[null,"(*) Asumimos crecimiento de ventas en sistemas aislados del año 2018"]
[null,null,"Unidades",2014,{"$f":"+D23+1","v":2015},{"$f":"+E23+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generacion Total","MWh",{"$f":"+D25+D26","v":646.00490000000002},{"$f":"+E25+E26","v":1248.1833999999999},1677.7593999999997,1881.0661,2309.0619999999999,{"$f":"H24*(1+$C$20)","v":2436.0604099999996},{"$f":"I24*(1+$C$20)","v":2570.0437325499993},2711.3961378402491,2860.5229254214628,3017.8516863196432,3183.8335290672235,3358.9443731659208]
[null,"Generacion Energia Renovable","MWh",{"$nulls":4},95.87,203.29068000000001,{"$f":"+I25","v":203.29068000000001},203.29068000000001,203.29068000000001,203.29068000000001,203.29068000000001,203.29068000000001]
[null,"Generacion","MWh",646.00490000000002,1248.1833999999999,1677.7593999999997,1881.0661,2213.192,{"$f":"+I24-I25","v":2232.7697299999995},{"$f":"+J24-J25","v":2366.7530525499992},2508.1054578402491,2657.2322454214627,2814.5610063196432,2980.5428490672234,3155.6536931659207]
[null,"Combustible Fosil","Miles de Litros",207.08499999899999,380.24799999999999,518.60700099999997,584.76199999999994,697.83399999999995,{"$f":"+I26*$C$12","v":696.75317828089715},{"$f":"+J26*$C$12","v":738.56371725812835},782.67383587910729,829.21001102424009,878.30567580235515,930.10160214326663,984.74630443292813]
[null,"Energia Vendida","MWh",327.1148,869.54600000000005,1342.3541000000002,1672.1505999999999,2105.6350000000002,{"$f":"I24*$C$21","v":2160.937595362328},{"$f":"J24*$C$21","v":2279.7891631072562},2405.1775670781549,2537.4623332674537,2677.0227615971635,2824.2590134850075,2979.5932592266827]
[null,"Cantidad de Usuarios",null,238,447,647,883,976]
[null,"Demanda Maxima","MW",null,null,0.43099999999999999,0.44500000000000001,0.67300000000000004]
[null,"Consumo  por usuario","kWh/usuario-mes",{"$f":"(D28*1000/D29)/12","v":114.5359943977591},{"$f":"(E28*1000/E29)/12","v":162.10775540641313},{"$f":"(F28*1000/F29)/12","v":172.89465481710462},{"$f":"(G28*1000/G29)/12","v":157.80960739901849},{"$f":"(H28*1000/H29)/12","v":179.78440915300544}]
[null,"Potencia Instalada","MW",null,1.42,2.2160000000000002,2.2160000000000002,{"$f":"+C10","v":2.2160000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",null,1.1000000000000001,1.2999999999999998,1.2999999999999998,{"$f":"+C11","v":1.2999999999999998}]
[null,"Factor de Planta ",null,null,{"$f":"E26/(E33*8760)","v":0.12953335408883354},{"$f":"F26/(F33*8760)","v":0.14732695820161573},{"$f":"G26/(G33*8760)","v":0.16517967158412367},{"$f":"H26/(H33*8760)","v":0.19434422198805765}]
[]
[]
[]
[]
[]
[null,"Calculo del Factor de Emision"]
[null,"COEF  i,j =",{"$f":"+G20","v":7.6597356000000005E-2},{"$f":"+H20","v":"gCO2/BTU"},"Diesel"]
[]
[null,null,null,{"$f":"+D23","v":2014},{"$f":"+E23","v":2015},{"$f":"+F23","v":2016},{"$f":"+G23","v":2017},{"$f":"+H23","v":2018},{"$f":"+H43+1","v":2019},2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",{"$f":"+D24","v":646.00490000000002},{"$f":"+E24","v":1248.1833999999999},1677.7593999999997,1881.0661,2309.0619999999999,2436.0604099999996,2570.0437325499993,2711.3961378402491,2860.5229254214628,3017.8516863196432,3183.8335290672235,3358.9443731659208]
[null,"GEN  j,bl =","MWh",{"$f":"+D26","v":646.00490000000002},1248.1833999999999,1677.7593999999997,1881.0661,2213.192,2232.7697299999995,2366.7530525499992,2508.1054578402491,2657.2322454214627,2814.5610063196432,2980.5428490672234,3155.6536931659207]
[null,"FC  j,y =","Miles de litros",{"$f":"+D27","v":207.08499999899999},380.24799999999999,518.60700099999997,584.76199999999994,697.83399999999995,696.75317828089715,738.56371725812835,782.67383587910729,829.21001102424009,878.30567580235515,930.10160214326663,984.74630443292813]
[null,"NCV j =","Btu/litro",33710,{"$f":"+D47","v":33710},{"$f":"+E47","v":33710},33710,33710,33710,33710,33710,33710,33710,33710,33710]
[null,"EF co2,j =","gCO2/BTU",{"$f":"+C41","v":7.6597356000000005E-2},{"$f":"+D48","v":7.6597356000000005E-2},7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2,7.6597356000000005E-2]
[null,"BE y =","tCO2/año",{"$f":"D46*D47*D48/1000","v":534.71353047875243},{"$f":"E46*E47*E48/1000","v":981.83717091274855},1339.0935144363282,1509.9121303393592,1801.8749877099337,1799.0842013311892,1907.0430631890868,2020.939662449169,2141.1005746685555,2267.8703370600088,2401.6124363829913,2542.7103511687383]
[null,"EF bl =","tCO2/MWh",{"$f":"+D49/D44","v":0.82772364494255757},{"$f":"+E49/E44","v":0.78661290553355268},0.79814394986332871,0.80268956542216097,0.78034933133451323,0.73852199803665353,0.74202747565580029,0.74535020325688728,0.74849970809204081,0.75148502073199686,0.7543147009594432,0.75699686231247298]
[]
[null,"Evolucion Necesidad de Potencia"]
[null,"Potencia Instalada","MW",{"$f":"+D32","v":0},1.42,2.2160000000000002,2.2160000000000002,2.2160000000000002,{"$f":"+H53","v":2.2160000000000002},{"$f":"($H$53/$H$54)*J54","v":2.3697558840131352},{"$f":"+J53","v":2.3697558840131352},{"$f":"($H$53/$H$54)*L54","v":2.6606036240208542},{"$f":"+L53","v":2.6606036240208542},{"$f":"($H$53/$H$54)*N54","v":2.9843244298429452},{"$f":"+N53","v":2.9843244298429452}]
[null,"Pot. Efectiva a Temp. Media","MW",0,1.1000000000000001,1.2999999999999998,1.2999999999999998,1.2999999999999998,{"$f":"I26/(I55*8760)","v":1.3114997022400221},{"$f":"J45/(J55*8760)","v":1.3901997514517486},{"$f":"K45/(K55*8760)","v":1.4732283033701203},1.5608234256440023,1.6532362796429481,1.7507318406118357,1.8535896574340121]
[null,"Factor de Planta",null,0,0.12953335408883354,0.14732695820161573,0.16517967158412367,0.19434422198805765,{"$f":"+H55","v":0.19434422198805765},0.19434422198805765,0.19434422198805765,0.19434422198805765,0.19434422198805765,0.19434422198805765,0.19434422198805765]
[null,"Adiciones de capacidad","MW",{"$nulls":6},{"$f":"+J53-I53","v":0.153755884013135},0,0.29084774000771896,0,0.32372080582209106,0]
[]
[null,"Donde"]
[null,"GEN  j,bl =","MWh","Electricidad (MWh) generada por el sistema aislado de la fuente \"j\""]
[null,"FC  j,y =","Miles de litros","Cantidad de Combustible i (masa o volumen) consumido por la fuente \"j\""]
[null,"NCV j =","Btu/litro","Poder Calorífico Inferior del combustible \"j\""]
[null,"EF co2,j =","gCO2/BTU","Coefiente de emisiones de CO2 del combustible"]
[null,"BE y =","tCO2/año","Línea de Base de emisiones "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año y"]
[null,"EF bl =","tCO2/MWh","Línea de Base del Factor de Emisiones del sistema aislado (tCO2e/MWh) "]

{"sheet":"DESCRIPCION 6","index":12,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,2,4],[3,1,3,4]]}
[]
[]
[null,"Demanda Máxima (kW) y Número de Consumidores de los sistemas Aislados"]
[null,"Gestión 2018"]
[null,"Empresa \nEléctrica","Sistema","Demanda \nMáxima (kW)","Número de \nConsumidores","Combustible"]
[null,"ENDE","Cobija",12360,17092,"Diesel"]
[null,null,"El Sena",673,976,"Diesel"]
[null,null,"Guayaramerín",5140,9030,"Diesel"]
[null,null,"Cachuela Esperanza",47,148,"Diesel"]
[null,null,"Rosario del Yata",48,148,"Diesel"]
[null,null,"Puerto Ustarez",8.91,38,"Diesel"]
[null,"ENDE DELBENI S.A.M.","Baures",210,953,"Diesel"]
[null,null,"Bella Vista",202,702,"Diesel"]
[null,null,"Huacaraje",159,505,"Diesel"]
[null,null,"El Carmen de Itenez",77.3,218,"Diesel"]
[null,null,"Exaltación",74,159,"Diesel"]
[null,"CRE R.L.","El Espino",31.62,133,"Diesel/Solar"]
[null,null,"Charagua",1107,3253,"Gas"]
[null,null,"Chiquitos",4380.2179999999998,8470,"Gas"]
[null,null,"San Ignacio de Velasco",5050.6779999999999,12184,"Diesel"]
[null,null,"Cordillera",6377.9699999999993,14957,"Gas"]
[null,null,"Valles Cruceños",6340.8040000000001,23104,"Gas"]
[null,null,"Las Misiones",11739.855209350586,28263,"Diesel / Gas"]
[null,null,"German Busch",10252.709999999999,10771,"Gas"]
[null,"CER","Riberalta",9824,21407,"Diesel"]
[null,"SETAR","Bermejo",6100,12941,"Gas"]
[null,null,"Entre Ríos",1700,5436,"Gas"]
[null,"ENDE GUARACACHI S.A.","San Matías",1676.7,2875,"Gas"]
[null,"TOTAL",null,null,{"$f":"SUM(E6:E25)+SUM(E26:E28)","v":173763}]

{"sheet":"CAP VI-1","index":13,"n_rows":66,"n_cols":20,"rows_kept":66,"cut":false,"hidden":false,"merged":[[60,2,60,3],[6,4,6,7],[6,9,6,12],[6,15,6,18],[2,1,2,18],[3,1,3,18],[5,4,5,12],[5,14,5,18]]}
[]
[]
[null,"Potencia instalada y efectiva al 31 de diciembre de 2018"]
[]
[]
[{"$nulls":4},"Potencia Instalada",{"$nulls":9},"Potencia Efectiva a Temp. media"]
[null,null,"Empresa","Central","(MVA)",{"$nulls":4},"(MW)",{"$nulls":4},"°C","(MW)"]
[{"$nulls":4},"Hidro","Termo","E. Alternativas","Total",null,"Hidro","Termo","E. Alternativas","Total",null,null,"Hidro","Termo","E. Alternativas","Total"]
[null,null,"GENERACIÓN - DISTRIBUCIÓN"]
[null,null,"ENDE","Cobija",null,28.199999999999996,null,{"$f":"SUM(E10:G10)","v":28.199999999999996},null,null,22.560000000000002,null,{"$f":"SUM(J10:L10)","v":22.560000000000002},null,"40°",null,19.500000000000004,null,{"$f":"SUM(P10:R10)","v":19.500000000000004},{"$f":"S10","v":19.500000000000004}]
[null,null,null,"El Sena",null,2.7669999999999999,null,2.7669999999999999,null,null,2.2160000000000002,null,2.2160000000000002,null,"40°",null,1.2999999999999998,null,{"$f":"SUM(P11:R11)","v":1.2999999999999998},{"$f":"S11","v":1.2999999999999998}]
[null,null,null,"Guayaramerín",null,22.349999999999994,null,22.349999999999994,null,null,17.254999999999995,null,17.254999999999995,null,"36°",null,15.446000000000002,null,{"$f":"SUM(P12:R12)","v":15.446000000000002},15.446000000000002]
[null,null,null,"Cachuela Esperanza",null,0.80899999999999994,null,0.80899999999999994,null,null,0.64700000000000002,null,0.64700000000000002,null,"36°",null,0.51760000000000006,null,{"$f":"SUM(P13:R13)","v":0.51760000000000006},0.51760000000000006]
[null,null,null,"Rosario del Yata",null,1.2080000000000002,null,1.2080000000000002,null,null,0.96640000000000004,null,0.96640000000000004,null,"36°",null,0.77312000000000014,null,0.77312000000000014,0.77312000000000014]
[null,null,null,"Puerto Ustárez",null,0.23499999999999999,null,0.23499999999999999,null,null,0.188,null,0.188,null,"34°",null,0.14100000000000001,null,0.14100000000000001,0.14100000000000001]
[null,null,"Total ENDE",null,null,{"$f":"SUM(F10:F15)","v":55.568999999999988},null,{"$f":"SUM(H10:H15)","v":55.568999999999988},null,null,{"$f":"SUM(K10:K15)","v":43.8324},null,{"$f":"SUM(M10:M15)","v":43.8324},null,null,null,{"$f":"SUM(Q10:Q15)","v":37.677720000000008},null,{"$f":"SUM(P16:R16)","v":37.677720000000008},{"$f":"S23","v":7.3220000000000001}]
[null,null,"ENDE DELBENI S.A.M.","Baures",null,2.2630000000000003,null,{"$f":"SUM(E17:G17)","v":2.2630000000000003},null,null,1.8100000000000003,null,{"$f":"SUM(J17:L17)","v":1.8100000000000003},null,"33°",null,1.4330000000000001,null,{"$f":"SUM(P17:R17)","v":1.4330000000000001},{"$f":"S24","v":4.8}]
[null,null,null,"Bella Vista",null,1.774,null,{"$f":"SUM(E18:G18)","v":1.774},null,null,1.4260000000000002,null,{"$f":"SUM(J18:L18)","v":1.4260000000000002},null,"33°",null,1.111,null,1.111,{"$f":"S17","v":1.4330000000000001}]
[null,null,null,"Huacaraje",null,0.58000000000000007,null,{"$f":"SUM(E19:G19)","v":0.58000000000000007},null,null,0.46400000000000002,null,{"$f":"SUM(J19:L19)","v":0.46400000000000002},null,"33°",null,0.39800000000000002,null,0.39800000000000002,{"$f":"S18","v":1.111}]
[null,null,null,"El Carmen de Iténez",null,0.16,null,{"$f":"SUM(E20:G20)","v":0.16},null,null,0.128,null,{"$f":"SUM(J20:L20)","v":0.128},null,"32°",null,9.6000000000000002E-2,null,9.6000000000000002E-2,0.39800000000000002]
[null,null,null,"Exaltación",null,0.35,null,{"$f":"SUM(E21:G21)","v":0.35},null,null,0.28000000000000003,null,{"$f":"SUM(J21:L21)","v":0.28000000000000003},null,"36°",null,0.23,null,0.23,9.6000000000000002E-2]
[null,null,"Total ENDE DELBENI S.A.M.",null,null,{"$f":"SUM(F17:F21)","v":5.1270000000000007},null,{"$f":"SUM(H17:H21)","v":5.1270000000000007},null,null,{"$f":"SUM(K17:K21)","v":4.1080000000000005},null,{"$f":"SUM(M17:M21)","v":4.1080000000000005},null,null,null,{"$f":"SUM(Q17:Q21)","v":3.2680000000000002},null,{"$f":"SUM(S17:S21)","v":3.2680000000000002},{"$f":"S21","v":0.23}]
[null,null,"ENDE GUARACACHI S.A.","San Matías",null,10.555999999999999,null,{"$f":"SUM(E23:G23)","v":10.555999999999999},null,null,8.68,null,{"$f":"SUM(J23:L23)","v":8.68},null,"25°",null,7.3220000000000001,null,{"$f":"SUM(O23:R23)","v":7.3220000000000001},{"$f":"+S26","v":11.55}]
[null,null,null,"(1) Planta Solar Cobija",null,null,5.0999999999999996,{"$f":"SUM(E24:G24)","v":5.0999999999999996},null,null,null,5.0999999999999996,{"$f":"SUM(J24:L24)","v":5.0999999999999996},null,"31°",null,null,4.8,{"$f":"SUM(P24:R24)","v":4.8},{"$f":"+S27","v":2.2799999999999998}]
[null,null,"Total ENDE GUARACACHI S.A.",null,null,{"$f":"SUM(F23:F24)","v":10.555999999999999},{"$f":"SUM(G23:G24)","v":5.0999999999999996},{"$f":"SUM(E25:G25)","v":15.655999999999999},null,null,{"$f":"SUM(K23:K24)","v":8.68},{"$f":"SUM(L24:L24)","v":5.0999999999999996},13.78,null,null,null,{"$f":"SUM(Q23:Q24)","v":7.3220000000000001},{"$f":"SUM(R23:R24)","v":4.8},12.122,{"$f":"+S29","v":11.75}]
[null,null,"SETAR","Bermejo ",null,18.055999999999997,null,{"$f":"SUM(E26:G26)","v":18.055999999999997},null,null,14.443999999999999,null,14.443999999999999,null,"30°",null,11.55,null,11.55,{"$f":"+S30","v":19.05}]
[null,null,null,"Entre Ríos ",null,2.9739999999999998,null,2.9739999999999998,null,null,2.6999999999999997,null,2.6999999999999997,null,"25°",null,2.2799999999999998,null,2.2799999999999998,7.2]
[null,null,"Total SETAR",null,null,{"$f":"SUM(F26:F27)","v":21.029999999999998},null,21.029999999999998,null,null,{"$f":"SUM(K26:K27)","v":17.143999999999998},null,17.143999999999998,null,null,null,{"$f":"SUM(Q26:Q27)","v":13.83},null,{"$f":"SUM(P28:R28)","v":13.83},6.7919999999999998]
[null,null,"CRE R.L.","Cordillera",null,15.83,null,15.83,null,null,12.673999999999999,null,12.673999999999999,null,"35,5°",null,11.75,null,{"$f":"SUM(P29:R29)","v":11.75},9.56]
[null,null,null,"Las Misiones",null,27.8,null,27.8,null,null,21.349999999999994,null,21.349999999999994,null,"32,0°",null,19.05,null,19.05,2.19]
[null,null,null,"Chiquitos",null,9.879999999999999,null,9.879999999999999,null,null,7.54,null,7.54,null,"35,0°",null,7.2,null,7.2,19.099999999999998]
[null,null,null,"San Ignacio de Velasco",null,9.8000000000000007,null,9.8000000000000007,null,null,7.84,null,7.84,null,"30,0°",null,6.7919999999999998,null,6.7919999999999998,{"$f":"+S36","v":0.124}]
[null,null,null,"Valles",null,14.547500000000001,null,14.547500000000001,null,null,11.637999999999998,null,11.637999999999998,null,"35,0°",null,9.56,null,9.56,{"$f":"S39","v":15.779999999999992}]
[null,null,null,"Charagua",null,3.13,null,{"$f":"SUM(E34:G34)","v":3.13},null,null,2.5539999999999998,null,2.5539999999999998,null,"35,0°",null,2.19,null,2.19,{"$f":"S41","v":1.6}]
[null,null,null,"German Busch",null,28.984999999999999,null,28.984999999999999,null,null,23.199999999999996,null,23.199999999999996,null,"33,5°",null,19.099999999999998,null,19.099999999999998,{"$f":"S43","v":25}]
[null,null,null,"(1) El Espino",null,0.08,0.06,{"$f":"SUM(E36:G36)","v":0.14000000000000001},null,null,6.4000000000000001E-2,0.06,{"$f":"SUM(J36:L36)","v":0.124},null,"35,5°",null,6.5000000000000002E-2,5.8999999999999997E-2,{"$f":"SUM(P36:R36)","v":0.124},{"$f":"S44","v":2.2000000000000002}]
[null,null,"Total CRE R.L.",null,null,{"$f":"SUM(F29:F36)","v":110.05249999999999},{"$f":"SUM(G29:G36)","v":0.06},{"$f":"SUM(H29:H36)","v":110.1125},null,null,{"$f":"SUM(K29:K36)","v":86.859999999999985},{"$f":"SUM(L29:L36)","v":0.06},{"$f":"SUM(M29:M36)","v":86.919999999999987},null,null,null,{"$f":"SUM(Q29:Q36)","v":75.706999999999994},{"$f":"SUM(R29:R36)","v":5.8999999999999997E-2},{"$f":"SUM(S29:S36)","v":75.765999999999991},16]
[null,null,"CER ","El Palmar",null,22.029999999999998,null,{"$f":"SUM(E38:G38)","v":22.029999999999998},null,null,16.120000000000005,null,{"$f":"SUM(J38:L38)","v":16.120000000000005},null,"37,0°",null,15.779999999999992,null,{"$f":"SUM(P38:R38)","v":15.779999999999992},4.7799999999999994]
[null,null,"Total CER",null,null,{"$f":"F38","v":22.029999999999998},null,{"$f":"SUM(E39:G39)","v":22.029999999999998},null,null,{"$f":"K38","v":16.120000000000005},null,{"$f":"SUM(J39:L39)","v":16.120000000000005},null,null,null,{"$f":"Q38","v":15.779999999999992},null,{"$f":"S38","v":15.779999999999992},{"$f":"S47","v":3.9159999999999999}]
[null,null,"G&E S.A.","El Puente",null,2.2000000000000002,null,{"$f":"SUM(E40:G40)","v":2.2000000000000002},null,null,1.92,null,{"$f":"SUM(J40:L40)","v":1.92},null,"25,0°",null,1.6,null,{"$f":"SUM(P40:R40)","v":1.6},{"$f":"S56","v":2.238}]
[null,null,"Total G&E S,A,",null,null,2.2000000000000002,null,{"$f":"SUM(E41:G41)","v":2.2000000000000002},null,null,1.92,null,{"$f":"SUM(J41:L41)","v":1.92},null,null,null,1.6,null,{"$f":"SUM(P41:R41)","v":1.6},{"$f":"S57","v":4.5}]
[null,null,"AUTOPRODUCTORES",{"$nulls":16},{"$f":"S58","v":16.2}]
[null,null,"AGUAÍ S.A.","(2) Aguaí",null,null,27,{"$f":"SUM(E43:G43)","v":27},null,null,null,25,{"$f":"SUM(J43:L43)","v":25},null,"27°",null,null,25,25,{"$f":"S48","v":61.5}]
[null,null,"Gravetal Bolivia S.A. ","Gravetal",null,3.9,null,3.9,null,null,3,null,3,null,"30°-42°",null,2.2000000000000002,null,2.2000000000000002,8.6]
[null,null,"IAGSA","(2) Guabirá",null,null,31.25,31.25,null,null,null,25,25,null,"28,0°",null,null,16,16,9.4]
[null,null,"PLUSPETROL","Pluspetrol",null,5.9199999999999982,null,5.9199999999999982,null,null,4.7799999999999994,null,4.7799999999999994,null,"38°-40°",null,4.7799999999999994,null,4.7799999999999994,15]
[null,null,"IOL","Industrias Oleaginosas Bolivia S.A.",null,7.0659999999999998,null,7.0659999999999998,null,null,3.9459999999999997,null,3.9459999999999997,null,"34°",null,3.9159999999999999,null,3.9159999999999999,11]
[null,null,"UNAGRO","(2) Unagro",null,null,77,77,null,null,null,61.5,61.5,null,"29°",null,null,61.5,61.5,1.6]
[null,null,"YPFB REFINACIÓN S.A.","Guillermo Elder Bell",null,12,null,12,null,null,9.6,null,9.6,null,"38,2°",null,8.6,null,8.6,0.8]
[null,null,"YPFB REFINACIÓN S.A.","Gualberto Villarroel",null,15,null,{"$f":"SUM(E50:G50)","v":15},null,null,12,null,12,null,"18,5°",null,9.4,null,9.4]
[null,null,"EASBA","1Turbogenerador de Contrapresion",null,null,18.75,{"$f":"SUM(E51:G51)","v":18.75},null,null,null,15,15,null,"25,7°",null,null,15,{"$f":"SUM(P51:R51)","v":15}]
[null,null,"EASBA","2 Turbogenerador de Extraccion",null,18.75,null,{"$f":"SUM(E52:G52)","v":18.75},null,null,15,null,15,null,"25,7°",null,11,null,{"$f":"SUM(P52:R52)","v":11}]
[null,null,"SINCHY WAYRA S.A.","Aroifilia",null,3.8960000000000004,null,3.8960000000000004,null,null,2,null,2,null,"19°",null,1.6,null,{"$f":"SUM(P53:R53)","v":1.6}]
[null,null,"SINCHY WAYRA S.A.","(3) Yocalla",1.5,null,null,1.5,null,1.2,null,null,1.2,null,null,0.8,null,null,{"$f":"SUM(P54:R54)","v":0.8}]
[null,null,"(5) TAHUAMANU S.A.","Nicolás Suárez Pando",null,null,1.25,1.25,null,null,null,1,1,null,"25,7°"]
[null,null,"YPFB TRANSIERRA","(4) ECV",null,2.8259999999999996,null,{"$f":"SUM(E56:G56)","v":2.8259999999999996},null,null,2.262,null,2.262,null,"27°",null,2.238,null,{"$f":"SUM(P56:R56)","v":2.238}]
[null,null,"PIL ANDINA S.A.","Warnes",null,6,null,6,null,null,5.125,null,5.125,null,"27°",null,4.5,null,{"$f":"SUM(P57:R57)","v":4.5}]
[null,null,"ITACAMBA CEMENTO S.A.","Yacuses",null,21.599999999999994,null,21.599999999999994,null,null,18.45,null,18.45,null,"28°",null,16.2,null,{"$f":"SUM(P58:R58)","v":16.2}]
[null,null,"Total Autoproductores",null,{"$f":"SUM(E43:E58)","v":1.5},{"$f":"SUM(F43:F58)","v":96.957999999999984},{"$f":"SUM(G43:G58)","v":155.25},{"$f":"SUM(H43:H58)","v":253.70799999999997},null,{"$f":"SUM(J43:J58)","v":1.2},{"$f":"SUM(K43:K58)","v":76.162999999999997},{"$f":"SUM(L43:L58)","v":127.5},{"$f":"SUM(M43:M58)","v":204.86299999999997},null,null,{"$f":"SUM(P43:P58)","v":0.8},{"$f":"SUM(Q43:Q58)","v":64.433999999999997},{"$f":"SUM(R43:R58)","v":117.5},{"$f":"SUM(S43:S58)","v":182.73399999999998}]
[null,null,"Total Sistemas Aislados",null,{"$f":"E59+E41+E39+E37+E28+E25+E22+E16","v":1.5},{"$f":"F59+F41+F39+F37+F28+F25+F22+F16","v":323.52250000000004},{"$f":"G59+G41+G39+G37+G28+G25+G22+G16","v":160.41},{"$f":"H59+H41+H39+H37+H28+H25+H22+H16","v":485.43249999999989},null,{"$f":"J59+J41+J39+J37+J28+J25+J22+J16","v":1.2},{"$f":"K59+K41+K39+K37+K28+K25+K22+K16","v":254.82740000000001},{"$f":"L59+L41+L39+L37+L28+L25+L22+L16","v":132.66},{"$f":"M59+M41+M39+M37+M28+M25+M22+M16","v":388.68739999999997},null,null,{"$f":"P59+P41+P39+P37+P28+P25+P22+P16","v":0.8},{"$f":"Q59+Q41+Q39+Q37+Q28+Q25+Q22+Q16","v":219.61872},{"$f":"R59+R41+R39+R37+R28+R25+R22+R16","v":122.35899999999999},{"$f":"S59+S41+S39+S37+S28+S25+S22+S16","v":342.77771999999999}]
[null,null,"Fuente: Formularios ISE-130"]
[null,null,"(1) Datos Unidades de Generación Fotovoltaíca"]
[null,null,"(2) Datos Unidades de Generación Biomasa"]
[null,null,"(3) Datos Unidades de Generación Hidroeléctrica"]
[null,null,"(4) Estación de Compresión Villa Montes"]
[null,null,"(5) La empresa no registró la postencia efectiva en la gestión 2018"]

{"sheet":"Generacion Bruta","index":14,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,2,8]]}
[]
[null,"Evolución de la generación bruta (GWh)"]
[null,"Periodo 1996-2018"]
[]
[null,"Empresa",null,"Central/Sistema",2014,2015,2016,2017,2018]
[]
[null,"Fotovoltaica"]
[null,"ENDE GUARACAHI S.A.",null,"Cobija",0,4.7943755010909097,5.6278183999999989,5.7761255999999994,{"$f":"'[12]CAP VI-5'!O7","v":5.3198761000000019}]
[null,"CRE R.L.",null,"El Espino",0,0,3.8451240000000005E-2,4.8443E-2,{"$f":"'[12]CAP VI-5'!O8","v":4.8871999999999999E-2}]
[null,"Total Generación Fotovoltaíca",null,null,0,{"$f":"+F8","v":4.7943755010909097},{"$f":"SUM(G8:G9)","v":5.6662696399999986},5.8245685999999992,{"$f":"SUM(I8:I9)","v":5.3687481000000021}]
[null,"Termoeléctrica"]
[null,"SETAR"]
[null,null," ","Bermejo",17.625435,24.367993999999999,25.069997999999998,27.032792000000004,{"$f":"'[12]CAP VI-5'!O30","v":28.138757000000002}]
[null,null,null,"Entre Ríos",4.6918300000000004,5.9633520000000004,6.8269659999999996,7.2175999999999991,{"$f":"'[12]CAP VI-5'!O31","v":7.5071260000000004}]
[null,null,null,"El Puente",0.80841999999999992,0,0,0,0]
[null,"Total SETAR",null,null,58.545166333333334,{"$f":"SUM(F13:F15)","v":30.331346},{"$f":"SUM(G13:G15)","v":31.896963999999997},34.250392000000005,{"$f":"SUM(I13:I15)","v":35.645883000000005}]
[null,"ENDE",null,"Cobija",52.004804699999994,56.054181291999996,55.734794489999992,56.969075999999994,{"$f":"'[12]CAP VI-5'!O16","v":57.831902999999997}]
[null,null,null,"El Sena",0.64600489999999999,1.2481833999999998,1.6777593999999998,1.8810661,{"$f":"'[12]CAP VI-5'!O17","v":2.2131919999999998}]
[null,null,null,"Guayaramerín",0,0,0,13.925585000000002,{"$f":"'[12]CAP VI-5'!O18","v":27.108353999999995}]
[null,null,null,"Cachuela Esperanza ",0,0,0,4.9051999999999998E-2,{"$f":"'[12]CAP VI-5'!O19","v":0.34881999999999996}]
[null,null,null,"Rosario del Yata",0,0,0,5.8606000000000005E-2,{"$f":"'[12]CAP VI-5'!O20","v":0.17151299999999997}]
[null,null,null,"Puerto Ustarez",0,0,0,0,{"$f":"'[12]CAP VI-5'!O21","v":2.7969472395090601E-2}]
[null,"Total ENDE",null,null,{"$f":"SUM(E17:E22)","v":52.650809599999995},{"$f":"SUM(F17:F22)","v":57.302364691999998},{"$f":"SUM(G17:G22)","v":57.412553889999991},{"$f":"SUM(H17:H22)","v":72.883385099999998},{"$f":"SUM(I17:I22)","v":87.701751472395088}]
[null,"ENDE DELBENI S.A.M ",null,"Baures","-","-",0.27,1.1203589999999999,{"$f":"'[12]CAP VI-5'!O23","v":1.3459519438664254}]
[null,null,null,"Bella Vista","-","-",0.2,0.83362900000000006,{"$f":"'[12]CAP VI-5'!O24","v":0.90140105729503861}]
[null,null,null,"Huacaraje ","-","-",0.19,0.67930499999999994,{"$f":"'[12]CAP VI-5'!O25","v":0.68033414166666661}]
[null,null,null,"El Carmen de Iténez ","-","-","-",0.19936100000000004,{"$f":"'[12]CAP VI-5'!O26","v":0.233177}]
[null,null,null,"Exaltación ","-","-","-",7.2394E-2,{"$f":"'[12]CAP VI-5'!O27","v":0.21676699999999999}]
[null,"Total ENDE DELBENI S.A.M ",{"$nulls":4},{"$f":"SUM(G24:G28)","v":0.66},2.9050479999999999,{"$f":"SUM(I24:I28)","v":3.3776311428281307}]
[null,"CRE R.L.",null,"Cordillera",26.931018999999999,29.769716000000003,31.023121999999994,32.518518999999998,{"$f":"'[12]CAP VI-5'!O35","v":33.217416593452008}]
[null,null,null,"Roboré y Santiago de Chiquitos",16.495100058047001,18.492527343749998,19.606297000000005,21.045854061,{"$f":"'[12]CAP VI-5'!O38","v":22.0879751005}]
[null,null,null,"Valles",24.962853000000003,27.356741,30.774994530201344,33.037838000000001,{"$f":"'[12]CAP VI-5'!O40","v":34.243890999999998}]
[null,null,null,"San Ignacio de Velasco",20.118833000000006,22.009939000000003,23.362835999999998,24.446846999999998,{"$f":"'[12]CAP VI-5'!O39","v":25.906172000000005}]
[null,null,null,"Las Misiones",45.834749141093852,51.150008,55.241410000000002,59.494525999999993,{"$f":"'[12]CAP VI-5'!O37","v":58.424895768660626}]
[null,null,null,"Charagua",2.9131480000000005,3.280516,3.7023280000000001,4.6336119999999994,{"$f":"'[12]CAP VI-5'!O34","v":4.9756110000000007}]
[null,null,null,"German Busch",57.328465000000001,60.886547999999998,60.284140000000001,55.369352999999997,{"$f":"'[12]CAP VI-5'!O36","v":57.411820999999996}]
[null,null,null,"El Espino",0,0,0,4.5814000000000001E-2,{"$f":"'[12]CAP VI-5'!O41","v":7.0738999999999996E-2}]
[null,"Total CRE R.L.",null,null,{"$f":"SUM(E30:E37)","v":194.58416719914086},212.94599534375001,223.99512753020133,230.59236306099999,236.33852146261265]
[null,"ENDE GUARACACHI S.A.",null,"San Matías",6.5460960353676558,7.4119906499999955,7.853605008150006,8.7442823000000036,{"$f":"'[12]CAP VI-5'!O44","v":8.060722724999998}]
[null,"TOTAL",null,null,{"$f":"+#REF!+#REF!+E10","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+F10","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+G10","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+H10","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!+I10","v":{"$error":"#REF!"}}]

{"sheet":"Hoja1","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}