BXL Integrity Checks Walkthrough

Error alerts and performance alerts made easy Download Best Practices Guide free: https://www.dropbox.com/s/bcuklqx6nsi12e2/BXL%20Checks.pdf?dl=1 Download Add-In at: https://www.eloquens.com/tool/zQyzt7R3/finance/excel-add-ins/bxl-integrity-checks-add-in Adding alerts helps customers succeed and can save our reputation. It is a best practice recognized by all major modeling standards. BXL Integrity Checks makes adding best-in-class error alerts and performance alerts easy Error Alerts The last thing I want is for customers to find errors in my work. The thought makes me ill because I know my reputation will suffer. I also know all complex models have errors during development which must be driven out. As we build models, changes on one worksheet can introduce errors in others unseen without the kinds of integrity checks (aka audit tests) discussed here. For that alone these techniques are invaluable. But error reporting is only half of BXL Integrity Checks value. BXL Integrity Checks can also provide performance alerts. Performance Alerts Performance alerts include key performance indicators (KPIs), financial ratios, or any stakeholder requirement in the model. When any of these measures fall short customers want to know about it and BXL Integrity Checks can make that happen. Actionable Messages High Visibility A problem anywhere must be visible everywhere. Thus, BXL Integrity Checks adds alerts prominently on every worksheet and draws attention to the area of concern on worksheets containing failed tests through conditional formatting. Make Doing-the-Right-Thing Easy We all want to do the right thing but adding best-practice integrity checks manually is cumbersome. BXL Integrity Checks makes doing the right thing easy.