CBR Test Excel Calculation Sheet
(As per IS 2720 Part 16 – Highway & Pavement Works)
A professionally designed and fully automated CBR Test Excel format developed for highway engineers, QA/QC professionals, EPC contractors, and geotechnical laboratories.
This advanced Excel sheet performs complete California Bearing Ratio (CBR) calculations in accordance with:
IS 2720 (Part 16) – Laboratory Determination of CBR
Relevant IRC Specifications
Applicable MoRTH Guidelines
The format ensures technical accuracy, compliance, and audit-ready documentation for highway and infrastructure projects.
It eliminates manual errors and significantly reduces reporting time.
What is the CBR Test?
The California Bearing Ratio (CBR) test evaluates the strength of subgrade soil and granular layers used in pavement construction.
It is a critical parameter for:
Pavement thickness design
Subgrade evaluation
Embankment quality control
Highway and runway construction
Accurate CBR determination directly impacts pavement performance and project approval.
What This Excel Sheet Does
Calculates CBR value at 2.5 mm penetration
Calculates CBR value at 5.0 mm penetration
Automatically selects governing CBR value
Computes corrected load values
Generates Load vs Penetration graph
Integrates moisture content and dry density data
Produces a clean, printable professional report
All formulas are pre-applied and protected to ensure accuracy while keeping input cells editable.
Key Features
✔ Automatic CBR value calculation (2.5 mm & 5.0 mm)
✔ Load vs Penetration graph generation
✔ Corrected load computation
✔ Automatic CBR comparison & selection logic
✔ Moisture content & dry density integration
✔ Ready-to-print professional laboratory report
✔ IS Code reference included in format
Designed for real project execution and audit documentation.
Who This Is For
Highway & Pavement Engineers
QA/QC Engineers (EPC / PMC Projects)
Geotechnical Laboratories
Infrastructure Consultants
Engineering Students & Researchers
Whether you are working on National Highways, State Highways, or major infrastructure projects, this format ensures professional and standardized reporting.
Technical Standards Covered
Prepared in accordance with:
IS 2720 (Part 16) – Laboratory Determination of CBR
IRC Specifications for Road & Bridge Works
MoRTH Guidelines (where applicable)
The calculation logic aligns with standard laboratory practice used in highway quality control.
Why Use This Format Instead of Manual Calculation?
Manual CBR calculations require:
Repetitive load ratio calculations
Graph plotting
Penetration comparison
Correction factors
This Excel sheet:
✔ Saves approximately 30–45 minutes per test
✔ Reduces calculation mistakes
✔ Standardizes reporting format
✔ Improves documentation quality
✔ Enhances professionalism during consultant review
Especially valuable in EPC and PMC environments where documentation accuracy is critical.
What You Will Receive
1 Fully Automated Excel File
Built-in Protected Formulas
Editable Input Cells
Load vs Penetration Graph Sheet
Printable Test Report Format
Instant download after successful payment.
Delivery & Access
Instant digital download
Limited download attempts (for file security)
No physical shipment
One-time purchase (No subscription)
🔒 License & Usage Terms
This product is provided under a single-user license.
Redistribution, resale, sharing, or uploading to public platforms is strictly prohibited.
Internal modification for project use is permitted.
Unauthorized distribution may result in access restriction and legal action.
For multi-user or company-wide licensing, please purchase additional licenses.
Why Choose Highway Quality Test?
Highway Quality Test formats are developed specifically for real infrastructure projects.
✔ Based on Indian Standard Codes
✔ Structured for Highway & Pavement Works
✔ Designed for Professional Documentation
✔ Used by Engineers & QA/QC Teams
✔ Practical, Field-Oriented Format
These are not generic spreadsheets — they are structured engineering tools built for real-world application.
