20mm + 10mm Aggregate Combined Gradation Calculation Sheet
(For Concrete Works – As per IS 383)
This professionally developed Excel format is designed to calculate the combined sieve analysis of 20mm and 10mm graded coarse aggregates used in concrete mix design.
The sheet automatically computes weighted percentage passing values based on your selected blending ratio (e.g., 60:40, 65:35, 70:30, etc.) and checks grading compliance with IS 383 specifications.
It is specially designed for real project execution, laboratory testing, and mix design verification in highway and structural concrete works.
IS Code Reference
IS 383 – Specification for Coarse and Fine Aggregates for Concrete
Grading requirements for combined coarse aggregates
Applicable for concrete works in highways, bridges, and infrastructure projects
Why Combined Gradation is Important in Concrete?
In practical concrete production, 20mm and 10mm aggregates are blended to achieve:
Better particle packing
Reduced voids
Improved workability
Optimized cement consumption
Higher strength and durability
Incorrect blending can lead to:
Poor concrete performance
Segregation
Excess cement demand
Consultant rejection during QA/QC checks
This sheet eliminates manual blending errors and instantly verifies grading compliance.
What This Excel Sheet Calculates
Individual sieve analysis for 20mm aggregate
Individual sieve analysis for 10mm aggregate
Automatic weighted combined gradation
Blending ratio-based % passing calculation
IS 383 grading limit comparison
Clear Pass / Fail compliance indication
Print-ready professional laboratory report
How the Weighted Calculation Works
The sheet uses the blending ratio to compute combined gradation:
Combined % Passing =
(% Passing of 20mm × Proportion of 20mm) +
(% Passing of 10mm × Proportion of 10mm)
You only need to:
Enter sieve data for 20mm aggregate
Enter sieve data for 10mm aggregate
Select or enter blending ratio
The sheet calculates combined results automatically
No manual formula application required.
How to Use the Sheet
Input retained weights for 20mm aggregate.
Input retained weights for 10mm aggregate.
Enter blending ratio (e.g., 60:40).
Combined gradation and compliance status appear instantly.
Print the formatted report for submission.
Suitable For
Highway Concrete Works
Bridge Construction Projects
RMC / Batching Plants
EPC Contractors
PMC & Authority Engineers
Quality Control Laboratories
Mix Design Engineers
Key Benefits
✔ Saves manual calculation time
✔ Eliminates blending mistakes
✔ Reduces risk of grading rejection
✔ Ready for site and consultant submission
✔ Clean, professional presentation format
✔ Designed for real infrastructure projects
Frequently Asked Questions (FAQ)
Is this sheet based on IS 383?
Yes, grading limits are aligned with IS 383 for combined coarse aggregates.
Can I change the blending ratio?
Yes, you can enter any custom ratio (e.g., 55:45, 70:30, etc.).
Is this useful for RMC plants?
Yes, it is highly useful for daily production control and mix verification.
Does it automatically show Pass/Fail?
Yes, compliance with grading limits is displayed instantly.
🔒 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.
Internal modification for project use is permitted; resale in any form (modified or unmodified) is not allowed.
Unauthorized distribution may result in legal action and permanent access restriction.
For team-wide or company-wide usage, please purchase additional licenses or contact us for bulk licensing.
