{"id":"https://openalex.org/W1481671871","doi":"https://doi.org/10.1023/a:1016631003750","title":"Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae","display_name":"Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae","publication_year":2001,"publication_date":"2001-06-01","ids":{"openalex":"https://openalex.org/W1481671871","doi":"https://doi.org/10.1023/a:1016631003750","mag":"1481671871"},"language":"en","primary_location":{"id":"doi:10.1023/a:1016631003750","is_oa":false,"landing_page_url":"https://doi.org/10.1023/a:1016631003750","pdf_url":null,"source":{"id":"https://openalex.org/S7504070","display_name":"Software Quality Journal","issn_l":"0963-9314","issn":["0963-9314","1573-1367"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software Quality Journal","raw_type":"journal-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/A5000532994","display_name":"David R. Chadwick","orcid":"https://orcid.org/0000-0002-8479-8157"},"institutions":[{"id":"https://openalex.org/I55060895","display_name":"University of Greenwich","ror":"https://ror.org/00bmj0a71","country_code":"GB","type":"education","lineage":["https://openalex.org/I55060895"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"David Chadwick","raw_affiliation_strings":["Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK D.R.Chadwick@gre.ac.uk#TAB#"],"affiliations":[{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","institution_ids":["https://openalex.org/I55060895"]},{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK D.R.Chadwick@gre.ac.uk#TAB#","institution_ids":["https://openalex.org/I55060895"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106134404","display_name":"Brian Knight","orcid":"https://orcid.org/0000-0001-8049-4749"},"institutions":[{"id":"https://openalex.org/I55060895","display_name":"University of Greenwich","ror":"https://ror.org/00bmj0a71","country_code":"GB","type":"education","lineage":["https://openalex.org/I55060895"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Brian Knight","raw_affiliation_strings":["Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK#TAB#"],"affiliations":[{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","institution_ids":["https://openalex.org/I55060895"]},{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK#TAB#","institution_ids":["https://openalex.org/I55060895"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084151605","display_name":"Kamalasen Rajalingham","orcid":null},"institutions":[{"id":"https://openalex.org/I55060895","display_name":"University of Greenwich","ror":"https://ror.org/00bmj0a71","country_code":"GB","type":"education","lineage":["https://openalex.org/I55060895"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Kamalasen Rajalingham","raw_affiliation_strings":["Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK#TAB#"],"affiliations":[{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK","institution_ids":["https://openalex.org/I55060895"]},{"raw_affiliation_string":"Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK#TAB#","institution_ids":["https://openalex.org/I55060895"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5000532994"],"corresponding_institution_ids":["https://openalex.org/I55060895"],"apc_list":{"value":2390,"currency":"EUR","value_usd":2990},"apc_paid":null,"fwci":1.2151,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.8263236,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"9","issue":"2","first_page":"133","last_page":"143"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":1.0,"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":1.0,"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.9556000232696533,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/copying","display_name":"Copying","score":0.6525506973266602},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6274254322052002},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5103718638420105},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.47311875224113464},{"id":"https://openalex.org/keywords/control","display_name":"Control (management)","score":0.4361175298690796},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.4324498176574707},{"id":"https://openalex.org/keywords/risk-analysis","display_name":"Risk analysis (engineering)","score":0.3236249089241028},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.29931455850601196},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1039285957813263}],"concepts":[{"id":"https://openalex.org/C2779151265","wikidata":"https://www.wikidata.org/wiki/Q1156791","display_name":"Copying","level":2,"score":0.6525506973266602},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6274254322052002},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5103718638420105},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.47311875224113464},{"id":"https://openalex.org/C2775924081","wikidata":"https://www.wikidata.org/wiki/Q55608371","display_name":"Control (management)","level":2,"score":0.4361175298690796},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4324498176574707},{"id":"https://openalex.org/C112930515","wikidata":"https://www.wikidata.org/wiki/Q4389547","display_name":"Risk analysis (engineering)","level":1,"score":0.3236249089241028},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.29931455850601196},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1039285957813263},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","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/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","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/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1023/a:1016631003750","is_oa":false,"landing_page_url":"https://doi.org/10.1023/a:1016631003750","pdf_url":null,"source":{"id":"https://openalex.org/S7504070","display_name":"Software Quality Journal","issn_l":"0963-9314","issn":["0963-9314","1573-1367"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Software Quality Journal","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.41999998688697815,"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":4,"referenced_works":["https://openalex.org/W1517370497","https://openalex.org/W1548532775","https://openalex.org/W2038436770","https://openalex.org/W2093987194"],"related_works":["https://openalex.org/W2384667405","https://openalex.org/W2389266787","https://openalex.org/W2363885542","https://openalex.org/W2387206255","https://openalex.org/W2355570285","https://openalex.org/W2364958354","https://openalex.org/W2352797113","https://openalex.org/W2372137583","https://openalex.org/W2374872591","https://openalex.org/W1548050717"],"abstract_inverted_index":null,"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2016-06-24T00:00:00"}