Validation Sheet
The validation tool applies a simple method to check the input data in the Plant sheet. It is based on a general List of Validation Ranges. In addition, some calculated data is checked based on validation functions. There may for instance be special cases where values lie outside the validation ranges, but where these values are still assessed as correct, after carefully checking the data. In these cases, the checked values should be accepted, even though the Protocol Spreadsheet validation tool indicates a value outside of the min-max-range in its list of results in the Control Plant sheet.
For the validation of the Protocol Spreadsheet it is most important that the plant sheets are named "Plant_xyz", with xyz being replaced e.g. by the name of the plant. Otherwise the Excel® macros of the validation tool might not be able to identify the Plant sheet correctly.
Tasks
References
- See the List of Validation Ranges for a detailed list of lines and values that are checked by the macros of the Validation sheet
- In the Line-by-Line you can also find line specific information on validation ranges