{"id":"https://openalex.org/W2803182674","doi":"https://doi.org/10.1145/3183399.3183402","title":"Combining spreadsheet smells for improved fault prediction","display_name":"Combining spreadsheet smells for improved fault prediction","publication_year":2018,"publication_date":"2018-05-27","ids":{"openalex":"https://openalex.org/W2803182674","doi":"https://doi.org/10.1145/3183399.3183402","mag":"2803182674"},"language":"en","primary_location":{"id":"doi:10.1145/3183399.3183402","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183399.3183402","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183399.3183402","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th International Conference on Software Engineering: New Ideas and Emerging Results","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3183399.3183402","any_repository_has_fulltext":true},"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, Austria"],"affiliations":[{"raw_affiliation_string":"AAU 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, Austria"],"affiliations":[{"raw_affiliation_string":"AAU 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, Austria"],"affiliations":[{"raw_affiliation_string":"AAU 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":["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/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"]}]},{"author_position":"last","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, Germany"],"affiliations":[{"raw_affiliation_string":"TU Dortmund, Germany","institution_ids":["https://openalex.org/I200332995"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5073809674"],"corresponding_institution_ids":["https://openalex.org/I4210166741"],"apc_list":null,"apc_paid":null,"fwci":0.9182,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.77069553,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"25","last_page":"28"},"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.9997000098228455,"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.9997000098228455,"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/T10260","display_name":"Software Engineering Research","score":0.9983999729156494,"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"}},{"id":"https://openalex.org/T12423","display_name":"Software Reliability and Analysis Research","score":0.9746999740600586,"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/code-smell","display_name":"Code smell","score":0.761724591255188},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7551308870315552},{"id":"https://openalex.org/keywords/classifier","display_name":"Classifier (UML)","score":0.5991929173469543},{"id":"https://openalex.org/keywords/adaboost","display_name":"AdaBoost","score":0.569955050945282},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.5182352066040039},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5060905814170837},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.49376019835472107},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.46673429012298584},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.39862316846847534},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3422505259513855},{"id":"https://openalex.org/keywords/software-quality","display_name":"Software quality","score":0.3281264901161194},{"id":"https://openalex.org/keywords/software-development","display_name":"Software development","score":0.244145929813385},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.1719588041305542},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.13977044820785522},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.0809779167175293}],"concepts":[{"id":"https://openalex.org/C133237599","wikidata":"https://www.wikidata.org/wiki/Q2295111","display_name":"Code smell","level":5,"score":0.761724591255188},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7551308870315552},{"id":"https://openalex.org/C95623464","wikidata":"https://www.wikidata.org/wiki/Q1096149","display_name":"Classifier (UML)","level":2,"score":0.5991929173469543},{"id":"https://openalex.org/C141404830","wikidata":"https://www.wikidata.org/wiki/Q2823869","display_name":"AdaBoost","level":3,"score":0.569955050945282},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.5182352066040039},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5060905814170837},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.49376019835472107},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.46673429012298584},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.39862316846847534},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3422505259513855},{"id":"https://openalex.org/C117447612","wikidata":"https://www.wikidata.org/wiki/Q1412670","display_name":"Software quality","level":4,"score":0.3281264901161194},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.244145929813385},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1719588041305542},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.13977044820785522},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.0809779167175293}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3183399.3183402","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183399.3183402","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183399.3183402","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th International Conference on Software Engineering: New Ideas and Emerging Results","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1805.10493","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1805.10493","pdf_url":"https://arxiv.org/pdf/1805.10493","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/3183399.3183402","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3183399.3183402","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3183399.3183402","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th International Conference on Software Engineering: New Ideas and Emerging Results","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.7699999809265137,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"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/G5106512922","display_name":null,"funder_award_id":"Deutsche Forschungsgemeinschaft (DFG","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6024419964","display_name":null,"funder_award_id":"Deutsche Forschungsgemeinschaft (DFG)","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6052429835","display_name":null,"funder_award_id":"(DFG)","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6783783255","display_name":null,"funder_award_id":"number","funder_id":"https://openalex.org/F4320321181","funder_display_name":"Austrian Science Fund"},{"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/W2803182674.pdf","grobid_xml":"https://content.openalex.org/works/W2803182674.grobid-xml"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W114517082","https://openalex.org/W649920412","https://openalex.org/W1531418056","https://openalex.org/W1534477342","https://openalex.org/W1579695396","https://openalex.org/W1933103375","https://openalex.org/W1987407028","https://openalex.org/W1988997230","https://openalex.org/W2022114557","https://openalex.org/W2038340833","https://openalex.org/W2080982416","https://openalex.org/W2145073242","https://openalex.org/W2153887189","https://openalex.org/W2156400118","https://openalex.org/W2554473058","https://openalex.org/W2564490203","https://openalex.org/W2577322449","https://openalex.org/W2596295962","https://openalex.org/W2744434042","https://openalex.org/W4234117503","https://openalex.org/W6681651645"],"related_works":["https://openalex.org/W3134933787","https://openalex.org/W3116338676","https://openalex.org/W2786648929","https://openalex.org/W2774816643","https://openalex.org/W4286793953","https://openalex.org/W2806610047","https://openalex.org/W2031808517","https://openalex.org/W2950234014","https://openalex.org/W4205203654","https://openalex.org/W2935052825"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1],"commonly":[2],"used":[3,53],"in":[4,18,38,50,114],"organizations":[5],"as":[6],"a":[7,25,84],"programming":[8],"tool":[9],"for":[10,54],"business-related":[11],"calculations":[12],"and":[13],"decision":[14],"making.":[15],"Since":[16],"faults":[17,110],"spreadsheets":[19,37],"can":[20,49,75],"have":[21,33],"severe":[22],"business":[23],"impacts,":[24],"number":[26],"of":[27,45,57,62,72,93,116],"approaches":[28],"from":[29],"general":[30],"software":[31],"engineering":[32],"been":[34],"applied":[35],"to":[36],"recent":[39],"years,":[40],"among":[41],"them":[42],"the":[43,55,69,91],"concept":[44],"code":[46],"smells.":[47],"Smells":[48],"particular":[51],"be":[52,76],"task":[56],"fault":[58,117],"prediction.":[59],"An":[60],"analysis":[61],"existing":[63],"spreadsheet":[64,109],"smells,":[65],"however,":[66],"revealed":[67],"that":[68],"predictive":[70],"power":[71],"individual":[73,94],"smells":[74,95],"limited.":[77],"In":[78],"this":[79],"work":[80],"we":[81],"therefore":[82],"propose":[83],"machine":[85],"learning":[86],"based":[87],"approach":[88],"which":[89],"combines":[90],"predictions":[92],"by":[96],"using":[97],"an":[98],"AdaBoost":[99],"ensemble":[100],"classifier.":[101],"Experiments":[102],"on":[103],"two":[104],"public":[105],"datasets":[106],"containing":[107],"real-world":[108],"show":[111],"significant":[112],"improvements":[113],"terms":[115],"prediction":[118],"accuracy.":[119]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}