XLeMs

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 SHM loggers 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.

• Uses a relational database to store readings and system configuration
• Easy to configure
• Reports are generated as standard Excel workbook files
• Data functions include Absolute reading, Reading difference, Minimum, Maximum, Average, Half- hour MD
• Simple user interface to browse configuration and data readings
• Schedule actions (eg. Collect Data, Run Report) at hourly, daily, weekly, monthly or yearly frequency
• Automatic sending of Reports via Email as attachments
• Automatic exporting of charts in your Reports as GIF files to your website
• Automatic exporting of Reports via FTP to a server
• Automatic Emailing of Alarm Reports if an alarm condition is detected
• Special Reports to facilitate invoicing/billing
• Built-in "Quick Reports" to view data for any channel in various formats
• CSV format reports to export data to other applications
• User-definable Constants Table to provide an easy method for updating fields in multiple reports
• Configurable Date Offset on each channel to facilitate comparisons with previous data
• Improved Channel Headings with dynamic parameters

We have XLeMs running on one of our servers monitoring a house in Winchester.  It uses the GIF Export feature to export charts showing Electricity, Water and Gas consumption to the SHM website.

Visit the Live Demo of XLeMs monitoring Energy, or see XLeMs being used to monitor Red Squirrels at www.RedSquirrelWatch.org.uk .

Click here to view the XLeMs brochure (62k).

A full manual is available on our technical manuals page, and we have an application note describing how to use XLeMs for simple tenant billing applications..

The latest version of XLeMs is 1.4.0, released in September 2011.

Click here to download the software (11.5 MB) for evaluation.  Contact SHM for a demo licence and details of an on-line datalogger you can collect data from.