Software de análise

• Software de análise

  c

• Software de análise

  • GridVis
  • OPC server
  • Analise Excel 

  GridVis

  The GridVis software is part of the standard package supplied with the UMG 604 power analyser and the UMG 103 universal measuring instrument.

  This software can be used to present the measurement values as actual values online and a graphic presentation of the values read from the measurement value memory is possible.

  The topology overview guarantees a quick overview of the complete electricity network. The GridVis software also serves the purpose of parameterisation of the measurement instruments. Furthermore, the creation of customer-specific programs is possible using our own developed program language, Jasic®, or the user-friendly graphic programming periphery.
  Software for grid visualisation

  The GridVis programming and grid visualisation software, which is part of the UMG 604 and UMG 103 standard delivery package, enables a simple and complete parameterisation of the UMG 604 and UMG 103 power analysers. Customer specific visualisation of the energy supply is possible with the topology view. The individual measurement instrument can also be operated online using the mouse. Measurement data can be directly recorded on the PC using the online presentation. Furthermore, the GridVis offers convenient opportunities for presentation and analysis of historical data from the database.

  The automatic ring buffer down load and integrated data management has a particularly positive effect in medium and large sized projects as data can be stored in various database formats. In addition to the UMG 604 and UMG 103, the UMG 507, UMG 96S and UMG 510 instruments are also successively integrated into the software. User programs can be freely programmed for the UMG 604 with the graphic programming.
  Characteristic feature

  The GridVis grid visualisation software enables the following:

  *

  Visualisation of measurement values
  *

  Automatic ring buffer readout from the instruments
  *

  Storage of the data in a database
  *

  Graphic presentation of online measurement values
  *

  Configurable topology overview with freely selectable register levels
  *

  Configuration of the measuring instruments
  *

  Graphic programming of user programs or programming with the Jasic® source code
  *

  Parameterisation, visualisation, data management and analysis

  Applications

  The GridVis software has a multitude of applications:

  *

  The development of extensive energy management systems
  *

  Visualisation of energy supplies with the help of a topology view
  *

  Documentation of the power quality for freely definable period of time
  *

  Analysis of the causes of faults
  *

  Cost centre management i.e. simple and precise electricity cost calculation
  *

  Stabilisation of energy supply through the alarm function when limit values are exceeded e.g. overvoltage or short-term interruption
  *

  Improvement of power quality e.g. harmonic analysis for fault detection
  *

  Load profile analysis e.g. consumption prognosis for electricity contract negotiations

  Programming and configuration

  The UMG 604 power analysers are completely parameterised with the help of the GridVis software. The instruments can be given any name and the CT and PT values can be set. Trigger values for the measurement of events and transients, as well as the measurement values which are to be stored and their recording intervals are determined. Limit values for the monitoring function of the digital outputs are programmed using the comparator or the pulse value for the digital inputs or outputs is established. The external temperature sensor can be selected. The time server for time synchronisation is also determined. If it is necessary to carry out an update on the measuring instrument, this can conveniently be done in the programming mode without the instrument having to be dismantled or returned to Janitza. The most recent updates for software and instrument firmware is available free of charge at Software.
  Unlimited programming options

  The Jasic® programming language opens up so many new opportunities because you are no longer tied to just the fixed integrated functions in the instrument. You can expand the instrument to include your own functions. Up to seven freely definable user programs can run at the same time.

  The graphic programming option for user programs is a fully new aspect in the field of digital power analysers. These can be used to create user-specific programs such as free programming of inputs and outputs or the issue of reports when a defined limit value is reached. In addition to the user-friendly graphic programming, the user is free to program the source code directly.
  Online data

  All measurement values are available in the online measurement mode as a line graph or bar chart. The line graphs are permanently updated and the oldest data is deleted after a while. Two scales for measurement data in two units can be created. Any number of measurement data from each unit, including from several measurement instruments, can be observed in the same graph. The colours in the graph can be changed as required.
  Topology overview

  A device view can be called for up for each UMG604 which is found in the network. It is not only possible to observe the actualdisplay but to control the unit completely by remote control as if you were on site. Furthermore, any jpg document can be assigned e.g. a drawing of buildings or distribution systems. All measurement data for the UMG device can be presented simultaneously online.
  Event and transient browser

  Freely defined periods of time can be checked with regard to transients and events using the two event and transient browser functions. These functions (compare illustration: transient browser) are especially important for error analysis.
  Data storage

  The UMG 604 contains a data memory space of 128MB. The measurement data are stored in a SQL database when the memory data are downloaded. The Derby, SQL and MySQL formats are available for saving the data. Storage in a MySQL database or a Microsoft SQL server database is recommended because these are faster than the Derby database. This has a particularly positive effect for larger projects. MySQL can be downloaded free of charge from www.MySQL.org.
  Offline data

  The data which are saved in the database can be presented as a line graph, bar chart or histogram in the GridVis software. The data are stored in the database according to parameters, year, month and day. The data can, therefore, be selected accordingly. Particularly interesting periods of time can be enlarged with the zoom feature. The graphs can be provided with titles and comments and can be printed out. The display of transients and events also takes place here a the transient or event browser. The flag browser can be used to examine whether measurement data are missing at certain periods of time or whether the data are not reliable.
  Licences

  The following extension modules are available for the GridVis software as an option:

  GridVis licence 1, item number 51.00.117
  Graphic programming module – write/read Modbus
  This allows the graphic programming of the UMG604 as a Modbus master for reading/writing Modbus units using the graphic programming.

  GridVis licence 2, item number 51.00.118
  Database driver for the Microsoft SQL-Server
  This enables the data exchange between the GridVis and a SQL server. Without this driver, the GridVis software uses the integrated Derby database.

  GridVis licence 3, item number 51.00.119
  Database driver for the MySQL-Server
  This enables the data exchange between the GridVis and a MySQL server. Without this driver, the GridVis software uses the integrated Derby database.

  GridVis licence 4, item number 51.00.120
  Devices driver for generic Modbus devices
  Screenshots
  Screenshot Screenshot Screenshot Screenshot Screenshot
   

  OPC server

  We often need to incorporate measurement values from power analysers in “foreign” visualisation systems but the existing visualisation system does not support the protocol which is contained in the measuring instrument. OPC servers serve as an interface between the measuring instrument and the central building control system or PLC in these cases.

  OPC drivers, therefore, offer a standardised interface for easy data exchange without exact knowledge about the communication options in the counterpart system.

  The OPC can be used to link the measurement data with the data from other trades and archive it in the database structures for process control techniques. OPC drivers for process control techniques are used by almost all renowned manufacturers of building automation systems.
  Modbus Suite TOP Server

  Janitza electronics® GmbH has been recommending the proven payable OPC Top server with Modbus suite from Software Toolbox (www.softwaretoolbox.com) for years. Support is also provided in connection with UMG measuring instruments and power analysers.
  Functions of the OPC server

  The OPC server is a software driver and must be installed on a PC in the network. If the existing automation software is already running on a computer with sufficient power reserves and if the operating system is compatible with the OPC server, installation is possible on this computer. If sufficient power reserves are available, the OPC server also runs on systems in which PSW professional/PAS 510 or GridVis is already installed. The software driver contains a Modbus TCP/IP or a Modbus over TCP/IP Master and an OPC server. The data (e.g. measurement values) is read out using the Ethernet interface (port 502 or port 8000) and is passed on to the OPC server. The OPC server then passes on the data to the OPC client of the external program. Access can be simultaneously gained to up to 6 software applications on port 502 of the UMG 507E/EP and UMG 604E/EP. Another two applications can be simultaneously accessed on downstream measuring instruments using the RS485 (Ethernet encapsulation). This means that measurement data can be simultaneously read with PSW/GridVis and the OPC server.
  Configuration of the OPC server

  The OPC server is configured using a convenient operating area but does require some basic knowledge of the data types (Word, float etc) and bus technology. Communication settings can be individually adapted for each channel.

  Following data types are supported:
  Char, Byte, Long, Float, Word and Double as big-endian and little-endian. The OPC server also contains an OPC Quick Client for quick online control of the data. This means that the data is automatically taken from the configuration table and displayed. The statistics function assists fault detection.
  The meaning of OPC

  OPC is an abbreviation for “OLE for process control” and is a standardised interface in the field of automation technology. This term is frequently used in the field of building automation. OPC was created to provide industrial bus systems and protocols with a universal communication possibility. An OPC driver can be integrated into any size control and monitoring system without any major adaptation efforts.
  Screenshots

  Analise Excel

  In order to be able to offer an affordable solution, e.g. for cost centre analysis, Janitza electronics® offers MS Excel solutions specific to the customer. An expensive pro cess control solution is, therefore, superfluous. The measurement data in Janitza electronics® products also available thrugh MS Excel macro or in the MS Excel functions. The costs per data point in MS Excel are just a fraction of the costs for a data point in process control technology.

  Another advantage is the maintenance of the system. Simple changes can be made by the user at any time if the user has sufficient knowledge about MS Excel. Furthermore, the MS Excel macros can be installed on as many computers as required. There are no additional license costs. Obviously a licensed MS Excel version (2003 or 2007) with the most recent service packs is a prerequisite.
  MS-Excel analysis

  The analysis of measurement data can be carried out using the software for the instruments or additionally by using the MS Excel macros which are available as an option. The macros produce MS Excel functions similar to the familiar MS Excel function = sum (). The macros can be incorporated in MS Excel as an add-in. The macros use an ODBC driver to directly access the measuring instrument’s database. Complex analysis can be created even if the user only has moderate knowledge of MS Excel.

   

  The customer specific MS Excel solutions, which are directly created by Janitza electronics®, can program progress charts and user interfaces which are specially produced for the application. For example, it is possible to create a complete cost analysis as a PDF document with the push of a button. The integration of the building plan or the entering of a password is also possible.

   

  You will not recognise the standard MS Excel at all. The MS Excel solutions developed by us come very close to visualisation system but only cost a fraction of the price and do not have any complicated, expensive license management. You only require a licensed version of MS Excel on the computer on which the analysis is to be carried out. The actual macros it self can be used as required.

  Main features

  *

  Affordable, just a fraction of the cost per data point in comparison to process control visualization solutions
  *

  View changes can be undertaken by the end customer at any time if the customer has sufficient MS Excel knowledge
  *

  The complete functional diversity of MS Excel is available
  *

  Many users can access the database via MS Exel at the same time
  *

  Many programs can directly access MS Excel
  *

  The MS Excel macros are consistently adapted to the database models of Janitza electronics®. This means that a rapid data flow rate is achieved.
  *

  The standard MS Excel terms are used for all Janitza® MS Excel functions such as sum = (..,...)
  *

  A standard file with the most important analysis is available free of charge
  *

  The software supports MS Excel 2003 and MS Excel 2007 with ribbon UI
  *

  A user interface in the look&feel function in Office 2007 (ribbon UI) can be created

  Applications

  The MS Excel functions which are especially programmed for the database model offer a wide range of selection options. For example, it is possible to let the software carry out a targeted search for peak values. It is even possible to create an average value over any period of time and to create the maximum value of a measurement parameter. The full loading of a transformer can also be identified at an early stage. Here is a small selection of the possible functions:

  *

  AverageValue: provides the average value of a measurement parameter in a month
  *

  AverageDates: provides the average value of a measurement parameter within the time range
  *

  Maximum: provides the maximum value of a measurement parameter in a month
  *

  MaximumDates: provides the maximum value of a measurement parameter within the time range
  *

  MaximumDate_time_month: provides the date and time of the maximum value
  *

  Minimum: provides the minimum value of a measurement parameter in a month
  *

  MinimumDates: provides the minimum value of a measurement parameter within the time range
  *

  MinimumDate_time_month: provides the date and time of the minimum value
  *

  ConsumedRealEnergy: provides the effective energy drawn in a month
  *

  ConsumedRealEnergyDates: provides the effective energy drawn within the time range
  *

  Get_AvgValues_oneMonth: this function produces a list with measurement values for a month.

  A total of more than 50 functions are available !
  MS-Excel VBA

  VBA (Visual Basic for applications) is an independent, object-orientated programming language for MS Office applications. It serves the purpose of expanding the extent of functions of MS office products. Through the use of these programs (macros), MS Excel becomes even more powerful because MS Excel tables can be automated for example.
  Who can profit from the MS Excel analysis tools?

  Analysis tools are applied when functions of the PSW professional, PAS 510 or GridVis software systems are not sufficient. They, therefore, make sense for complex cost centre analysis, large-scale applications and when measurement data has to be compared with certain specifications. The MS Excel analysis tools can be an affordable introduction to the world of process control technology for medium-sized companies which do not have their own building automation and visualisation. But MS Excel analysis tools can also offer an option to make necessary data accessible to all members of staff in large companies in which all employees may not have access to building automation. This means that consumption levels and power peaks can easily be passed on to controlling in customer specific form or invoices can be issued directly from MS Excel if the MS Excel sheet already has an invoice template.
  Function

  The macros take the respective measurement data from the database created by PSW professional, PAS 510 or GridVis and enter it in an MS Excel document. The time periods, for example, are now simply entered and the respective measurement values, consumptions, costs or other values calculated by MS Excel are issued as a graph or table. All MS Excel instruments are available for creating the MS Excel documents. The MS Excel macro is incorporated in MS Excel as an add-in. This can be used to create graphics of the building complex or systems. Set function keys can be used to zoom in on individual buildings or building parts in order to be able to monitor the incurred costs, consumptions or any other measurement data.
  Vorteile

  The data are made available as measured in the databases of the various software systems of Janitza electronics® GmbH. However, in the MS Excel analysis tools any computing processes can be undertaken which are provided by MS Excel. The measurement data from the macros can be reprocessed in formulas. This means that the facility manager has almost unrestricted options for analysis e.g. for the comparison with reference data, for percentage distributions, for comparisons of various properties or any graphs etc. This means that the customer is no longer tied to the rigid functions of ready to use software and can either create MS Excel sheets himself, whereby Janitza electronics ® GmbH provides the macros, or he can allow Janitza electronics® GmbH to undertake extensive programming as a service against payment of a very reasonable charge.
  Vorgehensweise

  In order to be able to create MS Excel solutions specific to the customer, Janitza electronics® needs a specification in which the functions of the MS Excel analysis tools are described. The costs are exclusively based on the time needed for programming. These costs can be kept low with active cooperation e.g. the customer provides prepared tables or building plans in MS Excel. Our sales team is pleased to support you and work together with you on a suitable and affordable solution.
  Screenshots