{"id":"https://openalex.org/W278689687","doi":null,"title":"Reducing Spreadsheet Errors","display_name":"Reducing Spreadsheet Errors","alternate_titles":[],"publication_year":2009,"publication_date":"2009-09-01","ids":{"openalex":"https://openalex.org/W278689687","mag":"278689687"},"language":"en","primary_location":{"id":"mag:278689687","doi":null,"is_oa":false,"landing_page_url":"https://apps.dtic.mil/dtic/tr/fulltext/u2/a508437.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},"parent_works":[],"lineage":["https://openalex.org/W278689687"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5025834825","display_name":"S. Kyle McKay","orcid":"https://orcid.org/0000-0003-2703-3841","observed_orcids":["https://orcid.org/0000-0003-2703-3841"]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"S. Kyle McKay","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5025834825"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":1,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"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.9994999766349792,"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.9994999766349792,"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":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/T11734","display_name":"Decision Support System Applications","score":0.0,"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/spreadsheet-errors","display_name":"spreadsheet errors","score":0.9919999837875366},{"id":"https://openalex.org/keywords/error-reduction","display_name":"error reduction","score":0.8019999861717224},{"id":"https://openalex.org/keywords/spreadsheet-modeling","display_name":"spreadsheet modeling","score":0.7509999871253967},{"id":"https://openalex.org/keywords/numerical-computation","display_name":"numerical computation","score":0.5320000052452087},{"id":"https://openalex.org/keywords/non-expert-users","display_name":"non-expert users","score":0.699999988079071},{"id":"https://openalex.org/keywords/quality-control","display_name":"quality control","score":0.8820000290870667}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.791450023651123},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6031509637832642},{"id":"https://openalex.org/C63882131","wikidata":"https://www.wikidata.org/wiki/Q17122954","display_name":"Strengths and weaknesses","level":2,"score":0.5075763463973999},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4664791226387024},{"id":"https://openalex.org/C179799912","wikidata":"https://www.wikidata.org/wiki/Q205084","display_name":"Computational complexity theory","level":2,"score":0.45772820711135864},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.35864147543907166},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2573317885398865},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.11539861559867859},{"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}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:278689687","doi":null,"is_oa":false,"landing_page_url":"https://apps.dtic.mil/dtic/tr/fulltext/u2/a508437.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":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W93717786","https://openalex.org/W563010272","https://openalex.org/W1987842730","https://openalex.org/W2030470921","https://openalex.org/W2105237266","https://openalex.org/W2105860581","https://openalex.org/W2112338634","https://openalex.org/W2133487099","https://openalex.org/W2138086333","https://openalex.org/W2150704968","https://openalex.org/W2160322876","https://openalex.org/W2170810033","https://openalex.org/W2786957354"],"related_works":["https://openalex.org/W16688517","https://openalex.org/W1514269045","https://openalex.org/W7099178134","https://openalex.org/W1517575644","https://openalex.org/W7096520433","https://openalex.org/W937552413","https://openalex.org/W2030153680","https://openalex.org/W1677831939","https://openalex.org/W2538785426","https://openalex.org/W1837419786"],"abstract_inverted_index":{"Increasing":[0],"computational":[1,22,51],"power":[2,36],"and":[3,67,77],"memory":[4],"capacity":[5],"in":[6,11],"desktop":[7],"computers":[8],"has":[9],"resulted":[10],"access":[12],"to":[13,18,30,38,48,63],"numerical":[14,84],"techniques":[15],"previously":[16],"unavailable":[17],"many":[19,26],"users.":[20],"Although":[21],"capabilities":[23],"have":[24],"increased,":[25],"users":[27,45],"are":[28],"unable":[29],"take":[31],"full":[32],"advantage":[33],"of":[34,69],"this":[35],"due":[37,62],"limited":[39],"programming":[40],"expertise.":[41],"Spreadsheets":[42],"offer":[43],"these":[44],"a":[46],"means":[47],"capitalize":[49],"upon":[50],"potential":[52],"without":[53],"extensive":[54],"training,":[55],"though":[56],"spreadsheet":[57],"models":[58],"can":[59],"confer":[60],"risks":[61],"high":[64],"error":[65],"rates":[66],"lack":[68],"quality":[70],"control.":[71],"Table":[72],"1":[73],"presents":[74],"several":[75],"strengths":[76],"weaknesses":[78],"associated":[79],"with":[80],"using":[81],"spreadsheets":[82],"as":[83],"tools":[85],"for":[86],"the":[87],"masses.":[88]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W278689687","counts_by_year":[{"year":2022,"cited_by_count":1}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
