How to decide size of water tank ?

Dear Friends ,

It’s a week since we met here.

Today , we shall take one problem .

We shall find out the following for a Multistoreyed building :

1. Water storage requirement 
2. Water tank size { various options ]
3. Internal Dimensions for the Given water tank
4. External Dimensions for the water tank

Let us write down the exact issue :

Hope with this guideline , you can plan and design the water tank for your project.

Blog Stats for reference :

In case of any queries on facilities planning , please contact me here :

Name(required)

Email(required)

Comment(required)

Submit

Δ

BACK TO BASICS….4 Questions for you !

Hi friends ,

Good Morning !

Hope you are enjoying the growing cold in the region.

Today we shall ask ourselves a few basic questions and see whether we can answer them or not ?

Sometime in our quest to learn new things , we simply forget the basics.

Ready ?

Here we go !

So you are ready with the answers ?

Check out from the solutions given below :

In case you have any queries on the above solutions , do write to me using this form :

Name(required)

Email(required)

Comment(required)

Submit

Δ

Blog Stats for reference :

Ready template for Internal Plaster

Hello Friends ,

We have been talking about preparing templates for various civil works .

In the previous article, we saw how to prepare a template for Rate analysis for cement concrete of M20 grade.

This is the link for your quick reference : Link

Today , let me share with you a template for Internal plaster.

In this template , you need to feed the following inputs :

1. Room dimensions [ length , breadth and height ]
2. Details of the openings 
3. Mortar mix for the plaster
4. Thickness of the plaster
5. Material rates

The template shall immediately give you :

1. Total material cost for the plaster
2. Rate of plaster in Rs/sqm & Rs/sqFt.

If you want , you can also know :

1. Area of roof plaster 
2. Area of wall plaster
3. Deductions
4. Mortar volume required
5. Materials required

This is the template for your study :

Hope you are able to able to prepare similar templates yourselves for your day to day applications at site.

In case of any queries , you are most welcome to contact me using this form here :

Name(required)

Email(required)

Comment(required)

Submit

Δ

Bye Bye

Have a nice day.

Blog Stats for future reference :

 

Ready template for Rate Analysis

Dear Friends ,

Let us develop a great template for Rate analysis.

If you prepare this template and maintain on your lap top , you can work out so many variations  of this rate analysis . This shall boost your efficiency .Not only this , you shall be able to support your team in arriving at the accurate decision making during tender analysis. Your negotiation process shall also be quite effective.

In case the clients need a supporting rate analysis from you , you can submit a print out of this MS Excel sheet.

Believe me , if you can do this , you can win the confidence of your clients .

Now let us take a specific case ;

The variable are listed as under :

1. All the material rates
2. Material wastages
3. Labour, Administration , Tools & plants , Contingencies, Profit % 

As you know , if there is a slight variation in any of these factors , there shall be an effect on the complete rate of the item.

First look at this template .

This is self-explanatory :

Try preparing a similar template yourselves .

The effect on the rate whenever you revise any of these variables can be determined within the fraction of a second.

All the best !

In case of any queries , do contact me using this form :

 

Name(required)

Email(required)

Comment(required)

Submit

Δ

Blog Stats for future reference :

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 :
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. 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]
2. 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 .

Please give me your feedback /suggestions through this form here :

Name(required)

Email(required)

Comment(required)

Submit

Δ

Thank you so much !

Blog stats at the time of publishing this blog :