Some organization moved their business logic to Excel files, that are integrated with several systems. Of course, such approach has its advantages, if you compare it to hard code everything alternative:
Business users are familiar with Excel, so they can create and modify business logic without the need of programming nor IT specialists.
Excel supports many complicated mathematical functions.
However, this solution is not perfect:
The structure gets more and more complicated as it involves more spreadsheets.
It's hard to maintain the files, because there are kept locally. Sometimes the changes aren't merged, if two or more users work on the same file simultaneously.
You have to hard code some logic in order to interpret Excel files and keep them in sync.
If you want to keep all the advantages of keeping the business logic in Excel files and eliminate all its flaws, consider migrating the business logic to Hyperon. Your architecture will get so much clearer and easier to maintain.
Business rules and parameters kept in Excel
Rings represent systems using business logic kept in spreadsheets.
Business rules and parameters kept in Hyperon
Rings represent systems using business logic kept in Hyperon.
More features
your business user will be able still work in Excel thank to import/export feature,
you will manager user privileges easily,
create and maintain many versions of the parametrization.
