Excel to Web App

Molson Coors

A graphic of a clipboard with paper attachedThe Client’s Need

This client was using multiple spreadsheets to calculate their labour requirements and cost projections. They needed a tool to bring all of their complex data together into an easy-to-use application to save on time and effort.

A graphic of 4 interlocked puzzle piecesThe Project

Their many spreadsheets were consolidated and converted into a single web application that displayed a simple form to users to fill out and all calculations were done from this one input location.

A deep understanding of their complex business led to success in automation and projections.

A graphic of gearsComponents

  • Advanced database module

Common

  • Pleasant reusable core
  • Pleasant visual data modeller

A graphic of a USB thumb driveTechnology

  • Microsoft .NET Framework
  • C#
  • LINQ
  • MVC with AJAX
  • HTML