Design of Abutment excel sheet

DESIGN OF GRAVITY TYPE ABUTMENT (Rocker Side) NAME OF WORK :- Constrction o! G"#"$ %rid#e %rid#e o&er o&er Si$ ri&er 

SPAN

::(ECK 'E)E' :C'EAR CARR*A+EWAY :,.F.'. :'.W.'. :M.S.'. :FON(*N+ 'E)E' :SAFE /EAR*N+ CAPAC*TY:CAPAC*TY:-

25 Mtr. !x " r %r %r 1424 Mtr. 4.25 Mtr. .45 Mtr. 0 Mtr. 0 Mtr. 1410.45 Mtr. 25 T&M2

INPUT DATA '

' / , 91

5.15 8. 13.55 1.84

S.Str.('.R%tt6 MA. '.'t6 M# '.'. t6 ,x!rl6 t6

92 93 94 95 9; 90,t !< '' Sr9r"%6 1 2 3 4 5 '1 '2 =!%<< !< t#>% E.P.6 ?1#t @t. /%$ l!= 6 ?2#t @t t%t6 ?3W t $#<< t.%rt96 ?4#t @t !< %rt96 tB ; t1 ?5W t $#<< A sl %rt96

0.5 ,# !rl6 .21 ,x s%#s#6 0.3 ,# s%#s#6 11.55 C!%<< !< %rs6 1.2 S. S./.C.T&M26 2.7 0.3 1.2 3 1.7 0.475 2 0.235 2.4 2.2 0.4 1.8 0.32 B 0.7;3  A"l% !< #t%rl Fr#. 0.3 0.;

 

0.00 40.55 .45 7.235 8.85;5 24.;7;5 23.744 0.5 F!r 9%= "#st sl#$#" 0.825 25

17.5 0.31 35 0.;1

.1.

OUTPUT DATA ' De"d o"d O! S%Strctre' S%Strctre'

(%sr#t#! 1APP. S'A/ 2 (*RT WA'' 3 /E( /'OCK 4.At%t. 5 $! ; $! 7 @#" @ll 8 $!  $! 10 $!

W t.t6 2.;535; ;.82272 .27 15;.524 15;.524 25.;1301 4.72473 2.40084 1.18871 0.735;8

NORMA' CASE. '.A. DT!%6 Mt. t-6 7.55 20.03438 ;.05 41.2774; 5.45 50.5215 5.45 853.0555 3.71 580.703 7.01 181.;21 8.00 37.8403; 7.55 18.12;34 8.00 .52037; 7.55 5.55;55;

SE*SM*C CASE. W t. t6 'A D/s% 0.2;535; 13.355 0.;82272 12.;3 0.27 11.4; 15.;524 ;.;05 15.;524 5.033 2.5;1301 5.033 0.472473 ;.;05 0.240084 12.38 0.118871 5. 5 .7;2;11;7 0.07357 11.8535

Mt. t-6 3.5438238 8.;17053; 10.;2342 103.3840; 78.8771141 12.071;41 3.120;841; 2.72232 0.;8500723 0.872373;

13 $! 14 Ert9 15 ).C!. Ert9 TOTA'

30.2511 28.084 74.15;2; 15.0008

S st. (.'.R%t. '.'. Mx '.'. M#

0 40.55 .45

5.4;3 41.;7 5.4;3 22 221.5247 5.4;3 51 51.;2535

1005.001 1045.551 1014.451

;020.775 ;242.3 ;072.4

NO '' CASE MA '' CASE M*N '' CASE

4.45 134.;174 0 7.55 2182.51 28.084 8. ;5.07 552.105 ;5 ; 5.55424

0 7.775 224.7;354

 ACT*)E EART, PRESSRE AT /ASE: At#>% Ert9 Pr%ssr% F!r%   At#>% Ert9 Pr%ssr% M!%t 

235.320;430;88 'K?49!,0.5'K?4,G2 'K?49!,0.5'K?4,G2 1377.528;3403 0.5'K?49!,G2 0.5'K?49!,G2 0.21'K ?4,G3   .2.

450.3;;551

13 $! 14 Ert9 15 ).C!. Ert9 TOTA'

30.2511 28.084 74.15;2; 15.0008

S st. (.'.R%t. '.'. Mx '.'. M#

0 40.55 .45

5.4;3 41.;7 5.4;3 22 221.5247 5.4;3 51 51.;2535

1005.001 1045.551 1014.451

;020.775 ;242.3 ;072.4

NO '' CASE MA '' CASE M*N '' CASE

4.45 134.;174 0 7.55 2182.51 28.084 8. ;5.07 552.105 ;5 ; 5.55424

0 7.775 224.7;354

 ACT*)E EART, PRESSRE AT /ASE: At#>% Ert9 Pr%ssr% F!r%   At#>% Ert9 Pr%ssr% M!%t 

235.320;430;88 'K?49!,0.5'K?4,G2 'K?49!,0.5'K?4,G2 1377.528;3403 0.5'K?49!,G2 0.5'K?49!,G2 0.21'K ?4,G3   .2.

450.3;;551

C,ECK FOR PRESSRE AT /ASE:MA '' CASE :-

NORMA' CASE

W , REST. Mt. O)T. Mt. NET Mt.

1045.551 243.2441 ;242.3 1470.377 4771.23

M*N. '' CASE :W , REST. Mt. O)T. Mt. NET Mt.

1014.451 244.1771 ;072.4 1481.302 451.08

MA. ''. CASE: >% $!@6 W , REST. Mt. O)T. Mt. NET Mt.

SE*SM*C CASE ->% @r$.6 1082.828 1008.273;740432 325.5514 325.5513818107 ;4;5.2; ;242.25741; 211;.21 2340.547208;325 434.004 301.75231102

M*N. '' CASE: ->% $!@ 6 W , RES. Mt. O)T. Mt. NET Mt.

FOS O)T6 *+,*-./. H2.00 ,+0*102 H1.50 FOS S'(6

/ASE PRESSRES :I 4. 4.5;4027 % -0 - 0.114027 P1T&M26 21.1 P2T&M26 23.71

N%t. Mt&W /&2-I W &A1;%&/6;Mt&/'G2 W &A1-;%&/6-;Mt&/'G2

FOSO)T6 *+0 H2.00 FOS S'(6 ,+32 H1.50 /ASE PRESSRES:I 4. 4.525;8 % -0.075;8 P1T&M26 21.2 P2T&M26 23.0;

FOSO)T6 .+3,+4/ H1.50 FOSS'(6 0+44 0+-- H1.25 / /s% Pr%ssr%s:I 4.01;33 3.8;7354; % 0.433;;1 0. 0 .5802;454 P1 P1T&M26 30.73 30.8 P2T&M26 1;.52 13.1

->% @r$6 @r$6

1051.728 324.;18 ;2;.02; 210;.002 410.025

77.173;740432 324.;188818107 ;072.4002741; 232.;27;33;325 3742.772;;;102

SPAN (*S'O(+E( CASE. /ASE PRESSRES:W , RES Mt O)T Mt NET Mt

STA/.Mt.&O)T.Mt. W &,

FOSO)T6 ,+11 ,+40 H1.50 FO F OSS'(6 0+4, 0+-0 H1.25 /s% Pr%ssr%s:I 3.8344 3.83020211 % 0.4;;05; 0.;1778 P1T&M26 30.35 30.43 P2T&M26 15.54 12.21

NORMA' CASE 03.8425 1.11 542.7; 1137.; 422.07

FOSO)T6 *+//,40* H2.00 FOSS'(6 ,+,4343, H1.50 /s% Pr%ssr%s:I 4.748723 % -0.28723 P1T&M26 15.75 P2 T&M26 23.; SE*SM*C CASE:-

W , RES Mt O)T Mt NET Mt

3;.;1; 2;5.4;;1 5;28.838 1588.0;5 4040.773

871.0;53;5311 2;5.4;;1330104 542.7;0075442 1787.107;205103 3;42.;88387033

>% $!@6 - >% @r$.6 FOSO)T6 .+-***4. .+-***4. .+3.2.0-3/ .+3.2.0-3/ H1.50 FOSS'(6 0+/4 0+/4*0 *03* 3* 0+4* 0+4*34 34.. ../ / H1.25 / / s% Pr Pr%ssr%s:I 4.31421 4. 4.1818771 % 0.1357 0. 0.2;812281 P1T&M26 22.31 22.44 P2 T&M26 18.5; 15.57

 ACT*)E EART, PRESSRE AT M.S.'.: A.E.P.F!r%.  A.E.P.F!r%.  A.E.P.M!%t.  A.E.P.M!%t.

175.43478038 878.23;78035   .3.

145.252; 704.;205

C,ECK FOR STRESSES AT M.S.'.:NORMA' CASE:MA. '' CASE:W 841.377 , 183.3585 REST. Mt. 3570.;4 O)T. Mt. 55.8;0 NET Mt. 2;15.103 M*N. '' CASE:W , REST. Mt. O)T. Mt. NET Mt. SE*SM*C CASE.:Mx '' CASE:->%6 W , REST. Mt. O)T. Mt. NET Mt.

STRESSES:I 3.108123 % 0.41877 P1T&M26 33.04 P2T&M26 12.34

STRESSES:I 3.071807 % 0.52813 P1T&M26 31.72 P2T&M26 11.

810.277 184.215 3453.34 ;4.203 248.014

->%6

M*N '' CASE:->%6 ->%6 W , REST. Mt. O)T. Mt. NET Mt. SPAN (*S'O(+E( CASE:NORMA' CASE:W , REST. Mt. O)T. Mt. NET Mt.

878.;541 2;5.;;57 378;.4 1437.71 234.14

804.084;731 2;5.;;573;5457 3570.;3777371 1;53.7;;5475482 117.17230388

847.5541 2;4.7332 372.17; 1428.73; 2300.44

772.84;731 2;4.73323;5457 3453.34477371 1;38.8;1725482 1815.072505388

STRESSES:I 2.;73577 2.38427757 % 0.2;423 1.21572243 P1T&M26 43.04 44.71 P2T&M26 4.35 -1.34

STRESSES:I 2.71421 2.348080 % 0.8857 1.251101 P1T&M26 3.7 42.84 P2T&M26 5.74 -1.25

STRESSES:I 3.288;4 % 0.31103; P1T&M26 23.82 P2T&M26 14.01

701.315; 145.252; 3011.223 704.;205 230;.;02

SE*SM*C CASE:- >% $!@@r$6 ->% @r$6 W 734.028 ;;8.5385213;7 , 210.80; 210.80;8713322 REST. Mt. 3210.2;5 3011.222585308 O)T. Mt. 1023.87 1222.2107343 NET Mt. 218;.38; 1788.3015118;

  .4.

STRESSES:- >%6 ->%6 I 2.7835177 2.;7441;1 % 0.;21;4823 0.250583 P1T&M26 30.05 31.3 P2T&M26 .54 4.13

(Rocker Side) C&' O< /%r#"

1

0.30 t1 1.84

91

0.5

92

(%= '%>%l 1424.00

2

0.7;3

20&100

JANT*TY OF CONCRETE :.,*+102./ CUM 3

0.+-- 56

.21 93

,.F.'. .45

4

'.W.'. ; M.S.'.

5

1412.45

1.7 5

12

11

F!$#" '%>%l 1410.45

13

0.3 94 .+**

1 2.70  

0.30

-+*4

2 3 0.3 1.2 B67 2+1

4 3.00

5 1.7

'1 0.475 9;

'1 0.475

8    1    0

10

95 11.55

8

95-9; 11.1;

13.55 ,

7

14

   7





  945 2 '1 0.475

'2 2

0.2 ' 5.15

'2 2

'1 0.475

FOS N&C S&C FOS O)T6 *+03 H2.00 ,+40 H1.5 FOS S'(6 ,+32 H1.50 0+-0 H1.25 SUMMARY OF RESUTS'

 AT /ASE:NORMA'

SE*SM*C

Mx.''

P1 21.1

P2 23.71

M# ''

21.2

23.0;

S (#sl!$"%

15.75

23.;

Mx.''.

33.04

12.34

M#. ''.

31.72

11.

S (#sl!$"%

23.82

14.01

P1 30.73 30.8 30.35 30.43 22.31 22.44

P2 1;.52 13.1 15.54 12.21 18.5; 15.57

43.04 44.71 3.7 42.84 30.05 31.3

4.35 -1.34 5.74 -1.25 .54 4.13

 AT M.S.':-

 T

Y1

 T T T

Y1

 T

Y1

 T T T

Y1

Y2

Y2 21.1 21.2 15.75 21.1

Y3

Y3 Y4 23.71 4.245373 2.1418 23.0; 4.1 2.08 23.; 4.772;14 2.2;0;02 23.0; 4.1 2.08

Y2

Y2 33.04 31.72 23.82 33.04

Y4

12.34 11. 14.01 11.

 T

Y1

 T T T T T

Y1

T

Y2

Y2

Y3

Y4

30.73 30.8 30.35 30.43 22.31

Y3 Y4 1;.52 3.05 1.;; 13.1 2.;7 1.55 15.54 2. 1.;2 12.21 2.;1 1.51 18.5; 3.5444;3 1.7;4104

22.44 30.8

15.57 3.038315 1.;40;34 12.21 2.;1 1.51

 T

Y1

Y2

 T T T T T T

Y1

Y2 43.04 44.71 3.7 42.84 30.05 31.3 44.71

4.35 -1.34 5.74 -1.25 .54 4.13 -1.34