{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ENTRADA","CÁLCULOS","SALIDA"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"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":"ENTRADA","index":0,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[2,4,2,7],[1,4,1,7],[14,9,15,9],[5,4,5,7],[6,4,6,7],[14,2,14,4],[14,5,14,7],[14,8,15,8],[30,11,30,13],[29,11,29,13],[14,1,15,1],[3,4,3,7],[4,4,4,7],[41,2,41,4],[42,2,42,4],[41,8,41,9],[42,8,42,9],[41,11,41,13],[42,11,42,13]]}
[{"$f":"CELL(\"fila\",C13)","v":13}]
[{"$f":"CELL(\"fila\",C21)","v":21},null,null,"Compañía*"]
[{"$f":"CELL(\"fila\",C28)","v":28},null,null,"Ubicación*"]
[{"$f":"CELL(\"fila\",C40)","v":40},null,null,"Estado*"]
[{"$f":"MATCH(B35,B:B,0)","v":35},null,null,"Contacto*"]
[{"$f":"COUNTBLANK(E2:E7)+COUNTBLANK(E9)+COUNTBLANK(INDIRECT(\"C\"&A1))+COUNTBLANK(INDIRECT(\"C\"&A2))+COUNTBLANK(INDIRECT(\"C\"&A3))+COUNTBLANK(INDIRECT(\"C\"&A4))","v":7},null,null,"Teléfono*"]
[null,null,null,"Correo*"]
[]
[null,null,null,"Tarifa CFE*"]
[]
[null,"Equipos HVAC"]
[]
[null,"Cantidad*",1,null,{"$f":"MATCH(B19,B:B,0)-MATCH(B11,B:B,0)-7","v":1},{"$f":"ROW()+MATCH(B19,B:B,0)-MATCH(B11,B:B,0)-4","v":17}]
[]
[null,"Cantidad","Capacidad",null,null,"Eficiencia",null,null,"Consumo [kW]","¿Encendido manual?"]
[null,null,"Valor","Unidad","BTUh","Valor","Unidad","EER"]
[null,null,null,null,{"$f":"IFERROR(IF(ISBLANK(D17),0,IF(D17=\"BTUh\",C17,C17*12000)),0)","v":0},null,null,{"$f":"IF(OR(B17=0,ISBLANK(F17),ISBLANK(G17)),0,IF(G17=\"EER\",F17,(-0.02*F17^2)+(1.12*F17)))","v":0},{"$f":"IFERROR(B17*((E17/H17)/1000),0)","v":0}]
[]
[null,"Luminaria"]
[]
[null,"Cantidad*",1,null,{"$f":"MATCH(B26,B:B,0)-MATCH(B19,B:B,0)-6","v":1},{"$f":"ROW()+MATCH(B26,B:B,0)-MATCH(B19,B:B,0)-4","v":24}]
[]
[null,"Cantidad","Tecnología","Potencia","Consumo [W]","¿Interior o Exterior?","¿Encendido manual?","Tipo de sensor"]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(B24),B24=0,ISBLANK(D24),D24=0),0,B24*D24)","v":0}]
[]
[null,"Motores"]
[]
[null,"Cantidad*",1,null,{"$f":"MATCH(B33,B:B,0)-MATCH(B26,B:B,0)-6","v":1},{"$f":"ROW()+MATCH(B33,B:B,0)-MATCH(B26,B:B,0)-4","v":31}]
[]
[null,"Cantidad","Alimentación","Tensión [V]","Corriente nominal [A]","Potencia [HP]","Factor de potencia","rpm","Letra código NEMA","Operación diaria [hrs]","Factor de servicio","Tipo de servicio"]
[]
[]
[null,"Computadoras"]
[]
[null,"Cantidad de equipos:"]
[null,"¿Suspensión automática?"]
[]
[null,"Otro tipo de cargas"]
[]
[null,"Cantidad*",1,null,{"$f":"MATCH(B45,B:B,0)-MATCH(B38,B:B,0)-6","v":1},{"$f":"ROW()+MATCH(B45,B:B,0)-MATCH(B38,B:B,0)-4","v":43}]
[]
[null,"Cantidad","Descripción",null,null,"Alimentación","Tensión [V]","Potencia [W]","Modelo",null,"Operación diaria [hrs]","Descripción"]
[]
[]
[null,"Fin"]

{"sheet":"CÁLCULOS","index":1,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":true,"merged":[[12,4,12,5],[17,4,17,5],[13,4,13,5],[20,4,20,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[18,4,18,5]]}
["Baja California"]
["Baja California Sur",null,null,null,"HVAC"]
["Campeche"]
["Coahuila",1,null,null,"manual","EER <11","kW instalados"]
["Colima",null,null,null,{"$f":"COUNTIF(OFFSET(OFFSET(INDIRECT(\"ENTRADA!J\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1),\"=Sí\")","v":0},{"$f":"SUM(ISNUMBER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1))*ISNUMBER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!F\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1))*(OFFSET(OFFSET(INDIRECT(\"ENTRADA!H\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1)<11.18))","v":0},{"$f":"IFERROR(SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!I\"&ENTRADA!A1+4),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A1),1)),0)","v":0}]
["Chiapas"]
["Chihuahua",1,null,null,{"$f":"IF(E5>0,\"• Encender equipos HVAC de manera simultanea podría significar un aumento en el costo por demanda, debe controlar la filosofía de operación.\",\"\")","v":""}]
["Ciudad de México",1,null,null,{"$f":"IF(F5>0,\"• Tener equipos HVAC instalados con un SEER menor a 13 implica mantener un sistema ineficiente, aumentando el costo por consumo.\",\"\")","v":""}]
["Durango",1,null,null,{"$f":"IFERROR(IF(AND(G5>40,IFERROR(VLOOKUP(ENTRADA!E4,A1:B31,2,FALSE),0)=1),\"• Si los sistemas HVAC instalados no son tecnología HMX, debería considerar su reemplazo, con esto podría reducir entre 53-95% su consumo actual. [1]\",\"\"),\"\")","v":""}]
["Estado de México",1]
["Guanajuato",1,null,null,"Luminaria"]
["Guerrero"]
["Hidalgo",1,null,null,"Tecnología",null,"% instalado","Consumo [W]","Pérdidas [W]",null,"Manual","W sin","Cantidad sin"]
["Jalisco",null,null,null,"LED",null,{"$f":"IFERROR(SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E14)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))/SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)),0)","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E14)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"0.25*H14","v":0},null,{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!G\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"Sí\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!H\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"Ninguno\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!H\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"Ninguno\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0}]
["Michoacán",null,null,null,"Fluorescente + CFL",null,{"$f":"IFERROR(SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"CFL\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1),(OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"Fluorescente\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))/SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)),0)","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"CFL\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1),(OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=\"Fluorescente\")*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"0.55*H15","v":0}]
["Morelos",1,null,null,"Halógena",null,{"$f":"IFERROR(SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E16)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))/SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)),0)","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E16)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"0.62*H16","v":0}]
["Nayarit",null,null,null,"Incandescente",null,{"$f":"IFERROR(SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E17)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))/SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)),0)","v":0},{"$f":"SUM((OFFSET(OFFSET(INDIRECT(\"ENTRADA!C\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)=E17)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1)*OFFSET(OFFSET(INDIRECT(\"ENTRADA!D\"&ENTRADA!A2+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A2),1))","v":0},{"$f":"0.65*H17","v":0}]
["Nuevo León",1,null,null,"Total",null,{"$f":"SUM(G14:G17)","v":0},{"$f":"SUM(H14:H17)","v":0},{"$f":"SUM(I14:I17)","v":0}]
["Oaxaca",null,null,null,"Total NO LED",null,{"$f":"SUM(G15:G17)","v":0},{"$f":"SUM(H15:H17)","v":0},{"$f":"SUM(I15:I17)","v":0}]
["Puebla",1]
["Querétaro",1,null,null,"Pérdidas en calor y radiación [W]",null,{"$f":"IFERROR(I19/H18,0)","v":0}]
["Quintana Roo"]
["San Luis Potosí",1,null,null,{"$f":"IF(AND(G18>0,G14<1),\"• Actualmente, el \"&ROUND((1-G14)*100,1)&\"% de las lámparas en '\"&ENTRADA!E2&\"' no son tecnología LED, esto se traduce como un mayor costo por consumo (\"&TEXT(H19,\"0,0\")&\" W).\",\"\")","v":""}]
["Sinaloa",null,null,null,{"$f":"IFERROR(IF(G21<0.15,\"\",\"• Si migra a tecnología LED, podría reducirse a cero el \"&ROUND(G21*100,1)&\"% de pérdidas en calor que producen las lámparas instaladas (\"&TEXT(I19,\"0,0\")&\" W)\"&IF(G5>0,\",\",\".\")),\"\")","v":""}]
["Sonora",null,null,null,{"$f":"IF(AND(E24<>\"\",G5>0),\"recuerde que el calor generado por los equipos de iluminación se extrae mediante el sistema HVAC instalado.\",\"\")","v":""}]
["Tabasco",null,null,null,{"$f":"IF(K14>0,\"• Apagar la iluminación manualmente de manera responsable permite disminuir el consumo, sin embargo, confiar en el factor humano resulta en un\",\"\")","v":""}]
["Tamaulipas",null,null,null,{"$f":"IF(E26<>\"\",\"incremento importante en el cobro por consumo.\",\"\")","v":""}]
["Tlaxcala",1,null,null,{"$f":"IF(L14>500,\"• Instalar sensores en las \"&TEXT(M14,\"0,0\")&\" lámparas que operan manualmente, podría reducir entre el 38-55% de su consumo. \"&\"[\"&D57&\"]\",\"\")","v":""}]
["Veracruz",null,null,null,{"$f":"IF(E28<>\"\",\"     - Los sensores de ocupación podrían ahorrarle desde un 24% hasta el 55% del consumo actual de sus equipos de iluminación. \"&\"[\"&D58&\"]\",\"\")","v":""}]
["Yucatán",null,null,null,{"$f":"IF(E28<>\"\",\"     - Aprovechar la luz natural mediante sensores de regulación podría disminuir su consumo desde un 36% hasta el 50%. \"&\"[\"&D59&\"]\",\"\")","v":""}]
["Zacatecas",null,null,null,{"$f":"IFERROR(IF(H18>10000,\"• Encender luminarias por bloques y de manera simultánea podría significar un incremento en el costo por demanda.\",\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(H18<>0,\"• Podría ahorrar energía eléctrica si implementa una solución de aprovechamiento de luz natural, para aquellos lugares de difícil acceso,\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(E32<>\"\",\"una hibridación con transferencia por fibra óptica es su mejor opeción, para ello, solicite un estudio de viabilidad.\",\"\")","v":""}]
[]
[null,"A",null,null,"Motores"]
[null,"B"]
[null,"C",null,null,"FP < 0.8","hrs op > 2","NEMA > B"]
[null,"D",null,null,{"$f":"SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)*(OFFSET(OFFSET(INDIRECT(\"ENTRADA!G\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)<0.8)*ISNUMBER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1))*ISNUMBER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!G\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)))","v":0},{"$f":"SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)*(OFFSET(OFFSET(INDIRECT(\"ENTRADA!J\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)>=2)*ISNUMBER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)))","v":0},{"$f":"SUM(OFFSET(OFFSET(INDIRECT(\"ENTRADA!B\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)*(IFERROR(MATCH(UPPER(OFFSET(OFFSET(INDIRECT(\"ENTRADA!i\"&ENTRADA!A3+3),0,0,1,1),0,0,INDIRECT(\"ENTRADA!E\"&ENTRADA!A3),1)),B35:B53,0),0)>2))","v":0}]
[null,"E"]
[null,"F",null,null,{"$f":"IF(E38>0,\"• \"&E38&IF(E38>1,\" motores instalados tienen\",\" motor instalado tiene\")&\" baja eficiencia, esto implica un aumento por consumo y, en su caso, una penalización en su recibo de CFE.\",\"\")","v":""}]
[null,"G",null,null,{"$f":"IF(E40<>\"\",\"• Instalar un banco de capacitores puede mejorar el factor de potencia de su instalación y con ello obtener bonificaciones por un factor de potencia mayor a 90%.\",\"\")","v":""}]
[null,"H",null,null,{"$f":"IF(F38>0,\"• Algunos motores tienen una operación contínua prolongada,  para reducir su costo por consumo verifique que éstos sean motores de gran eficiencia.\",\"\")","v":""}]
[null,"J",null,null,{"$f":"IF(G38>0,\"• Para reducir su costo por demanda considere asistir el arranque de sus motores o implemente un variador de velocidad para un arranque más suave.\",\"\")","v":""}]
[null,"K"]
[null,"L",null,null,"Computadoras"]
[null,"M"]
[null,"N",null,null,"Cantidad","Sin suspensión"]
[null,"P",null,null,{"$f":"INDIRECT(\"ENTRADA!D\"&ENTRADA!A5)","v":0},{"$f":"INDIRECT(\"ENTRADA!D\"&ENTRADA!A5+1)","v":0}]
[null,"R"]
[null,"S",null,null,{"$f":"IF(E48>50,\"• Activar la suspensión automática en sus equios de cómputo podría reducir considerablemente los costos por consumo.\",\"\")","v":""}]
[null,"T",null,null,{"$f":"IF(E48>50,\"• Las computadoras son una fuente importante de armónicos, haga un estudio de calidad de la energía para descartar efectos negativos en su instalación.\",\"\")","v":""}]
[null,"U"]
[null,"V",null,null,"Referencias"]
[]
[null,null,null,{"$f":"IF(E9<>\"\",1,\"\")","v":""},{"$f":"IF(D55<>\"\",\"[1] Según el tiempo de operación de compresores y la reducción del consumo pico (demanda) en referencia a los sistemas HVAC tradicionales.\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF(E55<>\"\",\"La tecnología híbrida HMX (Heat mass exchanger) no emplea compresores ni refrigerante para enfriar.\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(D55<>\"\",L14>500),2,IF(L14>500,1,\"\"))","v":""},{"$f":"IF(D57<>\"\",\"[\"&D57&\"]\"&\" De acuerdo con su filosofía de operación y el nivel de luz natural que pueda aprovecharse en sitio.\",\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(D57+1,\"\")","v":""},{"$f":"IF(D58<>\"\",\"[\"&D58&\"]\"&\" Este tipo de sensores (presencia y movimiento) proveen una mejor respuesta en espacios cerrados.\",\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(D58+1,\"\")","v":""},{"$f":"IF(D59<>\"\",\"[\"&D59&\"]\"&\" Depende de la cantidad de lámparas compatibles con dimming y de las tareas específicas que desarrolle en sitio.\",\"\")","v":""}]
[]
[]
[null,null,null,null,"Respuestas"]
[]
[null,null,null,null,{"$f":"E7","v":""}]
[null,null,null,null,{"$f":"E8","v":""}]
[null,null,null,null,""]
[null,null,null,null,{"$f":"E23","v":""}]
[null,null,null,null,{"$f":"E24","v":""}]
[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,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"E40","v":""}]
[null,null,null,null,{"$f":"E41","v":""}]
[null,null,null,null,""]
[null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-63),\"\")","v":""},null,""]
[null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-63),\"\")","v":""},null,{"$f":"E50","v":""}]
[null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-63),\"\")","v":""},null,{"$f":"E51","v":""}]
[]
[null,null,null,null,"Respuestas filtradas"]
[]
[null,null,{"$f":"20-COUNTBLANK(E87:E106)","v":0},{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},{"$f":"IFERROR(OFFSET($E$64,D87-1,0,1,1),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},{"$f":"IFERROR(OFFSET($E$64,D88-1,0,1,1),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$64:$E$83<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}),\"\"),ROW()-86),\"\")","v":""},""]
[]
[null,null,null,null,"Referencias filtradas"]
[]
[null,null,{"$f":"5-COUNTBLANK(E110:E114)","v":0},{"$f":"IFERROR(SMALL(IFERROR(IF($E$55:$E$59<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5}),\"\"),ROW()-109),\"\")","v":""},{"$f":"IFERROR(OFFSET($E$55,D110-1,0,1,1),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$55:$E$59<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5}),\"\"),ROW()-109),\"\")","v":""},{"$f":"IFERROR(OFFSET($E$55,D111-1,0,1,1),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$55:$E$59<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5}),\"\"),ROW()-109),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$55:$E$59<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5}),\"\"),ROW()-109),\"\")","v":""},""]
[null,null,null,{"$f":"IFERROR(SMALL(IFERROR(IF($E$55:$E$59<>\"\",1,\"\")*TRANSPOSE({1,2,3,4,5}),\"\"),ROW()-109),\"\")","v":""},""]

{"sheet":"SALIDA","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[14,11,14,12],[9,11,9,13],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12]]}
[{"$f":"IF(OR(ENTRADA!E9=\"DB1\",ENTRADA!E9=\"DB2\",ENTRADA!E9=\"PDBT\",ENTRADA!E9=\"RABT\",ENTRADA!E9=\"APBT\"),1,IF(OR(ENTRADA!E9=\"GDBT\",ENTRADA!E9=\"RAMT\",ENTRADA!E9=\"APMT\",ENTRADA!E9=\"GDMTO\"),2,IF(OR(ENTRADA!E9=\"GDMTH\",AND(ENTRADA!E4<>\"Baja california\",OR(ENTRADA!E9=\"DIST\",ENTRADA!E9=\"DIT\"))),3,IF(AND(ENTRADA!E4=\"Baja California\",OR(ENTRADA!E9=\"DIST\",ENTRADA!E9=\"DIT\")),4,0))))","v":0}]
[{"$f":"CÁLCULOS!C87+23","v":23}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"La tarifa que CFE aplica en '\"&ENTRADA!E2&\"' tiene los siguientes componentes de cobro:\"","v":"La tarifa que CFE aplica en '' tiene los siguientes componentes de cobro:"}]
[]
[null,"1. Costo fijo ",null,"$/mes","* No es posible ahorrar en este rubro"]
[null,"2. Costo por consumo ",null,"$/kWh",{"$f":"IF(A1=4,\"Horarios: Base, Intermedia, Punta, Semipunta\",IF(A1=3,\"Horarios: Base, Intermedia, Punta\",\"\"))","v":""}]
[null,{"$f":"IF(A1=1,\"\",\"3. Costo por demanda\")","v":"3. Costo por demanda"},null,{"$f":"IF(A1=1,\"\",\"$/kW\")","v":"$/kW"}]
[]
[]
[]
[]
[]
[]
[null,"Recomendaciones:"]
[]
[null,"• Encender equipos HVAC de manera simultanea podría significar un aumento en el costo por demanda, debe controlar la filosofía de operación."]
[null,"• Tener equipos HVAC instalados con un SEER menor a 13 implica mantener un sistema ineficiente, aumentando el costo por consumo."]
[null,"• Si los sistemas HVAC instalados no son tecnología HMX, debería considerar su reemplazo, con esto podría reducir entre 53-95% su consumo actual. [1]"]
[]
[null,"[1] Según el tiempo de operación de compresores y la reducción del consumo pico (demanda) en referencia a los sistemas HVAC tradicionales."]
[null,"La tecnología híbrida HMX (Heat mass exchanger) no emplea compresores ni refrigerante para enfriar."]
[null,""]
[null,""]
[null,""]