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 163 records · Page 9
All sourcesNASA NTRSDOE OSTI
NASA NTRS2004

A Three-fold Outlook of the Ultra-Efficient Engine Technology Program Office (UEET)

The Ultra-Efficient Engine Technology (UEET) Office at NASA Glenn Research Center is a part of the Aeronautics Directorate. Its vision is to develop and hand off revolutionary turbine engine propulsion technologies that will enable future generation vehicles over a wide range of flight speeds. There are seven different technology area projects of UEET. During my tenure at NASA Glenn Research Center, my assignment was to assist three different areas of UEET, simultaneously. I worked with Kathy Zona in Education Outreach, Lynn Boukalik in Knowledge Management, and Denise Busch with Financial Management. All of my tasks were related to the business side of UEET. As an intern with Education Outreach I created a word search to partner with an exhibit of a Turbine Engine developed out of the UEET office. This exhibit is a portable model that is presented to students of varying ages. The word search complies with National Standards for Education which are part of every science, engineering, and technology teachers curriculum. I also updated a Conference Planning/Workshop Excel Spreadsheet for the UEET Office. I collected and inputted facility overviews from various venues, both on and off site to determine where to hold upcoming conferences. I then documented which facilities were compliant with the Federal Emergency Management Agency's (FEMA) Hotel and Motel Fire Safety Act of 1990. The second area in which I worked was Knowledge Management. a large knowledge management system online which has extensive documentation that continually needs reviewing, updating, and archiving. Knowledge management is the ability to bring individual or team knowledge to an organizational level so that the information can be stored, shared, reviewed, archived. Livelink and a secure server are the Knowledge Management systems that UEET utilizes, Through these systems, I was able to obtain the documents needed for archiving. My assignment was to obtain intellectual property including reports, presentations, or any other documents related to the project. My next task was to document the author, date of creation, and all other properties of each document. To archive these documents I worked extensively with Microsoft Excel. different financial systems of accounting such as the SAP business accounting system. I also learned the best ways to present financial data and shadowed my mentor as she presented financial data to both UEET's project management and the Resources Analysis and Management Office (RAMO). I analyzed the June 2004 financial data of UEET and used Microsoft Excel to input the results of the data. This process made it easier to present the full cost of the project in the month of June. In addition I assisted in the End of the Year 2003 Reconciliation of Purchases of UEET.

Graham, La Quilia E.↗
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 NTRS2004

Book Out! An Inventory Story

The NASA Glenn Library is a science and engineering research library providing the most current books, journals, CD-ROM's and documents to support the study of aeronautics, space propulsion and power, communications technology, materials and structures and microgravity science. The GRC technical library also supports the research and development efforts of all scientists and engineers on site via full text electronic files, literature searching, technical reports, etc. As an intern in the NASA Glenn Library, I attempt to support these objectives through efficiently and effectively fulfilling the assignment that was given to me. The assignment that was relegated to me was to catalog National Advisory Committee for Aeronautics, NASA Technical Documents into NASA Galaxie. This process consists of holdings being added to existing Galaxie records, upgrades and editing done to the bibliographic records when needed, adding URL's into Galaxie when they were missing from the record. NASA ASAP and Digidoc was used to locate URL's of PDF's that were not in Galaxie. A spreadsheet of documents with no URL's were maintained. Also, a subject channel of web, fill-text, paid and free, journal and other subject specific pages were developed and expanded fiom current content of intranet pages. To expand upon the second half of my assignment, I was given the project of taking inventory of the library s book collection. I kept record of the books that were not accounted for on a master list I was given to work fiom and submitted them for correction and addition. I also made sure the books were placed in the appropriate order and made corrections to any discrepancies that existed between the master list and what was on the shelf. Upon completion of this assignment, I will have verified that 21,113 books were in the correct location, order and have the correct corresponding serial number and barcode. In conclusion, as of this date I have input around 750 documents into NASA Galaxie, inputting about half of the NASA Technical Documents into the system. The rest of my tenure in this program will consist of finishing the other half of the reports. In regard to the second assignment, I still have about three-quarters of the collection to record and correct.

Panait, Claudia M.↗
NASA NTRS2002

Solar Electric Propulsion Technologies Being Designed for Orbit Transfer Vehicle Applications

There is increasing interest in employing Solar Electric Propulsion (SEP) for new missions requiring transfer from low Earth orbit to the Earth-Moon Lagrange point, L1. Mission architecture plans place the Gateway Habitat at L1 in the 2011 to 2016 timeframe. The Gateway Habitat is envisioned to be used for Lunar exploration, space telescopes, and planetary mission staging. In these scenarios, an SEP stage, or "tug," is used to transport payloads to L1--such as the habitat module, lunar excursion and return vehicles, and chemical propellant for return crew trips. SEP tugs are attractive because they are able to efficiently transport large (less than 10,000 kg) payloads while minimizing propellant requirements. To meet the needs of these missions, a preliminary conceptual design for a general-purpose SEP tug was developed that incorporates several of the advanced space power and in-space propulsion technologies (such as high-power gridded ion and Hall thrusters, high-performance thin-film photovoltaics, lithium-ion batteries, and advanced high-voltage power processing) being developed at the NASA Glenn Research Center. A spreadsheet-based vehicle system model was developed for component sizing and is currently being used for mission planning. This model incorporates a low-thrust orbit transfer algorithm to make preliminary determinations of transfer times and propellant requirements. Results from this combined tug mass estimation and orbit transfer model will be used in a higher fidelity trajectory model to refine the analysis.

Sarver-Verhey, Timothy R.↗
NASA NTRS2005

A Reliability Model to Assess Reliability of Shuttle Derived Launch Vehicle and Next Generation Vehicles

One important thrust in NASA s space exploration vision is to improve the safety and reliability of future launch vehicles. A quantitative reliability model is an essential technical tool to evaluate launch vehicle reliability and to enhance launch vehicle configuration down selection and detailed designs. A quantitative reliability model that supports NASA's thrust has been developed and implemented in an MS Excel spreadsheet. The model addresses key reliability parameters, and provides for sensitivity analysis of various vehicle designs. This paper presents the specific elements of the model and examples of selected sensitivity analysis results. Reliability input parameters in the model include the following: 1. Main propulsion element failure probability; 2. Propulsion element catastrophic failure fraction (Cf). This is defined as the ratio of probability of uncontained failures over sum of probability of uncontained failures and contained failures); 3. Engine-out design vs. no-engine-out design; 4. Engine with redlines vs. no redlines; 5. Different levels of health management system implementation; 6. Launch Escape System (LES) reliability; and 7. Power level correlation with reliability. The sensitivity results will illustrate the impact of each of the above parameters on several reliability metrics: Loss of Mission (LOM), LOV (Loss of Vehicle) and Loss of Crew (LOC).

Huang, Zhao↗
NASA NTRS2002

Preliminary Sizing Completed for Single- Stage-To-Orbit Launch Vehicles Powered By Rocket-Based Combined Cycle Technology

Single-stage-to-orbit (SSTO) propulsion remains an elusive goal for launch vehicles. The physics of the problem is leading developers to a search for higher propulsion performance than is available with all-rocket power. Rocket-based combined cycle (RBCC) technology provides additional propulsion performance that may enable SSTO flight. Structural efficiency is also a major driving force in enabling SSTO flight. Increases in performance with RBCC propulsion are offset with the added size of the propulsion system. Geometrical considerations must be exploited to minimize the weight. Integration of the propulsion system with the vehicle must be carefully planned such that aeroperformance is not degraded and the air-breathing performance is enhanced. Consequently, the vehicle's structural architecture becomes one with the propulsion system architecture. Geometrical considerations applied to the integrated vehicle lead to low drag and high structural and volumetric efficiency. Sizing of the SSTO launch vehicle (GTX) is itself an elusive task. The weight of the vehicle depends strongly on the propellant required to meet the mission requirements. Changes in propellant requirements result in changes in the size of the vehicle, which in turn, affect the weight of the vehicle and change the propellant requirements. An iterative approach is necessary to size the vehicle to meet the flight requirements. GTX Sizer was developed to do exactly this. The governing geometry was built into a spreadsheet model along with scaling relationships. The scaling laws attempt to maintain structural integrity as the vehicle size is changed. Key aerodynamic relationships are maintained as the vehicle size is changed. The closed weight and center of gravity are displayed graphically on a plot of the synthesized vehicle. In addition, comprehensive tabular data of the subsystem weights and centers of gravity are generated. The model has been verified for accuracy with finite element analysis. The final trajectory was rerun using OTIS (Boeing Corporation's trajectory optimization software package), and the sizing output was incorporated into a solid model of the vehicle using PRO/Engineer computer-aided design software (Parametric Technology Corporation, Waltham, MA).

Roche, Joseph M.↗
NASA NTRS2005

Integration Of Launch Vehicle Simulation/Analysis Tools And Lunar Cargo Lander Design

Part 2, which will be discussed in this report, will discuss the development of a Lunar Cargo Lander (unmanned launch vehicle) that will transport usable payload from Trans- Lunar Injection to the moon. The Delta IV-Heavy was originally used to transport the Lunar Cargo Lander to TLI, but other launch vehicles have been studied. In order to uncover how much payload is possible to land on the moon, research was needed in order to design the sub-systems of the spacecraft. The report will discuss and compare the use of a hypergolic and cryogenic system for its main propulsion system. The guidance, navigation, control, telecommunications, thermal, propulsion, structure, mechanisms, landing gear, command, data handling, and electrical power sub-systems were designed by scaling off other flown orbiters and moon landers. Once all data was collected, an excel spreadsheet was created to accurately calculate the usable payload that will land on the moon along with detailed mass and volume estimating relations. As designed, The Lunar Cargo Lander can plant 5,400 lbm of usable payload on the moon using a hypergolic system and 7,400 lbm of usable payload on the moon using a cryogenic system.

DeJean, George Brian↗
NASA NTRS2004

Simplified computational approach for dual-probe heat-pulse method

Two equations are currently available for estimating soil volumetric heat capacity (pc) with the dual-probe heat-pulse (DPHP) method. One is simple but gives only approximate results because it assumes that the DPHP sensor releases an impulse of heat instantaneously. The other explicitly accounts for the finite duration of heating and gives exact results. Unfortunately, the equation that gives exact results involves the exponential integral function, which is not available in most computer spreadsheet software packages or data logger function libraries. In this note we introduce an approximation of the exact equation that contains only simple algebraic functions. The approximation consists of the first five terms of a Taylor series, which are written as a telescoped polynomial for computational purposes. For most applications of the DPHP method, the polynomial approximation gives estimates of pc that are at least an order of magnitude more accurate than estimates obtained from the simple equation based on instantaneous heating.

NASA Center JSC↗
NASA NTRS2005

Relevant Parameter Evolution in Team X Mission Concept Designs

The Advanced Projects Design Team, also known as Team X, is a concurrent engineering team that quickly and cheaply designs space mission architectures including the flight system and subsystems, the trajectory, and ground system. Through the use of ICEMaker, an Excel spreadsheet database, the parameters from each subsystem can be shared and used among the other subsystems. This allows for entire missions to be planned with only a few short design team sessions. Based on the results, the feasibility of the mission concept can be determined. Over the Years since the team was created, the amount of information being shared among subsystems on the database has increased, however many of the parameters are now obsolete. Removal of these unused parameters Will clean UP the database and help to streamline the mission design process. By comparing parameter files from previous Team X mission studies, the parameter usage can be determined. As was initially suspected there are more unused parameters on the database than parameters that are actually used.

Huelman, Brandon N.↗
NASA NTRS1993

(abstract) Generic Modeling of a Life Support System for Process Technology Comparisons

This paper describes a simulation model called the Life Support Systems Analysis Simulation Tool (LiSSA-ST), the spreadsheet program called the Life Support Systems Analysis Trade Tool (LiSSA-TT), and the Generic Modular Flow Schematic (GMFS) modeling technique. Results of using the LiSSA-ST and the LiSSA-TT will be presented for comparing life support systems and process technology options for a Lunar Base and a Mars Exploration Mission.

life support system long-duration missions simulat↗
NASA NTRS1993

Generic Modeling of a Life Support System for Process Technology Comparison

This paper describes a simulation model called the Life Support Systems Analysis Simulation Tool (LiSSA-ST), the spreadsheet program called the Life Support Systems Analysis Trade Tool (LiSSA-TT), and the Generic Modular Flow Schematic (GMFS) modeling technique. Results of using the LiSSA-ST and the LiSSA-TT will be presented for comparing life support system and process technology options for a Lunar Base with a crew size of 4 and mission lengths of 90 and 600 days. System configurations to minimize the life support system weight and power are explored.

lunar base life support systems processes simulati↗
NASA NTRS1992

LinkWinds: An Approach to Visual Data Analysis

The Linked Windows Interactive Data System (LinkWinds) is a prototype visual data exploration and analysis system resulting from a NASA/JPL program of research into graphical methods for rapidly accessing, displaying and analyzing large multivariate multidisciplinary datasets. It is an integrated multi-application execution environment allowing the dynamic interconnection of multiple windows containing visual displays and/or controls through a data-linking paradigm. This paradigm, which results in a system much like a graphical spreadsheet, is not only a powerful method for organizing large amounts of data for analysis, but provides a highly intuitive, easy to learn user interface on top of the traditional graphical user interface.

Jacobson, Allan S.↗
NASA NTRS2007

Process Improvement in a Radically Changing Organization

This presentation describes how the NASA Glenn Research Center planned and implemented a process improvement effort in response to a radically changing environment. As a result of a presidential decision to redefine the Agency's mission, many ongoing projects were canceled and future workload would be awarded based on relevance to the Exploration Initiative. NASA imposed a new Procedural Requirements standard on all future software development, and the Center needed to redesign its processes from CMM Level 2 objectives to meet the new standard and position itself for CMMI. The intended audience for this presentation is systems/software developers and managers in a large, research-oriented organization that may need to respond to imposed standards while also pursuing CMMI Maturity Level goals. A set of internally developed tools will be presented, including an overall Process Improvement Action Item database, a formal inspection/peer review tool, metrics collection spreadsheet, and other related technologies. The Center also found a need to charter Technical Working Groups (TWGs) to address particular Process Areas. In addition, a Marketing TWG was needed to communicate the process changes to the development community, including an innovative web site portal.

Varga, Denise M.↗
NASA NTRS2006

Cost Analysis for Large Civil Transport Rotorcraft

This paper presents cost analysis of purchase price and DOC+I (direct operating cost plus interest) that supports NASA s study of three advanced rotorcraft concepts that could enter commercial transport service within 10 to 15 years. The components of DOC+I are maintenance, flight crew, fuel, depreciation, insurance, and finance. The cost analysis aims at VTOL (vertical takeoff and landing) and CTOL (conventional takeoff and landing) aircraft suitable for regional transport service. The resulting spreadsheet-implemented cost models are semi-empirical and based on Department of Transportation and Army data from actual operations of such aircraft. This paper describes a rationale for selecting cost tech factors without which VTOL is more costly than CTOL by a factor of 10 for maintenance cost and a factor of two for purchase price. The three VTOL designs selected for cost comparisons meet the mission requirement to fly 1,200 nautical miles at 350 knots and 30,000 ft carrying 120 passengers. The lowest cost VTOL design is a large civil tilt rotor (LCTR) aircraft. With cost tech factors applied, the LCTR is reasonably competitive with the Boeing 737-700 when operated in economy regional service following the business model of the selected baseline operation, that of Southwest Airlines.

Coy, John J.↗
NASA NTRS2007

Organization's Orderly Interest Exploration: Inception, Development and Insights of AIAA's Topics Database

Since 2003, AIAA's Computer Systems and Software Systems Technical Committees (TCs) have developed a database that aids technical committee management to map technical topics to their members. This Topics/Interest (T/I) database grew out of a collection of charts and spreadsheets maintained by the TCs. Since its inception, the tool has evolved into a multi-dimensional database whose dimensions include the importance, interest and expertise of TC members and whether or not a member and/or a TC is actively involved with the topic. In 2005, the database was expanded to include the TCs in AIAA s Information Systems Group and then expanded further to include all AIAA TCs. It was field tested at an AIAA Technical Activities Committee (TAC) Workshop in early 2006 through live access by over 80 users. Through the use of the topics database, TC and program committee (PC) members can accomplish relevant tasks such as: to identify topic experts (for Aerospace America articles or external contacts), to determine the interest of its members, to identify overlapping topics between diverse TCs and PCs, to guide new member drives and to reveal emerging topics. This paper will describe the origins, inception, initial development, field test and current version of the tool as well as elucidate the benefits and insights gained by using the database to aid the management of various TC functions. Suggestions will be provided to guide future development of the database for the purpose of providing dynamics and system level benefits to AIAA that currently do not exist in any technical organization.

Marshall, Jospeh R.↗
NASA NTRS2007

Lessons Learned from Deploying an Analytical Task Management Database

Defining requirements, missions, technologies, and concepts for space exploration involves multiple levels of organizations, teams of people with complementary skills, and analytical models and simulations. Analytical activities range from filling a To-Be-Determined (TBD) in a requirement to creating animations and simulations of exploration missions. In a program as large as returning to the Moon, there are hundreds of simultaneous analysis activities. A way to manage and integrate efforts of this magnitude is to deploy a centralized database that provides the capability to define tasks, identify resources, describe products, schedule deliveries, and generate a variety of reports. This paper describes a web-accessible task management system and explains the lessons learned during the development and deployment of the database. Through the database, managers and team leaders can define tasks, establish review schedules, assign teams, link tasks to specific requirements, identify products, and link the task data records to external repositories that contain the products. Data filters and spreadsheet export utilities provide a powerful capability to create custom reports. Import utilities provide a means to populate the database from previously filled form files. Within a four month period, a small team analyzed requirements, developed a prototype, conducted multiple system demonstrations, and deployed a working system supporting hundreds of users across the aeros pace community. Open-source technologies and agile software development techniques, applied by a skilled team enabled this impressive achievement. Topics in the paper cover the web application technologies, agile software development, an overview of the system's functions and features, dealing with increasing scope, and deploying new versions of the system.

O'Neil, Daniel A.↗
NASA NTRS2006

Brush Seal Arrangement for the RS-68 Turbopump Set

The nature of the RS-68 turbopumps requires that the hydrogen seals separating the pump from the turbine must have extremely low levels of leakage and be contained in small packages. Conventional seal technologies are not able to reasonably satisfy such design requirements. A review of experimental measurements and analysis publications suggests that brush seals are well suited for the design requirements. Brush seals are shown to have less leakage than conventional labyrinth and damper seals and have no adverse effects on the rotordynamics of the machine. The bulk-flow analysis presented by Hendricks et al. is used as a guideline to create a spreadsheet that provides mass flow through the seal and heat generated by the rubbing contact of the bristles on the shaft. The analysis is anchored to published data for LN2 and LH2 leakage tests. Finally, the analysis is used to design seals for both applications. It is observed that the most important analysis parameter is the thickness of the bristle pack and its relationship to seal clearance, lay angle and pressure drop.

Nunez, D.↗
NASA NTRS2008

Facilitating Analysis of Multiple Partial Data Streams

Robotic Operations Automation: Mechanisms, Imaging, Navigation report Generation (ROAMING) is a set of computer programs that facilitates and accelerates both tactical and strategic analysis of time-sampled data especially the disparate and often incomplete streams of Mars Explorer Rover (MER) telemetry data described in the immediately preceding article. As used here, tactical refers to the activities over a relatively short time (one Martian day in the original MER application) and strategic refers to a longer time (the entire multi-year MER missions in the original application). Prior to installation, ROAMING must be configured with the types of data of interest, and parsers must be modified to understand the format of the input data (many example parsers are provided, including for general CSV files). Thereafter, new data from multiple disparate sources are automatically resampled into a single common annotated spreadsheet stored in a readable space-separated format, and these data can be processed or plotted at any time scale. Such processing or plotting makes it possible to study not only the details of a particular activity spanning only a few seconds, but also longer-term trends. ROAMING makes it possible to generate mission-wide plots of multiple engineering quantities [e.g., vehicle tilt as in Figure 1(a), motor current, numbers of images] that, heretofore could be found only in thousands of separate files. ROAMING also supports automatic annotation of both images and graphs. In the MER application, labels given to terrain features by rover scientists and engineers are automatically plotted in all received images based on their associated camera models (see Figure 2), times measured in seconds are mapped to Mars local time, and command names or arbitrary time-labeled events can be used to label engineering plots, as in Figure 1(b).

Maimone, Mark W.↗