{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Curvas (3)","Curvas (2)","Curvas","Orden","Merito","GARABITO","OROTINA","GUAPILES","SAN ANTONIO","BARRANCA","MOIN I","MOIN II","MOIN III"],"not_rendered":{"charts":24,"images":10,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Curvas (3)","index":0,"reason":"not_a_worksheet"},{"sheet":"Curvas (2)","index":1,"reason":"not_a_worksheet"},{"sheet":"Curvas","index":2,"reason":"not_a_worksheet"},{"sheet":"Merito","index":4,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Orden","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10]]}
[]
["Planta","CV"]
[{"$f":"GARABITO!$F$8","v":"Garabito"},{"$f":"GARABITO!$E$63","v":18.294443891745587}]
[{"$f":"OROTINA!$F$8","v":"Orotina"},{"$f":"OROTINA!$E$63","v":21.962849609748844}]
[{"$f":"GUAPILES!$F$8","v":"Guapiles"},{"$f":"GUAPILES!$E$63","v":20.700004058503406}]
[{"$f":"'MOIN I'!$F$8","v":"Moín I"},{"$f":"'MOIN I'!E63","v":22.801264434447326}]
[{"$f":"'MOIN III'!$F$8","v":"Moín III"},{"$f":"'MOIN III'!E64","v":43.014520898685014}]
[{"$f":"'MOIN II'!$F$8","v":"Moín II"},{"$f":"'MOIN II'!$E$63","v":43.885661207169683}]
[{"$f":"'SAN ANTONIO'!$F$8","v":"San Antonio"},{"$f":"'SAN ANTONIO'!$E$63","v":48.47144508473454}]
[{"$f":"BARRANCA!$F$8","v":"Barranca"},{"$f":"BARRANCA!E63","v":49.958578892884248}]

{"sheet":"GARABITO","index":5,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[69,4,69,9],[71,4,71,7],[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,4,77,7],[78,4,78,7],[45,17,45,18],[32,11,32,12],[34,11,34,12],[36,11,36,14],[52,1,52,6],[45,6,45,7],[60,1,60,2],[46,1,46,4],[47,1,47,2],[48,1,48,2],[46,6,46,7],[47,6,47,7],[58,1,58,9],[60,4,61,4],[70,4,70,7],[72,4,72,7],[73,4,73,7],[12,11,12,14],[22,11,22,14],[22,16,22,18],[30,11,30,14],[23,11,23,12],[24,11,24,12],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,17,1,18],[2,12,3,16],[2,17,2,18],[3,17,3,18],[4,12,5,16],[4,17,4,18],[5,17,5,18],[0,1,5,1],[4,8,4,9],[5,8,5,9],[0,8,0,9],[1,8,1,9],[2,8,2,9],[3,8,3,9],[0,2,1,7],[4,2,5,7],[2,2,3,7],[12,1,12,2],[17,1,17,2],[16,1,16,4],[18,1,18,2],[29,1,29,2],[24,1,24,9],[26,1,26,4],[27,1,27,2],[28,1,28,2],[17,6,17,7],[12,6,12,7],[16,6,16,9],[18,6,18,7],[19,6,19,7],[34,1,34,2],[36,1,36,2],[13,11,13,12],[25,11,25,12],[31,11,31,12],[16,11,16,12],[43,1,43,2],[40,6,40,7],[40,1,40,2],[41,1,41,2],[26,6,26,9],[27,6,27,7],[28,6,28,7],[29,6,29,7],[34,6,34,7],[13,1,13,2],[31,1,31,2],[33,1,33,4],[39,1,39,4],[42,1,42,2],[35,1,35,2],[37,1,37,2],[56,1,56,6],[48,11,54,18],[12,16,12,18],[13,16,19,18],[10,13,10,16],[19,1,19,2],[7,12,7,14],[40,11,40,12],[43,17,43,18],[7,5,7,6],[9,1,9,4],[9,6,9,9],[11,1,11,2],[10,1,10,2],[10,6,10,7],[11,6,11,7],[32,6,32,7],[33,6,33,7],[38,6,38,7],[39,6,39,7],[26,11,26,12],[28,11,28,12],[30,1,30,2],[20,1,20,2]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Garabito",null,"Unidad:","1-11",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Normal"]
[null,"Tipo",null,"HFO Clase C",null,null,"Horas esperadas de operación, hop",null,{"$f":"-985.66+71.51*I12","v":3590.9800000000005},"hrs/periodo",null,null,"Descripción:","Arranque con no más de 18 horas desde último arranque."]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":37132.07547169811},"BTU/l",null,"Generación bruta (PP)",null,64,"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,41000,"kJ/kg",null,"Consumo por servicio propio:",null,2.2885059999999999,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,418.13,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,1216,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"Cuando la unidad tiene más de 18 horas sin utilizarse el arranque aumenta el tiempo de rampa de carga (tc) a 45 minutos. Con el aumento de combustible esto representa un aproximado de (X=) 2360 litros de combustible con una generación de (Ex=) 6 600 kWh. Adicionalmente las horas equivalentes suben a (hpa=) 5."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",5167,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":4.5339999999999998},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,361,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,"Diesel",null,null,"Potencia efectiva actual",null,18000,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",1658,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":33825.849056603773},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,42685,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,592.04999999999995,"colones/l",null,null,"Método calculo de repuestos","ALTERNATIVO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2",4.0099999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,13,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",1.5,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,43,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",6,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":76.388178209086846},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",30,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":0},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",10,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":4.5339999999999998},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,{"$f":"0.01*I19","v":5.4565000000000001},"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":8189.6946342518995},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,7.0000000000000007E-2,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":132.38817820908685},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.41674325508130083},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":6.1078248122989511E-9},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":94.380909693406991},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":93384.008467802996},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":17.296968696674973},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,null,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,0,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,null,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":55355.468954565484},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":0},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":0},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"114.23+0.3657*I12","v":137.63480000000001},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":454357.15502184036},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":0.12183250190459666},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,null,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":418.13},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,1003.44,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":0},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"N29*N39","v":55355.468954565484},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,2.6128259999999998E-4,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0.26832197667963198},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"N35+N41","v":55355.468954565484},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":78832.738279166661},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,{"$f":"+I19*26.6677727272727","v":14551.270188636347},"colones/h",null,null,null,null,null,null,{"$f":"Q44/I19","v":101.44867397519562},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h"]
[null,"Precio  quimicos (PQCME)",null,0,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":5.3095089001847624},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Normalmente la planta puede trabajar y arrancar solamente con búnker, pero existen condiciones que requieren la utilización de diesel. Cuando la calidad del búnker no es la adecuada se requiere el uso de diesel durante el arranque en la toma de carga por un lapso de tiempo. También se presenta consumo de diesel por los faltantes de búnker para la operación de las unidades debido a problemas en el proceso de suministro. Dentro del cálculo del costo no se utiliza este porcentaje, pero se puede considerar para el cálculo del requerimiento de combustible.\n2. Si desea calcular el costo de arranque en frío deberá sustituir los valores indicados en el cuadro \"Condiciones de Otros Arranques\""]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":100.08057307828381},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":18.341532681807717},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":1.0445639851327435},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":18000},4.5339999999999998,null,18.294443891745587,null,null,"Crear la curva de costo con las condiciones "]
[null,16000,4.5190000000000001,null,18.351701428123775,null,null,"actuales del calculo."]
[null,14000,4.4519000000000002,null,18.612556949779517]
[null,12000,4.335,null,19.086302631795039,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,10000,4.1769999999999996,null,19.768749375119878,null,null,"el botón"]
[]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,18000,4.5339999999999998,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,3000,"horas"]
[null,16000,4.5190000000000001,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,12000,"horas"]
[null,14000,4.4519000000000002,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,16000,"horas"]
[null,12000,4.335,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,32000,"horas"]
[null,10000,4.1769999999999996,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,52925,"$"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,58500,"$"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,701332,"$"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,2500000,"$"]
[null,17000,4.2606516290726821]
[null,16000,4.43213296398892]
[null,12000,4.395604395604396]
[null,8000,4.1710114702815435]
[null,4000,3.5714285714285716]

{"sheet":"OROTINA","index":6,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[75,4,75,7],[76,4,76,7],[77,4,77,7],[78,4,78,7],[77,1,77,2],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[74,4,74,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Orotina",null,"Unidad:","1 - 2",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Caliente"]
[null,"Tipo",null,"HFO Clase C",null,null,"Horas esperadas de operación, hop",null,{"$f":"1299.04+82.47*I12","v":2941.70203606},"hrs/periodo",null,null,"Descripción:","Arranque después de no más de 3 horas de la última parada. Utiliza solo búnker"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":37132.07547169811},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"39.836596/2","v":19.918298},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,41000,"kJ/kg",null,"Consumo por servicio propio:",null,3.93,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,471.56,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,260,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"2. Arranque tibio, no más de 12 horas después de la última parada. El arranque se realiza en diesel y se requiere unos 15 minutos adicionales de diesel. \n3. Arranque en frío, puede llegar a requerir hasta 3 horas de operación en diesel luego del arranque. El arranque se realiza en diesel. \n4. Se utiliza 5 horas de penalización por mantenimento."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",967,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":4.37},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,252,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,"Diesel",null,null,"Potencia efectiva actual",null,5041,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",1058,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":33825.849056603773},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,42685,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,618.30999999999995,"colones/l",null,null,"Método calculo de repuestos","HISTORICO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2",4.0399999999999998E-2]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,7,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",5,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,15,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",10,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":38.718535469107564},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",30,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":9.8947368421052602},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",20,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":4.37},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":8497.0424420361815},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":70.613272311212825},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.40166917174796746},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":112.3227509308025},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":29741.9},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":20.585127999780536},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,null,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,5,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,null,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":185661.19732265448},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":0},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":148709.5},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"60.5+2.17*I12","v":103.72270666},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":184487.17262388492},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":1.0063637199382043},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,5.9,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":471.56},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,1003.44,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":6.1413552617882798},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"(N24+N26)*N39+(N25+N27)*D21","v":36951.697322654465},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,7.3999999999999999E-4,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0.77292141147080262},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"IF(L47=\"Caliente\",N35+N41,IF(L47=\"Tibio\",N35+N41+N46,N35+N41+N47))","v":185661.19732265448},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)","v":13103.055335999999},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,"TIPO ARRANQUE","Adicional arranque en tíbio",{"$f":"(15/60)*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":59749.469542057952},null,null,{"$f":"Q44/I19","v":340.25693635600567},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h",null,"Caliente","Adicional arranque en frío",{"$f":"3*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":716993.63450469542}]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":2.7056280141230582},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Esta planta utiliza normalmente diesel para arranques, por lo que el porcentaje de uso de diesel se verá afectado por el tipo de arranques que se realicen. Se considera que el porcentaje mostrado identifica las conficiones promedio utilizada en los últimos años. \n\n2. El proceso de parada siempre se realizan con diesel desde el inicio de la secuencia de paro.\n\n3. Para el arranque tíbio y caliente debe considerarse la utilización de diesel como tipo de combustible en el arranque. Adicionalmente se escoge el tipo de arranque en la pestaña indicada."]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":120.24339132399979},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":22.036725249518884},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":1.4515972497383487},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":5041},4.37,null,21.962849609748844,null,null,"Crear la curva de costo con las condiciones "]
[null,4650,4.46,null,21.54903446402518,null,null,"actuales del calculo."]
[null,4394,4.38,null,21.916030341612682]
[null,4178,4.3099999999999996,null,22.24832765304777,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,3865,4.28,null,22.394068196180513,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,5041,4.37,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,3750,"horas"]
[null,4650,4.46,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,750,"horas"]
[null,4394,4.38,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,1500,"horas"]
[null,4178,4.3099999999999996,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,30000,"horas"]
[null,3865,4.28,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,0,"colones"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,1130464.1000000001,"colones"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,792691.77,"colones"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,332019260.68000001,"colones"]
[null,5041,{"$f":"C72*$D$19/$D$12","v":3.980896798780488}]
[null,4650,{"$f":"C73*$D$19/$D$12","v":4.0628832317073176}]
[null,4394,3.9900064024390249]
[null,4178,3.9262391768292684]
[null,3865,3.8989103658536592]

{"sheet":"GUAPILES","index":7,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Guapiles",null,"Unidad:","1 - 2",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Caliente"]
[null,"Tipo",null,"HFO Clase C",null,null,"Horas esperadas de operación, hop",null,{"$f":"462.66+119.83*I12","v":3154.6882828499997},"hrs/periodo",null,null,"Descripción:","Arranque después de no más de 3 horas de la última parada. Utiliza solo búnker"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":37132.07547169811},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"44.93079/2","v":22.465395000000001},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,41000,"kJ/kg",null,"Consumo por servicio propio:",null,3.93,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,447.44,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,260,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"2. Arranque tibio, no más de 12 horas después de la última parada. El arranque se realiza en diesel y se requiere unos 15 minutos adicionales de diesel. \n3. Arranque en frío, puede llegar a requerir hasta 3 horas de operación en diesel luego del arranque. El arranque se realiza en diesel. \n4. Se utilizan 5 horas de penalización por mantenimento."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",967,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":4.3899999999999997},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,252,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,"Diesel",null,null,"Potencia efectiva actual",null,7360,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",1058,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":33825.849056603773},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,42685,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,475.15,"colones/l",null,null,"Método calculo de repuestos","HISTORICO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2",2.69E-2]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,7,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",5,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,15,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",10,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":39.726651480637798},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",30,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":10.997722095671975},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",20,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":4.3899999999999997},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":8458.3315425280434},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":72.724373576309773},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.40350747459349595},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":106.09196549687455},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":65136},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":19.443226518257958},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,null,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,5,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,null,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":358940.19059225509},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":0},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":325680},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"80.07+0.21*I12","v":84.787732949999992},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":254547.49437902035},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":1.4101108772172566},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,8.85,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":447.44},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,1003.44,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":9.2120328926824193},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"(N24+N26)*N39+(N25+N27)*D21","v":33260.190592255116},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,1.6199999999999999E-3,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":1.6920711980847298},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"IF(L47=\"Caliente\",N35+N41,IF(L47=\"Tibio\",N35+N41+N46,N35+N41+N47))","v":358940.19059225509},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)","v":17470.740448},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,"TIPO ARRANQUE","Adicional arranque en tíbio",{"$f":"(15/60)*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":-37802.456215075887},null,null,{"$f":"Q44/I19","v":657.8212967877854},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h",null,"Caliente","Adicional arranque en frío",{"$f":"3*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":-453629.47458091064}]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":2.4708461628975247},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Esta planta utiliza normalmente diesel para arranques, por lo que el porcentaje de uso de diesel se verá afectado por el tipo de arranques que se realicen. Se considera que el porcentaje mostrado identifica las conficiones promedio utilizada en los últimos años. \n\n2. El proceso de parada siempre se realizan con diesel desde el inicio de la secuencia de paro.\n\n3. Para el arranque tíbio y caliente debe considerarse la utilización de diesel como tipo de combustible en el arranque. Adicionalmente se escoge el tipo de arranque en la pestaña indicada."]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":118.40618046485895},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":21.700023909989731},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":2.256797391731773},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":7360},4.3899999999999997,null,20.700004058503406,null,null,"Crear la curva de costo con las condiciones "]
[null,6800,4.25,null,21.307340397564133,null,null,"actuales del calculo."]
[null,6400,4.18,null,21.626264623458457]
[null,6000,4.13,null,21.860686615857439,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,5500,4.09,null,22.052350953897093,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,7360,4.3899999999999997,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,3750,"horas"]
[null,6800,4.25,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,750,"horas"]
[null,6400,4.18,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,1500,"horas"]
[null,6000,4.13,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,30000,"horas"]
[null,5500,4.09,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,0,"colones"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,{"$f":"1.33333333333333*1130464.1","v":1507285.4666666668},"colones"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,{"$f":"1.33333333333333*792691.77","v":1056922.3599999999},"colones"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,{"$f":"1.33333333333333*332019260.68","v":442692347.57333332},"colones"]
[null,5041,{"$f":"C72*$D$19/$D$12","v":3.999116006097561}]
[null,4650,{"$f":"C73*$D$19/$D$12","v":3.8715815548780488}]
[null,4394,3.8078143292682922]
[null,4178,3.7622663109756096]
[null,3865,3.7258278963414639]

{"sheet":"SAN ANTONIO","index":8,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","San Antonio",null,"Unidad:","3 - 4",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Frío"]
[null,"Tipo",null,"Diesel",null,null,"Horas esperadas de operación, hop",null,{"$f":"68.31+53.74*I12","v":400.78371479000003},"hrs/periodo",null,null,"Descripción:","Arranque luego de varios días de no operación."]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":38400},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"12.373417/2","v":6.1867084999999999},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,42400,"kJ/kg",null,"Consumo por servicio propio:",null,1.27,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,564.53,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,418,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"Los arranques en caliente son poco comunes en este tipo de plantas por su función del respaldo. Por lo que solo se considera un tipo de arranque. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",565.4,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":2.569},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,418,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,null,null,null,"Potencia efectiva actual",null,18500,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",565.4,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":0},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,null,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,null,"colones/l",null,null,"Método calculo de repuestos","HISTORICO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2","No aplica"]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,220,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",11,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,180,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",11,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":197.91436356558972},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",4.2,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":197.91436356558972},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",4.2,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":2.569},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":14947.450369793694},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":795.82872713117945},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.22833325520833334},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":222.57366885644649},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":63270},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":40.790556007779074},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,null,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,20,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,null,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":1714669.1913273646},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":0},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":1265400},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"15.25+3.83*I12","v":38.945093555},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":156839.7131572894},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":10.932621316437752},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,3.42,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":564.53},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,0,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":3.463992707383774},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"N29*N39","v":449269.19132736471},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,0,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"N35+N41","v":1714669.1913273646},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":141323.35},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,null,null,null,null,null,{"$f":"Q44/I19","v":3142.4341451981395},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h"]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":7.7373645295249673},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Esta planta utiliza normalmente diesel para arranques, por lo que el porcentaje de uso de diesel se verá afectado por el tipo de arranques que se realicen. Se considera que el porcentaje mostrado identifica las conficiones promedio utilizada en los últimos años. \n\n2. El proceso de parada siempre se realizan con diesel desde el inicio de la secuencia de paro.\n\n3. Para el arranque tíbio y caliente debe considerarse la utilización de diesel como tipo de combustible en el arranque. Adicionalmente se escoge el tipo de arranque en la pestaña indicada."]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":236.970282880268},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":43.428989806701736},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":2.6384337989226623},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":18500},2.569,null,48.47144508473454,null,null,"Crear la curva de costo con las condiciones "]
[null,18000,2.52,null,49.361269888839772,null,null,"actuales del calculo."]
[null,16000,2.35,null,52.736113021248613]
[null,14000,2.1789999999999998,null,56.662056931346648,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,11000,1.89,null,64.912017655821671,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,18500,2.569,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,5000,"horas"]
[null,18000,2.52,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,10000,"horas"]
[null,16000,2.35,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,15000,"horas"]
[null,14000,2.1789999999999998,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,20000,"horas"]
[null,11000,1.89,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,20000,"dólares"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,50000,"dólares"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,1500000,"dólares"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,3000000,"dólares"]

{"sheet":"BARRANCA","index":9,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Barranca",null,"Unidad:","1 - 2",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Frío"]
[null,"Tipo",null,"Diesel",null,null,"Horas esperadas de operación, hop",null,{"$f":"7.86+57.56*I12","v":169.31781460000002},"hrs/periodo",null,null,"Descripción:","Arranque luego de varios días de no operación."]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":38762.264150943396},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"5.61007/2","v":2.8050350000000002},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,42800,"kJ/kg",null,"Consumo por servicio propio:",null,0.83,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,631.83000000000004,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,315,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"Los arranques en caliente son poco comunes en este tipo de plantas por su función del respaldo. Por lo que solo se considera un tipo de arranque. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",519,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":2.5299999999999998},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,333,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,null,null,null,"Potencia efectiva actual",null,18500,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",661,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":0},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,null,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,null,"colones/l",null,null,"Método calculo de repuestos","HISTORICO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2","No aplica"]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,181,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",11,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,79,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",11,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":109.86166007905138},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",4.2,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":71.735177865612627},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",4.2,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":2.5299999999999998},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":15321.0530240883},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":441.596837944664},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.22276536701713395},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":251.82532808874927},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":97310},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":46.151439217217863},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,null,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,20,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,null,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":2225214.1301185773},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":0},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":1946200},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"8.1+3.59*I12","v":18.170075650000001},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":153095.30147718452},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":14.534829669153474},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,5.26,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":631.83000000000004},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,0,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":5.3040233941716242},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"N29*N39","v":279014.1301185771},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,0,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"N35+N41","v":2225214.1301185773},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":141323.35},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,null,null,null,null,null,{"$f":"Q44/I19","v":4078.0979201293453},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h"]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":7.7030351920943838},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr"]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":271.66418115207438},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":49.787259443246477},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":3.6358202260286134},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":18500},2.5299999999999998,null,49.958578892884248,null,null,"Crear la curva de costo con las condiciones "]
[null,18000,2.4900000000000002,null,50.702535242035296,null,null,"actuales del calculo."]
[null,16000,2.3220000000000001,null,54.107048664119304]
[null,14000,2.1469999999999998,null,58.219976791054748,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,11000,1.863,null,66.539161600352585,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,18500,2.5299999999999998,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,5000,"horas"]
[null,18000,2.4900000000000002,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,10000,"horas"]
[null,16000,2.3220000000000001,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,15000,"horas"]
[null,14000,2.1469999999999998,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,20000,"horas"]
[null,11000,1.863,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,20000,"dólares"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,50000,"dólares"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,1500000,"dólares"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,3000000,"dólares"]

{"sheet":"MOIN I","index":10,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Moín I",null,"Unidad:","1 - 2- 4",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Caliente"]
[null,"Tipo",null,"HFO Clase C",null,null,"Horas esperadas de operación, hop",null,{"$f":"7.5+165.21*I12","v":1884.8126199000003},"hrs/periodo",null,null,"Descripción:","Arranque después de no más de 3 horas de la última parada. Utiliza solo búnker"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":36769.811320754714},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"34.08957/3","v":11.363190000000001},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,40600,"kJ/kg",null,"Consumo por servicio propio:",null,6.38,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,357.1807,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,260,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"2. Arranque tibio, no más de 12 horas después de la última parada. El arranque se realiza en diesel y se requiere unos 15 minutos adicionales de diesel. \n3. Arranque en frío, puede llegar a requerir hasta 3 horas de operación en diesel luego del arranque. El arranque se realiza en diesel. \n4. Se utilizan 5 horas de penalización por mantenimento."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",967,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":3.8591379310344824},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,252,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,"Diesel",null,null,"Potencia efectiva actual",null,6500,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",1058,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":34233.962264150941},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,43200,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,630.30999999999995,"colones/l",null,null,"Método calculo de repuestos","HISTORICO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2",2.87E-2]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,7,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",5,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,15,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",10,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":9.4259035875440986},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",30,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":0},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",20,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":4.1449999999999996},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,1170,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":8870.8833101941418},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,1,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":31.425903587544099},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.38474184369868636},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":1.0998082079434426E-4},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":92.043857711885622},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":121875},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":16.868662643065267},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,29.25,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,5,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,0.28999999999999998,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":629183.06129026494},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":7.9736095075899594E-7},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":609375},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"18.08+7.68*I12","v":105.3492992},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":100980.43896622334},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":6.2307419905425308},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",2]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,18.75,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":630.30999999999995},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,1403.28,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":20.027771843623157},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"(N24+N26)*N39+(N25+N27)*D21","v":19808.061290264919},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,3.82E-3,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":5.72583806878872},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"IF(L47=\"Caliente\",N35+N41,IF(L47=\"Tibio\",N35+N41+N46,N35+N41+N47))","v":629183.06129026494},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":106844.10209166202},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,"TIPO ARRANQUE","Adicional arranque en tíbio",{"$f":"(15/60)*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":125381.36565697179},null,null,{"$f":"Q44/I19","v":1153.0890887753412},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h",null,"Caliente","Adicional arranque en frío",{"$f":"3*($B$80/$C$80*$D$21-$B$63/$C$63*$D$14)","v":1504576.3878836613}]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":17.557737842285839},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Para el próximo verano se verificarán los datos de consumo de combusible al arranque. Para una aproximación se utilizan los datos de Guápiles. "]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":124.02832039302177},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":22.730380352427705},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":5.8617177093624377},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":6500},4.1449999999999996,null,22.801264434447326,null,null,"Crear la curva de costo con las condiciones "]
[null,6000,4.05,null,23.198185742012544,null,null,"actuales del calculo."]
[null,5500,3.9729999999999999,null,23.533828671600563]
[null,5000,3.8929999999999998,null,23.896612052982789,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,4500,3.8159999999999998,null,24.260157174889997,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,6500,4.1449999999999996,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,3000,"horas"]
[null,6000,4.05,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,6000,"horas"]
[null,5500,3.9729999999999999,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,9000,"horas"]
[null,5000,3.8929999999999998,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,12000,"horas"]
[null,4500,3.8159999999999998,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,181656.11807183368,"colones"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,289536.34977315686,"colones"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,276002.88096408313,"colones"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,676027.24693761813,"colones"]
[null,6500,{"$f":"C72*$D$19/$D$12","v":3.8591379310344824}]
[null,6000,{"$f":"C73*$D$19/$D$12","v":3.7706896551724136}]
[null,5500,3.6989999999999998]
[null,5000,3.6245172413793103]
[null,4500,3.5528275862068965]

{"sheet":"MOIN II","index":11,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Moín II",null,"Unidad:","5, 6, 7, 8",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Frío"]
[null,"Tipo",null,"Diesel",null,null,"Horas esperadas de operación, hop",null,{"$f":"12.91+32.81*I12","v":721.34936018000008},"hrs/periodo",null,null,"Descripción:","Arranque luego de varios días de no operación."]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":39124.528301886785},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"86.368712/4","v":21.592178000000001},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,43200,"kJ/kg",null,"Consumo por servicio propio:",null,1.1299999999999999,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,630.30999999999995,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,315,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"Los arranques en caliente son poco comunes en este tipo de plantas por su función del respaldo. Por lo que solo se considera un tipo de arranque. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",519,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":2.84},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,333,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,null,null,null,"Potencia efectiva actual",null,30000,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",661,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":0},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,null,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,null,"colones/l",null,null,"Método calculo de repuestos","ALTERNATIVO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2","No aplica"]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,181,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",11,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,79,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",11,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":132.25352112676055},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",4.2,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":100.25352112676055},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",4.2,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":2.84},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":13776.242359819291},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":492.50704225352109},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.24774535108024695},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":224.47672787000144},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":205602.46241613751},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":41.139325184642431},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,62.5,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,20,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,0.1,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":4422481.3621255672},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":2.927649162430735E-7},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":4112049.2483227504},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"23.32+0.78*I12","v":40.161898840000006},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":531553.21349840832},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":8.3199221636138407},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,2.67,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":630.30999999999995},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":2.7005158288661879},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"N29*N39","v":310432.11380281684},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,null,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"N35+N41","v":4422481.3621255672},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":205602.46241613751},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,null,null,null,null,null,{"$f":"Q44/I19","v":8104.9782133704157},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h"]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":6.9317441224549921},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Para el próximo verano se verificarán los datos de consumo de combusible al arranque. Para una aproximación se utilizan los datos de Barranca. "]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":239.72839444883519},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":43.934462466569272},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":2.7951372819268414},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":30000},2.84,null,43.885661207169683,null,null,"Crear la curva de costo con las condiciones "]
[null,27000,2.67,null,46.50191985701445,null,null,"actuales del calculo."]
[null,24000,2.4900000000000002,null,49.66145546249674]
[null,21000,2.2999999999999998,null,53.533031338489877,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,18000,2.1,null,58.365223785218156,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,30000,2.84,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,6000,"horas"]
[null,27000,2.67,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,12000,"horas"]
[null,24000,2.4900000000000002,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,24000,"horas"]
[null,21000,2.2999999999999998,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,20000,"horas"]
[null,18000,2.1,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,191724.5,"dólares"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,2753784.42,"dólares"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,2768801.0019999999,"dólares"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,0,"dólares"]

{"sheet":"MOIN III","index":12,"n_rows":79,"n_cols":19,"rows_kept":79,"cut":false,"hidden":false,"merged":[[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,1,77,2],[77,4,77,7],[78,4,78,7],[69,1,69,2],[69,4,69,9],[70,4,70,7],[71,4,71,7],[72,4,72,7],[73,4,73,7],[48,1,48,2],[48,11,54,18],[52,1,52,6],[58,1,58,9],[60,1,60,2],[60,4,61,4],[43,17,43,18],[45,6,45,7],[45,17,45,18],[46,1,46,4],[46,6,46,7],[47,1,47,2],[47,6,47,7],[56,1,56,6],[40,1,40,2],[40,6,40,7],[40,11,40,12],[41,1,41,2],[42,1,42,2],[43,1,43,2],[36,1,36,2],[36,11,36,14],[37,1,37,2],[38,6,38,7],[39,1,39,4],[39,6,39,7],[33,1,33,4],[33,6,33,7],[34,1,34,2],[34,6,34,7],[34,11,34,12],[35,1,35,2],[30,1,30,2],[30,11,30,14],[31,1,31,2],[31,11,31,12],[32,6,32,7],[32,11,32,12],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[28,11,28,12],[29,1,29,2],[29,6,29,7],[24,1,24,9],[24,11,24,12],[25,11,25,12],[26,1,26,4],[26,6,26,9],[26,11,26,12],[19,1,19,2],[19,6,19,7],[20,1,20,2],[22,11,22,14],[22,16,22,18],[23,11,23,12],[13,1,13,2],[13,11,13,12],[13,16,19,18],[16,1,16,4],[16,6,16,9],[16,11,16,12],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[12,11,12,14],[12,16,12,18],[7,5,7,6],[7,12,7,14],[9,1,9,4],[9,6,9,9],[10,1,10,2],[10,6,10,7],[10,13,10,17],[0,1,5,1],[0,2,1,7],[0,8,0,9],[0,11,5,11],[0,12,1,16],[0,17,0,18],[1,8,1,9],[1,17,1,18],[2,2,3,7],[2,8,2,9],[2,12,3,16],[2,17,2,18],[3,8,3,9],[3,17,3,18],[4,2,5,7],[4,8,4,9],[4,12,5,16],[4,17,4,18],[5,8,5,9],[5,17,5,18]]}
[null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,null,"Código:   ",null,null,"   ","INSTITUTO COSTARRICENSE DE ELECTRICIDAD",null,null,null,null,"Código:   "]
[null,null,null,null,null,null,null,null,"PE-05-FO-90-002",null,null,null,null,null,null,null,null,"PE-05-FO-90-002"]
[null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,null,"Versión:",null,null,null,"UEN PRODUCCIÓN DE ELECTRICIDAD ",null,null,null,null,"Versión:"]
[null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,1]
[null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,null,"Rige a partir de: ",null,null,null,"REPORTE DEL COSTO VARIABLE  OPERATIVO",null,null,null,null,"Rige a partir de: "]
[null,null,null,null,null,null,null,null,"2012-06-12",null,null,null,null,null,null,null,null,"2012-06-12"]
[]
[null,"Fecha:","2014-11-04",null,"Planta:","Moín III",null,"Unidad:","9 - 10",null,null,null,"COSTOS DE ARRANQUE Y PARO"]
[]
[null,"COMBUSTIBLE 1 PRINCIPAL",null,null,null,null,"OPERACIÓN",null,null,null,null,null,"Tipo de Arranque:","Frío"]
[null,"Tipo",null,"Diesel",null,null,"Horas esperadas de operación, hop",null,{"$f":"40.34+28.84*I12","v":1119.9908801399999},"hrs/periodo",null,null,"Descripción:","Arranque luego de varios días de no operación."]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D13/1.06*0.96","v":39124.528301886785},"BTU/l",null,"Generación bruta (PP)",null,{"$f":"74.871767/2","v":37.435883500000003},"GWh/periodo"]
[null,"Pder calórico bajo (LHV)",null,43200,"kJ/kg",null,"Consumo por servicio propio:",null,0.81,"%",null,"PÉRDIDA DE EFICIENCIA EN LA TOMA DE CARGA Y DESCARGA",null,null,null,null,"CONDICIONES DE OTROS ARRANQUES"]
[null,"Precio  combustible",null,630.30999999999995,"colones/l",null,null,null,null,null,null,"Consumo de combustible durante la carga (X)",null,315,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"},null,"Los arranques en caliente son poco comunes en este tipo de plantas por su función del respaldo. Por lo que solo se considera un tipo de arranque. "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Energía generada durante la toma de carga (Ex)",519,"kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rendimiento de la unidad a potencia nominal (Rnom)",{"$f":"IF(N38=1,C72,C80)","v":3.0070000000000001},{"$f":"+CONCATENATE(\"kWh/\",IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"))","v":"kWh/litros"}]
[null,"COMBUSTIBLE 2 SECUNDARIO",null,null,null,null,"CONDICIONES",null,null,null,null,"Consumo de combustible durante la descarga (Y)",null,333,{"$f":"+IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\")","v":"litros"}]
[null,"Tipo",null,null,null,null,"Potencia efectiva actual",null,35000,"kW",null,null,"Energía generada durante la toma de descarga (Ey)",661,"kWh"]
[null,"Poder calorico bajo (LHV)",null,{"$f":"D20/1.06*0.84","v":0},"BTU/l",null,"Tipo de cambio",null,545.65,"colones/$"]
[null,"Pder calórico bajo (LHV)",null,null,"kJ/kg",null,"Tipo de combustible",null,1]
[null,"Precio  combustible",null,null,"colones/l",null,null,"Método calculo de repuestos","ALTERNATIVO"]
[null,null,null,null,null,null,null,"Porcentaje de uso del combustible 2","No aplica"]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO DE COMBUSTIBLE EN LAS RAMPAS",null,null,null,null,"TIEMPO DE ARRANQUE Y PARO"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible arranque (Ga)",null,181,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de arranque (ta)",11,"minutos"]
[null,"CALCULO DE COSTOS VARIABLES OPERATIVOS",null,null,null,null,null,null,null,null,null,"Consumo de combustible parada (Gp)",null,79,{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de parada (tp)",11,"minutos"]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo de combustible asumiendo carga (Gc)",null,{"$f":"+IF(OR(N14=\"\",N15=\"\",N16=\"\"),0,IF((N14-(N15/$N$16))<0,0,N14-(N15/$N$16)))","v":142.4027269704024},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de carga (tc)",4.2,"minutos"]
[null,"COMBUSTIBLE",null,null,null,null,"TRATAMIENTO QUÍMICO",null,null,null,null,"Consumo de combustible asumiendo descarga (Gd)",null,{"$f":"+IF(OR(N17=\"\",N18=\"\",N16=\"\"),0,IF((N17-(N18/$N$16))<0,0,N17-(N18/$N$16)))","v":113.17958097771867},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"},null,"Tiempo de rampa de descarga (td)",4.2,"minutos"]
[null,"Rendimiento promedio",null,{"$f":"VLOOKUP(I18,$B$63:$C$67,2,FALSE)","v":3.0070000000000001},"kWh/l",null,"Precio de productos quimicos a granel (PPQ)",null,null,"colones/l"]
[null,"Heat Rate",null,{"$f":"IF(I20=1,D12,D19)/D28","v":13011.150083766805},"BTU/kWh",null,"Consumo de productos, durante ciclo operativo (CPQ)",null,null,"l/h",null,"Consumo total de combustible (Gi)",null,{"$f":"N27+N26+N25+N24","v":515.58230794812107},{"$f":"+CONCATENATE(IF($B$11=\"Turbo vapor\",\"toneladas\",\"litros\"),\"/arranque\")","v":"litros/arranque"}]
[null,"Eficiencia electrica del turbogrupo ",null,{"$f":"3413/D29","v":0.26231347559799389},null,null,"Costo  Variable de productos quimicos (CVPQ)",null,{"$f":"(I28*I29)/(I12*1000000*(1-I13/100))","v":0},"colones/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTO POR MANTENIMIENTO"]
[null,"Costo Variable por Combustible (CVC)",null,{"$f":"IF(I20=1,D14,D21)/(D28*(1-I13/100))","v":211.32597384340255},"colones/kWh",null,"AGUA DE PROCESO",null,null,null,null,"Costos de mantenimiento por hora de operación (M)",null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)*B63*(1-I13/100)","v":205602.462825375},"colones/hop"]
[null,null,null,{"$f":"D32/I19*100","v":38.729217235114554},"cent-$/kWh",null,"Precio del agua potable o cruda, mes de declaracion (PA)",null,62.5,"colones/m3",null,"Horas equivalente de operación por arranque (hpa)",null,20,"hop"]
[null,"ARRANQUE",null,null,null,null,"Consumo agua, durante ciclo operativo  (CAA)",null,0.2,"m3/h"]
[null,"Costo por arranque (CPA)",null,{"$f":"Q44","v":4437025.9410302807},"colones/arr",null,"Costo Variable por agua potable o cruda (CVAP)",null,{"$f":"I33*I34/(I12*1000000*(1-I13/100))","v":3.366309445390893E-7},"colones/kWh",null,"Costo por mantenimiento",null,{"$f":"+N32*N33","v":4112049.2565075001},"colones/arranque"]
[null,"Número de arranques estimado (#A)",null,{"$f":"23.67+0.78*I12","v":52.869989130000008},"arranques"]
[null,"Ciclo de arranque (CA)",null,{"$f":"I12*1000000*(1-I13/100)/D36","v":702338.95362349949},"kWh/arranque",null,null,null,null,null,null,"COSTO POR COMBUSTIBLE"]
[null,"Costo Variable por Arranque (CVA)",null,{"$f":"D35/D37","v":6.3174994326298215},"colones/kWh",null,"MANTENIMIENTO HISTÓRICO",null,null,null,null,null,"Tipo de combustible:",1]
[null,null,null,null,null,null,"Costo unitario repuestos (CUMRep)",null,1.62,"colones/kWh",null,null,"Precio Combustible:",{"$f":"IF(N38=1,D14,D21)","v":630.30999999999995},{"$f":"+CONCATENATE(\"colones/\",IF($B$11=\"Turbo vapor\",\"ton\",\"litros\"))","v":"colones/litros"}]
[null,"LUBRICANTES"]
[null,"Precio del lubricante  (PL) ",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I39/(1-I13/100)","v":1.6332291561649361},"colones/kWh",null,"Costo por Combustible","Costo por combustible",{"$f":"N29*N39","v":324976.68452278018},"colones/arranque"]
[null,"Consumo lubricante (CL)",null,null,"l/kWh"]
[]
[null,"Costo Variable por lubricantes (CVL)",null,{"$f":"D41*D42/(1-I13/100)","v":0},"colones/kWh",null,"MANTENIMIENTO ALTERNATIVO",null,null,null,null,"COSTO ARRANQUE Y PARO (CPA)",null,null,null,null,{"$f":"N35+N41","v":4437025.9410302807},"colones/arranque"]
[null,null,null,null,null,null,"Valor de los repuestos durante el ciclo operativo (RPTM)",null,{"$f":"(I76/I72+I77/I73+I78/I74+I79/I75)*I19","v":205602.462825375},"colones/h"]
[null,null,null,null,null,null,"Valor de otros insumos durante el ciclo operativo (OIM)",null,null,"colones/h",null,null,null,null,null,null,{"$f":"Q44/I19","v":8131.6337231380567},"$/arranque"]
[null,"CONTROL Y MITIGACIÓN EMISIONES",null,null,null,null,"Valor de la mano de obra adicional (MOAM)",null,null,"colones/h"]
[null,"Precio  quimicos (PQCME)",null,null,"colones/l",null,"Costo Variable de mantenimiento (CVM)",null,{"$f":"I45/(B63*(1-I13/100))+(I46+I47)/(B63*(1-I13/100))","v":5.9223269288486744},"colones/kWh",null,"Comentarios:"]
[null,"Consumo de quimicos (CQCME)",null,null,"l/hr",null,null,null,null,null,null,"1. Para el próximo verano se verificarán los datos de consumo de combusible al arranque. Para una aproximación se utilizan los datos de Barranca. "]
[null,"Costo de mitigacion de emisiones (CVCME)",null,{"$f":"(D48/(I12*1000000*(1-I13/100)))*D49","v":0},"colones/kWh"]
[]
[]
[null,"COSTOS  VARIABLES TOTALES DE PRODUCCION (CVP)",null,null,null,null,null,{"$f":"IF(I21=\"HISTORICO\",I41,I48)+D44+I35+D38+D32+I30+D50","v":223.56580054151198},"colones/kWh"]
[]
[null,null,null,null,null,null,null,{"$f":"H53/I19*100","v":40.972381662514792},"cent $/kWh"]
[]
[null,"Costo Variable de O&M (sin combustible) ",null,null,null,null,null,{"$f":"(H55-D33)","v":2.243164427400238},"cent $/kWh"]
[]
[null,"DATOS PARA EL CALCULO"]
[]
[null,"Rendimiento seleccionado",null,null,"CVC (cent $/kWh)"]
[null,"Potencia (kW)","Rend (kWh/l)"]
[null,{"$f":"IF($I$20=1,B72,B80)","v":35000},3.0070000000000001,null,40.926458262310192,null,null,"Crear la curva de costo con las condiciones "]
[null,32000,2.8530000000000002,null,43.014520898685014,null,null,"actuales del calculo."]
[null,29000,2.6920000000000002,null,45.452932691105644]
[null,26000,2.524,null,48.329025370955193,null,null,"*Los datos de la curva solo se actualizan al presionar "]
[null,23000,2.3479999999999999,null,51.783509691378015,null,null,"el botón. Luego de cargar la curva es posible que "]
[null,null,null,null,null,null,null,"la potencia seleccionada haya cambiado. "]
[]
[null,"Rendimiento combustible 1",null,null,"Tabla de Mantenimientos"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Descripción",null,null,null,"Valor","Unidades"]
[null,35000,3.0070000000000001,null," Intervalo entre inspecciones de mantenimiento tipo 1, IMT1",null,null,null,6000,"horas"]
[null,32000,2.8530000000000002,null,"Intervalo entre inspecciones de mantenimiento tipo 2, IMT2",null,null,null,12000,"horas"]
[null,29000,2.6920000000000002,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT3",null,null,null,24000,"horas"]
[null,26000,2.524,null,"Intervalo entre inspecciones de mantenimiento tipo 3, IMT4",null,null,null,20000,"horas"]
[null,23000,2.3479999999999999,null," Costo total de una inspecciónde mantenimiento tipo 1, MT1",null,null,null,191724.5,"dólares"]
[null,null,null,null," Costo total de una inspección de mantenimiento tipo 2, MT2",null,null,null,2753784.42,"dólares"]
[null,"Rendimiento Combustible 2",null,null,"Costo total de una inspección de mantenimiento tipo 3, MT3",null,null,null,2768801.02,"dólares"]
[null,"Potencia (kW)","Rend (kWh/l)",null,"Costo total de una inspección de mantenimiento tipo 3, MT4",null,null,null,0,"dólares"]