August 24, 2021
Each week, XI Technologies scans its unique combination of enhanced industry data to provide trends and insights that have value for professionals doing business in the WCSB. If you’d like to receive our Wednesday Word to the Wise in your inbox, subscribe here.
Despite software solutions purpose-built for oil and gas companies to manage, track, and calculate ARO, many companies choose to manage their ARO programs using spreadsheets. At first glance, it’s easy to understand why. For many people, spreadsheets are easy-to-use, highly customizable, and come at no additional cost. It’s the tool people are accustomed to using to calculate various business costs, develop plans, and build and share reports.
But as ARO management has grown in importance and complexity, managing an ARO program through spreadsheets is less than ideal. The initial benefits of spreadsheets – flexibility, familiarity, and affordability can’t overcome the challenges posed by utilizing a tool never made for this job.
Some might scoff at the notion that spreadsheets aren’t up for this job. There are Excel Wizards out there capable of creating remarkable spreadsheets, harnessing the power of the tool to create complex workbooks custom-tailored to meet their needs. The issue is that spreadsheets are just that – customizable to meet the needs of their creator. They are personal productivity tools, not mission-critical applications to be used across departments and entire companies. People build them with their own logic, understanding and a unique endpoint. They aren’t meant to be managed and used by multiple users with differing needs.
That VLOOKUP formula, complicated cell, or field that makes sense to one user might not make sense to the next, leading to confusion, errors, and over-dependence on one expert to manage the entire ARO reporting process. And as a company’s assets and liabilities grow, even a properly maintained spreadsheet can become too big and unwieldy to manage.
Through the years, we’ve had many customers share their own personal spreadsheet horror stories as they replace their old processes with our standardized, web-based AssetBook ARO Manager. The stories themselves are varied, but all share a similar theme: the spreadsheets that once got the job done were now making the job far more difficult than it needed to be.
A sampling of these issues can be summarized as follows:
When you factor in the time spent building and updating spreadsheets to manage ARO processes, the time lost to corrupted files or confusing layouts and lengthy load times, and the added difficulty in satisfying auditors, free spreadsheets start to become a lot less cost-effective than they initially appear. ARO management has grown into far too important and too large a process to be trusted to a custom-built spreadsheet. Companies need a more standardized approach that can be easily used by anyone throughout their organization, and the protection that comes from a fully auditable, cloud-based solution.
XI Technologies provides just such a solution with AssetBook ARO Manager, the industry’s premiere web-based tool for estimating and monitoring asset retirement obligations in the WCSB. Our soon to be SOC Compliant tool tracks any changes to data made by your team, so you can save time on your audits. You can read more about the various struggles our clients have had with their ARO spreadsheets, including dedicated hardware solutions and “the Rainbow Unicorn Spreadsheet of Barf” in our latest case study “The Problem with Spreadsheets in ARO Management” or contact us for a demo.