End-Use Analysis of ASHRAE Standard 90.1-2022
The end-use breakdown spreadsheet provides detailed end use data results from the Progress Indicator Analysis of ASHRAE Standard 90.1 conducted by PNNL
Nambiar, Chitra↗
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.
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↗
Closed Loop Pumped Storage Hydropower Resource Assessment of the United States
The data includes a geospatial and spreadsheet representation of a resource analysis for closed loop pumped storage systems across the Continental United States, Alaska, Hawaii, and Puerto Rico. The data includes energy storage potential, water volume, distance from source to storage, hydraulic head, dollars per kilowatt of storage, and transmission spurline cost for each pumped storage hydropower (PHS) reservoir. Each reservoir represented in this dataset is represented on potential 10 hour storage duration PSH system comprised of two reservoirs. Units of measure are laid out in the dataset. Pumped storage hydropower (PSH) represents the bulk of the United States' current energy storage capacity: 23 gigawatts (GW) of the 24 GW national total (Denholm et al. 2021). This capacity was largely built between 1960 and 1990. PSH is a mature and proven method of energy storage with competitive round-trip efficiency and long life spans. These qualities make PSH a very attractive potential solution to energy storage needs, particularly for longer-duration storage (8 hours or more); such storage will be crucial to bridge gaps in electricity production as variable wind and solar production continue to comprise an ever-larger portion of the United States' energy portfolio. This study seeks to better understand the technical potential for PSH development in the United States by developing a national-scale resource assessment for closed-loop PSH. For more information, please refer to the Closed Loop Pumped Storage Hydropower Resource Assessment for the United States linked in the resources.
Array↗
U.S. Wind Siting Regulation and Zoning Ordinances
A machine readable collection of documented wind siting ordinances at the state and local (e.g., county, township) level throughout the United States. The data were compiled from several sources including, DOE's Wind Exchange Ordinance Database (Linked in the submission), National Conference of State and Legislatures Wind Energy Siting (also linked in the submission), and scholarly legal articles. The citations for each ordinance are included in the spreadsheet. This data is an updated to a previously developed database of wind ordinances found in OEDI Submission 1932: "U.S. Wind Siting Regulation and Zoning Ordinances"
analysis↗
U.S. Solar Siting Regulation and Zoning Ordinances
A machine readable collection of documented solar siting ordinances at the state and local (e.g., county, township) level throughout the United States. The data were compiled based on a locality-by-locality review zoning ordinances after completing an initial review of scholarly legal articles. The citations for each ordinance are included in the spreadsheet.
Array↗
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↗
AquaPV: Foundational Analysis and Industry Guidance on Floating PV Results
This dataset contains results of the technical potential analysis of floating photovoltaics (FPV) on federally owned or permitted reservoirs in the United States. Estimates of the area of reservoirs that is technically feasible for FPV development are provided for reservoirs that are owned by the US Army Corps of Engineers or the US Bureau of Reclamation, or are associated with hydropower dams licensed by the Federal Energy Regulatory Commission. Other associated data are included, such as estimates of the potential evaporative losses of FPV development, and whether the waterbody is associated with an energy community or disadvantaged community that could qualify it for investment or production tax credits. Data is provided both as a spreadsheet and in a geospatial format including the waterbody geometries. Please read the included readme for more detailed field definitions.
area↗
U.S. Solar Siting Regulation and Zoning Ordinances (2025)
A machine readable collection of documented solar siting ordinances at the state and local (e.g., county, township) level throughout the United States. The data were compiled using the Infrastructure Continuous Ordinance Mapping for Planning and Siting Systems (INFRA-COMPASS) tool, which leverages Large Language Models (LLMs) to automate the collection of local codes and ordinances applicable to energy infrastructure. URLs for the ordinance source documents are included in the Solar Ordinances spreadsheet. The GeoPackage file included below contains the jurisdiction shapes for each ordinance. Note that the GeoPackage file is formatted for ingestion by NLR's reVX setbacks tool and therefore does not contain any of the state-level regulations. NOTE: This data was collected with the help of generative AI. The Large Language Models used for this effort make mistakes. Always validate the data for critical use cases. This data is an update to a previously developed database of wind ordinances found in OEDI Submission 5734: see the "U.S. Solar Siting Regulation and Zoning Ordinances 2022" link below. INFRA-COMPASS version used for collection: v0.11.3 LLMs used for collection: GPT-4.1, GPT-4.1 mini, GPT-4.1 nano
14 SOLAR ENERGY↗
U.S. Wind Siting Regulation and Zoning Ordinances (2025)
A machine readable collection of documented wind siting ordinances at the state and local (e.g., county, township) level throughout the United States. The data were compiled using the Infrastructure Continuous Ordinance Mapping for Planning and Siting Systems (INFRA-COMPASS) tool, which leverages Large Language Models (LLMs) to automate the collection of local codes and ordinances applicable to energy infrastructure. URLs for the ordinance source documents are included in the Wind Ordinances spreadsheet. The GeoPackage file included below contains the jurisdiction shapes for each ordinance. Note that the GeoPackage file is formatted for ingestion by NREL's reVX setbacks tool and therefore does not contain any of the state-level regulations. NOTE: This data was collected with the help of generative AI. The Large Language Models used for this effort make mistakes. Always validate the data for critical use cases. This data is an update to a previously developed database of wind ordinances found in OEDI Submission 5733: see the "U.S. Wind Siting Regulation and Zoning Ordinances 2022" link below. INFRA-COMPASS version used for collection: v0.8.2 LLMs used for collection: GPT-4.1, GPT-4.1 mini, GPT-4.1 nano, GPT-4o mini
17 WIND ENERGY↗
Agrivoltaic Decision Tools for Perennial and Field Crop Farmers
This article describes a series of spreadsheet-based tools to help farmers estimate costs, revenues, and yields from agricultural production under different configurations of agrivoltaic installations for field and perennial crops. Crop-specific log books allow farmers to project changes in activity-level costs from the field due to agrivoltaic installations. The whole-farm tool helps farmers aggregate activity-level net returns up to the farm level to calculate projections of trade-offs between crop production with or without agrivoltaic installations. We present tools for lettuce and cranberries, but the tools are comprehensive and inclusive and so can be modified for other perennial and field crops.
14 SOLAR ENERGY↗
MuCol Milestone Report No. 5: Preliminary Parameters
This document is comprised of a collection of updated preliminary parameters for the key parts of the muon collider. The updated preliminary parameters follow on from the October 2023 Tentative Parameters Report. Particular attention has been given to regions of the facility that are believed to hold greater technical uncertainty in their design and that have a strong impact on the cost and power consumption of the facility. The data is collected from a collaborative spreadsheet and transferred to overleaf.
43 PARTICLE ACCELERATORS↗
MuCol Milestone Report No. 7: Consolidated Parameters
This document is comprised of a collection of consolidated parameters for the key parts of the muon collider. These consolidated parameters follow on from the October 2024 Preliminary Parameters Report. Attention has been given to a high-level consistent set of baseline parameters throughout all systems of the complex, following a 10 TeV center-of-mass design. Additional details of the designs contributing to this baseline design are featured in the appendix. Likewise, explorative variations from this baseline set can be found in the appendix. The data is collected from a collaborative spreadsheet and transferred to overleaf.
Taylor, Rebecca [CERN]↗
Interactive CAD Layout of Reflection-Based Mirror Metrology Systems
Explore the source record for details and available documents.
Brimigion, Felicia Marie↗
Active Layer and Moisture Measurements for Intensive Site 0 and 1, Utqiagvik (Barrow), Alaska
Thaw depth, relative dielectric permittivity, and soil temperature were collected along three transects within the Arctic polygonal tundra coastal region on the Barrow Environmental Observatory (BEO) near Utqiagvik (Barrow), Alaska. Measurements were acquired along the transect at 3 m intervals on 2011-09-25, 2011-09-26, 2012-07-18, 2012-09-30, 2014-07-02, 2014-08-15, and 2014-09-14 for the L2 transect (intensive site 0), which is about 470 m long. Similarly, measurements were collected every 3 m on 2012-09-30, 2013-09-30, 2014-07-02, 2014-08-14, and 2014-09-23, and every 1 m on 2013-09-30 along the AB transect (intensive site 1) which is about 500 m long. File types in the package are all csv spreadsheets, following the ESS-DIVE csv guidelines (ESS-DIVE CSV v1), organized by transect name, with accompanying data dictionary files containing the filename suffix "_dd" (also csv format). Data collection details can be found in the Methods description of the metadata record. The Next-Generation Ecosystem Experiments: Arctic (NGEE Arctic), was a research effort to reduce uncertainty in Earth System Models by developing a predictive understanding of carbon-rich Arctic ecosystems and feedbacks to climate. NGEE Arctic was supported by the Department of Energy's Office of Biological and Environmental Research. The NGEE Arctic project had two field research sites: 1) located within the Arctic polygonal tundra coastal region on the Barrow Environmental Observatory (BEO) and the North Slope near Utqiagvik (Barrow), Alaska and 2) multiple areas on the discontinuous permafrost region of the Seward Peninsula north of Nome, Alaska. Through observations, experiments, and synthesis with existing datasets, NGEE Arctic provided an enhanced knowledge base for multi-scale modeling and contributed to improved process representation at global pan-Arctic scales within the Department of Energy's Earth system Model (the Energy Exascale Earth System Model, or E3SM), and specifically within the E3SM Land Model component (ELM).
54 ENVIRONMENTAL SCIENCES↗
Validation of the NLR Pumped Storage Hydropower Cost Model
The National Laboratory of the Rockies (NLR) first released its pumped storage hydropower (PSH) cost model in 2023 as the most detailed bottom-up PSH cost model available to the public. It is available both as a spreadsheet and an interactive web tool, enabling users with a variety of PSH interests to transparently characterize costs of alternative PSH sites and designs. The PSH cost model cannot replace detailed site-level studies and design, but it is important to validate it against other industry PSH cost estimates. The initial model methodology report validated the cost model for a single proposed site, the Eagle Mountain Project in California. This slide deck documents an expanded validation exercise using cost data from six other sites: Goldendale (Washington), Seminoe (Wyoming), Gordon Butte (Montana), Swan Lake (Oregon), White Pine (Oregon), and Lewis Ridge (Kentucky). It compares itemized costs from Federal Energy Regulatory Commission (FERC) applications and other reported costs with NLR PSH cost model outputs after customizing inputs for each site. The validation exercise finds that the NLR model's conservative indirect cost assumptions often drive overall cost overestimation, with direct cost comparisons typically agreeing more closely. All cost model estimates are well within an Association for the Advancement of Cost Engineering (AACE) Class 5 estimation range (-50% to +100%), with five within the AACE Class 4 range (-30% to +50%) and four being within 15%. This result is considered reasonable performance for a parametric model applied at a preliminary design stage.
13 HYDRO ENERGY↗
Pumped Storage Hydropower Operation & Maintenance Cost Estimation
The National Laboratory of the Rockies (NLR) develops and hosts a pumped storage hydropower (PSH) cost model that is the most detailed bottom-up PSH cost model available to the public. It is available both as a spreadsheet and an interactive web tool, enabling users with a variety of PSH interests to transparently characterize costs of alternative PSH sites and designs. The NLR PSH cost model was designed originally to consider only upfront capital costs only. This slide deck describes methodology to expand the cost model to include operations and maintenance (OM) costs. OM costs are characterized as five distinct components with unique sources and methods for cost estimation. By combining methods for each of these components into a cumulative OM cost estimate, these methods allow a more complete estimation of total OM costs that agrees with existing literature values. The methods are scalable and transparent, allowing them to be readily to applied to any prospective PSH facility for a representative preliminary OM cost estimate in advance of detailed site-specific engineering and other studies.
13 HYDRO ENERGY↗
Stations Tool for Automated Permitting (S-TAP) User Manual
The Stations Tool for Automated Permitting (S-TAP) is a spreadsheet-based plan review questionnaire designed to help automate and expedite the electric vehicle supply equipment (EVSE) permitting process. This manual goes into detail on the development of the tool and guidance for use cases of the tool.
29 ENERGY PLANNING, POLICY, AND ECONOMY↗
U.S. Indirect and Direct Potable Water Reuse Systems (2020)
Collection of proposed, operating, demonstration, and pilot study potable reuse systems across the U.S. as of 2020. Information includes project name, location, augmentation type, capacity, year operational, treatment train, and source water type. References are included in this submission. As potable reuse facilities undergo expansions or upgrades, treatment trains and capacities are subject to change. Operational status may also change. Treatment trains listed are reported to the detail that the source provides. Type and doses of chemical post-treatment or chlorination is often not specified. Please see README section in spreadsheet for definitions of acronyms used.
29 ENERGY PLANNING, POLICY, AND ECONOMY↗