XLeMs is a software package for use with data loggers from SHM Communications.
XLeMs is a full-function energy monitoring system that presents results in Microsoft Excel format. By using the familiar Excel environment, it leverages the user's Excel skills to produce high quality reports and graphs. This means that the "learning curve" for XLeMs is very short.
Because XLeMs reports are Excel workbook files, reports and graphs can easily be incorporated into other Microsoft Office applications.
XLeMs collects data automatically from all types of SHM logger via serial port, modem or Ethernet as appropriate and stores the readings in its database. It can also import data from files sent via FTP by Northern Design CubeIP meters.
You can specify which channels you want, the start and end dates and interval between readings and XLeMs will extract this data from the database and write to an Excel file.
You can produce a Template using Microsoft Excel that displays the data in the format you want (eg. charts, invoice etc.) and then it only takes a few clicks to run a report based on the Template for the range of data you require. Reports can also be run automatically hourly, daily, weekly or monthly as appropriate.
The new (version 2.0.0) Instant Charting feature enables you to view Report data as a Chart (Bar, Line, Area or Point) without going via Excel. It only takes two clicks to copy and paste the Chart into any Office document :-
XLeMs can collect data from SHM UL-series loggers, devices supporting the oBIX protocol (SHM J-Loggers) and various formats of CSV file.
XLeMs can now act as an oBIX Server for historic data to allow reading of all data in the Readings Database.
XLeMs can act as a
Collection Engine for collecting data from all types of SHM Logger and other devices and allow other systems to access this data via either
FTP Push or oBIX. An Application Note shows how to do this.