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 73 records · Page 4

TEAMER: Performance mapping of Re Vision's Persistance PTO

Contains datasets from experimental measurements that were used to validate Re Vision's Persistence PTO's efficiency and performance. These measurements were obtained using a dynamometer test bench setup. The data includes open-circuit voltage and loss measurements to validate machine characteristics, efficiency mapping tests to determine the generator's performance mapping, and efficiency mapping tests to determine the converter's efficiency over the feasible operating range. This data was collected between June 2023 and September 2023. The data was collected at the National Renewable Energy Laboratory's Flatirons Campus, Colorado, United States. The data was collected using NREL's 5-kW dynamometer test bench, equipped with a torque sensor and various voltage and current sensors fed to a dedicated data acquisition system. Units for the data are included in the data file headers for each data series. A text editor or spreadsheet software such as Excel is required to view the *.csv data. The data are also provided in *.mat files. To view data plots, a Matlab script with *.mat files are provided.

16 TIDAL AND WAVE POWER↗

Groundwater elevation data for monitoring wells within the East and Taylor River basins, Colorado (USA)

This dataset is comprised of temporal variations in groundwater elevation data for the 24 monitoring wells located throughout the East River watershed. Seasonal to annual variations in groundwater elevations are a critical property of mountainous watersheds needed to understand both hydrological and below ground biogeochemical processes. Such data serve as a critical constraint for numerical models describing coupled groundwater-surface water behavior within the watershed. Additionally, the offset between the maximum and minimum groundwater elevations defines the extent of the bedrock weathering zone, with annual excursions in the groundwater hydrographic (i.e., the rising and falling hydrographic limbs) imposing primary controls on bedrock saturation state and redox conditions that govern biogeochemical reactions impacting nitrogen, carbon, and metals cycling. Manufacturer-specific software is used to download pressure data from each transducer, with broadly available spreadsheet software (e.g. Microsoft Excel) used to convert temporal variations in water pressure to elevations in units of meters above mean sea level. As additional monitoring wells are installed within the East River watershed and new groundwater monitoring wells are installed in the Taylor River watershed, temporal groundwater elevation data will be included as a part of this master dataset. Details regarding the metadata associated with each monitoring well location, including well depths, screened intervals, well location coordinates, and bedrock type, are included, as is a standard operating procedure for generating groundwater elevation data from water pressure values recorded by the pressure transducers. This dataset includes: (1) a zip file (East_River_Watershed_Compiled_Groundwater_Elevation_Data_Plots.zip), containing (a) PNG of groundwater hydrographs, (b) a CSV file with groundwater elevation data, and (c) CSV file containing metadata organized by location; (2) an Excel file (East_River_Watershed_Compiled_Groundwater_Elevation_Data_Plots.xlsx) with the groundwater elevation data, groundwater hydrographs, and metadata organized by location; (3) a Word file (Groundwater_elevation_data_protocols.docx) and a PDF file version (Groundwater_elevation_data_protocols.pdf) containing field protocols and methods; (4) a location metadata (locations.csv) file; (5) a file level metadata (flmd.csv); and (6) data dictionary (dd.csv) file.This work was supported by the Watershed Function Science Focus Area at Lawrence Berkeley National Laboratory funded by the US Department of Energy, Office of Science, Biological and Environmental Research under Contract No. DE-AC02-05CH11231.

54 ENVIRONMENTAL SCIENCES↗

Evapotranspiration partitioning estimates from 8 methods from 47 NEON sites, 2019-2021

This dataset provides daily estimates of evapotranspiration (ET) and the transpiration-to-evapotranspiration ratio (T/ET) across 47 terrestrial National Ecological Observatory Network (NEON) sites spanning diverse environmental and biome conditions in the United States across three years of data (2019-2021). Daily ET is reported in both energy units (MJ m⁻² day⁻¹) and equivalent water depth (mm day⁻¹), assuming a constant latent heat of vaporization of 2.45 MJ/kg. The primary method uses a hybrid recurrent neural network–Penman–Monteith framework (RNN-PM), which integrates physically based surface energy balance constraints with data-driven learning to partition ET into transpiration and evaporation components. Model inputs include in situ meteorological observations (air temperature, vapor pressure deficit, wind speed, and radiation) combined with satellite-derived land surface temperature, leaf area index, and soil moisture. For benchmarking and uncertainty assessment, T/ET estimates from seven additional models are included: Priestley-Taylor Jet Propulsion Laboratory (PT-JPL), Penman-Monteith (P-M), Two-Source Energy Balance (TSEB), Support Vector Regression (SVR), and Categorical Boosting (CatBoost), among others—spanning empirical, machine-learning, and process-based approaches (see methods section or linked publication for detailed descriptions). Data Package Contents: The dataset a csv files containing daily ET and T/ET estimates for each site and model, along with associated metadata files these variables. Data can be accessed using common spreadsheet software (e.g., Microsoft Excel, LibreOffice) or programming environments such as R or Python. Together, these data support cross-site comparisons of ecosystem water use, evaluation of ET partitioning methods, and development of improved land–atmosphere exchange models.

EARTH SCIENCE > ATMOSPHERE↗

Transient Data Library of Solar Grid Integrated Distributed System

This submission contains an open-source library of transient events in distributed system with high solar PV. The library includes the collected data, related documents and scripts for loading the data. The data library is built for transient event detection and machine learning based analysis algorithm development. The data was collected via both field test and software simulation. The units for the data are included in the data file headers for each data series. A text editor or spreadsheet software, such as Excel, and Matlab is required to view the data.

algorithms↗

Pilot-Scale Testing of an Integrated Circuit for the Extraction of Rare Earth Minerals and Elements from Coal and Coal Byproducts Using Advanced Separation Technologies

The primary objective of this project was to develop and demonstrate an integrated pilot-scale circuitry for recovering high-value rare earth elements (REEs) from coal and coal byproducts. The target performance was to produce a mixed REE product with content of at least two percent by weight on a dry mass basis in a cost-effective and environmentally benign manner. During the first nine months of the project period (Phase 2 Budget Period 2), pilot plant construction was completed including all field site startup activities such as permitting, engineering design, procurement/bidding, unit fabrication, site construction, equipment installation, module assembly, safety training, and circuit shakedown. During the remaining 21 months of project period (Phase 2 Budget Period 3), detailed field-testing activities were performed including feedstock sample collection and preparation, exploratory testing, circuit modification, detailed parametric study, and performance optimization. A detailed techno-economic analysis was performed based on the pilot plant testing findings which provided various scenarios for REE production. The project successfully accomplished the proposed target performance by producing mixed rare earth oxide (REO) with greater than 90% purity by weight in a continuous pilot scale operation from two distinctly different coarse refuse materials (i.e., West Kentucky No. 13 and Fire Clay coal seams), and at least three secondary sources (i.e., heap leach process and naturally formed acid mine drainage system). Project partners included the University of Kentucky, Virginia Tech, West Virginia University, Alliance Coal, Blackhawk Mining, Mineral Refining Company, and Mineral Separation Technologies. The pilot scale test facility was constructed at a former mining complex owned by Alliance Natural Resource Partners (Alliance Coal). The site was rehabilitated to accommodate the equipment installation, construction and fabrication, electrical power requirement, water line management and containment. The process units constructed and installed included X-ray sorting unit, crushing and grinding unit, physical separation unit, acid leaching unit, solvent extraction unit, and wastewater management unit. A rare earth mineral concentration unit was constructed as a standalone unit for flexible operation. A detailed environmental assessment and control plan was carried out to identify and quantify any potential impacts of the pilot-scale processing circuitry on the human and eco-system health and well-being. Corresponding mitigation strategies and control measures were provided. A conceptual flowsheet was developed to effectively remove thorium and uranium from high purity rare earth oxide mix or any potential radionuclide enriched stream. The two distinct feedstock materials were secured from the Blackhawk Mining Complex in eastern Kentucky where the Fire Clay (Hazard No. 4) seam is processed. The West Kentucky No. 13 (Baker) coarse refuse material was collected from an active process stream at an Alliance coal preparation plant located in western Kentucky. Characterization analysis indicated that both of feed materials generated from the two sources contained >300 ppm of TREEs on a dry whole mass basis which met the requirements for a qualified feed stock. The two feedstocks were further upgraded using a dual x-ray sorter to prepare the feed material for hydrometallurgical circuit. Thermal treatment on feed material prior to leaching was found to: 1) improve the leaching recovery of REEs, 2) increase the leaching kinetics, and 3) allow the leaching reaction to occur at lower acidity. Roasting at 600°C was selected as the pre-treatment condition for both West Kentucky No. 13 and Fire Clay coarse refuse material. Over 40% of leaching recovery was achieved by roasting West Kentucky No. 13 material having a top particle size of 3 mm in the pilot scale operation using 1.2M sulfuric acid leaching at 75OC. Initial pilot scale testing involved continuous operation of the pilot plant for 94 hours. The leaching unit was operated at solid-to-liquid ratio of 1 to 10 (w/v) using 0.5M sulfuric acid solution at a temperature of 75°C. The continuous solvent extraction circuit utilized rougher and cleaner units with DEHPA and TBP as the extractants. An innovative stripping circuit was developed to accumulate the REE concentration in the stripping solution to a level above 600 ppm. A bleed stream from the recycled strip solution was treated using oxalic acid precipitation which produced a high grade rare earth oxalate. The oxalate product was roasted to remove the oxalate which produced a rare earth oxide product having a purity greater 90%. Due to high concentrations of contaminant ions in the pregnant leach solution (PLS), a modified flowsheet was developed that involved pre-concentration of the REEs using multiple stages of precipitation and redissolution. The advantage of this process was improved removal of contamination before the downstream purification process and a significant cost reduction relative to the circuit that utilized the solvent extraction process. The modified circuitry included processes involving leaching, multistage precipitation, redissolution, and oxalate precipitation followed by roasting of the oxalate product. The circuit produced a mixed REO that was 92.96% pure from the initial test. A detailed parametric test plan was carried out which involved varying key parameters including solids feed rate, acid flowrate, acid concentration, multistage precipitation pH, redissolution pH, oxalate precipitation dosage and pH. The response variables included REE recovery, contaminant recovery, REO product grade and overall chemical consumption. Test results indicated that the acid-to-solid ratio is the key parameter to leaching efficiency as performance deteriorated with an increase in solids concentration. The optimal pH determined for REE precipitation and redissolution was 6.5 and 2.5, respectively. Additional tests were conducted to further improve the flowsheet. Recirculating a portion of the PLS to the feed of the leach tanks improved the leaching performance by lowering the pH of the leaching system and reducing the contamination recovery by shortening the residence time. Moreover, the removal of Al prior to REE precipitation significantly reduced the oxalic acid consumption in the oxalate precipitation circuit. The modified circuit produced over 90% grade REO by weight from both West Kentucky No. 13 and Fire Clay coarse refuse material in pilot scale continuous test programs. A case analysis model was developed to project the REE and major contaminants concentration in each PLS stream based on the leaching condition, pH cut point, and oxalic acid dosage. A correlation was established using empirical and semi-empirical models. Using the models, chemical consumption required for each stage was predicted based on the projected performance of the hydrometallurgy circuit. After identifying the optimum conditions, validation tests were carried out for the treatment of both West Kentucky No. 13 and Fire Clay coarse refuse materials in the pilot plant. The actual circuit performance and chemical consumptions were very close to the model predictions. Other than the two coarse refuse sources, several secondary feedstocks were also tested in the pilot plant facility. A “heap leach” system was constructed using the coarse refuse material generated from cleaning the West Kentucky No. 13 seam coal. Using the two stage SX rougher and cleaner circuit, a concentrate with a grade >90% REO was produced while recovering >97% of the REEs from the heap leach PLS. Naturally generated acid mine drainage (AMD) from West Kentucky No.13 mine was processed using the multistage precipitation circuit in the pilot plant in a test conducted for a period of 32 hours. The final grade of the mix RE oxide produced from the AMD was 90.84% with an overall circuit recovery of 64%. The primary source of REE was the selective precipitation steps involving iron and aluminum rejection. The hydrophobic-hydrophilic separation (HHS) process was proven to effectively recover coal from fine waste materials. For REM recovery, the HHS process was able to produce concentrates at grades of approximately 1.8% REE on an ash basis; however, recovery values were typically low, <10%, under the optimal conditions determined in the laboratory-scale testing. Staged testing of the pilot-scale HHS process for coal recovery and semi-continuous laboratory testing for REM testing showed that a total concentration ratio of more than 15x was observed for the REM recovery process. A circuit simulation package was developed for REE extraction and purification using a spreadsheet-based platform (Microsoft Excel). The REESim circuit simulation package is configured to track the mass and volume flows of components passing through a series of unit operations specified and configured by the user. The mass rates can then be utilized by the user to determine important performance indicators such as product mass yields, concentrate purity levels, element-by-element recoveries, and so forth. The techno-economic analysis showed that the roasting and leaching operations were the most expensive capital items, each contributing approximately 30% to the total capital cost. One notable contributor to the high production costs was the low REE recovery observed in the pilot scale trials. The product basket price was shown to have a strong influence on the economic viability of the scenarios, with the scandium price being the most significant influencer. Operating cost was shown to be extremely sensitive to REE recovery, REE feed grade, and leaching acid consumption. An analysis of ten different scenarios for a 500 t/h commercial operation revealed that three were economically favorable, producing internal rates of return varying from 27.7% to 33.1% and payback periods of 4 to 5 years. The project successfully developed and demonstrated a process to recover REEs from coal and coal byproducts in a pilot-plant operation which consistently produced over 90% grade REO mix from varies types of feedstocks. Commercialization analysis showed that the technology readiness level successfully achieved TRL 6 at the end of the project and demonstrated the need and the potential for scaling the process to further advance the technologies toward the goal of providing a domestic supply of REEs at a commercial scale.

01 COAL, LIGNITE, AND PEAT↗

Soil Temperature Sensor Data, May - December 2024, Five sites in Knoxville, Tennessee

This dataset contains surface soil temperature measurements from five urban parks in Knoxville: Cumberland Estates Park (CE), Socially Equal Energy Efficient Development (SD), West View Park (WV), Victor Ashe Park (VA), and West Hills Park (WH). The dataset comprises 29 Excel (.xlsx) and Comma-Separated Values (.csv) files documenting soil temperature recorded by six HOBO Pendant MX Water Temperature Data Loggers at each site, except for CE, which has five sensors. Each logger was installed at a depth of 10 inches and positioned approximately 3 to 6 feet from the weather station at each site. To open both csv and xlsx files, users can utilize spreadsheet applications such as Microsoft Excel, Google Sheets, LibreOffice Calc, and Apple Numbers. This dataset is part of a broader study examining the effects of soil moisture and plant evapotranspiration on ambient temperature and relative humidity across multiple urban parks in Knoxville, Tennessee.

EARTH SCIENCE > LAND SURFACE > SOILS↗

Riverbed and Near-Surface Water Quality Data, Hanford Reach, Columbia River, February 2021 - April 2022

This dataset contains longitudinal profiles of natural groundwater tracers (temperature, electrical conductivity (EC), and Radon-222 (Rn)) collected to identify locations of hydrologic exchange flows along a 75-km reach of the Columbia River near Richland, Washington.A jetboat was used to tow a 30 foot long, weighted tether that had one set of temperature and EC sensors just below the water surface and one set of temperature and EC sensors on the end (just above the river bed). The dataset contains profiles of temperature/EC data (resolution: 1 second) collected along the left and right banks during three different sampling events. During the final sampling event, we revisited some "deep holes" where the river was more than 30 feet deep with a weighted tether that was 75 feet long. The dataset has been processed to remove data collected when the sensors were not in the water, or when the water was too deep to keep the tether on the riverbed. We collected grab samples of water for analysis of dissolved Rn in places where the temperature/EC was different from the background river water. The Rn data was joined to the temperature/EC profiles based on the sample times.This dataset is comprised of one main data folder containing (1) file-level metadata; (2) data dictionary; (3) installation methods; (4) February 2021 data; (5) July 2021 data; (6) April 2022 data; and (7) April 2022 deep hole data. All files are .csv format and can be opened with a spreadsheet program (such as Microsoft Excel or OpenOffice).

54 ENVIRONMENTAL SCIENCES↗

Processed Soil Respiration at the TRACE experimental Warming project, Aug 2015 - Sep 2017, Sabana, Luquillo, Puerto Rico

This data package contains processed measurements of soil carbon dioxide (CO₂) efflux collected using LI-COR LI-8100 soil respiration chambers at the Tropical Responses to Altered Climate Experiment (TRACE) located at the Sabana Field Research Station near Luquillo, Puerto Rico. The TRACE site is a mature, closed-canopy tropical wet forest within the Luquillo Experimental Forest. These data quantify soil surface CO₂ fluxes from both ambient (control) and experimentally warmed plots to evaluate how long-term soil warming affects belowground carbon cycling in tropical ecosystems. The data files include time-series tables of CO₂ flux (µmol CO₂ m⁻² s⁻¹), soil temperature (°C), and ancillary environmental variables, stored in comma-separated values (CSV) format and viewable with any text editor, spreadsheet, or statistical software (e.g., R, Python, Excel). Associated metadata describe plot identifiers, measurement intervals, and processing steps. These data were generated to address the research question: How does sustained soil warming influence soil respiration and carbon flux dynamics in tropical wet forests?

54 ENVIRONMENTAL SCIENCES↗

Fungal mat growth and leaf colonization at the TRACE warming experiment, Mar - Aug 2024, Luquillo, Puerto Rico

This data package contains processed measurements on the growth of litter mat-forming fungi and the time to leaf colonization at the Tropical Responses to Altered Climate Experiment (TRACE). Located near the Sabana Field Research Station in Luquillo, Puerto Rico, the TRACE site is located in a mature, closed-canopy tropical rainforest within the Luquillo Experimental Forest (LEF). These data quantify fungal mat growth and the time to leaf colonization of fungi species Gymnopus johnstonii and Marasmius crinis-equi. The experiment was conducted in ambient (control) and experimentally warmed plots (4°C above ambient) during spring and summer periods to assess how litter mat-forming fungi respond to a range of environmental conditions of tropical wet forests. The data files include tables of relative fungal mat growth rates, time to leaf colonization, averages of soil temperature (°C), and number of dry days before leaf attachment. The data are stored in comma-separated values (CSV) format and viewable with any text editor, spreadsheet, or statistical software (e.g., R, Python, Excel). Associated metadata describe plot identifiers, measurement descriptions, and processing steps.

Agaric fungi↗

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↗

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↗

Datum: A Scientific Metadata Catalog

The data catalog market is currently flooded with a myriad of different products, but none serve the scientific community well. There are cloud-native tools like Databricks, Snowflake,to on-premise solutions like Collibra and Datahub. The common failing of all these tools however, is their inability to serve the scientific data community directly. Most catalogs are targeted towards financial, health, or user data - not sensor or scientific domain data. They also prioritize integrations that often don’t exist or are just starting to be used in the scientific realm - all while ignoring common scientific tools and file types. Datum is a catalog which targets the scientific data directly, including the tools and networks in which those tools are used. We work with the producers and consumers of the data where they are, targeting cloud and on-premise with a focus on classified networks. Datum is an Erlang/Elixir application. Technical Features Note: The features listed below are still under development and may change, slightly, upon final delivery of the product. File Formats - Datum has the ability to read additional metadata and provides processing pipelines for the following file formats: Plain Text, PDF, LaTeX, HTML, Open Document Format (.odt), XML, CSV/TSV (and other standard delimiters), OpenDocument Database and Spreadsheets, Geo-Referenced TIFF, Common Data Format, HDF/HDF5, LabView TDMS, Excel, DeltaTables, Parquet, Apache Iceberg, Apache Hudi and many others. Metadata Collection - Scanners for the local and networked file systems and cloud storage providers. Network integration with common databases such as MSSQL and MySQL. User Plugin System - Users are able to provide either file processing, metadata extraction, or sampling plugins in the programming language of their choice. Authentication/Authorization -: OIDC integration, SCIM provisioning and EntraID integration out of the box. Full user and group management system with a “least privilege” operating mode. Governance - Customizable data governance platform; dictate and enforce required metadata, enforce data embargos, and enforce user agreements and NDAs before data access. Ability to create health checks on data, rejecting abandoned or poorly curated data and automatically removing it from the search index. Ability for users to submit corrections. Search - Semantic search is a first class citizen. No licenses to expensive, external software required. Integrated use of vectors and vector-based search allows for AI agent integration at all levels of operation. Metadata Model - Display and control data’s lineage and connections to other data and data directories. Data is modeled after a filesystem - an organization instantly recognizable and navigable by most any user. CLI and SDK - Ships with a Command Line Interface (CLI) tool and with a fully-featured Python SDK. This allows for rapid and programmatic use of Datum by every level of user. Minimal Infrastructure - Datum ships as a single executable file and can be run on any operating system and most CPU architectures. Datum has no reliance on external databases, search indexing tools, or other outside services - and it runs equally well on edge computing devices, cloud services, or in a clustered HPC environment.

darrington, john↗

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↗

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↗

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↗

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↗

FECM/NETL Unconventional Shale Well Economic Model (UShWEM)

FECM/NETL Unconventional Shale Well Economic Model (UShWEM) is an Excel-based model that evaluates the economics of an unconventional shale well on a per-well and per-pad basis. The model calculates the net cash flow, internal rate of return (IRR), net present value (NPV), earnings before interest, taxes, depreciation, and amortization (EBITDA), payout month and year, and breakeven price (for either oil- or gas-wells). The model can be used to estimate the economics of a well or pad over its lifetime (development through site reclamation) based on (1) the capital and operating costs associated with well/pad development and operations, (2) the revenue associated with oil, gas, and condensate production streams, and (3) accounting for relevant tax policies and asset depreciation applicable for oil and gas operations. The main input for the model is the completion design and production data. Key financial considerations in the model include oil, gas, and condensate market prices, tax-related settings, royalty rates, the discount rate, minimum economic hurdle (IRR) [if performing break-even analysis], and project contingency. The financial consideration can be adjusted to reflect the level of granularity the user requires as input when calculating the economics for a well or pad development. In addition, the model affords users the option to provide their user inputs for all cost categories considered. As a result, the model can be used to generate a multitude of scenario cases for sensitivity analysis of the various financial considerations, as well as production and cost profiles. To make this seamless, the model has the capability for key economic outputs to be exported in large batches through macros-enabled functions on its “Model Output Summary” and “Multi-Well Cost Analysis. The spreadsheet model includes macros and user-defined functions, so the user must enable Excel’s macro capability for the model to function correctly.

Sheriff, Alana↗

2021 Annual Technology Baseline (ATB) Cost and Performance Data for Electricity Generation Technologies

Starting in 2015 NREL has presented the Annual Technology Baseline (ATB) in an Excel workbook that contains detailed cost and performance data, both current and projected, for renewable and conventional technologies. The workbook includes a spreadsheet for each technology. This version of the workbook provides the final updates to data for the 2021 ATB. In 2019 and 2020, NREL has also provided selected data in Tableau workbooks and structured summary csv files. The data for 2015 - 2020 is located on https://data.nrel.gov. In 2021 and going forward, the data is cloud optimized and provided in the OEDI data lake. A website documents this and future data at https://atb.nrel.gov.

Array↗