RulesBase: Problems and Solution

Creating Models

Can’t reuse logic from one model to the next	A building block approach allows users to reuse logic from one model to the next
Replacing data in an existing model requires copying formulas, resetting subtotals, and rechecking everything	Logic in one model expands or contracts to the data provided; and reusing logic reduces the amount of rechecking.
Only one person can work on a model at a time	Users can work in parallel, building the “blocks” independently; and combining the results is effortless and quick.
Every analyst performs calculations differently	Allows the user to incorporate standard logic while providing all of the flexibility they are used to.

Modifying Models

It takes hours to make a seemingly simple change	Users can insert logic and data without fear of “breaking” a model.
Difficult to follow complex, nested formulas	Since the analysis is separate from the presentation, logic doesn’t need to be crammed into single, complex formulas.

Reviewing Models

Managers spend much of their time reviewing and re-reviewing, which only covers a sample of the logic	Self-documenting rules can be reviewed alongside the results, allowing for much better understanding of the logic.
Internal and External auditors spend a great deal of their time on spreadsheets	The underlying formulas and data, as well as any changes are maintained.
No one can tell who made changes or when	Maintains full record of who made a change and when.
SOX compliance requires a shift away from spreadsheets	Improved, and built-in, auditability will reduce SOX compliance exceptions.