{"text_format":"2","workbook":"xlsx","n_sheets":14,"sheets":["Hoja1","Hoja2","Hoja3 (Muro Concreto)","Hoja3 (Muro Concreto celular)","Hoja3 (Puerta)","Hoja3 (Losa)","Superficie No Homogénea 1 techo","Superficie No Homogénea 2 techo","Edif.REF","Edif. PROY conducc ","Edf. PROY radiacion","Resumen","Etiqueta","Tabla 1"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":43,"comments":9,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":201,"n_cols":20,"rows_kept":201,"cut":false,"hidden":false,"merged":[[16,4,16,8],[36,4,36,8],[26,4,26,8],[50,8,50,9],[44,4,44,8],[46,4,46,8],[30,4,30,8],[42,4,42,8],[28,4,28,8],[34,4,34,8],[54,4,54,8],[1,1,1,9],[2,1,2,9],[52,8,52,9],[48,4,48,8],[24,4,24,8],[40,4,40,8],[50,4,50,5],[52,4,52,5],[32,4,32,8],[18,4,18,8],[20,4,20,8],[8,4,8,8],[10,4,10,8],[12,4,12,8],[14,4,14,8]]}
[]
[null,"FORMATO PARA INFORMAR DEL CALCULO DEL"]
[null,"PRESUPUESTO ENERGÉTICO"]
[]
[null,"1. Datos Generales"]
[]
[null,"1.1. ","Propietario"]
[]
[null,null,"Nombre",null,"Clima cálido"]
[]
[null,null,"Dirección ",null,"Calle limpia"]
[]
[null,null,"Colonia",null,"Modelo"]
[]
[null,null,"Ciudad "]
[]
[null,null,"Estado"]
[]
[null,null,"Codigo Postal"]
[]
[null,null,"Teléfono"]
[]
[null,"1.2. ","Ubicación de la Obra"]
[]
[null,null,"Nombre",null,"Casa aislada clima cálido"]
[]
[null,null,"Dirección "]
[]
[null,null,"Colonia"]
[]
[null,null,"Ciudad ",null,"Hermosillo"]
[]
[null,null,"Estado",null,"SONORA"]
[]
[null,null,"Codigo Postal"]
[]
[null,null,"Teléfono"]
[]
[null,"1.3.","Unidad de Verificación"]
[]
[null,null,"Nombre"]
[]
[null,null,"Dirección "]
[]
[null,null,"Colonia"]
[]
[null,null,"Ciudad "]
[]
[null,null,"Estado"]
[]
[null,null,"Codigo Postal",{"$nulls":4},"N° de Registro"]
[]
[null,null,"Teléfono",{"$nulls":4},"Fax"]
[]
[null,null,"E-mail"]
[]
[]
[null,"1A. Descripción del Edificio a Evaluar"]
[]
[null,"1A.1","Dimensiones Generales",null,null,"(Se deberán completar todas las celdas de color verde de este formato de cálculo)"]
[]
[null,null,"Niveles",2,{"$nulls":8},"Unidades Adosadas",1]
[]
[null,null,"Techo",{"$f":"(N64*$N$62)+Q64","v":56.7},{"$nulls":8},"Techo 1",38.700000000000003,null,"Techo 2",18,null,"Domos",{"$f":"2*(0.84*0.84)","v":1.4111999999999998}]
[]
[null,null,"Muro norte",{"$f":"(N66*$N$62)+Q66","v":33},{"$nulls":8},"Muro norte 1",16.5,null,"Muro norte 2",16.5]
[]
[null,null,"Ventana Norte",{"$f":"(N68*$N$62)+Q68","v":6.8421000000000003},{"$nulls":8},"Ventana Norte",{"$f":"(2.35*1.13)+(1.75*2.2)","v":6.5055000000000005},null,"Ventana Norte",{"$f":"(0.51*0.66)","v":0.33660000000000001}]
[]
[null,null,"Puerta Norte",{"$f":"(N70*$N$62)+Q70","v":1.68},{"$nulls":8},"Puerta Norte",null,null,"Puerta Norte",1.68]
[]
[null,null,"Muro este",{"$f":"(N72*$N$62)+Q72","v":40.844999999999999},{"$nulls":8},"Muro este 1",{"$f":"N84","v":23.512499999999999},null,"Muro este 2",{"$f":"Q84","v":17.3325}]
[]
[null,null,"Ventana este",{"$f":"(N74*$N$62)+Q74","v":2.1235000000000004},{"$nulls":8},"Ventana este",{"$f":"(1.37*1.55)","v":2.1235000000000004},null,"Ventana este"]
[]
[null,null,"Puerta este",{"$f":"(N76*$N$62)+Q76","v":0},{"$nulls":8},"Puerta este",null,null,"Puerta este"]
[]
[null,null,"Muro sur",{"$f":"(N78*$N$62)+Q78","v":33},{"$nulls":8},"Muro sur 1",{"$f":"(6*2.65)","v":15.899999999999999},null,"Muro sur 2",{"$f":"(6*2.85)","v":17.100000000000001}]
[]
[null,null,"Ventana sur ",{"$f":"(N80*$N$62)+Q80","v":6.9750000000000005},{"$nulls":8},"Ventana sur ",null,null,"Ventana sur ",{"$f":"(4.5*1.55)","v":6.9750000000000005}]
[]
[null,null,"Puerta sur ",{"$f":"(N82*$N$62)+Q82","v":2.2000000000000002},{"$nulls":8},"Puerta sur ",2.2000000000000002,null,"Puerta sur "]
[]
[null,null,"Muro oeste",{"$f":"(N84*$N$62)+Q84","v":40.844999999999999},{"$nulls":8},"Muro oeste 1",{"$f":"(8.25*2.85)","v":23.512499999999999},null,"Muro oeste 2",{"$f":"(6.45*2.65)+(1.2*0.2)","v":17.3325}]
[]
[null,null,"Ventana oeste",{"$f":"(N86*$N$62)+Q86","v":0.33660000000000001},{"$nulls":8},"Ventana oeste",{"$f":"(0.66*0.51)","v":0.33660000000000001},null,"Ventana oeste"]
[]
[null,null,"Puerta oeste",{"$f":"(N88*$N$62)+Q88","v":0},{"$nulls":8},"Puerta oeste",null,null,"Puerta oeste"]
[]
[null,"1A.2","Dimensiones de ventanas",{"$nulls":9},"Superficie Inferior",{"$f":"6*1.2","v":7.1999999999999993}]
[]
[null,null,"Ventana Norte",{"$f":"D68","v":6.8421000000000003}]
[]
[null,null,"Ventana Este",{"$f":"D74","v":2.1235000000000004}]
[]
[null,null,"Ventana Sur",{"$f":"D80","v":6.9750000000000005}]
[]
[null,null,"Ventana Oeste",{"$f":"D86","v":0.33660000000000001}]
[]
[null,null,"Domos",{"$f":"T64","v":1.4111999999999998}]
{"$rows_empty":8}
["LISTA DE CIUDADES"]
[]
[null,null,{"$f":"'Tabla 1'!B6","v":"Aguascalientes"}]
[null,null,{"$f":"'Tabla 1'!B7","v":"La Paz"}]
[null,null,{"$f":"'Tabla 1'!B8","v":"Cabo S. Lucas"}]
[null,null,{"$f":"'Tabla 1'!B9","v":"Ensenada"}]
[null,null,{"$f":"'Tabla 1'!B10","v":"Mexicali"}]
[null,null,{"$f":"'Tabla 1'!B11","v":"Tijuana"}]
[null,null,{"$f":"'Tabla 1'!B12","v":"Campeche"}]
[null,null,{"$f":"'Tabla 1'!B13","v":"Cd. Carmen"}]
[null,null,{"$f":"'Tabla 1'!B14","v":"Monclova"}]
[null,null,{"$f":"'Tabla 1'!B15","v":"Piedras Negras"}]
[null,null,{"$f":"'Tabla 1'!B16","v":"Saltillo"}]
[null,null,{"$f":"'Tabla 1'!B17","v":"Torreón"}]
[null,null,{"$f":"'Tabla 1'!B18","v":"Colima"}]
[null,null,{"$f":"'Tabla 1'!B19","v":"Manzanillo"}]
[null,null,{"$f":"'Tabla 1'!B20","v":"Arriaga"}]
[null,null,{"$f":"'Tabla 1'!B21","v":"Comitán"}]
[null,null,{"$f":"'Tabla 1'!B22","v":"San Cristóbal"}]
[null,null,{"$f":"'Tabla 1'!B23","v":"Tapachula"}]
[null,null,{"$f":"'Tabla 1'!B24","v":"Tuxtla Gutiérrez"}]
[null,null,{"$f":"'Tabla 1'!B25","v":"Casas Grandes"}]
[null,null,{"$f":"'Tabla 1'!B26","v":"Chihuahua"}]
[null,null,{"$f":"'Tabla 1'!B27","v":"C. Juárez"}]
[null,null,{"$f":"'Tabla 1'!B28","v":"H. del Parral"}]
[null,null,{"$f":"'Tabla 1'!B29","v":"México (a)"}]
[null,null,{"$f":"'Tabla 1'!B30","v":"Durango"}]
[null,null,{"$f":"'Tabla 1'!B31","v":"Lerdo"}]
[null,null,{"$f":"'Tabla 1'!B32","v":"Guanajuato"}]
[null,null,{"$f":"'Tabla 1'!B33","v":"León (b)"}]
[null,null,{"$f":"'Tabla 1'!B34","v":"Acapulco"}]
[null,null,{"$f":"'Tabla 1'!B35","v":"Chilpancingo"}]
[null,null,{"$f":"'Tabla 1'!B36","v":"Zihuatanejo"}]
[null,null,{"$f":"'Tabla 1'!B37","v":"Pachuca"}]
[null,null,{"$f":"'Tabla 1'!B38","v":"Tulancingo"}]
[null,null,{"$f":"'Tabla 1'!B39","v":"Guadalajara ( c)"}]
[null,null,{"$f":"'Tabla 1'!B40","v":"Huejucar"}]
[null,null,{"$f":"'Tabla 1'!B41","v":"Lagos de Mor."}]
[null,null,{"$f":"'Tabla 1'!B42","v":"Ocotlán"}]
[null,null,{"$f":"'Tabla 1'!B43","v":"Puerto Vallarta"}]
[null,null,{"$f":"'Tabla 1'!B44","v":"Chapingo, Texc."}]
[null,null,{"$f":"'Tabla 1'!B45","v":"Toluca"}]
[null,null,{"$f":"'Tabla 1'!B46","v":"Morelia"}]
[null,null,{"$f":"'Tabla 1'!B47","v":"Lázaro Carden."}]
[null,null,{"$f":"'Tabla 1'!B48","v":"Uruapan"}]
[null,null,{"$f":"'Tabla 1'!B49","v":"Cuernavaca"}]
[null,null,{"$f":"'Tabla 1'!B50","v":"Cuautla"}]
[null,null,{"$f":"'Tabla 1'!B51","v":"Tepic"}]
[null,null,{"$f":"'Tabla 1'!B52","v":"Monterrey (d)"}]
[null,null,{"$f":"'Tabla 1'!B53","v":"Oaxaca"}]
[null,null,{"$f":"'Tabla 1'!B54","v":"Salina Cruz"}]
[null,null,{"$f":"'Tabla 1'!B55","v":"Puebla"}]
[null,null,{"$f":"'Tabla 1'!B56","v":"Atlixco"}]
[null,null,{"$f":"'Tabla 1'!B57","v":"Tehuacán"}]
[null,null,{"$f":"'Tabla 1'!B58","v":"Querétaro"}]
[null,null,{"$f":"'Tabla 1'!B59","v":"San Juan del Río"}]
[null,null,{"$f":"'Tabla 1'!B60","v":"Cozumel"}]
[null,null,{"$f":"'Tabla 1'!B61","v":"Chetumal"}]
[null,null,{"$f":"'Tabla 1'!B62","v":"Cancún"}]
[null,null,{"$f":"'Tabla 1'!B63","v":"Playa Carmen"}]
[null,null,{"$f":"'Tabla 1'!B64","v":"Río Verde"}]
[null,null,{"$f":"'Tabla 1'!B65","v":"San Luis Potosí"}]
[null,null,{"$f":"'Tabla 1'!B66","v":"Cd. Valles"}]
[null,null,{"$f":"'Tabla 1'!B67","v":"Matehuala"}]
[null,null,{"$f":"'Tabla 1'!B68","v":"Culiacán"}]
[null,null,{"$f":"'Tabla 1'!B69","v":"Mazatlán"}]
[null,null,{"$f":"'Tabla 1'!B70","v":"Guasave"}]
[null,null,{"$f":"'Tabla 1'!B71","v":"Mochis, Los"}]
[null,null,{"$f":"'Tabla 1'!B72","v":"Guaymas"}]
[null,null,{"$f":"'Tabla 1'!B73","v":"Hermosillo"}]
[null,null,{"$f":"'Tabla 1'!B74","v":"Obregón"}]
[null,null,{"$f":"'Tabla 1'!B75","v":"Navojoa"}]
[null,null,{"$f":"'Tabla 1'!B76","v":"Nogales"}]
[null,null,{"$f":"'Tabla 1'!B77","v":"Villahermosa"}]
[null,null,{"$f":"'Tabla 1'!B78","v":"Comalcalco"}]
[null,null,{"$f":"'Tabla 1'!B79","v":"Cd. Victoria"}]
[null,null,{"$f":"'Tabla 1'!B80","v":"Tampico"}]
[null,null,{"$f":"'Tabla 1'!B81","v":"Matamoros"}]
[null,null,{"$f":"'Tabla 1'!B82","v":"Reynosa"}]
[null,null,{"$f":"'Tabla 1'!B83","v":"Nuevo Laredo"}]
[null,null,{"$f":"'Tabla 1'!B84","v":"Tlaxcala"}]
[null,null,{"$f":"'Tabla 1'!B85","v":"Coatzacoalcos"}]
[null,null,{"$f":"'Tabla 1'!B86","v":"Córdoba"}]
[null,null,{"$f":"'Tabla 1'!B87","v":"Jalapa"}]
[null,null,{"$f":"'Tabla 1'!B88","v":"Orizaba"}]
[null,null,{"$f":"'Tabla 1'!B89","v":"Tuxpan"}]
[null,null,{"$f":"'Tabla 1'!B90","v":"Poza Rica"}]
[null,null,{"$f":"'Tabla 1'!B91","v":"Veracruz"}]
[null,null,{"$f":"'Tabla 1'!B92","v":"Mérida"}]
[null,null,{"$f":"'Tabla 1'!B93","v":"Progreso"}]
[null,null,{"$f":"'Tabla 1'!B94","v":"Valladolid"}]
[null,null,{"$f":"'Tabla 1'!B95","v":"Fresnillo"}]
[null,null,{"$f":"'Tabla 1'!B96","v":"Zacatecas"}]

{"sheet":"Hoja2","index":1,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[31,4,31,5],[3,3,3,9],[25,3,25,4],[27,4,27,5],[25,7,25,8],[27,8,27,9]]}
[]
[null,"2. Valores para el Cálculo de la ganancia de Calor a través de la Envolvente (*)"]
[]
[null,"2.1.","Ciudad ",{"$f":"Hoja1!E31","v":"Hermosillo"}]
[]
[null,null,"Latitud",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AD$96,27,FALSE)","v":29.9},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AD$96,28,FALSE)","v":-110.96}]
[]
[null,"2.2.","Temperatura equivalente promedio \"te\" (°C)"]
[]
[null,null,"a). Techo ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,7,FALSE)","v":48},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,5,FALSE)","v":25},"b). Superficie inferior",null,null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,6,FALSE)","v":33}]
[]
[null,null,"c). Muros",null,null,null,"d). Partes transparentes"]
[]
[null,null,null,"Masivo",null,"Ligero ",null,"Tragaluz y domo ",null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,16,FALSE)","v":28}]
[]
[null,null,"Norte",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,8,FALSE)","v":34},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,12,FALSE)","v":39},null,"Ventana",null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,17,FALSE)","v":29}]
[]
[null,null,"Este ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,9,FALSE)","v":38},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,13,FALSE)","v":43},null,null,null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,18,FALSE)","v":30}]
[]
[null,null,"Sur ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,10,FALSE)","v":35},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,14,FALSE)","v":41},null,null,null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,19,FALSE)","v":31}]
[]
[null,null,"Oeste",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,11,FALSE)","v":36},null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,15,FALSE)","v":43},null,null,null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,20,FALSE)","v":31}]
[]
[null,"2.3.","Coeficiente de transferencia de calor \"K\" del edificio de referecia (W/m2K)"]
[]
[null,null,"Techo ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,2,FALSE)","v":0.47599999999999998},null,null,"Muro ",{"$f":"IF(Hoja1!D62>3,VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,4,FALSE),VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,2,FALSE))","v":0.47599999999999998}]
[]
[null,null,"Tragaluz y domo ",null,5.952,null,null,"Ventana ",5.319]
[]
[null,"2.4.","Factor de ganancia de calor solar \"FG\" (W/m2K)"]
[]
[null,null,"Tragaluz y domo ",null,{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,21,FALSE)","v":322}]
[]
[null,null,"Norte",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,22,FALSE)","v":70}]
[]
[null,null,"Este ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,23,FALSE)","v":159}]
[]
[null,null,"Sur ",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,24,FALSE)","v":131}]
[]
[null,null,"Oeste",{"$f":"VLOOKUP($D$4,'Tabla 1'!$B$6:$AA$96,25,FALSE)","v":164}]
[]
[null,"2.5.","Barrera para vapor "]
[]
[null,null,"SI",null,null,"NO"]
[]
[null,"2.6.","Factor de corrección de sombreado exterior (SE)"]
[]
[null,null,"Número (**)",null,null,1,null,2,null,3,null,4]
[]
[null,null,"L/H o P/E (***)",{"$nulls":4},{"$f":"0.7/1.55","v":0.45161290322580638}]
[]
[null,null,"W/H o W/E (***)",{"$nulls":4},{"$f":"4.5/1.55","v":2.903225806451613}]
[]
[null,null,"Norte"]
[]
[null,null,"Este/Oeste"]
[]
[null,null,"Sur",{"$nulls":4},0.501]
[]
[null,null,"    * Los valores se optienen de la Tabla 1 para los incisos 2.2 a 2.5 y de la Tabla 2,3,4 y 5 para el inciso 2.6"]
[null,null,"  ** Si las ventanas tienen algun tipo de sombreado se deberá usar una columna para cada tipo "]
[null,null,"*** Indicar el tipo de sombreado: 1 volado simple, 2 volado extendido, 3 ventana remetida y 4 partesol "]

{"sheet":"Hoja3 (Muro Concreto)","index":2,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,2,24,3],[26,2,26,3],[28,2,28,3],[30,2,30,3],[3,5,3,7],[8,2,8,3],[9,2,9,3],[20,2,20,3],[22,2,22,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las porciones de la Envolvente(*)"]
[]
[null,"3.1.","Descripcion de la porción ",null,null,"Muro de concreto aparente",null,null,null,"Número(**)",1]
[]
[null,null,"Componente de la envolvente ",{"$nulls":4},"Techo ","X","Pared"]
[]
[]
[null,null,"Material ",null,null,"Espesor",null,"Conductividad ",null,"M"]
[{"$nulls":5},"(m) ",null,"térmica",null,"Aislamiento térmico"]
[{"$nulls":5},1,null,"(w/mK)",null,"(m2K/W)"]
[]
[null,null,"Convección exterior (*****)",null,null,1,null,13,null,{"$f":"F13/H13","v":7.6923076923076927E-2}]
[]
[null,null,"Concreto armado",null,null,0.12,null,1.74,null,{"$f":"F15/H15","v":6.8965517241379309E-2}]
[]
[null,null,"Mortero de cal al interior",null,null,0.01,null,0.69799999999999995,null,{"$f":"F17/H17","v":1.4326647564469915E-2}]
{"$rows_empty":15}
[null,null,"Convección interior",null,null,1,null,8.1,null,{"$f":"F33/H33","v":0.1234567901234568}]
[]
[null,null,"Para optener el aislamiento térmico total, sumar la M de todos",{"$nulls":5},"M",{"$f":"SUM(J13:J33)","v":0.28367203185238293},"m2K/W"]
[null,null," los materiales más la convección exterior e interior"]
[null,null,"[ Formula           M=",null,"S M]"]
[]
[null,null,"Coeficiente Global de transferencia de calor de la porción (k)",{"$nulls":5},"K",{"$f":" 1/J35","v":3.5251977203039155},"W/m2K"]
[null,null,"[ Formula          K=",null,"1/M]"]

{"sheet":"Hoja3 (Muro Concreto celular)","index":3,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[22,2,22,3],[24,2,24,3],[26,2,26,3],[28,2,28,3],[30,2,30,3],[20,2,20,3],[3,5,3,7],[8,2,8,3],[9,2,9,3],[14,2,14,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las porciones de la Envolvente(*)"]
[]
[null,"3.1.","Descripcion de la porción ",null,null,"Muro de concreto celular",null,null,null,"Número(**)",2]
[]
[null,null,"Componente de la envolvente ",{"$nulls":4},"Techo ","X","Pared"]
[]
[]
[null,null,"Material ",null,null,"Espesor",null,"Conductividad ",null,"M"]
[{"$nulls":5},"(m) ",null,"térmica",null,"Aislamiento térmico"]
[{"$nulls":5},1,null,"(w/mK)",null,"(m2K/W)"]
[]
[null,null,"Convección exterior (*****)",null,null,1,null,13,null,{"$f":"F13/H13","v":7.6923076923076927E-2}]
[]
[null,null,"Mortero de cal al exterior",null,null,0.01,null,0.872,null,{"$f":"F15/H15","v":1.1467889908256881E-2}]
[]
[null,null,"Bloque de concreto celular (densidad 500 kg/m2)",null,null,0.14000000000000001,null,0.19,null,{"$f":"F17/H17","v":0.73684210526315796}]
[]
[null,null,"Mortero de cal al interior",null,null,0.01,null,0.69799999999999995,null,{"$f":"F19/H19","v":1.4326647564469915E-2}]
{"$rows_empty":13}
[null,null,"Convección interior",null,null,1,null,8.1,null,{"$f":"F33/H33","v":0.1234567901234568}]
[]
[null,null,"Para optener el aislamiento térmico total, sumar la M de todos",{"$nulls":5},"M",{"$f":"SUM(J13:J33)","v":0.96301650978241848},"m2K/W"]
[null,null," los materiales más la convección exterior e interior"]
[null,null,"[ Formula           M=",null,"S M]"]
[]
[null,null,"Coeficiente Global de transferencia de calor de la porción (k)",{"$nulls":5},"K",{"$f":" 1/J35","v":1.0384037966555084},"W/m2K"]
[null,null,"[ Formula          K=",null,"1/M]"]

{"sheet":"Hoja3 (Puerta)","index":4,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,2,26,3],[28,2,28,3],[22,2,22,3],[30,2,30,3],[3,5,3,7],[8,2,8,3],[9,2,9,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[20,2,20,3],[24,2,24,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las porciones de la Envolvente(*)"]
[]
[null,"3.1.","Descripcion de la porción ",null,null,"Puerta exterior",null,null,null,"Número(**)",3]
[]
[null,null,"Componente de la envolvente ",{"$nulls":4},"Techo ","X","Pared"]
[]
[]
[null,null,"Material ",null,null,"Espesor",null,"Conductividad ",null,"M"]
[{"$nulls":5},"(m) ",null,"térmica",null,"Aislamiento térmico"]
[{"$nulls":5},1,null,"(w/mK)",null,"(m2K/W)"]
[]
[null,null,"Convección exterior (*****)",null,null,1,null,13,null,{"$f":"F13/H13","v":7.6923076923076927E-2}]
[]
[null,null,"Madera blanda",null,null,3.5999999999999997E-2,null,0.13,null,{"$f":"F15/H15","v":0.27692307692307688}]
{"$rows_empty":17}
[null,null,"Convección interior",null,null,1,null,8.1,null,{"$f":"F33/H33","v":0.1234567901234568}]
[]
[null,null,"Para optener el aislamiento térmico total, sumar la M de todos",{"$nulls":5},"M",{"$f":"SUM(J13:J33)","v":0.47730294396961059},"m2K/W"]
[null,null," los materiales más la convección exterior e interior"]
[null,null,"[ Formula           M=",null,"S M]"]
[]
[null,null,"Coeficiente Global de transferencia de calor de la porción (k)",{"$nulls":5},"K",{"$f":" 1/J35","v":2.0951054516514129},"W/m2K"]
[null,null,"[ Formula          K=",null,"1/M]"]

{"sheet":"Hoja3 (Losa)","index":5,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,2,26,3],[28,2,28,3],[22,2,22,3],[30,2,30,3],[3,5,3,7],[8,2,8,3],[9,2,9,3],[18,2,18,3],[24,2,24,3],[23,2,23,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las porciones de la Envolvente(*)"]
[]
[null,"3.1.","Descripcion de la porción ",null,null,"Losa plana de concreto aislada",null,null,null,"Número(**)",4]
[]
[null,null,"Componente de la envolvente ",null,null,null,"X","Techo ",null,"Pared"]
[]
[]
[null,null,"Material ",null,null,"Espesor",null,"Conductividad ",null,"M"]
[{"$nulls":5},"(m) ",null,"térmica",null,"Aislamiento térmico"]
[{"$nulls":5},1,null,"(w/mK)",null,"(m2K/W)"]
[]
[null,null,"Convección exterior (*****)",null,null,1,null,13,null,{"$f":"F13/H13","v":7.6923076923076927E-2}]
[]
[null,null,"Losa de concreto armado",null,null,0.15,null,1.74,null,{"$f":"F15/H15","v":8.620689655172413E-2}]
[]
[null,null,"Aislante térmico certificado (NOM-018)",null,null,3.7999999999999999E-2,null,0.04,null,{"$f":"F17/H17","v":0.95}]
[]
[null,null,"Mortero de cal al exterior",null,null,1.7000000000000001E-2,null,0.872,null,{"$f":"F19/H19","v":1.9495412844036698E-2}]
[]
[]
[]
[]
[]
[null,null,"Losa de concreto armado",null,null,0.1,null,1.74,null,{"$f":"F25/H25","v":5.7471264367816098E-2}]
{"$rows_empty":7}
[null,null,"Convección interior",null,null,1,null,9.4,null,{"$f":"F33/H33","v":0.10638297872340426}]
[]
[null,null,"Para optener el aislamiento térmico total, sumar la M de todos",{"$nulls":5},"M",{"$f":"J13+J15+J17+J19+J33","v":1.2390083650422421},"m2K/W"]
[null,null," los materiales más la convección exterior e interior"]
[null,null,"[ Formula           M=",null,"S M]"]
[]
[null,null,"Coeficiente Global de transferencia de calor de la porción (k)",{"$nulls":5},"K",{"$f":" 1/J35","v":0.80709705294516432},"W/m2K"]
[null,null,"[ Formula          K=",null,"1/M]"]

{"sheet":"Superficie No Homogénea 1 techo","index":6,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[138,2,138,3],[114,2,114,3],[115,2,115,3],[120,2,120,3],[122,2,122,3],[124,2,124,3],[126,2,126,3],[128,2,128,3],[130,2,130,3],[132,2,132,3],[134,2,134,3],[136,2,136,3],[4,4,4,6],[109,5,109,7],[56,5,56,7],[61,2,61,3],[62,2,62,3],[67,2,67,3],[69,2,69,3],[73,2,73,3],[75,2,75,3],[77,2,77,3],[79,2,79,3],[81,2,81,3],[83,2,83,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las Porciones de la Envolvente (*)"]
[null,"(Háganse tantas hojas como porciones diferentes de la envolvente se tengan) "]
[]
[null,"3.1. ","Descripción de la Porción No Homogénea (a)",null,"losa de vigueta y bovedilla",null,null,null,"Número (**) ",5]
[]
[null,null,"Componente de la envolvente ",null,null,"X","Techo ",null,"Pared"]
[]
[null,null,"Área de la componente en m2 (A)",null,{"$f":"G9*I9","v":0.11},"=",0.11,"x",1]
[]
[]
[null,null,"Área que ocupa la componente no homogénea 1",null,null,null,{"$f":"(G9-G16)*I9","v":9.2399999999999996E-2}]
[]
[null,null,"Fracción de la combinación (F1) (b)",null,{"$f":"G12/E9","v":0.84}]
[]
[null,null,"Área que ocupa la componente no homogénea 2",null,null,null,{"$f":"(0.11*0.16)","v":1.7600000000000001E-2}]
[]
[null,null,"Fracción de la combinación (F2)",null,{"$f":"1-E14","v":0.16000000000000003}]
[]
[]
[null,"3.2.","Aislamiento térmico parcial "]
[]
[null,null,"Material ",null,"Espesor",null,"Conductividad ",null,"M"]
[null,null,"(***)",null,"(m) ",null,"térmica",null,"Aislamiento térmico"]
[{"$nulls":4},1,null,"(w/mK)",null,"(m2K/W)"]
[]
[null,null,"Convección exterior (*****)",null,1,null,13,null,{"$f":"E27/G27","v":7.6923076923076927E-2}]
[]
[null,null,"Impermeabilizante",null,2E-3,null,0.17,null,{"$f":"E29/G29","v":1.1764705882352941E-2}]
[]
[null,null,"Concreto armado",null,0.05,null,1.74,null,{"$f":"E31/G31","v":2.8735632183908049E-2},null,null,null,0.11,100]
[]
[null,null,"Material aislante certificado (NOM-018)",null,3.7999999999999999E-2,null,0.04,null,{"$f":"E33/G33","v":0.95},null,null,null,{"$f":"(N33*M31)/N31","v":1.7600000000000001E-2},16]
[]
[null,null,"Yeso al Interior",null,5.0000000000000001E-3,null,0.372,null,{"$f":"E35/G35","v":1.3440860215053764E-2}]
[]
[{"$nulls":12},0.11]
[]
[null,null,"Convección interior",null,1,null,6.6,null,{"$f":"E39/G39","v":0.15151515151515152}]
[]
[null,"Para optener el aislamiento térmico total, sumar la M de ",{"$nulls":5},"M parcial ",{"$f":"SUM(I27:I39)","v":1.2323794267195431},"m2K/W"]
[null,"todos los materiales más la convección exterior e interior"]
[]
[null,null,"[ Formula  Mparcial = S M ]"]
[]
[null,"*","Estos valores se obtienen en el Apéndice D de la NOM-020-ENER-2011"]
[null,"**","Dar un número consecutivo (1,2…N) el cual será indicado en el inciso 4.3"]
[null,"***","Anotar los materiales que forman la porción homogénea. Por ejemplo, en un muro estructurado formado por: madera"]
[null,null,"con triplay y mortero en la superficie exterior, tablero de yeso en la superficie interior y entre ambos una estructura"]
[null,null,"de madera con polines verticales y aislantes térmicos. Solo se deben poner los que forman la superficie exterior e "]
[null,null,"interior, que es la porción homogénea. Véase apéndice B, inciso B.2 de la Norma "]
[null,"****","Para los materiales se utilizan valores del apéndice D de la NOM-020-ENER, o los proporcionados por los fabricantes"]
[null,"*****","Para la convección exterior e interior se utilizan los valores de L1, calculados de acuerdo al apéndice \"B\""]
[null,"(a)","Veáse apéndice B inciso B.2 de la Norma"]
[null,"(b)","El número de fracciones depende del número de materiales que se quieren colocar en la superficie exterior e interior"]

{"sheet":"Superficie No Homogénea 2 techo","index":7,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[123,2,123,3],[99,2,99,3],[100,2,100,3],[105,2,105,3],[107,2,107,3],[109,2,109,3],[111,2,111,3],[113,2,113,3],[115,2,115,3],[117,2,117,3],[119,2,119,3],[121,2,121,3],[94,5,94,7],[41,5,41,7],[46,2,46,3],[47,2,47,3],[52,2,52,3],[54,2,54,3],[58,2,58,3],[60,2,60,3],[62,2,62,3],[64,2,64,3],[66,2,66,3],[68,2,68,3]]}
[]
[null,"3. Cálculo del Coeficiente Global de Transferencia de Calor de las Porciones de la Envolvente (*)"]
[null,"(Háganse tantas hojas como porciones diferentes de la envolvente se tengan) "]
[]
[null,3.3,"Aislamiento Térmico parcial (Mparcial)",{"$nulls":5},{"$f":"'Superficie No Homogénea 1 techo'!I41","v":1.2323794267195431}]
[]
[null,null,"Fracción",null,"Material",null,"Grueso  (m)",null,"Conductividad ",null,"g/"]
[null,null,"(F)",null,"(***)",null,"g",null,"térmica"]
[{"$nulls":6},"(****)",null,"(w/mK)"]
[]
[null,"F1",0.84,null,"Material aislante certificado (NOM-018)",null,0.11,null,0.04,null,{"$f":"G11/I11","v":2.75}]
[]
[{"$nulls":10},{"$f":"SUM(K11:K12)","v":2.75}]
[]
[{"$nulls":12},{"$f":"C11/(I5+K13)","v":0.21092917323850882}]
[]
[null,"F2",0.16,null,"Concreto armado",null,{"$f":"G11","v":0.11},null,1.74,null,{"$f":"G17/I17","v":6.3218390804597707E-2}]
[]
[]
[{"$nulls":10},{"$f":"SUM(K17:K19)","v":6.3218390804597707E-2}]
[]
[{"$nulls":12},{"$f":"C17/(I5+K20)","v":0.12349511386624323}]
[]
[]
[{"$nulls":6},{"$f":"M15+M22","v":0.33442428710475203}]
[]
[]
[]
[{"$nulls":7},"M=",{"$f":"1/G25","v":2.9902134460909209}]
[]
[]
[]
[]
[null,"Coeficiente global de transferencia de calor de la porción (k) "]
[]
[{"$nulls":4},"[ Formula  K = 1/M ]",null,null,null,{"$f":"1/I29","v":0.33442428710475203}]
[]
[null,"*****","Para la convección exterior e interior se utilizan los valores de L1, calculados de acuerdo al apéndice \"B\""]
[null,"(a)","Veáse apéndice B inciso B.2 de la norma"]
[null,"(b)","El número de fracciones depende del numero de materiales que se quieren colocar en la superficie exterior e interior"]

{"sheet":"Edif.REF","index":8,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[35,9,35,10],[57,9,57,10],[13,6,15,6],[17,6,19,6],[29,6,31,6],[25,6,27,6],[21,6,23,6]]}
[]
[null,"4. Cálculo Comparativo de la Ganancia de Calor "]
[]
[null,4.0999999999999996,"Edificio de referencia"]
[]
[null,"4.1.1. ","Ganancias por conducción (partes opacas y transparentes)"]
[]
[null,null,"Tipo y orientacion",null,"Tranferencia",null,"Area del ",null,"Fracción de la ",null,"Temp.",null,"Temp.",null,"Ganancia por "]
[null,null,"de la porcion de ",null,"de Calor ",null,"edificio ",null,"componente",null,"equivalente",null,"Interior",null,"Conducción "]
[null,null,"la envolvente",null,"(W/m2K)",null,"proyectado",null,"[F]",null,"(te)",null,"(t)",null,"[K*A*F*(te-t)]"]
[{"$nulls":4},"[K]",null,"(m2)"]
[{"$nulls":6},"[A]"]
[]
[null,null,"Techo",null,{"$f":"Hoja2!D26","v":0.47599999999999998},null,{"$f":"Hoja1!D64","v":56.7},null,1,null,{"$f":"Hoja2!D10","v":48},null,{"$f":"Hoja2!F10","v":25},null,{"$f":"(E14*G14*I14*(K14-M14))","v":620.75160000000005}]
[]
[null,null,"Tragaluz y domo",null,{"$f":"Hoja2!E28","v":5.952},null,null,null,0,null,{"$f":"Hoja2!J14","v":28},null,{"$f":"M14","v":25},null,{"$f":"(E16*G14*I16*(K16-M16))","v":0}]
[]
[null,null,"Muro Norte",null,{"$f":"Hoja2!H26","v":0.47599999999999998},null,{"$f":"Hoja1!D66","v":33},null,0.9,null,{"$f":"Hoja2!D16","v":34},null,{"$f":"M14","v":25},null,{"$f":"(E18*G18*I18*(K18-M18))","v":127.23479999999998}]
[]
[null,null,"Ventana Norte",null,{"$f":"Hoja2!I28","v":5.319},null,null,null,0.1,null,{"$f":"Hoja2!J16","v":29},null,{"$f":"M14","v":25},null,{"$f":"(E20*G18*I20*(K20-M20))","v":70.210799999999992}]
[]
[null,null,"Muro Este",null,{"$f":"Hoja2!H26","v":0.47599999999999998},null,{"$f":"Hoja1!D72","v":40.844999999999999},null,0.9,null,{"$f":"Hoja2!D18","v":38},null,{"$f":"M14","v":25},null,{"$f":"(E22*G22*I22*(K22-M22))","v":227.473974}]
[]
[null,null,"Ventana Este",null,{"$f":"Hoja2!I28","v":5.319},null,null,null,0.1,null,{"$f":"Hoja2!J18","v":30},null,{"$f":"M14","v":25},null,{"$f":"(E24*G22*I24*(K24-M24))","v":108.62727749999999}]
[]
[null,null,"Muro Sur",null,{"$f":"Hoja2!H26","v":0.47599999999999998},null,{"$f":"Hoja1!D78","v":33},null,0.9,null,{"$f":"Hoja2!D20","v":35},null,{"$f":"M14","v":25},null,{"$f":"(E26*G26*I26*(K26-M26))","v":141.37199999999999}]
[]
[null,null,"Ventana Sur ",null,{"$f":"Hoja2!I28","v":5.319},null,null,null,0.1,null,{"$f":"Hoja2!J20","v":31},null,{"$f":"M14","v":25},null,{"$f":"(E28*G26*I28*(K28-M28))","v":105.31619999999998}]
[]
[null,null,"Muro Oeste",null,{"$f":"Hoja2!H26","v":0.47599999999999998},null,{"$f":"Hoja1!D72","v":40.844999999999999},null,0.9,null,{"$f":"Hoja2!D22","v":36},null,{"$f":"M14","v":25},null,{"$f":"(E30*G30*I30*(K30-M30))","v":192.47797799999998}]
[]
[null,null,"Ventana Oeste",null,{"$f":"Hoja2!I28","v":5.319},null,null,null,0.1,null,{"$f":"Hoja2!J22","v":31},null,{"$f":"M14","v":25},null,{"$f":"(E32*G30*I32*(K32-M32))","v":130.352733}]
[]
[null,null,"Techo (sup. Inf)",null,{"$f":"Hoja2!D26","v":0.47599999999999998},null,{"$f":"Hoja1!N90","v":7.1999999999999993},null,1,null,{"$f":"Hoja2!J10","v":33},null,{"$f":"M14","v":25},null,{"$f":"(E34*G34*I34*(K34-M34))","v":27.417599999999997}]
[]
[null,"* Nota: Si los valores son negativos significa una bonificación , ",{"$nulls":7},"SUBTOTAL",{"$nulls":4},{"$f":"SUM(O14:O34)","v":1751.2349624999999}]
[null,null,"por lo que deben sumarse algebraicamente"]
[]
[]
[null,"4.1.2. ","Ganancias por radiación (partes transparentes)"]
[]
[null,null,"Tipo y orientacion",null,"Coeficiente",null,"Area del ",null,"Fracción de la ",null,"Ganancia",null,"Ganancia por "]
[null,null,"de la porcion de ",null,"de",null,"edificio ",null,"componente",null,"de ",null,"Radiación "]
[null,null,"la envolvente",null,"Sombreado",null,"proyectado",null,"[F]",null,"Calor ",null,"f rs (*)"]
[{"$nulls":4},"(CS)",null,"(m2)",null,null,null,"(W/m2)",null,"[CS*A*F*FG]"]
[{"$nulls":6},"[A]",null,null,null,"[FG]"]
[]
[null,null,"Tragaluz y domo",null,1,null,{"$f":"G14","v":56.7},null,0,null,{"$f":"Hoja2!E32","v":322},null,{"$f":"E48*G48*I48*K48","v":0}]
[]
[null,null,"Ventana norte",null,1,null,{"$f":"G18","v":33},null,0.1,null,{"$f":"Hoja2!D34","v":70},null,{"$f":"E50*G50*I50*K50","v":231.00000000000003}]
[]
[null,null,"Ventana este",null,1,null,{"$f":"G22","v":40.844999999999999},null,0.1,null,{"$f":"Hoja2!D36","v":159},null,{"$f":"E52*G52*I52*K52","v":649.43550000000005}]
[]
[null,null,"Ventana sur",null,1,null,{"$f":"G26","v":33},null,0.1,null,{"$f":"Hoja2!D38","v":131},null,{"$f":"E54*G54*I54*K54","v":432.3}]
[]
[null,null,"Ventana oeste",null,1,null,{"$f":"G30","v":40.844999999999999},null,0.1,null,{"$f":"Hoja2!D40","v":164},null,{"$f":"E56*G56*I56*K56","v":669.85800000000006}]
[]
[{"$nulls":9},"SUBTOTAL",null,null,{"$f":"SUM(M48:M56)","v":1982.5934999999999}]

{"sheet":"Edif. PROY conducc ","index":9,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[8,3,8,7],[63,8,63,11]]}
[]
[null,"4. Cálculo Comparativo de la Ganancia de Calor (continuación)"]
[]
[null,4.2,"Edificio proyectado"]
[]
[null,"4.2.1. ","Ganancias por conducción (partes opacas y transparentes)"]
[]
[null,null,"Tipo y orientacion",null,"Coeficiente Global de ",null,null,null,"Area del edificio",null,"Temp.",null,"Temp.",null,"Ganancia por "]
[null,null,"de la porcion de ","Transferencia de Calor (k)",{"$nulls":4},"proyectado",null,"equivalente",null,"Interior",null,"Conducción "]
[null,null,"la envolvente",null,"N° de ",null,"Valor calculado",null,"(m2)",null,"(°C)",null,"(°C)",null,"f pc(****)"]
[null,null,"(*)",null,"porción ",null,"(W/m2K)",null,"[A]",null,"[te]",null,"[t]",null,"[K*A*(te-t)]"]
[{"$nulls":4},"(**)",null,"(***)"]
[{"$nulls":12},"Subtotal 1"]
[]
[{"$nulls":12},"Subtotal 2"]
[]
[{"$nulls":12},"Subtotal 3"]
[]
[null,null,"T1_Techo ",null,{"$f":"'Superficie No Homogénea 1 techo'!J5","v":5},null,{"$f":"'Superficie No Homogénea 2 techo'!I36","v":0.33442428710475203},null,{"$f":"Hoja1!N64-Hoja1!D100","v":37.288800000000002},null,{"$f":"Hoja2!D10","v":48},null,{"$f":"Hoja2!F10","v":25},null,{"$f":"(G19*I19*(K19-M19))","v":286.81644821080857}]
[]
[null,null,"D1_Domos ",null,"6*",null,2.27,null,{"$f":"Hoja1!D100","v":1.4111999999999998},null,{"$f":"Hoja2!J14","v":28},null,{"$f":"M19","v":25},null,{"$f":"(G21*I21*(K21-M21))","v":9.6102719999999984}]
[]
[null,null,"T2_Techo ",null,{"$f":"'Superficie No Homogénea 1 techo'!J5","v":5},null,{"$f":"'Superficie No Homogénea 2 techo'!I36","v":0.33442428710475203},null,{"$f":"Hoja1!Q64","v":18},null,{"$f":"Hoja2!D10","v":48},null,{"$f":"M19","v":25},null,{"$f":"(G23*I23*(K23-M23))","v":138.45165486136733}]
[]
[null,null,"SI_Superficie inferior",null,{"$f":"'Hoja3 (Losa)'!K4","v":4},null,{"$f":"'Hoja3 (Losa)'!J39","v":0.80709705294516432},null,{"$f":"Hoja1!N90","v":7.1999999999999993},null,{"$f":"Hoja2!J10","v":33},null,{"$f":"M19","v":25},null,{"$f":"(G25*I25*(K25-M25))","v":46.488790249641461}]
[]
[null,null,"MN_Muro Norte ",null,{"$f":"'Hoja3 (Muro Concreto celular)'!K4","v":2},null,{"$f":"'Hoja3 (Muro Concreto celular)'!J39","v":1.0384037966555084},null,{"$f":"Hoja1!D66-I29-I31","v":24.477899999999998},null,{"$f":"Hoja2!D16","v":34},null,{"$f":"M19","v":25},null,{"$f":"(G27*I27*(K27-M27))","v":228.7614986473848}]
[]
[null,null,"VN_Ventana Norte",null,"6*",null,2.27,null,{"$f":"Hoja1!D92","v":6.8421000000000003},null,{"$f":"Hoja2!J16","v":29},null,{"$f":"M19","v":25},null,{"$f":"(G29*I29*(K29-M29))","v":62.126268000000003}]
[]
[null,null,"PN_Puerta Norte",null,{"$f":"'Hoja3 (Puerta)'!K4","v":3},null,{"$f":"'Hoja3 (Puerta)'!J39","v":2.0951054516514129},null,{"$f":"Hoja1!D70","v":1.68},null,{"$f":"Hoja2!F16","v":39},null,{"$f":"M19","v":25},null,{"$f":"(G31*I31*(K31-M31))","v":49.276880222841228}]
[]
[null,null,"ME_Muro Este ",null,{"$f":"'Hoja3 (Muro Concreto celular)'!K4","v":2},null,{"$f":"'Hoja3 (Muro Concreto celular)'!J39","v":1.0384037966555084},null,{"$f":"Hoja1!D72-Hoja1!D94","v":38.721499999999999},null,{"$f":"Hoja2!D18","v":38},null,{"$f":"M19","v":25},null,{"$f":"(G33*I33*(K33-M33))","v":522.71118395855149}]
[]
[null,null,"VE1_Ventana Este ",null,"6*",null,2.27,null,{"$f":"Hoja1!D94","v":2.1235000000000004},null,{"$f":"Hoja2!J18","v":30},null,{"$f":"M19","v":25},null,{"$f":"(G35*I35*(K35-M35))","v":24.101725000000002}]
[]
[null,null,"MS1_Muro Sur 1",null,{"$f":"'Hoja3 (Muro Concreto)'!K4","v":1},null,{"$f":"'Hoja3 (Muro Concreto)'!J39","v":3.5251977203039155},null,{"$f":"Hoja1!N78-Hoja1!N82","v":13.7},null,{"$f":"Hoja2!D20","v":35},null,{"$f":"M19","v":25},null,{"$f":"(G37*I37*(K37-M37))","v":482.95208768163639}]
[]
[null,null,"PS_Puerta Sur ",null,{"$f":"'Hoja3 (Puerta)'!K4","v":3},null,{"$f":"'Hoja3 (Puerta)'!J39","v":2.0951054516514129},null,{"$f":"Hoja1!N82","v":2.2000000000000002},null,{"$f":"Hoja2!F20","v":41},null,{"$f":"M19","v":25},null,{"$f":"(G39*I39*(K39-M39))","v":73.747711898129737}]
[]
[null,null,"MS2_Muro Sur 2",null,{"$f":"'Hoja3 (Muro Concreto celular)'!K4","v":2},null,{"$f":"'Hoja3 (Muro Concreto celular)'!J39","v":1.0384037966555084},null,{"$f":"Hoja1!Q78-I43","v":10.125},null,{"$f":"Hoja2!D20","v":35},null,{"$f":"M19","v":25},null,{"$f":"(G41*I41*(K41-M41))","v":105.13838441137023}]
[]
[null,null,"VS_Ventana Sur",null,"6*",null,2.27,null,{"$f":"Hoja1!Q80","v":6.9750000000000005},null,{"$f":"Hoja2!J20","v":31},null,{"$f":"M19","v":25},null,{"$f":"(G43*I43*(K43-M43))","v":94.999500000000012}]
[]
[null,null,"MO_Muro Oeste ",null,{"$f":"'Hoja3 (Muro Concreto celular)'!K4","v":2},null,{"$f":"'Hoja3 (Muro Concreto celular)'!J39","v":1.0384037966555084},null,{"$f":"Hoja1!D84-'Edif. PROY conducc '!I47","v":40.508400000000002},null,{"$f":"Hoja2!D22","v":36},null,{"$f":"M19","v":25},null,{"$f":"(G45*I45*(K45-M45))","v":462.70483992083996}]
[]
[null,null,"VO_Ventana Oeste ",null,"6*",null,2.27,null,{"$f":"Hoja1!D98","v":0.33660000000000001},null,{"$f":"Hoja2!J22","v":31},null,{"$f":"M19","v":25},null,{"$f":"(G47*I47*(K47-M47))","v":4.584492}]
{"$rows_empty":16}
[null,null,"* Desde certificado NOM-024-ENER-2012",{"$nulls":5},"Total ( Sumar todas las f pc)",{"$nulls":5},{"$f":"SUM(O19:O61)","v":2592.4717370625713}]

{"sheet":"Edf. PROY radiacion","index":10,"n_rows":42,"n_cols":17,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,12,5,14]]}
[]
[null,"4. Cálculo Comparativo de la Ganancia de Calor (continuación)"]
[]
[null,"4.2.2. ","Ganancias por radiación (partes transparentes)"]
[]
[null,null,"Tipo y orientacion",null,null,null,"Coeficiente",null,null,null,"Ganancia",null,"Factor de ",null,null,null,"Ganancia por "]
[null,null,"de la porcion de ",null,"Material",null,"de",null,"Area",null,"de ",null,null,"Sombreado ext.",null,null,"Radiación "]
[null,null,"la envolvente",null,"(**)",null,"Sombreado",null,"(m2)",null,"Calor ",null,null,"[SE]",null,null,"f pr"]
[null,null,"(*)",null,null,null,"(CS)",null,"[A]",null,"(W/m2)",null,null,"(****)",null,null,"[CS*A*FG*SE]"]
[{"$nulls":6},"(***)",null,null,null,"[FG]",null,"Numero",null,"Valor"]
[]
[null,null,"VN_Ventana Norte ",null,"Doble vidrio LowE certificado (NOM-024)",null,0.6,null,{"$f":"Hoja1!D92","v":6.8421000000000003},null,{"$f":"Hoja2!D34","v":70},null,1,null,1,null,{"$f":"G12*I12*K12*O12","v":287.3682}]
[]
[null,null,"VE_Ventana Este ",null,"Doble vidrio LowE certificado (NOM-024)",null,0.6,null,{"$f":"Hoja1!D94","v":2.1235000000000004},null,{"$f":"Hoja2!D36","v":159},null,1,null,1,null,{"$f":"G14*I14*K14*O14","v":202.58190000000005}]
[]
[null,null,"VS_Ventana Sur ",null,"Doble vidrio LowE certificado (NOM-024)",null,0.6,null,{"$f":"Hoja1!D96","v":6.9750000000000005},null,{"$f":"Hoja2!D38","v":131},null,{"$f":"Hoja2!H48","v":2},null,{"$f":"Hoja2!H58","v":0.501},null,{"$f":"G16*I16*K16*O16","v":274.66573499999998}]
[]
[null,null,"VO_Ventana Oeste ",null,"Doble vidrio LowE certificado (NOM-024)",null,0.6,null,{"$f":"Hoja1!D98","v":0.33660000000000001},null,{"$f":"Hoja2!D40","v":164},null,1,null,1,null,{"$f":"G18*I18*K18*O18","v":33.12144}]
[]
[null,null,"D1_Domos ",null,"Doble vidrio LowE certificado (NOM-024)",null,0.6,null,{"$f":"Hoja1!D100","v":1.4111999999999998},null,{"$f":"Hoja2!E32","v":322},null,1,null,1,null,272.64383999999995]
{"$rows_empty":21}
[{"$nulls":10},"Total ( Sumar todas las f pr)",{"$nulls":5},{"$f":"SUM(Q12:Q40)","v":1070.3811150000001}]

{"sheet":"Resumen","index":11,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,9,24,10],[5,8,11,8],[5,5,11,5]]}
[]
[null,"5. Resumen del Cálculo"]
[]
[null,"5.1. ","Presupuesto Enérgetico"]
[]
[{"$nulls":5},"Ganancia  por Conducción (W)",null,null,"Ganancia  por Radiación (W)",null,null,"Ganancia Total"]
[]
[{"$nulls":11},"f r = f rc + f rs"]
[]
[{"$nulls":11},"f p = f pc + f ps"]
[]
[{"$nulls":11},"(W)"]
[]
[null,null,"Referencia",null,"(f rc)",{"$f":"Edif.REF!O36","v":1751.2349624999999},null,"(f rs)",{"$f":"Edif.REF!M58","v":1982.5934999999999},null,"(f r)",{"$f":"F14+I14","v":3733.8284624999997}]
[]
[]
[]
[null,null,"Proyectado",null,"(f pc)",{"$f":"'Edif. PROY conducc '!O64","v":2592.4717370625713},null,"(f ps)",{"$f":"'Edf. PROY radiacion'!Q42","v":1070.3811150000001},null,"(f p)",{"$f":"F18+I18","v":3662.8528520625714}]
[]
[]
[]
[null,"5.2. ","Cumplimiento"]
[]
[]
[null,null,null,"Si ( f r > f p)",null,{"$f":"IF(L18<=L14,\"X\",\" \")","v":"X"},null,null,null,"No ( f r < f p)",null,{"$f":"IF(L18>L14,\"X\",\" \")","v":" "}]
{"$rows_empty":7}
[{"$nulls":11},"Ahorro de Energía"]
[{"$nulls":11},{"$f":"1-($L18/$L14)","v":1.9008803203001579E-2}]

{"sheet":"Etiqueta","index":12,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[29,12,30,12],[29,8,30,8],[29,7,30,7],[13,3,13,5],[7,2,7,14],[15,6,15,13],[16,6,16,13],[17,6,17,13],[14,3,14,5],[21,12,21,14],[23,12,23,14],[18,6,18,13],[19,6,19,13],[29,13,30,13],[29,10,30,10],[26,3,26,13],[6,2,6,14],[29,5,30,5],[29,6,30,6],[9,2,9,14],[25,3,25,13],[23,2,23,11],[21,2,21,11],[15,3,15,5],[16,3,16,5],[29,11,30,11],[17,3,17,5],[29,9,30,9],[29,3,30,3],[29,4,30,4],[13,6,13,13],[14,6,14,13],[31,3,31,8],[31,9,31,13],[41,2,43,14],[34,2,34,3],[34,4,34,8],[36,2,36,8],[36,9,36,14],[39,2,39,14]]}
[]
[]
[]
[]
[]
[]
[null,null,"EFICIENCIA ENERGETICA"]
[null,null,"Ganancia de Calor "]
[]
[null,null,"Determinada como se establece en la NOM -020-ENER-2011"]
[]
[null,null,"Ubicación de la Edificación "]
[]
[null,null,null,"Nombre",null,null,{"$f":"Hoja1!E25","v":"Casa aislada clima cálido"}]
[null,null,null,"Dirección",null,null,{"$f":"Hoja1!E27","v":0}]
[null,null,null,"Colonia",null,null,{"$f":"Hoja1!E29","v":0}]
[null,null,null,"Ciudad",null,null,{"$f":"Hoja1!E31","v":"Hermosillo"}]
[null,null,null,"Delegación:"]
[null,null,null,"Entidad Federativa",null,null,{"$f":"Hoja1!E33","v":"SONORA"}]
[null,null,null,"Codigo Postal "]
[]
[null,null,"Ganancia de Calor del Edificio de Referencia (Watts)",{"$nulls":9},{"$f":"Resumen!L14","v":3733.8284624999997}]
[]
[null,null,"Ganancia de Calor del Edificio Proyectado (Watts)",{"$nulls":9},{"$f":"Resumen!L18","v":3662.8528520625714}]
[]
[null,null,null,"Ahorro de Energía"]
[null,null,null,"Ahorro de Energía de este Edificio"]
[]
[]
[null,null,null,0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1]
[]
[null,null,null,"Menor Ahorro",{"$nulls":5},"Mayor Ahorro"]
[]
[]
[null,null,"Fecha "]
[]
[null,null,"Nombre y Clave de la Unidad de Verificación"]
[]
[]
[null,null,"Importante"]
[]
[null,null,"Cuando la ganancia de calor del edifico proyectado sea igual a la del edifico de referencia el ahorro sera del 0% y por lo tanto se cumple con la norma. La etiqueta no debe retirarse del edificio"]

{"sheet":"Tabla 1","index":13,"n_rows":102,"n_cols":31,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,0,4,0],[0,1,4,1],[0,2,2,4],[0,5,0,20],[0,21,0,25],[2,21,2,25],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,4,7],[0,26,4,26],[1,21,1,25],[3,16,4,16],[3,21,3,25],[1,5,1,15],[1,16,1,20],[2,5,2,20],[3,8,3,11],[3,12,3,15],[3,17,3,20],[43,0,44,0],[48,0,49,0],[52,0,53,0],[6,0,7,0],[8,0,10,0],[11,0,12,0],[13,0,16,0],[17,0,18,0],[19,0,23,0],[24,0,27,0],[29,0,30,0],[31,0,32,0],[33,0,35,0],[0,27,3,28],[0,29,4,29],[91,0,93,0],[94,0,95,0],[36,0,37,0],[71,0,75,0],[76,0,77,0],[78,0,82,0],[84,0,90,0],[54,0,56,0],[57,0,58,0],[59,0,62,0],[63,0,66,0],[67,0,70,0],[38,0,42,0],[45,0,47,0]]}
["ESTADO","CIUDAD","K de referencia (W/m2 K)",null,null,"CONDUCCIÓN",{"$nulls":15},"RADIACIÓN",{"$nulls":4},"Barrera para vapor","Posición geográfica",null,"Altitud"]
[{"$nulls":5},"OPACA",{"$nulls":10},"TRANSPARENTES",{"$nulls":4},"TRANSPARENTE"]
[{"$nulls":5},"Temperatura equivalente promedio te (°C)"]
[null,null,"Hasta tres niveles  Conjunto horizontal con muros compartidos","Más de tres niveles",null,"T interior","Superficie interior","Techo","Muro masivo",null,null,null,"Muro ligero",null,null,null,"Tragaluz y domo","Ventanas",null,null,null,"Factor de ganancia solar promedio                 FG (W/m2)",{"$nulls":8},"Estados"]
[null,null,"Techo y muro","Techo","Muro",null,null,null,"N","E","S","O","N","E","S","O",null,"N","E","S","O","Tragaluz y domo","N","E","S","O",null,"Latitud","Longitud"]
["AGUASCALIENTES","Aguascalientes",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,26,37,24,27,26,25,30,33,32,32,22,23,24,24,24,274,91,137,118,146,null,21.88,-102.29,1877,"AGUASCALIENTES"]
["BAJA CALIFORNIA SUR","La Paz",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,31,45,31,34,32,33,36,40,38,39,26,27,28,29,29,322,70,159,131,164,"Sí",24.15,-110.31,38,"BAJA_CALIFORNIA_SUR"]
[null,"Cabo S. Lucas",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,44,30,34,32,32,36,39,38,39,25,27,28,28,28,322,70,159,131,164,"Sí",22.89,-109.92,24,"BAJA_CALIFORNIA"]
["BAJA CALIFORNIA","Ensenada",0.90900000000000003,0.90900000000000003,0.90900000000000003,24,25,35,22,25,24,23,28,31,30,30,20,22,22,22,23,322,70,159,131,164,"Sí",20.55,-103.3,21,"CAMPECHE"]
[null,"Mexicali",0.47599999999999998,0.47599999999999998,0.55600000000000005,25,34,50,36,40,37,38,41,45,43,45,29,30,32,32,32,322,70,159,131,164,null,20.55,-103.31,5,"COAHUILA"]
[null,"Tijuana",0.71399999999999997,0.71399999999999997,0.90900000000000003,23,26,37,24,27,25,25,30,33,32,32,22,23,24,24,24,322,70,159,131,164,"Sí",20.55,-103.3,20,"COLIMA"]
["CAMPECHE","Campeche",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,36,40,38,40,26,27,29,29,29,284,95,152,119,133,"Sí",19.84,-90.52,6,"CHIAPAS"]
[null,"Cd. Carmen",0.52600000000000002,0.52600000000000002,0.625,25,31,46,32,35,33,33,37,41,39,40,26,28,29,29,29,284,95,152,119,133,"Sí",18.649999999999999,-91.83,3,"CHIHUAHUA"]
["COAHUILA","Monclova",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,34,32,33,36,40,38,39,26,27,28,29,29,322,70,159,131,164,null,26.91,-101.42,603,"D.F."]
[null,"Piedras Negras",0.52600000000000002,0.52600000000000002,0.625,25,31,46,32,35,33,33,37,41,39,40,26,28,29,29,29,322,70,159,131,164,"Sí",28.7,-100.53,225,"DURANGO"]
[null,"Saltillo",0.83299999999999996,0.83299999999999996,0.90900000000000003,25,27,38,25,28,26,26,30,34,33,33,22,24,24,24,25,322,70,159,131,164,null,25.43,-101,1582,"GUANAJUATO"]
[null,"Torreón",0.52600000000000002,0.52600000000000002,0.625,25,30,43,30,33,31,31,35,39,37,38,25,27,28,28,28,322,70,159,131,164,null,25.54,-103.41,1125,"GUERRERO"]
["COLIMA","Colima",0.55600000000000005,0.55600000000000005,0.90900000000000003,25,29,42,28,32,30,30,34,38,36,37,24,26,27,27,27,274,91,137,118,146,"Sí",19.239999999999998,-103.73,500,"HIDALGO"]
[null,"Manzanillo",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,34,32,33,36,40,38,40,26,27,28,29,29,274,91,137,118,146,"Sí",19.5,-104.32,11,"JALISCO"]
["CHIAPAS","Arriaga",0.52600000000000002,0.52600000000000002,0.625,25,31,46,32,35,33,33,37,41,39,40,26,28,29,29,29,272,102,140,114,134,"Sí",16.239999999999998,-93.9,62,"MÉXICO"]
[null,"Comitán",0.83299999999999996,0.83299999999999996,0.90900000000000003,23,25,35,22,24,24,23,28,31,30,30,20,22,22,22,23,272,102,140,114,134,null,16.239999999999998,-92.12,1586,"MICHOACAN"]
[null,"San Cristóbal",0.90900000000000003,0.90900000000000003,0.90900000000000003,23,22,31,19,20,20,20,25,27,27,26,18,20,20,20,20,272,102,140,114,134,null,16.739999999999998,-92.64,2133,"MORELOS"]
[null,"Tapachula",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,44,30,33,31,32,35,39,37,38,25,27,28,28,28,272,102,140,114,134,"Sí",14.9,-92.26,164,"NAYARIT"]
[null,"Tuxtla Gutiérrez",0.55600000000000005,0.55600000000000005,0.83299999999999996,25,29,42,29,32,30,30,34,38,36,37,24,26,27,27,27,272,102,140,114,134,"Sí",16.75,-93.12,539,"NUEVO_LEON"]
["CHIHUAHUA","Casas Grandes",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,28,40,27,30,28,28,32,35,34,35,23,25,25,26,26,322,70,159,131,164,null,30.38,-107.95,1474,"OAXACA"]
[null,"Chihuahua",0.625,0.625,0.90900000000000003,25,28,41,27,30,29,29,33,36,35,36,24,25,26,26,26,322,70,159,131,164,null,28.63,-106.8,1421,"PUEBLA"]
[null,"C. Juárez",0.625,0.625,0.83299999999999996,25,29,41,28,31,29,29,33,37,35,36,24,25,26,27,27,322,70,159,131,164,null,28.7,-106.1,1137,"QUERÉTARO"]
[null,"H. del Parral",0.83299999999999996,0.83299999999999996,0.90900000000000003,25,27,39,26,28,27,27,31,34,33,34,23,24,25,25,25,322,70,159,131,164,null,28.68,-106.1,1620,"QUINTANA_ROO"]
["D.F.","México (a)",0.90900000000000003,0.90900000000000003,0.90900000000000003,23,23,33,20,22,22,21,26,29,28,28,19,21,21,21,21,272,102,140,114,134,null,19.43,-99.13,2232,"SAN_LUIS_POTOSI"]
["DURANGO","Durango",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,26,37,24,27,25,25,30,33,32,32,22,23,24,24,24,322,70,159,131,164,null,24.3,-104.65,1888,"SINALOA"]
[null,"Lerdo",0.55600000000000005,0.55600000000000005,0.71399999999999997,25,30,43,29,33,31,31,35,39,37,38,25,26,27,28,28,322,70,159,131,164,null,25.54,-103.52,1138,"SONORA"]
["GUANAJUATO","Guanajuato",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,25,36,23,25,24,24,29,32,31,31,21,22,23,23,23,274,91,137,118,146,null,21.2,-101.26,2016,"TABASCO"]
[null,"León (b)",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,27,38,25,28,26,26,31,34,33,33,22,24,24,24,25,274,91,137,118,146,null,21.12,-101.68,1807,"TAMAULIPAS"]
["GUERRERO","Acapulco",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,36,41,39,40,26,28,29,29,29,274,91,137,118,146,"Sí",16.87,-99.89,93,"TLAXCALA"]
[null,"Chilpancingo",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,27,38,25,28,27,26,31,34,33,33,22,24,24,25,25,274,91,137,118,146,null,17.55,-99.5,1253,"VERACRUZ"]
[null,"Zihuatanejo",0.55600000000000005,0.55600000000000005,0.83299999999999996,25,29,42,29,32,30,30,34,38,36,37,25,26,27,27,27,274,91,137,118,146,"Sí",17.64,-101.55,14,"YUCATAN"]
["HIDALGO","Pachuca",0.90900000000000003,0.90900000000000003,0.90900000000000003,22,22,31,19,20,20,20,25,27,27,26,18,20,20,20,20,272,102,140,114,134,null,20.12,-98.75,2385,"ZACATECAS"]
[null,"Tulancingo",0.90900000000000003,0.90900000000000003,0.90900000000000003,23,23,32,19,21,21,20,25,28,27,27,19,20,20,20,21,272,102,140,114,134,null,20.8,-98.37,2160]
["JALISCO","Guadalajara ( c)",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,26,38,25,27,26,26,30,34,32,33,22,23,24,24,24,274,91,137,118,146,null,20.67,-103.34,1545]
[null,"Huejucar",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,26,38,25,27,26,26,30,34,32,33,22,23,24,24,24,274,91,137,118,146,null,20.69,-103.27,2000]
[null,"Lagos de Mor.",0.83299999999999996,0.83299999999999996,0.90900000000000003,23,26,37,24,26,25,25,29,33,32,32,21,23,23,24,24,274,91,137,118,146,null,21.36,-101.93,1884]
[null,"Ocotlán",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,27,38,25,28,26,26,30,34,33,33,22,24,24,24,25,274,91,137,118,146,null,20.350000000000001,-102.77,1533]
[null,"Puerto Vallarta",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,37,41,39,40,26,28,29,29,29,274,91,137,118,146,"Sí",20.62,-105.23,10]
["MÉXICO","Chapingo, Texc.",0.83299999999999996,0.83299999999999996,0.90900000000000003,23,23,32,20,22,22,21,26,29,28,28,19,21,21,21,21,274,91,137,118,146,null,20.49,-100.95,1740]
[null,"Toluca",0.90900000000000003,0.90900000000000003,0.90900000000000003,22,21,29,17,18,18,18,23,25,25,24,17,18,18,19,19,274,91,137,118,146,null,19.28,-99.65,2667]
["MCHOACAN","Morelia",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,25,35,23,25,24,24,28,31,30,30,21,22,23,23,23,274,91,137,118,146,null,19.7,-100.56,2087]
[null,"Lázaro Carden.",0.52600000000000002,0.52600000000000002,0.625,25,31,46,32,35,33,33,37,41,39,40,26,28,29,29,29,274,91,137,118,146,"Sí",19.399999999999999,-98.88,10]
[null,"Uruapan",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,25,35,23,25,24,24,28,31,30,30,21,22,23,23,23,274,91,137,118,146,null,19.420000000000002,-102.5,1626]
["MORELOS","Cuernavaca",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,27,39,26,28,27,27,31,34,33,34,22,24,25,25,25,274,91,137,118,146,null,18.93,-99.23,1558]
[null,"Cuautla",0.55600000000000005,0.55600000000000005,0.83299999999999996,25,29,41,28,31,29,29,33,37,35,36,24,25,26,26,27,274,91,137,118,146,null,18.809999999999999,-98.96,1301]
["NAYARIT","Tepic",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,27,39,26,29,27,27,31,35,34,34,23,24,25,25,25,274,91,137,118,146,"Sí",21.5,-104.89,930]
["NUEVO LEON","Monterrey (d)",0.55600000000000005,0.55600000000000005,0.71399999999999997,25,30,44,30,33,31,32,35,39,37,38,25,27,28,28,28,274,91,137,118,146,null,25.67,-100.3,529]
["OAXACA","Oaxaca",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,26,38,25,27,26,26,30,34,33,33,22,23,24,24,24,272,102,140,114,134,null,17.7,-96.75,1550]
[null,"Salina Cruz",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,31,46,32,36,33,34,37,41,39,41,26,28,29,29,29,272,102,140,114,134,"Sí",16.190000000000001,-95.19,94]
["PUEBLA","Puebla",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,24,34,21,23,23,22,27,30,29,29,20,21,22,22,22,272,102,140,114,134,null,19.399999999999999,-98.21,2150]
[null,"Atlixco",0.71399999999999997,0.71399999999999997,0.90900000000000003,23,25,35,23,25,24,24,28,31,30,30,21,22,23,23,23,272,102,140,114,134,null,18.899999999999999,-98.44,1841]
[null,"Tehuacán",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,25,35,23,25,24,24,28,31,31,31,21,22,23,23,23,272,102,140,114,134,null,18.47,-97.4,1647]
["QUERÉTARO","Querétaro",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,26,37,24,27,26,25,30,33,32,32,22,23,24,24,24,274,91,137,118,146,null,20.59,-100.39,1822]
[null,"San Juan del Río",0.83299999999999996,0.83299999999999996,0.90900000000000003,24,24,34,22,24,23,23,27,30,29,29,20,21,22,22,22,274,91,137,118,146,null,20.39,-99.98,1939]
["QUINTANA ROO","Cozumel",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,44,30,33,31,32,35,39,37,38,25,27,28,28,28,284,95,152,119,133,"Sí",20.43,-86.91,11]
[null,"Chetumal",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,34,32,32,36,40,38,39,26,27,28,29,29,284,95,152,119,133,"Sí",18.5,-88.3,16]
[null,"Cancún",0.52600000000000002,0.52600000000000002,0.625,25,31,46,32,35,33,34,37,41,39,40,26,28,29,29,29,284,95,152,119,133,"Sí",21.16,-86.84,12]
[null,"Playa Carmen",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,36,41,39,40,26,28,29,29,29,284,95,152,119,133,"Sí",20.63,-87.8,11]
["SAN LUIS POTOSI","Río Verde",0.55600000000000005,0.55600000000000005,0.90900000000000003,25,28,41,27,30,29,29,33,36,35,35,24,25,26,26,26,274,91,137,118,146,null,21.93,-99.99,996]
[null,"San Luis Potosí",0.83299999999999996,0.83299999999999996,0.90900000000000003,25,24,34,22,24,23,23,27,30,30,30,20,22,22,22,22,274,91,137,118,146,null,22.15,-100.98,1874]
[null,"Cd. Valles",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,31,45,32,35,33,33,37,41,39,40,26,28,29,29,29,274,91,137,118,146,"Sí",23,-99.1,88]
[null,"Matehuala",0.83299999999999996,0.83299999999999996,0.90900000000000003,25,27,39,25,28,27,27,31,34,33,34,22,24,25,25,25,274,91,137,118,146,null,23.65,-100.64,1588]
["SINALOA","Culiacán",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,31,46,32,36,33,34,37,41,39,41,27,28,29,29,29,322,70,159,131,164,"Sí",24.8,-107.39,68]
[null,"Mazatlán",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,34,32,33,36,40,38,39,26,27,28,29,29,322,70,159,131,164,"Sí",23.24,-106.41,10]
[null,"Guasave",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,32,47,33,36,34,34,38,42,40,41,27,28,30,30,30,322,70,159,131,164,"Sí",25.57,-108.47,17]
[null,"Mochis, Los",0.52600000000000002,0.52600000000000002,0.625,25,32,47,33,36,34,34,38,42,40,41,27,28,30,30,30,322,70,159,131,164,"Sí",25.8,-108.99,14]
["SONORA","Guaymas",0.47599999999999998,0.47599999999999998,0.55600000000000005,25,32,47,33,37,34,35,38,42,40,42,27,29,30,30,30,322,70,159,131,164,"Sí",27.91,-110.9,15]
[null,"Hermosillo",0.47599999999999998,0.47599999999999998,0.52600000000000002,25,33,48,34,38,35,36,39,43,41,43,28,29,30,31,31,322,70,159,131,164,null,29.9,-110.96,212]
[null,"Obregón",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,37,41,39,40,26,28,29,29,29,322,70,159,131,164,"Sí",27.49,-109.94,40]
[null,"Navojoa",0.52600000000000002,0.52600000000000002,0.52600000000000002,25,31,45,31,35,33,33,37,41,39,40,26,28,29,29,29,322,70,159,131,164,"Sí",27.7,-109.45,46]
[null,"Nogales",0.71399999999999997,0.71399999999999997,0.90900000000000003,25,28,40,27,30,28,28,32,36,35,35,23,25,26,26,26,322,70,159,131,164,null,31.3,-110.94,1220]
["TABASCO","Villahermosa",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,32,46,32,36,34,34,38,42,40,41,27,28,29,30,30,272,102,140,114,134,"Sí",17.989999999999998,-92.93,20]
[null,"Comalcalco",0.52600000000000002,0.52600000000000002,0.625,25,31,45,32,35,33,33,37,41,39,40,26,28,29,29,29,272,102,140,114,134,"Sí",18.260000000000002,-93.22,11]
["TAMAULIPAS","Cd. Victoria",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,33,33,36,40,38,40,26,27,29,29,29,272,102,140,114,134,null,23.74,-99.14,321]
[null,"Tampico",0.52600000000000002,0.52600000000000002,0.625,25,30,44,30,34,32,32,36,40,38,39,26,27,28,28,28,272,102,140,114,134,"Sí",22.25,-97.87,25]
[null,"Matamoros",0.55600000000000005,0.55600000000000005,0.83299999999999996,25,31,45,31,34,32,32,36,40,38,39,26,27,28,29,29,272,102,140,114,134,"Sí",22.23,-97.87,22]
[null,"Reynosa",0.55600000000000005,0.55600000000000005,0.625,25,31,46,32,35,33,34,37,41,39,40,26,28,29,29,29,272,102,140,114,134,null,26.7,-98.3,46]
[null,"Nuevo Laredo",0.52600000000000002,0.52600000000000002,0.55600000000000005,25,32,46,32,36,34,34,37,42,40,41,27,28,29,30,30,272,102,140,114,134,null,27.48,-99.51,130]
["TLAXCALA","Tlaxcala",0.90900000000000003,0.90900000000000003,0.90900000000000003,23,24,33,21,23,22,22,27,29,29,28,20,21,21,21,22,272,102,140,114,134,null,19.3,-98.24,2299]
["VERACRUZ","Coatzacoalcos",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,34,32,32,36,40,38,39,26,27,28,29,29,272,102,140,114,134,"Sí",18.14,-94.43,27]
[null,"Córdoba",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,27,38,25,28,27,27,31,34,33,33,22,24,24,25,25,272,102,140,114,134,null,18.89,-96.93,868]
[null,"Jalapa",0.71399999999999997,0.71399999999999997,0.90900000000000003,23,25,36,23,25,24,24,29,32,31,31,21,22,23,23,23,272,102,140,114,134,"Sí",19.54,-96.91,1550]
[null,"Orizaba",0.71399999999999997,0.71399999999999997,0.90900000000000003,24,26,37,24,26,25,25,29,33,32,32,21,23,23,24,24,272,102,140,114,134,null,18.850000000000001,-97.1,1241]
[null,"Tuxpan",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,43,30,33,31,31,35,39,37,38,25,27,28,28,28,272,102,140,114,134,"Sí",20.96,-97.4,21]
[null,"Poza Rica",0.52600000000000002,0.52600000000000002,0.625,25,31,45,31,35,32,33,36,40,38,40,26,27,29,29,29,272,102,140,114,134,"Sí",20.53,-97.45,64]
[null,"Veracruz",0.52600000000000002,0.52600000000000002,0.625,25,31,44,31,34,32,32,36,40,38,39,26,27,28,28,29,272,102,140,114,134,"Sí",20.51,-97.44,76]
["YUCATAN","Mérida",0.52600000000000002,0.52600000000000002,0.625,25,31,44,31,34,32,32,36,40,38,39,26,27,28,28,29,284,95,152,119,133,"Sí",20.97,-89.63,12]
[null,"Progreso",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,44,30,34,31,32,35,39,38,39,25,27,28,28,28,284,95,152,119,133,"Sí",21.28,-89.67,2]
[null,"Valladolid",0.52600000000000002,0.52600000000000002,0.71399999999999997,25,30,43,30,33,31,31,35,39,37,38,25,27,28,28,28,284,95,152,119,133,"Sí",20.69,-88.2,23]
["ZACATECAS","Fresnillo",0.83299999999999996,0.83299999999999996,0.90900000000000003,23,24,34,21,23,23,22,27,30,29,29,20,21,22,22,22,274,91,137,118,146,null,23.18,-102.87,2198]
[null,"Zacatecas",0.90900000000000003,0.90900000000000003,0.90900000000000003,22,24,34,21,23,23,22,27,30,29,29,20,21,22,22,22,274,91,137,118,146,null,22.77,-102.58,2481]
[]
[]
["( a ): Utilizar los mismos valores para los municipios conurbados del Estado de México que forman la Zona Metropolitana"]
["( b ): Utilizar los mismos valores para las ciudades de Celaya, Irapuato, Salamanca y Silao"]
["( c ): Utilizar los mismos valores para los municipios de: Tlaquepaque, Tonalá y Zapopan"]
["( d ): Utilizar los mismos valores para los municipios de: Apodaca, Garza García, Guadalupe, San Nicolás de los Garza y Santa Catarina"]