i-nth logo

Authors

Guy G. Gable, C. S. Yap, & M. N. Eng

Abstract

Spreadsheet software is one of the most extensively used software packages in many organizations. However, the development and use of spreadsheet applications in organizations is ill understood.

This research is a case study of investment in, criticality of, and control over spreadsheet applications in a medium-sized contract construction company in Singapore. Using a spreadsheet based questionnaire, data were collected from 40 spreadsheet application developers and users on 402 spreadsheet applications.

The results indicate that while the investment in spreadsheet applications is substantial, neither management nor individual employees appreciate the significance of this investment. Both the organization and individual employees are highly dependent upon many spreadsheet applications, and though the general awareness of this dependence is high, little control is exercised at either the organizational or individual employee level.

Sample

Development guidelines employed
Development guidelines employed

Half of the users do not follow any guidelines at all. Only three users had their outputs formally reviewed by someone else.

None of the users includes internal comments to describe the spreadsheet logic and functions, and none had their logic formally reviewed by someone else in the organization.

The few guidelines employed are very low level and offer no protection against application loss.

Publication

1991, 24th Hawaii International Conference on Systems Science, Number 3, pages 153-162

Full article

Spreadsheet investment, criticality, and control