September 20, 2004

UTAH TECHNICAL GUIDE

450-III

NOTICE UT208

SUBJECT: TCH – FOTG, SECTION I – EXCEL AND WORD ENVIRONMENTAL EVALUATION WORKSHEET (UT-CPA-52)

Purpose. To transmit information regarding new FOTG Section I Environmental Evaluation Worksheets (UT-CPA-52) in both excel and word format.

Effective Date. Begin using immediately.

Background Information. A new NRCS-CPA-52 was released nationally in December of 2003. States were directed to begin using the new form, but have been allowed to make state modifications. Two state versions (one in excel format and the other in word format) have been developed for use in Utah. These two versions are now the only approved versions for use in the state.

Both versions contain hyperlinks and/or buttons to direct the user to help sheets, websites with specific information about the topic, or other locations within the document.

The excel version has drop down lists with recommended wording. Where specific information is desired, the user can enter the information in the yellow boxes to the right and the information will then appear in the drop down lists. This version also has notes, identified as red triangles in the upper right corner of a cell, that provide information about what should be entered, hyperlinks to websites with additional information or help, and buttons that will take the user back and forth from the CPA-52 form to help sheets for each special environmental concern. One drawback with the excel version is the limitation with the size of the cell thus limiting the amount of information that can be put in the cell.

The word version also has hyperlinks to websites with additional information or help and hyperlinks to take the user back and forth from the CPA-52 form to help sheets for each special environmental concern. The hyperlink at the end of each help sheet titled “NOTES” will take the user back to the special environmental concern. The hyperlink at the top of each help sheet will take the user to a website that has additional information about the special environmental concern. The word document is especially useful when

Utah Technical Guide Notice UT2082

a large amount of information needs to be recorded in the cells, since the cells are able to expand automatically. The drawback with the word version is that it is not as user friendly as the excel version and does not have drop down lists.

Filing Instructions. This notice will be filed in the eFOTG Section I\FOTG Notices and Updates\Notices in the eFOTG. Both the excel and word versions of the UT-CPA-52 will be filed in the eFOTG under the folder: Section I\References & Technical Notes\NEPA

Contacts. Marnie Wilson, State Cultural Resource Specialist, at (801) 524-4591 if you have questions on the NEPA and EE process or how to fill out the worksheet and help sheets;Karen Fullen, State Biologist, at (801) 524-4566; Kerry Goodrich, Conservation Agronomist, at (801) 524-4568 if you have questions or need help with the mechanics/programming of the spreadsheet or word document.

/s/ Lisa R. Coverdale

LISA R. COVERDALE

State Resource Conservationist

Enclosure

cc:

Sylvia Gillen, STC, NRCS, SLC, UT

Lisa Coverdale, SRC, NRCS, SLC, UT

Marnie Wilson, CRS, NRCS, SLC, UT

Kerry Goodrich, CA, NRCS, SLC, UT

Shane Green, RMS, NRCS, SLC, UT

Karen Fullen, WB, NRCS, SLC, UT

Surrounding States

DIST:

FOTG