{"id":"https://openalex.org/W2906252910","doi":"https://doi.org/10.1007/s10515-018-0250-9","title":"Fragment-based spreadsheet debugging","display_name":"Fragment-based spreadsheet debugging","publication_year":2018,"publication_date":"2018-12-22","ids":{"openalex":"https://openalex.org/W2906252910","doi":"https://doi.org/10.1007/s10515-018-0250-9","mag":"2906252910"},"language":"en","primary_location":{"id":"doi:10.1007/s10515-018-0250-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10515-018-0250-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10515-018-0250-9.pdf","source":{"id":"https://openalex.org/S4210177399","display_name":"Automated Software Engineering","issn_l":"0928-8910","issn":["0928-8910","1573-7535"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Automated Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s10515-018-0250-9.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005545405","display_name":"Dietmar Jannach","orcid":"https://orcid.org/0000-0002-4698-8507"},"institutions":[{"id":"https://openalex.org/I4210166741","display_name":"University of Klagenfurt","ror":"https://ror.org/05q9m0937","country_code":"AT","type":"education","lineage":["https://openalex.org/I4210166741"]}],"countries":["AT"],"is_corresponding":true,"raw_author_name":"Dietmar Jannach","raw_affiliation_strings":["AAU Klagenfurt, Klagenfurt, Austria"],"affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090974146","display_name":"Thomas Schmitz","orcid":"https://orcid.org/0000-0001-9605-1117"},"institutions":[{"id":"https://openalex.org/I200332995","display_name":"TU Dortmund University","ror":"https://ror.org/01k97gp34","country_code":"DE","type":"education","lineage":["https://openalex.org/I200332995"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Schmitz","raw_affiliation_strings":["TU Dortmund, Dortmund, Germany"],"affiliations":[{"raw_affiliation_string":"TU Dortmund, Dortmund, Germany","institution_ids":["https://openalex.org/I200332995"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069209580","display_name":"Birgit Hofer","orcid":"https://orcid.org/0000-0001-5144-059X"},"institutions":[{"id":"https://openalex.org/I4092182","display_name":"Graz University of Technology","ror":"https://ror.org/00d7xrm67","country_code":"AT","type":"education","lineage":["https://openalex.org/I4092182"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Birgit Hofer","raw_affiliation_strings":["TU Graz, Graz, Austria"],"affiliations":[{"raw_affiliation_string":"TU Graz, Graz, Austria","institution_ids":["https://openalex.org/I4092182"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055185135","display_name":"Konstantin Schekotihin","orcid":"https://orcid.org/0000-0002-0286-0958"},"institutions":[{"id":"https://openalex.org/I4210166741","display_name":"University of Klagenfurt","ror":"https://ror.org/05q9m0937","country_code":"AT","type":"education","lineage":["https://openalex.org/I4210166741"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Konstantin Schekotihin","raw_affiliation_strings":["AAU Klagenfurt, Klagenfurt, Austria"],"affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073809674","display_name":"Patrick Koch","orcid":"https://orcid.org/0000-0002-3819-1784"},"institutions":[{"id":"https://openalex.org/I4210166741","display_name":"University of Klagenfurt","ror":"https://ror.org/05q9m0937","country_code":"AT","type":"education","lineage":["https://openalex.org/I4210166741"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Patrick Koch","raw_affiliation_strings":["AAU Klagenfurt, Klagenfurt, Austria"],"affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5011388533","display_name":"Franz Wotawa","orcid":"https://orcid.org/0000-0002-0462-2283"},"institutions":[{"id":"https://openalex.org/I4092182","display_name":"Graz University of Technology","ror":"https://ror.org/00d7xrm67","country_code":"AT","type":"education","lineage":["https://openalex.org/I4092182"]}],"countries":["AT"],"is_corresponding":false,"raw_author_name":"Franz Wotawa","raw_affiliation_strings":["TU Graz, Graz, Austria"],"affiliations":[{"raw_affiliation_string":"TU Graz, Graz, Austria","institution_ids":["https://openalex.org/I4092182"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5005545405"],"corresponding_institution_ids":["https://openalex.org/I4210166741"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":1.4736,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":{"value":0.84571185,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"26","issue":"1","first_page":"203","last_page":"239"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10906","display_name":"AI-based Problem Solving and Planning","score":0.9319999814033508,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9226999878883362,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.9414306879043579},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.8461045622825623},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8329593539237976},{"id":"https://openalex.org/keywords/algorithmic-program-debugging","display_name":"Algorithmic program debugging","score":0.6609880924224854},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5610679984092712},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5587916374206543},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5445041060447693},{"id":"https://openalex.org/keywords/decomposition","display_name":"Decomposition","score":0.4987468719482422},{"id":"https://openalex.org/keywords/test-case","display_name":"Test case","score":0.46302902698516846},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3236495852470398},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.32212352752685547},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.10576844215393066}],"concepts":[{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.9414306879043579},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.8461045622825623},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8329593539237976},{"id":"https://openalex.org/C136388014","wikidata":"https://www.wikidata.org/wiki/Q17084976","display_name":"Algorithmic program debugging","level":3,"score":0.6609880924224854},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5610679984092712},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5587916374206543},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5445041060447693},{"id":"https://openalex.org/C124681953","wikidata":"https://www.wikidata.org/wiki/Q339062","display_name":"Decomposition","level":2,"score":0.4987468719482422},{"id":"https://openalex.org/C128942645","wikidata":"https://www.wikidata.org/wiki/Q1568346","display_name":"Test case","level":3,"score":0.46302902698516846},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3236495852470398},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.32212352752685547},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.10576844215393066},{"id":"https://openalex.org/C152877465","wikidata":"https://www.wikidata.org/wiki/Q208042","display_name":"Regression analysis","level":2,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s10515-018-0250-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10515-018-0250-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10515-018-0250-9.pdf","source":{"id":"https://openalex.org/S4210177399","display_name":"Automated Software Engineering","issn_l":"0928-8910","issn":["0928-8910","1573-7535"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Automated Software Engineering","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1007/s10515-018-0250-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s10515-018-0250-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s10515-018-0250-9.pdf","source":{"id":"https://openalex.org/S4210177399","display_name":"Automated Software Engineering","issn_l":"0928-8910","issn":["0928-8910","1573-7535"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Automated Software Engineering","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G358022161","display_name":null,"funder_award_id":"JA 2095/4-1","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G7443541685","display_name":null,"funder_award_id":"I2144","funder_id":"https://openalex.org/F4320321181","funder_display_name":"Austrian Science Fund"}],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"},{"id":"https://openalex.org/F4320321181","display_name":"Austrian Science Fund","ror":"https://ror.org/013tf3c58"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2906252910.pdf","grobid_xml":"https://content.openalex.org/works/W2906252910.grobid-xml"},"referenced_works_count":40,"referenced_works":["https://openalex.org/W194998427","https://openalex.org/W1544130153","https://openalex.org/W1737602619","https://openalex.org/W1781167154","https://openalex.org/W1808011207","https://openalex.org/W1880733898","https://openalex.org/W1933103375","https://openalex.org/W1974365737","https://openalex.org/W1985769033","https://openalex.org/W2004681315","https://openalex.org/W2012984944","https://openalex.org/W2020123909","https://openalex.org/W2022114557","https://openalex.org/W2057279587","https://openalex.org/W2067436653","https://openalex.org/W2068829166","https://openalex.org/W2080982416","https://openalex.org/W2083808198","https://openalex.org/W2086674260","https://openalex.org/W2095955261","https://openalex.org/W2108309071","https://openalex.org/W2111469656","https://openalex.org/W2117032538","https://openalex.org/W2121840944","https://openalex.org/W2122410182","https://openalex.org/W2138633813","https://openalex.org/W2152376725","https://openalex.org/W2247001206","https://openalex.org/W2548809312","https://openalex.org/W2554473058","https://openalex.org/W2557818304","https://openalex.org/W2572285107","https://openalex.org/W2601734385","https://openalex.org/W2604295526","https://openalex.org/W2623293810","https://openalex.org/W2755137825","https://openalex.org/W2768841788","https://openalex.org/W2770662258","https://openalex.org/W4285719527","https://openalex.org/W6600755840"],"related_works":["https://openalex.org/W2119199043","https://openalex.org/W2396596882","https://openalex.org/W2098290990","https://openalex.org/W2801084903","https://openalex.org/W2377280071","https://openalex.org/W2060682672","https://openalex.org/W2375626968","https://openalex.org/W4242908235","https://openalex.org/W1520271518","https://openalex.org/W2294325978"],"abstract_inverted_index":{"Faults":[0],"in":[1],"spreadsheets":[2,21],"can":[3,64,96,113,169],"represent":[4],"a":[5,61,141,195,212],"major":[6],"risk":[7],"for":[8,20,70,103,207,211],"businesses.":[9],"To":[10],"minimize":[11],"such":[12,25],"risks,":[13],"various":[14],"automated":[15],"testing":[16],"and":[17,68,157,176],"debugging":[18,83,137,174],"approaches":[19],"were":[22],"proposed.":[23],"In":[24,74],"approaches,":[26],"often":[27],"one":[28],"main":[29],"assumption":[30],"is":[31,36,86],"that":[32,55,122,145,164,193],"the":[33,41,48,56,90,124,155,165,172,179,186,202],"spreadsheet":[34,81,91,196],"developer":[35],"able":[37],"to":[38,47],"indicate":[39],"if":[40],"outcomes":[42],"of":[43,105,143,181],"certain":[44],"calculations":[45,59],"correspond":[46],"intended":[49],"values.":[50],"This,":[51],"however,":[52],"might":[53],"require":[54],"user":[57],"performs":[58],"manually,":[60],"process":[62,175],"which":[63,85,139],"easily":[65],"become":[66],"tedious":[67],"error-prone":[69],"more":[71],"complex":[72],"spreadsheets.":[73],"this":[75],"work,":[76],"we":[77],"propose":[78],"an":[79,135],"interactive":[80],"algorithmic":[82,136,173],"method,":[84],"based":[87],"on":[88],"partitioning":[89],"into":[92,134],"fragments.":[93],"Test":[94],"cases":[95,121,130,210],"then":[97,132],"be":[98,114],"automatically":[99],"or":[100,111],"manually":[101],"created":[102],"each":[104],"these":[106],"smaller":[107],"fragments,":[108],"whose":[109],"correctness":[110],"faultiness":[112],"easier":[115],"assessed":[116],"by":[117,185,205],"users":[118,206],"than":[119],"test":[120,129,209],"cover":[123],"entire":[125],"spreadsheet.":[126,213],"The":[127],"annotated":[128],"are":[131],"fed":[133],"technique,":[138],"returns":[140],"set":[142],"formulas":[144],"could":[146],"have":[147],"caused":[148],"any":[149],"observed":[150],"failures,":[151],"i.e.,":[152],"discrepancies":[153],"between":[154],"expected":[156],"computed":[158],"calculation":[159],"outcomes.":[160],"Simulation":[161],"experiments":[162],"demonstrate":[163],"suggested":[166],"decomposition":[167],"approach":[168],"speed":[170],"up":[171],"significantly":[177],"reduce":[178],"number":[180],"fault":[182],"candidates":[183],"returned":[184],"algorithm.":[187],"An":[188],"additional":[189],"laboratory":[190],"study":[191],"shows":[192],"fragmenting":[194],"with":[197],"our":[198],"method":[199],"furthermore":[200],"reduces":[201],"time":[203],"needed":[204],"creating":[208]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":4},{"year":2019,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}