Concrete mix design has to be performed to find out mix
ratio of concrete element to acquire target strength for a specified job e.g.
structure. For different structure different strength of concrete are used. As
example, strength of concrete for high rise building or important class
building and low rise or relatively less important buildings are not same.
That's why mix design of concrete need to be done to get the desired strength
of concrete.
We know the fundamental elements of concrete are water, cement,
fine aggregate ( mainly sand), and coarse aggregate ( brick or stone chips). So
by the consequences of the mix design, ratio of these things are obtain to get
expected concrete strength. And then present those amount as a ratio. May be
the ratio looks like this:
Water : cement : sand : brick/stone
Or just like this
Cement : sand : brick/stone
There are many programs & and spreadsheet are available
over Internet to calculate mix design. Those are varies according to design
code such as ACI, IS, BS standard etc. And also differs in unit
system like as English or Metric. Today I am going to share a
spreadsheet to calculate mix design. This sheet is according to ACI Code. The
good thing is that, this sheet is available with both unit system. This sheet is
made to calculate the Mix Design Ratio and Further calculation of Quantity of
materials.
Sheet Specifications are:
Code: ACI 211.1-91
Unit: English & SI
This sheet is able to calculate MIX ratio for air and
non-air en-trained concrete under freezing & thawing and salt water
condition. Thin Structure consideration also added.
This is a macro enabled Excel file. You need to Enable excel macro to use this sheet.
This is first version of this sheet. It may have some bug.
I’ll keeping it update regularly.
Thanks for visiting this post.