Forbury Portal

Error Checking

How To
March 26, 2021

Is That An Error In Your Spreadsheet?

Clients tell us that in-house models are error-prone, hard to support and challenging to keep up to date. Time is wasted second-guessing numbers, fixing calculations, and worrying about the outputs.

That’s where Forbury comes in! We’ve got your back with clever input-error detection functionality. This means you can feel confident that your data is extremely accurate.

Easy-To-See Errors

When working with the Forbury Model, any errors, or cells to check, show up automatically in RED.  This provides you with an immediate Visual Integrity Check on your data. This takes place as the Model contains a set of input error checks on the Control sheet. If one or more of these checks is flagged, your model will display a red banner alerting you to a Model Integrity Issue. You can then resolve the error/s by reviewing the Control sheet.

Example showing cell to check, highlighted in red, indicating to review the Control sheet.

Example showing the Control sheet and the issue which can be reviewed and resolved.

Forbury Customers: Find Out More

For more info, including a list of input errors and tips, click through to our Support Articles:

Commercial Model Integrity Issue Article

Retail Model Integrity Issue Article

Article headline