Revising the Panko–Halverson taxonomy of spreadsheet errors

Panko, Raymond R.; Aurigemma, Salvatore

doi:10.1016/j.dss.2010.02.009

Cited by 78 publications

(51 citation statements)

References 17 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…To adjust these assumptions and to maintain the grid, further update operations shown in Figure 23 can be applied to CS graphs. To change a CS graph's orientation, the toggleOri operation can be used, which toggles the whole graph's orientation 3 , For example, increasing the first row of repetition to 2 does not repeat the first row on the class for every single class instances. The first row might be a header.…”

Section: Update Languagementioning

confidence: 99%

“…Although, the spreadsheet user group usually is able to develop complex spreadsheets, the users often do not have the knowledge to prevent errors leading to error-prone and unstructured spreadsheets [2]. Studies estimate rates of at least 80 percent of erroneous spreadsheets [3,4]. How costly these errors can be is evident in recent news stories.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Systematic evolution of model-based spreadsheet applications

Luckey

Erwig

Engels

2012

Journal of Visual Languages & Computing

View full text Add to dashboard Cite

Using spreadsheets is the preferred method to calculate, display or store anything that fits into a table-like structure. They are often used by end users to create applications, although they have one critical drawback-spreadsheets are very error-prone. Recent research has developed methods to reduce this error-proneness by introducing a new way of object-oriented modeling of spreadsheets before using them. These spreadsheet models, termed ClassSheets, are used to generate concrete spreadsheets on the instance level. By this approach sources of errors are reduced and spreadsheet applications become easier to understand.As usual for almost every other application, requirements on spreadsheets change due to the changing environment. Thus, the problem of evolution of spreadsheets arises. The update and evolution of spreadsheets is the uttermost source of errors that may have severe impact.In this article, we will introduce a model-based approach to spreadsheet evolution by propagating updates on spreadsheet models (i.e. ClassSheets) to spreadsheets. To this end, update commands for the ClassSheet layer are automatically transformed to those for the spreadsheet layer. We describe spreadsheet model update propagation using a formal framework and present an integrated tool suite that allows the easy creation and safe update of spreadsheet models. The presented approach greatly contributes to the problem of software evolution and maintenance for spreadsheets and thus avoids many errors that might have severe impacts.

show abstract

Section: Update Languagementioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

Systematic evolution of model-based spreadsheet applications

Luckey

Erwig

Engels

2012

Journal of Visual Languages & Computing

View full text Add to dashboard Cite

show abstract

“…Searches identified eight studies [45][46][47][48][49][50][51][52] that presented original work on classifications or taxonomies of errors, and one critical review. 53 Of the eight studies all except two focused on errors in spreadsheet systems, one focused on generic programming errors 48 and a second focused on errors in the requirements specification process.…”

Section: Review Of Taxonomy/ Classification Literature Quantity and Qmentioning

confidence: 99%

“…The second classification system of Panko 52 provides perhaps the best match in terms of purpose and level of abstraction to the interview classification of modelling errors. The interview classification is mapped onto this second Panko classification in Table 6 and this is used here to further discuss the details of the interview classification system.…”

Section: The Interview Classification Of Hta Modelling Errorsmentioning

confidence: 99%

Avoiding and identifying errors in health technology assessment models: qualitative study and methodological review

Chilcott¹,

Tappenden²,

Rawdin³

et al. 2010

Health Technol Assess

View full text Add to dashboard Cite

How to obtain copies of this and other HTA programme reports An electronic version of this title, in Adobe Acrobat format, is available for downloading free of charge for personal use from the HTA website (www.hta.ac.uk). A fully searchable DVD is also available (see below).Printed copies of HTA journal series issues cost £20 each (post and packing free in the UK) to both public and private sector purchasers from our despatch agents.Non-UK purchasers will have to pay a small fee for post and packing. For European countries the cost is £2 per issue and for the rest of the world £3 per issue. How to order:-fax (with credit card details) -post (with credit card details or cheque) -phone during office hours (credit card only).Additionally the HTA website allows you to either print out your order or download a blank order form. Contact details are as follows:Synergie UK (HTA Department) Digital House, The Loddon Centre Wade Road Basingstoke Hants RG24 8QW Email: orders@hta.ac.uk Tel: 0845 812 4000 -ask for 'HTA Payment Services' (out-of-hours answer-phone service) Fax: 0845 812 4001 -put 'HTA Order' on the fax header Payment methods Paying by chequeIf you pay by cheque, the cheque must be in pounds sterling, made payable to University of Southampton and drawn on a bank with a UK address. Paying by credit cardYou can order using your credit card by phone, fax or post. SubscriptionsNHS libraries can subscribe free of charge. Public libraries can subscribe at a reduced cost of £100 for each volume (normally comprising 40-50 titles). The commercial subscription rate is £400 per volume (addresses within the UK) and £600 per volume (addresses outside the UK). Please see our website for details. Subscriptions can be purchased only for the current or forthcoming volume. How do I get a copy of HTA on DVD?Please use the form on the HTA website (www.hta.ac.uk/htacd/index.shtml). HTA on DVD is currently free of charge worldwide.The website also provides information about the HTA programme and lists the membership of the various committees. The research findings from the HTA programme directly influence decision-making bodies such as the National Institute for Health and Clinical Excellence (NICE) and the National Screening Committee (NSC). HTA findings also help to improve the quality of clinical practice in the NHS indirectly in that they form a key component of the 'National Knowledge Service'. The HTA programme is needs led in that it fills gaps in the evidence needed by the NHS. There are three routes to the start of projects. First is the commissioned route. Suggestions for research are actively sought from people working in the NHS, from the public and consumer groups and from professional bodies such as royal colleges and NHS trusts. These suggestions are carefully prioritised by panels of independent experts (including NHS service users). The HTA programme then commissions the research by competitive tender. Second, the HTA programme provides grants for clinical trials for researchers who identify research questions. The...

show abstract

“…The most common topic within which literature deals with spreadsheets are spreadsheet errors [4], [14], [22], [23], [24], [25], [26], [27], [34], [36], [43]. The predominant opinion is that, although spreadsheets are ubiquitous in business operations, what is (mostly) neglected and insufficiently elaborated is the data on how much the spreadsheet-generated data are used, how important they are to end users, what the level of the users' knowledge is and in which situations and for which purposes the end users use spreadsheets.…”

mentioning

confidence: 99%