OBJECTIVE: Overhaul and enhance timesheet check report automation.
SOLUTION FORMAT: MS Excel driven by VBA (Macros) add-in. User operation via custom ribbon.
OBJECTIVE: Daily automated reporting of rusted pipe-ends remediated by engineers in the field as part of a project to restore them to a suitable condition prior to welding on the ship before being laid on the seabed (Russia – Turkey).
SOLUTION FORMAT: MS Excel driven by VBA (Macros) using Dropbox to remotely sync .jpeg images and pipe barcode inputs into an Excel front-end. User navigation via main Dashboard interface to input barcodes and instantiate tablet camera so as to capture before and after .jpeg images in order to prove that each individual pipe had been cleaned.
OBJECTIVE: Automation of the reporting, production and reconciliation of Credit Notes issued to their dealer network on a monthly, quarterly and annual basis.
SOLUTION FORMAT: MS Excel driven by VBA (Macros). User navigation via customised ribbon to operate model. Manual copy / paste replaced by simple mouse clicks.