| Column Header | Description | Example | | :--- | :--- | :--- | | | Unique equipment code | PUMP-01 | | Equipment Name | Description | Centrifugal Pump | | Location | Plant area | Building A, Floor 2 | | Maintenance Type | Daily, weekly, monthly, quarterly | Monthly | | Last Service Date | Last time maintenance was done | 03/15/2026 | | Next Due Date | =Last Service + Frequency (days) | 04/15/2026 | | Frequency (days) | Interval in days | 30 | | Assigned To | Technician name | J. Pérez | | Task Description | Specific actions | Lubricate bearings, check seals | | Status | Pending / Completed / Overdue | Overdue | | Cost (optional) | Parts + labor | $45.00 |
✅ Use TODAY() exactly the same way. No special syntax needed. | Column Header | Description | Example |
LibreOffice
Aunque existen soluciones CMMS especializadas, las hojas de cálculo ofrecen flexibilidad total sin costo de licencias. Son ideales para: LibreOffice Aunque existen soluciones CMMS especializadas
Para estructurar un plan efectivo desde cero en Excel o Calc, sigue estos pasos clave: Inventario detallado sigue estos pasos clave: Inventario detallado