{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Diseño","Datos"],"not_rendered":{"charts":3,"images":1,"macros":1,"defined_names":3,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Diseño","index":0,"n_rows":259,"n_cols":21,"rows_kept":259,"merged":[[2,0,2,10],[6,0,6,16],[9,1,9,15],[13,2,13,4],[13,7,13,8],[13,12,13,13],[14,2,14,4],[14,7,14,8],[16,2,16,3],[16,7,16,8],[16,12,16,13],[17,2,17,3],[17,7,17,8],[17,12,17,13],[28,1,28,3],[28,4,28,6],[29,2,29,3],[29,5,29,6],[29,10,29,12],[29,13,29,15],[30,2,30,3],[30,5,30,6],[31,2,31,3],[31,5,31,6],[32,2,32,3],[32,5,32,6],[33,2,33,3],[33,5,33,6],[34,2,34,3],[34,5,34,6],[35,2,35,3],[35,5,35,6],[36,2,36,3],[36,5,36,6],[37,2,37,3],[37,5,37,6],[45,4,45,5],[45,12,45,13],[49,6,49,7],[49,12,49,14],[53,4,53,5],[53,7,53,8],[55,6,55,10],[61,13,61,15],[63,7,63,8],[63,13,63,15],[74,4,74,5],[80,13,80,14],[86,11,86,12],[86,13,86,14],[90,3,90,5],[90,6,90,7],[90,11,90,12],[90,13,90,14],[97,12,97,13],[104,13,104,14],[114,6,114,7],[114,13,114,14],[116,6,116,7],[116,11,116,12],[116,13,116,14],[121,3,121,4],[121,11,121,12],[123,3,123,4],[123,11,123,12],[125,5,125,6],[125,13,125,14],[127,5,127,6],[127,13,127,14],[131,3,131,4],[131,11,131,12],[133,3,133,5],[133,11,133,13],[137,4,137,5],[137,12,137,13],[139,3,139,4],[139,11,139,12],[143,5,143,6],[143,13,143,14],[145,3,145,4],[145,11,145,12],[147,3,147,5],[147,11,147,13],[153,3,153,4],[153,11,153,12],[178,3,178,4],[178,11,178,12],[192,3,192,4],[192,11,192,12],[198,3,198,4],[198,11,198,12],[204,3,204,4],[204,11,204,12],[205,3,205,4],[205,11,205,12],[207,3,207,4],[207,11,207,12],[213,3,213,4],[213,11,213,12],[227,3,227,4],[227,11,227,12],[233,3,233,4],[233,11,233,12],[239,3,239,4],[239,11,239,12],[240,3,240,4],[240,11,240,12],[242,3,242,4],[242,11,242,12],[246,3,246,4],[246,7,246,9],[246,12,246,13],[250,1,251,2],[250,14,251,15],[256,2,256,5],[256,11,256,14],[258,3,258,4],[258,12,258,13]]}
[]
[]
["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"]
[]
[]
[null,"ANALISIS Y DISEÑO DE MUROS ESTRUCTURALES DE CONCRETO ARMADO"]
[]
["01 DATOS DE DISEÑO",{"$nulls":16},{"$f":"-H17/2","v":{"v":0,"d":"0.000"}},{"$f":"-C18/2","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R12+C17","v":{"v":0,"d":"0.000"}},{"$f":"+S12","v":{"v":0,"d":"0.000"}}]
[null,"Codigo=",{"$nulls":4},"f'c =",null,null,"kg/cm2",null,"hm =",null,null,"m",null,null,{"$f":"+R13","v":{"v":0,"d":"0.000"}},{"$f":"-H18*0.5","v":{"v":0,"d":"0.000"}}]
[null,"Block =",{"$nulls":4},"fy =",null,null,"kg/cm2",{"$nulls":7},{"$f":"+R14+(H17*0.5-C17)","v":{"v":0,"d":"0.000"}},{"$f":"+S14","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R15+(H17*0.5-M17)","v":{"v":0,"d":"0.000"}},{"$f":"+S15","v":{"v":0,"d":"0.000"}}]
[null,"Lci =",null,null,"m",null,"Lm =",null,null,"m",null,"Lcd =",null,null,"m",null,null,{"$f":"+R16","v":{"v":0,"d":"0.000"}},{"$f":"-M18*0.5","v":{"v":0,"d":"0.000"}}]
[null,"hci =",null,null,"m",null,"tm =",null,null,"m",null,"hcd =",null,null,"m",null,null,{"$f":"+R17+M17","v":{"v":0,"d":"0.000"}},{"$f":"+S17","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R18","v":{"v":0,"d":"0.000"}},{"$f":"+S18+M18","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R19-M17","v":{"v":0,"d":"0.000"}},{"$f":"+S19","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R20","v":{"v":0,"d":"0.000"}},{"$f":"+S20-(0.5*M18-0.5*H18)","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R21-(0.5*H17-M17)","v":{"v":0,"d":"0.000"}},{"$f":"+S21","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R22-(0.5*H17-C17)","v":0},{"$f":"+S22","v":{"v":0,"d":"0.000"}}]
[{"$nulls":17},{"$f":"+R23","v":0},{"$f":"0.5*C18","v":0}]
[{"$nulls":17},{"$f":"+R24-C17","v":{"v":0,"d":"0.00"}},{"$f":"+S24","v":0}]
[{"$nulls":17},{"$f":"+R25","v":{"v":0,"d":"0.00"}},{"$f":"+S25-C18","v":{"v":0,"d":"0.00"}}]
["01 CARGAS Y COMBINACIONES DE DISEÑO"]
[]
[null,"DIRECCION X-X",null,null,"DIRECCION Y-Y"]
[null,"Pcm =",null,null,"Pcm =",{"$nulls":3},"Combinaciones",null,"DIRECCION X-X",null,null,"DIRECCION Y-Y"]
[null,"Pcv =",null,null,"Pcv =",{"$nulls":3},"de Diseño",null,"Pux(tn)","Mux(tn-m)","Vux(tn)","Puy(tn)","Muy(tn-m)","Vuy(tn)"]
[null,"Pcs =",null,null,"Pcs =",{"$nulls":3},"1.4cm+1.7cv",null,{"$f":"IFERROR(1.4*C30+1.7*C31,)","v":{"v":0,"d":"0.0"}},{"$f":"1.4*C33+1.7*C34","v":{"v":0,"d":"0.0"}},{"$f":"1.4*C36+1.7*C37","v":{"v":0,"d":"0.0"}},{"$f":"1.4*F30+1.7*F31","v":{"v":0,"d":"0.0"}},{"$f":"1.4*F33+1.7*F34","v":{"v":0,"d":"0.0"}},{"$f":"1.4*F36+1.7*F37","v":{"v":0,"d":"0.0"}}]
[null,"Mcm =",null,null,"Mcm =",{"$nulls":3},"1.25(cm+cv)+cs",null,{"$f":"IFERROR(1.25*(C30+C31)+C32,)","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(C33+C34)+C35","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(C36+C37)+C38","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F30+F31)+F32","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F33+F34)+F35","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F36+F37)+F38","v":{"v":0,"d":"0.0"}}]
[null,"Mcv =",null,null,"Mcv =",{"$nulls":3},"1.25(cm+cv)-cs",null,{"$f":"IFERROR(1.25*(C30+C31)-C32,)","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(C33+C34)-C35","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(C36+C37)-C38","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F30+F31)-F32","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F33+F34)-F35","v":{"v":0,"d":"0.0"}},{"$f":"1.25*(F36+F37)-F38","v":{"v":0,"d":"0.0"}}]
[null,"Mcs =",null,null,"Mcs =",{"$nulls":3},"0.9cm+cs",null,{"$f":"IFERROR(0.9*C30+C32,)","v":{"v":0,"d":"0.0"}},{"$f":"0.9*C33+C35","v":{"v":0,"d":"0.0"}},{"$f":"0.9*C36+C38","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F30+F32","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F33+F35","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F36+F38","v":{"v":0,"d":"0.0"}}]
[null,"Vcm =",null,null,"Vcm =",{"$nulls":3},"0.9cm-cs",null,{"$f":"IFERROR(0.9*C30-C32,)","v":{"v":0,"d":"0.0"}},{"$f":"0.9*C33-C35","v":{"v":0,"d":"0.0"}},{"$f":"0.9*C36-C38","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F30-F32","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F33-F35","v":{"v":0,"d":"0.0"}},{"$f":"0.9*F36-F38","v":{"v":0,"d":"0.0"}}]
[null,"Vcv =",null,null,"Vcv =",{"$nulls":4},"Envolvente",{"$f":"+IFERROR(MAX(K32:K36),)","v":0},{"$f":"+IFERROR(MAX(L32:L36),)","v":0},0,0,0,0]
[null,"Vcs =",null,null,"Vcs ="]
[]
["02 VERIFICACION DE NECESIDAD DE ELEMENTOS DE CONFINAMIENTO"]
[]
[null,"El muro estructural necesitara elementos de confinamiento si el esfuerzo máximo de compresion en la fibra extrema es mayor de:",{"$nulls":11},"0.2f'c =",{"$f":"IFERROR(0.2*H14,)","v":{"v":0,"d":"0.00"}},"kg/cm2"]
[]
[null,"Area neta del muro estructural:",{"$nulls":7},"Momento de inercia respecto al eje y-y :"]
[]
[{"$nulls":3},"Ag =",{"$f":"+IFERROR((C17*C18+M17*M18+(H17-C17-M17)*H18)*10000,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Iy-y =",{"$f":"+IFERROR(((C18*(C17^3)/12)+C18*C17*((H17*0.5-C17*0.5)^2))+((M18*(M17^3)/12)+M18*M17*((H17*0.5-M17*0.5)^2))+(H18*((H17-C17-M17)^3)/12),)*100000000","v":{"v":0,"d":"0.00"}},null,"cm4"]
[]
[null,"Carga axial ultimo en el muro estructural :",{"$nulls":7},"Momento ultimo en el muro estructural :"]
[]
[null,"Pu =",{"v":1.4,"d":"1.40"},"* Pcm   +",{"v":1.5,"d":"1.50"},"* Pcv   =",{"$f":"+IFERROR((C50*C30+E50*C31)*1000,)","v":{"v":0,"d":"0.00"}},null,"kg","Mu =",{"v":1.4,"d":"1.40"},"* Mb =",{"$f":"+IFERROR(K50*L37*100000,)","v":{"v":0,"d":"0.00"}},null,null,"kg-cm"]
[]
[null,"Esfuerzo de compresion en la fibra extrema:"]
[]
[null,null,"f'c =","Pu / Ag","+  Mu * (Lm/2) / Iy-y",null,"=",{"$f":"+IFERROR((G50/E46)+((M50*H17*100*0.5)/M46),)","v":{"v":0,"d":"0.000"}},null,"kg/cm2",{"$f":"+IFERROR(IF(H54<=M54,\"<\",\">\"),)","v":"<"},"0.2f'c =",{"$f":"+IFERROR(O42,)","v":{"v":0,"d":"0.00"}},"kg/cm2"]
[]
[{"$nulls":6},{"$f":"+IFERROR(IF(H54>M54,\"Necesita de Elementos de Confinamiento\",\"No Necesita de Elementos de Confinamiento\"),)","v":"No Necesita de Elementos de Confinamiento"}]
[]
["03 DETERMINACION DE LOS REFUERZOS DE ACERO EN EL MURO ESTRUCTURAL"]
[]
[null,"a. Verificacion del Requerimeinto de Refuerzo de Acero en Dos Capas"]
[]
[null,null,"Si :","tm =",{"$f":"+IFERROR(H18,)","v":{"v":0,"d":"0.00"}},"m",">",0.25,"m",{"$nulls":4},{"$f":"+IFERROR(IF(E62>=H62,\"Refuerzo en dos capas\",\"Refuerzo en una capa\"),)","v":"Refuerzo en una capa"}]
[]
[null,null,"Si :","Vu =",{"$f":"+IFERROR(M37,)","v":{"v":0,"d":"0.00"}},"tn",">","0.53 * √f'c * Acv =",null,{"$f":"IFERROR(0.53*SQRT(H14)*H17*10*H18,)","v":{"v":0,"d":"0.00"}},"tn",null,null,{"$f":"+IFERROR(IF(E64>=J64,\"Refuerzo en dos capas\",\"Refuerzo en una capa\"),)","v":"Refuerzo en dos capas"}]
[]
[null,"b. Determinacion de los requerimientos de refuerzo minimo longitudinal en el muro estructural"]
[]
[null,"Cuantia de acero vertical en el muro :",{"$nulls":8},"Espaciamiento maximo del refuerzo:"]
[]
[null,null,"ρv =","Asv",">",0.0025,{"$nulls":4},"S =",0.45,"m","Smax =",{"$f":"+IFERROR(MIN(L70,L71),)","v":{"v":0,"d":"0.00"}},"m"]
[{"$nulls":3},"Acv",{"$nulls":6},"3tm =",{"$f":"IFERROR(3*H18,)","v":{"v":0,"d":"0.00"}},"m"]
[]
[null,"Area resistente al corte por unidad de metro:",{"$nulls":8},"Area de acero vertical por unidad de metro :"]
[]
[null,null,"Acv / m","=",{"$f":"IFERROR(100*H18*100,)","v":{"v":0,"d":"0.00"}},null,"cm2/m",{"$nulls":3},"ρv * Acv","=",{"$f":"+F70*E75","v":{"v":0,"d":"0.00"}},"cm2/m"]
[]
[null,"La distribucion de acero vertical en el muro sera de :",{"$nulls":8},"Numero de capas del refuerzo vertical :",{"$nulls":3},"N° =",{"$f":"+IFERROR(MAX(IF(N62=\"Refuerzo en dos capas\",2,1),IF(N64=\"Refuerzo en dos capas\",2,1)),)","v":2}]
[]
[null,null,"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\"",null,"Distribucion de acero en :",null,null,"Av =",{"$f":"+IFERROR(HLOOKUP(L81,D79:I81,2,0),)","v":{"v":0,"d":"0.00"}},"cm2"]
[null,null,"Area",{"$f":"+IFERROR(0.71*P77,)","v":1.42},{"$f":"+IFERROR(1.27*P77,)","v":2.54},{"$f":"+IFERROR(1.98*P77,)","v":3.96},{"$f":"+IFERROR(2.85*P77,)","v":{"v":5.7,"d":"5.70"}},{"$f":"+IFERROR(3.88*P77,)","v":7.76},{"$f":"+IFERROR(5.07*P77,)","v":10.14}]
[null,null,"s (cm)",{"$f":"IFERROR(+D80*100/$M$75,)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(+E80*100/$M$75,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(L81,D79:I81,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m"]
[]
[null,"c. Determinacion de los requerimientos de refuerzo por corte en el muro estructural"]
[]
[null,"Calculamos el factor αc :",{"$nulls":8},"Resistencia al cortante del area Acv del muro :"]
[]
[null,null,"hm / Lm","=",{"$f":"+IFERROR(M14/H17,)","v":{"v":0,"d":"0.00"}},"---->","αc =",{"$f":"+IFERROR(IF(E87<=1.5,0.8,IF(E87>=2,0.53,0.65)),)","v":0.8},null,null,"Vc =","αc * √f'c * Acv =",null,{"$f":"IFERROR(H87*SQRT(H14)*H17*10*H18,)","v":{"v":0,"d":"0.000"}},null,"tn"]
[]
[null,"Resistencia al cortante nominal del area Acv del muro :",{"$nulls":8},"Cortante desarrollado de la resistencia a flexion nominal"]
[]
[null,null,"Vn =","(αc * √f'c + ρv * fy ) * Acv =",null,null,{"$f":"IFERROR(H87*SQRT(H14)*H17*10*H18+H17*H18*H15/1000,)","v":{"v":0,"d":"0.000"}},null,"tn",null,"Vfn =","( Mu / ϕ ) * 2 / hm   =",null,{"$f":"+IFERROR((L37/0.9)*2/M14,)","v":{"v":0,"d":"0.000"}},null,"tn"]
[]
[null,"El valor de para el cortante es de ϕ=0.85, sin embargo deberá tomarse ϕ=0.60, si la resistencia al cortante nominal Vn es menor que el cortante"]
[null,"correspondiente al desarrollo de la resistencia a flexion nominal Vfn. En forma conservadora se tomara ϕ=0.60"]
[]
[null,"Resistenca al cortante del acero de refuerzo:"]
[]
[{"$nulls":3},"Vs =","Vu","-","Vc","=",{"$f":"+IFERROR(M37,)","v":{"v":0,"d":"0.0"}},"-",{"$f":"+IFERROR(N87,)","v":{"v":0,"d":"0.0"}},"=",{"$f":"+IFERROR((I98/I99)-K98,)","v":{"v":0,"d":"0.000"}},null,"tn"]
[{"$nulls":4},"ϕ",{"$nulls":3},{"v":0.6,"d":"0.60"}]
[]
[null,"La separacion del refuerzo horizontal estara dado por :",{"$nulls":5},"s = (Av * fy * d) / Vs",null,null,"Numero de capas del refuerzo vertical :",{"$nulls":3},"N° =",{"$f":"+IFERROR(MAX(IF(N62=\"Refuerzo en dos capas\",2,1),IF(N64=\"Refuerzo en dos capas\",2,1)),)","v":2}]
[]
[null,null,"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\"",null,"Distribucion de acero en :",null,null,"Av =",{"$f":"+IFERROR(HLOOKUP(L105,D103:I105,2,0),)","v":{"v":0,"d":"0.00"}},"cm2"]
[null,null,"Av (cm2)",{"$f":"+IFERROR(0.71*P101,)","v":1.42},{"$f":"+IFERROR(1.27*P101,)","v":2.54},{"$f":"+IFERROR(1.98*P101,)","v":3.96},{"$f":"+IFERROR(2.85*P101,)","v":{"v":5.7,"d":"5.70"}},{"$f":"+IFERROR(3.88*P101,)","v":7.76},{"$f":"+IFERROR(5.07*P101,)","v":10.14}]
[null,null,"s (cm)",{"$f":"+IFERROR(D104*$H$15*($H$17*0.8)*100/($M$98*1000),)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(L105,D103:I105,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000"}},null,"m"]
[]
["04 DETERMINACION DE LOS REFUERZOS DE ACERO EN LAS COLUMNAS DE CONFINAMIENTO"]
[]
[null,"a. Verificacion de los elementos de confinamiento actuando como columnas cortas"]
[]
[null,"En esta condicion las columnas toman las cargas verticales debidas a las cargas de gravedad y de sismo."]
[]
[null,"Fuerza axial maxima sobre el elemento de confinamiento \"Pu max\" :"]
[]
[null,null,"Pu(muro)=",{"v":1.4,"d":"1.40"},"*(Pcm+Pcv+Pcs) =",null,{"$f":"+IFERROR(D115*(C30+C31),)","v":{"v":0,"d":"0.000"}},null,"tn",null,"Mu =",{"v":1.4,"d":"1.40"},"* Mb =",{"$f":"+IFERROR(L115*L37,)","v":{"v":0,"d":"0.000"}},null,"tn-m"]
[]
[null,null,"Pumax =","Pu(muro)","+    Mu","=",{"$f":"+IFERROR((G115/2)+(N115/(N117)),)","v":{"v":0,"d":"0.000"}},null,"tn",null,"L'm =","Lm - Lcol(max) =",null,{"$f":"+IFERROR(H17-MAX(C17,M17),)","v":{"v":0,"d":"0.000"}},null,"m"]
[{"$nulls":3},2,"   L'm"]
[]
[null,"Determinacion del acero longitudinal en la columna Iquierda",{"$nulls":7},"Determinacion del acero longitudinal en la columna Derecha"]
[]
[null,null,"Acolizq =",{"$f":"+IFERROR(C17*C18*10000,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Acolder =",{"$f":"+IFERROR(M17*M18*10000,)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,null,"Pu col =",{"$f":"+IFERROR(G117*D122/MAX(D122,L122),)","v":{"v":0,"d":"0.000"}},null,"tn",{"$nulls":4},"Pu col =",{"$f":"+IFERROR(G117*L122/MAX(D122,L122),)","v":0},null,"tn"]
[]
[null,null,"As min =",0.01," * Acoli =",{"$f":"+IFERROR(D126*D122,)","v":{"v":0,"d":"0.00"}},null,"cm2",null,null,"As min =",0.01," * Acoli =",{"$f":"+IFERROR(L126*L122,)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,null,"As max =",0.06," * Acoli =",{"$f":"+IFERROR(D128*D122,)","v":{"v":0,"d":"0.00"}},null,"cm2",null,null,"As max =",0.06," * Acoli =",{"$f":"+IFERROR(L128*L122,)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[{"$nulls":17},"ϕ3/8\"",{"$f":"+IFERROR(0.71,)","v":0.71}]
[null,"As coli =",{"$nulls":7},"As cold=",{"$nulls":7},"ϕ1/2\"",{"$f":"+IFERROR(1.27,)","v":1.27},{"$f":"+IFERROR(IF(E130=0,\"\",\" + \"),)","v":""},{"$f":"+IFERROR(IF(M130=0,\"\",\" + \"),)","v":""}]
[null,null,{"$f":"+IFERROR(C130,)","v":0},{"$f":"+IFERROR(VLOOKUP(D130,$R$129:$S$138,2,0),)","v":0},{"$f":"+IFERROR(E130,)","v":0},{"$f":"+IFERROR(VLOOKUP(F130,$R$129:$S$138,2,0),)","v":0},{"$f":"+IFERROR(G130,)","v":0},{"$f":"+IFERROR(VLOOKUP(H130,$R$129:$S$138,2,0),)","v":0},null,null,{"$f":"+IFERROR(K130,)","v":0},{"$f":"+IFERROR(VLOOKUP(L130,$R$129:$S$138,2,0),)","v":0},{"$f":"+IFERROR(M130,)","v":0},{"$f":"+IFERROR(VLOOKUP(N130,$R$129:$S$138,2,0),)","v":0},{"$f":"+IFERROR(O130,)","v":0},{"$f":"+IFERROR(VLOOKUP(P130,$R$129:$S$138,2,0),)","v":0},null,"ϕ5/8\"",{"$f":"+IFERROR(1.98,)","v":1.98}]
[null,null,"As coli =",{"$f":"+IFERROR(C131*D131+E131*F131+G131*H131,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"As cold =",{"$f":"+IFERROR(K131*L131+M131*N131+O131*P131,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":3},"ϕ3/4\"",{"$f":"+IFERROR(2.85,)","v":2.85},{"$f":"+IFERROR(IF(G130=0,\"\",\" + \"),)","v":""},{"$f":"+IFERROR(IF(O130=0,\"\",\" + \"),)","v":""}]
[{"$nulls":17},"ϕ7/8\"",{"$f":"+IFERROR(3.88,)","v":3.88}]
[{"$nulls":3},{"$f":"+IFERROR(IF(AND(D132>=F126,D132<=F128),\"Cumple los limites de cuantia\",\"No cumple los limites de cuantia\"),)","v":"Cumple los limites de cuantia"},{"$nulls":7},{"$f":"+IFERROR(IF(AND(L132>=N126,L132<=N128),\"Cumple los limites de cuantia\",\"No cumple los limites de cuantia\"),)","v":"Cumple los limites de cuantia"},{"$nulls":5},"ϕ1\"",{"$f":"+IFERROR(5.07,)","v":5.07}]
[{"$nulls":17},"ϕ1 1/8\"",6.41]
[null,"Determinamos la resistencia axial maxima de la columna Izquierda",{"$nulls":7},"Determinamos la resistencia axial maxima de la columna Derecha",{"$nulls":7},"ϕ1 1/4\"",7.92]
[{"$nulls":17},"ϕ1 3/8\"",9.58]
[null,null,"Pni max =",{"v":0.8,"d":"0.80"},"* ( f'c * ( Ag - Ast )*",null,0.85,"+  Ast*fy )",null,null,"Pnd max =",{"v":0.8,"d":"0.80"},"* ( f'c * ( Ag - Ast )*",null,0.85,"+  Ast*fy )",null,"ϕ1 1/2\"",11.4]
[]
[null,null,"Pni max =",{"$f":"+IFERROR(D138*(G138*$H$14*(D122-D132)+D132*$H$15)/1000,)","v":{"v":0,"d":"0.00"}},null,"tn",{"$nulls":4},"Pnd max =",{"$f":"+IFERROR(L138*(O138*$H$14*(L122-L132)+L132*$H$15)/1000,)","v":{"v":0,"d":"0.00"}},null,"tn"]
[]
[null,"Determinamos la resistencia ultima axial maxima de la columna Izquierda",{"$nulls":7},"Determinamos la resistencia ultima axial maxima de la columna Derecha"]
[]
[null,null,"Pui max =",{"v":0.7,"d":"0.70"},"*Pnimax =",{"$f":"+IFERROR(D144*D140,)","v":{"v":0,"d":"0.000"}},null,"tn",null,null,"Pud max =",{"v":0.7,"d":"0.70"},"*Pndmax=",{"$f":"+IFERROR(L144*L140,)","v":{"v":0,"d":"0.000"}},null,"tn"]
[]
[null,null,"Pu coli =",{"$f":"+IFERROR(D124,)","v":{"v":0,"d":"0.000"}},null,"tn",{"$nulls":4},"Pu cold =",{"$f":"+IFERROR(L124,)","v":{"v":0,"d":"0.000"}},null,"tn"]
[]
[{"$nulls":3},{"$f":"+IFERROR(IF(F144<D146,\"La columna no es conforme\",\"La columna es conforme\"),)","v":"La columna es conforme"},{"$nulls":7},{"$f":"+IFERROR(IF(N144<L146,\"La columna no es conforme\",\"La columna es conforme\"),)","v":"La columna es conforme"}]
[]
[null,"b. Verificacion por flexocompresión de los elementos de confinamiento"]
[]
[null,"Determinamos la carga axial ultima actuante en el muro",{"$nulls":7},"Determinamos el momento ultimo actuante en el muro"]
[]
[null,null,"Pu =",{"$f":"+IFERROR(MAX(D146,L146),)","v":{"v":0,"d":"0.00"}},null,"tn",{"$nulls":4},"Mu =",{"$f":"+IFERROR(MAX(N115),)","v":{"v":0,"d":"0.00"}},null,"tn"]
[]
[null,"Diagrama de interaccion del muro en la direccion x-x",{"$nulls":7},"Diagrama de interaccion del muro en la direccion y-y"]
[]
[{"$nulls":17},0,0]
[{"$nulls":17},{"$f":"+L154","v":{"v":0,"d":"0.00"}},{"$f":"+D154","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":17},0,0]
[{"$nulls":17},{"$f":"+O37","v":0},{"$f":"+N37","v":0}]
{"$rows_empty":12}
[null,"b. Determinamos los requerimientos de refuerzo transversal por confinamiento en la direccion de la longitud menor de la columna"]
[]
[null,"Determinacion de la separacion en la columna Iquierda",{"$nulls":7},"Determinacion de la separacion en la columna Derecha"]
[]
[null,null,"s ="," Lmenor / 4  =",null,{"$f":"+IFERROR(MIN(C17,C18)/4,)","v":{"v":0,"d":"0.000"}},"m",{"$nulls":3},"s ="," Lmenor / 4  =",null,{"$f":"+IFERROR(MIN(M17,M18)/4,)","v":{"v":0,"d":"0.000"}},"m"]
[]
[null,"Determinacion de altura del nucleo de concreto en columna Iquierda",{"$nulls":7},"Determinacion de la altura del nucleo de concreto en la columna Derecha"]
[]
[null,null,"rec =",null,"cm",{"$nulls":5},"rec =",null,"cm"]
[]
[null,null,"hc =",{"$f":"+IFERROR(MAX(C17,C18)-(2*D183/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m","bc =",{"$f":"+IFERROR(MIN(C17,C18)-(1.5*D183/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m",null,null,"hc =",{"$f":"+IFERROR(MAX(M17,M18)-(2*L183/100)-(1.27/100),)","v":-0.0127},"m","bc =",{"$f":"+IFERROR(MIN(M17,M18)-(1.5*L183/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m"]
[]
[null,"Calculamos el area de acero horizontal en la columna izquierda - 01",{"$nulls":7},"Calculamos el area de acero horizontal en la columna izquierda - 01"]
[]
[null,null,"Ash =","0.3 * s * hc * ( (Ag / Ach) -1 ) * f'c / fy",{"$nulls":6},"Ash =","0.3 * s * hc * ( (Ag / Ach) -1 ) * f'c / fy"]
[]
[null,null,"s =",null,"m",{"$nulls":5},"s =",null,"m"]
[]
[null,null,"Ash =",{"$f":"IFERROR(10000*0.3*D191*D185*(((C17*C18)/(D185*G185))-1)*(H14/H15),)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash =",{"$f":"IFERROR(10000*0.3*L191*L185*(((M17*M18)/(L185*O185))-1)*(H14/H15),)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Calculamos el area de acero horizontal en la columna izquierda - 02",{"$nulls":7},"Calculamos el area de acero horizontal en la columna izquierda - 02",{"$nulls":7},"ϕ6mm",0.28]
[{"$nulls":17},"ϕ8mm",{"v":0.5,"d":"0.50"}]
[null,null,"Ash' =","0.09 * s * hc * f'c/fy",{"$nulls":6},"Ash' =","0.09 * s * hc * f'c/fy",{"$nulls":5},"ϕ3/8\"",{"$f":"+IFERROR(0.71,)","v":0.71}]
[{"$nulls":17},"ϕ12mm",1.13]
[null,null,"Ash' =",{"$f":"IFERROR(10000*0.09*D191*D185*H14/H15,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash' =",{"$f":"IFERROR(10000*0.09*L191*L185*H14/H15,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":3},"ϕ1/2\"",{"$f":"+IFERROR(1.27,)","v":1.27}]
[]
[null,"Elegimos la siguiente distribucion de aceros, en la columna izquierda",{"$nulls":7},"Elegimos la siguiente distribucion de aceros, en la columna derecha"]
[]
[]
[{"$nulls":3},{"$f":"+IFERROR(C203*VLOOKUP(D203,R195:S199,2,0),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(E203*VLOOKUP(F203,R195:S199,2,0),)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"+IFERROR(K203*VLOOKUP(L203,R195:S199,2,0),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(M203*VLOOKUP(N203,R195:S199,2,0),)","v":{"v":0,"d":"0.00"}}]
[null,null,"Ash =",{"$f":"+IFERROR(D204+F204,)","v":0},null,"cm2",{"$nulls":4},"Ash =",{"$f":"+IFERROR(L204+N204,)","v":0},null,"cm2"]
[null,null,"Ash min =",{"$f":"+IFERROR(MAX(D193,D199),)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash =",{"$f":"+IFERROR(MAX(L193,L199),)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[{"$nulls":3},{"$f":"+IFERROR(IF(D205>=D206,\"Cumple\",\"No Cumple\"),)","v":"Cumple"},{"$nulls":7},{"$f":"+IFERROR(IF(L205>=L206,\"Cumple\",\"No Cumple\"),)","v":"Cumple"}]
[]
[null,"c. Determinamos los requerimientos de refuerzo transversal por confinamiento en la direccion de la longitud mayor de la columna"]
[]
[null,"Determinacion de la separacion en la columna Iquierda",{"$nulls":7},"Determinacion de la separacion en la columna Derecha"]
[]
[null,null,"s ="," Lmenor / 4  =",null,{"$f":"+IFERROR(MAX(C17,C18)/4,)","v":{"v":0,"d":"0.000"}},"m",{"$nulls":3},"s ="," Lmenor / 4  =",null,{"$f":"+IFERROR(MAX(M17,M18)/4,)","v":{"v":0,"d":"0.000"}},"m"]
[]
[null,"Determinacion de altura del nucleo de concreto en columna Iquierda",{"$nulls":7},"Determinacion de la altura del nucleo de concreto en la columna Derecha"]
[]
[null,null,"rec =",null,"cm",{"$nulls":5},"rec =",null,"cm"]
[]
[null,null,"hc =",{"$f":"+IFERROR(MIN(C17,C18)-(2*D218/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m","bc =",{"$f":"+IFERROR(MAX(C17,C18)-(1.5*D218/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m",null,null,"hc =",{"$f":"+IFERROR(MIN(M17,M18)-(2*L218/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m","bc =",{"$f":"+IFERROR(MAX(M17,M18)-(1.5*L218/100)-(1.27/100),)","v":{"v":-0.0127,"d":"-0.013"}},"m"]
[]
[null,"Calculamos el area de acero horizontal en la columna izquierda - 01",{"$nulls":7},"Calculamos el area de acero horizontal en la columna izquierda - 01"]
[]
[null,null,"Ash =","0.3 * s * hc * ( (Ag / Ach) -1 ) * f'c / fy",{"$nulls":6},"Ash =","0.3 * s * hc * ( (Ag / Ach) -1 ) * f'c / fy"]
[]
[null,null,"s =",null,"m",{"$nulls":5},"s =",null,"m"]
[]
[null,null,"Ash =",{"$f":"IFERROR(10000*0.3*D226*D220*(((C17*C18)/(D220*G220))-1)*(H14/H15),)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash =",{"$f":"IFERROR(10000*0.3*L226*L220*(((M17*M18)/(L220*O220))-1)*(H14/H15),)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[null,"Calculamos el area de acero horizontal en la columna izquierda - 02",{"$nulls":7},"Calculamos el area de acero horizontal en la columna izquierda - 02",{"$nulls":7},"ϕ6mm",0.28]
[{"$nulls":17},"ϕ8mm",{"v":0.5,"d":"0.50"}]
[null,null,"Ash' =","0.09 * s * hc * f'c/fy",{"$nulls":6},"Ash' =","0.09 * s * hc * f'c/fy",{"$nulls":5},"ϕ3/8\"",{"$f":"+IFERROR(0.71,)","v":0.71}]
[{"$nulls":17},"ϕ12mm",1.13]
[null,null,"Ash' =",{"$f":"IFERROR(10000*0.09*D226*D220*H14/H15,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash' =",{"$f":"IFERROR(10000*0.09*L226*L220*H14/H15,)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":3},"ϕ1/2\"",{"$f":"+IFERROR(1.27,)","v":1.27}]
[]
[null,"Elegimos la siguiente distribucion de aceros, en la columna izquierda",{"$nulls":7},"Elegimos la siguiente distribucion de aceros, en la columna derecha"]
[]
[]
[{"$nulls":3},{"$f":"+IFERROR(C238*VLOOKUP(D238,R230:S234,2,0),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(E238*VLOOKUP(F238,R230:S234,2,0),)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"+IFERROR(K238*VLOOKUP(L238,R230:S234,2,0),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(M238*VLOOKUP(N238,R230:S234,2,0),)","v":{"v":0,"d":"0.00"}}]
[null,null,"Ash =",{"$f":"+IFERROR(D239+F239,)","v":0},null,"cm2",{"$nulls":4},"Ash =",{"$f":"+IFERROR(L239+N239,)","v":0},null,"cm2"]
[null,null,"Ash min =",{"$f":"+IFERROR(MAX(D228,D234),)","v":{"v":0,"d":"0.00"}},null,"cm2",{"$nulls":4},"Ash =",{"$f":"+IFERROR(MAX(L228,L234),)","v":{"v":0,"d":"0.00"}},null,"cm2"]
[]
[{"$nulls":3},{"$f":"+IFERROR(IF(D240>=D241,\"Cumple\",\"No Cumple\"),)","v":"Cumple"},{"$nulls":7},{"$f":"+IFERROR(IF(L240>=L241,\"Cumple\",\"No Cumple\"),)","v":"Cumple"}]
[]
["05 DIAGRAMA FINAL DEL MURO ESTRUCTURAL"]
[]
[{"$nulls":3},{"$f":"+IFERROR(CONCATENATE(C17,\" m\"),)","v":" m"},{"$nulls":3},{"$f":"+IFERROR(CONCATENATE(H17-M17-C17,\" m\"),)","v":"0 m"},{"$nulls":4},{"$f":"+IFERROR(CONCATENATE(M17,\" m\"),)","v":" m"}]
[]
[]
[{"$nulls":3},"•     •","•     •",{"$nulls":7},"•     •","•     •"]
[null,{"$f":"+IFERROR(CONCATENATE(C18,\" m\"),)","v":" m"},null,"•","•","•     •","•     •","•     •","•     •","•     •","•     •","•     •","•","•",{"$f":"+IFERROR(CONCATENATE(M18,\" m\"),)","v":" m"}]
[{"$nulls":3},"•","•","•     •","•     •","•     •","•     •","•     •","•     •","•     •","•","•"]
[{"$nulls":3},"•     •","•     •",{"$nulls":7},"•     •","•     •"]
[]
[{"$nulls":8},{"$f":"+IFERROR(CONCATENATE(H18,\" m\"),)","v":" m"}]
[]
[null,null,{"$f":"+IFERROR(CONCATENATE(C130,D130,T130,E130,F130,T132,G130,H130),)","v":""},{"$nulls":4},{"$f":"IFERROR(+K105,)","v":"Ø"},{"$f":"IFERROR(+L105,)","v":0},{"$f":"IFERROR(+M105,)","v":"@"},{"$f":"IFERROR(+CONCATENATE(N105,\" m\"),)","v":"0 m"},{"$f":"+IFERROR(CONCATENATE(K130,L130,U130,M130,N130,U132,O130,P130),)","v":""}]
[]
[null,null,"Estr. :",{"$f":"+IFERROR(CONCATENATE(MAX(C238,C203),D203,IF(MAX(E238,E203)=0,\"\",\" + \"),IF(MAX(E238,E203)=0,\"\",MAX(E203,E238)),IF(MAX(E238,E203)=0,\"\",F203)),)","v":"0"},null,null,{"$f":"IFERROR(+K81,)","v":"Ø"},{"$f":"IFERROR(+L81,)","v":0},{"$f":"IFERROR(+M81,)","v":"@"},{"$f":"IFERROR(+CONCATENATE(N81,\" m\"),)","v":"0 m"},null,"Estr. :",{"$f":"+IFERROR(CONCATENATE(MAX(K238,K203),L203,IF(MAX(M238,M203)=0,\"\",\" + \"),IF(MAX(M238,M203)=0,\"\",MAX(M203,M238)),IF(MAX(M238,M203)=0,\"\",N203)),)","v":"0"}]

{"sheet":"Datos","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"merged":[[2,0,2,7],[6,0,6,12],[9,1,9,11],[15,2,15,4],[15,8,15,10]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[null,null,"Cel:","#942656792"]
[null,null,"Correo:","grupo_crixuz@hotmail.com"]
[null,null,"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"]
[]
[]
[null,"ANALISIS Y DISEÑO DE MUROS ESTRUCTURALES DE CONCRETO ARMADO"]
[]
["01. IMPORTACION DE PUNTOS PARA EL DIAGRAMA DE INTERACCION"]
[]
[null,"a. DATOS DE DISEÑO",{"$nulls":7},"Insertar Numero de filas =",null,{"$f":"11+MATCH(\"xxx\",A12:A21,0)","v":21}]
[]
[null,null,"Dirección X-X",{"$nulls":5},"Dirección Y-Y"]
[null,null,"Point","Load","Moment",{"$nulls":3},"Point","Load","Moment"]
[null,null,"#","(tn)","(ton-m)",{"$nulls":3},"#","(tn)","(ton-m)"]
[null,"--",{"$nulls":3},"--",null,"--",{"$nulls":3},"--"]
[null,"--",{"$nulls":3},"--",null,"--",{"$nulls":3},"--"]
["xxx","--",{"$nulls":3},"--",null,"--",{"$nulls":3},"--"]