# FOOTING COST on M.S. Excel ?

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.

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 :

1. Cement : Rs.CCC per bag
2. Artificial Sand :Rs.SSS per brass
3. River Sand :Rs.RRR  per brass
4. Aggregate : Rs. AAA per brass

The composition of River and Crushed sand is : X and Y. ( X +Y =100 or Y = 100-X )

[ This means that if we assume River sand factor X to be 50 % , The crushed sand to be mixed shall be 100-50 =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 :

1. Open a new MS Excel sheet on your laptop or Desktop and prepare the following table :
2. The Volume of footing shall be  calculated automatically once we put numeric values for the dimensions
3. 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.
4. 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 :

1. Footing Dimension 01 [ P ]
2. Footing Dimension 02 [ Q ]
3. Footing Dimension 03 [ R ]
4. Grade of concrete [GG ]
5. Composition of river and crushed sand [ X % & Y% ]
6. Density of Rebars in the concrete [DDD ]
7. Consumption of Binding wire [B%]
8. Consumption of Plasticizer [PS]
9. Rate of Cement [ CCC ]
10. Rate of Crushed Sand [SSS ]
11. Rate of River sand :[RRR ]
12. Rate of Aggregate [ AAA ]
13. rate of Binding wire [BW ]
14. Rate of Rebars [WWW ]
15. Rate of Plasticizer [PPP]

Now , let us say , on your site , the following values have been determined :

1. Footing Dimension 01 [ P =1200 mm ]
2. Footing Dimension 02 [ Q=1200 mm  ]
3. Footing Dimension 03 [ R= 1200 mm ]
4. Grade of concrete [GG =30 ]
5. Composition of river and crushed sand [ X =50 %  & Y=50 % ]
6. Density of Rebars in the concrete [DDD = 100 Kg/CuM  ]
7. Consumption of Binding wire [B= 1 %]
8. Consumption of Plasticizer [PS= 80 ml /bag ]
9. Rate of Cement [ CCC = Rs 300 per bag ]
10. Rate of Crushed Sand [SSS= Rs. 3800 per brass ]
11. Rate of River sand :[RRR= Rs. 4600 per brass ]
12. Rate of Aggregate [ AAA= Rs.2500 per brass  ]
13. rate of Binding wire [BW= Rs. 50 per kg ]
14. Rate of Rebars [WWW = Rs. 38000 per MT ]
15. Rate of Plasticizer [PPP= Rs.100 per litre]
1. 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 re-calculate 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 :

1. Footing Dimension 01 [ P =1200 mm ]
2. Footing Dimension 02 [ Q=1200 mm  ]
3. Footing Dimension 03 [ R= 1200 mm ]
4. Grade of concrete [GG =30 ]
5. Composition of river and crushed sand [ X =50 %  & Y=50 % ]
6. Density of Rebars in the concrete [DDD = 90 Kg/CuM  ]
7. Consumption of Binding wire [B= 1 %]

Following values have been revised :

1. Consumption of Plasticizer [PS= 85 ml /bag ]
2. Rate of Cement [ CCC = Rs 310 per bag ]
3. Rate of Crushed Sand [SSS= Rs. 3900 per brass ]
4. Rate of River sand :[RRR= Rs. 4500 per brass ]
5. Rate of Aggregate [ AAA= Rs.2400 per brass  ]
6. rate of Binding wire [BW= Rs. 45 per kg ]
7. Rate of Rebars [WWW = Rs. 37000 per MT ]
8. 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 .