Electrical supervision - drum management

The document describes an example of import, management and supervision of cable drums used for cable works. The goal is to make it possible to manage the available cable drums. After the drums have been delivered and their capacity (declared cable length of a given type) has been determined, the system enables supervision of the drums themselves (their condition, location, length declared by warehousemen) as well as supervision of the wear and tear of the cables used to route the sections during the execution of these works. The used drum information is recorded for each cable section. Reports allow you to generate information about the use of drums and cable allocation.

Descriptively, the implementation of the required functionality may look like this:

In addition, for the purpose of access to analytics, we follow the steps:

We define the group to which we will import the drums. It will contain drums imported from an Excel file. This is to enter the drum data into a specific group. Additional subgroups or a main group can be defined in the Excel worksheet. It is up to the data importer to decide whether he wants to additionally divide the imported drums into internal groups.

The Excel file contains information about individual drums. These data can be entered already in the system (parameters), but they can be imported from external systems. We use the general spreadsheet for the definition.

The content of the file is data on:

To import data, go to the configuration section and select imports and resource import.

In the options, we choose mapping by element name and group. We also automatically add identifiers during import. This will allow you to generate and assign identifiers and print them later (it can also be done later).

In the case of drums, we define new additional parameters for them. The import sheet contains additional information resulting from the design process, i.e. total drum capacity (in [m]), drum radius, minimum bend radius and ordered length. We can store any number of additional parameters for a given type in the system. In this case, part of the data will be informative and part will be used in the reporting process (ordered lengths).

In addition, we map the main fields that define basic parameters such as name, type, manufacturer and mark the import to the group with the given name 'Drums'. This will automatically create such a group in the system and enter all drums inside that group.

We import data with saving to the database.

After this step, the basic drum data is imported into the system.

For imported drums, we create supervision to be able to track their path and exploitation. We define appropriate states in the system. For basic monitoring, it is enough to define states without monitoring additional parameters.

We associate all drum types with the given supervision and initiate supervision after selecting all drum types.

Alternatively, when we have specific categories for drum types, we can define supervision in a simplified way. We only select a category of types and assign a supervision template to it. This will allow for faster initialization of supervision for all types of assortment data, e.g. drums, cables, etc. This option is available in the supervision view.

Result: We get initialized supervision for drums. You can record the status of individual drums.

In order for the system to be able to generate appropriate reports specific to drum/cable sections, it is necessary to specify in the configuration which templates and what parameters correspond to the selected sections and parameters.

For cables, we define information about supervision states and parameters that will be used to calculate data/reports.

For drums, we specify parameters such as initial lengths/weights.

Then we can proceed to the preparation of identifiers for individual drums. In this case, we will use predefined label appearances and configure the labels to store two types of data for drums used in two different areas.

We will use an automatically assigned ID to track supervision of individual drums. This will allow us to report the change in the state of the drum in accordance with the adopted scheme (used, empty, etc.).

However, we will add an additional, second 2D code (QR Code), which will contain the name of the drum. This name will be used to record which drum the cable was laid from when laying the cable. We do it so that the text known to the user appears instead of the numerical identifier in the parameter view of the individual cables.

Go to the view of a given drum (you can also generate IDs from a collective list of drums) and select the 'Print IDs' action.

For printing, we choose a QR+DataMatrix template.

As a result of this action, we get a label ready to be printed on a label printer. Select the >> button and then "Download" and print the download result on the label printer.

We receive labels that we put on the delivered drums. They can be nailed to the side section of a given drum. You can also print more of the same label and place it in several places on the drum.

In the definition of cable supervision, we specify that in one of the states, the scanned code of the selected drum should be additionally saved. This allows you to enter (scan) the name of the drum used to lay the given cable, in addition to the cable length marker, when a given condition is selected for the supervision report.

After recording this data in the supervision history for a given cable, information appears which drum was used to lay the given cable.

This data can be used to generate general reports, compare or export information to external systems. The AMAGE system additionally uses this information to generate detailed drum usage reports.

The Drum Usage Report is available in the Report Viewer. Select the Cable supervision section and the Drums report.

Report options allow you to narrow down reports to drums in a specific product group, drum type and add additional visual parameters to the report.

Report generation generates this information as well as collects information about drum usage during cable works.

The report presents information on the initial parameters of the drum, wear in relation to the planned length (design) and actual drum wear based on the declared length of the laid cables.

The data contained in the report include: