{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["ÍNDICE","1. Consideraciones","2. RESULTADOS","3. Obligaciones CEL","4. C Datos SEN","4. C Demanda CFE SSB"],"not_rendered":{"charts":50,"images":1,"macros":1,"external_links":56,"defined_names":514,"comments":1,"pivot_tables":0},"unopened":[],"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":"ÍNDICE","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Modelo de análisis prospectivo de la oferta y demanda de CEL"]
[null,"2018-2027"]
[]
[null,"ÍNDICE"]
[]
[null,1,"Consideraciones generales"]
[null,2,"Resultados"]
[null,3,"Obligaciones CEL"]
[null,4,"Consumo"]
[null,null,"4.1 Consumo Datos SEN"]
[null,null,"4.2 Consumo CFE Suministro Básico"]

{"sheet":"1. Consideraciones","index":1,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,3,43,5],[44,3,44,5],[49,2,50,17],[6,2,6,17],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,3,42,5]]}
[]
[null,"CONSIDERACIONES GENERALES"]
[]
[null,"Hoja: \"2. RESULTADOS\" - Hoja de resultados del análisis"]
[]
[null,"A) Escenario:"]
[null,null,"1. Escenario A: utiliza la información obtenida mediante fuentes oficiales, como los documentos de planeación del sistema elaborados por SENER (PRODESEN 2018-2032, PRODESEN 2019-2033  y PIIRCE 2019-2033) complementada con información de los permisos de generación otorgados por la CRE."]
[]
[null,"B) Hipótesis:"]
[null,null,"1) Proyecciones de consumo: para elegir el escenario (Alto, Planeación o Bajo) sobre el que calcular los requermientos de CEL y realizar el análisis."]
[null,null,"2) Efecto COVID: posibilidad de contemplar una reducción en el consumo en el año 2020 por efecto de la emergencia sanitaria declarada como consecuencia del COVID-19"]
[null,null,"3) Aplicación Modificatorio Lineamientos CEL: permite considerar el otorgamiento de CEL a las Centrales Eléctricas Legadas (centrales de CFE previas a la entrada en vigor de la LIE)."]
[null,null,"4) Aplicación de lo establecido en la LTE en lo referente a la posibilidad de diferimiento del 50% de la obligación durante los primeros años de vigencia del sistema de CEL."]
[null,null,"5) Posibilidad de utilización de CEL de los 4 primeros meses del año siguiente para el cumplimiento de obligaciones de un año determinado ya que la liquidación de CEL se hace el 15 de mayo del año siguiente."]
[]
[null,"C) Análisis realizados:"]
[null,null,"1. Análisis del cumplimiento de CEL de todo el Sistema Eléctrico Nacional a nivel macro."]
[null,null,"2. Análisis del cumplimiento de CEL de CFE Suministrador de Servicios Básicos (CFE SSB)."]
[null,null,"2. Análisis del cumplimiento de las metas de energías limpias para 2024."]
[]
[null,"D) Bases de datos consideradas:",null,null,null,"Centrales en operación a 31 de diciembre de 2017 (Fuente: Tablas 2.2.14 a 2.2.20 del PRODESEN 2018-2032)",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[null,null,null,null,null,"Listado de centrales conectadas en 2018 (Fuente: CENACE)",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[null,null,null,null,null,"Listado de centrales proyectadas para el periodo 2019-2024 (Fuente: Tabla 7.3 Capítulo VII PRODESEN 2019-2033)",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[null,null,null,null,null,"Permisos de la CRE"]
[null,null,null,null,null,"Listado proyectos adjudicatarios de la SLP-2015",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[null,null,null,null,null,"Listado proyectos adjudicatarios de la SLP-2016",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[null,null,null,null,null,"Listado proyectos adjudicatarios de la SLP-2017",null,null,null,null,null,null,null,null,"Enlace a documento oficial"]
[]
[null,"Hoja: \"3. Obligaciones CEL\""]
[]
[null,"A) Obligaciones 2018 a 2022: datos publicados por la Secretaría de Energía (\"SENER\")"]
[]
[null,"B) Obligaciones 2023 y 2024 (datos estimados):"]
[null,null,"1. Objetivos/metas de Generación Limpia:"]
[null,null,null,"2023: 33.35% (término medio entre la meta del 35% de 2024 y el 31.7% de 2022)."]
[null,null,null,"2024: 35% de acuerdo a la Ley General de Cambio Climático."]
[]
[null,null,"2. Generación estimada: se ha considerado que el dato más preciso de los datos publicados es el correspondiente a Consumo Bruto, de acuerdo a lo siguiente:"]
[null,null,null,"GWh",null,null,2017,2018,2019,2020,2021,2022,2023,2024,"Comentarios"]
[null,null,null,"Generación (Obligaciones CEL SENER)",null,null,"-","-",321577.81647940073,319698.62190812727,334542.8633333334,349598.86119873816,"-","-","Estimaciones hechas 3 años antes"]
[null,null,null,"Generación Bruta PRODESEN 2019",null,null,309370.40000000002,317278]
[null,null,null,"Generación Bruta PRODESEN 2018",null,null,329164]
[null,null,null,"Generación MEM (macro)",null,null,302751.38,310554.38,317643.84999999998]
[null,null,null,"Consumo bruto (PRODESEN 2019)",null,null,309726.5,318236.39999999997,329042,339611,350231,360754,371516,382530.5,"Datos >=2019 proyecciones PAMNRT 2019"]
[null,null,null,"Consumo bruto (CENACE)",null,null,309021.5]
[]
[null,null,"3. Generación limpia sin CELs:"]
[null,null,null,"Se tiene en cuenta la proyección de generación limpia de CE limpias que no generan CELs (sin tener en cuenta el Modificatorio de Lineamientos, es decir, sin contemplar que las CE Legadas generen CELs)."]
[]
[null,null,"4. Consumo estimado: Se considera que la energía a la cual es aplicable la obligación de CELs es el Consumo final más las pérdidas técnicas. Se han utilizado los Pronósticos de consumo bruto del SEN del PAMRNT 2019-2033 restando las pérdidas no técnicas del sistema, estimadas en un 7.5%, de acuerdo con las cifras de 2018 del PRODESEN 2019-2033."]
[]
[]
[null,null,"5. Consumo estimado Contratos de Interconexión Legados (\"CIL\") exentos:"]
[null,null,null,"Se considera el 100% de la energía de los CIL de fuentes de energía renovable y de cogeneración eficiente."]

{"sheet":"2. RESULTADOS","index":2,"n_rows":245,"n_cols":68,"rows_kept":245,"cut":false,"hidden":false,"merged":[]}
[]
[null,"HIPÓTESIS"]
[]
[]
[null,null,"1) Proyección Consumo","Planeación",2018,2019,2020,2021,2022,2023,2024]
[null,null,"(Consumo final más pérdidas técnicas)",null,294273.19907999999,304265.13740000001,314038.2917,323858.60569999996,333589.22379999998,343540.84519999998,353725.95335000003]
[null,null,"Se tiene en cuenta para obligaciones 2023-2024 y para resultados 2020-2021 (sin considerar efecto COVID-19)"]
[]
[null,null,"2) Efecto COVID",null,"Sí","        SÍ se considera un descenso en el consumo"]
[null,null,"Número de meses de afectación",null,4]
[null,null,"Impacto promedio en consumo",null,-0.1]
[]
[null,null,"3) Aplicación Modificatorio Lineamientos CEL",null,"No","        No se entregan CEL a Centrales Eléctricas Legadas (de CFE)"]
[null,null,"Año inicio de aplicación",null,2021]
[]
[null,null,"4) Aplicación LTE (Posibilidad de 50% de diferimiento)",null,2018,2019,2020,2021,2022,2023,2024]
[null,null,null,null,"No","No","No","No","n/a","n/a","n/a"]
[null,null,null,null,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[]
[null,null,"5) Utilizar CEL 4m año siguiente",null,"Sí"]
[]
[]
[]
[null,"RESULTADOS"]
[]
[null,"1. Nueva capacidad instalada por tecnología (MW)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRÁFICO 48. ADICIÓN DE CAPACIDAD DE GENERACIÓN DE ENERGÍA LIMPIA POR ESCENARIO Y POR TECNOLOGÍA, EN MW",null,null,null,null,null,null,null,null,null,null,null,"GRÁFICO 34. ESTIMACIÓN DE ADICIÓN DE CAPACIDAD DE ENERGÍA LIMPIA POR ESCENARIO (MW)",null,null,null,null,null,null,null,"GRÁFICO 47. ADICIÓN DE CAPACIDAD DE GENERACIÓN DE ENERGÍA LIMPIA POR ESCENARIO, EN MW"]
[null,null,"Tecnología","Esquema",2018,2019,2020,2021,2022,2023,2024," TOTAL\n2018-2024","Promedio '18-'21",null,null,"Promedio '21-'24"]
[null,"Escenario A","Eólica","SLP",880.5,308.55,929.69,0,0,0,0,2118.7399999999998,529.68499999999995,0.35381622343756519,null,0,-1]
[null,null,null,"CIL-AUT",790.51,572,464,649,520,0,0,2995.51,618.87750000000005,0.41339456435519562,null,173.33333333333334,-0.7199230326949464]
[null,null,null,"Otros",0,302,754,338,0,175,1275.5999999999999,2844.6,348.5,0.23278921220723917,null,483.5333333333333,0.38747010999521758]
[null,null,null,"TOTAL",1671.01,1182.55,2147.69,987,520,175,1275.5999999999999,7958.85,1497.0625,0.99999999999999989,0.35102998496285032,656.86666666666667,-0.56122963024812478]
[null,null,"FV","SLP",1570.8,1628.25,1136.3,330,0,0,0,4665.3500000000004,1166.3375000000001,0.45344292383721763,null,0,-1]
[null,null,null,"CIL-AUT",90,797,60,0,0,0,0,947,236.75,9.2042493890886021E-2,null,0,-1]
[null,null,null,"Otros",495.35000000000014,1949.0259999999998,2013,219,0,562,790,6028.3760000000002,1169.0940000000001,0.45451458227189651,null,450.66666666666669,-0.61451631206159074]
[null,null,null,"TOTAL",2156.15,4374.2759999999998,3209.3,549,0,562,790,11640.725999999999,2572.1814999999997,1.0000000000000002,0.60312300472874159,450.66666666666669,-0.82479204260404382]
[null,null,"Cogeneración","TOTAL",351,321.17200000000003,4.2779999999999996,0,320,0,870,1866.45,169.11250000000001,null,3.9653360051454117E-2,396.66666666666669,1.3455786335526154]
[null,null,"Bioenergía","TOTAL",0,5.6579999999999995,0,0,0,0,0,5.6579999999999995,1.4144999999999999,null,3.3167079779899083E-4,0,-1]
[null,null,"Nuclear","TOTAL",0,0,0,0,0,0,0,0,0,null,0,0,""]
[null,null,"Hidro","TOTAL",0,15,0,60,116,194.3,82,467.3,18.75,null,4.3964845943662628E-3,130.76666666666668,5.974222222222223]
[null,null,"Geotérmica","TOTAL",0,25,0,0,0,25,0,50,6.25,null,1.4654948647887542E-3,8.3333333333333339,0.33333333333333348]
[null,null,"TOTAL","TOTAL",4178.16,5923.6559999999999,5361.268,1596,956,956.3,3017.6,21988.983999999997,4264.7709999999997,null,1,1643.3,-0.61468036619082245]
[]
[]
[]
[null,"2. Cumplimiento obligaciones CEL SEN"]
[null,null,null,null,null,null,null,{"$f":"+H49/G49","v":1.0639057866843225}]
[null,null,"Concepto","Unidad",2018,2019,2020,2021,2022,2023,2024,"Fuente",null,"GRÁFICO 35, 36 y 39. CUMPLIMIENTO DE REQUISITOS DE CEL POR ESCENARIO"]
[null,"Información general","Consumo final obligado a CEL","GWh",269236.28978241998,274522.28290166624,271720.0125237896,289084.4936819963,297645.68946383632,306128.64403823635,316313.75218823639,"Sener"]
[null,null,"Req. CEL","% Req. CEL",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999,"Sener"]
[null,null,null,"miles CEL",13461.814489120999,15922.292408296644,20107.280926760428,31510.209811337598,41372.750835473249,45307.039317658979,55038.592880753131]
[null,null,null,"miles CEL (acum.)",13461.814489120999,29384.106897417645,49491.387824178077,81001.597635515674,122374.34847098892,167681.3877886479,222719.98066940103]
[null,"Escenario A (Base)","CEL disponibles (A)","Miles CEL generados",7553.5405061321489,19211.55974529931,32661.425594771099,39922.691407133745,41560.930869206357,43679.525807935119,49790.86195834192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,null,"Escenario A",2018,null,null,2019,null,null,null,2020,null,null,null,2021,null,null,null,2022,null,null,null,2023,null,null,null,2024]
[null,null,null,"% CEL generados año (A)",2.8055432320198925E-2,6.9981786331643189E-2,0.12020250290512381,0.13810042489186636,0.13963222831841471,0.14268356345798017,0.1574097288337678,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Escenario A",null,null,null,null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)",null,"CEL Disponibles","Obligación","Déficit (-) /\nSuperávit (+)"]
[null,null,null,"CEL utilizados año anterior",0,5072.931854878685,2660.7737523916931,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,null,null,null,"Requisito anual",null,{"$f":"+E51/$AK$53","v":13.461814489121},null,"Requisito anual",null,{"$f":"+F51/$AK$53","v":15.922292408296643},null,"Requisito anual",null,{"$f":"+G51/$AK$53","v":20.107280926760428},null,"Requisito anual",null,{"$f":"+H51/$AK$53","v":31.510209811337599},null,"Requisito anual",null,{"$f":"+I51/$AK$53","v":41.372750835473248},null,"Requisito anual",null,{"$f":"+J51/$AK$53","v":45.307039317658976},null,"Requisito anual",null,{"$f":"+K51/$AK$53","v":55.038592880753129}]
[null,null,null,"CEL disponibles año anterior",0,0,0,9893.3709156189761,18305.852511415127,18494.032545148235,16866.519035424375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL generados \nene-dic",{"$f":"E53/$AK$53","v":7.5535405061321486},null,null,null,"Obligac. Pdte. Año ant.",null,0,null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(E60<0,-E60+5%*E61,0)/$AK$53","v":0.87710923451567369},null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(F60<0,-F60+5%*F61,0)/$AK$53","v":0},null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(G60<0,-G60+5%*G61,0)/$AK$53","v":0},null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(H60<0,-H60+5%*H61,0)/$AK$53","v":0},null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(I60<0,-I60+5%*I61,0)/$AK$53","v":0},null,"Obligac. Pdte. Año ant.",null,{"$f":"+IF(J60<0,-J60+5%*J61,0)/$AK$53","v":0}]
[null,null,null,"CEL año siguiente utilizados",5072.931854878685,2660.7737523916931,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL generados \nene-dic","CEL generados \nene-abr sig año",{"$f":"+E57/$AK$53","v":5.0729318548786848},null,null,null,"CEL generados año",{"$f":"+E53/$AK$53","v":7.5535405061321486},null,null,"CEL generados año",{"$f":"+F53/$AK$53","v":19.211559745299311},null,null,"CEL generados año",{"$f":"+G53/$AK$53","v":32.661425594771096},null,null,"CEL generados año",{"$f":"+H53/$AK$53","v":39.922691407133748},null,null,"CEL generados año",{"$f":"+I53/$AK$53","v":41.560930869206359},null,null,"CEL generados año",{"$f":"+J53/$AK$53","v":43.679525807935121},null,null,"CEL generados año",{"$f":"+K53/$AK$53","v":49.790861958341921}]
[null,null,null,"Miles CEL disponibles (A)",12626.472361010834,16799.401642812321,30000.651842379404,49816.062322752725,59866.783380621484,62173.558353083354,66657.380993766303,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL generados \nene-abr sig año","Diferimiento \nsig. año",{"$f":"+E61/$AK$53","v":0.8353421281101655},null,null,null,"CEL utilizados año ant.",0,null,null,"CEL utilizados año ant.",{"$f":"-F55/$AK$53","v":-5.0729318548786848},null,null,"CEL utilizados año ant. \nene-abr  utilizados año anterior",{"$f":"-G55/$AK$53","v":-2.6607737523916932},null,null,"CEL utilizados año ant. \nene-abr  utilizados año anterior",{"$f":"-H55/$AK$53","v":0},null,null,"CEL utilizados año ant. \nene-abr  utilizados año anterior",{"$f":"-I55/$AK$53","v":0},null,null,"CEL utilizados año ant. \nene-abr  utilizados año anterior",{"$f":"-J55/$AK$53","v":0},null,null,"CEL utilizados año ant. \nene-abr  utilizados año anterior",{"$f":"-K55/$AK$53","v":0}]
[null,null,"Balance cumplimiento Obligación CEL (A)","CEL necesarios para cumplir requisito (A)",13461.814489120999,16799.401642812318,20107.280926760428,31510.209811337598,41372.750835473249,45307.039317658979,55038.592880753131,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exceso CEL","Obligación anual",{"$f":"+E51/$AK$53","v":13.461814489121},null,null,null,"Superávit año ant.",0,null,null,"Superávit año ant.",{"$f":"+IF(E60>0,E60,0)/$AK$53","v":0},null,null,"Superávit año ant.",{"$f":"+IF(F60>0,F60,0)/$AK$53","v":0},null,null,"Superávit año ant.",{"$f":"+IF(G60>0,G60,0)/$AK$53","v":9.8933709156189753},null,null,"Superávit año ant.",{"$f":"+IF(H60>0,H60,0)/$AK$53","v":18.305852511415129},null,null,"Superávit año ant.",{"$f":"+IF(I60>0,I60,0)/$AK$53","v":18.494032545148237},null,null,"Superávit año ant.",{"$f":"+IF(J60>0,J60,0)/$AK$53","v":16.866519035424375}]
[null,null,null,"Balance (miles CEL)",-835.3421281101655,0,9893.3709156189761,18305.852511415127,18494.032545148235,16866.519035424375,11618.788113013172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Obligación anual",null,null,null,null,null,"CEL año sig.",{"$f":"+E57/$AK$53","v":5.0729318548786848},null,null,"CEL año sig.",{"$f":"+F57/$AK$53","v":2.6607737523916932},null,null,"CEL gen. año siguiente",{"$f":"+G57/$AK$53","v":0},null,null,"CEL gen. año siguiente",{"$f":"+H57/$AK$53","v":0},null,null,"CEL gen. año siguiente",{"$f":"+I57/$AK$53","v":0},null,null,"CEL gen. año siguiente",{"$f":"+J57/$AK$53","v":0},null,null,"CEL gen. año siguiente",{"$f":"+K57/$AK$53","v":0}]
[null,null,null,"Diferimiento CEL (25%/50%)",835.3421281101655,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total ",{"$f":"SUM(AK56:AK57)","v":12.626472361010833},null,null,null,"Balance Anual",null,null,{"$f":"+SUM(AP57:AP60)-AQ55-AQ56","v":-0.83534212811016673},"Balance Anual",null,null,{"$f":"+SUM(AT57:AT60)-AU55-AU56","v":3.3306690738754696E-15},"Balance Anual",null,null,{"$f":"+SUM(AX57:AX60)-AY55-AY56","v":9.8933709156189735},"Balance Anual",null,null,{"$f":"+SUM(BB57:BB60)-BC55-BC56","v":18.305852511415122},"Balance Anual",null,null,{"$f":"+SUM(BF57:BF60)-BG55-BG56","v":18.494032545148237},"Balance Anual",null,null,{"$f":"+SUM(BJ57:BJ60)-BK55-BK56","v":16.866519035424382},"Balance Anual",null,null,{"$f":"+SUM(BN57:BN60)-BO55-BO56","v":11.618788113013167}]
[null,null,null,"Incumplimiento (con multa)",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total CEL disponibles",{"$f":"+SUM(AP57:AP60)","v":12.626472361010833},null,null,"Total CEL disponibles",{"$f":"+SUM(AT57:AT60)","v":16.79940164281232},null,null,"Total CEL disponibles",{"$f":"+SUM(AX57:AX60)","v":30.000651842379401},null,null,"Total CEL disponibles",{"$f":"+SUM(BB57:BB60)","v":49.816062322752721},null,null,"Total CEL disponibles",{"$f":"+SUM(BF57:BF60)","v":59.866783380621484},null,null,"Total CEL disponibles",{"$f":"+SUM(BJ57:BJ60)","v":62.173558353083358},null,null,"Total CEL disponibles",{"$f":"+SUM(BN57:BN60)","v":66.657380993766296}]
[null,null,"Cumplimiento obligación (sin considerar balance)","% anual (sin considerar balance)",0.56110864640397851,1.2065825229593652,1.6243581473665383,1.2669763751547372,1.0045484051684512,0.96407813147283905,0.90465361398717137]
[null,null,null,"% anual (considerando balance)",0.93794728572546915,1.0000000000000002,1.4920292779344453,1.5809498769134998,1.4470099805230099,1.3722714900254018,1.2111025646710571]
[null,"S-CEL","Datos oficiales CRE","CEL emitidos CRE",6899.5209999999997,14373.46]
[null,null,null,"CEL cuenta CRE",1612.8448000000001,2668.5766500000004]
[null,null,null,"Total CELs",8512.3657999999996,17042.036649999998]
[]
[null,null,"Origen CEL (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"SLP","miles CEL",3139.7569694563672,11343.745083161395,18307.566606744385,20659.641634163119,21040.052635176817,21040.052635176817,21040.052635176817]
[null,null,"SLP-2015","miles CEL",1803.7565950494302,4068.9521838826258,4673.3114436545784,5276.9704549952476,5643.9963043103162,5643.9963043103162,5643.9963043103162]
[null,null,"SLP-2016","miles CEL",1336.000374406937,6975.9994695801397,9239.5038358174843,9429.1819265778704,9442.567078276501,9442.567078276501,9442.567078276501]
[null,null,"SLP-2017","miles CEL",0,298.79342969863012,4394.7513272723218,5953.4892525899995,5953.4892525899995,5953.4892525899995,5953.4892525899995]
[null,null,"CE Legada","miles CEL",0,0,0,0,0,0,0]
[null,null,"GEN-LIE","miles CEL",1216.7478546757804,4670.7789801379149,11156.823306026705,16066.014090970601,17323.842552029506,19221.506234758268,22725.590219296217]
[null,null,"CE Leg-Ampliación","miles CEL",2879.94,2879.94,2879.94,2879.94,2879.94,2879.94,2879.94]
[null,null,"PIE > LIE","miles CEL",317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,538.02693799999997,3145.2791038688524]
[null,null,"PIE < LIE","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-AUT-Limpia","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-COG-Limpia","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-PP","miles CEL",0,0,0,0,0,0,0]
[null,null,"Exportación","miles CEL",0,0,0,0,0,0,0]
[null,null,"U.P.C.","miles CEL",0,0,0,0,0,0,0]
[null,null,"TOTAL","miles CEL",7553.540506132148,19211.55974529931,32661.425594771088,39922.691407133723,41560.93086920632,43679.52580793509,49790.861958341884]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[null,null,null,"Control vs CRE",-958.82529386785154,2169.5230952993115]
[]
[null,null,"Origen CEL (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"Eólica","miles CEL",1525.3766522140691,4679.3091655916878,9419.9173619276098,11927.733125537441,12391.76969033744,12759.988450337438,15538.377366046294]
[null,null,"FV","miles CEL",2053.6392193402921,10073.387549513398,18389.276510369909,23031.658334689713,23573.970821003415,24525.390287403414,26243.367856707242]
[null,null,"Cogeneración","miles CEL",801.54613457778635,1107.0803011531286,1473.3438224735867,1481.8367044408001,1873.9901290983344,2153.8367044408005,3451.7055568998162]
[null,null,"Bioenergía","miles CEL",125.7025,130.79208904109589,132.8475,132.8475,132.8475,132.8475,132.8475]
[null,null,"Nuclear","miles CEL",1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999]
[null,null,"Hidro","miles CEL",762.23099999999999,762.23099999999999,762.23099999999999,864.80634246575323,1104.5433287671235,1516.804150684932,1790.7542786885244]
[null,null,"Geotérmica","miles CEL",636.97400000000005,810.68863999999996,835.73840000000007,835.73840000000007,835.73840000000007,942.58771506849314,985.73840000000007]
[null,null,"TOTAL","miles CEL",7553.540506132148,19211.55974529931,32661.425594771103,39922.691407133716,41560.930869206313,43679.525807935075,49790.861958341884]
[]
[]
[null,"3. Cumplimiento obligaciones CEL CFE SSB"]
[]
[null,null,"Concepto","Unidad",2018,2019,2020,2021,2022,2023,2024,null,"GRÁFICO 43. ESCENARIOS DE CUMPLIMIENTO DE CEL CFE SSB"]
[null,"Información general","Consumo final","GWh",235532.14855287332,237388.26668756615,231283.71161612673,241144.49981026602,243044.84624674747,244960.16842010658,246890.58434708524]
[null,null,"Requisito CEL","% Req. CEL",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[null,null,null,"miles CEL",11776.607427643667,13768.519467878838,17114.994659593376,26284.750479318995,33783.233628297901,36254.104926175773,42958.961676392828]
[null,null,null,"miles CEL (acum.)",11776.607427643667,25545.126895522502,42660.121555115882,68944.872034434869,102728.10566273276,138982.21058890852,181941.17226530134]
[null,"Escenario A (Base)","CEL disponibles (A)","Miles CEL adquiridos año",4369.162093369041,12304.218668591862,19700.539102822102,22911.898001631704,23277.623892645403,23498.555148645406,26105.807314514252]
[null,null,null,"% CEL (A)",1.8550172960309204E-2,5.183162099913647E-2,8.5179103038263593E-2,9.501314780000758E-2,9.5775015401944219E-2,9.5928065775760712E-2,0.10573836739684664]
[null,null,null,"CEL utilizados año anterior",0,3415.9958361525132,5932.8575926173025,6587.7140898679136,7759.207964215133,7771.9539982151337,8007.8634195921832]
[null,null,null,"CEL disponibles año anterior",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024]
[null,null,null,"CEL año siguiente utilizados",3415.9958361525132,5932.8575926173025,6587.7140898679136,7759.207964215133,7771.9539982151337,8007.8634195921832,8701.9357715047499,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% Requisito CEL",{"$f":"+E104","v":0.05},{"$f":"+F104","v":5.8000000000000003E-2},7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[null,null,null,"Miles CEL disponibles (A)",7785.1579295215543,14821.080425056651,20355.395600072712,24083.391875978923,23290.369926645402,23734.464570022457,26799.879666426816,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL Contratados SLP",{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}},{"$f":"+#REF!/1000","v":{"$error":"#REF!"}}]
[null,null,"Balance cumplimiento Obligación CEL","Obligación CEL (A)",11776.607427643667,17907.176558846495,20355.395600072712,26284.750479318995,36094.660161804975,49509.578413357907,69352.945249895245,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL Contratos Legados",{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}},{"$f":"+(#REF!+#REF!)/1000","v":{"$error":"#REF!"}}]
[null,null,null,"Balance (miles CEL)",-3991.4494981221123,-3086.0961337898443,0,-2201.3586033400716,-12804.290235159573,-25775.11384333545,-42553.065583468429,-0.99055153855947475,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Déficit de CEL",{"$f":"+MAX(E105/1000-AI112-AI113,0)","v":{"$error":"#REF!"}},{"$f":"+MAX(F105/1000-AJ112-AJ113,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,"Diferimiento CEL (25%/50%)",2944.1518569109166,3086.0961337898443,0,2201.3586033400716,9023.6650404512438,12377.394603339477,17338.236312473811]
[null,null,null,"Incumplimiento (con multa)",1047.2976412111957,0,0,0,3780.6251947083292,13397.719239995973,25214.829270994618]
[null,null,"Cumplimiento obligación (sin considerar balance)","% anual (sin considerar balance)",0.37100345920618405,0.89364863791614602,1.1510689599765351,0.87168025504594104,0.68902888778377125,0.64816260659297775,0.60769176664854396]
[null,null,null,"% anual (considerando balance)",0.66106966521166055,0.8276614895905936,1,0.91624959099109138,0.64525804709725598,0.47939136891577311,0.3864274194824811]
[]
[]
[null,null,"Origen CEL (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024,null,"GRÁFICO 42. ADQUISICIÓN DE CEL POR PARTE DE CFE SSB"]
[null,null,"Subastas de Largo Plazo","miles CEL",1172.1264113690409,9107.1829865918589,16503.5034208221,19714.862319631706,20080.588210645408,20080.588210645408,20080.588210645408]
[null,null,"SLP-2015","miles CEL",1048.3756260318189,3838.7469669342622,4425.3581393442619,5028.5701506849309,5380.9110000000001,5380.9110000000001,5380.9110000000001]
[null,null,"SLP-2016","miles CEL",123.7507853372219,5050.5978333562271,9074.472227540984,9264.1489583013699,9277.5339999999997,9277.5339999999997,9277.5339999999997]
[null,null,"SLP-2017","miles CEL",0,217.83818630136986,3003.673053936855,5422.1432106454067,5422.1432106454067,5422.1432106454067,5422.1432106454067]
[null,null,"CE Legada","miles CEL",0,0,0,0,0,0,0]
[null,null,"GEN-LIE","miles CEL",0,0,0,0,0,0,0]
[null,null,"CE Leg-Ampliación","miles CEL",2879.94,2879.94,2879.94,2879.94,2879.94,2879.94,2879.94]
[null,null,"PIE > LIE","miles CEL",317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,538.02693799999997,3145.2791038688524]
[null,null,"PIE < LIE","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-AUT-Limpia","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-COG-Limpia","miles CEL",0,0,0,0,0,0,0]
[null,null,"CIL-PP","miles CEL",0,0,0,0,0,0,0]
[null,null,"Exportación","miles CEL",0,0,0,0,0,0,0]
[null,null,"U.P.C.","miles CEL",0,0,0,0,0,0,0]
[null,null,"TOTAL","miles CEL",4369.162093369041,12304.218668591859,19700.539102822098,22911.898001631704,23277.623892645406,23498.555148645406,26105.807314514259]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[null,null,null,null,"","","","","","",""]
[null,null,"Origen CEL (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"Eólica","miles CEL",647.9518800755651,2950.5017851103394,6486.0767204373578,7790.1706954846977,7790.1706954846977,8011.1019514846976,10618.35411735355]
[null,null,"FV","miles CEL",841.27021329347565,6209.4564808232935,9821.1273823847459,11728.39230614701,12094.118197160709,12094.118197160709,12094.118197160709]
[null,null,"Cogeneración","miles CEL",594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998]
[null,null,"Bioenergía","miles CEL",0,0,0,0,0,0,0]
[null,null,"Nuclear","miles CEL",1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999]
[null,null,"Hidro","miles CEL",0,90.605762658227846,314.63099999999997,314.63099999999997,314.63099999999997,314.63099999999997,314.63099999999997]
[null,null,"Geotérmica","miles CEL",636.97400000000005,810.68863999999996,835.73800000000006,835.73800000000006,835.73800000000006,835.73800000000006,835.73800000000006]
[null,null,"TOTAL","miles CEL",4369.162093369041,12304.218668591862,19700.539102822106,22911.898001631711,23277.62389264541,23498.55514864541,26105.807314514263]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[]
[null,null,"Origen CEL (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"Eólica","miles CEL",647.9518800755651,2749.2965954117094,5423.6103262076513,6743.5489749367525,6971.9066954846976,7657.9037999230541,7790.1706954846977]
[null,null,"FV","miles CEL",841.27021329347565,5737.1270799449148,8990.7353339284382,10682.913683408857,11971.135351796223,12094.118197160709,12094.118197160709]
[null,null,"Cogeneración","miles CEL",594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998,594.89499999999998]
[null,null,"Bioenergía","miles CEL",0,0,0,0,0,0,0]
[null,null,"Nuclear","miles CEL",1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999,1648.0709999999999]
[null,null,"Hidro","miles CEL",0,90.605762658227846,314.63099999999997,314.63099999999997,314.63099999999997,314.63099999999997,314.63099999999997]
[null,null,"Geotérmica","miles CEL",636.97400000000005,810.68863999999996,835.73800000000006,835.73800000000006,835.73800000000006,835.73800000000006,835.73800000000006]
[null,null,"TOTAL","miles CEL",4369.162093369041,11630.684078014852,17807.680660136091,20819.797658345611,22336.377047280923,23145.356997083767,23277.62389264541]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[]
[]
[null,"4. Cumplimiento metas Generación Limpia"]
[]
[null,null,"Concepto","Unidad",2018,2019,2020,2021,2022,2023,2024,null,"GRÁFICO 46. CUMPLIMIENTO DE METAS DE GENERACIÓN DE ENERGÍA LIMPIA"]
[null,"Información general","Generación bruta","GWh",318236.39999999997,329042,328290.63333333336,350231,360754,371516,382530.5]
[null,null,"Meta Generación Limpia","% Meta",0.25,0.26700000000000002,0.28299999999999997,0.3,0.317,0.33350000000000002,0.35]
[null,null,null,"GWh",79559.099999999991,87854.214000000007,92906.249233333336,105069.3,114359.018,123900.58600000001,133885.67499999999]
[null,"Escenario A (Base)","Generación limpia (A)","GWh",74847.375720472613,89921.72235677678,106907.63556625546,115994.38982468001,118802.05160491265,122389.31336924138,128500.64951964818]
[null,null,null,"% Gen. (A)",0.23519426351125333,0.27328341779097132,0.32564936282451185,0.33119395434636001,0.32931596490936382,0.32943214658114695,0.33592262452183075]
[null,null,"Balance Energía Limpia","GWh",-4711.7242795273778,2067.5083567767724,14001.38633292212,10925.089824680006,4443.033604912649,-1511.2726307586272,-5385.0254803518037]
[null,null,"Cumplimiento obligación","%",0.94077705404501333,1.0235333999661846,1.150704462277427,1.1039798478212,1.0388516243197599,0.98780253847420363,0.95977892720523084]
[]
[null,null,"Origen Generación Limpia (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"SLP","GWh",3139.7569694563672,11343.745083161395,18307.566606744385,20659.641634163119,21040.052635176817,21040.052635176817,21040.052635176817]
[null,null,"SLP-2015","GWh",1803.7565950494302,4068.9521838826258,4673.3114436545784,5276.9704549952476,5643.9963043103162,5643.9963043103162,5643.9963043103162]
[null,null,"SLP-2016","GWh",1336.000374406937,6975.9994695801397,9239.5038358174843,9429.1819265778704,9442.567078276501,9442.567078276501,9442.567078276501]
[null,null,"SLP-2017","GWh",0,298.79342969863012,4394.7513272723218,5953.4892525899995,5953.4892525899995,5953.4892525899995,5953.4892525899995]
[null,null,"CE Legada","GWh",47468.096179839995,47468.096179839995,47468.096179839995,47468.096179839995,47468.096179839995,47468.096179839995,47468.096179839995]
[null,null,"GEN-LIE","GWh",1330.9605900362808,4784.991715498415,11271.036041387208,16180.2268263311,17438.055287390005,19335.718970118767,22839.802954656712]
[null,null,"CE Leg-Ampliación","GWh",2879.94,2879.94,2879.94,2879.94,2879.94,2879.94,2879.94]
[null,null,"PIE","GWh",1918.8893269799999,1918.8893269799999,1918.8893269799999,1918.8893269799999,1918.8893269799999,2139.8205829799999,4747.0727488488519]
[null,null,"PIE > LIE","GWh",317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,317.09568199999995,538.02693799999997,3145.2791038688524]
[null,null,"PIE < LIE","GWh",1601.79364498,1601.79364498,1601.79364498,1601.79364498,1601.79364498,1601.79364498,1601.79364498]
[null,null,"CIL","GWh",18109.732654159998,21526.060051296958,25062.10741130391,26887.595857365766,28057.018175525769,29525.685001125767,29525.685001125767]
[null,null,"CIL-AUT","GWh",12907.257378785498,15562.13639597765,18764.437707941772,20589.926154003628,21759.348472163631,23228.015297763628,23228.015297763628]
[null,null,"CIL-COG-Limpia","GWh",4234.175738038356,4849.4955931068489,4850.5359216000006,4850.5359216000006,4850.5359216000006,4850.5359216000006,4850.5359216000006]
[null,null,"CIL-PP","GWh",188.51133033614383,334.63985521245957,667.34557476213627,667.34557476213627,667.34557476213627,667.34557476213627,667.34557476213627]
[null,null,"U.P.C.","GWh",779.78820699999994,779.78820699999994,779.78820699999994,779.78820699999994,779.78820699999994,779.78820699999994,779.78820699999994]
[null,null,"TOTAL","GWh",74847.375720472643,89921.722356776765,106907.6355662555,115994.38982467998,118802.05160491259,122389.31336924134,128500.64951964814]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[]
[]
[null,null,"Origen Generación Limpia (Escenario A)","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,null,"Eólica","GWh",14183.920251296957,19065.681857436812,25772.132226011199,30092.969050502568,31726.427933462568,33563.313519062569,36341.702434771425]
[null,null,"FV","GWh",2488.6503871990481,11571.774468763299,21416.860414612929,26071.709624113075,26614.022110426777,27565.441576826772,29283.4191461306]
[null,null,"Cogeneración","GWh",4246.6416406161425,5167.4956622599793,5534.7995120735877,5543.2923940408009,5935.4458186983356,6215.2923940408009,7513.1612464998179]
[null,null,"Bioenergía","GWh",2792.8194413605002,2806.1336461249066,2813.7350135577863,2813.7350135577863,2813.7350135577863,2813.7350135577863,2813.7350135577863]
[null,null,"Nuclear","GWh",14512.071,14512.071,14512.071,14512.071,14512.071,14512.071,14512.071]
[null,null,"Hidro","GWh",30432.699000000001,30434.27708219178,30468.699000000001,30571.274342465753,30811.011328767116,31223.272150684934,31497.222278688532]
[null,null,"Geotérmica","GWh",6190.5739999999996,6364.2886399999998,6389.3384000000005,6389.3384000000005,6389.3384000000005,6496.1877150684941,6539.3384000000005]
[null,null,"TOTAL","GWh",74847.375720472657,89921.72235677678,106907.63556625551,115994.38982467999,118802.05160491259,122389.31336924135,128500.64951964817]
[null,null,null,"Control","OK","OK","OK","OK","OK","OK","OK"]
[]
[null,"Gráficas Modificatorio Lineamientos CEL (hay que copiar y pegar valores en cada escenario: no/sí aplicación Modificatorio)"]
[]
[null,"No aplicación Modificatorio"]
[]
[null,null,"Concepto","Unidad",2018,2019,2020,2021,2022,2023,2024,null,"GRÁFICO 44. EFECTO APLICACIÓN MODIFICATORIO A LINEAMIENTOS SOBRE EL CUMPLIMIENTO DE CEL DE CFE SSB"]
[null,"Información general","Consumo final","GWh",235532.14855287332,237388.26668756615,231283.71161612673,241144.49981026602,243044.84624674747,244960.16842010658,246890.58434708524]
[null,null,"Requisito CEL sin aplic. Modificatorio","% Req. CEL sin aplic. Modificatorio",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[null,null,null,"miles CEL",11776.607427643667,13768.519467878838,17114.994659593376,26284.750479318995,33783.233628297901,36254.104926175773,42958.961676392828]
[null,null,null,"miles CEL (acum.)",11776.607427643667,25545.126895522502,42660.121555115882,68944.872034434869,102728.10566273276,138982.21058890852,181941.17226530134]
[null,"Escenario A (Base)","CEL disponibles (A)","CEL adq. sin aplic. Modificatorio (A)",4369.162093369041,12304.218668591862,19700.539102822102,22911.898001631704,23277.623892645403,23498.555148645406,26105.807314514252]
[null,null,null,"% CEL (A)",1.8550172960309204E-2,5.183162099913647E-2,8.5179103038263593E-2,9.501314780000758E-2,9.5775015401944219E-2,9.5928065775760712E-2,0.10573836739684664]
[null,null,null,"CEL utilizados año anterior",0,3415.9958361525132,5932.8575926173025,6587.7140898679136,7759.207964215133,7771.9539982151337,8007.8634195921832]
[null,null,null,"CEL disponibles año anterior",0,0,0,0,0,0,0]
[null,null,null,"CEL año siguiente utilizados",3415.9958361525132,5932.8575926173025,6587.7140898679136,7759.207964215133,7771.9539982151337,8007.8634195921832,8701.9357715047499]
[null,null,null,"Miles CEL disponibles (A)",7785.1579295215543,14821.080425056651,20355.395600072712,24083.391875978923,23290.369926645402,23734.464570022457,26799.879666426816]
[null,null,"Balance cumplimiento Obligación CEL","Obligación CEL (A)",11776.607427643667,17907.176558846495,20355.395600072712,26284.750479318995,36094.660161804975,49509.578413357907,69352.945249895245]
[null,null,null,"Balance (miles CEL)",-3991.4494981221123,-3086.0961337898443,0,-2201.3586033400716,-12804.290235159573,-25775.11384333545,-42553.065583468429]
[null,null,null,"Diferimiento CEL (25%/50%)",2944.1518569109166,3086.0961337898443,0,2201.3586033400716,9023.6650404512438,12377.394603339477,17338.236312473811]
[null,null,null,"Incumplimiento (con multa)",1047.2976412111957,0,0,0,3780.6251947083292,13397.719239995973,25214.829270994618]
[null,null,"Cumplimiento obligación (sin considerar balance)","% anual (sin considerar balance)",0.37100345920618405,0.89364863791614602,1.1510689599765351,0.87168025504594104,0.68902888778377125,0.64816260659297775,0.60769176664854396]
[null,null,null,"% anual (considerando balance)",0.66106966521166055,0.8276614895905936,1,0.91624959099109138,0.64525804709725598,0.47939136891577311,0.3864274194824811]
[]
[null,"Sí aplicación Modificatorio"]
[]
[null,null,"Concepto","Unidad",2018,2019,2020,2021,2022,2023,2024]
[null,"Información general","Consumo final","GWh",235532.14855287332,237388.26668756615,231283.71161612673,241144.49981026602,243044.84624674747,244960.16842010658,246890.58434708524]
[null,null,"Requisito CEL con aplic. Modificatorio","% Req. CEL con aplic. Modificatorio",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.26178861840750767,0.28742950188722083,0.3026795970355533,0.32450054070823608]
[null,null,null,"miles CEL",11776.607427643667,13768.519467878838,17114.994659593376,63128.885441899038,69858.259092958804,74144.445067159133,80116.128116401524]
[null,null,null,"miles CEL (acum.)",11776.607427643667,25545.126895522502,42660.121555115882,105789.00699701492,175647.26608997374,249791.71115713287,329907.83927353437]
[null,"Escenario A (Base)","CEL disponibles (A)","CEL adq. con aplic. Modificatorio (A)",4369.162093369041,12304.218668591862,19700.539102822102,70379.994181471702,70745.720072485405,70966.651328485401,73573.90349435425]
[null,null,null,"% CEL (A)",1.8550172960309204E-2,5.183162099913647E-2,8.5179103038263593E-2,0.29185817730384528,0.2910809308034531,0.2897069012737517,0.29800206309578064]
[null,null,null,"CEL utilizados año anterior",0,3415.9958361525132,5932.8575926173025,6587.7140898679136,0,0,1626.9381094423734]
[null,null,null,"CEL disponibles año anterior",0,0,0,0,663.39464970475092,1550.8556292313588,0]
[null,null,null,"CEL año siguiente utilizados",3415.9958361525132,5932.8575926173025,6587.7140898679136,0,0,1626.9381094423734,8169.1627314896468]
[null,null,null,"Miles CEL disponibles (A)",7785.1579295215543,14821.080425056651,20355.395600072712,63792.280091603789,71409.114722190163,74144.445067159133,80116.128116401524]
[null,null,"Balance cumplimiento Obligación CEL","Obligación CEL (A)",11776.607427643667,17907.176558846495,20355.395600072712,63128.885441899038,69858.259092958804,74144.445067159133,80116.128116401524]
[null,null,null,"Balance (miles CEL)",-3991.4494981221123,-3086.0961337898443,0,663.39464970475092,1550.8556292313588,0,0]
[null,null,null,"Diferimiento CEL (25%/50%)",2944.1518569109166,3086.0961337898443,0,0,0,0,0]
[null,null,null,"Incumplimiento (con multa)",1047.2976412111957,0,0,0,0,0,0]
[null,null,"Cumplimiento obligación (sin considerar balance)","% anual (sin considerar balance)",0.37100345920618405,0.89364863791614602,1.1510689599765351,1.114861979406341,1.0127037374112871,0.95714050141186813,0.91834072894109398]
[null,null,null,"% anual (considerando balance)",0.66106966521166055,0.8276614895905936,1,1.0105085753543885,1.0222000325998344,1,1]

{"sheet":"3. Obligaciones CEL","index":3,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,2,3,6],[3,7,3,8]]}
[]
[null,"Obligaciones CELs (sin tener en cuenta Modificatorio Lineamientos CEL)"]
[]
[null,"Fuente:","SENER",null,null,null,null,"Estimación realizada por la COFECE"]
[null,"Fecha DOF","2015-03-31","2016-03-31","2017-03-31","2018-03-29","2019-03-29","-","-"]
[]
[null,"Objetivos Energías Limpias",2018,2019,2020,2021,2022,2023,2024]
[null,"% Objetivo Generación limpia",0.25,0.26700000000000002,0.28299999999999997,0.3,0.317,0.33350000000000002,0.35,null,null,null,null,"GRÁFICO 33. ESTIMACIÓN DE RANGO DE REQUISITOS DE CEL PARA 2023 Y 2024"]
[null,"Equivalencia (MWh)",null,85861277,90474710,100362859,110822839,123900586,133885674.99999999]
[null,"Generación estimada (MWh)",null,321577816.47940075,319698621.90812725,334542863.33333337,349598861.19873816,371516000,382530500,null,"Dato Consumo Bruto PAMNRT 2019"]
[null,"Generación limpia sin CELs (MWh)",null,69378490,69117114,66504797,66516692,78709787.561306208,78709787.561306208,null,"Energía Limpia sin CELs (% Cogeneración y 100% resto)"]
[null,"Generación limpia NECESARIA (MWh)",null,16482787,21357596,33858062,44306147,45190798.438693792,55175887.438693777]
[null,"Consumo estimado (MWh)",null,304644261,311260714,331472889,340627664,343540845.19999999,353725953.35000002,null,"Consumo Final más pérdidas técnicas estimadas"]
[null,"Consumo estimado CILs exentos (MWh)",null,20978632,21778784,20817068,21334611,37412201.161763623,37412201.161763623]
[null,"Consumo participantes obligados (MWh)",null,283665629,289481930,310655821,319293053,306128644.03823638,316313752.18823642]
[null,"Obligación consumo energía limpia (MWh)",null,16482787,21357596,33858062,44306147,45190798.438693792,55175887.438693777]
[null,"% Requisito Esc. A (Base)",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[null,"% Energía entregada (C/G)",null,0.94734227732252341,0.97360668038615417,0.99082337520895047,0.97433859719114402,0.92469999999999997,0.92470000000000008]
[null,"% Pérdidas",null,5.2657722677476593E-2,2.6393319613845834E-2,9.1766247910495258E-3,2.5661402808855982E-2,7.5300000000000034E-2,7.5299999999999923E-2]
[]
[null,"% Base Energía Limpia sin CELs",null,0.21574401729431533,0.21619459473260536,0.19879305251756527,0.19026575707918836,0.21186109766821942,0.20576081531095222]
[]
[]
[]
[]
[null,"Objetivos Energías Limpias",null,null,null,2021,2022]
[null,"Objetivo % Generación limpia",null,null,null,0.3,0.317]
[null,"Equivalencia (MWh)",null,null,null,98969440,107780453]
[null,"Generación estimada (MWh)",null,null,null,329898133.33333337,340001429.02208203]
[null,"Generación limpia sin CELs (MWh)",null,null,null,65710885,63223402]
[null,"Generación limpia con CELs NECESARIA (MWh)",null,null,null,33258555,44557051]
[null,"Consumo estimado (MWh)",null,null,null,322925382,334863025]
[null,"Consumo estimado CILs exentos (MWh)",null,null,null,18583536,13441012]
[null,"Consumo participantes obligados (MWh)",null,null,null,304341846,321422013]
[null,"Obligación consumo energía limpia (MWh)",null,null,null,33258556,44557051]
[null,"% Obligación",null,null,null,0.10928025980364199,0.13862476494414835]
[null,"% Energía entregada (C/G)",null,null,null,0.97886392607657458,0.98488711051344346]
[null,"% Pérdidas",null,null,null,2.1136073923425425E-2,1.5112889486556536E-2]
[null,null,null,null,null,-0.14671379265251905,-0.38283918881788814]
[]
[null,"Estimación Obligaciones CELs (teniendo en cuenta Modificatorio Lineamientos CELS) - sobre Escenario A"]
[]
[null,null,2018,2019,2020,2021,2022,2023,2024]
[null,"Generación CE Legadas (con CELs)",null,47468096.179839998,47468096.179839998,47468096.179839998,47468096.179839998,47468096.179839998,47468096.179839998]
[null,"Generación limpia sin CELS",null,21910393.820160002,21649017.820160002,19036700.820160002,19048595.820160002,31241691.38146621,31241691.38146621]
[null,"CELs necesarios en el Sistema",null,63950883.179839998,68825692.179839998,81326158.179839998,91774243.179839998,92658894.61853379,102643983.61853378]
[null,"% Requisito",0.2084445961792572,0.22544459617925722,0.23775470952483976,0.26178861840750767,0.28742950188722083,0.30267959703555353,0.32450054070823631]
[null,"CELs faltantes",null,16482787,21357596,33858062,44306147,45190798.438693792,55175887.438693777]
[]
[null,"% Base Energía Limpia sin CELs",null,6.8134033808776459E-2,6.7716956960738303E-2,5.6903622544750343E-2,5.4487007637394315E-2,8.4092451957563624E-2,8.1671112189658626E-2,null,null,null,2018,2019,2020,2021,2022,2023,2024]
[null,null,null,null,null,null,null,null,null,null,null,"Req. SENER",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001]
[null,"Simulación Obligaciones CELs teniendo en cuenta estimaciones realizadas en base a últimos datos reales",null,null,null,null,null,null,null,null,null,"% Requisito Esc. A",0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[]
[null,"Objetivos Energías Limpias",2018,2019,2020,2021,2022,2023,2024]
[null,"% Objetivo Generación limpia",0.25,0.26700000000000002,0.28299999999999997,0.3,0.317,0.33350000000000002,0.35]
[null,"Equivalencia (MWh)",79559099.999999985,87854214,96109912.999999985,105069300,114359018,123900586,133885674.99999999]
[null,"Generación estimada (MWh)",318236399.99999994,329042000,339611000,350231000,360754000,371516000,382530500]
[null,"Generación limpia sin CELs (MWh)",67293835.214340478,70710162.61147745,74246209.971484348,76071698.417546183,77241120.73570618,78709787.561306208,78709787.561306208]
[null,"Generación limpia NECESARIA (MWh)",12265264.785659507,17144051.38852255,21863703.028515637,28997601.582453817,37117897.26429382,45190798.438693792,55175887.438693777]
[null,"Consumo estimado (MWh)",294273199.07999998,304265137.40000004,314038291.69999999,323858605.69999993,333589223.79999995,343540845.19999999,353725953.35000002]
[null,"Consumo estimado CILs exentos (MWh)",25036909.297580019,29742854.498333812,32948623.571941771,34774112.018003628,35943534.336163625,37412201.161763623,37412201.161763623]
[null,"Consumo participantes obligados (MWh)",269236289.78241998,274522282.90166622,281089668.1280582,289084493.68199629,297645689.46383631,306128644.03823638,316313752.18823642]
[null,"Obligación consumo energía limpia (MWh)",12265264.785659507,17144051.38852255,21863703.028515637,28997601.582453817,37117897.26429382,45190798.438693792,55175887.438693777]
[null,"% Obligación",4.5999999999999999E-2,6.2E-2,7.8E-2,0.1,0.125,0.14799999999999999,0.17399999999999999]
[null,"Dif. vs obligación SENER",-4.0000000000000036E-3,3.9999999999999966E-3,4.0000000000000036E-3,-8.9999999999999941E-3,-1.4000000000000012E-2]

{"sheet":"4. C Datos SEN","index":4,"n_rows":52,"n_cols":21,"rows_kept":52,"cut":false,"hidden":false,"merged":[[17,13,19,13],[17,1,19,1],[47,1,49,1],[6,2,6,3],[6,4,6,9],[27,4,27,9],[45,4,45,9]]}
[]
[null,"Datos de consumo"]
[]
[null,"Consumo bruto de energía eléctrica (GWh)"]
[null,"(Ventas SSB, ventas SSC, ventas SUR, Autoabastecimiento Remoto, Importación, pérdidas y usos propios Dx, Tx y Generadores)"]
[]
[null,null,"Fuente - Prodesen 2019: Tabla 6.1 Consumo bruto",null,"Fuente: PAMNRT 2019 - Figura 6.6. Pronóstico del consumo bruto del SEN 2019-2033, Escenario de Planeación"]
[null,"Sistema",2017,2018,2019,2020,2021,2022,2023,2024]
[null,"SIN",293127.3,300786.8,311161,321142,331193,341147,351331,361768.3]
[null,"BC",13825.2,14535.8,14857,15346,15822,16293,16765,17240.2]
[null,"BCS",2622,2758.8,2861,2952,3039,3130,3230,3325]
[null,"Mulegé",152,155,163,171,177,184,190,197]
[null,"Total",309726.5,318236.39999999997,329042,339611,350231,360754,371516,382530.5]
[null,"% Incremento",null,2.747553083123333E-2,3.3954632468190526E-2,3.2120519568930472E-2,3.1271071902853498E-2,3.0045884002272816E-2,2.9831963055156674E-2,2.9647444524596445E-2]
[null,"Dif. vs. Obligaciones  CEL SENER",null,null,2.3211126943756044E-2,6.2284841808279756E-2,4.6894249993416182E-2,3.190839570532944E-2]
[]
[null,null,null,2018,2019,2020,2021,2022,2023,2024,"Fuente - Prodesen 2019: Tabla 6.9",null,null,null,null,2019,2020,2021,2022,2023,2024]
[null,"Consumo bruto","Planeación",318236.39999999997,329042,339611,350231,360754,371516,382530.5,null,null,null,"% Incremento","Planeación",3.3954632468190526E-2,3.2120519568930472E-2,3.1271071902853498E-2,3.0045884002272816E-2,2.9831963055156674E-2,2.9647444524596445E-2]
[null,null,"Alto",318236.39999999997,329374.67399999994,340902.78758999991,352834.38515564986,365183.58863609756,377965.01423836092,391193.7897367035,3.5000000000000003E-2,null,null,null,"Alto",3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2]
[null,null,"Bajo",318236.39999999997,326828.78279999993,335653.15993559989,344715.79525386106,354023.12172571529,363581.74601230957,373398.4531546419,2.7E-2,null,null,null,"Bajo",2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Proporción alto",1.0307871844228855,1.0896461349228856,1.1192452919020739,1.1648850137793394,1.173238245679243,1.1805401970130314]
[null,"Dato de Consumo para análisis","Planeación",318236.39999999997,329042,339611,350231,360754,371516,382530.5,null,null,null,null,"Proporción bajo",0.7951786851262258,0.84058416122622603,0.86341779661017115,0.89862558205834742,0.90506950380970153,0.91070243769576686]
[]
[]
[null,"Consumo final"]
[null,"(Ventas SSB, ventas SSC, ventas SUR, Autoabastecimiento Remoto)"]
[]
[null,null,null,"Fuente: Prodesen 2019 - Gráfico 6.3","Fuente: Estimación realizada por la COFECE"]
[null,"Sistema",null,2018,2019,2020,2021,2022,2023,2024]
[null,"SEN - Escenario Planeación","Planeación",268811,277938.3787084067,286865.90384066687,295836.50814614544,304725.17755354196,313815.72779229528,323119.56217296328]
[null,null,"Dif. respecto Consumo Bruto",-0.15531032905098219]
[null,"SEN - Escenario Alto","Alto",268811,278219.38499999995,287957.06347499992,298035.56069662492,308466.80532100674,319263.14350724191,330437.35352999537]
[null,"SEN - Escenario Bajo","Bajo",268811,276068.89699999994,283522.7572189999,291177.8716639129,299039.67419883853,307113.74540220713,315405.8165280667]
[]
[null,"Pérdidas"]
[]
[null,null,null,"Fuente: Prodesen 2019 (p.140)"]
[null,null,null,2018]
[null,"Pérdidas técnicas RGD",null,5.9200000000000003E-2,"se considera para consumo final de Obligaciones"]
[null,"Pérdidas no técnicas RGD",null,7.5399999999999995E-2]
[null,"Total pérdidas RGD",null,0.13450000000000001]
[null,"Pérdidas técnicas AT",null,2.0810329050982179E-2,"se considera para consumo final de Obligaciones"]
[]
[null,"Consumo final más pérdidas técnicas RGD"]
[]
[null,null,null,null,"Fuente: Estimación realizada por la COFECE de consumo final con pérdidas técnicas RGD"]
[null,null,null,2018,2019,2020,2021,2022,2023,2024]
[null,"Consumo final más pérdidas técnicas","Planeación",294273.19907999999,304265.13740000001,314038.2917,323858.60569999996,333589.22379999998,343540.84519999998,353725.95335000003]
[null,null,"Alto",294273.19907999999,304572.76104779996,315232.80768447288,326265.95595342945,337685.26441179944,349504.24866621231,361736.89736952976]
[null,null,"Bajo",294273.19907999999,302218.57545515994,310378.4769924492,318758.69587124535,327365.18065976893,336204.04053758265,345281.54963209736]
[]
[null,"Dato de Consumo para análisis","Planeación",294273.19907999999,304265.13740000001,314038.2917,323858.60569999996,333589.22379999998,343540.84519999998,353725.95335000003]

{"sheet":"4. C Demanda CFE SSB","index":5,"n_rows":65,"n_cols":18,"rows_kept":65,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,4,5,9],[15,4,15,9]]}
[]
[null,"Datos CFE SSB"]
[]
[null,"Ventas CFE SSB (GWh) - Datos reales y proyección"]
[]
[null,null,"Fuente: Informe Anual CFE 2018 (p.165)",null,"Fuente: estimación realizada por la COFECE de incremento anual"]
[null,"Segmento",2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Residencial",59152.857000000004,61468.745000000003]
[null,"Comercial",14896.744000000001,15251.535]
[null,"Servicios",4947.5619999999999,4633.5060000000003]
[null,"Agrícola",11579.377,10923.067999999999]
[null,"Empresa mediana",87498.255000000005,87578.331999999995,null,null,null,null,null,null,null,null,"(GWh)"]
[null,"Gran industria",37235.135999999999,38228.050999999999,null,null,null,null,null,null,null,"% cambio",2019,2020,2021,2022,2023,2024]
[null,"Consumo Neto total SSB P",215309.93100000001,218083.23699999999,219801.84846580314,221534.00350061702,223279.80883494191,225039.372040371,226812.80153621861,228600.20659620073,"<-",5.0000000000000001E-3,1090.416185,1099.0092423290157,1107.6700175030851,1116.3990441747096,1125.1968602018551,1134.064007681093]
[null,null,null,0.81128836617549127,0.79082942588653327,0.77225630698747327,0.75474054988723716,0.73849943692568787,0.72275791634745234,0.70747869630323679,null,"% sobre Mediana y Gran Industria",8.6674154283570819E-3,8.7357192546344466E-3,8.8045613512558029E-3,8.8739459600766808E-3,8.9438773563806778E-3,9.0143598491428927E-3]
[null,null,null,0.81128836617549127,"Fuente: estimación realizada por la COFECE de incremento anual"]
[null,"Consumo Neto total SSB P",null,1.2880529881364344E-2,1.2880529881364344E-2,1.2880529881364344E-2,1.2880529881364344E-2,1.2880529881364344E-2,1.2880529881364344E-2,1.2880529881364344E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"GRÁFICO 50. PROYECCIÓN DE DEMANDA DE CFE SSB, (TWH)"]
[]
[null,"(GWh)",2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Consumo CFE SSB final (con pérdidas técnicas)",232536.94942725427,235532.14855287332,237388.26668756615,239259.01201668283,241144.49981026602,243044.84624674747,244960.16842010658,246890.58434708524,"Incluye pérdidas técnicas"]
[null,null,null,0.05,5.8000000000000003E-2,7.3999999999999996E-2,0.109,0.13900000000000001,0.14799999999999999,0.17399999999999999]
[null,"Requerimiento anual de CEL (millones de CEL)",null,11.776607427643667,13.768519467878837,17.70516688923453,26.284750479318994,33.7832336282979,36.254104926175771,42.958961676392825]
[null,"Incremento anual obligación CEL CFE SSB",null,11.776607427643667,1.9919120402351709,3.9366474213556923,8.5795835900844644,7.4984831489789059,2.4708712978778706,6.7048567502170542]
[null,"Obligación CEL CFE SSB año anterior",null,0,11.776607427643667,13.768519467878837,17.70516688923453,26.284750479318994,33.7832336282979,36.254104926175771]
[null,null,null,11.776607427643667,13.768519467878837,17.70516688923453,26.284750479318994,33.7832336282979,36.254104926175771,42.958961676392825]
[]
[null,null,null,0.05,8.0000000000000002E-3,1.5999999999999993E-2,3.5000000000000003E-2,3.0000000000000013E-2,8.9999999999999802E-3,2.5999999999999995E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Segmento"]
[null,"Residencial",0.27473352819940294,0.2818591004314559]
[null,"Comercial",6.9187444958124109E-2,6.9934467269485739E-2]
[null,"Servicios",2.2978791442741207E-2,2.1246502315994148E-2]
[null,"Agrícola",5.3780041386014839E-2,5.0086692357744121E-2]
[null,"Empresa mediana",0.40638281101859625,0.40158213535687753]
[null,"Gran industria",0.17293738299512063,0.17529110226844258]
[null,"Consumo Neto total SSB P",1,1]