Hands-Off Spreadsheets
This addresses the issue of costly and error-prone spreadsheet operations for businesses relying on highly paid staff.
The paper tackles the problem of human error and inefficiency in manually operated spreadsheets by applying a method to improve reliability and efficiency, reporting on its practical implementation.
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 is 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.