Fully Automated Dashboard with Excel VBA

By |February 19th, 2014|Categories: Excel & PowerPoint Blog, VBA Development|

Client Problem: A local airport operator seeked us out to create a fully automated dashboard using Excel VBA. The airport operator collects customer satisfaction surveys using Ipads and the results are stored in an Oracle database. They run weekly management [...]

Excel-based Expense tracking tool for Ship Management

By |October 3rd, 2013|Categories: Excel & PowerPoint Blog, VBA Development|

Client Problem: A ship management company typically is engaged by ship owners to operate their tanker ships within a strict yearly budget. This company approached us to improve their Excel expense tracking tool for a fleet of 20 ships. We [...]

A Trading Database in Excel

By |September 23rd, 2013|Categories: Excel & PowerPoint Blog, VBA Development|

A commodity trader approached us to create an Excel VBA database application to store and manage trading records. The objective of this app is to increase productivity of coal traders to create SELL trades, manage multiple BUY trades, and execute [...]