{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,12]],"date-time":"2025-06-12T23:40:02Z","timestamp":1749771602493,"version":"3.41.0"},"publisher-location":"Cham","reference-count":23,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783319502298"},{"type":"electronic","value":"9783319502304"}],"license":[{"start":{"date-parts":[[2016,1,1]],"date-time":"2016-01-01T00:00:00Z","timestamp":1451606400000},"content-version":"unspecified","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2016]]},"DOI":"10.1007\/978-3-319-50230-4_28","type":"book-chapter","created":{"date-parts":[[2016,11,30]],"date-time":"2016-11-30T13:31:26Z","timestamp":1480512686000},"page":"372-387","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":3,"title":["Fragment-Based Diagnosis of Spreadsheets"],"prefix":"10.1007","author":[{"given":"Thomas","family":"Schmitz","sequence":"first","affiliation":[]},{"given":"Birgit","family":"Hofer","sequence":"additional","affiliation":[]},{"given":"Dietmar","family":"Jannach","sequence":"additional","affiliation":[]},{"given":"Franz","family":"Wotawa","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2016,12,1]]},"reference":[{"issue":"2","key":"28_CR1","doi-asserted-by":"publisher","first-page":"297","DOI":"10.1007\/s11219-014-9236-4","volume":"23","author":"R Abreu","year":"2015","unstructured":"Abreu, R., Hofer, B., Perez, A., Wotawa, F.: Using constraints to diagnose faulty spreadsheets. Softw. Qual. J. 23(2), 297\u2013322 (2015)","journal-title":"Softw. Qual. J."},{"unstructured":"Autio, K., Reiter, R.: Structural abstraction in model-based diagnosis. In: ECAI 1998, pp. 269\u2013273 (1998)","key":"28_CR2"},{"issue":"1\u20132","key":"28_CR3","doi-asserted-by":"publisher","first-page":"147","DOI":"10.1016\/j.artint.2003.06.003","volume":"155","author":"L Chittaro","year":"2004","unstructured":"Chittaro, L., Ranon, R.: Hierarchical model-based diagnosis based on structural abstraction. Artifi. Intell. 155(1\u20132), 147\u2013182 (2004)","journal-title":"Artifi. Intell."},{"key":"28_CR4","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"85","DOI":"10.1007\/BFb0019402","volume-title":"Automated and Algorithmic Debugging","author":"L Console","year":"1993","unstructured":"Console, L., Friedrich, G., Dupr\u00e9, D.T.: Model-based diagnosis meets error diagnosis in logic programs. In: Fritzson, P.A. (ed.) AADEBUG 1993. LNCS, vol. 749, pp. 85\u201387. Springer, Heidelberg (1993). doi: 10.1007\/BFb0019402"},{"doi-asserted-by":"crossref","unstructured":"Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: VL\/HCC 2010, pp. 93\u2013100 (2010)","key":"28_CR5","DOI":"10.1109\/VLHCC.2010.22"},{"unstructured":"F1F9: The Dirty Dozen. http:\/\/blogs.mazars.com\/the-model-auditor\/files\/2014\/01\/12-Modelling-Horror-Stories-and-Spreadsheet-Disasters-Mazars-UK.pdf . Accessed 7 Apr 2016","key":"28_CR6"},{"key":"28_CR7","series-title":"Lecture Notes in Computer Science (Lecture Notes in Artificial Intelligence)","doi-asserted-by":"publisher","first-page":"185","DOI":"10.1007\/3-540-45422-5_14","volume-title":"KI 2001: Advances in Artificial Intelligence","author":"A Felfernig","year":"2001","unstructured":"Felfernig, A., Friedrich, G.E., Zanker, M., Jannach, D., Stumptner, M.: Hierarchical diagnosis of large configurator knowledge bases. In: Baader, F., Brewka, G., Eiter, T. (eds.) KI 2001. LNCS (LNAI), vol. 2174, pp. 185\u2013197. Springer, Heidelberg (2001). doi: 10.1007\/3-540-45422-5_14"},{"issue":"1\u20132","key":"28_CR8","doi-asserted-by":"publisher","first-page":"3","DOI":"10.1016\/S0004-3702(99)00034-X","volume":"111","author":"G Friedrich","year":"1999","unstructured":"Friedrich, G., Stumptner, M., Wotawa, F.: Model-based diagnosis of hardware designs. Artif. Intell. 111(1\u20132), 3\u201339 (1999)","journal-title":"Artif. Intell."},{"doi-asserted-by":"crossref","unstructured":"Hermans, F., Pinzger, M., van Deursen, A.: Supporting professional spreadsheet users by generating leveled dataflow diagrams. In: ICSE 2011, pp. 451\u2013460 (2011)","key":"28_CR9","DOI":"10.1145\/1985793.1985855"},{"doi-asserted-by":"crossref","unstructured":"Hermans, F., Murphy-Hill, E.R.: Enron\u2019s spreadsheets and related emails: a dataset and analysis. In: ICSE 2015, pp. 7\u201316 (2015)","key":"28_CR10","DOI":"10.1109\/ICSE.2015.129"},{"doi-asserted-by":"crossref","unstructured":"Hermans, F., Pinzger, M., van Deursen, A.: Detecting code smells in spreadsheet formulas. In: ICSM 2012, pp. 409\u2013418 (2012)","key":"28_CR11","DOI":"10.1109\/ICSM.2012.6405300"},{"unstructured":"Hodnigg, K., Mittermeir, R.T.: Metrics-based spreadsheet visualization - support for focused maintenance. In: EuSpRIG 2008, pp. 79\u201394 (2008)","key":"28_CR12"},{"key":"28_CR13","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"68","DOI":"10.1007\/978-3-642-37057-1_6","volume-title":"Fundamental Approaches to Software Engineering","author":"B Hofer","year":"2013","unstructured":"Hofer, B., Riboira, A., Wotawa, F., Abreu, R., Getzner, E.: On the empirical evaluation of fault localization techniques for spreadsheets. In: Cortellessa, V., Varr\u00f3, D. (eds.) FASE 2013. LNCS, vol. 7793, pp. 68\u201382. Springer, Heidelberg (2013). doi: 10.1007\/978-3-642-37057-1_6"},{"doi-asserted-by":"crossref","unstructured":"Hofer, B., Wotawa, F.: Why does my spreadsheet compute wrong values? In: ISSRE 2014, pp. 112\u2013121 (2014)","key":"28_CR14","DOI":"10.1109\/ISSRE.2014.23"},{"doi-asserted-by":"crossref","unstructured":"Jannach, D., Baharloo, A., Williamson, D.: Toward an integrated framework for declarative and interactive spreadsheet debugging. In: ENASE 2013, pp. 117\u2013124 (2013)","key":"28_CR15","DOI":"10.5220\/0004410601170124"},{"unstructured":"Jannach, D., Schmitz, T.: Using calculation fragments for spreadsheet testing and debugging. In: SEMS 2015, pp. 1\u20132 (2015)","key":"28_CR16"},{"issue":"1","key":"28_CR17","doi-asserted-by":"publisher","first-page":"105","DOI":"10.1007\/s10515-014-0141-7","volume":"23","author":"D Jannach","year":"2016","unstructured":"Jannach, D., Schmitz, T.: Model-based diagnosis of spreadsheet programs: a constraint-based debugging approach. Autom. Softw. Eng. 23(1), 105\u2013144 (2016)","journal-title":"Autom. Softw. Eng."},{"key":"28_CR18","doi-asserted-by":"publisher","first-page":"129","DOI":"10.1016\/j.jss.2014.03.058","volume":"94","author":"D Jannach","year":"2014","unstructured":"Jannach, D., Schmitz, T., Hofer, B., Wotawa, F.: Avoiding, finding and fixing spreadsheet errors - a survey of automated approaches for spreadsheet QA. J. Syst. Softw. 94, 129\u2013150 (2014)","journal-title":"J. Syst. Softw."},{"unstructured":"Junker, U.: QUICKXPLAIN: preferred explanations and relaxations for over-constrained problems. In: AAAI 2004, pp. 167\u2013172 (2004)","key":"28_CR19"},{"issue":"1","key":"28_CR20","doi-asserted-by":"publisher","first-page":"57","DOI":"10.1016\/0004-3702(87)90062-2","volume":"32","author":"R Reiter","year":"1987","unstructured":"Reiter, R.: A theory of diagnosis from first principles. Artif. Intell. 32(1), 57\u201395 (1987)","journal-title":"Artif. Intell."},{"doi-asserted-by":"crossref","unstructured":"Schmitz, T., Jannach, D.: Finding errors in the enron spreadsheet corpus. In: VL\/HCC 2016 (2016)","key":"28_CR21","DOI":"10.1109\/VLHCC.2016.7739679"},{"issue":"1","key":"28_CR22","doi-asserted-by":"publisher","first-page":"1","DOI":"10.1016\/S0004-3702(01)00054-6","volume":"127","author":"M Stumptner","year":"2001","unstructured":"Stumptner, M., Wotawa, F.: Diagnosing tree-structured systems. Artif. Intell. 127(1), 1\u201329 (2001)","journal-title":"Artif. Intell."},{"unstructured":"Tan, G.: Spreadsheet mistake costs Tibco shareholders $100 million, 16 October 2014. http:\/\/on.wsj.com\/1vjYdWE . Accessed 7 Apr 2016","key":"28_CR23"}],"container-title":["Lecture Notes in Computer Science","Software Technologies: Applications and Foundations"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-319-50230-4_28","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,12]],"date-time":"2025-06-12T23:10:57Z","timestamp":1749769857000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-319-50230-4_28"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2016]]},"ISBN":["9783319502298","9783319502304"],"references-count":23,"URL":"https:\/\/doi.org\/10.1007\/978-3-319-50230-4_28","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2016]]},"assertion":[{"value":"1 December 2016","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"STAF","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Federation of International Conferences on Software Technologies: Applications and Foundations","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Vienna","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Austria","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2016","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"4 July 2016","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"8 July 2016","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"staf2016","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}