Aggregate Impact Value (AIV) Test Excel Sheet
As per IS 2386 (Part IV)
This professionally developed Excel sheet is designed for accurate calculation of Aggregate Impact Value (AIV) as per IS 2386 (Part IV) – Mechanical Properties of Aggregates.
The format automates impact value calculation, eliminates manual errors, and generates a clean printable laboratory report suitable for submission in highway and infrastructure projects.
IS Code Reference
IS 2386 (Part IV) – Methods of Test for Aggregates for Concrete
Standard procedure for determining Aggregate Impact Value
Applicable for highway, pavement, and structural works
What is Aggregate Impact Value Test?
The Aggregate Impact Value (AIV) test measures the toughness of coarse aggregates by determining their resistance to sudden impact or shock.
During the test, aggregates are subjected to standard impact blows, and the percentage of fines generated is calculated.
Lower AIV indicates:
Higher aggregate strength
Better resistance to impact
Improved pavement performance
Why AIV Test is Important in Highway Construction?
Aggregate toughness directly affects the durability and service life of pavements.
A high impact value may lead to:
Surface disintegration
Premature pavement failure
Loss of structural strength
The test is particularly important for aggregates used in:
Dense Bituminous Macadam (DBM)
Bituminous Concrete (BC)
Wet Mix Macadam (WMM)
Cement Concrete Works
National Highway projects
What This Excel Sheet Calculates
Total oven-dried sample weight (W1)
Weight of fines passing 2.36 mm sieve (W2)
Automatic AIV (%) calculation
Instant percentage result
Acceptance / compliance indication
Professional printable report layout
Formula Used:
AIV (%) = (W2 / W1) × 100
How to Use the Sheet
Enter total oven-dried sample weight.
Enter weight of fines passing 2.36 mm sieve.
The sheet automatically calculates AIV (%).
Print the formatted laboratory report.
No manual calculations required.
Suitable For
National Highway EPC Projects
Authority Engineers / IE / PMC
Material Testing Laboratories
Asphalt & Concrete QC Engineers
Infrastructure Consultants
Key Benefits
✔ Fully automated calculations
✔ Eliminates manual errors
✔ IS 2386 compliant format
✔ Ready for project submission
✔ Designed for real site and lab use
Frequently Asked Questions (FAQ)
Is this sheet based on IS 2386?
Yes, it follows IS 2386 (Part IV) guidelines.
Can this be used for NH projects?
Yes, it is suitable for NH and State Highway quality control works.
Does it generate printable reports?
Yes, it includes a clean professional reporting format.
🔒 License & Usage Terms (Important)
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.
If multiple team members require access, please purchase additional licenses or contact us for bulk licensing options.
