My Work

I would like to share with you some examples of my work created for Clients, employeers, freinds or just plain fun. Where examples are from prior employers to ensure i do not provide any confidential data image's may have been edited to protect details such as Customer Details, Product Costs etc.

 

If you would like more information on a particular peice of work or to discuss anything else click on the Contact Me link for more information.

  • OS Compatibility: Windows XP, Vista, 7 and 8.1

  • MS Office 2000, 2003, 2007, 2010 & 2014

  • Launguages Used: VBA , XML , SQL
     

  • Increased Security
    Quickview plugin checked users profile access within background, where a spreadsheet was highliy confidential the plugin would not enable and thus the spreadsheets core functions such as access to data was hidden and locked down.
     

  • Optimized Files
    Each Excel file with QuickView were optimized in the background by Clearing dead links, rebuilding pivot cache and removing data not required using VBA Scripts all without inteferring the user while they worked on the file.

    The result was improved Open and Save time and reduced file size compared to those without the plugin
     

  • Improved Efficiency
    Over all users found any document with the QuickView plugin supported easy to find, open , edit and save knowing the report was safe from curruption from other users.

Quick View - Menu Plugin
 
Designed as a side project at home while discovering the benefits to VBA Plugins the Quick View plugin was eventually used within Woodward Foodservice Ltd, Country Choice and Brakes.
 
The idea was a background code and Front End Plugin that allowed users to instantly access frequent files and locate, edit and save them in the most efficient manor possible.
 
 
In total the Plugin enables over 300 bespoke excel reports an forms.

This ensured a standard format was enforced across the business, reducing file size's and increased admin process time typically wasted when trying to locate and figuire out a non standard format.

The plugin has a built in Authorization process that validated each users Windows network access and adapted it's structure by showing only area's the user was authorised to use.

 

Outlook cache converter

Designed using VBA within excel a plugin converts data from a Customer enquiry form within an email body and formats it into a text cache file that feed's an access database.

 

The excel element enable's the user to check the information converted and make any adjustments before loading into Access.

 

This significantly reduced the time spent processing customer enquiries as prioviosly the administrator would manually copy and paste or retype the information into an excel work book and then importing into access.

  • OS Compatibility: Windows XP, Vista, 7 and 8.1

  • MS Office 2000, 2003, 2007, 2010 & 2014

  • Launguages Used: VBA

Journal Upload Tool

Built within Office 2010 in compatibility mode for backward compatiblity.
 
The purpose of this spreadsheet was to allow accountants to copy data from existing spreadsheets or input manually adjustments and post into SAP the results.
 
What the Journal tool did was convert the spreadsheet data into a compatible SAP upload file within a text file.
 
Without this tool users would have to manually post into SAP directly for every entry line,  this would take a hugh amount of time and resource.
 
There are three types of the Journal upload tool each slightly different and all used Nationwide across Brakes Group.
PowerArchiver - Tutorial Video

A very breif video tutorial for Conexware's PowerArchiver explaining how to do the following;
 

  1. Access Configuration Screen via Ribbon

  2. Access Configuration via shortcut keys

  3. Save & Backup Configuraton settings

  4. Import previosly saved configuration settings

 

SKY Router - Product Review

I created this video review of BSKYB router due to not being able to locate information on it previosly.

 

So far over 16,000 views and have I received emails for more video reviews on other products.

Just a sample of my work. To see more or discuss possible work >>