Excel to Web Solutions
Use your spreadsheet as the “logic engine”, and keep users from ever touching the spreadsheet directly by interfacing via an EASA web app.
Microsoft Excel is often the go-to tool for numerous business applications, but the use of spreadsheets can spiral out of control when they are shared or used as part of collaborative processes. Nearly everyone has experienced version confusion, exposed intellectual property and undesirable changes being made to their shared spreadsheets.
However, many spreadsheets are the result of years of continual refinement and validation and represent a surprising amount of investment. They often provide critical and unique value to an organization. Replacing them can be expensive, technically difficult, and ultimately unpopular. Thankfully, EASA’s platform, installed on your network or in the cloud, provides an easy solution that continues to use your existing spreadsheets, complete with VBA and macros, while eliminating any direct contact between the user and the spreadsheet. This completely eliminates all the major problems associated with sharing and collaborating using Excel.
Eliminate Chaos by Turning Excel Spreadsheets into HTML Applications
When spreadsheets are shared and exchanged, a host of familiar problems can arise. Formulas can be overwritten. Out of date versions of a spreadsheet may inadvertently remain in circulation. Sensitive intellectual property may be at risk of exposure. Spreadsheets don’t always work due to mismatches of settings or computer software.
EASA, installed on your corporate network or in the cloud, enables you to create a web interface (web page, HTML, portal, etc.) that can drive your native spreadsheet, including any VBA, macros and add-ins, while completely eliminating the need to email, download, copy or edit spreadsheets. This means that your spreadsheets remain completely secure and unalterable, and only the latest, most up to date version is being used.
Transform Excel Spreadsheets into Secure Web or SaaS Portals
A common application of EASA is for the creation of web portals, which provide an online resource where information and calculations can be easily but securely accessed and shared. If you have an Excel spreadsheet with the functional capability you need, EASA software, which can operate on your corporate network or in a cloud, enables you to convert it into a web portal or web page without the need for any programming, and with no danger of exposing the spreadsheet to your portal visitors.
Your webified spreadsheet can then be used by both internal and external staff such as partners, resellers, suppliers and customers, or for subscription based, “SaaS’ (Software as a Service) applications. Often, it is very important that these portals have an elegant and sophisticated appearance. EASA enables you to create a completely custom user interface, with no programming required, which can completely mask the fact that a spreadsheet is actually running in the background, if your use-case requires this.
Some typical web portals created with EASA include configuration and pricing calculators, financial and tax calculators, engineering or scientific calculators, or online demonstration or training applications.
Turn Excel Spreadsheets into Web Applications – With VBA or macros
(Configure, Price, Quote)
Embrace your Excel spreadsheet-based system rather than replace it with an expensive-to-implement commercial CPQ solution.
Insurance Raters & Scenario Modeling
Complex and highly proprietary spreadsheets used in the insurance-reinsurance and financial industries are transformed into secure, enterprise tools easily integrated with policy management platforms and CRM systems.
Engineered to Order
Simplify complex Excel-based manufacturing processes by creating an enterprise web application that is powered by your existing software.
Many industries rely on Excel to create financial models in Excel for many purposes, such as forecasting, profitability, risk management, and many others. EASA allows you to transform your Excel-based financial models into secure, polished web apps.
How is EASA different from other Excel to web and Excel sharing technologies?
Secures Intellectual Property
Spreadsheets often contain proprietary information and business logic that must not fall into unauthorized hands and must not be altered. Because the EASA solution eliminates any user handling of your native Excel files—no emailing, copying, downloading or editing of your spreadsheets—it completely eliminates the possibility of exposing your critical IP, or allowing it to be modified in any way.
Eliminates version confusion
EASA ensures every user is always using only the latest and most up to date version of the underlying spreadsheet. Only you, as the administrator, can update any time by simply uploading a new version of the spreadsheet into the EASA system.
VBA and macros remain fully functional
EASA technology is unique in that it does not rely on any conversion, translation or compiling of your spreadsheet. When spreadsheets are reconstituted by conversion or compiling, they must be revalidated to ensure they still perform as they did as native spreadsheets. Furthermore, it is not possible to reconstitute a spreadsheet that contains VBA or macros. But with EASA, your native spreadsheet continues to be used in its native form by the EASA system, which means that your VBA and macros still perform exactly as intended.
Eliminates Excel compatibility issues
When deploying spreadsheets throughout an enterprise, mismatched versions of Excel, settings, or simply the lack of Excel on a non-Windows device can prevent spreadsheets from running properly or at all. EASA completely eliminates this type of failure, as Excel is run on dedicated, secure servers (on your network or cloud based). Access for authorized users requires only a web browser and does not require any additional locally installed software. This means mobile devices can be used as well, with no app download required. EASA customers have seen increases in reliability when deploying new or updated spreadsheets go from less than 50% to near 100% across the enterprise.
Errors due to input mistakes can also be greatly reduced by embedding intelligence at the user interface level, thanks to our custom interface building capability.
Multiple users can access your spreadsheets
EASA lets multiple authorized users make use of the same spreadsheet without needing to check it in or out, with zero risk of overwriting or exposing another user’s work.
Works with virtually all software
Create web apps that are compatible with CAE, databases (including ERP, PLM and CRM systems) scripts, in-house, legacy software and much more.
EASA provides database functionality
EASA comes with its own relational database and saves only the key data each time a spreadsheet is used. The data generated when you execute your spreadsheet is automatically saved in the relational database for efficient and convenient reporting, analytics and data aggregation. This prevents spreadsheet proliferation, ensuring that everyone is working from the same mass document.
On-premise or cloud based, access with any browser
EASA can be resident on either your corporate network or in a private cloud. Either way, access to your spreadsheet app only requires a device equipped with a web browser and an internet link to your network or the cloud (which must be authorized by either EASA’s or your corporate authentication system). Windows, Apple and Android devices can all be used – access to spreadsheets is no longer limited to Windows! The accessing device, or client, does not require Microsoft Excel to be installed on it.
Process automation, workflow management and e-signature capabilities
If needed, EASA enables you to integrate and automate your native spreadsheets with a wide range of other software and data sources. Typical integrations are with databases, CRM systems such as Salesforce, ERP systems such as SAP, and engineering simulation and modeling software. Workflow management enables you to segment and enforce processes, for example requiring an approval or signature before allowing the process to continue.
Ability to create a fully custom user interface – with no code writing
While the standard column-row format for your input and output fields may be perfectly sufficient, there are cases where a more elegant or intuitive design of the user interface is desired. EASA provides you with the option to create a completely customized, non-spreadsheet looking webpage interface, with greater error trapping and “intelligence” beyond what can be easily built into Excel – all without the need for any programming. The no-coding requirement of EASA means faster creation of your apps, and a greatly reduced or complete elimination of the need to enlist your IT experts or software developers to build them.
Automatically log usage details, fulfill compliance and regulatory requirements
EASA records what version of the underlying software was executed by your app, and provides a complete “audit trail” of usage: Who used which app, when, and with what result. EASA ensures a rigid and repeatable process (and no need to keep re-validating spreadsheets) that along with the audit trail can assist gaining compliance certification even when spreadsheets are being used.
Using EASA: How to Convert a Spreadsheet into a Web App
Don’t Wait for IT or Software Developers
to Build Your Solution
One reason that Excel is such a popular tool for businesses is that it enables people who need a solution to create one for themselves, rather than relying on IT or outsourcing to external software developers. EASA extends this advantage with low-code technology that requires no programming experience, enabling anyone to easily implement the Excel to web transformation.