Simulation of 2D Waves in Circular Membrane Using Excel Spreadsheet with Visual Basic for Teaching Activity

NASA Astrophysics Data System (ADS)

Eso, R.; Safiuddin, L. O.; Agusu, L.; Arfa, L. M. R. F.

2018-04-01

We propose a teaching instrument demonstrating the circular membrane waves using the excel interactive spreadsheets with the Visual Basic for Application (VBA) programming. It is based on the analytic solution of circular membrane waves involving Bessel function. The vibration modes and frequencies are determined by using Bessel approximation and initial conditions. The 3D perspective based on the spreadsheets functions and facilities has been explored to show the 3D moving objects in transitional or rotational processes. This instrument is very useful both in teaching activity and learning process of wave physics. Visualizing of the vibration of waves in the circular membrane which is showing a very clear manner of m and n vibration modes of the wave in a certain frequency has been compared and matched to the experimental result using resonance method. The peak of deflection varies in time if the initial condition was working and have the same pattern with matlab simulation in zero initial velocity

Forming Conjectures within a Spreadsheet Environment

ERIC Educational Resources Information Center

Calder, Nigel; Brown, Tony; Hanley, Una; Darby, Susan

2006-01-01

This paper is concerned with the use of spreadsheets within mathematical investigational tasks. Considering the learning of both children and pre-service teaching students, it examines how mathematical phenomena can be seen as a function of the pedagogical media through which they are encountered. In particular, it shows how pedagogical apparatus…

Spreadsheet Applications: Prototyping an Innovative Blended Course

ERIC Educational Resources Information Center

Baker, J. Howard

2004-01-01

After teaching the advanced spreadsheet course at a major university in Louisiana as a traditional classroom course for a number of years, it was decided to create a prototype-blended course, with a considerable portion offered via distance education. This research, which uses a prototyping methodology, is exploratory in nature. Prototyping can…

Triangular Plots and Spreadsheet Software.

ERIC Educational Resources Information Center

Holm, Paul Eric

1988-01-01

Describes how the limitations of the built-in graphics capabilities of spreadsheet software can be overcome by making full use of the flexibility of the grahics options. Uses triangular plots with labeled field boundaries produced using Lotus 1-2-3 to demonstrate these techniques and their use in teaching geology. (CW)

Dynamic Modeling for Development and Education: From Concepts to Numbers

ERIC Educational Resources Information Center

Van Geert, Paul

2014-01-01

The general aim of the article is to teach the reader how to transform conceptual models of change, development, and learning into mathematical expressions and how to use these equations to build dynamic models by means of the widely used spreadsheet program Excel. The explanation is supported by a number of Excel files, which the reader can…

Using Spreadsheets to Teach Aspects of Biology Involving Mathematical Models

ERIC Educational Resources Information Center

Carlton, Kevin; Nicholls, Mike; Ponsonby, David

2004-01-01

Some aspects of biology, for example the Hardy-Weinberg simulation of population genetics or modelling heat flow in lizards, have an undeniable mathematical basis. Students can find the level of mathematical skill required to deal with such concepts to be an insurmountable hurdle to understanding. If not used effectively, spreadsheet models…

Spreadsheets as a Transparent Resource for Learning the Mathematics of Annuities

ERIC Educational Resources Information Center

Pournara, Craig

2009-01-01

The ability of mathematics teachers to decompress mathematics and to move between representations are two key features of mathematical knowledge that is usable for teaching. This article reports on four pre-service secondary mathematics teachers learning the mathematics of annuities. In working with spreadsheets students began to make sense of…

Transition Matrices: A Tool to Assess Student Learning and Improve Instruction

ERIC Educational Resources Information Center

Morris, Gary A.; Walter, Paul; Skees, Spencer; Schwartz, Samantha

2017-01-01

This paper introduces a new spreadsheet tool for adoption by high school or college-level physics teachers who use common assessments in a pre-instruction/post-instruction mode to diagnose student learning and teaching effectiveness. The spreadsheet creates a simple matrix that identifies the percentage of students who select each possible…

Teaching with New Technology: Four "Early Majority" Teachers

ERIC Educational Resources Information Center

Pierce, Robyn; Stacey, Kaye

2013-01-01

This paper explores how four good teachers, who do not have a special interest in technology, meet the challenge of introducing the rapidly developing mathematics analysis software (e.g. spreadsheets, function graphers, symbolic algebra manipulation and dynamic geometry) into their classrooms. These teachers' practice is viewed through the…

Flipping the Classroom and Instructional Technology Integration in a College-Level Information Systems Spreadsheet Course

ERIC Educational Resources Information Center

Davies, Randall S.; Dean, Douglas L.; Ball, Nick

2013-01-01

The purpose of this research was to explore how technology can be used to teach technological skills and to determine what benefit "flipping" the classroom might have for students taking an introductory-level college course on spreadsheets in terms of student achievement and satisfaction with the class. A pretest posttest…

Designing Optical Spreadsheets-Technological Pedagogical Content Knowledge Simulation (S-TPACK): A Case Study of Pre-Service Teachers Course

ERIC Educational Resources Information Center

Thohir, M. Anas

2018-01-01

In the 21st century, the competence of instructional technological design is important for pre-service physics teachers. This case study described the pre-service physics teachers' design of optical spreadsheet simulation and evaluated teaching and learning the task in the classroom. The case study chose three of thirty pre-service teacher's…

Earthquake Magnitude: A Teaching Module for the Spreadsheets Across the Curriculum Initiative

NASA Astrophysics Data System (ADS)

Wetzel, L. R.; Vacher, H. L.

2006-12-01

Spreadsheets Across the Curriculum (SSAC) is a library of computer-based activities designed to reinforce or teach quantitative-literacy or mathematics concepts and skills in context. Each activity (called a "module" in the SSAC project) consists of a PowerPoint presentation with embedded Excel spreadsheets. Each module focuses on one or more problems for students to solve. Each student works through a presentation, thinks about the in-context problem, figures out how to solve it mathematically, and builds the spreadsheets to calculate and examine answers. The emphasis is on mathematical problem solving. The intention is for the in- context problems to span the entire range of subjects where quantitative thinking, number sense, and math non-anxiety are relevant. The self-contained modules aim to teach quantitative concepts and skills in a wide variety of disciplines (e.g., health care, finance, biology, and geology). For example, in the Earthquake Magnitude module students create spreadsheets and graphs to explore earthquake magnitude scales, wave amplitude, and energy release. In particular, students realize that earthquake magnitude scales are logarithmic. Because each step in magnitude represents a 10-fold increase in wave amplitude and approximately a 30-fold increase in energy release, large earthquakes are much more powerful than small earthquakes. The module has been used as laboratory and take-home exercises in small structural geology and solid earth geophysics courses with upper level undergraduates. Anonymous pre- and post-tests assessed students' familiarity with Excel as well as other quantitative skills. The SSAC library consists of 27 modules created by a community of educators who met for one-week "module-making workshops" in Olympia, Washington, in July of 2005 and 2006. The educators designed the modules at the workshops both to use in their own classrooms and to make available for others to adopt and adapt at other locations and in other classes. When fully developed, the module collection will be available at the on-line Science Education Resource Center at Carleton College, searchable by quantitative skill, subject area, and Excel level. The number of modules will continue to grow through individual efforts as well as an additional module-making workshop in July of 2007 facilitated by the Washington Center for Improving the Quality of Undergraduate Education.

Excel spreadsheet in teaching numerical methods

NASA Astrophysics Data System (ADS)

Djamila, Harimi

2017-09-01

One of the important objectives in teaching numerical methods for undergraduates’ students is to bring into the comprehension of numerical methods algorithms. Although, manual calculation is important in understanding the procedure, it is time consuming and prone to error. This is specifically the case when considering the iteration procedure used in many numerical methods. Currently, many commercial programs are useful in teaching numerical methods such as Matlab, Maple, and Mathematica. These are usually not user-friendly by the uninitiated. Excel spreadsheet offers an initial level of programming, which it can be used either in or off campus. The students will not be distracted with writing codes. It must be emphasized that general commercial software is required to be introduced later to more elaborated questions. This article aims to report on a teaching numerical methods strategy for undergraduates engineering programs. It is directed to students, lecturers and researchers in engineering field.

Teaching Modeling with Partial Differential Equations: Several Successful Approaches

ERIC Educational Resources Information Center

Myers, Joseph; Trubatch, David; Winkel, Brian

2008-01-01

We discuss the introduction and teaching of partial differential equations (heat and wave equations) via modeling physical phenomena, using a new approach that encompasses constructing difference equations and implementing these in a spreadsheet, numerically solving the partial differential equations using the numerical differential equation…

Forming conjectures within a spreadsheet environment

NASA Astrophysics Data System (ADS)

Calder, Nigel; Brown, Tony; Hanley, Una; Darby, Susan

2006-12-01

This paper is concerned with the use of spreadsheets within mathematical investigational tasks. Considering the learning of both children and pre-service teaching students, it examines how mathematical phenomena can be seen as a function of the pedagogical media through which they are encountered. In particular, it shows how pedagogical apparatus influence patterns of social interaction, and how this interaction shapes the mathematical ideas that are engaged with. Notions of conjecture, along with the particular faculty of the spreadsheet setting, are considered with regard to the facilitation of mathematical thinking. Employing an interpretive perspective, a key focus is on how alternative pedagogical media and associated discursive networks influence the way that students form and test informal conjectures.

Teaching Classic Probability Problems With Modern Digital Tools

ERIC Educational Resources Information Center

Abramovich, Sergei; Nikitin, Yakov Yu.

2017-01-01

This article is written to share teaching ideas about using commonly available computer applications--a spreadsheet, "The Geometer's Sketchpad", and "Wolfram Alpha"--to explore three classic and historically significant problems from the probability theory. These ideas stem from the authors' work with prospective economists,…

Computers in Science: Thinking Outside the Discipline.

ERIC Educational Resources Information Center

Hamilton, Todd M.

2003-01-01

Describes the Computers in Science course which integrates computer-related techniques into the science disciplines of chemistry, physics, biology, and Earth science. Uses a team teaching approach and teaches students how to solve chemistry problems with spreadsheets, identify minerals with X-rays, and chemical and force analysis. (Contains 14…

Teaching Accounting with Computers.

ERIC Educational Resources Information Center

Shaoul, Jean

This paper addresses the numerous ways that computers may be used to enhance the teaching of accounting and business topics. It focuses on the pedagogical use of spreadsheet software to improve the conceptual coverage of accounting principles and practice, increase student understanding by involvement in the solution process, and reduce the amount…

High Level Technology in a Low Level Mathematics Course.

ERIC Educational Resources Information Center

Schultz, James E.; Noguera, Norma

2000-01-01

Describes a teaching experiment in which spreadsheets and computer algebra systems were used to teach a low-level college consumer mathematics course. Students were successful in using different types of functions to solve a variety of problems drawn from real-world situations. Provides an existence proof that computer algebra systems can assist…

Histograms and Frequency Density.

ERIC Educational Resources Information Center

Micromath, 2003

2003-01-01

Introduces exercises on histograms and frequency density. Guides pupils to Discovering Important Statistical Concepts Using Spreadsheets (DISCUSS), created at the University of Coventry. Includes curriculum points, teaching tips, activities, and internet address (http://www.coventry.ac.uk/discuss/). (KHR)

Problem Solving with Spreadsheets.

ERIC Educational Resources Information Center

Catterall, P.; Lewis, R.

1985-01-01

Documents the educational use of spreadsheets through a description of exploratory work which utilizes spreadsheets to achieve the objectives of Conway's Game of Life, a scientific method game for the development of problem-solving techniques. The implementation and classroom use of the spreadsheet programs are discussed. (MBR)

Assessment of Spreadsheet-based Modules in a Physical Geology Course with Emphasis on the Effectiveness of the use of Excel

NASA Astrophysics Data System (ADS)

Lehto, H.; Vacher, H. L.

2013-12-01

Educators have used spreadsheets to teach math concepts for years. However, when spreadsheet-based modules began to be used to teach math and geology concepts at USF students found them difficult to use. Most often students expressed frustration that learning how to use Excel took precedence over learning the concepts presented in the modules. Was the Excel was getting in the way? To investigate this question, we placed students in Physical Geology courses into two groups: one group was given a set of modules that instructed them to use Excel for their calculations, while the modules given to the other group simple instructed them to do the calculations but they were not told what method to use. Our expectation was that students in the Non-Excel group would be less frustrated and thus attain a higher level of learning of the concepts presented in the modules. However, our results show that students had high gains for both the math and geology concepts presented in the modules whether Excel was used or not. We also tested the students' attitudes about the modules and the knowledge they gained and found that overall students were comfortable with the math and geology concepts presented in the modules, and most felt that the modules were worth their time; however they did not wish to complete any more modules. The only observed difference in gains was that students in the course led by the author of the modules had larger gains in knowledge versus those in the course led by another instructor. This difference may have been the result of differences in teaching style, such as the module author's mention and linking of the modules with lecture materials throughout the course. We believe that spreadsheet-based modules are a good tool for teaching math and geology concepts, as overall the students were confident in their new knowledge. We also found that the use of Excel within the module did not affect the learning outcomes. The one downside of this study was that after completing the modules the students did not wish to do any more, which may have to do with a strong tendency towards math avoidance.

Data acquisition and real-time control using spreadsheets: interfacing Excel with external hardware.

PubMed

Aliane, Nourdine

2010-07-01

Spreadsheets have become a popular computational tool and a powerful platform for performing engineering calculations. Moreover, spreadsheets include a macro language, which permits the inclusion of standard computer code in worksheets, and thereby enable developers to greatly extend spreadsheets' capabilities by designing specific add-ins. This paper describes how to use Excel spreadsheets in conjunction to Visual Basic for Application programming language to perform data acquisition and real-time control. Afterwards, the paper presents two Excel applications with interactive user interfaces developed for laboratory demonstrations and experiments in an introductory course in control. 2010 ISA. Published by Elsevier Ltd. All rights reserved.

Linear Discriminant Analysis on a Spreadsheet.

ERIC Educational Resources Information Center

Busbey, Arthur Bresnahan III

1989-01-01

Described is a software package, "Trapeze," within which a routine called LinDis can be used. Discussed are teaching methods, the linear discriminant model and equations, the LinDis worksheet, and an example. The set up for this routine is included. (CW)

Determining Faculty Staffing Using Lotus 1-2-3.

ERIC Educational Resources Information Center

Ebner, Stanley G.

1987-01-01

Discusses how to manipulate a database to create a spreadsheet which can be used to help decide which teaching areas are understaffed and by how much. Focuses on the use of the Lotus 1-2-3 database statistical functions. (TW)

On the Use of a Standard Spreadsheet to Model Physical Systems in School Teaching

ERIC Educational Resources Information Center

Quale, Andreas

2012-01-01

In the teaching of physics at upper secondary school level (K10-K12), the students are generally taught to solve problems analytically, i.e. using the dynamics describing a system (typically in the form of differential equations) to compute its evolution in time, e.g. the motion of a body along a straight line or in a plane. This reduces the scope…

Cognitive Skills, Domain Knowledge, and Self-Efficacy: Effects on Spreadsheet Quality

ERIC Educational Resources Information Center

Adkins, Joni K.

2011-01-01

Numerous studies have shown that spreadsheets used in companies often have errors which may affect the quality of the decisions made with these tools. Many businesses are unaware or choose to ignore the risks associated with spreadsheet use. The intent of this study was to learn more about the characteristics of spreadsheet end user developers,…

Numerical Stimulation of Multicomponent Chromatography Using Spreadsheets.

ERIC Educational Resources Information Center

Frey, Douglas D.

1990-01-01

Illustrated is the use of spreadsheet programs for implementing finite difference numerical simulations of chromatography as an instructional tool in a separations course. Discussed are differential equations, discretization and integration, spreadsheet development, computer requirements, and typical simulation results. (CW)

Computer Series, 86. Bits and Pieces, 35.

ERIC Educational Resources Information Center

Moore, John W., Ed.

1987-01-01

Describes eight applications of the use of computers in teaching chemistry. Includes discussions of audio frequency measurements of heat capacity ratios, quantum mechanics, ab initio calculations, problem solving using spreadsheets, simplex optimization, faradaic impedance diagrams, and the recording and tabulation of student laboratory data. (TW)

Idea Notebook: Wilderness Food Planning in the Computer Age.

ERIC Educational Resources Information Center

Drury, Jack K.

1986-01-01

Explains the use of a computer as a planning and teaching tool in wilderness trip food planning. Details use of master food list and spreadsheet software such as VisiCalc to provide shopping lists for food purchasing, cost analysis, and diet analysis. (NEC)

Differentiation from First Principles Using Spreadsheets

ERIC Educational Resources Information Center

Lim, Kieran F.

2008-01-01

In the teaching of calculus, the algebraic derivation of the derivative (gradient function) enables the student to obtain an analytic "global" gradient function. However, to the best of this author's knowledge, all current technology-based approaches require the student to obtain the derivative (gradient) at a single point by…

Student Computer Use in Selected Undergraduate Agriculture Courses: An Examination of Required Tasks.

ERIC Educational Resources Information Center

Johnson, Donald M.; Ferguson, James A.; Vokins, Nancy W.; Lester, Melissa L.

2000-01-01

Over 50% of faculty teaching undergraduate agriculture courses (n=58) required use of word processing, Internet, and electronic mail; less than 50% required spreadsheets, databases, graphics, or specialized software. They planned to maintain or increase required computer tasks in their courses. (SK)

Transition Matrices: A Tool to Assess Student Learning and Improve Instruction

NASA Astrophysics Data System (ADS)

Morris, Gary A.; Walter, Paul; Skees, Spencer; Schwartz, Samantha

2017-03-01

This paper introduces a new spreadsheet tool for adoption by high school or college-level physics teachers who use common assessments in a pre-instruction/post-instruction mode to diagnose student learning and teaching effectiveness. The spreadsheet creates a simple matrix that identifies the percentage of students who select each possible pre-/post-test answer combination on each question of the diagnostic exam. Leveraging analysis of the quality of the incorrect answer choices, one can order the answer choices from worst to best (i.e., correct), resulting in "transition matrices" that can provide deeper insight into student learning and the success or failure of the pedagogical approach than traditional analyses that employ dichotomous scoring.

On the Use of Spreadsheet Algebra Programs in the Professional Development of Teachers from Selected Township High Schools

ERIC Educational Resources Information Center

Gierdien, M. Faaiz

2014-01-01

This paper reports on the initial stages of a small-scale project involving the use of "spreadsheet algebra programs" in the professional development of eight teachers from three township high schools. In terms of the education context, the paper draws on social practice theory. It then details what is meant by spreadsheet algebra. An…

A document-centric approach for developing the tolAPC ontology.

PubMed

Blfgeh, Aisha; Warrender, Jennifer; Hilkens, Catharien M U; Lord, Phillip

2017-11-28

There are many challenges associated with ontology building, as the process often touches on many different subject areas; it needs knowledge of the problem domain, an understanding of the ontology formalism, software in use and, sometimes, an understanding of the philosophical background. In practice, it is very rare that an ontology can be completed by a single person, as they are unlikely to combine all of these skills. So people with these skills must collaborate. One solution to this is to use face-to-face meetings, but these can be expensive and time-consuming for teams that are not co-located. Remote collaboration is possible, of course, but one difficulty here is that domain specialists use a wide-variety of different "formalisms" to represent and share their data - by the far most common, however, is the "office file" either in the form of a word-processor document or a spreadsheet. Here we describe the development of an ontology of immunological cell types; this was initially developed by domain specialists using an Excel spreadsheet for collaboration. We have transformed this spreadsheet into an ontology using highly-programmatic and pattern-driven ontology development. Critically, the spreadsheet remains part of the source for the ontology; the domain specialists are free to update it, and changes will percolate to the end ontology. We have developed a new ontology describing immunological cell lines built by instantiating ontology design patterns written programmatically, using values from a spreadsheet catalogue. This method employs a spreadsheet that was developed by domain experts. The spreadsheet is unconstrained in its usage and can be freely updated resulting in a new ontology. This provides a general methodology for ontology development using data generated by domain specialists.

Development of Spreadsheet-Based Integrated Transaction Processing Systems and Financial Reporting Systems

NASA Astrophysics Data System (ADS)

Ariana, I. M.; Bagiada, I. M.

2018-01-01

Development of spreadsheet-based integrated transaction processing systems and financial reporting systems is intended to optimize the capabilities of spreadsheet in accounting data processing. The purpose of this study are: 1) to describe the spreadsheet-based integrated transaction processing systems and financial reporting systems; 2) to test its technical and operational feasibility. This study type is research and development. The main steps of study are: 1) needs analysis (need assessment); 2) developing spreadsheet-based integrated transaction processing systems and financial reporting systems; and 3) testing the feasibility of spreadsheet-based integrated transaction processing systems and financial reporting systems. The technical feasibility include the ability of hardware and operating systems to respond the application of accounting, simplicity and ease of use. Operational feasibility include the ability of users using accounting applications, the ability of accounting applications to produce information, and control applications of the accounting applications. The instrument used to assess the technical and operational feasibility of the systems is the expert perception questionnaire. The instrument uses 4 Likert scale, from 1 (strongly disagree) to 4 (strongly agree). Data were analyzed using percentage analysis by comparing the number of answers within one (1) item by the number of ideal answer within one (1) item. Spreadsheet-based integrated transaction processing systems and financial reporting systems integrate sales, purchases, and cash transaction processing systems to produce financial reports (statement of profit or loss and other comprehensive income, statement of changes in equity, statement of financial position, and statement of cash flows) and other reports. Spreadsheet-based integrated transaction processing systems and financial reporting systems is feasible from the technical aspects (87.50%) and operational aspects (84.17%).

The Use of Microcomputers in Distance Teaching Systems. ZIFF Papiere 70.

ERIC Educational Resources Information Center

Rumble, Greville

Microcomputers have revolutionized distance education in virtually every area. Used alone, personal computers provide students with a wide range of utilities, including word processing, graphics packages, and spreadsheets. When linked to a mainframe computer or connected to other personal computers in local area networks, microcomputers can…

Peer Taught Microcomputer Skills: An Untapped Resource for Stretching the Budget.

ERIC Educational Resources Information Center

Teer, Harold B., Jr.; And Others

1988-01-01

Discussion of the use of peer teachers to provide college students with microcomputer education focuses on a video course used to teach Lotus 1-2-3 spreadsheet software. Budget considerations are discussed, student and faculty reactions are described, and potential time savings to faculty are examined. (LRW)

Making One-Computer Teaching Fun!

ERIC Educational Resources Information Center

Tan, Soo Boo

1998-01-01

Most teachers face the challenge of bringing technology into classrooms with only one computer. This article describes how one computer can serve the needs of many students: connecting it to a TV or projection device to display agendas, Web sites, microscope slides and other scientific instruments, and spreadsheets; tabulate data; deliver…

Teaching Quality Control with Chocolate Chip Cookies

ERIC Educational Resources Information Center

Baker, Ardith

2014-01-01

Chocolate chip cookies are used to illustrate the importance and effectiveness of control charts in Statistical Process Control. By counting the number of chocolate chips, creating the spreadsheet, calculating the control limits and graphing the control charts, the student becomes actively engaged in the learning process. In addition, examining…

Have More Fun Teaching Physics: Simulating, Stimulating Software.

ERIC Educational Resources Information Center

Jenkins, Doug

1996-01-01

High school physics offers opportunities to use problem solving and lab practices as well as cement skills in research, technical writing, and software applications. Describes and evaluates computer software enhancing the high school physics curriculum including spreadsheets for laboratory data, all-in-one simulators, projectile motion simulators,…

How to Teach Hicksian Compensation and Duality Using a Spreadsheet Optimizer

ERIC Educational Resources Information Center

Ghosh, Satyajit; Ghosh, Sarah

2007-01-01

Principle of duality and numerical calculation of income and substitution effects under Hicksian Compensation are often left out of intermediate microeconomics courses because they require a rigorous calculus based analysis. But these topics are critically important for understanding consumer behavior. In this paper we use excel solver--a…

Manipulative and Numerical Spreadsheet Templates for the Study of Discrete Structures.

ERIC Educational Resources Information Center

Abramovich, Sergei

1998-01-01

Argues that basic components of discrete mathematics can be introduced to students through gradual elaboration of experiences with iconic spreadsheet-based simulations of concrete materials. Suggests that the study of homogeneous and heterogeneous patterns of manipulative spreadsheet templates allows for appreciation of the development of…

Computer Supported Collaborative Rocketry: Teaching students to distinguish good and bad data like expert physicists

NASA Astrophysics Data System (ADS)

d'Alessio, Matthew; Lundquist, Loraine

2013-10-01

Each year our physical science class for pre-service elementary teachers launches water-powered rockets based on the activity from NASA. We analyze the rocket flight using data from frame-by-frame video analysis of the launches. Before developing the methods presented in this paper, we noticed our students were mired in calculation details while losing sight of physical concepts. Sloppy measurements and calculations (even when using spreadsheets with formulas provided) sometimes led to such poor results that physical concepts could not be reliably taught from the data, but students were unmotivated to either notice or correct their errors. We adopted a collaborative, computer supported approach using simple and easily available functions in Google Spreadsheets to pool observations, provide instant feedback, and publicly display results from all teams side-by-side in real time. These instant comparisons promote student accountability and engagement, inspiring them to think more carefully about why answers may be different and notice sloppy data or unlikely outcomes—in short, to facilitate and motivate expert thinking about data.

Spreadsheet Modeling of Electron Distributions in Solids

ERIC Educational Resources Information Center

Glassy, Wingfield V.

2006-01-01

A series of spreadsheet modeling exercises constructed as part of a new upper-level elective course on solid state materials and surface chemistry is described. The spreadsheet exercises are developed to provide students with the opportunity to interact with the conceptual framework where the role of the density of states and the Fermi-Dirac…

A simple geometrical model describing shapes of soap films suspended on two rings

NASA Astrophysics Data System (ADS)

Herrmann, Felix J.; Kilvington, Charles D.; Wildenberg, Rebekah L.; Camacho, Franco E.; Walecki, Wojciech J.; Walecki, Peter S.; Walecki, Eve S.

2016-09-01

We measured and analysed the stability of two types of soap films suspended on two rings using the simple conical frusta-based model, where we use common definition of conical frustum as a portion of a cone that lies between two parallel planes cutting it. Using frusta-based we reproduced very well-known results for catenoid surfaces with and without a central disk. We present for the first time a simple conical frusta based spreadsheet model of the soap surface. This very simple, elementary, geometrical model produces results surprisingly well matching the experimental data and known exact analytical solutions. The experiment and the spreadsheet model can be used as a powerful teaching tool for pre-calculus and geometry students.

Measuring Assurance of Learning Goals: Effectiveness of Computer Training and Assessment Tools

ERIC Educational Resources Information Center

Murphy, Marianne C.; Sharma, Aditya; Rosso, Mark

2012-01-01

Teaching office applications such as word processing, spreadsheet and presentation skills has been widely debated regarding its necessity, extent and delivery method. Training and Assessment applications such as MyITLab, SAM, etc. are popular tools for training students and are particularly useful in measuring Assurance of Learning (AOL)…

Introduction to Financial Projection Models. Business Management Instructional Software.

ERIC Educational Resources Information Center

Pomeroy, Robert W., III

This guidebook and teacher's guide accompany a personal computer software program and introduce the key elements of financial projection modeling to project the financial statements of an industrial enterprise. The student will then build a model on an electronic spreadsheet. The guidebook teaches the purpose of a financial model and the steps…

Using Spreadsheet Modeling to Teach Exchange Curves (Optimal Policy Curves) in Inventory Management

ERIC Educational Resources Information Center

Strakos, Joshua K.

2016-01-01

Inventory management is widely researched and the topic is taught in business programs across the spectrum of operations and supply chain management. However, the concepts are notoriously difficult for students to practice once they finish school and become managers responsible for inventory control. This article explains the structure and details…

Spreadsheet Modeling of (Q,R) Inventory Policies

ERIC Educational Resources Information Center

Cobb, Barry R.

2013-01-01

This teaching brief describes a method for finding an approximately optimal combination of order quantity and reorder point in a continuous review inventory model using a discrete expected shortage calculation. The technique is an alternative to a model where expected shortage is calculated by integration, and can allow students who have not had a…

An Innovative Spreadsheet Application to Teach Management Science Decision Criteria

ERIC Educational Resources Information Center

Hozak, Kurt

2018-01-01

This article describes a Microsoft Excel-based application that uses humorous voice synthesis and timed competition to make it more fun and engaging to learn management science decision criteria. In addition to providing immediate feedback and easily customizable tips that facilitate self-learning, the software randomly generates both the problem…

How to Teach Programming Indirectly--Using Spreadsheet Application

ERIC Educational Resources Information Center

Tahy, Zsuzsanna Szalayné

2016-01-01

It is a question in many countries whether ICT and application usage should be taught. There are some problems with IT literacy: users do not understand the concepts of a software, they cannot solve problems, and moreover, using applications gives them more problems. Consequently, using ICT seems to slow work down. Experts suggest learning…

Integrated Spreadsheets as a Paradigm of Type II Technology Applications in Mathematics Teacher Education

ERIC Educational Resources Information Center

Abramovich, Sergei

2016-01-01

The paper presents the use of spreadsheets integrated with digital tools capable of symbolic computations and graphic constructions in a master's level capstone course for secondary mathematics teachers. Such use of spreadsheets is congruent with the Type II technology applications framework aimed at the development of conceptual knowledge in the…

Enhancing Teaching using MATLAB Add-Ins for Excel

ERIC Educational Resources Information Center

Hamilton, Paul V.

2004-01-01

In this paper I will illustrate how to extend the capabilities of Microsoft Excel spreadsheets with add-ins created by MATLAB. Excel provides a broad array of fundamental tools but often comes up short when more sophisticated scenarios are involved. To overcome this short-coming of Excel while retaining its ease of use, I will describe how…

Using a Readily Available Commercial Spreadsheet to Teach a Graduate Course on Chemical Process Simulation

ERIC Educational Resources Information Center

Clarke, Matthew A.; Giraldo, Carlos

2009-01-01

Chemical process simulation is one of the most fundamental skills that is expected from chemical engineers, yet relatively few graduates have the opportunity to learn, in depth, how a process simulator works, from programming the unit operations to the sequencing. The University of Calgary offers a "hands-on" postgraduate course in…

An Excel Spreadsheet for a One-Dimensional Fourier Map in X-ray Crystallography

ERIC Educational Resources Information Center

Clegg, William

2004-01-01

The teaching of crystal structure determination with single-crystal X-ray diffraction at undergraduate level faces numerous challenges. Single-crystal X-ray diffraction is used in a vast range of chemical research projects and forms the basis for a high proportion of structural results that are presented to high-school, undergraduate, and graduate…

The Agony and the Ecstasy: Teaching Marketing Metrics to Undergraduate Business Students

ERIC Educational Resources Information Center

Saber, Jane Lee; Foster, Mary K.

2011-01-01

The marketing department of a large business school introduced a new undergraduate course, marketing metrics and analysis. The main materials for this course consisted of a series of online spreadsheets with embedded text and practice problems, a 32-page online metrics primer that included assurance of learning questions and a sample examination…

Performing an Event Study: An Exercise for Finance Students

ERIC Educational Resources Information Center

Reese, William A., Jr.; Robins, Russell P.

2017-01-01

This exercise helps instructors teach students how to perform a simple event study. The study tests to see if stocks earn abnormal returns when added to the S&P 500. Students select a random sample of stocks that were added to the index between January 2000 and July 2015. The accompanying spreadsheet calculates cumulative abnormal returns and…

DARPA Initiative in Concurrent Engineering (DICE). Phase 2

DTIC Science & Technology

1990-07-31

XS spreadsheet tool " Q-Calc spreadsheet tool " TAE+ outer wrapper for XS • Framemaker-based formal EDN (Electronic Design Notebook) " Data...shared global object space and object persistence. Technical Results Module Development XS Integration Environment A prototype of the wrapper concepts...for a spreadsheet integration environment, using an X-Windows based extensible Lotus 1-2-3 emulation called XS , and was (initially) targeted for

CALCULATIONAL TOOL FOR SKIN CONTAMINATION DOSE ESTIMATE

DOE Office of Scientific and Technical Information (OSTI.GOV)

HILL, R.L.

2005-03-31

A spreadsheet calculational tool was developed to automate the calculations performed for estimating dose from skin contamination. This document reports on the design and testing of the spreadsheet calculational tool.

NetpathXL - An Excel Interface to the Program NETPATH

USGS Publications Warehouse

Parkhurst, David L.; Charlton, Scott R.

2008-01-01

NetpathXL is a revised version of NETPATH that runs under Windows? operating systems. NETPATH is a computer program that uses inverse geochemical modeling techniques to calculate net geochemical reactions that can account for changes in water composition between initial and final evolutionary waters in hydrologic systems. The inverse models also can account for the isotopic composition of waters and can be used to estimate radiocarbon ages of dissolved carbon in ground water. NETPATH relies on an auxiliary, database program, DB, to enter the chemical analyses and to perform speciation calculations that define total concentrations of elements, charge balance, and redox state of aqueous solutions that are then used in inverse modeling. Instead of DB, NetpathXL relies on Microsoft Excel? to enter the chemical analyses. The speciation calculation formerly included in DB is implemented within the program NetpathXL. A program DBXL can be used to translate files from the old DB format (.lon files) to NetpathXL spreadsheets, or to create new NetpathXL spreadsheets. Once users have a NetpathXL spreadsheet with the proper format, new spreadsheets can be generated by copying or saving NetpathXL spreadsheets. In addition, DBXL can convert NetpathXL spreadsheets to PHREEQC input files. New capabilities in PHREEQC (version 2.15) allow solution compositions to be written to a .lon file, and inverse models developed in PHREEQC to be written as NetpathXL .pat and model files. NetpathXL can open NetpathXL spreadsheets, NETPATH-format path files (.pat files), and NetpathXL-format path files (.pat files). Once the speciation calculations have been performed on a spreadsheet file or a .pat file has been opened, the NetpathXL calculation engine is identical to the original NETPATH. Development of models and viewing results in NetpathXL rely on keyboard entry as in NETPATH.

Active Learning and Student Engagement in the Business Curriculum: Excel Can Be the Answer

ERIC Educational Resources Information Center

McCloskey, Donna W.; Bussom, Lisa

2013-01-01

Business educators are struggling with how better to engage their students in the learning process. At the same time, stakeholders are reporting that business students are ill prepared in problem solving techniques and the effective use of spreadsheets. The systemic use of Excel as a teaching tool in the business curriculum may be the answer to…

Resource Economics

NASA Astrophysics Data System (ADS)

Conrad, Jon M.

1999-10-01

Resource Economics is a text for students with a background in calculus, intermediate microeconomics, and a familiarity with the spreadsheet software Excel. The book covers basic concepts, shows how to set up spreadsheets to solve dynamic allocation problems, and presents economic models for fisheries, forestry, nonrenewable resources, stock pollutants, option value, and sustainable development. Within the text, numerical examples are posed and solved using Excel's Solver. Through these examples and additional exercises at the end of each chapter, students can make dynamic models operational, develop their economic intuition, and learn how to set up spreadsheets for the simulation of optimization of resource and environmental systems.

Resource Economics

NASA Astrophysics Data System (ADS)

Conrad, Jon M.

2000-01-01

Resource Economics is a text for students with a background in calculus, intermediate microeconomics, and a familiarity with the spreadsheet software Excel. The book covers basic concepts, shows how to set up spreadsheets to solve dynamic allocation problems, and presents economic models for fisheries, forestry, nonrenewable resources, stock pollutants, option value, and sustainable development. Within the text, numerical examples are posed and solved using Excel's Solver. These problems help make concepts operational, develop economic intuition, and serve as a bridge to the study of real-world problems of resource management. Through these examples and additional exercises at the end of Chapters 1 to 8, students can make dynamic models operational, develop their economic intuition, and learn how to set up spreadsheets for the simulation of optimization of resource and environmental systems. Book is unique in its use of spreadsheet software (Excel) to solve dynamic allocation problems Conrad is co-author of a previous book for the Press on the subject for graduate students Approach is extremely student-friendly; gives students the tools to apply research results to actual environmental issues

Building Your Own Regression Model

ERIC Educational Resources Information Center

Horton, Robert, M.; Phillips, Vicki; Kenelly, John

2004-01-01

Spreadsheets to explore regression with an algebra 2 class in a medium-sized rural high school are presented. The use of spreadsheets can help students develop sophisticated understanding of mathematical models and use them to describe real-world phenomena.

[Development of an Excel spreadsheet for meta-analysis of indirect and mixed treatment comparisons].

PubMed

Tobías, Aurelio; Catalá-López, Ferrán; Roqué, Marta

2014-01-01

Meta-analyses in clinical research usually aimed to evaluate treatment efficacy and safety in direct comparison with a unique comparator. Indirect comparisons, using the Bucher's method, can summarize primary data when information from direct comparisons is limited or nonexistent. Mixed comparisons allow combining estimates from direct and indirect comparisons, increasing statistical power. There is a need for simple applications for meta-analysis of indirect and mixed comparisons. These can easily be conducted using a Microsoft Office Excel spreadsheet. We developed a spreadsheet for indirect and mixed effects comparisons of friendly use for clinical researchers interested in systematic reviews, but non-familiarized with the use of more advanced statistical packages. The use of the proposed Excel spreadsheet for indirect and mixed comparisons can be of great use in clinical epidemiology to extend the knowledge provided by traditional meta-analysis when evidence from direct comparisons is limited or nonexistent.

Using Spreadsheets to Discover Meaning for Parameters in Nonlinear Models

ERIC Educational Resources Information Center

Green, Kris H.

2008-01-01

This paper explores the use of spreadsheets to develop an exploratory environment where mathematics students can develop their own understanding of the parameters of commonly encountered families of functions: linear, logarithmic, exponential and power. The key to this understanding involves opening up the definition of rate of change from the…

Parallel Structures of Computer-Assisted Signature Pedagogy: The Case of Integrated Spreadsheets

ERIC Educational Resources Information Center

Abramovich, Sergei; Easton, Jonathan; Hayes, Victoria O.

2012-01-01

This article was motivated by the authors' work on a project with a group of 2nd-grade students in a computer lab of a rural school in upstate New York. From this project, one goal of which was to provide a capstone experience for a teacher candidate in teaching application-oriented mathematics with technology, the ideas about parallel structures…

Standard Evaluation Procedures (SEPs) and Data Entry Spreadsheet Templates (DESTs) for Endocrine Disruptor Screening Program (EDSP) Tier 1 Assays

EPA Pesticide Factsheets

This page provides information and access to Standard Evaluation Procedures (SEPs) and Data Entry Spreadsheet Templates (DESTs) developed by EPA's Office of Chemical Safety and Pollution Prevention (OCSPP).

Use of a Spreadsheet to Calculate the Net Charge of Peptides and Proteins as a Function of pH: An Alternative to Using "Canned" Programs to Estimate the Isoelectric Point of These Important Biomolecules

ERIC Educational Resources Information Center

Sims, Paul A.

2010-01-01

An approach is presented that utilizes a spreadsheet to allow students to explore different means of calculating and visualizing how the charge on peptides and proteins varies as a function of pH. In particular, the concept of isoelectric point is developed to allow students to compare the results of their spreadsheet calculations with those of…

Carbon footprint estimator, phase II : volume I - GASCAP model & volume II - technical appendices [technical brief].

DOT National Transportation Integrated Search

2014-03-01

This study resulted in the development of the GASCAP model (the Greenhouse Gas Assessment : Spreadsheet for Transportation Capital Projects). This spreadsheet model provides a user-friendly interface for determining the greenhouse gas (GHG) emissions...

A TOOL FOR PLANNING AERIAL PHOTOGRAPHY

EPA Science Inventory

abstract The U.S. EPAs Pacific Coastal Ecology Branch has developed a tool in the form of an Excel. spreadsheet that facilitates planning aerial photography missions. The spreadsheet accepts various input parameters such as desired photo-scale and boundary coordinates of the stud...

Interstellar journeys in human lifetimes: numerical computations

NASA Astrophysics Data System (ADS)

Riggs, Peter J.

2017-05-01

Contrary to some contemporary accounts, a spacecraft with low acceleration can reach speeds very close to the speed of light in just a few years. In support of the teaching of special relativity, an easy to use software application has been created which calculates the values for travel times and distances to astronomical objects for such a spacecraft. This spreadsheet application may be conveniently employed as a basis for class exercises.

SU-F-BRB-16: A Spreadsheet Based Automatic Trajectory GEnerator (SAGE): An Open Source Tool for Automatic Creation of TrueBeam Developer Mode Robotic Trajectories

DOE Office of Scientific and Technical Information (OSTI.GOV)

Etmektzoglou, A; Mishra, P; Svatos, M

Purpose: To automate creation and delivery of robotic linac trajectories with TrueBeam Developer Mode, an open source spreadsheet-based trajectory generation tool has been developed, tested and made freely available. The computing power inherent in a spreadsheet environment plus additional functions programmed into the tool insulate users from the underlying schema tedium and allow easy calculation, parameterization, graphical visualization, validation and finally automatic generation of Developer Mode XML scripts which are directly loadable on a TrueBeam linac. Methods: The robotic control system platform that allows total coordination of potentially all linac moving axes with beam (continuous, step-and-shoot, or combination thereof) becomesmore » available in TrueBeam Developer Mode. Many complex trajectories are either geometric or can be described in analytical form, making the computational power, graphing and programmability available in a spreadsheet environment an easy and ideal vehicle for automatic trajectory generation. The spreadsheet environment allows also for parameterization of trajectories thus enabling the creation of entire families of trajectories using only a few variables. Standard spreadsheet functionality has been extended for powerful movie-like dynamic graphic visualization of the gantry, table, MLC, room, lasers, 3D observer placement and beam centerline all as a function of MU or time, for analysis of the motions before requiring actual linac time. Results: We used the tool to generate and deliver extended SAD “virtual isocenter” trajectories of various shapes such as parameterized circles and ellipses. We also demonstrated use of the tool in generating linac couch motions that simulate respiratory motion using analytical parameterized functions. Conclusion: The SAGE tool is a valuable resource to experiment with families of complex geometric trajectories for a TrueBeam Linac. It makes Developer Mode more accessible as a vehicle to quickly translate research ideas into machine readable scripts without programming knowledge. As an open source initiative, it also enables researcher collaboration on future developments. I am a full time employee at Varian Medical Systems, Palo Alto, California.« less

A Spreadsheet-based GIS tool for planning aerial photography

EPA Science Inventory

The U.S.EPA's Pacific Coastal Ecology Branch has developed a tool which facilitates planning aerial photography missions. This tool is an Excel spreadsheet which accepts various input parameters such as desired photo-scale and boundary coordinates of the study area and compiles ...

Development of standardized air-blown coal gasifier/gas turbine concepts for future electric power systems, Volume 4

DOE Office of Scientific and Technical Information (OSTI.GOV)

Not Available

1991-02-01

This appendix is a compilation of work done to predict overall cycle performance from gasifier to generator terminals. A spreadsheet has been generated for each case to show flows within a cycle. The spreadsheet shows gaseous or solid composition of flow, temperature of flow, quantity of flow, and heat heat content of flow. Prediction of steam and gas turbine performance was obtained by the computer program GTPro. Outputs of all runs for each combined cycle reviewed has been added to this appendix. A process schematic displaying all flows predicted through GTPro and the spreadsheet is also added to this appendix.more » The numbered bubbles on the schematic correspond to columns on the top headings of the spreadsheet.« less

The Euler’s Graphical User Interface Spreadsheet Calculator for Solving Ordinary Differential Equations by Visual Basic for Application Programming

NASA Astrophysics Data System (ADS)

Gaik Tay, Kim; Cheong, Tau Han; Foong Lee, Ming; Kek, Sie Long; Abdul-Kahar, Rosmila

2017-08-01

In the previous work on Euler’s spreadsheet calculator for solving an ordinary differential equation, the Visual Basic for Application (VBA) programming was used, however, a graphical user interface was not developed to capture users input. This weakness may make users confuse on the input and output since those input and output are displayed in the same worksheet. Besides, the existing Euler’s spreadsheet calculator is not interactive as there is no prompt message if there is a mistake in inputting the parameters. On top of that, there are no users’ instructions to guide users to input the derivative function. Hence, in this paper, we improved previous limitations by developing a user-friendly and interactive graphical user interface. This improvement is aimed to capture users’ input with users’ instructions and interactive prompt error messages by using VBA programming. This Euler’s graphical user interface spreadsheet calculator is not acted as a black box as users can click on any cells in the worksheet to see the formula used to implement the numerical scheme. In this way, it could enhance self-learning and life-long learning in implementing the numerical scheme in a spreadsheet and later in any programming language.

Mediation of a Teacher's Development of Spreadsheets as an Instrument to Support Pupils' Inquiry in Mathematics

ERIC Educational Resources Information Center

Fuglestad, Anne Berit

2013-01-01

This paper presents a case of collaboration with three teachers and a didactician on task development within a developmental research project based on ideas of inquiry and learning community. The teachers' goal was to utilise a spreadsheet to orchestrate the pupils' investigations and build a library of tasks for the classroom. The focus is on one…

Students' Meaning Making in Science: Solving Energy Resource Problems in Virtual Worlds Combined with Spreadsheets to Develop Graphs

ERIC Educational Resources Information Center

Krange, Ingeborg; Arnseth, Hans Christian

2012-01-01

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

How To Use the Spreadsheet as a Tool in the Secondary School Mathematics Classroom. Second Edition (for Windows and Macintosh Operating Systems).

ERIC Educational Resources Information Center

Masalski, William J.

This book seeks to develop, enhance, and expand students' understanding of mathematics by using technology. Topics covered include the advantages of spreadsheets along with the opportunity to explore the 'what if?' type of questions encountered in the problem-solving process, enhancing the user's insight into the development and use of algorithms,…

Domestic Disasters and Geospatial Technology for the Defense Logistics Agency

DTIC Science & Technology

2014-12-01

total distance traveled and satisfy all fuel demands. This report used the Vehicle Routing Problem (VRP) Spreadsheet Solver, developed by Erdogan ...Security Affairs, 2(2), 5–10. Erdogan , G. (2013). VRP spreadsheet solver. Retrieved from VeRoLog: EURO Working Group on Vehicle Routing and Logistics

Hydroshear Simulation Lab Test 2

DOE Data Explorer

Bauer, Steve

2014-08-01

This data file is for test 2. In this test a sample of granite with a pre cut (man made fracture) is confined, heated and differential stress is applied. max temperature in this this system development test is 95C. test details on the spreadsheets--note thta there are 2 spreadsheets

Constructing Meanings and Utilities within Algebraic Tasks

ERIC Educational Resources Information Center

Ainley, Janet; Bills, Liz; Wilson, Kirsty

2004-01-01

The Purposeful Algebraic Activity project aims to explore the potential of spreadsheets in the introduction to algebra and algebraic thinking. We discuss two sub-themes within the project: tracing the development of pupils' construction of meaning for variable from arithmetic-based activity, through use of spreadsheets, and into formal algebra,…

CalTOX (registered trademark), A multimedia total exposure model spreadsheet user's guide. Version 4.0(Beta)

DOE Office of Scientific and Technical Information (OSTI.GOV)

McKone, T.E.; Enoch, K.G.

2002-08-01

CalTOX has been developed as a set of spreadsheet models and spreadsheet data sets to assist in assessing human exposures from continuous releases to multiple environmental media, i.e. air, soil, and water. It has also been used for waste classification and for setting soil clean-up levels at uncontrolled hazardous wastes sites. The modeling components of CalTOX include a multimedia transport and transformation model, multi-pathway exposure scenario models, and add-ins to quantify and evaluate uncertainty and variability. All parameter values used as inputs to CalTOX are distributions, described in terms of mean values and a coefficient of variation, rather than asmore » point estimates or plausible upper values such as most other models employ. This probabilistic approach allows both sensitivity and uncertainty analyses to be directly incorporated into the model operation. This manual provides CalTOX users with a brief overview of the CalTOX spreadsheet model and provides instructions for using the spreadsheet to make deterministic and probabilistic calculations of source-dose-risk relationships.« less

A Spreadsheet-Based Visualized Mindtool for Improving Students' Learning Performance in Identifying Relationships between Numerical Variables

ERIC Educational Resources Information Center

Lai, Chiu-Lin; Hwang, Gwo-Jen

2015-01-01

In this study, a spreadsheet-based visualized Mindtool was developed for improving students' learning performance when finding relationships between numerical variables by engaging them in reasoning and decision-making activities. To evaluate the effectiveness of the proposed approach, an experiment was conducted on the "phenomena of climate…

Simulating Satellite and Space Probe Motion at High School with Spreadsheets

ERIC Educational Resources Information Center

Benacka, Jan

2017-01-01

This paper gives an account of an experiment in which thirty-three high school students of ages 17-19 developed spreadsheet numerical models of satellite and space probe motion. The models are free to download. A survey was carried out to find out the students' opinion of the lessons.

Diary of a Conversion--Lotus 1-2-3 to Symphony 1.1.

ERIC Educational Resources Information Center

Dunnewin, Larry

1986-01-01

Describes the uses of Lotus 1-2-3 (a spreadsheet-graphics-database program created by Lotus Development Corporation) and Symphony 1.1 (a refinement and expansion of Symphony 1.01 providing memory efficiency, speed, ease of use, greater file compatibility). Spreadsheet and graphics capabilities, the use of windows, database environment, and…

Studying Faculty Flows Using an Interactive Spreadsheet Model. AIR 1997 Annual Forum Paper.

ERIC Educational Resources Information Center

Kelly, Wayne

This paper describes a spreadsheet-based faculty flow model developed and implemented at the University of Calgary (Canada) to analyze faculty retirement, turnover, and salary issues. The study examined whether, given expected faculty turnover, the current salary increment system was sustainable in a stable or declining funding environment, and…

Examining Errors in Simple Spreadsheet Modeling from Different Research Perspectives

ERIC Educational Resources Information Center

Kadijevich, Djordje M.

2012-01-01

By using a sample of 1st-year undergraduate business students, this study dealt with the development of simple (deterministic and non-optimization) spreadsheet models of income statements within an introductory course on business informatics. The study examined students' errors in doing this for business situations of their choice and found three…

Evolving Polygons and Spreadsheets: Connecting Mathematics across Grade Levels in Teacher Education

ERIC Educational Resources Information Center

Abramovich, Sergei; Brouwer, Peter

2009-01-01

This paper was prepared in response to the Conference Board of Mathematical Sciences recommendations for the preparation of secondary teachers. It shows how using trigonometry as a conceptual tool in spreadsheet-based applications enables one to develop mathematical understanding in the context of constructing geometric representations of unit…

Spreadsheets Answer "What If...?

ERIC Educational Resources Information Center

Pogge, Alfred F.; Lunetta, Vincent N.

1987-01-01

Demonstrates how a spreadsheet program can do calculations, freeing students to question, analyze data and learn science. Notes several popular spreadsheet programs. Gives an example using Lotus 1-2-3 spreadsheets for a sampling experiment in Biology. Shows other examples of spreadsheet use in laboratory activities. (CW)

When Spreadsheets Become Software - Quality Control Challenges and Approaches - 13360

DOE Office of Scientific and Technical Information (OSTI.GOV)

Fountain, Stefanie A.; Chen, Emmie G.; Beech, John F.

2013-07-01

As part of a preliminary waste acceptance criteria (PWAC) development, several commercial models were employed, including the Hydrologic Evaluation of Landfill Performance model (HELP) [1], the Disposal Unit Source Term - Multiple Species model (DUSTMS) [2], and the Analytical Transient One, Two, and Three-Dimensional model (AT123D) [3]. The results of these models were post-processed in MS Excel spreadsheets to convert the model results to alternate units, compare the groundwater concentrations to the groundwater concentration thresholds, and then to adjust the waste contaminant masses (based on average concentration over the waste volume) as needed in an attempt to achieve groundwater concentrationsmore » at the limiting point of assessment that would meet the compliance concentrations while maximizing the potential use of the landfill (i.e., maximizing the volume of projected waste being generated that could be placed in the landfill). During the course of the PWAC calculation development, one of the Microsoft (MS) Excel spreadsheets used to post-process the results of the commercial model packages grew to include more than 575,000 formulas across 18 worksheets. This spreadsheet was used to assess six base scenarios as well as nine uncertainty/sensitivity scenarios. The complexity of the spreadsheet resulted in the need for a rigorous quality control (QC) procedure to verify data entry and confirm the accuracy of formulas. (authors)« less

An Experimental Study in the Use of Computer-Based Instruction to Teach Automated Spreadsheet Functions

DTIC Science & Technology

1991-09-01

review of past CBI studies -was conducted to provide the researcher a theoretical knowledge base on the effectiveness and efficiency of CBI. A summary...Literature Review Findinms on Ways to Measure CBI Effectiveness and Efficiency. The literature included previously conducted CBI experiments, studies , and...nine choices on each main and submenu (14:16). 3) Allow the student to make a menu selection with upper or lower case entries (28:291). 4) Prevent

Development of standardized air-blown coal gasifier/gas turbine concepts for future electric power systems, Volume 4. Appendix C: Design and performance of standardized fixed bed air-blown gasifier IGCC systems for future electric power generation: Final report

DOE Office of Scientific and Technical Information (OSTI.GOV)

Not Available

1991-02-01

This appendix is a compilation of work done to predict overall cycle performance from gasifier to generator terminals. A spreadsheet has been generated for each case to show flows within a cycle. The spreadsheet shows gaseous or solid composition of flow, temperature of flow, quantity of flow, and heat heat content of flow. Prediction of steam and gas turbine performance was obtained by the computer program GTPro. Outputs of all runs for each combined cycle reviewed has been added to this appendix. A process schematic displaying all flows predicted through GTPro and the spreadsheet is also added to this appendix.more » The numbered bubbles on the schematic correspond to columns on the top headings of the spreadsheet.« less

Pre-Service Teachers' TPACK Competencies for Spreadsheet Integration: Insights from a Mathematics-Specific Instructional Technology Course

ERIC Educational Resources Information Center

Agyei, Douglas D.; Voogt, Joke M.

2015-01-01

This article explored the impact of strategies applied in a mathematics instructional technology course for developing technology integration competencies, in particular in the use of spreadsheets, in pre-service teachers. In this respect, 104 pre-service mathematics teachers from a teacher training programme in Ghana enrolled in the mathematics…

Using Spreadsheets in the Management, Analysis, and Reporting of Evaluation Data.

ERIC Educational Resources Information Center

Glowacki, Margaret L.; Rice, Richard L., Jr.

Currently available spreadsheet programs for microcomputers provide many features that can be very useful for evaluators and researchers. Some of the basic concepts involved in spreadsheet use are introduced, and information is provided on the use of spreadsheets in maintaining and analyzing evaluation data. The spreadsheet used in the discussion…

Implementing parallel spreadsheet models for health policy decisions: The impact of unintentional errors on model projections

PubMed Central

Bailey, Stephanie L.; Bono, Rose S.; Nash, Denis; Kimmel, April D.

2018-01-01

Background Spreadsheet software is increasingly used to implement systems science models informing health policy decisions, both in academia and in practice where technical capacity may be limited. However, spreadsheet models are prone to unintentional errors that may not always be identified using standard error-checking techniques. Our objective was to illustrate, through a methodologic case study analysis, the impact of unintentional errors on model projections by implementing parallel model versions. Methods We leveraged a real-world need to revise an existing spreadsheet model designed to inform HIV policy. We developed three parallel versions of a previously validated spreadsheet-based model; versions differed by the spreadsheet cell-referencing approach (named single cells; column/row references; named matrices). For each version, we implemented three model revisions (re-entry into care; guideline-concordant treatment initiation; immediate treatment initiation). After standard error-checking, we identified unintentional errors by comparing model output across the three versions. Concordant model output across all versions was considered error-free. We calculated the impact of unintentional errors as the percentage difference in model projections between model versions with and without unintentional errors, using +/-5% difference to define a material error. Results We identified 58 original and 4,331 propagated unintentional errors across all model versions and revisions. Over 40% (24/58) of original unintentional errors occurred in the column/row reference model version; most (23/24) were due to incorrect cell references. Overall, >20% of model spreadsheet cells had material unintentional errors. When examining error impact along the HIV care continuum, the percentage difference between versions with and without unintentional errors ranged from +3% to +16% (named single cells), +26% to +76% (column/row reference), and 0% (named matrices). Conclusions Standard error-checking techniques may not identify all errors in spreadsheet-based models. Comparing parallel model versions can aid in identifying unintentional errors and promoting reliable model projections, particularly when resources are limited. PMID:29570737

Implementing parallel spreadsheet models for health policy decisions: The impact of unintentional errors on model projections.

PubMed

Bailey, Stephanie L; Bono, Rose S; Nash, Denis; Kimmel, April D

2018-01-01

Spreadsheet software is increasingly used to implement systems science models informing health policy decisions, both in academia and in practice where technical capacity may be limited. However, spreadsheet models are prone to unintentional errors that may not always be identified using standard error-checking techniques. Our objective was to illustrate, through a methodologic case study analysis, the impact of unintentional errors on model projections by implementing parallel model versions. We leveraged a real-world need to revise an existing spreadsheet model designed to inform HIV policy. We developed three parallel versions of a previously validated spreadsheet-based model; versions differed by the spreadsheet cell-referencing approach (named single cells; column/row references; named matrices). For each version, we implemented three model revisions (re-entry into care; guideline-concordant treatment initiation; immediate treatment initiation). After standard error-checking, we identified unintentional errors by comparing model output across the three versions. Concordant model output across all versions was considered error-free. We calculated the impact of unintentional errors as the percentage difference in model projections between model versions with and without unintentional errors, using +/-5% difference to define a material error. We identified 58 original and 4,331 propagated unintentional errors across all model versions and revisions. Over 40% (24/58) of original unintentional errors occurred in the column/row reference model version; most (23/24) were due to incorrect cell references. Overall, >20% of model spreadsheet cells had material unintentional errors. When examining error impact along the HIV care continuum, the percentage difference between versions with and without unintentional errors ranged from +3% to +16% (named single cells), +26% to +76% (column/row reference), and 0% (named matrices). Standard error-checking techniques may not identify all errors in spreadsheet-based models. Comparing parallel model versions can aid in identifying unintentional errors and promoting reliable model projections, particularly when resources are limited.

Beyond the Mechanics of Spreadsheets: Using Design Instruction to Address Spreadsheet Errors

ERIC Educational Resources Information Center

Schneider, Kent N.; Becker, Lana L.; Berg, Gary G.

2017-01-01

Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting…

Probabilistic assessment methodology for continuous-type petroleum accumulations

USGS Publications Warehouse

Crovelli, R.A.

2003-01-01

The analytic resource assessment method, called ACCESS (Analytic Cell-based Continuous Energy Spreadsheet System), was developed to calculate estimates of petroleum resources for the geologic assessment model, called FORSPAN, in continuous-type petroleum accumulations. The ACCESS method is based upon mathematical equations derived from probability theory in the form of a computer spreadsheet system. ?? 2003 Elsevier B.V. All rights reserved.

Numerical Modelling with Spreadsheets as a Means to Promote STEM to High School Students

ERIC Educational Resources Information Center

Benacka, Jan

2016-01-01

The article gives an account of an experiment in which sixty-eight high school students of age 16 - 19 developed spreadsheet applications that simulated fall and projectile motion in the air. The students applied the Euler method to solve the governing differential equations. The aim was to promote STEM to the students and motivate them to study…

Exploring Customization in Higher Education: An Experiment in Leveraging Computer Spreadsheet Technology to Deliver Highly Individualized Online Instruction to Undergraduate Business Students

ERIC Educational Resources Information Center

Kunzler, Jayson S.

2012-01-01

This dissertation describes a research study designed to explore whether customization of online instruction results in improved learning in a college business statistics course. The study involved utilizing computer spreadsheet technology to develop an intelligent tutoring system (ITS) designed to: a) collect and monitor individual real-time…

Documentation of spreadsheets for the analysis of aquifer-test and slug-test data

USGS Publications Warehouse

Halford, Keith J.; Kuniansky, Eve L.

2002-01-01

Several spreadsheets have been developed for the analysis of aquifer-test and slug-test data. Each spreadsheet incorporates analytical solution(s) of the partial differential equation for ground-water flow to a well for a specific type of condition or aquifer. The derivations of the analytical solutions were previously published. Thus, this report abbreviates the theoretical discussion, but includes practical information about each method and the important assumptions for the applications of each method. These spreadsheets were written in Microsoft Excel 9.0 (use of trade names does not constitute endorsement by the USGS). Storage properties should not be estimated with many of the spreadsheets because most are for analyzing single-well tests. Estimation of storage properties from single-well tests is generally discouraged because single-well tests are affected by wellbore storage and by well construction. These non-ideal effects frequently cause estimates of storage to be erroneous by orders of magnitude. Additionally, single-well tests are not sensitive to aquifer-storage properties. Single-well tests include all slug tests (Bouwer and Rice Method, Cooper, Bredehoeft, Papadopulos Method, and van der Kamp Method), the Cooper-Jacob straight-line Method, Theis recovery-data analysis, Jacob-Lohman method for flowing wells in a confined aquifer, and the step-drawdown test. Multi-well test spreadsheets included in this report are; Hantush-Jacob Leaky Aquifer Method and Distance-Drawdown Methods. The distance-drawdown method is an equilibrium or steady-state method, thus storage cannot be estimated.

OntoMaton: a bioportal powered ontology widget for Google Spreadsheets.

PubMed

Maguire, Eamonn; González-Beltrán, Alejandra; Whetzel, Patricia L; Sansone, Susanna-Assunta; Rocca-Serra, Philippe

2013-02-15

Data collection in spreadsheets is ubiquitous, but current solutions lack support for collaborative semantic annotation that would promote shared and interdisciplinary annotation practices, supporting geographically distributed players. OntoMaton is an open source solution that brings ontology lookup and tagging capabilities into a cloud-based collaborative editing environment, harnessing Google Spreadsheets and the NCBO Web services. It is a general purpose, format-agnostic tool that may serve as a component of the ISA software suite. OntoMaton can also be used to assist the ontology development process. OntoMaton is freely available from Google widgets under the CPAL open source license; documentation and examples at: https://github.com/ISA-tools/OntoMaton.

Analytical resource assessment method for continuous (unconventional) oil and gas accumulations - The "ACCESS" Method

USGS Publications Warehouse

Crovelli, Robert A.; revised by Charpentier, Ronald R.

2012-01-01

The U.S. Geological Survey (USGS) periodically assesses petroleum resources of areas within the United States and the world. The purpose of this report is to explain the development of an analytic probabilistic method and spreadsheet software system called Analytic Cell-Based Continuous Energy Spreadsheet System (ACCESS). The ACCESS method is based upon mathematical equations derived from probability theory. The ACCESS spreadsheet can be used to calculate estimates of the undeveloped oil, gas, and NGL (natural gas liquids) resources in a continuous-type assessment unit. An assessment unit is a mappable volume of rock in a total petroleum system. In this report, the geologic assessment model is defined first, the analytic probabilistic method is described second, and the spreadsheet ACCESS is described third. In this revised version of Open-File Report 00-044 , the text has been updated to reflect modifications that were made to the ACCESS program. Two versions of the program are added as appendixes.

A Novel Real-Time Data Acquisition Using an Excel Spreadsheet in Pendulum Experiment Tool with Light-Based Timer

ERIC Educational Resources Information Center

Adhitama, Egy; Fauzi, Ahmad

2018-01-01

In this study, a pendulum experimental tool with a light-based timer has been developed to measure the period of a simple pendulum. The obtained data was automatically recorded in an Excel spreadsheet. The intensity of monochromatic light, sensed by a 3DU5C phototransistor, dynamically changes as the pendulum swings. The changed intensity varies…

Developing Students' Understanding of Co-Opetition and Multilevel Inventory Management Strategies in Supply Chains: An In-Class Spreadsheet Simulation Exercise

ERIC Educational Resources Information Center

Fetter, Gary; Shockley, Jeff

2014-01-01

Instructors look for ways to explain to students how supply chains can be constructed so that competing suppliers can work together to improve inventory management performance (i.e., a phenomenon known as co-opetition). An Excel spreadsheet-driven simulation is presented that models a complete multilevel supply chain system--customer, retailer,…

ThinTool: a spreadsheet model to evaluate fuel reduction thinning cost, net energy output, and nutrient impacts

Treesearch

Sang-Kyun Han; Han-Sup Han; William J. Elliot; Edward M. Bilek

2017-01-01

We developed a spreadsheet-based model, named ThinTool, to evaluate the cost of mechanical fuel reduction thinning including biomass removal, to predict net energy output, and to assess nutrient impacts from thinning treatments in northern California and southern Oregon. A combination of literature reviews, field-based studies, and contractor surveys was used to...

Determination of Needed Spreadsheet Competencies for Business Personnel in the Mid-South States.

ERIC Educational Resources Information Center

Rogers, Betty S.; Arn, Joseph V.

1993-01-01

A survey of 209 Mid-South businesses determined spreadsheet usage, what competencies are needed for entry-level and continued employment, and sources of spreadsheet training. Recommended that, because of their widespread use, spreadsheets should be taught to all business students. (Author/JOW)

Solving Optimization Problems with Spreadsheets

ERIC Educational Resources Information Center

Beigie, Darin

2017-01-01

Spreadsheets provide a rich setting for first-year algebra students to solve problems. Individual spreadsheet cells play the role of variables, and creating algebraic expressions for a spreadsheet to perform a task allows students to achieve a glimpse of how mathematics is used to program a computer and solve problems. Classic optimization…

Simulation Software's Effect on College Students Spreadsheet Project Scores

ERIC Educational Resources Information Center

Atkinson, J. Kirk; Thrasher, Evelyn H.; Coleman, Phillip D.

2011-01-01

The purpose of this study is to explore the potential impact of support materials on student spreadsheet skill acquisition. Specifically, this study examines the use of an online spreadsheet simulation tool versus a printed book across two independent student groups. This study hypothesizes that the online spreadsheet simulation tool will have a…

LICSS - a chemical spreadsheet in microsoft excel

PubMed Central

2012-01-01

Background Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Microsoft Excel environment. However, within this group, the performance of Excel is often compromised, particularly in terms of the number of compounds which can usefully be stored on a sheet. Summary LICSS is a lightweight chemical spreadsheet within Microsoft Excel for Windows. LICSS stores structures solely as Smiles strings. Chemical operations are carried out by calling Java code modules which use the CDK, JChemPaint and OPSIN libraries to provide cheminformatics functionality. Compounds in sheets or charts may be visualised (individually or en masse), and sheets may be searched by substructure or similarity. All the molecular descriptors available in CDK may be calculated for compounds (in batch or on-the-fly), and various cheminformatic operations such as fingerprint calculation, Sammon mapping, clustering and R group table creation may be carried out. We detail here the features of LICSS and how they are implemented. We also explain the design criteria, particularly in terms of potential corporate use, which led to this particular implementation. Conclusions LICSS is an Excel-based chemical spreadsheet with a difference: • It can usefully be used on sheets containing hundreds of thousands of compounds; it doesn't compromise the normal performance of Microsoft Excel • It is designed to be installed and run in environments in which users do not have admin privileges; installation involves merely file copying, and sharing of LICSS sheets invokes automatic installation • It is free and extensible LICSS is open source software and we hope sufficient detail is provided here to enable developers to add their own features and share with the community. PMID:22301088

LICSS - a chemical spreadsheet in microsoft excel.

PubMed

Lawson, Kevin R; Lawson, Jonty

2012-02-02

Representations of chemical datasets in spreadsheet format are important for ready data assimilation and manipulation. In addition to the normal spreadsheet facilities, chemical spreadsheets need to have visualisable chemical structures and data searchable by chemical as well as textual queries. Many such chemical spreadsheet tools are available, some operating in the familiar Microsoft Excel environment. However, within this group, the performance of Excel is often compromised, particularly in terms of the number of compounds which can usefully be stored on a sheet. LICSS is a lightweight chemical spreadsheet within Microsoft Excel for Windows. LICSS stores structures solely as Smiles strings. Chemical operations are carried out by calling Java code modules which use the CDK, JChemPaint and OPSIN libraries to provide cheminformatics functionality. Compounds in sheets or charts may be visualised (individually or en masse), and sheets may be searched by substructure or similarity. All the molecular descriptors available in CDK may be calculated for compounds (in batch or on-the-fly), and various cheminformatic operations such as fingerprint calculation, Sammon mapping, clustering and R group table creation may be carried out.We detail here the features of LICSS and how they are implemented. We also explain the design criteria, particularly in terms of potential corporate use, which led to this particular implementation. LICSS is an Excel-based chemical spreadsheet with a difference:• It can usefully be used on sheets containing hundreds of thousands of compounds; it doesn't compromise the normal performance of Microsoft Excel• It is designed to be installed and run in environments in which users do not have admin privileges; installation involves merely file copying, and sharing of LICSS sheets invokes automatic installation• It is free and extensibleLICSS is open source software and we hope sufficient detail is provided here to enable developers to add their own features and share with the community.

The Web as an educational tool for/in learning/teaching bioinformatics statistics.

PubMed

Oliver, J; Pisano, M E; Alonso, T; Roca, P

2005-12-01

Statistics provides essential tool in Bioinformatics to interpret the results of a database search or for the management of enormous amounts of information provided from genomics, proteomics and metabolomics. The goal of this project was the development of a software tool that would be as simple as possible to demonstrate the use of the Bioinformatics statistics. Computer Simulation Methods (CSMs) developed using Microsoft Excel were chosen for their broad range of applications, immediate and easy formula calculation, immediate testing and easy graphics representation, and of general use and acceptance by the scientific community. The result of these endeavours is a set of utilities which can be accessed from the following URL: http://gmein.uib.es/bioinformatica/statistics. When tested on students with previous coursework with traditional statistical teaching methods, the general opinion/overall consensus was that Web-based instruction had numerous advantages, but traditional methods with manual calculations were also needed for their theory and practice. Once having mastered the basic statistical formulas, Excel spreadsheets and graphics were shown to be very useful for trying many parameters in a rapid fashion without having to perform tedious calculations. CSMs will be of great importance for the formation of the students and professionals in the field of bioinformatics, and for upcoming applications of self-learning and continuous formation.

Finding P-Values for F Tests of Hypothesis on a Spreadsheet.

ERIC Educational Resources Information Center

Rochowicz, John A., Jr.

The calculation of the F statistic for a one-factor analysis of variance (ANOVA) and the construction of an ANOVA tables are easily implemented on a spreadsheet. This paper describes how to compute the p-value (observed significance level) for a particular F statistic on a spreadsheet. Decision making on a spreadsheet and applications to the…

Spreadsheets and Bulgarian goats

NASA Astrophysics Data System (ADS)

Sugden, Steve

2012-10-01

We consider a problem appearing in an Australian Mathematics Challenge in 2003. This article considers whether a spreadsheet might be used to model this problem, thus allowing students to explore its structure within the spreadsheet environment. It then goes on to reflect on some general principles of problem decomposition when the final goal is a successful and lucid spreadsheet implementation.

GeoRePORT Input Spreadsheet

DOE Office of Scientific and Technical Information (OSTI.GOV)

St. Onge, Melinda

The Geothermal Resource Portfolio Optimization and Reporting Tool (GeoRePORT) was developed as a way to distill large amounts of geothermal project data into an objective, reportable data set that can be used to communicate with experts and non-experts. GeoRePORT summarizes (1) resource grade and certainty and (2) project readiness. This Excel file allows users to easily navigate through the resource grade attributes, using drop-down menus to pick grades and project readiness, and then easily print and share the summary with others. This spreadsheet is the first draft, for which we are soliciting expert feedback. The spreadsheet will be updated basedmore » on this feedback to increase usability of the tool. If you have any comments, please feel free to contact us.« less

DataSpread: Unifying Databases and Spreadsheets.

PubMed

Bendre, Mangesh; Sun, Bofan; Zhang, Ding; Zhou, Xinyan; Chang, Kevin ChenChuan; Parameswaran, Aditya

2015-08-01

Spreadsheet software is often the tool of choice for ad-hoc tabular data management, processing, and visualization, especially on tiny data sets. On the other hand, relational database systems offer significant power, expressivity, and efficiency over spreadsheet software for data management, while lacking in the ease of use and ad-hoc analysis capabilities. We demonstrate DataSpread, a data exploration tool that holistically unifies databases and spreadsheets. It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL. DataSpread retains all the advantages of spreadsheets, including ease of use, ad-hoc analysis and visualization capabilities, and a schema-free nature, while also adding the advantages of traditional relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet. DataSpread needs to reason about and reconcile differences in the notions of schema, addressing of cells and tuples, and the current "pane" (which exists in spreadsheets but not in traditional databases), and support data modifications at both the front-end and the back-end. Our demonstration will center on our first and early prototype of the DataSpread, and will give the attendees a sense for the enormous data exploration capabilities offered by unifying spreadsheets and databases.

DataSpread: Unifying Databases and Spreadsheets

PubMed Central

Bendre, Mangesh; Sun, Bofan; Zhang, Ding; Zhou, Xinyan; Chang, Kevin ChenChuan; Parameswaran, Aditya

2015-01-01

Spreadsheet software is often the tool of choice for ad-hoc tabular data management, processing, and visualization, especially on tiny data sets. On the other hand, relational database systems offer significant power, expressivity, and efficiency over spreadsheet software for data management, while lacking in the ease of use and ad-hoc analysis capabilities. We demonstrate DataSpread, a data exploration tool that holistically unifies databases and spreadsheets. It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL. DataSpread retains all the advantages of spreadsheets, including ease of use, ad-hoc analysis and visualization capabilities, and a schema-free nature, while also adding the advantages of traditional relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet. DataSpread needs to reason about and reconcile differences in the notions of schema, addressing of cells and tuples, and the current “pane” (which exists in spreadsheets but not in traditional databases), and support data modifications at both the front-end and the back-end. Our demonstration will center on our first and early prototype of the DataSpread, and will give the attendees a sense for the enormous data exploration capabilities offered by unifying spreadsheets and databases. PMID:26900487

A simple node and conductor data generator for SINDA

NASA Technical Reports Server (NTRS)

Gottula, Ronald R.

1992-01-01

This paper presents a simple, automated method to generate NODE and CONDUCTOR DATA for thermal match modes. The method uses personal computer spreadsheets to create SINDA inputs. It was developed in order to make SINDA modeling less time consuming and serves as an alternative to graphical methods. Anyone having some experience using a personal computer can easily implement this process. The user develops spreadsheets to automatically calculate capacitances and conductances based on material properties and dimensional data. The necessary node and conductor information is then taken from the spreadsheets and automatically arranged into the proper format, ready for insertion directly into the SINDA model. This technique provides a number of benefits to the SINDA user such as a reduction in the number of hand calculations, and an ability to very quickly generate a parametric set of NODE and CONDUCTOR DATA blocks. It also provides advantages over graphical thermal modeling systems by retaining the analyst's complete visibility into the thermal network, and by permitting user comments anywhere within the DATA blocks.

The Evolution of Spreadsheets.

ERIC Educational Resources Information Center

Schuyler, Michael

1985-01-01

Discusses basic features and functions of spreadsheet programs and describes additional capabilities (editing, windowing, graphics, and word processing) of two second-generation spreadsheet programs: Lotus 1-2-3 and Symphony. (MBR)

Spreadsheet-Like Image Analysis

DTIC Science & Technology

1992-08-01

1 " DTIC AD-A254 395 S LECTE D, ° AD-E402 350 Technical Report ARPAD-TR-92002 SPREADSHEET-LIKE IMAGE ANALYSIS Paul Willson August 1992 U.S. ARMY...August 1992 4. TITLE AND SUBTITLE 5. FUNDING NUMBERS SPREADSHEET-LIKE IMAGE ANALYSIS 6. AUTHOR(S) Paul Willson 7. PERFORMING ORGANIZATION NAME(S) AND...14. SUBJECT TERMS 15. NUMBER OF PAGES Image analysis , nondestructive inspection, spreadsheet, Macintosh software, 14 neural network, signal processing

A quality-based cost model for new electronic systems and products

NASA Astrophysics Data System (ADS)

Shina, Sammy G.; Saigal, Anil

1998-04-01

This article outlines a method for developing a quality-based cost model for the design of new electronic systems and products. The model incorporates a methodology for determining a cost-effective design margin allocation for electronic products and systems and its impact on manufacturing quality and cost. A spreadsheet-based cost estimating tool was developed to help implement this methodology in order for the system design engineers to quickly estimate the effect of design decisions and tradeoffs on the quality and cost of new products. The tool was developed with automatic spreadsheet connectivity to current process capability and with provisions to consider the impact of capital equipment and tooling purchases to reduce the product cost.

Geodynamics for Everyone: Robust Finite-Difference Heat Transfer Models using MS Excel 2007 Spreadsheets

NASA Astrophysics Data System (ADS)

Grose, C. J.

2008-05-01

Numerical geodynamics models of heat transfer are typically thought of as specialized topics of research requiring knowledge of specialized modelling software, linux platforms, and state-of-the-art finite-element codes. I have implemented analytical and numerical finite-difference techniques with Microsoft Excel 2007 spreadsheets to solve for complex solid-earth heat transfer problems for use by students, teachers, and practicing scientists without specialty in geodynamics modelling techniques and applications. While implementation of equations for use in Excel spreadsheets is occasionally cumbersome, once case boundary structure and node equations are developed, spreadsheet manipulation becomes routine. Model experimentation by modifying parameter values, geometry, and grid resolution makes Excel a useful tool whether in the classroom at the undergraduate or graduate level or for more engaging student projects. Furthermore, the ability to incorporate complex geometries and heat-transfer characteristics makes it ideal for first and occasionally higher order geodynamics simulations to better understand and constrain the results of professional field research in a setting that does not require the constraints of state-of-the-art modelling codes. The straightforward expression and manipulation of model equations in excel can also serve as a medium to better understand the confusing notations of advanced mathematical problems. To illustrate the power and robustness of computation and visualization in spreadsheet models I focus primarily on one-dimensional analytical and two-dimensional numerical solutions to two case problems: (i) the cooling of oceanic lithosphere and (ii) temperatures within subducting slabs. Excel source documents will be made available.

Development of a spreadsheet for SNPs typing using Microsoft EXCEL.

PubMed

Hashiyada, Masaki; Itakura, Yukio; Takahashi, Shirushi; Sakai, Jun; Funayama, Masato

2009-04-01

Single-nucleotide polymorphisms (SNPs) have some characteristics that make them very appropriate for forensic studies and applications. In our institute, SNPs typings were performed by the TaqMan SNP Genotyping Assays using the ABI PRISM 7500 FAST Real-Time PCR System (AppliedBiosystems) and Sequence Detection Software ver.1.4 (AppliedBiosystem). The TaqMan method was desired two positive control (Allele1 and 2) and one negative control to analyze each SNP locus. Therefore, it can be analyzed up to 24 loci of a person on a 96-well-plate at the same time. If SNPs analysis is expected to apply to biometrics authentication, 48 and over loci are required to identify a person. In this study, we designed a spreadsheet package using Microsoft EXCEL, and population data were used from our 120 SNPs population studies. On the spreadsheet, we defined SNP types using 'template files' instead of positive and negative controls. "Template files" consisted of the results of 94 unknown samples and two negative controls of each of 120 SNPs loci we had previously studied. By the use of the files, the spreadsheet could analyze 96 SNPs on a 96-wells-plate simultaneously.

Spreadsheet-based engine data analysis tool - user's guide.

DOT National Transportation Integrated Search

2016-07-01

This record refers to both the spreadsheet tool - Fleet Equipment Performance Measurement Preventive Maintenance Model: Spreadsheet-Based Engine Data Analysis Tool, http://ntl.bts.gov/lib/60000/60000/60007/0-6626-P1_Final.xlsm - and its accompanying ...

Modeling Steady-State Groundwater Flow Using Microcomputer Spreadsheets.

ERIC Educational Resources Information Center

Ousey, John Russell, Jr.

1986-01-01

Describes how microcomputer spreadsheets are easily adapted for use in groundwater modeling. Presents spreadsheet set-ups and the results of five groundwater models. Suggests that this approach can provide a basis for demonstrations, laboratory exercises, and student projects. (ML)

How Spreadsheets Boost Productivity.

ERIC Educational Resources Information Center

Ross, James

1988-01-01

Explains the use of computerized bookkeeping systems called spreadsheets to perform mathematical and accounting functions such as totaling expenditures, averaging test grades, and transferring funds. Advises about adapting spreadsheet programs and discusses several essential features, including linkage, macro functions, and sharing capabilities.…

Second NASA Technical Interchange Meeting (TIM): Advanced Technology Lifecycle Analysis System (ATLAS) Technology Tool Box (TTB)

NASA Technical Reports Server (NTRS)

ONeil, D. A.; Mankins, J. C.; Christensen, C. B.; Gresham, E. C.

2005-01-01

The Advanced Technology Lifecycle Analysis System (ATLAS), a spreadsheet analysis tool suite, applies parametric equations for sizing and lifecycle cost estimation. Performance, operation, and programmatic data used by the equations come from a Technology Tool Box (TTB) database. In this second TTB Technical Interchange Meeting (TIM), technologists, system model developers, and architecture analysts discussed methods for modeling technology decisions in spreadsheet models, identified specific technology parameters, and defined detailed development requirements. This Conference Publication captures the consensus of the discussions and provides narrative explanations of the tool suite, the database, and applications of ATLAS within NASA s changing environment.

Learning to Work with Databases in Astronomy: Quantitative Analysis of Science Educators' and Students' Pre-/Post-Tests

NASA Astrophysics Data System (ADS)

Schwortz, Andria C.; Burrows, Andrea C.; Myers, Adam D.

2015-01-01

Astronomy is increasingly moving towards working with large databases, from the state-of-the-art Sloan Digital Sky Survey Data Release 10, to the historical Digital Access to a Sky Century at Harvard. Non-astronomy fields as well tend to work with large datasets, be it in the form of warehouse inventory, health trends, or the stock market. However very few fields explicitly teach students the necessary skills to analyze such data. The authors studied a matched set of 37 participants working with 200-entry databases in astronomy using Google Spreadsheets, with limited information about a random set of quasars drawn from SDSS DR5. Here the authors present the quantitative results from an eight question pre-/post-test, with questions designed to span Bloom's taxonomy, on both the topics of the skills of using spreadsheets, and the content of quasars. Participants included both Astro 101 summer students and professionals including in-service K-12 teachers and science communicators. All groups showed statistically significant gains (as per Hake, 1998), with the greatest difference between women's gains of 0.196 and men's of 0.480.

Using Spreadsheets to Produce Acid-Base Titration Curves.

ERIC Educational Resources Information Center

Cawley, Martin James; Parkinson, John

1995-01-01

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

Information Spreadsheet for Engines and Vehicles Compliance Information System (EV-CIS) User Registration

EPA Pesticide Factsheets

In this spreadsheet, user(s) provide their company’s manufacturer code, user contact information for EV-CIS, and user roles. This spreadsheet is used for the Company Authorizing Official (CAO), CROMERR Signer, and EV-CIS Submitters.

Integrating numerical computation into the undergraduate education physics curriculum using spreadsheet excel

NASA Astrophysics Data System (ADS)

Fauzi, Ahmad

2017-11-01

Numerical computation has many pedagogical advantages: it develops analytical skills and problem-solving skills, helps to learn through visualization, and enhances physics education. Unfortunately, numerical computation is not taught to undergraduate education physics students in Indonesia. Incorporate numerical computation into the undergraduate education physics curriculum presents many challenges. The main challenges are the dense curriculum that makes difficult to put new numerical computation course and most students have no programming experience. In this research, we used case study to review how to integrate numerical computation into undergraduate education physics curriculum. The participants of this research were 54 students of the fourth semester of physics education department. As a result, we concluded that numerical computation could be integrated into undergraduate education physics curriculum using spreadsheet excel combined with another course. The results of this research become complements of the study on how to integrate numerical computation in learning physics using spreadsheet excel.

Microsoft excel spreadsheets for calculation of P-V-T relations and thermodynamic properties from equations of state of MgO, diamond and nine metals as pressure markers in high-pressure and high-temperature experiments

NASA Astrophysics Data System (ADS)

Sokolova, Tatiana S.; Dorogokupets, Peter I.; Dymshits, Anna M.; Danilov, Boris S.; Litasov, Konstantin D.

2016-09-01

We present Microsoft Excel spreadsheets for calculation of thermodynamic functions and P-V-T properties of MgO, diamond and 9 metals, Al, Cu, Ag, Au, Pt, Nb, Ta, Mo, and W, depending on temperature and volume or temperature and pressure. The spreadsheets include the most common pressure markers used in in situ experiments with diamond anvil cell and multianvil techniques. The calculations are based on the equation of state formalism via the Helmholtz free energy. The program was developed using Visual Basic for Applications in Microsoft Excel and is a time-efficient tool to evaluate volume, pressure and other thermodynamic functions using T-P and T-V data only as input parameters. This application is aimed to solve practical issues of high pressure experiments in geosciences and mineral physics.

Preparation of School District Budgets with Microcomputer Electronic Spreadsheets.

ERIC Educational Resources Information Center

Hinitz, Herman J.

1996-01-01

Preparing a microcomputer electronic spreadsheet containing all relevant school district budgetary information is possible with currently available hardware and software (such as Lotus 1-2-3), despite random-access-memory limitations. Spreadsheets can provide financial summaries, inventory-control listings, scheduling alternatives,…

A Spreadsheet in the Mathematics Classroom.

ERIC Educational Resources Information Center

Watkins, Will; Taylor, Monty

1989-01-01

Demonstrates how spreadsheets can be used to implement linear system solving algorithms in college mathematics classes. Lotus 1-2-3 is described, a linear system of equations is illustrated using spreadsheets, and the interplay between applications, computations, and theory is discussed. (four references) (LRW)

The Iodine-Clock Reaction--A Spreadsheet Simulation To Test.

ERIC Educational Resources Information Center

Swain, P. A.

1997-01-01

Describes a spreadsheet activity for the iodine-clock reaction which follows the concentrations of all reactions and products for 200 seconds and gives the induction period. Explains that, although there are limitations to the spreadsheet, it is nevertheless illuminating. (Author/ASK)

XLWrap - Querying and Integrating Arbitrary Spreadsheets with SPARQL

NASA Astrophysics Data System (ADS)

Langegger, Andreas; Wöß, Wolfram

In this paper a novel approach is presented for generating RDF graphs of arbitrary complexity from various spreadsheet layouts. Currently, none of the available spreadsheet-to-RDF wrappers supports cross tables and tables where data is not aligned in rows. Similar to RDF123, XLWrap is based on template graphs where fragments of triples can be mapped to specific cells of a spreadsheet. Additionally, it features a full expression algebra based on the syntax of OpenOffice Calc and various shift operations, which can be used to repeat similar mappings in order to wrap cross tables including multiple sheets and spreadsheet files. The set of available expression functions includes most of the native functions of OpenOffice Calc and can be easily extended by users of XLWrap.

Students' meaning making in science: solving energy resource problems in virtual worlds combined with spreadsheets to develop graphs

NASA Astrophysics Data System (ADS)

Krange, Ingeborg; Arnseth, Hans Christian

2012-09-01

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource consumption. The data were gathered in 1st grade upper-secondary science classes and they constitute the basis for the interaction analysis of students' meaning making with representations. Our analyses demonstrate the difficulties involved in developing students' orientation toward more conceptual orientations to representations of the knowledge domain. Virtual worlds do not in themselves represent a solution to this problem.

Integrating Critical Spreadsheet Competencies into the Accounting Curriculum

ERIC Educational Resources Information Center

Walters, L. Melissa; Pergola, Teresa M.

2012-01-01

The American Institute of Certified Public Accountants (AICPA) and the International Accounting Education Standards Board (IAESB) identify spreadsheet technology as a key information technology (IT) competency for accounting professionals. However requisite spreadsheet competencies are not specifically defined by the AICPA or IAESB nor are they…

Exploring Difference Equations with Spreadsheets.

ERIC Educational Resources Information Center

Walsh, Thomas P.

1996-01-01

When using spreadsheets to explore real-world problems involving periodic change, students can observe what happens at each period, generate a graph, and learn how changing the starting quantity or constants affects results. Spreadsheet lessons for high school students are presented that explore mathematical modeling, linear programming, and…

Visual Basic programs for spreadsheet analysis.

PubMed

Hunt, Bruce

2005-01-01

A collection of Visual Basic programs, entitled Function.xls, has been written for ground water spreadsheet calculations. This collection includes programs for calculating mathematical functions and for evaluating analytical solutions in ground water hydraulics and contaminant transport. Several spreadsheet examples are given to illustrate their use.

Decision Analysis Using Spreadsheets.

ERIC Educational Resources Information Center

Sounderpandian, Jayavel

1989-01-01

Discussion of decision analysis and its importance in a business curriculum focuses on the use of spreadsheets instead of commercial software packages for computer assisted instruction. A hypothetical example is given of a company drilling for oil, and suggestions are provided for classroom exercises using spreadsheets. (seven references) (LRW)

The Computer Bulletin Board.

ERIC Educational Resources Information Center

Batt, Russell H., Ed.

1988-01-01

Notes two uses of computer spreadsheets in the chemistry classroom. Discusses the general use of the spreadsheet to easily provide changing parameters of equations and then replotting the results on the screen. Presents a molecular orbital spreadsheet calculation of the LCAO-MO approach. Supplies representative printouts and graphs. (MVL)

How to Create Automatically Graded Spreadsheets for Statistics Courses

ERIC Educational Resources Information Center

LoSchiavo, Frank M.

2016-01-01

Instructors often use spreadsheet software (e.g., Microsoft Excel) in their statistics courses so that students can gain experience conducting computerized analyses. Unfortunately, students tend to make several predictable errors when programming spreadsheets. Without immediate feedback, programming errors are likely to go undetected, and as a…

Spreadsheet-Based Program for Simulating Atomic Emission Spectra

ERIC Educational Resources Information Center

Flannigan, David J.

2014-01-01

A simple Excel spreadsheet-based program for simulating atomic emission spectra from the properties of neutral atoms (e.g., energies and statistical weights of the electronic states, electronic partition functions, transition probabilities, etc.) is described. The contents of the spreadsheet (i.e., input parameters, formulas for calculating…

Spreadsheet Design: An Optimal Checklist for Accountants

ERIC Educational Resources Information Center

Barnes, Jeffrey N.; Tufte, David; Christensen, David

2009-01-01

Just as good grammar, punctuation, style, and content organization are important to well-written documents, basic fundamentals of spreadsheet design are essential to clear communication. In fact, the very principles of good writing should be integrated into spreadsheet workpaper design and organization. The unique contributions of this paper are…

Computer Applications: Using Electronic Spreadsheets.

ERIC Educational Resources Information Center

Riley, Connee; And Others

This instructional unit is intended to assist teachers in helping students learn to use electronic spreadsheets. The 11 learning activities included, all of which are designed for use in conjunction with Multiplan Spreadsheet Software, are arranged in order of increasing difficulty. An effort has been made to include problems applicable to each of…

Excel Spreadsheets for Algebra: Improving Mental Modeling for Problem Solving

ERIC Educational Resources Information Center

Engerman, Jason; Rusek, Matthew; Clariana, Roy

2014-01-01

This experiment investigates the effectiveness of Excel spreadsheets in a high school algebra class. Students in the experiment group convincingly outperformed the control group on a post lesson assessment. The student responses, teacher observations involving Excel spreadsheet revealed that it operated as a mindtool, which formed the users'…

Why Excel?

ERIC Educational Resources Information Center

Barreto, Humberto

2015-01-01

This article is not the usual Excel pedagogy fare in that it does not provide an application or example taught via a spreadsheet. Instead, it briefly reviews the history of spreadsheets in the economics classroom and explores the current environment, with an emphasis on modern learning theory. The conclusion is not surprising: spreadsheets improve…

The Growing Problems with Spreadsheet Budgeting

ERIC Educational Resources Information Center

Solomon, Jeff; Johnson, Stella; Wilcox, Leon; Olson, Tom

2010-01-01

The ubiquitous spreadsheet in some version has been the sole and unrivaled instrument of financial management for decades. And it has served well. The spreadsheet provides the flexibility to design a unique business process. It allows users to create formulas that execute complex calculations, and it is available in the globally standardized Excel…

Levels of Student Responses in a Spreadsheet-Based Environment

ERIC Educational Resources Information Center

Tabach, Michal; Friedlander, Alex

2004-01-01

The purpose of this report is to investigate the range of student responses in three domains--hypothesizing, organizing data, and algebraic generalization of patterns during their work on a spreadsheet-based activity. In a wider context, we attempted to investigate students' utilization schemes of spreadsheets in their learning of introductory…

User's guide: RPGrow$: a red pine growth and analysis spreadsheet for the Lake States.

Treesearch

Carol A. Hyldahl; Gerald H. Grossman

1993-01-01

Describes RPGrow$, a stand-level, interactive spreadsheet for projecting growth and yield and estimating financial returns of red pine plantations in the Lake States. This spreadsheet is based on published growth models for red pine. Financial analyses are based on discounted cash flow methods.

Spreadsheets and Bulgarian Goats

ERIC Educational Resources Information Center

Sugden, Steve

2012-01-01

We consider a problem appearing in an Australian Mathematics Challenge in 2003. This article considers whether a spreadsheet might be used to model this problem, thus allowing students to explore its structure within the spreadsheet environment. It then goes on to reflect on some general principles of problem decomposition when the final goal is a…

CEASAW: A User-Friendly Computer Environment Analysis for the Sawmill Owner

Treesearch

Guillermo Mendoza; William Sprouse; Philip A. Araman; William G. Luppold

1991-01-01

Improved spreadsheet software capabilities have brought optimization to users with little or no background in mathematical programming. Better interface capabilities of spreadsheet models now make it possible to combine optimization models with a spreadsheet system. Sawmill production and inventory systems possess many features that make them suitable application...

A Spreadsheet for the Mixing of a Row of Jets with a Confined Crossflow

NASA Technical Reports Server (NTRS)

Holderman, J. D.; Smith, T. D.; Clisset, J. R.; Lear, W. E.

2005-01-01

An interactive computer code, written with a readily available software program, Microsoft Excel (Microsoft Corporation, Redmond, WA) is presented which displays 3 D oblique plots of a conserved scalar distribution downstream of jets mixing with a confined crossflow, for a single row, double rows, or opposed rows of jets with or without flow area convergence and/or a non-uniform crossflow scalar distribution. This project used a previously developed empirical model of jets mixing in a confined crossflow to create an Microsoft Excel spreadsheet that can output the profiles of a conserved scalar for jets injected into a confined crossflow given several input variables. The program uses multiple spreadsheets in a single Microsoft Excel notebook to carry out the modeling. The first sheet contains the main program, controls for the type of problem to be solved, and convergence criteria. The first sheet also provides for input of the specific geometry and flow conditions. The second sheet presents the results calculated with this routine to show the effects on the mixing of varying flow and geometric parameters. Comparisons are also made between results from the version of the empirical correlations implemented in the spreadsheet and the versions originally written in Applesoft BASIC (Apple Computer, Cupertino, CA) in the 1980's.

A Spreadsheet for the Mixing of a Row of Jets with a Confined Crossflow. Supplement

NASA Technical Reports Server (NTRS)

Holderman, J. D.; Smith, T. D.; Clisset, J. R.; Lear, W. E.

2005-01-01

An interactive computer code, written with a readily available software program, Microsoft Excel (Microsoft Corporation, Redmond, WA) is presented which displays 3 D oblique plots of a conserved scalar distribution downstream of jets mixing with a confined crossflow, for a single row, double rows, or opposed rows of jets with or without flow area convergence and/or a non-uniform crossflow scalar distribution. This project used a previously developed empirical model of jets mixing in a confined crossflow to create an Microsoft Excel spreadsheet that can output the profiles of a conserved scalar for jets injected into a confined crossflow given several input variables. The program uses multiple spreadsheets in a single Microsoft Excel notebook to carry out the modeling. The first sheet contains the main program, controls for the type of problem to be solved, and convergence criteria. The first sheet also provides for input of the specific geometry and flow conditions. The second sheet presents the results calculated with this routine to show the effects on the mixing of varying flow and geometric parameters. Comparisons are also made between results from the version of the empirical correlations implemented in the spreadsheet and the versions originally written in Applesoft BASIC (Apple Computer, Cupertino, CA) in the 1980's.

Lens Ray Diagrams with a Spreadsheet

ERIC Educational Resources Information Center

González, Manuel I.

2018-01-01

Physicists create spreadsheets customarily to carry out numerical calculations and to display their results in a meaningful, nice-looking way. Spreadsheets can also be used to display a vivid geometrical model of a physical system. This statement is illustrated with an example taken from geometrical optics: images formed by a thin lens. A careful…

Designing Spreadsheet-Based Tasks for Purposeful Algebra

ERIC Educational Resources Information Center

Ainley, Janet; Bills, Liz; Wilson, Kirsty

2005-01-01

We describe the design of a sequence of spreadsheet-based pedagogic tasks for the introduction of algebra in the early years of secondary schooling within the Purposeful Algebraic Activity project. This design combines two relatively novel features to bring a different perspective to research in the use of spreadsheets for the learning and…

Refinery spreadsheet highlights microcomputer process applications

DOE Office of Scientific and Technical Information (OSTI.GOV)

Tucker, M.A.

1984-01-23

Microcomputer applications in the process areas at Chevron U.S.A. refineries and at the Chevron Research Co. illustrate how the microcomputer has changed the way we do our jobs. This article will describe major uses of the microcomputer as a personal work tool in Chevron process areas. It will also describe how and why many of Chevron's microcomputer applications were developed and their characteristics. One of our earliest microcomputer applications, developed in late 1981, was an electronic spreadsheet program using a small desktop microcomputer. It was designed to help a refinery planner prepare monthly plans for a small portion of onemore » of our major refineries. This particular microcomputer had a tiny 4-in. screen, and the reports were several strips of print-out from the microcomputer's 3-in.-wide internal printer taped together. In spite of these archaic computing conditions, it was a successful application. It automated what had been very tedious and time-consuming calculations with a pencil, a calculator, and a great deal of erasing. It eliminated filling out large ''horseblanket'' reports. The electronic spreadsheet was also flexible; the planner could easily change the worksheet to match new operating constraints, new process conditions, and new feeds and products. Fortunately, within just a few months, this application graduated to a similar electronic spreadsheet program on a new, more powerful microcomputer. It had a bigger display screen and a letter-size printer. The same application is still in use today, although it has been greatly enhanced and altered to match extensive plant modifications. And there are plans to expand it again onto yet another, more powerful microcomputer.« less

TMDL RUSLE MODEL

EPA Science Inventory

We developed a simplified spreadsheet modeling approach for characterizing and prioritizing sources of sediment loadings from watersheds in the United States. A simplified modeling approach was developed to evaluate sediment loadings from watersheds and selected land segments. ...

Alternative theoretical method for motion of a sand-filled funnel experiment

NASA Astrophysics Data System (ADS)

Byrd, David; White, Gary

2001-11-01

In "Motion of a Sand-Filled Funnel," Peter Sullivan and Anna McLoon described how to use numerical methods and a Microsoft Excel spreadsheet to predict the motion of a variant of Atwood's machine with variable mass. They wrote for noncalculus-based physics classes, but we solve the same problem using the methods of calculus. Our method highlights the less-familiar but more accurate version of Newton's second law, ∑F =dp/dt. This can help introductory physics students understand a broader definition of Newton's second law and enhance their calculus skills. It also teaches students how to solve a variable-mass problem.

Internal trip capture estimator for mixed-use developments.

DOT National Transportation Integrated Search

2007-12-01

This report describes a spreadsheet tool for estimating trip generation for mixed-use developments, : accounting for internal trip capture. Internal trip capture is the portion of trips generated by a mixed-use : development that both begin and end w...

Comparison between In-house developed and Diamond commercial software for patient specific independent monitor unit calculation and verification with heterogeneity corrections.

PubMed

Kuppusamy, Vijayalakshmi; Nagarajan, Vivekanandan; Jeevanandam, Prakash; Murugan, Lavanya

2016-02-01

The study was aimed to compare two different monitor unit (MU) or dose verification software in volumetric modulated arc therapy (VMAT) using modified Clarkson's integration technique for 6 MV photons beams. In-house Excel Spreadsheet based monitor unit verification calculation (MUVC) program and PTW's DIAMOND secondary check software (SCS), version-6 were used as a secondary check to verify the monitor unit (MU) or dose calculated by treatment planning system (TPS). In this study 180 patients were grouped into 61 head and neck, 39 thorax and 80 pelvic sites. Verification plans are created using PTW OCTAVIUS-4D phantom and also measured using 729 detector chamber and array with isocentre as the suitable point of measurement for each field. In the analysis of 154 clinically approved VMAT plans with isocentre at a region above -350 HU, using heterogeneity corrections, In-house Spreadsheet based MUVC program and Diamond SCS showed good agreement TPS. The overall percentage average deviations for all sites were (-0.93% + 1.59%) and (1.37% + 2.72%) for In-house Excel Spreadsheet based MUVC program and Diamond SCS respectively. For 26 clinically approved VMAT plans with isocentre at a region below -350 HU showed higher variations for both In-house Spreadsheet based MUVC program and Diamond SCS. It can be concluded that for patient specific quality assurance (QA), the In-house Excel Spreadsheet based MUVC program and Diamond SCS can be used as a simple and fast accompanying to measurement based verification for plans with isocentre at a region above -350 HU. Copyright © 2016 Associazione Italiana di Fisica Medica. Published by Elsevier Ltd. All rights reserved.

Molten Salt Power Tower Cost Model for the System Advisor Model (SAM)

DOE Office of Scientific and Technical Information (OSTI.GOV)

Turchi, C. S.; Heath, G. A.

2013-02-01

This report describes a component-based cost model developed for molten-salt power tower solar power plants. The cost model was developed by the National Renewable Energy Laboratory (NREL), using data from several prior studies, including a contracted analysis from WorleyParsons Group, which is included herein as an Appendix. The WorleyParsons' analysis also estimated material composition and mass for the plant to facilitate a life cycle analysis of the molten salt power tower technology. Details of the life cycle assessment have been published elsewhere. The cost model provides a reference plant that interfaces with NREL's System Advisor Model or SAM. The referencemore » plant assumes a nominal 100-MWe (net) power tower running with a nitrate salt heat transfer fluid (HTF). Thermal energy storage is provided by direct storage of the HTF in a two-tank system. The design assumes dry-cooling. The model includes a spreadsheet that interfaces with SAM via the Excel Exchange option in SAM. The spreadsheet allows users to estimate the costs of different-size plants and to take into account changes in commodity prices. This report and the accompanying Excel spreadsheet can be downloaded at https://sam.nrel.gov/cost.« less

A Spreadsheet for a 2 x 3 x 2 Log-Linear Analysis. AIR 1991 Annual Forum Paper.

ERIC Educational Resources Information Center

Saupe, Joe L.

This paper describes a personal computer spreadsheet set up to carry out hierarchical log-linear analyses, a type of analysis useful for institutional research into multidimensional frequency tables formed from categorical variables such as faculty rank, student class level, gender, or retention status. The spreadsheet provides a concrete vehicle…

Using Spreadsheets to Help Students Think Recursively

ERIC Educational Resources Information Center

Webber, Robert P.

2012-01-01

Spreadsheets lend themselves naturally to recursive computations, since a formula can be defined as a function of one of more preceding cells. A hypothesized closed form for the "n"th term of a recursive sequence can be tested easily by using a spreadsheet to compute a large number of the terms. Similarly, a conjecture about the limit of a series…

A Spreadsheet Tool for Learning the Multiple Regression F-Test, T-Tests, and Multicollinearity

ERIC Educational Resources Information Center

Martin, David

2008-01-01

This note presents a spreadsheet tool that allows teachers the opportunity to guide students towards answering on their own questions related to the multiple regression F-test, the t-tests, and multicollinearity. The note demonstrates approaches for using the spreadsheet that might be appropriate for three different levels of statistics classes,…

Understanding Solubility through Excel Spreadsheets

NASA Astrophysics Data System (ADS)

Brown, Pamela

2001-02-01

This article describes assignments related to the solubility of inorganic salts that can be given in an introductory general chemistry course. Le Châtelier's principle, solubility, unit conversion, and thermodynamics are tied together to calculate heats of solution by two methods: heats of formation and an application of the van't Hoff equation. These assignments address the need for math, graphing, and computer skills in the chemical technology program by developing skill in the use of Microsoft Excel to prepare spreadsheets and graphs and to perform linear and nonlinear curve-fitting. Background information on the value of understanding and predicting solubility is provided.

Definition and maintenance of a telemetry database dictionary

NASA Technical Reports Server (NTRS)

Knopf, William P. (Inventor)

2007-01-01

A telemetry dictionary database includes a component for receiving spreadsheet workbooks of telemetry data over a web-based interface from other computer devices. Another component routes the spreadsheet workbooks to a specified directory on the host processing device. A process then checks the received spreadsheet workbooks for errors, and if no errors are detected the spreadsheet workbooks are routed to another directory to await initiation of a remote database loading process. The loading process first converts the spreadsheet workbooks to comma separated value (CSV) files. Next, a network connection with the computer system that hosts the telemetry dictionary database is established and the CSV files are ported to the computer system that hosts the telemetry dictionary database. This is followed by a remote initiation of a database loading program. Upon completion of loading a flatfile generation program is manually initiated to generate a flatfile to be used in a mission operations environment by the core ground system.

MO-DE-BRA-02: From Teaching to Learning: Systems-Based-Practice and Practice-Based-Learning Innovations in Medical Physics Education Programs

DOE Office of Scientific and Technical Information (OSTI.GOV)

Kapur, A

Purpose: The increasing complexity in the field of radiation medicine and concomitant rise in patient safety concerns call for enhanced systems-level training for future medical physicists and thus commensurate innovations in existing educational program curricula. In this work we report on the introduction of three learning opportunities to augment medical physics educational programs towards building systems-based practice and practice-based learning competencies. Methods: All initiatives were introduced for senior -level graduate students and physics residents in an institution with a newly established medical-physics graduate program and therapeutic-physics residency program. The first, centered on incident learning, was based on a spreadsheet toolmore » that incorporated the reporting structure of the Radiation Oncology-incident Learning System (ROILS), included 120 narratives of published incidents and enabled inter-rater variability calculations. The second, centered on best-practices, was a zero-credit seminar course, where students summarized select presentations from the AAPM virtual library on a weekly basis and moderated class discussions using a point/counterpoint approach. Presentation styles were critiqued. The third; centered on learning-by-teaching, required physics residents to regularly explain fundamental concepts in radiological physics from standard textbooks to board certified physics faculty members. Results: Use of the incident-learning system spreadsheet provided a platform to recast known accidents into the framework of ROILS, thereby increasing awareness of factors contributing to unsafe practice and appreciation for inter-rater variability. The seminar course enhanced awareness of best practices, the effectiveness of presentation styles and encouraged critical thinking. The learn-by-teaching rotation allowed residents to stay abreast of and deepen their knowledge of relevant subjects. Conclusion: The incorporation of systems-driven initiatives broadens comprehension of the wider systems context of medical physics, enhances awareness of resources for innovation, communication and sustained learning while maintaining a metric-driven focus on patient safety within the formative phase of student careers. The initiatives were well-received, feasible, and utilized available or shared-resources translatable across educational programs.« less

AXAOTHER XL -- A spreadsheet for determining doses for incidents caused by tornadoes or high-velocity straight winds

DOE Office of Scientific and Technical Information (OSTI.GOV)

Simpkins, A.A.

1996-09-01

AXAOTHER XL is an Excel Spreadsheet used to determine dose to the maximally exposed offsite individual during high-velocity straight winds or tornado conditions. Both individual and population doses may be considered. Potential exposure pathways are inhalation and plume shine. For high-velocity straight winds the spreadsheet has the capability to determine the downwind relative air concentration, however for the tornado conditions, the user must enter the relative air concentration. Theoretical models are discussed and hand calculations are performed to ensure proper application of methodologies. A section has also been included that contains user instructions for the spreadsheet.

Data from fitting Gaussian process models to various data sets using eight Gaussian process software packages.

PubMed

Erickson, Collin B; Ankenman, Bruce E; Sanchez, Susan M

2018-06-01

This data article provides the summary data from tests comparing various Gaussian process software packages. Each spreadsheet represents a single function or type of function using a particular input sample size. In each spreadsheet, a row gives the results for a particular replication using a single package. Within each spreadsheet there are the results from eight Gaussian process model-fitting packages on five replicates of the surface. There is also one spreadsheet comparing the results from two packages performing stochastic kriging. These data enable comparisons between the packages to determine which package will give users the best results.

A retention index calculator simplifies identification of plant volatile organic compounds.

PubMed

Lucero, Mary; Estell, Rick; Tellez, María; Fredrickson, Ed

2009-01-01

Plant volatiles (PVOCs) are important targets for studies in natural products, chemotaxonomy and biochemical ecology. The complexity of PVOC profiles often limits research to studies targeting only easily identified compounds. With the availability of mass spectral libraries and recent growth of retention index (RI) libraries, PVOC identification can be achieved using only gas chromatography coupled to mass spectrometry (GCMS). However, RI library searching is not typically automated, and until recently, RI libraries were both limited in scope and costly to obtain. To automate RI calculation and lookup functions commonly utilised in PVOC analysis. Formulae required for calculating retention indices from retention time data were placed in a spreadsheet along with lookup functions and a retention index library. Retention times obtained from GCMS analysis of alkane standards and Koeberlinia spinosa essential oil were entered into the spreadsheet to determine retention indices. Indices were used in combination with mass spectral analysis to identify compounds contained in Koeberlinia spinosa essential oil. Eighteen compounds were positively identified. Total oil yield was low, with only 5 ppm in purple berries. The most abundant compounds were octen-3-ol and methyl salicylate. The spreadsheet accurately calculated RIs of the detected compounds. The downloadable spreadsheet tool developed for this study provides a calculator and RI library that works in conjuction with GCMS or other analytical techniques to identify PVOCs in plant extracts.

The Computerized Reference Department: Buying the Future.

ERIC Educational Resources Information Center

Kriz, Harry M.; Kok, Victoria T.

1985-01-01

Basis for systematic computerization of academic research library's reference, collection development, and collection management functions emphasizes productivity enhancement for librarians and support staff. Use of microcomputer and university's mainframe computer to develop applications of database management systems, electronic spreadsheets,…

GREET 1.5 : transportation fuel-cycle model. Vol. 1 : methodology, development, use, and results.

DOT National Transportation Integrated Search

1999-10-01

This report documents the development and use of the most recent version (Version 1.5) of the Greenhouse Gases, Regulated Emissions, and Energy Use in Transportation (GREET) model. The model, developed in a spreadsheet format, estimates the full fuel...

Calculating ellipse area by the Monte Carlo method and analysing dice poker with Excel at high school

NASA Astrophysics Data System (ADS)

Benacka, Jan

2016-08-01

This paper reports on lessons in which 18-19 years old high school students modelled random processes with Excel. In the first lesson, 26 students formulated a hypothesis on the area of ellipse by using the analogy between the areas of circle, square and rectangle. They verified the hypothesis by the Monte Carlo method with a spreadsheet model developed in the lesson. In the second lesson, 27 students analysed the dice poker game. First, they calculated the probability of the hands by combinatorial formulae. Then, they verified the result with a spreadsheet model developed in the lesson. The students were given a questionnaire to find out if they found the lesson interesting and contributing to their mathematical and technological knowledge.

Measuring the RC time constant with Arduino

NASA Astrophysics Data System (ADS)

Pereira, N. S. A.

2016-11-01

In this work we use the Arduino UNO R3 open source hardware platform to assemble an experimental apparatus for the measurement of the time constant of an RC circuit. With adequate programming, the Arduino is used as a signal generator, a data acquisition system and a basic signal visualisation tool. Theoretical calculations are compared with direct observations from an analogue oscilloscope. Data processing and curve fitting is performed on a spreadsheet. The results obtained for the six RC test circuits are within the expected interval of values defined by the tolerance of the components. The hardware and software prove to be adequate to the proposed measurements and therefore adaptable to a laboratorial teaching and learning context.

Individualized Human CAD Models: Anthropmetric Morphing and Body Tissue Layering

DTIC Science & Technology

2014-07-31

Part Flow Chart of the Interaction among VBA Macros, Excel® Spreadsheet, and SolidWorks Front View of the Male and Female Soldier CAD Model...yellow highlighting. The spreadsheet is linked to the CAD model by macros created with the Visual Basic for Application ( VBA ) editor in Microsoft Excel...basically three working parts to the anthropometric morphing that are all interconnected ( VBA macros, Excel spreadsheet, and SolidWorks). The flow

Using a Spreadsheet to Solve the Schro¨dinger Equations for the Energies of the Ground Electronic State and the Two Lowest Excited States of H[subscript2

ERIC Educational Resources Information Center

Ge, Yingbin; Rittenhouse, Robert C.; Buchanan, Jacob C.; Livingston, Benjamin

2014-01-01

We have designed an exercise suitable for a lab or project in an undergraduate physical chemistry course that creates a Microsoft Excel spreadsheet to calculate the energy of the S[subscript 0] ground electronic state and the S[subscript 1] and T[subscript 1] excited states of H[subscript 2]. The spreadsheet calculations circumvent the…

Spreadsheet as a motivational tool in learning and professional development in Agricultural Engineering

NASA Astrophysics Data System (ADS)

Medina, Silvia; Moratiel, Ruben; Tarquis, Ana Maria; María Durán, Jose

2013-04-01

For the past few decades, Spanish universities have been introduced gradually, the use of so-called New Technologies in the classroom. This is because its use contributes to improve outcomes in education at all levels. In this sense, it helps not only to expand knowledge as in traditional education, but teaches students to learn and encouraged them to be more independent, to develop and apply their knowledge in practice, their future employment use. The aim of this paper is to analyse the educational content and the degree of satisfaction students get through the use of a spreadsheet program to perform various practices of Agricultural Engineers courses of the Polytechnic University of Madrid. Weekly, the professor poses a practice with a detailed explanation of what is required and students have the opportunity to submit as many times as they want, over two weeks, the work developed. Students are encouraged to undertake individual work and to submit in the same day the exercise done because earlier is the presentation of results more opportunities to correct the mistakes. Regardless of students' knowledge on Excel, the professor explains each one of the Excel resources to be employed in the presented practice. Then, they have the opportunity to ask about them avoiding the scenario of not performing the practice due to ignore some Excel resources. The number of practices that are performed per year depend on the hours / credits that are assigned to each subject. On the other hand, to check the degree of student satisfaction with these practices, a anonymous questionnaire was performed consisting of 15 questions that can be grouped into four categories: consolidation of knowledge (4 questions), practice organization (7 questions), following indications (2 questions) and knowledge of Excel (2 questions). Results show high degree of students' satisfaction in their learning process and their applicability in the future. Acknowledgments Funded provided by educational innovation projects "Training of mentors' students in different subjects in the first degree and postgraduate ETSI Agrónomos" and "Students mentoring system in undergraduate and graduate courses at ETS Ingenieros Agrónomos" given by UPM are gratefully appreciated.

Data Logging and Data Modelling: Using seismology and seismic data to create challenge in the academic classroom.

NASA Astrophysics Data System (ADS)

Neighbour, Gordon

2013-04-01

In 2012 Computing and Information Technology was disapplied from the English National Curriculum and therefore no longer has a compulsory programme of study. Data logging and data modelling are still essential components of the curriculum in the Computing and Information Technology classroom. Once the students have mastered the basics of both spreadsheet and information handling software they need to be further challenged. All too often the data used with relation to data-logging and data-handling is not realistic enough to really challenge very able students. However, using data from seismology allows students to manipulate "real" data and enhances their experience of geo-science, developing their skills and then allowing them to build on this work in both the science and geography classroom. This new scheme of work "Seismology at School" has allowed the students to work and develop skills beyond those normally expected for their age group and has allowed them to better appreciate their learning experience of "Natural Hazards" in the science and geography classroom in later years. The students undertake research to help them develop their understanding of earthquakes. This includes using materials from other nations within the European Economic Area, to also develop and challenge their use of Modern Foreign Languages. They are then challenged to create their own seismometers using simple kits and 'free' software - this "problem-solving" approach to their work is designed to enhance team-work and to extend the challenge they experience in the classroom. The students are then are asked to manipulate a "real" set of data using international earthquake data from the most recent whole year. This allows the students to make use of many of the analytical and statistical functions of both spreadsheet software and information handling software in a meaningful way. The students will need to have developed a hypothesis which their work should have provided either validation for or against. They are required to document their progress throughout the project and submit their work as an electronic portfolio for marking and this thus challenges their organisational abilities. Finally through the project it is hoped to develop and extend partnerships with other schools in the European Economic Area so that the students are able to work with students from these areas to further appreciate the teaching of "Natural Hazards" in other cultures within the EEA.

Predicting Ga and Cu Profiles in Co-Evaporated Cu(In,Ga)Se 2 Using Modified Diffusion Equations and a Spreadsheet

DOE PAGES

Repins, Ingrid L.; Harvey, Steve; Bowers, Karen; ...

2017-05-15

Cu(In,Ga)Se 2(CIGS) photovoltaic absorbers frequently develop Ga gradients during growth. These gradients vary as a function of growth recipe, and are important to device performance. Prediction of Ga profiles using classic diffusion equations is not possible because In and Ga atoms occupy the same lattice sites and thus diffuse interdependently, and there is not yet a detailed experimental knowledge of the chemical potential as a function of composition that describes this interaction. Here, we show how diffusion equations can be modified to account for site sharing between In and Ga atoms. The analysis has been implemented in an Excel spreadsheet,more » and outputs predicted Cu, In, and Ga profiles for entered deposition recipes. A single set of diffusion coefficients and activation energies are chosen, such that simulated elemental profiles track with published data and those from this study. Extent and limits of agreement between elemental profiles predicted from the growth recipes and the spreadsheet tool are demonstrated.« less

Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis.

PubMed

Neyeloff, Jeruza L; Fuchs, Sandra C; Moreira, Leila B

2012-01-20

Meta-analyses are necessary to synthesize data obtained from primary research, and in many situations reviews of observational studies are the only available alternative. General purpose statistical packages can meta-analyze data, but usually require external macros or coding. Commercial specialist software is available, but may be expensive and focused in a particular type of primary data. Most available softwares have limitations in dealing with descriptive data, and the graphical display of summary statistics such as incidence and prevalence is unsatisfactory. Analyses can be conducted using Microsoft Excel, but there was no previous guide available. We constructed a step-by-step guide to perform a meta-analysis in a Microsoft Excel spreadsheet, using either fixed-effect or random-effects models. We have also developed a second spreadsheet capable of producing customized forest plots. It is possible to conduct a meta-analysis using only Microsoft Excel. More important, to our knowledge this is the first description of a method for producing a statistically adequate but graphically appealing forest plot summarizing descriptive data, using widely available software.

Meta-analyses and Forest plots using a microsoft excel spreadsheet: step-by-step guide focusing on descriptive data analysis

PubMed Central

2012-01-01

Background Meta-analyses are necessary to synthesize data obtained from primary research, and in many situations reviews of observational studies are the only available alternative. General purpose statistical packages can meta-analyze data, but usually require external macros or coding. Commercial specialist software is available, but may be expensive and focused in a particular type of primary data. Most available softwares have limitations in dealing with descriptive data, and the graphical display of summary statistics such as incidence and prevalence is unsatisfactory. Analyses can be conducted using Microsoft Excel, but there was no previous guide available. Findings We constructed a step-by-step guide to perform a meta-analysis in a Microsoft Excel spreadsheet, using either fixed-effect or random-effects models. We have also developed a second spreadsheet capable of producing customized forest plots. Conclusions It is possible to conduct a meta-analysis using only Microsoft Excel. More important, to our knowledge this is the first description of a method for producing a statistically adequate but graphically appealing forest plot summarizing descriptive data, using widely available software. PMID:22264277

Multiphysics Object Oriented Simulation Environment

DOE Office of Scientific and Technical Information (OSTI.GOV)

The Multiphysics Object Oriented Simulation Environment (MOOSE) software library developed at Idaho National Laboratory is a tool. MOOSE, like other tools, doesn't actually complete a task. Instead, MOOSE seeks to reduce the effort required to create engineering simulation applications. MOOSE itself is a software library: a blank canvas upon which you write equations and then MOOSE can help you solve them. MOOSE is comparable to a spreadsheet application. A spreadsheet, by itself, doesn't do anything. Only once equations are entered into it will a spreadsheet application compute anything. Such is the same for MOOSE. An engineer or scientist can utilizemore » the equation solvers within MOOSE to solve equations related to their area of study. For instance, a geomechanical scientist can input equations related to water flow in underground reservoirs and MOOSE can solve those equations to give the scientist an idea of how water could move over time. An engineer might input equations related to the forces in steel beams in order to understand the load bearing capacity of a bridge. Because MOOSE is a blank canvas it can be useful in many scientific and engineering pursuits.« less

Predicting Ga and Cu Profiles in Co-Evaporated Cu(In,Ga)Se 2 Using Modified Diffusion Equations and a Spreadsheet

DOE Office of Scientific and Technical Information (OSTI.GOV)

Repins, Ingrid L.; Harvey, Steve; Bowers, Karen

Cu(In,Ga)Se 2(CIGS) photovoltaic absorbers frequently develop Ga gradients during growth. These gradients vary as a function of growth recipe, and are important to device performance. Prediction of Ga profiles using classic diffusion equations is not possible because In and Ga atoms occupy the same lattice sites and thus diffuse interdependently, and there is not yet a detailed experimental knowledge of the chemical potential as a function of composition that describes this interaction. Here, we show how diffusion equations can be modified to account for site sharing between In and Ga atoms. The analysis has been implemented in an Excel spreadsheet,more » and outputs predicted Cu, In, and Ga profiles for entered deposition recipes. A single set of diffusion coefficients and activation energies are chosen, such that simulated elemental profiles track with published data and those from this study. Extent and limits of agreement between elemental profiles predicted from the growth recipes and the spreadsheet tool are demonstrated.« less

Computer-based Astronomy Labs for Non-science Majors

NASA Astrophysics Data System (ADS)

Smith, A. B. E.; Murray, S. D.; Ward, R. A.

1998-12-01

We describe and demonstrate two laboratory exercises, Kepler's Third Law and Stellar Structure, which are being developed for use in an astronomy laboratory class aimed at non-science majors. The labs run with Microsoft's Excel 98 (Macintosh) or Excel 97 (Windows). They can be run in a classroom setting or in an independent learning environment. The intent of the labs is twofold; first and foremost, students learn the subject matter through a series of informational frames. Next, students enhance their understanding by applying their knowledge in lab procedures, while also gaining familiarity with the use and power of a widely-used software package and scientific tool. No mathematical knowledge beyond basic algebra is required to complete the labs or to understand the computations in the spreadsheets, although the students are exposed to the concepts of numerical integration. The labs are contained in Excel workbook files. In the files are multiple spreadsheets, which contain either a frame with information on how to run the lab, material on the subject, or one or more procedures. Excel's VBA macro language is used to automate the labs. The macros are accessed through button interfaces positioned on the spreadsheets. This is done intentionally so that students can focus on learning the subject matter and the basic spreadsheet features without having to learn advanced Excel features all at once. Students open the file and progress through the informational frames to the procedures. After each procedure, student comments and data are automatically recorded in a preformatted Lab Report spreadsheet. Once all procedures have been completed, the student is prompted for a filename in which to save their Lab Report. The lab reports can then be printed or emailed to the instructor. The files will have full worksheet and workbook protection, and will have a "redo" feature at the end of the lab for students who want to repeat a procedure.

The EnzymeTracker: an open-source laboratory information management system for sample tracking.

PubMed

Triplet, Thomas; Butler, Gregory

2012-01-26

In many laboratories, researchers store experimental data on their own workstation using spreadsheets. However, this approach poses a number of problems, ranging from sharing issues to inefficient data-mining. Standard spreadsheets are also error-prone, as data do not undergo any validation process. To overcome spreadsheets inherent limitations, a number of proprietary systems have been developed, which laboratories need to pay expensive license fees for. Those costs are usually prohibitive for most laboratories and prevent scientists from benefiting from more sophisticated data management systems. In this paper, we propose the EnzymeTracker, a web-based laboratory information management system for sample tracking, as an open-source and flexible alternative that aims at facilitating entry, mining and sharing of experimental biological data. The EnzymeTracker features online spreadsheets and tools for monitoring numerous experiments conducted by several collaborators to identify and characterize samples. It also provides libraries of shared data such as protocols, and administration tools for data access control using OpenID and user/team management. Our system relies on a database management system for efficient data indexing and management and a user-friendly AJAX interface that can be accessed over the Internet. The EnzymeTracker facilitates data entry by dynamically suggesting entries and providing smart data-mining tools to effectively retrieve data. Our system features a number of tools to visualize and annotate experimental data, and export highly customizable reports. It also supports QR matrix barcoding to facilitate sample tracking. The EnzymeTracker was designed to be easy to use and offers many benefits over spreadsheets, thus presenting the characteristics required to facilitate acceptance by the scientific community. It has been successfully used for 20 months on a daily basis by over 50 scientists. The EnzymeTracker is freely available online at http://cubique.fungalgenomics.ca/enzymedb/index.html under the GNU GPLv3 license.

The EnzymeTracker: an open-source laboratory information management system for sample tracking

PubMed Central

2012-01-01

Background In many laboratories, researchers store experimental data on their own workstation using spreadsheets. However, this approach poses a number of problems, ranging from sharing issues to inefficient data-mining. Standard spreadsheets are also error-prone, as data do not undergo any validation process. To overcome spreadsheets inherent limitations, a number of proprietary systems have been developed, which laboratories need to pay expensive license fees for. Those costs are usually prohibitive for most laboratories and prevent scientists from benefiting from more sophisticated data management systems. Results In this paper, we propose the EnzymeTracker, a web-based laboratory information management system for sample tracking, as an open-source and flexible alternative that aims at facilitating entry, mining and sharing of experimental biological data. The EnzymeTracker features online spreadsheets and tools for monitoring numerous experiments conducted by several collaborators to identify and characterize samples. It also provides libraries of shared data such as protocols, and administration tools for data access control using OpenID and user/team management. Our system relies on a database management system for efficient data indexing and management and a user-friendly AJAX interface that can be accessed over the Internet. The EnzymeTracker facilitates data entry by dynamically suggesting entries and providing smart data-mining tools to effectively retrieve data. Our system features a number of tools to visualize and annotate experimental data, and export highly customizable reports. It also supports QR matrix barcoding to facilitate sample tracking. Conclusions The EnzymeTracker was designed to be easy to use and offers many benefits over spreadsheets, thus presenting the characteristics required to facilitate acceptance by the scientific community. It has been successfully used for 20 months on a daily basis by over 50 scientists. The EnzymeTracker is freely available online at http://cubique.fungalgenomics.ca/enzymedb/index.html under the GNU GPLv3 license. PMID:22280360

Iteration with Spreadsheets.

ERIC Educational Resources Information Center

Smith, Michael

1990-01-01

Presents several examples of the iteration method using computer spreadsheets. Examples included are simple iterative sequences and the solution of equations using the Newton-Raphson formula, linear interpolation, and interval bisection. (YP)

Safety analysis of interchanges

DOT National Transportation Integrated Search

2007-06-01

The objectives of this research are to synthesize the current state of knowledge concerning the safety assessment of new or modified interchanges; develop a spreadsheet-based computational tool for performing safety assessments of interchanges; and i...

Development of a Genetic Algorithm to Automate Clustering of a Dependency Structure Matrix

NASA Technical Reports Server (NTRS)

Rogers, James L.; Korte, John J.; Bilardo, Vincent J.

2006-01-01

Much technology assessment and organization design data exists in Microsoft Excel spreadsheets. Tools are needed to put this data into a form that can be used by design managers to make design decisions. One need is to cluster data that is highly coupled. Tools such as the Dependency Structure Matrix (DSM) and a Genetic Algorithm (GA) can be of great benefit. However, no tool currently combines the DSM and a GA to solve the clustering problem. This paper describes a new software tool that interfaces a GA written as an Excel macro with a DSM in spreadsheet format. The results of several test cases are included to demonstrate how well this new tool works.

A novel real-time data acquisition using an Excel spreadsheet in pendulum experiment tool with light-based timer

NASA Astrophysics Data System (ADS)

Adhitama, Egy; Fauzi, Ahmad

2018-05-01

In this study, a pendulum experimental tool with a light-based timer has been developed to measure the period of a simple pendulum. The obtained data was automatically recorded in an Excel spreadsheet. The intensity of monochromatic light, sensed by a 3DU5C phototransistor, dynamically changes as the pendulum swings. The changed intensity varies the resistance value and was processed by the microcontroller, ATMega328, to obtain a signal period as a function of time and brightness when the pendulum crosses the light. Through the experiment, using calculated average periods, the gravitational acceleration value has been accurately and precisely determined.

Estimation of unaltered daily mean streamflow at ungaged streams of New York, excluding Long Island, water years 1961-2010

USGS Publications Warehouse

Gazoorian, Christopher L.

2015-01-01

A graphical user interface, with an integrated spreadsheet summary report, has been developed to estimate and display the daily mean streamflows and statistics and to evaluate different water management or water withdrawal scenarios with the estimated monthly data. This package of regression equations, U.S. Geological Survey streamgage data, and spreadsheet application produces an interactive tool to estimate an unaltered daily streamflow hydrograph and streamflow statistics at ungaged sites in New York. Among other uses, the New York Streamflow Estimation Tool can assist water managers with permitting water withdrawals, implementing habitat protection, estimating contaminant loads, or determining the potential affect from chemical spills.

Fitting Planetary Orbits with a Spreadsheet.

ERIC Educational Resources Information Center

Bridges, Richard

1995-01-01

Describes how to fit binocular observations of the planets to a theoretical model of circular orbits using a modern computer spreadsheet, from which fundamental data about the solar system may be deduced. (AIM)

Strontium-90 Error Discovered in Subcontract Laboratory Spreadsheet

DOE Office of Scientific and Technical Information (OSTI.GOV)

D. D. Brown A. S. Nagel

1999-07-31

West Valley Demonstration Project health physicists and environment scientists discovered a series of errors in a subcontractor's spreadsheet being used to reduce data as part of their strontium-90 analytical process.

LCoE Analysis of Surge-Mode WEC

DOE Data Explorer

Bill Staby

2017-03-07

Spreadsheet which provides estimates of reductions in Levelized Cost of Energy for a surge-mode wave energy converter (WEC). This is made available via adoption of the advanced control strategies developed during this research effort.

Integrated developmental model of life-support capabilities in wheat

NASA Technical Reports Server (NTRS)

Darnell, R. L.; Obrien, C. O.

1994-01-01

The objective of this project was to develop a model for CO2, O2, H2O, and nitrogen use during the life cycle of wheat. Spreadsheets and accompanying graphs were developed to illustrate plant population reactions to environmental parameters established in the Controlled Ecological Life Support System (CELSS) program at Kennedy Space Center, Fl. The spreadsheets and graphs were produced using validated biomass production chamber (BPC) data from BWT931. Conditions of the BPC during the 83 day plant growth period were as follows: The BPC area is 27.8 m(exp 2), volume is 113 m(exp 3). Temperatures during the 83 day plant growth period ranged from 16.3 to 24.8 C during the light cycle (except for day 69, when the minimum and maximum temperatures were 7.7 C and 7.9 C, respectively) and 14.5 C and 23.6 C during the dark cycle (except for day 49, when the minimum and maximum temperatures were 11.1 C and 11.3 C, respectively). Relative humidity was 85 percent for the first seven days of plant growth, and 70 percent thereafter. The plant leaf canopy area was 10 m(exp 2). Presented is a list and explanation of each spreadsheet and accompanying graph(s), conditions under which the data were collected, and formulas used to obtain each result.

Economic Comparison of Processes Using Spreadsheet Programs

NASA Technical Reports Server (NTRS)

Ferrall, J. F.; Pappano, A. W.; Jennings, C. N.

1986-01-01

Inexpensive approach aids plant-design decisions. Commercially available electronic spreadsheet programs aid economic comparison of different processes for producing particular end products. Facilitates plantdesign decisions without requiring large expenditures for powerful mainframe computers.

The meaning of diagnostic test results: a spreadsheet for swift data analysis.

PubMed

Maceneaney, P M; Malone, D E

2000-03-01

To design a spreadsheet program to: (a) analyse rapidly diagnostic test result data produced in local research or reported in the literature; (b) correct reported predictive values for disease prevalence in any population; (c) estimate the post-test probability of disease in individual patients. Microsoft Excel(TM)was used. Section A: a contingency (2 x 2) table was incorporated into the spreadsheet. Formulae for standard calculations [sample size, disease prevalence, sensitivity and specificity with 95% confidence intervals, predictive values and likelihood ratios (LRs)] were linked to this table. The results change automatically when the data in the true or false negative and positive cells are changed. Section B: this estimates predictive values in any population, compensating for altered disease prevalence. Sections C-F: Bayes' theorem was incorporated to generate individual post-test probabilities. The spreadsheet generates 95% confidence intervals, LRs and a table and graph of conditional probabilities once the sensitivity and specificity of the test are entered. The latter shows the expected post-test probability of disease for any pre-test probability when a test of known sensitivity and specificity is positive or negative. This spreadsheet can be used on desktop and palmtop computers. The MS Excel(TM)version can be downloaded via the Internet from the URL ftp://radiography.com/pub/Rad-data99.xls A spreadsheet is useful for contingency table data analysis and assessment of the clinical meaning of diagnostic test results. Copyright 2000 The Royal College of Radiologists.

Spreadsheet Works: Graphing Functions on a Spreadsheet.

ERIC Educational Resources Information Center

Ramamurthi, V. S.

1989-01-01

Explains graphing functions when using LOTUS 1-2-3. Provides examples and explains keystroke entries needed to make the graphs. Notes up to six functions can be displayed on the same set of axes. (MVL)

Fitting Orbits to Jupiter's Moons with a Spreadsheet.

ERIC Educational Resources Information Center

Bridges, Richard

1995-01-01

Describes how a spreadsheet is used to fit a circular orbit model to observations of Jupiter's moons made with a small telescope. Kepler's Third Law and the inverse square law of gravity are observed. (AIM)

Software validation applied to spreadsheets used in laboratories working under ISO/IEC 17025

NASA Astrophysics Data System (ADS)

Banegas, J. M.; Orué, M. W.

2016-07-01

Several documents deal with software validation. Nevertheless, more are too complex to be applied to validate spreadsheets - surely the most used software in laboratories working under ISO/IEC 17025. The method proposed in this work is intended to be directly applied to validate spreadsheets. It includes a systematic way to document requirements, operational aspects regarding to validation, and a simple method to keep records of validation results and modifications history. This method is actually being used in an accredited calibration laboratory, showing to be practical and efficient.

Small-College Software Survey.

ERIC Educational Resources Information Center

Birch, Anthony D.

1986-01-01

Computers have a great number of potential uses at the small college. A survey of the role of software in the effective use of computers is described. Hardware characteristics, spreadsheets, purchasing or developing software, and software information are discussed. (Author/MLW)

FHWA infrastructure carbon estimator : final report and user’s guide.

DOT National Transportation Integrated Search

2014-09-01

This study developed a method of estimating energy and GHG emissions from construction and maintenance of transportation systems. Designed as a spreadsheet-based model for practitioners, FHWAs Infrastructure Carbon Estimator is based on data colle...

Automatic Grading of Spreadsheet and Database Skills

ERIC Educational Resources Information Center

Kovacic, Zlatko J.; Green, John Steven

2012-01-01

Growing enrollment in distance education has increased student-to-lecturer ratios and, therefore, increased the workload of the lecturer. This growing enrollment has resulted in mounting efforts to develop automatic grading systems in an effort to reduce this workload. While research in the design and development of automatic grading systems has a…

User's Manual for Space Debris Surfaces (SD_SURF)

NASA Technical Reports Server (NTRS)

Elfer, N. C.

1996-01-01

A unique collection of computer codes, Space Debris Surfaces (SD_SURF), have been developed to assist in the design and analysis of space debris protection systems. SD_SURF calculates and summarizes a vehicle's vulnerability to space debris as a function of impact velocity and obliquity. An SD_SURF analysis will show which velocities and obliquities are the most probable to cause a penetration. This determination can help the analyst select a shield design which is best suited to the predominant penetration mechanism. The analysis also indicates the most suitable parameters for development or verification testing. The SD_SURF programs offer the option of either FORTRAN programs and Microsoft EXCEL spreadsheets and macros. The FORTRAN programs work with BUMPERII version 1.2a or 1.3 (Cosmic released). The EXCEL spreadsheets and macros can be used independently or with selected output from the SD_SURF FORTRAN programs.

From differences in means between cases and controls to risk stratification: a business plan for biomarker development.

PubMed

Wentzensen, Nicolas; Wacholder, Sholom

2013-02-01

Researchers developing biomarkers for early detection can determine the potential for clinical benefit at early stages of development. We provide the theoretical background showing the quantitative connection between biomarker levels in cases and controls and clinically meaningful risk measures, as well as a spreadsheet for researchers to use in their own research. We provide researchers with tools to decide whether a test is useful, whether it needs technical improvement, whether it may work only in specific populations, or whether any further development is futile. The methods described here apply to any method that aims to estimate risk of disease based on biomarkers, clinical tests, genetics, environment, or behavior. Many efforts go into futile biomarker development and premature clinical testing. In many instances, predictions for translational success or failure can be made early, simply based on critical analysis of case–control data. Our article presents well-established theory in a form that can be appreciated by biomarker researchers. Furthermore, we provide an interactive spreadsheet that links biomarker performance with specific disease characteristics to evaluate the promise of biomarker candidates at an early stage.

Petrogenetic Modeling with a Spreadsheet Program.

ERIC Educational Resources Information Center

Holm, Paul Eric

1988-01-01

Describes how interactive programs for scientific modeling may be created by using spreadsheet software such as LOTUS 1-2-3. Lists the advantages of using this method. Discusses fractional distillation, batch partial melting, and combination models as examples. (CW)

Incorporating Inquiry into Upper-Level Homework Assignments: The Mini-Journal

NASA Astrophysics Data System (ADS)

Whittington, A. G.; Speck, A. K.; Witzig, S. B.; Abell, S. K.

2009-12-01

The U.S. National Science Education Standards provide guidelines for teaching science through inquiry, where students actively develop their understanding of science by combining scientific knowledge with reasoning and thinking skills. Inquiry activities include reading scientific literature, generating hypotheses, designing and carrying out investigations, interpreting data, and formulating conclusions. Inquiry-based instruction emphasizes questions, evidence, and explanation, the essential features of inquiry. As part of an NSF-funded project, “CUES: Connecting Undergraduates to the Enterprise of Science,” new inquiry-based homework materials were developed for two upper-level classes at the University of Missouri: Geochemistry (required for Geology majors), and Solar System Science (open to seniors and graduate students, co-taught and cross-listed between Geology and Physics & Astronomy). We engage students in inquiry-based learning by presenting homework exercises as “mini-journal” articles that follow the format of a scientific journal article, including a title, authors, abstract, introduction, methods, results, discussion and citations to peer-reviewed literature. The mini-journal provides a scaffold and serves as a springboard for students to develop and carry out their own follow-up investigation. They then present their findings in the form of their own mini-journal. Mini-journals replace traditional homework problem sets with a format that more directly reflects and encourages scientific practice. Students are engaged in inquiry-based homework which encompass doing, thinking, and communicating, while the minijournal allows the instructor to contain lines of inquiry within the limits posed by available resources. In the examples we present, research is conducted via spreadsheet modeling, where the students develop their own spreadsheets. The key differences between the old and new formats include (i) the active participation of the students in defining the problem that they will pursue, (ii) the open-ended nature of the inquiry, such that students need to recognize when they have enough information to answer their question, (iii) presentation of results in graphical and tabular formats, and (iv) a written discussion of their findings. We present both the rationale for and concept of using mini-journal homeworks, and provide specific examples we are currently employing in classes. In addition, we explore the challenges (real and perceived) and successes associated with implementing such a technique, and examine student feedback comparing mini-journal and traditional homework formats from the same classes.

A user interface for the Kansas Geological Survey slug test model.

PubMed

Esling, Steven P; Keller, John E

2009-01-01

The Kansas Geological Survey (KGS) developed a semianalytical solution for slug tests that incorporates the effects of partial penetration, anisotropy, and the presence of variable conductivity well skins. The solution can simulate either confined or unconfined conditions. The original model, written in FORTRAN, has a text-based interface with rigid input requirements and limited output options. We re-created the main routine for the KGS model as a Visual Basic macro that runs in most versions of Microsoft Excel and built a simple-to-use Excel spreadsheet interface that automatically displays the graphical results of the test. A comparison of the output from the original FORTRAN code to that of the new Excel spreadsheet version for three cases produced identical results.

Spreadsheet log analysis in subsurface geology

USGS Publications Warehouse

Doveton, J.H.

2000-01-01

Most of the direct knowledge of the geology of the subsurface is gained from the examination of core and drill-cuttings recovered from boreholes drilled by the petroleum and water industries. Wireline logs run in these same boreholes generally have been restricted to tasks of lithostratigraphic correlation and thee location of hydrocarbon pay zones. However, the range of petrophysical measurements has expanded markedly in recent years, so that log traces now can be transformed to estimates of rock composition. Increasingly, logs are available in a digital format that can be read easily by a desktop computer and processed by simple spreadsheet software methods. Taken together, these developments offer accessible tools for new insights into subsurface geology that complement the traditional, but limited, sources of core and cutting observations.

Applying 'evidence-based medicine' theory to interventional radiology. Part 2: a spreadsheet for swift assessment of procedural benefit and harm.

PubMed

Maceneaney, P M; Malone, D E

2000-12-01

To design a spreadsheet program to analyse interventional radiology (IR) data rapidly produced in local research or reported in the literature using 'evidence-based medicine' (EBM) parameters of treatment benefit and harm. Microsoft Excel(TM)was used. The spreadsheet consists of three worksheets. The first shows the 'Levels of Evidence and Grades of Recommendations' that can be assigned to therapeutic studies as defined by the Oxford Centre for EBM. The second and third worksheets facilitate the EBM assessment of therapeutic benefit and harm. Validity criteria are described. These include the assessment of the adequacy of sample size in the detection of possible procedural complications. A contingency (2 x 2) table for raw data on comparative outcomes in treated patients and controls has been incorporated. Formulae for EBM calculations are related to these numerators and denominators in the spreadsheet. The parameters calculated are benefit - relative risk reduction, absolute risk reduction, number needed to treat (NNT). Harm - relative risk, relative odds, number needed to harm (NNH). Ninety-five per cent confidence intervals are calculated for all these indices. The results change automatically when the data in the therapeutic outcome cells are changed. A final section allows the user to correct the NNT or NNH in their application to individual patients. This spreadsheet can be used on desktop and palmtop computers. The MS Excel(TM)version can be downloaded via the Internet from the URL ftp://radiography.com/pub/TxHarm00.xls. A spreadsheet is useful for the rapid analysis of the clinical benefit and harm from IR procedures.

ISA-TAB-Nano: a specification for sharing nanomaterial research data in spreadsheet-based format.

PubMed

Thomas, Dennis G; Gaheen, Sharon; Harper, Stacey L; Fritts, Martin; Klaessig, Fred; Hahn-Dantona, Elizabeth; Paik, David; Pan, Sue; Stafford, Grace A; Freund, Elaine T; Klemm, Juli D; Baker, Nathan A

2013-01-14

The high-throughput genomics communities have been successfully using standardized spreadsheet-based formats to capture and share data within labs and among public repositories. The nanomedicine community has yet to adopt similar standards to share the diverse and multi-dimensional types of data (including metadata) pertaining to the description and characterization of nanomaterials. Owing to the lack of standardization in representing and sharing nanomaterial data, most of the data currently shared via publications and data resources are incomplete, poorly-integrated, and not suitable for meaningful interpretation and re-use of the data. Specifically, in its current state, data cannot be effectively utilized for the development of predictive models that will inform the rational design of nanomaterials. We have developed a specification called ISA-TAB-Nano, which comprises four spreadsheet-based file formats for representing and integrating various types of nanomaterial data. Three file formats (Investigation, Study, and Assay files) have been adapted from the established ISA-TAB specification; while the Material file format was developed de novo to more readily describe the complexity of nanomaterials and associated small molecules. In this paper, we have discussed the main features of each file format and how to use them for sharing nanomaterial descriptions and assay metadata. The ISA-TAB-Nano file formats provide a general and flexible framework to record and integrate nanomaterial descriptions, assay data (metadata and endpoint measurements) and protocol information. Like ISA-TAB, ISA-TAB-Nano supports the use of ontology terms to promote standardized descriptions and to facilitate search and integration of the data. The ISA-TAB-Nano specification has been submitted as an ASTM work item to obtain community feedback and to provide a nanotechnology data-sharing standard for public development and adoption.

ISA-TAB-Nano: A Specification for Sharing Nanomaterial Research Data in Spreadsheet-based Format

PubMed Central

2013-01-01

Background and motivation The high-throughput genomics communities have been successfully using standardized spreadsheet-based formats to capture and share data within labs and among public repositories. The nanomedicine community has yet to adopt similar standards to share the diverse and multi-dimensional types of data (including metadata) pertaining to the description and characterization of nanomaterials. Owing to the lack of standardization in representing and sharing nanomaterial data, most of the data currently shared via publications and data resources are incomplete, poorly-integrated, and not suitable for meaningful interpretation and re-use of the data. Specifically, in its current state, data cannot be effectively utilized for the development of predictive models that will inform the rational design of nanomaterials. Results We have developed a specification called ISA-TAB-Nano, which comprises four spreadsheet-based file formats for representing and integrating various types of nanomaterial data. Three file formats (Investigation, Study, and Assay files) have been adapted from the established ISA-TAB specification; while the Material file format was developed de novo to more readily describe the complexity of nanomaterials and associated small molecules. In this paper, we have discussed the main features of each file format and how to use them for sharing nanomaterial descriptions and assay metadata. Conclusion The ISA-TAB-Nano file formats provide a general and flexible framework to record and integrate nanomaterial descriptions, assay data (metadata and endpoint measurements) and protocol information. Like ISA-TAB, ISA-TAB-Nano supports the use of ontology terms to promote standardized descriptions and to facilitate search and integration of the data. The ISA-TAB-Nano specification has been submitted as an ASTM work item to obtain community feedback and to provide a nanotechnology data-sharing standard for public development and adoption. PMID:23311978

The Computer Bulletin Board. Modified Gran Plots of Very Weak Acids on a Spreadsheet.

ERIC Educational Resources Information Center

Chau, F. T.; And Others

1990-01-01

Presented are two applications of computer technology to chemistry instruction: the use of a spreadsheet program to analyze acid-base titration curves and the use of database software to catalog stockroom inventories. (CW)

Computer Corner: Spreadsheets, Power Series, Generating Functions, and Integers.

ERIC Educational Resources Information Center

Snow, Donald R.

1989-01-01

Implements a table algorithm on a spreadsheet program and obtains functions for several number sequences such as the Fibonacci and Catalan numbers. Considers other applications of the table algorithm to integers represented in various number bases. (YP)

Computer Literacy for Teachers.

ERIC Educational Resources Information Center

Sarapin, Marvin I.; Post, Paul E.

Basic concepts of computer literacy are discussed as they relate to industrial arts/technology education. Computer hardware development is briefly examined, and major software categories are defined, including database management, computer graphics, spreadsheet programs, telecommunications and networking, word processing, and computer assisted and…

Relativity on a Spreadsheet.

ERIC Educational Resources Information Center

Carson, S. R.

1998-01-01

Presents a method for using spreadsheets to model special relativistic phenomena based on the connection between electric and magnetic fields in special relativity. Uses the time dilation equation to carry out transformations between reference frames that show the connection between the fields quantitatively. (DDR)

Improving Students' Understanding of the Importance of Economic Consequences in Standard Setting: A Computerized Spreadsheet Tool.

ERIC Educational Resources Information Center

Ivancevich, Daniel M.; And Others

1996-01-01

Points out that political and economic pressures have sometimes caused the Financial Accounting Standards Board to alter standards. Presents a spreadsheet tool that demonstrates the economic consequences of adopting accounting standards. (SK)

76 FR 34124 - Civil Supersonic Aircraft Panel Discussion

Federal Register 2010, 2011, 2012, 2013, 2014

2011-06-10

... and continuing to the second line in the second column, the Web site address should read as follows: https://spreadsheets.google.com/spreadsheet/viewform?formkey=dEFEdlRnYzBiaHZtTUozTHVtbkF4d0E6MQ . [FR...

Assessment of ODOT culvert load rating spreadsheets for use in Michigan.

DOT National Transportation Integrated Search

2013-01-01

The project Assessment of ODOT Culvert Load Rating Spreadsheets for use in Michigan was : a short time-frame project funded by the Michigan Department of Transportation (MDOT) : through the Center for Structural Durability (CSD) at Michigan Tec...

2017 Annual Technology Baseline (ATB): Cost and Performance Data for Electricity Generation Technologies

DOE Data Explorer

Hand, Maureen; Augustine, Chad; Feldman, David; Kurup, Parthiv; Beiter, Philipp; O'Connor, Patrick

2017-08-21

Each year since 2015, NREL has presented Annual Technology Baseline (ATB) in a spreadsheet that contains detailed cost and performance data (both current and projected) for renewable and conventional technologies. The spreadsheet includes a workbook for each technology. This spreadsheet provides data for the 2017 ATB. In this edition of the ATB, offshore wind power has been updated to include 15 technical resource groups. And, two options are now provided for representing market conditions for project financing, including current market conditions and long-term historical conditions. For more information, see https://atb.nrel.gov/.

The Development of Computational Thinking in a High School Chemistry Course

ERIC Educational Resources Information Center

Matsumoto, Paul S.; Cao, Jiankang

2017-01-01

Computational thinking is a component of the Science and Engineering Practices in the Next Generation Science Standards, which were adopted by some states. We describe the activities in a high school chemistry course that may develop students' computational thinking skills by primarily using Excel, a widely available spreadsheet software. These…

Simulations of the cardiac action potential based on the Hodgkin-Huxley kinetics with the use of Microsoft Excel spreadsheets.

PubMed

Wu, Sheng-Nan

2004-03-31

The purpose of this study was to develop a method to simulate the cardiac action potential using a Microsoft Excel spreadsheet. The mathematical model contained voltage-gated ionic currents that were modeled using either Beeler-Reuter (B-R) or Luo-Rudy (L-R) phase 1 kinetics. The simulation protocol involves the use of in-cell formulas directly typed into a spreadsheet. The capability of spreadsheet iteration was used in these simulations. It does not require any prior knowledge of computer programming, although the use of the macro language can speed up the calculation. The normal configuration of the cardiac ventricular action potential can be well simulated in the B-R model that is defined by four individual ionic currents, each representing the diffusion of ions through channels in the membrane. The contribution of Na+ inward current to the rate of depolarization is reproduced in this model. After removal of Na+ current from the model, a constant current stimulus elicits an oscillatory change in membrane potential. In the L-R phase 1 model where six types of ionic currents were defined, the effect of extracellular K+ concentration on changes both in the time course of repolarization and in the time-independent K+ current can be demonstrated, when the solutions are implemented in Excel. Using the simulation protocols described here, the users can readily study and graphically display the underlying properties of ionic currents to see how changes in these properties determine the behavior of the heart cell. The method employed in these simulation protocols may also be extended or modified to other biological simulation programs.

An Introduction to Simulated Annealing

ERIC Educational Resources Information Center

Albright, Brian

2007-01-01

An attempt to model the physical process of annealing lead to the development of a type of combinatorial optimization algorithm that takes on the problem of getting trapped in a local minimum. The author presents a Microsoft Excel spreadsheet that illustrates how this works.

Evaluation of work zone enhancement software programs.

DOT National Transportation Integrated Search

2009-09-01

The Missouri Department of Transportation (MoDOT) is looking for software tools that can assist in : developing effective plans to manage and communicate work zone activities. QuickZone, CA4PRS, : VISSIM, and Spreadsheet models are the tools that MoD...

User manual and spreadsheet tool for implementing performance planning for rural planning organizations.

DOT National Transportation Integrated Search

2017-03-01

The performance-planning tool developed as part of this project is intended for use with the guidebook for establishing and using rural performance based transportation system assessment, monitoring, planning, and programming to support the rural pla...

Using a Spreadsheet To Explore Melting, Dissolving and Phase Diagrams.

ERIC Educational Resources Information Center

Goodwin, Alan

2002-01-01

Compares phase diagrams relating to the solubilities and melting points of various substances in textbooks with those generated by a spreadsheet using data from the literature. Argues that differences between the diagrams give rise to new chemical insights. (Author/MM)

The Use of Lotus 1-2-3 Macros in Engineering Calculations.

ERIC Educational Resources Information Center

Rosen, Edward M.

1990-01-01

Described are the use of spreadsheet programs in chemical engineering calculations using Lotus 1-2-3 macros. Discusses the macro commands, subroutine operations, and solution of partial differential equation. Provides examples of the subroutine programs and spreadsheet solution. (YP)

Academic Testing and Grading with Spreadsheet Software.

ERIC Educational Resources Information Center

Ho, James K.

1987-01-01

Explains how spreadsheet software can be used in the design and grading of academic tests and in assigning grades. Macro programs and menu-driven software are highlighted and an example using IBM PCs and Lotus 1-2-3 software is given. (Author/LRW)

Spreadsheet Toolkit for Ulysses Hi-Scale Measurements of Interplanetary Ions and Electrons

NASA Astrophysics Data System (ADS)

Reza, J. Z.; Lanzerotti, L. J.; Denker, C.; Patterson, D.; Amstrong, T. P.

2004-05-01

Throughout the entire Ulysses out-of-the-ecliptic solar polar mission, the Heliosphere Instrument for Spectra, Composition, and Anisotropy at Low Energies (HI-SCALE) has collected measurements of interplanetary ions and electrons. Time-series of electron and ion fluxes obtained since 1990 have been carefully calibrated and will be stored in a data management system, which will be publicly accessible via the WWW. The goal of the Virtual Solar Observatory (VSO) is to provide data uniformly and efficiently to a diverse user community. However, data dissemination can only be a first step, which has to be followed by a suite of data analysis tools that are tailored towards a diverse user community in science, technology, and education. The widespread use and familiarity of spreadsheets, which are available at low cost or open source for many operating systems, make them an interesting tool to investigate for the analysis of HI-SCALE data. The data are written in comma separated variable (CSV) format, which is commonly used in spreadsheet programs. CSV files can simply be linked as external data to spreadsheet templates, which in turn can be used to generate tables and figures of basic statistical properties and frequency distributions, temporal evolution of electron and ion spectra, comparisons of various energy channels, automatic detection of solar events, solar cycle variations, and space weather. Exploring spreadsheet-assisted data analysis in the context of information technology research, data base information search and retrieval, and data visualization potentially impacts other VSO components, where diverse user communities are targeted. Finally, this presentation is the result of an undergraduate research project, which will allow us to evaluate the performance of user-based spreadsheet analysis "benchmarked" at the undergraduate skill level.

Design and Evaluation of a Personal Diffusion Battery.

PubMed

Vosburgh, Donna J H; Klein, Timothy; Sheehan, Maura; Anthony, T Renee; Peters, Thomas M

A four-stage personal diffusion battery (pDB) was designed and constructed to measure submicron particle size distributions. The pDB consisted of a screen-type diffusion battery, solenoid valve system, and electronic controller. A data inversion spreadsheet was created to solve for the number median diameter (NMD), geometric standard deviation (GSD), and particle number concentration of unimodal aerosols using stage number concentrations from the pDB combined with a handheld condensation particle counter (pDB+CPC). The inversion spreadsheet included particle entry losses, theoretical penetrations across screens, the detection efficiency of the CPC, and constraints so the spreadsheet solved to values within the pDB range. Size distribution parameters (NMD, GSD, and number concentration) measured with the pDB+CPC with inversion spreadsheet were within 25% of those measured with a scanning mobility particle sizer (SMPS) for 5 of 12 polydisperse combustion aerosols. For three tests conducted with propylene torch exhaust, the pDB+CPC with inversion spreadsheet successfully identified that the NMD was smaller than the constraint value of 16 nm. The ratio of the nanoparticle portion of the aerosol compared to the reference ( R nano ) was calculated to determine the ability of pDB+CPC with inversion spreadsheet to measure the nanoparticle portion of the aerosols. The R nano ranged from 0.87 to 1.01 when the inversion solved and from 0.06 to 2.01 when the inversion solved to a constraint. The pDB combined with CPC has limited use as a personal monitor but combining the pDB with a different detector would allow for the pDB to be used as a personal monitor.

Design and Evaluation of a Personal Diffusion Battery

PubMed Central

Vosburgh, Donna J. H.; Klein, Timothy; Sheehan, Maura; Anthony, T. Renee; Peters, Thomas M.

2016-01-01

A four-stage personal diffusion battery (pDB) was designed and constructed to measure submicron particle size distributions. The pDB consisted of a screen-type diffusion battery, solenoid valve system, and electronic controller. A data inversion spreadsheet was created to solve for the number median diameter (NMD), geometric standard deviation (GSD), and particle number concentration of unimodal aerosols using stage number concentrations from the pDB combined with a handheld condensation particle counter (pDB+CPC). The inversion spreadsheet included particle entry losses, theoretical penetrations across screens, the detection efficiency of the CPC, and constraints so the spreadsheet solved to values within the pDB range. Size distribution parameters (NMD, GSD, and number concentration) measured with the pDB+CPC with inversion spreadsheet were within 25% of those measured with a scanning mobility particle sizer (SMPS) for 5 of 12 polydisperse combustion aerosols. For three tests conducted with propylene torch exhaust, the pDB+CPC with inversion spreadsheet successfully identified that the NMD was smaller than the constraint value of 16 nm. The ratio of the nanoparticle portion of the aerosol compared to the reference (R nano) was calculated to determine the ability of pDB+CPC with inversion spreadsheet to measure the nanoparticle portion of the aerosols. The R nano ranged from 0.87 to 1.01 when the inversion solved and from 0.06 to 2.01 when the inversion solved to a constraint. The pDB combined with CPC has limited use as a personal monitor but combining the pDB with a different detector would allow for the pDB to be used as a personal monitor. PMID:26900207

Simplified risk assessment of noise induced hearing loss by means of 2 spreadsheet models.

PubMed

Lie, Arve; Engdahl, Bo; Tambs, Kristian

2016-11-18

The objective of this study has been to test 2 spreadsheet models to compare the observed with the expected hearing loss for a Norwegian reference population. The prevalence rates of the Norwegian and the National Institute for Occupational Safety and Health (NIOSH) definitions of hearing outcomes were calculated in terms of sex and age, 20-64 years old, for a screened (with no occupational noise exposure) (N = 18 858) and unscreened (N = 38 333) Norwegian reference population from the Nord-Trøndelag Hearing Loss Study (NTHLS). Based on the prevalence rates, 2 different spreadsheet models were constructed in order to compare the prevalence rates of various groups of workers with the expected rates. The spreadsheets were then tested on 10 different occupational groups with varying degrees of hearing loss as compared to a reference population. Hearing of office workers, train drivers, conductors and teachers differed little from the screened reference values based on the Norwegian and the NIOSH criterion. The construction workers, miners, farmers and military had an impaired hearing and railway maintenance workers and bus drivers had a mildly impaired hearing. The spreadsheet models give a valid assessment of the hearing loss. The use of spreadsheet models to compare hearing in occupational groups with that of a reference population is a simple and quick method. The results are in line with comparable hearing thresholds, and allow for significance testing. The method is believed to be useful for occupational health services in the assessment of risk of noise induced hearing loss (NIHL) and the preventive potential in groups of noise-exposed workers. Int J Occup Med Environ Health 2016;29(6):991-999. This work is available in Open Access model and licensed under a CC BY-NC 3.0 PL license.

CTEPP STANDARD OPERATING PROCEDURE FOR ENTERING OR IMPORTING ELECTRONIC DATA INTO THE CTEPP DATABASE (SOP-4.12)

EPA Science Inventory

This SOP described the method used to automatically parse analytical data generated from gas chromatography/mass spectrometry (GC/MS) analyses into CTEPP summary spreadsheets and electronically import the summary spreadsheets into the CTEPP study database.

A spreadsheet template compatible with Microsoft Excel and iWork Numbers that returns the simultaneous confidence intervals for all pairwise differences between multiple sample means.

PubMed

Brown, Angus M

2010-04-01

The objective of the method described in this paper is to develop a spreadsheet template for the purpose of comparing multiple sample means. An initial analysis of variance (ANOVA) test on the data returns F--the test statistic. If F is larger than the critical F value drawn from the F distribution at the appropriate degrees of freedom, convention dictates rejection of the null hypothesis and allows subsequent multiple comparison testing to determine where the inequalities between the sample means lie. A variety of multiple comparison methods are described that return the 95% confidence intervals for differences between means using an inclusive pairwise comparison of the sample means. 2009 Elsevier Ireland Ltd. All rights reserved.

Financial Analysis for R&D Decisions.

ERIC Educational Resources Information Center

Carter, Robert

1997-01-01

Using personal computer spreadsheet software, standard corporate financial analysis can help university research administrators communicate the value of research and development to sponsors and other stakeholders; balance projects, technologies, or categories of research; and continually assess the value of investing in ongoing projects. It also…

PREDICTING EVAPORATION RATES AND TIMES FOR SPILLS OF CHEMICAL MIXTURES

EPA Science Inventory

Spreadsheet and short-cut methods have been developed for predicting evaporation rates and evaporation times for spills (and constrained baths) of chemical mixtures. Steady-state and time-varying predictions of evaporation rates can be made for six-component mixtures, includ...

COAL UTILITY EVIRONMENTAL COST (CUECOST) WORKBOOK USER'S MANUAL

EPA Science Inventory

The document is a user's manual for the Coal Utility Environmental Cost (CUECost) workbook (an interrelated set of spreadsheets) and documents its development and the validity of methods used to estimate installed capital ad annualize costs. The CUECost workbook produces rough-or...

Science: Database Programs and the Study of Seashells.

ERIC Educational Resources Information Center

McCurry, Niki; McCurry, Alan

1992-01-01

Discusses the dynamics and outcomes of an unplanned classroom activity that developed from the integration of the use of spreadsheets with the study of the characteristics of previously collected seashells, specifically their color, size, shape, texture, and any other obvious differences. (JJK)

Implementation of straight and curved steel girder erection design tools construction : summary.

DOT National Transportation Integrated Search

2010-11-05

Project 0-5574 Curved Plate Girder Design for Safe and Economical Construction, resulted in the : development of two design tools, UT Lift and UT Bridge. UT Lift is a spreadsheet-based program for analyzing : steel girders during lifting while ...

Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel.

PubMed

Zou, Jiaqi; Li, Na

2013-09-01

Proper design of nucleic acid sequences is crucial for many applications. We have previously established a thermodynamics-based quantitative model to help design aptamer-based nucleic acid probes by predicting equilibrium concentrations of all interacting species. To facilitate customization of this thermodynamic model for different applications, here we present a generic and easy-to-use platform to implement the algorithm of the model with Microsoft(®) Excel formulas and VBA (Visual Basic for Applications) macros. Two Excel spreadsheets have been developed: one for the applications involving only nucleic acid species, the other for the applications involving both nucleic acid and non-nucleic acid species. The spreadsheets take the nucleic acid sequences and the initial concentrations of all species as input, guide the user to retrieve the necessary thermodynamic constants, and finally calculate equilibrium concentrations for all species in various bound and unbound conformations. The validity of both spreadsheets has been verified by comparing the modeling results with the experimental results on nucleic acid sequences reported in the literature. This Excel-based platform described here will allow biomedical researchers to rationalize the sequence design of nucleic acid probes using the thermodynamics-based modeling even without relevant theoretical and computational skills. Copyright © 2013 Elsevier Ireland Ltd. All rights reserved.

Use of the partial farm budget technique to predict the economic impact of the flock management decision to use B-mode ultrasonographic pregnancy diagnosis.

PubMed

Sprecher, D J; Ley, W B; Whittier, W D; Bowen, J M; Thatcher, C D; Pelzer, K D; Moore, J M

1989-07-15

A computer spreadsheet was developed to predict the economic impact of a management decision to use B-mode ultrasonographic ovine pregnancy diagnosis. The spreadsheet design and spreadsheet cell formulas are provided. The program used the partial farm budget technique to calculate net return (NR) or cash flow changes that resulted from the decision to use ultrasonography. Using the program, either simple pregnancy diagnosis or pregnancy diagnosis with the ability to determine singleton or multiple pregnancies may be compared with no flock ultrasonographic pregnancy diagnosis. A wide range of user-selected regional variables are used to calculate the cash flow changes associated with the ultrasonography decisions. A variable may be altered through a range of values to conduct a sensitivity analysis of predicted NR. Example sensitivity analyses are included for flock conception rate, veterinary ultrasound fee, and the price of corn. Variables that influence the number of cull animals and the cost of ultrasonography have the greatest impact on predicted NR. Because the determination of singleton or multiple pregnancies is more time consuming, its economic practicality in comparison with simple pregnancy diagnosis is questionable. The value of feed saved by identifying and separately feeding ewes with singleton pregnancies is not offset by the increased ultrasonography cost.

Buffer$--An Economic Analysis Tool

Treesearch

Gary Bentrup

2007-01-01

Buffer$ is an economic spreadsheet tool for analyzing the cost-benefits of conservation buffers by resource professionals. Conservation buffers are linear strips of vegetation managed for multiple landowner and societal objectives. The Microsoft Excel based spreadsheet can calculate potential income derived from a buffer, including income from cost-share/incentive...

A spreadsheet that calculates meteor orbits

NASA Astrophysics Data System (ADS)

Langbroek, M.

2004-08-01

The author has written an MS Excel spreadsheet application called Metorb08.xls which calculates a meteor's orbital elements from its apparent radiant position and initial speed. It can be downloaded from URL http://home.wanadoo.nl/marco.langbroek along with a suite of other meteor-related Excel applications.

Automated Formative Feedback and Summative Assessment Using Individualised Spreadsheet Assignments

ERIC Educational Resources Information Center

Blayney, Paul; Freeman, Mark

2004-01-01

This paper reports on the effects of automating formative feedback at the student's discretion and automating summative assessment with individualised spreadsheet assignments. Quality learning outcomes are achieved when students adopt deep approaches to learning (Ramsden, 2003). Learning environments designed to align assessment to learning…

Introduction to Classroom Sprego

ERIC Educational Resources Information Center

Csernoch, Mária; Biró, Piroska

2016-01-01

Sprego is programming with spreadsheet functions. The present paper provides introductory Sprego examples which have so far only been available in Hungarian. Spreadsheet environments offer both a programming tool which best serves beginner and end-user programmers' interest, and an approach which lightens the burden of coding and language details.…

The Devil and Daniel's Spreadsheet

ERIC Educational Resources Information Center

Burke, Maurice J.

2012-01-01

"When making mathematical models, technology is valuable for varying assumptions, exploring consequences, and comparing predictions with data," notes the Common Core State Standards Initiative (2010, p. 72). This exploration of the recursive process in the Devil and Daniel Webster problem reveals that the symbolic spreadsheet fits this bill.…

Hydrogen Financial Analysis Scenario Tool (H2FAST) Documentation

Science.gov Websites

for the web and spreadsheet versions of H2FAST. H2FAST Web Tool User's Manual H2FAST Spreadsheet Tool User's Manual (DRAFT) Technical Support Send questions or feedback about H2FAST to H2FAST@nrel.gov. Home

EasyDelta: A spreadsheet for kinetic modeling of the stable carbon isotope composition of natural gases

NASA Astrophysics Data System (ADS)

Zou, Yan-Rong; Wang, Lianyuan; Shuai, Yanhua; Peng, Ping'an

2005-08-01

A new kinetic model and an Excel © spreadsheet program for modeling the stable carbon isotope composition of natural gases is provided in this paper. The model and spreadsheet could be used to describe and predict the variances in stable carbon isotope of natural gases under both experimental and geological conditions with heating temperature or geological time. It is a user-friendly convenient tool for the modeling of isotope variation with time under experimental and geological conditions. The spreadsheet, based on experimental data, requires the input of the kinetic parameters of gaseous hydrocarbons generation. Some assumptions are made in this model: the conventional (non-isotope species) kinetic parameters represent the light isotope species; the initial isotopic value is the same for all parallel chemical reaction of gaseous hydrocarbons generation for simplicity, the re-exponential factor ratio, 13A/ 12A, is a constant, and both heavy and light isotope species have similar activation energy distribution. These assumptions are common in modeling of isotope ratios. The spreadsheet is used for searching the best kinetic parameters of the heavy isotope species to reach the minimum errors compared with experimental data, and then extrapolating isotopic changes to the thermal history of sedimentary basins. A short calculation example on the variation in δ13C values of methane is provided in this paper to show application to geological conditions.

S2O - A software tool for integrating research data from general purpose statistic software into electronic data capture systems.

PubMed

Bruland, Philipp; Dugas, Martin

2017-01-07

Data capture for clinical registries or pilot studies is often performed in spreadsheet-based applications like Microsoft Excel or IBM SPSS. Usually, data is transferred into statistic software, such as SAS, R or IBM SPSS Statistics, for analyses afterwards. Spreadsheet-based solutions suffer from several drawbacks: It is generally not possible to ensure a sufficient right and role management; it is not traced who has changed data when and why. Therefore, such systems are not able to comply with regulatory requirements for electronic data capture in clinical trials. In contrast, Electronic Data Capture (EDC) software enables a reliable, secure and auditable collection of data. In this regard, most EDC vendors support the CDISC ODM standard to define, communicate and archive clinical trial meta- and patient data. Advantages of EDC systems are support for multi-user and multicenter clinical trials as well as auditable data. Migration from spreadsheet based data collection to EDC systems is labor-intensive and time-consuming at present. Hence, the objectives of this research work are to develop a mapping model and implement a converter between the IBM SPSS and CDISC ODM standard and to evaluate this approach regarding syntactic and semantic correctness. A mapping model between IBM SPSS and CDISC ODM data structures was developed. SPSS variables and patient values can be mapped and converted into ODM. Statistical and display attributes from SPSS are not corresponding to any ODM elements; study related ODM elements are not available in SPSS. The S2O converting tool was implemented as command-line-tool using the SPSS internal Java plugin. Syntactic and semantic correctness was validated with different ODM tools and reverse transformation from ODM into SPSS format. Clinical data values were also successfully transformed into the ODM structure. Transformation between the spreadsheet format IBM SPSS and the ODM standard for definition and exchange of trial data is feasible. S2O facilitates migration from Excel- or SPSS-based data collections towards reliable EDC systems. Thereby, advantages of EDC systems like reliable software architecture for secure and traceable data collection and particularly compliance with regulatory requirements are achievable.

Introducing Artificial Neural Networks through a Spreadsheet Model

ERIC Educational Resources Information Center

Rienzo, Thomas F.; Athappilly, Kuriakose K.

2012-01-01

Business students taking data mining classes are often introduced to artificial neural networks (ANN) through point and click navigation exercises in application software. Even if correct outcomes are obtained, students frequently do not obtain a thorough understanding of ANN processes. This spreadsheet model was created to illuminate the roles of…

Introducing Simulation via the Theory of Records

ERIC Educational Resources Information Center

Johnson, Arvid C.

2011-01-01

While spreadsheet simulation can be a useful method by which to help students to understand some of the more advanced concepts in an introductory statistics course, introducing the simulation methodology at the same time as these concepts can result in student cognitive overload. This article describes a spreadsheet model that has been…

The Spreadsheet in an Educational Setting. Microcomputing Working Paper Series F 84-4.

ERIC Educational Resources Information Center

Wozny, Lucy

This overview of a specific spreadsheet, Microsoft's Multiplan for the Apple Macintosh microcomputer, emphasizes specific features that are important to the academic community, including the mathematical functions of algebra, trigonometry, and statistical analysis. Additional features are summarized, including data formats for both numerical and…

Interactive Spreadsheets in JCE Webware

ERIC Educational Resources Information Center

Coleman, William F.; Fedosky, Edward W.

2005-01-01

A description of the Microsoft Excel spreadsheet simulation, Anharmonicity.xls that can be used to smoothly and continuously switch a plotted function and its quadratic approximation is presented. It can be used in a classroom demonstration or incorporated into a student-centered computer-laboratory exercise to examine the qualitative behavior of…

LOTUS 1-2-3 and Decision Support: Allocating the Monograph Budget.

ERIC Educational Resources Information Center

Perry-Holmes, Claudia

1985-01-01

Describes the use of electronic spreadsheet software for library decision support systems using personal computers. Discussion covers templates, formulas for allocating the materials budget, LOTUS 1-2-3 and budget allocations, choosing a formula, the spreadsheet itself, graphing capabilities, and advantages and disadvantages of templates. Six…

Calculating the Variables of Finance on a Spreadsheet.

ERIC Educational Resources Information Center

Rochowicz, John A., Jr.

The different approaches for solving problems and learning mathematics with technology are invaluable. This paper describes how to determine the variables of the ordinary annuity equation with a spreadsheet. Examples of future value of annuity, sinking fund annuity, the number of periods necessary for periodic payments plus interest to accumulate…

Buyers Guide: Communications Software--Overview; Ratings Digest; Reviews; Benchmarks.

ERIC Educational Resources Information Center

Lockwood, Russ; And Others

1988-01-01

Contains articles which review communications software. Includes "Crosstalk Mark 4,""ProComm,""Freeway Advanced,""Windows InTalk,""Relay Silver," and "Smartcom III." Compares in terms of text proprietary, MCI upload, Test ASCII, Spreadsheet Proprietary, Text XMODEM, Spreadsheet XMODEM, MCI Download, Documentation, Support and Service, ease of use,…

Spreadsheet Analysis of Harvesting Systems

Treesearch

R.B. Rummer; B.L. Lanford

1987-01-01

Harvesting systems can be modeled and analyzed on microcomputers using commercially available "spreadsheet" software. The effect of system or external variables on the production rate or system cost can be evaluated and alternative systems can be easily examined. The tedious calculations associated with such analyses are performed by the computer. For users...

Applied Educational Computing: Putting Skills to Practice.

ERIC Educational Resources Information Center

Thomerson, J. D.

The College of Education at Valdosta State University (Georgia) developed a followup course to their required entry-level educational computing course. The introductory course covers word processing, spreadsheet, database, presentation, Internet, electronic mail, and operating system software and basic computer concepts. Students expressed a need…

Strategies of Successful Technology Integrators. Part I: Streamlining Classroom Management.

ERIC Educational Resources Information Center

McNally, Lynn; Etchison, Cindy

2000-01-01

Discussion of how to develop curriculum that successfully integrates technology into elementary and secondary school classrooms focuses on solutions for school and classroom management tasks. Highlights include Web-based solutions; student activities; word processing; desktop publishing; draw and paint programs; spreadsheets; and database…

Waste Characterization Process

DOE Office of Scientific and Technical Information (OSTI.GOV)

Lambert, Patrick E.

2014-11-01

The purpose is to provide guidance to the Radiological Characterization Reviewer to complete the radiological characterization of waste items. This information is used for Department of Transportation (DOT) shipping and disposal, typically at the Nevada National Security Site (NNSS). Complete characterization ensures compliance with DOT shipping laws and NNSS Waste Acceptance Criteria (WAC). The fines for noncompliance can be extreme. This does not include possible bad press, and endangerment to the public, employees and the environment. A Radiological Characterization Reviewer has an important role in the organization. The scope is to outline the characterization process, but does not to includemore » every possible situation. The Radiological Characterization Reviewer position requires a strong background in Health Physics; therefore, these concepts are minimally addressed. The characterization process includes many Excel spreadsheets that were developed by Michael Enghauser known as the WCT software suite. New Excel spreadsheets developed as part of this project include the Ra- 226 Decider and the Density Calculator by Jesse Bland, MicroShield Density Calculator and Molecular Weight Calculator by Pat Lambert.« less

Space Debris Surfaces (Computer Code): Probability of No Penetration Versus Impact Velocity and Obliquity

NASA Technical Reports Server (NTRS)

Elfer, N.; Meibaum, R.; Olsen, G.

1995-01-01

A unique collection of computer codes, Space Debris Surfaces (SD_SURF), have been developed to assist in the design and analysis of space debris protection systems. SD_SURF calculates and summarizes a vehicle's vulnerability to space debris as a function of impact velocity and obliquity. An SD_SURF analysis will show which velocities and obliquities are the most probable to cause a penetration. This determination can help the analyst select a shield design that is best suited to the predominant penetration mechanism. The analysis also suggests the most suitable parameters for development or verification testing. The SD_SURF programs offer the option of either FORTRAN programs or Microsoft-EXCEL spreadsheets and macros. The FORTRAN programs work with BUMPERII. The EXCEL spreadsheets and macros can be used independently or with selected output from the SD_SURF FORTRAN programs. Examples will be presented of the interaction between space vehicle geometry, the space debris environment, and the penetration and critical damage ballistic limit surfaces of the shield under consideration.

Web-Based Learning for Cultural Heritage: First Experienced with Students of the Private University of Technology in Northern Taiwan

NASA Astrophysics Data System (ADS)

Yen, Y.-N.; Wu, Y.-W.; Weng, K.-H.

2013-07-01

E-learning assisted teaching and learning is the trend of the 21st century and has many advantages - freedom from the constraints of time and space, hypertext and multimedia rich resources - enhancing the interaction between students and the teaching materials. The purpose of this study is to explore how rich Internet resources assisted students with the Western Architectural History course. First, we explored the Internet resources which could assist teaching and learning activities. Second, according to course objectives, we built a web-based platform which integrated the Google spreadsheets form, SIMILE widget, Wikipedia and the Google Maps and applied it to the course of Western Architectural History. Finally, action research was applied to understanding the effectiveness of this teaching/learning mode. Participants were the students of the Department of Architecture in the Private University of Technology in northern Taiwan. Results showed that students were willing to use the web-based platform to assist their learning. They found this platform to be useful in understanding the relationship between different periods of buildings. Through the view of the map mode, this platform also helped students expand their international perspective. However, we found that the information shared by students via the Internet were not completely correct. One possible reason was that students could easily acquire information on Internet but they could not determine the correctness of the information. To conclude, this study found some useful and rich resources that could be well-integrated, from which we built a web-based platform to collect information and present this information in diverse modes to stimulate students' learning motivation. We recommend that future studies should consider hiring teaching assistants in order to ease the burden on teachers, and to assist in the maintenance of information quality.

An evaluation of training of teachers in medical education in four medical schools of Nepal.

PubMed

Baral, Nirmal; Paudel, Bishnu Hari; Das, Binod Kumar Lal; Aryal, Madhukar; Das, Balbhadra Prasad; Jha, Nilambar; Lamsal, Madhab

2007-09-01

Effective teaching is a concern of all teachers. Therefore, regular teachers' training is emphasized globally. B. P. Koirala Institute of Health Sciences (BPKIHS), a health science deemed university situated in eastern region of Nepal has an established Medical Education unit which attempts to improve teaching-learning skills by training faculty members through organizing regular medical education training programs. The aim of the present study was to assess the effectiveness of 3-day training workshop on "Teaching-learning methodology and Evaluation" held in four different medical colleges of Nepal. The workshop was targeted at middle and entry level of health profession teachers who had not been previously exposed to any teacher's training program. The various components, such as teaching-learning principles, writing educational objectives, organizing and sequencing education materials, teaching-learning methods, microteaching and assessment techniques, were incorporated in the workshop. A team of resource persons from BPKIHS were involved in all the four medical institutions. The collection data had two categories of responses: (1) a questionnaire survey of participants at the beginning and end of the workshop to determine their gain in knowledge and (2) a semi-structured questionnaire survey of participants at the end of workshop to evaluate their perception on usefulness of the workshop. The later category had items with three-point likert scale (very useful, useful and not useful) and responses to open-ended questions/ statements to document participants general views. The response was entered into a spreadsheet and analyzed using SPSS. The result showed that all participants (n = 92) improved their scores after attending the workshop (p < 0.001). Majority of respondents expressed that the teaching-learning methods, media, microteaching and evaluation techniques were useful in teaching-learning. The workshop was perceived as an acceptable way of acquiring teaching-learning skills but 39.4% participants expressed that the duration of the workshop was too short. The overall impression about trainers was very positive. Therefore, regular organization of such workshops with addition of new advances in medical education would be highly beneficial to improve teaching learning skill of medical teachers.

Cloud Computing Based E-Learning System

ERIC Educational Resources Information Center

Al-Zoube, Mohammed; El-Seoud, Samir Abou; Wyne, Mudasser F.

2010-01-01

Cloud computing technologies although in their early stages, have managed to change the way applications are going to be developed and accessed. These technologies are aimed at running applications as services over the internet on a flexible infrastructure. Microsoft office applications, such as word processing, excel spreadsheet, access database…

Pilot project - demonstration of capabilities and benefits of bridge load rating through physical testing : tech transfer summary.

DOT National Transportation Integrated Search

2013-08-01

This project demonstrated the capabilities for load testing bridges in Iowa, developed and presented a webinar to local and state engineers, and produced a spreadsheet and benefit evaluation matrix that others can use to preliminarily assess where br...

Mathematical Modeling with MyMaps and Spreadsheets

ERIC Educational Resources Information Center

Weber, Victoria; Fortune, Nicholas; Williams, Derek; Whitehead, Ashley

2016-01-01

Software programs such as Tinkerplots ® or Geometer's Sketchpad ® can help students solve problems in mathematics classes, but may not be available to them after high school. In contrast, many students who become familiar with Internet tools and programs in office packages (word processing, spreadsheets, etc.) may use them daily to enhance their…

A Computer Spreadsheet for Locating Assistive Devices.

ERIC Educational Resources Information Center

Palmer, Catherine V.; Garstecki, Dean C.

1988-01-01

The article presents a directory of assistive devices for persons with hearing impairments in a grid format by distributor and type of device (alerting devices, telephone, TV/radio/stereo, personal communication, group communication, and other). The product locator is also available in spreadsheet form for either the Macintosh or IBM-PC computers.…

Working Together: Google Apps Goes to School

ERIC Educational Resources Information Center

Oishi, Lindsay

2007-01-01

Online collaboration and project-management tools allow people to work together without being in the same place at the same time. However, that is not all, Google Docs & Spreadsheets, for example, allows the creation of documents and spreadsheets just like in Microsoft Word and Excel, but with more collaborative capacity. Google Calendar lets…

Using Spreadsheet Modeling Techniques for Capital Project Review. AIR 1985 Annual Forum Paper.

ERIC Educational Resources Information Center

Kaynor, Robert K.

The value of microcomputer modeling tools and spreadsheets to help college institutional researchers analyze proposed capital projects is discussed, along with strengths and weaknesses of different software packages. Capital budgeting is the analysis that supports decisions about the allocation and commitment of funds to long-term capital…

Negative Effects of Learning Spreadsheet Management on Learning Database Management

ERIC Educational Resources Information Center

Vágner, Anikó; Zsakó, László

2015-01-01

A lot of students learn spreadsheet management before database management. Their similarities can cause a lot of negative effects when learning database management. In this article, we consider these similarities and explain what can cause problems. First, we analyse the basic concepts such as table, database, row, cell, reference, etc. Then, we…

A Simple Spreadsheet Strikes a Nerve among Adjuncts

ERIC Educational Resources Information Center

Stratford, Michael

2012-01-01

Energized by his fellow adjunct professors who had gathered for a national meeting last month in Washington, District of Columbia, Joshua A. Boldt flew home to Athens, Georgia, opened his laptop, and created a Google document. On his personal blog, the writing instructor implored colleagues to contribute to the publicly editable spreadsheet,…

Using a Spreadsheet Scroll Bar to Solve Equilibrium Concentrations

ERIC Educational Resources Information Center

Raviolo, Andres

2012-01-01

A simple, conceptual method is described for using the spreadsheet scroll bar to find the composition of a system at chemical equilibrium. Simulation of any kind of chemical equilibrium can be carried out using this method, and the effects of different disturbances can be predicted. This simulation, which can be used in general chemistry…

Excel Yourself with Personalised Email Messages

ERIC Educational Resources Information Center

McClean, Stephen

2008-01-01

Combining the Excel spreadsheet with an email program provides a very powerful tool for sending students personalised emails. Most email clients now support a Mail Merge facility whereby a generic template is created and information unique to each student record in the spreadsheet is filled into that template, generating tens if not hundreds of…

Perovskite classification: An Excel spreadsheet to determine and depict end-member proportions for the perovskite- and vapnikite-subgroups of the perovskite supergroup

NASA Astrophysics Data System (ADS)

Locock, Andrew J.; Mitchell, Roger H.

2018-04-01

Perovskite mineral oxides commonly exhibit extensive solid-solution, and are therefore classified on the basis of the proportions of their ideal end-members. A uniform sequence of calculation of the end-members is required if comparisons are to be made between different sets of analytical data. A Microsoft Excel spreadsheet has been programmed to assist with the classification and depiction of the minerals of the perovskite- and vapnikite-subgroups following the 2017 nomenclature of the perovskite supergroup recommended by the International Mineralogical Association (IMA). Compositional data for up to 36 elements are input into the spreadsheet as oxides in weight percent. For each analysis, the output includes the formula, the normalized proportions of 15 end-members, and the percentage of cations which cannot be assigned to those end-members. The data are automatically plotted onto the ternary and quaternary diagrams recommended by the IMA for depiction of perovskite compositions. Up to 200 analyses can be entered into the spreadsheet, which is accompanied by data calculated for 140 perovskite compositions compiled from the literature.

ALOG: A spreadsheet-based program for generating artificial logs

Treesearch

Matthew F. Winn; Randolph H. Wynne; Philip A. Araman

2004-01-01

Log sawing simulation computer programs can be valuable tools for training sawyers as well as for testing different sawing patterns. Most available simulation programs rely on databases from which to draw logs and can be very costly and time-consuming to develop. ALOG (Artificial LOg Generator) is a Microsoft Excel®-based computer program that was developed to...

Jobs and Economic Development Impact (JEDI) Model: Offshore Wind User Reference Guide

DOE Office of Scientific and Technical Information (OSTI.GOV)

Lantz, E.; Goldberg, M.; Keyser, D.

2013-06-01

The Offshore Wind Jobs and Economic Development Impact (JEDI) model, developed by NREL and MRG & Associates, is a spreadsheet based input-output tool. JEDI is meant to be a user friendly and transparent tool to estimate potential economic impacts supported by the development and operation of offshore wind projects. This guide describes how to use the model as well as technical information such as methodology, limitations, and data sources.

Company's Unusual Plan to Package Commercial Software with Business Textbooks Produces a Measure of Success.

ERIC Educational Resources Information Center

Watkins, Beverly T.

1992-01-01

Course Technology Inc. has developed 10 products combining textbooks with commercial software for college accounting, business, computer science, and statistics courses. Five of the products use Lotus 1-2-3 spreadsheet software. The products have been positively received by teachers and students. (DB)

Improving the Pedagogy of Capital Structure Theory: An Excel Application

ERIC Educational Resources Information Center

Baltazar, Ramon; Maybee, Bryan; Santos, Michael R.

2012-01-01

This paper uses Excel to enhance the pedagogy of capital structure theory for corporate finance instructors and students. We provide a lesson plan that utilizes Excel spreadsheets and graphs to develop understanding of the theory. The theory is introduced in three scenarios that utilize Modigliani & Miller's Propositions and…

A Comprehensive Enzyme Kinetic Exercise for Biochemistry

ERIC Educational Resources Information Center

Barton, Janice S.

2011-01-01

This article describes a comprehensive treatment of experimental enzyme kinetics strongly coupled to electronic data acquisition and use of spreadsheets to organize data and perform linear and nonlinear least-squares analyses, all in a manner that promotes development of important reasoning skills. Kinetic parameters are obtained for the stable…

Plantation thinning systems in the Southern United States

Treesearch

Bryce J. Stokes; William F. Watson

1996-01-01

This paper reviews southern pine management and thinning practices, describes three harvesting systems for thinning, and presents production and cost estimates, and utilization rates. The costs and product recoveries were developed from published sources using a spreadsheet analysis. Systems included tree-length, flail/chip, and cut-to-length. The estimated total...

National Geothermal Data System Hub Deployment Timeline (Appendix E-1-d)

DOE Office of Scientific and Technical Information (OSTI.GOV)

Caudill, Christy

Excel spreadsheet describing activity, spending, and development for the four data hubs (Arizona Geoloical Survey, Kentucky Geological Survey, Illinois Geological Survey, and Nevada Bureau of Mines and Geology) serving data for the National Geothermal Data System under the State Contributions to the National Geothermal Data System Project.

Academics' perceptions of the use and relevance of software in quantitative and financial disciplines

NASA Astrophysics Data System (ADS)

Kyng, Timothy; Tickle, Leonie; Wood, Leigh

2013-03-01

Software may be used in university teaching both to enhance student learning of discipline-content knowledge and skills, and to equip students with capabilities that will be useful in their future careers. Although research has indicated that software may be used as an effective way of engaging students and enhancing learning in certain scenarios, relatively little is known about academic practices with regard to the use of software more generally or about the extent to which this software is subsequently used by graduates in the workplace. This article reports on the results of a survey of academics in quantitative and financial disciplines, which is part of a broader study also encompassing recent graduates and employers. Results indicate that a variety of software packages are in widespread use in university programmes in quantitative and financial disciplines. Most surveyed academics believe that the use of software enhances learning and enables students to solve otherwise intractable problems. A majority also rate spreadsheet skills in particular as very important for the employability of graduates. A better understanding of the use of software in university teaching points the way to how curricula can be revised to enhance learning and prepare graduates for professional work.

Solving L-L Extraction Problems with Excel Spreadsheet

ERIC Educational Resources Information Center

Teppaitoon, Wittaya

2016-01-01

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

Electronic spreadsheet vs. manual payroll.

PubMed

Kiley, M M

1991-01-01

Medical groups with direct employees must employ someone or contract with a company to compute payroll, writes Michael Kiley, Ph.D., M.P.H. However, many medical groups, including small ones, own a personal or minicomputer to handle accounts receivable. Kiley explains, in detail, how this same computer and a spreadsheet program also can be used to perform payroll functions.

How Helpful Are Error Management and Counterfactual Thinking Instructions to Inexperienced Spreadsheet Users' Training Task Performance?

ERIC Educational Resources Information Center

Caputi, Peter; Chan, Amy; Jayasuriya, Rohan

2011-01-01

This paper examined the impact of training strategies on the types of errors that novice users make when learning a commonly used spreadsheet application. Fifty participants were assigned to a counterfactual thinking training (CFT) strategy, an error management training strategy, or a combination of both strategies, and completed an easy task…

Data Analysis and Graphing in an Introductory Physics Laboratory: Spreadsheet versus Statistics Suite

ERIC Educational Resources Information Center

Peterlin, Primoz

2010-01-01

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

Ideas Tried, Lessons Learned, and Improvements to Make: A Journey in Moving a Spreadsheet-Intensive Course Online

ERIC Educational Resources Information Center

Berardi, Victor L.

2012-01-01

Using information systems to solve business problems is increasingly required of everyone in an organization, not just technical specialists. In the operations management class, spreadsheet usage has intensified with the focus on building decision models to solve operations management concerns such as forecasting, process capability, and inventory…

A Computer Simulation Using Spreadsheets for Learning Concept of Steady-State Equilibrium

ERIC Educational Resources Information Center

Sharda, Vandana; Sastri, O. S. K. S.; Bhardwaj, Jyoti; Jha, Arbind K.

2016-01-01

In this paper, we present a simple spreadsheet based simulation activity that can be performed by students at the undergraduate level. This simulation is implemented in free open source software (FOSS) LibreOffice Calc, which is available for both Windows and Linux platform. This activity aims at building the probability distribution for the…

A Simple Spreadsheet Program for the Calculation of Lattice-Site Distributions

ERIC Educational Resources Information Center

McCaffrey, John G.

2009-01-01

A simple spreadsheet program is presented that can be used by undergraduate students to calculate the lattice-site distributions in solids. A major strength of the method is the natural way in which the correct number of ions or atoms are present, or absent, at specific lattice distances. The expanding-cube method utilized is straightforward to…

Mathematical Modeling in Science: Using Spreadsheets to Create Mathematical Models and Address Scientific Inquiry

ERIC Educational Resources Information Center

Horton, Robert M.; Leonard, William H.

2005-01-01

In science, inquiry is used as students explore important and interesting questions concerning the world around them. In mathematics, one contemporary inquiry approach is to create models that describe real phenomena. Creating mathematical models using spreadsheets can help students learn at deep levels in both science and mathematics, and give…

Making the business case for telemedicine: an interactive spreadsheet.

PubMed

McCue, Michael J; Palsbo, Susan E

2006-04-01

The objective of this study was to demonstrate the business case for telemedicine in nonrural areas. We developed an interactive spreadsheet to conduct multiple financial analyses under different capital investment, revenue, and expense scenarios. We applied the spreadsheet to the specific case of poststroke rehabilitation in urban settings. The setting involved outpatient clinics associated with a freestanding rehabilitation hospital in Oklahoma. Our baseline scenario used historical financial data from face-to-face encounters as the baseline for payer and volume mix. We assumed a cost of capital of 10% to finance the project. The outcome measures were financial breakeven points and internal rate of return. A total of 340 telemedicine visits will generate a positive net cash flow each year. The project is expected to recoup the initial investment by the fourth year, produce a positive present value dollar return of more than $2,000, and earn rate of return of 20%, which exceeds the hospital's cost of capital. The business case is demonstrated for this scenario. Urban telemedicine programs can be financially self-sustaining without accounting for reductions in travel time by providers or patients. Urban telemedicine programs can be a sound business investment and not depend on grants or subsidies for start-up funding. There are several key decision points that affect breakeven points and return on investment. The best business strategy is to approach the decision as whether or not to build a new clinic.

A simple and accurate method for calculation of the structure factor of interacting charged spheres.

PubMed

Wu, Chu; Chan, Derek Y C; Tabor, Rico F

2014-07-15

Calculation of the structure factor of a system of interacting charged spheres based on the Ginoza solution of the Ornstein-Zernike equation has been developed and implemented on a stand-alone spreadsheet. This facilitates direct interactive numerical and graphical comparisons between experimental structure factors with the pioneering theoretical model of Hayter-Penfold that uses the Hansen-Hayter renormalisation correction. The method is used to fit example experimental structure factors obtained from the small-angle neutron scattering of a well-characterised charged micelle system, demonstrating that this implementation, available in the supplementary information, gives identical results to the Hayter-Penfold-Hansen approach for the structure factor, S(q) and provides direct access to the pair correlation function, g(r). Additionally, the intermediate calculations and outputs can be readily accessed and modified within the familiar spreadsheet environment, along with information on the normalisation procedure. Copyright © 2014 Elsevier Inc. All rights reserved.

A Brief User's Guide to the Excel ® -Based DF Calculator

DOE Office of Scientific and Technical Information (OSTI.GOV)

Jubin, Robert T.

2016-06-01

To understand the importance of capturing penetrating forms of iodine as well as the other volatile radionuclides, a calculation tool was developed in the form of an Excel ® spreadsheet to estimate the overall plant decontamination factor (DF). The tool requires the user to estimate splits of the volatile radionuclides within the major portions of the reprocessing plant, speciation of iodine and individual DFs for each off-gas stream within the Used Nuclear Fuel reprocessing plant. The Impact to the overall plant DF for each volatile radionuclide is then calculated by the tool based on the specific user choices. The Excelmore » ® spreadsheet tracks both elemental and penetrating forms of iodine separately and allows changes in the speciation of iodine at each processing step. It also tracks 3H, 14C and 85Kr. This document provides a basic user's guide to the manipulation of this tool.« less

A Simple Spreadsheet Program to Simulate and Analyze the Far-UV Circular Dichroism Spectra of Proteins

ERIC Educational Resources Information Center

Abriata, Luciano A.

2011-01-01

A simple algorithm was implemented in a spreadsheet program to simulate the circular dichroism spectra of proteins from their secondary structure content and to fit [alpha]-helix, [beta]-sheet, and random coil contents from experimental far-UV circular dichroism spectra. The physical basis of the method is briefly reviewed within the context of…

Fuels planning: science synthesis and integration; environmental consequences fact sheet 11: Smoke Impact Spreadsheet (SIS) model

Treesearch

Trent Wickman; Ann Acheson

2005-01-01

The Smoke Impact Spreadsheet (SIS) is a simple-to-use planning model for calculating particulate matter (PM) emissions and concentrations downwind of wildland fires. This fact sheet identifies the intended users and uses, required inputs, what the model does and does not do, and tells the user how to obtain the model.

Effects of Screencasting on the Turkish Undergraduate Students' Achievement and Knowledge Acquisitions in Spreadsheet Applications

ERIC Educational Resources Information Center

Tekinarslan, Erkan

2013-01-01

The purpose of this study is to investigate the effects of screencasts on the Turkish undergraduate students' achievement and knowledge acquisitions in spreadsheet applications. The methodology of the study is based on a pretest-posttest experimental design with a control group. A total of 66 undergraduate students in two groups (n = 33 in…

CVal: a spreadsheet tool to evaluate the direct benefits and costs of carbon sequestration contracts for managed forests

Treesearch

E.M. Bilek; Peter Becker; Tim. McAbee

2009-01-01

This documentation is meant to accompany CVal, a downloadable spreadsheet tool. CVal was constructed for foresters, other land management advisors, landowners, and carbon credit aggregators to evaluate the direct benefits and costs of entering into contracts for carbon sequestered in managed forests and forest plantations. CVal was designed to evaluate Exchange...

An Integrated Management Support and Production Control System for Hardwood Forest Products

Treesearch

Guillermo A. Mendoza; Roger J. Meimban; William Sprouse; William G. Luppold; Philip A. Araman

1991-01-01

Spreadsheet and simulation models are tools which enable users to analyze a large number of variables affecting hardwood material utilization and profit in a systematic fashion. This paper describes two spreadsheet models; SEASaw and SEAIn, and a hardwood sawmill simulator. SEASaw is designed to estimate the amount of conversion from timber to lumber, while SEAIn is a...

Exploring the Nature of the H[subscript 2] Bond. 1. Using Spreadsheet Calculations to Examine the Valence Bond and Molecular Orbital Methods

ERIC Educational Resources Information Center

Halpern, Arthur M.; Glendening, Eric D.

2013-01-01

A three-part project for students in physical chemistry, computational chemistry, or independent study is described in which they explore applications of valence bond (VB) and molecular orbital-configuration interaction (MO-CI) treatments of H[subscript 2]. Using a scientific spreadsheet, students construct potential-energy (PE) curves for several…

Calculating Optimum sowing factor: A tool to evaluate sowing strategies and minimize seedling production cost

Treesearch

Eric van Steenis

2013-01-01

This paper illustrates how to use an excel spreadsheet as a decision-making tool to determine optimum sowing factor to minimize seedling production cost. Factors incorporated into the spreadsheet calculations include germination percentage, seeder accuracy, cost per seed, cavities per block, costs of handling, thinning, and transplanting labor, and more. In addition to...

Synthesizer: Expediting synthesis studies from context-free data with information retrieval techniques.

PubMed

Gandy, Lisa M; Gumm, Jordan; Fertig, Benjamin; Thessen, Anne; Kennish, Michael J; Chavan, Sameer; Marchionni, Luigi; Xia, Xiaoxin; Shankrit, Shambhavi; Fertig, Elana J

2017-01-01

Scientists have unprecedented access to a wide variety of high-quality datasets. These datasets, which are often independently curated, commonly use unstructured spreadsheets to store their data. Standardized annotations are essential to perform synthesis studies across investigators, but are often not used in practice. Therefore, accurately combining records in spreadsheets from differing studies requires tedious and error-prone human curation. These efforts result in a significant time and cost barrier to synthesis research. We propose an information retrieval inspired algorithm, Synthesize, that merges unstructured data automatically based on both column labels and values. Application of the Synthesize algorithm to cancer and ecological datasets had high accuracy (on the order of 85-100%). We further implement Synthesize in an open source web application, Synthesizer (https://github.com/lisagandy/synthesizer). The software accepts input as spreadsheets in comma separated value (CSV) format, visualizes the merged data, and outputs the results as a new spreadsheet. Synthesizer includes an easy to use graphical user interface, which enables the user to finish combining data and obtain perfect accuracy. Future work will allow detection of units to automatically merge continuous data and application of the algorithm to other data formats, including databases.

Synthesizer: Expediting synthesis studies from context-free data with information retrieval techniques

PubMed Central

Gumm, Jordan; Fertig, Benjamin; Thessen, Anne; Kennish, Michael J.; Chavan, Sameer; Marchionni, Luigi; Xia, Xiaoxin; Shankrit, Shambhavi; Fertig, Elana J.

2017-01-01

Scientists have unprecedented access to a wide variety of high-quality datasets. These datasets, which are often independently curated, commonly use unstructured spreadsheets to store their data. Standardized annotations are essential to perform synthesis studies across investigators, but are often not used in practice. Therefore, accurately combining records in spreadsheets from differing studies requires tedious and error-prone human curation. These efforts result in a significant time and cost barrier to synthesis research. We propose an information retrieval inspired algorithm, Synthesize, that merges unstructured data automatically based on both column labels and values. Application of the Synthesize algorithm to cancer and ecological datasets had high accuracy (on the order of 85–100%). We further implement Synthesize in an open source web application, Synthesizer (https://github.com/lisagandy/synthesizer). The software accepts input as spreadsheets in comma separated value (CSV) format, visualizes the merged data, and outputs the results as a new spreadsheet. Synthesizer includes an easy to use graphical user interface, which enables the user to finish combining data and obtain perfect accuracy. Future work will allow detection of units to automatically merge continuous data and application of the algorithm to other data formats, including databases. PMID:28437440

"Utstein style" spreadsheet and database programs based on Microsoft Excel and Microsoft Access software for CPR data management of in-hospital resuscitation.

PubMed

Adams, Bruce D; Whitlock, Warren L

2004-04-01

In 1997, The American Heart Association in association with representatives of the International Committee on Resuscitation (ILCOR) published recommended guidelines for reviewing, reporting and conducting in-hospital cardiopulmonary resuscitation (CPR) outcomes using the "Utstein style". Using these guidelines, we developed two Microsoft Office based database management programs that may be useful to the resuscitation community. We developed a user-friendly spreadsheet based on MS Office Excel. The user enters patient variables such as name, age, and diagnosis. Then, event resuscitation variables such as time of collapse and CPR team arrival are entered from a "code flow sheet". Finally, outcome variables such as patient condition at different time points are recorded. The program then makes automatic calculations of average response times, survival rates and other important outcome measurements. Also using the Utstein style, we developed a database program based on MS Office Access. To promote free public access to these programs, we established at a website. These programs will help hospitals track, analyze, and present their CPR outcomes data. Clinical CPR researchers might also find the programs useful because they are easily modified and have statistical functions.

Economic and Financial Analysis Tools | Energy Analysis | NREL

Science.gov Websites

Economic and Financial Analysis Tools Economic and Financial Analysis Tools Use these economic and . Job and Economic Development Impact (JEDI) Model Use these easy-to-use, spreadsheet-based tools to analyze the economic impacts of constructing and operating power generation and biofuel plants at the

AlleleCoder: a PERL script for coding codominant polymorphism data for PCA analysis

USDA-ARS?s Scientific Manuscript database

A useful biological interpretation of diploid heterozygotes is in terms of the dose of the common allele (0, 1 or 2 copies). We have developed a PERL script that converts FASTA files into coded spreadsheets suitable for Principal Component Analysis (PCA). In combination with R and R Commander, two- ...

Particle Size Characterization of Water-Elutriated Libby Amphibole 2000 and RTI International Amosite

USGS Publications Warehouse

Lowers, Heather; Bern, Amy M.

2009-01-01

This report presents data on particle characterization analyzed by scanning electron microscopy on Libby amphibole collected by the U.S. Geological Survey in 2000 (LA2000) and amosite material collected by RTI International (RTI amosite). The particle characterization data were generated to support a portion of the Libby Action Plan. Prior to analysis, the raw LA2000 and RTI amosite materials were subjected to a preparation step. Each sample was water-elutriated by U.S. Environmental Protection Agency (USEPA) Office of Research and Development, Research Triangle Park using the methods generally described in another published report and then delivered to the U.S. Geological Survey, Denver Microbeam Laboratory for analysis. Data presented here represent analyses performed by the U.S. Geological Survey, Denver Microbeam Laboratory and USEPA National Enforcement Investigations Center. This report consists of two Excel spreadsheet files developed by USEPA, Region 8 Superfund Technical Assistance Unit and describe the particle size characterization of the LA2000 and RTI amosite, respectively. Multiple tabs and data entry cells exist in each spreadsheet and are defined herein.

Great Basin NV Play Fairway Analysis - Carson Sink

DOE Data Explorer

Jim Faulds

2015-10-28

All datasets and products specific to the Carson Sink Basin. Includes a packed ArcMap (.mpk), individually zipped shapefiles, and a file geodatabase for the Carson Sink area; a GeoSoft Oasis montaj project containing GM-SYS 2D gravity profiles along the trace of our seismic reflection lines; a 3D model in EarthVision; spreadsheet of links to published maps; and spreadsheets of well data.

NV PFA - Steptoe Valley

DOE Data Explorer

Jim Faulds

2015-10-29

All datasets and products specific to the Steptoe Valley model area. Includes a packed ArcMap project (.mpk), individually zipped shapefiles, and a file geodatabase for the northern Steptoe Valley area; a GeoSoft Oasis montaj project containing GM-SYS 2D gravity profiles along the trace of our seismic reflection lines; a 3D model in EarthVision; spreadsheet of links to published maps; and spreadsheets of well data.

A user-friendly tool for incremental haemodialysis prescription.

PubMed

Casino, Francesco Gaetano; Basile, Carlo

2018-01-05

There is a recently heightened interest in incremental haemodialysis (IHD), the main advantage of which could likely be a better preservation of the residual kidney function of the patients. The implementation of IHD, however, is hindered by many factors, among them, the mathematical complexity of its prescription. The aim of our study was to design a user-friendly tool for IHD prescription, consisting of only a few rows of a common spreadsheet. The keystone of our spreadsheet was the following fundamental concept: the dialysis dose to be prescribed in IHD depends only on the normalized urea clearance provided by the native kidneys (KRUn) of the patient for each frequency of treatment, according to the variable target model recently proposed by Casino and Basile (The variable target model: a paradigm shift in the incremental haemodialysis prescription. Nephrol Dial Transplant 2017; 32: 182-190). The first step was to put in sequence a series of equations in order to calculate, firstly, KRUn and, then, the key parameters to be prescribed for an adequate IHD; the second step was to compare KRUn values obtained with our spreadsheet with KRUn values obtainable with the gold standard Solute-solver (Daugirdas JT et al., Solute-solver: a web-based tool for modeling urea kinetics for a broad range of hemodialysis schedules in multiple patients. Am J Kidney Dis 2009; 54: 798-809) in a sample of 40 incident haemodialysis patients. Our spreadsheet provided excellent results. The differences with Solute-solver were clinically negligible. This was confirmed by the Bland-Altman plot built to analyse the agreement between KRUn values obtained with the two methods: the difference was 0.07 ± 0.05 mL/min/35 L. Our spreadsheet is a user-friendly tool able to provide clinically acceptable results in IHD prescription. Two immediate consequences could derive: (i) a larger dissemination of IHD might occur; and (ii) our spreadsheet could represent a useful tool for an ineludibly needed full-fledged clinical trial, comparing IHD with standard thrice-weekly HD. © The Author(s) 2018. Published by Oxford University Press on behalf of ERA-EDTA. All rights reserved.

Costing nursing education programs. It's as easy as 1-2-3.

PubMed

Fisher, M L; Hume, R; Emerick, R

1998-01-01

Staff development departments are pressured to reveal the costs of their educational programs and to compete with outside vendors for programming. The process of implementing a spreadsheet template for costing out staff development programs is described. The template is easy to use and supports "what if" analysis. This model allows educators to evaluate cost implications of curricular decisions and to better negotiate with internal and external customers.

Google Tools in the Classroom

NASA Astrophysics Data System (ADS)

Albee, E. M.; Koons, P. O.; Schauffler, M.; Zhu, Y.; Segee, B. E.

2009-12-01

The Maine Learning Technology Initiative provides every seventh and eighth grade student in the state with MacBook laptop computers. Limitless education possibilities exist with the inclusion of Google Tools and laptops as learning tools in our modern classrooms. Google Applications allow students to create documents, spreadsheets, charts, graphs, forms, and presentations and easily allows the sharing of information with their fellow classmates and teachers. These applications invite the use of inquiry and critical thinking skills, collaboration among peers, and subject integration to teach students crucial concepts. The benefits for teachers extend into the realm of using Google sites to easily create a teacher website and blog to upload classroom information and create a communication connection for parents and students as well as collaborations between the teachers and University researchers and educators. Google Applications further enhances the possibilities for learning, sharing a wealth of information, and enhancing communication inside and outside of the classroom.

Engine Icing Data - An Analytics Approach

NASA Technical Reports Server (NTRS)

Fitzgerald, Brooke A.; Flegel, Ashlie B.

2017-01-01

Engine icing researchers at the NASA Glenn Research Center use the Escort data acquisition system in the Propulsion Systems Laboratory (PSL) to generate and collect a tremendous amount of data every day. Currently these researchers spend countless hours processing and formatting their data, selecting important variables, and plotting relationships between variables, all by hand, generally analyzing data in a spreadsheet-style program (such as Microsoft Excel). Though spreadsheet-style analysis is familiar and intuitive to many, processing data in spreadsheets is often unreproducible and small mistakes are easily overlooked. Spreadsheet-style analysis is also time inefficient. The same formatting, processing, and plotting procedure has to be repeated for every dataset, which leads to researchers performing the same tedious data munging process over and over instead of making discoveries within their data. This paper documents a data analysis tool written in Python hosted in a Jupyter notebook that vastly simplifies the analysis process. From the file path of any folder containing time series datasets, this tool batch loads every dataset in the folder, processes the datasets in parallel, and ingests them into a widget where users can search for and interactively plot subsets of columns in a number of ways with a click of a button, easily and intuitively comparing their data and discovering interesting dynamics. Furthermore, comparing variables across data sets and integrating video data (while extremely difficult with spreadsheet-style programs) is quite simplified in this tool. This tool has also gathered interest outside the engine icing branch, and will be used by researchers across NASA Glenn Research Center. This project exemplifies the enormous benefit of automating data processing, analysis, and visualization, and will help researchers move from raw data to insight in a much smaller time frame.

Spreadsheet WATERSHED modeling for nonpoint-source pollution management in a Wisconsin basin

USGS Publications Warehouse

Walker, J.F.; Pickard, S.A.; Sonzogni, W.C.

1989-01-01

Although several sophisticated nonpoint pollution models exist, few are available that are easy to use, cover a variety of conditions, and integrate a wide range of information to allow managers and planners to assess different control strategies. Here, a straightforward pollutant input accounting approach is presented in the form of an existing model (WATERSHED) that has been adapted to run on modern electronic spreadsheets. As an application, WATERSHED is used to assess options to improve the quality of highly eutrophic Delavan Lake in Wisconsin. WATERSHED is flexible in that several techniques, such as the Universal Soil Loss Equation or unit-area loadings, can be used to estimate nonpoint-source inputs. Once the model parameters are determined (and calibrated, if possible), the spreadsheet features can be used to conduct a sensitivity analysis of management options. In the case of Delavan Lake, it was concluded that, although some nonpoint controls were cost-effective, the overall reduction in phosphorus would be insufficient to measurably improve water quality.A straightforward pollutant input accounting approach is presented in the form of an existing model (WATERSHED) that has been adapted to run on modern electronic spreadsheets. As an application, WATERSHED is used to assess options to improve the quality of highly eutrophic Delavan Lake in Wisconsin. WATERSHED is flexible in that several techniques, such as the Universal Soil Loss Equation or unit-area loadings, can be used to estimate nonpoint-source inputs. Once the model parameters are determined (and calibrated, if possible), the spreadsheet features can be used to conduct a sensitivity analysis of management options. In the case of Delavan Lake, it was concluded that, although some nonpoint controls were cost-effective, the overall reduction in phosphorus would be insufficient to measurably improve water quality.

Errors in patient specimen collection: application of statistical process control.

PubMed

Dzik, Walter Sunny; Beckman, Neil; Selleng, Kathleen; Heddle, Nancy; Szczepiorkowski, Zbigniew; Wendel, Silvano; Murphy, Michael

2008-10-01

Errors in the collection and labeling of blood samples for pretransfusion testing increase the risk of transfusion-associated patient morbidity and mortality. Statistical process control (SPC) is a recognized method to monitor the performance of a critical process. An easy-to-use SPC method was tested to determine its feasibility as a tool for monitoring quality in transfusion medicine. SPC control charts were adapted to a spreadsheet presentation. Data tabulating the frequency of mislabeled and miscollected blood samples from 10 hospitals in five countries from 2004 to 2006 were used to demonstrate the method. Control charts were produced to monitor process stability. The participating hospitals found the SPC spreadsheet very suitable to monitor the performance of the sample labeling and collection and applied SPC charts to suit their specific needs. One hospital monitored subcategories of sample error in detail. A large hospital monitored the number of wrong-blood-in-tube (WBIT) events. Four smaller-sized facilities, each following the same policy for sample collection, combined their data on WBIT samples into a single control chart. One hospital used the control chart to monitor the effect of an educational intervention. A simple SPC method is described that can monitor the process of sample collection and labeling in any hospital. SPC could be applied to other critical steps in the transfusion processes as a tool for biovigilance and could be used to develop regional or national performance standards for pretransfusion sample collection. A link is provided to download the spreadsheet for free.

A Spreadsheet for the Mixing of Rows of Jets with Confined Crossflow in a Rectangular Duct. Supplement

NASA Technical Reports Server (NTRS)

Holderman, James D.; Clisset, James R.; Moder, Jeffrey P.

2010-01-01

This is a printout of the supplemental spreadsheet that is a supplement to the document found in NASA/TM-2010-216100. The calculations for cases of opposed rows of jets with the orifices on one side shifted show that staggering can improve the mixing, particularly for cases where jets would overpenetrate slightly if the orifices were in an aligned configuration.

Spreadsheet Application Showing the Proper Elevation Angle, Points of Shot and Impact of a Projectile

ERIC Educational Resources Information Center

Benacka, Jan

2015-01-01

This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

ExcelAutomat: a tool for systematic processing of files as applied to quantum chemical calculations

NASA Astrophysics Data System (ADS)

Laloo, Jalal Z. A.; Laloo, Nassirah; Rhyman, Lydia; Ramasami, Ponnadurai

2017-07-01

The processing of the input and output files of quantum chemical calculations often necessitates a spreadsheet as a key component of the workflow. Spreadsheet packages with a built-in programming language editor can automate the steps involved and thus provide a direct link between processing files and the spreadsheet. This helps to reduce user-interventions as well as the need to switch between different programs to carry out each step. The ExcelAutomat tool is the implementation of this method in Microsoft Excel (MS Excel) using the default Visual Basic for Application (VBA) programming language. The code in ExcelAutomat was adapted to work with the platform-independent open-source LibreOffice Calc, which also supports VBA. ExcelAutomat provides an interface through the spreadsheet to automate repetitive tasks such as merging input files, splitting, parsing and compiling data from output files, and generation of unique filenames. Selected extracted parameters can be retrieved as variables which can be included in custom codes for a tailored approach. ExcelAutomat works with Gaussian files and is adapted for use with other computational packages including the non-commercial GAMESS. ExcelAutomat is available as a downloadable MS Excel workbook or as a LibreOffice workbook.

ExcelAutomat: a tool for systematic processing of files as applied to quantum chemical calculations.

PubMed

Laloo, Jalal Z A; Laloo, Nassirah; Rhyman, Lydia; Ramasami, Ponnadurai

2017-07-01

The processing of the input and output files of quantum chemical calculations often necessitates a spreadsheet as a key component of the workflow. Spreadsheet packages with a built-in programming language editor can automate the steps involved and thus provide a direct link between processing files and the spreadsheet. This helps to reduce user-interventions as well as the need to switch between different programs to carry out each step. The ExcelAutomat tool is the implementation of this method in Microsoft Excel (MS Excel) using the default Visual Basic for Application (VBA) programming language. The code in ExcelAutomat was adapted to work with the platform-independent open-source LibreOffice Calc, which also supports VBA. ExcelAutomat provides an interface through the spreadsheet to automate repetitive tasks such as merging input files, splitting, parsing and compiling data from output files, and generation of unique filenames. Selected extracted parameters can be retrieved as variables which can be included in custom codes for a tailored approach. ExcelAutomat works with Gaussian files and is adapted for use with other computational packages including the non-commercial GAMESS. ExcelAutomat is available as a downloadable MS Excel workbook or as a LibreOffice workbook.

Baseliner: an open source, interactive tool for processing sap flux data from thermal dissipation probes.

Treesearch

Andrew C. Oishi; David Hawthorne; Ram Oren

2016-01-01

Estimating transpiration from woody plants using thermal dissipation sap flux sensors requires careful data processing. Currently, researchers accomplish this using spreadsheets, or by personally writing scripts for statistical software programs (e.g., R, SAS). We developed the Baseliner software to help establish a standardized protocol for processing sap...

Automating Partial Period Bond Valuation with Excel's Day Counting Functions

ERIC Educational Resources Information Center

Vicknair, David; Spruell, James

2009-01-01

An Excel model for calculating the actual price of bonds under a 30 day/month, 360 day/year day counting assumption by nesting the DAYS360 function within the PV function is developed. When programmed into an Excel spreadsheet, the model can accommodate annual and semiannual payment bonds sold on or between interest dates using six fundamental…

ALOG user's manual: A Guide to using the spreadsheet-based artificial log generator

Treesearch

Matthew F. Winn; Philip A. Araman; Randolph H. Wynne

2012-01-01

Computer programs that simulate log sawing can be valuable training tools for sawyers, as well as a means oftesting different sawing patterns. Most available simulation programs rely on diagrammed-log databases, which canbe very costly and time consuming to develop. Artificial Log Generator (ALOG) is a user-friendly Microsoft® Excel®...

Self-Instructional Module Based on Cognitive Load Theory: A Study on Information Retention among Trainee Teachers

ERIC Educational Resources Information Center

Ong, Chiek Pin; Tasir, Zaidatun

2015-01-01

The aim of the research is to study the information retention among trainee teachers using a self-instructional printed module based on Cognitive Load Theory for learning spreadsheet software. Effective pedagogical considerations integrating the theoretical concepts related to cognitive load are reflected in the design and development of the…

Active Learning and Threshold Concepts in Multiple Testing That Can Further Develop Student Critical Statistical Thinking

ERIC Educational Resources Information Center

White, Desley

2015-01-01

Two practical activities are described, which aim to support critical thinking about statistics as they concern multiple outcomes testing. Formulae are presented in Microsoft Excel spreadsheets, which are used to calculate the inflation of error associated with the quantity of tests performed. This is followed by a decision-making exercise, where…

Development of a Conference Planning Model Using Integrated Database, Word Processing, and Spreadsheet Software.

ERIC Educational Resources Information Center

Stevens, William E.

This report presents a model for conducting a statewide conference for the approximately 900 members of the South Carolina Council of Teachers of Mathematics (SCCTM) using the AppleWorks integrated software as the basis of the implementation plan. The first and second chapters provide background information on the conference and the…

Users guide for FRCS: fuel reduction cost simulator software.

Treesearch

Roger D. Fight; Bruce R. Hartsough; Peter Noordijk

2006-01-01

The Fuel Reduction Cost Simulator (FRCS) spreadsheet application is public domain software used to estimate costs for fuel reduction treatments involving removal of trees of mixed sizes in the form of whole trees, logs, or chips from a forest. Equipment production rates were developed from existing studies. Equipment operating cost rates are from December 2002 prices...

Application of Newtonian Physics to Predict the Speed of a Gravity Racer

ERIC Educational Resources Information Center

Driscoll, H. F.; Bullas, A. M.; King, C. E.; Senior, T.; Haake, S. J.; Hart, J.

2016-01-01

Gravity racing can be studied using numerical solutions to the equations of motion derived from Newton's second law. This allows students to explore the physics of gravity racing and to understand how design and course selection influences vehicle speed. Using Euler's method, we have developed a spreadsheet application that can be used to predict…

Matlab-Excel Interface for OpenDSS

DOE Office of Scientific and Technical Information (OSTI.GOV)

The software allows users of the OpenDSS grid modeling software to access their load flow models using a GUI interface developed in MATLAB. The circuit definitions are entered into a Microsoft Excel spreadsheet which makes circuit creation and editing a much simpler process than the basic text-based editors used in the native OpenDSS interface. Plot tools have been developed which can be accessed through a MATLAB GUI once the desired parameters have been simulated.

Organizational Linkages: Understanding the Productivity Paradox,

DTIC Science & Technology

1994-01-01

students were asked to make a decision regarding a production scheduling. Some used a Lotus spreadsheet’s what-if capacity, which enabled them to...the degree to which managers and MBA students believed that they make better decisions using what-if spreadsheet models, despite the fact that their...for this system is Naylor et al.’s (1980) view of behavior in organizations. When Pritchard and his students (Pritchard et al., 1988) applied this

Maxine: A spreadsheet for estimating dose from chronic atmospheric radioactive releases

DOE Office of Scientific and Technical Information (OSTI.GOV)

Jannik, Tim; Bell, Evaleigh; Dixon, Kenneth

MAXINE is an EXCEL© spreadsheet, which is used to estimate dose to individuals for routine and accidental atmospheric releases of radioactive materials. MAXINE does not contain an atmospheric dispersion model, but rather doses are estimated using air and ground concentrations as input. Minimal input is required to run the program and site specific parameters are used when possible. Complete code description, verification of models, and user’s manual have been included.

Nurses' perception and barriers to use of information communication technology in a teaching hospital in Nigeria.

PubMed

Irinoye, Omolola O; Ayandiran, Emmanuel Olufemi; Fakunle, Imoleayo; Mtshali, Ntombifikile

2013-08-01

The impact of information technology on nursing has been a subject of discourse for the latter half of the 20th century and the early part of the 21st. Despite its obvious benefits, adapting information technology to healthcare has been relatively difficult, and rates of use have been limited especially in many developing countries. This quantitative study has shown a generally low usage of information technology among nurses in the study setting. Many of the nurses adjudged themselves as novice in information technology, with 37.8% stating that they had never had formal training in information technology and many rating themselves as possessing little or no skill in the use of spreadsheet, databases, and so on. Many (55.6%) stated that they do not have access to information technology despite the fairly widespread satisfactory perception established among them. Results further showed that unreliable network connections, high work demand, inadequate number of computers, poor access to computers consequent on wrong locations, and poor system design with associated failure to fit work demands are some of the major barriers to the use of information technology in the study setting. These factors therefore need to be taken into consideration in any intervention that seeks to improve the nurses' use of information technology in clinical setting.

Simplifying CEA through Excel, VBA, and Subeq

NASA Technical Reports Server (NTRS)

Foster, Ryan

2004-01-01

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

SU-E-P-29: Testing Display Monitors for GSDF Compliance - a Practical Approach

DOE Office of Scientific and Technical Information (OSTI.GOV)

Gauntt, D

2015-06-15

Purpose: To develop a simple technique for testing display monitors for compliance with the DICOM Grayscale Standard Display Function (GSDF), in accordance with the recommendations of AAPM Task Group 18. Methods: We have developed a spreadsheet that can be used to compare both the luminance response and contrast response of a display to the GSDF, using luminance measurements of the SMPTE test pattern. The contrast response compares the slope of the GSDF j-index as a function of pixel value to that of the GSDF function, and should lie within the range 0.85 to 1.15. Results: We present the results ofmore » measurements both of primary diagnostic displays and of ultrasound and acquisition workstations, all at a tertiary care hospital. The Barco displays in the radiographic reading rooms are GSDF compliant or nearly so, while those in the ultrasound reading rooms and at the acquisition workstations generally show significantly higher contrast at low luminance levels than they would if GSDF compliant, and lower contrast at high luminance levels. Conclusion: The spreadsheet that we developed allows a simple comparison of measured display contrast response to the GSDF. Although we used the SMPTE pattern, the same technique could be used with other grayscale patterns, such as TG18-QC and TG18-PQC.« less

Timber products output and timber harvests in Alaska: projections for 1992-2010.

Treesearch

D.J. Brooks; R.W. Haynes

1994-01-01

Projections of Alaska timber products output, the derived demand for raw material, and timber harvest by owner are developed from a trend-based analysis. By using a spread-sheet model, material flows in the Alaska forest sectorare fully accounted for. Demand for Alaska national forest timber is projected and depends on product output and harvest by other owners. Key...

IDA Cost Research Symposium Held 25 May 1995.

DTIC Science & Technology

1995-08-01

Excel Spreadsheet Publications: MCR Report TR-9507/01 Category: II.B Keywords: Government, Estimating, Missiles, Analysis, Production, Data...originally developed by Martin Marietta as part of SASET software estimating model. To be implemented as part of SoftEST Software Estimating Tool...following documents to report the results of Its work. Reports Reports are the most authoritative and most carefully considered products IDA

Geophysical, geochemical, mineralogical, and enivronmental data for rock samples collected in a mineralized volcanic environment, upper Animas River watershed, Colorado

USGS Publications Warehouse

McCafferty, A.E.; Horton, R.J.; Stanton, M.R.; McDougal, R.R.; Fey, D.L.

2011-01-01

* provide measurements to study the geochemical, mineralogical, and geophysical characteristics of rocks having weak to extreme degrees of alteration and to develop an understanding of how these characteristics change with alteration type. Data are provided in two digital formats: an Arc/Info geodatabase and a Microsoft Excel spreadsheet.

Trainee Teachers' Mental Effort in Learning Spreadsheet through Self-Instructional Module Based on Cognitive Load Theory

ERIC Educational Resources Information Center

Tasir, Zaidatun; Pin, Ong Chiek

2012-01-01

A printed module should consist of media elements, namely text and pictures, which are self-instructional and could cater to the needs of the user. However, the typical platform of such visualization frequently overloads the limited working memory causing split attention and redundancy effects. The purpose of this study is to design and develop a…

Users guide for noble fir bough cruiser.

Treesearch

Roger D. Fight; Keith A. Blatner; Roger C. Chapman; William E. Schlosser

2005-01-01

The bough cruiser spreadsheet was developed to provide a method for cruising noble fir (Abies procera Rehd.) stands to estimate the weight of boughs that might be harvested. No boughs are cut as part of the cruise process. The approach is based on a two-stage sample. The first stage consists of fixed-radius plots that are used to estimate the...

Cash Flow Statement Spreadsheet Modeling Case Using a Prototype System Development Process

ERIC Educational Resources Information Center

Davis, Jefferson T.

2015-01-01

U.S. GAAP and IFRS standards both require a cash flow statement that presents operating, investing and financing net cash flows (FASB, FAS 95; 1987; IASB, IAS 7, 1992). Although students are exposed to the cash flow statement in beginning accounting courses and then study the cash flow statement in more depth in intermediate accounting classes,…

Manual for computing bed load transport using BAGS (Bedload Assessment for Gravel-bed Streams) Software

Treesearch

John Pitlick; Yantao Cui; Peter Wilcock

2009-01-01

This manual provides background information and instructions on the use of a spreadsheet-based program for Bedload Assessment in Gravel-bed Streams (BAGS). The program implements six bed load transport equations developed specifically for gravel-bed rivers. Transport capacities are calculated on the basis of field measurements of channel geometry, reach-average slope,...

Break-even analysis revisited: the need to adjust for profitability, the collection rate and autonomous income.

PubMed

Broyles, R W; Narine, L; Khaliq, A

2003-08-01

This paper modifies traditional break-even analysis and develops a model that reflects the influence of variation in payer mix, the collection rate, profitability and autonomous income on the desired volume alternative. The augmented model indicates that a failure to adjust for uncollectibles and the net surplus results in a systematic understatement of the desired volume alternative. Conversely, a failure to adjust for autonomous income derived from the operation of cafeterias, gift shops or an organization's investment in marketable securities produces an overstatement of the desired volume. In addition, this paper uses Microsoft Excel to develop a spreadsheet that constructs a pro forma income statement, expressed in terms of the contribution margin. The spreadsheet also relies on the percentage of sales or revenue approach to prepare a balance sheet from which indicators of fiscal performance are calculated. Hence, the analysis enables the organization to perform a sensitivity analysis of potential changes in the desired volume, the operating margin, the current ratio, the debt: equity ratio and the amount of cash derived from operations that are associated with expected variation in payer mix, the collection rate, grouped by payer, the net surplus and autonomous income.

Mini-Journals: Incorporating Inquiry, Quantitative Skills and Writing into Homework Assignments for Geochemistry and Planetary Science

NASA Astrophysics Data System (ADS)

Whittington, A. G.; Speck, A.; Witzig, S.

2011-12-01

As part of an NSF-funded project, "CUES: Connecting Undergraduates to the Enterprise of Science," new inquiry-based homework materials were developed for two upper-level classes at the University of Missouri: Geochemistry (required for Geology majors, fulfills the computing requirement by having 50% of the grade come from five spreadsheet-based homework assignments), and Solar System Science (open to seniors and graduate students, co-taught and cross-listed between Geology and Physics & Astronomy). Inquiry involves activities where the learner engages in scientifically oriented questions, gives priority to evidence in responding to questions, formulates explanations from evidence, connects explanations to scientific knowledge, and communicates and justifies explanations. We engage students in inquiry-based learning by presenting homework exercises as "mini-journal" articles that follow the format of a scientific journal article, including a title, authors, abstract, introduction, methods, results, discussion and citations to peer-reviewed literature. The mini-journal provides a scaffold and serves as a springboard for students to develop and carry out their own follow-up investigation. They then present their findings in the form of their own mini-journal. Mini-journals replace traditional homework problem sets with a format that more directly reflects and encourages scientific practice. Students are engaged in inquiry-based homework which encompass doing, thinking, and communicating, while the mini-journal allows the instructor to contain lines of inquiry within the limits posed by available resources. In the examples we present, research is conducted via spreadsheet modeling, where the students develop their own spreadsheets. Example assignments from Geochemistry include "Trace Element Partitioning During Mantle Melting and MORB Crystallization" and "Isotopic Investigations of Crustal Evolution in the Midcontinent US". The key differences between the old and new formats include (i) active participation of the students in defining the question/problem that they will pursue, within well-defined boundaries, (ii) open-ended nature of the inquiry, so that students need to recognize when they have enough information to answer their question, (iii) extensive spreadsheet manipulation and presentation of results in graphical and tabular formats, and (iv) a written discussion of their findings. Grading is weighted more towards how the problem was addressed, and how findings are presented and interpreted, and less on actual numerical answers. Survey responses from students indicate that they experience discomfort on being presented with an open-ended assignment, but like the freedom to define their own problem. Students also recognize that reading, writing and critical thinking skills employed in the minijournal format increase their understanding of content. The combination of calculation and writing components make these assignments particularly useful for classes designated as "computer-based", and/or "writing intensive" (or similar designations).

Basic statistics with Microsoft Excel: a review.

PubMed

Divisi, Duilio; Di Leonardo, Gabriella; Zaccagna, Gino; Crisci, Roberto

2017-06-01

The scientific world is enriched daily with new knowledge, due to new technologies and continuous discoveries. The mathematical functions explain the statistical concepts particularly those of mean, median and mode along with those of frequency and frequency distribution associated to histograms and graphical representations, determining elaborative processes on the basis of the spreadsheet operations. The aim of the study is to highlight the mathematical basis of statistical models that regulate the operation of spreadsheets in Microsoft Excel.

Basic statistics with Microsoft Excel: a review

PubMed Central

Di Leonardo, Gabriella; Zaccagna, Gino; Crisci, Roberto

2017-01-01

The scientific world is enriched daily with new knowledge, due to new technologies and continuous discoveries. The mathematical functions explain the statistical concepts particularly those of mean, median and mode along with those of frequency and frequency distribution associated to histograms and graphical representations, determining elaborative processes on the basis of the spreadsheet operations. The aim of the study is to highlight the mathematical basis of statistical models that regulate the operation of spreadsheets in Microsoft Excel. PMID:28740690

U.S. Army Concept of Operations and Standard Operating Procedure for Acquisition Program Managers Using Item Unique Identification

DTIC Science & Technology

2017-09-01

Figure 58. Click on run ................................................................................................61 Figure 59. Top view of...engines, helicopter rotors, and turbine blades , and so forth Creating Marks Readable with a Scanner 4.  Simple techniques to follow:  Make the light...spreadsheet with data Figure 58. Click on Menu bar and find “View” then click on “Macros.” Click on run Figure 59. 62 Top view of xml spreadsheet

Small-Caliber Projectile Target Impact Angle Determined From Close Proximity Radiographs

DTIC Science & Technology

2006-10-01

discrete motion data that can be numerically modeled using linear aerodynamic theory or 6-degrees-of- freedom equations of motion. The values of Fφ...Prediction Excel® Spreadsheet shown in figure 9. The Gamma at Impact Spreadsheet uses the linear aerodynamics model , equations 5 and 6, to calculate αT...trajectory angle error via consideration of the RMS fit errors of the actual firings. However, the linear aerodynamics model does not include this effect

A computerized faculty time-management system in an academic family medicine department.

PubMed

Daugird, Allen J; Arndt, Jane E; Olson, P Richard

2003-02-01

The authors describe the development, implementation, and evaluation of a computerized faculty time-management system (FTMS) in the Department of Family Medicine at the University of North Carolina-Chapel Hill. The FTMS is presented as an integrated set of computerized spreadsheets used annually to allocate faculty time across all mission activities of the department. It was first implemented in 1996 and has been continuously developed since then. An iterative approach has been used to gain consensus among faculty about time resources needed for various tasks of all missions of the department. These time-resource assumptions are used in the computerized system. Faculty time is allocated annually by the department vice chair in negotiation with individual faculty, making sure that the activities planned do not exceed the work time each faculty member has available for the year. During this process, faculty preferences are balanced against department aggregate needs to meet mission commitments and obligations. The authors describe how the computerized FTMS is used for faculty time management and career development, department planning, budget planning, clinical scheduling, and mission cost accounting. They also describe barriers and potential abuses and the challenge of building an organizational culture willing to discuss faculty time openly and committed to developing a system perceived as fair and accurate. The spreadsheet file is available free from the authors for use in other departments.

Nutrient modeling for a semi-intensive IMC pond: an MS-Excel approach.

PubMed

Ray, Lala I P; Mal, B C; Moulick, S

2017-11-01

Semi-intensive Indian Major Carp (IMC) culture was practised in polythene lined dugout ponds at the Aquacultural Farm of Indian Institute of Technology, Kharagpur, West Bengal for 3 consecutive years at three different stocking densities (S.D), viz., 20,000, 35,000 and 50,000 numbers of fingerlings per hectare of water spread area. Fingerlings of Catla, Rohu and Mrigal were raised at a stocking ratio of 4:3:3. Total ammonia nitrogen (TAN) value along with other fishpond water quality parameters was monitored at 1 day intervals to ensure a good water ecosystem for a better fish growth. Water exchange was carried out before the TAN reached the critical limit. Field data on TAN obtained from the cultured fishponds stocked with three different stocking densities were used to study the dynamics of TAN. A developed model used to study the nutrient dynamics in shrimp pond was used to validate the observed data in the IMC pond ecosystem. Two years of observed TAN data were used to calibrate the spreadsheet model and the same model was validated using the third year observed data. The manual calibration based on the trial and error process of parameters adjustments was used and several simulations were performed by changing the model parameters. After adjustment of each parameter, the simulated and measured values of the water quality parameters were compared to judge the improvement in the model prediction. Forward finite difference discretization method was used in a MS-Excel spreadsheet to calibrate and validate the model for obtaining the TAN levels during the culture period. Observed data from the cultured fishponds of three different S.D were used to standardize 13 model parameters. The efficiency of the developed spreadsheet model was found to be more than 90% for the TAN estimation in the IMC cultured fishponds.

Tutorial: simulating chromatography with Microsoft Excel Macros.

PubMed

Kadjo, Akinde; Dasgupta, Purnendu K

2013-04-22

Chromatography is one of the cornerstones of modern analytical chemistry; developing an instinctive feeling for how chromatography works will be invaluable to future generation of chromatographers. Specialized software programs exist that handle and manipulate chromatographic data; there are also some that simulate chromatograms. However, the algorithm details of such software are not transparent to a beginner. In contrast, how spreadsheet tools like Microsoft Excel™ work is well understood and the software is nearly universally available. We show that the simple repetition of an equilibration process at each plate (a spreadsheet row) followed by discrete movement of the mobile phase down by a row, easily automated by a subroutine (a "Macro" in Excel), readily simulates chromatography. The process is readily understood by a novice. Not only does this permit simulation of isocratic and simple single step gradient elution, linear or multistep gradients are also easily simulated. The versatility of a transparent and easily understandable computational platform further enables the simulation of complex but commonly encountered chromatographic scenarios such as the effects of nonlinear isotherms, active sites, column overloading, on-column analyte degradation, etc. These are not as easily simulated by available software. Views of the separation as it develops on the column and as it is seen by an end-column detector are both available in real time. Excel 2010™ also permits a 16-level (4-bit) color gradation of numerical values in a column/row; this permits visualization of a band migrating down the column, much as Tswett may have originally observed, but in a numerical domain. All parameters of relevance (partition constants, elution conditions, etc.) are readily changed so their effects can be examined. Illustrative Excel spreadsheets are given in the Supporting Information; these are easily modified by the user or the user can write his/her own routine. Copyright © 2012 Elsevier B.V. All rights reserved.

Space-Plane Spreadsheet Program

NASA Technical Reports Server (NTRS)

Mackall, Dale

1993-01-01

Basic Hypersonic Data and Equations (HYPERDATA) spreadsheet computer program provides data gained from three analyses of performance of space plane. Equations used to perform analyses derived from Newton's second law of physics, derivation included. First analysis is parametric study of some basic factors affecting ability of space plane to reach orbit. Second includes calculation of thickness of spherical fuel tank. Third produces ratio between volume of fuel and total mass for each of various aircraft. HYPERDATA intended for use on Macintosh(R) series computers running Microsoft Excel 3.0.

Social Security: A Present Value Analysis of Old Age Survivors Insurance (OASI) Taxes and Benefits.

DTIC Science & Technology

1995-12-01

private sector plans and provides a spreadsheet model for making this comparison of plans using different assumptions. The investigation was done by collecting data from various books, Government publications, and various Government agencies to conduct a spreadsheet analysis of three different wage-earning groups, assuming various real interest rates potentially earned in the private sector . A comparison of Social Security with alternative private sector plans is important to the DoD/DoN because less constrained budgets could

Methodology for National Water Savings Model and Spreadsheet Tool—Outdoor Water Use

DOE Office of Scientific and Technical Information (OSTI.GOV)

Williams, Alison, A; Chen, Yuting; Dunham, Camilla

This report describes the method Lawrence Berkeley National Laboratory (LBNL) developed to estimate national impacts of the U.S. Environmental Protection Agency’s (EPA’s) WaterSense labeling program for weather-based irrigation controllers (WBIC). Estimated impacts include the national water savings attributable to the program and the net present value of the lifetime water savings for consumers of irrigation controllers.

An Excel Spreadsheet Model for States and Districts to Assess the Cost-Benefit of School Nursing Services.

PubMed

Wang, Li Yan; O'Brien, Mary Jane; Maughan, Erin D

2016-11-01

This paper describes a user-friendly, Excel spreadsheet model and two data collection instruments constructed by the authors to help states and districts perform cost-benefit analyses of school nursing services delivered by full-time school nurses. Prior to applying the model, states or districts need to collect data using two forms: "Daily Nurse Data Collection Form" and the "Teacher Survey." The former is used to record daily nursing activities, including number of student health encounters, number of medications administered, number of student early dismissals, and number of medical procedures performed. The latter is used to obtain estimates for the time teachers spend addressing student health issues. Once inputs are entered in the model, outputs are automatically calculated, including program costs, total benefits, net benefits, and benefit-cost ratio. The spreadsheet model, data collection tools, and instructions are available at the NASN website ( http://www.nasn.org/The/CostBenefitAnalysis ).

Emissions & Generation Resource Integrated Database (eGRID), eGRID2002 (with years 1996 - 2000 data)

EPA Pesticide Factsheets

The Emissions & Generation Resource Integrated Database (eGRID) is a comprehensive source of data on the environmental characteristics of almost all electric power generated in the United States. These environmental characteristics include air emissions for nitrogen oxides, sulfur dioxide, carbon dioxide, methane, nitrous oxide, and mercury; emissions rates; net generation; resource mix; and many other attributes. eGRID2002 (years 1996 through 2000 data) contains 16 Excel spreadsheets and the Technical Support Document, as well as the eGRID Data Browser, User's Manual, and Readme file. Archived eGRID data can be viewed as spreadsheets or by using the eGRID Data Browser. The eGRID spreadsheets can be manipulated by data users and enables users to view all the data underlying eGRID. The eGRID Data Browser enables users to view key data using powerful search features. Note that the eGRID Data Browser will not run on a Mac-based machine without Windows emulation.

Complex mapping of aerofoils - a different perspective

NASA Astrophysics Data System (ADS)

Matthews, Miccal T.

2012-01-01

In this article an application of conformal mapping to aerofoil theory is studied from a geometric and calculus point of view. The problem is suitable for undergraduate teaching in terms of a project or extended piece of work, and brings together the concepts of geometric mapping, parametric equations, complex numbers and calculus. The Joukowski and Karman-Trefftz aerofoils are studied, and it is shown that the Karman-Trefftz aerofoil is an improvement over the Joukowski aerofoil from a practical point of view. For the most part only a spreadsheet program and pen and paper is required, only for the last portion of the study of the Karman-Trefftz aerofoils a symbolic computer package is employed. Ignoring the concept of a conformal mapping and instead viewing the problem from a parametric point of view, some interesting mappings are obtained. By considering the derivative of the mapped mapping via the chain rule, some new and interesting analytical results are obtained for the Joukowski aerofoil, and numerical results for the Karman-Trefftz aerofoil.

Spreadsheet Calculations for Jets in Crossflow: Opposed Rows of Inline and Staggered Holes and Single and Opposed Rows with Alternating Hole Sizes

NASA Technical Reports Server (NTRS)

Holdeman, James D.; Clisset, James R.; Moder, Jeffrey P.

2010-01-01

The primary purpose of this jet-in-crossflow study was to calculate expected results for two configurations for which limited or no experimental results have been published: (1) cases of opposed rows of closely-spaced jets from inline and staggered round holes and (2) rows of jets from alternating large and small round holes. Simulations of these configurations were performed using an Excel (Microsoft Corporation) spreadsheet implementation of a NASA-developed empirical model which had been shown in previous publications to give excellent representations of mean experimental scalar results suggesting that the NASA empirical model for the scalar field could confidently be used to investigate these configurations. The supplemental Excel spreadsheet is posted with the current report on the NASA Glenn Technical Reports Server (http://gltrs.grc.nasa.gov) and can be accessed from the Supplementary Notes section as TM-2010-216100-SUPPL1.xls. Calculations for cases of opposed rows of jets with the orifices on one side shifted show that staggering can improve the mixing, particularly for cases where jets would overpenetrate slightly if the orifices were in an aligned configuration. The jets from the larger holes dominate the mixture fraction for configurations with a row of large holes opposite a row of smaller ones although the jet penetration was about the same. For single and opposed rows with mixed hole sizes, jets from the larger holes penetrated farther. For all cases investigated, the dimensionless variance of the mixture fraction decreased significantly with increasing downstream distance. However, at a given downstream distance, the variation between cases was small.

Standardized verification of fuel cycle modeling

DOE PAGES

Feng, B.; Dixon, B.; Sunny, E.; ...

2016-04-05

A nuclear fuel cycle systems modeling and code-to-code comparison effort was coordinated across multiple national laboratories to verify the tools needed to perform fuel cycle analyses of the transition from a once-through nuclear fuel cycle to a sustainable potential future fuel cycle. For this verification study, a simplified example transition scenario was developed to serve as a test case for the four systems codes involved (DYMOND, VISION, ORION, and MARKAL), each used by a different laboratory participant. In addition, all participants produced spreadsheet solutions for the test case to check all the mass flows and reactor/facility profiles on a year-by-yearmore » basis throughout the simulation period. The test case specifications describe a transition from the current US fleet of light water reactors to a future fleet of sodium-cooled fast reactors that continuously recycle transuranic elements as fuel. After several initial coordinated modeling and calculation attempts, it was revealed that most of the differences in code results were not due to different code algorithms or calculation approaches, but due to different interpretations of the input specifications among the analysts. Therefore, the specifications for the test case itself were iteratively updated to remove ambiguity and to help calibrate interpretations. In addition, a few corrections and modifications were made to the codes as well, which led to excellent agreement between all codes and spreadsheets for this test case. Although no fuel cycle transition analysis codes matched the spreadsheet results exactly, all remaining differences in the results were due to fundamental differences in code structure and/or were thoroughly explained. As a result, the specifications and example results are provided so that they can be used to verify additional codes in the future for such fuel cycle transition scenarios.« less

Using a spreadsheet/table template for economic value added analysis.

PubMed

Cassey, Margaret

2008-01-01

Translating clinical research into practical applications that are cost effective has received significant attention as staff nurses attempt to expand new knowledge into an already complex daily workflow. spreadsheet/table template created in a word processing format can assist with setting up and carrying out the analysis of costs for comparing different approaches to routine activities. By encouraging nurses to take the initiative to examine parts of everyday nursing practice with an eye to cost analysis, significant contributions can be made to maximizing the bottom line.

Value of Information spreadsheet

DOE Data Explorer

Trainor-Guitton, Whitney

2014-05-12

This spreadsheet represents the information posteriors derived from synthetic data of magnetotellurics (MT). These were used to calculate value of information of MT for geothermal exploration. Information posteriors describe how well MT was able to locate the "throat" of clay caps, which are indicative of hidden geothermal resources. This data is full explained in the peer-reviewed publication: Trainor-Guitton, W., Hoversten, G. M., Ramirez, A., Roberts, J., Júlíusson, E., Key, K., Mellors, R. (Sept-Oct. 2014) The value of spatial information for determining well placement: a geothermal example, Geophysics.

Angular Speed of a Compact Disc

NASA Astrophysics Data System (ADS)

Sawicki, Mikolaj ``Mik''

2006-09-01

A spinning motion of a compact disc in a CD player offers an interesting and challenging problem in rotational kinematics with a nonconstant angular acceleration that can be incorporated into a typical introductory physics class for engineers and scientists. It can be used either as an example presented during the lecture, emphasizing application of calculus, or as a homework assignment that could be handled easily with the help of a spreadsheet, thus eliminating the calculus aspect altogether. I tried both approaches, and the spreadsheet study was favored by my students.

CalPro: a spreadsheet program for the management of California mixed-conifer stands.

Treesearch

Jingjing Liang; Joseph Buongiorno; Robert A. Monserud

2004-01-01

CalPro is an add-in program developed to work with Microsoft Excel to simulate the growth and management of uneven-aged mixed-conifer stands in California. Its built-in growth model was calibrated from 177 uneven-aged plots on industry and other private lands. Stands are described by the number of trees per acre in each of nineteen 2-inch diameter classes in...

Formation and Dimerization of NO2 A General Chemistry Experiment

NASA Astrophysics Data System (ADS)

Hennis, April D.; Highberger, C. Scott; Schreiner, Serge

1997-11-01

We have developed a general chemistry experiment which illustrates Gay-Lussac's law of combining volumes. Students are able to determine the partial pressures and equilibrium constant for the formation and dimerization of NO2. The experiment can be carried out in about 45 minutes with students working in groups of two. The experiment readily provides students with data that can be manipulated with a common spreadsheet.

Use of a Spreadsheet to Help Students Understand the Origin of the Empirical Equation that Allows Estimation of the Extinction Coefficients of Proteins

ERIC Educational Resources Information Center

Sims, Paul A.

2012-01-01

A brief history of the development of the empirical equation that is used by prominent, Internet-based programs to estimate (or calculate) the extinction coefficients of proteins is presented. In addition, an overview of a series of related assignments designed to help students understand the origin of the empirical equation is provided. The…

Research and Development for Robotic Transportable Waste to Energy System (TWES)

DTIC Science & Technology

2012-01-01

Engineers, April 2003. NFESC UG-2039-ENV, Qualified Recycling Program (QRP) Guide; July 2000 (NOTAL) Paisley, M.A., Anson, D., “ Biomass Gasification ...Full Load Biomass Simulation .............................19 Figure 9. Spreadsheet-Based Heat and Mass Balance—Diesel Operation at 5:00 p.m...diesel fuel. Based on simulation of full-load biomass operation, the diesel-fueled test was expected to demonstrate a 75% net fuel-to-steam efficiency

Research in Science Education. Volume 21. Selected Refereed Papers from the Annual Conference of the Australasian Science Education Research Association (22nd, Surfers Paradise, Queensland, Australia, July 11-14, 1991).

ERIC Educational Resources Information Center

Forgasz, Helen, Ed.

1991-01-01

This annual publication contains 43 research papers on a variety of issues related to science education. Topics include the following: mature-age students; teacher professional development; spreadsheets and science instruction; the Learning in Science Project and putting it into practice; science discipline knowledge in primary teacher education;…

Cohen's Kappa and classification table metrics 2.0: An ArcView 3.x extension for accuracy assessment of spatially explicit models

Treesearch

Jeff Jenness; J. Judson Wynne

2005-01-01

In the field of spatially explicit modeling, well-developed accuracy assessment methodologies are often poorly applied. Deriving model accuracy metrics have been possible for decades, but these calculations were made by hand or with the use of a spreadsheet application. Accuracy assessments may be useful for: (1) ascertaining the quality of a model; (2) improving model...

Risk assessment methodology applied to counter IED research & development portfolio prioritization

DOE Office of Scientific and Technical Information (OSTI.GOV)

Shevitz, Daniel W; O' Brien, David A; Zerkle, David K

2009-01-01

In an effort to protect the United States from the ever increasing threat of domestic terrorism, the Department of Homeland Security, Science and Technology Directorate (DHS S&T), has significantly increased research activities to counter the terrorist use of explosives. More over, DHS S&T has established a robust Counter-Improvised Explosive Device (C-IED) Program to Deter, Predict, Detect, Defeat, and Mitigate this imminent threat to the Homeland. The DHS S&T portfolio is complicated and changing. In order to provide the ''best answer'' for the available resources, DHS S&T would like some ''risk based'' process for making funding decisions. There is a definitemore » need for a methodology to compare very different types of technologies on a common basis. A methodology was developed that allows users to evaluate a new ''quad chart'' and rank it, compared to all other quad charts across S&T divisions. It couples a logic model with an evidential reasoning model using an Excel spreadsheet containing weights of the subjective merits of different technologies. The methodology produces an Excel spreadsheet containing the aggregate rankings of the different technologies. It uses Extensible Logic Modeling (ELM) for logic models combined with LANL software called INFTree for evidential reasoning.« less

A commercial building energy standard for Mexico

DOE Office of Scientific and Technical Information (OSTI.GOV)

Huang, J.; Warner, J.L.; Wiel, S.

1998-07-01

Beginning in 1992, the Comission Nacional de Ahorro de Energia (CONAE), or Mexican National Commission for Energy Conservation, developed a national energy standard for commercial buildings, with assistance from USAID and LBNL. The first complete draft of the standard was released for public review in mid-1995. To promote public acceptance of the standard, CONAE held advisory meetings with architects, engineers, and utility representatives, and organized pubic workshops presented by the authors, with support from USAID. In response to industry comments, the standard was revised in late 1997 and is currently under review by CONAE. It is anticipated that the revisedmore » draft will be released again for final public comments in the summer of 1998. The standard will become law one year after it is finalized by CONAE and published in the federal government record. Since Mexico consists of cooling-dominated climates, the standard emphasizes energy-efficient envelope design to control solar and conductive heat gains. The authors extended DOE-2 simulation results for four climates to all of Mexico through regression analysis. Based on these results, they developed a simplified custom budget calculation approach. To facilitate the method's use, a calculation template was devised in a spreadsheet program and distributed to the public. CONAE anticipates that local engineering associations will use this spreadsheet to administer code compliance.« less

Intermediate-sized natural gas fueled carbonate fuel cell power plants

NASA Astrophysics Data System (ADS)

Sudhoff, Frederick A.; Fleming, Donald K.

1994-04-01

This executive summary of the report describes the accomplishments of the joint US Department of Energy's (DOE) Morgantown Energy Technology Center (METC) and M-C POWER Corporation's Cooperative Research and Development Agreement (CRADA) No. 93-013. This study addresses the intermediate power plant size between 2 megawatt (MW) and 200 MW. A 25 MW natural-gas, fueled-carbonate fuel cell power plant was chosen for this purpose. In keeping with recent designs, the fuel cell will operate under approximately three atmospheres of pressure. An expander/alternator is utilized to expand exhaust gas to atmospheric conditions and generate additional power. A steam-bottoming cycle is not included in this study because it is not believed to be cost effective for this system size. This study also addresses the simplicity and accuracy of a spreadsheet-based simulation with that of a full Advanced System for Process Engineering (ASPEN) simulation. The personal computer can fully utilize the simple spreadsheet model simulation. This model can be made available to all users and is particularly advantageous to the small business user.

A simple model of hysteresis behavior using spreadsheet analysis

NASA Astrophysics Data System (ADS)

Ehrmann, A.; Blachowicz, T.

2015-01-01

Hysteresis loops occur in many scientific and technical problems, especially as field dependent magnetization of ferromagnetic materials, but also as stress-strain-curves of materials measured by tensile tests including thermal effects, liquid-solid phase transitions, in cell biology or economics. While several mathematical models exist which aim to calculate hysteresis energies and other parameters, here we offer a simple model for a general hysteretic system, showing different hysteresis loops depending on the defined parameters. The calculation which is based on basic spreadsheet analysis plus an easy macro code can be used by students to understand how these systems work and how the parameters influence the reactions of the system on an external field. Importantly, in the step-by-step mode, each change of the system state, compared to the last step, becomes visible. The simple program can be developed further by several changes and additions, enabling the building of a tool which is capable of answering real physical questions in the broad field of magnetism as well as in other scientific areas, in which similar hysteresis loops occur.

Real-time PCR array as a universal platform for the detection of genetically modified crops and its application in identifying unapproved genetically modified crops in Japan.

PubMed

Mano, Junichi; Shigemitsu, Natsuki; Futo, Satoshi; Akiyama, Hiroshi; Teshima, Reiko; Hino, Akihiro; Furui, Satoshi; Kitta, Kazumi

2009-01-14

We developed a novel type of real-time polymerase chain reaction (PCR) array with TaqMan chemistry as a platform for the comprehensive and semiquantitative detection of genetically modified (GM) crops. Thirty primer-probe sets for the specific detection of GM lines, recombinant DNA (r-DNA) segments, endogenous reference genes, and donor organisms were synthesized, and a 96-well PCR plate was prepared with a different primer-probe in each well as the real-time PCR array. The specificity and sensitivity of the array were evaluated. A comparative analysis with the data and publicly available information on GM crops approved in Japan allowed us to assume the possibility of unapproved GM crop contamination. Furthermore, we designed a Microsoft Excel spreadsheet application, Unapproved GMO Checker version 2.01, which helps process all the data of real-time PCR arrays for the easy assumption of unapproved GM crop contamination. The spreadsheet is available free of charge at http://cse.naro.affrc.go.jp/jmano/index.html .

Abdominal surgery process modeling framework for simulation using spreadsheets.

PubMed

Boshkoska, Biljana Mileva; Damij, Talib; Jelenc, Franc; Damij, Nadja

2015-08-01

We provide a continuation of the existing Activity Table Modeling methodology with a modular spreadsheets simulation. The simulation model developed is comprised of 28 modeling elements for the abdominal surgery cycle process. The simulation of a two-week patient flow in an abdominal clinic with 75 beds demonstrates the applicability of the methodology. The simulation does not include macros, thus programming experience is not essential for replication or upgrading the model. Unlike the existing methods, the proposed solution employs a modular approach for modeling the activities that ensures better readability, the possibility of easily upgrading the model with other activities, and its easy extension and connectives with other similar models. We propose a first-in-first-served approach for simulation of servicing multiple patients. The uncertain time duration of the activities is modeled using the function "rand()". The patients movements from one activity to the next one is tracked with nested "if()" functions, thus allowing easy re-creation of the process without the need of complex programming. Copyright © 2015 The Authors. Published by Elsevier Ireland Ltd.. All rights reserved.

Psychology Experiment Authoring Kit (PEAK): formal usability testing of an easy-to-use method for creating computerized experiments.

PubMed

Schneider, Walter; Bolger, D J; Eschman, Amy; Neff, Christopher; Zuccolotto, Anthony P

2005-05-01

In academic courses in which one task for the students is to understand empirical methodology and the nature of scientific inquiry, the ability of students to create and implement their own experiments allows them to take intellectual ownership of, and greatly facilitates, the learning process. The Psychology Experiment Authoring Kit (PEAK) is a novel spreadsheet-based interface allowing students and researchers with rudimentary spreadsheet skills to create cognitive and cognitive neuroscience experiments in minutes. Students fill in a spreadsheet listing of independent variables and stimuli, insert columns that represent experimental objects such as slides (presenting text, pictures, and sounds) and feedback displays to create complete experiments, all within a single spreadsheet. The application then executes experiments with centisecond precision. Formal usability testing was done in two stages: (1) detailed coding of 10 individual subjects in one-on-one experimenter/subject videotaped sessions and (2) classroom testing of 64 undergraduates. In both individual and classroom testing, the students learned to effectively use PEAK within 2 h, and were able to create a lexical decision experiment in under 10 min. Findings from the individual testing in Stage 1 resulted in significant changes to documentation and training materials and identification of bugs to be corrected. Stage 2 testing identified additional bugs to be corrected and new features to be considered to facilitate student understanding of the experiment model. Such testing will improve the approach with each semester. The students were typically able to create their own projects in 2 h.

Using the Saturn V and Titan III Vibroacoustic Databanks for Random Vibration Criteria Development

NASA Technical Reports Server (NTRS)

Ferbee, R C.

2009-01-01

This is an update to TN D-7159, "Development and Application of Vibroacoustic Structural Data Banks in Predicting Vibration Design and Test Criteria for Rocket Vehicle Structures", which was originally published in 1973. Errors in the original document have been corrected and additional data from the Titan III program have been included. Methods for using the vibroacoustic databanks for vibration test criteria development are shown, as well as all of the data with drawings and pictures of the measurement locations. An Excel spreadsheet with the data included is available from the author.

Algorithm improvement program nuclide identification algorithm scoring criteria and scoring application.

DOE Office of Scientific and Technical Information (OSTI.GOV)

Enghauser, Michael

2016-02-01

The goal of the Domestic Nuclear Detection Office (DNDO) Algorithm Improvement Program (AIP) is to facilitate gamma-radiation detector nuclide identification algorithm development, improvement, and validation. Accordingly, scoring criteria have been developed to objectively assess the performance of nuclide identification algorithms. In addition, a Microsoft Excel spreadsheet application for automated nuclide identification scoring has been developed. This report provides an overview of the equations, nuclide weighting factors, nuclide equivalencies, and configuration weighting factors used by the application for scoring nuclide identification algorithm performance. Furthermore, this report presents a general overview of the nuclide identification algorithm scoring application including illustrative examples.

Groups: knowledge spreadsheets for symbolic biocomputing.

PubMed

Travers, Michael; Paley, Suzanne M; Shrager, Jeff; Holland, Timothy A; Karp, Peter D

2013-01-01

Knowledge spreadsheets (KSs) are a visual tool for interactive data analysis and exploration. They differ from traditional spreadsheets in that rather than being oriented toward numeric data, they work with symbolic knowledge representation structures and provide operations that take into account the semantics of the application domain. 'Groups' is an implementation of KSs within the Pathway Tools system. Groups allows Pathway Tools users to define a group of objects (e.g. groups of genes or metabolites) from a Pathway/Genome Database. Groups can be transformed (e.g. by transforming a metabolite group to the group of pathways in which those metabolites are substrates); combined through set operations; analysed (e.g. through enrichment analysis); and visualized (e.g. by painting onto a metabolic map diagram). Users of the Pathway Tools-based BioCyc.org website have made extensive use of Groups, and an informal survey of Groups users suggests that Groups has achieved the goal of allowing biologists themselves to perform some data manipulations that previously would have required the assistance of a programmer. Database URL: BioCyc.org.

Automated extraction of radiation dose information from CT dose report images.

PubMed

Li, Xinhua; Zhang, Da; Liu, Bob

2011-06-01

The purpose of this article is to describe the development of an automated tool for retrieving texts from CT dose report images. Optical character recognition was adopted to perform text recognitions of CT dose report images. The developed tool is able to automate the process of analyzing multiple CT examinations, including text recognition, parsing, error correction, and exporting data to spreadsheets. The results were precise for total dose-length product (DLP) and were about 95% accurate for CT dose index and DLP of scanned series.

WestProPlus: a stochastic spreadsheet program for the management of all-aged Douglas-fir–hemlock forests in the Pacific Northwest.

Treesearch

Jingjing Liang; Joseph Buongiorno; Robert A. Monserud

2006-01-01

WestProPlus is an add-in program developed to work with Microsoft Excel to simulate the growth and management of all-aged Douglas-fir–western hemlock (Pseudotsuga menziesii (Mirb.) Franco–Tsuga heterophylla (Raf.) Sarg.) stands in Oregon and Washington. Its built-in growth model was calibrated from 2,706 permanent plots in the...

The Managed Readiness Simulator: A Force Readiness Model

DTIC Science & Technology

2011-12-01

specific mili- tary occupations. Tyche Fleet Mix Model (Eisler, Bourque, and Reive 2009) provides the most effective mix of maritime fleet assets to...through the GUI input screens or imported from an external source such as a corporate database or spreadsheet. As the Simulation Manager, the GUI...Memorandum DRDC CORA TM 2011-xx. (in press) Skraba, A., M. Kljajic, A. Knaflic, D. Kofjac, and I. Podbregar. 2007. “Development of a Human Re

ROE Carbon Storage - Forest Biomass

EPA Pesticide Factsheets

This polygon dataset depicts the density of forest biomass in counties across the United States, in terms of metric tons of carbon per square mile of land area. These data were provided in spreadsheet form by the U.S. Department of Agriculture (USDA) Forest Service. To produce the Web mapping application, EPA joined the spreadsheet with a shapefile of U.S. county (and county equivalent) boundaries downloaded from the U.S. Census Bureau. EPA calculated biomass density based on the area of each county polygon. These data sets were converted into a single polygon feature class inside a file geodatabase.

A Microsoft Excel® 2010 Based Tool for Calculating Interobserver Agreement

PubMed Central

Azulay, Richard L

2011-01-01

This technical report provides detailed information on the rationale for using a common computer spreadsheet program (Microsoft Excel®) to calculate various forms of interobserver agreement for both continuous and discontinuous data sets. In addition, we provide a brief tutorial on how to use an Excel spreadsheet to automatically compute traditional total count, partial agreement-within-intervals, exact agreement, trial-by-trial, interval-by-interval, scored-interval, unscored-interval, total duration, and mean duration-per-interval interobserver agreement algorithms. We conclude with a discussion of how practitioners may integrate this tool into their clinical work. PMID:22649578

A microsoft excel(®) 2010 based tool for calculating interobserver agreement.

PubMed

Reed, Derek D; Azulay, Richard L

2011-01-01

This technical report provides detailed information on the rationale for using a common computer spreadsheet program (Microsoft Excel(®)) to calculate various forms of interobserver agreement for both continuous and discontinuous data sets. In addition, we provide a brief tutorial on how to use an Excel spreadsheet to automatically compute traditional total count, partial agreement-within-intervals, exact agreement, trial-by-trial, interval-by-interval, scored-interval, unscored-interval, total duration, and mean duration-per-interval interobserver agreement algorithms. We conclude with a discussion of how practitioners may integrate this tool into their clinical work.

Gravity Data for West-Central Colorado

DOE Data Explorer

Richard Zehner

2012-04-06

Modeled Bouger-Corrected Gravity data was extracted from the Pan American Center for Earth and Environmental Studies Gravity Database of the U.S. at http://irpsrvgis08.utep.edu/viewers/Flex/GravityMagnetic/GravityMagnetic_CyberShare/ on 2/29/2012. The downloaded text file was opened in an Excel spreadsheet. This spreadsheet data was then converted into an ESRI point shapefile in UTM Zone 13 NAD27 projection, showing location and gravity (in milligals). This data was then converted to grid and then contoured using ESRI Spatial Analyst. Data from From University of Texas: Pan American Center for Earth and Environmental Studies

Animated-simulation modeling facilitates clinical-process costing.

PubMed

Zelman, W N; Glick, N D; Blackmore, C C

2001-09-01

Traditionally, the finance department has assumed responsibility for assessing process costs in healthcare organizations. To enhance process-improvement efforts, however, many healthcare providers need to include clinical staff in process cost analysis. Although clinical staff often use electronic spreadsheets to model the cost of specific processes, PC-based animated-simulation tools offer two major advantages over spreadsheets: they allow clinicians to interact more easily with the costing model so that it more closely represents the process being modeled, and they represent cost output as a cost range rather than as a single cost estimate, thereby providing more useful information for decision making.

VeriClick: an efficient tool for table format verification

NASA Astrophysics Data System (ADS)

Nagy, George; Tamhankar, Mangesh

2012-01-01

The essential layout attributes of a visual table can be defined by the location of four critical grid cells. Although these critical cells can often be located by automated analysis, some means of human interaction is necessary for correcting residual errors. VeriClick is a macro-enabled spreadsheet interface that provides ground-truthing, confirmation, correction, and verification functions for CSV tables. All user actions are logged. Experimental results of seven subjects on one hundred tables suggest that VeriClick can provide a ten- to twenty-fold speedup over performing the same functions with standard spreadsheet editing commands.

Assessing Cumulative Impacts of Coal Bed Methane Development on Surface Water Quality and its Suitability for Irrigation in the Powder River Basin

NASA Astrophysics Data System (ADS)

Dawson, H. E.

2003-12-01

This paper presents a mass balance approach to assessing the cumulative impacts of discharge from Coal Bed Methane (CBM) wells on surface water quality and its suitability for irrigation in the Powder River Basin. Key water quality parameters for predicting potential effects of CBM development on irrigated agriculture are sodicity, expressed as sodium adsorption ratio (SAR) and salinity, expressed as electrical conductivity (EC). The assessment was performed with the aid of a spreadsheet model, which was designed to estimate steady-state SAR and EC at gauged stream locations after mixing with CBM produced water. Model input included ambient stream water quality and flow, CBM produced water quality and discharge rates, conveyance loss (quantity of water loss that may occur between the discharge point and the receiving streams), beneficial uses, regulatory thresholds, and discharge allocation at state-line boundaries. Historical USGS data were used to establish ambient stream water quality and flow conditions. The resultant water quality predicted for each stream station included the cumulative discharge of CBM produced water in all reaches upstream of the station. Model output was presented in both tabular and graphical formats, and indicated the suitability of pre- and post-mixing water quality for irrigation. Advantages and disadvantages of the spreadsheet model are discussed. This approach was used by federal agencies to support the development of the January 2003 Environmental Impact Statements (EIS) for the Wyoming and Montana portions of the Powder River Basin.

Database improvements for motor vehicle/bicycle crash analysis

PubMed Central

Lusk, Anne C; Asgarzadeh, Morteza; Farvid, Maryam S

2015-01-01

Background Bicycling is healthy but needs to be safer for more to bike. Police crash templates are designed for reporting crashes between motor vehicles, but not between vehicles/bicycles. If written/drawn bicycle-crash-scene details exist, these are not entered into spreadsheets. Objective To assess which bicycle-crash-scene data might be added to spreadsheets for analysis. Methods Police crash templates from 50 states were analysed. Reports for 3350 motor vehicle/bicycle crashes (2011) were obtained for the New York City area and 300 cases selected (with drawings and on roads with sharrows, bike lanes, cycle tracks and no bike provisions). Crashes were redrawn and new bicycle-crash-scene details were coded and entered into the existing spreadsheet. The association between severity of injuries and bicycle-crash-scene codes was evaluated using multiple logistic regression. Results Police templates only consistently include pedal-cyclist and helmet. Bicycle-crash-scene coded variables for templates could include: 4 bicycle environments, 18 vehicle impact-points (opened-doors and mirrors), 4 bicycle impact-points, motor vehicle/bicycle crash patterns, in/out of the bicycle environment and bike/relevant motor vehicle categories. A test of including these variables suggested that, with bicyclists who had minor injuries as the control group, bicyclists on roads with bike lanes riding outside the lane had lower likelihood of severe injuries (OR, 0.40, 95% CI 0.16 to 0.98) compared with bicyclists riding on roads without bicycle facilities. Conclusions Police templates should include additional bicycle-crash-scene codes for entry into spreadsheets. Crash analysis, including with big data, could then be conducted on bicycle environments, motor vehicle potential impact points/doors/mirrors, bicycle potential impact points, motor vehicle characteristics, location and injury. PMID:25835304

DOE Office of Scientific and Technical Information (OSTI.GOV)

Hunsberger, Randolph; Tomberlin, Gregg; Gaul, Chris

As part of the Army Net-Zero Energy Installation program, the Fort Carson Army Base requested that NREL evaluate the feasibility of adding a biomass boiler to the district heating system served by Building 1860. We have also developed an Excel-spreadsheet-based decision support tool--specific to the historic loads served by Building 1860--with which users can perform what-if analysis on gas costs, biomass costs, and other parameters. For economic reasons, we do not recommend adding a biomass system at this time.

CProb: a computational tool for conducting conditional probability analysis.

PubMed

Hollister, Jeffrey W; Walker, Henry A; Paul, John F

2008-01-01

Conditional probability is the probability of observing one event given that another event has occurred. In an environmental context, conditional probability helps to assess the association between an environmental contaminant (i.e., the stressor) and the ecological condition of a resource (i.e., the response). These analyses, when combined with controlled experiments and other methodologies, show great promise in evaluating ecological conditions from observational data and in defining water quality and other environmental criteria. Current applications of conditional probability analysis (CPA) are largely done via scripts or cumbersome spreadsheet routines, which may prove daunting to end-users and do not provide access to the underlying scripts. Combining spreadsheets with scripts eases computation through a familiar interface (i.e., Microsoft Excel) and creates a transparent process through full accessibility to the scripts. With this in mind, we developed a software application, CProb, as an Add-in for Microsoft Excel with R, R(D)com Server, and Visual Basic for Applications. CProb calculates and plots scatterplots, empirical cumulative distribution functions, and conditional probability. In this short communication, we describe CPA, our motivation for developing a CPA tool, and our implementation of CPA as a Microsoft Excel Add-in. Further, we illustrate the use of our software with two examples: a water quality example and a landscape example. CProb is freely available for download at http://www.epa.gov/emap/nca/html/regions/cprob.

WAVECALC: an Excel-VBA spreadsheet to model the characteristics of fully developed waves and their influence on bottom sediments in different water depths

NASA Astrophysics Data System (ADS)

Le Roux, Jacobus P.; Demirbilek, Zeki; Brodalka, Marysia; Flemming, Burghard W.

2010-10-01

The generation and growth of waves in deep water is controlled by winds blowing over the sea surface. In fully developed sea states, where winds and waves are in equilibrium, wave parameters may be calculated directly from the wind velocity. We provide an Excel spreadsheet to compute the wave period, length, height and celerity, as well as horizontal and vertical particle velocities for any water depth, bottom slope, and distance below the reference water level. The wave profile and propagation can also be visualized for any water depth, modeling the sea surface change from sinusoidal to trochoidal and finally cnoidal profiles into shallow water. Bedload entrainment is estimated under both the wave crest and the trough, using the horizontal water particle velocity at the top of the boundary layer. The calculations are programmed in an Excel file called WAVECALC, which is available online to authorized users. Although many of the recently published formulas are based on theoretical arguments, the values agree well with several existing theories and limited field and laboratory observations. WAVECALC is a user-friendly program intended for sedimentologists, coastal engineers and oceanographers, as well as marine ecologists and biologists. It provides a rapid means to calculate many wave characteristics required in coastal and shallow marine studies, and can also serve as an educational tool.

Supplemental knowledge acquisition through external product interface for CLIPS

NASA Technical Reports Server (NTRS)

Saito, Tim; Ebaud, Stephen; Loftin, Bowen R.

1990-01-01

Traditionally, the acquisition of knowledge for expert systems consisted of the interview process with the domain or subject matter expert (SME), observation of domain environment, and information gathering and research which constituted a direct form of knowledge acquisition (KA). The knowledge engineer would be responsible for accumulating pertinent information and/or knowledge from the SME(s) for input into the appropriate expert system development tool. The direct KA process may (or may not) have included forms of data or documentation to incorporate from the SME's surroundings. The differentiation between direct KA and supplemental KA (indirect) would be the difference in the use of data. In acquiring supplemental knowledge, the knowledge engineer would access other types of evidence (manuals, documents, data files, spreadsheets, etc.) that would support the reasoning or premises of the SME. When an expert makes a decision in a particular task, one tool that may have been used to justify a recommendation, would have been a spreadsheet total or column figure. Locating specific decision points from that data within the SME's framework would constitute supplemental KA. Data used for a specific purpose in one system or environment would be used as supplemental knowledge for another, specifically a CLIPS project.

Algorithm Improvement Program Nuclide Identification Algorithm Scoring Criteria And Scoring Application - DNDO.

DOE Office of Scientific and Technical Information (OSTI.GOV)

Enghauser, Michael

2015-02-01

The goal of the Domestic Nuclear Detection Office (DNDO) Algorithm Improvement Program (AIP) is to facilitate gamma-radiation detector nuclide identification algorithm development, improvement, and validation. Accordingly, scoring criteria have been developed to objectively assess the performance of nuclide identification algorithms. In addition, a Microsoft Excel spreadsheet application for automated nuclide identification scoring has been developed. This report provides an overview of the equations, nuclide weighting factors, nuclide equivalencies, and configuration weighting factors used by the application for scoring nuclide identification algorithm performance. Furthermore, this report presents a general overview of the nuclide identification algorithm scoring application including illustrative examples.

Sensor performance analysis

NASA Technical Reports Server (NTRS)

Montgomery, H. E.; Ostrow, H.; Ressler, G. M.

1990-01-01

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.

User Instructions for the Policy Analysis Modeling System (PAMS)

DOE Office of Scientific and Technical Information (OSTI.GOV)

McNeil, Michael A.; Letschert, Virginie E.; Van Buskirk, Robert D.

PAMS uses country-specific and product-specific data to calculate estimates of impacts of a Minimum Efficiency Performance Standard (MEPS) program. The analysis tool is self-contained in a Microsoft Excel spreadsheet, and requires no links to external data, or special code additions to run. The analysis can be customized to a particular program without additional user input, through the use of the pull-down menus located on the Summary page. In addition, the spreadsheet contains many areas into which user-generated input data can be entered for increased accuracy of projection. The following is a step-by-step guide for using and customizing the tool.

A pier-scour database: 2,427 field and laboratory measurements of pier scour

USGS Publications Warehouse

Benedict, Stephen T.; Caldwell, Andral W.

2014-01-01

The U.S. Geological Survey conducted a literature review to identify potential sources of published pier-scour data, and selected data were compiled into a digital spreadsheet called the 2014 USGS Pier-Scour Database (PSDb-2014) consisting of 569 laboratory and 1,858 field measurements. These data encompass a wide range of laboratory and field conditions and represent field data from 23 States within the United States and from 6 other countries. The digital spreadsheet is available on the Internet and offers a valuable resource to engineers and researchers seeking to understand pier-scour relations in the laboratory and field.

Ground Magnetic Data for West-Central Colorado

DOE Data Explorer

Richard Zehner

2012-03-08

Modeled ground magnetic data was extracted from the Pan American Center for Earth and Environmental Studies database at http://irpsrvgis08.utep.edu/viewers/Flex/GravityMagnetic/GravityMagnetic_CyberShare/ on 2/29/2012. The downloaded text file was then imported into an Excel spreadsheet. This spreadsheet data was converted into an ESRI point shapefile in UTM Zone 13 NAD27 projection, showing location and magnetic field strength in nano-Teslas. This point shapefile was then interpolated to an ESRI grid using an inverse-distance weighting method, using ESRI Spatial Analyst. The grid was used to create a contour map of magnetic field strength.

DOE Office of Scientific and Technical Information (OSTI.GOV)

Cottam, Joseph A.; Blaha, Leslie M.

Systems have biases. Their interfaces naturally guide a user toward specific patterns of action. For example, modern word-processors and spreadsheets are both capable of taking word wrapping, checking spelling, storing tables, and calculating formulas. You could write a paper in a spreadsheet or could do simple business modeling in a word-processor. However, their interfaces naturally communicate which function they are designed for. Visual analytic interfaces also have biases. In this paper, we outline why simple Markov models are a plausible tool for investigating that bias and how they might be applied. We also discuss some anticipated difficulties in such modelingmore » and touch briefly on what some Markov model extensions might provide.« less

Spreadsheets for Analyzing and Optimizing Space Missions

NASA Technical Reports Server (NTRS)

Some, Raphael R.; Agrawal, Anil K.; Czikmantory, Akos J.; Weisbin, Charles R.; Hua, Hook; Neff, Jon M.; Cowdin, Mark A.; Lewis, Brian S.; Iroz, Juana; Ross, Rick

2009-01-01

XCALIBR (XML Capability Analysis LIBRary) is a set of Extensible Markup Language (XML) database and spreadsheet- based analysis software tools designed to assist in technology-return-on-investment analysis and optimization of technology portfolios pertaining to outer-space missions. XCALIBR is also being examined for use in planning, tracking, and documentation of projects. An XCALIBR database contains information on mission requirements and technological capabilities, which are related by use of an XML taxonomy. XCALIBR incorporates a standardized interface for exporting data and analysis templates to an Excel spreadsheet. Unique features of XCALIBR include the following: It is inherently hierarchical by virtue of its XML basis. The XML taxonomy codifies a comprehensive data structure and data dictionary that includes performance metrics for spacecraft, sensors, and spacecraft systems other than sensors. The taxonomy contains >700 nodes representing all levels, from system through subsystem to individual parts. All entries are searchable and machine readable. There is an intuitive Web-based user interface. The software automatically matches technologies to mission requirements. The software automatically generates, and makes the required entries in, an Excel return-on-investment analysis software tool. The results of an analysis are presented in both tabular and graphical displays.

Statically determined slip-line field solution for the axial forming force estimation in the radial-axial ring rolling process

NASA Astrophysics Data System (ADS)

Quagliato, Luca; Berti, Guido A.

2017-10-01

In this paper, a statically determined slip-line solution algorithm is proposed for the calculation of the axial forming force in the radial-axial ring rolling process of flat rings. The developed solution is implemented in an Excel spreadsheet for the construction of the slip-line field and the calculation of the pressure factor to be used in the force model. The comparison between analytical solution and authors' FE simulation allows stating that the developed model supersedes the previous literature ones and proves the reliability of the proposed approach.

A programmable rules engine to provide clinical decision support using HTML forms.

PubMed

Heusinkveld, J; Geissbuhler, A; Sheshelidze, D; Miller, R

1999-01-01

The authors have developed a simple method for specifying rules to be applied to information on HTML forms. This approach allows clinical experts, who lack the programming expertise needed to write CGI scripts, to construct and maintain domain-specific knowledge and ordering capabilities within WizOrder, the order-entry and decision support system used at Vanderbilt Hospital. The clinical knowledge base maintainers use HTML editors to create forms and spreadsheet programs for rule entry. A test environment has been developed which uses Netscape to display forms; the production environment displays forms using an embedded browser.

A Magnetically Suspended Wheel for a Miniature Gyro Made Using Planar Fabrication Technologies

NASA Technical Reports Server (NTRS)

Dauwalter, Charles R.

1996-01-01

The technical feasibility of a magnetically suspended rotating wheel for miniature gyro applications was investigated under a NASA SBIR contract. A concept for a configuration for a system of compact, lightweight magnetic actuators capable of generating the necessary suspension forces and fabrication using millimachining planar fabrication technologies was developed. Both capacitive and electromagnetic position sensing concepts were developed for implementing a closed loop control system for supporting the wheel. A finite difference technique, implemented in a spreadsheet environment, for analyzing the force characteristics of the actuator was used and the results verified with Finite Element Analysis.

Trends in musical theatre voice: an analysis of audition requirements for singers.

PubMed

Green, Kathryn; Freeman, Warren; Edwards, Matthew; Meyer, David

2014-05-01

The American musical theatre industry is a multibillion dollar business in which the requirements for singers are varied and complex. This study identifies the musical genres and voice requirements that are currently most requested at professional auditions to help voice teachers, pedagogues, and physicians who work with musical theatre singers understand the demands of their clients' business. Frequency count. One thousand two thirty-eight professional musical theatre audition listings were gathered over a 6-month period, and information from each listing was categorized and entered into a spreadsheet for analysis. The results indicate that four main genres of music were requested over a wide variety of styles, with more than half of auditions requesting genre categories that may not be served by traditional or classical voice technique alone. To adequately prepare young musical theatre performers for the current job market and keep the performers healthily making the sounds required by the industry, new singing styles may need to be studied and integrated into voice training that only teaches classical styles. Copyright © 2014 The Voice Foundation. Published by Mosby, Inc. All rights reserved.

Myocardial and liver iron overload, assessed using T2* magnetic resonance imaging with an excel spreadsheet for post processing in Tunisian thalassemia major patients.

PubMed

Ouederni, Monia; Ben Khaled, Monia; Mellouli, Fethi; Ben Fraj, Elhem; Dhouib, Nawel; Yakoub, Ismehen Ben; Abbes, Selem; Mnif, Nejla; Bejaoui, Mohamed

2017-01-01

Thalassemia is a common genetic disorder in Tunisia. Early iron concentration assessment is a crucial and challenging issue. Most of annual deaths due to iron overload occurred in underdeveloped regions of the world. Limited access to liver and heart MRI monitoring might partially explain these poor prognostic results. Standard software programs are not available in Tunisia. This study is the first to evaluate iron overload in heart and liver using the MRI T2* with excel spreadsheet for post processing. Association of this MRI tool results to serum ferritin level, and echocardiography was also investigated. One hundred Tunisian-transfused thalassemia patients older than 10 years (16.1 ± 5.2) were enrolled in the study. The mean myocardial iron concentration (MIC) was 1.26 ± 1.65 mg/g dw (0.06-8.32). Cardiac T2* (CT2*) was under 20 ms in 30 % of patients and under 10 ms in 21 % of patients. Left ventricular ejection function was significantly lower in patients with CT2* <10 ms. Abnormal liver iron concentration (LIC >3 mg/g dw) was found in 95 % of patients. LIC was over 15 mg/g dw in 25 % of patients. MIC was more correlated than CT2* to LIC and serum ferritin. Among patients with SF <1000 μg/l, 13 % had CT2* <20 ms. Our data showed that 30 % of the Tunisian thalassemia major patients enrolled in this cohort had myocardial iron overload despite being treated by iron chelators. SF could not reliably predict iron overload in all thalassemia patients. MRI T2* using excel spreadsheet for routine follow-up of iron overload might improve the prognosis of thalassemia major patients in developing countries, such as Tunisia, where standard MRI tools are not available or expensive.

WQEP - a computer spreadsheet program to evaluate water quality data

DOE Office of Scientific and Technical Information (OSTI.GOV)

Liddle, R.G.

1996-12-31

A flexible spreadsheet Water Quality Evaluation Program (WQEP) has been developed for mining companies, consultants, and regulators to interpret the results of water quality sampling. In order properly to evaluate hydrologic data, unit conversions and chemical calculations are done, quality control checks are needed, and a complete and up-to-date listing of water quality standards is necessary. This process is time consuming and tends not to be done for every sample. This program speeds the process by allowing the input of up to 115 chemical parameters from one sample. WQEP compares concentrations with EPA primary and secondary drinking water MCLs ormore » MCLG, EPA warmwater and Coldwater acute and chronic aquatic life criteria, irrigation criteria, livestock criteria, EPA human health criteria, and several other categories of criteria. The spreadsheet allows the input of State or local water standards of interest. Water quality checks include: anion/cations, TDS{sub m}/TDS{sub c} (where m=measured and c=calculated), EC{sub m}/EC{sub c}, EC{sub m}/ion sums, TDS{sub c}/EC ratio, TDS{sub m}/EC, EC vs. alkalinity, two hardness values, and EC vs. {Sigma} cations. WQEP computes the dissolved transport index of 23 parameters, computes ratios of 26 species for trend analysis, calculates non-carbonate alkalinity to adjust the bicarbonate concentration, and calculates 35 interpretive formulas (pE, SAR, S.I., unionized ammonia, ionized sulfide HS-, pK{sub x} values, etc.). Fingerprinting is conducted by automatic generation of stiff diagrams and ion histograms. Mass loading calculations, mass balance calculations, conversions of concentrations, ionic strength, and the activity coefficient and chemical activity of 33 parameters is calculated. This program allows a speedy and thorough evaluation of water quality data from metal mines, coal mining, and natural surface water systems and has been tested against hand calculations.« less

Documentation of a spreadsheet for time-series analysis and drawdown estimation

USGS Publications Warehouse

Halford, Keith J.

2006-01-01

Drawdowns during aquifer tests can be obscured by barometric pressure changes, earth tides, regional pumping, and recharge events in the water-level record. These stresses can create water-level fluctuations that should be removed from observed water levels prior to estimating drawdowns. Simple models have been developed for estimating unpumped water levels during aquifer tests that are referred to as synthetic water levels. These models sum multiple time series such as barometric pressure, tidal potential, and background water levels to simulate non-pumping water levels. The amplitude and phase of each time series are adjusted so that synthetic water levels match measured water levels during periods unaffected by an aquifer test. Differences between synthetic and measured water levels are minimized with a sum-of-squares objective function. Root-mean-square errors during fitting and prediction periods were compared multiple times at four geographically diverse sites. Prediction error equaled fitting error when fitting periods were greater than or equal to four times prediction periods. The proposed drawdown estimation approach has been implemented in a spreadsheet application. Measured time series are independent so that collection frequencies can differ and sampling times can be asynchronous. Time series can be viewed selectively and magnified easily. Fitting and prediction periods can be defined graphically or entered directly. Synthetic water levels for each observation well are created with earth tides, measured time series, moving averages of time series, and differences between measured and moving averages of time series. Selected series and fitting parameters for synthetic water levels are stored and drawdowns are estimated for prediction periods. Drawdowns can be viewed independently and adjusted visually if an anomaly skews initial drawdowns away from 0. The number of observations in a drawdown time series can be reduced by averaging across user-defined periods. Raw or reduced drawdown estimates can be copied from the spreadsheet application or written to tab-delimited ASCII files.

Economic analysis of recycling contaminated concrete

DOE Office of Scientific and Technical Information (OSTI.GOV)

Stephen, A.; Ayers, K.W.; Boren, J.K.

1997-02-01

Decontamination and Decommissioning activities in the DOE complex generate large volumes of radioactively contaminated and uncontaminated concrete. Currently, this concrete is usually decontaminated, the contaminated waste is disposed of in a LLW facility and the decontaminated concrete is placed in C&D landfills. A number of alternatives to this practice are available including recycling of the concrete. Cost estimates for six alternatives were developed using a spreadsheet model. The results of this analysis show that recycling alternatives are at least as economical as current practice.

A Web Service Implementation for Large-Scale Automation, Visualization and Real-Time Program Awareness via Lexical Link Analysis

DTIC Science & Technology

2011-04-30

internal constructs f l f t th h l i l li k l i (LLA)? 3 use u or managemen , roug ex ca n ana ys s LLA Methodology Can Help! Warfighters RDTE...information, including suggestions for reducing this burden, to Washington Headquarters Services, Directorate for Information Operations and Reports...categories of interest in various spreadsheets). This year, we started to develop LLA from a demonstration to an operational capability and facilitate a

Use of Excel ion exchange equilibrium solver with WinGEMS to model and predict NPE distribution in the Mead/Westvaco Evandale, TX, hardwood bleach plant

Treesearch

Christopher Litvay; Alan Rudie; Peter Hart

2003-01-01

An Excel spreadsheet developed to solve the ion-exchange equilibrium in wood pulps has been linked by dynamic data exchange to WinGEMS and used to model the non-process elements in the hardwood bleach plant of the Mead/Westvaco Evandale mill. Pulp and filtrate samples were collected from the diffusion washers and final wash press of the bleach plant. A WinGEMS model of...

MetaRep, an extended CMAS 3D program to visualize mafic (CMAS, ACF-S, ACF-N) and pelitic (AFM-K, AFM-S, AKF-S) projections

NASA Astrophysics Data System (ADS)

France, Lydéric; Nicollet, Christian

2010-06-01

MetaRep is a program based on our earlier program CMAS 3D. It is developed in MATLAB ® script. MetaRep objectives are to visualize and project major element compositions of mafic and pelitic rocks and their minerals in the pseudo-quaternary projections of the ACF-S, ACF-N, CMAS, AFM-K, AFM-S and AKF-S systems. These six systems are commonly used to describe metamorphic mineral assemblages and magmatic evolutions. Each system, made of four apices, can be represented in a tetrahedron that can be visualized in three dimensions with MetaRep; the four tetrahedron apices represent oxides or combination of oxides that define the composition of the projected rock or mineral. The three-dimensional representation allows one to obtain a better understanding of the topology of the relationships between the rocks and minerals and relations. From these systems, MetaRep can also project data in ternary plots (for example, the ACF, AFM and AKF ternary projections can be generated). A functional interface makes it easy to use and does not require any knowledge of MATLAB ® programming. To facilitate the use, MetaRep loads, from the main interface, data compiled in a Microsoft Excel ™ spreadsheet. Although useful for scientific research, the program is also a powerful tool for teaching. We propose an application example that, by using two combined systems (ACF-S and ACF-N), provides strong confirmation in the petrological interpretation.

uSIMPK. An Excel for Windows-based simulation program for instruction of basic pharmacokinetics principles to pharmacy students.

PubMed

Brocks, Dion R

2015-07-01

Pharmacokinetics can be a challenging topic to teach due to the complex relationships inherent between physiological parameters, mathematical descriptors and equations, and their combined impact on shaping the blood fluid concentration vs. time curves of drugs. A computer program was developed within Microsoft Excel for Windows, designed to assist in the instruction of basic pharmacokinetics within an entry-to-practice pharmacy class environment. The program is composed of a series of spreadsheets (modules) linked by Visual Basic for Applications, intended to illustrate the relationships between pharmacokinetic and in some cases physiological parameters, doses and dose rates and the drug blood fluid concentration vs. time curves. Each module is accompanied by a simulation user's guide, prompting the user to change specific independent parameters and then observe the impact of the change(s) on the drug concentration vs. time curve and on other dependent parameters. "Slider" (or "scroll") bars can be selected to readily see the effects of repeated changes on the dependencies. Topics covered include one compartment single dose administration (iv bolus, oral, short infusion), intravenous infusion, repeated doses, renal and hepatic clearance, nonlinear elimination, two compartment model, plasma protein binding and the relationship between pharmacokinetics and drug effect. The program has been used in various forms in the classroom over a number of years, with positive ratings generally being received from students for its use in the classroom. Copyright © 2015 Elsevier Ireland Ltd. All rights reserved.

Engine System Model Development for Nuclear Thermal Propulsion

NASA Technical Reports Server (NTRS)

Nelson, Karl W.; Simpson, Steven P.

2006-01-01

In order to design, analyze, and evaluate conceptual Nuclear Thermal Propulsion (NTP) engine systems, an improved NTP design and analysis tool has been developed. The NTP tool utilizes the Rocket Engine Transient Simulation (ROCETS) system tool and many of the routines from the Enabler reactor model found in Nuclear Engine System Simulation (NESS). Improved non-nuclear component models and an external shield model were added to the tool. With the addition of a nearly complete system reliability model, the tool will provide performance, sizing, and reliability data for NERVA-Derived NTP engine systems. A new detailed reactor model is also being developed and will replace Enabler. The new model will allow more flexibility in reactor geometry and include detailed thermal hydraulics and neutronics models. A description of the reactor, component, and reliability models is provided. Another key feature of the modeling process is the use of comprehensive spreadsheets for each engine case. The spreadsheets include individual worksheets for each subsystem with data, plots, and scaled figures, making the output very useful to each engineering discipline. Sample performance and sizing results with the Enabler reactor model are provided including sensitivities. Before selecting an engine design, all figures of merit must be considered including the overall impacts on the vehicle and mission. Evaluations based on key figures of merit of these results and results with the new reactor model will be performed. The impacts of clustering and external shielding will also be addressed. Over time, the reactor model will be upgraded to design and analyze other NTP concepts with CERMET and carbide fuel cores.

(abstract) Simple Spreadsheet Thermal Models for Cryogenic Applications

NASA Technical Reports Server (NTRS)

Nash, A. E.

1994-01-01

Self consistent circuit analog thermal models, that can be run in commercial spreadsheet programs on personal computers, have been created to calculate the cooldown and steady state performance of cryogen cooled Dewars. The models include temperature dependent conduction and radiation effects. The outputs of the models provide temperature distribution and Dewar performance information. These models have been used to analyze the Cryogenic Telescope Test Facility (CTTF). The facility will be on line in early 1995 for its first user, the Infrared Telescope Technology Testbed (ITTT), for the Space Infrared Telescope Facility (SIRTF) at JPL. The model algorithm as well as a comparison of the model predictions and actual performance of this facility will be presented.

Simple Spreadsheet Thermal Models for Cryogenic Applications

NASA Technical Reports Server (NTRS)

Nash, Alfred

1995-01-01

Self consistent circuit analog thermal models that can be run in commercial spreadsheet programs on personal computers have been created to calculate the cooldown and steady state performance of cryogen cooled Dewars. The models include temperature dependent conduction and radiation effects. The outputs of the models provide temperature distribution and Dewar performance information. these models have been used to analyze the SIRTF Telescope Test Facility (STTF). The facility has been brought on line for its first user, the Infrared Telescope Technology Testbed (ITTT), for the Space Infrared Telescope Facility (SIRTF) at JPL. The model algorithm as well as a comparison between the models' predictions and actual performance of this facility will be presented.

USGS Coal Desorption Equipment and a Spreadsheet for Analysis of Lost and Total Gas from Canister Desorption Measurements

USGS Publications Warehouse

Barker, Charles E.; Dallegge, Todd A.; Clark, Arthur C.

2002-01-01

We have updated a simple polyvinyl chloride plastic canister design by adding internal headspace temperature measurement, and redesigned it so it is made with mostly off-the-shelf components for ease of construction. Using self-closing quick connects, this basic canister is mated to a zero-head manometer to make a simple coalbed methane desorption system that is easily transported in small aircraft to remote localities. This equipment is used to gather timed measurements of pressure, volume and temperature data that are corrected to standard pressure and temperature (STP) and graphically analyzed using an Excel(tm)-based spreadsheet. Used together these elements form an effective, practical canister desorption method.

Modeling the world in a spreadsheet: Environmental simulation on a microcomputer

DOE Office of Scientific and Technical Information (OSTI.GOV)

Cartwright, T.J.

1993-12-31

This article focuses on the following: Modeling Natural Systems Blowing Smoke; Atmospheric Dispersion of Air Pollution Running Water; The Underground Transport of Pollutants Preserving the Species; Determining Minimum Viable Population Sustainable Yield; Managing the Forest for the Trees Here Comes the Sun; Solar Energy from a Flat-Plate Collector Modeling Social Systems Macroeconomic Policy; Econometrics and the Klein Model Urban Form; The Lowry Model of Population Distribution Affordable Housing; The Bertaud/World Bank Model Traffic on the Roads; Modeling Trip Generation and Trip Distribution Throwing Things Away; A Model for Waste Management Apples and Oranges; and An Environmental Impact Assessment Model Modelingmore » Artificial Systems Life in a Spreadsheet.« less

Realist synthesis of educational interventions to improve nutrition care competencies and delivery by doctors and other healthcare professionals

PubMed Central

Mogre, Victor; Scherpbier, Albert J J A; Stevens, Fred; Aryee, Paul; Cherry, Mary Gemma; Dornan, Tim

2016-01-01

Objective To determine what, how, for whom, why, and in what circumstances educational interventions improve the delivery of nutrition care by doctors and other healthcare professionals work. Design Realist synthesis following a published protocol and reported following Realist and Meta-narrative Evidence Synthesis: Evolving Standards (RAMESES) guidelines. A multidisciplinary team searched MEDLINE, CINAHL, ERIC, EMBASE, PsyINFO, Sociological Abstracts, Web of Science, Google Scholar and Science Direct for published and unpublished (grey) literature. The team identified studies with varied designs; appraised their ability to answer the review question; identified relationships between contexts, mechanisms and outcomes (CMOs); and entered them into a spreadsheet configured for the purpose. The final synthesis identified commonalities across CMO configurations. Results Over half of the 46 studies from which we extracted data originated from the USA. Interventions that improved the delivery of nutrition care improved skills and attitudes rather than just knowledge; provided opportunities for superiors to model nutrition care; removed barriers to nutrition care in health systems; provided participants with local, practically relevant tools and messages; and incorporated non-traditional, innovative teaching strategies. Operating in contexts where student and qualified healthcare professionals provided nutrition care in developed and developing countries, these interventions yielded health outcomes by triggering a range of mechanisms, which included feeling competent, feeling confident and comfortable, having greater self-efficacy, being less inhibited by barriers in healthcare systems and feeling that nutrition care was accepted and recognised. Conclusions These findings show how important it is to move education for nutrition care beyond the simple acquisition of knowledge. They show how educational interventions embedded within systems of healthcare can improve patients’ health by helping health students and professionals to appreciate the importance of delivering nutrition care and feel competent to deliver it. PMID:27797977

The experience of dentists who gained enhanced skills in endodontics within a novel pilot training programme.

PubMed

Eliyas, S; Briggs, P; Gallagher, J E

2017-02-24

Objective To explore the experiences of primary care dentists following training to enhance endodontic skills and their views on the implications for the NHS.Design Qualitative study using anonymised free text questionnaires.Setting Primary care general dental services within the National Health Service (NHS) in London, United Kingdom.Subjects and methods Eight primary care dentists who completed this training were asked about factors affecting participant experience of the course, perceived impact on themselves, their organisation, their patients and barriers/facilitators to providing endodontic treatment in NHS primary care. Data were transferred verbatim to a spreadsheet and thematically analysed.Intervention 24-month part-time educational and service initiative to provide endodontics within the NHS, using a combination of training in simulation lab and treatment of patients in primary care.Results Positive impacts were identified at individual (gains in knowledge, skills, confidence, personal development), patient (more teeth saved, quality of care improved) and system levels (access, value for money). Suggested developments for future courses included more case discussions, teaching of practical skills earlier in the course and refinement of the triaging processes. Barriers to using the acquired skills in providing endodontic treatment in primary care within the NHS were perceived to be resources (remuneration, time, skills) and accountability. Facilitators included appropriately remunerated contracts, necessary equipment and time.Conclusion This novel pilot training programme in endodontics combining general practice experience with education/training, hands-on experience and a portfolio was perceived by participants as beneficial for extending skills and service innovation in primary dental care. The findings provide insight into primary dental care practitioners' experience with education/training and have implications for future educational initiatives in support of systems innovation within the NHS.

Impact of a didactic sequence on basic Astronomy concepts for graduates in physics of online and classroom modalities

NASA Astrophysics Data System (ADS)

Voelzke, M. R.; Barbosa, J. I. L.

2017-07-01

In the transition from elementary school to high school, the topics related to astronomy are studied within the curriculae component of physics. In this context, at some point of time a Physic's teacher at this level of education will be faced with the need to work with the contents related to this science. In this way, it is important to broaden the discussion about teacher education, as well as to apply in practice the means for it. Therefore, this work has the objective to present the results, obtained by application of a questionnaire at the beginning (a pre-test), and at the final stage by a course for physics graduates of online and classroom modalities (completed with a post-test), which was organized through the Potentially Significant Teaching Units - PSTUs; and this work also presents the level of satisfaction of them in relation to the course. It is an applied and descriptive research, and the adopted technical procedures consisted of the survey and a participatory research. The data were organized in spreadsheets and the statistical analyzes were made in the sequence, with the objective of establishing comparisons between the studied groups, of their evolution of acquired knowledge and their level of satisfaction, resulting from the development in the course. The results indicate that there has been an evolution of the student's s basic knowledge with relation to the proposed topics of Astronomy in the didactic sequences, i.e., the activities developed in the administered course created a favorable atmosphere for the learning, which is therefore contributing to the initial formation of these physics teachers.

Market valuation perspectives for photovoltaic systems

DOE Office of Scientific and Technical Information (OSTI.GOV)

Klise, Geoffrey Taylor

Sandia National Laboratories, working with Energy Sense Finance developed the proof-ofconcept PV Valueª tool in 2011 to provide real estate appraisers a tool that can be used to develop the market value and fair market value of a solar photovoltaic system. PV Valueª moved from a proof-of-concept spreadsheet to a commercial web-based tool developed and operated exclusively by Energy Sense Finance in June 2014. This paper presents the results of a survey aimed at different user categories in order to measure how the tool is being used in the marketplace as well as elicit information that can be used tomore » improve the tools effectiveness.« less

Rapid Risk Evaluation (ER2) Using MS Excel Spreadsheet: a Case Study of Fredericton (new Brunswick, Canada)

NASA Astrophysics Data System (ADS)

McGrath, H.; Stefanakis, E.; Nastev, M.

2016-06-01

Conventional knowledge of the flood hazard alone (extent and frequency) is not sufficient for informed decision-making. The public safety community needs tools and guidance to adequately undertake flood hazard risk assessment in order to estimate respective damages and social and economic losses. While many complex computer models have been developed for flood risk assessment, they require highly trained personnel to prepare the necessary input (hazard, inventory of the built environment, and vulnerabilities) and analyze model outputs. As such, tools which utilize open-source software or are built within popular desktop software programs are appealing alternatives. The recently developed Rapid Risk Evaluation (ER2) application runs scenario based loss assessment analyses in a Microsoft Excel spreadsheet. User input is limited to a handful of intuitive drop-down menus utilized to describe the building type, age, occupancy and the expected water level. In anticipation of local depth damage curves and other needed vulnerability parameters, those from the U.S. FEMA's Hazus-Flood software have been imported and temporarily accessed in conjunction with user input to display exposure and estimated economic losses related to the structure and the content of the building. Building types and occupancies representative of those most exposed to flooding in Fredericton (New Brunswick) were introduced and test flood scenarios were run. The algorithm was successfully validated against results from the Hazus-Flood model for the same building types and flood depths.

Keemei: cloud-based validation of tabular bioinformatics file formats in Google Sheets.

PubMed

Rideout, Jai Ram; Chase, John H; Bolyen, Evan; Ackermann, Gail; González, Antonio; Knight, Rob; Caporaso, J Gregory

2016-06-13

Bioinformatics software often requires human-generated tabular text files as input and has specific requirements for how those data are formatted. Users frequently manage these data in spreadsheet programs, which is convenient for researchers who are compiling the requisite information because the spreadsheet programs can easily be used on different platforms including laptops and tablets, and because they provide a familiar interface. It is increasingly common for many different researchers to be involved in compiling these data, including study coordinators, clinicians, lab technicians and bioinformaticians. As a result, many research groups are shifting toward using cloud-based spreadsheet programs, such as Google Sheets, which support the concurrent editing of a single spreadsheet by different users working on different platforms. Most of the researchers who enter data are not familiar with the formatting requirements of the bioinformatics programs that will be used, so validating and correcting file formats is often a bottleneck prior to beginning bioinformatics analysis. We present Keemei, a Google Sheets Add-on, for validating tabular files used in bioinformatics analyses. Keemei is available free of charge from Google's Chrome Web Store. Keemei can be installed and run on any web browser supported by Google Sheets. Keemei currently supports the validation of two widely used tabular bioinformatics formats, the Quantitative Insights into Microbial Ecology (QIIME) sample metadata mapping file format and the Spatially Referenced Genetic Data (SRGD) format, but is designed to easily support the addition of others. Keemei will save researchers time and frustration by providing a convenient interface for tabular bioinformatics file format validation. By allowing everyone involved with data entry for a project to easily validate their data, it will reduce the validation and formatting bottlenecks that are commonly encountered when human-generated data files are first used with a bioinformatics system. Simplifying the validation of essential tabular data files, such as sample metadata, will reduce common errors and thereby improve the quality and reliability of research outcomes.

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

NASA Technical Reports Server (NTRS)

Gakin, R.; Lewis, K.; Simmons, J.; Gchachu, K.; Karner, J. M.; Newsom, H. E.; Jones, R. H.

2003-01-01

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

A programmable rules engine to provide clinical decision support using HTML forms.

PubMed Central

Heusinkveld, J.; Geissbuhler, A.; Sheshelidze, D.; Miller, R.

1999-01-01

The authors have developed a simple method for specifying rules to be applied to information on HTML forms. This approach allows clinical experts, who lack the programming expertise needed to write CGI scripts, to construct and maintain domain-specific knowledge and ordering capabilities within WizOrder, the order-entry and decision support system used at Vanderbilt Hospital. The clinical knowledge base maintainers use HTML editors to create forms and spreadsheet programs for rule entry. A test environment has been developed which uses Netscape to display forms; the production environment displays forms using an embedded browser. Images Figure 1 PMID:10566470

Coastal Changes in Temperature and Salinity Observed during Hurricane Isaac Recorded and Downloaded by NASA DRIFTERs Moored in Heron Bay and at Half Moon Island, Louisiana

NASA Technical Reports Server (NTRS)

Kalcic, Maria; Iturriaga, Rodolfo H.; Kuper, Philip D.; O'Neal, Stanford Duane; Underwood, Lauren; Fletcher, Rose

2012-01-01

Major changes in salinity (approx.14 ppt.) and temperature (approx.40C) were continuously registered by two prototype NASA DRIFTERs, surface moored floaters, that NASA's Applied Science and Technology Project Office (ASTPO) has developed. The DRIFTER floating sensor module is equipped with an Arduino open-source electronics prototyping platform and programming language (http://www.arduino.cc), a GPS (Global Positioning System) module with antenna, a cell phone SIM (Subscriber Identity Module) card and a cellular antenna which is used to transmit data, and a probe to measure temperature and conductivity (from which salinity can be derived). The DRIFTER is powered by a solar cell panel and all the electronic components are mounted and sealed in [ waterproof encasement. Position and measurement data are transmitted via short message service (SMS) messaging to a Twitter site (DRIFTER 002@NASADRIFTER_002 and DRIFTER 004@NASADRIFTER_004), which provides a live feed. These data are the imported into a Google spreadsheet where conductivity is converted to salinity, and graphed in real-time. The spreadsheet data will be imported into a webpage maintained by ASTPO, where it will be displayed available for dO\\\\1lload.

Comparison of simple additive weighting (SAW) and composite performance index (CPI) methods in employee remuneration determination

NASA Astrophysics Data System (ADS)

Karlitasari, L.; Suhartini, D.; Benny

2017-01-01

The process of determining the employee remuneration for PT Sepatu Mas Idaman currently are still using Microsoft Excel-based spreadsheet where in the spreadsheet there is the value of criterias that must be calculated for every employee. This can give the effect of doubt during the assesment process, therefore resulting in the process to take much longer time. The process of employee remuneration determination is conducted by the assesment team based on some criterias that have been predetermined. The criteria used in the assessment process are namely the ability to work, human relations, job responsibility, discipline, creativity, work, achievement of targets, and absence. To ease the determination of employee remuneration to be more efficient and effective, the Simple Additive Weighting (SAW) method is used. SAW method can help in decision making for a certain case, and the calculation that generates the greatest value will be chosen as the best alternative. Other than SAW, also by using another method was the CPI method which is one of the calculating method in decision making based on performance index. Where SAW method was more faster by 89-93% compared to CPI method. Therefore it is expected that this application can be an evaluation material for the need of training and development for employee performances to be more optimal.

A review of malaria vaccine clinical projects based on the WHO rainbow table

PubMed Central

2012-01-01

Development and Phase 3 testing of the most advanced malaria vaccine, RTS,S/AS01, indicates that malaria vaccine R&D is moving into a new phase. Field trials of several research malaria vaccines have also confirmed that it is possible to impact the host-parasite relationship through vaccine-induced immune responses to multiple antigenic targets using different platforms. Other approaches have been appropriately tested but turned out to be disappointing after clinical evaluation. As the malaria community considers the potential role of a first-generation malaria vaccine in malaria control efforts, it is an apposite time to carefully document terminated and ongoing malaria vaccine research projects so that lessons learned can be applied to increase the chances of success for second-generation malaria vaccines over the next 10 years. The most comprehensive resource of malaria vaccine projects is a spreadsheet compiled by WHO thanks to the input from funding agencies, sponsors and investigators worldwide. This spreadsheet, available from WHO's website, is known as "the rainbow table". By summarizing the published and some unpublished information available for each project on the rainbow table, the most comprehensive review of malaria vaccine projects to be published in the last several years is provided below. PMID:22230255

Awareness and Use of Surgical Checklist among Theatre Users at Ekiti State University Teaching Hospital, Ado-Ekiti, Nigeria.

PubMed

Ogunlusi, Johnson Dare; Yusuf, Moruf Babatunde; Ogunsuyi, Popoola Sunday; Wuraola, Obafemi K; Babalola, Waheed O; Oluwadiya, Kehinde Sunday; Ajogbasile, Oduwole Olayemi

2017-01-01

Surgical checklist was introduced by the World Health Organization to reduce the number of surgical deaths and complications. During a surgical conference on "safety in surgical practice," it was noticed that the awareness and the use of surgical checklist are poor in Nigerian hospitals. This study was aimed at determining the awareness and use of surgical checklist among the theater users in our hospital, factors militating against its implementation, and make recommendations. This is a prospective study at Ekiti State University Teaching Hospital, Ado-Ekiti; questionnaires were distributed to three groups of theater users - surgeons, anesthetists, and perioperative nurses. The responses were collated by the lead researcher, entered into Microsoft Excel spreadsheet, exported, and analyzed with SPSS. Eighty-five questionnaires were distributed, 70 were returned, and 4 were discarded due to poor filling. The studied 66 comprised 40, 12, and 14 surgeons, anesthetists, and perioperative nurses, respectively. Fifty-five (83.3%) of the responders indicated awareness of the checklist but only 12 (21.8%) correctly stated that the main objective is for patients' safety and for safe surgery. Major barriers to its use include lack of training 58.2%, lack of assertiveness of staff 58.2%, and that its delays operation list 47.2%. The study demonstrated high level of awareness of surgical checklist in our hospital; however, this awareness is based on wrong premises as it is not reflected in the true aim of the checklist. Majority of the responders would want to be trained on the use of checklist despite the highlighted barriers.

Breaking free from chemical spreadsheets.

PubMed

Segall, Matthew; Champness, Ed; Leeding, Chris; Chisholm, James; Hunt, Peter; Elliott, Alex; Garcia-Martinez, Hector; Foster, Nick; Dowling, Samuel

2015-09-01

Drug discovery scientists often consider compounds and data in terms of groups, such as chemical series, and relationships, representing similarity or structural transformations, to aid compound optimisation. This is often supported by chemoinformatics algorithms, for example clustering and matched molecular pair analysis. However, chemistry software packages commonly present these data as spreadsheets or form views that make it hard to find relevant patterns or compare related compounds conveniently. Here, we review common data visualisation and analysis methods used to extract information from chemistry data. We introduce a new framework that enables scientists to work flexibly with drug discovery data to reflect their thought processes and interact with the output of algorithms to identify key structure-activity relationships and guide further optimisation intuitively. Copyright © 2015 Elsevier Ltd. All rights reserved.

MEMS product engineering: methodology and tools

NASA Astrophysics Data System (ADS)

Ortloff, Dirk; Popp, Jens; Schmidt, Thilo; Hahn, Kai; Mielke, Matthias; Brück, Rainer

2011-03-01

The development of MEMS comprises the structural design as well as the definition of an appropriate manufacturing process. Technology constraints have a considerable impact on the device design and vice-versa. Product design and technology development are therefore concurrent tasks. Based on a comprehensive methodology the authors introduce a software environment that links commercial design tools from both area into a common design flow. In this paper emphasis is put on automatic low threshold data acquisition. The intention is to collect and categorize development data for further developments with minimum overhead and minimum disturbance of established business processes. As a first step software tools that automatically extract data from spreadsheets or file-systems and put them in context with existing information are presented. The developments are currently carried out in a European research project.

Airport GSE Model Directions

EPA Pesticide Factsheets

User manual for the GSEModel which is a spreadsheet analysis tool for quantifying emission benefits and calculating the cost-effectiveness of converting to cleaner-burning fuels and engine technologies.

Analysis, prediction, and case studies of early-age cracking in bridge decks

NASA Astrophysics Data System (ADS)

ElSafty, Adel; Graeff, Matthew K.; El-Gharib, Georges; Abdel-Mohti, Ahmed; Mike Jackson, N.

2016-06-01

Early-age cracking can adversely affect strength, serviceability, and durability of concrete bridge decks. Early age is defined as the period after final setting, during which concrete properties change rapidly. Many factors can cause early-age bridge deck cracking including temperature change, hydration, plastic shrinkage, autogenous shrinkage, and drying shrinkage. The cracking may also increase the effect of freeze and thaw cycles and may lead to corrosion of reinforcement. This research paper presents an analysis of causes and factors affecting early-age cracking. It also provides a tool developed to predict the likelihood and initiation of early-age cracking of concrete bridge decks. Understanding the concrete properties is essential so that the developed tool can accurately model the mechanisms contributing to the cracking of concrete bridge decks. The user interface of the implemented computer Excel program enables the user to input the properties of the concrete being monitored. The research study and the developed spreadsheet were used to comprehensively investigate the issue of concrete deck cracking. The spreadsheet is designed to be a user-friendly calculation tool for concrete mixture proportioning, temperature prediction, thermal analysis, and tensile cracking prediction. The study also provides review and makes recommendations on the deck cracking based mainly on the Florida Department of Transportation specifications and Structures Design Guidelines, and Bridge Design Manuals of other states. The results were also compared with that of other commercially available software programs that predict early-age cracking in concrete slabs, concrete pavement, and reinforced concrete bridge decks. The outcome of this study can identify a set of recommendations to limit the deck cracking problem and maintain a longer service life of bridges.

Deconstruction Rapid Assessment Tool

EPA Pesticide Factsheets

Deconstruction Rapid Assessment Tool (EPA 905-F-15-001) instructions, form and spreadsheet for assessing and triaging structures being considered for deconstruction. Promote environmental stewardship and economic revitalization through deconstruction.

Cost-engineering modeling to support rapid concept development of an advanced infrared satellite system

NASA Astrophysics Data System (ADS)

Bell, Kevin D.; Dafesh, Philip A.; Hsu, L. A.; Tsuda, A. S.

1995-12-01

Current architectural and design trade techniques often carry unaffordable alternatives late into the decision process. Early decisions made during the concept exploration and development (CE&D) phase will drive the cost of a program more than any other phase of development; thus, designers must be able to assess both the performance and cost impacts of their early choices. The Space Based Infrared System (SBIRS) cost engineering model (CEM) described in this paper is an end-to-end process integrating engineering and cost expertise through commonly available spreadsheet software, allowing for concurrent design engineering and cost estimation to identify and balance system drives to reduce acquisition costs. The automated interconnectivity between subsystem models using spreadsheet software allows for the quick and consistent assessment of the system design impacts and relative cost impacts due to requirement changes. It is different from most CEM efforts attempted in the past as it incorporates more detailed spacecraft and sensor payload models, and has been applied to determine the cost drivers for an advanced infrared satellite system acquisition. The CEM is comprised of integrated detailed engineering and cost estimating relationships describing performance, design, and cost parameters. Detailed models have been developed to evaluate design parameters for the spacecraft bus and sensor; both step-starer and scanner sensor types incorporate models of focal plane array, optics, processing, thermal, communications, and mission performance. The current CEM effort has provided visibility to requirements, design, and cost drivers for system architects and decision makers to determine the configuration of an infrared satellite architecture that meets essential requirements cost effectively. In general, the methodology described in this paper consists of process building blocks that can be tailored to the needs of many applications. Descriptions of the spacecraft and payload subsystem models provide insight into The Aerospace Corporation expertise and scope of the SBIRS concept development effort.

Beginning secondary science teachers' instructional use of educational technology during the induction year

NASA Astrophysics Data System (ADS)

McNall, Rebecca Lee

This study explored how 10 beginning secondary science teachers who had completed the newly revised technology-integrated science teacher education program at the University of Virginia used educational technology in their science instruction during the induction year. Nine of the beginning teachers taught in Virginia or Maryland high schools, while one taught overseas in an international school. Participants taught biology, earth science, chemistry, physics, or general science. A revised version of the Technology Usage and Needs of Science Teachers survey (Pedersen & Yerrick, 2000) was administered to all 10 participants in early fall 2002 and late spring 2003 to assess their confidence using educational technology tools in teaching science. Follow-up interviews were conducted with all participants subsequent to survey administration to explore their views toward educational technology as an instructional tool, their use of educational technology in science instruction, and factors influencing their use. In addition, four participants were purposefully selected to characterize participants' instructional use of educational technology and to increase the likelihood of observing its use. Selection criteria of this subgroup included factors summarized from the research literature: (a) high confidence using educational technology, (b) strong intent to use educational technology instructionally, (c) access to technology tools, and (d) collegial or technology support. Survey responses were analyzed using descriptive statistics, and interview and classroom observation data were analyzed using analytic induction methods developed by Erickson (1986). Analysis of survey responses indicated that participants were confident using educational technology tools in science instruction and were most confident using word processing, spreadsheets, PowerPoint, and telecommunications applications. Classroom observations and interview responses indicated that participants used educational technology to provide visual representations of science concepts, support authentic science explorations and inquiry, and create real-world connections to science content. Limited access to educational technology resources, unfamiliarity with the curriculum, and limited time were factors limiting their use. While participants used educational technology less than they had originally intended, they continued to believe educational technology was a potentially powerful tool for teaching science and planned to continue to explore ways of incorporating it in their science instruction.

Scenario Evaluator for Electrical Resistivity survey pre-modeling tool

USGS Publications Warehouse

Terry, Neil; Day-Lewis, Frederick D.; Robinson, Judith L.; Slater, Lee D.; Halford, Keith J.; Binley, Andrew; Lane, John W.; Werkema, Dale D.

2017-01-01

Geophysical tools have much to offer users in environmental, water resource, and geotechnical fields; however, techniques such as electrical resistivity imaging (ERI) are often oversold and/or overinterpreted due to a lack of understanding of the limitations of the techniques, such as the appropriate depth intervals or resolution of the methods. The relationship between ERI data and resistivity is nonlinear; therefore, these limitations depend on site conditions and survey design and are best assessed through forward and inverse modeling exercises prior to field investigations. In this approach, proposed field surveys are first numerically simulated given the expected electrical properties of the site, and the resulting hypothetical data are then analyzed using inverse models. Performing ERI forward/inverse modeling, however, requires substantial expertise and can take many hours to implement. We present a new spreadsheet-based tool, the Scenario Evaluator for Electrical Resistivity (SEER), which features a graphical user interface that allows users to manipulate a resistivity model and instantly view how that model would likely be interpreted by an ERI survey. The SEER tool is intended for use by those who wish to determine the value of including ERI to achieve project goals, and is designed to have broad utility in industry, teaching, and research.

AQUATOX Features and Tools

EPA Pesticide Factsheets

Numerous features have been included to facilitate the modeling process, from model setup and data input, presentation and analysis of results, to easy export of results to spreadsheet programs for additional analysis.

Livestock Anaerobic Digester Database

EPA Pesticide Factsheets

The Anaerobic Digester Database provides basic information about anaerobic digesters on livestock farms in the United States, organized in Excel spreadsheets. It includes projects that are under construction, operating, or shut down.

76 FR 70517 - Proposed Collection; Comment Request

Federal Register 2010, 2011, 2012, 2013, 2014

2011-11-14

... requested. These systems generally also provide analytics, spreadsheets, and other tools designed to enable funds to analyze the data presented, as well as communication tools to process fund instructions...

Science Notes.

ERIC Educational Resources Information Center

School Science Review, 1990

1990-01-01

Presented are 29 science activities for secondary school science instruction. Topic areas include botany, genetics, biochemistry, anatomy, entomology, molecular structure, spreadsheets, chemistry, mechanics, astronomy, relativity, aeronautics, instrumentation, electrostatics, quantum mechanics, and laboratory interfacing. (CW)

Compilation of Physicochemical and Toxicological Information ...

EPA Pesticide Factsheets

The purpose of this product is to make accessible the information about the 1,173 hydraulic fracturing-related chemicals that were listed in the external review draft of the Hydraulic Fracturing Drinking Water Assessment that was released recently. The product consists of a series of spreadsheets with physicochemical and toxicological information pulled from several sources of information, including: EPI Suite, LeadScope, QikiProp, Reaxys, IRIS, PPRTV, ATSDR, among other sources. The spreadsheets also contain background information about how the list of chemicals were compiled, what the different sources of chemical information are, and definitions and descriptions of the values presented. The purpose of this product is to compile and make accessible information about the 1,173 hydraulic fracturing-related chemicals listed in the external review draft of the Hydraulic Fracturing Drinking Water Assessment.

Spreadsheet analysis of stability and meta-stability of low-dimensional magnetic particles using the Ising approach

NASA Astrophysics Data System (ADS)

Ehrmann, Andrea; Blachowicz, Tomasz; Zghidi, Hafed

2015-05-01

Modelling hysteresis behaviour, as it can be found in a broad variety of dynamical systems, can be performed in different ways. An elementary approach, applied for a set of elementary cells, which uses only two possible states per cell, is the Ising model. While such Ising models allow for a simulation of many systems with sufficient accuracy, they nevertheless depict some typical features which must be taken into account with proper care, such as meta-stability or the externally applied field sweeping speed. This paper gives a general overview of recent results from Ising models from the perspective of a didactic model, based on a 2D spreadsheet analysis, which can be used also for solving general scientific problems where direct next-neighbour interactions take place.

Spreadsheet-based program for alignment of overlapping DNA sequences.

PubMed

Anbazhagan, R; Gabrielson, E

1999-06-01

Molecular biology laboratories frequently face the challenge of aligning small overlapping DNA sequences derived from a long DNA segment. Here, we present a short program that can be used to adapt Excel spreadsheets as a tool for aligning DNA sequences, regardless of their orientation. The program runs on any Windows or Macintosh operating system computer with Excel 97 or Excel 98. The program is available for use as an Excel file, which can be downloaded from the BioTechniques Web site. Upon execution, the program opens a specially designed customized workbook and is capable of identifying overlapping regions between two sequence fragments and displaying the sequence alignment. It also performs a number of specialized functions such as recognition of restriction enzyme cutting sites and CpG island mapping without costly specialized software.

SynapticDB, effective web-based management and sharing of data from serial section electron microscopy.

PubMed

Shi, Bitao; Bourne, Jennifer; Harris, Kristen M

2011-03-01

Serial section electron microscopy (ssEM) is rapidly expanding as a primary tool to investigate synaptic circuitry and plasticity. The ultrastructural images collected through ssEM are content rich and their comprehensive analysis is beyond the capacity of an individual laboratory. Hence, sharing ultrastructural data is becoming crucial to visualize, analyze, and discover the structural basis of synaptic circuitry and function in the brain. We devised a web-based management system called SynapticDB (http://synapses.clm.utexas.edu/synapticdb/) that catalogues, extracts, analyzes, and shares experimental data from ssEM. The management strategy involves a library with check-in, checkout and experimental tracking mechanisms. We developed a series of spreadsheet templates (MS Excel, Open Office spreadsheet, etc) that guide users in methods of data collection, structural identification, and quantitative analysis through ssEM. SynapticDB provides flexible access to complete templates, or to individual columns with instructional headers that can be selected to create user-defined templates. New templates can also be generated and uploaded. Research progress is tracked via experimental note management and dynamic PDF forms that allow new investigators to follow standard protocols and experienced researchers to expand the range of data collected and shared. The combined use of templates and tracking notes ensures that the supporting experimental information is populated into the database and associated with the appropriate ssEM images and analyses. We anticipate that SynapticDB will serve future meta-analyses towards new discoveries about the composition and circuitry of neurons and glia, and new understanding about structural plasticity during development, behavior, learning, memory, and neuropathology.

Screening tool to evaluate the vulnerability of down-gradient receptors to groundwater contaminants from uncapped landfills

DOE Office of Scientific and Technical Information (OSTI.GOV)

Baker, Ronald J.; Reilly, Timothy J.; Lopez, Anthony

2015-09-15

Highlights: • A spreadsheet-based risk screening tool for groundwater affected by landfills is presented. • Domenico solute transport equations are used to estimate downgradient contaminant concentrations. • Landfills are categorized as presenting high, moderate or low risks. • Analysis of parameter sensitivity and examples of the method’s application are given. • The method has value to regulators and those considering redeveloping closed landfills. - Abstract: A screening tool for quantifying levels of concern for contaminants detected in monitoring wells on or near landfills to down-gradient receptors (streams, wetlands and residential lots) was developed and evaluated. The tool uses Quick Domenicomore » Multi-scenario (QDM), a spreadsheet implementation of Domenico-based solute transport, to estimate concentrations of contaminants reaching receptors under steady-state conditions from a constant-strength source. Unlike most other available Domenico-based model applications, QDM calculates the time for down-gradient contaminant concentrations to approach steady state and appropriate dispersivity values, and allows for up to fifty simulations on a single spreadsheet. Sensitivity of QDM solutions to critical model parameters was quantified. The screening tool uses QDM results to categorize landfills as having high, moderate and low levels of concern, based on contaminant concentrations reaching receptors relative to regulatory concentrations. The application of this tool was demonstrated by assessing levels of concern (as defined by the New Jersey Pinelands Commission) for thirty closed, uncapped landfills in the New Jersey Pinelands National Reserve, using historic water-quality data from monitoring wells on and near landfills and hydraulic parameters from regional flow models. Twelve of these landfills are categorized as having high levels of concern, indicating a need for further assessment. This tool is not a replacement for conventional numerically-based transport model or other available Domenico-based applications, but is suitable for quickly assessing the level of concern posed by a landfill or other contaminant point source before expensive and lengthy monitoring or remediation measures are taken. In addition to quantifying the level of concern using historic groundwater-monitoring data, the tool allows for archiving model scenarios and adding refinements as new data become available.« less

Tritium permeation model for plasma facing components

NASA Astrophysics Data System (ADS)

Longhurst, G. R.

1992-12-01

This report documents the development of a simplified one-dimensional tritium permeation and retention model. The model makes use of the same physical mechanisms as more sophisticated, time-transient codes such as implantation, recombination, diffusion, trapping and thermal gradient effects. It takes advantage of a number of simplifications and approximations to solve the steady-state problem and then provides interpolating functions to make estimates of intermediate states based on the steady-state solution. The model is developed for solution using commercial spread-sheet software such as Lotus 123. Comparison calculations are provided with the verified and validated TMAP4 transient code with good agreement. Results of calculations for the ITER CDA diverter are also included.

Utah FORGE Groundwater Data

DOE Data Explorer

Joe Moore

2016-07-20

This submission includes two modelled drawdown scenarios with new supply well locations, a total dissolved solids (TDS) concentration grid (raster dataset representing the spatial distribution of TDS), and an excel spreadsheet containing well data.

Wet Labs, Computers, and Spreadsheets.

ERIC Educational Resources Information Center

Durham, Bill

1990-01-01

Described are some commonly encountered chemistry experiments that have been modified for computerized data acquisition. Included are exercises in radioactivity, titration, calorimetry, kinetics, and electrochemistry. Software considerations and laboratory procedures are discussed. (CW)

The Computer Bulletin Board.

ERIC Educational Resources Information Center

Batt, Russell H., Ed.

1990-01-01

Described is how spreadsheet and problem solver microcomputer programs may assist students in performing mathematical calculations. Discussed is the application of the equation solver "MathCAD" to various areas in the undergraduate curriculum. (KR)

Bibliography. Computer-Oriented Projects, 1987.

ERIC Educational Resources Information Center

Smith, Richard L., Comp.

1988-01-01

Provides an annotated list of references on computer-oriented projects. Includes information on computers; hands-on versus simulations; games; instruction; students' attitudes and learning styles; artificial intelligence; tutoring; and application of spreadsheets. (RT)

2008 rural national transit database

DOT National Transportation Integrated Search

2008-01-01

This spreadsheet includes the following data from the 2008 Rural National Transit Database: : > Sub-Recipient Information : > Service Data : > Revenue Vehicle Inventory : > Counties Served : Each one of the categories above are in worksheets within t...

Electronics Environmental Benefits Calculator

EPA Pesticide Factsheets

The Electronics Environmental Benefits Calculator (EEBC) was developed to assist organizations in estimating the environmental benefits of greening their purchase, use and disposal of electronics.The EEBC estimates the environmental and economic benefits of: Purchasing Electronic Product Environmental Assessment Tool (EPEAT)-registered products; Enabling power management features on computers and monitors above default percentages; Extending the life of equipment beyond baseline values; Reusing computers, monitors and cell phones; and Recycling computers, monitors, cell phones and loads of mixed electronic products.The EEBC may be downloaded as a Microsoft Excel spreadsheet.See https://www.federalelectronicschallenge.net/resources/bencalc.htm for more details.

Software For Design And Analysis Of Tanks And Cylindrical Shells

NASA Technical Reports Server (NTRS)

Luz, Paul L.; Graham, Jerry B.

1995-01-01

Skin-stringer Tank Analysis Spreadsheet System (STASS) computer program developed for use as preliminary design software tool that enables quick-turnaround design and analysis of structural domes and cylindrical barrel sections in propellant tanks or other cylindrical shells. Determines minimum required skin thicknesses for domes and cylindrical shells to withstand material failure due to applied pressures (ullage and/or hydrostatic) and runs buckling analyses on cylindrical shells and skin-stringers. Implemented as workbook program, using Microsoft Excel v4.0 on Macintosh II. Also implemented using Microsoft Excel v4.0 for Microsoft Windows v3.1 IBM PC.

Screening and Spectral Summing of LANL Empty Waste Drums - 13226

DOE Office of Scientific and Technical Information (OSTI.GOV)

Gruetzmacher, Kathleen M.; Bustos, Roland M.; Ferran, Scott G.

2013-07-01

Empty 55-gallon drums that formerly held transuranic (TRU) waste (often over-packed in 85- gallon drums) are generated at LANL and require radiological characterization for disposition. These drums are typically measured and analyzed individually using high purity germanium (HPGe) gamma detectors. This approach can be resource and time intensive. For a project requiring several hundred drums to be characterized in a short time frame, an alternative approach was developed. The approach utilizes a combination of field screening and spectral summing that was required to be technically defensible and meet the Nevada Nuclear Security Site (NNSS) Waste Acceptance Criteria (WAC). In themore » screening phase of the operation, the drums were counted for 300 seconds (compared to 600 seconds for the typical approach) and checked against Low Level (LL)/TRU thresholds established for each drum configuration and detector. Multiple TRU nuclides and multiple gamma rays for each nuclide were evaluated using an automated spreadsheet utility that can process data from up to 42 drums at a time. Screening results were reviewed by an expert analyst to confirm the field LL/TRU determination. The spectral summing analysis technique combines spectral data (channel-by-channel) associated with a group of individual waste containers producing a composite spectrum. The grouped drums must meet specific similarity criteria. Another automated spreadsheet utility was used to spectral sum data from an unlimited number of similar drums grouped together. The composite spectrum represents a virtual combined drum for the group of drums and was analyzed using the SNAP{sup TM}/Radioassay Data Sheet (RDS)/Batch Data Report (BDR) method. The activity results for a composite virtual drum were divided equally amongst the individual drums to generate characterization results for each individual drum in the group. An initial batch of approximately 500 drums were measured and analyzed in less than 2 months in 2011. A second batch of approximately 500 more drums were measured and analyzed during the following 2 1/2 months. Four different HPGe detectors were employed for the operation. The screening and spectral summing approach can reduce the overall measurement and analysis time required. However, developing the technical details and automation spreadsheets requires a significant amount of expert time prior to beginning field operations and must be considered in the overall project schedule. This approach has continued to be used for characterizing several hundred more empty drums in 2012 and is planned to continue in 2013. (authors)« less

ARS-Media for excel instruction manual

USDA-ARS?s Scientific Manuscript database

ARS-Media for Excel Instruction Manual is the instruction manual that explains how to use the Excel spreadsheet ARS-Media for Excel application. ARS-Media for Excel Instruction Manual is provided as a pdf file....

User's Guide for Evaluating Subsurface Vapor Intrusion into Buildings

EPA Pesticide Factsheets

This revised version of the User's Guide corresponds with the release of Version 3.1 of the Johnson and Ettinger (1991) model (J E) spreadsheets for estimating subsurface vapor intrusion into buildings.

KCBX Air Monitoring Data - February 2014

EPA Pesticide Factsheets

KCBX submitted spreadsheets of heavy metal amounts, PM10 concentration, carbon measurements, and continuous monitor data from its petroleum coke (pet coke) facilities in Chicago, Illinois, per EPA's Clean Air Act Section 114 request.

NREL: SMARTS - About SMARTS

Science.gov Websites

its references list. To use SMARTS, users construct text files of 20-30 lines of simple text and ' output consists of spreadsheet-compatible American Standard Code for Information Interchange (ASCII) text

Microcomputer Scheduling of Reference Desk Staff.

ERIC Educational Resources Information Center

Cornick, Donna; Owen, Willy

1988-01-01

Presents a model that can accommodate staff preferences when determining a reference desk schedule using a microcomputer, the Lotus 1-2-3 spreadsheet software, and the linear programing software LP83. (eight references) (MES)

Rare Earth Geochemistry of Rock Core form WY Reservoirs

DOE Data Explorer

Quillinan, Scott; Bagdonnas, Davin; McLaughlin, J. Fred; Nye, Charles

2016-10-01

These data include major, minor, trace and rare earth element concentration of geologic formations in Wyoming oil and gas fields. *Note - Link below contains updated version of spreadsheet (6/14/2017)

Technology Tips

ERIC Educational Resources Information Center

Hollebrands, Karen Flanagan

2004-01-01

Directions for using a function called Mail Merge in Microsoft Office are mentioned. Using a spreadsheet and mail merge, allows one to create different assessments, complete with worked solutions, generate them on demand or save them for later use.

Causes of 30-day bariatric surgery mortality: with emphasis on bypass obstruction.

PubMed

Mason, Edward E; Renquist, Kathleen E; Huang, Yu-Hui; Jamal, Mohammad; Samuel, Isaac

2007-01-01

This is a study of the causes of 30-day postoperative death following surgical treatment for obesity and a search for ways to decrease an already low mortality rate. Data were contributed from 1986-2004 to the International Bariatric Surgery Registry by 85 sites, representing 137 surgeons. A spread-sheet was prepared with rows for causes and columns for patients. The 251 causes contributing to 93 deaths were then marked in cells wherever a patient was noted to have one of the causes. Rows and columns were then moved into positions that provided patterns of best fit. 11 patterns were found. 10 had well known initiating causes of death. Overall operative 30-day mortality was 0.24% (93 / 38,501). The most common cause of death was pulmonary embolism (32%, 30/93). 14 deaths were caused by leaks (15%, 14/93), and were equally prevalent after simple (15%, 2/14) or complex (15%, 12/79) operations. Small bowel obstruction caused 8 deaths, exclusively after complex operations. 5 of these involved the bypassed biliopancreatic limb and were defined as "bypass obstruction". A spread-sheet study of cause of 30-day postoperative death revealed a rapidly lethal initiating complication of Roux-en-Y gastric bypass obstruction that requires the earliest possible recognition and treatment. Bypass obstruction needs a name and code to facilitate recognition, study, prevention and early treatment. Spread-sheet pattern analysis of all available data helped identify the initiating cause of death for individual patients when multiple data elements were present.

Optimization of replacement and inspection decisions for multiple components on a power system

DOE Office of Scientific and Technical Information (OSTI.GOV)

Mauney, D.A.

1994-12-31

The use of optimization on the rescheduling of replacement dates provided a very proactive approach to deciding when components on individual units need to be addressed with a run/repair/replace decision. Including the effects of time value of money and taxes and unit need inside the spreadsheet model allowed the decision maker to concentrate on the effects of engineering input and replacement date decisions on the final net present value (NPV). The personal computer (PC)-based model was applied to a group of 140 forced outage critical fossil plant tube components across a power system. The estimated resulting NPV of the optimizationmore » was in the tens of millions of dollars. This PC spreadsheet model allows the interaction of inputs from structural reliability risk assessment models, plant foreman interviews, and actual failure history on a by component by unit basis across a complete power production system. This model includes not only the forced outage performance of these components caused by tube failures but, in addition, the forecasted need of the individual units on the power system and the expected cost of their replacement power if forced off line. The use of cash flow analysis techniques in the spreadsheet model results in the calculation of an NPV for a whole combination of replacement dates. This allows rapid assessments of {open_quotes}what if{close_quotes} scenarios of major maintenance projects on a systemwide basis and not just on a unit-by-unit basis.« less

Ladtap XL Version 2017: A Spreadsheet For Estimating Dose Resulting From Aqueous Releases

DOE Office of Scientific and Technical Information (OSTI.GOV)

Minter, K.; Jannik, T.

LADTAP XL© is an EXCEL© spreadsheet used to estimate dose to offsite individuals and populations resulting from routine and accidental releases of radioactive materials to the Savannah River. LADTAP XL© contains two worksheets: LADTAP and IRRIDOSE. The LADTAP worksheet estimates dose for environmental pathways including external exposure resulting from recreational activities on the Savannah River and internal exposure resulting from ingestion of water, fish, and invertebrates originating from the Savannah River. IRRIDOSE estimates offsite dose to individuals and populations from irrigation of foodstuffs with contaminated water from the Savannah River. In 2004, a complete description of the LADTAP XL© codemore » and an associated user’s manual was documented in LADTAP XL©: A Spreadsheet for Estimating Dose Resulting from Aqueous Release (WSRC-TR-2004-00059) and revised input parameters, dose coefficients, and radionuclide decay constants were incorporated into LADTAP XL© Version 2013 (SRNL-STI-2011-00238). LADTAP XL© Version 2017 is a slight modification to Version 2013 with minor changes made for more user-friendly parameter inputs and organization, updates in the time conversion factors used within the dose calculations, and fixed an issue with the expected time build-up parameter referenced within the population shoreline dose calculations. This manual has been produced to update the code description, verification of the models, and provide an updated user’s manual. LADTAP XL© Version 2017 has been verified by Minter (2017) and is ready for use at the Savannah River Site (SRS).« less

User interface support

NASA Technical Reports Server (NTRS)

Lewis, Clayton; Wilde, Nick

1989-01-01

Space construction will require heavy investment in the development of a wide variety of user interfaces for the computer-based tools that will be involved at every stage of construction operations. Using today's technology, user interface development is very expensive for two reasons: (1) specialized and scarce programming skills are required to implement the necessary graphical representations and complex control regimes for high-quality interfaces; (2) iteration on prototypes is required to meet user and task requirements, since these are difficult to anticipate with current (and foreseeable) design knowledge. We are attacking this problem by building a user interface development tool based on extensions to the spreadsheet model of computation. The tool provides high-level support for graphical user interfaces and permits dynamic modification of interfaces, without requiring conventional programming concepts and skills.

Primer for Using RE-Powering Data to Screen Sites for Renewable Energy Potential

EPA Pesticide Factsheets

This reference guide provides users with tips for using the RE-Powering Screening Dataset spreadsheet, which contains detailed site information on over 60,000 contaminated lands, landfills, and mine sites.

Two Car-Buying Strategies: An Old Problem Revisited with a New Analysis.

ERIC Educational Resources Information Center

Sen, Tapan; And Others

1996-01-01

Demonstrates the application of spreadsheet analysis in solving equations beyond quadratics. Considers the costs of interest, gasoline, and maintenance in deciding how long it pays to keep a car. (MKR)

Biogas Upgrading and Waste-to-Energy | Bioenergy | NREL

Science.gov Websites

dots. Waste Feedstocks We inventory WTE feedstocks-waste fat, oil, and greases; municipal solid wastes " and points right to an icon of an Excel spreadsheet labeled "Equipment and Raw Material

Lab Analyses of Fenceline PM10 Air Filters

EPA Pesticide Factsheets

These spreadsheets show the analytical data on PM10 concentration, organic carbon, elemental carbon, and several trace metals at KCBX petroleum coke (also known as pet coke or petcoke) storage terminals in Chicago, Illinois.

Rare Earth Element Geochemistry for Produced Waters, WY

DOE Data Explorer

Quillinan, Scott; Nye, Charles; McLing, Travis; Neupane, Hari

2016-06-30

These data represent major, minor, trace, isotopes, and rare earth element concentrations in geologic formations and water associated with oil and gas production. *Note - Link below contains updated version of spreadsheet (6/14/2017)

Office Computer Software: A Comprehensive Review of Software Programs.

ERIC Educational Resources Information Center

Secretary, 1992

1992-01-01

Describes types of software including system software, application software, spreadsheets, accounting software, graphics packages, desktop publishing software, database, desktop and personal information management software, project and records management software, groupware, and shareware. (JOW)

Science Notes.

ERIC Educational Resources Information Center

Talbot, Chris; And Others

1991-01-01

Twenty science experiments are presented. Topics include recombinant DNA, physiology, nucleophiles, reactivity series, molar volume of gases, spreadsheets in chemistry, hydrogen bonding, composite materials, radioactive decay, magnetism, speed, charged particles, compression waves, heat transfer, Ursa Major, balloons, current, and expansion of…

Mobile Building Energy Audit and Modeling Tools: Cooperative Research and Development Final Report, CRADA Number CRD-11-00441

DOE Office of Scientific and Technical Information (OSTI.GOV)

Brackney, L.

Broadly accessible, low cost, accurate, and easy-to-use energy auditing tools remain out of reach for managers of the aging U.S. building population (over 80% of U.S. commercial buildings are more than 10 years old*). concept3D and NREL's commercial buildings group will work to translate and extend NREL's existing spreadsheet-based energy auditing tool for a browser-friendly and mobile-computing platform. NREL will also work with concept3D to further develop a prototype geometry capture and materials inference tool operable on a smart phone/pad platform. These tools will be developed to interoperate with NREL's Building Component Library and OpenStudio energy modeling platforms, and willmore » be marketed by concept3D to commercial developers, academic institutions and governmental agencies. concept3D is NREL's lead developer and subcontractor of the Building Component Library.« less

A method for assessment of standards of care of anesthesia services in departments with different levels of resources.

PubMed

Montasser, A M

1998-12-01

In developing countries the standards of anesthesia care vary greatly between hospitals. In order to identify the urgent needs of disadvantaged hospitals, we compared three index hospitals in the greater Cairo area, one of which has excellent (category I), on intermediate (category II), and one with severely restricted resources (category III). Standards of care published by the American Society of Anesthesiologists (ASA) were used to develop a spreadsheet for documenting features of pre-, intra- and post-anesthetic care in patients undergoing tonsillectomies, a procedure commonly performed in all three hospitals. The spreadsheet enabled us to document all equipment, supplies and personnel engaged from pre-anesthetic evaluation to discharge. Analysis of the data revealed that the service provided by the category I hospital approached the ASA standards. In the category II hospital the patients did not go through a pre-anesthetic evaluation; instead they were seen for the first time in the operating room. No premedication was given. Intravenous access was established with the help of a needle (rather than a catheter). Monitoring consisted occasionally of a finger on the pulse. Sterilization was accomplished by boiling. Air-conditioning was not available. No records were kept and no recovery room was available. The same deficiencies existed in the category III hospital, which did not even have oropharyngeal airways, antiarrhythmic or inotropic medications, and sterile techniques were completely ignored. Despite these stark differences in care, the patients or their parents in all three hospitals appeared satisfied with the level of care they received. Much has to be done to improve anesthesia care in less fortunate departments in developing nations. Urgent help does not mean the need for sophisticated monitors or equipment only, but the establishment of practice standards first. Applying the priciples of modern management, we need to evaluate the structure, processes and outcome of anesthetic practice in developing countries in order to reengineer the way we provide help to anesthetic departments in developing nations. In this modest study we are presenting a means to evaluate the features and processes of the anesthesia services in developing countries.

Interchange Safety Analysis Tool (ISAT) : user manual

DOT National Transportation Integrated Search

2007-06-01

This User Manual describes the usage and operation of the spreadsheet-based Interchange Safety Analysis Tool (ISAT). ISAT provides design and safety engineers with an automated tool for assessing the safety effects of geometric design and traffic con...

39 CFR 3050.22 - Documentation supporting attributable cost estimates in the Postal Service's section 3652 report.

Code of Federal Regulations, 2010 CFR

2010-07-01

..., Demand Side Variability, and Network Variability studies, including input data, processing programs, and... should include the product or product groups carried under each listed contract; (k) Spreadsheets and...

A Spreadsheet for Estimating Soil Water Characteristic Curves (SWCC)

DTIC Science & Technology

2017-05-01

Federal Highway Admin- istration (FHWA), was designed to simulate the behavior of pavement and subgrade materials over several years of operation. The...Guide for mechanistic- empirical design of new and rehabilitated pavement structures. TRB-NCHRP

Microhole Tubing Bending Report

DOE Data Explorer

Oglesby, Ken

2012-01-01

A downhole tubing bending study was made and is reported herein. IT contains a report and 2 excel spreadsheets to calculate tubing bending and to estimate contact points of the tubing to the drilled hole wall (creating a new support point).