{"id":"https://openalex.org/W2192907926","doi":null,"title":"Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas","display_name":"Tool-assisted Spreadsheet Refactoring and Parsing Spreadsheet Formulas","alternate_titles":[],"publication_year":2015,"publication_date":"2015-11-17","ids":{"openalex":"https://openalex.org/W2192907926","mag":"2192907926"},"language":"en","primary_location":{"id":"pmh:oai:tudelft.nl:uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"master thesis"},"parent_works":[],"lineage":["https://openalex.org/W2192907926"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://resolver.tudelft.nl/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5089527566","display_name":"David Hoepelman","orcid":"https://orcid.org/0000-0002-8891-651X","observed_orcids":["https://orcid.org/0000-0002-8891-651X"]},"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,"contributor_roles":[],"raw_author_name":"David Hoepelman","raw_affiliation_strings":["Faculty Electrical Engineering, Mathematics and Computer Science (EEMCS), Delft University of Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Faculty Electrical Engineering, Mathematics and Computer Science (EEMCS), Delft University of Technology","institution_ids":["https://openalex.org/I98358874"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5089527566"],"corresponding_institution_ids":["https://openalex.org/I98358874"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":3,"reviewed_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9340999722480774,"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.9340999722480774,"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.06459999829530716,"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/T11450","display_name":"Model-Driven Software Engineering Techniques","score":9.999999747378752e-05,"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/spreadsheet-formulas","display_name":"spreadsheet formulas","score":0.7749999761581421},{"id":"https://openalex.org/keywords/bumblebees","display_name":"bumblebees","score":0.9739999771118164},{"id":"https://openalex.org/keywords/technical-debt","display_name":"technical debt","score":0.8100000023841858}],"concepts":[{"id":"https://openalex.org/C152752567","wikidata":"https://www.wikidata.org/wiki/Q116877","display_name":"Code refactoring","level":3,"score":0.9726086854934692},{"id":"https://openalex.org/C186644900","wikidata":"https://www.wikidata.org/wiki/Q194152","display_name":"Parsing","level":2,"score":0.805419921875},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7547692060470581},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.6019598841667175},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5880669355392456},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5765235424041748},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.543782114982605},{"id":"https://openalex.org/C26713055","wikidata":"https://www.wikidata.org/wiki/Q245962","display_name":"Implementation","level":2,"score":0.4521867632865906},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:tudelft.nl:uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"master thesis"},{"id":"mag:2192907926","doi":null,"is_oa":false,"landing_page_url":"http://repository.tudelft.nl/assets/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e/Tool-assisted_Spreadsheet_Refactoring_and_Parsing_Spreadsheet_Formulas.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":{"id":"pmh:oai:tudelft.nl:uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","doi":null,"is_oa":true,"landing_page_url":"http://resolver.tudelft.nl/uuid:d9d802af-9ebf-4524-9dbc-e7657d67921e","pdf_url":null,"source":{"id":"https://openalex.org/S4306400906","display_name":"Research Repository (Delft University of Technology)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I98358874","host_organization_name":"Delft University of Technology","host_organization_lineage":["https://openalex.org/I98358874"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"master thesis"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2192907926.pdf","grobid_xml":"https://content.openalex.org/works/W2192907926.grobid-xml"},"referenced_works_count":45,"referenced_works":["https://openalex.org/W1491178396","https://openalex.org/W1494112706","https://openalex.org/W1497777582","https://openalex.org/W1508262334","https://openalex.org/W1525153939","https://openalex.org/W1529704888","https://openalex.org/W1530063962","https://openalex.org/W1531418056","https://openalex.org/W1536104708","https://openalex.org/W1537955876","https://openalex.org/W1571341547","https://openalex.org/W1603920809","https://openalex.org/W1633494755","https://openalex.org/W1808011207","https://openalex.org/W1933103375","https://openalex.org/W1969600276","https://openalex.org/W1970665021","https://openalex.org/W1987407028","https://openalex.org/W1996473305","https://openalex.org/W2006426998","https://openalex.org/W2020168614","https://openalex.org/W2026539153","https://openalex.org/W2038340833","https://openalex.org/W2060404275","https://openalex.org/W2084671376","https://openalex.org/W2104937662","https://openalex.org/W2110825407","https://openalex.org/W2112338634","https://openalex.org/W2113815657","https://openalex.org/W2119723190","https://openalex.org/W2120407951","https://openalex.org/W2129723764","https://openalex.org/W2135473121","https://openalex.org/W2144849164","https://openalex.org/W2149107096","https://openalex.org/W2151458388","https://openalex.org/W2151867683","https://openalex.org/W2153887189","https://openalex.org/W2156400118","https://openalex.org/W2157800877","https://openalex.org/W2166549982","https://openalex.org/W2171561334","https://openalex.org/W3087962165","https://openalex.org/W3148828430","https://openalex.org/W4251337333"],"related_works":["https://openalex.org/W2151867683","https://openalex.org/W2026539153","https://openalex.org/W1986951253","https://openalex.org/W2144849164","https://openalex.org/W2751057302","https://openalex.org/W3037603623","https://openalex.org/W3166878122","https://openalex.org/W2963461588","https://openalex.org/W2346724833","https://openalex.org/W6920795264"],"abstract_inverted_index":{"Spreadsheets":[0],"have":[1],"a":[2,149,162],"life-cycle":[3],"similar":[4],"to":[5,25,31,43,60],"that":[6],"of":[7,70],"other":[8],"software:":[9],"they":[10],"are":[11,16],"inherited":[12],"throughout":[13],"an":[14,67],"organization,":[15],"maintained":[17],"by":[18,47],"different":[19],"users,":[20],"and":[21,34,91,100,109,112,124,139,169],"evolve":[22],"over":[23],"time":[24],"meet":[26],"changing":[27],"requirements.":[28],"This":[29,54],"leads":[30],"increased":[32],"complexity":[33],"technical":[35],"debt.":[36],"In":[37,62],"software":[38,49,146],"engineering,":[39],"refactoring":[40,73],"is":[41],"used":[42,132],"combat":[44],"these":[45,122,137],"problems":[46],"improving":[48],"structure":[50],"without":[51],"altering":[52],"behavior.":[53],"technique":[55],"can":[56],"also":[57],"be":[58],"applied":[59],"spreadsheets.":[61],"this":[63],"thesis":[64],"we":[65],"present":[66],"improved":[68],"version":[69],"the":[71,129,141,144],"spreadsheet":[72,127,154],"tool":[74],"BumbleBee,":[75],"extended":[76],"with":[77],"six":[78],"refactorings:":[79],"Extract":[80,110],"Formula,":[81,83,97],"Inline":[82,96],"Introduce":[84,89,92,101,113],"Cell":[85,114],"Name,":[86],"Group":[87,98],"References,":[88],"Aggregate":[90,103],"Conditional":[93,102],"Aggregate.":[94],"The":[95],"References":[99],"refactorings":[104,123],"were":[105],"not":[106],"implemented":[107,136],"before":[108],"Formula":[111],"Name":[115],"improve":[116],"upon":[117],"previous":[118],"implementations.":[119],"To":[120],"support":[121],"facilitate":[125],"future":[126],"research":[128],"formula":[130],"parser":[131,152],"needed":[133],"improvements.":[134],"We":[135],"improvements":[138],"released":[140],"result":[142],"as":[143],"open-source":[145],"package":[147],"XLParser,":[148],"stand-alone":[150],"C#":[151],"for":[153],"formulas.":[155],"XLParser":[156],"was":[157],"evaluated":[158],"on":[159],"more":[160],"than":[161],"million":[163],"unique":[164],"formulas":[165],"from":[166],"industrial":[167],"datasets,":[168],"successfully":[170],"parsed":[171],"99.999%.":[172]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2192907926","counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2016,"cited_by_count":2}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
