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.

SourceResearch connectionFrom yearThrough year

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

At least 145 records · Page 8

All sources NASA NTRS DOE OSTI

NASA NTRS2002

Predicting Production Costs for Advanced Aerospace Vehicles

For early design concepts, the conventional approach to cost is normally some kind of parametric weight-based cost model. There is now ample evidence that this approach can be misleading and inaccurate. By the nature of its development, a parametric cost model requires historical data and is valid only if the new design is analogous to those for which the model was derived. Advanced aerospace vehicles have no historical production data and are nowhere near the vehicles of the past. Using an existing weight-based cost model would only lead to errors and distortions of the true production cost. This paper outlines the development of a process-based cost model in which the physical elements of the vehicle are soared according to a first-order dynamics model. This theoretical cost model, first advocated by early work at MIT, has been expanded to cover the basic structures of an advanced aerospace vehicle. Elemental costs based on the geometry of the design can be summed up to provide an overall estimation of the total production cost for a design configuration. This capability to directly link any design configuration to realistic cost estimation is a key requirement for high payoff MDO problems. Another important consideration in this paper is the handling of part or product complexity. Here the concept of cost modulus is introduced to take into account variability due to different materials, sizes, shapes, precision of fabrication, and equipment requirements. The most important implication of the development of the proposed process-based cost model is that different design configurations can now be quickly related to their cost estimates in a seamless calculation process easily implemented on any spreadsheet tool.

Bao, Han P.↗

NASA NTRS2002

NETMARK

This presentation discuss NASA's proposed NETMARK knowledge management tool which aims 'to control and interoperate with every block in a document, email, spreadsheet, power point, database, etc. across the lifecycle'. Topics covered include: system software requirements and hardware requirements, seamless information systems, computer architecture issues, and potential benefits to NETMARK users.

Maluf, David A.↗

NASA NTRS2002

Comparison of Analytical and Numerical Performance Predictions for an International Space Station Node 3 Internal Active Thermal Control System Regenerative Heat Exchanger

The complexity of International Space Station (ISS) systems modeling often necessitates the concurrence of various dissimilar, parallel analysis techniques to validate modeling. This was the case with a feasibility and performance study of the ISS Node 3 Regenerative Heat Exchanger (RHX). A thermo-hydraulic network model was created and analyzed in SINDA/FLUINT. A less complex, closed form solution of the systems dynamics was created using an Excel Spreadsheet. The purpose of this paper is to provide a brief description of the modeling processes utilized, the results and benefits of each to the ISS Node 3 RHX study.

Wise, Stephen A.↗

NASA NTRS2003

Statistical Evaluation and Improvement of Methods for Combining Random and Harmonic Loads

Structures in many environments experience both random and harmonic excitation. A variety of closed-form techniques has been used in the aerospace industry to combine the loads resulting from the two sources. The resulting combined loads are then used to design for both yield/ultimate strength and high- cycle fatigue capability. This Technical Publication examines the cumulative distribution percentiles obtained using each method by integrating the joint probability density function of the sine and random components. A new Microsoft Excel spreadsheet macro that links with the software program Mathematica to calculate the combined value corresponding to any desired percentile is then presented along with a curve tit to this value. Another Excel macro that calculates the combination using Monte Carlo simulation is shown. Unlike the traditional techniques. these methods quantify the calculated load value with a consistent percentile. Using either of the presented methods can be extremely valuable in probabilistic design, which requires a statistical characterization of the loading. Additionally, since the CDF at high probability levels is very flat, the design value is extremely sensitive to the predetermined percentile; therefore, applying the new techniques can substantially lower the design loading without losing any of the identified structural reliability.

Brown, A. M.↗

NASA NTRS2002

Material Outgassing, Identification and Deposition, MOLIDEP System

The outgassing tests are performed employing a modified vacuum operated Cahn analytical microbalance, identified as the MOLIDEP system. The test measures under high vacuum, the time varying Molecular mass loss of a material sample held at a chosen temperature; it Identifies the outgassing molecular components using an inline SRS 300 amu Residual Gas Analyzer (RGA) and employs a temperature controlled 10 MHz Quartz Crystal Microbalance (QCM) to measure the condensable DEPosits. Both the QCM and the RGA intercept within the conductive passage the outgassing products being evacuated by a turbomolecular pump. The continuous measurements of the mass loss, the rate of loss, the sample temperature, the rate of temperature change, the QCM temperature and the QCM recorded condensable deposits or rate of deposits are saved to an Excel spreadsheet. A separate computer controls the RGA.

Scialdone, John J.↗

NASA NTRS2003

Effect of Voltage Level on Power System Design for Solar Electric Propulsion Missions

This paper presents study results quantifying the benefits of higher voltage, electric power system designs for a typical solar electric propulsion spacecraft Earth orbiting mission. A conceptual power system architecture was defined and design points were generated for system voltages of 28-V, 50-V, 120-V, and 300-V using state-of-the-art or advanced technologies. A 300-V 'direct-drive' architecture was also analyzed to assess the benefits of directly powering the electric thruster from the photovoltaic array without up-conversion. Fortran and spreadsheet computational models were exercised to predict the performance and size power system components to meet spacecraft mission requirements. Pertinent space environments, such as electron and proton radiation, were calculated along the spiral trajectory. In addition, a simplified electron current collection model was developed to estimate photovoltaic array losses for the orbital plasma environment and that created by the thruster plume. The secondary benefits of power system mass savings for spacecraft propulsion and attitude control systems were also quantified. Results indicate that considerable spacecraft wet mass savings were achieved by the 300-V and 300-V direct-drive architectures.

Kerslake, Thomas W.↗

NASA NTRS2003

Development of a Digital Meteorite Identification Program at University of New Mexico (UNM) (Institute of Meteoritics) and Southwestern Indian Polytechnic Institute (SIPI)

Determining the origin and chemical composition of suspect extra terrestrial specimens has lead to meteorite identification research programs. Such programs, like the University of New Mexico-Southwestern Indian Polytechnic Institute partnership, are being inundated with many non-meteorites (meteor wrongs) sent in by interested individuals from all over the world. This meteorite identification program developed a spreadsheet that aids in identifying the types of minerals in a sample for physical properties, possible meteorite characteristics, minerals and rock properties, and possible man made characteristics. Samples that show meteorite distinctiveness are further analyzed via the Scanning Electron Microprobe (SEM).

Gakin, R.↗

NASA NTRS2002

Software for Estimating Costs of Testing Rocket Engines

A high-level parametric mathematical model for estimating the costs of testing rocket engines and components at Stennis Space Center has been implemented as a Microsoft Excel program that generates multiple spreadsheets. The model and the program are both denoted, simply, the Cost Estimating Model (CEM). The inputs to the CEM are the parameters that describe particular tests, including test types (component or engine test), numbers and duration of tests, thrust levels, and other parameters. The CEM estimates anticipated total project costs for a specific test. Estimates are broken down into testing categories based on a work-breakdown structure and a cost-element structure. A notable historical assumption incorporated into the CEM is that total labor times depend mainly on thrust levels. As a result of a recent modification of the CEM to increase the accuracy of predicted labor times, the dependence of labor time on thrust level is now embodied in third- and fourth-order polynomials.

Hines, Merion M.↗

NASA NTRS2004

Statistical Comparison and Improvement of Methods for Combining Random and Harmonic Loads

Structures in many environments experience both random and harmonic excitation. A variety of closed-form techniques has been used in the aerospace industry to combine the loads resulting from the two sources. The resulting combined loads are then used to design for both yield ultimate strength and high cycle fatigue capability. This paper examines the cumulative distribution function (CDF) percentiles obtained using each method by integrating the joint probability density function of the sine and random components. A new Microsoft Excel spreadsheet macro that links with the software program Mathematics is then used to calculate the combined value corresponding to any desired percentile along with a curve fit to this value. Another Excel macro is used to calculate the combination using a Monte Carlo simulation. Unlike the traditional techniques, these methods quantify the calculated load value with a Consistent percentile. Using either of the presented methods can be extremely valuable in probabilistic design, which requires a statistical characterization of the loading. Also, since the CDF at high probability levels is very flat, the design value is extremely sensitive to the predetermined percentile; therefore, applying the new techniques can lower the design loading substantially without losing any of the identified structural reliability.

Brown, Andrew M.↗

NASA NTRS2004

Software for Estimating Costs of Testing Rocket Engines

Hines, Merlon M.↗

NASA NTRS2004

Lapin Data Interchange Among Database, Analysis and Display Programs Using XML-Based Text Files

The purpose was to investigate and evaluate the interchange of application- specific data among multiple programs each carrying out part of the analysis and design task. This has been carried out previously by creating a custom program to read data produced by one application and then write that data to a file whose format is specific to the second application that needs all or part of that data. In this investigation, data of interest is described using the XML markup language that allows the data to be stored in a text-string. Software to transform output data of a task into an XML-string and software to read an XML string and extract all or a portion of the data needed for another application is used to link two independent applications together as part of an overall design effort. This approach was initially used with a standard analysis program, Lapin, along with standard applications a standard spreadsheet program, a relational database program, and a conventional dialog and display program to demonstrate the successful sharing of data among independent programs. See Engineering Analysis Using a Web-Based Protocol by J.D. Schoeffler and R.W. Claus, NASA TM-2002-211981, October 2002. Most of the effort beyond that demonstration has been concentrated on the inclusion of more complex display programs. Specifically, a custom-written windowing program organized around dialogs to control the interactions have been combined with an independent CAD program (Open Cascade) that supports sophisticated display of CAD elements such as lines, spline curves, and surfaces and turbine-blade data produced by an independent blade design program (UD0300).

Source record↗

NASA NTRS1993

Decomposition of superimposed ground reaction forces into left and right force profiles

The process of collecting ground reaction force data by mounting a forceplate beneath a treadmill belt has the advantage that numerous walking trials can be analyzed without the problem of subjects 'targeting' their footsteps. However, a potential problem is that the measured forces represent a summation of bilateral force profiles during the double support phase of walking. To address this issue, an algorithm is described for decomposing superimposed ground reaction force data into individual left and right profiles. It is based on an examination of the side-to-side oscillations of the measured center of pressure (CoP). Whenever the measured CoP exceeds a certain threshold, it is assumed that the person is being supported by a single limb, and the measured GRF data reflect the forces under that limb. Conversely, when the measured CoP indicates that both feet are on the treadmill, it is assumed that the location of the individual CoP under each foot is given by wL2 and wR2. These quantities reflect the greatest excursion of the measured CoP towards the left and right sides of the forceplate, respectively. With this assumption, individual GRF profiles can be calculated by means of solving two simultaneous equations--one describing the equilibrium of forces in the vertical direction, and one describing the equilibrium of moments about an antero-posterior axis of the forceplate. The algorithm describing this procedure is simple enough to be implemented on a spreadsheet and yields estimates for average force, impulse, peak force and stance time that are typically within 3% of the true values.

Non-NASA Center↗

NASA NTRS2005

Lapin Data Interchange Among Database, Analysis and Display Programs Using XML-Based Text Files

The purpose of grant NCC3-966 was to investigate and evaluate the interchange of application-specific data among multiple programs each carrying out part of the analysis and design task. This has been carried out previously by creating a custom program to read data produced by one application and then write that data to a file whose format is specific to the second application that needs all or part of that data. In this investigation, data of interest is described using the XML markup language that allows the data to be stored in a text-string. Software to transform output data of a task into an XML-string and software to read an XML string and extract all or a portion of the data needed for another application is used to link two independent applications together as part of an overall design effort. This approach was initially used with a standard analysis program, Lapin, along with standard applications a standard spreadsheet program, a relational database program, and a conventional dialog and display program to demonstrate the successful sharing of data among independent programs. Most of the effort beyond that demonstration has been concentrated on the inclusion of more complex display programs. Specifically, a custom-written windowing program organized around dialogs to control the interactions have been combined with an independent CAD program (Open Cascade) that supports sophisticated display of CAD elements such as lines, spline curves, and surfaces and turbine-blade data produced by an independent blade design program (UD0300).

Source record↗

NASA NTRS2005

Low NO(x) Combustor Development

The goal of these efforts was the development of an ultra-low emissions, lean-burn combustor for the High Speed Civil Transport. The HSCT Mach 2.4 FLADE C1 Cycle was selected as the baseline engine cycle. A preliminary compilation of performance requirements for the HSCT combustor system was developed. The emissions goals of the program, baseline engine cycle, and standard combustor performance requirements were considered in developing the compilation of performance requirements. Seven combustor system designs were developed. The development of these system designs was facilitated by the use of spreadsheet-type models which predicted performance of the combustor systems over the entire flight envelope of the HSCT. A chemical kinetic model was developed for an LPP combustor and employed to study NO(x) formation kinetics, and CO burnout. These predictions helped to define the combustor residence time. Five fuel-air mixer concepts were analyzed for use in the combustor system designs. One of the seven system designs, one using the Swirl-Jet and Cyclone Swirler fuel-air mixers, was selected for a preliminary mechanical design study.

Kastl, J. A.↗

NASA NTRS2004

"ATLAS" Advanced Technology Life-cycle Analysis System

Making good decisions concerning research and development portfolios-and concerning the best systems concepts to pursue - as early as possible in the life cycle of advanced technologies is a key goal of R&D management This goal depends upon the effective integration of information from a wide variety of sources as well as focused, high-level analyses intended to inform such decisions Life-cycle Analysis System (ATLAS) methodology and tool kit. ATLAS encompasses a wide range of methods and tools. A key foundation for ATLAS is the NASA-created Technology Readiness. The toolkit is largely spreadsheet based (as of August 2003). This product is being funded by the Human and Robotics The presentation provides a summary of the Advanced Technology Level (TRL) systems Technology Program Office, Office of Exploration Systems, NASA Headquarters, Washington D.C. and is being integrated by Dan O Neil of the Advanced Projects Office, NASA/MSFC, Huntsville, AL

Lollar, Louis F.↗

NASA NTRS2004

Methodolgy For Evaluation Of Technology Impacts In Space Electric Power Systems

The Analysis and Management branch of the Power and Propulsion Office at NASA Glenn Research Center is responsible for performing complex analyses of the space power and In-Space propulsion products developed by GRC. This work quantifies the benefits of the advanced technologies to support on-going advocacy efforts. The Power and Propulsion Office is committed to understanding how the advancement in space technologies could benefit future NASA missions. They support many diverse projects and missions throughout NASA as well as industry and academia. The area of work that we are concentrating on is space technology investment strategies. Our goal is to develop a Monte-Carlo based tool to investigate technology impacts in space electric power systems. The framework is being developed at this stage, which will be used to set up a computer simulation of a space electric power system (EPS). The outcome is expected to be a probabilistic assessment of critical technologies and potential development issues. We are developing methods for integrating existing spreadsheet-based tools into the simulation tool. Also, work is being done on defining interface protocols to enable rapid integration of future tools. Monte Carlo-based simulation programs for statistical modeling of the EPS Model. I decided to learn and evaluate Palisade's @Risk and Risk Optimizer software, and utilize it's capabilities for the Electric Power System (EPS) model. I also looked at similar software packages (JMP, SPSS, Crystal Ball, VenSim, Analytica) available from other suppliers and evaluated them. The second task was to develop the framework for the tool, in which we had to define technology characteristics using weighing factors and probability distributions. Also we had to define the simulation space and add hard and soft constraints to the model. The third task is to incorporate (preliminary) cost factors into the model. A final task is developing a cross-platform solution of this framework.

Holda, Julie↗

NASA NTRS2004

The Training Process of the Organization Development and Training Office

The Organization Development and Training Office provides training and development opportunities to employees at NASA Glenn Research Center, as a division of the Office of Human Resources and Workforce Planning. Center-wide required trainings, new employee trainings, workshops and career development programs are organized by the OD&TO staff. They also arrange all academic, non-academic, headquarters, fellowship and learning center sponsored courses. They also service organizations wishing to work more effectively by facilitating teambuilding exercises. Equal Opportunity programs and upward mobility programs such as the STEP and GO programs for administrative staff. In working with my mentor I am very involved with Cuyahoga Community College classes, mandatory supervisory training and administrative staff workshops. My largest tasks are in the secretarial training category. The Supporting Organizations And Relationships workshop for administrative personnel, commonly known as SOAR, began last year and continued this summer with follow-up workshops. Months before a workshop or class is brought to Glenn, a need has to be realized. In this case, administrative staff did not feel they had an opportunity to receive relevant training and develop skills through teambuilding, networking and communication. A Statement of work is then created as several companies are contacted about providing the training. After the company best suited to meet the target group s needs is selected, the course is announced with an outline of all pertinent information. A reservation for a facility is made and applications or nominations, depending on the announcement s guidelines, are received from interested employees. Confirmations are sent to participants and final preparations are made but there are still several concluding steps. A training office staff member also assists the facilitator with setting up the facility and introducing the class. After the class, participants evaluations are read and summarized to determine the effectiveness of the class and instructor. In addition to the SOAR workshops, I have several projects and daily tasks to complete. Coding training applications, which require me to be familiar with Glenn s budgetary allocations and policies on training, is an ongoing process. It also requires verifying information reported by an employee via her C-478 form, more commonly known as the training application. I am also the point of contact for the Cuyahoga Community College Advising Sessions held here at NASA Glenn which involves coordinating counselors visits with employees schedules. Two databases had to be created. The first database holds information on administrative staff, and the other tracks supervisors training histories. Through these assignments I gained experience in Microsoft Access 2002 and spreadsheet creation, communicating with co-workers, and successfully facilitating a training to serve specific purposes. With trainings and evaluations to assessment them, the Organization Development and Training Office can assure a quality product and continued customer satisfaction.

Johnson, Melissa S.↗

NASA NTRS2004

The Office of the Materials Division

I was assigned to the Materials Division, which consists of the following branches; the Advanced Metallics Branch/5120-RMM, Ceramics Branch/5130-RMC, Polymers Branch/5150-RMP, and the Durability and Protective Coatings Branch/5160-RMD. Mrs. Pamela Spinosi is my assigned mentor. She was assisted by Ms.Raysa Rodriguez/5100-RM and Mrs.Denise Prestien/5100-RM, who are both employed by InDyne, Inc. My primary assignment this past summer was working directly with Ms. Rodriguez, assisting her with setting up the Integrated Financial Management Program (IFMP) 5130-RMC/Branch procedures and logs. These duties consisted of creating various spreadsheets for each individual branch member, which were updated daily. It was not hard to familiarize myself with these duties since this is my second summer working with Ms Rodriguez at NASA Glenn Research Center. RMC ordering laboratory, supplies and equipment for the Basic Materials Laboratory (Building 106) using the IF'MP/Purchase Card (P-card), a NASA-wide software program. I entered into the IFMP/Travel and Requisitions System, new Travel Authorizations for the 5130-RMC Civil Servant Branch Members. I also entered and completed Travel Vouchers for the 5130-RMC Ceramics Branch. I assisted in the Division Office creating new Emergency Contact list for the Materials Division. I worked with Dr. Hugh Gray, the Division Chief, and Dr. Ajay Misra, the 5130-RMC Branch Chief, on priority action items, with a close deadline, for a large NASA Proposal. Another project was working closely with Ms. Rodriguez in organizing and preparing for Dr. Ajay K. Misra's SESCDP (two year detail). This consisted of organizing files, file folders, personal information, and recording all data material onto CD's and printing all presentations for display in binders. I attended numerous Branch meetings, and observed many changes in the Branch Management organization.

Ramsey, amanda J.↗