{"id":"https://openalex.org/W2979001501","doi":"https://doi.org/10.1109/tse.2019.2944604","title":"Metric-Based Fault Prediction for Spreadsheets","display_name":"Metric-Based Fault Prediction for Spreadsheets","publication_year":2019,"publication_date":"2019-10-04","ids":{"openalex":"https://openalex.org/W2979001501","doi":"https://doi.org/10.1109/tse.2019.2944604","mag":"2979001501"},"language":"en","primary_location":{"id":"doi:10.1109/tse.2019.2944604","is_oa":true,"landing_page_url":"https://doi.org/10.1109/tse.2019.2944604","pdf_url":"https://ieeexplore.ieee.org/ielx7/32/9573514/08859280.pdf","source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ieeexplore.ieee.org/ielx7/32/9573514/08859280.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","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":true,"raw_author_name":"Patrick Koch","raw_affiliation_strings":["AAU Klagenfurt, Klagenfurt, Austria"],"raw_orcid":"https://orcid.org/0000-0002-3819-1784","affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"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"],"raw_orcid":"https://orcid.org/0000-0002-0286-0958","affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"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/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":"Dietmar Jannach","raw_affiliation_strings":["AAU Klagenfurt, Klagenfurt, Austria"],"raw_orcid":"https://orcid.org/0000-0002-4698-8507","affiliations":[{"raw_affiliation_string":"AAU Klagenfurt, Klagenfurt, Austria","institution_ids":["https://openalex.org/I4210166741"]}]},{"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"],"raw_orcid":"https://orcid.org/0000-0001-5144-059X","affiliations":[{"raw_affiliation_string":"TU Graz, Graz, Austria","institution_ids":["https://openalex.org/I4092182"]}]},{"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"],"raw_orcid":"https://orcid.org/0000-0002-0462-2283","affiliations":[{"raw_affiliation_string":"TU Graz, Graz, Austria","institution_ids":["https://openalex.org/I4092182"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5073809674"],"corresponding_institution_ids":["https://openalex.org/I4210166741"],"apc_list":null,"apc_paid":null,"fwci":2.636,"has_fulltext":true,"cited_by_count":13,"citation_normalized_percentile":{"value":0.90130197,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"47","issue":"10","first_page":"2195","last_page":"2207"},"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.998199999332428,"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.998199999332428,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9854000210762024,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9749000072479248,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/computer-science","display_name":"Computer science","score":0.7859556674957275},{"id":"https://openalex.org/keywords/metric","display_name":"Metric (unit)","score":0.7423791885375977},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.5935268998146057},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5424085855484009},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.517140805721283},{"id":"https://openalex.org/keywords/fault-detection-and-isolation","display_name":"Fault detection and isolation","score":0.5170343518257141},{"id":"https://openalex.org/keywords/fault","display_name":"Fault (geology)","score":0.5150318145751953},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.49224987626075745},{"id":"https://openalex.org/keywords/random-forest","display_name":"Random forest","score":0.4189165234565735},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3500739336013794}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7859556674957275},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.7423791885375977},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.5935268998146057},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5424085855484009},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.517140805721283},{"id":"https://openalex.org/C152745839","wikidata":"https://www.wikidata.org/wiki/Q5438153","display_name":"Fault detection and isolation","level":3,"score":0.5170343518257141},{"id":"https://openalex.org/C175551986","wikidata":"https://www.wikidata.org/wiki/Q47089","display_name":"Fault (geology)","level":2,"score":0.5150318145751953},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.49224987626075745},{"id":"https://openalex.org/C169258074","wikidata":"https://www.wikidata.org/wiki/Q245748","display_name":"Random forest","level":2,"score":0.4189165234565735},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3500739336013794},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.0},{"id":"https://openalex.org/C165205528","wikidata":"https://www.wikidata.org/wiki/Q83371","display_name":"Seismology","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C172707124","wikidata":"https://www.wikidata.org/wiki/Q423488","display_name":"Actuator","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tse.2019.2944604","is_oa":true,"landing_page_url":"https://doi.org/10.1109/tse.2019.2944604","pdf_url":"https://ieeexplore.ieee.org/ielx7/32/9573514/08859280.pdf","source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1109/tse.2019.2944604","is_oa":true,"landing_page_url":"https://doi.org/10.1109/tse.2019.2944604","pdf_url":"https://ieeexplore.ieee.org/ielx7/32/9573514/08859280.pdf","source":{"id":"https://openalex.org/S8351582","display_name":"IEEE Transactions on Software Engineering","issn_l":"0098-5589","issn":["0098-5589","1939-3520","2326-3881"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Software Engineering","raw_type":"journal-article"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.6800000071525574}],"awards":[{"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/F4320310430","display_name":"TU Graz, Internationale Beziehungen und Mobilit\u00e4tsprogramme","ror":"https://ror.org/00d7xrm67"},{"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/W2979001501.pdf","grobid_xml":"https://content.openalex.org/works/W2979001501.grobid-xml"},"referenced_works_count":64,"referenced_works":["https://openalex.org/W649920412","https://openalex.org/W1531418056","https://openalex.org/W1540371141","https://openalex.org/W1575549743","https://openalex.org/W1579695396","https://openalex.org/W1594031697","https://openalex.org/W1659044373","https://openalex.org/W1880733898","https://openalex.org/W1889354467","https://openalex.org/W1933103375","https://openalex.org/W1980851144","https://openalex.org/W1987407028","https://openalex.org/W2006499508","https://openalex.org/W2007827093","https://openalex.org/W2010598806","https://openalex.org/W2022114557","https://openalex.org/W2038340833","https://openalex.org/W2044123923","https://openalex.org/W2047081748","https://openalex.org/W2053724458","https://openalex.org/W2074805796","https://openalex.org/W2080982416","https://openalex.org/W2083808198","https://openalex.org/W2088252378","https://openalex.org/W2097435116","https://openalex.org/W2101778378","https://openalex.org/W2119479037","https://openalex.org/W2119821739","https://openalex.org/W2135473121","https://openalex.org/W2142721770","https://openalex.org/W2144849164","https://openalex.org/W2152376725","https://openalex.org/W2156400118","https://openalex.org/W2160988203","https://openalex.org/W2333114708","https://openalex.org/W2405587341","https://openalex.org/W2464636023","https://openalex.org/W2487770199","https://openalex.org/W2548596251","https://openalex.org/W2554473058","https://openalex.org/W2564490203","https://openalex.org/W2577322449","https://openalex.org/W2596295962","https://openalex.org/W2744434042","https://openalex.org/W2796264185","https://openalex.org/W2803182674","https://openalex.org/W2895064676","https://openalex.org/W2898098214","https://openalex.org/W2898330888","https://openalex.org/W2911964244","https://openalex.org/W2998216295","https://openalex.org/W3105310331","https://openalex.org/W3216347977","https://openalex.org/W4239510810","https://openalex.org/W4249909277","https://openalex.org/W4285719527","https://openalex.org/W4382677476","https://openalex.org/W6632223008","https://openalex.org/W6634654583","https://openalex.org/W6637107664","https://openalex.org/W6639525157","https://openalex.org/W6675477322","https://openalex.org/W6713172940","https://openalex.org/W6735145758"],"related_works":["https://openalex.org/W4386259002","https://openalex.org/W3171520305","https://openalex.org/W1546989560","https://openalex.org/W3193043704","https://openalex.org/W1924178503","https://openalex.org/W4308716060","https://openalex.org/W4280648719","https://openalex.org/W3135126032","https://openalex.org/W3033346322","https://openalex.org/W3125561743"],"abstract_inverted_index":{"Electronic":[0],"spreadsheets":[1,19,34,159],"are":[2,20,108,166],"widely":[3],"used":[4],"in":[5,80,126,129,176,210],"organizations":[6],"for":[7,30,38,62],"various":[8],"data":[9,144],"analytics":[10],"and":[11,22,32,42],"decision-making":[12],"tasks.":[13],"Even":[14],"though":[15],"faults":[16],"within":[17],"such":[18,66],"common":[21],"can":[23],"have":[24],"significant":[25],"negative":[26],"consequences,":[27],"today's":[28],"tools":[29],"creating":[31],"handling":[33],"provide":[35],"limited":[36,123],"support":[37],"fault":[39,78,139],"detection,":[40],"localization,":[41],"repair.":[43],"Being":[44],"able":[45,179],"to":[46,77,111,137,180],"predict":[47],"whether":[48,185],"a":[49,53,74,113,170,186,190,205],"certain":[50],"part":[51],"of":[52,65,88,98,116,189,204],"spreadsheet":[54,81,89,148,191],"is":[55,59,175,192],"faulty":[56,158],"or":[57],"not":[58],"often":[60,167],"central":[61],"the":[63,99,172],"implementation":[64],"supporting":[67],"functionality.":[68],"In":[69],"this":[70],"work,":[71],"we":[72,132],"propose":[73],"novel":[75],"approach":[76,131],"prediction":[79],"formulas,":[82],"which":[83],"combines":[84],"an":[85],"extensive":[86],"catalog":[87,104],"metrics":[90,101,149],"with":[91],"modern":[92],"machine":[93],"learning":[94,135],"algorithms.":[95],"An":[96],"analysis":[97],"individual":[100],"from":[102,150],"our":[103,130,151],"reveals":[105],"that":[106,141,161],"they":[107],"generally":[109],"suited":[110],"discover":[112],"wide":[114],"range":[115],"faults.":[117],"Their":[118],"predictive":[119],"power":[120],"is,":[121],"however,":[122],"when":[124],"considered":[125],"isolation.":[127],"Therefore,":[128],"apply":[133],"supervised":[134],"algorithms":[136],"obtain":[138],"predictors":[140],"utilize":[142],"all":[143],"provided":[145],"by":[146],"multiple":[147],"catalog.":[152],"Experiments":[153],"on":[154],"different":[155],"datasets":[156],"containing":[157],"show":[160],"particularly":[162],"Random":[163],"Forests":[164],"classifiers":[165],"effective.":[168],"As":[169],"result,":[171],"proposed":[173],"method":[174],"many":[177],"cases":[178],"make":[181],"highly":[182],"accurate":[183],"predictions":[184],"given":[187],"formula":[188],"faulty.":[193],"<xref":[194,211],"ref-type=\"fn\"":[195],"rid=\"fn1\"":[196],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"":[197,201],"xmlns:xlink=\"http://www.w3.org/1999/xlink\"><sup>1</sup></xref>":[198],"<fn":[199],"id=\"fn1\"":[200],"xmlns:xlink=\"http://www.w3.org/1999/xlink\"><label>1.</label>":[202],"Results":[203],"preliminary":[206],"study":[207],"were":[208],"published":[209],"ref-type=\"bibr\"":[212],"rid=\"ref1\">[1]</xref>":[213],".":[214],"</fn>":[215]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":5}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}