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 145 records · Page 8
All sourcesNASA NTRSDOE OSTI
NASA NTRS2006

User Interactive Software for Analysis of Human Physiological Data

Ambulatory physiological monitoring has been used to study human health and performance in space and in a variety of Earth-based environments (e.g., military aircraft, armored vehicles, small groups in isolation, and patients). Large, multi-channel data files are typically recorded in these environments, and these files often require the removal of contaminated data prior to processing and analyses. Physiological data processing can now be performed with user-friendly, interactive software developed by the Ames Psychophysiology Research Laboratory. This software, which runs on a Windows platform, contains various signal-processing routines for both time- and frequency- domain data analyses (e.g., peak detection, differentiation and integration, digital filtering, adaptive thresholds, Fast Fourier Transform power spectrum, auto-correlation, etc.). Data acquired with any ambulatory monitoring system that provides text or binary file format are easily imported to the processing software. The application provides a graphical user interface where one can manually select and correct data artifacts utilizing linear and zero interpolation and adding trigger points for missed peaks. Block and moving average routines are also provided for data reduction. Processed data in numeric and graphic format can be exported to Excel. This software, PostProc (for post-processing) requires the Dadisp engineering spreadsheet (DSP Development Corp), or equivalent, for implementation. Specific processing routines were written for electrocardiography, electroencephalography, electromyography, blood pressure, skin conductance level, impedance cardiography (cardiac output, stroke volume, thoracic fluid volume), temperature, and respiration

Cowings, Patricia S.↗
DOE OSTI2020

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↗
DOE OSTI2020

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↗
DOE OSTI2020

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↗
DOE OSTI2020

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↗
DOE OSTI2022

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↗
NASA NTRS2004

Low Emissions Alternative Power (LEAP) Project Office Business Team of the Aeropropulsion Research Program Office (ARPO) Org. 0140

The program for which I am working at this summer is Propulsion and Power/Low Emissions Alternative Power (P&P/LEAP). It invests in a fundamental TRL 1-6 research and technology portfolio that will enable the future of: Alternative fuels and/or alternative propulsion systems, non-combustion (electric) propulsion systems. P&P/LEAP will identify and capitalize on the highest potential concepts generated both internal and external to the Agency. During my 2004 summer at NASA Glenn Research Center, I worked with my mentor Barbara Mader, in the Project Office with the Business Team completing various tasks for the project and personnel. The LEAP project is a highly matrixed organization. The Project Office is responsible for the goals advocacy and dollar (budget) of the LEAP project. The objectives of the LEAP Project are to discover new energy sources and develop unconventional engines and power systems directed towards greatly reduced emissions, enable new vehicle concepts for public mobility, new science missions and national security. The Propulsion and PowerLow Emissions Alternative Power directly supports the environmental, mobility, national security objectives of the Vehicle Systems Program and the Aeronautics Technology Theme. Technology deliverables include the demonstration through integrated ground tests, a constant volume combustor in an engine system, and UAV/small transport aircraft all electric power system. My mentor serves as a key member of the management team for the Aeropropulsion Research Program Office (ARPO). She has represented the office on numerous occasions, and is a member of a number of center-wide panels/teams, such as the Space management Committee and is chair to the Business Process Consolidation Team. She is responsible for the overall coordination of resources for the Propulsion and Power Project - from advocacy to implementation. The goal for my summer at NASA was to document processes and archive program documents from the past years. I used the computer and office machines, and also worked with personnel in setting up a Cost Estimation Plan. I gained office experience in Word, Excel, and Power Point, with the completion of a variety of tasks. I made spreadsheets that pertained to the budget plan for Journey to Tomorrow, to name a few I have supported the office by tracking resource information: including programmatic travel, project budget at the center level to budgets for individual research sub-projects and grants. I also assisted the Program Support Office in their duties including, representing the office on numerous occasions on center-wide team/panels, such as the Space management committee, IFMP Budget Formulation, Journey to Tomorrow Committee, and the Vehicle Systems Program Business Process Team.

Buttler, Jennifer A.↗
NASA NTRS2010

Propulsion Technology Lifecycle Operational Analysis

The paper presents the results of a focused effort performed by the members of the Space Propulsion Synergy Team (SPST) Functional Requirements Sub-team to develop propulsion data to support Advanced Technology Lifecycle Analysis System (ATLAS). This is a spreadsheet application to analyze the impact of technology decisions at a system-of-systems level. Results are summarized in an Excel workbook we call the Technology Tool Box (TTB). The TTB provides data for technology performance, operations, and programmatic parameters in the form of a library of technical information to support analysis tools and/or models. The lifecycle of technologies can be analyzed from this data and particularly useful for system operations involving long running missions. The propulsion technologies in this paper are listed against Chemical Rocket Engines in a Work Breakdown Structure (WBS) format. The overall effort involved establishing four elements: (1) A general purpose Functional System Breakdown Structure (FSBS). (2) Operational Requirements for Rocket Engines. (3) Technology Metric Values associated with Operating Systems (4) Work Breakdown Structure (WBS) of Chemical Rocket Engines The list of Chemical Rocket Engines identified in the WBS is by no means complete. It is planned to update the TTB with a more complete list of available Chemical Rocket Engines for United States (US) engines and add the Foreign rocket engines to the WBS which are available to NASA and the Aerospace Industry. The Operational Technology Metric Values were derived by the SPST Sub-team in the form of the TTB and establishes a database for users to help evaluate and establish the technology level of each Chemical Rocket Engine in the database. The Technology Metric Values will serve as a guide to help determine which rocket engine to invest technology money in for future development.

Robinson, John W.↗
DOE OSTI2021

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↗
DOE OSTI2020

2020 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 updated version of the workbook provides data for the 2020 ATB. In 2019 and 2020, NREL has also provided selected data in Tableau workbooks and structured summary csv files. A website documents this data at https://atb.nlr.gov .

02 PETROLEUM↗
NASA NTRS2020

Conducted Susceptibility Data Adaptation Tool

The purpose of this research project is to help NASA scientists increase effectivity in testing by reducing the amount of time required for data conversion from initial measurements to the analysis stage. This project resulted in a data conversion tool developed in python using the openpyxl library. When lab personnel perform the Conducted Susceptibility 101 (CS101) and Conducted Susceptibility 02 (CS02) tests in the Semi-anechoic Electromagnetic Compatibility Test Facility at NASA Langley Research Center, the driving code produces a text file under the .DAT extension.The data must be manually converted the .DAT file into an Excel file line by line for data analysis.The Conducted Susceptibility Data Adaptation Tool (CSDAT) uses python code to convert the .DAT files to spreadsheets automatically which saves lab personnel time which they could use for faster analysis as well as prevents possible human error such as leaving out a line of data in the manual conversion process.

Gabriel Johnson↗
NASA NTRS2010

Integrating Variances into an Analytical Database

For this project, I enrolled in numerous SATERN courses that taught the basics of database programming. These include: Basic Access 2007 Forms, Introduction to Database Systems, Overview of Database Design, and others. My main job was to create an analytical database that can handle many stored forms and make it easy to interpret and organize. Additionally, I helped improve an existing database and populate it with information. These databases were designed to be used with data from Safety Variances and DCR forms. The research consisted of analyzing the database and comparing the data to find out which entries were repeated the most. If an entry happened to be repeated several times in the database, that would mean that the rule or requirement targeted by that variance has been bypassed many times already and so the requirement may not really be needed, but rather should be changed to allow the variance's conditions permanently. This project did not only restrict itself to the design and development of the database system, but also worked on exporting the data from the database to a different format (e.g. Excel or Word) so it could be analyzed in a simpler fashion. Thanks to the change in format, the data was organized in a spreadsheet that made it possible to sort the data by categories or types and helped speed up searches. Once my work with the database was done, the records of variances could be arranged so that they were displayed in numerical order, or one could search for a specific document targeted by the variances and restrict the search to only include variances that modified a specific requirement. A great part that contributed to my learning was SATERN, NASA's resource for education. Thanks to the SATERN online courses I took over the summer, I was able to learn many new things about computers and databases and also go more in depth into topics I already knew about.

Sanchez, Carlos↗
NASA NTRS2009

A General Tool for Evaluating High-Contrast Coronagraphic Telescope Performance Error Budgets

This paper describes a general purpose Coronagraph Performance Error Budget (CPEB) tool that we have developed under the NASA Exoplanet Exploration Program. The CPEB automates many of the key steps required to evaluate the scattered starlight contrast in the dark hole of a space-based coronagraph. It operates in 3 steps: first, a CodeV or Zemax prescription is converted into a MACOS optical prescription. Second, a Matlab program calls ray-trace code that generates linear beam-walk and aberration sensitivity matrices for motions of the optical elements and line-of-sight pointing, with and without controlled coarse and fine-steering mirrors. Third, the sensitivity matrices are imported by macros into Excel 2007 where the error budget is created. Once created, the user specifies the quality of each optic from a predefined set of PSDs. The spreadsheet creates a nominal set of thermal and jitter motions and combines them with the sensitivity matrices to generate an error budget for the system. The user can easily modify the motion allocations to perform trade studies.

Terrestrial Planet Finder↗
DOE OSTI2025

Systems Innovation: Modernization & Efficiencies for ESH&Q Reviews

Environmental compliance reviews at INL have traditionally been managed through fragmented systems, relying on multiple spreadsheets and manual processes. This inefficiency led to time-consuming status updates and redundant tasks, such as manually sending reminder emails and transferring data from Excel to the Environmental Review Process (ERP). Initial attempts to streamline these processes using Power Automate and Excel revealed significant limitations, necessitating a more comprehensive solution. To address these immediate inefficiencies, automated workflows were developed using Power Automate. These workflows were designed to send scheduled status update reminders and capture responses through standardized forms, with submitted data flowing directly into centralized Excel trackers. This automation reduced the administrative burden, improved data accuracy, and enabled faster, more consistent reporting. Specifically, email automation achieved a 65% efficiency gain, while data integration saw a 48% improvement, resulting in 91% of project statuses being updated within two months. Despite the improvements brought by Power Automate, the fragmented nature of the review processes persisted. To further enhance efficiency and accuracy, the Integrated Review Tool (IRT) was developed. The IRT aims to centralize review initiation and connect team systems, creating an interconnected data infrastructure that preserves team autonomy while enhancing overall efficiency. This tool automates email reminders, centralizes reviews, and streamlines data integration, significantly improving the accuracy and efficiency of environmental compliance reviews. The design and development of the IRT involved advanced systems methodology, process mapping, project management, and collaboration with subject matter experts. The minimum viable product design is 100% complete, and system development is currently underway, with expected outcomes including a centralized entry point for all ESH&Q reviews, automated routing, real-time tracking and analytics, AI integration, and a user-friendly interface. This project demonstrates the potential of leveraging automation and integrated systems to enhance efficiency, accuracy, and decision-making in environmental reporting and compliance processes at INL.

99 - GENERAL AND MISCELLANEOUS↗
DOE OSTI2026

Meteoric 10Be Flux Calibration Data for the East River Watershed, Colorado, USA

This data package contains tabular and geospatial data used to quantify and model meteoric beryllium-10 fluxes in the East River watershed, Colorado, USA. The tabular component includes calibration-site data from five glacial moraine sites and includes environmental variables used to evaluate spatial controls on meteoric 10Be delivery, including elevation, mean annual precipitation (MAP), mean snow depth, and mean snow water equivalent (SWE). These site-level data were used to compare observed fluxes with environmental gradients across the watershed and to evaluate the effects of erosion correction on flux estimates. The package also includes supporting slope and curvature values used to assess topographic inputs to the erosion analysis. A second component of the data package contains updated manuscript tables and regression outputs used to summarize the relationships between meteoric 10Be flux and environmental predictors. These tables include meteoric 10Be sample information and AMS results, site-level environmental values, site-level meteoric 10Be inventory and flux values, watershed-averaged predicted fluxes, soil bulk density measurements, fine-fraction values, soil pH measurements, and regression statistics including slope, intercept, coefficient of determination, and p-value. The regression products include both standard linear regressions and regressions in which the intercept is constrained to pass through zero, and they support the analyses presented in the companion manuscript. Together, these tabular files provide the numerical basis for the manuscript tables and the regression-based interpretation of meteoric 10Be flux variability in a snow-dominated mountain watershed. The geospatial component of the package consists of GeoTIFF raster files used to generate the map products presented in Figures 2 and 6 of the companion manuscript. These rasters represent watershed-scale spatial layers for environmental variables and regression-based predictions of meteoric 10Be flux. This dataset contains comma-separated values files (.csv), Microsoft Excel files (.xlsx), GeoTIFF raster files (.tif), and upporting metadata files, including CSV data dictionaries and readme text files (.csv, .txt). The tabular files can be opened with standard spreadsheet software, and the raster files can be viewed and analyzed in GIS software such as ArcGIS Pro or QGIS. Together, these files document the numerical and spatial datasets used to calibrate and predict meteoric 10Be delivery in the East River watershed.

East River↗
DOE OSTI2024

UMass 2-Body WEC Techno-Economic Assessment

The University of Massachusetts (UMass) is developing a 2-body wave energy converter (WEC) device that is converting mechanical power into electricity using a mechanical motion rectifier that allows the system to couple to a flywheel. UMass has completed numerical modeling, wave tank testing, and PTO sub-system testing and needed assistance in developing a techno-economic model to enable optimization of their topology, comparison to a generic heaving point absorber topology, and guide the next steps in their development efforts. The core objective was to develop a techno-economic approach and modeling tool that allows benchmarking of the two topologies across a wide range of scales to evaluate their respective competitiveness in different application spaces. This data includes the final report as well as a supporting spreadsheet containing the data produced for this report.

16 TIDAL AND WAVE POWER↗
NASA NTRS2011

General Tool for Evaluating High-Contrast Coronagraphic Telescope Performance Error Budgets

The Coronagraph Performance Error Budget (CPEB) tool automates many of the key steps required to evaluate the scattered starlight contrast in the dark hole of a space-based coronagraph. The tool uses a Code V prescription of the optical train, and uses MATLAB programs to call ray-trace code that generates linear beam-walk and aberration sensitivity matrices for motions of the optical elements and line-of-sight pointing, with and without controlled fine-steering mirrors (FSMs). The sensitivity matrices are imported by macros into Excel 2007, where the error budget is evaluated. The user specifies the particular optics of interest, and chooses the quality of each optic from a predefined set of PSDs. The spreadsheet creates a nominal set of thermal and jitter motions, and combines that with the sensitivity matrices to generate an error budget for the system. CPEB also contains a combination of form and ActiveX controls with Visual Basic for Applications code to allow for user interaction in which the user can perform trade studies such as changing engineering requirements, and identifying and isolating stringent requirements. It contains summary tables and graphics that can be instantly used for reporting results in view graphs. The entire process to obtain a coronagraphic telescope performance error budget has been automated into three stages: conversion of optical prescription from Zemax or Code V to MACOS (in-house optical modeling and analysis tool), a linear models process, and an error budget tool process. The first process was improved by developing a MATLAB package based on the Class Constructor Method with a number of user-defined functions that allow the user to modify the MACOS optical prescription. The second process was modified by creating a MATLAB package that contains user-defined functions that automate the process. The user interfaces with the process by utilizing an initialization file where the user defines the parameters of the linear model computations. Other than this, the process is fully automated. The third process was developed based on the Terrestrial Planet Finder coronagraph Error Budget Tool, but was fully automated by using VBA code, form, and ActiveX controls.

Marchen, Luis F.↗
DOE OSTI2024

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↗