SEARCH · Search NASA

Results for “Excel”

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.

SourceResearch connectionFrom yearThrough year

Quote a phrase for an exact phrase match. Source license links do not imply unrestricted reuse.

At least 19 records

All sources NASA NTRS DOE OSTI

NASA NTRS1992

Intelligent Processing Equipment Developments Within the Navy's Manufacturing Technology Centers of Excellence

The U.S. Navy has had an active Manufacturing Technology (MANTECH) Program aimed at developing advanced production processes and equipment since the late-1960's. During the past decade, however, the resources of the MANTECH program were concentrated in Centers of Excellence. Today, the Navy sponsors four manufacturing technology Centers of Excellence: the Automated Manufacturing Research Facility (AMRF); the Electronics Manufacturing Productivity Facility (EMPF); the National Center for Excellence in Metalworking Technology (NCEMT); and the Center of Excellence for Composites Manufacturing Technology (CECMT). This paper briefly describes each of the centers and summarizes typical Intelligent Equipment Processing (IEP) projects that were undertaken.

Nanzetta, Philip↗

NASA NTRS2008

Technical Excellence: A Requirement for Good Engineering

Technical excellence is a requirement for good engineering. Technical excellence has many different ways of expressing itself within engineering. NASA has initiatives that address the enhancement of the Agency's technical excellence and thrust to maintain the associated high level of performance by the Agency on current programs/projects and as it moves into the Constellation Program and the return to the Moon with plans to visit Mars. This paper addresses some of the key initiatives associated with NASA's technical excellence thrust. Examples are provided to illustrate some results being achieved and plans to enhance these initiatives.

Gill, Paul S.↗

NASA NTRS2004

An Interactive Microsoft(registered tm) Excel Program for Tracking a Single Evaporating Droplet in Crossflow

Droplet interaction with a high temperature gaseous crossflow is important because of its wide application in systems involving two phase mixing such as in combustion requiring quick mixing of fuel and air with the reduction of pollutants and for jet mixing in the dilution zone of combustors. Therefore, the focus of this work is to investigate dispersion of a two-dimensional atomized and evaporating spray jet into a two-dimensional crossflow. An interactive Microsoft Excel program for tracking a single droplet in crossflow that has previously been developed will be modified to include droplet evaporation computation. In addition to the high velocity airflow, the injected droplets are also subjected to combustor temperature and pressure that affect their motion in the flow field. Six ordinary differential equations are then solved by 4th-order Runge-Kutta method using Microsoft Excel software. Microsoft Visual Basic programming and Microsoft Excel macrocode are used to produce the data and plot graphs describing the droplet's motion in the flow field. This program computes and plots the data sequentially without forcing the user to open other types of plotting programs. A user's manual on how to use the program is included.

Droplet↗

NASA NTRS2002

An Interactive Excel Program for Tracking a Single Droplet in Crossflow Computation

Spray jet in crossflow has been a subject of research because of its wide application in systems involving pollutant dispersion, jet mixing in the dilution zone of combustors, and fuel injection strategies. The focus of this work is to investigate dispersion of a 2-dimensional atomized spray jet into a 2-dimensional crossflow. A quick computational method is developed using available software. The spreadsheet can be used for any 2D droplet trajectory problem where the drop is injected into the free stream eventually coming to the free stream conditions. During the transverse injection of a spray into high velocity airflow, the droplets (carried along and deflected by a gaseous stream of co-flowing air) are subjected to forces that affect their motion in the flow field. Based on the Newton's Second Law of motion, four ordinary differential equations were used. These equations were then solved by a fourth-order Runge-Kutta method using Excel software. Visual basic programming and Excel macrocode to produce the data facilitate Excel software to plot graphs describing the droplet's motion in the flow field. This program computes and plots the data sequentially without forcing users to open other types of plotting programs. A user's manual on how to use the program is also included in this report.

Urip, E.↗

NASA NTRS2004

Simplifying CEA through Excel, VBA, and Subeq

Many people use compound equilibrium programs for very different reasons, varying from refrigerators to light bulbs to rockets. A commonly used equilibrium program is CEA. CEA can take various inputs such as pressure, temperature, and volume along with numerous reactants and run them through equilibrium equations to obtain valuable output information, including products formed and their relative amounts. A little over a year ago, Bonnie McBride created the program subeq with the goal to simplify the calling of CEA. Subeq was also designed to be called by other programs, including Excel, through the use of Visual Basic for Applications (VBA). The largest advantage of using Excel is that it allows the user to input the information in a colorful and user-friendly environment while allowing VBA to run subeq, which is in the form of a FORTRAN DLL (Dynamic Link Library). Calling subeq in this form makes it much faster than if it were converted to VBA. Since subeq requires such large lists of reactant and product names, all of which can't be passed in as an array, subeq had to be changed to accept very long strings of reactants and products. To pass this string and adjust the transfer of input and output parameters, the subeq DLL had to be changed. One program that does this is Compaq Visual FORTRAN, which allows DLLs to be edited, debugged, and compiled. Compaq Visual FORTRAN uses FORTRAN 90/95, which has additional features to that of FORTRAN 77. My goals this summer include finishing up the excel spreadsheet of subeq, which I started last summer, and putting it on the Internet so that others can use it without having to download my spreadsheet. To finish up the spreadsheet I will need to work on debugging current options and problems. I will also work on making it as robust as possible, so that all errors that may arise will be clearly communicated to the user. New features will be added old ones will be changed as I receive comments from people using the spreadsheet. To implement this onto the Internet, I will need to develop an XML input/output format and learn how to write HTML.

Foster, Ryan↗

NASA NTRS2011

Auto Draw from Excel Input Files

The design process often involves the use of Excel files during project development. To facilitate communications of the information in the Excel files, drawings are often generated. During the design process, the Excel files are updated often to reflect new input. The problem is that the drawings often lag the updates, often leading to confusion of the current state of the design. The use of this program allows visualization of complex data in a format that is more easily understandable than pages of numbers. Because the graphical output can be updated automatically, the manual labor of diagram drawing can be eliminated. The more frequent update of system diagrams can reduce confusion and reduce errors and is likely to uncover symmetric problems earlier in the design cycle, thus reducing rework and redesign.

Strauss, Karl F.↗

NASA NTRS2012

Elements of Engineering Excellence

The inspiration for this Contract Report (CR) originated in discussions with the director of Marshall Space Flight Center (MSFC) Engineering who asked that we investigate the question: "How do you achieve excellence in aerospace engineering?" Engineering a space system is a complex activity. Avoiding its inherent potential pitfalls and achieving a successful product is a challenge. This CR presents one approach to answering the question of how to achieve Engineering Excellence. We first investigated the root causes of NASA major failures as a basis for developing a proposed answer to the question of Excellence. The following discussions integrate a triad of Technical Understanding and Execution, Partnership with the Project, and Individual and Organizational Culture. The thesis is that you must focus on the whole process and its underlying culture, not just on the technical aspects. In addition to the engineering process, emphasis is given to the need and characteristics of a Learning Organization as a mechanism for changing the culture.

Blair, J. C.↗

NASA NTRS2007

Excel for Cost Engineers

Excel is a powerful tool with a plethora of largely unused capabilities that can make the life of an engineer cognizant of them a great deal easier. This paper offers tips, tricks and techniques for better worksheets. Including the use of data validation, conditional formatting, subtotals, text formulas, custom functions and much more. It is assumed that the reader will have a cursory understanding of Excel so the basics will not be covered, if you get hung up try Excel's built in help menus, or a good book.

Butts, Glenn C.↗

NASA NTRS1991

Maintaining technical excellence requires a national plan

To meet the challenge of technical excellence, AIA established a rocket propulsion committee to develop the National Rocket Propulsion Strategic Plan. Developing such a plan required a broad spectrum of experience and disciplines. The Strategic Plan team needed the participation of industry, government, and academia. The plan provides, if followed, a means for the U.S. to maintain technical excellence and world leadership in rocket propulsion. To implement the National Rocket Propulsion Strategic Plan is to invest in the social, economic, and technological futures of America. The plan lays the basis for upgrading existing propulsion systems and a firm base for future full scale development, production, and operation of rocket propulsion systems for space, defense, and commercial applications.

Davidson, T. F.↗

NASA NTRS1991

George M. Low Trophy: NASA's quality and excellence award

NASA's major goal is the preservation of America's position as a leader in the aerospace industry. To maintain that status, it is crucial that the products and services we depend upon from NASA contractors, subcontractors, and suppliers meet the highest quality standards to ensure the space program's success. The George M. Low Trophy: NASA's Quality and Excellence Award is the result of NASA's desire to encourage continuous improvement and Total Quality Management (TQM) in the aerospace industry and is awarded to members of NASA's contractor community that have demonstrated sustained excellence, customer orientation, and outstanding achievements in a Total Quality Management (TQM) environment. The purpose in presenting this award is to increase public awareness of the importance of quality and productivity to the nation's aerospace industry and the nation's leadership position overall; encourage domestic business to continuously pursue efforts that enhance quality and increase productivity which will strengthen the nation's competitiveness in the international arena; and provide a forum for sharing the successful techniques and strategies used by applicants with other American organizations. Awards to Rockwell International and Marotta Scientific Controls, Inc. are announced and discussed.

Source record↗

NASA NTRS1990

NASA Excellence Award for Quality and Productivity 1989 highlights. The 1989 recipient: Lockheed Engineering and Sciences Company

The NASA Excellence Award for Productivity and Quality is the result of NASA's desire to encourage superior quality and the continuous improvement philosophy in the aerospace industry. It is awarded to NASA contractors, subcontractors, and suppliers who have demonstrated sustained excellence, customer orientation, and outstanding achievements in a total quality management (TQM) environment. The 'highlights' booklet is intended to transfer successful techniques demonstrated by the performance and quality of major NASA contractors.

Source record↗

NASA NTRS1988

Centers of Excellence: A Catalogue

This report summarizes information on State-sponsored 'Centers of Excellence' gathered during a survey of State programs in the Fall of 1987. For the purposes of this catalog, 'Centers of Excellence' refers to organizations or activities with the following characteristics: institutionalized, focused, cooperative Research and Development (R&D) programs; supported in part by State governments, in addition to universities, industry and (in some cases) Federal agencies; performed by teams that may include both industry and university employees; and concentrated on relatively specific R&D agendas, usually with near term commercial or governmental applicability. Most of these activities involve state-of-the-art advancement of new technologies under conditions leading to early practical applications. Not included in this catalog are project-level matching grant programs. The principal purpose of this catalog is to help NASA program management, at all levels. to identify and where appropriate, to initiate relationships with other technology-developing organizations. These State-sponsored programs should be of particular interest, because: they present an opportunity to leverage NASA's R&D investments; they are concentrated at the frontier, yet have a concern for practical applications; and they involve industrial participation under conditions that increase the probability of prompt, widespread dissemination in the form of new or enhanced commercial products, processes, or services.

Phelps, Paul B.↗

NASA NTRS1998

Implementation Plan for the NASA Center of Excellence for Structures and Materials

This report presents the implementation plans of the Center of Excellence (COE) for Structures and Materials. The plan documented herein is the result of an Agencywide planning activity led by the Office of the Center of Excellence for Structures and Materials at Langley Research Center (LaRC). The COE Leadership Team, with a representative from each NASA Field Center, was established to assist LaRC in fulfilling the responsibilities of the COE. The Leadership Team developed the plan presented in this report.

Harris, Charles E.↗

NASA NTRS2006

NASA Engineering Excellence: A Case Study on Strengthening an Engineering Organization

NASA implemented a system of technical authority following the Columbia Accident Investigation Board (CAE) report calling for independent technical authority to be exercised on the Space Shuttle Program activities via a virtual organization of personnel exercising specific technical authority responsibilities. After the current NASA Administrator reported for duty, and following the first of two planned "Shuttle Return to Flight" missions, the NASA Chief Engineer and the Administrator redirected the Independent Technical Authority to a program of Technical Excellence and Technical Authority exercised within the existing engineering organizations. This paper discusses the original implementation of technical authority and the transition to the new implementation of technical excellence, including specific measures aimed at improving safety of future Shuttle and space exploration flights.

Shivers, C. Herbert↗

NASA NTRS2010

Technical Excellence and Communication: The Cornerstones for Successful Safety and Mission Assurance Programs

The paper describes the role of technical excellence and communication in the development and maintenance of safety and mission assurance programs. The Marshall Space Flight Center (MSFC) Safety and Mission Assurance (S&MA) organization is used to illustrate philosophies and techniques that strengthen safety and mission assurance efforts and that contribute to healthy and effective organizational cultures. The events and conditions leading to the development of the MSFC S&MA organization are reviewed. Historic issues and concerns are identified. The adverse effects of resource limitations and risk assessment roles are discussed. The structure and functions of the core safety, reliability, and quality assurance functions are presented. The current organization s mission and vision commitments serve as the starting points for the description of the current organization. The goals and objectives are presented that address the criticisms of the predecessor organizations. Additional improvements are presented that address the development of technical excellence and the steps taken to improve communication within the Center, with program customers, and with other Agency S&MA organizations.

Malone, Roy W.↗

NASA NTRS2017

Improving the Plasticity of LIMS Implementation: LIMS Extension through Microsoft Excel

A Laboratory Information Management System (LIMS) is a databasing software with many built-in tools ideal for handling and documenting most laboratory processes in an accurate and consistent manner, making it an indispensable tool for the modern laboratory. However, a lot of LIMS end users will find that in the performance of analyses that have unique considerations such as standard curves, multiple stages incubations, or logical considerations, a base LIMS distribution may not ideally suit their needs. These considerations bring about the need for extension languages, which can extend the functionality of a LIMS. While these languages do provide the implementation team the functionality required to accommodate these special laboratory analyses, they are usually too complex for the end user to modify to compensate for natural changes in laboratory operations. The LIMS utilized by our laboratory offers a unique and easy-to-use choice for an extension language, one that is already heavily relied upon not only in science but also in most academic and business pursuits: Microsoft Excel. The validity of Microsoft Excel as a pseudo programming language and its usability and versatility as a LIMS extension language will be discussed. The NELAC implications and overall drawbacks of this LIMS configuration will also be discussed.

LIMS↗

NASA NTRS2018

The Advantages of Synergy-Quantitative Earth Science Data Visualization and Analysis with Giovanni, Panoply, and Excel

The NASA Giovanni data analysis system provides a multitude of basic analysis capabilities for numerous Earth science data products which are available in the NASA Goddard Earth Sciences Data and Information Services Center (GES DISC) archive, as well as for additional selected data products provided by other NASA Distributed Active Archive Center (DAAC) archives. In Giovanni, users can easily generate time-averaged data maps, area-averaged time-series, Latitude-Time and Longitude-Time Hovmoeller diagrams, correlation maps, accumulation maps, and map animations (22 analysis options are available in total). While ASCII text output is available for time-series plots, it is not included as an option for data maps. In order to provide a quantitative, easy-to-use numerical output in ASCII text form, the NetCDF file output from a Giovanni visualization is downloaded and then opened with the free NASA visualization software package Panoply. Panoply provides the capability of translating the Giovanni file into comma-separated-variable (CSV) output. Panoply also provides additional visualization options, including the facile calculation of difference maps and quasi-anomaly maps using Giovanni output files. The CSV files from Panoply can then be imported into an Excel spreadsheet, where an Excel macro converts the CSV files. The output consists of latitude-longitude-data value triads in text form for maps, and either longitude-time-data value or latitude-time-data value triads in text form for Hovmoeller diagrams. This presentation will explicate the basic procedure for the conversion, and then provide several examples where the procedure is applied to Giovanni output from different analysis options.

Earth science↗

NASA NTRS1990

Stanford/NASA-Ames Center of Excellence in model-based human performance

The human operator plays a critical role in many aeronautic and astronautic missions. The Stanford/NASA-Ames Center of Excellence in Model-Based Human Performance (COE) was initiated in 1985 to further our understanding of the performance capabilities and performance limits of the human component of aeronautic and astronautic projects. Support from the COE is devoted to those areas of experimental and theoretical work designed to summarize and explain human performance by developing computable performance models. The ultimate goal is to make these computable models available to other scientists for use in design and evaluation of aeronautic and astronautic instrumentation. Within vision science, two topics have received particular attention. First, researchers did extensive work analyzing the human ability to recognize object color relatively independent of the spectral power distribution of the ambient lighting (color constancy). The COE has supported a number of research papers in this area, as well as the development of a substantial data base of surface reflectance functions, ambient illumination functions, and an associated software package for rendering and analyzing image data with respect to these spectral functions. Second, the COE supported new empirical studies on the problem of selecting colors for visual display equipment to enhance human performance in discrimination and recognition tasks.

Wandell, Brian A.↗