XLValidator

Spreadsheets are commonly used due to their availability and user-friendliness, yet they often lack formal development processes, leading to errors. It's crucial to perform logical inspections on spreadsheets, akin to code reviews, to ensure calculations and data flows are correct before they go live. Doing this manually can be tedious and time consuming.

XLValidator automates the logic inspection of spreadsheets, quickly highlighting errors, warnings, and potential issues. It reduces the time and cost associated with spreadsheet validation by automatically generating specification documents and Installation Qualification/Operational Qualification (IQ/OQ) protocols. The software is customizable to fit individual validation procedures and can be implemented without additional hardware or software.

Benefits

• Quickly generates validation documentation for Excel spreadsheets.
• Ensures data integrity and reliability before validation.
• Installs easily without IT support.
• No need for expensive servers or additional database software.
• Works seamlessly with the eInfotree Excel Module for 21 CFR Part 11 compliance, enhancing productivity and compliance.
• Simple to configure, use, and maintain.

Features

XLValidator provides automated spreadsheet validation, allowing users to generate comprehensive spreadsheet specifications with a single click. It records details such as date, time, user ID, full user name, cell location, action type, and changes in cell values. The system can generate comprehensive IQ/OQ documentation, adapting to user-defined specification and test case criteria.

The software integrates fully with the eInfotree Excel module for 21 CFR Part 11 compliance but can also function independently for spreadsheet validation.

Spreadsheet Analysis Tools

• Formula and Cell Analysis: Uses user-defined criteria for powerful formula and cell analysis.
• Graphical Dependency Mapping: Provides a graphical view of file and cell dependencies, helping analyze structural integrity and identify errors.
• Formula Error Review: Features a graphical wizard that highlights formulas with potential errors or warnings for further verification.
• Cell Validation: Allows configuration of cell validation rules to ensure the accuracy and integrity of manually entered data.