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 19 records
All sourcesNASA NTRSDOE OSTI
DOE OSTI2022

NETL CO2U LCA Documentation Spreadsheet

The NETL CO2U LCA Documentation Spreadsheet is part of the NETL CO2U LCA Guidance Toolkit for Carbon Utilization funding recipients to meet their LCA requirements. The toolkit includes the following files: NETL CO2U LCA Guidance Document, NETL CO2U openLCA LCI Database, NETL CO2U openLCA Results Contribution Tool, NETL CO2U LCA Documentation Spreadsheet, and NETL CO2U LCA Report Template. The NETL CO2U LCA Documentation Spreadsheet is available to funding recipients to help meet their LCA data documentation requirements, especially when using a spreadsheet model rather than LCA software to complete the LCA requirements.

54 ENVIRONMENTAL SCIENCES↗
DOE OSTI2020

Environmental Life Cycle Assessment Spreadsheet tool for Deep Direct-Use Geothermal at the University of Illinois at Urbana-Champaign Campus

A Life Cycle Assessment (LCA) spreadsheet tool was developed to analyze potential environmental benefits of a deep direct-use (DDU) geothermal energy system (GES) at the University of Illinois at Urbana-Champaign (U of IL) campus. The LCA spreadsheet tool is a unique contribution to the feasibility study that provides further insight into the cradle-to-grave environmental impacts associated with the GES over the operating life time, as well as other DDU GES with similar objectives. The tool allows for a more in-depth analysis of the feasibility of DDU GES with respect to the overall environmental impacts. For the U of IL assessment, a doublet (two-well) system is evaluated, which is connected to aboveground mechanical system to supply heating to six agricultural research facilities. The additional of new equipment are assessed for the technical and economic feasibility. The results from this study will also allow geothermal resources from the entirety of the Illinois Basin (ILB) to be assessed and allow the DDU technology to be extended to additional areas of the ILB and other low-temperature sedimentary basins with similar characteristics.

15 GEOTHERMAL ENERGY↗
DOE OSTI2020

Adiabatic Cooling System Spreadsheet Model for sCO 2

The attached cost and performance spreadsheet model is for an adiabatic cooling system, one of four cooling system models developed for use in optimizing indirectly-heated supercritical CO 2 (sCO 2 ) power cycles. Running the model requires that the user has REFPROP version 9 or below installed, as well as the Microsoft Excel REFPROP Add-In. Upon opening, use Excel’s Edit Links feature to link to the user’s installed REFPROP.xla or REFPROP.xlam file. For the spreadsheet model compatible with REFPROP version 10 and above, contact Nathan Weiland at nathan.weiland@netl.doe.gov. Technical documentation for the model can be found here: https://www.netl.doe.gov/energy-analysis/details?id=3199.

30 DIRECT ENERGY CONVERSION↗
DOE OSTI2020

Direct Dry Cooling System Spreadsheet Model for sCO 2

The attached cost and performance spreadsheet model is for a direct dry cooling system, one of four cooling system models developed for use in optimizing indirectly-heated supercritical CO 2 (sCO 2 ) power cycles. Running the model requires that the user has REFPROP version 9 or below installed, as well as the Microsoft Excel REFPROP Add-In. Upon opening, use Excel’s Edit Links feature to link to the user’s installed REFPROP.xla or REFPROP.xlam file. For the spreadsheet model compatible with REFPROP version 10 and above, contact Nathan Weiland at nathan.weiland@netl.doe.gov. Technical documentation for the model can be found here: https://www.netl.doe.gov/energy-analysis/details?id=3199.

30 DIRECT ENERGY CONVERSION↗
DOE OSTI2020

Indirect Dry Cooling System Spreadsheet Model for sCO2

The attached cost and performance spreadsheet model is for an indirect dry cooling system, one of four cooling system models developed for use in optimizing indirectly-heated supercritical CO2 (sCO2) power cycles. Running the model requires that the user has REFPROP version 9 or below installed, as well as the Microsoft Excel REFPROP Add-In. Upon opening, use Excel’s Edit Links feature to link to the user’s installed REFPROP.xla or REFPROP.xlam file. For the spreadsheet model compatible with REFPROP version 10 and above, contact Nathan Weiland at nathan.weiland@netl.doe.gov. Technical documentation for the model can be found here: https://www.netl.doe.gov/energy-analysis/details?id=3199.

30 DIRECT ENERGY CONVERSION↗
DOE OSTI2020

Wet Cooling Tower Cooling System Spreadsheet Model for sCO2

The attached cost and performance spreadsheet model is for a wet cooling tower system, one of four cooling system models developed for use in optimizing indirectly-heated supercritical CO2 (sCO2) power cycles. Running the model requires that the user has REFPROP version 9 or below installed, as well as the Microsoft Excel REFPROP Add-In. Upon opening, use Excel’s Edit Links feature to link to the user’s installed REFPROP.xla or REFPROP.xlam file. For the spreadsheet model compatible with REFPROP version 10 and above, contact Nathan Weiland at nathan.weiland@netl.doe.gov. Technical documentation for the model can be found here: https://www.netl.doe.gov/energy-analysis/details?id=3199.

30 DIRECT ENERGY CONVERSION↗
DOE OSTI2024

2020 natural gas LCA data appendices

This collection is the data-centric appendices for the report Life Cycle Analysis of Natural Gas Extraction and Power Generation: U.S. 2020 Emissions Profile. It consists of Appendix A: Additional Modeling Parameters [spreadsheet]; Appendix B: Water Burdens [spreadsheet]; Appendix D: Simulation of Liquids Unloading [python script and spreadsheet]; Appendix E: Detailed GHG Results for All Scenarios [spreadsheet]; Appendix F: Full Inventory Results [spreadsheet]; and Appendix I: Stage-Level Natural Gas Loss and Consumption Rates [spreadsheet].

Appendices↗
DOE OSTI2025

2020 natural gas LCA appendices Rev1

This collection is the data-centric appendices for the report Life Cycle Analysis of Natural Gas Extraction and Power Generation: U.S. 2020 Emissions Profile. It consists of Appendix A: Additional Modeling Parameters [spreadsheet]; Appendix B: Water Burdens [spreadsheet]; Appendix D: Simulation of Liquids Unloading [python script and spreadsheet]; Appendix E: Detailed GHG Results for All Scenarios [spreadsheet]; Appendix F: Full Inventory Results [spreadsheet]; and Appendix I: Stage-Level Natural Gas Loss and Consumption Rates [spreadsheet]. These results have been updated from the previous version (https://edx.netl.doe.gov/dataset/2020-natural-gas-lca-data-appendices) to correct a modeling error where the same post-processing natural gas composition was used instead of the intended regional compositions.

Appendices↗
DOE OSTI2024

Example Alternative Compliance Annual Report: EPAct State and Alternative Fuel Provider Fleet Program User Guide

The U.S. Department of Energy developed an electronic reporting spreadsheet to facilitate fleets' preparation of a complete Alternative Compliance (AC) annual report. All fleets that participate in AC are encouraged to use the spreadsheet. The following examples include one AC annual report that uses the spreadsheet and one AC annual report that does not use the spreadsheet. Both examples include all components that must be included in a fleet's AC annual report. For further instructions on how to use the reporting spreadsheet, review the Alternative Compliance Guidance Document.

ADVANCED PROPULSION SYSTEMS,ENERGY PLANNING, POLIC↗
DOE OSTI2026

Data from: Lowland Tropical Forests Remain a Methane Sink Under Warming and Long-Term Hurricane Disturbance Recovery

The repository folder contains spreadsheets and script for soil greenhouse gas (GHG) fluxes, soil moisture, soil temperature, air temperature, and precipitation measurements collected from the Tropical Responses to Altered Climate Experiment (TRACE) at the Sabana Research Field Station, El Yunque National Forest (USDA Forest Service; 18°19′28.74″ N, 65°43′50.09″ W) — an open-air field warming experiment located in a lowland tropical forest in Puerto Rico within the Luquillo Experimental Forest (LEF) — six to seven years after Hurricanes Irma and Maria (2017). All spreadsheets for soil and air microclimate data, as well as soil greenhouse gas data, are included as csv files. Air temperature data are also included as Excel spreadsheets (.xlsx). The script is built in R Studio, which is the only software required to run data analysis. This dataset is associated with the manuscript “Larocca Conte G ; Zuvela L ; Cruz-Pérez R ; Barreto-Vélez T ; Becerra-Santillan N ; Campbell S ; Chu H ; Dam T ; Grullón-Penkova I ; Kleit M ; Ortiz-Iglesias D ; Rubio-Lebrón L ; Cavaleri M ; Reed S ; Sihi D ; Wood T ; O'Connell C., 2026. Lowland Tropical Forests Remain a Methane Sink Under Warming and Long-Term Hurricane Disturbance Recovery. Agricultural and Forest Meteorology. In review". The dataset was used to test the effect of warming on soil CH4 dynamics following long-term legacy effects of hurricane disturbance. The dataset includes: - An overall README file in word and pdf format describing methodology and spreadsheets’ structure. - Continuous measurements of soil temperature and moisture from January 2023 to July 2024 measured with Campbell CS655 probes (“TRACE_soil_temperature_and_moisture_2023_cleaned(in).csv” and “TRACE_soil_temperature_and_moisture_2024_cleaned. csv”). - Air temperature data measured with a HOBO MX23O1A data logger (“Hobo air temperature 2023 Sep 2024” and “Hobo air temperature 2023 Sep 2024” – “CSV FILES folders”). - Precipitation data from a nearby weather tower downloaded from González et al. (2025; “sabana_2020-2025.csv”). - Soil CH4 and CO2 effluxes measured intermittently in two summer campaigns (June – August 2023 and June – July 2024) with a LI-COR 8200-01S Portable Smart Chamber coupled with a LI-COR LI-7810 CH4/ CO2/H2O Trace Gas Analyzer (“23_24COMBO2.0.csv”). - R markdown script for data analysis (“Trace new_PLOTS.Rmd”).

54 ENVIRONMENTAL SCIENCES↗
DOE OSTI2020

Calculating Potential Radiological Emissions for Waste Management Activities at INL - 20068

At Idaho National Laboratory (INL), work involving radionuclides is evaluated for potential emissions from a project in order to comply with the National Emission Standards for Hazardous Air Pollutants (NESHAP) regulations, 40 CFR 61 Subpart H. Emission calculations are documented in an Air Permitting Applicability Determination (APAD) to analyze unmitigated and mitigated emissions and determine if an Application to Construct (ATC) or continuous monitoring is required. To calculate the unmitigated and mitigated emissions, a spreadsheet was developed to provide ease in determining potential emissions by providing the maximum operating temperature and the material being used. The spreadsheet aids in determining the potential emissions for research projects and waste management activities at Materials and Fuels Complex (MFC) and other locations across the INL site. Furthermore, it can also be used for periodic confirmatory measurements (PCM) to justify low emissions. Elements that factor into the unmitigated and mitigated calculations include the amount of each radionuclide used (in curies or grams), specific activity (if amount is given in grams), the temperature the material is heated to in Celsius, the dose conversion factor which is derived from Clean Air Act Assessment Package - 1988 (CAP-88) modeling, and the number of HEPA filters used for mitigated measures. The main drivers for calculating the unmitigated emissions for a project are the amount used per radionuclide, the maximum operating temperature, and the location of the work. The maximum operating temperature determines the airborne release factor which is dependent on the physical state of the radionuclide. Prior to October 2017, if the radionuclide was heated to greater than 100 deg. C, the radionuclide was assumed to be a gas, which has the highest airborne release factor. This assumption would be overly conservative for radionuclides with high melting and boiling points, which provided a challenge to demonstrate low emissions. In October 2017, the Environmental Protection Agency (EPA) approved an alternative method for INL. This method allows the airborne release factor to be determined by using the melting point and 90% of the boiling point of the radionuclide. This methodology was included in the spreadsheet to allow unmitigated emission calculations for APADs to be completed more efficiently and effectively. Results show a reduction in time completing air emission calculations as well as lower total emissions across all facilities at INL. MFC annual emissions were reduced by 62% from the previous year and Research and Education Campus (REC) facilities were reduced by 38% due to implementation of the approved alternative method. Time spent on APADs, PCMs, and documentation for the annual NESHAP report was also reduced significantly. The spreadsheet provided in Table I provides the potential emission calculations for the 'Advanced Retrieval and Disposition Techniques for Remote Handled Mixed Low Level Waste (RH MLLW) at the Radioactive Scrap and Waste Facility (RSWF)' project. Calculations show the Potential Effective Dose Equivalent (PEDE) at RSWF to be 7.27 E-04 mrem/yr (7.27 E-09 Sv/yr) which is well below the 0.1 mrem/yr threshold. (authors)

12 MANAGEMENT OF RADIOACTIVE AND NON-RADIOACTIVE W↗
DOE OSTI2024

Three-point Analysis for Butler-Volmer Electrochemical Kinetics

This file contains a spreadsheet and equations that evaluate corrosion test data. The data (which can be inserted by the user) is current vs voltage data. This spreadsheet will be part of the supplemental information of a journal article that is under review. Specifically, the spreadsheet evaluates the classical Butler Volmer equation in the presence of several different forms of noise found in electrochemical systems. The forms of noise are: 1) solution resistance, 2) random noise in the current, 3) drift of the open circuit potential voltage.

Cho, Seongkoo [Lawrence Livermore National Laborat↗
DOE OSTI2021

The Steel Equivalency Workbook: An X-Ray Transmission Calculator

The Steel Equivalency Spreadsheet was created as a robust, user-friendly method for the following: 1. Determining if it is possible to image an object. 2. Reducing time needed when selecting equipment and preparing for field imaging activities. 3. Reducing the amount of equipment taken for field imaging activities. 4. Determining a starting point for exposure settings prior to imaging an object. 5. Reducing the amount of dose deposited to complete an imaging operation (in the spirit of As Low As Reasonably Achievable, ALARA). The spreadsheet was developed using various physical models to account for different phenomena. Future implementations aim to expand beyond the Digital Radiography and Computed Tomography Single Munition Scanner (DRCT SMS) in standard configuration to include high energy XRGs (Betatrons) and sub-MeV pulsed XRGs (XRS4). Alternative computational methods that compensate for incoherent scattering when calculating relative transmission are also being pursued. Ultimately the spreadsheet exceeded the developmental goal of having less than 10% average error when comparing calculations to real-world images.

36 MATERIALS SCIENCE↗
DOE OSTI2024

Thermal Cooling Water Datasets for Electric Sector Modeling

This spreadsheet contains data inputs associated with representations of water (i.e., use, supply, costs) for thermo-electric based production. Values in this spreadsheet have been used to support multiple transmission-related planning studies, using models such as Regional Energy Deployment System Model (ReEDS). More information about associated studies can be found in Miara et al., 2019 (DOI: 10.1021/acs.est.9b03037); Cohen et al., 2022 (DOI: 10.1016/j.apenergy.2022.119193); and Cohen et al., 2024 (DOI TBD). Within these transmission-related studies, the values present in this spreadsheet are assigned for simulation of both existing units as well as new capacity build-outs. A summary of worksheets' content as well as associated sources are captured below.

24 POWER TRANSMISSION AND DISTRIBUTION↗
DOE OSTI2020

VENTSAR V3.0: A Python GUI for Estimating Contaminant Concentrations on or Near Buildings Due to Building Effects and Plume Rise and For Calculating Inhalation and Plume Shine Doses

VENTSAR: Originated as VENTAX (Smith and Weber 1983) on the IBM Mainframe at the Savannah River Site (SRS) as a Fortran program. Updated to VENTSAR XL V1.0 (Simpkins 1997) as a spreadsheet version using macros created in Microsoft Excel. Later updated to VENTSAR XL V2.0 (Dixon 2018) as a spreadsheet executing a modified version of the original VENTAX Fortran code. Estimates contaminant concentrations on or near a building from a release at a nearby location. Calculates concentrations for a given meteorological exceedance probability or for a given stability and wind speed combination. Can model a single building with or without a penthouse on top or a ground location from either a stack or ground release. Plume rise can be considered. Contaminant releases can be chemical or radioactive with downwind concentrations determined at user-specified distances. Wind passing over and around buildings creates a complicated dispersion pattern. Air-intake vents may be located on building roofs or near the ground downwind of a release source. An estimation of pollutant concentrations on or near a structure is important in determining expected pollutant levels. Meteorological data are selected based on a specific area of the site. Fortran-based VENTAX able to make fast, complex mathematical calculations. Not user-friendly VENTSAR XL V1.0 no longer supported due to obsolete Excel macros. VENTSAR XL V2.0 an interim solution using an Excel spreadsheet to interface with the modified VENTAX Fortran code. Requires user to have Microsoft Excel. Not an intuitive interface for someone unfamiliar with VENTSAR. Does not perform dose calculations. VENTSAR V3.0 goal to combine the strengths of previous versions of VENTSAR into a single, powerful yet user-friendly program with a Graphical User Interface (GUI). Not dependent upon a specific program or plug-ins. Self-contained package to be used on any computer running Microsoft Windows. User-friendly, intuitive GUI created in Python for parameter input. Executes same modified VENTAX Fortran code as VENTSAR XL V2.0. Outputs formatted text file of completed calculations for easy review and dissemination. Performs inhalation and plume shine dose calculations for up to 11 user-selected nuclides from a nuclide dose factor library of almost 500 nuclides. 12 test cases were created for verification of V1.0 and V2.0. Same test cases run in V3.0 to verify correct performance. V3.0 produced similar results to V1.0. Confirmed GUI did not alter calculations in any way. Comparisons of the test case results confirm the V3.0 GUI does not influence the VENTSAR calculations. Simply passes same input parameters to VENTAX Fortran code for execution. Provides end user an easy-to-use, intuitive tool to quickly make building effect and plume rise calculations, as well as, inhalation and plume shine dose calculations. No experience with or working knowledge of Fortran, Excel, command line, or macros required. Self-contained package allows VENTSAR be deployed to any Windows computer without the need for specific programs or plug-ins.

12 MANAGEMENT OF RADIOACTIVE AND NON-RADIOACTIVE W↗
DOE OSTI2024

Baseline Characterization Database Verification Report ? NBG-17 Billet V104

The purpose of this report is to present data collected in the Baseline Graphite Characterization Program, which is directly tasked with supporting the Idaho National Laboratory’s (INL’s) research and development efforts on the Advanced Reactor Technologies (ART) Program. This program populates a comprehensive database that reflects the baseline properties of nuclear-grade graphite regarding individual grade, billet, and position within individual billets. The physical- and mechanical-property information being collected will be transferred to the Nuclear Data Management and Analysis System (NDMAS), and that database will help populate the handbook of property data available to member nations of the Generation-IV International Forum. Transfer of these data from the applicable technical lead to the dissemination databases available to other end users requires a full review of the test procedures and data-collection efforts through an analysis of the multiple summary spreadsheets and values being collected. This report represents the analysis for NBG-17 Billet V104 and facilitates release of associated data to the NDMAS custodians. Millions of raw data points have been collected during testing and quantification analyses for these billets. The summary scalar property values and supplementary traceability data are collected into comprehensive spreadsheets. Data sets are composed of single billets of graphite for any given grade, organized by mechanical test-specimen type, and further subdivided into individual spreadsheet tabs according to the specific test or evaluation being performed. A direct analysis of properties was not conducted, and this report does not provide information on the validity or performance characteristics of the graphite itself. Rather, this report is intended as a verification of the completeness of actual data collected in accordance with PLN-3467, “Baseline Graphite Characterization Plan: Electromechanical Testing,” [1] and PLN-3348 “Graphite Mechanical Testing” [2] and their representation of the measurement and test results with sole regard to the graphite billets under evaluation.

11 NUCLEAR FUEL CYCLE AND FUEL MATERIALS↗