The concrete mix design excel sheet then calculates the quantities of fine and coarse aggregates. In phase four the designer inputs the density of the aggregate and the concrete mix design excel sheet uses this to calculate the density of the concrete mix.įinally for phase five the designer inputs the percentage of fine aggregate. The concrete mix design excel sheet then calculates the required cement content and adjusts it to suit the maximum and minimum cement requirements. Phase three requires the designer to input any maximum or minimum required cement contents.
The concrete mix design calculator excel sheet then uses this to calculate the required free water content to achieve this slump or vebe time. Next in phase two the designer inputs the required slump or vebe time. The concrete mix design excel sheet then calculates the required water-cement ratio for the mix. First the designer inputs the target compressive strength for the concrete mix design along with the cement type and aggregate types.
The concrete mix design process consists of 5 stages. This remains the most commonly used method of designing concrete mixes in the UK. This was published in the Design of Normal Concrete Mixes document in the 1970s and 1980s. However after many years of development the Building Research Establishment were able to derive a relatively straightforward standard procedure for the design of common concrete mixes.
This can make concrete mix design seem daunting to designers who do not complete the process regularly. Satisfying two or more different specification requirements can lead to the designer having to complete the calculations many times over until a balance is achieved. In some cases these are contradictory, for example strength and workability usually work against each other. The design of a concrete mix is extremely complicated as changing the volume or properties of any one component will affect all the others.Ĭoncrete specifications are also complex and often require the designer to create a concrete with several different properties including strength, workability, density and cost. Concrete is a very complex composite material consisting mostly of cement, water, aggregates and other property altering additives. This is our best value design bundle and can be purchased at the bottom of this page for only £50.Ĭoncrete mix design can be a complex and time consuming process. Alternatively this spreadsheet is included in the Concrete Design Suite which includes all of our reinforced concrete design spreadsheets. The CivilWeb Concrete Mix Design Spreadsheet can be purchased at the bottom of this page for only £20. The CivilWeb Concrete Mix Design Spreadsheet allows the designer to complete a fully compliant concrete mix design for any normal concrete specification in minutes, saving hours of detailed calculations for every concrete mix design. The spreadsheet allows the designer to specify all the requirements for the concrete mix such as strength and workability, and then the spreadsheet calculates the required cement content, water/cement ratio and aggregate requirements in order to meet all the specification requirements. The spreadsheet completes all the calculations in accordance with the BRE Normal Concrete Mix Design guidance. The CivilWeb Concrete Mix Design Spreadsheet is an easy to use spreadsheet which can be used to calculate the precise concrete mix requirements to suit a specification.