Tips to create a concrete calculator in excel for concrete mix design

In this exclusive construction video tutorial, you will learn how to create a concrete calculator in excel to find the required quantities of sand, cement and aggregates in 1m3.

With this excel based concrete calculator, it is possible to find out the quantities of materials for different grades of concretes like M10, M15, M20 etc.

Initially create table with different heads like Mix design, cement, sand, aggregate, sum of mix. It should be on first row. Then volume of concrete with input volume and dry volume. It should be on second row.

In third row, there should be cement quantity in different units like bags, cum, cuf, kg etc.

In fourth row, there should be sand quantity in cum, cft, kg etc.

In last row, there should be aggregate quantity in cum, cft, kg etc.

To learn the complete process for creating this concrete calculator with excel, go through the following video tutorial.

Video Source: Tutorials Tips