Complete the earthwork calculation sheet here and plot the r

Complete the earthwork calculation sheet here and plot the resulting mass diagram. Divide ccy by 0.9 to convert to bcy. Calculate the average haul (trapezoidal formula) for the balances on this project. Is this a waste or borrow project? 3.7 9 End- End- Vol. Vol. area area of of Strip Strip Total Total Adj cut fill cut ill cut fll cut fill 1 Mass fill Sum ordi- Station (st) (sf) (bcy) (ccy) (bcy) (ccy) (bcy) (ccy) (bey) (bcy) nate 0.90 10 00 11 +00 580 12 00 2,100 1300 4,650 14 +00 5,870 15+00 3,250 563 16+00 ,300 900 17 +00 700 2,450 18 00 19 + 00 20 00 21 00 200 1,310 22 00 580 1,100 23 00 1,620 260 24 00 2,480 25 00 994 100 100 80 85 0 100 90 80 80 0 7,200 0 4,160 0 1,980 80 100 100 100 10 10

Solution

Calculation of volume of cut

V_cut = ( ( A_c1+A_c2)/2) * (L/27)

A_c1 is cut area at 1st end

A_c2 is cut area at 2nd end

Calculation of volume of fill

V_fill = (( Af1+Af2)/2) * (L/27)

Af1 is fill area at 1st end

Af2 is fill area at 2nd end

Calculation for 11+00 station

Vcut = ((0+580)/2) * (100/27) = 1074.07

Vfill = ((0+0)/2) * ( 100/27) = 0

Total cut = Vcut - stripping cut = 1074.074-80 = 994.0741  

Total fill = Vfill + stripping fill = 0+0 = 0

Adjusted fill = Total fill / 0.9 = 0/0.9 = 0

Algebraic sum = total cut - adjusted fill = 994.0741 - 0 = 994.0741

Mass ordinate = Mass ordinate of above station + algebraic sum of actual station = 0 + 994.074 = 994.074

19481.48

17+00

Station	end cut area	end fill area	volume of cut	volume of fill	strip cut	strip fill	total cut	total fill	adj fill	algebraic sum	mean ordinate
10+00	0	0	0	0	0	0	0	0	0	0	0
11+00	580	0	1074.074	0	80	0	994.0741	0	0	994.0741	994.0741
12+00	2100	0	4962.963	0	90	0	4872.963	0	0	4872.963	5867.037037
13+00	4650	0	12500	0	100	0	12400	0	0	12400	17272.96296
14+00	5870	0	19481.48	1042.593	100	0	19381.48	1042.593	1158.436	18223.04527	30623.04527
15+00	3250	563	16888.89	2709.259	80	60	16808.89	2769.259	3076.955	13731.93416	31954.97942
16+00	1300	900	8425.926	6203.704	80	80	8345.926	6283.704	6981.893	1364.032922	-14962.6749
17+00	700	2450	3703.704	17870.37	80	85	3623.704	17955.37	19950.41	-16326.7078	-14962.6749
18+00	0	7200	1296.296	21037.04	0	100	1296.296	21137.04	23485.6	-22189.3004	-38516.00823
19+00	0	4160	0	11370.37	0	90	0	11460.37	12733.74	-12733.7449	-34923.04527
20+00	0	1980	0	6092.593	0	80	0	6172.593	6858.436	-6858.43621	-19592.18107
21+00	200	1310	370.3704	4462.963	0	80	370.3704	4542.963	5047.737	-4677.36626	-11535.80247
22+00	580	1100	1444.44	2518.519	80	10	1364.444	2528.519	2809.465	-1445.02058	-6122.386831
23+00	1620	260	4074.074	500	100	10	3974.074	510	566.6667	3407.407407	1962.386831
24+00	2480	10	7592.594	18.518	100	0	7492.593	18.51852	20.57613	7472.016461	10879.42387
25+00	994	0	6433.33	0	100	0	6333.333	0	0	6333.333	13805.34979