Validation Sheet

The Validation sheet acts as a tool for doing a first-general check on your sheets for faults and completeness. It should be used before submitting data. This validation tool/sheet works on the specific year which you need to validate and which is normally selected through the selection list in the sheet itself. The Validation sheet and the Control Plant Sheet are linked to each other. This means that if there are some faults or incomplete data which could make your validation process fail, you will find more details on the results in the Control Plant sheet. Subsequently you have to go back to the other sheets in your Protocol Spreadsheet to correct the errors there. After your correction is finished you should use the validation tool again.

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

FAQs