Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an excel maintenance dashboard with mttr, mtbf and oee kpis
Abdul Rehman
About this gig
Struggling to track maintenance on paper, or in a spreadsheet that's turned into chaos?
With 15+ years as a hands-on mechanical maintenance engineer, I know exactly what a maintenance team actually needs to track because I've run maintenance departments myself, not just built templates for them.
What you'll get:
- Asset register with auto-calculated Next PM Due dates
- Overdue / Due Soon / OK status flags, color-coded for instant clarity
- Downtime log with real cost impact tracking
- A live dashboard with charts, uptime %, and overdue counts
- On Premium: industry-standard reliability KPIs MTTR, MTBF, Fleet Uptime %, PM Compliance % the metrics real maintenance managers report upward
Fully formula-driven, not hardcoded update your data and everything recalculates automatically. Delivered as a ready-to-use .xlsx file with clear instructions.
Message me with your equipment type and rough asset count before ordering, so I can confirm the best package for you.
Get to know Abdul Rehman
Abdul Rehman
ERPNext, Excel and Power BI Dashboard, Procurement and Maintenance Specialist
- FromPakistan
- Member sinceMay 2019
- Avg. response time1 hour
Languages
Urdu, Punjabi, English, Arabic
Turning messy data into clear decisions — that's what I do best. 📊
I'm a data & systems specialist with 15+ years of hands-on experience in procurement, supply chain, and maintenance/asset operations across Saudi Arabia and Pakistan.
🔹 Advanced Excel — dashboards, automation, payroll & timesheet systems
🔹 Power BI — DAX, data modeling, interactive dashboards
🔹 ERPNext/Frappe — implementation & consulting for assets, work orders, inventory
I don't just build reports, I understand the real business processes behind the numbers. Clear communication, clean delivery, on-time results.
FAQ
What information do you need to get started?
Your current asset list (even messy or incomplete) and how you currently track maintenance — paper, spreadsheet, or nothing yet. I'll structure it properly either way.
Do I need any special software to use this?
No. Everything is built in standard Microsoft Excel — no add-ins, no macros required (unless you specifically request VBA automation), so it opens and works on any computer with Excel.
What are MTTR, MTBF, and OEE, and do I need them?
They're standard reliability metrics maintenance teams use to measure repair speed, equipment reliability, and overall efficiency. Included in the Premium package — useful if you report performance to management.
Will the dashboard update automatically as I add new data?
Yes. Every KPI, chart, and status flag is formula-driven — add a new asset or downtime entry and everything recalculates and updates automatically, no manual rework needed.
Can you customize this for my specific industry or equipment type?
Yes. Whether it's manufacturing machinery, vehicles, facilities equipment, or something else, I'll adapt the asset fields and categories to match what you actually maintain.
What if I don't have historical maintenance data yet?
No problem — I can set up the full structure and formulas now, so you're ready to start logging data immediately. The KPIs will populate as real data comes in.
