{"id":"https://openalex.org/W4213086105","doi":"https://doi.org/10.1109/icse.2013.6606575","title":"Data clone detection and visualization in spreadsheets","display_name":"Data clone detection and visualization in spreadsheets","publication_year":2013,"publication_date":"2013-05-01","ids":{"openalex":"https://openalex.org/W4213086105","doi":"https://doi.org/10.1109/icse.2013.6606575"},"language":"en","primary_location":{"id":"doi:10.1109/icse.2013.6606575","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse.2013.6606575","pdf_url":null,"source":{"id":"https://openalex.org/S4363607951","display_name":"2013 35th International Conference on Software Engineering (ICSE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 35th International Conference on Software Engineering (ICSE)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://figshare.com/articles/Data_Clone_Detection_and_Visualization_in_Spreadsheets/94316","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5034150823","display_name":"Felienne Hermans","orcid":"https://orcid.org/0000-0003-0722-0156"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Felienne Hermans","raw_affiliation_strings":["Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022511801","display_name":"B.M.W. Sedee","orcid":null},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Ben Sedee","raw_affiliation_strings":["Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052107936","display_name":"Martin Pinzger","orcid":"https://orcid.org/0000-0002-5536-3859"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Martin Pinzger","raw_affiliation_strings":["Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5090401584","display_name":"Arie van Deursen","orcid":"https://orcid.org/0000-0003-4850-3312"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Arie van Deursen","raw_affiliation_strings":["Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands"],"affiliations":[{"raw_affiliation_string":"Software Engineering Research Group, Delft University of Technology, Infotron, Netherlands","institution_ids":["https://openalex.org/I98358874"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5034150823"],"corresponding_institution_ids":["https://openalex.org/I98358874"],"apc_list":null,"apc_paid":null,"fwci":2.6236,"has_fulltext":true,"cited_by_count":30,"citation_normalized_percentile":{"value":0.91266376,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"292","last_page":"301"},"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.9998000264167786,"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.9998000264167786,"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.989300012588501,"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9800000190734863,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"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.8025492429733276},{"id":"https://openalex.org/keywords/clone","display_name":"clone (Java method)","score":0.8012033700942993},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.7397735714912415},{"id":"https://openalex.org/keywords/cloning","display_name":"Cloning (programming)","score":0.665040135383606},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.527606725692749},{"id":"https://openalex.org/keywords/plain-text","display_name":"Plain text","score":0.48674964904785156},{"id":"https://openalex.org/keywords/data-visualization","display_name":"Data visualization","score":0.4791666567325592},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.34425482153892517},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2899492084980011},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.08952057361602783}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8025492429733276},{"id":"https://openalex.org/C81089528","wikidata":"https://www.wikidata.org/wiki/Q5134986","display_name":"clone (Java method)","level":3,"score":0.8012033700942993},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.7397735714912415},{"id":"https://openalex.org/C121050878","wikidata":"https://www.wikidata.org/wiki/Q5135020","display_name":"Cloning (programming)","level":2,"score":0.665040135383606},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.527606725692749},{"id":"https://openalex.org/C46503548","wikidata":"https://www.wikidata.org/wiki/Q1145976","display_name":"Plain text","level":3,"score":0.48674964904785156},{"id":"https://openalex.org/C172367668","wikidata":"https://www.wikidata.org/wiki/Q6504956","display_name":"Data visualization","level":3,"score":0.4791666567325592},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.34425482153892517},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2899492084980011},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.08952057361602783},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.0},{"id":"https://openalex.org/C552990157","wikidata":"https://www.wikidata.org/wiki/Q7430","display_name":"DNA","level":2,"score":0.0},{"id":"https://openalex.org/C54355233","wikidata":"https://www.wikidata.org/wiki/Q7162","display_name":"Genetics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/icse.2013.6606575","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icse.2013.6606575","pdf_url":null,"source":{"id":"https://openalex.org/S4363607951","display_name":"2013 35th International Conference on Software Engineering (ICSE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2013 35th International Conference on Software Engineering (ICSE)","raw_type":"proceedings-article"},{"id":"pmh:oai:figshare.com:article/94316","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Data_Clone_Detection_and_Visualization_in_Spreadsheets/94316","pdf_url":"https://figshare.com/articles/Data_Clone_Detection_and_Visualization_in_Spreadsheets/94316","source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},{"id":"doi:10.6084/m9.figshare.94316.v1","is_oa":true,"landing_page_url":"https://doi.org/10.6084/m9.figshare.94316.v1","pdf_url":null,"source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"pmh:oai:figshare.com:article/94316","is_oa":true,"landing_page_url":"https://figshare.com/articles/journal_contribution/Data_Clone_Detection_and_Visualization_in_Spreadsheets/94316","pdf_url":"https://figshare.com/articles/Data_Clone_Detection_and_Visualization_in_Spreadsheets/94316","source":{"id":"https://openalex.org/S4377196282","display_name":"Figshare","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210132348","host_organization_name":"Figshare (United Kingdom)","host_organization_lineage":["https://openalex.org/I4210132348"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Text"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.6000000238418579}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4213086105.pdf","grobid_xml":"https://content.openalex.org/works/W4213086105.grobid-xml"},"referenced_works_count":44,"referenced_works":["https://openalex.org/W1497542708","https://openalex.org/W1512285202","https://openalex.org/W1515921409","https://openalex.org/W1531418056","https://openalex.org/W1551326568","https://openalex.org/W1558974199","https://openalex.org/W1593203335","https://openalex.org/W1644311900","https://openalex.org/W1698439592","https://openalex.org/W1808011207","https://openalex.org/W1970665021","https://openalex.org/W1994462700","https://openalex.org/W2019628947","https://openalex.org/W2020168614","https://openalex.org/W2072632642","https://openalex.org/W2080982416","https://openalex.org/W2090432523","https://openalex.org/W2096491586","https://openalex.org/W2101832700","https://openalex.org/W2109943392","https://openalex.org/W2115534035","https://openalex.org/W2119391892","https://openalex.org/W2119887272","https://openalex.org/W2123718358","https://openalex.org/W2124991517","https://openalex.org/W2128698639","https://openalex.org/W2129723764","https://openalex.org/W2134329651","https://openalex.org/W2135473121","https://openalex.org/W2138633813","https://openalex.org/W2138756793","https://openalex.org/W2157532207","https://openalex.org/W2159433976","https://openalex.org/W2169917840","https://openalex.org/W4232881974","https://openalex.org/W4247488451","https://openalex.org/W4394258353","https://openalex.org/W6629801835","https://openalex.org/W6629828802","https://openalex.org/W6630818679","https://openalex.org/W6635419185","https://openalex.org/W6636887936","https://openalex.org/W6677442436","https://openalex.org/W6863752994"],"related_works":["https://openalex.org/W1987653914","https://openalex.org/W2325518922","https://openalex.org/W2410849822","https://openalex.org/W2126967698","https://openalex.org/W4225274103","https://openalex.org/W2013728941","https://openalex.org/W2154046714","https://openalex.org/W2579659702","https://openalex.org/W2189613078","https://openalex.org/W1574055964"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,20,73,124],"widely":[2],"used":[3],"in":[4,50,68,78,97,140],"industry:":[5],"it":[6],"is":[7,38],"estimated":[8],"that":[9,120],"end-user":[10],"programmers":[11,13],"outnumber":[12],"by":[14],"a":[15,79,105],"factor":[16],"5.":[17],"However,":[18],"spreadsheets":[19],"error-prone,":[21],"numerous":[22],"companies":[23],"have":[24,60],"lost":[25],"money":[26],"because":[27],"of":[28,32,41,86,109,115],"spreadsheet":[29,36,132],"errors.":[30],"One":[31],"the":[33,39,84,87,101,116],"causes":[34],"for":[35],"problems":[37],"prevalence":[40],"copy-pasting.":[42],"In":[43],"this":[44,48],"paper,":[45],"we":[46,59,90,99],"study":[47],"cloning":[49],"spreadsheets.":[51],"Based":[52],"on":[53],"existing":[54],"text-based":[55],"clone":[56],"detection":[57],"algorithms,":[58],"developed":[61],"an":[62],"algorithm":[63],"to":[64,131],"detect":[65],"data":[66,122,127,144],"clones":[67,123,128],"spreadsheets:":[69],"formulas":[70],"whose":[71],"values":[72],"copied":[74],"as":[75],"plain":[76],"text":[77],"different":[80],"location.":[81],"To":[82],"evaluate":[83],"usefulness":[85],"proposed":[88],"approach,":[89],"conducted":[91],"two":[92,110],"evaluations.":[93],"A":[94],"quantitative":[95],"evaluation":[96,107,117],"which":[98],"analyzed":[100],"EUSES":[102],"corpus":[103],"and":[104,134,142],"qualitative":[106],"consisting":[108],"case":[111],"studies.":[112],"The":[113],"results":[114],"clearly":[118],"indicate":[119],"1)":[121],"common,":[125],"2)":[126],"pose":[129],"threats":[130],"quality":[133],"3)":[135],"our":[136],"approach":[137],"supports":[138],"users":[139],"finding":[141],"resolving":[143],"clones.":[145]},"counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":4}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}