Download - Excel diseño de Platea
-
7/23/2019 Excel diseo de Platea
1/120
Mdulo de Balastro o Mdulo de Winkler (K30)
P = 1 TnA = 1 m2
K30 = 39.37007874 Tn/m3
Mdulo de Balastro segn tipo de suelo
Tabla 1
Clase de Suelo Coefciene de
#alo $%&' 0.( ) 1.0 K*/m#edio $A"cillas +,medas' 2.0 ) -.0 K*/m
!ueno $A"enas' 7.0 ) 10.0 K*/!ueno $"aas' 10.0 ) 17.0 K*
Tabla 2
Clase de Suelo
Suelo li*e"o de u"ba cene*osoSuelo esado de u"ba cene*osoA"ena fna de "ibe"aCaas de +umus a"ena *"aa
Tie""a a"cillosa moadaTie""a a"cillosa +,medaTie""a a"cillosa secaTie""a a"cillosa seca du"a&umus f"memene es"aifcado con a"ena ocas iedas&umus f"memene es"aifcado con a"ena muc+as ied"as"aa fna muc+a a"ena fna"aa media a"ena fna"aa media a"ena *"uesa"aa *"uesa a"ena *"uesa
Dimensionamiento
eseso" = 1.05 m$emea" con 1/10 de la lu mao"'
K30 = 10000 Tn/m35a = 2-.4 Tn/m2 Tio Suelo = "anula"5n = 23.7- Tn/m2
=
-
7/23/2019 Excel diseo de Platea
2/120
5u = 3(.-4 Tn/m2c = 210 K*/cm2 Si 1.7(/ := ;sacio en"e ees de columna;c = 217370-.(1193 Tn/m3 Si 1.7(/ > ;sacio en"e ees de columnaslulo del diagrama de presiones de 4!V"$
D@-@
!/#o?R#e?R#s?RMA/#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-Puno 2 0 11.-
Puno 3 0 0Puno 4 1-.- 0
r>Co del diagrama de presiones en 3
J 0 11.-0 )9.-493-(29 )4.-((94-798
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
83/120
1-.- )12.7(02((94 )7.7(-8374(2
D@-@@0.94!/
#o?R#e?R#s?RMA/#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J '/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
84/120
J Puno 1 1-.- 11.-Puno 2 0 11.-Puno 3 0 0
Puno 4 1-.- 0
r>Co del diagrama de presiones en 3
J 0 11.-0 )3.7727((472 1.0123279(2
1-.- )18.418(30-9 )13.-3344727
#o?R#e?R#s?RMA/
#oR#eR#sR
J M2/1-.-
11.-A $m2'
= =
-
7/23/2019 Excel diseo de Platea
85/120
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J
Puno 1 1-.- 11.-Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
r>Co del diagrama de presiones en 3
J 0 11.-0 )1(.(2(97(11 )10.324221((
1-.- )7.081981193 )1.880227-34
'/$2 ' '/$2 '/ ( ( '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
86/120
D@-@@0.94!/
#o?R#e?R#s?RMA/
#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'4421.819
J
J Puno 1 1-.- 11.-Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
r>Co del diagrama de presiones en 3
J 0 11.-0 )1.(3949(991 )12.712-3287
1-.- )4.-93(73199 )1(.8--71007
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
87/120
#o?R
#e?R#s?RMA/#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-Puno 2 0 11.-
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
88/120
Puno 3 0 0Puno 4 1-.- 0
r>Co del diagrama de presiones en 3
J 0 11.-0 )17.7(9234(9 3.40073927
1-.- )20.80-938-9 0.3(303(171
$>lulo del diagrama de presiones ltimas
1.; @ 1.8!/
#o?R#e?R#s?RMA/#oR
#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0 '/$2 '=/ ( ( '/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
89/120
G? $m4'21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-
Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
1.5 @ 4A!/
#o?R#e?R#s?RMA/#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0
G? $m4'21(9.239G $m4'
4421.819
'/$2 ' '/$2 '/ ( ( '/$2 ' '/$2 '/ ( (
'/$2 '=/ ( ( '/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
90/120
J
J Puno 1 1-.- 11.-Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
1.5 6 4A!/
#o?R#e?R#s?RMA/#oR#eR#sR
J M2/1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-
'/$2 ' '/$2 '/ ( ( '/$2 ' '/$2 '/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
91/120
Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
1.5 @ 42!/
#o?R#e?R#s?RMA/#oR#eR#sR
J M2/
1-.-11.-
A $m2'192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-
Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
1.5 6 42!/
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
92/120
#o?R#e?R#s?RMA/#oR#eR
#sRJ M2/
1-.-
11.-A $m2'
192.(-0G? $m4'
21(9.239G $m4'
4421.819
J
J Puno 1 1-.- 11.-Puno 2 0 11.-Puno 3 0 0Puno 4 1-.- 0
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
'/$2 ' '/$2 '/ ( (
'/$2 '=/ ( (
-
7/23/2019 Excel diseo de Platea
93/120
" (?s)
61785.97:,n98(.07 Tn.m
)((.(911-Tn.m0 Tn.m
::.;9 ,n.m873.13 Tn.m)47.14 Tn.m
0 Tn.m97.00 ,n.m
5u $Tn/m2' Si*no ;sue"o6;.755:;78:95 Com"esin Cumle con 5neo68.857938;519 Com"esin Cumle con 5neo
6:.7;:375:0 Com"esin Cumle con 5neo61.85055:;35 Com"esin Cumle con 5neo
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
94/120
61785.97:,n9((.93 Tn.m
)((.(911-Tn.m)9.-3332Tn.m9:0.80 ,n.m3948.40Tn.m
)47.14 Tn.m0 Tn.m
3:01.7,n.m
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
95/120
5u $Tn/m2' Si*no ;sue"o1.0138:519 T"accin mena" a?ial ce"ca a ese u613.733;;88 Com"esin Cumle con 5neo63.88855;8 Com"esin Cumle con 5neo
619.;195307:39 Com"esin Cumle con 5neo
61785.97:,n1014.22Tn.m
)((.(911-Tn.m9.-3332Tn.m:79.7 ,n.m
)2202.13Tn.m)47.14 Tn.m
0 Tn.m6;:.8,n.m
-
7/23/2019 Excel diseo de Platea
96/120
5u $Tn/m2' Si*no ;sue"o
610.3;15;98 Com"esin Cumle con 5neo61.99087335 Com"esin Cumle con 5neo615.55:851095 Com"esin Cumle con 5neo68.091:911:33 Com"esin Cumle con 5neo
= '/$2 ' '/$2 '/ ( (
# #?)@
= '/$2 ' '/$2 '/ ( (
# #?)@
-
7/23/2019 Excel diseo de Platea
97/120
61785.97:5 ,n)2024.19Tn.m
)((.(911-Tn.m0 Tn.m
608:.89,n.m
891.-3 Tn.m)47.14 Tn.m
)4.33048Tn.m9;0.18 ,n.m
5u $Tn/m2' Si*no ;sue"o61.8173977: Com"esin Cumle con 5neo615.97781008;; Com"esin Cumle con 5neo61.53:;:5::13 Com"esin Cumle con 5neo6;.7:35831:98 Com"esin Cumle con 5neo
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
98/120
-
7/23/2019 Excel diseo de Platea
99/120
618.85:3;59: Com"esin Cumle con 5neo60.907:39799; Com"esin Cumle con 5neo
(?u)
6;1:.8;7,n1212.29Tn.m
)((.(911-Tn.m0 Tn.m
1157.80,n.m9-7.87 Tn.m
)47.14 Tn.m0 Tn.m
:0.83 ,n.m
'/$2 ' '/$2 '
-
7/23/2019 Excel diseo de Platea
100/120
5u $Tn/m2' Si*no ;sue"o68.8309:0:395 Com"esin Cumle con 5neo
611.198;15598 Com"esin Cumle con 5neo613.:;;:7:1;3 Com"esin Cumle con 5neo618.;01;:3889 Com"esin Cumle con 5neo
60:;.9375 ,n973.88 Tn.m
)((.(911-Tn.m)12.041-(Tn.m
:07.; ,n.m47(7.99Tn.m
)47.14 Tn.m0 Tn.m
;810.97,n.m
= '/$2 ' '/$2 '/ ( (
# #?)@
= '/$2 ' '/$2 '/ ( (
# #?)@
'/$2 '
# #?)@
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
101/120
5u $Tn/m2' Si*no ;sue"o0.3:8:55;389 T"accin mena" a?ial ce"ca a ese u
618.9813583 Com"esin Cumle con 5neo6;.;80783037 Com"esin Cumle con 5neo6.155807798 Com"esin Cumle con 5neo
60:;.9375 ,n
104-.74Tn.m)((.(911-Tn.m12.041-(Tn.m1003.1:,n.m)2930.17Tn.m
)47.14 Tn.m0 Tn.m
6:88.30,n.m
5u $Tn/m2' Si*no ;sue"o613.88831;38: Com"esin Cumle con 5neo
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
102/120
6.5:55:9:918 Com"esin Cumle con 5neo61:.171519;: Com"esin Cumle con 5neo
68.:9501:3:3 Com"esin Cumle con 5neo
60:;.93775 ,n)27(1.27Tn.m
)((.(911-Tn.m0 Tn.m
6907.97,n.m937.03 Tn.m)47.14 Tn.m
)(.4131 Tn.m99;.;: ,n.m
5u $Tn/m2' Si*no ;sue"o617.859;55958 Com"esin Cumle con 5neo
60.08980039 Com"esin Cumle con 5neo61.78:05:58 Com"esin Cumle con 5neo6;.:::50:3::9 Com"esin Cumle con 5neo
60:;.93595 ,n
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
103/120
4771.89Tn.m)((.(911-Tn.m
0 Tn.m;817.30,n.m
890.79 Tn.m)47.14 Tn.m
(.4131 Tn.m9;:.08 ,n.m
5u $Tn/m2' Si*no ;sue"o3.393;7:5955 T"accin mena" a?ial ce"ca a ese u0.1:5:8:538 in< aumena" mena" a?ial ce"ca a ese u
61.:5387001 Com"esin Cumle con 5neo65.1;11771: Com"esin Cumle con 5neo
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
= '/$2 ' '/$2 '/ ( (
'/$2 '
# #?)@
-
7/23/2019 Excel diseo de Platea
104/120
= '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
105/120
D@[email protected]@-@@0.94D@[email protected]
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
106/120
D@-@@0.94D@[email protected]
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
107/120
-
7/23/2019 Excel diseo de Platea
108/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
109/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
110/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
111/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
112/120
-
7/23/2019 Excel diseo de Platea
113/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
114/120
= '/$2 ' '/$2 '/ ( ( = '/$2 ' '/$2 '/ ( (
-
7/23/2019 Excel diseo de Platea
115/120
"nterpolain de ?u en #ranEas en
5u1R )7.73089094Tn/m25u2R )11.18741(-Tn/m3
1 2 3 45u )7.73089094 69.3;07195 6:.7751::1 610.:;1;J 0 2.9 9.2 1(.27
5u3R )13.9449-91Tn/m2
5u4R )17.4014938Tn/m3
22 23 24 2(5u )13.9449-91 61;.597805 615.:909 617.79308J 0 2.9 9.2 12.37
1- 19 215u )12.8(77719 617.05751)1-.31(2282
J 0 14.4( 1(.-2
"nterpolain de ?u en #ranEas en
5u3R )13.9449-91Tn/m25u1R )7.73089094Tn/m3
1 - 11 1-5u )7.73089094 69.;3:800: 610.91771 61.95888J 0 1.33 (.79 9.-2
5u4R )17.4014938Tn/m25u2R )11.18741(-Tn/m3
( 10 1( 20
-
7/23/2019 Excel diseo de Platea
116/120
5u )11.18741(- 611.9:5719 61;.80;:3 615.91;7:;J 0 1.33 (.79 8.-9
-
7/23/2019 Excel diseo de Platea
117/120
1.; @ 1.8
?1 F2.9 -.3
1.33(
)11.18741(-1-.44 4.4-
3.83
2- 27618.1;597)17.40149377
14.4( 1(.-2 2.04
2.9 -.3?3 F
D@ALIAJ1J2J3J4
22 1)13.9449-91 2
11.-- 34
21 27
1 2
- 7
11 12
1- 17
22 23
J1
J2
J3
J4
1 2
-
7/23/2019 Excel diseo de Platea
118/120
617.3159)17.401493779.-3 11.-7
-
7/23/2019 Excel diseo de Platea
119/120
? F-.07 1.17
1.33
4.4-
2.9
0.94
2.04
3.17 2.08 1.17?; F
)9.81340-39)11.3((-0-1)13.4398928)14.88(324-)11.1(079-)12.14333-4)13.8-(2002)13.49994(7
3 4 (
8 9 10
13 14
18 19
24 27
1(
2-2(
20
21
3 4
-
7/23/2019 Excel diseo de Platea
120/120