Mark E Taylor IT Consulting Limited

Various projects I have completed outside of work. If you have any questions please get in touch.

  • Live power consumption graphs using OpenEnergyMonitor hardware and NanodeRF
  • I have finally managed to get my OpenEnergyMonitor project working. Here is a graph of the real time power consumption at my house. Note: some of the early data is spurious and makes the chart look rather odd. More details to be published here later when I get a chance.

    I have had a small case 3D printed by Shapeways to house the NanodeRF. See here. You can download the SketchUp 3D model from here.

  • Current Cost power consumption meter data published to iPhone. Using Perl, RRDTool and iWebKit.
  • During the early part of 2009 I created some Apple iPhone optimised web pages to show the output of a Current Cost power consumption meter. I used some simple Perl code, RRDTool and iWebKit to create the pages. Here is an article (PDF) describing how the project was created. The actual web pages created by this project are here.
  • Network connected temperature sensor. Using Arduino, MQTT and Perl.
  • In January 2010 I started a small project to create a network attached temperature probe. This project made use of an Arduino micro controller and and Ethernet shield. The Arduino is loaded with the MQ Telemetry (MQTT) client which in turn sends messages to a Really Small Message Broker (RSMB). A simple Perl CGI web page then subscribes to "topics" published by the RSMB. The whole is system is embarrassingly crude, but it does work. I am certainly no programmer, and yet I am pleased with the result. Here is an article (PDF) describing how I created the project. The web page created by this project is here.
  • Waterrower S4 monitor data logger. Using Perl and MySQL.
  • I have been using a Waterrower rowing machine for quite a number of years. However I wanted to record the data from the S4 monitor automatically. I could not find an application to do this that ran on a Apple Mac. So I set myself a small challenge to learn the programming language Perl to record the data in a database. The application will record the data output from the S4 monitor at regular intervals and store the samples in a MySQL database. If a heart rate monitor is attached to the S4 it will also record that data as well. At the end of a rowing session the application calculates a summary of the data. This application is a very crude but it does what I need it to do. Here is an article (PDF) describing how I created the project. You can download the application code from here.
  • Waterrower S4 data output to Excel spreadsheet. Using a Perl script.
  • Following on from the project above I have since written a new Perl script to create an Excel spreadsheet from my Waterrower data. My original project was to capture data from a Waterrower S4 computer and store it in a MySQL database. This project extracts the data from the database and creates an Excel spreadsheet. In addition a chart is created from the data and embedded in the spreadsheet. At this time I only extract three data elements; time, heart rate and distance. From these a chart is created showing heart rate over time. The application was written in Perl on an Apple Macbook Pro, but should work equally well on a Windows system which has both Perl and MySQL installed. The Perl script and the documentation can be downloaded from here. An example spreadsheet is here.