Spreadsheet bibliography

Title A comparison of spreadsheet users with different levels of experience
Authors Barry Lawson, Kenneth R. Baker, Stephen G. Powell, & Lynn Foster-Johnson
Year 2009
Type Article
Publication The International Journal of Management Science
Series Omega 37, Issue 3, June, pages 579-590

How do experienced spreadsheet users compare to inexperienced ones, and what light can this comparison shed on spreadsheet best practices?

This is the question we address in this paper, using the results from a survey of nearly 1600 respondents. This survey was completed by a wide range of spreadsheet users and focused on their significant characteristics and practices. We were interested in their training, experience, collaboration, and quality control methods.

We also examined the number of spreadsheet functions they used regularly, the manner in which they created spreadsheets, and the types of tests they used to check results. We compared two subgroups corresponding to two extremes with respect to their self-reported level of experience and skill. Each subgroup was represented by roughly 10% of the total respondents.

Our results suggest that there is a substantial difference between these groups, not only in their personal backgrounds and the corporate setting within which they work, but also in their individual spreadsheet skills and practices. We find that the most experienced subgroup exhibits many desirable characteristics and practices.

Full version Available
Also see Comparison of characteristics and practices amongst spreadsheet users with different levels of experience
Are spreadsheet audit packages used in your organization?
Are spreadsheet audit packages used in your organization?

Very few organizations use commerically available audit packages to review their spreadsheets.