The zip archive of upload template documents must first be downloaded and saved to your local disk.

The template file(s) must then be extracted from the zip archive and also saved to your local disk before using them. 

If the template file is not first saved to your local disk, the data validation macros will not function.

The new spreadsheets to upload data into ORM2 contain validation tools to ensure accuracy of the data before submitting to the ORM2 team.  Performing the validation upfront will alleviate the need for back-and-forth correspondence between the requestor and the ORM team to correct any possible errors in the data.

The upload process now uses a consolidated workbook for uploading any data type in addition to aquatic resources.  This helps in validation relationships between waters and other data types.

To run the validation tool, first enter all data in the appropriate columns and tabs.  Once you have completed entering the data and have saved the document, click the gold shield at the top of the workbook window.  The tool has a tooltip showing "Validate Worksheets."  After clicking this button, validation of data is performed and any possible errors are added to the Validation tab.  This tab is opened after the process is complete to allow the user to see the output.  The validation output includes the tab (data type), column, and cell for where the possible error was found and a brief explanation of the issue.

The majority of the validation checks are captured in the Rules tab of the workbook.  For a complete list of validation rules, refer to the ORM_Rapanos_Upload_ValidationRules_....xlsx or ORM_2023Rule_Upload_ValidationRules_20230320....xlsx documents found in the relavent zip file found on the ORM2 Home page.

Please note that any subactions required per EVALCKLST must be created and finalized manually in ORM2; they are not supported via the new spreadsheets or upload process.

If you encounter any issues using the validation tool or have any questions on what is required, please contact the ORM Point of Contact for your District.