Search NASA⌕ Search

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.

At least 91 records · Page 5

Signal processing of spectroscopic data for engine diagnostic applications

A description is given of research based on a series of spectra taken from the Diagnostic Test Facility (DTF) plume at NASA-Stennis Space Center. The DTF was designed to obtain spectra scaling approximately to that of the SSME, yet allow full control of dopant and thruster conditions. DTF spectra were used in this research to develop a technique for quantitative identification of an alloy. A mathematically based identification technique was tried, with reasonable sucess for one-element alloys, and only fair success for a two-element alloy. This approach was found to have the simplicity required for DSP implementation, thus allowing real-time diagnosis as a possibility. Spreadsheets were organized to handle the proliferation of development equations required, which number about 50,000. The identification work reinforced the presence of nonlinearity to dopant level.

Nail, Bert↗

Further applications of a Figure-of-Merit in space missions

A redesigned figure-of-merit (FoM) approach is described with respect to its applications in projects that employ in situ resource utilization (ISRU) and advanced modular engines. The FoM considers long-term effects, reliability of hardware, and risks inherent to new technologies, as well as significant design parameters. A spreadsheet is utilized to describe the FoM by means of key mission characteristics and combinations of the characteristic inputs in terms of precise governing equations. Results of the FoMs for historical and Mars Sample Return (MSR) missions are given for the conventional mission as well as an ISRU mission for the MSR. A detailed description of the most effective Mars mission is presented, showing how different factors affect the FoM. The results demonstrate that the FoM gives quantitative results based on overall mission design, allowing intercomparisons of similar missions. The FoM can be used as a screening parameter by modifying aspects of the mission by means of the R-factor.

Preiss, Bruce↗

Modular, thermal bus-to-radiator integral heat exchanger design for Space Station Freedom

The baseline concept is introduced for the 'integral heat exchanger' (IHX) which is the interface of the two-phase thermal bus with the heat-rejecting radiator panels. A direct bus-to-radiator heat-pipe integral connection replaces the present interface hardware to reduce the weight and complexity of the heat-exchange mechanism. The IHX is presented in detail and compared to the baseline system assuming certain values for heat rejection, mass per unit width, condenser capacity, contact conductance, and assembly mass. The spreadsheet comparison can be used to examine a variety of parameters such as radiator length and configuration. The IHX is shown to permit the reduction of panel size and system mass in response to better conductance and packaging efficiency. The IHX is found to be a suitable heat-rejection system for the Space Station Freedom because it uses present technology and eliminates the interface mechanisms.

Chambliss, Joe↗

Computer-Assisted Scheduling System (COMPASS)

COMPASS is interactive planning and scheduling software system used like spreadsheet. System places activities only at feasible times, taking into consideration all constraints imposed upon activity and resources it requires. Version 1.4 written in Ada and contains standard X-Windows interfaces written in C.

Fox, Barry R.↗

Single wall penetration equations

Five single plate penetration equations are compared for accuracy and effectiveness. These five equations are two well-known equations (Fish-Summers and Schmidt-Holsapple), two equations developed by the Apollo project (Rockwell and Johnson Space Center (JSC), and one recently revised from JSC (Cour-Palais). They were derived from test results, with velocities ranging up to 8 km/s. Microsoft Excel software was used to construct a spreadsheet to calculate the diameters and masses of projectiles for various velocities, varying the material properties of both projectile and target for the five single plate penetration equations. The results were plotted on diameter versus velocity graphs for ballistic and spallation limits using Cricket Graph software, for velocities ranging from 2 to 15 km/s defined for the orbital debris. First, these equations were compared to each other, then each equation was compared with various aluminum projectile densities. Finally, these equations were compared with test results performed at JSC for the Marshall Space Flight Center. These equations predict a wide variety of projectile diameters at a given velocity. Thus, it is very difficult to choose the 'right' prediction equation. The thickness of a single plate could have a large variation by choosing a different penetration equation. Even though all five equations are empirically developed with various materials, especially for aluminum alloys, one cannot be confident in the shield design with the predictions obtained by the penetration equations without verifying by tests.

Hayashida, K. B.↗

Time management displays for shuttle countdown

The Intelligent Launch Decision Support System project is developing a Time Management System (TMS) for the NASA Test Director (NTD) to use for time management during Shuttle terminal countdown. TMS is being developed in three phases: an information phase; a tool phase; and an advisor phase. The information phase is an integrated display (TMID) of firing room clocks, of graphic timelines with Ground Launch Sequencer events, and of constraints. The tool phase is a what-if spreadsheet (TMWI) for devising plans for resuming from unplanned hold situations. It is tied to information in TMID, propagates constraints forward and backward to complete unspecified values, and checks the plan against constraints. The advisor phase is a situation advisor (TMSA), which proactively suggests tactics. A concept prototype for TMSA is under development. The TMID is currently undergoing field testing. Displays for TMID and TMWI are described. Descriptions include organization, rationale for organization, implementation choices and constraints, and use by NTD.

Beller, Arthur E.↗

Human life support during interplanetary travel and domicile. II - Generic Modular Flow Schematic modeling

This paper describes the Generic Modular Flow Schematic (GMFS) architecture capable of encompassing all functional elements of a physical/chemical life support system (LSS). The GMFS can be implemented to synthesize, model, analyze, and quantitatively compare many configurations of LSSs, from a simple, completely open-loop to a very complex closed-loop. The GMFS model is coded in ASPEN, a state-of-the-art chemical process simulation program, to accurately compute the material, heat, and power flow quantities for every stream in each of the subsystem functional elements (SFEs) in the chosen configuration of a life support system. The GMFS approach integrates the various SFEs and subsystems in a hierarchical and modular fashion facilitating rapid substitutions and reconfiguration of a life support system. The comprehensive ASPEN material and energy balance output is transferred to a systems and technology assessment spreadsheet for rigorous system analysis and trade studies.

Farral, Joseph F.↗

Repair-level analysis for Space Station Freedom

To assign repair or discard-at-failure designations for orbital replacement units (ORUs) used on Space Station Freedom Electric Power System (SSFEPS), new algorithms and methods were required. Unique parameters, such as upmass costs, extravehicular activity costs and intravehicular activity (IVA) costs specific to Space Station Freedom's maintenance concept were incorporated into the Repair-Level Analysis (RLA). Additional outputs were also required of the SSFEPS RLA that were not required of previous RLAs. These outputs included recommendations for the number of launches that an ORU should be capable of attaining and an economic basis for condemnation rate. These unique parameters were not addressable using existing RLA models: therefore, a new approach was developed. In addition, it was found that preemptive analysis could be performed using spreadsheet-based Boolean expressions to represent the logical condition of the items under analysis.

Chadwick, M.↗

Sizing the science data processing requirements for EOS

The methodology used in the compilation and synthesis of baseline science requirements associated with the 30 + EOS (Earth Observing System) instruments and over 2,400 EOS data products (both output and required input) proposed by EOS investigators is discussed. A brief background on EOS and the EOS Data and Information System (EOSDIS) is presented, and the approach is outlined in terms of a multilayer model. The methodology used to compile, synthesize, and tabulate requirements within the model is described. The principal benefit of this approach is the reduction of effort needed to update the analysis and maintain the accuracy of the science data processing requirements in response to changes in EOS platforms, instruments, data products, processing center allocations, or other model input parameters. The spreadsheets used in the model provide a compact representation, thereby facilitating review and presentation of the information content.

Wharton, Stephen W.↗

Techniques for optimal crop selection in a controlled ecological life support system

A Controlled Ecological Life Support System (CELSS) utilizes a plant's natural ability to regenerate air and water while being grown as a food source in a closed life support system. Current plant research is directed toward obtaining quantitative empirical data on the regenerative ability of each species of plant and the system volume and power requirements. Two techniques were adapted to optimize crop species selection while at the same time minimizing the system volume and power requirements. Each allows the level of life support supplied by the plants to be selected, as well as other system parameters. The first technique uses decision analysis in the form of a spreadsheet. The second method, which is used as a comparison with and validation of the first, utilizes standard design optimization techniques. Simple models of plant processes are used in the development of these methods.

Mccormack, Ann↗

Modelling global methane emissions from livestock: Biological and nutritional controls

The available observations of methane production from the literature have been compiled into a ruminant methane data base. This data base includes 400 treatment mean observations of methane losses from cattle and sheep, and minor numbers of measurements from other species. Methane loss varied from 2.0 to 11.6 percent of dietary gross energy. Measurements included describe the many different weights and physiological states of the animals fed and diets ranging from all forage to all concentrate diets or mixtures. An auxiliary spreadsheet lists approximately 1000 individual animal observations. Many important concepts have emerged from our query and analysis of this data set. The majority of the world's cattle, sheep, and goats under normal husbandry circumstances likely produce methane very close to 6 percent of their daily diets gross energy (2 percent of the diet by weight). Although individual animals or losses from specific dietary research circumstances can vary considerably, the average for the vast majority of groups of ruminant livestock are likely to fall between 5.5 to 6.5 percent. We must caution, however, that little experimental data is available for two-thirds of the world's ruminants in developing countries. Available evidence suggests similar percentage of emissions, but this supposition needs confirmation. More importantly, data is skimpy or unavailable to describe diet consumption, animal weight, and class distribution.

Johnson, Donald E.↗

Use of cyclic current reversal polarization voltammetry for investigating the relationship between corrosion resistance and heat-treatment induced variations in microstructures of 400 C martensitic stainless steels

Software for running a cyclic current reversal polarization voltammagram has been developed for use with a EG&G Princeton Applied Research Model 273 potentiostat/galvanostat system. The program, which controls the magnitude, direction and duration of an impressed galvanostatic current, will produce data in ASCII spreadsheets (Lotus, Quattro) for graphical representation of CCRPV voltammograms. The program was used to determine differences in corrosion resistance of 440 C martenstic stainless steel produced as a result of changes in microstructure effected by tempering. It was determined that tempering at all temperatures above 400 F resulted in increased polarizability of the material, with the increased likelihood that pitting would be initiated upon exposure to marine environments. These results will be used in development of remedial procedures for lowering the susceptibility of these alloys toward the stress corrosion cracking experienced in bearings used in high pressure oxygen turbopumps used in the main engines of space shuttle orbiters.

Ambrose, John R.↗

Operator-assisted planning and execution of proximity operations subject to operational constraints

Future multi-vehicle operations will involve multiple scenarios that will require a planning tool for the rapid, interactive creation of fuel-efficient trajectories. The planning process must deal with higher-order, non-linear processes involving dynamics that are often counter-intuitive. The optimization of resulting trajectories can be difficult to envision. An interaction proximity operations planning system is being developed to provide the operator with easily interpreted visual feedback of trajectories and constraints. This system is hosted on an IRIS 4D graphics platform and utilizes the Clohessy-Wiltshire equations. An inverse dynamics algorithm is used to remove non-linearities while the trajectory maneuvers are decoupled and separated in a geometric spreadsheet. The operator has direct control of the position and time of trajectory waypoints to achieve the desired end conditions. Graphics provide the operator with visualization of satisfying operational constraints such as structural clearance, plume impingement, approach velocity limits, and arrival or departure corridors. Primer vector theory is combined with graphical presentation to improve operator understanding of suggested automated system solutions and to allow the operator to review, edit, or provide corrective action to the trajectory plan.

Grunwald, Arthur J.↗

On-orbit operational scenarios, tools, and techniques

A derivation of OMV developed PC-based mission planning tools is described. Preliminary application of these tools was used to show that detailed description of events and mission modeling complexity can be accommodated easily. Also, spreadsheet models can be expanded to increase detail.

Jennings, Jerry↗

MIRAGE: The data acquisition, analysis, and display system

Developed for the NASA Johnson Space Center and Life Sciences Directorate by GE Government Services, the Microcomputer Integrated Real-time Acquisition Ground Equipment (MIRAGE) system is a portable ground support system for Spacelab life sciences experiments. The MIRAGE system can acquire digital or analog data. Digital data may be NRZ-formatted telemetry packets of packets from a network interface. Analog signal are digitized and stored in experimental packet format. Data packets from any acquisition source are archived to a disk as they are received. Meta-parameters are generated from the data packet parameters by applying mathematical and logical operators. Parameters are displayed in text and graphical form or output to analog devices. Experiment data packets may be retransmitted through the network interface. Data stream definition, experiment parameter format, parameter displays, and other variables are configured using spreadsheet database. A database can be developed to support virtually any data packet format. The user interface provides menu- and icon-driven program control. The MIRAGE system can be integrated with other workstations to perform a variety of functions. The generic capabilities, adaptability and ease of use make the MIRAGE a cost-effective solution to many experimental data processing requirements.

Rosser, Robert S.↗

A synthetic environment for visualization and planning of orbital maneuvers

An interactive proximity operations planning system, which allows on-site planning of fuel-efficient, multi-burn maneuvers in a potential multi-space-craft environment has been developed and tested. This display system most directly assists planning by providing visual feedback in a synthetic virtual space that aids visualization of trajectories and their constraints. Its most significant features include (1) an 'inverse dynamics' algorithm that removes control nonlinearities facing the operator and (2) a stack-oriented action-editor that reduces the order of control and creates, through a 'geometric spreadsheet,' the illusion of an inertially stable environment. This synthetic environment provides the user with control of relevant static and dynamic properties of way-points during small orbital changes allowing independent solutions to otherwise coupled problems of orbital maneuvering.

Ellis, Stephen R.↗

Design of a cooperative problem-solving system for enroute flight planning: An empirical study of its use by airline dispatchers

In a previous report, an empirical study of 30 pilots using the Flight Planning Testbed was reported. An identical experiment using the Flight Planning Testbed (FPT), except that 27 airline dispatchers were studied, is described. Five general questions were addressed in this study: (1) under what circumstances do the introduction of computer-generated suggestions (flight plans) influence the planning behavior of dispatchers (either in a beneficial or adverse manner); (2) what is the nature of such influences (i.e., how are the person's cognitive processes changed); (3) how beneficial are the general design concepts underlying FPT (use of a graphical interface, embedding graphics in a spreadsheet, etc.); (4) how effective are the specific implementation decisions made in realizing these general design concepts; and (5) how effectively do dispatchers evaluate situations requiring replanning, and how effectively do they identify appropriate solutions to these situations.

Smith, Philip J.↗

Space Transfer Concepts and Analyses for Exploration Missions. Technical Directive 12: Beamed Power Systems Study

Parametric models were constructed for Earth-based laser powered electric orbit transfer from low Earth orbit to geosynchronous orbit. These models were used to carry out performance, cost/benefit, and sensitivity analyses of laser-powered transfer systems including end-to-end life cycle cost analyses for complete systems. Comparisons with conventional orbit transfer systems were made indicating large potential cost savings for laser-powered transfer. Approximate optimization was done to determine best parameter values for the systems. Orbit transfer flights simulations were conducted to explore effects of parameters not practical to model with a spreadsheet. The simulations considered view factors that determine when power can be transferred from ground stations to an orbit transfer vehicle and conducted sensitivity analyses for numbers of ground stations, Isp including dual-Isp transfers, and plane change profiles. Optimal steering laws were used for simultaneous altitude and plane change. Viewing geometry and low-thrust orbit raising were simultaneously simulated. A very preliminary investigation of relay mirrors was made.

Eder, D.↗