Hanford Borehole Geologic Information System (HBGIS) Updated User’s Guide for Web-based Data Access and Export

The Hanford Borehole Geologic Information System (HBGIS) is a prototype web-based graphical user interface (GUI) for viewing and downloading borehole geologic data. The HBGIS is being developed as part of the Remediation Decision Support function of the Soil and Groundwater Remediation Project, managed by Fluor Hanford, Inc., Richland, Washington. Recent efforts have focused on improving the functionality of the HBGIS website in order to allow more efficient access and exportation of available data in HBGIS. Users will benefit from enhancements such as a dynamic browsing, user-driven forms, and multi-select options for selecting borehole geologic data for export. The need for translating borehole geologic data into electronic form within the HBGIS continues to increase, and efforts to populate the database continue at an increasing rate. These new web-based tools should help the end user quickly visualize what data are available in HBGIS, select from among these data, and download the borehole geologic data into a consistent and reproducible tabular form. This revised user’s guide supersedes the previous user’s guide (PNNL-15362) for viewing and downloading data from HBGIS. It contains an updated data dictionary for tables and fields containing borehole geologic data as well as instructions for viewing and downloading borehole geologic data

Guide to using Multiple Regression in Excel (MRCX v.1.1) for Removal of River Stage Effects from Well Water Levels

A software tool was created in Fiscal Year 2010 (FY11) that enables multiple-regression correction of well water levels for river-stage effects. This task was conducted as part of the Remediation Science and Technology project of CH2MHILL Plateau Remediation Company (CHPRC). This document contains an overview of the correction methodology and a user’s manual for Multiple Regression in Excel (MRCX) v.1.1. It also contains a step-by-step tutorial that shows users how to use MRCX to correct river effects in two different wells. This report is accompanied by an enclosed CD that contains the MRCX installer application and files used in the tutorial exercises

2005 Annual Synthesis Report, Pallid Sturgeon Population Assessment Program and Associated Fish Community Monitoring for the Missouri River

Pallid sturgeon, Scaphirhynchus albus, have declined throughout the Missouri River since dam construction and inception of the Bank Stabilization and Navigation Project in 1912. Their decline likely is due to the loss and degradation of their natural habitat as a result of changes in the river’s structure and function, as well as the pallid sturgeon’s inability to adapt to these changes. The U. S. Army Corps of Engineers has been working with state and federal agencies to develop and conduct a Pallid Sturgeon Monitoring and Assessment Program (Program), with the goal of recovering pallid sturgeon populations. The Program has organized the monitoring and assessment efforts into distinct geographic segments, with state and federal resource management agencies possessing primary responsibility for one or more segment. To date, the results from annual monitoring have been reported for individual Program segments. However, monitoring results have not been summarized or evaluated for larger spatial scales, encompassing more than one Program segment. This report describes a summary conducted by the Pacific Northwest National Laboratory (PNNL) that synthesizes the 2005 sampling year monitoring results from individual segments

Guide to using Multiple Regression in Excel (MRCX v.1.1) for Removal of River Stage Effects from Well Water Levels

A software tool was created in Fiscal Year 2010 (FY11) that enables multiple-regression correction of well water levels for river-stage effects. This task was conducted as part of the Remediation Science and Technology project of CH2MHILL Plateau Remediation Company (CHPRC). This document contains an overview of the correction methodology and a user’s manual for Multiple Regression in Excel (MRCX) v.1.1. It also contains a step-by-step tutorial that shows users how to use MRCX to correct river effects in two different wells. This report is accompanied by an enclosed CD that contains the MRCX installer application and files used in the tutorial exercises

Guide to using Multiple Regression in Excel (MRCX v.1.1) for Removal of River Stage Effects from Well Water Levels

A software tool was created in Fiscal Year 2010 (FY11) that enables multiple-regression correction of well water levels for river-stage effects. This task was conducted as part of the Remediation Science and Technology project of CH2MHILL Plateau Remediation Company (CHPRC). This document contains an overview of the correction methodology and a user’s manual for Multiple Regression in Excel (MRCX) v.1.1. It also contains a step-by-step tutorial that shows users how to use MRCX to correct river effects in two different wells. This report is accompanied by an enclosed CD that contains the MRCX installer application and files used in the tutorial exercises

2005 Annual Synthesis Report, Pallid Sturgeon Population Assessment Program and Associated Fish Community Monitoring for the Missouri River

Pallid sturgeon, Scaphirhynchus albus, have declined throughout the Missouri River since dam construction and inception of the Bank Stabilization and Navigation Project in 1912. Their decline likely is due to the loss and degradation of their natural habitat as a result of changes in the river’s structure and function, as well as the pallid sturgeon’s inability to adapt to these changes. The U. S. Army Corps of Engineers has been working with state and federal agencies to develop and conduct a Pallid Sturgeon Monitoring and Assessment Program (Program), with the goal of recovering pallid sturgeon populations. The Program has organized the monitoring and assessment efforts into distinct geographic segments, with state and federal resource management agencies possessing primary responsibility for one or more segment. To date, the results from annual monitoring have been reported for individual Program segments. However, monitoring results have not been summarized or evaluated for larger spatial scales, encompassing more than one Program segment. This report describes a summary conducted by the Pacific Northwest National Laboratory (PNNL) that synthesizes the 2005 sampling year monitoring results from individual segments

Summary of the 2006 Annual Synthesis Report, Pallid Sturgeon Population Assessment Program and Associated Fish Community Monitoring for the Missouri River

Pallid sturgeon, Scaphirhynchus albus, have declined throughout the Missouri River since dam construction and inception of the Bank Stabilization and Navigation Project in 1912. Their decline likely is due to the loss and degradation of their natural habitat as a result of changes in the river’s structure and function, as well as the pallid sturgeon’s inability to adapt to these changes. The U. S. Army Corps of Engineers has been working with state and federal agencies to develop and conduct a Pallid Sturgeon Monitoring and Assessment Program (Program), with the goal of recovering pallid sturgeon populations. The Program has organized the monitoring and assessment efforts into distinct geographic segments, with state and federal resource management agencies possessing primary responsibility for one or more segment. To date, the results from annual monitoring have been reported for individual Program segments. However, monitoring results have not been summarized or evaluated for larger spatial scales, encompassing more than one Program segment. This report describes a summary conducted by the Pacific Northwest National Laboratory (PNNL) that synthesizes the 2006 sampling year monitoring results from individual segments

2006 Annual Synthesis Report, Pallid Sturgeon Population Assessment Program and Associated Fish Community Monitoring for the Missouri River

Pallid sturgeon, Scaphirhynchus albus, have declined throughout the Missouri River since dam construction and inception of the Bank Stabilization and Navigation Project in 1912. Their decline likely is due to the loss and degradation of their natural habitat as a result of changes in the river’s structure and function, as well as the pallid sturgeon’s inability to adapt to these changes. The U. S. Army Corps of Engineers has been working with state and federal agencies to develop and conduct a Pallid Sturgeon Monitoring and Assessment Program (Program), with the goal of recovering pallid sturgeon populations. The Program has organized the monitoring and assessment efforts into distinct geographic segments, with state and federal resource management agencies possessing primary responsibility for one or more segment. To date, the results from annual monitoring have been reported for individual Program segments. However, monitoring results have not been summarized or evaluated for larger spatial scales, encompassing more than one Program segment. This report describes a summary conducted by the Pacific Northwest National Laboratory (PNNL) that synthesizes the 2006 sampling year monitoring results from individual segments