Asset Management Dashboard

Asset & Maintenance Management System

Twenty-eight sheets and thirty-eight live charts — the whole maintenance function in one workbook, instead of a CMMS subscription.

Most asset spreadsheets are a register and nothing else. This one runs the function: what you own, where it is, who has it, what maintenance is due, what has failed, what it costs, what is under warranty, and what needs replacing next.

The registers

• Asset Register — everything you own, with criticality and location
• Assignment & Custody — who holds what
• Maintenance Plan and Maintenance Log — what is due, what was done
• Defect Register — faults raised, severity, resolution
• Condition Monitoring — readings against spec, so failure is predicted rather than discovered
• Spares & Consumables, Suppliers & Contracts
• Compliance Register — inspections and certifications with due dates

The analysis

• Dashboard — availability, cost, backlog and workload on one screen
• Action Queue — what needs attention now, ranked
• Failure & Defect Analysis — failure modes, so the pattern shows
• Financial Analysis — maintenance cost by asset, system and period
• Backlog & Ageing — how long work has been waiting
• Warranty & Renewals — what is still covered, and what expires when
• Replacement Planning — which assets are approaching end of life
• Monthly Trends and Workstream Analysis

Who it's for

Maintenance managers, facilities teams, fleet operators and small businesses with equipment to look after — anyone quoted five figures a year for a CMMS to do what a well-built workbook does.

How it works

Enter your assets and keep the logs current. Availability, costs, backlog, ageing and every chart calculate themselves. No macros, no add-ins, no subscription — a normal Excel file that opens in any version of Excel and keeps working forever.

Pairs with the Fleet Asset & Maintenance Command Board (A$46), which reads this workbook and puts it on a screen the whole team can see.

Built in Australia from more than twenty years of program delivery experience. Instant download, yours to keep, use it across as many sites or fleets as you like.