Earthwork Excavation Calculation for Road Work | Road Estimate in Excel

In this Article today we will talk about the Earthwork Excavation Calculation for Road Work | Road Construction Layers | Road Estimate in Excel | Quantity Estimation of Road Work | Earth Work Calculation in Excel | Earth Work | Earthwork Calculation Formula

Earth Work:

Soil is one of the vital construction materials that is applied for the construction of road, embankment , earthen dam. The method of excavating the soil, deliver to the other place and placing it is known as Earthwork. The Quantities of Earthwork differs from millions of cubic meters to 100 cubic meter. Road Construction Layers

Methods of Earth Work:

Earthwork mainly includes the following method:-

1. Excavation of soil or shifting of the soil.
2. Loading, transportation and unloading of soil.
3. Placing and compacting of the soil.

This construction article is presented by the renowned engineer Mr. Engr WASEEM RAJA. In this video, you will learn the detailed process for measuring the earth work in hilly area. At the time of handling with earth work in hilly area, the following three types of situations occur: Earthwork Calculation Formula

Earthwork Conditions in Hilly Areas:

1. Fully in cutting.
2. Fully in filling.
3. Partially in cutting and filling.

Earthwork Excavation Calculation | Road Estimate Partially in Cutting and Filling:

Calculate approximately of earthwork through mean area method in partially cutting as well as filling lengthwise regarding road embankment. Road formation width in plain region is 22 ft as well as side slope in cutting is 1:1 and in filling is 2:1. Formation level at RD equal to 0 is 575.00m. On the part of road upward gradient of 200:1 is suggested. Natural surface levels at different RDs are specified underneath – compute quantity of earthwork for the road?

Reduced Distance	0 (cutting)	100 (cutting)	200 (cutting)	212.50 RD of IMP	300 (filling)	400 (filling)	500 (filling)
N.S.L.	577.65	576.85	576.15	0	575.45	574.65	573.75
F.S.L.	575	575.50	576	0	576.50	577	577.50

Depth (d) F.S.L. – N.S.L.	-2.65	– 1.35	– 0.15	0	1.05	2.35	3.75
Area (A) equal to (a + b/2 x d) (ft2)	65.32	31.52	3.32	0	25.30	62.75	110.63

Note: Download File Link is Available in the Bottom of this Post (Scroll Down)

Specified information:

• Top width of road equal to B equal to 22 ft (will be similar in all over the embankment)
• Side slope in cutting equal to S1 equal to 1:1 equal to 1
• Side slope in filling equal to S2 equal to 2:1 equal to 2
• Depth in cutting / Filling equal to 4 equal to Formation level – NSL
• Upward gradient slope equal to +g equal to 200:1 equal to 200

• Formation level at initial RD equal to FL equal to 575
• Since the formation is in a upward gradient (+g) of 200:1, formation width is 22 ft as well as formation level at R.D. equal to 0 is 575 so (specified info)
• The boost in formation level equal to Interval/gradient slope equal to 100/200 m equal to 0.50 ft

---

Earth Work Calculation in Excel | Video Tutorial

---

Example | Quantity Estimation of Road Work

Given Data:

R.D, N.S,L & F.S.L Readings:

Cross Section of a Road:

3D Cross Section of Road:

Road Cross Section at R.D = 0:

Road Cross Section at R.D = 100:

Road Cross Section at R.D = 200:

Road Cross Section at R.D = 300:

Road Cross Section at R.D = 400:

Road Cross Section at R.D = 500:

Earthwork of Road Embankment:

 Intermediate Point of Road Cross Section: Abstract of Quantities for Earthwork Calculation:

Earthwork of Road Embankment (Complete Table):

Abstract of Cost:

Road Estimate in Excel | File Download:

Road Estimate Excel File Download Here

---

OTHER POSTS:

1. Load Calculation on Column, Beam, Wall & Slab

2. Basic Rules for Design of Column | Thumb Rules for Column Design

3. Basic Components of Road Structure and Method of Construction

4. How to Create Road Alignment Coordinates Report XML XLS in AutoCAD Civil 3D

5. Difference Between Flexible and Rigid Pavement | Types of Pavement

---

Conclusion:

Full article on Earthwork Excavation Calculation for Road Work | Road Construction Layers | Road Estimate in Excel | Quantity Estimation of Road Work | Earth Work Calculation in Excel | Earth Work | Earthwork Calculation Formula. Thank you for the full reading of this article in “The Civil Engineering” platform in English. If you find this post helpful, then help others by sharing it on social media. If any formula of BBS is missing from this article please tell me in comments.