Search NASA⌕ Search

SEARCH · Search NASA

Results for “Excel 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

CO2-SCREEN

CO2 Storage prospeCtive Resource Estimation Excel aNalysis (CO2-SCREEN) is a tool which was developed by the Department of Energy’s National Energy Technology Laboratory (DOE-NETL) to screen saline formations for prospective CO2 storage resources. CO2-SCREEN applies U.S. DOE methods and equations for estimating prospective CO2 storage resources for saline formations. This provides a dependable method for calculating prospective CO2 storage resources which allows for consistent comparison of results between different research efforts. CO2-SCREEN latest version (v5.0) is a python application that utilizes a Java front end user interface. The 3.0 version consists of an Excel spreadsheet containing geologic inputs and outputs, linked to a GoldSim Player model that calculates prospective CO2 storage resources via Monte Carlo simulation. https://www.youtube.com/watch?v=lhakk-HYfOI

CO2 Storage Resource,Prospective Storage,Screening↗

CO2 pipeline data catalog

This "Data Catalog" is an excel spreadsheet of collected and catalogued spatial and non-spatial public datasets in relevance to and support of CO2 transport (pipelines) infrastructure development and risk modeling. Includes data associated with CO2 sources, sinks, and transportation.

CO2↗

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↗

Datasets for DOE 2023 Communities LEAP

This data is aligned to eligibility criteria outlined in the United States Department of Energy (DOE) 2023 Communities LEAP (Local Energy Action Program). Please visit the LEAP website (https://www.energy.gov/communitiesLEAP/communities-leap) to learn more about LEAP and gain additional contextual information for how these data may be used. The data provided approximates how the eligibility criteria apply at the census tract level across the United States. This EDX submission provides access to information pertaining to each of the four eligibility criteria outlined (average energy burden, percent low income, communities with a historic economic dependence on fossil fuel industrial facilities, and disadvantaged communities) for all census tracts within the 50 U.S. States, the District of Columbia (D.C.), and Puerto Rico. This information can be access in a detailed excel spreadsheet or through the linked interactive web application (https://arcgis.netl.doe.gov/portal/apps/experiencebuilder/experience/?id=2a77f443d72b4a4d82474b3ffe33b8cd). Please note that while these data are provided at the census tract level, census tracts do not necessarily have the same physical boundaries as a community but were used as they provide the closest proxy based on publicly available information collected using an empirically robust method. U.S. territories are not listed but are eligible to apply to Communities LEAP. As stated in the Opportunity Announcement, applying communities should describe how they meet the eligibility criteria in their application even if these data do not specifically show that they are eligible.

2023↗

2016 US Petroleum fuels Life Cycle Baseline Data Package

This data package accompanies the report "2016 U.S. Petroleum Fuels Life Cycle Baseline." It contains the openLCA life cycle model that generated the results and an Excel spreadsheet that contains well-to-tank life cycle inventory for all products.

Life Cycle Analysis Options - Fuels↗

SimpleMass (Version 2.0.1 Report)

SimpleMass v2 is an updated GUI version of the SimpleMass Excel spreadsheet. It was developed using Python 3.7 and wxPython, a cross-platform GUI toolkit. The program was developed on Windows 10 and tested on macOS Catalina. In theory, the program should work on Linux based operating systems such as Ubuntu, but this has not been tested. Executable versions of the code were built using PyInstaller. The version described in this report is an alpha version that is still in development. It has only been tested by the developer.

97 MATHEMATICS AND COMPUTING↗

NCS Program Health Tool

At the end of 2019, there were assessments of multiple safety management programs relied on by NCS that had significant issues identified. Discuss outliers with responders. Better definitions of categories. Expand audience. Move from Excel spreadsheet to web-based.

99 GENERAL AND MISCELLANEOUS↗

FECM/NETL CO 2 Transport Cost Model (2022): Model Overview [Slides]

The FECM/NETL CO 2 Transport Cost Model (CO 2 _T_COM) is an Excel spreadsheet model that calculates the cost of transporting CO 2 from the beginning to the end of a pipeline. This document provides an overview of the model. This document is intended to provide a user with a briefer description of the model and how to use the model than the user’s manual.

42 ENGINEERING↗

FECM/NETL CO 2 Transport Cost Model (2022): Description and User’s Manual

The FECM/NETL CO 2 Transport Cost Model (CO 2 _T_COM) is an Excel spreadsheet model that calculates the cost of transporting CO 2 from the beginning to the end of a pipeline. This document provides two main functions. First, the document describes the equations and algorithms that are used by the model to calculate technical quantities (such as the minimum inner pipe diameter needed to transport a user-specified CO 2 mass flow rate a specified distance) and engineering-economic quantities (such as capital costs, operating costs and cash flows). Second, the document is a user’s manual for the model that describes the procedures the user must follow to run the model. The document also describes input variables and output variables (i.e., results) for the model.

42 ENGINEERING↗

Intermountain West Energy Sustainability & Transitions Initiative: CO 2 Transport and Geologic Storage Modeling Results

This report and its associated Excel spreadsheet file provide the results of technoeconomic modeling of carbon dioxide (CO 2 ) pipeline transport modeling, CO 2 storage in deep saline subsurface formations, and CO 2 enhanced oil recovery (EOR). This report provides the methodology, describes the models and summarizes results for the three aspects of the analysis done for the Intermountain West Energy Sustainability and Transition (I-WEST) Initiative.

42 ENGINEERING↗

Operational Energy Life Cycle Data Development for the National Institute of Standards And Technology (NIST) Building Industry Reporting and Design for Sustainability (BIRDS) Neutral Environmental Software Tool (NEST)

For this analysis, regionalized life cycle assessment (LCA) results for environmental impacts (using the Tool for Reduction and Assessment of Chemicals and Other Environmental Impacts [TRACI] 2.1) and cumulative energy demand (using the Federal Life Cycle Analysis Commons Elementary Flow List [FEDEFL] Inventory Methods v1.0.0) were evaluated for the production and utilization of electricity, natural gas, fuel oil, and propane as commodities within residential and commercial buildings. These results can used as a framework for future research into net zero, high-performance buildings, such as done here for the Building Industry Reporting and Design for Sustainability (BIRDS) database by the National Institute of Standards and Technology (NIST) Engineering Laboratory. The geographical results were assigned to each United States (U.S.) Zone Improvement Plan (ZIP) code based on the ZIP code location and corresponding Balancing Authority Area, natural gas basin, and Petroleum Administration for Defense Districts (PADDs). Additionally, previously developed models were utilized to develop future life cycle profiles. Projections were based on data available from the U.S. Energy Information Administration Annual Energy Outlook 2022 through 2050 (AEO 2022). Electricity LCA models were updated based on AEO 2022 projected annual generation mixes, while the natural gas baseline model was updated based on projected shares of natural gas types (conventional, shale, tight, and coalbed methane). Projections of crude oil production rates and export rates were applied to the petroleum baseline model in five-year increments to investigate their effects on the life cycle profile of fuel oil and propane. While only 100-year Global Warming Potential (GWP-100) with climate carbon feedback (CC-FB) and Cumulative Energy Demand are shown in Section 4: Results, the complete results, including Acidification Potential, Eutrophication Potential, Freshwater Ecotoxicity Potential, GWP-100 without inclusion of CC-FB, Human Health Impacts Potentials (Cancer, Non-Cancer), Ozone Depletion Potential, Particulate Matter Formation Potential, and Photochemical Smog Formation Potential, are tabulated for each ZIP code in the Excel worksheets that accompany this analysis. For the Excel spreadsheet tools associated with this report, please go to https://www.netl.doe.gov/energy-analysis/details?id=f8890fac-be55-44ac-aaa9-e2888bfabe93

32 ENERGY CONSERVATION, CONSUMPTION, AND UTILIZATI↗

Pulverized Coal CO2 Capture Retrofit Database

This tool provides high-level analysis on the incremental costs for retrofitting pulverized coal plants with carbon dioxide capture and/or compression systems. Options are available to include costs of other technological improvements that would be required to comply with various environmental regulations when installing carbon capture technology. This model is based on the NETL report "Eliminating the Derate of Carbon Capture Retrofits." (2023). For the Excel spreadsheet tools associated with this report, please go to https://www.netl.doe.gov/energy-analysis/details?id=e7e822ff-18ac-4bc6-a052-0be3521b8789

01 COAL, LIGNITE, AND PEAT↗

FECM/NETL CO 2 Transport Cost Model (2023): Description and User’s Manual

The FECM/NETL CO 2 Transport Cost Model (CO 2 _T_COM) is an Excel spreadsheet model that calculates the cost of transporting CO 2 from the beginning to the end of a pipeline. This document provides two main functions. First, the document describes the equations and algorithms that are used by the model to calculate technical quantities (such as the minimum inner pipe diameter needed to transport a user-specified CO 2 mass flow rate a specified distance) and engineering-economic quantities (such as capital costs, operating costs and cash flows). Second, the document is a user’s manual for the model that describes the procedures the user must follow to run the model. The document also describes input variables and output variables (i.e., results) for the model. The model can be accessed at this URL: https://www.netl.doe.gov/energy-analysis/details?id=d3086f60-278d-4e97-a649-8e4d5ce5e93c

29 ENERGY PLANNING, POLICY, AND ECONOMY↗

Degradation of Poly- and Perfluoroalkyl Substances (PFAS) in Water via High Power, Energy-Efficient Electron Beam Accelerator

The goal of the 2-year workplan was to see if electron beam (EB) could be used to break down a sub-set of the larger chemical family of per and polyfluoroalkylated substances (PFAS) in an energy efficient and economical manner when compared to conventional water treatment technologies. Year one (Y1) work focused on sample EB treatment work in the Fermi National Accelerator Laboratory’s (FNALs) Accelerator Applications Demonstration and Development (A2D2) EB accelerator. While there are reportedly thousands of types of PFAS, for the point of most of the work herein, a small subset was examined, typically perfluorooctane sulfonate (PFOS) and perfluorooctanoate (PFOA). PFOA and PFOS are two of the most well studied PFAS and are studied for baseline evaluations and are considered most useful. The work from Y1 provided information about the optimal operating parameters and additives to use when treating PFOS and PFOA via EB. The data were then used to see where in a water treatment system an EB accelerator would be best suited to treat PFAS. A conventional water treatment technology, GAC, was then compared to e-beam treatment technology with respect to energy and costs for treatment. In year two (Y2), several conventional e-beam accelerator designs, and FNAL’s developmental compact SRF accelerator design, were evaluated for their suitability in PFAS treatment, from an energy efficiency and cost standpoint. Several EB parameters were evaluated and optimized for the removal of PFOA and PFOS from water at normal pressure and temperature, measured as total PFAS removal. Under the optimized test conditions both PFOA showed complete destruction to inorganic fluoride, and PFOS to inorganic fluoride and sulfate, with mass balance. The effect on PFAS removal relative to solution pH, total EB dose, EB dose rate, dissolved oxygen concentration (DO), temperature, and initial PFAS concentration were evaluated. In general, PFOA was easier to destroy than PFOS. Degradation products, typically observed under less-than-optimal EB conditions, provided insight to degradation mechanisms. Products were identified to rule out possible deleterious biproduct formation. The water radiolysis radical reaction kinetics with PFOS and PFOA were not dependent on the initial concentration over 5-orders of magnitude from 2 μg/L to 20 mg/L. This is thought to be because there was an overabundance of the reactive water radiolysis radicals relative to PFAS molecules and largely attributed to aqueous electrons. The reaction rates appeared to be diffusion limited. Testing at higher concentrations (100-200 mg/L) showed a decrease in removal efficiency, suggesting alternative kinetics, possibly second order rates, at higher concentrations. In all, we successfully defined a set of optimal EB parameters to treat PFOA and PFOS at concentrations of 20 mg/L in water with destruction efficiencies near 100%. We further tested the optimized EB parameters with other types of PFAS, including shorter and longer fluorocarbon chain homologs of PFOA and PFOS, and PFAS with alternative functional groups such as sulfonamides. Based on our results EB can be optimized as an effective destructive technology for removing PFAS from water. The conditions optimized for PFOA and PFOS were less effective with ultra-short fluorocarbon compounds like TFMS, PFES, PFPS and PFBS, and likely require re-optimization of parameters to them. In all, it was determined that from a cost and energy efficiency standpoint, EB would be best applied to waste streams with relatively high concentrations of PFOS and PFOA and is not as cost effective as GAC treatment for removing low concentrations of PFAS from water. Higher concentrations of PFAS can be found in the wastewater of conventional treatment processes such as RO and IE and therefore EB may be used to supplement such treatment technologies. Some real-world IE regeneration wash water and RO reject water containing higher concentrations of PFAS and obtained from pilot scale industrial wastewater treatment system at a fluorochemical manufacturing facility, showed that EB could remove PFAS from such types of wastewaters. The IE regenerant wash water appeared to be the most efficient of the two types of wastewaters tested. However, some further optimization of the EB parameters for the specific PFAS types present in those wastewaters may be required. Also, the effects of co-present TOC and mineral salts should be considered during such optimization efforts. From the experimental Y1 results it was seen that the aqueous electron drives degradation of the PFAS. In a hypothetical water treatment skid using EB for PFAS destruction the parameters of the system should be optimized to promote aqueous electron production. Before EB treatment, the PFAS should be preconcentrated when possible, the pH should be raised to pH 10 or higher to enhance aqueous electron production, and the water should be nitrogen purged to remove dissolved oxygen to minimize aqueous electron scavenging. An excel spreadsheet was created that calculates optimal conditions based on inlet PFAS concentration and desired outlet concentration, by optimizing the accelerator power, dose rate, water treatment rate, pH and dissolved oxygen levels to reach the desired endpoint. Given this information on accelerator operating conditions five different EB accelerator systems were compared. One EB system was a continuous-wave, linear superconducting accelerator being designed at Fermilab. Three other EB systems (IMPELA at 5% and 25% duty factor and the ILU-14) were normal conducting pulsed linear accelerators. The fifth system was an IBA Rhodotron which is a normal conducting, circular, continuous-wave accelerator. The accelerator efficiency (% of the incoming power that is used in water treatment) was the dominating factor in accelerator choice. The radio frequency (RF) power supply and the accelerator design (superconducting versus warm technology) drive the accelerator efficiency. The IBA Rhodotron was seen to be the most energy efficient commercially available technology with a wall-plug (total) power efficiency of 43% at 400 kW. The Fermilab design, with a prototype for a different application currently being fabricated, was the most energy efficient at 55% when driven by a Klystron RF power supply and as high as 77% when powered by a magnetron. As the Fermilab design was the most energy efficient by approximately 10-30%, further design work was done on the accelerator and beam delivery system specific to the destruction of PFAS in water. The Fermilab design is unique from industrial accelerators in that is superconducting. Superconducting technology allows for the acceleration of electrons without losses. The accelerator must be cooled to below the point where it is superconducting and is operated around 4 degrees Kelvin. The bulk of the design work for the accelerator is on making the accelerator as energy efficient as possible so that it does not require liquid helium and can be cooled with conduction cooling via cryocoolers. Final design work resulted in an EB accelerator that would operate at minimally 200 kW and 10 MeV. Prototype construction would cost $\$ $7.8 million dollars when driven by a Klystron power supply. A second version of the same accelerator would cost $\$ $5.5 million dollars when driven by a magnetron that is still under development. The commercially available 300 kW IBA Rhodotron cost was estimated at approximately $\$ $9 million. While it is hard to directly compare, an operational GAC system used by 3M for groundwater treatment capital cost (2022 dollars) was estimated to cost $\$ $3.3 million. While the capital expense of the EB accelerator systems was higher than GAC, the accelerator EB treatment would result in destruction of the PFAS and not just sequestration of PFAS to form a new waste stream that requires further treatment or disposal. The operating cost to destroy the PFAS via 400 kw EB system was less than $\$ $1000/kg of PFAS destroyed when treating at a 20 mg/L PFAS concentration, compared to GAC with operating costs that calculated at $\$ $27,530 per kg of PFAS sequestered when treating 100 μg/L PFOA and PFOS combined concentration.

37 INORGANIC, ORGANIC, PHYSICAL, AND ANALYTICAL CH↗

MCOR User Guide

User guide for the MCOR software package which is currently publicly hosted on Github (https://github.com/pnnl/MCOR). The Microgrid Component Optimization for Resilience (MCOR) tool simulates the operation of a renewable energy, battery, and back-up generator microgrid under a large range of outage conditions to understand how a potential system can meet the resilience goals of a particular site. It is an open-source, command line, Python-based tool that produces an output Excel spreadsheet as well as several types of plots to enable a user to compare different microgrid system sizes and costs. It is intended for high-level system planning and opportunity identification, and not for detailed electric system modeling and design. The tool includes a range of input parameters that can be adjusted or tuned to provide a more custom analysis as needed.

24 POWER TRANSMISSION AND DISTRIBUTION↗

Dataset for ASME VVUQ Symposium Workshop on Regression of Validation Data to an Application Point

This dataset consists of a collection of Excel spreadsheets that contain output from analysis specified in the workshop. The analysis involves ASME V&V 20-style validation as well as the application of a supplement methodology for regression of validation comparison error and validation uncertainty to application points where experimental data does not exist for comparison. The simulation results and experimental data are provided by the workshop organizers and a NASA report, respectively.

Kirsch, Jared Roelof [Sandia National Laboratories↗

Buoy - Massachusetts - Wind Sentinel (130) - Raw Data

This is the data collected during the validation period. The buoy is scheduled to be deployed near Martha's Vinyard in mid-January 2020. Data collected from buoy instruments are contained in two files labeled “primary” and secondary.” Header information for these files can be found in the respective tabs in the Excel spreadsheet under Attachments.

17 WIND ENERGY↗

Buoy - Massachusetts - Wind Sentinel (120) - Raw Data

This is the data collected during the validation period. The buoy is scheduled to be deployed near Martha's Vinyard in mid-January 2020. Data collected from buoy instruments are contained in two files labeled “primary” and secondary.” Header information for these files can be found in the respective tabs in the Excel spreadsheet under Attachments.

17 WIND ENERGY↗