20mm Aggregate Gradation Calculation Sheet

(As per IS 383)

This professionally designed Excel format is developed for accurate sieve analysis of 20mm graded coarse aggregate used in concrete works, strictly as per IS 383 – Specification for Coarse and Fine Aggregates from Natural Sources for Concrete.

The sheet automatically calculates percentage passing, cumulative values, and checks grading compliance with IS 383 limits.

Designed for real site and laboratory use in highway, bridge, and structural concrete projects.

IS Code Reference

• IS 383 – Specification for Coarse and Fine Aggregates

• Grading requirements for coarse aggregates (20mm nominal size)

• Applicable for concrete works, highway projects, and structural construction

What is 20mm Aggregate Gradation Test?

The gradation test determines the particle size distribution of coarse aggregate using standard sieves.

Proper grading ensures:

• Good workability of concrete

• Proper interlocking of aggregates

• Reduced void content

• Improved strength and durability

Non-compliance with IS 383 grading limits may result in:

• Poor concrete quality

• Segregation

• Reduced structural performance

• Consultant rejection

What This Excel Sheet Calculates

• Weight retained on each sieve

• Cumulative weight retained

• Percentage retained

• Percentage passing

• Automatic grading limit comparison (IS 383)

• Pass / Fail compliance indication

• Professional printable test report format

The sheet eliminates manual calculations and instantly verifies compliance.

How to Use the Sheet

1. Enter weight retained on each sieve.

2. Total sample weight calculates automatically.

3. % Retained and % Passing are generated instantly.

4. Compliance status (Pass/Fail) appears automatically.

5. Print the formatted laboratory report for submission.

No manual formula editing required.

Suitable For

• Highway Concrete Works

• Bridge & Structural Concrete

• RMC Plants

• EPC Contractors

• Authority Engineers / PMC

• Quality Control Laboratories

Key Benefits

✔ Fully automated calculations
✔ Reduces manual errors
✔ Saves time in site testing
✔ Ready for consultant/client submission
✔ Clean professional reporting format
✔ Designed for practical project use

Frequently Asked Questions (FAQ)

Is this sheet based on IS 383?

Yes, grading limits are aligned with IS 383 specifications for 20mm aggregate.

Can it be used for National Highway projects?

Yes, it is suitable for NH, State Highway, and infrastructure projects.

Does it automatically check grading compliance?

Yes, the sheet compares entered values with IS 383 limits and indicates Pass/Fail.

Is it suitable for RMC plants?

Yes, it is ideal for routine quality control in RMC and batching plants.

🔒 License & Usage Terms

This Excel sheet is licensed for single-user use only.

By purchasing and downloading this product:

• You are granted a non-transferable license for personal or organizational use.

• Redistribution, resale, sharing, uploading to public platforms, or forwarding to third parties is strictly prohibited.

• Modification for internal project use is permitted; however, resale in any form (modified or unmodified) is not allowed.

• Unauthorized distribution may result in legal action and permanent access restriction.

For team or company-wide usage, please purchase additional licenses or contact us for bulk licensing options.