Catalogs

Guide for Creating and Managing Excel Files

Introduction

This section describes the format of the Excel files used in the CMMS (Computerized Maintenance Management System) module for importing various necessary catalogs, such as:

• Component Catalog

• Routine Maintenance Activities Catalog

• Replacement Cause Catalog

These catalogs are crucial because maintenance activities and replacement causes are linked to specific groups and subgroups. These data can only be imported through the component catalog.

---

Notation

Before analyzing the syntax for the necessary catalogs, we formalize the syntax to be used:

• Element: Each lower hierarchical unit belonging to a group and subgroup.

The elements for each catalog are listed as follows:

• Component Catalog: Component

• Activity Catalog: Routine Maintenance Activity

• Replacement Cause Catalog: Cause of Replacement

---

Critical Component

A component is considered critical when the number of remaining cycles is less than or equal to the critical threshold defined in the database. In the application, the critical component will be displayed in red.

Subcritical Component

A component is considered subcritical when the number of remaining cycles is less than or equal to the subcritical threshold but greater than the critical threshold defined in the database. In the application, the subcritical component will be displayed in orange.

General Notes

In the first column of each table, the bold entries specify the fields that uniquely identify an element. These fields cannot be modified without creating a new element. In general, the unique identifier for each element is defined as:

Group + Subgroup + Element

---

Component Catalog

Column Name	Column Type	Description
GROUP	STR	Group name (in Italian)
ENGLISH GROUP	STR (optional)	Group name (in English)
SUBGROUP	STR	Subgroup name (in Italian)
ENGLISH SUBGROUP	STR (optional)	Subgroup name (in English)
COMPONENT	STR	Component name
CODE	STR (optional)	Component code (optional, for customer-specific purposes such as ordering spare parts)
DESCRIPTION	STR	Description (in Italian)
ENGLISH DESCRIPTION	STR (optional)	Description (in English)
CRITICAL THRESHOLD	INT (optional)	The number of cycles under which the component is considered critical. If not defined, the component cannot be evaluated as critical.
SUBCRITICAL THRESHOLD	INT (optional)	The number of cycles under which the component is considered subcritical (must be greater than or equal to the critical threshold). If not defined, the component cannot be evaluated as subcritical.
EXPECTED CYCLES	INT	Estimated number of cycles a component can perform before reaching a high risk of failure that requires replacement
IMAGE	INT (optional)	Name of the image file associated with the component (e.g., comp_XY1.png). Multiple components may share the same image.
INSTALLATION DATE	DATE (DD-MM-YYYY format)	The date when the component was installed. If not specified, it will default to the date the Excel file is uploaded (e.g., 14-06-2022).

---

Routine Maintenance Activities Catalog

Column Name	Column Type	Description
GROUP	STR	Group name (in Italian)
ENGLISH GROUP	STR (optional)	Group name (in English)
SUBGROUP	STR	Subgroup name (in Italian)
ENGLISH SUBGROUP	STR (optional)	Subgroup name (in English)
ACTIVITY	STR	Name of the maintenance activity (in Italian)
ENGLISH ACTIVITY	STR (optional)	Name of the maintenance activity (in English)
DESCRIPTION	STR	Activity description (in Italian)
ENGLISH DESCRIPTION	STR (optional)	Activity description (in English)
FREQUENCY	STR (Closed list)	Frequency of the activity (annual, monthly, weekly, daily)
RECURRENCE	INT (optional)	Number of recurrences of the activity frequency (e.g., 6 months, 2 weeks). Default is 1.
PERSONNEL	INT	Estimate of the amount of personnel required for the maintenance activity
DURATION	INT	Estimated duration of the maintenance activity (in minutes)

---

Replacement Cause Catalog

Column Name	Column Type	Description
GROUP	STR	Group name (in Italian)
ENGLISH GROUP	STR (optional)	Group name (in English)
SUBGROUP	STR	Subgroup name (in Italian)
ENGLISH SUBGROUP	STR (optional)	Subgroup name (in English)
EVENT	STR	Name of the failure cause (in Italian)
ENGLISH EVENT	STR (optional)	Name of the failure cause (in English)
LOCAL EFFECT	STR	Description of the local effect (in Italian)
SYSTEM EFFECT	STR	Description of the system effect (in Italian)
UPPER EFFECT	STR	Description of the upper effect (in Italian)
LOCAL EFFECT ENGLISH	STR (optional)	Description of the local effect (in English)
SYSTEM EFFECT ENGLISH	STR (optional)	Description of the system effect (in English)
UPPER EFFECT ENGLISH	STR (optional)	Description of the upper effect (in English)
SEVERITY	INT	Severity of the failure cause, used to calculate the criticality of an event. Higher values indicate greater severity.
FMECA	BOOL	Integer value that can be either 0 or 1. 0: The replacement cause is not related to a component failure. 1: The replacement cause is related to a component failure.