Professional Excel template
Asset Criticality Assessment Template
Stop wasting maintenance hours on low-priority equipment. This Excel template helps you score, rank, and prioritize assets in under 30 minutes.
- 4 Dimensions
- 6 Worksheets
- 30 Minutes
The problem
The Problem with Traditional Maintenance Planning
You're treating all equipment the same
Your overhead crane gets the same PM frequency as your office printer. That's not a strategy.
Your team can't agree on priorities
Operations says the packaging line is critical. Maintenance says it's the compressor. Who's right?
You can't justify predictive maintenance
CFO asks "Why do we need $50k for sensors?" You need data to back up your budget request.
This Template Solves All Three Problems
Score assets objectively across 4 dimensions. Get automatic rankings. Know exactly where to focus your time and budget.
Features
What's Inside the Template
6 professional Excel worksheets with built-in formulas and automation
Safety Impact Scoring
Rate equipment based on worker safety and injury risk (1-10 scale)
Production Impact
Assess downtime costs and output loss if equipment fails
Maintenance Cost
Factor in repair and replacement expenses (NZD pricing)
Environmental Risk
Evaluate potential spills, contamination, and regulatory impact
Automatic Rankings
Assets sorted by criticality score with visual heat maps
Strategy Recommendations
Get maintenance approach based on criticality (PM, PdM, RTF)
Preview
See It In Action
Rate Each Asset (1-10)
Simple dropdown scoring across safety, production, cost, and environment
Automatic Rankings
Assets sorted by criticality with visual heat map and statistics
Strategy Recommendations
Get specific maintenance approach for each criticality level
Included
Everything You Need to Get Started
- Complete instructions and usage guide
- Asset database template (20+ rows)
- 4-dimension scoring matrix
- Automatic results dashboard
- Action plan with strategy recommendations
- Detailed scoring criteria guide
- Data validation (ensures accurate scoring)
- Professional formatting and charts
- NZ-specific guidance (lead times, remote sites)
- 30-day email support included
The difference
Before vs After
Spending PM hours on low-priority equipment
Focus on assets that actually impact your business
Team disagreements about what's critical
Data-driven decisions everyone agrees on
Can't justify predictive maintenance budget
Clear ROI case for critical asset monitoring
No idea which assets to stock spares for
Prioritized spare parts strategy by criticality
Feedback
What Users Say
“Completed our criticality assessment in 45 minutes. Previously took us 2 full days with consultants.”
“Finally got budget approval for condition monitoring on our 3 critical assets. The scoring justified the investment.”
Made for New Zealand
Built for New Zealand Operations
Includes specific guidance for NZ maintenance challenges:
Parts Lead Times
Add +2 to criticality if 8+ weeks from overseas suppliers
Remote Locations
Factor in West Coast and high country access challenges
Contractor Availability
Account for limited specialist trades in NZ market
Risk-free
30-Day Money-Back Guarantee
If this template doesn't save you at least 2 hours of work, we'll refund you in full. No questions asked. Just email us within 30 days.
Ready to Prioritize Your Assets?
Download instantly. Start using in 5 minutes.
Download Template — $79 NZD$79 NZD
- Instant download
- Lifetime use
- 30-day money-back guarantee
- Email support included
FAQ
Frequently Asked Questions
What software do I need?
Works in Microsoft Excel 2016+, Google Sheets, or LibreOffice Calc. No macros or add-ins required.
How long does it take to complete?
Most users complete their first assessment in 30-45 minutes for 10-20 assets.
Can I use this for multiple sites?
Yes! One purchase includes lifetime use for unlimited assets and sites within your organization.
Do you offer team training?
Yes. We offer 1-day workshops where we facilitate the assessment process for your team. Email hello@assetcareplaybook.com
What if I need help using it?
30 days of email support included. We respond within 1-2 business days to help with any questions.
Is there a free version?
We offer a basic criticality matrix template for free. This Pro version includes automation, dashboards, and detailed guides.