Rohan|Ghatpande

Introduction|:

Recently at work I had an opportunity to work on designing and building a metrics reporting system. We built a data warehouse to garner data from sundry sources (software tools,systems) and then developed a front end reporting system to deliver metrics which helps the Senior leadership check the pulse of the product development quickly and effectively. I had recently purchased a new car and with all the excitement of a shinny new ride came the concerns about the maintenance and fuel costs of the vehicle. After much thought and analysis I concluded two metrics will help me keep a track of the running costs of the vehicle.

• 1. Mileage(MPG) as performance tracker
• 2. Cost per Mile (CPM) as a fuel budget monitor

Data|Capture:

I needed to come up with an effective and slick way to capture the data in order to track these two metrics. Remembering and noting down in an excel sheet was not working that well as I often missed data points. I realized that 90% of the times I had my Droid when I filled up my gas. So in order to harness the power of the cloud...

• 1. I moved the excel sheet to a google spreadsheet.
• 2. Created a form for based of the spreadsheet
• 3. Wrote a script to calculate metrics and attached it to OnFormSubmit trigger
  
• 4. Created this web page which calls the spreadhseet and displays the metric in the Annotated time line