Error Checking - Is That An Error In Your Spreadsheet?
How To
July 22, 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 inRED. This provides you with an immediateVisual Integrity Checkon 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 aModel 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: