Search NASA⌕ Search

SEARCH · Search NASA

Results for “spreadsheet”

Search indexed NASA NTRS and DOE OSTI research on propulsion, heat transfer, battery materials and energy systems. Follow report and document links to the original sources.

Quote a phrase for an exact phrase match. Source license links do not imply unrestricted reuse.

At least 37 records · Page 2

Lithium-Ion Battery Vent Gas Tools

The spreadsheets and Python scripts are used to determine vent gas hazard metrics (i.e. flammability limits, flame speed, etc.). These scripts and spreadsheets use open source literature to determine these hazard metrics. SAND2020-12540 O 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.

Baird, Austin↗

Network Architecture Verification & Validation Tool

The NAVV Tool is an automation of Linux commands run Zeek IDS software on a packet capture to create a Microsoft Excel spreadsheet table breaking down network traffic observed. The tool automates the Zeek software analysis, the collation of logs, and then the dissection of the Conn.log and DNS.logs to create a summary table within a Excel. This spreadsheet can then be updated with network segments using CIDR formatting and labels along with inventory information including name and IP address. Using the tool again will integrate these label and color coding into the existing analysis table to aid in conducting an evaluation of the network traffic.

Nichols, DonovanW↗

BESTEST-GSR (Building Energy Simulation Test - Generation Simulation and Reporting) 2023 [SWR 18-23]

Building Energy Simulation Test (BESTEST) is an NREL-developed method to validate the qualitative performance of different whole building simulations engines relative to each other. https://www.nrel.gov/docs/legosti/old/6231.pdf The purpose of this repository is to generate BESTEST test case models, run simulations, and populate data for ASHRAE Standard 140 reporting spreadsheets for EnergyPlus® based whole building simulation tools. It was originally setup for 2014 version of Standard 140. In May of 2022 it was updated to the 2020 version of Standard 140. This update included updates and additions to existing test suites, the bulk of which was in Section 5.2 (Building Thermal Envelope and Fabric Load Tests). We did not add Section 5.5 Airside HVAC Equipment Performance, but we hope to add that later in 2022. At some point we also hope to add Section 5.2.4 ground modeling, which is currently excluded. Supported Tools The default IDF generation is based on the OpenStudio® CLI, but the workflow supports a 'Bring your own IDF' use case. Additionally, for non-EnergyPlus® based tools the post processing scripts can be used if simulation results are provided as a CSV file.The scripts on this repository should work on Mac, Windows, and Linux. Dependencies Install OpenStudio® 3.4.0 make sure command line can recognize the 'openstudio' command This includes EnergyPlus® 22.1 Install Ruby on your system if it isn't already setup. 2.7 is used for development but other versions may work Since OpenStudio has its own embedded Ruby, which is used for running measures, you don't necessarily have to use a version of Ruby supported by OpenStudio. Install RubyXL Ruby gem This is used to modify Microsoft Excel spreadsheets Install Parallel Ruby gem This allows the CLI to run simulations in parallel

Goldwasser, David↗

Farmers’ Perceptions of Marginal Land for Biofuel Crops

The dataset includes the survey results about farmers’ perceptions of marginal land availability and the likelihood of a land pixel being marginal based on a machine learning model trained from the survey. Two spreadsheet files are the farmer and farm characteristics (marginal_land_survey_data_shared.xlsx), and the existing land use of marginal lands (land_use_info_sharing.xlsx). Note: the blank cells in these two spreadsheets mean missing values in the survey response. The GeoTiff file includes two bands, one the marginal land likelihood in the Midwestern states (0-1), the other the dominant reason of land marginality (0-5; 0 for farm size, 1 for growing season precipitation, 2 for root zone soil water capacity, 3 for average slope, 4 for growing season mean temperature, and 5 for growing season diurnal range of temperature). To read the data, please use a GIS software such as ArcGIS or QGIS.

marginal land↗

Utah FORGE: Phase 3 Microgravity Data

A 4D microgravity survey began in early 2019 in order to benchmark surface and subsurface elevations prior to Phase 3 drilling and stimulation campaigns. Microgravity stations are collocated with GPS deformation benchmarks and use the same location survey data. Surveys are undertaken on a quarterly basis. The focus of current activities is comparative analysis of GPS survey results and InSAR analysis (see GDR Submission 1251) to check seasonal variance and to evaluate possible changes in the groundwater elevation. The attached zip file contains a text file and an Excel spreadsheet containing Utah FORGE Phase 3 processed "final" microgravity data through time. The data are identical in both files. The spreadsheet is only supplied for convenience. There is also a ReadMe.txt file that describes the field headings.

15 GEOTHERMAL ENERGY↗

Coso Geothermal Spectral Library for Rocks and Minerals

An integrated open mineral spectral library designed to enhance the utility and precision of mineral spectral data for geothermal exploration, developed from a reliable and comprehensive digital dataset for seamless sharing by integrating field data, the USGS spectral library, and pertinent information obtained from Coso geothermal field (Coso) in California. The ASD FieldSpec portable spectrometer was utilized for collecting spectral data, which was subsequently analyzed using the THOR Material Identification tool in ENVI, The Spectral Geologist (TSG) software by CSIRO, and the Fully Constrained Linear Spectral Unmixing algorithm (FCLSU) in MATLAB. Scanning Electron Microscopy (SEM) with a mineralogy-analyzing function was employed to assess the mineral composition of samples, ensuring precise mineralogical analysis. A portable X-ray fluorescence (pXRF) spectrometer was also utilized to gather information on elemental enrichment. A framework for developing spectra data and establishing spectral libraries for various geological cases was proposed within this study. The characteristic spectra of six alteration minerals - alunite, chalcedony, epidote, hematite, kaolinite, and opal - were acquired from Coso samples. The spectral library for the Coso alteration minerals was introduced for further application in academic study or industrial exploration. To browse the Coso Geothermal Spectral data and related figures from spreadsheets: #1 Unzip and store the following items in the same folder. 'Contact Probe Data.zip', 'Sample Photos.zip', and 'Coso spectra of higher-certainity minerals.xlsx'. #2 Open 'Coso spectra of higher-certainity minerals.xlsx'. The hyperlinks in the spreadsheet lead to the folders or figures of: spectra .asd file, spectra ASC II file, spectra plots, and sample photos. The spectra data is raw data without splice correction. Spectra .asd files require particular software to open. (These cannot be opened in GIS software such as ArcGIS.) Spectra ASC II files can be opened in a text editor or spread sheet program.

15 GEOTHERMAL ENERGY↗

Pc-to-RP Method

These excel spreadsheets were used to develop the two-phase and three-phase methods for converting capillary pressure to relative permeability. Data was collected by the SWP and literature sources cited in the spreadsheets.

Capillary Pressure↗

Estimating the cost and energy demand of producing lithium manganese oxide for Li-ion batteries

Lithium Manganese Oxide (LMO) is one of the important cathode active materials used in lithium ion batteries of several electric vehicles. In this paper, the production of LMO cathode material for use in lithium-ion batteries is studied. Spreadsheet-based process models have been set up to estimate and analyze the factors affecting the cost of manufacturing, the energy demand, and the environmental impact. Two processes based on the solid-state synthesis method and a sol-gel method have been explored. Results show that the solid-state process is more cost-effective because of its lower cost of raw materials. The production cost for a solid-state process is $7 kg -1 and requires 6 kWh·kg -1 of energy. The pack level cost of electric vehicle battery using LMO as a primary active material is studied as a function of LMO production cost and other parameters. The potential for reducing the cost of automotive batteries to $100 per kWh is explored in terms of LMO price and plant production volume (economy of scale), using Argonne’s BatPaC spreadsheet tool.

25 ENERGY STORAGE↗

Residential Building Energy Efficiency Field Studies: Low-Rise Multifamily

In recent years, the U.S. Department of Energy (DOE) has conducted a series of research studies to validate energy efficient building technologies in the field. Much of the work has focused on single-family construction, and some has also addressed commercial energy codes. The work detailed in this DOE-funded study (EE0007616) focuses on low-rise multifamily buildings (three stories or fewer above grade) in various regions of the United States, and reports on how state-level building codes are being implemented, both in terms of observed characteristics and also in terms of estimated energy impacts. Nearly 100 buildings across four states—Illinois, Minnesota, Oregon, and Washington—were sampled, which represent a range of climate types from mild temperature to very cold continental. Both common entry and outdoor entry buildings were included, and a parallel research project evaluated envelope air tightness and current still-evolving air tightness testing methods. Finally, a set of structured interviews of building designers and other relevant professionals was carried to out to gain more insight into this market. To the greatest extent possible, the methodology developed under the project for low-rise multifamily buildings mirrored the approach established by Pacific Northwest National Laboratory (PNNL) for single-family residential buildings (https://www.energy.gov/eere/buildings/downloads/residential-building-energy-code-field-study). This included the general approach to sampling, recruitment, and data collection, as well as data analysis and presentation. The range of permitting dates for the sites encompassed two energy code cycles in most regions. All states in the study had adopted a variation of the International Energy Conservation Code (IECC) for the structure of their state code. The low-rise multifamily occupancy presents a hybrid building type: most of the building’s conditioned floor area was covered by the residential chapter of the code while portions of the building (such as corridors and common spaces) fell under the commercial code chapter. The key items assessed in this work were: Building Shell—exterior wall insulation, ceiling insulation, foundation insulation, windows. Common Areas—HVAC and lighting. Living Units—lighting, ventilation. A few items were not assessed in detail, given their relative paucity in this occupancy type; these included duct leakage, pipe insulation, and hot water circulation controls. Building characteristics were collected via a combination of architectural, mechanical, electrical, and plumbing plan reviews and field inspections, and entered into a spreadsheet-based tool that was later queried to build a database. Data went through quality control both upon arrival and via a later semi-automated review and assurance process. Most of the data are presented graphically so that the reader can quickly assess compliance with the applicable energy codes (both by state and by code year). As a final step, EnergyPlus™ simulations were created for all buildings in the study to estimate both the as-found energy use intensity (EUI) and the energy and CO 2 that could be saved if features that were found to not meet code minimums were brought up to code. The savings estimates were tabulated for each of the four states in the study. The research team found that the single-family approach was largely applicable to low-rise multifamily buildings. This applies to both the data collection and the prototype EUI analysis. Most of the occupied space is living units and falls under residential energy codes, and many characteristics use similar envelope construction and relatively straightforward mechanical systems and lighting. One of the most challenging aspects of this work was to build an effective spreadsheet-based data collection instrument that could allow efficient collection of both building plan and field data. The research team is of the view that other methods could be equally effective if the work is done carefully with diligent quality control. The primary findings for the work center around the thermal envelope and mechanical systems and lighting at the sites: For thermal envelope components, the majority of buildings met or were better than the prescriptive code.This suggests that building designers and builders are aware of code requirements. In some cases, surveyed buildings were designed to qualify for energy efficiency certification programs. These buildings made up at least 20% of sampled buildings in each state. Almost all buildings met mechanical system efficiency requirements (for both living units and common areas). In some cases, sites employed systems that were considerably more efficient than required by the applicable energy code. Dwelling units had a majority of high-efficacy lighting, often in excess of the state’s residential code requirements. While high-efficacy fixtures were also typical in common areas (corridors and stairwells), lighting power densities (LPDs) in these areas were sometimes higher than levels dictated by the applicable part of the state commercial energy code. The simulation models run on a series of low-rise multifamily prototypes, informed by a composite of the field data collected, calculated annual EUIs of between 20 and 50 kBtu/ft2-yr, with the range representing the effects of both building characteristics and building location (climate zone). A detailed process (based on simulations of prototype buildings) was used to estimate the amount of avoided energy use that would occur if 100% adherence to energy codes were attained. The results indicated modest savings are attainable for items such as window thermal performance and common area lighting. The result is overall only a modest potential for additional energy savings, averaging about 10% of EUI.

29 ENERGY PLANNING, POLICY, AND ECONOMY↗

Iodine Flowsheet Status Report

A simplified flowsheet was developed to evaluate the impact of varied assumptions of I-129 decontamination factors on the overall I-129 material balance in the Direct Feed Low-Activity Waste (DFLAW) facility. The flowsheet allows inputs for I-129 feed and Decontamination Factors (DFs) for multiple DFLAW unit operations and provides information on I-129 partitioning to output streams. A series of 6 DFs were evaluated, including baseline DFs from a prior Waste Treatment and Immobilization Plant (WTP) study and refined values based on a Savannah River National Laboratory (SRNL) review. The Microsoft Excel flowsheet spreadsheet will be provided to WRPS to allow further evaluation of the impact of DF assumptions on output streams. The spreadsheet is not specific to iodine, the partitioning of any species can be estimated by entering the assumed DFs for each unit operation. Flowsheet outputs matched results from the prior WTP study and show that different assumptions for the DFs can greatly impact iodine partitioning to primary and secondary waste streams. Results from SRNL's baseline DF values suggest less than 50% of I-129 would be retained in glass versus the 96% when using the BNI DF values. In addition, the flowsheet demonstrated that more than 5 DFLAW operational cycles are required to achieve a steady-state of I-129 to the primary waste stream. It is not possible with the data available to determine whether the BNI approach or the approach taken in this study will be a better match for the iodine partitioning once the LAW facility begins operation.

11 NUCLEAR FUEL CYCLE AND FUEL MATERIALS↗

Solid Oxide Cell and Stack Manufacturing Cost Tool

This is the user manual for the SOC Manufacturing Cost Tool spreadsheet. The manual details the use and meaning of each tab, color scheme, and spreadsheet operation. Also detailed are specific instructions for end-user modification and inputs to tailor the tool to their specific technology. To access the cost tool, please visit: <a href="https://netl.doe.gov/energy-analysis/details?id=d224ad08-6a38-402a-9cad-907db19e394f" rel="noopener noreferrer">Energy Analysis | netl.doe.gov</a>.

cost modeling↗

Model Validation Database for Fires Involving Fuels at Liquefied Natural Gas Facilities

This document provides a description of the model evaluation protocol (MEP) database for fires involving liquefied natural gas (LNG) and processing fuels at LNG facilities. The purpose of the MEP is to provide procedures regarding the assessment of a model's suitability to predict thermal exclusion zones resulting from a fire. The database includes measurements from pool fire, jet fire, and fireball experiments which are provided in a spreadsheet. Users are to enter model results into the spreadsheet which automatically generates statistical performance measures and graphical comparisons with the experimental data. The intent of this document is to provide a description of the experiments and of the procedure required to carry out the validation portion of the MEP. In addition, the statistical performance measures, measurements for comparisons, and parameter variation are provided.

03 NATURAL GAS↗

Survey of the Worldwide Supply Chain of Commodities Needed for a Quantum Technology Program

Quantum Information Science (QIS) is an emerging technology being pursued by fundamental science research groups worldwide, as well as commercial companies and government programs. There are a variety of QIS disciplines, including quantum computing, quantum sensing and quantum encryption. Some of the commodities needed for a robust quantum laboratory are particular to quantum phenomenon, but in general the equipment needed is similar to that needed for a typical high - technology lab (e.g. oscilloscopes, lasers, vacuum chambers, etc.). This study focuses on identifying commodities manufactured worldwide that would be needed for a robust quantum lab. The authors' own knowledge of needed equipment and primary vendors was used as a starting point, follow ed by extensive internet searching and utilization of buyer's guides to create a large spreadsheet of most of the components needed, the company offering the components, and country of manufacture. With this extensive spreadsheet, stakeholders can identify commodities that would be needed for a quantum lab oratory and potentially identify market choke points.

29 ENERGY PLANNING, POLICY, AND ECONOMY↗

Neutronics Calculations for EBR-II Run 137E

Neutronics calculations were performed for EBR-II Run 137E using MC2 -3/TWODANT, DIF3D, and PERSENT codes. Parameters required for system safety analysis such as the reactivity feedback coefficients and core power distribution were evaluated. The detailed results are provided in the accompanying Excel spreadsheet Run_137E_Neutronics_Results.xls. This report describes the core model of EBR-II at the beginning of Run 137E, the computation methodology, and how to interpret the results listed in the Excel spreadsheet.

21 SPECIFIC NUCLEAR REACTORS AND ASSOCIATED PLANTS↗

Reduced Order Costs for CO 2 Saline Storage for Use in Energy Market Models

This report provides the results of a collaboration between NETL, Los Alamos National Laboratory (LANL) and FECM headquarters personnel. NETL's FECM/NETL CO 2 Saline Storage Cost Model (CO2_S_COM) and LANL's Sequestration of CO 2 Tool (SCO 2 T) model were run with the same assumptions to generate costs for 314 potential storage formations in the U.S. The two models gave similar results. The results from CO2S_COM were then aggregated into a smaller number of costs that can be utilized in energy market models. The report has a companion spreadsheet called red_ord_costs_CO2_S_COM with the reduced order costs. The spreadsheet can be viewed online here: https://www.netl.doe.gov/energy-analysis/details?id=fb6d93df-0702-47aa-8147-59a5ae0c7cfd

54 ENVIRONMENTAL SCIENCES↗

Verification of RESRAD-BUILD Code Version 4

This report documents the verification of the RESRAD-BUILD code, Version 4.0, which was released on December 22, 2022. Two earlier reports verifying Versions 3.0 and 3.1, respectively, were published in 2001 (Kamboj, et al. 2001) and 2003 (Tetra Tech NUS 2003). Version 4.0 of the RESRAD-BUILD code has many new features and modeling enhancements over the earlier versions, including the previously released Version 3.5. Chapter 2 of this report focuses on verifying the external dose and risk modeling for point, line, area, and volume sources, as well as for floor deposition. Besides verification, the external radiation doses calculated by RESRAD-BUILD were also benchmarked with those calculated by the MCNP code (Briemeister 1993). Section J.3 of the RESRAD-BUILD User’s Manual Vol. 1 (Yu et al. 2022) documents the results of that benchmarking effort. Chapter 3 of this report focuses on verifying the ventilation modeling, from checking the remaining source inventory, releases of radionuclides to the air, air concentrations and deposited floor concentrations over time, to the radiation dose and risk associated with inhalation, ingestion, and air submersion, with and without vacuuming. The verification efforts involve designing spreadsheets to perform calculations the same as or like those performed by the RESRAD-BUILD code and then comparing the spreadsheet results with those produced by the code. When the results agree or the differences are within acceptable range, the accuracy of model implementation in the code is verified. In addition to model implementation, the implementation of key functions and features that facilitate the modeling or the use of the code were also verified during the release testing of the code. Appendix A presents the test cases developed for these verification testing, and Appendix B presents the testing results that verify proper implementation of key functions and features.

54 ENVIRONMENTAL SCIENCES↗

Model Validation Database for Fires Involving Fuels at Liquefied Natural Gas Facilities (Version 2)

This document provides a description of the model evaluation protocol (MEP) database for fires involving liquefied natural gas (LNG) and processing fuels at LNG facilities. The purpose of the MEP is to provide procedures regarding the assessment of a model’s suitability to predict thermal exclusion zones resulting from a fire. The database includes measurements from pool fire, jet fire, and fireball experiments which are provided in a spreadsheet. Users are to enter model results into the spreadsheet which automatically generates statistical performance measures and graphical comparisons with the experimental data. The intent of this document is to provide a description of the experiments and of the procedure required to carry out the validation portion of the MEP. In addition, the statistical performance measures, measurements for comparisons, and parameter variation are provided.

03 NATURAL GAS↗

2021 Source Term Template.xlsx

This is a screening spreadsheet and is used as a tool to calculate the source term for annual reporting, a new proposed project (APAD) or to calculate a periodic confirmatory measurement (PCM). NASA is doing a study of possible locations for a nuclear thermal propulsion ground test site and would like to use the spreadsheet to refine their study and provide guidance for future planning.

33 ADVANCED PROPULSION SYSTEMS↗