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 199 records · Page 11

U.S. Average Nitrogen Fertilizer Production Baseline Documentation For 45Q Life Cycle Analysis: Version 1.0 (2018-2022)

U.S. Average Benchmark life cycle inventory documentation for nitrogenous fertilizer production for calendar years 2018 - 2022. The documentation includes a technical report describing data sources and statistical methods used and an Excel file showing calculations. The calculations performed are used in the 45Q benchmark json-ld dataset, compatible with the NETL CO2U LCA Guidance Toolkit. Summary impact results will be included in the NETL CO2U LCA Documentation Spreadsheet within the Toolkit. https://www.netl.doe.gov/energy-analysis/details?id=7c0db05a-231e-40a5-b5fd-112a7c001834

09 BIOMASS FUELS↗

OPTOM: Optimization of Parabolic Trough - Operations & Maintenance

The US Department of Energy’s SunShot goals look to reduce the cost of Concentrating Solar Power (CSP) technology to 5¢/kWh for baseload plants. This is about a 50% reduction from current costs. To achieve this cost target, a significant reduction in operation and maintenance (O&M) costs of 40 to 50% is likely needed. Advances are needed in the O&M practices of CSP plants if the technology is to achieve the SunShot cost goals. Digitization of plant performance and O&M data has become a new best practice in the world of renewable energy asset management. Owners and operators of large photovoltaic and wind power plants are working to digitize performance and O&M data at their existing assets, to improve their management of the facilities, to increase performance, reduce O&M costs, and lower the overall life cycle cost of ownership. CSP power plants are behind the curve of other technologies on the digitization of plant information to aid in the plant asset management. This project directly addresses the objective of digitizing the O&M data of the solar field, focusing on three areas: 1) creating a framework for sharing data and information, 2) creating a system for monitoring and managing the maintenance of the solar field collectors, and 3) developing analytic tools to identify issues in the solar field. According to the NREL CSP Best Practices Study, the current practice at many CSP plants is to rely on paper lists, spreadsheets, and email for monitoring and managing problems and maintenance in the solar field. The key element to digitize solar field O&M is the creation of a centralized data archive that all users and systems can interface with. This project developed a centralized relational database framework that allows users and applications to access and share data. Conventional power plants utilize Computerized Maintenance Management Systems (CMMSs) to track the corrective, preventive (scheduled), and predictive maintenance of equipment and subsystems in the power plant. CSP plants use these systems in the power block, but while these systems specialize at tracking maintenance on up to thousands of pieces of equipment, they are not well suited for tracking the tens or hundreds of thousands of components in large commercial CSP or photovoltaic solar fields. In this project we developed a new software application referred to as FieldStatus (TM). This is a specialized database program that is used to track the status of each collector and its components. This application is designed to complement the existing CMMS to enable improved tracking and management of maintenance activities in the solar field. One of the major maintenance tasks for solar fields is maintaining the cleanliness of the mirrors. Although seemingly a relatively straight forward task, it has often proven challenging to maintain high levels of cleanliness in an efficient and cost-effective manner. This project developed new tools and metrics for monitoring and optimizing solar field cleaning resources and overall solar field cleanliness.

14 SOLAR ENERGY↗

ICBM Transition Tool

The ICBM Transition Tool is an interactive, spreadsheet-based tool for exploring scenarios involving the planned transition of the Intercontinental Ballistic Missile (ICBM) force from the Minute Man III (MMIII) to the Sentinel missile, including the refurbishment of missile silos. The transition includes the fielding of the W87-1 warhead, retirement of the W78 warhead, and impacts to the availability of components for reuse.

45 MILITARY TECHNOLOGY, WEAPONRY, AND NATIONAL DEF↗

Surveillance Workload Divinator (SWORD)

The LANL Surveillance Workload Divinator (SWORD) is a high-level decision support tool that reproduces and predicts the annual values for stockpile and production disassembly and inspections (D&I) and rebuilds. SWORD, a spreadsheet-based tool, can be used to assess the surveillance workload under various planning scenarios. Results are shown graphically and updated dynamically for each weapon system or for the entire stockpile. Surveillance workload is calculated from stockpile surveillance guidance1 and from Production and Planning Directive (P&PD) data.

45 MILITARY TECHNOLOGY, WEAPONRY, AND NATIONAL DEF↗

AMPP-4 Tank Tracking Tools

The Material Recovery & Recycle group (AMPP-4) Tank Tracking Tools are Microsoft Excel-based tools used to visualize the liquid levels in the tanks used by teams within AMPP-4. The tools rely on reports generated by the Tracking Hydrogen Accumulation in Aqueous Operations spreadsheet to provide daily data of the volume occupied by radioactive liquid waste (RLW). This set-up allows for rapid-response in viewing historical (from October 2024) and current data in thermometer-type charts.

97 MATHEMATICS AND COMPUTING↗

ORNL Package Testing Program Software Quality Assurance Plan

The Oak Ridge National Laboratory (ORNL) Package Testing Program (PTP) uses commercial off-the-shelf (COTS) software in performing data collection of thermal test results for package designs that contain radioactive materials. Specifically, this software is used to collect temperature data from the furnace, packages, and ambient air to prepare and execute the thermal test specified in 10 CFR 71.73, “Thermal Test.” This software quality assurance (SQA) plan sets forth the guidelines, standards, and procedures that shall be used to provide SQA for PTP software applications. This is a living document that will be maintained for the lifecycle of the PTP program. The SQA plan follows the requirements set forth in ORNL Standards Based Management System (SBMS): Information Technology; Subject Area: Software Quality Assurance. When applicable to the requirements as described in ORNL SBMS, Software Quality Assurance, the software shall be listed in the ORNL Software Registration System (SRS). Exemptions to this SBMS are COTS and firmware that are not modified; spreadsheet applications and personal productivity tools that do not have a utility or safety application, research applications, legacy software, system software, vendor-supplied software used to interface with the vendor’s services, software used within the organization to facilitate processing or management of information, and software developed for applications not specific to the US Department of Energy (DOE).

97 MATHEMATICS AND COMPUTING↗

A simplified approach for creep damage and remaining life calculation for materials surveillance in advanced reactors

High temperature reactor materials will experience a combination of mechanical degradation caused by creep and fatigue and environmental degradation caused by neutron irradiation and, in some cases, exposure to corrosive coolants. A materials surveillance program is one option for ensuring the safe, reliable operation of key reactor components under these conditions. Such a program would monitor the degradation in key material properties over time, using this data to predict how changes in the material properties affect components performance. This could then be used to make plant operational decisions and support eventual plant license extensions. Past work de-scribes such a material surveillance program based on passively actuated mechanical test articles that impose creep-fatigue type loading on test materials driven only by changes in temperature, for example those experienced by components under standard operating cycles. This report focuses on two aspects of the proposed material surveillance program: how to design the test articles to mimic the mechanical response of the corresponding component and how to use ex-situ test data to deter-mine the amount of damaged experienced by the test article (and hence the corresponding compo-nent) in service. Specifically, this report derives and validated simplified methods for both tasks, replacing earlier, more complicated approaches based on simulating the test article response and finding the best specimen design or current damage via complex numerical optimization. The sim-plified methods for each task developed here can be implemented in spreadsheet software and are simple enough for practical use in future operating plants. This report derives the methods (one for sizing and two options for damage inference), verifies the simplified approaches versus more so-phisticated methods, and compares the results of applying the simplified methods to previous re-sults using the complex numerical optimization approach. The report also provides a worked sam-pled problem applying the simplified techniques to a realistic high temperature reactor component.

22 GENERAL STUDIES OF NUCLEAR REACTORS↗

High-Temperature Active Magnetic Bearing Development for Supercritical CO 2 Machinery Applications

Hermetic machinery utilizing gas bearings for MW-scale supercritical CO 2 (sCO 2 ) machinery applications can have significantly lower power loss and enable improved cycle efficiency compared to conventional machinery with oil-lubricated bearings. Active magnetic bearings (AMBs) are another option anticipated to have similar power loss and load capacity to gas bearings as well as offering larger mechanical tolerances, the ability to tune properties, and high reliability due to lack of mechanical wear. AMBs also have proven commercial experience at MW-scale, though environments for high-temperature sCO 2 power cycle machinery conditions are novel. Besides the potential impact of AMBs for sCO 2 turbomachinery, the technology also offers promising benefits for steam and gas turbines for power generation, compressors and expanders for industrial heat and power, and in other oil and gas and space applications. The goals of this project were to conceptual design an AMB and perform material testing. Conceptual designs for radial and thrust AMBs were produced based on a hermetically-sealed sCO 2 machinery waste-heat recovery (WHR) application for sizing and loads, and choosing a target design temperature of 540°C useful for high-temperature sCO 2 turbines for concentrating solar power (CSP) applications. Conceptual designs were initially developed for multiple radial and thrust AMBs with spreadsheet-based calculations before selecting one of each to develop further using higher-fidelity design methods for magnetic and structural performance. It was found that the radial AMB at 540°C was feasible, but the thrust AMB needed to be limited to 315°C for high-speed operation. The decision for a reduced-temperature thrust AMB was the result of several significant conclusions: 1) Hiperco 50A, originally chosen for good magnetic performance at high temperature, had insufficient strength for high-speed operation, so it was replaced with 17-4 PH. 2) The reduced magnetic performance from 17-4 PH yielded a larger bearing size, reducing the strength margin. 3) This ultimately led to a creative design implementing a more-compact E-core topology, compared to the original (conventional) C-core, and an integral shaft-disk with Hirth joint connection. These conceptual designs are unique for the size and temperature in CO 2 , relevant for MW-scale CSP applications. Long term, high temperature test data was generated for several materials, filling a void in the current body of literature. Corrosion and magnetic performance measurements were produced for PM materials (Alnico 5-7C, Alnico 9C, and SmCo) with and without nickel-coating for environments of high-temperature CO 2 up to 550°C at atmospheric pressure and 450°C at 103 bar for up to 6,000 hours. Corrosion measurements were also produced for Hiperco 50, a SM material relevant for AMB laminations, with and without C5 coating. Comparisons were also made for 450°C and 550°C, atmospheric pressure air exposures up to 5,000 hours. Results generally show that coatings can be effective at improving oxidation resistance of the bare materials, and Alnicos generally outperformed SmCo after high-temperature exposure. In addition to technical feasibility demonstrated by the design, economic feasibility was demonstrated by updating the TEA from the reference machine, re-evaluating it with CAPEX and OPEX to reflect estimated changes from process-lubricated bearings to AMBs. AMBs were shown to be comparable in performance to process-lubricated bearings, still showing a notable improvement over conventional machinery architecture with oil-lubricated bearings.

42 ENGINEERING↗

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↗

Stakeholder Questionnaire on Fish Passage Facilities at U.S. Hydropower Developments

To mitigate the environmental impacts of hydropower dams on fish populations in rivers, fish passage infrastructure may be required by regulatory authorities or recommended by state or federal agencies to allow migratory fish to pass hydropower barriers and complete their life histories. However, information on the location, types, and characteristics of fish passage infrastructure is incomplete at the national scale. This lack of information limits understanding of current fish passage capabilities and hinders efforts to anticipate future passage requirements during project licensing or relicensing. To address this knowledge gap, researchers at Oak Ridge National Laboratory partnered with federal agency and industry stakeholders to create the first national-scale database of fish passage infrastructure at U.S. hydropower developments. As part of this effort, a stakeholder questionnaire was created and deployed to solicit information on fish passage infrastructure, including engineering characteristics, operational schedules, targeted species, and costs. This online questionnaire was designed to allow respondents to provide highly detailed information regarding fish passage capabilities at U.S. hydropower developments as efficiently as possible. The questionnaire improved database coverage and accuracy by providing valuable development- or passage-specific stakeholder knowledge that is not otherwise publicly available. However, questionnaire response rates were low, and stakeholders showed a preference for providing data via the spreadsheet template. This is likely because most stakeholders had high-level knowledge about fish passage existence and type at many features, and few stakeholders had highly detailed, feature-specific knowledge of fish passage infrastructure, cost, operational scheduling, and capabilities. Nonetheless, the development and deployment of the stakeholder questionnaire advanced the project in several fundamental ways, and a similar questionnaire may be valuable for future database expansion via targeted dissemination to stakeholders with confirmed knowledge of detailed fish passage information at specific hydropower projects.

13 HYDRO ENERGY↗

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↗

Gas-Gap Calorimeter Sizing and Rating Tools for Heat Pipe Experimentation

Effective gas-gap calorimeter sizing and rating tools are required to design calorimeters that enable well-defined operating conditions, high cooling powers, and accurate calorimetry. The present report describes two tools utilizing Microsoft Excel and MathWorks MATLAB that enable the sizing and rating of gas-gap calorimeters with a He-Ar binary gas mixture in the gap. The Excel tools are two easy-to-use spreadsheets for calculating heat pipe operating temperature or He-Ar mole fractions given the required inputs. The MATLAB tool includes similar models with more robust solution algorithms along with sub-options for full-vacuum, static gas-gap, and forced circulation in the gas-gap. The accuracy of the developed tools were demonstrated by comparing with existing work in literature. The MATLAB tool was used for a parametric study to determine the gas-gap thickness, coolant gap thickness, coolant flow rate, and coolant inlet temperatures for the testing of a 3/4 in outer diameter heat pipe up to powers of 10 kW and temperatures of 1,000°C. The effects of heat pipe and calorimeter inner shell surface emissivities were investigated, considering the inability to control or accurately measure surface emissivities in most applications. It was found that controlling the He-Ar mole fractions provides a wide operating range for gas-gap thicknesses around ~ 0.042--0.090 in (~ 1.07--2.29 mm) for a surface emissivity range of 0.4--0.8, since conduction heat transfer is a significant fraction of the heat transfer across the gas-gap. In addition, it was found that turbulent flow in the coolant gap is needed at high input powers to prevent shell temperatures from approaching the boiling temperature of the water coolant. The parametric study resulted in choosing stainless steel tubes with an outer diameter and thickness of 1 x 0.065 in as the inner shell, and a 1-1/2 x 0.156 in as the outer shell of the calorimeter. Overall, this report presents the necessary information for the sizing and rating of gas-gap calorimeters with He-Ar mixtures for the testing of high-temperature heat pipes (~ 500--1,000°C).

22 - GENERAL STUDIES OF NUCLEAR REACTORS↗

GHG Emissions Inventory Report for LvivTeploEnergo (LTE)

PNNL prepared the greenhouse gas (GHG) emissions inventory for LTE to help gain international funding for modernization requirements necessary to decarbonize LTE’s DH network. The inventory itself provides a comprehensive account of total greenhouse gas emissions from (a) LTE’s transportation (commuting and product transport), (b) purchased electricity (for water heating, heat production, and other uses), and (c) heat production for the DH network. The greenhouse gases analyzed in the inventory are Carbon Dioxide (CO 2 ), Carbon Monoxide (CO), and Nitrogen Oxide (NO x ). All data gathered for the inventory came directly from previous years of LTE data, with total emissions of each activity calculated by using emission factors from several internationally reputable sources (e.g., United National Framework Convention on Climate Change (UNFCCC), the ECLIPSE v6 dataset from the International Institute for Applied Systems Analysis (IIASA), the European Modeling and Evaluation Programme (EMEP), and the World Resources Institute (WRI)). This report further explains the methodology and justification for which scopes of emissions were included in the GHG emissions inventory spreadsheet and a description of references from which the emission factors were taken.

32 ENERGY CONSERVATION, CONSUMPTION, AND UTILIZATI↗

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↗

Thermal Tolerance Metrics for Freshwater Fish, CONUS, Version 1

This dataset is a compilation of 13 thermal response metrics for 834 freshwater fish species across the conterminous United States (CONUS). The data were extracted from six published sources, many of which are compilations of data from other sources. The data were harmonized for comparison, and additional variables were added to summarize the metrics. The dataset is presented as a spreadsheet containing 17 sheets. The first sheet (datasets) describes the data sources. Other sheets describe the source and compilation variables in detail.

13 HYDRO ENERGY↗

Bowtie Manufacturing Images, Round 1&2

This dataset contains over 3,600 image files of images of a semiconductor manufactured part called 'Bowtie'. The data is grouped into 'accept' and 'reject' but does not contain masks for why the inspector rejected a part. There are further groupings such as different zoom magnifications, types of rejection (e.g. gouge, debris, etc.). Some of the parts have been laminated and are organized as such. For the 2nd round of data also included are Excel spreadsheets which can be used to identify position on the wafer where the images came from. The included PDF has example images and explains this in more detail.

97 MATHEMATICS AND COMPUTING↗