A Decision Support Tool for Planning the Sampling of Tank 19

The Statistical Consulting Section (SCS) of the Savannah River Technology Center (SRTC) was asked to develop a decision support system (DSS) to aid in the planning of the process to characterize the heel of Tank 19. This characterization is to be based on samples of the tank heel, and the DSS is to be used to help determine the number of samples that might be needed to provide a meaningful characterization based upon assumptions for relevant variations and volumes. The objective of this report is to describe the framework used to develop the DSS and to document its calculations. The DSS was developed as a Microsoft Excel spreadsheet. Detailed input and output for two test cases are provided in the appendix as part of the documentation of this spreadsheet.