Some businesses choose to replace these data-centric spreadsheets with specific database applications, but in cases where there are formulas and logic being executed, a pure database application often is not suitable. The embedded logic in the spreadsheets is often specific to the business and is difficult or impossible to incorporate into a database application. EASA is specifically designed to work with the “spreadsheets as a database” while retaining the business logic and calculations.
EASA allows you to integrate external relational databases with custom-built web apps, allowing for data transfer with both read and write capability (two way integration). Multiple databases can be integrated, allowing more than one data source to supply information if necessary. This allows the data to be stored safely and clearly, while the logic remains safe in the spreadsheet that powers the web app. Users can easily access the data without the risk of accidentally altering it or any formulas within the spreadsheet.
Each user accesses the data through a browser-based portal while the spreadsheet itself remains safely stored and not directly accessible. Integrating your chosen database software with each custom-built app ensures that all formulas, macros, and VBAs that run in your spreadsheets remain operational, while eliminating the risk of being inadvertently lost or altered.
