DBM Grading-1 Gradation Calculation Excel Sheet
(As per MoRTH Specifications – Table 500-10)
Overview
This professionally designed Excel sheet is developed for Dense Bituminous Macadam (DBM) Grading-1 sieve analysis, strictly following MoRTH Specifications – Table 500-10, widely used in National Highway and State Highway projects.
The sheet automates sieve analysis calculations, compares results with the grading limits specified in Table 500-10, and generates a clean, consultant-ready printable report, eliminating manual errors and standardizing laboratory documentation.
It is designed for EPC contractors, Authority Engineers, Independent Engineers, and Asphalt Plant QC laboratories, making it ideal for quality control and audit-ready reporting.
What This Excel Sheet Calculates
- Weight retained on each sieve
- Cumulative retained weight
- Percentage retained
- Percentage passing
- Automatic comparison with MoRTH Table 500-10 grading limits
- Instant Pass / Fail compliance status
- Clean, professional printable report format
MoRTH Specification Reference
- ✔ Clause 507 – Dense Bituminous Macadam
- ✔ Table 500-10 – Grading Requirements for DBM
- ✔ Applicable for NH & State Highway Projects
What is DBM (Dense Bituminous Macadam)?
Dense Bituminous Macadam (DBM) is a binder/base course layer used in flexible pavement construction, laid below the Bituminous Concrete (BC) layer. It plays a critical role in:
- Load distribution
- Structural strength of pavement
- Long-term performance of flexible pavements
DBM is designed as per Clause 507 of MoRTH Specifications, and its aggregate gradation must strictly comply with Table 500-10.
Why Gradation Control is Critical in DBM
Proper gradation ensures:
- Adequate interlocking of aggregates
- Required void content
- Proper bitumen absorption
- Long-term pavement durability
- Prevention of rutting and cracking
Non-compliance with Table 500-10 may lead to:
- Mix rejection
- Poor compaction
- Premature pavement distress
- Consultant non-approval
This sheet eliminates such risks through automated compliance checking.
DBM Grading-1 – MoRTH Table 500-10 Overview
MoRTH Table 500-10 specifies grading limits for the following sieves: 45 mm, 37.5 mm, 26.5 mm, 13.2 mm, 4.75 mm, 2.36 mm, 0.3 mm, 0.075 mm.
The Excel sheet automatically checks your entered sieve results against these limits and provides instant compliance status.
How to Use the Sheet
- Enter weight retained on each sieve.
- Total weight calculates automatically.
- % Retained and % Passing generate instantly.
- Compliance check with Table 500-10 appears automatically.
- Print the formatted consultant-ready report.
- No manual formula editing required.
Suitable For
- National Highway EPC Projects
- Asphalt Mixing Plants
- Authority Engineer / IE / PMC
- Quality Control Laboratories
- Bituminous Work Contractors
Key Benefits
- ✔ Fully automated calculation
- ✔ Eliminates manual errors
- ✔ Table 500-10 limit auto-check
- ✔ Submission-ready professional format
- ✔ Designed for real highway project execution
Frequently Asked Questions (FAQ)
Q1. Is this sheet based on the latest MoRTH specification?
Yes, grading limits are aligned with MoRTH Table 500-10 for DBM Grading-1.
Q2. Can this be used for National Highway projects?
Yes. Suitable for NH, State Highway, and EPC projects.
Q3. Does it automatically check grading compliance?
Yes, the sheet compares your results with Table 500-10 limits and indicates Pass/Fail.
Q4. Is it suitable for asphalt plant QC labs?
Yes, it is designed for daily production quality control use.
License & Usage Terms
- Licensed for single-user or single-organization use only.
- Editable inputs are allowed for internal project use, but formulas are protected.
- Redistribution, resale, sharing, or forwarding to third parties is strictly prohibited.
- Unauthorized distribution may result in legal action and permanent access restriction.
- For multiple users, purchase additional licenses or contact for bulk licensing options.
