Wednesday 20 March 2013

Contract extension and new client

My contract with Three has been extended again, now until the end of May.

I've also recently picked up another dashboard order, this time from Anchorpoint, the sister company of Astrak.  They want a simple 4 sheet Dashboard containing two "fuel gauge" type charts to show the daily status of orders etc, as well as two monthly trend views.

To make things more interesting, they want it shown on a large TV in the office, with each sheet cycling every 10 seconds.  I've manged to set this up using some VBA code that also removes all scrollbars, column and row headings etc in order to maximise the charts on the screen.  The slideshow is started with the click of a button, and stopped by clicking another, which also replaces all the scrollbars etc, ready for them to add new data.

I'm really pleased with the way this works and can see me using it again in the future.  Showing live dashboards on a large screen in a busy office is an excellent way of keeping your staff on top of any issues that may be occuring, and letting everyone know how the company is performing at that period.  In this case, the data is updated many times a day, meaning that the KPI's are almost live.  Staff can respond more proactively as a result.