{"id":"https://openalex.org/W3034572698","doi":"https://doi.org/10.48550/arxiv.2006.04794","title":"Abstracting spreadsheet data flow through hypergraph redrawing","display_name":"Abstracting spreadsheet data flow through hypergraph redrawing","publication_year":2020,"publication_date":"2020-06-04","ids":{"openalex":"https://openalex.org/W3034572698","doi":"https://doi.org/10.48550/arxiv.2006.04794","mag":"3034572698"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2006.04794","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2006.04794","pdf_url":"https://arxiv.org/pdf/2006.04794","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},"volume":null,"type":"conference-abstract","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2006.04794","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5021871771","display_name":"David Birch","orcid":"https://orcid.org/0000-0001-5347-8700","observed_orcids":["https://orcid.org/0000-0001-5347-8700"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Birch, David","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004711123","display_name":"Nicolai Stawinoga","orcid":"https://orcid.org/0000-0002-3806-2691","observed_orcids":["https://orcid.org/0000-0002-3806-2691"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Stawinoga, Nicolai","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Binks, Jack","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Binks, Jack","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087500854","display_name":"Bruno Nicoletti","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nicoletti, Bruno","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5000319133","display_name":"Paul H. J. Kelly","orcid":"https://orcid.org/0000-0001-5905-1804","observed_orcids":["https://orcid.org/0000-0001-5905-1804"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kelly, Paul","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_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_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9970999956130981,"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.9970999956130981,"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/T10799","display_name":"Data Visualization and Analytics","score":0.0012000000569969416,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.0005000000237487257,"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/spreadsheet-errors","display_name":"spreadsheet errors","score":0.6359999775886536},{"id":"https://openalex.org/keywords/graph-transformation","display_name":"graph transformation","score":0.4440000057220459},{"id":"https://openalex.org/keywords/array-operations","display_name":"array operations","score":0.6119999885559082},{"id":"https://openalex.org/keywords/end-user-programming","display_name":"end-user programming","score":0.4869999885559082},{"id":"https://openalex.org/keywords/mental-models","display_name":"mental models","score":0.4699999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7963614463806152},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.6563502550125122},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.6475977897644043},{"id":"https://openalex.org/C2781018962","wikidata":"https://www.wikidata.org/wiki/Q5164884","display_name":"Container (type theory)","level":2,"score":0.61506187915802},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5404511094093323},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5352305769920349},{"id":"https://openalex.org/C2781221856","wikidata":"https://www.wikidata.org/wiki/Q840247","display_name":"Hypergraph","level":2,"score":0.5302303433418274},{"id":"https://openalex.org/C57691317","wikidata":"https://www.wikidata.org/wiki/Q1289248","display_name":"Scalar (mathematics)","level":2,"score":0.49186205863952637},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4787287414073944},{"id":"https://openalex.org/C62354387","wikidata":"https://www.wikidata.org/wiki/Q875399","display_name":"Boundary (topology)","level":2,"score":0.4551548659801483},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4455731213092804},{"id":"https://openalex.org/C31266012","wikidata":"https://www.wikidata.org/wiki/Q6554340","display_name":"Linkage (software)","level":3,"score":0.41365110874176025},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.39484792947769165},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3896749019622803},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36474376916885376},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.12517884373664856},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2006.04794","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2006.04794","pdf_url":"https://arxiv.org/pdf/2006.04794","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},{"id":"doi:10.48550/arxiv.2006.04794","doi":"https://doi.org/10.48550/arxiv.2006.04794","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2006.04794","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2006.04794","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2006.04794","pdf_url":"https://arxiv.org/pdf/2006.04794","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G774180880","display_name":null,"funder_award_id":"EP/P010040/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1494112706","https://openalex.org/W1643333174","https://openalex.org/W2028695285","https://openalex.org/W2032969662","https://openalex.org/W2065602053","https://openalex.org/W2111469656","https://openalex.org/W2112338634","https://openalex.org/W2115647291","https://openalex.org/W2129232680","https://openalex.org/W2149107096","https://openalex.org/W2320036734","https://openalex.org/W2550378979","https://openalex.org/W2618604729","https://openalex.org/W2736694534","https://openalex.org/W2787509493","https://openalex.org/W2898211431","https://openalex.org/W2950198459","https://openalex.org/W2963116929"],"related_works":["https://openalex.org/W4376608589","https://openalex.org/W1537073411","https://openalex.org/W3138003926","https://openalex.org/W1630514295","https://openalex.org/W4300037846","https://openalex.org/W4288275998","https://openalex.org/W2963081352","https://openalex.org/W4376608938","https://openalex.org/W2472555608","https://openalex.org/W4214498971"],"abstract_inverted_index":{"We":[0,170],"believe":[1],"the":[2,65,79,87,90,94,142,165,179,185],"error":[3],"prone":[4],"nature":[5],"of":[6,15,77,81,83,89,125,141,181,187],"traditional":[7],"spreadsheets":[8,84,100],"is":[9],"due":[10],"to":[11,22,43,49,135,151,155],"their":[12,24,45],"low":[13,28],"level":[14,29,80,139,158],"abstraction.":[16],"End":[17],"user":[18],"programmers":[19],"are":[20,55,69,111],"forced":[21],"construct":[23],"data":[25,36],"models":[26],"from":[27],"cells":[30,54,131],"which":[31,160],"we":[32,98,144],"define":[33],"as":[34,108,114],"\"a":[35],"container":[37],"or":[38],"manipulator":[39],"linked":[40],"by":[41,85,117],"user-intent":[42],"model":[44,140],"world":[46],"and":[47,64,106,134,178],"positioned":[48],"reflect":[50],"its":[51],"structure\".":[52],"Spreadsheet":[53],"limited":[56],"in":[57],"what":[58,130],"they":[59],"may":[60,132],"contain":[61,133],"(scalar":[62],"values)":[63],"links":[66],"between":[67],"them":[68],"inherently":[70],"hidden.":[71],"This":[72],"paper":[73],"proposes":[74],"a":[75,119,123,137],"method":[76],"raising":[78],"abstraction":[82],"\"redrawing":[86],"boundary\"":[88],"cell.":[91],"To":[92,128],"expose":[93],"hidden":[95],"linkage":[96],"structure":[97],"transform":[99],"into":[101],"fine-grained":[102],"graphs":[103],"with":[104],"operators":[105],"values":[107],"nodes.":[109,127],"\"cells\"":[110,159],"then":[112],"represented":[113],"hypergraph":[115],"edges":[116],"drawing":[118],"boundary":[120],"\"wall\"":[121],"around":[122],"set":[124],"operator/data":[126],"extend":[129],"create":[136,156],"higher":[138,157],"spreadsheet":[143],"propose":[145],"that":[146],"researchers":[147],"should":[148],"seek":[149],"techniques":[150],"redraw":[152],"these":[153],"boundaries":[154],"will":[161],"more":[162],"faithfully":[163],"represent":[164],"end-user's":[166],"real":[167],"world/mental":[168],"model.":[169],"illustrate":[171],"this":[172],"approach":[173],"via":[174],"common":[175],"sub-expression":[176],"identification":[177],"application":[180],"sub-tree":[182],"isomorphisms":[183],"for":[184],"detection":[186],"vector":[188],"(array)":[189],"operations.":[190]},"counts_by_year":[],"updated_date":"2026-10-02T10:15:12.560889","created_date":"2025-10-10T00:00:00"}