How to Calculate Excavation in Excel | Calculate the Building Estimation

What Is Excavation?

Excavation will be defined as excavating and removing volumes of earth or other materials to shape spaces into which foundations, water tanks, concrete, masonry, and sections corresponding to hydraulic or sanitary systems will be housed in accordance with project plans.

detailed estimate of building format in excel,building estimate format,detailed estimate of a residential building in excel,Quantity Survey,detailed estimation of building with plan pdf,
Calculate Excavation in Excel

There are various types of excavation:

• Common excavation

• Excavation on semi-hard ground

• Excavation in rock

• Excavation with shoveling

•Excavation with depletion and embedding

Excavation I.S. Code

Part 1 of I.S. Code 1200: Earthwork

I.S. Code 1200: Part - 27: Earth Work Done By Mechanical Appliances Important Excavation Point According to I.S. Code

Part 1 of IS 1200

Measurement (CL: 2.3)

• Every dimension must be measured to the nearest 0.01 meter.

• Areas must be calculated to the nearest 0.01 m2 and

• Cubical contents must be calculated to the nearest 0.01 m3.

Work to be Measured Separately (CL: 2.4)

• Work in or beneath the water,

• Work in or around bad situations,

•Work in the snow.

Excavation in Earthwork Including Rock Cutting (CL: 4.2)

• All excavation must be measured in 1.5-meter increments, with the starting level marked. This does not apply to cases with no lift, such as hillside cutting. (CL: 4.2.3)


Excavation Over Area (CL: 4.7)

• Excavation over areas that exceed 1.5 m in width, 10 m2 on a plan, and 300 mm in depth must be described as excavation over areas and measured in cubic meters.

• Lead (CL: 5.1)

• Distances of less than 250 m must be measured in 50-meter increments.

• Distances greater than 250 m but less than 500 m must be measured separately.

• Leads longer than 500 meters must be measured in 500-meter increments.

• That is, there will be one item for lead greater than 500 m but less than 1000 m.

• Another item for lead that exceeds 1000 m but does not exceed 1500 m, and so on up to 5 km.

• When the lead exceeds 5 km, it will be measured in 1 km increments, half km and above will be counted as one, and less than 1/2 km will be ignored.

• Lift (CL: 6.1)

• Excavation up to 1.5 m below ground level and depositing excavated material on the ground must be included in the earthwork item for different soil types.

• The extra lift must be measured in 1.5 m increments or parts. Only obvious lifts shall be measured; lifts naturally in the lead due to ground slope shall not be measured ( except for lead up to 250 m).

• When earth must be carried over a bank/obstruction and dumped beyond it, the lift is the difference in level between the excavated earth's center of gravity and the top of the bank/construction.

IS 1200: Part – 27

Measurement (CL: 2.3)

• Each dimension shall be measured to the nearest 0.01 m; if any dimension exceeds 25 m, it shall be measured to the nearest O.1 m2.

• Areas must be calculated to the nearest 0.01 m2 and

• Cubical contents must be calculated to the nearest 0.01 m3.

• Work to be Measured Separately (CL: 2.4)

• Work in or under-water,

• Work in or under foul situations,

• Work under tides, and

• Work in snow.

Read More




• Embankment

• Forming embankments and Ming must be measured in cubic meters and include slope formation.

• When the material is to be deposited in layers, the thickness of each layer must be specified.

• The consolidation method must be described. Be taken in 1.5 m increments beginning at the beginning level

How to Excavation Calculation in Excel Sheet

Required for Excavation Calculation Excel Sheet

1. Plan, Elevation, Section

2. Footing Detail Drawing

Plan


Footing Detail Plan


Number of Footings of the Same Size = 6 Nos.

Footing Size = 1400 mm x 1400 mm

Size of P.C.C = (150 + 1400 + 150) x (150 + 1400 + 150) = 1700 mm x 1700 mm

  • Size of Soling = Same as P.C.C = 1700 mm x 1700 mm
  • Excavation of height from E.G.L. (Existing Ground Level) according to drawing = 3500 mm + 150 mm

  • Excavation area L x B = (Extra length of 500mm for working space + Length of P.C.C + Extra length of 500mm for working space) x (Extra length of 500mm for working space + Breadth of P.C.C + Extra length of 500mm for working space) x (Extra length of 500mm for working space + Breadth of P.C.C + Extra length of 500mm for working space)
  • Area excavated L x B = (500 mm + 1700 mm + 500 mm) × (500 mm + 1700mm + 500mm)
  • Excavation size of area L x B = (2700 mm) x (2700 mm)

Excel Sheet for Excavation 

Civil Engineering Information

The creator Azib Rajput , is a civil engineer living in islamabad>> Punjab>> Pakistan . He has completed his DAE civil from CTTI. This site was made for educational purpose so as to help the fellow civil engineering students and to spread the knowledge about the latest civil engineering projects and softwares. This site consists of general notes of all engineering fields which are specifically taken from my class notes by considering various books and journals.

1 Comments

Previous Post Next Post