{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Diseño Albañileria"],"not_rendered":{"images":24,"macros":1,"defined_names":237,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Diseño Albañileria","index":0,"n_rows":252,"n_cols":25,"rows_kept":252,"merged":[[2,0,2,13],[6,0,6,20],[9,0,9,20],[10,0,10,20],[12,10,12,12],[14,4,14,5],[14,10,14,11],[14,17,14,19],[16,4,16,5],[16,10,16,11],[16,17,16,18],[20,3,21,5],[20,6,21,7],[20,8,21,9],[20,10,21,11],[20,12,21,13],[20,14,21,15],[20,16,21,17],[22,3,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[35,2,35,3],[35,9,35,10],[35,17,35,18],[39,11,40,19],[42,2,42,3],[42,6,42,7],[42,12,42,13],[42,17,42,18],[49,1,49,2],[49,9,49,10],[49,17,49,18],[55,3,55,4],[55,7,55,8],[55,9,55,10],[55,14,55,18],[61,2,61,3],[61,7,61,8],[61,12,61,13],[61,16,61,17],[61,18,61,19],[63,3,63,7],[63,13,63,17],[65,16,65,17],[65,18,65,19],[66,17,66,19],[67,17,67,18],[68,17,68,19],[69,16,69,17],[69,18,69,19],[70,17,70,19],[71,1,71,5],[71,6,71,7],[71,17,71,18],[72,17,72,19],[73,6,73,7],[73,16,73,17],[73,18,73,19],[75,3,75,12],[75,13,75,17],[81,2,81,3],[81,7,81,8],[81,12,81,13],[81,17,81,18],[85,6,85,7],[85,12,85,13],[85,17,85,18],[94,2,94,3],[94,7,94,8],[94,11,94,12],[94,16,94,17],[107,6,107,7],[107,16,107,17],[111,6,111,7],[111,14,114,20],[112,6,112,7],[114,6,114,7],[118,6,118,7],[119,6,119,7],[121,6,121,7],[135,13,135,17],[137,5,137,6],[137,15,137,16],[138,3,138,7],[138,13,138,17],[142,5,142,6],[142,15,142,16],[146,7,146,8],[146,13,146,14],[146,15,146,16],[150,3,150,4],[150,8,150,9],[150,13,150,14],[150,18,150,19],[156,4,156,5],[156,7,156,8],[156,14,156,15],[156,17,156,18],[165,15,165,16],[166,13,166,17],[168,15,168,16],[169,13,169,17],[173,7,173,8],[173,17,173,18],[177,16,177,17],[178,14,178,18],[181,10,181,11],[185,7,185,8],[185,17,185,18],[189,7,189,8],[189,17,189,18],[196,6,196,7],[196,16,196,17],[198,6,198,7],[198,16,198,17],[201,6,201,7],[201,16,201,17],[213,10,213,11],[213,15,213,16],[215,6,215,7],[215,16,215,17],[219,3,219,4],[219,8,219,9],[219,13,219,14],[221,8,221,9],[225,3,225,4],[225,9,225,10],[225,17,225,18],[229,7,229,8],[229,11,229,12],[229,15,229,16],[241,3,241,4],[241,7,241,8],[241,12,241,13],[241,17,241,18],[243,11,243,12],[243,17,243,18],[249,10,249,11],[249,15,249,16],[251,10,251,11],[251,14,251,15],[251,18,251,19]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[{"$nulls":3},"Cel:","#942656792"]
[{"$nulls":3},"Correo:","grupo_crixuz@hotmail.com"]
[{"$nulls":3},"G. General :","Max J. Cardenas Alarcon"]
["Hoja de cálculo que se distribuye de manera condicional, dar el crédito a Crixuz Ingenieria y Construccion SAC, no se tienen restricciones adicionales"]
[]
[]
["ANALISIS Y DISEÑO DE ELEMENTOS DE ALABAÑILERIA CONFINADA - E.070"]
["MEMORIA DE CALCULO"]
[]
["01","Caracteristicas del Muro :",{"$nulls":5},"Nombre del muro:"]
[]
[null,"Resistencia f'm :",{"$nulls":4},"kg/cm2",null,"Rst. v'm :",null,{"$f":"+IFERROR(MROUND(SQRT(E15),0.05),\"\")","v":{"v":0,"d":"0.00"}},null,"kg/cm2",null,"Ubicación muro :",{"$nulls":6},"f'c=(kg/cm2)",null,"f'c=",{"$f":"+F143","v":210}]
[{"$nulls":21},"f'm=(kg/cm2)",null,"f'm=",{"$f":"+E15","v":0}]
[null,"Longitud muro (l) :",{"$nulls":4},"m",null,"Altura (h) :",{"$nulls":3},"m",null,"Espesor muro (t) :",{"$nulls":4},"m",null,"L(m)",null,"L=",{"$f":"+E17","v":0}]
[{"$nulls":21},"t(m)",null,"t=",{"$f":"+R17","v":0}]
["02","Cargas y Combinaciones de Diseño",{"$nulls":19},"h(m)",null,"h=",{"$f":"+K17","v":0}]
[{"$nulls":21},"Ve(ton)",null,"Ve=",{"$f":"+K23","v":0}]
[{"$nulls":3},"Combinacion / Carga",null,null,"Pm = D+L   (Tn)",null,"Pg = D+ 0.25L (Tn)",null,"Ve          (Tn)",null,"Me         (Tn-m)",null,"Vu          (Tn)",null,"Mu          (Tn-m)",{"$nulls":4},"Me(ton.m)",null,"Me=",{"$f":"+M23","v":0}]
[{"$nulls":21},"Pg(PD+0.25PL)(ton)",null,"Pg=",{"$f":"+I23","v":0}]
[{"$nulls":3},"Valor (Tn)",{"$nulls":10},{"$f":"+IFERROR(J50,\"\")","v":""},null,{"$f":"+IFERROR(R50,\"\")","v":""},{"$nulls":4},"Pgt (Ton)",null,"Pgt=",{"$f":"+G23","v":0}]
[null,"Nota:"]
[null,"P = Carga de servicio (100% de la carga).",{"$nulls":9},"Pg = Carga de servicio (mas sobrecarga reducida).",{"$nulls":11},"v'm=",{"$f":"+SQRT(Y16)","v":{"v":0,"d":"0.00"}}]
[null,"Ve = Fuerza cortante producida por sismo moderado.",{"$nulls":9},"Me = Momento flector en el muro generado por sismo moderado."]
[null,"Vu = Fuerza cortante producida por sismo severo.",{"$nulls":9},"Mu = Momento flector en el muro generado por el sismo severo."]
[]
["03","Analisis de Esfuerzos por Cargas Verticales"]
[]
[]
[]
[]
[null,"Esfuerzo Axial.",{"$nulls":8},"Esfuerzo Admisible Carga Vertical.",{"$nulls":8},"Esfuerzo Limite."]
[]
[null,"σm =",{"$f":"+IFERROR(G23/(E17*R17),\"\")","v":""},null,"Tn/m2",{"$nulls":3},"Fa =",{"$f":"+IFERROR(0.2*E15*10*(1-(K17/(35*R17))*(K17/(35*R17))),\"\")","v":""},null,"Tn/m2",{"$nulls":4},"0.15 f'm =",{"$f":"+IFERROR(0.15*E15*10,\"\")","v":{"v":0,"d":"0.000"}},null,"Tn/m2"]
[]
["04","Analisis de Cortante y Momento Ultimo por Sismo Severo"]
[]
[{"$nulls":11},"Factores que se calcula solamente en le primer piso:         Vm1 ; Ve1"]
[]
[]
[null,"α=",{"$f":"+IFERROR(IF(Y20*Y17/Y21<0.3333,0.3333,IF(Y20*Y17/Y21>1,1,Y20*Y17/Y21)),\"\")","v":""},null,null,"Vm=",{"$f":"IFERROR(0.5*Y25*10*C43*Y18*Y17+0.23*Y22,\"\")","v":""},null,"Tn",null,null,"Vm1=",{"$f":"+G43","v":""},null,"Tn",null,"Ve1=",{"$f":"+Y20","v":{"v":0,"d":"0.000"}},null,"Tn"]
[]
[null,"Donde: Vm = Fuerza cortante asociada al agrietamiento diagonal."]
[]
[]
[]
[]
[null,"Vm1/Ve1=",null,{"$f":"+IFERROR(IF(M43/R43<2,2,IF(M43/R43>3,3,M43/R43)),\"\")","v":""},{"$nulls":4},"Vu=",{"$f":"+IFERROR(D50*Y20,\"\")","v":""},null,"Tn",{"$nulls":4},"Mu=",{"$f":"+IFERROR(D50*Y21,\"\")","v":""},null,"Tn-m"]
[]
["05","Control de la Fisuracion en los muros de albañileria"]
[]
[]
[]
[null,null,"Ve=",{"$f":"+Y20","v":{"v":0,"d":"0.000"}},null,"Tn","<","0.55Vm=",null,{"$f":"IFERROR(0.55*M43,\"\")","v":""},null,"Tn",null,null,{"$f":"+IF(D56<J56,\"Cumple - No Hay Fisuramiento\",\"No Cumple - Existe Fisuramiento\")","v":"Cumple - No Hay Fisuramiento"}]
[]
["06","Adicion de Refuerzo Horizontal por Agrietamiento de los Muros"]
[]
[]
[]
[null,"Vu=",{"$f":"+J50","v":""},null,"Tn",">","Vm=",{"$f":"+G43","v":""},null,"Tn",null,"σm =",{"$f":"+C36","v":""},null,"Tn/m2",">","0.05 f'm =",null,{"$f":"IFERROR(0.05*E15*10,\"\")","v":{"v":0,"d":"0.000"}}]
[]
[{"$nulls":3},{"$f":"+IF(C62>=H62,\"Muro Agrietado\",\"Muro No Agrietado\")","v":"Muro Agrietado"},{"$nulls":9},{"$f":"+IF(M62>=S62,\"Muro Agrietado\",\"Muro No Agrietado\")","v":"Muro Agrietado"}]
[]
[null,"La cuantia minima en los muros es :"]
[]
[]
[]
[null,"Distribucion de acero horizontal:"]
[{"$nulls":23},"Ninguno",{"v":0,"d":"0.00"}]
[null,"0.64 cm2  = 2 Ø #2 @ ",{"$nulls":6},"m",{"$nulls":14},"0.29 cm2  = 1 Ø 6mm @ ",0.29]
[{"$nulls":23},"0.58 cm2  = 2 Ø 6mm @ ",0.58]
[null,"La cuantia horizontal en el muro :",{"$nulls":4},{"$f":"IFERROR(IF(B72=\"Ninguno\",0,VLOOKUP(B72,X71:Y81,2,0)/(G72*100*R17*100)),\"\")","v":""},{"$nulls":16},"0.32 cm2  = 1 Ø #2 @ ",0.32]
[{"$nulls":23},"0.64 cm2  = 2 Ø #2 @ ",0.64]
[{"$nulls":3},"Condicion para diseñar el muro de albañileria confinada:",{"$nulls":9},{"$f":"+IFERROR(IF(AND(D64=\"Muro No Agrietado\",N64=\"Muro No Agrietado\"),\"Muro No Agrietado\",\"Muro Agrietado\"),\"\")","v":"Muro Agrietado"},{"$nulls":9},"0.5 cm2  = 1 Ø 8mm @ ",{"v":0.5,"d":"0.50"}]
[{"$nulls":23},"1.0 cm2  = 2 Ø 8mm @ ",{"v":1,"d":"1.00"}]
["07","Variables para el Diseño de Columnas en los Muros de Albañileria",{"$nulls":21},"0.71 cm2  = 1 Ø #3 @ ",0.71]
[{"$nulls":23},"1.42 cm2  = 2 Ø #3 @ ",1.42]
[null,"Carga de servicio",{"$nulls":4},"Corte por fisuramiento :",{"$nulls":4},"Momento ultimo :",{"$nulls":4},"Longitud total del muro :",{"$nulls":6},"1.13 cm2  = 1 Ø 12mm @ ",1.13]
[{"$nulls":23},"2.26 cm2  = 2 Ø 12mm @ ",2.26]
[null,"Pg=",{"$f":"+Y22","v":{"v":0,"d":"0.000"}},null,"Tn",null,"Vm=",{"$f":"+G43","v":""},null,"Tn",null,"Mu=",{"$f":"+R50","v":""},null,"Tn-m",null,"l =",{"$f":"+Y17","v":{"v":0,"d":"0.000"}},null,"m"]
[]
[null,"Numero de confinamiento",{"$nulls":4},"Lm : Long. paño mayor o la mitad de la long. total, el que sea mayor. En muros de un solo paño, Lm=l"]
[]
[null,null,"Nc=",{"$nulls":3},"Lpñmayor=",null,null,"m",null,"l / 2 =",{"$f":"+IFERROR(R82/2,\"\")","v":{"v":0,"d":"0.00"}},null,"m",null,"Lm=",{"$f":"+IFERROR(IF(D86=2,R82,MAX(I86,M86)),\"\")","v":{"v":0,"d":"0.00"}},null,"m"]
{"$rows_empty":8}
[null,"M=",{"$f":"+IFERROR(IF(N76=\"Muro no Agrietado\",M82,IF(M82-0.5*H82*Y19<0,0,M82-0.5*H82*Y19)),\"\")","v":""},null,"Tn-m",null,"F=",{"$f":"+IFERROR(C95/R82,\"\")","v":""},null,"Tn",null,"Pc=Pg/Nc=",null,{"$f":"+IFERROR(C82/D86,\"\")","v":""},"Tn",null,"Pt=0.25Pg=",null,{"$f":"+IFERROR(0.25*Y23,\"\")","v":{"v":0,"d":"0.00"}},"Tn"]
[]
["08","Fuerzas de Diseño en las Columnas de los Muros de Albañileria"]
{"$rows_empty":8}
[null,"a. Fuerza cortante en las columnas de confinamiento :"]
[]
[null,null,"Columna Exterma :",null,null,"Vc=",{"$f":"IFERROR(1.5*H82*R86/(R82*(D86+1)),\"\")","v":""},null,"Tn",{"$nulls":3},"Columna Interna :",null,null,"Vc=",{"$f":"IFERROR(H82*R86/(R82*(D86+1)),\"\")","v":""},null,"Tn"]
[]
[null,"b. Fuerzas de Traccion en las columnas de confinamiento :"]
[]
[null,null,"Columna Extrema :",null,null,"T1=",{"$f":"+IFERROR(H95-N95,\"\")","v":""},null,"Tn","Columna sin muro transversal",{"$nulls":4},"Nota: Si el valor es negativo, en esta columna domina el valor de compreion y al compararlo con los valores del paso Siguiente, elegimos el mayor de estos dos casos"]
[{"$nulls":5},"T2=",{"$f":"+IFERROR(H95-N95-S95,\"\")","v":""},null,"Tn","Columna con muro transversal"]
[]
[null,null,"Columna Interna :",null,null,"T=",{"$f":"+IFERROR(IF(D86=2,\"\",H82*Y19/R82-N95-S95),\"\")","v":""},null,"Tn","Columna sin muro transversal"]
[]
[null,"c. Fuerzas de Compresion en las columnas de confinamiento :"]
[]
[null,null,"Columna Extrema :",null,null,"C1=",{"$f":"+IFERROR(N95+H95,\"\")","v":""},null,"Tn","Columna sin muro transversal"]
[{"$nulls":5},"C2=",{"$f":"+IFERROR(N95+H95,\"\")","v":""},null,"Tn","Columna con muro transversal"]
[]
[null,null,"Columna Interna :",null,null,"C=",{"$f":"+IFERROR(IF(D86=2,\"\",N95-0.5*H82*Y19/R82),\"\")","v":""},null,"Tn","Columna sin muro transversal"]
[]
["09","Diseño de las Columnas de Confinamiento en los Muros de Albañileria"]
[]
[null,"a. Area de acero vertical requerida"]
[]
[null,null,"En muros Agrietados usar:",{"$nulls":9},"En muros No Agrietados usar:"]
[]
[]
[]
[]
[]
[{"$nulls":12},"Condicion de diseño del muro :"]
[{"$nulls":22},175]
[{"$nulls":13},{"$f":"+N76","v":"Muro Agrietado"},{"$nulls":8},210]
[{"$nulls":22},280]
[{"$nulls":4},"u=",0.8,{"$nulls":8},"Ø=",{"$f":"+IFERROR(IF(N136=\"Muro Agrietado\",0.85,0.9),\"\")","v":0.85}]
[{"$nulls":3},{"$f":"+VLOOKUP(F138,V144:W145,2,0)","v":"Juntas sin tratamiento"},{"$nulls":9},"Factor de reduccion de R."]
[]
[null,null,"Resistencia a compresion del concreto :",{"$nulls":9},"Esfuerzo de fluencia del acero :"]
[]
[{"$nulls":4},"f'c=",210,null,"kg/cm2",{"$nulls":6},"fy=",null,null,"kg/cm3"]
[{"$nulls":21},0.8,"Juntas sin tratamiento"]
[null,null,"Dimensiones minimas de las columnas :",{"$nulls":9},"Area de acero minima o 4 Ø 8mm :",{"$nulls":8},{"v":1,"d":"1.0"},"Juntas sin lechada y area rugosa"]
[]
[null,null,"Ag=",{"$f":"+IFERROR(R17*100,\"\")","v":0},"x",null,"=",{"$f":"+D147*F147","v":0},null,"cm2",{"$nulls":3},"As min=",null,{"$f":"IFERROR(MAX(0.1*F143*H147/P143,2),\"\")","v":""},null,"cm2"]
[{"$nulls":22},"6mm",0.29]
[null,null,"Columna extrema :",{"$nulls":9},"Columna Interna :",{"$nulls":9},"#2",0.32]
[{"$nulls":22},"8mm",{"v":0.5,"d":"0.50"}]
[null,null,"As1=",{"$f":"+IFERROR(IF(N136=\"Muro Agrietado\",((G108/((P143/1000)*F138*P138))+(MAX(G112:H113)/((P143/1000)*P138))),(ABS((R50/Y17)-N95))/(P138*(P143/1000))),\"\")","v":""},null,"cm2",null,"Asd=",{"$f":"+IFERROR(MAX(D151,P147),\"\")","v":{"v":0,"d":"0.00"}},{"$nulls":3},"As2=",{"$f":"+IFERROR(IF(D86=2,\"\",IF(N136=\"Muro Agrietado\",((G108/((P143/1000)*F138*P138))+(MAX(G115)/((P143/1000)*P138))),(ABS((R50/Y17)-N95))/(P138*(P143/1000)))),\"\")","v":""},null,"cm2",null,"Asd=",{"$f":"+IFERROR(IF(D86=2,\"\",MAX(N151,P147)),\"\")","v":0},{"$nulls":3},"#3",0.71]
[{"$nulls":22},"12mm",1.13]
[null,null,"Distribucion de la armadura vertical en la columna :"]
[]
[null,null,"Columna extrema :",{"$nulls":9},"Columna Interna :"]
[]
[{"$nulls":3},"Ø","#3",null,"As=",{"$f":"+C157*VLOOKUP(E157,W148:X152,2,0)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":3},"Ø","8mm",null,"As=",{"$f":"+IFERROR(IF(D86=2,\"\",M157*VLOOKUP(O157,W148:X152,2,0)),\"\")","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"b. Area del nucleo de Concreto de la Columna de Confinamiento"]
[]
[null,null,"El área de la columnas, se debe elegir el mayor valor entre 15 veces el espesor del muro, el área por diseño a compresion "]
[null,null,"y el área de diseño por corte-fricción. En el caso de muros No Agrietados, no se considera el diseño por corte - friccion"]
[]
[null,null,"Diseño por Compresion :"]
[]
[{"$nulls":14},"δ=",0.8,{"$nulls":6},0.8,"Columnas sin muros transversales"]
[{"$nulls":13},{"$f":"+VLOOKUP(P166,W166:X167,2,0)","v":"Columnas sin muros transversales"},{"$nulls":8},{"v":1,"d":"1.0"},"Columnas con muros transversales"]
[]
[{"$nulls":14},"Øc=",{"v":0.7,"d":"0.70"},{"$nulls":6},{"v":0.7,"d":"0.70"},"Para estribos cerrados"]
[{"$nulls":13},{"$f":"+VLOOKUP(P169,W169:X170,2,0)","v":"Para estribos cerrados"},{"$nulls":8},0.75,"Para estribos zunchos"]
[]
[null,null,"Diseño por Compresion :"]
[]
[{"$nulls":3},"Columna extrema :",null,null,"An=",{"$f":"IFERROR(+H157+((IF(N167=\"Columnas con muros transversales\",G120,G119)/P169)-H157*(P143/1000))/(0.85*P166*(Y15/1000)),\"\")","v":""},null,"cm2",{"$nulls":3},"Columna interma :",null,null,"An=",{"$f":"IFERROR(IF(D86=2,\"\",+H157+((IF(N167=\"Columnas con muros transversales\",G122,G122)/P169)-H157*(P143/1000))/(0.85*P166*(Y15/1000))),\"\")","v":""},null,"cm2"]
[]
[null,"c. Area de la columna de confinamiento"]
[]
[null,null,"Diseño por Corte-Friccion :",{"$nulls":12},"Øcf=",0.85]
[{"$nulls":14},"Para el diseño por corte-friccion"]
[]
[]
[null,null,"Area minima de columna por espesor del muro :",{"$nulls":6},"15t=",{"$f":"+IFERROR(MROUND(15*Y18*100,0.5),\"\")","v":{"v":0,"d":"0.0"}},null,"cm2"]
[]
[null,null,"Diseño por Corte - Friccion :"]
[]
[{"$nulls":3},"Columna extrema :",null,null,"An=",{"$f":"+IFERROR(G108/(0.2*(F143/1000)*Q178),\"\")","v":""},null,"cm2",{"$nulls":3},"Columna interma :",null,null,"An=",{"$f":"+IFERROR(IF(D86=2,\"\",Q108/(0.2*(F143/1000)*Q178)),\"\")","v":""},null,"cm2"]
[]
[null,null,"Area de la columna de confinamiento (Tomamos el valor mayor de los 03 casos mencionados anteriormente) :"]
[]
[{"$nulls":3},"Columna extrema :",null,null,"An=",{"$f":"+IFERROR(MAX(H174,H186,K182),\"\")","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":3},"Columna interma :",null,null,"An=",{"$f":"+IFERROR(IF(D86=2,\"\",MAX(R174,R186,K182)),\"\")","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"d. Dimensiones finales de la columna de confinamiento :"]
[]
[null,null,"Columna extrema :",{"$nulls":9},"Columna interma :"]
[]
[null,null,"Area de columna:",null,null,"Ac=",{"$f":"+IFERROR(ROUNDUP(H190/(Y18*100),0),\"\")","v":""},"x",{"$f":"+IFERROR(Y18*100,\"\")","v":0},"cm",null,null,"Area de columna:",null,null,"Ac=",{"$f":"+IFERROR(ROUNDUP(R190/(Y18*100),0),\"\")","v":""},"x",{"$f":"+IFERROR(IF(D86=2,\"\",Y18*100),\"\")","v":0},"cm"]
[{"$nulls":5},"Ac=",{"$f":"+IFERROR(G196*I196,\"\")","v":""},null,"cm2",{"$nulls":6},"Ac=",{"$f":"+IFERROR(Q196*S196,\"\")","v":""},null,"cm2"]
[]
[null,null,"Nucleo concreto:",null,null,"An=",{"$f":"+IFERROR((G196-4)*(I196-4),\"\")","v":""},null,"cm2",{"$nulls":3},"Nucleo concreto:",null,null,"An=",{"$f":"+IFERROR((Q196-4)*(S196-4),\"\")","v":""},null,"cm2"]
[]
[null,null,"Acero minimo :",null," Asmin= 0.1f'cAc/fy",{"$nulls":7},"Acero minimo :",null," Asmin= 0.1f'cAc/fy"]
[{"$nulls":5},"Amin=",{"$f":"IFERROR(0.1*Y15*G197/P143,\"\")","v":""},null,"cm2",{"$nulls":6},"Amin=",{"$f":"IFERROR(0.1*F143*Q197/P143,\"\")","v":""},null,"cm2"]
[]
[null,"e. Cantidad y espaciamiento del refuerzo transversal en las columnas de confinamiento"]
[]
[null,null,"El espaciamiento de los estribos o zunchos se tomará como el menor de las 4 condiciones siguientes:"]
[]
[{"$nulls":22},"6mm",0.29]
[{"$nulls":22},"#2",0.32]
[{"$nulls":22},"8mm",{"v":0.5,"d":"0.50"}]
[{"$nulls":22},"#3",0.71]
[{"$nulls":22},"12mm",1.13]
[]
[null,null,"Diametro de los estribos o zunchos :",{"$nulls":6},"Ø","#2",{"$nulls":3},"Av=",{"$f":"2*VLOOKUP(K214,W208:X212,2,0)","v":0.64},null,"cm2"]
[]
[null,null,"Espesor de nucleo :",null,null,"tn=",{"$f":"+IFERROR(I196-4,\"\")","v":{"v":-4,"d":"-4.00"}},null,"cm",{"$nulls":3},"Peralte columna :",null,null,"d=",{"$f":"+MIN(G196,Q196)-2.5","v":{"v":-2.5,"d":"-2.50"}},null,"cm"]
[]
[null,null,"Espaciamiento de los estribos :"]
[]
[null,null,"S1=",{"$f":"+IFERROR((P214*(P143/1000))/(0.3*G216*Y15*0.001*(G197/G199-1)),\"\")","v":""},null,"cm",null,"S2=",{"$f":"+IFERROR((P214*(P143/1000))/(0.12*G216*0.001*Y15),\"\")","v":{"v":0,"d":"0.00"}},null,"cm",null,"S3=",{"$f":"IF(0.25*Q216<5,5,0.25*Q216)","v":{"v":5,"d":"5.00"}},null,"cm",null,"S4=",10,"cm"]
[]
[null,null,"Elegimos el menor valor :",{"$nulls":4},"S=",{"$f":"+IF(MIN(D220,I220,N220,S220)<5,5,MIN(D220,I220,N220,S220))","v":{"v":5,"d":"5.00"}},null,"cm"]
[]
[null,"f. Zona de confinamiento en las columnas"]
[]
[null,null,"Z=",{"v":45,"d":"45.00"},null,"cm",null,"Z= 1.5 d =",null,{"$f":"+IFERROR(MROUND(1.5*Q216,0.5),\"\")","v":""},null,"cm",";","Tomamos el mayor:",null,null,"Z=",{"$f":"+MAX(D226,J226)","v":{"v":45,"d":"45.00"}},null,"cm"]
[]
[null,"g. Detalle final de la distribucion de los estribos"]
[]
[{"$nulls":4},"Estr:",1,"@",{"$f":"+MROUND(I222/100,0.05)","v":0.05},null,{"$f":"+ROUNDDOWN((R226*0.01)/(2*H230),0)","v":4},"@",{"$f":"+H230*2","v":{"v":0.1,"d":"0.10"}},null,"Rto.","@","0.25 m"]
[]
["09","Diseño de la Viga Solera en los Muros de Albañileria"]
[]
[null,"a. Determinacion del acero longitudinal de la viga solera"]
[]
[]
[]
[]
[]
[null,null,"Area transversal de la viga solera :",{"$nulls":4},"Ac=",null,"x",null,"=",{"$f":"+I240*K240","v":0},"cm2"]
[]
[null,null,"Ø=",{"v":0.9,"d":"0.90"},null,null,"Ts=",{"$f":"IFERROR(0.5*G43*R86/R82,\"\")","v":""},null,"Tn",null,"As=",{"$f":"+IFERROR(H242/(D242*(P143/1000)),\"\")","v":""},null,"cm2",null,"Amin=",{"$f":"+IFERROR(0.1*0.001*Y15*M240/(P143/1000),\"\")","v":""},null,"cm2"]
[]
[null,null,"Acero longitudinal de la viga solera :",{"$nulls":7},"Ø","#3",{"$nulls":4},"As=",{"$f":"+J244*VLOOKUP(L244,W208:X212,2,0)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"b. Definicion de los estribos en la viga solera"]
[]
[null,null,"En este tipo de vigas se considera por lo general que el area de acero de los estribos y la separacion es minima :"]
[]
[null,null,"Diametro de los estribos o zunchos :",{"$nulls":6},"Ø","8mm",{"$nulls":3},"Av=",{"$f":"2*VLOOKUP(K250,W208:X212,2,0)","v":{"v":1,"d":"1.00"}},null,"cm2"]
[]
[null,null,"Distribucion de estribos en viga solera :",{"$nulls":5},1,"@",0.05,null,4,"@",{"v":0.1,"d":"0.10"},null,"Rto.","@","0.25 m"]