Dear Friends ,
It has been almost a week that we met here.
Today let us do something different. we have estimated the cost of a footing earlier. However, today we shall see how to carry out the same calculations using the M.S.Excel.
Ready ?
Before we begin , let me narrate the exact problem :
Estimate the material cost for a Box footing of dimensions P*Q*R .
The Grade of concrete to be used is : M GG
GG can be any value between 20 to 60
[ This means , it can be a concrete of any grade between M20 TO M60 ].
The material rates are as follows :
 Cement : Rs.CCC per bag
 Artificial Sand :Rs.SSS per brass
 River Sand :Rs.RRR per brass
 Aggregate : Rs. AAA per brass
The composition of River and Crushed sand is : X and Y. ( X +Y =100 or Y = 100X )
[ This means that if we assume River sand factor X to be 50 % , The crushed sand to be mixed shall be 10050 =50 % ]
The ReBars density in the given RCC is given as : DDD Kg/CuM.
[ For a footing , DDD = 80 to 100 Kg/CuM ]
Rate of REBARS is : Rs. WWW per MT
Binding wire needed : B % of DDD. [ As you might remember , B = 1 % to 2 % of the Rebars weight ]
Rate of Binding wire is : Rs. BW per Kg
The Plasticizer to be added is : PPP Ml/bag of Cement
Rate of Plasticizer is : Rs. PS per Litre
So now with this data , let us try a hand at the calculations with MS Excel :
 Open a new MS Excel sheet on your laptop or Desktop and prepare the following table :
 The Volume of footing shall be calculated automatically once we put numeric values for the dimensions
 Now , you already know how to arrive at the proportion of the Cement, Sand and Aggregate in a concrete if the grade has been given.
 Make a table like this :
Once we put the numerical value of the grade in place of GG , we shall directly see the factor of sand in the given grade .
Now , make the following table which shows the consumption of the materials in 1 CuM of concrete of the given grade :
And ….yes…you are ready with the basic template.
In this example , there are 15 variables :
 Footing Dimension 01 [ P ]
 Footing Dimension 02 [ Q ]
 Footing Dimension 03 [ R ]
 Grade of concrete [GG ]
 Composition of river and crushed sand [ X % & Y% ]
 Density of Rebars in the concrete [DDD ]
 Consumption of Binding wire [B%]
 Consumption of Plasticizer [PS]
 Rate of Cement [ CCC ]
 Rate of Crushed Sand [SSS ]
 Rate of River sand :[RRR ]
 Rate of Aggregate [ AAA ]
 rate of Binding wire [BW ]
 Rate of Rebars [WWW ]
 Rate of Plasticizer [PPP]
Now , let us say , on your site , the following values have been determined :

 Footing Dimension 01 [ P =1200 mm ]
 Footing Dimension 02 [ Q=1200 mm ]
 Footing Dimension 03 [ R= 1200 mm ]
 Grade of concrete [GG =30 ]
 Composition of river and crushed sand [ X =50 % & Y=50 % ]
 Density of Rebars in the concrete [DDD = 100 Kg/CuM ]
 Consumption of Binding wire [B= 1 %]
 Consumption of Plasticizer [PS= 80 ml /bag ]
 Rate of Cement [ CCC = Rs 300 per bag ]
 Rate of Crushed Sand [SSS= Rs. 3800 per brass ]
 Rate of River sand :[RRR= Rs. 4600 per brass ]
 Rate of Aggregate [ AAA= Rs.2500 per brass ]
 rate of Binding wire [BW= Rs. 50 per kg ]
 Rate of Rebars [WWW = Rs. 38000 per MT ]
 Rate of Plasticizer [PPP= Rs.100 per litre]
 Now we simply need to enter this data into the templates we made earlier in the examples :
The proportion of materials in the concrete is as follows :
The composition of River and Crushed sand shall be :
Now , we need to just feed the data in the Summary template as follows :
Now suppose after a few weeks , your site reports to you that now the data has changed slightly due to various factors. And your boss wants you to recalculate the cost.
Dont worry. You shall now need less than a minute to tell him the revised cost.
Let us say , the new data is as follows :
Values which have remained constant :
 Footing Dimension 01 [ P =1200 mm ]
 Footing Dimension 02 [ Q=1200 mm ]
 Footing Dimension 03 [ R= 1200 mm ]
 Grade of concrete [GG =30 ]
 Composition of river and crushed sand [ X =50 % & Y=50 % ]
 Density of Rebars in the concrete [DDD = 90 Kg/CuM ]
 Consumption of Binding wire [B= 1 %]
Following values have been revised :
 Consumption of Plasticizer [PS= 85 ml /bag ]
 Rate of Cement [ CCC = Rs 310 per bag ]
 Rate of Crushed Sand [SSS= Rs. 3900 per brass ]
 Rate of River sand :[RRR= Rs. 4500 per brass ]
 Rate of Aggregate [ AAA= Rs.2400 per brass ]
 rate of Binding wire [BW= Rs. 45 per kg ]
 Rate of Rebars [WWW = Rs. 37000 per MT ]
 Rate of Plasticizer [PPP= Rs.95 per litre]
Just feed the new values in our Summary template :
Now you can promptly inform your boss that the rate of concrete has been reduced from Rs. 8404 per CuM to Rs.8388 per CuM.
Accordingly , the cost of the footing has come down slightly from Rs.14523 to Rs.14494.
So friends , with this template on your laptop , whenever , any of the data in the 15 variables is revised at site , you can proudly present the revised cost within a minute.
Hope you enjoyed this .
Please give me your feedback /suggestions through this form here :
Thank you so much !
Blog stats at the time of publishing this blog :