{"id":"https://openalex.org/W2898211431","doi":"https://doi.org/10.1109/vlhcc.2018.8506584","title":"Calculation View: multiple-representation editing in spreadsheets","display_name":"Calculation View: multiple-representation editing in spreadsheets","publication_year":2018,"publication_date":"2018-10-01","ids":{"openalex":"https://openalex.org/W2898211431","doi":"https://doi.org/10.1109/vlhcc.2018.8506584","mag":"2898211431"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2018.8506584","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2018.8506584","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.research.ed.ac.uk/en/publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5025427198","display_name":"Advait Sarkar","orcid":"https://orcid.org/0000-0002-5401-3478"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Advait Sarkar","raw_affiliation_strings":["Microsoft Research, Cambridge, United Kingdom"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078684560","display_name":"Andrew D. Gordon","orcid":"https://orcid.org/0000-0002-5809-2484"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Andrew D. Gordon","raw_affiliation_strings":["Microsoft Research, Cambridge, United Kingdom"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027817074","display_name":"Simon Peyton Jones","orcid":"https://orcid.org/0000-0002-6085-1435"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Simon Peyton Jones","raw_affiliation_strings":["Microsoft Research, Cambridge, United Kingdom"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034639850","display_name":"Neil Toronto","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Neil Toronto","raw_affiliation_strings":["Microsoft Research, Cambridge, United Kingdom"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5025427198"],"corresponding_institution_ids":["https://openalex.org/I4210164937"],"apc_list":null,"apc_paid":null,"fwci":2.7776,"has_fulltext":true,"cited_by_count":24,"citation_normalized_percentile":{"value":0.91500904,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"85","last_page":"93"},"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.9998999834060669,"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.9998999834060669,"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/T11875","display_name":"Statistics Education and Methodologies","score":0.9663000106811523,"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"}},{"id":"https://openalex.org/T11704","display_name":"Mobile Crowdsensing and Crowdsourcing","score":0.9164999723434448,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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.863250195980072},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.8324857950210571},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.6632281541824341},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.6614192724227905},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.5976824164390564},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5649670958518982},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.4628891348838806},{"id":"https://openalex.org/keywords/grid","display_name":"Grid","score":0.42217403650283813},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.40009772777557373},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.37993744015693665},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.248824805021286}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.863250195980072},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.8324857950210571},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.6632281541824341},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.6614192724227905},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.5976824164390564},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5649670958518982},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4628891348838806},{"id":"https://openalex.org/C187691185","wikidata":"https://www.wikidata.org/wiki/Q2020720","display_name":"Grid","level":2,"score":0.42217403650283813},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.40009772777557373},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.37993744015693665},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.248824805021286},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/vlhcc.2018.8506584","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2018.8506584","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2018 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.ed.ac.uk:publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11820/3f2a7757-d77d-4bec-a9ae-83cb905c5151","pdf_url":"https://www.research.ed.ac.uk/en/publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""},{"id":"pmh:oai:pure.ed.ac.uk:openaire/3f2a7757-d77d-4bec-a9ae-83cb905c5151","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sarkar, A, Gordon, A D, Jones, S P & Toronto, N 2018, Calculation View: multiple-representation editing in spreadsheets. in 2018 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC). Institute of Electrical and Electronics Engineers, Lisbon, Portugal, pp. 85-93. https://doi.org/10.1109/VLHCC.2018.8506584","raw_type":"contributionToPeriodical"}],"best_oa_location":{"id":"pmh:oai:pure.ed.ac.uk:publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11820/3f2a7757-d77d-4bec-a9ae-83cb905c5151","pdf_url":"https://www.research.ed.ac.uk/en/publications/3f2a7757-d77d-4bec-a9ae-83cb905c5151","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","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":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/1","score":0.5600000023841858,"display_name":"No poverty"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2898211431.pdf","grobid_xml":"https://content.openalex.org/works/W2898211431.grobid-xml"},"referenced_works_count":41,"referenced_works":["https://openalex.org/W849151795","https://openalex.org/W1531418056","https://openalex.org/W1551326568","https://openalex.org/W1899639145","https://openalex.org/W1969600276","https://openalex.org/W1974503980","https://openalex.org/W1996473305","https://openalex.org/W2000616678","https://openalex.org/W2001027630","https://openalex.org/W2064189581","https://openalex.org/W2072267223","https://openalex.org/W2084944215","https://openalex.org/W2090639318","https://openalex.org/W2093987194","https://openalex.org/W2108906160","https://openalex.org/W2111469656","https://openalex.org/W2112338634","https://openalex.org/W2119723190","https://openalex.org/W2126512988","https://openalex.org/W2144849164","https://openalex.org/W2150771261","https://openalex.org/W2153887189","https://openalex.org/W2156400118","https://openalex.org/W2157289187","https://openalex.org/W2165717273","https://openalex.org/W2172240163","https://openalex.org/W2199134679","https://openalex.org/W2404721232","https://openalex.org/W2407252599","https://openalex.org/W2407992198","https://openalex.org/W2551517045","https://openalex.org/W2596295962","https://openalex.org/W2770982456","https://openalex.org/W2891983174","https://openalex.org/W2963461588","https://openalex.org/W4231799929","https://openalex.org/W4251337333","https://openalex.org/W4252113818","https://openalex.org/W6729141015","https://openalex.org/W6747046034","https://openalex.org/W6754352043"],"related_works":["https://openalex.org/W1578053891","https://openalex.org/W1987935534","https://openalex.org/W1483845062","https://openalex.org/W2120071210","https://openalex.org/W1601811574","https://openalex.org/W1587224678","https://openalex.org/W1498982577","https://openalex.org/W4246531319","https://openalex.org/W3160136729","https://openalex.org/W2591945988"],"abstract_inverted_index":{"Spreadsheet":[0],"errors":[1,17],"are":[2],"ubiquitous":[3],"and":[4,90,101],"costly,":[5],"an":[6],"unfortunate":[7],"combination":[8],"that":[9,55,75],"is":[10],"well-reported.":[11],"A":[12],"large":[13],"class":[14],"of":[15,78,98,108],"these":[16],"can":[18,81],"be":[19],"attributed":[20],"to":[21,24],"the":[22,27,61,76],"inability":[23],"clearly":[25],"see":[26],"underlying":[28],"computational":[29],"structure,":[30],"as":[31,33],"well":[32],"poor":[34],"support":[35],"for":[36,105],"abstraction":[37],"(encapsulation,":[38],"re-use,":[39],"etc).":[40],"In":[41],"this":[42,106],"paper":[43],"we":[44,73],"propose":[45],"a":[46,49,70,96],"novel":[47],"solution:":[48],"multiple-representation":[50],"spreadsheet":[51,88],"containing":[52],"additional":[53],"representations":[54,80],"allow":[56],"abstract":[57],"operations,":[58],"without":[59],"altering":[60],"conventional":[62],"grid":[63],"representation":[64],"or":[65],"its":[66],"formula":[67],"syntax.":[68],"Through":[69],"user":[71,84],"study,":[72],"demonstrate":[74],"use":[77],"multiple":[79],"significantly":[82],"improve":[83],"performance":[85],"when":[86],"performing":[87],"authoring":[89],"debugging":[91],"tasks.":[92],"We":[93],"close":[94],"with":[95],"discussion":[97],"design":[99],"implications":[100],"outline":[102],"future":[103],"directions":[104],"line":[107],"inquiry.":[109]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":3}],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}