Latest Seat Projection

Update: Forgot to mention the source of this data:  Abacus.  Poll date: August 31, 2015.  Map colours also updated to make things easier to understand, and added an additional map. (September 5, 2015)  Note to mobile users:  This program isn’t perfect for you, yet; but I will be adding that functionality in due time. I…

Read more

Grocery Promotions

The Issue The client has a large customer base – retail outlets selling grocery products to end consumers.  Each sales cycle, sales data would be sent to the client for processing.  From that data, product promotions unique for each of the client’s customers would be developed and then forms – again, each form unique to…

Read more

Forecasting Application

The Issue: The client has a number of departments and resources within their office environment, and, for budgeting purposes needed a way to forecast the number of hours applied to any given job, which was the responsibility of various project managers within their firm.  Each project manager would provide a forecast to their central office,…

Read more

Metrics Tracking Application

The Issue: The customer is a data management company for a number of large customers in a very large market sector.  As their customers had a large amount of documents being checked out and checked in, updated, maintained, indexed, and, where necessary, destroyed, the customer needed a distributed application for data entry which could have…

Read more

Excel Merge Macro

The Issue: The client used SharePoint to distribute data entry across a number of different locations.  Each location would update the data in an Excel workbook, and the customer needed that data integrated into a centralized Excel workbook to manage their inventory database, from which would be uploaded and synchronized with a Magento-based eCommerce platform….

Read more

DataGrator Suite

The Issue: The client had a large dataset of survey results in CSV format, and needed a way to massage the CSV file into a simplified version and import the result into Excel for further processing.  Once imported into Excel, the client needed a way to to aggregate the survey results into standardized results for…

Read more