Software for field support for Electricity Smart Metering Solution

October 3, 2016

Tender procedure for the project of replacement of electric meters in Montenegro defined the types of solutions for the replacement of meters, depending on the activities performed in fieldwork. This project was, from the meter installation aspect, necessary to be supported by appropriate information system, because it is a fairly complex business process that requires a large amount of different resources. Process of replacing the electric meters consisted of of the following steps:

  1. Obtaining information from Billing department – Elektroprivreda Crne Gore (EPCG) delivers necessary information to the company in charge of the installation of meters: information about the meters, corresponding transformer reons and topology of consumer network, where it is necessary to replace or install electric meters. The mentioned information is imported into the system by performers;
  2. Creating a Pre-Inspection – Inspectors from the company which performs the installation and inspectors from EPCG visit places where an installation needs to be performed, obtaining information about the owner and the facility. After that, inspectors determine which installation solution needs to be applied for that facility. Entire set of necessary information is collected for replacement to be prepared;
  3. Monitoring the status of pre-inspection;
  4. Reports – Various reports necessary for successful monitoring and management of the project;

An information system is created which meets the requirements of the business process in an adequate way. The system consists of a C# desktop application, Microsoft SQL (MSSQL) central database and Android mobile application for field activity support.

1. Android applications for filed activity support

Collection of Pre-Inspection information data in the field is done through mobile application. Basic data(inspectors, transformer reons, energy utilities, municipalities, etc.) are exported to XML file through desktop applications. The created XML file is downloaded through mobile applications and is used to update data.

Entry of the basic information about the Pre-Inspection is done through limited entry fields and selections of more interdependent predefined values. GPS coordinates are also available to obtain.

After entering basic data, it is necessary to enter data on property owners (the maximum of 4 owners can be entered per property), as well as select the type of solution and input detailed data for the realization of the given solution. It is possible to directly photograph the object via mobile application.

The overview of created Pre-Inspection by date is enabled, as well as their modification and deletion. The entered data is exported to an XML file that is uploaded on the server and imported into the database via the Desktop application.

mezon-android

2. Desktop application

Desktop application enables sequential processing of data in different segments of the company that is charge of electric meters installation,  status monitoring of a replacement through all steps of the process, as well as a large number of reports that are always available to management. These characteristics make this system robust, but also very powerful and necessary tool.

mezon-desktop1

2.1    Creating Pre-Inspection

Creating a Pre-Inspection can be made via desktop application is based on the filled paper form, or by using the tablet and Android application that inspectors use in the field.  In addition to technical data, data also contain a photo of the object, as well as its GPS coordinates. Created Pre-Inspections can be reviewed through the application or in the form of reports.

mezon-desktop2

 

2.2  Specifications

Based on the solution selected when creating the Pre-Inspection, it is possible to automatically create specifications for all Pre-Inspections at the level of one transformer reon. Amount and type of material need for the installation of one meter is precisely defined in each specification.

mezon-desktop3

2.3 Module for planning executon of works

One of the advantages of this system is the ability to plan the execution of works through a specially created module. The person responsible for the deployment of teams for the installation of meters can see the map with all the meters that need to be replaced, grouped by transformer reons. That is why this component enables deployment of teams in the optimal way.

mezon-desktop4

2.4  Statusi predinspekcije

Jedna predinspekcija prolazi kroz niz različitih statusa od ulaska u sistem do fakturisanja. Iz ovog razloga, kreiran je modul koji omogućava pregled predinspekcija i grupisanje po statusima. Moguć je pregled statusa na nivou trafo-reona, kao i na nivou predinspekcije. Kao status trafo-reona uzima se najniži status predinspekcije u njemu. Za svaku predinspekciju mogu se vidjeti podaci koji su karakteristični za status u kom se predinspekcija nalazi, kao i podaci za sve prethodne statuse. Takođe, iz ovog modula se vrši i promjena statusa.

 

2.4  Pre-Inspection statuses

One Pre-Inspection passes through a number of different statuses from entering into the system to the final step of invoicing. For this reason, a module that provides an overview of Pre-Inspection and grouping by status is created. It is possible to view the status of the entire transformer reon, as well as at the singlePre-Inspection. Status of transformer reon is given by the Pre-Inspection with a lowest status which is located with it. It is possible to view data of each pre-inspection specific for the status it currently has, as well as for all statuses it has passed before current. This module also handles pre-inspection status changes.

mezon-desktop5

2.5  Reports

Desktop application allows the generation of various reports, intended to both technical personnel and management of the company in charge of electric meters replacment. It is possible to choose type of the report, as well as data types that will be withing given report.

Reports that can be generated by status of the Pre-Inspection are:
  1. Equipment ordered:
    1. Report for equipment order: According to ED, TR, object, or grand total based on solution choosen.
    2. Report on the ordered equipment: According to ED, TR, or object.
  2.  Produced equipment:
    1. The report of the produced equipment : by ED, TR, or object.
  3.  Planning:
    1. Weekly plan for electric meters replacemnt for the company in charge of replacement: complete report or TR based
    2. Weekly electric power industry plan: full or according to TR
  4. Execution:
    1. Completed objects
    2. Unfinished objects
    3. Analysis of the meter installation by TR:
      1. List of complete TR
      2. List of TR in which replacement started
    4. Reports on completed buildings: According to ED, TR or facility
  5. Invoicing
    1. Report on invoiced replaced meters
Jedan od najznačajnijih izvještaja je izvještaj o kompletiranosti zamjene brojila na nivou jednog trafo-reona. Za ovaj izvještaj mogu se izabrati sledeći parametri: grad i oznaka trafo-reona koji se u njemu nalazi, tip rješenja, inspektor koji je izvršio kreiranje predinspekcije i vremenski opseg. Svi navedeni parametri su opcioni, pa je moguće generisati izvještaj opšteg karaktera, koji sadrži podatke o kompletiranosti svih trafo-reona.
One of the most important reports is a report on the completeness of meter replacement at the level of a transformer regions. The following parameters can be selected for this report : the city and name of the sub-regions that is situated in it, the type of chosen solution, the inspector who performed the creation of Pre-Inspection and time range. All of the above parameters are optional, so it is possible to generate a report of a general nature, which contains information about the completeness of all the trapho-sections.

mezon-desktop6