Concrete Mix Design Template (1).xlsx

	F	G	H	I	J	K	L
1	Concrete Mix Design (As per IS 10262:2019 & IS 456:2000)
2	Created By: Parag Pal

3	A. STIPULATIONS FOR PROPORTIONING
4	Project Name	XYZ Consruction
5	Client / Owner	Parag
6	Contractor	ABC Contractor
7	Grade Designation (e.g., M25)	40	N/mm²	Enter grade like M20, M25, etc.
8	Type of Cement (e.g., OPC 43, PPC)	OPC 43		As per project spec
9	Max. Nominal Size of Aggregate	25.00	mm	Typically 10mm, 20mm or 40mm
10	Min. Cement Content (Table 5, IS 456)	300.00	kg/m³	Depends on exposure condition
11	Max. Water-Cement Ratio (Table 5, IS 456)	0.50		Depends on exposure condition
12	Workability Required (Slump)	110.00	mm	Target slump at site
13	Exposure Condition (IS 456)	Moderate		Mild, Moderate, Severe, Very Severe, Extreme
14	Method of Concrete Placing	Manual		Manual, Pumpable, Tremie etc.
15	Degree of Site Control	Good		Good/Fair
16	Type of Aggregate	Crushed Angular		E.g., Crushed Angular, Rounded
17	Chemical Admixture Type (if any)	Superplasticizer		E.g., Superplasticizer, Retarder
18	Max. Cement Content (Clause 8.2.4.2, IS 456)	450.00	kg/m³	Usually 450 kg/m³
19
20	B. TEST DATA FOR MATERIALS
21	B1. Cement Data
22	Specific Gravity of Cement	3.15
23	B2. Coarse Aggregate (CA) Data
24	Specific Gravity of CA (SSD)	2.74
25	Water Absorption of CA	0.50	%
26	Free (Surface) Moisture of CA	0.00	%	(Nil for SSD design, input actual for field)
27	B3. Fine Aggregate (FA) Data
28	Specific Gravity of FA (SSD)	2.65
29	Water Absorption of FA	1.00	%
30	Free (Surface) Moisture of FA	0.00	%	(Nil for SSD design, input actual for field)
31	FA Conforming to Grading Zone (IS 383)	Zone II		Table 9, IS 383
32	B4. Admixture Data (if used)
33	Specific Gravity of Admixture	1.10		From manufacturer data
34	Recommended Dosage	1.00	% by wt. of cement	From manufacturer data
35	Water Reduction due to Admixture	10.00	%	From manufacturer data / trials
36
37	C. TARGET MEAN COMPRESSIVE STRENGTH (f'm)
38	Characteristic Compressive Strength (fck) at 28 days	0.00	N/mm²	(Derived from B7)
39	Assumed Standard Deviation (s)	3.50	N/mm²	User to verify from Table 2, IS 10262:2019
40	Target Average Compressive Strength (f'm = fck + 1.65s)	5.78	N/mm²
41
42	D. SELECTION OF WATER-CEMENT RATIO
43	Max. W/C Ratio (from A.8, based on IS 456 Table 5)	0.50
44	Adopted Water-Cement Ratio	0.45		Should be <= B43. Check Fig.1 IS10262 for target strength.
45
46	E. SELECTION OF WATER CONTENT
47	Approx. Water Content (Table 4, IS 10262)	186.00	kg/m³	For B9mm agg & 25-50mm slump. Adjust for slump B12mm (±3% per 25mm change)
48	Estimated Water Content after admixture reduction (if any)	167.40	kg/m³
49
50	F. CALCULATION OF CEMENT CONTENT
51	Calculated Cement Content	372.00	kg/m³
52	Check against Min. Cement Content (from A.7)	OK		Min required: B10 kg/m³
53	Check against Max. Cement Content (from A.15)	OK		Max allowed: B18 kg/m³
54	Adopted Cement Content	400.00	kg/m³	Verify this is <= B18
55
56	G. PROPORTION OF VOLUME OF CA & FA
57	Vol. of CA per unit Vol. of Total Agg. (Table 5, IS 10262)	0.63		For B9mm agg, B31 FA. Adjust per Table 5 for W/C, FA Zone, pumpability (-10% for pumpable).
58	Adopted Volume of Coarse Aggregate (fraction)	0.63
59	Volume of Fine Aggregate (fraction = 1 - Vol. CA)	0.37
60
61	H. MIX CALCULATIONS (PER m³ OF CONCRETE - SSD BASIS)
62	a) Volume of Concrete (assumed)	1.00	m³
63	b) Volume of Cement	0.13	m³
64	c) Volume of Water	0.17	m³
65	d) Volume of Admixture (if any)	0.00	m³
66	e) Volume of All-in Aggregates (a-(b+c+d))	0.70	m³
67	f) Mass of Coarse Aggregate (SSD)	1211.76	kg
68	g) Mass of Fine Aggregate (SSD)	688.29	kg
69
70	I. MIX PROPORTIONS FOR TRIAL NO. 1 (Quantities per m³ - SSD Basis)
71	Cement	400.00	kg/m³
72	Water	167.40	kg/m³
73	Fine Aggregate (SSD)	688.29	kg/m³
74	Coarse Aggregate (SSD)	1211.76	kg/m³
75	Admixture (if any)	4.00	kg or L/m³	Unit depends on admixture form
76	Water-Cement Ratio (by mass)	0.42
77	Mix Ratio (Cement:FA:CA by mass)	1 : 1.72 : 3.03
78
79	J. ADJUSTMENTS FOR FIELD CONDITIONS (MOISTURE)
80	Mass of FA (SSD basis from I)	688.29	kg/m³
81	Mass of CA (SSD basis from I)	1211.76	kg/m³
82	Mass of Water (SSD basis from I)	167.40	kg/m³
83	Free (Surface) Moisture in FA (from B3)	0.00	%	Update in B3
84	Free (Surface) Moisture in CA (from B2)	0.00	%	Update in B2
85	Adjusted Mass of FA for batching	688.29	kg/m³
86	Adjusted Mass of CA for batching	1211.76	kg/m³
87	Adjusted Mass of Water for batching	167.40	kg/m³
88
89	K. QUANTITIES FOR BATCH (e.g., PER 50KG CEMENT BAG - FIELD CONDITIONS)
90	Cement (1 bag)	50.00	kg
91	Fine Aggregate (Adjusted)	86.04	kg
92	Coarse Aggregate (Adjusted)	151.47	kg
93	Water (Adjusted)	20.93	L or kg
94	Admixture (if any)	0.50	kg or L
95
96	L. TRIAL MIX RESULTS & ADJUSTMENTS
97	Trial No.	Date	Slump (mm)	Density (kg/m³)	7-Day Str. (N/mm²)	28-Day Str. (N/mm²)	Remarks
98
99
100