excel para diseño columna

Upload: oscar

Post on 05-Jul-2018

225 views

Category:

Documents


1 download

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;