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

Dnyan Deshmukh

Staff member
I am Civil Engineer from Somalia I want to use design EXCEL but I cannot use, how I can use???
Download the excel shit and open it on your Laptop or PC, after opening the excel sheet / program, it will ask you to enable micros, do enable micros and start using it.

Excel sheet program have micros on it to do calculations, once you enable it, it will allow program to work correctly, it may not work on mobile if the mobile application does not have micro enable feature.
 
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.
Thanks for sharing , its really helpful
 

Krishna22

Apprentice
Sir
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.
 
Respected Sir,
I have been in this field of imparting technical education especially Civil Engineering, to my students since 2016. Even beingBachelor and Masters holder in Civil Engineering discipline, I didn't have a clue about such technological advancement. I am so happy and proud as well to observe that such wonderful programmed excel sheets are being developed to undertake the concrete mix design calculations.
I really appreciate and salute such great initiative which will not only help budding civil engineers in their practical industry-oriented works, but also this initiative will really benefit young researchers and civil engineering students.

With regards,

Prof. Saurav Kar,
Asst. Prof., Department of Civil Engineering.
 
  • Like
Reactions: Dnyan Deshmukh
thanks for the sharing!!!
pls, insert the central zone also in your sheet...
also in your format, there is a term of "MOST"(in the selection of method ) is this indicate the "MORTH" or what ??
Pls, answer...
 

guguna08

Newbie
Dear Mr Desmukh,
It was indeed a pleasure to be in the team where professional like you and many other fellow members share valuable construction information,which is a bliss in this generation.
Please accept my regards of appreciation for the splendid contribution in sharing real time data.
Hats up to your spirit of sharing knowledge.
Regards,
Subhendu Sahoo
+91 7032433342
 
  • Like
Reactions: Dnyan Deshmukh

Bandya

Apprentice
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.
Excellent work done Dnyan Deshmukh. This will help many of us.
 
  • Like
Reactions: Dnyan Deshmukh

Dnyan Deshmukh

Staff member
pls, insert the central zone also in your sheet...
Currently not in role of mix designing, so cant spend time on collection of data and figuring out what to adjust.

there is a term of "MOST"(in the selection of method ) is this indicate the "MORTH" or what ??
Yes you guess that right.


password please .please provide me the password. its urgent
To the best of my knowledge, this file is not having any password nor it prompts for password.
 
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.
Sir please share me Excel sheet on my email I'd mukhtar.ahmad.org@gmail.com