{"id":"https://openalex.org/W2770662258","doi":"https://doi.org/10.1109/vlhcc.2017.8103458","title":"A decomposition-based approach to spreadsheet testing and debugging","display_name":"A decomposition-based approach to spreadsheet testing and debugging","publication_year":2017,"publication_date":"2017-10-01","ids":{"openalex":"https://openalex.org/W2770662258","doi":"https://doi.org/10.1109/vlhcc.2017.8103458","mag":"2770662258"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2017.8103458","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2017.8103458","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","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":true,"raw_author_name":"Thomas Schmitz","raw_affiliation_strings":["TU Dortmund, Germany"],"affiliations":[{"raw_affiliation_string":"TU Dortmund, Germany","institution_ids":["https://openalex.org/I200332995"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005545405","display_name":"Dietmar Jannach","orcid":"https://orcid.org/0000-0002-4698-8507"},"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":"Dietmar Jannach","raw_affiliation_strings":["TU Dortmund, Germany"],"affiliations":[{"raw_affiliation_string":"TU 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":["Graz University of Technology, Austria"],"affiliations":[{"raw_affiliation_string":"Graz University of Technology, Austria","institution_ids":["https://openalex.org/I4092182"]}]},{"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/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":"Patrick Koch","raw_affiliation_strings":["Graz University of Technology, Austria"],"affiliations":[{"raw_affiliation_string":"Graz University of Technology, 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":["Alpen-Adria Universit\u00e4t Klagenfurt, Austria"],"affiliations":[{"raw_affiliation_string":"Alpen-Adria Universit\u00e4t 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":["Graz University of Technology, Austria"],"affiliations":[{"raw_affiliation_string":"Graz University of Technology, Austria","institution_ids":["https://openalex.org/I4092182"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5090974146"],"corresponding_institution_ids":["https://openalex.org/I200332995"],"apc_list":null,"apc_paid":null,"fwci":2.7135,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.91311612,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"117","last_page":"121"},"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/T12423","display_name":"Software Reliability and Analysis Research","score":0.963699996471405,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.9375203847885132},{"id":"https://openalex.org/keywords/correctness","display_name":"Correctness","score":0.9039934873580933},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8262714147567749},{"id":"https://openalex.org/keywords/decomposition","display_name":"Decomposition","score":0.596295177936554},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5932358503341675},{"id":"https://openalex.org/keywords/fragmentation","display_name":"Fragmentation (computing)","score":0.548206090927124},{"id":"https://openalex.org/keywords/software-bug","display_name":"Software bug","score":0.5132434368133545},{"id":"https://openalex.org/keywords/algorithmic-program-debugging","display_name":"Algorithmic program debugging","score":0.4731135070323944},{"id":"https://openalex.org/keywords/test","display_name":"Test (biology)","score":0.4653039574623108},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.4643685221672058},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.21109279990196228}],"concepts":[{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.9375203847885132},{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.9039934873580933},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8262714147567749},{"id":"https://openalex.org/C124681953","wikidata":"https://www.wikidata.org/wiki/Q339062","display_name":"Decomposition","level":2,"score":0.596295177936554},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5932358503341675},{"id":"https://openalex.org/C191015642","wikidata":"https://www.wikidata.org/wiki/Q1132459","display_name":"Fragmentation (computing)","level":2,"score":0.548206090927124},{"id":"https://openalex.org/C1009929","wikidata":"https://www.wikidata.org/wiki/Q179550","display_name":"Software bug","level":3,"score":0.5132434368133545},{"id":"https://openalex.org/C136388014","wikidata":"https://www.wikidata.org/wiki/Q17084976","display_name":"Algorithmic program debugging","level":3,"score":0.4731135070323944},{"id":"https://openalex.org/C2777267654","wikidata":"https://www.wikidata.org/wiki/Q3519023","display_name":"Test (biology)","level":2,"score":0.4653039574623108},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4643685221672058},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.21109279990196228},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vlhcc.2017.8103458","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2017.8103458","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320321181","display_name":"Austrian Science Fund","ror":"https://ror.org/013tf3c58"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W194998427","https://openalex.org/W1659044373","https://openalex.org/W1933103375","https://openalex.org/W2022114557","https://openalex.org/W2080982416","https://openalex.org/W2083808198","https://openalex.org/W2086674260","https://openalex.org/W2095955261","https://openalex.org/W2134766084","https://openalex.org/W2557818304","https://openalex.org/W2601734385","https://openalex.org/W2798293618","https://openalex.org/W4249909277","https://openalex.org/W6607942509","https://openalex.org/W6637107664","https://openalex.org/W6729776893"],"related_works":["https://openalex.org/W2396596882","https://openalex.org/W2098290990","https://openalex.org/W2119199043","https://openalex.org/W2801084903","https://openalex.org/W2377280071","https://openalex.org/W2060682672","https://openalex.org/W2375626968","https://openalex.org/W4242908235","https://openalex.org/W2161928627","https://openalex.org/W4206999239"],"abstract_inverted_index":{"Spreadsheets":[0],"serve":[1],"as":[2],"a":[3,18,84,91,115],"basis":[4],"for":[5,40,69],"decision-making":[6],"processes":[7],"in":[8,13,87],"many":[9],"companies":[10],"and":[11,38],"bugs":[12],"spreadsheets":[14,56],"can":[15,25,35,65,105],"therefore":[16],"represent":[17],"considerable":[19],"risk":[20],"to":[21,27,54,76,107,113],"businesses.":[22],"Systematic":[23],"tests":[24],"help":[26,106],"locate":[28],"such":[29,78],"bugs,":[30],"but":[31],"providing":[32],"test":[33,49,114],"cases":[34,50],"be":[36,66],"cumbersome":[37],"complex":[39],"large":[41],"real-world":[42],"spreadsheets.":[43],"To":[44],"make":[45],"the":[46,88,102,110],"specification":[47],"of":[48,90],"easier,":[51],"we":[52,81],"propose":[53],"split":[55],"into":[57],"smaller":[58],"logically":[59],"connected":[60],"parts":[61],"(called":[62],"fragments)":[63],"which":[64,80],"individually":[67],"tested":[68],"correctness.":[70],"We":[71],"present":[72],"an":[73],"algorithmic":[74],"approach":[75,104],"compute":[77],"fragments,":[79],"validated":[82],"with":[83],"laboratory":[85],"study":[86],"form":[89],"spreadsheet":[92],"debugging":[93],"exercise":[94],"involving":[95],"57":[96],"subjects.":[97],"The":[98],"results":[99],"show":[100],"that":[101],"fragmentation":[103],"significantly":[108],"reduce":[109],"required":[111],"efforts":[112],"spreadsheet.":[116]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}