{"id":"https://openalex.org/W2769425229","doi":"https://doi.org/10.1109/vlhcc.2017.8103463","title":"Spreadsheet practices and challenges in a large multinational conglomerate","display_name":"Spreadsheet practices and challenges in a large multinational conglomerate","publication_year":2017,"publication_date":"2017-10-01","ids":{"openalex":"https://openalex.org/W2769425229","doi":"https://doi.org/10.1109/vlhcc.2017.8103463","mag":"2769425229"},"language":"en","primary_location":{"id":"doi:10.1109/vlhcc.2017.8103463","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2017.8103463","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"},"type":"article","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/A5020005323","display_name":"Justin Smith","orcid":"https://orcid.org/0000-0001-6987-5196"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Justin Smith","raw_affiliation_strings":["North Carolina State University, Raleigh, North Carolina, USA"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, North Carolina, USA","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015507948","display_name":"Justin Middleton","orcid":"https://orcid.org/0009-0008-7373-5354"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Justin A. Middleton","raw_affiliation_strings":["North Carolina State University, Raleigh, North Carolina, USA"],"affiliations":[{"raw_affiliation_string":"North Carolina State University, Raleigh, North Carolina, USA","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5051151566","display_name":"Nicholas A. Kraft","orcid":"https://orcid.org/0000-0002-7960-766X"},"institutions":[{"id":"https://openalex.org/I2948539688","display_name":"AbbVie (United States)","ror":"https://ror.org/02g5p4n58","country_code":"US","type":"company","lineage":["https://openalex.org/I2948539688"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nicholas A. Kraft","raw_affiliation_strings":["ABB Corporate Research, Raleigh, North Carolina, USA"],"affiliations":[{"raw_affiliation_string":"ABB Corporate Research, Raleigh, North Carolina, USA","institution_ids":["https://openalex.org/I2948539688"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5020005323"],"corresponding_institution_ids":["https://openalex.org/I137902535"],"apc_list":null,"apc_paid":null,"fwci":0.3524,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.66865672,"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":"155","last_page":"163"},"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/T12238","display_name":"Green IT and Sustainability","score":0.979200005531311,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.9692999720573425,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/multinational-corporation","display_name":"Multinational corporation","score":0.8311525583267212},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5662686824798584},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.5463848114013672},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5402803421020508},{"id":"https://openalex.org/keywords/coding","display_name":"Coding (social sciences)","score":0.540077805519104},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.480910062789917},{"id":"https://openalex.org/keywords/best-practice","display_name":"Best practice","score":0.4794579744338989},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.4490504860877991},{"id":"https://openalex.org/keywords/survey-data-collection","display_name":"Survey data collection","score":0.43163424730300903},{"id":"https://openalex.org/keywords/qualitative-property","display_name":"Qualitative property","score":0.4292852282524109},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.2515507638454437},{"id":"https://openalex.org/keywords/political-science","display_name":"Political science","score":0.13531091809272766},{"id":"https://openalex.org/keywords/sociology","display_name":"Sociology","score":0.11387494206428528}],"concepts":[{"id":"https://openalex.org/C158016649","wikidata":"https://www.wikidata.org/wiki/Q161726","display_name":"Multinational corporation","level":2,"score":0.8311525583267212},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5662686824798584},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.5463848114013672},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5402803421020508},{"id":"https://openalex.org/C179518139","wikidata":"https://www.wikidata.org/wiki/Q5140297","display_name":"Coding (social sciences)","level":2,"score":0.540077805519104},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.480910062789917},{"id":"https://openalex.org/C184356942","wikidata":"https://www.wikidata.org/wiki/Q830382","display_name":"Best practice","level":2,"score":0.4794579744338989},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.4490504860877991},{"id":"https://openalex.org/C198477413","wikidata":"https://www.wikidata.org/wiki/Q7647069","display_name":"Survey data collection","level":2,"score":0.43163424730300903},{"id":"https://openalex.org/C87156501","wikidata":"https://www.wikidata.org/wiki/Q7268708","display_name":"Qualitative property","level":2,"score":0.4292852282524109},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.2515507638454437},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.13531091809272766},{"id":"https://openalex.org/C144024400","wikidata":"https://www.wikidata.org/wiki/Q21201","display_name":"Sociology","level":0,"score":0.11387494206428528},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"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/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C36289849","wikidata":"https://www.wikidata.org/wiki/Q34749","display_name":"Social science","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/vlhcc.2017.8103463","is_oa":false,"landing_page_url":"https://doi.org/10.1109/vlhcc.2017.8103463","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2017 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":43,"referenced_works":["https://openalex.org/W161484876","https://openalex.org/W194998427","https://openalex.org/W1497588375","https://openalex.org/W1504065802","https://openalex.org/W1540823594","https://openalex.org/W1575549743","https://openalex.org/W1808011207","https://openalex.org/W1960620318","https://openalex.org/W1974307657","https://openalex.org/W1990050100","https://openalex.org/W1991369112","https://openalex.org/W2010329982","https://openalex.org/W2046652934","https://openalex.org/W2052296870","https://openalex.org/W2058797051","https://openalex.org/W2091027230","https://openalex.org/W2093495548","https://openalex.org/W2098544808","https://openalex.org/W2103700531","https://openalex.org/W2106646204","https://openalex.org/W2112338634","https://openalex.org/W2125287837","https://openalex.org/W2131932522","https://openalex.org/W2146691185","https://openalex.org/W2148071752","https://openalex.org/W2161047290","https://openalex.org/W2163004671","https://openalex.org/W2167514255","https://openalex.org/W2169917840","https://openalex.org/W2267941160","https://openalex.org/W2329395632","https://openalex.org/W2404721232","https://openalex.org/W2405408229","https://openalex.org/W2547709956","https://openalex.org/W2558145357","https://openalex.org/W2601734385","https://openalex.org/W3143739033","https://openalex.org/W4234795076","https://openalex.org/W4300427735","https://openalex.org/W6607942509","https://openalex.org/W6632301955","https://openalex.org/W6640861262","https://openalex.org/W6693381668"],"related_works":["https://openalex.org/W2002383399","https://openalex.org/W2085929198","https://openalex.org/W560905060","https://openalex.org/W3146347817","https://openalex.org/W4248941464","https://openalex.org/W2348308266","https://openalex.org/W2150379823","https://openalex.org/W3123142427","https://openalex.org/W3009841415","https://openalex.org/W4296737668"],"abstract_inverted_index":{"Spreadsheets":[0],"are":[1,56],"ubiquitous.":[2],"Thus,":[3],"it":[4],"is":[5],"important":[6],"to":[7,40,80,99,109],"understand":[8,19],"the":[9,42,103,124],"challenges":[10,43,78,97,126],"faced":[11],"by":[12],"spreadsheet":[13,90,128],"users":[14],"in":[15,52,60,122],"practice.":[16],"To":[17],"better":[18],"these":[20,111],"challenges,":[21],"we":[22],"surveyed":[23],"ABB":[24],"employees":[25],"and":[26,68,88,119],"then":[27],"interviewed":[28],"a":[29,36],"cross-section":[30],"of":[31],"survey":[32,47],"respondents.":[33],"We":[34,105],"used":[35],"two-phase":[37],"coding":[38],"process":[39],"classify":[41],"they":[44],"described.":[45],"Our":[46,63,113],"findings":[48],"demonstrate":[49],"that":[50],"practices":[51,59],"our":[53],"single-company":[54],"setting":[55],"consistent":[57],"with":[58],"broader":[61],"settings.":[62],"interviews":[64],"revealed":[65,96],"both":[66],"individual":[67,73],"organizational":[69],"challenges.":[70,112],"For":[71],"instance,":[72],"participants":[74],"described":[75],"data":[76,82],"pipeline":[77],"related":[79],"importing":[81],"from":[83],"external":[84],"sources":[85],"or":[86],"storing":[87],"archiving":[89],"data.":[91],"Further,":[92],"participants'":[93],"collective":[94],"responses":[95],"pertaining":[98],"knowledge":[100],"distribution":[101],"within":[102],"organization.":[104],"outline":[106],"possible":[107],"interventions":[108],"address":[110],"results":[114],"will":[115],"help":[116],"guide":[117],"researchers":[118],"tool":[120],"designers":[121],"addressing":[123],"practical":[125],"facing":[127],"users.":[129]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-14T06:02:45.956762","created_date":"2025-10-10T00:00:00"}