I currently load daily performance data into an Excel spreadsheet stored on our company server. The spreadsheet calculates weekly summary metrics from my daily detail data entries. The metrics include such things as; weekly shipments, on-time-delivery and shipments past due. The resulting summary statistics are all calculated as ‘percent to goal’ type metrics.
I would like to develop a way to graphically and simply display the resulting metrics on our company website. Is it possible to create a Flash movie that could automatically refresh a series of ‘thermometer’ type animated images directly from the Excel files?
Other than to ask the question, I’m not really sure where to start. Has anyone seen this done before?
