Results for “spreadsheet” — Page 7

DOE OSTI2023

Methods for Estimating Hydrogen Fuel Tank Characteristics

The pressure vessels needed to store hydrogen for next-generation hydrogen fuel cell vehicles are expected to be a substantial portion of the total system mass, volume, and cost. Gravimetric capacity, volumetric capacity, and cost per kilogram of usable hydrogen are key performance metrics that the U.S. Department of Energy (DOE) uses to determine the viability of hydrogen fuel cell systems. Research and development related to hydrogen storage systems covers a wide range of potential operating conditions, from cryogenic temperatures to high temperatures (above ambient) and low pressure to high pressure. Researchers at PNNL have developed methods for estimating these key pressure vessel characteristics to support on-board hydrogen storage system design and performance evaluation and to support decision-making about DOE hydrogen storage system research investments. This article describes the pressure tank estimation methodology that has been used as a stand-alone calculation and has been incorporated into larger system evaluation tools. The methodology estimates the geometry, mass, and material cost of type I, type III, and type IV pressure vessels based on operating pressure and material strength at the system's operating temperature, using classical thin-wall and thick-wall pressure vessel stress calculations. The geometry, mass, and material cost requirements of the pressure vessel have significant impacts on the total system performance. For example, hydrogen storage materials that can separately achieve a very high hydrogen density can be deemed impractical for use in fuel cell vehicle hydrogen storage systems because the pressure tank containing them is too large, heavy, or expensive. This article describes the design philosophy and analytical process of the tank characteristic estimation methodology, which has been implemented in spreadsheet calculation tools and system-level analysis tools used by DOE researchers. Each of the three tank types (type I, type III, and type IV) uses a different analysis methodology with some common elements. This article also provides examples of implementing the methodology to perform parametric studies of all three pressure vessel types. The goal of this article is to present the methodology in sufficient detail so it can be implemented in other hydrogen fuel cell vehicle design and analysis tools.

42 ENGINEERING↗

DOE OSTI2021

Simulation Dataset - Input files

The input data that are required to run the model are divided into fundamental data and advanced data. The fundamental data are essential to run the model, while the advanced data allow optional model features to be activated. The names of all input data files are to be entered as ASCII characters in a tabular format. Spaces, commas, or tabs can separate numeric fields, the use of any other special visible or hidden characters must be avoided. It may be useful to note that all files are generally read in using standard free-format style FORTRAN READ statements. The input data files can be generated/modified using any standard editor, spreadsheet or word processor (in non-document mode), given that the above guidelines are complied with. However, the inclusion of special formatting characters and the insertion of blank lines must be avoided. The input data files may also be generated through the use of special purpose translation programs that convert the input data files that were initially generated for another traffic simulation or transportation planning model into an INTEGRATION format.

32 ENERGY CONSERVATION, CONSUMPTION, AND UTILIZATI↗

DOE OSTI2021

Credibility Framework (CF) v.1.0

Credibility Framework provides tools such as PIRT (Phenomena Identification and Ranking Table) and PCMM (Predictive Capability Maturity Model) configurable by non-programmers through simple Excel spreadsheets for tailoring the credibility process to meet the needs of the analysis provider organizations, customers and regulatory agencies. Sandia National Laboratories is a multimission laboratory managed and operated by National Technology & Engineering Solutions of Sandia, LLC, a wholly owned subsidiary of Honeywell International Inc., for the U.S. Department of Energy’s National Nuclear Security Administration under contract DE-NA0003525. SAND2020-10230 M

Clay, RobertL.↗

DOE OSTI2020

GHEP WIBT (Guidelines for Home Energy Professionals Weatherization Installer Badges Toolkit) [SWR-20-69]

The National Renewable Energy Laboratory (NREL) and the U.S. Department of Energy's (DOE) Weatherization Assistance Program (WAP) are collaborating with the home energy retrofit industry to support the development of skilled workers. The Installer Badges Toolkit provides a flexible, customizable, and voluntary approach to training and skills recognition for WAP implementers, utility programs, private-sector workers, and contractors. In Fiscal Year 2018, DOE, along with the Crew Leader scheme committee, determined the Retrofit Installer Technician (RIT) Job Task Analysis (JTA) could be eliminated and its tasks inserted in the Crew Leader JTA. The RIT tasks became the basis of the Installer Badges. The Badges Toolkit was updated in 2020 to add licensing and copyright agreements. Users must cite the copyright information when using or distributing copies of the Badges Toolkit in any way. The technical content has remained unchanged from previous versions of the Badges Toolkit. The Toolkit for home retrofits consists of 25 Badges, each representing different energy efficiency tasks that an installer could perform on a home. Each Badge defines the desired outcome, criteria to verify, applicable material requirements, and references to Standard Work Specifications (SWS) or other relevant standards. The Badges provide a consistent approach to training by ensuring that installers in different regions are learning the same skills nationwide. Organizations can also customize the Toolkit by choosing only those Badges that are relevant to their program. The Badges Toolkit includes five pieces: "How to Use the Badges Toolkit" provides a brief overview of how a Grantee, Subgrantee, or training provider may approach using the toolkit. The "Badges Toolkit: Worksheet" includes what to consider when determining whether and how to best incorporate the Badges into a weatherization assistance program. The "Crew Leader Job Task Analysis Spreadsheet" indicates how the Badges align with specific areas of the JTA. The "Installer Badges Passport" features separate pages for each Badge, which include places for the installer and the supervisor/trainer to record the number of times a task has been successfully completed. The "Installer Badges Verification Criteria" includes sample inspection checklists for each Badge. These can be modified as needed based on approved variance requests or more stringent requirements. They also provide a basis for consistent inspections and awarding of Badges. Note: All elements of the Badges Toolkit are designed for use by potential program implementers. They are not off-the-shelf products intended for immediate deployment. Program implementers must review and modify as needed, revise verification criteria to match local requirements, complete worksheets, and otherwise define the parameters of their own badging program.

Desai, Jal↗

DOE OSTI2025

Datum: A Scientific Metadata Catalog

The data catalog market is currently flooded with a myriad of different products, but none serve the scientific community well. There are cloud-native tools like Databricks, Snowflake,to on-premise solutions like Collibra and Datahub. The common failing of all these tools however, is their inability to serve the scientific data community directly. Most catalogs are targeted towards financial, health, or user data - not sensor or scientific domain data. They also prioritize integrations that often don’t exist or are just starting to be used in the scientific realm - all while ignoring common scientific tools and file types. Datum is a catalog which targets the scientific data directly, including the tools and networks in which those tools are used. We work with the producers and consumers of the data where they are, targeting cloud and on-premise with a focus on classified networks. Datum is an Erlang/Elixir application. Technical Features Note: The features listed below are still under development and may change, slightly, upon final delivery of the product. File Formats - Datum has the ability to read additional metadata and provides processing pipelines for the following file formats: Plain Text, PDF, LaTeX, HTML, Open Document Format (.odt), XML, CSV/TSV (and other standard delimiters), OpenDocument Database and Spreadsheets, Geo-Referenced TIFF, Common Data Format, HDF/HDF5, LabView TDMS, Excel, DeltaTables, Parquet, Apache Iceberg, Apache Hudi and many others. Metadata Collection - Scanners for the local and networked file systems and cloud storage providers. Network integration with common databases such as MSSQL and MySQL. User Plugin System - Users are able to provide either file processing, metadata extraction, or sampling plugins in the programming language of their choice. Authentication/Authorization -: OIDC integration, SCIM provisioning and EntraID integration out of the box. Full user and group management system with a “least privilege” operating mode. Governance - Customizable data governance platform; dictate and enforce required metadata, enforce data embargos, and enforce user agreements and NDAs before data access. Ability to create health checks on data, rejecting abandoned or poorly curated data and automatically removing it from the search index. Ability for users to submit corrections. Search - Semantic search is a first class citizen. No licenses to expensive, external software required. Integrated use of vectors and vector-based search allows for AI agent integration at all levels of operation. Metadata Model - Display and control data’s lineage and connections to other data and data directories. Data is modeled after a filesystem - an organization instantly recognizable and navigable by most any user. CLI and SDK - Ships with a Command Line Interface (CLI) tool and with a fully-featured Python SDK. This allows for rapid and programmatic use of Datum by every level of user. Minimal Infrastructure - Datum ships as a single executable file and can be run on any operating system and most CPU architectures. Datum has no reliance on external databases, search indexing tools, or other outside services - and it runs equally well on edge computing devices, cloud services, or in a clustered HPC environment.

darrington, john↗

DOE OSTI2025

PNNL-Predictive-Phenomics/ProteoMeter

ProteoMeter is a Python package that assists in the statistical analysis of global proteomics, protein post-translation modification (PTM), and limited proteolysis (LiP) data. It contains batch correction, normalization, and statistical testing methods, as well as functions that "roll up" peptide-level data to the single-site level. It has a robust user configuration system, allowing it to flexibly integrate different types of experiment designs. For basic usage, a simple configuration file provides the essential functionality. Advanced users have access to the entire statistical pipeline for fine-tuning analyses. Processed data is easily exported to many common spreadsheet and data-frame formats.

Rozum, Jordan [Pacific Northwest National Lab]↗

DOE OSTI2026

Battery Performance and Cost Model (BatPaC) Version 6.0

SF-26-016 The Battery Performance and Cost model (BatPaC) is a calculation method based on Microsoft Excel spreadsheets that has been developed at Argonne for estimating the performance and manufacturing cost of lithium-ion batteries for electric-drive vehicles including hybrid-electrics (HEV), plug-in hybrids (PHEVs) and pure electrics. BatPaC was first developed in 2007, was subsequently peer reviewed, and it has served Argonne researchers and the greater battery community in studying the impact of material properties on performance at the pack level. BatPaC has been updated and re-released multiple times since its original public release in 2011. This current version is BatPaC 6.0, which contains additional functionality needed to handle advances in automotive batteries, like the use of lithium metal and silicon anodes and the need to accommodate cell expansion and apply high levels of pressure.

KNEHR, KEVIN [Argonne National Laboratory (ANL), A↗

DOE OSTI2026

FLOW BATTERY COST AND COMMERCIALIZATION TOOL (FlowBaCC) v.1.0

The Flow Battery Cost and Commercialization Tool (FlowBaCC) is a python-based framework used to project the costs and commercialization timelines for redox flow batteries. FlowBaCC combines learning curves for component costs and performance with adoption curves for market diffusion to project future system costs. The tool uses the bottom-up, spreadsheet-based Battery Performance and Cost Model for Flow Batteries (BatPaC-Flow) as the engine to translate learning curve inputs into full system costs. FlowBaCC provides capital costs and levelized costs of energy storage. The tool enables scenario analysis, sensitivity analysis, and uncertainty quantification (via grid and Monte Carlo methods).

Fu, Xiaoxu [Argonne National Laboratory (ANL), Arg↗

DOE OSTI2020

Greenhouse gases, Regulated Emissions, and Energy use in Technologies Model ® (2020 Excel)

To fully evaluate energy and emission impacts of advanced vehicle technologies and new transportation fuels, the fuel cycle from wells to wheels and the vehicle cycle through material recovery and vehicle disposal need to be considered. Sponsored by the U.S. Department of Energy's Office of Energy Efficiency and Renewable Energy (EERE), Argonne has developed a full life-cycle model called GREET (Greenhouse gases, Regulated Emissions, and Energy use in Technologies). It allows researchers and analysts to evaluate various vehicle and fuel combinations on a full fuel-cycle/vehicle-cycle basis. The first version of GREET was released in 1996. Since then, Argonne has continued to update and expand the model. GREET is developed as a multidimensional spreadsheet model in Microsoft Excel. It provides a comprehensive, life-cycle-based approach to compare the energy use and emissions of conventional and advanced vehicle technologies. It includes two sub-models named Fuel-Cycle Model (GREET 1, contains data on fuel cycles and vehicle operations) and Vehicle-Cycle Model (GREET 2, evaluates the energy and emission effects associated with vehicle material recovery and production, vehicle component fabrication, vehicle assembly, and vehicle disposal/recycling). This public domain model is available free of charge for anyone to use.

Wang, Michael↗

DOE OSTI2021

Greenhouse gases, Regulated Emissions, and Energy use in Technologies Model ® (2021 Excel)

To fully evaluate energy and emission impacts of advanced vehicle technologies and new transportation fuels, the fuel cycle from wells to wheels and the vehicle cycle through material recovery and vehicle disposal need to be considered. Sponsored by the U.S. Department of Energy's Office of Energy Efficiency and Renewable Energy (EERE), Argonne has developed a full life-cycle model called GREET (Greenhouse gases, Regulated Emissions, and Energy use in Technologies). It allows researchers and analysts to evaluate various vehicle and fuel combinations on a full fuel-cycle/vehicle-cycle basis. The first version of GREET was released in 1996. Since then, Argonne has continued to update and expand the model. GREET is developed as a multidimensional spreadsheet model in Microsoft Excel. It provides a comprehensive, life-cycle-based approach to compare the energy use and emissions of conventional and advanced vehicle technologies. It includes two sub-models named Fuel-Cycle Model (GREET 1, contains data on fuel cycles and vehicle operations) and Vehicle-Cycle Model (GREET 2, evaluates the energy and emission effects associated with vehicle material recovery and production, vehicle component fabrication, vehicle assembly, and vehicle disposal/recycling). This public domain model is available free of charge for anyone to use.

Wang, Michael↗

DOE OSTI2022

Greenhouse gases, Regulated Emissions, and Energy use in Technologies Model ® (2022 Excel)

To fully evaluate energy and emission impacts of advanced vehicle technologies and new transportation fuels, the fuel cycle from wells to wheels and the vehicle cycle through material recovery and vehicle disposal need to be considered. Sponsored by the U.S. Department of Energy's Office of Energy Efficiency and Renewable Energy (EERE), Argonne has developed a full life-cycle model called GREET (Greenhouse gases, Regulated Emissions, and Energy use in Technologies). It allows researchers and analysts to evaluate various vehicle and fuel combinations on a full fuel-cycle/vehicle-cycle basis. The first version of GREET was released in 1996. Since then, Argonne has continued to update and expand the model. GREET is developed as a multidimensional spreadsheet model in Microsoft Excel. It provides a comprehensive, life-cycle-based approach to compare the energy use and emissions of conventional and advanced vehicle technologies. It includes two sub-models named Fuel-Cycle Model (GREET 1, contains data on fuel cycles and vehicle operations) and Vehicle-Cycle Model (GREET 2, evaluates the energy and emission effects associated with vehicle material recovery and production, vehicle component fabrication, vehicle assembly, and vehicle disposal/recycling). This public domain model is available free of charge for anyone to use.

Wang, Michael↗

DOE OSTI2023

Greenhouse gases, Regulated Emissions, and Energy use in Technologies Model ® (2023 Excel)

To fully evaluate energy and emission impacts of advanced vehicle technologies and new transportation fuels, the fuel cycle from wells to wheels and the vehicle cycle through material recovery and vehicle disposal need to be considered. Sponsored by the U.S. Department of Energy's Office of Energy Efficiency and Renewable Energy (EERE), Argonne has developed a full life-cycle model called GREET (Greenhouse gases, Regulated Emissions, and Energy use in Technologies). It allows researchers and analysts to evaluate various vehicle and fuel combinations on a full fuel-cycle/vehicle-cycle basis. The first version of GREET was released in 1996. Since then, Argonne has continued to update and expand the model. GREET is developed as a multidimensional spreadsheet model in Microsoft Excel. It provides a comprehensive, life-cycle-based approach to compare the energy use and emissions of conventional and advanced vehicle technologies. It includes two sub-models named Fuel-Cycle Model (GREET 1, contains data on fuel cycles and vehicle operations) and Vehicle-Cycle Model (GREET 2, evaluates the energy and emission effects associated with vehicle material recovery and production, vehicle component fabrication, vehicle assembly, and vehicle disposal/recycling). This public domain model is available free of charge for anyone to use.

Wang, Michael↗

DOE OSTI2024

Established Regulatory Limits for Surface Water and Groundwater

The regulatory limits for surface water and groundwater contained in this database comprise chemical-specific preliminary remediation goals (PRGs) based on potential Applicable or Relevant and Appropriate Requirements (ARARs). These values should be used in conjunction with PRGs based on risk assessment to ensure that the PRGs for a site meet the residual risk requirements for protection of human health and the environment in the National Oil and Hazardous Substance Pollution Contingency Plan (NCP). In some cases, the values presented in this database may be To-Be-Considered (TBC) Guidance because these values are superseded by site-specific state requirements. ARARs are available for the Federal government, California, Georgia, Illinois, Kentucky, New Jersey, New Mexico, Nevada, New York, Ohio, South Carolina, Tennessee, Washington, and Wisconsin. The dataset provides maximum contaminant levels for drinking water and water quality criteria for fresh and marine environments based on acute and chronic exposures. Users can select ARAR sources, drinking water standards and water quality standards, individual chemicals, and retrieve results in tabular or spreadsheet formats for analysis. ARARs are derived from authoritative sources, including federal and state government agencies. The dataset supports environmental risk assessments, regulatory decision-making, and environmental planning, with tools for benchmarking against promulgated standards. This structured approach ensures a robust evaluation of environmental risks tailored to regulatory needs.

Stewart, Debra [Oak Ridge National Laboratory (ORN↗

DOE OSTI2024

Ecological Benchmark for Chemicals

The Ecological Benchmark Tool dataset serves as a comprehensive repository of benchmarks designed to assess ecological risks at contaminated sites. This tool facilitates the evaluation of various environmental media and contaminants, supporting regulatory compliance and ecological protection. Benchmarks are available for air, biota, sediment, soil, and surface water. The dataset also provides species-specific benchmarks for fish, plants, birds, mammals, and invertebrates. Users can select benchmark sources, media, individual chemicals, and retrieve results in tabular or spreadsheet formats for analysis. Benchmarks are derived from authoritative sources, including government agencies, scientific councils, and academic publications. The dataset supports ecological risk assessments, regulatory decision-making, and environmental planning, with tools for benchmarking against chemical thresholds, sensitive species protection, and habitat impact evaluations. This structured approach ensures a robust evaluation of ecological risks tailored to site-specific and regulatory needs.

Stewart, Debra [Oak Ridge National Laboratory (ORN↗

DOE OSTI2024

Ecological Benchmark for Radionuclides

The Ecological Benchmark Tool for radionuclides dataset serves as a comprehensive repository of benchmarks designed to assess ecological risks at contaminated sites. This tool facilitates the evaluation of various environmental media and contaminants, supporting regulatory compliance and ecological protection. Benchmarks are available for sediment, soil, and surface water. The dataset also provides species-specific benchmarks for fish, plants, birds, mammals, and invertebrates. Users can select benchmark sources, media, individual radionuclides, and retrieve results in tabular or spreadsheet formats for analysis. Benchmarks are derived from authoritative sources, including government agencies, scientific councils, and academic publications. The dataset supports ecological risk assessments, regulatory decision-making, and environmental planning, with tools for benchmarking against radiological thresholds, sensitive species protection, and habitat impact evaluations. This structured approach ensures a robust evaluation of ecological risks tailored to site-specific and regulatory needs.

Stewart, Debra [Oak Ridge National Laboratory (ORN↗

DOE OSTI2020

VADER: A Tool for Criticality Safety Validation

The purpose of criticality safety is to prevent any inadvertent criticality from occurring during the handling or storage of fissile material. Calculations are frequently used to demonstrate that a sufficient subcritical margin exists. Validation is a key aspect of the evaluation process, establishing the suitability, accuracy, and associated uncertainty of the computational method and data to be used for the intended application. The validation process is performed by comparing the results of critical experiments with the calculated results from models of the experiments using the computational method to be validated. Laboratory critical experiments are controlled systems that achieve a k eff of approximately 1 in order to investigate the parameters at which such a critical condition is achieved. The validation parameters that are traditionally applied to safety analysis calculations are the bias and the bias uncertainty . The bias is the deviation of the average k eff of the validation suite from unity. The bias uncertainty accounts for the statistical uncertainty in the bias based on the standard deviation, sample size, and distribution of k eff values of the validation suite. The values of bias and bias uncertainty ensure that the systems predicted to be subcritical by the computational method will indeed be subcritical. The bias and bias uncertainty are often combined to determine an upper subcritical limit (USL) or computational margin that can then be applied to safety analysis calculations. Many methods have been developed by different organizations to calculate the bias and bias uncertainty for various types of criticality analyses. Each of these methods typically requires that the validity of various underpinning statistical assumptions be confirmed to demonstrate that the method is appropriate for the analysis of a given validation suite. An example of the validation decision making flow is shown in Fig.1. As shown in Fig. 1, the analyst performing the validation fits a trend line to the data and performs a test to determine if the trend was a statistically better representation of the data than if it were treated as an uncorrelated sample. If the trend line is a better representation of the data, then the analyst uses any one of a number of trending techniques to determine the bias and bias uncertainty. If a trend is not an appropriate representation of the data, then the analyst proceeds to perform a normality assessment for the data. If the normal assumption can be shown to be acceptable, then the analyst calculates the bias and bias uncertainty with the parametric technique. If the assumption of normality cannot be justified, then the nonparametric technique is used. Once the decision flow has been followed and the appropriate technique has been selected, the bias and bias uncertainty is typically combined with an administrative margin to determine a USL below which calculated values of k eff for safety analysis models can be considered subcritical. The calculations used in each decision are often performed with spreadsheets or with small programs available at various sites performing criticality analyses. Expertise in understanding and interpreting the results must be maintained to perform these calculations. This can often be an error-prone process. Oak Ridge National Laboratory (ORNL) is currently developing the Validation and Data Evaluation Resource (VADER) to simplify and automate the criticality safety validation process and to provide a software quality assurance pedigree to the calculational methods used. This paper discusses the use of the Fulcrum user interface with VADER, the anticipated initial capabilities of VADER to perform validation analyses, and the output from the code.

73 NUCLEAR PHYSICS AND RADIATION PHYSICS↗

DOE OSTI2025

Neutron powder diffraction, Mossbauer Spectroscopy and Optical Spectroscopy to study magnetic and nuclear lattices in Fe-based oxychlorides Ca2FeO3Cl, Sr2FeO3Cl and Sr3Fe2O5Cl2

Data for Neutron Diffraction, Mossbauer Spectoscopy and Optical Spectroscopy are contained on all three samples (Ca2FeO3Cl, Sr2FeO3Cl, and Sr3Fe2O5Cl2). Mossbauer data are in the folder "MossbauerSpectroscopy". This contains details of files and examples to read the data. The Optical Spectroscopy are in the folder "AbsorptionData", this contains one file with explanatory headers. The neutron diffraction data are in the "NeutronDiffractionData" folder. The data was collected on the HB-2A powder diffractometer at HFIR. The autoreduced files are corrected using a vanadium standard and are in arbitrary intensity units. The RawData folder contains the uncorrected data with metadata for motor positions and temperature. All measurements were collected with a constant neuton wavelength of 2.41 Angstrom. An excel spreadsheet "NeutronDiffractionData_IPTS-29118_summary" contains details for each scan. Sr3Fe2O5Cl2 data were collected at only room temperature. Ca2FeO3Cl and Sr2FeO3Cl data were collected at 4K and room temperature. The autoreduced .dat fileformat is three columns corresponding to: Two-theta, Intensity and Intensity_error.

fe-based oxychlorides↗

DOE OSTI2020

Utah FORGE: Data for 3-D Model Development - Lithology, Temperature, Pressure, and Stress

This submission comprises two downloadable .zip archives. Each archive contains spreadsheets with 3-D data and a .txt document describing the data. The Mesh Files .zip download contains data regarding the lithologic contacts of the granitoid and overlying sedimentary basin fill. The Initial Conditions .zip download contains data regarding temperature, pressure, and stress. These data were generated during Utah FORGE Phase 2 and exported from Seequent Leapfrog Geothermal. They are intended for use in 3-D earth modeling.

15 GEOTHERMAL ENERGY↗