{"id":"https://openalex.org/W4292261888","doi":"https://doi.org/10.1109/vl/hcc53370.2022.9833131","title":"End-user encounters with lambda abstraction in spreadsheets: Apollo\u2019s bow or Achilles\u2019 heel?","display_name":"End-user encounters with lambda abstraction in spreadsheets: Apollo\u2019s bow or Achilles\u2019 heel?","publication_year":2022,"publication_date":"2022-08-17","ids":{"openalex":"https://openalex.org/W4292261888","doi":"https://doi.org/10.1109/vl/hcc53370.2022.9833131"},"language":"en","primary_location":{"id":"doi:10.1109/vl/hcc53370.2022.9833131","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vl/hcc53370.2022.9833131","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"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/I241749","display_name":"University of Cambridge","ror":"https://ror.org/013meh722","country_code":"GB","type":"education","lineage":["https://openalex.org/I241749"]},{"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":"Advait Sarkar","raw_affiliation_strings":["Microsoft Research,Cambridge,United Kingdom","Microsoft Research, Cambridge, United Kingdom","University of Cambridge, United Kingdom"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research,Cambridge,United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"University of Cambridge, United Kingdom","institution_ids":["https://openalex.org/I241749"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014639509","display_name":"Sruti Srinivasa Ragavan","orcid":"https://orcid.org/0000-0001-6197-2194"},"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":"Sruti Srinivasa Ragavan","raw_affiliation_strings":["Microsoft Research,Cambridge,United Kingdom","Microsoft Research, Cambridge, United Kingdom"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research,Cambridge,United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102732604","display_name":"Jack M. Williams","orcid":"https://orcid.org/0000-0003-1925-7191"},"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":"Jack Williams","raw_affiliation_strings":["Microsoft Research,Cambridge,United Kingdom","Microsoft Research, Cambridge, United Kingdom"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research,Cambridge,United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"last","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"]},{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Andrew D. Gordon","raw_affiliation_strings":["Microsoft Research,Cambridge,United Kingdom","Microsoft Research, Cambridge, United Kingdom","University of Edinburgh, United Kingdom"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research,Cambridge,United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft Research, Cambridge, United Kingdom","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"University of Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.9039,"has_fulltext":false,"cited_by_count":10,"citation_normalized_percentile":{"value":0.86801153,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"11"},"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/T11704","display_name":"Mobile Crowdsensing and Crowdsourcing","score":0.9758999943733215,"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"}},{"id":"https://openalex.org/T10731","display_name":"Educational Games and Gamification","score":0.9742000102996826,"subfield":{"id":"https://openalex.org/subfields/3204","display_name":"Developmental and Educational Psychology"},"field":{"id":"https://openalex.org/fields/32","display_name":"Psychology"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7871793508529663},{"id":"https://openalex.org/keywords/hacker","display_name":"Hacker","score":0.6724820733070374},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.5716302394866943},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.5146980881690979},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.46533268690109253},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.440339058637619},{"id":"https://openalex.org/keywords/software-versioning","display_name":"Software versioning","score":0.4257057309150696},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.33234089612960815},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.320284366607666},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11767652630805969}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7871793508529663},{"id":"https://openalex.org/C86844869","wikidata":"https://www.wikidata.org/wiki/Q2798820","display_name":"Hacker","level":2,"score":0.6724820733070374},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.5716302394866943},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.5146980881690979},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.46533268690109253},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.440339058637619},{"id":"https://openalex.org/C198140048","wikidata":"https://www.wikidata.org/wiki/Q10859422","display_name":"Software versioning","level":3,"score":0.4257057309150696},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.33234089612960815},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.320284366607666},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11767652630805969},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","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},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C18903297","wikidata":"https://www.wikidata.org/wiki/Q7150","display_name":"Ecology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vl/hcc53370.2022.9833131","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vl/hcc53370.2022.9833131","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2022 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.800000011920929,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W80893987","https://openalex.org/W969178593","https://openalex.org/W1492324553","https://openalex.org/W1540823594","https://openalex.org/W1567073561","https://openalex.org/W1579695396","https://openalex.org/W1594912681","https://openalex.org/W1842410071","https://openalex.org/W1899639145","https://openalex.org/W1944688181","https://openalex.org/W1969768303","https://openalex.org/W1979290264","https://openalex.org/W1981425990","https://openalex.org/W1985749074","https://openalex.org/W1996063403","https://openalex.org/W1996473305","https://openalex.org/W2034880908","https://openalex.org/W2048713687","https://openalex.org/W2060404275","https://openalex.org/W2064189581","https://openalex.org/W2075173534","https://openalex.org/W2075984358","https://openalex.org/W2078045516","https://openalex.org/W2093495548","https://openalex.org/W2094647106","https://openalex.org/W2107150807","https://openalex.org/W2138720844","https://openalex.org/W2144849164","https://openalex.org/W2160945247","https://openalex.org/W2197696765","https://openalex.org/W2313158369","https://openalex.org/W2323803659","https://openalex.org/W2339183141","https://openalex.org/W2404721232","https://openalex.org/W2405896853","https://openalex.org/W2770826549","https://openalex.org/W2795742133","https://openalex.org/W2796239588","https://openalex.org/W2898211431","https://openalex.org/W2907069560","https://openalex.org/W2955133185","https://openalex.org/W3016513390","https://openalex.org/W3017863658","https://openalex.org/W3022461789","https://openalex.org/W3111869873","https://openalex.org/W4224994457","https://openalex.org/W4230392236","https://openalex.org/W4237412827","https://openalex.org/W4281564584","https://openalex.org/W6640545326","https://openalex.org/W6680513227","https://openalex.org/W6765316126"],"related_works":["https://openalex.org/W2921504876","https://openalex.org/W1982580243","https://openalex.org/W2183730421","https://openalex.org/W2551868243","https://openalex.org/W2348153269","https://openalex.org/W4205613068","https://openalex.org/W4286284259","https://openalex.org/W1507118973","https://openalex.org/W2363979337","https://openalex.org/W4316194496"],"abstract_inverted_index":{"The":[0],"value":[1],"of":[2,38,100],"computational":[3,58],"abstractions":[4,59],"to":[5,14,24,74],"non-expert":[6],"end-user":[7],"programmers":[8],"is":[9],"contentious.":[10],"We":[11,55,95],"study":[12],"reactions":[13],"the":[15,30,44,98],"lambda":[16,101],"function":[17],"in":[18,84,88],"Microsoft":[19,50],"Excel,":[20],"which":[21],"enables":[22],"users":[23,68,120],"define":[25],"their":[26],"own":[27],"functions":[28],"using":[29],"spreadsheet":[31,119],"formula":[32,89],"language,":[33],"through":[34],"a":[35],"thematic":[36],"analysis":[37],"nearly":[39],"2,700":[40],"comments":[41],"posted":[42],"on":[43],"Reddit,":[45],"Hacker":[46],"News,":[47],"YouTube,":[48],"and":[49,65,71,77,82,93,117],"Tech":[51],"Community":[52],"online":[53],"forums.":[54],"find":[56,96],"that":[57,67,78,97],"are":[60,80,108],"viewed":[61],"both":[62],"as":[63,87,123],"helpful":[64],"harmful,":[66],"encounter":[69],"learning":[70],"understanding":[72],"barriers":[73],"applying":[75],"them,":[76],"there":[79],"deficiencies":[81],"opportunities":[83],"tooling":[85],"such":[86],"editing,":[90],"versioning,":[91],"reuse":[92],"sharing.":[94],"introduction":[99],"prompts":[102],"new":[103],"debate":[104],"around":[105],"whether":[106,110,118],"spreadsheets":[107],"code,":[109],"writing":[111],"formulas":[112],"can":[113],"be":[114],"considered":[115],"programming,":[116],"identify":[121],"themselves":[122],"programmers.":[124]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}