Introduction
PCC | Rate analysis and Quantity Calculation Tool
function calcule2(){
var i=0; for (i=0;i<= 48;i++) {calcule();}}
function calcule(){
Excel2Html.C5.value=parseFloat(Excel2Html.C2.value)*parseFloat(Excel2Html.C3.value)*parseFloat(Excel2Html.C4.value) ;
Excel2Html.C6.value=parseFloat(Excel2Html.C5.value)*1.52 ;
Excel2Html.C8.value=(Math.round((((parseFloat(Excel2Html.C6.value)*parseFloat(Excel2Html.C5.value)*parseFloat(Excel2Html.C7.value))/(parseFloat(Excel2Html.C7.value)+parseFloat(Excel2Html.D7.value)+parseFloat(Excel2Html.E7.value))))* 100))/ 100 ;
Excel2Html.C9.value=(Math.round((parseFloat(Excel2Html.C8.value)*28.8)* 100000000000000))/ 100000000000000 ;
Excel2Html.C10.value=(Math.round(((parseFloat(Excel2Html.C6.value)/(parseFloat(Excel2Html.C7.value)+parseFloat(Excel2Html.D7.value)+parseFloat(Excel2Html.E7.value)))*parseFloat(Excel2Html.D7.value)*parseFloat(Excel2Html.C5.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.C11.value=(Math.round(((parseFloat(Excel2Html.C6.value)/(parseFloat(Excel2Html.C7.value)+parseFloat(Excel2Html.D7.value)+parseFloat(Excel2Html.E7.value)))*parseFloat(Excel2Html.E7.value)*parseFloat(Excel2Html.C5.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.C15.value=(Math.round((parseFloat(Excel2Html.C9.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F15.value=(Math.round((parseFloat(Excel2Html.C15.value)*parseFloat(Excel2Html.D15.value))* 1E+15))/ 1E+15 ;
Excel2Html.C16.value=(Math.round((parseFloat(Excel2Html.C10.value))* 100))/ 100 ;
Excel2Html.F16.value=(Math.round((parseFloat(Excel2Html.C16.value)*parseFloat(Excel2Html.D16.value))* 1E+15))/ 1E+15 ;
Excel2Html.C17.value=(Math.round((parseFloat(Excel2Html.C11.value))* 100))/ 100 ;
Excel2Html.F17.value=(Math.round((parseFloat(Excel2Html.C17.value)*parseFloat(Excel2Html.D17.value))* 1E+15))/ 1E+15 ;
Excel2Html.F18.value=(Math.round((parseFloat(Excel2Html.F15.value)+parseFloat(Excel2Html.F16.value)+parseFloat(Excel2Html.F17.value))* 1E+15))/ 1E+15 ;
Excel2Html.C19.value=(Math.round((0.05*parseFloat(Excel2Html.C5.value))* 100))/ 100 ;
Excel2Html.F19.value=parseFloat(Excel2Html.C19.value)*parseFloat(Excel2Html.D19.value) ;
Excel2Html.C20.value=(Math.round((0.2*parseFloat(Excel2Html.C5.value))* 100))/ 100 ;
Excel2Html.F20.value=parseFloat(Excel2Html.C20.value)*parseFloat(Excel2Html.D20.value) ;
Excel2Html.C21.value=(Math.round((1.1*parseFloat(Excel2Html.C5.value))* 100))/ 100 ;
Excel2Html.F21.value=parseFloat(Excel2Html.C21.value)*parseFloat(Excel2Html.D21.value) ;
Excel2Html.C22.value=(Math.round((1*parseFloat(Excel2Html.C5.value))* 100))/ 100 ;
Excel2Html.F22.value=parseFloat(Excel2Html.C22.value)*parseFloat(Excel2Html.D22.value) ;
Excel2Html.C23.value=(Math.round((0.4*parseFloat(Excel2Html.C5.value))* 100))/ 100 ;
Excel2Html.F23.value=parseFloat(Excel2Html.C23.value)*parseFloat(Excel2Html.D23.value) ;
Excel2Html.C24.value=(Math.round(((parseFloat(Excel2Html.C2.value)*parseFloat(Excel2Html.C3.value)*parseFloat(Excel2Html.C4.value))*10)* 100))/ 100 ;
Excel2Html.F24.value=(Math.round((parseFloat(Excel2Html.C24.value)*parseFloat(Excel2Html.D24.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F25.value=(Math.round((parseFloat(Excel2Html.F19.value)+parseFloat(Excel2Html.F20.value)+parseFloat(Excel2Html.F21.value)+parseFloat(Excel2Html.F22.value)+parseFloat(Excel2Html.F23.value)+parseFloat(Excel2Html.F24.value))* 100000000000000))/ 100000000000000 ;
Excel2Html.F26.value=(Math.round((parseFloat(Excel2Html.F18.value)+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))* 1E+15))/ 1E+15 ;
Excel2Html.F30.value=(Math.round((parseFloat(Excel2Html.F26.value)+parseFloat(Excel2Html.F27.value)+parseFloat(Excel2Html.F28.value)+parseFloat(Excel2Html.F29.value))* 1E+15))/ 1E+15 ;
}
| Length | m | |||
| Width | m | |||
| Height | m | |||
| Volume | cum | |||
| Dry Volume | cum | |||
| Mix | ||||
| Cement | Cum | |||
| No of cement bag | Bag | |||
| Sand | Cum | |||
| Coarse aggregate | Cum | |||
| Prepared By:Parag Kamlakar Pal | ||||
| Description | Quantity & Number | Rate | Per | Amount |
| Cement | Bag | |||
| Sand | Cum | |||
| Coarse aggregate | Cum | |||
| Total | ||||
| Mistry | Day | |||
| Mason | Day | |||
| Male mazdoor | Day | |||
| Female mazdoor | Day | |||
| Bhisti | Day | |||
| Scaffolding | Sq.m | |||
| Total | ||||
| Total cost | ||||
| Water charges | Percentage | |||
| Machineries charges | Percentage | |||
| Contractor profit | Percentage | |||
| Total |

