首页|Spreadsheet quality assurance:a literature review
Spreadsheet quality assurance:a literature review
扫码查看
点击上方二维码区域，可以放大扫码查看
原文链接
NETL
NSTL
万方数据
Spreadsheets are very common for information processing to support decision making by both professional developers and non-technical end users.Moreover,business intelligence and artificial intelligence are increasingly popular in the industry nowadays,where spreadsheets have been used as,or integrated into,intelligent or expert systems in various application domains.However,it has been repeatedly reported that faults often exist in operational spreadsheets,which could severely compromise the quality of conclusions and decisions based on the spreadsheets.With a view to systematically examining this problem via survey of existing work,we have conducted a comprehensive literature review on the quality issues and related techniques of spreadsheets over a 35.5-year period(from January 1987 to June 2022)for target journals and a 10.5-year period(from January 2012 to June 2022)for target conferences.Among other findings,two major ones are:(a)Spreadsheet quality is best addressed throughout the whole spreadsheet life cycle,rather than just focusing on a few specific stages of the life cycle.(b)Relatively more studies focus on spreadsheet testing and debugging(related to fault detection and removal)when compared with spreadsheet specification,modeling,and design(related to development).As prevention is better than cure,more research should be performed on the early stages of the spreadsheet life cycle.Enlightened by our comprehensive review,we have identified the major research gaps as well as highlighted key research directions for future work in the area.
decision support systemend-user computingend-user programmingExcelspreadsheet
Pak-Lok POON、Man Fai LAU、Yuen Tak YU、Sau-Fun TANG
展开 >
School of Engineering and Technology,Central Queensland University,Melbourne 3000,Australia
Department of Computing Technologies,Swinburne University of Technology,Hawthorn 3122,Australia
Department of Computer Science,City University of Hong Kong,Hong Kong SAR 999077,China
The Royal Victorian Eye and Ear Hospital,East Melbourne 3002,Australia
展开 >
Open Access funding enabled and organized by CAUL and its Member Institutions
NETL
NSTL
万方数据
