Wall Plaster | Rate analysis and Quantity Calculation Tool

Wall plaster work is the next step carried out after the Brickwork. The calculation of material and labor costs for plaster work is quite difficult, so to make it easier I have made a calculator from which you can easily calculate the rate analysis and quantity calculation using this tool.  

There are different types of plaster thicknesses such as 12 mm, 15mm, and so on based on that the cement sand means the mortar mix we use for plaster work. This building estimation tool will help you to grab the rate analysis and quantity of material and labor required for plaster work easily.  

To use this tool provide your input in the yellow highlighted box and based on your real life practices provide the input for contractor % and rates of labor and material.

function calcule2(){
var i=0; for (i=0;i<= 32;i++) {calcule();}}
function calcule(){
Excel2Html.C5.value=parseFloat(Excel2Html.C3.value)*parseFloat(Excel2Html.C4.value) ;
Excel2Html.C7.value=parseFloat(Excel2Html.C6.value)*parseFloat(Excel2Html.C5.value) ;
Excel2Html.C8.value=(Math.round((((1.52+0.05+0.03)/(parseFloat(Excel2Html.C2.value)+parseFloat(Excel2Html.D2.value)))*parseFloat(Excel2Html.C7.value)*parseFloat(Excel2Html.C2.value)*28.8)* 100))/ 100 ;
Excel2Html.C9.value=(Math.round((((1.52+0.05+0.03)/(parseFloat(Excel2Html.C2.value)+parseFloat(Excel2Html.D2.value)))*parseFloat(Excel2Html.C7.value)*parseFloat(Excel2Html.D2.value)*1.05)* 1000))/ 1000 ;
Excel2Html.C12.value=(Math.round((parseFloat(Excel2Html.C8.value))* 100))/ 100 ;
Excel2Html.F12.value=(Math.round((parseFloat(Excel2Html.C12.value)*parseFloat(Excel2Html.D12.value))* 1))/ 1 ;
Excel2Html.C13.value=(Math.round((parseFloat(Excel2Html.C9.value))* 1000))/ 1000 ;
Excel2Html.F13.value=(Math.round((parseFloat(Excel2Html.C13.value)*parseFloat(Excel2Html.D13.value))* 1))/ 1 ;
Excel2Html.F14.value=(Math.round((parseFloat(Excel2Html.F12.value)+parseFloat(Excel2Html.F13.value))* 1))/ 1 ;
Excel2Html.C15.value=0.25*parseFloat(Excel2Html.C5.value) ;
Excel2Html.F15.value=(Math.round((parseFloat(Excel2Html.C15.value)*parseFloat(Excel2Html.D15.value))* 1))/ 1 ;
Excel2Html.C16.value=0.5*parseFloat(Excel2Html.C5.value) ;
Excel2Html.F16.value=(Math.round((parseFloat(Excel2Html.C16.value)*parseFloat(Excel2Html.D16.value))* 1))/ 1 ;
Excel2Html.C17.value=0.2*parseFloat(Excel2Html.C5.value) ;
Excel2Html.F17.value=(Math.round((parseFloat(Excel2Html.C17.value)*parseFloat(Excel2Html.D17.value))* 1))/ 1 ;
Excel2Html.F19.value=(Math.round((parseFloat(Excel2Html.F15.value)+parseFloat(Excel2Html.F16.value)+parseFloat(Excel2Html.F17.value)+parseFloat(Excel2Html.F18.value))* 1))/ 1 ;
Excel2Html.F20.value=(Math.round((parseFloat(Excel2Html.F14.value)+parseFloat(Excel2Html.F19.value))* 1))/ 1 ;
Excel2Html.F21.value=(Math.round((parseFloat(Excel2Html.F20.value)*parseFloat(Excel2Html.C21.value))* 1))/ 1 ;
Excel2Html.F22.value=(Math.round((parseFloat(Excel2Html.F20.value)*parseFloat(Excel2Html.C22.value))* 1))/ 1 ;
Excel2Html.F23.value=(Math.round((parseFloat(Excel2Html.F20.value)+parseFloat(Excel2Html.F21.value)+parseFloat(Excel2Html.F22.value))* 1))/ 1 ;
}

Mix
Length		m
Width		m
Quantity		sq.m
Thickness		m
Volume of wet mortar		cum
Cement bags		Bag
Sand		cum
Prepared By:Parag Kamlakar Pal
Description	Quantity & Number	Rate	Per	Amount
Cement bag			Bag
Sand			Cum
Material Cost
Supervisor for measuring and mixing			no
Male coolie			no
Bhistie			no
Sundries			LS
Labour Cost
Total
Contractor profit			Percentage
Water and electric consumption charges			Percentage
Total cost