A completed copy of the Aquatic Resources Excel spreadsheet, found in the ZIP archive linked below, is required by the Sacramento District’s Minimum Standards for Acceptance of Aquatic Resources Delineation Reports. This spreadsheet facilitates efficient and accurate data entry of the aquatic resources into the Corps’ database. The spreadsheet contains validation tools to ensure accuracy of the data before submitting to the Corps. Performing the validation upfront will alleviate the need for back-and-forth correspondence between the requester and the Corps to correct any possible errors in the data.
To run the validation tool, first enter all data in the appropriate columns and tabs. Ensure that that for each aquatic resource, the amount field contains a value greater than zero. If data is copied into the worksheet using the Paste Tool, ensure that you paste only the values, as other paste methods can alter the format and cause the validation to fail. Once you have completed entering the data and have saved the document as a XLSM file, click the gold shield at the top of the workbook window. The tool has a tool-tip 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.
If you encounter any issues in using the validation tool or the new workbook, or if you have any questions, please contact your local Point of Contact, who can be found using the interactive map available on our Contact Your Local Office page.