DOE OSTI2008
The EndpointTool is a Microsoft Excel{sup R}-based workbook with a set of macros and worksheets for the evaluation of Hanford Site tank treatment scenarios. This tool enables the user to determine bottlenecks in processes and storage and address regulatory issues. It also provides an avenue to evaluate new technologies, as well as changes in existing technologies and their impact to the current baseline. The EndpointTool tracks 46 radionuclides, 52 species, and 10 properties for each event. Seventeen different processes are modeled, each with its own worksheet that describes that process, has its assumptions, qualifications, and calculations, and holds the historical results of each process event. This enables the user to not only look at the big picture, but to evaluate process parameters such as flowrates, sizing, etc. The user composes an event that is a combination of a sender tank, a process tank, and a receiver tank. Each event involves one of the processes and each process can have up to a total of 81 assumptions and 180 qualifications. The starting point for all tank inventories is the Hanford tank Best-Basis Inventory (BBI). Each tank comprises up to three phases: salt-cake, sludge, and supernatant. Each of these BBI phases has an insoluble solids fraction that was derived from the embedded solubility model. Each composed event must meet a set of qualifications that are dependent on the process, as well as whether the sender tank has any inventory, whether the receiver tank has sufficient space, etc. For example, supernatant events are limited to a maximum solids specified in its assumptions, usually 5 wt%. Above this solids contents, a slurry transfer must be used. Once a qualified event is added to the Event List, the inventories of involved tanks are updated in a status worksheet and the results of that event appear in the timeline and metrics charts. Although the EndpointTool is not a true dynamic model, it provides a useful desktop capability for quite complex process sequences. While only schedule and variances are presently performed, a cost module is in development. In summary: The EndpointTool is a powerful Excel-based planning resource. It is portable and test runs have shown that about 600 Events can effectively represent the processing of all of Hanford tank waste. Since each Event takes approximately 3 seconds to run on a 1.8 GHz CPU with 512 MB ram, a complete run only takes approximately 30 minutes. As a result, extensive scenario planning and process optimization is possible with this tool. Moreover, Event List 'scenarios' can be easily shared among users and scenario planning can then be distributed among a large number of users. (authors)
12 MANAGEMENT OF RADIOACTIVE AND NON-RADIOACTIVE W↗