{"text_format":"2","workbook":"xlsx","n_sheets":17,"sheets":["Las Misiones (2)","Huacaraje (2)","Cobija (2)","Analisis","Datos","Cobija","Riberalta","San Ingacio Velasco","Las Misiones","Valles","Camiri","German Busch","Bermejo","Chiquitos","Huacaraje","Bella Vista","El Sena"],"not_rendered":{"charts":13,"images":12,"macros":0,"external_links":12,"defined_names":1475,"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":"Las Misiones (2)","index":0,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[[1,1,1,3],[34,1,34,3],[34,4,34,6],[82,1,85,4],[86,1,86,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[null,"Departamento","Santa Cruz"]
[null,"Provincia","Guarayos"]
[null,"Sistema Eléctrico","Las Misiones"]
[null,"Empresa","CRE Ltda."]
[null,"Combustible","Gas/Diesel"]
[null,"Consumo especifico (pc/kWh) (*)",{"$f":"SUM(F20:H20)/SUM(F18:H18)","v":13.231302586681062}]
[null,"Consumo especifico (lts/kWh) (*)",0.27718065536918751]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"((H15/D15)^(1/4))-1","v":6.2553416093206415E-2}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(D22:H22)/SUM(D15:H15)","v":0.84237616434307439}]
[null,"Factor  Ʃ(Generación Total - Bruta)/Ʃ(Generación Diesel)",{"$f":"SUM(F19:H19)/SUM(F15:H15)","v":0.16051175725136119}]
[]
[null,null,"Unidades",2014,{"$f":"+D14+1","v":2015},{"$f":"+E14+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D16+D17","v":45834.749141093853},{"$f":"+E16+E17","v":51150.008000000002},55241.41,59494.525999999991,58424.895768660623,{"$f":"H15*(1+$C$10)","v":62079.572583879868},{"$f":"I15*(1+$C$10)","v":65962.861918607712},70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D41","v":45834.749141093853},{"$f":"+Datos!E41","v":51150.008000000002},{"$f":"+Datos!F41","v":55241.41},{"$f":"+Datos!G41","v":59494.525999999991},{"$f":"+Datos!H41","v":58424.895768660623},{"$f":"+I15-I16","v":62079.572583879868},{"$f":"+J15-J16","v":65962.861918607712},70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Generación Fósil Gas","MWh",{"$f":"+D17-D19","v":45415.109466582391},{"$f":"+E17-E19","v":49661.704281796665},53151.033241101519,46841.12493202358,45374.324201240481,{"$f":"+I17-I19","v":52115.071299027884},{"$f":"+J17-J19","v":55375.047038723096},58838.94539731722,62519.52243124105,66430.332131831019,70585.776338883355,75001.157776471533]
[null,"Generación Fósil Diesel","MWh",{"$f":"D21/$C$9","v":419.63967451146357},{"$f":"E21/$C$9","v":1488.3037182033388},2090.3767588984847,12653.401067976414,13050.571567420144,{"$f":"+I15*$C$12","v":9964.5012848519818},{"$f":"+J15*$C$12","v":10587.814879884618},11250.118869583883,11953.852236330997,12701.606529186914,13496.135407459331,14340.36478125239]
[null,"Combustible Fósil gas natural","MPC",{"$f":"+Datos!D92","v":571963.42796784278},{"$f":"+Datos!E92","v":612920.54899999988},{"$f":"+Datos!F92","v":663158.38600000006},{"$f":"+Datos!G92","v":620081.93500000006},{"$f":"+Datos!H92","v":640147.59325666993},{"$f":"+I18*$C$8","v":689550.27768389566},{"$f":"+J18*$C$8","v":732684.00312104239},778515.89043310913,827214.7188625444,878959.82536997786,933941.76505555829,992363.01289190224]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+Datos!D93","v":116.316},{"$f":"+Datos!E93","v":412.529},{"$f":"+Datos!F93","v":579.41200000000003},{"$f":"+Datos!G93","v":3507.2780006708795},{"$f":"+Datos!H93","v":3617.36598},{"$f":"+I19*$C$9","v":2761.9669965623834},{"$f":"+J19*$C$9","v":2934.7374673340537},3118.3153212525235,3313.3765970526533,3520.6396220015799,3740.8676571908741,3974.8717083007527]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D59","v":37833.118999999999},{"$f":"+Datos!E59","v":41946.923999999992},{"$f":"+Datos!F59","v":46627.072999999997},{"$f":"+Datos!G59","v":48820.517},{"$f":"+Datos!H59","v":52336.572},{"$f":"I15*$C$11","v":52294.352237266205},{"$f":"J15*$C$11","v":55565.542612088611},59041.357119547385,62734.595698154022,66658.858966299726,70828.598307517037,75259.169088745737]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D75","v":18188},{"$f":"+Datos!E75","v":20295},{"$f":"+Datos!F75","v":22711},{"$f":"+Datos!G75","v":25616},{"$f":"+Datos!H75","v":28263}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D22*1000/D23)/12","v":173.3428588446595},{"$f":"(E22*1000/E23)/12","v":172.2383345651638},{"$f":"(F22*1000/F23)/12","v":171.08843365182804},{"$f":"(G22*1000/G23)/12","v":158.82169021965439},{"$f":"(H22*1000/H23)/12","v":154.31415631744684}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D113","v":0},{"$f":"+Datos!E113","v":0},{"$f":"+Datos!F113","v":10.15507},{"$f":"+Datos!G113","v":11.0601664072266},{"$f":"+Datos!H113","v":11.7398552093505}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D7","v":17.149999999999999},{"$f":"+Datos!E7","v":17.149999999999999},{"$f":"+Datos!F7","v":21.349999999999994},{"$f":"+Datos!G7","v":21.349999999999994},{"$f":"+Datos!H7","v":21.349999999999994}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D23","v":14.999999999999998},{"$f":"+Datos!E23","v":15},{"$f":"+Datos!F23","v":19.05},{"$f":"+Datos!G23","v":19.05},{"$f":"+Datos!H23","v":19.05}]
[null,"Factor de Planta (****)",null,{"$f":"D17/(D27*8760)","v":0.34881848661410852},{"$f":"E17/(E27*8760)","v":0.38926946727549466},{"$f":"F17/(F27*8760)","v":0.33102871558863362},{"$f":"G17/(G27*8760)","v":0.35651509485971783},{"$f":"H17/(H27*8760)","v":0.3501054409128862}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]
[]
[null,"CALCULOS LINEA DE BASE",null,null,"Factores de Emisiones"]
[null,"Categoría","Gran Escala",null,"EF CO2,j = COEF  i,j =",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU","Gas Natural"]
[null,"Metodología Aplicable","AM0045",null,"EF CO2,j = COEF  i,j =",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU","Diesel "]
[null,"NCV - PCI (Diesel BTU/litro) =",33710]
[null,"NCV - PCI (Diesel BTU/pc) =",940,"(PCI del gas para SCZ)"]
[]
[]
[]
[null,null,null,"Ecuación (1)",null,null,null,"Ecuación (8)"]
[]
[]
[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\""]
[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 "]
[null,"EG y =","MWh","Electricidad abastecida al sistema Aislado en el año y"]
[]
[null,null,null,{"$f":"+D23","v":18188},{"$f":"+E23","v":20295},{"$f":"+F23","v":22711},{"$f":"+G23","v":25616},{"$f":"+H23","v":28263},{"$f":"+H54+1","v":28264},28265,28266,28267,28268,28269,28270]
[null,"EG y =","MWh",{"$f":"+D15","v":45834.749141093853},51150.008000000002,55241.41,59494.525999999991,58424.895768660623,62079.572583879868,65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"GEN  j,bl =","MWh",{"$f":"+D17","v":45834.749141093853},51150.008000000002,55241.41,59494.525999999991,58424.895768660623,62079.572583879868,65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"F  i,j,bl =","MMBTU (gas)",{"$f":"D20*1000*$C$39/1000000","v":537645.62228977226},576145.31605999987,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":"+D21*$C$38/1000","v":3921.0123599999997},13906.35259,19531.978520000001,118230.34140261535,121941.4071858,93105.907454117943,98930.000023830944,105118.40947942257,111693.92508664494,118680.76165767325,126104.64872390438,133992.92528681838]
[null,"EF bl,ini =","tCO2/MWh",{"$f":"+E59","v":0.67257222997730337},{"$f":"+F59","v":0.67257222997730337},{"$f":"(SUM(D57:F57)*$F$36+SUM(D58:F58)*$F$37)/SUM(D56:F56)","v":0.67257222997730337},{"$f":"(SUM(E57:G57)*$F$36+SUM(E58:G58)*$F$37)/SUM(E56:G56)","v":0.68559263123332204},0.71304590095652665,{"$f":"+H59","v":0.71304590095652665},{"$f":"+I59","v":0.71304590095652665},0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665]
[null,"BE y =","tCO2/año",{"$f":"D55*F59","v":30827.179440275784},{"$f":"+E55*F59","v":34402.074943916909},{"$f":"+F59*F55","v":37153.83831079051},{"$f":"+G59*G55","v":40789.008624319285},41659.632441655776,44265.584764068713,47034.5483064246,49976.719977392393,53102.934537111876,56424.704496982136,59954.262515318078,63704.606445000099]
[null,"EG y = GEN j,bl   (NO hay energía renovable por lo que la Gen. Fósil = Gen. Total)"]
{"$rows_empty":20}
[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.",{"$nulls":6},"Proyecto:","Conexión al SIN Las Misiones"]
[{"$nulls":8},"Línea:","230 kV (Los Troncos - Guarayos)"]
[{"$nulls":9},"Mes/Año de puesta en operación","2020-12-01"]
[{"$nulls":9},"Categoría","Gran Escala"]
[{"$nulls":9},"Metodología Aplicable","AM00045"]
[null,"Emisiones del Proyecto"]
[null,"Utilizamos el factor de emisiones del Sistema Interconectado Nacional (SIN)",0.48,null,null,null,"Ecuación (9)"]
[{"$nulls":6},"Ecuación (11)"]
[]
[{"$nulls":6},"Ecuación (13)"]
[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,"BE y  =","tCO2/año","Línea de Base de emisiones "]
[null,"PE y  =","tCO2/año","Emisiones de las actividades del Proyecto"]
[null,"L y  =","tCO2/año","Emisiones fugitivas del proyecto, por desmonte (Asumimos que la deforestación es < 1% de las emisiones; por lo que L y = 0) (**)"]
[null,"ER y  =","tCO2/año","Emisiones Reducidas "]
[]
[null,null,null,2014,{"$f":"+D103+1","v":2015},{"$f":"+E103+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,{"$f":"+B15","v":"Generación Total"},{"$f":"+C15","v":"MWh"},{"$f":"+D15","v":45834.749141093853},51150.008000000002,55241.41,59494.525999999991,58424.895768660623,62079.572583879868,65962.861918607712,70089.064266901099,74473.374667572047,79131.938661017935,84081.911746342681,89341.522557723918]
[null,"Provision del SIN por la linea Interc."]
[null,"EG y(*) =","MWh",{"$nulls":6},{"$f":"+J15*0.7/12*1","v":3847.8336119187829},{"$f":"+K15*0.7","v":49062.344986830765},{"$f":"+L15*0.7","v":52131.362267300428},{"$f":"+M15*0.7","v":55392.357062712552},{"$f":"+N15*0.7","v":58857.338222439874},{"$f":"+O15*0.7","v":62539.065790406741}]
[null,{"$f":"+B96","v":"TL ="},"%",{"$nulls":6},{"$f":"+C96","v":2.6814880952380937E-2},{"$f":"+C96","v":2.6814880952380937E-2},{"$f":"+K107","v":2.6814880952380937E-2},2.6814880952380937E-2,2.6814880952380937E-2,2.6814880952380937E-2]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":6},{"$f":"+C89","v":0.48},{"$f":"+C89","v":0.48},0.48,0.48,0.48,0.48]
[null,"PE y =","tCO2/año",{"$nulls":6},{"$f":"J106*J108*(J107+1)","v":1896.4861498305384},{"$f":"K106*K108*(K107+1)","v":24181.414044910693},{"$f":"L106*L108*(L107+1)","v":25694.044099384097},{"$f":"M106*M108*(M107+1)","v":27301.294331050063},{"$f":"N106*N108*(N107+1)","v":29009.083555223333},{"$f":"O106*O108*(O107+1)","v":30823.700829335812}]
[null,"(*) Asumimos que un 70% de la demanda de energía vendría de la red (SIN)"]
[null,"(**) Las líneas se construyen en derechos de vía de caminos o tierras agrícolas"]
[null,"Una hectárea (10000 m2) puede absorber 20 tCO2/año y las perdidas en construcción de líneas solo se aplican al primer año, las hemos considerado cero (0)"]
[]
[]
[null,null,null,{"$f":"+D103","v":2014},{"$f":"+E103","v":2015},{"$f":"+F103","v":2016},{"$f":"+G103","v":2017},{"$f":"+H103","v":2018},{"$f":"+I103","v":2019},{"$f":"+J103","v":2020},{"$f":"+K103","v":2021},{"$f":"+L103","v":2022},{"$f":"+M103","v":2023},{"$f":"+N103","v":2024},{"$f":"+O103","v":2025}]
[null,"Sin Proyecto"]
[null,"Generación Total","MWh",{"$f":"+D15","v":45834.749141093853},{"$f":"+E15","v":51150.008000000002},{"$f":"+F15","v":55241.41},{"$f":"+G15","v":59494.525999999991},{"$f":"+H15","v":58424.895768660623},{"$f":"+I15","v":62079.572583879868},{"$f":"+J15","v":65962.861918607712},{"$f":"+K15","v":70089.064266901099},{"$f":"+L15","v":74473.374667572047},{"$f":"+M15","v":79131.938661017935},{"$f":"+N15","v":84081.911746342681},{"$f":"+O15","v":89341.522557723918}]
[null,"Generación Combustible Fósil Gas","MWh",{"$f":"+D18","v":45415.109466582391},{"$f":"+E18","v":49661.704281796665},{"$f":"+F18","v":53151.033241101519},{"$f":"+G18","v":46841.12493202358},{"$f":"+H18","v":45374.324201240481},{"$f":"+I18","v":52115.071299027884},{"$f":"+J18","v":55375.047038723096},{"$f":"+K18","v":58838.94539731722},{"$f":"+L18","v":62519.52243124105},{"$f":"+M18","v":66430.332131831019},{"$f":"+N18","v":70585.776338883355},{"$f":"+O18","v":75001.157776471533}]
[null,"Combustible Fósil Gas","MPC",{"$f":"+D20","v":571963.42796784278},{"$f":"+E20","v":612920.54899999988},663158.38600000006,620081.93500000006,640147.59325666993,{"$f":"+I20","v":689550.27768389566},732684.00312104239,778515.89043310913,827214.7188625444,878959.82536997786,933941.76505555829,992363.01289190224]
[null,"Generación Combustible Fósil Diesel","MWh",{"$f":"+D19","v":419.63967451146357},{"$f":"+E19","v":1488.3037182033388},2090.3767588984847,12653.401067976414,13050.571567420144,{"$f":"+I19","v":9964.5012848519818},10587.814879884618,11250.118869583883,11953.852236330997,12701.606529186914,13496.135407459331,14340.36478125239]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+D21","v":116.316},{"$f":"+E21","v":412.529},579.41200000000003,3507.2780006708795,3617.36598,{"$f":"+I21","v":2761.9669965623834},2934.7374673340537,3118.3153212525235,3313.3765970526533,3520.6396220015799,3740.8676571908741,3974.8717083007527]
[null,"Emisiones Planta Sistema Aislado (BE y)","tCO2/año",{"$f":"+D60","v":30827.179440275784},34402.074943916909,37153.83831079051,40789.008624319285,41659.632441655776,44265.584764068713,47034.5483064246,49976.719977392393,53102.934537111876,56424.704496982136,59954.262515318078,63704.606445000099]
[null,"Factor de Emisiones","tCO2/MWh",{"$f":"D59","v":0.67257222997730337},{"$f":"E59","v":0.67257222997730337},{"$f":"F59","v":0.67257222997730337},{"$f":"G59","v":0.68559263123332204},{"$f":"H59","v":0.71304590095652665},{"$f":"I59","v":0.71304590095652665},{"$f":"J59","v":0.71304590095652665},{"$f":"K59","v":0.71304590095652665},{"$f":"L59","v":0.71304590095652665},{"$f":"M59","v":0.71304590095652665},{"$f":"N59","v":0.71304590095652665},{"$f":"O59","v":0.71304590095652665}]
[]
[]
[null,"Con Proyecto"]
[null,"Generación Combustible Fósil Gas","MWh",{"$f":"(D18/D15)*(D15-D106)","v":45415.109466582391},{"$f":"(E18/E15)*(E15-E106)","v":49661.704281796665},{"$f":"(F18/F15)*(F15-F106)","v":53151.033241101519},{"$f":"(G18/G15)*(G15-G106)","v":46841.12493202358},{"$f":"(H18/H15)*(H15-H106)","v":45374.324201240481},{"$f":"(I18/I15)*(I15-I106)","v":52115.071299027884},{"$f":"(J18/J15)*(J15-J106)","v":52144.835961464254},{"$f":"(K18/K15)*(K15-K106)","v":17651.68361919517},{"$f":"(L18/L15)*(L15-L106)","v":18755.856729372317},{"$f":"(M18/M15)*(M15-M106)","v":19929.099639549306},{"$f":"(N18/N15)*(N15-N106)","v":21175.732901665007},{"$f":"(O18/O15)*(O15-O106)","v":22500.347332941459}]
[null,"Combustible Fósil Gas","MPC",{"$f":"+D20","v":571963.42796784278},{"$f":"+E20","v":612920.54899999988},663158.38600000006,620081.93500000006,640147.59325666993,{"$f":"+I127*$C8","v":689550.27768389566},{"$f":"+J127*$C8","v":689944.10293898161},{"$f":"+K127*$C8","v":233554.76712993279},{"$f":"+L127*$C8","v":248164.41565876335},{"$f":"+M127*$C8","v":263687.94761099335},{"$f":"+N127*$C8","v":280182.52951666748},{"$f":"+O127*$C8","v":297708.90386757068}]
[null,"Generación Combustible Fósil Diesel","MWh",{"$f":"(D19/D15)*(D15-D106)","v":419.63967451146357},{"$f":"(E19/E15)*(E15-E106)","v":1488.3037182033388},{"$f":"(F19/F15)*(F15-F106)","v":2090.3767588984847},{"$f":"(G19/G15)*(G15-G106)","v":12653.401067976414},{"$f":"(H19/H15)*(H15-H106)","v":13050.571567420144},{"$f":"(I19/I15)*(I15-I106)","v":9964.5012848519818},{"$f":"(J19/J15)*(J15-J106)","v":9970.1923452246829},{"$f":"(K19/K15)*(K15-K106)","v":3375.0356608751654},{"$f":"(L19/L15)*(L15-L106)","v":3586.1556708992994},{"$f":"(M19/M15)*(M15-M106)","v":3810.4819587560746},{"$f":"(N19/N15)*(N15-N106)","v":4048.8406222377998},{"$f":"(O19/O15)*(O15-O106)","v":4302.1094343757177}]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+D21","v":116.316},{"$f":"+E21","v":412.529},579.41200000000003,3507.2780006708795,3617.36598,{"$f":"+I129*$C9","v":2761.9669965623834},{"$f":"+J129*$C9","v":2763.5444484062341},{"$f":"+K129*$C9","v":935.49459637575728},{"$f":"+L129*$C9","v":994.01297911579616},{"$f":"+M129*$C9","v":1056.1918866004742},{"$f":"+N129*$C9","v":1122.2602971572624},{"$f":"+O129*$C9","v":1192.4615124902259}]
[null,"Emisiones Planta Interconectada","tCO2/año",{"$f":"(D15-D106)*D59","v":30827.179440275784},{"$f":"(E15-E106)*E59","v":34402.074943916909},{"$f":"(F15-F106)*F59","v":37153.83831079051},{"$f":"(G15-G106)*G59","v":40789.008624319285},{"$f":"(H15-H106)*H59","v":41659.632441655776},{"$f":"(I15-I106)*I59","v":44265.584764068713},{"$f":"(J15-J106)*J59","v":44290.866321883164},{"$f":"(K15-K106)*K59","v":14993.015993217721},{"$f":"(L15-L106)*L59","v":15930.880361133566},{"$f":"(M15-M106)*M59","v":16927.411349094644},{"$f":"(N15-N106)*N59","v":17986.278754595427},{"$f":"(O15-O106)*O59","v":19111.38193350003}]
[null,"Emisiones del Proyecto (PE y-0)","tCO2/año",{"$f":"+D109","v":0},{"$f":"+E109","v":0},0,0,0,0,1896.4861498305384,24181.414044910693,25694.044099384097,27301.294331050063,29009.083555223333,30823.700829335812]
[null,"Total Emisiones del SA con Proyecto (PE y)","tCO2/año",{"$f":"+D131+D132","v":30827.179440275784},{"$f":"+E131+E132","v":34402.074943916909},37153.83831079051,40789.008624319285,41659.632441655776,44265.584764068713,46187.352471713704,39174.430038128412,41624.924460517665,44228.705680144703,46995.36230981876,49935.082762835838]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",{"$f":"+D133/D104","v":0.67257222997730337},{"$f":"+E133/E104","v":0.67257222997730337},0.67257222997730337,0.68559263123332204,0.71304590095652665,0.71304590095652665,0.70020237340072933,0.55892357028695794,0.55892357028695805,0.55892357028695794,0.55892357028695794,0.55892357028695794]
[]
[null,"Reducciones "]
[null,"Reduccion Consumo Combustible Fósil"]
[null,{"$f":"+B128","v":"Combustible Fósil Gas"},{"$f":"+C128","v":"MPC"},{"$f":"+D119-D128","v":0},{"$f":"+E119-E128","v":0},{"$f":"+F119-F128","v":0},{"$f":"+G119-G128","v":0},{"$f":"+H119-H128","v":0},{"$f":"+I119-I128","v":0},{"$f":"+J119-J128","v":42739.900182060781},{"$f":"+K119-K128","v":544961.12330317637},{"$f":"+L119-L128","v":579050.30320378102},{"$f":"+M119-M128","v":615271.87775898445},{"$f":"+N119-N128","v":653759.23553889082},{"$f":"+O119-O128","v":694654.10902433156}]
[null,{"$f":"+B130","v":"Combustible Fósil Diesel"},{"$f":"+C130","v":"Miles de Litros"},{"$f":"+D121-D130","v":0},{"$f":"+E121-E130","v":0},{"$f":"+F121-F130","v":0},{"$f":"+G121-G130","v":0},{"$f":"+H121-H130","v":0},{"$f":"+I121-I130","v":0},{"$f":"+J121-J130","v":171.19301892781959},{"$f":"+K121-K130","v":2182.8207248767662},{"$f":"+L121-L130","v":2319.3636179368573},{"$f":"+M121-M130","v":2464.447735401106},{"$f":"+N121-N130","v":2618.6073600336117},{"$f":"+O121-O130","v":2782.4101958105266}]
[null,"Emisiones Reducidas (ER y)","tCO2/año",{"$f":"+D122-D133","v":0},{"$f":"+E122-E133","v":0},{"$f":"+F122-F133","v":0},{"$f":"+G122-G133","v":0},{"$f":"+H122-H133","v":0},{"$f":"+I122-I133","v":0},{"$f":"+J122-J133","v":847.19583471089572},{"$f":"+K122-K133","v":10802.289939263981},{"$f":"+L122-L133","v":11478.010076594212},{"$f":"+M122-M133","v":12195.998816837433},{"$f":"+N122-N133","v":12958.900205499318},{"$f":"+O122-O133","v":13769.523682164261}]
[null,"Reducción Factor de Emisiones","tCO2/MWh",{"$f":"+D134-D123","v":0},{"$f":"+E134-E123","v":0},0,0,0,0,-1.2843527555797318E-2,-0.15412233066956871,-0.1541223306695686,-0.15412233066956871,-0.15412233066956871,-0.15412233066956871]
[]
[]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,null,"Combustible Fósil Gas SIN proyecto (MPC)",{"$f":"+D119","v":571963.42796784278},{"$f":"+E119","v":612920.54899999988},663158.38600000006,620081.93500000006,640147.59325666993,689550.27768389566,732684.00312104239,778515.89043310913,827214.7188625444,878959.82536997786,933941.76505555829,992363.01289190224]
[null,null,"Combustible Fósil Gas CON proyecto (MPC)",{"$f":"+D128","v":571963.42796784278},{"$f":"+E128","v":612920.54899999988},663158.38600000006,620081.93500000006,640147.59325666993,689550.27768389566,689944.10293898161,233554.76712993279,248164.41565876335,263687.94761099335,280182.52951666748,297708.90386757068]
[null,null,"Combustible Fósil Diesel (SIN) proyecto (Miles de Litros)",{"$f":"+D121","v":116.316},{"$f":"+E121","v":412.529},579.41200000000003,3507.2780006708795,3617.36598,2761.9669965623834,2934.7374673340537,3118.3153212525235,3313.3765970526533,3520.6396220015799,3740.8676571908741,3974.8717083007527]
[null,null,"Combustible Fósil Diesel CON proyecto (Miles de Litros)",{"$f":"+D130","v":116.316},{"$f":"+E130","v":412.529},579.41200000000003,3507.2780006708795,3617.36598,2761.9669965623834,2763.5444484062341,935.49459637575728,994.01297911579616,1056.1918866004742,1122.2602971572624,1192.4615124902259]
[null,null,"Emisiones Planta SA SIN Proyecto(BE y) - tCO2/año",{"$f":"+D122","v":30827.179440275784},{"$f":"+E122","v":34402.074943916909},37153.83831079051,40789.008624319285,41659.632441655776,44265.584764068713,47034.5483064246,49976.719977392393,53102.934537111876,56424.704496982136,59954.262515318078,63704.606445000099]
[null,null,"Total Emisiones del SA CON Proyecto (PE y) tCO2/año",{"$f":"+D133","v":30827.179440275784},{"$f":"+E133","v":34402.074943916909},37153.83831079051,40789.008624319285,41659.632441655776,44265.584764068713,46187.352471713704,39174.430038128412,41624.924460517665,44228.705680144703,46995.36230981876,49935.082762835838]
[null,null,"Factor de Emisiones SA SIN Proyecto tCO2/MWh",{"$f":"+D123","v":0.67257222997730337},{"$f":"+E123","v":0.67257222997730337},0.67257222997730337,0.68559263123332204,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665,0.71304590095652665]
[null,null,"Factor de Emisiones SA CON Proyecto tCO2/MWh",{"$f":"+D134","v":0.67257222997730337},{"$f":"+E134","v":0.67257222997730337},0.67257222997730337,0.68559263123332204,0.71304590095652665,0.71304590095652665,0.70020237340072933,0.55892357028695794,0.55892357028695805,0.55892357028695794,0.55892357028695794,0.55892357028695794]

{"sheet":"Huacaraje (2)","index":1,"n_rows":136,"n_cols":15,"rows_kept":136,"cut":false,"hidden":false,"merged":[[95,1,95,2],[1,1,1,3],[30,1,30,3],[30,4,30,6],[78,1,81,4],[82,1,82,4]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Beni"]
[null,"Provincia","Itenez"]
[null,"Sistema Eléctrico","Huacaraje"]
[null,"Empresa","ENDE DELBENI S.A.M."]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"SUM(G17:H17)/SUM(G16:H16)","v":0.36575954954518364}]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"H14/G14-1","v":1.5149920384314175E-3},"Se debe tomar una decisión"]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(G18:H18)/SUM(G14:H14)","v":0.86183970738265214}]
[]
[null,null,"Unidades",2014,{"$f":"+D13+1","v":2015},{"$f":"+E13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D15+D16","v":0},{"$f":"+E15+E16","v":0},190,679.30499999999995,680.3341416666666,{"$f":"+H14*(1+$C$10)","v":681.36484247476471},{"$f":"+I14*(1+$C$10)","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Generación Energía Renovable","MWh"]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D47","v":0},{"$f":"+Datos!E47","v":0},{"$f":"+Datos!F47","v":190},{"$f":"+Datos!G47","v":679.30499999999995},{"$f":"+Datos!H47","v":680.3341416666666},{"$f":"+I14-I15","v":681.36484247476471},{"$f":"+J14-J15","v":682.39710478638108},683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D103","v":0},{"$f":"+Datos!E103","v":0},{"$f":"+Datos!F103","v":0},{"$f":"+Datos!G103","v":284.65100000000001},{"$f":"+Datos!H103","v":212.65},{"$f":"+I16*$C$9","v":249.21569785949495},{"$f":"+J16*$C$9","v":249.59325765760423},249.97138945580164,250.35009412066285,250.7293725200762,251.10922552324502,251.48965400068943]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D65","v":0},{"$f":"+Datos!E65","v":0},{"$f":"+Datos!F65","v":0},{"$f":"+Datos!G65","v":575.524},{"$f":"+Datos!H65","v":596.26700000000005},{"$f":"I16*$C$11","v":587.22727645927807},{"$f":"J16*$C$11","v":588.11692110786373},589.00791356100888,589.90025586062688,590.79395005172444,591.68899818240629,592.58540230388007]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D81","v":0},{"$f":"+Datos!E81","v":0},{"$f":"+Datos!F81","v":406},{"$f":"+Datos!G81","v":490},{"$f":"+Datos!H81","v":505}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",null,null,{"$f":"(F18*1000/F19)/12","v":0},{"$f":"(G18*1000/G19)/12","v":97.878231292517},{"$f":"(H18*1000/H19)/12","v":98.393894389438955}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D119","v":0},{"$f":"+Datos!E119","v":0},{"$f":"+Datos!F119","v":0},{"$f":"+Datos!G119","v":0.16900000000000001},{"$f":"+Datos!H119","v":0.159}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D13","v":0},{"$f":"+Datos!E13","v":0},{"$f":"+Datos!F13","v":0.56999999999999995},{"$f":"+Datos!G13","v":0.69499999999999995},{"$f":"+Datos!H13","v":0.46400000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D29","v":0},{"$f":"+Datos!E29","v":0},{"$f":"+Datos!F29","v":0.13},{"$f":"+Datos!G29","v":0.64800000000000002},{"$f":"+Datos!H29","v":0.39800000000000002}]
[null,"Factor de Planta (****)",null,null,null,{"$f":"F16/(F23*8760)","v":0.16684229012996138},{"$f":"G16/(G23*8760)","v":0.11967011246406221},{"$f":"H16/(H23*8760)","v":0.19513496181439921}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1  -  Cuando el crecimiento NO es un datos consistente, asumimos el promedio de los SA"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]
[]
[null,"CALCULOS LINEA DE BASE",null,null,"Factores de Emisiones"]
[null,"Categoría","Pequeña Escala",null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Metodología Aplicable","AMS-I.A",null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"NCV - PCI (Diesel BTU/litro) =",33710]
[null,"NCV - PCI (Diesel BTU/pc) =",940]
[]
[null,null,null,"Ecuación (5)"]
[]
[null,null,"FC j,y =  GEN  j,bl * Consumo especifico (litros/kWh o pc/kWh)"]
[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"]
[]
[null,null,null,{"$f":"+D13","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",{"$f":"+D14","v":0},0,190,679.30499999999995,680.3341416666666,{"$f":"+I14","v":681.36484247476471},682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"GEN  j,bl =","MWh",{"$f":"+D16","v":0},0,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",{"$f":"+D17","v":0},0,0,284.65100000000001,212.65,{"$f":"+I17","v":249.21569785949495},249.59325765760423,249.97138945580164,250.35009412066285,250.7293725200762,251.10922552324502,251.48965400068943]
[null,"NCV j =","Btu/litro",null,null,null,{"$f":"+C34","v":33710},{"$f":"+G53","v":33710},{"$f":"+H53","v":33710},33710,33710,33710,33710,33710,33710]
[null,"EF co2,j =","gCO2/BTU",null,null,null,{"$f":"+F33","v":7.6597356000000005E-2},{"$f":"+G54","v":7.6597356000000005E-2},{"$f":"+H54","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",null,null,null,{"$f":"G52*G53*G54/1000","v":734.99645635870479},{"$f":"H52*H53*H54/1000","v":549.08289956711405},{"$f":"I52*I53*I54/1000","v":643.49907358727148},{"$f":"J52*J53*J54/1000","v":644.47396956049431},645.4503424933547,646.42819462343505,647.40752819170723,648.38834544253814,649.37064862369539]
[null,"EF bl =","tCO2/MWh",null,null,null,{"$f":"+G55/G50","v":1.0819829919678272},{"$f":"+H55/H50","v":0.80707826630893997},{"$f":"+I55/I50","v":0.94442658833120574},0.94442658833120596,0.94442658833120585,0.94442658833120596,0.94442658833120607,0.94442658833120585,0.94442658833120607]
{"$rows_empty":21}
[null,"ACTIVIDADES DEL PROYECTO",{"$nulls":7},"Proyecto:","Planta Solar Huacaraje"]
[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.",{"$nulls":8},"Potencia Instalada MW",250,"kWp"]
[{"$nulls":10},"Potencia a Temp. Media",{"$f":"+L79*0.95","v":237.5},"kWp"]
[{"$nulls":10},"Mes/Año de puesta en operación","2021-05-01"]
[{"$nulls":10},"Factor de Planta",0.13736980593607304]
[null,"Opción 2: basada en la generación anual de electricidad por la actividad del proyecto",{"$nulls":8},"Categoría","Pequeña Escala"]
[{"$nulls":10},"Metodología Aplicable","AMS I.A"]
[{"$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,"TDL  =",{"$f":"1-C11","v":0.13816029261734786},"(1 - Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta))"]
[]
[null,"Emisiones Reducidas por la Planta Solar",null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG  i,y =","MWh",{"$nulls":7},{"$f":"L97/12*8","v":190.53192083333332},{"$f":"L80*L82*8760/1000","v":285.79788124999999},{"$f":"+L97","v":285.79788124999999},{"$f":"+M97","v":285.79788124999999},{"$f":"+N97","v":285.79788124999999}]
[null,"TDL  =","%",{"$nulls":7},{"$f":"+C94","v":0.13816029261734786},{"$f":"+K98","v":0.13816029261734786},{"$f":"+L98","v":0.13816029261734786},0.13816029261734786,0.13816029261734786]
[null,"E BL,y =","MWh",{"$nulls":7},{"$f":"+K97*(1-K98)","v":164.20797489805463},{"$f":"+L97*(1-L98)","v":246.31196234708196},{"$f":"+M97*(1-M98)","v":246.31196234708196},{"$f":"+N97*(1-N98)","v":246.31196234708196},{"$f":"+O97*(1-O98)","v":246.31196234708196}]
[null,"EF CO2,y =","tCO2/MWh",{"$nulls":7},{"$f":"+K56","v":0.94442658833120585},{"$f":"+L56","v":0.94442658833120596},0.94442658833120607,0.94442658833120585,0.94442658833120607]
[null,"BE CO2, y =","tCO2/año",{"$nulls":7},{"$f":"+K100*K99","v":155.08237750974601},{"$f":"+L100*L99","v":232.62356626461909},232.62356626461911,232.62356626461906,232.62356626461911]
[]
[]
[]
[null,null,null,{"$f":"+D96","v":2014},{"$f":"+E96","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Sin Proyecto"]
[null,"Generación total","MWh",{"$f":"+D50","v":0},{"$f":"+E50","v":0},190,679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D51","v":0},{"$f":"+E51","v":0},190,679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+D52","v":0},{"$f":"+E52","v":0},0,284.65100000000001,212.65,249.21569785949495,249.59325765760423,249.97138945580164,250.35009412066285,250.7293725200762,251.10922552324502,251.48965400068943]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D55","v":0},{"$f":"+E55","v":0},{"$f":"+F55","v":0},{"$f":"+G55","v":734.99645635870479},{"$f":"+H55","v":549.08289956711405},{"$f":"+I55","v":643.49907358727148},{"$f":"+J55","v":644.47396956049431},{"$f":"+K55","v":645.4503424933547},{"$f":"+L55","v":646.42819462343505},{"$f":"+M55","v":647.40752819170723},{"$f":"+N55","v":648.38834544253814},{"$f":"+O55","v":649.37064862369539}]
[null,"Factor Emisiones","tCO2/MWh",null,null,null,{"$f":"+G56","v":1.0819829919678272},{"$f":"+H56","v":0.80707826630893997},0.94442658833120574,0.94442658833120596,0.94442658833120585,0.94442658833120596,0.94442658833120607,0.94442658833120585,0.94442658833120607]
[]
[]
[null,"Con Proyecto"]
[null,"Generación total","MWh",{"$f":"+D107","v":0},{"$f":"+E107","v":0},190,679.30499999999995,680.3341416666666,681.36484247476471,682.39710478638108,683.4309309671811,684.46632338641416,685.50328441691897,686.54181643512925,687.58192182107871]
[null,"Generación Planta Solar","MWh",{"$f":"+D97","v":0},{"$f":"+E97","v":0},0,0,0,0,0,190.53192083333332,285.79788124999999,285.79788124999999,285.79788124999999,285.79788124999999]
[null,"Generación Combustible Fosil","MWh",{"$f":"+D115-D116","v":0},{"$f":"+E115-E116","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":"+D52","v":0},{"$f":"+E52","v":0},0,284.65100000000001,212.65,{"$f":"+I117*$C$9","v":249.21569785949495},{"$f":"+J117*$C$9","v":249.59325765760423},180.28251991782307,145.81678981369495,146.1960682131083,146.57592121627715,146.95634969372153]
[null,"Emisiones de CO2e","tCO2/año",{"$f":"+D110-D101","v":0},{"$f":"+E110-E101","v":0},{"$f":"+F110-F101","v":0},{"$f":"+G110-G101","v":734.99645635870479},{"$f":"+H110-H101","v":549.08289956711405},{"$f":"+I110-I101","v":643.49907358727148},{"$f":"+J110-J101","v":644.47396956049431},{"$f":"+K110-K101","v":490.36796498360866},{"$f":"+L110-L101","v":413.80462835881599},{"$f":"+M110-M101","v":414.78396192708811},{"$f":"+N110-N101","v":415.76477917791908},{"$f":"+O110-O101","v":416.74708235907627}]
[null,"Factor Emisiones con Proyecto","tCO2/MWh",null,null,null,{"$f":"G119/G115","v":1.0819829919678272},0.80707826630893997,0.94442658833120574,0.94442658833120596,{"$f":"K119/K115","v":0.7175091772472858},{"$f":"L119/L115","v":0.60456535876229422},{"$f":"M119/M115","v":0.60507946694945225},0.60559279744499628,0.60610535142534105]
[]
[]
[null,"Reducciones "]
[null,"Reduccion Consumo Combustible Fósil"]
[null,"Combustible Fósil Diesel","Miles de Litros",{"$f":"+D109-D118","v":0},{"$f":"+E109-E118","v":0},0,0,0,0,0,69.688869537978576,104.53330430696789,104.53330430696789,104.53330430696786,104.53330430696789]
[null,"Emisiones Reducidas (ER y)","tCO2/año",{"$f":"+D110-D119","v":0},{"$f":"+E110-E119","v":0},0,0,0,0,0,155.08237750974604,232.62356626461906,232.62356626461911,232.62356626461906,232.62356626461911]
[null,"Reducción Factor de Emisiones","tCO2/MWh",{"$nulls":7},{"$f":"+K120-K111","v":-0.22691741108392005},{"$f":"+L120-L111","v":-0.33986122956891174},{"$f":"+M120-M111","v":-0.33934712138175382},{"$f":"+N120-N111","v":-0.33883379088620957},{"$f":"+O120-O111","v":-0.33832123690586502}]
[]
[]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,null,"Combustible Fósil Diesel (SIN) proyecto (Miles de Litros)",{"$f":"+D109","v":0},{"$f":"+E109","v":0},0,284.65100000000001,212.65,249.21569785949495,249.59325765760423,249.97138945580164,250.35009412066285,250.7293725200762,251.10922552324502,251.48965400068943]
[null,null,"Combustible Fósil Diesel CON proyecto (Miles de Litros)",{"$f":"+D118","v":0},{"$f":"+E118","v":0},0,284.65100000000001,212.65,249.21569785949495,249.59325765760423,180.28251991782307,145.81678981369495,146.1960682131083,146.57592121627715,146.95634969372153]
[null,null,"Emisiones Planta SA SIN Proyecto(BE y) - tCO2/año",{"$f":"+D110","v":0},{"$f":"+E110","v":0},0,734.99645635870479,549.08289956711405,643.49907358727148,644.47396956049431,645.4503424933547,646.42819462343505,647.40752819170723,648.38834544253814,649.37064862369539]
[null,null,"Total Emisiones del SA CON Proyecto (PE y) tCO2/año",{"$f":"+D119","v":0},{"$f":"+E119","v":0},0,734.99645635870479,549.08289956711405,643.49907358727148,644.47396956049431,490.36796498360866,413.80462835881599,414.78396192708811,415.76477917791908,416.74708235907627]
[null,null,"Factor de Emisiones SA SIN Proyecto tCO2/MWh",{"$f":"+D111","v":0},{"$f":"+E111","v":0},0,1.0819829919678272,0.80707826630893997,0.94442658833120574,0.94442658833120596,0.94442658833120585,0.94442658833120596,0.94442658833120607,0.94442658833120585,0.94442658833120607]
[null,null,"Factor de Emisiones SA CON Proyecto tCO2/MWh",{"$f":"+D120","v":0},{"$f":"+E120","v":0},0,1.0819829919678272,0.80707826630893997,0.94442658833120574,0.94442658833120596,0.7175091772472858,0.60456535876229422,0.60507946694945225,0.60559279744499628,0.60610535142534105]

{"sheet":"Cobija (2)","index":2,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,3],[33,1,33,3],[33,4,33,6],[33,7,33,10],[50,3,50,7],[50,8,50,14]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Pando"]
[null,"Provincia","Nicolas Suarez"]
[null,"Sistema Eléctrico","Cobija"]
[null,"Empresa","ENDE"]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"SUM(F20:H20)/SUM(F19:H19)","v":0.26606625750993845}]
[null,"Energía Alternativa","Solar"]
[null,"Potencia Instalada MW",5.0999999999999996]
[null,"Potencia a Temp. Media (MW)",5.0999999999999996]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"((H17/D17)^(1/4))-1","v":4.974914610377823E-2}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(D21:H21)/SUM(D17:H17)","v":0.83270384196113723}]
[]
[null,null,"Unidades",2014,{"$f":"+D16+1","v":2015},{"$f":"+E16+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D18+D19","v":52004.804699999993},{"$f":"+E18+E19","v":60848.556793090902},61362.612889999989,62745.201599999993,63151.7791,{"$f":"H17*(1+$C$13)","v":66293.526185159426},{"$f":"I17*(1+$C$13)","v":69591.572505079574},73053.693813226448,76688.052700161323,80503.217838355893,84508.184184420548,88712.394186376288]
[null,"Generación Energía Renovable","MWh",{"$f":"+Datos!D37","v":0},{"$f":"+Datos!E37","v":4794.3755010909099},{"$f":"+Datos!F37","v":5627.8183999999992},{"$f":"+Datos!G37","v":5776.1255999999994},{"$f":"+Datos!H37","v":5319.8761000000022},{"$f":"AVERAGE(F18:H18)","v":5574.6067000000003},{"$f":"AVERAGE(G18:I18)","v":5556.869466666667},5483.7840888888895,5538.4200851851856,5526.3578802469137,5516.1873514403296,5526.9884389574763]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D38","v":52004.804699999993},{"$f":"+Datos!E38","v":56054.181291999994},{"$f":"+Datos!F38","v":55734.794489999993},{"$f":"+Datos!G38","v":56969.075999999994},{"$f":"+Datos!H38","v":57831.902999999998},{"$f":"+I17-I18","v":60718.919485159422},{"$f":"+J17-J18","v":64034.703038412903},67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D88","v":13406.099},{"$f":"+Datos!E88","v":14382.120999999999},{"$f":"+Datos!F88","v":14611.594999999999},{"$f":"+Datos!G88","v":14853.701024046875},{"$f":"+Datos!H88","v":15908.519},{"$f":"I19*$C$9","v":16155.255667463647},{"$f":"J19*$C$9","v":17037.473788190804},17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D56","v":42283.498689999993},{"$f":"+Datos!E56","v":48572.567869999999},{"$f":"+Datos!F56","v":51457.801999999996},{"$f":"+Datos!G56","v":52482.941159999995},{"$f":"+Datos!H56","v":55108.400999999998},{"$f":"+I17*$C$14","v":55202.873951533504},{"$f":"+J17*$C$14","v":57949.1697930968},60832.091507726225,63858.436115942495,67035.338784233303,70370.289647526399,73871.151468566386]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D72","v":13895},{"$f":"+Datos!E72","v":14516},{"$f":"+Datos!F72","v":15424},{"$f":"+Datos!G72","v":15589},{"$f":"+Datos!H72","v":17092}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D21*1000/D22)/12","v":253.58941279836867},{"$f":"(E21*1000/E22)/12","v":278.84499787590704},{"$f":"(F21*1000/F22)/12","v":278.01803466459194},{"$f":"(G21*1000/G22)/12","v":280.55541920585023},{"$f":"(H21*1000/H22)/12","v":268.68515972384745}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D110","v":0},{"$f":"+Datos!E110","v":0},{"$f":"+Datos!F110","v":11.57},{"$f":"+Datos!G110","v":11.45},{"$f":"+Datos!H110","v":12.36}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D4","v":20.61},{"$f":"+Datos!E4","v":25},{"$f":"+Datos!F4","v":25},{"$f":"+Datos!G4","v":24.16},{"$f":"+Datos!H4","v":22.560000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D20","v":15.96},{"$f":"+Datos!E20","v":19.260000000000002},{"$f":"+Datos!F20","v":19.66},{"$f":"+Datos!G20","v":19.2},{"$f":"+Datos!H20","v":19.500000000000004}]
[null,"Factor de Planta (****)",null,{"$f":"D19/(D26*8760)","v":0.37196876823909081},{"$f":"E19/(E26*8760)","v":0.33223671562421464},{"$f":"F19/(F26*8760)","v":0.32362255657826888},{"$f":"G19/(G26*8760)","v":0.33871454052511413},{"$f":"H19/(H26*8760)","v":0.3385546364594309}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]
[]
[null,"CALCULOS LINEA DE BASE",null,null,"Factores de Emisiones",null,null,"Dato obtenido de calculo de variables técnicas"]
[null,"Categoría","Gran Escala",null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Metodología Aplicable","AM0045",null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"PCI (Diesel BTU/litro) =",33710]
[]
[]
[{"$nulls":4},"Ecuación (1)",null,null,null,"Ecuación (8)"]
[]
[]
[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 (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"]
[]
[null,null,null,"Histórico",{"$nulls":4},"Proyectado"]
[null,null,"Unidades",2014,{"$f":"+D52+1","v":2015},{"$f":"+E52+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"EG y =","MWh",{"$f":"+D17","v":52004.804699999993},{"$f":"+E17","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":"+D19","v":52004.804699999993},{"$f":"+E19","v":56054.181291999994},55734.794489999993,56969.075999999994,57831.902999999998,60718.919485159422,64034.703038412903,67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"F  i,j,bl =","Miles Litros",{"$f":"+D20","v":13406.099},14382.120999999999,14611.594999999999,14853.701024046875,15908.519,16155.255667463647,17037.473788190804,17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"F  i,j,bl =","MMBTU",{"$f":"D55*$C$37/1000","v":451919.59729000001},{"$f":"E55*$C$37/1000","v":484821.29890999995},492556.86744999996,500718.26152062014,536276.17549000005,544593.66855019948,574333.24139991205,606040.84085153695,638147.71030731639,672474.47034924652,708486.60855852009,746097.68536635744]
[null,"EF bl =","tCO2/MWh",null,null,{"$f":"SUM(D56:F56)*$F$36/SUM(D54:F54)","v":0.66840407071704533},{"$f":"SUM(E56:G56)*$F$36/SUM(E54:G54)","v":0.67089111952391145},0.68700885093123643,{"$f":"+H57","v":0.68700885093123643},{"$f":"+I57","v":0.68700885093123643},0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643]
[null,"BE y =","tCO2/año",{"$f":"+F57*D54","v":34760.22315832493},{"$f":"+F57*E54","v":37466.842956284047},{"$f":"+F57*F54","v":37253.363517693942},{"$f":"+G57*G54","v":38220.047175882792},{"$f":"+H57*H54","v":39731.029227196726},41714.435105285636,43992.407754143002,46421.126037244525,48880.42734699438,51509.766406252682,54268.20097698961,57149.11001678287]
[null,"EF bl ini =","tCO2/MWh",{"$f":"+D58/D53","v":0.66840407071704544},{"$f":"+E58/E53","v":0.61573922095944023},0.60710197566839541,0.60913099649492231,0.62913554920255166,0.62923844160553788,{"$f":"+J58/J53","v":0.63215136791070414},{"$f":"+K58/K53","v":0.63543845101012442},{"$f":"+L58/L53","v":0.63739299181463704},{"$f":"+M58/M53","v":0.63984729790156003},0.64216503408192016,{"$f":"+O58/O53","v":0.64420660203035485}]

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

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

{"sheet":"Cobija","index":5,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[33,4,33,6],[50,3,50,7],[50,8,50,14],[1,1,1,3],[33,1,33,3],[33,7,33,10]]}
[]
[null,"FICHA TECNICA DEL SISTEMA AISLADO"]
[]
[null,"Departamento","Pando"]
[null,"Provincia","Nicolas Suarez"]
[null,"Sistema Eléctrico","Cobija"]
[null,"Empresa","ENDE"]
[null,"Combustible","Diesel"]
[null,"Consumo especifico (lts/kWh) (*)",{"$f":"SUM(F20:H20)/SUM(F19:H19)","v":0.26606625750993845}]
[null,"Energía Alternativa","Solar"]
[null,"Potencia Instalada MW",5.0999999999999996]
[null,"Potencia a Temp. Media (MW)",5.0999999999999996]
[null,"% Crecimiento Acumulativo Anual  (**)",{"$f":"((H17/D17)^(1/4))-1","v":4.974914610377823E-2}]
[null,"Factor  Ʃ(Energía Vendida)/Ʃ(Generación Total - Bruta)",{"$f":"SUM(D21:H21)/SUM(D17:H17)","v":0.83270384196113723}]
[]
[null,null,"Unidades",2014,{"$f":"+D16+1","v":2015},{"$f":"+E16+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Generación Total","MWh",{"$f":"+D18+D19","v":52004.804699999993},{"$f":"+E18+E19","v":60848.556793090902},61362.612889999989,62745.201599999993,63151.7791,{"$f":"H17*(1+$C$13)","v":66293.526185159426},{"$f":"I17*(1+$C$13)","v":69591.572505079574},73053.693813226448,76688.052700161323,80503.217838355893,84508.184184420548,88712.394186376288]
[null,"Generación Energía Renovable","MWh",{"$f":"+Datos!D37","v":0},{"$f":"+Datos!E37","v":4794.3755010909099},{"$f":"+Datos!F37","v":5627.8183999999992},{"$f":"+Datos!G37","v":5776.1255999999994},{"$f":"+Datos!H37","v":5319.8761000000022},{"$f":"AVERAGE(F18:H18)","v":5574.6067000000003},{"$f":"AVERAGE(G18:I18)","v":5556.869466666667},5483.7840888888895,5538.4200851851856,5526.3578802469137,5516.1873514403296,5526.9884389574763]
[null,"Generación Fósil","MWh",{"$f":"+Datos!D38","v":52004.804699999993},{"$f":"+Datos!E38","v":56054.181291999994},{"$f":"+Datos!F38","v":55734.794489999993},{"$f":"+Datos!G38","v":56969.075999999994},{"$f":"+Datos!H38","v":57831.902999999998},{"$f":"+I17-I18","v":60718.919485159422},{"$f":"+J17-J18","v":64034.703038412903},67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"Combustible Fósil","Miles de Litros",{"$f":"+Datos!D88","v":13406.099},{"$f":"+Datos!E88","v":14382.120999999999},{"$f":"+Datos!F88","v":14611.594999999999},{"$f":"+Datos!G88","v":14853.701024046875},{"$f":"+Datos!H88","v":15908.519},{"$f":"I19*$C$9","v":16155.255667463647},{"$f":"J19*$C$9","v":17037.473788190804},17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"Energía Vendida","MWh",{"$f":"+Datos!D56","v":42283.498689999993},{"$f":"+Datos!E56","v":48572.567869999999},{"$f":"+Datos!F56","v":51457.801999999996},{"$f":"+Datos!G56","v":52482.941159999995},{"$f":"+Datos!H56","v":55108.400999999998},{"$f":"+I17*$C$14","v":55202.873951533504},{"$f":"+J17*$C$14","v":57949.1697930968},60832.091507726225,63858.436115942495,67035.338784233303,70370.289647526399,73871.151468566386]
[null,"Cantidad de Usuarios",null,{"$f":"+Datos!D72","v":13895},{"$f":"+Datos!E72","v":14516},{"$f":"+Datos!F72","v":15424},{"$f":"+Datos!G72","v":15589},{"$f":"+Datos!H72","v":17092}]
[null,"Consumo  por usuario (***)","kWh/usuario-mes",{"$f":"(D21*1000/D22)/12","v":253.58941279836867},{"$f":"(E21*1000/E22)/12","v":278.84499787590704},{"$f":"(F21*1000/F22)/12","v":278.01803466459194},{"$f":"(G21*1000/G22)/12","v":280.55541920585023},{"$f":"(H21*1000/H22)/12","v":268.68515972384745}]
[null,"Demanda Máxima","MW",{"$f":"+Datos!D110","v":0},{"$f":"+Datos!E110","v":0},{"$f":"+Datos!F110","v":11.57},{"$f":"+Datos!G110","v":11.45},{"$f":"+Datos!H110","v":12.36}]
[null,"Potencia Instalada","MW",{"$f":"+Datos!D4","v":20.61},{"$f":"+Datos!E4","v":25},{"$f":"+Datos!F4","v":25},{"$f":"+Datos!G4","v":24.16},{"$f":"+Datos!H4","v":22.560000000000002}]
[null,"Pot. Efectiva a Temp. Media","MW",{"$f":"+Datos!D20","v":15.96},{"$f":"+Datos!E20","v":19.260000000000002},{"$f":"+Datos!F20","v":19.66},{"$f":"+Datos!G20","v":19.2},{"$f":"+Datos!H20","v":19.500000000000004}]
[null,"Factor de Planta (****)",null,{"$f":"D19/(D26*8760)","v":0.37196876823909081},{"$f":"E19/(E26*8760)","v":0.33223671562421464},{"$f":"F19/(F26*8760)","v":0.32362255657826888},{"$f":"G19/(G26*8760)","v":0.33871454052511413},{"$f":"H19/(H26*8760)","v":0.3385546364594309}]
[]
[null,"(*) Factor  Ʃ(Combustible Fósil)/Ʃ(Generación)  -  Consideramos los tres últimos años, por tecnología"]
[null,"(**)   F = C*(1+i)^n  -  i = ((F/C)^(1/n))-1"]
[null,"(***) Energía Vendida año i / Cantidad Usuarios año i"]
[null,"(****) Generación Fósil año i / ((Pot. Efectiva a Temp. Media año i) * 8760)"]
[]
[null,"CALCULOS LINEA DE BASE",null,null,"Factores de Emisiones",null,null,"Dato obtenido de calculo de variables técnicas"]
[null,"Categoría","Gran Escala",null,"Gas Natural",{"$f":"54300*0.00000105506","v":5.7289758000000003E-2},"gCO2/BTU"]
[null,"Metodología Aplicable","AM0045",null,"Diesel ",{"$f":"72600*0.00000105506","v":7.6597356000000005E-2},"gCO2/BTU"]
[null,"PCI (Diesel BTU/litro) =",33710]
[]
[]
[{"$nulls":4},"Ecuación (1)",null,null,null,"Ecuación (8)"]
[]
[]
[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 (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"]
[]
[null,null,null,"Histórico",{"$nulls":4},"Proyectado"]
[null,null,"Unidades",2014,{"$f":"+D52+1","v":2015},{"$f":"+E52+1","v":2016},{"$f":"+F52+1","v":2017},{"$f":"+G52+1","v":2018},{"$f":"+H52+1","v":2019},{"$f":"+I52+1","v":2020},{"$f":"+J52+1","v":2021},{"$f":"+K52+1","v":2022},{"$f":"+L52+1","v":2023},{"$f":"+M52+1","v":2024},{"$f":"+N52+1","v":2025}]
[null,"EG y =","MWh",{"$f":"+D17","v":52004.804699999993},{"$f":"+E17","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":"+D19","v":52004.804699999993},{"$f":"+E19","v":56054.181291999994},55734.794489999993,56969.075999999994,57831.902999999998,60718.919485159422,64034.703038412903,67569.909724337558,71149.632614976144,74976.85995810898,78991.996832980221,83185.405747418816]
[null,"F  i,j,bl =","Miles Litros",{"$f":"+D20","v":13406.099},{"$f":"+E20","v":14382.120999999999},14611.594999999999,14853.701024046875,15908.519,16155.255667463647,17037.473788190804,17978.073000638891,18930.51647307376,19948.812528900817,21017.10497058796,22132.82958666145]
[null,"F  i,j,bl =","MMBTU",{"$f":"+D55*33710/1000","v":451919.59729000001},{"$f":"+E55*33710/1000","v":484821.29890999995},492556.86744999996,500718.26152062014,536276.17549000005,544593.66855019948,574333.24139991205,606040.84085153695,638147.71030731639,672474.47034924652,708486.60855852009,746097.68536635744]
[null,"EF bl =","tCO2/MWh",null,null,{"$f":"SUM(D56:F56)*$F$36/SUM(D54:F54)","v":0.66840407071704533},{"$f":"SUM(E56:G56)*$F$36/SUM(E54:G54)","v":0.67089111952391145},{"$f":"SUM(F56:H56)*$F$36/SUM(F54:H54)","v":0.68700885093123643},{"$f":"+H57","v":0.68700885093123643},0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643,0.68700885093123643]
[null,"BE y =","tCO2/año",{"$f":"+F57*D54","v":34760.22315832493},{"$f":"+F57*E54","v":37466.842956284047},{"$f":"+F57*F54","v":37253.363517693942},{"$f":"+G57*G54","v":38220.047175882792},{"$f":"+H57*H54","v":39731.029227196726},41714.435105285636,43992.407754143002,46421.126037244525,48880.42734699438,51509.766406252682,54268.20097698961,57149.11001678287]
[null,"EF bl ini =","tCO2/MWh",{"$f":"+D58/D53","v":0.66840407071704544},{"$f":"+E58/E53","v":0.61573922095944023},0.60710197566839541,0.60913099649492231,0.62913554920255166,{"$f":"+I58/I53","v":0.62923844160553788},0.63215136791070414,0.63543845101012442,0.63739299181463704,0.63984729790156003,0.64216503408192016,0.64420660203035485]

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

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

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

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

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

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

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

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

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

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

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