Concrete Mix Design Excel Program up to M85 Grade - Now do it in easy steps

Dnyan Deshmukh

Staff member
Concrete Mix Design Excel Program
As we know the concrete ingredients properties are not same in all area, so the properties of ingredient affects the mix design and a designed made at some place in KanyaKumari can not be used at Kashmir.
So referring a design made by someone for his work at other places may not give you result as intended at your place.

This concrete mix design program is specifically made for India Only as per the ingredient properties available in all places.
This may be useful out side of India too (As the data is not hard coded and can get modify if you put correct properties of materials)
We divided India into four parts as North East West and South for easy evaluation.
With this you can design concrete up to M 85 Grade (If you know basics, you can design it with this program)
To learn the art of concrete mix design and clear the concepts about it you can go through Best article by Clicking Here.

This works on principles of IS 456 and MOST. With this program you can design concrete mix as per IS456, MOST and your technical specification if have any.

This is for professional designer who understand the designing process, as it need all inputs on ingredients.
Request all student to understand the concrete mix design process by going through article Become concrete master posted at forum, after that if you have any difficulties in using it, kindly do post about it in this thread.

This excel program runs with micros, so when you open sheet it is must to enable micros to allow program to do calculation on your input and its operation.

When you open program it will open its index page as shown below.

Concrete Mix App Index.png

It basically consist of 5 steps to get the final output of your design.

You need to fill the basic data of ingredient, when you click on 1st button it will open a below data entry form.

Basic Data Mix Design app.png
There are some drop downs and text fields with green color. You need to enter the data in green fields.

After that go back to index and click on 2nd button, it will open the below form.

FA Sieve Analysis Input.png
According to your choice of Fine Aggregates 1 or 2 type, you need to fill the sieve analysis form and again go back to index.

Click on 3rd button, it will open below form.

CA SA Input.png
Same with coarse aggregates, fill the sieve analysis form and go back to index page.

Click on the 4th button and review the combine gradation as per the standards you want to refer.
Combine Gradation.png

You can adjust proportion by changing total CA % in green bar, after that go back to index.

When you click on the 5th button a complete mix design sheet will open.
mix design 1.png
Mix Design2.png

Add your company logo in red text area and take the print of it.

Any mix design created on paper need to be verified by doing trials on it before using directly at construction project.
Mix Designs should be use only after getting satisfactory outcomes from trials.

After doing trails, you need to adjust some ingredient to meet the fresh concrete desired properties (if required any, to learn more about this you can go to the article, whose link is given in this post at top).

The Concrete Mix Design Excel Program is attached in this post.

This is a smart program and does fast calculation, so you need to provide correct input to get correct result.
It do not have logic like us, so will give you false result on false input.


If you are a concrete mix designer and have some suggestions or can help us in improving this program further or find any miscalculation or missing formulas, kindly contact us.
We will update it and release the new version of it.

This is in the interest to share knowledge with all for betterment of Civil Engineering Community.
 

Attachments

  • C4M Concrete mix designer Updated on 03.04.18.xlsm
    161.8 KB · Views: 10,494

Dnyan Deshmukh

Staff member
Can it not be used in pakistan
You can use it at any place, provided you give the correct inputs in data entry as per the materials properties at your place.

You can take trials of the mix after doing designing in program, if you find any non conformance, kindly revert here so that we can improve the designing calculation further more by finding the causes.
 
Please what if i need to change the code,because i try to change it now ,it reply me that it protected. i want to design to BS CODE please.
 
  • Like
Reactions: atisan

Dnyan Deshmukh

Staff member
Please what if i need to change the code,because i try to change it now ,it reply me that it protected. i want to design to BS CODE please.
You can do it, by changing the properties of material.

By default the codes are Indian and MOST, it only help to check the limits as per guidelines and only worn about limits ( This you can check manually with relevant standards).
 
  • Like
Reactions: akinade

VIDHYA SAGAR

Senior Member
By reading this, it is a excellent and easy to understand regarding mix design.
It will be really useful to me.
Sir, How can I use this.
After downloading I am unable to enter the values to design.
Pls advise.
Regards,
Vidhyasagar.
 

Dnyan Deshmukh

Staff member
By reading this, it is a excellent and easy to understand regarding mix design.
It will be really useful to me.
Sir, How can I use this.
After downloading I am unable to enter the values to design.
Pls advise.
Regards,
Vidhyasagar.
Check, you have enable editing, as excel prevent editing in downloaded excel files.

Also do ensure you enable micros when it prompt, do check below the tabs for prompts given by excel program.
 

MAR

Founder Member
Concrete Mix Design Excel Program
As we know the concrete ingredients properties are not same in all area, so the properties of ingredient affects the mix design and a designed made at some place in KanyaKumari can not be used at Kashmir.
So referring a design made by someone for his work at other places may not give you result as intended at your place.

This concrete mix design program is specifically made for India Only as per the ingredient properties available in all places.
This may be useful out side of India too (As the data is not hard coded and can get modify if you put correct properties of materials)
We divided India into four parts as North East West and South for easy evaluation.
With this you can design concrete up to M 85 Grade (If you know basics, you can design it with this program)
To learn the art of concrete mix design and clear the concepts about it you can go through Best article by Clicking Here.

This works on principles of IS 456 and MOST. With this program you can design concrete mix as per IS456, MOST and your technical specification if have any.

This is for professional designer who understand the designing process, as it need all inputs on ingredients.
Request all student to understand the concrete mix design process by going through article Become concrete master posted at forum, after that if you have any difficulties in using it, kindly do post about it in this thread.

This excel program runs with micros, so when you open sheet it is must to enable micros to allow program to do calculation on your input and its operation.

When you open program it will open its index page as shown below.

View attachment 985

It basically consist of 5 steps to get the final output of your design.

You need to fill the basic data of ingredient, when you click on 1st button it will open a below data entry form.

View attachment 986
There are some drop downs and text fields with green color. You need to enter the data in green fields.

After that go back to index and click on 2nd button, it will open the below form.

View attachment 987
According to your choice of Fine Aggregates 1 or 2 type, you need to fill the sieve analysis form and again go back to index.

Click on 3rd button, it will open below form.

View attachment 988
Same with coarse aggregates, fill the sieve analysis form and go back to index page.

Click on the 4th button and review the combine gradation as per the standards you want to refer.
View attachment 989

You can adjust proportion by changing total CA % in green bar, after that go back to index.

When you click on the 5th button a complete mix design sheet will open.
View attachment 990
View attachment 991

Add your company logo in red text area and take the print of it.

Any mix design created on paper need to be verified by doing trials on it before using directly at construction project.
Mix Designs should be use only after getting satisfactory outcomes from trials.

After doing trails, you need to adjust some ingredient to meet the fresh concrete desired properties (if required any, to learn more about this you can go to the article, whose link is given in this post at top).

The Concrete Mix Design Excel Program is attached in this post.

This is a smart program and does fast calculation, so you need to provide correct input to get correct result.
It do not have logic like us, so will give you false result on false input.


If you are a concrete mix designer and have some suggestions or can help us in improving this program further or find any miscalculation or missing formulas, kindly contact us.
We will update it and release the new version of it.

This is in the interest to share knowledge with all for betterment of Civil Engineering Community.
Nicely crafted article with excellent knowledge
 

Dnyan Deshmukh

Staff member
why this file is not opening in MS Excel plz solve sir
File opens correctly, i had checked it.

From where you are opening it. Mobile or pc.

If on mobile then use microsoft excel program, on opening you need to enable micros on it, once you enable micros, it will work (as program uses micros to run)

At top when you open sheet, you will see a prompt enable micros, you need to enable it.
 
  • Like
Reactions: Sumit Civil