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 307 records · Page 17

All sources NASA NTRS DOE OSTI

NASA NTRS1990

Managing Information On Costs

Cost Management Model, CMM, software tool for planning, tracking, and reporting costs and information related to costs. Capable of estimating costs, comparing estimated to actual costs, performing "what-if" analyses on estimates of costs, and providing mechanism to maintain data on costs in format oriented to management. Number of supportive cost methods built in: escalation rates, production-learning curves, activity/event schedules, unit production schedules, set of spread distributions, tables of rates and factors defined by user, and full arithmetic capability. Import/export capability possible with 20/20 Spreadsheet available on Data General equipment. Program requires AOS/VS operating system available on Data General MV series computers. Written mainly in FORTRAN 77 but uses SGU (Screen Generation Utility).

Taulbee, Zoe A.↗

NASA NTRS1990

Sensor performance analysis

The theory is described and the equations required to design are developed and the performance of electro-optical sensor systems that operate from the visible through the thermal infrared spectral regions are analyzed. Methods to compute essential optical and detector parameters, signal-to-noise ratio, MTF, and figures of merit such as NE delta rho and NE delta T are developed. A set of atmospheric tables are provided to determine scene radiance in the visible spectral region. The Planck function is used to determine radiance in the infrared. The equations developed were incorporated in a spreadsheet so that a wide variety of sensor studies can be rapidly and efficiently conducted.

Montgomery, H. E.↗

NASA NTRS1989

Knowledge-based control of an adaptive interface

The analysis, development strategy, and preliminary design for an intelligent, adaptive interface is reported. The design philosophy couples knowledge-based system technology with standard human factors approaches to interface development for computer workstations. An expert system has been designed to drive the interface for application software. The intelligent interface will be linked to application packages, one at a time, that are planned for multiple-application workstations aboard Space Station Freedom. Current requirements call for most Space Station activities to be conducted at the workstation consoles. One set of activities will consist of standard data management services (DMS). DMS software includes text processing, spreadsheets, data base management, etc. Text processing was selected for the first intelligent interface prototype because text-processing software can be developed initially as fully functional but limited with a small set of commands. The program's complexity then can be increased incrementally. The intelligent interface includes the operator's behavior and three types of instructions to the underlying application software are included in the rule base. A conventional expert-system inference engine searches the data base for antecedents to rules and sends the consequents of fired rules as commands to the underlying software. Plans for putting the expert system on top of a second application, a database management system, will be carried out following behavioral research on the first application. The intelligent interface design is suitable for use with ground-based workstations now common in government, industrial, and educational organizations.

Lachman, Roy↗

NASA NTRS1989

A 'figure-of-merit' approach to extraterrestrial resource utilization

An approach for interrelated optimizations in space missions that utilize extraterrestrial resources is developed, consisting in the concept of an overall mission 'figure-of-merit' leading to more realistic designs than through individual performance maximizations. After a brief discussion of this concept, the synthesis of four major components of any future space mission is considered. The four major components are: orbital mechanics of the transportation; performance of the rocket motors; support systems including power, thermal and process controls, and instruments; and in situ resource utilization plant equipment. The Mars Sample Return mission is the basis of an illustration of the proposed concept. A popular spreadsheet is used to quantitatively demonstrate the interdependent nature of the mission optimization. Future prospects are outlined, that promise great economy through extraterrestrial resource utilization and a quick evaluation technique.

Ramohalli, Kumar↗

NASA NTRS1990

A figure-of-merit approach to extraterrestrial resource utilization

A concept is developed for interrelated optimizations in space missions that utilize extraterrestrial resources. It is shown that isolated (component) optimizations may not result in the best mission. It is shown that substantial benefits can be had through less than the best propellants, propellant combinations, propulsion hardware, and actually, some waste in the traditional sense. One ready example is the possibility of discarding hydrogen produced extraterrestrially by water splitting and using only the oxygen to burn storable fuels. The gains in refrigeration and leak-proof equipment mass (elimination) outweigh the loss in specific impulse. After a brief discussion of this concept, the synthesis of the four major components of any future space mission is developed. The four components are: orbital mechanics of the transportation; performance of the rocket motor; support systems that include power; thermal and process controls, and instruments; and in situ resource utilization plant equipment. This paper's main aim is to develop the concept of a figure-of-merit for the mission. The Mars Sample Return Mission is used to illustrate the new concept. At this time, a popular spreadsheet is used to quantitatively indicate the interdependent nature of the mission optimization. Future prospects are outlined that promise great economy through extraterrestrial resource utilization and a technique for quickly evaluating the same.

Ramohalli, K.↗

NASA NTRS1990

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↗

NASA NTRS1991

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↗

NASA NTRS1990

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↗

NASA NTRS1992

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.↗

NASA NTRS1991

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.↗

NASA NTRS1992

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.↗

NASA NTRS1991

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.↗

NASA NTRS1992

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.↗

NASA NTRS1991

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.↗

NASA NTRS1992

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↗

NASA NTRS1992

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.↗

NASA NTRS1992

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.↗

NASA NTRS1991

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.↗