Civilnotess.com
Random News

Excavation | Rate analysis and Quantity calculation Tool

parag21pal@icloud.com021 mins

Introduction


To carry out any construction work we required the quantity calculation and that gives a detailed explanation of how much quantity to procure at the construction site. The rate analysis is one of the best calculations which help to carry out the cost and quantity calculation for construction work.

This post will help to calculate the rate analysis of Excation using the following standard tool developed by Parag Pal.


Rate analysis of Excavation 

Rate analysis of excavation is very important as it gives importance to the cost calculation of unit and multiple quantity at a given time with cost using the following tool.

Kindly provide the input in the yellow highlighted cell and it is suggested to watch the video below before kick start working on following rate analysis of excavation tool.


Watch following video to undertsand how to use this tool.




Rate analysis of Excavation Tool


function calcule2(){
var i=0; for (i=0;i<= 19;i++) {calcule();}}
function calcule(){
Excel2Html.D7.value=(Math.round((1*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F7.value=(Math.round((parseFloat(Excel2Html.C7.value)*parseFloat(Excel2Html.D7.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F8.value=(Math.round((parseFloat(Excel2Html.F7.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F9.value=(Math.round((parseFloat(Excel2Html.F8.value)*parseFloat(Excel2Html.C9.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F10.value=(Math.round((parseFloat(Excel2Html.F8.value)*parseFloat(Excel2Html.C10.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F11.value=(Math.round((parseFloat(Excel2Html.F8.value)*parseFloat(Excel2Html.C11.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F12.value=(Math.round((parseFloat(Excel2Html.F8.value)*parseFloat(Excel2Html.C12.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F13.value=(Math.round((parseFloat(Excel2Html.F8.value)+parseFloat(Excel2Html.F9.value)+parseFloat(Excel2Html.F10.value)+parseFloat(Excel2Html.F11.value)+parseFloat(Excel2Html.F12.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D15.value=(Math.round((0.32*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F15.value=(Math.round((parseFloat(Excel2Html.C15.value)*parseFloat(Excel2Html.D15.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D16.value=(Math.round((0.9*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F16.value=(Math.round((parseFloat(Excel2Html.C16.value)*parseFloat(Excel2Html.D16.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D17.value=(Math.round((1.5*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F17.value=(Math.round((parseFloat(Excel2Html.C17.value)*parseFloat(Excel2Html.D17.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F18.value=(Math.round((parseFloat(Excel2Html.F15.value)+parseFloat(Excel2Html.F16.value)+parseFloat(Excel2Html.F17.value))* 1E+15))/ 1E+15 ;
Excel2Html.F19.value=(Math.round((parseFloat(Excel2Html.F18.value)*parseFloat(Excel2Html.C19.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F20.value=(Math.round((parseFloat(Excel2Html.F18.value)*parseFloat(Excel2Html.C20.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F21.value=(Math.round((parseFloat(Excel2Html.F18.value)*parseFloat(Excel2Html.C21.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F22.value=(Math.round((parseFloat(Excel2Html.F18.value)*parseFloat(Excel2Html.C22.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F23.value=(Math.round((parseFloat(Excel2Html.F18.value)+parseFloat(Excel2Html.F19.value)+parseFloat(Excel2Html.F20.value)+parseFloat(Excel2Html.F21.value)+parseFloat(Excel2Html.F22.value))* 1E+15))/ 1E+15 ;
Excel2Html.D25.value=(Math.round((0.33*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F25.value=(Math.round((parseFloat(Excel2Html.C25.value)*parseFloat(Excel2Html.D25.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F26.value=(Math.round((parseFloat(Excel2Html.F25.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F27.value=(Math.round((parseFloat(Excel2Html.F26.value)*parseFloat(Excel2Html.C27.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F28.value=(Math.round((parseFloat(Excel2Html.F26.value)*parseFloat(Excel2Html.C28.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F29.value=(Math.round((parseFloat(Excel2Html.F26.value)*parseFloat(Excel2Html.C29.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F30.value=(Math.round((parseFloat(Excel2Html.F26.value)*parseFloat(Excel2Html.C30.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F31.value=(Math.round((parseFloat(Excel2Html.F26.value)+parseFloat(Excel2Html.F30.value)+parseFloat(Excel2Html.F29.value)+parseFloat(Excel2Html.F28.value)+parseFloat(Excel2Html.F27.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D33.value=(Math.round((0.7*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F33.value=(Math.round((parseFloat(Excel2Html.C33.value)*parseFloat(Excel2Html.D33.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F34.value=(Math.round((parseFloat(Excel2Html.F33.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F35.value=(Math.round((parseFloat(Excel2Html.F34.value)*parseFloat(Excel2Html.C35.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F36.value=(Math.round((parseFloat(Excel2Html.F34.value)*parseFloat(Excel2Html.C36.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F37.value=(Math.round((parseFloat(Excel2Html.F34.value)*parseFloat(Excel2Html.C37.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F38.value=(Math.round((parseFloat(Excel2Html.F34.value)*parseFloat(Excel2Html.C38.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F39.value=(Math.round((parseFloat(Excel2Html.F34.value)+parseFloat(Excel2Html.F35.value)+parseFloat(Excel2Html.F36.value)+parseFloat(Excel2Html.F37.value)+parseFloat(Excel2Html.F38.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D41.value=(Math.round((0.5*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F41.value=(Math.round((parseFloat(Excel2Html.C41.value)*parseFloat(Excel2Html.D41.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F42.value=(Math.round((parseFloat(Excel2Html.F41.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F43.value=(Math.round((parseFloat(Excel2Html.F42.value)*parseFloat(Excel2Html.C43.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F44.value=(Math.round((parseFloat(Excel2Html.F42.value)*parseFloat(Excel2Html.C44.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F45.value=(Math.round((parseFloat(Excel2Html.F42.value)*parseFloat(Excel2Html.C45.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F46.value=(Math.round((parseFloat(Excel2Html.F42.value)*parseFloat(Excel2Html.C46.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F47.value=(Math.round((parseFloat(Excel2Html.F42.value)+parseFloat(Excel2Html.F46.value)+parseFloat(Excel2Html.F45.value)+parseFloat(Excel2Html.F44.value)+parseFloat(Excel2Html.F43.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D49.value=(Math.round((0.24*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F49.value=(Math.round((parseFloat(Excel2Html.C49.value)*parseFloat(Excel2Html.D49.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F50.value=(Math.round((parseFloat(Excel2Html.F49.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F51.value=(Math.round((parseFloat(Excel2Html.F50.value)*parseFloat(Excel2Html.C51.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F52.value=(Math.round((parseFloat(Excel2Html.F50.value)*parseFloat(Excel2Html.C52.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F53.value=(Math.round((parseFloat(Excel2Html.F50.value)*parseFloat(Excel2Html.C53.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F54.value=(Math.round((parseFloat(Excel2Html.F50.value)*parseFloat(Excel2Html.C54.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F55.value=(Math.round((parseFloat(Excel2Html.F50.value)+parseFloat(Excel2Html.F54.value)+parseFloat(Excel2Html.F53.value)+parseFloat(Excel2Html.F52.value)+parseFloat(Excel2Html.F51.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D57.value=(Math.round((1*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F57.value=(Math.round((parseFloat(Excel2Html.C57.value)*parseFloat(Excel2Html.D57.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D58.value=(Math.round((0.24*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F58.value=(Math.round((parseFloat(Excel2Html.C58.value)*parseFloat(Excel2Html.D58.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F59.value=(Math.round((parseFloat(Excel2Html.F57.value)+parseFloat(Excel2Html.F58.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F60.value=(Math.round((parseFloat(Excel2Html.F59.value)*parseFloat(Excel2Html.C60.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F61.value=(Math.round((parseFloat(Excel2Html.F59.value)*parseFloat(Excel2Html.C61.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F62.value=(Math.round((parseFloat(Excel2Html.F59.value)*parseFloat(Excel2Html.C62.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F63.value=(Math.round((parseFloat(Excel2Html.F59.value)*parseFloat(Excel2Html.C63.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F64.value=(Math.round((parseFloat(Excel2Html.F59.value)+parseFloat(Excel2Html.F63.value)+parseFloat(Excel2Html.F62.value)+parseFloat(Excel2Html.F61.value)+parseFloat(Excel2Html.F60.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D66.value=(Math.round((0.24*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F66.value=(Math.round((parseFloat(Excel2Html.C66.value)*parseFloat(Excel2Html.D66.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F67.value=(Math.round((parseFloat(Excel2Html.F66.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F68.value=(Math.round((parseFloat(Excel2Html.F67.value)*parseFloat(Excel2Html.C68.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F69.value=(Math.round((parseFloat(Excel2Html.F67.value)*parseFloat(Excel2Html.C69.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F70.value=(Math.round((parseFloat(Excel2Html.F67.value)*parseFloat(Excel2Html.C70.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F71.value=(Math.round((parseFloat(Excel2Html.F67.value)*parseFloat(Excel2Html.C71.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F72.value=(Math.round((parseFloat(Excel2Html.F67.value)+parseFloat(Excel2Html.F71.value)+parseFloat(Excel2Html.F70.value)+parseFloat(Excel2Html.F69.value)+parseFloat(Excel2Html.F68.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D74.value=(Math.round((1*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F74.value=(Math.round((parseFloat(Excel2Html.C74.value)*parseFloat(Excel2Html.D74.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D75.value=(Math.round((0.24*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F75.value=(Math.round((parseFloat(Excel2Html.C75.value)*parseFloat(Excel2Html.D75.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F76.value=(Math.round((parseFloat(Excel2Html.F74.value)+parseFloat(Excel2Html.F75.value))* 10000000000000))/ 10000000000000 ;
Excel2Html.F77.value=(Math.round((parseFloat(Excel2Html.F76.value)*parseFloat(Excel2Html.C77.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F78.value=(Math.round((parseFloat(Excel2Html.F76.value)*parseFloat(Excel2Html.C78.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F79.value=(Math.round((parseFloat(Excel2Html.F76.value)*parseFloat(Excel2Html.C79.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F80.value=(Math.round((parseFloat(Excel2Html.F76.value)*parseFloat(Excel2Html.C80.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F81.value=(Math.round((parseFloat(Excel2Html.F76.value)+parseFloat(Excel2Html.F80.value)+parseFloat(Excel2Html.F79.value)+parseFloat(Excel2Html.F78.value)+parseFloat(Excel2Html.F77.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D83.value=(Math.round((1*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F83.value=(Math.round((parseFloat(Excel2Html.C83.value)*parseFloat(Excel2Html.D83.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.D84.value=(Math.round((0.24*parseFloat(Excel2Html.C2.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F84.value=(Math.round((parseFloat(Excel2Html.C84.value)*parseFloat(Excel2Html.D84.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F85.value=(Math.round((parseFloat(Excel2Html.F83.value)+parseFloat(Excel2Html.F84.value))* 10000000000000))/ 10000000000000 ;
Excel2Html.F86.value=(Math.round((parseFloat(Excel2Html.F85.value)*parseFloat(Excel2Html.C86.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F87.value=(Math.round((parseFloat(Excel2Html.F85.value)*parseFloat(Excel2Html.C87.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F88.value=(Math.round((parseFloat(Excel2Html.F85.value)*parseFloat(Excel2Html.C88.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F89.value=(Math.round((parseFloat(Excel2Html.F85.value)*parseFloat(Excel2Html.C89.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F90.value=(Math.round((parseFloat(Excel2Html.F85.value)+parseFloat(Excel2Html.F89.value)+parseFloat(Excel2Html.F88.value)+parseFloat(Excel2Html.F87.value)+parseFloat(Excel2Html.F86.value))* 100000000000000))/ 100000000000000 ;
}

Excavation Quantity cum
RATE ANALYSIS – By PARAG KAMLAKAR PAL
Description Rate Quantity Unit Amount
EARTH WORKS SITE CLEARING
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS BLASTING ROCKS Unit Cu.M.
COUNTRY BLASTING POWDER Kg
COUNTRY FUSE m
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS EXCAVATION ORDINARY SOIL Unit Cu.M.
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS EXCAVATION HARD SOIL Unit Cu.M.
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS EXCAVATION Unit Cu.M.
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS FILLING FOUNDATION Unit Cu.M.
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS FILLING FOUNDATION USING SAND Unit Cu.M.
SAND cum
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS FILLING PLINTH USING EARTH FROM SITE Unit Cu.M.
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS FILLING PLINTH USING EARTH OUTSIDE Unit Cu.M.
EARTH cum
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
EARTH WORKS FILLING PLINTH USING SAND Unit Cu.M.
SAND cum
HELPER day
Sub Total
Add for Machinery, Scaffoldings, etc. Percentage
Add for Sundries & Contingencies Percentage
Add for Water Charges & Electricity Percentage
Add for Profit & Overhead Percentage
Total
If you like this tool then please subscribe my youtube channel:Subscribe Youtube channel

Leave a Reply

Your email address will not be published. Required fields are marked *

Related News