As with any data entry software, human error can be somewhat unavoidable when updating engineering spreadsheets. However, these mistakes can have further-reaching ramifications if users are relying on these spreadsheets for mission critical calculations used for modeling or analysis. Various estimates suggest at least 80% to 90%+ of all spreadsheets have at least one error.
Issues such as errors in formulas, typos or formulas mistakenly converted to values can be very insidious, and may not reveal themselves until it is too late. Errors due to input mistakes can be reduced with EASA by embedding intelligence at the user interface level, thanks to our custom interface building capability. EASA’s architecture also completely eliminates propagating new errors as spreadsheets are not copied or forwarded downstream.
Lack of IP security
The IP embedded into your formulas, VBA and overall workbook can be difficult or impossible to completely hide or protect, plus spreadsheets are easy to duplicate and disseminate, whether intentionally or not. With EASA, this issue is a thing of the past, as users no longer will have direct contact with the actual spreadsheet, rather will interface via a separate web application.
When Excel is distributed to multiple users across a large organization or external to the organization, there is the potential for it failing due to simple mismatches between different versions of Excel, inconsistent settings, missing add-ins and other mismatches. Furthermore, people are increasingly making use of mobile devices to access these files, which adds another layer to the deployment mismatch potential.
By using EASA to turn your engineering spreadsheet into a custom-designed, web-enabled app, only a web browser is needed, eliminating any possibility of mismatches and unreliable deployment.