Scribd
Upload
60 views16 pages

Is 10262 2009

The document outlines an Excel sheet for Indian Standard Concrete Mix Design, detailing parameters such as concrete grade, cement content, water-cement ratio, and aggregate proportions. It includes calculations for targeted strength, water content adjustments, and final mix proportions for both concrete with and without fly ash. The document is prepared by Chinmay R. Shah and invites user feedback.

Uploaded by

Muthyalu Punna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
60 views16 pages

Is 10262 2009

The document outlines an Excel sheet for Indian Standard Concrete Mix Design, detailing parameters such as concrete grade, cement content, water-cement ratio, and aggregate proportions. It includes calculations for targeted strength, water content adjustments, and final mix proportions for both concrete with and without fly ash. The document is prepared by Chinmay R. Shah and invites user feedback.

Uploaded by

Muthyalu Punna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 16

EXCEL SHEET FOR INDIAN STANDARD

Prepared By: Chinmay R. Shah (Email ID: sh


INDICATES USER DEFINED VALUES
INDICATES FINAL VALUES

Grade of Concrete 40 Specific Gravity

Nominal Size of
10 mm Cement
Coarse Aggregate

Min. Cement
300 kg/m3 Coarse Aggregate
Content
Max. Water Cement
0.4 Fine Aggregate
Ratio
Workability (mm) 100 mm
Method of Placing Pump
Max. Cement Zone of Fine
kg/m3
Content Aggregate
Admixture Superplasticizer
Superplasticizer
Water Reduction (in 29
%)

Zone
Nominal Size
IV III II I
10 0.5 0.48 0.46 0.44
20 0.66 0.64 0.62 0.6
40 0.75 0.73 0.71 0.69

Targeted Strength for Mix


Step:1 Step: 2
Proportioning
Given W/C Ratio
Min. Allowable
fck' 48.25 N/mm2
W/C Ratio
Final W/C Ratio

Step: 3 Water Content Step: 5

Max. Water Content 208


Zone
I
Correction 1: For
220.48
Slump
CA/TA
Correction 2: For
156.5408 kg/m3
admixture
Correction

Final Water Content: 156.5408 kg/m3

Corrected Value of
CA/TA
Step: 4 Cement Content
Correction for
Cement Content: 411.95 kg/m3
Placing

Check against max.


0 kg/m3
Cement Content:

Final Cement Final Value of


411.95 kg/m3
Content: CA/TA

Final Value of
FA/TA
Step 6: Proportioning

Vol. of Concrete 1 m3

Vol. of Cement 0.1308 m3

Vol. of Water 0.1565 m3


Unit Weight of
Concrete

Mass of Admixture 8.2390 kg

Vol. of Admixtures 0.0072 m3 FINAL PROPORTION

Vol. of All in
0.7055 m3 C:S:A
Aggregate

Mass of CA 800.2749 kg

Mass of FA 1132.7562 kg
L SHEET FOR INDIAN STANDARD CONCRETE MIX DESIGN (WITHOUT FLY ASH)
By: Chinmay R. Shah (Email ID: shhchnmy@gmail.com). Kindly mail your feedback

Specific Gravity Table 1: Standard Deviation

3.15 Strength Std. Dev

2.74 10
3.5
2.74 15

20
4
25

I 30

35

40 5

45
50
55

Water Cement Ratio


0.4

0.35

0.38 THE USER SHOULD INPUT THE VALUE IF IT IS OTHER


THAN THE MIN. ALLOWABLE W/C RATIO. DO NOT
GO BELOW 0.38
Coarse/Total Aggregate Ratio

Size Fraction
10 0.44

0.44
0.02

0.46

0.414

0.414

0.586

2501.53 kg/m3

FINAL PROPORTION

1 : 2.75 : 1.95
A
1.95

Max. Water Content

Water
Nom. Size Content
(kg/m3)

10 208

20 186

40 165
50

6
W/C

0.38

1 0.02
EXCEL SHEET FOR INDIAN STANDARD
Prepared By: Chinmay R. Shah (Email ID: sh
INDICATES USER DEFINED VALUES
INDICATES FINAL VALUES

Grade of Concrete 40 Specific Gravity

Nominal Size of
20 mm Cement
Coarse Aggregate

Min. Cement
320 kg/m3 Coarse Aggregate
Content
Max. Water Cement
0.45 Fine Aggregate
Ratio
Workability (mm) 100 mm Fly Ash
Method of Placing Pump
Max. Cement Zone of Fine
kg/m3
Content Aggregate
Admixture Superplasticizer
Superplasticizer
Water Reduction (in 29
%)

Fly Ash Content (%) 30

Zone
Nominal Size
IV III II I
10 0.5 0.48 0.46 0.44
20 0.66 0.64 0.62 0.6
40 0.75 0.73 0.71 0.69

Targeted Strength for Mix


Step:1 Step: 2
Proportioning
Given W/C Ratio
Min. Allowable
fck' 48.25 N/mm2
W/C Ratio
Final W/C Ratio

Step: 3 Water Content Step: 5

Max. Water Content 186


Zone
I
Correction 1: For
197.16
Slump
CA/TA
Correction 2: For
139.9836 kg/m3
admixture
Correction

Final Water Content: 139.9836 kg/m3

Corrected Value of
CA/TA
Step: 4 Cement Content
Correction for
Cement Content: 349.959 kg/m3
Placing

Check against max. Final Value of


0 kg/m3
Cement Content: CA/TA

Final Cement
Final Value of
Content (if no Fly 349.959 kg/m3
FA/TA
Ash):

Fly Ash Calculation

Cementitious
384.955 kg/m3
Content

New W/C Ratio 0.37

Fly Ash Content 115.49 kg/m3

Cement Content 234.469 kg/m3

Final Fly Ash Content 115.49 kg/m3

Final Cement
234.469 kg/m3
Content

Step 6: Proportioning

Vol. of Concrete 1 m3

Vol. of Cement 0.1111 m3

Vol. of Water 0.1400 m3


Vol. of Fly Ash 0.1000 m3
Unit Weight of
Concrete

Mass of Admixture 6.9992 kg

Vol. of Admixtures 0.0061 m3 FINAL PROPORTION

Vol. of All in
0.6428 m3 C:S:A
Aggregate

Mass of CA 982.7982 kg

Mass of FA 778.4889 kg
L SHEET FOR INDIAN STANDARD CONCRETE MIX DESIGN (WITHOUT FLY ASH)
By: Chinmay R. Shah (Email ID: shhchnmy@gmail.com). Kindly mail your feedback

Specific Gravity Table 1: Standard Deviation

3.15 Strength Std. Dev

2.74 10
3.5
2.74 15

1.2 20
4
25

I 30

35

40
5

45

50
55

Water Cement Ratio


0.45

0.4

0.4 THE USER SHOULD INPUT THE VALUE IF IT IS OTHER


THAN THE MIN. ALLOWABLE W/C RATIO. DO NOT
GO BELOW 0.38
Coarse/Total Aggregate Ratio

Size Fraction
20 0.6

0.6

0.02

0.62

0.558

0.558

0.442
2251.23 kg/m3

FINAL PROPORTION

1:2.23:2.81
Max. Water Content

Water
Nom. Size Content
(kg/m3)

10 208

20 186

40 165

You might also like