Meal Delivery Web App

Delivery app on mobile phone

Bespoke Meal Delivery Web Application

Back office task automation, customer self service and billing platform

Mobile friendly web app reduced overheads by 80hrs per week

screen-smartphone

Mobile Friendly Web App

Made it easier for customers to buy meals and edit their preferences

pie-chart

Automated Meal Algorithms

Replaced the need for manual meal planning

graph

Planning and Reporting

Reduced prep times and food wastage

grid

Third party software integration by API

Connections to Stripe car payment software, and postcode lookup software by API

Client Needs

A healthy bespoke meal prep company, with a rapidly growing business in London, the team was creaking under the volume of manual administration in spreadsheets, emails, and Word documents. They needed to reduce their administration burden to make the business scalable.

The Challenge

The team had limited availabilty to work on the project due to overwhelm as a result of manual customer management and back office administration processes taking up all their time.

Our objective was to automate as many tasks as possible including customer communications, creating customer eating plans, producing food labels and information sheets and planning ingredient orders, kitchen prep sheets and compiling delivery information.

The Solution

Because of the pressing administrative burden and the complexity of the end requirements we took a two phased approach, to relieve pressure from the team immediately before implementing a long term solution.

We began by automating many of their existing processes using VBA in Microsoft Excel. This reduced administration by about 40 hours per week and freed up the operational team’s time and resources to work on the next phase.

Next we replaced spreadsheets entirely with a mobile friendly web app on our Laravel based framework, that made it easier for customers to pay by card for their services (using Stripe API), reduced administration and kitchen overheads by a further 40-60 hours per week, and reduced food wastage by around 50%.

Streamlined processes put the business in a position to franchise and scale.

SCADA Reporting in Excel

SCADA Reporting in Excel

Automation of SCADA Reporting in Excel for International Firm

Fast SCADA reporting and improved feedback using Excel

layers

Automated SCADA Analysis

We wrote custom algorithms to automatically process the data produced by the client’s SCADA system and turn them into useful feedback reports.

speech

Enhanced Language Usability

To allow the company to use the system in multiple countries we incorporated a language translation feature that allowed the end user to choose the language to be displayed on reports.

clock

Speedy Delivery

This job required a fast turn-around (two weeks), and the client appreciated our quick response

Client Needs

An international fire training company wish to provide more detailed and immediate feedback to trainees based on SCADA outputs. With locations in 40 countries they also needed to provide outputs in different languages.

The Challenge

The client’s fire training simulators deliver intense live-fire training, replicating the heat and flames of a real fire emergency and allowing firefighters to battle situations they would find in real-world emergency situations. They capture real-time sensor data at millisecond level which is output to a SCADA SQL database.

This sensor data is then used to monitor how trainees are performing and to deliver feedback. Available SCADA reporting software was costly and not specific to their needs.

The Solution

Following an initial discussion period by phone, e-mail and remote screen sharing, we began with a prototype to demonstrate what could be done and to ensure that it had got to the heart of the client’s brief.

Next we developed a system in Microsoft Excel, using custom algorithms written in VBA, to automatically process the data produced by the client’s SCADA system and deliver:

  • dynamic charts and reports;
  • graphical representations of what was happening during a training session;
  • improved speed of feedback in the field.

As a result, the client could give much more immediate and usable feedback and analysis to its trainees – making training sessions much more engaging – whilst also saving on the cost of other SCADA reporting software.

EPOS Data Analysis

EPOS Data Analysis in Microsoft Excel

Production of KPI reports from EPOS data exports for restaurateur.

EPOS data analysis in Microsoft Excel

chart

Improved Business Insight

By compiling daily EPOS exports into useful tables of information we were able to create detailed reports on the effectiveness of restaurant promotional activity.

wallet

Time and Cost Saving

The owner avoided having to pay for a costly EPOS upgrade by getting more out of their existing data.

clock

Fast Turnaround

Building on our library of existing VBA modules meant that we could quickly produce a system that was easy for the restaurateur to use.

Client Needs

A US based restaurateur wanted to understand the effectiveness of their sales promotions.

The Challenge

The existing EPOS system did not provide their desired data analysis functionality and the client was faced with a costly EPOS upgrade or replacement.

The Solution

Data exports were available from the existing EPOS system in the form of .txt and .csv files so we created a user-friendly interface for importing and managing these files.

Using Excel’s programming language, VBA, the system compiles the daily exports into organised tables with useful KPI’s saving the client time and money and giving them the desired analysis.

CRM Database Cleanse

CRM Database Cleanse

Pre-migration CRM database cleanse, formatting and validation

CRM database cleanse and UK phone number verification

arrow-right-circle

Effective Migration

Cleaning and reformating the CRM database before migration ensured the successful upload of data to the new system.

clock

Time Saving

Client received their clean data back within 2 days, saving them weeks of time trying to clean the data and check it for exceptions manually.

refresh

Better Quality Data

By removing data exceptions and matching contacts between companies we were able to identify company contact numbers for thousands of contacts with missing information.

Client Needs

The client wanted to migrate contact records between two CRM systems that required different data formats.

The Challenge

Before completing the data upload into the new system they first needed help to clean, verify and reformat the entries however with around 80,000 inconsistent contact records, it was too large a task to complete manually.

The Solution

After discussion by telephone we agreed a clear set of rules, logic and principles to apply to cleaning up the data including:

  • removing unwanted characters and symbols from phone numbers;
  • replacing +44 UK international dialling codes and preserve leading 0’s;
  • removing non-numeric entries;
  • removing duplicate numbers within each records;
  • verify phone numbers against UK geographic, non-geographic, mobile and premium dialling codes;
  • match clients by name and copy HQ phone numbers across where departmental entries were missing.

Our VBA developers used a mixture of our existing modules in our code library and custom code to complete the operation. By automating data cleaning processes and UK phone number verification in Excel (using VBA) we were able to provide a clean set of data to the client in a short turnaround of only two days allowing them to quickly migrate the system.