{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Termo CS","Termo CC","Hidro","Eolica","Solar","Geotermico","Biomasa","Gráfico1","Resumen","Conversion a CC"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Gráfico1","index":7,"reason":"not_a_worksheet"}],"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":"Termo CS","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CENTRAL TERMOELECTRICA",null,null,null,"Financiamiento de la Inversión"]
[]
[null,null,"Tipo de unidad","SGT 800",null,null,"Tasa",4.4999999999999998E-2,"anual"]
[null,null,"Potencia Total ISO (2 unidades)",{"$f":"D7+D8","v":95},"MW"]
[null,null,"Potencia ciclo simple",{"$f":"47.5*2","v":95},"MW"]
[null,null,"Potencia Turbina de Vapor",0,"MW"]
[null,null,"Precio FOB",338,"$us/kW "]
[]
[null,null,"Potencia Total Sitio",{"$f":"D6*0.94","v":89.3},"MW"]
[null,null,"Potencia ciclo simple",{"$f":"D11-D13","v":89.3},"MW"]
[null,null,"Potencia Turbina de Vapor",0,"MW"]
[]
[null,null,"Costo de Instalación "]
[null,null,"Precio FOB",{"$f":"D9*D6","v":32110},"Miles de $us"]
[null,null,"Transporte + Montaje + Puesta en Marcha",{"$f":"D16*0.85","v":27293.5},"Miles de $us"]
[null,null,"Total Inversión",{"$f":"SUM(D16:D17)","v":59403.5},"Miles de $us"]
[null,null,"$us/kW Instalado",{"$f":"D18/D11","v":665.21276595744678}]
[]
[null,null,"Recuperación Inversión"]
[null,null,"Tasa de retorno",0.12,"anual"]
[null,null,"Vida Útil",20,"años"]
[null,null,"Repago anual",{"$f":"PMT(D22,D23,-D18)","v":7952.8681100859822},"Miles de $us/año"]
[]
[null,null,"Costo de Producción"]
[null,null,"Heat Rate",9775,"BTU/kWh"]
[null,null,"Consumo especifico",{"$f":"D27/920","v":10.625},"pc/kWh"]
[null,null,"Precio del gas",{"$f":"+Resumen!E12","v":6.09},"$us/mpc"]
[null,null,"Costo de Combustible",{"$f":"D29*D28","v":64.706249999999997},"$us/MWh"]
[null,null,"Costo Variable O&M&A",3.0630000000000002,"$us/MWh"]
[null,null,"Total Costo Variable de Producción",{"$f":"D31+D30","v":67.76925},"$us/MWh"]
[]
[null,null,"Factor de Planta",0.56999999999999995,"(Equivalente a 5000 horas/año)"]
[null,null,"Energía generada",{"$f":"D11*D34*8760","v":445892.75999999995},"MWh/año"]
[null,null,"Gas consumido",{"$f":"D35*D28","v":4737610.5749999993},"mpc/año"]
[null,null,"Gas consumido",{"$f":"D36/35.31/365/1000","v":0.36759430756159717},"MM3dia"]
[]
[null,null,"Costo Total de Producción"]
[null,null,"Recuperación Inversión",{"$f":"D24*1000/D35","v":17.835831445404008},"$us/MWh"]
[null,null,"Costo Variable de Producción",{"$f":"D32","v":67.76925},"$us/MWh"]
[null,null,"Costo Total de Producción",{"$f":"SUM(D40:D41)","v":85.605081445404011},"$us/MWh"]

{"sheet":"Termo CC","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CENTRAL TERMOELECTRICA  CC configuracion 2 x 1",null,null,null,"Financiamiento de la Inversión"]
[]
[null,null,"Tipo de unidad","SGT 800",null,null,"Tasa",4.4999999999999998E-2,"anual"]
[null,null,"Potencia Total ISO",{"$f":"+D7+D8","v":142.5},"MW"]
[null,null,"Potencia ciclo simple",{"$f":"'Termo CS'!D7","v":95},"MW"]
[null,null,"Potencia Turbina de Vapor",{"$f":"D7*0.5","v":47.5},"MW"]
[null,null,"Precio FOB",964,"$us/kW "]
[null,null,"Eficiencia",0.53800000000000003]
[]
[]
[null,null,"Potencia Total Sitio",{"$f":"+D14+D15","v":136.80000000000001},"MW"]
[null,null,"Potencia ciclo simple",{"$f":"'Termo CS'!D12","v":89.3},"MW"]
[null,null,"Potencia Turbina de Vapor",{"$f":"D8","v":47.5},"MW"]
[]
[null,null,"Costo de Instalación "]
[null,null,"Precio FOB",{"$f":"D9*D6","v":137370},"Miles de $us"]
[null,null,"Transporte + Montaje + Puesta en Marcha",{"$f":"D18*0.8","v":109896},"Miles de $us"]
[null,null,"Total Inversión",{"$f":"SUM(D18:D19)","v":247266},"Miles de $us"]
[null,null,"$us/kW Instalado",{"$f":"D20/D13","v":1807.4999999999998}]
[]
[null,null,"Recuperación Inversión"]
[null,null,"Tasa de retorno",0.12,"anual"]
[null,null,"Vida Útil",20,"años"]
[null,null,"Repago anual",{"$f":"PMT(D24,D25,-D20)","v":33103.670425286735},"Miles de $us/año"]
[]
[null,null,"Costo de Producción"]
[null,null,"Heat Rate",{"$f":"3412/D10","v":6342.0074349442375},"BTU/kWh"]
[null,null,"Consumo especifico",{"$f":"D29/920","v":6.8934863423306929},"pc/kWh"]
[null,null,"Precio del gas",{"$f":"+Resumen!E12","v":6.09},"$us/mpc"]
[null,null,"Costo de Combustible",{"$f":"D31*D30","v":41.981331824793919},"$us/MWh"]
[null,null,"Costo Variable O&M&A",2.931,"$us/MWh"]
[null,null,"Total Costo Variable de Producción",{"$f":"D33+D32","v":44.912331824793917},"$us/MWh"]
[]
[null,null,"Factor de Planta",0.7]
[null,null,"Energía generada",{"$f":"D13*D36*8760","v":838857.60000000009},"MWh/año"]
[null,null,"Gas consumido",{"$f":"D37*D30","v":5782653.4087603046},"mpc/año"]
[null,null,"Gas consumido",{"$f":"D38/35.31/365/1000","v":0.44867986551679678},"MM3dia"]
[]
[null,null,"Costo Total de Producción"]
[null,null,"Recuperación Inversión",{"$f":"D26*1000/D37","v":39.462800867854966},"$us/MWh"]
[null,null,"Costo Variable de Producción",{"$f":"D34","v":44.912331824793917},"$us/MWh"]
[null,null,"Costo Total de Producción",{"$f":"SUM(D42:D43)","v":84.37513269264889},"$us/MWh"]

{"sheet":"Hidro","index":2,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Centrales Hidroeléctricas"]
[]
[null,"Potencia",{"$f":"'Termo CC'!D13","v":136.80000000000001},"MW"]
[null,"Inversión ",2500,"$us/kW-Instalado"]
[null,"Inversión Total",{"$f":"C5*C4/1000","v":342},"Millones de $us"]
[null,"Financiamiento"]
[null,"Tasa",4.4999999999999998E-2,"anual"]
[null,"Plazo",30,"años"]
[]
[]
[null,"Factor de Planta",0.5]
[null,"Energía generada",{"$f":"C12*C4*8760","v":599184},"MWh"]
[]
[null,"Recuperación de Capital"]
[null,"Plazo",30,"años"]
[null,"Tasa",0.1,"anual"]
[null,"Vida Útil",50,"años"]
[]
[null,"Monto anual a recuperar",{"$f":"PMT(C17,C16,-C6)","v":36.279102902400801},"Millones de $us/año"]
[]
[null,"Costo fijo por recuperación de capital",{"$f":"C20*1000000/C13","v":60.547516125932603},"$us/MWh"]
[null,"O&M&A",2,"$us/MWh"]
[null,"Total Costo de Producción",{"$f":"SUM(C22:C23)","v":62.547516125932603},"$us/MWh"]

{"sheet":"Eolica","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Centrales Eolicas"]
[]
[null,"Potencia",{"$f":"'Termo CC'!D13","v":136.80000000000001},"MW"]
[null,"Inversión ",1750,"$us/kW-Instalado",1.5564516129032258]
[null,"Inversión Total",{"$f":"C5*C4/1000","v":239.40000000000003},"Millones de $us"]
[null,"Financiamiento"]
[null,"Tasa",4.4999999999999998E-2,"anual"]
[null,"Plazo",20,"años"]
[]
[]
[null,"Factor de Planta",0.35]
[null,"Energía generada",{"$f":"C12*C4*8760","v":419428.80000000005},"MWh"]
[]
[null,"Recuperación de Capital"]
[null,"Plazo",20,"años"]
[null,"Tasa",0.1,"anual"]
[null,"Vida Útil",20,"años"]
[]
[null,"Monto anual a recuperar",{"$f":"PMT(C17,C16,-C6)","v":28.119834170547467},"Millones de $us/año"]
[]
[null,"Costo fijo por recuperación de capital",{"$f":"C20*1000000/C13","v":67.043164824512445},"$us/MWh"]
[null,"O&M&A",5,"$us/MWh"]
[null,"Total Costo de Producción",{"$f":"SUM(C22:C23)","v":72.043164824512445},"$us/MWh"]

{"sheet":"Solar","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Centrales Solares"]
[]
[null,"Potencia",{"$f":"'Termo CC'!D13","v":136.80000000000001},"MW"]
[null,"Inversión ",1200,"$us/kW-Instalado"]
[null,"Inversión Total",{"$f":"C5*C4/1000","v":164.16},"Millones de $us"]
[null,"Financiamiento"]
[null,"Tasa",4.4999999999999998E-2,"anual"]
[null,"Plazo",20,"años"]
[]
[]
[null,"Factor de Planta",0.24]
[null,"Energía generada",{"$f":"C12*C4*8760","v":287608.32000000001},"MWh"]
[]
[null,"Recuperación de Capital"]
[null,"Plazo",20,"años"]
[null,"Tasa",0.1,"anual"]
[null,"Vida Útil",20,"años"]
[]
[null,"Monto anual a recuperar",{"$f":"PMT(C17,C16,-C6)","v":19.282172002661117},"Millones de $us/año"]
[]
[null,"Costo fijo por recuperación de capital",{"$f":"C20*1000000/C13","v":67.043164824512431},"$us/MWh"]
[null,"O&M&A",5,"$us/MWh"]
[null,"Total Costo de Producción",{"$f":"SUM(C22:C23)","v":72.043164824512431},"$us/MWh"]

{"sheet":"Geotermico","index":5,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Centrales Hidroeléctricas"]
[]
[null,"Potencia",{"$f":"'Termo CC'!D13","v":136.80000000000001},"MW"]
[null,"Inversión ",5500,"$us/kW-Instalado"]
[null,"Inversión Total",{"$f":"C5*C4/1000","v":752.40000000000009},"Millones de $us"]
[null,"Financiamiento"]
[null,"Tasa",4.4999999999999998E-2,"anual"]
[null,"Plazo",30,"años"]
[]
[]
[null,"Factor de Planta",0.85]
[null,"Energía generada",{"$f":"C12*C4*8760","v":1018612.8},"MWh"]
[]
[null,"Recuperación de Capital"]
[null,"Plazo",30,"años"]
[null,"Tasa",0.1,"anual"]
[null,"Vida Útil",50,"años"]
[]
[null,"Monto anual a recuperar",{"$f":"PMT(C17,C16,-C6)","v":79.814026385281778},"Millones de $us/año"]
[]
[null,"Costo fijo por recuperación de capital",{"$f":"C20*1000000/C13","v":78.355609104148087},"$us/MWh"]
[null,"O&M&A",3,"$us/MWh"]
[null,"Total Costo de Producción",{"$f":"SUM(C22:C23)","v":81.355609104148087},"$us/MWh"]

{"sheet":"Biomasa","index":6,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Centrales Hidroeléctricas"]
[]
[null,"Potencia",20,"MW"]
[null,"Inversión ",4000,"$us/kW-Instalado"]
[null,"Inversión Total",{"$f":"+C5*C4/1000","v":80},"Millones de $us"]
[null,"Financiamiento",null,null,null,28.449356830943994]
[null,"Tasa",4.4999999999999998E-2,"anual"]
[null,"Plazo",30,"años"]
[]
[]
[null,"Factor de Planta",0.85]
[null,"Energía generada",{"$f":"C12*C4*8760","v":148920},"MWh"]
[]
[null,"Recuperación de Capital"]
[null,"Plazo",30,"años"]
[null,"Tasa",0.1,"anual"]
[null,"Vida Útil",30,"años"]
[]
[null,"Monto anual a recuperar",{"$f":"PMT(C17,C16,-C6)","v":8.4863398602107143},"Millones de $us/año"]
[]
[null,"Costo fijo por recuperación de capital",{"$f":"C20*1000000/C13","v":56.98589753028952},"$us/MWh"]
[null,"Combustible",{"$f":"+F7","v":28.449356830943994},"$us/MWh"]
[null,"O&M&A",3,"$us/MWh"]
[null,"Total Costo de Producción",{"$f":"SUM(C22:C24)","v":88.435254361233518},"$us/MWh"]

{"sheet":"Resumen","index":8,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[]
[]
[null,null,"RESUMEN"]
[null,null,"Tecnología",null,null,"Ciclo Simple","Ciclo Combinado","Hidroeléctricas","Eólicas","Solares","Geotermico","Biomasa",{"$nulls":6},"Precio de Gas (sin IVA)","Ciclo Simple","Ciclo Combinado","Hidroeléctricas","Eólicas","Solares"]
[null,null,"Inversion","$us/kW-instalado",null,{"$f":"+'Termo CS'!D19","v":665.21276595744678},{"$f":"+'Termo CC'!D21","v":1807.4999999999998},{"$f":"+Hidro!C5","v":2500},{"$f":"+Eolica!C5","v":1750},{"$f":"+Solar!C5","v":1200},{"$f":"+Geotermico!C5","v":5500},{"$f":"+Biomasa!C5","v":4000}]
[]
[]
[null,null,"Factor de Planta",null,null,{"$f":"+'Termo CS'!D34","v":0.56999999999999995},{"$f":"+'Termo CC'!D36","v":0.7},{"$f":"+Hidro!C12","v":0.5},{"$f":"+Eolica!C12","v":0.35},{"$f":"+Solar!C12","v":0.24},{"$f":"+Geotermico!C12","v":0.85},{"$f":"+Biomasa!C12","v":0.85},{"$nulls":4},1,1.3,{"$f":"R8*0.87","v":1.131},32.915706445404012,40.430716502099102,{"$f":"+H16","v":62.547516125932603},{"$f":"+I16","v":72.043164824512445},{"$f":"+J16","v":72.043164824512431}]
[null,null,"Energía Generada","MWh/año",null,{"$f":"+'Termo CS'!D35","v":445892.75999999995},{"$f":"+'Termo CC'!D37","v":838857.60000000009},{"$f":"+Hidro!C13","v":599184},{"$f":"+Eolica!C13","v":419428.80000000005},{"$f":"+Solar!C13","v":287608.32000000001},{"$f":"+Geotermico!C13","v":1018612.8},{"$f":"+Biomasa!C13","v":148920},{"$nulls":4},{"$f":"+Q8+1","v":2},2,{"$f":"R9*0.87","v":1.74},39.386331445404011,44.628849684578498,{"$f":"+V8","v":62.547516125932603},{"$f":"+W8","v":72.043164824512445},{"$f":"+X8","v":72.043164824512431}]
[null,null,"Consumo de Gas","MMpc/año",null,{"$f":"+'Termo CS'!D36","v":4737610.5749999993},{"$f":"+'Termo CC'!D38","v":5782653.4087603046},{"$nulls":9},{"$f":"+Q9+1","v":3},{"$f":"R9+1","v":3},2.61,48.630081445404002,50.626182802406198,{"$f":"+V9","v":62.547516125932603},{"$f":"+W9","v":72.043164824512445},{"$f":"+X9","v":72.043164824512431}]
[null,"Con IVA",{"$nulls":14},{"$f":"+Q10+1","v":4},{"$f":"R10+1","v":4},{"$f":"R11*0.87","v":3.48},57.873831445404008,56.623515920233899,62.547516125932603,72.043164824512445,72.043164824512431]
[null,7,"Precio Gas","$us/mpc  (s/IVA)",{"$f":"VLOOKUP(B12,$Q$8:$S$18,3,0)","v":6.09},{"$nulls":11},{"$f":"+Q11+1","v":5},5,{"$f":"R12*0.87","v":4.3499999999999996},67.117581445403999,62.620849038061593,62.547516125932603,72.043164824512445,72.043164824512431]
[{"$nulls":16},{"$f":"+Q12+1","v":6},6,{"$f":"R13*0.87","v":5.22},76.361331445404005,68.618182155889301,62.547516125932603,72.043164824512445,72.043164824512431]
[null,null,"Recuperación de Capital","$us/MWh",null,{"$f":"+'Termo CS'!D40","v":17.835831445404008},{"$f":"+'Termo CC'!D42","v":39.462800867854966},{"$f":"+Hidro!C22","v":60.547516125932603},{"$f":"+Eolica!C22","v":67.043164824512445},{"$f":"+Solar!C22","v":67.043164824512431},{"$f":"+Geotermico!C22","v":78.355609104148087},{"$f":"+Biomasa!C22","v":56.98589753028952},{"$nulls":4},{"$f":"+Q13+1","v":7},7,{"$f":"R14*0.87","v":6.09},85.605081445404011,74.615515273717008,62.547516125932603,72.043164824512445,72.043164824512431]
[null,null,"Costo Variable","$us/MWh",null,{"$f":"+'Termo CS'!D41","v":67.76925},{"$f":"+'Termo CC'!D43","v":44.912331824793917},{"$f":"+Hidro!C23","v":2},{"$f":"+Eolica!C23","v":5},{"$f":"+Solar!C23","v":5},{"$f":"+Geotermico!C23","v":3},{"$f":"+Biomasa!C23+Biomasa!C24","v":31.449356830943994},{"$nulls":4},{"$f":"+Q14+1","v":8},8,{"$f":"R15*0.87","v":6.96},94.848831445404016,80.612848391544702,62.547516125932603,72.043164824512445,72.043164824512431]
[null,null,"Costo de Producción Energía","$us/MWh",null,{"$f":"SUM(F14:F15)","v":85.605081445404011},{"$f":"SUM(G14:G15)","v":84.37513269264889},{"$f":"SUM(H14:H15)","v":62.547516125932603},{"$f":"SUM(I14:I15)","v":72.043164824512445},{"$f":"SUM(J14:J15)","v":72.043164824512431},81.355609104148087,88.435254361233518,{"$nulls":4},{"$f":"+Q15+1","v":9},{"$f":"R15+1","v":9},{"$f":"R16*0.87","v":7.83},104.09258144540401,86.61018150937241,62.547516125932603,72.043164824512445,72.043164824512431]
[{"$nulls":16},10,10,8.6999999999999993,113.336331445404,92.607514627200104,62.547516125932603,72.043164824512445,72.043164824512431]
[{"$nulls":16},11,11,9.57,122.58008144540402,98.604847745027811,62.547516125932603,72.043164824512445,72.043164824512431]

{"sheet":"Conversion a CC","index":9,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"CENTRAL TERMOELECTRICA  CC configuracion 2 x 1",null,null,null,"Financiamiento de la Inversión"]
[]
[null,null,"Tipo de unidad","SGT 800",null,null,"Tasa",4.4999999999999998E-2,"anual"]
[null,null,"Potencia Total ISO",{"$f":"+D7+D8","v":47.5},"MW"]
[null,null,"Potencia ciclo simple",null,"MW"]
[null,null,"Potencia Turbina de Vapor",47.5,"MW"]
[null,null,"Precio FOB",{"$f":"'Termo CC'!D9-'Termo CS'!D9","v":626},"$us/kW "]
[null,null,"Eficiencia",0]
[]
[]
[null,null,"Potencia Total Sitio",{"$f":"+D14+D15","v":38.479999999999997},"MW"]
[null,null,"Potencia ciclo simple",{"$f":"D7*0.87","v":0},"MW"]
[null,null,"Potencia Turbina de Vapor",38.479999999999997,"MW"]
[]
[null,null,"Costo de Instalación "]
[null,null,"Precio FOB",{"$f":"D9*D6","v":29735},"Miles de $us"]
[null,null,"Transporte + Montaje + Puesta en Marcha",{"$f":"D18*0.887","v":26374.945},"Miles de $us"]
[null,null,"Total Inversión",{"$f":"SUM(D18:D19)","v":56109.945},"Miles de $us"]
[null,null,"$us/kW Instalado",{"$f":"D20/D13","v":1458.158653846154}]
[]
[null,null,"Recuperación Inversión"]
[null,null,"Tasa de retorno",0.12,"anual"]
[null,null,"Vida Útil",20,"años"]
[null,null,"Repago anual",{"$f":"PMT(D24,D25,-D20)","v":7511.930984692458},"Miles de $us/año"]
[]
[null,null,"Costo de Producción"]
[null,null,"Heat Rate",0,"BTU/kWh"]
[null,null,"Consumo especifico",{"$f":"D29/920","v":0},"pc/kWh"]
[null,null,"Precio del gas",{"$f":"1.3*0.87","v":1.131},"$us/mpc"]
[null,null,"Costo de Combustible",{"$f":"D31*D30","v":0},"$us/MWh"]
[null,null,"Costo Variable O&M&A",{"$f":"'Termo CC'!D33","v":2.931},"$us/MWh"]
[null,null,"Total Costo Variable de Producción",{"$f":"D33+D32","v":2.931},"$us/MWh"]
[]
[null,null,"Factor de Planta",0.9]
[null,null,"Energía generada",{"$f":"D13*D36*8760","v":303376.32},"MWh/año"]
[null,null,"Gas consumido",{"$f":"D37*D30","v":0},"mpc/año"]
[null,null,"Gas consumido",{"$f":"D38/35.31/365/1000","v":0},"MM3dia"]
[]
[null,null,"Costo Total de Producción"]
[null,null,"Recuperación Inversión",{"$f":"D26*1000/D37","v":24.761098640435936},"$us/MWh"]
[null,null,"Costo Variable de Producción",{"$f":"D34","v":2.931},"$us/MWh"]
[null,null,"Costo Total de Producción",{"$f":"SUM(D42:D43)","v":27.692098640435937},"$us/MWh"]