{"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":6,"images":7,"macros":0,"external_links":11,"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":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,1,1,3],[34,1,34,3],[34,4,34,6]]}
[]
[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)"]
[]
[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},{"$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,"GEN  j,bl =","MWh",{"$f":"+D17","v":45834.749141093853},{"$f":"+E17","v":51150.008000000002},{"$f":"+F17","v":55241.41},{"$f":"+G17","v":59494.525999999991},{"$f":"+H17","v":58424.895768660623},{"$f":"+I17","v":62079.572583879868},{"$f":"+J17","v":65962.861918607712},{"$f":"+K17","v":70089.064266901099},{"$f":"+L17","v":74473.374667572047},{"$f":"+M17","v":79131.938661017935},{"$f":"+N17","v":84081.911746342681},{"$f":"+O17","v":89341.522557723918}]
[null,"F  i,j,bl =","MMBTU (gas)",{"$f":"D20*1000*$C$39/1000000","v":537645.62228977226},{"$f":"E20*1000*$C$39/1000000","v":576145.31605999987},{"$f":"F20*1000*$C$39/1000000","v":623368.88283999998},{"$f":"G20*1000*$C$39/1000000","v":582877.01890000002},{"$f":"H20*1000*$C$39/1000000","v":601738.73766126961},{"$f":"I20*1000*$C$39/1000000","v":648177.26102286193},{"$f":"J20*1000*$C$39/1000000","v":688722.96293377981},{"$f":"K20*1000*$C$39/1000000","v":731804.93700712256},{"$f":"L20*1000*$C$39/1000000","v":777581.83573079179},{"$f":"M20*1000*$C$39/1000000","v":826222.2358477792},{"$f":"N20*1000*$C$39/1000000","v":877905.25915222487},{"$f":"O20*1000*$C$39/1000000","v":932821.23211838806}]
[null,"F  i,j,bl =","MMBTU (Diesel)",{"$f":"+D21*$C$38/1000","v":3921.0123599999997},{"$f":"+E21*$C$38/1000","v":13906.35259},{"$f":"+F21*$C$38/1000","v":19531.978520000001},{"$f":"+G21*$C$38/1000","v":118230.34140261535},{"$f":"+H21*$C$38/1000","v":121941.4071858},{"$f":"+I21*$C$38/1000","v":93105.907454117943},{"$f":"+J21*$C$38/1000","v":98930.000023830944},{"$f":"+K21*$C$38/1000","v":105118.40947942257},{"$f":"+L21*$C$38/1000","v":111693.92508664494},{"$f":"+M21*$C$38/1000","v":118680.76165767325},{"$f":"+N21*$C$38/1000","v":126104.64872390438},{"$f":"+O21*$C$38/1000","v":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 energia renovable por lo que la Gen. Fosil = Gen. Total)"]

{"sheet":"Huacaraje (2)","index":1,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,1,1,3],[30,1,30,3],[30,4,30,6]]}
[]
[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,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,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},643.49907358727148,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},0.94442658833120574,0.94442658833120596,0.94442658833120585,0.94442658833120596,0.94442658833120607,0.94442658833120585,0.94442658833120607]

{"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)"]