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 145 records · Page 8

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↗

PARETO 0.5.0 Release

PARETO 0.5.0 Release. Highlights: Treatment Center Modeling - New case study with desalination, clean brine, and evaporation treatment technologies - New option to reduce disposal capacity due to Seismic Response Areas (SRA) - New option to consider water sharing outside of system General Updates - New features for Sankey Diagram visualization (multiple regions, filtered time periods) - Introduce badges to README.md - Convert documentation to ASCII LaTeX - Code cleaning and maintenance - Correct strategic model documentation typo - Update and format treatment demo input spreadsheet Bug Fixes - Fix water quality operational model results printing bug - Piping and trucking variables are now built only over defined arcs instead of all possible connections - Revise pipeline expansion cost constraints, ensure that all pipelines built incur cost

PARETO,PARETO-UI,PSE,Process Systems Engineering,P↗

Pennsylvania Department of Environmental Protection (PA DEP) 26r Detailed Produced Water Compositions (version 1.0)

A database of geochemical compositions of aqueous species in produced water reported to the PA DEP. Samples were collected between mid-2012 to early-2020. Data from publicly-available PA DEP 26r reports were scraped from pdf files and cumulated into tabular spreadsheet format for >1000 produced water streams from Marcellus wells in Pennsylvania. In addition to providing the original values, the NETL NEWTS team has reformatted the dataset to allow sample streams to be easily copied into OLI Studio and Geochemist WorkBench (GWB) software for modeling the geochemistry and the recovery of critical minerals, such as lithium, from these produced water streams. In addition, a version of the dataset has been included with predictions for some missing values in the original dataset using machine learning techniques within CoDaRT software, a public ML software developed by the Nation Energy Technology Laboratory. We have made the Input into CoDaRT and one example output from CoDaRT available in this dataset.

Aqueous Chemistry↗

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↗

Pennsylvania Department of Environmental Protection (PA DEP) 26r Detailed Produced Water Compositions (version 2.0)

A database of geochemical compositions of aqueous species in produced water reported to the PA Department of Environmental Protection (PA DEP). Samples were collected between late-2010 to late-2024. Data from publicly available PA DEP 26r reports were scraped from pdf files and cumulated into tabular spreadsheet format for >3,000 produced water streams from Marcellus Shale wells in Pennsylvania. In addition to providing the original values, the NETL NEWTS team has reformatted the dataset to allow sample streams to be easily copied into OLI Studio and Geochemist WorkBench (GWB) software for modeling the geochemistry and the recovery of critical minerals, such as lithium, from these produced water streams. ***This dataset is an updated version of the PA DEP 26r Detailed Produced Water Compositions (version 1.0) dataset, providing expanded spatial and temporal coverage.***

Aqueous Chemistry↗

RETRO RX

RETRO Rx is an R&D 100 Gold Award-winning suite of tools that provides a new class of analytics in the space between traditional epidemiological models and unanalyzed spreadsheets of data. Unlike traditional models, these tools provide analysts, scientists, practitioners, and decision makers a way to easily and effectively do sophisticated analyses using a simple user interface. AIDO guides users at the early stages of a disease outbreak by comparing the current parameters to historic outbreaks. RED Alert constructs a broad historical picture of disease incidence (recent outbreak included) to detect disease reemergence at its earliest stages, locally and globally. RETRO Rx compiles data and presents analysis in a clear, concise visual format to support disease mitigation and prevention planning. Both are available currently as web-based apps. A prototype of the RED Alert mobile app with enhanced functionality is available for beta testing and AIDO mobile app development is planned.

59 BASIC BIOLOGICAL SCIENCES↗

Calculation of Moisture-Dependent, Anisotropic Parameters Supporting the Hanford Site's Composite Analysis, Cumulative Impact Evaluation, and Performance Assessments

Variable, moisture (tension) dependent anisotropy (MDA) in unsaturated soils is an effective, large-scale (macroscopic) flow property that results from media heterogeneities at a smaller scale. The purpose of this environmental calculation file (ECF) is to document the variable MDA calculations using a script routine. The accuracy of the script calculations are cross-checked against results using other software. Appendices for this ECF are Appendix A, which documents supporting script use; Appendix B, which provides supporting spreadsheet calculations; and Appendix C, which provides supporting utility calculations. The work is in support of vadose zone flow and transport models used in performance assessment (PA), composite analysis (CA), and cumulative impact evaluation (CIE) at the Hanford Site.

12 MANAGEMENT OF RADIOACTIVE AND NON-RADIOACTIVE W↗

Power Sector Transformation Pathways: Exploring Objectives, Factors, and Technology Innovations to Inform Power Sector Pathway Decisions

The power and heating sectors are responsible for around 30% of global CO2 emissions and this share is likely to grow as countries move towards electrification of the transportation and building sectors. Therefore, enabling forward-thinking, long term strategies in the power sector is a crucial area for international collaboration and support. The rapid transition of power systems toward modern, low-carbon pathways and technologies will be necessary to meet key climate goals while also enabling other critical objectives such as economic development, energy access, and energy system resiliency, among others. Many developed and developing countries are well-poised to champion power sector transformation (PST), however, further support is needed to identify pathways and implement critical near and long-term actions. To address this need, the Low Emission Development Strategies Global Partnership (LEDS GP) together with an expert team including Agora Energiewende, Energy Innovation, European Climate Foundation, Fraunhofer Institute for Systems and Innovation Research , Prayas Energy Group and LEDS Latin America and Caribbean Platform, developed a framework identifying four key pathways that can be integrated and combined to support low-carbon PST. These four pathways are: (1) Distributed Energy Resource Revolution, (2) Bulk Power Transformation, (3) Transmission and Distribution Interactivity, and (4) Distributed Transactional Future. To support exploration of pathways, this study examines PST objectives and factors that may lead countries or jurisdictions to place a greater relative emphasis on certain pathways as well as a framework and complementary tool for considering the emphasis in a hands on manner. The report provides case studies on application of the approach to bring life to the topic. The case studies include Haiti, Kenya, Mexico, Southeast Asia, and the European Union, among others. The report also presents actions to-be-taken in the near-, medium- and long-term to support the realization of pathways and long-term transformation of the power sector. The report, together with a complementary spreadsheet tool developed under the effort, can be used to enable stakeholder engagement and visioning for the power sector over the long-term, taking into account key factors and potential innovations. It can also be used to understand and inform relevant analysis tools and models based on which pathways are emphasized, and to identify key actions in the near- and medium-term to avoid lock-in of carbon-intensive technologies.

29 ENERGY PLANNING, POLICY, AND ECONOMY↗

Verification and Validation of the PLTEMP/ANL Code for Thermal-Hydraulic Analysis of Experimental and Test Reactors

The document compiles in a single volume the verification and validation works done for the PLTEMP/ANL code during the years of its development and improvement. The verification of sixteen capabilities of the PLTEMP/ANL Version 4.3 code that were identified by research reactor analysts as frequently used in their thermal-hydraulic analysis are described and documented. Each chapter of the document deals with the verification or validation of a specific model. The model verification is usually done by comparing the code with hand calculation, Microsoft spreadsheet calculation, or Mathematica calculation. The model validation is done by comparing the code with experimental data or a widely tested code like the RELAP5 code. In addition, some PLTEMP/ANL verification works that are available in the open literature are simply referenced and not included in the document. PLTEMP/ANL has been used in conversion safety analysis reports of several US and foreign research reactors that have been licensed and converted. A list of such reactors is given.

22 GENERAL STUDIES OF NUCLEAR REACTORS↗

Energy Consumption and Cost Reduction of Future Light-Duty Vehicles through Advanced Vehicle Technologies: A Modeling Simulation Study Through 2050

The U.S. Department of Energy’s (DOE’s) Vehicle Technologies Office (VTO) and Hydrogen and Fuel Cell Technologies Office (HFTO) aim to develop sustainable, affordable and efficient technologies for transportation of goods and people. Translating investments in advanced transportation component technologies and powertrains to estimate vehicle-level fuel savings potential is critical for understanding DOE’s impact. In this work, we simulated technologies funded by VTO and HFTO for light duty vehicles. The simulations were performed across: Multiple powertrain configurations (i.e., conventional, power-split, extended-range electric vehicle, battery electric drive, and fuel-cell vehicles), Vehicle classes (i.e., compact car, midsize car, small sport utility vehicle [SUV], midsize SUV, and pickup trucks); and Fuels (i.e., gasoline, diesel, hydrogen, and battery electricity). These various technologies are assessed for six different timeframes: laboratory years 2015, 2020, 2025, 2030, and 2045. A delay of 5 years is assumed between laboratory year and model year (year technology is introduced into production). Finally, uncertainties are included for both technology performance and cost aspects by considering two cases: Low case, aligned with DOE technology manager estimates of expected original equipment manufacturer (OEM) improvements based on regulations, business as usual; and High case, aligned with aggressive technology advancements based on R&D targets developed through support by VTO & HFTO. These scenarios are not intended as predictions of future performances. The energy and cost impact of different technologies were estimated using Autonomie (www.autonomie.net), Argonne vehicle system simulation tool. Autonomie is a state-of-the-art vehicle system simulation tool used to assess the energy consumption, performance and cost of multiple advanced vehicle technologies across classes (from light to heavy duty), powertrains (from conventional to HEVs, FCEVs, PHEVs and BEVs), components and control strategies. Autonomie is packaged with a complete set of vehicle models for a wide range of vehicle classes, powertrain configurations and component technologies, including vehicle level and component level controls. These controls were developed and calibrated using dynamometer test data. Autonomie has been used to support a wide range of studies including analyzing various component technologies, sizing powertrains components for different vehicle requirements, comparing the benefits of powertrain configurations, optimizing both heuristic and route based vehicle energy control and predicting transportation energy use when paired with a traffic modeling tool such as POLARIS. This report documents the assumptions and estimates the vehicle-level energy consumption benefits and associated technology costs for the various types of light duty vehicles. All details of vehicle assumptions and simulation results are available in the spreadsheets accompanying this report.

33 ADVANCED PROPULSION SYSTEMS↗

Model of Operation-and-Maintenance Costs for Photovoltaic Systems

This article presents a method for calculating costs associated with operation and maintenance (O&M) of photovoltaic (PV) systems. It compiles details regarding the cost and frequency of multiple O&M services to estimate annual O&M costs ($\$$/year) for each year of an analysis period, the net present value ($\$$) of life cycle costs accumulated over the analysis period, and the reserve account amount ($\$$). Here we show that this method is an improvement over the previous averaged or levelized per-unit ($\$$/kW/year) valuations for estimating PV O&M costs, because it allows a detailed selection of services to perform based on system size, market served (e.g., residential, commercial, or utility), type and configuration of system components (e.g., micro-, string or central inverter) and site and environmental conditions (e.g., snow, pollen, bird populations). This model also distinguishes costs that vary from year to year and increase at different rates over time because of heuristic failure distributions (e.g. Weibull or Lognormal distribution) based on actuarial data for many of the services. This cost model was created by the PV O&M Working Group of researchers and industry, sponsored by DOE Solar Energy Technologies Office, and has been published in an on-line version hosted by SunSpec Alliance at apsuite.sunspec.org. A spreadsheet version is included with this paper as supplementary material.

14 SOLAR ENERGY↗

Eight County Permian Basin Residual Oil Zone (ROZ) Database

This document describes the spreadsheet geologic database named ROZ_SanAnd_8.xlsm used in the report, ''An Eight-County Appraisal of the San Andres Residual Oil Zone (ROZ) 'Fairway' of the Permian Basin''. The dataset provides geologic properties for ROZ partitions in San Andres formation in eight counties in the Permian Basin. The geologic data is used to estimate total oil in place in each partition and provides the inputs needed to estimate the oil that can be produced and CO 2 stored from the application of CO 2 EOR to a partition. The database and the appraisal report are available on NETL's website under the Collection Name: Eight-County San Andres ROZ Appraisal.

02 PETROLEUM↗

Four County Permian Basin San Andres Residual Oil Zone (ROZ) Database

This document describes the spreadsheet geologic database named ROZ_SanAnd_4.xlsm used in the report ''A Four-County Appraisal of the San Andres Residual Oil Zone (ROZ) 'Fairway' of the Permian Basin''. The dataset provides geologic properties for ROZ partitions in San Andres formation in four counties in the Permian Basin. The geologic data is used to estimate total oil in place in each partition and provides the inputs needed to estimate the oil that can be produced and CO 2 stored from the application of CO 2 EOR to a partition. The database and the appraisal report are available on NETL's website under the Collection Name: Four-County San Andres ROZ Appraisal.

02 PETROLEUM↗

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↗

Wood-to-Fuel for California's Transportation Sector using Autothermal Pyrolysis: Kickoff Questionnaire for Benefits Analysis of CEC Projects

This is the first of three questionnaires that you will be asked to complete over the course of the agreement. Please type your responses directly into this document in the spaces below each question. Use as much space as you need; the form automatically creates more space within each response field. In addition, you may submit additional documents, spreadsheets, or other files. Acceptable filetypes are MS Word, MS Excel, and PDF. Additional files do not need to follow any particular format, unless specified by the particular questionnaire designed for your project.

96 KNOWLEDGE MANAGEMENT AND PRESERVATION↗

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↗

Verification and Validation of the PLTEMP/ANL Code for Thermal-Hydraulic Analysis of Experimental and Test Reactors (Code Version 4.3)

The document compiles in a single volume the verification and validation works done for the PLTEMP/ANL code during the years of its development and improvement. The verification of sixteen capabilities of the PLTEMP/ANL Version 4.3 code that were identified by research reactor analysts as frequently used in their thermal-hydraulic analysis are described and documented. Each chapter of the document deals with the verification or validation of a specific part of the software that calculates a specific phenomenon, e.g., channel flow calculation, coolant property calculation, heat transfer calculation, and flow instability calculation. The software verification work is usually done by comparing the code with hand calculation, Microsoft spreadsheet calculation, or Mathematica calculation. The software validation is done by comparing the code with experimental data or a widely tested code like the RELAP5 code. In addition, some PLTEMP/ANL verification works that are available in the open literature are simply referenced and not included in the document. PLTEMP/ANL has been used in conversion safety analysis reports of several US and foreign research reactors that have been licensed and converted. A list of such reactors is given.

22 GENERAL STUDIES OF NUCLEAR REACTORS↗

Puerto Rico Demand Response Impact and Forecast Tool (PR-DRIFT) - Beta Version [Slides]

Due to high fossil fuel imports, high electricity rates, an unreliable electricity grid, and 100% renewable electricity goals, demand response can play a crucial role for the Puerto Rico electricity grid. The Puerto Rico Demand Response Impact and Forecast Tool (PR-DRIFT) is a spreadsheet-based tool in which users can estimate the potential impacts of demand response, energy efficiency, and VRE and storage adoption in Puerto Rico from 2021 through 2040. The tool includes projections for solar, wind, and battery adoption based on released RFPs and energy targets (including Act-17 2019) to generate a projected net load profile for each hour through 2040. Based on user inputs and default assumptions, the tool also projects load profile impacts of demand response and energy efficiency, and is specifically focused on highlighting projected demand response technical potential. This demand response technical potential can be used by local utilities, regulators, program administrators, or researchers to help design demand response programs for larger impact.

24 POWER TRANSMISSION AND DISTRIBUTION↗