Industrial Maintenance Plan Excel

I need a well-structured, easy-to-update Excel workbook that serves as a preventive maintenance plan for my production machines. The file must let me log each machine, register its running hours, and keep a clear history of past interventions.

What matters most is speed and clarity: a dashboard or summary sheet that tells me at a glance which machine is approaching its next service based on hours worked, plus automatic colour alerts when thresholds are reached. I already know the service intervals; I just want formulas or simple VBA snippets that flag the dates and hours for me rather than a complex CMMS.

Key requirements
• Data entry sheets for every production machine (around a dozen to start)
• Fields for total hours, last maintenance date, and next due date calculated automatically
• A master overview that updates instantly and can be filtered by status (due / upcoming / ok)
• Clean, bilingual labels in French where relevant so the shop-floor team can use it directly

Deliverable: the finished, unlocked Excel file with any macros, plus brief instructions so a non-technical operator can add new machines or tweak intervals later. If you have experience designing similar tools for industrial environments and can turn this around quickly, let’s get started.