{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Principal","Matriz Aislada"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"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":"Principal","index":0,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[27,13,27,14],[49,13,49,14],[27,6,27,11],[49,6,49,11],[70,1,70,2],[51,7,55,9],[7,7,11,9],[10,1,10,2],[10,4,10,5],[11,1,11,2],[11,4,11,5],[9,1,9,2],[9,4,9,5],[13,7,13,9],[14,4,14,5],[24,4,24,5],[13,1,13,5],[20,7,20,9],[24,1,24,2],[20,1,20,2],[22,1,22,2],[2,13,2,16],[2,4,2,5],[3,4,3,5],[7,1,7,2],[8,1,8,2],[6,7,6,9],[6,1,6,5],[7,4,7,5],[8,4,8,5],[5,13,5,14],[5,6,5,11],[14,1,14,2],[15,1,15,2],[15,4,15,5],[16,1,16,2],[16,4,16,5],[22,4,22,5],[20,4,20,5],[17,1,17,2],[17,4,17,5],[18,1,18,2],[18,4,18,5],[35,1,35,5],[35,7,35,9],[36,1,36,2],[36,4,36,5],[37,1,37,2],[37,4,37,5],[28,1,28,5],[28,7,28,9],[29,1,29,2],[29,4,29,5],[29,7,33,9],[30,1,30,2],[30,4,30,5],[31,1,31,2],[31,4,31,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,4,33,5],[50,7,50,9],[42,1,42,2],[42,4,42,5],[42,7,42,9],[44,1,44,2],[44,4,44,5],[38,1,38,2],[38,4,38,5],[39,1,39,2],[39,4,39,5],[40,1,40,2],[40,4,40,5],[55,1,55,2],[55,4,55,5],[46,1,46,2],[46,4,46,5],[50,1,50,5],[51,1,51,2],[51,4,51,5],[52,1,52,2],[52,4,52,5],[53,1,53,2],[53,4,53,5],[68,1,68,2],[68,4,68,5],[64,1,64,2],[64,4,64,5],[64,7,64,9],[66,1,66,2],[66,4,66,5],[60,1,60,2],[60,4,60,5],[61,1,61,2],[61,4,61,5],[62,1,62,2],[62,4,62,5],[57,1,57,5],[57,7,57,9],[58,1,58,2],[58,4,58,5],[59,1,59,2],[59,4,59,5],[54,1,54,2],[54,4,54,5]]}
[]
[null,null,null,null,null,null,null,{"$f":"IF('Matriz Aislada'!H183=1,\"Favor de seleccionar una tarifa eléctrica\",IF('Matriz Aislada'!H183=2,\"La ciudad seleccionada no se encuentra en la tarifa \"&'Matriz Aislada'!F167,\"\"))","v":""}]
[null,"Tarifa:","Fachada Principal al:",null,"Ciudad:",null,null,"Estado:",null,"Valor K Requerido:",null,null,null,"Sistema Constructivo:"]
[null,"1C","Este",{"$f":"\"_\"&B4","v":"_1C"},"Cabo San Lucas",null,null,{"$f":"IF(E4=\"\",\"\",VLOOKUP(E4,Datos,2,0))","v":"Baja California Sur"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP(E4,'Matriz Aislada'!$A$132:$D$163,4,0))","v":0.71399999999999997},null,null,null,"Muro:",{"$f":"IF(E4=\"\",\"\",\"Block (15 cms)\")","v":"Block (15 cms)"},"Cubierta:",{"$f":"IF(E4=\"\",\"\",\"Vigueta y Bovedilla\")","v":"Vigueta y Bovedilla"}]
[null,{"$f":"VLOOKUP(E4,Ciudad,2,0)+VLOOKUP(C4,Orientacion,2,0)","v":12}]
[null,"Prototipo Aislada",null,null,"Número de viviendas: 1",null,"Reducción de barriles de petróleo (Día Critico):",null,null,null,null,null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AR$131,0))","v":0.27}]
[null,"Espesor de aislamiento (Poliestireno)",null,null,null,null,null,"Control Solar minimo requerido",null,null,null,{"$f":"VLOOKUP(E4,Ciudad,2,0)+1","v":11},null,"Fachada Principal ubicado al Norte",{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L7,Matriz,'Matriz Aislada'!$AE$131,0)-VLOOKUP(L7,Matriz,'Matriz Aislada'!$AB$131,0))","v":48.409999999999968}]
[null,"Cubierta (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!N131,0)=0,\"Sin aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!N131,0)))","v":1},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!X131,0))","v":"10 cm de remetimento en todas las ventanas de  F. Principal"},null,null,null,{"$f":"VLOOKUP(E4,Ciudad,2,0)+2","v":12},null,"Fachada Principal ubicado al Este",{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L8,Matriz,'Matriz Aislada'!$AE$131,0)-VLOOKUP(L8,Matriz,'Matriz Aislada'!$AB$131,0))","v":66.759999999999991}]
[null,"Muro Norte (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!O131,0)=0,\"Sin aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!O131,0)))","v":"Sin aislante"},null,null,null,null,null,null,{"$f":"VLOOKUP(E4,Ciudad,2,0)+3","v":13},null,"Fachada Principal ubicado al Sur",{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L9,Matriz,'Matriz Aislada'!$AE$131,0)-VLOOKUP(L9,Matriz,'Matriz Aislada'!$AB$131,0))","v":51.79000000000002}]
[null,"Muro Este (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!P131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!P131,0)))","v":1},null,null,null,null,null,null,{"$f":"VLOOKUP(E4,Ciudad,2,0)+4","v":14},null,"Fachada Principal ubicado al Oeste",{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L10,Matriz,'Matriz Aislada'!$AE$131,0)-VLOOKUP(L10,Matriz,'Matriz Aislada'!$AB$131,0))","v":62.28}]
[null,"Muro Sur (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!Q131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!Q131,0)))","v":"Sin Aislante"}]
[null,"Muro Oeste (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!R131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!R131,0)))","v":"Sin Aislante"}]
[]
[null,"Área con aislante (m2)",null,null,null,null,null,"Presupuesto Energético"]
[null,"Cubierta",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!S131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!S131,0)))","v":39.729999999999997},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[null,"Muro Norte",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!T131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!T131,0)))","v":"Sin Aislante"},null,null,"Conducción",null,"Conducción"]
[null,"Muro Este",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!U131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!U131,0)))","v":17.296600000000002},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!AC131,0)&\" Watts\")","v":"1629.15 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!L131,0)&\" Watts\")","v":"1201.12 Watts"}]
[null,"Muro Sur",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!V131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!V131,0)))","v":"Sin Aislante"},null,null,"Radiación",null,"Radiación"]
[null,"Muro Oeste",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(VLOOKUP($B$5,Matriz,'Matriz Aislada'!W131,0)=0,\"Sin Aislante\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!W131,0)))","v":"Sin Aislante"},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!AD131,0)&\" Watts\")","v":"536.86 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!M131,0)&\" Watts\")","v":"484.81 Watts"}]
[]
[null,"Costo de Aislamiento",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!Y131,0))","v":9705.0400000000009},null,null,"Presupuesto Energético Total"]
[]
[null,"Veces salario min. Diario",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!Z131,0)&\" VSMD\")","v":"139 VSMD"},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[]
[null,"Veces salario min. Mensuales",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!AA131,0)&\" VSMM\")","v":"5 VSMM"},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",(VLOOKUP($B$5,Matriz,'Matriz Aislada'!AC131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!AD131,0))&\" Watts\")","v":"2166.01 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",(VLOOKUP($B$5,Matriz,'Matriz Aislada'!L131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!M131,0))&\" Watts\")","v":"1685.93 Watts"}]
[]
[]
[null,"Prototipo Adosada",null,null,"Número de viviendas: 2",null,"Reducción de barriles de petróleo (Día Critico):",null,null,null,null,null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AS$131,0))","v":0.51}]
[null,"Espesor de aislamiento (Poliestireno)",null,null,null,null,null,"Control Solar minimo requerido",null,null,null,{"$f":"$L$7","v":11},null,{"$f":"$N$7","v":"Fachada Principal ubicado al Norte"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L29,Matriz,'Matriz Aislada'!$AK$131,0)-VLOOKUP(L29,Matriz,'Matriz Aislada'!$AH$131,0))","v":49.270000000000039}]
[null,"Cubierta (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D201,0))","v":1},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D206,0))","v":"18 cms de remetimiento en ventanas sin elementos sombreantes"},null,null,null,{"$f":"$L$8","v":12},null,{"$f":"$N$8","v":"Fachada Principal ubicado al Este"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L30,Matriz,'Matriz Aislada'!$AK$131,0)-VLOOKUP(L30,Matriz,'Matriz Aislada'!$AH$131,0))","v":125.05999999999995}]
[null,"Muro Norte (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D202,0))","v":"Sin Aislante"},null,null,null,null,null,null,{"$f":"$L$9","v":13},null,{"$f":"$N$9","v":"Fachada Principal ubicado al Sur"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L31,Matriz,'Matriz Aislada'!$AK$131,0)-VLOOKUP(L31,Matriz,'Matriz Aislada'!$AH$131,0))","v":71.550000000000011}]
[null,"Muro Este (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D203,0))","v":"Sin Aislante"},null,null,null,null,null,null,{"$f":"$L$10","v":14},null,{"$f":"$N$10","v":"Fachada Principal ubicado al Oeste"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L32,Matriz,'Matriz Aislada'!$AK$131,0)-VLOOKUP(L32,Matriz,'Matriz Aislada'!$AH$131,0))","v":134.83999999999997}]
[null,"Muro Sur (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D204,0))","v":"Sin Aislante"}]
[null,"Muro Oeste (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$200:$I$206,'Matriz Aislada'!D205,0))","v":1}]
[]
[null,"Área con aislante (m2)",null,null,null,null,null,"Presupuesto Energético"]
[null,"Cubierta",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$209:$I$214,'Matriz Aislada'!D210,0))","v":80.91},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[null,"Muro Norte",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$209:$I$214,'Matriz Aislada'!D211,0))","v":"Sin Aislante"},null,null,"Conducción",null,"Conducción"]
[null,"Muro Este",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$209:$I$214,'Matriz Aislada'!D212,0))","v":"Sin Aislante"},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AI$131,0),2)&\" Watts\")","v":"2975.07 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AF$131,0),2)&\" Watts\")","v":"2190.26 Watts"}]
[null,"Muro Sur",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$209:$I$214,'Matriz Aislada'!D213,0))","v":"Sin Aislante"},null,null,"Radiación",null,"Radiación"]
[null,"Muro Oeste",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$209:$I$214,'Matriz Aislada'!D214,0))","v":19.876000000000001},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AJ$131,0),2)&\" Watts\")","v":"1257.44 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AG$131,0),2)&\" Watts\")","v":"1142.96 Watts"}]
[]
[null,"Costo de Aislamiento",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(OR(C4=\"Este\",C4=\"Oeste\"),19252.18,5653.93))","v":19252.18},null,null,"Presupuesto Energético Total"]
[]
[null,"Veces salario min. Diario",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(E43*0.0143,0))","v":275},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[]
[null,"Veces salario min. Mensuales",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(E43*0.0005,0))","v":10},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND((VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AI$131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AJ$131,0)),2)&\" Watts\")","v":"4232.51 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND((VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AF$131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AG$131,0)),2)&\" Watts\")","v":"3333.22 Watts"}]
[]
[]
[null,"Prototipo Vertical",null,null,"Número de viviendas: 8",null,"Reducción de barriles de petróleo (Día Critico):",null,null,null,null,null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AT$131,0))","v":1.64}]
[null,"Espesor de aislamiento (Poliestireno)",null,null,null,null,null,"Control Solar minimo requerido",null,null,null,{"$f":"$L$7","v":11},null,{"$f":"$N$7","v":"Fachada Principal ubicado al Norte"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L51,Matriz,'Matriz Aislada'!$AQ$131,0)-VLOOKUP(L51,Matriz,'Matriz Aislada'!$AN$131,0))","v":197.84999999999991}]
[null,"Cubierta (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D192,0))","v":1},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D197,0))","v":"13 cms de remetimiento en todas las ventanas"},null,null,null,{"$f":"$L$8","v":12},null,{"$f":"$N$8","v":"Fachada Principal ubicado al Este"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L52,Matriz,'Matriz Aislada'!$AQ$131,0)-VLOOKUP(L52,Matriz,'Matriz Aislada'!$AN$131,0))","v":399.01999999999975}]
[null,"Muro Norte (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D193,0))","v":"Sin Aislante"},null,null,null,null,null,null,{"$f":"$L$9","v":13},null,{"$f":"$N$9","v":"Fachada Principal ubicado al Sur"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L53,Matriz,'Matriz Aislada'!$AQ$131,0)-VLOOKUP(L53,Matriz,'Matriz Aislada'!$AN$131,0))","v":205.97000000000003}]
[null,"Muro Este (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D194,0))","v":"Sin Aislante"},null,null,null,null,null,null,{"$f":"$L$10","v":14},null,{"$f":"$N$10","v":"Fachada Principal ubicado al Oeste"},{"$f":"IF(OR($B$4=\"\",$E$4=\"\",$C$4=\"\",'Matriz Aislada'!$G$183=0),\"\",VLOOKUP(L54,Matriz,'Matriz Aislada'!$AQ$131,0)-VLOOKUP(L54,Matriz,'Matriz Aislada'!$AN$131,0))","v":456.37999999999988}]
[null,"Muro Sur (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D195,0))","v":"Sin Aislante"}]
[null,"Muro Oeste (plg)",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$191:$I$197,'Matriz Aislada'!D196,0))","v":1}]
[]
[null,"Área con aislante (m2)",null,null,null,null,null,"Presupuesto Energético"]
[null,"Cubierta",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$217:$I$222,'Matriz Aislada'!D218,0))","v":87.27},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[null,"Muro Norte",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$217:$I$222,'Matriz Aislada'!D219,0))","v":"Sin Aislante"},null,null,"Conducción",null,"Conducción"]
[null,"Muro Este",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$217:$I$222,'Matriz Aislada'!D220,0))","v":"Sin Aislante"},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AO$131,0),2)&\" Watts\")","v":"9619.56 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AL$131,0),2)&\" Watts\")","v":"7764.04 Watts"}]
[null,"Muro Sur",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$217:$I$222,'Matriz Aislada'!D221,0))","v":"Sin Aislante"},null,null,"Radiación",null,"Radiación"]
[null,"Muro Oeste",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",HLOOKUP($C$4,'Matriz Aislada'!$D$217:$I$222,'Matriz Aislada'!D222,0))","v":121.4152},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AP$131,0),2)&\" Watts\")","v":"5208.62 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AM$131,0),2)&\" Watts\")","v":"4194.69 Watts"}]
[]
[null,"Costo de Aislamiento",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",IF(OR(C4=\"Este\",C4=\"Oeste\"),40197.01,20437.76))","v":40197.01},null,null,"Presupuesto Energético Total"]
[]
[null,"Veces salario min. Diario",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(E65*0.0143,0))","v":575},null,null,"Proyectado Base",null,"Proyectado Eficiente"]
[]
[null,"Veces salario min. Mensuales",null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND(E65*0.0005,0))","v":20},null,null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND((VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AO$131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AP$131,0)),2)&\" Watts\")","v":"14828.18 Watts"},null,{"$f":"IF(OR(B4=\"\",E4=\"\",C4=\"\",'Matriz Aislada'!G183=0),\"\",ROUND((VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AL$131,0)+VLOOKUP($B$5,Matriz,'Matriz Aislada'!$AM$131,0)),2)&\" Watts\")","v":"11958.73 Watts"}]
[]
[null,"Factores de Conversión:",null,null,"1 Tonelada de refrigeración: 3517 W, 1 Tonelada de refrigeración= 858 kWh, 1 kWh= 0.57 kgCO2, 1 Barril de petroleo= 428 kWh"]

{"sheet":"Matriz Aislada","index":1,"n_rows":222,"n_cols":46,"rows_kept":222,"cut":false,"hidden":true,"merged":[[215,5,215,8],[189,5,189,8],[198,5,198,8],[0,31,0,32],[0,34,0,35],[0,37,0,38],[0,40,0,41],[82,0,85,0],[86,0,89,0],[62,0,65,0],[66,0,69,0],[2,0,5,0],[14,0,17,0],[22,0,25,0],[26,0,29,0],[34,0,37,0],[82,7,85,7],[82,8,85,8],[86,1,89,1],[86,2,89,2],[86,4,89,4],[86,5,89,5],[86,6,89,6],[86,7,89,7],[34,1,37,1],[34,2,37,2],[34,4,37,4],[34,5,37,5],[34,6,37,6],[34,7,37,7],[34,8,37,8],[62,1,65,1],[62,2,65,2],[62,4,65,4],[62,5,65,5],[62,6,65,6],[62,7,65,7],[62,8,65,8],[42,1,45,1],[42,5,45,5],[42,4,45,4],[38,5,41,5],[38,4,41,4],[38,8,41,8],[38,7,41,7],[38,6,41,6],[42,8,45,8],[50,2,53,2],[22,1,25,1],[22,2,25,2],[22,4,25,4],[22,5,25,5],[22,6,25,6],[22,7,25,7],[22,8,25,8],[26,1,29,1],[26,2,29,2],[26,4,29,4],[26,5,29,5],[26,6,29,6],[26,7,29,7],[26,8,29,8],[2,1,5,1],[2,2,5,2],[2,4,5,4],[2,5,5,5],[2,6,5,6],[2,7,5,7],[2,8,5,8],[14,1,17,1],[14,2,17,2],[14,4,17,4],[14,5,17,5],[14,6,17,6],[14,7,17,7],[14,8,17,8],[126,8,129,8],[126,7,129,7],[126,6,129,6],[126,5,129,5],[126,4,129,4],[126,2,129,2],[126,0,129,0],[126,1,129,1],[122,8,125,8],[122,7,125,7],[122,6,125,6],[122,5,125,5],[122,4,125,4],[122,2,125,2],[122,0,125,0],[122,1,125,1],[118,4,121,4],[118,2,121,2],[118,0,121,0],[118,1,121,1],[18,2,21,2],[10,2,13,2],[6,2,9,2],[38,2,41,2],[30,2,33,2],[6,1,9,1],[18,1,21,1],[10,1,13,1],[18,0,21,0],[10,0,13,0],[6,0,9,0],[38,0,41,0],[30,0,33,0],[38,1,41,1],[30,1,33,1],[46,2,49,2],[46,0,49,0],[46,1,49,1],[42,2,45,2],[42,0,45,0],[82,1,85,1],[82,2,85,2],[0,23,1,23],[0,11,0,12],[0,7,0,8],[0,13,0,17],[0,18,0,22],[118,8,121,8],[118,7,121,7],[118,6,121,6],[118,5,121,5],[18,5,21,5],[50,5,53,5],[46,5,49,5],[18,7,21,7],[18,6,21,6],[30,8,33,8],[30,7,33,7],[30,6,33,6],[54,8,57,8],[54,7,57,7],[58,8,61,8],[58,7,61,7],[58,6,61,6],[50,0,53,0],[50,1,53,1],[74,2,77,2],[74,0,77,0],[74,1,77,1],[70,1,73,1],[70,2,73,2],[70,0,73,0],[58,2,61,2],[58,0,61,0],[58,1,61,1],[54,2,57,2],[54,0,57,0],[54,1,57,1],[66,1,69,1],[66,2,69,2],[110,2,113,2],[110,0,113,0],[110,1,113,1],[114,2,117,2],[114,0,117,0],[114,1,117,1],[78,2,81,2],[78,0,81,0],[78,1,81,1],[106,2,109,2],[106,0,109,0],[106,1,109,1],[94,2,97,2],[94,0,97,0],[94,1,97,1],[90,2,93,2],[90,0,93,0],[90,1,93,1],[102,2,105,2],[102,0,105,0],[102,1,105,1],[98,2,101,2],[98,0,101,0],[98,1,101,1],[66,7,69,7],[66,8,69,8],[30,5,33,5],[30,4,33,4],[6,8,9,8],[6,7,9,7],[6,6,9,6],[10,8,13,8],[10,7,13,7],[10,6,13,6],[10,5,13,5],[10,4,13,4],[6,5,9,5],[6,4,9,4],[46,8,49,8],[46,7,49,7],[42,7,45,7],[78,8,81,8],[78,7,81,7],[78,6,81,6],[78,5,81,5],[78,4,81,4],[90,8,93,8],[90,7,93,7],[42,6,45,6],[18,8,21,8],[18,4,21,4],[46,6,49,6],[50,8,53,8],[50,7,53,7],[50,6,53,6],[58,5,61,5],[58,4,61,4],[54,6,57,6],[54,5,57,5],[54,4,57,4],[46,4,49,4],[50,4,53,4],[66,4,69,4],[66,5,69,5],[66,6,69,6],[70,8,73,8],[70,7,73,7],[70,6,73,6],[70,5,73,5],[70,4,73,4],[74,8,77,8],[74,7,77,7],[74,6,77,6],[74,5,77,5],[74,4,77,4],[98,4,101,4],[102,8,105,8],[102,7,105,7],[102,6,105,6],[82,4,85,4],[82,5,85,5],[82,6,85,6],[106,7,109,7],[106,6,109,6],[106,5,109,5],[106,4,109,4],[94,8,97,8],[94,7,97,7],[94,6,97,6],[94,5,97,5],[94,4,97,4],[102,5,105,5],[102,4,105,4],[106,8,109,8],[86,8,89,8],[0,43,1,43],[0,44,1,44],[0,45,1,45],[207,5,207,8],[90,6,93,6],[90,5,93,5],[90,4,93,4],[0,28,0,29],[0,10,1,10],[0,0,0,6],[114,8,117,8],[114,7,117,7],[114,6,117,6],[114,5,117,5],[114,4,117,4],[110,5,113,5],[110,4,113,4],[110,6,113,6],[110,8,113,8],[110,7,113,7],[98,8,101,8],[98,7,101,7],[98,6,101,6],[98,5,101,5]]}
["Datos Generales",null,null,null,null,null,null,"Sistema Constructivo",null,null,"No.","Presupuesto energético (Edificio proyectado)",null,"Espesor de aislamiento (Poliestireno)",null,null,null,null,"Área con aislante en el edificio proyectado (m2)",null,null,null,null," Control Solar Mínimo requerido","Importe del aislamiento","Veces Salario Minimo Diario","Veces Salario Minimo Mensuales","Gases Efecto Invernadero","Presupuesto energético (Edificio proyectado)",null,"Gases Efecto Invernadero","Presupuesto energético (Edificio proyectado)",null,"Gases Efecto Invernadero","Presupuesto energético (Edificio proyectado)",null,"Gases Efecto Invernadero","Presupuesto energético (Edificio proyectado)",null,"Gases Efecto Invernadero","Presupuesto energético (Edificio proyectado)",null,"Gases Efecto Invernadero","Barriles de Petroleo (Aislada)","Barriles de Petroleo (Adosada)","Barriles de Petroleo (Vertical)"]
["Ciudad","Estado","Tarifa","Fachada principal al:","Tipo de Vivenda","No. Unidades","Valor K requerido (W/m2K)","Muros","Cubierta",null,null,"Conducción","Radiación","Cubierta (plg)","M. Norte (plg)","M. Este (plg)","M. Sur (plg)","M. Oeste (plg)","Cubierta","M. Norte","M. Este","M. Sur","Muro Oeste",null,"($)","(VSMD)","(VSMM)","(GEI)","Conducción","Radiación","(GEI)","Conducción","Radiación","(GEI)","Conducción","Radiación","(GEI)","Conducción","Radiación","(GEI)","Conducción","Radiación","(GEI)"]
["Cabo San Lucas","Baja California Sur","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A3,$F$132:$G$163,2,0)+VLOOKUP(D3,$H$132:$I$135,2,0)","v":11},1365.48,380.55,1.5,0,0,0,0,39.729999999999997,0,0,0,0,"10 cm de remetimento en todas las ventanas de  F. Principal",8430.31,{"$f":"ROUND(Y3*0.0143,0)","v":121},{"$f":"ROUND(Y3*0.0005,0)","v":4},{"$f":"ROUND(((SUM(L3:M3)/3517)*858)*0.57,2)","v":242.8},1682.6,411.61,{"$f":"ROUND(((SUM(AC3:AD3)/3517)*858)*0.57,2)","v":291.20999999999998},2747.0434799999998,681.13,{"$f":"ROUND(((SUM(AF3:AG3)/3517)*858)*0.57,2)","v":476.71},3040.6348159999998,741.86,{"$f":"ROUND(((SUM(AI3:AJ3)/3517)*858)*0.57,2)","v":525.98},8582.8646480000007,2410.1799999999998,{"$f":"ROUND(((SUM(AL3:AM3)/3517)*858)*0.57,2)","v":1528.65},9370.0000560000008,3045.87,{"$f":"ROUND(((SUM(AO3:AP3)/3517)*858)*0.57,2)","v":1726.5},{"$f":"ROUND((((SUM(AC3:AD3)-SUM(L3:M3))/3517)*858)/428,2)","v":0.2},{"$f":"ROUND((((SUM(AI3:AJ3)-SUM(AF3:AG3))/3517)*858)/428,2)","v":0.2},{"$f":"ROUND((((SUM(AO3:AP3)-SUM(AL3:AM3))/3517)*858)/428,2)","v":0.81}]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A3,$F$132:$G$163,2,0)+VLOOKUP(D4,$H$132:$I$135,2,0)","v":12},1201.1199999999999,484.81,1,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"10 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,234.44,1629.15,536.86,301.2,2190.2645199999997,1142.96,{"$f":"ROUND(((SUM(AF4:AG4)/3517)*858)*0.57,2)","v":463.5},2975.07132,1257.44,{"$f":"ROUND(((SUM(AI4:AJ4)/3517)*858)*0.57,2)","v":588.55999999999995},7764.0403999999999,4194.6899999999996,{"$f":"ROUND(((SUM(AL4:AM4)/3517)*858)*0.57,2)","v":1662.93},9619.5565360000001,5208.62,{"$f":"ROUND(((SUM(AO4:AP4)/3517)*858)*0.57,2)","v":2061.9499999999998},{"$f":"ROUND((((SUM(AC4:AD4)-SUM(L4:M4))/3517)*858)/428,2)","v":0.27},{"$f":"ROUND((((SUM(AI4:AJ4)-SUM(AF4:AG4))/3517)*858)/428,2)","v":0.51},{"$f":"ROUND((((SUM(AO4:AP4)-SUM(AL4:AM4))/3517)*858)/428,2)","v":1.64}]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A3,$F$132:$G$163,2,0)+VLOOKUP(D5,$H$132:$I$135,2,0)","v":13},1360.02,503.53,1.5,0,0,0,0,39.729999999999997,0,0,0,0,"10 cm de remetimento en todas las ventanas de  F. Principal",8430.31,121,4,259.14,1677.14,558.9,310.93,2656.9856639999998,826.69,{"$f":"ROUND(((SUM(AF5:AG5)/3517)*858)*0.57,2)","v":484.43},3048.4334560000002,949.78,{"$f":"ROUND(((SUM(AI5:AJ5)/3517)*858)*0.57,2)","v":555.98},8604.3163999999997,2763.65,{"$f":"ROUND(((SUM(AL5:AM5)/3517)*858)*0.57,2)","v":1580.78},9391.4627919999984,3457.69,{"$f":"ROUND(((SUM(AO5:AP5)/3517)*858)*0.57,2)","v":1786.75},0.21,0.28999999999999998,0.84]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A3,$F$132:$G$163,2,0)+VLOOKUP(D6,$H$132:$I$135,2,0)","v":14},1248.44,571.13,1,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"10 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,253.02,1642.61,624.82000000000005,315.3,2136.486856,1155.82,{"$f":"ROUND(((SUM(AF6:AG6)/3517)*858)*0.57,2)","v":457.82},2988.153264,1273.9000000000001,{"$f":"ROUND(((SUM(AI6:AJ6)/3517)*858)*0.57,2)","v":592.66},7391.5619760000009,4224.3100000000004,{"$f":"ROUND(((SUM(AL6:AM6)/3517)*858)*0.57,2)","v":1615.26},9655.5401199999997,5242.37,{"$f":"ROUND(((SUM(AO6:AP6)/3517)*858)*0.57,2)","v":2071.64},0.26,0.55000000000000004,1.87]
["Campeche","Campeche","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A7,$F$132:$G$163,2,0)+VLOOKUP(D7,$H$132:$I$135,2,0)","v":21},2348.94,1250.55,1.5,0,1,0,1,53.16,0,37.15,0,38.44,"5 cm de Remetimiento en la ventana Oeste",25971.69,{"$f":"ROUND(Y7*0.0143,0)","v":371},{"$f":"ROUND(Y7*0.0005,0)","v":13},{"$f":"ROUND(((SUM(L7:M7)/3517)*858)*0.57,2)","v":500.53},4011.11,1262.48,{"$f":"ROUND(((SUM(AC7:AD7)/3517)*858)*0.57,2)","v":733.32},3148.4459549999997,653.88480000000004,{"$f":"ROUND(((SUM(AF7:AG7)/3517)*858)*0.57,2)","v":528.74},3484.937336,712.18560000000002,{"$f":"ROUND(((SUM(AI7:AJ7)/3517)*858)*0.57,2)","v":583.64},9837.0068329999995,2313.7727999999997,{"$f":"ROUND(((SUM(AL7:AM7)/3517)*858)*0.57,2)","v":1689.64},10739.159750999999,2924.0351999999998,{"$f":"ROUND(((SUM(AO7:AP7)/3517)*858)*0.57,2)","v":1899.95},0.95,0.23,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A7,$F$132:$G$163,2,0)+VLOOKUP(D8,$H$132:$I$135,2,0)","v":22},1885.25,1562.12,1,1,1,1,1,53.16,38.44,23.39,37.15,24.158000000000001,"No Aplica",34044.129999999997,{"$f":"ROUND(Y8*0.0143,0)","v":487},{"$f":"ROUND(Y8*0.0005,0)","v":17},{"$f":"ROUND(((SUM(L8:M8)/3517)*858)*0.57,2)","v":479.38},3904.81,1562.12,760.21,2510.3095450000001,1097.2416000000001,501.65,3409.7935950000001,1207.1424,642.01,8898.5346499999996,4026.9023999999995,1797.36,11025.181831000002,5000.2752,2228.44,1.1499999999999999,0.57999999999999996,1.77]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A7,$F$132:$G$163,2,0)+VLOOKUP(D9,$H$132:$I$135,2,0)","v":23},2322.84,1249.1199999999999,1.5,0,1,0,1,53.16,0,37.15,0,38.44,"5 cm de Remetimiento en la ventana Este",25971.69,371,13,496.7,3980.88,1262.75,729.16,3045.228744,793.62240000000008,533.82000000000005,3493.8755260000003,911.78879999999992,612.63,9861.5931500000006,2653.1040000000003,1740.24,10763.758656999998,3319.3824,1958.35,0.95,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A7,$F$132:$G$163,2,0)+VLOOKUP(D10,$H$132:$I$135,2,0)","v":24},1883.39,1613.27,1,1,1,1,1,53.16,38.44,23.39,37.15,24.158000000000001,"No Aplica",34044.129999999997,487,17,486.23,3895.94,1613.27,766.09,2448.6738009999999,1109.5871999999999,494.8,3424.7870940000003,1222.9440000000002,646.29,8471.6290710000012,4055.3376000000003,1741.95,11066.423395,5032.6751999999997,2238.6799999999998,1.1499999999999999,0.62,2.04]
["Ciudad del Carmen","Campeche","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A11,$F$132:$G$163,2,0)+VLOOKUP(D11,$H$132:$I$135,2,0)","v":31},2451.0100000000002,1221.1099999999999,1.5,0,1,0,1,53.16,0,37.15,0,38.44,"22 cm de Remetimiento en la ventana Oeste",25971.69,371,13,510.63,4139.6000000000004,1286.99,754.6,3225.7253099999998,653.88480000000004,539.48,3570.4759519999998,712.18560000000002,595.53,10078.458506000001,2313.7727999999997,1723.21,11002.754982,2924.0351999999998,1936.6,1,0.23,0.87]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A11,$F$132:$G$163,2,0)+VLOOKUP(D12,$H$132:$I$135,2,0)","v":32},1949.39,1561.11,1,1,1,1,1,53.16,38.44,23.39,37.15,24.158000000000001,"No Aplica",34044.129999999997,487,17,488.16,4051.54,1561.11,780.47,2571.92569,1097.2416000000001,510.22,3493.4877900000001,1207.1424,653.65,9116.9513000000006,4026.9023999999995,1827.73,11295.797542,5000.2752,2266.0700000000002,1.2,0.59,1.8]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A11,$F$132:$G$163,2,0)+VLOOKUP(D13,$H$132:$I$135,2,0)","v":33},2439.3200000000002,1195.2,1.5,0,1,0,1,53.16,0,37.15,0,38.44,"22 cm de Remetimiento en la ventana Este",25971.69,371,13,505.4,4123.66,1270.48,750.09,3119.974608,793.62240000000008,544.21,3579.6335320000003,911.78879999999992,624.55999999999995,10103.648300000001,2653.1040000000003,1773.9,11027.957673999999,3319.3824,1995.08,1,0.33,0.91]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A11,$F$132:$G$163,2,0)+VLOOKUP(D14,$H$132:$I$135,2,0)","v":34},1947.17,1597.74,1,1,1,1,1,53.16,38.44,23.39,37.15,24.158000000000001,"No Aplica",34044.129999999997,487,17,492.94,4044.51,1597.74,784.59,2508.7770820000001,1109.5871999999999,503.16,3508.8493079999998,1222.9440000000002,657.98,8679.5672219999997,4055.3376000000003,1770.87,11338.051389999999,5032.6751999999997,2276.4499999999998,1.2,0.63,2.0699999999999998]
["Arriaga","Chiapas","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A15,$F$132:$G$163,2,0)+VLOOKUP(D15,$H$132:$I$135,2,0)","v":41},1441.01,457.78,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.77,100,{"$f":"ROUND(Y15*0.0005,0)","v":3},{"$f":"ROUND(((SUM(L15:M15)/3517)*858)*0.57,2)","v":264.04000000000002},1937.19,457.78,333.03,3158.9499449999998,640.26220000000001,{"$f":"ROUND(((SUM(AF15:AG15)/3517)*858)*0.57,2)","v":528.29999999999995},3496.5639439999995,697.34839999999997,{"$f":"ROUND(((SUM(AI15:AJ15)/3517)*858)*0.57,2)","v":583.19000000000005},9869.8255070000014,2265.5691999999999,{"$f":"ROUND(((SUM(AL15:AM15)/3517)*858)*0.57,2)","v":1687.5},10774.988229000001,2863.1178,{"$f":"ROUND(((SUM(AO15:AP15)/3517)*858)*0.57,2)","v":1896.46},0.28000000000000003,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A15,$F$132:$G$163,2,0)+VLOOKUP(D16,$H$132:$I$135,2,0)","v":42},1426.38,441.58,1,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"16 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,259.75,1900.35,518.29999999999995,336.33,2518.6845549999998,1074.3824,{"$f":"ROUND(((SUM(AF16:AG16)/3517)*858)*0.57,2)","v":499.64},3421.1695050000003,1181.9936,{"$f":"ROUND(((SUM(AI16:AJ16)/3517)*858)*0.57,2)","v":640.1},8928.22235,3943.0085999999997,{"$f":"ROUND(((SUM(AL16:AM16)/3517)*858)*0.57,2)","v":1789.82},11061.964549,4896.1027999999997,{"$f":"ROUND(((SUM(AO16:AP16)/3517)*858)*0.57,2)","v":2219.0700000000002},0.31,0.57999999999999996,1.76]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A15,$F$132:$G$163,2,0)+VLOOKUP(D17,$H$132:$I$135,2,0)","v":43},1445.86,494.9,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.77,100,3,269.87,1938.17,494.9,338.33,3055.3883759999999,777.08860000000004,{"$f":"ROUND(((SUM(AF17:AG17)/3517)*858)*0.57,2)","v":532.92999999999995},3505.531954,892.79319999999996,{"$f":"ROUND(((SUM(AI17:AJ17)/3517)*858)*0.57,2)","v":611.61},9894.4938499999989,2597.8310000000001,{"$f":"ROUND(((SUM(AL17:AM17)/3517)*858)*0.57,2)","v":1737.13},10799.669202999999,3250.2285999999999,{"$f":"ROUND(((SUM(AO17:AP17)/3517)*858)*0.57,2)","v":1953.72},0.28000000000000003,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A15,$F$132:$G$163,2,0)+VLOOKUP(D18,$H$132:$I$135,2,0)","v":44},1476.66,447.17,1,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"16 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,267.52,1916.78,520.6,338.93,2456.843179,1086.4708000000001,{"$f":"ROUND(((SUM(AF18:AG18)/3517)*858)*0.57,2)","v":492.72},3436.2130259999999,1197.4660000000001,{"$f":"ROUND(((SUM(AI18:AJ18)/3517)*858)*0.57,2)","v":644.34},8499.8925090000012,3970.8514000000005,{"$f":"ROUND(((SUM(AL18:AM18)/3517)*858)*0.57,2)","v":1734.13},11103.343704999999,4927.8278,{"$f":"ROUND(((SUM(AO18:AP18)/3517)*858)*0.57,2)","v":2229.23},0.28999999999999998,0.62,2.0299999999999998]
["Ciudad Juarez","Chihuahua","1C","Norte","Aislada",1,0.83299999999999996,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A19,$F$132:$G$163,2,0)+VLOOKUP(D19,$H$132:$I$135,2,0)","v":51},1131.1400000000001,361.91,0,0,0,0,0,0,0,0,0,0,"No Aplica",0,{"$f":"ROUND(Y19*0.0143,0)","v":0},{"$f":"ROUND(Y19*0.0005,0)","v":0},{"$f":"ROUND(((SUM(L19:M19)/3517)*858)*0.57,2)","v":207.62},1131.1400000000001,361.91,207.62,1975.000215,681.13,369.35,2186.0791279999999,741.86,407.15,6170.6921090000005,2410.1799999999998,{"$f":"ROUND(((SUM(AL19:AM19)/3517)*858)*0.57,2)","v":1193.22},6736.6069230000003,3045.87,{"$f":"ROUND(((SUM(AO19:AP19)/3517)*858)*0.57,2)","v":1360.31},0,0.15,0.68]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A19,$F$132:$G$163,2,0)+VLOOKUP(D20,$H$132:$I$135,2,0)","v":52},1095.6199999999999,538.79,0,0,0,0,0,0,0,0,0,0,"16 cm de Remetimiento en todas las ventanas que no tienen partesol.",0,0,0,227.27,1095.6199999999999,538.79,227.27,1574.7012850000001,1142.96,377.91,2138.9419350000003,1257.44,472.29,5581.9944500000001,4194.6899999999996,1359.51,6916.0267630000008,5208.62,1686.01,0,0.39,1.34]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A19,$F$132:$G$163,2,0)+VLOOKUP(D21,$H$132:$I$135,2,0)","v":53},1136.75,389.56,0,0,0,0,0,0,0,0,0,0,"No Aplica",0,0,0,212.24,1136.75,389.56,212.24,1910.252712,826.69,380.59,2191.6859979999999,949.78,436.84,6186.1149500000001,2763.65,1244.52,6752.0376609999994,3457.69,1419.72,0,0.23,0.72]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A19,$F$132:$G$163,2,0)+VLOOKUP(D22,$H$132:$I$135,2,0)","v":54},1104.72,541.86,0,0,0,0,0,0,0,0,0,0,"16 cm de Remetimiento en todas las ventanas que no tienen partesol.",0,0,0,228.97,1104.72,541.86,228.97,1536.0375730000001,1155.82,374.32,2148.3472620000002,1273.9000000000001,475.88,5314.1992829999999,4224.3100000000004,1326.39,6941.8973349999997,5242.37,1694.3,0,0.42,1.51]
["Torreon","Coahuila","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A23,$F$132:$G$163,2,0)+VLOOKUP(D23,$H$132:$I$135,2,0)","v":61},1372.64,363.85,0,0,0,0,1,0,0,0,0,18.563500000000001,"12 cm de remetimento en todas las ventanas de  F. Principal",3361.77,{"$f":"ROUND(Y23*0.0143,0)","v":48},{"$f":"ROUND(Y23*0.0005,0)","v":2},{"$f":"ROUND(((SUM(L23:M23)/3517)*858)*0.57,2)","v":241.47},1531.56,401.22,268.76,2500.9499999999998,681.13,{"$f":"ROUND(((SUM(AF23:AG23)/3517)*858)*0.57,2)","v":442.49},2768.24,741.86,{"$f":"ROUND(((SUM(AI23:AJ23)/3517)*858)*0.57,2)","v":488.1},7813.97,2410.1799999999998,{"$f":"ROUND(((SUM(AL23:AM23)/3517)*858)*0.57,2)","v":1421.73},8530.59,3045.87,{"$f":"ROUND(((SUM(AO23:AP23)/3517)*858)*0.57,2)","v":1609.78},0.11,0.19,0.77]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A23,$F$132:$G$163,2,0)+VLOOKUP(D24,$H$132:$I$135,2,0)","v":62},1233.3699999999999,441.12,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"17cm de remetimento en todas las ventanas de  F. Principal",4812.22,69,2,232.85,1494.73,535.09,282.26,1994.05,1142.96,436.22,2708.55,1257.44,551.49,7068.5,4194.6899999999996,1566.21,8757.7900000000009,5208.62,1942.11,0.2,0.47,1.54]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A23,$F$132:$G$163,2,0)+VLOOKUP(D25,$H$132:$I$135,2,0)","v":63},1320.64,480.71,0,0,1,0,0,0,0,17.296600000000002,0,0,"12 cm de remetimento en todas las ventanas de  F. Principal",3361.77,48,2,250.49,1532.54,550.63,289.68,2418.96,826.69,451.33,2775.34,949.78,518,7833.5,2763.65,1473.6,8550.1299999999992,3457.69,1669.76,0.16,0.27,0.8]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A23,$F$132:$G$163,2,0)+VLOOKUP(D26,$H$132:$I$135,2,0)","v":64},1241.68,517.22,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"17cm de remetimento en todas las ventanas de  F. Principal",4812.22,69,2,244.59,1511.15,614.15,295.54000000000002,1945.09,1155.82,431.2,2720.46,1273.9000000000001,555.44000000000005,6729.39,4224.3100000000004,1523.18,8790.5499999999993,5242.37,1951.36,0.21,0.51,1.76]
["Lerdo","Durango","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A27,$F$132:$G$163,2,0)+VLOOKUP(D27,$H$132:$I$135,2,0)","v":71},1331.53,370.65,0,0,0,0,1,0,0,0,0,18.563500000000001,"10cm de remetimento en todas las ventanas de  F. Principal",3361.77,48,2,236.7,1490.46,401.22,263.05,1639.62282,681.13,322.70999999999998,1814.8581439999998,741.86,355.53,5122.8387320000002,2410.1799999999998,1047.51,5592.6548039999998,3045.87,1201.24,0.11,0.13,0.63]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A27,$F$132:$G$163,2,0)+VLOOKUP(D28,$H$132:$I$135,2,0)","v":72},1170.3900000000001,452.25,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"15cm de remetimento en todas las ventanas de  F. Principal",4812.22,69,2,225.64,1431.74,535.09,273.5,1307.29918,1142.96,340.72,1775.7253800000003,1257.44,421.78,4634.1085999999996,4194.6899999999996,1227.7,5741.6071240000001,5208.62,1522.69,0.2,0.33,1.21]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A27,$F$132:$G$163,2,0)+VLOOKUP(D29,$H$132:$I$135,2,0)","v":73},1279.71,493.62,0,0,1,0,0,0,0,17.296600000000002,0,0,"10cm de remetimento en todas las ventanas de  F. Principal",3361.77,48,2,246.59,1491.61,550.63,283.99,1585.8701759999999,826.69,335.48,1819.5129040000002,949.78,385.09,5135.6426000000001,2763.65,1098.44,5605.4652279999991,3457.69,1260.29,0.15,0.2,0.66]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A27,$F$132:$G$163,2,0)+VLOOKUP(D30,$H$132:$I$135,2,0)","v":74},1195.7,528.70000000000005,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"15cm de remetimento en todas las ventanas de  F. Principal",4812.22,69,2,239.79,1465.18,614.15,289.14,1275.201004,1155.82,338.05,1783.533576,1273.9000000000001,425.15,4411.7880839999998,4224.3100000000004,1200.9000000000001,5763.0845799999997,5242.37,1530.37,0.2,0.36,1.35]
["Monterrey","Nuevo León","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A31,$F$132:$G$163,2,0)+VLOOKUP(D31,$H$132:$I$135,2,0)","v":81},1275.6400000000001,642.99,0,0,1,0,1,0,0,19.867000000000001,0,26.187000000000001,"No Aplica",8951.06,128,4,266.8,1664.79,642.99,320.91000000000003,2812.3182749999996,647.07349999999997,481.05,3112.8858799999998,704.76700000000005,530.87,8786.8092649999999,2289.6709999999998,{"$f":"ROUND(((SUM(AL31:AM31)/3517)*858)*0.57,2)","v":1540.25},9592.6484550000005,2893.5765000000001,{"$f":"ROUND(((SUM(AO31:AP31)/3517)*858)*0.57,2)","v":1736.28},0.22,0.2,0.8]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A31,$F$132:$G$163,2,0)+VLOOKUP(D32,$H$132:$I$135,2,0)","v":82},1201.3399999999999,590.14,2,0,0,0,1,40.04,0,0,0,10.407,"2 cm de Remetimiento en la ventana sin elemento sombreante (Este)",11399.67,163,6,249.12,1547.17,594.67999999999995,297.83999999999997,2242.309225,1085.8120000000001,462.8,3045.7644749999999,1194.568,589.64,7948.5282500000003,3984.9554999999996,1659.42,9848.1348550000002,4948.1890000000003,2057.52,0.2,0.52,1.63]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A31,$F$132:$G$163,2,0)+VLOOKUP(D33,$H$132:$I$135,2,0)","v":83},1278.27,644.28,0,0,1,0,1,0,0,19.867000000000001,0,26.187000000000001,"No Aplica",8951.06,128,4,267.33999999999997,1659.63,644.28,320.37,2720.1205199999999,785.35550000000001,487.46,3120.8698300000001,902.29099999999994,559.44000000000005,8808.7707499999997,2625.4675000000002,1590,9614.621185,3284.8054999999999,1793.74,0.22,0.3,0.84]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A31,$F$132:$G$163,2,0)+VLOOKUP(D34,$H$132:$I$135,2,0)","v":84},1228.26,662.39,2,0,0,0,1,40.04,0,0,0,10.407,"2 cm de Remetimiento en la ventana sin elemento sombreante (Oeste)",11399.67,163,6,262.91000000000003,1560.24,667.22,309.74,2187.2537050000001,1098.029,456.84,3059.1572700000002,1210.2050000000002,593.67999999999995,7567.199055,4013.0945000000002,1610.31,9884.9734749999989,4980.2515000000003,2067.1,0.19,0.56000000000000005,1.87]
["Salina Cruz","Oaxaca","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A35,$F$132:$G$163,2,0)+VLOOKUP(D35,$H$132:$I$135,2,0)","v":91},1473.09,435.19,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"5cm de remetimento en todas las ventanas de  F. Principal",6969.71,{"$f":"ROUND(Y35*0.0143,0)","v":100},{"$f":"ROUND(Y35*0.0005,0)","v":3},{"$f":"ROUND(((SUM(L35:M35)/3517)*858)*0.57,2)","v":265.36},2024.19,457.78,345.13,3193.9632449999999,640.26220000000001,{"$f":"ROUND(((SUM(AF35:AG35)/3517)*858)*0.57,2)","v":533.16999999999996},3535.3193039999996,697.34839999999997,{"$f":"ROUND(((SUM(AI35:AJ35)/3517)*858)*0.57,2)","v":588.58000000000004},9979.2210869999999,2265.5691999999999,{"$f":"ROUND(((SUM(AL35:AM35)/3517)*858)*0.57,2)","v":1702.71},10894.416488999999,2863.1178,{"$f":"ROUND(((SUM(AO35:AP35)/3517)*858)*0.57,2)","v":1913.07},0.33,0.23,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A35,$F$132:$G$163,2,0)+VLOOKUP(D36,$H$132:$I$135,2,0)","v":92},1425.07,446.66,1.5,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"15cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,260.27999999999997,1961.78,518.29999999999995,344.87,2546.601255,1074.3824,{"$f":"ROUND(((SUM(AF36:AG36)/3517)*858)*0.57,2)","v":503.52},3459.0892050000002,1181.9936,{"$f":"ROUND(((SUM(AI36:AJ36)/3517)*858)*0.57,2)","v":645.37},9027.1813500000007,3943.0085999999997,{"$f":"ROUND(((SUM(AL36:AM36)/3517)*858)*0.57,2)","v":1803.58},11184.573609000001,4896.1027999999997,{"$f":"ROUND(((SUM(AO36:AP36)/3517)*858)*0.57,2)","v":2236.11},0.35,0.57999999999999996,1.77]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A35,$F$132:$G$163,2,0)+VLOOKUP(D37,$H$132:$I$135,2,0)","v":93},1477.94,472.88,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"5cm de remetimento en todas las ventanas de  F. Principal",6969.71,100,3,271.27,2025.17,494.9,350.43,3089.2538159999999,777.08860000000004,{"$f":"ROUND(((SUM(AF37:AG37)/3517)*858)*0.57,2)","v":537.64},3544.3867140000002,892.79319999999996,{"$f":"ROUND(((SUM(AI37:AJ37)/3517)*858)*0.57,2)","v":617.02},10004.162850000001,2597.8310000000001,{"$f":"ROUND(((SUM(AL37:AM37)/3517)*858)*0.57,2)","v":1752.38},10919.371023,3250.2285999999999,{"$f":"ROUND(((SUM(AO37:AP37)/3517)*858)*0.57,2)","v":1970.37},0.32,0.33,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A35,$F$132:$G$163,2,0)+VLOOKUP(D38,$H$132:$I$135,2,0)","v":94},1475.46,452.03,1.5,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"15cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,268.02999999999997,1978.31,520.6,347.49,2484.074439,1086.4708000000001,{"$f":"ROUND(((SUM(AF38:AG38)/3517)*858)*0.57,2)","v":496.51},3474.2994659999999,1197.4660000000001,{"$f":"ROUND(((SUM(AI38:AJ38)/3517)*858)*0.57,2)","v":649.64},8594.1039689999998,3970.8514000000005,{"$f":"ROUND(((SUM(AL38:AM38)/3517)*858)*0.57,2)","v":1747.23},11226.411404999999,4927.8278,{"$f":"ROUND(((SUM(AO38:AP38)/3517)*858)*0.57,2)","v":2246.34},0.33,0.63,2.0499999999999998]
["Cancun","Quintana Roo","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A39,$F$132:$G$163,2,0)+VLOOKUP(D39,$H$132:$I$135,2,0)","v":101},3081.7,1441.88,0,0,1,0,1.5,0,0,54.983699999999999,0,54.983699999999999,"No Aplica",22909.51,328,11,629.03,5266.05,1441.88,932.78,3239.73063,653.88480000000004,541.42999999999995,3585.9780959999998,712.18560000000002,597.69000000000005,10122.216737999999,2313.7727999999997,{"$f":"ROUND(((SUM(AL39:AM39)/3517)*858)*0.57,2)","v":1729.3},11050.526286,2924.0351999999998,{"$f":"ROUND(((SUM(AO39:AP39)/3517)*858)*0.57,2)","v":1943.25},1.25,0.23,0.88]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A39,$F$132:$G$163,2,0)+VLOOKUP(D40,$H$132:$I$135,2,0)","v":102},2375.08,1954.26,1.5,0,2,2,2,55.67,0,28.3292,54.983699999999999,26.8432,"No Aplica",39556.53,566,20,602.02,5002.51,1954.26,967.38,2583.0923699999998,1097.2416000000001,511.77,3508.6556700000001,1207.1424,655.76,9156.5349000000006,4026.9023999999995,1833.24,11344.841166000002,5000.2752,2272.89,1.5,0.59,1.8]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A39,$F$132:$G$163,2,0)+VLOOKUP(D41,$H$132:$I$135,2,0)","v":103},3090.13,1452.57,0,0,1,0,1.5,0,0,54.983699999999999,0,54.983699999999999,"No Aplica",22909.51,328,11,631.69000000000005,5262.2,1452.57,933.73,3133.5207840000003,793.62240000000008,546.09,3595.1754360000004,911.78879999999992,626.72,10147.5159,2653.1040000000003,1780,11075.838401999999,3319.3824,2001.74,1.24,0.33,0.91]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A39,$F$132:$G$163,2,0)+VLOOKUP(D42,$H$132:$I$135,2,0)","v":104},2271.19,1950.66,1.5,0,2,2,2,55.67,0,28.3292,54.983699999999999,26.8432,"No Aplica",39556.53,566,20,587.07000000000005,5005.1099999999997,1950.66,967.24,2519.669586,1109.5871999999999,504.67,3524.0838840000001,1222.9440000000002,660.1,8717.2518060000002,4055.3376000000003,1776.11,11387.278469999999,5032.6751999999997,2283.29,1.56,0.64,2.08]
["Comalcalco","Tabasco","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A43,$F$132:$G$163,2,0)+VLOOKUP(D43,$H$132:$I$135,2,0)","v":111},2390.1799999999998,1335.51,1,0,1,0,1,42.11,0,42.779800000000002,0,43.56,"11 cm de Remetimiento en ventanas al Sur",24790.33,355,12,518.08000000000004,4307.1499999999996,1468.53,803.14,3225.7253099999998,640.26220000000001,537.59,3570.4759519999998,697.34839999999997,593.47,10078.458506000001,2265.5691999999999,1716.51,11002.754982,2863.1178,1928.13,1.17,0.23,0.87]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A43,$F$132:$G$163,2,0)+VLOOKUP(D44,$H$132:$I$135,2,0)","v":112},1919,1711.61,0,1,2,1,2,0,43.56,25.51,42.779800000000002,28.096499999999999,"7 cm de Remetimiento en ventanas al Oeste",30282.34,433,15,504.86,4209.18,1788.9,834.07,2571.92569,1074.3824,507.04,3493.4877900000001,1181.9936,650.15,9116.9513000000006,3943.0085999999997,1816.07,11295.797542,4896.1027999999997,2251.58,1.35,0.59,1.79]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A43,$F$132:$G$163,2,0)+VLOOKUP(D45,$H$132:$I$135,2,0)","v":113},2378.25,1324.64,1,0,1,0,1,42.11,0,42.779800000000002,0,43.56,"11 cm de Remetimiento en ventanas al Norte",24790.33,355,12,514.91,4293.18,1434.02,796.4,3119.974608,777.08860000000004,541.91,3579.6335320000003,892.79319999999996,621.91999999999996,10103.648300000001,2597.8310000000001,1766.22,11027.957673999999,3250.2285999999999,1985.47,1.1499999999999999,0.33,0.9]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A43,$F$132:$G$163,2,0)+VLOOKUP(D46,$H$132:$I$135,2,0)","v":114},1919.03,1740.31,0,1,2,1,2,0,43.56,25.51,42.779800000000002,28.096499999999999,"7 cm de Remetimiento en ventanas al Este",30282.34,433,15,508.85,4196.26,1821.06,836.74,2508.7770820000001,1086.4708000000001,499.94,3508.8493079999998,1197.4660000000001,654.44000000000005,8679.5672219999997,3970.8514000000005,1759.12,11338.051389999999,4927.8278,2261.87,1.34,0.63,2.06]
["Ciudad Victoria","Tamaulipas","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A47,$F$132:$G$163,2,0)+VLOOKUP(D47,$H$132:$I$135,2,0)","v":121},1355.1,479.26,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,255.08,1987.98,479.26,343.08,3148.4459549999997,640.26220000000001,526.84,3484.937336,697.34839999999997,581.57000000000005,9837.0068329999995,2265.5691999999999,1682.94,10739.159750999999,2863.1178,1891.48,0.36,0.22,0.85]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A47,$F$132:$G$163,2,0)+VLOOKUP(D48,$H$132:$I$135,2,0)","v":122},1241.73,602.98,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"No Aplica",11786.64,169,6,256.52,1925.77,602.98,351.64,2510.3095450000001,1074.3824,498.47,3409.7935950000001,1181.9936,638.52,8898.5346499999996,3943.0085999999997,1785.69,11025.181831000002,4896.1027999999997,2213.9499999999998,0.39,0.56999999999999995,1.76]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A47,$F$132:$G$163,2,0)+VLOOKUP(D49,$H$132:$I$135,2,0)","v":123},1358.22,472.19,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,254.53,1998.76,472.19,343.6,3045.228744,777.08860000000004,531.52,3493.8755260000003,892.79319999999996,609.99,9861.5931500000006,2597.8310000000001,1732.56,10763.758656999998,3250.2285999999999,1948.73,0.37,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A47,$F$132:$G$163,2,0)+VLOOKUP(D50,$H$132:$I$135,2,0)","v":124},1246.72,605.45000000000005,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"No Aplica",11786.64,169,6,257.56,1931,605.45000000000005,352.71,2448.6738009999999,1086.4708000000001,491.58,3424.7870940000003,1197.4660000000001,642.75,8471.6290710000012,3970.8514000000005,1730.2,11066.423395,4927.8278,2224.1,0.39,0.62,2.02]
["Tampico","Tamaulipas","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A51,$F$132:$G$163,2,0)+VLOOKUP(D51,$H$132:$I$135,2,0)","v":131},1448.57,370.45,0,0,1.5,0,0,0,0,21.006,0,0,"17 cm Remetimiento en ventanas sin elemento sombreante",4669.63,67,2,252.95,1782.69,481.15,314.8,3055.4106149999998,640.26220000000001,513.91,3381.9588079999999,697.34839999999997,567.25,9546.3271490000006,2265.5691999999999,1642.52,10421.821803000001,2863.1178,1847.35,0.25,0.22,0.84]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A51,$F$132:$G$163,2,0)+VLOOKUP(D52,$H$132:$I$135,2,0)","v":132},1247.8599999999999,514.99,1,0,1,0,0,37.950000000000003,0,11.6768,0,0,"22 cm Remetimiento en las ventanas al Oeste",9487.59,136,5,245.13,1708.29,605.05999999999995,321.69,2436.130885,1074.3824,488.16,3309.035535,1181.9936,624.5,8635.5864500000007,3943.0085999999997,1749.13,10699.392043000002,4896.1027999999997,2168.65,0.31,0.56000000000000005,1.72]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A51,$F$132:$G$163,2,0)+VLOOKUP(D53,$H$132:$I$135,2,0)","v":133},1384.53,366.63,0,0,1.5,0,0,0,0,21.006,0,0,"17 cm Remetimiento en ventanas sin elemento sombreante",4669.63,67,2,243.51,1792.82,474,315.20999999999998,2955.2434320000002,777.08860000000004,519,3390.6328780000003,892.79319999999996,595.64,9570.1869499999993,2597.8310000000001,1692.04,10445.693820999999,3250.2285999999999,1904.5,0.28999999999999998,0.31,0.87]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A51,$F$132:$G$163,2,0)+VLOOKUP(D54,$H$132:$I$135,2,0)","v":134},1217.95,511.35,1,0,1,0,0,37.950000000000003,0,11.6768,0,0,"22 cm Remetimiento en las ventanas al Este",9487.59,136,5,240.47,1714.85,605.45000000000005,322.64999999999998,2376.3164529999999,1086.4708000000001,481.52,3323.5859820000001,1197.4660000000001,628.67999999999995,8221.2957630000001,3970.8514000000005,1695.39,10739.414934999999,4927.8278,2178.62,0.34,0.6,1.98]
["Coatzacoalcos","Veracruz","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A55,$F$132:$G$163,2,0)+VLOOKUP(D55,$H$132:$I$135,2,0)","v":141},2390.9,883.88,1,0,1,0,0,34.33,0,46.879100000000001,0,0,"8 cm Remetimiento en ventanas  sin elementos sombreantes",15640.99,224,8,455.38,3312.88,955.22,593.5,3074.9180249999999,640.26220000000001,516.62,3403.5510799999997,697.34839999999997,570.25,9607.2761150000006,2265.5691999999999,1650.99,10488.360404999999,2863.1178,1856.6,0.56999999999999995,0.22,0.84]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A55,$F$132:$G$163,2,0)+VLOOKUP(D56,$H$132:$I$135,2,0)","v":142},1977.89,1122.99,0,0,2,1,2,0,0,19.559999999999999,46.879100000000001,18.146999999999998,"17 cm Remetimiento en ventanas  sin elementos sombreantes",18608.310000000001,266,9,431.2,3126.44,1262.44,610.29999999999995,2451.684475,1074.3824,490.32,3330.162225,1181.9936,627.44000000000005,8690.7207500000004,3943.0085999999997,1756.8,10767.702805000001,4896.1027999999997,2178.15,0.73,0.56000000000000005,1.73]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A55,$F$132:$G$163,2,0)+VLOOKUP(D57,$H$132:$I$135,2,0)","v":143},2258.35,911.06,1,0,1,0,0,34.33,0,46.879100000000001,0,0,"8 cm Remetimiento en ventanas  sin elementos sombreantes",15640.99,224,8,440.73,3323.67,967.89,596.77,2974.11132,777.08860000000004,521.63,3412.28053,892.79319999999996,598.65,9631.2882499999996,2597.8310000000001,1700.53,10512.384834999999,3250.2285999999999,1913.77,0.64,0.32,0.87]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A55,$F$132:$G$163,2,0)+VLOOKUP(D58,$H$132:$I$135,2,0)","v":144},1914.78,1113.76,0,0,2,1,2,0,0,19.559999999999999,46.879100000000001,18.146999999999998,"17 cm Remetimiento en ventanas  sin elementos sombreantes",18608.310000000001,266,9,421.14,3140.9,1256.58,611.5,2391.488155,1086.4708000000001,483.63,3344.80557,1197.4660000000001,631.63,8273.7850049999997,3970.8514000000005,1702.69,10807.981225,4927.8278,2188.16,0.78,0.61,1.99]
["Veracruz","Veracruz","1C","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A59,$F$132:$G$163,2,0)+VLOOKUP(D59,$H$132:$I$135,2,0)","v":151},2319.77,922.56,1,0,1,0,0,34.33,0,46.879100000000001,0,0,"15 cm Remetimiento en ventanas  sin elementos sombreantes",16395.900000000001,234,8,450.87,3265.02,957.61,587.17999999999995,3055.1605199999999,640.26220000000001,513.87,3381.6819839999998,697.34839999999997,567.21,9545.545752,2265.5691999999999,1642.41,10420.968744,2863.1178,1847.23,0.56000000000000005,0.22,0.84]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A59,$F$132:$G$163,2,0)+VLOOKUP(D60,$H$132:$I$135,2,0)","v":152},1856.37,1197.5999999999999,0,0,2,1,2,0,0,19.559999999999999,46.879100000000001,18.146999999999998,"10 cm Remetimiento en ventanas  sin elementos sombreantes",21303.86,305,11,424.67,3102.27,1266.8599999999999,607.54999999999995,2435.9314799999997,1074.3824,488.13,3308.7646800000002,1181.9936,624.47,8634.8796000000002,3943.0085999999997,1749.03,10698.516264000002,4896.1027999999997,2168.5300000000002,0.75,0.56000000000000005,1.72]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A59,$F$132:$G$163,2,0)+VLOOKUP(D61,$H$132:$I$135,2,0)","v":153},2180.0300000000002,874.88,1,0,1,0,0,34.33,0,46.879100000000001,0,0,"15 cm Remetimiento en ventanas  sin elementos sombreantes",16395.900000000001,234,8,424.8,3268.63,969.91,589.39,2955.0015359999998,777.08860000000004,518.97,3390.3553440000001,892.79319999999996,595.6,9569.4035999999996,2597.8310000000001,1691.93,10444.838807999999,3250.2285999999999,1904.38,0.67,0.31,0.87]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A59,$F$132:$G$163,2,0)+VLOOKUP(D62,$H$132:$I$135,2,0)","v":154},1777.04,1189.98,0,0,2,1,2,0,0,19.559999999999999,46.879100000000001,18.146999999999998,"10 cm Remetimiento en ventanas  sin elementos sombreantes",21303.86,305,11,412.58,3116.74,1260.46,608.67999999999995,2376.121944,1086.4708000000001,481.49,3323.313936,1197.4660000000001,628.64,8220.622824,3970.8514000000005,1695.3,10738.535879999999,4927.8278,2178.5,0.8,0.6,1.98]
["Monclova","Coahuila","1D","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A63,$F$132:$G$163,2,0)+VLOOKUP(D63,$H$132:$I$135,2,0)","v":161},1319.26,401.22,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.77,{"$f":"ROUND(Y63*0.0143,0)","v":100},{"$f":"ROUND(Y63*0.0005,0)","v":3},{"$f":"ROUND(((SUM(L63:M63)/3517)*858)*0.57,2)","v":239.24},1787.02,401.22,304.29000000000002,3028.6504499999996,681.13,{"$f":"ROUND(((SUM(AF63:AG63)/3517)*858)*0.57,2)","v":515.87},3352.3386399999999,741.86,{"$f":"ROUND(((SUM(AI63:AJ63)/3517)*858)*0.57,2)","v":569.32000000000005},9462.71767,2410.1799999999998,{"$f":"ROUND(((SUM(AL63:AM63)/3517)*858)*0.57,2)","v":1651},10330.54449,3045.87,{"$f":"ROUND(((SUM(AO63:AP63)/3517)*858)*0.57,2)","v":1860.07},0.27,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A63,$F$132:$G$163,2,0)+VLOOKUP(D64,$H$132:$I$135,2,0)","v":162},1292.2,467.48,1,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"12 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,244.69,1734.73,535.09,315.63,2414.7945500000001,1142.96,494.73,3280.0540500000002,1257.44,630.97,8559.9534999999996,4194.6899999999996,1773.61,10605.683690000002,5208.62,2199.0700000000002,0.28999999999999998,0.56000000000000005,1.74]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A63,$F$132:$G$163,2,0)+VLOOKUP(D65,$H$132:$I$135,2,0)","v":163},1331.86,550.63,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.77,100,3,261.77,1797.68,550.63,326.55,2929.3605600000001,826.69,522.29999999999995,3360.9367400000001,949.78,599.42999999999995,9486.3685000000005,2763.65,1703.44,10354.207429999999,3457.69,1920.63,0.27,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A63,$F$132:$G$163,2,0)+VLOOKUP(D66,$H$132:$I$135,2,0)","v":164},1339.2,544.41,1,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"12 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,261.93,1764.81,614.15,330.81,2355.5039899999997,1155.82,488.27,3294.4770600000002,1273.9000000000001,635.26,8149.2912900000001,4224.3100000000004,1720.62,10645.356049999999,5242.37,2209.2800000000002,0.28000000000000003,0.6,2]
["Ciudad Valles","San Luis Potosi","1D","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A67,$F$132:$G$163,2,0)+VLOOKUP(D67,$H$132:$I$135,2,0)","v":171},1413.04,443.69,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.71,100,3,258.19,1909.22,443.69,{"$f":"ROUND(((SUM(AC67:AD67)/3517)*858)*0.57,2)","v":327.19},3151.6971899999999,647.07349999999997,528.24,3488.5360479999999,704.76700000000005,583.1,9847.1649940000007,2289.6709999999998,1687.7,10750.249518000001,2893.5765000000001,1897.26,0.28000000000000003,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A67,$F$132:$G$163,2,0)+VLOOKUP(D68,$H$132:$I$135,2,0)","v":172},1369.3,423.23,1.5,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"17cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,249.26,1872.38,499.37,329.81,2512.9018099999998,1085.8120000000001,500.42,3413.3147100000001,1194.568,640.75,8907.7237000000005,3984.9554999999996,1792.8,11036.566958000001,4948.1890000000003,2222.7800000000002,{"$f":"ROUND((((SUM(AC68:AD68)-SUM(L68:M68))/3517)*858)/428,2)","v":0.33},{"$f":"ROUND((((SUM(AI68:AJ68)-SUM(AF68:AG68))/3517)*858)/428,2)","v":0.57999999999999996},{"$f":"ROUND((((SUM(AO68:AP68)-SUM(AL68:AM68))/3517)*858)/428,2)","v":1.76}]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A67,$F$132:$G$163,2,0)+VLOOKUP(D69,$H$132:$I$135,2,0)","v":173},1417.89,500.2,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.71,100,3,266.72000000000003,1910.2,500.2,335.18,3048.373392,785.35550000000001,533.1,3497.4834680000004,902.29099999999994,611.82000000000005,9871.7767000000003,2625.4675000000002,1737.82,10774.873825999999,3284.8054999999999,1955.08,0.28000000000000003,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A67,$F$132:$G$163,2,0)+VLOOKUP(D70,$H$132:$I$135,2,0)","v":174},1419.58,475.98,1.5,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"17cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,263.58999999999997,1888.81,557.13,340.12,2451.2024179999999,1098.029,493.54,3428.3236919999999,1210.2050000000002,645.02,8480.3772779999999,4013.0945000000002,1737.29,11077.85111,4980.2515000000003,2232.98,0.31,0.62,2.0299999999999998]
["Mazatlán","Sinaloa","1D","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A71,$F$132:$G$163,2,0)+VLOOKUP(D71,$H$132:$I$135,2,0)","v":181},1468.76,324.14999999999998,0,0,1,0,0,0,0,16.331399999999999,0,0,"11 cm de Remetimiento en ventanas al Norte",3174.17,45,2,249.31,1944.07,352.13,319.3,3095.4258149999996,681.13,{"$f":"ROUND(((SUM(AF71:AG71)/3517)*858)*0.57,2)","v":525.15},3426.2506479999997,741.86,{"$f":"ROUND(((SUM(AI71:AJ71)/3517)*858)*0.57,2)","v":579.6},9671.3506689999995,2410.1799999999998,{"$f":"ROUND(((SUM(AL71:AM71)/3517)*858)*0.57,2)","v":1680.01},10558.311243,3045.87,{"$f":"ROUND(((SUM(AO71:AP71)/3517)*858)*0.57,2)","v":1891.74},0.28999999999999998,0.22,0.87]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A71,$F$132:$G$163,2,0)+VLOOKUP(D72,$H$132:$I$135,2,0)","v":182},1207.78,556.11,1,0,0,0,1,38,0,0,0,11.1945,"13 cm de Remetimiento en ventanas al Este",9403.36,134,5,245.28,1901.99,614.36,349.91,2468.0356849999998,1142.96,502.13,3352.372335,1257.44,641.02,8748.6824500000002,4194.6899999999996,1799.85,10839.516683000002,5208.62,2231.59,0.43,0.56999999999999995,1.77]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A71,$F$132:$G$163,2,0)+VLOOKUP(D73,$H$132:$I$135,2,0)","v":183},1446.5,350.49,0,0,1,0,0,0,0,16.331399999999999,0,0,"11 cm de Remetimiento en ventanas al Sur",3174.17,45,2,249.88,1946.46,402.05,326.57,2993.9467920000002,826.69,531.28,3435.0383179999999,949.78,609.74,9695.5229500000005,2763.65,1732.52,10582.495900999998,3457.69,1952.37,0.31,0.32,0.9]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A71,$F$132:$G$163,2,0)+VLOOKUP(D74,$H$132:$I$135,2,0)","v":184},1228.08,557.21,1,0,0,0,1,38,0,0,0,11.1945,"13 cm de Remetimiento en ventanas al Oeste",9403.36,134,5,248.26,1905.52,617.29999999999995,350.81,2407.4378929999998,1155.82,495.49,3367.1133420000001,1273.9000000000001,645.36,8328.9660030000014,4224.3100000000004,1745.61,10880.063735,5242.37,2241.92,0.42,0.61,2.0299999999999998]
["Villahermosa","Tabasco","1D","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A75,$F$132:$G$163,2,0)+VLOOKUP(D75,$H$132:$I$135,2,0)","v":191},1468.76,324.14999999999998,2,0,1,0,1,42.11,0,42.779800000000002,0,43.56,"11 cm de Remetimiento en ventanas al Norte",3174.17,45,2,249.31,4465.09,1468.53,825.11,3373.2813599999999,640.26220000000001,558.11,3733.8021119999999,697.34839999999997,616.17999999999995,10539.482736,2265.5691999999999,1780.62,11506.059792,2863.1178,1998.12,2.36,0.24,0.89]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A75,$F$132:$G$163,2,0)+VLOOKUP(D76,$H$132:$I$135,2,0)","v":192},1207.78,556.11,0,1,2,1,2,0,43.56,25.51,42.779800000000002,28.096499999999999,"13 cm de Remetimiento en ventanas al Este",9403.36,134,5,245.28,4332.72,1788.9,851.25,2689.5746399999998,1074.3824,523.4,3653.2922400000002,1181.9936,672.38,9533.9928,3943.0085999999997,1874.06,11812.507152000002,4896.1027999999997,2323.4299999999998,2.48,0.61,1.84]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A75,$F$132:$G$163,2,0)+VLOOKUP(D77,$H$132:$I$135,2,0)","v":193},1446.5,350.49,2,0,1,0,1,42.11,0,42.779800000000002,0,43.56,"11 cm de Remetimiento en ventanas al Sur",3174.17,45,2,249.88,4435.53,1434.02,816.2,3262.693248,777.08860000000004,561.76,3743.378592,892.79319999999996,644.69000000000005,10565.8248,2597.8310000000001,1830.49,11532.415343999999,3250.2285999999999,2055.62,2.3199999999999998,0.34,0.92]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A75,$F$132:$G$163,2,0)+VLOOKUP(D78,$H$132:$I$135,2,0)","v":194},1228.08,557.21,0,1,2,1,2,0,43.56,25.51,42.779800000000002,28.096499999999999,"13 cm de Remetimiento en ventanas al Oeste",9403.36,134,5,248.26,4304.9799999999996,1821.06,851.86,2623.5373919999997,1086.4708000000001,515.9,3669.356448,1197.4660000000001,676.76,9076.6012320000009,3970.8514000000005,1814.33,11856.69384,4927.8278,2333.9899999999998,2.4700000000000002,0.66,2.13]
["Matamoros","Tamaulipas","1D","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A79,$F$132:$G$163,2,0)+VLOOKUP(D79,$H$132:$I$135,2,0)","v":201},1468.76,324.14999999999998,0,0,2,0,0,0,0,21.006,0,0,"11 cm de Remetimiento en ventanas al Norte",3174.17,45,2,249.31,1853.11,478.9,324.27999999999997,3074.9180249999999,640.26220000000001,516.62,3403.5510799999997,697.34839999999997,570.25,9607.2761150000006,2265.5691999999999,1650.99,10488.360404999999,2863.1178,1856.6,0.31,0.22,0.84]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A79,$F$132:$G$163,2,0)+VLOOKUP(D80,$H$132:$I$135,2,0)","v":202},1207.78,556.11,1.5,0,1,0,0,37.950000000000003,0,11.6768,0,0,"13 cm de Remetimiento en ventanas al Este",9403.36,134,5,245.28,1803.86,605.78,335.07,2451.684475,1074.3824,490.32,3330.162225,1181.9936,627.44000000000005,8690.7207500000004,3943.0085999999997,1756.8,10767.702805000001,4896.1027999999997,2178.15,0.37,0.56000000000000005,1.73]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A79,$F$132:$G$163,2,0)+VLOOKUP(D81,$H$132:$I$135,2,0)","v":203},1446.5,350.49,0,0,2,0,0,0,0,21.006,0,0,"11 cm de Remetimiento en ventanas al Sur",3174.17,45,2,249.88,1863.36,470.85,324.58999999999997,2974.11132,777.08860000000004,521.63,3412.28053,892.79319999999996,598.65,9631.2882499999996,2597.8310000000001,1700.53,10512.384834999999,3250.2285999999999,1913.77,0.31,0.32,0.87]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A79,$F$132:$G$163,2,0)+VLOOKUP(D82,$H$132:$I$135,2,0)","v":204},1228.08,557.21,1.5,0,1,0,0,37.950000000000003,0,11.6768,0,0,"13 cm de Remetimiento en ventanas al Oeste",9403.36,134,5,248.26,1802.47,608.13,335.21,2391.488155,1086.4708000000001,483.63,3344.80557,1197.4660000000001,631.63,8273.7850049999997,3970.8514000000005,1702.69,10807.981225,4927.8278,2188.16,0.36,0.61,1.99]
["La Paz","Baja California Sur","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A83,$F$132:$G$163,2,0)+VLOOKUP(D83,$H$132:$I$135,2,0)","v":211},1453.21,358.77,1.5,0,0,0,0,39.729999999999997,0,0,0,0,"14 cm de remetimento en todas las ventanas de  F. Principal",8430.31,{"$f":"ROUND(Y83*0.0143,0)","v":121},{"$f":"ROUND(Y83*0.0005,0)","v":4},{"$f":"ROUND(((SUM(L83:M83)/3517)*858)*0.57,2)","v":251.97},1787.02,401.22,304.29000000000002,3028.6504499999996,681.13,{"$f":"ROUND(((SUM(AF83:AG83)/3517)*858)*0.57,2)","v":515.87},3352.3386399999999,741.86,{"$f":"ROUND(((SUM(AI83:AJ83)/3517)*858)*0.57,2)","v":569.32000000000005},9462.71767,2410.1799999999998,{"$f":"ROUND(((SUM(AL83:AM83)/3517)*858)*0.57,2)","v":1651},10330.54449,3045.87,{"$f":"ROUND(((SUM(AO83:AP83)/3517)*858)*0.57,2)","v":1860.07},0.21,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A83,$F$132:$G$163,2,0)+VLOOKUP(D84,$H$132:$I$135,2,0)","v":212},1292.2,460.89,1,0,0,0,1,39.729999999999997,0,17.296600000000002,0,0,"14 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,243.78,1734.73,535.09,315.63,2414.7945500000001,1142.96,494.73,3280.0540500000002,1257.44,630.97,8559.9534999999996,4194.6899999999996,1773.61,10605.683690000002,5208.62,2199.0700000000002,0.28999999999999998,0.56000000000000005,1.74]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A83,$F$132:$G$163,2,0)+VLOOKUP(D85,$H$132:$I$135,2,0)","v":213},1463.87,472.36,1.5,0,0,0,0,39.729999999999997,0,0,0,0,"14 cm de remetimento en todas las ventanas de  F. Principal",8430.31,121,4,269.24,1797.68,550.63,326.55,2929.3605600000001,826.69,522.29999999999995,3360.9367400000001,949.78,599.42999999999995,9486.3685000000005,2763.65,1703.44,10354.207429999999,3457.69,1920.63,0.23,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A83,$F$132:$G$163,2,0)+VLOOKUP(D86,$H$132:$I$135,2,0)","v":214},1339.2,537.61,1,0,1,0,0,39.729999999999997,0,0,0,18.563500000000001,"14 cm de remetimento en todas las ventanas de  F. Principal",9705.0400000000009,139,5,260.98,1764.81,614.15,330.81,2355.5039899999997,1155.82,488.27,3294.4770600000002,1273.9000000000001,635.26,8149.2912900000001,4224.3100000000004,1720.62,10645.356049999999,5242.37,2209.2800000000002,0.28999999999999998,0.6,2]
["Piedras Negras","Coahuila","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A87,$F$132:$G$163,2,0)+VLOOKUP(D87,$H$132:$I$135,2,0)","v":221},1441.01,401.22,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.71,100,3,256.17,1937.19,401.22,325.17,3158.9499449999998,681.13,533.99,3496.5639439999995,741.86,589.38,9869.8255070000014,2410.1799999999998,1707.61,10774.988229000001,3045.87,1921.87,0.28000000000000003,0.23,0.88]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A87,$F$132:$G$163,2,0)+VLOOKUP(D88,$H$132:$I$135,2,0)","v":222},1380.58,452.25,1.5,0,1,0,0,39.729999999999997,0,17.296600000000002,0,0,"15cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,254.87,1900.35,535.09,338.66,2518.6845549999998,1142.96,509.17,3421.1695050000003,1257.44,650.59,8928.22235,4194.6899999999996,1824.82,11061.964549,5208.62,2262.52,0.34,0.57999999999999996,1.79]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A87,$F$132:$G$163,2,0)+VLOOKUP(D89,$H$132:$I$135,2,0)","v":223},1445.86,550.63,0,0,1,0,1,0,0,17.296600000000002,0,18.563500000000001,"No Aplica",6969.71,100,3,277.62,1938.17,550.63,346.08,3055.3883759999999,826.69,539.83000000000004,3505.531954,949.78,619.54,9894.4938499999989,2763.65,1760.19,10799.669202999999,3457.69,1982.57,0.28000000000000003,0.33,0.91]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A87,$F$132:$G$163,2,0)+VLOOKUP(D90,$H$132:$I$135,2,0)","v":224},1430.86,528.70000000000005,1.5,0,0,0,1,39.729999999999997,0,0,0,18.563500000000001,"15cm de remetimento en todas las ventanas de  F. Principal",10578.71,151,5,272.49,1916.78,614.15,351.94,2456.843179,1155.82,502.36,3436.2130259999999,1273.9000000000001,654.97,8499.8925090000012,4224.3100000000004,1769.38,11103.343704999999,5242.37,2272.9699999999998,0.33,0.63,2.06]
["Guaymas","Sonora","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A91,$F$132:$G$163,2,0)+VLOOKUP(D91,$H$132:$I$135,2,0)","v":231},1601.25,434.68,1,0,1,0,0,38.65,0,18.129799999999999,0,0,"No Aplica",10874.94,156,5,283.11,2405.75,434.68,394.98,3409.7952299999997,681.13,568.87,3774.2184159999997,741.86,627.99,10653.566698000001,2410.1799999999998,{"$f":"ROUND(((SUM(AL91:AM91)/3517)*858)*0.57,2)","v":1816.59},11630.606406000001,3045.87,{"$f":"ROUND(((SUM(AO91:AP91)/3517)*858)*0.57,2)","v":2040.85},0.46,0.24,0.92]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A91,$F$132:$G$163,2,0)+VLOOKUP(D92,$H$132:$I$135,2,0)","v":232},1275.69,753.83,2,0,2,0,2,38.65,0,12.282,0,10.045199999999999,"No Aplica",14674.77,210,7,282.22000000000003,2322.63,753.83,427.8,2718.68777,1142.96,536.99,3692.8370700000005,1257.44,688.37,9637.1929,4194.6899999999996,1923.41,11940.370886000001,5208.62,2384.67,0.6,0.62,1.89]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A91,$F$132:$G$163,2,0)+VLOOKUP(D93,$H$132:$I$135,2,0)","v":233},1550.61,554.23,1,0,1,0,0,38.65,0,18.129799999999999,0,0,"No Aplica",10874.94,156,5,292.69,2409.64,554.23,412.14,3298.0100640000001,826.69,573.55999999999995,3783.8985560000001,949.78,658.25,10680.1939,2763.65,1869.45,11657.247241999999,3457.69,2101.8200000000002,0.49,0.35,0.95]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A91,$F$132:$G$163,2,0)+VLOOKUP(D94,$H$132:$I$135,2,0)","v":234},1278.8499999999999,775.65,2,0,2,0,2,38.65,0,12.282,0,10.045199999999999,"No Aplica",14674.77,210,7,285.69,2335.7399999999998,775.65,432.66,2651.9357059999998,1155.82,529.49,3709.0751639999999,1273.9000000000001,692.91,9174.8503259999998,4224.3100000000004,1863.23,11985.03587,5242.37,2395.5700000000002,0.6,0.67,2.1800000000000002]
["Navojoa","Sonora","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A95,$F$132:$G$163,2,0)+VLOOKUP(D95,$H$132:$I$135,2,0)","v":241},1346.79,434.68,0,0,1,0,1,0,0,18.129799999999999,0,18.373799999999999,"No Aplica",7094.84,101,4,247.72,2028.15,434.68,342.47,3131.9396849999998,681.13,530.23,3466.6669519999996,741.86,585.22,9785.4346310000001,2410.1799999999998,1695.87,10682.857857000001,3045.87,1909.06,0.39,0.23,0.87]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A95,$F$132:$G$163,2,0)+VLOOKUP(D96,$H$132:$I$135,2,0)","v":242},1165.51,704.06,1,0,1.5,0,1.5,38.65,0,12.282,0,10.045199999999999,"18 cm remetimiento en la ventana al Oeste",12314.57,176,6,259.97000000000003,1960.64,753.83,377.46,2497.148815,1142.96,506.18,3391.9171650000003,1257.44,646.52,8851.8825500000003,4194.6899999999996,1814.2,10967.380417,5208.62,2249.37,0.48,0.57999999999999996,1.78]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A95,$F$132:$G$163,2,0)+VLOOKUP(D97,$H$132:$I$135,2,0)","v":243},1347,554.23,0,0,1,0,1,0,0,18.129799999999999,0,18.373799999999999,"No Aplica",7094.84,101,4,264.38,2025.79,554.23,358.77,3029.2636080000002,826.69,536.19000000000005,3475.5582820000004,949.78,615.37,9809.8920500000004,2763.65,1748.43,10707.327798999999,3457.69,1969.73,0.39,0.32,0.91]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A95,$F$132:$G$163,2,0)+VLOOKUP(D98,$H$132:$I$135,2,0)","v":244},1168.5899999999999,727.41,1,0,1.5,0,1.5,38.65,0,12.282,0,10.045199999999999,"18 cm remetimiento en la ventana al Este",12314.57,176,6,263.64999999999998,1972.98,775.65,382.21,2435.8362069999998,1155.82,499.44,3406.832058,1273.9000000000001,650.88,8427.2150970000002,4224.3100000000004,1759.27,11008.405765,5242.37,2259.77,0.49,0.62,2.0499999999999998]
["Reynosa","Tamaulipas","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A99,$F$132:$G$163,2,0)+VLOOKUP(D99,$H$132:$I$135,2,0)","v":251},1442.96,478.9,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,267.25,2113.5700000000002,478.9,360.5,3172.9552649999996,640.26220000000001,530.25,3512.0660879999996,697.34839999999997,585.34,9913.5837389999997,2265.5691999999999,1693.58,10822.759533,2863.1178,1903.1,0.38,0.23,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A99,$F$132:$G$163,2,0)+VLOOKUP(D100,$H$132:$I$135,2,0)","v":252},1317.46,601.20000000000005,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"1 cm de Remetimiento en la ventana al Este",11786.64,169,6,266.8,2038.78,605.78,367.74,2529.8512350000001,1074.3824,501.19,3436.3373850000003,1181.9936,642.21,8967.8059499999999,3943.0085999999997,1795.33,11111.008173000002,4896.1027999999997,2225.89,0.41,0.57999999999999996,1.76]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A99,$F$132:$G$163,2,0)+VLOOKUP(D101,$H$132:$I$135,2,0)","v":253},1443.05,470.85,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,266.14,2117.5,470.85,359.93,3068.9345520000002,777.08860000000004,534.80999999999995,3521.0738580000002,892.79319999999996,613.77,9938.3614500000003,2597.8310000000001,1743.23,10847.549931,3250.2285999999999,1960.38,0.38,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A99,$F$132:$G$163,2,0)+VLOOKUP(D102,$H$132:$I$135,2,0)","v":254},1318.49,603.34,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"1 cm de Remetimiento en la ventana al Este",11786.64,169,6,267.24,2039.92,608.13,368.23,2467.7356829999999,1086.4708000000001,494.23,3451.4476020000002,1197.4660000000001,646.46,8537.5770929999999,3970.8514000000005,1739.37,11152.570785,4927.8278,2236.08,0.41,0.62,2.04]
["Nuevo Laredo","Tamaulipas","1E","Norte","Aislada",1,0.71399999999999997,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A103,$F$132:$G$163,2,0)+VLOOKUP(D103,$H$132:$I$135,2,0)","v":261},1502.55,478.9,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,275.52999999999997,2207.06,478.9,373.5,3295.75191,640.26220000000001,547.33000000000004,3647.986672,697.34839999999997,604.24,10297.249666,2265.5691999999999,1746.94,11241.611502,2863.1178,1961.35,0.4,0.23,0.88]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A103,$F$132:$G$163,2,0)+VLOOKUP(D104,$H$132:$I$135,2,0)","v":262},1389.37,568.77,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"8 cm de Remetimiento en la ventana al Oeste",11786.64,{"$f":"ROUND(Y104*0.0143,0)","v":169},{"$f":"ROUND(Y104*0.0005,0)","v":6},{"$f":"ROUND(((SUM(L104:M104)/3517)*858)*0.57,2)","v":272.29000000000002},2133.9899999999998,605.78,380.98,2627.75909,1074.3824,514.80999999999995,3569.3271900000004,1181.9936,660.7,9314.8693000000003,3943.0085999999997,1843.59,11541.015662000002,4896.1027999999997,2285.6799999999998,0.45,0.6,1.81]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A103,$F$132:$G$163,2,0)+VLOOKUP(D105,$H$132:$I$135,2,0)","v":263},1505.53,470.85,0,0,1,0,1,0,0,21.006,0,18.768699999999999,"No Aplica",7730.61,111,4,274.83,2217.71,470.85,373.86,3187.7054880000001,777.08860000000004,551.33000000000004,3657.3430520000002,892.79319999999996,632.72,10322.9863,2597.8310000000001,1796.72,11267.361314,3250.2285999999999,2018.76,0.41,0.33,0.91]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A103,$F$132:$G$163,2,0)+VLOOKUP(D106,$H$132:$I$135,2,0)","v":264},1392.09,569.47,1,0,1,0,1,37.950000000000003,0,11.6768,0,11.828799999999999,"8 cm de Remetimiento en la ventana al Este",11786.64,169,6,272.77,2136.94,608.13,381.72,2563.2396020000001,1086.4708000000001,507.51,3585.0221879999999,1197.4660000000001,665.03,8867.9901420000006,3970.8514000000005,1785.32,11584.18679,4927.8278,2296.09,0.45,0.65,2.09]
["Mexicali","Baja California","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A107,$F$132:$G$163,2,0)+VLOOKUP(D107,$H$132:$I$135,2,0)","v":271},1911.9,306.70999999999998,2,0,2,0,0,39.729999999999997,0,17.296600000000002,0,0,"19 cm de remetimiento en ventanas al Norte y Sur; 22 cm de remetimiento en ventana al Oeste",13660.69,195,7,308.51,3475.75,401.22,539.12,3425.8013099999998,681.13,571.09,3791.935152,741.86,630.45000000000005,10703.576106,2410.1799999999998,1823.55,11685.202182000001,3045.87,2048.44,0.95,0.24,0.92]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A107,$F$132:$G$163,2,0)+VLOOKUP(D108,$H$132:$I$135,2,0)","v":272},1723.76,423.53,1,0,2,0,2,39.729999999999997,0,13.7056,0,11.053699999999999,"22 cm de remetimiento en ventanas al Este, 18 cm de remetimiento en ventana al  Oeste y 14 cm de remetimiento en ventana al Norte.",13792.52,197,7,298.58999999999997,3389.34,535.09,545.72,2731.4496899999999,1142.96,538.76,3710.1717900000003,1257.44,690.78,9682.4313000000002,4194.6899999999996,1929.7,11996.420742000002,5208.62,2392.46,1.01,0.62,1.9]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A107,$F$132:$G$163,2,0)+VLOOKUP(D109,$H$132:$I$135,2,0)","v":273},1861.27,408.74,2,0,2,0,0,39.729999999999997,0,17.296600000000002,0,0,"19 cm de remetimiento en ventanas al Sur y Norte; 22 cm de remetimiento en ventana al Este",13660.69,195,7,315.66000000000003,3484.55,550.63,561.12,3313.4914079999999,826.69,575.72,3801.6607320000003,949.78,660.72,10730.328300000001,2763.65,1876.42,11711.968073999999,3457.69,2109.4299999999998,1.01,0.35,0.96]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A107,$F$132:$G$163,2,0)+VLOOKUP(D110,$H$132:$I$135,2,0)","v":274},1737.08,485.98,1,0,2,0,2,39.729999999999997,0,13.7056,0,11.053699999999999,"22 cm de remetimiento en ventanas al Oeste, 18 cm de remetimiento en ventana al  Este y 14 cm de remetimiento en ventana al Sur.",13792.52,197,7,309.13,3418.47,614.15,560.76,2664.384282,1155.82,531.22,3726.4861080000001,1273.9000000000001,695.33,9217.9184220000006,4224.3100000000004,1869.22,12041.295389999999,5242.37,2403.4,1.03,0.67,2.19]
["Hermosillo","Sonora","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A111,$F$132:$G$163,2,0)+VLOOKUP(D111,$H$132:$I$135,2,0)","v":281},1697.46,312.95,1,0,1.5,0,0,38.65,0,18.129799999999999,0,0,"22 cm de remetimiento en ventanas al Sur y al Norte",11381.48,163,6,279.56,2608.1,434.68,423.12,3219.7230299999997,681.13,542.44000000000005,3563.8321759999999,741.86,598.73,10059.704978,2410.1799999999998,1734.01,10982.281566,3045.87,1950.7,0.59,0.23,0.89]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A111,$F$132:$G$163,2,0)+VLOOKUP(D112,$H$132:$I$135,2,0)","v":282},1237.8,753.83,2,0,1,1,1,38.65,0,12.282,18.129799999999999,10.045199999999999,"No Aplica",16914.669999999998,242,8,276.95,2523.69,753.83,455.76,2567.1399700000002,1142.96,515.91,3486.9872700000001,1257.44,659.74,9099.9868999999999,4194.6899999999996,1848.7,11274.778846000001,5208.62,2292.12,0.73,0.59,1.82]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A111,$F$132:$G$163,2,0)+VLOOKUP(D113,$H$132:$I$135,2,0)","v":283},1649.07,410.39,1,0,1.5,0,0,38.65,0,18.129799999999999,0,0,"22 cm de remetimiento en ventanas al Sur y al Norte",11381.48,163,6,286.38,2622.03,554.23,441.68,3114.1691040000001,826.69,548,3572.9727160000002,949.78,628.91999999999996,10084.847900000001,2763.65,1786.66,11007.437361999999,3457.69,2011.46,0.64,0.33,0.92]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A111,$F$132:$G$163,2,0)+VLOOKUP(D114,$H$132:$I$135,2,0)","v":284},1227.3800000000001,775.65,2,0,1,1,1,38.65,0,12.282,18.129799999999999,10.045199999999999,"No Aplica",16914.669999999998,242,8,278.52999999999997,2549.4299999999998,775.65,462.37,2504.108866,1155.82,508.94,3502.3202040000001,1273.9000000000001,664.16,8663.4166860000005,4224.3100000000004,1792.12,11316.95407,5242.37,2302.67,0.75,0.64,2.09]
["Ciudad Obregón","Sonora","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A115,$F$132:$G$163,2,0)+VLOOKUP(D115,$H$132:$I$135,2,0)","v":291},1345.87,408.79,1,0,1,0,0,38.65,0,18.129799999999999,0,0,"9 cm de remetimiento en ventana al Sur.",10874.94,156,5,244,2028.15,434.68,342.47,2815.0693199999996,681.13,486.17,3115.9309439999997,741.86,536.45000000000005,8795.4046319999998,2410.1799999999998,1558.2,9602.0321039999999,3045.87,1758.77,0.4,0.21,0.82]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A115,$F$132:$G$163,2,0)+VLOOKUP(D116,$H$132:$I$135,2,0)","v":292},1069.04,688.83,2,0,2,0,2,38.65,0,12.282,0,10.045199999999999,"11 cm de remetimiento en ventanas al Este.",14674.77,210,7,244.44,1960.64,753.83,377.46,2244.5026800000001,1142.96,471.05,3048.74388,1257.44,598.79999999999995,7956.3036000000002,4194.6899999999996,1689.67,9857.7684240000017,5208.62,2095.0700000000002,0.55000000000000004,0.52,1.66]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A115,$F$132:$G$163,2,0)+VLOOKUP(D117,$H$132:$I$135,2,0)","v":293},1289.8,540.29999999999995,1,0,1,0,0,38.65,0,18.129799999999999,0,0,"9 cm de remetimiento en ventana al Norte.",10874.94,156,5,254.49,2025.79,554.23,358.77,2722.7813759999999,826.69,493.58,3123.9227040000001,949.78,566.47,8817.3876,2763.65,1610.41,9624.0263279999999,3457.69,1819.09,0.43,0.3,0.86]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A115,$F$132:$G$163,2,0)+VLOOKUP(D118,$H$132:$I$135,2,0)","v":294},1071.53,708.61,2,0,2,0,2,38.65,0,12.282,0,10.045199999999999,"11 cm de remetimiento en ventanas al Oeste.",14674.77,210,7,247.54,1972.98,775.65,382.21,2189.3933039999997,1155.82,465.17,3062.1497760000002,1273.9000000000001,602.95000000000005,7574.6013840000005,4224.3100000000004,1640.71,9894.6430799999998,5242.37,2104.89,0.55000000000000004,0.56000000000000005,1.9]
["Culiacán","Sinaloa","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A119,$F$132:$G$163,2,0)+VLOOKUP(D119,$H$132:$I$135,2,0)","v":301},1384.58,347.15,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"2cm de Remetimiento en ventanas al Norte",6348.34,91,3,240.81,2206.38,352.13,355.78,2877.0928799999997,681.13,494.79,3184.5832959999998,741.86,546,8989.1910879999996,2410.1799999999998,1585.15,9813.5907360000001,3045.87,1788.19,0.47,0.21,0.83]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A119,$F$132:$G$163,2,0)+VLOOKUP(D120,$H$132:$I$135,2,0)","v":302},1202.27,556.80999999999995,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"12cm de Remetimiento en ventanas al Este",11690.88,167,6,244.61,2149.91,614.36,384.39,2293.9551200000001,1142.96,477.92,3115.9159200000004,1257.44,608.14,8131.6023999999998,4194.6899999999996,1714.05,10074.961616000001,5208.62,2125.27,0.56999999999999995,0.53,1.69]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A119,$F$132:$G$163,2,0)+VLOOKUP(D121,$H$132:$I$135,2,0)","v":303},1385.42,391.42,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"2cm de Remetimiento en ventanas al Sur",6348.34,91,3,247.08,2206.85,402.05,362.78,2782.7715840000001,826.69,501.92,3192.7511360000003,949.78,576.04,9011.6584000000003,2763.65,1637.43,9836.069551999999,3457.69,1848.58,0.47,0.3,0.87]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A119,$F$132:$G$163,2,0)+VLOOKUP(D122,$H$132:$I$135,2,0)","v":304},1203.3,557.92999999999995,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"12cm de Remetimiento en ventanas al Oeste",11690.88,167,6,244.91,2153.44,617.29999999999995,385.29,2237.6315359999999,1155.82,471.88,3129.6171840000002,1273.9000000000001,612.34,7741.490256,4224.3100000000004,1663.92,10112.648719999999,5242.37,2135.21,0.57999999999999996,0.57999999999999996,1.93]
["Guasave","Sinaloa","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A123,$F$132:$G$163,2,0)+VLOOKUP(D123,$H$132:$I$135,2,0)","v":311},1479.76,332.11,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"8 cm de Remetimiento en ventanas al Norte",6348.34,91,3,251.95,2316.35,352.13,371.07,3036.1532999999999,681.13,516.91,3360.6433599999996,741.86,570.48,9486.1595799999996,2410.1799999999998,1654.26,10356.136259999999,3045.87,1863.63,0.49,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A123,$F$132:$G$163,2,0)+VLOOKUP(D124,$H$132:$I$135,2,0)","v":312},1317.41,512.83000000000004,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"21 cm de Remetimiento en ventanas al Este",11690.88,167,6,254.51,2299.98,614.36,405.26,2420.7766999999999,1142.96,495.56,3288.1797000000001,1257.44,632.1,8581.1589999999997,4194.6899999999996,1776.56,10631.957060000001,5208.62,2202.73,0.62,0.56000000000000005,1.75]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A123,$F$132:$G$163,2,0)+VLOOKUP(D125,$H$132:$I$135,2,0)","v":313},1482.51,359.5,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"8 cm de Remetimiento en ventanas al Sur",6348.34,91,3,256.14,2318.73,402.05,378.34,2936.61744,826.69,523.30999999999995,3369.2627600000001,949.78,600.59,9509.8690000000006,2763.65,1706.71,10379.857819999999,3457.69,1924.19,0.5,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A123,$F$132:$G$163,2,0)+VLOOKUP(D126,$H$132:$I$135,2,0)","v":314},1318.28,512.57000000000005,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"21 cm de Remetimiento en ventanas al Oeste",11690.88,167,6,254.59,2303.35,617.29999999999995,406.13,2361.3392599999997,1155.82,489.08,3302.6384400000002,1273.9000000000001,636.4,8169.4794600000005,4224.3100000000004,1723.43,10671.727699999999,5242.37,2212.9499999999998,0.62,0.6,2.0099999999999998]
["Los Mochis","Sinaloa","1F","Norte","Aislada",1,0.625,"Block 15cm","Vigueta y Bovedilla",null,{"$f":"VLOOKUP(A127,$F$132:$G$163,2,0)+VLOOKUP(D127,$H$132:$I$135,2,0)","v":321},1479.76,332.11,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"8 cm de Remetimiento en ventanas al Norte",6348.34,91,3,251.95,2316.35,352.13,371.07,3036.1532999999999,681.13,516.91,3360.6433599999996,741.86,570.48,9486.1595799999996,2410.1799999999998,1654.26,10356.136259999999,3045.87,1863.63,0.49,0.22,0.86]
[null,null,null,"Este",null,null,null,null,null,null,{"$f":"VLOOKUP(A127,$F$132:$G$163,2,0)+VLOOKUP(D128,$H$132:$I$135,2,0)","v":322},1317.41,512.83000000000004,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"21 cm de Remetimiento en ventanas al Este",11690.88,167,6,254.51,2299.98,614.36,405.26,2420.7766999999999,1142.96,495.56,3288.1797000000001,1257.44,632.1,8581.1589999999997,4194.6899999999996,1776.56,10631.957060000001,5208.62,2202.73,0.62,0.56000000000000005,1.75]
[null,null,null,"Sur",null,null,null,null,null,null,{"$f":"VLOOKUP(A127,$F$132:$G$163,2,0)+VLOOKUP(D129,$H$132:$I$135,2,0)","v":323},1482.51,359.5,0,0,1,0,1,0,0,16.331399999999999,0,16.331399999999999,"8 cm de Remetimiento en ventanas al Sur",6348.34,91,3,256.14,2318.73,402.05,378.34,2936.61744,826.69,523.30999999999995,3369.2627600000001,949.78,600.59,9509.8690000000006,2763.65,1706.71,10379.857819999999,3457.69,1924.19,0.5,0.32,0.89]
[null,null,null,"Oeste",null,null,null,null,null,null,{"$f":"VLOOKUP(A127,$F$132:$G$163,2,0)+VLOOKUP(D130,$H$132:$I$135,2,0)","v":324},1318.28,512.57000000000005,1,0,1,0,1,38,0,11.769500000000001,0,11.1945,"21 cm de Remetimiento en ventanas al Oeste",11690.88,167,6,254.59,2303.35,617.29999999999995,406.13,2361.3392599999997,1155.82,489.08,3302.6384400000002,1273.9000000000001,636.4,8169.4794600000005,4224.3100000000004,1723.43,10671.727699999999,5242.37,2212.9499999999998,0.62,0.6,2.0099999999999998]
[null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]
["Arriaga","Chiapas","1C",0.71399999999999997,null,"Cabo San Lucas",10,"Norte",1]
["Cabo San Lucas","Baja California Sur","1C",0.71399999999999997,null,"Campeche",20,"Este",2]
["Campeche","Campeche","1C",0.71399999999999997,null,"Ciudad del Carmen",30,"Sur",3]
["Cancun","Quintana Roo","1C",0.71399999999999997,null,"Arriaga",40,"Oeste",4]
["Ciudad del Carmen","Campeche","1C",0.71399999999999997,null,"Ciudad Juarez",50]
["Ciudad Juarez","Chihuahua","1C",0.83299999999999996,null,"Torreon",60]
["Ciudad Obregón","Sonora","1F",0.625,null,"Lerdo",70]
["Ciudad Valles","San Luis Potosi","1D",0.71399999999999997,null,"Monterrey",80]
["Ciudad Victoria","Tamaulipas","1C",0.71399999999999997,null,"Salina Cruz",90]
["Coatzacoalcos","Veracruz","1C",0.71399999999999997,null,"Cancun",100]
["Comalcalco","Tabasco","1C",0.71399999999999997,null,"Comalcalco",110]
["Culiacán","Sinaloa","1F",0.625,null,"Ciudad Victoria",120]
["Guasave","Sinaloa","1F",0.625,null,"Tampico",130]
["Guaymas","Sonora","1E",0.71399999999999997,null,"Coatzacoalcos",140]
["Hermosillo","Sonora","1F",0.625,null,"Veracruz",150]
["La Paz","Baja California Sur","1E",0.71399999999999997,null,"Monclova",160]
["Lerdo","Durango","1C",0.71399999999999997,null,"Ciudad Valles",170]
["Los Mochis","Sinaloa","1F",0.625,null,"Mazatlán",180]
["Matamoros","Tamaulipas","1D",0.71399999999999997,null,"Villahermosa",190]
["Mazatlán","Sinaloa","1D",0.71399999999999997,null,"Matamoros",200]
["Mexicali","Baja California","1F",0.625,null,"La Paz",210]
["Monclova","Coahuila","1D",0.71399999999999997,null,"Piedras Negras",220]
["Monterrey","Nuevo León","1C",0.71399999999999997,null,"Guaymas",230]
["Navojoa","Sonora","1E",0.71399999999999997,null,"Navojoa",240]
["Nuevo Laredo","Tamaulipas","1E",0.71399999999999997,null,"Reynosa",250]
["Piedras Negras","Coahuila","1E",0.71399999999999997,null,"Nuevo Laredo",260]
["Reynosa","Tamaulipas","1E",0.71399999999999997,null,"Mexicali",270]
["Salina Cruz","Oaxaca","1C",0.71399999999999997,null,"Hermosillo",280]
["Tampico","Tamaulipas","1C",0.71399999999999997,null,"Ciudad Obregón",290]
["Torreon","Coahuila","1C",0.71399999999999997,null,"Culiacán",300]
["Veracruz","Veracruz","1C",0.71399999999999997,null,"Guasave",310]
["Villahermosa","Tabasco","1D",0.71399999999999997,null,"Los Mochis",320]
[]
[]
[]
["1C","1D","1E","1F",1,{"$f":"Principal!B4","v":"1C"},{"$f":"Principal!E4","v":"Cabo San Lucas"}]
["Arriaga","Ciudad Valles","Guaymas","Ciudad Obregón",2,{"$f":"HLOOKUP($F$167,$A$167:$D$182,E168,0)","v":"Arriaga"},{"$f":"IF($G$167=F168,1,0)","v":0}]
["Cabo San Lucas","Matamoros","La Paz","Culiacán",3,"Cabo San Lucas",1]
["Campeche","Mazatlán","Navojoa","Guasave",4,"Campeche",0]
["Cancun","Monclova","Nuevo Laredo","Hermosillo",5,"Cancun",0]
["Ciudad del Carmen","Villahermosa","Piedras Negras","Los Mochis",6,"Ciudad del Carmen",0]
["Ciudad Juarez",null,"Reynosa","Mexicali",7,"Ciudad Juarez",0]
["Ciudad Victoria",null,null,null,8,"Ciudad Victoria",0]
["Coatzacoalcos",null,null,null,9,"Coatzacoalcos",0]
["Comalcalco",null,null,null,10,"Comalcalco",0]
["Lerdo",null,null,null,11,"Lerdo",0]
["Monterrey",null,null,null,12,"Monterrey",0]
["Salina Cruz",null,null,null,13,"Salina Cruz",0]
["Tampico",null,null,null,14,"Tampico",0]
["Torreon",null,null,null,15,"Torreon",0]
["Veracruz",null,null,null,16,"Veracruz",0]
[null,null,null,null,null,"Total",{"$f":"IF(F167=0,0,SUM(G168:G182))","v":1},{"$f":"IF(AND(F167=0,G183=0),1,IF(AND(OR(F167=A167,F167=B167,F167=C167,F167=D167),G183=0),2,0))","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Vertical Fachada Principal al:"]
[null,null,null,1,null,"Norte","Este","Sur","Oeste"]
[null,null,null,2,"Cubierta",2,1,2,1]
[null,null,null,3,"Norte","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,4,"Este","Sin Aislante","Sin Aislante","Sin Aislante",1]
[null,null,null,5,"Sur","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,6,"Oeste","Sin Aislante",1,"Sin Aislante","Sin Aislante"]
[null,null,null,7,"CS","11 cms de remetimiento en todas las ventanas","13 cms de remetimiento en todas las ventanas","11 cms de remetimiento en todas las ventanas","13 cms de remetimiento en todas las ventanas"]
[]
[null,null,null,null,null,"Adosada Fachada Principal al:"]
[null,null,null,1,null,"Norte","Este","Sur","Oeste"]
[null,null,null,2,"Cubierta","Sin Aislante",1,"Sin Aislante",1]
[null,null,null,3,"Norte","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,4,"Este","Sin Aislante","Sin Aislante",1,1]
[null,null,null,5,"Sur","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,6,"Oeste",1,1,"Sin Aislante","Sin Aislante"]
[null,null,null,7,"CS","19 cms de remetimiento en ventanas sin elementos sombreantes","18 cms de remetimiento en ventanas sin elementos sombreantes","19 cms de remetimiento en ventanas sin elementos sombreantes","18 cms de remetimiento en ventanas sin elementos sombreantes"]
[]
[null,null,null,null,null,"Adosada Fachada Principal al:"]
[null,null,null,1,null,"Norte","Este","Sur","Oeste"]
[null,null,null,2,"Cubierta","Sin Aislante",80.91,"Sin Aislante",80.91]
[null,null,null,3,"Norte","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,4,"Este","Sin Aislante","Sin Aislante",29.09,19.876000000000001]
[null,null,null,5,"Sur","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,6,"Oeste",29.09,19.876000000000001,"Sin Aislante","Sin Aislante"]
[]
[null,null,null,null,null,"Vertical Fachada Principal al:"]
[null,null,null,1,null,"Norte","Este","Sur","Oeste"]
[null,null,null,2,"Cubierta",87.27,87.27,87.27,87.27]
[null,null,null,3,"Norte","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,4,"Este","Sin Aislante","Sin Aislante","Sin Aislante",121.4152]
[null,null,null,5,"Sur","Sin Aislante","Sin Aislante","Sin Aislante","Sin Aislante"]
[null,null,null,6,"Oeste","Sin Aislante",121.4152,"Sin Aislante","Sin Aislante"]