Hands-Off Spreadsheets
نویسنده
چکیده
The wealth of functionality in the Excel software package means it can go beyond use as a static evaluator of predefined cell formulae, to be used actively in manipulating and transforming data. Due to human error it’s impossible to ensure a process like this is always error free, and frequently the sequence of actions is recorded only in the operator’s head. If done regularly by highly paid staff it will be expensive. This paper applies to those spreadsheets which involve significant operator intervention, describes a method that has been used to improve reliability and efficiency, and reports on how it has worked in practice.
منابع مشابه
MODFLOW 2001 and Other Modeling Odysseys Proceedings, 2001, International Ground Water Modeling Center, Colorado School of Mines, Golden, CO, p. 815-822 The Power of Spreadsheet Models
Prior to using MODFLOW, students need experience with simpler codes that provide “hands-on” experience setting up boundary and initial conditions, coding simple solution algorithms, and handling numerical errors. The best way to do this is using spreadsheet models; faculty no longer can expect students to know a common computer language, but students are familiar with spreadsheets. Many aspects...
متن کاملمقایسه میزان صدمات پرینه در کنترل پرینه با دست و بدون کاربرد دست حین زایمان
Background and purpose: Perineal lacerations are common complications of normal vaginal delivery which influence maternal health and quality of life of mothers. This study aimed at comparing perineal protection using hands on and hands off techniques on perineal lacerations during delivery. Material and Methods: This clinical trial included 600 nulliparous women who were randomly divided into ...
متن کامل2005: Combining Hands-On, Spreadsheet and Discrete Event Simulation to Teach Supply Chain Management
This paper describes the effect of combining hands-on simulation with spreadsheets and discrete event simulations. These tools enhance the student learning process of supply chain management principles. Active, hands-on learning is one of the most effective types of learning but is very time consuming. Supplementing it with computer simulation enhances the hands-on learning to cover more materi...
متن کاملAutomating Spreadsheet Discovery & Risk Assessment
There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today’s business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for ente...
متن کاملHow do Range Names Hinder Novice Spreadsheet Debugging Performance?
Although experts diverge on how best to improve spreadsheet quality, it is generally agreed that more time needs to be spent testing spreadsheets. Ideally, experienced and trained spreadsheet engineers would carry this out, but quite often this is neither practical nor possible. Many spreadsheets are a legacy, developed by staff that have since moved on, or indeed modified by many staff no long...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
- CoRR
دوره abs/1210.5262 شماره
صفحات -
تاریخ انتشار 2012