PRACTICAL EXPERIENCE AND AUTOMATION
Throughout my professional career, I have designed and developed several applications to make everyday tasks easier and more efficient.
Below, I present four projects, ranging from earlier automation solutions using Excel, Access and VBA to a modern web application for a local community transport service.
For each project, I explain the problem, my solution, my personal contribution and the results achieved.
Integrated web application
Two existing Excel applications were combined into a single web application for daily trip scheduling and weekly driver planning. This allows planners to work with the same up-to-date information.
Read the project and view screenshotsTrip and weekly scheduling with VBA
Manual planning in Google Spreadsheets was replaced by two Excel applications. These made trip registration and the preparation of weekly schedules easier and more organised.
Read the project and view screenshotsMicrosoft Access 2010 and VBA
A custom-built application that allowed security patrol reports to be recorded centrally and automatically saved and emailed as individual PDF reports for each client.
Read the projectMicrosoft Excel 2010 and VBA
An integrated application for my security company, combining employee scheduling, time registration, allowances, commuting mileage and customer invoicing.
Read the project