Sunday, December 20, 2009
Dashboarding the program in #Excel well underway
Down to 2 Excel worksheet tabs, from well over a dozen. Goal is to get to a single sheet, but the volume of data, screen real estate, and the fact that it is reviewed in a conference room rather than printed all factor it. I'll get there, but I like the progress so far.
I have a tab with a dynamic chart to review planned orders by assy (over 50 assemblies). Another tab to review upcoming total production volumes by type/workcenter. Need to add demand management and WIP data, then scale it all down to a single sheet.