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

{"sheet":"Diseño","index":0,"n_rows":254,"n_cols":16,"rows_kept":254,"merged":[[2,0,2,7],[6,0,6,12],[9,1,9,11],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[32,3,32,4],[33,3,33,4],[41,10,41,11],[46,7,46,8],[50,4,50,5],[50,10,50,11],[56,8,56,9],[62,2,62,3],[62,8,62,9],[62,10,62,11],[66,4,66,5],[70,5,70,6],[70,7,70,8],[74,5,74,6],[74,7,74,8],[80,2,80,3],[80,7,80,8],[80,10,80,11],[89,4,89,5],[89,10,89,11],[96,4,96,5],[96,10,96,11],[101,2,101,3],[101,8,101,9],[103,6,103,8],[105,3,105,4],[105,9,105,10],[107,3,107,4],[107,9,107,10],[111,6,111,7],[111,10,111,11],[118,3,118,4],[118,10,118,11],[123,2,123,3],[123,4,123,5],[123,10,123,11],[128,4,128,7],[128,8,128,9],[132,4,132,7],[133,5,133,7],[133,8,133,9],[136,4,136,5],[136,8,136,9],[138,5,138,7],[142,6,142,8],[144,3,144,4],[144,9,144,10],[146,3,146,4],[146,9,146,10],[150,2,150,3],[150,6,150,7],[150,10,150,11],[158,7,158,8],[162,10,162,11],[168,7,168,8],[174,4,174,7],[175,5,175,7],[175,8,175,9],[180,4,180,5],[180,9,180,10],[183,4,183,7],[183,8,183,9],[187,5,187,6],[187,7,187,8],[188,5,188,6],[192,3,192,4],[192,7,192,8],[192,10,192,11],[199,2,199,3],[199,4,199,5],[199,10,199,11],[200,2,200,3],[204,4,204,5],[204,8,204,9],[204,10,204,11],[210,2,210,3],[210,4,210,5],[210,8,210,10],[210,11,210,12],[214,4,214,5],[214,8,214,9],[219,1,219,2],[219,5,219,6],[220,10,221,11],[230,1,230,2],[230,10,231,11],[239,5,239,6],[240,10,240,11],[242,10,242,11],[247,10,247,11],[250,5,250,6],[253,3,253,4]]}
[]
[]
["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 SOTANO"]
[]
["01 DATOS INICIALES"]
[]
[null,null,"Lm =",{"$nulls":10},0,0]
[null,null,"Bm =",{"$nulls":10},{"$f":"+D22","v":{"v":0,"d":"0.00  m"}},{"$f":"+O14","v":0}]
[null,null,"Hm =",{"$nulls":10},{"$f":"+N15","v":{"v":0,"d":"0.00  m"}},{"$f":"+D21","v":{"v":0,"d":"0.00  m"}}]
[null,null,"Lpl =",{"$nulls":10},{"$f":"+N16-(D22-D18)","v":{"v":0,"d":"0.0"}},{"$f":"+O16","v":{"v":0,"d":"0.00  m"}}]
[null,null,"em =",{"$nulls":10},{"$f":"+N17","v":{"v":0,"d":"0.0"}},{"$f":"+O17+(D16-D19-D21)","v":{"v":0,"d":"0.0"}}]
[null,null,"Losa =",{"$nulls":10},{"$f":"+N18+1.5","v":1.5},{"$f":"+O18","v":{"v":0,"d":"0.0"}}]
[null,null,"Piso =",{"$nulls":10},{"$f":"+N19","v":1.5},{"$f":"+O19+D19","v":{"v":0,"d":"0.0"}}]
[null,null,"Hzm =",{"$nulls":10},{"$f":"+N20-1.5-D18","v":{"v":0,"d":"0.0"}},{"$f":"+O20","v":{"v":0,"d":"0.0"}}]
[null,null,"Bzm =",{"$nulls":10},{"$f":"+N21","v":{"v":0,"d":"0.00"}},{"$f":"+O21-D16","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"γt =",{"$nulls":10},{"$f":"+N17","v":{"v":0,"d":"0.0"}},{"$f":"+D16-D19-D17-D20","v":{"v":0,"d":"0.00"}}]
[null,null,"ϕt =",{"$nulls":10},{"$f":"+N24+1.5","v":1.5},{"$f":"+O24","v":{"v":0,"d":"0.00"}}]
[null,null,"qt =",{"$nulls":10},{"$f":"+N25","v":1.5},{"$f":"+O25+D20","v":{"v":0,"d":"0.00"}}]
[null,null,"s/c =",{"$nulls":10},{"$f":"+N26-1.5","v":{"v":0,"d":"0.0"}},{"$f":"+O26","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"γc =",{"$nulls":10},0,{"$f":"+D16","v":{"v":0,"d":"0.00  m"}}]
[null,null,"f'c =",{"$nulls":10},{"$f":"+N29-1.5","v":-1.5},{"$f":"+O29","v":{"v":0,"d":"0.00  m"}}]
[null,null,"fy ="]
[]
[null,null,"Pcm ="]
[null,null,"Pcv ="]
[]
["02 DETERMINACION DE LAS CARGAS DE DISEÑO"]
[]
[null,"a. Empuje del terreno y sobrecarga (s/c)"]
[]
[null,"Coeficiente de empuje activo del suelo",{"$nulls":5},"Empuje de la sobrecarga"]
[]
[null,"Ca =","1-Sen(ϕt)","=",{"$f":"+IFERROR((1-SIN(D25*2*PI()/360))/(1+SIN(D25*2*PI()/360)),)","v":{"v":1,"d":"1.000"}},null,null,"Es/c =","s/c * Ca","=",{"$f":"+IFERROR(D27*E42,)","v":{"v":0,"d":"0.00 kg/m2"}}]
[null,null,"1+Sen(ϕt)"]
[]
[null,"Empuje del terreno por carga rectangular uniforme según Peck, para arenas:"]
[]
[{"$nulls":4},"Et =",0.65,"*γt*Ca*Lc=",{"$f":"+IFERROR(F47*D24*E42*C63,)","v":{"v":0,"d":"0.00 kg/m2"}}]
[]
[null,"Carga total de la s/c y del terreno (Servicio)",{"$nulls":5},"Carga ultima de la s/c y del terreno"]
[]
[null,"Ws =","Es/c + Et","=",{"$f":"+IFERROR(H47+K42,)","v":{"v":0,"d":"0.00 kg/m2"}},null,null,"Wu =",{"v":1.7,"d":"1.70"},"*  W  =",{"$f":"+IFERROR(I51*E51,)","v":{"v":0,"d":"0.00 kg/m2"}}]
[]
[null,"b. Cargas axiales ultimas debido a las carga muertas y vivas"]
[]
[null,"Carga axial ultima mayorada"]
[]
[{"$nulls":3},"Pui =",{"v":1.4,"d":"1.40"},"*  Pcm  +",{"v":1.7,"d":"1.70"},"*  Pcv  =",{"$f":"+IFERROR(E57*D33+G57*D34,)","v":{"v":0,"d":"0.00 kg/m"}}]
[]
[null,"c. Peso propio del muro a mitad de la altura"]
[]
[null,"Luz de la pantalla del muro sotano entre ejes de apoyo",{"$nulls":5},"Peso del muro sotano a mitad de altura"]
[]
[null,"Lc =",{"$f":"+IFERROR(D17+0.5*D19+0.5*D20,)","v":{"v":0,"d":"0.00 m"}},{"$nulls":4},"P' =","em * (Hm/2) * γc =",null,{"$f":"+IFERROR(D18*0.5*D16*D29,)","v":{"v":0,"d":"0.00 kg/m"}}]
[]
[null,"Carga axial ultima del muro sotano a mitad de altura"]
[]
[null,"Puii =",{"v":1.4,"d":"1.40"},"*  P'  =",{"$f":"+IFERROR(C67*K63,)","v":{"v":0,"d":"0.00 kg/m"}}]
[]
[null,"d. Cargas axiales sin mayorar (cargas de servicio)"]
[]
[{"$nulls":4},"Ps =","Pcm  +  Pcv  +  P'  =",null,{"$f":"+IFERROR(D33+D34+K63,)","v":{"v":0,"d":"0.00 kg/m"}}]
[]
[null,"e. Cargas axiales mayoradas (cargas ultimas)"]
[]
[{"$nulls":4},"Pu =","Pui  +  Puii  =",null,{"$f":"+IFERROR(E67+I57,)","v":{"v":0,"d":"0.00 kg/m"}}]
[]
["03 VERIFICACION DEL ESFUERZO VERTICAL EN EL MURO"]
[]
[null,"Esfuerzo de compresion en el muro por unidad de metro"]
[]
[null,"Pu   =",{"$f":"+IFERROR(H75/(D18*10000),)","v":{"v":0,"d":"0.00 kg/cm2"}},null,{"$f":"+IFERROR(IF(C81<=H81,\"<\",\">\"),)","v":"<"},0.06,"*  f'c  =",{"$f":"+IFERROR(F81*D30,)","v":{"v":0,"d":"0.00 kg/cm2"}},null,null,{"$f":"+IFERROR(IF(E81=\"<\",\"Cumple\",\"No Cumple\"),)","v":"Cumple"}]
[null,"Ag"]
[]
["04 DETERMINACION DE LOS MOMENTOS DE DISEÑO"]
[]
[null,"Se modelara el muro sotano como una viga simple con carag uniforme rectangular, con apoyos de articulacion en los extremos"]
[]
[null,"Momento sin amplificar en el muro sotano (Servicio)",{"$nulls":5},"Momento amplificado en el muro sotano (Ultimo)"]
[]
[null,"Ms =","Ws * Lc2","=",{"$f":"+IFERROR(E51*C63*C63/8,)","v":{"v":0,"d":"0.00 kg-m"}},null,null,"Mu =","Wu * Lc2","=",{"$f":"+IFERROR(K51*C63*C63/8,)","v":{"v":0,"d":"0.00 kg-m"}}]
[null,null,8,{"$nulls":5},8]
[]
["05 VERIFICAMOS LA RESISTENCIA DE DISEÑO DEL REFUERZO DE ACERO"]
[]
[null,"Determinamos el momento critico Mcr con las siguientes expresiones:"]
[]
[null,"fr =","2  *  √f'c","=",{"$f":"+IFERROR(2*SQRT(D30),)","v":{"v":0,"d":"0.00 kg/cm2"}},null,null,"Mcr =","fr * Ig ","=",{"$f":"+IFERROR((E97*D15*100*D18*D18*D18*1000000/(12*0.5*D18*100))/100,)","v":{"v":0,"d":"0.00 kg-m"}}]
[{"$nulls":8},"Yt"]
[]
[null,"Determinamos el area de acero requerido para el momento de diseño Mu"]
[]
[null,"req =",null,null,"(Recubrimiento)",null,null,"d =",{"$f":"+IFERROR(D18*100-C102,)","v":{"v":0,"d":"0.00 cm"}},null,"(Peralte Efectivo)"]
[]
[{"$nulls":4},"Mu =",{"v":0.9,"d":"0.90"},"* b * d2 * f'c * w * (1-0.59w)",{"$nulls":7},0.59,"A"]
[{"$nulls":14},{"$f":"+-1","v":-1},"B"]
[null,null,"w1 =",{"$f":"IFERROR(+(-O105+SQRT((O105^2)-4*O104*O106))/(2*O104),)","v":{"v":1.6949152542372883,"d":"1.69492"}},{"$nulls":4},"w2 =",{"$f":"IFERROR(+(-O105-SQRT((O105^2)-4*O104*O106))/(2*O104),)","v":{"v":0,"d":"0.00000"}},{"$nulls":4},{"$f":"IFERROR(+(K90*100)/(0.9*D15*100*((I102)^2)*D30),)","v":0},"C"]
[]
[null,null,"ρ =",{"$f":"+IFERROR(MIN(D106,J106)*D30/D31,)","v":{"v":0,"d":"0.000000"}},{"$nulls":4},"As =",{"$f":"+IFERROR(D108*I102*D15*100,)","v":{"v":0,"d":"0.00 cm2"}}]
[]
[null,"Determinamos el area de acero requerido por"]
[]
[null,"Ase =","Pu   +",{"v":5,"d":"5.00"},"*   fy","=",{"$f":"+IFERROR((H75+D112*D31)/D31,)","v":{"v":0,"d":"0.00 cm2"}},null,null,"Ase =",{"$f":"+IFERROR(MAX(J108,G112),)","v":{"v":0,"d":"0.00 cm2"}}]
[{"$nulls":3},"fy"]
[]
["06 CONTROL DEL MURO SOTANO POR TRACCION"]
[]
[null,"La relacion de modulos de elasticidad sera:"]
[]
[null,"n =","Es   =",{"v":2042000,"d":"2042000.0 kg/cm2"},null,"=",{"$f":"+IFERROR(D119/(D120*SQRT(D30)),)","v":{"v":0,"d":"0.000"}},{"$f":"+IFERROR(IF(G119<=I119,\"<\",\">\"),)","v":"<"},{"v":6,"d":"6.00"},null,{"$f":"+IFERROR(IF(H119=\">\",\"Cumple\",\"No Cumple\"),)","v":"No Cumple"}]
[null,null,"Ec",15000,"*  √f´c"]
[]
[null,"Calculamos los valores de \"a\" y \"c\" respecto al area de acero As"]
[]
[null,"a =","   As * fy         =",null,{"$f":"IFERROR(+J108*D31/(C125*D30*D15*100),)","v":{"v":0,"d":"0.00 cm"}},null,null,"c =","   a   ","=",{"$f":"IFERROR(E124/I125,)","v":{"v":0,"d":"0.00 cm"}}]
[null,null,0.85,"f'c * b",{"$nulls":4},0.85]
[]
[null,"Calculamos la inercia critica \"Icr\" de la seccion del muro sotano"]
[]
[{"$nulls":3},"Icr =","n*( As + Pu / fy )*( d - c )2 + ( Im * c3  / 3 ) =",{"$nulls":3},{"$f":"+IFERROR(G119*K112*(I102-K124)*(I102-K124)+D14*100*K124*K124*K124/3,)","v":{"v":0,"d":"0.00 cm4"}}]
[]
[null,"El momento de diseño para la combinacion de flexion y fuerza axial en la seccion critica sera"]
[]
[{"$nulls":4},"                         Mu                        "]
[{"$nulls":3},"Mu' =","1 -","        5  *  Pu  *  Lc2                =",null,null,{"$f":"+IFERROR(((K90*100)/(1-((5*H75*C63*C63*10000)/(F135*48*D120*SQRT(D30)*I129))))/100,)","v":{"v":0,"d":"0.00 kg-m"}}]
[{"$nulls":5},{"v":0.75,"d":"0.750"},"*  48  *  Ec  *  Icr"]
[]
[{"$nulls":3},"Mu' =",{"$f":"+I134","v":{"v":0,"d":"0.00 kg-m"}},null,{"$f":"+IFERROR(IF(E137<=I137,\"<\",\">\"),)","v":"<"},"Mcr =",{"$f":"+K97","v":{"v":0,"d":"0.00 kg-m"}}]
[]
[{"$nulls":5},{"$f":"+IFERROR(IF(G137=\">\",\"Necesita Refuerzo\",\"No Necesita Refuerzo\"),)","v":"No Necesita Refuerzo"}]
[]
[null,"Calculamos el area de acero para nuestro muro sotano"]
[]
[{"$nulls":4},"Mu =",{"v":0.9,"d":"0.90"},"* b * d2 * f'c * w * (1-0.59w)",{"$nulls":7},0.59,"A"]
[{"$nulls":14},{"$f":"+-1","v":-1},"B"]
[null,null,"w1 =",{"$f":"IFERROR(+(-O144+SQRT((O144^2)-4*O143*O145))/(2*O143),)","v":{"v":1.6949152542372883,"d":"1.69492"}},{"$nulls":4},"w2 =",{"$f":"IFERROR(+(-O144-SQRT((O144^2)-4*O143*O145))/(2*O143),)","v":{"v":0,"d":"0.00000"}},{"$nulls":4},{"$f":"IFERROR(+(MAX(E137,K90)*100)/(0.9*D15*100*((I102)^2)*D30),)","v":0},"C"]
[]
[null,null,"ρ =",{"$f":"+IFERROR(MIN(D145,J145)*D30/D31,)","v":{"v":0,"d":"0.000000"}},{"$nulls":4},"As =",{"$f":"+IFERROR(D147*I102*D15*100,)","v":{"v":0,"d":"0.00 cm2"}}]
[]
[null,"Como :"]
[]
[null,"Ase =",{"$f":"+K112","v":{"v":0,"d":"0.00 cm2"}},null,{"$f":"+IFERROR(IF(C151<=G151,\"<\",\">\"),)","v":"<"},"As =",{"$f":"+J147","v":{"v":0,"d":"0.00 cm2"}},null,null,{"$f":"+IFERROR(IF(C151>G151,B151,F151),)","v":"As ="},{"$f":"+IFERROR(IF(C151>G151,C151,G151),)","v":{"v":0,"d":"0.00 cm2"}}]
[]
[null,"a. La distribucion de acero Vertical en el muro sera de :"]
[]
[null,"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\"",null,"N° capas de refuerzo vertical :"]
[null,"Area",{"$f":"+IFERROR(0.71*L157,)","v":0.71},{"$f":"+IFERROR(1.27*L157,)","v":1.27},{"$f":"+IFERROR(1.98*L157,)","v":1.98},{"$f":"+IFERROR(2.85*L157,)","v":2.85},{"$f":"+IFERROR(3.88*L157,)","v":3.88},{"$f":"+IFERROR(5.07*L157,)","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C156*$D$15*100/$K$151,)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(+D156*$D$15*100/$K$151,)","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,"N° =",{"v":1,"d":"1.0"}]
[]
[{"$nulls":4},"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(F159,C155:H157,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000 m"}}]
[]
[null,"b. La distribucion de acero Horizontal en el muro sera de :"]
[]
[null,"Distribuimos acero en funcion de la cuantia minima :",{"$nulls":5},"Ash =",0.0025,"* b * d =",{"$f":"+IFERROR(I163*100*D15*D18*100,)","v":{"v":0,"d":"0.00 cm2"}}]
[]
[null,"Ø","3/8\"","1/2\"","5/8\"","3/4\"","7/8\"","1\"",null,"N° capas de refuerzo vertical :"]
[null,"Area",{"$f":"+IFERROR(0.71*L167,)","v":0.71},{"$f":"+IFERROR(1.27*L167,)","v":1.27},{"$f":"+IFERROR(1.98*L167,)","v":1.98},{"$f":"+IFERROR(2.85*L167,)","v":2.85},{"$f":"+IFERROR(3.88*L167,)","v":3.88},{"$f":"+IFERROR(5.07*L167,)","v":5.07}]
[null,"s (cm)",{"$f":"IFERROR(+C166*$D$15*100/$K$163,)","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,"N° =",{"v":1,"d":"1.0"}]
[]
[{"$nulls":4},"Ø",null,"@",{"$f":"IFERROR((2.5*(ROUNDDOWN(HLOOKUP(F169,C165:H167,3,0)/2.5,0)))/100,)","v":{"v":0,"d":"0.000 m"}}]
[]
["07 VERIFICAMOS LA DEFLEXION MAXIMA DEL MURO SOTANO"]
[]
[null,"El momento de servicio para la combinacion de flexion y fuerza axial en la seccion critica sera"]
[]
[{"$nulls":4},"                         Ms                        "]
[{"$nulls":3},"M =","1 -","        5  *  Ps  *  Lc2                =",null,null,{"$f":"+IFERROR(((E90*100)/(1-((5*H71*C63*C63*10000)/(F177*48*D120*SQRT(D30)*I129))))/100,)","v":{"v":0,"d":"0.00 kg-m"}}]
[{"$nulls":5},{"v":0.75,"d":"0.750"},"*  48  *  Ec  *  Icr"]
[]
[null,"Hallamos la inercia agrietada o efectiva"]
[]
[{"$nulls":3},"( Mcr / M )3 =",{"$f":"IFERROR(+(K97/I176)^3,)","v":{"v":0,"d":"0.0000"}},null,null,"Ig =","b * h3 =",{"$f":"+IFERROR((D15*100*(D18*100)^3)/12,)","v":{"v":0,"d":"0.00 cm4"}}]
[{"$nulls":8},12]
[]
[{"$nulls":3},"Ie =","( Mcr / M )3 * Ig  +  ( 1 - ( Mcr / M )3 ) * Icr =",{"$nulls":3},{"$f":"+IFERROR(E181*J181+(1-E181)*I129,)","v":{"v":0,"d":"0.00 cm4"}}]
[]
[null,"La deflexion maxima en el muro sotano sera:"]
[]
[{"$nulls":4},"Δs =","5  *  M  *  Lc2   =",null,{"$f":"+IFERROR(5*I176*100*C63*C63*10000/(48*D120*SQRT(D30)*I184),)","v":{"v":0,"d":"0.0000 cm"}}]
[{"$nulls":5},"48  *  Ec  *  Ie"]
[]
[null,"La deflexion maxima permesible esta dada por:"]
[]
[null,"Δmax =","  Lc   =",{"$f":"+IFERROR(C63*100/C194,)","v":{"v":0,"d":"0.000 cm"}},null,{"$f":"+IFERROR(IF(D193<=H193,\"<\",\">\"),)","v":"<"},"Δs =",{"$f":"+IFERROR(H188,)","v":{"v":0,"d":"0.0000 cm"}},null,null,{"$f":"+IFERROR(IF(F193=\">\",\"Cumple\",\"No Cumple\"),)","v":"No Cumple"}]
[null,null,150]
[]
["08 VERIFICAMOS LA FUERZA CORTANTE EN EL MURO SOTANO"]
[]
[null,"La fuerza cortante ultima en el muro sera:",{"$nulls":5},"La fuerza cortante nominal en el muro sera:"]
[]
[null,"Vu =","Wu * ( Lpl - em ) =",null,{"$f":"IFERROR(+K51*(D17-D18)*0.5,)","v":{"v":0,"d":"0.00 kg"}},null,null,"Vn =","  Vu  ","=",{"$f":"IFERROR(E200/I201,)","v":{"v":0,"d":"0.00 kg"}}]
[null,null,2,{"$nulls":5},0.75]
[]
[null,"La resistencia del concreto al cortante es:"]
[]
[null,"Vc =",0.53,"*√f'c*b*d=",{"$f":"IFERROR(C205*SQRT(D30)*D15*100*I102,)","v":{"v":0,"d":"0.00 kg"}},null,{"$f":"+IFERROR(IF(E205<=I205,\"<\",\">\"),)","v":"<"},"Vn =",{"$f":"IFERROR(K200,)","v":{"v":0,"d":"0.00 kg"}},null,{"$f":"+IFERROR(IF(G205=\">\",\"Cumple\",\"No Cumple\"),)","v":"No Cumple"}]
[]
["09 VERIFICAMOS LA CAPACIDAD PORTANTE DEL TERRENO"]
[]
[null,"La fuerza sobre el terreno sera:",{"$nulls":5},"Capacidad portante neta:"]
[]
[null,"P =","Pcm + Pcv + Pmuro =",null,{"$f":"IFERROR(D33+D34+D18*D29*(D16-D21),)","v":{"v":0,"d":"0.00 kg"}},null,null,"qn =","qt - Hz*γc - Hpiso*γc - Hrell*γt =",null,null,{"$f":"+D26-(D21*D29/10000)-(D20*D29/10000)-((D16-D19-D17-D21-D20)*D24/10000)","v":{"v":0,"d":"0.00 kg/cm2"}}]
[]
[null,"El ancho de la cimentacion del muro sera:"]
[]
[null,"Bzm ="," P ","=",{"$f":"+IFERROR((E211/L211)/(D15*100),)","v":{"v":0,"d":"0.00 cm"}},null,null,"Bzm =",{"$f":"IFERROR(0.05*(ROUNDUP(E215/100,1)/0.05),)","v":{"v":0,"d":"0.00 m"}}]
[null,null,"qn"]
[]
["10 DIAGRAMA FINAL DEL MURO SOTANO"]
[]
[null,"Terreno de relleno",{"$nulls":3},"Losa de Techo"]
[null,"//////////////////////","//////////////////////","•      •",{"$nulls":6},{"$f":"IFERROR(+D19,)","v":{"v":0,"d":"0.00 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •",null,{"$f":"+IFERROR(E159,)","v":"Ø"},{"$f":"+IFERROR(F159,)","v":0},{"$f":"+IFERROR(G159,)","v":"@"},{"$f":"+IFERROR(H159,)","v":{"v":0,"d":"0.000 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[null,{"$f":"IFERROR(+D18,)","v":{"v":0,"d":"0.00 m"}},null,"•      •",{"$nulls":6},{"$f":"IFERROR(+D17,)","v":{"v":0,"d":"0.00 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •",null,{"$f":"+IFERROR(E169,)","v":"Ø"},{"$f":"+IFERROR(F169,)","v":0},{"$f":"+IFERROR(G169,)","v":"@"},{"$f":"+IFERROR(H169,)","v":{"v":0,"d":"0.000 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •",null,"Piso de Concreto"]
[{"$nulls":3},"•      •",{"$nulls":6},{"$f":"IFERROR(+D20,)","v":{"v":0,"d":"0.00 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •",{"$nulls":6},{"$f":"IFERROR(+D16-D19-D17-D20-D21,)","v":{"v":0,"d":"0.00 m"}}]
[{"$nulls":3},"•      •"]
[{"$nulls":3},"•      •"]
[]
[]
[{"$nulls":10},{"$f":"IFERROR(+D21,)","v":{"v":0,"d":"0.00 m"}}]
[]
[]
[{"$nulls":5},"Nivel de cimentacion"]
[]
[]
[{"$nulls":3},{"$f":"IFERROR(+I215,)","v":{"v":0,"d":"0.00 m"}}]