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.

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 :

  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 :4
  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 :

5

6.GIF

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 :

7.GIF

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 :

8.GIF

The proportion of materials in the concrete is as follows :

9

The composition of River and Crushed sand shall be :

10.GIF

Now , we need to just feed the data in the Summary template as follows :

11.GIF

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 :

12.GIF

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 :

IMG_20161024_102743.jpg

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s