{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T15:04:09Z","timestamp":1781103849770,"version":"3.54.1"},"reference-count":33,"publisher":"IGI Global Scientific Publishing","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2015,1,1]]},"abstract":"<p>Most organizations use large and complex spreadsheets that are embedded in their mission-critical processes and are used for decision-making. Identification of the various types of errors that can be present in these spreadsheets is, therefore, an important first step to creating controls that organizations can use to govern their spreadsheets. While a considerable amount of research on quantitative error taxonomies exists, there is comparatively little research concerning qualitative error taxonomies. In this paper, we propose a taxonomy for categorizing qualitative errors in spreadsheet models that offers an exploratory framework for evaluating the quality of a spreadsheet model before it is released for use by others in the organization. The classification was developed based on types of qualitative errors identified in the literature and errors committed by end-users in developing a spreadsheet model for Panko's (1996) \u201cWall Problem.\u201d A principal component analysis of the errors reveals four logical groupings thereby creating four categories of qualitative errors. The usability and limitations of the proposed taxonomy and areas for future research are discussed.<\/p>","DOI":"10.4018\/joeuc.2015010102","type":"journal-article","created":{"date-parts":[[2015,1,8]],"date-time":"2015-01-08T12:37:41Z","timestamp":1420720661000},"page":"33-56","source":"Crossref","is-referenced-by-count":3,"title":["Introducing a Taxonomy for Classifying Qualitative Spreadsheet Errors"],"prefix":"10.4018","volume":"27","author":[{"given":"Linda","family":"Leon","sequence":"first","affiliation":[{"name":"Department of Finance and Computer Information Systems, Loyola Marymount University, Los Angeles, CA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zbigniew H.","family":"Przasnyski","sequence":"additional","affiliation":[{"name":"Department of Finance and Computer Information Systems, Loyola Marymount University, Los Angeles, CA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Kala Chand","family":"Seal","sequence":"additional","affiliation":[{"name":"Department of Finance and Computer Information Systems, Loyola Marymount University, Los Angeles, CA, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"joeuc.2015010102-0","doi-asserted-by":"publisher","DOI":"10.1080\/0963928042000229699"},{"key":"joeuc.2015010102-1","unstructured":"Bewig, P. L. (2005). How do you know your spreadsheet is right? Principles, Techniques and Practice of Spreadsheet Style, Retrieved August 8, 2013 from http:\/\/www.eusprig.org\/hdykysir.pdf"},{"key":"joeuc.2015010102-2","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.2007070101"},{"key":"joeuc.2015010102-3","doi-asserted-by":"publisher","DOI":"10.1177\/001316446002000104"},{"key":"joeuc.2015010102-4","doi-asserted-by":"publisher","DOI":"10.1016\/S0305-0483(97)00004-2"},{"key":"joeuc.2015010102-5","doi-asserted-by":"publisher","DOI":"10.1037\/h0031619"},{"issue":"3","key":"joeuc.2015010102-6","doi-asserted-by":"crossref","first-page":"45","DOI":"10.1080\/07421222.1996.11518133","article-title":"Spreadsheet presentation and error detection: An experimental study.","volume":"13","author":"D. F.Galletta","year":"1996\/1997","journal-title":"Journal of Management Information Systems"},{"key":"joeuc.2015010102-7","unstructured":"Gandel, S. (2013). Damn Excel! How the 'most important software application of all time' is ruining the world. CNN, Fortune and Money. Retrieved May 31, 2013 from http:\/\/finance.fortune.cnn.com\/2013\/04\/17\/rogoff-reinhart-excel-errors\/"},{"key":"joeuc.2015010102-8","doi-asserted-by":"publisher","DOI":"10.1348\/000711006X126600"},{"key":"joeuc.2015010102-9","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-9236(00)00068-3"},{"key":"joeuc.2015010102-10","doi-asserted-by":"publisher","DOI":"10.1016\/j.infsof.2005.04.005"},{"key":"joeuc.2015010102-11","doi-asserted-by":"publisher","DOI":"10.2307\/2529310"},{"key":"joeuc.2015010102-12","doi-asserted-by":"publisher","DOI":"10.1016\/j.omega.2007.12.004"},{"issue":"6","key":"joeuc.2015010102-13","first-page":"31","article-title":"Get spreadsheets under control.","volume":"62","author":"A. G.Martin","year":"2005","journal-title":"The Internal Auditor"},{"key":"joeuc.2015010102-14","unstructured":"McKeever, R., & McDaid, K. (2010). How do range names hinder novice debugging performance? Proceedings of the EuSpRIG 2010 Conference,http:\/\/arxiv.org\/ftp\/arxiv\/papers\/1009\/1009.2765.pdf"},{"key":"joeuc.2015010102-15","author":"P.O\u2019Beirne","year":"2005","journal-title":"Spreadsheet Check and Control"},{"issue":"1","key":"joeuc.2015010102-16","first-page":"79","article-title":"The use of influence diagrams in the design of spreadsheet models: An experimental study.","volume":"9","author":"P. A.O\u2019Donnell","year":"2001","journal-title":"Australian Journal of Information Systems"},{"key":"joeuc.2015010102-17","doi-asserted-by":"publisher","DOI":"10.1109\/HICSS.1996.495419"},{"key":"joeuc.2015010102-18","doi-asserted-by":"crossref","unstructured":"Panko, R. R. (1998). Spreadsheet errors: What we know about spreadsheet errors. Journal of End User Computing, Special Issue on Scaling up End User Development, 10(2), 15-21.","DOI":"10.4018\/joeuc.1998040102"},{"key":"joeuc.2015010102-19","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2010.02.009"},{"key":"joeuc.2015010102-20","doi-asserted-by":"publisher","DOI":"10.1109\/HICSS.1996.495416"},{"issue":"1","key":"joeuc.2015010102-21","first-page":"21","article-title":"Are two heads better than one (at reducing errors in spreadsheet modeling?).","volume":"15","author":"R. R.Panko","year":"1997","journal-title":"Office Systems Research Journal"},{"key":"joeuc.2015010102-22","first-page":"15","article-title":"Sarbanes\u2013Oxley: What about all the spreadsheets? Controlling for errors and fraud in financial reporting.","author":"R. R.Panko","year":"2005","journal-title":"Proceedings of the EuSpRIG 2005 Conference"},{"key":"joeuc.2015010102-23","doi-asserted-by":"publisher","DOI":"10.1016\/S0167-9236(97)00038-9"},{"key":"joeuc.2015010102-24","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2008.06.001"},{"key":"joeuc.2015010102-25","doi-asserted-by":"publisher","DOI":"10.4018\/joeuc.2009070102"},{"key":"joeuc.2015010102-26","first-page":"117","article-title":"Correctness is not enough.","author":"L.Pryor","year":"2003","journal-title":"Proceedings of the EuSpRIG 2003 Conference"},{"key":"joeuc.2015010102-27","unstructured":"Purser, M., & Chadwick, D. (2006). Does an awareness of differing types of spreadsheet errors aid end-users in identifying spreadsheets errors? Proceedings of the EuSpRIG 2006 Conference (pp. 185-204). University of Cambridge, UK."},{"issue":"2","key":"joeuc.2015010102-28","first-page":"141","article-title":"New guidelines for spreadsheets.","volume":"2","author":"J. F.Raffensperger","year":"2003","journal-title":"International Journal of Business and Economics"},{"key":"joeuc.2015010102-29","first-page":"23","article-title":"Classification of spreadsheet errors.","author":"K.Rajalingham","year":"2000","journal-title":"Proceedings of the EuSpRIG 2000 Conference"},{"key":"joeuc.2015010102-30","doi-asserted-by":"publisher","DOI":"10.13031\/2013.37064"},{"key":"joeuc.2015010102-31","doi-asserted-by":"crossref","unstructured":"Reason, J. (1990). The contribution of latent human failures to the breakdown of complex systems. Philosophical Transactions of the Royal Society (London), series B, 327(1241), 475-484.","DOI":"10.1098\/rstb.1990.0090"},{"key":"joeuc.2015010102-32","doi-asserted-by":"publisher","DOI":"10.1016\/S0959-8022(99)00006-5"}],"container-title":["Journal of Organizational and End User Computing"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=121646","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T17:23:55Z","timestamp":1654104235000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/joeuc.2015010102"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2015,1,1]]},"references-count":33,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2015,1]]}},"URL":"https:\/\/doi.org\/10.4018\/joeuc.2015010102","relation":{},"ISSN":["1546-2234","1546-5012"],"issn-type":[{"value":"1546-2234","type":"print"},{"value":"1546-5012","type":"electronic"}],"subject":[],"published":{"date-parts":[[2015,1,1]]}}}