Scribd
Upload
18 views1 page

Excel Ex1

Uploaded by

gopikar.22ece
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
18 views1 page

Excel Ex1

Uploaded by

gopikar.22ece
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

inputs:

Rising Gradient 1 in 40 0.025


Falling Gradient 0.01
Side Slope(Z) 2
Top width(B) 12m

Computation of formation level


Chainage(m) RL of Ground(m) RL of Formation(m) Gradient
0 101.5 101.75
20 100.9 102.25

40
in
40 101.5 102.75

1
ng
si
60 102 103.25

ai
R
80 102.85 103.75
100 101.65 103.55
120 101.95 103.35

0
10
140 100.7 103.15

in
1
160 101.25 102.95

g
llin
Fa
180 99.9 102.75
200 100.6 102.55

computation of quantity earthwork:


Chainage Length Height Mean Height Central Area Side Area Total Sectional Area Length between two area Quantity
d bd Zd2 bd+zd2 l Filling Cutting
m m m m2 m2 m2 m3 m3
0 0 0.25
20 20 1.35 0.8 9.6 1.28 10.88 20 218 0
40 40 1.25 1.3 15.6 3.38 18.98 20 379.6 0
60 60 1.25 1.3 15 3.125 18.13 20 362.5 0
80 80 0.9 1.1 12.9 2.31 15.21 20 304.23 0
100 100 1.9 1.4 16.8 3.92 20.72 20 414.4 0
120 120 1.4 1.6 19.8 5.44 25.24 20 504.9 0
140 140 2.45 1.9 23.1 7.41 30.51 20 610.22 0
160 160 1.7 2.1 24.9 8.61 33.51 20 670.22 0
180 180 2.85 2.3 27.3 10.35 37.65 20 753.02 0
200 200 1.95 2.4 28.8 11.52 40.32 20 806.4 0
5019

You might also like