excel para diseño columna
TRANSCRIPT
-
8/15/2019 Excel para Diseño Columna
1/58
DISEÑO DE COLUMNAS DE CONCRETO ARMADO
Dimensiones de columnaH= 60 CmB= 25 Cm
Materialesfc= 210 Kg/cm2Fy= 4200 Kg/cm2
Numero de pisos edicio: 7 ! "eso por u#id$d de $re$% 0&7 '#/m2(re$ 'ri)u*$ri$: 2+&,2 m2#= 0&45 Co-um#$ ce#*rC$rg$ *o*$- e# -$ co-um#$ !1&25 "s%: 17+&5.5 '#C$rg$ $i$- resis*e#*e: 141&75
s*ri)o: ,/. 5&.+
efuero:
Fila n di F Area1 2 ,&4+ 1 10&1,42 2 17&67 ,/4 5&700, 0 2,&56 0 0&0004 0 2+&45 0 0&0005 0 ,5&,4 5/. 0&0006 0 41&2, 5/. 0&0007 0 47&12 0 0&000. 0 5,&02 0 0&000+ 2 ,5&,4 ,/4 5&70010 2 56&51 1 10&1,4
(re$ 'o*$-: ,1&66+
(re$ )ru*$ Co-um#$: 1500 Cm2
r= 00!"""!#
O$ Co#dicio# Co#ce#*ric$: "= 400&761 '#ey= 0&0021 C)= ,,&240
r%00"
-
8/15/2019 Excel para Diseño Columna
2/58
36&+51&,
3.&25
-
8/15/2019 Excel para Diseño Columna
3/58
,6
$-
(ume#*$r dime#sio#es
cm2
Cm
0 5 10 15 20 25 ,0 ,0
50
100
150
200
250
,00
M &tn'm(
)&Tn(
-
8/15/2019 Excel para Diseño Columna
4/58
-
8/15/2019 Excel para Diseño Columna
5/58
-
8/15/2019 Excel para Diseño Columna
6/58
-
8/15/2019 Excel para Diseño Columna
7/58
C)= ,,&2,+705..24 d= 56&51ey= 0&0021
F$--$ Fr$gi- = 2000000
,,&24 ,&,2,+705+
C C d11 0 01 ,&,2,+705+ ,&,2,+705..2, 6&647+411. 6&647+4117654 +&+71+1176 +&+71+1176475 1,&2+5..24 1,&2+5..2,52+6 16&61+.52+ 16&61+.52+4127 1+&+4,.2,5 1+&+4,.2,52+4. 2,&2677+41 2,&2677+41176
+ 26&5+17647 26&5+1764705+10 2+&+157,5, 2+&+157,52+4111 ,,&2,+705+ ,,&2,+705..24
Ce#*ro p-$s*iC= ,&,24(cero:di (i e si F
1 ,&4+ 10&1, 0&000152 ,04&21 ,0.2&..2 17&67 5&70 0&012+4+ 4200&00 2,+41&+,, 2,&56 0&00 0&01.266 4200&00 0&004 2+&45 0&00 0&02,5.2 4200&00 0&005 ,5&,4 0&00 0&02..++ 4200&00 0&006 41&2, 0&00 0&0,4215 4200&00 0&007 47&12 0&00 0&0,+5,1 4200&00 0&00. 5,&02 0&00 0&044.4. 4200&00 0&00+ ,5&,4 5&70 0&02..++ 4200&00 2,+41&+,
10 56&51 10&1, 0&04.000 4200&00 4256,&4,+,5,0&17
Co#cre*o: $= 2&.25,75 cm)= 25 cmfc= 210 Kg/cm2"c= 31260.&24
"= .0+21&+, =3.0&+2 =
C= 6&64.(cero:di (i e si F
,&4+ 10&1, 30&001424 32.47&+0 32..61&0117&67 5&70 0&004+75 4200&00 2,+41&+,
-
8/15/2019 Excel para Diseño Columna
8/58
2,&56 0&00 0&0076,, 4200&00 0&002+&45 0&00 0&0102+1 4200&00 0&00,5&,4 0&00 0&012+4+ 4200&00 0&0041&2, 0&00 0&01560. 4200&00 0&0047&12 0&00 0&01.266 4200&00 0&005,&02 0&00 0&020+24 4200&00 0&00
,5&,4 5&70 0&012+4+ 4200&00 2,+41&+,56&51 10&1, 0&022500 4200&00 4256,&4,
615.6&2.Co#cre*o: $= 5&65075 cm
)= 25 cmfc= 210 Kg/cm2"c= 325216&47
"= ,6,6+&.1 =3,6&,7 =
C= +&+72(cero:di (i e si F
,&4+ 10&1, 30&001+4+ 3,.+.&60 3,+50.&+717&67 5&70 0&002,16 4200&00 2,+41&+,2,&56 0&00 0&0040.+ 4200&00 0&002+&45 0&00 0&005.61 4200&00 0&00,5&,4 0&00 0&0076,, 4200&00 0&0041&2, 0&00 0&00+405 4200&00 0&0047&12 0&00 0&011177 4200&00 0&005,&02 0&00 0&012+4+ 4200&00 0&00,5&,4 5&70 0&0076,, 4200&00 2,+41&+,56&51 10&1, 0&014000 4200&00 4256,&4,
50+,.&,1Co#cre*o: $= .&476125 cm
)= 25 cmfc= 210 Kg/cm2"c= 3,7.24&71
"= 1,11,&61 =31,&11 =
C= 1,&2+6(cero:di (i e si F
,&4+ 10&1, 30&002212 34200&00 34256,&4,17&67 5&70 0&000+.7 1+74&65 11256&412,&56 0&00 0&002,16 4200&00 0&002+&45 0&00 0&00,646 4200&00 0&00,5&,4 0&00 0&004+75 4200&00 0&0041&2, 0&00 0&006,04 4200&00 0&00
-
8/15/2019 Excel para Diseño Columna
9/58
47&12 0&00 0&0076,, 4200&00 0&005,&02 0&00 0&00.+62 4200&00 0&00,5&,4 5&70 0&004+75 4200&00 2,+41&+,56&51 10&1, 0&00+750 4200&00 4256,&4,
,51+.&,4Co#cre*o: $= 11&,015 cm
)= 25 cmfc= 210 Kg/cm2"c= 3504,2&+4
"= 3152,4&61 =15&2, =
C= 16&620(cero:di (i e si F
,&4+ 10&1, 30&002,70 34200&00 34256,&4,17&67 5&70 0&0001+0 ,7+&72 2164&5.2,&56 0&00 0&00125, 2506&2+ 0&002+&45 0&00 0&002,16 4200&00 0&00,5&,4 0&00 0&00,,.0 4200&00 0&0041&2, 0&00 0&00444, 4200&00 0&0047&12 0&00 0&005506 4200&00 0&005,&02 0&00 0&006570 4200&00 0&00,5&,4 5&70 0&00,,.0 4200&00 2,+41&+,56&51 10&1, 0&007200 4200&00 4256,&4,
26106&50Co#cre*o: $= 14&126.75 cm
)= 25 cmfc= 210 Kg/cm2"c= 36,041&1.
"= 3,6+,4&6. =,6&+, =
C= 1+&+44(cero:di (i e si F
,&4+ 10&1, 30&002475 34200&00 34256,&4,17&67 5&70 30&000,42 36.,&57 3,.+6&652,&56 0&00 0&000544 10..&5. 0&002+&45 0&00 0&0014,0 2.60&72 0&00,5&,4 0&00 0&002,16 4200&00 0&0041&2, 0&00 0&00,20, 4200&00 0&0047&12 0&00 0&0040.+ 4200&00 0&005,&02 0&00 0&004+75 4200&00 0&00,5&,4 5&70 0&002,16 4200&00 2,+41&+,56&51 10&1, 0&005500 4200&00 4256,&4,
-
8/15/2019 Excel para Diseño Columna
10/58
-
8/15/2019 Excel para Diseño Columna
11/58
"c= 3100.65&.+
"= 31010.2&65 =101&0. =
C= 2+&+16
(cero:di (i e si F
,&4+ 10&1, 30&002650 34200&00 34256,&4,17&67 5&70 30&00122. 32455&71 31,++.&6.2,&56 0&00 30&0006,7 31274&2. 0&002+&45 0&00 30&000046 3+2&.5 0&00,5&,4 0&00 0&000544 10..&5. 0&0041&2, 0&00 0&0011,5 2270&01 0&0047&12 0&00 0&001726 ,451&44 0&005,&02 0&00 0&002,16 4200&00 0&00
,5&,4 5&70 0&000544 10..&5. 6205&,+56&51 10&1, 0&002667 4200&00 4256,&4,
377+,&2+Co#cre*o: $= 25&42.,75 cm
)= 25 cmfc= 210 Kg/cm2"c= 311,474&12
"= 3121267&42 =121&27 =
C= ,,&240(cero:di (i e si F
,&4+ 10&1, 30&0026.5 34200&00 34256,&4,17&67 5&70 30&001405 32.10&14 31601+&0+2,&56 0&00 30&000.7, 31746&.5 0&002+&45 0&00 30&000,42 36.,&57 0&00,5&,4 0&00 0&0001+0 ,7+&72 0&0041&2, 0&00 0&000722 144,&01 0&0047&12 0&00 0&00125, 2506&2+ 0&005,&02 0&00 0&0017.5 ,56+&5. 0&00,5&,4 5&70 0&0001+0 ,7+&72 2164&5.56&51 10&1, 0&002100 4200&00 4256,&4,
31,.54&51Co#cre*o: $= 2.&25,75 cm
)= 25 cmfc= 210 Kg/cm2"c= 31260.2&,6
"= 31,++,6&.7 =1,+&+4 =
-
8/15/2019 Excel para Diseño Columna
12/58
Cm
Kg/Cm2
o: 2.&7427
)r$o mome#*o25&25 77.4,&4211&07 265061&.+5&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&0036&60 315.0,1&.+
327&76 311.1765&073++6.+1&65
)r$o= 27&,,00125= 3,445.,&25
31,41474&+01,&41
)r$o mome#*o25&25 372.746&2011&07 265061&.+
-
8/15/2019 Excel para Diseño Columna
13/58
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 315.0,1&.+327&76 311.1765&07
31.0,4.1&2.
)r$o= 25&+17,25= 365,54,&50
32457024&7724&57
)r$o mome#*o25&25 3++760+&4111&07 265061&.+5&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&0036&60 315.0,1&.+
327&76 311.1765&0732072,44&4.
)r$o= 24&5046,75= 3+26..0&75
32+++225&242+&++
)r$o mome#*o25&25 310747,5&0.11&07 124620&075&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&00
-
8/15/2019 Excel para Diseño Columna
14/58
31.&,. 0&00324&27 0&0036&60 315.0,1&.+
327&76 311.1765&07322.++11&+7
)r$o= 2,&0+1+5= 311645+5&02
3,454506&+.,4&55
)r$o mome#*o
25&25 310747,5&0.11&07 2,+64&0+5&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&0036&60 315.0,1&.+
327&76 311.1765&0732,+0567&+5
)r$o= 21&67+2625= 31,666.6&2.
3,757254&2,,7&57
)r$o mome#*o25&25 310747,5&0.11&07 34,1,+&+05&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&0036&60 315.0,1&.+
327&76 311.1765&07
-
8/15/2019 Excel para Diseño Columna
15/58
-
8/15/2019 Excel para Diseño Columna
16/58
= 3175+222&12
34217041&5742&17
)r$o mome#*o25&25 310747,5&0.11&07 3154+7+&..5&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 340+5+&50327&76 311.1765&07
324524,+&5,
)r$o= 16&02.5125= 31.1..21&41
34271260&+442&71
)r$o mome#*o25&25 310747,5&0.11&07 3177,47&..5&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&0036&60 3142.7&57
327&76 311.1765&073244.1,5&5+
)r$o= 14&615.25= 31.427+7&70
342+0+,,&2+42&+1
-
8/15/2019 Excel para Diseño Columna
17/58
C)= ,,&2,+705..24 d= 56&51ey= 0&0021
F$--$ Fr$gi- = 2000000
2,&27 2&,2677+41
C C d11 0 01 2&,2677+41 ,5&5664.52+41, 4&65,55..2 ,7&.+,264705+4 6&+.0,,.24 40&22004411765 +&,0711765 42&546.2,52+46 11&6,,.+71 44&.7,602+4127 1,&+606765 47&200,.2,52+. 16&2.7455+ 4+&5271617647
+ 1.&6142,5, 51&.5,+41176510 20&+410147 54&1.07205..211 2,&2677+41 56&5075
Ce#*ro p-$s*iC= ,5&566(cero:di (i e si F
1 ,&4+ 10&1, 30&002705 34200&00 34256,&4,2 17&67 5&70 30&00150+ 3,01.&.2 31720.&6., 2,&56 0&00 30&00101, 32025&10 0&004 2+&45 0&00 30&000516 310,1&,7 0&005 ,5&,4 0&00 30&00001+ 3,7&65 0&006 41&2, 0&00 0&00047. +56&0. 0&007 47&12 0&00 0&000+75 1+4+&.1 0&00. 5,&02 0&00 0&001472 2+4,&5, 0&00+ ,5&,4 5&70 30&00001+ 3,7&65 3214&60
10 56&51 10&1, 0&001766 ,5,2&71 ,5.01&013241.5&6.
Co#cre*o: $= ,0&2,15125 cm)= 25 cm
fc= 210 Kg/cm2"c= 31,4+0.&12
"= 315+0+,&.1 =15+&0+ =
C= ,7&.+,(cero:
-
8/15/2019 Excel para Diseño Columna
18/58
di (i e si F,&4+ 10&1, 30&00272, 34200&00 34256,&4,
17&67 5&70 30&001601 3,201&.. 31.252&172,&56 0&00 30&0011,5 3226+&17 0&002+&45 0&00 30&00066. 31,,6&46 0&00,5&,4 0&00 30&000202 340,&75 0&00
41&2, 0&00 0&000264 52.&+5 0&0047&12 0&00 0&0007,1 1461&66 0&005,&02 0&00 0&0011+7 2,+4&,7 0&00,5&,4 5&70 30&000202 340,&75 32,01&5+56&51 10&1, 0&001474 2+47&,7 2+.6+&07
3,,24.&11Co#cre*o: $= ,2&20+275 cm
)= 25 cmfc= 210 Kg/cm2"c= 314,7,,&.+
"= 3176+.2&00 =176&+. =
C= 40&220(cero:di (i e si F
,&4+ 10&1, 30&0027,+ 34200&00 34256,&4,17&67 5&70 30&0016.2 3,,6,&75 31+174&+,2,&56 0&00 30&00124, 324.5&00 0&002+&45 0&00 30&000.0, 31606&25 0&00,5&,4 0&00 30&000,64 3727&50 0&0041&2, 0&00 0&000076 151&24 0&0047&12 0&00 0&000515 102+&++ 0&005,&02 0&00 0&000+54 1+0.&74 0&00,5&,4 5&70 30&000,64 3727&50 34147&1156&51 10&1, 0&001215 242+&75 2462,&47
341262&00Co#cre*o: $= ,4&1.70,75 cm
)= 25 cmfc= 210 Kg/cm2
"c= 315255+&65
"= 31+,.21&65 =1+,&.2 =
C= 42&547(cero:di (i e si F
-
8/15/2019 Excel para Diseño Columna
19/58
,&4+ 10&1, 30&002754 34200&00 34256,&4,17&67 5&70 30&001754 3,507&+2 31+++6&772,&56 0&00 30&001,,+ 32677&2, 0&002+&45 0&00 30&000+2, 31.46&54 0&00,5&,4 0&00 30&00050. 31015&.4 0&0041&2, 0&00 30&0000+, 31.5&15 0&00
47&12 0&00 0&000,2, 645&54 0&005,&02 0&00 0&0007,. 1476&2, 0&00,5&,4 5&70 30&00050. 31015&.4 357+0&7.56&51 10&1, 0&000+.4 1+6.&75 1++51&61
34.,++&,7Co#cre*o: $= ,6&164. cm
)= 25 cmfc= 210 Kg/cm2"c= 3161,.5&42
"= 320+7.4&7+ =20+&7. =
C= 44&.74(cero:di (i e si F
,&4+ 10&1, 30&002767 34200&00 34256,&4,17&67 5&70 30&001.1+ 3,6,7&14 3207,,&,72,&56 0&00 30&001425 32.4+&52 0&002+&45 0&00 30&0010,1 32061&+0 0&00,5&,4 0&00 30&0006,7 31274&2. 0&0041&2, 0&00 30&00024, 34.6&66 0&0047&12 0&00 0&000150 ,00&+6 0&005,&02 0&00 0&000544 10..&5. 0&00,5&,4 5&70 30&0006,7 31274&2. 3726,&++56&51 10&1, 0&00077. 1555&56 15764&2,
3547+6&56Co#cre*o: $= ,.&1425625 cm
)= 25 cmfc= 210 Kg/cm2"c= 3170211&1+
"= 3225007&75 =225&01 =
C= 47&200(cero:di (i e si F
,&4+ 10&1, 30&00277. 34200&00 34256,&4,
-
8/15/2019 Excel para Diseño Columna
20/58
17&67 5&70 30&001.77 3,75,&62 321,+7&,62,&56 0&00 30&001502 3,004&., 0&002+&45 0&00 30&00112. 32256&0, 0&00,5&,4 0&00 30&000754 31507&24 0&0041&2, 0&00 30&000,7+ 375.&45 0&0047&12 0&00 30&000005 3+&65 0&00
5,&02 0&00 0&000,70 7,+&14 0&00,5&,4 5&70 30&000754 31507&24 3.5+1&+656&51 10&1, 0&0005+2 11.,&10 11+.+&70
36056,&05Co#cre*o: $= 40&120,25 cm
)= 25 cmfc= 210 Kg/cm2"c= 317+0,6&+5
"= 32,+600&00 =
2,+&60 =
C= 4+&527(cero:di (i e si F
,&4+ 10&1, 30&0027.. 34200&00 34256,&4,17&67 5&70 30&001+,0 3,.5+&15 321++.&+52,&56 0&00 30&00157, 3,145&54 0&002+&45 0&00 30&001216 324,1&+2 0&00,5&,4 0&00 30&000.5+ 3171.&,1 0&0041&2, 0&00 30&000502 31004&6+ 0&0047&12 0&00 30&000146 32+1&0. 0&005,&02 0&00 0&000211 422&54 0&00,5&,4 5&70 30&000.5+ 3171.&,1 3+7+5&1556&51 10&1, 0&00042, .45&64 .56+&.2
3657.7&71Co#cre*o: $= 42&0+.0.75 cm
)= 25 cmfc= 210 Kg/cm2"c= 31.7.62&72
"= 325,650&4, =25,&65 =
C= 51&.54(cero:di (i e si F
,&4+ 10&1, 30&0027+. 34200&00 34256,&4,17&67 5&70 30&001+7. 3,+55&22 322546&56
-
8/15/2019 Excel para Diseño Columna
21/58
2,&56 0&00 30&0016,7 3,27,&62 0&002+&45 0&00 30&0012+6 325+2&0, 0&00,5&,4 0&00 30&000+55 31+10&44 0&0041&2, 0&00 30&000614 3122.&.4 0&0047&12 0&00 30&000274 3547&25 0&005,&02 0&00 0&000067 1,4&,5 0&00
,5&,4 5&70 30&000+55 31+10&44 310.+0&,656&51 10&1, 0&00026+ 5,.&46 5456&.5
37054,&50Co#cre*o: $= 44&075.5 cm
)= 25 cmfc= 210 Kg/cm2"c= 31+66..&4.
"= 32672,1&+. =267&2, =
C= 54&1.1(cero:di (i e si F
,&4+ 10&1, 30&002.07 34200&00 34256,&4,17&67 5&70 30&002022 3404,&0, 32,047&1,2,&56 0&00 30&0016+5 3,,+0&71 0&002+&45 0&00 30&001,6+ 327,.&,. 0&00,5&,4 0&00 30&00104, 320.6&06 0&0041&2, 0&00 30&000717 314,,&74 0&0047&12 0&00 30&000,+1 37.1&42 0&005,&02 0&00 30&000065 312+&0+ 0&00,5&,4 5&70 30&00104, 320.6&06 311.+1&5156&51 10&1, 0&00012+ 257&67 2611&25
374.+0&.2Co#cre*o: $= 46&05,6125 cm
)= 25 cmfc= 210 Kg/cm2"c= 3205514&25
"= 32.0405&06 =
2.0&41 =
C= 56&50.(cero:di (i e si F
,&4+ 10&1, 30&002.15 34200&00 34256,&4,17&67 5&70 30&002062 3412,&61 32,506&4.2,&56 0&00 30&00174+ 3,4+.&15 0&00
-
8/15/2019 Excel para Diseño Columna
22/58
2+&45 0&00 30&0014,6 32.72&6+ 0&00,5&,4 0&00 30&001124 32247&22 0&0041&2, 0&00 30&000.11 31621&76 0&0047&12 0&00 30&0004+. 3++6&,0 0&005,&02 0&00 30&0001.5 3,70&.4 0&00,5&,4 5&70 30&001124 32247&22 312.10&21
56&51 10&1, 0&000000 0&00 0&0037...0&12
Co#cre*o: $= 4.&0,1,75 cm)= 25 cmfc= 210 Kg/cm2"c= 3214,40&01
"= 32+,220&1, =2+,&22 =
-
8/15/2019 Excel para Diseño Columna
23/58
Cm
Kg/Cm2
o: 2.&7427
)r$o mome#*o25&25 310747,5&0.11&07 31+0517&.2
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 1416&47327&76 3++400.&00
32257.44&4,
)r$o= 1,&626+4,75= 31.,.,.5&42
340+622+&.640&+6
-
8/15/2019 Excel para Diseño Columna
24/58
)r$o mome#*o25&25 310747,5&0.11&07 3202070&40
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 151+1&+4327&76 3.2+,0.&.2
320+0+22&,6
)r$o= 12&6,.0625= 31.16517&..
3,+07440&24,+&07
)r$o mome#*o25&25 310747,5&0.11&07 32122.6&,2
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 27,7,&55327&76 36.,665&74
31+4,,1,&5.
)r$o= 11&64+1.125
= 317771+5&07
3,72050.&65,7&21
)r$o mome#*o
-
8/15/2019 Excel para Diseño Columna
25/58
25&25 310747,5&0.11&07 3221,.4&.7
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&00
31.&,. 0&00324&27 0&00
36&60 ,.222&.0327&76 355,+52&,.
31.11.4+&52
)r$o= 10&660,= 31720416&++
3,5,2266&51,5&,2
)r$o mome#*o25&25 310747,5&0.11&07 322+5,+&.7
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 47+46&+5327&76 34,76+0&77
316+401.&76
)r$o= +&67141.75= 316461.,&65
3,,40202&41,,&40
)r$o mome#*o25&25 310747,5&0.
-
8/15/2019 Excel para Diseño Columna
26/58
11&07 32,6.+0&.55&1. 0&00
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00
324&27 0&0036&60 56712&,7
327&76 3,,2.+1&57315.7.05&1,
)r$o= .&6.25,75= 315544+5&0,
3,142,00&16
,1&42
)r$o mome#*o25&25 310747,5&0.11&07 324,551&14
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 64654&20327&76 32,7+,+&2.
314+1571&2+
)r$o= 7&6+,65625= 31445,51&16
32+,6+22&452+&,7
)r$o mome#*o25&25 310747,5&0.11&07 324+61,&71
-
8/15/2019 Excel para Diseño Columna
27/58
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 71..,&,0327&76 315150.&,4
3140,+7,&.,
)r$o= 6&704775= 31,1.752&01
32722725&.427&2,
)r$o mome#*o25&25 310747,5&0.11&07 3255155&57
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 7.4+1&4+327&76 372500&+2
31,2,+00&0.
)r$o= 5&715.+,75= 311746+7&5+
324+.5+7&67
24&++
)r$o mome#*o25&25 310747,5&0.11&07 3260241&04
5&1. 0&00
-
8/15/2019 Excel para Diseño Columna
28/58
30&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 .4555&4.
327&76 0&0031250420&6,
)r$o= 4&7270125= 3101,1.7&+1
3226,60.&5422&64
-
8/15/2019 Excel para Diseño Columna
29/58
C)= ,,&2,+705..24 d= 56&51ey= 0&0021
F$--$ Fr$gi- = 2000000
2,&27 2&,2677+41
C C d11 0 01 2&,2677+41 ,5&5664.52+41, 4&65,55..2 ,7&.+,264705+4 6&+.0,,.24 40&22004411765 +&,0711765 42&546.2,52+46 11&6,,.+71 44&.7,602+4127 1,&+606765 47&200,.2,52+. 16&2.7455+ 4+&5271617647
+ 1.&6142,5, 51&.5,+41176510 20&+410147 54&1.07205..211 2,&2677+41 56&5075
Ce#*ro p-$s*iC= ,,&240(cero:di (i e si F
1 ,&4+ 10&1, 30&0026.5 34200&00 34256,&4,2 17&67 5&70 30&001405 32.10&14 31601+&0+, 2,&56 0&00 30&000.7, 31746&.5 0&004 2+&45 0&00 30&000,42 36.,&57 0&005 ,5&,4 0&00 0&0001+0 ,7+&72 0&006 41&2, 0&00 0&000722 144,&01 0&007 47&12 0&00 0&00125, 2506&2+ 0&00. 5,&02 0&00 0&0017.5 ,56+&5. 0&00+ ,5&,4 5&70 0&0001+0 ,7+&72 2164&5.
10 56&51 10&1, 0&002100 4200&00 4256,&4,31,.54&51
Co#cre*o: $= 2.&25,75 cm)= 25 cm
fc= 210 Kg/cm2"c= 31260.2&,6
"= 31,++,6&.7 =1,+&+4 =
-
8/15/2019 Excel para Diseño Columna
30/58
-
8/15/2019 Excel para Diseño Columna
31/58
-
8/15/2019 Excel para Diseño Columna
32/58
-
8/15/2019 Excel para Diseño Columna
33/58
-
8/15/2019 Excel para Diseño Columna
34/58
-
8/15/2019 Excel para Diseño Columna
35/58
Cm
Kg/Cm2
o: 2.&7427
)r$o mome#*o25&25 310747,5&0.11&07 3177,47&..
5&1. 0&0030&71 0&0036&60 0&00
312&4+ 0&0031.&,. 0&00324&27 0&00
36&60 3142.7&57327&76 311.1765&07
3244.1,5&5+
)r$o= 14&615.25= 31.427+7&70
342+0+,,&2+42&+1
-
8/15/2019 Excel para Diseño Columna
36/58
-
8/15/2019 Excel para Diseño Columna
37/58
-
8/15/2019 Excel para Diseño Columna
38/58
-
8/15/2019 Excel para Diseño Columna
39/58
-
8/15/2019 Excel para Diseño Columna
40/58
-
8/15/2019 Excel para Diseño Columna
41/58
'(B( 89N
" " F0 400&76071, 400&76071, 0
10 22&64 2+,&22 2+,&22012. 15&.4525+.
+ 24&++ 2.0&41 2.0&405062 17&4+01.,7. 27&2, 267&2, 267&2,1+.2 1+&05+0.0+7 2+&,7 25,&65 25,&65042+ 20&55.45716 ,1&42 2,+&60 2,+&5++++6 21&++610115 ,,&40 225&01 225&007746 2,&,.1416+4 ,5&,2 20+&7. 20+&7.47.6 24&725.656, ,7&21 1+,&.2 1+,&.21654 26&04,56062 ,+&07 176&+. 176&+.2005 27&,520.171 40&+6 15+&0+ 15+&0+,.0+ 2.&67,60+
B 42&+1 1,+&+4 1,+&+,6.7, ,0&0,65,,1
+ 42&71 121&27 121&267416 2+&.+..266. 42&17 101&0. 101&0.265, 2+&51+2+17 41&2+ 7.&7, 7.&7,,1676 2.&+01154,6 ,+&+1 55&60 55&6041,,4 27&+,57.555 ,7&57 ,6&+, ,6&+,4675. 26&,0077+64 ,4&55 15&2, 15&2,46072 24&1.154.+, 2+&++ 31,&11 0 20&++457672 24&57 3,6&,7 0 17&1++17,41 1,&41 3.0&+2 0 +&,+0,24,
cierre 0 0 0
#e$0 0
,0&0,65,,1 +7&+55.114
0 5 10 150
50
100
150
200
250
,00
M &tn'm(
)&Tn(
-
8/15/2019 Excel para Diseño Columna
42/58
2,.&452624
F"2.0&5,24++ 2,.&452624205&2540+ 205&2540+
1+6&2.,54, 1+6&2.,54,1.7&062,.7 1.7&062,.7
177&555, 177&555,167&71+++7 167&71+++7157&505422 157&505422146&.4+,5 146&.4+,5
1,5&67515. 1,5&67515.12,&..740, 12,&..740,111&,65666 111&,65666+7&+55.114 +7&+55.114
.4&..71+11 .4&..71+1170&757.56+ 70&757.56+55&11,217, 55&11,217,,.&+22.+,4 ,.&+22.+,425&.5427, 25&.5427,
10&6642251 10&66422510 00 00 00 0
20 25 ,0 ,5
*er$ccio# F$c*or$do
i#e$
-
8/15/2019 Excel para Diseño Columna
43/58
C9;( de '(CC
-
8/15/2019 Excel para Diseño Columna
44/58
8*ory Co-um# o$d oc " ;28'
-
8/15/2019 Excel para Diseño Columna
45/58
;, ' 2 , 34&2. 0 34&001 30&0, 4&00134&2. 0 1&,44 0&01+ 1&,4434&2. 0 6&6+ 0&06. 6&6+3,&47 0&006 32&+7, 0&474 2&+7,3,&47 0&006 1&,7 0&0+. 1&,7
3,&47 0&006 5&71. 0&,+6 5&71.3,&7+ 30&005 3,&.22 30&526 ,&.223,&7+ 30&005 0&+1, 30&065 0&+1,3,&7+ 30&005 5&644 30&27+ 5&64431&7 0&074 1&.2 0&457 1&.231&7 0&074 ,&+54 0&0+. ,&+5431&7 0&074 6&147 0&,7. 6&147
35&56 30&07, 3.&614 30&50+ .&61435&56 30&07, 31&671 30&066 1&67135&56 30&07, 5&214 30&261 5&214
30&06 0&074 ,&,6 0&46. ,&,630&06 0&074 ,&4,. 0&0+1 ,&4,.30&06 0&074 ,&575 0&,5, ,&5753,&+1 30&07, 37&074 30&4+. 7&0743,&+1 30&07, 32&1.7 30&072 2&1.73,&+1 30&07, 2&642 30&2.5 2&64231&., 0&006 31&4,, 0&4.5 1&4,,31&., 0&006 0&.54 0&0+1 0&.5431&., 0&006 ,&145 0&,71 ,&14532&14 30&006 32&2.2 30&515 2&2.232&14 30&006 0&,+7 30&072 0&,+732&14 30&006 ,&071 30&,0, ,&071
-
8/15/2019 Excel para Diseño Columna
46/58
"101&05100&42
++&7+.,&+5.,&,+
.2&.,
.+&0,
..&47
.7&+1
.,&45
.2&.+
.2&,2
.+&54
..&+7
..&41
46&746&2+45&.+52&7+52&,.51&+747&246&.
46&,+52&2.51&..51&47
-
8/15/2019 Excel para Diseño Columna
47/58
*O+A DE METRADOS DE ESTRUCTURAS
)ro,ecto "" (
-
8/15/2019 Excel para Diseño Columna
48/58
Total m2 !"00
00! Muro de contension
@escripciE#& C$#*& Co#cre*o m,
$rgo (#co (-*ur$ 8u)*o*$-& C$#*
131 1 ,7&56 0&25 ,&05 2.&64 2
232 1 50&44 0&20 ,&70 ,7&,, 2
Total m2 3456
002 Columnas
@escripciE#& C$#*& Co#cre*o m,
$rgo (#co (-*ur$ 8u)*o*$-& C$#*
C31 14 ,&24 0&25 0&,5 ,&+7 14
14
14
C32 14 6&70 0&25 0&,5 .&21 1414
14
Total m2 "!"#
00 7i8as
@escripciE#& C$#*& Co#cre*o m,
-
8/15/2019 Excel para Diseño Columna
49/58
$rgo (#co (-*ur$ 8u)*o*$-& C$#*
"
-
8/15/2019 Excel para Diseño Columna
50/58
#cofr$do m2 (cero "ie$ o#g o#g
$rgo (-*/(#c& 8u) *o*$-& e-em& pie$ 'o*$-
25&00 150&00 ,/4GG 12 1&50 1.
20&00 105&00 1/2GG 7 1&05 7&,5c
10&00 1+.&00 ,/.GG 7 1&+. 1,&.6
c
10&00 2.0&00 ,/.GG . 2&.0 22&4
25&00 170&00 ,/.GG 12 1&70 20&4
25&00 150&00 ,/4GG 12 1&50 1.
20&00 125&00 1/2GG 7 1&25 .&75
c
10&00 270&00 ,/.GG 7 2&70 1.&+
c
10&00 ,60&00 ,/.GG 7 ,&60 25&2
25&00 170&00 ,/.GG 12 1&70 20&4
-
8/15/2019 Excel para Diseño Columna
51/58
m! ":56#00
#cofr$do m2 (cero "ie$ o#g o#g
$rgo (-*/(#c& 8u) *o*$-& e-em& pie$ 'o*$-
,7&56 ,&05 22+&12 5/.GG 1.7&. ,&+5 741&.1
1/2GG 1.7&. ,&+5 741&.1
1/2GG 26 ,.&06 +.+&56
50&44 ,&05 ,07&6. 1/2GG 252&2 4&50 11,4&+
1/2GG 252&2 4&50 11,4&+
,/.GG ,0 50&+4 152.&2
m! 423#0
#cofr$do m2 (cero "ie$ o#g o#g
$rgo (-*/(#c& 8u) *o*$-& e-em& pie$ 'o*$-
,&24 1&20 54&4, 1/2GG 6 4&22 ,54&4.
,/.GG 26 0&70 254&.
,/.GG 26 0&70 254&.
6&70 1&20 112&56 1/2GG 6 7&56 6,5&04 ,/.GG 52 0&70 50+&6
,/.GG 52 0&70 50+&6
m! "3355
#cofr$do m2 (cero "ie$ o#g o#g
-
8/15/2019 Excel para Diseño Columna
52/58
$rgo (-*/(#c& 8u) *o*$-& e-em& pie$ 'o*$-
2&00 0&,0 111&44 1/2GG 2 5&76 161&2.
1/2GG 2 5&76 161&2.
,/.GG 40 1&20 672
,/.GG 5 2&,5 164&5
2&25 11,&4+ 5/.GG 4 50&+4 20,&76
,/.GG . 50&+4 407&52
,/.GG ,,6&2666666667 1&70 571&65,,,,,,,,
,/.GG ,,6&2666666667 2&,1 776&776
m! !!52
#cofr$do m2 (cero "ie$ o#g o#g
$rgo (-*/(#c& 8u) *o*$-& e-em& pie$ 'o*$-
60 5&57 ,,4&2 5/.GG 16&00 60&25 +64&00
,/.GG ,4&00 60&25 204.&50
,/.GG 400&00 1&60 640&00
1/4GG 400&00 2&15 .60&00
m! 22!0
-
8/15/2019 Excel para Diseño Columna
53/58
F$c*or
*o*$-
Kg
";
-
8/15/2019 Excel para Diseño Columna
54/58
-
8/15/2019 Excel para Diseño Columna
55/58
";
-
8/15/2019 Excel para Diseño Columna
56/58
2;
-
8/15/2019 Excel para Diseño Columna
57/58
-
8/15/2019 Excel para Diseño Columna
58/58
2;