Case Studies

order input form

Order Tracking and Invoicing System Most businesses have some kind of tracking or invoicing system.  To do such menial tasks without a computer would be considered madness. So many of our customers ask us to build or add functionality to…

portfolio management spreadsheet

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

Stocks and data

Excel: Lego for Data (1995) My first introduction to the world of Excel, or as I like to call it, ‘Lego For Data’ was back when I was a sole trader, before switching to working in small business IT… The…

environmental science tag

Building a dashboard for Science 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#,…

Estimated driving times

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…

Environmental modelling

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…