Tel: 07795 233648
Email: info@bluecattechnical.co.uk
Background and Aim
A local manufacturing company needed a simple tool to manage customer complaints. This tool had to be accessible by all members of the customer services team and they had to be able to use it immediately with little training.
Approach
This was a "quick and dirty" tool developed over a couple of days. That, along with the limitations on software available to the various potential users, meant that MS Excel was chosen as the development environment. This allowed a single master workbook to be maintained and managed on the company's server, accessible by all, but only editable by one at a time.
With the use of a bit of VBA (Visual Basic for Applications) a basic tool was developed that allowed the user to enter, manage and view complaints through simple forms without ever actually having to use the underlying spreadsheets.
Result
Stricly speaking this was an "unoficial" and free piece of work done over a few evenings for a local company. That said, the resulting tool is still being used in anger and gives a good example of what can rapidly be developed to aid office life.