{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Predimensionamiento","Hoja2"],"not_rendered":{"images":4,"macros":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Predimensionamiento","index":0,"n_rows":167,"n_cols":17,"rows_kept":167,"merged":[[2,0,2,10],[6,0,6,16],[10,0,10,16],[16,3,16,5],[28,2,28,6],[30,3,30,5],[34,1,34,7],[38,1,38,7],[42,2,42,3],[42,10,42,11],[43,2,43,3],[43,10,43,11],[44,2,44,3],[46,2,46,3],[46,4,46,5],[46,10,46,11],[47,2,47,3],[47,10,47,11],[49,2,49,13],[53,3,53,4],[53,11,53,12],[56,11,56,12],[58,5,58,6],[59,1,59,3],[60,1,60,3],[60,4,61,4],[60,5,61,5],[60,6,61,6],[60,7,61,7],[60,8,61,8],[60,9,61,9],[60,10,61,10],[60,11,61,11],[60,12,61,12],[60,13,61,13],[60,14,61,14],[60,15,61,15],[60,16,61,16],[61,1,61,3],[62,1,62,3],[62,4,63,4],[62,5,63,5],[62,6,63,6],[62,7,63,7],[62,8,63,8],[62,9,63,9],[62,10,63,10],[62,11,63,11],[62,12,63,12],[62,13,63,13],[62,14,63,14],[62,15,63,15],[62,16,63,16],[63,1,63,3],[64,1,64,3],[64,4,65,4],[64,5,65,5],[64,6,65,6],[64,7,65,7],[64,8,65,8],[64,9,65,9],[64,10,65,10],[64,11,65,11],[64,12,65,12],[64,13,65,13],[64,14,65,14],[64,15,65,15],[64,16,65,16],[65,1,65,3],[66,1,66,3],[66,4,67,4],[66,5,67,5],[66,6,67,6],[66,7,67,7],[66,8,67,8],[66,9,67,9],[66,10,67,10],[66,11,67,11],[66,12,67,12],[66,13,67,13],[66,14,67,14],[66,15,67,15],[66,16,67,16],[67,1,67,3],[68,1,68,3],[68,4,69,4],[68,5,69,5],[68,6,69,6],[68,7,69,7],[68,8,69,8],[68,9,69,9],[68,10,69,10],[68,11,69,11],[68,12,69,12],[68,13,69,13],[68,14,69,14],[68,15,69,15],[68,16,69,16],[69,1,69,3],[70,1,70,3],[70,4,71,4],[70,5,71,5],[70,6,71,6],[70,7,71,7],[70,8,71,8],[70,9,71,9],[70,10,71,10],[70,11,71,11],[70,12,71,12],[70,13,71,13],[70,14,71,14],[70,15,71,15],[70,16,71,16],[71,1,71,3],[72,1,72,3],[72,4,73,4],[72,5,73,5],[72,6,73,6],[72,7,73,7],[72,8,73,8],[72,9,73,9],[72,10,73,10],[72,11,73,11],[72,12,73,12],[72,13,73,13],[72,14,73,14],[72,15,73,15],[72,16,73,16],[73,1,73,3],[74,1,74,3],[74,4,75,4],[74,5,75,5],[74,6,75,6],[74,7,75,7],[74,8,75,8],[74,9,75,9],[74,10,75,10],[74,11,75,11],[74,12,75,12],[74,13,75,13],[74,14,75,14],[74,15,75,15],[74,16,75,16],[75,1,75,3],[76,1,76,3],[76,4,77,4],[76,5,77,5],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,10,77,10],[76,11,77,11],[76,12,77,12],[76,13,77,13],[76,14,77,14],[76,15,77,15],[76,16,77,16],[77,1,77,3],[78,1,78,3],[78,4,79,4],[78,5,79,5],[78,6,79,6],[78,7,79,7],[78,8,79,8],[78,9,79,9],[78,10,79,10],[78,11,79,11],[78,12,79,12],[78,13,79,13],[78,14,79,14],[78,15,79,15],[78,16,79,16],[79,1,79,3],[80,1,80,3],[80,4,81,4],[80,5,81,5],[80,6,81,6],[80,7,81,7],[80,8,81,8],[80,9,81,9],[80,10,81,10],[80,11,81,11],[80,12,81,12],[80,13,81,13],[80,14,81,14],[80,15,81,15],[80,16,81,16],[81,1,81,3],[82,1,82,3],[82,4,83,4],[82,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[82,10,83,10],[82,11,83,11],[82,12,83,12],[82,13,83,13],[82,14,83,14],[82,15,83,15],[82,16,83,16],[83,1,83,3],[84,1,84,3],[84,4,85,4],[84,5,85,5],[84,6,85,6],[84,7,85,7],[84,8,85,8],[84,9,85,9],[84,10,85,10],[84,11,85,11],[84,12,85,12],[84,13,85,13],[84,14,85,14],[84,15,85,15],[84,16,85,16],[85,1,85,3],[86,1,86,3],[86,4,87,4],[86,5,87,5],[86,6,87,6],[86,7,87,7],[86,8,87,8],[86,9,87,9],[86,10,87,10],[86,11,87,11],[86,12,87,12],[86,13,87,13],[86,14,87,14],[86,15,87,15],[86,16,87,16],[87,1,87,3],[88,1,88,3],[88,4,89,4],[88,5,89,5],[88,6,89,6],[88,7,89,7],[88,8,89,8],[88,9,89,9],[88,10,89,10],[88,11,89,11],[88,12,89,12],[88,13,89,13],[88,14,89,14],[88,15,89,15],[88,16,89,16],[89,1,89,3],[91,0,92,16],[98,1,98,2],[98,3,98,5],[99,1,99,2],[99,3,99,5],[99,7,99,8],[100,1,100,2],[100,3,100,5],[101,1,101,2],[101,3,101,5],[101,7,101,8],[102,1,102,2],[102,3,102,5],[103,1,103,2],[103,3,103,5],[103,7,103,8],[104,1,105,2],[104,3,105,5],[105,7,105,8],[109,3,109,5],[111,2,111,3],[111,4,111,7],[113,2,113,3],[113,4,113,7],[117,3,117,5],[123,10,123,11],[127,5,127,6],[128,1,128,3],[129,1,129,3],[129,4,130,4],[129,5,130,5],[129,6,130,6],[129,7,130,7],[129,8,130,8],[129,9,130,9],[129,10,130,10],[129,11,130,11],[129,12,130,12],[129,13,130,13],[129,14,130,14],[129,15,130,15],[129,16,130,16],[130,1,130,3],[131,1,131,3],[131,4,132,4],[131,5,132,5],[131,6,132,6],[131,7,132,7],[131,8,132,8],[131,9,132,9],[131,10,132,10],[131,11,132,11],[131,12,132,12],[131,13,132,13],[131,14,132,14],[131,15,132,15],[131,16,132,16],[132,1,132,3],[133,1,133,3],[133,4,134,4],[133,5,134,5],[133,6,134,6],[133,7,134,7],[133,8,134,8],[133,9,134,9],[133,10,134,10],[133,11,134,11],[133,12,134,12],[133,13,134,13],[133,14,134,14],[133,15,134,15],[133,16,134,16],[134,1,134,3],[135,1,135,3],[135,4,136,4],[135,5,136,5],[135,6,136,6],[135,7,136,7],[135,8,136,8],[135,9,136,9],[135,10,136,10],[135,11,136,11],[135,12,136,12],[135,13,136,13],[135,14,136,14],[135,15,136,15],[135,16,136,16],[136,1,136,3],[137,1,137,3],[137,4,138,4],[137,5,138,5],[137,6,138,6],[137,7,138,7],[137,8,138,8],[137,9,138,9],[137,10,138,10],[137,11,138,11],[137,12,138,12],[137,13,138,13],[137,14,138,14],[137,15,138,15],[137,16,138,16],[138,1,138,3],[139,1,139,3],[139,4,140,4],[139,5,140,5],[139,6,140,6],[139,7,140,7],[139,8,140,8],[139,9,140,9],[139,10,140,10],[139,11,140,11],[139,12,140,12],[139,13,140,13],[139,14,140,14],[139,15,140,15],[139,16,140,16],[140,1,140,3],[141,1,141,3],[141,4,142,4],[141,5,142,5],[141,6,142,6],[141,7,142,7],[141,8,142,8],[141,9,142,9],[141,10,142,10],[141,11,142,11],[141,12,142,12],[141,13,142,13],[141,14,142,14],[141,15,142,15],[141,16,142,16],[142,1,142,3],[143,1,143,3],[143,4,144,4],[143,5,144,5],[143,6,144,6],[143,7,144,7],[143,8,144,8],[143,9,144,9],[143,10,144,10],[143,11,144,11],[143,12,144,12],[143,13,144,13],[143,14,144,14],[143,15,144,15],[143,16,144,16],[144,1,144,3],[145,1,145,3],[145,4,146,4],[145,5,146,5],[145,6,146,6],[145,7,146,7],[145,8,146,8],[145,9,146,9],[145,10,146,10],[145,11,146,11],[145,12,146,12],[145,13,146,13],[145,14,146,14],[145,15,146,15],[145,16,146,16],[146,1,146,3],[147,1,147,3],[147,4,148,4],[147,5,148,5],[147,6,148,6],[147,7,148,7],[147,8,148,8],[147,9,148,9],[147,10,148,10],[147,11,148,11],[147,12,148,12],[147,13,148,13],[147,14,148,14],[147,15,148,15],[147,16,148,16],[148,1,148,3],[149,1,149,3],[149,4,150,4],[149,5,150,5],[149,6,150,6],[149,7,150,7],[149,8,150,8],[149,9,150,9],[149,10,150,10],[149,11,150,11],[149,12,150,12],[149,13,150,13],[149,14,150,14],[149,15,150,15],[149,16,150,16],[150,1,150,3],[151,1,151,3],[151,4,152,4],[151,5,152,5],[151,6,152,6],[151,7,152,7],[151,8,152,8],[151,9,152,9],[151,10,152,10],[151,11,152,11],[151,12,152,12],[151,13,152,13],[151,14,152,14],[151,15,152,15],[151,16,152,16],[152,1,152,3],[153,1,153,3],[153,4,154,4],[153,5,154,5],[153,6,154,6],[153,7,154,7],[153,8,154,8],[153,9,154,9],[153,10,154,10],[153,11,154,11],[153,12,154,12],[153,13,154,13],[153,14,154,14],[153,15,154,15],[153,16,154,16],[154,1,154,3],[155,1,155,3],[155,4,156,4],[155,5,156,5],[155,6,156,6],[155,7,156,7],[155,8,156,8],[155,9,156,9],[155,10,156,10],[155,11,156,11],[155,12,156,12],[155,13,156,13],[155,14,156,14],[155,15,156,15],[155,16,156,16],[156,1,156,3],[157,1,157,3],[157,4,158,4],[157,5,158,5],[157,6,158,6],[157,7,158,7],[157,8,158,8],[157,9,158,9],[157,10,158,10],[157,11,158,11],[157,12,158,12],[157,13,158,13],[157,14,158,14],[157,15,158,15],[157,16,158,16],[158,1,158,3],[159,1,159,3],[159,4,160,4],[159,5,160,5],[159,6,160,6],[159,7,160,7],[159,8,160,8],[159,9,160,9],[159,10,160,10],[159,11,160,11],[159,12,160,12],[159,13,160,13],[159,14,160,14],[159,15,160,15],[159,16,160,16],[160,1,160,3],[161,1,161,3],[161,4,162,4],[161,5,162,5],[161,6,162,6],[161,7,162,7],[161,8,162,8],[161,9,162,9],[161,10,162,10],[161,11,162,11],[161,12,162,12],[161,13,162,13],[161,14,162,14],[161,15,162,15],[161,16,162,16],[162,1,162,3],[163,1,163,3],[163,4,164,4],[163,5,164,5],[163,6,164,6],[163,7,164,7],[163,8,164,8],[163,9,164,9],[163,10,164,10],[163,11,164,11],[163,12,164,12],[163,13,164,13],[163,14,164,14],[163,15,164,15],[163,16,164,16],[164,1,164,3],[166,0,167,16]]}
[]
[]
["Grupo Crixuz Ingenieria y Construccion S.A.C."]
[null,"Cel:","#942656792"]
[null,"Correo:","grupo_crixuz@hotmail.com"]
[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"]
[]
[]
[]
["PREDIMENSIONAMIENTO DE VIGAS Y COLUMNAS"]
[]
["01","PREDIMENSIONAMIENTO DE VIGAS"]
[]
[null,"El momento flector último de una sección cualquiera puede expresarse como sigue:"]
[]
[{"$nulls":3},"Mu = ( Wu*B )*Ln2/α",{"$nulls":4},"(1)"]
[]
[null,"Donde:"]
[]
[null,"Wu =","Carga por unidad de área"]
[null,"Ln =","Longitud libre"]
[null,"B =","Dimension transversal tributaria"]
[null,"α =","Coeficiente de momento"]
[]
[null,"Para una sección rectangular con acero solo en la parte de"]
[null,"tracción, de acuerdo al ACI 318-14 se tiene:"]
[]
[null,null,"Mu = Ø*f'c*b*d2*w*(1-0.59w)",{"$nulls":5},"(2)"]
[]
[{"$nulls":3},"w = ρ*fy / f'c",{"$nulls":4},"(3)"]
[]
[null,"De las expresiones (1) y (2), tenemos"]
[]
[null,"( Wu*B )*Ln2/α = Ø*f'c*b*d2*w*(1-0.59w)",{"$nulls":6},"(4)"]
[]
[null,"De donde:"]
[]
[null,"d = Ln * [ (Wu*B) / (α*Ø*f'c*b*w*(1-0.59w)) ]1/2",{"$nulls":6},"(5)"]
[]
[null,"Considerando que la sección se ubica en la zona de momento positivo máximo, asumimos:"]
[]
[null,"α =",16,null,"(Depende de ubicación y apoyo)",{"$nulls":4},"Ø =",0.9,null,"(Factor reducción para flexion)"]
[null,"f'c =",210,null,"kg/cm2",{"$nulls":4},"fy =",4200,null,"kg/cm2"]
[null,"ρ =",0.007,null,"(0.7%) cuantia de acero"]
[]
[null,"w =","ρ*fy / f'c = ",null,{"$f":"+C45*K44/C44","v":0.14},{"$nulls":4},"b =","B / 20",null,"(Base de la viga)"]
[null,"Wu =","Carga ultima,",null,"en kg/cm2",{"$nulls":4},"d =","h / 1.1",null,"(Peralte efectivo de la viga)"]
[]
[null,null,"h / 1.1 = Ln * [ (Wu*B) / (16*0.9*210*(B/20)*0.14*(1-0.59*0.14)) ]1/2",{"$nulls":12},"(6)"]
[]
[null,"De donde obtenemos:",{"$nulls":7},"Redondeando los valores obtenemos:"]
[]
[null,null,"h =","Ln",{"$nulls":3},"(7)",null,null,"h =","Ln",{"$nulls":3},"(8)"]
[{"$nulls":3},{"$f":"(SQRT(C43*K43*C44*E47*(1-0.59*E47)/20))/1.1","v":{"v":4.006144371746071,"d":"4.01"}},"/ Wu1/ 2",{"$nulls":6},{"$f":"+ROUND(D55,0)","v":4},"/ Wu1/ 2"]
[]
[null,"A partir de la ecuacion (8), obtendremos el valor de Wu, para distintos usos:"]
[]
["Bloque","Carga viva minima repartida (E020)",{"$nulls":3},"Espesor aligerado",null,"Acabado","Tabique","Ln ó Lv","B ó Bv","Tipo de","Ancho","Altura","Zona","Ancho","Altura"]
["Eje","Ocupacion o uso",null,null,"kg/m2","Altura","kg/m2","kg/m2","kg/m2","(m)","(m)","Viga","viga (m)","viga (m)","sismica","viga (m)","viga (m)"]
["Block-A","Colegios.",null,null,{"$f":"+VLOOKUP(B62,Hoja2!$B$5:$C$81,2,FALSE)","v":250},"0.25 m",{"$f":"+VLOOKUP(F61,Hoja2!$J$3:$K$7,2,FALSE)","v":350},100,150,{"v":5,"d":"5.00"},4.5,"Central",{"$f":"+IF(L61=\"Perimetrica\",(K61*0.5+0.125+(950/(E61+G61+H61+I61)))/20,IF(L61=\"Central\",K61/20,K61/20))","v":{"v":0.225,"d":"0.23"}},{"$f":"+IFERROR(IF(L61=\"Perimetrica\",(K61*0.5+0.125+(950/(E61+G61+H61+I61)))/(3/(SQRT((1.4*(G61+H61+I61)+1.7*E61)/10000))),IF(L61=\"Central\",J61/(4/(SQRT((1.4*(G61+H61+I61)+1.7*E61)/10000))),1.4*2*J61/(4/(SQRT((1.4*(G61+H61+I61)+1.7*E61)/10000))))),)","v":{"v":0.4445854810944685,"d":"0.44"}},"Alta",0.25,{"$f":"+IFERROR(IF(O61=\"Alta\",MROUND((M61*N61*N61*N61/P61)^(1/3),0.05),MROUND((M61*N61*N61/P61)^(1/2),0.05)),)","v":0.45}]
["4-4","Aulas"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B64,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F63,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L63=\"Perimetrica\",(K63*0.5+0.125+(950/(E63+G63+H63+I63)))/20,IF(L63=\"Central\",K63/20,K63/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L63=\"Perimetrica\",(K63*0.5+0.125+(950/(E63+G63+H63+I63)))/(3/(SQRT((1.4*(G63+H63+I63)+1.7*E63)/10000))),IF(L63=\"Central\",J63/(4/(SQRT((1.4*(G63+H63+I63)+1.7*E63)/10000))),1.4*2*J63/(4/(SQRT((1.4*(G63+H63+I63)+1.7*E63)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O63=\"Alta\",MROUND((M63*N63*N63*N63/P63)^(1/3),0.05),MROUND((M63*N63*N63/P63)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B66,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F65,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L65=\"Perimetrica\",(K65*0.5+0.125+(950/(E65+G65+H65+I65)))/20,IF(L65=\"Central\",K65/20,K65/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L65=\"Perimetrica\",(K65*0.5+0.125+(950/(E65+G65+H65+I65)))/(3/(SQRT((1.4*(G65+H65+I65)+1.7*E65)/10000))),IF(L65=\"Central\",J65/(4/(SQRT((1.4*(G65+H65+I65)+1.7*E65)/10000))),1.4*2*J65/(4/(SQRT((1.4*(G65+H65+I65)+1.7*E65)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O65=\"Alta\",MROUND((M65*N65*N65*N65/P65)^(1/3),0.05),MROUND((M65*N65*N65/P65)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B68,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F67,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L67=\"Perimetrica\",(K67*0.5+0.125+(950/(E67+G67+H67+I67)))/20,IF(L67=\"Central\",K67/20,K67/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L67=\"Perimetrica\",(K67*0.5+0.125+(950/(E67+G67+H67+I67)))/(3/(SQRT((1.4*(G67+H67+I67)+1.7*E67)/10000))),IF(L67=\"Central\",J67/(4/(SQRT((1.4*(G67+H67+I67)+1.7*E67)/10000))),1.4*2*J67/(4/(SQRT((1.4*(G67+H67+I67)+1.7*E67)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O67=\"Alta\",MROUND((M67*N67*N67*N67/P67)^(1/3),0.05),MROUND((M67*N67*N67/P67)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B70,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F69,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L69=\"Perimetrica\",(K69*0.5+0.125+(950/(E69+G69+H69+I69)))/20,IF(L69=\"Central\",K69/20,K69/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L69=\"Perimetrica\",(K69*0.5+0.125+(950/(E69+G69+H69+I69)))/(3/(SQRT((1.4*(G69+H69+I69)+1.7*E69)/10000))),IF(L69=\"Central\",J69/(4/(SQRT((1.4*(G69+H69+I69)+1.7*E69)/10000))),1.4*2*J69/(4/(SQRT((1.4*(G69+H69+I69)+1.7*E69)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O69=\"Alta\",MROUND((M69*N69*N69*N69/P69)^(1/3),0.05),MROUND((M69*N69*N69/P69)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B72,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F71,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L71=\"Perimetrica\",(K71*0.5+0.125+(950/(E71+G71+H71+I71)))/20,IF(L71=\"Central\",K71/20,K71/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L71=\"Perimetrica\",(K71*0.5+0.125+(950/(E71+G71+H71+I71)))/(3/(SQRT((1.4*(G71+H71+I71)+1.7*E71)/10000))),IF(L71=\"Central\",J71/(4/(SQRT((1.4*(G71+H71+I71)+1.7*E71)/10000))),1.4*2*J71/(4/(SQRT((1.4*(G71+H71+I71)+1.7*E71)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O71=\"Alta\",MROUND((M71*N71*N71*N71/P71)^(1/3),0.05),MROUND((M71*N71*N71/P71)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B74,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F73,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L73=\"Perimetrica\",(K73*0.5+0.125+(950/(E73+G73+H73+I73)))/20,IF(L73=\"Central\",K73/20,K73/20))","v":{"v":0,"d":"0.00"}},{"$f":"+IFERROR(IF(L73=\"Perimetrica\",(K73*0.5+0.125+(950/(E73+G73+H73+I73)))/(3/(SQRT((1.4*(G73+H73+I73)+1.7*E73)/10000))),IF(L73=\"Central\",J73/(4/(SQRT((1.4*(G73+H73+I73)+1.7*E73)/10000))),1.4*2*J73/(4/(SQRT((1.4*(G73+H73+I73)+1.7*E73)/10000))))),)","v":{"v":0,"d":"0.00"}},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O73=\"Alta\",MROUND((M73*N73*N73*N73/P73)^(1/3),0.05),MROUND((M73*N73*N73/P73)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B76,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F75,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L75=\"Perimetrica\",(K75*0.5+0.125+(950/(E75+G75+H75+I75)))/20,IF(L75=\"Central\",K75/20,K75/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O75=\"Alta\",MROUND((M75*N75*N75*N75/P75)^(1/3),0.05),MROUND((M75*N75*N75/P75)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B78,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F77,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L77=\"Perimetrica\",(K77*0.5+0.125+(950/(E77+G77+H77+I77)))/20,IF(L77=\"Central\",K77/20,K77/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O77=\"Alta\",MROUND((M77*N77*N77*N77/P77)^(1/3),0.05),MROUND((M77*N77*N77/P77)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B80,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F79,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L79=\"Perimetrica\",(K79*0.5+0.125+(950/(E79+G79+H79+I79)))/20,IF(L79=\"Central\",K79/20,K79/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O79=\"Alta\",MROUND((M79*N79*N79*N79/P79)^(1/3),0.05),MROUND((M79*N79*N79/P79)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B82,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F81,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L81=\"Perimetrica\",(K81*0.5+0.125+(950/(E81+G81+H81+I81)))/20,IF(L81=\"Central\",K81/20,K81/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O81=\"Alta\",MROUND((M81*N81*N81*N81/P81)^(1/3),0.05),MROUND((M81*N81*N81/P81)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B84,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F83,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L83=\"Perimetrica\",(K83*0.5+0.125+(950/(E83+G83+H83+I83)))/20,IF(L83=\"Central\",K83/20,K83/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O83=\"Alta\",MROUND((M83*N83*N83*N83/P83)^(1/3),0.05),MROUND((M83*N83*N83/P83)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B86,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F85,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L85=\"Perimetrica\",(K85*0.5+0.125+(950/(E85+G85+H85+I85)))/20,IF(L85=\"Central\",K85/20,K85/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O85=\"Alta\",MROUND((M85*N85*N85*N85/P85)^(1/3),0.05),MROUND((M85*N85*N85/P85)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B88,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F87,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L87=\"Perimetrica\",(K87*0.5+0.125+(950/(E87+G87+H87+I87)))/20,IF(L87=\"Central\",K87/20,K87/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O87=\"Alta\",MROUND((M87*N87*N87*N87/P87)^(1/3),0.05),MROUND((M87*N87*N87/P87)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Hoteles.",null,null,{"$f":"+VLOOKUP(B90,Hoja2!$B$5:$C$81,2,FALSE)","v":200},"Ninguna",{"$f":"+VLOOKUP(F89,Hoja2!$J$3:$K$7,2,FALSE)","v":0},0,0,{"v":0,"d":"0.00"},0,"Central",{"$f":"+IF(L89=\"Perimetrica\",(K89*0.5+0.125+(950/(E89+G89+H89+I89)))/20,IF(L89=\"Central\",K89/20,K89/20))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},"Normal",{"v":0,"d":"0.00"},{"$f":"+IFERROR(IF(O89=\"Alta\",MROUND((M89*N89*N89*N89/P89)^(1/3),0.05),MROUND((M89*N89*N89/P89)^(1/2),0.05)),)","v":{"v":0,"d":"0.00"}}]
["--","Cuartos.."]
[]
["NOTA: Editar solo las celdas que contiene el texto de color Azul, para obtener la dimensiones finales de las vigas debemos de ingresar el valor del ancho de la viga deseada en la penultima columna, y automaticamente se generara el valor de la altura de la viga en la ultima columna. "]
[]
[]
["02","PREDIMENSIONAMIENTO DE COLUMNAS"]
[]
[null,"La tabla muestra los valores de P y n para el predimensionamiento de columnas, Pg es el peso total de cargas de gravedad"]
[]
[null," TIPO C-1",null,"Columna",null,null,"P =",{"v":1.1,"d":"1.10"},"Pg"]
[null,"Primeros pisos",null,"Interior",null,null,"n =",{"v":0.3,"d":"0.30"}]
[null," TIPO C-1''",null,"Columna",null,null,"P =",{"v":1.1,"d":"1.10"},"Pg"]
[null,"4 ultimos pisos",null,"Interior",null,null,"n =",0.25]
[null,"TIPO C-2 Y",null,"Comunas extremas de",null,null,"P =",1.25,"Pg"]
[null,"TIPO C-3",null,"porticos interiores",null,null,"n =",0.25]
[null,"TIPO C-4",null,"Columnas de Esquina",null,null,"P =",{"v":1.5,"d":"1.50"},"Pg"]
[{"$nulls":6},"n =",{"v":0.2,"d":"0.20"}]
[]
[null,"Según ensayos en Japon, tenemos que:"]
[]
[{"$nulls":3},"n = P / ( f'c*b*D )",null,null,"(1)"]
[]
[null,null,"n > 1/3",null,"Falla fragil por aplastamiento"]
[]
[null,null,"n < 1/3",null,"Falla ductil"]
[]
[null,"Las columnas se predimensionan con:"]
[]
[{"$nulls":3},"bD = P / ( n*f'c )",null,null,"(2)"]
[]
[null,"Donde:"]
[]
[null,"D =","Dimension de seccion en la direccion de sismo",{"$nulls":6},"P =","Carga total que soporta la columna"]
[null,"b =","Dimension de seccion en la otra direccion",{"$nulls":6},"f'c =","Resistencia del concreto a la compresion"]
[null,"n =","Valor que depende del tipo de columna",{"$nulls":6},"f'c =",350,null,"kg/cm2"]
[]
[null,"A partir de la ecuacion (2), obtendremos área de las columnas, para distintos usos:"]
[{"$nulls":13},"cm2","m","m","m"]
["Bloque","Carga viva minima repartida (E020)",{"$nulls":3},"Espesor aligerado",null,"Acabado","Tabique","Peso de","Peso de","Area trib.","Tipo de","Area de","Columna","Ancho","Largo"]
["Eje","Ocupacion o uso",null,null,"kg/m2","Altura","kg/m2","kg/m2","kg/m2","vigas","columnas","(m2)","Columna","Columna","cuadrada","D (m)","b (m)"]
["Block-A","Colegios.",null,null,{"$f":"+VLOOKUP(B131,Hoja2!$B$5:$C$81,2,FALSE)","v":250},"0.25 m",{"$f":"+VLOOKUP(F130,Hoja2!$J$3:$K$7,2,FALSE)","v":350},100,120,100,60,27.4,"C-2",{"$f":"+IFERROR(IF(M130=\"Ninguno\",0,IF(M130=\"C-1\",(E130+G130+H130+I130+J130+K130)*L130*1.1*10/(0.3*$K$124),IF(M130=\"C-1'\",(E130+G130+H130+I130+J130+K130)*L130*1*10/(0.3*$K$124),IF(M130=\"C-1''\",(E130+G130+H130+I130+J130+K130)*L130*1.1*10/(0.25*$K$124),IF(M130=\"C-2\",(E130+G130+H130+I130+J130+K130)*L130*1.25*10/(0.25*$K$124),IF(M130=\"C-3\",(E130+G130+H130+I130+J130+K130)*L130*1.25*10/(0.25*$K$124),IF(M130=\"C-4\",(E130+G130+H130+I130+J130+K130)*L130*1.5*10/(0.2*$K$124),0))))))),)","v":3836},{"$f":"+IFERROR(MROUND(SQRT(N130)/100,0.05),)","v":{"v":0.6000000000000001,"d":"0.60"}},{"v":0.8,"d":"0.80"},{"$f":"+IFERROR(MROUND((N130/(P130*100))/100,0.05),)","v":{"v":0.5,"d":"0.50"}}]
["B-4","Aulas"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B133,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F132,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M132=\"Ninguno\",0,IF(M132=\"C-1\",(E132+G132+H132+I132+J132+K132)*L132*1.1*10/(0.3*$K$124),IF(M132=\"C-1'\",(E132+G132+H132+I132+J132+K132)*L132*1*10/(0.3*$K$124),IF(M132=\"C-1''\",(E132+G132+H132+I132+J132+K132)*L132*1.1*10/(0.25*$K$124),IF(M132=\"C-2\",(E132+G132+H132+I132+J132+K132)*L132*1.25*10/(0.25*$K$124),IF(M132=\"C-3\",(E132+G132+H132+I132+J132+K132)*L132*1.25*10/(0.25*$K$124),IF(M132=\"C-4\",(E132+G132+H132+I132+J132+K132)*L132*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N132)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N132/(P132*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B135,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F134,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M134=\"Ninguno\",0,IF(M134=\"C-1\",(E134+G134+H134+I134+J134+K134)*L134*1.1*10/(0.3*$K$124),IF(M134=\"C-1'\",(E134+G134+H134+I134+J134+K134)*L134*1*10/(0.3*$K$124),IF(M134=\"C-1''\",(E134+G134+H134+I134+J134+K134)*L134*1.1*10/(0.25*$K$124),IF(M134=\"C-2\",(E134+G134+H134+I134+J134+K134)*L134*1.25*10/(0.25*$K$124),IF(M134=\"C-3\",(E134+G134+H134+I134+J134+K134)*L134*1.25*10/(0.25*$K$124),IF(M134=\"C-4\",(E134+G134+H134+I134+J134+K134)*L134*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N134)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N134/(P134*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B137,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F136,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M136=\"Ninguno\",0,IF(M136=\"C-1\",(E136+G136+H136+I136+J136+K136)*L136*1.1*10/(0.3*$K$124),IF(M136=\"C-1'\",(E136+G136+H136+I136+J136+K136)*L136*1*10/(0.3*$K$124),IF(M136=\"C-1''\",(E136+G136+H136+I136+J136+K136)*L136*1.1*10/(0.25*$K$124),IF(M136=\"C-2\",(E136+G136+H136+I136+J136+K136)*L136*1.25*10/(0.25*$K$124),IF(M136=\"C-3\",(E136+G136+H136+I136+J136+K136)*L136*1.25*10/(0.25*$K$124),IF(M136=\"C-4\",(E136+G136+H136+I136+J136+K136)*L136*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N136)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N136/(P136*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B139,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F138,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M138=\"Ninguno\",0,IF(M138=\"C-1\",(E138+G138+H138+I138+J138+K138)*L138*1.1*10/(0.3*$K$124),IF(M138=\"C-1'\",(E138+G138+H138+I138+J138+K138)*L138*1*10/(0.3*$K$124),IF(M138=\"C-1''\",(E138+G138+H138+I138+J138+K138)*L138*1.1*10/(0.25*$K$124),IF(M138=\"C-2\",(E138+G138+H138+I138+J138+K138)*L138*1.25*10/(0.25*$K$124),IF(M138=\"C-3\",(E138+G138+H138+I138+J138+K138)*L138*1.25*10/(0.25*$K$124),IF(M138=\"C-4\",(E138+G138+H138+I138+J138+K138)*L138*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N138)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N138/(P138*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B141,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F140,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M140=\"Ninguno\",0,IF(M140=\"C-1\",(E140+G140+H140+I140+J140+K140)*L140*1.1*10/(0.3*$K$124),IF(M140=\"C-1'\",(E140+G140+H140+I140+J140+K140)*L140*1*10/(0.3*$K$124),IF(M140=\"C-1''\",(E140+G140+H140+I140+J140+K140)*L140*1.1*10/(0.25*$K$124),IF(M140=\"C-2\",(E140+G140+H140+I140+J140+K140)*L140*1.25*10/(0.25*$K$124),IF(M140=\"C-3\",(E140+G140+H140+I140+J140+K140)*L140*1.25*10/(0.25*$K$124),IF(M140=\"C-4\",(E140+G140+H140+I140+J140+K140)*L140*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N140)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N140/(P140*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B143,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F142,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M142=\"Ninguno\",0,IF(M142=\"C-1\",(E142+G142+H142+I142+J142+K142)*L142*1.1*10/(0.3*$K$124),IF(M142=\"C-1'\",(E142+G142+H142+I142+J142+K142)*L142*1*10/(0.3*$K$124),IF(M142=\"C-1''\",(E142+G142+H142+I142+J142+K142)*L142*1.1*10/(0.25*$K$124),IF(M142=\"C-2\",(E142+G142+H142+I142+J142+K142)*L142*1.25*10/(0.25*$K$124),IF(M142=\"C-3\",(E142+G142+H142+I142+J142+K142)*L142*1.25*10/(0.25*$K$124),IF(M142=\"C-4\",(E142+G142+H142+I142+J142+K142)*L142*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N142)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N142/(P142*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B145,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F144,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M144=\"Ninguno\",0,IF(M144=\"C-1\",(E144+G144+H144+I144+J144+K144)*L144*1.1*10/(0.3*$K$124),IF(M144=\"C-1'\",(E144+G144+H144+I144+J144+K144)*L144*1*10/(0.3*$K$124),IF(M144=\"C-1''\",(E144+G144+H144+I144+J144+K144)*L144*1.1*10/(0.25*$K$124),IF(M144=\"C-2\",(E144+G144+H144+I144+J144+K144)*L144*1.25*10/(0.25*$K$124),IF(M144=\"C-3\",(E144+G144+H144+I144+J144+K144)*L144*1.25*10/(0.25*$K$124),IF(M144=\"C-4\",(E144+G144+H144+I144+J144+K144)*L144*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N144)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N144/(P144*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B147,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F146,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M146=\"Ninguno\",0,IF(M146=\"C-1\",(E146+G146+H146+I146+J146+K146)*L146*1.1*10/(0.3*$K$124),IF(M146=\"C-1'\",(E146+G146+H146+I146+J146+K146)*L146*1*10/(0.3*$K$124),IF(M146=\"C-1''\",(E146+G146+H146+I146+J146+K146)*L146*1.1*10/(0.25*$K$124),IF(M146=\"C-2\",(E146+G146+H146+I146+J146+K146)*L146*1.25*10/(0.25*$K$124),IF(M146=\"C-3\",(E146+G146+H146+I146+J146+K146)*L146*1.25*10/(0.25*$K$124),IF(M146=\"C-4\",(E146+G146+H146+I146+J146+K146)*L146*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N146)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N146/(P146*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B149,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F148,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M148=\"Ninguno\",0,IF(M148=\"C-1\",(E148+G148+H148+I148+J148+K148)*L148*1.1*10/(0.3*$K$124),IF(M148=\"C-1'\",(E148+G148+H148+I148+J148+K148)*L148*1*10/(0.3*$K$124),IF(M148=\"C-1''\",(E148+G148+H148+I148+J148+K148)*L148*1.1*10/(0.25*$K$124),IF(M148=\"C-2\",(E148+G148+H148+I148+J148+K148)*L148*1.25*10/(0.25*$K$124),IF(M148=\"C-3\",(E148+G148+H148+I148+J148+K148)*L148*1.25*10/(0.25*$K$124),IF(M148=\"C-4\",(E148+G148+H148+I148+J148+K148)*L148*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N148)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N148/(P148*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B151,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F150,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M150=\"Ninguno\",0,IF(M150=\"C-1\",(E150+G150+H150+I150+J150+K150)*L150*1.1*10/(0.3*$K$124),IF(M150=\"C-1'\",(E150+G150+H150+I150+J150+K150)*L150*1*10/(0.3*$K$124),IF(M150=\"C-1''\",(E150+G150+H150+I150+J150+K150)*L150*1.1*10/(0.25*$K$124),IF(M150=\"C-2\",(E150+G150+H150+I150+J150+K150)*L150*1.25*10/(0.25*$K$124),IF(M150=\"C-3\",(E150+G150+H150+I150+J150+K150)*L150*1.25*10/(0.25*$K$124),IF(M150=\"C-4\",(E150+G150+H150+I150+J150+K150)*L150*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N150)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N150/(P150*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B153,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F152,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M152=\"Ninguno\",0,IF(M152=\"C-1\",(E152+G152+H152+I152+J152+K152)*L152*1.1*10/(0.3*$K$124),IF(M152=\"C-1'\",(E152+G152+H152+I152+J152+K152)*L152*1*10/(0.3*$K$124),IF(M152=\"C-1''\",(E152+G152+H152+I152+J152+K152)*L152*1.1*10/(0.25*$K$124),IF(M152=\"C-2\",(E152+G152+H152+I152+J152+K152)*L152*1.25*10/(0.25*$K$124),IF(M152=\"C-3\",(E152+G152+H152+I152+J152+K152)*L152*1.25*10/(0.25*$K$124),IF(M152=\"C-4\",(E152+G152+H152+I152+J152+K152)*L152*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N152)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N152/(P152*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B155,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F154,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M154=\"Ninguno\",0,IF(M154=\"C-1\",(E154+G154+H154+I154+J154+K154)*L154*1.1*10/(0.3*$K$124),IF(M154=\"C-1'\",(E154+G154+H154+I154+J154+K154)*L154*1*10/(0.3*$K$124),IF(M154=\"C-1''\",(E154+G154+H154+I154+J154+K154)*L154*1.1*10/(0.25*$K$124),IF(M154=\"C-2\",(E154+G154+H154+I154+J154+K154)*L154*1.25*10/(0.25*$K$124),IF(M154=\"C-3\",(E154+G154+H154+I154+J154+K154)*L154*1.25*10/(0.25*$K$124),IF(M154=\"C-4\",(E154+G154+H154+I154+J154+K154)*L154*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N154)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N154/(P154*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B157,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F156,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M156=\"Ninguno\",0,IF(M156=\"C-1\",(E156+G156+H156+I156+J156+K156)*L156*1.1*10/(0.3*$K$124),IF(M156=\"C-1'\",(E156+G156+H156+I156+J156+K156)*L156*1*10/(0.3*$K$124),IF(M156=\"C-1''\",(E156+G156+H156+I156+J156+K156)*L156*1.1*10/(0.25*$K$124),IF(M156=\"C-2\",(E156+G156+H156+I156+J156+K156)*L156*1.25*10/(0.25*$K$124),IF(M156=\"C-3\",(E156+G156+H156+I156+J156+K156)*L156*1.25*10/(0.25*$K$124),IF(M156=\"C-4\",(E156+G156+H156+I156+J156+K156)*L156*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N156)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N156/(P156*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B159,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F158,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M158=\"Ninguno\",0,IF(M158=\"C-1\",(E158+G158+H158+I158+J158+K158)*L158*1.1*10/(0.3*$K$124),IF(M158=\"C-1'\",(E158+G158+H158+I158+J158+K158)*L158*1*10/(0.3*$K$124),IF(M158=\"C-1''\",(E158+G158+H158+I158+J158+K158)*L158*1.1*10/(0.25*$K$124),IF(M158=\"C-2\",(E158+G158+H158+I158+J158+K158)*L158*1.25*10/(0.25*$K$124),IF(M158=\"C-3\",(E158+G158+H158+I158+J158+K158)*L158*1.25*10/(0.25*$K$124),IF(M158=\"C-4\",(E158+G158+H158+I158+J158+K158)*L158*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N158)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N158/(P158*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B161,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F160,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M160=\"Ninguno\",0,IF(M160=\"C-1\",(E160+G160+H160+I160+J160+K160)*L160*1.1*10/(0.3*$K$124),IF(M160=\"C-1'\",(E160+G160+H160+I160+J160+K160)*L160*1*10/(0.3*$K$124),IF(M160=\"C-1''\",(E160+G160+H160+I160+J160+K160)*L160*1.1*10/(0.25*$K$124),IF(M160=\"C-2\",(E160+G160+H160+I160+J160+K160)*L160*1.25*10/(0.25*$K$124),IF(M160=\"C-3\",(E160+G160+H160+I160+J160+K160)*L160*1.25*10/(0.25*$K$124),IF(M160=\"C-4\",(E160+G160+H160+I160+J160+K160)*L160*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N160)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N160/(P160*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B163,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F162,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M162=\"Ninguno\",0,IF(M162=\"C-1\",(E162+G162+H162+I162+J162+K162)*L162*1.1*10/(0.3*$K$124),IF(M162=\"C-1'\",(E162+G162+H162+I162+J162+K162)*L162*1*10/(0.3*$K$124),IF(M162=\"C-1''\",(E162+G162+H162+I162+J162+K162)*L162*1.1*10/(0.25*$K$124),IF(M162=\"C-2\",(E162+G162+H162+I162+J162+K162)*L162*1.25*10/(0.25*$K$124),IF(M162=\"C-3\",(E162+G162+H162+I162+J162+K162)*L162*1.25*10/(0.25*$K$124),IF(M162=\"C-4\",(E162+G162+H162+I162+J162+K162)*L162*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N162)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N162/(P162*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
["--","Ninguno.",null,null,{"$f":"+VLOOKUP(B165,Hoja2!$B$5:$C$81,2,FALSE)","v":0},"Ninguna",{"$f":"+VLOOKUP(F164,Hoja2!$J$3:$K$7,2,FALSE)","v":0},{"$nulls":5},"Ninguno",{"$f":"+IFERROR(IF(M164=\"Ninguno\",0,IF(M164=\"C-1\",(E164+G164+H164+I164+J164+K164)*L164*1.1*10/(0.3*$K$124),IF(M164=\"C-1'\",(E164+G164+H164+I164+J164+K164)*L164*1*10/(0.3*$K$124),IF(M164=\"C-1''\",(E164+G164+H164+I164+J164+K164)*L164*1.1*10/(0.25*$K$124),IF(M164=\"C-2\",(E164+G164+H164+I164+J164+K164)*L164*1.25*10/(0.25*$K$124),IF(M164=\"C-3\",(E164+G164+H164+I164+J164+K164)*L164*1.25*10/(0.25*$K$124),IF(M164=\"C-4\",(E164+G164+H164+I164+J164+K164)*L164*1.5*10/(0.2*$K$124),0))))))),)","v":0},{"$f":"+IFERROR(MROUND(SQRT(N164)/100,0.05),)","v":{"v":0,"d":"0.00"}},null,{"$f":"+IFERROR(MROUND((N164/(P164*100))/100,0.05),)","v":{"v":0,"d":"0.00"}}]
["--","Sin Selección"]
[]
["NOTA: Editar solo las celdas que contiene el texto de color Azul, para obtener la dimensiones finales de las columnas debemos de ingresar el valor del ancho de columna deseada en la penultima columna, y automaticamente se generara el valor de la altura de columna en la ultima columna. "]

{"sheet":"Hoja2","index":1,"n_rows":81,"n_cols":12,"rows_kept":81,"hidden":true,"merged":[[47,4,47,5],[47,6,47,8],[48,4,48,5],[48,6,48,8],[48,10,48,11],[49,4,49,5],[49,6,49,8],[50,4,50,5],[50,6,50,8],[50,10,50,11],[51,4,51,5],[51,6,51,8],[52,4,52,5],[52,6,52,8],[52,10,52,11],[53,4,54,5],[53,6,54,8],[54,10,54,11]]}
[]
[{"$nulls":9},"Altura"]
[{"$nulls":9},"Ninguna",0]
[{"$nulls":9},"0.17 m",280]
[null,"Sin Selección",0,null,"Ninguno.",{"$nulls":4},"0.20 m",300]
[null,"Almacenaje.",null,null,"Almacenaje.",{"$nulls":4},"0.25 m",350]
[null,"Almacenaje",500,null,"Baños.",{"$nulls":4},"0.30 m",420]
[{"$nulls":4},"Bibliotecas."]
[null,"Baños.",null,null,"Colegios."]
[null,"Baños",200,null,"Garajes."]
[{"$nulls":4},"Hospitales."]
[null,"Bibliotecas.",null,null,"Hoteles."]
[null,"Salas de lectura",300,null,"Industria."]
[null,"Salas de almacenaje estantes fijos",750,null,"Carceles.",{"$nulls":4},"Perimetrica"]
[null,"Corredores y escaleras.",400,null,"Asambleas.",{"$nulls":4},"Central"]
[{"$nulls":4},"Oficinas.",{"$nulls":4},"Voladizo"]
[null,"Centros de Educación.",null,null,"Teatros."]
[null,"Aulas",250,null,"Tiendas.",{"$nulls":4},"Alta"]
[null,"Talleres",350,null,"Viviendas.",{"$nulls":4},"Normal"]
[null,"Auditorios",400]
[null,"Gimnasios, etc.",400]
[null,"Laboratorios",300]
[null,"Corredores y escaleras..",400,{"$nulls":6},"P","N"]
[{"$nulls":4},210,{"$nulls":3},"Ninguno",0,0]
[null,"Garajes.",null,null,280,{"$nulls":3},"C-1",1.1,0.3]
[null,"Para vehículos de pasajeros",250,null,350,{"$nulls":3},"C-1'",1,0.3]
[null,"Para otros vehículos",350,null,420,{"$nulls":3},"C-1''",1.1,0.25]
[{"$nulls":4},490,{"$nulls":3},"C-2",1.25,0.25]
[null,"Hospitales.",null,null,560,{"$nulls":3},"C-3",1.25,0.25]
[null,"Salas de operación",300,null,630,{"$nulls":3},"C-4",1.5,0.2]
[null,"Laboratorios",300,null,700]
[null,"Zonas de servicio",300,null,770]
[null,"Cuartos.",200,null,840]
[null,"Corredores y escaleras...",400,null,910]
[{"$nulls":4},980]
[null,"Hoteles."]
[null,"Cuartos..",200]
[null,"Salas públicas",300]
[null,"Almacenaje y servicios",500]
[null,"Corredores y escaleras .",400]
[]
[null,"Industria."]
[null,"Industria",400]
[]
[null,"Instituciones Penales."]
[null,"Celdas y habitaciones",200]
[null,"Zonas públicas.",300]
[null,"Corredores y escaleras ..",400,null," TIPO C-1",null,"Columna",null,null,"P =",{"v":1.1,"d":"1.10"},"Pg"]
[{"$nulls":4},"Primeros pisos",null,"Interior",null,null,"n =",{"v":0.3,"d":"0.30"}]
[null,"Lugares de Asamblea.",null,null," TIPO C-1''",null,"Columna",null,null,"P =",{"v":1.1,"d":"1.10"},"Pg"]
[null,"Con asientos fijos",300,null,"4 ultimos pisos",null,"Interior",null,null,"n =",0.25]
[null,"Con asientos movibles",400,null,"TIPO C-2 Y",null,"Comunas extremas de",null,null,"P =",1.25,"Pg"]
[null,"Salones de baile",400,null,"TIPO C-3",null,"porticos interiores",null,null,"n =",0.25]
[null,"Restaurantes",400,null,"TIPO C-4",null,"Columnas de Esquina",null,null,"P =",{"v":1.5,"d":"1.50"},"Pg"]
[null,"Museos",400,{"$nulls":6},"n =",{"v":0.2,"d":"0.20"}]
[null,"Gimnasios",400]
[null,"Vestíbulos de teatros.",400]
[null,"Vestíbulos de cines.",400]
[null,"Graderías y tribunas",500]
[null,"Corredores y escaleras …",500]
[]
[null,"Oficinas."]
[null,"Exceptuando salas de archivo",250]
[null,"Exceptuando salas de computación",250]
[null,"Salas de archivo",500]
[null,"Salas de computación",250]
[null,"Corredores y escaleras  .",400]
[]
[null,"Teatros."]
[null,"Vestidores",200]
[null,"Cuarto de proyección",300]
[null,"Escenario",750]
[null,"Zonas públicas..",400]
[]
[null,"Tiendas."]
[null,"Tiendas",500]
[null,"Corredores y escaleras  ..",500]
[]
[null,"Viviendas."]
[null,"Viviendas",200]
[null,"Corredores y escaleras  …",200]