Automated systems are great at creating data and generating reports but they don’t always give us what we’re looking for. Microsoft’s Excel Pivot Tables provide an amazing ability to create and generate custom reports on the fly and it’s easier than you may think. Could this be a differentiation factor for how your company works with OEE data versus others claiming to do the same?
For some reason, Pivot Tables seem to be obscure and very few people seem to understand how much power they bring to the arena of data analytics. We recommend reviewing a site we discovered that presents some excellent tutorials covering a number of areas of interest including an in-depth look at Pivot Tables. If you’re overwhelmed by the volume of data that you have to contend with, I highly recommend visiting http://www.brainbell.com/tutorials/ms-office/excel/
Excel Pivot Tables can “connect” to external data sources and most systems provide the functionality required to support exporting data to Microsoft Office products and other platforms. You can discuss the options available with your system provider or your company IT administrator.
Of course, this means we’ll have to demonstrate how Pivot Tables can be used to summarize OEE results. Coming soon to our Free Downloads page. In the meantime, take some time to learn how Pivot Tables can be used to help you with everyday data. You won’t be disappointed.
We’ve also decided that to improve our spreadsheet solutions, we will start presenting spreadsheets that include the use of VBA. The added functionality provided by custom VBA routines is decidedly worth the extra effort.
Until Next Time – STAY lean!