{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["PROGRAMA HLM-60_200","HOJA_RESULTADOS","1_vano_sin_armadura_adicional","mallazo_antifisurac_sin_puntal","mallazo_antifisurac_con_puntal","cargas_de_encofrado","heficaz_mínimo","2_vanos_sin_armadura_adicional","casos de 2 vanos particulares"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":50,"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":"PROGRAMA HLM-60_200","index":0,"n_rows":94,"n_cols":44,"rows_kept":94,"cut":false,"hidden":false,"merged":[[24,3,24,11],[14,10,14,11],[15,10,15,11],[1,30,1,34],[15,27,15,29],[15,8,15,9],[8,17,9,17],[5,8,9,8],[5,9,9,14],[12,8,12,9],[12,15,12,17],[23,15,24,17],[12,5,12,6],[19,3,19,4],[14,8,14,9],[17,3,17,4],[15,15,15,16],[16,15,16,16],[21,8,21,9],[22,8,22,9],[17,5,17,6],[21,15,21,16],[22,15,22,16],[18,15,18,17],[16,5,16,6],[19,10,19,11],[18,8,18,11],[16,3,16,4],[15,5,15,6],[15,3,15,4],[19,8,20,9],[17,8,17,11],[12,10,12,11],[13,10,13,11],[2,1,2,3],[5,3,5,4],[10,3,10,6],[14,3,14,4],[11,3,11,4],[13,3,13,4],[11,5,11,6],[13,5,13,6],[1,5,2,16],[1,4,2,4],[1,1,1,3],[8,5,8,6],[8,15,9,16],[13,15,13,16],[14,15,14,16],[7,15,7,16],[5,15,5,16],[6,5,7,6],[7,3,7,4],[93,3,93,6],[12,3,12,4],[5,5,5,6],[6,3,6,4],[14,5,14,6],[11,8,11,11],[74,36,74,43],[62,34,62,35],[39,34,39,35],[63,34,63,35],[69,32,69,33],[27,34,27,35],[33,34,33,35],[46,27,47,37],[44,27,44,29],[44,30,44,31],[29,27,29,29],[35,27,35,29],[33,27,33,29],[71,27,71,29],[53,30,53,31],[55,30,55,31],[55,28,55,29],[68,27,68,31],[48,27,49,29],[51,30,51,31],[41,28,41,29],[37,30,39,30],[51,28,51,29],[53,28,53,29],[37,28,39,29],[9,27,9,29],[11,27,11,29],[13,27,13,29],[37,27,43,27],[31,27,31,29],[43,28,43,29],[32,27,32,29],[5,45,5,47],[19,15,20,16],[19,17,20,17],[5,48,5,54],[6,48,6,50],[6,52,6,54],[6,36,7,36],[17,36,19,36],[17,27,17,29],[17,30,19,30],[17,34,19,35],[6,29,6,30],[6,27,6,28],[5,29,5,30],[8,27,8,29],[8,30,9,30],[6,34,7,35],[6,43,7,43]]}
[]
[null,"Versión 2.2",null,null,null," PROGRAMA PARA CÁLCULO CON                                                                                                                            LOSA MIXTA HLM-60/220"]
[null,{"$f":"NOW()","v":"2011-02-16T11:50:03.350"}]
[null,null,"DATOS DE ENTRADA"]
[]
[null,null,null,"TIPOLOGÍA DE LOSA MIXTA",null,"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA",null,null,"RESISTENCIA AL FUEGO NORMALIZADO",null,null,null,null,null,null,"ALTURA DEL PAVIMENTO                                                        h3 (mm)",null,0]
[null,null,null,"SOBRECARGA ÚTIL ACTUANTE                                                          (daN/m2)                                                          ",null,1000,null,null,null,null,null,null,null,null,null,{"$f":"IF(R7=\"VER RANGO DE VALORES\",\"RANGO DE VALORES\",\"----\")","v":"----"},{"$f":"IF(R7=\"VER RANGO DE VALORES\",\"MÍN=0 mm  MÁX=50 mm\",\"----\")","v":"----"},{"$f":"IF(R6<0,\"VER RANGO DE VALORES\",IF(R6>50,\"VER RANGO DE VALORES\",\"----\"))","v":"----"}]
[null,null,null,"SOBRECARGA DE USO + CARGAS MUERTAS + TABIQUERÍA",null,null,null,null,null,null,null,null,null,null,null,"RESISTENCIA AL FUEGO                                            NORMALIZADO NECESARIA",null,"R30"]
[null,null,null,{"$f":"IF(F9=\"VER RANGO DE VALORES\",\"RANGO DE VALORES\",\"----\")","v":"----"},{"$f":"IF(F9=\"VER RANGO DE VALORES\",\"MÍN:100 daN/m2                                                                                               MÁX:4.000 daN/m2\",\"----\")","v":"----"},{"$f":"IF(F7<100,\"VER RANGO DE VALORES\",IF(F7>4000,\"VER RANGO DE VALORES\",\"----\"))","v":"----"},null,null,null,null,null,null,null,null,null,"SEPARACIÓN DE LA ARMADURA                             ADICIONAL (mm)",null,220]
[]
[null,null,null,"MATERIALES"]
[null,null,null,"COEFICIENTE DE SEGURIDAD DEL                                                        ACERO  ( γs)",null,1.1499999999999999,null,null,"GEOMETRÍA DE LA LOSA",null,null,null,null,null,"RESULTADOS"]
[null,null,null,"COEFICIENTE DE SEGURIDAD DEL                                                  HORMIGÓN   (γc)",null,1.5,null,null,"LUZ   (m)",null,1.4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P15=\"MALLA ANTIFISURACIÓN (mm)\",IF(R14=HOJA_RESULTADOS!$K$3,HOJA_RESULTADOS!$M$3,IF(R14=HOJA_RESULTADOS!$K$4,HOJA_RESULTADOS!$M$4)))","v":false}]
[null,null,null,"TIPO DE ACERO DE LA                                                           PLACA NERVADA",null,"S250GD",null,null,{"$f":"IF(K13<0.5,\"RANGO DE VALORES\",IF(K13>5,\"RANGO DE VALORES\",\"----\"))","v":"----"},{"$f":"IF(K13<0.5,\"MÍN:0,5 m MÁX:5,0 m\",IF(K13>5,\"MÍN:0,5 m MÁX:5,0 m\",\"----\"))","v":"----"},{"$f":"IF(K13<0.5,\"VER RANGO DE VALORES\",IF(K13>5,\"VER RANGO DE VALORES\",\"----\"))","v":"----"},null,null,null,null,"¿COLOCACIÓN DE PUNTAL                                               INTERMEDIO?",null,{"$f":"IF($F$6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",HOJA_RESULTADOS!$I$17,IF($F$6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",W19))","v":"NO"}]
[null,null,null,"RESISTENCIA CARACTERÍSTICA DEL HORMIGÓN A 20ºC                                                                                       (más común: 25 N/mm2)             ",null,25,null,null,"ESPESOR DE LA PLACA                                                     NERVADA   (mm)",null,0.8,null,null,null,null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",\"MALLA ANTIFISURACIÓN (mm)\",IF(F6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",\"MALLA DE ARMADURA NEGATIVA (mm)\"))","v":"MALLA DE ARMADURA NEGATIVA (mm)"},null,{"$f":"IF(P15=\"MALLA ANTIFISURACIÓN (mm)\",V13,IF(P15=\"MALLA DE ARMADURA NEGATIVA (mm)\",V15))","v":"Datos de Entrada"},null,null,null,{"$f":"IF(P15=\"MALLA DE ARMADURA NEGATIVA (mm)\",\"Datos de Entrada\")","v":"Datos de Entrada"}]
[null,null,null,"LÍMITE ELÁSTICO DEL ACERO                                                     CORRUGADO A 20ºC (N/mm2)",null,500,null,null,"ALTURA DE LA LOSA DE                                                       HORMIGÓN    H (cm)",null,8,null,null,null,null,"SOBRECARGA ÚTIL RESISTENTE                                                         (daN/m2)",null,{"$f":"IF(P15=\"MALLA ANTIFISURACIÓN (mm)\",V17,IF(P15=\"MALLA DE ARMADURA NEGATIVA (mm)\",MAX(U19:V19)))","v":2909.1157600556344}]
[null,null,null,"TIPO DE CEMENTO                                               (valor más común: 2)",null,2,null,null,null,null,null,null,null,null,null,"¿SOLUCIÓN VÁLIDA?",null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",V22,IF(F6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",V23))","v":"SI"},null,null,null,{"$f":"IF(F9=\"----\",HOJA_RESULTADOS!$K$17,\" -- \")","v":2615},{"$f":"IF(F9=\"----\",'1_vano_sin_armadura_adicional'!$E$216,\" -- \")","v":"SI"}]
[null,null,null,"HUMEDAD RELATIVA                                                                (valor más común 50%)",null,50,null,null,"MALLA DE ARMADURA DE NEGATIVOS"]
[null,null,null,null,null,null,null,null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",\"NO RELLENAR ESTAS CUADRÍCULAS EN ESTA SOLUCIÓN DE LOSA\",\"ELEGIR MALLA DE LA OPCIÓN SOMBREADA\")","v":"ELEGIR MALLA DE LA OPCIÓN SOMBREADA"},null,null,null,null,null,null,"RESISTENCIA AL FUEGO NORMALIZADO",null,null,null,null,{"$f":"IF(Q29=TRUE,P29,IF(Q30=TRUE,P30,IF(Q31=TRUE,P31,IF(Q32=TRUE,P32,IF(Q33=TRUE,P33,IF(Q34=TRUE,P34,IF(Q35=TRUE,P35,IF(Q36=TRUE,P36,IF(Q37=TRUE,P37,IF(Q38=TRUE,P38,IF(Q39=TRUE,P39,IF(Q40=TRUE,P40,IF(Q41=TRUE,P41,IF(Q42=TRUE,P42,IF(Q43=TRUE,P43,IF(Q44=TRUE,P44,IF(Q45=TRUE,P45,IF(Q46=TRUE,P46,IF(Q47=TRUE,P47,IF(Q48=TRUE,P48,IF(Q49=TRUE,P49,IF(Q50=TRUE,P50,IF(Q51=TRUE,P51,IF(Q52=TRUE,P52,IF(Q53=TRUE,P53,IF(Q54=TRUE,P54,IF(Q55=TRUE,P55,IF(Q56=TRUE,P56,IF(Q57=TRUE,P57,IF(Q58=TRUE,P58,IF(Q59=TRUE,P59,IF(Q60=TRUE,P60,IF(Q61=TRUE,P61,IF(Q62=TRUE,P62,IF(Q67=TRUE,P67,IF(Q68=TRUE,P68,IF(Q69=TRUE,P69,IF(Q70=TRUE,P70,IF(Q71=TRUE,P71,IF(Q72=TRUE,P72))))))))))))))))))))))))))))))))))))))))","v":false},{"$f":"IF(F9=\"----\",'2_vanos_sin_armadura_adicional'!C270,\" -- \")","v":2909.1157600556344},{"$f":"IF(F9=\"----\",'2_vanos_sin_armadura_adicional'!$B$299,\" -- \")","v":"NO"},null,null,null,{"$f":"ISTEXT(AA20)","v":false},{"$f":"ISTEXT(AB20)","v":false}]
[null,null,null," ",null,null,null,null,"MALLA DE ARMADURA DE                                                         NEGATIVOS",null,{"$f":"IF(P15=\"MALLA ANTIFISURACIÓN (mm)\",\"NO\",IF(P15=\"MALLA DE ARMADURA NEGATIVA (mm)\",\"SI\"))","v":"SI"},null,null,null,null,"¿SE CUMPLE EL CRITERIO DE                                                            AISLAMIENTO TÉRMICO?",null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",V28,IF(F6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",V30))","v":"SI"},null,null,null,null,null,4,{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=4,IF(K15=1.2,IF(K13=1.4,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=1.8,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=2,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=2.2,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=2.4,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=2.6,\"150 x 150 x 5\",IF(K16=4,IF(K15=1.2,IF(K13=2.8,\"150 x 150 x 5\"))))))))))))))))))))))","v":false},{"$f":"ISTEXT(Y20)","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=4,IF(K15=1,IF(K13=1.6,\"150 x 150 x 8\"))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=4,IF(K15=1.2,IF(K13=1.6,\"150 x 150 x 5\"))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,"Elección de Malla","Malla a Utilizar"]
[null,null,null,null,null,null,null,null,"MALLA DE ARMADURA NEGATIVA (sin puntal)",null,"200 x 200 x 8",{"$f":"IF(Z20=TRUE,Y20,IF(AA19=TRUE,AA20,IF(AB19=TRUE,AB20,IF(Z22=TRUE,Y22,IF(Z23=TRUE,Y23,IF(AA22=TRUE,AA23,IF(AB22=TRUE,AB23,IF(AC22=TRUE,AC23,IF(AD22=TRUE,AD23,IF(AE22=TRUE,AE23,IF(AF22=TRUE,AF23,IF(Z25=TRUE,Y25,IF(AA28=TRUE,AA25,IF(AB28=TRUE,AB25,IF(AC28=TRUE,AC25,IF(AD28=TRUE,AD25,IF(AE28=TRUE,AE25,IF(Z28=TRUE,Y28,K22))))))))))))))))))","v":"200 x 200 x 8"},null,null,null,"¿ES NECESARIO COLOCAR                                                                                ARMADURA ADICIONAL?",null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",'1_vano_sin_armadura_adicional'!$B$300,IF(F6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",'2_vanos_sin_armadura_adicional'!B361))","v":"NO"},null,null,null,{"$f":"IF(F9=\"----\",'1_vano_sin_armadura_adicional'!$E$216,\" -- \")","v":"SI"},null,6,{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=6,IF(K15=1.2,IF(K13=2.8,\"150 x 150 x 6\",IF(K16=6,IF(K15=1.2,IF(K13=3.2,\"200 x 200 x 10\",IF(K16=6,IF(K15=1.2,IF(K13=3.4,\"200 x 200 x 10\",IF(K16=6,IF(K15=1.2,IF(K13=3.6,\"200 x 200 x 10\")))))))))))))","v":false},{"$f":"ISTEXT(Y22)","v":false},{"$f":"ISTEXT(AA23)","v":false},{"$f":"ISTEXT(AB23)","v":false},false,false,false,false]
[null,null,null,null,null,null,null,null,"MALLA DE ARMADURA NEGATIVA (con puntal)",null,null,{"$f":"(K23)","v":0},null,null,null,"DIÁMETRO DE LA ARMADURA                                                                   ADICIONAL (mm)",null,{"$f":"IF(F6=\"1 VANO SIN ARMADURA ADICIONAL POSITIVA\",V34,IF(F6=\"2 Ó MÁS VANOS SIN ARMADURA ADICIONAL POSITIVA\",'2_vanos_sin_armadura_adicional'!C370))","v":"--"},null,null,null,{"$f":"IF(F9=\"----\",'2_vanos_sin_armadura_adicional'!E272,\" -- \")","v":"SI"},null,8,{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=1.6,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=1.6,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"ISTEXT(Y23)","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=1.8,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=1.8,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=2,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=2,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=2.2,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=2.2,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=2.4,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=2.4,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=2.6,IF(K15=1,\"200 x 200 x 8\",IF(K16=8,IF(K13=2.6,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=8,IF(K13=2.8,IF(K15=1.2,\"200 x 200 x 8\"))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota: La armadura adicional para fuego se colocará a 40 mm de                                                                        la zona inferior de la placa.",null,null,null,null,null,null,null,null,null,{"$f":"ISTEXT(Y24)","v":false},null,null,null,null,false]
[null,null,null,"Nota: En caso de que en la resolución de algún caso se obtenga como valor \"FALSO\" agradecemos lo notifiquen al Departamento Técnico de Estructuras para poder comentar dicha notificación.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K15=1,IF(K13=1.6,\"200 x 200 x 8\",IF(K16=10,IF(K15=1,IF(K13=1.8,\"200 x 200 x 8\")))))))","v":false},{"$f":"ISTEXT(Y25)","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K13=1.8,IF(K15=1.2,\"200 x 200 x 8\"))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K13=2,IF(K15=1,\"200 x 200 x 8\",IF(K16=10,IF(K13=2,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K13=2.2,IF(K15=1,\"200 x 200 x 8\",IF(K16=10,IF(K13=2.2,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K13=2.4,IF(K15=1,\"200 x 200 x 8\",IF(K16=10,IF(K13=2.4,IF(K15=1.2,\"200 x 200 x 8\")))))))","v":false},{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=10,IF(K13=2.6,IF(K15=1.2,\"200 x 200 x 8\"))))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R7=\"----\",'1_vano_sin_armadura_adicional'!$B$274,\" -- \")","v":"SI"},"1 VANO SIN",12,{"$f":"IF(U19=\"FALSO\",\"\",IF(K16=12,IF(K15=1.2,IF(K13=1.8,\"150 x 150 x 8\",IF(K16=12,IF(K15=1.2,IF(K13=2,\"150 x 150 x 8\",IF(K16=12,IF(K15=1.2,IF(K13=2.2,\"150 x 150 x 8\",IF(K16=12,IF(K15=1.2,IF(K13=2.4,\"150 x 150 x 8\")))))))))))))","v":false},{"$f":"ISTEXT(Y28)","v":false},{"$f":"ISTEXT(AA25)","v":false},{"$f":"ISTEXT(AB25)","v":false},false,false,{"$f":"ISTEXT(AE25)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=1.4,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=1.4,IF(K15=1.2,IF(K16=4,IF(L29=\"150 x 150 x 5\",V17))))","v":false},{"$f":"ISNUMBER(P29)","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"IF(R14=\"NO\",\"MALLA DE ARMADURA NEGATIVA (sin puntal)\")","v":"MALLA DE ARMADURA NEGATIVA (sin puntal)"},null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=1.8,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1.2,IF(K16=4,IF(L30=\"150 x 150 x 5\",V17))))","v":false},{"$f":"ISNUMBER(P30)","v":false},null,null,null,null,{"$f":"IF(R7=\"----\",'2_vanos_sin_armadura_adicional'!$B$330,\" -- \")","v":"SI"},"2 VANOS SIN"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=2,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1.2,IF(K16=4,IF(L31=\"150 x 150 x 5\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,{"$f":"IF(R14=\"SI\",\"MALLA DE ARMADURA NEGATIVA (con puntal)\")","v":false},null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=2.2,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1.2,IF(K16=4,IF(L32=\"150 x 150 x 5\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=2.4,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1.2,IF(K16=4,IF(L33=\"150 x 150 x 5\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=2.6,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=2.6,IF(K15=1.2,IF(K16=4,IF(L34=\"150 x 150 x 5\",V17))))","v":false},false,null,null,null,null,{"$f":"IF('1_vano_sin_armadura_adicional'!$G$47='1_vano_sin_armadura_adicional'!$E$47,\"--\",'1_vano_sin_armadura_adicional'!$C$305)","v":"--"},"1 vano sin"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=2.8,\"150 X 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=2.8,IF(K15=1.2,IF(K16=4,IF(L35=\"150 x 150 x 5\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=6,IF(K15=1.2,IF(K13=2.8,\"150 X 150 x 6\")))","v":false},null,null,null,{"$f":"IF(K13=2.8,IF(K15=1.2,IF(K16=6,IF(L36=\"150 x 150 x 6\",V17))))","v":false},false,null,null,null,null,{"$f":"IF('2_vanos_sin_armadura_adicional'!E47='2_vanos_sin_armadura_adicional'!G47,\"--\",'2_vanos_sin_armadura_adicional'!$C$370)","v":"--"},"2 vanos sin"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=6,IF(K15=1.2,IF(K13=3.2,\"200 X 200 x 10\")))","v":false},null,null,null,{"$f":"IF(K13=3.2,IF(K15=1.2,IF(K16=6,IF(L37=\"200 x 200 x 10\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=6,IF(K15=1.2,IF(K13=3.4,\"200 X 200 x 10\")))","v":false},null,null,null,{"$f":"IF(K13=3.4,IF(K15=1.2,IF(K16=6,IF(L38=\"200 x 200 x 10\",V17))))","v":false},false]
[null,null,null,null,null,null,0.7,null,null,null,null,{"$f":"IF(K16=6,IF(K15=1.2,IF(K13=3.6,\"200 X 200 x 10\")))","v":false},null,null,null,{"$f":"IF(K13=3.6,IF(K15=1.2,IF(K16=6,IF(L39=\"200 x 200 x 10\",V17))))","v":false},false]
[null,null,null,null,null,null,0.8,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=1.6,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.6,IF(K15=1,IF(K16=8,IF(L40=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,1,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=1.6,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.6,IF(K15=1.2,IF(K16=8,IF(L41=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,1.2,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=1.8,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1,IF(K16=8,IF(L42=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=1.8,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1.2,IF(K16=8,IF(L43=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=2,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1,IF(K16=8,IF(L44=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=2,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1.2,IF(K16=8,IF(L45=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=2.2,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1,IF(K16=8,IF(L46=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=2.2,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1.2,IF(K16=8,IF(L47=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=2.4,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1,IF(K16=8,IF(L48=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=2.4,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1.2,IF(K16=8,IF(L49=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1,IF(K13=2.6,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.6,IF(K15=1,IF(K16=8,IF(L50=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=2.6,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.6,IF(K15=1.2,IF(K16=8,IF(L51=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=8,IF(K15=1.2,IF(K13=2.8,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.8,IF(K15=1.2,IF(K16=8,IF(L52=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1,IF(K13=1.6,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.6,IF(K15=1,IF(K16=10,IF(L53=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1,IF(K13=1.8,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1,IF(K16=10,IF(L54=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1.2,IF(K13=1.8,\"200 X 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1.2,IF(K16=10,IF(L55=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1,IF(K13=2,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1,IF(K16=10,IF(L56=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1.2,IF(K13=2,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1.2,IF(K16=10,IF(L57=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1,IF(K13=2.2,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1,IF(K16=10,IF(L58=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1.2,IF(K13=2.2,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1.2,IF(K16=10,IF(L59=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1,IF(K13=2.4,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1,IF(K16=10,IF(L60=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1.2,IF(K13=2.4,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1.2,IF(K16=10,IF(L61=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=10,IF(K15=1.2,IF(K13=2.6,\"200 x 200 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.6,IF(K15=1.2,IF(K16=10,IF(L62=\"200 x 200 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=12,IF(K15=1.2,IF(K13=1.8,\"150 x 150 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.8,IF(K15=1.2,IF(K16=12,IF(L67=\"150 x 150 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=12,IF(K15=1.2,IF(K13=2,\"150 x 150 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2,IF(K15=1.2,IF(K16=12,IF(L68=\"150 x 150 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=12,IF(K15=1.2,IF(K13=2.2,\"150 x 150 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.2,IF(K15=1.2,IF(K16=12,IF(L69=\"150 x 150 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=12,IF(K15=1.2,IF(K13=2.4,\"150 x 150 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=2.4,IF(K15=1.2,IF(K16=12,IF(L70=\"150 x 150 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1,IF(K13=1.6,\"150 x 150 x 8\")))","v":false},null,null,null,{"$f":"IF(K13=1.6,IF(K15=1,IF(K16=4,IF(L71=\"150 x 150 x 8\",V17))))","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=4,IF(K15=1.2,IF(K13=1.6,\"150 x 150 x 5\")))","v":false},null,null,null,{"$f":"IF(K13=1.6,IF(K15=1.2,IF(K16=4,IF(L72=\"150 x 150 x 5\",V17))))","v":false},false]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H4","H5","H6","H7","H8","H9","H10","H11","H12","H13","H14",null,null,null,null,"H15","H16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 6","200 x 200 x 8","200 x 200 x 8","200 x 200 x 8","200 x 200 x 8","150 x 150 x 8","150 x 150 x 8","150 x 150 x 8","150 x 150 x 8",null,null,null,null,"200 x 200 x 10","200 x 200 x 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 8","200 x 200 x 8","150 x 150 x 8","150 x 150 x 8","150 x 150 x 8","150 x 150 x 8","200 x 200 x 10","200 x 200 x 10","200 x 200 x 10","200 x 200 x 10",null,null,null,null,"150 x 150 x 10","150 x 150 x 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 5","150 x 150 x 8","150 x 150 x 8","200 x 200 x 10","200 x 200 x 10","200 x 200 x 10","200 x 200 x 10","150 x 150 x 10","150 x 150 x 10","150 x 150 x 10","150 x 150 x 10",null,null,null,null,"200 x 200 x 12","200 x 200 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 8","200 x 200 x 10","200 x 200 x 10","150 x 150 x 10","150 x 150 x 10","150 x 150 x 10","150 x 150 x 10","200 x 200 x 12","200 x 200 x 12","200 x 200 x 12","200 x 200 x 12",null,null,null,null,"150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 8","150 x 150 x 10","150 x 150 x 10","200 x 200 x 12","200 x 200 x 12","200 x 200 x 12","200 x 200 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 10","200 x 200 x 12","200 x 200 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 10","150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 12"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H4","H5","H6","H7","H8","H9","H10","H11","H12","H13","H14",null,null,null,null,"H15","H16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 8","150 x 150 x 8","200 x 200 x 10","200 x 200 x 10","150 x 150 x 10","150 x 150 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12",null,null,null,null,"150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 10","200 x 200 x 10","150 x 150 x 10","150 x 150 x 10","200 x 200 x 12","200 x 200 x 12","200 x 200 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 10","150 x 150 x 10","200 x 200 x 12","200 x 200 x 12","150 x 150 x 12","150 x 150 x 12","150 x 150 x 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 x 200 x 12","200 x 200 x 12","150 x 150 x 12","150 x 150 x 12"]
[null,null,null,"                                                  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"150 x 150 x 12","150 x 150 x 12"]

{"sheet":"HOJA_RESULTADOS","index":1,"n_rows":86,"n_cols":18,"rows_kept":86,"cut":false,"hidden":true,"merged":[[42,9,42,10],[44,9,44,10],[46,9,46,10],[48,9,48,10],[49,9,49,10],[14,12,14,17],[9,6,9,7],[25,4,25,16],[39,9,39,10],[41,9,41,10],[38,7,38,10],[40,9,40,10],[9,8,9,9],[2,10,2,11],[8,2,8,7],[18,3,18,4],[20,3,20,5],[11,2,11,4],[3,10,3,11],[51,9,51,10],[43,9,43,10],[47,9,47,10],[64,9,64,10],[73,9,73,10],[66,9,66,10],[68,9,68,10],[70,9,70,10],[63,7,63,10],[65,9,65,10],[67,9,67,10],[69,9,69,10],[54,4,54,16],[45,9,45,10],[50,9,50,10],[74,9,74,10],[75,9,75,10],[76,9,76,10],[71,9,71,10],[72,9,72,10]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"NO",null,{"$f":"IF('PROGRAMA HLM-60_200'!K16=H40,J40,IF('PROGRAMA HLM-60_200'!K16=H41,J41,IF('PROGRAMA HLM-60_200'!K16=H42,J42,IF('PROGRAMA HLM-60_200'!K16=H43,J43,IF('PROGRAMA HLM-60_200'!K16=H44,J44,IF('PROGRAMA HLM-60_200'!K16=H45,J45,IF('PROGRAMA HLM-60_200'!K16=H46,J46,IF('PROGRAMA HLM-60_200'!K16=H47,J47,IF('PROGRAMA HLM-60_200'!K16=H48,J48,IF('PROGRAMA HLM-60_200'!K16=H49,J49,IF('PROGRAMA HLM-60_200'!K16=H50,J50,IF('PROGRAMA HLM-60_200'!K16=H51,J51,IF('PROGRAMA HLM-60_200'!K16=H52,J52)))))))))))))","v":"200 x 200 x 8"}]
[null,null,null,null,null,null,null,null,null,null,"SI",null,{"$f":"IF('PROGRAMA HLM-60_200'!K16=H65,J65,IF('PROGRAMA HLM-60_200'!K16=H66,J66,IF('PROGRAMA HLM-60_200'!K16=H67,J67,IF('PROGRAMA HLM-60_200'!K16=H68,J68,IF('PROGRAMA HLM-60_200'!K16=H69,J69,IF('PROGRAMA HLM-60_200'!K16=H70,J70,IF('PROGRAMA HLM-60_200'!K16=H71,J71,IF('PROGRAMA HLM-60_200'!K16=H72,J72,IF('PROGRAMA HLM-60_200'!K16=H73,J73,IF('PROGRAMA HLM-60_200'!K16=H74,J74,IF('PROGRAMA HLM-60_200'!K16=H75,J75,IF('PROGRAMA HLM-60_200'!K16=H76,J76,IF('PROGRAMA HLM-60_200'!K16=H77,J77)))))))))))))","v":"150 x 150 x 10"}]
[]
[]
[]
[]
[null,null,"DATOS DE ENTRADA"]
[null,null,null,null,null,null,"VALORES PREDETERMINADOS POR DEFECTO",null,"VALORES INTRODUCIDOS POR EL USUARIO"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"RESISTENCIA A FUEGO NORMALIZADO"]
[null,null,"Sobrecarga útil (sobrecarga de uso+cargas muertas+tabiquería…)                                                                   (daN/m2)","Tipología de Losa Mixta","Luz (m)","Tipo de acero de la placa nervada","Espesor de la placa nervada (mm)","Altura de la Losa (cm)","¿ES NECESARIO COLOCACIÓN DE PUNTALES INTERMEDIOS?","Mallazo antifisuración","Sobrecarga útil resistente (daN/m2)","¿Sobrecarga válida?","Altura del pavimento (mm)","Resistencia al fuego normalizado necesaria","Criterio de aislamiento térmico","¿ES NECESARIO COLOCAR ARMADURA ADICIONAL?","Separación de armadura adicional","Ø (mm)"]
[null,null,{"$f":"'PROGRAMA HLM-60_200'!AE18","v":0},"1 vano",{"$f":"'PROGRAMA HLM-60_200'!AE24","v":false},{"$f":"'PROGRAMA HLM-60_200'!F14","v":"S250GD"},{"$f":"'PROGRAMA HLM-60_200'!AE28","v":false},{"$f":"'PROGRAMA HLM-60_200'!AE30","v":0},{"$f":"'1_vano_sin_armadura_adicional'!B246","v":"NO"},{"$f":"IF(I17=K3,M3,IF(I17=K4,M4))","v":"200 x 200 x 8"},{"$f":"'1_vano_sin_armadura_adicional'!C214","v":2615},{"$f":"'1_vano_sin_armadura_adicional'!E216","v":"SI"},0,{"$f":"'PROGRAMA HLM-60_200'!AE42","v":0},{"$f":"'1_vano_sin_armadura_adicional'!B274","v":"SI"},{"$f":"'1_vano_sin_armadura_adicional'!B300","v":"NO"},{"$f":"'PROGRAMA HLM-60_200'!AE44","v":0},{"$f":"IF('1_vano_sin_armadura_adicional'!G47='1_vano_sin_armadura_adicional'!E47,\"--\",'1_vano_sin_armadura_adicional'!C305)","v":"--"}]
[]
[null,null,null,"Datos de entrada"]
[]
[null,null,null,"Datos obtenidos en el cálculo"]
[]
[]
[]
[]
["S250GD",null,0.7,null,"ELECCIÓN MALLAZO ANTIFISURACIÓN SIN PUNTAL"]
["S320GD",null,0.8,null,"H=4","H=5","H=6","H=7","H=8","H=9","H=10","H=11","H=12","H=13","H=14","H=15","H=16"]
["S350GD",null,1,null,"SOLUCIÓN 1.4","SOLUCIÓN 1.5","SOLUCIÓN 1.6","SOLUCIÓN 1.7","SOLUCIÓN 1.8","SOLUCIÓN 1.9","SOLUCIÓN 1.10","SOLUCIÓN 1.11","SOLUCIÓN 1.12","SOLUCIÓN 1.13","SOLUCIÓN 1.14","SOLUCIÓN 1.15","SOLUCIÓN 1.16"]
["S280GD",null,1.2,null,"SOLUCIÓN 2.4","SOLUCIÓN 2.5","SOLUCIÓN 2.6","SOLUCIÓN 2.7","SOLUCIÓN 2.8","SOLUCIÓN 2.9","SOLUCIÓN 2.10","SOLUCIÓN 2.11","SOLUCIÓN 2.12","SOLUCIÓN 2.13","SOLUCIÓN 2.14","SOLUCIÓN 2.15","SOLUCIÓN 2.16"]
[null,null,null,null,"SOLUCIÓN 3.4","SOLUCIÓN 3.5","SOLUCIÓN 3.6","SOLUCIÓN 3.7","SOLUCIÓN 3.8","SOLUCIÓN 3.9","SOLUCIÓN 3.10","SOLUCIÓN 3.11","SOLUCIÓN 3.12","SOLUCIÓN 3.13","SOLUCIÓN 3.14","SOLUCIÓN 3.15","SOLUCIÓN 3.16"]
[null,null,null,null,"SOLUCIÓN 4.4","SOLUCIÓN 4.5","SOLUCIÓN 4.6","SOLUCIÓN 4.7","SOLUCIÓN 4.8","SOLUCIÓN 4.9","SOLUCIÓN 4.10","SOLUCIÓN 4.11","SOLUCIÓN 4.12","SOLUCIÓN 4.13","SOLUCIÓN 4.14","SOLUCIÓN 4.15","SOLUCIÓN 4.16"]
[null,null,null,null,"SOLUCIÓN 5.4","SOLUCIÓN 5.5","SOLUCIÓN 5.6","SOLUCIÓN 5.7","SOLUCIÓN 5.8","SOLUCIÓN 5.9","SOLUCIÓN 5.10","SOLUCIÓN 5.11","SOLUCIÓN 5.12","SOLUCIÓN 5.13","SOLUCIÓN 5.14"]
[null,null,null,null,"SOLUCIÓN 6.4","SOLUCIÓN 6.5","SOLUCIÓN 6.6","SOLUCIÓN 6.7","SOLUCIÓN 6.8","SOLUCIÓN 6.9","SOLUCIÓN 6.10"]
[null,null,null,null,"SOLUCIÓN 7.4","SOLUCIÓN 7.5","SOLUCIÓN 7.6"]
[null,null,null,null,"SOLUCIÓN 8.4"]
[null,null,null,null,"SOLUCIÓN 9.4"]
[]
[]
[null,null,null,null,null,null,null,"SIN PUNTAL"]
[null,null,null,null,null,null,null,4,"SOLUCIÓN 1.4",{"$f":"IF(I40=E28,mallazo_antifisurac_sin_puntal!D8,IF(I40=E29,mallazo_antifisurac_sin_puntal!E8,IF(I40=E30,mallazo_antifisurac_sin_puntal!F8,IF(I40=E31,mallazo_antifisurac_sin_puntal!G8,IF(I40=E32,mallazo_antifisurac_sin_puntal!H8,IF(I40=E33,mallazo_antifisurac_sin_puntal!I8,IF(I40=E34,mallazo_antifisurac_sin_puntal!J8,IF(I40=E35,mallazo_antifisurac_sin_puntal!K8,IF(I40=E36,mallazo_antifisurac_sin_puntal!L8)))))))))","v":"150 x 150 x 5"}]
[null,null,null,null,null,null,null,5,"SOLUCIÓN 1.5",{"$f":"IF(I41=F28,mallazo_antifisurac_sin_puntal!D11,IF(I41=F29,mallazo_antifisurac_sin_puntal!E11,IF(I41=F30,mallazo_antifisurac_sin_puntal!F11,IF(I41=F31,mallazo_antifisurac_sin_puntal!G11,IF(I41=F32,mallazo_antifisurac_sin_puntal!H11,IF(I41=F33,mallazo_antifisurac_sin_puntal!I11,IF(I41=F34,mallazo_antifisurac_sin_puntal!J11)))))))","v":"150 x 150 x 6"}]
[null,null,null,null,null,null,null,6,"SOLUCIÓN 1.6",{"$f":"IF(I42=G28,mallazo_antifisurac_sin_puntal!D14,IF(I42=G29,mallazo_antifisurac_sin_puntal!E14,IF(I42=G30,mallazo_antifisurac_sin_puntal!F14,IF(I42=G31,mallazo_antifisurac_sin_puntal!G14,IF(I42=G32,mallazo_antifisurac_sin_puntal!H14,IF(I42=G33,mallazo_antifisurac_sin_puntal!I14,IF(I42=G34,mallazo_antifisurac_sin_puntal!J14)))))))","v":"150 x 150 x 6"}]
[null,null,null,null,null,null,null,7,"SOLUCIÓN 1.7",{"$f":"IF(I43=H28,mallazo_antifisurac_sin_puntal!D17,IF(I43=H29,mallazo_antifisurac_sin_puntal!E17,IF(I43=H30,mallazo_antifisurac_sin_puntal!F17,IF(I43=H31,mallazo_antifisurac_sin_puntal!G17,IF(I43=H32,mallazo_antifisurac_sin_puntal!H17,IF(I43=H33,mallazo_antifisurac_sin_puntal!I17))))))","v":"200 x 200 x 8"}]
[null,null,null,null,null,null,null,8,"SOLUCIÓN 1.8",{"$f":"IF(I44=I28,mallazo_antifisurac_sin_puntal!D20,IF(I44=I29,mallazo_antifisurac_sin_puntal!E20,IF(I44=I30,mallazo_antifisurac_sin_puntal!F20,IF(I44=I31,mallazo_antifisurac_sin_puntal!G20,IF(I44=I32,mallazo_antifisurac_sin_puntal!H20,IF(I44=I33,mallazo_antifisurac_sin_puntal!I20))))))","v":"200 x 200 x 8"}]
[null,null,null,null,null,null,null,9,"SOLUCIÓN 1.9",{"$f":"IF(I45=J28,mallazo_antifisurac_sin_puntal!D23,IF(I45=J29,mallazo_antifisurac_sin_puntal!E23,IF(I45=J30,mallazo_antifisurac_sin_puntal!F23,IF(I45=J31,mallazo_antifisurac_sin_puntal!G23,IF(I45=J32,mallazo_antifisurac_sin_puntal!H23,IF(I45=J33,mallazo_antifisurac_sin_puntal!I23))))))","v":"200 x 200 x 8"}]
[null,null,null,null,null,null,null,10,"SOLUCIÓN 1.10",{"$f":"IF(I46=K28,mallazo_antifisurac_sin_puntal!D26,IF(I46=K29,mallazo_antifisurac_sin_puntal!E26,IF(I46=K30,mallazo_antifisurac_sin_puntal!F26,IF(I46=K31,mallazo_antifisurac_sin_puntal!G26,IF(I46=K32,mallazo_antifisurac_sin_puntal!H26,IF(I46=K33,mallazo_antifisurac_sin_puntal!I26))))))","v":"200 x 200 x 8"}]
[null,null,null,null,null,null,null,11,"SOLUCIÓN 1.11",{"$f":"IF(I47=L28,mallazo_antifisurac_sin_puntal!D29,IF(I47=L29,mallazo_antifisurac_sin_puntal!E29,IF(I47=L30,mallazo_antifisurac_sin_puntal!F29,IF(I47=L31,mallazo_antifisurac_sin_puntal!G29,IF(I47=L32,mallazo_antifisurac_sin_puntal!H29)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,12,"SOLUCIÓN 1.12",{"$f":"IF(I48=M28,mallazo_antifisurac_sin_puntal!D32,IF(I48=M29,mallazo_antifisurac_sin_puntal!E32,IF(I48=M30,mallazo_antifisurac_sin_puntal!F32,IF(I48=M31,mallazo_antifisurac_sin_puntal!G32,IF(I48=M32,mallazo_antifisurac_sin_puntal!H32)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,13,"SOLUCIÓN 1.13",{"$f":"IF(I49=N28,mallazo_antifisurac_sin_puntal!D35,IF(I49=N29,mallazo_antifisurac_sin_puntal!E35,IF(I49=N30,mallazo_antifisurac_sin_puntal!F35,IF(I49=N31,mallazo_antifisurac_sin_puntal!G35,IF(I49=N32,mallazo_antifisurac_sin_puntal!H35)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,14,"SOLUCIÓN 1.14",{"$f":"IF(I50=O28,mallazo_antifisurac_sin_puntal!D38,IF(I50=O29,mallazo_antifisurac_sin_puntal!E38,IF(I50=O30,mallazo_antifisurac_sin_puntal!F38,IF(I50=O31,mallazo_antifisurac_sin_puntal!G38,IF(I50=O32,mallazo_antifisurac_sin_puntal!H38)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,15,"SOLUCIÓN 1.15",{"$f":"IF(I51=P28,mallazo_antifisurac_sin_puntal!D41,IF(I51=P29,mallazo_antifisurac_sin_puntal!E41,IF(I51=P30,mallazo_antifisurac_sin_puntal!F41,IF(I51=P31,mallazo_antifisurac_sin_puntal!G41))))","v":"200 x 200 x 10"}]
[null,null,null,null,null,null,null,16,"SOLUCIÓN 1.16",{"$f":"IF(I52=Q28,mallazo_antifisurac_sin_puntal!D44,IF(I52=Q29,mallazo_antifisurac_sin_puntal!E44,IF(I52=Q30,mallazo_antifisurac_sin_puntal!F44,IF(I52=Q31,mallazo_antifisurac_sin_puntal!G44))))","v":"200 x 200 x 10"}]
[]
[]
[null,null,null,null,"ELECCIÓN MALLAZO ANTIFISURACIÓN CON PUNTAL"]
[null,null,null,null,"H=4","H=5","H=6","H=7","H=8","H=9","H=10","H=11","H=12","H=13","H=14","H=15","H=16"]
[null,null,null,null,"SOLUCIÓN 1.4","SOLUCIÓN 1.5","SOLUCIÓN 1.6","SOLUCIÓN 1.7","SOLUCIÓN 1.8","SOLUCIÓN 1.9","SOLUCIÓN 1.10","SOLUCIÓN 1.11","SOLUCIÓN 1.12","SOLUCIÓN 1.13","SOLUCIÓN 1.14","SOLUCIÓN 1.15","SOLUCIÓN 1.16"]
[null,null,null,null,"SOLUCIÓN 2.4","SOLUCIÓN 2.5","SOLUCIÓN 2.6","SOLUCIÓN 2.7","SOLUCIÓN 2.8","SOLUCIÓN 2.9","SOLUCIÓN 2.10","SOLUCIÓN 2.11"]
[null,null,null,null,"SOLUCIÓN 3.4","SOLUCIÓN 3.5","SOLUCIÓN 3.6","SOLUCIÓN 3.7","SOLUCIÓN 3.8","SOLUCIÓN 3.9","SOLUCIÓN 3.10"]
[null,null,null,null,"SOLUCIÓN 4.4","SOLUCIÓN 4.5","SOLUCIÓN 4.6","SOLUCIÓN 4.7"]
[null,null,null,null,"SOLUCIÓN 5.4","SOLUCIÓN 5.5"]
[]
[]
[null,null,null,null,null,null,null,"CON PUNTAL"]
[null,null,null,null,null,null,null,4,"SOLUCIÓN 1.4",{"$f":"IF(I65=E57,mallazo_antifisurac_con_puntal!F14,IF(I65=E58,mallazo_antifisurac_con_puntal!G14,IF(I65=E59,mallazo_antifisurac_con_puntal!H14,IF(I65=E60,mallazo_antifisurac_con_puntal!I14,IF(I65=E61,mallazo_antifisurac_con_puntal!J14)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,5,"SOLUCIÓN 1.5",{"$f":"IF(I66=F57,mallazo_antifisurac_con_puntal!F18,IF(I66=F58,mallazo_antifisurac_con_puntal!G18,IF(I66=F59,mallazo_antifisurac_con_puntal!H18,IF(I66=F60,mallazo_antifisurac_con_puntal!I18,IF(I66=F61,mallazo_antifisurac_con_puntal!J18)))))","v":"150 x 150 x 8"}]
[null,null,null,null,null,null,null,6,"SOLUCIÓN 1.6",{"$f":"IF(I67=G57,mallazo_antifisurac_con_puntal!F22,IF(I67=G58,mallazo_antifisurac_con_puntal!G22,IF(I67=G59,mallazo_antifisurac_con_puntal!H22,IF(I67=G60,mallazo_antifisurac_con_puntal!I22))))","v":"200 x 200 x 10"}]
[null,null,null,null,null,null,null,7,"SOLUCIÓN 1.7",{"$f":"IF(I68=H57,mallazo_antifisurac_con_puntal!F26,IF(I68=H58,mallazo_antifisurac_con_puntal!G26,IF(I68=H59,mallazo_antifisurac_con_puntal!H26,IF(I68=H60,mallazo_antifisurac_con_puntal!I26))))","v":"200 x 200 x 10"}]
[null,null,null,null,null,null,null,8,"SOLUCIÓN 1.8",{"$f":"IF(I69=I57,mallazo_antifisurac_con_puntal!F30,IF(I69=I58,mallazo_antifisurac_con_puntal!G30,IF(I69=I59,mallazo_antifisurac_con_puntal!H30)))","v":"150 x 150 x 10"}]
[null,null,null,null,null,null,null,9,"SOLUCIÓN 1.9",{"$f":"IF(I70=J57,mallazo_antifisurac_con_puntal!F34,IF(I70=J58,mallazo_antifisurac_con_puntal!G34,IF(I70=J59,mallazo_antifisurac_con_puntal!H34)))","v":"150 x 150 x 10"}]
[null,null,null,null,null,null,null,10,"SOLUCIÓN 1.10",{"$f":"IF(I71=K57,mallazo_antifisurac_con_puntal!F38,IF(I71=K58,mallazo_antifisurac_con_puntal!G38,IF(I71=K59,mallazo_antifisurac_con_puntal!H38)))","v":"150 x 150 x 10"}]
[null,null,null,null,null,null,null,11,"SOLUCIÓN 1.11",{"$f":"IF(I72=L57,mallazo_antifisurac_con_puntal!F42,IF(I72=L58,mallazo_antifisurac_con_puntal!G42))","v":"200 x 200 x 12"}]
[null,null,null,null,null,null,null,12,"SOLUCIÓN 1.12",{"$f":"mallazo_antifisurac_con_puntal!F46","v":"150 x 150 x 12"}]
[null,null,null,null,null,null,null,13,"SOLUCIÓN 1.13",{"$f":"mallazo_antifisurac_con_puntal!F50","v":"150 x 150 x 12"}]
[null,null,null,null,null,null,null,14,"SOLUCIÓN 1.14",{"$f":"mallazo_antifisurac_con_puntal!F54","v":"150 x 150 x 12"}]
[null,null,null,null,null,null,null,15,"SOLUCIÓN 1.15",{"$f":"mallazo_antifisurac_con_puntal!F58","v":"150 x 150 x 12"}]
[null,null,null,null,null,null,null,16,"SOLUCIÓN 1.16",{"$f":"mallazo_antifisurac_con_puntal!F62","v":"150 x 150 x 12"}]
[]
[]
[]
[]
[null,null,"Limitación de sobrecarga útil actuante"]
[]
[null,null,"Mínimo","Máximo"]
[]
[null,null,100,4000]

{"sheet":"1_vano_sin_armadura_adicional","index":2,"n_rows":320,"n_cols":9,"rows_kept":320,"cut":false,"hidden":true,"merged":[[150,3,150,4],[146,4,146,5],[172,3,172,4],[40,6,40,8],[90,1,90,4],[41,1,41,2],[41,6,41,8],[42,1,42,2],[43,1,44,2],[43,3,44,3],[43,5,44,5],[46,1,46,2],[47,1,47,2],[45,1,45,2],[311,4,319,4],[215,4,215,5],[235,3,238,3],[36,1,36,2],[37,1,37,2],[40,1,40,2],[54,1,54,4],[39,1,39,2],[38,1,38,2],[43,4,44,4],[48,1,48,2],[49,1,49,2],[50,1,50,2],[206,1,206,4],[208,1,208,2],[147,4,147,5]]}
[]
[null,"Datos fijos"]
[]
[null,"msc",101.36,"N/mm2"]
[null,"ksc",4.4999999999999998E-2,"N/mm2"]
[null,"γvs",1.25]
[null,"tpp",60,"días"]
[null,"bo",6,"cm"]
[null,"b",22,"cm"]
[null,"b1",13,"cm"]
[null,"Es",{"$f":"2.1*10^6","v":2100000},"kg/cm2"]
[null,"Ac_v",0,"cm2"]
[null,"fmv",0.125]
[null,"ffv",1.302E-2]
[null,"te",7,"días"]
[null,"tinf",10000,"días"]
[null,"d",{"$f":"C104-2","v":12}]
[null,"ρ2",0]
[null,"fr",0.125]
[null,"Tpp",7,"días"]
[null,"l1",127]
[null,"l2",60]
[null,"l3",93]
[null,"h2",60]
[null,"k",0.85]
[null,"u1",50,"mm"]
[null,"u2",50,"mm"]
[null,"u3",40,"mm"]
[]
[]
[]
[]
[]
[]
[null,"Entrada de datos variables"]
[]
[null,"Nombre variable",null,"Unidades","Valor","Abreviatura"]
[null,"Luz de cálculo",null,"m",{"$f":"'PROGRAMA HLM-60_200'!K13","v":1.4},"L"]
[null,"Espesor de la placa nervada",null,"mm",{"$f":"'PROGRAMA HLM-60_200'!K15","v":0.8},"ec"]
[null,"Altura de la losa de hormigón",null,"cm",{"$f":"'PROGRAMA HLM-60_200'!K16","v":8},"H",4]
[null,"Sobrecarga útil (suma de uso más cargas muertas, más tabiquería…)",null,"daN/m2",{"$f":"'PROGRAMA HLM-60_200'!F7","v":1000},"Quso","Recordar que no es la de uso exactamente, sino la suma de la de uso mas tabiquería más cargas  muertas…"]
[null,"Tipo de cemento (1, 2 ó 3)",null,null,{"$f":"'PROGRAMA HLM-60_200'!F17","v":2},null,"Tipo 2: Endurecimiento normal"]
[null,"Resistencia característica del hormigón",null,"kg/cm2",{"$f":"'PROGRAMA HLM-60_200'!F15*10","v":250},"fck"]
[null,"HUMEDAD RELATIVA( 50% Ó 80%)",null,null,{"$f":"'PROGRAMA HLM-60_200'!F18","v":50}]
[]
[null,"Calidad de la placa de acero",null,"kg/cm2",{"$f":"IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$26,2500,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$27,3200,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$28,3500,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!A29,2800))))","v":2500},"σ"]
[null,"Resistencia al fuego requerida",null,null,{"$f":"'PROGRAMA HLM-60_200'!R8","v":"R30"},"RF","R30"]
[null,"Altura del pavimento",null,"mm",{"$f":"'PROGRAMA HLM-60_200'!R6","v":0},"h3"]
[null,"Resistencia característica del hormigón a 20ºC",null,null,{"$f":"$E$43/10","v":25},"fc_20ºC"]
[null,"Resistencia del acero a 20ºC",null,null,{"$f":"'PROGRAMA HLM-60_200'!F16","v":500},"fsy_20ºC"]
[]
[]
[]
[]
[null,"CRITERIO DE FLEXIÓN"]
[]
[]
[]
[null,"yinf",{"$f":"IF(E39=0.7,F60,IF(E39=0.8,F61,IF(E39=1,F62,IF(E39=1.2,F63))))","v":33.47},null,"ec","yinf"]
[null,null,null,null,0.7,32.79]
[null,null,null,null,0.8,33.47]
[null,null,null,null,1,33.549999999999997]
[null,null,null,null,1.2,33.64]
[]
[null,"dp",{"$f":"E40*10+60-C59","v":106.53}]
[]
[null,"Ap",{"$f":"IF(E39=0.7,E68,IF(E39=0.8,E69,IF(E39=1,E70,IF(E39=1.2,E71))))","v":1000},null,"Ap","ec"]
[null,null,null,null,875,0.7]
[null,"Vd(L)",{"$f":"((967*C65)/C6)*(((4*C67*C4)/(E38*1000*967))+C5)*(1/9.8)","v":2896.8768122448973},null,1000,0.8]
[null,null,null,null,1250,1]
[null,null,null,null,1500,1.2]
[]
[null,"Qt(L)",{"$f":"2*C69*1000*1000/(E38*1000*967)","v":4279.6230052369583}]
[]
[null,"Qpp",{"$f":"IF(E40=4,E76,IF(E40=5,E77,IF(E40=6,E78,IF(E40=7,E79,IF(E40=8,E80,IF(E40=9,E81,IF(E40=10,E82,IF(E40=11,E83,IF(E40=12,E84,IF(E40=13,E85,IF(E40=14,E86,IF(E40=15,E87,IF(E40=16,E88)))))))))))))","v":265},null,"Qpp","H"]
[null,"Qsc(L)",{"$f":"ROUND((C73-1.35*C75)/1.5,0)","v":2615},null,165,4]
[null,"Qsc(L)",{"$f":"IF(C76>0,C76,0)","v":2615},null,190,5]
[null,null,null,null,215,6]
[null,null,null,null,240,7]
[null,null,null,null,265,8]
[null,null,null,null,299,9]
[null,null,null,null,315,10]
[null,null,null,null,340,11]
[null,null,null,null,365,12]
[null,null,null,null,390,13]
[null,null,null,null,415,14]
[null,null,null,null,440,15]
[null,null,null,null,465,16]
[]
[]
[null,"CRITERIO DE DEFORMACIÓN"]
[]
[null,"tpp",60]
[null,"s",{"$f":"IF(E42=1,E95,IF(E42=2,E96,IF(E42=3,E97)))","v":0.25},null,"s","Tipo cemento"]
[null,"β",{"$f":"EXP(C94*(1-(28/C93)^(1/2)))","v":1.0824397132913168},null,0.2,1]
[null,null,null,null,0.25,2]
[null,null,null,null,0.38,3]
[]
[]
[null,"fc_flex",{"$f":"0.8*(E43)^(2/3)","v":31.748021039363984}]
[]
[null,"fc_flex_pp",{"$f":"C100*C95","v":34.365318791415845}]
[]
[null,"h",{"$f":"E40+6","v":14}]
[null,"yT",{"$f":"((C8*((C104-E40)^2)/2)+C9*E40*(C104-(E40/2)))/(C8*(C104-E40)+C9*E40)","v":8.8113207547169807}]
[null,"Ihor",{"$f":"(1/12)*C8*(C104-E40)^3+C8*(C104-E40)*(C105-((C104-E40)/2))^2+(1/12)*C9*E40^3+C9*E40*(C104-(E40/2)-C105)^2","v":2511.1194968553459}]
[null,"Ah",{"$f":"(C9*E40+((C10+C8)/2)*(C104-E40))/100^2","v":2.3300000000000001E-2},null,"At_v","ec"]
[null,"Ahor",{"$f":"C107*100^2","v":233},null,2.0099999999999998,0.7]
[null,"At_v",{"$f":"IF(E39=0.7,E108,IF(E39=0.8,E109,IF(E39=1,E110,IF(E39=1.2,E111))))","v":2.2999999999999998},null,2.2999999999999998,0.8]
[null,"Eci_pp",{"$f":"19000*(E43*C95)^(1/2)","v":312554.28988343984},null,2.87,1]
[null,"npp",{"$f":"C11/C110","v":6.7188327531295391},null,3.45,1.2]
[null,"d´",{"$f":"IF(E39=0.7,E114,IF(E39=0.8,E115,IF(E39=1,E116,IF(E39=1.2,E117))))","v":3.3395000000000001}]
[null,"yhv_pp",{"$f":"(C108*C105+C111*C109*C112+C111*C12*(C104-C112))/(C108+C111*C109+C111*C12)","v":8.4709840944842618},null,"d´","ec"]
[null,"Ihv_pp",{"$f":"C106+C108*(C113-C105)^2+C111*C109*(C113-C112)^2+C111*C12*(C104-C113-C112)^2","v":2945.0263567005672},null,3.3399000000000001,0.7]
[null,null,null,null,3.3395000000000001,0.8]
[null,"Whv_pp",{"$f":"C114/C113","v":347.66047531811228},null,3.3378000000000001,1]
[null,null,null,null,3.3376999999999999,1.2]
[]
[]
[null,"Mfv",{"$f":"C102*C116","v":11947.463065482088}]
[]
[]
[null,"Mv",{"$f":"(C13*(C75+C77)*C9*(E38*100)^2)/10000","v":15523.2}]
[]
[null,"ξv",{"$f":"1-0.5*(C120/C123)^2","v":0.70381784297144556}]
[]
[]
[null,"FLECHA DE SOBRECARGA"]
[]
[null,"Ecm",{"$f":"44100*(E43+80)^(1/3)","v":304749.66444349318}]
[null,"Phor",{"$f":"C9+2*E40+4.6*2+6.9*2+C8","v":67}]
[null,"em",{"$f":"2*C108*100/(C131*10)","v":69.552238805970148}]
[null,"Ø",{"$f":"IF(E44=50,F133,IF(E44=80,F135))","v":3.6343554001188423},null,"Ø50",{"$f":"10.345*C132^(-0.1601)*C15^((-5.238*(10^(-8))*C132^2)+(3.158*(10^-5)*C132)-0.1905)","v":3.6343554001188423}]
[null,"Ete",{"$f":"C130/(1+C133)","v":65758.803141355587}]
[null,"nte",{"$f":"C11/C134","v":31.934887797240243},null,"Ø80",{"$f":"5.5952*C132^(-0.1058)*C15^(0.007289*LN(C132)-0.23155)","v":2.4173943797795014}]
[null,"yhv_te",{"$f":"(C108*C105+C135*C109*C112+C135*C12*(C104-C112))/(C108+C135*C109+C135*C12)","v":7.4998303290100976}]
[null,"Ihv_te",{"$f":"C106+C108*(C136-C105)^2+C135*C109*(C136-C112)^2+C135*C12*(C104-C136-C112)^2","v":4183.1835405773054}]
[]
[null,"β",{"$f":"EXP(C94*(1-(28/C16)^(1/2)))","v":1.2671512154708973}]
[null,"Eci_inf",{"$f":"19000*(E43*C139)^(1/2)","v":338172.14136626996}]
[]
[null,"Fsc_I",{"$f":"C14*(C76*C9*(E38*100)^4)/(100*100*C140*C137)","v":2.0341021245351365E-2}]
[]
[null,"δf",{"$f":"E40/C17","v":0.66666666666666663}]
[null,"ξf",{"$f":"C144*((C9/C8)-1)","v":1.7777777777777777}]
[null,"ρ1",{"$f":"C109/(C9*C17)","v":8.712121212121211E-3}]
[null,"ninf",{"$f":"C11/C140","v":6.209855109636357},null,"SECCIÓN RECTANGULAR"]
[null,"Tf_inf",{"$f":"(C144^2+2*C147*C18*(C144-(C112/C17)))/(2*(1-C144))","v":0.66666666666666652},null,"SECCIÓN T"]
[null,"αf_inf",{"$f":"2*C147*(C146+C18*(C112/C17)*(C9/C8))+(C145*C144)","v":1.2933872060349094}]
[null,"βf_inf",{"$f":"C145+C147*(C146+C18)*(C9/C8)","v":1.9761481493356057}]
[null,"ninf*ρ1",{"$f":"C147*C146","v":5.4101010424862192E-2},{"$f":"IF(C151<C148,E147,IF(C151>C148,E148))","v":"SECCIÓN RECTANGULAR"}]
[]
[null,"Xfv_inf_r",{"$f":"(C17*C147*C146*(-1+(1+(2/(C147*C146)))^(1/2)))","v":3.3511087852456001},"Considerando ρ2=0"]
[null,"Ifv_inf_r",{"$f":"C147*C109*(C17-C153)*(C17-(C153/3))+C147*C12*(C153-C112)*((C153/3)-C112)","v":1344.3641415441307}]
[]
[null,"Xfv_inf_T",{"$f":"C17*C150*(-1+(1+(C149/C150^2)^(1/2)))","v":13.647261911058456}]
[null,"Ic_inf",{"$f":"C9*E40*(((E40^2)/12)+(C156-(E40/2))^2)+((C8*(C156-E40)^3))/3","v":17679.127309891363}]
[null,"Ifv_inf_T",{"$f":"C157+C147*C109*(C17-C156)^2+C147*C12*(C156-C112)^2","v":17717.882923403915}]
[]
[null,"Ifis_inf",{"$f":"IF(D151=E147,C154,IF(D151=E148,C158))","v":1344.3641415441307}]
[]
[null,"Fsc_II",{"$f":"C14*(C76/100)*(C9/100)*((E38*100)^4)/(C140*C160)","v":6.3294030718755154E-2}]
[]
[null,"Flecha_SC",{"$f":"C125*C162+(1-C125)*C142","v":5.0572115722054486E-2}]
[]
[null,"FLECHA DEBIDA A RETRACCIÓN"]
[]
[null,"Sh",{"$f":"C109*(C136-C112)","v":9.5687597567232228}]
[]
[null,"βf_te",{"$f":"C145+C135*(C146+C18)*(C9/C8)","v":2.7979200268562856}]
[null,"αf_te",{"$f":"2*C135*(C146+C18*(C112/C17))*(C9/C8)+(C145*C144)","v":3.2254696833422005}]
[null,"Tf_te",{"$f":"(C144^2+(2*C135*C18*(C144-(C112/C17))))/(2*(1-C144))","v":0.66666666666666652}]
[null,"nte*ρ1",{"$f":"C135*C146","v":0.27822061338504755},{"$f":"IF(C173<C172,E147,IF(C173>C172,E148))","v":"SECCIÓN RECTANGULAR"}]
[]
[null,"Xfv_te_r",{"$f":"C17*C135*C146*(-1+(1+(2/(C135*C146)))^(1/2))","v":6.2151007443627515}]
[null,"Ifv_te_r",{"$f":"C135*C109*(C17-C175)*(C17-(C175/3))+C135*C12*C175*((C175/3)-C112)","v":4218.5569021394931}]
[]
[null,"Xfv_te_T",{"$f":"C17*C170*(-1+(1+(C171/C170^2))^(1/2))","v":6.321713518653759}]
[null,"Ic_te",{"$f":"C9*E40*(((E40^2)/12)+(C178-(E40/2))^2)+(C8*(C178-E40)^3)/3","v":1877.9146351257984}]
[null,"Ifv_te_T",{"$f":"C179+C135*C109*(C17-C178)^2+C135*C12*(C178-C112)^2","v":4246.166185180793}]
[null,"Xfv_te",{"$f":"IF(D173=E147,C175,IF(D173=E148,C178))","v":6.2151007443627515}]
[null,"Ifv_te",{"$f":"IF(D173=E147,C176,IF(D173=E148,C180))","v":4218.5569021394931}]
[null,"Sfis",{"$f":"C109*(C104-C181-C112)","v":10.224418287965671}]
[]
[null,"εr_50",{"$f":"IF(C132<150,0.6/1000,IF(C132>150,(-0.00022*C132+0.63333)/1000))","v":5.9999999999999995E-4}]
[null,"εr_80",{"$f":"IF(C132<150,0.33/1000,IF(C132>150,(-0.00011*C132+0.34667)/1000))","v":3.3E-4}]
[]
[null,"εr_50",{"$f":"C185*(C15-C20)/C15","v":0}]
[null,"εr_80",{"$f":"C186*(C15-C20)/C15","v":0}]
[null,"εr",{"$f":"IF(E44=50,C188,IF(E44=80,C189))","v":0}]
[]
[null,"Fret_I",{"$f":"(C19*C168*C190*(C11/C134)*E38^2)/C137","v":0}]
[]
[null,"Fret_II",{"$f":"(C19*C183*C190*(C11/C134)*E38^2)/C182","v":0}]
[]
[null,"Flecha _ret",{"$f":"C125*C194+(1-C125)*C192","v":0}]
[]
[null,"FLECHA DEBIDA A PESO PROPIO "]
[]
[null,"Fpp_I",{"$f":"(C14*(C75)*C9*(100*E38)^4)/(100*100*C134*C137)","v":1.0600610112125436E-2}]
[]
[null,"Fpp_II",{"$f":"(C14*(C75)*C9*(100*E38)^4)/(100*100*C134*C182)","v":1.0511722081698295E-2}]
[]
[null,"Flecha _PP",{"$f":"C125*C202+(1-C125)*C200","v":1.0538049130284225E-2}]
[]
[]
[null,"FLECHA TOTAL=Flecha_sc + Flecha_ret + Flecha_pp"]
[]
[null,"FLECHA TOTAL",null,{"$f":"C204+C196+C164","v":6.1110164852338708E-2},"cm"]
[]
[]
[null,"FACTOR RELACIÓN LUZ=",null,{"$f":"E38*100/D209","v":2290.9445644318557}]
[null,null,null,null,null,"\"Solución No Válida\" "]
[null,"Q_resultante",{"$f":"IF(D212>350,C77,IF(D212<350,F213))","v":2615},null,null,"SI","NO"]
[]
[null,"¿Q_resultante",">","Q\"uso\"?",{"$f":"IF(C214=F213,G214,IF(C214=E41,F214,IF(C214>E41,F214,IF(C214<E41,G214))))","v":"SI"}]
[]
[]
[null,"CÁLCULO DE APUNTALAMIENTOS"]
[]
[]
[]
[null,"I",{"$f":"IF(E39=E225,F225,IF(E39=E226,F226,IF(E39=E227,F227,IF(E39=E228,F228))))","v":62.63}]
[null,"W",{"$f":"IF(E39=E225,G225,IF(E39=E226,G226,IF(E39=E227,G227,IF(E39=E228,G228))))","v":18.71},null,"ec","Momento de Inercia I (cm4/m)","Módulo resistente W (cm3/m)"]
[null,"Qsc_flex",{"$f":"((E46/1.5)*(C224/100)*8)/E38^2","v":1272.7891156462588},null,0.7,54.79,16.71]
[null,"Qsc_def",{"$f":"((C11*C223)/10000)*384/(5*180*E38^3)","v":2045.0612244897961},null,0.8,62.63,18.71]
[null,null,null,null,1,78.31,23.34]
[null,null,null,null,1.2,94.01,27.95]
[]
[]
[null,"¿Qsc_flex","<","Qsc_def?",{"$f":"IF(C225<C226,F231,IF(C225>C226,F232))","v":"SI"},"SI"]
[null,null,null,null,null,"NO"]
[]
[null,"QSC =",{"$f":"IF(E231=F232,B226,IF(E231=F231,B225))","v":"Qsc_flex"},{"$f":"IF(C234=B226,C226,IF(C234=B225,C225))","v":1272.7891156462588}]
[]
[null,"QSC_EUROCÓDIGO_0,7",{"$f":"IF(E39=0.7,IF(E40=4,cargas_de_encofrado!$G$7,IF(E39=0.7,IF(E40=5,cargas_de_encofrado!$G$8,IF(E39=0.7,IF(E40=6,cargas_de_encofrado!$G$9,IF(E39=0.7,IF(E40=7,cargas_de_encofrado!$G$10,IF(E39=0.7,IF(E40=8,cargas_de_encofrado!$G$11,IF(E39=0.7,IF(E40=9,cargas_de_encofrado!$G$12,IF(E39=0.7,IF(E40=10,cargas_de_encofrado!$G$13,IF(E39=0.7,IF(E40=11,cargas_de_encofrado!$G$14,IF(E39=0.7,IF(E40=12,cargas_de_encofrado!$G$15,IF(E39=0.7,IF(E40=13,cargas_de_encofrado!$G$16,IF(E39=0.7,IF(E40=14,cargas_de_encofrado!$G$17,IF(E39=0.7,IF(E40=15,cargas_de_encofrado!$G$18,IF(E39=0.7,IF(E40=16,cargas_de_encofrado!$G$19))))))))))))))))))))))))))","v":false}]
[null,"QSC_EUROCÓDIGO_0,8",{"$f":"IF(E39=0.8,IF(E40=4,cargas_de_encofrado!$G$20,IF(E39=0.8,IF(E40=5,cargas_de_encofrado!$G$21,IF(E39=0.8,IF(E40=6,cargas_de_encofrado!$G$22,IF(E39=0.8,IF(E40=7,cargas_de_encofrado!$G$23,IF(E39=0.8,IF(E40=8,cargas_de_encofrado!$G$24,IF(E39=0.8,IF(E40=9,cargas_de_encofrado!$G$25,IF(E39=0.8,IF(E40=10,cargas_de_encofrado!$G$26,IF(E39=0.8,IF(E40=11,cargas_de_encofrado!$G$27,IF(E39=0.8,IF(E40=12,cargas_de_encofrado!$G$28,IF(E39=0.8,IF(E40=13,cargas_de_encofrado!$G$29,IF(E39=0.8,IF(E40=14,cargas_de_encofrado!$G$30,IF(E39=0.8,IF(E40=15,cargas_de_encofrado!$G$31,IF(E39=0.8,IF(E40=16,cargas_de_encofrado!$G$32))))))))))))))))))))))))))","v":422.25}]
[null,"QSC_EUROCÓDIGO_1,0",{"$f":"IF(E39=1,IF(E40=4,cargas_de_encofrado!$G$33,IF(E39=1,IF(E40=5,cargas_de_encofrado!$G$34,IF(E39=1,IF(E40=6,cargas_de_encofrado!$G$35,IF(E39=1,IF(E40=7,cargas_de_encofrado!$G$36,IF(E39=1,IF(E40=8,cargas_de_encofrado!$G$37,IF(E39=1,IF(E40=9,cargas_de_encofrado!$G$38,IF(E39=1,IF(E40=10,cargas_de_encofrado!$G$39,IF(E39=1,IF(E40=11,cargas_de_encofrado!$G$40,IF(E39=1,IF(E40=12,cargas_de_encofrado!$G$41,IF(E39=1,IF(E40=13,cargas_de_encofrado!$G$42,IF(E39=1,IF(E40=14,cargas_de_encofrado!$G$43,IF(E39=1,IF(E40=15,cargas_de_encofrado!$G$44,IF(E39=1,IF(E40=16,cargas_de_encofrado!$G$45))))))))))))))))))))))))))","v":false}]
[null,"QSC_EUROCÓDIGO_1,2",{"$f":"IF(E39=1.2,IF(E40=4,cargas_de_encofrado!$G$46,IF(E39=1.2,IF(E40=5,cargas_de_encofrado!$G$47,IF(E39=1.2,IF(E40=6,cargas_de_encofrado!$G$48,IF(E39=1.2,IF(E40=7,cargas_de_encofrado!$G$49,IF(E39=1.2,IF(E40=8,cargas_de_encofrado!$G$50,IF(E39=1.2,IF(E40=9,cargas_de_encofrado!$G$51,IF(E39=1.2,IF(E40=10,cargas_de_encofrado!$G$52,IF(E39=1.2,IF(E40=10,cargas_de_encofrado!$G$52,IF(E39=1.2,IF(E40=11,cargas_de_encofrado!$G$53,IF(E39=1.2,IF(E40=12,cargas_de_encofrado!$G$54,IF(E39=1.2,IF(E40=13,cargas_de_encofrado!$G$55,IF(E39=1.2,IF(E40=14,cargas_de_encofrado!$G$56,IF(E39=1.2,IF(E40=15,cargas_de_encofrado!$G$57,IF(E39=1.2,IF(E40=16,cargas_de_encofrado!$G$58))))))))))))))))))))))))))))","v":false}]
[]
[null,"QSC_EUROCÓDIGO",{"$f":"MAX(C236:C239)","v":422.25}]
[]
[null,{"$f":"C234","v":"Qsc_flex"},">","QSC_EUROCÓDIGO?",{"$f":"IF(D234>C241,F231,IF(D234<C241,F232))","v":"SI"},null,"SI"]
[null,null,null,null,null,null,"NO"]
[]
[null,{"$f":"IF(E243=F232,G243,IF(E243=F231,G244))","v":"NO"}]
[]
[null,"Elección del mallazo antifisuración por el cliente"]
[]
[]
[null,"Mallazo seleccionado",{"$f":"HOJA_RESULTADOS!J17","v":"200 x 200 x 8"}]
[]
[]
[null,"CÁLCULO DE FUEGO"]
[]
[null,"CRITERIO DE AISLAMIENTO"]
[]
[null,"h2/H",{"$f":"C24/(E40*10)","v":0.75}]
[null,"heff",{"$f":"E40*10*(1+0.75*((C21+C22)/(C21+C23)))","v":131}]
[null,"heff",{"$f":"(E40*10)+0.5*C24*((C21+C22)/(C21+C23))","v":105.5}]
[]
[null,"heff",{"$f":"IF(C258>1.5,C259,IF(C258<1.5,C260,IF(C258=1.5,C260,\"ERROR\")))","v":105.5},null,"Resistencia al fuego normalizado","Grosor eficaz mínimo"]
[null,"heff_min",{"$f":"IF(E47=E263,G263,IF(E47=E264,G264,IF(E47=E265,G265,IF(E47=E266,G266,IF(E47=E267,G267,IF(E47=E268,G268,\"ERROR\"))))))","v":60},null,"R30","heff=60-h3",{"$f":"60-E48","v":60}]
[null,null,null,null,"R60","heff=80-h3",{"$f":"80-E48","v":80}]
[null,null,null,null,"R90","heff=100-h3",{"$f":"100-E48","v":100}]
[null,null,null,null,"R120","heff=120-h3",{"$f":"120-E48","v":120}]
[null,null,null,null,"R180","heff=150-h3",{"$f":"150-E48","v":150}]
[null,null,null,null,"R240","heff=175-h3",{"$f":"175-E48","v":175}]
[]
[null,"¿heff_min","<","heff?",null,"SI"]
[null,null,null,null,null,"NO"]
[null,{"$f":"IF(C263<C262,F270,IF(C263>C262,F271,\"ERROR\"))","v":"SI"},null,null,null,"NO"]
[]
[null,{"$f":"IF(G40=E40,F271,IF(B272=F271,F272,IF(B272=F270,F270)))","v":"SI"}]
[]
[]
[null,"CRITERIO DE RESISTENCIA"]
[]
[]
[null,"Q",{"$f":"E41/100","v":10}]
[null,"G",{"$f":"IF(E40=H283,I283,IF(E40=H284,I284,IF(E40=H285,I285,IF(E40=H286,I286,IF(E40=H287,I287,IF(E40=H288,I288,IF(E40=H289,I289,IF(E40=H290,I290,IF(E40=H291,I291,IF(E40=H292,I292,IF(E40=H293,I293,IF(E40=H294,I294,IF(E40=H295,I295,\"ERROR\")))))))))))))","v":2.65}]
[null,null,null,null,null,null,null,"Espesor de losa (cm)","Peso losa(KN/m2)"]
[null,"Mpv",{"$f":"(C25*(C280+C281)*E38^2)/8","v":2.6343624999999995},null,null,null,null,4,1.65]
[null,null,null,null,null,null,null,5,1.89]
[null,null,null,null,null,null,null,6,2.15]
[null,null,null,null,null,null,null,7,2.39]
[null,"z",{"$f":"1/((1/(C26)^(1/2)+(1/(C27)^(1/2)+(1/(C28)^(1/2)))))","v":2.2677968993854556},null,null,null,null,8,2.65]
[null,null,null,null,null,null,null,9,2.89]
[null,"θs",{"$f":"IF(E47=G297,F297,IF(E47=G298,F298,IF(E47=G299,F299,IF(E47=G300,F300,IF(E47=G301,F301,\"ERROR\")))))","v":"ERROR"},null,null,null,null,10,3.15]
[null,null,null,null,null,null,null,11,3.39]
[null,"kcal",{"$f":"F304*(C289)^5-F305*(C289)^4+F306*(C289)^3-F307*(C289^2)+F308*C289-F309","v":{"$error":"#VALUE!"}},null,null,null,null,12,3.65]
[null,null,null,null,null,null,null,13,3.9]
[null,null,null,null,null,null,null,14,4.1500000000000004]
[null,null,null,null,null,null,null,15,4.4000000000000004]
[null,null,null,null,null,null,null,16,4.6500000000000004]
[null,"kmax",{"$f":"IF(C289<400,1,IF(C289>400,C291,IF(C289>950,\"ERROR MÁXIMO\")))","v":{"$error":"#VALUE!"}},null,null,"θs","RF"]
[null,null,null,null,null,{"$f":"1175-350*C287","v":381.27108521509058},"R60"]
[null,"Av_2",{"$f":"((0.85*E49*1*10^3)/(C296*E50))*((E40*10+C24-C28)-((E40*10+C24-C28)^2-(2*C283*10^6/(0.85*E49*10^3)))^(1/2))","v":{"$error":"#VALUE!"}},null,null,{"$f":"1285-350*C287","v":491.27108521509058},"R90","NO"]
[null,null,null,null,null,{"$f":"1370-350*C287","v":576.27108521509058},"R120","SI "]
[null,{"$f":"IF(E47=G47,H298,IF(C298>0,H299,IF(C298<0,H298,\"ERROR\")))","v":"NO"},null,null,null,{"$f":"1490-350*C287","v":696.27108521509058},"R180"]
[null,null,null,null,null,{"$f":"1575-350*C287","v":781.27108521509058},"R240"]
[null,"sep",{"$f":"'PROGRAMA HLM-60_200'!R9","v":220}]
[null,"Ø",{"$f":"(C298*4*C302*10^(-3)/PI())^(1/2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"A",4.9081000000000001E-14]
[null,"Ø",{"$f":"IF(B300=\"NO\",\"--\",IF(C303<F312,F312,IF(C303<F313,F313,IF(C303<F314,F314,IF(C303<F315,F315,IF(C303<F316,F316,IF(C303<F317,F317,IF(C303<F318,F318,IF(C303<F319,F319,IF(C303<F320,F320))))))))))","v":"--"},null,"B",2.0162295699999999E-10]
[null,null,null,null,"C",3.1961444828600002E-7]
[null,null,null,null,"D",2.4088468851569901E-4]
[null,null,null,null,"E",8.3489748378334797E-2]
[null,null,null,null,"F",9.6515662159594307]
[]
[]
[null,null,null,null,"Ø",6]
[null,null,null,null,null,8]
[null,null,null,null,null,10]
[null,null,null,null,null,12]
[null,null,null,null,null,14]
[null,null,null,null,null,16]
[null,null,null,null,null,20]
[null,null,null,null,null,25]
[null,null,null,null,null,32]

{"sheet":"mallazo_antifisurac_sin_puntal","index":3,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":true,"merged":[[4,2,4,5],[4,1,44,1]]}
[]
[]
[]
[]
[null,"ELECCIÓN MALLAZO ANTIFISURACIÓN SIN PUNTAL"]
[]
[null,null,"H=4","Solución 1.4","Solución 2.4","Solución 3.4","Solución 4.4","Solución 5.4","Solución 6.4","Solución 7.4","Solución 8.4","Solución 9.4"]
[null,null,null,"150 x 150 x 5","200 x 200 x 6","150 x 150 x 6","200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=5","Solución 1.5","Solución 2.5","Solución 3.5","Solución 4.5","Solución 5.5","Solución 6.5","Solución 7.5"]
[null,null,null,"150 x 150 x 6","200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=6","Solución 1.6","Solución 2.6","Solución 3.6","Solución 4.6","Solución 5.6","Solución 6.6","Solución 7.6"]
[null,null,null,"150 x 150 x 6","200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=7","Solución 1.7","Solución 2.7","Solución 3.7","Solución 4.7","Solución 5.7","Solución 6.7"]
[null,null,null,"200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=8","Solución 1.8","Solución 2.8","Solución 3.8","Solución 4.8","Solución 5.8","Solución 6.8"]
[null,null,null,"200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=9","Solución 1.9","Solución 2.9","Solución 3.9","Solución 4.9","Solución 5.9","Solución 6.9"]
[null,null,null,"200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=10","Solución 1.10","Solución 2.10","Solución 3.10","Solución 4.10","Solución 5.10","Solución 6.10"]
[null,null,null,"200 x 200 x 8","150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=11","Solución 1.11","Solución 2.11","Solución 3.11","Solución 4.11","Solución 5.11"]
[null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=12","Solución 1.12","Solución 2.12","Solución 3.12","Solución 4.12","Solución 5.12"]
[null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=13","Solución 1.13","Solución 2.13","Solución 3.13","Solución 4.13","Solución 5.13"]
[null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=14","Solución 1.14","Solución 2.14","Solución 3.14","Solución 4.14","Solución 5.14"]
[null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=15","Solución 1.15","Solución 2.15","Solución 3.15","Solución 4.15"]
[null,null,null,"200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,"H=16","Solución 1.16","Solución 2.16","Solución 3.16","Solución 4.16"]
[null,null,null,"200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]

{"sheet":"mallazo_antifisurac_con_puntal","index":4,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":true,"merged":[[9,4,9,6],[8,2,62,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ELECCIÓN MALLAZO ANTIFISURACIÓN CON PUNTAL"]
[]
[]
[null,null,null,null,"H=4"]
[null,null,null,null,null,"Solución 1.4","Solución 2.4","Solución 3.4","Solución 4.4","Solución 5.4"]
[null,null,null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=5"]
[null,null,null,null,null,"Solución 1.5","Solución 2.5","Solución 3.5","Solución 4.5","Solución 5.5"]
[null,null,null,null,null,"150 x 150 x 8","200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=6"]
[null,null,null,null,null,"Solución 1.6","Solución 2.6","Solución 3.6","Solución 4.6"]
[null,null,null,null,null,"200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=7"]
[null,null,null,null,null,"Solución 1.7","Solución 2.7","Solución 3.7","Solución 4.7"]
[null,null,null,null,null,"200 x 200 x 10","150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=8"]
[null,null,null,null,null,"Solución 1.8","Solución 2.8","Solución 3.8"]
[null,null,null,null,null,"150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=9"]
[null,null,null,null,null,"Solución 1.9","Solución 2.9","Solución 3.9"]
[null,null,null,null,null,"150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=10"]
[null,null,null,null,null,"Solución 1.10","Solución 2.10","Solución 3.10"]
[null,null,null,null,null,"150 x 150 x 10","200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=11"]
[null,null,null,null,null,"Solución 1.11","Solución 2.11"]
[null,null,null,null,null,"200 x 200 x 12","150 x 150 x 12"]
[]
[null,null,null,null,"H=12"]
[null,null,null,null,null,"Solución 1.12"]
[null,null,null,null,null,"150 x 150 x 12"]
[]
[null,null,null,null,"H=13"]
[null,null,null,null,null,"Solución 1.13"]
[null,null,null,null,null,"150 x 150 x 12"]
[]
[null,null,null,null,"H=14"]
[null,null,null,null,null,"Solución 1.14"]
[null,null,null,null,null,"150 x 150 x 12"]
[]
[null,null,null,null,"H=15"]
[null,null,null,null,null,"Solución 1.15"]
[null,null,null,null,null,"150 x 150 x 12"]
[]
[null,null,null,null,"H=16"]
[null,null,null,null,null,"Solución 1.16"]
[null,null,null,null,null,"150 x 150 x 12"]

{"sheet":"cargas_de_encofrado","index":5,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":true,"merged":[[45,1,57,1],[45,3,57,3],[6,5,57,5],[5,7,57,7],[32,1,44,1],[32,3,44,3],[6,1,18,1],[6,3,18,3],[19,1,31,1],[19,3,31,3]]}
[]
[]
[]
[]
[]
[null,"Espesor de chapa (mm)","Altura losa hormigón (cm)","Peso chapa (kg/m2)","Peso hormigón (kg/m2)","Carga de ejecución (kg/m2)","Carga total (kg/m2)","Cargas en fase de encofrado según Eurocódigo 4"]
[null,0.7,40,7.21,164,150,321.21000000000004]
[null,null,50,null,189,null,346.21]
[null,null,60,null,214,null,371.21000000000004]
[null,null,70,null,239,null,396.21]
[null,null,80,null,264,null,421.21]
[null,null,90,null,289,null,446.21]
[null,null,100,null,314,null,471.21]
[null,null,110,null,339,null,496.21]
[null,null,120,null,364,null,521.21]
[null,null,130,null,390,null,547.21]
[null,null,140,null,415,null,572.21]
[null,null,150,null,440,null,597.21]
[null,null,160,null,465,null,622.21]
[null,0.8,40,8.25,164,null,322.25]
[null,null,50,null,189,null,347.25]
[null,null,60,null,214,null,364]
[null,null,70,null,239,null,397.25]
[null,null,80,null,264,null,422.25]
[null,null,90,null,289,null,447.25]
[null,null,100,null,314,null,472.25]
[null,null,110,null,339,null,497.25]
[null,null,120,null,364,null,522.25]
[null,null,130,null,390,null,548.25]
[null,null,140,null,415,null,573.25]
[null,null,150,null,440,null,598.25]
[null,null,160,null,465,null,623.25]
[null,1,40,10.31,164,null,324.31]
[null,null,50,null,189,null,349.31]
[null,null,60,null,214,null,374.31]
[null,null,70,null,239,null,399.31]
[null,null,80,null,264,null,424.31]
[null,null,90,null,289,null,449.31]
[null,null,100,null,314,null,474.31]
[null,null,110,null,339,null,499.31]
[null,null,120,null,364,null,524.30999999999995]
[null,null,130,null,390,null,550.30999999999995]
[null,null,140,null,415,null,575.30999999999995]
[null,null,150,null,440,null,600.30999999999995]
[null,null,160,null,465,null,625.30999999999995]
[null,1.2,40,12.36,164,null,326.36]
[null,null,50,null,189,null,351.36]
[null,null,60,null,214,null,376.36]
[null,null,70,null,239,null,401.36]
[null,null,80,null,264,null,426.36]
[null,null,90,null,289,null,451.36]
[null,null,100,null,314,null,476.36]
[null,null,110,null,339,null,501.36]
[null,null,120,null,364,null,526.36]
[null,null,130,null,390,null,552.36]
[null,null,140,null,415,null,577.36]
[null,null,150,null,440,null,602.36]
[null,null,160,null,465,null,627.36]

{"sheet":"heficaz_mínimo","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Resistencia al fuego normalizado","Grosor eficaz mínimo"]
[null,null,null,"R30","heff=60-h3"]
[null,null,null,"R60","heff=80-h3"]
[null,null,null,"R90","heff=100-h3"]
[null,null,null,"R120","heff=120-h3"]
[null,null,null,"R180","heff=150-h3"]
[null,null,null,"R240","heff=175-h3"]

{"sheet":"2_vanos_sin_armadura_adicional","index":7,"n_rows":389,"n_cols":8,"rows_kept":389,"cut":false,"hidden":true,"merged":[[382,4,388,4],[174,6,174,7],[175,6,175,7],[180,3,180,4],[40,6,40,8],[118,1,118,4],[53,1,53,4],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[41,1,41,2],[41,6,41,8],[42,1,42,2],[43,1,44,2],[262,1,262,4],[264,1,264,2],[271,4,271,5],[289,3,292,3],[219,3,219,4],[43,4,44,4],[43,5,44,5],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[43,3,44,3]]}
[]
[]
[null,"Datos fijos"]
[]
[null,"msc",101.36,"N/mm2"]
[null,"ksc",4.4999999999999998E-2,"N/mm2"]
[null,"γvs",1.25]
[null,"tpp",60,"días"]
[null,"bo",6,"cm"]
[null,"b",22,"cm"]
[null,"b1",13,"cm"]
[null,"Es",{"$f":"2.1*10^6","v":2100000},"kg/cm2"]
[null,"Ac_v",{"$f":"C140","v":0.55292030703180362},"cm2"]
[null,"fmv",7.1400000000000005E-2]
[null,"ffv",6.3299999999999997E-3]
[null,"te",7,"días"]
[null,"tinf",10000,"días"]
[null,"d",{"$f":"C133-2","v":12}]
[null,"ρ2",0]
[null,"fr",9.0999999999999998E-2]
[null,"Tpp",7,"días"]
[null,"l1",127]
[null,"l2",60]
[null,"l3",93]
[null,"h2",60]
[null,"k",0.85]
[null,"u1",50,"mm"]
[null,"u2",50,"mm"]
[null,"u3",40,"mm"]
[null,"γs",{"$f":"'PROGRAMA HLM-60_200'!F12","v":1.1499999999999999}]
[null,"d´",2,"cm"]
[null,"γc",{"$f":"'PROGRAMA HLM-60_200'!F13","v":1.5}]
[]
[]
[null,"Entrada de datos variables"]
[]
[null,"Nombre variable",null,"Unidades","Valor","Abreviatura"]
[null,"Luz de cálculo",null,"m",{"$f":"'PROGRAMA HLM-60_200'!K13","v":1.4},"L"]
[null,"Espesor de la placa nervada",null,"mm",{"$f":"'PROGRAMA HLM-60_200'!K15","v":0.8},"ec"]
[null,"Altura de la losa de hormigón",null,"cm",{"$f":"'PROGRAMA HLM-60_200'!K16","v":8},"H",4]
[null,"Sobrecarga útil (suma de uso más cargas muertas, más tabiquería…)",null,"daN/m2",{"$f":"'PROGRAMA HLM-60_200'!F7","v":1000},"Quso","Recordar que no es la de uso exactamente, sino la suma de la de uso mas tabiquería más cargas  muertas…"]
[null,"Tipo de cemento (1, 2 ó 3)",null,null,{"$f":"'PROGRAMA HLM-60_200'!F17","v":2},null,"Tipo 2: Endurecimiento normal"]
[null,"Resistencia característica del hormigón",null,"kg/cm2",{"$f":"'PROGRAMA HLM-60_200'!F15*10","v":250},"fck"]
[null,"HUMEDAD RELATIVA( 50% Ó 80%)",null,null,{"$f":"'PROGRAMA HLM-60_200'!F18","v":50}]
[]
[null,"Calidad de la placa de acero",null,"kg/cm2",{"$f":"IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$26,2500,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$27,3200,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!$A$28,3500,IF(HOJA_RESULTADOS!$F$17=HOJA_RESULTADOS!A29,2800))))","v":2500},"σ"]
[null,"Resistencia al fuego requerida",null,null,{"$f":"'PROGRAMA HLM-60_200'!R8","v":"R30"},"RF","R30"]
[null,"Altura del pavimento",null,"mm",{"$f":"'PROGRAMA HLM-60_200'!R6","v":0},"h3"]
[null,"Resistencia característica del hormigón a 20ºC",null,null,{"$f":"E43/10","v":25},"fc_20ºC"]
[null,"Resistencia del acero a 20ºC",null,null,{"$f":"'PROGRAMA HLM-60_200'!F16","v":500},"fsy_20ºC"]
[]
[]
[]
[null,"CRITERIO DE FLEXIÓN"]
[]
[]
[null,"Elección del mallazo de negativos"]
[]
[]
[]
[null,{"$f":"IF('PROGRAMA HLM-60_200'!R14=\"NO\",'PROGRAMA HLM-60_200'!L22,IF('PROGRAMA HLM-60_200'!R14=\"SI\",'PROGRAMA HLM-60_200'!L23))","v":"200 x 200 x 8"}]
[]
[null,"Ø",{"$f":"IF(B61=\"150 x 150 x 5\",0.5,IF(B61=\"200 x 200 x 6\",0.6,IF(B61=\"150 x 150 x 6\",0.6,IF(B61=\"200 x 200 x 8\",0.8,IF(B61=\"150 x 150 x 8\",0.8,IF(B61=\"200 x 200 x 10\",1,IF(B61=\"150 x 150 x 10\",1,IF(B61=\"150 x 150 x 12\",1.2,IF(B61=\"200 x 200 x 12\",1.2)))))))))","v":0.8}]
[]
[null,"s",{"$f":"IF(B61=\"150 x 150 x 5\",150,IF(B61=\"200 x 200 x 6\",200,IF(B61=\"150 x 150 x 6\",150,IF(B61=\"200 x 200 x 8\",200,IF(B61=\"150 x 150 x 8\",150,IF(B61=\"200 x 200 x 10\",200,IF(B61=\"150 x 150 x 10\",150,IF(B61=\"200 x 200 x 12\",200,IF(B61=\"150 x 150 x 12\",150)))))))))","v":200}]
[]
[null,"At",{"$f":"(PI()*(C63^2)*1000*22)/(4*C65*100)","v":0.55292030703180362}]
[]
[null,"fyd",{"$f":"(E50*10/C30)","v":4347.826086956522}]
[]
[null,"Us1",{"$f":"C67*C69","v":2404.0013349208853}]
[]
[null,"Us2",0]
[]
[null,"fcd",{"$f":"E43/C32","v":166.66666666666666}]
[]
[null,"h",{"$f":"E40+6","v":14}]
[]
[null,"d",{"$f":"C77-2","v":12}]
[]
[null,"Uo",{"$f":"0.85*C75*C9*C79","v":10200}]
[]
[null,"Uv",{"$f":"2*C81*(C31/C79)","v":3400}]
[]
[null,"α",{"$f":"(C71+0.6*C73)/C81","v":0.23568640538440053}]
[]
[null,"Mu1",{"$f":"(((0.24*C83*C31*(C83-C71+C73)*((1.5*C71)+C73))/(0.6*C83+C73)^2)+(C71*(C79-C31)))*(1/100)","v":254.48473420049802}]
[]
[null,"MU2",{"$f":"((C71-C73)*(1-((C71-C73)/(2*C81)))*C79+(C73*(C79-C31)))*(1/100)","v":254.48473420049802}]
[]
[null,"Mu3",{"$f":"(((4/3)*C71)*((C85+1.2)/(C85+((C85^2)+1.92*(C71/C81))^(1/2))-0.5)*C79+(C73*(C79-C31)))*(1/100)","v":389.90228105304016}]
[]
[]
[null,"Us1-Us2",{"$f":"C71-C73","v":2404.0013349208853}]
[]
[null,"0,5*Uo",{"$f":"0.5*C81","v":5100}]
[]
[]
[null,"Mu",{"$f":"IF(C94<C83,C87,IF(E99=TRUE,C89,IF(C96<C94,C91)))","v":254.48473420049802},null,{"$f":"AND(C83<C94,C94<C96)","v":false}]
[]
[null,"Qpp",{"$f":"IF(E40=4,E104,IF(E40=5,E105,IF(E40=6,E106,IF(E40=7,E107,IF(E40=8,E108,IF(E40=9,E109,IF(E40=10,E110,IF(E40=11,E111,IF(E40=12,E112,IF(E40=13,E113,IF(E40=14,E114,IF(E40=15,E115,IF(E40=16,E116)))))))))))))","v":265}]
[null,"Qpp_m",{"$f":"IF(E40=F104,(E104*22/100),IF(E40=F105,(E105*22/100),IF(E40=F106,(E106*22/100),IF(E40=F107,(E107*22/100),IF(E40=F108,(E108*22/100),IF(E40=F109,(E109*22/100),IF(E40=F110,(E110*22/100),IF(E40=F111,(E111*22/100),IF(E40=F112,(E112*22/100),IF(E40=F113,(E113*22/100),IF(E40=F114,(E114*22/100),IF(E40=F115,(E115*22/100),IF(E40=F116,(E116*22/100))))))))))))))","v":58.3}]
[null,null,null,null,"Qpp","H"]
[null,"Mpp",{"$f":"(1/8)*C102*E38^2","v":14.283499999999998},null,165,4]
[null,null,null,null,190,5]
[null,"Msc",{"$f":"(C99-1.35*C104)/(1.5)","v":156.80133946699868},null,215,6]
[null,null,null,null,240,7]
[null,"Qsc_s",{"$f":"(100*8*C106)/(22*E38^2)","v":2909.1157600556344},null,265,8]
[null,"Qsc_s",{"$f":"IF(C108>0,C108,0)","v":2909.1157600556344},null,299,9]
[null,null,null,null,315,10]
[null,null,null,null,340,11]
[null,null,null,null,365,12]
[null,null,null,null,390,13]
[null,null,null,null,415,14]
[null,null,null,null,440,15]
[null,null,null,null,465,16]
[]
[]
[null,"CRITERIO DE DEFORMACIÓN"]
[]
[]
[]
[null,"tpp",60,null,"s","Tipo cemento"]
[null,"s",{"$f":"IF(E42=1,E124,IF(E42=2,E125,IF(E42=3,E126)))","v":0.25},null,0.2,1]
[null,"β",{"$f":"EXP(C124*(1-(28/C123)^(1/2)))","v":1.0824397132913168},null,0.25,2]
[null,null,null,null,0.38,3]
[]
[null,"fc_flex",{"$f":"0.8*(E43)^(2/3)","v":31.748021039363984}]
[null,"  "]
[null,"fc_flex_pp",{"$f":"C128*C125","v":34.365318791415845}]
[]
[]
[null,"h",{"$f":"E40+6","v":14}]
[null,"yT",{"$f":"((C9*((C133-E40)^2)/2)+C10*E40*(C133-(E40/2)))/(C9*(C133-E40)+C10*E40)","v":8.8113207547169807}]
[null,"Ihor",{"$f":"(1/12)*C9*(C133-E40)^3+C9*(C133-E40)*(C134-((C133-E40)/2))^2+(1/12)*C10*E40^3+C10*E40*(C133-(E40/2)-C134)^2","v":2511.1194968553459}]
[null,"Ah",{"$f":"(C10*E40+((C11+C9)/2)*(C133-E40))/100^2","v":2.3300000000000001E-2}]
[null,"Ahor",{"$f":"C136*100^2","v":233},null,"At_v","ec"]
[null,"At_v",{"$f":"IF(E39=0.7,E138,IF(E39=0.8,E139,IF(E39=1,E140,IF(E39=1.2,E141))))","v":2.2999999999999998},null,2.0099999999999998,0.7]
[null,"Aneg",{"$f":"(PI()*1000*C63^2)/(4*C65)","v":2.5132741228718349},null,2.2999999999999998,0.8]
[null,"Ac_v",{"$f":"C139*22/100","v":0.55292030703180362},null,2.87,1]
[null,null,null,null,3.45,1.2]
[null,"Eci_pp",{"$f":"19000*(E43*C125)^(1/2)","v":312554.28988343984}]
[null,"npp",{"$f":"C12/C142","v":6.7188327531295391}]
[null,"d´",{"$f":"IF(E39=0.7,E145,IF(E39=0.8,E146,IF(E39=1,E147,IF(E39=1.2,E148))))","v":3.3395000000000001},null,"d´","ec"]
[null,null,null,null,3.3399000000000001,0.7]
[null,"yhv_pp",{"$f":"(C137*C134+C143*C138*C144+C143*C140*(C133-C144))/(C137+C143*C138+C143*C140)","v":8.5032403532618428},null,3.3395000000000001,0.8,null,{"$f":"'PROGRAMA HLM-60_200'!K23","v":0}]
[null,"Ihv_pp",{"$f":"C135+C137*(C146-C134)^2+C143*C138*(C146-C144)^2+C143*C144*(C133-C146-C144)^2","v":3049.7040053994574},null,3.3378000000000001,1]
[null,null,null,null,3.3376999999999999,1.2]
[null,"Whv_pp",{"$f":"C147/C146","v":358.65198191529316}]
[]
[]
[]
[null,"Mfv",{"$f":"C130*C149","v":12325.18969369216}]
[]
[]
[null,"Mv",{"$f":"(C14*(C101+C109)*C10*(E38*100)^2)/10000","v":9772.3660303549659}]
[]
[null,"ξv",{"$f":"1-0.5*(C153/C156)^2","v":0.20465092965578102}]
[]
[]
[null,"FLECHA DE SOBRECARGA"]
[]
[null,"Ecm",{"$f":"44100*(E76+80)^(1/3)","v":190021.13966081207}]
[null,"β",{"$f":"EXP(C124*(1-(28/C17)^(1/2)))","v":1.2671512154708973}]
[null,"Eci_inf",{"$f":"19000*(E43*C164)^(1/2)","v":338172.14136626996}]
[null,"ninf",{"$f":"C12/C165","v":6.209855109636357}]
[null,"yhv_inf",{"$f":"(C137*C134+C166*C138*C144+C166*C140*(C133-C144))/(C137+C166*C138+C166*C140)","v":8.524929498359489}]
[null,"Ihv_inf",{"$f":"C135+C137*(C167-C134)^2+C166*C138*(C167-C144)^2+C166*C140*(C133-C167-C144)^2","v":2929.9314699597758}]
[null,"Ih_inf",{"$f":"0.85*C168","v":2490.4417494658092}]
[]
[null,"Fsc_I",{"$f":"C15*(C109*C10*(E38*100)^4)/(100*100*C169*C165)","v":1.847929169879917E-2}]
[]
[null,"δf",{"$f":"E40/C18","v":0.66666666666666663}]
[null,"ξf",{"$f":"C173*((C10/C9)-1)","v":1.7777777777777777}]
[null,"ρ1",{"$f":"C138/(C10*C18)","v":8.712121212121211E-3},null,null,null,"SECCIÓN RECTANGULAR"]
[null,"ρ2",{"$f":"C140/(C10*C18)","v":2.0943951023931957E-3},null,null,null,"SECCIÓN T"]
[null,"βf_inf",{"$f":"C174+C166*(C175+C176)*(C10/C9)","v":2.0238364131389828}]
[null,"αf_inf",{"$f":"(2*C166*(C175+C176*(C144/C79))*(C10/C9))+(C174*C173)","v":1.6084684211294042}]
[null,"Tf_inf",{"$f":"(C173^2+2*C166*C176*(C173-(C144/C79)))/(2*(1-C173))","v":0.68182015440227828}]
[]
[null,"ninf*ρ1",{"$f":"C166*C175","v":5.4101010424862192E-2},{"$f":"IF(C181<C178,G175,IF(C181>C178,G176))","v":"SECCIÓN RECTANGULAR"}]
[]
[null,"Xfv_inf_r",{"$f":"C18*C166*C175*(1+(C176/C175))*(-1+(1+2*((1+(C176*C144)/(C175*C79))/(C166*C175*(1+(C176/C175)^2))))^(1/2))","v":4.1774746613250757},"Comprobar"]
[null,"Ifv_inf_r",{"$f":"C166*C138*(C79-C183)*(C79-(C183/3))+C166*C140*(C183-C144)*((C183/3)-C144)","v":1179.5380366891698},"Comprobar"]
[]
[]
[null,"Xfv_inf_T",{"$f":"C79*C177*(-1+(1+(C178/C177^2))^(1/2))","v":4.3745813844378114}]
[null,"Ic_inf",{"$f":"(C10*E40*(((E40^2)/12)+(C187-(E40/2))^2))+(C9*(C187-E40)^3)/3","v":868.05889997219367}]
[null,"Ifv_inf_T",{"$f":"C188+C166*C138*(C79-C187)^2+C166*C140*(C187-C144)^2","v":1702.2319414553731}]
[]
[null,"Ifis_inf",{"$f":"IF(D181=G175,C184*0.85,IF(D181=G176,C189*0.85))","v":1002.6073311857942}]
[]
[]
[null,"Fsc_II",{"$f":"C15*(C109/100)*(C10/100)*((E38*100)^4)/(C165*C191)","v":4.5901918044840312E-2}]
[]
[]
[null,"Flecha_SC",{"$f":"C158*C194+(1-C158)*C171","v":2.4091357674119601E-2}]
[]
[]
[null,"FLECHA DEBIDA A RETRACCIÓN"]
[]
[]
[null,"Sh",{"$f":"C138*(C205-C144)","v":8.9924649804248986}]
[]
[null,"yhv_te",{"$f":"(C137*C134+C207*C138*C144+C207*C140*(C133-C144))/(C137+C207*C138+C207*C140)","v":7.2492673827934349}]
[]
[null,"nte",{"$f":"C12/C209","v":51.216124467106454}]
[]
[null,"Eeff",{"$f":"C163/(1+C213)","v":41002.711974989921}]
[]
[null,"Phor",{"$f":"C10+2*E40+4.6*2+6.9*2+C9","v":67}]
[null,"em",{"$f":"(2*C137*100)/(C211*10)","v":69.552238805970148},null,"Ø50",{"$f":"10.345*C212^(-0.1601)*C16^((-5.238*(10^(-8))*C212^2)+(3.158*(10^-5)*C212)-0.1905)","v":3.6343554001188423}]
[null,"Ø",{"$f":"IF(E44=50,F212,IF(E44=80,F214))","v":3.6343554001188423}]
[null,null,null,null,"Ø80",{"$f":"5.5952*C212^(-0.1058)*C16^(0.007289*LN(C212)-0.23155)","v":2.4173943797795014}]
[null,"βf_te",{"$f":"C174+C207*(C175+C176)*(C10/C9)","v":3.8071600213843939}]
[null,"αf_te",{"$f":"2*C207*(C175+C176*(C144/C79))*(C10/C9)+(C174*C173)","v":4.6762371524553537}]
[]
[null,"Tf_te",{"$f":"(C173^2+(2*C207*C176*(C173-(C144/C79))))/(2*(1-C173))","v":0.79164589730499779}]
[]
[null,"nte*ρ1",{"$f":"C207*C175","v":0.44620108437251826},{"$f":"IF(C220<C218,G175,IF(C220>C218,G176))","v":"SECCIÓN RECTANGULAR"}]
[]
[null,"Xfv_te_r",{"$f":"C79*C207*C175*(1+(C176/C175)*(-1+(1+2*((1+((C176*C144)/(C175*C79))))/(C207*C175*(1+(C176/C175))^2))^(1/2)))","v":6.6761808077235436}]
[null,"Ifv_te_r",{"$f":"C207*C138*(C79-C222)*(C79-(C222/3))+C207*C140*C222*((C222/3)-C144)","v":5919.3208746905766}]
[]
[null,"Xfv_te_T",{"$f":"C79*C215*(-1+(1+(C216/C215^2))^(1/2))","v":6.8553155458229496}]
[null,"Ic_te",{"$f":"C10*E40*(((E40^2)/12)+(C225-(E40/2))^2)+(C9*(C225-E40)^3)/3","v":2370.5644293178693}]
[null,"Ifv_te_T",{"$f":"C226+C207*C138*(C79-C225)^2+C207*C140*(C225-C144)^2","v":5838.4345894538201}]
[]
[null,"Xfv_te",{"$f":"IF(D220=G175,C222,IF(D220=G176,C225))","v":6.6761808077235436}]
[null,"Ifv_te",{"$f":"IF(D220=G175,C223,IF(D220=G176,C227))","v":5919.3208746905766}]
[]
[null,"Ifis_te",{"$f":"0.85*C230","v":5031.4227434869899}]
[null,"Sfis",{"$f":"C138*(C133-C229-C144)","v":9.1639341422358491}]
[]
[null,"εr_50",{"$f":"IF(C212<150,0.6/1000,IF(C212>150,(-0.00022*C177+0.63333)/1000))","v":5.9999999999999995E-4}]
[null,"εr_80",{"$f":"IF(C212<150,0.33/1000,IF(C212>150,(-0.00011*C212+0.34667)/1000))","v":3.3E-4}]
[]
[null,"εr_50",{"$f":"C235*(C16-C21)/C16","v":0}]
[null,"εr_80",{"$f":"C236*(C16-C21)/C16","v":0}]
[]
[null,"εr",{"$f":"IF(E44=50,C238,IF(E44=80,C239))","v":0}]
[]
[null,"Ihv_te",{"$f":"C135+C137*(C205-C134)^2+C207*C138*(C205-C144)^2+C207*C140*(C133-C205-C144)^2","v":5209.8490564461526}]
[null,"Ih_te",{"$f":"0.85*C243","v":4428.3716979792298}]
[]
[null,"Fret_I",{"$f":"(C20*(C203*C241*(C12/C209)*E38^2)/(C243))","v":0}]
[]
[null,"Fret_II",{"$f":"(C20*C233*C241*(C12/C209)*E38^2)/C243","v":0}]
[]
[]
[null,"Flecha _ret",{"$f":"C158*C248+(1-C158)*C246","v":0}]
[]
[]
[null,"FLECHA DEBIDA A PESO PROPIO "]
[]
[null,"Fpp_I",{"$f":"(C15*(C101)*C10*(100*E38)^4)/(100*100*C209*C244)","v":7.8077834300236777E-3}]
[]
[null,"Fpp_II",{"$f":"(C15*(C101)*C10*(100*E38)^4)/(100*100*C209*C232)","v":6.87196622669507E-3}]
[]
[null,"Flecha _PP",{"$f":"C158*C258+(1-C158)*C256","v":7.6162675693746051E-3}]
[]
[]
[null,"FLECHA TOTAL=Flecha_sc + Flecha_ret + Flecha_pp"]
[]
[null,"FLECHA TOTAL",null,{"$f":"C260+C251+C197","v":3.1707625243494207E-2},"cm"]
[]
[]
[null,"FACTOR RELACIÓN LUZ=",null,{"$f":"E38*100/D265","v":4415.3417017165393}]
[null,null,null,null,null,"\"Solución No Válida\" "]
[null,"Q_resultante",{"$f":"IF(D268>350,C109,IF(D268<350,F269))","v":2909.1157600556344},null,null,"SI","NO"]
[]
[null,"¿Q_resultante",">","Q\"uso\"?",{"$f":"IF(C270=F269,G270,IF(C270=E41,F270,IF(C270>E41,F270,IF(C270<E41,G270))))","v":"SI"}]
[]
[]
[null,"CÁLCULO DE APUNTALAMIENTOS"]
[]
[null,"I",{"$f":"IF(E39=F279,G279,IF(E39=F280,G280,IF(E39=F281,G281,IF(E39=F282,G282))))","v":62.63}]
[null,"W",{"$f":"IF(E39=F279,H279,IF(E39=F280,H280,IF(E39=F281,H281,IF(E39=F282,H282))))","v":18.71},null,null,"ec","Momento de Inercia I (cm4/m)","Módulo resistente W (cm3/m)"]
[null,"Qsc_flex",{"$f":"((E46/1.5)*(C278/100)*8)/E38^2","v":1272.7891156462588},null,null,0.7,54.79,16.71]
[null,"Qsc_def",{"$f":"((C12*C277)/10000)*192/(180*E38^3)","v":5112.6530612244896},null,null,0.8,62.63,18.71]
[null,null,null,null,null,1,78.31,23.34]
[null,null,null,null,null,1.2,94.01,27.95]
[]
[]
[null,"¿Qsc_flex","<","Qsc_def?",{"$f":"IF(C279<C280,F285,IF(C279>C280,F286))","v":"SI"},"SI"]
[null,null,null,null,null,"NO"]
[]
[null,"QSC =",{"$f":"IF(E285=F286,B280,IF(E285=F285,B279))","v":"Qsc_flex"},{"$f":"IF(C288=B280,C280,IF(C288=B279,C279))","v":1272.7891156462588}]
[]
[null,"QSC_EUROCÓDIGO_0,7",{"$f":"IF(E39=0.7,IF(E40=4,cargas_de_encofrado!$G$7,IF(E39=0.7,IF(E40=5,cargas_de_encofrado!$G$8,IF(E39=0.7,IF(E40=6,cargas_de_encofrado!$G$9,IF(E39=0.7,IF(E40=7,cargas_de_encofrado!$G$10,IF(E39=0.7,IF(E40=8,cargas_de_encofrado!$G$11,IF(E39=0.7,IF(E40=9,cargas_de_encofrado!$G$12,IF(E39=0.7,IF(E40=10,cargas_de_encofrado!$G$13,IF(E39=0.7,IF(E40=11,cargas_de_encofrado!$G$14,IF(E39=0.7,IF(E40=12,cargas_de_encofrado!$G$15,IF(E39=0.7,IF(E40=13,cargas_de_encofrado!$G$16,IF(E39=0.7,IF(E40=14,cargas_de_encofrado!$G$17,IF(E39=0.7,IF(E40=15,cargas_de_encofrado!$G$18,IF(E39=0.7,IF(E40=16,cargas_de_encofrado!$G$19))))))))))))))))))))))))))","v":false}]
[null,"QSC_EUROCÓDIGO_0,8",{"$f":"IF(E39=0.8,IF(E40=4,cargas_de_encofrado!$G$20,IF(E39=0.8,IF(E40=5,cargas_de_encofrado!$G$21,IF(E39=0.8,IF(E40=6,cargas_de_encofrado!$G$22,IF(E39=0.8,IF(E40=7,cargas_de_encofrado!$G$23,IF(E39=0.8,IF(E40=8,cargas_de_encofrado!$G$24,IF(E39=0.8,IF(E40=9,cargas_de_encofrado!$G$25,IF(E39=0.8,IF(E40=10,cargas_de_encofrado!$G$26,IF(E39=0.8,IF(E40=11,cargas_de_encofrado!$G$27,IF(E39=0.8,IF(E40=12,cargas_de_encofrado!$G$28,IF(E39=0.8,IF(E40=13,cargas_de_encofrado!$G$29,IF(E39=0.8,IF(E40=14,cargas_de_encofrado!$G$30,IF(E39=0.8,IF(E40=15,cargas_de_encofrado!$G$31,IF(E39=0.8,IF(E40=16,cargas_de_encofrado!$G$32))))))))))))))))))))))))))","v":422.25}]
[null,"QSC_EUROCÓDIGO_1,0",{"$f":"IF(E39=1,IF(E40=4,cargas_de_encofrado!$G$33,IF(E39=1,IF(E40=5,cargas_de_encofrado!$G$34,IF(E39=1,IF(E40=6,cargas_de_encofrado!$G$35,IF(E39=1,IF(E40=7,cargas_de_encofrado!$G$36,IF(E39=1,IF(E40=8,cargas_de_encofrado!$G$37,IF(E39=1,IF(E40=9,cargas_de_encofrado!$G$38,IF(E39=1,IF(E40=10,cargas_de_encofrado!$G$39,IF(E39=1,IF(E40=11,cargas_de_encofrado!$G$40,IF(E39=1,IF(E40=12,cargas_de_encofrado!$G$41,IF(E39=1,IF(E40=13,cargas_de_encofrado!$G$42,IF(E39=1,IF(E40=14,cargas_de_encofrado!$G$43,IF(E39=1,IF(E40=15,cargas_de_encofrado!$G$44,IF(E39=1,IF(E40=16,cargas_de_encofrado!$G$45))))))))))))))))))))))))))","v":false}]
[null,"QSC_EUROCÓDIGO_1,2",{"$f":"IF(E39=1.2,IF(E40=4,cargas_de_encofrado!$G$46,IF(E39=1.2,IF(E40=5,cargas_de_encofrado!$G$47,IF(E39=1.2,IF(E40=6,cargas_de_encofrado!$G$48,IF(E39=1.2,IF(E40=7,cargas_de_encofrado!$G$49,IF(E39=1.2,IF(E40=8,cargas_de_encofrado!$G$50,IF(E39=1.2,IF(E40=9,cargas_de_encofrado!$G$51,IF(E39=1.2,IF(E40=10,cargas_de_encofrado!$G$52,IF(E39=1.2,IF(E40=10,cargas_de_encofrado!$G$52,IF(E39=1.2,IF(E40=11,cargas_de_encofrado!$G$53,IF(E39=1.2,IF(E40=12,cargas_de_encofrado!$G$54,IF(E39=1.2,IF(E40=13,cargas_de_encofrado!$G$55,IF(E39=1.2,IF(E40=14,cargas_de_encofrado!$G$56,IF(E39=1.2,IF(E40=15,cargas_de_encofrado!$G$57,IF(E39=1.2,IF(E40=16,cargas_de_encofrado!$G$58))))))))))))))))))))))))))))","v":false}]
[]
[null,"QSC_EUROCÓDIGO",{"$f":"MAX(C290:C293)","v":422.25}]
[]
[null,{"$f":"C288","v":"Qsc_flex"},">","QSC_EUROCÓDIGO?",{"$f":"IF(D288>C295,F285,IF(D288<C295,F286))","v":"SI"},null,"SI"]
[null,null,null,null,null,null,"NO"]
[null,{"$f":"IF(E297=F286,G297,IF(E297=F285,G298))","v":"NO"}]
[]
[]
[null,"Elección del mallazo antifisuración por el cliente"]
[]
[]
[null,"Mallazo seleccionado",{"$f":"HOJA_RESULTADOS!J71","v":"150 x 150 x 10"}]
[]
[]
[]
[null,"CÁLCULO DE FUEGO"]
[]
[null,"CRITERIO DE AISLAMIENTO"]
[]
[null,"h2/H",{"$f":"C25/(E40*10)","v":0.75}]
[null,"heff",{"$f":"E40*10*(1+0.75*((C22+C23)/(C22+C24)))","v":131}]
[null,"heff",{"$f":"(E40*10)+0.5*C25*((C22+C23)/(C22+C24))","v":105.5}]
[]
[null,"heff",{"$f":"IF(C313>1.5,C314,IF(C313<1.5,C315,IF(C313=1.5,C315,\"ERROR\")))","v":105.5},null,"Resistencia al fuego normalizado","Grosor eficaz mínimo"]
[null,"heff_min",{"$f":"IF(E47=E318,G318,IF(E47=E319,G319,IF(E47=E320,G320,IF(E47=E321,G321,IF(E47=E322,G322,IF(E47=E323,G323,\"ERROR\"))))))","v":60},null,"R30","heff=60-h3",{"$f":"60-E48","v":60}]
[null,null,null,null,"R60","heff=80-h3",{"$f":"80-E48","v":80}]
[null,null,null,null,"R90","heff=100-h3",{"$f":"100-E48","v":100}]
[null,null,null,null,"R120","heff=120-h3",{"$f":"120-E48","v":120}]
[null,null,null,null,"R180","heff=150-h3",{"$f":"150-E48","v":150}]
[null,null,null,null,"R240","heff=175-h3",{"$f":"175-E48","v":175}]
[]
[]
[null,"¿heff_min","<","heff?",null,"SI"]
[null,null,null,null,null,"NO"]
[null,{"$f":"IF(C318<C317,F326,IF(C318>C317,F327,\"ERROR\"))","v":"SI"},null,null,null,"NO"]
[]
[null,{"$f":"IF(E40=G40,F327,IF(B328=F327,F328,IF(B328=F326,F326)))","v":"SI"}]
[]
[]
[null,"CRITERIO DE RESISTENCIA"]
[]
[]
[null,"Q",{"$f":"E41/100","v":10},null,null,"Espesor de losa (cm)","Peso losa(KN/m2)"]
[null,"G",{"$f":"IF(E40=F337,G337,IF(E40=F338,G338,IF(E40=F339,G339,IF(E40=F340,G340,IF(E40=F341,G341,IF(E40=F342,G342,IF(E40=F344,G344,IF(E40=F345,G345,IF(E40=F346,G346,IF(E40=F347,G347,IF(E40=F348,G348,IF(E40=F349,G349,IF(E40=F350,G350,\"ERROR\")))))))))))))","v":2.65},null,null,4,1.65]
[null,null,null,null,null,5,1.89]
[null,"A",{"$f":"IF(E47=E319,E354,IF(E47=E320,E356,IF(E47=E321,E358,IF(E47=E322,E360,IF(E47=E323,E362)))))","v":false},null,null,6,2.15]
[null,"B",{"$f":"IF(E47=E319,F354,IF(E47=E320,F356,IF(E47=E321,F358,IF(E47=E322,F360,IF(E47=E323,F362)))))","v":false},null,null,7,2.39]
[null,"C",{"$f":"IF(E47=E319,G354,IF(E47=E320,G356,IF(E47=E321,G358,IF(E47=E322,G360,IF(E47=E323,G362)))))","v":false},null,null,8,2.65]
[null,"Acr",{"$f":"(C343*E50)/(0.85*E49)","v":5913.5861714631392},null,null,9,2.89]
[null,"As_neg",{"$f":"(PI()*1000*(C63*10)^2)/(4*C65)","v":251.32741228718342}]
[null,"e",{"$f":"(1/(2*C339)*(-C340+((C340^2+4*C339*C342-4*C339*C341)^(1/2))))","v":{"$error":"#DIV/0!"}},null,null,10,3.15]
[null,"u4",20,null,null,11,3.39]
[null,null,null,null,null,12,3.65]
[null,"Mneg_ext",{"$f":"(0.85*E49*C342*(C317-C345-C344))/(10^6)","v":{"$error":"#DIV/0!"}},null,null,13,3.9]
[null,null,null,null,null,14,4.1500000000000004]
[null,null,null,null,null,15,4.4000000000000004]
[null,"Mpv_ext",{"$f":"(0.85*(C337+C336)/8)*E38^2-(0.5*C347)","v":{"$error":"#DIV/0!"}},null,null,16,4.6500000000000004]
[]
[]
[null,"θ",{"$f":"IF(E47=F375,G375,IF(E47=F376,G376,IF(E47=F377,G377,IF(E47=F378,G378,IF(E47=F379,G379)))))","v":false},null,"A60","B60","C60"]
[null,"z",{"$f":"1/((1/(C27)^(1/2))+(1/(C28)^(1/2))+(1/(C29)^(1/2)))","v":2.2677968993854551},null,11.488,724.17281000000003,-2182.8357099999998]
[null,"kcal",{"$f":"F366*(C353)^(5)-F367*(C353)^(4)+F368*(C353)^(3)-F369*(C353)^(2)+(F370*C353)-F371","v":-9.6515662159594307},null,"A90","B90","C90"]
[null,null,null,null,13.459,350.14967999999999,-1540.2130999999999]
[null,"Kmáx",{"$f":"IF(C353<400,1,IF(C353>400,C355,IF(C353>950,\"ERROR MÁXIMO\")))","v":-9.6515662159594307},null,"A120","B120","C120"]
[null,null,null,null,14.12745,113.67965,-605.43892000000005]
[null,"Av_2",{"$f":"((0.85*E49*10^3)/(C357*E50))*(((E40*10)+C25-C29)-(((E40*10)+C25-C29)^2-((2*C350*10^6)/(0.85*E49*10^3)))^(1/2))","v":{"$error":"#DIV/0!"}},null,"A180","B180","C180"]
[null,null,null,null,13.676299999999999,-124.58305,568.64503000000002]
[null,{"$f":"IF(E47=G47,D362,IF(C359>0,D363,IF(C359<0,D362,\"ERROR\")))","v":"NO"},null,null,"A240","B240","C240"]
[null,null,null,"NO",12.371930000000001,-203.06941,1106.11545]
[null,null,null,"SI "]
[]
[]
[null,null,null,null,"A",4.9081000000000001E-14]
[null,"sep",{"$f":"'PROGRAMA HLM-60_200'!R9","v":220},null,"B",2.0162295699999999E-10]
[null,"Ø",{"$f":"(C359*4*C367*10^(-3)/PI())^(1/2)","v":{"$error":"#DIV/0!"}},null,"C",3.1961444828600002E-7]
[null,null,null,null,"D",2.4088468851569901E-4]
[null,"Ø",{"$f":"IF(B361=\"NO\",\"--\",IF(C368<F383,F383,IF(C368<F384,F384,IF(C368<F385,F385,IF(C368<F386,F386,IF(C368<F387,F387,IF(C368<F388,F388,IF(C368<F389,F389,\"--\"))))))))","v":"--"},null,"E",8.3489748378334797E-2]
[null,null,null,null,"F",9.6515662159594307]
[]
[]
[null,null,null,null,"θS",null,"θS"]
[null,null,null,null,"1175-350z","R60",{"$f":"1175-350*C354","v":381.27108521509069}]
[null,null,null,null,"1285-350z","R90",{"$f":"1285-350*C354","v":491.27108521509069}]
[null,null,null,null,"1370-350z","R120",{"$f":"1370-350*C354","v":576.27108521509069}]
[null,null,null,null,"1490-350z","R180",{"$f":"1490-350*C354","v":696.27108521509069}]
[null,null,null,null,"1575-350z","R240",{"$f":"1575-350*C354","v":781.27108521509069}]
[]
[]
[]
[null,null,null,null,"Ø",6]
[null,null,null,null,null,8]
[null,null,null,null,null,10]
[null,null,null,null,null,12]
[null,null,null,null,null,14]
[null,null,null,null,null,16]
[null,null,null,null,null,20]

{"sheet":"casos de 2 vanos particulares","index":8,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"H","L","e","Mallazo de negativos","Sobrecarga"]
[null,4,1.4,1.2,"150 x 150 x 5",2401]
[null,4,1.8,1.2,"150 x 150 x 5",1434]
[null,4,2,1.2,"150 x 150 x 5",1150]
[null,4,2.2000000000000002,1.2,"150 x 150 x 5",938]
[null,4,2.4,1.2,"150 x 150 x 5",776]
[null,4,2.6,1.2,"150 x 150 x 5",648]
[null,4,2.8,1.2,"150 x 150 x 5",547]
[null,6,2.8,1.2,"150 x 150 x 6",712]
[null,6,3.2,1.2,"200 x 200 x 10",516]
[null,6,3.4,1.2,"200 x 200 x 10",442]
[null,6,3.6,1.2,"200 x 200 x 10",380]
[null,8,1.6,1,"200 x 200 x 8",2459]
[null,8,1.6,1.2,"200 x 200 x 8",2931]
[null,8,1.8,1,"200 x 200 x 8",1925]
[null,8,1.8,1.2,"200 x 200 x 8",2298]
[null,8,2,1,"200 x 200 x 8",1540]
[null,8,2,1.2,"200 x 200 x 8",1842]
[null,8,2.2000000000000002,1,"200 x 200 x 8",1253]
[null,8,2.2000000000000002,1.2,"200 x 200 x 8",1503]
[null,8,2.4,1,"200 x 200 x 8",1033]
[null,8,2.4,1.2,"200 x 200 x 8",1243]
[null,8,2.6,1,"200 x 200 x 8",860]
[null,8,2.6,1.2,"200 x 200 x 8",1039]
[null,8,2.8,1.2,"200 x 200 x 8",876]
[null,10,1.6,1,"200 x 200 x 8",2921]
[null,10,1.8,1,"200 x 200 x 8",2287]
[null,10,1.8,1.2,"200 x 200 x 8",2730]
[null,10,2,1,"200 x 200 x 8",1829]
[null,10,2,1.2,"200 x 200 x 8",2188]
[null,10,2.2000000000000002,1,"200 x 200 x 8",1488]
[null,10,2.2000000000000002,1.2,"200 x 200 x 8",1785]
[null,10,2.4,1,"200 x 200 x 8",1227]
[null,10,2.4,1.2,"200 x 200 x 8",1476]
[null,10,2.6,1.2,"200 x 200 x 8",1234]
[null,12,1.8,1.2,"150 x 150 x 8",3162]
[null,12,2,1.2,"150 x 150 x 8",2535]
[null,12,2.2000000000000002,1.2,"150 x 150 x 8",2067,null,null,null,null,"P","temp","cota"]
[null,12,2.4,1.2,"150 x 150 x 8",1710,null,null,null,null,835,13.6,508,{"$f":"IF(P>800,IF(temp<15,IF(cota>450,\"CORRECTO\",\"COTA BAJA\"),\"TEMP ALTA\"),\"POCA PREC\")","v":"CORRECTO"}]
[null,null,null,null,null,null,null,null,null,null,451,16.899999999999999,601,{"$f":"IF(P>800,IF(temp<15,IF(cota>450,\"CORRECTO\",\"COTA BAJA\"),\"TEMP ALTA\"),\"POCA PREC\")","v":"POCA PREC"}]
[null,null,null,null,null,null,null,null,null,null,892,14.8,385,{"$f":"IF(P>800,IF(temp<15,IF(cota>450,\"CORRECTO\",\"COTA BAJA\"),\"TEMP ALTA\"),\"POCA PREC\")","v":"COTA BAJA"}]
[null,null,null,null,null,null,null,null,null,null,911,12.9,750,{"$f":"IF(P>800,IF(temp<15,IF(cota>450,\"CORRECTO\",\"COTA BAJA\"),\"TEMP ALTA\"),\"POCA PREC\")","v":"CORRECTO"}]
[null,null,null,null,null,null,null,null,null,null,902,16.100000000000001,547,{"$f":"IF(P>800,IF(temp<15,IF(cota>450,\"CORRECTO\",\"COTA BAJA\"),\"TEMP ALTA\"),\"POCA PREC\")","v":"TEMP ALTA"}]