Do you love spreadsheets? I do! I mean what’s not to love, all those columns, rows, formulas, and don’t forget, pivot tables!
But seriously, spreadsheets are easy to manipulate and most of us have used them at one point or another. In fact, I bet you can’t find an engineer without a spreadsheet.
Even though spreadsheets might seem like an easy solution to managing your asset performance management (APM) program, I’m here to help you realize there are at least seven reasons why they won’t. Take a look below:
Do you want to operate your plant or facility based on errors? Spreadsheets can be easily manipulated, but that can mean more opportunities for spreadsheets to contain errors.
Unlike spreadsheets, APM solutions are tested and go through formal verification processes. You can trust the data collected in APM solutions are error-free.
Where do you store your spreadsheet? On a shared drive? In a cloud? That’s all well and good but how do you maintain control over it? How do you track revisions and changes? How do you test those changes? Do you know who is responsible for making those changes? Is your sensitive company data now out in the cloud in an unsecured location?
These are all questions to consider when thinking about your assets. APM solutions are designed to hold your company data in a secure manner, with the right level of access to the right individuals. This provides clearer visibility and transparency.
By using a spreadsheet, you cut ties to much of the available data coming from your assets. Sure, you can make connections, but with an APM solution you can connect disparate systems—such as historians, EAM systems, and condition monitoring solutions—into one integrated view. This type of connected data can drive an effective APM program by providing a single-view of risk, maintenance prioritization, and optimizing costs.
4. Analysis vs. data manipulation
Spreadsheets require a constant effort to add new data and maintain existing data. With an APM solution, you can bring data together and measure its accuracy where appropriate as well as automate the data to gather analysis.
Think of it this way, an APM solution allows engineers to solve problems (often times in real-time) instead of being IT data scrubbers.
What happens if the person responsible for updating your asset performance spreadsheet leaves your company? What about the person who is analyzing the data? The knowledge captured in that spreadsheet can be lost or passed along with little training.
By using intelligent asset strategies, human recommendations are continuously collected and balanced with operating parameters, analytics data from systems, and data from physical assets. This way, you’ll have a seamless library of tribal knowledge that is passed along to the next generation of employees.
6. Leveraging mobility
Sure, you can view a spreadsheet on a phone or tablet, but is that an effective way to communicate information that will help run a business?
APM solutions offer robust mobile capabilities that include capturing data from any location as well as the ability to view and manipulate that data in real time. This will not only help drive your business objectives, but help you make more informed timely decisions about your assets when necessary.
7. Automation and predictive analytics
Today’s leading APM solutions offer automation capabilities that are impossible to create in a spreadsheet. And last time I checked, it was not easy to gather predictive analytics from a spreadsheet. APM solutions can offer these with a few simple clicks. Again, this makes achieving and surpassing your business objectives through asset performance obtainable.
As APM solutions define more connections and analytics, the gap between a basic spreadsheet and APM will only continue to grow.
So, can asset performance management be done in a spreadsheet?
I hope these seven reasons convince you the answer to that question is no.
If you'd like to learn more about GE Digital's APM solution and implementing intelligent asset strategies, click here.