Case Studies


Order Tracking and Invoicing System We built the Order tracking and Invoicing system for a film processing agency that wanted to keep track of their clients orders as they passed through their factory. Information from the arrival package was scanned…


Using Excel Dashboards, we built the property portfolio workbook for an estate agency, to help them to keep track of their clients’ property portfolios and investments. The idea  was that the agent put in the necessary data and the workbook calculated…


Excel: Lego for Data (1995) was my first introduction to the world of Excel, back when I was a sole trader, before switching to working in small business IT… The person I used for my IT then had installed Office…


Science dashboard in Excel The science dashboard in Excel offers the combination of a very powerful analysis engine, matched with a colourful and animated front end. We use VBA and .net languages… such as VB.net or C#, to write the…


What postcodes can say about you or your clients What does a postcode say about you or your clients? We cut down trees and turn them into junk mail-surely anything that can reduce wastage is a good thing. Postcode analysis…


Environmental Modelling – Monitoring and Models Environmental modelling and monitoring with estimated driving times can play a vital role in spacial data analysis. Customer address lists can be fed into a GIS system, and processed… Customer address lists can be…


There is a real need for mathematical models to simulate or model various environmental systems, such as water or air quality. Environmental quality measure  taken in the field need to be fed into a simulation/model that then computes various coefficients such…